Mercurial > malikania

annotate libmlk-db/script/init.sql @ 215:268b66d72ec0 default tip @

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
misc: remove Javascript bindings, closes #2402
author David Demelier <markand@malikania.fr>
date Thu, 10 Oct 2019 13:52:57 +0200
parents 9ef01392a7f1
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
199
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 --
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
2 -- init.sql -- initialize database
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 --
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
4 -- Copyright (c) 2013-2018 David Demelier <markand@malikania.fr>
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 --
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
6 -- Permission to use, copy, modify, and/or distribute this software for any
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
7 -- purpose with or without fee is hereby granted, provided that the above
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
8 -- copyright notice and this permission notice appear in all copies.
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
9 --
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
10 -- THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
11 -- WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
12 -- MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
13 -- ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
14 -- WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
15 -- ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
16 -- OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
17 --
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
18
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
19 CREATE TABLE IF NOT EXISTS account(
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
20 id SERIAL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
21 login TEXT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
22 password TEXT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
23 firstname TEXT,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
24 lastname TEXT,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
25 email TEXT,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
26 PRIMARY KEY(id)
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
27 );
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
28
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
29 CREATE TABLE IF NOT EXISTS character(
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
30 id SERIAL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
31 account_id INTEGER NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
32 nickname TEXT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
33 type TEXT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
34 hp_level SMALLINT NOT NULL DEFAULT 1,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
35 hp_factor SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
36 hp_exp INT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
37 force_level SMALLINT NOT NULL DEFAULT 1,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
38 force_factor SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
39 force_exp INT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
40 defense_level SMALLINT NOT NULL DEFAULT 1,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
41 defense_factor SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
42 defense_exp INT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
43 agility_level SMALLINT NOT NULL DEFAULT 1,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
44 agility_factor SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
45 agility_exp INT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
46 luck_level SMALLINT NOT NULL DEFAULT 1,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
47 luck_factor SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
48 luck_exp INT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
49 PRIMARY KEY(id),
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
50 FOREIGN KEY (account_id) REFERENCES account(id) ON DELETE CASCADE
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
51 );
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
52
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
53 CREATE TABLE IF NOT EXISTS spell(
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
54 id SERIAL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
55 character_id INTEGER NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
56 type TEXT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
57 level SMALLINT NOT NULL,
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
58 PRIMARY KEY(id),
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
59 FOREIGN KEY (character_id) REFERENCES character(id) ON DELETE CASCADE
9ef01392a7f1 tests: make a database test fixture, closes #939 @4h
David Demelier <markand@malikania.fr>
parents:
diff changeset
60 );