table 'Game' copy table 'Race' copy 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 'Commander' 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 add 'Visible' 0 table 'FleetMove' copy table 'ShipDesign' replace preselect 'select ShipClassID, ClassName, DesignTypeID, ControlSheet, AtmosphereCapable, AdvMan, XORacks, XOGRacks, RaceID from ShipClass order by ShipClassID' add 'ShipDesignID' #1 add 'Name' #2 add 'DesignTypeID' #3 add 'HullTypeID' evaluate( 'select HullTypeID from ShipClass left join HullType on ShipClass.HullType = HullType.HullTypeDesc order by ShipClass.ShipClassID' ) add 'ControlSheet' #4 add 'AtmosCap' if #5 > 0 then 1 else 0 endif add 'AdvMan' if #6 = 1 then 1 else 0 endif add 'AdvMan2' if #6 = 2 then 1 else 0 endif add 'EngTune' 0 add 'XORacks' #7 add 'XOGRacks' #8 add 'RaceID' #9 table 'ShipClass' copy order by 'ShipClassID' preselect 'select AdvMan, AtmosphereCapable, XORacks, XOGRacks, HullSpaces, TL, Cost, MaintenanceCost, TurnMode, ControlSheet, ShipClassID, ClassName, Speed from ShipClass order by ShipClassID' let $hullmod = (if #2 != 0 then '(AC) ' else '' endif) | (if #1 = 1 then 'AM ' else '' endif) | (if #1 = 2 then 'AM2' else '' endif) let $racks = (if #3 > 0 then #3 | ' XORacks ' else '' endif) | (if #4 > 0 then #4 | ' XOGRacks' else '' endif) let $spacestl = #5 | ' Hull TL ' | #6 let $cost = 'Cost = ' | #7 | '/' | #8 delete 'AdvMan' delete 'ControlSheet' add 'ControlSheetA' '\t' | $hullmod | '\t' | $racks | '\t' | $spacestl add 'ControlSheetB' '\tCrew ??\tTrg:?\t' | $cost add 'CostMaint' $cost add 'Crew' 'Crew:' add 'DesignCode' '[' | #9 | '] ' | #10 | ' [' | #13 | ']' add 'DesignID' #11 add 'FireMods' 'Mods:' delete 'HTK' add 'HullMods' $hullmod add 'Loadout' '' add 'NameAndType' #12 | ' class' delete 'Picture' add 'Racks' $racks add 'SpacesTL' $spacestl // add 'TotalNumber' evaluate( 'select count(Ship.ShipID) // from ShipClass left join Ship on ShipClass.ShipClassID = Ship.ShipClassID // group by ShipClass.ShipClassID order by ShipClass.ShipClassID' ) add 'WeaponList' 'Weapons:' delete 'XORacks' delete 'XOGRacks' table 'GovtPool' copy table 'GovType' copy order by 'GovTypeID' add 'Trade' compound( 0, 0, -5, 0, 0, 5, -15, -10, 10, 5, 0, -5, 0, -10, -25, -20, 10, 5, 0, -5, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, -15, 0, 0 ) add 'Military' compound( 0, 0, 10, 0, 0, -5, -10, -5, -20, -10, 0, 10, -10, 10, 0, 0, 0, 0, -5, 0, 0, 0, 0, 30, 20, 0, 0, 0, 0, 0, -10, 0, 0 ) add 'Partnership' compound( 0, -10, -10, -10, 0, 0, -10, -5, 0, 5, 15, 5, 0, 5, -10, -15, 10, 5, 0, 5, 0, 5, 0, 40, 40, 0, 0, 0, 0, 0, -10, 0, 0 ) add 'Amalgamate' compound( 0, -20, -10, -20, 0, 0, 10, 10, 0, 10, 20, 15, 10, 10, 0, -5, 10, 15, 5, 15, 0, 5, 0, 50, 50, 10, 0, 0, 0, 0, -25, 10, 10 ) 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 'PoliticalState' ignore table 'PopulationLevel' ignore table 'PopulationSize' ignore table 'Progress' ignore table 'RaceClassName' copy table 'RacePCF' copy table 'RaceSysSurvey' copy table 'RaceSystemName' copy table 'RaceTech' copy table 'WarpPoint' copy table 'RaceWPSurvey' copy add 'Hide' 0 table 'ReadinessState' ignore table 'RefitCost' ignore // should be copy in next version table 'Relationship' copy table 'ReportClass' ignore // should be copy in next version table 'ReportTurn' ignore // should be copy in next version table 'Ship' copy order by 'ShipID' preselect 'SELECT ShipClass.ControlSheet, ShipClass.TurnMode, ShipClass.Speed FROM Ship, ShipClass WHERE Ship.ShipClassID = ShipClass.ShipClassID ORDER BY Ship.ShipID' let $shipSheet = evaluate( 'SELECT CurrentControl from Ship order by ShipID' ) let $designCode = '[' | #2 | '] ' | #1 | ' [' | #3 | ']' delete 'CurrentControl' add 'CurrentControl' if $shipSheet = #1 then $designCode else $shipSheet endif table 'ShipComponent' clear table 'ShipSC' copy table 'Shipyards' copy table 'ShipyardTask' copy table 'SystemItem' copy table 'SystemNotes' copy table 'TaskType' ignore table 'TechResearchType' ignore table 'TechSystem' 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 'WindowPosition' copy