rpfw-samp/samp03/gamemodes/sql/rpfw.0.0a-build10.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 12.1
-- Dumped by pg_dump version 12.1

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: character; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public."character" (
    id integer NOT NULL,
    user_id integer NOT NULL,
    name character varying(24) NOT NULL,
    skin_id smallint DEFAULT 134 NOT NULL,
    cash integer DEFAULT 0,
    health real DEFAULT 100,
    armour real DEFAULT 100,
    jailed smallint DEFAULT 0,
    pos_x real DEFAULT '-144.0328'::numeric,
    pos_y real DEFAULT 1225.0564,
    pos_z real DEFAULT 19.8992,
    rotation real DEFAULT 175.5507,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone,
    job_id smallint DEFAULT 0 NOT NULL,
    world_id smallint DEFAULT 0 NOT NULL,
    interior_id smallint DEFAULT 0 NOT NULL,
    job_skin_id smallint,
    weapon_slot_0 smallint,
    weapon_slot_1 smallint,
    weapon_slot_2 smallint,
    weapon_slot_3 smallint,
    weapon_slot_4 smallint,
    weapon_slot_5 smallint,
    weapon_slot_6 smallint,
    weapon_slot_7 smallint,
    weapon_slot_8 smallint,
    weapon_slot_9 smallint,
    weapon_slot_10 smallint,
    weapon_slot_11 smallint,
    weapon_slot_12 smallint,
    weapon_skill_0 smallint DEFAULT 0 NOT NULL,
    weapon_skill_1 smallint DEFAULT 0 NOT NULL,
    weapon_skill_2 smallint DEFAULT 0 NOT NULL,
    weapon_skill_3 smallint DEFAULT 0 NOT NULL,
    weapon_skill_4 smallint DEFAULT 0 NOT NULL,
    weapon_skill_5 smallint DEFAULT 0 NOT NULL,
    weapon_skill_6 smallint DEFAULT 0 NOT NULL,
    weapon_skill_7 smallint DEFAULT 0 NOT NULL,
    weapon_skill_8 smallint DEFAULT 0 NOT NULL,
    weapon_skill_9 smallint DEFAULT 0 NOT NULL,
    weapon_skill_10 smallint DEFAULT 0 NOT NULL
);
ALTER TABLE ONLY public."character" ALTER COLUMN job_id SET (n_distinct=0);


ALTER TABLE public."character" OWNER TO "rpfw-dev";

--
-- Name: TABLE "character"; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON TABLE public."character" IS 'A character of a user. A user can have multiple characters, limited in the game-mode by the charaterArray size, which is set to the definition MAX_CHARACTERS_PER_USER in the game-mode limits section.';


--
-- Name: COLUMN "character".jailed; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public."character".jailed IS 'Amount of minutes jailed.
TODO Move to own table for criminal database';


--
-- Name: character_character_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.character_character_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.character_character_id_seq OWNER TO "rpfw-dev";

--
-- Name: character_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.character_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.character_id_seq OWNER TO "rpfw-dev";

--
-- Name: character_id_seq1; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.character_id_seq1
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.character_id_seq1 OWNER TO "rpfw-dev";

--
-- Name: character_id_seq1; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.character_id_seq1 OWNED BY public."character".id;


--
-- Name: ip; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.ip (
    id integer NOT NULL,
    address character varying(45) NOT NULL,
    connections integer DEFAULT 1
);


ALTER TABLE public.ip OWNER TO "rpfw-dev";

--
-- Name: COLUMN ip.address; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.ip.address IS 'Even though sa-mp only seems to support IPv4.
It''s not likely to be updated, but if so, the database is ready for the "future".';


--
-- Name: ip_ban; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.ip_ban (
    id integer NOT NULL,
    ip_id integer NOT NULL,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone,
    expires timestamp without time zone DEFAULT ((now())::timestamp without time zone + '30 days'::interval),
    reason character varying(121) NOT NULL,
    banner_id integer
);


ALTER TABLE public.ip_ban OWNER TO "rpfw-dev";

--
-- Name: TABLE ip_ban; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON TABLE public.ip_ban IS 'Ban records per IP.
Historic bans are kept for administrative purposes & active bans are checked against timestamp.';


--
-- Name: COLUMN ip_ban.reason; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.ip_ban.reason IS 'Maximum sa-mp message length = 128.
The shortest possible ban command is "/ban 0 ". (7 characters)
128 - 7 = 121 as maximum ban reason.';


