src/static/dbSchemas/postgres_schema.sql

CREATE TABLE files
(
    id           INT PRIMARY key GENERATED BY DEFAULT AS identity,
    hash         text    NOT NULL,
    originalname text    NOT NULL,
    filename     text    NOT NULL,
    size         integer not null,
    date         integer not null,
    ip           text    null
);

CREATE TABLE blacklist
(
    id           INT PRIMARY key GENERATED BY DEFAULT AS identity,
    hash         text    NOT NULL,
    originalname text    NULL,
    time         integer null,
    ip           text    null
);

CREATE TABLE ratelimit
(
    id     INT PRIMARY key GENERATED BY DEFAULT AS identity,
    iphash text    NOT NULL,
    files  integer not null,
    time   integer not null
);

CREATE TABLE accounts
(
    id    INT PRIMARY key GENERATED BY DEFAULT AS identity,
    email text    NOT NULL,
    pass  text    not null,
    level integer not null
);
Commit	Line	Data
	1	CREATE TABLE files
	2	(
	3	id INT PRIMARY key GENERATED BY DEFAULT AS identity,
	4	hash text NOT NULL,
	5	originalname text NOT NULL,
	6	filename text NOT NULL,
	7	size integer not null,
	8	date integer not null,
	9	ip text null
	10	);
	11
	12	CREATE TABLE blacklist
	13	(
	14	id INT PRIMARY key GENERATED BY DEFAULT AS identity,
	15	hash text NOT NULL,
	16	originalname text NULL,
	17	time integer null,
	18	ip text null
	19	);
	20
	21	CREATE TABLE ratelimit
	22	(
	23	id INT PRIMARY key GENERATED BY DEFAULT AS identity,
	24	iphash text NOT NULL,
	25	files integer not null,
	26	time integer not null
	27	);
	28
	29	CREATE TABLE accounts
	30	(
	31	id INT PRIMARY key GENERATED BY DEFAULT AS identity,
	32	email text NOT NULL,
	33	pass text not null,
	34	level integer not null
	35	);