From 1201b65c816e0d2fb5440d970633f0a3553e21e8 Mon Sep 17 00:00:00 2001 From: tt41 Date: Sat, 20 Aug 2011 00:23:55 +0200 Subject: modified structure for task table. --- Database/gsmselftesting.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'Database') 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 ; -- cgit v1.2.3-55-g7522