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


Ignore:
Timestamp:
Oct 15, 2008, 3:56:02 PM (17 years ago)
Author:
jazz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • oid/WorkLog/08-10-15

    v17 v18  
    134134+) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    135135}}}
     136{{{
     137--- data_type.sql.org   2008-10-15 23:54:34.000000000 +0800
     138+++ data_type.sql       2008-10-15 23:55:03.000000000 +0800
     139@@ -1,8 +1,8 @@
     140 CREATE TABLE data_type (
     141-    int(11) auto_increment smallint NOT NULL,
     142+    serial smallint auto_increment NOT NULL,
     143     name varchar(30) NOT NULL,
     144     parent_id smallint NOT NULL
     145-, PRIMARY KEY(`int(11)`)
     146+, PRIMARY KEY(`serial`)
     147 ) TYPE=MyISAM;
     148}}}
    136149 * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]
    137150 * [參考] [http://forums.mysql.com/read.php?83,34517,70646#msg-70646 用 Perl 寫的 SQL::Translator (aka SQLFairy)]