+
−--
+
−-- 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);