equal
deleted
inserted
replaced
57 |
57 |
58 CREATE INDEX index_bkkw_kwuser ON bookmarks_keywords (keyword, userid); |
58 CREATE INDEX index_bkkw_kwuser ON bookmarks_keywords (keyword, userid); |
59 CREATE INDEX index_bkkw_user ON bookmarks_keywords (userid); |
59 CREATE INDEX index_bkkw_user ON bookmarks_keywords (userid); |
60 CREATE INDEX index_bkkw_bkuser ON bookmarks_keywords (bookmark, userid); |
60 CREATE INDEX index_bkkw_bkuser ON bookmarks_keywords (bookmark, userid); |
61 |
61 |
|
62 -- |
|
63 -- Folders structure |
|
64 -- |
|
65 |
|
66 CREATE TABLE folders ( |
|
67 id int DEFAULT '0' NOT NULL, |
|
68 userid int DEFAULT '0' NOT NULL, |
|
69 keyword int DEFAULT '0' NOT NULL, |
|
70 parent int DEFAULT '0' NOT NULL, |
|
71 PRIMARY KEY (id, userid) |
|
72 ); |
|
73 |
|
74 CREATE INDEX index_folders_parent ON folders (userid, parent); |
|
75 |
62 -- |
76 -- |
63 -- Table structure for table 'db_sequence' |
77 -- Table structure for table 'db_sequence' |
64 -- |
78 -- |
65 CREATE TABLE db_sequence ( |
79 CREATE TABLE db_sequence ( |
66 seq_name varchar(30) DEFAULT '' NOT NULL, |
80 seq_name varchar(30) DEFAULT '' NOT NULL, |