--

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,
  default_view int DEFAULT 0 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);