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