summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorgsmselgtest2011-09-02 14:11:36 +0200
committergsmselgtest2011-09-02 14:11:36 +0200
commitcd0b7f95f6145684f658bcd9761c0fbd49a1d145 (patch)
treeafc0ce0fef22ad63e6694adc24a7e6be7fda2938 /Database
parentmore information for the sip handler (diff)
downloadgsm-selftest-cd0b7f95f6145684f658bcd9761c0fbd49a1d145.tar.gz
gsm-selftest-cd0b7f95f6145684f658bcd9761c0fbd49a1d145.tar.xz
gsm-selftest-cd0b7f95f6145684f658bcd9761c0fbd49a1d145.zip
insert more error code on the table.
Diffstat (limited to 'Database')
-rw-r--r--Database/gsmselftesting.sql15
1 files changed, 7 insertions, 8 deletions
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
index cba3741..15126ee 100644
--- a/Database/gsmselftesting.sql
+++ b/Database/gsmselftesting.sql
@@ -3,7 +3,7 @@
-- http://www.phpmyadmin.net
--
-- Host: localhost
--- Generation Time: Aug 19, 2011 at 07:07 PM
+-- Generation Time: Sep 02, 2011 at 02:10 PM
-- Server version: 5.1.54
-- PHP Version: 5.3.5-1ubuntu7.2
@@ -28,7 +28,6 @@ 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,
@@ -61,7 +60,6 @@ INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChang
-- 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,
@@ -79,7 +77,9 @@ INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES
(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');
+(500, 'Server Internal Error'),
+(333, 'No connection to Database'),
+(100, 'Missing account detail');
-- --------------------------------------------------------
@@ -87,7 +87,6 @@ INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES
-- 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,
@@ -109,7 +108,6 @@ CREATE TABLE IF NOT EXISTS `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,
@@ -120,6 +118,9 @@ CREATE TABLE IF NOT EXISTS `ResultTable` (
-- Dumping data for table `ResultTable`
--
+INSERT INTO `ResultTable` (`taskID`, `result`) VALUES
+(1, 486),
+(2, 486);
-- --------------------------------------------------------
@@ -127,7 +128,6 @@ CREATE TABLE IF NOT EXISTS `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,
@@ -148,7 +148,6 @@ CREATE TABLE IF NOT EXISTS `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,