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