Changes between Version 19 and Version 20 of oid/WorkLog/08-10-15

Timestamp:

Oct 15, 2008, 4:48:01 PM (17 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -148 +148 @@
  ) TYPE=MyISAM;
 }}}
-   * [錯誤] #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause 
+   * [錯誤] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
 {{{
 #!diff
---- maincase.sql.org    2008-10-15 23:58:18.000000000 +0800
-+++ maincase.sql        2008-10-16 00:04:56.000000000 +0800
-@@ -1,5 +1,5 @@
- CREATE TABLE maincase (
--    int(11) auto_increment int(11) auto_increment NOT NULL,
-+    serial int(11) auto_increment NOT NULL,
-     name varchar(60) NOT NULL,
-     description varchar(255),
-     storage_desc varchar(50),
-@@ -19,9 +19,9 @@
-     end_time timestamp NOT NULL,
-     user_id smallint NOT NULL,
-     checked bool DEFAULT 0 NOT NULL,
--    insert_time timestamp DEFAULT CURRENT_TIMESTAMP,
-+    insert_time timestamp,
-     cover bool DEFAULT 0 NOT NULL
--, PRIMARY KEY(`int(11)`)
-+, PRIMARY KEY(`serial`)
- ) TYPE=MyISAM;
+
 }}}
  * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]