From c7c941bcf6d2d4fec81d9f9c37c53421e474623b Mon Sep 17 00:00:00 2001
From: Refik Hadzialic
Date: Tue, 19 Jul 2011 14:03:20 +0200
Subject: New database file

---
 Database/localhost.sql | 28 +++++++++++++++++++++++-----
 1 file changed, 23 insertions(+), 5 deletions(-)

(limited to 'Database/localhost.sql')

diff --git a/Database/localhost.sql b/Database/localhost.sql
index e656946..ed64338 100644
--- a/Database/localhost.sql
+++ b/Database/localhost.sql
@@ -3,7 +3,7 @@
 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Jul 06, 2011 at 06:24 PM
+-- Generation Time: Jul 19, 2011 at 02:01 PM
 -- Server version: 5.1.54
 -- PHP Version: 5.3.5-1ubuntu7.2
 
@@ -24,16 +24,19 @@ USE `gsmselftesting`;
 -- --------------------------------------------------------
 
 --
--- Table structure for table `DeviceAddress`
+-- Table structure for table `DeviceAddressTable`
 --
 
-CREATE TABLE IF NOT EXISTS `DeviceAddress` (
+CREATE TABLE IF NOT EXISTS `DeviceAddressTable` (
   `deviceName` varchar(10) NOT NULL,
   `deviceIP` varchar(60) NOT NULL,
   `lastChange` datetime NOT NULL,
   PRIMARY KEY (`deviceName`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+--
+-- Dumping data for table `DeviceAddressTable`
+--
 
 
 -- --------------------------------------------------------
@@ -69,6 +72,10 @@ CREATE TABLE IF NOT EXISTS `PingResultTable` (
   PRIMARY KEY (`taskNo`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+--
+-- Dumping data for table `PingResultTable`
+--
+
 
 -- --------------------------------------------------------
 
@@ -82,6 +89,9 @@ CREATE TABLE IF NOT EXISTS `ResultTable` (
   PRIMARY KEY (`taskID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+--
+-- Dumping data for table `ResultTable`
+--
 
 
 -- --------------------------------------------------------
@@ -91,14 +101,18 @@ CREATE TABLE IF NOT EXISTS `ResultTable` (
 --
 
 CREATE TABLE IF NOT EXISTS `TaskTable` (
-  `taskID` int(11) NOT NULL,
+  `taskID` int(11) NOT NULL AUTO_INCREMENT,
   `taskNo` int(11) NOT NULL,
   `from` varchar(10) NOT NULL,
   `to` varchar(10) NOT NULL,
   `status` int(2) NOT NULL,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   PRIMARY KEY (`taskID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `TaskTable`
+--
 
 
 -- --------------------------------------------------------
@@ -109,9 +123,13 @@ CREATE TABLE IF NOT EXISTS `TaskTable` (
 
 CREATE TABLE IF NOT EXISTS `TempTaskTable` (
   `taskID` int(11) NOT NULL,
+  `taskNo` int(11) NOT NULL,
   `from` varchar(10) NOT NULL,
   `to` varchar(10) NOT NULL,
   PRIMARY KEY (`taskID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+--
+-- Dumping data for table `TempTaskTable`
+--
 
-- 
cgit v1.2.3-55-g7522

