1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- $Horde: horde/scripts/sql/horde_groups.mysql.sql,v 1.1.2.2 2008/04/28 03:24:02 chuck Exp $
CREATE TABLE horde_groups (
group_uid INT(10) UNSIGNED NOT NULL,
group_name VARCHAR(255) NOT NULL,
group_parents VARCHAR(255) NOT NULL,
group_email VARCHAR(255),
PRIMARY KEY (group_uid),
UNIQUE KEY group_name (group_name)
);
CREATE TABLE horde_groups_members (
group_uid INT(10) UNSIGNED NOT NULL,
user_uid VARCHAR(255) NOT NULL
);
CREATE INDEX group_uid_idx ON horde_groups_members (group_uid);
CREATE INDEX user_uid_idx ON horde_groups_members (user_uid);
|
