diff -r ab20799fef27 -r c30e2402deca lib/create_db.sql --- 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' --