summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authortriatmoko2011-07-06 18:28:40 +0200
committertriatmoko2011-07-06 18:28:40 +0200
commited9926b3265b2bb1a9b94b6a28a7864800b19424 (patch)
treed878c54efb3b02c23a6d4f6e0322924b0012583b /Database
parentSIP FINAL HANDLER!!! (diff)
downloadgsm-selftest-ed9926b3265b2bb1a9b94b6a28a7864800b19424.tar.gz
gsm-selftest-ed9926b3265b2bb1a9b94b6a28a7864800b19424.tar.xz
gsm-selftest-ed9926b3265b2bb1a9b94b6a28a7864800b19424.zip
edit some field.
Diffstat (limited to 'Database')
-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;
--