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');
776 ALTER TABLE planets ADD COLUMN id text UNIQUE NOT NULL;
779 ALTER TABLE planets OWNER TO ndawn;
782 -- Name: current_planet_stats; Type: VIEW; Schema: public; Owner: ndawn
785 CREATE VIEW current_planet_stats AS
810 FROM ((( SELECT planet_stats.pid,
819 planet_stats.sizerank,
820 planet_stats.scorerank,
821 planet_stats.valuerank,
824 WHERE (planet_stats.tick = ( SELECT max(planet_stats_1.tick) AS max
825 FROM planet_stats planet_stats_1))) ps
826 JOIN planets p USING (pid))
827 LEFT JOIN alliances a USING (alliance));
830 ALTER TABLE current_planet_stats OWNER TO ndawn;
833 -- Name: alliance_resources; Type: VIEW; Schema: public; Owner: ndawn
836 CREATE VIEW alliance_resources AS
837 WITH planet_estimates AS (
843 ((ps.metal + ps.crystal) + ps.eonium) AS resources,
844 ((p.score + (((ps.metal + ps.crystal) + ps.eonium) / 300)) + (ps.hidden / 100)) AS nscore2,
845 ((((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)) +
849 ELSE ((COALESCE(ds.extraction, 3) * 3000) * 3)
850 END)))::numeric * (1.35 + (0.005 * (COALESCE(ds.fincents, 20))::numeric))) / (100)::numeric)) AS nscore3
851 FROM ((current_planet_stats p
852 JOIN current_planet_scans ps USING (pid))
853 LEFT JOIN current_development_scans ds USING (pid))
855 SELECT planet_estimates.tick,
856 planet_estimates.alliance,
857 planet_estimates.hidden,
858 planet_estimates.size,
859 planet_estimates.score,
860 planet_estimates.resources,
861 planet_estimates.nscore2,
862 planet_estimates.nscore3,
863 rank() OVER (PARTITION BY planet_estimates.alliance ORDER BY planet_estimates.score DESC) AS rank
864 FROM planet_estimates
866 SELECT planet_ranks.alliance,
867 sum(planet_ranks.resources) AS resources,
868 sum(planet_ranks.hidden) AS hidden,
869 (sum(planet_ranks.nscore2))::bigint AS nscore2,
870 (sum(planet_ranks.nscore3))::bigint AS nscore3,
872 sum(planet_ranks.score) AS score,
873 sum(planet_ranks.size) AS size,
874 (avg(planet_ranks.tick))::integer AS avgtick
876 WHERE (planet_ranks.rank <= 60)
877 GROUP BY planet_ranks.alliance
890 ((((s.score)::numeric + (r.resources / (300)::numeric)) + (r.hidden / (100)::numeric)))::bigint AS nscore,
895 JOIN top_planets r USING (alliance))
896 LEFT JOIN ( SELECT alliance_stats.aid,
897 alliance_stats.score,
899 alliance_stats.members
901 WHERE (alliance_stats.tick = ( SELECT max(alliance_stats_1.tick) AS max
902 FROM alliance_stats alliance_stats_1))) s USING (aid));
905 ALTER TABLE alliance_resources OWNER TO ndawn;
908 -- Name: alliances_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
911 CREATE SEQUENCE alliances_id_seq
919 ALTER TABLE alliances_id_seq OWNER TO ndawn;
922 -- Name: alliances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
925 ALTER SEQUENCE alliances_id_seq OWNED BY alliances.aid;
929 -- Name: available_planet_tags; Type: TABLE; Schema: public; Owner: ndawn
932 CREATE TABLE available_planet_tags (
937 ALTER TABLE available_planet_tags OWNER TO ndawn;
940 -- Name: fleet_ships; Type: TABLE; Schema: public; Owner: ndawn
943 CREATE TABLE fleet_ships (
944 fid integer NOT NULL,
946 amount integer NOT NULL,
951 ALTER TABLE fleet_ships OWNER TO ndawn;
954 -- Name: fleets; Type: TABLE; Schema: public; Owner: ndawn
957 CREATE TABLE fleets (
958 mission text NOT NULL,
959 tick integer NOT NULL,
960 fid integer NOT NULL,
961 pid integer NOT NULL,
962 amount integer NOT NULL,
967 ALTER TABLE fleets OWNER TO ndawn;
970 -- Name: launch_confirmations; Type: TABLE; Schema: public; Owner: ndawn
973 CREATE TABLE launch_confirmations (
974 fid integer NOT NULL,
975 uid integer NOT NULL,
976 pid integer NOT NULL,
977 landing_tick integer NOT NULL,
978 eta integer NOT NULL,
979 back integer NOT NULL,
982 WITH (fillfactor='75');
985 ALTER TABLE launch_confirmations OWNER TO ndawn;
988 -- Name: ticks; Type: TABLE; Schema: public; Owner: ndawn
996 ALTER TABLE ticks OWNER TO ndawn;
999 -- Name: users; Type: TABLE; Schema: public; Owner: ndawn
1002 CREATE TABLE users (
1003 uid integer NOT NULL,
1004 username citext NOT NULL,
1007 attack_points numeric(3,0) DEFAULT 0 NOT NULL,
1008 defense_points numeric(4,1) DEFAULT 0 NOT NULL,
1009 scan_points numeric(5,0) DEFAULT 0 NOT NULL,
1010 humor_points numeric(3,0) DEFAULT 0 NOT NULL,
1011 hostmask citext NOT NULL,
1014 laston timestamp with time zone,
1015 ftid integer NOT NULL,
1018 pnick citext NOT NULL,
1021 timezone text DEFAULT 'GMT'::text NOT NULL,
1022 call_if_needed boolean DEFAULT false NOT NULL,
1023 sms_note text DEFAULT ''::text NOT NULL
1025 WITH (fillfactor='50');
1028 ALTER TABLE users OWNER TO ndawn;
1031 -- Name: ships_home; Type: VIEW; Schema: public; Owner: ndawn
1034 CREATE VIEW ships_home AS
1040 COALESCE((f.amount - o.amount), (f.amount)::bigint) AS amount,
1041 COALESCE(o.fleets, (3)::bigint) AS fleets
1043 JOIN ( SELECT f_1.t AS tick,
1047 FROM (( SELECT DISTINCT ON (ticks.t, f_2.pid, f_2.mission) ticks.t,
1052 CROSS JOIN fleets f_2)
1053 WHERE ((f_2.tick <= ticks.t) AND (f_2.name = ANY (ARRAY['Main'::text, 'Advanced Unit'::text])) AND (f_2.mission = 'Full fleet'::text))
1054 ORDER BY ticks.t, f_2.pid, f_2.mission, f_2.tick DESC, f_2.fid DESC) f_1
1055 JOIN fleet_ships fs USING (fid))) f USING (pid))
1056 LEFT JOIN ( SELECT ticks.t AS tick,
1059 sum(fs.amount) AS amount,
1060 (3 - count(DISTINCT f_1.fid)) AS fleets
1062 CROSS JOIN fleets f_1)
1063 JOIN ( SELECT launch_confirmations.landing_tick,
1064 launch_confirmations.fid,
1065 launch_confirmations.back,
1066 launch_confirmations.eta
1067 FROM launch_confirmations) lc USING (fid))
1068 JOIN fleet_ships fs USING (fid))
1069 WHERE ((lc.back > ticks.t) AND (((lc.landing_tick - lc.eta) - 12) < ticks.t))
1070 GROUP BY ticks.t, f_1.pid, fs.ship) o USING (tick, pid, ship))
1071 WHERE (COALESCE((f.amount - o.amount), (f.amount)::bigint) > 0);
1074 ALTER TABLE ships_home OWNER TO ndawn;
1077 -- Name: available_ships; Type: VIEW; Schema: public; Owner: ndawn
1080 CREATE VIEW available_ships AS
1081 SELECT ships_home.uid,
1082 ships_home.username,
1088 WHERE (ships_home.tick = tick());
1091 ALTER TABLE available_ships OWNER TO ndawn;
1094 -- Name: call_statuses; Type: TABLE; Schema: public; Owner: ndawn
1097 CREATE TABLE call_statuses (
1098 status text NOT NULL
1102 ALTER TABLE call_statuses OWNER TO ndawn;
1105 -- Name: calls; Type: TABLE; Schema: public; Owner: ndawn
1108 CREATE TABLE calls (
1109 call integer NOT NULL,
1110 uid integer NOT NULL,
1112 landing_tick integer NOT NULL,
1114 ftid integer NOT NULL,
1115 calc text DEFAULT ''::text NOT NULL,
1116 status text DEFAULT 'Open'::text NOT NULL
1120 ALTER TABLE calls OWNER TO ndawn;
1123 -- Name: calls_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1126 CREATE SEQUENCE calls_id_seq
1134 ALTER TABLE calls_id_seq OWNER TO ndawn;
1137 -- Name: calls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1140 ALTER SEQUENCE calls_id_seq OWNED BY calls.call;
1144 -- Name: channel_flags; Type: TABLE; Schema: public; Owner: ndawn
1147 CREATE TABLE channel_flags (
1149 flag character(1) NOT NULL
1153 ALTER TABLE channel_flags OWNER TO ndawn;
1156 -- Name: channel_group_flags; Type: TABLE; Schema: public; Owner: ndawn
1159 CREATE TABLE channel_group_flags (
1160 channel citext NOT NULL,
1161 gid character(1) NOT NULL,
1162 flag character(1) NOT NULL
1166 ALTER TABLE channel_group_flags OWNER TO ndawn;
1169 -- Name: channels; Type: TABLE; Schema: public; Owner: ndawn
1172 CREATE TABLE channels (
1173 channel citext NOT NULL,
1174 description text NOT NULL
1178 ALTER TABLE channels OWNER TO ndawn;
1181 -- Name: clickatell; Type: TABLE; Schema: public; Owner: ndawn
1184 CREATE TABLE clickatell (
1185 api_id text NOT NULL,
1186 username text NOT NULL,
1187 password text NOT NULL
1191 ALTER TABLE clickatell OWNER TO ndawn;
1194 -- Name: covop_attacks; Type: TABLE; Schema: public; Owner: ndawn
1197 CREATE TABLE covop_attacks (
1198 uid integer NOT NULL,
1199 tick integer NOT NULL,
1200 pid integer NOT NULL
1204 ALTER TABLE covop_attacks OWNER TO ndawn;
1207 -- Name: current_planet_stats_full; Type: VIEW; Schema: public; Owner: ndawn
1210 CREATE VIEW current_planet_stats_full AS
1246 ps.sizerank_gain_day,
1247 ps.scorerank_gain_day,
1248 ps.valuerank_gain_day,
1251 alliances.relationship
1253 JOIN ( SELECT planet_stats.pid,
1262 planet_stats.sizerank,
1263 planet_stats.scorerank,
1264 planet_stats.valuerank,
1265 planet_stats.xprank,
1266 planet_stats.size_gain,
1267 planet_stats.score_gain,
1268 planet_stats.value_gain,
1269 planet_stats.xp_gain,
1270 planet_stats.sizerank_gain,
1271 planet_stats.scorerank_gain,
1272 planet_stats.valuerank_gain,
1273 planet_stats.xprank_gain,
1274 planet_stats.size_gain_day,
1275 planet_stats.score_gain_day,
1276 planet_stats.value_gain_day,
1277 planet_stats.xp_gain_day,
1278 planet_stats.sizerank_gain_day,
1279 planet_stats.scorerank_gain_day,
1280 planet_stats.valuerank_gain_day,
1281 planet_stats.xprank_gain_day
1283 WHERE (planet_stats.tick = ( SELECT max(planet_stats_1.tick) AS max
1284 FROM planet_stats planet_stats_1))) ps USING (pid))
1285 LEFT JOIN alliances USING (alliance));
1288 ALTER TABLE current_planet_stats_full OWNER TO ndawn;
1291 -- Name: ship_stats; Type: TABLE; Schema: public; Owner: ndawn
1294 CREATE TABLE ship_stats (
1296 class text NOT NULL,
1299 init integer NOT NULL,
1300 armor integer NOT NULL,
1301 damage integer NOT NULL,
1302 metal integer NOT NULL,
1303 crystal integer NOT NULL,
1304 eonium integer NOT NULL,
1306 guns integer DEFAULT 0 NOT NULL,
1307 eres integer DEFAULT 0 NOT NULL,
1314 ALTER TABLE ship_stats OWNER TO ndawn;
1317 -- Name: def_leeches; Type: VIEW; Schema: public; Owner: ndawn
1320 CREATE VIEW def_leeches AS
1329 sum((((fs.amount * ((s.metal + s.crystal) + s.eonium)))::numeric / 100.0)) AS value
1330 FROM (((launch_confirmations lc
1331 JOIN fleets f USING (fid))
1332 JOIN fleet_ships fs USING (fid))
1333 JOIN ship_stats s ON ((fs.ship = s.ship)))
1334 WHERE (f.mission = 'Defend'::text)
1335 GROUP BY lc.uid, lc.fid, lc.pid, f.pid, lc.landing_tick, lc.eta, lc.back
1338 sum((f.value / (COALESCE(p.value, ( SELECT planet_stats.value
1340 WHERE ((planet_stats.pid = f.fpid) AND (planet_stats.tick = (c.landing_tick - f.eta)))
1341 ORDER BY planet_stats.tick DESC
1342 LIMIT 1)))::numeric)) AS sent_value
1344 JOIN users u USING (uid))
1345 JOIN f USING (pid, landing_tick))
1346 LEFT JOIN ( SELECT planet_stats.pid AS fpid,
1348 planet_stats.tick AS landing_tick
1349 FROM planet_stats) p USING (fpid, landing_tick))
1355 count(d.call) AS calls,
1356 sum(d.fleets) AS fleets,
1357 sum(d.recalled) AS recalled,
1358 count(NULLIF(d.fleets, 0)) AS defended_calls,
1359 (sum(d.value))::numeric(4,2) AS value,
1360 (f2.sent_value)::numeric(4,2) AS sent_value
1361 FROM (( SELECT u.uid,
1365 count(f.back) AS fleets,
1366 count(NULLIF((((f.landing_tick + f.eta) - 1) = f.back), true)) AS recalled,
1367 sum((f.value / (COALESCE(p.value, ( SELECT planet_stats.value
1369 WHERE ((planet_stats.pid = f.pid) AND (planet_stats.tick = (c.landing_tick - f.eta)))
1370 ORDER BY planet_stats.tick DESC
1371 LIMIT 1)))::numeric)) AS value
1373 JOIN calls c USING (uid))
1374 LEFT JOIN f USING (pid, landing_tick))
1375 LEFT JOIN ( SELECT planet_stats.pid,
1377 planet_stats.tick AS landing_tick
1378 FROM planet_stats) p USING (pid, landing_tick))
1379 GROUP BY u.uid, u.username, u.defense_points, c.call) d
1380 LEFT JOIN f2 USING (uid))
1381 GROUP BY d.uid, d.username, d.defense_points, f2.sent_value;
1384 ALTER TABLE def_leeches OWNER TO ndawn;
1387 -- Name: incomings; Type: TABLE; Schema: public; Owner: ndawn
1390 CREATE TABLE incomings (
1391 call integer NOT NULL,
1392 pid integer NOT NULL,
1393 eta integer NOT NULL,
1394 amount integer NOT NULL,
1395 fleet text NOT NULL,
1396 shiptype text DEFAULT '?'::text NOT NULL,
1397 inc integer NOT NULL
1401 ALTER TABLE incomings OWNER TO ndawn;
1404 -- Name: defcalls; Type: VIEW; Schema: public; Owner: ndawn
1407 CREATE VIEW defcalls AS
1413 (c.landing_tick - tick()) AS curreta,
1414 array_agg(COALESCE((p2.race)::text, ''::text)) AS race,
1415 array_agg(COALESCE(i.amount, 0)) AS amount,
1416 array_agg(COALESCE(i.eta, 0)) AS eta,
1417 array_agg(COALESCE(i.shiptype, ''::text)) AS shiptype,
1418 array_agg(COALESCE(p2.alliance, '?'::text)) AS alliance,
1419 array_agg(coords(p2.x, p2.y, p2.z)) AS attackers
1421 LEFT JOIN incomings i USING (call))
1422 LEFT JOIN current_planet_stats p2 USING (pid))
1423 LEFT JOIN users dc ON ((c.dc = dc.uid)))
1424 GROUP BY c.call, c.uid, dc.username, c.landing_tick, c.status;
1427 ALTER TABLE defcalls OWNER TO ndawn;
1430 -- Name: defense_missions; Type: TABLE; Schema: public; Owner: ndawn
1433 CREATE TABLE defense_missions (
1434 call integer NOT NULL,
1435 fleet integer NOT NULL,
1436 announced boolean DEFAULT false NOT NULL,
1437 pointed boolean DEFAULT false NOT NULL
1441 ALTER TABLE defense_missions OWNER TO ndawn;
1444 -- Name: dumps; Type: TABLE; Schema: public; Owner: ndawn
1447 CREATE TABLE dumps (
1448 tick integer NOT NULL,
1451 modified integer DEFAULT 0 NOT NULL
1455 ALTER TABLE dumps OWNER TO ndawn;
1458 -- Name: email_change; Type: TABLE; Schema: public; Owner: ndawn
1461 CREATE TABLE email_change (
1462 id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
1463 uid integer NOT NULL,
1464 email text NOT NULL,
1465 confirmed boolean DEFAULT false NOT NULL
1469 ALTER TABLE email_change OWNER TO ndawn;
1472 -- Name: fleet_scans; Type: TABLE; Schema: public; Owner: ndawn
1475 CREATE TABLE fleet_scans (
1476 fid integer NOT NULL,
1481 ALTER TABLE fleet_scans OWNER TO ndawn;
1484 -- Name: fleet_ships_num_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1487 CREATE SEQUENCE fleet_ships_num_seq
1495 ALTER TABLE fleet_ships_num_seq OWNER TO ndawn;
1498 -- Name: fleet_ships_num_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1501 ALTER SEQUENCE fleet_ships_num_seq OWNED BY fleet_ships.num;
1505 -- Name: fleets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1508 CREATE SEQUENCE fleets_id_seq
1516 ALTER TABLE fleets_id_seq OWNER TO ndawn;
1519 -- Name: fleets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1522 ALTER SEQUENCE fleets_id_seq OWNED BY fleets.fid;
1526 -- Name: forum_access; Type: TABLE; Schema: public; Owner: ndawn
1529 CREATE TABLE forum_access (
1530 fbid integer NOT NULL,
1531 gid character(1) NOT NULL,
1532 post boolean DEFAULT false NOT NULL,
1533 moderate boolean DEFAULT false NOT NULL
1537 ALTER TABLE forum_access OWNER TO ndawn;
1540 -- Name: forum_boards; Type: TABLE; Schema: public; Owner: ndawn
1543 CREATE TABLE forum_boards (
1544 fbid integer NOT NULL,
1545 fcid integer NOT NULL,
1550 ALTER TABLE forum_boards OWNER TO ndawn;
1553 -- Name: forum_boards_fbid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1556 CREATE SEQUENCE forum_boards_fbid_seq
1564 ALTER TABLE forum_boards_fbid_seq OWNER TO ndawn;
1567 -- Name: forum_boards_fbid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1570 ALTER SEQUENCE forum_boards_fbid_seq OWNED BY forum_boards.fbid;
1574 -- Name: forum_categories; Type: TABLE; Schema: public; Owner: ndawn
1577 CREATE TABLE forum_categories (
1578 fcid integer NOT NULL,
1579 category text NOT NULL
1583 ALTER TABLE forum_categories OWNER TO ndawn;
1586 -- Name: forum_categories_fcid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1589 CREATE SEQUENCE forum_categories_fcid_seq
1597 ALTER TABLE forum_categories_fcid_seq OWNER TO ndawn;
1600 -- Name: forum_categories_fcid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1603 ALTER SEQUENCE forum_categories_fcid_seq OWNED BY forum_categories.fcid;
1607 -- Name: forum_posts; Type: TABLE; Schema: public; Owner: ndawn
1610 CREATE TABLE forum_posts (
1611 fpid integer NOT NULL,
1612 ftid integer NOT NULL,
1613 message text NOT NULL,
1614 "time" timestamp with time zone DEFAULT now() NOT NULL,
1615 uid integer NOT NULL,
1616 textsearch tsvector NOT NULL
1620 ALTER TABLE forum_posts OWNER TO ndawn;
1623 -- Name: forum_posts_fpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1626 CREATE SEQUENCE forum_posts_fpid_seq
1634 ALTER TABLE forum_posts_fpid_seq OWNER TO ndawn;
1637 -- Name: forum_posts_fpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1640 ALTER SEQUENCE forum_posts_fpid_seq OWNED BY forum_posts.fpid;
1644 -- Name: forum_priv_access; Type: TABLE; Schema: public; Owner: ndawn
1647 CREATE TABLE forum_priv_access (
1648 uid integer NOT NULL,
1649 ftid integer NOT NULL
1653 ALTER TABLE forum_priv_access OWNER TO ndawn;
1656 -- Name: forum_thread_visits; Type: TABLE; Schema: public; Owner: ndawn
1659 CREATE TABLE forum_thread_visits (
1660 uid integer NOT NULL,
1661 ftid integer NOT NULL,
1662 "time" timestamp with time zone DEFAULT now() NOT NULL
1664 WITH (fillfactor='50');
1667 ALTER TABLE forum_thread_visits OWNER TO ndawn;
1670 -- Name: forum_threads; Type: TABLE; Schema: public; Owner: ndawn
1673 CREATE TABLE forum_threads (
1674 ftid integer NOT NULL,
1675 fbid integer NOT NULL,
1676 subject text NOT NULL,
1677 sticky boolean DEFAULT false NOT NULL,
1678 uid integer NOT NULL,
1679 posts integer DEFAULT 0 NOT NULL,
1680 mtime timestamp with time zone DEFAULT now() NOT NULL,
1681 ctime timestamp with time zone DEFAULT now() NOT NULL
1683 WITH (fillfactor='50');
1686 ALTER TABLE forum_threads OWNER TO ndawn;
1689 -- Name: forum_threads_ftid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1692 CREATE SEQUENCE forum_threads_ftid_seq
1700 ALTER TABLE forum_threads_ftid_seq OWNER TO ndawn;
1703 -- Name: forum_threads_ftid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1706 ALTER SEQUENCE forum_threads_ftid_seq OWNED BY forum_threads.ftid;
1710 -- Name: groupmembers; Type: TABLE; Schema: public; Owner: ndawn
1713 CREATE TABLE groupmembers (
1714 gid character(1) NOT NULL,
1715 uid integer NOT NULL
1719 ALTER TABLE groupmembers OWNER TO ndawn;
1722 -- Name: users_defprio; Type: VIEW; Schema: public; Owner: ndawn
1725 CREATE VIEW users_defprio AS
1747 ((((((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
1749 LEFT JOIN current_planet_stats p USING (pid)),
1750 ( SELECT avg(u_1.attack_points) AS attack,
1751 avg(u_1.defense_points) AS defense,
1752 avg(p_1.size) AS size,
1753 avg(p_1.score) AS score,
1754 avg(p_1.value) AS value
1756 JOIN current_planet_stats p_1 USING (pid))
1757 WHERE (u_1.uid IN ( SELECT groupmembers.uid
1759 WHERE (groupmembers.gid = 'M'::bpchar)))) a;
1762 ALTER TABLE users_defprio OWNER TO ndawn;
1765 -- Name: full_defcalls; Type: VIEW; Schema: public; Owner: ndawn
1768 CREATE VIEW full_defcalls AS
1785 count(NULLIF((f.back = ((f.landing_tick + f.eta) - 1)), false)) AS fleets
1786 FROM (((users_defprio u
1787 JOIN current_planet_stats p USING (pid))
1788 JOIN defcalls c USING (uid))
1789 LEFT JOIN launch_confirmations f USING (pid, landing_tick))
1790 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;
1793 ALTER TABLE full_defcalls OWNER TO ndawn;
1796 -- Name: full_fleets; Type: TABLE; Schema: public; Owner: ndawn
1799 CREATE TABLE full_fleets (
1800 fid integer NOT NULL,
1801 uid integer NOT NULL
1805 ALTER TABLE full_fleets OWNER TO ndawn;
1808 -- Name: intel; Type: TABLE; Schema: public; Owner: ndawn
1811 CREATE TABLE intel (
1812 id integer NOT NULL,
1813 uid integer NOT NULL,
1814 sender integer NOT NULL,
1815 target integer NOT NULL,
1816 mission text NOT NULL,
1819 tick integer NOT NULL,
1820 eta integer NOT NULL,
1822 ingal boolean NOT NULL
1826 ALTER TABLE intel OWNER TO ndawn;
1829 -- Name: full_intel; Type: VIEW; Schema: public; Owner: ndawn
1832 CREATE VIEW full_intel AS
1833 SELECT s.alliance AS salliance,
1834 coords(s.x, s.y, s.z) AS scoords,
1837 t.alliance AS talliance,
1838 coords(t.x, t.y, t.z) AS tcoords,
1849 JOIN users u USING (uid))
1850 JOIN current_planet_stats t ON ((i.target = t.pid)))
1851 JOIN current_planet_stats s ON ((i.sender = s.pid)))
1852 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;
1855 ALTER TABLE full_intel OWNER TO ndawn;
1858 -- Name: galaxies; Type: TABLE; Schema: public; Owner: ndawn
1861 CREATE TABLE galaxies (
1864 tick integer NOT NULL,
1865 size integer NOT NULL,
1866 score integer NOT NULL,
1867 value integer NOT NULL,
1868 xp integer NOT NULL,
1869 planets integer NOT NULL,
1870 sizerank integer NOT NULL,
1871 scorerank integer NOT NULL,
1872 valuerank integer NOT NULL,
1873 xprank integer NOT NULL,
1874 size_gain integer NOT NULL,
1875 score_gain integer NOT NULL,
1876 value_gain integer NOT NULL,
1877 xp_gain integer NOT NULL,
1878 planets_gain integer NOT NULL,
1879 sizerank_gain integer NOT NULL,
1880 scorerank_gain integer NOT NULL,
1881 valuerank_gain integer NOT NULL,
1882 xprank_gain integer NOT NULL,
1883 size_gain_day integer NOT NULL,
1884 score_gain_day integer NOT NULL,
1885 value_gain_day integer NOT NULL,
1886 xp_gain_day integer NOT NULL,
1887 planets_gain_day integer NOT NULL,
1888 sizerank_gain_day integer NOT NULL,
1889 scorerank_gain_day integer NOT NULL,
1890 valuerank_gain_day integer NOT NULL,
1891 xprank_gain_day integer NOT NULL
1895 ALTER TABLE galaxies OWNER TO ndawn;
1898 -- Name: group_roles; Type: TABLE; Schema: public; Owner: ndawn
1901 CREATE TABLE group_roles (
1902 gid character(1) NOT NULL,
1903 role character varying(32) NOT NULL
1907 ALTER TABLE group_roles OWNER TO ndawn;
1910 -- Name: groups; Type: TABLE; Schema: public; Owner: ndawn
1913 CREATE TABLE groups (
1914 groupname text NOT NULL,
1915 gid character(1) NOT NULL
1919 ALTER TABLE groups OWNER TO ndawn;
1922 -- Name: incomings_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1925 CREATE SEQUENCE incomings_id_seq
1933 ALTER TABLE incomings_id_seq OWNER TO ndawn;
1936 -- Name: incomings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1939 ALTER SEQUENCE incomings_id_seq OWNED BY incomings.inc;
1943 -- Name: intel_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1946 CREATE SEQUENCE intel_id_seq
1954 ALTER TABLE intel_id_seq OWNER TO ndawn;
1957 -- Name: intel_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
1960 ALTER SEQUENCE intel_id_seq OWNED BY intel.id;
1964 -- Name: intel_scans; Type: TABLE; Schema: public; Owner: ndawn
1967 CREATE TABLE intel_scans (
1968 id integer NOT NULL,
1969 intel integer NOT NULL
1973 ALTER TABLE intel_scans OWNER TO ndawn;
1976 -- Name: irc_requests; Type: TABLE; Schema: public; Owner: ndawn
1979 CREATE TABLE irc_requests (
1980 id integer NOT NULL,
1981 channel text NOT NULL,
1982 message text NOT NULL,
1983 sent boolean DEFAULT false NOT NULL,
1984 uid integer NOT NULL
1988 ALTER TABLE irc_requests OWNER TO ndawn;
1991 -- Name: irc_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
1994 CREATE SEQUENCE irc_requests_id_seq
2002 ALTER TABLE irc_requests_id_seq OWNER TO ndawn;
2005 -- Name: irc_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2008 ALTER SEQUENCE irc_requests_id_seq OWNED BY irc_requests.id;
2012 -- Name: last_smokes; Type: TABLE; Schema: public; Owner: ndawn
2015 CREATE TABLE last_smokes (
2016 nick citext NOT NULL,
2017 "time" timestamp with time zone NOT NULL
2021 ALTER TABLE last_smokes OWNER TO ndawn;
2024 -- Name: misc; Type: TABLE; Schema: public; Owner: ndawn
2033 ALTER TABLE misc OWNER TO ndawn;
2036 -- Name: planet_tags; Type: TABLE; Schema: public; Owner: ndawn
2039 CREATE TABLE planet_tags (
2040 pid integer NOT NULL,
2041 tag citext NOT NULL,
2042 uid integer NOT NULL,
2043 "time" timestamp with time zone DEFAULT now() NOT NULL
2047 ALTER TABLE planet_tags OWNER TO ndawn;
2050 -- Name: planets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2053 CREATE SEQUENCE planets_id_seq
2061 ALTER TABLE planets_id_seq OWNER TO ndawn;
2064 -- Name: planets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2067 ALTER SEQUENCE planets_id_seq OWNED BY planets.pid;
2071 -- Name: raid_access; Type: TABLE; Schema: public; Owner: ndawn
2074 CREATE TABLE raid_access (
2075 raid integer NOT NULL,
2076 gid character(1) NOT NULL
2080 ALTER TABLE raid_access OWNER TO ndawn;
2083 -- Name: raid_claims; Type: TABLE; Schema: public; Owner: ndawn
2086 CREATE TABLE raid_claims (
2087 target integer NOT NULL,
2088 uid integer NOT NULL,
2089 wave integer NOT NULL,
2090 joinable boolean DEFAULT false NOT NULL,
2091 launched boolean DEFAULT false NOT NULL,
2092 "timestamp" timestamp with time zone DEFAULT now() NOT NULL
2094 WITH (fillfactor='50');
2097 ALTER TABLE raid_claims OWNER TO ndawn;
2100 -- Name: raid_targets; Type: TABLE; Schema: public; Owner: ndawn
2103 CREATE TABLE raid_targets (
2104 id integer NOT NULL,
2105 raid integer NOT NULL,
2106 pid integer NOT NULL,
2108 modified timestamp with time zone DEFAULT now() NOT NULL
2110 WITH (fillfactor='50');
2113 ALTER TABLE raid_targets OWNER TO ndawn;
2116 -- Name: raid_targets_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2119 CREATE SEQUENCE raid_targets_id_seq
2127 ALTER TABLE raid_targets_id_seq OWNER TO ndawn;
2130 -- Name: raid_targets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2133 ALTER SEQUENCE raid_targets_id_seq OWNED BY raid_targets.id;
2137 -- Name: raids; Type: TABLE; Schema: public; Owner: ndawn
2140 CREATE TABLE raids (
2141 id integer NOT NULL,
2142 tick integer NOT NULL,
2143 open boolean DEFAULT false NOT NULL,
2144 waves integer DEFAULT 3 NOT NULL,
2145 message text NOT NULL,
2146 removed boolean DEFAULT false NOT NULL,
2147 released_coords boolean DEFAULT false NOT NULL,
2148 ftid integer NOT NULL
2152 ALTER TABLE raids OWNER TO ndawn;
2155 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2158 CREATE SEQUENCE raids_id_seq
2166 ALTER TABLE raids_id_seq OWNER TO ndawn;
2169 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2172 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
2176 -- Name: roles; Type: TABLE; Schema: public; Owner: ndawn
2179 CREATE TABLE roles (
2180 role character varying(32) NOT NULL
2184 ALTER TABLE roles OWNER TO ndawn;
2187 -- Name: scan_requests; Type: TABLE; Schema: public; Owner: ndawn
2190 CREATE TABLE scan_requests (
2191 id integer NOT NULL,
2192 uid integer NOT NULL,
2193 pid integer NOT NULL,
2196 tick integer DEFAULT tick() NOT NULL,
2197 "time" timestamp with time zone DEFAULT now() NOT NULL,
2198 sent boolean DEFAULT false NOT NULL
2202 ALTER TABLE scan_requests OWNER TO ndawn;
2205 -- Name: scan_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2208 CREATE SEQUENCE scan_requests_id_seq
2216 ALTER TABLE scan_requests_id_seq OWNER TO ndawn;
2219 -- Name: scan_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2222 ALTER SEQUENCE scan_requests_id_seq OWNED BY scan_requests.id;
2226 -- Name: scans; Type: TABLE; Schema: public; Owner: ndawn
2229 CREATE TABLE scans (
2230 tick integer NOT NULL,
2231 scan_id text NOT NULL,
2234 uid integer DEFAULT '-1'::integer NOT NULL,
2235 groupscan boolean DEFAULT false NOT NULL,
2236 parsed boolean DEFAULT false NOT NULL,
2241 ALTER TABLE scans OWNER TO ndawn;
2244 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2247 CREATE SEQUENCE scans_id_seq
2255 ALTER TABLE scans_id_seq OWNER TO ndawn;
2258 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2261 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
2265 -- Name: session_log; Type: TABLE; Schema: public; Owner: ndawn
2268 CREATE TABLE session_log (
2269 uid integer NOT NULL,
2270 "time" timestamp with time zone NOT NULL,
2272 country character(2) NOT NULL,
2273 session text NOT NULL,
2274 remember boolean NOT NULL
2278 ALTER TABLE session_log OWNER TO ndawn;
2281 -- Name: ship_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2284 CREATE SEQUENCE ship_stats_id_seq
2292 ALTER TABLE ship_stats_id_seq OWNER TO ndawn;
2295 -- Name: ship_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2298 ALTER SEQUENCE ship_stats_id_seq OWNED BY ship_stats.id;
2302 -- Name: sms; Type: TABLE; Schema: public; Owner: ndawn
2306 id integer NOT NULL,
2308 uid integer NOT NULL,
2309 status text DEFAULT 'Waiting'::text NOT NULL,
2310 number text NOT NULL,
2311 message character varying(140) NOT NULL,
2312 cost numeric(4,2) DEFAULT 0 NOT NULL,
2313 "time" timestamp with time zone DEFAULT now() NOT NULL
2317 ALTER TABLE sms OWNER TO ndawn;
2320 -- Name: sms_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2323 CREATE SEQUENCE sms_id_seq
2331 ALTER TABLE sms_id_seq OWNER TO ndawn;
2334 -- Name: sms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2337 ALTER SEQUENCE sms_id_seq OWNED BY sms.id;
2341 -- Name: smslist; Type: TABLE; Schema: public; Owner: ndawn
2344 CREATE TABLE smslist (
2351 ALTER TABLE smslist OWNER TO ndawn;
2354 -- Name: table_updates; Type: VIEW; Schema: public; Owner: ndawn
2357 CREATE VIEW table_updates AS
2358 SELECT t.schemaname,
2364 WHEN (t.n_tup_upd > 0) THEN ((((t.n_tup_hot_upd)::numeric / (t.n_tup_upd)::numeric) * 100.0))::numeric(5,2)
2367 FROM (pg_stat_all_tables t
2369 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))));
2372 ALTER TABLE table_updates OWNER TO ndawn;
2375 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2378 CREATE SEQUENCE users_uid_seq
2386 ALTER TABLE users_uid_seq OWNER TO ndawn;
2389 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2392 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
2396 -- Name: wiki_namespace_access; Type: TABLE; Schema: public; Owner: ndawn
2399 CREATE TABLE wiki_namespace_access (
2400 namespace text NOT NULL,
2401 gid character(1) NOT NULL,
2402 edit boolean DEFAULT false NOT NULL,
2403 post boolean DEFAULT false NOT NULL,
2404 moderate boolean DEFAULT false NOT NULL
2408 ALTER TABLE wiki_namespace_access OWNER TO ndawn;
2411 -- Name: wiki_namespaces; Type: TABLE; Schema: public; Owner: ndawn
2414 CREATE TABLE wiki_namespaces (
2415 namespace character varying(16) NOT NULL
2419 ALTER TABLE wiki_namespaces OWNER TO ndawn;
2422 -- Name: wiki_page_access; Type: TABLE; Schema: public; Owner: ndawn
2425 CREATE TABLE wiki_page_access (
2426 wpid integer NOT NULL,
2427 uid integer NOT NULL,
2428 edit boolean DEFAULT false NOT NULL,
2429 moderate boolean DEFAULT false NOT NULL
2433 ALTER TABLE wiki_page_access OWNER TO ndawn;
2436 -- Name: wiki_page_revisions; Type: TABLE; Schema: public; Owner: ndawn
2439 CREATE TABLE wiki_page_revisions (
2441 wprev integer NOT NULL,
2444 comment text NOT NULL,
2445 "time" timestamp with time zone DEFAULT now() NOT NULL,
2450 ALTER TABLE wiki_page_revisions OWNER TO ndawn;
2453 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2456 CREATE SEQUENCE wiki_page_revisions_wprev_seq
2464 ALTER TABLE wiki_page_revisions_wprev_seq OWNER TO ndawn;
2467 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2470 ALTER SEQUENCE wiki_page_revisions_wprev_seq OWNED BY wiki_page_revisions.wprev;
2474 -- Name: wiki_pages; Type: TABLE; Schema: public; Owner: ndawn
2477 CREATE TABLE wiki_pages (
2478 wpid integer NOT NULL,
2479 name character varying(255) NOT NULL,
2480 namespace text DEFAULT ''::text NOT NULL,
2481 textsearch tsvector DEFAULT to_tsvector(''::text) NOT NULL,
2483 "time" timestamp with time zone DEFAULT now() NOT NULL
2487 ALTER TABLE wiki_pages OWNER TO ndawn;
2490 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2493 CREATE SEQUENCE wiki_pages_wpid_seq
2501 ALTER TABLE wiki_pages_wpid_seq OWNER TO ndawn;
2504 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2507 ALTER SEQUENCE wiki_pages_wpid_seq OWNED BY wiki_pages.wpid;
2511 -- Name: aid; Type: DEFAULT; Schema: public; Owner: ndawn
2514 ALTER TABLE ONLY alliances ALTER COLUMN aid SET DEFAULT nextval('alliances_id_seq'::regclass);
2518 -- Name: call; Type: DEFAULT; Schema: public; Owner: ndawn
2521 ALTER TABLE ONLY calls ALTER COLUMN call SET DEFAULT nextval('calls_id_seq'::regclass);
2525 -- Name: num; Type: DEFAULT; Schema: public; Owner: ndawn
2528 ALTER TABLE ONLY fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
2532 -- Name: fid; Type: DEFAULT; Schema: public; Owner: ndawn
2535 ALTER TABLE ONLY fleets ALTER COLUMN fid SET DEFAULT nextval('fleets_id_seq'::regclass);
2539 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: ndawn
2542 ALTER TABLE ONLY forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
2546 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: ndawn
2549 ALTER TABLE ONLY forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
2553 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: ndawn
2556 ALTER TABLE ONLY forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
2560 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: ndawn
2563 ALTER TABLE ONLY forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
2567 -- Name: inc; Type: DEFAULT; Schema: public; Owner: ndawn
2570 ALTER TABLE ONLY incomings ALTER COLUMN inc SET DEFAULT nextval('incomings_id_seq'::regclass);
2574 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2577 ALTER TABLE ONLY intel ALTER COLUMN id SET DEFAULT nextval('intel_id_seq'::regclass);
2581 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2584 ALTER TABLE ONLY irc_requests ALTER COLUMN id SET DEFAULT nextval('irc_requests_id_seq'::regclass);
2588 -- Name: pid; Type: DEFAULT; Schema: public; Owner: ndawn
2591 ALTER TABLE ONLY planets ALTER COLUMN pid SET DEFAULT nextval('planets_id_seq'::regclass);
2595 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2598 ALTER TABLE ONLY raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
2602 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2605 ALTER TABLE ONLY raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
2609 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2612 ALTER TABLE ONLY scan_requests ALTER COLUMN id SET DEFAULT nextval('scan_requests_id_seq'::regclass);
2616 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2619 ALTER TABLE ONLY scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
2623 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2626 ALTER TABLE ONLY ship_stats ALTER COLUMN id SET DEFAULT nextval('ship_stats_id_seq'::regclass);
2630 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2633 ALTER TABLE ONLY sms ALTER COLUMN id SET DEFAULT nextval('sms_id_seq'::regclass);
2637 -- Name: uid; Type: DEFAULT; Schema: public; Owner: ndawn
2640 ALTER TABLE ONLY users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
2644 -- Name: wprev; Type: DEFAULT; Schema: public; Owner: ndawn
2647 ALTER TABLE ONLY wiki_page_revisions ALTER COLUMN wprev SET DEFAULT nextval('wiki_page_revisions_wprev_seq'::regclass);
2651 -- Name: wpid; Type: DEFAULT; Schema: public; Owner: ndawn
2654 ALTER TABLE ONLY wiki_pages ALTER COLUMN wpid SET DEFAULT nextval('wiki_pages_wpid_seq'::regclass);
2658 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2661 ALTER TABLE ONLY users
2662 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
2666 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2669 ALTER TABLE ONLY alliance_stats
2670 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (aid, tick);
2674 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2677 ALTER TABLE ONLY alliances
2678 ADD CONSTRAINT alliances_name_key UNIQUE (alliance);
2682 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2685 ALTER TABLE ONLY alliances
2686 ADD CONSTRAINT alliances_pkey PRIMARY KEY (aid);
2690 -- Name: available_planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2693 ALTER TABLE ONLY available_planet_tags
2694 ADD CONSTRAINT available_planet_tags_pkey PRIMARY KEY (tag);
2698 -- Name: call_statuses_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2701 ALTER TABLE ONLY call_statuses
2702 ADD CONSTRAINT call_statuses_pkey PRIMARY KEY (status);
2706 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2709 ALTER TABLE ONLY calls
2710 ADD CONSTRAINT calls_member_key UNIQUE (uid, landing_tick);
2714 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2717 ALTER TABLE ONLY calls
2718 ADD CONSTRAINT calls_pkey PRIMARY KEY (call);
2722 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2725 ALTER TABLE ONLY channel_flags
2726 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
2730 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2733 ALTER TABLE ONLY channel_flags
2734 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (flag);
2738 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2741 ALTER TABLE ONLY channel_group_flags
2742 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, gid, flag);
2746 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2749 ALTER TABLE ONLY channels
2750 ADD CONSTRAINT channels_pkey PRIMARY KEY (channel);
2754 -- Name: clickatell_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2757 ALTER TABLE ONLY clickatell
2758 ADD CONSTRAINT clickatell_pkey PRIMARY KEY (api_id, username);
2762 -- Name: covop_attacks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2765 ALTER TABLE ONLY covop_attacks
2766 ADD CONSTRAINT covop_attacks_pkey PRIMARY KEY (pid, tick, uid);
2770 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2773 ALTER TABLE ONLY defense_missions
2774 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
2778 -- Name: development_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2781 ALTER TABLE ONLY development_scans
2782 ADD CONSTRAINT development_scans_pkey PRIMARY KEY (id);
2786 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2789 ALTER TABLE ONLY dumps
2790 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
2794 -- Name: email_change_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2797 ALTER TABLE ONLY email_change
2798 ADD CONSTRAINT email_change_pkey PRIMARY KEY (id);
2802 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2805 ALTER TABLE ONLY fleet_scans
2806 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (fid);
2810 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2813 ALTER TABLE ONLY fleet_ships
2814 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
2818 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2821 ALTER TABLE ONLY fleet_ships
2822 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (fid, ship);
2826 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2829 ALTER TABLE ONLY fleets
2830 ADD CONSTRAINT fleets_pkey PRIMARY KEY (fid);
2834 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2837 ALTER TABLE ONLY forum_access
2838 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
2842 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2845 ALTER TABLE ONLY forum_boards
2846 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
2850 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2853 ALTER TABLE ONLY forum_boards
2854 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
2858 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2861 ALTER TABLE ONLY forum_categories
2862 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
2866 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2869 ALTER TABLE ONLY forum_categories
2870 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
2874 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2877 ALTER TABLE ONLY forum_posts
2878 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
2882 -- Name: forum_priv_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2885 ALTER TABLE ONLY forum_priv_access
2886 ADD CONSTRAINT forum_priv_access_pkey PRIMARY KEY (uid, ftid);
2890 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2893 ALTER TABLE ONLY forum_thread_visits
2894 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
2898 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2901 ALTER TABLE ONLY forum_threads
2902 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
2906 -- Name: full_fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2909 ALTER TABLE ONLY full_fleets
2910 ADD CONSTRAINT full_fleets_pkey PRIMARY KEY (fid);
2914 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2917 ALTER TABLE ONLY galaxies
2918 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (tick, x, y);
2922 -- Name: group_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2925 ALTER TABLE ONLY group_roles
2926 ADD CONSTRAINT group_roles_pkey PRIMARY KEY (gid, role);
2930 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2933 ALTER TABLE ONLY groupmembers
2934 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2938 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2941 ALTER TABLE ONLY groups
2942 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2946 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2949 ALTER TABLE ONLY groups
2950 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2954 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2957 ALTER TABLE ONLY incomings
2958 ADD CONSTRAINT incomings_call_key UNIQUE (call, pid, fleet);
2962 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2965 ALTER TABLE ONLY incomings
2966 ADD CONSTRAINT incomings_pkey PRIMARY KEY (inc);
2970 -- Name: intel_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2973 ALTER TABLE ONLY intel
2974 ADD CONSTRAINT intel_pkey PRIMARY KEY (id);
2978 -- Name: intel_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2981 ALTER TABLE ONLY intel_scans
2982 ADD CONSTRAINT intel_scans_pkey PRIMARY KEY (id, intel);
2986 -- Name: irc_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2989 ALTER TABLE ONLY irc_requests
2990 ADD CONSTRAINT irc_requests_pkey PRIMARY KEY (id);
2994 -- Name: last_smokes_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2997 ALTER TABLE ONLY last_smokes
2998 ADD CONSTRAINT last_smokes_pkey PRIMARY KEY (nick);
3002 -- Name: launch_confirmations_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3005 ALTER TABLE ONLY launch_confirmations
3006 ADD CONSTRAINT launch_confirmations_pkey PRIMARY KEY (fid);
3010 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3013 ALTER TABLE ONLY misc
3014 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
3018 -- Name: planet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3021 ALTER TABLE ONLY planet_scans
3022 ADD CONSTRAINT planet_scans_pkey PRIMARY KEY (id);
3026 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3029 ALTER TABLE ONLY planet_stats
3030 ADD CONSTRAINT planet_stats_id_key UNIQUE (pid, tick);
3034 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3037 ALTER TABLE ONLY planet_stats
3038 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
3042 -- Name: planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3045 ALTER TABLE ONLY planet_tags
3046 ADD CONSTRAINT planet_tags_pkey PRIMARY KEY (pid, uid, tag);
3050 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3053 ALTER TABLE ONLY planets
3054 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
3058 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3061 ALTER TABLE ONLY planets
3062 ADD CONSTRAINT planets_pkey PRIMARY KEY (pid);
3066 -- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3069 ALTER TABLE ONLY planets
3070 ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
3074 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3077 ALTER TABLE ONLY raid_access
3078 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
3082 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3085 ALTER TABLE ONLY raid_claims
3086 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
3090 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3093 ALTER TABLE ONLY raid_targets
3094 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
3098 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3101 ALTER TABLE ONLY raid_targets
3102 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, pid);
3106 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3109 ALTER TABLE ONLY raids
3110 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
3114 -- Name: roles_role_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3117 ALTER TABLE ONLY roles
3118 ADD CONSTRAINT roles_role_key UNIQUE (role);
3122 -- Name: scan_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3125 ALTER TABLE ONLY scan_requests
3126 ADD CONSTRAINT scan_requests_pkey PRIMARY KEY (id);
3130 -- Name: scan_requests_tick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3133 ALTER TABLE ONLY scan_requests
3134 ADD CONSTRAINT scan_requests_tick_key UNIQUE (tick, pid, type, uid);
3138 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3141 ALTER TABLE ONLY scans
3142 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
3146 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3149 ALTER TABLE ONLY scans
3150 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
3154 -- Name: session_log_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3157 ALTER TABLE ONLY session_log
3158 ADD CONSTRAINT session_log_pkey PRIMARY KEY (uid, "time", ip);
3162 -- Name: ship_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3165 ALTER TABLE ONLY ship_stats
3166 ADD CONSTRAINT ship_stats_id_key UNIQUE (id);
3168 ALTER TABLE ship_stats CLUSTER ON ship_stats_id_key;
3172 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3175 ALTER TABLE ONLY ship_stats
3176 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (ship);
3180 -- Name: sms_msgid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3183 ALTER TABLE ONLY sms
3184 ADD CONSTRAINT sms_msgid_key UNIQUE (msgid);
3188 -- Name: sms_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3191 ALTER TABLE ONLY sms
3192 ADD CONSTRAINT sms_pkey PRIMARY KEY (id);
3196 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3199 ALTER TABLE ONLY smslist
3200 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
3204 -- Name: ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3207 ALTER TABLE ONLY ticks
3208 ADD CONSTRAINT ticks_pkey PRIMARY KEY (t);
3212 -- Name: users_hostmask_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3215 ALTER TABLE ONLY users
3216 ADD CONSTRAINT users_hostmask_key UNIQUE (hostmask);
3220 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3223 ALTER TABLE ONLY users
3224 ADD CONSTRAINT users_planet_key UNIQUE (pid);
3228 -- Name: users_pnick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3231 ALTER TABLE ONLY users
3232 ADD CONSTRAINT users_pnick_key UNIQUE (pnick);
3236 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3239 ALTER TABLE ONLY users
3240 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
3244 -- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3247 ALTER TABLE ONLY users
3248 ADD CONSTRAINT users_username_key UNIQUE (username);
3252 -- Name: wiki_namespace_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3255 ALTER TABLE ONLY wiki_namespace_access
3256 ADD CONSTRAINT wiki_namespace_access_pkey PRIMARY KEY (gid, namespace);
3260 -- Name: wiki_namespaces_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3263 ALTER TABLE ONLY wiki_namespaces
3264 ADD CONSTRAINT wiki_namespaces_pkey PRIMARY KEY (namespace);
3268 -- Name: wiki_page_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3271 ALTER TABLE ONLY wiki_page_access
3272 ADD CONSTRAINT wiki_page_access_pkey PRIMARY KEY (uid, wpid);
3276 -- Name: wiki_page_revisions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3279 ALTER TABLE ONLY wiki_page_revisions
3280 ADD CONSTRAINT wiki_page_revisions_pkey PRIMARY KEY (wprev);
3284 -- Name: wiki_pages_namespace_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3287 ALTER TABLE ONLY wiki_pages
3288 ADD CONSTRAINT wiki_pages_namespace_key UNIQUE (namespace, name);
3292 -- Name: wiki_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3295 ALTER TABLE ONLY wiki_pages
3296 ADD CONSTRAINT wiki_pages_pkey PRIMARY KEY (wpid);
3300 -- Name: development_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3303 CREATE INDEX development_scans_planet_index ON development_scans USING btree (pid, tick);
3307 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: ndawn
3310 CREATE INDEX fleets_sender_index ON fleets USING btree (pid);
3314 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: ndawn
3317 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
3321 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3324 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
3328 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn
3331 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
3335 -- Name: intel_tick_index; Type: INDEX; Schema: public; Owner: ndawn
3338 CREATE INDEX intel_tick_index ON intel USING btree (tick);
3342 -- Name: planet_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3345 CREATE INDEX planet_scans_planet_index ON planet_scans USING btree (pid, tick);
3349 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: ndawn
3352 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
3356 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: ndawn
3359 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
3363 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: ndawn
3366 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
3370 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: ndawn
3373 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
3377 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: ndawn
3380 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance);
3384 -- Name: scan_requests_time_not_sent_index; Type: INDEX; Schema: public; Owner: ndawn
3387 CREATE INDEX scan_requests_time_not_sent_index ON scan_requests USING btree ("time") WHERE (NOT sent);
3391 -- Name: scans_not_parsed_index; Type: INDEX; Schema: public; Owner: ndawn
3394 CREATE INDEX scans_not_parsed_index ON scans USING btree (groupscan) WHERE (NOT parsed);
3398 -- Name: scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3401 CREATE INDEX scans_planet_index ON scans USING btree (pid, type, tick);
3405 -- Name: sms_status_msgid_idx; Type: INDEX; Schema: public; Owner: ndawn
3408 CREATE INDEX sms_status_msgid_idx ON sms USING btree (status) WHERE (msgid IS NULL);
3412 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: ndawn
3415 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
3419 -- Name: users_birthday_index; Type: INDEX; Schema: public; Owner: ndawn
3422 CREATE INDEX users_birthday_index ON users USING btree (mmdd(birthday)) WHERE (birthday IS NOT NULL);
3426 -- Name: wiki_pages_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3429 CREATE INDEX wiki_pages_textsearch_index ON wiki_pages USING gin (textsearch);
3433 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: ndawn
3436 CREATE TRIGGER add_call BEFORE INSERT ON calls FOR EACH ROW EXECUTE PROCEDURE add_call();
3440 -- Name: add_raid; Type: TRIGGER; Schema: public; Owner: ndawn
3443 CREATE TRIGGER add_raid BEFORE INSERT ON raids FOR EACH ROW EXECUTE PROCEDURE add_raid();
3447 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: ndawn
3450 CREATE TRIGGER add_remove_member AFTER INSERT OR DELETE ON groupmembers FOR EACH ROW EXECUTE PROCEDURE change_member();
3454 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: ndawn
3457 CREATE TRIGGER add_user BEFORE INSERT ON users FOR EACH ROW EXECUTE PROCEDURE add_user();
3461 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: ndawn
3464 CREATE TRIGGER update_forum_post BEFORE INSERT OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_post();
3468 -- Name: update_forum_thread_posts; Type: TRIGGER; Schema: public; Owner: ndawn
3471 CREATE TRIGGER update_forum_thread_posts AFTER INSERT OR DELETE OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_thread_posts();
3475 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: ndawn
3478 CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
3482 -- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn
3485 CREATE TRIGGER update_wiki_page BEFORE UPDATE ON wiki_pages FOR EACH ROW EXECUTE PROCEDURE update_wiki_page();
3489 -- Name: updated_claim; Type: TRIGGER; Schema: public; Owner: ndawn
3492 CREATE TRIGGER updated_claim AFTER INSERT OR DELETE OR UPDATE ON raid_claims FOR EACH ROW EXECUTE PROCEDURE updated_claim();
3496 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3499 ALTER TABLE ONLY alliance_stats
3500 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (aid) REFERENCES alliances(aid);
3504 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3507 ALTER TABLE ONLY calls
3508 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
3512 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3515 ALTER TABLE ONLY calls
3516 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
3520 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3523 ALTER TABLE ONLY calls
3524 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3528 -- Name: calls_status_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3531 ALTER TABLE ONLY calls
3532 ADD CONSTRAINT calls_status_fkey FOREIGN KEY (status) REFERENCES call_statuses(status);
3536 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3539 ALTER TABLE ONLY channel_group_flags
3540 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(channel) ON UPDATE CASCADE ON DELETE CASCADE;
3544 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3547 ALTER TABLE ONLY channel_group_flags
3548 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(flag) ON UPDATE CASCADE ON DELETE CASCADE;
3552 -- Name: channel_group_flags_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3555 ALTER TABLE ONLY channel_group_flags
3556 ADD CONSTRAINT channel_group_flags_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3560 -- Name: covop_attacks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3563 ALTER TABLE ONLY covop_attacks
3564 ADD CONSTRAINT covop_attacks_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3568 -- Name: covop_attacks_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3571 ALTER TABLE ONLY covop_attacks
3572 ADD CONSTRAINT covop_attacks_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3576 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3579 ALTER TABLE ONLY defense_missions
3580 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3584 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3587 ALTER TABLE ONLY defense_missions
3588 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3592 -- Name: development_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3595 ALTER TABLE ONLY development_scans
3596 ADD CONSTRAINT development_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3600 -- Name: development_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3603 ALTER TABLE ONLY development_scans
3604 ADD CONSTRAINT development_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3608 -- Name: email_change_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3611 ALTER TABLE ONLY email_change
3612 ADD CONSTRAINT email_change_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3616 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3619 ALTER TABLE ONLY fleet_scans
3620 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON DELETE CASCADE;
3624 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3627 ALTER TABLE ONLY fleet_scans
3628 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (id) REFERENCES scans(id);
3632 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3635 ALTER TABLE ONLY fleet_ships
3636 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3640 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3643 ALTER TABLE ONLY fleet_ships
3644 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(ship);
3648 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3651 ALTER TABLE ONLY fleets
3652 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3656 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3659 ALTER TABLE ONLY forum_access
3660 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3664 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3667 ALTER TABLE ONLY forum_access
3668 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3672 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3675 ALTER TABLE ONLY forum_boards
3676 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
3680 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3683 ALTER TABLE ONLY forum_posts
3684 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3688 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3691 ALTER TABLE ONLY forum_posts
3692 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3696 -- Name: forum_priv_access_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3699 ALTER TABLE ONLY forum_priv_access
3700 ADD CONSTRAINT forum_priv_access_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON DELETE CASCADE;
3704 -- Name: forum_priv_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3707 ALTER TABLE ONLY forum_priv_access
3708 ADD CONSTRAINT forum_priv_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3712 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3715 ALTER TABLE ONLY forum_thread_visits
3716 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3720 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3723 ALTER TABLE ONLY forum_thread_visits
3724 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3728 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3731 ALTER TABLE ONLY forum_threads
3732 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3736 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3739 ALTER TABLE ONLY forum_threads
3740 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
3744 -- Name: full_fleets_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3747 ALTER TABLE ONLY full_fleets
3748 ADD CONSTRAINT full_fleets_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3752 -- Name: full_fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3755 ALTER TABLE ONLY full_fleets
3756 ADD CONSTRAINT full_fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3760 -- Name: group_roles_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3763 ALTER TABLE ONLY group_roles
3764 ADD CONSTRAINT group_roles_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3768 -- Name: group_roles_role_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3771 ALTER TABLE ONLY group_roles
3772 ADD CONSTRAINT group_roles_role_fkey FOREIGN KEY (role) REFERENCES roles(role);
3776 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3779 ALTER TABLE ONLY groupmembers
3780 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3784 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3787 ALTER TABLE ONLY groupmembers
3788 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3792 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3795 ALTER TABLE ONLY incomings
3796 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3800 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3803 ALTER TABLE ONLY incomings
3804 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3808 -- Name: intel_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3811 ALTER TABLE ONLY intel_scans
3812 ADD CONSTRAINT intel_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3816 -- Name: intel_scans_intel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3819 ALTER TABLE ONLY intel_scans
3820 ADD CONSTRAINT intel_scans_intel_fkey FOREIGN KEY (intel) REFERENCES intel(id) ON DELETE CASCADE;
3824 -- Name: intel_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3827 ALTER TABLE ONLY intel
3828 ADD CONSTRAINT intel_sender_fkey FOREIGN KEY (sender) REFERENCES planets(pid);
3832 -- Name: intel_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3835 ALTER TABLE ONLY intel
3836 ADD CONSTRAINT intel_target_fkey FOREIGN KEY (target) REFERENCES planets(pid);
3840 -- Name: intel_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3843 ALTER TABLE ONLY intel
3844 ADD CONSTRAINT intel_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3848 -- Name: irc_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3851 ALTER TABLE ONLY irc_requests
3852 ADD CONSTRAINT irc_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3856 -- Name: launch_confirmations_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3859 ALTER TABLE ONLY launch_confirmations
3860 ADD CONSTRAINT launch_confirmations_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3864 -- Name: launch_confirmations_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3867 ALTER TABLE ONLY launch_confirmations
3868 ADD CONSTRAINT launch_confirmations_target_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3872 -- Name: launch_confirmations_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3875 ALTER TABLE ONLY launch_confirmations
3876 ADD CONSTRAINT launch_confirmations_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3880 -- Name: planet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3883 ALTER TABLE ONLY planet_scans
3884 ADD CONSTRAINT planet_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3888 -- Name: planet_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3891 ALTER TABLE ONLY planet_scans
3892 ADD CONSTRAINT planet_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3896 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3899 ALTER TABLE ONLY planet_stats
3900 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3904 -- Name: planet_tags_pid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3907 ALTER TABLE ONLY planet_tags
3908 ADD CONSTRAINT planet_tags_pid_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3912 -- Name: planet_tags_tag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3915 ALTER TABLE ONLY planet_tags
3916 ADD CONSTRAINT planet_tags_tag_fkey FOREIGN KEY (tag) REFERENCES available_planet_tags(tag);
3920 -- Name: planet_tags_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3923 ALTER TABLE ONLY planet_tags
3924 ADD CONSTRAINT planet_tags_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3928 -- Name: planets_alliance_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3931 ALTER TABLE ONLY planets
3932 ADD CONSTRAINT planets_alliance_fkey FOREIGN KEY (alliance) REFERENCES alliances(alliance) ON UPDATE CASCADE ON DELETE SET NULL;
3936 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3939 ALTER TABLE ONLY planets
3940 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
3944 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3947 ALTER TABLE ONLY raid_access
3948 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3952 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3955 ALTER TABLE ONLY raid_access
3956 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3960 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3963 ALTER TABLE ONLY raid_claims
3964 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
3968 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3971 ALTER TABLE ONLY raid_claims
3972 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3976 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3979 ALTER TABLE ONLY raid_targets
3980 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3984 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3987 ALTER TABLE ONLY raid_targets
3988 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3992 -- Name: scan_requests_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3995 ALTER TABLE ONLY scan_requests
3996 ADD CONSTRAINT scan_requests_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
4000 -- Name: scan_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4003 ALTER TABLE ONLY scan_requests
4004 ADD CONSTRAINT scan_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4008 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4011 ALTER TABLE ONLY scans
4012 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
4016 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4019 ALTER TABLE ONLY scans
4020 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
4024 -- Name: session_log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4027 ALTER TABLE ONLY session_log
4028 ADD CONSTRAINT session_log_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4032 -- Name: sms_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4035 ALTER TABLE ONLY sms
4036 ADD CONSTRAINT sms_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4040 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4043 ALTER TABLE ONLY users
4044 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE SET NULL ON DELETE SET NULL;
4048 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4051 ALTER TABLE ONLY users
4052 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
4056 -- Name: wiki_namespace_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4059 ALTER TABLE ONLY wiki_namespace_access
4060 ADD CONSTRAINT wiki_namespace_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
4064 -- Name: wiki_namespace_access_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4067 ALTER TABLE ONLY wiki_namespace_access
4068 ADD CONSTRAINT wiki_namespace_access_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4072 -- Name: wiki_page_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4075 ALTER TABLE ONLY wiki_page_access
4076 ADD CONSTRAINT wiki_page_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4080 -- Name: wiki_page_access_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4083 ALTER TABLE ONLY wiki_page_access
4084 ADD CONSTRAINT wiki_page_access_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4088 -- Name: wiki_page_revisions_parent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4091 ALTER TABLE ONLY wiki_page_revisions
4092 ADD CONSTRAINT wiki_page_revisions_parent_fkey FOREIGN KEY (parent) REFERENCES wiki_page_revisions(wprev);
4096 -- Name: wiki_page_revisions_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4099 ALTER TABLE ONLY wiki_page_revisions
4100 ADD CONSTRAINT wiki_page_revisions_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4104 -- Name: wiki_page_revisions_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4107 ALTER TABLE ONLY wiki_page_revisions
4108 ADD CONSTRAINT wiki_page_revisions_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4112 -- Name: wiki_pages_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4115 ALTER TABLE ONLY wiki_pages
4116 ADD CONSTRAINT wiki_pages_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4120 -- Name: wiki_pages_wprev_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4123 ALTER TABLE ONLY wiki_pages
4124 ADD CONSTRAINT wiki_pages_wprev_fkey FOREIGN KEY (wprev) REFERENCES wiki_page_revisions(wprev);
4128 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4131 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4132 REVOKE ALL ON SCHEMA public FROM postgres;
4133 GRANT ALL ON SCHEMA public TO postgres;
4134 GRANT ALL ON SCHEMA public TO PUBLIC;
4138 -- Name: coords(integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4141 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM PUBLIC;
4142 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM ndawn;
4143 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO ndawn;
4144 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO PUBLIC;
4145 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO intel;
4149 -- Name: endtick(); Type: ACL; Schema: public; Owner: ndawn
4152 REVOKE ALL ON FUNCTION endtick() FROM PUBLIC;
4153 REVOKE ALL ON FUNCTION endtick() FROM ndawn;
4154 GRANT ALL ON FUNCTION endtick() TO ndawn;
4155 GRANT ALL ON FUNCTION endtick() TO PUBLIC;
4156 GRANT ALL ON FUNCTION endtick() TO intel;
4160 -- Name: planetcoords(integer, integer); Type: ACL; Schema: public; Owner: ndawn
4163 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM PUBLIC;
4164 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM ndawn;
4165 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO ndawn;
4166 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO PUBLIC;
4167 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO intel;
4171 -- Name: planetid(integer, integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4174 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM PUBLIC;
4175 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM ndawn;
4176 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO ndawn;
4177 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO PUBLIC;
4178 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO intel;
4182 -- Name: tick(); Type: ACL; Schema: public; Owner: ndawn
4185 REVOKE ALL ON FUNCTION tick() FROM PUBLIC;
4186 REVOKE ALL ON FUNCTION tick() FROM ndawn;
4187 GRANT ALL ON FUNCTION tick() TO ndawn;
4188 GRANT ALL ON FUNCTION tick() TO PUBLIC;
4189 GRANT ALL ON FUNCTION tick() TO intel;
4193 -- Name: alliance_stats; Type: ACL; Schema: public; Owner: ndawn
4196 REVOKE ALL ON TABLE alliance_stats FROM PUBLIC;
4197 REVOKE ALL ON TABLE alliance_stats FROM ndawn;
4198 GRANT ALL ON TABLE alliance_stats TO ndawn;
4199 GRANT SELECT ON TABLE alliance_stats TO intel;
4203 -- Name: alliances; Type: ACL; Schema: public; Owner: ndawn
4206 REVOKE ALL ON TABLE alliances FROM PUBLIC;
4207 REVOKE ALL ON TABLE alliances FROM ndawn;
4208 GRANT ALL ON TABLE alliances TO ndawn;
4209 GRANT SELECT ON TABLE alliances TO intel;
4213 -- Name: development_scans; Type: ACL; Schema: public; Owner: ndawn
4216 REVOKE ALL ON TABLE development_scans FROM PUBLIC;
4217 REVOKE ALL ON TABLE development_scans FROM ndawn;
4218 GRANT ALL ON TABLE development_scans TO ndawn;
4219 GRANT SELECT ON TABLE development_scans TO intel;
4223 -- Name: current_development_scans; Type: ACL; Schema: public; Owner: ndawn
4226 REVOKE ALL ON TABLE current_development_scans FROM PUBLIC;
4227 REVOKE ALL ON TABLE current_development_scans FROM ndawn;
4228 GRANT ALL ON TABLE current_development_scans TO ndawn;
4229 GRANT SELECT ON TABLE current_development_scans TO intel;
4233 -- Name: planet_scans; Type: ACL; Schema: public; Owner: ndawn
4236 REVOKE ALL ON TABLE planet_scans FROM PUBLIC;
4237 REVOKE ALL ON TABLE planet_scans FROM ndawn;
4238 GRANT ALL ON TABLE planet_scans TO ndawn;
4239 GRANT SELECT ON TABLE planet_scans TO intel;
4243 -- Name: current_planet_scans; Type: ACL; Schema: public; Owner: ndawn
4246 REVOKE ALL ON TABLE current_planet_scans FROM PUBLIC;
4247 REVOKE ALL ON TABLE current_planet_scans FROM ndawn;
4248 GRANT ALL ON TABLE current_planet_scans TO ndawn;
4249 GRANT SELECT ON TABLE current_planet_scans TO intel;
4253 -- Name: planet_stats; Type: ACL; Schema: public; Owner: ndawn
4256 REVOKE ALL ON TABLE planet_stats FROM PUBLIC;
4257 REVOKE ALL ON TABLE planet_stats FROM ndawn;
4258 GRANT ALL ON TABLE planet_stats TO ndawn;
4259 GRANT SELECT ON TABLE planet_stats TO intel;
4263 -- Name: planets; Type: ACL; Schema: public; Owner: ndawn
4266 REVOKE ALL ON TABLE planets FROM PUBLIC;
4267 REVOKE ALL ON TABLE planets FROM ndawn;
4268 GRANT ALL ON TABLE planets TO ndawn;
4269 GRANT SELECT ON TABLE planets TO intel;
4273 -- Name: current_planet_stats; Type: ACL; Schema: public; Owner: ndawn
4276 REVOKE ALL ON TABLE current_planet_stats FROM PUBLIC;
4277 REVOKE ALL ON TABLE current_planet_stats FROM ndawn;
4278 GRANT ALL ON TABLE current_planet_stats TO ndawn;
4279 GRANT SELECT ON TABLE current_planet_stats TO intel;
4283 -- Name: alliance_resources; Type: ACL; Schema: public; Owner: ndawn
4286 REVOKE ALL ON TABLE alliance_resources FROM PUBLIC;
4287 REVOKE ALL ON TABLE alliance_resources FROM ndawn;
4288 GRANT ALL ON TABLE alliance_resources TO ndawn;
4289 GRANT SELECT ON TABLE alliance_resources TO intel;
4293 -- Name: available_planet_tags; Type: ACL; Schema: public; Owner: ndawn
4296 REVOKE ALL ON TABLE available_planet_tags FROM PUBLIC;
4297 REVOKE ALL ON TABLE available_planet_tags FROM ndawn;
4298 GRANT ALL ON TABLE available_planet_tags TO ndawn;
4299 GRANT SELECT ON TABLE available_planet_tags TO intel;
4303 -- Name: fleet_ships; Type: ACL; Schema: public; Owner: ndawn
4306 REVOKE ALL ON TABLE fleet_ships FROM PUBLIC;
4307 REVOKE ALL ON TABLE fleet_ships FROM ndawn;
4308 GRANT ALL ON TABLE fleet_ships TO ndawn;
4309 GRANT SELECT ON TABLE fleet_ships TO intel;
4313 -- Name: fleets; Type: ACL; Schema: public; Owner: ndawn
4316 REVOKE ALL ON TABLE fleets FROM PUBLIC;
4317 REVOKE ALL ON TABLE fleets FROM ndawn;
4318 GRANT ALL ON TABLE fleets TO ndawn;
4319 GRANT SELECT ON TABLE fleets TO intel;
4323 -- Name: launch_confirmations; Type: ACL; Schema: public; Owner: ndawn
4326 REVOKE ALL ON TABLE launch_confirmations FROM PUBLIC;
4327 REVOKE ALL ON TABLE launch_confirmations FROM ndawn;
4328 GRANT ALL ON TABLE launch_confirmations TO ndawn;
4329 GRANT SELECT ON TABLE launch_confirmations TO intel;
4333 -- Name: current_planet_stats_full; Type: ACL; Schema: public; Owner: ndawn
4336 REVOKE ALL ON TABLE current_planet_stats_full FROM PUBLIC;
4337 REVOKE ALL ON TABLE current_planet_stats_full FROM ndawn;
4338 GRANT ALL ON TABLE current_planet_stats_full TO ndawn;
4339 GRANT SELECT ON TABLE current_planet_stats_full TO intel;
4343 -- Name: fleet_scans; Type: ACL; Schema: public; Owner: ndawn
4346 REVOKE ALL ON TABLE fleet_scans FROM PUBLIC;
4347 REVOKE ALL ON TABLE fleet_scans FROM ndawn;
4348 GRANT ALL ON TABLE fleet_scans TO ndawn;
4349 GRANT SELECT ON TABLE fleet_scans TO intel;
4353 -- Name: intel; Type: ACL; Schema: public; Owner: ndawn
4356 REVOKE ALL ON TABLE intel FROM PUBLIC;
4357 REVOKE ALL ON TABLE intel FROM ndawn;
4358 GRANT ALL ON TABLE intel TO ndawn;
4359 GRANT SELECT ON TABLE intel TO intel;
4363 -- Name: full_intel; Type: ACL; Schema: public; Owner: ndawn
4366 REVOKE ALL ON TABLE full_intel FROM PUBLIC;
4367 REVOKE ALL ON TABLE full_intel FROM ndawn;
4368 GRANT ALL ON TABLE full_intel TO ndawn;
4369 GRANT SELECT ON TABLE full_intel TO intel;
4373 -- Name: galaxies; Type: ACL; Schema: public; Owner: ndawn
4376 REVOKE ALL ON TABLE galaxies FROM PUBLIC;
4377 REVOKE ALL ON TABLE galaxies FROM ndawn;
4378 GRANT ALL ON TABLE galaxies TO ndawn;
4379 GRANT SELECT ON TABLE galaxies TO intel;
4383 -- Name: intel_scans; Type: ACL; Schema: public; Owner: ndawn
4386 REVOKE ALL ON TABLE intel_scans FROM PUBLIC;
4387 REVOKE ALL ON TABLE intel_scans FROM ndawn;
4388 GRANT ALL ON TABLE intel_scans TO ndawn;
4389 GRANT SELECT ON TABLE intel_scans TO intel;
4393 -- Name: planet_tags; Type: ACL; Schema: public; Owner: ndawn
4396 REVOKE ALL ON TABLE planet_tags FROM PUBLIC;
4397 REVOKE ALL ON TABLE planet_tags FROM ndawn;
4398 GRANT ALL ON TABLE planet_tags TO ndawn;
4399 GRANT SELECT ON TABLE planet_tags TO intel;
4403 -- Name: scans; Type: ACL; Schema: public; Owner: ndawn
4406 REVOKE ALL ON TABLE scans FROM PUBLIC;
4407 REVOKE ALL ON TABLE scans FROM ndawn;
4408 GRANT ALL ON TABLE scans TO ndawn;
4409 GRANT SELECT ON TABLE scans TO intel;
4413 -- PostgreSQL database dump complete