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: plperl; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
15 CREATE PROCEDURAL LANGUAGE plperl;
19 -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: -
22 CREATE PROCEDURAL LANGUAGE plpgsql;
25 SET search_path = public, pg_catalog;
27 SET default_tablespace = '';
29 SET default_with_oids = false;
32 -- Name: alliance_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
35 CREATE TABLE alliance_stats (
37 tick integer NOT NULL,
38 size integer NOT NULL,
39 members integer NOT NULL,
40 score integer NOT NULL,
41 sizerank integer NOT NULL,
42 scorerank integer NOT NULL,
43 size_gain integer NOT NULL,
44 score_gain integer NOT NULL,
45 sizerank_gain integer NOT NULL,
46 scorerank_gain integer NOT NULL,
47 size_gain_day integer NOT NULL,
48 score_gain_day integer NOT NULL,
49 sizerank_gain_day integer NOT NULL,
50 scorerank_gain_day integer NOT NULL,
51 members_gain integer NOT NULL,
52 members_gain_day integer NOT NULL
57 -- Name: ead_status; Type: TYPE; Schema: public; Owner: -
60 CREATE TYPE ead_status AS ENUM (
69 -- Name: alliances; Type: TABLE; Schema: public; Owner: -; Tablespace:
72 CREATE TABLE alliances (
74 name character varying NOT NULL,
75 relationship ead_status DEFAULT ''::ead_status NOT NULL
80 -- Name: calls; Type: TABLE; Schema: public; Owner: -; Tablespace:
85 member integer NOT NULL,
87 landing_tick integer NOT NULL,
89 covered boolean DEFAULT false NOT NULL,
91 open boolean DEFAULT true NOT NULL,
97 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: -; Tablespace:
100 CREATE TABLE channel_flags (
107 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: -; Tablespace:
110 CREATE TABLE channel_group_flags (
111 channel integer NOT NULL,
112 "group" integer NOT NULL,
113 flag integer NOT NULL
118 -- Name: channels; Type: TABLE; Schema: public; Owner: -; Tablespace:
121 CREATE TABLE channels (
124 description text NOT NULL
129 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
132 CREATE TABLE planet_stats (
134 tick integer NOT NULL,
138 size integer NOT NULL,
139 score integer NOT NULL,
140 value integer NOT NULL,
142 sizerank integer NOT NULL,
143 scorerank integer NOT NULL,
144 valuerank integer NOT NULL,
145 xprank integer NOT NULL,
146 size_gain integer NOT NULL,
147 score_gain integer NOT NULL,
148 value_gain integer NOT NULL,
149 xp_gain integer NOT NULL,
150 sizerank_gain integer NOT NULL,
151 scorerank_gain integer NOT NULL,
152 valuerank_gain integer NOT NULL,
153 xprank_gain integer NOT NULL,
154 size_gain_day integer NOT NULL,
155 score_gain_day integer NOT NULL,
156 value_gain_day integer NOT NULL,
157 xp_gain_day integer NOT NULL,
158 sizerank_gain_day integer NOT NULL,
159 scorerank_gain_day integer NOT NULL,
160 valuerank_gain_day integer NOT NULL,
161 xprank_gain_day integer NOT NULL
166 -- Name: planets; Type: TABLE; Schema: public; Owner: -; Tablespace:
169 CREATE TABLE planets (
171 ruler character varying NOT NULL,
172 planet character varying NOT NULL,
173 race character varying,
174 nick character varying,
175 planet_status ead_status DEFAULT ''::ead_status NOT NULL,
176 hit_us integer DEFAULT 0 NOT NULL,
184 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: -
187 CREATE VIEW current_planet_stats AS
188 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)));
192 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: -
195 CREATE VIEW current_planet_stats_full AS
196 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)));
200 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: -; Tablespace:
203 CREATE TABLE defense_missions (
204 call integer NOT NULL,
205 fleet integer NOT NULL,
206 announced boolean DEFAULT false NOT NULL,
207 pointed boolean DEFAULT false NOT NULL
212 -- Name: defense_requests; Type: TABLE; Schema: public; Owner: -; Tablespace:
215 CREATE TABLE defense_requests (
217 uid integer NOT NULL,
218 message text NOT NULL,
219 sent boolean DEFAULT false NOT NULL
224 -- Name: dumps; Type: TABLE; Schema: public; Owner: -; Tablespace:
228 tick integer NOT NULL,
231 modified integer DEFAULT 0 NOT NULL
236 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
239 CREATE TABLE fleet_scans (
241 scan integer NOT NULL
246 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: -; Tablespace:
249 CREATE TABLE fleet_ships (
252 amount integer NOT NULL,
258 -- Name: fleets; Type: TABLE; Schema: public; Owner: -; Tablespace:
261 CREATE TABLE fleets (
262 uid integer NOT NULL,
264 mission text NOT NULL,
265 tick integer NOT NULL,
269 sender integer NOT NULL,
272 ingal boolean DEFAULT false NOT NULL
277 -- Name: forum_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
280 CREATE TABLE forum_access (
281 fbid integer NOT NULL,
282 gid integer NOT NULL,
283 post boolean DEFAULT false NOT NULL,
284 moderate boolean DEFAULT false NOT NULL
289 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: -; Tablespace:
292 CREATE TABLE forum_boards (
293 fbid integer NOT NULL,
294 fcid integer NOT NULL,
300 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: -; Tablespace:
303 CREATE TABLE forum_categories (
304 fcid integer NOT NULL,
305 category text NOT NULL
310 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: -; Tablespace:
313 CREATE TABLE forum_posts (
314 fpid integer NOT NULL,
315 ftid integer NOT NULL,
316 message text NOT NULL,
317 "time" timestamp with time zone DEFAULT now() NOT NULL,
318 uid integer NOT NULL,
324 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: -; Tablespace:
327 CREATE TABLE forum_thread_visits (
328 uid integer NOT NULL,
329 ftid integer NOT NULL,
330 "time" timestamp with time zone DEFAULT now() NOT NULL
335 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: -; Tablespace:
338 CREATE TABLE forum_threads (
339 ftid integer NOT NULL,
340 fbid integer NOT NULL,
341 subject text NOT NULL,
342 sticky boolean DEFAULT false NOT NULL,
348 -- Name: galaxies; Type: TABLE; Schema: public; Owner: -; Tablespace:
351 CREATE TABLE galaxies (
354 tick integer NOT NULL,
355 size integer NOT NULL,
356 score integer NOT NULL,
357 value integer NOT NULL,
359 planets integer NOT NULL,
360 sizerank integer NOT NULL,
361 scorerank integer NOT NULL,
362 valuerank integer NOT NULL,
363 xprank integer NOT NULL,
364 size_gain integer NOT NULL,
365 score_gain integer NOT NULL,
366 value_gain integer NOT NULL,
367 xp_gain integer NOT NULL,
368 planets_gain integer NOT NULL,
369 sizerank_gain integer NOT NULL,
370 scorerank_gain integer NOT NULL,
371 valuerank_gain integer NOT NULL,
372 xprank_gain integer NOT NULL,
373 size_gain_day integer NOT NULL,
374 score_gain_day integer NOT NULL,
375 value_gain_day integer NOT NULL,
376 xp_gain_day integer NOT NULL,
377 planets_gain_day integer NOT NULL,
378 sizerank_gain_day integer NOT NULL,
379 scorerank_gain_day integer NOT NULL,
380 valuerank_gain_day integer NOT NULL,
381 xprank_gain_day integer NOT NULL
386 -- Name: graphs; Type: TABLE; Schema: public; Owner: -; Tablespace:
389 CREATE TABLE graphs (
392 last_modified timestamp with time zone DEFAULT now() NOT NULL,
393 tick integer NOT NULL,
399 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: -; Tablespace:
402 CREATE TABLE groupmembers (
403 gid integer NOT NULL,
409 -- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
412 CREATE TABLE groups (
413 gid integer NOT NULL,
414 groupname text NOT NULL,
416 attack boolean DEFAULT false NOT NULL
421 -- Name: incomings; Type: TABLE; Schema: public; Owner: -; Tablespace:
424 CREATE TABLE incomings (
425 call integer NOT NULL,
426 sender integer NOT NULL,
427 eta integer NOT NULL,
428 amount integer NOT NULL,
430 shiptype text DEFAULT '?'::text NOT NULL,
436 -- Name: misc; Type: TABLE; Schema: public; Owner: -; Tablespace:
446 -- Name: planet_data; Type: TABLE; Schema: public; Owner: -; Tablespace:
449 CREATE TABLE planet_data (
451 scan integer NOT NULL,
452 tick integer NOT NULL,
453 rid integer NOT NULL,
454 amount integer NOT NULL
459 -- Name: planet_data_types; Type: TABLE; Schema: public; Owner: -; Tablespace:
462 CREATE TABLE planet_data_types (
464 category text NOT NULL,
470 -- Name: scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
474 tick integer NOT NULL,
475 scan_id numeric(10,0) NOT NULL,
478 uid integer DEFAULT -1 NOT NULL,
479 groupscan boolean DEFAULT false NOT NULL,
480 parsed boolean DEFAULT false NOT NULL,
486 -- Name: planet_scans; Type: VIEW; Schema: public; Owner: -
489 CREATE VIEW planet_scans AS
490 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;
494 -- Name: raid_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
497 CREATE TABLE raid_access (
498 raid integer NOT NULL,
504 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: -; Tablespace:
507 CREATE TABLE raid_claims (
508 target integer NOT NULL,
509 uid integer NOT NULL,
510 wave integer NOT NULL,
511 joinable boolean DEFAULT false NOT NULL,
512 launched boolean DEFAULT false NOT NULL,
513 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
518 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
521 CREATE TABLE raid_targets (
523 raid integer NOT NULL,
524 planet integer NOT NULL,
526 modified timestamp with time zone DEFAULT now() NOT NULL
531 -- Name: raids; Type: TABLE; Schema: public; Owner: -; Tablespace:
536 tick integer NOT NULL,
537 open boolean DEFAULT false NOT NULL,
538 waves integer DEFAULT 3 NOT NULL,
539 message text NOT NULL,
540 removed boolean DEFAULT false NOT NULL,
541 released_coords boolean DEFAULT false NOT NULL
546 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
549 CREATE TABLE ship_stats (
554 init integer NOT NULL,
555 armor integer NOT NULL,
556 damage integer NOT NULL,
557 metal integer NOT NULL,
558 crystal integer NOT NULL,
559 eonium integer NOT NULL,
561 guns integer DEFAULT 0 NOT NULL,
562 eres integer DEFAULT 0 NOT NULL,
569 -- Name: smslist; Type: TABLE; Schema: public; Owner: -; Tablespace:
572 CREATE TABLE smslist (
580 -- Name: structure_scans; Type: VIEW; Schema: public; Owner: -
583 CREATE VIEW structure_scans AS
584 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;
588 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
592 uid integer NOT NULL,
593 username text NOT NULL,
595 password text NOT NULL,
596 attack_points integer DEFAULT 0 NOT NULL,
597 defense_points integer DEFAULT 0 NOT NULL,
598 scan_points integer DEFAULT 0 NOT NULL,
599 humor_points integer DEFAULT 0 NOT NULL,
603 laston timestamp with time zone,
606 last_forum_visit timestamp with time zone,
614 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: -
617 CREATE VIEW usersingroup AS
618 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
622 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: -
625 CREATE FUNCTION add_call() RETURNS trigger
627 if ($_TD->{event} eq 'INSERT'){
628 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
629 if ($rv->{processed} != 1){
632 $ftid = $rv->{rows}[0]->{id};
633 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES(-3,$1,$2,-3)','int4','varchar');
634 $rv = spi_exec_prepared($query,$ftid,"$_TD->{new}{member}: $_TD->{new}{landing_tick}");
635 spi_freeplan($query);
636 if (rv->{status} != SPI_OK_INSERT){
639 $_TD->{new}{ftid} = $ftid;
648 -- Name: add_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
651 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
652 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
654 $tick = -1 unless defined $tick;
655 if ($x1 == $x2 && $y1 == $y2) {
659 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
660 $tick = $rv->{rows}[0]->{tick};
662 $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;");
663 unless ($rv->{processed} >= 1){
666 $id1 = $rv->{rows}[0]->{id};
667 $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;");
668 unless ($rv->{processed} >= 1){
671 $id2 = $rv->{rows}[0]->{id};
673 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
679 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
682 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
683 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
685 if ($x1 == $x2 && $y1 == $y2) {
689 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
690 $tick = $rv->{rows}[0]->{tick};
692 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
693 unless ($rv->{processed} == 1){
696 $id1 = $rv->{rows}[0]->{id};
697 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
698 unless ($rv->{processed} == 1){
701 $id2 = $rv->{rows}[0]->{id};
702 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
708 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
711 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
712 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
713 unless ($uid = /^(-?\d+)$/){
714 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
715 $uid = $rv->{rows}[0]->{id};
718 if ($x1 == $x2 && $y1 == $y2) {
722 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
723 $tick = $rv->{rows}[0]->{tick};
725 $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;");
726 unless ($rv->{processed} >= 1){
729 $id1 = $rv->{rows}[0]->{id};
730 $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;");
731 unless ($rv->{processed} >= 1){
734 $id2 = $rv->{rows}[0]->{id};
736 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
742 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
745 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
746 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
748 if ($x1 == $x2 && $y1 == $y2) {
752 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
753 $tick = $rv->{rows}[0]->{tick};
755 $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;");
756 unless ($rv->{processed} >= 1){
759 $id1 = $rv->{rows}[0]->{id};
760 $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;");
761 unless ($rv->{processed} >= 1){
764 $id2 = $rv->{rows}[0]->{id};
766 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
772 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: -
775 CREATE FUNCTION add_user() RETURNS trigger
777 if ($_TD->{event} eq 'INSERT'){
778 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
779 if ($rv->{processed} != 1){
782 $ftid = $rv->{rows}[0]->{id};
783 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
784 $rv = spi_exec_prepared($query,-1,$ftid,"$_TD->{new}{uid}: $_TD->{new}{username}");
785 spi_freeplan($query);
786 if (rv->{status} != SPI_OK_INSERT){
789 $_TD->{new}{ftid} = $ftid;
798 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: -
801 CREATE FUNCTION calc_rank(tick integer) RETURNS void
802 AS $_$my ($tick) = @_;
803 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
805 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
806 my $status = $rv->{status};
807 my $nrows = $rv->{processed};
809 for ($row = 1; $row <= $nrows; ++$row ){
810 $id = $rv->{rows}[$row-1]->{id};
811 $ranks{$id}{'score'} = $row;
814 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
815 my $status = $rv->{status};
816 my $nrows = $rv->{processed};
818 for ($row = 1; $row <= $nrows; ++$row ){
819 $id = $rv->{rows}[$row-1]->{id};
820 $ranks{$id}{'value'} = $row;
823 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
824 my $status = $rv->{status};
825 my $nrows = $rv->{processed};
827 for ($row = 1; $row <= $nrows; ++$row ){
828 $id = $rv->{rows}[$row-1]->{id};
829 $ranks{$id}{'size'} = $row;
832 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
833 my $status = $rv->{status};
834 my $nrows = $rv->{processed};
836 for ($row = 1; $row <= $nrows; ++$row ){
837 $id = $rv->{rows}[$row-1]->{id};
838 $ranks{$id}{'xp'} = $row;
840 foreach $key (keys(%ranks)){
841 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'}.")");
848 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: -
851 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
852 AS $_$my ($tick) = @_;
853 #spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
855 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
856 my $status = $rv->{status};
857 my $nrows = $rv->{processed};
859 for ($row = 1; $row <= $nrows; ++$row ){
860 $id = $rv->{rows}[$row-1]->{id};
861 #$ranks{$id}{'score'} = $row;
864 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
865 my $status = $rv->{status};
866 my $nrows = $rv->{processed};
868 for ($row = 1; $row <= $nrows; ++$row ){
869 $id = $rv->{rows}[$row-1]->{id};
870 #$ranks{$id}{'value'} = $row;
873 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
874 my $status = $rv->{status};
875 my $nrows = $rv->{processed};
877 for ($row = 1; $row <= $nrows; ++$row ){
878 $id = $rv->{rows}[$row-1]->{id};
879 #$ranks{$id}{'size'} = $row;
882 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
883 my $status = $rv->{status};
884 my $nrows = $rv->{processed};
886 for ($row = 1; $row <= $nrows; ++$row ){
887 $id = $rv->{rows}[$row-1]->{id};
888 #$ranks{$id}{'xp'} = $row;
890 foreach $key (keys(%ranks)){
891 #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'}.")");
898 -- Name: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: -
901 CREATE FUNCTION calculate_rankings(integer) RETURNS void
902 AS $_$my ($tick) = @_;
903 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
904 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
905 my $status = $rv->{status};
906 my $nrows = $rv->{processed};
908 for ($row = 1; $row <= $nrows; ++$row ){
909 $id = $rv->{rows}[$row-1]->{id};
910 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
913 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
914 my $status = $rv->{status};
915 my $nrows = $rv->{processed};
917 for ($row = 1; $row <= $nrows; ++$row ){
918 $id = $rv->{rows}[$row-1]->{id};
919 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
922 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
923 my $status = $rv->{status};
924 my $nrows = $rv->{processed};
926 for ($row = 1; $row <= $nrows; ++$row ){
927 $id = $rv->{rows}[$row-1]->{id};
928 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
931 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
932 my $status = $rv->{status};
933 my $nrows = $rv->{processed};
935 for ($row = 1; $row <= $nrows; ++$row ){
936 $id = $rv->{rows}[$row-1]->{id};
937 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
944 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: -
947 CREATE FUNCTION change_member() RETURNS trigger
948 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
949 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
950 if ($rv->{rows}[0]->{planet}){
951 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
954 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
955 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
956 if ($rv->{rows}[0]->{planet}){
957 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
965 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
968 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
969 AS $_$my ($x,$y,$z) = @_;
970 return "$x:$y:$z";$_$
971 LANGUAGE plperl IMMUTABLE;
975 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: -
978 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
981 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
982 my $rv = spi_exec_prepared($query,$name);
983 my $status = $rv->{status};
984 my $nrows = $rv->{processed};
987 $id = $rv->{rows}[0]->{id};
990 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
991 if ($rv->{processed} != 1){
994 $id = $rv->{rows}[0]->{id};
995 my $query = spi_prepare('INSERT INTO alliances(id,name) VALUES($1,$2)','int4','varchar');
996 $rv = spi_exec_prepared($query,$id,$name);
997 spi_freeplan($query);
998 if (rv->{status} != SPI_OK_INSERT){
1008 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
1011 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
1012 AS $_$my ($ruler, $planet, $race) = @_;
1013 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
1014 my $rv = spi_exec_prepared($query,$ruler,$planet);
1015 spi_freeplan($query);
1016 my $status = $rv->{status};
1017 my $nrows = $rv->{processed};
1020 $id = $rv->{rows}[0]->{id};
1021 unless ($race eq $rv->{rows}[0]->{race}){
1022 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','varchar','int4');
1023 spi_exec_prepared($query,$race,$id);
1024 spi_freeplan($query);
1027 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
1028 if ($rv->{processed} != 1){
1031 $ftid = $rv->{rows}[0]->{id};
1032 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
1033 $rv = spi_exec_prepared($query,-2,$ftid,"$ruler OF $planet");
1034 spi_freeplan($query);
1035 if (rv->{status} != SPI_OK_INSERT){
1038 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
1039 if ($rv->{processed} != 1){
1042 $id = $rv->{rows}[0]->{id};
1043 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race,ftid) VALUES($1,$2,$3,$4,$5)','int4','varchar','varchar','varchar','int4
1045 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race,$ftid);
1046 spi_freeplan($query);
1047 if (rv->{status} != SPI_OK_INSERT){
1057 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: -
1060 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
1061 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
1062 LANGUAGE sql STABLE;
1066 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1069 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
1070 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$_$
1071 LANGUAGE sql IMMUTABLE;
1075 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: -
1078 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
1079 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$
1080 LANGUAGE sql IMMUTABLE;
1084 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: -
1087 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
1088 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$_$
1089 LANGUAGE sql STABLE;
1093 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1096 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
1097 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$_$
1098 LANGUAGE sql STABLE;
1102 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: -
1105 CREATE FUNCTION populate_ticks() RETURNS void
1106 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
1107 my $nrows = $rv->{processed};
1109 $tick = $rv->{rows}[0]->{tick};
1110 spi_exec_query("DELETE FROM ticks;");
1111 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);");
1112 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
1118 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: -
1121 CREATE FUNCTION tick() RETURNS integer
1122 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
1123 LANGUAGE sql STABLE;
1127 -- Name: unclaim_target(); Type: FUNCTION; Schema: public; Owner: -
1130 CREATE FUNCTION unclaim_target() RETURNS trigger
1132 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{launched} eq 't'){
1133 my $uid = $_TD->{old}{uid};
1134 my $query = spi_prepare(q{UPDATE users
1135 SET attack_points = attack_points - 1
1136 WHERE uid = $1},'int4');
1137 spi_exec_prepared($query,$uid);
1138 spi_freeplan($query);
1146 -- Name: update_forum_post(); Type: FUNCTION; Schema: public; Owner: -
1149 CREATE FUNCTION update_forum_post() RETURNS trigger
1154 SELECT setweight(to_tsvector(coalesce(ft.subject,'')), 'A')
1155 || setweight(to_tsvector(coalesce(u.username,'')), 'B') AS ts
1157 FROM forum_threads ft, users u
1158 WHERE NEW.ftid = ft.ftid AND u.uid = NEW.uid;
1159 NEW.textsearch := rec.ts
1160 || setweight(to_tsvector(coalesce(NEW.message,'')), 'D');
1168 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: -
1171 CREATE FUNCTION update_user_planet() RETURNS trigger
1172 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
1173 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
1174 if ($_TD->{old}{planet}){
1175 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
1177 if ($_TD->{new}{planet}){
1178 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
1181 if ($_TD->{old}{planet}){
1182 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
1184 if ($_TD->{new}{planet}){
1185 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
1192 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: -
1195 CREATE FUNCTION updated_target() RETURNS trigger
1196 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
1197 my $target = $_TD->{new}{target};
1198 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
1199 spi_exec_prepared($query,$target);
1200 spi_freeplan($query);$_X$
1205 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
1208 CREATE AGGREGATE concat(text) (
1216 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1219 CREATE SEQUENCE alliances_id_seq
1227 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1230 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
1234 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1237 CREATE SEQUENCE calls_id_seq
1246 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1249 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
1253 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1256 CREATE SEQUENCE channel_flags_id_seq
1264 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1267 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
1271 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1274 CREATE SEQUENCE channels_id_seq
1282 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1285 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
1289 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1292 CREATE SEQUENCE defense_requests_id_seq
1301 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1304 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
1308 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: -
1311 CREATE SEQUENCE fleet_ships_num_seq
1319 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1322 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1326 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1329 CREATE SEQUENCE fleets_id_seq
1337 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1340 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
1344 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: -
1347 CREATE SEQUENCE forum_boards_fbid_seq
1355 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1358 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1362 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: -
1365 CREATE SEQUENCE forum_categories_fcid_seq
1373 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1376 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1380 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: -
1383 CREATE SEQUENCE forum_posts_fpid_seq
1391 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1394 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1398 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: -
1401 CREATE SEQUENCE forum_threads_ftid_seq
1409 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1412 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1416 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
1419 CREATE SEQUENCE groups_gid_seq
1427 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1430 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1434 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1437 CREATE SEQUENCE incomings_id_seq
1446 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1449 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1453 -- Name: planet_data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1456 CREATE SEQUENCE planet_data_types_id_seq
1464 -- Name: planet_data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1467 ALTER SEQUENCE planet_data_types_id_seq OWNED BY planet_data_types.id;
1471 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1474 CREATE SEQUENCE planets_id_seq
1482 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1485 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1489 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1492 CREATE SEQUENCE raid_targets_id_seq
1501 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1504 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1508 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1511 CREATE SEQUENCE raids_id_seq
1520 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1523 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1527 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1530 CREATE SEQUENCE scans_id_seq
1539 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1542 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
1546 -- Name: test; Type: SEQUENCE; Schema: public; Owner: -
1549 CREATE SEQUENCE test
1557 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
1560 CREATE SEQUENCE users_uid_seq
1568 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1571 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1575 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1578 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1582 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1585 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1589 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1592 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1596 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1599 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1603 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1606 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1610 -- Name: num; Type: DEFAULT; Schema: public; Owner: -
1613 ALTER TABLE fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
1617 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1620 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1624 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: -
1627 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1631 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: -
1634 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1638 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: -
1641 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1645 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: -
1648 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1652 -- Name: gid; Type: DEFAULT; Schema: public; Owner: -
1655 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1659 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1662 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1666 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1669 ALTER TABLE planet_data_types ALTER COLUMN id SET DEFAULT nextval('planet_data_types_id_seq'::regclass);
1673 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1676 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1680 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1683 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1687 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1690 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1694 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1697 ALTER TABLE scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
1701 -- Name: uid; Type: DEFAULT; Schema: public; Owner: -
1704 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1708 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1711 ALTER TABLE ONLY users
1712 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1716 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1719 ALTER TABLE ONLY alliance_stats
1720 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1724 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1727 ALTER TABLE ONLY alliances
1728 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1732 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1735 ALTER TABLE ONLY alliances
1736 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1740 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1743 ALTER TABLE ONLY calls
1744 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1748 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1751 ALTER TABLE ONLY calls
1752 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1756 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1759 ALTER TABLE ONLY channel_flags
1760 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1764 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1767 ALTER TABLE ONLY channel_flags
1768 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1772 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1775 ALTER TABLE ONLY channel_group_flags
1776 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
1780 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1783 ALTER TABLE ONLY channels
1784 ADD CONSTRAINT channels_name_key UNIQUE (name);
1788 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1791 ALTER TABLE ONLY channels
1792 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
1796 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1799 ALTER TABLE ONLY defense_missions
1800 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
1804 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1807 ALTER TABLE ONLY defense_requests
1808 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
1812 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1815 ALTER TABLE ONLY dumps
1816 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
1820 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1823 ALTER TABLE ONLY fleet_scans
1824 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (id);
1828 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1831 ALTER TABLE ONLY fleet_ships
1832 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
1836 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1839 ALTER TABLE ONLY fleet_ships
1840 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (id, ship);
1844 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1847 ALTER TABLE ONLY fleets
1848 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
1852 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1855 ALTER TABLE ONLY forum_access
1856 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
1860 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1863 ALTER TABLE ONLY forum_boards
1864 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
1868 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1871 ALTER TABLE ONLY forum_boards
1872 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
1876 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1879 ALTER TABLE ONLY forum_categories
1880 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
1884 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1887 ALTER TABLE ONLY forum_categories
1888 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
1892 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1895 ALTER TABLE ONLY forum_posts
1896 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
1900 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1903 ALTER TABLE ONLY forum_thread_visits
1904 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
1908 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1911 ALTER TABLE ONLY forum_threads
1912 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
1916 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1919 ALTER TABLE ONLY galaxies
1920 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
1924 -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1927 ALTER TABLE ONLY graphs
1928 ADD CONSTRAINT graphs_pkey PRIMARY KEY (type, id);
1932 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1935 ALTER TABLE ONLY groupmembers
1936 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
1940 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1943 ALTER TABLE ONLY groups
1944 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
1948 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1951 ALTER TABLE ONLY groups
1952 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
1956 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1959 ALTER TABLE ONLY incomings
1960 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
1964 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1967 ALTER TABLE ONLY incomings
1968 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
1972 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1975 ALTER TABLE ONLY misc
1976 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
1980 -- Name: planet_data_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1983 ALTER TABLE ONLY planet_data
1984 ADD CONSTRAINT planet_data_pkey PRIMARY KEY (rid, scan);
1988 -- Name: planet_data_types_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1991 ALTER TABLE ONLY planet_data_types
1992 ADD CONSTRAINT planet_data_types_category_key UNIQUE (category, name);
1996 -- Name: planet_data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1999 ALTER TABLE ONLY planet_data_types
2000 ADD CONSTRAINT planet_data_types_pkey PRIMARY KEY (id);
2004 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2007 ALTER TABLE ONLY planet_stats
2008 ADD CONSTRAINT planet_stats_id_key UNIQUE (id, tick);
2012 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2015 ALTER TABLE ONLY planet_stats
2016 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
2020 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2023 ALTER TABLE ONLY planets
2024 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
2028 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2031 ALTER TABLE ONLY planets
2032 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
2036 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2039 ALTER TABLE ONLY planets
2040 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
2044 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2047 ALTER TABLE ONLY raid_access
2048 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
2052 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2055 ALTER TABLE ONLY raid_claims
2056 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
2060 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2063 ALTER TABLE ONLY raid_targets
2064 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
2068 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2071 ALTER TABLE ONLY raid_targets
2072 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, planet);
2076 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2079 ALTER TABLE ONLY raids
2080 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
2084 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2087 ALTER TABLE ONLY scans
2088 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
2092 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2095 ALTER TABLE ONLY scans
2096 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
2100 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2103 ALTER TABLE ONLY ship_stats
2104 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
2108 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2111 ALTER TABLE ONLY smslist
2112 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
2116 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2119 ALTER TABLE ONLY users
2120 ADD CONSTRAINT users_planet_key UNIQUE (planet);
2124 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2127 ALTER TABLE ONLY users
2128 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
2132 -- Name: fleets_ingal_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2135 CREATE INDEX fleets_ingal_index ON fleets USING btree (ingal);
2139 -- Name: fleets_mission_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2142 CREATE INDEX fleets_mission_index ON fleets USING btree (mission);
2146 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2149 CREATE INDEX fleets_sender_index ON fleets USING btree (sender);
2153 -- Name: fleets_target_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2156 CREATE INDEX fleets_target_index ON fleets USING btree (target);
2160 -- Name: fleets_tick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2163 CREATE INDEX fleets_tick_index ON fleets USING btree (tick);
2167 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2170 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2174 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2177 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2181 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2184 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
2188 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2191 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2195 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2198 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2202 -- Name: planet_data_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2205 CREATE INDEX planet_data_id_index ON planet_data USING btree (id);
2209 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2212 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2216 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2219 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
2223 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2226 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2230 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2233 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
2237 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2240 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2244 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2247 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
2251 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2254 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
2258 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2261 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2265 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2268 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2272 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2275 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2279 -- Name: scans_parsed_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2282 CREATE INDEX scans_parsed_index ON scans USING btree (parsed);
2286 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2289 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
2293 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2296 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2300 -- Name: users_pnick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2303 CREATE UNIQUE INDEX users_pnick_index ON users USING btree (lower(pnick));
2307 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2310 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2314 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: -
2317 CREATE TRIGGER add_call
2318 BEFORE INSERT ON calls
2320 EXECUTE PROCEDURE add_call();
2324 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: -
2327 CREATE TRIGGER add_remove_member
2328 AFTER INSERT OR DELETE ON groupmembers
2330 EXECUTE PROCEDURE change_member();
2334 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: -
2337 CREATE TRIGGER add_user
2338 BEFORE INSERT ON users
2340 EXECUTE PROCEDURE add_user();
2344 -- Name: unclaim_target; Type: TRIGGER; Schema: public; Owner: -
2347 CREATE TRIGGER unclaim_target
2348 AFTER DELETE ON raid_claims
2350 EXECUTE PROCEDURE unclaim_target();
2354 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: -
2357 CREATE TRIGGER update_forum_post
2358 BEFORE INSERT OR UPDATE ON forum_posts
2360 EXECUTE PROCEDURE update_forum_post();
2364 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: -
2367 CREATE TRIGGER update_planet
2368 AFTER UPDATE ON users
2370 EXECUTE PROCEDURE update_user_planet();
2374 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: -
2377 CREATE TRIGGER update_target
2378 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2380 EXECUTE PROCEDURE updated_target();
2384 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2387 ALTER TABLE ONLY alliance_stats
2388 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2392 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2395 ALTER TABLE ONLY calls
2396 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2400 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2403 ALTER TABLE ONLY calls
2404 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
2408 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2411 ALTER TABLE ONLY calls
2412 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2416 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2419 ALTER TABLE ONLY channel_group_flags
2420 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2424 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2427 ALTER TABLE ONLY channel_group_flags
2428 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2432 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2435 ALTER TABLE ONLY channel_group_flags
2436 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2440 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2443 ALTER TABLE ONLY defense_missions
2444 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2448 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2451 ALTER TABLE ONLY defense_missions
2452 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2456 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2459 ALTER TABLE ONLY defense_requests
2460 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2464 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2467 ALTER TABLE ONLY fleet_scans
2468 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON DELETE CASCADE;
2472 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2475 ALTER TABLE ONLY fleet_scans
2476 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2480 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2483 ALTER TABLE ONLY fleet_ships
2484 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2488 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2491 ALTER TABLE ONLY fleet_ships
2492 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(name);
2496 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2499 ALTER TABLE ONLY fleets
2500 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2504 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2507 ALTER TABLE ONLY fleets
2508 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2512 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2515 ALTER TABLE ONLY fleets
2516 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2520 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2523 ALTER TABLE ONLY forum_access
2524 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2528 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2531 ALTER TABLE ONLY forum_access
2532 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2536 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2539 ALTER TABLE ONLY forum_boards
2540 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2544 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2547 ALTER TABLE ONLY forum_posts
2548 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2552 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2555 ALTER TABLE ONLY forum_posts
2556 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2560 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2563 ALTER TABLE ONLY forum_thread_visits
2564 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2568 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2571 ALTER TABLE ONLY forum_thread_visits
2572 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2576 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2579 ALTER TABLE ONLY forum_threads
2580 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2584 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2587 ALTER TABLE ONLY forum_threads
2588 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
2592 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2595 ALTER TABLE ONLY groupmembers
2596 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2600 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2603 ALTER TABLE ONLY groupmembers
2604 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2608 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2611 ALTER TABLE ONLY incomings
2612 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2616 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2619 ALTER TABLE ONLY incomings
2620 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2624 -- Name: planet_data_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2627 ALTER TABLE ONLY planet_data
2628 ADD CONSTRAINT planet_data_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2632 -- Name: planet_data_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2635 ALTER TABLE ONLY planet_data
2636 ADD CONSTRAINT planet_data_rid_fkey FOREIGN KEY (rid) REFERENCES planet_data_types(id);
2640 -- Name: planet_data_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2643 ALTER TABLE ONLY planet_data
2644 ADD CONSTRAINT planet_data_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2648 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2651 ALTER TABLE ONLY planet_stats
2652 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2656 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2659 ALTER TABLE ONLY planets
2660 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2664 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2667 ALTER TABLE ONLY planets
2668 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2672 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2675 ALTER TABLE ONLY raid_access
2676 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2680 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2683 ALTER TABLE ONLY raid_access
2684 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2688 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2691 ALTER TABLE ONLY raid_claims
2692 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2696 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2699 ALTER TABLE ONLY raid_claims
2700 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2704 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2707 ALTER TABLE ONLY raid_targets
2708 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2712 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2715 ALTER TABLE ONLY raid_targets
2716 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2720 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2723 ALTER TABLE ONLY scans
2724 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2728 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2731 ALTER TABLE ONLY scans
2732 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2736 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2739 ALTER TABLE ONLY users
2740 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2744 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2747 ALTER TABLE ONLY users
2748 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
2752 -- Name: public; Type: ACL; Schema: -; Owner: -
2755 REVOKE ALL ON SCHEMA public FROM PUBLIC;
2756 REVOKE ALL ON SCHEMA public FROM postgres;
2757 GRANT ALL ON SCHEMA public TO postgres;
2758 GRANT ALL ON SCHEMA public TO PUBLIC;
2762 -- PostgreSQL database dump complete