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: covop_attacks; Type: TABLE; Schema: public; Owner: -; Tablespace:
132 CREATE TABLE covop_attacks (
133 uid integer NOT NULL,
134 tick integer NOT NULL,
140 -- Name: governments; Type: TYPE; Schema: public; Owner: -
143 CREATE TYPE governments AS ENUM (
153 -- Name: race; Type: TYPE; Schema: public; Owner: -
156 CREATE TYPE race AS ENUM (
166 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
169 CREATE TABLE planet_stats (
171 tick integer NOT NULL,
175 size integer NOT NULL,
176 score integer NOT NULL,
177 value integer NOT NULL,
179 sizerank integer NOT NULL,
180 scorerank integer NOT NULL,
181 valuerank integer NOT NULL,
182 xprank integer NOT NULL,
183 size_gain integer NOT NULL,
184 score_gain integer NOT NULL,
185 value_gain integer NOT NULL,
186 xp_gain integer NOT NULL,
187 sizerank_gain integer NOT NULL,
188 scorerank_gain integer NOT NULL,
189 valuerank_gain integer NOT NULL,
190 xprank_gain integer NOT NULL,
191 size_gain_day integer NOT NULL,
192 score_gain_day integer NOT NULL,
193 value_gain_day integer NOT NULL,
194 xp_gain_day integer NOT NULL,
195 sizerank_gain_day integer NOT NULL,
196 scorerank_gain_day integer NOT NULL,
197 valuerank_gain_day integer NOT NULL,
198 xprank_gain_day integer NOT NULL
203 -- Name: planets; Type: TABLE; Schema: public; Owner: -; Tablespace:
206 CREATE TABLE planets (
208 ruler character varying NOT NULL,
209 planet character varying NOT NULL,
211 nick character varying,
212 planet_status ead_status DEFAULT ''::ead_status NOT NULL,
213 hit_us integer DEFAULT 0 NOT NULL,
216 ftid integer NOT NULL,
217 gov governments DEFAULT ''::governments NOT NULL
222 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: -
225 CREATE VIEW current_planet_stats AS
226 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, p.gov 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)));
230 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: -
233 CREATE VIEW current_planet_stats_full AS
234 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, p.gov 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)));
238 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: -; Tablespace:
241 CREATE TABLE defense_missions (
242 call integer NOT NULL,
243 fleet integer NOT NULL,
244 announced boolean DEFAULT false NOT NULL,
245 pointed boolean DEFAULT false NOT NULL
250 -- Name: defense_requests; Type: TABLE; Schema: public; Owner: -; Tablespace:
253 CREATE TABLE defense_requests (
255 uid integer NOT NULL,
256 message text NOT NULL,
257 sent boolean DEFAULT false NOT NULL
262 -- Name: dumps; Type: TABLE; Schema: public; Owner: -; Tablespace:
266 tick integer NOT NULL,
269 modified integer DEFAULT 0 NOT NULL
274 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
277 CREATE TABLE fleet_scans (
279 scan integer NOT NULL
284 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: -; Tablespace:
287 CREATE TABLE fleet_ships (
290 amount integer NOT NULL,
296 -- Name: fleets; Type: TABLE; Schema: public; Owner: -; Tablespace:
299 CREATE TABLE fleets (
300 uid integer NOT NULL,
302 mission text NOT NULL,
303 tick integer NOT NULL,
307 sender integer NOT NULL,
310 ingal boolean DEFAULT false NOT NULL
315 -- Name: forum_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
318 CREATE TABLE forum_access (
319 fbid integer NOT NULL,
320 gid integer NOT NULL,
321 post boolean DEFAULT false NOT NULL,
322 moderate boolean DEFAULT false NOT NULL
327 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: -; Tablespace:
330 CREATE TABLE forum_boards (
331 fbid integer NOT NULL,
332 fcid integer NOT NULL,
338 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: -; Tablespace:
341 CREATE TABLE forum_categories (
342 fcid integer NOT NULL,
343 category text NOT NULL
348 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: -; Tablespace:
351 CREATE TABLE forum_posts (
352 fpid integer NOT NULL,
353 ftid integer NOT NULL,
354 message text NOT NULL,
355 "time" timestamp with time zone DEFAULT now() NOT NULL,
356 uid integer NOT NULL,
362 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: -; Tablespace:
365 CREATE TABLE forum_thread_visits (
366 uid integer NOT NULL,
367 ftid integer NOT NULL,
368 "time" timestamp with time zone DEFAULT now() NOT NULL
373 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: -; Tablespace:
376 CREATE TABLE forum_threads (
377 ftid integer NOT NULL,
378 fbid integer NOT NULL,
379 subject text NOT NULL,
380 sticky boolean DEFAULT false NOT NULL,
386 -- Name: galaxies; Type: TABLE; Schema: public; Owner: -; Tablespace:
389 CREATE TABLE galaxies (
392 tick integer NOT NULL,
393 size integer NOT NULL,
394 score integer NOT NULL,
395 value integer NOT NULL,
397 planets integer NOT NULL,
398 sizerank integer NOT NULL,
399 scorerank integer NOT NULL,
400 valuerank integer NOT NULL,
401 xprank integer NOT NULL,
402 size_gain integer NOT NULL,
403 score_gain integer NOT NULL,
404 value_gain integer NOT NULL,
405 xp_gain integer NOT NULL,
406 planets_gain integer NOT NULL,
407 sizerank_gain integer NOT NULL,
408 scorerank_gain integer NOT NULL,
409 valuerank_gain integer NOT NULL,
410 xprank_gain integer NOT NULL,
411 size_gain_day integer NOT NULL,
412 score_gain_day integer NOT NULL,
413 value_gain_day integer NOT NULL,
414 xp_gain_day integer NOT NULL,
415 planets_gain_day integer NOT NULL,
416 sizerank_gain_day integer NOT NULL,
417 scorerank_gain_day integer NOT NULL,
418 valuerank_gain_day integer NOT NULL,
419 xprank_gain_day integer NOT NULL
424 -- Name: graphs; Type: TABLE; Schema: public; Owner: -; Tablespace:
427 CREATE TABLE graphs (
430 last_modified timestamp with time zone DEFAULT now() NOT NULL,
431 tick integer NOT NULL,
437 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: -; Tablespace:
440 CREATE TABLE groupmembers (
441 gid integer NOT NULL,
447 -- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
450 CREATE TABLE groups (
451 gid integer NOT NULL,
452 groupname text NOT NULL,
454 attack boolean DEFAULT false NOT NULL
459 -- Name: incomings; Type: TABLE; Schema: public; Owner: -; Tablespace:
462 CREATE TABLE incomings (
463 call integer NOT NULL,
464 sender integer NOT NULL,
465 eta integer NOT NULL,
466 amount integer NOT NULL,
468 shiptype text DEFAULT '?'::text NOT NULL,
474 -- Name: misc; Type: TABLE; Schema: public; Owner: -; Tablespace:
484 -- Name: planet_data; Type: TABLE; Schema: public; Owner: -; Tablespace:
487 CREATE TABLE planet_data (
489 scan integer NOT NULL,
490 tick integer NOT NULL,
491 rid integer NOT NULL,
492 amount bigint NOT NULL
497 -- Name: planet_data_types; Type: TABLE; Schema: public; Owner: -; Tablespace:
500 CREATE TABLE planet_data_types (
502 category text NOT NULL,
508 -- Name: scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
512 tick integer NOT NULL,
513 scan_id numeric(10,0) NOT NULL,
516 uid integer DEFAULT -1 NOT NULL,
517 groupscan boolean DEFAULT false NOT NULL,
518 parsed boolean DEFAULT false NOT NULL,
524 -- Name: planet_scans; Type: VIEW; Schema: public; Owner: -
527 CREATE VIEW planet_scans AS
528 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;
532 -- Name: raid_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
535 CREATE TABLE raid_access (
536 raid integer NOT NULL,
542 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: -; Tablespace:
545 CREATE TABLE raid_claims (
546 target integer NOT NULL,
547 uid integer NOT NULL,
548 wave integer NOT NULL,
549 joinable boolean DEFAULT false NOT NULL,
550 launched boolean DEFAULT false NOT NULL,
551 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
556 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
559 CREATE TABLE raid_targets (
561 raid integer NOT NULL,
562 planet integer NOT NULL,
564 modified timestamp with time zone DEFAULT now() NOT NULL
569 -- Name: raids; Type: TABLE; Schema: public; Owner: -; Tablespace:
574 tick integer NOT NULL,
575 open boolean DEFAULT false NOT NULL,
576 waves integer DEFAULT 3 NOT NULL,
577 message text NOT NULL,
578 removed boolean DEFAULT false NOT NULL,
579 released_coords boolean DEFAULT false NOT NULL
584 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
587 CREATE TABLE ship_stats (
592 init integer NOT NULL,
593 armor integer NOT NULL,
594 damage integer NOT NULL,
595 metal integer NOT NULL,
596 crystal integer NOT NULL,
597 eonium integer NOT NULL,
599 guns integer DEFAULT 0 NOT NULL,
600 eres integer DEFAULT 0 NOT NULL,
607 -- Name: smslist; Type: TABLE; Schema: public; Owner: -; Tablespace:
610 CREATE TABLE smslist (
618 -- Name: structure_scans; Type: VIEW; Schema: public; Owner: -
621 CREATE VIEW structure_scans AS
622 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;
626 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
630 uid integer NOT NULL,
631 username text NOT NULL,
633 password text NOT NULL,
634 attack_points integer DEFAULT 0 NOT NULL,
635 defense_points integer DEFAULT 0 NOT NULL,
636 scan_points integer DEFAULT 0 NOT NULL,
637 humor_points integer DEFAULT 0 NOT NULL,
641 laston timestamp with time zone,
644 last_forum_visit timestamp with time zone,
652 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: -
655 CREATE VIEW usersingroup AS
656 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
660 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: -
663 CREATE FUNCTION add_call() RETURNS trigger
665 if ($_TD->{event} eq 'INSERT'){
666 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
667 if ($rv->{processed} != 1){
670 $ftid = $rv->{rows}[0]->{id};
671 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES(-3,$1,$2,-3)','int4','varchar');
672 $rv = spi_exec_prepared($query,$ftid,"$_TD->{new}{member}: $_TD->{new}{landing_tick}");
673 spi_freeplan($query);
674 if (rv->{status} != SPI_OK_INSERT){
677 $_TD->{new}{ftid} = $ftid;
686 -- Name: add_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
689 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
690 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
692 $tick = -1 unless defined $tick;
693 if ($x1 == $x2 && $y1 == $y2) {
697 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
698 $tick = $rv->{rows}[0]->{tick};
700 $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;");
701 unless ($rv->{processed} >= 1){
704 $id1 = $rv->{rows}[0]->{id};
705 $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;");
706 unless ($rv->{processed} >= 1){
709 $id2 = $rv->{rows}[0]->{id};
711 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
717 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
720 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
721 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
723 if ($x1 == $x2 && $y1 == $y2) {
727 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
728 $tick = $rv->{rows}[0]->{tick};
730 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
731 unless ($rv->{processed} == 1){
734 $id1 = $rv->{rows}[0]->{id};
735 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
736 unless ($rv->{processed} == 1){
739 $id2 = $rv->{rows}[0]->{id};
740 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
746 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
749 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
750 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
751 unless ($uid = /^(-?\d+)$/){
752 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
753 $uid = $rv->{rows}[0]->{id};
756 if ($x1 == $x2 && $y1 == $y2) {
760 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
761 $tick = $rv->{rows}[0]->{tick};
763 $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;");
764 unless ($rv->{processed} >= 1){
767 $id1 = $rv->{rows}[0]->{id};
768 $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;");
769 unless ($rv->{processed} >= 1){
772 $id2 = $rv->{rows}[0]->{id};
774 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
780 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
783 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
784 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
786 if ($x1 == $x2 && $y1 == $y2) {
790 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
791 $tick = $rv->{rows}[0]->{tick};
793 $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;");
794 unless ($rv->{processed} >= 1){
797 $id1 = $rv->{rows}[0]->{id};
798 $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;");
799 unless ($rv->{processed} >= 1){
802 $id2 = $rv->{rows}[0]->{id};
804 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
810 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: -
813 CREATE FUNCTION add_user() RETURNS trigger
815 if ($_TD->{event} eq 'INSERT'){
816 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
817 if ($rv->{processed} != 1){
820 $ftid = $rv->{rows}[0]->{id};
821 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
822 $rv = spi_exec_prepared($query,-1,$ftid,"$_TD->{new}{uid}: $_TD->{new}{username}");
823 spi_freeplan($query);
824 if (rv->{status} != SPI_OK_INSERT){
827 $_TD->{new}{ftid} = $ftid;
836 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: -
839 CREATE FUNCTION calc_rank(tick integer) RETURNS void
840 AS $_$my ($tick) = @_;
841 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
843 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
844 my $status = $rv->{status};
845 my $nrows = $rv->{processed};
847 for ($row = 1; $row <= $nrows; ++$row ){
848 $id = $rv->{rows}[$row-1]->{id};
849 $ranks{$id}{'score'} = $row;
852 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
853 my $status = $rv->{status};
854 my $nrows = $rv->{processed};
856 for ($row = 1; $row <= $nrows; ++$row ){
857 $id = $rv->{rows}[$row-1]->{id};
858 $ranks{$id}{'value'} = $row;
861 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
862 my $status = $rv->{status};
863 my $nrows = $rv->{processed};
865 for ($row = 1; $row <= $nrows; ++$row ){
866 $id = $rv->{rows}[$row-1]->{id};
867 $ranks{$id}{'size'} = $row;
870 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
871 my $status = $rv->{status};
872 my $nrows = $rv->{processed};
874 for ($row = 1; $row <= $nrows; ++$row ){
875 $id = $rv->{rows}[$row-1]->{id};
876 $ranks{$id}{'xp'} = $row;
878 foreach $key (keys(%ranks)){
879 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'}.")");
886 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: -
889 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
890 AS $_$my ($tick) = @_;
891 #spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
893 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
894 my $status = $rv->{status};
895 my $nrows = $rv->{processed};
897 for ($row = 1; $row <= $nrows; ++$row ){
898 $id = $rv->{rows}[$row-1]->{id};
899 #$ranks{$id}{'score'} = $row;
902 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
903 my $status = $rv->{status};
904 my $nrows = $rv->{processed};
906 for ($row = 1; $row <= $nrows; ++$row ){
907 $id = $rv->{rows}[$row-1]->{id};
908 #$ranks{$id}{'value'} = $row;
911 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
912 my $status = $rv->{status};
913 my $nrows = $rv->{processed};
915 for ($row = 1; $row <= $nrows; ++$row ){
916 $id = $rv->{rows}[$row-1]->{id};
917 #$ranks{$id}{'size'} = $row;
920 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
921 my $status = $rv->{status};
922 my $nrows = $rv->{processed};
924 for ($row = 1; $row <= $nrows; ++$row ){
925 $id = $rv->{rows}[$row-1]->{id};
926 #$ranks{$id}{'xp'} = $row;
928 foreach $key (keys(%ranks)){
929 #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'}.")");
936 -- Name: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: -
939 CREATE FUNCTION calculate_rankings(integer) RETURNS void
940 AS $_$my ($tick) = @_;
941 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
942 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
943 my $status = $rv->{status};
944 my $nrows = $rv->{processed};
946 for ($row = 1; $row <= $nrows; ++$row ){
947 $id = $rv->{rows}[$row-1]->{id};
948 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
951 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
952 my $status = $rv->{status};
953 my $nrows = $rv->{processed};
955 for ($row = 1; $row <= $nrows; ++$row ){
956 $id = $rv->{rows}[$row-1]->{id};
957 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
960 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
961 my $status = $rv->{status};
962 my $nrows = $rv->{processed};
964 for ($row = 1; $row <= $nrows; ++$row ){
965 $id = $rv->{rows}[$row-1]->{id};
966 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
969 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
970 my $status = $rv->{status};
971 my $nrows = $rv->{processed};
973 for ($row = 1; $row <= $nrows; ++$row ){
974 $id = $rv->{rows}[$row-1]->{id};
975 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
982 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: -
985 CREATE FUNCTION change_member() RETURNS trigger
986 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
987 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
988 if ($rv->{rows}[0]->{planet}){
989 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
992 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
993 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
994 if ($rv->{rows}[0]->{planet}){
995 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
1003 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1006 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
1007 AS $_$my ($x,$y,$z) = @_;
1008 return "$x:$y:$z";$_$
1009 LANGUAGE plperl IMMUTABLE;
1013 -- Name: covop_alert(integer, integer, governments, integer); Type: FUNCTION; Schema: public; Owner: -
1016 CREATE FUNCTION covop_alert(secs integer, strucs integer, gov governments, population integer) RETURNS integer
1018 SELECT (70*(1.0+LEAST(COALESCE($1::float/$2,$4),0.30)*2 +
1020 WHEN 'Dic' THEN 0.20
1021 WHEN 'Feu' THEN -0.20
1022 WHEN 'Uni' THEN -0.10
1024 END) + $4/100.0))::integer;
1026 LANGUAGE sql IMMUTABLE;
1030 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: -
1033 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
1036 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
1037 my $rv = spi_exec_prepared($query,$name);
1038 my $status = $rv->{status};
1039 my $nrows = $rv->{processed};
1042 $id = $rv->{rows}[0]->{id};
1045 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
1046 if ($rv->{processed} != 1){
1049 $id = $rv->{rows}[0]->{id};
1050 my $query = spi_prepare('INSERT INTO alliances(id,name) VALUES($1,$2)','int4','varchar');
1051 $rv = spi_exec_prepared($query,$id,$name);
1052 spi_freeplan($query);
1053 if (rv->{status} != SPI_OK_INSERT){
1063 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
1066 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
1068 my ($ruler, $planet, $race) = @_;
1069 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
1070 my $rv = spi_exec_prepared($query,$ruler,$planet);
1071 spi_freeplan($query);
1072 my $status = $rv->{status};
1073 my $nrows = $rv->{processed};
1076 $id = $rv->{rows}[0]->{id};
1077 unless ($race eq $rv->{rows}[0]->{race}){
1078 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','race','int4');
1079 spi_exec_prepared($query,$race,$id);
1080 spi_freeplan($query);
1083 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
1084 if ($rv->{processed} != 1){
1087 $ftid = $rv->{rows}[0]->{id};
1088 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
1089 $rv = spi_exec_prepared($query,-2,$ftid,"$ruler OF $planet");
1090 spi_freeplan($query);
1091 if (rv->{status} != SPI_OK_INSERT){
1094 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
1095 if ($rv->{processed} != 1){
1098 $id = $rv->{rows}[0]->{id};
1099 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race,ftid) VALUES($1,$2,$3,$4,$5)','int4','varchar','varchar','race','int4
1101 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race,$ftid);
1102 spi_freeplan($query);
1103 if (rv->{status} != SPI_OK_INSERT){
1114 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: -
1117 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
1118 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
1119 LANGUAGE sql STABLE;
1123 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1126 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
1128 SELECT LEAST(2000.0*15*$4/$5,$1*0.10, 15*7500.0)::integer
1129 + LEAST(2000.0*15*$4/$5,$2*0.10, 15*7500.0)::integer
1130 + LEAST(2000.0*15*$4/$5,$3*0.10, 15*7500.0)::integer
1132 LANGUAGE sql IMMUTABLE;
1136 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: -
1139 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
1140 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$
1141 LANGUAGE sql IMMUTABLE;
1145 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: -
1148 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
1149 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$_$
1150 LANGUAGE sql STABLE;
1154 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1157 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
1158 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$_$
1159 LANGUAGE sql STABLE;
1163 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: -
1166 CREATE FUNCTION populate_ticks() RETURNS void
1167 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
1168 my $nrows = $rv->{processed};
1170 $tick = $rv->{rows}[0]->{tick};
1171 spi_exec_query("DELETE FROM ticks;");
1172 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);");
1173 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
1179 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: -
1182 CREATE FUNCTION tick() RETURNS integer
1183 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
1184 LANGUAGE sql STABLE;
1188 -- Name: unclaim_target(); Type: FUNCTION; Schema: public; Owner: -
1191 CREATE FUNCTION unclaim_target() RETURNS trigger
1193 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{launched} eq 't'){
1194 my $uid = $_TD->{old}{uid};
1195 my $query = spi_prepare(q{UPDATE users
1196 SET attack_points = attack_points - 1
1197 WHERE uid = $1},'int4');
1198 spi_exec_prepared($query,$uid);
1199 spi_freeplan($query);
1207 -- Name: update_forum_post(); Type: FUNCTION; Schema: public; Owner: -
1210 CREATE FUNCTION update_forum_post() RETURNS trigger
1215 SELECT setweight(to_tsvector(coalesce(ft.subject,'')), 'A')
1216 || setweight(to_tsvector(coalesce(u.username,'')), 'B') AS ts
1218 FROM forum_threads ft, users u
1219 WHERE NEW.ftid = ft.ftid AND u.uid = NEW.uid;
1220 NEW.textsearch := rec.ts
1221 || setweight(to_tsvector(coalesce(NEW.message,'')), 'D');
1229 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: -
1232 CREATE FUNCTION update_user_planet() RETURNS trigger
1233 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
1234 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
1235 if ($_TD->{old}{planet}){
1236 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
1238 if ($_TD->{new}{planet}){
1239 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
1242 if ($_TD->{old}{planet}){
1243 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
1245 if ($_TD->{new}{planet}){
1246 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
1253 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: -
1256 CREATE FUNCTION updated_target() RETURNS trigger
1257 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
1258 my $target = $_TD->{new}{target};
1259 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
1260 spi_exec_prepared($query,$target);
1261 spi_freeplan($query);$_X$
1266 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
1269 CREATE AGGREGATE concat(text) (
1277 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1280 CREATE SEQUENCE alliances_id_seq
1288 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1291 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
1295 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1298 CREATE SEQUENCE calls_id_seq
1306 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1309 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
1313 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1316 CREATE SEQUENCE channel_flags_id_seq
1324 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1327 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
1331 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1334 CREATE SEQUENCE channels_id_seq
1342 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1345 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
1349 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1352 CREATE SEQUENCE defense_requests_id_seq
1360 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1363 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
1367 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: -
1370 CREATE SEQUENCE fleet_ships_num_seq
1378 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1381 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1385 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1388 CREATE SEQUENCE fleets_id_seq
1396 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1399 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
1403 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: -
1406 CREATE SEQUENCE forum_boards_fbid_seq
1414 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1417 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1421 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: -
1424 CREATE SEQUENCE forum_categories_fcid_seq
1432 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1435 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1439 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: -
1442 CREATE SEQUENCE forum_posts_fpid_seq
1450 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1453 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1457 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: -
1460 CREATE SEQUENCE forum_threads_ftid_seq
1468 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1471 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1475 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
1478 CREATE SEQUENCE groups_gid_seq
1486 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1489 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1493 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1496 CREATE SEQUENCE incomings_id_seq
1504 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1507 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1511 -- Name: planet_data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1514 CREATE SEQUENCE planet_data_types_id_seq
1522 -- Name: planet_data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1525 ALTER SEQUENCE planet_data_types_id_seq OWNED BY planet_data_types.id;
1529 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1532 CREATE SEQUENCE planets_id_seq
1540 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1543 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1547 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1550 CREATE SEQUENCE raid_targets_id_seq
1558 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1561 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1565 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1568 CREATE SEQUENCE raids_id_seq
1576 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1579 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1583 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1586 CREATE SEQUENCE scans_id_seq
1594 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1597 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
1601 -- Name: test; Type: SEQUENCE; Schema: public; Owner: -
1604 CREATE SEQUENCE test
1612 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
1615 CREATE SEQUENCE users_uid_seq
1623 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1626 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1630 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1633 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1637 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1640 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1644 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1647 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1651 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1654 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1658 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1661 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1665 -- Name: num; Type: DEFAULT; Schema: public; Owner: -
1668 ALTER TABLE fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
1672 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1675 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1679 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: -
1682 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1686 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: -
1689 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1693 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: -
1696 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1700 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: -
1703 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1707 -- Name: gid; Type: DEFAULT; Schema: public; Owner: -
1710 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1714 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1717 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1721 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1724 ALTER TABLE planet_data_types ALTER COLUMN id SET DEFAULT nextval('planet_data_types_id_seq'::regclass);
1728 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1731 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1735 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1738 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1742 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1745 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1749 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1752 ALTER TABLE scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
1756 -- Name: uid; Type: DEFAULT; Schema: public; Owner: -
1759 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1763 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1766 ALTER TABLE ONLY users
1767 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1771 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1774 ALTER TABLE ONLY alliance_stats
1775 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1779 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1782 ALTER TABLE ONLY alliances
1783 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1787 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1790 ALTER TABLE ONLY alliances
1791 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1795 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1798 ALTER TABLE ONLY calls
1799 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1803 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1806 ALTER TABLE ONLY calls
1807 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1811 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1814 ALTER TABLE ONLY channel_flags
1815 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1819 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1822 ALTER TABLE ONLY channel_flags
1823 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1827 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1830 ALTER TABLE ONLY channel_group_flags
1831 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
1835 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1838 ALTER TABLE ONLY channels
1839 ADD CONSTRAINT channels_name_key UNIQUE (name);
1843 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1846 ALTER TABLE ONLY channels
1847 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
1851 -- Name: covop_attacks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1854 ALTER TABLE ONLY covop_attacks
1855 ADD CONSTRAINT covop_attacks_pkey PRIMARY KEY (id, tick, uid);
1859 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1862 ALTER TABLE ONLY defense_missions
1863 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
1867 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1870 ALTER TABLE ONLY defense_requests
1871 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
1875 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1878 ALTER TABLE ONLY dumps
1879 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
1883 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1886 ALTER TABLE ONLY fleet_scans
1887 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (id);
1891 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1894 ALTER TABLE ONLY fleet_ships
1895 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
1899 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1902 ALTER TABLE ONLY fleet_ships
1903 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (id, ship);
1907 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1910 ALTER TABLE ONLY fleets
1911 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
1915 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1918 ALTER TABLE ONLY forum_access
1919 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
1923 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1926 ALTER TABLE ONLY forum_boards
1927 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
1931 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1934 ALTER TABLE ONLY forum_boards
1935 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
1939 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1942 ALTER TABLE ONLY forum_categories
1943 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
1947 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1950 ALTER TABLE ONLY forum_categories
1951 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
1955 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1958 ALTER TABLE ONLY forum_posts
1959 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
1963 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1966 ALTER TABLE ONLY forum_thread_visits
1967 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
1971 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1974 ALTER TABLE ONLY forum_threads
1975 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
1979 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1982 ALTER TABLE ONLY galaxies
1983 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
1987 -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1990 ALTER TABLE ONLY graphs
1991 ADD CONSTRAINT graphs_pkey PRIMARY KEY (type, id);
1995 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1998 ALTER TABLE ONLY groupmembers
1999 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2003 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2006 ALTER TABLE ONLY groups
2007 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2011 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2014 ALTER TABLE ONLY groups
2015 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2019 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2022 ALTER TABLE ONLY incomings
2023 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
2027 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2030 ALTER TABLE ONLY incomings
2031 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
2035 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2038 ALTER TABLE ONLY misc
2039 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
2043 -- Name: planet_data_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2046 ALTER TABLE ONLY planet_data
2047 ADD CONSTRAINT planet_data_pkey PRIMARY KEY (rid, scan);
2051 -- Name: planet_data_types_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2054 ALTER TABLE ONLY planet_data_types
2055 ADD CONSTRAINT planet_data_types_category_key UNIQUE (category, name);
2059 -- Name: planet_data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2062 ALTER TABLE ONLY planet_data_types
2063 ADD CONSTRAINT planet_data_types_pkey PRIMARY KEY (id);
2067 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2070 ALTER TABLE ONLY planet_stats
2071 ADD CONSTRAINT planet_stats_id_key UNIQUE (id, tick);
2075 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2078 ALTER TABLE ONLY planet_stats
2079 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
2083 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2086 ALTER TABLE ONLY planets
2087 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
2091 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2094 ALTER TABLE ONLY planets
2095 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
2099 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2102 ALTER TABLE ONLY planets
2103 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
2107 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2110 ALTER TABLE ONLY raid_access
2111 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
2115 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2118 ALTER TABLE ONLY raid_claims
2119 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
2123 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2126 ALTER TABLE ONLY raid_targets
2127 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
2131 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2134 ALTER TABLE ONLY raid_targets
2135 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, planet);
2139 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2142 ALTER TABLE ONLY raids
2143 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
2147 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2150 ALTER TABLE ONLY scans
2151 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
2155 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2158 ALTER TABLE ONLY scans
2159 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
2163 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2166 ALTER TABLE ONLY ship_stats
2167 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
2171 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2174 ALTER TABLE ONLY smslist
2175 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
2179 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2182 ALTER TABLE ONLY users
2183 ADD CONSTRAINT users_planet_key UNIQUE (planet);
2187 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2190 ALTER TABLE ONLY users
2191 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
2195 -- Name: fleets_ingal_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2198 CREATE INDEX fleets_ingal_index ON fleets USING btree (ingal);
2202 -- Name: fleets_mission_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2205 CREATE INDEX fleets_mission_index ON fleets USING btree (mission);
2209 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2212 CREATE INDEX fleets_sender_index ON fleets USING btree (sender);
2216 -- Name: fleets_target_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2219 CREATE INDEX fleets_target_index ON fleets USING btree (target);
2223 -- Name: fleets_tick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2226 CREATE INDEX fleets_tick_index ON fleets USING btree (tick);
2230 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2233 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2237 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2240 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2244 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2247 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
2251 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2254 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2258 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2261 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2265 -- Name: planet_data_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2268 CREATE INDEX planet_data_id_index ON planet_data USING btree (id);
2272 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2275 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2279 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2282 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
2286 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2289 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2293 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2296 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
2300 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2303 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2307 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2310 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
2314 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2317 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
2321 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2324 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2328 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2331 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2335 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2338 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2342 -- Name: scans_parsed_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2345 CREATE INDEX scans_parsed_index ON scans USING btree (parsed);
2349 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2352 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
2356 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2359 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2363 -- Name: users_pnick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2366 CREATE UNIQUE INDEX users_pnick_index ON users USING btree (lower(pnick));
2370 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2373 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2377 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: -
2380 CREATE TRIGGER add_call
2381 BEFORE INSERT ON calls
2383 EXECUTE PROCEDURE add_call();
2387 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: -
2390 CREATE TRIGGER add_remove_member
2391 AFTER INSERT OR DELETE ON groupmembers
2393 EXECUTE PROCEDURE change_member();
2397 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: -
2400 CREATE TRIGGER add_user
2401 BEFORE INSERT ON users
2403 EXECUTE PROCEDURE add_user();
2407 -- Name: unclaim_target; Type: TRIGGER; Schema: public; Owner: -
2410 CREATE TRIGGER unclaim_target
2411 AFTER DELETE ON raid_claims
2413 EXECUTE PROCEDURE unclaim_target();
2417 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: -
2420 CREATE TRIGGER update_forum_post
2421 BEFORE INSERT OR UPDATE ON forum_posts
2423 EXECUTE PROCEDURE update_forum_post();
2427 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: -
2430 CREATE TRIGGER update_planet
2431 AFTER UPDATE ON users
2433 EXECUTE PROCEDURE update_user_planet();
2437 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: -
2440 CREATE TRIGGER update_target
2441 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2443 EXECUTE PROCEDURE updated_target();
2447 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2450 ALTER TABLE ONLY alliance_stats
2451 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2455 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2458 ALTER TABLE ONLY calls
2459 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2463 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2466 ALTER TABLE ONLY calls
2467 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
2471 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2474 ALTER TABLE ONLY calls
2475 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2479 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2482 ALTER TABLE ONLY channel_group_flags
2483 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2487 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2490 ALTER TABLE ONLY channel_group_flags
2491 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2495 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2498 ALTER TABLE ONLY channel_group_flags
2499 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2503 -- Name: covop_attacks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2506 ALTER TABLE ONLY covop_attacks
2507 ADD CONSTRAINT covop_attacks_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2511 -- Name: covop_attacks_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2514 ALTER TABLE ONLY covop_attacks
2515 ADD CONSTRAINT covop_attacks_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
2519 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2522 ALTER TABLE ONLY defense_missions
2523 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2527 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2530 ALTER TABLE ONLY defense_missions
2531 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2535 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2538 ALTER TABLE ONLY defense_requests
2539 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2543 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2546 ALTER TABLE ONLY fleet_scans
2547 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON DELETE CASCADE;
2551 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2554 ALTER TABLE ONLY fleet_scans
2555 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2559 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2562 ALTER TABLE ONLY fleet_ships
2563 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2567 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2570 ALTER TABLE ONLY fleet_ships
2571 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(name);
2575 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2578 ALTER TABLE ONLY fleets
2579 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2583 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2586 ALTER TABLE ONLY fleets
2587 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2591 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2594 ALTER TABLE ONLY fleets
2595 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2599 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2602 ALTER TABLE ONLY forum_access
2603 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2607 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2610 ALTER TABLE ONLY forum_access
2611 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2615 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2618 ALTER TABLE ONLY forum_boards
2619 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2623 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2626 ALTER TABLE ONLY forum_posts
2627 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2631 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2634 ALTER TABLE ONLY forum_posts
2635 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2639 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2642 ALTER TABLE ONLY forum_thread_visits
2643 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2647 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2650 ALTER TABLE ONLY forum_thread_visits
2651 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2655 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2658 ALTER TABLE ONLY forum_threads
2659 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2663 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2666 ALTER TABLE ONLY forum_threads
2667 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
2671 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2674 ALTER TABLE ONLY groupmembers
2675 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2679 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2682 ALTER TABLE ONLY groupmembers
2683 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2687 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2690 ALTER TABLE ONLY incomings
2691 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2695 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2698 ALTER TABLE ONLY incomings
2699 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2703 -- Name: planet_data_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2706 ALTER TABLE ONLY planet_data
2707 ADD CONSTRAINT planet_data_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2711 -- Name: planet_data_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2714 ALTER TABLE ONLY planet_data
2715 ADD CONSTRAINT planet_data_rid_fkey FOREIGN KEY (rid) REFERENCES planet_data_types(id);
2719 -- Name: planet_data_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2722 ALTER TABLE ONLY planet_data
2723 ADD CONSTRAINT planet_data_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2727 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2730 ALTER TABLE ONLY planet_stats
2731 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2735 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2738 ALTER TABLE ONLY planets
2739 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2743 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2746 ALTER TABLE ONLY planets
2747 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2751 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2754 ALTER TABLE ONLY raid_access
2755 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2759 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2762 ALTER TABLE ONLY raid_access
2763 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2767 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2770 ALTER TABLE ONLY raid_claims
2771 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2775 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2778 ALTER TABLE ONLY raid_claims
2779 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2783 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2786 ALTER TABLE ONLY raid_targets
2787 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2791 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2794 ALTER TABLE ONLY raid_targets
2795 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2799 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2802 ALTER TABLE ONLY scans
2803 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2807 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2810 ALTER TABLE ONLY scans
2811 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2815 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2818 ALTER TABLE ONLY users
2819 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2823 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2826 ALTER TABLE ONLY users
2827 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
2831 -- Name: public; Type: ACL; Schema: -; Owner: -
2834 REVOKE ALL ON SCHEMA public FROM PUBLIC;
2835 REVOKE ALL ON SCHEMA public FROM postgres;
2836 GRANT ALL ON SCHEMA public TO postgres;
2837 GRANT ALL ON SCHEMA public TO PUBLIC;
2841 -- PostgreSQL database dump complete