2 -- PostgreSQL database dump
5 SET client_encoding = 'UTF8';
6 SET standard_conforming_strings = off;
7 SET check_function_bodies = false;
8 SET client_min_messages = warning;
9 SET escape_string_warning = off;
12 -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
15 COMMENT ON SCHEMA public IS 'Standard public schema';
19 -- Name: plperl; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: postgres
22 CREATE PROCEDURAL LANGUAGE plperl;
25 SET search_path = public, pg_catalog;
28 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: ndawn
31 CREATE FUNCTION add_call() RETURNS "trigger"
33 if ($_TD->{event} eq 'INSERT'){
34 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
35 if ($rv->{processed} != 1){
38 $ftid = $rv->{rows}[0]->{id};
39 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES(-3,$1,$2,-3)','int4','varchar');
40 $rv = spi_exec_prepared($query,$ftid,"$_TD->{new}{member}: $_TD->{new}{landing_tick}");
42 if (rv->{status} != SPI_OK_INSERT){
45 $_TD->{new}{ftid} = $ftid;
53 ALTER FUNCTION public.add_call() OWNER TO ndawn;
56 -- Name: add_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: ndawn
59 CREATE FUNCTION add_intel(tick integer, eta integer, x1 integer, y1 integer, z1 integer, x2 integer, y2 integer, z2 integer, amount integer, mission character varying, uid integer) RETURNS boolean
60 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
62 $tick = -1 unless defined $tick;
63 if ($x1 == $x2 && $y1 == $y2) {
67 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
68 $tick = $rv->{rows}[0]->{tick};
70 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
71 unless ($rv->{processed} >= 1){
74 $id1 = $rv->{rows}[0]->{id};
75 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
76 unless ($rv->{processed} >= 1){
79 $id2 = $rv->{rows}[0]->{id};
81 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
86 ALTER FUNCTION public.add_intel(tick integer, eta integer, x1 integer, y1 integer, z1 integer, x2 integer, y2 integer, z2 integer, amount integer, mission character varying, uid integer) OWNER TO ndawn;
89 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
92 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
93 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
95 if ($x1 == $x2 && $y1 == $y2) {
99 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
100 $tick = $rv->{rows}[0]->{tick};
102 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
103 unless ($rv->{processed} == 1){
106 $id1 = $rv->{rows}[0]->{id};
107 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
108 unless ($rv->{processed} == 1){
111 $id2 = $rv->{rows}[0]->{id};
112 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
117 ALTER FUNCTION public.add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) OWNER TO ndawn;
120 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
123 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
124 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
125 unless ($uid = /^(-?\d+)$/){
126 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
127 $uid = $rv->{rows}[0]->{id};
130 if ($x1 == $x2 && $y1 == $y2) {
134 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
135 $tick = $rv->{rows}[0]->{tick};
137 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
138 unless ($rv->{processed} >= 1){
141 $id1 = $rv->{rows}[0]->{id};
142 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
143 unless ($rv->{processed} >= 1){
146 $id2 = $rv->{rows}[0]->{id};
148 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
153 ALTER FUNCTION public.add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) OWNER TO ndawn;
156 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: ndawn
159 CREATE FUNCTION add_intel4(tick integer, eta integer, x1 integer, y1 integer, z1 integer, x2 integer, y2 integer, z2 integer, amount integer, mission character varying, uid integer) RETURNS information_schema.cardinal_number
160 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
162 if ($x1 == $x2 && $y1 == $y2) {
166 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
167 $tick = $rv->{rows}[0]->{tick};
169 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
170 unless ($rv->{processed} >= 1){
173 $id1 = $rv->{rows}[0]->{id};
174 $rv = spi_exec_query("SELECT id,tick FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND (tick = $tick OR tick = (SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC;");
175 unless ($rv->{processed} >= 1){
178 $id2 = $rv->{rows}[0]->{id};
180 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
185 ALTER FUNCTION public.add_intel4(tick integer, eta integer, x1 integer, y1 integer, z1 integer, x2 integer, y2 integer, z2 integer, amount integer, mission character varying, uid integer) OWNER TO ndawn;
188 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: postgres
191 CREATE FUNCTION add_user() RETURNS "trigger"
193 if ($_TD->{event} eq 'INSERT'){
194 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
195 if ($rv->{processed} != 1){
198 $ftid = $rv->{rows}[0]->{id};
199 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
200 $rv = spi_exec_prepared($query,-1,$ftid,"$_TD->{new}{uid}: $_TD->{new}{username}");
201 spi_freeplan($query);
202 if (rv->{status} != SPI_OK_INSERT){
205 $_TD->{new}{ftid} = $ftid;
213 ALTER FUNCTION public.add_user() OWNER TO postgres;
216 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: ndawn
219 CREATE FUNCTION calc_rank(tick integer) RETURNS void
220 AS $_$my ($tick) = @_;
221 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
223 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
224 my $status = $rv->{status};
225 my $nrows = $rv->{processed};
227 for ($row = 1; $row <= $nrows; ++$row ){
228 $id = $rv->{rows}[$row-1]->{id};
229 $ranks{$id}{'score'} = $row;
232 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
233 my $status = $rv->{status};
234 my $nrows = $rv->{processed};
236 for ($row = 1; $row <= $nrows; ++$row ){
237 $id = $rv->{rows}[$row-1]->{id};
238 $ranks{$id}{'value'} = $row;
241 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
242 my $status = $rv->{status};
243 my $nrows = $rv->{processed};
245 for ($row = 1; $row <= $nrows; ++$row ){
246 $id = $rv->{rows}[$row-1]->{id};
247 $ranks{$id}{'size'} = $row;
250 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
251 my $status = $rv->{status};
252 my $nrows = $rv->{processed};
254 for ($row = 1; $row <= $nrows; ++$row ){
255 $id = $rv->{rows}[$row-1]->{id};
256 $ranks{$id}{'xp'} = $row;
258 foreach $key (keys(%ranks)){
259 spi_exec_query("INSERT INTO rankings (id,tick,score,value,size,xp) VALUES($key,$tick,".$ranks{$key}{'score'}.",".$ranks{$key}{'value'}.",".$ranks{$key}{'size'}.",".$ranks{$key}{'xp'}.")");
265 ALTER FUNCTION public.calc_rank(tick integer) OWNER TO ndawn;
268 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: ndawn
271 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
272 AS $_$my ($tick) = @_;
273 #spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
275 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
276 my $status = $rv->{status};
277 my $nrows = $rv->{processed};
279 for ($row = 1; $row <= $nrows; ++$row ){
280 $id = $rv->{rows}[$row-1]->{id};
281 #$ranks{$id}{'score'} = $row;
284 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
285 my $status = $rv->{status};
286 my $nrows = $rv->{processed};
288 for ($row = 1; $row <= $nrows; ++$row ){
289 $id = $rv->{rows}[$row-1]->{id};
290 #$ranks{$id}{'value'} = $row;
293 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
294 my $status = $rv->{status};
295 my $nrows = $rv->{processed};
297 for ($row = 1; $row <= $nrows; ++$row ){
298 $id = $rv->{rows}[$row-1]->{id};
299 #$ranks{$id}{'size'} = $row;
302 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
303 my $status = $rv->{status};
304 my $nrows = $rv->{processed};
306 for ($row = 1; $row <= $nrows; ++$row ){
307 $id = $rv->{rows}[$row-1]->{id};
308 #$ranks{$id}{'xp'} = $row;
310 foreach $key (keys(%ranks)){
311 #spi_exec_query("INSERT INTO rankings (id,tick,score,value,size,xp) VALUES($key,$tick,".$ranks{$key}{'score'}.",".$ranks{$key}{'value'}.",".$ranks{$key}{'size'}.",".$ranks{$key}{'xp'}.")");
317 ALTER FUNCTION public.calc_rank3(tick integer) OWNER TO ndawn;
320 -- Name: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: ndawn
323 CREATE FUNCTION calculate_rankings(integer) RETURNS void
324 AS $_$my ($tick) = @_;
325 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
326 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
327 my $status = $rv->{status};
328 my $nrows = $rv->{processed};
330 for ($row = 1; $row <= $nrows; ++$row ){
331 $id = $rv->{rows}[$row-1]->{id};
332 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
335 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
336 my $status = $rv->{status};
337 my $nrows = $rv->{processed};
339 for ($row = 1; $row <= $nrows; ++$row ){
340 $id = $rv->{rows}[$row-1]->{id};
341 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
344 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
345 my $status = $rv->{status};
346 my $nrows = $rv->{processed};
348 for ($row = 1; $row <= $nrows; ++$row ){
349 $id = $rv->{rows}[$row-1]->{id};
350 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
353 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
354 my $status = $rv->{status};
355 my $nrows = $rv->{processed};
357 for ($row = 1; $row <= $nrows; ++$row ){
358 $id = $rv->{rows}[$row-1]->{id};
359 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
365 ALTER FUNCTION public.calculate_rankings(integer) OWNER TO ndawn;
368 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: ndawn
371 CREATE FUNCTION change_member() RETURNS "trigger"
372 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
373 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
374 if ($rv->{rows}[0]->{planet}){
375 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
378 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
379 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
380 if ($rv->{rows}[0]->{planet}){
381 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
388 ALTER FUNCTION public.change_member() OWNER TO ndawn;
391 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
394 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
395 AS $_$my ($x,$y,$z) = @_;
396 return "$x:$y:$z";$_$
397 LANGUAGE plperl IMMUTABLE;
400 ALTER FUNCTION public.coords(x integer, y integer, z integer) OWNER TO ndawn;
403 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: ndawn
406 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
407 AS $_$my ($name) = @_;
409 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
410 my $rv = spi_exec_prepared($query,$name);
411 my $status = $rv->{status};
412 my $nrows = $rv->{processed};
415 $id = $rv->{rows}[0]->{id};
418 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
419 if ($rv->{processed} != 1){
422 $id = $rv->{rows}[0]->{id};
423 my $query = spi_prepare('INSERT INTO alliances(id,name,relationship) VALUES($1,$2,NULL)','int4','varchar');
424 $rv = spi_exec_prepared($query,$id,$name);
425 spi_freeplan($query);
426 if (rv->{status} != SPI_OK_INSERT){
434 ALTER FUNCTION public.find_alliance_id(character varying) OWNER TO ndawn;
437 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
440 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
441 AS $_$my ($ruler, $planet, $race) = @_;
442 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
443 my $rv = spi_exec_prepared($query,$ruler,$planet);
444 spi_freeplan($query);
445 my $status = $rv->{status};
446 my $nrows = $rv->{processed};
449 $id = $rv->{rows}[0]->{id};
450 unless ($race eq $rv->{rows}[0]->{race}){
451 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','varchar','int4');
452 spi_exec_prepared($query,$race,$id);
453 spi_freeplan($query);
456 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
457 if ($rv->{processed} != 1){
460 $ftid = $rv->{rows}[0]->{id};
461 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject) VALUES($1,$2,$3)','int4','int4','varchar');
462 $rv = spi_exec_prepared($query,-2,$ftid,"$ruler OF $planet");
463 spi_freeplan($query);
464 if (rv->{status} != SPI_OK_INSERT){
467 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
468 if ($rv->{processed} != 1){
471 $id = $rv->{rows}[0]->{id};
472 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race,ftid) VALUES($1,$2,$3,$4,$5)','int4','varchar','varchar','varchar','int4');
473 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race,$ftid);
474 spi_freeplan($query);
475 if (rv->{status} != SPI_OK_INSERT){
484 ALTER FUNCTION public.findplanetid(character varying, character varying, character varying) OWNER TO ndawn;
487 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: ndawn
490 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
491 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
495 ALTER FUNCTION public.groups(uid integer) OWNER TO ndawn;
498 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
501 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
502 AS $_$SELECT LEAST(2000*15*$4::numeric/$5,$1*0.10, 15*7500)::integer + LEAST(2000*15*$4::numeric/$5,$2*0.10, 15*7500)::integer+LEAST(2000*15*$4::numeric/$5,$3*0.10, 15*7500)::integer$_$
503 LANGUAGE sql IMMUTABLE;
506 ALTER FUNCTION public.max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) OWNER TO ndawn;
509 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: ndawn
512 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
513 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$
514 LANGUAGE sql IMMUTABLE;
517 ALTER FUNCTION public.old_claim("timestamp" timestamp with time zone) OWNER TO ndawn;
520 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
523 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
524 AS $_$SELECT x,y,z FROM planet_stats WHERE id = $1 AND (tick >= $2 OR tick =( SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC LIMIT 1$_$
528 ALTER FUNCTION public.planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) OWNER TO ndawn;
531 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
534 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
535 AS $_$SELECT id FROM planet_stats WHERE x = $1 AND y = $2 AND z = $3 AND (tick >= $4 OR tick =( SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC LIMIT 1$_$
539 ALTER FUNCTION public.planetid(x integer, y integer, z integer, tick integer) OWNER TO ndawn;
542 -- Name: plperl_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
545 CREATE FUNCTION plperl_call_handler() RETURNS language_handler
546 AS '$libdir/plperl', 'plperl_call_handler'
550 ALTER FUNCTION public.plperl_call_handler() OWNER TO postgres;
553 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: ndawn
556 CREATE FUNCTION populate_ticks() RETURNS void
557 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
558 my $nrows = $rv->{processed};
560 $tick = $rv->{rows}[0]->{tick};
561 spi_exec_query("DELETE FROM ticks;");
562 spi_exec_query("INSERT INTO ticks(tick) (SELECT generate_series(36, tick,tick/50) FROM (SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1) as foo);");
563 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
568 ALTER FUNCTION public.populate_ticks() OWNER TO ndawn;
571 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: postgres
574 CREATE FUNCTION tick() RETURNS integer
575 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
579 ALTER FUNCTION public.tick() OWNER TO postgres;
582 -- Name: unclaim_target(); Type: FUNCTION; Schema: public; Owner: ndawn
585 CREATE FUNCTION unclaim_target() RETURNS "trigger"
587 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{launched} eq 't'){
588 my $uid = $_TD->{old}{uid};
589 my $query = spi_prepare(q{UPDATE users
590 SET attack_points = attack_points - 1
591 WHERE uid = $1},'int4');
592 spi_exec_prepared($query,$uid);
593 spi_freeplan($query);
600 ALTER FUNCTION public.unclaim_target() OWNER TO ndawn;
603 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: ndawn
606 CREATE FUNCTION update_user_planet() RETURNS "trigger"
607 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
608 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
609 if ($_TD->{old}{planet}){
610 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
612 if ($_TD->{new}{planet}){
613 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
616 if ($_TD->{old}{planet}){
617 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
619 if ($_TD->{new}{planet}){
620 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
626 ALTER FUNCTION public.update_user_planet() OWNER TO ndawn;
629 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: ndawn
632 CREATE FUNCTION updated_target() RETURNS "trigger"
633 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
634 my $target = $_TD->{new}{target};
635 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
636 spi_exec_prepared($query,$target);
637 spi_freeplan($query);$_X$
641 ALTER FUNCTION public.updated_target() OWNER TO ndawn;
644 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: ndawn
647 CREATE AGGREGATE concat(text) (
654 ALTER AGGREGATE public.concat(text) OWNER TO ndawn;
656 SET default_tablespace = '';
658 SET default_with_oids = false;
661 -- Name: alliance_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
664 CREATE TABLE alliance_stats (
666 tick integer NOT NULL,
667 size integer NOT NULL,
668 members integer NOT NULL,
669 score integer NOT NULL,
670 sizerank integer NOT NULL,
671 scorerank integer NOT NULL,
672 size_gain integer NOT NULL,
673 score_gain integer NOT NULL,
674 sizerank_gain integer NOT NULL,
675 scorerank_gain integer NOT NULL,
676 size_gain_day integer NOT NULL,
677 score_gain_day integer NOT NULL,
678 sizerank_gain_day integer NOT NULL,
679 scorerank_gain_day integer NOT NULL,
680 members_gain integer NOT NULL,
681 members_gain_day integer NOT NULL
685 ALTER TABLE public.alliance_stats OWNER TO ndawn;
688 -- Name: alliances; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
691 CREATE TABLE alliances (
693 name character varying NOT NULL,
698 ALTER TABLE public.alliances OWNER TO ndawn;
701 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
704 CREATE SEQUENCE alliances_id_seq
711 ALTER TABLE public.alliances_id_seq OWNER TO ndawn;
714 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
717 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
721 -- Name: calls; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
726 member integer NOT NULL,
728 landing_tick integer NOT NULL,
730 covered boolean DEFAULT false NOT NULL,
732 open boolean DEFAULT true NOT NULL,
737 ALTER TABLE public.calls OWNER TO ndawn;
740 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
743 CREATE SEQUENCE calls_id_seq
750 ALTER TABLE public.calls_id_seq OWNER TO ndawn;
753 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
756 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
760 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
763 CREATE TABLE channel_flags (
769 ALTER TABLE public.channel_flags OWNER TO ndawn;
772 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
775 CREATE SEQUENCE channel_flags_id_seq
782 ALTER TABLE public.channel_flags_id_seq OWNER TO ndawn;
785 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
788 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
792 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
795 CREATE TABLE channel_group_flags (
796 channel integer NOT NULL,
797 "group" integer NOT NULL,
798 flag integer NOT NULL
802 ALTER TABLE public.channel_group_flags OWNER TO ndawn;
805 -- Name: channels; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
808 CREATE TABLE channels (
811 description text NOT NULL
815 ALTER TABLE public.channels OWNER TO ndawn;
818 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
821 CREATE SEQUENCE channels_id_seq
828 ALTER TABLE public.channels_id_seq OWNER TO ndawn;
831 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
834 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
838 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
841 CREATE TABLE planet_stats (
843 tick integer NOT NULL,
847 size integer NOT NULL,
848 score integer NOT NULL,
849 value integer NOT NULL,
851 sizerank integer NOT NULL,
852 scorerank integer NOT NULL,
853 valuerank integer NOT NULL,
854 xprank integer NOT NULL,
855 size_gain integer NOT NULL,
856 score_gain integer NOT NULL,
857 value_gain integer NOT NULL,
858 xp_gain integer NOT NULL,
859 sizerank_gain integer NOT NULL,
860 scorerank_gain integer NOT NULL,
861 valuerank_gain integer NOT NULL,
862 xprank_gain integer NOT NULL,
863 size_gain_day integer NOT NULL,
864 score_gain_day integer NOT NULL,
865 value_gain_day integer NOT NULL,
866 xp_gain_day integer NOT NULL,
867 sizerank_gain_day integer NOT NULL,
868 scorerank_gain_day integer NOT NULL,
869 valuerank_gain_day integer NOT NULL,
870 xprank_gain_day integer NOT NULL
874 ALTER TABLE public.planet_stats OWNER TO ndawn;
877 -- Name: planets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
880 CREATE TABLE planets (
882 ruler character varying NOT NULL,
883 planet character varying NOT NULL,
884 race character varying,
885 nick character varying,
887 hit_us integer DEFAULT 0 NOT NULL,
894 ALTER TABLE public.planets OWNER TO ndawn;
897 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: ndawn
900 CREATE VIEW current_planet_stats AS
901 SELECT p.id, p.nick, p.planet_status, p.hit_us, ps.x, ps.y, ps.z, p.ruler, p.planet, p.race, ps.size, ps.score, ps.value, ps.xp, ps.sizerank, ps.scorerank, ps.valuerank, ps.xprank, alliances.name AS alliance, alliances.relationship, p.alliance_id, p.channel, p.ftid FROM (((SELECT planet_stats.id, planet_stats.tick, planet_stats.x, planet_stats.y, planet_stats.z, planet_stats.size, planet_stats.score, planet_stats.value, planet_stats.xp, planet_stats.sizerank, planet_stats.scorerank, planet_stats.valuerank, planet_stats.xprank FROM planet_stats WHERE (planet_stats.tick = (SELECT max(planet_stats.tick) AS max FROM planet_stats))) ps NATURAL JOIN planets p) LEFT JOIN alliances ON ((alliances.id = p.alliance_id)));
904 ALTER TABLE public.current_planet_stats OWNER TO ndawn;
907 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: ndawn
910 CREATE VIEW current_planet_stats_full AS
911 SELECT p.id, p.nick, p.planet_status, p.hit_us, ps.x, ps.y, ps.z, p.ruler, p.planet, p.race, ps.size, ps.score, ps.value, ps.xp, ps.sizerank, ps.scorerank, ps.valuerank, ps.xprank, alliances.name AS alliance, alliances.relationship, p.alliance_id, p.channel, p.ftid, ps.size_gain, ps.score_gain, ps.value_gain, ps.xp_gain, ps.sizerank_gain, ps.scorerank_gain, ps.valuerank_gain, ps.xprank_gain, ps.size_gain_day, ps.score_gain_day, ps.value_gain_day, ps.xp_gain_day, ps.sizerank_gain_day, ps.scorerank_gain_day, ps.valuerank_gain_day, ps.xprank_gain_day FROM (((SELECT planet_stats.id, planet_stats.tick, planet_stats.x, planet_stats.y, planet_stats.z, planet_stats.size, planet_stats.score, planet_stats.value, planet_stats.xp, planet_stats.sizerank, planet_stats.scorerank, planet_stats.valuerank, planet_stats.xprank, planet_stats.size_gain, planet_stats.score_gain, planet_stats.value_gain, planet_stats.xp_gain, planet_stats.sizerank_gain, planet_stats.scorerank_gain, planet_stats.valuerank_gain, planet_stats.xprank_gain, planet_stats.size_gain_day, planet_stats.score_gain_day, planet_stats.value_gain_day, planet_stats.xp_gain_day, planet_stats.sizerank_gain_day, planet_stats.scorerank_gain_day, planet_stats.valuerank_gain_day, planet_stats.xprank_gain_day FROM planet_stats WHERE (planet_stats.tick = (SELECT max(planet_stats.tick) AS max FROM planet_stats))) ps NATURAL JOIN planets p) LEFT JOIN alliances ON ((alliances.id = p.alliance_id)));
914 ALTER TABLE public.current_planet_stats_full OWNER TO ndawn;
917 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
920 CREATE TABLE defense_missions (
921 call integer NOT NULL,
922 fleet integer NOT NULL,
923 announced boolean DEFAULT false NOT NULL,
924 pointed boolean DEFAULT false NOT NULL
928 ALTER TABLE public.defense_missions OWNER TO ndawn;
931 -- Name: defense_requests; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
934 CREATE TABLE defense_requests (
936 uid integer NOT NULL,
937 message text NOT NULL,
938 sent boolean DEFAULT false NOT NULL
942 ALTER TABLE public.defense_requests OWNER TO ndawn;
945 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
948 CREATE SEQUENCE defense_requests_id_seq
955 ALTER TABLE public.defense_requests_id_seq OWNER TO ndawn;
958 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
961 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
965 -- Name: dumps; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
969 tick integer NOT NULL,
970 "type" text NOT NULL,
972 modified integer DEFAULT 0 NOT NULL
976 ALTER TABLE public.dumps OWNER TO ndawn;
979 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
982 CREATE TABLE fleet_scans (
984 scan integer NOT NULL
988 ALTER TABLE public.fleet_scans OWNER TO ndawn;
991 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
994 CREATE TABLE fleet_ships (
997 amount integer NOT NULL
1001 ALTER TABLE public.fleet_ships OWNER TO ndawn;
1004 -- Name: fleets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1007 CREATE TABLE fleets (
1008 uid integer NOT NULL,
1010 mission text NOT NULL,
1011 tick integer NOT NULL,
1012 id integer NOT NULL,
1015 sender integer NOT NULL,
1018 ingal boolean DEFAULT false NOT NULL
1022 ALTER TABLE public.fleets OWNER TO ndawn;
1025 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1028 CREATE SEQUENCE fleets_id_seq
1035 ALTER TABLE public.fleets_id_seq OWNER TO ndawn;
1038 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1041 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
1045 -- Name: forum_access; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1048 CREATE TABLE forum_access (
1049 fbid integer NOT NULL,
1050 gid integer NOT NULL,
1051 post boolean DEFAULT false NOT NULL,
1052 moderate boolean DEFAULT false NOT NULL
1056 ALTER TABLE public.forum_access OWNER TO ndawn;
1059 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1062 CREATE TABLE forum_boards (
1063 fbid integer NOT NULL,
1064 fcid integer NOT NULL,
1069 ALTER TABLE public.forum_boards OWNER TO ndawn;
1072 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1075 CREATE SEQUENCE forum_boards_fbid_seq
1082 ALTER TABLE public.forum_boards_fbid_seq OWNER TO ndawn;
1085 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1088 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1092 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1095 CREATE TABLE forum_categories (
1096 fcid integer NOT NULL,
1097 category text NOT NULL
1101 ALTER TABLE public.forum_categories OWNER TO ndawn;
1104 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1107 CREATE SEQUENCE forum_categories_fcid_seq
1114 ALTER TABLE public.forum_categories_fcid_seq OWNER TO ndawn;
1117 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1120 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1124 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1127 CREATE TABLE forum_posts (
1128 fpid integer NOT NULL,
1129 ftid integer NOT NULL,
1130 message text NOT NULL,
1131 "time" timestamp with time zone DEFAULT now() NOT NULL,
1132 uid integer NOT NULL
1136 ALTER TABLE public.forum_posts OWNER TO ndawn;
1139 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1142 CREATE SEQUENCE forum_posts_fpid_seq
1149 ALTER TABLE public.forum_posts_fpid_seq OWNER TO ndawn;
1152 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1155 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1159 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1162 CREATE TABLE forum_thread_visits (
1163 uid integer NOT NULL,
1164 ftid integer NOT NULL,
1165 "time" timestamp with time zone DEFAULT now() NOT NULL
1169 ALTER TABLE public.forum_thread_visits OWNER TO ndawn;
1172 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1175 CREATE TABLE forum_threads (
1176 ftid integer NOT NULL,
1177 fbid integer NOT NULL,
1178 subject text NOT NULL,
1179 sticky boolean DEFAULT false NOT NULL,
1184 ALTER TABLE public.forum_threads OWNER TO ndawn;
1187 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1190 CREATE SEQUENCE forum_threads_ftid_seq
1197 ALTER TABLE public.forum_threads_ftid_seq OWNER TO ndawn;
1200 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1203 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1207 -- Name: galaxies; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1210 CREATE TABLE galaxies (
1213 tick integer NOT NULL,
1214 size integer NOT NULL,
1215 score integer NOT NULL,
1216 value integer NOT NULL,
1217 xp integer NOT NULL,
1218 planets integer NOT NULL,
1219 sizerank integer NOT NULL,
1220 scorerank integer NOT NULL,
1221 valuerank integer NOT NULL,
1222 xprank integer NOT NULL,
1223 size_gain integer NOT NULL,
1224 score_gain integer NOT NULL,
1225 value_gain integer NOT NULL,
1226 xp_gain integer NOT NULL,
1227 planets_gain integer NOT NULL,
1228 sizerank_gain integer NOT NULL,
1229 scorerank_gain integer NOT NULL,
1230 valuerank_gain integer NOT NULL,
1231 xprank_gain integer NOT NULL,
1232 size_gain_day integer NOT NULL,
1233 score_gain_day integer NOT NULL,
1234 value_gain_day integer NOT NULL,
1235 xp_gain_day integer NOT NULL,
1236 planets_gain_day integer NOT NULL,
1237 sizerank_gain_day integer NOT NULL,
1238 scorerank_gain_day integer NOT NULL,
1239 valuerank_gain_day integer NOT NULL,
1240 xprank_gain_day integer NOT NULL
1244 ALTER TABLE public.galaxies OWNER TO ndawn;
1247 -- Name: graphs; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1250 CREATE TABLE graphs (
1251 "type" text NOT NULL,
1252 id integer NOT NULL,
1253 last_modified timestamp with time zone DEFAULT now() NOT NULL,
1254 tick integer NOT NULL,
1259 ALTER TABLE public.graphs OWNER TO ndawn;
1262 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1265 CREATE TABLE groupmembers (
1266 gid integer NOT NULL,
1267 uid integer NOT NULL
1271 ALTER TABLE public.groupmembers OWNER TO ndawn;
1274 -- Name: groups; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1277 CREATE TABLE groups (
1278 gid integer NOT NULL,
1279 groupname text NOT NULL,
1281 attack boolean DEFAULT false NOT NULL
1285 ALTER TABLE public.groups OWNER TO ndawn;
1288 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1291 CREATE SEQUENCE groups_gid_seq
1298 ALTER TABLE public.groups_gid_seq OWNER TO ndawn;
1301 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1304 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1308 -- Name: incomings; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1311 CREATE TABLE incomings (
1312 call integer NOT NULL,
1313 sender integer NOT NULL,
1314 eta integer NOT NULL,
1315 amount integer NOT NULL,
1316 fleet text NOT NULL,
1317 shiptype text DEFAULT '?'::text NOT NULL,
1322 ALTER TABLE public.incomings OWNER TO ndawn;
1325 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1328 CREATE SEQUENCE incomings_id_seq
1335 ALTER TABLE public.incomings_id_seq OWNER TO ndawn;
1338 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1341 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1345 -- Name: intel_messages; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1348 CREATE TABLE intel_messages (
1349 id integer NOT NULL,
1350 uid integer NOT NULL,
1351 message text NOT NULL,
1352 handled boolean DEFAULT false NOT NULL,
1354 report_date timestamp with time zone DEFAULT now() NOT NULL
1358 ALTER TABLE public.intel_messages OWNER TO ndawn;
1361 -- Name: intel_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1364 CREATE SEQUENCE intel_messages_id_seq
1371 ALTER TABLE public.intel_messages_id_seq OWNER TO ndawn;
1374 -- Name: intel_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1377 ALTER SEQUENCE intel_messages_id_seq OWNED BY intel_messages.id;
1381 -- Name: log; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1385 id integer NOT NULL,
1386 uid integer NOT NULL,
1387 "time" timestamp without time zone DEFAULT now() NOT NULL,
1392 ALTER TABLE public.log OWNER TO ndawn;
1395 -- Name: log_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1398 CREATE SEQUENCE log_id_seq
1405 ALTER TABLE public.log_id_seq OWNER TO ndawn;
1408 -- Name: log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1411 ALTER SEQUENCE log_id_seq OWNED BY log.id;
1415 -- Name: misc; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1424 ALTER TABLE public.misc OWNER TO ndawn;
1427 -- Name: planet_data; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1430 CREATE TABLE planet_data (
1431 id integer NOT NULL,
1432 scan integer NOT NULL,
1433 tick integer NOT NULL,
1434 rid integer NOT NULL,
1435 amount integer NOT NULL
1439 ALTER TABLE public.planet_data OWNER TO ndawn;
1442 -- Name: planet_data_types; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1445 CREATE TABLE planet_data_types (
1446 id integer NOT NULL,
1447 category text NOT NULL,
1452 ALTER TABLE public.planet_data_types OWNER TO ndawn;
1455 -- Name: planet_data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1458 CREATE SEQUENCE planet_data_types_id_seq
1465 ALTER TABLE public.planet_data_types_id_seq OWNER TO ndawn;
1468 -- Name: planet_data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1471 ALTER SEQUENCE planet_data_types_id_seq OWNED BY planet_data_types.id;
1475 -- Name: planet_graphs; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1478 CREATE TABLE planet_graphs (
1479 planet integer NOT NULL,
1480 tick integer NOT NULL,
1481 "type" text NOT NULL,
1482 graph bytea NOT NULL
1486 ALTER TABLE public.planet_graphs OWNER TO ndawn;
1489 -- Name: scans; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1492 CREATE TABLE scans (
1493 tick integer NOT NULL,
1494 scan_id numeric(10,0) NOT NULL,
1497 uid integer DEFAULT -1 NOT NULL,
1498 groupscan boolean DEFAULT false NOT NULL,
1499 parsed boolean DEFAULT false NOT NULL,
1504 ALTER TABLE public.scans OWNER TO ndawn;
1507 -- Name: planet_scans; Type: VIEW; Schema: public; Owner: ndawn
1510 CREATE VIEW planet_scans AS
1511 SELECT DISTINCT ON (s.planet) s.id, s.planet, s.tick, m.metal, c.crystal, e.eonium, mr.metal_roids, cr.crystal_roids, er.eonium_roids FROM ((((((scans s JOIN (SELECT planet_data.scan AS id, planet_data.amount AS metal_roids FROM planet_data WHERE (planet_data.rid = 1)) mr USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS crystal_roids FROM planet_data WHERE (planet_data.rid = 2)) cr USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS eonium_roids FROM planet_data WHERE (planet_data.rid = 3)) er USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS metal FROM planet_data WHERE (planet_data.rid = 4)) m USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS crystal FROM planet_data WHERE (planet_data.rid = 5)) c USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS eonium FROM planet_data WHERE (planet_data.rid = 6)) e USING (id)) ORDER BY s.planet, s.tick DESC, s.id DESC;
1514 ALTER TABLE public.planet_scans OWNER TO ndawn;
1517 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1520 CREATE SEQUENCE planets_id_seq
1527 ALTER TABLE public.planets_id_seq OWNER TO ndawn;
1530 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1533 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1537 -- Name: raid_access; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1540 CREATE TABLE raid_access (
1541 raid integer NOT NULL,
1542 gid integer NOT NULL
1546 ALTER TABLE public.raid_access OWNER TO ndawn;
1549 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1552 CREATE TABLE raid_claims (
1553 target integer NOT NULL,
1554 uid integer NOT NULL,
1555 wave integer NOT NULL,
1556 joinable boolean DEFAULT false NOT NULL,
1557 launched boolean DEFAULT false NOT NULL,
1558 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
1562 ALTER TABLE public.raid_claims OWNER TO ndawn;
1565 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1568 CREATE TABLE raid_targets (
1569 id integer NOT NULL,
1570 raid integer NOT NULL,
1571 planet integer NOT NULL,
1573 modified timestamp with time zone DEFAULT now() NOT NULL
1577 ALTER TABLE public.raid_targets OWNER TO ndawn;
1580 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1583 CREATE SEQUENCE raid_targets_id_seq
1590 ALTER TABLE public.raid_targets_id_seq OWNER TO ndawn;
1593 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1596 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1600 -- Name: raids; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1603 CREATE TABLE raids (
1604 id integer NOT NULL,
1605 tick integer NOT NULL,
1606 open boolean DEFAULT false NOT NULL,
1607 waves integer DEFAULT 3 NOT NULL,
1608 message text NOT NULL,
1609 removed boolean DEFAULT false NOT NULL,
1610 released_coords boolean DEFAULT false NOT NULL
1614 ALTER TABLE public.raids OWNER TO ndawn;
1617 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1620 CREATE SEQUENCE raids_id_seq
1627 ALTER TABLE public.raids_id_seq OWNER TO ndawn;
1630 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1633 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1637 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1640 CREATE SEQUENCE scans_id_seq
1647 ALTER TABLE public.scans_id_seq OWNER TO ndawn;
1650 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1653 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
1657 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1660 CREATE TABLE ship_stats (
1662 "class" text NOT NULL,
1664 "type" text NOT NULL,
1665 init integer NOT NULL,
1666 armor integer NOT NULL,
1667 damage integer NOT NULL,
1668 metal integer NOT NULL,
1669 crystal integer NOT NULL,
1670 eonium integer NOT NULL,
1672 guns integer DEFAULT 0 NOT NULL,
1673 eres integer DEFAULT 0 NOT NULL,
1679 ALTER TABLE public.ship_stats OWNER TO ndawn;
1682 -- Name: smslist; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1685 CREATE TABLE smslist (
1692 ALTER TABLE public.smslist OWNER TO ndawn;
1695 -- Name: structure_scans; Type: VIEW; Schema: public; Owner: ndawn
1698 CREATE VIEW structure_scans AS
1699 SELECT DISTINCT ON (s.planet) s.id, s.planet, s.tick, t.total, d.distorters, sc.seccents FROM (((scans s JOIN (SELECT planet_data.scan AS id, sum(planet_data.amount) AS total FROM planet_data WHERE ((planet_data.rid >= 14) AND (planet_data.rid <= 24)) GROUP BY planet_data.scan) t USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS distorters FROM planet_data WHERE (planet_data.rid = 18)) d USING (id)) JOIN (SELECT planet_data.scan AS id, planet_data.amount AS seccents FROM planet_data WHERE (planet_data.rid = 24)) sc USING (id)) ORDER BY s.planet, s.tick DESC, s.id DESC;
1702 ALTER TABLE public.structure_scans OWNER TO ndawn;
1705 -- Name: test; Type: SEQUENCE; Schema: public; Owner: ndawn
1708 CREATE SEQUENCE test
1715 ALTER TABLE public.test OWNER TO ndawn;
1717 SET default_with_oids = true;
1720 -- Name: ticks; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1723 CREATE TABLE ticks (
1724 tick integer NOT NULL
1728 ALTER TABLE public.ticks OWNER TO ndawn;
1730 SET default_with_oids = false;
1733 -- Name: users; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1736 CREATE TABLE users (
1737 uid integer NOT NULL,
1738 username text NOT NULL,
1740 "password" text NOT NULL,
1741 attack_points integer DEFAULT 0 NOT NULL,
1742 defense_points integer DEFAULT 0 NOT NULL,
1743 scan_points integer DEFAULT 0 NOT NULL,
1744 humor_points integer DEFAULT 0 NOT NULL,
1748 laston timestamp with time zone,
1751 last_forum_visit timestamp with time zone,
1758 ALTER TABLE public.users OWNER TO ndawn;
1761 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1764 CREATE SEQUENCE users_uid_seq
1771 ALTER TABLE public.users_uid_seq OWNER TO ndawn;
1774 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1777 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1781 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: ndawn
1784 CREATE VIEW usersingroup AS
1785 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
1788 ALTER TABLE public.usersingroup OWNER TO ndawn;
1791 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1794 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1798 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1801 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1805 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1808 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1812 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1815 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1819 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1822 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1826 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1829 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1833 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: ndawn
1836 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1840 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: ndawn
1843 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1847 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: ndawn
1850 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1854 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: ndawn
1857 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1861 -- Name: gid; Type: DEFAULT; Schema: public; Owner: ndawn
1864 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1868 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1871 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1875 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1878 ALTER TABLE intel_messages ALTER COLUMN id SET DEFAULT nextval('intel_messages_id_seq'::regclass);
1882 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1885 ALTER TABLE log ALTER COLUMN id SET DEFAULT nextval('log_id_seq'::regclass);
1889 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1892 ALTER TABLE planet_data_types ALTER COLUMN id SET DEFAULT nextval('planet_data_types_id_seq'::regclass);
1896 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1899 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1903 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1906 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1910 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1913 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1917 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1920 ALTER TABLE scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
1924 -- Name: uid; Type: DEFAULT; Schema: public; Owner: ndawn
1927 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1931 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1934 ALTER TABLE ONLY users
1935 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1939 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1942 ALTER TABLE ONLY alliance_stats
1943 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1947 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1950 ALTER TABLE ONLY alliances
1951 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1955 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1958 ALTER TABLE ONLY alliances
1959 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1963 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1966 ALTER TABLE ONLY calls
1967 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1971 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1974 ALTER TABLE ONLY calls
1975 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1979 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1982 ALTER TABLE ONLY channel_flags
1983 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1987 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1990 ALTER TABLE ONLY channel_flags
1991 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1995 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1998 ALTER TABLE ONLY channel_group_flags
1999 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
2003 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2006 ALTER TABLE ONLY channels
2007 ADD CONSTRAINT channels_name_key UNIQUE (name);
2011 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2014 ALTER TABLE ONLY channels
2015 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
2019 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2022 ALTER TABLE ONLY defense_missions
2023 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
2027 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2030 ALTER TABLE ONLY defense_requests
2031 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
2035 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2038 ALTER TABLE ONLY dumps
2039 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, "type", modified);
2043 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2046 ALTER TABLE ONLY fleet_scans
2047 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (id);
2051 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2054 ALTER TABLE ONLY fleet_ships
2055 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (id, ship);
2059 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2062 ALTER TABLE ONLY fleets
2063 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
2067 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2070 ALTER TABLE ONLY forum_access
2071 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
2075 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2078 ALTER TABLE ONLY forum_boards
2079 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
2083 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2086 ALTER TABLE ONLY forum_boards
2087 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
2091 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2094 ALTER TABLE ONLY forum_categories
2095 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
2099 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2102 ALTER TABLE ONLY forum_categories
2103 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
2107 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2110 ALTER TABLE ONLY forum_posts
2111 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
2115 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2118 ALTER TABLE ONLY forum_thread_visits
2119 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
2123 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2126 ALTER TABLE ONLY forum_threads
2127 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
2131 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2134 ALTER TABLE ONLY galaxies
2135 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
2139 -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2142 ALTER TABLE ONLY graphs
2143 ADD CONSTRAINT graphs_pkey PRIMARY KEY ("type", id);
2147 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2150 ALTER TABLE ONLY groupmembers
2151 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2155 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2158 ALTER TABLE ONLY groups
2159 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2163 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2166 ALTER TABLE ONLY groups
2167 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2171 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2174 ALTER TABLE ONLY incomings
2175 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
2179 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2182 ALTER TABLE ONLY incomings
2183 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
2187 -- Name: intel_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2190 ALTER TABLE ONLY intel_messages
2191 ADD CONSTRAINT intel_messages_pkey PRIMARY KEY (id);
2195 -- Name: log_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2198 ALTER TABLE ONLY log
2199 ADD CONSTRAINT log_pkey PRIMARY KEY (id);
2203 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2206 ALTER TABLE ONLY misc
2207 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
2211 -- Name: planet_data_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2214 ALTER TABLE ONLY planet_data
2215 ADD CONSTRAINT planet_data_pkey PRIMARY KEY (rid, scan);
2219 -- Name: planet_data_types_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2222 ALTER TABLE ONLY planet_data_types
2223 ADD CONSTRAINT planet_data_types_category_key UNIQUE (category, name);
2227 -- Name: planet_data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2230 ALTER TABLE ONLY planet_data_types
2231 ADD CONSTRAINT planet_data_types_pkey PRIMARY KEY (id);
2235 -- Name: planet_graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2238 ALTER TABLE ONLY planet_graphs
2239 ADD CONSTRAINT planet_graphs_pkey PRIMARY KEY (planet, "type");
2243 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2246 ALTER TABLE ONLY planet_stats
2247 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
2251 -- Name: planet_stats_tick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2254 ALTER TABLE ONLY planet_stats
2255 ADD CONSTRAINT planet_stats_tick_key UNIQUE (tick, x, y, z);
2259 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2262 ALTER TABLE ONLY planets
2263 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
2267 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2270 ALTER TABLE ONLY planets
2271 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
2275 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2278 ALTER TABLE ONLY planets
2279 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
2283 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2286 ALTER TABLE ONLY raid_access
2287 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
2291 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2294 ALTER TABLE ONLY raid_claims
2295 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
2299 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2302 ALTER TABLE ONLY raid_targets
2303 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
2307 -- Name: raid_targets_raid_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2310 ALTER TABLE ONLY raid_targets
2311 ADD CONSTRAINT raid_targets_raid_planet_key UNIQUE (planet, raid);
2315 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2318 ALTER TABLE ONLY raids
2319 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
2323 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2326 ALTER TABLE ONLY scans
2327 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
2331 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2334 ALTER TABLE ONLY scans
2335 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
2339 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2342 ALTER TABLE ONLY ship_stats
2343 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
2347 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2350 ALTER TABLE ONLY smslist
2351 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
2355 -- Name: ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2358 ALTER TABLE ONLY ticks
2359 ADD CONSTRAINT ticks_pkey PRIMARY KEY (tick);
2363 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2366 ALTER TABLE ONLY users
2367 ADD CONSTRAINT users_planet_key UNIQUE (planet);
2371 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
2374 ALTER TABLE ONLY users
2375 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
2379 -- Name: fleets_ingal_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2382 CREATE INDEX fleets_ingal_index ON fleets USING btree (ingal);
2386 -- Name: fleets_mission_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2389 CREATE INDEX fleets_mission_index ON fleets USING btree (mission);
2393 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2396 CREATE INDEX fleets_sender_index ON fleets USING btree (sender);
2400 -- Name: fleets_target_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2403 CREATE INDEX fleets_target_index ON fleets USING btree (target);
2407 -- Name: fleets_tick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2410 CREATE INDEX fleets_tick_index ON fleets USING btree (tick);
2414 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2417 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2421 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2424 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2428 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2431 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2435 -- Name: forum_thread_visits_time_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2438 CREATE INDEX forum_thread_visits_time_index ON forum_thread_visits USING btree ("time");
2442 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2445 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2449 -- Name: planet_data_id_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2452 CREATE INDEX planet_data_id_index ON planet_data USING btree (id);
2456 -- Name: planet_stats_coord_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2459 CREATE INDEX planet_stats_coord_index ON planet_stats USING btree (x, y, z);
2463 -- Name: planet_stats_id_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2466 CREATE INDEX planet_stats_id_index ON planet_stats USING btree (id);
2470 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2473 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2477 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2480 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2484 -- Name: planet_stats_tick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2487 CREATE INDEX planet_stats_tick_index ON planet_stats USING btree (tick);
2491 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2494 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2498 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2501 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2505 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2508 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2512 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2515 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2519 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2522 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
2526 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2529 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2533 -- Name: users_pnick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2536 CREATE UNIQUE INDEX users_pnick_index ON users USING btree (lower(pnick));
2540 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2543 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2547 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: ndawn
2550 CREATE TRIGGER add_call
2551 BEFORE INSERT ON calls
2553 EXECUTE PROCEDURE add_call();
2557 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: ndawn
2560 CREATE TRIGGER add_remove_member
2561 AFTER INSERT OR DELETE ON groupmembers
2563 EXECUTE PROCEDURE change_member();
2567 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: ndawn
2570 CREATE TRIGGER add_user
2571 BEFORE INSERT ON users
2573 EXECUTE PROCEDURE add_user();
2577 -- Name: unclaim_target; Type: TRIGGER; Schema: public; Owner: ndawn
2580 CREATE TRIGGER unclaim_target
2581 AFTER DELETE ON raid_claims
2583 EXECUTE PROCEDURE unclaim_target();
2587 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: ndawn
2590 CREATE TRIGGER update_planet
2591 AFTER UPDATE ON users
2593 EXECUTE PROCEDURE update_user_planet();
2597 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: ndawn
2600 CREATE TRIGGER update_target
2601 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2603 EXECUTE PROCEDURE updated_target();
2607 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2610 ALTER TABLE ONLY alliance_stats
2611 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2615 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2618 ALTER TABLE ONLY calls
2619 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2623 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2626 ALTER TABLE ONLY calls
2627 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
2631 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2634 ALTER TABLE ONLY calls
2635 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2639 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2642 ALTER TABLE ONLY channel_group_flags
2643 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2647 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2650 ALTER TABLE ONLY channel_group_flags
2651 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2655 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2658 ALTER TABLE ONLY channel_group_flags
2659 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2663 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2666 ALTER TABLE ONLY defense_missions
2667 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2671 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2674 ALTER TABLE ONLY defense_missions
2675 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2679 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2682 ALTER TABLE ONLY defense_requests
2683 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2687 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2690 ALTER TABLE ONLY fleet_scans
2691 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON DELETE CASCADE;
2695 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2698 ALTER TABLE ONLY fleet_scans
2699 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2703 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2706 ALTER TABLE ONLY fleet_ships
2707 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2711 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2714 ALTER TABLE ONLY fleet_ships
2715 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(name);
2719 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2722 ALTER TABLE ONLY fleets
2723 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2727 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2730 ALTER TABLE ONLY fleets
2731 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2735 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2738 ALTER TABLE ONLY fleets
2739 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2743 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2746 ALTER TABLE ONLY forum_access
2747 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2751 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2754 ALTER TABLE ONLY forum_access
2755 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2759 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2762 ALTER TABLE ONLY forum_boards
2763 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2767 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2770 ALTER TABLE ONLY forum_posts
2771 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2775 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2778 ALTER TABLE ONLY forum_posts
2779 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2783 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2786 ALTER TABLE ONLY forum_thread_visits
2787 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2791 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2794 ALTER TABLE ONLY forum_thread_visits
2795 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2799 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2802 ALTER TABLE ONLY forum_threads
2803 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2807 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2810 ALTER TABLE ONLY forum_threads
2811 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
2815 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2818 ALTER TABLE ONLY groupmembers
2819 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2823 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2826 ALTER TABLE ONLY groupmembers
2827 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2831 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2834 ALTER TABLE ONLY incomings
2835 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2839 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2842 ALTER TABLE ONLY incomings
2843 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2847 -- Name: intel_messages_handled_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2850 ALTER TABLE ONLY intel_messages
2851 ADD CONSTRAINT intel_messages_handled_by_fkey FOREIGN KEY (handled_by) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2855 -- Name: intel_messages_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2858 ALTER TABLE ONLY intel_messages
2859 ADD CONSTRAINT intel_messages_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2863 -- Name: log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2866 ALTER TABLE ONLY log
2867 ADD CONSTRAINT log_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2871 -- Name: planet_data_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2874 ALTER TABLE ONLY planet_data
2875 ADD CONSTRAINT planet_data_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2879 -- Name: planet_data_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2882 ALTER TABLE ONLY planet_data
2883 ADD CONSTRAINT planet_data_rid_fkey FOREIGN KEY (rid) REFERENCES planet_data_types(id);
2887 -- Name: planet_data_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2890 ALTER TABLE ONLY planet_data
2891 ADD CONSTRAINT planet_data_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2895 -- Name: planet_graphs_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2898 ALTER TABLE ONLY planet_graphs
2899 ADD CONSTRAINT planet_graphs_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id);
2903 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2906 ALTER TABLE ONLY planet_stats
2907 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2911 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2914 ALTER TABLE ONLY planets
2915 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2919 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2922 ALTER TABLE ONLY planets
2923 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2927 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2930 ALTER TABLE ONLY raid_access
2931 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2935 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2938 ALTER TABLE ONLY raid_access
2939 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2943 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2946 ALTER TABLE ONLY raid_claims
2947 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2951 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2954 ALTER TABLE ONLY raid_claims
2955 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2959 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2962 ALTER TABLE ONLY raid_targets
2963 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2967 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2970 ALTER TABLE ONLY raid_targets
2971 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2975 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2978 ALTER TABLE ONLY scans
2979 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2983 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2986 ALTER TABLE ONLY scans
2987 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2991 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2994 ALTER TABLE ONLY users
2995 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2999 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3002 ALTER TABLE ONLY users
3003 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
3007 -- Name: public; Type: ACL; Schema: -; Owner: postgres
3010 REVOKE ALL ON SCHEMA public FROM PUBLIC;
3011 REVOKE ALL ON SCHEMA public FROM postgres;
3012 GRANT ALL ON SCHEMA public TO postgres;
3013 GRANT ALL ON SCHEMA public TO ndawn;
3014 GRANT ALL ON SCHEMA public TO PUBLIC;
3018 -- PostgreSQL database dump complete