equal
deleted
inserted
replaced
12 CREATE TABLE preferences ( |
12 CREATE TABLE preferences ( |
13 userid int NOT NULL, |
13 userid int NOT NULL, |
14 keywords_box int DEFAULT 5 not NULL, |
14 keywords_box int DEFAULT 5 not NULL, |
15 keywords_sort varchar(31) DEFAULT 'keyword' NOT NULL, |
15 keywords_sort varchar(31) DEFAULT 'keyword' NOT NULL, |
16 keywords_reverse boolean DEFAULT FALSE NOT NULL, |
16 keywords_reverse boolean DEFAULT FALSE NOT NULL, |
|
17 default_view int DEFAULT 0 not NULL, |
17 PRIMARY KEY (userid) |
18 PRIMARY KEY (userid) |
18 ); |
19 ); |
19 |
20 |
20 -- |
21 -- |
21 -- Table structure for table 'bookmark' |
22 -- Table structure for table 'bookmark' |