
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'
 --




