SQL Project using Starcraft to create simple database

Here I created a simple database based on the Protoss faction from the PC game Starcraft. Although, the lay out may not be perfect, I believe it works and is functional

create table resource_harvest
(
  id int,
  structure1_name varchar(255)primary key'null',
  structure1_purpose1 varchar(255)'null',
  structure1_purpose2 varchar(255)'null',
  structure1_purpose3 varchar(255)'null',
  structure1_purpose4 varchar(255)'null',   
  structure1_psi_supplied int   
  structure1_ability varchar(255) 'null',
  structure2_name varchar(255),
  structure2_purpose varchar(255)
  structure_cost_min int,   
);

insert into resource_harvest 
values (1, 'Nexus', 'Collects Resources', 'Warp_in workers', 'produce psi', 'Warp_in Mothership', 10 ,'Chrono_boost', 400);
values (2, 'null', 'null', 'null', 'null', 'null','null', 'null' , 'Assimilator', 'refines Vaspene gas', 75);

create table base_b_u
(
  id int
  structure1_name varchar(255) foreign key, 
  worker_name varchar(50) primary key,
  worker_cost_min int,
  worker_purpose1 varchar(255),
    worker_purpose2 varchar(255),

  worker_purpose3 varchar(255)  
);

insert into base_b_u 
values (1, 'Nexus', 'Probe', 50, 'harvest minerals','harvest gas', 'Warp in Structures');

create table essential_structure
(
  id int,
  E_structure_name varchar(50) Primary key,
  E_structure_name_cost_min int,    
  E_structure_purpose varchar(255),
  E_structure_purpose2 varchar(255)
  E_structure_amount_psi_supplied   int,
  worker_name varchar(50) foreign key
)

insert into essential_structure
values (1, 'Pylon', 100,'Project_psionic_matrix', 'null','null', 'probe')
values (2, 'null', 'null', 'null','provide_psi', 9, 'probe'); 

create table G_structure_build
(
  id int,
  worker_name varchar(50)foreign key,
  E_structure_name varchar(50) foreign key,--pylon for energy field to build
  structurename_G varchar(255) primary key,
  structurename_G_purpose varchar(255),
  structure_cost_min int
);

insert into G_structure_build
values (1, 'Probe', 'pylon','Gateway', 'warp in troops', 150); 

create table G_troops
(id int primary key,
  E_structure_name varchar(50) foreign key, -- pylon for psi/supply increase limit on unit build
  structurename_G varchar(255) foreign key,
  troop_unitname varchar(255),
  unit_cost_M int,
  unit_cost_G int,
  unit_supply varchar(255),
  unit_armor_type varchar(255),
  unit_shields int,
  unit_shields_reg/sec int,
  unit_type varchar(255),
  unit_energy_max int 'null',
  unit_armament varchar(255),
  unit_targets_a varchar(255),
  unit_targets_b varchar(255),
  unit_role varchar(255),
  unit_damage int,
  unit_extradamage_antiarmor varchar(20),
  unit_structure_requirement varchar(255) ,
  unit_structure_requirement_name varchar(255) 'null',
  unit_structure_requirement_name2 varchar(255) 'null' 
);

insert into G_troops
values (1,'pylon', 'Gateway', 'Zealot', 100, 0, '2_psi', 'Light', 50, 2, 'Biological', 'null', 'Psi_blades', 'Ground', 'no_antiair', 'No', 'Power_Melee_warrior', 8, 'no_extra', 'No', 'Null','Null');

create table G_research_structure

(
  id int,
  E_structure_name varchar(50) foreign key,--pylon for psionic matrix to warp in structure
  --structurename_G varchar(255) foreign key,   
  structurename_F varchar(255) primary key,
  structurename_F_GW_upgrades varchar(255),
  structurename_F_GArm_upgrades varchar(255),
  structurename_F_GroundandAir_Shield_upgrades varchar(255),    
  --structurename_Function varchar(255)
);

