2022-12-30 17:04:27 +01:00
|
|
|
-- +migrate up
|
|
|
|
CREATE TABLE levels (
|
|
|
|
id SERIAL PRIMARY KEY,
|
|
|
|
created_at TEXT NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'now')),
|
|
|
|
modified_at TEXT NOT NULL DEFAULT (STRFTIME('%Y-%m-%d %H:%M:%f', 'now')),
|
|
|
|
|
2023-01-05 20:39:24 +01:00
|
|
|
name VARCHAR(20) NOT NULL,
|
|
|
|
user_id INTEGER NOT NULL references users(id),
|
|
|
|
description VARCHAR(140) NOT NULL DEFAULT "",
|
2022-12-30 17:04:27 +01:00
|
|
|
original INTEGER,
|
|
|
|
|
|
|
|
game_version INTEGER NOT NULL,
|
|
|
|
binary_version INTEGER NOT NULL,
|
|
|
|
|
|
|
|
password TEXT,
|
|
|
|
requested_stars INTEGER,
|
|
|
|
unlisted INTEGER NOT NULL DEFAULT 0,
|
|
|
|
|
|
|
|
version INTEGER NOT NULL DEFAULT 0,
|
|
|
|
extra_data BLOB NOT NULL,
|
|
|
|
level_info BLOB NOT NULL,
|
|
|
|
|
2023-01-03 07:14:02 +01:00
|
|
|
editor_time INTEGER NOT NULL,
|
|
|
|
editor_time_copies INTEGER NOT NULL,
|
2022-12-30 17:04:27 +01:00
|
|
|
|
|
|
|
song_id INTEGER NOT NULL,
|
|
|
|
|
|
|
|
length INTEGER NOT NULL,
|
|
|
|
objects INTEGER NOT NULL,
|
|
|
|
coins INTEGER NOT NULL DEFAULT 0,
|
|
|
|
has_ldm INTEGER NOT NULL DEFAULT 0,
|
|
|
|
two_player INTEGER NOT NULL DEFAULT 0,
|
|
|
|
|
2022-12-31 07:59:44 +01:00
|
|
|
downloads INTEGER NOT NULL DEFAULT 0,
|
|
|
|
likes INTEGER NOT NULL DEFAULT 0,
|
|
|
|
difficulty INTEGER,
|
|
|
|
community_difficulty INTEGER,
|
|
|
|
demon_difficulty INTEGER,
|
|
|
|
stars INTEGER,
|
|
|
|
featured INTEGER NOT NULL DEFAULT 0,
|
|
|
|
epic INTEGER NOT NULL DEFAULT 0,
|
|
|
|
rated_coins INTEGER NOT NULL DEFAULT 0
|
2022-12-30 17:04:27 +01:00
|
|
|
);
|
|
|
|
|
|
|
|
-- +migrate down
|
|
|
|
DROP TABLE levels;
|