equal
deleted
inserted
replaced
5 name varchar(255) DEFAULT '' NOT NULL, |
5 name varchar(255) DEFAULT '' NOT NULL, |
6 PRIMARY KEY (id) |
6 PRIMARY KEY (id) |
7 ); |
7 ); |
8 |
8 |
9 CREATE INDEX index_users_name ON users(name); |
9 CREATE INDEX index_users_name ON users(name); |
|
10 |
|
11 CREATE TABLE preferences ( |
|
12 userid int NOT NULL, |
|
13 keywords_box int DEFAULT 5 not NULL, |
|
14 keywords_sort varchar(31) DEFAULT 'keyword' NOT NULL, |
|
15 keywords_reverse boolean DEFAULT FALSE NOT NULL, |
|
16 PRIMARY KEY (userid) |
|
17 ); |
10 |
18 |
11 -- |
19 -- |
12 -- Table structure for table 'bookmark' |
20 -- Table structure for table 'bookmark' |
13 -- |
21 -- |
14 CREATE TABLE bookmarks ( |
22 CREATE TABLE bookmarks ( |