summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authortriatmoko2011-07-04 17:00:39 +0200
committertriatmoko2011-07-04 17:00:39 +0200
commit01e709c252f48876be3ecdce654d36e8d855b50e (patch)
tree8269bc3bb1f7abfaafaf76b062fd6599fd696588 /Database
parentMaybe you guys can consider new algorithm. this controller use one function t... (diff)
downloadgsm-selftest-01e709c252f48876be3ecdce654d36e8d855b50e.tar.gz
gsm-selftest-01e709c252f48876be3ecdce654d36e8d855b50e.tar.xz
gsm-selftest-01e709c252f48876be3ecdce654d36e8d855b50e.zip
new database design.
Diffstat (limited to 'Database')
-rw-r--r--Database/localhost.sql254
1 files changed, 26 insertions, 228 deletions
diff --git a/Database/localhost.sql b/Database/localhost.sql
index 75aeef3..5cdd675 100644
--- a/Database/localhost.sql
+++ b/Database/localhost.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Generation Time: Jun 30, 2011 at 04:02 PM
+-- Generation Time: Jul 04, 2011 at 04:58 PM
-- Server version: 5.1.54
-- PHP Version: 5.3.5-1ubuntu7.2
@@ -24,207 +24,55 @@ USE `gsmselftesting`;
-- --------------------------------------------------------
--
--- Table structure for table `EplusTableResult`
+-- Table structure for table `ErrorCodeTable`
--
-CREATE TABLE IF NOT EXISTS `EplusTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `EplusTableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `LandlineTableResult`
---
-
-CREATE TABLE IF NOT EXISTS `LandlineTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `LandlineTableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `LocalSIPTableResult`
---
-
-CREATE TABLE IF NOT EXISTS `LocalSIPTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- `landline` int(4) NOT NULL,
- `otwo` int(4) NOT NULL,
- `vodaphone` int(4) NOT NULL,
- `tmobile` int(4) NOT NULL,
- `eplus` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `LocalSIPTableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `OtwoTableResult`
---
-
-CREATE TABLE IF NOT EXISTS `OtwoTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `OtwoTableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `PingResultTabel`
---
-
-CREATE TABLE IF NOT EXISTS `PingResultTabel` (
- `taskid` int(11) NOT NULL,
- `sipserver` varchar(1) NOT NULL,
- `sipgate` varchar(1) NOT NULL,
- `siplocal` varchar(1) NOT NULL,
- `btsbox1` varchar(1) NOT NULL,
- `btsbox2` varchar(1) NOT NULL,
- `btsbox3` varchar(1) NOT NULL,
- PRIMARY KEY (`taskid`)
+CREATE TABLE IF NOT EXISTS `ErrorCodeTable` (
+ `errorcode` int(4) NOT NULL,
+ `description` varchar(100) NOT NULL,
+ PRIMARY KEY (`errorcode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
--- Dumping data for table `PingResultTabel`
+-- Dumping data for table `ErrorCodeTable`
--
-- --------------------------------------------------------
--
--- Table structure for table `RZ1TableResult`
+-- Table structure for table `PingResultTable`
--
-CREATE TABLE IF NOT EXISTS `RZ1TableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- `localsip` int(4) NOT NULL,
- `landline` int(4) NOT NULL,
- `otwo` int(4) NOT NULL,
- `vodaphone` int(4) NOT NULL,
- `tmobile` int(4) NOT NULL,
- `eplus` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `RZ1TableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `RZ2TableResult`
---
-
-CREATE TABLE IF NOT EXISTS `RZ2TableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- `localsip` int(4) NOT NULL,
- `landline` int(4) NOT NULL,
- `otwo` int(4) NOT NULL,
- `vodaphone` int(4) NOT NULL,
- `tmobile` int(4) NOT NULL,
- `eplus` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `RZ2TableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `RZ3TableResult`
---
-
-CREATE TABLE IF NOT EXISTS `RZ3TableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `localsip` int(4) NOT NULL,
- `landline` int(4) NOT NULL,
- `otwo` int(4) NOT NULL,
- `vodaphone` int(4) NOT NULL,
- `tmobile` int(4) NOT NULL,
- `eplus` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
+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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
--- Dumping data for table `RZ3TableResult`
+-- Dumping data for table `PingResultTable`
--
-- --------------------------------------------------------
--
--- Table structure for table `SIPTableResult`
+-- Table structure for table `ResultTable`
--
-CREATE TABLE IF NOT EXISTS `SIPTableResult` (
+CREATE TABLE IF NOT EXISTS `ResultTable` (
`taskid` int(11) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- `localsip` int(4) NOT NULL,
- `landline` int(4) NOT NULL,
- `otwo` int(4) NOT NULL,
- `vodaphone` int(4) NOT NULL,
- `tmobile` int(4) NOT NULL,
- `eplus` int(4) NOT NULL,
+ `result` int(3) NOT NULL,
PRIMARY KEY (`taskid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
--- Dumping data for table `SIPTableResult`
+-- Dumping data for table `ResultTable`
--
@@ -236,21 +84,11 @@ CREATE TABLE IF NOT EXISTS `SIPTableResult` (
CREATE TABLE IF NOT EXISTS `TaskTable` (
`taskid` int(11) NOT NULL,
- `sip2gsmrz` int(1) NOT NULL,
- `sip2localsip` int(1) NOT NULL,
- `sip2landline` int(1) NOT NULL,
- `sip2extgsm` int(1) NOT NULL,
- `gsmrz2gsmrz` int(1) NOT NULL,
- `gsmrz2extgsm` int(1) NOT NULL,
- `gsmrz2sip` int(1) NOT NULL,
- `gsmrz2landline` int(1) NOT NULL,
- `gsmrz2localsip` int(1) NOT NULL,
- `extgsm2sip` int(1) NOT NULL,
- `extgsm2gsmrz` int(1) NOT NULL,
- `landline2gsmrz` int(1) NOT NULL,
- `landline2sip` int(1) NOT NULL,
- `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `status` varchar(1) NOT NULL,
+ `taskno` int(11) NOT NULL,
+ `from` varchar(10) NOT NULL,
+ `to` int(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;
@@ -258,43 +96,3 @@ CREATE TABLE IF NOT EXISTS `TaskTable` (
-- Dumping data for table `TaskTable`
--
-
--- --------------------------------------------------------
-
---
--- Table structure for table `TmobileTableResult`
---
-
-CREATE TABLE IF NOT EXISTS `TmobileTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `TmobileTableResult`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `VodaphoneTableResult`
---
-
-CREATE TABLE IF NOT EXISTS `VodaphoneTableResult` (
- `taskid` int(11) NOT NULL,
- `sip` int(4) NOT NULL,
- `rz1` int(4) NOT NULL,
- `rz2` int(4) NOT NULL,
- `rz3` int(4) NOT NULL,
- PRIMARY KEY (`taskid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `VodaphoneTableResult`
---
-