|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
declare(strict_types=1); |
|
4
|
|
|
|
|
5
|
|
|
namespace Stu\Migrations\Sqlite; |
|
6
|
|
|
|
|
7
|
|
|
use Doctrine\DBAL\Schema\Schema; |
|
8
|
|
|
use Doctrine\Migrations\AbstractMigration; |
|
9
|
|
|
|
|
10
|
|
|
/** |
|
11
|
|
|
* Auto-generated Migration: Please modify to your needs! |
|
12
|
|
|
*/ |
|
13
|
|
|
final class Version20250602202724 extends AbstractMigration |
|
14
|
|
|
{ |
|
15
|
|
|
public function getDescription(): string |
|
16
|
|
|
{ |
|
17
|
|
|
return ''; |
|
18
|
|
|
} |
|
19
|
|
|
|
|
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) |
|
1660
|
|
|
SQL); |
|
1661
|
|
|
} |
|
1662
|
|
|
|
|
1663
|
|
|
public function down(Schema $schema): void |
|
1664
|
|
|
{ |
|
1665
|
|
|
// this down() migration is auto-generated, please modify it to your needs |
|
1666
|
|
|
$this->addSql(<<<'SQL' |
|
1667
|
|
|
DROP TABLE stu_alliance_boards |
|
1668
|
|
|
SQL); |
|
1669
|
|
|
$this->addSql(<<<'SQL' |
|
1670
|
|
|
DROP TABLE stu_alliance_posts |
|
1671
|
|
|
SQL); |
|
1672
|
|
|
$this->addSql(<<<'SQL' |
|
1673
|
|
|
DROP TABLE stu_alliance_settings |
|
1674
|
|
|
SQL); |
|
1675
|
|
|
$this->addSql(<<<'SQL' |
|
1676
|
|
|
DROP TABLE stu_alliance_topics |
|
1677
|
|
|
SQL); |
|
1678
|
|
|
$this->addSql(<<<'SQL' |
|
1679
|
|
|
DROP TABLE stu_alliances |
|
1680
|
|
|
SQL); |
|
1681
|
|
|
$this->addSql(<<<'SQL' |
|
1682
|
|
|
DROP TABLE stu_alliances_jobs |
|
1683
|
|
|
SQL); |
|
1684
|
|
|
$this->addSql(<<<'SQL' |
|
1685
|
|
|
DROP TABLE stu_alliances_relations |
|
1686
|
|
|
SQL); |
|
1687
|
|
|
$this->addSql(<<<'SQL' |
|
1688
|
|
|
DROP TABLE stu_anomaly |
|
1689
|
|
|
SQL); |
|
1690
|
|
|
$this->addSql(<<<'SQL' |
|
1691
|
|
|
DROP TABLE stu_anomaly_type |
|
1692
|
|
|
SQL); |
|
1693
|
|
|
$this->addSql(<<<'SQL' |
|
1694
|
|
|
DROP TABLE stu_astro_entry |
|
1695
|
|
|
SQL); |
|
1696
|
|
|
$this->addSql(<<<'SQL' |
|
1697
|
|
|
DROP TABLE stu_auction_bid |
|
1698
|
|
|
SQL); |
|
1699
|
|
|
$this->addSql(<<<'SQL' |
|
1700
|
|
|
DROP TABLE stu_award |
|
1701
|
|
|
SQL); |
|
1702
|
|
|
$this->addSql(<<<'SQL' |
|
1703
|
|
|
DROP TABLE stu_basic_trade |
|
1704
|
|
|
SQL); |
|
1705
|
|
|
$this->addSql(<<<'SQL' |
|
1706
|
|
|
DROP TABLE stu_blocked_user |
|
1707
|
|
|
SQL); |
|
1708
|
|
|
$this->addSql(<<<'SQL' |
|
1709
|
|
|
DROP TABLE stu_buildings |
|
1710
|
|
|
SQL); |
|
1711
|
|
|
$this->addSql(<<<'SQL' |
|
1712
|
|
|
DROP TABLE stu_buildings_commodity |
|
1713
|
|
|
SQL); |
|
1714
|
|
|
$this->addSql(<<<'SQL' |
|
1715
|
|
|
DROP TABLE stu_buildings_cost |
|
1716
|
|
|
SQL); |
|
1717
|
|
|
$this->addSql(<<<'SQL' |
|
1718
|
|
|
DROP TABLE stu_buildings_field_alternative |
|
1719
|
|
|
SQL); |
|
1720
|
|
|
$this->addSql(<<<'SQL' |
|
1721
|
|
|
DROP TABLE stu_buildings_functions |
|
1722
|
|
|
SQL); |
|
1723
|
|
|
$this->addSql(<<<'SQL' |
|
1724
|
|
|
DROP TABLE stu_buildings_upgrades |
|
1725
|
|
|
SQL); |
|
1726
|
|
|
$this->addSql(<<<'SQL' |
|
1727
|
|
|
DROP TABLE stu_buildings_upgrades_cost |
|
1728
|
|
|
SQL); |
|
1729
|
|
|
$this->addSql(<<<'SQL' |
|
1730
|
|
|
DROP TABLE stu_buildplan |
|
1731
|
|
|
SQL); |
|
1732
|
|
|
$this->addSql(<<<'SQL' |
|
1733
|
|
|
DROP TABLE stu_buildplans_hangar |
|
1734
|
|
|
SQL); |
|
1735
|
|
|
$this->addSql(<<<'SQL' |
|
1736
|
|
|
DROP TABLE stu_buildplans_modules |
|
1737
|
|
|
SQL); |
|
1738
|
|
|
$this->addSql(<<<'SQL' |
|
1739
|
|
|
DROP TABLE stu_buoy |
|
1740
|
|
|
SQL); |
|
1741
|
|
|
$this->addSql(<<<'SQL' |
|
1742
|
|
|
DROP TABLE stu_colonies |
|
1743
|
|
|
SQL); |
|
1744
|
|
|
$this->addSql(<<<'SQL' |
|
1745
|
|
|
DROP TABLE stu_colonies_classes |
|
1746
|
|
|
SQL); |
|
1747
|
|
|
$this->addSql(<<<'SQL' |
|
1748
|
|
|
DROP TABLE stu_colonies_fielddata |
|
1749
|
|
|
SQL); |
|
1750
|
|
|
$this->addSql(<<<'SQL' |
|
1751
|
|
|
DROP TABLE stu_colonies_shipqueue |
|
1752
|
|
|
SQL); |
|
1753
|
|
|
$this->addSql(<<<'SQL' |
|
1754
|
|
|
DROP TABLE stu_colonies_shiprepair |
|
1755
|
|
|
SQL); |
|
1756
|
|
|
$this->addSql(<<<'SQL' |
|
1757
|
|
|
DROP TABLE stu_colonies_terraforming |
|
1758
|
|
|
SQL); |
|
1759
|
|
|
$this->addSql(<<<'SQL' |
|
1760
|
|
|
DROP TABLE stu_colony_class_deposit |
|
1761
|
|
|
SQL); |
|
1762
|
|
|
$this->addSql(<<<'SQL' |
|
1763
|
|
|
DROP TABLE stu_colony_class_restriction |
|
1764
|
|
|
SQL); |
|
1765
|
|
|
$this->addSql(<<<'SQL' |
|
1766
|
|
|
DROP TABLE stu_colony_deposit_mining |
|
1767
|
|
|
SQL); |
|
1768
|
|
|
$this->addSql(<<<'SQL' |
|
1769
|
|
|
DROP TABLE stu_colony_fieldtype |
|
1770
|
|
|
SQL); |
|
1771
|
|
|
$this->addSql(<<<'SQL' |
|
1772
|
|
|
DROP TABLE stu_colony_sandbox |
|
1773
|
|
|
SQL); |
|
1774
|
|
|
$this->addSql(<<<'SQL' |
|
1775
|
|
|
DROP TABLE stu_colony_scan |
|
1776
|
|
|
SQL); |
|
1777
|
|
|
$this->addSql(<<<'SQL' |
|
1778
|
|
|
DROP TABLE stu_commodity |
|
1779
|
|
|
SQL); |
|
1780
|
|
|
$this->addSql(<<<'SQL' |
|
1781
|
|
|
DROP TABLE stu_construction_progress |
|
1782
|
|
|
SQL); |
|
1783
|
|
|
$this->addSql(<<<'SQL' |
|
1784
|
|
|
DROP TABLE stu_contactlist |
|
1785
|
|
|
SQL); |
|
1786
|
|
|
$this->addSql(<<<'SQL' |
|
1787
|
|
|
DROP TABLE stu_crew |
|
1788
|
|
|
SQL); |
|
1789
|
|
|
$this->addSql(<<<'SQL' |
|
1790
|
|
|
DROP TABLE stu_crew_assign |
|
1791
|
|
|
SQL); |
|
1792
|
|
|
$this->addSql(<<<'SQL' |
|
1793
|
|
|
DROP TABLE stu_crew_race |
|
1794
|
|
|
SQL); |
|
1795
|
|
|
$this->addSql(<<<'SQL' |
|
1796
|
|
|
DROP TABLE stu_crew_training |
|
1797
|
|
|
SQL); |
|
1798
|
|
|
$this->addSql(<<<'SQL' |
|
1799
|
|
|
DROP TABLE stu_database_categories |
|
1800
|
|
|
SQL); |
|
1801
|
|
|
$this->addSql(<<<'SQL' |
|
1802
|
|
|
DROP TABLE stu_database_category_awards |
|
1803
|
|
|
SQL); |
|
1804
|
|
|
$this->addSql(<<<'SQL' |
|
1805
|
|
|
DROP TABLE stu_database_entrys |
|
1806
|
|
|
SQL); |
|
1807
|
|
|
$this->addSql(<<<'SQL' |
|
1808
|
|
|
DROP TABLE stu_database_types |
|
1809
|
|
|
SQL); |
|
1810
|
|
|
$this->addSql(<<<'SQL' |
|
1811
|
|
|
DROP TABLE stu_database_user |
|
1812
|
|
|
SQL); |
|
1813
|
|
|
$this->addSql(<<<'SQL' |
|
1814
|
|
|
DROP TABLE stu_deals |
|
1815
|
|
|
SQL); |
|
1816
|
|
|
$this->addSql(<<<'SQL' |
|
1817
|
|
|
DROP TABLE stu_dockingrights |
|
1818
|
|
|
SQL); |
|
1819
|
|
|
$this->addSql(<<<'SQL' |
|
1820
|
|
|
DROP TABLE stu_factions |
|
1821
|
|
|
SQL); |
|
1822
|
|
|
$this->addSql(<<<'SQL' |
|
1823
|
|
|
DROP TABLE stu_field_build |
|
1824
|
|
|
SQL); |
|
1825
|
|
|
$this->addSql(<<<'SQL' |
|
1826
|
|
|
DROP TABLE stu_fleets |
|
1827
|
|
|
SQL); |
|
1828
|
|
|
$this->addSql(<<<'SQL' |
|
1829
|
|
|
DROP TABLE stu_flight_sig |
|
1830
|
|
|
SQL); |
|
1831
|
|
|
$this->addSql(<<<'SQL' |
|
1832
|
|
|
DROP TABLE stu_game_config |
|
1833
|
|
|
SQL); |
|
1834
|
|
|
$this->addSql(<<<'SQL' |
|
1835
|
|
|
DROP TABLE stu_game_request |
|
1836
|
|
|
SQL); |
|
1837
|
|
|
$this->addSql(<<<'SQL' |
|
1838
|
|
|
DROP TABLE stu_game_turn_stats |
|
1839
|
|
|
SQL); |
|
1840
|
|
|
$this->addSql(<<<'SQL' |
|
1841
|
|
|
DROP TABLE stu_game_turns |
|
1842
|
|
|
SQL); |
|
1843
|
|
|
$this->addSql(<<<'SQL' |
|
1844
|
|
|
DROP TABLE stu_history |
|
1845
|
|
|
SQL); |
|
1846
|
|
|
$this->addSql(<<<'SQL' |
|
1847
|
|
|
DROP TABLE stu_ignorelist |
|
1848
|
|
|
SQL); |
|
1849
|
|
|
$this->addSql(<<<'SQL' |
|
1850
|
|
|
DROP TABLE stu_kn |
|
1851
|
|
|
SQL); |
|
1852
|
|
|
$this->addSql(<<<'SQL' |
|
1853
|
|
|
DROP TABLE stu_kn_archiv |
|
1854
|
|
|
SQL); |
|
1855
|
|
|
$this->addSql(<<<'SQL' |
|
1856
|
|
|
DROP TABLE stu_kn_character |
|
1857
|
|
|
SQL); |
|
1858
|
|
|
$this->addSql(<<<'SQL' |
|
1859
|
|
|
DROP TABLE stu_kn_comments |
|
1860
|
|
|
SQL); |
|
1861
|
|
|
$this->addSql(<<<'SQL' |
|
1862
|
|
|
DROP TABLE stu_kn_comments_archiv |
|
1863
|
|
|
SQL); |
|
1864
|
|
|
$this->addSql(<<<'SQL' |
|
1865
|
|
|
DROP TABLE stu_kn_plot_application |
|
1866
|
|
|
SQL); |
|
1867
|
|
|
$this->addSql(<<<'SQL' |
|
1868
|
|
|
DROP TABLE stu_layer |
|
1869
|
|
|
SQL); |
|
1870
|
|
|
$this->addSql(<<<'SQL' |
|
1871
|
|
|
DROP TABLE stu_location |
|
1872
|
|
|
SQL); |
|
1873
|
|
|
$this->addSql(<<<'SQL' |
|
1874
|
|
|
DROP TABLE stu_location_mining |
|
1875
|
|
|
SQL); |
|
1876
|
|
|
$this->addSql(<<<'SQL' |
|
1877
|
|
|
DROP TABLE stu_lottery_buildplan |
|
1878
|
|
|
SQL); |
|
1879
|
|
|
$this->addSql(<<<'SQL' |
|
1880
|
|
|
DROP TABLE stu_lottery_ticket |
|
1881
|
|
|
SQL); |
|
1882
|
|
|
$this->addSql(<<<'SQL' |
|
1883
|
|
|
DROP TABLE stu_map |
|
1884
|
|
|
SQL); |
|
1885
|
|
|
$this->addSql(<<<'SQL' |
|
1886
|
|
|
DROP TABLE stu_map_bordertypes |
|
1887
|
|
|
SQL); |
|
1888
|
|
|
$this->addSql(<<<'SQL' |
|
1889
|
|
|
DROP TABLE stu_map_ftypes |
|
1890
|
|
|
SQL); |
|
1891
|
|
|
$this->addSql(<<<'SQL' |
|
1892
|
|
|
DROP TABLE stu_map_regions |
|
1893
|
|
|
SQL); |
|
1894
|
|
|
$this->addSql(<<<'SQL' |
|
1895
|
|
|
DROP TABLE stu_map_regions_settlement |
|
1896
|
|
|
SQL); |
|
1897
|
|
|
$this->addSql(<<<'SQL' |
|
1898
|
|
|
DROP TABLE stu_mass_center_type |
|
1899
|
|
|
SQL); |
|
1900
|
|
|
$this->addSql(<<<'SQL' |
|
1901
|
|
|
DROP TABLE stu_mining_queue |
|
1902
|
|
|
SQL); |
|
1903
|
|
|
$this->addSql(<<<'SQL' |
|
1904
|
|
|
DROP TABLE stu_modules |
|
1905
|
|
|
SQL); |
|
1906
|
|
|
$this->addSql(<<<'SQL' |
|
1907
|
|
|
DROP TABLE stu_modules_buildingfunction |
|
1908
|
|
|
SQL); |
|
1909
|
|
|
$this->addSql(<<<'SQL' |
|
1910
|
|
|
DROP TABLE stu_modules_cost |
|
1911
|
|
|
SQL); |
|
1912
|
|
|
$this->addSql(<<<'SQL' |
|
1913
|
|
|
DROP TABLE stu_modules_queue |
|
1914
|
|
|
SQL); |
|
1915
|
|
|
$this->addSql(<<<'SQL' |
|
1916
|
|
|
DROP TABLE stu_modules_specials |
|
1917
|
|
|
SQL); |
|
1918
|
|
|
$this->addSql(<<<'SQL' |
|
1919
|
|
|
DROP TABLE stu_names |
|
1920
|
|
|
SQL); |
|
1921
|
|
|
$this->addSql(<<<'SQL' |
|
1922
|
|
|
DROP TABLE stu_news |
|
1923
|
|
|
SQL); |
|
1924
|
|
|
$this->addSql(<<<'SQL' |
|
1925
|
|
|
DROP TABLE stu_notes |
|
1926
|
|
|
SQL); |
|
1927
|
|
|
$this->addSql(<<<'SQL' |
|
1928
|
|
|
DROP TABLE stu_npc_log |
|
1929
|
|
|
SQL); |
|
1930
|
|
|
$this->addSql(<<<'SQL' |
|
1931
|
|
|
DROP TABLE stu_opened_advent_door |
|
1932
|
|
|
SQL); |
|
1933
|
|
|
$this->addSql(<<<'SQL' |
|
1934
|
|
|
DROP TABLE stu_partnersite |
|
1935
|
|
|
SQL); |
|
1936
|
|
|
$this->addSql(<<<'SQL' |
|
1937
|
|
|
DROP TABLE stu_pirate_setup |
|
1938
|
|
|
SQL); |
|
1939
|
|
|
$this->addSql(<<<'SQL' |
|
1940
|
|
|
DROP TABLE stu_pirate_setup_buildplan |
|
1941
|
|
|
SQL); |
|
1942
|
|
|
$this->addSql(<<<'SQL' |
|
1943
|
|
|
DROP TABLE stu_pirate_wrath |
|
1944
|
|
|
SQL); |
|
1945
|
|
|
$this->addSql(<<<'SQL' |
|
1946
|
|
|
DROP TABLE stu_planet_type_research |
|
1947
|
|
|
SQL); |
|
1948
|
|
|
$this->addSql(<<<'SQL' |
|
1949
|
|
|
DROP TABLE stu_planets_commodity |
|
1950
|
|
|
SQL); |
|
1951
|
|
|
$this->addSql(<<<'SQL' |
|
1952
|
|
|
DROP TABLE stu_plots |
|
1953
|
|
|
SQL); |
|
1954
|
|
|
$this->addSql(<<<'SQL' |
|
1955
|
|
|
DROP TABLE stu_plots_archiv |
|
1956
|
|
|
SQL); |
|
1957
|
|
|
$this->addSql(<<<'SQL' |
|
1958
|
|
|
DROP TABLE stu_plots_members |
|
1959
|
|
|
SQL); |
|
1960
|
|
|
$this->addSql(<<<'SQL' |
|
1961
|
|
|
DROP TABLE stu_plots_members_archiv |
|
1962
|
|
|
SQL); |
|
1963
|
|
|
$this->addSql(<<<'SQL' |
|
1964
|
|
|
DROP TABLE stu_pm_cats |
|
1965
|
|
|
SQL); |
|
1966
|
|
|
$this->addSql(<<<'SQL' |
|
1967
|
|
|
DROP TABLE stu_pms |
|
1968
|
|
|
SQL); |
|
1969
|
|
|
$this->addSql(<<<'SQL' |
|
1970
|
|
|
DROP TABLE stu_prestige_log |
|
1971
|
|
|
SQL); |
|
1972
|
|
|
$this->addSql(<<<'SQL' |
|
1973
|
|
|
DROP TABLE stu_progress_module |
|
1974
|
|
|
SQL); |
|
1975
|
|
|
$this->addSql(<<<'SQL' |
|
1976
|
|
|
DROP TABLE stu_repair_task |
|
1977
|
|
|
SQL); |
|
1978
|
|
|
$this->addSql(<<<'SQL' |
|
1979
|
|
|
DROP TABLE stu_research |
|
1980
|
|
|
SQL); |
|
1981
|
|
|
$this->addSql(<<<'SQL' |
|
1982
|
|
|
DROP TABLE stu_research_dependencies |
|
1983
|
|
|
SQL); |
|
1984
|
|
|
$this->addSql(<<<'SQL' |
|
1985
|
|
|
DROP TABLE stu_researched |
|
1986
|
|
|
SQL); |
|
1987
|
|
|
$this->addSql(<<<'SQL' |
|
1988
|
|
|
DROP TABLE stu_rump |
|
1989
|
|
|
SQL); |
|
1990
|
|
|
$this->addSql(<<<'SQL' |
|
1991
|
|
|
DROP TABLE stu_rump_costs |
|
1992
|
|
|
SQL); |
|
1993
|
|
|
$this->addSql(<<<'SQL' |
|
1994
|
|
|
DROP TABLE stu_rumps_buildingfunction |
|
1995
|
|
|
SQL); |
|
1996
|
|
|
$this->addSql(<<<'SQL' |
|
1997
|
|
|
DROP TABLE stu_rumps_cat_role_crew |
|
1998
|
|
|
SQL); |
|
1999
|
|
|
$this->addSql(<<<'SQL' |
|
2000
|
|
|
DROP TABLE stu_rumps_categories |
|
2001
|
|
|
SQL); |
|
2002
|
|
|
$this->addSql(<<<'SQL' |
|
2003
|
|
|
DROP TABLE stu_rumps_colonize_building |
|
2004
|
|
|
SQL); |
|
2005
|
|
|
$this->addSql(<<<'SQL' |
|
2006
|
|
|
DROP TABLE stu_rumps_module_level |
|
2007
|
|
|
SQL); |
|
2008
|
|
|
$this->addSql(<<<'SQL' |
|
2009
|
|
|
DROP TABLE stu_rumps_module_special |
|
2010
|
|
|
SQL); |
|
2011
|
|
|
$this->addSql(<<<'SQL' |
|
2012
|
|
|
DROP TABLE stu_rumps_roles |
|
2013
|
|
|
SQL); |
|
2014
|
|
|
$this->addSql(<<<'SQL' |
|
2015
|
|
|
DROP TABLE stu_rumps_specials |
|
2016
|
|
|
SQL); |
|
2017
|
|
|
$this->addSql(<<<'SQL' |
|
2018
|
|
|
DROP TABLE stu_rumps_user |
|
2019
|
|
|
SQL); |
|
2020
|
|
|
$this->addSql(<<<'SQL' |
|
2021
|
|
|
DROP TABLE stu_session_strings |
|
2022
|
|
|
SQL); |
|
2023
|
|
|
$this->addSql(<<<'SQL' |
|
2024
|
|
|
DROP TABLE stu_ship |
|
2025
|
|
|
SQL); |
|
2026
|
|
|
$this->addSql(<<<'SQL' |
|
2027
|
|
|
DROP TABLE stu_ship_log |
|
2028
|
|
|
SQL); |
|
2029
|
|
|
$this->addSql(<<<'SQL' |
|
2030
|
|
|
DROP TABLE stu_ship_takeover |
|
2031
|
|
|
SQL); |
|
2032
|
|
|
$this->addSql(<<<'SQL' |
|
2033
|
|
|
DROP TABLE stu_shipyard_shipqueue |
|
2034
|
|
|
SQL); |
|
2035
|
|
|
$this->addSql(<<<'SQL' |
|
2036
|
|
|
DROP TABLE stu_spacecraft |
|
2037
|
|
|
SQL); |
|
2038
|
|
|
$this->addSql(<<<'SQL' |
|
2039
|
|
|
DROP TABLE stu_spacecraft_emergency |
|
2040
|
|
|
SQL); |
|
2041
|
|
|
$this->addSql(<<<'SQL' |
|
2042
|
|
|
DROP TABLE stu_spacecraft_system |
|
2043
|
|
|
SQL); |
|
2044
|
|
|
$this->addSql(<<<'SQL' |
|
2045
|
|
|
DROP TABLE stu_station |
|
2046
|
|
|
SQL); |
|
2047
|
|
|
$this->addSql(<<<'SQL' |
|
2048
|
|
|
DROP TABLE stu_station_shiprepair |
|
2049
|
|
|
SQL); |
|
2050
|
|
|
$this->addSql(<<<'SQL' |
|
2051
|
|
|
DROP TABLE stu_storage |
|
2052
|
|
|
SQL); |
|
2053
|
|
|
$this->addSql(<<<'SQL' |
|
2054
|
|
|
DROP TABLE stu_sys_map |
|
2055
|
|
|
SQL); |
|
2056
|
|
|
$this->addSql(<<<'SQL' |
|
2057
|
|
|
DROP TABLE stu_system_types |
|
2058
|
|
|
SQL); |
|
2059
|
|
|
$this->addSql(<<<'SQL' |
|
2060
|
|
|
DROP TABLE stu_systems |
|
2061
|
|
|
SQL); |
|
2062
|
|
|
$this->addSql(<<<'SQL' |
|
2063
|
|
|
DROP TABLE stu_tachyon_scan |
|
2064
|
|
|
SQL); |
|
2065
|
|
|
$this->addSql(<<<'SQL' |
|
2066
|
|
|
DROP TABLE stu_terraforming |
|
2067
|
|
|
SQL); |
|
2068
|
|
|
$this->addSql(<<<'SQL' |
|
2069
|
|
|
DROP TABLE stu_terraforming_cost |
|
2070
|
|
|
SQL); |
|
2071
|
|
|
$this->addSql(<<<'SQL' |
|
2072
|
|
|
DROP TABLE stu_tholian_web |
|
2073
|
|
|
SQL); |
|
2074
|
|
|
$this->addSql(<<<'SQL' |
|
2075
|
|
|
DROP TABLE stu_torpedo_cost |
|
2076
|
|
|
SQL); |
|
2077
|
|
|
$this->addSql(<<<'SQL' |
|
2078
|
|
|
DROP TABLE stu_torpedo_hull |
|
2079
|
|
|
SQL); |
|
2080
|
|
|
$this->addSql(<<<'SQL' |
|
2081
|
|
|
DROP TABLE stu_torpedo_storage |
|
2082
|
|
|
SQL); |
|
2083
|
|
|
$this->addSql(<<<'SQL' |
|
2084
|
|
|
DROP TABLE stu_torpedo_types |
|
2085
|
|
|
SQL); |
|
2086
|
|
|
$this->addSql(<<<'SQL' |
|
2087
|
|
|
DROP TABLE stu_trade_license |
|
2088
|
|
|
SQL); |
|
2089
|
|
|
$this->addSql(<<<'SQL' |
|
2090
|
|
|
DROP TABLE stu_trade_license_info |
|
2091
|
|
|
SQL); |
|
2092
|
|
|
$this->addSql(<<<'SQL' |
|
2093
|
|
|
DROP TABLE stu_trade_offers |
|
2094
|
|
|
SQL); |
|
2095
|
|
|
$this->addSql(<<<'SQL' |
|
2096
|
|
|
DROP TABLE stu_trade_posts |
|
2097
|
|
|
SQL); |
|
2098
|
|
|
$this->addSql(<<<'SQL' |
|
2099
|
|
|
DROP TABLE stu_trade_shoutbox |
|
2100
|
|
|
SQL); |
|
2101
|
|
|
$this->addSql(<<<'SQL' |
|
2102
|
|
|
DROP TABLE stu_trade_transaction |
|
2103
|
|
|
SQL); |
|
2104
|
|
|
$this->addSql(<<<'SQL' |
|
2105
|
|
|
DROP TABLE stu_trade_transfers |
|
2106
|
|
|
SQL); |
|
2107
|
|
|
$this->addSql(<<<'SQL' |
|
2108
|
|
|
DROP TABLE stu_trumfield |
|
2109
|
|
|
SQL); |
|
2110
|
|
|
$this->addSql(<<<'SQL' |
|
2111
|
|
|
DROP TABLE stu_tutorial_step |
|
2112
|
|
|
SQL); |
|
2113
|
|
|
$this->addSql(<<<'SQL' |
|
2114
|
|
|
DROP TABLE stu_user |
|
2115
|
|
|
SQL); |
|
2116
|
|
|
$this->addSql(<<<'SQL' |
|
2117
|
|
|
DROP TABLE stu_user_award |
|
2118
|
|
|
SQL); |
|
2119
|
|
|
$this->addSql(<<<'SQL' |
|
2120
|
|
|
DROP TABLE stu_user_character |
|
2121
|
|
|
SQL); |
|
2122
|
|
|
$this->addSql(<<<'SQL' |
|
2123
|
|
|
DROP TABLE stu_user_invitations |
|
2124
|
|
|
SQL); |
|
2125
|
|
|
$this->addSql(<<<'SQL' |
|
2126
|
|
|
DROP TABLE stu_user_iptable |
|
2127
|
|
|
SQL); |
|
2128
|
|
|
$this->addSql(<<<'SQL' |
|
2129
|
|
|
DROP TABLE stu_user_layer |
|
2130
|
|
|
SQL); |
|
2131
|
|
|
$this->addSql(<<<'SQL' |
|
2132
|
|
|
DROP TABLE stu_user_lock |
|
2133
|
|
|
SQL); |
|
2134
|
|
|
$this->addSql(<<<'SQL' |
|
2135
|
|
|
DROP TABLE stu_user_map |
|
2136
|
|
|
SQL); |
|
2137
|
|
|
$this->addSql(<<<'SQL' |
|
2138
|
|
|
DROP TABLE stu_user_profile_visitors |
|
2139
|
|
|
SQL); |
|
2140
|
|
|
$this->addSql(<<<'SQL' |
|
2141
|
|
|
DROP TABLE stu_user_referer |
|
2142
|
|
|
SQL); |
|
2143
|
|
|
$this->addSql(<<<'SQL' |
|
2144
|
|
|
DROP TABLE stu_user_setting |
|
2145
|
|
|
SQL); |
|
2146
|
|
|
$this->addSql(<<<'SQL' |
|
2147
|
|
|
DROP TABLE stu_user_tag |
|
2148
|
|
|
SQL); |
|
2149
|
|
|
$this->addSql(<<<'SQL' |
|
2150
|
|
|
DROP TABLE stu_user_tutorial |
|
2151
|
|
|
SQL); |
|
2152
|
|
|
$this->addSql(<<<'SQL' |
|
2153
|
|
|
DROP TABLE stu_weapon_shield |
|
2154
|
|
|
SQL); |
|
2155
|
|
|
$this->addSql(<<<'SQL' |
|
2156
|
|
|
DROP TABLE stu_weapons |
|
2157
|
|
|
SQL); |
|
2158
|
|
|
$this->addSql(<<<'SQL' |
|
2159
|
|
|
DROP TABLE stu_wormhole_entry |
|
2160
|
|
|
SQL); |
|
2161
|
|
|
$this->addSql(<<<'SQL' |
|
2162
|
|
|
DROP TABLE stu_wormhole_restrictions |
|
2163
|
|
|
SQL); |
|
2164
|
|
|
} |
|
2165
|
|
|
} |
|
2166
|
|
|
|
st-universe /
core
