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_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: ndawn
31 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
32 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
34 if ($x1 == $x2 && $y1 == $y2) {
38 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
39 $tick = $rv->{rows}[0]->{tick};
41 $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;");
42 unless ($rv->{processed} >= 1){
45 $id1 = $rv->{rows}[0]->{id};
46 $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;");
47 unless ($rv->{processed} >= 1){
50 $id2 = $rv->{rows}[0]->{id};
52 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
57 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;
60 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
63 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
64 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
66 if ($x1 == $x2 && $y1 == $y2) {
70 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
71 $tick = $rv->{rows}[0]->{tick};
73 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
74 unless ($rv->{processed} == 1){
77 $id1 = $rv->{rows}[0]->{id};
78 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
79 unless ($rv->{processed} == 1){
82 $id2 = $rv->{rows}[0]->{id};
83 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
88 ALTER FUNCTION public.add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) OWNER TO ndawn;
91 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
94 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
95 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
96 unless ($uid = /^(-?\d+)$/){
97 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
98 $uid = $rv->{rows}[0]->{id};
101 if ($x1 == $x2 && $y1 == $y2) {
105 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
106 $tick = $rv->{rows}[0]->{tick};
108 $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;");
109 unless ($rv->{processed} >= 1){
112 $id1 = $rv->{rows}[0]->{id};
113 $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;");
114 unless ($rv->{processed} >= 1){
117 $id2 = $rv->{rows}[0]->{id};
119 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
124 ALTER FUNCTION public.add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) OWNER TO ndawn;
127 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: ndawn
130 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
131 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
133 if ($x1 == $x2 && $y1 == $y2) {
137 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
138 $tick = $rv->{rows}[0]->{tick};
140 $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;");
141 unless ($rv->{processed} >= 1){
144 $id1 = $rv->{rows}[0]->{id};
145 $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;");
146 unless ($rv->{processed} >= 1){
149 $id2 = $rv->{rows}[0]->{id};
151 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
156 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;
159 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: ndawn
162 CREATE FUNCTION calc_rank(tick integer) RETURNS void
163 AS $_$my ($tick) = @_;
164 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
166 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
167 my $status = $rv->{status};
168 my $nrows = $rv->{processed};
170 for ($row = 1; $row <= $nrows; ++$row ){
171 $id = $rv->{rows}[$row-1]->{id};
172 $ranks{$id}{'score'} = $row;
175 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
176 my $status = $rv->{status};
177 my $nrows = $rv->{processed};
179 for ($row = 1; $row <= $nrows; ++$row ){
180 $id = $rv->{rows}[$row-1]->{id};
181 $ranks{$id}{'value'} = $row;
184 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
185 my $status = $rv->{status};
186 my $nrows = $rv->{processed};
188 for ($row = 1; $row <= $nrows; ++$row ){
189 $id = $rv->{rows}[$row-1]->{id};
190 $ranks{$id}{'size'} = $row;
193 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
194 my $status = $rv->{status};
195 my $nrows = $rv->{processed};
197 for ($row = 1; $row <= $nrows; ++$row ){
198 $id = $rv->{rows}[$row-1]->{id};
199 $ranks{$id}{'xp'} = $row;
201 foreach $key (keys(%ranks)){
202 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'}.")");
208 ALTER FUNCTION public.calc_rank(tick integer) OWNER TO ndawn;
211 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: ndawn
214 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
215 AS $_$my ($tick) = @_;
216 #spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
218 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
219 my $status = $rv->{status};
220 my $nrows = $rv->{processed};
222 for ($row = 1; $row <= $nrows; ++$row ){
223 $id = $rv->{rows}[$row-1]->{id};
224 #$ranks{$id}{'score'} = $row;
227 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
228 my $status = $rv->{status};
229 my $nrows = $rv->{processed};
231 for ($row = 1; $row <= $nrows; ++$row ){
232 $id = $rv->{rows}[$row-1]->{id};
233 #$ranks{$id}{'value'} = $row;
236 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
237 my $status = $rv->{status};
238 my $nrows = $rv->{processed};
240 for ($row = 1; $row <= $nrows; ++$row ){
241 $id = $rv->{rows}[$row-1]->{id};
242 #$ranks{$id}{'size'} = $row;
245 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
246 my $status = $rv->{status};
247 my $nrows = $rv->{processed};
249 for ($row = 1; $row <= $nrows; ++$row ){
250 $id = $rv->{rows}[$row-1]->{id};
251 #$ranks{$id}{'xp'} = $row;
253 foreach $key (keys(%ranks)){
254 #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'}.")");
260 ALTER FUNCTION public.calc_rank3(tick integer) OWNER TO ndawn;
263 -- Name: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: ndawn
266 CREATE FUNCTION calculate_rankings(integer) RETURNS void
267 AS $_$my ($tick) = @_;
268 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
269 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
270 my $status = $rv->{status};
271 my $nrows = $rv->{processed};
273 for ($row = 1; $row <= $nrows; ++$row ){
274 $id = $rv->{rows}[$row-1]->{id};
275 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
278 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
279 my $status = $rv->{status};
280 my $nrows = $rv->{processed};
282 for ($row = 1; $row <= $nrows; ++$row ){
283 $id = $rv->{rows}[$row-1]->{id};
284 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
287 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
288 my $status = $rv->{status};
289 my $nrows = $rv->{processed};
291 for ($row = 1; $row <= $nrows; ++$row ){
292 $id = $rv->{rows}[$row-1]->{id};
293 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
296 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
297 my $status = $rv->{status};
298 my $nrows = $rv->{processed};
300 for ($row = 1; $row <= $nrows; ++$row ){
301 $id = $rv->{rows}[$row-1]->{id};
302 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
308 ALTER FUNCTION public.calculate_rankings(integer) OWNER TO ndawn;
311 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: ndawn
314 CREATE FUNCTION change_member() RETURNS "trigger"
315 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
316 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
317 if ($rv->{rows}[0]->{planet}){
318 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
321 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
322 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
323 if ($rv->{rows}[0]->{planet}){
324 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
331 ALTER FUNCTION public.change_member() OWNER TO ndawn;
334 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
337 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
338 AS $_$my ($x,$y,$z) = @_;
339 return "$x:$y:$z";$_$
340 LANGUAGE plperl IMMUTABLE;
343 ALTER FUNCTION public.coords(x integer, y integer, z integer) OWNER TO ndawn;
346 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: ndawn
349 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
350 AS $_$my ($name) = @_;
352 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
353 my $rv = spi_exec_prepared($query,$name);
354 my $status = $rv->{status};
355 my $nrows = $rv->{processed};
358 $id = $rv->{rows}[0]->{id};
361 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
362 if ($rv->{processed} != 1){
365 $id = $rv->{rows}[0]->{id};
366 my $query = spi_prepare('INSERT INTO alliances(id,name,relationship) VALUES($1,$2,NULL)','int4','varchar');
367 $rv = spi_exec_prepared($query,$id,$name);
368 spi_freeplan($query);
369 if (rv->{status} != SPI_OK_INSERT){
377 ALTER FUNCTION public.find_alliance_id(character varying) OWNER TO ndawn;
380 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: ndawn
383 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
384 AS $_$my ($ruler, $planet, $race) = @_;
385 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
386 my $rv = spi_exec_prepared($query,$ruler,$planet);
387 spi_freeplan($query);
388 my $status = $rv->{status};
389 my $nrows = $rv->{processed};
392 $id = $rv->{rows}[0]->{id};
393 unless ($race eq $rv->{rows}[0]->{race}){
394 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','varchar','int4');
395 spi_exec_prepared($query,$race,$id);
396 spi_freeplan($query);
399 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
400 if ($rv->{processed} != 1){
403 $id = $rv->{rows}[0]->{id};
404 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race) VALUES($1,$2,$3,$4)','int4','varchar','varchar','varchar');
405 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race);
406 spi_freeplan($query);
407 if (rv->{status} != SPI_OK_INSERT){
410 $query = spi_prepare('INSERT INTO forum_threads (fbid,planet,subject) VALUES($1,$2,$3)','int4','int4','varchar');
411 $rv = spi_exec_prepared($query,-2,$id,"$ruler OF $planet");
412 spi_freeplan($query);
413 if (rv->{status} != SPI_OK_INSERT){
421 ALTER FUNCTION public.findplanetid(character varying, character varying, character varying) OWNER TO ndawn;
424 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: ndawn
427 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
428 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
432 ALTER FUNCTION public.groups(uid integer) OWNER TO ndawn;
435 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
438 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
439 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$_$
440 LANGUAGE sql IMMUTABLE;
443 ALTER FUNCTION public.max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) OWNER TO ndawn;
446 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
449 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
450 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$_$
454 ALTER FUNCTION public.planetid(x integer, y integer, z integer, tick integer) OWNER TO ndawn;
457 -- Name: plperl_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
460 CREATE FUNCTION plperl_call_handler() RETURNS language_handler
461 AS '$libdir/plperl', 'plperl_call_handler'
465 ALTER FUNCTION public.plperl_call_handler() OWNER TO postgres;
468 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: ndawn
471 CREATE FUNCTION populate_ticks() RETURNS void
472 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
473 my $nrows = $rv->{processed};
475 $tick = $rv->{rows}[0]->{tick};
476 spi_exec_query("DELETE FROM ticks;");
477 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);");
478 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
483 ALTER FUNCTION public.populate_ticks() OWNER TO ndawn;
486 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: postgres
489 CREATE FUNCTION tick() RETURNS integer
490 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
494 ALTER FUNCTION public.tick() OWNER TO postgres;
497 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: ndawn
500 CREATE FUNCTION update_user_planet() RETURNS "trigger"
501 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
502 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
503 if ($_TD->{old}{planet}){
504 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
506 if ($_TD->{new}{planet}){
507 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
510 if ($_TD->{old}{planet}){
511 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
513 if ($_TD->{new}{planet}){
514 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
520 ALTER FUNCTION public.update_user_planet() OWNER TO ndawn;
523 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: ndawn
526 CREATE FUNCTION updated_target() RETURNS "trigger"
527 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
528 my $target = $_TD->{new}{target};
529 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
530 spi_exec_prepared($query,$target);
531 spi_freeplan($query);$_X$
535 ALTER FUNCTION public.updated_target() OWNER TO ndawn;
538 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: ndawn
541 CREATE AGGREGATE concat(text) (
548 ALTER AGGREGATE public.concat(text) OWNER TO ndawn;
550 SET default_tablespace = '';
552 SET default_with_oids = false;
555 -- Name: alliance_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
558 CREATE TABLE alliance_stats (
560 tick integer NOT NULL,
561 size integer NOT NULL,
562 members integer NOT NULL,
563 score integer NOT NULL
567 ALTER TABLE public.alliance_stats OWNER TO ndawn;
570 -- Name: alliances; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
573 CREATE TABLE alliances (
575 name character varying NOT NULL,
580 ALTER TABLE public.alliances OWNER TO ndawn;
583 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
586 CREATE SEQUENCE alliances_id_seq
593 ALTER TABLE public.alliances_id_seq OWNER TO ndawn;
596 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
599 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
603 -- Name: calls; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
608 member integer NOT NULL,
610 landing_tick integer NOT NULL,
612 covered boolean DEFAULT false NOT NULL,
614 open boolean DEFAULT true NOT NULL
618 ALTER TABLE public.calls OWNER TO ndawn;
621 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
624 CREATE SEQUENCE calls_id_seq
631 ALTER TABLE public.calls_id_seq OWNER TO ndawn;
634 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
637 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
641 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
644 CREATE TABLE channel_flags (
650 ALTER TABLE public.channel_flags OWNER TO ndawn;
653 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
656 CREATE SEQUENCE channel_flags_id_seq
663 ALTER TABLE public.channel_flags_id_seq OWNER TO ndawn;
666 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
669 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
673 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
676 CREATE TABLE channel_group_flags (
677 channel integer NOT NULL,
678 "group" integer NOT NULL,
679 flag integer NOT NULL
683 ALTER TABLE public.channel_group_flags OWNER TO ndawn;
686 -- Name: channels; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
689 CREATE TABLE channels (
692 description text NOT NULL
696 ALTER TABLE public.channels OWNER TO ndawn;
699 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
702 CREATE SEQUENCE channels_id_seq
709 ALTER TABLE public.channels_id_seq OWNER TO ndawn;
712 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
715 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
719 -- Name: covop_targets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
722 CREATE TABLE covop_targets (
723 planet integer NOT NULL,
735 ALTER TABLE public.covop_targets OWNER TO ndawn;
738 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
741 CREATE TABLE planet_stats (
743 tick integer NOT NULL,
747 size integer NOT NULL,
748 score integer NOT NULL,
749 value integer NOT NULL,
751 sizerank integer NOT NULL,
752 scorerank integer NOT NULL,
753 valuerank integer NOT NULL,
754 xprank integer NOT NULL
758 ALTER TABLE public.planet_stats OWNER TO ndawn;
761 -- Name: planets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
764 CREATE TABLE planets (
766 ruler character varying NOT NULL,
767 planet character varying NOT NULL,
768 race character varying,
769 nick character varying,
771 hit_us integer DEFAULT 0 NOT NULL,
777 ALTER TABLE public.planets OWNER TO ndawn;
780 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: ndawn
783 CREATE VIEW current_planet_stats AS
784 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 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)));
787 ALTER TABLE public.current_planet_stats OWNER TO ndawn;
790 -- Name: defense_requests; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
793 CREATE TABLE defense_requests (
795 uid integer NOT NULL,
796 message text NOT NULL,
797 sent boolean DEFAULT false NOT NULL
801 ALTER TABLE public.defense_requests OWNER TO ndawn;
804 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
807 CREATE SEQUENCE defense_requests_id_seq
814 ALTER TABLE public.defense_requests_id_seq OWNER TO ndawn;
817 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
820 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
824 -- Name: dumps; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
828 tick integer NOT NULL,
829 "type" text NOT NULL,
831 modified integer DEFAULT 0 NOT NULL
835 ALTER TABLE public.dumps OWNER TO ndawn;
838 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
841 CREATE TABLE fleet_ships (
842 fleet integer NOT NULL,
844 amount integer NOT NULL
848 ALTER TABLE public.fleet_ships OWNER TO ndawn;
851 -- Name: fleets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
854 CREATE TABLE fleets (
855 uid integer NOT NULL,
856 fleet integer NOT NULL,
857 target integer NOT NULL,
858 mission text NOT NULL,
859 landing_tick integer NOT NULL,
861 eta integer NOT NULL,
862 back integer NOT NULL
866 ALTER TABLE public.fleets OWNER TO ndawn;
869 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
872 CREATE SEQUENCE fleets_id_seq
879 ALTER TABLE public.fleets_id_seq OWNER TO ndawn;
882 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
885 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
889 -- Name: forum_access; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
892 CREATE TABLE forum_access (
893 fbid integer NOT NULL,
894 gid integer NOT NULL,
895 post boolean DEFAULT false NOT NULL
899 ALTER TABLE public.forum_access OWNER TO ndawn;
902 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
905 CREATE TABLE forum_boards (
906 fbid integer NOT NULL,
907 fcid integer NOT NULL,
912 ALTER TABLE public.forum_boards OWNER TO ndawn;
915 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
918 CREATE SEQUENCE forum_boards_fbid_seq
925 ALTER TABLE public.forum_boards_fbid_seq OWNER TO ndawn;
928 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
931 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
935 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
938 CREATE TABLE forum_categories (
939 fcid integer NOT NULL,
940 category text NOT NULL
944 ALTER TABLE public.forum_categories OWNER TO ndawn;
947 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
950 CREATE SEQUENCE forum_categories_fcid_seq
957 ALTER TABLE public.forum_categories_fcid_seq OWNER TO ndawn;
960 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
963 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
967 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
970 CREATE TABLE forum_posts (
971 fpid integer NOT NULL,
972 ftid integer NOT NULL,
973 message text NOT NULL,
974 "time" timestamp with time zone DEFAULT now() NOT NULL,
979 ALTER TABLE public.forum_posts OWNER TO ndawn;
982 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
985 CREATE SEQUENCE forum_posts_fpid_seq
992 ALTER TABLE public.forum_posts_fpid_seq OWNER TO ndawn;
995 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
998 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1002 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1005 CREATE TABLE forum_thread_visits (
1006 uid integer NOT NULL,
1007 ftid integer NOT NULL,
1008 "time" timestamp with time zone DEFAULT now() NOT NULL
1012 ALTER TABLE public.forum_thread_visits OWNER TO ndawn;
1015 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1018 CREATE TABLE forum_threads (
1019 ftid integer NOT NULL,
1020 fbid integer NOT NULL,
1021 subject text NOT NULL,
1027 ALTER TABLE public.forum_threads OWNER TO ndawn;
1030 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1033 CREATE SEQUENCE forum_threads_ftid_seq
1040 ALTER TABLE public.forum_threads_ftid_seq OWNER TO ndawn;
1043 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1046 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1050 -- Name: galaxies; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1053 CREATE TABLE galaxies (
1056 tick integer NOT NULL,
1057 name character varying NOT NULL,
1058 size integer NOT NULL,
1059 score integer NOT NULL,
1060 value integer NOT NULL
1064 ALTER TABLE public.galaxies OWNER TO ndawn;
1067 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1070 CREATE TABLE groupmembers (
1071 gid integer NOT NULL,
1072 uid integer NOT NULL
1076 ALTER TABLE public.groupmembers OWNER TO ndawn;
1079 -- Name: groups; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1082 CREATE TABLE groups (
1083 gid integer NOT NULL,
1084 groupname text NOT NULL,
1086 attack boolean DEFAULT false NOT NULL
1090 ALTER TABLE public.groups OWNER TO ndawn;
1093 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1096 CREATE SEQUENCE groups_gid_seq
1103 ALTER TABLE public.groups_gid_seq OWNER TO ndawn;
1106 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1109 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1113 -- Name: incomings; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1116 CREATE TABLE incomings (
1117 call integer NOT NULL,
1118 sender integer NOT NULL,
1119 eta integer NOT NULL,
1120 amount integer NOT NULL,
1121 fleet text NOT NULL,
1122 shiptype text DEFAULT '?'::text NOT NULL,
1127 ALTER TABLE public.incomings OWNER TO ndawn;
1130 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1133 CREATE SEQUENCE incomings_id_seq
1140 ALTER TABLE public.incomings_id_seq OWNER TO ndawn;
1143 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1146 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1149 SET default_with_oids = true;
1152 -- Name: intel; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1155 CREATE TABLE intel (
1156 target integer NOT NULL,
1157 sender integer NOT NULL,
1158 tick integer NOT NULL,
1159 mission character varying NOT NULL,
1160 ingal boolean NOT NULL,
1161 amount integer NOT NULL,
1162 eta smallint DEFAULT 16 NOT NULL,
1163 uid integer NOT NULL
1167 ALTER TABLE public.intel OWNER TO ndawn;
1169 SET default_with_oids = false;
1172 -- Name: intel_messages; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1175 CREATE TABLE intel_messages (
1176 id integer NOT NULL,
1177 uid integer NOT NULL,
1178 message text NOT NULL,
1179 handled boolean DEFAULT false NOT NULL,
1181 report_date timestamp with time zone DEFAULT now() NOT NULL
1185 ALTER TABLE public.intel_messages OWNER TO ndawn;
1188 -- Name: intel_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1191 CREATE SEQUENCE intel_messages_id_seq
1198 ALTER TABLE public.intel_messages_id_seq OWNER TO ndawn;
1201 -- Name: intel_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1204 ALTER SEQUENCE intel_messages_id_seq OWNED BY intel_messages.id;
1208 -- Name: log; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1212 id integer NOT NULL,
1213 uid integer NOT NULL,
1214 "time" timestamp without time zone DEFAULT now() NOT NULL,
1219 ALTER TABLE public.log OWNER TO ndawn;
1222 -- Name: log_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1225 CREATE SEQUENCE log_id_seq
1232 ALTER TABLE public.log_id_seq OWNER TO ndawn;
1235 -- Name: log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1238 ALTER SEQUENCE log_id_seq OWNED BY log.id;
1242 -- Name: misc; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1251 ALTER TABLE public.misc OWNER TO ndawn;
1254 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1257 CREATE SEQUENCE planets_id_seq
1264 ALTER TABLE public.planets_id_seq OWNER TO ndawn;
1267 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1270 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1274 -- Name: raid_access; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1277 CREATE TABLE raid_access (
1278 raid integer NOT NULL,
1279 gid integer NOT NULL
1283 ALTER TABLE public.raid_access OWNER TO ndawn;
1286 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1289 CREATE TABLE raid_claims (
1290 target integer NOT NULL,
1291 uid integer NOT NULL,
1292 wave integer NOT NULL,
1293 joinable boolean DEFAULT false NOT NULL,
1294 launched boolean DEFAULT false NOT NULL
1298 ALTER TABLE public.raid_claims OWNER TO ndawn;
1301 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1304 CREATE TABLE raid_targets (
1305 id integer NOT NULL,
1306 raid integer NOT NULL,
1307 planet integer NOT NULL,
1309 modified timestamp with time zone DEFAULT now() NOT NULL
1313 ALTER TABLE public.raid_targets OWNER TO ndawn;
1316 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1319 CREATE SEQUENCE raid_targets_id_seq
1326 ALTER TABLE public.raid_targets_id_seq OWNER TO ndawn;
1329 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1332 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1336 -- Name: raids; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1339 CREATE TABLE raids (
1340 id integer NOT NULL,
1341 tick integer NOT NULL,
1342 open boolean DEFAULT false NOT NULL,
1343 waves integer DEFAULT 3 NOT NULL,
1344 message text NOT NULL,
1345 removed boolean DEFAULT false NOT NULL,
1346 released_coords boolean DEFAULT false NOT NULL
1350 ALTER TABLE public.raids OWNER TO ndawn;
1353 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1356 CREATE SEQUENCE raids_id_seq
1363 ALTER TABLE public.raids_id_seq OWNER TO ndawn;
1366 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1369 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1373 -- Name: scans; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1376 CREATE TABLE scans (
1377 tick integer NOT NULL,
1378 "type" character varying,
1379 scan_id integer NOT NULL,
1385 ALTER TABLE public.scans OWNER TO ndawn;
1388 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1391 CREATE TABLE ship_stats (
1393 "class" text NOT NULL,
1394 target text NOT NULL,
1395 "type" text NOT NULL,
1396 init integer NOT NULL,
1397 armor integer NOT NULL,
1398 damage integer NOT NULL,
1399 metal integer NOT NULL,
1400 crystal integer NOT NULL,
1401 eonium integer NOT NULL,
1403 guns integer DEFAULT 0 NOT NULL,
1404 eres integer DEFAULT 0 NOT NULL
1408 ALTER TABLE public.ship_stats OWNER TO ndawn;
1410 SET default_with_oids = true;
1413 -- Name: ticks; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1416 CREATE TABLE ticks (
1417 tick integer NOT NULL
1421 ALTER TABLE public.ticks OWNER TO ndawn;
1423 SET default_with_oids = false;
1426 -- Name: users; Type: TABLE; Schema: public; Owner: ndawn; Tablespace:
1429 CREATE TABLE users (
1430 uid integer NOT NULL,
1431 username text NOT NULL,
1433 "password" text NOT NULL,
1434 attack_points integer DEFAULT 0 NOT NULL,
1435 defense_points integer DEFAULT 0 NOT NULL,
1436 scan_points integer DEFAULT 0 NOT NULL,
1437 humor_points integer DEFAULT 0 NOT NULL,
1441 laston timestamp with time zone
1445 ALTER TABLE public.users OWNER TO ndawn;
1448 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1451 CREATE SEQUENCE users_uid_seq
1458 ALTER TABLE public.users_uid_seq OWNER TO ndawn;
1461 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1464 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1468 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: ndawn
1471 CREATE VIEW usersingroup AS
1472 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
1475 ALTER TABLE public.usersingroup OWNER TO ndawn;
1478 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1481 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1485 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1488 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1492 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1495 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1499 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1502 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1506 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1509 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1513 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1516 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1520 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: ndawn
1523 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1527 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: ndawn
1530 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1534 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: ndawn
1537 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1541 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: ndawn
1544 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1548 -- Name: gid; Type: DEFAULT; Schema: public; Owner: ndawn
1551 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1555 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1558 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1562 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1565 ALTER TABLE intel_messages ALTER COLUMN id SET DEFAULT nextval('intel_messages_id_seq'::regclass);
1569 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1572 ALTER TABLE log ALTER COLUMN id SET DEFAULT nextval('log_id_seq'::regclass);
1576 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1579 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1583 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1586 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1590 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
1593 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1597 -- Name: uid; Type: DEFAULT; Schema: public; Owner: ndawn
1600 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1604 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1607 ALTER TABLE ONLY users
1608 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1612 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1615 ALTER TABLE ONLY alliance_stats
1616 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1620 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1623 ALTER TABLE ONLY alliances
1624 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1628 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1631 ALTER TABLE ONLY alliances
1632 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1636 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1639 ALTER TABLE ONLY calls
1640 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1644 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1647 ALTER TABLE ONLY calls
1648 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1652 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1655 ALTER TABLE ONLY channel_flags
1656 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1660 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1663 ALTER TABLE ONLY channel_flags
1664 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1668 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1671 ALTER TABLE ONLY channel_group_flags
1672 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
1676 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1679 ALTER TABLE ONLY channels
1680 ADD CONSTRAINT channels_name_key UNIQUE (name);
1684 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1687 ALTER TABLE ONLY channels
1688 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
1692 -- Name: covOp_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1695 ALTER TABLE ONLY covop_targets
1696 ADD CONSTRAINT "covOp_targets_pkey" PRIMARY KEY (planet);
1700 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1703 ALTER TABLE ONLY defense_requests
1704 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
1708 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1711 ALTER TABLE ONLY dumps
1712 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, "type", modified);
1716 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1719 ALTER TABLE ONLY fleet_ships
1720 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (fleet, ship);
1724 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1727 ALTER TABLE ONLY fleets
1728 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
1732 -- Name: fleets_uid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1735 ALTER TABLE ONLY fleets
1736 ADD CONSTRAINT fleets_uid_key UNIQUE (uid, fleet);
1740 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1743 ALTER TABLE ONLY forum_access
1744 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
1748 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1751 ALTER TABLE ONLY forum_boards
1752 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
1756 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1759 ALTER TABLE ONLY forum_boards
1760 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
1764 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1767 ALTER TABLE ONLY forum_categories
1768 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
1772 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1775 ALTER TABLE ONLY forum_categories
1776 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
1780 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1783 ALTER TABLE ONLY forum_posts
1784 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
1788 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1791 ALTER TABLE ONLY forum_thread_visits
1792 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
1796 -- Name: forum_threads_log_uid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1799 ALTER TABLE ONLY forum_threads
1800 ADD CONSTRAINT forum_threads_log_uid_key UNIQUE (log_uid);
1804 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1807 ALTER TABLE ONLY forum_threads
1808 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
1812 -- Name: forum_threads_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1815 ALTER TABLE ONLY forum_threads
1816 ADD CONSTRAINT forum_threads_planet_key UNIQUE (planet);
1820 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1823 ALTER TABLE ONLY galaxies
1824 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
1828 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1831 ALTER TABLE ONLY groupmembers
1832 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
1836 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1839 ALTER TABLE ONLY groups
1840 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
1844 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1847 ALTER TABLE ONLY groups
1848 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
1852 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1855 ALTER TABLE ONLY incomings
1856 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
1860 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1863 ALTER TABLE ONLY incomings
1864 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
1868 -- Name: intel_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1871 ALTER TABLE ONLY intel_messages
1872 ADD CONSTRAINT intel_messages_pkey PRIMARY KEY (id);
1876 -- Name: log_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1879 ALTER TABLE ONLY log
1880 ADD CONSTRAINT log_pkey PRIMARY KEY (id);
1884 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1887 ALTER TABLE ONLY misc
1888 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
1892 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1895 ALTER TABLE ONLY planet_stats
1896 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
1900 -- Name: planet_stats_tick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1903 ALTER TABLE ONLY planet_stats
1904 ADD CONSTRAINT planet_stats_tick_key UNIQUE (tick, x, y, z);
1908 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1911 ALTER TABLE ONLY planets
1912 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
1916 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1919 ALTER TABLE ONLY planets
1920 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
1924 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1927 ALTER TABLE ONLY raid_access
1928 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
1932 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1935 ALTER TABLE ONLY raid_claims
1936 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
1940 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1943 ALTER TABLE ONLY raid_targets
1944 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
1948 -- Name: raid_targets_raid_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1951 ALTER TABLE ONLY raid_targets
1952 ADD CONSTRAINT raid_targets_raid_planet_key UNIQUE (planet, raid);
1956 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1959 ALTER TABLE ONLY raids
1960 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
1964 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1967 ALTER TABLE ONLY scans
1968 ADD CONSTRAINT scans_pkey PRIMARY KEY (tick, scan_id);
1972 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1975 ALTER TABLE ONLY ship_stats
1976 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
1980 -- Name: ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1983 ALTER TABLE ONLY ticks
1984 ADD CONSTRAINT ticks_pkey PRIMARY KEY (tick);
1988 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn; Tablespace:
1991 ALTER TABLE ONLY users
1992 ADD CONSTRAINT users_planet_key UNIQUE (planet);
1996 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
1999 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2003 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2006 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2010 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2013 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2017 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2020 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2024 -- Name: inteL_ingal_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2027 CREATE INDEX "inteL_ingal_index" ON intel USING btree (ingal);
2031 -- Name: intel_eta_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2034 CREATE INDEX intel_eta_index ON intel USING btree (eta);
2038 -- Name: intel_launchtick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2041 CREATE INDEX intel_launchtick_index ON intel USING btree (((tick - eta)));
2045 -- Name: intel_mission_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2048 CREATE INDEX intel_mission_index ON intel USING btree (mission);
2052 -- Name: intel_sender_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2055 CREATE INDEX intel_sender_index ON intel USING btree (sender);
2059 -- Name: intel_target_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2062 CREATE INDEX intel_target_index ON intel USING btree (target);
2066 -- Name: intel_tick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2069 CREATE INDEX intel_tick_index ON intel USING btree (tick);
2073 -- Name: planet_stats_coord_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2076 CREATE INDEX planet_stats_coord_index ON planet_stats USING btree (x, y, z);
2080 -- Name: planet_stats_id_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2083 CREATE INDEX planet_stats_id_index ON planet_stats USING btree (id);
2087 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2090 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2094 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2097 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2101 -- Name: planet_stats_tick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2104 CREATE INDEX planet_stats_tick_index ON planet_stats USING btree (tick);
2108 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2111 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2115 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2118 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2122 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2125 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2129 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2132 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2136 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2139 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2143 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: ndawn; Tablespace:
2146 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2150 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: ndawn
2153 CREATE TRIGGER add_remove_member
2154 AFTER INSERT OR DELETE ON groupmembers
2156 EXECUTE PROCEDURE change_member();
2160 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: ndawn
2163 CREATE TRIGGER update_planet
2164 AFTER UPDATE ON users
2166 EXECUTE PROCEDURE update_user_planet();
2170 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: ndawn
2173 CREATE TRIGGER update_target
2174 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2176 EXECUTE PROCEDURE updated_target();
2180 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2183 ALTER TABLE ONLY alliance_stats
2184 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2188 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2191 ALTER TABLE ONLY calls
2192 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2196 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2199 ALTER TABLE ONLY calls
2200 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2204 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2207 ALTER TABLE ONLY channel_group_flags
2208 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2212 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2215 ALTER TABLE ONLY channel_group_flags
2216 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2220 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2223 ALTER TABLE ONLY channel_group_flags
2224 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2228 -- Name: covOp_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2231 ALTER TABLE ONLY covop_targets
2232 ADD CONSTRAINT "covOp_targets_planet_fkey" FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2236 -- Name: covop_targets_covop_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2239 ALTER TABLE ONLY covop_targets
2240 ADD CONSTRAINT covop_targets_covop_by_fkey FOREIGN KEY (covop_by) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2244 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2247 ALTER TABLE ONLY defense_requests
2248 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2252 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2255 ALTER TABLE ONLY fleet_ships
2256 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2260 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2263 ALTER TABLE ONLY fleets
2264 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2268 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2271 ALTER TABLE ONLY fleets
2272 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2276 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2279 ALTER TABLE ONLY forum_access
2280 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2284 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2287 ALTER TABLE ONLY forum_access
2288 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2292 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2295 ALTER TABLE ONLY forum_boards
2296 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2300 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2303 ALTER TABLE ONLY forum_posts
2304 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2308 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2311 ALTER TABLE ONLY forum_posts
2312 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2316 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2319 ALTER TABLE ONLY forum_thread_visits
2320 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2324 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2327 ALTER TABLE ONLY forum_thread_visits
2328 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2332 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2335 ALTER TABLE ONLY forum_threads
2336 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2340 -- Name: forum_threads_log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2343 ALTER TABLE ONLY forum_threads
2344 ADD CONSTRAINT forum_threads_log_uid_fkey FOREIGN KEY (log_uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2348 -- Name: forum_threads_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2351 ALTER TABLE ONLY forum_threads
2352 ADD CONSTRAINT forum_threads_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2356 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2359 ALTER TABLE ONLY groupmembers
2360 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2364 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2367 ALTER TABLE ONLY groupmembers
2368 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2372 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2375 ALTER TABLE ONLY incomings
2376 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2380 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2383 ALTER TABLE ONLY incomings
2384 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2388 -- Name: intel_messages_handled_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2391 ALTER TABLE ONLY intel_messages
2392 ADD CONSTRAINT intel_messages_handled_by_fkey FOREIGN KEY (handled_by) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2396 -- Name: intel_messages_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2399 ALTER TABLE ONLY intel_messages
2400 ADD CONSTRAINT intel_messages_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2404 -- Name: intel_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2407 ALTER TABLE ONLY intel
2408 ADD CONSTRAINT intel_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2412 -- Name: intel_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2415 ALTER TABLE ONLY intel
2416 ADD CONSTRAINT intel_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2420 -- Name: intel_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2423 ALTER TABLE ONLY intel
2424 ADD CONSTRAINT intel_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2428 -- Name: log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2431 ALTER TABLE ONLY log
2432 ADD CONSTRAINT log_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2436 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2439 ALTER TABLE ONLY planet_stats
2440 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2444 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2447 ALTER TABLE ONLY planets
2448 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2452 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2455 ALTER TABLE ONLY raid_access
2456 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2460 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2463 ALTER TABLE ONLY raid_access
2464 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2468 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2471 ALTER TABLE ONLY raid_claims
2472 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2476 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2479 ALTER TABLE ONLY raid_claims
2480 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2484 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2487 ALTER TABLE ONLY raid_targets
2488 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2492 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2495 ALTER TABLE ONLY raid_targets
2496 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2500 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2503 ALTER TABLE ONLY scans
2504 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2508 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
2511 ALTER TABLE ONLY users
2512 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2516 -- Name: public; Type: ACL; Schema: -; Owner: postgres
2519 REVOKE ALL ON SCHEMA public FROM PUBLIC;
2520 REVOKE ALL ON SCHEMA public FROM postgres;
2521 GRANT ALL ON SCHEMA public TO postgres;
2522 GRANT ALL ON SCHEMA public TO ndawn;
2523 GRANT ALL ON SCHEMA public TO PUBLIC;
2527 -- PostgreSQL database dump complete