xkPC3bRG

1DONT USE YET - MUST CHECK PK
2
3delimeter ;
4
5drop table if exists handles;
6
7create table handles
8(
9 feature_id mediumint unsigned not null, 
10 tag_id smallint unsigned not null,
11 checkout_ts datetime not null,
12 user_id mediumint unsigned default null,
13 checkin_ts datetime default null,
14 loadinfo_id smallint unsigned default null,
15 process_id mediumint unsigned default null,
16 request_ts datetime default null,
17 host_id smallint unsigned default null,
18 tokens smallint unsigned default null,
19 account_id smallint unsigned default null,
20 origin tinyint default null,
21 accounting_location_id smallint unsigned default 0,
22 primary key (feature_id, tag_id, checkout_ts)
23)
24engine=InnoDB 
25default charset=latin1 collate latin1_swedish_ci;