T mods
F mod text read
A pkey

T repos
F id serial system
A pkey
F side text write
A notnull
F name text write
A notnull
F ownr text write
A notnull
F publ bool write
A notnull
F nname text write
A notnull
F creat date read
A notnull
F dscr text write
A notnull
F lock bool write
A notnull
F wtch bool write
A notnull

T paths
F id serial system
A pkey
F rid int write
A notnull
A fkey repos id
F path text write
A notnull
D
F publ bool write
A notnull

T rights
F id serial system
A pkey
F pid int write
A notnull
F rid int write
A notnull
A fkey paths id
F mod text write
A fkey mods mod
A notnull
F man bool write
A notnull
F wat bool write
A notnull

T guests
F id     serial system
A pkey
F login  text write
A notnull
F passwd text write
A notnull
F name   text write
A notnull
F email  text write
A notnull
F parent text write
A notnull
F creat  text write
A notnull
F nwmail text write
A notnull
F nwcode text write
A notnull

T stats
F id serial system
A pkey
F rid int write
A notnull
A fkey repos id
F rev int write
A notnull
F size int write
A notnull
F date text write
A notnull
F time int write
A notnull

T tots
F id serial system
A pkey
F size int write
A notnull
F count int write
A notnull
F date text write
A notnull
F time int write
A notnull

T groups
F gid serial system
A pkey
F name text write
A notnull
F ownr text write
A notnull
F creat date read
A notnull

T gr_mem
F id serial system
A pkey
F pid int write
A notnull
F gid int write
A notnull
A fkey groups gid
F mem bool write
A notnull
F man bool write
A notnull

T xusers
F id serial system
A pkey
F pid int write
A notnull
A unique

T roots
F pid text write
A pkey
F actv bool write
A notnull
D 0