summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorRefik Hadzialic2011-07-19 14:03:20 +0200
committerRefik Hadzialic2011-07-19 14:03:20 +0200
commitc7c941bcf6d2d4fec81d9f9c37c53421e474623b (patch)
treec462d4b90e4d37faa4c37a34456f00f896788d28 /Database
parentfix bug on localsip part. (diff)
downloadgsm-selftest-c7c941bcf6d2d4fec81d9f9c37c53421e474623b.tar.gz
gsm-selftest-c7c941bcf6d2d4fec81d9f9c37c53421e474623b.tar.xz
gsm-selftest-c7c941bcf6d2d4fec81d9f9c37c53421e474623b.zip
New database file
Diffstat (limited to 'Database')
-rw-r--r--Database/localhost.sql28
1 files changed, 23 insertions, 5 deletions
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`
+--