st-universe /
core
| Conditions | 1 |
| Paths | 1 |
| Total Lines | 1639 |
| Code Lines | 1638 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 0 | ||
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 20 | public function up(Schema $schema): void |
||
| 21 | { |
||
| 22 | // this up() migration is auto-generated, please modify it to your needs |
||
| 23 | $this->addSql(<<<'SQL' |
||
| 24 | CREATE TABLE stu_alliance_boards (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, alliance_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, CONSTRAINT FK_5D868E4710A0EA3F FOREIGN KEY (alliance_id) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 25 | SQL); |
||
| 26 | $this->addSql(<<<'SQL' |
||
| 27 | CREATE INDEX alliance_idx ON stu_alliance_boards (alliance_id) |
||
| 28 | SQL); |
||
| 29 | $this->addSql(<<<'SQL' |
||
| 30 | CREATE TABLE stu_alliance_posts (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, topic_id INTEGER NOT NULL, board_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, date INTEGER NOT NULL, text CLOB NOT NULL, user_id INTEGER NOT NULL, lastedit INTEGER DEFAULT NULL, CONSTRAINT FK_31F4A4121F55203D FOREIGN KEY (topic_id) REFERENCES stu_alliance_topics (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_31F4A412E7EC5785 FOREIGN KEY (board_id) REFERENCES stu_alliance_boards (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_31F4A412A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 31 | SQL); |
||
| 32 | $this->addSql(<<<'SQL' |
||
| 33 | CREATE INDEX IDX_31F4A4121F55203D ON stu_alliance_posts (topic_id) |
||
| 34 | SQL); |
||
| 35 | $this->addSql(<<<'SQL' |
||
| 36 | CREATE INDEX IDX_31F4A412E7EC5785 ON stu_alliance_posts (board_id) |
||
| 37 | SQL); |
||
| 38 | $this->addSql(<<<'SQL' |
||
| 39 | CREATE INDEX IDX_31F4A412A76ED395 ON stu_alliance_posts (user_id) |
||
| 40 | SQL); |
||
| 41 | $this->addSql(<<<'SQL' |
||
| 42 | CREATE INDEX topic_date_idx ON stu_alliance_posts (topic_id, date) |
||
| 43 | SQL); |
||
| 44 | $this->addSql(<<<'SQL' |
||
| 45 | CREATE INDEX board_date_idx ON stu_alliance_posts (board_id, date) |
||
| 46 | SQL); |
||
| 47 | $this->addSql(<<<'SQL' |
||
| 48 | CREATE TABLE stu_alliance_settings (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, alliance_id INTEGER NOT NULL, setting VARCHAR(255) NOT NULL, value VARCHAR(255) NOT NULL, CONSTRAINT FK_39FF05F710A0EA3F FOREIGN KEY (alliance_id) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 49 | SQL); |
||
| 50 | $this->addSql(<<<'SQL' |
||
| 51 | CREATE INDEX IDX_39FF05F710A0EA3F ON stu_alliance_settings (alliance_id) |
||
| 52 | SQL); |
||
| 53 | $this->addSql(<<<'SQL' |
||
| 54 | CREATE TABLE stu_alliance_topics (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, board_id INTEGER NOT NULL, alliance_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, last_post_date INTEGER NOT NULL, user_id INTEGER NOT NULL, sticky BOOLEAN NOT NULL, CONSTRAINT FK_3F9E856DE7EC5785 FOREIGN KEY (board_id) REFERENCES stu_alliance_boards (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3F9E856D10A0EA3F FOREIGN KEY (alliance_id) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3F9E856DA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 55 | SQL); |
||
| 56 | $this->addSql(<<<'SQL' |
||
| 57 | CREATE INDEX IDX_3F9E856DE7EC5785 ON stu_alliance_topics (board_id) |
||
| 58 | SQL); |
||
| 59 | $this->addSql(<<<'SQL' |
||
| 60 | CREATE INDEX IDX_3F9E856D10A0EA3F ON stu_alliance_topics (alliance_id) |
||
| 61 | SQL); |
||
| 62 | $this->addSql(<<<'SQL' |
||
| 63 | CREATE INDEX IDX_3F9E856DA76ED395 ON stu_alliance_topics (user_id) |
||
| 64 | SQL); |
||
| 65 | $this->addSql(<<<'SQL' |
||
| 66 | CREATE INDEX recent_topics_idx ON stu_alliance_topics (alliance_id, last_post_date) |
||
| 67 | SQL); |
||
| 68 | $this->addSql(<<<'SQL' |
||
| 69 | CREATE INDEX ordered_topics_idx ON stu_alliance_topics (board_id, last_post_date) |
||
| 70 | SQL); |
||
| 71 | $this->addSql(<<<'SQL' |
||
| 72 | CREATE TABLE stu_alliances (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description CLOB NOT NULL, homepage VARCHAR(255) NOT NULL, date INTEGER NOT NULL, faction_id INTEGER DEFAULT NULL, accept_applications BOOLEAN NOT NULL, avatar VARCHAR(32) NOT NULL, rgb_code VARCHAR(7) NOT NULL, CONSTRAINT FK_A36183F74448F8DA FOREIGN KEY (faction_id) REFERENCES stu_factions (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 73 | SQL); |
||
| 74 | $this->addSql(<<<'SQL' |
||
| 75 | CREATE INDEX IDX_A36183F74448F8DA ON stu_alliances (faction_id) |
||
| 76 | SQL); |
||
| 77 | $this->addSql(<<<'SQL' |
||
| 78 | CREATE TABLE stu_alliances_jobs (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, alliance_id INTEGER NOT NULL, user_id INTEGER NOT NULL, type SMALLINT NOT NULL, CONSTRAINT FK_3C71C67B10A0EA3F FOREIGN KEY (alliance_id) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3C71C67BA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 79 | SQL); |
||
| 80 | $this->addSql(<<<'SQL' |
||
| 81 | CREATE INDEX IDX_3C71C67B10A0EA3F ON stu_alliances_jobs (alliance_id) |
||
| 82 | SQL); |
||
| 83 | $this->addSql(<<<'SQL' |
||
| 84 | CREATE INDEX IDX_3C71C67BA76ED395 ON stu_alliances_jobs (user_id) |
||
| 85 | SQL); |
||
| 86 | $this->addSql(<<<'SQL' |
||
| 87 | CREATE TABLE stu_alliances_relations (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type SMALLINT NOT NULL, alliance_id INTEGER NOT NULL, recipient INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_9EBADCD910A0EA3F FOREIGN KEY (alliance_id) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_9EBADCD96804FB49 FOREIGN KEY (recipient) REFERENCES stu_alliances (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 88 | SQL); |
||
| 89 | $this->addSql(<<<'SQL' |
||
| 90 | CREATE INDEX IDX_9EBADCD910A0EA3F ON stu_alliances_relations (alliance_id) |
||
| 91 | SQL); |
||
| 92 | $this->addSql(<<<'SQL' |
||
| 93 | CREATE INDEX IDX_9EBADCD96804FB49 ON stu_alliances_relations (recipient) |
||
| 94 | SQL); |
||
| 95 | $this->addSql(<<<'SQL' |
||
| 96 | CREATE INDEX alliance_relation_idx ON stu_alliances_relations (alliance_id, recipient) |
||
| 97 | SQL); |
||
| 98 | $this->addSql(<<<'SQL' |
||
| 99 | CREATE TABLE stu_anomaly (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, remaining_ticks INTEGER NOT NULL, anomaly_type_id INTEGER NOT NULL, location_id INTEGER DEFAULT NULL, parent_id INTEGER DEFAULT NULL, data CLOB DEFAULT NULL, CONSTRAINT FK_A1426D1126894FC7 FOREIGN KEY (anomaly_type_id) REFERENCES stu_anomaly_type (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A1426D1164D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A1426D11727ACA70 FOREIGN KEY (parent_id) REFERENCES stu_anomaly (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 100 | SQL); |
||
| 101 | $this->addSql(<<<'SQL' |
||
| 102 | CREATE INDEX IDX_A1426D1164D218E ON stu_anomaly (location_id) |
||
| 103 | SQL); |
||
| 104 | $this->addSql(<<<'SQL' |
||
| 105 | CREATE INDEX IDX_A1426D11727ACA70 ON stu_anomaly (parent_id) |
||
| 106 | SQL); |
||
| 107 | $this->addSql(<<<'SQL' |
||
| 108 | CREATE INDEX anomaly_to_type_idx ON stu_anomaly (anomaly_type_id) |
||
| 109 | SQL); |
||
| 110 | $this->addSql(<<<'SQL' |
||
| 111 | CREATE INDEX anomaly_remaining_idx ON stu_anomaly (remaining_ticks) |
||
| 112 | SQL); |
||
| 113 | $this->addSql(<<<'SQL' |
||
| 114 | CREATE TABLE stu_anomaly_type (id INTEGER NOT NULL, name VARCHAR(200) NOT NULL, lifespan_in_ticks INTEGER NOT NULL, PRIMARY KEY(id)) |
||
| 115 | SQL); |
||
| 116 | $this->addSql(<<<'SQL' |
||
| 117 | CREATE TABLE stu_astro_entry (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, state SMALLINT NOT NULL, astro_start_turn INTEGER DEFAULT NULL, systems_id INTEGER DEFAULT NULL, region_id INTEGER DEFAULT NULL, field_ids CLOB NOT NULL, CONSTRAINT FK_783E1A92A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_783E1A92411D7F6D FOREIGN KEY (systems_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_783E1A9298260155 FOREIGN KEY (region_id) REFERENCES stu_map_regions (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 118 | SQL); |
||
| 119 | $this->addSql(<<<'SQL' |
||
| 120 | CREATE INDEX astro_entry_user_idx ON stu_astro_entry (user_id) |
||
| 121 | SQL); |
||
| 122 | $this->addSql(<<<'SQL' |
||
| 123 | CREATE INDEX astro_entry_star_system_idx ON stu_astro_entry (systems_id) |
||
| 124 | SQL); |
||
| 125 | $this->addSql(<<<'SQL' |
||
| 126 | CREATE INDEX astro_entry_map_region_idx ON stu_astro_entry (region_id) |
||
| 127 | SQL); |
||
| 128 | $this->addSql(<<<'SQL' |
||
| 129 | CREATE TABLE stu_auction_bid (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, auction_id INTEGER NOT NULL, user_id INTEGER NOT NULL, max_amount INTEGER NOT NULL, CONSTRAINT FK_F198A82957B8F0DE FOREIGN KEY (auction_id) REFERENCES stu_deals (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_F198A829A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 130 | SQL); |
||
| 131 | $this->addSql(<<<'SQL' |
||
| 132 | CREATE INDEX IDX_F198A82957B8F0DE ON stu_auction_bid (auction_id) |
||
| 133 | SQL); |
||
| 134 | $this->addSql(<<<'SQL' |
||
| 135 | CREATE INDEX IDX_F198A829A76ED395 ON stu_auction_bid (user_id) |
||
| 136 | SQL); |
||
| 137 | $this->addSql(<<<'SQL' |
||
| 138 | CREATE INDEX auction_bid_sort_idx ON stu_auction_bid (max_amount) |
||
| 139 | SQL); |
||
| 140 | $this->addSql(<<<'SQL' |
||
| 141 | CREATE TABLE stu_award (id INTEGER NOT NULL, prestige INTEGER NOT NULL, description CLOB NOT NULL, PRIMARY KEY(id)) |
||
| 142 | SQL); |
||
| 143 | $this->addSql(<<<'SQL' |
||
| 144 | CREATE TABLE stu_basic_trade (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, faction_id INTEGER DEFAULT NULL, commodity_id INTEGER NOT NULL, buy_sell SMALLINT NOT NULL, value INTEGER NOT NULL, date_ms BIGINT DEFAULT NULL, uniqid VARCHAR(255) NOT NULL, user_id INTEGER DEFAULT NULL, CONSTRAINT FK_15ACD9904448F8DA FOREIGN KEY (faction_id) REFERENCES stu_factions (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_15ACD990B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 145 | SQL); |
||
| 146 | $this->addSql(<<<'SQL' |
||
| 147 | CREATE INDEX IDX_15ACD9904448F8DA ON stu_basic_trade (faction_id) |
||
| 148 | SQL); |
||
| 149 | $this->addSql(<<<'SQL' |
||
| 150 | CREATE INDEX IDX_15ACD990B4ACC212 ON stu_basic_trade (commodity_id) |
||
| 151 | SQL); |
||
| 152 | $this->addSql(<<<'SQL' |
||
| 153 | CREATE INDEX base_trade_idx ON stu_basic_trade (faction_id, commodity_id, date_ms) |
||
| 154 | SQL); |
||
| 155 | $this->addSql(<<<'SQL' |
||
| 156 | CREATE TABLE stu_blocked_user (user_id INTEGER NOT NULL, time INTEGER NOT NULL, email_hash VARCHAR(255) NOT NULL, mobile_hash VARCHAR(255) DEFAULT NULL, PRIMARY KEY(user_id)) |
||
| 157 | SQL); |
||
| 158 | $this->addSql(<<<'SQL' |
||
| 159 | CREATE TABLE stu_buildings (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, lager SMALLINT NOT NULL, eps SMALLINT NOT NULL, eps_cost SMALLINT NOT NULL, eps_proc SMALLINT NOT NULL, bev_pro SMALLINT NOT NULL, bev_use SMALLINT NOT NULL, integrity SMALLINT NOT NULL, research_id INTEGER NOT NULL, "view" BOOLEAN NOT NULL, buildtime INTEGER NOT NULL, blimit SMALLINT NOT NULL, bclimit SMALLINT NOT NULL, is_activateable BOOLEAN NOT NULL, bm_col SMALLINT NOT NULL) |
||
| 160 | SQL); |
||
| 161 | $this->addSql(<<<'SQL' |
||
| 162 | CREATE INDEX eps_production_idx ON stu_buildings (eps_proc) |
||
| 163 | SQL); |
||
| 164 | $this->addSql(<<<'SQL' |
||
| 165 | CREATE INDEX buildmenu_column_idx ON stu_buildings (bm_col) |
||
| 166 | SQL); |
||
| 167 | $this->addSql(<<<'SQL' |
||
| 168 | CREATE INDEX building_research_idx ON stu_buildings (research_id) |
||
| 169 | SQL); |
||
| 170 | $this->addSql(<<<'SQL' |
||
| 171 | CREATE TABLE stu_buildings_commodity (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildings_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_D20755B9B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D20755B91485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 172 | SQL); |
||
| 173 | $this->addSql(<<<'SQL' |
||
| 174 | CREATE INDEX IDX_D20755B9B4ACC212 ON stu_buildings_commodity (commodity_id) |
||
| 175 | SQL); |
||
| 176 | $this->addSql(<<<'SQL' |
||
| 177 | CREATE INDEX building_commodity_building_idx ON stu_buildings_commodity (buildings_id) |
||
| 178 | SQL); |
||
| 179 | $this->addSql(<<<'SQL' |
||
| 180 | CREATE INDEX commodity_count_idx ON stu_buildings_commodity (commodity_id, count) |
||
| 181 | SQL); |
||
| 182 | $this->addSql(<<<'SQL' |
||
| 183 | CREATE TABLE stu_buildings_cost (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildings_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_A411CF8CB4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A411CF8C1485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 184 | SQL); |
||
| 185 | $this->addSql(<<<'SQL' |
||
| 186 | CREATE INDEX IDX_A411CF8CB4ACC212 ON stu_buildings_cost (commodity_id) |
||
| 187 | SQL); |
||
| 188 | $this->addSql(<<<'SQL' |
||
| 189 | CREATE INDEX building_cost_building_idx ON stu_buildings_cost (buildings_id) |
||
| 190 | SQL); |
||
| 191 | $this->addSql(<<<'SQL' |
||
| 192 | CREATE TABLE stu_buildings_field_alternative (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, fieldtype INTEGER NOT NULL, buildings_id INTEGER NOT NULL, alternate_buildings_id INTEGER NOT NULL, research_id INTEGER DEFAULT NULL, CONSTRAINT FK_A9CE59831485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A9CE5983D17B76D1 FOREIGN KEY (alternate_buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 193 | SQL); |
||
| 194 | $this->addSql(<<<'SQL' |
||
| 195 | CREATE INDEX IDX_A9CE59831485E613 ON stu_buildings_field_alternative (buildings_id) |
||
| 196 | SQL); |
||
| 197 | $this->addSql(<<<'SQL' |
||
| 198 | CREATE INDEX IDX_A9CE5983D17B76D1 ON stu_buildings_field_alternative (alternate_buildings_id) |
||
| 199 | SQL); |
||
| 200 | $this->addSql(<<<'SQL' |
||
| 201 | CREATE INDEX building_field_idx ON stu_buildings_field_alternative (fieldtype, buildings_id) |
||
| 202 | SQL); |
||
| 203 | $this->addSql(<<<'SQL' |
||
| 204 | CREATE TABLE stu_buildings_functions (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildings_id INTEGER NOT NULL, function SMALLINT NOT NULL, CONSTRAINT FK_CF2657C11485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 205 | SQL); |
||
| 206 | $this->addSql(<<<'SQL' |
||
| 207 | CREATE INDEX building_function_building_idx ON stu_buildings_functions (buildings_id) |
||
| 208 | SQL); |
||
| 209 | $this->addSql(<<<'SQL' |
||
| 210 | CREATE INDEX building_function_function_idx ON stu_buildings_functions (function) |
||
| 211 | SQL); |
||
| 212 | $this->addSql(<<<'SQL' |
||
| 213 | CREATE TABLE stu_buildings_upgrades (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, upgrade_from INTEGER NOT NULL, upgrade_to INTEGER NOT NULL, research_id INTEGER NOT NULL, description VARCHAR(255) NOT NULL, energy_cost INTEGER NOT NULL, CONSTRAINT FK_BFDD6E5BF0CC2E2A FOREIGN KEY (upgrade_to) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BFDD6E5BCDECE66E FOREIGN KEY (upgrade_from) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 214 | SQL); |
||
| 215 | $this->addSql(<<<'SQL' |
||
| 216 | CREATE INDEX IDX_BFDD6E5BF0CC2E2A ON stu_buildings_upgrades (upgrade_to) |
||
| 217 | SQL); |
||
| 218 | $this->addSql(<<<'SQL' |
||
| 219 | CREATE INDEX IDX_BFDD6E5BCDECE66E ON stu_buildings_upgrades (upgrade_from) |
||
| 220 | SQL); |
||
| 221 | $this->addSql(<<<'SQL' |
||
| 222 | CREATE INDEX upgrade_from_research_idx ON stu_buildings_upgrades (upgrade_from, research_id) |
||
| 223 | SQL); |
||
| 224 | $this->addSql(<<<'SQL' |
||
| 225 | CREATE TABLE stu_buildings_upgrades_cost (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildings_upgrades_id BIGINT NOT NULL, commodity_id INTEGER NOT NULL, amount INTEGER NOT NULL, CONSTRAINT FK_37358E19B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_37358E1927B02F4A FOREIGN KEY (buildings_upgrades_id) REFERENCES stu_buildings_upgrades (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 226 | SQL); |
||
| 227 | $this->addSql(<<<'SQL' |
||
| 228 | CREATE INDEX IDX_37358E19B4ACC212 ON stu_buildings_upgrades_cost (commodity_id) |
||
| 229 | SQL); |
||
| 230 | $this->addSql(<<<'SQL' |
||
| 231 | CREATE INDEX buildings_upgrades_idx ON stu_buildings_upgrades_cost (buildings_upgrades_id) |
||
| 232 | SQL); |
||
| 233 | $this->addSql(<<<'SQL' |
||
| 234 | CREATE TABLE stu_buildplan (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, user_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, buildtime INTEGER NOT NULL, signature VARCHAR(32) DEFAULT NULL, crew SMALLINT NOT NULL, CONSTRAINT FK_8FFD6A1A2EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_8FFD6A1AA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 235 | SQL); |
||
| 236 | $this->addSql(<<<'SQL' |
||
| 237 | CREATE INDEX IDX_8FFD6A1A2EE98D4C ON stu_buildplan (rump_id) |
||
| 238 | SQL); |
||
| 239 | $this->addSql(<<<'SQL' |
||
| 240 | CREATE INDEX IDX_8FFD6A1AA76ED395 ON stu_buildplan (user_id) |
||
| 241 | SQL); |
||
| 242 | $this->addSql(<<<'SQL' |
||
| 243 | CREATE UNIQUE INDEX buildplan_signatures_idx ON stu_buildplan (user_id, rump_id, signature) |
||
| 244 | SQL); |
||
| 245 | $this->addSql(<<<'SQL' |
||
| 246 | CREATE TABLE stu_buildplans_hangar (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, buildplan_id INTEGER NOT NULL, default_torpedo_type_id INTEGER DEFAULT NULL, start_energy_costs INTEGER NOT NULL, CONSTRAINT FK_DE1E0721497D0592 FOREIGN KEY (default_torpedo_type_id) REFERENCES stu_torpedo_types (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_DE1E07218638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_DE1E07212EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 247 | SQL); |
||
| 248 | $this->addSql(<<<'SQL' |
||
| 249 | CREATE INDEX IDX_DE1E0721497D0592 ON stu_buildplans_hangar (default_torpedo_type_id) |
||
| 250 | SQL); |
||
| 251 | $this->addSql(<<<'SQL' |
||
| 252 | CREATE INDEX IDX_DE1E07218638E4E7 ON stu_buildplans_hangar (buildplan_id) |
||
| 253 | SQL); |
||
| 254 | $this->addSql(<<<'SQL' |
||
| 255 | CREATE UNIQUE INDEX rump_idx ON stu_buildplans_hangar (rump_id) |
||
| 256 | SQL); |
||
| 257 | $this->addSql(<<<'SQL' |
||
| 258 | CREATE TABLE stu_buildplans_modules (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildplan_id INTEGER NOT NULL, module_type SMALLINT NOT NULL, module_id INTEGER NOT NULL, module_special INTEGER DEFAULT NULL, module_count SMALLINT NOT NULL, CONSTRAINT FK_82701FF58638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_82701FF5AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 259 | SQL); |
||
| 260 | $this->addSql(<<<'SQL' |
||
| 261 | CREATE INDEX IDX_82701FF58638E4E7 ON stu_buildplans_modules (buildplan_id) |
||
| 262 | SQL); |
||
| 263 | $this->addSql(<<<'SQL' |
||
| 264 | CREATE INDEX IDX_82701FF5AFC2B591 ON stu_buildplans_modules (module_id) |
||
| 265 | SQL); |
||
| 266 | $this->addSql(<<<'SQL' |
||
| 267 | CREATE UNIQUE INDEX buildplan_module_type_idx ON stu_buildplans_modules (buildplan_id, module_type, module_special) |
||
| 268 | SQL); |
||
| 269 | $this->addSql(<<<'SQL' |
||
| 270 | CREATE TABLE stu_buoy (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, text CLOB NOT NULL, location_id INTEGER NOT NULL, CONSTRAINT FK_B6DF528964D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_B6DF5289A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 271 | SQL); |
||
| 272 | $this->addSql(<<<'SQL' |
||
| 273 | CREATE INDEX IDX_B6DF528964D218E ON stu_buoy (location_id) |
||
| 274 | SQL); |
||
| 275 | $this->addSql(<<<'SQL' |
||
| 276 | CREATE INDEX IDX_B6DF5289A76ED395 ON stu_buoy (user_id) |
||
| 277 | SQL); |
||
| 278 | $this->addSql(<<<'SQL' |
||
| 279 | CREATE TABLE stu_colonies (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colonies_classes_id INTEGER NOT NULL, user_id INTEGER NOT NULL, starsystem_map_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, planet_name VARCHAR(100) NOT NULL, bev_work INTEGER NOT NULL, bev_free INTEGER NOT NULL, bev_max INTEGER NOT NULL, eps INTEGER NOT NULL, max_eps INTEGER NOT NULL, max_storage INTEGER NOT NULL, mask CLOB DEFAULT NULL, database_id INTEGER DEFAULT NULL, populationlimit INTEGER NOT NULL, immigrationstate BOOLEAN NOT NULL, shields INTEGER DEFAULT NULL, shield_frequency INTEGER DEFAULT NULL, torpedo_type INTEGER DEFAULT NULL, rotation_factor INTEGER NOT NULL, surface_width INTEGER NOT NULL, CONSTRAINT FK_D1C60F739106126 FOREIGN KEY (colonies_classes_id) REFERENCES stu_colonies_classes (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D1C60F73496DDE10 FOREIGN KEY (starsystem_map_id) REFERENCES stu_sys_map (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D1C60F73A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D1C60F73942323E3 FOREIGN KEY (torpedo_type) REFERENCES stu_torpedo_types (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D1C60F73F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 280 | SQL); |
||
| 281 | $this->addSql(<<<'SQL' |
||
| 282 | CREATE UNIQUE INDEX UNIQ_D1C60F73496DDE10 ON stu_colonies (starsystem_map_id) |
||
| 283 | SQL); |
||
| 284 | $this->addSql(<<<'SQL' |
||
| 285 | CREATE INDEX IDX_D1C60F73942323E3 ON stu_colonies (torpedo_type) |
||
| 286 | SQL); |
||
| 287 | $this->addSql(<<<'SQL' |
||
| 288 | CREATE UNIQUE INDEX UNIQ_D1C60F73F0AA09DB ON stu_colonies (database_id) |
||
| 289 | SQL); |
||
| 290 | $this->addSql(<<<'SQL' |
||
| 291 | CREATE INDEX colony_user_idx ON stu_colonies (user_id) |
||
| 292 | SQL); |
||
| 293 | $this->addSql(<<<'SQL' |
||
| 294 | CREATE INDEX colony_classes_idx ON stu_colonies (colonies_classes_id) |
||
| 295 | SQL); |
||
| 296 | $this->addSql(<<<'SQL' |
||
| 297 | CREATE INDEX colony_sys_map_idx ON stu_colonies (starsystem_map_id) |
||
| 298 | SQL); |
||
| 299 | $this->addSql(<<<'SQL' |
||
| 300 | CREATE TABLE stu_colonies_classes (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, type INTEGER NOT NULL, database_id INTEGER DEFAULT NULL, colonizeable_fields CLOB NOT NULL, bev_growth_rate SMALLINT NOT NULL, special SMALLINT NOT NULL, allow_start BOOLEAN NOT NULL, min_rot INTEGER NOT NULL, max_rot INTEGER NOT NULL, CONSTRAINT FK_D116D262F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 301 | SQL); |
||
| 302 | $this->addSql(<<<'SQL' |
||
| 303 | CREATE UNIQUE INDEX UNIQ_D116D262F0AA09DB ON stu_colonies_classes (database_id) |
||
| 304 | SQL); |
||
| 305 | $this->addSql(<<<'SQL' |
||
| 306 | CREATE TABLE stu_colonies_fielddata (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colonies_id INTEGER DEFAULT NULL, colony_sandbox_id INTEGER DEFAULT NULL, field_id SMALLINT NOT NULL, type_id INTEGER NOT NULL, buildings_id INTEGER DEFAULT NULL, terraforming_id INTEGER DEFAULT NULL, integrity SMALLINT NOT NULL, aktiv INTEGER NOT NULL, activate_after_build BOOLEAN NOT NULL, CONSTRAINT FK_7E4F10971485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7E4F1097BD31079C FOREIGN KEY (terraforming_id) REFERENCES stu_terraforming (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7E4F109774EB5CC8 FOREIGN KEY (colonies_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7E4F1097A0222FA4 FOREIGN KEY (colony_sandbox_id) REFERENCES stu_colony_sandbox (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 307 | SQL); |
||
| 308 | $this->addSql(<<<'SQL' |
||
| 309 | CREATE INDEX IDX_7E4F10971485E613 ON stu_colonies_fielddata (buildings_id) |
||
| 310 | SQL); |
||
| 311 | $this->addSql(<<<'SQL' |
||
| 312 | CREATE INDEX IDX_7E4F1097BD31079C ON stu_colonies_fielddata (terraforming_id) |
||
| 313 | SQL); |
||
| 314 | $this->addSql(<<<'SQL' |
||
| 315 | CREATE INDEX IDX_7E4F109774EB5CC8 ON stu_colonies_fielddata (colonies_id) |
||
| 316 | SQL); |
||
| 317 | $this->addSql(<<<'SQL' |
||
| 318 | CREATE INDEX IDX_7E4F1097A0222FA4 ON stu_colonies_fielddata (colony_sandbox_id) |
||
| 319 | SQL); |
||
| 320 | $this->addSql(<<<'SQL' |
||
| 321 | CREATE INDEX colony_field_idx ON stu_colonies_fielddata (colonies_id, field_id) |
||
| 322 | SQL); |
||
| 323 | $this->addSql(<<<'SQL' |
||
| 324 | CREATE INDEX sandbox_field_idx ON stu_colonies_fielddata (colony_sandbox_id, field_id) |
||
| 325 | SQL); |
||
| 326 | $this->addSql(<<<'SQL' |
||
| 327 | CREATE INDEX colony_building_active_idx ON stu_colonies_fielddata (colonies_id, buildings_id, aktiv) |
||
| 328 | SQL); |
||
| 329 | $this->addSql(<<<'SQL' |
||
| 330 | CREATE INDEX sandbox_building_active_idx ON stu_colonies_fielddata (colony_sandbox_id, buildings_id, aktiv) |
||
| 331 | SQL); |
||
| 332 | $this->addSql(<<<'SQL' |
||
| 333 | CREATE INDEX active_idx ON stu_colonies_fielddata (aktiv) |
||
| 334 | SQL); |
||
| 335 | $this->addSql(<<<'SQL' |
||
| 336 | CREATE TABLE stu_colonies_shipqueue (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_id INTEGER NOT NULL, user_id INTEGER NOT NULL, rump_id INTEGER NOT NULL, buildplan_id INTEGER NOT NULL, buildtime INTEGER NOT NULL, finish_date INTEGER NOT NULL, stop_date INTEGER NOT NULL, building_function_id SMALLINT NOT NULL, mode INTEGER DEFAULT NULL, ship_id INTEGER DEFAULT NULL, CONSTRAINT FK_BEDCCA2F8638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BEDCCA2F2EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BEDCCA2F96ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BEDCCA2FC256317D FOREIGN KEY (ship_id) REFERENCES stu_ship (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 337 | SQL); |
||
| 338 | $this->addSql(<<<'SQL' |
||
| 339 | CREATE INDEX IDX_BEDCCA2F8638E4E7 ON stu_colonies_shipqueue (buildplan_id) |
||
| 340 | SQL); |
||
| 341 | $this->addSql(<<<'SQL' |
||
| 342 | CREATE INDEX IDX_BEDCCA2F2EE98D4C ON stu_colonies_shipqueue (rump_id) |
||
| 343 | SQL); |
||
| 344 | $this->addSql(<<<'SQL' |
||
| 345 | CREATE INDEX IDX_BEDCCA2F96ADBADE ON stu_colonies_shipqueue (colony_id) |
||
| 346 | SQL); |
||
| 347 | $this->addSql(<<<'SQL' |
||
| 348 | CREATE UNIQUE INDEX UNIQ_BEDCCA2FC256317D ON stu_colonies_shipqueue (ship_id) |
||
| 349 | SQL); |
||
| 350 | $this->addSql(<<<'SQL' |
||
| 351 | CREATE INDEX colony_shipqueue_building_function_idx ON stu_colonies_shipqueue (colony_id, building_function_id) |
||
| 352 | SQL); |
||
| 353 | $this->addSql(<<<'SQL' |
||
| 354 | CREATE INDEX colony_shipqueue_user_idx ON stu_colonies_shipqueue (user_id) |
||
| 355 | SQL); |
||
| 356 | $this->addSql(<<<'SQL' |
||
| 357 | CREATE INDEX colony_shipqueue_finish_date_idx ON stu_colonies_shipqueue (finish_date) |
||
| 358 | SQL); |
||
| 359 | $this->addSql(<<<'SQL' |
||
| 360 | CREATE TABLE stu_colonies_shiprepair (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_id INTEGER NOT NULL, ship_id INTEGER NOT NULL, field_id INTEGER NOT NULL, CONSTRAINT FK_F14F182F96ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_F14F182FC256317D FOREIGN KEY (ship_id) REFERENCES stu_ship (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 361 | SQL); |
||
| 362 | $this->addSql(<<<'SQL' |
||
| 363 | CREATE INDEX IDX_F14F182F96ADBADE ON stu_colonies_shiprepair (colony_id) |
||
| 364 | SQL); |
||
| 365 | $this->addSql(<<<'SQL' |
||
| 366 | CREATE UNIQUE INDEX UNIQ_F14F182FC256317D ON stu_colonies_shiprepair (ship_id) |
||
| 367 | SQL); |
||
| 368 | $this->addSql(<<<'SQL' |
||
| 369 | CREATE TABLE stu_colonies_terraforming (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colonies_id INTEGER NOT NULL, field_id INTEGER NOT NULL, terraforming_id INTEGER NOT NULL, finished INTEGER NOT NULL, CONSTRAINT FK_AFB8ADC7BD31079C FOREIGN KEY (terraforming_id) REFERENCES stu_terraforming (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AFB8ADC7443707B0 FOREIGN KEY (field_id) REFERENCES stu_colonies_fielddata (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AFB8ADC774EB5CC8 FOREIGN KEY (colonies_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 370 | SQL); |
||
| 371 | $this->addSql(<<<'SQL' |
||
| 372 | CREATE INDEX IDX_AFB8ADC7BD31079C ON stu_colonies_terraforming (terraforming_id) |
||
| 373 | SQL); |
||
| 374 | $this->addSql(<<<'SQL' |
||
| 375 | CREATE INDEX IDX_AFB8ADC7443707B0 ON stu_colonies_terraforming (field_id) |
||
| 376 | SQL); |
||
| 377 | $this->addSql(<<<'SQL' |
||
| 378 | CREATE INDEX colony_idx ON stu_colonies_terraforming (colonies_id) |
||
| 379 | SQL); |
||
| 380 | $this->addSql(<<<'SQL' |
||
| 381 | CREATE INDEX finished_idx ON stu_colonies_terraforming (finished) |
||
| 382 | SQL); |
||
| 383 | $this->addSql(<<<'SQL' |
||
| 384 | CREATE TABLE stu_colony_class_deposit (colony_class_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, min_amount INTEGER NOT NULL, max_amount INTEGER NOT NULL, PRIMARY KEY(colony_class_id, commodity_id), CONSTRAINT FK_A843E75CBA61CECC FOREIGN KEY (colony_class_id) REFERENCES stu_colonies_classes (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A843E75CB4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 385 | SQL); |
||
| 386 | $this->addSql(<<<'SQL' |
||
| 387 | CREATE INDEX IDX_A843E75CBA61CECC ON stu_colony_class_deposit (colony_class_id) |
||
| 388 | SQL); |
||
| 389 | $this->addSql(<<<'SQL' |
||
| 390 | CREATE INDEX IDX_A843E75CB4ACC212 ON stu_colony_class_deposit (commodity_id) |
||
| 391 | SQL); |
||
| 392 | $this->addSql(<<<'SQL' |
||
| 393 | CREATE TABLE stu_colony_class_restriction (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_class_id INTEGER NOT NULL, terraforming_id INTEGER DEFAULT NULL, building_id INTEGER DEFAULT NULL, CONSTRAINT FK_CEF73D7ABA61CECC FOREIGN KEY (colony_class_id) REFERENCES stu_colonies_classes (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CEF73D7ABD31079C FOREIGN KEY (terraforming_id) REFERENCES stu_terraforming (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CEF73D7A4D2A7E12 FOREIGN KEY (building_id) REFERENCES stu_buildings (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 394 | SQL); |
||
| 395 | $this->addSql(<<<'SQL' |
||
| 396 | CREATE INDEX IDX_CEF73D7ABA61CECC ON stu_colony_class_restriction (colony_class_id) |
||
| 397 | SQL); |
||
| 398 | $this->addSql(<<<'SQL' |
||
| 399 | CREATE INDEX IDX_CEF73D7ABD31079C ON stu_colony_class_restriction (terraforming_id) |
||
| 400 | SQL); |
||
| 401 | $this->addSql(<<<'SQL' |
||
| 402 | CREATE INDEX IDX_CEF73D7A4D2A7E12 ON stu_colony_class_restriction (building_id) |
||
| 403 | SQL); |
||
| 404 | $this->addSql(<<<'SQL' |
||
| 405 | CREATE TABLE stu_colony_deposit_mining (user_id INTEGER NOT NULL, colony_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, amount_left INTEGER NOT NULL, PRIMARY KEY(user_id, colony_id, commodity_id), CONSTRAINT FK_BD7DF1EAA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BD7DF1EA96ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BD7DF1EAB4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 406 | SQL); |
||
| 407 | $this->addSql(<<<'SQL' |
||
| 408 | CREATE INDEX IDX_BD7DF1EAA76ED395 ON stu_colony_deposit_mining (user_id) |
||
| 409 | SQL); |
||
| 410 | $this->addSql(<<<'SQL' |
||
| 411 | CREATE INDEX IDX_BD7DF1EA96ADBADE ON stu_colony_deposit_mining (colony_id) |
||
| 412 | SQL); |
||
| 413 | $this->addSql(<<<'SQL' |
||
| 414 | CREATE INDEX IDX_BD7DF1EAB4ACC212 ON stu_colony_deposit_mining (commodity_id) |
||
| 415 | SQL); |
||
| 416 | $this->addSql(<<<'SQL' |
||
| 417 | CREATE TABLE stu_colony_fieldtype (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, field_id INTEGER NOT NULL, description VARCHAR(255) NOT NULL, normal_id INTEGER NOT NULL, category INTEGER NOT NULL) |
||
| 418 | SQL); |
||
| 419 | $this->addSql(<<<'SQL' |
||
| 420 | CREATE INDEX field_id_idx ON stu_colony_fieldtype (field_id) |
||
| 421 | SQL); |
||
| 422 | $this->addSql(<<<'SQL' |
||
| 423 | CREATE TABLE stu_colony_sandbox (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, bev_work INTEGER NOT NULL, bev_max INTEGER NOT NULL, max_eps INTEGER NOT NULL, max_storage INTEGER NOT NULL, mask CLOB DEFAULT NULL, CONSTRAINT FK_7F824EAB96ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 424 | SQL); |
||
| 425 | $this->addSql(<<<'SQL' |
||
| 426 | CREATE INDEX IDX_7F824EAB96ADBADE ON stu_colony_sandbox (colony_id) |
||
| 427 | SQL); |
||
| 428 | $this->addSql(<<<'SQL' |
||
| 429 | CREATE TABLE stu_colony_scan (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_id INTEGER NOT NULL, user_id INTEGER NOT NULL, colony_user_id INTEGER NOT NULL, colony_name VARCHAR(255) DEFAULT NULL, colony_user_name VARCHAR(255) NOT NULL, mask CLOB NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_2853B5FC96ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2853B5FCA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 430 | SQL); |
||
| 431 | $this->addSql(<<<'SQL' |
||
| 432 | CREATE INDEX IDX_2853B5FC96ADBADE ON stu_colony_scan (colony_id) |
||
| 433 | SQL); |
||
| 434 | $this->addSql(<<<'SQL' |
||
| 435 | CREATE INDEX IDX_2853B5FCA76ED395 ON stu_colony_scan (user_id) |
||
| 436 | SQL); |
||
| 437 | $this->addSql(<<<'SQL' |
||
| 438 | CREATE TABLE stu_commodity (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, sort SMALLINT NOT NULL, "view" BOOLEAN NOT NULL, type SMALLINT NOT NULL, npc_commodity BOOLEAN NOT NULL, bound BOOLEAN NOT NULL) |
||
| 439 | SQL); |
||
| 440 | $this->addSql(<<<'SQL' |
||
| 441 | CREATE TABLE stu_construction_progress (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, station_id INTEGER NOT NULL, remaining_ticks INTEGER NOT NULL, CONSTRAINT FK_57D2AD0421BDB235 FOREIGN KEY (station_id) REFERENCES stu_station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 442 | SQL); |
||
| 443 | $this->addSql(<<<'SQL' |
||
| 444 | CREATE UNIQUE INDEX UNIQ_57D2AD0421BDB235 ON stu_construction_progress (station_id) |
||
| 445 | SQL); |
||
| 446 | $this->addSql(<<<'SQL' |
||
| 447 | CREATE TABLE stu_contactlist (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, recipient INTEGER NOT NULL, mode SMALLINT NOT NULL, comment VARCHAR(50) NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_451BB4B0A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_451BB4B06804FB49 FOREIGN KEY (recipient) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 448 | SQL); |
||
| 449 | $this->addSql(<<<'SQL' |
||
| 450 | CREATE INDEX IDX_451BB4B0A76ED395 ON stu_contactlist (user_id) |
||
| 451 | SQL); |
||
| 452 | $this->addSql(<<<'SQL' |
||
| 453 | CREATE INDEX IDX_451BB4B06804FB49 ON stu_contactlist (recipient) |
||
| 454 | SQL); |
||
| 455 | $this->addSql(<<<'SQL' |
||
| 456 | CREATE INDEX user_pair_idx ON stu_contactlist (user_id, recipient) |
||
| 457 | SQL); |
||
| 458 | $this->addSql(<<<'SQL' |
||
| 459 | CREATE TABLE stu_crew (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type SMALLINT NOT NULL, gender SMALLINT NOT NULL, name VARCHAR(255) NOT NULL, user_id INTEGER NOT NULL, race_id INTEGER NOT NULL, CONSTRAINT FK_167BE6E46E59D40D FOREIGN KEY (race_id) REFERENCES stu_crew_race (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_167BE6E4A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 460 | SQL); |
||
| 461 | $this->addSql(<<<'SQL' |
||
| 462 | CREATE INDEX IDX_167BE6E46E59D40D ON stu_crew (race_id) |
||
| 463 | SQL); |
||
| 464 | $this->addSql(<<<'SQL' |
||
| 465 | CREATE INDEX IDX_167BE6E4A76ED395 ON stu_crew (user_id) |
||
| 466 | SQL); |
||
| 467 | $this->addSql(<<<'SQL' |
||
| 468 | CREATE TABLE stu_crew_assign (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, spacecraft_id INTEGER DEFAULT NULL, colony_id INTEGER DEFAULT NULL, tradepost_id INTEGER DEFAULT NULL, crew_id INTEGER NOT NULL, slot SMALLINT DEFAULT NULL, user_id INTEGER NOT NULL, repair_task_id INTEGER DEFAULT NULL, CONSTRAINT FK_4793ED245FE259F6 FOREIGN KEY (crew_id) REFERENCES stu_crew (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4793ED241C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4793ED2496ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4793ED248B935ABD FOREIGN KEY (tradepost_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4793ED24A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4793ED24130D5415 FOREIGN KEY (repair_task_id) REFERENCES stu_repair_task (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 469 | SQL); |
||
| 470 | $this->addSql(<<<'SQL' |
||
| 471 | CREATE INDEX IDX_4793ED241C6AF6FD ON stu_crew_assign (spacecraft_id) |
||
| 472 | SQL); |
||
| 473 | $this->addSql(<<<'SQL' |
||
| 474 | CREATE INDEX IDX_4793ED2496ADBADE ON stu_crew_assign (colony_id) |
||
| 475 | SQL); |
||
| 476 | $this->addSql(<<<'SQL' |
||
| 477 | CREATE INDEX IDX_4793ED248B935ABD ON stu_crew_assign (tradepost_id) |
||
| 478 | SQL); |
||
| 479 | $this->addSql(<<<'SQL' |
||
| 480 | CREATE INDEX IDX_4793ED24A76ED395 ON stu_crew_assign (user_id) |
||
| 481 | SQL); |
||
| 482 | $this->addSql(<<<'SQL' |
||
| 483 | CREATE INDEX IDX_4793ED24130D5415 ON stu_crew_assign (repair_task_id) |
||
| 484 | SQL); |
||
| 485 | $this->addSql(<<<'SQL' |
||
| 486 | CREATE UNIQUE INDEX crew_assign_crew_idx ON stu_crew_assign (crew_id) |
||
| 487 | SQL); |
||
| 488 | $this->addSql(<<<'SQL' |
||
| 489 | CREATE TABLE stu_crew_race (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, faction_id INTEGER NOT NULL, description VARCHAR(255) NOT NULL, chance SMALLINT NOT NULL, maleratio SMALLINT NOT NULL, define VARCHAR(255) NOT NULL, CONSTRAINT FK_ED3686294448F8DA FOREIGN KEY (faction_id) REFERENCES stu_factions (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 490 | SQL); |
||
| 491 | $this->addSql(<<<'SQL' |
||
| 492 | CREATE INDEX IDX_ED3686294448F8DA ON stu_crew_race (faction_id) |
||
| 493 | SQL); |
||
| 494 | $this->addSql(<<<'SQL' |
||
| 495 | CREATE TABLE stu_crew_training (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, colony_id INTEGER NOT NULL, CONSTRAINT FK_E25756B996ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E25756B9A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 496 | SQL); |
||
| 497 | $this->addSql(<<<'SQL' |
||
| 498 | CREATE INDEX crew_training_colony_idx ON stu_crew_training (colony_id) |
||
| 499 | SQL); |
||
| 500 | $this->addSql(<<<'SQL' |
||
| 501 | CREATE INDEX crew_training_user_idx ON stu_crew_training (user_id) |
||
| 502 | SQL); |
||
| 503 | $this->addSql(<<<'SQL' |
||
| 504 | CREATE TABLE stu_database_categories (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, points INTEGER NOT NULL, type INTEGER NOT NULL, sort INTEGER NOT NULL, prestige INTEGER NOT NULL) |
||
| 505 | SQL); |
||
| 506 | $this->addSql(<<<'SQL' |
||
| 507 | CREATE TABLE stu_database_category_awards (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, category_id INTEGER NOT NULL, layer_id INTEGER DEFAULT NULL, award_id INTEGER DEFAULT NULL, CONSTRAINT FK_EEBC1A0512469DE2 FOREIGN KEY (category_id) REFERENCES stu_database_categories (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_EEBC1A053D5282CF FOREIGN KEY (award_id) REFERENCES stu_award (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 508 | SQL); |
||
| 509 | $this->addSql(<<<'SQL' |
||
| 510 | CREATE INDEX IDX_EEBC1A0512469DE2 ON stu_database_category_awards (category_id) |
||
| 511 | SQL); |
||
| 512 | $this->addSql(<<<'SQL' |
||
| 513 | CREATE INDEX IDX_EEBC1A053D5282CF ON stu_database_category_awards (award_id) |
||
| 514 | SQL); |
||
| 515 | $this->addSql(<<<'SQL' |
||
| 516 | CREATE TABLE stu_database_entrys (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, data CLOB NOT NULL, category_id INTEGER NOT NULL, type INTEGER NOT NULL, sort INTEGER NOT NULL, object_id INTEGER NOT NULL, layer_id INTEGER DEFAULT NULL, CONSTRAINT FK_4D14EE9A8CDE5729 FOREIGN KEY (type) REFERENCES stu_database_types (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4D14EE9A12469DE2 FOREIGN KEY (category_id) REFERENCES stu_database_categories (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 517 | SQL); |
||
| 518 | $this->addSql(<<<'SQL' |
||
| 519 | CREATE INDEX IDX_4D14EE9A8CDE5729 ON stu_database_entrys (type) |
||
| 520 | SQL); |
||
| 521 | $this->addSql(<<<'SQL' |
||
| 522 | CREATE INDEX database_entry_category_id_idx ON stu_database_entrys (category_id) |
||
| 523 | SQL); |
||
| 524 | $this->addSql(<<<'SQL' |
||
| 525 | CREATE TABLE stu_database_types (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, macro VARCHAR(255) NOT NULL) |
||
| 526 | SQL); |
||
| 527 | $this->addSql(<<<'SQL' |
||
| 528 | CREATE TABLE stu_database_user (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, database_id INTEGER NOT NULL, user_id INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_4148521FF0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4148521FA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 529 | SQL); |
||
| 530 | $this->addSql(<<<'SQL' |
||
| 531 | CREATE INDEX IDX_4148521FF0AA09DB ON stu_database_user (database_id) |
||
| 532 | SQL); |
||
| 533 | $this->addSql(<<<'SQL' |
||
| 534 | CREATE INDEX IDX_4148521FA76ED395 ON stu_database_user (user_id) |
||
| 535 | SQL); |
||
| 536 | $this->addSql(<<<'SQL' |
||
| 537 | CREATE TABLE stu_deals (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, faction_id INTEGER DEFAULT NULL, auction BOOLEAN NOT NULL, amount INTEGER DEFAULT NULL, give_commodity INTEGER DEFAULT NULL, want_commodity INTEGER DEFAULT NULL, give_commodity_amonut INTEGER DEFAULT NULL, want_commodity_amount INTEGER DEFAULT NULL, want_prestige INTEGER DEFAULT NULL, buildplan_id INTEGER DEFAULT NULL, ship BOOLEAN DEFAULT NULL, start INTEGER NOT NULL, "end" INTEGER NOT NULL, taken_time INTEGER DEFAULT NULL, auction_user INTEGER DEFAULT NULL, auction_amount INTEGER DEFAULT NULL, CONSTRAINT FK_6DAE42FCF27F1BE1 FOREIGN KEY (want_commodity) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_6DAE42FCABA274E9 FOREIGN KEY (give_commodity) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_6DAE42FC8638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 538 | SQL); |
||
| 539 | $this->addSql(<<<'SQL' |
||
| 540 | CREATE INDEX IDX_6DAE42FCF27F1BE1 ON stu_deals (want_commodity) |
||
| 541 | SQL); |
||
| 542 | $this->addSql(<<<'SQL' |
||
| 543 | CREATE INDEX IDX_6DAE42FCABA274E9 ON stu_deals (give_commodity) |
||
| 544 | SQL); |
||
| 545 | $this->addSql(<<<'SQL' |
||
| 546 | CREATE INDEX IDX_6DAE42FC8638E4E7 ON stu_deals (buildplan_id) |
||
| 547 | SQL); |
||
| 548 | $this->addSql(<<<'SQL' |
||
| 549 | CREATE TABLE stu_dockingrights (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, station_id INTEGER NOT NULL, target INTEGER NOT NULL, privilege_type SMALLINT NOT NULL, privilege_mode SMALLINT NOT NULL, CONSTRAINT FK_E7D4B2A21BDB235 FOREIGN KEY (station_id) REFERENCES stu_station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 550 | SQL); |
||
| 551 | $this->addSql(<<<'SQL' |
||
| 552 | CREATE INDEX dockingrights_station_idx ON stu_dockingrights (station_id) |
||
| 553 | SQL); |
||
| 554 | $this->addSql(<<<'SQL' |
||
| 555 | CREATE TABLE stu_factions (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description CLOB NOT NULL, darker_color VARCHAR(255) NOT NULL, chooseable BOOLEAN NOT NULL, player_limit INTEGER NOT NULL, start_building_id INTEGER NOT NULL, start_research_id INTEGER DEFAULT NULL, start_map_id INTEGER DEFAULT NULL, close_combat_score INTEGER DEFAULT NULL, positive_effect_primary_commodity_id INTEGER DEFAULT NULL, positive_effect_secondary_commodity_id INTEGER DEFAULT NULL, CONSTRAINT FK_55D1F3CC237EF159 FOREIGN KEY (start_research_id) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_55D1F3CC990AC8F4 FOREIGN KEY (start_map_id) REFERENCES stu_map (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_55D1F3CCFDE04DC5 FOREIGN KEY (positive_effect_primary_commodity_id) REFERENCES stu_commodity (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_55D1F3CC5840AFBB FOREIGN KEY (positive_effect_secondary_commodity_id) REFERENCES stu_commodity (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 556 | SQL); |
||
| 557 | $this->addSql(<<<'SQL' |
||
| 558 | CREATE INDEX IDX_55D1F3CC237EF159 ON stu_factions (start_research_id) |
||
| 559 | SQL); |
||
| 560 | $this->addSql(<<<'SQL' |
||
| 561 | CREATE INDEX IDX_55D1F3CC990AC8F4 ON stu_factions (start_map_id) |
||
| 562 | SQL); |
||
| 563 | $this->addSql(<<<'SQL' |
||
| 564 | CREATE INDEX IDX_55D1F3CCFDE04DC5 ON stu_factions (positive_effect_primary_commodity_id) |
||
| 565 | SQL); |
||
| 566 | $this->addSql(<<<'SQL' |
||
| 567 | CREATE INDEX IDX_55D1F3CC5840AFBB ON stu_factions (positive_effect_secondary_commodity_id) |
||
| 568 | SQL); |
||
| 569 | $this->addSql(<<<'SQL' |
||
| 570 | CREATE TABLE stu_field_build (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type INTEGER NOT NULL, buildings_id INTEGER NOT NULL, research_id INTEGER DEFAULT NULL, "view" BOOLEAN NOT NULL, CONSTRAINT FK_2785504A1485E613 FOREIGN KEY (buildings_id) REFERENCES stu_buildings (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 571 | SQL); |
||
| 572 | $this->addSql(<<<'SQL' |
||
| 573 | CREATE INDEX IDX_2785504A1485E613 ON stu_field_build (buildings_id) |
||
| 574 | SQL); |
||
| 575 | $this->addSql(<<<'SQL' |
||
| 576 | CREATE INDEX type_building_idx ON stu_field_build (type, buildings_id) |
||
| 577 | SQL); |
||
| 578 | $this->addSql(<<<'SQL' |
||
| 579 | CREATE INDEX type_building_research_idx ON stu_field_build (type, research_id) |
||
| 580 | SQL); |
||
| 581 | $this->addSql(<<<'SQL' |
||
| 582 | CREATE TABLE stu_fleets (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(200) NOT NULL, user_id INTEGER NOT NULL, ships_id INTEGER NOT NULL, defended_colony_id INTEGER DEFAULT NULL, blocked_colony_id INTEGER DEFAULT NULL, sort INTEGER DEFAULT NULL, is_fixed BOOLEAN NOT NULL, CONSTRAINT FK_2042261BA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2042261BC907E695 FOREIGN KEY (ships_id) REFERENCES stu_ship (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2042261BF61193E4 FOREIGN KEY (defended_colony_id) REFERENCES stu_colonies (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2042261B9722AC5D FOREIGN KEY (blocked_colony_id) REFERENCES stu_colonies (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 583 | SQL); |
||
| 584 | $this->addSql(<<<'SQL' |
||
| 585 | CREATE UNIQUE INDEX UNIQ_2042261BC907E695 ON stu_fleets (ships_id) |
||
| 586 | SQL); |
||
| 587 | $this->addSql(<<<'SQL' |
||
| 588 | CREATE INDEX IDX_2042261BF61193E4 ON stu_fleets (defended_colony_id) |
||
| 589 | SQL); |
||
| 590 | $this->addSql(<<<'SQL' |
||
| 591 | CREATE INDEX IDX_2042261B9722AC5D ON stu_fleets (blocked_colony_id) |
||
| 592 | SQL); |
||
| 593 | $this->addSql(<<<'SQL' |
||
| 594 | CREATE INDEX fleet_user_idx ON stu_fleets (user_id) |
||
| 595 | SQL); |
||
| 596 | $this->addSql(<<<'SQL' |
||
| 597 | CREATE TABLE stu_flight_sig (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, ship_id INTEGER NOT NULL, rump_id INTEGER NOT NULL, time INTEGER NOT NULL, location_id INTEGER NOT NULL, from_direction SMALLINT DEFAULT NULL, to_direction SMALLINT DEFAULT NULL, ship_name VARCHAR(255) NOT NULL, is_cloaked BOOLEAN NOT NULL, CONSTRAINT FK_C789CFE12EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_C789CFE164D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 598 | SQL); |
||
| 599 | $this->addSql(<<<'SQL' |
||
| 600 | CREATE INDEX IDX_C789CFE12EE98D4C ON stu_flight_sig (rump_id) |
||
| 601 | SQL); |
||
| 602 | $this->addSql(<<<'SQL' |
||
| 603 | CREATE INDEX IDX_C789CFE164D218E ON stu_flight_sig (location_id) |
||
| 604 | SQL); |
||
| 605 | $this->addSql(<<<'SQL' |
||
| 606 | CREATE INDEX flight_sig_user_idx ON stu_flight_sig (user_id) |
||
| 607 | SQL); |
||
| 608 | $this->addSql(<<<'SQL' |
||
| 609 | CREATE INDEX flight_sig_sensor_result_idx ON stu_flight_sig (from_direction, to_direction, time) |
||
| 610 | SQL); |
||
| 611 | $this->addSql(<<<'SQL' |
||
| 612 | CREATE TABLE stu_game_config (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, option SMALLINT NOT NULL, value SMALLINT NOT NULL) |
||
| 613 | SQL); |
||
| 614 | $this->addSql(<<<'SQL' |
||
| 615 | CREATE INDEX option_idx ON stu_game_config (option) |
||
| 616 | SQL); |
||
| 617 | $this->addSql(<<<'SQL' |
||
| 618 | CREATE TABLE stu_game_request (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER DEFAULT NULL, turn_id INTEGER NOT NULL, time INTEGER NOT NULL, module VARCHAR(255) DEFAULT NULL, "action" VARCHAR(255) DEFAULT NULL, action_ms INTEGER DEFAULT NULL, "view" VARCHAR(255) DEFAULT NULL, view_ms INTEGER DEFAULT NULL, render_ms INTEGER DEFAULT NULL, params CLOB DEFAULT NULL) |
||
| 619 | SQL); |
||
| 620 | $this->addSql(<<<'SQL' |
||
| 621 | CREATE INDEX game_request_idx ON stu_game_request (user_id, "action", "view") |
||
| 622 | SQL); |
||
| 623 | $this->addSql(<<<'SQL' |
||
| 624 | CREATE TABLE stu_game_turn_stats (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, turn_id INTEGER NOT NULL, user_count INTEGER NOT NULL, logins_24h INTEGER NOT NULL, inactive_count INTEGER NOT NULL, vacation_count INTEGER NOT NULL, ship_count INTEGER NOT NULL, ship_count_manned INTEGER NOT NULL, ship_count_npc INTEGER NOT NULL, kn_count INTEGER NOT NULL, flight_sig_24h INTEGER NOT NULL, flight_sig_system_24h INTEGER NOT NULL, new_pm_count INTEGER NOT NULL, CONSTRAINT FK_D3ABA4DB1F4F9889 FOREIGN KEY (turn_id) REFERENCES stu_game_turns (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 625 | SQL); |
||
| 626 | $this->addSql(<<<'SQL' |
||
| 627 | CREATE UNIQUE INDEX UNIQ_D3ABA4DB1F4F9889 ON stu_game_turn_stats (turn_id) |
||
| 628 | SQL); |
||
| 629 | $this->addSql(<<<'SQL' |
||
| 630 | CREATE INDEX game_turn_stats_turn_idx ON stu_game_turn_stats (turn_id) |
||
| 631 | SQL); |
||
| 632 | $this->addSql(<<<'SQL' |
||
| 633 | CREATE TABLE stu_game_turns (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, turn INTEGER NOT NULL, startdate INTEGER NOT NULL, enddate INTEGER NOT NULL, pirate_fleets INTEGER DEFAULT NULL) |
||
| 634 | SQL); |
||
| 635 | $this->addSql(<<<'SQL' |
||
| 636 | CREATE INDEX turn_idx ON stu_game_turns (turn) |
||
| 637 | SQL); |
||
| 638 | $this->addSql(<<<'SQL' |
||
| 639 | CREATE TABLE stu_history (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, type SMALLINT NOT NULL, source_user_id INTEGER DEFAULT NULL, target_user_id INTEGER DEFAULT NULL, location_id INTEGER DEFAULT NULL, CONSTRAINT FK_7F01683964D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 640 | SQL); |
||
| 641 | $this->addSql(<<<'SQL' |
||
| 642 | CREATE INDEX IDX_7F01683964D218E ON stu_history (location_id) |
||
| 643 | SQL); |
||
| 644 | $this->addSql(<<<'SQL' |
||
| 645 | CREATE INDEX type_idx ON stu_history (type) |
||
| 646 | SQL); |
||
| 647 | $this->addSql(<<<'SQL' |
||
| 648 | CREATE TABLE stu_ignorelist (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, recipient INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_B58C18ECA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_B58C18EC6804FB49 FOREIGN KEY (recipient) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 649 | SQL); |
||
| 650 | $this->addSql(<<<'SQL' |
||
| 651 | CREATE INDEX IDX_B58C18ECA76ED395 ON stu_ignorelist (user_id) |
||
| 652 | SQL); |
||
| 653 | $this->addSql(<<<'SQL' |
||
| 654 | CREATE INDEX IDX_B58C18EC6804FB49 ON stu_ignorelist (recipient) |
||
| 655 | SQL); |
||
| 656 | $this->addSql(<<<'SQL' |
||
| 657 | CREATE INDEX user_recipient_idx ON stu_ignorelist (user_id, recipient) |
||
| 658 | SQL); |
||
| 659 | $this->addSql(<<<'SQL' |
||
| 660 | CREATE TABLE stu_kn (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, titel VARCHAR(255) DEFAULT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, username VARCHAR(255) NOT NULL, user_id INTEGER DEFAULT NULL, del_user_id INTEGER DEFAULT NULL, lastedit INTEGER NOT NULL, plot_id INTEGER DEFAULT NULL, deleted INTEGER DEFAULT NULL, ratings CLOB NOT NULL, CONSTRAINT FK_27245FD3680D0B01 FOREIGN KEY (plot_id) REFERENCES stu_plots (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_27245FD3A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 661 | SQL); |
||
| 662 | $this->addSql(<<<'SQL' |
||
| 663 | CREATE INDEX plot_idx ON stu_kn (plot_id) |
||
| 664 | SQL); |
||
| 665 | $this->addSql(<<<'SQL' |
||
| 666 | CREATE INDEX kn_post_date_idx ON stu_kn (date) |
||
| 667 | SQL); |
||
| 668 | $this->addSql(<<<'SQL' |
||
| 669 | CREATE INDEX kn_post_user_idx ON stu_kn (user_id) |
||
| 670 | SQL); |
||
| 671 | $this->addSql(<<<'SQL' |
||
| 672 | CREATE TABLE stu_kn_archiv (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, version VARCHAR(255) NOT NULL, former_id INTEGER NOT NULL, titel VARCHAR(255) DEFAULT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, username VARCHAR(255) NOT NULL, user_id INTEGER NOT NULL, del_user_id INTEGER DEFAULT NULL, lastedit INTEGER DEFAULT NULL, plot_id INTEGER DEFAULT NULL, ratings CLOB NOT NULL, CONSTRAINT FK_412525B680D0B01 FOREIGN KEY (plot_id) REFERENCES stu_plots_archiv (former_id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 673 | SQL); |
||
| 674 | $this->addSql(<<<'SQL' |
||
| 675 | CREATE INDEX plot_archiv_idx ON stu_kn_archiv (plot_id) |
||
| 676 | SQL); |
||
| 677 | $this->addSql(<<<'SQL' |
||
| 678 | CREATE INDEX kn_post_archiv_date_idx ON stu_kn_archiv (date) |
||
| 679 | SQL); |
||
| 680 | $this->addSql(<<<'SQL' |
||
| 681 | CREATE UNIQUE INDEX unique_kn_archiv_former_id ON stu_kn_archiv (former_id) |
||
| 682 | SQL); |
||
| 683 | $this->addSql(<<<'SQL' |
||
| 684 | CREATE TABLE stu_kn_character (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, kn_id INTEGER NOT NULL, character_id INTEGER NOT NULL, CONSTRAINT FK_B00DC07A6A392D53 FOREIGN KEY (kn_id) REFERENCES stu_kn (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_B00DC07A1136BE75 FOREIGN KEY (character_id) REFERENCES stu_user_character (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 685 | SQL); |
||
| 686 | $this->addSql(<<<'SQL' |
||
| 687 | CREATE INDEX IDX_B00DC07A6A392D53 ON stu_kn_character (kn_id) |
||
| 688 | SQL); |
||
| 689 | $this->addSql(<<<'SQL' |
||
| 690 | CREATE INDEX IDX_B00DC07A1136BE75 ON stu_kn_character (character_id) |
||
| 691 | SQL); |
||
| 692 | $this->addSql(<<<'SQL' |
||
| 693 | CREATE TABLE stu_kn_comments (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, post_id INTEGER NOT NULL, user_id INTEGER NOT NULL, username VARCHAR(255) NOT NULL, text VARCHAR(255) NOT NULL, date INTEGER NOT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_F18967DD4B89032C FOREIGN KEY (post_id) REFERENCES stu_kn (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_F18967DDA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 694 | SQL); |
||
| 695 | $this->addSql(<<<'SQL' |
||
| 696 | CREATE INDEX kn_comment_post_idx ON stu_kn_comments (post_id) |
||
| 697 | SQL); |
||
| 698 | $this->addSql(<<<'SQL' |
||
| 699 | CREATE INDEX kn_comment_user_idx ON stu_kn_comments (user_id) |
||
| 700 | SQL); |
||
| 701 | $this->addSql(<<<'SQL' |
||
| 702 | CREATE TABLE stu_kn_comments_archiv (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, version VARCHAR(255) NOT NULL, former_id INTEGER NOT NULL, post_id INTEGER NOT NULL, user_id INTEGER NOT NULL, username VARCHAR(255) NOT NULL, text VARCHAR(255) NOT NULL, date INTEGER NOT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_378C11A44B89032C FOREIGN KEY (post_id) REFERENCES stu_kn_archiv (former_id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 703 | SQL); |
||
| 704 | $this->addSql(<<<'SQL' |
||
| 705 | CREATE INDEX IDX_378C11A44B89032C ON stu_kn_comments_archiv (post_id) |
||
| 706 | SQL); |
||
| 707 | $this->addSql(<<<'SQL' |
||
| 708 | CREATE UNIQUE INDEX unique_comments_former_id ON stu_kn_comments_archiv (former_id) |
||
| 709 | SQL); |
||
| 710 | $this->addSql(<<<'SQL' |
||
| 711 | CREATE TABLE stu_kn_plot_application (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, post_id INTEGER NOT NULL, plot_id INTEGER NOT NULL, time INTEGER NOT NULL, CONSTRAINT FK_F342AF3C4B89032C FOREIGN KEY (post_id) REFERENCES stu_kn (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_F342AF3C680D0B01 FOREIGN KEY (plot_id) REFERENCES stu_plots (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 712 | SQL); |
||
| 713 | $this->addSql(<<<'SQL' |
||
| 714 | CREATE INDEX IDX_F342AF3C4B89032C ON stu_kn_plot_application (post_id) |
||
| 715 | SQL); |
||
| 716 | $this->addSql(<<<'SQL' |
||
| 717 | CREATE INDEX IDX_F342AF3C680D0B01 ON stu_kn_plot_application (plot_id) |
||
| 718 | SQL); |
||
| 719 | $this->addSql(<<<'SQL' |
||
| 720 | CREATE TABLE stu_layer (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, width INTEGER NOT NULL, height INTEGER NOT NULL, is_hidden BOOLEAN NOT NULL, is_finished BOOLEAN DEFAULT NULL, is_encoded BOOLEAN DEFAULT NULL, award_id INTEGER DEFAULT NULL, CONSTRAINT FK_664CE77D3D5282CF FOREIGN KEY (award_id) REFERENCES stu_award (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 721 | SQL); |
||
| 722 | $this->addSql(<<<'SQL' |
||
| 723 | CREATE INDEX IDX_664CE77D3D5282CF ON stu_layer (award_id) |
||
| 724 | SQL); |
||
| 725 | $this->addSql(<<<'SQL' |
||
| 726 | CREATE TABLE stu_location (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, layer_id INTEGER DEFAULT NULL, cx INTEGER DEFAULT NULL, cy INTEGER DEFAULT NULL, field_id INTEGER NOT NULL, discr VARCHAR(255) NOT NULL, CONSTRAINT FK_E0CD22C3EA6EFDCD FOREIGN KEY (layer_id) REFERENCES stu_layer (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E0CD22C3443707B0 FOREIGN KEY (field_id) REFERENCES stu_map_ftypes (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 727 | SQL); |
||
| 728 | $this->addSql(<<<'SQL' |
||
| 729 | CREATE INDEX IDX_E0CD22C3EA6EFDCD ON stu_location (layer_id) |
||
| 730 | SQL); |
||
| 731 | $this->addSql(<<<'SQL' |
||
| 732 | CREATE INDEX location_coords_idx ON stu_location (layer_id, cx, cy) |
||
| 733 | SQL); |
||
| 734 | $this->addSql(<<<'SQL' |
||
| 735 | CREATE INDEX location_coords_reverse_idx ON stu_location (layer_id, cy, cx) |
||
| 736 | SQL); |
||
| 737 | $this->addSql(<<<'SQL' |
||
| 738 | CREATE INDEX location_field_type_idx ON stu_location (field_id) |
||
| 739 | SQL); |
||
| 740 | $this->addSql(<<<'SQL' |
||
| 741 | CREATE TABLE stu_location_mining (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, location_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, actual_amount INTEGER NOT NULL, max_amount INTEGER NOT NULL, depleted_at INTEGER DEFAULT NULL, CONSTRAINT FK_AC85C1AC64D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AC85C1ACB4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 742 | SQL); |
||
| 743 | $this->addSql(<<<'SQL' |
||
| 744 | CREATE INDEX IDX_AC85C1AC64D218E ON stu_location_mining (location_id) |
||
| 745 | SQL); |
||
| 746 | $this->addSql(<<<'SQL' |
||
| 747 | CREATE INDEX IDX_AC85C1ACB4ACC212 ON stu_location_mining (commodity_id) |
||
| 748 | SQL); |
||
| 749 | $this->addSql(<<<'SQL' |
||
| 750 | CREATE TABLE stu_lottery_buildplan (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, buildplan_id INTEGER NOT NULL, chance INTEGER NOT NULL, faction_id INTEGER DEFAULT NULL, CONSTRAINT FK_E8141D9B8638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 751 | SQL); |
||
| 752 | $this->addSql(<<<'SQL' |
||
| 753 | CREATE INDEX IDX_E8141D9B8638E4E7 ON stu_lottery_buildplan (buildplan_id) |
||
| 754 | SQL); |
||
| 755 | $this->addSql(<<<'SQL' |
||
| 756 | CREATE TABLE stu_lottery_ticket (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, period VARCHAR(255) NOT NULL, is_winner BOOLEAN DEFAULT NULL, CONSTRAINT FK_6300976CA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 757 | SQL); |
||
| 758 | $this->addSql(<<<'SQL' |
||
| 759 | CREATE INDEX IDX_6300976CA76ED395 ON stu_lottery_ticket (user_id) |
||
| 760 | SQL); |
||
| 761 | $this->addSql(<<<'SQL' |
||
| 762 | CREATE INDEX lottery_ticket_period_idx ON stu_lottery_ticket (period) |
||
| 763 | SQL); |
||
| 764 | $this->addSql(<<<'SQL' |
||
| 765 | CREATE TABLE stu_map (system_type_id INTEGER DEFAULT NULL, systems_id INTEGER DEFAULT NULL, influence_area_id INTEGER DEFAULT NULL, bordertype_id INTEGER DEFAULT NULL, region_id INTEGER DEFAULT NULL, admin_region_id INTEGER DEFAULT NULL, id INTEGER NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_1EEF59FD411D7F6D FOREIGN KEY (systems_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FD915ABAF6 FOREIGN KEY (influence_area_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FD293FF000 FOREIGN KEY (system_type_id) REFERENCES stu_system_types (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FDE5FE943D FOREIGN KEY (bordertype_id) REFERENCES stu_map_bordertypes (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FD98260155 FOREIGN KEY (region_id) REFERENCES stu_map_regions (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FD71D10467 FOREIGN KEY (admin_region_id) REFERENCES stu_map_regions (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1EEF59FDBF396750 FOREIGN KEY (id) REFERENCES stu_location (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 766 | SQL); |
||
| 767 | $this->addSql(<<<'SQL' |
||
| 768 | CREATE UNIQUE INDEX UNIQ_1EEF59FD411D7F6D ON stu_map (systems_id) |
||
| 769 | SQL); |
||
| 770 | $this->addSql(<<<'SQL' |
||
| 771 | CREATE INDEX IDX_1EEF59FD98260155 ON stu_map (region_id) |
||
| 772 | SQL); |
||
| 773 | $this->addSql(<<<'SQL' |
||
| 774 | CREATE INDEX map_system_idx ON stu_map (systems_id) |
||
| 775 | SQL); |
||
| 776 | $this->addSql(<<<'SQL' |
||
| 777 | CREATE INDEX map_system_type_idx ON stu_map (system_type_id) |
||
| 778 | SQL); |
||
| 779 | $this->addSql(<<<'SQL' |
||
| 780 | CREATE INDEX map_influence_area_idx ON stu_map (influence_area_id) |
||
| 781 | SQL); |
||
| 782 | $this->addSql(<<<'SQL' |
||
| 783 | CREATE INDEX map_bordertype_idx ON stu_map (bordertype_id) |
||
| 784 | SQL); |
||
| 785 | $this->addSql(<<<'SQL' |
||
| 786 | CREATE INDEX map_admin_region_idx ON stu_map (admin_region_id) |
||
| 787 | SQL); |
||
| 788 | $this->addSql(<<<'SQL' |
||
| 789 | CREATE TABLE stu_map_bordertypes (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, faction_id INTEGER NOT NULL, color VARCHAR(255) NOT NULL, description VARCHAR(255) NOT NULL) |
||
| 790 | SQL); |
||
| 791 | $this->addSql(<<<'SQL' |
||
| 792 | CREATE TABLE stu_map_ftypes (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type INTEGER NOT NULL, is_system BOOLEAN NOT NULL, ecost SMALLINT NOT NULL, name VARCHAR(255) NOT NULL, colonies_classes_id INTEGER DEFAULT NULL, damage SMALLINT NOT NULL, x_damage SMALLINT NOT NULL, x_damage_system SMALLINT DEFAULT NULL, x_damage_type SMALLINT DEFAULT NULL, "view" BOOLEAN NOT NULL, passable BOOLEAN NOT NULL, complementary_color VARCHAR(255) DEFAULT NULL, effects CLOB DEFAULT NULL, CONSTRAINT FK_3D24A6CE9106126 FOREIGN KEY (colonies_classes_id) REFERENCES stu_colonies_classes (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 793 | SQL); |
||
| 794 | $this->addSql(<<<'SQL' |
||
| 795 | CREATE INDEX IDX_3D24A6CE9106126 ON stu_map_ftypes (colonies_classes_id) |
||
| 796 | SQL); |
||
| 797 | $this->addSql(<<<'SQL' |
||
| 798 | CREATE INDEX map_ftypes_type_idx ON stu_map_ftypes (type) |
||
| 799 | SQL); |
||
| 800 | $this->addSql(<<<'SQL' |
||
| 801 | CREATE TABLE stu_map_regions (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, database_id INTEGER DEFAULT NULL, layers VARCHAR(255) DEFAULT NULL, CONSTRAINT FK_3CCEB5C5F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 802 | SQL); |
||
| 803 | $this->addSql(<<<'SQL' |
||
| 804 | CREATE INDEX IDX_3CCEB5C5F0AA09DB ON stu_map_regions (database_id) |
||
| 805 | SQL); |
||
| 806 | $this->addSql(<<<'SQL' |
||
| 807 | CREATE TABLE stu_map_regions_settlement (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, region_id INTEGER NOT NULL, faction_id INTEGER NOT NULL) |
||
| 808 | SQL); |
||
| 809 | $this->addSql(<<<'SQL' |
||
| 810 | CREATE TABLE stu_mass_center_type (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, size INTEGER NOT NULL, first_field_type_id INTEGER NOT NULL, CONSTRAINT FK_81F0ECD2AC15FEB7 FOREIGN KEY (first_field_type_id) REFERENCES stu_map_ftypes (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 811 | SQL); |
||
| 812 | $this->addSql(<<<'SQL' |
||
| 813 | CREATE UNIQUE INDEX UNIQ_81F0ECD2AC15FEB7 ON stu_mass_center_type (first_field_type_id) |
||
| 814 | SQL); |
||
| 815 | $this->addSql(<<<'SQL' |
||
| 816 | CREATE INDEX mass_center_field_type_idx ON stu_mass_center_type (first_field_type_id) |
||
| 817 | SQL); |
||
| 818 | $this->addSql(<<<'SQL' |
||
| 819 | CREATE TABLE stu_mining_queue (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ship_id INTEGER NOT NULL, location_mining_id INTEGER NOT NULL, CONSTRAINT FK_BBFEF8C427D56C25 FOREIGN KEY (location_mining_id) REFERENCES stu_location_mining (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_BBFEF8C4C256317D FOREIGN KEY (ship_id) REFERENCES stu_ship (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 820 | SQL); |
||
| 821 | $this->addSql(<<<'SQL' |
||
| 822 | CREATE INDEX IDX_BBFEF8C427D56C25 ON stu_mining_queue (location_mining_id) |
||
| 823 | SQL); |
||
| 824 | $this->addSql(<<<'SQL' |
||
| 825 | CREATE UNIQUE INDEX UNIQ_BBFEF8C4C256317D ON stu_mining_queue (ship_id) |
||
| 826 | SQL); |
||
| 827 | $this->addSql(<<<'SQL' |
||
| 828 | CREATE TABLE stu_modules (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, level SMALLINT NOT NULL, upgrade_factor SMALLINT NOT NULL, default_factor SMALLINT NOT NULL, downgrade_factor SMALLINT NOT NULL, crew SMALLINT NOT NULL, type INTEGER NOT NULL, research_id INTEGER DEFAULT NULL, commodity_id INTEGER NOT NULL, viewable BOOLEAN NOT NULL, rumps_role_id INTEGER DEFAULT NULL, ecost SMALLINT NOT NULL, faction_id INTEGER DEFAULT NULL, system_type INTEGER DEFAULT NULL, CONSTRAINT FK_760C5BA57909E1ED FOREIGN KEY (research_id) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_760C5BA5B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_760C5BA54448F8DA FOREIGN KEY (faction_id) REFERENCES stu_factions (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_760C5BA5A7BC4A6 FOREIGN KEY (rumps_role_id) REFERENCES stu_rumps_roles (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 829 | SQL); |
||
| 830 | $this->addSql(<<<'SQL' |
||
| 831 | CREATE INDEX IDX_760C5BA57909E1ED ON stu_modules (research_id) |
||
| 832 | SQL); |
||
| 833 | $this->addSql(<<<'SQL' |
||
| 834 | CREATE INDEX IDX_760C5BA5B4ACC212 ON stu_modules (commodity_id) |
||
| 835 | SQL); |
||
| 836 | $this->addSql(<<<'SQL' |
||
| 837 | CREATE INDEX IDX_760C5BA54448F8DA ON stu_modules (faction_id) |
||
| 838 | SQL); |
||
| 839 | $this->addSql(<<<'SQL' |
||
| 840 | CREATE INDEX IDX_760C5BA5A7BC4A6 ON stu_modules (rumps_role_id) |
||
| 841 | SQL); |
||
| 842 | $this->addSql(<<<'SQL' |
||
| 843 | CREATE INDEX ship_rump_role_type_idx ON stu_modules (rumps_role_id, type) |
||
| 844 | SQL); |
||
| 845 | $this->addSql(<<<'SQL' |
||
| 846 | CREATE TABLE stu_modules_buildingfunction (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module_id INTEGER NOT NULL, buildingfunction INTEGER NOT NULL, CONSTRAINT FK_85B4A88EAFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 847 | SQL); |
||
| 848 | $this->addSql(<<<'SQL' |
||
| 849 | CREATE INDEX IDX_85B4A88EAFC2B591 ON stu_modules_buildingfunction (module_id) |
||
| 850 | SQL); |
||
| 851 | $this->addSql(<<<'SQL' |
||
| 852 | CREATE INDEX module_buildingfunction_idx ON stu_modules_buildingfunction (module_id, buildingfunction) |
||
| 853 | SQL); |
||
| 854 | $this->addSql(<<<'SQL' |
||
| 855 | CREATE TABLE stu_modules_cost (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_91B75BB6B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_91B75BB6AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 856 | SQL); |
||
| 857 | $this->addSql(<<<'SQL' |
||
| 858 | CREATE INDEX IDX_91B75BB6B4ACC212 ON stu_modules_cost (commodity_id) |
||
| 859 | SQL); |
||
| 860 | $this->addSql(<<<'SQL' |
||
| 861 | CREATE INDEX module_cost_module_idx ON stu_modules_cost (module_id) |
||
| 862 | SQL); |
||
| 863 | $this->addSql(<<<'SQL' |
||
| 864 | CREATE TABLE stu_modules_queue (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, colony_id INTEGER NOT NULL, module_id INTEGER NOT NULL, count INTEGER NOT NULL, buildingfunction INTEGER NOT NULL, CONSTRAINT FK_E97D4622AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E97D462296ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 865 | SQL); |
||
| 866 | $this->addSql(<<<'SQL' |
||
| 867 | CREATE INDEX IDX_E97D4622AFC2B591 ON stu_modules_queue (module_id) |
||
| 868 | SQL); |
||
| 869 | $this->addSql(<<<'SQL' |
||
| 870 | CREATE INDEX IDX_E97D462296ADBADE ON stu_modules_queue (colony_id) |
||
| 871 | SQL); |
||
| 872 | $this->addSql(<<<'SQL' |
||
| 873 | CREATE INDEX module_queue_colony_module_idx ON stu_modules_queue (colony_id, module_id) |
||
| 874 | SQL); |
||
| 875 | $this->addSql(<<<'SQL' |
||
| 876 | CREATE TABLE stu_modules_specials (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module_id INTEGER NOT NULL, special_id SMALLINT NOT NULL, CONSTRAINT FK_B025FE0DAFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 877 | SQL); |
||
| 878 | $this->addSql(<<<'SQL' |
||
| 879 | CREATE INDEX module_special_module_idx ON stu_modules_specials (module_id) |
||
| 880 | SQL); |
||
| 881 | $this->addSql(<<<'SQL' |
||
| 882 | CREATE TABLE stu_names (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, count INTEGER DEFAULT NULL, type INTEGER NOT NULL) |
||
| 883 | SQL); |
||
| 884 | $this->addSql(<<<'SQL' |
||
| 885 | CREATE TABLE stu_news (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, subject VARCHAR(255) NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, refs CLOB NOT NULL) |
||
| 886 | SQL); |
||
| 887 | $this->addSql(<<<'SQL' |
||
| 888 | CREATE INDEX news_date_idx ON stu_news (date) |
||
| 889 | SQL); |
||
| 890 | $this->addSql(<<<'SQL' |
||
| 891 | CREATE TABLE stu_notes (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, date INTEGER NOT NULL, title VARCHAR(255) NOT NULL, text CLOB NOT NULL, CONSTRAINT FK_838C60EBA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 892 | SQL); |
||
| 893 | $this->addSql(<<<'SQL' |
||
| 894 | CREATE INDEX note_user_idx ON stu_notes (user_id) |
||
| 895 | SQL); |
||
| 896 | $this->addSql(<<<'SQL' |
||
| 897 | CREATE TABLE stu_npc_log (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, source_user_id INTEGER DEFAULT NULL) |
||
| 898 | SQL); |
||
| 899 | $this->addSql(<<<'SQL' |
||
| 900 | CREATE TABLE stu_opened_advent_door (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, day INTEGER NOT NULL, year INTEGER NOT NULL, time INTEGER NOT NULL) |
||
| 901 | SQL); |
||
| 902 | $this->addSql(<<<'SQL' |
||
| 903 | CREATE TABLE stu_partnersite (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, url VARCHAR(255) NOT NULL, text CLOB NOT NULL, banner VARCHAR(200) NOT NULL) |
||
| 904 | SQL); |
||
| 905 | $this->addSql(<<<'SQL' |
||
| 906 | CREATE TABLE stu_pirate_setup (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(200) NOT NULL, probability_weight INTEGER NOT NULL) |
||
| 907 | SQL); |
||
| 908 | $this->addSql(<<<'SQL' |
||
| 909 | CREATE TABLE stu_pirate_setup_buildplan (pirate_setup_id INTEGER NOT NULL, buildplan_id INTEGER NOT NULL, amount INTEGER NOT NULL, PRIMARY KEY(pirate_setup_id, buildplan_id), CONSTRAINT FK_A99F4154E66A498F FOREIGN KEY (pirate_setup_id) REFERENCES stu_pirate_setup (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A99F41548638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 910 | SQL); |
||
| 911 | $this->addSql(<<<'SQL' |
||
| 912 | CREATE INDEX IDX_A99F4154E66A498F ON stu_pirate_setup_buildplan (pirate_setup_id) |
||
| 913 | SQL); |
||
| 914 | $this->addSql(<<<'SQL' |
||
| 915 | CREATE INDEX IDX_A99F41548638E4E7 ON stu_pirate_setup_buildplan (buildplan_id) |
||
| 916 | SQL); |
||
| 917 | $this->addSql(<<<'SQL' |
||
| 918 | CREATE TABLE stu_pirate_wrath (user_id INTEGER NOT NULL, wrath INTEGER NOT NULL, protection_timeout INTEGER DEFAULT NULL, PRIMARY KEY(user_id), CONSTRAINT FK_A7D3C35BA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 919 | SQL); |
||
| 920 | $this->addSql(<<<'SQL' |
||
| 921 | CREATE TABLE stu_planet_type_research (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, research_id INTEGER NOT NULL, planet_type_id INTEGER NOT NULL, CONSTRAINT FK_5C1857F87909E1ED FOREIGN KEY (research_id) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_5C1857F8506FDB14 FOREIGN KEY (planet_type_id) REFERENCES stu_colonies_classes (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 922 | SQL); |
||
| 923 | $this->addSql(<<<'SQL' |
||
| 924 | CREATE INDEX IDX_5C1857F87909E1ED ON stu_planet_type_research (research_id) |
||
| 925 | SQL); |
||
| 926 | $this->addSql(<<<'SQL' |
||
| 927 | CREATE INDEX planet_type_idx ON stu_planet_type_research (planet_type_id) |
||
| 928 | SQL); |
||
| 929 | $this->addSql(<<<'SQL' |
||
| 930 | CREATE TABLE stu_planets_commodity (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, planet_classes_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count SMALLINT NOT NULL) |
||
| 931 | SQL); |
||
| 932 | $this->addSql(<<<'SQL' |
||
| 933 | CREATE INDEX planet_classes_idx ON stu_planets_commodity (planet_classes_id) |
||
| 934 | SQL); |
||
| 935 | $this->addSql(<<<'SQL' |
||
| 936 | CREATE TABLE stu_plots (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, title VARCHAR(255) NOT NULL, description CLOB NOT NULL, start_date INTEGER NOT NULL, end_date INTEGER DEFAULT NULL, CONSTRAINT FK_D438967A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 937 | SQL); |
||
| 938 | $this->addSql(<<<'SQL' |
||
| 939 | CREATE INDEX rpg_plot_end_date_idx ON stu_plots (end_date) |
||
| 940 | SQL); |
||
| 941 | $this->addSql(<<<'SQL' |
||
| 942 | CREATE INDEX rpg_plot_user_idx ON stu_plots (user_id) |
||
| 943 | SQL); |
||
| 944 | $this->addSql(<<<'SQL' |
||
| 945 | CREATE TABLE stu_plots_archiv (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, version VARCHAR(255) NOT NULL, former_id INTEGER NOT NULL, user_id INTEGER NOT NULL, title VARCHAR(255) NOT NULL, description CLOB NOT NULL, start_date INTEGER NOT NULL, end_date INTEGER DEFAULT NULL) |
||
| 946 | SQL); |
||
| 947 | $this->addSql(<<<'SQL' |
||
| 948 | CREATE INDEX rpg_plot_archiv_end_date_idx ON stu_plots_archiv (end_date) |
||
| 949 | SQL); |
||
| 950 | $this->addSql(<<<'SQL' |
||
| 951 | CREATE UNIQUE INDEX unique_plot_id ON stu_plots_archiv (id) |
||
| 952 | SQL); |
||
| 953 | $this->addSql(<<<'SQL' |
||
| 954 | CREATE UNIQUE INDEX unique_former_id ON stu_plots_archiv (former_id) |
||
| 955 | SQL); |
||
| 956 | $this->addSql(<<<'SQL' |
||
| 957 | CREATE TABLE stu_plots_members (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, plot_id INTEGER NOT NULL, user_id INTEGER NOT NULL, CONSTRAINT FK_87148972680D0B01 FOREIGN KEY (plot_id) REFERENCES stu_plots (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_87148972A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 958 | SQL); |
||
| 959 | $this->addSql(<<<'SQL' |
||
| 960 | CREATE INDEX IDX_87148972680D0B01 ON stu_plots_members (plot_id) |
||
| 961 | SQL); |
||
| 962 | $this->addSql(<<<'SQL' |
||
| 963 | CREATE INDEX IDX_87148972A76ED395 ON stu_plots_members (user_id) |
||
| 964 | SQL); |
||
| 965 | $this->addSql(<<<'SQL' |
||
| 966 | CREATE UNIQUE INDEX plot_user_idx ON stu_plots_members (plot_id, user_id) |
||
| 967 | SQL); |
||
| 968 | $this->addSql(<<<'SQL' |
||
| 969 | CREATE TABLE stu_plots_members_archiv (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, version VARCHAR(255) NOT NULL, former_id INTEGER NOT NULL, plot_id INTEGER NOT NULL, user_id INTEGER NOT NULL, CONSTRAINT FK_CDE3D430680D0B01 FOREIGN KEY (plot_id) REFERENCES stu_plots_archiv (former_id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 970 | SQL); |
||
| 971 | $this->addSql(<<<'SQL' |
||
| 972 | CREATE INDEX IDX_CDE3D430680D0B01 ON stu_plots_members_archiv (plot_id) |
||
| 973 | SQL); |
||
| 974 | $this->addSql(<<<'SQL' |
||
| 975 | CREATE UNIQUE INDEX plot_archiv_user_idx ON stu_plots_members_archiv (plot_id, user_id) |
||
| 976 | SQL); |
||
| 977 | $this->addSql(<<<'SQL' |
||
| 978 | CREATE TABLE stu_pm_cats (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, description VARCHAR(255) NOT NULL, sort SMALLINT NOT NULL, special SMALLINT NOT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_C54F3637A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 979 | SQL); |
||
| 980 | $this->addSql(<<<'SQL' |
||
| 981 | CREATE INDEX IDX_C54F3637A76ED395 ON stu_pm_cats (user_id) |
||
| 982 | SQL); |
||
| 983 | $this->addSql(<<<'SQL' |
||
| 984 | CREATE INDEX user_special_idx ON stu_pm_cats (user_id, special) |
||
| 985 | SQL); |
||
| 986 | $this->addSql(<<<'SQL' |
||
| 987 | CREATE TABLE stu_pms (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, send_user INTEGER NOT NULL, recip_user INTEGER NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, new BOOLEAN NOT NULL, cat_id INTEGER NOT NULL, inbox_pm_id INTEGER DEFAULT NULL, href VARCHAR(255) DEFAULT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_3FAD7768E6ADA943 FOREIGN KEY (cat_id) REFERENCES stu_pm_cats (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3FAD7768E9546EDA FOREIGN KEY (send_user) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3FAD77685A3E0BD8 FOREIGN KEY (recip_user) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3FAD77687FAFC1FA FOREIGN KEY (inbox_pm_id) REFERENCES stu_pms (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 988 | SQL); |
||
| 989 | $this->addSql(<<<'SQL' |
||
| 990 | CREATE INDEX IDX_3FAD7768E6ADA943 ON stu_pms (cat_id) |
||
| 991 | SQL); |
||
| 992 | $this->addSql(<<<'SQL' |
||
| 993 | CREATE INDEX IDX_3FAD7768E9546EDA ON stu_pms (send_user) |
||
| 994 | SQL); |
||
| 995 | $this->addSql(<<<'SQL' |
||
| 996 | CREATE INDEX IDX_3FAD77685A3E0BD8 ON stu_pms (recip_user) |
||
| 997 | SQL); |
||
| 998 | $this->addSql(<<<'SQL' |
||
| 999 | CREATE UNIQUE INDEX UNIQ_3FAD77687FAFC1FA ON stu_pms (inbox_pm_id) |
||
| 1000 | SQL); |
||
| 1001 | $this->addSql(<<<'SQL' |
||
| 1002 | CREATE INDEX recipient_folder_idx ON stu_pms (recip_user, cat_id) |
||
| 1003 | SQL); |
||
| 1004 | $this->addSql(<<<'SQL' |
||
| 1005 | CREATE INDEX correspondence ON stu_pms (recip_user, send_user) |
||
| 1006 | SQL); |
||
| 1007 | $this->addSql(<<<'SQL' |
||
| 1008 | CREATE INDEX pm_date_idx ON stu_pms (date) |
||
| 1009 | SQL); |
||
| 1010 | $this->addSql(<<<'SQL' |
||
| 1011 | CREATE TABLE stu_prestige_log (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, amount INTEGER NOT NULL, description CLOB NOT NULL, date INTEGER NOT NULL) |
||
| 1012 | SQL); |
||
| 1013 | $this->addSql(<<<'SQL' |
||
| 1014 | CREATE INDEX prestige_log_user_idx ON stu_prestige_log (user_id) |
||
| 1015 | SQL); |
||
| 1016 | $this->addSql(<<<'SQL' |
||
| 1017 | CREATE TABLE stu_progress_module (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, progress_id INTEGER NOT NULL, module_id INTEGER NOT NULL, CONSTRAINT FK_7FE7540743DB87C9 FOREIGN KEY (progress_id) REFERENCES stu_construction_progress (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7FE75407AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1018 | SQL); |
||
| 1019 | $this->addSql(<<<'SQL' |
||
| 1020 | CREATE INDEX IDX_7FE7540743DB87C9 ON stu_progress_module (progress_id) |
||
| 1021 | SQL); |
||
| 1022 | $this->addSql(<<<'SQL' |
||
| 1023 | CREATE INDEX IDX_7FE75407AFC2B591 ON stu_progress_module (module_id) |
||
| 1024 | SQL); |
||
| 1025 | $this->addSql(<<<'SQL' |
||
| 1026 | CREATE TABLE stu_repair_task (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, spacecraft_id INTEGER NOT NULL, finish_time INTEGER NOT NULL, system_type INTEGER NOT NULL, healing_percentage INTEGER NOT NULL, CONSTRAINT FK_36DA3BAFA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_36DA3BAF1C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1027 | SQL); |
||
| 1028 | $this->addSql(<<<'SQL' |
||
| 1029 | CREATE INDEX IDX_36DA3BAFA76ED395 ON stu_repair_task (user_id) |
||
| 1030 | SQL); |
||
| 1031 | $this->addSql(<<<'SQL' |
||
| 1032 | CREATE INDEX IDX_36DA3BAF1C6AF6FD ON stu_repair_task (spacecraft_id) |
||
| 1033 | SQL); |
||
| 1034 | $this->addSql(<<<'SQL' |
||
| 1035 | CREATE TABLE stu_research (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description CLOB NOT NULL, sort SMALLINT NOT NULL, rump_id INTEGER NOT NULL, database_entries CLOB NOT NULL, points SMALLINT NOT NULL, commodity_id INTEGER NOT NULL, reward_buildplan_id INTEGER DEFAULT NULL, award_id INTEGER DEFAULT NULL, needed_award INTEGER DEFAULT NULL, upper_limit_colony_type SMALLINT DEFAULT NULL, upper_limit_colony_amount SMALLINT DEFAULT NULL, CONSTRAINT FK_E9B8FBCAB4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E9B8FBCAEEF0C2F2 FOREIGN KEY (reward_buildplan_id) REFERENCES stu_buildplan (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E9B8FBCA3D5282CF FOREIGN KEY (award_id) REFERENCES stu_award (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1036 | SQL); |
||
| 1037 | $this->addSql(<<<'SQL' |
||
| 1038 | CREATE INDEX IDX_E9B8FBCAB4ACC212 ON stu_research (commodity_id) |
||
| 1039 | SQL); |
||
| 1040 | $this->addSql(<<<'SQL' |
||
| 1041 | CREATE INDEX IDX_E9B8FBCAEEF0C2F2 ON stu_research (reward_buildplan_id) |
||
| 1042 | SQL); |
||
| 1043 | $this->addSql(<<<'SQL' |
||
| 1044 | CREATE INDEX IDX_E9B8FBCA3D5282CF ON stu_research (award_id) |
||
| 1045 | SQL); |
||
| 1046 | $this->addSql(<<<'SQL' |
||
| 1047 | CREATE TABLE stu_research_dependencies (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, research_id INTEGER NOT NULL, depends_on INTEGER NOT NULL, mode SMALLINT NOT NULL, CONSTRAINT FK_8C4C33D97909E1ED FOREIGN KEY (research_id) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_8C4C33D950E5182A FOREIGN KEY (depends_on) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1048 | SQL); |
||
| 1049 | $this->addSql(<<<'SQL' |
||
| 1050 | CREATE INDEX IDX_8C4C33D97909E1ED ON stu_research_dependencies (research_id) |
||
| 1051 | SQL); |
||
| 1052 | $this->addSql(<<<'SQL' |
||
| 1053 | CREATE INDEX IDX_8C4C33D950E5182A ON stu_research_dependencies (depends_on) |
||
| 1054 | SQL); |
||
| 1055 | $this->addSql(<<<'SQL' |
||
| 1056 | CREATE TABLE stu_researched (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, research_id INTEGER NOT NULL, user_id INTEGER NOT NULL, aktiv INTEGER NOT NULL, finished INTEGER NOT NULL, CONSTRAINT FK_8F6D5B47909E1ED FOREIGN KEY (research_id) REFERENCES stu_research (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_8F6D5B4A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1057 | SQL); |
||
| 1058 | $this->addSql(<<<'SQL' |
||
| 1059 | CREATE INDEX IDX_8F6D5B47909E1ED ON stu_researched (research_id) |
||
| 1060 | SQL); |
||
| 1061 | $this->addSql(<<<'SQL' |
||
| 1062 | CREATE INDEX IDX_8F6D5B4A76ED395 ON stu_researched (user_id) |
||
| 1063 | SQL); |
||
| 1064 | $this->addSql(<<<'SQL' |
||
| 1065 | CREATE TABLE stu_rump (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, category_id INTEGER NOT NULL, role_id INTEGER DEFAULT NULL, evade_chance SMALLINT NOT NULL, hit_chance SMALLINT NOT NULL, module_level SMALLINT NOT NULL, base_crew SMALLINT NOT NULL, base_eps SMALLINT NOT NULL, base_reactor SMALLINT NOT NULL, base_hull INTEGER NOT NULL, base_shield INTEGER NOT NULL, base_damage SMALLINT NOT NULL, base_sensor_range SMALLINT NOT NULL, base_torpedo_storage SMALLINT NOT NULL, phaser_volleys SMALLINT NOT NULL, phaser_hull_damage_factor SMALLINT NOT NULL, phaser_shield_damage_factor SMALLINT NOT NULL, torpedo_level SMALLINT NOT NULL, torpedo_volleys SMALLINT NOT NULL, name VARCHAR(255) NOT NULL, is_buildable BOOLEAN NOT NULL, is_npc BOOLEAN NOT NULL, eps_cost SMALLINT NOT NULL, storage INTEGER NOT NULL, slots SMALLINT NOT NULL, buildtime INTEGER NOT NULL, needed_workbees SMALLINT DEFAULT NULL, sort SMALLINT NOT NULL, database_id INTEGER DEFAULT NULL, commodity_id INTEGER DEFAULT NULL, flight_ecost SMALLINT NOT NULL, beam_factor SMALLINT NOT NULL, special_slots SMALLINT NOT NULL, shuttle_slots SMALLINT NOT NULL, tractor_mass INTEGER NOT NULL, tractor_payload INTEGER NOT NULL, prestige INTEGER NOT NULL, base_warpdrive INTEGER NOT NULL, npc_buildable BOOLEAN DEFAULT NULL, CONSTRAINT FK_AD2CDF30D60322AC FOREIGN KEY (role_id) REFERENCES stu_rumps_roles (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AD2CDF3012469DE2 FOREIGN KEY (category_id) REFERENCES stu_rumps_categories (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AD2CDF30B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AD2CDF30F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1066 | SQL); |
||
| 1067 | $this->addSql(<<<'SQL' |
||
| 1068 | CREATE INDEX IDX_AD2CDF30B4ACC212 ON stu_rump (commodity_id) |
||
| 1069 | SQL); |
||
| 1070 | $this->addSql(<<<'SQL' |
||
| 1071 | CREATE INDEX IDX_AD2CDF30F0AA09DB ON stu_rump (database_id) |
||
| 1072 | SQL); |
||
| 1073 | $this->addSql(<<<'SQL' |
||
| 1074 | CREATE INDEX rump_category_idx ON stu_rump (category_id) |
||
| 1075 | SQL); |
||
| 1076 | $this->addSql(<<<'SQL' |
||
| 1077 | CREATE INDEX rump_role_idx ON stu_rump (role_id) |
||
| 1078 | SQL); |
||
| 1079 | $this->addSql(<<<'SQL' |
||
| 1080 | CREATE TABLE stu_rump_costs (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_11BE8AA4B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_11BE8AA42EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1081 | SQL); |
||
| 1082 | $this->addSql(<<<'SQL' |
||
| 1083 | CREATE INDEX IDX_11BE8AA4B4ACC212 ON stu_rump_costs (commodity_id) |
||
| 1084 | SQL); |
||
| 1085 | $this->addSql(<<<'SQL' |
||
| 1086 | CREATE INDEX rump_cost_ship_rump_idx ON stu_rump_costs (rump_id) |
||
| 1087 | SQL); |
||
| 1088 | $this->addSql(<<<'SQL' |
||
| 1089 | CREATE TABLE stu_rumps_buildingfunction (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, building_function INTEGER NOT NULL) |
||
| 1090 | SQL); |
||
| 1091 | $this->addSql(<<<'SQL' |
||
| 1092 | CREATE INDEX building_function_ship_rump_idx ON stu_rumps_buildingfunction (rump_id) |
||
| 1093 | SQL); |
||
| 1094 | $this->addSql(<<<'SQL' |
||
| 1095 | CREATE INDEX building_function_idx ON stu_rumps_buildingfunction (building_function) |
||
| 1096 | SQL); |
||
| 1097 | $this->addSql(<<<'SQL' |
||
| 1098 | CREATE TABLE stu_rumps_cat_role_crew (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_category_id INTEGER NOT NULL, rump_role_id INTEGER NOT NULL, job_1_crew SMALLINT NOT NULL, job_2_crew SMALLINT NOT NULL, job_3_crew SMALLINT NOT NULL, job_4_crew SMALLINT NOT NULL, job_5_crew SMALLINT NOT NULL, job_6_crew SMALLINT NOT NULL, job_7_crew SMALLINT NOT NULL, CONSTRAINT FK_976EF6322F027718 FOREIGN KEY (rump_role_id) REFERENCES stu_rumps_roles (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1099 | SQL); |
||
| 1100 | $this->addSql(<<<'SQL' |
||
| 1101 | CREATE INDEX IDX_976EF6322F027718 ON stu_rumps_cat_role_crew (rump_role_id) |
||
| 1102 | SQL); |
||
| 1103 | $this->addSql(<<<'SQL' |
||
| 1104 | CREATE INDEX ship_rump_category_role_idx ON stu_rumps_cat_role_crew (rump_category_id, rump_role_id) |
||
| 1105 | SQL); |
||
| 1106 | $this->addSql(<<<'SQL' |
||
| 1107 | CREATE TABLE stu_rumps_categories (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, database_id INTEGER DEFAULT NULL, type VARCHAR(255) NOT NULL, CONSTRAINT FK_D23A3E0BF0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1108 | SQL); |
||
| 1109 | $this->addSql(<<<'SQL' |
||
| 1110 | CREATE INDEX IDX_D23A3E0BF0AA09DB ON stu_rumps_categories (database_id) |
||
| 1111 | SQL); |
||
| 1112 | $this->addSql(<<<'SQL' |
||
| 1113 | CREATE TABLE stu_rumps_colonize_building (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, building_id INTEGER NOT NULL) |
||
| 1114 | SQL); |
||
| 1115 | $this->addSql(<<<'SQL' |
||
| 1116 | CREATE INDEX rump_colonize_building_ship_rump_idx ON stu_rumps_colonize_building (rump_id) |
||
| 1117 | SQL); |
||
| 1118 | $this->addSql(<<<'SQL' |
||
| 1119 | CREATE TABLE stu_rumps_module_level (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, module_level_1 SMALLINT NOT NULL, module_mandatory_1 SMALLINT NOT NULL, module_level_1_min SMALLINT NOT NULL, module_level_1_max SMALLINT NOT NULL, module_level_2 SMALLINT NOT NULL, module_mandatory_2 SMALLINT NOT NULL, module_level_2_min SMALLINT NOT NULL, module_level_2_max SMALLINT NOT NULL, module_level_3 SMALLINT NOT NULL, module_mandatory_3 SMALLINT NOT NULL, module_level_3_min SMALLINT NOT NULL, module_level_3_max SMALLINT NOT NULL, module_level_4 SMALLINT NOT NULL, module_mandatory_4 SMALLINT NOT NULL, module_level_4_min SMALLINT NOT NULL, module_level_4_max SMALLINT NOT NULL, module_level_5 SMALLINT NOT NULL, module_mandatory_5 SMALLINT NOT NULL, module_level_5_min SMALLINT NOT NULL, module_level_5_max SMALLINT NOT NULL, module_level_6 SMALLINT NOT NULL, module_mandatory_6 SMALLINT NOT NULL, module_level_6_min SMALLINT NOT NULL, module_level_6_max SMALLINT NOT NULL, module_level_7 SMALLINT NOT NULL, module_mandatory_7 SMALLINT NOT NULL, module_level_7_min SMALLINT NOT NULL, module_level_7_max SMALLINT NOT NULL, module_level_8 SMALLINT NOT NULL, module_mandatory_8 SMALLINT NOT NULL, module_level_8_min SMALLINT NOT NULL, module_level_8_max SMALLINT NOT NULL, module_level_10 SMALLINT NOT NULL, module_mandatory_10 SMALLINT NOT NULL, module_level_10_min SMALLINT NOT NULL, module_level_10_max SMALLINT NOT NULL, module_level_11 SMALLINT NOT NULL, module_mandatory_11 SMALLINT NOT NULL, module_level_11_min SMALLINT NOT NULL, module_level_11_max SMALLINT NOT NULL) |
||
| 1120 | SQL); |
||
| 1121 | $this->addSql(<<<'SQL' |
||
| 1122 | CREATE INDEX rump_module_level_ship_rump_idx ON stu_rumps_module_level (rump_id) |
||
| 1123 | SQL); |
||
| 1124 | $this->addSql(<<<'SQL' |
||
| 1125 | CREATE TABLE stu_rumps_module_special (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, module_special_id INTEGER NOT NULL) |
||
| 1126 | SQL); |
||
| 1127 | $this->addSql(<<<'SQL' |
||
| 1128 | CREATE INDEX rump_module_special_ship_rump_idx ON stu_rumps_module_special (rump_id) |
||
| 1129 | SQL); |
||
| 1130 | $this->addSql(<<<'SQL' |
||
| 1131 | CREATE TABLE stu_rumps_roles (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL) |
||
| 1132 | SQL); |
||
| 1133 | $this->addSql(<<<'SQL' |
||
| 1134 | CREATE TABLE stu_rumps_specials (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, special INTEGER NOT NULL, CONSTRAINT FK_3F94D9B22EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1135 | SQL); |
||
| 1136 | $this->addSql(<<<'SQL' |
||
| 1137 | CREATE INDEX rump_special_ship_rump_idx ON stu_rumps_specials (rump_id) |
||
| 1138 | SQL); |
||
| 1139 | $this->addSql(<<<'SQL' |
||
| 1140 | CREATE TABLE stu_rumps_user (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rump_id INTEGER NOT NULL, user_id INTEGER NOT NULL, CONSTRAINT FK_1E7BBE13A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1141 | SQL); |
||
| 1142 | $this->addSql(<<<'SQL' |
||
| 1143 | CREATE INDEX IDX_1E7BBE13A76ED395 ON stu_rumps_user (user_id) |
||
| 1144 | SQL); |
||
| 1145 | $this->addSql(<<<'SQL' |
||
| 1146 | CREATE INDEX rump_user_idx ON stu_rumps_user (rump_id, user_id) |
||
| 1147 | SQL); |
||
| 1148 | $this->addSql(<<<'SQL' |
||
| 1149 | CREATE TABLE stu_session_strings (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, sess_string VARCHAR(255) NOT NULL, date DATETIME DEFAULT NULL, CONSTRAINT FK_6468CB57A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1150 | SQL); |
||
| 1151 | $this->addSql(<<<'SQL' |
||
| 1152 | CREATE INDEX IDX_6468CB57A76ED395 ON stu_session_strings (user_id) |
||
| 1153 | SQL); |
||
| 1154 | $this->addSql(<<<'SQL' |
||
| 1155 | CREATE INDEX session_string_user_idx ON stu_session_strings (sess_string, user_id) |
||
| 1156 | SQL); |
||
| 1157 | $this->addSql(<<<'SQL' |
||
| 1158 | CREATE INDEX session_string_date_idx ON stu_session_strings (date) |
||
| 1159 | SQL); |
||
| 1160 | $this->addSql(<<<'SQL' |
||
| 1161 | CREATE TABLE stu_ship (fleet_id INTEGER DEFAULT NULL, docked_to_id INTEGER DEFAULT NULL, is_fleet_leader BOOLEAN NOT NULL, id INTEGER NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_65024D724B061DF9 FOREIGN KEY (fleet_id) REFERENCES stu_fleets (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_65024D729B76929F FOREIGN KEY (docked_to_id) REFERENCES stu_station (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_65024D72BF396750 FOREIGN KEY (id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1162 | SQL); |
||
| 1163 | $this->addSql(<<<'SQL' |
||
| 1164 | CREATE INDEX IDX_65024D724B061DF9 ON stu_ship (fleet_id) |
||
| 1165 | SQL); |
||
| 1166 | $this->addSql(<<<'SQL' |
||
| 1167 | CREATE INDEX IDX_65024D729B76929F ON stu_ship (docked_to_id) |
||
| 1168 | SQL); |
||
| 1169 | $this->addSql(<<<'SQL' |
||
| 1170 | CREATE TABLE stu_ship_log (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, spacecraft_id INTEGER NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, is_private BOOLEAN NOT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_74CEF0EE1C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1171 | SQL); |
||
| 1172 | $this->addSql(<<<'SQL' |
||
| 1173 | CREATE INDEX IDX_74CEF0EE1C6AF6FD ON stu_ship_log (spacecraft_id) |
||
| 1174 | SQL); |
||
| 1175 | $this->addSql(<<<'SQL' |
||
| 1176 | CREATE TABLE stu_ship_takeover (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, source_spacecraft_id INTEGER NOT NULL, target_spacecraft_id INTEGER NOT NULL, start_turn INTEGER NOT NULL, prestige INTEGER NOT NULL, CONSTRAINT FK_4B0B8A7CD906279F FOREIGN KEY (source_spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4B0B8A7CE6C54C FOREIGN KEY (target_spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1177 | SQL); |
||
| 1178 | $this->addSql(<<<'SQL' |
||
| 1179 | CREATE UNIQUE INDEX UNIQ_4B0B8A7CD906279F ON stu_ship_takeover (source_spacecraft_id) |
||
| 1180 | SQL); |
||
| 1181 | $this->addSql(<<<'SQL' |
||
| 1182 | CREATE UNIQUE INDEX UNIQ_4B0B8A7CE6C54C ON stu_ship_takeover (target_spacecraft_id) |
||
| 1183 | SQL); |
||
| 1184 | $this->addSql(<<<'SQL' |
||
| 1185 | CREATE INDEX ship_takeover_source_idx ON stu_ship_takeover (source_spacecraft_id) |
||
| 1186 | SQL); |
||
| 1187 | $this->addSql(<<<'SQL' |
||
| 1188 | CREATE INDEX ship_takeover_target_idx ON stu_ship_takeover (target_spacecraft_id) |
||
| 1189 | SQL); |
||
| 1190 | $this->addSql(<<<'SQL' |
||
| 1191 | CREATE TABLE stu_shipyard_shipqueue (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, station_id INTEGER NOT NULL, user_id INTEGER NOT NULL, rump_id INTEGER NOT NULL, buildplan_id INTEGER NOT NULL, buildtime INTEGER NOT NULL, finish_date INTEGER NOT NULL, stop_date INTEGER NOT NULL, CONSTRAINT FK_7C6FFB428638E4E7 FOREIGN KEY (buildplan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7C6FFB422EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_7C6FFB4221BDB235 FOREIGN KEY (station_id) REFERENCES stu_station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1192 | SQL); |
||
| 1193 | $this->addSql(<<<'SQL' |
||
| 1194 | CREATE INDEX IDX_7C6FFB428638E4E7 ON stu_shipyard_shipqueue (buildplan_id) |
||
| 1195 | SQL); |
||
| 1196 | $this->addSql(<<<'SQL' |
||
| 1197 | CREATE INDEX IDX_7C6FFB422EE98D4C ON stu_shipyard_shipqueue (rump_id) |
||
| 1198 | SQL); |
||
| 1199 | $this->addSql(<<<'SQL' |
||
| 1200 | CREATE INDEX IDX_7C6FFB4221BDB235 ON stu_shipyard_shipqueue (station_id) |
||
| 1201 | SQL); |
||
| 1202 | $this->addSql(<<<'SQL' |
||
| 1203 | CREATE INDEX shipyard_shipqueue_user_idx ON stu_shipyard_shipqueue (user_id) |
||
| 1204 | SQL); |
||
| 1205 | $this->addSql(<<<'SQL' |
||
| 1206 | CREATE INDEX shipyard_shipqueue_finish_date_idx ON stu_shipyard_shipqueue (finish_date) |
||
| 1207 | SQL); |
||
| 1208 | $this->addSql(<<<'SQL' |
||
| 1209 | CREATE TABLE stu_spacecraft (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, rump_id INTEGER NOT NULL, plan_id INTEGER DEFAULT NULL, direction SMALLINT DEFAULT NULL, name VARCHAR(255) NOT NULL, alvl SMALLINT NOT NULL, lss_mode SMALLINT NOT NULL, huelle INTEGER NOT NULL, max_huelle INTEGER NOT NULL, schilde INTEGER NOT NULL, max_schilde INTEGER NOT NULL, tractored_ship_id INTEGER DEFAULT NULL, holding_web_id INTEGER DEFAULT NULL, database_id INTEGER DEFAULT NULL, disabled BOOLEAN NOT NULL, hit_chance SMALLINT NOT NULL, evade_chance SMALLINT NOT NULL, base_damage SMALLINT NOT NULL, state SMALLINT NOT NULL, location_id INTEGER NOT NULL, in_emergency BOOLEAN NOT NULL, type VARCHAR(255) NOT NULL, CONSTRAINT FK_4BD20E2EEE54A42E FOREIGN KEY (tractored_ship_id) REFERENCES stu_ship (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4BD20E2E73D3801E FOREIGN KEY (holding_web_id) REFERENCES stu_tholian_web (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4BD20E2EA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4BD20E2E2EE98D4C FOREIGN KEY (rump_id) REFERENCES stu_rump (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4BD20E2EE899029B FOREIGN KEY (plan_id) REFERENCES stu_buildplan (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4BD20E2E64D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1210 | SQL); |
||
| 1211 | $this->addSql(<<<'SQL' |
||
| 1212 | CREATE UNIQUE INDEX UNIQ_4BD20E2EEE54A42E ON stu_spacecraft (tractored_ship_id) |
||
| 1213 | SQL); |
||
| 1214 | $this->addSql(<<<'SQL' |
||
| 1215 | CREATE INDEX IDX_4BD20E2E73D3801E ON stu_spacecraft (holding_web_id) |
||
| 1216 | SQL); |
||
| 1217 | $this->addSql(<<<'SQL' |
||
| 1218 | CREATE INDEX IDX_4BD20E2EA76ED395 ON stu_spacecraft (user_id) |
||
| 1219 | SQL); |
||
| 1220 | $this->addSql(<<<'SQL' |
||
| 1221 | CREATE INDEX IDX_4BD20E2E2EE98D4C ON stu_spacecraft (rump_id) |
||
| 1222 | SQL); |
||
| 1223 | $this->addSql(<<<'SQL' |
||
| 1224 | CREATE INDEX IDX_4BD20E2EE899029B ON stu_spacecraft (plan_id) |
||
| 1225 | SQL); |
||
| 1226 | $this->addSql(<<<'SQL' |
||
| 1227 | CREATE INDEX IDX_4BD20E2E64D218E ON stu_spacecraft (location_id) |
||
| 1228 | SQL); |
||
| 1229 | $this->addSql(<<<'SQL' |
||
| 1230 | CREATE TABLE stu_spacecraft_emergency (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, spacecraft_id INTEGER NOT NULL, text CLOB NOT NULL, date INTEGER NOT NULL, deleted INTEGER DEFAULT NULL, CONSTRAINT FK_F02308131C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1231 | SQL); |
||
| 1232 | $this->addSql(<<<'SQL' |
||
| 1233 | CREATE INDEX IDX_F02308131C6AF6FD ON stu_spacecraft_emergency (spacecraft_id) |
||
| 1234 | SQL); |
||
| 1235 | $this->addSql(<<<'SQL' |
||
| 1236 | CREATE TABLE stu_spacecraft_system (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, spacecraft_id INTEGER NOT NULL, system_type SMALLINT NOT NULL, module_id INTEGER DEFAULT NULL, status SMALLINT NOT NULL, mode SMALLINT NOT NULL, cooldown INTEGER DEFAULT NULL, data CLOB DEFAULT NULL, CONSTRAINT FK_2AD626BCAFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_2AD626BC1C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1237 | SQL); |
||
| 1238 | $this->addSql(<<<'SQL' |
||
| 1239 | CREATE INDEX IDX_2AD626BCAFC2B591 ON stu_spacecraft_system (module_id) |
||
| 1240 | SQL); |
||
| 1241 | $this->addSql(<<<'SQL' |
||
| 1242 | CREATE INDEX IDX_2AD626BC1C6AF6FD ON stu_spacecraft_system (spacecraft_id) |
||
| 1243 | SQL); |
||
| 1244 | $this->addSql(<<<'SQL' |
||
| 1245 | CREATE INDEX spacecraft_system_status_idx ON stu_spacecraft_system (status) |
||
| 1246 | SQL); |
||
| 1247 | $this->addSql(<<<'SQL' |
||
| 1248 | CREATE INDEX spacecraft_system_type_idx ON stu_spacecraft_system (system_type) |
||
| 1249 | SQL); |
||
| 1250 | $this->addSql(<<<'SQL' |
||
| 1251 | CREATE INDEX spacecraft_system_mode_idx ON stu_spacecraft_system (mode) |
||
| 1252 | SQL); |
||
| 1253 | $this->addSql(<<<'SQL' |
||
| 1254 | CREATE TABLE stu_station (influence_area_id INTEGER DEFAULT NULL, id INTEGER NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_C782E0C3915ABAF6 FOREIGN KEY (influence_area_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_C782E0C3BF396750 FOREIGN KEY (id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1255 | SQL); |
||
| 1256 | $this->addSql(<<<'SQL' |
||
| 1257 | CREATE UNIQUE INDEX UNIQ_C782E0C3915ABAF6 ON stu_station (influence_area_id) |
||
| 1258 | SQL); |
||
| 1259 | $this->addSql(<<<'SQL' |
||
| 1260 | CREATE INDEX station_influence_area_idx ON stu_station (influence_area_id) |
||
| 1261 | SQL); |
||
| 1262 | $this->addSql(<<<'SQL' |
||
| 1263 | CREATE TABLE stu_station_shiprepair (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, station_id INTEGER NOT NULL, ship_id INTEGER NOT NULL, CONSTRAINT FK_51875AF721BDB235 FOREIGN KEY (station_id) REFERENCES stu_station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_51875AF7C256317D FOREIGN KEY (ship_id) REFERENCES stu_ship (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1264 | SQL); |
||
| 1265 | $this->addSql(<<<'SQL' |
||
| 1266 | CREATE INDEX IDX_51875AF721BDB235 ON stu_station_shiprepair (station_id) |
||
| 1267 | SQL); |
||
| 1268 | $this->addSql(<<<'SQL' |
||
| 1269 | CREATE INDEX IDX_51875AF7C256317D ON stu_station_shiprepair (ship_id) |
||
| 1270 | SQL); |
||
| 1271 | $this->addSql(<<<'SQL' |
||
| 1272 | CREATE TABLE stu_storage (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, colony_id INTEGER DEFAULT NULL, spacecraft_id INTEGER DEFAULT NULL, torpedo_storage_id INTEGER DEFAULT NULL, tradepost_id INTEGER DEFAULT NULL, tradeoffer_id INTEGER DEFAULT NULL, trumfield_id INTEGER DEFAULT NULL, CONSTRAINT FK_CC10346A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC10346B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC1034696ADBADE FOREIGN KEY (colony_id) REFERENCES stu_colonies (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC103461C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC1034686DD9CFF FOREIGN KEY (torpedo_storage_id) REFERENCES stu_torpedo_storage (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC103468B935ABD FOREIGN KEY (tradepost_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC10346D40ECD65 FOREIGN KEY (tradeoffer_id) REFERENCES stu_trade_offers (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_CC10346668E6720 FOREIGN KEY (trumfield_id) REFERENCES stu_trumfield (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1273 | SQL); |
||
| 1274 | $this->addSql(<<<'SQL' |
||
| 1275 | CREATE UNIQUE INDEX UNIQ_CC1034686DD9CFF ON stu_storage (torpedo_storage_id) |
||
| 1276 | SQL); |
||
| 1277 | $this->addSql(<<<'SQL' |
||
| 1278 | CREATE UNIQUE INDEX UNIQ_CC10346D40ECD65 ON stu_storage (tradeoffer_id) |
||
| 1279 | SQL); |
||
| 1280 | $this->addSql(<<<'SQL' |
||
| 1281 | CREATE INDEX IDX_CC10346668E6720 ON stu_storage (trumfield_id) |
||
| 1282 | SQL); |
||
| 1283 | $this->addSql(<<<'SQL' |
||
| 1284 | CREATE INDEX storage_user_idx ON stu_storage (user_id) |
||
| 1285 | SQL); |
||
| 1286 | $this->addSql(<<<'SQL' |
||
| 1287 | CREATE INDEX storage_commodity_idx ON stu_storage (commodity_id) |
||
| 1288 | SQL); |
||
| 1289 | $this->addSql(<<<'SQL' |
||
| 1290 | CREATE INDEX storage_colony_idx ON stu_storage (colony_id) |
||
| 1291 | SQL); |
||
| 1292 | $this->addSql(<<<'SQL' |
||
| 1293 | CREATE INDEX storage_spacecraft_idx ON stu_storage (spacecraft_id) |
||
| 1294 | SQL); |
||
| 1295 | $this->addSql(<<<'SQL' |
||
| 1296 | CREATE INDEX storage_torpedo_idx ON stu_storage (torpedo_storage_id) |
||
| 1297 | SQL); |
||
| 1298 | $this->addSql(<<<'SQL' |
||
| 1299 | CREATE INDEX storage_tradepost_idx ON stu_storage (tradepost_id) |
||
| 1300 | SQL); |
||
| 1301 | $this->addSql(<<<'SQL' |
||
| 1302 | CREATE INDEX storage_tradeoffer_idx ON stu_storage (tradeoffer_id) |
||
| 1303 | SQL); |
||
| 1304 | $this->addSql(<<<'SQL' |
||
| 1305 | CREATE TABLE stu_sys_map (sx SMALLINT NOT NULL, sy SMALLINT NOT NULL, systems_id INTEGER NOT NULL, id INTEGER NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_758AA7F1411D7F6D FOREIGN KEY (systems_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_758AA7F1BF396750 FOREIGN KEY (id) REFERENCES stu_location (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1306 | SQL); |
||
| 1307 | $this->addSql(<<<'SQL' |
||
| 1308 | CREATE INDEX IDX_758AA7F1411D7F6D ON stu_sys_map (systems_id) |
||
| 1309 | SQL); |
||
| 1310 | $this->addSql(<<<'SQL' |
||
| 1311 | CREATE UNIQUE INDEX system_coordinates_idx ON stu_sys_map (sx, sy, systems_id) |
||
| 1312 | SQL); |
||
| 1313 | $this->addSql(<<<'SQL' |
||
| 1314 | CREATE TABLE stu_system_types (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, database_id INTEGER DEFAULT NULL, is_generateable BOOLEAN DEFAULT NULL, first_mass_center_id INTEGER DEFAULT NULL, second_mass_center_id INTEGER DEFAULT NULL, CONSTRAINT FK_A02918D8F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A02918D8109BE2EA FOREIGN KEY (first_mass_center_id) REFERENCES stu_mass_center_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_A02918D8E1E58576 FOREIGN KEY (second_mass_center_id) REFERENCES stu_mass_center_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1315 | SQL); |
||
| 1316 | $this->addSql(<<<'SQL' |
||
| 1317 | CREATE UNIQUE INDEX UNIQ_A02918D8F0AA09DB ON stu_system_types (database_id) |
||
| 1318 | SQL); |
||
| 1319 | $this->addSql(<<<'SQL' |
||
| 1320 | CREATE INDEX starsystem_mass_center_1_idx ON stu_system_types (first_mass_center_id) |
||
| 1321 | SQL); |
||
| 1322 | $this->addSql(<<<'SQL' |
||
| 1323 | CREATE INDEX starsystem_mass_center_2_idx ON stu_system_types (second_mass_center_id) |
||
| 1324 | SQL); |
||
| 1325 | $this->addSql(<<<'SQL' |
||
| 1326 | CREATE TABLE stu_systems (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, type INTEGER NOT NULL, name VARCHAR(255) NOT NULL, max_x SMALLINT NOT NULL, max_y SMALLINT NOT NULL, bonus_fields SMALLINT NOT NULL, database_id INTEGER DEFAULT NULL, is_wormhole BOOLEAN NOT NULL, CONSTRAINT FK_3916C0C08CDE5729 FOREIGN KEY (type) REFERENCES stu_system_types (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_3916C0C0F0AA09DB FOREIGN KEY (database_id) REFERENCES stu_database_entrys (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1327 | SQL); |
||
| 1328 | $this->addSql(<<<'SQL' |
||
| 1329 | CREATE INDEX IDX_3916C0C08CDE5729 ON stu_systems (type) |
||
| 1330 | SQL); |
||
| 1331 | $this->addSql(<<<'SQL' |
||
| 1332 | CREATE INDEX IDX_3916C0C0F0AA09DB ON stu_systems (database_id) |
||
| 1333 | SQL); |
||
| 1334 | $this->addSql(<<<'SQL' |
||
| 1335 | CREATE TABLE stu_tachyon_scan (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, scan_time INTEGER NOT NULL, location_id INTEGER NOT NULL, CONSTRAINT FK_1ED54F94A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1ED54F9464D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1336 | SQL); |
||
| 1337 | $this->addSql(<<<'SQL' |
||
| 1338 | CREATE INDEX IDX_1ED54F9464D218E ON stu_tachyon_scan (location_id) |
||
| 1339 | SQL); |
||
| 1340 | $this->addSql(<<<'SQL' |
||
| 1341 | CREATE INDEX tachyon_scan_user_idx ON stu_tachyon_scan (user_id) |
||
| 1342 | SQL); |
||
| 1343 | $this->addSql(<<<'SQL' |
||
| 1344 | CREATE TABLE stu_terraforming (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, description VARCHAR(255) NOT NULL, ecost INTEGER NOT NULL, v_feld INTEGER NOT NULL, z_feld INTEGER NOT NULL, duration INTEGER NOT NULL, research_id INTEGER DEFAULT NULL) |
||
| 1345 | SQL); |
||
| 1346 | $this->addSql(<<<'SQL' |
||
| 1347 | CREATE INDEX terraforming_research_idx ON stu_terraforming (research_id) |
||
| 1348 | SQL); |
||
| 1349 | $this->addSql(<<<'SQL' |
||
| 1350 | CREATE UNIQUE INDEX field_transformation_idx ON stu_terraforming (v_feld, z_feld) |
||
| 1351 | SQL); |
||
| 1352 | $this->addSql(<<<'SQL' |
||
| 1353 | CREATE TABLE stu_terraforming_cost (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, terraforming_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_4CD9B703B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4CD9B703BD31079C FOREIGN KEY (terraforming_id) REFERENCES stu_terraforming (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1354 | SQL); |
||
| 1355 | $this->addSql(<<<'SQL' |
||
| 1356 | CREATE INDEX IDX_4CD9B703B4ACC212 ON stu_terraforming_cost (commodity_id) |
||
| 1357 | SQL); |
||
| 1358 | $this->addSql(<<<'SQL' |
||
| 1359 | CREATE INDEX terraforming_idx ON stu_terraforming_cost (terraforming_id) |
||
| 1360 | SQL); |
||
| 1361 | $this->addSql(<<<'SQL' |
||
| 1362 | CREATE TABLE stu_tholian_web (finished_time INTEGER DEFAULT NULL, id INTEGER NOT NULL, PRIMARY KEY(id), CONSTRAINT FK_D032F9A0BF396750 FOREIGN KEY (id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1363 | SQL); |
||
| 1364 | $this->addSql(<<<'SQL' |
||
| 1365 | CREATE TABLE stu_torpedo_cost (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, torpedo_type_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, count INTEGER NOT NULL, CONSTRAINT FK_AD0DEA44D12BAD4E FOREIGN KEY (torpedo_type_id) REFERENCES stu_torpedo_types (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_AD0DEA44B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1366 | SQL); |
||
| 1367 | $this->addSql(<<<'SQL' |
||
| 1368 | CREATE INDEX IDX_AD0DEA44D12BAD4E ON stu_torpedo_cost (torpedo_type_id) |
||
| 1369 | SQL); |
||
| 1370 | $this->addSql(<<<'SQL' |
||
| 1371 | CREATE INDEX IDX_AD0DEA44B4ACC212 ON stu_torpedo_cost (commodity_id) |
||
| 1372 | SQL); |
||
| 1373 | $this->addSql(<<<'SQL' |
||
| 1374 | CREATE TABLE stu_torpedo_hull (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module_id INTEGER NOT NULL, torpedo_type INTEGER NOT NULL, modificator INTEGER NOT NULL, CONSTRAINT FK_B58BDD2B942323E3 FOREIGN KEY (torpedo_type) REFERENCES stu_torpedo_types (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_B58BDD2BAFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1375 | SQL); |
||
| 1376 | $this->addSql(<<<'SQL' |
||
| 1377 | CREATE INDEX torpedo_hull_module_idx ON stu_torpedo_hull (module_id) |
||
| 1378 | SQL); |
||
| 1379 | $this->addSql(<<<'SQL' |
||
| 1380 | CREATE INDEX torpedo_hull_torpedo_idx ON stu_torpedo_hull (torpedo_type) |
||
| 1381 | SQL); |
||
| 1382 | $this->addSql(<<<'SQL' |
||
| 1383 | CREATE TABLE stu_torpedo_storage (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, spacecraft_id INTEGER NOT NULL, torpedo_type INTEGER NOT NULL, CONSTRAINT FK_823719111C6AF6FD FOREIGN KEY (spacecraft_id) REFERENCES stu_spacecraft (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_82371911942323E3 FOREIGN KEY (torpedo_type) REFERENCES stu_torpedo_types (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1384 | SQL); |
||
| 1385 | $this->addSql(<<<'SQL' |
||
| 1386 | CREATE UNIQUE INDEX UNIQ_823719111C6AF6FD ON stu_torpedo_storage (spacecraft_id) |
||
| 1387 | SQL); |
||
| 1388 | $this->addSql(<<<'SQL' |
||
| 1389 | CREATE INDEX IDX_82371911942323E3 ON stu_torpedo_storage (torpedo_type) |
||
| 1390 | SQL); |
||
| 1391 | $this->addSql(<<<'SQL' |
||
| 1392 | CREATE INDEX torpedo_storage_spacecraft_idx ON stu_torpedo_storage (spacecraft_id) |
||
| 1393 | SQL); |
||
| 1394 | $this->addSql(<<<'SQL' |
||
| 1395 | CREATE TABLE stu_torpedo_types (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, base_damage INTEGER NOT NULL, critical_chance INTEGER NOT NULL, hit_factor INTEGER NOT NULL, hull_damage_factor INTEGER NOT NULL, shield_damage_factor INTEGER NOT NULL, variance INTEGER NOT NULL, commodity_id INTEGER NOT NULL, level INTEGER NOT NULL, research_id INTEGER NOT NULL, ecost INTEGER NOT NULL, amount INTEGER NOT NULL, CONSTRAINT FK_9C3F99F0B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1396 | SQL); |
||
| 1397 | $this->addSql(<<<'SQL' |
||
| 1398 | CREATE INDEX IDX_9C3F99F0B4ACC212 ON stu_torpedo_types (commodity_id) |
||
| 1399 | SQL); |
||
| 1400 | $this->addSql(<<<'SQL' |
||
| 1401 | CREATE INDEX torpedo_type_research_idx ON stu_torpedo_types (research_id) |
||
| 1402 | SQL); |
||
| 1403 | $this->addSql(<<<'SQL' |
||
| 1404 | CREATE INDEX level_idx ON stu_torpedo_types (level) |
||
| 1405 | SQL); |
||
| 1406 | $this->addSql(<<<'SQL' |
||
| 1407 | CREATE TABLE stu_trade_license (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, posts_id INTEGER NOT NULL, user_id INTEGER NOT NULL, date INTEGER NOT NULL, expired INTEGER NOT NULL, CONSTRAINT FK_1A4E6AF5D5E258C5 FOREIGN KEY (posts_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_1A4E6AF5A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1408 | SQL); |
||
| 1409 | $this->addSql(<<<'SQL' |
||
| 1410 | CREATE INDEX IDX_1A4E6AF5D5E258C5 ON stu_trade_license (posts_id) |
||
| 1411 | SQL); |
||
| 1412 | $this->addSql(<<<'SQL' |
||
| 1413 | CREATE INDEX IDX_1A4E6AF5A76ED395 ON stu_trade_license (user_id) |
||
| 1414 | SQL); |
||
| 1415 | $this->addSql(<<<'SQL' |
||
| 1416 | CREATE INDEX user_trade_post_idx ON stu_trade_license (user_id, posts_id) |
||
| 1417 | SQL); |
||
| 1418 | $this->addSql(<<<'SQL' |
||
| 1419 | CREATE TABLE stu_trade_license_info (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, posts_id INTEGER NOT NULL, commodity_id INTEGER NOT NULL, amount INTEGER NOT NULL, days INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_88CAD317D5E258C5 FOREIGN KEY (posts_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_88CAD317B4ACC212 FOREIGN KEY (commodity_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1420 | SQL); |
||
| 1421 | $this->addSql(<<<'SQL' |
||
| 1422 | CREATE INDEX IDX_88CAD317B4ACC212 ON stu_trade_license_info (commodity_id) |
||
| 1423 | SQL); |
||
| 1424 | $this->addSql(<<<'SQL' |
||
| 1425 | CREATE INDEX trade_license_info_post_idx ON stu_trade_license_info (posts_id) |
||
| 1426 | SQL); |
||
| 1427 | $this->addSql(<<<'SQL' |
||
| 1428 | CREATE TABLE stu_trade_offers (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, posts_id INTEGER NOT NULL, amount SMALLINT NOT NULL, wg_id INTEGER NOT NULL, wg_count INTEGER NOT NULL, gg_id INTEGER NOT NULL, gg_count INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_4EB9B047D5E258C5 FOREIGN KEY (posts_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4EB9B047B221185A FOREIGN KEY (wg_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4EB9B047D2C18FD8 FOREIGN KEY (gg_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_4EB9B047A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1429 | SQL); |
||
| 1430 | $this->addSql(<<<'SQL' |
||
| 1431 | CREATE INDEX IDX_4EB9B047D5E258C5 ON stu_trade_offers (posts_id) |
||
| 1432 | SQL); |
||
| 1433 | $this->addSql(<<<'SQL' |
||
| 1434 | CREATE INDEX IDX_4EB9B047B221185A ON stu_trade_offers (wg_id) |
||
| 1435 | SQL); |
||
| 1436 | $this->addSql(<<<'SQL' |
||
| 1437 | CREATE INDEX IDX_4EB9B047D2C18FD8 ON stu_trade_offers (gg_id) |
||
| 1438 | SQL); |
||
| 1439 | $this->addSql(<<<'SQL' |
||
| 1440 | CREATE INDEX IDX_4EB9B047A76ED395 ON stu_trade_offers (user_id) |
||
| 1441 | SQL); |
||
| 1442 | $this->addSql(<<<'SQL' |
||
| 1443 | CREATE INDEX trade_post_user_idx ON stu_trade_offers (posts_id, user_id) |
||
| 1444 | SQL); |
||
| 1445 | $this->addSql(<<<'SQL' |
||
| 1446 | CREATE TABLE stu_trade_posts (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, name VARCHAR(255) NOT NULL, description CLOB NOT NULL, station_id INTEGER NOT NULL, trade_network SMALLINT NOT NULL, level SMALLINT NOT NULL, transfer_capacity INTEGER NOT NULL, storage INTEGER NOT NULL, is_dock_pm_auto_read BOOLEAN DEFAULT NULL, CONSTRAINT FK_13D25E73A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_13D25E7321BDB235 FOREIGN KEY (station_id) REFERENCES stu_station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1447 | SQL); |
||
| 1448 | $this->addSql(<<<'SQL' |
||
| 1449 | CREATE INDEX IDX_13D25E73A76ED395 ON stu_trade_posts (user_id) |
||
| 1450 | SQL); |
||
| 1451 | $this->addSql(<<<'SQL' |
||
| 1452 | CREATE UNIQUE INDEX UNIQ_13D25E7321BDB235 ON stu_trade_posts (station_id) |
||
| 1453 | SQL); |
||
| 1454 | $this->addSql(<<<'SQL' |
||
| 1455 | CREATE INDEX trade_network_idx ON stu_trade_posts (trade_network) |
||
| 1456 | SQL); |
||
| 1457 | $this->addSql(<<<'SQL' |
||
| 1458 | CREATE INDEX trade_post_station_idx ON stu_trade_posts (station_id) |
||
| 1459 | SQL); |
||
| 1460 | $this->addSql(<<<'SQL' |
||
| 1461 | CREATE TABLE stu_trade_shoutbox (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, trade_network_id SMALLINT NOT NULL, date INTEGER NOT NULL, message VARCHAR(255) NOT NULL, CONSTRAINT FK_8D70B786A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1462 | SQL); |
||
| 1463 | $this->addSql(<<<'SQL' |
||
| 1464 | CREATE INDEX IDX_8D70B786A76ED395 ON stu_trade_shoutbox (user_id) |
||
| 1465 | SQL); |
||
| 1466 | $this->addSql(<<<'SQL' |
||
| 1467 | CREATE INDEX trade_network_date_idx ON stu_trade_shoutbox (trade_network_id, date) |
||
| 1468 | SQL); |
||
| 1469 | $this->addSql(<<<'SQL' |
||
| 1470 | CREATE TABLE stu_trade_transaction (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, wg_id INTEGER NOT NULL, wg_count INTEGER NOT NULL, gg_id INTEGER NOT NULL, gg_count INTEGER NOT NULL, date INTEGER NOT NULL, tradepost_id INTEGER DEFAULT NULL, CONSTRAINT FK_D2A0D0A2B221185A FOREIGN KEY (wg_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D2A0D0A2D2C18FD8 FOREIGN KEY (gg_id) REFERENCES stu_commodity (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1471 | SQL); |
||
| 1472 | $this->addSql(<<<'SQL' |
||
| 1473 | CREATE INDEX IDX_D2A0D0A2B221185A ON stu_trade_transaction (wg_id) |
||
| 1474 | SQL); |
||
| 1475 | $this->addSql(<<<'SQL' |
||
| 1476 | CREATE INDEX IDX_D2A0D0A2D2C18FD8 ON stu_trade_transaction (gg_id) |
||
| 1477 | SQL); |
||
| 1478 | $this->addSql(<<<'SQL' |
||
| 1479 | CREATE INDEX trade_transaction_date_tradepost_idx ON stu_trade_transaction (date, tradepost_id) |
||
| 1480 | SQL); |
||
| 1481 | $this->addSql(<<<'SQL' |
||
| 1482 | CREATE TABLE stu_trade_transfers (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, posts_id INTEGER NOT NULL, user_id INTEGER NOT NULL, count INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_6556769DD5E258C5 FOREIGN KEY (posts_id) REFERENCES stu_trade_posts (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_6556769DA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1483 | SQL); |
||
| 1484 | $this->addSql(<<<'SQL' |
||
| 1485 | CREATE INDEX IDX_6556769DD5E258C5 ON stu_trade_transfers (posts_id) |
||
| 1486 | SQL); |
||
| 1487 | $this->addSql(<<<'SQL' |
||
| 1488 | CREATE INDEX IDX_6556769DA76ED395 ON stu_trade_transfers (user_id) |
||
| 1489 | SQL); |
||
| 1490 | $this->addSql(<<<'SQL' |
||
| 1491 | CREATE INDEX trade_transfer_post_user_idx ON stu_trade_transfers (posts_id, user_id) |
||
| 1492 | SQL); |
||
| 1493 | $this->addSql(<<<'SQL' |
||
| 1494 | CREATE TABLE stu_trumfield (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, huelle INTEGER NOT NULL, former_rump_id INTEGER NOT NULL, location_id INTEGER NOT NULL, CONSTRAINT FK_3CBB9A4E64D218E FOREIGN KEY (location_id) REFERENCES stu_location (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1495 | SQL); |
||
| 1496 | $this->addSql(<<<'SQL' |
||
| 1497 | CREATE INDEX IDX_3CBB9A4E64D218E ON stu_trumfield (location_id) |
||
| 1498 | SQL); |
||
| 1499 | $this->addSql(<<<'SQL' |
||
| 1500 | CREATE TABLE stu_tutorial_step (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module VARCHAR(50) NOT NULL, "view" VARCHAR(100) NOT NULL, next_step_id INTEGER DEFAULT NULL, title CLOB DEFAULT NULL, text CLOB DEFAULT NULL, elementIds CLOB DEFAULT NULL, innerUpdate CLOB DEFAULT NULL, fallbackIndex INTEGER DEFAULT NULL, CONSTRAINT FK_82D9BF6BB13C343E FOREIGN KEY (next_step_id) REFERENCES stu_tutorial_step (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1501 | SQL); |
||
| 1502 | $this->addSql(<<<'SQL' |
||
| 1503 | CREATE UNIQUE INDEX UNIQ_82D9BF6BB13C343E ON stu_tutorial_step (next_step_id) |
||
| 1504 | SQL); |
||
| 1505 | $this->addSql(<<<'SQL' |
||
| 1506 | CREATE INDEX tutorial_view_idx ON stu_tutorial_step (module, "view") |
||
| 1507 | SQL); |
||
| 1508 | $this->addSql(<<<'SQL' |
||
| 1509 | CREATE TABLE stu_user (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, username VARCHAR(255) NOT NULL, login VARCHAR(20) NOT NULL, pass VARCHAR(255) NOT NULL, sms_code VARCHAR(6) DEFAULT NULL, email VARCHAR(200) NOT NULL, mobile VARCHAR(255) DEFAULT NULL, allys_id INTEGER DEFAULT NULL, race INTEGER NOT NULL, state SMALLINT NOT NULL, lastaction INTEGER NOT NULL, creation INTEGER NOT NULL, kn_lez INTEGER NOT NULL, delmark SMALLINT NOT NULL, vac_active BOOLEAN NOT NULL, vac_request_date INTEGER NOT NULL, description CLOB NOT NULL, tick SMALLINT NOT NULL, maptype SMALLINT DEFAULT NULL, sessiondata CLOB NOT NULL, password_token VARCHAR(255) NOT NULL, prestige INTEGER NOT NULL, deals BOOLEAN NOT NULL, last_boarding INTEGER DEFAULT NULL, CONSTRAINT FK_12A1701F5E0B0712 FOREIGN KEY (allys_id) REFERENCES stu_alliances (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_12A1701FDA6FBBAF FOREIGN KEY (race) REFERENCES stu_factions (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1510 | SQL); |
||
| 1511 | $this->addSql(<<<'SQL' |
||
| 1512 | CREATE INDEX IDX_12A1701FDA6FBBAF ON stu_user (race) |
||
| 1513 | SQL); |
||
| 1514 | $this->addSql(<<<'SQL' |
||
| 1515 | CREATE INDEX user_alliance_idx ON stu_user (allys_id) |
||
| 1516 | SQL); |
||
| 1517 | $this->addSql(<<<'SQL' |
||
| 1518 | CREATE TABLE stu_user_award (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, award_id INTEGER NOT NULL, CONSTRAINT FK_E1449B84A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_E1449B843D5282CF FOREIGN KEY (award_id) REFERENCES stu_award (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1519 | SQL); |
||
| 1520 | $this->addSql(<<<'SQL' |
||
| 1521 | CREATE INDEX IDX_E1449B84A76ED395 ON stu_user_award (user_id) |
||
| 1522 | SQL); |
||
| 1523 | $this->addSql(<<<'SQL' |
||
| 1524 | CREATE INDEX IDX_E1449B843D5282CF ON stu_user_award (award_id) |
||
| 1525 | SQL); |
||
| 1526 | $this->addSql(<<<'SQL' |
||
| 1527 | CREATE TABLE stu_user_character (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description CLOB DEFAULT NULL, avatar VARCHAR(32) DEFAULT NULL, former_user_id INTEGER DEFAULT NULL, user_id INTEGER DEFAULT NULL, CONSTRAINT FK_6E46626CA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1528 | SQL); |
||
| 1529 | $this->addSql(<<<'SQL' |
||
| 1530 | CREATE INDEX IDX_6E46626CA76ED395 ON stu_user_character (user_id) |
||
| 1531 | SQL); |
||
| 1532 | $this->addSql(<<<'SQL' |
||
| 1533 | CREATE TABLE stu_user_invitations (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, invited_user_id INTEGER DEFAULT NULL, date DATETIME NOT NULL, token VARCHAR(255) NOT NULL) |
||
| 1534 | SQL); |
||
| 1535 | $this->addSql(<<<'SQL' |
||
| 1536 | CREATE INDEX user_invitation_user_idx ON stu_user_invitations (user_id) |
||
| 1537 | SQL); |
||
| 1538 | $this->addSql(<<<'SQL' |
||
| 1539 | CREATE INDEX user_invitation_token_idx ON stu_user_invitations (token) |
||
| 1540 | SQL); |
||
| 1541 | $this->addSql(<<<'SQL' |
||
| 1542 | CREATE TABLE stu_user_iptable (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, ip VARCHAR(255) NOT NULL, session VARCHAR(255) NOT NULL, agent VARCHAR(255) NOT NULL, startDate DATETIME DEFAULT NULL, endDate DATETIME DEFAULT NULL, CONSTRAINT FK_4DB0B7AAA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1543 | SQL); |
||
| 1544 | $this->addSql(<<<'SQL' |
||
| 1545 | CREATE INDEX IDX_4DB0B7AAA76ED395 ON stu_user_iptable (user_id) |
||
| 1546 | SQL); |
||
| 1547 | $this->addSql(<<<'SQL' |
||
| 1548 | CREATE INDEX session_idx ON stu_user_iptable (session) |
||
| 1549 | SQL); |
||
| 1550 | $this->addSql(<<<'SQL' |
||
| 1551 | CREATE INDEX iptable_start_idx ON stu_user_iptable (startDate) |
||
| 1552 | SQL); |
||
| 1553 | $this->addSql(<<<'SQL' |
||
| 1554 | CREATE INDEX iptable_end_idx ON stu_user_iptable (endDate) |
||
| 1555 | SQL); |
||
| 1556 | $this->addSql(<<<'SQL' |
||
| 1557 | CREATE INDEX iptable_ip_idx ON stu_user_iptable (ip) |
||
| 1558 | SQL); |
||
| 1559 | $this->addSql(<<<'SQL' |
||
| 1560 | CREATE TABLE stu_user_layer (user_id INTEGER NOT NULL, layer_id INTEGER NOT NULL, map_type SMALLINT NOT NULL, PRIMARY KEY(user_id, layer_id), CONSTRAINT FK_8FC49479A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_8FC49479EA6EFDCD FOREIGN KEY (layer_id) REFERENCES stu_layer (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1561 | SQL); |
||
| 1562 | $this->addSql(<<<'SQL' |
||
| 1563 | CREATE INDEX IDX_8FC49479A76ED395 ON stu_user_layer (user_id) |
||
| 1564 | SQL); |
||
| 1565 | $this->addSql(<<<'SQL' |
||
| 1566 | CREATE INDEX IDX_8FC49479EA6EFDCD ON stu_user_layer (layer_id) |
||
| 1567 | SQL); |
||
| 1568 | $this->addSql(<<<'SQL' |
||
| 1569 | CREATE TABLE stu_user_lock (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER DEFAULT NULL, former_user_id INTEGER DEFAULT NULL, remaining_ticks INTEGER NOT NULL, reason CLOB NOT NULL, CONSTRAINT FK_F36B0C5EA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1570 | SQL); |
||
| 1571 | $this->addSql(<<<'SQL' |
||
| 1572 | CREATE UNIQUE INDEX UNIQ_F36B0C5EA76ED395 ON stu_user_lock (user_id) |
||
| 1573 | SQL); |
||
| 1574 | $this->addSql(<<<'SQL' |
||
| 1575 | CREATE INDEX user_lock_user_idx ON stu_user_lock (user_id) |
||
| 1576 | SQL); |
||
| 1577 | $this->addSql(<<<'SQL' |
||
| 1578 | CREATE TABLE stu_user_map (user_id INTEGER NOT NULL, layer_id INTEGER NOT NULL, cx INTEGER NOT NULL, cy INTEGER NOT NULL, map_id INTEGER NOT NULL, PRIMARY KEY(user_id, layer_id, cx, cy), CONSTRAINT FK_C6E86038A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_C6E86038EA6EFDCD FOREIGN KEY (layer_id) REFERENCES stu_layer (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1579 | SQL); |
||
| 1580 | $this->addSql(<<<'SQL' |
||
| 1581 | CREATE INDEX IDX_C6E86038A76ED395 ON stu_user_map (user_id) |
||
| 1582 | SQL); |
||
| 1583 | $this->addSql(<<<'SQL' |
||
| 1584 | CREATE INDEX IDX_C6E86038EA6EFDCD ON stu_user_map (layer_id) |
||
| 1585 | SQL); |
||
| 1586 | $this->addSql(<<<'SQL' |
||
| 1587 | CREATE TABLE stu_user_profile_visitors (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, recipient INTEGER NOT NULL, date INTEGER NOT NULL, CONSTRAINT FK_DD0F4487A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_DD0F44876804FB49 FOREIGN KEY (recipient) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1588 | SQL); |
||
| 1589 | $this->addSql(<<<'SQL' |
||
| 1590 | CREATE INDEX IDX_DD0F44876804FB49 ON stu_user_profile_visitors (recipient) |
||
| 1591 | SQL); |
||
| 1592 | $this->addSql(<<<'SQL' |
||
| 1593 | CREATE INDEX user_profile_visitor_user_idx ON stu_user_profile_visitors (user_id) |
||
| 1594 | SQL); |
||
| 1595 | $this->addSql(<<<'SQL' |
||
| 1596 | CREATE TABLE stu_user_referer (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, referer CLOB NOT NULL, user_id INTEGER NOT NULL, CONSTRAINT FK_A00722FDA76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1597 | SQL); |
||
| 1598 | $this->addSql(<<<'SQL' |
||
| 1599 | CREATE UNIQUE INDEX UNIQ_A00722FDA76ED395 ON stu_user_referer (user_id) |
||
| 1600 | SQL); |
||
| 1601 | $this->addSql(<<<'SQL' |
||
| 1602 | CREATE TABLE stu_user_setting (user_id INTEGER NOT NULL, setting VARCHAR(255) NOT NULL, value VARCHAR(255) NOT NULL, PRIMARY KEY(user_id, setting), CONSTRAINT FK_6AAFACE0A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1603 | SQL); |
||
| 1604 | $this->addSql(<<<'SQL' |
||
| 1605 | CREATE INDEX IDX_6AAFACE0A76ED395 ON stu_user_setting (user_id) |
||
| 1606 | SQL); |
||
| 1607 | $this->addSql(<<<'SQL' |
||
| 1608 | CREATE TABLE stu_user_tag (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user_id INTEGER NOT NULL, tag_type_id INTEGER NOT NULL, date DATETIME NOT NULL, CONSTRAINT FK_56CC7D00A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1609 | SQL); |
||
| 1610 | $this->addSql(<<<'SQL' |
||
| 1611 | CREATE INDEX IDX_56CC7D00A76ED395 ON stu_user_tag (user_id) |
||
| 1612 | SQL); |
||
| 1613 | $this->addSql(<<<'SQL' |
||
| 1614 | CREATE TABLE stu_user_tutorial (user_id INTEGER NOT NULL, tutorial_step_id INTEGER NOT NULL, PRIMARY KEY(user_id, tutorial_step_id), CONSTRAINT FK_9840DDF3A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_9840DDF3D356979 FOREIGN KEY (tutorial_step_id) REFERENCES stu_tutorial_step (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1615 | SQL); |
||
| 1616 | $this->addSql(<<<'SQL' |
||
| 1617 | CREATE INDEX IDX_9840DDF3A76ED395 ON stu_user_tutorial (user_id) |
||
| 1618 | SQL); |
||
| 1619 | $this->addSql(<<<'SQL' |
||
| 1620 | CREATE INDEX IDX_9840DDF3D356979 ON stu_user_tutorial (tutorial_step_id) |
||
| 1621 | SQL); |
||
| 1622 | $this->addSql(<<<'SQL' |
||
| 1623 | CREATE TABLE stu_weapon_shield (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, module_id INTEGER NOT NULL, weapon_id INTEGER NOT NULL, modificator INTEGER NOT NULL, faction_id INTEGER DEFAULT NULL, CONSTRAINT FK_9DC03BD595B82273 FOREIGN KEY (weapon_id) REFERENCES stu_weapons (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_9DC03BD5AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1624 | SQL); |
||
| 1625 | $this->addSql(<<<'SQL' |
||
| 1626 | CREATE INDEX weapon_shield_module_idx ON stu_weapon_shield (module_id) |
||
| 1627 | SQL); |
||
| 1628 | $this->addSql(<<<'SQL' |
||
| 1629 | CREATE INDEX weapon_shield_weapon_idx ON stu_weapon_shield (weapon_id) |
||
| 1630 | SQL); |
||
| 1631 | $this->addSql(<<<'SQL' |
||
| 1632 | CREATE TABLE stu_weapons (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(255) NOT NULL, variance SMALLINT NOT NULL, critical_chance SMALLINT NOT NULL, type SMALLINT NOT NULL, firing_mode SMALLINT NOT NULL, module_id INTEGER NOT NULL, CONSTRAINT FK_AB5A393AFC2B591 FOREIGN KEY (module_id) REFERENCES stu_modules (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1633 | SQL); |
||
| 1634 | $this->addSql(<<<'SQL' |
||
| 1635 | CREATE UNIQUE INDEX UNIQ_AB5A393AFC2B591 ON stu_weapons (module_id) |
||
| 1636 | SQL); |
||
| 1637 | $this->addSql(<<<'SQL' |
||
| 1638 | CREATE INDEX weapon_module_idx ON stu_weapons (module_id) |
||
| 1639 | SQL); |
||
| 1640 | $this->addSql(<<<'SQL' |
||
| 1641 | CREATE TABLE stu_wormhole_entry (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, map_id INTEGER NOT NULL, system_id INTEGER NOT NULL, system_map_id INTEGER NOT NULL, type VARCHAR(10) NOT NULL, last_used INTEGER DEFAULT NULL, cooldown INTEGER DEFAULT NULL, CONSTRAINT FK_D68CF8C953C55F64 FOREIGN KEY (map_id) REFERENCES stu_map (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D68CF8C9D0952FA5 FOREIGN KEY (system_id) REFERENCES stu_systems (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_D68CF8C9434BEAA5 FOREIGN KEY (system_map_id) REFERENCES stu_sys_map (id) NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1642 | SQL); |
||
| 1643 | $this->addSql(<<<'SQL' |
||
| 1644 | CREATE INDEX IDX_D68CF8C953C55F64 ON stu_wormhole_entry (map_id) |
||
| 1645 | SQL); |
||
| 1646 | $this->addSql(<<<'SQL' |
||
| 1647 | CREATE INDEX IDX_D68CF8C9D0952FA5 ON stu_wormhole_entry (system_id) |
||
| 1648 | SQL); |
||
| 1649 | $this->addSql(<<<'SQL' |
||
| 1650 | CREATE INDEX IDX_D68CF8C9434BEAA5 ON stu_wormhole_entry (system_map_id) |
||
| 1651 | SQL); |
||
| 1652 | $this->addSql(<<<'SQL' |
||
| 1653 | CREATE TABLE stu_wormhole_restrictions (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, mode INTEGER DEFAULT NULL, wormhole_entry_id INTEGER DEFAULT NULL, user_id INTEGER DEFAULT NULL, CONSTRAINT FK_76C7B8E0BE56147A FOREIGN KEY (wormhole_entry_id) REFERENCES stu_wormhole_entry (id) NOT DEFERRABLE INITIALLY IMMEDIATE, CONSTRAINT FK_76C7B8E0A76ED395 FOREIGN KEY (user_id) REFERENCES stu_user (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE) |
||
| 1654 | SQL); |
||
| 1655 | $this->addSql(<<<'SQL' |
||
| 1656 | CREATE INDEX IDX_76C7B8E0BE56147A ON stu_wormhole_restrictions (wormhole_entry_id) |
||
| 1657 | SQL); |
||
| 1658 | $this->addSql(<<<'SQL' |
||
| 1659 | CREATE INDEX IDX_76C7B8E0A76ED395 ON stu_wormhole_restrictions (user_id) |
||
| 2166 |
