init-tables.sql

CREATE TABLE IF NOT EXISTS settings (id SERIAL PRIMARY KEY, data varchar);
CREATE TABLE IF NOT EXISTS people (uid bigint NOT NULL UNIQUE , fname text, lname text, uname text);
CREATE TABLE IF NOT EXISTS groups (gid bigint NOT NULL UNIQUE, title text);
CREATE TABLE IF NOT EXISTS logs (uid bigint, mid bigint NOT NULL, time varchar, content text, gid bigint, FOREIGN KEY(uid) REFERENCES people(uid), FOREIGN KEY(gid) REFERENCES groups(gid));
CREATE TABLE IF NOT EXISTS services (id INTEGER PRIMARY KEY, name varchar);
CREATE TABLE IF NOT EXISTS subscriptions (uid bigint NOT NULL, service INTEGER, FOREIGN KEY(uid) REFERENCES people(uid), FOREIGN KEY(service) REFERENCES services(id));
CREATE TABLE IF NOT EXISTS servicedays (id INTEGER, day varchar, FOREIGN KEY(id) REFERENCES services(id));
INSERT into groups (gid, title) VALUES(0, 'private');
INSERT into settings (data) VALUES(0);
INSERT into settings (data) VALUES('YOUR-TELEGRAM-BOT-TOKEN');
INSERT into services (id, name) VALUES(1, 'yemekhane');