· 9 years ago · Dec 15, 2016, 10:38 AM
1--==========================================================================================================================
2-- SUZERAIN TRAITS
3--==========================================================================================================================
4-- Suk_SuzerainTrait
5--==========================================================================================================================
6CREATE TABLE IF NOT EXISTS
7 Suk_SuzerainTrait (
8 ID integer primary key autoincrement,
9 Type text default null,
10 MinorCivType text REFERENCES MinorCivilizations(Type) default null,
11 Description text default null,
12 IconAtlas text REFERENCES IconTextureAtlases(Atlas) default null,
13 PortraitIndex text default null,
14 BackgroundImage text default null;
15--------------------------------------------------------------------------------------------------------------------------
16-- Suk_SuzerainTrait_FreePolicy
17--------------------------------------------------------------------------------------------------------------------------
18CREATE TABLE IF NOT EXISTS
19 Suk_SuzerainTrait_FreePolicy (
20 SuzerainTraitType text REFERENCES Suk_SuzerainTrait(Type) default null,
21 PolicyType text REFERENCES Policies(Type) default null;
22--------------------------------------------------------------------------------------------------------------------------
23-- Suk_SuzerainTrait_FreeUnit
24--------------------------------------------------------------------------------------------------------------------------
25CREATE TABLE IF NOT EXISTS
26 Suk_SuzerainTrait_FreeUnit (
27 SuzerainTraitType text REFERENCES Suk_SuzerainTrait(Type) default null,
28 UnitType text REFERENCES Units(Type) default null,
29 Interval integer default 0;
30--------------------------------------------------------------------------------------------------------------------------
31-- Suk_SuzerainTrait_FreeUnitClass
32--------------------------------------------------------------------------------------------------------------------------
33CREATE TABLE IF NOT EXISTS
34 Suk_SuzerainTrait_FreeUnitClass (
35 SuzerainTraitType text REFERENCES Suk_SuzerainTrait(Type) default null,
36 UnitClassType text REFERENCES UnitClasses(Type) default null,
37 Interval integer default 0;
38--------------------------------------------------------------------------------------------------------------------------
39-- Suk_SuzerainTrait_FreeCombatClass
40--------------------------------------------------------------------------------------------------------------------------
41CREATE TABLE IF NOT EXISTS
42 Suk_SuzerainTrait_FreeCombatClass (
43 SuzerainTraitType text REFERENCES Suk_SuzerainTrait(Type) default null,
44 CombatClassType text REFERENCES UnitCombatInfos(Type) default null,
45 Interval integer default 0;
46--==========================================================================================================================
47--==========================================================================================================================