DATABASE.sql

create table if not exists banlist
(
	id bigint not null
		constraint banlist_pkey
			primary key,
	reason text not null,
	date timestamp not null,
	message text
);

alter table banlist owner to jonas;

create table if not exists strafanzeigen
(
	key text not null
		constraint strafanzeigen_pkey
			primary key,
	data text not null,
	creation_date timestamp default now()
);

alter table strafanzeigen owner to jonas;

create table if not exists chats
(
	id bigint not null
		constraint chats_pkey
			primary key,
	tags jsonb not null,
	permissions jsonb,
	locked boolean default false
);

alter table chats owner to jonas;

create table if not exists blacklists.bio
(
	id serial not null
		constraint bio_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.bio owner to jonas;

create table if not exists blacklists.string
(
	id serial not null
		constraint string_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.string owner to jonas;

create table if not exists blacklists.channel
(
	id serial not null
		constraint channel_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.channel owner to jonas;

create table if not exists blacklists.domain
(
	id serial not null
		constraint domain_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.domain owner to jonas;

create table if not exists blacklists.file
(
	id serial not null
		constraint file_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.file owner to jonas;

create table if not exists blacklists.mhash
(
	id serial not null
		constraint mhash_pkey
			primary key,
	item text not null,
	retired boolean default false
);

alter table blacklists.mhash owner to jonas;

create table if not exists templates
(
	name text
		constraint templates_name_key
			unique,
	content text
);

alter table templates owner to jonas;

create table if not exists whitelist
(
	id integer not null
		constraint id
			primary key
);

alter table whitelist owner to jonas;

create table if not exists adderlist
(
	uid integer not null
		constraint adderlist_pk
			primary key,
	count integer,
	modify_date timestamp default now()
);

alter table adderlist owner to jonas;

create table if not exists cute_chain
(
	uid integer not null
		constraint cute_chain_pk
			primary key,
	loved_by integer not null
);

alter table cute_chain owner to jonas;

create table if not exists users
(
	tg_id bigint not null
		constraint users_pkey
			primary key,
	first_name text,
	f915068391_hash text,
	f357693014_hash text,
	f778274583_hash text,
	f1102450249_hash text,
	f358491576_hash text,
	f1175015621_hash text
);

alter table users owner to jonas;

create table if not exists wordlist
(
	word text not null
		constraint word
			primary key,
	count integer
);

alter table wordlist owner to jonas;

create table if not exists adding_list
(
	adder_id integer,
	added_id integer,
	chat_id integer,
	raw_update text
);

alter table adding_list owner to jonas;

create unique index if not exists adding_list_raw_update_uindex
	on adding_list (raw_update);