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

Timestamp:

Oct 15, 2008, 4:05:39 PM (16 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -135 +135 @@
 }}}
 {{{
+#!diff
 --- data_type.sql.org   2008-10-15 23:54:34.000000000 +0800
 +++ data_type.sql       2008-10-15 23:55:03.000000000 +0800
@@ -143 +144 @@
      name varchar(30) NOT NULL,
      parent_id smallint NOT NULL
+-, PRIMARY KEY(`int(11)`)
++, PRIMARY KEY(`serial`)
+ ) TYPE=MyISAM;
+}}}
+   * [錯誤] #1293 - 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`)