From 7cbd30ee6b5b2866a168c575ab327a50de397554 Mon Sep 17 00:00:00 2001 From: tt41 Date: Fri, 19 Aug 2011 19:08:01 +0200 Subject: add database dumping file. --- Database/gsmselftesting.sql | 164 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 164 insertions(+) create mode 100644 Database/gsmselftesting.sql (limited to 'Database') diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql new file mode 100644 index 0000000..ad50687 --- /dev/null +++ b/Database/gsmselftesting.sql @@ -0,0 +1,164 @@ +-- phpMyAdmin SQL Dump +-- version 3.3.10deb1 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Aug 19, 2011 at 07:07 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` +-- +DROP DATABASE `gsmselftesting`; +CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; +USE `gsmselftesting`; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `DeviceAddressTable` +-- + +DROP TABLE IF EXISTS `DeviceAddressTable`; +CREATE TABLE IF NOT EXISTS `DeviceAddressTable` ( + `deviceName` varchar(15) NOT NULL, + `deviceIP` varchar(60) NOT NULL, + `number` varchar(20) NOT NULL, + `lastChange` datetime NOT NULL, + `username` varchar(20) NOT NULL, + `password` varchar(20) NOT NULL, + `server` varchar(20) NOT NULL, + PRIMARY KEY (`deviceName`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `DeviceAddressTable` +-- + +INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChange`, `username`, `password`, `server`) VALUES +('sip', 'localhost', '07612034661928', '2011-07-26 00:00:00', 'mpselftest1', '1mpselftest', '132.230.4.8'), +('unisip', 'localhost', '076120397897', '2011-07-27 00:00:00', '4976120397897', 'hB8M3WyFt61C', '132.230.252.228'), +('landline', 'localhost', '076145875681', '2011-07-26 00:00:00', '1289459', 'MMW9AX', 'sipgate.de'), +('GSMRZ1', 'localhost', '07612034661xxx', '2011-07-27 15:47:08', '', '', ''), +('GSMRZ2', '132.230.4.64', '07612034661455', '2011-07-27 15:48:04', '', '', ''), +('GSMExt.Eplus', 'localhost', '015782677224', '2011-07-28 14:33:43', '', '', ''), +('GSMExt.Voda', 'localhost', '015252423662', '2011-07-28 14:35:33', '', '', ''), +('GSMExt.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', ''); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `ErrorCodeTable` +-- + +DROP TABLE IF EXISTS `ErrorCodeTable`; +CREATE TABLE IF NOT EXISTS `ErrorCodeTable` ( + `errorcode` int(4) NOT NULL, + `description` varchar(100) NOT NULL, + PRIMARY KEY (`errorcode`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `ErrorCodeTable` +-- + +INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES +(200, 'Call was OK'), +(604, 'General Handler Error: Destination handler no respond timeout'), +(998, 'General Handler Error: Could not connect Destination handler'), +(605, 'General Handler Error: caller handler no respond timeout'), +(999, 'General Handler Error: Could not connect to Caller handler'), +(486, 'Call Failed'), +(500, 'Server Internal Error'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `PingResultTable` +-- + +DROP TABLE IF EXISTS `PingResultTable`; +CREATE TABLE IF NOT EXISTS `PingResultTable` ( + `taskNo` int(11) NOT NULL, + `sipServer` int(3) NOT NULL, + `sipGate` int(3) NOT NULL, + `sipLoc` int(3) NOT NULL, + `gsmBox1` int(3) NOT NULL, + `gsmBox2` int(3) NOT NULL, + PRIMARY KEY (`taskNo`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `PingResultTable` +-- + + +-- -------------------------------------------------------- + +-- +-- Table structure for table `ResultTable` +-- + +DROP TABLE IF EXISTS `ResultTable`; +CREATE TABLE IF NOT EXISTS `ResultTable` ( + `taskID` int(11) NOT NULL, + `result` int(3) NOT NULL, + PRIMARY KEY (`taskID`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `ResultTable` +-- + + +-- -------------------------------------------------------- + +-- +-- Table structure for table `TaskTable` +-- + +DROP TABLE IF EXISTS `TaskTable`; +CREATE TABLE IF NOT EXISTS `TaskTable` ( + `taskID` int(11) NOT NULL AUTO_INCREMENT, + `taskNo` int(11) NOT NULL, + `from` varchar(10) NOT NULL, + `to` varchar(10) NOT NULL, + `status` int(2) NOT NULL, + `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`taskID`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ; + +-- +-- Dumping data for table `TaskTable` +-- + + +-- -------------------------------------------------------- + +-- +-- Table structure for table `TempTaskTable` +-- + +DROP TABLE IF EXISTS `TempTaskTable`; +CREATE TABLE IF NOT EXISTS `TempTaskTable` ( + `taskID` int(11) NOT NULL, + `taskNo` int(11) NOT NULL, + `from` varchar(10) NOT NULL, + `to` varchar(10) NOT NULL, + `status` int(1) NOT NULL, + PRIMARY KEY (`taskID`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Dumping data for table `TempTaskTable` +-- + -- cgit v1.2.3-55-g7522