@@ -0,0 +1,2138 @@
--
-- PostgreSQL database dump
--
SET statement_timeout = 0 ;
SET client_encoding = ' UTF8'
SET standard_conforming_strings = on ;
SET check_function_bodies = false;
SET client_min_messages = warning;
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION plpgsql IS ' PL/pgSQL procedural language'
--
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner:
--
CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;
--
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION pgcrypto IS ' cryptographic functions'
SET search_path = public, pg_catalog;
--
-- Name: skill_type; Type: TYPE; Schema: public; Owner: kzqai
--
CREATE TYPE skill_type AS ENUM (
' combat'
' passive'
' self-only'
' targeted'
);
ALTER TYPE public .skill_type OWNER TO kzqai;
--
-- Name: array_accum(anyelement); Type: AGGREGATE; Schema: public; Owner: kzqai
--
CREATE AGGREGATE array_accum (anyelement) (
SFUNC = array_append,
STYPE = anyarray,
INITCOND = ' {}'
);
ALTER AGGREGATE public .array_accum (anyelement) OWNER TO kzqai;
SET default_tablespace = ' '
SET default_with_oids = false;
--
-- Name: account_players; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE account_players (
_account_id integer NOT NULL ,
_player_id integer NOT NULL ,
last_login timestamp without time zone DEFAULT now() NOT NULL ,
created_date timestamp without time zone DEFAULT now() NOT NULL
);
ALTER TABLE public .account_players OWNER TO developers;
--
-- Name: accounts; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE accounts (
account_id integer NOT NULL ,
account_identity text NOT NULL ,
phash text ,
active_email text NOT NULL ,
type integer DEFAULT 0 ,
operational boolean DEFAULT true,
created_date timestamp without time zone DEFAULT now() NOT NULL ,
last_login timestamp without time zone ,
last_login_failure timestamp without time zone ,
karma_total integer DEFAULT 0 NOT NULL ,
last_ip character varying (100 ),
confirmed integer DEFAULT 0 NOT NULL ,
verification_number character varying (100 )
);
ALTER TABLE public .accounts OWNER TO developers;
--
-- Name: accounts_account_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE accounts_account_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .accounts_account_id_seq OWNER TO developers;
--
-- Name: accounts_account_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE accounts_account_id_seq OWNED BY accounts .account_id ;
--
-- Name: chat; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE chat (
chat_id integer NOT NULL ,
sender_id integer DEFAULT 0 ,
message character varying (255 ) NOT NULL ,
date timestamp without time zone DEFAULT now() NOT NULL
);
ALTER TABLE public .chat OWNER TO developers;
--
-- Name: chat_chat_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE chat_chat_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .chat_chat_id_seq OWNER TO developers;
--
-- Name: chat_chat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE chat_chat_id_seq OWNED BY chat .chat_id ;
--
-- Name: chat_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE chat_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .chat_id_seq OWNER TO developers;
--
-- Name: clan; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE clan (
clan_id integer NOT NULL ,
clan_name character varying (255 ) NOT NULL ,
clan_created_date timestamp without time zone DEFAULT now() NOT NULL ,
clan_founder text ,
clan_avatar_url text ,
description text
);
ALTER TABLE public .clan OWNER TO developers;
--
-- Name: clan_clan_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE clan_clan_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .clan_clan_id_seq OWNER TO developers;
--
-- Name: clan_clan_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE clan_clan_id_seq OWNED BY clan .clan_id ;
--
-- Name: clan_player; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE clan_player (
_clan_id integer NOT NULL ,
_player_id integer NOT NULL ,
member_level integer DEFAULT 0 NOT NULL
);
ALTER TABLE public .clan_player OWNER TO developers;
--
-- Name: class; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE class (
class_id integer NOT NULL ,
class_name text NOT NULL ,
class_active boolean DEFAULT true,
class_note text ,
class_tier integer DEFAULT 1 NOT NULL ,
class_desc text ,
class_icon text ,
theme character varying (255 ),
identity character varying (255 )
);
ALTER TABLE public .class OWNER TO developers;
--
-- Name: class_class_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE class_class_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .class_class_id_seq OWNER TO developers;
--
-- Name: class_class_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE class_class_id_seq OWNED BY class .class_id ;
--
-- Name: class_skill; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE class_skill (
_class_id integer NOT NULL ,
_skill_id integer NOT NULL ,
class_skill_level integer
);
ALTER TABLE public .class_skill OWNER TO developers;
--
-- Name: dueling_log_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE dueling_log_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .dueling_log_id_seq OWNER TO developers;
--
-- Name: dueling_log; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE dueling_log (
id integer DEFAULT nextval(' dueling_log_id_seq' NOT NULL ,
attacker character varying (100 ) NOT NULL ,
defender character varying (100 ) NOT NULL ,
won boolean DEFAULT false NOT NULL ,
killpoints integer DEFAULT 0 NOT NULL ,
date date DEFAULT now() NOT NULL
);
ALTER TABLE public .dueling_log OWNER TO developers;
--
-- Name: duped_unames; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE duped_unames (
uname text NOT NULL ,
email text NOT NULL ,
created_date timestamp without time zone NOT NULL ,
relative_age smallint NOT NULL ,
player_id integer NOT NULL ,
locked boolean DEFAULT false NOT NULL
);
ALTER TABLE public .duped_unames OWNER TO developers;
--
-- Name: effects; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE effects (
effect_id integer NOT NULL ,
effect_identity character varying (500 ) NOT NULL ,
effect_name text NOT NULL ,
effect_verb text NOT NULL ,
effect_self boolean
);
ALTER TABLE public .effects OWNER TO developers;
--
-- Name: effects_effect_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE effects_effect_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .effects_effect_id_seq OWNER TO developers;
--
-- Name: effects_effect_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE effects_effect_id_seq OWNED BY effects .effect_id ;
--
-- Name: enemies; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE enemies (
_player_id integer NOT NULL ,
_enemy_id integer NOT NULL
);
ALTER TABLE public .enemies OWNER TO developers;
--
-- Name: events; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE events (
event_id integer NOT NULL ,
send_to integer DEFAULT 0 ,
send_from integer DEFAULT 0 ,
message text NOT NULL ,
unread integer DEFAULT 1 NOT NULL ,
date timestamp without time zone DEFAULT now() NOT NULL
);
ALTER TABLE public .events OWNER TO developers;
--
-- Name: events_event_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE events_event_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .events_event_id_seq OWNER TO developers;
--
-- Name: events_event_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE events_event_id_seq OWNED BY events .event_id ;
--
-- Name: flags_flag_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE flags_flag_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .flags_flag_id_seq OWNER TO developers;
--
-- Name: flags; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE flags (
flag_id integer DEFAULT nextval(' flags_flag_id_seq' NOT NULL ,
flag character varying (100 ) NOT NULL ,
flag_type integer NOT NULL
);
ALTER TABLE public .flags OWNER TO developers;
--
-- Name: inventory_item_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE inventory_item_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .inventory_item_id_seq OWNER TO developers;
--
-- Name: inventory; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE inventory (
item_id integer DEFAULT nextval(' inventory_item_id_seq' NOT NULL ,
amount integer DEFAULT 1 ,
owner integer NOT NULL ,
item_type integer ,
item_type_string_backup character varying
);
ALTER TABLE public .inventory OWNER TO developers;
--
-- Name: item; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE item (
item_id integer NOT NULL ,
item_internal_name text NOT NULL ,
item_display_name text NOT NULL ,
item_cost numeric NOT NULL ,
image character varying (250 ),
for_sale boolean DEFAULT false,
usage text ,
ignore_stealth boolean DEFAULT false,
covert boolean DEFAULT false,
turn_cost integer ,
target_damage integer ,
turn_change integer ,
self_use boolean DEFAULT false,
plural character varying (20 ),
other_usable boolean DEFAULT false,
traits character varying (250 )
);
ALTER TABLE public .item OWNER TO developers;
--
-- Name: item_effects; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE item_effects (
_item_id integer NOT NULL ,
_effect_id integer NOT NULL
);
ALTER TABLE public .item_effects OWNER TO developers;
--
-- Name: item_item_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE item_item_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .item_item_id_seq OWNER TO developers;
--
-- Name: item_item_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE item_item_id_seq OWNED BY item .item_id ;
--
-- Name: levelling_log_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE levelling_log_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .levelling_log_id_seq OWNER TO developers;
--
-- Name: levelling_log; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE levelling_log (
id integer DEFAULT nextval(' levelling_log_id_seq' NOT NULL ,
killpoints integer DEFAULT 0 NOT NULL ,
levelling integer DEFAULT 0 NOT NULL ,
killsdate date NOT NULL ,
_player_id integer NOT NULL
);
ALTER TABLE public .levelling_log OWNER TO developers;
--
-- Name: login_attempts; Type: TABLE; Schema: public; Owner: kzqai; Tablespace:
--
CREATE TABLE login_attempts (
attempt_id integer NOT NULL ,
username text ,
ua_string text ,
ip text ,
successful integer ,
additional_info text ,
attempt_date timestamp without time zone DEFAULT now()
);
ALTER TABLE public .login_attempts OWNER TO kzqai;
--
-- Name: login_attempts_attempt_id_seq; Type: SEQUENCE; Schema: public; Owner: kzqai
--
CREATE SEQUENCE login_attempts_attempt_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .login_attempts_attempt_id_seq OWNER TO kzqai;
--
-- Name: login_attempts_attempt_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: kzqai
--
ALTER SEQUENCE login_attempts_attempt_id_seq OWNED BY login_attempts .attempt_id ;
--
-- Name: messages; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE messages (
message_id integer NOT NULL ,
message text NOT NULL ,
date timestamp without time zone DEFAULT now() NOT NULL ,
send_to integer ,
send_from integer ,
unread integer DEFAULT 1 ,
type integer DEFAULT 0
);
ALTER TABLE public .messages OWNER TO developers;
--
-- Name: messages_message_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE messages_message_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .messages_message_id_seq OWNER TO developers;
--
-- Name: messages_message_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE messages_message_id_seq OWNED BY messages .message_id ;
--
-- Name: past_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE past_stats_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .past_stats_id_seq OWNER TO developers;
--
-- Name: past_stats; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE past_stats (
id integer DEFAULT nextval(' past_stats_id_seq' NOT NULL ,
stat_type character varying (50 ) DEFAULT ' ' NOT NULL ,
stat_result character varying (50 ) DEFAULT ' ' NOT NULL
);
ALTER TABLE public .past_stats OWNER TO developers;
--
-- Name: player_rank_rank_id_seq1; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE player_rank_rank_id_seq1
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .player_rank_rank_id_seq1 OWNER TO developers;
--
-- Name: player_rank; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE player_rank (
rank_id integer DEFAULT nextval(' player_rank_rank_id_seq1' NOT NULL ,
_player_id integer NOT NULL ,
score integer
);
ALTER TABLE public .player_rank OWNER TO developers;
--
-- Name: player_rank_rank_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE player_rank_rank_id_seq
START WITH 1
INCREMENT BY 1
MINVALUE 0
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .player_rank_rank_id_seq OWNER TO developers;
--
-- Name: players_player_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE players_player_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .players_player_id_seq OWNER TO developers;
--
-- Name: players; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE players (
player_id integer DEFAULT nextval(' players_player_id_seq' NOT NULL ,
uname character varying (100 ) NOT NULL ,
pname_backup character varying (100 ),
health integer DEFAULT 0 NOT NULL ,
strength integer DEFAULT 0 NOT NULL ,
gold integer DEFAULT 0 NOT NULL ,
messages text DEFAULT ' ' NOT NULL ,
kills integer DEFAULT 0 NOT NULL ,
turns integer DEFAULT 0 NOT NULL ,
verification_number integer DEFAULT 0 NOT NULL ,
active integer DEFAULT 0 NOT NULL ,
email character varying (100 ) DEFAULT ' ' NOT NULL ,
level integer DEFAULT 0 NOT NULL ,
status integer DEFAULT 0 NOT NULL ,
member integer DEFAULT 0 NOT NULL ,
days integer DEFAULT 0 NOT NULL ,
ip character varying (100 ) DEFAULT ' ' NOT NULL ,
bounty integer DEFAULT 0 NOT NULL ,
created_date timestamp without time zone DEFAULT now(),
resurrection_time integer DEFAULT (round((random() * (7 )::double precision )) * (3 )::double precision ) NOT NULL ,
last_started_attack timestamp without time zone DEFAULT now(),
energy integer DEFAULT 0 NOT NULL ,
avatar_type integer DEFAULT 1 NOT NULL ,
_class_id integer NOT NULL ,
ki integer DEFAULT 0 NOT NULL ,
stamina integer DEFAULT 0 NOT NULL ,
speed integer DEFAULT 0 NOT NULL ,
karma integer DEFAULT 0 NOT NULL ,
kills_gained integer DEFAULT 0 NOT NULL ,
kills_used integer DEFAULT 0 NOT NULL
);
ALTER TABLE public .players OWNER TO developers;
--
-- Name: players_flagged_players_flagged_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE players_flagged_players_flagged_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .players_flagged_players_flagged_id_seq OWNER TO developers;
--
-- Name: players_flagged; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE players_flagged (
players_flagged_id integer DEFAULT nextval(' players_flagged_players_flagged_id_seq' NOT NULL ,
player_id integer ,
flag_id integer ,
" timestamp" date DEFAULT now(),
originating_page character varying (50 ),
extra_notes character varying (100 )
);
ALTER TABLE public .players_flagged OWNER TO developers;
--
-- Name: ppl_online; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE ppl_online (
session_id character varying (255 ) NOT NULL ,
activity timestamp without time zone DEFAULT now() NOT NULL ,
member boolean DEFAULT false NOT NULL ,
ip_address character varying (255 ) DEFAULT ' ' NOT NULL ,
refurl character varying (255 ) DEFAULT ' ' NOT NULL ,
user_agent character varying (255 )
);
ALTER TABLE public .ppl_online OWNER TO developers;
--
-- Name: rankings; Type: VIEW; Schema: public; Owner: kzqai
--
CREATE VIEW rankings AS
SELECT player_rank .rank_id , players .player_id , player_rank .score , players .uname , class .class_name , players .level , (CASE WHEN (players .health = 0 ) THEN 0 ELSE 1 END)::boolean AS alive, players .days FROM ((player_rank JOIN players ON ((players .player_id = player_rank ._player_id ))) JOIN class ON ((class .class_id = players ._class_id ))) WHERE (players .active = 1 ) ORDER BY player_rank .rank_id ;
ALTER TABLE public .rankings OWNER TO kzqai;
--
-- Name: settings; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE settings (
setting_id integer NOT NULL ,
player_id integer NOT NULL ,
settings_store text
);
ALTER TABLE public .settings OWNER TO developers;
--
-- Name: settings_setting_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE settings_setting_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .settings_setting_id_seq OWNER TO developers;
--
-- Name: settings_setting_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE settings_setting_id_seq OWNED BY settings .setting_id ;
--
-- Name: skill; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE skill (
skill_id integer NOT NULL ,
skill_level integer DEFAULT 1 NOT NULL ,
skill_is_active boolean DEFAULT true,
skill_display_name text NOT NULL ,
skill_internal_name text NOT NULL ,
skill_type skill_type NOT NULL
);
ALTER TABLE public .skill OWNER TO developers;
--
-- Name: skill_skill_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE skill_skill_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .skill_skill_id_seq OWNER TO developers;
--
-- Name: skill_skill_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE skill_skill_id_seq OWNED BY skill .skill_id ;
--
-- Name: test; Type: TABLE; Schema: public; Owner: kzqai; Tablespace:
--
CREATE TABLE test (
id text DEFAULT encode(gen_random_bytes(32 ), ' hex' text ) NOT NULL ,
value text
);
ALTER TABLE public .test OWNER TO kzqai;
--
-- Name: time; Type: TABLE; Schema: public; Owner: developers; Tablespace:
--
CREATE TABLE "time " (
time_id integer NOT NULL ,
time_label character varying NOT NULL ,
amount integer NOT NULL
);
ALTER TABLE public." time"
--
-- Name: time_time_id_seq; Type: SEQUENCE; Schema: public; Owner: developers
--
CREATE SEQUENCE time_time_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1 ;
ALTER TABLE public .time_time_id_seq OWNER TO developers;
--
-- Name: time_time_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: developers
--
ALTER SEQUENCE time_time_id_seq OWNED BY " time"
--
-- Name: account_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY accounts ALTER COLUMN account_id SET DEFAULT nextval(' accounts_account_id_seq'
--
-- Name: chat_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY chat ALTER COLUMN chat_id SET DEFAULT nextval(' chat_chat_id_seq'
--
-- Name: clan_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY clan ALTER COLUMN clan_id SET DEFAULT nextval(' clan_clan_id_seq'
--
-- Name: class_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY class ALTER COLUMN class_id SET DEFAULT nextval(' class_class_id_seq'
--
-- Name: effect_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY effects ALTER COLUMN effect_id SET DEFAULT nextval(' effects_effect_id_seq'
--
-- Name: event_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY events ALTER COLUMN event_id SET DEFAULT nextval(' events_event_id_seq'
--
-- Name: item_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY item ALTER COLUMN item_id SET DEFAULT nextval(' item_item_id_seq'
--
-- Name: attempt_id; Type: DEFAULT; Schema: public; Owner: kzqai
--
ALTER TABLE ONLY login_attempts ALTER COLUMN attempt_id SET DEFAULT nextval(' login_attempts_attempt_id_seq'
--
-- Name: message_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY messages ALTER COLUMN message_id SET DEFAULT nextval(' messages_message_id_seq'
--
-- Name: setting_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY settings ALTER COLUMN setting_id SET DEFAULT nextval(' settings_setting_id_seq'
--
-- Name: skill_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY skill ALTER COLUMN skill_id SET DEFAULT nextval(' skill_skill_id_seq'
--
-- Name: time_id; Type: DEFAULT; Schema: public; Owner: developers
--
ALTER TABLE ONLY " time" SET DEFAULT nextval(' time_time_id_seq'
--
-- Data for Name: account_players; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY account_players (_account_id, _player_id, last_login, created_date) FROM stdin;
5442 1000 2013 - 05 - 10 18 :07 :54 .362302 2013 - 05 - 10 18 :07 :54 .362302
\.
--
-- Data for Name: accounts; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY accounts (account_id, account_identity, phash, active_email, type, operational, created_date, last_login, last_login_failure, karma_total, last_ip, confirmed, verification_number) FROM stdin;
5442 tchalvak@gmail .com $2a$08 $y/ vyPiyTwR23tPQcLm4gKuqtvjbk/ oepXjhQXGCgwCMxSesdEnkZW tchalvak@gmail .com 0 t 2009 - 11 - 03 12 :04 :53 .223615 2013 - 05 - 20 12 :57 :26 .758901 2013 - 05 - 20 12 :57 :21 .901384 7 127 .0 .0 .1 1 19444
\.
--
-- Name: accounts_account_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' accounts_account_id_seq' 24904 , true);
--
-- Name: clan_clan_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' clan_clan_id_seq' 225 , true);
--
-- Data for Name: class; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY class (class_id, class_name, class_active, class_note, class_tier, class_desc, class_icon, theme, identity) FROM stdin;
1 Viper t Poison 1 \N \N Black viper
2 Crane t Speed 1 \N \N Blue crane
4 Dragon t Healing 1 \N \N White dragon
3 Tiger t Strength 1 \N \N Red tiger
5 Mantis f Smoke 1 \N \N Gray mantis
\.
--
-- Name: class_class_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' class_class_id_seq' 6 , true);
--
-- Data for Name: class_skill; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY class_skill (_class_id, _skill_id, class_skill_level) FROM stdin;
1 9 \N
1 10 \N
2 1 \N
2 3 \N
4 4 \N
3 6 \N
3 7 \N
4 17 \N
2 15 \N
4 16 \N
\.
--
-- Name: dueling_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' dueling_log_id_seq' 1266177 , true);
-- Data for Name: effects; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY effects (effect_id, effect_identity, effect_name, effect_verb, effect_self) FROM stdin;
1 wound Wound Wounds f
2 fire Fire Burns f
3 ice Ice Freezes f
4 shock Shock Shocks f
5 acid Acid Dissolves f
6 void Void Taints f
7 flare Flare Blinds f
8 poison Poison Poisons f
9 paralysis Paralysis Paralyzes f
10 slice Slice Slices f
11 bash Bash Bashes f
12 pierce Pierce Pierces f
13 slow Slow Slows down f
14 speed Speed Speeds up t
15 stealth Stealthed Hides t
16 vigor Vigor Energizes t
17 strength Strength Strengthens t
18 weaken Weaken Weakens f
19 heal Heal Heals t
20 healing Healing Healed t
21 regen Regenerate Regenerating t
22 death Death Dying f
\.
--
-- Name: effects_effect_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' effects_effect_id_seq' 22 , true);
--
-- Name: events_event_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' events_event_id_seq' 7059596 , true);
--
-- Data for Name: flags; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY flags (flag_id, flag, flag_type) FROM stdin;
1 bugabuse 2
2 multiplaying 3
3 spamming 4
4 paused 10
5 moderator 21
6 bugfinder 22
\.
--
-- Name: flags_flag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' flags_flag_id_seq' 1 , false);
-- Name: inventory_item_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' inventory_item_id_seq' 49240 , true);
--
-- Data for Name: item; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY item (item_id, item_internal_name, item_display_name, item_cost, image, for_sale, usage, ignore_stealth, covert, turn_cost, target_damage, turn_change, self_use, plural, other_usable, traits) FROM stdin;
9 charcoal Charcoal 10 \N f Purges Poisons, Burns Merrily t t \N 20 \N t \N f \N
10 sake Sake 30 \N f Warms the Soul t t \N 1 \N t \N f \N
11 mirror Mirror Shard 120 \N f Reflects Light t t \N 5 \N t \N f \N
12 shell Shell Fragment 700 \N f Insulates against Flame t t \N 0 \N t \N f \N
13 prayerwheel Prayer Wheel 150 \N f Lifts Curses t t \N 0 \N t \N f \N
15 sushi Sushi 50 \N f For immediate consumption t t \N 20 \N t \N f \N
16 fugu Fugu Blowfish 50 \N f Delicious, or Deadly t t \N 20 \N t \N f \N
17 oyoroi O- yoroi Great Armor 3000 \N f Woven Armor with a Metal Breastplate against piercing and slashing t t \N 3000 \N t s f \N
18 kozando Kozan- do Scale Armor 1600 \N f Scale Plated Armor against slashing t t \N 0 \N t s f \N
19 domaru Do- Maru Woven Armor 1000 \N f Woven Armor against piercing and slashing t t \N 0 \N t s f \N
20 tanko Tanko Scale Armor 900 \N f Lamellate Armor against Crushing Blows t t \N 0 \N t s f \N
21 tatamido Tatami- do Folding Armor 1500 \N f Laced Squares of Flexible Leather for easy movement t t \N 0 \N t s f \N
22 keikogi Keiko- Gi Suit 70 \N f Thick Cloth Uniform for unfettered movement t t \N 0 \N t s f \N
24 hakama Hakama Garb 30 \N f Pleated, Loose Pants and Shirt for unfettered movement t t \N 0 \N t s f \N
25 mask Menpo Mask 600 \N f For Disguise or Intimidation t t \N 0 \N t s f \N
27 meito Meito Named Katana 3000 \N f Folded- Steel Named Sword for Slashing t f \N 3000 \N t \N f \N
28 naginata Naginata Spear 750 \N f Long Reached, Curved Spear for Piercing and Slashing f f \N 750 \N t s f \N
30 kusarigama Kusarigama Chain Sickle 500 \N f For Swinging Slashes and Entanglement t f \N 500 \N t s f \N
32 tetsubo Tetsubo Club 140 \N f For Piercing, Crushing Blows f f \N 140 \N t \N f \N
33 nunchaku Nunchaku 180 \N f Thrashing Blows with a long reach t f \N 180 \N t \N f \N
34 zanbato Zanbato Long Sword 660 \N f For Heavy Slashing Blows with a long reach t f \N 660 \N t \N f \N
35 eku Eku Wooden Oar 30 \N f For Slow, Wide- Arcing Blows t f \N 130 \N t s f \N
36 ono Ono Axe 10 \N f Great for Beheadings and De- limbing f f \N 110 \N t s f \N
37 nekote Neko- Te Claws 450 \N f For Poisoned slashing or climbing f t \N 30 \N t \N f \N
23 kimono Kimono 170 \N f Light Silk Clothing for formal wear t t \N 0 \N t s f \N
26 katana Katana 1800 \N f Crafted Sword for Slashing f f \N 1800 \N t \N f \N
31 kama Kama Sickle 55 \N f For Reaping Rice f f \N 55 \N t \N f \N
38 hamagari Hamagari Saw 77 \N f For Poisoned slashing or climbing f t \N 177 \N t s f \N
39 bo Bo Staff 70 \N f For Ease of Walking t t \N 170 \N t s f \N
14 lantern Hooded Lantern 50 \N f A lantern for light and flame t t \N 20 \N t \N t \N
5 shuriken Shuriken 50 mini_star .png t Reduces health f f \N \N \N f \N t \N
3 amanita Amanita Mushroom 225 mushroom .png t Increases Turns t t \N \N 6 t s t \N
2 caltrops Caltrops 125 caltrops .png t Reduces Turns f f \N \N - 6 f \N t \N
4 smokebomb Smoke Bomb 150 smoke_bomb .gif t Stealths a Ninja f f \N \N \N t s t \N
6 dimmak Dim Mak 1000 scroll .png f \N t t \N \N \N f \N t \N
1 phosphor Phosphor Powder 175 \N t Reduces health f f \N \N \N f s t \N
7 ginsengroot Ginseng Root 1000 \N f \N t t \N \N \N t s t \N
8 tigersalve Tiger Salve 3000 \N f \N t t \N \N \N t s t \N
40 tessen Tessen Fan 150 \N t For Cooling Air f t \N 20 \N t s t \N
29 kunai Kunai 50 \N t For Digging and Planting t t \N 50 \N t \N t \N
\.
--
-- Data for Name: item_effects; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY item_effects (_item_id, _effect_id) FROM stdin;
1 2
1 7
1 1
2 13
2 12
2 1
7 16
8 17
3 14
6 22
6 1
5 10
5 1
4 15
29 1
29 12
40 1
\.
--
-- Name: item_item_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' item_item_id_seq' 40 , true);
--
-- Name: levelling_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' levelling_log_id_seq' 4168545 , true);
--
-- Name: messages_message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' messages_message_id_seq' 336595 , true);
--
-- Data for Name: past_stats; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY past_stats (id, stat_type, stat_result) FROM stdin;
2 Most Kills Last Month 0
3 Total Kills Last Month 0
5 Previous Month' s Vicious Killer no-one
6 Total Kills Yesterday 0
1 Most Kills Yesterday 0
4 Yesterday' s Vicious Killer lightning_dust
\.
--
-- Name: past_stats_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' past_stats_id_seq' 1 , false);
--
-- Data for Name: player_rank; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY player_rank (rank_id, _player_id, score) FROM stdin;
1 5442 9999999
\.
--
-- Name: player_rank_rank_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' player_rank_rank_id_seq' 1 , false);
--
-- Name: player_rank_rank_id_seq1; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog .setval (' player_rank_rank_id_seq1' 921 , true);
--
-- Data for Name: players; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY players (player_id, uname, pname_backup, health, strength, gold, messages, kills, turns, verification_number, active, email, level, status, member, days, ip, bounty, created_date, resurrection_time, last_started_attack, energy, avatar_type, _class_id, ki, stamina, speed, karma, kills_gained, kills_used) FROM stdin;
1000 Tchalvak spamspam 3896171 75 40634 I am staff! It' s true, check the staff page.\r\n\r\n Email me there if you want a prompt response. Or the official email, [email protected] \r\n\r\n In the depths of my black little coal of a heart, there is a dying sun that burns on the fuel of my hatred for you. 72 33332247 1873 1 [email protected] 15 131074 0 0 127.0.0.1 5000 2009-11-03 12:04:53.223615 12 2013-05-17 12:39:56.863946 1000 1 1 463 75 75 23 126 105
\.
--
-- Data for Name: players_flagged; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY players_flagged (players_flagged_id, player_id, flag_id, "timestamp", originating_page, extra_notes) FROM stdin;
\.
--
-- Name: players_flagged_players_flagged_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog.setval(' players_flagged_players_flagged_id_seq' , 1, false);
--
-- Name: players_player_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog.setval(' players_player_id_seq' , 166507, true);
--
-- Data for Name: skill; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY skill (skill_id, skill_level, skill_is_active, skill_display_name, skill_internal_name, skill_type) FROM stdin;
1 1 t Ice Bolt ice targeted
2 6 t Cold Steal coldsteal targeted
3 1 t Speed speed passive
4 1 t Chi chi passive
6 1 t Fire Bolt fire targeted
7 1 t Blaze blaze combat
8 2 t Deflect deflect combat
9 1 t Poison Touch poison targeted
10 1 t Hidden Resurrect stealthres passive
11 1 t Sight sight targeted
12 1 t Stealth stealth self-only
13 1 t Unstealth unstealth self-only
14 2 t Steal steal targeted
15 2 t Kampo kampo self-only
16 2 t Evasion evasion combat
5 20 t Midnight Heal midnightheal passive
17 1 t Heal heal targeted
\.
--
-- Name: skill_skill_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog.setval(' skill_skill_id_seq' , 16, true);
--
-- Data for Name: test; Type: TABLE DATA; Schema: public; Owner: kzqai
--
COPY test (id, value) FROM stdin;
1f9b35a4f87292a8888b2c68d7de86302d433419bd979afdf023358dbffe884e scoobydoo
\.
--
-- Data for Name: time; Type: TABLE DATA; Schema: public; Owner: developers
--
COPY "time" (time_id, time_label, amount) FROM stdin;
1 hours 6
\.
--
-- Name: time_time_id_seq; Type: SEQUENCE SET; Schema: public; Owner: developers
--
SELECT pg_catalog.setval(' time_time_id_seq' , 1, true);
--
-- Name: account_players__player_id_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY account_players
ADD CONSTRAINT account_players__player_id_key UNIQUE (_player_id);
--
-- Name: account_players__player_id_key1; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY account_players
ADD CONSTRAINT account_players__player_id_key1 UNIQUE (_player_id);
--
-- Name: accounts_account_identity_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT accounts_account_identity_key UNIQUE (account_identity);
--
-- Name: accounts_active_email_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT accounts_active_email_key UNIQUE (active_email);
--
-- Name: accounts_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY accounts
ADD CONSTRAINT accounts_pkey PRIMARY KEY (account_id);
--
-- Name: clan_clan_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY clan
ADD CONSTRAINT clan_clan_name_key UNIQUE (clan_name);
--
-- Name: clan_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY clan
ADD CONSTRAINT clan_pkey PRIMARY KEY (clan_id);
--
-- Name: clan_player__player_id_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY clan_player
ADD CONSTRAINT clan_player__player_id_key UNIQUE (_player_id);
--
-- Name: clan_player__player_id_key1; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY clan_player
ADD CONSTRAINT clan_player__player_id_key1 UNIQUE (_player_id);
--
-- Name: class_class_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY class
ADD CONSTRAINT class_class_name_key UNIQUE (class_name);
--
-- Name: class_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY class
ADD CONSTRAINT class_pkey PRIMARY KEY (class_id);
--
-- Name: class_skill_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY class_skill
ADD CONSTRAINT class_skill_pkey PRIMARY KEY (_class_id, _skill_id);
--
-- Name: dueling_log_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY dueling_log
ADD CONSTRAINT dueling_log_pkey PRIMARY KEY (id);
--
-- Name: duped_unames_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY duped_unames
ADD CONSTRAINT duped_unames_pkey PRIMARY KEY (player_id);
--
-- Name: effects_effect_identity_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY effects
ADD CONSTRAINT effects_effect_identity_key UNIQUE (effect_identity);
--
-- Name: effects_effect_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY effects
ADD CONSTRAINT effects_effect_name_key UNIQUE (effect_name);
--
-- Name: effects_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY effects
ADD CONSTRAINT effects_pkey PRIMARY KEY (effect_id);
--
-- Name: enemies_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY enemies
ADD CONSTRAINT enemies_pkey PRIMARY KEY (_player_id, _enemy_id);
--
-- Name: flags_flag_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY flags
ADD CONSTRAINT flags_flag_key UNIQUE (flag);
--
-- Name: flags_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY flags
ADD CONSTRAINT flags_pkey PRIMARY KEY (flag_id);
--
-- Name: inventory_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY inventory
ADD CONSTRAINT inventory_pkey PRIMARY KEY (item_id);
--
-- Name: item_effects_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY item_effects
ADD CONSTRAINT item_effects_pkey PRIMARY KEY (_item_id, _effect_id);
--
-- Name: item_item_display_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY item
ADD CONSTRAINT item_item_display_name_key UNIQUE (item_display_name);
--
-- Name: item_item_internal_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY item
ADD CONSTRAINT item_item_internal_name_key UNIQUE (item_internal_name);
--
-- Name: item_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY item
ADD CONSTRAINT item_pkey PRIMARY KEY (item_id);
--
-- Name: levelling_log_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY levelling_log
ADD CONSTRAINT levelling_log_pkey PRIMARY KEY (id);
--
-- Name: past_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY past_stats
ADD CONSTRAINT past_stats_pkey PRIMARY KEY (id);
--
-- Name: players_flagged_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY players_flagged
ADD CONSTRAINT players_flagged_pkey PRIMARY KEY (players_flagged_id);
--
-- Name: players_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY players
ADD CONSTRAINT players_pkey PRIMARY KEY (player_id);
--
-- Name: players_uname_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY players
ADD CONSTRAINT players_uname_key UNIQUE (uname);
--
-- Name: ppl_online_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY ppl_online
ADD CONSTRAINT ppl_online_pkey PRIMARY KEY (session_id);
--
-- Name: skill_pkey; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY skill
ADD CONSTRAINT skill_pkey PRIMARY KEY (skill_id);
--
-- Name: skill_skill_display_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY skill
ADD CONSTRAINT skill_skill_display_name_key UNIQUE (skill_display_name);
--
-- Name: skill_skill_internal_name_key; Type: CONSTRAINT; Schema: public; Owner: developers; Tablespace:
--
ALTER TABLE ONLY skill
ADD CONSTRAINT skill_skill_internal_name_key UNIQUE (skill_internal_name);
--
-- Name: test_pkey; Type: CONSTRAINT; Schema: public; Owner: kzqai; Tablespace:
--
ALTER TABLE ONLY test
ADD CONSTRAINT test_pkey PRIMARY KEY (id);
--
-- Name: chat_date_index; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX chat_date_index ON chat USING btree (date);
--
-- Name: dueling_log_date_index; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX dueling_log_date_index ON dueling_log USING btree (date);
--
-- Name: duped_unames_email_key; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX duped_unames_email_key ON duped_unames USING btree (email);
--
-- Name: duped_unames_uname_key; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX duped_unames_uname_key ON duped_unames USING btree (uname);
--
-- Name: events_date_index; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX events_date_index ON events USING btree (date);
--
-- Name: messages_date_index; Type: INDEX; Schema: public; Owner: developers; Tablespace:
--
CREATE INDEX messages_date_index ON messages USING btree (date);
--
-- Name: account_players__account_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY account_players
ADD CONSTRAINT account_players__account_id_fkey FOREIGN KEY (_account_id) REFERENCES accounts(account_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: account_players__player_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY account_players
ADD CONSTRAINT account_players__player_id_fkey FOREIGN KEY (_player_id) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: clan_player__clan_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY clan_player
ADD CONSTRAINT clan_player__clan_id_fkey FOREIGN KEY (_clan_id) REFERENCES clan(clan_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: clan_player__player_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY clan_player
ADD CONSTRAINT clan_player__player_id_fkey FOREIGN KEY (_player_id) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: class_skill__class_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY class_skill
ADD CONSTRAINT class_skill__class_id_fkey FOREIGN KEY (_class_id) REFERENCES class(class_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: class_skill__skill_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY class_skill
ADD CONSTRAINT class_skill__skill_id_fkey FOREIGN KEY (_skill_id) REFERENCES skill(skill_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: effects_effect_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY item_effects
ADD CONSTRAINT effects_effect_id_fkey FOREIGN KEY (_effect_id) REFERENCES effects(effect_id) ON UPDATE CASCADE ON DELETE RESTRICT;
--
-- Name: enemies__enemy_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY enemies
ADD CONSTRAINT enemies__enemy_id_fkey FOREIGN KEY (_enemy_id) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: enemies__player_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY enemies
ADD CONSTRAINT enemies__player_id_fkey FOREIGN KEY (_player_id) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: inventory_owner_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY inventory
ADD CONSTRAINT inventory_owner_fkey FOREIGN KEY (owner) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: item_item_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY item_effects
ADD CONSTRAINT item_item_id_fkey FOREIGN KEY (_item_id) REFERENCES item(item_id) ON UPDATE CASCADE ON DELETE RESTRICT;
--
-- Name: levelling_log__player_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY levelling_log
ADD CONSTRAINT levelling_log__player_id_fkey FOREIGN KEY (_player_id) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: messages_send_from_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY messages
ADD CONSTRAINT messages_send_from_fkey FOREIGN KEY (send_from) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: messages_send_to_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY messages
ADD CONSTRAINT messages_send_to_fkey FOREIGN KEY (send_to) REFERENCES players(player_id) ON UPDATE CASCADE ON DELETE CASCADE;
--
-- Name: players__class_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: developers
--
ALTER TABLE ONLY players
ADD CONSTRAINT players__class_id_fkey FOREIGN KEY (_class_id) REFERENCES class(class_id) ON UPDATE CASCADE;
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- Name: chat; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE chat FROM PUBLIC;
REVOKE ALL ON TABLE chat FROM developers;
GRANT ALL ON TABLE chat TO developers;
--
-- Name: chat_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE chat_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE chat_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE chat_id_seq TO developers;
--
-- Name: clan; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE clan FROM PUBLIC;
REVOKE ALL ON TABLE clan FROM developers;
GRANT ALL ON TABLE clan TO developers;
--
-- Name: clan_player; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE clan_player FROM PUBLIC;
REVOKE ALL ON TABLE clan_player FROM developers;
GRANT ALL ON TABLE clan_player TO developers;
--
-- Name: class; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE class FROM PUBLIC;
REVOKE ALL ON TABLE class FROM developers;
GRANT ALL ON TABLE class TO developers;
--
-- Name: dueling_log_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE dueling_log_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE dueling_log_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE dueling_log_id_seq TO developers;
--
-- Name: dueling_log; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE dueling_log FROM PUBLIC;
REVOKE ALL ON TABLE dueling_log FROM developers;
GRANT ALL ON TABLE dueling_log TO developers;
--
-- Name: effects; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE effects FROM PUBLIC;
REVOKE ALL ON TABLE effects FROM developers;
GRANT ALL ON TABLE effects TO developers;
--
-- Name: enemies; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE enemies FROM PUBLIC;
REVOKE ALL ON TABLE enemies FROM developers;
GRANT ALL ON TABLE enemies TO developers;
--
-- Name: events; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE events FROM PUBLIC;
REVOKE ALL ON TABLE events FROM developers;
GRANT ALL ON TABLE events TO developers;
--
-- Name: flags_flag_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE flags_flag_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE flags_flag_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE flags_flag_id_seq TO developers;
--
-- Name: flags; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE flags FROM PUBLIC;
REVOKE ALL ON TABLE flags FROM developers;
GRANT ALL ON TABLE flags TO developers;
--
-- Name: inventory_item_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE inventory_item_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE inventory_item_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE inventory_item_id_seq TO developers;
--
-- Name: inventory; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE inventory FROM PUBLIC;
REVOKE ALL ON TABLE inventory FROM developers;
GRANT ALL ON TABLE inventory TO developers;
--
-- Name: item; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE item FROM PUBLIC;
REVOKE ALL ON TABLE item FROM developers;
GRANT ALL ON TABLE item TO developers;
--
-- Name: item_effects; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE item_effects FROM PUBLIC;
REVOKE ALL ON TABLE item_effects FROM developers;
GRANT ALL ON TABLE item_effects TO developers;
--
-- Name: levelling_log_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE levelling_log_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE levelling_log_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE levelling_log_id_seq TO developers;
--
-- Name: levelling_log; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE levelling_log FROM PUBLIC;
REVOKE ALL ON TABLE levelling_log FROM developers;
GRANT ALL ON TABLE levelling_log TO developers;
--
-- Name: login_attempts; Type: ACL; Schema: public; Owner: kzqai
--
REVOKE ALL ON TABLE login_attempts FROM PUBLIC;
REVOKE ALL ON TABLE login_attempts FROM kzqai;
GRANT ALL ON TABLE login_attempts TO kzqai;
GRANT ALL ON TABLE login_attempts TO developers;
--
-- Name: login_attempts_attempt_id_seq; Type: ACL; Schema: public; Owner: kzqai
--
REVOKE ALL ON SEQUENCE login_attempts_attempt_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE login_attempts_attempt_id_seq FROM kzqai;
GRANT ALL ON SEQUENCE login_attempts_attempt_id_seq TO kzqai;
GRANT ALL ON SEQUENCE login_attempts_attempt_id_seq TO developers;
--
-- Name: messages; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE messages FROM PUBLIC;
REVOKE ALL ON TABLE messages FROM developers;
GRANT ALL ON TABLE messages TO developers;
--
-- Name: past_stats_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE past_stats_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE past_stats_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE past_stats_id_seq TO developers;
--
-- Name: past_stats; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE past_stats FROM PUBLIC;
REVOKE ALL ON TABLE past_stats FROM developers;
GRANT ALL ON TABLE past_stats TO developers;
--
-- Name: player_rank; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE player_rank FROM PUBLIC;
REVOKE ALL ON TABLE player_rank FROM developers;
GRANT ALL ON TABLE player_rank TO developers;
--
-- Name: player_rank_rank_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE player_rank_rank_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE player_rank_rank_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE player_rank_rank_id_seq TO developers;
--
-- Name: players_player_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE players_player_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE players_player_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE players_player_id_seq TO developers;
--
-- Name: players; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE players FROM PUBLIC;
REVOKE ALL ON TABLE players FROM developers;
GRANT ALL ON TABLE players TO developers;
--
-- Name: players_flagged_players_flagged_id_seq; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON SEQUENCE players_flagged_players_flagged_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE players_flagged_players_flagged_id_seq FROM developers;
GRANT SELECT,UPDATE ON SEQUENCE players_flagged_players_flagged_id_seq TO developers;
--
-- Name: players_flagged; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE players_flagged FROM PUBLIC;
REVOKE ALL ON TABLE players_flagged FROM developers;
GRANT ALL ON TABLE players_flagged TO developers;
--
-- Name: ppl_online; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE ppl_online FROM PUBLIC;
REVOKE ALL ON TABLE ppl_online FROM developers;
GRANT ALL ON TABLE ppl_online TO developers;
--
-- Name: rankings; Type: ACL; Schema: public; Owner: kzqai
--
REVOKE ALL ON TABLE rankings FROM PUBLIC;
REVOKE ALL ON TABLE rankings FROM kzqai;
GRANT ALL ON TABLE rankings TO kzqai;
GRANT ALL ON TABLE rankings TO developers;
--
-- Name: settings; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE settings FROM PUBLIC;
REVOKE ALL ON TABLE settings FROM developers;
GRANT ALL ON TABLE settings TO developers;
--
-- Name: time; Type: ACL; Schema: public; Owner: developers
--
REVOKE ALL ON TABLE "time" FROM PUBLIC;
REVOKE ALL ON TABLE "time" FROM developers;
GRANT ALL ON TABLE "time" TO developers;
--
-- PostgreSQL database dump complete
--
toopay revised this gist