From 7a02ee41a959f605be26cd69e9bd7f8d1c91ce8f Mon Sep 17 00:00:00 2001 From: triatmoko Date: Thu, 30 Jun 2011 16:04:54 +0200 Subject: the new design of our database. just import it to your database. will produce new database include the table. --- Database/localhost.sql | 1034 ++++++------------------------------------------ 1 file changed, 126 insertions(+), 908 deletions(-) (limited to 'Database') diff --git a/Database/localhost.sql b/Database/localhost.sql index f6da83e..75aeef3 100644 --- a/Database/localhost.sql +++ b/Database/localhost.sql @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Jun 25, 2011 at 02:14 AM +-- Generation Time: Jun 30, 2011 at 04:02 PM -- Server version: 5.1.54 -- PHP Version: 5.3.5-1ubuntu7.2 @@ -16,1067 +16,285 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET NAMES utf8 */; -- --- Database: `GSMSelfTesting` +-- Database: `gsmselftesting` -- -CREATE DATABASE `GSMSelfTesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; -USE `GSMSelfTesting`; +CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; +USE `gsmselftesting`; -- -------------------------------------------------------- -- --- 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`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `PingResultTabel` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `TaskTable` --- - -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, - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `TaskTable` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `eplus2gsm1rz` --- - -CREATE TABLE IF NOT EXISTS `eplus2gsm1rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `eplus2gsm1rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `eplus2gsm2rz` --- - -CREATE TABLE IF NOT EXISTS `eplus2gsm2rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `eplus2gsm2rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `eplus2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `eplus2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `eplus2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `eplus2sip` --- - -CREATE TABLE IF NOT EXISTS `eplus2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `eplus2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2eplus` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2eplus` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2eplus` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2gsm2rz` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2gsm2rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2gsm2rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2landline` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2landline` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2landline` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2localsip` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2localsip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2localsip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2otwo` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2otwo` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2otwo` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2sip` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2tmobile` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2tmobile` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2tmobile` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm1rz2vodaphone` --- - -CREATE TABLE IF NOT EXISTS `gsm1rz2vodaphone` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm1rz2vodaphone` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2eplus` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2eplus` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2eplus` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2landline` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2landline` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2landline` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2localsip` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2localsip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2localsip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2otwo` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2otwo` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2otwo` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2sip` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2tmobile` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2tmobile` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2tmobile` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm2rz2vodaphone` --- - -CREATE TABLE IF NOT EXISTS `gsm2rz2vodaphone` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm2rz2vodaphone` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2eplus` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2eplus` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2eplus` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2landline` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2landline` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2landline` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2localsip` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2localsip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2localsip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2otwo` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2otwo` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2otwo` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2sip` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2tmobile` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2tmobile` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2tmobile` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `gsm3rz2vodaphone` --- - -CREATE TABLE IF NOT EXISTS `gsm3rz2vodaphone` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `gsm3rz2vodaphone` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `landline2gsm1rz` --- - -CREATE TABLE IF NOT EXISTS `landline2gsm1rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `landline2gsm1rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `landline2gsm2rz` --- - -CREATE TABLE IF NOT EXISTS `landline2gsm2rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `landline2gsm2rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `landline2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `landline2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `landline2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `landline2sip` --- - -CREATE TABLE IF NOT EXISTS `landline2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `landline2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `otwo2gsm1rz` --- - -CREATE TABLE IF NOT EXISTS `otwo2gsm1rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `otwo2gsm1rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `otwo2gsm2rz` --- - -CREATE TABLE IF NOT EXISTS `otwo2gsm2rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `otwo2gsm2rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `otwo2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `otwo2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `otwo2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `otwo2sip` --- - -CREATE TABLE IF NOT EXISTS `otwo2sip` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `otwo2sip` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2eplus` --- - -CREATE TABLE IF NOT EXISTS `sip2eplus` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sip2eplus` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2gsm1rz` --- - -CREATE TABLE IF NOT EXISTS `sip2gsm1rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sip2gsm1rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2gsm2rz` --- - -CREATE TABLE IF NOT EXISTS `sip2gsm2rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sip2gsm2rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2gsm3rz` --- - -CREATE TABLE IF NOT EXISTS `sip2gsm3rz` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sip2gsm3rz` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2landline` --- - -CREATE TABLE IF NOT EXISTS `sip2landline` ( - `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', - PRIMARY KEY (`taskid`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `sip2landline` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `sip2localsip` +-- Table structure for table `EplusTableResult` -- -CREATE TABLE IF NOT EXISTS `sip2localsip` ( +CREATE TABLE IF NOT EXISTS `EplusTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `sip2localsip` +-- Dumping data for table `EplusTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `sip2otwo` +-- Table structure for table `LandlineTableResult` -- -CREATE TABLE IF NOT EXISTS `sip2otwo` ( +CREATE TABLE IF NOT EXISTS `LandlineTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `sip2otwo` +-- Dumping data for table `LandlineTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `sip2tmobile` +-- Table structure for table `LocalSIPTableResult` -- -CREATE TABLE IF NOT EXISTS `sip2tmobile` ( +CREATE TABLE IF NOT EXISTS `LocalSIPTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `sip2tmobile` +-- Dumping data for table `LocalSIPTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `sip2vodaphone` +-- Table structure for table `OtwoTableResult` -- -CREATE TABLE IF NOT EXISTS `sip2vodaphone` ( +CREATE TABLE IF NOT EXISTS `OtwoTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `sip2vodaphone` +-- Dumping data for table `OtwoTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `tmobile2gsm1rz` +-- Table structure for table `PingResultTabel` -- -CREATE TABLE IF NOT EXISTS `tmobile2gsm1rz` ( +CREATE TABLE IF NOT EXISTS `PingResultTabel` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --- Dumping data for table `tmobile2gsm1rz` +-- Dumping data for table `PingResultTabel` -- -- -------------------------------------------------------- -- --- Table structure for table `tmobile2gsm2rz` +-- Table structure for table `RZ1TableResult` -- -CREATE TABLE IF NOT EXISTS `tmobile2gsm2rz` ( +CREATE TABLE IF NOT EXISTS `RZ1TableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `tmobile2gsm2rz` +-- Dumping data for table `RZ1TableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `tmobile2gsm3rz` +-- Table structure for table `RZ2TableResult` -- -CREATE TABLE IF NOT EXISTS `tmobile2gsm3rz` ( +CREATE TABLE IF NOT EXISTS `RZ2TableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `tmobile2gsm3rz` +-- Dumping data for table `RZ2TableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `tmobile2sip` +-- Table structure for table `RZ3TableResult` -- -CREATE TABLE IF NOT EXISTS `tmobile2sip` ( +CREATE TABLE IF NOT EXISTS `RZ3TableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --- Dumping data for table `tmobile2sip` +-- Dumping data for table `RZ3TableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `vodaphone2gsm1rz` +-- Table structure for table `SIPTableResult` -- -CREATE TABLE IF NOT EXISTS `vodaphone2gsm1rz` ( +CREATE TABLE IF NOT EXISTS `SIPTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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, PRIMARY KEY (`taskid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --- Dumping data for table `vodaphone2gsm1rz` +-- Dumping data for table `SIPTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `vodaphone2gsm2rz` +-- Table structure for table `TaskTable` -- -CREATE TABLE IF NOT EXISTS `vodaphone2gsm2rz` ( +CREATE TABLE IF NOT EXISTS `TaskTable` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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, PRIMARY KEY (`taskid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- --- Dumping data for table `vodaphone2gsm2rz` +-- Dumping data for table `TaskTable` -- -- -------------------------------------------------------- -- --- Table structure for table `vodaphone2gsm3rz` +-- Table structure for table `TmobileTableResult` -- -CREATE TABLE IF NOT EXISTS `vodaphone2gsm3rz` ( +CREATE TABLE IF NOT EXISTS `TmobileTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `vodaphone2gsm3rz` +-- Dumping data for table `TmobileTableResult` -- -- -------------------------------------------------------- -- --- Table structure for table `vodaphone2sip` +-- Table structure for table `VodaphoneTableResult` -- -CREATE TABLE IF NOT EXISTS `vodaphone2sip` ( +CREATE TABLE IF NOT EXISTS `VodaphoneTableResult` ( `taskid` int(11) NOT NULL, - `status` int(1) NOT NULL, - `reason` varchar(4) NOT NULL COMMENT 'error code', - `comment` varchar(50) NOT NULL COMMENT 'additional information', + `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 `vodaphone2sip` +-- Dumping data for table `VodaphoneTableResult` -- -- cgit v1.2.3-55-g7522