summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorBebek2011-06-25 02:15:13 +0200
committerBebek2011-06-25 02:15:13 +0200
commitad8446eaadeb2e4369fc5428b562b7377a0b1559 (patch)
tree24a7371e49f5cb6ca3360eeae18b2f7f8f028cfa /Database
parenthandler for SIP. (diff)
downloadgsm-selftest-ad8446eaadeb2e4369fc5428b562b7377a0b1559.tar.gz
gsm-selftest-ad8446eaadeb2e4369fc5428b562b7377a0b1559.tar.xz
gsm-selftest-ad8446eaadeb2e4369fc5428b562b7377a0b1559.zip
just export to your mysql database. its will be store new database include all table.
Diffstat (limited to 'Database')
-rw-r--r--Database/localhost.sql1082
1 files changed, 1082 insertions, 0 deletions
diff --git a/Database/localhost.sql b/Database/localhost.sql
new file mode 100644
index 0000000..f6da83e
--- /dev/null
+++ b/Database/localhost.sql
@@ -0,0 +1,1082 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.10deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Jun 25, 2011 at 02:14 AM
+-- Server version: 5.1.54
+-- PHP Version: 5.3.5-1ubuntu7.2
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `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`
+--
+
+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`
+--
+
+CREATE TABLE IF NOT EXISTS `tmobile2gsm1rz` (
+ `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 `tmobile2gsm1rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tmobile2gsm2rz`
+--
+
+CREATE TABLE IF NOT EXISTS `tmobile2gsm2rz` (
+ `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 `tmobile2gsm2rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tmobile2gsm3rz`
+--
+
+CREATE TABLE IF NOT EXISTS `tmobile2gsm3rz` (
+ `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 `tmobile2gsm3rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tmobile2sip`
+--
+
+CREATE TABLE IF NOT EXISTS `tmobile2sip` (
+ `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 `tmobile2sip`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `vodaphone2gsm1rz`
+--
+
+CREATE TABLE IF NOT EXISTS `vodaphone2gsm1rz` (
+ `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 `vodaphone2gsm1rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `vodaphone2gsm2rz`
+--
+
+CREATE TABLE IF NOT EXISTS `vodaphone2gsm2rz` (
+ `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 `vodaphone2gsm2rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `vodaphone2gsm3rz`
+--
+
+CREATE TABLE IF NOT EXISTS `vodaphone2gsm3rz` (
+ `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 `vodaphone2gsm3rz`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `vodaphone2sip`
+--
+
+CREATE TABLE IF NOT EXISTS `vodaphone2sip` (
+ `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 `vodaphone2sip`
+--
+