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'));