|
1 -- |
|
2 |
|
3 CREATE TABLE users ( |
|
4 id int NOT NULL, |
|
5 name varchar(255) DEFAULT '' NOT NULL, |
|
6 full_name varchar(255) DEFAULT '', |
|
7 PRIMARY KEY (id) |
|
8 ); |
|
9 |
|
10 CREATE INDEX index_users_name ON users(name); |
|
11 |
|
12 CREATE TABLE preferences ( |
|
13 userid int NOT NULL, |
|
14 keywords_box int DEFAULT 5 not NULL, |
|
15 keywords_sort varchar(31) DEFAULT 'keyword' NOT NULL, |
|
16 keywords_reverse boolean DEFAULT FALSE NOT NULL, |
|
17 default_view int DEFAULT 0 not NULL, |
|
18 PRIMARY KEY (userid) |
|
19 ); |
|
20 |
|
21 -- |
|
22 -- Table structure for table 'bookmark' |
|
23 -- |
|
24 CREATE TABLE bookmarks ( |
|
25 id int NOT NULL, |
|
26 userid int NOT NULL, |
|
27 url varchar(1023) DEFAULT '' NOT NULL, |
|
28 name varchar(1023) DEFAULT '' NOT NULL, |
|
29 ldesc varchar(1023) DEFAULT '' NOT NULL, |
|
30 added date DEFAULT '1998-01-01' NOT NULL, |
|
31 PRIMARY KEY (id, userid) |
|
32 ); |
|
33 |
|
34 CREATE INDEX index_bookmarks_userid ON bookmarks(userid); |
|
35 |
|
36 -- |
|
37 -- Table structure for table 'keywords' |
|
38 -- |
|
39 CREATE TABLE keywords ( |
|
40 id int DEFAULT '0' NOT NULL, |
|
41 userid int DEFAULT '0' NOT NULL, |
|
42 name varchar(255) DEFAULT '' NOT NULL, |
|
43 PRIMARY KEY (id, userid) |
|
44 ); |
|
45 |
|
46 CREATE INDEX index_keywords_name ON keywords(userid, name); |
|
47 |
|
48 -- |
|
49 -- Cross reference table for linking keywords and bookmarks |
|
50 -- |
|
51 |
|
52 CREATE TABLE bookmarks_keywords ( |
|
53 bookmark int NOT NULL, |
|
54 keyword int DEFAULT '0' NOT NULL, |
|
55 userid int DEFAULT '0' NOT NULL, |
|
56 PRIMARY KEY (bookmark, keyword, userid) |
|
57 ); |
|
58 |
|
59 CREATE INDEX index_bkkw_kwuser ON bookmarks_keywords (keyword, userid); |
|
60 CREATE INDEX index_bkkw_user ON bookmarks_keywords (userid); |
|
61 CREATE INDEX index_bkkw_bkuser ON bookmarks_keywords (bookmark, userid); |
|
62 |
|
63 -- |
|
64 -- Folders structure |
|
65 -- |
|
66 |
|
67 CREATE TABLE folders ( |
|
68 id int DEFAULT '0' NOT NULL, |
|
69 userid int DEFAULT '0' NOT NULL, |
|
70 keyword int DEFAULT '0' NOT NULL, |
|
71 parent int DEFAULT '0' NOT NULL, |
|
72 PRIMARY KEY (id, userid) |
|
73 ); |
|
74 |
|
75 CREATE INDEX index_folders_parent ON folders (userid, parent); |
|
76 |
|
77 -- |
|
78 -- Table structure for table 'db_sequence' |
|
79 -- |
|
80 CREATE TABLE db_sequence ( |
|
81 seq_name varchar(30) DEFAULT '' NOT NULL, |
|
82 userid int DEFAULT '0' NOT NULL, |
|
83 nextid int DEFAULT '0' NOT NULL, |
|
84 PRIMARY KEY (seq_name, userid) |
|
85 ); |
|
86 |
|
87 INSERT INTO db_sequence (seq_name, userid, nextid) VALUES ('users' , -1, 0); |