summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authortt412011-09-01 22:46:31 +0200
committertt412011-09-01 22:46:31 +0200
commit451ba9298b9de3fbf2aa560bd39c1e8577af3d1b (patch)
tree6c746c44a452c188d7f4bf3af15a4d8445653a99 /Database
parentnew account for Univ. telp. network. (diff)
downloadgsm-selftest-451ba9298b9de3fbf2aa560bd39c1e8577af3d1b.tar.gz
gsm-selftest-451ba9298b9de3fbf2aa560bd39c1e8577af3d1b.tar.xz
gsm-selftest-451ba9298b9de3fbf2aa560bd39c1e8577af3d1b.zip
clean the comment
Diffstat (limited to 'Database')
-rw-r--r--Database/gsmselftesting.sql4
1 files changed, 1 insertions, 3 deletions
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
index 0ac203f..be80cb2 100644
--- a/Database/gsmselftesting.sql
+++ b/Database/gsmselftesting.sql
@@ -49,7 +49,7 @@ INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChang
('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', '132.230.4.64', '07612034661455', '2011-07-27 15:48:04', '', '', ''),
+('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.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', '');
@@ -132,7 +132,6 @@ CREATE TABLE IF NOT EXISTS `TaskTable` (
`taskNo` int(11) NOT NULL,
`from` varchar(15) NOT NULL,
`to` varchar(15) NOT NULL,
- `status` int(1) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`taskID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
@@ -154,7 +153,6 @@ CREATE TABLE IF NOT EXISTS `TempTaskTable` (
`taskNo` int(11) NOT NULL,
`from` varchar(15) NOT NULL,
`to` varchar(15) NOT NULL,
- `status` int(1) NOT NULL,
PRIMARY KEY (`taskID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;