diff -r 87f94936990d -r c81d480c3224 lib/create_db.sql --- a/lib/create_db.sql Fri Oct 17 15:05:17 2003 -0400 +++ b/lib/create_db.sql Sat Oct 18 00:56:42 2003 -0400 @@ -59,6 +59,20 @@ CREATE INDEX index_bkkw_user ON bookmarks_keywords (userid); CREATE INDEX index_bkkw_bkuser ON bookmarks_keywords (bookmark, userid); +-- +-- Folders structure +-- + +CREATE TABLE folders ( + id int DEFAULT '0' NOT NULL, + userid int DEFAULT '0' NOT NULL, + keyword int DEFAULT '0' NOT NULL, + parent int DEFAULT '0' NOT NULL, + PRIMARY KEY (id, userid) +); + +CREATE INDEX index_folders_parent ON folders (userid, parent); + -- -- Table structure for table 'db_sequence' --