Mercurial > molko

annotate libmlk-rpg/assets/sql/init.sql @ 494:35cc5d51bcb2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
ui: notify -> mlk_notify
author David Demelier <markand@malikania.fr>
date Tue, 28 Feb 2023 13:32:01 +0100
parents 773a082f0b91
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
173
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 --
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
2 -- init.sql -- initialize database
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 --
445
773a082f0b91 misc: update copyright years
David Demelier <markand@malikania.fr>
parents: 434
diff changeset
4 -- Copyright (c) 2020-2023 David Demelier <markand@malikania.fr>
173
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 --
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
6 -- Permission to use, copy, modify, and/or distribute this software for any
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
7 -- purpose with or without fee is hereby granted, provided that the above
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
8 -- copyright notice and this permission notice appear in all copies.
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
9 --
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
17 --
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
18
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
19 BEGIN EXCLUSIVE TRANSACTION;
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
20
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
21 CREATE TABLE IF NOT EXISTS property(
281
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
22 id INTEGER PRIMARY KEY AUTOINCREMENT,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
23 key TEXT NOT NULL UNIQUE,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
24 value TEXT NOT NULL
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
25 );
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
26
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
27 CREATE TABLE IF NOT EXISTS character(
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
28 name TEXT PRIMARY KEY,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
29 hp INTEGER NOT NULL,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
30 mp INTEGER NOT NULL,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
31 level INTEGER NOT NULL,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
32 team_order INTEGER DEFAULT -1,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
33 bonus_hp INTEGER DEFAULT 0,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
34 bonus_mp INTEGER DEFAULT 0,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
35 bonus_atk INTEGER DEFAULT 0,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
36 bonus_def INTEGER DEFAULT 0,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
37 bonus_agt INTEGER DEFAULT 0,
87b8c7510717 rpg: implement load/save for characters
David Demelier <markand@malikania.fr>
parents: 243
diff changeset
38 bonus_luck INTEGER DEFAULT 0
173
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
39 );
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
40
330
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
41 CREATE TABLE IF NOT EXISTS quest(
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
42 name TEXT PRIMARY KEY
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
43 );
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
44
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
45 CREATE TABLE IF NOT EXISTS quest_step(
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
46 name TEXT PRIMARY KEY,
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
47 percent INTEGER DEFAULT 0,
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
48 quest_name TEXT NOT NULL,
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
49 FOREIGN KEY(quest_name) REFERENCES quest(name)
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
50 );
e0657709fbe3 rpg: add support for basic quests
David Demelier <markand@malikania.fr>
parents: 320
diff changeset
51
173
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
52 INSERT OR IGNORE INTO property(key, value) VALUES ('molko.create-date', strftime('%s','now'));
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
53 INSERT OR IGNORE INTO property(key, value) VALUES ('molko.update-date', strftime('%s','now'));
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
54
cd69c8791dac core: forgot to add .sql files
David Demelier <markand@malikania.fr>
parents:
diff changeset
55 COMMIT;