--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/lib/db/create_db.sql	Wed Dec 31 15:41:32 2008 -0500
@@ -0,0 +1,87 @@
+--
+
+CREATE TABLE users (
+  id int NOT NULL,
+  name varchar(255) DEFAULT '' NOT NULL,
+  full_name varchar(255) DEFAULT '',
+  PRIMARY KEY (id)
+);
+
+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,
+  default_view int DEFAULT 0 not NULL,
+  PRIMARY KEY (userid)
+);
+
+--
+-- Table structure for table 'bookmark'
+--
+CREATE TABLE bookmarks (
+  id int NOT NULL,
+  userid int NOT NULL,
+  url varchar(1023) DEFAULT '' NOT NULL,
+  name varchar(1023) DEFAULT '' NOT NULL,
+  ldesc varchar(1023) DEFAULT '' NOT NULL,
+  added date DEFAULT '1998-01-01' NOT NULL,
+  PRIMARY KEY (id, userid)
+);
+
+CREATE INDEX index_bookmarks_userid ON bookmarks(userid);
+
+--
+-- Table structure for table 'keywords'
+--
+CREATE TABLE keywords (
+  id int DEFAULT '0' NOT NULL,
+  userid int DEFAULT '0' NOT NULL,
+  name varchar(255) DEFAULT '' NOT NULL,
+  PRIMARY KEY (id, userid)
+);
+
+CREATE INDEX index_keywords_name ON keywords(userid, name);
+
+--
+-- Cross reference table for linking keywords and bookmarks
+--
+
+CREATE TABLE bookmarks_keywords (
+  bookmark int NOT NULL,
+  keyword int DEFAULT '0' NOT NULL,
+  userid int DEFAULT '0' NOT NULL,
+  PRIMARY KEY (bookmark, keyword, userid)
+);
+
+CREATE INDEX index_bkkw_kwuser ON bookmarks_keywords (keyword, userid);
+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'
+--
+CREATE TABLE db_sequence (
+  seq_name varchar(30)    DEFAULT '' NOT NULL,
+  userid int DEFAULT '0' NOT NULL,
+  nextid int DEFAULT '0' NOT NULL,
+  PRIMARY KEY (seq_name, userid)
+);
+
+INSERT INTO db_sequence (seq_name, userid, nextid) VALUES ('users' , -1, 0);