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.
- Timestamp:
-
Oct 15, 2008, 3:48:12 PM (16 years ago)
- Author:
-
jazz
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
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 | | - ) TYPE=MyISAM; |
| 96 | -) TYPE=MyISAM; |
102 | 97 | +, 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; |
104 | 99 | }}} |
105 | 100 | * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)] |