Most visitors online was 17251 , on 24 May 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!you can play it over wan ip as long as all the required ports are openAre these files allow you to play over wan ip ? or its just for local test ?
Mega works fine so I don't see a reason to upload it to another host. Besides Mega is the fastest host out there as of now without any limits.Sorry to ask, but can anyone upload the client on another host? Cause Mega now only accepts 5gb for non premium users
Mega works fine so I don't see a reason to upload it to another host. Besides Mega is the fastest host out there as of now without any limits.
its not limited to download
Well, thats not what the site said '-' Maybe is because I live in Brazil and Mega hate us too, like everyone. ^-^
Mega works fine so I don't see a reason to upload it to another host. Besides Mega is the fastest host out there as of now without any limits.
[Err] ERRO: role "eperty123" n�o existe
[Err] --
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'LATIN1';
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';
SET search_path = public, pg_catalog;
--
-- Name: mission_approval_guys(integer); Type: FUNCTION; Schema: public; Owner: Eperty123
--
CREATE FUNCTION mission_approval_guys(mission_id integer, OUT player_id integer) RETURNS SETOF integer
LANGUAGE plpgsql
AS $_$
DECLARE
mid ALIAS FOR $1;
MIDX INT;
MMASK INT;
STATE_BASE INT;
BEGIN
MMASK=07*8 ^((mid-1) % 10);
STATE_BASE=8 ^((mid-1) % 10);
MIDX=(mid-1)/10;
RETURN QUERY SELECT t1.player_id from final_mission_state1 t1 where t1.index=MIDX and (state&MMASK::int)/STATE_BASE=2;
END
$_$;
ALTER FUNCTION public.mission_approval_guys(mission_id integer, OUT player_id integer) OWNER TO Eperty123;
--
-- Name: mission_complete_guys(integer); Type: FUNCTION; Schema: public; Owner: Eperty123
--
CREATE FUNCTION mission_complete_guys(mission_id integer, OUT player_id integer) RETURNS SETOF integer
LANGUAGE plpgsql
AS $_$
DECLARE
mid ALIAS FOR $1;
MIDX INT;
MMASK INT;
STATE_BASE INT;
BEGIN
MMASK=07*8 ^((mid-1) % 10);
STATE_BASE=8 ^((mid-1) % 10);
MIDX=(mid-1)/10;
RETURN QUERY SELECT t1.player_id from final_mission_state1 t1 where t1.index=MIDX and (state&MMASK::int)/STATE_BASE=1;
END
$_$;
ALTER FUNCTION public.mission_complete_guys(mission_id integer, OUT player_id integer) OWNER TO Eperty123;
--
-- Name: mission_none_guys(integer); Type: FUNCTION; Schema: public; Owner: Eperty123
--
CREATE FUNCTION mission_none_guys(mission_id integer, OUT player_id integer) RETURNS SETOF integer
LANGUAGE plpgsql
AS $_$
DECLARE
mid ALIAS FOR $1;
MIDX INT;
MMASK INT;
STATE_BASE INT;
BEGIN
MMASK=07*8 ^((mid-1) % 10);
STATE_BASE=8 ^((mid-1) % 10);
MIDX=(mid-1)/10;
RETURN QUERY SELECT t1.player_id from final_mission_state1 t1 where t1.index=MIDX and (state&MMASK::int)/STATE_BASE=0;
END
$_$;
ALTER FUNCTION public.mission_none_guys(mission_id integer, OUT player_id integer) OWNER TO Eperty123;
--
-- Name: mission_state_decode(integer); Type: FUNCTION; Schema: public; Owner: Eperty123
--
CREATE FUNCTION mission_state_decode(player_id integer, OUT pid integer, OUT mission_id integer, OUT state integer, OUT result text) RETURNS SETOF record
LANGUAGE plpgsql
AS $_$
DECLARE
pid ALIAS FOR $1;
r final_mission_state%rowtype;
midx INT;
I INT;
BEGIN
FOR midx IN SELECT t1.index from final_mission_state as t1
WHERE t1.player_id = pid
LOOP
I=1;
LOOP
--raise notice 'pid is: %', pid;
EXIT WHEN I >= 11;
--raise notice 'midex is: %', midx*10+I-1;
RETURN QUERY SELECT t1.player_id,t1.index*10+I,(t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::INT,CASE
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=0 then 'None'
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=1 then 'Complete'
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=2 then 'Approval'
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=3 then 'OnGoing'
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=4 then 'OnReward'
WHEN (t1.state&(7*8 ^((t1.index*10+I-1) % 10) )::int)/(8 ^((t1.index*10+I-1) % 10))::int=5 then 'Disable'
WHEN (t1.state&(7*8 ^
[Err] ERRO: relação "public.family_schedule" não existe
[Err] ALTER TABLE public.family_schedule OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: family_sprayer; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE family_sprayer (
id integer NOT NULL,
family_id integer NOT NULL,
loc integer NOT NULL,
sprayer_tid integer NOT NULL,
pos_x integer DEFAULT 0,
pos_y integer DEFAULT 0,
record_time integer DEFAULT 0,
due_time integer DEFAULT 0
);
ALTER TABLE public.family_sprayer OWNER TO postgres;
--
-- Name: family_sprayer_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE family_sprayer_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.family_sprayer_id_seq OWNER TO postgres;
--
-- Name: family_sprayer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE family_sprayer_id_seq OWNED BY family_sprayer.id;
--
-- Name: family_storage; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE family_storage (
id integer NOT NULL,
item_id integer NOT NULL,
durability integer NOT NULL,
maker character varying(32) DEFAULT ''::character varying,
identify smallint DEFAULT 1,
embedded_amount integer DEFAULT 0,
embedded_id1 integer DEFAULT (-1),
loc smallint NOT NULL,
create_time integer DEFAULT 1,
due_date integer DEFAULT 0,
combo_id integer DEFAULT 0,
strengthen integer DEFAULT 0,
cur_maxdurability integer DEFAULT 0,
bind integer DEFAULT 0,
family_id integer DEFAULT 0,
container_index smallint NOT NULL,
witchcraft integer DEFAULT 0 NOT NULL,
quality smallint DEFAULT 0,
plus_parameter bigint DEFAULT 0,
color bigint DEFAULT 0,
train_type integer DEFAULT 0,
train_level integer DEFAULT 0,
train_exp integer DEFAULT 0,
attr_factor integer DEFAULT 0,
item_level integer DEFAULT 1,
item_exp integer DEFAULT 0,
embedded_level1 integer DEFAULT 0,
embedded_exp1 integer DEFAULT 0,
combo_id1 integer DEFAULT 0,
combo_plusrate1 integer DEFAULT 0,
combo_id2 integer DEFAULT 0,
combo_plusrate2 integer DEFAULT 0,
combo_id3 integer DEFAULT 0,
combo_plusrate3 integer DEFAULT 0,
combo_id4 integer DEFAULT 0,
combo_plusrate4 integer DEFAULT 0,
embedded_comboid1 integer DEFAULT 0,
embedded_comboid2 integer DEFAULT 0,
rune_combo_id1 integer DEFAULT 0,
modified_times integer DEFAULT 0,
modified_atkspeed integer DEFAULT 0,
modified_attack integer DEFAULT 0,
modified_critical integer DEFAULT 0,
modified_recover integer DEFAULT 0,
modified_maxhp integer DEFAULT 0,
modified_defence integer DEFAULT 0,
modified_dodge integer DEFAULT 0,
modified_level integer DEFAULT 0,
modified_durability integer DEFAULT 0,
witchcraft_1 integer DEFAULT 0,
witchcraft_2 integer DEFAULT 0
);
ALTER TABLE public.family_storage OWNER TO postgres;
--
-- Name: family_storage_log; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE family_storage_log (
family_id integer NOT NULL,
log_type smallint NOT NULL,
log character varying(256) DEFAULT ''::character varying NOT NULL,
log_time integer NOT NULL
);
ALTER TABLE public.family_storage_log OWNER TO postgres;
SET default_with_oids = true;
--
-- Name: final_mission_state1; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE final_mission_state1 (
player_id integer NOT NULL,
index integer NOT NULL,
state integer
);
ALTER TABLE public.final_mission_state1 OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: final_mission_state2; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE final_mission_state2 (
player_id integer NOT NULL,
index integer NOT NULL,
state integer
);
ALTER TABLE public.final_mission_state2 OWNER TO postgres;
--
-- Name: final_mission_state; Type: VIEW; Schema: public; Owner: Eperty123
--
CREATE VIEW final_mission_state AS
SELECT final_mission_st
[Err] ERRO: relação "public.player_characters_achievement" não existe
[Err] ALTER TABLE public.player_characters_achievement OWNER TO postgres;
--
-- Name: player_classlist; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_classlist (
player_id integer NOT NULL,
class integer NOT NULL,
level integer DEFAULT 1,
exp integer DEFAULT 0,
point integer DEFAULT 0,
aa_point integer DEFAULT 0,
style integer DEFAULT 0,
lic_1 integer DEFAULT 0,
lic_2 integer DEFAULT 0,
lic_3 integer DEFAULT 0,
lic_4 integer DEFAULT 0,
lic_5 integer DEFAULT 0,
lic_6 integer DEFAULT 0,
lic_7 integer DEFAULT 0
);
ALTER TABLE public.player_classlist OWNER TO postgres;
--
-- Name: player_closet; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_closet (
player_id integer NOT NULL,
class integer NOT NULL,
index integer NOT NULL,
helmet_color bigint,
clothes_color bigint,
cloak_color bigint
);
ALTER TABLE public.player_closet OWNER TO postgres;
--
-- Name: player_coins; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_coins (
player_id integer NOT NULL,
coin_type integer NOT NULL,
amount integer NOT NULL
);
ALTER TABLE public.player_coins OWNER TO postgres;
--
-- Name: player_colosseum_rank; Type: TABLE; Schema: public; Owner: Eperty123; Tablespace:
--
CREATE TABLE player_colosseum_rank (
player_id integer NOT NULL,
reward_gold integer DEFAULT 0,
defeat integer DEFAULT 0,
update_time integer DEFAULT 0
);
ALTER TABLE public.player_colosseum_rank OWNER TO Eperty123;
--
-- Name: player_destiny_road; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_destiny_road (
player_id integer NOT NULL,
road_id integer NOT NULL,
step integer DEFAULT 0,
dice_time integer DEFAULT 0,
exp_buff integer DEFAULT 0,
start_time integer DEFAULT 0,
end_time integer DEFAULT 0
);
ALTER TABLE public.player_destiny_road OWNER TO postgres;
SET default_with_oids = true;
--
-- Name: player_enchants; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_enchants (
player_id integer NOT NULL,
effect_id integer NOT NULL,
caster_id integer DEFAULT 0,
rest_time integer DEFAULT 0,
factor integer DEFAULT 0,
counter integer DEFAULT 0,
sets character varying(32) DEFAULT ''::character varying,
note text,
stack_count integer DEFAULT 1,
level smallint DEFAULT 1,
target_id integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.player_enchants OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: player_fortune_bag; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_fortune_bag (
account_id integer NOT NULL,
item_id integer NOT NULL,
counter integer DEFAULT 0
);
ALTER TABLE public.player_fortune_bag OWNER TO postgres;
--
-- Name: player_license; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_license (
id integer NOT NULL,
item_id integer NOT NULL,
loc smallint DEFAULT 0
);
ALTER TABLE public.player_license OWNER TO postgres;
SET default_with_oids = true;
--
-- Name: player_mail; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_mail (
id integer NOT NULL,
receiver_id integer NOT NULL,
sender_id integer NOT NULL,
sender_name text DEFAULT ''::character varying,
send_time integer NOT NULL,
due_date integer NOT NULL,
title text DEFAULT ''::character varying,
content text,
item_id integer DEFAULT 0,
gold integer DEFAULT 0,
crystal integer DEFAULT 0,
cod integer DEFAULT 0,
opened integer DEFAULT 0,
returned integer DEFAULT 0,
authoritative integer DEFAULT 0
);
ALTER TABLE public.player_mail OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: player_mail_history; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE player_mail_history (
player_id integer NOT NULL,
target_name characte
[Err] ERRO: erro de sintaxe em ou próximo a "\"
LINE 177: \.
^
[Err] ALTER TABLE public.storage OWNER TO postgres;
--
-- Name: sys_mail_queue; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE sys_mail_queue (
mail_id integer NOT NULL,
receiver_id integer NOT NULL,
clone_item_id integer DEFAULT 0,
state character varying(16) DEFAULT 'New'::character varying,
sender_name character varying(32) DEFAULT ''::character varying,
title character varying(40) DEFAULT ''::character varying,
content character varying DEFAULT ''::character varying,
gold integer DEFAULT 0,
id integer DEFAULT 0,
item_id integer NOT NULL,
durability integer DEFAULT (-1),
maker character varying(32) DEFAULT ''::character varying,
identify smallint DEFAULT 1,
embedded_amount integer DEFAULT 0,
embedded_id1 integer DEFAULT (-1),
create_time integer DEFAULT 1,
due_date integer DEFAULT 0,
combo_id integer DEFAULT 0,
strengthen integer DEFAULT 0,
cur_maxdurability integer DEFAULT 0,
bind integer DEFAULT 0,
witchcraft integer DEFAULT 0,
quality smallint DEFAULT 0,
plus_parameter bigint DEFAULT 0,
color bigint DEFAULT 0,
attr_factor integer DEFAULT 0,
item_level integer DEFAULT 1,
item_exp integer DEFAULT 0,
embedded_level1 integer DEFAULT 0,
embedded_exp1 integer DEFAULT 0,
combo_id1 integer DEFAULT 0,
combo_plusrate1 integer DEFAULT 0,
combo_id2 integer DEFAULT 0,
combo_plusrate2 integer DEFAULT 0,
combo_id3 integer DEFAULT 0,
combo_plusrate3 integer DEFAULT 0,
combo_id4 integer DEFAULT 0,
combo_plusrate4 integer DEFAULT 0,
embedded_comboid1 integer DEFAULT 0,
embedded_comboid2 integer DEFAULT 0,
rune_combo_id1 integer DEFAULT 0,
train_type integer DEFAULT 0,
train_level integer DEFAULT 0,
train_exp integer DEFAULT 0,
modified_times integer DEFAULT 0,
modified_atkspeed integer DEFAULT 0,
modified_attack integer DEFAULT 0,
modified_critical integer DEFAULT 0,
modified_recover integer DEFAULT 0,
modified_maxhp integer DEFAULT 0,
modified_defence integer DEFAULT 0,
modified_dodge integer DEFAULT 0,
modified_level integer DEFAULT 0,
modified_durability integer DEFAULT 0,
witchcraft_1 integer DEFAULT 0,
witchcraft_2 integer DEFAULT 0
);
ALTER TABLE public.sys_mail_queue OWNER TO postgres;
--
-- Name: sys_mail_queue_mail_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE sys_mail_queue_mail_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.sys_mail_queue_mail_id_seq OWNER TO postgres;
--
-- Name: sys_mail_queue_mail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE sys_mail_queue_mail_id_seq OWNED BY sys_mail_queue.mail_id;
SET default_with_oids = true;
--
-- Name: transport; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE transport (
player_id integer NOT NULL,
node_id integer NOT NULL,
eventarea_id integer NOT NULL
);
ALTER TABLE public.transport OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: victory_declaration; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE victory_declaration (
player_id integer NOT NULL,
content character varying NOT NULL,
lose_content character varying DEFAULT ''::character varying NOT NULL,
hello_content character varying DEFAULT ''::character varying
);
ALTER TABLE public.victory_declaration OWNER TO postgres;
--
-- Name: weaponexp; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE weaponexp (
player_id integer NOT NULL,
type smallint NOT NULL,
level smallint DEFAULT 0,
exp integer DEFAULT 0,
skillpoint smallint DEFAULT 0
);
ALTER TABLE public.weaponexp OWNER TO postgres;
--
-- Name: week_update; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE week_update (
type_name character varying(32) DEFAULT ''::character varying NOT NULL,
next_update_time
[Err] ERRO: erro de sintaxe em ou próximo a "\"
LINE 2: \.
^
[Err] \.
--
-- Data for Name: player_fortune_bag; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_fortune_bag (account_id, item_id, counter) FROM stdin;
\.
--
-- Data for Name: player_license; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_license (id, item_id, loc) FROM stdin;
\.
--
-- Data for Name: player_mail; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mail (id, receiver_id, sender_id, sender_name, send_time, due_date, title, content, item_id, gold, crystal, cod, opened, returned, authoritative) FROM stdin;
\.
--
-- Data for Name: player_mail_history; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mail_history (player_id, target_name, date) FROM stdin;
\.
--
-- Data for Name: player_memories1; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_memories1 (player_id, memories_id, reset_time, completed_num, completed_time, extra_info) FROM stdin;
\.
--
-- Data for Name: player_memories2; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_memories2 (player_id, memories_id, reset_time, completed_num, completed_time, extra_info) FROM stdin;
\.
--
-- Data for Name: player_mission_complete_num; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mission_complete_num (player_id, mission_id, complete_num, cycle_finish_state, cycle_daily_reset) FROM stdin;
\.
--
-- Data for Name: player_mission_rank_point; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mission_rank_point (player_id, mission_point, prestige_point, achievement_point) FROM stdin;
\.
--
-- Data for Name: player_node_times; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_node_times (player_id, node_id, node_times) FROM stdin;
\.
--
-- Data for Name: player_potential_point; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_potential_point (player_id, point1, point2, point3, point4, point5, point6, atk, def) FROM stdin;
\.
--
-- Data for Name: player_reset_time; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_reset_time (player_id, reset_type, reset_time) FROM stdin;
\.
--
-- Data for Name: player_room; Type: TABLE DATA; Schema: public; Owner: Eperty123
--
COPY player_room (player_id, player_name, hotel_type, friend_privilege, family_privilege, lover_privilege, other_privilege, populity, extend, due_date, wallpaper, living_floor, bed_floor, party_time, dog_gifts) FROM stdin;
\.
--
-- Data for Name: player_room_container; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_room_container (id, item_id, durability, maker, identify, embedded_amount, embedded_id1, create_time, due_date, container_index, combo_id, strengthen, cur_maxdurability, bind, player_id, loc, witchcraft, quality, plus_parameter, color, attr_factor, item_level, item_exp, embedded_level1, embedded_exp1, combo_id1, combo_plusrate1, combo_id2, combo_plusrate2, combo_id3, combo_plusrate3, combo_id4, combo_plusrate4, embedded_comboid1, embedded_comboid2, rune_combo_id1, train_type, train_level, train_exp, modified_times, modified_atkspeed, modified_attack, modified_critical, modified_recover, modified_maxhp, modified_defence, modified_dodge, modified_level, modified_durability, witchcraft_1, witchcraft_2) FROM stdin;
\.
--
-- Data for Name: player_room_garden_mound; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_room_garden_mound (room_id, mound_index, mound_state, state_start_time, gift_item_id, item_amount, giver) FROM stdin;
\.
--
-- Data for Name: player_sky_tower; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_sky_tower (player_id, tower_id, play_times) FROM stdin;
\.
--
-- Data for Name: player_spellcards; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_spellcards (player_id, enchant_type, item_id) FROM stdin;
\.
--
-- Data for Name: player_spells; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_spells (player_id, spellmaster_id, spell_order, spell_level) FROM stdin;
\.
--
-- Data for Na
[Err] ERRO: relação "recommended_events" não existe
[Err] --
-- Name: recommended_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY recommended_events
ADD CONSTRAINT recommended_events_pkey PRIMARY KEY (player_id, recommended_id);
--
-- Name: serverstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY serverstatus
ADD CONSTRAINT serverstatus_pkey PRIMARY KEY (id);
--
-- Name: sky_tower_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY sky_tower
ADD CONSTRAINT sky_tower_pkey PRIMARY KEY (tower_id);
--
-- Name: statistics_monster_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statistics_monster
ADD CONSTRAINT statistics_monster_pkey PRIMARY KEY (handle);
--
-- Name: statistics_player_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statistics_player
ADD CONSTRAINT statistics_player_pkey PRIMARY KEY (level);
--
-- Name: statues_scenes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statues_scenes
ADD CONSTRAINT statues_scenes_pkey PRIMARY KEY (worldserver_id, node_id, template_id, family_id);
--
-- Name: storage1_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY storage1
ADD CONSTRAINT storage1_pkey PRIMARY KEY (id);
--
-- Name: storage2_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY storage2
ADD CONSTRAINT storage2_pkey PRIMARY KEY (id);
--
-- Name: victory_declaration_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY victory_declaration
ADD CONSTRAINT victory_declaration_pkey PRIMARY KEY (player_id);
--
-- Name: weaponexp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY weaponexp
ADD CONSTRAINT weaponexp_pkey PRIMARY KEY (player_id, type);
--
-- Name: week_update_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY week_update
ADD CONSTRAINT week_update_pkey PRIMARY KEY (type_name);
--
-- Name: account_dyeing_item_indexs; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_dyeing_item_indexs ON account_dyeing_item USING btree (account_id, item_id);
--
-- Name: account_lottery_storage_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_lottery_storage_index ON account_lottery_storage USING btree (account_id, loc);
--
-- Name: account_storage_bags_container_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_storage_bags_container_index ON account_storage_bags USING btree (account_id, container_index);
--
-- Name: account_storage_bags_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_storage_bags_loc_index ON account_storage_bags USING btree (account_id, container_index, loc);
--
-- Name: account_storage_container_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_storage_container_index ON account_storage USING btree (account_id, container_index);
--
-- Name: account_storage_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_storage_loc_index ON account_storage USING btree (account_id, container_index, loc);
--
-- Name: achievement_reset_time_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX achievement_reset_time_index ON achievement_reset_time USING btree (account_id);
--
-- Name: advanced_ability_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX advanced_ability_index ON advanced_ability USING btree (player_id, effect_id);
--
-- Name: auction_auction_price_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX auction_auction_price_index ON auction USING btree (auction_price);
--
--
[Err] ERRO: relação "rank_award_mail_queue" não existe
[Err] --
-- Name: rank_award_mail_queue_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX rank_award_mail_queue_index ON rank_award_mail_queue USING btree (receiver_id);
--
-- Name: recommended_events_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX recommended_events_index ON recommended_events USING btree (player_id);
--
-- Name: shortcut_menu_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX shortcut_menu_index ON shortcut_menu USING btree (character_id, page, class);
--
-- Name: storage1_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX storage1_loc_index ON storage1 USING btree (player_id, container_index, loc);
--
-- Name: storage2_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX storage2_loc_index ON storage2 USING btree (player_id, container_index, loc);
--
-- Name: sys_mail_queue_receiver_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX sys_mail_queue_receiver_index ON sys_mail_queue USING btree (receiver_id);
--
-- Name: transport_ci_node_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX transport_ci_node_index ON transport USING btree (player_id, node_id);
--
-- Name: week_update_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX week_update_index ON week_update USING btree (type_name);
--
-- 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: account_dyeing_item; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_dyeing_item FROM PUBLIC;
REVOKE ALL ON TABLE account_dyeing_item FROM postgres;
GRANT ALL ON TABLE account_dyeing_item TO postgres;
GRANT ALL ON TABLE account_dyeing_item TO Eperty123;
--
-- Name: account_lottery_storage; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_lottery_storage FROM PUBLIC;
REVOKE ALL ON TABLE account_lottery_storage FROM postgres;
GRANT ALL ON TABLE account_lottery_storage TO postgres;
GRANT ALL ON TABLE account_lottery_storage TO Eperty123;
--
-- Name: account_storage; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_storage FROM PUBLIC;
REVOKE ALL ON TABLE account_storage FROM postgres;
GRANT ALL ON TABLE account_storage TO postgres;
GRANT ALL ON TABLE account_storage TO Eperty123;
--
-- Name: account_storage_bags; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_storage_bags FROM PUBLIC;
REVOKE ALL ON TABLE account_storage_bags FROM postgres;
GRANT ALL ON TABLE account_storage_bags TO postgres;
GRANT ALL ON TABLE account_storage_bags TO Eperty123;
--
-- Name: achievement_reset_time; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE achievement_reset_time FROM PUBLIC;
REVOKE ALL ON TABLE achievement_reset_time FROM postgres;
GRANT ALL ON TABLE achievement_reset_time TO postgres;
GRANT ALL ON TABLE achievement_reset_time TO Eperty123;
--
-- Name: advanced_ability; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE advanced_ability FROM PUBLIC;
REVOKE ALL ON TABLE advanced_ability FROM postgres;
GRANT ALL ON TABLE advanced_ability TO postgres;
GRANT ALL ON TABLE advanced_ability TO Eperty123;
--
-- Name: auction; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE auction FROM PUBLIC;
REVOKE ALL ON TABLE auction FROM postgres;
GRANT ALL ON TABLE auction TO postgres;
GRANT ALL ON TABLE auction TO Eperty123;
--
-- Name: bags; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE bags FROM PUBLIC;
REVOKE ALL ON TABLE bags FROM postgres;
GRANT ALL ON TABLE bags TO postgres;
GRANT ALL ON TABLE bags TO Eperty123;
--
-- Name: beginner_tutorial; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE beginne
[Err] ERRO: relação "family_crop" não existe
[Err] GRANT ALL ON TABLE family_crop TO Eperty123;
--
-- Name: family_crop_enchants; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_crop_enchants FROM PUBLIC;
REVOKE ALL ON TABLE family_crop_enchants FROM postgres;
GRANT ALL ON TABLE family_crop_enchants TO postgres;
GRANT ALL ON TABLE family_crop_enchants TO Eperty123;
--
-- Name: family_crop_id_seq; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON SEQUENCE family_crop_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE family_crop_id_seq FROM postgres;
GRANT ALL ON SEQUENCE family_crop_id_seq TO postgres;
GRANT ALL ON SEQUENCE family_crop_id_seq TO Eperty123;
--
-- Name: family_emblem; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_emblem FROM PUBLIC;
REVOKE ALL ON TABLE family_emblem FROM postgres;
GRANT ALL ON TABLE family_emblem TO postgres;
GRANT ALL ON TABLE family_emblem TO Eperty123;
--
-- Name: family_farm_donation; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_farm_donation FROM PUBLIC;
REVOKE ALL ON TABLE family_farm_donation FROM postgres;
GRANT ALL ON TABLE family_farm_donation TO postgres;
GRANT ALL ON TABLE family_farm_donation TO Eperty123;
--
-- Name: family_log; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_log FROM PUBLIC;
REVOKE ALL ON TABLE family_log FROM postgres;
GRANT ALL ON TABLE family_log TO postgres;
GRANT ALL ON TABLE family_log TO Eperty123;
--
-- Name: family_msgboard; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_msgboard FROM PUBLIC;
REVOKE ALL ON TABLE family_msgboard FROM postgres;
GRANT ALL ON TABLE family_msgboard TO postgres;
GRANT ALL ON TABLE family_msgboard TO Eperty123;
--
-- Name: family_personal_infos; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_personal_infos FROM PUBLIC;
REVOKE ALL ON TABLE family_personal_infos FROM postgres;
GRANT ALL ON TABLE family_personal_infos TO postgres;
GRANT ALL ON TABLE family_personal_infos TO Eperty123;
--
-- Name: family_schedule; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_schedule FROM PUBLIC;
REVOKE ALL ON TABLE family_schedule FROM postgres;
GRANT ALL ON TABLE family_schedule TO postgres;
GRANT ALL ON TABLE family_schedule TO Eperty123;
--
-- Name: family_sprayer; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_sprayer FROM PUBLIC;
REVOKE ALL ON TABLE family_sprayer FROM postgres;
GRANT ALL ON TABLE family_sprayer TO postgres;
GRANT ALL ON TABLE family_sprayer TO Eperty123;
--
-- Name: family_sprayer_id_seq; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON SEQUENCE family_sprayer_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE family_sprayer_id_seq FROM postgres;
GRANT ALL ON SEQUENCE family_sprayer_id_seq TO postgres;
GRANT ALL ON SEQUENCE family_sprayer_id_seq TO Eperty123;
--
-- Name: family_storage; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_storage FROM PUBLIC;
REVOKE ALL ON TABLE family_storage FROM postgres;
GRANT ALL ON TABLE family_storage TO postgres;
GRANT ALL ON TABLE family_storage TO Eperty123;
--
-- Name: family_storage_log; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE family_storage_log FROM PUBLIC;
REVOKE ALL ON TABLE family_storage_log FROM postgres;
GRANT ALL ON TABLE family_storage_log TO postgres;
GRANT ALL ON TABLE family_storage_log TO Eperty123;
--
-- Name: final_mission_state1; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE final_mission_state1 FROM PUBLIC;
REVOKE ALL ON TABLE final_mission_state1 FROM postgres;
GRANT ALL ON TABLE final_mission_state1 TO postgres;
GRANT ALL ON TABLE final_mission_state1 TO Eperty123;
--
-- Name: final_mission_state2; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE final_mission_state2 FROM PUBLIC;
REVOKE ALL ON TABLE final_mission_state2 FROM postgres;
GRANT ALL ON TABLE final_mission_state2 TO postgres;
GRANT ALL ON TABLE final_mission_state2 TO Eperty123;
--
-- Name: friends; Typ
[Err] ERRO: relação "lover" não existe
[Err] GRANT ALL ON TABLE lover TO Eperty123;
--
-- Name: mailitem; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE mailitem FROM PUBLIC;
REVOKE ALL ON TABLE mailitem FROM postgres;
GRANT ALL ON TABLE mailitem TO postgres;
GRANT ALL ON TABLE mailitem TO Eperty123;
--
-- Name: making_item_ways; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE making_item_ways FROM PUBLIC;
REVOKE ALL ON TABLE making_item_ways FROM postgres;
GRANT ALL ON TABLE making_item_ways TO postgres;
GRANT ALL ON TABLE making_item_ways TO Eperty123;
--
-- Name: message_board; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE message_board FROM PUBLIC;
REVOKE ALL ON TABLE message_board FROM postgres;
GRANT ALL ON TABLE message_board TO postgres;
GRANT ALL ON TABLE message_board TO Eperty123;
--
-- Name: message_boards; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE message_boards FROM PUBLIC;
REVOKE ALL ON TABLE message_boards FROM postgres;
GRANT ALL ON TABLE message_boards TO postgres;
GRANT ALL ON TABLE message_boards TO Eperty123;
--
-- Name: midnight_limit; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE midnight_limit FROM PUBLIC;
REVOKE ALL ON TABLE midnight_limit FROM postgres;
GRANT ALL ON TABLE midnight_limit TO postgres;
GRANT ALL ON TABLE midnight_limit TO Eperty123;
--
-- Name: mission_trace; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE mission_trace FROM PUBLIC;
REVOKE ALL ON TABLE mission_trace FROM postgres;
GRANT ALL ON TABLE mission_trace TO postgres;
GRANT ALL ON TABLE mission_trace TO Eperty123;
--
-- Name: node_stream; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE node_stream FROM PUBLIC;
REVOKE ALL ON TABLE node_stream FROM postgres;
GRANT ALL ON TABLE node_stream TO postgres;
GRANT ALL ON TABLE node_stream TO Eperty123;
--
-- Name: personal_mission_states; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE personal_mission_states FROM PUBLIC;
REVOKE ALL ON TABLE personal_mission_states FROM postgres;
GRANT ALL ON TABLE personal_mission_states TO postgres;
GRANT ALL ON TABLE personal_mission_states TO Eperty123;
--
-- Name: pet_dictionary; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE pet_dictionary FROM PUBLIC;
REVOKE ALL ON TABLE pet_dictionary FROM postgres;
GRANT ALL ON TABLE pet_dictionary TO postgres;
GRANT ALL ON TABLE pet_dictionary TO Eperty123;
--
-- Name: player_achievement_coins; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_achievement_coins FROM PUBLIC;
REVOKE ALL ON TABLE player_achievement_coins FROM postgres;
GRANT ALL ON TABLE player_achievement_coins TO postgres;
GRANT ALL ON TABLE player_achievement_coins TO Eperty123;
--
-- Name: player_achievement_rank; Type: ACL; Schema: public; Owner: Eperty123
--
REVOKE ALL ON TABLE player_achievement_rank FROM PUBLIC;
REVOKE ALL ON TABLE player_achievement_rank FROM Eperty123;
GRANT ALL ON TABLE player_achievement_rank TO Eperty123;
--
-- Name: player_adventure_enchants; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_adventure_enchants FROM PUBLIC;
REVOKE ALL ON TABLE player_adventure_enchants FROM postgres;
GRANT ALL ON TABLE player_adventure_enchants TO postgres;
GRANT ALL ON TABLE player_adventure_enchants TO Eperty123;
--
-- Name: player_alchemy; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_alchemy FROM PUBLIC;
REVOKE ALL ON TABLE player_alchemy FROM postgres;
GRANT ALL ON TABLE player_alchemy TO postgres;
GRANT ALL ON TABLE player_alchemy TO Eperty123;
--
-- Name: player_appellation; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_appellation FROM PUBLIC;
REVOKE ALL ON TABLE player_appellation FROM postgres;
GRANT ALL ON TABLE player_appellation TO postgres;
GRANT ALL ON TABLE player_appellation TO Eperty123;
--
-- Name: player_battlefield_rank; Type: ACL; Schema: public; Owner: Eperty123
--
REVOKE ALL ON TABLE player_battlefield_rank FROM PUBLIC;
REVOKE ALL
[Err] ERRO: relação "player_mail_history" não existe
[Err] GRANT ALL ON TABLE player_mail_history TO postgres;
GRANT ALL ON TABLE player_mail_history TO Eperty123;
--
-- Name: player_memories1; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_memories1 FROM PUBLIC;
REVOKE ALL ON TABLE player_memories1 FROM postgres;
GRANT ALL ON TABLE player_memories1 TO postgres;
GRANT ALL ON TABLE player_memories1 TO Eperty123;
--
-- Name: player_memories2; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_memories2 FROM PUBLIC;
REVOKE ALL ON TABLE player_memories2 FROM postgres;
GRANT ALL ON TABLE player_memories2 TO postgres;
GRANT ALL ON TABLE player_memories2 TO Eperty123;
--
-- Name: player_memories; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_memories FROM PUBLIC;
REVOKE ALL ON TABLE player_memories FROM postgres;
GRANT ALL ON TABLE player_memories TO postgres;
GRANT ALL ON TABLE player_memories TO Eperty123;
--
-- Name: player_mission_complete_num; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_mission_complete_num FROM PUBLIC;
REVOKE ALL ON TABLE player_mission_complete_num FROM postgres;
GRANT ALL ON TABLE player_mission_complete_num TO postgres;
GRANT ALL ON TABLE player_mission_complete_num TO Eperty123;
--
-- Name: player_mission_rank_point; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_mission_rank_point FROM PUBLIC;
REVOKE ALL ON TABLE player_mission_rank_point FROM postgres;
GRANT ALL ON TABLE player_mission_rank_point TO postgres;
GRANT ALL ON TABLE player_mission_rank_point TO Eperty123;
--
-- Name: player_node_times; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_node_times FROM PUBLIC;
REVOKE ALL ON TABLE player_node_times FROM postgres;
GRANT ALL ON TABLE player_node_times TO postgres;
GRANT ALL ON TABLE player_node_times TO Eperty123;
--
-- Name: player_potential_point; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_potential_point FROM PUBLIC;
REVOKE ALL ON TABLE player_potential_point FROM postgres;
GRANT ALL ON TABLE player_potential_point TO postgres;
GRANT ALL ON TABLE player_potential_point TO Eperty123;
--
-- Name: player_reset_time; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_reset_time FROM PUBLIC;
REVOKE ALL ON TABLE player_reset_time FROM postgres;
GRANT ALL ON TABLE player_reset_time TO postgres;
GRANT ALL ON TABLE player_reset_time TO Eperty123;
--
-- Name: player_room; Type: ACL; Schema: public; Owner: Eperty123
--
REVOKE ALL ON TABLE player_room FROM PUBLIC;
REVOKE ALL ON TABLE player_room FROM Eperty123;
GRANT ALL ON TABLE player_room TO Eperty123;
--
-- Name: player_room_container; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_room_container FROM PUBLIC;
REVOKE ALL ON TABLE player_room_container FROM postgres;
GRANT ALL ON TABLE player_room_container TO postgres;
GRANT ALL ON TABLE player_room_container TO Eperty123;
--
-- Name: player_room_garden_mound; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_room_garden_mound FROM PUBLIC;
REVOKE ALL ON TABLE player_room_garden_mound FROM postgres;
GRANT ALL ON TABLE player_room_garden_mound TO postgres;
GRANT ALL ON TABLE player_room_garden_mound TO Eperty123;
--
-- Name: player_spellcards; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_spellcards FROM PUBLIC;
REVOKE ALL ON TABLE player_spellcards FROM postgres;
GRANT ALL ON TABLE player_spellcards TO postgres;
GRANT ALL ON TABLE player_spellcards TO Eperty123;
--
-- Name: player_spells; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_spells FROM PUBLIC;
REVOKE ALL ON TABLE player_spells FROM postgres;
GRANT ALL ON TABLE player_spells TO postgres;
GRANT ALL ON TABLE player_spells TO Eperty123;
--
-- Name: player_used_upanisad; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE player_used_upanisad FROM PUBLIC;
REVOKE ALL ON TABLE player_used_upanisad FROM postgres;
GRANT ALL ON TABLE player_use
[Err] ERRO: relação "statistics_monster" não existe
[Err] GRANT ALL ON TABLE statistics_monster TO Eperty123;
--
-- Name: statistics_player; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE statistics_player FROM PUBLIC;
REVOKE ALL ON TABLE statistics_player FROM postgres;
GRANT ALL ON TABLE statistics_player TO postgres;
GRANT ALL ON TABLE statistics_player TO Eperty123;
--
-- Name: statues_scenes; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE statues_scenes FROM PUBLIC;
REVOKE ALL ON TABLE statues_scenes FROM postgres;
GRANT ALL ON TABLE statues_scenes TO postgres;
GRANT ALL ON TABLE statues_scenes TO Eperty123;
--
-- Name: storage1; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE storage1 FROM PUBLIC;
REVOKE ALL ON TABLE storage1 FROM postgres;
GRANT ALL ON TABLE storage1 TO postgres;
GRANT ALL ON TABLE storage1 TO Eperty123;
--
-- Name: storage2; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE storage2 FROM PUBLIC;
REVOKE ALL ON TABLE storage2 FROM postgres;
GRANT ALL ON TABLE storage2 TO postgres;
GRANT ALL ON TABLE storage2 TO Eperty123;
--
-- Name: transport; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE transport FROM PUBLIC;
REVOKE ALL ON TABLE transport FROM postgres;
GRANT ALL ON TABLE transport TO postgres;
GRANT ALL ON TABLE transport TO Eperty123;
--
-- Name: victory_declaration; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE victory_declaration FROM PUBLIC;
REVOKE ALL ON TABLE victory_declaration FROM postgres;
GRANT ALL ON TABLE victory_declaration TO postgres;
GRANT ALL ON TABLE victory_declaration TO Eperty123;
--
-- Name: weaponexp; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE weaponexp FROM PUBLIC;
REVOKE ALL ON TABLE weaponexp FROM postgres;
GRANT ALL ON TABLE weaponexp TO postgres;
GRANT ALL ON TABLE weaponexp TO Eperty123;
--
-- Name: week_update; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE week_update FROM PUBLIC;
REVOKE ALL ON TABLE week_update FROM postgres;
GRANT ALL ON TABLE week_update TO postgres;
GRANT ALL ON TABLE week_update TO Eperty123;
--
-- PostgreSQL database dump complete
--
[Msg] Finished - Unsuccessfully
--------------------------------------------------
[Err] ERRO: erro de sintaxe em ou pr�ximo a "\"
LINE 177: \.
^
[Err] ALTER TABLE public.storage OWNER TO postgres;
--
-- Name: sys_mail_queue; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE sys_mail_queue (
mail_id integer NOT NULL,
receiver_id integer NOT NULL,
clone_item_id integer DEFAULT 0,
state character varying(16) DEFAULT 'New'::character varying,
sender_name character varying(32) DEFAULT ''::character varying,
title character varying(40) DEFAULT ''::character varying,
content character varying DEFAULT ''::character varying,
gold integer DEFAULT 0,
id integer DEFAULT 0,
item_id integer NOT NULL,
durability integer DEFAULT (-1),
maker character varying(32) DEFAULT ''::character varying,
identify smallint DEFAULT 1,
embedded_amount integer DEFAULT 0,
embedded_id1 integer DEFAULT (-1),
create_time integer DEFAULT 1,
due_date integer DEFAULT 0,
combo_id integer DEFAULT 0,
strengthen integer DEFAULT 0,
cur_maxdurability integer DEFAULT 0,
bind integer DEFAULT 0,
witchcraft integer DEFAULT 0,
quality smallint DEFAULT 0,
plus_parameter bigint DEFAULT 0,
color bigint DEFAULT 0,
attr_factor integer DEFAULT 0,
item_level integer DEFAULT 1,
item_exp integer DEFAULT 0,
embedded_level1 integer DEFAULT 0,
embedded_exp1 integer DEFAULT 0,
combo_id1 integer DEFAULT 0,
combo_plusrate1 integer DEFAULT 0,
combo_id2 integer DEFAULT 0,
combo_plusrate2 integer DEFAULT 0,
combo_id3 integer DEFAULT 0,
combo_plusrate3 integer DEFAULT 0,
combo_id4 integer DEFAULT 0,
combo_plusrate4 integer DEFAULT 0,
embedded_comboid1 integer DEFAULT 0,
embedded_comboid2 integer DEFAULT 0,
rune_combo_id1 integer DEFAULT 0,
train_type integer DEFAULT 0,
train_level integer DEFAULT 0,
train_exp integer DEFAULT 0,
modified_times integer DEFAULT 0,
modified_atkspeed integer DEFAULT 0,
modified_attack integer DEFAULT 0,
modified_critical integer DEFAULT 0,
modified_recover integer DEFAULT 0,
modified_maxhp integer DEFAULT 0,
modified_defence integer DEFAULT 0,
modified_dodge integer DEFAULT 0,
modified_level integer DEFAULT 0,
modified_durability integer DEFAULT 0,
witchcraft_1 integer DEFAULT 0,
witchcraft_2 integer DEFAULT 0
);
ALTER TABLE public.sys_mail_queue OWNER TO postgres;
--
-- Name: sys_mail_queue_mail_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE sys_mail_queue_mail_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.sys_mail_queue_mail_id_seq OWNER TO postgres;
--
-- Name: sys_mail_queue_mail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE sys_mail_queue_mail_id_seq OWNED BY sys_mail_queue.mail_id;
SET default_with_oids = true;
--
-- Name: transport; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE transport (
player_id integer NOT NULL,
node_id integer NOT NULL,
eventarea_id integer NOT NULL
);
ALTER TABLE public.transport OWNER TO postgres;
SET default_with_oids = false;
--
-- Name: victory_declaration; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE victory_declaration (
player_id integer NOT NULL,
content character varying NOT NULL,
lose_content character varying DEFAULT ''::character varying NOT NULL,
hello_content character varying DEFAULT ''::character varying
);
ALTER TABLE public.victory_declaration OWNER TO postgres;
--
-- Name: weaponexp; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE weaponexp (
player_id integer NOT NULL,
type smallint NOT NULL,
level smallint DEFAULT 0,
exp integer DEFAULT 0,
skillpoint smallint DEFAULT 0
);
ALTER TABLE public.weaponexp OWNER TO postgres;
--
-- Name: week_update; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
CREATE TABLE week_update (
type_name character varying(32) DEFAULT ''::character varying NOT NULL,
next_update_time
[Err] ERRO: erro de sintaxe em ou pr�ximo a "\"
LINE 2: \.
^
[Err] \.
--
-- Data for Name: player_fortune_bag; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_fortune_bag (account_id, item_id, counter) FROM stdin;
\.
--
-- Data for Name: player_license; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_license (id, item_id, loc) FROM stdin;
\.
--
-- Data for Name: player_mail; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mail (id, receiver_id, sender_id, sender_name, send_time, due_date, title, content, item_id, gold, crystal, cod, opened, returned, authoritative) FROM stdin;
\.
--
-- Data for Name: player_mail_history; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mail_history (player_id, target_name, date) FROM stdin;
\.
--
-- Data for Name: player_memories1; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_memories1 (player_id, memories_id, reset_time, completed_num, completed_time, extra_info) FROM stdin;
\.
--
-- Data for Name: player_memories2; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_memories2 (player_id, memories_id, reset_time, completed_num, completed_time, extra_info) FROM stdin;
\.
--
-- Data for Name: player_mission_complete_num; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mission_complete_num (player_id, mission_id, complete_num, cycle_finish_state, cycle_daily_reset) FROM stdin;
\.
--
-- Data for Name: player_mission_rank_point; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_mission_rank_point (player_id, mission_point, prestige_point, achievement_point) FROM stdin;
\.
--
-- Data for Name: player_node_times; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_node_times (player_id, node_id, node_times) FROM stdin;
\.
--
-- Data for Name: player_potential_point; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_potential_point (player_id, point1, point2, point3, point4, point5, point6, atk, def) FROM stdin;
\.
--
-- Data for Name: player_reset_time; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_reset_time (player_id, reset_type, reset_time) FROM stdin;
\.
--
-- Data for Name: player_room; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_room (player_id, player_name, hotel_type, friend_privilege, family_privilege, lover_privilege, other_privilege, populity, extend, due_date, wallpaper, living_floor, bed_floor, party_time, dog_gifts) FROM stdin;
\.
--
-- Data for Name: player_room_container; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_room_container (id, item_id, durability, maker, identify, embedded_amount, embedded_id1, create_time, due_date, container_index, combo_id, strengthen, cur_maxdurability, bind, player_id, loc, witchcraft, quality, plus_parameter, color, attr_factor, item_level, item_exp, embedded_level1, embedded_exp1, combo_id1, combo_plusrate1, combo_id2, combo_plusrate2, combo_id3, combo_plusrate3, combo_id4, combo_plusrate4, embedded_comboid1, embedded_comboid2, rune_combo_id1, train_type, train_level, train_exp, modified_times, modified_atkspeed, modified_attack, modified_critical, modified_recover, modified_maxhp, modified_defence, modified_dodge, modified_level, modified_durability, witchcraft_1, witchcraft_2) FROM stdin;
\.
--
-- Data for Name: player_room_garden_mound; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_room_garden_mound (room_id, mound_index, mound_state, state_start_time, gift_item_id, item_amount, giver) FROM stdin;
\.
--
-- Data for Name: player_sky_tower; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_sky_tower (player_id, tower_id, play_times) FROM stdin;
\.
--
-- Data for Name: player_spellcards; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_spellcards (player_id, enchant_type, item_id) FROM stdin;
\.
--
-- Data for Name: player_spells; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY player_spells (player_id, spellmaster_id, spell_order, spell_level) FROM stdin;
\.
--
-- Data for Nam
[Err] ERRO: rela��o "victory_declaration" n�o existe
[Err] --
-- Name: recommended_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY recommended_events
ADD CONSTRAINT recommended_events_pkey PRIMARY KEY (player_id, recommended_id);
--
-- Name: serverstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY serverstatus
ADD CONSTRAINT serverstatus_pkey PRIMARY KEY (id);
--
-- Name: sky_tower_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY sky_tower
ADD CONSTRAINT sky_tower_pkey PRIMARY KEY (tower_id);
--
-- Name: statistics_monster_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statistics_monster
ADD CONSTRAINT statistics_monster_pkey PRIMARY KEY (handle);
--
-- Name: statistics_player_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statistics_player
ADD CONSTRAINT statistics_player_pkey PRIMARY KEY (level);
--
-- Name: statues_scenes_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY statues_scenes
ADD CONSTRAINT statues_scenes_pkey PRIMARY KEY (worldserver_id, node_id, template_id, family_id);
--
-- Name: storage1_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY storage1
ADD CONSTRAINT storage1_pkey PRIMARY KEY (id);
--
-- Name: storage2_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY storage2
ADD CONSTRAINT storage2_pkey PRIMARY KEY (id);
--
-- Name: victory_declaration_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY victory_declaration
ADD CONSTRAINT victory_declaration_pkey PRIMARY KEY (player_id);
--
-- Name: weaponexp_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY weaponexp
ADD CONSTRAINT weaponexp_pkey PRIMARY KEY (player_id, type);
--
-- Name: week_update_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
ALTER TABLE ONLY week_update
ADD CONSTRAINT week_update_pkey PRIMARY KEY (type_name);
--
-- Name: account_dyeing_item_indexs; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_dyeing_item_indexs ON account_dyeing_item USING btree (account_id, item_id);
--
-- Name: account_lottery_storage_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_lottery_storage_index ON account_lottery_storage USING btree (account_id, loc);
--
-- Name: account_storage_bags_container_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_storage_bags_container_index ON account_storage_bags USING btree (account_id, container_index);
--
-- Name: account_storage_bags_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_storage_bags_loc_index ON account_storage_bags USING btree (account_id, container_index, loc);
--
-- Name: account_storage_container_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX account_storage_container_index ON account_storage USING btree (account_id, container_index);
--
-- Name: account_storage_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX account_storage_loc_index ON account_storage USING btree (account_id, container_index, loc);
--
-- Name: achievement_reset_time_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX achievement_reset_time_index ON achievement_reset_time USING btree (account_id);
--
-- Name: advanced_ability_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX advanced_ability_index ON advanced_ability USING btree (player_id, effect_id);
--
-- Name: auction_auction_price_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX auction_auction_price_index ON auction USING btree (auction_price);
--
--
[Err] ERRO: rela��o "sys_mail_queue" n�o existe
[Err] --
-- Name: rank_award_mail_queue_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX rank_award_mail_queue_index ON rank_award_mail_queue USING btree (receiver_id);
--
-- Name: recommended_events_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX recommended_events_index ON recommended_events USING btree (player_id);
--
-- Name: shortcut_menu_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX shortcut_menu_index ON shortcut_menu USING btree (character_id, page, class);
--
-- Name: storage1_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX storage1_loc_index ON storage1 USING btree (player_id, container_index, loc);
--
-- Name: storage2_loc_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX storage2_loc_index ON storage2 USING btree (player_id, container_index, loc);
--
-- Name: sys_mail_queue_receiver_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX sys_mail_queue_receiver_index ON sys_mail_queue USING btree (receiver_id);
--
-- Name: transport_ci_node_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE UNIQUE INDEX transport_ci_node_index ON transport USING btree (player_id, node_id);
--
-- Name: week_update_index; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
--
CREATE INDEX week_update_index ON week_update USING btree (type_name);
--
-- 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: account_dyeing_item; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_dyeing_item FROM PUBLIC;
REVOKE ALL ON TABLE account_dyeing_item FROM postgres;
GRANT ALL ON TABLE account_dyeing_item TO postgres;
GRANT ALL ON TABLE account_dyeing_item TO postgres;
--
-- Name: account_lottery_storage; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_lottery_storage FROM PUBLIC;
REVOKE ALL ON TABLE account_lottery_storage FROM postgres;
GRANT ALL ON TABLE account_lottery_storage TO postgres;
GRANT ALL ON TABLE account_lottery_storage TO postgres;
--
-- Name: account_storage; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_storage FROM PUBLIC;
REVOKE ALL ON TABLE account_storage FROM postgres;
GRANT ALL ON TABLE account_storage TO postgres;
GRANT ALL ON TABLE account_storage TO postgres;
--
-- Name: account_storage_bags; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE account_storage_bags FROM PUBLIC;
REVOKE ALL ON TABLE account_storage_bags FROM postgres;
GRANT ALL ON TABLE account_storage_bags TO postgres;
GRANT ALL ON TABLE account_storage_bags TO postgres;
--
-- Name: achievement_reset_time; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE achievement_reset_time FROM PUBLIC;
REVOKE ALL ON TABLE achievement_reset_time FROM postgres;
GRANT ALL ON TABLE achievement_reset_time TO postgres;
GRANT ALL ON TABLE achievement_reset_time TO postgres;
--
-- Name: advanced_ability; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE advanced_ability FROM PUBLIC;
REVOKE ALL ON TABLE advanced_ability FROM postgres;
GRANT ALL ON TABLE advanced_ability TO postgres;
GRANT ALL ON TABLE advanced_ability TO postgres;
--
-- Name: auction; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE auction FROM PUBLIC;
REVOKE ALL ON TABLE auction FROM postgres;
GRANT ALL ON TABLE auction TO postgres;
GRANT ALL ON TABLE auction TO postgres;
--
-- Name: bags; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE bags FROM PUBLIC;
REVOKE ALL ON TABLE bags FROM postgres;
GRANT ALL ON TABLE bags TO postgres;
GRANT ALL ON TABLE bags TO postgres;
--
-- Name: beginner_tutorial; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE beginner_tutori
[Err] ERRO: rela��o "transport" n�o existe
[Err] GRANT ALL ON TABLE statistics_monster TO postgres;
--
-- Name: statistics_player; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE statistics_player FROM PUBLIC;
REVOKE ALL ON TABLE statistics_player FROM postgres;
GRANT ALL ON TABLE statistics_player TO postgres;
GRANT ALL ON TABLE statistics_player TO postgres;
--
-- Name: statues_scenes; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE statues_scenes FROM PUBLIC;
REVOKE ALL ON TABLE statues_scenes FROM postgres;
GRANT ALL ON TABLE statues_scenes TO postgres;
GRANT ALL ON TABLE statues_scenes TO postgres;
--
-- Name: storage1; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE storage1 FROM PUBLIC;
REVOKE ALL ON TABLE storage1 FROM postgres;
GRANT ALL ON TABLE storage1 TO postgres;
GRANT ALL ON TABLE storage1 TO postgres;
--
-- Name: storage2; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE storage2 FROM PUBLIC;
REVOKE ALL ON TABLE storage2 FROM postgres;
GRANT ALL ON TABLE storage2 TO postgres;
GRANT ALL ON TABLE storage2 TO postgres;
--
-- Name: transport; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE transport FROM PUBLIC;
REVOKE ALL ON TABLE transport FROM postgres;
GRANT ALL ON TABLE transport TO postgres;
GRANT ALL ON TABLE transport TO postgres;
--
-- Name: victory_declaration; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE victory_declaration FROM PUBLIC;
REVOKE ALL ON TABLE victory_declaration FROM postgres;
GRANT ALL ON TABLE victory_declaration TO postgres;
GRANT ALL ON TABLE victory_declaration TO postgres;
--
-- Name: weaponexp; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE weaponexp FROM PUBLIC;
REVOKE ALL ON TABLE weaponexp FROM postgres;
GRANT ALL ON TABLE weaponexp TO postgres;
GRANT ALL ON TABLE weaponexp TO postgres;
--
-- Name: week_update; Type: ACL; Schema: public; Owner: postgres
--
REVOKE ALL ON TABLE week_update FROM PUBLIC;
REVOKE ALL ON TABLE week_update FROM postgres;
GRANT ALL ON TABLE week_update TO postgres;
GRANT ALL ON TABLE week_update TO postgres;
--
-- PostgreSQL database dump complete
--
[Msg] Finished - Unsuccessfully
--------------------------------------------------
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
1,2016/05/16 02:20:49,[EVENT] Connected to database[127.0.0.1].
2,2016/05/16 02:20:49,[EVENT] Get 2 world servers from DB.
3,2016/05/16 02:20:49,[EVENT] Load 0 records of AccountID from database.
4,2016/05/16 02:20:49,[EVENT] Load login_version: [1-6-7-VIP (Login)] from database done.
5,2016/05/16 02:20:51,RSA size(n) = 256 size(e) = 2
6,2016/05/16 02:20:51,RSA size(n) = 256 size(e) = 2
7,2016/05/16 02:20:51,Server is rolling on TCP 0.0.0.0:6543.
[B] [COLOR="#FF0000"] 8,2016/05/16 02:20:51,TCP connection: 127.0.0.1:18624 Conexão recusada 9,2016/05/16 02:20:51,SOCKET 9: closed.
10,2016/05/16 02:20:51,[SJFramework.cc:111],ERROR: #Network# CSJFramework::InitNetwork -- Network Initial Error[/B][/COLOR].
261,2016/05/16 02:21:03,[EVENT] ElfLottery: Update LotteryID:58, Category:1, DropLevel:6, Weekday:0, LevelOrder:6, ItemID:50014, MaxStack:1, DropRate:7,000000, Notify:1, GetOnly:1, ShiningHint:1, JackPot:0
5262,2016/05/16 02:21:03,[EVENT] ElfLottery: Update LotteryID:59, Category:1, DropLevel:7, Weekday:0, LevelOrder:2, ItemID:40289, MaxStack:6, DropRate:75,000000, Notify:0, GetOnly:1, ShiningHint:1, JackPot:0
5263,2016/05/16 02:21:03,[EVENT] ElfLottery: Update LotteryID:60, Category:1, DropLevel:7, Weekday:0, LevelOrder:5, ItemID:55590, MaxStack:1, DropRate:25,000000, Notify:1, GetOnly:1, ShiningHint:1, JackPot:0
5264,2016/05/16 02:21:03,[EVENT] LOAD text_index [886] : [Reg. Members] from database done.
5265,2016/05/16 02:21:03,[EVENT] LOAD text_index [887] : [Leader] from database done.
5266,2016/05/16 02:21:03,[EVENT] LOAD text_index [888] : [Vice-Leader] from database done.
5267,2016/05/16 02:21:03,[EVENT] LOAD text_index [889] : [Adept] from database done.
5268,2016/05/16 02:21:03,[EVENT] LOAD text_index [890] : [Disciple] from database done.
5269,2016/05/16 02:21:03,[EVENT] LOAD text_index [891] : [Trainee] from database done.
5270,2016/05/16 02:21:03,[EVENT] LOAD text_index [5047] : [New Member] from database done.
[B][COLOR="#FF0000"] 5271,2016/05/16 02:21:03,[EVENT] == [END of INITIAL DATA LOADING.....] ============================================================
5272,2016/05/16 02:21:03,ExecTuplesOk Failed:ERRO: coluna "world_start_time" não existe
LINE 1: SELECT world_start_time FROM configuration
^
5273,2016/05/16 02:21:03,SELECT configuration failed due to 'ERRO: coluna "world_start_time" não existe
LINE 1: SELECT world_start_time FROM configuration
^
'.[/COLOR][/B]
5274,2016/05/16 02:21:03,Service OK
5275,2016/05/16 02:21:03,Service OK
5276,2016/05/16 02:21:04,RSA size(n) = 256 size(e) = 2
5277,2016/05/16 02:21:04,RSA size(n) = 256 size(e) = 2
5278,2016/05/16 02:21:04,Server is rolling on TCP 192.168.1.4:5567.
5279,2016/05/16 02:21:04,Server is rolling on TCP 127.0.0.1:5567.
5280,2016/05/16 02:21:04,Connect to 127.0.0.1<0x622EE30:16>:18624.
5281,2016/05/16 02:21:04,Connect to 127.0.0.1<0x623D300:17>:5560.
5282,2016/05/16 02:21:04,[EVENT] WorldServer (with BillingGateway support) booting...
5283,2016/05/16 02:21:04,Connect to 127.0.0.1<0x623FF40:18>:5560.
5284,2016/05/16 02:21:04,[EVENT] WorldServer (with BillingGatewayPayment support) booting...
5285,2016/05/16 02:21:04,Connect to 127.0.0.1<0x6242890:19>:7654.
5286,2016/05/16 02:21:04,[EVENT] Apex Queue start
5287,2016/05/16 02:21:04,[EVENT] ApexProxy start
5288,2016/05/16 02:21:04,[EVENT] Apex: Start
2,2016/05/16 02:20:44,[EVENT] Use PgSQL.
3,2016/05/16 02:20:44,[EVENT] Connected to database[127.0.0.1].
4,2016/05/16 02:20:55,RSA size(n) = 256 size(e) = 2
5,2016/05/16 02:20:55,Server is rolling on TCP 0.0.0.0:5560.
6,2016/05/16 02:20:55,Add New Epoll 9
7,2016/05/16 02:20:56,EVAL(1.007220 secs): {Network I/O}
8,2016/05/16 02:20:56,EVAL(1.007283 secs): {Main Loop}
9,2016/05/16 02:20:57,EVAL(1.000637 secs): {Network I/O}
10,2016/05/16 02:20:57,EVAL(1.000698 secs): {Main Loop}
11,2016/05/16 02:20:58,EVAL(1.000870 secs): {Network I/O}
12,2016/05/16 02:20:58,EVAL(1.000933 secs): {Main Loop}
13,2016/05/16 02:20:59,EVAL(1.000922 secs): {Network I/O}
14,2016/05/16 02:20:59,EVAL(1.000993 secs): {Main Loop}
15,2016/05/16 02:21:00,EVAL(1.001036 secs): {Network I/O}
16,2016/05/16 02:21:00,EVAL(1.001102 secs): {Main Loop}
17,2016/05/16 02:21:01,EVAL(1.012397 secs): {Network I/O}
18,2016/05/16 02:21:01,EVAL(1.012455 secs): {Main Loop}
19,2016/05/16 02:21:02,EVAL(1.039486 secs): {Network I/O}
20,2016/05/16 02:21:02,EVAL(1.039546 secs): {Main Loop}
21,2016/05/16 02:21:03,EVAL(1.000682 secs): {Network I/O}
22,2016/05/16 02:21:03,EVAL(1.000746 secs): {Main Loop}
23,2016/05/16 02:21:04,SOCKET 10: accepted by 9
24,2016/05/16 02:21:04,TCP <0x9553DE0:10>: connected from (null) [127.0.0.1].
25,2016/05/16 02:21:04,Add New Epoll 10
26,2016/05/16 02:21:04,SOCKET 11: accepted by 9
27,2016/05/16 02:21:04,TCP <0x9556690:11>: connected from (null) [127.0.0.1].
28,2016/05/16 02:21:04,Add New Epoll 11
29,2016/05/16 02:21:04,[GatewayServerNetwork.cc:12],[FATAL] OnReady
30,2016/05/16 02:21:04,TCP <0x9553DE0:10>: connection from '127.0.0.1' encrypted.
31,2016/05/16 02:21:04,[NE_G_Connected.cc:14],CNE_G_Connected::Execut
32,2016/05/16 02:21:05,[GatewayServerNetwork.cc:12],[FATAL] OnReady
33,2016/05/16 02:21:05,TCP <0x9556690:11>: connection from '127.0.0.1' encrypted.
34,2016/05/16 02:21:05,[NE_G_Connected.cc:14],CNE_G_Connected::Execut
35,2016/05/16 02:21:05,[NE_G_ServerClientTypeReport.cc:12],CNE_G_ServerClientTypeReport::Execute
36,2016/05/16 02:21:05,[NE_G_ServerClientTypeReport.cc:28],World Server ID: [1010] Connected! Version: [003.005.01.04]
37,2016/05/16 02:21:05,[NE_G_ServerClientTypeReport.cc:12],CNE_G_ServerClientTypeReport::Execute
38,2016/05/16 02:21:05,[NE_G_ServerClientTypeReport.cc:28],World Server ID: [1010] Connected! Version: [003.005.01.04]
39,2016/05/16 02:21:06,EVAL(1.009034 secs): {Network I/O}
40,2016/05/16 02:21:06,EVAL(1.009097 secs): {Main Loop}
41,2016/05/16 02:21:07,EVAL(1.000296 secs): {Network I/O}
42,2016/05/16 02:21:07,EVAL(1.000335 secs): {Main Loop}
43,2016/05/16 02:21:08,EVAL(1.038097 secs): {Network I/O}
44,2016/05/16 02:21:08,EVAL(1.038161 secs): {Main Loop}
45,2016/05/16 02:21:09,EVAL(1.040004 secs): {Network I/O}
46,2016/05/16 02:21:09,EVAL(1.040065 secs): {Main Loop}
47,2016/05/16 02:21:10,EVAL(1.014543 secs): {Network I/O}
48,2016/05/16 02:21:10,EVAL(1.014611 secs): {Main Loop}
49,2016/05/16 02:21:11,EVAL(1.001641 secs): {Network I/O}
50,2016/05/16 02:21:11,EVAL(1.001698 secs): {Main Loop}
51,2016/05/16 02:21:12,EVAL(1.059590 secs): {Network I/O}
52,2016/05/16 02:21:12,EVAL(1.059653 secs): {Main Loop}
53,2016/05/16 02:21:12,SOCKET 12: accepted by 9
54,2016/05/16 02:21:12,TCP <0x9559BE0:12>: connected from (null) [127.0.0.1].
55,2016/05/16 02:21:12,Add New Epoll 12
56,2016/05/16 02:21:12,SOCKET 13: accepted by 9
57,2016/05/16 02:21:12,TCP <0x955C490:13>: connected from (null) [127.0.0.1].
58,2016/05/16 02:21:12,Add New Epoll 13
59,2016/05/16 02:21:13,[GatewayServerNetwork.cc:12],[FATAL] OnReady
60,2016/05/16 02:21:13,TCP <0x9559BE0:12>: connection from '127.0.0.1' encrypted.
61,2016/05/16 02:21:13,[NE_G_Connected.cc:14],CNE_G_Connected::Execut
62,2016/05/16 02:21:13,[GatewayServerNetwork.cc:12],[FATAL] OnReady
63,2016/05/16 02:21:13,TCP <0x955C490:13>: connection from '127.0.0.1' encrypted.
64,2016/05/16 02:21:13,[NE_G_Connected.cc:14],CNE_G_Connected::Execut
65,2016/05/16 02:21:13,[NE_G_ServerClientTypeReport.cc:12],CNE_G_ServerClientTypeReport::Execute
66,2016/05/16 02:21:13,[NE_G_ServerClientTypeReport.cc:28],World Server ID: [1020] Connected! Version: [003.005.01.04]
67,2016/05/16 02:21:13,[NE_G_ServerClientTypeReport.cc:12],CNE_G_ServerClientTypeReport::Execute
68,2016/05/16 02:21:13,[NE_G_ServerClientTypeReport.cc:28],World Server ID: [1020] Connected! Version: [003.005.01.04]
69,2016/05/16 02:21:14,EVAL(1.001278 secs): {Network I/O}
70,2016/05/16 02:21:14,EVAL(1.001343 secs): {Main Loop}
71,2016/05/16 02:21:15,EVAL(1.001396 secs): {Network I/O}
72,2016/05/16 02:21:15,EVAL(1.001448 secs): {Main Loop}
73,2016/05/16 02:21:16,EVAL(1.082747 secs): {Network I/O}
74,2016/05/16 02:21:16,EVAL(1.082812 secs): {Main Loop}
75,2016/05/16 02:21:17,EVAL(1.010796 secs): {Network I/O}
76,2016/05/16 02:21:17,EVAL(1.010859 secs): {Main Loop}
77,2016/05/16 02:21:18,EVAL(1.000838 secs): {Network I/O}