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 OR REPLACE 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, h.hidden, fl.light, fm.medium, fh.heavy
530 (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))
531 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS crystal_roids FROM planet_data WHERE (planet_data.rid = 2)) cr USING (id)
532 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS eonium_roids FROM planet_data WHERE (planet_data.rid = 3)) er USING (id)
533 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS metal FROM planet_data WHERE (planet_data.rid = 4)) m USING (id)
534 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS crystal FROM planet_data WHERE (planet_data.rid = 5)) c USING (id)
535 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS eonium FROM planet_data WHERE (planet_data.rid = 6)) e USING (id)
536 JOIN (SELECT planet_data.scan AS id, planet_data.amount AS hidden FROM planet_data WHERE (planet_data.rid = 25)) h USING (id)
537 LEFT OUTER JOIN (SELECT planet_data.scan AS id, planet_data.amount AS light FROM planet_data WHERE (planet_data.rid = 26)) fl USING (id)
538 LEFT OUTER JOIN (SELECT planet_data.scan AS id, planet_data.amount AS medium FROM planet_data WHERE (planet_data.rid = 27)) fm USING (id)
539 LEFT OUTER JOIN (SELECT planet_data.scan AS id, planet_data.amount AS heavy FROM planet_data WHERE (planet_data.rid = 28)) fh USING (id)
540 ORDER BY s.planet, s.tick DESC, s.id DESC;
544 -- Name: raid_access; Type: TABLE; Schema: public; Owner: -; Tablespace:
547 CREATE TABLE raid_access (
548 raid integer NOT NULL,
554 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: -; Tablespace:
557 CREATE TABLE raid_claims (
558 target integer NOT NULL,
559 uid integer NOT NULL,
560 wave integer NOT NULL,
561 joinable boolean DEFAULT false NOT NULL,
562 launched boolean DEFAULT false NOT NULL,
563 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
568 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: -; Tablespace:
571 CREATE TABLE raid_targets (
573 raid integer NOT NULL,
574 planet integer NOT NULL,
576 modified timestamp with time zone DEFAULT now() NOT NULL
581 -- Name: raids; Type: TABLE; Schema: public; Owner: -; Tablespace:
586 tick integer NOT NULL,
587 open boolean DEFAULT false NOT NULL,
588 waves integer DEFAULT 3 NOT NULL,
589 message text NOT NULL,
590 removed boolean DEFAULT false NOT NULL,
591 released_coords boolean DEFAULT false NOT NULL
596 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
599 CREATE TABLE ship_stats (
604 init integer NOT NULL,
605 armor integer NOT NULL,
606 damage integer NOT NULL,
607 metal integer NOT NULL,
608 crystal integer NOT NULL,
609 eonium integer NOT NULL,
611 guns integer DEFAULT 0 NOT NULL,
612 eres integer DEFAULT 0 NOT NULL,
619 -- Name: smslist; Type: TABLE; Schema: public; Owner: -; Tablespace:
622 CREATE TABLE smslist (
630 -- Name: structure_scans; Type: VIEW; Schema: public; Owner: -
633 CREATE VIEW structure_scans AS
634 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;
638 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
642 uid integer NOT NULL,
643 username text NOT NULL,
645 password text NOT NULL,
646 attack_points integer DEFAULT 0 NOT NULL,
647 defense_points integer DEFAULT 0 NOT NULL,
648 scan_points integer DEFAULT 0 NOT NULL,
649 humor_points integer DEFAULT 0 NOT NULL,
653 laston timestamp with time zone,
656 last_forum_visit timestamp with time zone,
664 -- Name: usersingroup; Type: VIEW; Schema: public; Owner: -
667 CREATE VIEW usersingroup AS
668 SELECT groups.gid, groups.groupname, users.uid, users.username FROM ((users NATURAL JOIN groupmembers) NATURAL JOIN groups);
672 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: -
675 CREATE FUNCTION add_call() RETURNS trigger
677 if ($_TD->{event} eq 'INSERT'){
678 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
679 if ($rv->{processed} != 1){
682 $ftid = $rv->{rows}[0]->{id};
683 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES(-3,$1,$2,-3)','int4','varchar');
684 $rv = spi_exec_prepared($query,$ftid,"$_TD->{new}{member}: $_TD->{new}{landing_tick}");
685 spi_freeplan($query);
686 if (rv->{status} != SPI_OK_INSERT){
689 $_TD->{new}{ftid} = $ftid;
698 -- Name: add_intel(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
701 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
702 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
704 $tick = -1 unless defined $tick;
705 if ($x1 == $x2 && $y1 == $y2) {
709 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
710 $tick = $rv->{rows}[0]->{tick};
712 $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;");
713 unless ($rv->{processed} >= 1){
716 $id1 = $rv->{rows}[0]->{id};
717 $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;");
718 unless ($rv->{processed} >= 1){
721 $id2 = $rv->{rows}[0]->{id};
723 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
729 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
732 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
733 AS $_$my ($tick, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $user) = @_;
735 if ($x1 == $x2 && $y1 == $y2) {
739 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
740 $tick = $rv->{rows}[0]->{tick};
742 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x1 AND y = $y1 AND z = $z1 AND tick = $tick;");
743 unless ($rv->{processed} == 1){
746 $id1 = $rv->{rows}[0]->{id};
747 $rv = spi_exec_query("SELECT id FROM planet_stats WHERE x = $x2 AND y = $y2 AND z = $z2 AND tick = $tick;");
748 unless ($rv->{processed} == 1){
751 $id2 = $rv->{rows}[0]->{id};
752 spi_exec_query("INSERT INTO intel (target,sender,tick,mission,\"user\",ingal, amount) VALUES ($id1, $id2, $tick, '$mission', '$user', $ingal, $amount)");
758 -- Name: add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
761 CREATE FUNCTION add_intel2(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, character varying) RETURNS boolean
762 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
763 unless ($uid = /^(-?\d+)$/){
764 $rv = spi_exec_query("SELECT id FROM users WHERE username = '$uid';");
765 $uid = $rv->{rows}[0]->{id};
768 if ($x1 == $x2 && $y1 == $y2) {
772 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
773 $tick = $rv->{rows}[0]->{tick};
775 $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;");
776 unless ($rv->{processed} >= 1){
779 $id1 = $rv->{rows}[0]->{id};
780 $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;");
781 unless ($rv->{processed} >= 1){
784 $id2 = $rv->{rows}[0]->{id};
786 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
792 -- Name: add_intel4(integer, integer, integer, integer, integer, integer, integer, integer, integer, character varying, integer); Type: FUNCTION; Schema: public; Owner: -
795 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
796 AS $_$my ($tick, $eta, $x1, $y1, $z1, $x2, $y2, $z2, $amount, $mission, $uid) = @_;
798 if ($x1 == $x2 && $y1 == $y2) {
802 $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
803 $tick = $rv->{rows}[0]->{tick};
805 $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;");
806 unless ($rv->{processed} >= 1){
809 $id1 = $rv->{rows}[0]->{id};
810 $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;");
811 unless ($rv->{processed} >= 1){
814 $id2 = $rv->{rows}[0]->{id};
816 spi_exec_query("INSERT INTO intel (target,sender,tick,eta,mission,uid,ingal, amount) VALUES ($id1, $id2, $tick,$eta, '$mission', $uid, $ingal, $amount)");
822 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: -
825 CREATE FUNCTION add_user() RETURNS trigger
827 if ($_TD->{event} eq 'INSERT'){
828 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
829 if ($rv->{processed} != 1){
832 $ftid = $rv->{rows}[0]->{id};
833 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
834 $rv = spi_exec_prepared($query,-1,$ftid,"$_TD->{new}{uid}: $_TD->{new}{username}");
835 spi_freeplan($query);
836 if (rv->{status} != SPI_OK_INSERT){
839 $_TD->{new}{ftid} = $ftid;
848 -- Name: calc_rank(integer); Type: FUNCTION; Schema: public; Owner: -
851 CREATE FUNCTION calc_rank(tick integer) RETURNS void
852 AS $_$my ($tick) = @_;
853 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
855 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
856 my $status = $rv->{status};
857 my $nrows = $rv->{processed};
859 for ($row = 1; $row <= $nrows; ++$row ){
860 $id = $rv->{rows}[$row-1]->{id};
861 $ranks{$id}{'score'} = $row;
864 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
865 my $status = $rv->{status};
866 my $nrows = $rv->{processed};
868 for ($row = 1; $row <= $nrows; ++$row ){
869 $id = $rv->{rows}[$row-1]->{id};
870 $ranks{$id}{'value'} = $row;
873 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
874 my $status = $rv->{status};
875 my $nrows = $rv->{processed};
877 for ($row = 1; $row <= $nrows; ++$row ){
878 $id = $rv->{rows}[$row-1]->{id};
879 $ranks{$id}{'size'} = $row;
882 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
883 my $status = $rv->{status};
884 my $nrows = $rv->{processed};
886 for ($row = 1; $row <= $nrows; ++$row ){
887 $id = $rv->{rows}[$row-1]->{id};
888 $ranks{$id}{'xp'} = $row;
890 foreach $key (keys(%ranks)){
891 spi_exec_query("INSERT INTO rankings (id,tick,score,value,size,xp) VALUES($key,$tick,".$ranks{$key}{'score'}.",".$ranks{$key}{'value'}.",".$ranks{$key}{'size'}.",".$ranks{$key}{'xp'}.")");
898 -- Name: calc_rank3(integer); Type: FUNCTION; Schema: public; Owner: -
901 CREATE FUNCTION calc_rank3(tick integer) RETURNS information_schema.cardinal_number
902 AS $_$my ($tick) = @_;
903 #spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
905 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
906 my $status = $rv->{status};
907 my $nrows = $rv->{processed};
909 for ($row = 1; $row <= $nrows; ++$row ){
910 $id = $rv->{rows}[$row-1]->{id};
911 #$ranks{$id}{'score'} = $row;
914 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
915 my $status = $rv->{status};
916 my $nrows = $rv->{processed};
918 for ($row = 1; $row <= $nrows; ++$row ){
919 $id = $rv->{rows}[$row-1]->{id};
920 #$ranks{$id}{'value'} = $row;
923 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
924 my $status = $rv->{status};
925 my $nrows = $rv->{processed};
927 for ($row = 1; $row <= $nrows; ++$row ){
928 $id = $rv->{rows}[$row-1]->{id};
929 #$ranks{$id}{'size'} = $row;
932 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
933 my $status = $rv->{status};
934 my $nrows = $rv->{processed};
936 for ($row = 1; $row <= $nrows; ++$row ){
937 $id = $rv->{rows}[$row-1]->{id};
938 #$ranks{$id}{'xp'} = $row;
940 foreach $key (keys(%ranks)){
941 #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'}.")");
948 -- Name: calculate_rankings(integer); Type: FUNCTION; Schema: public; Owner: -
951 CREATE FUNCTION calculate_rankings(integer) RETURNS void
952 AS $_$my ($tick) = @_;
953 spi_exec_query("DELETE FROM rankings WHERE tick = $tick");
954 my $rv = spi_exec_query("SELECT id, score FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY score DESC");
955 my $status = $rv->{status};
956 my $nrows = $rv->{processed};
958 for ($row = 1; $row <= $nrows; ++$row ){
959 $id = $rv->{rows}[$row-1]->{id};
960 spi_exec_query("INSERT INTO rankings (id,tick,score) VALUES($id,$tick,$row)");
963 my $rv = spi_exec_query("SELECT id, value FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY value DESC");
964 my $status = $rv->{status};
965 my $nrows = $rv->{processed};
967 for ($row = 1; $row <= $nrows; ++$row ){
968 $id = $rv->{rows}[$row-1]->{id};
969 spi_exec_query("UPDATE rankings SET value = $row WHERE id = $id AND tick = $tick");
972 my $rv = spi_exec_query("SELECT id, size FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY size DESC");
973 my $status = $rv->{status};
974 my $nrows = $rv->{processed};
976 for ($row = 1; $row <= $nrows; ++$row ){
977 $id = $rv->{rows}[$row-1]->{id};
978 spi_exec_query("UPDATE rankings SET size = $row WHERE id = $id AND tick = $tick");
981 my $rv = spi_exec_query("SELECT id, (score-value) as xp FROM planets NATURAL JOIN planet_stats WHERE tick = $tick ORDER BY xp DESC");
982 my $status = $rv->{status};
983 my $nrows = $rv->{processed};
985 for ($row = 1; $row <= $nrows; ++$row ){
986 $id = $rv->{rows}[$row-1]->{id};
987 spi_exec_query("UPDATE rankings SET xp = $row WHERE id = $id AND tick = $tick");
994 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: -
997 CREATE FUNCTION change_member() RETURNS trigger
998 AS $_X$if ($_TD->{event} eq 'INSERT' && $_TD->{new}{gid} == 2){
999 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{new}{uid};");
1000 if ($rv->{rows}[0]->{planet}){
1001 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $rv->{rows}[0]->{planet};");
1004 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{gid} == 2){
1005 $rv = spi_exec_query("SELECT * FROM users WHERE uid = $_TD->{old}{uid};");
1006 if ($rv->{rows}[0]->{planet}){
1007 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $rv->{rows}[0]{planet};");
1015 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1018 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
1019 AS $_$my ($x,$y,$z) = @_;
1020 return "$x:$y:$z";$_$
1021 LANGUAGE plperl IMMUTABLE;
1025 -- Name: covop_alert(integer, integer, governments, integer); Type: FUNCTION; Schema: public; Owner: -
1028 CREATE FUNCTION covop_alert(secs integer, strucs integer, gov governments, population integer) RETURNS integer
1030 SELECT (70*(1.0+LEAST(COALESCE($1::float/$2,$4),0.30)*2 +
1032 WHEN 'Dic' THEN 0.20
1033 WHEN 'Feu' THEN -0.20
1034 WHEN 'Uni' THEN -0.10
1036 END) + $4/100.0))::integer;
1038 LANGUAGE sql IMMUTABLE;
1042 -- Name: find_alliance_id(character varying); Type: FUNCTION; Schema: public; Owner: -
1045 CREATE FUNCTION find_alliance_id(character varying) RETURNS integer
1048 my $query = spi_prepare('SELECT id FROM alliances WHERE name=$1','varchar');
1049 my $rv = spi_exec_prepared($query,$name);
1050 my $status = $rv->{status};
1051 my $nrows = $rv->{processed};
1054 $id = $rv->{rows}[0]->{id};
1057 $rv = spi_exec_query("SELECT nextval('public.alliances_id_seq') AS id");
1058 if ($rv->{processed} != 1){
1061 $id = $rv->{rows}[0]->{id};
1062 my $query = spi_prepare('INSERT INTO alliances(id,name) VALUES($1,$2)','int4','varchar');
1063 $rv = spi_exec_prepared($query,$id,$name);
1064 spi_freeplan($query);
1065 if (rv->{status} != SPI_OK_INSERT){
1075 -- Name: findplanetid(character varying, character varying, character varying); Type: FUNCTION; Schema: public; Owner: -
1078 CREATE FUNCTION findplanetid(character varying, character varying, character varying) RETURNS integer
1080 my ($ruler, $planet, $race) = @_;
1081 my $query = spi_prepare('SELECT id, race FROM planets WHERE ruler=$1 AND planet=$2','varchar','varchar');
1082 my $rv = spi_exec_prepared($query,$ruler,$planet);
1083 spi_freeplan($query);
1084 my $status = $rv->{status};
1085 my $nrows = $rv->{processed};
1088 $id = $rv->{rows}[0]->{id};
1089 unless ($race eq $rv->{rows}[0]->{race}){
1090 $query = spi_prepare('UPDATE planets SET race=$1 where id=$2','race','int4');
1091 spi_exec_prepared($query,$race,$id);
1092 spi_freeplan($query);
1095 $rv = spi_exec_query("SELECT nextval('public.forum_threads_ftid_seq') AS id");
1096 if ($rv->{processed} != 1){
1099 $ftid = $rv->{rows}[0]->{id};
1100 $query = spi_prepare('INSERT INTO forum_threads (fbid,ftid,subject,uid) VALUES($1,$2,$3,-3)','int4','int4','varchar');
1101 $rv = spi_exec_prepared($query,-2,$ftid,"$ruler OF $planet");
1102 spi_freeplan($query);
1103 if (rv->{status} != SPI_OK_INSERT){
1106 $rv = spi_exec_query("SELECT nextval('public.planets_id_seq') AS id");
1107 if ($rv->{processed} != 1){
1110 $id = $rv->{rows}[0]->{id};
1111 $query = spi_prepare('INSERT INTO planets(id,ruler,planet,race,ftid) VALUES($1,$2,$3,$4,$5)','int4','varchar','varchar','race','int4
1113 $rv = spi_exec_prepared($query,$id,$ruler,$planet,$race,$ftid);
1114 spi_freeplan($query);
1115 if (rv->{status} != SPI_OK_INSERT){
1126 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: -
1129 CREATE FUNCTION groups(uid integer) RETURNS SETOF integer
1130 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT -1$_$
1131 LANGUAGE sql STABLE;
1135 -- Name: max_bank_hack(integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1138 CREATE FUNCTION max_bank_hack(metal integer, crystal integer, eonium integer, tvalue integer, value integer) RETURNS integer
1140 SELECT LEAST(2000.0*15*$4/$5,$1*0.10, 15*7500.0)::integer
1141 + LEAST(2000.0*15*$4/$5,$2*0.10, 15*7500.0)::integer
1142 + LEAST(2000.0*15*$4/$5,$3*0.10, 15*7500.0)::integer
1144 LANGUAGE sql IMMUTABLE;
1148 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: -
1151 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
1152 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$
1153 LANGUAGE sql IMMUTABLE;
1157 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: -
1160 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
1161 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$_$
1162 LANGUAGE sql STABLE;
1166 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
1169 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
1170 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$_$
1171 LANGUAGE sql STABLE;
1175 -- Name: populate_ticks(); Type: FUNCTION; Schema: public; Owner: -
1178 CREATE FUNCTION populate_ticks() RETURNS void
1179 AS $_$my $rv = spi_exec_query("SELECT tick FROM planet_stats ORDER BY tick DESC LIMIT 1;");
1180 my $nrows = $rv->{processed};
1182 $tick = $rv->{rows}[0]->{tick};
1183 spi_exec_query("DELETE FROM ticks;");
1184 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);");
1185 spi_exec_query("INSERT INTO ticks(tick) VALUES($tick)");
1191 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: -
1194 CREATE FUNCTION tick() RETURNS integer
1195 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$
1196 LANGUAGE sql STABLE;
1200 -- Name: unclaim_target(); Type: FUNCTION; Schema: public; Owner: -
1203 CREATE FUNCTION unclaim_target() RETURNS trigger
1205 if ($_TD->{event} eq 'DELETE' && $_TD->{old}{launched} eq 't'){
1206 my $uid = $_TD->{old}{uid};
1207 my $query = spi_prepare(q{UPDATE users
1208 SET attack_points = attack_points - 1
1209 WHERE uid = $1},'int4');
1210 spi_exec_prepared($query,$uid);
1211 spi_freeplan($query);
1219 -- Name: update_forum_post(); Type: FUNCTION; Schema: public; Owner: -
1222 CREATE FUNCTION update_forum_post() RETURNS trigger
1227 SELECT setweight(to_tsvector(coalesce(ft.subject,'')), 'A')
1228 || setweight(to_tsvector(coalesce(u.username,'')), 'B') AS ts
1230 FROM forum_threads ft, users u
1231 WHERE NEW.ftid = ft.ftid AND u.uid = NEW.uid;
1232 NEW.textsearch := rec.ts
1233 || setweight(to_tsvector(coalesce(NEW.message,'')), 'D');
1241 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: -
1244 CREATE FUNCTION update_user_planet() RETURNS trigger
1245 AS $_X$my $rv = spi_exec_query("SELECT * FROM groupmembers WHERE uid = $_TD->{new}{uid} AND gid = 2;");
1246 if ($rv->{processed} == 1){# && ($_TD->{old}{planet} != $_TD->{new}{planet})){
1247 if ($_TD->{old}{planet}){
1248 spi_exec_query("UPDATE planets SET alliance_id = NULL WHERE id = $_TD->{old}{planet};");
1250 if ($_TD->{new}{planet}){
1251 spi_exec_query("UPDATE planets SET alliance_id = 1 WHERE id = $_TD->{new}{planet};");
1254 if ($_TD->{old}{planet}){
1255 spi_exec_query("UPDATE planets SET nick = NULL WHERE id = $_TD->{old}{planet};");
1257 if ($_TD->{new}{planet}){
1258 spi_exec_query("UPDATE planets SET nick = '$_TD->{new}{username}' WHERE id = $_TD->{new}{planet};");
1265 -- Name: updated_target(); Type: FUNCTION; Schema: public; Owner: -
1268 CREATE FUNCTION updated_target() RETURNS trigger
1269 AS $_X$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
1270 my $target = $_TD->{new}{target};
1271 $target = $_TD->{old}{target} if ($_TD->{event} eq 'DELETE');
1272 spi_exec_prepared($query,$target);
1273 spi_freeplan($query);$_X$
1278 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
1281 CREATE AGGREGATE concat(text) (
1289 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1292 CREATE SEQUENCE alliances_id_seq
1300 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1303 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.id;
1307 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1310 CREATE SEQUENCE calls_id_seq
1318 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1321 ALTER SEQUENCE calls_id_seq OWNED BY calls.id;
1325 -- Name: channel_flags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1328 CREATE SEQUENCE channel_flags_id_seq
1336 -- Name: channel_flags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1339 ALTER SEQUENCE channel_flags_id_seq OWNED BY channel_flags.id;
1343 -- Name: channels_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1346 CREATE SEQUENCE channels_id_seq
1354 -- Name: channels_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1357 ALTER SEQUENCE channels_id_seq OWNED BY channels.id;
1361 -- Name: defense_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1364 CREATE SEQUENCE defense_requests_id_seq
1372 -- Name: defense_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1375 ALTER SEQUENCE defense_requests_id_seq OWNED BY defense_requests.id;
1379 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: -
1382 CREATE SEQUENCE fleet_ships_num_seq
1390 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1393 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1397 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1400 CREATE SEQUENCE fleets_id_seq
1408 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1411 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.id;
1415 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: -
1418 CREATE SEQUENCE forum_boards_fbid_seq
1426 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1429 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1433 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: -
1436 CREATE SEQUENCE forum_categories_fcid_seq
1444 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1447 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1451 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: -
1454 CREATE SEQUENCE forum_posts_fpid_seq
1462 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1465 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1469 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: -
1472 CREATE SEQUENCE forum_threads_ftid_seq
1480 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1483 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1487 -- Name: groups_gid_seq; Type: SEQUENCE; Schema: public; Owner: -
1490 CREATE SEQUENCE groups_gid_seq
1498 -- Name: groups_gid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1501 ALTER SEQUENCE groups_gid_seq OWNED BY groups.gid;
1505 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1508 CREATE SEQUENCE incomings_id_seq
1516 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1519 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.id;
1523 -- Name: planet_data_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1526 CREATE SEQUENCE planet_data_types_id_seq
1534 -- Name: planet_data_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1537 ALTER SEQUENCE planet_data_types_id_seq OWNED BY planet_data_types.id;
1541 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1544 CREATE SEQUENCE planets_id_seq
1552 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1555 ALTER SEQUENCE planets_id_seq OWNED BY planets.id;
1559 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1562 CREATE SEQUENCE raid_targets_id_seq
1570 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1573 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
1577 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1580 CREATE SEQUENCE raids_id_seq
1588 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1591 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
1595 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1598 CREATE SEQUENCE scans_id_seq
1606 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1609 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
1613 -- Name: test; Type: SEQUENCE; Schema: public; Owner: -
1616 CREATE SEQUENCE test
1624 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: -
1627 CREATE SEQUENCE users_uid_seq
1635 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1638 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
1642 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1645 ALTER TABLE alliances ALTER COLUMN id SET DEFAULT nextval('alliances_id_seq'::regclass);
1649 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1652 ALTER TABLE calls ALTER COLUMN id SET DEFAULT nextval('calls_id_seq'::regclass);
1656 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1659 ALTER TABLE channel_flags ALTER COLUMN id SET DEFAULT nextval('channel_flags_id_seq'::regclass);
1663 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1666 ALTER TABLE channels ALTER COLUMN id SET DEFAULT nextval('channels_id_seq'::regclass);
1670 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1673 ALTER TABLE defense_requests ALTER COLUMN id SET DEFAULT nextval('defense_requests_id_seq'::regclass);
1677 -- Name: num; Type: DEFAULT; Schema: public; Owner: -
1680 ALTER TABLE fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
1684 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1687 ALTER TABLE fleets ALTER COLUMN id SET DEFAULT nextval('fleets_id_seq'::regclass);
1691 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: -
1694 ALTER TABLE forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
1698 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: -
1701 ALTER TABLE forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
1705 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: -
1708 ALTER TABLE forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
1712 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: -
1715 ALTER TABLE forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
1719 -- Name: gid; Type: DEFAULT; Schema: public; Owner: -
1722 ALTER TABLE groups ALTER COLUMN gid SET DEFAULT nextval('groups_gid_seq'::regclass);
1726 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1729 ALTER TABLE incomings ALTER COLUMN id SET DEFAULT nextval('incomings_id_seq'::regclass);
1733 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1736 ALTER TABLE planet_data_types ALTER COLUMN id SET DEFAULT nextval('planet_data_types_id_seq'::regclass);
1740 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1743 ALTER TABLE planets ALTER COLUMN id SET DEFAULT nextval('planets_id_seq'::regclass);
1747 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1750 ALTER TABLE raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
1754 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1757 ALTER TABLE raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
1761 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1764 ALTER TABLE scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
1768 -- Name: uid; Type: DEFAULT; Schema: public; Owner: -
1771 ALTER TABLE users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
1775 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1778 ALTER TABLE ONLY users
1779 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
1783 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1786 ALTER TABLE ONLY alliance_stats
1787 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (id, tick);
1791 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1794 ALTER TABLE ONLY alliances
1795 ADD CONSTRAINT alliances_name_key UNIQUE (name);
1799 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1802 ALTER TABLE ONLY alliances
1803 ADD CONSTRAINT alliances_pkey PRIMARY KEY (id);
1807 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1810 ALTER TABLE ONLY calls
1811 ADD CONSTRAINT calls_member_key UNIQUE (member, landing_tick);
1815 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1818 ALTER TABLE ONLY calls
1819 ADD CONSTRAINT calls_pkey PRIMARY KEY (id);
1823 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1826 ALTER TABLE ONLY channel_flags
1827 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
1831 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1834 ALTER TABLE ONLY channel_flags
1835 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (id);
1839 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1842 ALTER TABLE ONLY channel_group_flags
1843 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, "group", flag);
1847 -- Name: channels_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1850 ALTER TABLE ONLY channels
1851 ADD CONSTRAINT channels_name_key UNIQUE (name);
1855 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1858 ALTER TABLE ONLY channels
1859 ADD CONSTRAINT channels_pkey PRIMARY KEY (id);
1863 -- Name: covop_attacks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1866 ALTER TABLE ONLY covop_attacks
1867 ADD CONSTRAINT covop_attacks_pkey PRIMARY KEY (id, tick, uid);
1871 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1874 ALTER TABLE ONLY defense_missions
1875 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
1879 -- Name: defense_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1882 ALTER TABLE ONLY defense_requests
1883 ADD CONSTRAINT defense_requests_pkey PRIMARY KEY (id);
1887 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1890 ALTER TABLE ONLY dumps
1891 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
1895 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1898 ALTER TABLE ONLY fleet_scans
1899 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (id);
1903 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1906 ALTER TABLE ONLY fleet_ships
1907 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
1911 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1914 ALTER TABLE ONLY fleet_ships
1915 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (id, ship);
1919 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1922 ALTER TABLE ONLY fleets
1923 ADD CONSTRAINT fleets_pkey PRIMARY KEY (id);
1927 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1930 ALTER TABLE ONLY forum_access
1931 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
1935 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1938 ALTER TABLE ONLY forum_boards
1939 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
1943 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1946 ALTER TABLE ONLY forum_boards
1947 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
1951 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1954 ALTER TABLE ONLY forum_categories
1955 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
1959 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1962 ALTER TABLE ONLY forum_categories
1963 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
1967 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1970 ALTER TABLE ONLY forum_posts
1971 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
1975 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1978 ALTER TABLE ONLY forum_thread_visits
1979 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
1983 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1986 ALTER TABLE ONLY forum_threads
1987 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
1991 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1994 ALTER TABLE ONLY galaxies
1995 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (x, y, tick);
1999 -- Name: graphs_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2002 ALTER TABLE ONLY graphs
2003 ADD CONSTRAINT graphs_pkey PRIMARY KEY (type, id);
2007 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2010 ALTER TABLE ONLY groupmembers
2011 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2015 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2018 ALTER TABLE ONLY groups
2019 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2023 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2026 ALTER TABLE ONLY groups
2027 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2031 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2034 ALTER TABLE ONLY incomings
2035 ADD CONSTRAINT incomings_call_key UNIQUE (call, sender, fleet);
2039 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2042 ALTER TABLE ONLY incomings
2043 ADD CONSTRAINT incomings_pkey PRIMARY KEY (id);
2047 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2050 ALTER TABLE ONLY misc
2051 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
2055 -- Name: planet_data_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2058 ALTER TABLE ONLY planet_data
2059 ADD CONSTRAINT planet_data_pkey PRIMARY KEY (rid, scan);
2063 -- Name: planet_data_types_category_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2066 ALTER TABLE ONLY planet_data_types
2067 ADD CONSTRAINT planet_data_types_category_key UNIQUE (category, name);
2071 -- Name: planet_data_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2074 ALTER TABLE ONLY planet_data_types
2075 ADD CONSTRAINT planet_data_types_pkey PRIMARY KEY (id);
2079 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2082 ALTER TABLE ONLY planet_stats
2083 ADD CONSTRAINT planet_stats_id_key UNIQUE (id, tick);
2087 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2090 ALTER TABLE ONLY planet_stats
2091 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
2095 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2098 ALTER TABLE ONLY planets
2099 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
2103 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2106 ALTER TABLE ONLY planets
2107 ADD CONSTRAINT planets_pkey PRIMARY KEY (id);
2111 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2114 ALTER TABLE ONLY planets
2115 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
2119 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2122 ALTER TABLE ONLY raid_access
2123 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
2127 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2130 ALTER TABLE ONLY raid_claims
2131 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
2135 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2138 ALTER TABLE ONLY raid_targets
2139 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
2143 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2146 ALTER TABLE ONLY raid_targets
2147 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, planet);
2151 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2154 ALTER TABLE ONLY raids
2155 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
2159 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2162 ALTER TABLE ONLY scans
2163 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
2167 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2170 ALTER TABLE ONLY scans
2171 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
2175 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2178 ALTER TABLE ONLY ship_stats
2179 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (name);
2183 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2186 ALTER TABLE ONLY smslist
2187 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
2191 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2194 ALTER TABLE ONLY users
2195 ADD CONSTRAINT users_planet_key UNIQUE (planet);
2199 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
2202 ALTER TABLE ONLY users
2203 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
2207 -- Name: fleets_ingal_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2210 CREATE INDEX fleets_ingal_index ON fleets USING btree (ingal);
2214 -- Name: fleets_mission_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2217 CREATE INDEX fleets_mission_index ON fleets USING btree (mission);
2221 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2224 CREATE INDEX fleets_sender_index ON fleets USING btree (sender);
2228 -- Name: fleets_target_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2231 CREATE INDEX fleets_target_index ON fleets USING btree (target);
2235 -- Name: fleets_tick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2238 CREATE INDEX fleets_tick_index ON fleets USING btree (tick);
2242 -- Name: forum_access_gid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2245 CREATE INDEX forum_access_gid_index ON forum_access USING btree (gid);
2249 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2252 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
2256 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2259 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
2263 -- Name: forum_posts_time_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2266 CREATE INDEX forum_posts_time_index ON forum_posts USING btree ("time");
2270 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2273 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
2277 -- Name: planet_data_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2280 CREATE INDEX planet_data_id_index ON planet_data USING btree (id);
2284 -- Name: planet_stats_score_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2287 CREATE INDEX planet_stats_score_index ON planet_stats USING btree (tick, score);
2291 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2294 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
2298 -- Name: planet_stats_size_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2301 CREATE INDEX planet_stats_size_index ON planet_stats USING btree (tick, size);
2305 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2308 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
2312 -- Name: planet_stats_value_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2315 CREATE INDEX planet_stats_value_index ON planet_stats USING btree (tick, value);
2319 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2322 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
2326 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2329 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
2333 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2336 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance_id);
2340 -- Name: planets_nick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2343 CREATE INDEX planets_nick_index ON planets USING btree (nick);
2347 -- Name: raid_targets_modified_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2350 CREATE INDEX raid_targets_modified_index ON raid_targets USING btree (modified);
2354 -- Name: scans_parsed_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2357 CREATE INDEX scans_parsed_index ON scans USING btree (parsed);
2361 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
2364 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
2368 -- Name: users_hostmask_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2371 CREATE UNIQUE INDEX users_hostmask_index ON users USING btree (lower(hostmask));
2375 -- Name: users_pnick_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2378 CREATE UNIQUE INDEX users_pnick_index ON users USING btree (lower(pnick));
2382 -- Name: users_username_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
2385 CREATE UNIQUE INDEX users_username_index ON users USING btree (lower(username));
2389 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: -
2392 CREATE TRIGGER add_call
2393 BEFORE INSERT ON calls
2395 EXECUTE PROCEDURE add_call();
2399 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: -
2402 CREATE TRIGGER add_remove_member
2403 AFTER INSERT OR DELETE ON groupmembers
2405 EXECUTE PROCEDURE change_member();
2409 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: -
2412 CREATE TRIGGER add_user
2413 BEFORE INSERT ON users
2415 EXECUTE PROCEDURE add_user();
2419 -- Name: unclaim_target; Type: TRIGGER; Schema: public; Owner: -
2422 CREATE TRIGGER unclaim_target
2423 AFTER DELETE ON raid_claims
2425 EXECUTE PROCEDURE unclaim_target();
2429 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: -
2432 CREATE TRIGGER update_forum_post
2433 BEFORE INSERT OR UPDATE ON forum_posts
2435 EXECUTE PROCEDURE update_forum_post();
2439 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: -
2442 CREATE TRIGGER update_planet
2443 AFTER UPDATE ON users
2445 EXECUTE PROCEDURE update_user_planet();
2449 -- Name: update_target; Type: TRIGGER; Schema: public; Owner: -
2452 CREATE TRIGGER update_target
2453 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
2455 EXECUTE PROCEDURE updated_target();
2459 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2462 ALTER TABLE ONLY alliance_stats
2463 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (id) REFERENCES alliances(id);
2467 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2470 ALTER TABLE ONLY calls
2471 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
2475 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2478 ALTER TABLE ONLY calls
2479 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
2483 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2486 ALTER TABLE ONLY calls
2487 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (member) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2491 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2494 ALTER TABLE ONLY channel_group_flags
2495 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(id) ON UPDATE CASCADE ON DELETE CASCADE;
2499 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2502 ALTER TABLE ONLY channel_group_flags
2503 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(id) ON UPDATE CASCADE ON DELETE CASCADE;
2507 -- Name: channel_group_flags_group_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2510 ALTER TABLE ONLY channel_group_flags
2511 ADD CONSTRAINT channel_group_flags_group_fkey FOREIGN KEY ("group") REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2515 -- Name: covop_attacks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2518 ALTER TABLE ONLY covop_attacks
2519 ADD CONSTRAINT covop_attacks_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2523 -- Name: covop_attacks_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2526 ALTER TABLE ONLY covop_attacks
2527 ADD CONSTRAINT covop_attacks_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
2531 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2534 ALTER TABLE ONLY defense_missions
2535 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2539 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2542 ALTER TABLE ONLY defense_missions
2543 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2547 -- Name: defense_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2550 ALTER TABLE ONLY defense_requests
2551 ADD CONSTRAINT defense_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2555 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2558 ALTER TABLE ONLY fleet_scans
2559 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON DELETE CASCADE;
2563 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2566 ALTER TABLE ONLY fleet_scans
2567 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2571 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2574 ALTER TABLE ONLY fleet_ships
2575 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (id) REFERENCES fleets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2579 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2582 ALTER TABLE ONLY fleet_ships
2583 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(name);
2587 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2590 ALTER TABLE ONLY fleets
2591 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2595 -- Name: fleets_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2598 ALTER TABLE ONLY fleets
2599 ADD CONSTRAINT fleets_target_fkey FOREIGN KEY (target) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2603 -- Name: fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2606 ALTER TABLE ONLY fleets
2607 ADD CONSTRAINT fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2611 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2614 ALTER TABLE ONLY forum_access
2615 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2619 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2622 ALTER TABLE ONLY forum_access
2623 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2627 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2630 ALTER TABLE ONLY forum_boards
2631 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
2635 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2638 ALTER TABLE ONLY forum_posts
2639 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2643 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2646 ALTER TABLE ONLY forum_posts
2647 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2651 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2654 ALTER TABLE ONLY forum_thread_visits
2655 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
2659 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2662 ALTER TABLE ONLY forum_thread_visits
2663 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2667 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2670 ALTER TABLE ONLY forum_threads
2671 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
2675 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2678 ALTER TABLE ONLY forum_threads
2679 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
2683 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2686 ALTER TABLE ONLY groupmembers
2687 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2691 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2694 ALTER TABLE ONLY groupmembers
2695 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2699 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2702 ALTER TABLE ONLY incomings
2703 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(id) ON UPDATE CASCADE ON DELETE CASCADE;
2707 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2710 ALTER TABLE ONLY incomings
2711 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (sender) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2715 -- Name: planet_data_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2718 ALTER TABLE ONLY planet_data
2719 ADD CONSTRAINT planet_data_id_fkey FOREIGN KEY (id) REFERENCES planets(id);
2723 -- Name: planet_data_rid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2726 ALTER TABLE ONLY planet_data
2727 ADD CONSTRAINT planet_data_rid_fkey FOREIGN KEY (rid) REFERENCES planet_data_types(id);
2731 -- Name: planet_data_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2734 ALTER TABLE ONLY planet_data
2735 ADD CONSTRAINT planet_data_scan_fkey FOREIGN KEY (scan) REFERENCES scans(id);
2739 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2742 ALTER TABLE ONLY planet_stats
2743 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (id) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2747 -- Name: planets_alliance_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2750 ALTER TABLE ONLY planets
2751 ADD CONSTRAINT planets_alliance_id_fkey FOREIGN KEY (alliance_id) REFERENCES alliances(id) ON UPDATE SET NULL ON DELETE SET NULL;
2755 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2758 ALTER TABLE ONLY planets
2759 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2763 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2766 ALTER TABLE ONLY raid_access
2767 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
2771 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2774 ALTER TABLE ONLY raid_access
2775 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2779 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2782 ALTER TABLE ONLY raid_claims
2783 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2787 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2790 ALTER TABLE ONLY raid_claims
2791 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
2795 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2798 ALTER TABLE ONLY raid_targets
2799 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2803 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2806 ALTER TABLE ONLY raid_targets
2807 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
2811 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2814 ALTER TABLE ONLY scans
2815 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE CASCADE ON DELETE CASCADE;
2819 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2822 ALTER TABLE ONLY scans
2823 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
2827 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2830 ALTER TABLE ONLY users
2831 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (planet) REFERENCES planets(id) ON UPDATE SET NULL ON DELETE SET NULL;
2835 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2838 ALTER TABLE ONLY users
2839 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
2843 -- Name: public; Type: ACL; Schema: -; Owner: -
2846 REVOKE ALL ON SCHEMA public FROM PUBLIC;
2847 REVOKE ALL ON SCHEMA public FROM postgres;
2848 GRANT ALL ON SCHEMA public TO postgres;
2849 GRANT ALL ON SCHEMA public TO PUBLIC;
2853 -- PostgreSQL database dump complete