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

Timestamp:

Oct 15, 2008, 3:46:41 PM (16 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -81 +81 @@
 jazz@oceandb:~/pg2mysql-1.2$ 
 }}}
+   * 轉出來的結果有錯，因為有用到 sequence (序列)
+{{{
+#!diff
+--- account.sql.org     2008-10-15 23:23:54.000000000 +0800
++++ account.sql 2008-10-15 23:24:12.000000000 +0800
+@@ -1,5 +1,5 @@
+collation database utf8_unicode_ci
+ CREATE TABLE account (
+-    int(11) auto_increment smallint auto_increment NOT NULL,
++    serial int(11) auto_increment NOT NULL,
+     name varchar(10) NOT NULL,
+     tel varchar(20) NOT NULL,
+     fax varchar(20),
+@@ -10,5 +10,5 @@
+     admin bool NOT NULL,
+     account varchar(20) NOT NULL,
+     password varchar(20) NOT NULL
+-, PRIMARY KEY(`int(11)`)
++, PRIMARY KEY(`serial`)
+- ) TYPE=MyISAM;
++ ) TYPE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
+}}}
  * [工具二] [http://sqlfairy.sourceforge.net/ SQL::Translator (aka SQLFairy)]
  * [參考] [http://forums.mysql.com/read.php?83,34517,70646#msg-70646 用 Perl 寫的 SQL::Translator (aka SQLFairy)]