--

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,

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