From 01e709c252f48876be3ecdce654d36e8d855b50e Mon Sep 17 00:00:00 2001 From: triatmoko Date: Mon, 4 Jul 2011 17:00:39 +0200 Subject: new database design. --- Database/localhost.sql | 254 +++++-------------------------------------------- 1 file changed, 26 insertions(+), 228 deletions(-) (limited to 'Database') 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` --- - -- cgit v1.2.3-55-g7522