2 -- PostgreSQL database dump
5 -- Dumped from database version 9.5.1
6 -- Dumped by pg_dump version 9.5.1
8 SET statement_timeout = 0;
10 SET client_encoding = 'UTF8';
11 SET standard_conforming_strings = on;
12 SET check_function_bodies = false;
13 SET client_min_messages = warning;
14 SET row_security = off;
17 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
20 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
24 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
27 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
31 -- Name: citext; Type: EXTENSION; Schema: -; Owner:
34 CREATE EXTENSION IF NOT EXISTS citext WITH SCHEMA public;
38 -- Name: EXTENSION citext; Type: COMMENT; Schema: -; Owner:
41 COMMENT ON EXTENSION citext IS 'data type for case-insensitive character strings';
45 -- Name: pg_trgm; Type: EXTENSION; Schema: -; Owner:
48 CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public;
52 -- Name: EXTENSION pg_trgm; Type: COMMENT; Schema: -; Owner:
55 COMMENT ON EXTENSION pg_trgm IS 'text similarity measurement and index searching based on trigrams';
58 SET search_path = public, pg_catalog;
61 -- Name: ead_status; Type: TYPE; Schema: public; Owner: ndawn
64 CREATE TYPE ead_status AS ENUM (
72 ALTER TYPE ead_status OWNER TO ndawn;
75 -- Name: governments; Type: TYPE; Schema: public; Owner: ndawn
78 CREATE TYPE governments AS ENUM (
87 ALTER TYPE governments OWNER TO ndawn;
90 -- Name: race; Type: TYPE; Schema: public; Owner: ndawn
93 CREATE TYPE race AS ENUM (
102 ALTER TYPE race OWNER TO ndawn;
105 -- Name: add_call(); Type: FUNCTION; Schema: public; Owner: ndawn
108 CREATE FUNCTION add_call() RETURNS trigger
114 INSERT INTO forum_threads (fbid,subject,uid)
115 VALUES(-3,NEW.uid || ': ' || NEW.landing_tick,-3) RETURNING ftid
123 ALTER FUNCTION public.add_call() OWNER TO ndawn;
126 -- Name: add_raid(); Type: FUNCTION; Schema: public; Owner: ndawn
129 CREATE FUNCTION add_raid() RETURNS trigger
135 INSERT INTO forum_threads (ftid,fbid,subject,uid) VALUES
136 (DEFAULT,-5,'Raid ' || NEW.id,-3) RETURNING ftid INTO rec;
137 NEW.ftid := rec.ftid;
143 ALTER FUNCTION public.add_raid() OWNER TO ndawn;
146 -- Name: add_user(); Type: FUNCTION; Schema: public; Owner: ndawn
149 CREATE FUNCTION add_user() RETURNS trigger
155 INSERT INTO forum_threads (fbid,subject,uid)
156 VALUES(-1,NEW.uid || ': ' || NEW.username,-3) RETURNING ftid
164 ALTER FUNCTION public.add_user() OWNER TO ndawn;
167 -- Name: change_member(); Type: FUNCTION; Schema: public; Owner: ndawn
170 CREATE FUNCTION change_member() RETURNS trigger
174 IF TG_OP = 'INSERT' THEN
175 IF NEW.gid = 'M' THEN
176 UPDATE planets SET alliance = 'NewDawn' WHERE
177 pid = (SELECT pid FROM users WHERE uid = NEW.uid);
179 ELSIF TG_OP = 'DELETE' THEN
180 IF OLD.gid = 'M' THEN
181 UPDATE planets SET alliance = NULL WHERE
182 pid = (SELECT pid FROM users WHERE uid = OLD.uid);
191 ALTER FUNCTION public.change_member() OWNER TO ndawn;
194 -- Name: coords(integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
197 CREATE FUNCTION coords(x integer, y integer, z integer) RETURNS text
198 LANGUAGE sql IMMUTABLE
200 SELECT $1 || ':' || $2 || ':' || $3
204 ALTER FUNCTION public.coords(x integer, y integer, z integer) OWNER TO ndawn;
207 -- Name: covop_alert(integer, integer, integer, integer, governments, integer); Type: FUNCTION; Schema: public; Owner: ndawn
210 CREATE FUNCTION covop_alert(secs integer, strucs integer, roids integer, guards integer, gov governments, population integer) RETURNS integer
211 LANGUAGE sql IMMUTABLE
213 SELECT ((50 + COALESCE($4*5.0/($3+1.0),$6))
214 * (1.0+2*LEAST(COALESCE($1::float/CASE $2
215 WHEN 0 THEN 1 ELSE $2 END,$6),0.30)
218 WHEN 'Feu' THEN -0.20
219 WHEN 'Uni' THEN -0.10
226 ALTER FUNCTION public.covop_alert(secs integer, strucs integer, roids integer, guards integer, gov governments, population integer) OWNER TO ndawn;
229 -- Name: endtick(); Type: FUNCTION; Schema: public; Owner: ndawn
232 CREATE FUNCTION endtick() RETURNS integer
233 LANGUAGE sql STABLE SECURITY DEFINER
234 AS $$SELECT value::integer FROM misc WHERE id = 'ENDTICK'$$;
237 ALTER FUNCTION public.endtick() OWNER TO ndawn;
240 -- Name: find_alliance_id(text); Type: FUNCTION; Schema: public; Owner: ndawn
243 CREATE FUNCTION find_alliance_id(alli text) RETURNS integer
249 SELECT aid FROM INTO id alliances WHERE alliance = alli;
251 INSERT INTO alliances(alliance) VALUES($1)
252 RETURNING aid INTO id;
259 ALTER FUNCTION public.find_alliance_id(alli text) OWNER TO ndawn;
262 -- Name: find_planet_id(text, text, race); Type: FUNCTION; Schema: public; Owner: ndawn
265 CREATE FUNCTION find_planet_id(_ruler text, _planet text, _race race) RETURNS integer
273 SELECT pid, race INTO p FROM planets WHERE ruler = _ruler AND planet = _planet;
275 IF _race <> p.race THEN
276 UPDATE planets SET race = _race WHERE pid = p.pid;
280 INSERT INTO forum_threads (fbid,subject,uid) VALUES(-2, _ruler || ' OF ' || _planet, -3)
281 RETURNING ftid INTO thread;
282 INSERT INTO planets(ruler,planet,race,ftid) VALUES(_ruler,_planet,_race,thread)
283 RETURNING pid INTO id;
290 ALTER FUNCTION public.find_planet_id(_ruler text, _planet text, _race race) OWNER TO ndawn;
293 -- Name: groups(integer); Type: FUNCTION; Schema: public; Owner: ndawn
296 CREATE FUNCTION groups(uid integer) RETURNS SETOF character
298 AS $_$SELECT gid FROM groupmembers WHERE uid = $1 UNION SELECT ''$_$;
301 ALTER FUNCTION public.groups(uid integer) OWNER TO ndawn;
304 -- Name: max_bank_hack(bigint, bigint, bigint, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
307 CREATE FUNCTION max_bank_hack(metal bigint, crystal bigint, eonium bigint, tvalue integer, value integer, agents integer) RETURNS integer
308 LANGUAGE sql IMMUTABLE
310 SELECT LEAST(2000.0*$6*$4/$5, $1*0.10, $6*10000.0)::integer
311 + LEAST(2000.0*$6*$4/$5, $2*0.10, $6*10000.0)::integer
312 + LEAST(2000.0*$6*$4/$5, $3*0.10, $6*10000.0)::integer
316 ALTER FUNCTION public.max_bank_hack(metal bigint, crystal bigint, eonium bigint, tvalue integer, value integer, agents integer) OWNER TO ndawn;
319 -- Name: mmdd(date); Type: FUNCTION; Schema: public; Owner: ndawn
322 CREATE FUNCTION mmdd(d date) RETURNS text
323 LANGUAGE sql IMMUTABLE
324 AS $_$ SELECT to_char($1,'MM-DD') $_$;
327 ALTER FUNCTION public.mmdd(d date) OWNER TO ndawn;
330 -- Name: old_claim(timestamp with time zone); Type: FUNCTION; Schema: public; Owner: ndawn
333 CREATE FUNCTION old_claim("timestamp" timestamp with time zone) RETURNS boolean
334 LANGUAGE sql IMMUTABLE
335 AS $_$SELECT NOW() - '10 minutes'::INTERVAL > $1;$_$;
338 ALTER FUNCTION public.old_claim("timestamp" timestamp with time zone) OWNER TO ndawn;
341 -- Name: planetcoords(integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
344 CREATE FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) RETURNS record
346 AS $_$SELECT x,y,z FROM planet_stats WHERE pid = $1 AND (tick >= $2 OR tick =( SELECT max(tick) FROM planet_stats)) ORDER BY tick ASC LIMIT 1$_$;
349 ALTER FUNCTION public.planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) OWNER TO ndawn;
352 -- Name: planetid(integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: ndawn
355 CREATE FUNCTION planetid(x integer, y integer, z integer, tick integer) RETURNS integer
357 AS $_$SELECT pid 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$_$;
360 ALTER FUNCTION public.planetid(x integer, y integer, z integer, tick integer) OWNER TO ndawn;
363 -- Name: tick(); Type: FUNCTION; Schema: public; Owner: ndawn
366 CREATE FUNCTION tick() RETURNS integer
367 LANGUAGE sql STABLE SECURITY DEFINER
368 AS $$SELECT value::integer FROM misc WHERE id = 'TICK'$$;
371 ALTER FUNCTION public.tick() OWNER TO ndawn;
374 -- Name: unread_posts(integer); Type: FUNCTION; Schema: public; Owner: ndawn
377 CREATE FUNCTION unread_posts(uid integer, OUT unread integer, OUT new integer) RETURNS record
380 SELECT count(*)::int AS unread
381 ,count(NULLIF(fp.time > (SELECT max(time) FROM forum_thread_visits WHERE uid = $1),FALSE))::int AS new
383 SELECT ftid, ftv.time
384 FROM forum_threads ft
385 LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
387 WHERE COALESCE(ft.mtime > ftv.time,TRUE)
389 fbid IN (SELECT fbid FROM forum_access WHERE gid IN (SELECT groups($1)))
390 ) OR ft.ftid IN (SELECT ftid FROM forum_priv_access WHERE uid = $1)
393 JOIN forum_posts fp USING (ftid)
394 WHERE COALESCE(fp.time > ft.time, TRUE)
398 ALTER FUNCTION public.unread_posts(uid integer, OUT unread integer, OUT new integer) OWNER TO ndawn;
401 -- Name: update_forum_post(); Type: FUNCTION; Schema: public; Owner: ndawn
404 CREATE FUNCTION update_forum_post() RETURNS trigger
410 SELECT setweight(to_tsvector(coalesce(ft.subject,'')), 'A')
411 || setweight(to_tsvector(coalesce(u.username,'')), 'B') AS ts
413 FROM forum_threads ft, users u
414 WHERE NEW.ftid = ft.ftid AND u.uid = NEW.uid;
415 NEW.textsearch := rec.ts
416 || setweight(to_tsvector(coalesce(NEW.message,'')), 'D');
422 ALTER FUNCTION public.update_forum_post() OWNER TO ndawn;
425 -- Name: update_forum_thread_posts(); Type: FUNCTION; Schema: public; Owner: ndawn
428 CREATE FUNCTION update_forum_thread_posts() RETURNS trigger
433 IF TG_OP = 'INSERT' THEN
434 UPDATE forum_threads SET posts = posts + 1, mtime = GREATEST(NEW.time,mtime)
435 WHERE ftid = NEW.ftid;
436 ELSIF TG_OP = 'DELETE' THEN
437 UPDATE forum_threads SET posts = posts - 1 WHERE ftid = OLD.ftid;
438 ELSIF TG_OP = 'UPDATE' AND NEW.ftid <> OLD.ftid THEN
439 UPDATE forum_threads SET posts = posts - 1 WHERE ftid = OLD.ftid;
440 UPDATE forum_threads SET posts = posts + 1, mtime = GREATEST(NEW.time,mtime)
441 WHERE ftid = NEW.ftid;
449 ALTER FUNCTION public.update_forum_thread_posts() OWNER TO ndawn;
452 -- Name: update_user_planet(); Type: FUNCTION; Schema: public; Owner: ndawn
455 CREATE FUNCTION update_user_planet() RETURNS trigger
459 IF COALESCE(NEW.pid <> OLD.pid,TRUE) OR NEW.username <> OLD.username THEN
460 UPDATE planets SET nick = NULL WHERE pid = OLD.pid;
461 UPDATE planets SET nick = NEW.username WHERE pid = NEW.pid;
464 IF COALESCE(NEW.pid <> OLD.pid,TRUE)
465 AND (SELECT TRUE FROM groupmembers WHERE gid = 'M' AND uid = NEW.uid) THEN
466 UPDATE planets SET alliance = NULL WHERE pid = OLD.pid;
467 UPDATE planets SET alliance = 'NewDawn' WHERE pid = NEW.pid;
474 ALTER FUNCTION public.update_user_planet() OWNER TO ndawn;
477 -- Name: update_wiki_page(); Type: FUNCTION; Schema: public; Owner: ndawn
480 CREATE FUNCTION update_wiki_page() RETURNS trigger
486 SELECT setweight(to_tsvector(wpr.text), 'D') AS ts
488 FROM wiki_page_revisions wpr
489 WHERE NEW.wprev = wpr.wprev;
490 NEW.textsearch := rec.ts
491 || setweight(to_tsvector(NEW.namespace || ':' || NEW.name), 'A');
498 ALTER FUNCTION public.update_wiki_page() OWNER TO ndawn;
501 -- Name: updated_claim(); Type: FUNCTION; Schema: public; Owner: ndawn
504 CREATE FUNCTION updated_claim() RETURNS trigger
512 target := NEW.target;
514 target := NEW.target;
515 IF NEW.launched AND NOT OLD.launched THEN
517 SET attack_points = attack_points + 1
520 INSERT INTO forum_posts (ftid,uid,message)
521 VALUES((SELECT ftid FROM users WHERE uid = NEW.uid),NEW.uid
522 ,'Gave attack point for confirmation of attack on target '
523 || NEW.target || ', wave ' || NEW.wave
527 target := OLD.target;
531 SET attack_points = attack_points - 1
535 UPDATE raid_targets SET modified = NOW() WHERE id = target;
541 ALTER FUNCTION public.updated_claim() OWNER TO ndawn;
544 -- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: ndawn
547 CREATE AGGREGATE concat(text) (
554 ALTER AGGREGATE public.concat(text) OWNER TO ndawn;
556 SET default_tablespace = '';
558 SET default_with_oids = false;
561 -- Name: alliance_stats; Type: TABLE; Schema: public; Owner: ndawn
564 CREATE TABLE alliance_stats (
565 aid integer NOT NULL,
566 tick integer NOT NULL,
567 size integer NOT NULL,
568 members integer NOT NULL,
569 score integer NOT NULL,
570 sizerank integer NOT NULL,
571 scorerank integer NOT NULL,
572 size_gain integer NOT NULL,
573 score_gain integer NOT NULL,
574 sizerank_gain integer NOT NULL,
575 scorerank_gain integer NOT NULL,
576 size_gain_day integer NOT NULL,
577 score_gain_day integer NOT NULL,
578 sizerank_gain_day integer NOT NULL,
579 scorerank_gain_day integer NOT NULL,
580 members_gain integer NOT NULL,
581 members_gain_day integer NOT NULL
585 ALTER TABLE alliance_stats OWNER TO ndawn;
588 -- Name: alliances; Type: TABLE; Schema: public; Owner: ndawn
591 CREATE TABLE alliances (
592 aid integer NOT NULL,
593 alliance text NOT NULL,
594 relationship ead_status DEFAULT ''::ead_status NOT NULL
598 ALTER TABLE alliances OWNER TO ndawn;
601 -- Name: development_scans; Type: TABLE; Schema: public; Owner: ndawn
604 CREATE TABLE development_scans (
606 pid integer NOT NULL,
607 tick integer NOT NULL,
608 light_fac integer NOT NULL,
609 medium_fac integer NOT NULL,
610 heavy_fac integer NOT NULL,
611 amps integer NOT NULL,
612 distorters integer NOT NULL,
613 metal_ref integer NOT NULL,
614 crystal_ref integer NOT NULL,
615 eonium_ref integer NOT NULL,
616 reslabs integer NOT NULL,
617 fincents integer NOT NULL,
618 seccents integer NOT NULL,
619 total integer NOT NULL,
620 travel integer NOT NULL,
621 infra integer NOT NULL,
622 hulls integer NOT NULL,
623 waves integer NOT NULL,
624 extraction integer NOT NULL,
625 covert integer NOT NULL,
626 mining integer NOT NULL,
627 milcents integer NOT NULL,
628 structdefs integer NOT NULL
632 ALTER TABLE development_scans OWNER TO ndawn;
635 -- Name: current_development_scans; Type: VIEW; Schema: public; Owner: ndawn
638 CREATE VIEW current_development_scans AS
639 SELECT DISTINCT ON (ds.pid) ds.id,
661 FROM development_scans ds
662 ORDER BY ds.pid, ds.tick DESC, ds.id DESC;
665 ALTER TABLE current_development_scans OWNER TO ndawn;
668 -- Name: planet_scans; Type: TABLE; Schema: public; Owner: ndawn
671 CREATE TABLE planet_scans (
673 pid integer NOT NULL,
674 tick integer NOT NULL,
675 metal bigint NOT NULL,
676 crystal bigint NOT NULL,
677 eonium bigint NOT NULL,
678 hidden bigint NOT NULL,
679 metal_roids integer NOT NULL,
680 crystal_roids integer NOT NULL,
681 eonium_roids integer NOT NULL,
682 agents integer NOT NULL,
683 guards integer NOT NULL,
685 medium text NOT NULL,
690 ALTER TABLE planet_scans OWNER TO ndawn;
693 -- Name: current_planet_scans; Type: VIEW; Schema: public; Owner: ndawn
696 CREATE VIEW current_planet_scans AS
697 SELECT DISTINCT ON (ps.pid) ps.id,
713 ORDER BY ps.pid, ps.tick DESC, ps.id DESC;
716 ALTER TABLE current_planet_scans OWNER TO ndawn;
719 -- Name: planet_stats; Type: TABLE; Schema: public; Owner: ndawn
722 CREATE TABLE planet_stats (
723 pid integer NOT NULL,
724 tick integer NOT NULL,
728 size integer NOT NULL,
729 score integer NOT NULL,
730 value integer NOT NULL,
732 sizerank integer NOT NULL,
733 scorerank integer NOT NULL,
734 valuerank integer NOT NULL,
735 xprank integer NOT NULL,
736 size_gain integer NOT NULL,
737 score_gain integer NOT NULL,
738 value_gain integer NOT NULL,
739 xp_gain integer NOT NULL,
740 sizerank_gain integer NOT NULL,
741 scorerank_gain integer NOT NULL,
742 valuerank_gain integer NOT NULL,
743 xprank_gain integer NOT NULL,
744 size_gain_day integer NOT NULL,
745 score_gain_day integer NOT NULL,
746 value_gain_day integer NOT NULL,
747 xp_gain_day integer NOT NULL,
748 sizerank_gain_day integer NOT NULL,
749 scorerank_gain_day integer NOT NULL,
750 valuerank_gain_day integer NOT NULL,
751 xprank_gain_day integer NOT NULL
755 ALTER TABLE planet_stats OWNER TO ndawn;
758 -- Name: planets; Type: TABLE; Schema: public; Owner: ndawn
761 CREATE TABLE planets (
762 pid integer NOT NULL,
764 planet text NOT NULL,
767 planet_status ead_status DEFAULT ''::ead_status NOT NULL,
768 hit_us integer DEFAULT 0 NOT NULL,
771 ftid integer NOT NULL,
772 gov governments DEFAULT ''::governments NOT NULL
774 WITH (fillfactor='50');
777 ALTER TABLE planets OWNER TO ndawn;
780 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: ndawn
783 CREATE VIEW current_planet_stats AS
808 FROM ((( SELECT planet_stats.pid,
817 planet_stats.sizerank,
818 planet_stats.scorerank,
819 planet_stats.valuerank,
822 WHERE (planet_stats.tick = ( SELECT max(planet_stats_1.tick) AS max
823 FROM planet_stats planet_stats_1))) ps
824 JOIN planets p USING (pid))
825 LEFT JOIN alliances a USING (alliance));
828 ALTER TABLE current_planet_stats OWNER TO ndawn;
831 -- Name: alliance_resources; Type: VIEW; Schema: public; Owner: ndawn
834 CREATE VIEW alliance_resources AS
835 WITH planet_estimates AS (
841 ((ps.metal + ps.crystal) + ps.eonium) AS resources,
842 ((p.score + (((ps.metal + ps.crystal) + ps.eonium) / 300)) + (ps.hidden / 100)) AS nscore2,
843 ((((p.score + (((ps.metal + ps.crystal) + ps.eonium) / 300)) + (ps.hidden / 100)))::numeric + (((((endtick() - tick()) * (((250 * p.size) + (COALESCE(((ds.metal_ref + ds.crystal_ref) + ds.eonium_ref), 7) * 1000)) +
847 ELSE ((COALESCE(ds.extraction, 3) * 3000) * 3)
848 END)))::numeric * (1.35 + (0.005 * (COALESCE(ds.fincents, 20))::numeric))) / (100)::numeric)) AS nscore3
849 FROM ((current_planet_stats p
850 JOIN current_planet_scans ps USING (pid))
851 LEFT JOIN current_development_scans ds USING (pid))
853 SELECT planet_estimates.tick,
854 planet_estimates.alliance,
855 planet_estimates.hidden,
856 planet_estimates.size,
857 planet_estimates.score,
858 planet_estimates.resources,
859 planet_estimates.nscore2,
860 planet_estimates.nscore3,
861 rank() OVER (PARTITION BY planet_estimates.alliance ORDER BY planet_estimates.score DESC) AS rank
862 FROM planet_estimates
864 SELECT planet_ranks.alliance,
865 sum(planet_ranks.resources) AS resources,
866 sum(planet_ranks.hidden) AS hidden,
867 (sum(planet_ranks.nscore2))::bigint AS nscore2,
868 (sum(planet_ranks.nscore3))::bigint AS nscore3,
870 sum(planet_ranks.score) AS score,
871 sum(planet_ranks.size) AS size,
872 (avg(planet_ranks.tick))::integer AS avgtick
874 WHERE (planet_ranks.rank <= 60)
875 GROUP BY planet_ranks.alliance
888 ((((s.score)::numeric + (r.resources / (300)::numeric)) + (r.hidden / (100)::numeric)))::bigint AS nscore,
893 JOIN top_planets r USING (alliance))
894 LEFT JOIN ( SELECT alliance_stats.aid,
895 alliance_stats.score,
897 alliance_stats.members
899 WHERE (alliance_stats.tick = ( SELECT max(alliance_stats_1.tick) AS max
900 FROM alliance_stats alliance_stats_1))) s USING (aid));
903 ALTER TABLE alliance_resources OWNER TO ndawn;
906 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
909 CREATE SEQUENCE alliances_id_seq
917 ALTER TABLE alliances_id_seq OWNER TO ndawn;
920 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
923 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.aid;
927 -- Name: available_planet_tags; Type: TABLE; Schema: public; Owner: ndawn
930 CREATE TABLE available_planet_tags (
935 ALTER TABLE available_planet_tags OWNER TO ndawn;
938 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: ndawn
941 CREATE TABLE fleet_ships (
942 fid integer NOT NULL,
944 amount integer NOT NULL,
949 ALTER TABLE fleet_ships OWNER TO ndawn;
952 -- Name: fleets; Type: TABLE; Schema: public; Owner: ndawn
955 CREATE TABLE fleets (
956 mission text NOT NULL,
957 tick integer NOT NULL,
958 fid integer NOT NULL,
959 pid integer NOT NULL,
960 amount integer NOT NULL,
965 ALTER TABLE fleets OWNER TO ndawn;
968 -- Name: launch_confirmations; Type: TABLE; Schema: public; Owner: ndawn
971 CREATE TABLE launch_confirmations (
972 fid integer NOT NULL,
973 uid integer NOT NULL,
974 pid integer NOT NULL,
975 landing_tick integer NOT NULL,
976 eta integer NOT NULL,
977 back integer NOT NULL,
980 WITH (fillfactor='75');
983 ALTER TABLE launch_confirmations OWNER TO ndawn;
986 -- Name: ticks; Type: TABLE; Schema: public; Owner: ndawn
994 ALTER TABLE ticks OWNER TO ndawn;
997 -- Name: users; Type: TABLE; Schema: public; Owner: ndawn
1000 CREATE TABLE users (
1001 uid integer NOT NULL,
1002 username citext NOT NULL,
1004 password text NOT NULL,
1005 attack_points numeric(3,0) DEFAULT 0 NOT NULL,
1006 defense_points numeric(4,1) DEFAULT 0 NOT NULL,
1007 scan_points numeric(5,0) DEFAULT 0 NOT NULL,
1008 humor_points numeric(3,0) DEFAULT 0 NOT NULL,
1009 hostmask citext NOT NULL,
1012 laston timestamp with time zone,
1013 ftid integer NOT NULL,
1016 pnick citext NOT NULL,
1019 timezone text DEFAULT 'GMT'::text NOT NULL,
1020 call_if_needed boolean DEFAULT false NOT NULL,
1021 sms_note text DEFAULT ''::text NOT NULL
1023 WITH (fillfactor='50');
1026 ALTER TABLE users OWNER TO ndawn;
1029 -- Name: ships_home; Type: VIEW; Schema: public; Owner: ndawn
1032 CREATE VIEW ships_home AS
1038 COALESCE((f.amount - o.amount), (f.amount)::bigint) AS amount,
1039 COALESCE(o.fleets, (3)::bigint) AS fleets
1041 JOIN ( SELECT f_1.t AS tick,
1045 FROM (( SELECT DISTINCT ON (ticks.t, f_2.pid, f_2.mission) ticks.t,
1050 CROSS JOIN fleets f_2)
1051 WHERE ((f_2.tick <= ticks.t) AND (f_2.name = ANY (ARRAY['Main'::text, 'Advanced Unit'::text])) AND (f_2.mission = 'Full fleet'::text))
1052 ORDER BY ticks.t, f_2.pid, f_2.mission, f_2.tick DESC, f_2.fid DESC) f_1
1053 JOIN fleet_ships fs USING (fid))) f USING (pid))
1054 LEFT JOIN ( SELECT ticks.t AS tick,
1057 sum(fs.amount) AS amount,
1058 (3 - count(DISTINCT f_1.fid)) AS fleets
1060 CROSS JOIN fleets f_1)
1061 JOIN ( SELECT launch_confirmations.landing_tick,
1062 launch_confirmations.fid,
1063 launch_confirmations.back,
1064 launch_confirmations.eta
1065 FROM launch_confirmations) lc USING (fid))
1066 JOIN fleet_ships fs USING (fid))
1067 WHERE ((lc.back > ticks.t) AND (((lc.landing_tick - lc.eta) - 12) < ticks.t))
1068 GROUP BY ticks.t, f_1.pid, fs.ship) o USING (tick, pid, ship))
1069 WHERE (COALESCE((f.amount - o.amount), (f.amount)::bigint) > 0);
1072 ALTER TABLE ships_home OWNER TO ndawn;
1075 -- Name: available_ships; Type: VIEW; Schema: public; Owner: ndawn
1078 CREATE VIEW available_ships AS
1079 SELECT ships_home.uid,
1080 ships_home.username,
1086 WHERE (ships_home.tick = tick());
1089 ALTER TABLE available_ships OWNER TO ndawn;
1092 -- Name: call_statuses; Type: TABLE; Schema: public; Owner: ndawn
1095 CREATE TABLE call_statuses (
1096 status text NOT NULL
1100 ALTER TABLE call_statuses OWNER TO ndawn;
1103 -- Name: calls; Type: TABLE; Schema: public; Owner: ndawn
1106 CREATE TABLE calls (
1107 call integer NOT NULL,
1108 uid integer NOT NULL,
1110 landing_tick integer NOT NULL,
1112 ftid integer NOT NULL,
1113 calc text DEFAULT ''::text NOT NULL,
1114 status text DEFAULT 'Open'::text NOT NULL
1118 ALTER TABLE calls OWNER TO ndawn;
1121 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1124 CREATE SEQUENCE calls_id_seq
1132 ALTER TABLE calls_id_seq OWNER TO ndawn;
1135 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1138 ALTER SEQUENCE calls_id_seq OWNED BY calls.call;
1142 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: ndawn
1145 CREATE TABLE channel_flags (
1147 flag character(1) NOT NULL
1151 ALTER TABLE channel_flags OWNER TO ndawn;
1154 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: ndawn
1157 CREATE TABLE channel_group_flags (
1158 channel citext NOT NULL,
1159 gid character(1) NOT NULL,
1160 flag character(1) NOT NULL
1164 ALTER TABLE channel_group_flags OWNER TO ndawn;
1167 -- Name: channels; Type: TABLE; Schema: public; Owner: ndawn
1170 CREATE TABLE channels (
1171 channel citext NOT NULL,
1172 description text NOT NULL
1176 ALTER TABLE channels OWNER TO ndawn;
1179 -- Name: clickatell; Type: TABLE; Schema: public; Owner: ndawn
1182 CREATE TABLE clickatell (
1183 api_id text NOT NULL,
1184 username text NOT NULL,
1185 password text NOT NULL
1189 ALTER TABLE clickatell OWNER TO ndawn;
1192 -- Name: covop_attacks; Type: TABLE; Schema: public; Owner: ndawn
1195 CREATE TABLE covop_attacks (
1196 uid integer NOT NULL,
1197 tick integer NOT NULL,
1198 pid integer NOT NULL
1202 ALTER TABLE covop_attacks OWNER TO ndawn;
1205 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: ndawn
1208 CREATE VIEW current_planet_stats_full AS
1244 ps.sizerank_gain_day,
1245 ps.scorerank_gain_day,
1246 ps.valuerank_gain_day,
1249 alliances.relationship
1251 JOIN ( SELECT planet_stats.pid,
1260 planet_stats.sizerank,
1261 planet_stats.scorerank,
1262 planet_stats.valuerank,
1263 planet_stats.xprank,
1264 planet_stats.size_gain,
1265 planet_stats.score_gain,
1266 planet_stats.value_gain,
1267 planet_stats.xp_gain,
1268 planet_stats.sizerank_gain,
1269 planet_stats.scorerank_gain,
1270 planet_stats.valuerank_gain,
1271 planet_stats.xprank_gain,
1272 planet_stats.size_gain_day,
1273 planet_stats.score_gain_day,
1274 planet_stats.value_gain_day,
1275 planet_stats.xp_gain_day,
1276 planet_stats.sizerank_gain_day,
1277 planet_stats.scorerank_gain_day,
1278 planet_stats.valuerank_gain_day,
1279 planet_stats.xprank_gain_day
1281 WHERE (planet_stats.tick = ( SELECT max(planet_stats_1.tick) AS max
1282 FROM planet_stats planet_stats_1))) ps USING (pid))
1283 LEFT JOIN alliances USING (alliance));
1286 ALTER TABLE current_planet_stats_full OWNER TO ndawn;
1289 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: ndawn
1292 CREATE TABLE ship_stats (
1294 class text NOT NULL,
1297 init integer NOT NULL,
1298 armor integer NOT NULL,
1299 damage integer NOT NULL,
1300 metal integer NOT NULL,
1301 crystal integer NOT NULL,
1302 eonium integer NOT NULL,
1304 guns integer DEFAULT 0 NOT NULL,
1305 eres integer DEFAULT 0 NOT NULL,
1312 ALTER TABLE ship_stats OWNER TO ndawn;
1315 -- Name: def_leeches; Type: VIEW; Schema: public; Owner: ndawn
1318 CREATE VIEW def_leeches AS
1327 sum((((fs.amount * ((s.metal + s.crystal) + s.eonium)))::numeric / 100.0)) AS value
1328 FROM (((launch_confirmations lc
1329 JOIN fleets f USING (fid))
1330 JOIN fleet_ships fs USING (fid))
1331 JOIN ship_stats s ON ((fs.ship = s.ship)))
1332 WHERE (f.mission = 'Defend'::text)
1333 GROUP BY lc.uid, lc.fid, lc.pid, f.pid, lc.landing_tick, lc.eta, lc.back
1336 sum((f.value / (COALESCE(p.value, ( SELECT planet_stats.value
1338 WHERE ((planet_stats.pid = f.fpid) AND (planet_stats.tick = (c.landing_tick - f.eta)))
1339 ORDER BY planet_stats.tick DESC
1340 LIMIT 1)))::numeric)) AS sent_value
1342 JOIN users u USING (uid))
1343 JOIN f USING (pid, landing_tick))
1344 LEFT JOIN ( SELECT planet_stats.pid AS fpid,
1346 planet_stats.tick AS landing_tick
1347 FROM planet_stats) p USING (fpid, landing_tick))
1353 count(d.call) AS calls,
1354 sum(d.fleets) AS fleets,
1355 sum(d.recalled) AS recalled,
1356 count(NULLIF(d.fleets, 0)) AS defended_calls,
1357 (sum(d.value))::numeric(4,2) AS value,
1358 (f2.sent_value)::numeric(4,2) AS sent_value
1359 FROM (( SELECT u.uid,
1363 count(f.back) AS fleets,
1364 count(NULLIF((((f.landing_tick + f.eta) - 1) = f.back), true)) AS recalled,
1365 sum((f.value / (COALESCE(p.value, ( SELECT planet_stats.value
1367 WHERE ((planet_stats.pid = f.pid) AND (planet_stats.tick = (c.landing_tick - f.eta)))
1368 ORDER BY planet_stats.tick DESC
1369 LIMIT 1)))::numeric)) AS value
1371 JOIN calls c USING (uid))
1372 LEFT JOIN f USING (pid, landing_tick))
1373 LEFT JOIN ( SELECT planet_stats.pid,
1375 planet_stats.tick AS landing_tick
1376 FROM planet_stats) p USING (pid, landing_tick))
1377 GROUP BY u.uid, u.username, u.defense_points, c.call) d
1378 LEFT JOIN f2 USING (uid))
1379 GROUP BY d.uid, d.username, d.defense_points, f2.sent_value;
1382 ALTER TABLE def_leeches OWNER TO ndawn;
1385 -- Name: incomings; Type: TABLE; Schema: public; Owner: ndawn
1388 CREATE TABLE incomings (
1389 call integer NOT NULL,
1390 pid integer NOT NULL,
1391 eta integer NOT NULL,
1392 amount integer NOT NULL,
1393 fleet text NOT NULL,
1394 shiptype text DEFAULT '?'::text NOT NULL,
1395 inc integer NOT NULL
1399 ALTER TABLE incomings OWNER TO ndawn;
1402 -- Name: defcalls; Type: VIEW; Schema: public; Owner: ndawn
1405 CREATE VIEW defcalls AS
1411 (c.landing_tick - tick()) AS curreta,
1412 array_agg(COALESCE((p2.race)::text, ''::text)) AS race,
1413 array_agg(COALESCE(i.amount, 0)) AS amount,
1414 array_agg(COALESCE(i.eta, 0)) AS eta,
1415 array_agg(COALESCE(i.shiptype, ''::text)) AS shiptype,
1416 array_agg(COALESCE(p2.alliance, '?'::text)) AS alliance,
1417 array_agg(coords(p2.x, p2.y, p2.z)) AS attackers
1419 LEFT JOIN incomings i USING (call))
1420 LEFT JOIN current_planet_stats p2 USING (pid))
1421 LEFT JOIN users dc ON ((c.dc = dc.uid)))
1422 GROUP BY c.call, c.uid, dc.username, c.landing_tick, c.status;
1425 ALTER TABLE defcalls OWNER TO ndawn;
1428 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: ndawn
1431 CREATE TABLE defense_missions (
1432 call integer NOT NULL,
1433 fleet integer NOT NULL,
1434 announced boolean DEFAULT false NOT NULL,
1435 pointed boolean DEFAULT false NOT NULL
1439 ALTER TABLE defense_missions OWNER TO ndawn;
1442 -- Name: dumps; Type: TABLE; Schema: public; Owner: ndawn
1445 CREATE TABLE dumps (
1446 tick integer NOT NULL,
1449 modified integer DEFAULT 0 NOT NULL
1453 ALTER TABLE dumps OWNER TO ndawn;
1456 -- Name: email_change; Type: TABLE; Schema: public; Owner: ndawn
1459 CREATE TABLE email_change (
1460 id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
1461 uid integer NOT NULL,
1462 email text NOT NULL,
1463 confirmed boolean DEFAULT false NOT NULL
1467 ALTER TABLE email_change OWNER TO ndawn;
1470 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: ndawn
1473 CREATE TABLE fleet_scans (
1474 fid integer NOT NULL,
1479 ALTER TABLE fleet_scans OWNER TO ndawn;
1482 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1485 CREATE SEQUENCE fleet_ships_num_seq
1493 ALTER TABLE fleet_ships_num_seq OWNER TO ndawn;
1496 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1499 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1503 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1506 CREATE SEQUENCE fleets_id_seq
1514 ALTER TABLE fleets_id_seq OWNER TO ndawn;
1517 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1520 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.fid;
1524 -- Name: forum_access; Type: TABLE; Schema: public; Owner: ndawn
1527 CREATE TABLE forum_access (
1528 fbid integer NOT NULL,
1529 gid character(1) NOT NULL,
1530 post boolean DEFAULT false NOT NULL,
1531 moderate boolean DEFAULT false NOT NULL
1535 ALTER TABLE forum_access OWNER TO ndawn;
1538 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: ndawn
1541 CREATE TABLE forum_boards (
1542 fbid integer NOT NULL,
1543 fcid integer NOT NULL,
1548 ALTER TABLE forum_boards OWNER TO ndawn;
1551 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1554 CREATE SEQUENCE forum_boards_fbid_seq
1562 ALTER TABLE forum_boards_fbid_seq OWNER TO ndawn;
1565 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1568 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1572 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: ndawn
1575 CREATE TABLE forum_categories (
1576 fcid integer NOT NULL,
1577 category text NOT NULL
1581 ALTER TABLE forum_categories OWNER TO ndawn;
1584 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1587 CREATE SEQUENCE forum_categories_fcid_seq
1595 ALTER TABLE forum_categories_fcid_seq OWNER TO ndawn;
1598 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1601 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1605 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: ndawn
1608 CREATE TABLE forum_posts (
1609 fpid integer NOT NULL,
1610 ftid integer NOT NULL,
1611 message text NOT NULL,
1612 "time" timestamp with time zone DEFAULT now() NOT NULL,
1613 uid integer NOT NULL,
1614 textsearch tsvector NOT NULL
1618 ALTER TABLE forum_posts OWNER TO ndawn;
1621 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1624 CREATE SEQUENCE forum_posts_fpid_seq
1632 ALTER TABLE forum_posts_fpid_seq OWNER TO ndawn;
1635 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1638 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1642 -- Name: forum_priv_access; Type: TABLE; Schema: public; Owner: ndawn
1645 CREATE TABLE forum_priv_access (
1646 uid integer NOT NULL,
1647 ftid integer NOT NULL
1651 ALTER TABLE forum_priv_access OWNER TO ndawn;
1654 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: ndawn
1657 CREATE TABLE forum_thread_visits (
1658 uid integer NOT NULL,
1659 ftid integer NOT NULL,
1660 "time" timestamp with time zone DEFAULT now() NOT NULL
1662 WITH (fillfactor='50');
1665 ALTER TABLE forum_thread_visits OWNER TO ndawn;
1668 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: ndawn
1671 CREATE TABLE forum_threads (
1672 ftid integer NOT NULL,
1673 fbid integer NOT NULL,
1674 subject text NOT NULL,
1675 sticky boolean DEFAULT false NOT NULL,
1676 uid integer NOT NULL,
1677 posts integer DEFAULT 0 NOT NULL,
1678 mtime timestamp with time zone DEFAULT now() NOT NULL,
1679 ctime timestamp with time zone DEFAULT now() NOT NULL
1681 WITH (fillfactor='50');
1684 ALTER TABLE forum_threads OWNER TO ndawn;
1687 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1690 CREATE SEQUENCE forum_threads_ftid_seq
1698 ALTER TABLE forum_threads_ftid_seq OWNER TO ndawn;
1701 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1704 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1708 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: ndawn
1711 CREATE TABLE groupmembers (
1712 gid character(1) NOT NULL,
1713 uid integer NOT NULL
1717 ALTER TABLE groupmembers OWNER TO ndawn;
1720 -- Name: users_defprio; Type: VIEW; Schema: public; Owner: ndawn
1723 CREATE VIEW users_defprio AS
1745 ((((((0.2 * (u.attack_points / GREATEST(a.attack, (1)::numeric))) + (0.4 * (u.defense_points / GREATEST(a.defense, (1)::numeric)))) + (0.2 * ((p.size)::numeric / a.size))) + (0.05 * ((p.score)::numeric / a.score))) + (0.15 * ((p.value)::numeric / a.value))))::numeric(3,2) AS defprio
1747 LEFT JOIN current_planet_stats p USING (pid)),
1748 ( SELECT avg(u_1.attack_points) AS attack,
1749 avg(u_1.defense_points) AS defense,
1750 avg(p_1.size) AS size,
1751 avg(p_1.score) AS score,
1752 avg(p_1.value) AS value
1754 JOIN current_planet_stats p_1 USING (pid))
1755 WHERE (u_1.uid IN ( SELECT groupmembers.uid
1757 WHERE (groupmembers.gid = 'M'::bpchar)))) a;
1760 ALTER TABLE users_defprio OWNER TO ndawn;
1763 -- Name: full_defcalls; Type: VIEW; Schema: public; Owner: ndawn
1766 CREATE VIEW full_defcalls AS
1783 count(NULLIF((f.back = ((f.landing_tick + f.eta) - 1)), false)) AS fleets
1784 FROM (((users_defprio u
1785 JOIN current_planet_stats p USING (pid))
1786 JOIN defcalls c USING (uid))
1787 LEFT JOIN launch_confirmations f USING (pid, landing_tick))
1788 GROUP BY c.call, p.x, p.y, p.z, u.pid, c.landing_tick, c.dc, c.curreta, u.defprio, c.race, c.amount, c.eta, c.shiptype, c.alliance, c.attackers, c.status;
1791 ALTER TABLE full_defcalls OWNER TO ndawn;
1794 -- Name: full_fleets; Type: TABLE; Schema: public; Owner: ndawn
1797 CREATE TABLE full_fleets (
1798 fid integer NOT NULL,
1799 uid integer NOT NULL
1803 ALTER TABLE full_fleets OWNER TO ndawn;
1806 -- Name: intel; Type: TABLE; Schema: public; Owner: ndawn
1809 CREATE TABLE intel (
1810 id integer NOT NULL,
1811 uid integer NOT NULL,
1812 sender integer NOT NULL,
1813 target integer NOT NULL,
1814 mission text NOT NULL,
1817 tick integer NOT NULL,
1818 eta integer NOT NULL,
1820 ingal boolean NOT NULL
1824 ALTER TABLE intel OWNER TO ndawn;
1827 -- Name: full_intel; Type: VIEW; Schema: public; Owner: ndawn
1830 CREATE VIEW full_intel AS
1831 SELECT s.alliance AS salliance,
1832 coords(s.x, s.y, s.z) AS scoords,
1835 t.alliance AS talliance,
1836 coords(t.x, t.y, t.z) AS tcoords,
1847 JOIN users u USING (uid))
1848 JOIN current_planet_stats t ON ((i.target = t.pid)))
1849 JOIN current_planet_stats s ON ((i.sender = s.pid)))
1850 GROUP BY i.tick, i.mission, t.x, t.y, t.z, s.x, s.y, s.z, i.amount, i.ingal, u.username, i.uid, t.alliance, s.alliance, t.nick, s.nick, i.sender, i.target;
1853 ALTER TABLE full_intel OWNER TO ndawn;
1856 -- Name: galaxies; Type: TABLE; Schema: public; Owner: ndawn
1859 CREATE TABLE galaxies (
1862 tick integer NOT NULL,
1863 size integer NOT NULL,
1864 score integer NOT NULL,
1865 value integer NOT NULL,
1866 xp integer NOT NULL,
1867 planets integer NOT NULL,
1868 sizerank integer NOT NULL,
1869 scorerank integer NOT NULL,
1870 valuerank integer NOT NULL,
1871 xprank integer NOT NULL,
1872 size_gain integer NOT NULL,
1873 score_gain integer NOT NULL,
1874 value_gain integer NOT NULL,
1875 xp_gain integer NOT NULL,
1876 planets_gain integer NOT NULL,
1877 sizerank_gain integer NOT NULL,
1878 scorerank_gain integer NOT NULL,
1879 valuerank_gain integer NOT NULL,
1880 xprank_gain integer NOT NULL,
1881 size_gain_day integer NOT NULL,
1882 score_gain_day integer NOT NULL,
1883 value_gain_day integer NOT NULL,
1884 xp_gain_day integer NOT NULL,
1885 planets_gain_day integer NOT NULL,
1886 sizerank_gain_day integer NOT NULL,
1887 scorerank_gain_day integer NOT NULL,
1888 valuerank_gain_day integer NOT NULL,
1889 xprank_gain_day integer NOT NULL
1893 ALTER TABLE galaxies OWNER TO ndawn;
1896 -- Name: group_roles; Type: TABLE; Schema: public; Owner: ndawn
1899 CREATE TABLE group_roles (
1900 gid character(1) NOT NULL,
1901 role character varying(32) NOT NULL
1905 ALTER TABLE group_roles OWNER TO ndawn;
1908 -- Name: groups; Type: TABLE; Schema: public; Owner: ndawn
1911 CREATE TABLE groups (
1912 groupname text NOT NULL,
1913 gid character(1) NOT NULL
1917 ALTER TABLE groups OWNER TO ndawn;
1920 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1923 CREATE SEQUENCE incomings_id_seq
1931 ALTER TABLE incomings_id_seq OWNER TO ndawn;
1934 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1937 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.inc;
1941 -- Name: intel_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1944 CREATE SEQUENCE intel_id_seq
1952 ALTER TABLE intel_id_seq OWNER TO ndawn;
1955 -- Name: intel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1958 ALTER SEQUENCE intel_id_seq OWNED BY intel.id;
1962 -- Name: intel_scans; Type: TABLE; Schema: public; Owner: ndawn
1965 CREATE TABLE intel_scans (
1966 id integer NOT NULL,
1967 intel integer NOT NULL
1971 ALTER TABLE intel_scans OWNER TO ndawn;
1974 -- Name: irc_requests; Type: TABLE; Schema: public; Owner: ndawn
1977 CREATE TABLE irc_requests (
1978 id integer NOT NULL,
1979 channel text NOT NULL,
1980 message text NOT NULL,
1981 sent boolean DEFAULT false NOT NULL,
1982 uid integer NOT NULL
1986 ALTER TABLE irc_requests OWNER TO ndawn;
1989 -- Name: irc_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1992 CREATE SEQUENCE irc_requests_id_seq
2000 ALTER TABLE irc_requests_id_seq OWNER TO ndawn;
2003 -- Name: irc_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2006 ALTER SEQUENCE irc_requests_id_seq OWNED BY irc_requests.id;
2010 -- Name: last_smokes; Type: TABLE; Schema: public; Owner: ndawn
2013 CREATE TABLE last_smokes (
2014 nick citext NOT NULL,
2015 "time" timestamp with time zone NOT NULL
2019 ALTER TABLE last_smokes OWNER TO ndawn;
2022 -- Name: misc; Type: TABLE; Schema: public; Owner: ndawn
2031 ALTER TABLE misc OWNER TO ndawn;
2034 -- Name: planet_tags; Type: TABLE; Schema: public; Owner: ndawn
2037 CREATE TABLE planet_tags (
2038 pid integer NOT NULL,
2039 tag citext NOT NULL,
2040 uid integer NOT NULL,
2041 "time" timestamp with time zone DEFAULT now() NOT NULL
2045 ALTER TABLE planet_tags OWNER TO ndawn;
2048 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2051 CREATE SEQUENCE planets_id_seq
2059 ALTER TABLE planets_id_seq OWNER TO ndawn;
2062 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2065 ALTER SEQUENCE planets_id_seq OWNED BY planets.pid;
2069 -- Name: raid_access; Type: TABLE; Schema: public; Owner: ndawn
2072 CREATE TABLE raid_access (
2073 raid integer NOT NULL,
2074 gid character(1) NOT NULL
2078 ALTER TABLE raid_access OWNER TO ndawn;
2081 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: ndawn
2084 CREATE TABLE raid_claims (
2085 target integer NOT NULL,
2086 uid integer NOT NULL,
2087 wave integer NOT NULL,
2088 joinable boolean DEFAULT false NOT NULL,
2089 launched boolean DEFAULT false NOT NULL,
2090 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
2092 WITH (fillfactor='50');
2095 ALTER TABLE raid_claims OWNER TO ndawn;
2098 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: ndawn
2101 CREATE TABLE raid_targets (
2102 id integer NOT NULL,
2103 raid integer NOT NULL,
2104 pid integer NOT NULL,
2106 modified timestamp with time zone DEFAULT now() NOT NULL
2108 WITH (fillfactor='50');
2111 ALTER TABLE raid_targets OWNER TO ndawn;
2114 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2117 CREATE SEQUENCE raid_targets_id_seq
2125 ALTER TABLE raid_targets_id_seq OWNER TO ndawn;
2128 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2131 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
2135 -- Name: raids; Type: TABLE; Schema: public; Owner: ndawn
2138 CREATE TABLE raids (
2139 id integer NOT NULL,
2140 tick integer NOT NULL,
2141 open boolean DEFAULT false NOT NULL,
2142 waves integer DEFAULT 3 NOT NULL,
2143 message text NOT NULL,
2144 removed boolean DEFAULT false NOT NULL,
2145 released_coords boolean DEFAULT false NOT NULL,
2146 ftid integer NOT NULL
2150 ALTER TABLE raids OWNER TO ndawn;
2153 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2156 CREATE SEQUENCE raids_id_seq
2164 ALTER TABLE raids_id_seq OWNER TO ndawn;
2167 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2170 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
2174 -- Name: roles; Type: TABLE; Schema: public; Owner: ndawn
2177 CREATE TABLE roles (
2178 role character varying(32) NOT NULL
2182 ALTER TABLE roles OWNER TO ndawn;
2185 -- Name: scan_requests; Type: TABLE; Schema: public; Owner: ndawn
2188 CREATE TABLE scan_requests (
2189 id integer NOT NULL,
2190 uid integer NOT NULL,
2191 pid integer NOT NULL,
2194 tick integer DEFAULT tick() NOT NULL,
2195 "time" timestamp with time zone DEFAULT now() NOT NULL,
2196 sent boolean DEFAULT false NOT NULL
2200 ALTER TABLE scan_requests OWNER TO ndawn;
2203 -- Name: scan_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2206 CREATE SEQUENCE scan_requests_id_seq
2214 ALTER TABLE scan_requests_id_seq OWNER TO ndawn;
2217 -- Name: scan_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2220 ALTER SEQUENCE scan_requests_id_seq OWNED BY scan_requests.id;
2224 -- Name: scans; Type: TABLE; Schema: public; Owner: ndawn
2227 CREATE TABLE scans (
2228 tick integer NOT NULL,
2229 scan_id text NOT NULL,
2232 uid integer DEFAULT '-1'::integer NOT NULL,
2233 groupscan boolean DEFAULT false NOT NULL,
2234 parsed boolean DEFAULT false NOT NULL,
2239 ALTER TABLE scans OWNER TO ndawn;
2242 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2245 CREATE SEQUENCE scans_id_seq
2253 ALTER TABLE scans_id_seq OWNER TO ndawn;
2256 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2259 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
2263 -- Name: session_log; Type: TABLE; Schema: public; Owner: ndawn
2266 CREATE TABLE session_log (
2267 uid integer NOT NULL,
2268 "time" timestamp with time zone NOT NULL,
2270 country character(2) NOT NULL,
2271 session text NOT NULL,
2272 remember boolean NOT NULL
2276 ALTER TABLE session_log OWNER TO ndawn;
2279 -- Name: ship_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2282 CREATE SEQUENCE ship_stats_id_seq
2290 ALTER TABLE ship_stats_id_seq OWNER TO ndawn;
2293 -- Name: ship_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2296 ALTER SEQUENCE ship_stats_id_seq OWNED BY ship_stats.id;
2300 -- Name: sms; Type: TABLE; Schema: public; Owner: ndawn
2304 id integer NOT NULL,
2306 uid integer NOT NULL,
2307 status text DEFAULT 'Waiting'::text NOT NULL,
2308 number text NOT NULL,
2309 message character varying(140) NOT NULL,
2310 cost numeric(4,2) DEFAULT 0 NOT NULL,
2311 "time" timestamp with time zone DEFAULT now() NOT NULL
2315 ALTER TABLE sms OWNER TO ndawn;
2318 -- Name: sms_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2321 CREATE SEQUENCE sms_id_seq
2329 ALTER TABLE sms_id_seq OWNER TO ndawn;
2332 -- Name: sms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2335 ALTER SEQUENCE sms_id_seq OWNED BY sms.id;
2339 -- Name: smslist; Type: TABLE; Schema: public; Owner: ndawn
2342 CREATE TABLE smslist (
2349 ALTER TABLE smslist OWNER TO ndawn;
2352 -- Name: table_updates; Type: VIEW; Schema: public; Owner: ndawn
2355 CREATE VIEW table_updates AS
2356 SELECT t.schemaname,
2362 WHEN (t.n_tup_upd > 0) THEN ((((t.n_tup_hot_upd)::numeric / (t.n_tup_upd)::numeric) * 100.0))::numeric(5,2)
2365 FROM (pg_stat_all_tables t
2367 JOIN pg_namespace n ON ((c.relnamespace = n.oid))) ON (((n.nspname = t.schemaname) AND (c.relname = t.relname) AND (t.n_tup_upd > 0))));
2370 ALTER TABLE table_updates OWNER TO ndawn;
2373 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2376 CREATE SEQUENCE users_uid_seq
2384 ALTER TABLE users_uid_seq OWNER TO ndawn;
2387 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2390 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
2394 -- Name: wiki_namespace_access; Type: TABLE; Schema: public; Owner: ndawn
2397 CREATE TABLE wiki_namespace_access (
2398 namespace text NOT NULL,
2399 gid character(1) NOT NULL,
2400 edit boolean DEFAULT false NOT NULL,
2401 post boolean DEFAULT false NOT NULL,
2402 moderate boolean DEFAULT false NOT NULL
2406 ALTER TABLE wiki_namespace_access OWNER TO ndawn;
2409 -- Name: wiki_namespaces; Type: TABLE; Schema: public; Owner: ndawn
2412 CREATE TABLE wiki_namespaces (
2413 namespace character varying(16) NOT NULL
2417 ALTER TABLE wiki_namespaces OWNER TO ndawn;
2420 -- Name: wiki_page_access; Type: TABLE; Schema: public; Owner: ndawn
2423 CREATE TABLE wiki_page_access (
2424 wpid integer NOT NULL,
2425 uid integer NOT NULL,
2426 edit boolean DEFAULT false NOT NULL,
2427 moderate boolean DEFAULT false NOT NULL
2431 ALTER TABLE wiki_page_access OWNER TO ndawn;
2434 -- Name: wiki_page_revisions; Type: TABLE; Schema: public; Owner: ndawn
2437 CREATE TABLE wiki_page_revisions (
2439 wprev integer NOT NULL,
2442 comment text NOT NULL,
2443 "time" timestamp with time zone DEFAULT now() NOT NULL,
2448 ALTER TABLE wiki_page_revisions OWNER TO ndawn;
2451 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2454 CREATE SEQUENCE wiki_page_revisions_wprev_seq
2462 ALTER TABLE wiki_page_revisions_wprev_seq OWNER TO ndawn;
2465 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2468 ALTER SEQUENCE wiki_page_revisions_wprev_seq OWNED BY wiki_page_revisions.wprev;
2472 -- Name: wiki_pages; Type: TABLE; Schema: public; Owner: ndawn
2475 CREATE TABLE wiki_pages (
2476 wpid integer NOT NULL,
2477 name character varying(255) NOT NULL,
2478 namespace text DEFAULT ''::text NOT NULL,
2479 textsearch tsvector DEFAULT to_tsvector(''::text) NOT NULL,
2481 "time" timestamp with time zone DEFAULT now() NOT NULL
2485 ALTER TABLE wiki_pages OWNER TO ndawn;
2488 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2491 CREATE SEQUENCE wiki_pages_wpid_seq
2499 ALTER TABLE wiki_pages_wpid_seq OWNER TO ndawn;
2502 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2505 ALTER SEQUENCE wiki_pages_wpid_seq OWNED BY wiki_pages.wpid;
2509 -- Name: aid; Type: DEFAULT; Schema: public; Owner: ndawn
2512 ALTER TABLE ONLY alliances ALTER COLUMN aid SET DEFAULT nextval('alliances_id_seq'::regclass);
2516 -- Name: call; Type: DEFAULT; Schema: public; Owner: ndawn
2519 ALTER TABLE ONLY calls ALTER COLUMN call SET DEFAULT nextval('calls_id_seq'::regclass);
2523 -- Name: num; Type: DEFAULT; Schema: public; Owner: ndawn
2526 ALTER TABLE ONLY fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
2530 -- Name: fid; Type: DEFAULT; Schema: public; Owner: ndawn
2533 ALTER TABLE ONLY fleets ALTER COLUMN fid SET DEFAULT nextval('fleets_id_seq'::regclass);
2537 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: ndawn
2540 ALTER TABLE ONLY forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
2544 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: ndawn
2547 ALTER TABLE ONLY forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
2551 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: ndawn
2554 ALTER TABLE ONLY forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
2558 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: ndawn
2561 ALTER TABLE ONLY forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
2565 -- Name: inc; Type: DEFAULT; Schema: public; Owner: ndawn
2568 ALTER TABLE ONLY incomings ALTER COLUMN inc SET DEFAULT nextval('incomings_id_seq'::regclass);
2572 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2575 ALTER TABLE ONLY intel ALTER COLUMN id SET DEFAULT nextval('intel_id_seq'::regclass);
2579 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2582 ALTER TABLE ONLY irc_requests ALTER COLUMN id SET DEFAULT nextval('irc_requests_id_seq'::regclass);
2586 -- Name: pid; Type: DEFAULT; Schema: public; Owner: ndawn
2589 ALTER TABLE ONLY planets ALTER COLUMN pid SET DEFAULT nextval('planets_id_seq'::regclass);
2593 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2596 ALTER TABLE ONLY raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
2600 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2603 ALTER TABLE ONLY raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
2607 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2610 ALTER TABLE ONLY scan_requests ALTER COLUMN id SET DEFAULT nextval('scan_requests_id_seq'::regclass);
2614 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2617 ALTER TABLE ONLY scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
2621 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2624 ALTER TABLE ONLY ship_stats ALTER COLUMN id SET DEFAULT nextval('ship_stats_id_seq'::regclass);
2628 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2631 ALTER TABLE ONLY sms ALTER COLUMN id SET DEFAULT nextval('sms_id_seq'::regclass);
2635 -- Name: uid; Type: DEFAULT; Schema: public; Owner: ndawn
2638 ALTER TABLE ONLY users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
2642 -- Name: wprev; Type: DEFAULT; Schema: public; Owner: ndawn
2645 ALTER TABLE ONLY wiki_page_revisions ALTER COLUMN wprev SET DEFAULT nextval('wiki_page_revisions_wprev_seq'::regclass);
2649 -- Name: wpid; Type: DEFAULT; Schema: public; Owner: ndawn
2652 ALTER TABLE ONLY wiki_pages ALTER COLUMN wpid SET DEFAULT nextval('wiki_pages_wpid_seq'::regclass);
2656 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2659 ALTER TABLE ONLY users
2660 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
2664 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2667 ALTER TABLE ONLY alliance_stats
2668 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (aid, tick);
2672 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2675 ALTER TABLE ONLY alliances
2676 ADD CONSTRAINT alliances_name_key UNIQUE (alliance);
2680 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2683 ALTER TABLE ONLY alliances
2684 ADD CONSTRAINT alliances_pkey PRIMARY KEY (aid);
2688 -- Name: available_planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2691 ALTER TABLE ONLY available_planet_tags
2692 ADD CONSTRAINT available_planet_tags_pkey PRIMARY KEY (tag);
2696 -- Name: call_statuses_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2699 ALTER TABLE ONLY call_statuses
2700 ADD CONSTRAINT call_statuses_pkey PRIMARY KEY (status);
2704 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2707 ALTER TABLE ONLY calls
2708 ADD CONSTRAINT calls_member_key UNIQUE (uid, landing_tick);
2712 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2715 ALTER TABLE ONLY calls
2716 ADD CONSTRAINT calls_pkey PRIMARY KEY (call);
2720 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2723 ALTER TABLE ONLY channel_flags
2724 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
2728 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2731 ALTER TABLE ONLY channel_flags
2732 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (flag);
2736 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2739 ALTER TABLE ONLY channel_group_flags
2740 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, gid, flag);
2744 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2747 ALTER TABLE ONLY channels
2748 ADD CONSTRAINT channels_pkey PRIMARY KEY (channel);
2752 -- Name: clickatell_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2755 ALTER TABLE ONLY clickatell
2756 ADD CONSTRAINT clickatell_pkey PRIMARY KEY (api_id, username);
2760 -- Name: covop_attacks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2763 ALTER TABLE ONLY covop_attacks
2764 ADD CONSTRAINT covop_attacks_pkey PRIMARY KEY (pid, tick, uid);
2768 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2771 ALTER TABLE ONLY defense_missions
2772 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
2776 -- Name: development_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2779 ALTER TABLE ONLY development_scans
2780 ADD CONSTRAINT development_scans_pkey PRIMARY KEY (id);
2784 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2787 ALTER TABLE ONLY dumps
2788 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
2792 -- Name: email_change_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2795 ALTER TABLE ONLY email_change
2796 ADD CONSTRAINT email_change_pkey PRIMARY KEY (id);
2800 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2803 ALTER TABLE ONLY fleet_scans
2804 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (fid);
2808 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2811 ALTER TABLE ONLY fleet_ships
2812 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
2816 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2819 ALTER TABLE ONLY fleet_ships
2820 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (fid, ship);
2824 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2827 ALTER TABLE ONLY fleets
2828 ADD CONSTRAINT fleets_pkey PRIMARY KEY (fid);
2832 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2835 ALTER TABLE ONLY forum_access
2836 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
2840 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2843 ALTER TABLE ONLY forum_boards
2844 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
2848 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2851 ALTER TABLE ONLY forum_boards
2852 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
2856 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2859 ALTER TABLE ONLY forum_categories
2860 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
2864 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2867 ALTER TABLE ONLY forum_categories
2868 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
2872 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2875 ALTER TABLE ONLY forum_posts
2876 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
2880 -- Name: forum_priv_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2883 ALTER TABLE ONLY forum_priv_access
2884 ADD CONSTRAINT forum_priv_access_pkey PRIMARY KEY (uid, ftid);
2888 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2891 ALTER TABLE ONLY forum_thread_visits
2892 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
2896 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2899 ALTER TABLE ONLY forum_threads
2900 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
2904 -- Name: full_fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2907 ALTER TABLE ONLY full_fleets
2908 ADD CONSTRAINT full_fleets_pkey PRIMARY KEY (fid);
2912 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2915 ALTER TABLE ONLY galaxies
2916 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (tick, x, y);
2920 -- Name: group_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2923 ALTER TABLE ONLY group_roles
2924 ADD CONSTRAINT group_roles_pkey PRIMARY KEY (gid, role);
2928 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2931 ALTER TABLE ONLY groupmembers
2932 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2936 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2939 ALTER TABLE ONLY groups
2940 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2944 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2947 ALTER TABLE ONLY groups
2948 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2952 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2955 ALTER TABLE ONLY incomings
2956 ADD CONSTRAINT incomings_call_key UNIQUE (call, pid, fleet);
2960 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2963 ALTER TABLE ONLY incomings
2964 ADD CONSTRAINT incomings_pkey PRIMARY KEY (inc);
2968 -- Name: intel_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2971 ALTER TABLE ONLY intel
2972 ADD CONSTRAINT intel_pkey PRIMARY KEY (id);
2976 -- Name: intel_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2979 ALTER TABLE ONLY intel_scans
2980 ADD CONSTRAINT intel_scans_pkey PRIMARY KEY (id, intel);
2984 -- Name: irc_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2987 ALTER TABLE ONLY irc_requests
2988 ADD CONSTRAINT irc_requests_pkey PRIMARY KEY (id);
2992 -- Name: last_smokes_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2995 ALTER TABLE ONLY last_smokes
2996 ADD CONSTRAINT last_smokes_pkey PRIMARY KEY (nick);
3000 -- Name: launch_confirmations_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3003 ALTER TABLE ONLY launch_confirmations
3004 ADD CONSTRAINT launch_confirmations_pkey PRIMARY KEY (fid);
3008 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3011 ALTER TABLE ONLY misc
3012 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
3016 -- Name: planet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3019 ALTER TABLE ONLY planet_scans
3020 ADD CONSTRAINT planet_scans_pkey PRIMARY KEY (id);
3024 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3027 ALTER TABLE ONLY planet_stats
3028 ADD CONSTRAINT planet_stats_id_key UNIQUE (pid, tick);
3032 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3035 ALTER TABLE ONLY planet_stats
3036 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
3040 -- Name: planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3043 ALTER TABLE ONLY planet_tags
3044 ADD CONSTRAINT planet_tags_pkey PRIMARY KEY (pid, uid, tag);
3048 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3051 ALTER TABLE ONLY planets
3052 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
3056 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3059 ALTER TABLE ONLY planets
3060 ADD CONSTRAINT planets_pkey PRIMARY KEY (pid);
3064 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3067 ALTER TABLE ONLY planets
3068 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
3072 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3075 ALTER TABLE ONLY raid_access
3076 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
3080 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3083 ALTER TABLE ONLY raid_claims
3084 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
3088 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3091 ALTER TABLE ONLY raid_targets
3092 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
3096 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3099 ALTER TABLE ONLY raid_targets
3100 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, pid);
3104 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3107 ALTER TABLE ONLY raids
3108 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
3112 -- Name: roles_role_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3115 ALTER TABLE ONLY roles
3116 ADD CONSTRAINT roles_role_key UNIQUE (role);
3120 -- Name: scan_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3123 ALTER TABLE ONLY scan_requests
3124 ADD CONSTRAINT scan_requests_pkey PRIMARY KEY (id);
3128 -- Name: scan_requests_tick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3131 ALTER TABLE ONLY scan_requests
3132 ADD CONSTRAINT scan_requests_tick_key UNIQUE (tick, pid, type, uid);
3136 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3139 ALTER TABLE ONLY scans
3140 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
3144 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3147 ALTER TABLE ONLY scans
3148 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
3152 -- Name: session_log_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3155 ALTER TABLE ONLY session_log
3156 ADD CONSTRAINT session_log_pkey PRIMARY KEY (uid, "time", ip);
3160 -- Name: ship_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3163 ALTER TABLE ONLY ship_stats
3164 ADD CONSTRAINT ship_stats_id_key UNIQUE (id);
3166 ALTER TABLE ship_stats CLUSTER ON ship_stats_id_key;
3170 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3173 ALTER TABLE ONLY ship_stats
3174 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (ship);
3178 -- Name: sms_msgid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3181 ALTER TABLE ONLY sms
3182 ADD CONSTRAINT sms_msgid_key UNIQUE (msgid);
3186 -- Name: sms_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3189 ALTER TABLE ONLY sms
3190 ADD CONSTRAINT sms_pkey PRIMARY KEY (id);
3194 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3197 ALTER TABLE ONLY smslist
3198 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
3202 -- Name: ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3205 ALTER TABLE ONLY ticks
3206 ADD CONSTRAINT ticks_pkey PRIMARY KEY (t);
3210 -- Name: users_hostmask_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3213 ALTER TABLE ONLY users
3214 ADD CONSTRAINT users_hostmask_key UNIQUE (hostmask);
3218 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3221 ALTER TABLE ONLY users
3222 ADD CONSTRAINT users_planet_key UNIQUE (pid);
3226 -- Name: users_pnick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3229 ALTER TABLE ONLY users
3230 ADD CONSTRAINT users_pnick_key UNIQUE (pnick);
3234 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3237 ALTER TABLE ONLY users
3238 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
3242 -- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3245 ALTER TABLE ONLY users
3246 ADD CONSTRAINT users_username_key UNIQUE (username);
3250 -- Name: wiki_namespace_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3253 ALTER TABLE ONLY wiki_namespace_access
3254 ADD CONSTRAINT wiki_namespace_access_pkey PRIMARY KEY (gid, namespace);
3258 -- Name: wiki_namespaces_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3261 ALTER TABLE ONLY wiki_namespaces
3262 ADD CONSTRAINT wiki_namespaces_pkey PRIMARY KEY (namespace);
3266 -- Name: wiki_page_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3269 ALTER TABLE ONLY wiki_page_access
3270 ADD CONSTRAINT wiki_page_access_pkey PRIMARY KEY (uid, wpid);
3274 -- Name: wiki_page_revisions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3277 ALTER TABLE ONLY wiki_page_revisions
3278 ADD CONSTRAINT wiki_page_revisions_pkey PRIMARY KEY (wprev);
3282 -- Name: wiki_pages_namespace_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3285 ALTER TABLE ONLY wiki_pages
3286 ADD CONSTRAINT wiki_pages_namespace_key UNIQUE (namespace, name);
3290 -- Name: wiki_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3293 ALTER TABLE ONLY wiki_pages
3294 ADD CONSTRAINT wiki_pages_pkey PRIMARY KEY (wpid);
3298 -- Name: development_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3301 CREATE INDEX development_scans_planet_index ON development_scans USING btree (pid, tick);
3305 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: ndawn
3308 CREATE INDEX fleets_sender_index ON fleets USING btree (pid);
3312 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: ndawn
3315 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
3319 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3322 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
3326 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn
3329 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
3333 -- Name: intel_tick_index; Type: INDEX; Schema: public; Owner: ndawn
3336 CREATE INDEX intel_tick_index ON intel USING btree (tick);
3340 -- Name: planet_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3343 CREATE INDEX planet_scans_planet_index ON planet_scans USING btree (pid, tick);
3347 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: ndawn
3350 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
3354 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: ndawn
3357 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
3361 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: ndawn
3364 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
3368 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: ndawn
3371 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
3375 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: ndawn
3378 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance);
3382 -- Name: scan_requests_time_not_sent_index; Type: INDEX; Schema: public; Owner: ndawn
3385 CREATE INDEX scan_requests_time_not_sent_index ON scan_requests USING btree ("time") WHERE (NOT sent);
3389 -- Name: scans_not_parsed_index; Type: INDEX; Schema: public; Owner: ndawn
3392 CREATE INDEX scans_not_parsed_index ON scans USING btree (groupscan) WHERE (NOT parsed);
3396 -- Name: scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3399 CREATE INDEX scans_planet_index ON scans USING btree (pid, type, tick);
3403 -- Name: sms_status_msgid_idx; Type: INDEX; Schema: public; Owner: ndawn
3406 CREATE INDEX sms_status_msgid_idx ON sms USING btree (status) WHERE (msgid IS NULL);
3410 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: ndawn
3413 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
3417 -- Name: users_birthday_index; Type: INDEX; Schema: public; Owner: ndawn
3420 CREATE INDEX users_birthday_index ON users USING btree (mmdd(birthday)) WHERE (birthday IS NOT NULL);
3424 -- Name: wiki_pages_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3427 CREATE INDEX wiki_pages_textsearch_index ON wiki_pages USING gin (textsearch);
3431 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: ndawn
3434 CREATE TRIGGER add_call BEFORE INSERT ON calls FOR EACH ROW EXECUTE PROCEDURE add_call();
3438 -- Name: add_raid; Type: TRIGGER; Schema: public; Owner: ndawn
3441 CREATE TRIGGER add_raid BEFORE INSERT ON raids FOR EACH ROW EXECUTE PROCEDURE add_raid();
3445 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: ndawn
3448 CREATE TRIGGER add_remove_member AFTER INSERT OR DELETE ON groupmembers FOR EACH ROW EXECUTE PROCEDURE change_member();
3452 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: ndawn
3455 CREATE TRIGGER add_user BEFORE INSERT ON users FOR EACH ROW EXECUTE PROCEDURE add_user();
3459 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: ndawn
3462 CREATE TRIGGER update_forum_post BEFORE INSERT OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_post();
3466 -- Name: update_forum_thread_posts; Type: TRIGGER; Schema: public; Owner: ndawn
3469 CREATE TRIGGER update_forum_thread_posts AFTER INSERT OR DELETE OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_thread_posts();
3473 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: ndawn
3476 CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
3480 -- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn
3483 CREATE TRIGGER update_wiki_page BEFORE UPDATE ON wiki_pages FOR EACH ROW EXECUTE PROCEDURE update_wiki_page();
3487 -- Name: updated_claim; Type: TRIGGER; Schema: public; Owner: ndawn
3490 CREATE TRIGGER updated_claim AFTER INSERT OR DELETE OR UPDATE ON raid_claims FOR EACH ROW EXECUTE PROCEDURE updated_claim();
3494 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3497 ALTER TABLE ONLY alliance_stats
3498 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (aid) REFERENCES alliances(aid);
3502 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3505 ALTER TABLE ONLY calls
3506 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
3510 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3513 ALTER TABLE ONLY calls
3514 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
3518 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3521 ALTER TABLE ONLY calls
3522 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3526 -- Name: calls_status_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3529 ALTER TABLE ONLY calls
3530 ADD CONSTRAINT calls_status_fkey FOREIGN KEY (status) REFERENCES call_statuses(status);
3534 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3537 ALTER TABLE ONLY channel_group_flags
3538 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(channel) ON UPDATE CASCADE ON DELETE CASCADE;
3542 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3545 ALTER TABLE ONLY channel_group_flags
3546 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(flag) ON UPDATE CASCADE ON DELETE CASCADE;
3550 -- Name: channel_group_flags_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3553 ALTER TABLE ONLY channel_group_flags
3554 ADD CONSTRAINT channel_group_flags_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3558 -- Name: covop_attacks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3561 ALTER TABLE ONLY covop_attacks
3562 ADD CONSTRAINT covop_attacks_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3566 -- Name: covop_attacks_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3569 ALTER TABLE ONLY covop_attacks
3570 ADD CONSTRAINT covop_attacks_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3574 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3577 ALTER TABLE ONLY defense_missions
3578 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3582 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3585 ALTER TABLE ONLY defense_missions
3586 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3590 -- Name: development_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3593 ALTER TABLE ONLY development_scans
3594 ADD CONSTRAINT development_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3598 -- Name: development_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3601 ALTER TABLE ONLY development_scans
3602 ADD CONSTRAINT development_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3606 -- Name: email_change_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3609 ALTER TABLE ONLY email_change
3610 ADD CONSTRAINT email_change_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3614 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3617 ALTER TABLE ONLY fleet_scans
3618 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON DELETE CASCADE;
3622 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3625 ALTER TABLE ONLY fleet_scans
3626 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (id) REFERENCES scans(id);
3630 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3633 ALTER TABLE ONLY fleet_ships
3634 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3638 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3641 ALTER TABLE ONLY fleet_ships
3642 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(ship);
3646 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3649 ALTER TABLE ONLY fleets
3650 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3654 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3657 ALTER TABLE ONLY forum_access
3658 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3662 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3665 ALTER TABLE ONLY forum_access
3666 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3670 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3673 ALTER TABLE ONLY forum_boards
3674 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
3678 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3681 ALTER TABLE ONLY forum_posts
3682 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3686 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3689 ALTER TABLE ONLY forum_posts
3690 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3694 -- Name: forum_priv_access_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3697 ALTER TABLE ONLY forum_priv_access
3698 ADD CONSTRAINT forum_priv_access_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON DELETE CASCADE;
3702 -- Name: forum_priv_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3705 ALTER TABLE ONLY forum_priv_access
3706 ADD CONSTRAINT forum_priv_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3710 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3713 ALTER TABLE ONLY forum_thread_visits
3714 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3718 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3721 ALTER TABLE ONLY forum_thread_visits
3722 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3726 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3729 ALTER TABLE ONLY forum_threads
3730 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3734 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3737 ALTER TABLE ONLY forum_threads
3738 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
3742 -- Name: full_fleets_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3745 ALTER TABLE ONLY full_fleets
3746 ADD CONSTRAINT full_fleets_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3750 -- Name: full_fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3753 ALTER TABLE ONLY full_fleets
3754 ADD CONSTRAINT full_fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3758 -- Name: group_roles_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3761 ALTER TABLE ONLY group_roles
3762 ADD CONSTRAINT group_roles_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3766 -- Name: group_roles_role_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3769 ALTER TABLE ONLY group_roles
3770 ADD CONSTRAINT group_roles_role_fkey FOREIGN KEY (role) REFERENCES roles(role);
3774 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3777 ALTER TABLE ONLY groupmembers
3778 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3782 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3785 ALTER TABLE ONLY groupmembers
3786 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3790 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3793 ALTER TABLE ONLY incomings
3794 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3798 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3801 ALTER TABLE ONLY incomings
3802 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3806 -- Name: intel_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3809 ALTER TABLE ONLY intel_scans
3810 ADD CONSTRAINT intel_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3814 -- Name: intel_scans_intel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3817 ALTER TABLE ONLY intel_scans
3818 ADD CONSTRAINT intel_scans_intel_fkey FOREIGN KEY (intel) REFERENCES intel(id) ON DELETE CASCADE;
3822 -- Name: intel_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3825 ALTER TABLE ONLY intel
3826 ADD CONSTRAINT intel_sender_fkey FOREIGN KEY (sender) REFERENCES planets(pid);
3830 -- Name: intel_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3833 ALTER TABLE ONLY intel
3834 ADD CONSTRAINT intel_target_fkey FOREIGN KEY (target) REFERENCES planets(pid);
3838 -- Name: intel_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3841 ALTER TABLE ONLY intel
3842 ADD CONSTRAINT intel_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3846 -- Name: irc_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3849 ALTER TABLE ONLY irc_requests
3850 ADD CONSTRAINT irc_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3854 -- Name: launch_confirmations_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3857 ALTER TABLE ONLY launch_confirmations
3858 ADD CONSTRAINT launch_confirmations_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3862 -- Name: launch_confirmations_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3865 ALTER TABLE ONLY launch_confirmations
3866 ADD CONSTRAINT launch_confirmations_target_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3870 -- Name: launch_confirmations_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3873 ALTER TABLE ONLY launch_confirmations
3874 ADD CONSTRAINT launch_confirmations_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3878 -- Name: planet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3881 ALTER TABLE ONLY planet_scans
3882 ADD CONSTRAINT planet_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3886 -- Name: planet_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3889 ALTER TABLE ONLY planet_scans
3890 ADD CONSTRAINT planet_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3894 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3897 ALTER TABLE ONLY planet_stats
3898 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3902 -- Name: planet_tags_pid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3905 ALTER TABLE ONLY planet_tags
3906 ADD CONSTRAINT planet_tags_pid_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3910 -- Name: planet_tags_tag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3913 ALTER TABLE ONLY planet_tags
3914 ADD CONSTRAINT planet_tags_tag_fkey FOREIGN KEY (tag) REFERENCES available_planet_tags(tag);
3918 -- Name: planet_tags_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3921 ALTER TABLE ONLY planet_tags
3922 ADD CONSTRAINT planet_tags_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3926 -- Name: planets_alliance_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3929 ALTER TABLE ONLY planets
3930 ADD CONSTRAINT planets_alliance_fkey FOREIGN KEY (alliance) REFERENCES alliances(alliance) ON UPDATE CASCADE ON DELETE SET NULL;
3934 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3937 ALTER TABLE ONLY planets
3938 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
3942 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3945 ALTER TABLE ONLY raid_access
3946 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3950 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3953 ALTER TABLE ONLY raid_access
3954 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3958 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3961 ALTER TABLE ONLY raid_claims
3962 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
3966 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3969 ALTER TABLE ONLY raid_claims
3970 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3974 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3977 ALTER TABLE ONLY raid_targets
3978 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3982 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3985 ALTER TABLE ONLY raid_targets
3986 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3990 -- Name: scan_requests_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3993 ALTER TABLE ONLY scan_requests
3994 ADD CONSTRAINT scan_requests_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3998 -- Name: scan_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4001 ALTER TABLE ONLY scan_requests
4002 ADD CONSTRAINT scan_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4006 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4009 ALTER TABLE ONLY scans
4010 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
4014 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4017 ALTER TABLE ONLY scans
4018 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
4022 -- Name: session_log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4025 ALTER TABLE ONLY session_log
4026 ADD CONSTRAINT session_log_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4030 -- Name: sms_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4033 ALTER TABLE ONLY sms
4034 ADD CONSTRAINT sms_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4038 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4041 ALTER TABLE ONLY users
4042 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE SET NULL ON DELETE SET NULL;
4046 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4049 ALTER TABLE ONLY users
4050 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
4054 -- Name: wiki_namespace_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4057 ALTER TABLE ONLY wiki_namespace_access
4058 ADD CONSTRAINT wiki_namespace_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
4062 -- Name: wiki_namespace_access_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4065 ALTER TABLE ONLY wiki_namespace_access
4066 ADD CONSTRAINT wiki_namespace_access_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4070 -- Name: wiki_page_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4073 ALTER TABLE ONLY wiki_page_access
4074 ADD CONSTRAINT wiki_page_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4078 -- Name: wiki_page_access_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4081 ALTER TABLE ONLY wiki_page_access
4082 ADD CONSTRAINT wiki_page_access_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4086 -- Name: wiki_page_revisions_parent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4089 ALTER TABLE ONLY wiki_page_revisions
4090 ADD CONSTRAINT wiki_page_revisions_parent_fkey FOREIGN KEY (parent) REFERENCES wiki_page_revisions(wprev);
4094 -- Name: wiki_page_revisions_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4097 ALTER TABLE ONLY wiki_page_revisions
4098 ADD CONSTRAINT wiki_page_revisions_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4102 -- Name: wiki_page_revisions_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4105 ALTER TABLE ONLY wiki_page_revisions
4106 ADD CONSTRAINT wiki_page_revisions_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4110 -- Name: wiki_pages_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4113 ALTER TABLE ONLY wiki_pages
4114 ADD CONSTRAINT wiki_pages_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4118 -- Name: wiki_pages_wprev_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4121 ALTER TABLE ONLY wiki_pages
4122 ADD CONSTRAINT wiki_pages_wprev_fkey FOREIGN KEY (wprev) REFERENCES wiki_page_revisions(wprev);
4126 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4129 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4130 REVOKE ALL ON SCHEMA public FROM postgres;
4131 GRANT ALL ON SCHEMA public TO postgres;
4132 GRANT ALL ON SCHEMA public TO PUBLIC;
4136 -- Name: coords(integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4139 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM PUBLIC;
4140 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM ndawn;
4141 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO ndawn;
4142 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO PUBLIC;
4143 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO intel;
4147 -- Name: endtick(); Type: ACL; Schema: public; Owner: ndawn
4150 REVOKE ALL ON FUNCTION endtick() FROM PUBLIC;
4151 REVOKE ALL ON FUNCTION endtick() FROM ndawn;
4152 GRANT ALL ON FUNCTION endtick() TO ndawn;
4153 GRANT ALL ON FUNCTION endtick() TO PUBLIC;
4154 GRANT ALL ON FUNCTION endtick() TO intel;
4158 -- Name: planetcoords(integer, integer); Type: ACL; Schema: public; Owner: ndawn
4161 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM PUBLIC;
4162 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM ndawn;
4163 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO ndawn;
4164 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO PUBLIC;
4165 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO intel;
4169 -- Name: planetid(integer, integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4172 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM PUBLIC;
4173 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM ndawn;
4174 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO ndawn;
4175 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO PUBLIC;
4176 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO intel;
4180 -- Name: tick(); Type: ACL; Schema: public; Owner: ndawn
4183 REVOKE ALL ON FUNCTION tick() FROM PUBLIC;
4184 REVOKE ALL ON FUNCTION tick() FROM ndawn;
4185 GRANT ALL ON FUNCTION tick() TO ndawn;
4186 GRANT ALL ON FUNCTION tick() TO PUBLIC;
4187 GRANT ALL ON FUNCTION tick() TO intel;
4191 -- Name: alliance_stats; Type: ACL; Schema: public; Owner: ndawn
4194 REVOKE ALL ON TABLE alliance_stats FROM PUBLIC;
4195 REVOKE ALL ON TABLE alliance_stats FROM ndawn;
4196 GRANT ALL ON TABLE alliance_stats TO ndawn;
4197 GRANT SELECT ON TABLE alliance_stats TO intel;
4201 -- Name: alliances; Type: ACL; Schema: public; Owner: ndawn
4204 REVOKE ALL ON TABLE alliances FROM PUBLIC;
4205 REVOKE ALL ON TABLE alliances FROM ndawn;
4206 GRANT ALL ON TABLE alliances TO ndawn;
4207 GRANT SELECT ON TABLE alliances TO intel;
4211 -- Name: development_scans; Type: ACL; Schema: public; Owner: ndawn
4214 REVOKE ALL ON TABLE development_scans FROM PUBLIC;
4215 REVOKE ALL ON TABLE development_scans FROM ndawn;
4216 GRANT ALL ON TABLE development_scans TO ndawn;
4217 GRANT SELECT ON TABLE development_scans TO intel;
4221 -- Name: current_development_scans; Type: ACL; Schema: public; Owner: ndawn
4224 REVOKE ALL ON TABLE current_development_scans FROM PUBLIC;
4225 REVOKE ALL ON TABLE current_development_scans FROM ndawn;
4226 GRANT ALL ON TABLE current_development_scans TO ndawn;
4227 GRANT SELECT ON TABLE current_development_scans TO intel;
4231 -- Name: planet_scans; Type: ACL; Schema: public; Owner: ndawn
4234 REVOKE ALL ON TABLE planet_scans FROM PUBLIC;
4235 REVOKE ALL ON TABLE planet_scans FROM ndawn;
4236 GRANT ALL ON TABLE planet_scans TO ndawn;
4237 GRANT SELECT ON TABLE planet_scans TO intel;
4241 -- Name: current_planet_scans; Type: ACL; Schema: public; Owner: ndawn
4244 REVOKE ALL ON TABLE current_planet_scans FROM PUBLIC;
4245 REVOKE ALL ON TABLE current_planet_scans FROM ndawn;
4246 GRANT ALL ON TABLE current_planet_scans TO ndawn;
4247 GRANT SELECT ON TABLE current_planet_scans TO intel;
4251 -- Name: planet_stats; Type: ACL; Schema: public; Owner: ndawn
4254 REVOKE ALL ON TABLE planet_stats FROM PUBLIC;
4255 REVOKE ALL ON TABLE planet_stats FROM ndawn;
4256 GRANT ALL ON TABLE planet_stats TO ndawn;
4257 GRANT SELECT ON TABLE planet_stats TO intel;
4261 -- Name: planets; Type: ACL; Schema: public; Owner: ndawn
4264 REVOKE ALL ON TABLE planets FROM PUBLIC;
4265 REVOKE ALL ON TABLE planets FROM ndawn;
4266 GRANT ALL ON TABLE planets TO ndawn;
4267 GRANT SELECT ON TABLE planets TO intel;
4271 -- Name: current_planet_stats; Type: ACL; Schema: public; Owner: ndawn
4274 REVOKE ALL ON TABLE current_planet_stats FROM PUBLIC;
4275 REVOKE ALL ON TABLE current_planet_stats FROM ndawn;
4276 GRANT ALL ON TABLE current_planet_stats TO ndawn;
4277 GRANT SELECT ON TABLE current_planet_stats TO intel;
4281 -- Name: alliance_resources; Type: ACL; Schema: public; Owner: ndawn
4284 REVOKE ALL ON TABLE alliance_resources FROM PUBLIC;
4285 REVOKE ALL ON TABLE alliance_resources FROM ndawn;
4286 GRANT ALL ON TABLE alliance_resources TO ndawn;
4287 GRANT SELECT ON TABLE alliance_resources TO intel;
4291 -- Name: available_planet_tags; Type: ACL; Schema: public; Owner: ndawn
4294 REVOKE ALL ON TABLE available_planet_tags FROM PUBLIC;
4295 REVOKE ALL ON TABLE available_planet_tags FROM ndawn;
4296 GRANT ALL ON TABLE available_planet_tags TO ndawn;
4297 GRANT SELECT ON TABLE available_planet_tags TO intel;
4301 -- Name: fleet_ships; Type: ACL; Schema: public; Owner: ndawn
4304 REVOKE ALL ON TABLE fleet_ships FROM PUBLIC;
4305 REVOKE ALL ON TABLE fleet_ships FROM ndawn;
4306 GRANT ALL ON TABLE fleet_ships TO ndawn;
4307 GRANT SELECT ON TABLE fleet_ships TO intel;
4311 -- Name: fleets; Type: ACL; Schema: public; Owner: ndawn
4314 REVOKE ALL ON TABLE fleets FROM PUBLIC;
4315 REVOKE ALL ON TABLE fleets FROM ndawn;
4316 GRANT ALL ON TABLE fleets TO ndawn;
4317 GRANT SELECT ON TABLE fleets TO intel;
4321 -- Name: launch_confirmations; Type: ACL; Schema: public; Owner: ndawn
4324 REVOKE ALL ON TABLE launch_confirmations FROM PUBLIC;
4325 REVOKE ALL ON TABLE launch_confirmations FROM ndawn;
4326 GRANT ALL ON TABLE launch_confirmations TO ndawn;
4327 GRANT SELECT ON TABLE launch_confirmations TO intel;
4331 -- Name: current_planet_stats_full; Type: ACL; Schema: public; Owner: ndawn
4334 REVOKE ALL ON TABLE current_planet_stats_full FROM PUBLIC;
4335 REVOKE ALL ON TABLE current_planet_stats_full FROM ndawn;
4336 GRANT ALL ON TABLE current_planet_stats_full TO ndawn;
4337 GRANT SELECT ON TABLE current_planet_stats_full TO intel;
4341 -- Name: fleet_scans; Type: ACL; Schema: public; Owner: ndawn
4344 REVOKE ALL ON TABLE fleet_scans FROM PUBLIC;
4345 REVOKE ALL ON TABLE fleet_scans FROM ndawn;
4346 GRANT ALL ON TABLE fleet_scans TO ndawn;
4347 GRANT SELECT ON TABLE fleet_scans TO intel;
4351 -- Name: intel; Type: ACL; Schema: public; Owner: ndawn
4354 REVOKE ALL ON TABLE intel FROM PUBLIC;
4355 REVOKE ALL ON TABLE intel FROM ndawn;
4356 GRANT ALL ON TABLE intel TO ndawn;
4357 GRANT SELECT ON TABLE intel TO intel;
4361 -- Name: full_intel; Type: ACL; Schema: public; Owner: ndawn
4364 REVOKE ALL ON TABLE full_intel FROM PUBLIC;
4365 REVOKE ALL ON TABLE full_intel FROM ndawn;
4366 GRANT ALL ON TABLE full_intel TO ndawn;
4367 GRANT SELECT ON TABLE full_intel TO intel;
4371 -- Name: galaxies; Type: ACL; Schema: public; Owner: ndawn
4374 REVOKE ALL ON TABLE galaxies FROM PUBLIC;
4375 REVOKE ALL ON TABLE galaxies FROM ndawn;
4376 GRANT ALL ON TABLE galaxies TO ndawn;
4377 GRANT SELECT ON TABLE galaxies TO intel;
4381 -- Name: intel_scans; Type: ACL; Schema: public; Owner: ndawn
4384 REVOKE ALL ON TABLE intel_scans FROM PUBLIC;
4385 REVOKE ALL ON TABLE intel_scans FROM ndawn;
4386 GRANT ALL ON TABLE intel_scans TO ndawn;
4387 GRANT SELECT ON TABLE intel_scans TO intel;
4391 -- Name: planet_tags; Type: ACL; Schema: public; Owner: ndawn
4394 REVOKE ALL ON TABLE planet_tags FROM PUBLIC;
4395 REVOKE ALL ON TABLE planet_tags FROM ndawn;
4396 GRANT ALL ON TABLE planet_tags TO ndawn;
4397 GRANT SELECT ON TABLE planet_tags TO intel;
4401 -- Name: scans; Type: ACL; Schema: public; Owner: ndawn
4404 REVOKE ALL ON TABLE scans FROM PUBLIC;
4405 REVOKE ALL ON TABLE scans FROM ndawn;
4406 GRANT ALL ON TABLE scans TO ndawn;
4407 GRANT SELECT ON TABLE scans TO intel;
4411 -- PostgreSQL database dump complete