insert into G_research_structure
values (1, 'Gateway', 'Forge', 'plus_1 to damage', 'plus_1 to armor', 'plus_1 to shields', 'access defensive structure' ); 
values (2, 'null', 'null', 'plus_2 to damage', 'plus_2 to armor', 'plus_2 to shields', 'null' ); 
values (3, 'null', 'null', 'plus_3 to damage', 'plus_3 to armor', 'plus_3 to shields', 'null' ); 

------------

create table defense_structure
(
  id int,
    E_structure_name varchar(50) foreign key, 
  structurename_F varchar(255) foreign key,
  --structurename_G varchar(255)foreign key,
    structure_nameP_C varchar(255) primary key,

  worker_name varchar(50)foreign key
);

insert into defense_structure
values (1,'pylon','Gateway','Forge','photon_cannon', 'probe'); 

------------

create table req_CCstructure

(
  id int,
  E_structure_name varchar(50) foreign key, -- pylon energy field to warp in structure
  structurename_G varchar(255)foreign key,
  structurename_C varchar(255) primary key,
  structurename_C_GGunitaccess varchar(255),
  structure_C_Research_Air_W_upgrades varchar(255),
  structure_C_Research_Air_Armor_upgrades varchar(255),
  structure_C_Reseach_Struct_G_ability varchar (255),
  structure_C_structural_requirement_for_additional_upgrades varchar (255)'null',
  worker_name varchar(50)foreign key
);

insert into req_CCstructure
values (1, 'pylon','Gateway', 'Cybernetics_core', 'produce new gw_units','plus_1 to air weapons', 'plus_1 to air armor','Warpgate','null','probe' ); 
values (2, 'null', 'null', 'null','null', 'plus_2 to damage', 'plus_2 to armor', 'null','Fleetbeacon','null' ); 
values (3, 'null', 'null', 'null','null', 'plus_3 to damage', 'plus_3 to armor', 'null','Fleetbeacon','null'); 

create table G_troops_after_Cyb_C
(id int primary,
  E_structure_name varchar(50) foreign key,-- pylon need to increase supply/larger army
  structurename_G varchar(255) foreign key,
  structurename_C varchar(255)foreign key,
  g_unitname varchar(255),
  unit_cost_M int,
  unit_cost_G int,
  unit_supply varchar(255),
  unit_armor_type varchar(255),
  unit_shields int,
  unit_shields_reg/sec int,
  unit_type varchar(255),
  unit_energy_max int null,
  unit_armament varchar(255),
  unit_targets_a varchar(255),
  unit_targets_b varchar(255),
  unit_role varchar(255),
  unit_damage int,
  unit_additionaldamage_vs_lightarmor varchar(20),
  unit_additionaldamage_vs_heavyarmor varchar(20),
  unit_structure_requirement varchar(255), 
  unit_structure_requirement_name varchar(255) null,
  unit_structure_requirement_name2 varchar(255) null 
);

insert into G_troops_after_Cyb_C
values (1, 'pylon', 'Gateway',  'Cybernetics_core','Stalker', 125, 50, '2_psi', 'Armored', 80, 2, 'Mechanical', 'null', 'Particle_disruptors', 'yes', 'yes','Range_Support_Strider', 13, 'no additonal','additional_5_damage', 'Yes', 'Cybernetics_core', 'negative');
values (2, 'Gateway', 'Cybernetics_core' ,'Adept', 100, 25, '2_psi', 'Light', 70, 'null', 'psionic', 0, 'Glaive cannon', 'yes', 'yes', 'Harassment', 10, 'additional 12damage','no_extra', 'Yes', 'Cybernetics_core', 'negative');
values (3, 'Gateway', 'Cybernetics_core' ,'Sentry', 50, 100, '2_psi', 'Light', 40, 2, 'Psionic', 200, 'Disruption_beam', 'yes', 'yes', 'energy_manipulation', 6, 'no additional','no_extra', 'Yes', 'Cybernetics_core', 'negative');


