You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

39 lines
631 B

CREATE TABLE IF NOT EXISTS quests(
chat_id int NOT NULL,
qid int NOT NULL,
name varchar(255),
difficulty int,
importance int,
state int DEFAULT 0,
UNIQUE(chat_id, qid)
);
CREATE TABLE IF NOT EXISTS side_quests(
chat_id int NOT NULL,
qid int NOT NULL,
name varchar(255),
difficulty int,
importance int,
state int DEFAULT 0,
UNIQUE(chat_id, qid)
);
CREATE TABLE IF NOT EXISTS points(
chat_id int PRIMARY KEY,
points int
);
CREATE TABLE IF NOT EXISTS state(
chat_id int PRIMARY KEY,
state varchar(10),
extra varchar(10)
);
CREATE TABLE IF NOT EXISTS tokens(
chat_id int,
token varchar(36) PRIMARY KEY
);