Changes between Version 14 and Version 15 of oid/WorkLog/08-10-15
- Timestamp:
- Oct 15, 2008, 3:48:12 PM (16 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
oid/WorkLog/08-10-15
v14 v15 83 83 * 轉出來的結果有錯,因為有用到 sequence (序列) 84 84 {{{ 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 ( 91 86 - int(11) auto_increment smallint auto_increment NOT NULL, 92 87 + serial int(11) auto_increment NOT NULL, … … 99 94 password varchar(20) NOT NULL 100 95 -, PRIMARY KEY(`int(11)`) 101 - 96 -) TYPE=MyISAM; 102 97 +, PRIMARY KEY(`serial`) 103 + 98 +) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 104 99 }}} 105 100 * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]