---------------

 create table shield_battery
(
  
  id int,
  E_structure_name varchar(50) foreign key, -- pylon essential, if surrounding pylon destroyed cannons become inactive
  structurename_C varchar(255)foreign key,
  structurename_G varchar(255) foreign key,
  structure_nameS_B varchar(255)primary key,
  structure_nameS_B_minerals int
  structure_nameS_B_gas int
  structure_purpose varchar(50)
  structure_nameS_B_energy int
  worker_name varchar(50)foreign key
);

insert into shield_battery
values (1,'pylon','Gateway', 'Cybernetics_core','shield_battery', 100, 0, 'recharge shields',100, 'probe'); 

 create table advance_structures_G_unit_research
(
  id int primary key,
  E_structure_name varchar(50) foreign key,--pylon for energy field
  Adv_structurename varchar(255),
  structurename_G varchar(255) foreign key 'null',
  structurename_C varchar(255)foreign key 'null',
  --Adv_structure_requirement varchar(255) foreign key 'null',
  Adv_structure_cost_min int 'null',
  Adv_structure_cost_Vespine_gas int 'null',
  Adv_structure_purpose varchar(255) 'null',    
  Adv_structure_research1 varchar(255) ,
  Adv_structure_research1_unitaffected varchar(255) ,   
  Adv_structure_research2 varchar(255),
  Adv_structure_research2_unitaffected varchar(255),
  worker_name varchar(50)foreign key 'null'
);

insert into advance_structures_G_unit_research
values (1, 'pylon ','Twilight_Council', 'Gateway', 'Cybernetics_Core', 150, 150, 'research_new_abilities', 'Charge_ability','Zealot', 'null', 'null','probe');
values (2,'null', 'Twilight_Council', 'Gateway', 'Cybernetics_Core', 150, 150, 'research_new_abilities', 'Blink_ability','Stalker', 'null', 'null','null');

create table G_units_advance_structures
(
  id int primary key,
  --structurename_G varchar(255) foreign key 'null', gateway not quite essential unless (advance structure destroyed, cybernetics core destroyed, awa gateway destroyed ) as cybernetics core in order to be rebuilt will require a new gateway 
  structurename_C varchar(255)foreign key 'null',   
  E_structure_name varchar(50) foreign key, --new or existing pylon energy field to build
  Adv_structurename varchar(255)foreign key 'null',
  
  Advstructurename2_ varchar(255)foreign key 'null',
  Adv_structure2_cost_min int 'null',
  Adv_structure2_cost_Vespine_gas int 'null',
  Advstructure2_purpose varchar(255) 'null',
  Advstructure2_reseach_ability varchar(255) 'null',
  Advstructure2_research_ability varchar(255) 'null',
  Advstructurename3_ varchar(255)   'null',
  Adv_structure3_cost_min int 'null',
  Adv_structure3_cost_Vespine_gas int 'null',   
  Advstructurename3_purpose varchar(255) 'null',
  worker_name varchar(50)foreign key
  --structurename_C_grantaccesstoadvancetech varchar(255),
);