--
-- Name: ip_bans_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.ip_bans_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ip_bans_id_seq OWNER TO "rpfw-dev";

--
-- Name: ip_bans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.ip_bans_id_seq OWNED BY public.ip_ban.id;


--
-- Name: ip_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.ip_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ip_id_seq OWNER TO "rpfw-dev";

--
-- Name: ip_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.ip_id_seq OWNED BY public.ip.id;


--
-- Name: ip_ip_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.ip_ip_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ip_ip_id_seq OWNER TO "rpfw-dev";

--
-- Name: ip_kick; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.ip_kick (
    id integer NOT NULL,
    ip_id integer NOT NULL,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone NOT NULL,
    reason character varying(121) NOT NULL,
    kicker_id integer
);


ALTER TABLE public.ip_kick OWNER TO "rpfw-dev";

--
-- Name: ip_kick_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.ip_kick_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ip_kick_id_seq OWNER TO "rpfw-dev";

--
-- Name: ip_kick_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.ip_kick_id_seq OWNED BY public.ip_kick.id;


--
-- Name: pickup; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.pickup (
    id integer NOT NULL,
    object_id smallint NOT NULL,
    pos_x real NOT NULL,
    pos_y real NOT NULL,
    pos_z real NOT NULL,
    world_id smallint NOT NULL,
    interior_id smallint NOT NULL,
    type_id smallint NOT NULL,
    pickup_id smallint,
    angle real DEFAULT 0 NOT NULL
);


ALTER TABLE public.pickup OWNER TO "rpfw-dev";

--
-- Name: pickup_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.pickup_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pickup_id_seq OWNER TO "rpfw-dev";

--
-- Name: pickup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.pickup_id_seq OWNED BY public.pickup.id;


--
-- Name: portal; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.portal (
    id integer NOT NULL,
    object smallint NOT NULL,
    pos_x real NOT NULL,
    pos_y real NOT NULL,
    pos_z real NOT NULL,
    world smallint NOT NULL,
    exit_object smallint,
    exit_pos_x real,
    exit_pos_y real,
    exit_pos_z real,
    exit_world smallint,
    pickup_id smallint,
    exit_pickup_id smallint,
    interior_id smallint DEFAULT 0 NOT NULL,
    exit_interior_id smallint,
    angle real DEFAULT 0 NOT NULL,
    exit_angle real
);


ALTER TABLE public.portal OWNER TO "rpfw-dev";

--
-- Name: portal_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.portal_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.portal_id_seq OWNER TO "rpfw-dev";

--
-- Name: portal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.portal_id_seq OWNED BY public.portal.id;


--
-- Name: user; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public."user" (
    id integer NOT NULL,
    name character varying(24) NOT NULL,
    level smallint DEFAULT 1,
    password character varying(128) NOT NULL,
    webaccount_id integer,
    jailed smallint DEFAULT 0,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone
);


ALTER TABLE public."user" OWNER TO "rpfw-dev";

--
-- Name: TABLE "user"; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON TABLE public."user" IS 'SA-MP player user records';


--
-- Name: user_ban; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.user_ban (
    id integer NOT NULL,
    user_id integer NOT NULL,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone,
    expires timestamp without time zone DEFAULT ((now())::timestamp without time zone + '30 days'::interval),
    reason character varying(121) NOT NULL,
    banner integer,
    ip_ban_id integer
);


ALTER TABLE public.user_ban OWNER TO "rpfw-dev";

--
-- Name: COLUMN user_ban.banner; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.user_ban.banner IS 'NOT NULL as users can be banned by automation as well as ingame players.';


--
-- Name: COLUMN user_ban.ip_ban_id; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.user_ban.ip_ban_id IS 'Optional, as an IP ban might get removed for another user and we want the offending user to remain banned.';


--
-- Name: user_bans_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.user_bans_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_bans_id_seq OWNER TO "rpfw-dev";

--
-- Name: user_bans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.user_bans_id_seq OWNED BY public.user_ban.id;


--
-- Name: user_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_id_seq OWNER TO "rpfw-dev";

--
-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.user_id_seq OWNED BY public."user".id;


