mirror of
https://github.com/house-of-vanity/doka2_info_bot.git
synced 2025-07-06 08:34:08 +00:00
37 lines
853 B
SQL
37 lines
853 B
SQL
BEGIN TRANSACTION;
|
|
CREATE TABLE IF NOT EXISTS "heroes" (
|
|
"name" TEXT NOT NULL,
|
|
PRIMARY KEY("name")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "patches" (
|
|
"version" TEXT NOT NULL,
|
|
"release_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY("version")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "items" (
|
|
"name" TEXT NOT NULL,
|
|
PRIMARY KEY("name")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "hero_changes" (
|
|
"type" TEXT NOT NULL,
|
|
"patch" INT NOT NULL,
|
|
"hero" INT NOT NULL,
|
|
"info" TEXT NOT NULL,
|
|
"meta" TEXT,
|
|
PRIMARY KEY("hero", "patch", "info")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "item_changes" (
|
|
"patch" INT NOT NULL,
|
|
"item" INT NOT NULL,
|
|
"info" TEXT NOT NULL,
|
|
"meta" TEXT,
|
|
PRIMARY KEY("item", "patch", "info")
|
|
);
|
|
CREATE TABLE IF NOT EXISTS "general_changes" (
|
|
"patch" INT NOT NULL,
|
|
"info" TEXT NOT NULL,
|
|
"meta" TEXT,
|
|
PRIMARY KEY("patch", "info")
|
|
);
|
|
COMMIT;
|