equal
deleted
inserted
replaced
12 -- Table structure for table 'bookmark' |
12 -- Table structure for table 'bookmark' |
13 -- |
13 -- |
14 CREATE TABLE bookmarks ( |
14 CREATE TABLE bookmarks ( |
15 id int NOT NULL, |
15 id int NOT NULL, |
16 userid int NOT NULL, |
16 userid int NOT NULL, |
17 url varchar(255) DEFAULT '' NOT NULL, |
17 url varchar(1023) DEFAULT '' NOT NULL, |
18 name varchar(255) DEFAULT '' NOT NULL, |
18 name varchar(1023) DEFAULT '' NOT NULL, |
19 ldesc varchar(255) DEFAULT '' NOT NULL, |
19 ldesc varchar(1023) DEFAULT '' NOT NULL, |
20 added date DEFAULT '1998-01-01' NOT NULL, |
20 added date DEFAULT '1998-01-01' NOT NULL, |
21 PRIMARY KEY (id, userid) |
21 PRIMARY KEY (id, userid) |
22 ); |
22 ); |
23 |
23 |
24 CREATE INDEX index_bookmarks_userid ON bookmarks(userid); |
24 CREATE INDEX index_bookmarks_userid ON bookmarks(userid); |
27 -- Table structure for table 'keywords' |
27 -- Table structure for table 'keywords' |
28 -- |
28 -- |
29 CREATE TABLE keywords ( |
29 CREATE TABLE keywords ( |
30 id int DEFAULT '0' NOT NULL, |
30 id int DEFAULT '0' NOT NULL, |
31 userid int DEFAULT '0' NOT NULL, |
31 userid int DEFAULT '0' NOT NULL, |
32 name varchar(30) DEFAULT '' NOT NULL, |
32 name varchar(255) DEFAULT '' NOT NULL, |
33 PRIMARY KEY (id, userid) |
33 PRIMARY KEY (id, userid) |
34 ); |
34 ); |
35 |
35 |
36 CREATE INDEX index_keywords_name ON keywords(userid, name); |
36 CREATE INDEX index_keywords_name ON keywords(userid, name); |
37 |
37 |