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

Timestamp:

Oct 15, 2008, 5:16:13 PM (16 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -187 +187 @@
  ) TYPE=MyISAM;
 }}}
+{{{
+#!diff
+--- maincase_detail.sql.org     2008-10-16 01:13:41.000000000 +0800
++++ maincase_detail.sql 2008-10-16 01:15:25.000000000 +0800
+@@ -1,10 +1,12 @@
+ CREATE TABLE maincase_detail (
+-    int(11) auto_increment bigint auto_increment NOT NULL,
++    serial int(11) auto_increment NOT NULL,
+     maincase_id int(11),
+     type_id smallint
+-, PRIMARY KEY(`int(11)`)
++, PRIMARY KEY(`serial`)
+ ) TYPE=MyISAM;
+
++SET NAMES 'utf8';
+}}}
  * 為了讓後續 INSERT 進去的中文字元維持 UTF-8, 必須在一開始的 SQL 語法加進 "SET NAMES 'utf8';"
 {{{