1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
INSERT OR REPLACE INTO regions VALUES
('Valriel', 'ALL', 0.25),
('Gorokh', 'ALL', 0.25),
('Devourers', 'ALL', 0.25),
('Sorig', 'ALL', 0.25),
('Ruggilli', 'ALL', 0.25),
('Ixalovh', 'ALL', 0.25),
('Gaea', 'ALL', 0.25),
('Valkyrie', 'ALL', 0.25),
('Mostrai', 'ALL', 0.25),
('Lythander', 'ALL', 0.25),
('Gnarg', 'ALL', 0.25);
INSERT OR REPLACE INTO relations VALUES
('Valriel', 'angel', 10),
('Valriel', 'demon', -1),
('Gorokh', 'demon', 10),
('Gorokh', 'angel', -1),
('Devourers', 'undead', 10),
('Devourers', 'none', -1),
('Sorig', 'air_elemental', 10),
('Sorig', 'none', -1),
('Ruggilli', 'consuming_fire_creatures', 10),
('Ruggilli', 'chaotic_water_creatures', -1),
('Ixalovh', 'chaotic_water_creatures', 10),
('Ixalovh', 'consuming_fire_creatures', -1),
('Gaea', 'animal', 10),
('Gaea', 'bird', 10),
('Gaea', 'slime', 10),
('Gaea', 'insect', 10),
('Gaea', 'reptile', 10),
('Gaea', 'water_elemental', 10),
('Gaea', 'earth_elemental', 10),
('Gaea', 'air_elemental', 10),
('Gaea', 'fire_elemental', 10),
('Gaea', 'undead', -1),
('Gaea', 'unnatural', -1),
('Valkyrie', 'human', 10),
('Valkyrie', 'troll', 10),
('Valkyrie', 'unnatural', -1),
('Valkyrie', 'angel', -1),
('Valkyrie', 'demon', -1),
('Valkyrie', 'undead', -1),
('Mostrai', 'dwarf', 10),
('Mostrai', 'goblin', -1),
('Mostrai', 'giant', -1),
('Lythander', 'faerie', 10),
('Lythander', 'goblin', -1),
('Lythander', 'troll', -1),
('Gnarg', 'goblin', 10),
('Gnarg', 'giant', 10),
('Gnarg', 'troll', 10),
('Gnarg', 'faerie', -1),
('Gnarg', 'dwarf', -1);
|
