summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authortriatmoko2011-06-30 16:04:54 +0200
committertriatmoko2011-06-30 16:04:54 +0200
commit7a02ee41a959f605be26cd69e9bd7f8d1c91ce8f (patch)
tree7f6f86e6747ae80eb2859527a460879ae34b52d4 /Database
parentput last version of SIP Handler which is working with our socket communication. (diff)
downloadgsm-selftest-7a02ee41a959f605be26cd69e9bd7f8d1c91ce8f.tar.gz
gsm-selftest-7a02ee41a959f605be26cd69e9bd7f8d1c91ce8f.tar.xz
gsm-selftest-7a02ee41a959f605be26cd69e9bd7f8d1c91ce8f.zip
the new design of our database. just import it to your database. will produce new database include the table.
Diffstat (limited to 'Database')
-rw-r--r--Database/localhost.sql1034
1 files changed, 126 insertions, 908 deletions
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`
+-- Table structure for table `EplusTableResult`
--
-CREATE TABLE IF NOT EXISTS `eplus2sip` (
+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 `eplus2sip`
+-- Dumping data for table `EplusTableResult`
--
-- --------------------------------------------------------
--
--- Table structure for table `gsm1rz2eplus`
+-- Table structure for table `LandlineTableResult`
--
-CREATE TABLE IF NOT EXISTS `gsm1rz2eplus` (
+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 `gsm1rz2eplus`
+-- Dumping data for table `LandlineTableResult`
--
-- --------------------------------------------------------
--
--- Table structure for table `gsm1rz2gsm2rz`
+-- Table structure for table `LocalSIPTableResult`
--
-CREATE TABLE IF NOT EXISTS `gsm1rz2gsm2rz` (
+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 `gsm1rz2gsm2rz`
+-- Dumping data for table `LocalSIPTableResult`
--
-- --------------------------------------------------------
--
--- Table structure for table `gsm1rz2gsm3rz`
+-- Table structure for table `OtwoTableResult`
--
-CREATE TABLE IF NOT EXISTS `gsm1rz2gsm3rz` (
+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 `gsm1rz2gsm3rz`
+-- Dumping data for table `OtwoTableResult`
--
-- --------------------------------------------------------
--
--- 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`
---
-
-CREATE TABLE IF NOT EXISTS `sip2localsip` (
- `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 `sip2localsip`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `sip2otwo`
---
-
-CREATE TABLE IF NOT EXISTS `sip2otwo` (
- `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 `sip2otwo`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `sip2tmobile`
---
-
-CREATE TABLE IF NOT EXISTS `sip2tmobile` (
- `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 `sip2tmobile`
---
-
-
--- --------------------------------------------------------
-
---
--- Table structure for table `sip2vodaphone`
---
-
-CREATE TABLE IF NOT EXISTS `sip2vodaphone` (
- `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 `sip2vodaphone`
---
-
-
--- --------------------------------------------------------
-
---
--- 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`
--