Mercurial > molko
view libmlk-rpg/assets/sql/init.sql @ 564:e91f37da2992
core: doxygenize window
author | David Demelier <markand@malikania.fr> |
---|---|
date | Wed, 08 Mar 2023 20:09:21 +0100 |
parents | 773a082f0b91 |
children |
line wrap: on
line source
-- -- 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;