[CentOS] Setting up your Aura Kingdom Server

**Mahdi Abdullah** · 08-05-16

Finally, after 2x24 hours of study! Well, the tut is not complete but the thread is! Thank you people!

**AaronzitoBr** · 15-05-16

Sorry to ask, but can anyone upload the client on another host? Cause Mega now only accepts 5gb for non premium users

**Eperty123** · 15-05-16

Originally Posted by AaronzitoBr

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.

**AaronzitoBr** · 15-05-16

Originally Posted by Eperty123

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.

Mega now limits downloads of 1GB+, so just premium users can download files bigger than 1GB ^^ The client has 5GB, after the first 1GB Mega stopped my download and said to wait "6 hours" to continue, or buy premium. I'll try to use a VPN.

**Valmor Silva** · 15-05-16

its not limited to download

**AaronzitoBr** · 15-05-16

Originally Posted by Valmor Silva

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. ^- ^ just kidding, I changed the ip to USA and now it works, but the "tools" on mega is gone. T.T anyone has it?

**Valmor Silva** · 15-05-16

Originally Posted by AaronzitoBr

Well, thats not what the site said '-' Maybe is because I live in Brazil and Mega hate us too, like everyone. ^-^

see

**AaronzitoBr** · 16-05-16

Originally Posted by Eperty123

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.

guy, I'm trying to import the db on navicat, but it shows me erros:

Code:

