summaryrefslogblamecommitdiffstats
path: root/Database/localhost.sql
blob: 75aeef3009daaec2f6de8f46a4474a78ab9bfcf7 (plain) (tree)
1
2
3
4
5
6




                            
                                            











                                                                   
                             
  

                                                                                        



                                                           
                                               

  
                                               
                            



                        



                                       
                                            





                                                           
                                                  

  
                                                  
                            



                        



                                       
                                               





                                                           
                                                  

  
                                                  
                            








                              



                                       
                                               





                                                           
                                              

  
                                              
                            



                        



                                       
                                           





                                                           
                                              

  
                                              
                            





                                  



                                       
                                           





                                                           
                                             

  
                                             
                            








                              



                                       
                                          





                                                           
                                             

  
                                             
                            








                              



                                       
                                          





                                                           
                                             

  
                                             
                            








                              



                                       
                                          





                                                           
                                             

  
                                             
                            








                              



                                       
                                          





                                                           
                                        

  
                                        
                            














                                                           



                                       
                                     





                                                           
                                                 

  
                                                 
                            



                        



                                       
                                              





                                                           
                                                   

  
                                                   
                            



                        



                                       
                                                

  
-- phpMyAdmin SQL Dump
-- version 3.3.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 30, 2011 at 04:02 PM
-- 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 `EplusTableResult`
--

CREATE TABLE IF NOT EXISTS `EplusTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `EplusTableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `LandlineTableResult`
--

CREATE TABLE IF NOT EXISTS `LandlineTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `LandlineTableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `LocalSIPTableResult`
--

CREATE TABLE IF NOT EXISTS `LocalSIPTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `LocalSIPTableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `OtwoTableResult`
--

CREATE TABLE IF NOT EXISTS `OtwoTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `OtwoTableResult`
--


-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `RZ1TableResult` (
  `taskid` int(11) NOT NULL,
  `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 `RZ1TableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `RZ2TableResult`
--

CREATE TABLE IF NOT EXISTS `RZ2TableResult` (
  `taskid` int(11) NOT NULL,
  `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 `RZ2TableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `RZ3TableResult`
--

CREATE TABLE IF NOT EXISTS `RZ3TableResult` (
  `taskid` int(11) NOT NULL,
  `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 `RZ3TableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `SIPTableResult`
--

CREATE TABLE IF NOT EXISTS `SIPTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `SIPTableResult`
--


-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `TmobileTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `TmobileTableResult`
--


-- --------------------------------------------------------

--
-- Table structure for table `VodaphoneTableResult`
--

CREATE TABLE IF NOT EXISTS `VodaphoneTableResult` (
  `taskid` int(11) NOT NULL,
  `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 `VodaphoneTableResult`
--