summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authortt412011-08-20 00:23:55 +0200
committertt412011-08-20 00:23:55 +0200
commit1201b65c816e0d2fb5440d970633f0a3553e21e8 (patch)
treef9e8980516dcfbe509dd8bf1533e70d7073b296d /Database
parentmodified column name for ping result table. (diff)
downloadgsm-selftest-1201b65c816e0d2fb5440d970633f0a3553e21e8.tar.gz
gsm-selftest-1201b65c816e0d2fb5440d970633f0a3553e21e8.tar.xz
gsm-selftest-1201b65c816e0d2fb5440d970633f0a3553e21e8.zip
modified structure for task table.
Diffstat (limited to 'Database')
-rw-r--r--Database/gsmselftesting.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
index ee3f198..df3a0a8 100644
--- a/Database/gsmselftesting.sql
+++ b/Database/gsmselftesting.sql
@@ -132,7 +132,7 @@ CREATE TABLE IF NOT EXISTS `TaskTable` (
`taskNo` int(11) NOT NULL,
`from` varchar(10) NOT NULL,
`to` varchar(10) NOT NULL,
- `status` int(2) 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 ;