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') 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