1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
-- $Horde: horde/scripts/db/category.sql,v 1.2.2.8 2002/03/11 19:31:35 chuck Exp $
CREATE TABLE horde_categories (
category_id INT not null,
group_uid VARCHAR(255) not null,
user_uid VARCHAR(255) not null,
category_name VARCHAR(255) not null,
-- There is no portable way to do this apparently. If your db doesn't allow varchars
-- greater than 255 characters, then maybe it allows TEXT columns, so try the second
-- line.
category_data VARCHAR(2048),
-- category_data TEXT,
category_serialized SMALLINT DEFAULT 0 not null,
category_updated TIMESTAMP,
PRIMARY KEY (category_id)
);
CREATE INDEX category_category_name_idx ON horde_categories (category_name);
CREATE INDEX category_group_idx ON horde_categories (group_uid);
CREATE INDEX category_user_idx ON horde_categories (user_uid);
CREATE INDEX category_serialized_idx ON horde_categories (category_serialized);
CREATE TABLE horde_categories_categories (
category_id_parent INT not null,
category_id_child INT not null,
PRIMARY KEY (category_id_parent, category_id_child)
);
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories TO @dbuser@;
GRANT SELECT, INSERT, UPDATE, DELETE ON horde_categories_categories TO @dbuser@;
|
