From 1c009430af80260d67c47652783931414989c75d Mon Sep 17 00:00:00 2001 From: gsmselftest Date: Wed, 9 Nov 2011 16:41:00 +0100 Subject: Final folder team project --- Database/gsmselftesting.sql | 196 -------------------------------------------- 1 file changed, 196 deletions(-) delete mode 100644 Database/gsmselftesting.sql (limited to 'Database/gsmselftesting.sql') diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql deleted file mode 100644 index 566997d..0000000 --- a/Database/gsmselftesting.sql +++ /dev/null @@ -1,196 +0,0 @@ --- phpMyAdmin SQL Dump --- version 3.3.10deb1 --- http://www.phpmyadmin.net --- --- Host: localhost --- Generation Time: Oct 30, 2011 at 10:28 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` --- - --- -------------------------------------------------------- - --- --- Table structure for table `DeviceAddressTable` --- - -CREATE TABLE IF NOT EXISTS `DeviceAddressTable` ( - `deviceName` varchar(15) NOT NULL, - `portName` varchar(15) NOT NULL, - `number` varchar(20) NOT NULL, - `lastChange` datetime NOT NULL, - `username` varchar(20) NOT NULL DEFAULT 'root', - `password` varchar(20) NOT NULL DEFAULT 'root', - `server` varchar(20) NOT NULL, - PRIMARY KEY (`deviceName`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `DeviceAddressTable` --- - -INSERT INTO `DeviceAddressTable` (`deviceName`, `portName`, `number`, `lastChange`, `username`, `password`, `server`) VALUES -('sip', 'localhost', '07612034661928', '2011-07-26 00:00:00', 'mpselftest1', '1mpselftest', '132.230.4.8'), -('unisip', 'localhost', '076120397898', '2011-07-27 00:00:00', '4976120397898', 'itzEfmLkzvS9', '132.230.252.228'), -('landline', 'localhost', '076145875681', '2011-07-26 00:00:00', '1289459', 'MMW9AX', 'sipgate.de'), -('GSMRZ1', '/dev/ttyUSB0', '07612034661449', '2011-07-27 15:47:08', '', '', ''), -('GSMRZ2', 'localhost', '07612034661473', '2011-07-27 15:48:04', 'lsfks', 'lsfks', '132.230.4.67'), -('GSMExt.Eplus', '/dev/ttyUSB4', '015782677224', '2011-07-28 14:33:43', '', '', ''), -('GSMExt.Voda', '/dev/ttyUSB3', '015252423662', '2011-07-28 14:35:33', '', '', ''), -('GSMExt.Tm', '/dev/ttyUSB1', '015128040906', '2011-08-29 14:47:18', '', '', ''), -('GSMExt.O2', '/dev/ttyUSB2', '017678038038', '2011-07-28 14:36:13', '', '', ''), -('GSMRZ3', 'localhost', '07612034661455', '2011-10-14 16:34:07', 'lsfks', 'root', '132.230.4.57'); - --- -------------------------------------------------------- - --- --- Table structure for table `ErrorCodeTable` --- - -CREATE TABLE IF NOT EXISTS `ErrorCodeTable` ( - `respondCode` int(4) NOT NULL, - `description` varchar(100) NOT NULL, - PRIMARY KEY (`respondCode`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `ErrorCodeTable` --- - -INSERT INTO `ErrorCodeTable` (`respondCode`, `description`) VALUES -(200, 'Call was OK'), -(604, 'General Handler Error: Destination handler did not respond. Timeout'), -(998, 'General Handler Error: Could not connect to the destination handler!'), -(605, 'General Handler Error: Caller handler did not respond. Timeout'), -(999, 'General Handler Error: Could not connect to the caller handler!'), -(486, 'Call Failed'), -(500, 'Server Internal Error'), -(333, 'Could not establish a connection to the database!'), -(100, 'Missing account detail'), -(402, 'Payment Required (Eplus Card)'), -(801, 'Connection to caller establishment, but device error'), -(802, 'Connection to destination establishment, but device error'); - --- -------------------------------------------------------- - --- --- Table structure for table `GSMPrefix` --- - -CREATE TABLE IF NOT EXISTS `GSMPrefix` ( - `carrier` varchar(13) NOT NULL, - `prefix` varchar(4) NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `GSMPrefix` --- - -INSERT INTO `GSMPrefix` (`carrier`, `prefix`) VALUES -('GSMExt.Tm', '0151'), -('GSMExt.Tm', '0160'), -('GSMExt.Tm', '0170'), -('GSMExt.Tm', '0175'), -('GSMExt.Tm', '0171'), -('GSMExt.Voda', '0162'), -('GSMExt.Voda', '0172'), -('GSMExt.Voda', '0173'), -('GSMExt.Voda', '0174'), -('GSMExt.Eplus', '0157'), -('GSMExt.Eplus', '0177'), -('GSMExt.Eplus', '0155'), -('GSMExt.Eplus', '0163'), -('GSMExt.Eplus', '0178'), -('GSMExt.O2', '0159'), -('GSMExt.O2', '0176'), -('GSMExt.O2', '0179'), -('GSMRZ1', '0761'), -('GSMExt.Voda', '0152'); - --- -------------------------------------------------------- - --- --- Table structure for table `PingResultTable` --- - -CREATE TABLE IF NOT EXISTS `PingResultTable` ( - `taskNo` int(11) NOT NULL, - `sipServer` int(3) NOT NULL, - `sipGate` int(3) NOT NULL, - `unisip` 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` --- - -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` --- - -CREATE TABLE IF NOT EXISTS `TaskTable` ( - `taskID` int(11) NOT NULL AUTO_INCREMENT, - `taskNo` int(11) NOT NULL, - `from` varchar(15) NOT NULL, - `to` varchar(15) NOT NULL, - `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`taskID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; - --- --- Dumping data for table `TaskTable` --- - - --- -------------------------------------------------------- - --- --- Table structure for table `TempTaskTable` --- - -CREATE TABLE IF NOT EXISTS `TempTaskTable` ( - `taskID` int(11) NOT NULL, - `taskNo` int(11) NOT NULL, - `from` varchar(15) NOT NULL, - `to` varchar(15) NOT NULL, - PRIMARY KEY (`taskID`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1; - --- --- Dumping data for table `TempTaskTable` --- - -- cgit v1.2.3-55-g7522