--
-- init.sql -- initialize database
--
-- Copyright (c) 2020-2023 David Demelier <markand@malikania.fr>
--
-- Permission to use, copy, modify, and/or distribute this software for any
-- purpose with or without fee is hereby granted, provided that the above
-- copyright notice and this permission notice appear in all copies.
--
-- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
-- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
-- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
-- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
-- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
-- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
-- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
--

BEGIN EXCLUSIVE TRANSACTION;

CREATE TABLE IF NOT EXISTS property(
	id              INTEGER PRIMARY KEY AUTOINCREMENT,
	key             TEXT NOT NULL UNIQUE,
	value           TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS character(
	name            TEXT PRIMARY KEY,
	hp              INTEGER NOT NULL,
	mp              INTEGER NOT NULL,
	level           INTEGER NOT NULL,
	team_order      INTEGER DEFAULT -1,
	bonus_hp        INTEGER DEFAULT 0,
	bonus_mp        INTEGER DEFAULT 0,
	bonus_atk       INTEGER DEFAULT 0,
	bonus_def       INTEGER DEFAULT 0,
	bonus_agt       INTEGER DEFAULT 0,
	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'));

COMMIT;