Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

v1083c WitP Staff

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> v1083c WitP Staff Page: [1]
Login
Message << Older Topic   Newer Topic >>
v1083c WitP Staff - 9/3/2009 3:29:03 PM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
I started scenario 1, created a database, tried to load a save game, and died. Here's the log:
quote:


/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
SET CHECKPOINT DEFRAG 10
SET AUTOCOMMIT FALSE
SET TABLE "LeaderPrefs" SOURCE "leader-prefs.csv;ignore_first=true"
\u000aSET TABLE "LeaderPrefs" READONLY TRUE
SET TABLE "ACFactors" SOURCE "acfactors.csv;ignore_first=true"
\u000aSET TABLE "ACFactors" READONLY TRUE
SET AUTOCOMMIT TRUE


Here are the properties:
quote:


#HSQL Database Engine 1.8.0.9
#Thu Sep 03 14:13:37 BST 2009
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=false
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=true
hsqldb.cache_scale=14
version=1.8.0
hsqldb.default_table_type=memory
hsqldb.cache_file_scale=1
hsqldb.log_size=200
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.defrag_limit=10
hsqldb.compatible_version=1.8.0


Here's the script:
quote:


CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE "wdConfig"("gameversion" SMALLINT DEFAULT 1 NOT NULL,"scenario" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"natnumber" TINYINT DEFAULT 0 NOT NULL,"isPBEM" BOOLEAN DEFAULT FALSE NOT NULL,"lastFileRead" VARCHAR(100) DEFAULT NULL,"pw" BIGINT DEFAULT NULL,"dbVersion" INTEGER DEFAULT 6 NOT NULL)
CREATE MEMORY TABLE "Turn2Date"("date" DATE DEFAULT '0002-11-30' NOT NULL,"turn" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"storedate" VARCHAR(33) DEFAULT '0000-00-00' NOT NULL,"gameday" TINYINT DEFAULT 0 NOT NULL,"gamemonth" TINYINT DEFAULT 0 NOT NULL,"gameyear" TINYINT DEFAULT 0 NOT NULL,CONSTRAINT SYS_CT_49 UNIQUE("date"))
CREATE MEMORY TABLE "FactoryTypes"("factorytype" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"factorytypetype" TINYINT DEFAULT 0 NOT NULL,"factorytypename" VARCHAR(16) DEFAULT '' NOT NULL,"side" TINYINT DEFAULT 5 NOT NULL)
CREATE CACHED TABLE "GlobalStorageLog"("turn" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"manpower" INTEGER DEFAULT 0 NOT NULL,"hi" INTEGER DEFAULT 0 NOT NULL,"armament" INTEGER DEFAULT 0 NOT NULL,"vehicle" INTEGER DEFAULT 0 NOT NULL,"naval" INTEGER DEFAULT 0 NOT NULL,"merchant" INTEGER DEFAULT 0 NOT NULL,"loadedRes" INTEGER DEFAULT 0 NOT NULL,"loadedSup" INTEGER DEFAULT 0 NOT NULL,"loadedOil" INTEGER DEFAULT 0 NOT NULL,"loadedFuel" INTEGER DEFAULT 0 NOT NULL,"freeRes" INTEGER DEFAULT 0 NOT NULL,"freeSup" INTEGER DEFAULT 0 NOT NULL,"freeOil" INTEGER DEFAULT 0 NOT NULL,"freeFuel" INTEGER DEFAULT 0 NOT NULL,"japPoints" INTEGER DEFAULT 0 NOT NULL,"alliesPoints" INTEGER DEFAULT 0 NOT NULL,CONSTRAINT "StorageOnlyForExistingTurns" FOREIGN KEY("turn") REFERENCES "Turn2Date"("turn") ON DELETE CASCADE)
CREATE CACHED TABLE "EngineStorageLog"("turn" SMALLINT DEFAULT 0 NOT NULL,"enginetype" SMALLINT DEFAULT 0 NOT NULL,"stored" INTEGER DEFAULT 0 NOT NULL,PRIMARY KEY("turn","enginetype"),CONSTRAINT "EngStorageOnlyForExistingTurns" FOREIGN KEY("turn") REFERENCES "Turn2Date"("turn") ON DELETE CASCADE,CONSTRAINT "EngStorageTypeCheck" FOREIGN KEY("enginetype") REFERENCES "FactoryTypes"("factorytype"))
CREATE MEMORY TABLE "LocationTypes"("loctypeID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"loctypeName" VARCHAR(20) DEFAULT '' NOT NULL)
CREATE MEMORY TABLE "Nationalities"("natID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"natName" VARCHAR(20) DEFAULT '' NOT NULL,CONSTRAINT "NationalityHasUniqueName" UNIQUE("natName"))
CREATE CACHED TABLE "BaseStatus"("baseID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"hqID" SMALLINT DEFAULT 0 NOT NULL,"airfieldMax" TINYINT DEFAULT 0 NOT NULL,"airfieldCurrent" TINYINT DEFAULT 0 NOT NULL,"airfieldExpansion" TINYINT DEFAULT 0 NOT NULL,"portMax" TINYINT DEFAULT 0 NOT NULL,"portCurrent" TINYINT DEFAULT 0 NOT NULL,"portExpansion" TINYINT DEFAULT 0 NOT NULL,"fortCurrent" TINYINT DEFAULT 0 NOT NULL,"fortExpansion" TINYINT DEFAULT 0 NOT NULL,"storedFuel" INTEGER DEFAULT 0 NOT NULL,"storedSupply" INTEGER DEFAULT 0 NOT NULL,"storedOil" INTEGER DEFAULT 0 NOT NULL,"storedResources" INTEGER DEFAULT 0 NOT NULL,"basename" VARCHAR(25) DEFAULT '' NOT NULL,"factoryCount" TINYINT DEFAULT 0 NOT NULL,"basetype" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"originalnatID" TINYINT DEFAULT 0 NOT NULL,"appearingFuel" INTEGER DEFAULT 0 NOT NULL,"appearingSupply" INTEGER DEFAULT 0 NOT NULL,"appearingOil" INTEGER DEFAULT 0 NOT NULL,"appearingResources" INTEGER DEFAULT 0 NOT NULL,"storedRepair" INTEGER DEFAULT 0 NOT NULL,"requestedSupply" INTEGER DEFAULT 0 NOT NULL,"garrisonRequired" SMALLINT DEFAULT 0 NOT NULL,CONSTRAINT "PositiveBasePositions" CHECK(("BaseStatus"."posx">0) AND ("BaseStatus"."posy">0)),CONSTRAINT "BaseTypeExisting" FOREIGN KEY("basetype") REFERENCES "LocationTypes"("loctypeID"),CONSTRAINT "NationalityExisting" FOREIGN KEY("natID") REFERENCES "Nationalities"("natID"),CONSTRAINT "Nationality2Existing" FOREIGN KEY("originalnatID") REFERENCES "Nationalities"("natID"))
CREATE INDEX "basename" ON "BaseStatus"("basename")
CREATE CACHED TABLE "Factory2Base"("baseID" SMALLINT DEFAULT 0 NOT NULL,"factoryindex" TINYINT DEFAULT 0 NOT NULL,"factorytype" SMALLINT DEFAULT 0 NOT NULL,"size" SMALLINT DEFAULT 0 NOT NULL,"repair" SMALLINT DEFAULT 0 NOT NULL,"doRepair" BOOLEAN DEFAULT FALSE NOT NULL,"doProduce" BOOLEAN DEFAULT FALSE NOT NULL,PRIMARY KEY("baseID","factoryindex"),CONSTRAINT "FactoriesOnlyForExistingBases" FOREIGN KEY("baseID") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,CONSTRAINT "FactoriesMustProduceSomethingExisting" FOREIGN KEY("factorytype") REFERENCES "FactoryTypes"("factorytype"))
CREATE CACHED TABLE "OriginalBaseStatus"("baseID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"airfieldMax" TINYINT DEFAULT 0 NOT NULL,"airfieldCurrent" TINYINT DEFAULT 0 NOT NULL,"portMax" TINYINT DEFAULT 0 NOT NULL,"portCurrent" TINYINT DEFAULT 0 NOT NULL,"fortCurrent" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"appearingFuel" INTEGER DEFAULT 0 NOT NULL,"appearingSupply" INTEGER DEFAULT 0 NOT NULL,"appearingOil" INTEGER DEFAULT 0 NOT NULL,"appearingResources" INTEGER DEFAULT 0 NOT NULL,"garrisonRequired" SMALLINT DEFAULT 0 NOT NULL)
CREATE CACHED TABLE "OriginalFactory2Base"("baseID" SMALLINT DEFAULT 0 NOT NULL,"factoryindex" TINYINT DEFAULT 0 NOT NULL,"factorytype" SMALLINT DEFAULT 0 NOT NULL,"size" SMALLINT DEFAULT 0 NOT NULL,"repair" SMALLINT DEFAULT 0 NOT NULL,PRIMARY KEY("baseID","factoryindex"),CONSTRAINT "OrgFactoriesOnlyForExistingBases" FOREIGN KEY("baseID") REFERENCES "OriginalBaseStatus"("baseID") ON DELETE CASCADE,CONSTRAINT "OrgFactoriesMustProduceSomethingExisting" FOREIGN KEY("factorytype") REFERENCES "FactoryTypes"("factorytype"))
CREATE MEMORY TABLE "CommandTypes"("commandID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"commandName" VARCHAR(20) DEFAULT '' NOT NULL)
CREATE MEMORY TABLE "Ranks"("rankID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"rankName" VARCHAR(20) DEFAULT '' NOT NULL)
CREATE CACHED TABLE "LeaderStatus"("leaderID" INTEGER DEFAULT 0 NOT NULL PRIMARY KEY,"leaderName" VARCHAR(25) DEFAULT '' NOT NULL,"availDelay" SMALLINT DEFAULT 0 NOT NULL,"skill" TINYINT DEFAULT 0 NOT NULL,"inspiration" TINYINT DEFAULT 0 NOT NULL,"administration" TINYINT DEFAULT 0 NOT NULL,"aggresiveness" TINYINT DEFAULT 0 NOT NULL,"landOp" TINYINT DEFAULT 0 NOT NULL,"surfaceOp" TINYINT DEFAULT 0 NOT NULL,"airOp" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"rankID" TINYINT DEFAULT 0 NOT NULL,"commandID" TINYINT DEFAULT 0 NOT NULL,"ppValue" TINYINT DEFAULT 0 NOT NULL,CONSTRAINT "LeadersNationalityMustExist" FOREIGN KEY("natID") REFERENCES "Nationalities"("natID"),CONSTRAINT "LeadersRankMustExist" FOREIGN KEY("rankID") REFERENCES "Ranks"("rankID"),CONSTRAINT "LeadersCommandAbilityMustExist" FOREIGN KEY("commandID") REFERENCES "CommandTypes"("commandID"))
CREATE INDEX "natID" ON "LeaderStatus"("natID")
CREATE CACHED TABLE "LCUDevices"("deviceID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"devicetype" TINYINT DEFAULT -1 NOT NULL,"devicename" VARCHAR(25) DEFAULT '' NOT NULL,"loadcost" SMALLINT DEFAULT 0 NOT NULL,"range" SMALLINT DEFAULT 0 NOT NULL,"effect" SMALLINT DEFAULT 0 NOT NULL,"penetration" SMALLINT DEFAULT 0 NOT NULL,"accuracy" SMALLINT DEFAULT 0 NOT NULL,"ceiling" INTEGER DEFAULT 0 NOT NULL,"anti-armor" SMALLINT DEFAULT 0 NOT NULL,"anti-soft" SMALLINT DEFAULT 0 NOT NULL,"isStatic" BOOLEAN DEFAULT FALSE NOT NULL)
CREATE INDEX "lcudevtype" ON "LCUDevices"("devicetype")
CREATE MEMORY TABLE "Suffixes"("id" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"suffix" VARCHAR(20) DEFAULT '' NOT NULL)
CREATE CACHED TABLE "LCUStatus"("lcuID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"prepLoc" SMALLINT DEFAULT NULL,"prepPerc" TINYINT DEFAULT 0 NOT NULL,"exp" TINYINT DEFAULT 0 NOT NULL,"moral" TINYINT DEFAULT 0 NOT NULL,"fatigue" TINYINT DEFAULT 0 NOT NULL,"commanderID" INTEGER DEFAULT NULL,"hqID" SMALLINT DEFAULT NULL,"targetID" SMALLINT DEFAULT NULL,"targetx" SMALLINT DEFAULT 0 NOT NULL,"targety" SMALLINT DEFAULT 0 NOT NULL,"storedSupply" INTEGER DEFAULT 0 NOT NULL,"requestedSupply" SMALLINT DEFAULT 0 NOT NULL,"name" VARCHAR(24) DEFAULT '' NOT NULL,"suffixID" SMALLINT DEFAULT 0 NOT NULL,"lcutypeID" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"turnsTillAvail" SMALLINT DEFAULT 0 NOT NULL,"fragmentToParent" SMALLINT DEFAULT NULL,"fragmentNumber" TINYINT DEFAULT 0 NOT NULL,"hqType" TINYINT DEFAULT NULL,"isRestricted" BOOLEAN DEFAULT FALSE NOT NULL,"isStatic" BOOLEAN DEFAULT FALSE NOT NULL,"supportGivingSquads" SMALLINT DEFAULT 0 NOT NULL,"supportRequiringSquads" SMALLINT DEFAULT 0 NOT NULL,"supportNeutralSquads" SMALLINT DEFAULT 0 NOT NULL,"navalSquads" SMALLINT DEFAULT 0 NOT NULL,"disabledSquads" SMALLINT DEFAULT 0 NOT NULL,"loadcostAP" SMALLINT DEFAULT 0 NOT NULL,"loadcostAK" SMALLINT DEFAULT 0 NOT NULL,"estAV" SMALLINT DEFAULT 0 NOT NULL,"estAA" SMALLINT DEFAULT 0 NOT NULL,"withdrawDays" SMALLINT DEFAULT 0 NOT NULL,"opmode" TINYINT DEFAULT 0 NOT NULL,"packdelay" TINYINT DEFAULT -1 NOT NULL,CONSTRAINT "LCUCommanderMustExist" FOREIGN KEY("commanderID") REFERENCES "LeaderStatus"("leaderID") ON DELETE CASCADE,CONSTRAINT "LCUneedsAnExistingHQ" FOREIGN KEY("hqID") REFERENCES "LCUStatus"("lcuID") ON DELETE CASCADE,CONSTRAINT "PreparationOnlyForExistingTargets" FOREIGN KEY("prepLoc") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,CONSTRAINT "LCUneedsAnExistingSuffix" FOREIGN KEY("suffixID") REFERENCES "Suffixes"("id"),CONSTRAINT "LCUsMarchOnlyToExistingBases" FOREIGN KEY("targetID") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,CONSTRAINT "LCUsTypeMustExist" FOREIGN KEY("lcutypeID") REFERENCES "LocationTypes"("loctypeID"),CONSTRAINT "LCUsTypeMustBeAnLCUtype" CHECK((("LCUStatus"."lcutypeID"=3) OR ("LCUStatus"."lcutypeID"=4)) OR (("LCUStatus"."lcutypeID">=7) AND ("LCUStatus"."lcutypeID"<=11))),CONSTRAINT "LCUsNationalityMustExist" FOREIGN KEY("natID") REFERENCES "Nationalities"("natID"),CONSTRAINT "FragmentParentMustExist" FOREIGN KEY("fragmentToParent") REFERENCES "LCUStatus"("lcuID") ON DELETE CASCADE)
CREATE INDEX "LCUAvail" ON "LCUStatus"("turnsTillAvail")
CREATE INDEX "LCUTargetCoord" ON "LCUStatus"("targetx","targety")
CREATE INDEX "prepLoc" ON "LCUStatus"("prepLoc")
CREATE INDEX "LCUtargetID" ON "LCUStatus"("targetID")
CREATE MEMORY TABLE "TFMissions"("missionID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"missionName" VARCHAR(16) DEFAULT '' NOT NULL,"isTransport" TINYINT DEFAULT 0 NOT NULL)
CREATE CACHED TABLE "TFStatus"("tfID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"commanderID" INTEGER DEFAULT 0 NOT NULL,"homeHarborID" SMALLINT DEFAULT 0 NOT NULL,"targetID" SMALLINT DEFAULT NULL,"targetx" SMALLINT DEFAULT 0 NOT NULL,"targety" SMALLINT DEFAULT 0 NOT NULL,"missionID" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,CONSTRAINT "TFCommanderMustExist" FOREIGN KEY("commanderID") REFERENCES "LeaderStatus"("leaderID") ON DELETE CASCADE,CONSTRAINT "TFsTargetMustExists" FOREIGN KEY("targetID") REFERENCES "BaseStatus"("baseID") ON DELETE CASCADE,CONSTRAINT "TFsNationalityMustExist" FOREIGN KEY("natID") REFERENCES "Nationalities"("natID"))
CREATE INDEX "TFTargetID" ON "TFStatus"("targetID")
CREATE INDEX "TFTargetCoord" ON "TFStatus"("targetx","targety")
CREATE MEMORY TABLE "ShipTypes"("shiptypeID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"shiptypeName" VARCHAR(6) DEFAULT '' NOT NULL,"navalProduct" BOOLEAN DEFAULT FALSE NOT NULL,"carryTroopInFastTFOnly" BOOLEAN DEFAULT FALSE NOT NULL,"carryTroopInCargo" BOOLEAN DEFAULT TRUE NOT NULL,"isTransport" BOOLEAN DEFAULT FALSE NOT NULL)
CREATE CACHED TABLE "ShipDevices"("deviceID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"devicetype" TINYINT DEFAULT -1 NOT NULL,"attributes" TINYINT DEFAULT 0 NOT NULL,"devicename" VARCHAR(25) DEFAULT '' NOT NULL,"range" SMALLINT DEFAULT 0 NOT NULL,"effect" SMALLINT DEFAULT 0 NOT NULL,"penetration" SMALLINT DEFAULT 0 NOT NULL,"accuracy" SMALLINT DEFAULT 0 NOT NULL,"ceiling" INTEGER DEFAULT 0 NOT NULL,"loadcost" SMALLINT DEFAULT 0 NOT NULL)
CREATE INDEX "shipdevtype" ON "ShipDevices"("devicetype")
CREATE CACHED TABLE "ShipClasses"("shipclassID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"shiptype" TINYINT DEFAULT 0 NOT NULL,"shipclassName" VARCHAR(25) DEFAULT '' NOT NULL,"speed" TINYINT DEFAULT 0 NOT NULL,"durability" SMALLINT DEFAULT 0 NOT NULL,"manuever" SMALLINT DEFAULT 0 NOT NULL,"endurance" INTEGER DEFAULT 0 NOT NULL,"fuel" SMALLINT DEFAULT 0 NOT NULL,"armorsum" SMALLINT DEFAULT 0 NOT NULL,"lowAA" SMALLINT DEFAULT 0 NOT NULL,"highAA" SMALLINT DEFAULT 0 NOT NULL,"aaCeiling" INTEGER DEFAULT 0 NOT NULL,"torptubes" TINYINT DEFAULT 0 NOT NULL,"torploads" TINYINT DEFAULT 0 NOT NULL,"aswNumber" SMALLINT DEFAULT 0 NOT NULL,"aswRating" SMALLINT DEFAULT 0 NOT NULL,"mainweapon" SMALLINT DEFAULT NULL,"mainweapNum" TINYINT DEFAULT 0,"mainweapShots" SMALLINT DEFAULT 0,"fightingValue" SMALLINT DEFAULT 0,"specials" VARCHAR(40) DEFAULT '' NOT NULL,"upgradeClass" SMALLINT DEFAULT NULL,"upgradeMonth" TINYINT DEFAULT NULL,"upgradeYear" TINYINT DEFAULT NULL,"availMonth" TINYINT DEFAULT 0 NOT NULL,"availYear" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT -1 NOT NULL,"troopCap" SMALLINT DEFAULT 0 NOT NULL,"bulkCap" SMALLINT DEFAULT 0 NOT NULL,"liquidCap" SMALLINT DEFAULT 0 NOT NULL,"tonnage" INTEGER DEFAULT 0 NOT NULL,"rearmCostsGuns" SMALLINT DEFAULT 0 NOT NULL,"rearmCostsOthers" SMALLINT DEFAULT 0 NOT NULL,"attribute" TINYINT DEFAULT 0 NOT NULL,CONSTRAINT "ShipsTypeMustExists" FOREIGN KEY("shiptype") REFERENCES "ShipTypes"("shiptypeID"),CONSTRAINT "ShipsUpgradeOnlyToExistingTypes" FOREIGN KEY("upgradeClass") REFERENCES "ShipClasses"("shipclassID"),CONSTRAINT "ShipsMainWeaponMustExist" FOREIGN KEY("mainweapon") REFERENCES "ShipDevices"("deviceID"))
CREATE INDEX "upgtime" ON "ShipClasses"("upgradeYear","upgradeMonth")
CREATE CACHED TABLE "ShipConversions"("fromID" SMALLINT DEFAULT 0 NOT NULL,"toID" SMALLINT DEFAULT 0 NOT NULL,PRIMARY KEY("fromID","toID"))
CREATE CACHED TABLE "Ships"("shipID" INTEGER DEFAULT 0 NOT NULL PRIMARY KEY,"shipclass" SMALLINT DEFAULT 0 NOT NULL,"shipName" VARCHAR(25) DEFAULT '' NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"state" TINYINT DEFAULT -2 NOT NULL,"commanderID" INTEGER DEFAULT NULL,CONSTRAINT "ShipClassMustExist" FOREIGN KEY("shipclass") REFERENCES "ShipClasses"("shipclassID"),CONSTRAINT "ShipNatMustExist" FOREIGN KEY("natID") REFERENCES "Nationalities"("natID"),CONSTRAINT "ShipCommanderMustExist" FOREIGN KEY("commanderID") REFERENCES "LeaderStatus"("leaderID") ON DELETE SET NULL)
CREATE CACHED TABLE "ShipStatus"("shipID" INTEGER DEFAULT 0 NOT NULL PRIMARY KEY,"harborLocID" SMALLINT DEFAULT NULL,"tfID" SMALLINT DEFAULT NULL,"loadedRes" SMALLINT DEFAULT 0 NOT NULL,"loadedSup" SMALLINT DEFAULT 0 NOT NULL,"loadedOil" SMALLINT DEFAULT 0 NOT NULL,"loadedFuel" SMALLINT DEFAULT 0 NOT NULL,"loadedUnitID" SMALLINT DEFAULT NULL,"expDay" TINYINT DEFAULT 0 NOT NULL,"expNight" TINYINT DEFAULT 0 NOT NULL,"sysDamage" TINYINT DEFAULT 0 NOT NULL,"floatDamage" TINYINT DEFAULT 0 NOT NULL,"fireDamage" TINYINT DEFAULT 0 NOT NULL,"isLoading" BOOLEAN DEFAULT FALSE NOT NULL,CONSTRAINT "ShipStatusMustHaveShip" FOREIGN KEY("shipID") REFERENCES "Ships"("shipID") ON DELETE CASCADE,CONSTRAINT "HarborMustExist" FOREIGN KEY("harborLocID") REFERENCES "BaseStatus"("baseID") ON DELETE SET NULL,CONSTRAINT "ShipsTFMustExist" FOREIGN KEY("tfID") REFERENCES "TFStatus"("tfID") ON DELETE SET NULL,CONSTRAINT "OnlyExistingUnitsCanBeLoaded" FOREIGN KEY("loadedUnitID") REFERENCES "LCUStatus"("lcuID") ON DELETE SET NULL)
CREATE CACHED TABLE "ShipBuildqueue"("shipID" INTEGER DEFAULT 0 NOT NULL PRIMARY KEY,"harborLocID" SMALLINT DEFAULT NULL,"durability" SMALLINT DEFAULT 0 NOT NULL,"buildspeed" TINYINT DEFAULT 0 NOT NULL,"turnsTillAvail" SMALLINT DEFAULT 0 NOT NULL,CONSTRAINT "BuildQueueMustHaveShip" FOREIGN KEY("shipID") REFERENCES "Ships"("shipID") ON DELETE CASCADE)
CREATE INDEX "shipAvail" ON "ShipBuildqueue"("turnsTillAvail")
CREATE CACHED TABLE "ShipPosLog"("shipID" INTEGER DEFAULT 0 NOT NULL,"turn" SMALLINT DEFAULT 0 NOT NULL,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"movetox" SMALLINT DEFAULT 0 NOT NULL,"movetoy" SMALLINT DEFAULT 0 NOT NULL,PRIMARY KEY("shipID","turn"),CONSTRAINT SYS_FK_178 FOREIGN KEY("shipID") REFERENCES "Ships"("shipID"),CONSTRAINT "ShipsPositionOnlyInterestingAtKnownTurns" FOREIGN KEY("turn") REFERENCES "Turn2Date"("turn") ON DELETE CASCADE)
CREATE MEMORY TABLE "ACTypes"("actypeID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"actypeName" VARCHAR(16) DEFAULT '' NOT NULL,"actypeAbbr" CHAR(2) DEFAULT '' NOT NULL,"usedRange" TINYINT DEFAULT 0 NOT NULL,"canSearch" BOOLEAN DEFAULT TRUE NOT NULL,"isFighter" BOOLEAN DEFAULT FALSE NOT NULL,"isBomber" BOOLEAN DEFAULT FALSE NOT NULL)
CREATE CACHED TABLE "ACClasses"("acclassID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"productionID" SMALLINT DEFAULT 0 NOT NULL,"acclassName" VARCHAR(25) DEFAULT '' NOT NULL,"actype" TINYINT DEFAULT 0 NOT NULL,"enginetype" SMALLINT DEFAULT 0 NOT NULL,"enginenumber" TINYINT DEFAULT 0 NOT NULL,"upgradeClass" SMALLINT DEFAULT NULL,"upgradeMonth" TINYINT DEFAULT NULL,"upgradeYear" TINYINT DEFAULT NULL,"availMonth" TINYINT DEFAULT 0 NOT NULL,"availYear" TINYINT DEFAULT 0 NOT NULL,"realAvailMonth" TINYINT DEFAULT 0 NOT NULL,"realAvailYear" TINYINT DEFAULT 0 NOT NULL,"turnsTillAvail" SMALLINT DEFAULT 0 NOT NULL,"estAccumResearch" INTEGER DEFAULT 0 NOT NULL,"lastAccumTurn" SMALLINT DEFAULT 32767 NOT NULL,"maxSpeed" SMALLINT DEFAULT 0 NOT NULL,"cruiseSpeed" SMALLINT DEFAULT 0 NOT NULL,"climbRate" SMALLINT DEFAULT 0 NOT NULL,"maxAlt" INTEGER DEFAULT 0 NOT NULL,"endurance" SMALLINT DEFAULT 0 NOT NULL,"normRange" SMALLINT DEFAULT 0 NOT NULL,"extRange" SMALLINT DEFAULT 0 NOT NULL,"maxRange" SMALLINT DEFAULT 0 NOT NULL,"maxLoad" SMALLINT DEFAULT 0 NOT NULL,"maneuver" TINYINT DEFAULT 0 NOT NULL,"durability" TINYINT DEFAULT 0 NOT NULL,"armor" TINYINT DEFAULT 0 NOT NULL,"serviceRating" TINYINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT -1 NOT NULL,"buildPlaces" VARCHAR(100) DEFAULT NULL,CONSTRAINT "ACtypeMustExist" FOREIGN KEY("actype") REFERENCES "ACTypes"("actypeID"),CONSTRAINT "ACupgradingOnlyToExistingACs" FOREIGN KEY("upgradeClass") REFERENCES "ACClasses"("acclassID"))
CREATE INDEX "acproduction" ON "ACClasses"("productionID")
CREATE CACHED TABLE "ACDevices"("deviceID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"devicetype" TINYINT DEFAULT -1 NOT NULL,"devicename" VARCHAR(25) DEFAULT '' NOT NULL,"range" SMALLINT DEFAULT 0 NOT NULL,"effect" SMALLINT DEFAULT 0 NOT NULL,"penetration" SMALLINT DEFAULT 0 NOT NULL,"accuracy" SMALLINT DEFAULT 0 NOT NULL)
CREATE INDEX "acdevtype" ON "ACDevices"("devicetype")
CREATE MEMORY TABLE "ACWeaponFacings"("facingID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"facingName" CHAR(2) DEFAULT '' NOT NULL)
CREATE CACHED TABLE "ACs2Armament"("acclassID" SMALLINT DEFAULT 0 NOT NULL,"deviceID" SMALLINT DEFAULT 0 NOT NULL,"number" TINYINT DEFAULT 0 NOT NULL,"facing" TINYINT DEFAULT 0 NOT NULL,PRIMARY KEY("acclassID","deviceID","facing"),CONSTRAINT "ACClassMustExists4Armament" FOREIGN KEY("acclassID") REFERENCES "ACClasses"("acclassID"),CONSTRAINT "ACDeviceMustExists" FOREIGN KEY("deviceID") REFERENCES "ACDevices"("deviceID"),CONSTRAINT "ACFacingMustExists" FOREIGN KEY("facing") REFERENCES "ACWeaponFacings"("facingID"))
CREATE MEMORY TABLE "AGMissions"("missionID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"missionName" VARCHAR(15) DEFAULT '' NOT NULL,"searchDivisor" TINYINT DEFAULT 0 NOT NULL,"isSupply" BOOLEAN DEFAULT FALSE NOT NULL)
CREATE CACHED TABLE "AirGroups"("airgroupID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"airgroupName" VARCHAR(24) DEFAULT '' NOT NULL,"acclassID" SMALLINT DEFAULT 0 NOT NULL,"commanderID" INTEGER DEFAULT 0,"hqID" SMALLINT DEFAULT 0,"baselocID" SMALLINT DEFAULT NULL,"shiplocID" INTEGER DEFAULT NULL,"nationality" TINYINT DEFAULT 0 NOT NULL,"acUsable" TINYINT DEFAULT 0 NOT NULL,"primaryMission" TINYINT DEFAULT 0 NOT NULL,"secondaryMission" TINYINT DEFAULT 0 NOT NULL,"missionLevel" TINYINT DEFAULT -1 NOT NULL,"capLevel" TINYINT DEFAULT -1 NOT NULL,"lrcapLevel" TINYINT DEFAULT -1 NOT NULL,"navsearchLevel" TINYINT DEFAULT -1 NOT NULL,"aswLevel" TINYINT DEFAULT -1 NOT NULL,"range" TINYINT DEFAULT 0 NOT NULL,"searchStartAngle" TINYINT DEFAULT -1 NOT NULL,"searchEndAngle" TINYINT DEFAULT -1 NOT NULL,"aswStartAngle" TINYINT DEFAULT -1 NOT NULL,"aswEndAngle" TINYINT DEFAULT -1 NOT NULL,"missionTargetLocID" SMALLINT DEFAULT NULL,"turnsTillAvail" SMALLINT DEFAULT 0 NOT NULL,"fragmentToParent" SMALLINT DEFAULT NULL,"fragmentNumber" TINYINT DEFAULT 0 NOT NULL,"wasUpdated" BOOLEAN DEFAULT FALSE NOT NULL,CONSTRAINT "ACClassMustExist" FOREIGN KEY("acclassID") REFERENCES "ACClasses"("acclassID"),CONSTRAINT "AGsCommanderMustExist" FOREIGN KEY("commanderID") REFERENCES "LeaderStatus"("leaderID") ON DELETE SET NULL,CONSTRAINT "AGsBaseMustExist" FOREIGN KEY("baselocID") REFERENCES "BaseStatus"("baseID") ON DELETE SET NULL,CONSTRAINT "AGsShipMustExist" FOREIGN KEY("shiplocID") REFERENCES "Ships"("shipID") ON DELETE SET NULL,CONSTRAINT "AGsMissionMustBeKnown" FOREIGN KEY("primaryMission") REFERENCES "AGMissions"("missionID"),CONSTRAINT "AGsHQMustExist" FOREIGN KEY("hqID") REFERENCES "LCUStatus"("lcuID") ON DELETE SET NULL,CONSTRAINT "AGsNationalityMustExist" FOREIGN KEY("nationality") REFERENCES "Nationalities"("natID"),CONSTRAINT "AGFragmentParentMustExist" FOREIGN KEY("fragmentToParent") REFERENCES "AirGroups"("airgroupID") ON DELETE CASCADE,CONSTRAINT "AGMustBeSomewhere" CHECK((("AirGroups"."baselocID" IS NOT NULL) OR ("AirGroups"."shiplocID" IS NOT NULL)) OR (("AirGroups"."acUsable"=0) OR ("AirGroups"."turnsTillAvail">0))))
CREATE INDEX "AGAvail" ON "AirGroups"("turnsTillAvail")
CREATE CACHED TABLE "OccurenceClasses"("ocClassID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,"name" VARCHAR(30) DEFAULT '' NOT NULL,"priority" TINYINT DEFAULT 0 NOT NULL,"symbol" TINYINT DEFAULT 0 NOT NULL,"direction" TINYINT DEFAULT 0 NOT NULL,"color" INTEGER DEFAULT 0 NOT NULL)
CREATE CACHED TABLE "Occurences"("key" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"turn" SMALLINT DEFAULT 0 NOT NULL,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"class" SMALLINT DEFAULT 0 NOT NULL,"shorttext" VARCHAR(50) DEFAULT '' NOT NULL,"longtext" VARCHAR(1000) DEFAULT '' NOT NULL,CONSTRAINT "OcClassMustExist" FOREIGN KEY("class") REFERENCES "OccurenceClasses"("ocClassID") ON DELETE CASCADE)
CREATE INDEX "OcurWhenWhere" ON "Occurences"("turn","posx","posy")
CREATE MEMORY TABLE "OccurenceTypes"("ocTypeID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"name" VARCHAR(30) DEFAULT '' NOT NULL)
CREATE CACHED TABLE "OccurenceC2T"("ocClassID" SMALLINT DEFAULT 0 NOT NULL,"ocTypeID" TINYINT DEFAULT 0 NOT NULL,CONSTRAINT "OcRelationClassMustExist" FOREIGN KEY("ocClassID") REFERENCES "OccurenceClasses"("ocClassID") ON DELETE CASCADE,CONSTRAINT "OcRelationTypeMustExist" FOREIGN KEY("ocTypeID") REFERENCES "OccurenceTypes"("ocTypeID") ON DELETE CASCADE)
CREATE CACHED TABLE "Map"("posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"natID" TINYINT DEFAULT 0 NOT NULL,"weather" TINYINT DEFAULT 0 NOT NULL,"factorytype" SMALLINT DEFAULT 0 NOT NULL,PRIMARY KEY("posx","posy"),CONSTRAINT "PositiveMapPositions" CHECK(("Map"."posx">0) AND ("Map"."posy">0)))
CREATE TEXT TABLE "Clusters"("clusterID" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"clusterName" VARCHAR(60) DEFAULT '' NOT NULL)
SET TABLE "Clusters" SOURCE "clusters.csv;ignore_first=true"
CREATE TEXT TABLE "Base2Cluster"("clusterID" TINYINT DEFAULT 0 NOT NULL,"baseID" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY,CONSTRAINT "ClusterForBaseMustExist" FOREIGN KEY("clusterID") REFERENCES "Clusters"("clusterID"))
SET TABLE "Base2Cluster" SOURCE "clusterbases.csv;ignore_first=true"
CREATE CACHED TABLE "LeadObjects"("id" INTEGER DEFAULT 0 NOT NULL,"name" VARCHAR(30) DEFAULT '' NOT NULL,"posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"leaderID" INTEGER DEFAULT 0 NOT NULL,"unittype" TINYINT DEFAULT 0 NOT NULL,"turnsTillAvail" SMALLINT DEFAULT 0 NOT NULL,PRIMARY KEY("id","unittype"),CONSTRAINT "OnlyExistingLeadersCanLeadAnObject" FOREIGN KEY("leaderID") REFERENCES "LeaderStatus"("leaderID") ON DELETE CASCADE)
CREATE CACHED TABLE "NearTo"("posx" SMALLINT DEFAULT 0 NOT NULL,"posy" SMALLINT DEFAULT 0 NOT NULL,"baseID" SMALLINT DEFAULT 0 NOT NULL,"distance" TINYINT DEFAULT 0 NOT NULL,PRIMARY KEY("posx","posy"))
CREATE CACHED TABLE "ResUsage"("resfrom" SMALLINT DEFAULT 0 NOT NULL,"resto" SMALLINT DEFAULT 0 NOT NULL,"amountThousands" INTEGER DEFAULT 1000 NOT NULL,"needsPort" BOOLEAN DEFAULT FALSE NOT NULL,"researchPossible" BOOLEAN DEFAULT FALSE NOT NULL,PRIMARY KEY("resfrom","resto"))
CREATE INDEX "resto" ON "ResUsage"("resto")
CREATE MEMORY TABLE "Spoilage"("combinedSize" TINYINT DEFAULT 0 NOT NULL PRIMARY KEY,"fuelLimit" INTEGER DEFAULT 0 NOT NULL,"supplyLimit" INTEGER DEFAULT 0 NOT NULL)
CREATE MEMORY TABLE "HarborReloadCapa"("index" TINYINT DEFAULT 0 NOT NULL,"reloadValue" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY)
CREATE MEMORY TABLE "ReloadLevels"("index" TINYINT DEFAULT 0 NOT NULL,"reloadValue" SMALLINT DEFAULT 0 NOT NULL PRIMARY KEY)
CREATE TEXT TABLE "LeaderPrefs"("name" VARCHAR(10) DEFAULT '' NOT NULL PRIMARY KEY,"leads" VARCHAR(20) DEFAULT '' NOT NULL,"nationality" VARCHAR(20) DEFAULT NULL,"rank" SMALLINT DEFAULT 0 NOT NULL,"air" TINYINT DEFAULT 0 NOT NULL,"sea" TINYINT DEFAULT 0 NOT NULL,"land" TINYINT DEFAULT 0 NOT NULL,"skill" TINYINT DEFAULT 0 NOT NULL,"admin" TINYINT DEFAULT 0 NOT NULL,"aggr" TINYINT DEFAULT 0 NOT NULL,"insp" TINYINT DEFAULT 0 NOT NULL)
SET TABLE "LeaderPrefs" READONLY TRUE
SET TABLE "LeaderPrefs" SOURCE "leader-prefs.csv;ignore_first=true"
CREATE TEXT TABLE "ACFactors"("name" VARCHAR(10) DEFAULT '' NOT NULL PRIMARY KEY,"manoeuver" SMALLINT DEFAULT 0 NOT NULL,"maxspeed" SMALLINT DEFAULT 0 NOT NULL,"cruise" SMALLINT DEFAULT 0 NOT NULL,"dura" SMALLINT DEFAULT 0 NOT NULL,"armor" SMALLINT DEFAULT 0 NOT NULL,"climb" SMALLINT DEFAULT 0 NOT NULL,"maxalt" SMALLINT DEFAULT 0 NOT NULL,"range" SMALLINT DEFAULT 0 NOT NULL,"load" SMALLINT DEFAULT 0 NOT NULL,"opgv" SMALLINT DEFAULT 0 NOT NULL,"dpgv" SMALLINT DEFAULT 0 NOT NULL,"lbl" SMALLINT DEFAULT 0 NOT NULL,"nbl" SMALLINT DEFAULT 0 NOT NULL,"sum" SMALLINT DEFAULT 0 NOT NULL)
SET TABLE "ACFactors" READONLY TRUE
SET TABLE "ACFactors" SOURCE "acfactors.csv;ignore_first=true"
SET TABLE "LCUDevices" INDEX'105152 81128 0'
SET TABLE "ShipDevices" INDEX'22552 4496 0'
SET TABLE "ShipClasses" INDEX'740000 1515880 1429008 575032 624920 0'
SET TABLE "ShipConversions" INDEX'1292488 0'
SET TABLE "ACClasses" INDEX'221464 180976 221464 221464 0'
SET TABLE "ACDevices" INDEX'169880 170976 0'
SET TABLE "ACs2Armament" INDEX'299968 299968 268784 250792 0'
SET TABLE "OccurenceClasses" INDEX'1674400 0'
SET TABLE "OccurenceC2T" INDEX'1675272 1675016 1675016 0'
SET TABLE "ResUsage" INDEX'477088 1634680 0'
ALTER TABLE "Occurences" ALTER COLUMN "key" RESTART WITH 0
CREATE VIEW "ShipPositions" ("shipID","posx","posy","targetx","targety") AS (SELECT a."shipID", b."posx",b."posy",b."targetx",b."targety" FROM "TFStatus" AS b INNER JOIN "ShipStatus" AS a ON a."tfID"=b."tfID" UNION SELECT a."shipID",b."posx",b."posy",0 AS "targetx",0 AS "targety" FROM "BaseStatus" AS b INNER JOIN "ShipStatus" AS a ON a."harborLocID"=b."baseID" )
CREATE VIEW "LcuMovesBases" ("lcuID","name","suffixID","posx","posy","estAV","baseID","basename","mover") AS (SELECT a."lcuID",a."name",a."suffixID",a."posx",a."posy",a."estAV",c."baseID",c."basename", 1 AS "mover"FROM "LCUStatus" AS a JOIN "NearTo" AS b ON b."posx"=a."targetx" AND b."posy"=a."targety" JOIN "BaseStatus" AS c ON b."baseID" = c."baseID" WHERE a."turnsTillAvail"=0 AND a."fragmentNumber"=0 AND b."distance"<=2 UNION SELECT a."lcuID",a."name",a."suffixID",c."posx",c."posy",a."estAV",e."baseID",e."basename", 2 AS "mover" FROM "LCUStatus" AS a JOIN "ShipStatus" AS b ON a."lcuID"=b."loadedUnitID" JOIN "TFStatus" AS c ON b."tfID"=c."tfID" JOIN "NearTo" AS d ON c."targetx"=d."posx" AND c."targety"=d."posy" JOIN "BaseStatus" AS e ON d."baseID"=e."baseID" WHERE a."turnsTillAvail"=0 AND a."fragmentNumber"=0 AND d."distance"<=4)
CREATE VIEW "LcuPrepsBases" ("lcuID","name","suffixID","posx","posy","estAV","baseID","basename","shipx","shipy") AS SELECT a."lcuID",a."name",a."suffixID",a."posx",a."posy",a."estAV",b."baseID",b."basename",d."posx" AS "shipx",d."posy" AS "shipy" FROM "LCUStatus" AS a JOIN "BaseStatus" AS b ON a."prepLoc"=b."baseID" AND (a."posx"<>b."posx" OR a."posy" <> b."posy") LEFT JOIN "ShipStatus" AS c ON a."lcuID"=c."loadedUnitID" LEFT JOIN "TFStatus" AS d ON c."tfID"=d."tfID" WHERE a."turnsTillAvail"=0 AND a."fragmentNumber"=0 AND a."prepLoc"<>0
CREATE VIEW "TargetBases" ("lcuID","baseID","basename") AS (SELECT "lcuID","baseID","basename" FROM "LcuMovesBases" UNION DISTINCT SELECT "lcuID","baseID","basename" FROM "LcuPrepsBases")
CREATE VIEW "ResUsageNoResearch" ("resfrom","resto","amountThousands","needsPort","turnsTillAvail") AS SELECT a."resfrom",a."resto",a."amountThousands",a."needsPort",CASE WHEN "researchPossible" THEN b."turnsTillAvail" ELSE 0 END AS "turnsTillAvail"FROM "ResUsage" AS a LEFT JOIN "ACClasses" AS b ON a."resto"=b."productionID"
CREATE VIEW "ACClassNatsHelp" ("acclassID","natID") AS SELECT DISTINCT "acclassID","nationality" AS "natID" FROM "AirGroups"
CREATE VIEW "ACClassNats" ("acclassID","natID") AS SELECT DISTINCT "acclassID","natID" FROM "ACClassNatsHelp" UNION DISTINCT SELECT DISTINCT b."upgradeClass",a."natID" FROM "ACClassNatsHelp" as a JOIN "ACClasses" as b ON a."acclassID"=b."acclassID" WHERE b."upgradeClass" IS NOT NULL
CREATE VIEW "ACClassGunValues" ("acclassID",OPGV,DPGV) AS SELECT b."acclassID",SUM(CASE WHEN b."facing"=0 OR b."facing"=8 THEN SQRT(c."effect"*c."accuracy"*LOG(c."range"))*(1+c."penetration")*b."number"/2 ELSE 0 END) AS OPGV,SUM(CASE WHEN b."facing"<>0 AND b."facing"<>8 THEN SQRT(c."effect"*c."accuracy"*LOG(c."range"))*(1+c."penetration")*b."number"/2 ELSE 0 END) AS DPGV FROM "ACs2Armament" AS b JOIN "ACDevices" AS c ON b."deviceID"=c."deviceID" WHERE c."devicetype"=0 GROUP BY b."acclassID"
CREATE VIEW "ACClassBombValues" ("acclassID",LBL,NBL) AS SELECT b."acclassID",FLOOR(SUM(LOG(c."effect")*b."number")*4) AS LBL,FLOOR(SUM(c."penetration"*(LOG10(b."number")+1))) AS NBL FROM "ACs2Armament" AS b JOIN "ACDevices" AS c ON b."deviceID"=c."deviceID" WHERE (c."devicetype">=2 AND c."devicetype"<=4) OR c."devicetype"=16 GROUP BY b."acclassID"
CREATE VIEW "DumpViewAvailLCUs" ("lcuID",NAME,"loctypeName","ApproxPlace","DistFromBase","estAV","hqRestricted","turnsTillAvail",PREPTARGET,"prepPerc",MOVETARGET,"leaderName","natName","tfID","ApproxShipTarget","BelongsToHQ","posx","posy") AS SELECT a."lcuID", RTRIM(CONCAT(a."name",CONCAT(' ',b."suffix"))) AS name, n."loctypeName", CASE WHEN k."tfID">0 THEN r."basename" ELSE e."basename" END AS "ApproxPlace", CASE WHEN k."tfID">0 THEN q."distance" ELSE d."distance" END AS "DistFromBase", a."estAV", o."isRestricted" AS "hqRestricted", a."turnsTillAvail", i."basename" AS preptarget, a."prepPerc",g."basename" as movetarget, c."leaderName", h."natName", k."tfID", m."basename" AS "ApproxShipTarget", RTRIM(CONCAT(o."name",CONCAT(' ',p."suffix"))) AS "BelongsToHQ", a."posx", a."posy" FROM "LCUStatus" AS a JOIN "Suffixes" AS b ON a."suffixID" = b."id" LEFT JOIN "LeaderStatus" AS c ON a."commanderID"=c."leaderID" LEFT JOIN "NearTo" AS d on a."posx"=d."posx" and a."posy"=d."posy" LEFT JOIN "BaseStatus" AS e ON d."baseID"=e."baseID" LEFT JOIN "NearTo" AS f on a."targetx"=f."posx" and a."targety"=f."posy" LEFT JOIN "BaseStatus" AS g ON f."baseID"=g."baseID" JOIN "Nationalities" AS h ON a."natID"=h."natID" LEFT JOIN "BaseStatus" AS i ON a."prepLoc"=i."baseID" LEFT JOIN "ShipStatus" AS j on j."loadedUnitID"=a."lcuID" LEFT JOIN "TFStatus" AS k ON j."tfID"=k."tfID" LEFT JOIN "NearTo" AS l on k."targetx"=l."posx" and k."targety"=l."posy" LEFT JOIN "BaseStatus" AS m ON l."baseID"=m."baseID" LEFT JOIN "NearTo" AS q on k."posx"=q."posx" and k."posy"=q."posy" LEFT JOIN "BaseStatus" AS r ON q."baseID"=r."baseID" JOIN "LocationTypes" AS n ON a."lcutypeID"=n."loctypeID" LEFT JOIN "LCUStatus" AS o ON a."hqID"=o."lcuID" JOIN "Suffixes" AS p ON o."suffixID" = p."id" WHERE a."turnsTillAvail"<180 AND a."fragmentNumber"=0 AND NOT a."isRestricted"ORDER BY "turnsTillAvail",a."posx"-a."posy" DESC, "lcuID"
CREATE VIEW "DumpViewCurrentOOB" (HQID,"HQname","lcuID","name","ApproxPlace") AS SELECT a."lcuID" as HQID, RTRIM(CONCAT(a."name",CONCAT(' ',b."suffix"))) AS "HQname",c."lcuID",RTRIM(CONCAT(c."name",CONCAT(' ',d."suffix"))) AS "name", CASE WHEN k."tfID">0 THEN r."basename" ELSE f."basename" END AS "ApproxPlace" FROM "LCUStatus" as c JOIN "Suffixes" AS d ON c."suffixID" = d."id" LEFT JOIN "LCUStatus" as a ON a."lcuID"=c."hqID" LEFT JOIN "Suffixes" AS b ON a."suffixID" = b."id" LEFT JOIN "NearTo" AS e on c."posx"=e."posx" and c."posy"=e."posy" LEFT JOIN "BaseStatus" AS f ON e."baseID"=f."baseID" LEFT JOIN "ShipStatus" AS j on j."loadedUnitID"=c."lcuID" LEFT JOIN "TFStatus" AS k ON j."tfID"=k."tfID" LEFT JOIN "NearTo" AS q on k."posx"=q."posx" and k."posy"=q."posy" LEFT JOIN "BaseStatus" AS r ON q."baseID"=r."baseID" WHERE c."turnsTillAvail"=0 AND c."fragmentNumber"=0 ORDER BY a."lcuID",c."lcuID"
CREATE VIEW "ACClassesWithRange" ("acclassID","productionID","acclassName","actype","enginetype","enginenumber","upgradeClass","upgradeMonth","upgradeYear","availMonth","availYear","realAvailMonth","realAvailYear","turnsTillAvail","estAccumResearch","lastAccumTurn","maxSpeed","cruiseSpeed","climbRate","maxAlt","endurance","normRange","extRange","maxRange","maxLoad","maneuver","durability","armor","serviceRating","natID","buildPlaces",CLASSRANGE) AS SELECT "A"."acclassID", "A"."productionID", "A"."acclassName", "A"."actype", "A"."enginetype", "A"."enginenumber", "A"."upgradeClass", "A"."upgradeMonth", "A"."upgradeYear", "A"."availMonth", "A"."availYear", "A"."realAvailMonth", "A"."realAvailYear", "A"."turnsTillAvail", "A"."estAccumResearch", "A"."lastAccumTurn", "A"."maxSpeed", "A"."cruiseSpeed", "A"."climbRate", "A"."maxAlt", "A"."endurance", "A"."normRange", "A"."extRange", "A"."maxRange", "A"."maxLoad", "A"."maneuver", "A"."durability", "A"."armor", "A"."serviceRating", "A"."natID", "A"."buildPlaces",(CASE WHEN b."usedRange"=0 THEN a."normRange"/2 WHEN b."usedRange"=1 THEN a."extRange"/2 ELSE a."maxRange" END +39) / 40 AS CLASSRANGE FROM "ACClasses" AS a JOIN "ACTypes" AS b ON a."actype"=b."actypeID"
CREATE VIEW "RepairShipsInHex" ("ASShips","ADShips","ARShips","posx","posy") AS SELECT SUM(CASE WHEN d."shiptype"=41 THEN 1 END) AS "ASShips", SUM(CASE WHEN d."shiptype"=42 THEN 1 END) AS "ADShips", SUM(CASE WHEN d."shiptype"=43 THEN 1 END) AS "ARShips" ,f."posx", f."posy" FROM "ShipClasses" AS d JOIN "Ships" AS e ON e."shipclass"=d."shipclassID" JOIN "ShipPositions" AS f ON f."shipID"=e."shipID" WHERE d."shiptype">=41 AND d."shiptype"<=43 GROUP BY "posx","posy"
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO "wdConfig" VALUES(0,1,3,FALSE,NULL,NULL,6)
INSERT INTO "FactoryTypes" VALUES(197,2,'MXY7 Ohka 11',1)
INSERT INTO "FactoryTypes" VALUES(237,27,'Aichi Ha-60 ',1)
INSERT INTO "FactoryTypes" VALUES(238,27,'Hitachi Amakaze',1)
INSERT INTO "FactoryTypes" VALUES(239,27,'Hitachi (early)',1)
INSERT INTO "FactoryTypes" VALUES(240,27,'Kawasaki (early)',1)
INSERT INTO "FactoryTypes" VALUES(241,27,'Kawasaki Ha-60 ',1)
INSERT INTO "FactoryTypes" VALUES(242,27,'Mitsubishi Ha-31 ',1)
INSERT INTO "FactoryTypes" VALUES(243,27,'Mitsubishi Ha-32',1)
INSERT INTO "FactoryTypes" VALUES(244,27,'Mitsubishi Ha-33',1)
INSERT INTO "FactoryTypes" VALUES(245,27,'Mitsubishi Ha-42',1)
INSERT INTO "FactoryTypes" VALUES(246,27,'Mitsubishi Ha-43',1)
INSERT INTO "FactoryTypes" VALUES(247,27,'Nakajima Ha-45',1)
INSERT INTO "FactoryTypes" VALUES(518,26,'Oil',5)
INSERT INTO "FactoryTypes" VALUES(519,26,'Resources',5)
INSERT INTO "FactoryTypes" VALUES(520,26,'Manpower',5)
INSERT INTO "FactoryTypes" VALUES(521,14,'Heavy Industry',5)
INSERT INTO "FactoryTypes" VALUES(522,14,'Naval Shipyard',1)
INSERT INTO "FactoryTypes" VALUES(523,14,'Merchant Shipyard',1)
INSERT INTO "FactoryTypes" VALUES(524,14,'Repair Shipyard',5)
INSERT INTO "FactoryTypes" VALUES(525,14,'Armament Assembly',1)
INSERT INTO "FactoryTypes" VALUES(526,14,'Vehicle Assembly',1)
INSERT INTO "FactoryTypes" VALUES(527,14,'Light Industry',5)
INSERT INTO "FactoryTypes" VALUES(528,14,'Refinery',5)
INSERT INTO "FactoryTypes" VALUES(1852,27,'Engine',4)
INSERT INTO "FactoryTypes" VALUES(1885,2,'MXY7 Ohka 22',1)
INSERT INTO "FactoryTypes" VALUES(1930,27,'Nakajima Ha-5 ',1)
INSERT INTO "FactoryTypes" VALUES(1931,27,'Nakajima Ha-34 ',1)
INSERT INTO "FactoryTypes" VALUES(1932,27,'Nakajima Ha-35 ',1)
INSERT INTO "FactoryTypes" VALUES(1933,27,'Nakajima Ha-44',1)
INSERT INTO "FactoryTypes" VALUES(1934,27,'Nakajima Hikari ',1)
INSERT INTO "FactoryTypes" VALUES(1935,27,'Nakajima Kotobuki ',1)
INSERT INTO "FactoryTypes" VALUES(1937,27,'NE turbojet',1)
INSERT INTO "FactoryTypes" VALUES(1938,27,'Toko Rocket ',1)
INSERT INTO "FactoryTypes" VALUES(1940,27,'Kayaba Argus',1)
INSERT INTO "FactoryTypes" VALUES(2002,0,'A-29A Hudson',5)
INSERT INTO "FactoryTypes" VALUES(2003,0,'B-24M Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2004,0,'B-25D Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2005,0,'DB-3M',5)
INSERT INTO "FactoryTypes" VALUES(2006,0,'DC-2',5)
INSERT INTO "FactoryTypes" VALUES(2007,0,'DC-3',5)
INSERT INTO "FactoryTypes" VALUES(2008,0,'C-46A Commando',5)
INSERT INTO "FactoryTypes" VALUES(2009,0,'F-5E Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2010,0,'I-16-III',5)
INSERT INTO "FactoryTypes" VALUES(2011,0,'I-15-III',5)
INSERT INTO "FactoryTypes" VALUES(2012,0,'H81-A3',5)
INSERT INTO "FactoryTypes" VALUES(2013,0,'Hawk 75M',5)
INSERT INTO "FactoryTypes" VALUES(2014,0,'P-40E Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2015,0,'P-40N Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2016,0,'P-43A-1 Lancer',5)
INSERT INTO "FactoryTypes" VALUES(2017,0,'P-66 Vanguard',5)
INSERT INTO "FactoryTypes" VALUES(2018,0,'P-51D Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2019,0,'SB-III',5)
INSERT INTO "FactoryTypes" VALUES(2021,0,'Swordfish II',5)
INSERT INTO "FactoryTypes" VALUES(2022,0,'Albacore I',5)
INSERT INTO "FactoryTypes" VALUES(2023,0,'Walrus II',5)
INSERT INTO "FactoryTypes" VALUES(2025,0,'Avenger I',5)
INSERT INTO "FactoryTypes" VALUES(2026,0,'Avenger II',5)
INSERT INTO "FactoryTypes" VALUES(2027,0,'Avenger III',5)
INSERT INTO "FactoryTypes" VALUES(2029,0,'Barracuda II',5)
INSERT INTO "FactoryTypes" VALUES(2030,0,'Barracuda TR.III',5)
INSERT INTO "FactoryTypes" VALUES(2032,0,'Corsair II',5)
INSERT INTO "FactoryTypes" VALUES(2034,0,'Corsair IV',5)
INSERT INTO "FactoryTypes" VALUES(2035,0,'Corsair V',5)
INSERT INTO "FactoryTypes" VALUES(2036,0,'Firefly FR.I',5)
INSERT INTO "FactoryTypes" VALUES(2037,0,'Firefly F.I',5)
INSERT INTO "FactoryTypes" VALUES(2038,0,'Firefly NF.I',5)
INSERT INTO "FactoryTypes" VALUES(2039,0,'Fulmar II',5)
INSERT INTO "FactoryTypes" VALUES(2041,0,'Hellcat I',5)
INSERT INTO "FactoryTypes" VALUES(2042,0,'Hellcat F.II',5)
INSERT INTO "FactoryTypes" VALUES(2043,0,'Hellcat NF.II',5)
INSERT INTO "FactoryTypes" VALUES(2044,0,'Hellcat PR.II',5)
INSERT INTO "FactoryTypes" VALUES(2045,0,'Seafire IIC',5)
INSERT INTO "FactoryTypes" VALUES(2046,0,'Seafire L.III',5)
INSERT INTO "FactoryTypes" VALUES(2047,0,'Seafire F.XV',5)
INSERT INTO "FactoryTypes" VALUES(2049,0,'Sea Hurricane Ib',5)
INSERT INTO "FactoryTypes" VALUES(2051,0,'Martlet II',5)
INSERT INTO "FactoryTypes" VALUES(2052,0,'Martlet IV',5)
INSERT INTO "FactoryTypes" VALUES(2053,0,'Wildcat V',5)
INSERT INTO "FactoryTypes" VALUES(2054,0,'Wildcat VI',5)
INSERT INTO "FactoryTypes" VALUES(2057,0,'Audax I',5)
INSERT INTO "FactoryTypes" VALUES(2058,0,'Beaufighter VIf',5)
INSERT INTO "FactoryTypes" VALUES(2059,0,'Beaufighter VIc',5)
INSERT INTO "FactoryTypes" VALUES(2060,0,'Beaufighter TF.X',5)
INSERT INTO "FactoryTypes" VALUES(2061,0,'Beaufort I',5)
INSERT INTO "FactoryTypes" VALUES(2062,0,'Beaufort V (PR)',5)
INSERT INTO "FactoryTypes" VALUES(2063,0,'Blenheim I',5)
INSERT INTO "FactoryTypes" VALUES(2064,0,'Blenheim IF',5)
INSERT INTO "FactoryTypes" VALUES(2065,0,'Blenheim IV',5)
INSERT INTO "FactoryTypes" VALUES(2066,0,'Blenheim VD',5)
INSERT INTO "FactoryTypes" VALUES(2068,0,'Buffalo I',5)
INSERT INTO "FactoryTypes" VALUES(2069,0,'Buffalo PR.I',5)
INSERT INTO "FactoryTypes" VALUES(2071,0,'Catalina I',5)
INSERT INTO "FactoryTypes" VALUES(2073,0,'Dakota III',5)
INSERT INTO "FactoryTypes" VALUES(2074,0,'DC-2',5)
INSERT INTO "FactoryTypes" VALUES(2075,0,'DC-3',5)
INSERT INTO "FactoryTypes" VALUES(2076,0,'Hudson IIIa',5)
INSERT INTO "FactoryTypes" VALUES(2078,0,'Hurricane I Trop',5)
INSERT INTO "FactoryTypes" VALUES(2079,0,'Hurricane IIa Trop',5)
INSERT INTO "FactoryTypes" VALUES(2080,0,'Hurricane IIb Trop',5)
INSERT INTO "FactoryTypes" VALUES(2081,0,'Hurricane IIc Trop',5)
INSERT INTO "FactoryTypes" VALUES(2082,0,'Hurricane IId Trop',5)
INSERT INTO "FactoryTypes" VALUES(2083,0,'Hurricane PR.II',5)
INSERT INTO "FactoryTypes" VALUES(2084,0,'Hurricane FR.IIb',5)
INSERT INTO "FactoryTypes" VALUES(2085,0,'Hurricane FR.IIc',5)
INSERT INTO "FactoryTypes" VALUES(2086,0,'Hurricane IV',5)
INSERT INTO "FactoryTypes" VALUES(2087,0,'Lancaster B.1 Spcl',5)
INSERT INTO "FactoryTypes" VALUES(2088,0,'Lancaster B.1 FE',5)
INSERT INTO "FactoryTypes" VALUES(2089,0,'Lincoln B.1',5)
INSERT INTO "FactoryTypes" VALUES(2091,0,'Liberator II',5)
INSERT INTO "FactoryTypes" VALUES(2092,0,'Liberator B.III',5)
INSERT INTO "FactoryTypes" VALUES(2093,0,'Liberator B.VI',5)
INSERT INTO "FactoryTypes" VALUES(2094,0,'Liberator GR.III',5)
INSERT INTO "FactoryTypes" VALUES(2095,0,'Liberator GR.VI',5)
INSERT INTO "FactoryTypes" VALUES(2096,0,'Liberator C.VII',5)
INSERT INTO "FactoryTypes" VALUES(2097,0,'Lysander II',5)
INSERT INTO "FactoryTypes" VALUES(2099,0,'Mitchell PR.II',5)
INSERT INTO "FactoryTypes" VALUES(2101,0,'Mohawk IV',5)
INSERT INTO "FactoryTypes" VALUES(2103,0,'Mosquito FB.VI',5)
INSERT INTO "FactoryTypes" VALUES(2104,0,'Mosquito NF.XIX',5)
INSERT INTO "FactoryTypes" VALUES(2105,0,'Mosquito PR.IX',5)
INSERT INTO "FactoryTypes" VALUES(2106,0,'Mosquito PR.XVI',5)
INSERT INTO "FactoryTypes" VALUES(2107,0,'Mosquito PR.34',5)
INSERT INTO "FactoryTypes" VALUES(2108,0,'Mosquito B.35',5)
INSERT INTO "FactoryTypes" VALUES(2109,0,'Mustang IV',5)
INSERT INTO "FactoryTypes" VALUES(2110,0,'Swordfish I',5)
INSERT INTO "FactoryTypes" VALUES(2112,0,'Spitfire PR.IV',5)
INSERT INTO "FactoryTypes" VALUES(2113,0,'Spitfire Vc Trop',5)
INSERT INTO "FactoryTypes" VALUES(2114,0,'Spitfire VIII',5)
INSERT INTO "FactoryTypes" VALUES(2115,0,'Spitfire PR.XI',5)
INSERT INTO "FactoryTypes" VALUES(2116,0,'Spitfire F.XIV',5)
INSERT INTO "FactoryTypes" VALUES(2117,0,'Spitfire FR.XIVe',5)
INSERT INTO "FactoryTypes" VALUES(2118,0,'Sunderland III',5)
INSERT INTO "FactoryTypes" VALUES(2119,0,'Sunderland GR.V',5)
INSERT INTO "FactoryTypes" VALUES(2121,0,'Tempest F.2',5)
INSERT INTO "FactoryTypes" VALUES(2123,0,'Thunderbolt I',5)
INSERT INTO "FactoryTypes" VALUES(2124,0,'Thunderbolt II',5)
INSERT INTO "FactoryTypes" VALUES(2126,0,'Vengeance I',5)
INSERT INTO "FactoryTypes" VALUES(2127,0,'Vengeance IV',5)
INSERT INTO "FactoryTypes" VALUES(2129,0,'Vildebeest III',5)
INSERT INTO "FactoryTypes" VALUES(2131,0,'Wapiti IIa',5)
INSERT INTO "FactoryTypes" VALUES(2133,0,'Wellington Ic',5)
INSERT INTO "FactoryTypes" VALUES(2134,0,'Wellington GR.VIII',5)
INSERT INTO "FactoryTypes" VALUES(2135,0,'Wellington B.X',5)
INSERT INTO "FactoryTypes" VALUES(2136,0,'Wellington GR.XIII',5)
INSERT INTO "FactoryTypes" VALUES(2142,0,'139WH-3',5)
INSERT INTO "FactoryTypes" VALUES(2143,0,'B-339D',5)
INSERT INTO "FactoryTypes" VALUES(2144,0,'L-18 Lodestar',5)
INSERT INTO "FactoryTypes" VALUES(2145,0,'CW-21B Demon',5)
INSERT INTO "FactoryTypes" VALUES(2146,0,'CW-22 Falcon',5)
INSERT INTO "FactoryTypes" VALUES(2147,0,'C.XI-W',5)
INSERT INTO "FactoryTypes" VALUES(2148,0,'Do-24K-1',5)
INSERT INTO "FactoryTypes" VALUES(2149,0,'FK-51',5)
INSERT INTO "FactoryTypes" VALUES(2150,0,'75A-7 Hawk',5)
INSERT INTO "FactoryTypes" VALUES(2151,0,'Hurricane IIb Trop',5)
INSERT INTO "FactoryTypes" VALUES(2152,0,'L-212',5)
INSERT INTO "FactoryTypes" VALUES(2153,0,'PBY-5 Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2154,0,'T.IVa',5)
INSERT INTO "FactoryTypes" VALUES(2155,0,'P-40E Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2156,0,'DB-7B',5)
INSERT INTO "FactoryTypes" VALUES(2157,0,'B-25C Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2160,0,'Anson I',5)
INSERT INTO "FactoryTypes" VALUES(2161,0,'B-24J Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2163,0,'Beaufighter Ic',5)
INSERT INTO "FactoryTypes" VALUES(2164,0,'Beaufighter VIc',5)
INSERT INTO "FactoryTypes" VALUES(2165,0,'Beaufighter X',5)
INSERT INTO "FactoryTypes" VALUES(2166,0,'Beaufighter 21',5)
INSERT INTO "FactoryTypes" VALUES(2168,0,'Beaufort V',5)
INSERT INTO "FactoryTypes" VALUES(2169,0,'Beaufort VIII',5)
INSERT INTO "FactoryTypes" VALUES(2171,0,'Boomerang C-12',5)
INSERT INTO "FactoryTypes" VALUES(2172,0,'Boomerang C-19',5)
INSERT INTO "FactoryTypes" VALUES(2174,0,'A-20C Boston',5)
INSERT INTO "FactoryTypes" VALUES(2175,0,'A-20G Boston',5)
INSERT INTO "FactoryTypes" VALUES(2177,0,'B339-23',5)
INSERT INTO "FactoryTypes" VALUES(2178,0,'B339-23 (PR)',5)
INSERT INTO "FactoryTypes" VALUES(2180,0,'Catalina I',5)
INSERT INTO "FactoryTypes" VALUES(2181,0,'DH-84 Dragon',5)
INSERT INTO "FactoryTypes" VALUES(2182,0,'C-47 Dakota',5)
INSERT INTO "FactoryTypes" VALUES(2183,0,'DC-2',5)
INSERT INTO "FactoryTypes" VALUES(2184,0,'Do-24K-1',5)
INSERT INTO "FactoryTypes" VALUES(2185,0,'S.23 Empire',5)
INSERT INTO "FactoryTypes" VALUES(2187,0,'Hudson I',5)
INSERT INTO "FactoryTypes" VALUES(2188,0,'Hudson III (LR)',5)
INSERT INTO "FactoryTypes" VALUES(2189,0,'Hudson C.IV',5)
INSERT INTO "FactoryTypes" VALUES(2190,0,'PV-1 Ventura',5)
INSERT INTO "FactoryTypes" VALUES(2192,0,'Kittyhawk IA',5)
INSERT INTO "FactoryTypes" VALUES(2193,0,'Kittyhawk III',5)
INSERT INTO "FactoryTypes" VALUES(2194,0,'Kittyhawk IV',5)
INSERT INTO "FactoryTypes" VALUES(2196,0,'F-4 Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2197,0,'C-60A Lodestar',5)
INSERT INTO "FactoryTypes" VALUES(2199,0,'Mitchell II',5)
INSERT INTO "FactoryTypes" VALUES(2200,0,'Mitchell III',5)
INSERT INTO "FactoryTypes" VALUES(2202,0,'Mosquito FB.40',5)
INSERT INTO "FactoryTypes" VALUES(2203,0,'Mosquito PR.40',5)
INSERT INTO "FactoryTypes" VALUES(2204,0,'Mosquito PR.41',5)
INSERT INTO "FactoryTypes" VALUES(2205,0,'P-51D Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2207,0,'P-39D Airacobra',5)
INSERT INTO "FactoryTypes" VALUES(2208,0,'P-43A-1 Lancer',5)
INSERT INTO "FactoryTypes" VALUES(2209,0,'PBM-3R Mariner',5)
INSERT INTO "FactoryTypes" VALUES(2211,0,'Spitfire Vc Trop',5)
INSERT INTO "FactoryTypes" VALUES(2212,0,'Spitfire VIII',5)
INSERT INTO "FactoryTypes" VALUES(2214,0,'Sunderland C.III',5)
INSERT INTO "FactoryTypes" VALUES(2216,0,'Vengeance I',5)
INSERT INTO "FactoryTypes" VALUES(2218,0,'Wirraway',5)
INSERT INTO "FactoryTypes" VALUES(2219,0,'OS2U-3 Kingfisher',5)
INSERT INTO "FactoryTypes" VALUES(2220,0,'Seagull V',5)
INSERT INTO "FactoryTypes" VALUES(2221,0,'Catalina IIIA',5)
INSERT INTO "FactoryTypes" VALUES(2222,0,'Catalina VI',5)
INSERT INTO "FactoryTypes" VALUES(2224,0,'Beaufort I',5)
INSERT INTO "FactoryTypes" VALUES(2226,0,'Bolingbroke IV',5)
INSERT INTO "FactoryTypes" VALUES(2227,0,'Canso A',5)
INSERT INTO "FactoryTypes" VALUES(2228,0,'C-47 Dakota',5)
INSERT INTO "FactoryTypes" VALUES(2229,0,'Hurricane XIIb',5)
INSERT INTO "FactoryTypes" VALUES(2231,0,'Kittyhawk I',5)
INSERT INTO "FactoryTypes" VALUES(2232,0,'Kittyhawk III',5)
INSERT INTO "FactoryTypes" VALUES(2233,0,'Kittyhawk IV',5)
INSERT INTO "FactoryTypes" VALUES(2235,0,'Liberator GR.VI',5)
INSERT INTO "FactoryTypes" VALUES(2237,0,'Mosquito FB.26',5)
INSERT INTO "FactoryTypes" VALUES(2239,0,'Shark III',5)
INSERT INTO "FactoryTypes" VALUES(2240,0,'Stranraer II',5)
INSERT INTO "FactoryTypes" VALUES(2241,0,'Ventura GR.V',5)
INSERT INTO "FactoryTypes" VALUES(2243,0,'PBY-5 Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2244,0,'C-47 Dakota',5)
INSERT INTO "FactoryTypes" VALUES(2245,0,'DH-89 Dragon Rapide',5)
INSERT INTO "FactoryTypes" VALUES(2247,0,'F4U-1D Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2249,0,'Hudson III (LR)',5)
INSERT INTO "FactoryTypes" VALUES(2250,0,'C-63 Hudson',5)
INSERT INTO "FactoryTypes" VALUES(2251,0,'PV-1 Ventura',5)
INSERT INTO "FactoryTypes" VALUES(2252,0,'C-60A Lodestar',5)
INSERT INTO "FactoryTypes" VALUES(2254,0,'Kittyhawk IA',5)
INSERT INTO "FactoryTypes" VALUES(2255,0,'Kittyhawk III',5)
INSERT INTO "FactoryTypes" VALUES(2256,0,'Kittyhawk IV',5)
INSERT INTO "FactoryTypes" VALUES(2258,0,'P-51D Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2260,0,'SBD-3 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2261,0,'SBD-5 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2263,0,'TBF-1C Avenger',5)
INSERT INTO "FactoryTypes" VALUES(2264,0,'S.19 Singapore III',5)
INSERT INTO "FactoryTypes" VALUES(2265,0,'Vildebeest IV',5)
INSERT INTO "FactoryTypes" VALUES(2266,0,'Vincent I',5)
INSERT INTO "FactoryTypes" VALUES(2267,0,'Walrus II',5)
INSERT INTO "FactoryTypes" VALUES(2269,0,'A-20A Havoc',5)
INSERT INTO "FactoryTypes" VALUES(2271,0,'A-20A1 Havoc',5)
INSERT INTO "FactoryTypes" VALUES(2272,0,'A-20G Havoc',5)
INSERT INTO "FactoryTypes" VALUES(2274,0,'A-24 Banshee',5)
INSERT INTO "FactoryTypes" VALUES(2275,0,'A-24B Banshee',5)
INSERT INTO "FactoryTypes" VALUES(2276,0,'A-29 Hudson',5)
INSERT INTO "FactoryTypes" VALUES(2277,0,'A-26B Invader',5)
INSERT INTO "FactoryTypes" VALUES(2278,0,'A-26C Invader',5)
INSERT INTO "FactoryTypes" VALUES(2279,0,'A-36 Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2281,0,'B-10B',5)
INSERT INTO "FactoryTypes" VALUES(2282,0,'B-18A Bolo',5)
INSERT INTO "FactoryTypes" VALUES(2283,0,'Beech 18-S',5)
INSERT INTO "FactoryTypes" VALUES(2284,0,'B-17D Fortress',5)
INSERT INTO "FactoryTypes" VALUES(2285,0,'B-17E Fortress',5)
INSERT INTO "FactoryTypes" VALUES(2286,0,'B-17F Fortress',5)
INSERT INTO "FactoryTypes" VALUES(2287,0,'B-17G Fortress',5)
INSERT INTO "FactoryTypes" VALUES(2289,0,'LB-30 Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2290,0,'B-24D Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2291,0,'B-24D1 Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2292,0,'B-24J Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2294,0,'B-25B Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2295,0,'B-25C Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2296,0,'B-25D1 Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2297,0,'B-25G Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2298,0,'B-25H Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2299,0,'B-25J1 Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2300,0,'B-25J11 Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2302,0,'B-26 Marauder',5)
INSERT INTO "FactoryTypes" VALUES(2303,0,'B-26B Marauder',5)
INSERT INTO "FactoryTypes" VALUES(2304,0,'B-29-1 Superfort',5)
INSERT INTO "FactoryTypes" VALUES(2305,0,'B-29-25 Superfort',5)
INSERT INTO "FactoryTypes" VALUES(2306,0,'B-29B Superfort',5)
INSERT INTO "FactoryTypes" VALUES(2307,0,'B-32 Dominator',5)
INSERT INTO "FactoryTypes" VALUES(2308,0,'C-33',5)
INSERT INTO "FactoryTypes" VALUES(2309,0,'C-46A Commando',5)
INSERT INTO "FactoryTypes" VALUES(2310,0,'C-46D Commando',5)
INSERT INTO "FactoryTypes" VALUES(2311,0,'C-47 Skytrain',5)
INSERT INTO "FactoryTypes" VALUES(2312,0,'C-54 Skymaster',5)
INSERT INTO "FactoryTypes" VALUES(2314,0,'C-87 Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2315,0,'F-4 Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2316,0,'F-5A Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2317,0,'F-5E Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2318,0,'F-6C Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2319,0,'F-6D Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2320,0,'F-7A Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2321,0,'F-10 Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2322,0,'F-13 Superfortress',5)
INSERT INTO "FactoryTypes" VALUES(2323,0,'O-47A',5)
INSERT INTO "FactoryTypes" VALUES(2324,0,'O-49 Vigilant',5)
INSERT INTO "FactoryTypes" VALUES(2326,0,'P-26A',5)
INSERT INTO "FactoryTypes" VALUES(2327,0,'P-35A',5)
INSERT INTO "FactoryTypes" VALUES(2328,0,'P-36A Mohawk',5)
INSERT INTO "FactoryTypes" VALUES(2330,0,'P-38E Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2331,0,'P-38F Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2332,0,'P-38G Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2333,0,'P-38H Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2334,0,'P-38J Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2335,0,'P-38L Lightning',5)
INSERT INTO "FactoryTypes" VALUES(2336,0,'P-39D Airacobra',5)
INSERT INTO "FactoryTypes" VALUES(2337,0,'P-39N2 Airacobra',5)
INSERT INTO "FactoryTypes" VALUES(2338,0,'P-39N1 Airacobra',5)
INSERT INTO "FactoryTypes" VALUES(2339,0,'P-400 Airacobra',5)
INSERT INTO "FactoryTypes" VALUES(2341,0,'P-40B Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2342,0,'P-40E Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2343,0,'P-40K Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2344,0,'P-40N1 Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2345,0,'P-40N5 Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2346,0,'P-40N26 Warhawk',5)
INSERT INTO "FactoryTypes" VALUES(2347,0,'P-43 Lancer',5)
INSERT INTO "FactoryTypes" VALUES(2348,0,'P-43A Lancer',5)
INSERT INTO "FactoryTypes" VALUES(2349,0,'P-47D2 Thunderbolt',5)
INSERT INTO "FactoryTypes" VALUES(2350,0,'P-47D25 Thunderbolt',5)
INSERT INTO "FactoryTypes" VALUES(2351,0,'P-47N Thunderbolt',5)
INSERT INTO "FactoryTypes" VALUES(2353,0,'P-51A Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2354,0,'P-51B Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2355,0,'P-51D Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2356,0,'P-51H Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2358,0,'P-61A Black Widow',5)
INSERT INTO "FactoryTypes" VALUES(2359,0,'P-61C Black Widow',5)
INSERT INTO "FactoryTypes" VALUES(2360,0,'P-70 Havoc',5)
INSERT INTO "FactoryTypes" VALUES(2361,0,'P-70A-1 Havoc',5)
INSERT INTO "FactoryTypes" VALUES(2363,0,'P-80A Shooting Star',5)
INSERT INTO "FactoryTypes" VALUES(2364,0,'P-82B Twin Mustang',5)
INSERT INTO "FactoryTypes" VALUES(2365,0,'Stearman 75M',5)
INSERT INTO "FactoryTypes" VALUES(2368,0,'A-20H',5)
INSERT INTO "FactoryTypes" VALUES(2370,0,'B-25J',5)
INSERT INTO "FactoryTypes" VALUES(2372,0,'Do J Wal',5)
INSERT INTO "FactoryTypes" VALUES(2373,0,'I-15bis',5)
INSERT INTO "FactoryTypes" VALUES(2374,0,'I-153',5)
INSERT INTO "FactoryTypes" VALUES(2375,0,'I-16m24',5)
INSERT INTO "FactoryTypes" VALUES(2377,0,'IL-2',5)
INSERT INTO "FactoryTypes" VALUES(2378,0,'IL-2m3',5)
INSERT INTO "FactoryTypes" VALUES(2379,0,'IL-10',5)
INSERT INTO "FactoryTypes" VALUES(2381,0,'DB-3M',5)
INSERT INTO "FactoryTypes" VALUES(2382,0,'DB-3T',5)
INSERT INTO "FactoryTypes" VALUES(2383,0,'IL-4T',5)
INSERT INTO "FactoryTypes" VALUES(2384,0,'G-2',5)
INSERT INTO "FactoryTypes" VALUES(2386,0,'La-5FN',5)
INSERT INTO "FactoryTypes" VALUES(2387,0,'La-7',5)
INSERT INTO "FactoryTypes" VALUES(2388,0,'LaGG-3',5)
INSERT INTO "FactoryTypes" VALUES(2390,0,'Li-2P',5)
INSERT INTO "FactoryTypes" VALUES(2391,0,'MBR-2',5)
INSERT INTO "FactoryTypes" VALUES(2393,0,'Mig-3',5)
INSERT INTO "FactoryTypes" VALUES(2394,0,'P-39Q',5)
INSERT INTO "FactoryTypes" VALUES(2395,0,'P-63A',5)
INSERT INTO "FactoryTypes" VALUES(2397,0,'PBN-1',5)
INSERT INTO "FactoryTypes" VALUES(2399,0,'Pe-2',5)
INSERT INTO "FactoryTypes" VALUES(2400,0,'Pe-2R',5)
INSERT INTO "FactoryTypes" VALUES(2402,0,'R-10',5)
INSERT INTO "FactoryTypes" VALUES(2403,0,'R-12',5)
INSERT INTO "FactoryTypes" VALUES(2404,0,'Li-2VV',5)
INSERT INTO "FactoryTypes" VALUES(2406,0,'SB-2',5)
INSERT INTO "FactoryTypes" VALUES(2407,0,'TB-3',5)
INSERT INTO "FactoryTypes" VALUES(2408,0,'Tu-2S',5)
INSERT INTO "FactoryTypes" VALUES(2410,0,'Yak-7B',5)
INSERT INTO "FactoryTypes" VALUES(2411,0,'Yak-9',5)
INSERT INTO "FactoryTypes" VALUES(2412,0,'Yak-9D',5)
INSERT INTO "FactoryTypes" VALUES(2413,0,'Yak-9R',5)
INSERT INTO "FactoryTypes" VALUES(2414,0,'Yak-9T',5)
INSERT INTO "FactoryTypes" VALUES(2415,0,'Yak-9U',5)
INSERT INTO "FactoryTypes" VALUES(2419,0,'F2A-2 Buffalo',5)
INSERT INTO "FactoryTypes" VALUES(2420,0,'F2A-3 Buffalo',5)
INSERT INTO "FactoryTypes" VALUES(2421,0,'F2A-2P Buffalo',5)
INSERT INTO "FactoryTypes" VALUES(2422,0,'F4F-3A Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2423,0,'F4F-3 Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2424,0,'F4F-3P Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2425,0,'F4F-4 Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2426,0,'F4F-7 Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2427,0,'FM-1 Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2428,0,'FM-2 Wildcat',5)
INSERT INTO "FactoryTypes" VALUES(2429,0,'F4U-1 Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2430,0,'F4U-1A Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2431,0,'F4U-1D Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2432,0,'F4U-4 Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2433,0,'F2G-1 Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2435,0,'F6F-3 Hellcat',5)
INSERT INTO "FactoryTypes" VALUES(2436,0,'F6F-3N Hellcat',5)
INSERT INTO "FactoryTypes" VALUES(2437,0,'F6F-5 Hellcat',5)
INSERT INTO "FactoryTypes" VALUES(2438,0,'F6F-5N Hellcat',5)
INSERT INTO "FactoryTypes" VALUES(2439,0,'F6F-5P Hellcat',5)
INSERT INTO "FactoryTypes" VALUES(2440,0,'F4U-2 Corsair',5)
INSERT INTO "FactoryTypes" VALUES(2441,0,'F7F-2N Tigercat',5)
INSERT INTO "FactoryTypes" VALUES(2442,0,'F7F-3 Tigercat',5)
INSERT INTO "FactoryTypes" VALUES(2443,0,'F7F-3P Tigercat',5)
INSERT INTO "FactoryTypes" VALUES(2444,0,'F8F-1 Bearcat',5)
INSERT INTO "FactoryTypes" VALUES(2445,0,'FR-1 Fireball',5)
INSERT INTO "FactoryTypes" VALUES(2447,0,'OS2U-3 Kingfisher',5)
INSERT INTO "FactoryTypes" VALUES(2450,0,'PB2Y-3 Coronado',5)
INSERT INTO "FactoryTypes" VALUES(2451,0,'PB2Y-3R Coronado',5)
INSERT INTO "FactoryTypes" VALUES(2452,0,'PB2Y-5 Coronado',5)
INSERT INTO "FactoryTypes" VALUES(2454,0,'PB4Y-1 Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2455,0,'PB4Y-1P Liberator',5)
INSERT INTO "FactoryTypes" VALUES(2456,0,'PB4Y-2 Privateer',5)
INSERT INTO "FactoryTypes" VALUES(2458,0,'PBJ-1D Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2459,0,'PBJ-1H Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2460,0,'PBJ-1J Mitchell',5)
INSERT INTO "FactoryTypes" VALUES(2462,0,'PBM-3D Mariner',5)
INSERT INTO "FactoryTypes" VALUES(2463,0,'PBM-5 Mariner',5)
INSERT INTO "FactoryTypes" VALUES(2465,0,'PBY-4 Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2466,0,'PBY-5 Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2467,0,'PBY-5A Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2468,0,'PBY-6A Catalina',5)
INSERT INTO "FactoryTypes" VALUES(2470,0,'PV-1 Ventura',5)
INSERT INTO "FactoryTypes" VALUES(2471,0,'PV-1N Ventura',5)
INSERT INTO "FactoryTypes" VALUES(2472,0,'PV-2 Harpoon',5)
INSERT INTO "FactoryTypes" VALUES(2474,0,'R3D-2',5)
INSERT INTO "FactoryTypes" VALUES(2475,0,'R4D-5 Skytrain',5)
INSERT INTO "FactoryTypes" VALUES(2476,0,'R5C-1 Commando',5)
INSERT INTO "FactoryTypes" VALUES(2478,0,'SB2U-3 Vindicator',5)
INSERT INTO "FactoryTypes" VALUES(2480,0,'SBC-4 Helldiver',5)
INSERT INTO "FactoryTypes" VALUES(2481,0,'SB2C-1C Helldiver',5)
INSERT INTO "FactoryTypes" VALUES(2482,0,'SB2C-3 Helldiver',5)
INSERT INTO "FactoryTypes" VALUES(2483,0,'SB2C-4 Helldiver',5)
INSERT INTO "FactoryTypes" VALUES(2484,0,'SB2C-5 Helldiver',5)
INSERT INTO "FactoryTypes" VALUES(2485,0,'SBD-2 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2486,0,'SBD-1 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2487,0,'SBD-3 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2488,0,'SBD-5 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2489,0,'SBD-6 Dauntless',5)
INSERT INTO "FactoryTypes" VALUES(2490,0,'SNJ-3 Texan',5)
INSERT INTO "FactoryTypes" VALUES(2491,0,'SOC-1 Seagull',5)
INSERT INTO "FactoryTypes" VALUES(2492,0,'SO3C-2 Seamew',5)
INSERT INTO "FactoryTypes" VALUES(2493,0,'TBD-1 Devastator',5)
INSERT INTO "FactoryTypes" VALUES(2494,0,'ZPK',5)
INSERT INTO "FactoryTypes" VALUES(2495,0,'TBF-1 Avenger',5)
INSERT INTO "FactoryTypes" VALUES(2496,0,'TBM-1C Avenger',5)
INSERT INTO "FactoryTypes" VALUES(2497,0,'TBM-3 Avenger',5)
INSERT INTO "FactoryTypes" VALUES(2601,0,'A5M4 Claude',5)
INSERT INTO "FactoryTypes" VALUES(2603,0,'A6M2 Zero',5)
INSERT INTO "FactoryTypes" VALUES(2604,0,'A6M2 Sen Baku',5)
INSERT INTO "FactoryTypes" VALUES(2605,0,'A6M2-N Rufe',5)
INSERT INTO "FactoryTypes" VALUES(2607,0,'A6M2-K Zero',5)
INSERT INTO "FactoryTypes" VALUES(2609,0,'A6M3 Zero',5)
INSERT INTO "FactoryTypes" VALUES(2610,0,'A6M3a Zero',5)
INSERT INTO "FactoryTypes" VALUES(2612,0,'A6M5 Zero',5)
INSERT INTO "FactoryTypes" VALUES(2614,0,'A6M5b Zero',5)
INSERT INTO "FactoryTypes" VALUES(2615,0,'A6M5d-S Zero',5)
INSERT INTO "FactoryTypes" VALUES(2616,0,'A6M5c Zero',5)
INSERT INTO "FactoryTypes" VALUES(2617,0,'A6M7 Zero',5)
INSERT INTO "FactoryTypes" VALUES(2619,0,'A6M8 Zero',5)
INSERT INTO "FactoryTypes" VALUES(2621,0,'A7M2 Sam',5)
INSERT INTO "FactoryTypes" VALUES(2622,0,'A7M3-J Sam',5)
INSERT INTO "FactoryTypes" VALUES(2623,0,'B4Y1 Jean',5)
INSERT INTO "FactoryTypes" VALUES(2625,0,'B5M1 Mabel',5)
INSERT INTO "FactoryTypes" VALUES(2627,0,'B5N1 Kate',5)
INSERT INTO "FactoryTypes" VALUES(2628,0,'B5N2 Kate',5)
INSERT INTO "FactoryTypes" VALUES(2630,0,'B6N1 Jill',5)
INSERT INTO "FactoryTypes" VALUES(2631,0,'B6N2 Jill',5)
INSERT INTO "FactoryTypes" VALUES(2632,0,'B6N2a Jill',5)
INSERT INTO "FactoryTypes" VALUES(2635,0,'B7A2 Grace',5)
INSERT INTO "FactoryTypes" VALUES(2637,0,'C5M2 Babs',5)
INSERT INTO "FactoryTypes" VALUES(2639,0,'C6N1 Myrt',5)
INSERT INTO "FactoryTypes" VALUES(2640,0,'C6N1-S Myrt',5)
INSERT INTO "FactoryTypes" VALUES(2641,0,'C6N2 Myrt',5)
INSERT INTO "FactoryTypes" VALUES(2642,0,'D1A2 Susie',5)
INSERT INTO "FactoryTypes" VALUES(2644,0,'D3A1 Val',5)
INSERT INTO "FactoryTypes" VALUES(2645,0,'D3A2 Val',5)
INSERT INTO "FactoryTypes" VALUES(2647,0,'D5Y1 Myojo',5)
INSERT INTO "FactoryTypes" VALUES(2649,0,'D4Y1 Judy',5)
INSERT INTO "FactoryTypes" VALUES(2650,0,'D4Y2 Judy',5)
INSERT INTO "FactoryTypes" VALUES(2651,0,'D4Y3 Judy',5)
INSERT INTO "FactoryTypes" VALUES(2652,0,'D4Y4 Judy',5)
INSERT INTO "FactoryTypes" VALUES(2655,0,'D4Y1-C Judy',5)
INSERT INTO "FactoryTypes" VALUES(2656,0,'D4Y2-C Judy',5)
INSERT INTO "FactoryTypes" VALUES(2658,0,'D4Y2-S Judy',5)
INSERT INTO "FactoryTypes" VALUES(2660,0,'E13A1 Jake',5)
INSERT INTO "FactoryTypes" VALUES(2661,0,'E13A1b Jake',5)
INSERT INTO "FactoryTypes" VALUES(2663,0,'E14Y1 Glen',5)
INSERT INTO "FactoryTypes" VALUES(2664,0,'E15K1 Norm',5)
INSERT INTO "FactoryTypes" VALUES(2665,0,'E16A1 Paul',5)
INSERT INTO "FactoryTypes" VALUES(2666,0,'E7K2 Alf',5)
INSERT INTO "FactoryTypes" VALUES(2667,0,'E8N2 Dave',5)
INSERT INTO "FactoryTypes" VALUES(2668,0,'F1M2 Pete',5)
INSERT INTO "FactoryTypes" VALUES(2670,0,'G3M2 Nell',5)
INSERT INTO "FactoryTypes" VALUES(2671,0,'G3M3 Nell',5)
INSERT INTO "FactoryTypes" VALUES(2673,0,'G4M1 Betty',5)
INSERT INTO "FactoryTypes" VALUES(2674,0,'G4M2 Betty',5)
INSERT INTO "FactoryTypes" VALUES(2675,0,'G4M2a Betty',5)
INSERT INTO "FactoryTypes" VALUES(2677,0,'G4M2e Betty',5)
INSERT INTO "FactoryTypes" VALUES(2678,0,'G4M3a Betty',5)
INSERT INTO "FactoryTypes" VALUES(2679,0,'G4M1-L Betty',5)
INSERT INTO "FactoryTypes" VALUES(2681,0,'H6K2-L Mavis',5)
INSERT INTO "FactoryTypes" VALUES(2682,0,'H6K4-L Mavis',5)
INSERT INTO "FactoryTypes" VALUES(2683,0,'H6K4 Mavis',5)
INSERT INTO "FactoryTypes" VALUES(2684,0,'H6K5 Mavis',5)
INSERT INTO "FactoryTypes" VALUES(2686,0,'H8K1 Emily',5)
INSERT INTO "FactoryTypes" VALUES(2687,0,'H8K2 Emily',5)
INSERT INTO "FactoryTypes" VALUES(2688,0,'H8K2-L Emily',5)
INSERT INTO "FactoryTypes" VALUES(2690,0,'J1N1-C Irving',5)
INSERT INTO "FactoryTypes" VALUES(2691,0,'J1N1-S Irving',5)
INSERT INTO "FactoryTypes" VALUES(2692,0,'J1N1-Sa Irving',5)
INSERT INTO "FactoryTypes" VALUES(2694,0,'J2M2 Jack',5)
INSERT INTO "FactoryTypes" VALUES(2695,0,'J2M3 Jack',5)
INSERT INTO "FactoryTypes" VALUES(2697,0,'J2M5 Jack',5)
INSERT INTO "FactoryTypes" VALUES(2699,0,'J7W1 Shinden',5)
INSERT INTO "FactoryTypes" VALUES(2701,0,'J8M1 Shusei',5)
INSERT INTO "FactoryTypes" VALUES(2703,0,'Kikka',5)
INSERT INTO "FactoryTypes" VALUES(2705,0,'K5Y1 Willow',5)
INSERT INTO "FactoryTypes" VALUES(2707,0,'K11W1 Shiragiku',5)
INSERT INTO "FactoryTypes" VALUES(2709,0,'L2D2 Tabby',5)
INSERT INTO "FactoryTypes" VALUES(2710,0,'L3Y2 Tina',5)
INSERT INTO "FactoryTypes" VALUES(2712,0,'M6A1 Seiran',5)
INSERT INTO "FactoryTypes" VALUES(2714,0,'N1K1 Rex',5)
INSERT INTO "FactoryTypes" VALUES(2715,0,'N1K1-J George',5)
INSERT INTO "FactoryTypes" VALUES(2716,0,'N1K2-J George',5)
INSERT INTO "FactoryTypes" VALUES(2718,0,'N1K5-J George',5)
INSERT INTO "FactoryTypes" VALUES(2721,0,'P1Y1 Frances',5)
INSERT INTO "FactoryTypes" VALUES(2722,0,'P1Y3 Frances',5)
INSERT INTO "FactoryTypes" VALUES(2724,0,'P1Y2 Frances',5)
INSERT INTO "FactoryTypes" VALUES(2725,0,'P1Y2-S Frances',5)
INSERT INTO "FactoryTypes" VALUES(2727,0,'Q1W1 Lorna',5)
INSERT INTO "FactoryTypes" VALUES(2732,0,'S1A1 Denko',5)
INSERT INTO "FactoryTypes" VALUES(2734,0,'Toka',5)
INSERT INTO "FactoryTypes" VALUES(2740,0,'Ka-1',5)
INSERT INTO "FactoryTypes" VALUES(2742,0,'Ki-9 Spruce',5)
INSERT INTO "FactoryTypes" VALUES(2744,0,'Ki-15-II Babs',5)
INSERT INTO "FactoryTypes" VALUES(2746,0,'Ki-21-Ic Sally',5)
INSERT INTO "FactoryTypes" VALUES(2747,0,'Ki-21-IIa Sally',5)
INSERT INTO "FactoryTypes" VALUES(2748,0,'Ki-21-IIb Sally',5)
INSERT INTO "FactoryTypes" VALUES(2750,0,'MC-21 Sally',5)
INSERT INTO "FactoryTypes" VALUES(2752,0,'Ki-27b Nate',5)
INSERT INTO "FactoryTypes" VALUES(2754,0,'Ki-30 Ann',5)
INSERT INTO "FactoryTypes" VALUES(2755,0,'Ki-32 Mary',5)
INSERT INTO "FactoryTypes" VALUES(2757,0,'Ki-36 Ida',5)
INSERT INTO "FactoryTypes" VALUES(2759,0,'Ki-43-Ia Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2760,0,'Ki-43-Ib Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2761,0,'Ki-43-Ic Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2762,0,'Ki-43-IIa Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2763,0,'Ki-43-IIb Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2764,0,'Ki-43-IIIa Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2765,0,'Ki-43-IV Oscar',5)
INSERT INTO "FactoryTypes" VALUES(2768,0,'Ki-44 Tojo',5)
INSERT INTO "FactoryTypes" VALUES(2769,0,'Ki-44-IIa Tojo',5)
INSERT INTO "FactoryTypes" VALUES(2770,0,'Ki-44-IIb Tojo',5)
INSERT INTO "FactoryTypes" VALUES(2771,0,'Ki-44-IIc Tojo',5)
INSERT INTO "FactoryTypes" VALUES(2775,0,'Ki-45 KAIa Nick',5)
INSERT INTO "FactoryTypes" VALUES(2776,0,'Ki-45 KAIb Nick',5)
INSERT INTO "FactoryTypes" VALUES(2777,0,'Ki-45 KAIc Nick',5)
INSERT INTO "FactoryTypes" VALUES(2778,0,'Ki-45 KAId Nick',5)
INSERT INTO "FactoryTypes" VALUES(2781,0,'Ki-46-I Dinah',5)
INSERT INTO "FactoryTypes" VALUES(2782,0,'Ki-46-II Dinah',5)
INSERT INTO "FactoryTypes" VALUES(2783,0,'Ki-46-III Dinah',5)
INSERT INTO "FactoryTypes" VALUES(2784,0,'Ki-46-IIIb Dinah',5)
INSERT INTO "FactoryTypes" VALUES(2785,0,'Ki-46-III KAI Dinah',5)
INSERT INTO "FactoryTypes" VALUES(2788,0,'Ki-48-Ib Lily',5)
INSERT INTO "FactoryTypes" VALUES(2789,0,'Ki-48-IIa Lily',5)
INSERT INTO "FactoryTypes" VALUES(2790,0,'Ki-48-IIb Lily',5)
INSERT INTO "FactoryTypes" VALUES(2791,0,'Ki-48-IIc Lily',5)
INSERT INTO "FactoryTypes" VALUES(2793,0,'Ki-49-Ia Helen',5)
INSERT INTO "FactoryTypes" VALUES(2794,0,'Ki-49-IIa Helen',5)
INSERT INTO "FactoryTypes" VALUES(2795,0,'Ki-49-IIb Helen',5)
INSERT INTO "FactoryTypes" VALUES(2796,0,'Ki-49-II KAI Helen',5)
INSERT INTO "FactoryTypes" VALUES(2797,0,'Ki-51 Sonia',5)
INSERT INTO "FactoryTypes" VALUES(2798,0,'Ki-51b Sonia ',5)
INSERT INTO "FactoryTypes" VALUES(2800,0,'Ki-54b Hickory',5)
INSERT INTO "FactoryTypes" VALUES(2801,0,'Ki-54c Hickory',5)
INSERT INTO "FactoryTypes" VALUES(2802,0,'Ki-55 Ida',5)
INSERT INTO "FactoryTypes" VALUES(2804,0,'Ki-56 Thalia',5)
INSERT INTO "FactoryTypes" VALUES(2805,0,'Ki-57-I Topsy',5)
INSERT INTO "FactoryTypes" VALUES(2806,0,'Ki-57-II Topsy',5)
INSERT INTO "FactoryTypes" VALUES(2807,0,'Ki-59 Theresa',5)
INSERT INTO "FactoryTypes" VALUES(2809,0,'Ki-61-Ia Tony',5)
INSERT INTO "FactoryTypes" VALUES(2810,0,'Ki-61-Ib Tony',5)
INSERT INTO "FactoryTypes" VALUES(2811,0,'Ki-61-Ic Tony',5)
INSERT INTO "FactoryTypes" VALUES(2812,0,'Ki-61-Id Tony',5)
INSERT INTO "FactoryTypes" VALUES(2813,0,'Ki-61-II KAI Tony',5)
INSERT INTO "FactoryTypes" VALUES(2815,0,'Ki-67-Ia Peggy',5)
INSERT INTO "FactoryTypes" VALUES(2816,0,'Ki-67-Ib Peggy',5)
INSERT INTO "FactoryTypes" VALUES(2817,0,'Ki-109-I Peggy',5)
INSERT INTO "FactoryTypes" VALUES(2818,0,'Ki-67-Ia (T) Peggy',5)
INSERT INTO "FactoryTypes" VALUES(2819,0,'Ki-74-I Patsy',5)
INSERT INTO "FactoryTypes" VALUES(2820,0,'Ki-76 Stella',5)
INSERT INTO "FactoryTypes" VALUES(2822,0,'Ki-79a Nate',5)
INSERT INTO "FactoryTypes" VALUES(2824,0,'Ki-83',5)
INSERT INTO "FactoryTypes" VALUES(2825,0,'Ki-84a Frank',5)
INSERT INTO "FactoryTypes" VALUES(2826,0,'Ki-84b Frank',5)
INSERT INTO "FactoryTypes" VALUES(2828,0,'Ki-84r Frank',5)
INSERT INTO "FactoryTypes" VALUES(2830,0,'Ki-93-Ia',5)
INSERT INTO "FactoryTypes" VALUES(2831,0,'Ki-93-Ib',5)
INSERT INTO "FactoryTypes" VALUES(2832,0,'Ki-94-II',5)
INSERT INTO "FactoryTypes" VALUES(2834,0,'Ki-95',5)
INSERT INTO "FactoryTypes" VALUES(2836,0,'Ki-100-I Tony',5)
INSERT INTO "FactoryTypes" VALUES(2837,0,'Ki-100-II Tony',5)
INSERT INTO "FactoryTypes" VALUES(2838,0,'Ki-102a Randy',5)
INSERT INTO "FactoryTypes" VALUES(2839,0,'Ki-102b Randy',5)
INSERT INTO "FactoryTypes" VALUES(2840,0,'Ki-102c Randy',5)
INSERT INTO "FactoryTypes" VALUES(2844,0,'Ki-115a Tsurugi',5)
INSERT INTO "FactoryTypes" VALUES(2845,0,'Ki-115b Tsurugi',5)
INSERT INTO "FactoryTypes" VALUES(2847,0,'Ki-119',5)
INSERT INTO "FactoryTypes" VALUES(2848,0,'Ki-201 Karyu',5)
INSERT INTO "FactoryTypes" VALUES(2849,0,'Ki-202 Shusei',5)
INSERT INTO "LocationTypes" VALUES(0,'city')
INSERT INTO "LocationTypes" VALUES(1,'port')
INSERT INTO "LocationTypes" VALUES(2,'radar site')
INSERT INTO "LocationTypes" VALUES(3,'AA unit')
INSERT INTO "LocationTypes" VALUES(4,'headquarters')
INSERT INTO "LocationTypes" VALUES(5,'primary airfield')
INSERT INTO "LocationTypes" VALUES(6,'secondary airfield')
INSERT INTO "LocationTypes" VALUES(7,'infantry unit')
INSERT INTO "LocationTypes" VALUES(8,'armored unit')
INSERT INTO "LocationTypes" VALUES(9,'artillery unit')
INSERT INTO "LocationTypes" VALUES(10,'engineer unit')
INSERT INTO "LocationTypes" VALUES(11,'coastal defense unit')
INSERT INTO "LocationTypes" VALUES(12,'task force')
INSERT INTO "LocationTypes" VALUES(13,'industry')
INSERT INTO "LocationTypes" VALUES(14,'resource')
INSERT INTO "Nationalities" VALUES(1,'IJ Army')
INSERT INTO "Nationalities" VALUES(2,'IJ Navy')
INSERT INTO "Nationalities" VALUES(4,'US Navy')
INSERT INTO "Nationalities" VALUES(5,'US Army')
INSERT INTO "Nationalities" VALUES(6,'US Marines')
INSERT INTO "Nationalities" VALUES(7,'Australian')
INSERT INTO "Nationalities" VALUES(8,'New Zealand')
INSERT INTO "Nationalities" VALUES(9,'British')
INSERT INTO "Nationalities" VALUES(10,'French')
INSERT INTO "Nationalities" VALUES(11,'Dutch')
INSERT INTO "Nationalities" VALUES(12,'Chinese')
INSERT INTO "Nationalities" VALUES(13,'Soviet')
INSERT INTO "Nationalities" VALUES(14,'Indian')
INSERT INTO "Nationalities" VALUES(15,'Commonwealth')
INSERT INTO "Nationalities" VALUES(16,'Philippines')
INSERT INTO "Nationalities" VALUES(18,'Canada')
INSERT INTO "Nationalities" VALUES(63,'Uninitialized')
INSERT INTO "CommandTypes" VALUES(1,'HQ')
INSERT INTO "CommandTypes" VALUES(2,'Large GU')
INSERT INTO "CommandTypes" VALUES(3,'Small GU')
INSERT INTO "CommandTypes" VALUES(4,'TaskForce')
INSERT INTO "CommandTypes" VALUES(5,'Ship')
INSERT INTO "CommandTypes" VALUES(6,'Air unit')
INSERT INTO "CommandTypes" VALUES(127,'BAD COMMAND CAP')
INSERT INTO "Ranks" VALUES(0,'WO')
INSERT INTO "Ranks" VALUES(1,'LT')
INSERT INTO "Ranks" VALUES(2,'LT')
INSERT INTO "Ranks" VALUES(3,'CPT')
INSERT INTO "Ranks" VALUES(4,'MAJ')
INSERT INTO "Ranks" VALUES(5,'LTC')
INSERT INTO "Ranks" VALUES(6,'COL')
INSERT INTO "Ranks" VALUES(7,'MGEN')
INSERT INTO "Ranks" VALUES(8,'LGEN')
INSERT INTO "Ranks" VALUES(9,'GEN')
INSERT INTO "Ranks" VALUES(10,'PO2')
INSERT INTO "Ranks" VALUES(11,'PO1')
INSERT INTO "Ranks" VALUES(12,'CPO')
INSERT INTO "Ranks" VALUES(13,'WO')
INSERT INTO "Ranks" VALUES(14,'ENS')
INSERT INTO "Ranks" VALUES(15,'LTJG')
INSERT INTO "Ranks" VALUES(16,'LT')
INSERT INTO "Ranks" VALUES(17,'LCDR')
INSERT INTO "Ranks" VALUES(18,'CDR')
INSERT INTO "Ranks" VALUES(19,'CPT')
INSERT INTO "Ranks" VALUES(20,'RAMD')
INSERT INTO "Ranks" VALUES(21,'VADM')
INSERT INTO "Ranks" VALUES(22,'ADM')
INSERT INTO "Ranks" VALUES(23,'ENS')
INSERT INTO "Ranks" VALUES(24,'LTJG')
INSERT INTO "Ranks" VALUES(25,'LT')
INSERT INTO "Ranks" VALUES(26,'LCDR')
INSERT INTO "Ranks" VALUES(27,'CDR')
INSERT INTO "Ranks" VALUES(28,'CPT')
INSERT INTO "Ranks" VALUES(29,'RAMD')
INSERT INTO "Ranks" VALUES(30,'VADM')
INSERT INTO "Ranks" VALUES(31,'ADM')
INSERT INTO "Ranks" VALUES(32,'FO')
INSERT INTO "Ranks" VALUES(33,'LT')
INSERT INTO "Ranks" VALUES(34,'LT')
INSERT INTO "Ranks" VALUES(35,'CPT')
INSERT INTO "Ranks" VALUES(36,'MAJ')
INSERT INTO "Ranks" VALUES(37,'LTC')
INSERT INTO "Ranks" VALUES(38,'COL')
INSERT INTO "Ranks" VALUES(39,'BGEN')
INSERT INTO "Ranks" VALUES(40,'MGEN')
INSERT INTO "Ranks" VALUES(41,'LGEN')
INSERT INTO "Ranks" VALUES(42,'GEN')
INSERT INTO "Ranks" VALUES(43,'WO')
INSERT INTO "Ranks" VALUES(44,'PO')
INSERT INTO "Ranks" VALUES(45,'FO')
INSERT INTO "Ranks" VALUES(46,'FLT')
INSERT INTO "Ranks" VALUES(47,'SLDR')
INSERT INTO "Ranks" VALUES(48,'WCDR')
INSERT INTO "Ranks" VALUES(49,'GCPT')
INSERT INTO "Ranks" VALUES(50,'ACOM')
INSERT INTO "Ranks" VALUES(51,'AVM')
INSERT INTO "Ranks" VALUES(52,'AM')
INSERT INTO "Ranks" VALUES(53,'ACM')
INSERT INTO "Ranks" VALUES(127,'CORRUPT RANK')
INSERT INTO "Suffixes" VALUES(0,'')
INSERT INTO "Suffixes" VALUES(31,'AA Regiment')
INSERT INTO "Suffixes" VALUES(32,'AA Battalion')
INSERT INTO "Suffixes" VALUES(33,'AA Division')
INSERT INTO "Suffixes" VALUES(34,'AAA Auto-weapons Battalion')
INSERT INTO "Suffixes" VALUES(35,'AA Machinecannon Company')
INSERT INTO "Suffixes" VALUES(36,'Field AA Battalion')
INSERT INTO "Suffixes" VALUES(37,'Coast AA Regiment')
INSERT INTO "Suffixes" VALUES(41,'Detachment')
INSERT INTO "Suffixes" VALUES(42,'Brigade')
INSERT INTO "Suffixes" VALUES(43,'Mixed Brigade')
INSERT INTO "Suffixes" VALUES(44,'Brigade')
INSERT INTO "Suffixes" VALUES(45,'Division')
INSERT INTO "Suffixes" VALUES(46,'Army')
INSERT INTO "Suffixes" VALUES(47,'Group')
INSERT INTO "Suffixes" VALUES(48,'Corps')
INSERT INTO "Suffixes" VALUES(49,'Fleet')
INSERT INTO "Suffixes" VALUES(71,'Division')
INSERT INTO "Suffixes" VALUES(72,'Brigade')
INSERT INTO "Suffixes" VALUES(73,'Regimental Combat Team')
INSERT INTO "Suffixes" VALUES(74,'Regiment')
INSERT INTO "Suffixes" VALUES(75,'Battalion')
INSERT INTO "Suffixes" VALUES(76,'SNLF')
INSERT INTO "Suffixes" VALUES(77,'Cavalry Division')
INSERT INTO "Suffixes" VALUES(78,'Corps')
INSERT INTO "Suffixes" VALUES(79,'Naval Garrison Unit')
INSERT INTO "Suffixes" VALUES(81,'Division')
INSERT INTO "Suffixes" VALUES(82,'Brigade')
INSERT INTO "Suffixes" VALUES(83,'Regiment')
INSERT INTO "Suffixes" VALUES(84,'Battalion')
INSERT INTO "Suffixes" VALUES(85,'Corps')
INSERT INTO "Suffixes" VALUES(86,'Mechanized Corps')
INSERT INTO "Suffixes" VALUES(87,'Tank Destroyer Battalion')
INSERT INTO "Suffixes" VALUES(88,'Tank Destroyer Company')
INSERT INTO "Suffixes" VALUES(91,'Field Artillery Regiment')
INSERT INTO "Suffixes" VALUES(92,'Field Artillery Battalion')
INSERT INTO "Suffixes" VALUES(93,'Mountain Gun Regiment')
INSERT INTO "Suffixes" VALUES(94,'AT Gun Regiment')
INSERT INTO "Suffixes" VALUES(95,'Battalion')
INSERT INTO "Suffixes" VALUES(96,'Defense Battalion')
INSERT INTO "Suffixes" VALUES(97,'Artillery Division')
INSERT INTO "Suffixes" VALUES(98,'Brigade')
INSERT INTO "Suffixes" VALUES(99,'Regiment')
INSERT INTO "Suffixes" VALUES(101,'Engineer Regiment')
INSERT INTO "Suffixes" VALUES(102,'Engineer Battalion')
INSERT INTO "Suffixes" VALUES(103,'Construction Regiment')
INSERT INTO "Suffixes" VALUES(104,'Construction Battalion')
INSERT INTO "Suffixes" VALUES(105,'Pioneer Regiment')
INSERT INTO "Suffixes" VALUES(106,'Pioneer Battalion')
INSERT INTO "Suffixes" VALUES(107,'Naval Construction Battalion')
INSERT INTO "Suffixes" VALUES(108,'Engineer Aviation Battalion')
INSERT INTO "Suffixes" VALUES(109,'Base Force')
INSERT INTO "Suffixes" VALUES(111,'Coastal Gun Regiment')
INSERT INTO "Suffixes" VALUES(112,'Coastal Gun Battalion')
INSERT INTO "Suffixes" VALUES(113,'Coastal Artillery Regiment')
INSERT INTO "Suffixes" VALUES(114,'Coastal Artillery Battalion')
INSERT INTO "Suffixes" VALUES(115,'Fortress')
INSERT INTO "Suffixes" VALUES(119,'Sup Cvy')
INSERT INTO "Suffixes" VALUES(127,'BAD SUFFIX')
INSERT INTO "TFMissions" VALUES(1,'ACTF',0)
INSERT INTO "TFMissions" VALUES(2,'SCTF',0)
INSERT INTO "TFMissions" VALUES(3,'Bombard',0)
INSERT INTO "TFMissions" VALUES(4,'FastTrans',1)
INSERT INTO "TFMissions" VALUES(5,'Trans',1)
INSERT INTO "TFMissions" VALUES(6,'Replen',0)
INSERT INTO "TFMissions" VALUES(7,'SurfMine',0)
INSERT INTO "TFMissions" VALUES(8,'SubPat',0)
INSERT INTO "TFMissions" VALUES(9,'SubMine',0)
INSERT INTO "TFMissions" VALUES(10,'SubTrans',1)
INSERT INTO "TFMissions" VALUES(11,'ASW',0)
INSERT INTO "TFMissions" VALUES(12,'Escort',0)
INSERT INTO "TFMissions" VALUES(127,'No TF',0)
INSERT INTO "ShipTypes" VALUES(1,'CVB',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(2,'CV',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(3,'CVL',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(4,'CVE',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(5,'BB',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(6,'BC',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(7,'CB',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(8,'CA',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(9,'CL',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(10,'CLAA',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(11,'CS',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(12,'DD',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(13,'DE',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(14,'TB',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(15,'E',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(16,'PG',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(17,'PF',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(18,'KV',FALSE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(19,'PC',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(20,'PB',FALSE,TRUE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(21,'SC',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(22,'PT',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(23,'MTB',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(24,'MGB',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(25,'ML',TRUE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(26,'SS',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(27,'SST',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(28,'SSX',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(29,'AMC',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(30,'CM',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(31,'CMc',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(32,'DM',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(33,'DMS',TRUE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(34,'AM',FALSE,TRUE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(35,'AS',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(36,'AD',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(37,'AV',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(38,'AVD',TRUE,TRUE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(39,'AVP',TRUE,TRUE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(40,'AR',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(41,'ARD',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(42,'AGP',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(43,'AG',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(44,'AO',FALSE,FALSE,FALSE,TRUE)
INSERT INTO "ShipTypes" VALUES(45,'AE',FALSE,FALSE,FALSE,TRUE)
INSERT INTO "ShipTypes" VALUES(46,'AGC',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(47,'APA',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(48,'LSI(L)',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(49,'LSI(M)',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(50,'LSI(S)',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(51,'APD',TRUE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(52,'AKA',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(53,'LSD',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(54,'LSV',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(55,'AP',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(56,'AK',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(57,'AKV',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(58,'AKE',FALSE,FALSE,FALSE,TRUE)
INSERT INTO "ShipTypes" VALUES(59,'AKL',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(60,'TK',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(61,'LST',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(62,'LCI',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(63,'LCI(G)',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(64,'LCI(M)',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(65,'LCI(R)',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(66,'LSM',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(67,'LSM(R)',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(68,'LCM',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(69,'LCT',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(70,'LB',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(71,'LCVP',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(72,'LCS(L)',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(73,'YO',FALSE,FALSE,TRUE,FALSE)
INSERT INTO "ShipTypes" VALUES(74,'ACM',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(75,'YMS',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(76,'YP',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(77,'HDML',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(78,'APc',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(79,'AMc',FALSE,FALSE,FALSE,FALSE)
INSERT INTO "ShipTypes" VALUES(80,'xAP',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(81,'xAPc',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(82,'xAK',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ShipTypes" VALUES(83,'xAKL',FALSE,FALSE,TRUE,TRUE)
INSERT INTO "ACTypes" VALUES(0,'fighter','F',1,FALSE,TRUE,FALSE)
INSERT INTO "ACTypes" VALUES(1,'fighter bomber','FB',1,FALSE,TRUE,TRUE)
INSERT INTO "ACTypes" VALUES(2,'night fighter','NF',1,FALSE,TRUE,FALSE)
INSERT INTO "ACTypes" VALUES(3,'dive bomber','DB',0,TRUE,FALSE,TRUE)
INSERT INTO "ACTypes" VALUES(4,'level bomber','LB',0,TRUE,FALSE,TRUE)
INSERT INTO "ACTypes" VALUES(5,'recon','R',1,TRUE,FALSE,FALSE)
INSERT INTO "ACTypes" VALUES(6,'jet fighter','JF',1,FALSE,TRUE,FALSE)
INSERT INTO "ACTypes" VALUES(7,'electronic warfare','EW',0,TRUE,FALSE,FALSE)
INSERT INTO "ACTypes" VALUES(8,'transport','T',2,FALSE,FALSE,FALSE)
INSERT INTO "ACTypes" VALUES(9,'patrol','P',1,TRUE,FALSE,TRUE)
INSERT INTO "ACTypes" VALUES(10,'float plane','FP',1,TRUE,FALSE,FALSE)
INSERT INTO "ACTypes" VALUES(11,'float fighter','FF',1,FALSE,TRUE,FALSE)
INSERT INTO "ACTypes" VALUES(12,'torpedo bomber','TB',0,TRUE,FALSE,TRUE)
INSERT INTO "ACWeaponFacings" VALUES(0,'F')
INSERT INTO "ACWeaponFacings" VALUES(1,'S')
INSERT INTO "ACWeaponFacings" VALUES(2,'R')
INSERT INTO "ACWeaponFacings" VALUES(3,'TT')
INSERT INTO "ACWeaponFacings" VALUES(4,'BT')
INSERT INTO "ACWeaponFacings" VALUES(5,'TR')
INSERT INTO "ACWeaponFacings" VALUES(6,'BR')
INSERT INTO "ACWeaponFacings" VALUES(7,'UP')
INSERT INTO "ACWeaponFacings" VALUES(8,'C')
INSERT INTO "ACWeaponFacings" VALUES(11,'INT')
INSERT INTO "ACWeaponFacings" VALUES(12,'XT')
INSERT INTO "AGMissions" VALUES(1,'AF Attack',1,FALSE)
INSERT INTO "AGMissions" VALUES(2,'Port Attack',1,FALSE)
INSERT INTO "AGMissions" VALUES(3,'Naval Attack',1,FALSE)
INSERT INTO "AGMissions" VALUES(4,'Ground Attack',1,FALSE)
INSERT INTO "AGMissions" VALUES(5,'Sweep/LRCAP',0,FALSE)
INSERT INTO "AGMissions" VALUES(6,'Escort',0,FALSE)
INSERT INTO "AGMissions" VALUES(7,'Recon',1,FALSE)
INSERT INTO "AGMissions" VALUES(8,'Naval Search',1,FALSE)
INSERT INTO "AGMissions" VALUES(9,'ASW Search',2,FALSE)
INSERT INTO "AGMissions" VALUES(10,'Supply',0,TRUE)
INSERT INTO "AGMissions" VALUES(11,'Troop Trsp.',0,FALSE)
INSERT INTO "AGMissions" VALUES(12,'Training',0,FALSE)
INSERT INTO "AGMissions" VALUES(13,'City Attack',1,FALSE)
INSERT INTO "AGMissions" VALUES(14,'Kamikaze',1,FALSE)
INSERT INTO "AGMissions" VALUES(15,'A-Bombing',1,FALSE)
INSERT INTO "AGMissions" VALUES(16,'Training2',0,FALSE)
INSERT INTO "OccurenceTypes" VALUES(-2,'All Localized')
INSERT INTO "OccurenceTypes" VALUES(-1,'All')
INSERT INTO "OccurenceTypes" VALUES(1,'Ship related')
INSERT INTO "OccurenceTypes" VALUES(2,'LCU related')
INSERT INTO "OccurenceTypes" VALUES(3,'Air related')
INSERT INTO "OccurenceTypes" VALUES(4,'Leader related')
INSERT INTO "OccurenceTypes" VALUES(5,'Base related')
INSERT INTO "OccurenceTypes" VALUES(6,'Reinforcements')
INSERT INTO "Spoilage" VALUES(0,1000,5000)
INSERT INTO "Spoilage" VALUES(1,3000,8000)
INSERT INTO "Spoilage" VALUES(2,9000,17000)
INSERT INTO "Spoilage" VALUES(3,19000,32000)
INSERT INTO "Spoilage" VALUES(4,33000,53000)
INSERT INTO "Spoilage" VALUES(5,51000,80000)
INSERT INTO "Spoilage" VALUES(6,73000,113000)
INSERT INTO "Spoilage" VALUES(7,99000,152000)
INSERT INTO "Spoilage" VALUES(8,129000,197000)
INSERT INTO "Spoilage" VALUES(9,163000,248000)
INSERT INTO "HarborReloadCapa" VALUES(1,15)
INSERT INTO "HarborReloadCapa" VALUES(2,25)
INSERT INTO "HarborReloadCapa" VALUES(3,40)
INSERT INTO "HarborReloadCapa" VALUES(4,110)
INSERT INTO "HarborReloadCapa" VALUES(5,300)
INSERT INTO "HarborReloadCapa" VALUES(6,700)
INSERT INTO "HarborReloadCapa" VALUES(7,5500)
INSERT INTO "HarborReloadCapa" VALUES(8,6000)
INSERT INTO "HarborReloadCapa" VALUES(9,6500)
INSERT INTO "ReloadLevels" VALUES(1,110)
INSERT INTO "ReloadLevels" VALUES(2,500)
INSERT INTO "ReloadLevels" VALUES(3,800)
INSERT INTO "ReloadLevels" VALUES(4,1620)
INSERT INTO "ReloadLevels" VALUES(5,2200)
INSERT INTO "ReloadLevels" VALUES(6,4500)
INSERT INTO "ReloadLevels" VALUES(7,6440)



_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
Post #: 1
RE: v1083c WitP Staff - 9/4/2009 7:45:29 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
See next message.

< Message edited by herwin -- 9/4/2009 8:38:10 AM >


_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 2
RE: v1083c WitP Staff - 9/4/2009 8:27:44 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
The evidence is uploaded here. For convenience in packaging, the save file that produces the problem is inside the db directory. I'm playing Japan against the AI this time. (I was just checking to see if the problem involved which side I was playing.)

< Message edited by herwin -- 9/4/2009 8:40:43 AM >


_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 3
RE: v1083c WitP Staff - 9/4/2009 8:45:51 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
This is curious. There are some files stashed in the main witpstaff directory (rather than db) that seem relevant. Here's the log:
config.directory is db
Now trying plugin UPGTestPlugin
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Matrix Games\War in the Pacific Admiral's Edition\tools\witpstaff\pwsdll.dll: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem
	at java.lang.ClassLoader$NativeLibrary.load(Native Method)
	at java.lang.ClassLoader.loadLibrary0(Unknown Source)
	at java.lang.ClassLoader.loadLibrary(Unknown Source)
	at java.lang.Runtime.loadLibrary0(Unknown Source)
	at java.lang.System.loadLibrary(Unknown Source)
	at de.retsiemuab.witpDecoder.ioreaders.NativeInputStream.<clinit>(Unknown Source)
	at de.retsiemuab.witpDecoder.ioreaders.o.<init>(Unknown Source)
	at de.retsiemuab.witpDecoder.c.a(Unknown Source)
	at de.retsiemuab.witpDecoder.c.<init>(Unknown Source)
	at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
	at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
	at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
	at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
	at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
	at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
	at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
	at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
	at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



This suggests that there's some sort of reconfiguration bug, because the database initialisation--done just before, using the db directory--was fine.

A zip file containing the entirety of the witpstaff directory, with the save file stashed in db, is uploaded here. (This is the only link in the world to that zip file.)


< Message edited by herwin -- 9/4/2009 8:51:39 AM >


_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 4
RE: v1083c WitP Staff - 9/4/2009 9:14:20 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
OK, I backed off to the hotfix version of the dll, and got this:
quote:


config.directory is db
Now trying plugin UPGTestPlugin
Could not read the turn because of java.io.IOException: Skipping forward failed somehow. Unexpected EOF at pos 1040?
java.io.IOException: Skipping forward failed somehow. Unexpected EOF at pos 1040?
at de.retsiemuab.witpDecoder.ioreaders.p.a(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


And then I dropped the new version of the .dll back in the directory and got this:
quote:


config.directory is db
You didn't correctly closed the DB last time. LeaderPrefs exists.
You didn't correctly closed the DB last time. ACFactors exists.
Now trying plugin UPGTestPlugin
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Matrix Games\War in the Pacific Admiral's Edition\tools\witpstaff\pwsdll.dll: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.NativeInputStream.<clinit>(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.o.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


Since my configuration consists of 1080 patched to 1083 using the beta patch, that tells me the beta patch has a problem with witpstaff.

< Message edited by herwin -- 9/4/2009 9:55:57 AM >


_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 5
RE: v1083c WitP Staff - 9/4/2009 9:54:23 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
I reinstalled the hotfix beta (10 August), reran the first turn of scenario one as the Japanese, tried to process the save file, and got the following:

quote:


config.directory is db
You didn't correctly closed the DB last time. LeaderPrefs exists.
You didn't correctly closed the DB last time. ACFactors exists.
Now trying plugin UPGTestPlugin
Couldn't execute the following command:
INSERT INTO "BaseStatus" VALUES (8,2322,706,0,0,0,0,0,0,0,0,0,0,0,0,0,'a Area',3,0,63,0,0,0,0,0,0,0,0);
Couldn't write things to the DB due to java.sql.SQLException: Integrity constraint violation - no parent Nationality2Existing table: Nationalities
java.sql.SQLException: Integrity constraint violation - no parent Nationality2Existing table: Nationalities
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.data.h.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



I then tried reinitialising the database and got this:

quote:


config.directory is .
You didn't correctly closed the DB last time. LeaderPrefs exists.
You didn't correctly closed the DB last time. ACFactors exists.
Now trying plugin UPGTestPlugin
Initialization worked nicely.
Please wait 5 seconds and start me again.
Couldn't execute the following command:
DROP TABLE "LeaderPrefs";
DROP TABLE "ACFactors";
Couldn't shutdown DB.
java.sql.SQLException: Table not found: LeaderPrefs in statement [DROP TABLE "LeaderPrefs"]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.a.g(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.g(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.ao.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.c(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.d(Unknown Source)
at de.retsiemuab.witpDecoder.gui.V.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



And now I tried to load the save file and got this again:
quote:


config.directory is db
Now trying plugin UPGTestPlugin
Couldn't execute the following command:
INSERT INTO "BaseStatus" VALUES (8,2322,706,0,0,0,0,0,0,0,0,0,0,0,0,0,'a Area',3,0,63,0,0,0,0,0,0,0,0);
Couldn't write things to the DB due to java.sql.SQLException: Integrity constraint violation - no parent Nationality2Existing table: Nationalities
java.sql.SQLException: Integrity constraint violation - no parent Nationality2Existing table: Nationalities
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.data.h.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 6
RE: v1083c WitP Staff - 9/4/2009 10:01:10 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
I then cleaned everything out of the witpstaff directory except the installed bits and reinitialised the database. That produced this:

quote:


config.directory is .
Now trying plugin UPGTestPlugin
Initialization worked nicely.
Please wait 5 seconds and start me again.
Couldn't execute the following command:
DROP TABLE "LeaderPrefs";
DROP TABLE "ACFactors";
Couldn't shutdown DB.
java.sql.SQLException: Table not found: LeaderPrefs in statement [DROP TABLE "LeaderPrefs"]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
at de.retsiemuab.witpDecoder.a.b(Unknown Source)
at de.retsiemuab.witpDecoder.a.g(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.g(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.ao.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.c(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.d(Unknown Source)
at de.retsiemuab.witpDecoder.gui.V.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)



That suggests there is a latent bug in witpstaff that people don't notice because they see
quote:


Initialization worked nicely.
Please wait 5 seconds and start me again.

and think everything is fine.

_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 7
RE: v1083c WitP Staff - 9/4/2009 11:29:42 AM   
herwin

 

Posts: 6059
Joined: 5/28/2004
From: Sunderland, UK
Status: offline
OK, I've reinstalled again. Creating the database seems to produce an empty logfile.

Trying to load the savefile produces this:

quote:


config.directory is db
Now trying plugin UPGTestPlugin
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\Matrix Games\War in the Pacific Admiral's Edition\tools\witpstaff\pwsdll.dll: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.NativeInputStream.<clinit>(Unknown Source)
at de.retsiemuab.witpDecoder.ioreaders.o.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.c.a(Unknown Source)
at de.retsiemuab.witpDecoder.c.<init>(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aV.run(Unknown Source)
at org.eclipse.swt.custom.BusyIndicator.showWhile(Unknown Source)
at de.retsiemuab.witpDecoder.gui.bt.a(Unknown Source)
at de.retsiemuab.witpDecoder.gui.X.widgetSelected(Unknown Source)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at de.retsiemuab.witpDecoder.gui.aR.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.a(Unknown Source)
at de.retsiemuab.witpDecoder.Main.main(Unknown Source)


Woos?

_____________________________

Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com

(in reply to herwin)
Post #: 8
RE: v1083c WitP Staff - 9/9/2009 4:32:06 AM   
awadley

 

Posts: 153
Joined: 9/1/2004
From: Wichita, KS
Status: offline
I have the same problem.  thanks found the answer


< Message edited by awadley -- 9/9/2009 5:17:40 AM >


_____________________________



Gunner USMCR

(in reply to herwin)
Post #: 9
RE: v1083c WitP Staff - 9/9/2009 4:33:14 AM   
awadley

 

Posts: 153
Joined: 9/1/2004
From: Wichita, KS
Status: offline
fixed.

< Message edited by awadley -- 9/9/2009 5:18:02 AM >


_____________________________



Gunner USMCR

(in reply to awadley)
Post #: 10
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> War in the Pacific: Admiral's Edition >> Tech Support >> v1083c WitP Staff Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.206