
diff -r c078d8a04d76 -r 6784c4350b41 lib/create_db.sql
--- a/lib/create_db.sql	Wed Dec 31 01:53:22 2008 -0500
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,87 +0,0 @@
---
-
-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);




