|
1 -- |
|
2 -- Table structure for table 'bookmark' |
|
3 -- |
|
4 CREATE TABLE bookmarks ( |
|
5 id int NOT NULL, |
|
6 url varchar(255) DEFAULT '' NOT NULL, |
|
7 name varchar(255) DEFAULT '' NOT NULL, |
|
8 ldesc varchar(255) DEFAULT '' NOT NULL, |
|
9 added date DEFAULT '1998-01-01' NOT NULL, |
|
10 PRIMARY KEY (id) |
|
11 ); |
|
12 |
|
13 -- |
|
14 -- Table structure for table 'keywords' |
|
15 -- |
|
16 CREATE TABLE keywords ( |
|
17 id int DEFAULT '0' NOT NULL, |
|
18 name varchar(30) DEFAULT '' NOT NULL, |
|
19 PRIMARY KEY (id) |
|
20 ); |
|
21 |
|
22 -- |
|
23 -- Default nil keyword |
|
24 -- |
|
25 |
|
26 INSERT INTO keywords(id, name) VALUES (0, '--'); |
|
27 |
|
28 -- |
|
29 -- Cross reference table for linking keywords and bookmarks |
|
30 -- |
|
31 |
|
32 CREATE TABLE bookmarks_keywords ( |
|
33 bookmark int NOT NULL, |
|
34 keyword int DEFAULT '0' NOT NULL, |
|
35 PRIMARY KEY (bookmark, keyword) |
|
36 ); |
|
37 |
|
38 CREATE INDEX bkkw_kw_idx ON bookmarks_keywords (keyword); |
|
39 |
|
40 -- |
|
41 -- Table structure for table 'db_sequence' |
|
42 -- |
|
43 CREATE TABLE db_sequence ( |
|
44 seq_name varchar(30) DEFAULT '' NOT NULL, |
|
45 nextid int DEFAULT '0' NOT NULL, |
|
46 PRIMARY KEY (seq_name) |
|
47 ); |
|
48 |
|
49 INSERT INTO db_sequence (seq_name, nextid) VALUES ('bookmarks', 0); |
|
50 INSERT INTO db_sequence (seq_name, nextid) VALUES ('keywords' , 1); |