summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorgsmselftest2011-11-09 16:41:00 +0100
committergsmselftest2011-11-09 16:41:00 +0100
commit1c009430af80260d67c47652783931414989c75d (patch)
tree204540af3ff3d8e23892986ad7585080900b7463 /Database
parentReport relocating! (diff)
downloadgsm-selftest-1c009430af80260d67c47652783931414989c75d.tar.gz
gsm-selftest-1c009430af80260d67c47652783931414989c75d.tar.xz
gsm-selftest-1c009430af80260d67c47652783931414989c75d.zip
Final folder team project
Diffstat (limited to 'Database')
-rw-r--r--Database/gsmselftesting.sql196
1 files changed, 0 insertions, 196 deletions
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`
---
-