--
-- Name: user_ip; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.user_ip (
    ip_id integer NOT NULL,
    user_id integer NOT NULL,
    updated timestamp without time zone DEFAULT (now())::timestamp without time zone NOT NULL,
    created timestamp without time zone NOT NULL
);


ALTER TABLE public.user_ip OWNER TO "rpfw-dev";

--
-- Name: COLUMN user_ip.updated; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.user_ip.updated IS 'For administration purposes it might be usefull to see when a user last used an IP.';


--
-- Name: COLUMN user_ip.created; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON COLUMN public.user_ip.created IS 'For administration purposes it might be usefull to see when a user started using an IP.';


--
-- Name: user_kick; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.user_kick (
    id integer NOT NULL,
    user_id integer NOT NULL,
    created timestamp without time zone DEFAULT (now())::timestamp without time zone,
    reason character varying(121) NOT NULL,
    kicker_id integer,
    ip_kick_id integer NOT NULL
);


ALTER TABLE public.user_kick OWNER TO "rpfw-dev";

--
-- Name: user_kicks_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.user_kicks_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_kicks_id_seq OWNER TO "rpfw-dev";

--
-- Name: user_kicks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.user_kicks_id_seq OWNED BY public.user_kick.id;


--
-- Name: user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.user_user_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_user_id_seq OWNER TO "rpfw-dev";

--
-- Name: vehicle; Type: TABLE; Schema: public; Owner: rpfw-dev
--

CREATE TABLE public.vehicle (
    id integer NOT NULL,
    model_id smallint NOT NULL,
    pos_x real NOT NULL,
    pos_y real NOT NULL,
    pos_z real NOT NULL,
    angle real NOT NULL,
    color1 smallint DEFAULT '-1'::integer NOT NULL,
    color2 smallint DEFAULT '-1'::integer NOT NULL,
    respawn_delay smallint DEFAULT '-1'::integer NOT NULL,
    addsiren smallint DEFAULT '-1'::integer NOT NULL,
    vehicle_id smallint
);


ALTER TABLE public.vehicle OWNER TO "rpfw-dev";

--
-- Name: vehicle_id_seq; Type: SEQUENCE; Schema: public; Owner: rpfw-dev
--

CREATE SEQUENCE public.vehicle_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.vehicle_id_seq OWNER TO "rpfw-dev";

--
-- Name: vehicle_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: rpfw-dev
--

ALTER SEQUENCE public.vehicle_id_seq OWNED BY public.vehicle.id;


--
-- Name: character id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."character" ALTER COLUMN id SET DEFAULT nextval('public.character_id_seq1'::regclass);


--
-- Name: ip id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip ALTER COLUMN id SET DEFAULT nextval('public.ip_id_seq'::regclass);


--
-- Name: ip_ban id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_ban ALTER COLUMN id SET DEFAULT nextval('public.ip_bans_id_seq'::regclass);


--
-- Name: ip_kick id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_kick ALTER COLUMN id SET DEFAULT nextval('public.ip_kick_id_seq'::regclass);


--
-- Name: pickup id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.pickup ALTER COLUMN id SET DEFAULT nextval('public.pickup_id_seq'::regclass);


--
-- Name: portal id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.portal ALTER COLUMN id SET DEFAULT nextval('public.portal_id_seq'::regclass);


--
-- Name: user id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."user" ALTER COLUMN id SET DEFAULT nextval('public.user_id_seq'::regclass);


--
-- Name: user_ban id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ban ALTER COLUMN id SET DEFAULT nextval('public.user_bans_id_seq'::regclass);


--
-- Name: user_kick id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_kick ALTER COLUMN id SET DEFAULT nextval('public.user_kicks_id_seq'::regclass);


--
-- Name: vehicle id; Type: DEFAULT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.vehicle ALTER COLUMN id SET DEFAULT nextval('public.vehicle_id_seq'::regclass);


--
-- Data for Name: character; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public."character" (id, user_id, name, skin_id, cash, health, armour, jailed, pos_x, pos_y, pos_z, rotation, created, job_id, world_id, interior_id, job_skin_id, weapon_slot_0, weapon_slot_1, weapon_slot_2, weapon_slot_3, weapon_slot_4, weapon_slot_5, weapon_slot_6, weapon_slot_7, weapon_slot_8, weapon_slot_9, weapon_slot_10, weapon_slot_11, weapon_slot_12, weapon_skill_0, weapon_skill_1, weapon_skill_2, weapon_skill_3, weapon_skill_4, weapon_skill_5, weapon_skill_6, weapon_skill_7, weapon_skill_8, weapon_skill_9, weapon_skill_10) FROM stdin;
37	13	Jo_Bo	134	47	100	0	0	-199.62967	992.9551	19.032475	33.898186	2020-02-26 17:46:13.40483	0	0	0	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	0	0	0	0	0	0	0	0	0	0
\.


