From ed9926b3265b2bb1a9b94b6a28a7864800b19424 Mon Sep 17 00:00:00 2001 From: triatmoko Date: Wed, 6 Jul 2011 18:28:40 +0200 Subject: edit some field. --- Database/localhost.sql | 55 ++++++++++++++++++++++++++++++++------------------ 1 file changed, 35 insertions(+), 20 deletions(-) (limited to 'Database/localhost.sql') diff --git a/Database/localhost.sql b/Database/localhost.sql index 0251e3c..a83e610 100644 --- a/Database/localhost.sql +++ b/Database/localhost.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Jul 04, 2011 at 07:58 PM +-- Generation Time: Jul 06, 2011 at 06:24 PM -- Server version: 5.1.54 -- PHP Version: 5.3.5-1ubuntu7.2 @@ -23,6 +23,23 @@ USE `gsmselftesting`; -- -------------------------------------------------------- +-- +-- Table structure for table `DeviceAddress` +-- + +CREATE TABLE IF NOT EXISTS `DeviceAddress` ( + `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 `DeviceAddress` +-- + +-- -------------------------------------------------------- + -- -- Table structure for table `ErrorCodeTable` -- @@ -45,13 +62,13 @@ CREATE TABLE IF NOT EXISTS `ErrorCodeTable` ( -- CREATE TABLE IF NOT EXISTS `PingResultTable` ( - `taskno` int(11) NOT NULL, - `sipserver` int(3) NOT NULL, - `sipgate` int(3) NOT NULL, - `locsip` int(3) NOT NULL, - `box1` int(3) NOT NULL, - `box2` int(3) NOT NULL, - PRIMARY KEY (`taskno`) + `taskNo` int(11) NOT NULL, + `sipServer` int(3) NOT NULL, + `sipGate` int(3) NOT NULL, + `sipLoc` int(3) NOT NULL, + `gsmBox1` int(3) NOT NULL, + `gsmBox2` int(3) NOT NULL, + PRIMARY KEY (`taskNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- @@ -66,16 +83,15 @@ CREATE TABLE IF NOT EXISTS `PingResultTable` ( -- CREATE TABLE IF NOT EXISTS `ResultTable` ( - `taskid` int(11) NOT NULL, + `taskID` int(11) NOT NULL, `result` int(3) NOT NULL, - PRIMARY KEY (`taskid`) + PRIMARY KEY (`taskID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ResultTable` -- - -- -------------------------------------------------------- -- @@ -83,20 +99,19 @@ CREATE TABLE IF NOT EXISTS `ResultTable` ( -- CREATE TABLE IF NOT EXISTS `TaskTable` ( - `taskid` int(11) NOT NULL, - `taskno` int(11) NOT NULL, + `taskID` int(11) NOT NULL, + `taskNo` int(11) NOT NULL, `from` varchar(10) NOT NULL, - `to` int(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; + PRIMARY KEY (`taskID`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `TaskTable` -- - -- -------------------------------------------------------- -- @@ -104,10 +119,10 @@ CREATE TABLE IF NOT EXISTS `TaskTable` ( -- CREATE TABLE IF NOT EXISTS `TempTaskTable` ( - `taskid` int(11) NOT NULL, + `taskID` int(11) NOT NULL, `from` varchar(10) NOT NULL, - `to` int(10) NOT NULL, - PRIMARY KEY (`taskid`) + `to` varchar(10) NOT NULL, + PRIMARY KEY (`taskID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- cgit v1.2.3-55-g7522