insert into  G_units_advance_structures
values (1, 'pylon', 'Cybernetics_Core', 'Twilight_Council', 'Templar_Archives', 150,200,'enable production of High_templar', 
values(2, 'null','null','null', 'null','null','null','null','Psionic_storm', 'Khaydarin Amulet_increases_starting_energy','null','null','null','null', 'null');

values (3, 'null','null', 'null', 'null', 'null','null','null', 'null','null','Dark_Shrine' ,150, 250, 'enable production of Dark_templar','null');

create table G_troops_beyondCyb_C
(id int primary key,
  E_structure_name varchar(50) foreign key, 
  structurename_G varchar(255) foreign key,
  structurename_C varchar(255)foreign key,
  Adv_structurename varchar(255)foreign key 'null',
  Advstructurename2 varchar(255)foreign key 'null',
  Advstructurename3 varchar(255)     foreign key,
  g_unitname varchar(255),
  unit_cost_Min int,
  unit_cost_vespine_Gas int,
  unit_supply varchar(255),
  unit_armor_type varchar(255),
  unit_shields int,
  unit_shields_reg/sec int,
  unit_type varchar(255),
  unit_energy_max int null,
  unit_armament varchar(255),
  unit_targets_ground varchar(255),
  unit_targets_air varchar(255),
  unit_role varchar(255),
  unit_ability1 varchar(255),
  unit_ability2 varchar(255),
  unit_ability3 varchar(255),
  
  unit_damage int,
  unit_additionaldamage_vs_biological varchar(20), 
  unit_additionaldamage_vs_lightarmor varchar(20),
  unit_additionaldamage_vs_heavyarmor varchar(20));

insert into G_troops_beyondCyb_C
values (1, 'pylon','Gateway', 'Cybernetics_Core', 'Twilight_Council' ,  'Templar_Archives', 'null','High_Templar', 50, 150, '2_psi', 'Light', 40, 2, 'Psionic', 200, 'psi_blast', 'yes', 'no', 'Potent_psionic_master', 'Feedback','Psionic storm','Archon merge',4, 'No_extra', 'No_extra', 'Yes'); 

values (2, 'pylon','Gateway', 'Cybernetics_Core', 'Twilight_Council' , 'Templar_Archives', 'Dark_Shrine', 'Dark_Templar', 125, 125, '2_psi', 'Light', 80, 2, 'Psionic', 200, 'Warp_Blade', 'yes', 'no', 'Stealth_Harassment_Warrior', 'null','null','Archon merge',45, 'No_extra', 'Yes');

create table Massive_unit
(
  id int primary key,
    structurename_G varchar(255) foreign key,
  structurename_C varchar(255)foreign key,
  Adv_structurename varchar(255)foreign key 'null',
  Advstructurename2 varchar(255)foreign key 'null',
  Advstructurename3 varchar(255)     foreign key,
  M_unit_name varchar (100),
  unit_supply varchar(255)'null',
  unit_origin varchar(255) 'null',
  unit_shields int 'null',
  unit_shields_reg/sec int 'null',
  unit_type varchar(255) 'null',
  unit_type2 varchar(255)'null',
  unit_armament varchar(255)'null',
  unit_targets_ground varchar(255)'null',
  unit_targets_air varchar(255)'null',
  unit_role varchar(255)'null',
  unit_damage int 'null',
  unit_additionaldamage_vs_biological varchar(20) 'null',
  g_unitname varchar(255) foreign key 'null'
);

insert into massive_unit
values (1, 'pylon','Gateway', 'Cyberneticscore','Twilight_Council' , 'Templar_Archives', 'Dark_Shrine','Archon', '4_psi', 'merging of 2 high_or_dark_templar', 350, 2, 'Massive','Psionic', 'null', 'Psionic shockwave', 'yes', 'yes','Powerful_psionic_attacker', 25, '+10', 'Yes');

create table advance_structure_Mech
(id int ,
  E_structure_name varchar(50) foreign key, 
  --structurename_G varchar(255) foreign key 'null',
  structurename_C varchar(255)foreign key 'null',
  --Adv_structurename varchar(255)foreign key 'null',
  M_Advstructurename_ varchar(255)primary key 'null',
  M_Adv_structure_cost_min int 'null',
  M_Adv_structure_cost_Vespine_gas int 'null',
  M_Advstructure_purpose varchar(255) 'null',
  --M_Advstructure_purpose2 varchar(255)
  --Advstructurename1_reseach_ability varchar(255) 'null',
  --Advstructurename1_research_ability varchar(255) 'null',
  --Advstructurename2_ varchar(255) 'null',
  --Adv_structure2_cost_min int 'null',
  --Adv_structure2_cost_Vespine_gas int 'null', 
  --Advstructurename2_purpose varchar(255) 'null',
  worker_name varchar(50)foreign key
);

insert into advance_structure_Mech
values (1, 'Pylon', 'Cybernetics_Core', 'Robotics_Facility', 200,100, 'produce mechanical units', 'probe');

create table adv_mech_units
(id int primary key,
  E_structure_name varchar(50) foreign key, 
  structurename_C varchar(255)foreign key,
  M_Adv_structurename varchar(255)foreign key 'null',
  -- Advstructurename2 varchar(255)foreign key 'null',
  -- Advstructurename3 varchar(255)  foreign key,
  M_unitname varchar(255),
  M_unit_production_structural_req. varchar(255),
  M_unit_nonoffense_purpose varchar (255),
  M_unit_ability varchar (255),
  M_unit_cost_Min int,
  M_unit_cost_vespine_Gas int,
  M_unit_build_time varchar(255),
  M_unit_supply varchar(255),
  
  M_unit_armor_type varchar(255),
  
  M_unit_shields int,
  M_unit_shields_reg/sec int,
  M_unit_type varchar(255),
  M_unit_energy_max varchar(250) null,
  M_unit_armament varchar(255),
  M_unit_targets_ground varchar(255),
  M_unit_targets_air varchar(255),
  M_unit_role varchar(255),
  M_unit_damage int,
  M_unit_additionaldamage_vs_biological varchar(20), 
  M_unit_additionaldamage_vs_lightarmor varchar(20),
  M_unit_additionaldamage_vs_heavyarmor varchar(20)
);

insert into adv_mech_units

values (1, 'pylon','robotics_facility','Warp_prism', 'transport troops', 'no','phase mode', 250, 0,'36_seconds' ,2,'armored',100,2,'psionic', 'noenergy', 
        'unarmed','none','none','flying_transport',0, 'none','none','none');

values (2, 'pylon','robotics_facility','Observer', 'detect_CloakedorBurrowed_enemies','no', 'surveilence_mode'
        ,25,75,'18_seconds',1,'light',20,2,'mechanical', 'noenergy', 'unarmed','none',
        'none','flying_spy',0,'none','none','none');

values (3, 'pylon','robotics_facility','immortal','none', 'none','no',
        275,100,'39_seconds',4,'armored',100,2,'mechanical', 'no','phase_disruptors','yes','no','robotic assault strider',10, 'none','+5','none');

create table adv_structure_mechresearch

(
  id int primary key,
  E_structure_name varchar(50) foreign key,--pylon for energy field
  structurename_C varchar(255)foreign key 'null',
  M_Adv_structurename varchar(255)foreign key 'null',
  M_R_Adv_structurename varchar(255),
  --Adv_structure_requirement varchar(255) foreign key 'null',
  M_R_Adv_structure_cost_min int 'null',
  M_R_Adv_structure_cost_Vespine_gas int 'null',
  M_R_Adv_structure_purpose varchar(255) 'null',
  M_R_Adv_structure_purpose2 varchar(255)   
  M_R_Adv_structure_research1 varchar(255) ,
  M_R_Adv_structure_research1_unitaffected varchar(255) ,   
  M_R_Adv_structure_research2 varchar(255),
  M_R_Adv_structure_research2_unitaffected varchar(255),
  M_R_Adv_structure_research3 varchar(255),
  M_R_Adv_structure_research3_unitaffected varchar(255),
  worker_name varchar(50)foreign key 'null'
);

insert into adv_structure_mechresearch
values 
(1, 'Pylon','Cybernetics_core','Robotics_Facility', 'Robotics_bay',200,200,'unlock_Colossus','research_tech_upgrades','gravitic_booster','Observer');
values (2, 'null','null','null', 'null','null','null','null','research_tech_upgrades','Gravitic_drive','Warp_prism');
values (3, 'null','null','null', 'null','null','null','null','research_tech_upgrades','Extend_Thermal_Lances','Colossus','probe');

create table adv_mech_units_after_Mresearch
(id int primary key,
  E_structure_name varchar(50) foreign key, 
  --structurename_C varchar(255)foreign key,
  M_Adv_structurename varchar(255)foreign key 'null',
  M_R_Adv_structurename varchar(255)foreign key,
  -- Advstructurename2 varchar(255)foreign key 'null',
  -- Advstructurename3 varchar(255)  foreign key,
  M_adv_unitname varchar(255),
  M_adv_unit_nonoffense_purpose varchar (255),
  M_adv_unit_ability varchar (255),
  M_adv_unit_cost_Min int,
  M_adv_unit_cost_vespine_Gas int,
  M_adv_unit_build_time varchar(255),
  M_adv_unit_supply varchar(255),
  M_adv_unit_armor_type varchar(255),
  M_adv_unit_shields int,
  M_adv_unit_shields_reg/sec int,
  M_adv_unit_type varchar(255),
  M_adv_unit_energy_max varchar(250) null,
  M_adv_unit_armament varchar(255),
  M_adv_unit_targets_ground varchar(255),
  M_adv_unit_targets_air varchar(255),
  M_adv_unit_role varchar(255),
  M_adv_unit_damage int,
  M_adv_unit_additionaldamage_vs_biological varchar(20), 
  M_adv_unit_additionaldamage_vs_lightarmor varchar(20),
  M_adv_unit_additionaldamage_vs_heavyarmor varchar(20)
);

insert into adv_mech_units_after_Mresearch
values (1, 'pylon','robotics_facility', 'robotics_bay','Colossus','none','No'
        300,200,'54_seconds',6,'armored',150,2,'massive',
        'no','Thermal_lance','yes','no','robotic Siege strider',10,'none','+5','none'); 
values (2, 'pylon','robotics_facility', 'robotics_bay','Disruptor','none','Yes'
        150,150,'36_seconds',4,'armored',100,2,'light',
        'no','Nova','yes','no','energy_castor',145,'none','none','none'); 

create table advance_structure_Mech_air
(id int ,
  E_structure_name varchar(50) foreign key, --psionic matrix
  --structurename_G varchar(255) foreign key 'null',
  structurename_C varchar(255)foreign key 'null',
  --Adv_structurename varchar(255)foreign key 'null',
  M_Air_Advstructurename_ varchar(255)primary key 'null',
  M_Air_Adv_structure_cost_min int 'null',
  M_Air_Adv_structure_cost_Vespine_gas int 'null',
  M_Air_Advstructure_purpose varchar(255) 'null',
  --M_Advstructure_purpose2 varchar(255)
  --Advstructurename1_reseach_ability varchar(255) 'null',
  --Advstructurename1_research_ability varchar(255) 'null',
  --Advstructurename2_ varchar(255) 'null',
  --Adv_structure2_cost_min int 'null',
  --Adv_structure2_cost_Vespine_gas int 'null', 
  --Advstructurename2_purpose varchar(255) 'null',
  worker_name varchar(50)foreign key
);

insert into advance_structure_Mech_air
values (1, 'Pylon', 'Cybernetics_Core', 'Stargate', 150,150, 'produce mechanical air_units', 'probe');

create table adv_mech_air_units
(id int primary key,
  E_structure_name varchar(50) foreign key, --pylon for supply
  structurename_C varchar(255)foreign key,
  M_Air_Advstructurename_ varchar(255)foreign key 'null',
  -- Advstructurename2 varchar(255)foreign key 'null',
  -- Advstructurename3 varchar(255)  foreign key,
  M_Air_unitname varchar(255),
  M_Air_unit_production_structural_req. varchar(255),
  M_Air_unit_nonoffense_purpose varchar (255),
  M_Air_unit_ability varchar (255) 'null',
  M_Air_unit_ability2 varchar (255) 'null',
  
  M_Air_unit_ability_purpose varchar (255) 'null',
  M_Air_unit_ability_purpose2 varchar (255) 'null',
  M_Air_unit_ability_purpose3 varchar (255) 'null',
  
  
  M_Air_unit_ability_requirement varchar (255) 'null',
  M_Air_unit_cost_Min int,
  M_Air_unit_cost_vespine_Gas int,
  M_Air_unit_warp_in_time varchar(255),
  M_Air_unit_supply varchar(255),
  M_Air_unit_armor_type varchar(255),
  
  M_Air_unit_shields int,
  M_Air_unit_armor int,
  M_Air_unit_speed int,
  M_Air_unit_energy_cooldown int,
  M_Air_unit_type varchar(255),
  M_Air_unit_energy_max varchar(250) null,
  M_Air_unit_armament varchar(255),
  M_Air_unit_targets_ground varchar(255),
  M_Air_unit_targets_air varchar(255),
  M_Air_unit_role varchar(255),
  M_Air_unit_damage int,
  M_Air_unit_damage_per_sec int,
  M_Air_unit_additionaldamage_vs_biological_air_or_ground varchar(20), 
  M_Air_unit_additionaldamage_vs_lightarmor_air_or_ground varchar(20),
  M_Air_unit_additionaldamage_vs_heavyarmor_air_or_ground varchar(20)
);

insert into adv_mech_air_units

values (1, 'pylon','cybernetics_core','Stargate','Pheonix', 'no', 'no'
        'Graviton_beam','Anion_Pulse-Crystals','lifts light ground units into air','increase range of weapons by 2','null',
        'research require Fleet Beacon',
        150,100,'25_seconds',2,'Air Unit',60,120,5.95,.79,'Mechanical_Air', 'no', 
        'ion cannon','no','yes','airtoair',12.7,'none','plus_5_lightly_armored_air','none');


values (2, 'pylon','cybernetics_core','Stargate','Void Ray', 'no', 'no','Prismatic Alignment',
        'Flux Vanes','boost damage ouput to armored units', 'increase_movement_speed', 'null', 
        'fleet beacon',
        ,250,150,43,4,'Large Air Unit',100,150,3.85,42.9,'Mechanical_air', 'no', 'armed','none',
        'prismatic beam','yes','yes','surgical strike',6, 16.8, 'none','none','plus_4');

create table adv_air_structure_mechresearch

(
  id int primary key,
  E_structure_name varchar(50) foreign key,--pylon for energy field
  structurename_C varchar(255)foreign key 'null',
  M_Air_Advstructurename_ varchar(255)foreign key 'null',
  M_air_R_Adv_structurename varchar(255),
  --Adv_structure_requirement varchar(255) foreign key 'null',
  M_air_R_Adv_structure_cost_min int 'null',
  M_air_R_Adv_structure_cost_Vespine_gas int 'null',
  M_air_R_Adv_structure_purpose varchar(255) 'null',
  M_air_R_Adv_structure_purpose2 varchar(255) ,
  M_air_R_Adv_structure_purpose3 varchar(255), 
  M_air_R_Adv_structure_research1 varchar(255) ,
  M_air_R_Adv_structure_research1_cost_minerals int ,
  M_air_R_Adv_structure_research1_cost_gas int ,
  M_air_R_Adv_structure_research1_time varchar(255) ,
  
  M_air_R_Adv_structure_research1_unitaffected varchar(255) ,   
  M_air_R_Adv_structure_research2 varchar(255),
  M_air_R_Adv_structure_research2_cost_minerals int ,
  M_air_R_Adv_structure_research2_cost_gas int ,
  M_air_R_Adv_structure_research2_time varchar(255) ,
  M_air_R_Adv_structure_research2_unitaffected varchar(255),
  M_air_R_Adv_structure_research3 varchar(255),
  M_air_R_Adv_structure_research3_cost_minerals int ,
  M_air_R_Adv_structure_research3_cost_gas int ,
  M_air_R_Adv_structure_research3_time varchar(255) ,
  M_air_R_Adv_structure_research3_unitaffected varchar(255),
  worker_name varchar(50)foreign key 'null'
);

insert into adv_structure_mechresearch
values 
(1, 'Pylon','Cybernetics_core','Stargate', 'Fleet Beacon',300,200,'unlock_Carrier','unlock_Tempest','unlock_Mothership','research_Anion Pulse-Crystals',150, 150, '64_seconds',  'Pheonix');
(2,  'null',       'null',     'null',      'null',     'null','null','null', 'research Flux Vanes', 100,100, '57_seconds',
 'Void Ray',);
(3,  'null',       'null',     'null',      'null',     'null','null','null', 'research Techtonic Destabilizers',150, 150,'100_seconds','Tempest','probe');

create table adv_mech_air_Capital_ships
(id int primary key,
  E_structure_name varchar(50) foreign key, --pylon for supply
  structurename_C varchar(255)foreign key,
  M_Air_Advstructurename_ varchar(255)foreign key 'null',
  Advstructurename2 varchar(255)foreign key 'null',
  Advstructurename3 varchar(255)     foreign key,
  M_Air_unitname varchar(255),
  M_Air_unit_production_structural_req. varchar(255),
  M_Air_unit_nonoffense_purpose varchar (255),
  M_Air_unit_ability varchar (255) 'null',
  M_Air_unit_ability2 varchar (255) 'null',
  
  M_Air_unit_ability_purpose varchar (255) 'null',
  M_Air_unit_ability_purpose2 varchar (255) 'null',
  M_Air_unit_ability_purpose3 varchar (255) 'null',
  
  
  M_Air_unit_ability_requirement varchar (255) 'null',
  M_Air_unit_cost_Min int,
  M_Air_unit_cost_vespine_Gas int,
  M_Air_unit_warp_in_time varchar(255),
  M_Air_unit_supply varchar(255),
  M_Air_unit_armor_type varchar(255),
  
  M_Air_unit_shields int,
  M_Air_unit_armor int,
  M_Air_unit_speed int,
  M_Air_unit_energy_cooldown int,
  M_Air_unit_type varchar(255),
  M_Air_unit_energy_max varchar(250) null,
  M_Air_unit_armament varchar(255),
  M_Air_unit_targets_ground varchar(255),
  M_Air_unit_targets_air varchar(255),
  M_Air_unit_role varchar(255),
  M_Air_unit_damage int,
  M_Air_unit_damage_per_sec int,
  M_Air_unit_additionaldamage_vs_biological_air_or_ground varchar(20), 
  M_Air_unit_additionaldamage_vs_lightarmor_air_or_ground varchar(20),
  M_Air_unit_additionaldamage_vs_heavyarmor_air_or_ground varchar(20)
);

insert into adv_mech_air_Capital_ships

values (1, 'pylon','cybernetics_core','Stargate','fleet beacon', 'Carrier', 'no', 'no'
        'null','null','null','null','null',
        'null',
        150,100,'25_seconds',2,'Air Unit',60,120,5.95,.79,'Mechanical_Air', 'no', 
        'interceptors','yes','yes','capitalship',12.7,'none','plus_5_lightly_armored_air','none');


values (2, 'pylon','cybernetics_core','Stargate','fleet beacon','Tempest', 'no', 'no','no',
        'Techtonic Destabilizers','null', 'null', 'null', 
        ,250,175,43,5,'capitalship',100,150,3.85,42.9,'Mechanical_air', 'no', 'armed','none',
        ' ','yes','no','siege',40 , 16.97 , 'none','none','plus_4');