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,
1466 time timestamptz DEFAULT now()
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,
2146 message text NOT NULL,
2147 removed boolean DEFAULT false NOT NULL,
2148 released_coords boolean DEFAULT false NOT NULL,
2149 ftid integer NOT NULL
2153 ALTER TABLE raids OWNER TO ndawn;
2156 -- Name: raids_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2159 CREATE SEQUENCE raids_id_seq
2167 ALTER TABLE raids_id_seq OWNER TO ndawn;
2170 -- Name: raids_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2173 ALTER SEQUENCE raids_id_seq OWNED BY raids.id;
2177 -- Name: roles; Type: TABLE; Schema: public; Owner: ndawn
2180 CREATE TABLE roles (
2181 role character varying(32) NOT NULL
2185 ALTER TABLE roles OWNER TO ndawn;
2188 -- Name: scan_requests; Type: TABLE; Schema: public; Owner: ndawn
2191 CREATE TABLE scan_requests (
2192 id integer NOT NULL,
2193 uid integer NOT NULL,
2194 pid integer NOT NULL,
2197 tick integer DEFAULT tick() NOT NULL,
2198 "time" timestamp with time zone DEFAULT now() NOT NULL,
2199 sent boolean DEFAULT false NOT NULL
2203 ALTER TABLE scan_requests OWNER TO ndawn;
2206 -- Name: scan_requests_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2209 CREATE SEQUENCE scan_requests_id_seq
2217 ALTER TABLE scan_requests_id_seq OWNER TO ndawn;
2220 -- Name: scan_requests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2223 ALTER SEQUENCE scan_requests_id_seq OWNED BY scan_requests.id;
2227 -- Name: scans; Type: TABLE; Schema: public; Owner: ndawn
2230 CREATE TABLE scans (
2231 tick integer NOT NULL,
2232 scan_id text NOT NULL,
2235 uid integer DEFAULT '-1'::integer NOT NULL,
2236 groupscan boolean DEFAULT false NOT NULL,
2237 parsed boolean DEFAULT false NOT NULL,
2242 ALTER TABLE scans OWNER TO ndawn;
2245 -- Name: scans_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2248 CREATE SEQUENCE scans_id_seq
2256 ALTER TABLE scans_id_seq OWNER TO ndawn;
2259 -- Name: scans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2262 ALTER SEQUENCE scans_id_seq OWNED BY scans.id;
2266 -- Name: session_log; Type: TABLE; Schema: public; Owner: ndawn
2269 CREATE TABLE session_log (
2270 uid integer NOT NULL,
2271 "time" timestamp with time zone NOT NULL,
2273 country character(2) NOT NULL,
2274 session text NOT NULL,
2275 remember boolean NOT NULL
2279 ALTER TABLE session_log OWNER TO ndawn;
2282 -- Name: ship_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2285 CREATE SEQUENCE ship_stats_id_seq
2293 ALTER TABLE ship_stats_id_seq OWNER TO ndawn;
2296 -- Name: ship_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2299 ALTER SEQUENCE ship_stats_id_seq OWNED BY ship_stats.id;
2303 -- Name: sms; Type: TABLE; Schema: public; Owner: ndawn
2307 id integer NOT NULL,
2309 uid integer NOT NULL,
2310 status text DEFAULT 'Waiting'::text NOT NULL,
2311 number text NOT NULL,
2312 message character varying(140) NOT NULL,
2313 cost numeric(4,2) DEFAULT 0 NOT NULL,
2314 "time" timestamp with time zone DEFAULT now() NOT NULL
2318 ALTER TABLE sms OWNER TO ndawn;
2321 -- Name: sms_id_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2324 CREATE SEQUENCE sms_id_seq
2332 ALTER TABLE sms_id_seq OWNER TO ndawn;
2335 -- Name: sms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2338 ALTER SEQUENCE sms_id_seq OWNED BY sms.id;
2342 -- Name: smslist; Type: TABLE; Schema: public; Owner: ndawn
2345 CREATE TABLE smslist (
2352 ALTER TABLE smslist OWNER TO ndawn;
2355 -- Name: table_updates; Type: VIEW; Schema: public; Owner: ndawn
2358 CREATE VIEW table_updates AS
2359 SELECT t.schemaname,
2365 WHEN (t.n_tup_upd > 0) THEN ((((t.n_tup_hot_upd)::numeric / (t.n_tup_upd)::numeric) * 100.0))::numeric(5,2)
2368 FROM (pg_stat_all_tables t
2370 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))));
2373 ALTER TABLE table_updates OWNER TO ndawn;
2376 -- Name: users_uid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2379 CREATE SEQUENCE users_uid_seq
2387 ALTER TABLE users_uid_seq OWNER TO ndawn;
2390 -- Name: users_uid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2393 ALTER SEQUENCE users_uid_seq OWNED BY users.uid;
2397 -- Name: wiki_namespace_access; Type: TABLE; Schema: public; Owner: ndawn
2400 CREATE TABLE wiki_namespace_access (
2401 namespace text NOT NULL,
2402 gid character(1) NOT NULL,
2403 edit boolean DEFAULT false NOT NULL,
2404 post boolean DEFAULT false NOT NULL,
2405 moderate boolean DEFAULT false NOT NULL
2409 ALTER TABLE wiki_namespace_access OWNER TO ndawn;
2412 -- Name: wiki_namespaces; Type: TABLE; Schema: public; Owner: ndawn
2415 CREATE TABLE wiki_namespaces (
2416 namespace character varying(16) NOT NULL
2420 ALTER TABLE wiki_namespaces OWNER TO ndawn;
2423 -- Name: wiki_page_access; Type: TABLE; Schema: public; Owner: ndawn
2426 CREATE TABLE wiki_page_access (
2427 wpid integer NOT NULL,
2428 uid integer NOT NULL,
2429 edit boolean DEFAULT false NOT NULL,
2430 moderate boolean DEFAULT false NOT NULL
2434 ALTER TABLE wiki_page_access OWNER TO ndawn;
2437 -- Name: wiki_page_revisions; Type: TABLE; Schema: public; Owner: ndawn
2440 CREATE TABLE wiki_page_revisions (
2442 wprev integer NOT NULL,
2445 comment text NOT NULL,
2446 "time" timestamp with time zone DEFAULT now() NOT NULL,
2451 ALTER TABLE wiki_page_revisions OWNER TO ndawn;
2454 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2457 CREATE SEQUENCE wiki_page_revisions_wprev_seq
2465 ALTER TABLE wiki_page_revisions_wprev_seq OWNER TO ndawn;
2468 -- Name: wiki_page_revisions_wprev_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2471 ALTER SEQUENCE wiki_page_revisions_wprev_seq OWNED BY wiki_page_revisions.wprev;
2475 -- Name: wiki_pages; Type: TABLE; Schema: public; Owner: ndawn
2478 CREATE TABLE wiki_pages (
2479 wpid integer NOT NULL,
2480 name character varying(255) NOT NULL,
2481 namespace text DEFAULT ''::text NOT NULL,
2482 textsearch tsvector DEFAULT to_tsvector(''::text) NOT NULL,
2484 "time" timestamp with time zone DEFAULT now() NOT NULL
2488 ALTER TABLE wiki_pages OWNER TO ndawn;
2491 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE; Schema: public; Owner: ndawn
2494 CREATE SEQUENCE wiki_pages_wpid_seq
2502 ALTER TABLE wiki_pages_wpid_seq OWNER TO ndawn;
2505 -- Name: wiki_pages_wpid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: ndawn
2508 ALTER SEQUENCE wiki_pages_wpid_seq OWNED BY wiki_pages.wpid;
2512 -- Name: aid; Type: DEFAULT; Schema: public; Owner: ndawn
2515 ALTER TABLE ONLY alliances ALTER COLUMN aid SET DEFAULT nextval('alliances_id_seq'::regclass);
2519 -- Name: call; Type: DEFAULT; Schema: public; Owner: ndawn
2522 ALTER TABLE ONLY calls ALTER COLUMN call SET DEFAULT nextval('calls_id_seq'::regclass);
2526 -- Name: num; Type: DEFAULT; Schema: public; Owner: ndawn
2529 ALTER TABLE ONLY fleet_ships ALTER COLUMN num SET DEFAULT nextval('fleet_ships_num_seq'::regclass);
2533 -- Name: fid; Type: DEFAULT; Schema: public; Owner: ndawn
2536 ALTER TABLE ONLY fleets ALTER COLUMN fid SET DEFAULT nextval('fleets_id_seq'::regclass);
2540 -- Name: fbid; Type: DEFAULT; Schema: public; Owner: ndawn
2543 ALTER TABLE ONLY forum_boards ALTER COLUMN fbid SET DEFAULT nextval('forum_boards_fbid_seq'::regclass);
2547 -- Name: fcid; Type: DEFAULT; Schema: public; Owner: ndawn
2550 ALTER TABLE ONLY forum_categories ALTER COLUMN fcid SET DEFAULT nextval('forum_categories_fcid_seq'::regclass);
2554 -- Name: fpid; Type: DEFAULT; Schema: public; Owner: ndawn
2557 ALTER TABLE ONLY forum_posts ALTER COLUMN fpid SET DEFAULT nextval('forum_posts_fpid_seq'::regclass);
2561 -- Name: ftid; Type: DEFAULT; Schema: public; Owner: ndawn
2564 ALTER TABLE ONLY forum_threads ALTER COLUMN ftid SET DEFAULT nextval('forum_threads_ftid_seq'::regclass);
2568 -- Name: inc; Type: DEFAULT; Schema: public; Owner: ndawn
2571 ALTER TABLE ONLY incomings ALTER COLUMN inc SET DEFAULT nextval('incomings_id_seq'::regclass);
2575 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2578 ALTER TABLE ONLY intel ALTER COLUMN id SET DEFAULT nextval('intel_id_seq'::regclass);
2582 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2585 ALTER TABLE ONLY irc_requests ALTER COLUMN id SET DEFAULT nextval('irc_requests_id_seq'::regclass);
2589 -- Name: pid; Type: DEFAULT; Schema: public; Owner: ndawn
2592 ALTER TABLE ONLY planets ALTER COLUMN pid SET DEFAULT nextval('planets_id_seq'::regclass);
2596 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2599 ALTER TABLE ONLY raid_targets ALTER COLUMN id SET DEFAULT nextval('raid_targets_id_seq'::regclass);
2603 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2606 ALTER TABLE ONLY raids ALTER COLUMN id SET DEFAULT nextval('raids_id_seq'::regclass);
2610 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2613 ALTER TABLE ONLY scan_requests ALTER COLUMN id SET DEFAULT nextval('scan_requests_id_seq'::regclass);
2617 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2620 ALTER TABLE ONLY scans ALTER COLUMN id SET DEFAULT nextval('scans_id_seq'::regclass);
2624 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2627 ALTER TABLE ONLY ship_stats ALTER COLUMN id SET DEFAULT nextval('ship_stats_id_seq'::regclass);
2631 -- Name: id; Type: DEFAULT; Schema: public; Owner: ndawn
2634 ALTER TABLE ONLY sms ALTER COLUMN id SET DEFAULT nextval('sms_id_seq'::regclass);
2638 -- Name: uid; Type: DEFAULT; Schema: public; Owner: ndawn
2641 ALTER TABLE ONLY users ALTER COLUMN uid SET DEFAULT nextval('users_uid_seq'::regclass);
2645 -- Name: wprev; Type: DEFAULT; Schema: public; Owner: ndawn
2648 ALTER TABLE ONLY wiki_page_revisions ALTER COLUMN wprev SET DEFAULT nextval('wiki_page_revisions_wprev_seq'::regclass);
2652 -- Name: wpid; Type: DEFAULT; Schema: public; Owner: ndawn
2655 ALTER TABLE ONLY wiki_pages ALTER COLUMN wpid SET DEFAULT nextval('wiki_pages_wpid_seq'::regclass);
2659 -- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2662 ALTER TABLE ONLY users
2663 ADD CONSTRAINT accounts_pkey PRIMARY KEY (uid);
2667 -- Name: alliance_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2670 ALTER TABLE ONLY alliance_stats
2671 ADD CONSTRAINT alliance_stats_pkey PRIMARY KEY (aid, tick);
2675 -- Name: alliances_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2678 ALTER TABLE ONLY alliances
2679 ADD CONSTRAINT alliances_name_key UNIQUE (alliance);
2683 -- Name: alliances_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2686 ALTER TABLE ONLY alliances
2687 ADD CONSTRAINT alliances_pkey PRIMARY KEY (aid);
2691 -- Name: available_planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2694 ALTER TABLE ONLY available_planet_tags
2695 ADD CONSTRAINT available_planet_tags_pkey PRIMARY KEY (tag);
2699 -- Name: call_statuses_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2702 ALTER TABLE ONLY call_statuses
2703 ADD CONSTRAINT call_statuses_pkey PRIMARY KEY (status);
2707 -- Name: calls_member_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2710 ALTER TABLE ONLY calls
2711 ADD CONSTRAINT calls_member_key UNIQUE (uid, landing_tick);
2715 -- Name: calls_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2718 ALTER TABLE ONLY calls
2719 ADD CONSTRAINT calls_pkey PRIMARY KEY (call);
2723 -- Name: channel_flags_name_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2726 ALTER TABLE ONLY channel_flags
2727 ADD CONSTRAINT channel_flags_name_key UNIQUE (name);
2731 -- Name: channel_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2734 ALTER TABLE ONLY channel_flags
2735 ADD CONSTRAINT channel_flags_pkey PRIMARY KEY (flag);
2739 -- Name: channel_group_flags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2742 ALTER TABLE ONLY channel_group_flags
2743 ADD CONSTRAINT channel_group_flags_pkey PRIMARY KEY (channel, gid, flag);
2747 -- Name: channels_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2750 ALTER TABLE ONLY channels
2751 ADD CONSTRAINT channels_pkey PRIMARY KEY (channel);
2755 -- Name: clickatell_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2758 ALTER TABLE ONLY clickatell
2759 ADD CONSTRAINT clickatell_pkey PRIMARY KEY (api_id, username);
2763 -- Name: covop_attacks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2766 ALTER TABLE ONLY covop_attacks
2767 ADD CONSTRAINT covop_attacks_pkey PRIMARY KEY (pid, tick, uid);
2771 -- Name: defense_missions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2774 ALTER TABLE ONLY defense_missions
2775 ADD CONSTRAINT defense_missions_pkey PRIMARY KEY (fleet);
2779 -- Name: development_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2782 ALTER TABLE ONLY development_scans
2783 ADD CONSTRAINT development_scans_pkey PRIMARY KEY (id);
2787 -- Name: dumps_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2790 ALTER TABLE ONLY dumps
2791 ADD CONSTRAINT dumps_pkey PRIMARY KEY (tick, type, modified);
2795 -- Name: email_change_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2798 ALTER TABLE ONLY email_change
2799 ADD CONSTRAINT email_change_pkey PRIMARY KEY (id);
2803 -- Name: fleet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2806 ALTER TABLE ONLY fleet_scans
2807 ADD CONSTRAINT fleet_scans_pkey PRIMARY KEY (fid);
2811 -- Name: fleet_ships_num_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2814 ALTER TABLE ONLY fleet_ships
2815 ADD CONSTRAINT fleet_ships_num_key UNIQUE (num);
2819 -- Name: fleet_ships_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2822 ALTER TABLE ONLY fleet_ships
2823 ADD CONSTRAINT fleet_ships_pkey PRIMARY KEY (fid, ship);
2827 -- Name: fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2830 ALTER TABLE ONLY fleets
2831 ADD CONSTRAINT fleets_pkey PRIMARY KEY (fid);
2835 -- Name: forum_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2838 ALTER TABLE ONLY forum_access
2839 ADD CONSTRAINT forum_access_pkey PRIMARY KEY (fbid, gid);
2843 -- Name: forum_boards_fcid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2846 ALTER TABLE ONLY forum_boards
2847 ADD CONSTRAINT forum_boards_fcid_key UNIQUE (fcid, board);
2851 -- Name: forum_boards_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2854 ALTER TABLE ONLY forum_boards
2855 ADD CONSTRAINT forum_boards_pkey PRIMARY KEY (fbid);
2859 -- Name: forum_categories_category_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2862 ALTER TABLE ONLY forum_categories
2863 ADD CONSTRAINT forum_categories_category_key UNIQUE (category);
2867 -- Name: forum_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2870 ALTER TABLE ONLY forum_categories
2871 ADD CONSTRAINT forum_categories_pkey PRIMARY KEY (fcid);
2875 -- Name: forum_posts_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2878 ALTER TABLE ONLY forum_posts
2879 ADD CONSTRAINT forum_posts_pkey PRIMARY KEY (fpid);
2883 -- Name: forum_priv_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2886 ALTER TABLE ONLY forum_priv_access
2887 ADD CONSTRAINT forum_priv_access_pkey PRIMARY KEY (uid, ftid);
2891 -- Name: forum_thread_visits_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2894 ALTER TABLE ONLY forum_thread_visits
2895 ADD CONSTRAINT forum_thread_visits_pkey PRIMARY KEY (uid, ftid);
2899 -- Name: forum_threads_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2902 ALTER TABLE ONLY forum_threads
2903 ADD CONSTRAINT forum_threads_pkey PRIMARY KEY (ftid);
2907 -- Name: full_fleets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2910 ALTER TABLE ONLY full_fleets
2911 ADD CONSTRAINT full_fleets_pkey PRIMARY KEY (fid);
2915 -- Name: galaxies_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2918 ALTER TABLE ONLY galaxies
2919 ADD CONSTRAINT galaxies_pkey PRIMARY KEY (tick, x, y);
2923 -- Name: group_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2926 ALTER TABLE ONLY group_roles
2927 ADD CONSTRAINT group_roles_pkey PRIMARY KEY (gid, role);
2931 -- Name: groupmembers_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2934 ALTER TABLE ONLY groupmembers
2935 ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (gid, uid);
2939 -- Name: groups_groupname_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2942 ALTER TABLE ONLY groups
2943 ADD CONSTRAINT groups_groupname_key UNIQUE (groupname);
2947 -- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2950 ALTER TABLE ONLY groups
2951 ADD CONSTRAINT groups_pkey PRIMARY KEY (gid);
2955 -- Name: incomings_call_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
2958 ALTER TABLE ONLY incomings
2959 ADD CONSTRAINT incomings_call_key UNIQUE (call, pid, fleet);
2963 -- Name: incomings_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2966 ALTER TABLE ONLY incomings
2967 ADD CONSTRAINT incomings_pkey PRIMARY KEY (inc);
2971 -- Name: intel_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2974 ALTER TABLE ONLY intel
2975 ADD CONSTRAINT intel_pkey PRIMARY KEY (id);
2979 -- Name: intel_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2982 ALTER TABLE ONLY intel_scans
2983 ADD CONSTRAINT intel_scans_pkey PRIMARY KEY (id, intel);
2987 -- Name: irc_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2990 ALTER TABLE ONLY irc_requests
2991 ADD CONSTRAINT irc_requests_pkey PRIMARY KEY (id);
2995 -- Name: last_smokes_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
2998 ALTER TABLE ONLY last_smokes
2999 ADD CONSTRAINT last_smokes_pkey PRIMARY KEY (nick);
3003 -- Name: launch_confirmations_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3006 ALTER TABLE ONLY launch_confirmations
3007 ADD CONSTRAINT launch_confirmations_pkey PRIMARY KEY (fid);
3011 -- Name: misc_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3014 ALTER TABLE ONLY misc
3015 ADD CONSTRAINT misc_pkey PRIMARY KEY (id);
3019 -- Name: planet_scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3022 ALTER TABLE ONLY planet_scans
3023 ADD CONSTRAINT planet_scans_pkey PRIMARY KEY (id);
3027 -- Name: planet_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3030 ALTER TABLE ONLY planet_stats
3031 ADD CONSTRAINT planet_stats_id_key UNIQUE (pid, tick);
3035 -- Name: planet_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3038 ALTER TABLE ONLY planet_stats
3039 ADD CONSTRAINT planet_stats_pkey PRIMARY KEY (tick, x, y, z);
3043 -- Name: planet_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3046 ALTER TABLE ONLY planet_tags
3047 ADD CONSTRAINT planet_tags_pkey PRIMARY KEY (pid, uid, tag);
3051 -- Name: planets_ftid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3054 ALTER TABLE ONLY planets
3055 ADD CONSTRAINT planets_ftid_key UNIQUE (ftid);
3059 -- Name: planets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3062 ALTER TABLE ONLY planets
3063 ADD CONSTRAINT planets_pkey PRIMARY KEY (pid);
3067 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3070 ALTER TABLE ONLY raid_access
3071 ADD CONSTRAINT raid_access_pkey PRIMARY KEY (raid, gid);
3075 -- Name: raid_claims_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3078 ALTER TABLE ONLY raid_claims
3079 ADD CONSTRAINT raid_claims_pkey PRIMARY KEY (target, uid, wave);
3083 -- Name: raid_targets_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3086 ALTER TABLE ONLY raid_targets
3087 ADD CONSTRAINT raid_targets_pkey PRIMARY KEY (id);
3091 -- Name: raid_targets_raid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3094 ALTER TABLE ONLY raid_targets
3095 ADD CONSTRAINT raid_targets_raid_key UNIQUE (raid, pid);
3099 -- Name: raids_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3102 ALTER TABLE ONLY raids
3103 ADD CONSTRAINT raids_pkey PRIMARY KEY (id);
3107 -- Name: roles_role_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3110 ALTER TABLE ONLY roles
3111 ADD CONSTRAINT roles_role_key UNIQUE (role);
3115 -- Name: scan_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3118 ALTER TABLE ONLY scan_requests
3119 ADD CONSTRAINT scan_requests_pkey PRIMARY KEY (id);
3123 -- Name: scan_requests_tick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3126 ALTER TABLE ONLY scan_requests
3127 ADD CONSTRAINT scan_requests_tick_key UNIQUE (tick, pid, type, uid);
3131 -- Name: scans_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3134 ALTER TABLE ONLY scans
3135 ADD CONSTRAINT scans_pkey PRIMARY KEY (id);
3139 -- Name: scans_scan_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3142 ALTER TABLE ONLY scans
3143 ADD CONSTRAINT scans_scan_id_key UNIQUE (scan_id, tick, groupscan);
3147 -- Name: session_log_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3150 ALTER TABLE ONLY session_log
3151 ADD CONSTRAINT session_log_pkey PRIMARY KEY (uid, "time", ip);
3155 -- Name: ship_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3158 ALTER TABLE ONLY ship_stats
3159 ADD CONSTRAINT ship_stats_id_key UNIQUE (id);
3161 ALTER TABLE ship_stats CLUSTER ON ship_stats_id_key;
3165 -- Name: ship_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3168 ALTER TABLE ONLY ship_stats
3169 ADD CONSTRAINT ship_stats_pkey PRIMARY KEY (ship);
3173 -- Name: sms_msgid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3176 ALTER TABLE ONLY sms
3177 ADD CONSTRAINT sms_msgid_key UNIQUE (msgid);
3181 -- Name: sms_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3184 ALTER TABLE ONLY sms
3185 ADD CONSTRAINT sms_pkey PRIMARY KEY (id);
3189 -- Name: smslist_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3192 ALTER TABLE ONLY smslist
3193 ADD CONSTRAINT smslist_pkey PRIMARY KEY (sms);
3197 -- Name: ticks_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3200 ALTER TABLE ONLY ticks
3201 ADD CONSTRAINT ticks_pkey PRIMARY KEY (t);
3205 -- Name: users_hostmask_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3208 ALTER TABLE ONLY users
3209 ADD CONSTRAINT users_hostmask_key UNIQUE (hostmask);
3213 -- Name: users_planet_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3216 ALTER TABLE ONLY users
3217 ADD CONSTRAINT users_planet_key UNIQUE (pid);
3221 -- Name: users_pnick_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3224 ALTER TABLE ONLY users
3225 ADD CONSTRAINT users_pnick_key UNIQUE (pnick);
3229 -- Name: users_tfid_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3232 ALTER TABLE ONLY users
3233 ADD CONSTRAINT users_tfid_key UNIQUE (ftid);
3237 -- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3240 ALTER TABLE ONLY users
3241 ADD CONSTRAINT users_username_key UNIQUE (username);
3245 -- Name: wiki_namespace_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3248 ALTER TABLE ONLY wiki_namespace_access
3249 ADD CONSTRAINT wiki_namespace_access_pkey PRIMARY KEY (gid, namespace);
3253 -- Name: wiki_namespaces_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3256 ALTER TABLE ONLY wiki_namespaces
3257 ADD CONSTRAINT wiki_namespaces_pkey PRIMARY KEY (namespace);
3261 -- Name: wiki_page_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3264 ALTER TABLE ONLY wiki_page_access
3265 ADD CONSTRAINT wiki_page_access_pkey PRIMARY KEY (uid, wpid);
3269 -- Name: wiki_page_revisions_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3272 ALTER TABLE ONLY wiki_page_revisions
3273 ADD CONSTRAINT wiki_page_revisions_pkey PRIMARY KEY (wprev);
3277 -- Name: wiki_pages_namespace_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
3280 ALTER TABLE ONLY wiki_pages
3281 ADD CONSTRAINT wiki_pages_namespace_key UNIQUE (namespace, name);
3285 -- Name: wiki_pages_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
3288 ALTER TABLE ONLY wiki_pages
3289 ADD CONSTRAINT wiki_pages_pkey PRIMARY KEY (wpid);
3293 -- Name: development_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3296 CREATE INDEX development_scans_planet_index ON development_scans USING btree (pid, tick);
3300 -- Name: fleets_sender_index; Type: INDEX; Schema: public; Owner: ndawn
3303 CREATE INDEX fleets_sender_index ON fleets USING btree (pid);
3307 -- Name: forum_posts_ftid_index; Type: INDEX; Schema: public; Owner: ndawn
3310 CREATE INDEX forum_posts_ftid_index ON forum_posts USING btree (ftid);
3314 -- Name: forum_posts_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3317 CREATE INDEX forum_posts_textsearch_index ON forum_posts USING gin (textsearch);
3320 CREATE INDEX forum_threads_mtime_index ON forum_threads USING btree (mtime);
3323 -- Name: groupmembers_uid_key; Type: INDEX; Schema: public; Owner: ndawn
3326 CREATE INDEX groupmembers_uid_key ON groupmembers USING btree (uid);
3330 -- Name: intel_tick_index; Type: INDEX; Schema: public; Owner: ndawn
3333 CREATE INDEX intel_tick_index ON intel USING btree (tick);
3337 -- Name: planet_scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3340 CREATE INDEX planet_scans_planet_index ON planet_scans USING btree (pid, tick);
3344 -- Name: planet_stats_scorerank_index; Type: INDEX; Schema: public; Owner: ndawn
3347 CREATE INDEX planet_stats_scorerank_index ON planet_stats USING btree (tick, scorerank);
3351 -- Name: planet_stats_sizerank_index; Type: INDEX; Schema: public; Owner: ndawn
3354 CREATE INDEX planet_stats_sizerank_index ON planet_stats USING btree (tick, sizerank);
3358 -- Name: planet_stats_valuerank_index; Type: INDEX; Schema: public; Owner: ndawn
3361 CREATE INDEX planet_stats_valuerank_index ON planet_stats USING btree (tick, valuerank);
3365 -- Name: planet_stats_xprank_index; Type: INDEX; Schema: public; Owner: ndawn
3368 CREATE INDEX planet_stats_xprank_index ON planet_stats USING btree (tick, xprank);
3372 -- Name: planets_alliance_id_index; Type: INDEX; Schema: public; Owner: ndawn
3375 CREATE INDEX planets_alliance_id_index ON planets USING btree (alliance);
3379 -- Name: scan_requests_time_not_sent_index; Type: INDEX; Schema: public; Owner: ndawn
3382 CREATE INDEX scan_requests_time_not_sent_index ON scan_requests USING btree ("time") WHERE (NOT sent);
3386 -- Name: scans_not_parsed_index; Type: INDEX; Schema: public; Owner: ndawn
3389 CREATE INDEX scans_not_parsed_index ON scans USING btree (groupscan) WHERE (NOT parsed);
3393 -- Name: scans_planet_index; Type: INDEX; Schema: public; Owner: ndawn
3396 CREATE INDEX scans_planet_index ON scans USING btree (pid, type, tick);
3400 -- Name: sms_status_msgid_idx; Type: INDEX; Schema: public; Owner: ndawn
3403 CREATE INDEX sms_status_msgid_idx ON sms USING btree (status) WHERE (msgid IS NULL);
3407 -- Name: smslist_nick_key; Type: INDEX; Schema: public; Owner: ndawn
3410 CREATE UNIQUE INDEX smslist_nick_key ON smslist USING btree (lower(nick));
3414 -- Name: users_birthday_index; Type: INDEX; Schema: public; Owner: ndawn
3417 CREATE INDEX users_birthday_index ON users USING btree (mmdd(birthday)) WHERE (birthday IS NOT NULL);
3421 -- Name: wiki_pages_textsearch_index; Type: INDEX; Schema: public; Owner: ndawn
3424 CREATE INDEX wiki_pages_textsearch_index ON wiki_pages USING gin (textsearch);
3428 -- Name: add_call; Type: TRIGGER; Schema: public; Owner: ndawn
3431 CREATE TRIGGER add_call BEFORE INSERT ON calls FOR EACH ROW EXECUTE PROCEDURE add_call();
3435 -- Name: add_raid; Type: TRIGGER; Schema: public; Owner: ndawn
3438 CREATE TRIGGER add_raid BEFORE INSERT ON raids FOR EACH ROW EXECUTE PROCEDURE add_raid();
3442 -- Name: add_remove_member; Type: TRIGGER; Schema: public; Owner: ndawn
3445 CREATE TRIGGER add_remove_member AFTER INSERT OR DELETE ON groupmembers FOR EACH ROW EXECUTE PROCEDURE change_member();
3449 -- Name: add_user; Type: TRIGGER; Schema: public; Owner: ndawn
3452 CREATE TRIGGER add_user BEFORE INSERT ON users FOR EACH ROW EXECUTE PROCEDURE add_user();
3456 -- Name: update_forum_post; Type: TRIGGER; Schema: public; Owner: ndawn
3459 CREATE TRIGGER update_forum_post BEFORE INSERT OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_post();
3463 -- Name: update_forum_thread_posts; Type: TRIGGER; Schema: public; Owner: ndawn
3466 CREATE TRIGGER update_forum_thread_posts AFTER INSERT OR DELETE OR UPDATE ON forum_posts FOR EACH ROW EXECUTE PROCEDURE update_forum_thread_posts();
3470 -- Name: update_planet; Type: TRIGGER; Schema: public; Owner: ndawn
3473 CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
3475 CREATE TRIGGER update_user_planet_check BEFORE UPDATE ON users FOR EACH ROW WHEN (NEW.pid IS NOT NULL AND OLD.pid IS NULL) EXECUTE PROCEDURE update_user_planet_check();
3479 -- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn
3482 CREATE TRIGGER update_wiki_page BEFORE UPDATE ON wiki_pages FOR EACH ROW EXECUTE PROCEDURE update_wiki_page();
3486 -- Name: updated_claim; Type: TRIGGER; Schema: public; Owner: ndawn
3489 CREATE TRIGGER updated_claim AFTER INSERT OR DELETE OR UPDATE ON raid_claims FOR EACH ROW EXECUTE PROCEDURE updated_claim();
3493 -- Name: alliance_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3496 ALTER TABLE ONLY alliance_stats
3497 ADD CONSTRAINT alliance_stats_id_fkey FOREIGN KEY (aid) REFERENCES alliances(aid);
3501 -- Name: calls_dc_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3504 ALTER TABLE ONLY calls
3505 ADD CONSTRAINT calls_dc_fkey FOREIGN KEY (dc) REFERENCES users(uid) ON UPDATE SET NULL ON DELETE SET NULL;
3509 -- Name: calls_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3512 ALTER TABLE ONLY calls
3513 ADD CONSTRAINT calls_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid);
3517 -- Name: calls_member_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3520 ALTER TABLE ONLY calls
3521 ADD CONSTRAINT calls_member_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3525 -- Name: calls_status_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3528 ALTER TABLE ONLY calls
3529 ADD CONSTRAINT calls_status_fkey FOREIGN KEY (status) REFERENCES call_statuses(status);
3533 -- Name: channel_group_flags_channel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3536 ALTER TABLE ONLY channel_group_flags
3537 ADD CONSTRAINT channel_group_flags_channel_fkey FOREIGN KEY (channel) REFERENCES channels(channel) ON UPDATE CASCADE ON DELETE CASCADE;
3541 -- Name: channel_group_flags_flag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3544 ALTER TABLE ONLY channel_group_flags
3545 ADD CONSTRAINT channel_group_flags_flag_fkey FOREIGN KEY (flag) REFERENCES channel_flags(flag) ON UPDATE CASCADE ON DELETE CASCADE;
3549 -- Name: channel_group_flags_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3552 ALTER TABLE ONLY channel_group_flags
3553 ADD CONSTRAINT channel_group_flags_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3557 -- Name: covop_attacks_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3560 ALTER TABLE ONLY covop_attacks
3561 ADD CONSTRAINT covop_attacks_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3565 -- Name: covop_attacks_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3568 ALTER TABLE ONLY covop_attacks
3569 ADD CONSTRAINT covop_attacks_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3573 -- Name: defense_missions_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3576 ALTER TABLE ONLY defense_missions
3577 ADD CONSTRAINT defense_missions_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3581 -- Name: defense_missions_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3584 ALTER TABLE ONLY defense_missions
3585 ADD CONSTRAINT defense_missions_fleet_fkey FOREIGN KEY (fleet) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3589 -- Name: development_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3592 ALTER TABLE ONLY development_scans
3593 ADD CONSTRAINT development_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3597 -- Name: development_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3600 ALTER TABLE ONLY development_scans
3601 ADD CONSTRAINT development_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3605 -- Name: email_change_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3608 ALTER TABLE ONLY email_change
3609 ADD CONSTRAINT email_change_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3613 -- Name: fleet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3616 ALTER TABLE ONLY fleet_scans
3617 ADD CONSTRAINT fleet_scans_id_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON DELETE CASCADE;
3621 -- Name: fleet_scans_scan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3624 ALTER TABLE ONLY fleet_scans
3625 ADD CONSTRAINT fleet_scans_scan_fkey FOREIGN KEY (id) REFERENCES scans(id);
3629 -- Name: fleet_ships_fleet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3632 ALTER TABLE ONLY fleet_ships
3633 ADD CONSTRAINT fleet_ships_fleet_fkey FOREIGN KEY (fid) REFERENCES fleets(fid) ON UPDATE CASCADE ON DELETE CASCADE;
3637 -- Name: fleet_ships_ship_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3640 ALTER TABLE ONLY fleet_ships
3641 ADD CONSTRAINT fleet_ships_ship_fkey FOREIGN KEY (ship) REFERENCES ship_stats(ship);
3645 -- Name: fleets_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3648 ALTER TABLE ONLY fleets
3649 ADD CONSTRAINT fleets_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3653 -- Name: forum_access_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3656 ALTER TABLE ONLY forum_access
3657 ADD CONSTRAINT forum_access_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3661 -- Name: forum_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3664 ALTER TABLE ONLY forum_access
3665 ADD CONSTRAINT forum_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3669 -- Name: forum_boards_fcid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3672 ALTER TABLE ONLY forum_boards
3673 ADD CONSTRAINT forum_boards_fcid_fkey FOREIGN KEY (fcid) REFERENCES forum_categories(fcid) ON UPDATE CASCADE ON DELETE CASCADE;
3677 -- Name: forum_posts_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3680 ALTER TABLE ONLY forum_posts
3681 ADD CONSTRAINT forum_posts_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3685 -- Name: forum_posts_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3688 ALTER TABLE ONLY forum_posts
3689 ADD CONSTRAINT forum_posts_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3693 -- Name: forum_priv_access_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3696 ALTER TABLE ONLY forum_priv_access
3697 ADD CONSTRAINT forum_priv_access_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON DELETE CASCADE;
3701 -- Name: forum_priv_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3704 ALTER TABLE ONLY forum_priv_access
3705 ADD CONSTRAINT forum_priv_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3709 -- Name: forum_thread_visits_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3712 ALTER TABLE ONLY forum_thread_visits
3713 ADD CONSTRAINT forum_thread_visits_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE CASCADE ON DELETE CASCADE;
3717 -- Name: forum_thread_visits_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3720 ALTER TABLE ONLY forum_thread_visits
3721 ADD CONSTRAINT forum_thread_visits_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3725 -- Name: forum_threads_fbid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3728 ALTER TABLE ONLY forum_threads
3729 ADD CONSTRAINT forum_threads_fbid_fkey FOREIGN KEY (fbid) REFERENCES forum_boards(fbid) ON UPDATE CASCADE ON DELETE CASCADE;
3733 -- Name: forum_threads_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3736 ALTER TABLE ONLY forum_threads
3737 ADD CONSTRAINT forum_threads_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE RESTRICT;
3741 -- Name: full_fleets_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3744 ALTER TABLE ONLY full_fleets
3745 ADD CONSTRAINT full_fleets_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3749 -- Name: full_fleets_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3752 ALTER TABLE ONLY full_fleets
3753 ADD CONSTRAINT full_fleets_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3757 -- Name: group_roles_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3760 ALTER TABLE ONLY group_roles
3761 ADD CONSTRAINT group_roles_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3765 -- Name: group_roles_role_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3768 ALTER TABLE ONLY group_roles
3769 ADD CONSTRAINT group_roles_role_fkey FOREIGN KEY (role) REFERENCES roles(role);
3773 -- Name: groupmembers_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3776 ALTER TABLE ONLY groupmembers
3777 ADD CONSTRAINT groupmembers_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3781 -- Name: groupmembers_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3784 ALTER TABLE ONLY groupmembers
3785 ADD CONSTRAINT groupmembers_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3789 -- Name: incomings_call_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3792 ALTER TABLE ONLY incomings
3793 ADD CONSTRAINT incomings_call_fkey FOREIGN KEY (call) REFERENCES calls(call) ON UPDATE CASCADE ON DELETE CASCADE;
3797 -- Name: incomings_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3800 ALTER TABLE ONLY incomings
3801 ADD CONSTRAINT incomings_sender_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3805 -- Name: intel_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3808 ALTER TABLE ONLY intel_scans
3809 ADD CONSTRAINT intel_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3813 -- Name: intel_scans_intel_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3816 ALTER TABLE ONLY intel_scans
3817 ADD CONSTRAINT intel_scans_intel_fkey FOREIGN KEY (intel) REFERENCES intel(id) ON DELETE CASCADE;
3821 -- Name: intel_sender_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3824 ALTER TABLE ONLY intel
3825 ADD CONSTRAINT intel_sender_fkey FOREIGN KEY (sender) REFERENCES planets(pid);
3829 -- Name: intel_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3832 ALTER TABLE ONLY intel
3833 ADD CONSTRAINT intel_target_fkey FOREIGN KEY (target) REFERENCES planets(pid);
3837 -- Name: intel_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3840 ALTER TABLE ONLY intel
3841 ADD CONSTRAINT intel_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3845 -- Name: irc_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3848 ALTER TABLE ONLY irc_requests
3849 ADD CONSTRAINT irc_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3853 -- Name: launch_confirmations_fid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3856 ALTER TABLE ONLY launch_confirmations
3857 ADD CONSTRAINT launch_confirmations_fid_fkey FOREIGN KEY (fid) REFERENCES fleets(fid);
3861 -- Name: launch_confirmations_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3864 ALTER TABLE ONLY launch_confirmations
3865 ADD CONSTRAINT launch_confirmations_target_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3869 -- Name: launch_confirmations_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3872 ALTER TABLE ONLY launch_confirmations
3873 ADD CONSTRAINT launch_confirmations_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3877 -- Name: planet_scans_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3880 ALTER TABLE ONLY planet_scans
3881 ADD CONSTRAINT planet_scans_id_fkey FOREIGN KEY (id) REFERENCES scans(id);
3885 -- Name: planet_scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3888 ALTER TABLE ONLY planet_scans
3889 ADD CONSTRAINT planet_scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3893 -- Name: planet_stats_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3896 ALTER TABLE ONLY planet_stats
3897 ADD CONSTRAINT planet_stats_id_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3901 -- Name: planet_tags_pid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3904 ALTER TABLE ONLY planet_tags
3905 ADD CONSTRAINT planet_tags_pid_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3909 -- Name: planet_tags_tag_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3912 ALTER TABLE ONLY planet_tags
3913 ADD CONSTRAINT planet_tags_tag_fkey FOREIGN KEY (tag) REFERENCES available_planet_tags(tag);
3917 -- Name: planet_tags_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3920 ALTER TABLE ONLY planet_tags
3921 ADD CONSTRAINT planet_tags_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
3925 -- Name: planets_alliance_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3928 ALTER TABLE ONLY planets
3929 ADD CONSTRAINT planets_alliance_fkey FOREIGN KEY (alliance) REFERENCES alliances(alliance) ON UPDATE CASCADE ON DELETE SET NULL;
3933 -- Name: planets_ftid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3936 ALTER TABLE ONLY planets
3937 ADD CONSTRAINT planets_ftid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE RESTRICT ON DELETE RESTRICT;
3941 -- Name: raid_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3944 ALTER TABLE ONLY raid_access
3945 ADD CONSTRAINT raid_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
3949 -- Name: raid_access_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3952 ALTER TABLE ONLY raid_access
3953 ADD CONSTRAINT raid_access_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3957 -- Name: raid_claims_target_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3960 ALTER TABLE ONLY raid_claims
3961 ADD CONSTRAINT raid_claims_target_fkey FOREIGN KEY (target) REFERENCES raid_targets(id) ON UPDATE CASCADE ON DELETE CASCADE;
3965 -- Name: raid_claims_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3968 ALTER TABLE ONLY raid_claims
3969 ADD CONSTRAINT raid_claims_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE CASCADE ON DELETE CASCADE;
3973 -- Name: raid_targets_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3976 ALTER TABLE ONLY raid_targets
3977 ADD CONSTRAINT raid_targets_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
3981 -- Name: raid_targets_raid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3984 ALTER TABLE ONLY raid_targets
3985 ADD CONSTRAINT raid_targets_raid_fkey FOREIGN KEY (raid) REFERENCES raids(id) ON UPDATE CASCADE ON DELETE CASCADE;
3989 -- Name: scan_requests_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
3992 ALTER TABLE ONLY scan_requests
3993 ADD CONSTRAINT scan_requests_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid);
3997 -- Name: scan_requests_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4000 ALTER TABLE ONLY scan_requests
4001 ADD CONSTRAINT scan_requests_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4005 -- Name: scans_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4008 ALTER TABLE ONLY scans
4009 ADD CONSTRAINT scans_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE CASCADE ON DELETE CASCADE;
4013 -- Name: scans_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4016 ALTER TABLE ONLY scans
4017 ADD CONSTRAINT scans_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid) ON UPDATE RESTRICT ON DELETE RESTRICT;
4021 -- Name: session_log_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4024 ALTER TABLE ONLY session_log
4025 ADD CONSTRAINT session_log_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4029 -- Name: sms_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4032 ALTER TABLE ONLY sms
4033 ADD CONSTRAINT sms_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4037 -- Name: users_planet_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4040 ALTER TABLE ONLY users
4041 ADD CONSTRAINT users_planet_fkey FOREIGN KEY (pid) REFERENCES planets(pid) ON UPDATE SET NULL ON DELETE SET NULL;
4045 -- Name: users_tfid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4048 ALTER TABLE ONLY users
4049 ADD CONSTRAINT users_tfid_fkey FOREIGN KEY (ftid) REFERENCES forum_threads(ftid) ON UPDATE SET NULL ON DELETE SET NULL;
4053 -- Name: wiki_namespace_access_gid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4056 ALTER TABLE ONLY wiki_namespace_access
4057 ADD CONSTRAINT wiki_namespace_access_gid_fkey FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE CASCADE ON DELETE CASCADE;
4061 -- Name: wiki_namespace_access_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4064 ALTER TABLE ONLY wiki_namespace_access
4065 ADD CONSTRAINT wiki_namespace_access_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4069 -- Name: wiki_page_access_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4072 ALTER TABLE ONLY wiki_page_access
4073 ADD CONSTRAINT wiki_page_access_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4077 -- Name: wiki_page_access_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4080 ALTER TABLE ONLY wiki_page_access
4081 ADD CONSTRAINT wiki_page_access_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4085 -- Name: wiki_page_revisions_parent_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4088 ALTER TABLE ONLY wiki_page_revisions
4089 ADD CONSTRAINT wiki_page_revisions_parent_fkey FOREIGN KEY (parent) REFERENCES wiki_page_revisions(wprev);
4093 -- Name: wiki_page_revisions_uid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4096 ALTER TABLE ONLY wiki_page_revisions
4097 ADD CONSTRAINT wiki_page_revisions_uid_fkey FOREIGN KEY (uid) REFERENCES users(uid);
4101 -- Name: wiki_page_revisions_wpid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4104 ALTER TABLE ONLY wiki_page_revisions
4105 ADD CONSTRAINT wiki_page_revisions_wpid_fkey FOREIGN KEY (wpid) REFERENCES wiki_pages(wpid);
4109 -- Name: wiki_pages_namespace_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4112 ALTER TABLE ONLY wiki_pages
4113 ADD CONSTRAINT wiki_pages_namespace_fkey FOREIGN KEY (namespace) REFERENCES wiki_namespaces(namespace);
4117 -- Name: wiki_pages_wprev_fkey; Type: FK CONSTRAINT; Schema: public; Owner: ndawn
4120 ALTER TABLE ONLY wiki_pages
4121 ADD CONSTRAINT wiki_pages_wprev_fkey FOREIGN KEY (wprev) REFERENCES wiki_page_revisions(wprev);
4125 -- Name: public; Type: ACL; Schema: -; Owner: postgres
4128 REVOKE ALL ON SCHEMA public FROM PUBLIC;
4129 REVOKE ALL ON SCHEMA public FROM postgres;
4130 GRANT ALL ON SCHEMA public TO postgres;
4131 GRANT ALL ON SCHEMA public TO PUBLIC;
4135 -- Name: coords(integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4138 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM PUBLIC;
4139 REVOKE ALL ON FUNCTION coords(x integer, y integer, z integer) FROM ndawn;
4140 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO ndawn;
4141 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO PUBLIC;
4142 GRANT ALL ON FUNCTION coords(x integer, y integer, z integer) TO intel;
4146 -- Name: endtick(); Type: ACL; Schema: public; Owner: ndawn
4149 REVOKE ALL ON FUNCTION endtick() FROM PUBLIC;
4150 REVOKE ALL ON FUNCTION endtick() FROM ndawn;
4151 GRANT ALL ON FUNCTION endtick() TO ndawn;
4152 GRANT ALL ON FUNCTION endtick() TO PUBLIC;
4153 GRANT ALL ON FUNCTION endtick() TO intel;
4157 -- Name: planetcoords(integer, integer); Type: ACL; Schema: public; Owner: ndawn
4160 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM PUBLIC;
4161 REVOKE ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) FROM ndawn;
4162 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO ndawn;
4163 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO PUBLIC;
4164 GRANT ALL ON FUNCTION planetcoords(id integer, tick integer, OUT x integer, OUT y integer, OUT z integer) TO intel;
4168 -- Name: planetid(integer, integer, integer, integer); Type: ACL; Schema: public; Owner: ndawn
4171 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM PUBLIC;
4172 REVOKE ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) FROM ndawn;
4173 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO ndawn;
4174 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO PUBLIC;
4175 GRANT ALL ON FUNCTION planetid(x integer, y integer, z integer, tick integer) TO intel;
4179 -- Name: tick(); Type: ACL; Schema: public; Owner: ndawn
4182 REVOKE ALL ON FUNCTION tick() FROM PUBLIC;
4183 REVOKE ALL ON FUNCTION tick() FROM ndawn;
4184 GRANT ALL ON FUNCTION tick() TO ndawn;
4185 GRANT ALL ON FUNCTION tick() TO PUBLIC;
4186 GRANT ALL ON FUNCTION tick() TO intel;
4190 -- Name: alliance_stats; Type: ACL; Schema: public; Owner: ndawn
4193 REVOKE ALL ON TABLE alliance_stats FROM PUBLIC;
4194 REVOKE ALL ON TABLE alliance_stats FROM ndawn;
4195 GRANT ALL ON TABLE alliance_stats TO ndawn;
4196 GRANT SELECT ON TABLE alliance_stats TO intel;
4200 -- Name: alliances; Type: ACL; Schema: public; Owner: ndawn
4203 REVOKE ALL ON TABLE alliances FROM PUBLIC;
4204 REVOKE ALL ON TABLE alliances FROM ndawn;
4205 GRANT ALL ON TABLE alliances TO ndawn;
4206 GRANT SELECT ON TABLE alliances TO intel;
4210 -- Name: development_scans; Type: ACL; Schema: public; Owner: ndawn
4213 REVOKE ALL ON TABLE development_scans FROM PUBLIC;
4214 REVOKE ALL ON TABLE development_scans FROM ndawn;
4215 GRANT ALL ON TABLE development_scans TO ndawn;
4216 GRANT SELECT ON TABLE development_scans TO intel;
4220 -- Name: current_development_scans; Type: ACL; Schema: public; Owner: ndawn
4223 REVOKE ALL ON TABLE current_development_scans FROM PUBLIC;
4224 REVOKE ALL ON TABLE current_development_scans FROM ndawn;
4225 GRANT ALL ON TABLE current_development_scans TO ndawn;
4226 GRANT SELECT ON TABLE current_development_scans TO intel;
4230 -- Name: planet_scans; Type: ACL; Schema: public; Owner: ndawn
4233 REVOKE ALL ON TABLE planet_scans FROM PUBLIC;
4234 REVOKE ALL ON TABLE planet_scans FROM ndawn;
4235 GRANT ALL ON TABLE planet_scans TO ndawn;
4236 GRANT SELECT ON TABLE planet_scans TO intel;
4240 -- Name: current_planet_scans; Type: ACL; Schema: public; Owner: ndawn
4243 REVOKE ALL ON TABLE current_planet_scans FROM PUBLIC;
4244 REVOKE ALL ON TABLE current_planet_scans FROM ndawn;
4245 GRANT ALL ON TABLE current_planet_scans TO ndawn;
4246 GRANT SELECT ON TABLE current_planet_scans TO intel;
4250 -- Name: planet_stats; Type: ACL; Schema: public; Owner: ndawn
4253 REVOKE ALL ON TABLE planet_stats FROM PUBLIC;
4254 REVOKE ALL ON TABLE planet_stats FROM ndawn;
4255 GRANT ALL ON TABLE planet_stats TO ndawn;
4256 GRANT SELECT ON TABLE planet_stats TO intel;
4260 -- Name: planets; Type: ACL; Schema: public; Owner: ndawn
4263 REVOKE ALL ON TABLE planets FROM PUBLIC;
4264 REVOKE ALL ON TABLE planets FROM ndawn;
4265 GRANT ALL ON TABLE planets TO ndawn;
4266 GRANT SELECT ON TABLE planets TO intel;
4270 -- Name: current_planet_stats; Type: ACL; Schema: public; Owner: ndawn
4273 REVOKE ALL ON TABLE current_planet_stats FROM PUBLIC;
4274 REVOKE ALL ON TABLE current_planet_stats FROM ndawn;
4275 GRANT ALL ON TABLE current_planet_stats TO ndawn;
4276 GRANT SELECT ON TABLE current_planet_stats TO intel;
4280 -- Name: alliance_resources; Type: ACL; Schema: public; Owner: ndawn
4283 REVOKE ALL ON TABLE alliance_resources FROM PUBLIC;
4284 REVOKE ALL ON TABLE alliance_resources FROM ndawn;
4285 GRANT ALL ON TABLE alliance_resources TO ndawn;
4286 GRANT SELECT ON TABLE alliance_resources TO intel;
4290 -- Name: available_planet_tags; Type: ACL; Schema: public; Owner: ndawn
4293 REVOKE ALL ON TABLE available_planet_tags FROM PUBLIC;
4294 REVOKE ALL ON TABLE available_planet_tags FROM ndawn;
4295 GRANT ALL ON TABLE available_planet_tags TO ndawn;
4296 GRANT SELECT ON TABLE available_planet_tags TO intel;
4300 -- Name: fleet_ships; Type: ACL; Schema: public; Owner: ndawn
4303 REVOKE ALL ON TABLE fleet_ships FROM PUBLIC;
4304 REVOKE ALL ON TABLE fleet_ships FROM ndawn;
4305 GRANT ALL ON TABLE fleet_ships TO ndawn;
4306 GRANT SELECT ON TABLE fleet_ships TO intel;
4310 -- Name: fleets; Type: ACL; Schema: public; Owner: ndawn
4313 REVOKE ALL ON TABLE fleets FROM PUBLIC;
4314 REVOKE ALL ON TABLE fleets FROM ndawn;
4315 GRANT ALL ON TABLE fleets TO ndawn;
4316 GRANT SELECT ON TABLE fleets TO intel;
4320 -- Name: launch_confirmations; Type: ACL; Schema: public; Owner: ndawn
4323 REVOKE ALL ON TABLE launch_confirmations FROM PUBLIC;
4324 REVOKE ALL ON TABLE launch_confirmations FROM ndawn;
4325 GRANT ALL ON TABLE launch_confirmations TO ndawn;
4326 GRANT SELECT ON TABLE launch_confirmations TO intel;
4330 -- Name: current_planet_stats_full; Type: ACL; Schema: public; Owner: ndawn
4333 REVOKE ALL ON TABLE current_planet_stats_full FROM PUBLIC;
4334 REVOKE ALL ON TABLE current_planet_stats_full FROM ndawn;
4335 GRANT ALL ON TABLE current_planet_stats_full TO ndawn;
4336 GRANT SELECT ON TABLE current_planet_stats_full TO intel;
4340 -- Name: fleet_scans; Type: ACL; Schema: public; Owner: ndawn
4343 REVOKE ALL ON TABLE fleet_scans FROM PUBLIC;
4344 REVOKE ALL ON TABLE fleet_scans FROM ndawn;
4345 GRANT ALL ON TABLE fleet_scans TO ndawn;
4346 GRANT SELECT ON TABLE fleet_scans TO intel;
4350 -- Name: intel; Type: ACL; Schema: public; Owner: ndawn
4353 REVOKE ALL ON TABLE intel FROM PUBLIC;
4354 REVOKE ALL ON TABLE intel FROM ndawn;
4355 GRANT ALL ON TABLE intel TO ndawn;
4356 GRANT SELECT ON TABLE intel TO intel;
4360 -- Name: full_intel; Type: ACL; Schema: public; Owner: ndawn
4363 REVOKE ALL ON TABLE full_intel FROM PUBLIC;
4364 REVOKE ALL ON TABLE full_intel FROM ndawn;
4365 GRANT ALL ON TABLE full_intel TO ndawn;
4366 GRANT SELECT ON TABLE full_intel TO intel;
4370 -- Name: galaxies; Type: ACL; Schema: public; Owner: ndawn
4373 REVOKE ALL ON TABLE galaxies FROM PUBLIC;
4374 REVOKE ALL ON TABLE galaxies FROM ndawn;
4375 GRANT ALL ON TABLE galaxies TO ndawn;
4376 GRANT SELECT ON TABLE galaxies TO intel;
4380 -- Name: intel_scans; Type: ACL; Schema: public; Owner: ndawn
4383 REVOKE ALL ON TABLE intel_scans FROM PUBLIC;
4384 REVOKE ALL ON TABLE intel_scans FROM ndawn;
4385 GRANT ALL ON TABLE intel_scans TO ndawn;
4386 GRANT SELECT ON TABLE intel_scans TO intel;
4390 -- Name: planet_tags; Type: ACL; Schema: public; Owner: ndawn
4393 REVOKE ALL ON TABLE planet_tags FROM PUBLIC;
4394 REVOKE ALL ON TABLE planet_tags FROM ndawn;
4395 GRANT ALL ON TABLE planet_tags TO ndawn;
4396 GRANT SELECT ON TABLE planet_tags TO intel;
4400 -- Name: scans; Type: ACL; Schema: public; Owner: ndawn
4403 REVOKE ALL ON TABLE scans FROM PUBLIC;
4404 REVOKE ALL ON TABLE scans FROM ndawn;
4405 GRANT ALL ON TABLE scans TO ndawn;
4406 GRANT SELECT ON TABLE scans TO intel;
4410 -- PostgreSQL database dump complete