summaryrefslogtreecommitdiffstats
path: root/Database/localhost.sql
diff options
context:
space:
mode:
Diffstat (limited to 'Database/localhost.sql')
-rw-r--r--Database/localhost.sql55
1 files changed, 35 insertions, 20 deletions
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
@@ -24,6 +24,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;
--