1 -- --------------------------------------------------
3 -- --------------------------------------------------
6 -- Manage Client groups in bweb
7 -- Works with postgresql and mysql5
9 CREATE TABLE client_group
11 client_group_id serial not null,
12 client_group_name text not null,
13 primary key (client_group_id)
16 CREATE UNIQUE INDEX client_group_idx on client_group (client_group_name);
18 CREATE TABLE client_group_member
20 client_group_id integer not null,
21 clientid integer not null,
22 primary key (client_group_id, clientid)
25 CREATE INDEX client_group_member_idx on client_group_member (client_group_id);