Changes between Version 26 and Version 27 of oid/WorkLog/08-10-15

Timestamp:

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

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

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