
diff -r 000000000000 -r a4c49a0c313b lib/create_db.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/lib/create_db.sql	Tue Sep 23 09:00:02 2003 -0400
@@ -0,0 +1,50 @@
+--
+-- Table structure for table 'bookmark'
+--
+CREATE TABLE bookmarks (
+  id int NOT NULL,
+  url varchar(255) DEFAULT '' NOT NULL,
+  name varchar(255) DEFAULT '' NOT NULL,
+  ldesc varchar(255) DEFAULT '' NOT NULL,
+  added date DEFAULT '1998-01-01' NOT NULL,
+  PRIMARY KEY (id)
+);
+
+--
+-- Table structure for table 'keywords'
+--
+CREATE TABLE keywords (
+  id int DEFAULT '0' NOT NULL,
+  name varchar(30) DEFAULT '' NOT NULL,
+  PRIMARY KEY (id)
+);
+
+--
+-- Default nil keyword
+--
+
+INSERT INTO keywords(id, name) VALUES (0, '--');
+
+--
+-- Cross reference table for linking keywords and bookmarks
+--
+
+CREATE TABLE bookmarks_keywords (
+  bookmark int NOT NULL,
+  keyword int DEFAULT '0' NOT NULL,
+  PRIMARY KEY (bookmark, keyword)
+);
+
+CREATE INDEX bkkw_kw_idx ON bookmarks_keywords (keyword);
+
+--
+-- Table structure for table 'db_sequence'
+--
+CREATE TABLE db_sequence (
+  seq_name varchar(30)    DEFAULT '' NOT NULL,
+  nextid int DEFAULT '0' NOT NULL,
+  PRIMARY KEY (seq_name)
+);
+
+INSERT INTO db_sequence (seq_name, nextid) VALUES ('bookmarks', 0);
+INSERT INTO db_sequence (seq_name, nextid) VALUES ('keywords' , 1);




