close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_fs.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
- Timestamp:
-
Oct 15, 2008, 5:24:53 PM (18 years ago)
- Author:
-
jazz
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
|
v26
|
v27
|
|
| 205 | 205 | +SET NAMES 'utf8'; |
| 206 | 206 | }}} |
| | 207 | {{{ |
| | 208 | #!diff |
| | 209 | --- maincase_storage.sql.org 2008-10-16 01:21:07.000000000 +0800 |
| | 210 | +++ maincase_storage.sql 2008-10-16 01:22:12.000000000 +0800 |
| | 211 | @@ -1,10 +1,12 @@ |
| | 212 | CREATE TABLE maincase_storage ( |
| | 213 | - int(11) auto_increment int(11) auto_increment NOT NULL, |
| | 214 | + serial int(11) auto_increment NOT NULL, |
| | 215 | maincase_id int(11) NOT NULL, |
| | 216 | storage_type smallint NOT NULL |
| | 217 | -, PRIMARY KEY(`int(11)`) |
| | 218 | +, PRIMARY KEY(`serial`) |
| | 219 | ) TYPE=MyISAM; |
| | 220 | |
| | 221 | +SET NAMES 'utf8'; |
| | 222 | }}} |
| 207 | 223 | * 為了讓後續 INSERT 進去的中文字元維持 UTF-8, 必須在一開始的 SQL 語法加進 "SET NAMES 'utf8';" |
| 208 | 224 | {{{ |