-- 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` --