| 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; |
