1CREATE TABLE user ( 2 uid integer not null primary key, 3 login text not null, 4 pass text not null, 5 fullname text not null default '', 6 email text not null default '', 7 unique(login), 8 unique(email) 9); 10 11CREATE TABLE groups ( 12 gid integer not null primary key, 13 name text not null, 14 unique(name) 15); 16 17CREATE TABLE usergroup ( 18 uid integer not null, 19 gid integer not null, 20 animal text not null default '', 21 primary key (uid, gid, animal) 22); 23 24