From ad8446eaadeb2e4369fc5428b562b7377a0b1559 Mon Sep 17 00:00:00 2001 From: Bebek Date: Sat, 25 Jun 2011 02:15:13 +0200 Subject: just export to your mysql database. its will be store new database include all table. --- Database/localhost.sql | 1082 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 1082 insertions(+) create mode 100644 Database/localhost.sql (limited to 'Database/localhost.sql') 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` +-- + -- cgit v1.2.3-55-g7522