close
Warning:
Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_core.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.
- Timestamp:
-
Oct 15, 2008, 5:16:13 PM (17 years ago)
- Author:
-
jazz
- Comment:
-
--
Legend:
- Unmodified
- Added
- Removed
- Modified
-
|
v24
|
v25
|
|
| 187 | 187 | ) TYPE=MyISAM; |
| 188 | 188 | }}} |
| | 189 | {{{ |
| | 190 | #!diff |
| | 191 | --- maincase_detail.sql.org 2008-10-16 01:13:41.000000000 +0800 |
| | 192 | +++ maincase_detail.sql 2008-10-16 01:15:25.000000000 +0800 |
| | 193 | @@ -1,10 +1,12 @@ |
| | 194 | CREATE TABLE maincase_detail ( |
| | 195 | - int(11) auto_increment bigint auto_increment NOT NULL, |
| | 196 | + serial int(11) auto_increment NOT NULL, |
| | 197 | maincase_id int(11), |
| | 198 | type_id smallint |
| | 199 | -, PRIMARY KEY(`int(11)`) |
| | 200 | +, PRIMARY KEY(`serial`) |
| | 201 | ) TYPE=MyISAM; |
| | 202 | |
| | 203 | +SET NAMES 'utf8'; |
| | 204 | }}} |
| 189 | 205 | * 為了讓後續 INSERT 進去的中文字元維持 UTF-8, 必須在一開始的 SQL 語法加進 "SET NAMES 'utf8';" |
| 190 | 206 | {{{ |