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

