· 5 years ago · Feb 05, 2020, 11:22 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 11.6 (Ubuntu 11.6-1.pgdg18.04+1)
6-- Dumped by pg_dump version 11.6 (Ubuntu 11.6-1.pgdg18.04+1)
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET xmloption = content;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- Name: pg_stat_statements; Type: EXTENSION; Schema: -; Owner:
21--
22
23CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;
24
25
26--
27-- Name: EXTENSION pg_stat_statements; Type: COMMENT; Schema: -; Owner:
28--
29
30COMMENT ON EXTENSION pg_stat_statements IS 'track execution statistics of all SQL statements executed';
31
32
33SET default_tablespace = '';
34
35SET default_with_oids = false;
36
37--
38-- Name: cell_flag; Type: TABLE; Schema: public; Owner: blitz
39--
40
41CREATE TABLE public.cell_flag (
42 guild_id integer NOT NULL,
43 war_id integer NOT NULL,
44 tick_number integer NOT NULL,
45 room_number integer NOT NULL,
46 cell_x integer NOT NULL,
47 cell_y integer NOT NULL,
48 flag_type character varying NOT NULL
49);
50
51
52ALTER TABLE public.cell_flag OWNER TO blitz;
53
54--
55-- Name: cell_state; Type: TABLE; Schema: public; Owner: blitz
56--
57
58CREATE TABLE public.cell_state (
59 war_id integer NOT NULL,
60 cell_x integer NOT NULL,
61 cell_y integer NOT NULL,
62 tick_number integer NOT NULL,
63 room_number integer NOT NULL,
64 guild_id integer,
65 power integer NOT NULL,
66 base_id integer,
67 landmark_id integer,
68 under_control integer
69);
70
71
72ALTER TABLE public.cell_state OWNER TO blitz;
73
74--
75-- Name: elixir_spent; Type: TABLE; Schema: public; Owner: blitz
76--
77
78CREATE TABLE public.elixir_spent (
79 profile_id character varying NOT NULL,
80 guild_id integer NOT NULL,
81 war_id integer NOT NULL,
82 day integer NOT NULL,
83 spent integer NOT NULL
84);
85
86
87ALTER TABLE public.elixir_spent OWNER TO blitz;
88
89--
90-- Name: guild_cell_discovered; Type: TABLE; Schema: public; Owner: blitz
91--
92
93CREATE TABLE public.guild_cell_discovered (
94 war_id integer NOT NULL,
95 cell_x integer NOT NULL,
96 cell_y integer NOT NULL,
97 tick_number integer NOT NULL,
98 room_number integer NOT NULL,
99 guild_id integer NOT NULL,
100 times_discovered integer NOT NULL,
101 discovered_on timestamp without time zone NOT NULL
102);
103
104
105ALTER TABLE public.guild_cell_discovered OWNER TO blitz;
106
107--
108-- Name: guild_cell_hidden; Type: TABLE; Schema: public; Owner: blitz
109--
110
111CREATE TABLE public.guild_cell_hidden (
112 war_id integer NOT NULL,
113 cell_x integer NOT NULL,
114 cell_y integer NOT NULL,
115 tick_number integer NOT NULL,
116 room_number integer NOT NULL,
117 guild_id integer NOT NULL,
118 hidden boolean NOT NULL,
119 times_hidden integer NOT NULL,
120 hidden_on timestamp without time zone DEFAULT now() NOT NULL
121);
122
123
124ALTER TABLE public.guild_cell_hidden OWNER TO blitz;
125
126--
127-- Name: guild_riots_data; Type: TABLE; Schema: public; Owner: blitz
128--
129
130CREATE TABLE public.guild_riots_data (
131 war_id integer NOT NULL,
132 guild_id integer NOT NULL,
133 tick_number integer NOT NULL,
134 room_number integer NOT NULL,
135 max_riots integer NOT NULL,
136 data jsonb NOT NULL
137);
138
139
140ALTER TABLE public.guild_riots_data OWNER TO blitz;
141
142--
143-- Name: guild_war; Type: TABLE; Schema: public; Owner: blitz
144--
145
146CREATE TABLE public.guild_war (
147 id integer NOT NULL,
148 start_datetime timestamp without time zone NOT NULL,
149 end_datetime timestamp without time zone NOT NULL,
150 finished boolean NOT NULL,
151 current_tick_number integer NOT NULL,
152 current_day integer NOT NULL,
153 is_qa_war boolean NOT NULL,
154 prev_war_id integer,
155 map_dimension_x integer NOT NULL,
156 map_dimension_y integer NOT NULL,
157 duration_days integer NOT NULL,
158 reward_time_hour integer NOT NULL,
159 end_tick_hours integer[],
160 cooldown integer NOT NULL
161);
162
163
164ALTER TABLE public.guild_war OWNER TO blitz;
165
166--
167-- Name: guild_war_id_seq; Type: SEQUENCE; Schema: public; Owner: blitz
168--
169
170CREATE SEQUENCE public.guild_war_id_seq
171 START WITH 1
172 INCREMENT BY 1
173 NO MINVALUE
174 NO MAXVALUE
175 CACHE 1;
176
177
178ALTER TABLE public.guild_war_id_seq OWNER TO blitz;
179
180--
181-- Name: player_force; Type: TABLE; Schema: public; Owner: blitz
182--
183
184CREATE TABLE public.player_force (
185 profile_id character varying NOT NULL,
186 war_id integer NOT NULL,
187 tick_number integer NOT NULL,
188 day integer NOT NULL,
189 room_number integer NOT NULL,
190 cell_x integer NOT NULL,
191 cell_y integer NOT NULL,
192 guild_id integer NOT NULL,
193 power integer NOT NULL,
194 pure_power integer NOT NULL,
195 monster_ids integer[] NOT NULL
196);
197
198
199ALTER TABLE public.player_force OWNER TO blitz;
200
201--
202-- Name: power_boost; Type: TABLE; Schema: public; Owner: blitz
203--
204
205CREATE TABLE public.power_boost (
206 profile_id character varying NOT NULL,
207 war_id integer NOT NULL,
208 tick_number integer NOT NULL,
209 cell_x integer NOT NULL,
210 cell_y integer NOT NULL,
211 guild_id integer NOT NULL,
212 room_number integer NOT NULL,
213 boost_multiplier double precision NOT NULL
214);
215
216
217ALTER TABLE public.power_boost OWNER TO blitz;
218
219--
220-- Name: cell_flag cell_flag_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
221--
222
223ALTER TABLE ONLY public.cell_flag
224 ADD CONSTRAINT cell_flag_pkey PRIMARY KEY (guild_id, war_id, tick_number, room_number, cell_x, cell_y);
225
226
227--
228-- Name: elixir_spent elixir_spent_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
229--
230
231ALTER TABLE ONLY public.elixir_spent
232 ADD CONSTRAINT elixir_spent_pkey PRIMARY KEY (profile_id, guild_id, war_id, day);
233
234
235--
236-- Name: guild_riots_data guild_riots_data_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
237--
238
239ALTER TABLE ONLY public.guild_riots_data
240 ADD CONSTRAINT guild_riots_data_pkey PRIMARY KEY (war_id, guild_id, tick_number);
241
242
243--
244-- Name: guild_war guild_war_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
245--
246
247ALTER TABLE ONLY public.guild_war
248 ADD CONSTRAINT guild_war_pkey PRIMARY KEY (id);
249
250
251--
252-- Name: cell_state pk_cell_state; Type: CONSTRAINT; Schema: public; Owner: blitz
253--
254
255ALTER TABLE ONLY public.cell_state
256 ADD CONSTRAINT pk_cell_state PRIMARY KEY (war_id, cell_x, cell_y, tick_number, room_number);
257
258
259--
260-- Name: guild_cell_discovered pk_guild_cell_discovered; Type: CONSTRAINT; Schema: public; Owner: blitz
261--
262
263ALTER TABLE ONLY public.guild_cell_discovered
264 ADD CONSTRAINT pk_guild_cell_discovered PRIMARY KEY (war_id, cell_x, cell_y, tick_number, room_number, guild_id);
265
266
267--
268-- Name: guild_cell_hidden pk_guild_cell_hidden; Type: CONSTRAINT; Schema: public; Owner: blitz
269--
270
271ALTER TABLE ONLY public.guild_cell_hidden
272 ADD CONSTRAINT pk_guild_cell_hidden PRIMARY KEY (war_id, cell_x, cell_y, tick_number, room_number, guild_id);
273
274
275--
276-- Name: player_force player_force_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
277--
278
279ALTER TABLE ONLY public.player_force
280 ADD CONSTRAINT player_force_pkey PRIMARY KEY (profile_id, war_id, tick_number, cell_x, cell_y);
281
282
283--
284-- Name: power_boost power_boost_pkey; Type: CONSTRAINT; Schema: public; Owner: blitz
285--
286
287ALTER TABLE ONLY public.power_boost
288 ADD CONSTRAINT power_boost_pkey PRIMARY KEY (profile_id, war_id, tick_number, cell_x, cell_y);
289
290
291--
292-- Name: cell_state_war_id_room_number_tick_number_idx; Type: INDEX; Schema: public; Owner: blitz
293--
294
295CREATE INDEX cell_state_war_id_room_number_tick_number_idx ON public.cell_state USING btree (war_id, room_number, tick_number);
296
297
298--
299-- Name: elixir_spent_guild_id_war_id_day_idx; Type: INDEX; Schema: public; Owner: blitz
300--
301
302CREATE INDEX elixir_spent_guild_id_war_id_day_idx ON public.elixir_spent USING btree (guild_id, war_id, day);
303
304
305--
306-- Name: guild_cell_discovered_war_id_tick_number_room_number_idx; Type: INDEX; Schema: public; Owner: blitz
307--
308
309CREATE INDEX guild_cell_discovered_war_id_tick_number_room_number_idx ON public.guild_cell_discovered USING btree (war_id, tick_number, room_number);
310
311
312--
313-- Name: player_force_war_id_guild_id_day_idx; Type: INDEX; Schema: public; Owner: blitz
314--
315
316CREATE INDEX player_force_war_id_guild_id_day_idx ON public.player_force USING btree (war_id, guild_id, day);
317
318
319--
320-- Name: player_force_war_id_room_number_tick_number; Type: INDEX; Schema: public; Owner: blitz
321--
322
323CREATE INDEX player_force_war_id_room_number_tick_number ON public.player_force USING btree (war_id, room_number, tick_number);
324
325
326--
327-- Name: cell_flag cell_flag_war_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blitz
328--
329
330ALTER TABLE ONLY public.cell_flag
331 ADD CONSTRAINT cell_flag_war_id_fkey FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
332
333
334--
335-- Name: elixir_spent elixir_spent_war_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blitz
336--
337
338ALTER TABLE ONLY public.elixir_spent
339 ADD CONSTRAINT elixir_spent_war_id_fkey FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
340
341
342--
343-- Name: guild_cell_hidden fk_guild_war_id; Type: FK CONSTRAINT; Schema: public; Owner: blitz
344--
345
346ALTER TABLE ONLY public.guild_cell_hidden
347 ADD CONSTRAINT fk_guild_war_id FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
348
349
350--
351-- Name: guild_cell_discovered fk_guild_war_id; Type: FK CONSTRAINT; Schema: public; Owner: blitz
352--
353
354ALTER TABLE ONLY public.guild_cell_discovered
355 ADD CONSTRAINT fk_guild_war_id FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
356
357
358--
359-- Name: cell_state fk_guild_war_id; Type: FK CONSTRAINT; Schema: public; Owner: blitz
360--
361
362ALTER TABLE ONLY public.cell_state
363 ADD CONSTRAINT fk_guild_war_id FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
364
365
366--
367-- Name: guild_riots_data guild_riots_data_war_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blitz
368--
369
370ALTER TABLE ONLY public.guild_riots_data
371 ADD CONSTRAINT guild_riots_data_war_id_fkey FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
372
373
374--
375-- Name: player_force player_force_war_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blitz
376--
377
378ALTER TABLE ONLY public.player_force
379 ADD CONSTRAINT player_force_war_id_fkey FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
380
381
382--
383-- Name: power_boost power_boost_war_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: blitz
384--
385
386ALTER TABLE ONLY public.power_boost
387 ADD CONSTRAINT power_boost_war_id_fkey FOREIGN KEY (war_id) REFERENCES public.guild_war(id) ON DELETE CASCADE;
388
389
390--
391-- PostgreSQL database dump complete
392--