modules/bookmarks/bookmarks.mysql

CREATE TABLE bookmarks (
  uid INT UNSIGNED NOT NULL,
  url VARCHAR(128) NOT NULL,
  title VARCHAR(128) NOT NULL
);

ALTER TABLE bookmarks ADD INDEX (uid);
ALTER TABLE bookmarks ADD fid mediumint(9) unsigned NOT NULL;
ALTER TABLE bookmarks ADD options tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE bookmarks ADD INDEX (fid);

CREATE TABLE bookmarks_folders (
  fid mediumint(8) unsigned NOT NULL auto_increment,
  f_parent_id mediumint(8) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  `name` varchar(128) NOT NULL,
  options tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (fid),
  KEY uid (uid),
  KEY f_parent_id (f_parent_id)
) COMMENT='options are binary math: 1-expanded by default';

CREATE TABLE bookmarks_prefs (
  uid int(10) unsigned NOT NULL,
  options tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid)
) COMMENT='options are binary math: 1-title is link';
1	CREATE TABLE bookmarks (
2	uid INT UNSIGNED NOT NULL,
3	url VARCHAR(128) NOT NULL,
4	title VARCHAR(128) NOT NULL
5	);
6
7	ALTER TABLE bookmarks ADD INDEX (uid);
8	ALTER TABLE bookmarks ADD fid mediumint(9) unsigned NOT NULL;
9	ALTER TABLE bookmarks ADD options tinyint(3) unsigned NOT NULL default '0';
10	ALTER TABLE bookmarks ADD INDEX (fid);
11
12	CREATE TABLE bookmarks_folders (
13	fid mediumint(8) unsigned NOT NULL auto_increment,
14	f_parent_id mediumint(8) unsigned NOT NULL default '0',
15	uid int(10) unsigned NOT NULL default '0',
16	`name` varchar(128) NOT NULL,
17	options tinyint(3) unsigned NOT NULL default '0',
18	PRIMARY KEY (fid),
19	KEY uid (uid),
20	KEY f_parent_id (f_parent_id)
21	) COMMENT='options are binary math: 1-expanded by default';
22
23	CREATE TABLE bookmarks_prefs (
24	uid int(10) unsigned NOT NULL,
25	options tinyint(3) unsigned NOT NULL default '0',
26	PRIMARY KEY (uid)
27	) COMMENT='options are binary math: 1-title is link';