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


Ignore:
Timestamp:
Oct 15, 2008, 4:05:39 PM (16 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • oid/WorkLog/08-10-15

    v18 v19  
    135135}}}
    136136{{{
     137#!diff
    137138--- data_type.sql.org   2008-10-15 23:54:34.000000000 +0800
    138139+++ data_type.sql       2008-10-15 23:55:03.000000000 +0800
     
    143144     name varchar(30) NOT NULL,
    144145     parent_id smallint NOT NULL
     146-, PRIMARY KEY(`int(11)`)
     147+, PRIMARY KEY(`serial`)
     148 ) TYPE=MyISAM;
     149}}}
     150   * [錯誤] #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
     151{{{
     152#!diff
     153--- maincase.sql.org    2008-10-15 23:58:18.000000000 +0800
     154+++ maincase.sql        2008-10-16 00:04:56.000000000 +0800
     155@@ -1,5 +1,5 @@
     156 CREATE TABLE maincase (
     157-    int(11) auto_increment int(11) auto_increment NOT NULL,
     158+    serial int(11) auto_increment NOT NULL,
     159     name varchar(60) NOT NULL,
     160     description varchar(255),
     161     storage_desc varchar(50),
     162@@ -19,9 +19,9 @@
     163     end_time timestamp NOT NULL,
     164     user_id smallint NOT NULL,
     165     checked bool DEFAULT 0 NOT NULL,
     166-    insert_time timestamp DEFAULT CURRENT_TIMESTAMP,
     167+    insert_time timestamp,
     168     cover bool DEFAULT 0 NOT NULL
    145169-, PRIMARY KEY(`int(11)`)
    146170+, PRIMARY KEY(`serial`)