--

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