forked from .cyb/cyberman
53 lines
1.2 KiB
SQL
53 lines
1.2 KiB
SQL
drop table if exists cyberman;
|
|
create table cyberman (
|
|
id integer primary key,
|
|
dbrev integer not null,
|
|
intserial integer not null default 1,
|
|
lastserial integer not null default 0,
|
|
zonecheckstatus integer not null default 0,
|
|
);
|
|
insert into cyberman (dbrev) values (10);
|
|
|
|
drop table if exists user;
|
|
create table user (
|
|
id integer primary key,
|
|
email text not null,
|
|
password text not null,
|
|
salt text not null,
|
|
active integer not null default 0,
|
|
conftoken text not null,
|
|
newemail text,
|
|
recoverytoken text,
|
|
stylesheet text,
|
|
admin integer not null default 0,
|
|
email_pub integer not null default 0,
|
|
whois_name text
|
|
);
|
|
|
|
drop table if exists session;
|
|
create table session (
|
|
id integer primary key,
|
|
uid integer not null,
|
|
since integer not null,
|
|
token text not null
|
|
);
|
|
|
|
drop table if exists domain;
|
|
create table domain (
|
|
id integer primary key,
|
|
name string not null,
|
|
ownerid integer not null,
|
|
lastsid integer not null default 0,
|
|
since integer not null default 1503187200
|
|
);
|
|
|
|
drop table if exists record;
|
|
create table record (
|
|
id integer primary key,
|
|
sid integer not null,
|
|
domainid integer not null,
|
|
type string not null,
|
|
name string not null,
|
|
value string not null
|
|
);
|