close Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_repos.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.

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


Ignore:
Timestamp:
Oct 15, 2008, 4:48:01 PM (17 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • oid/WorkLog/08-10-15

    v19 v20  
    148148 ) TYPE=MyISAM;
    149149}}}
    150    * [錯誤] #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
     150   * [錯誤] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
    151151{{{
    152152#!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
    169 -, PRIMARY KEY(`int(11)`)
    170 +, PRIMARY KEY(`serial`)
    171  ) TYPE=MyISAM;
     153
    172154}}}
    173155 * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]