--
-- Data for Name: ip; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.ip (id, address, connections) FROM stdin;
49	127.0.0.1	235
\.


--
-- Data for Name: ip_ban; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.ip_ban (id, ip_id, created, expires, reason, banner_id) FROM stdin;
\.


--
-- Data for Name: ip_kick; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.ip_kick (id, ip_id, created, reason, kicker_id) FROM stdin;
\.


--
-- Data for Name: pickup; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.pickup (id, object_id, pos_x, pos_y, pos_z, world_id, interior_id, type_id, pickup_id, angle) FROM stdin;
31	1247	-203.16534	1012.1661	19.73446	0	0	1	3	0
30	1247	-202	1005	19.723639	0	0	0	4	0
\.


--
-- Data for Name: portal; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.portal (id, object, pos_x, pos_y, pos_z, world, exit_object, exit_pos_x, exit_pos_y, exit_pos_z, exit_world, pickup_id, exit_pickup_id, interior_id, exit_interior_id, angle, exit_angle) FROM stdin;
43	19902	-197.22972	1006.7419	19.580938	-1	19607	-193.11603	1001.5561	19.775234	-1	1	2	0	0	359	1.1358372e+09
\.


--
-- Data for Name: user; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public."user" (id, name, level, password, webaccount_id, jailed, created) FROM stdin;
13	Player	1	DF3210C97BB5895B32A09C3CD9A905248FD2F34720711152C92EE6D1828E3122B0844C565536C5214B5F2C137FF638BD86F03EBC412DDDDD4018F968819BEEC0	\N	0	2020-02-26 17:46:13.395829
\.


--
-- Data for Name: user_ban; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.user_ban (id, user_id, created, expires, reason, banner, ip_ban_id) FROM stdin;
\.


--
-- Data for Name: user_ip; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.user_ip (ip_id, user_id, updated, created) FROM stdin;
\.


--
-- Data for Name: user_kick; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.user_kick (id, user_id, created, reason, kicker_id, ip_kick_id) FROM stdin;
\.


--
-- Data for Name: vehicle; Type: TABLE DATA; Schema: public; Owner: rpfw-dev
--

COPY public.vehicle (id, model_id, pos_x, pos_y, pos_z, angle, color1, color2, respawn_delay, addsiren, vehicle_id) FROM stdin;
4	411	-205.92249	950.4727	15.779951	92.88477	-1	-1	-1	-1	1
5	411	-190.78378	977.7164	18.630545	62.595642	-1	-1	-1	-1	2
\.


--
-- Name: character_character_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.character_character_id_seq', 1, false);


--
-- Name: character_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.character_id_seq', 1, false);


--
-- Name: character_id_seq1; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.character_id_seq1', 39, true);


--
-- Name: ip_bans_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.ip_bans_id_seq', 8, true);


--
-- Name: ip_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.ip_id_seq', 283, true);


--
-- Name: ip_ip_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.ip_ip_id_seq', 133, true);


--
-- Name: ip_kick_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.ip_kick_id_seq', 19, true);


--
-- Name: pickup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.pickup_id_seq', 31, true);


--
-- Name: portal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.portal_id_seq', 43, true);


--
-- Name: user_bans_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.user_bans_id_seq', 5, true);


--
-- Name: user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.user_id_seq', 13, true);


--
-- Name: user_kicks_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.user_kicks_id_seq', 10, true);


--
-- Name: user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.user_user_id_seq', 19, true);


--
-- Name: vehicle_id_seq; Type: SEQUENCE SET; Schema: public; Owner: rpfw-dev
--

SELECT pg_catalog.setval('public.vehicle_id_seq', 5, true);


--
-- Name: character character_name_key; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."character"
    ADD CONSTRAINT character_name_key UNIQUE (name);


--
-- Name: character character_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."character"
    ADD CONSTRAINT character_pkey PRIMARY KEY (id);


--
-- Name: ip ip_address_key; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip
    ADD CONSTRAINT ip_address_key UNIQUE (address);


