Mercurial > molko
diff src/libmlk-rpg/assets/sql/init.sql @ 330:e0657709fbe3
rpg: add support for basic quests
author | David Demelier <markand@malikania.fr> |
---|---|
date | Wed, 06 Oct 2021 13:54:16 +0200 |
parents | 8f9937403749 |
children | 460c78706989 |
line wrap: on
line diff
--- a/src/libmlk-rpg/assets/sql/init.sql Mon Oct 04 13:30:09 2021 +0200 +++ b/src/libmlk-rpg/assets/sql/init.sql Wed Oct 06 13:54:16 2021 +0200 @@ -38,6 +38,17 @@ bonus_luck INTEGER DEFAULT 0 ); +CREATE TABLE IF NOT EXISTS quest( + name TEXT PRIMARY KEY +); + +CREATE TABLE IF NOT EXISTS quest_step( + name TEXT PRIMARY KEY, + percent INTEGER DEFAULT 0, + quest_name TEXT NOT NULL, + FOREIGN KEY(quest_name) REFERENCES quest(name) +); + INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now')); INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now'));