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


Ignore:
Timestamp:
Oct 15, 2008, 3:48:12 PM (16 years ago)
Author:
jazz
Comment:

--

Legend:

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

    v14 v15  
    8383   * 轉出來的結果有錯,因為有用到 sequence (序列)
    8484{{{
    85 #!diff
    86 --- account.sql.org     2008-10-15 23:23:54.000000000 +0800
    87 +++ account.sql 2008-10-15 23:24:12.000000000 +0800
    88 @@ -1,5 +1,5 @@
    89 collation database utf8_unicode_ci
    90  CREATE TABLE account (
     85#!diff CREATE TABLE account (
    9186-    int(11) auto_increment smallint auto_increment NOT NULL,
    9287+    serial int(11) auto_increment NOT NULL,
     
    9994     password varchar(20) NOT NULL
    10095-, PRIMARY KEY(`int(11)`)
    101 - ) TYPE=MyISAM;
     96-) TYPE=MyISAM;
    10297+, PRIMARY KEY(`serial`)
    103 + ) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
     98+) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    10499}}}
    105100 * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]