--
-- Name: ip_ban ip_bans_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_ban
    ADD CONSTRAINT ip_bans_pkey PRIMARY KEY (id);


--
-- Name: ip_kick ip_kick_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_kick
    ADD CONSTRAINT ip_kick_pkey PRIMARY KEY (id);


--
-- Name: ip ip_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip
    ADD CONSTRAINT ip_pkey PRIMARY KEY (id);


--
-- Name: pickup pickup_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.pickup
    ADD CONSTRAINT pickup_pkey PRIMARY KEY (id);


--
-- Name: portal portal_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.portal
    ADD CONSTRAINT portal_pkey PRIMARY KEY (id);


--
-- Name: portal unique_location; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.portal
    ADD CONSTRAINT unique_location UNIQUE (pos_x, pos_y, pos_z, world);


--
-- Name: user_ban user_bans_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ban
    ADD CONSTRAINT user_bans_pkey PRIMARY KEY (id);


--
-- Name: user_ip user_ip_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ip
    ADD CONSTRAINT user_ip_pkey PRIMARY KEY (ip_id, user_id);


--
-- Name: user_kick user_kicks_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_kick
    ADD CONSTRAINT user_kicks_pkey PRIMARY KEY (id);


--
-- Name: user user_name_key; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_name_key UNIQUE (name);


--
-- Name: user user_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."user"
    ADD CONSTRAINT user_pkey PRIMARY KEY (id);


--
-- Name: vehicle vehicle_pkey; Type: CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.vehicle
    ADD CONSTRAINT vehicle_pkey PRIMARY KEY (id);


--
-- Name: character character_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public."character"
    ADD CONSTRAINT character_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_ban ip_ban_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ban
    ADD CONSTRAINT ip_ban_id_fkey FOREIGN KEY (ip_ban_id) REFERENCES public.ip_ban(id) ON UPDATE CASCADE NOT VALID;


--
-- Name: CONSTRAINT ip_ban_id_fkey ON user_ban; Type: COMMENT; Schema: public; Owner: rpfw-dev
--

COMMENT ON CONSTRAINT ip_ban_id_fkey ON public.user_ban IS 'IP ban can be removed while character ban remains';


--
-- Name: ip_ban ip_bans_banner_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_ban
    ADD CONSTRAINT ip_bans_banner_fkey FOREIGN KEY (banner_id) REFERENCES public."user"(id) ON UPDATE CASCADE;


--
-- Name: ip_ban ip_bans_ip_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_ban
    ADD CONSTRAINT ip_bans_ip_id_fkey FOREIGN KEY (ip_id) REFERENCES public.ip(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ip_kick ip_kick_ip_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_kick
    ADD CONSTRAINT ip_kick_ip_id_fkey FOREIGN KEY (ip_id) REFERENCES public.ip(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ip_kick ip_kick_kicker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.ip_kick
    ADD CONSTRAINT ip_kick_kicker_id_fkey FOREIGN KEY (kicker_id) REFERENCES public."user"(id) ON UPDATE CASCADE;


--
-- Name: user_ban user_bans_banner_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ban
    ADD CONSTRAINT user_bans_banner_fkey FOREIGN KEY (banner) REFERENCES public."user"(id) ON UPDATE CASCADE;


--
-- Name: user_ban user_bans_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ban
    ADD CONSTRAINT user_bans_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_ip user_ip_ip_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ip
    ADD CONSTRAINT user_ip_ip_id_fkey FOREIGN KEY (ip_id) REFERENCES public.ip(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_ip user_ip_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_ip
    ADD CONSTRAINT user_ip_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: user_kick user_kick_ip_kick_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_kick
    ADD CONSTRAINT user_kick_ip_kick_id_fkey FOREIGN KEY (ip_kick_id) REFERENCES public.ip_kick(id) NOT VALID;


--
-- Name: user_kick user_kick_kicker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_kick
    ADD CONSTRAINT user_kick_kicker_id_fkey FOREIGN KEY (kicker_id) REFERENCES public."user"(id) ON UPDATE CASCADE;


--
-- Name: user_kick user_kick_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: rpfw-dev
--

ALTER TABLE ONLY public.user_kick
    ADD CONSTRAINT user_kick_user_id_fkey FOREIGN KEY (user_id) REFERENCES public."user"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--