summaryrefslogtreecommitdiffstats
path: root/Database/gsmselftesting.sql
diff options
context:
space:
mode:
authorTriatmoko2011-10-30 22:29:21 +0100
committerTriatmoko2011-10-30 22:29:21 +0100
commit92eed03aeeb1c905a33546392a7bff3337b607c8 (patch)
tree465e96d6d58656bb1b99cf20c1866f653ac16a72 /Database/gsmselftesting.sql
parentsmarttest php (diff)
downloadgsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.tar.gz
gsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.tar.xz
gsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.zip
rearrange the files and edit ssh connection for class controller
Diffstat (limited to 'Database/gsmselftesting.sql')
-rw-r--r--Database/gsmselftesting.sql80
1 files changed, 57 insertions, 23 deletions
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
index 0f3e70b..566997d 100644
--- a/Database/gsmselftesting.sql
+++ b/Database/gsmselftesting.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Generation Time: Sep 02, 2011 at 02:10 PM
+-- Generation Time: Oct 30, 2011 at 10:28 PM
-- Server version: 5.1.54
-- PHP Version: 5.3.5-1ubuntu7.2
@@ -18,9 +18,6 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `gsmselftesting`
--
-DROP DATABASE IF EXISTS `gsmselftesting`;
-CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-USE `gsmselftesting`;
-- --------------------------------------------------------
@@ -47,12 +44,13 @@ INSERT INTO `DeviceAddressTable` (`deviceName`, `portName`, `number`, `lastChang
('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', 'localhost', '07612034661xxx', '2011-07-27 15:47:08', '', '', ''),
-('GSMRZ2', 'localhost', '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.Tm', 'localhost', '015128040906', '2011-08-29 14:47:18', '', '', ''),
-('GSMExt.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', '');
+('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');
-- --------------------------------------------------------
@@ -61,25 +59,64 @@ INSERT INTO `DeviceAddressTable` (`deviceName`, `portName`, `number`, `lastChang
--
CREATE TABLE IF NOT EXISTS `ErrorCodeTable` (
- `errorcode` int(4) NOT NULL,
+ `respondCode` int(4) NOT NULL,
`description` varchar(100) NOT NULL,
- PRIMARY KEY (`errorcode`)
+ PRIMARY KEY (`respondCode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ErrorCodeTable`
--
-INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES
+INSERT INTO `ErrorCodeTable` (`respondCode`, `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'),
+(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, 'No connection to Database'),
-(100, 'Missing account detail');
+(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');
-- --------------------------------------------------------
@@ -118,9 +155,6 @@ CREATE TABLE IF NOT EXISTS `ResultTable` (
-- Dumping data for table `ResultTable`
--
-INSERT INTO `ResultTable` (`taskID`, `result`) VALUES
-(1, 486),
-(2, 486);
-- --------------------------------------------------------
@@ -135,7 +169,7 @@ CREATE TABLE IF NOT EXISTS `TaskTable` (
`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=25 ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `TaskTable`