11 create table xestiascan_users (
12 uid SERIAL PRIMARY KEY,
13 username varchar(64) UNIQUE NOT NULL,
14 salt varchar(512) NOT NULL,
15 password text NOT NULL,
16 name varchar(128) NOT NULL,
17 admin boolean NOT NULL,
18 enabled boolean NOT NULL
24 uid (linked to user table)
28 create table xestiascan_scanners (
30 scannerid varchar(256) NOT NULL,
31 enabled boolean NOT NULL
37 uid (linked to user table)
42 create table xestiascan_modules(
44 moduletype varchar(12) NOT NULL,
45 modulename varchar(256) NOT NULL,
46 enabled boolean NOT NULL
52 seed text(32) unique primary key not null,
53 username memo NOT NULL,
54 expires datetime NOT NULL
56 create table xestiascan_sessions(
57 seed varchar(32) UNIQUE PRIMARY KEY NOT NULL,
58 username text NOT NULL,
59 expires timestamp NOT NULL