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: alliances; Type: TABLE; Schema: public; Owner: -; Tablespace:
60 CREATE TABLE alliances (
62 name character varying NOT NULL,
68 -- Name: calls; Type: TABLE; Schema: public; Owner: -; Tablespace:
73 member integer NOT NULL,
75 landing_tick integer NOT NULL,
77 covered boolean DEFAULT false NOT NULL,
79 open boolean DEFAULT true NOT NULL,
85 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: -; Tablespace:
88 CREATE TABLE channel_flags (
95 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: -; Tablespace:
98 CREATE TABLE channel_group_flags (
99 channel integer NOT NULL,
100 "group" integer NOT NULL,
101 flag integer NOT NULL
106 -- Name: channels; Type: TABLE; Schema: public; Owner: -; Tablespace:
109 CREATE TABLE channels (
112 description text NOT NULL
117 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
120 CREATE TABLE planet_stats (
122 tick integer NOT NULL,
126 size integer NOT NULL,
127 score integer NOT NULL,
128 value integer NOT NULL,
130 sizerank integer NOT NULL,
131 scorerank integer NOT NULL,
132 valuerank integer NOT NULL,
133 xprank integer NOT NULL,
134 size_gain integer NOT NULL,
135 score_gain integer NOT NULL,
136 value_gain integer NOT NULL,
137 xp_gain integer NOT NULL,
138 sizerank_gain integer NOT NULL,
139 scorerank_gain integer NOT NULL,
140 valuerank_gain integer NOT NULL,
141 xprank_gain integer NOT NULL,
142 size_gain_day integer NOT NULL,
143 score_gain_day integer NOT NULL,
144 value_gain_day integer NOT NULL,
145 xp_gain_day integer NOT NULL,
146 sizerank_gain_day integer NOT NULL,
147 scorerank_gain_day integer NOT NULL,
148 valuerank_gain_day integer NOT NULL,
149 xprank_gain_day integer NOT NULL
154 -- Name: planets; Type: TABLE; Schema: public; Owner: -; Tablespace:
157 CREATE TABLE planets (
159 ruler character varying NOT NULL,
160 planet character varying NOT NULL,
161 race character varying,
162 nick character varying,
164 hit_us integer DEFAULT 0 NOT NULL,
172 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: -
175 CREATE VIEW current_planet_stats AS
176 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)));
180 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: -
183 CREATE VIEW current_planet_stats_full AS
184 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)));
188 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: -; Tablespace:
191 CREATE TABLE defense_missions (
192 call integer NOT NULL,
193 fleet integer NOT NULL,
194 announced boolean DEFAULT false NOT NULL,
195 pointed boolean DEFAULT false NOT NULL
200 -- Name: defense_requests; Type: TABLE; Schema: public; Owner: -; Tablespace:
203 CREATE TABLE defense_requests (
205 uid integer NOT NULL,
206 message text NOT NULL,
207 sent boolean DEFAULT false NOT NULL
212 -- Name: dumps; Type: TABLE; Schema: public; Owner: -; Tablespace:
216 tick integer NOT NULL,
219 modified integer DEFAULT 0 NOT NULL
224 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
227 CREATE TABLE fleet_scans (
229 scan integer NOT NULL
234 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: -; Tablespace:
237 CREATE TABLE fleet_ships (
240 amount integer NOT NULL,
246 -- Name: fleets; Type: TABLE; Schema: public; Owner: -; Tablespace:
249 CREATE TABLE fleets (
250 uid integer NOT NULL,
252 mission text NOT NULL,
253 tick integer NOT NULL,
257 sender integer NOT NULL,
260 ingal boolean DEFAULT false NOT NULL
265 -- Name: forum_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
268 CREATE TABLE forum_access (
269 fbid integer NOT NULL,
270 gid integer NOT NULL,
271 post boolean DEFAULT false NOT NULL,
272 moderate boolean DEFAULT false NOT NULL
277 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: -; Tablespace:
280 CREATE TABLE forum_boards (
281 fbid integer NOT NULL,
282 fcid integer NOT NULL,
288 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: -; Tablespace:
291 CREATE TABLE forum_categories (
292 fcid integer NOT NULL,
293 category text NOT NULL
298 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: -; Tablespace:
301 CREATE TABLE forum_posts (
302 fpid integer NOT NULL,
303 ftid integer NOT NULL,
304 message text NOT NULL,
305 "time" timestamp with time zone DEFAULT now() NOT NULL,
306 uid integer NOT NULL,
312 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: -; Tablespace:
315 CREATE TABLE forum_thread_visits (
316 uid integer NOT NULL,
317 ftid integer NOT NULL,
318 "time" timestamp with time zone DEFAULT now() NOT NULL
323 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: -; Tablespace:
326 CREATE TABLE forum_threads (
327 ftid integer NOT NULL,
328 fbid integer NOT NULL,
329 subject text NOT NULL,
330 sticky boolean DEFAULT false NOT NULL,
336 -- Name: galaxies; Type: TABLE; Schema: public; Owner: -; Tablespace:
339 CREATE TABLE galaxies (
342 tick integer NOT NULL,
343 size integer NOT NULL,
344 score integer NOT NULL,
345 value integer NOT NULL,
347 planets integer NOT NULL,
348 sizerank integer NOT NULL,
349 scorerank integer NOT NULL,
350 valuerank integer NOT NULL,
351 xprank integer NOT NULL,
352 size_gain integer NOT NULL,
353 score_gain integer NOT NULL,
354 value_gain integer NOT NULL,
355 xp_gain integer NOT NULL,
356 planets_gain integer NOT NULL,
357 sizerank_gain integer NOT NULL,
358 scorerank_gain integer NOT NULL,
359 valuerank_gain integer NOT NULL,
360 xprank_gain integer NOT NULL,
361 size_gain_day integer NOT NULL,
362 score_gain_day integer NOT NULL,
363 value_gain_day integer NOT NULL,
364 xp_gain_day integer NOT NULL,
365 planets_gain_day integer NOT NULL,
366 sizerank_gain_day integer NOT NULL,
367 scorerank_gain_day integer NOT NULL,
368 valuerank_gain_day integer NOT NULL,
369 xprank_gain_day integer NOT NULL
374 -- Name: graphs; Type: TABLE; Schema: public; Owner: -; Tablespace:
377 CREATE TABLE graphs (
380 last_modified timestamp with time zone DEFAULT now() NOT NULL,
381 tick integer NOT NULL,
387 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: -; Tablespace:
390 CREATE TABLE groupmembers (
391 gid integer NOT NULL,
397 -- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
400 CREATE TABLE groups (
401 gid integer NOT NULL,
402 groupname text NOT NULL,
404 attack boolean DEFAULT false NOT NULL
409 -- Name: incomings; Type: TABLE; Schema: public; Owner: -; Tablespace:
412 CREATE TABLE incomings (
413 call integer NOT NULL,
414 sender integer NOT NULL,
415 eta integer NOT NULL,
416 amount integer NOT NULL,
418 shiptype text DEFAULT '?'::text NOT NULL,
424 -- Name: misc; Type: TABLE; Schema: public; Owner: -; Tablespace:
434 -- Name: planet_data; Type: TABLE; Schema: public; Owner: -; Tablespace:
437 CREATE TABLE planet_data (
439 scan integer NOT NULL,
440 tick integer NOT NULL,
441 rid integer NOT NULL,
442 amount integer NOT NULL
447 -- Name: planet_data_types; Type: TABLE; Schema: public; Owner: -; Tablespace:
450 CREATE TABLE planet_data_types (
452 category text NOT NULL,
458 -- Name: scans; Type: TABLE; Schema: public; Owner: -; Tablespace:
462 tick integer NOT NULL,
463 scan_id numeric(10,0) NOT NULL,
466 uid integer DEFAULT -1 NOT NULL,
467 groupscan boolean DEFAULT false NOT NULL,
468 parsed boolean DEFAULT false NOT NULL,
474 -- Name: planet_scans; Type: VIEW; Schema: public; Owner: -
477 CREATE VIEW planet_scans AS
478 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;
482 -- Name: raid_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
485 CREATE TABLE raid_access (
486 raid integer NOT NULL,
492 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: -; Tablespace:
495 CREATE TABLE raid_claims (
496 target integer NOT NULL,
497 uid integer NOT NULL,
498 wave integer NOT NULL,
499 joinable boolean DEFAULT false NOT NULL,
500 launched boolean DEFAULT false NOT NULL,
501 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
506 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
509 CREATE TABLE raid_targets (
511 raid integer NOT NULL,
512 planet integer NOT NULL,
514 modified timestamp with time zone DEFAULT now() NOT NULL
519 -- Name: raids; Type: TABLE; Schema: public; Owner: -; Tablespace:
524 tick integer NOT NULL,
525 open boolean DEFAULT false NOT NULL,
526 waves integer DEFAULT 3 NOT NULL,
527 message text NOT NULL,
528 removed boolean DEFAULT false NOT NULL,
529 released_coords boolean DEFAULT false NOT NULL
534 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
537 CREATE TABLE ship_stats (
542 init integer NOT NULL,
543 armor integer NOT NULL,
544 damage integer NOT NULL,
545 metal integer NOT NULL,
546 crystal integer NOT NULL,
547 eonium integer NOT NULL,
549 guns integer DEFAULT 0 NOT NULL,
550 eres integer DEFAULT 0 NOT NULL,
557 -- Name: smslist; Type: TABLE; Schema: public; Owner: -; Tablespace:
560 CREATE TABLE smslist (
568 -- Name: structure_scans; Type: VIEW; Schema: public; Owner: -
571 CREATE VIEW structure_scans AS
572 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;
576 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
580 uid integer NOT NULL,
581 username text NOT NULL,
583 password text NOT NULL,
584 attack_points integer DEFAULT 0 NOT NULL,
585 defense_points integer DEFAULT 0 NOT NULL,
586 scan_points integer DEFAULT 0 NOT NULL,
587 humor_points integer DEFAULT 0 NOT NULL,
591 laston timestamp with time zone,
594 last_forum_visit timestamp with time zone,
602 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: -
605 CREATE VIEW usersingroup AS
606 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
610 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: -
613 CREATE FUNCTION add_call() RETURNS trigger
615 if ($_TD->{event} eq 'INSERT'){
616 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
617 if ($rv->{processed} != 1){
620 $ftid = $rv->{rows}[0]->{id};
621 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES(-3,$1,$2,-3)','int4','varchar');
622 $rv = spi_exec_prepared($query,$ftid,"$_TD->{new}{member}: $_TD->{new}{landing_tick}");
623 spi_freeplan($query);
624 if (rv->{status} != SPI_OK_INSERT){
627 $_TD->{new}{ftid} = $ftid;
636 -- Name: add_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
639 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
640 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
642 $tick = -1 unless defined $tick;
643 if ($x1 == $x2 && $y1 == $y2) {
647 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
648 $tick = $rv->{rows}[0]->{tick};
650 $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;");
651 unless ($rv->{processed} >= 1){
654 $id1 = $rv->{rows}[0]->{id};
655 $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;");
656 unless ($rv->{processed} >= 1){
659 $id2 = $rv->{rows}[0]->{id};
661 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
667 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
670 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
671 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
673 if ($x1 == $x2 && $y1 == $y2) {
677 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
678 $tick = $rv->{rows}[0]->{tick};
680 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
681 unless ($rv->{processed} == 1){
684 $id1 = $rv->{rows}[0]->{id};
685 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
686 unless ($rv->{processed} == 1){
689 $id2 = $rv->{rows}[0]->{id};
690 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
696 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
699 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
700 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
701 unless ($uid = /^(-?\d+)$/){
702 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
703 $uid = $rv->{rows}[0]->{id};
706 if ($x1 == $x2 && $y1 == $y2) {
710 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
711 $tick = $rv->{rows}[0]->{tick};
713 $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;");
714 unless ($rv->{processed} >= 1){
717 $id1 = $rv->{rows}[0]->{id};
718 $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;");
719 unless ($rv->{processed} >= 1){
722 $id2 = $rv->{rows}[0]->{id};
724 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
730 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
733 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
734 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
736 if ($x1 == $x2 && $y1 == $y2) {
740 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
741 $tick = $rv->{rows}[0]->{tick};
743 $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;");
744 unless ($rv->{processed} >= 1){
747 $id1 = $rv->{rows}[0]->{id};
748 $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;");
749 unless ($rv->{processed} >= 1){
752 $id2 = $rv->{rows}[0]->{id};
754 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
760 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: -
763 CREATE FUNCTION add_user() RETURNS trigger
765 if ($_TD->{event} eq 'INSERT'){
766 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
767 if ($rv->{processed} != 1){
770 $ftid = $rv->{rows}[0]->{id};
771 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
772 $rv = spi_exec_prepared($query,-1,$ftid,"$_TD->{new}{uid}: $_TD->{new}{username}");
773 spi_freeplan($query);
774 if (rv->{status} != SPI_OK_INSERT){
777 $_TD->{new}{ftid} = $ftid;
786 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: -
789 CREATE FUNCTION calc_rank(tick integer) RETURNS void
790 AS $_$my ($tick) = @_;
791 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
793 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
794 my $status = $rv->{status};
795 my $nrows = $rv->{processed};
797 for ($row = 1; $row <= $nrows; ++$row ){
798 $id = $rv->{rows}[$row-1]->{id};
799 $ranks{$id}{'score'} = $row;
802 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
803 my $status = $rv->{status};
804 my $nrows = $rv->{processed};
806 for ($row = 1; $row <= $nrows; ++$row ){
807 $id = $rv->{rows}[$row-1]->{id};
808 $ranks{$id}{'value'} = $row;
811 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
812 my $status = $rv->{status};
813 my $nrows = $rv->{processed};
815 for ($row = 1; $row <= $nrows; ++$row ){
816 $id = $rv->{rows}[$row-1]->{id};
817 $ranks{$id}{'size'} = $row;
820 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
821 my $status = $rv->{status};
822 my $nrows = $rv->{processed};
824 for ($row = 1; $row <= $nrows; ++$row ){
825 $id = $rv->{rows}[$row-1]->{id};
826 $ranks{$id}{'xp'} = $row;
828 foreach $key (keys(%ranks)){
829 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'}.")");
836 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: -
839 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
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: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: -
889 CREATE FUNCTION calculate_rankings(integer) RETURNS void
890 AS $_$my ($tick) = @_;
891 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
892 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
893 my $status = $rv->{status};
894 my $nrows = $rv->{processed};
896 for ($row = 1; $row <= $nrows; ++$row ){
897 $id = $rv->{rows}[$row-1]->{id};
898 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
901 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
902 my $status = $rv->{status};
903 my $nrows = $rv->{processed};
905 for ($row = 1; $row <= $nrows; ++$row ){
906 $id = $rv->{rows}[$row-1]->{id};
907 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
910 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
911 my $status = $rv->{status};
912 my $nrows = $rv->{processed};
914 for ($row = 1; $row <= $nrows; ++$row ){
915 $id = $rv->{rows}[$row-1]->{id};
916 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
919 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
920 my $status = $rv->{status};
921 my $nrows = $rv->{processed};
923 for ($row = 1; $row <= $nrows; ++$row ){
924 $id = $rv->{rows}[$row-1]->{id};
925 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
932 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: -
935 CREATE FUNCTION change_member() RETURNS trigger
936 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
937 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
938 if ($rv->{rows}[0]->{planet}){
939 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
942 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
943 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
944 if ($rv->{rows}[0]->{planet}){
945 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
953 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
956 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
957 AS $_$my ($x,$y,$z) = @_;
958 return "$x:$y:$z";$_$
959 LANGUAGE plperl IMMUTABLE;
963 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: -
966 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
967 AS $_$my ($name) = @_;
969 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
970 my $rv = spi_exec_prepared($query,$name);
971 my $status = $rv->{status};
972 my $nrows = $rv->{processed};
975 $id = $rv->{rows}[0]->{id};
978 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
979 if ($rv->{processed} != 1){
982 $id = $rv->{rows}[0]->{id};
983 my $query = spi_prepare('INSERT INTO alliances(id,name,relationship) VALUES($1,$2,NULL)','int4','varchar');
984 $rv = spi_exec_prepared($query,$id,$name);
985 spi_freeplan($query);
986 if (rv->{status} != SPI_OK_INSERT){
995 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
998 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
999 AS $_$my ($ruler, $planet, $race) = @_;
1000 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
1001 my $rv = spi_exec_prepared($query,$ruler,$planet);
1002 spi_freeplan($query);
1003 my $status = $rv->{status};
1004 my $nrows = $rv->{processed};
1007 $id = $rv->{rows}[0]->{id};
1008 unless ($race eq $rv->{rows}[0]->{race}){
1009 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','varchar','int4');
1010 spi_exec_prepared($query,$race,$id);
1011 spi_freeplan($query);
1014 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
1015 if ($rv->{processed} != 1){
1018 $ftid = $rv->{rows}[0]->{id};
1019 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
1020 $rv = spi_exec_prepared($query,-2,$ftid,"$ruler OF $planet");
1021 spi_freeplan($query);
1022 if (rv->{status} != SPI_OK_INSERT){
1025 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
1026 if ($rv->{processed} != 1){
1029 $id = $rv->{rows}[0]->{id};
1030 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race,ftid) VALUES($1,$2,$3,$4,$5)','int4','varchar','varchar','varchar','int4
1032 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race,$ftid);
1033 spi_freeplan($query);
1034 if (rv->{status} != SPI_OK_INSERT){
1044 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: -
1047 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
1048 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
1049 LANGUAGE sql STABLE;
1053 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1056 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
1057 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$_$
1058 LANGUAGE sql IMMUTABLE;
1062 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: -
1065 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
1066 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$
1067 LANGUAGE sql IMMUTABLE;
1071 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: -
1074 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
1075 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$_$
1076 LANGUAGE sql STABLE;
1080 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1083 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
1084 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$_$
1085 LANGUAGE sql STABLE;
1089 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: -
1092 CREATE FUNCTION populate_ticks() RETURNS void
1093 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
1094 my $nrows = $rv->{processed};
1096 $tick = $rv->{rows}[0]->{tick};
1097 spi_exec_query("DELETE FROM ticks;");
1098 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);");
1099 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
1105 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: -
1108 CREATE FUNCTION tick() RETURNS integer
1109 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
1110 LANGUAGE sql STABLE;
1114 -- Name: unclaim_target(); Type: FUNCTION; Schema: public; Owner: -
1117 CREATE FUNCTION unclaim_target() RETURNS trigger
1119 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{launched} eq 't'){
1120 my $uid = $_TD->{old}{uid};
1121 my $query = spi_prepare(q{UPDATE users
1122 SET attack_points = attack_points - 1
1123 WHERE uid = $1},'int4');
1124 spi_exec_prepared($query,$uid);
1125 spi_freeplan($query);
1133 -- Name: update_forum_post(); Type: FUNCTION; Schema: public; Owner: -
1136 CREATE FUNCTION update_forum_post() RETURNS trigger
1141 SELECT setweight(to_tsvector(coalesce(ft.subject,'')), 'A')
1142 || setweight(to_tsvector(coalesce(u.username,'')), 'B') AS ts
1144 FROM forum_threads ft, users u
1145 WHERE NEW.ftid = ft.ftid AND u.uid = NEW.uid;
1146 NEW.textsearch := rec.ts
1147 || setweight(to_tsvector(coalesce(NEW.message,'')), 'D');
1155 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: -
1158 CREATE FUNCTION update_user_planet() RETURNS trigger
1159 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
1160 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
1161 if ($_TD->{old}{planet}){
1162 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
1164 if ($_TD->{new}{planet}){
1165 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
1168 if ($_TD->{old}{planet}){
1169 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
1171 if ($_TD->{new}{planet}){
1172 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
1179 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: -
1182 CREATE FUNCTION updated_target() RETURNS trigger
1183 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
1184 my $target = $_TD->{new}{target};
1185 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
1186 spi_exec_prepared($query,$target);
1187 spi_freeplan($query);$_X$
1192 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
1195 CREATE AGGREGATE concat(text) (
1203 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1206 CREATE SEQUENCE alliances_id_seq
1214 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1217 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
1221 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1224 CREATE SEQUENCE calls_id_seq
1232 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1235 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
1239 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1242 CREATE SEQUENCE channel_flags_id_seq
1250 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1253 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
1257 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1260 CREATE SEQUENCE channels_id_seq
1268 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1271 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
1275 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1278 CREATE SEQUENCE defense_requests_id_seq
1286 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1289 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
1293 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: -
1296 CREATE SEQUENCE fleet_ships_num_seq
1304 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1307 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1311 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1314 CREATE SEQUENCE fleets_id_seq
1322 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1325 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
1329 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: -
1332 CREATE SEQUENCE forum_boards_fbid_seq
1340 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1343 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1347 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: -
1350 CREATE SEQUENCE forum_categories_fcid_seq
1358 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1361 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1365 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: -
1368 CREATE SEQUENCE forum_posts_fpid_seq
1376 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1379 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1383 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: -
1386 CREATE SEQUENCE forum_threads_ftid_seq
1394 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1397 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1401 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
1404 CREATE SEQUENCE groups_gid_seq
1412 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1415 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1419 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1422 CREATE SEQUENCE incomings_id_seq
1430 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1433 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1437 -- Name: planet_data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1440 CREATE SEQUENCE planet_data_types_id_seq
1448 -- Name: planet_data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1451 ALTER SEQUENCE planet_data_types_id_seq OWNED BY planet_data_types.id;
1455 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1458 CREATE SEQUENCE planets_id_seq
1466 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1469 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1473 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1476 CREATE SEQUENCE raid_targets_id_seq
1484 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1487 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1491 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1494 CREATE SEQUENCE raids_id_seq
1502 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1505 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1509 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1512 CREATE SEQUENCE scans_id_seq
1520 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1523 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
1527 -- Name: test; Type: SEQUENCE; Schema: public; Owner: -
1530 CREATE SEQUENCE test
1538 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
1541 CREATE SEQUENCE users_uid_seq
1549 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1552 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1556 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1559 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1563 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1566 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1570 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1573 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1577 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1580 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1584 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1587 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1591 -- Name: num; Type: DEFAULT; Schema: public; Owner: -
1594 ALTER TABLE fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
1598 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1601 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1605 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: -
1608 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1612 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: -
1615 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1619 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: -
1622 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1626 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: -
1629 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1633 -- Name: gid; Type: DEFAULT; Schema: public; Owner: -
1636 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1640 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1643 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1647 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1650 ALTER TABLE planet_data_types ALTER COLUMN id SET DEFAULT nextval('planet_data_types_id_seq'::regclass);
1654 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1657 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1661 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1664 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1668 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1671 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1675 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1678 ALTER TABLE scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
1682 -- Name: uid; Type: DEFAULT; Schema: public; Owner: -
1685 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1689 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1692 ALTER TABLE ONLY users
1693 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1697 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1700 ALTER TABLE ONLY alliance_stats
1701 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1705 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1708 ALTER TABLE ONLY alliances
1709 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1713 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1716 ALTER TABLE ONLY alliances
1717 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1721 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1724 ALTER TABLE ONLY calls
1725 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1729 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1732 ALTER TABLE ONLY calls
1733 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1737 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1740 ALTER TABLE ONLY channel_flags
1741 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1745 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1748 ALTER TABLE ONLY channel_flags
1749 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1753 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1756 ALTER TABLE ONLY channel_group_flags
1757 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
1761 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1764 ALTER TABLE ONLY channels
1765 ADD CONSTRAINT channels_name_key UNIQUE (name);
1769 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1772 ALTER TABLE ONLY channels
1773 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
1777 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1780 ALTER TABLE ONLY defense_missions
1781 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
1785 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1788 ALTER TABLE ONLY defense_requests
1789 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
1793 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1796 ALTER TABLE ONLY dumps
1797 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
1801 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1804 ALTER TABLE ONLY fleet_scans
1805 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (id);
1809 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1812 ALTER TABLE ONLY fleet_ships
1813 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
1817 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1820 ALTER TABLE ONLY fleet_ships
1821 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (id, ship);
1825 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1828 ALTER TABLE ONLY fleets
1829 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
1833 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1836 ALTER TABLE ONLY forum_access
1837 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
1841 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1844 ALTER TABLE ONLY forum_boards
1845 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
1849 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1852 ALTER TABLE ONLY forum_boards
1853 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
1857 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1860 ALTER TABLE ONLY forum_categories
1861 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
1865 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1868 ALTER TABLE ONLY forum_categories
1869 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
1873 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1876 ALTER TABLE ONLY forum_posts
1877 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
1881 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1884 ALTER TABLE ONLY forum_thread_visits
1885 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
1889 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1892 ALTER TABLE ONLY forum_threads
1893 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
1897 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1900 ALTER TABLE ONLY galaxies
1901 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
1905 -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1908 ALTER TABLE ONLY graphs
1909 ADD CONSTRAINT graphs_pkey PRIMARY KEY (type, id);
1913 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1916 ALTER TABLE ONLY groupmembers
1917 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
1921 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1924 ALTER TABLE ONLY groups
1925 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
1929 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1932 ALTER TABLE ONLY groups
1933 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
1937 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1940 ALTER TABLE ONLY incomings
1941 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
1945 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1948 ALTER TABLE ONLY incomings
1949 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
1953 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1956 ALTER TABLE ONLY misc
1957 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
1961 -- Name: planet_data_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1964 ALTER TABLE ONLY planet_data
1965 ADD CONSTRAINT planet_data_pkey PRIMARY KEY (rid, scan);
1969 -- Name: planet_data_types_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1972 ALTER TABLE ONLY planet_data_types
1973 ADD CONSTRAINT planet_data_types_category_key UNIQUE (category, name);
1977 -- Name: planet_data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1980 ALTER TABLE ONLY planet_data_types
1981 ADD CONSTRAINT planet_data_types_pkey PRIMARY KEY (id);
1985 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1988 ALTER TABLE ONLY planet_stats
1989 ADD CONSTRAINT planet_stats_id_key UNIQUE (id, tick);
1993 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1996 ALTER TABLE ONLY planet_stats
1997 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
2001 -- Name: planet_stats_x_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2004 ALTER TABLE ONLY planet_stats
2005 ADD CONSTRAINT planet_stats_x_key UNIQUE (x, y, z, tick);
2009 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2012 ALTER TABLE ONLY planets
2013 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
2017 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2020 ALTER TABLE ONLY planets
2021 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
2025 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2028 ALTER TABLE ONLY planets
2029 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
2033 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2036 ALTER TABLE ONLY raid_access
2037 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
2041 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2044 ALTER TABLE ONLY raid_claims
2045 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
2049 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2052 ALTER TABLE ONLY raid_targets
2053 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
2057 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2060 ALTER TABLE ONLY raid_targets
2061 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, planet);
2065 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2068 ALTER TABLE ONLY raids
2069 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
2073 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2076 ALTER TABLE ONLY scans
2077 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
2081 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2084 ALTER TABLE ONLY scans
2085 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
2089 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2092 ALTER TABLE ONLY ship_stats
2093 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
2097 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2100 ALTER TABLE ONLY smslist
2101 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
2105 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2108 ALTER TABLE ONLY users
2109 ADD CONSTRAINT users_planet_key UNIQUE (planet);
2113 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2116 ALTER TABLE ONLY users
2117 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
2121 -- Name: fleets_ingal_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2124 CREATE INDEX fleets_ingal_index ON fleets USING btree (ingal);
2128 -- Name: fleets_mission_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2131 CREATE INDEX fleets_mission_index ON fleets USING btree (mission);
2135 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2138 CREATE INDEX fleets_sender_index ON fleets USING btree (sender);
2142 -- Name: fleets_target_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2145 CREATE INDEX fleets_target_index ON fleets USING btree (target);
2149 -- Name: fleets_tick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2152 CREATE INDEX fleets_tick_index ON fleets USING btree (tick);
2156 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2159 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2163 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2166 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2170 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2173 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
2177 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2180 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2184 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2187 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2191 -- Name: planet_data_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2194 CREATE INDEX planet_data_id_index ON planet_data USING btree (id);
2198 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2201 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2205 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2208 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
2212 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2215 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2219 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2222 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
2226 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2229 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2233 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2236 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
2240 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2243 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
2247 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2250 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2254 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2257 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2261 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2264 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2268 -- Name: scans_parsed_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2271 CREATE INDEX scans_parsed_index ON scans USING btree (parsed);
2275 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2278 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
2282 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2285 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2289 -- Name: users_pnick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2292 CREATE UNIQUE INDEX users_pnick_index ON users USING btree (lower(pnick));
2296 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2299 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2303 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: -
2306 CREATE TRIGGER add_call
2307 BEFORE INSERT ON calls
2309 EXECUTE PROCEDURE add_call();
2313 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: -
2316 CREATE TRIGGER add_remove_member
2317 AFTER INSERT OR DELETE ON groupmembers
2319 EXECUTE PROCEDURE change_member();
2323 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: -
2326 CREATE TRIGGER add_user
2327 BEFORE INSERT ON users
2329 EXECUTE PROCEDURE add_user();
2333 -- Name: unclaim_target; Type: TRIGGER; Schema: public; Owner: -
2336 CREATE TRIGGER unclaim_target
2337 AFTER DELETE ON raid_claims
2339 EXECUTE PROCEDURE unclaim_target();
2343 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: -
2346 CREATE TRIGGER update_forum_post
2347 BEFORE INSERT OR UPDATE ON forum_posts
2349 EXECUTE PROCEDURE update_forum_post();
2353 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: -
2356 CREATE TRIGGER update_planet
2357 AFTER UPDATE ON users
2359 EXECUTE PROCEDURE update_user_planet();
2363 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: -
2366 CREATE TRIGGER update_target
2367 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2369 EXECUTE PROCEDURE updated_target();
2373 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2376 ALTER TABLE ONLY alliance_stats
2377 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2381 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2384 ALTER TABLE ONLY calls
2385 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2389 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2392 ALTER TABLE ONLY calls
2393 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
2397 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2400 ALTER TABLE ONLY calls
2401 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2405 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2408 ALTER TABLE ONLY channel_group_flags
2409 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2413 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2416 ALTER TABLE ONLY channel_group_flags
2417 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2421 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2424 ALTER TABLE ONLY channel_group_flags
2425 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2429 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2432 ALTER TABLE ONLY defense_missions
2433 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2437 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2440 ALTER TABLE ONLY defense_missions
2441 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2445 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2448 ALTER TABLE ONLY defense_requests
2449 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2453 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2456 ALTER TABLE ONLY fleet_scans
2457 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON DELETE CASCADE;
2461 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2464 ALTER TABLE ONLY fleet_scans
2465 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2469 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2472 ALTER TABLE ONLY fleet_ships
2473 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2477 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2480 ALTER TABLE ONLY fleet_ships
2481 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(name);
2485 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2488 ALTER TABLE ONLY fleets
2489 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2493 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2496 ALTER TABLE ONLY fleets
2497 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2501 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2504 ALTER TABLE ONLY fleets
2505 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2509 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2512 ALTER TABLE ONLY forum_access
2513 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2517 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2520 ALTER TABLE ONLY forum_access
2521 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2525 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2528 ALTER TABLE ONLY forum_boards
2529 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2533 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2536 ALTER TABLE ONLY forum_posts
2537 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2541 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2544 ALTER TABLE ONLY forum_posts
2545 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2549 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2552 ALTER TABLE ONLY forum_thread_visits
2553 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2557 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2560 ALTER TABLE ONLY forum_thread_visits
2561 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2565 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2568 ALTER TABLE ONLY forum_threads
2569 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2573 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2576 ALTER TABLE ONLY forum_threads
2577 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
2581 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2584 ALTER TABLE ONLY groupmembers
2585 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2589 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2592 ALTER TABLE ONLY groupmembers
2593 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2597 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2600 ALTER TABLE ONLY incomings
2601 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2605 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2608 ALTER TABLE ONLY incomings
2609 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2613 -- Name: planet_data_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2616 ALTER TABLE ONLY planet_data
2617 ADD CONSTRAINT planet_data_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2621 -- Name: planet_data_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2624 ALTER TABLE ONLY planet_data
2625 ADD CONSTRAINT planet_data_rid_fkey FOREIGN KEY (rid) REFERENCES planet_data_types(id);
2629 -- Name: planet_data_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2632 ALTER TABLE ONLY planet_data
2633 ADD CONSTRAINT planet_data_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2637 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2640 ALTER TABLE ONLY planet_stats
2641 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2645 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2648 ALTER TABLE ONLY planets
2649 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2653 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2656 ALTER TABLE ONLY planets
2657 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2661 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2664 ALTER TABLE ONLY raid_access
2665 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2669 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2672 ALTER TABLE ONLY raid_access
2673 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2677 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2680 ALTER TABLE ONLY raid_claims
2681 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2685 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2688 ALTER TABLE ONLY raid_claims
2689 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2693 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2696 ALTER TABLE ONLY raid_targets
2697 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2701 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2704 ALTER TABLE ONLY raid_targets
2705 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2709 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2712 ALTER TABLE ONLY scans
2713 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2717 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2720 ALTER TABLE ONLY scans
2721 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2725 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2728 ALTER TABLE ONLY users
2729 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2733 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2736 ALTER TABLE ONLY users
2737 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
2741 -- Name: public; Type: ACL; Schema: -; Owner: -
2744 REVOKE ALL ON SCHEMA public FROM PUBLIC;
2745 REVOKE ALL ON SCHEMA public FROM postgres;
2746 GRANT ALL ON SCHEMA public TO postgres;
2747 GRANT ALL ON SCHEMA public TO PUBLIC;
2751 -- PostgreSQL database dump complete