[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
--------------------------------------------------

afther change EPedrty123 to my db user "Posgres":

Code:

[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
--------------------------------------------------

**MagiKitty** · 16-05-16

Sup, I had to register for this one.
The Tut is fine, until certain points...

Basically I was able to set up CentOS and Virtual Box. But I wasn't able to Port-Forward and still am not. I just sort of figured a way around it but it's not helping at the moment, meaning I am stuck.
Additionally, when I try to start the service (or did the restart step for the SQL) it will just say FAILED and

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"?

So, I have no idea how to Port-Forward on this new VirtualBox UI (looks easy, yet is very confusing to me for some reason). I think fixing this issue might help me proceed with postgres.
Because the Tutorial just says "set up to your likings".

Thanks for your help in advance!

**AaronzitoBr** · 16-05-16

Everytime I try to import the dbs with "\i '/<name>.sql'; some dbs get errors. Like, lottery or something like that. World_Start_Time and a lot more on FFMember.sql and FFAccount. I created an db named "Fantasy" and put all three there, I tried them separate,but it don't even work to connect LoginServer, Gateway and WorldServer.

I'm getting theses errors now:

Code:

     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.
     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.

WorldServer101.log

Code:

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.
  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
               ^
'.
  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

gateway

Code:

     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}

the game client shows "Logging in, please wait" or something like that. It nevers connect, neither show me some error message. Any tips?

**Valmor Silva** · 17-05-16

i can help u a little

**AaronzitoBr** · 17-05-16

I changed the sql files, now I can log in, but I can't create a new character =/ when i select my eidolon it says:

"Can't create character profile"

- UPDATE -

I Found something on WorldServer log:

Code:

  6027,2016/05/17 00:30:57,EVAL(1,022735 secs): {Main Loop}
  6028,2016/05/17 00:30:57,[EVENT] CNE_CW_ServerCreateCharacterName::Execute ---- Name:
  6029,2016/05/17 00:30:57,[EVENT] Mago
  6030,2016/05/17 00:30:57,[EVENT] LP_NEW (CNC_CW_ClientVerifyCharacterName(success))
  6031,2016/05/17 00:30:59,[EVENT] CNE_CW_ServerCreateCharacterName::Execute ---- Name:
  6032,2016/05/17 00:30:59,[EVENT] Mago
  6033,2016/05/17 00:30:59,[EVENT] LP_NEW (CNC_CW_ClientVerifyCharacterName(success))
  6034,2016/05/17 00:30:59,[EVENT] CNE_CW_ServerCreateCharacterName::Execute ---- Name:
  6035,2016/05/17 00:30:59,[EVENT] Mago
  6036,2016/05/17 00:30:59,[EVENT] LP_NEW (CNC_CW_ClientVerifyCharacterName(success))
  6037,2016/05/17 00:31:00,EVAL(1,001630 secs): {Network I/O}
  6038,2016/05/17 00:31:00,EVAL(1,001695 secs): {Main Loop}
  6039,2016/05/17 00:31:00,[EVENT] Character name after modification is: 'Mago'
  6040,2016/05/17 00:31:00,[EVENT][AID:2048] Create character['Mago'] with values: weapontype=8, gender=1, face=0, skin_color=0, eyes_color=0, hair=0, hair_color=0 loc=0
  6041,2016/05/17 00:31:00,[EVENT] INSERT INTO player_characters(id, given_name, node_id, x, y, z, face_dir, class_id, gender_id, hair, face, hair_color, skin_color, eyes_color, level, hp, max_hp, mp, max_mp, account_id, account_name, privilege, revive_area_id ,survival_ghost ,is_itemmall_character) values(50000003, 'Mago', 610, 377,000000, 283,000000, 0.0, 0,000000, 0, 1, 0, 0, 0, 0, 0, 1, 1351, 351, 0, 0, 2048, 'hycker', 0, 39976962, -1, 0);
  6042,2016/05/17 00:31:00,[EVENT] CreateCharacterIntoDB Failed:ERRO:  INSERT tem mais expressões do que colunas alvo
LINE 1: ..., 0, 0, 0, 1, 1351, 351, 0, 0, 2048, 'hycker', 0, 39976962, ...
                                                             ^

  6043,2016/05/17 00:31:00,[EVENT] LP_NEW (CNC_CW_ClientVerifyCharacterName(create character data' error))
  6044,2016/05/17 00:31:02,EVAL(1,008466 secs): {Network I/O}
  6045,2016/05/17 00:31:02,EVAL(1,008519 secs): {Main Loop}

It says that the INSERT expression has more collums than his target. I'm using another SQL, that has hycker account and character (wich I can login, but still can't create new char).

But, even with the original Eperty sqls I can't create a character.

**MagiKitty** · 17-05-16

I have to add something. The Tutorial really does expect me to know every inch of the softwares itself, aswell as doesn't explain to me how to use what the way I need it.

Somehow I figured my way around having the connection via SSH and to the Database. All fine.
The next step would be to Start the server. Where do I type that in? via Putty or via the VM? neither works, and if I am in the server files directory to start it, I just get this output:

[root@localhost aura]# ./start
LoginServer: no process killed
GatewayServer: no process killed
TicketServer: no process killed
MissionServer: no process killed
WorldServer: no process killed
ZoneServer: no process killed
./start: line 26: cd: /root/hxsy/TicketServer/: No such file or directory
./start: line 28: ./TicketServer: is a directory
./start: line 30: cd: /root/hxsy/GatewayServer/: No such file or directory
./start: line 32: ./GatewayServer: is a directory
./start: line 34: cd: /root/hxsy/LoginServer/: No such file or directory
./start: line 36: ./LoginServer: is a directory
./start: line 38: cd: /root/hxsy/MissionServer/: No such file or directory
./start: line 40: ./MissionServer: is a directory
./start: line 42: cd: /root/hxsy/WorldServer101/: No such file or directory
./start: line 44: ./WorldServer: No such file or directory
./start: line 46: cd: /root/hxsy/WorldServer102/: No such file or directory
./start: line 48: ./WorldServer: No such file or directory
./start: line 50: cd: /root/hxsy/ZoneServer101/: No such file or directory
./start: line 52: ./ZoneServer: No such file or directory
./start: line 54: cd: /root/hxsy/ZoneServer102/: No such file or directory
./start: line 56: ./ZoneServer: No such file or directory

I don't wanna blame you, but writing a tutorial, pls think that the readers are stupid. It's easier to skip steps yourself than to have steps skipped for you that you actually need.

**ferasn** · 17-05-16

check you server files path, it should be as same as the path given in the error message, or you can edit if you want to

**MagiKitty** · 17-05-16

Originally Posted by ferasn

check you server files path, it should be as same as the path given in the error message, or you can edit if you want to

That's not the error. It doesn't matter if I change the path to /root/aura/<Serverfiles>.
It just doesn't work. I don't know why.

[CentOS] Setting up your Aura Kingdom Server

Thread Tools

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Re: [CentOS] Setting up your Aura Kingdom Server

Advertisement