-
Notifications
You must be signed in to change notification settings - Fork 7
Expand file tree
/
Copy pathdatabase.sql
More file actions
385 lines (262 loc) · 8.32 KB
/
database.sql
File metadata and controls
385 lines (262 loc) · 8.32 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
--
-- PostgreSQL database dump
--
-- Dumped from database version 10.3 (Debian 10.3-1.pgdg90+1)
-- Dumped by pg_dump version 10.1
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
SET search_path = public, pg_catalog;
SET default_with_oids = false;
--
-- Name: accounts; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE accounts (
id integer NOT NULL,
login character varying(64) NOT NULL,
display_name character varying(64) NOT NULL,
password character varying(64) NOT NULL,
password_salt character varying(64) NOT NULL,
email character varying(64) NOT NULL,
creation_date timestamp without time zone NOT NULL,
last_login_date timestamp without time zone,
permission_level smallint DEFAULT 10 NOT NULL
);
--
-- Name: account_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE account_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE account_id_seq OWNED BY accounts.id;
--
-- Name: collision_meshes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE collision_meshes (
id integer NOT NULL,
file_path character varying(255) NOT NULL
);
--
-- Name: collision_mesh_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE collision_mesh_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: collision_mesh_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE collision_mesh_id_seq OWNED BY collision_meshes.id;
--
-- Name: modules; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE modules (
id integer NOT NULL,
class_name character varying(64) NOT NULL,
class_info json NOT NULL,
name character varying(64) NOT NULL,
description text
);
--
-- Name: modules_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE modules_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: modules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE modules_id_seq OWNED BY modules.id;
--
-- Name: spaceship_hulls; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE spaceship_hulls (
id integer NOT NULL,
name character varying NOT NULL,
description text,
collision_mesh integer NOT NULL,
visual_mesh integer NOT NULL
);
--
-- Name: spaceship_hull_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE spaceship_hull_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: spaceship_hull_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE spaceship_hull_id_seq OWNED BY spaceship_hulls.id;
--
-- Name: spaceships; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE spaceships (
id integer NOT NULL,
name character varying(64) NOT NULL,
script text,
owner_id integer,
last_update_date timestamp without time zone,
spaceship_hull_id integer
);
--
-- Name: spaceship_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE spaceship_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: spaceship_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE spaceship_id_seq OWNED BY spaceships.id;
--
-- Name: spaceship_modules; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE spaceship_modules (
spaceship_id integer NOT NULL,
module_id integer NOT NULL
);
--
-- Name: visual_meshes; Type: TABLE; Schema: public; Owner: -
--
CREATE TABLE visual_meshes (
id integer NOT NULL,
file_path character varying(128) NOT NULL
);
--
-- Name: visual_meshes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE visual_meshes_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: visual_meshes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE visual_meshes_id_seq OWNED BY visual_meshes.id;
--
-- Name: accounts id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY accounts ALTER COLUMN id SET DEFAULT nextval('account_id_seq'::regclass);
--
-- Name: collision_meshes id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY collision_meshes ALTER COLUMN id SET DEFAULT nextval('collision_mesh_id_seq'::regclass);
--
-- Name: modules id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY modules ALTER COLUMN id SET DEFAULT nextval('modules_id_seq'::regclass);
--
-- Name: spaceship_hulls id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_hulls ALTER COLUMN id SET DEFAULT nextval('spaceship_hull_id_seq'::regclass);
--
-- Name: spaceships id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceships ALTER COLUMN id SET DEFAULT nextval('spaceship_id_seq'::regclass);
--
--
ALTER TABLE ONLY visual_meshes ALTER COLUMN id SET DEFAULT nextval('visual_meshes_id_seq'::regclass);
--
-- Name: accounts account_email_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT account_email_key UNIQUE (email);
--
-- Name: accounts account_login_key; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT account_login_key UNIQUE (login);
--
-- Name: accounts account_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT account_pkey PRIMARY KEY (id);
--
-- Name: collision_meshes collision_mesh_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY collision_meshes
ADD CONSTRAINT collision_mesh_pkey PRIMARY KEY (id);
--
-- Name: modules modules_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY modules
ADD CONSTRAINT modules_pkey PRIMARY KEY (id);
--
-- Name: spaceship_hulls spaceship_hull_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_hulls
ADD CONSTRAINT spaceship_hull_pkey PRIMARY KEY (id);
--
-- Name: spaceship_modules spaceship_modules_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_modules
ADD CONSTRAINT spaceship_modules_pkey PRIMARY KEY (spaceship_id, module_id);
--
-- Name: spaceships spaceship_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceships
ADD CONSTRAINT spaceship_pkey PRIMARY KEY (id);
--
-- Name: visual_meshes visual_meshes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY visual_meshes
ADD CONSTRAINT visual_meshes_pkey PRIMARY KEY (id);
--
-- Name: spaceship_hulls spaceship_hull_collision_mesh_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_hulls
ADD CONSTRAINT spaceship_hull_collision_mesh_fkey FOREIGN KEY (collision_mesh) REFERENCES collision_meshes(id) ON UPDATE CASCADE;
--
-- Name: spaceship_modules spaceship_modules_module_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_modules
ADD CONSTRAINT spaceship_modules_module_id_fkey FOREIGN KEY (module_id) REFERENCES modules(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: spaceship_modules spaceship_modules_spaceship_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceship_modules
ADD CONSTRAINT spaceship_modules_spaceship_id_fkey FOREIGN KEY (spaceship_id) REFERENCES spaceships(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: spaceships spaceship_owner_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceships
ADD CONSTRAINT spaceship_owner_id_fkey FOREIGN KEY (owner_id) REFERENCES accounts(id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: spaceships spaceship_spaceship_hull_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY spaceships
ADD CONSTRAINT spaceship_spaceship_hull_id_fkey FOREIGN KEY (spaceship_hull_id) REFERENCES spaceship_hulls(id) ON UPDATE CASCADE ON DELETE SET NULL;
--
-- PostgreSQL database dump complete
--