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