153 | | |
| 153 | --- maincase.sql.org 2008-10-15 23:58:18.000000000 +0800 |
| 154 | +++ maincase.sql 2008-10-16 00:29:51.000000000 +0800 |
| 155 | @@ -1,13 +1,13 @@ |
| 156 | CREATE TABLE maincase ( |
| 157 | - int(11) auto_increment int(11) auto_increment NOT NULL, |
| 158 | + serial int(11) auto_increment NOT NULL, |
| 159 | name varchar(60) NOT NULL, |
| 160 | description varchar(255), |
| 161 | storage_desc varchar(50), |
| 162 | quality bool NOT NULL, |
| 163 | handle_level smallint NOT NULL, |
| 164 | handle_desc varchar(40), |
| 165 | - location1 point NOT NULL, |
| 166 | - location2 point, |
| 167 | + location1 varchar(50) NOT NULL, |
| 168 | + location2 varchar(50), |
| 169 | can_supply bool NOT NULL, |
| 170 | take_free bool NOT NULL, |
| 171 | owner varchar(10), |
| 172 | @@ -15,13 +15,13 @@ |
| 173 | taker varchar(10), |
| 174 | taker_org varchar(15), |
| 175 | website text, |
| 176 | - start_time timestamp NOT NULL, |
| 177 | - end_time timestamp NOT NULL, |
| 178 | + start_time timestamp, |
| 179 | + end_time timestamp, |
| 180 | user_id smallint NOT NULL, |
| 181 | checked bool DEFAULT 0 NOT NULL, |
| 182 | - insert_time timestamp DEFAULT CURRENT_TIMESTAMP, |
| 183 | + insert_time timestamp, |
| 184 | cover bool DEFAULT 0 NOT NULL |
| 185 | -, PRIMARY KEY(`int(11)`) |
| 186 | +, PRIMARY KEY(`serial`) |
| 187 | ) TYPE=MyISAM; |