Duke William of Normandy
King of England & Unofficial Welcoming Committee
@robal1991 has just recently been posting new tables that have been discovered. From the code here, it seems like the February update is going to bring many changes to Barbarians and Tribes.
What are your thoughts?
Code:
CREATE TABLE "BarbarianTribe_MapConditions" (
"MapConditionSetType" TEXT NOT NULL,
"TerrainType" TEXT,
"FeatureType" TEXT,
"ResourceType" TEXT,
"Range" INTEGER NOT NULL DEFAULT 0,
"Invert" BOOLEAN NOT NULL CHECK (Invert IN (0,1)) DEFAULT 0,
PRIMARY KEY(MapConditionSetType, TerrainType, FeatureType, ResourceType),
FOREIGN KEY (FeatureType) REFERENCES Features(FeatureType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (TerrainType) REFERENCES Terrains(TerrainType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (ResourceType) REFERENCES Resources(ResourceType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (MapConditionSetType) REFERENCES BarbarianTribe_MapConditionSets(MapConditionSetType) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE "BarbarianTribe_MapConditionSets" (
"MapConditionSetType" TEXT NOT NULL,
"TribeType" TEXT NOT NULL,
"Test" TEXT NOT NULL,
"Priority" INTEGER NOT NULL DEFAULT 1,
PRIMARY KEY(MapConditionSetType),
FOREIGN KEY (TribeType) REFERENCES BarbarianTribes(TribeType) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE "BarbarianTribe_UnitConditions" (
"TribeType" TEXT NOT NULL,
"UnitType" TEXT NOT NULL,
"ReplacesUnitType" TEXT,
"MaxPerTribe" INTEGER NOT NULL DEFAULT 1,
PRIMARY KEY(TribeType, UnitType),
FOREIGN KEY (TribeType) REFERENCES BarbarianTribes(TribeType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (UnitType) REFERENCES Units(UnitType) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (ReplacesUnitType) REFERENCES Units(UnitType) ON DELETE CASCADE ON UPDATE CASCADE);
What are your thoughts?