table 'Game' copy table 'Race' copy order by 'RaceID' preselect 'select ResearchStatus from Race order by RaceID' add 'MinSystem' 0 add 'MaxSystem' 0 add 'NewStartupMod' if #1 = 2 then 1 else 0 endif add 'StartupModPaid' if #1 = 2 then 1 else 0 endif table 'AdminCommand' copy table 'App' copy table 'BinaryDistances' ignore table 'BuildRates' ignore table 'CFNCost' ignore table 'CFNTasks' copy table 'Civilization' copy table 'Ranks' copy table 'CommanderList' copy table 'Commander' copy table 'CommanderRace' copy table 'CommunicationState' ignore table 'ConHistory' copy table 'CrewGrade' ignore table 'CrewGradeAdvance' ignore table 'DesignType' ignore table 'DSBPosition' copy table 'EconomicLevel' ignore table 'EconomicTurns' copy table 'ELResearchType' ignore table 'EnvValue' ignore table 'Expendables' ignore table 'SystemType' copy table 'System' copy table 'Fleet' copy table 'FleetMove' copy table 'ShipDesign' copy table 'ShipClass' copy table 'GovtPool' copy table 'GovType' copy order by 'GovTypeID' preselect 'select GovTypeID from GovType order by GovTypeID' add 'ConstMod' if #1 = 28 then 2 else 1 endif add 'ResearchCost' if #1 = 27 then 3 else if #1 = 28 then '1.5' else 1 endif endif table 'GradeAdvancement' ignore table 'HighTech' ignore table 'HistoricalData' copy table 'HullType' ignore table 'Inhabited' ignore table 'JRillRaces' copy table 'MinContent' ignore table 'MissileMods' ignore table 'StarType' copy table 'Star' copy table 'Planet' copy table 'Moon' copy table 'MoonChance' ignore table 'MoonName' copy table 'MoveImpulses' ignore table 'Notes' ignore table 'NPR1' ignore table 'NPR10' ignore table 'NPR11' ignore table 'NPR12' ignore table 'NPR21' ignore table 'NPR22' ignore table 'NPR3' ignore table 'NPR4' ignore table 'NPR51' ignore table 'NPR52' ignore table 'NPR53' ignore table 'NPR61' ignore table 'NPR62' ignore table 'NPR71' ignore table 'NPR72' ignore table 'NPR73' ignore table 'NPR74' ignore table 'NPR75' ignore table 'NPR76' ignore table 'NPR8' ignore table 'NPR9' ignore table 'NPRExploration' ignore table 'NPRTechlevel' ignore table 'NumOrder' ignore table 'PCF' ignore table 'PlanetDistance' ignore table 'PlanetName' copy table 'PlanetType' ignore table 'PointDefence' ignore table 'PoliticalState' ignore table 'PopulationLevel' ignore table 'PopulationSize' ignore table 'Progress' ignore table 'RaceClassName' copy table 'RacePCF' copy table 'RaceSysSurvey' copy table 'RaceSystemName' copy table 'TechSystem' ignore table 'AvailTech' clear // should be copy in next version table 'RaceTech' copy order by 'RaceTechID' preselect 'select RaceTech.Type, TechSystem.DevelopCost, TechSystem.DevelopCost * 3, TechSystem.DevelopCost * 4, TechSystem.DevelopCost * 6 from RaceTech, TechSystem where RaceTech.TechID = TechSystem.TechSystemID order by RaceTech.RaceTechID' add 'Paid' if #1 = 2 then #3 else if #1 = 3 then #4 else if #1 = 4 then #5 else #2 endif endif endif table 'WarpPoint' copy table 'RaceWPSurvey' copy table 'ReadinessState' ignore table 'RefitCost' copy table 'Relationship' copy add 'InteractionThisMonth' 0 table 'ReportClass' copy table 'ReportTurn' copy table 'Resolver' copy table 'Ship' copy table 'ShipComponent' copy table 'ShipItem' copy table 'ShipSC' copy table 'ShipNameType' ignore table 'ShipNames' ignore table 'ShipNamesUsed' copy table 'Shipyards' copy table 'ShipyardTask' copy table 'SurveyOptions' ignore table 'SystemItem' copy table 'SystemNotes' copy table 'SystemSurvey' copy table 'TaskType' ignore table 'TechResearchType' ignore table 'TechSystemModifiers' copy table 'Theme' ignore table 'ThemeClass' copy table 'ThemeRank' copy table 'ThemeSystem' copy table 'TotalWarpPoints' ignore table 'Trade' copy table 'TurnStatus' ignore table 'WarpPointDistance' ignore table 'WarpPointType' ignore table 'Weapons' ignore table 'WindowPosition' copy