--- a/lib/create_db.sql	Tue Oct 07 11:10:52 2003 -0400
+++ b/lib/create_db.sql	Tue Oct 07 12:50:30 2003 -0400
@@ -8,6 +8,14 @@
 
 CREATE INDEX index_users_name ON users(name);
 
+CREATE TABLE preferences (
+  userid int NOT NULL,
+  keywords_box int DEFAULT 5 not NULL,
+  keywords_sort varchar(31) DEFAULT 'keyword' NOT NULL,
+  keywords_reverse boolean DEFAULT FALSE NOT NULL,
+  PRIMARY KEY (userid)
+);
+
 --
 -- Table structure for table 'bookmark'
 --