vagato.dump

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: accommodation_equipments; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE accommodation_equipments (
    id integer NOT NULL,
    accommodation_id integer,
    equipment_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.accommodation_equipments OWNER TO m3dw3;

--
-- Name: accommodation_equipments_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE accommodation_equipments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accommodation_equipments_id_seq OWNER TO m3dw3;

--
-- Name: accommodation_equipments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE accommodation_equipments_id_seq OWNED BY accommodation_equipments.id;


--
-- Name: accommodations; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE accommodations (
    id integer NOT NULL,
    name character varying,
    code character varying,
    description text,
    owner_id integer,
    categry_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    image_file_name character varying,
    image_content_type character varying,
    image_file_size integer,
    image_updated_at timestamp without time zone
);


ALTER TABLE public.accommodations OWNER TO m3dw3;

--
-- Name: accommodations_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE accommodations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.accommodations_id_seq OWNER TO m3dw3;

--
-- Name: accommodations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE accommodations_id_seq OWNED BY accommodations.id;


--
-- Name: accommodations_serviices; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE accommodations_serviices (
    accommodation_id integer,
    serviice_id integer
);


ALTER TABLE public.accommodations_serviices OWNER TO m3dw3;

--
-- Name: addresses; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE addresses (
    id integer NOT NULL,
    country character varying,
    zip character varying,
    city character varying,
    address character varying,
    latitude double precision,
    longitude double precision,
    addressable_id integer,
    addressable_type character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.addresses OWNER TO m3dw3;

--
-- Name: addresses_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE addresses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.addresses_id_seq OWNER TO m3dw3;

--
-- Name: addresses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE addresses_id_seq OWNED BY addresses.id;


--
-- Name: admins; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE admins (
    id integer NOT NULL,
    name character varying,
    phone character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.admins OWNER TO m3dw3;

--
-- Name: admins_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE admins_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admins_id_seq OWNER TO m3dw3;

--
-- Name: admins_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE admins_id_seq OWNED BY admins.id;


--
-- Name: bookings; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE bookings (
    id integer NOT NULL,
    start_date date,
    end_date date,
    num_of_nights integer,
    state character varying,
    guest_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.bookings OWNER TO m3dw3;

--
-- Name: bookings_guests; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE bookings_guests (
    id integer NOT NULL,
    guest_id integer,
    booking_id integer,
    room_id integer,
    role character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    bed integer,
    room_index integer
);


ALTER TABLE public.bookings_guests OWNER TO m3dw3;

--
-- Name: bookings_guests_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE bookings_guests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.bookings_guests_id_seq OWNER TO m3dw3;

--
-- Name: bookings_guests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE bookings_guests_id_seq OWNED BY bookings_guests.id;


--
-- Name: bookings_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE bookings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.bookings_id_seq OWNER TO m3dw3;

--
-- Name: bookings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE bookings_id_seq OWNED BY bookings.id;


--
-- Name: bookings_rooms; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE bookings_rooms (
    id integer NOT NULL,
    booking_id integer,
    room_id integer,
    status character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    index integer
);


ALTER TABLE public.bookings_rooms OWNER TO m3dw3;

--
-- Name: bookings_rooms_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE bookings_rooms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.bookings_rooms_id_seq OWNER TO m3dw3;

--
-- Name: bookings_rooms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE bookings_rooms_id_seq OWNED BY bookings_rooms.id;


--
-- Name: categries; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE categries (
    id integer NOT NULL,
    name character varying,
    code character varying,
    value integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.categries OWNER TO m3dw3;

--
-- Name: categries_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE categries_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.categries_id_seq OWNER TO m3dw3;

--
-- Name: categries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE categries_id_seq OWNED BY categries.id;


--
-- Name: comments; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE comments (
    id integer NOT NULL,
    stars integer,
    text text,
    guest_id integer,
    accommodation_id integer,
    booking_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.comments OWNER TO m3dw3;

--
-- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE comments_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.comments_id_seq OWNER TO m3dw3;

--
-- Name: comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE comments_id_seq OWNED BY comments.id;


--
-- Name: equipment; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE equipment (
    id integer NOT NULL,
    name character varying,
    code character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.equipment OWNER TO m3dw3;

--
-- Name: equipment_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE equipment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.equipment_id_seq OWNER TO m3dw3;

--
-- Name: equipment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE equipment_id_seq OWNED BY equipment.id;


--
-- Name: equipment_rooms; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE equipment_rooms (
    id integer NOT NULL,
    room_id integer,
    equipment_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.equipment_rooms OWNER TO m3dw3;

--
-- Name: equipment_rooms_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE equipment_rooms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.equipment_rooms_id_seq OWNER TO m3dw3;

--
-- Name: equipment_rooms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE equipment_rooms_id_seq OWNED BY equipment_rooms.id;


--
-- Name: guests; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE guests (
    id integer NOT NULL,
    name character varying,
    phone character varying,
    day_of_birth date,
    guest_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.guests OWNER TO m3dw3;

--
-- Name: guests_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE guests_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.guests_id_seq OWNER TO m3dw3;

--
-- Name: guests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE guests_id_seq OWNED BY guests.id;


--
-- Name: owners; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE owners (
    id integer NOT NULL,
    name character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


ALTER TABLE public.owners OWNER TO m3dw3;

--
-- Name: owners_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE owners_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.owners_id_seq OWNER TO m3dw3;

--
-- Name: owners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE owners_id_seq OWNED BY owners.id;


--
-- Name: prices; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE prices (
    id integer NOT NULL,
    value double precision,
    currency character varying,
    ifa double precision,
    vat double precision,
    room_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.prices OWNER TO m3dw3;

--
-- Name: prices_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE prices_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.prices_id_seq OWNER TO m3dw3;

--
-- Name: prices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE prices_id_seq OWNED BY prices.id;


--
-- Name: properties; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE properties (
    id integer NOT NULL,
    key character varying,
    value text,
    "group" character varying,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL,
    title character varying
);


ALTER TABLE public.properties OWNER TO m3dw3;

--
-- Name: properties_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE properties_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.properties_id_seq OWNER TO m3dw3;

--
-- Name: properties_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE properties_id_seq OWNED BY properties.id;


--
-- Name: rooms; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE rooms (
    id integer NOT NULL,
    name character varying,
    code character varying,
    accommodation_id integer,
    num_of_this integer,
    capacity integer,
    description text,
    created_at timestamp without time zone,
    updated_at timestamp without time zone,
    image_file_name character varying,
    image_content_type character varying,
    image_file_size integer,
    image_updated_at timestamp without time zone
);


ALTER TABLE public.rooms OWNER TO m3dw3;

--
-- Name: rooms_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE rooms_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rooms_id_seq OWNER TO m3dw3;

--
-- Name: rooms_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE rooms_id_seq OWNED BY rooms.id;


--
-- Name: schema_migrations; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE schema_migrations (
    version character varying NOT NULL
);


ALTER TABLE public.schema_migrations OWNER TO m3dw3;

--
-- Name: serviices; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE serviices (
    id integer NOT NULL,
    name character varying,
    code character varying,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.serviices OWNER TO m3dw3;

--
-- Name: serviices_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE serviices_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.serviices_id_seq OWNER TO m3dw3;

--
-- Name: serviices_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE serviices_id_seq OWNED BY serviices.id;


--
-- Name: users; Type: TABLE; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE TABLE users (
    id integer NOT NULL,
    email character varying DEFAULT ''::character varying NOT NULL,
    encrypted_password character varying DEFAULT ''::character varying NOT NULL,
    reset_password_token character varying,
    reset_password_sent_at timestamp without time zone,
    remember_created_at timestamp without time zone,
    sign_in_count integer DEFAULT 0 NOT NULL,
    current_sign_in_at timestamp without time zone,
    last_sign_in_at timestamp without time zone,
    current_sign_in_ip inet,
    last_sign_in_ip inet,
    role_type character varying,
    role_id integer,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);


ALTER TABLE public.users OWNER TO m3dw3;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: m3dw3
--

CREATE SEQUENCE users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO m3dw3;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: m3dw3
--

ALTER SEQUENCE users_id_seq OWNED BY users.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY accommodation_equipments ALTER COLUMN id SET DEFAULT nextval('accommodation_equipments_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY accommodations ALTER COLUMN id SET DEFAULT nextval('accommodations_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY addresses ALTER COLUMN id SET DEFAULT nextval('addresses_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY admins ALTER COLUMN id SET DEFAULT nextval('admins_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY bookings ALTER COLUMN id SET DEFAULT nextval('bookings_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY bookings_guests ALTER COLUMN id SET DEFAULT nextval('bookings_guests_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY bookings_rooms ALTER COLUMN id SET DEFAULT nextval('bookings_rooms_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY categries ALTER COLUMN id SET DEFAULT nextval('categries_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY comments ALTER COLUMN id SET DEFAULT nextval('comments_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY equipment ALTER COLUMN id SET DEFAULT nextval('equipment_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY equipment_rooms ALTER COLUMN id SET DEFAULT nextval('equipment_rooms_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY guests ALTER COLUMN id SET DEFAULT nextval('guests_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY owners ALTER COLUMN id SET DEFAULT nextval('owners_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY prices ALTER COLUMN id SET DEFAULT nextval('prices_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY properties ALTER COLUMN id SET DEFAULT nextval('properties_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY rooms ALTER COLUMN id SET DEFAULT nextval('rooms_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY serviices ALTER COLUMN id SET DEFAULT nextval('serviices_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: m3dw3
--

ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);


--
-- Data for Name: accommodation_equipments; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY accommodation_equipments (id, accommodation_id, equipment_id, created_at, updated_at) FROM stdin;
\.


--
-- Name: accommodation_equipments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('accommodation_equipments_id_seq', 1, false);


--
-- Data for Name: accommodations; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY accommodations (id, name, code, description, owner_id, categry_id, created_at, updated_at, image_file_name, image_content_type, image_file_size, image_updated_at) FROM stdin;
2	Hotel 1	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec dui dictum, vestibulum ante non, vestibulum enim. Nunc convallis neque eu elit mollis, nec tincidunt ex viverra. Pellentesque posuere, ex vitae dapibus viverra, justo libero vestibulum nunc, et congue leo velit a nisi. Aenean et scelerisque mi. Fusce nec molestie magna. Integer fringilla auctor metus sed commodo. Sed at aliquet neque. Nunc faucibus porta consectetur. Cras ac dui consectetur, rutrum magna consequat, eleifend tortor.\r\n\r\nCras dolor diam, tempus nec scelerisque vel, pretium sit amet nulla. Etiam luctus leo sed ipsum tincidunt, id ornare leo vestibulum. Maecenas nisi elit, cursus non fermentum quis, viverra et massa. In sollicitudin justo tortor, id efficitur dolor volutpat sed. Proin ac metus odio. Integer tempus ac purus a mattis. Pellentesque accumsan dolor mattis dui pellentesque viverra.	2	5	2015-02-20 16:09:09.067244	2015-03-27 17:19:23.741037	hotel1.jpg	image/jpeg	225926	2015-03-27 17:19:23.030537
3	Hotel 2	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec nec dui dictum, vestibulum ante non, vestibulum enim. Nunc convallis neque eu elit mollis, nec tincidunt ex viverra. Pellentesque posuere, ex vitae dapibus viverra, justo libero vestibulum nunc, et congue leo velit a nisi. Aenean et scelerisque mi. Fusce nec molestie magna. Integer fringilla auctor metus sed commodo. Sed at aliquet neque. Nunc faucibus porta consectetur. Cras ac dui consectetur, rutrum magna consequat, eleifend tortor.\r\n\r\nCras dolor diam, tempus nec scelerisque vel, pretium sit amet nulla. Etiam luctus leo sed ipsum tincidunt, id ornare leo vestibulum. Maecenas nisi elit, cursus non fermentum quis, viverra et massa. In sollicitudin justo tortor, id efficitur dolor volutpat sed. Proin ac metus odio. Integer tempus ac purus a mattis. Pellentesque accumsan dolor mattis dui pellentesque viverra.	3	4	2015-02-20 16:18:08.967696	2015-03-27 17:20:48.040515	hotel2.jpg	image/jpeg	188728	2015-03-27 17:20:47.650846
4	Hotel 3	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ut massa at est cursus dictum ut sed nisl. Sed elementum a leo consectetur dignissim. Etiam non faucibus ex, sed molestie velit. Phasellus elementum hendrerit lectus at interdum. Aenean iaculis vestibulum ultrices. Vivamus a risus rhoncus, ultrices eros sit amet, ultricies ipsum. Integer in turpis ligula. Vivamus molestie dictum purus, quis tempus diam tincidunt nec. Pellentesque sagittis nunc tortor, id rhoncus felis lobortis ac. Sed felis justo, cursus eget nisi rutrum, luctus maximus arcu. Nunc elementum dapibus pharetra. Aliquam dapibus justo et ornare luctus. Phasellus tempor suscipit suscipit. Nam dignissim aliquet consequat. Morbi dapibus efficitur ante, quis interdum nisi. Sed elit nibh, sollicitudin quis dapibus sit amet, tempus sit amet risus.\r\n\r\nInteger sed turpis pharetra, lobortis augue vel, porttitor dolor. Ut faucibus efficitur libero, in consectetur nunc ullamcorper in. Donec efficitur gravida sem at semper. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer malesuada nisi arcu, egestas feugiat purus venenatis at. Nulla facilisi. Donec maximus ultrices dolor, non viverra arcu viverra in. Vestibulum tempus non eros sit amet gravida. Proin molestie consectetur lacus quis pellentesque. Suspendisse maximus mi quis nisl dictum, quis egestas eros molestie. Nam aliquam tempus risus, in dignissim massa sollicitudin non. Phasellus nunc orci, imperdiet in nunc ac, lobortis mattis felis. Proin ante odio, ornare vel magna vitae, eleifend facilisis dolor. Nam suscipit quis lacus id porta. Vestibulum euismod vehicula justo.	4	3	2015-02-20 16:22:43.934142	2015-03-27 17:23:46.588471	hotel3.jpg	image/jpeg	1020563	2015-03-27 17:23:45.950071
5	Hotel 4	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam ut massa at est cursus dictum ut sed nisl. Sed elementum a leo consectetur dignissim. Etiam non faucibus ex, sed molestie velit. Phasellus elementum hendrerit lectus at interdum. Aenean iaculis vestibulum ultrices. Vivamus a risus rhoncus, ultrices eros sit amet, ultricies ipsum. Integer in turpis ligula. Vivamus molestie dictum purus, quis tempus diam tincidunt nec. Pellentesque sagittis nunc tortor, id rhoncus felis lobortis ac. Sed felis justo, cursus eget nisi rutrum, luctus maximus arcu. Nunc elementum dapibus pharetra. Aliquam dapibus justo et ornare luctus. Phasellus tempor suscipit suscipit. Nam dignissim aliquet consequat. Morbi dapibus efficitur ante, quis interdum nisi. Sed elit nibh, sollicitudin quis dapibus sit amet, tempus sit amet risus.\r\n\r\nInteger sed turpis pharetra, lobortis augue vel, porttitor dolor. Ut faucibus efficitur libero, in consectetur nunc ullamcorper in. Donec efficitur gravida sem at semper. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Integer malesuada nisi arcu, egestas feugiat purus venenatis at. Nulla facilisi. Donec maximus ultrices dolor, non viverra arcu viverra in. Vestibulum tempus non eros sit amet gravida. Proin molestie consectetur lacus quis pellentesque. Suspendisse maximus mi quis nisl dictum, quis egestas eros molestie. Nam aliquam tempus risus, in dignissim massa sollicitudin non. Phasellus nunc orci, imperdiet in nunc ac, lobortis mattis felis. Proin ante odio, ornare vel magna vitae, eleifend facilisis dolor. Nam suscipit quis lacus id porta. Vestibulum euismod vehicula justo.	4	4	2015-02-20 16:23:47.184568	2015-03-27 17:24:13.201612	hotel4.jpg	image/jpeg	227782	2015-03-27 17:24:12.816145
6	Hotel Lővér Sopron	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2	3	2015-03-29 08:53:23.91417	2015-03-29 08:53:23.91417	\N	\N	\N	\N
7	Hotel Sopron 	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2	4	2015-03-29 08:59:38.763643	2015-03-29 08:59:38.763643	\N	\N	\N	\N
8	Hotel Szieszta	\N	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2	3	2015-03-29 09:13:05.921333	2015-03-29 09:13:05.921333	\N	\N	\N	\N
\.


--
-- Name: accommodations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('accommodations_id_seq', 17, true);


--
-- Data for Name: accommodations_serviices; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY accommodations_serviices (accommodation_id, serviice_id) FROM stdin;
2	1
2	3
2	5
3	3
3	5
4	3
4	5
5	3
5	4
5	5
6	1
6	2
6	3
6	4
6	5
7	1
7	2
7	5
8	1
8	2
8	3
8	4
8	5
2	1
2	3
2	5
3	3
3	5
4	3
4	5
5	3
5	4
5	5
6	1
6	2
6	3
6	4
6	5
7	1
7	2
7	5
8	1
8	2
8	3
8	4
8	5
9	3
9	4
9	5
10	1
10	2
10	3
10	4
10	5
11	3
11	5
12	1
12	2
12	3
12	4
12	5
13	3
13	5
14	4
14	5
15	1
15	3
15	4
15	5
16	1
16	3
16	4
16	5
17	5
\.


--
-- Data for Name: addresses; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY addresses (id, country, zip, city, address, latitude, longitude, addressable_id, addressable_type, created_at, updated_at) FROM stdin;
1	AL	0123	Sopron	Deák Ferenc tér 1.	\N	\N	1	Guest	2015-02-20 15:35:05.870613	2015-02-20 15:35:05.870613
2	HU	1000	Budapest	Váci utca 1	47.5139834000000008	19.0594125000000005	1	Accommodation	2015-02-20 15:58:32.218611	2015-02-20 15:58:32.218611
3	HU	1000	Budapest	Váci utca 1.	47.5139834000000008	19.0594125000000005	2	Accommodation	2015-02-20 16:09:09.082167	2015-02-20 16:09:09.082167
5	HU	1000	Budapest	Pannónia utca 116	47.5267211999999972	19.0594058000000004	4	Accommodation	2015-02-20 16:22:43.947529	2015-02-20 16:22:43.947529
6	HU	1000	Budapest	Budaörsi út 4.	47.4872376000000003	19.0248358000000017	5	Accommodation	2015-02-20 16:23:47.19805	2015-02-20 16:23:47.19805
7	HU	8200	Veszprém	Egyetem utca 12.	47.0846238999999969	17.9095340999999983	58	Guest	2015-03-27 17:15:34.341617	2015-03-27 17:15:34.341617
4	HU	1000	Budapest	Kossuth tér 2.	47.4581661000000068	19.1460673999999997	3	Accommodation	2015-02-20 16:18:08.982951	2015-03-27 17:20:48.043053
8	HU	9400	Sopron	Várisi út. 4.	47.6679835999999995	16.5789696999999983	6	Accommodation	2015-03-29 08:53:23.924298	2015-03-29 10:36:30.230121
9	HU	9400	Sopron	Fövényverem utca 7.	47.6888891999999984	16.5937315000000005	7	Accommodation	2015-03-29 08:59:38.77102	2015-03-29 10:36:56.741453
10	HU	9400	Sopron	Lővér körút 37.	47.6710303999999994	16.5751612000000002	8	Accommodation	2015-03-29 09:13:05.930913	2015-03-29 10:37:11.008125
\.


--
-- Name: addresses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('addresses_id_seq', 19, true);


--
-- Data for Name: admins; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY admins (id, name, phone, created_at, updated_at) FROM stdin;
1	admin1	0123456789	2015-02-20 17:01:38.817	2015-02-20 17:01:40.455
\.


--
-- Name: admins_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('admins_id_seq', 1, false);


--
-- Data for Name: bookings; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY bookings (id, start_date, end_date, num_of_nights, state, guest_id, created_at, updated_at) FROM stdin;
23	2015-03-26	2015-03-30	1	CLOSED	1	2015-03-29 20:31:28.316684	2015-03-30 16:29:20.813494
26	2015-03-30	2015-03-31	1	BOOKED	1	2015-03-30 16:38:46.115783	2015-03-30 18:38:42.758289
27	2015-03-31	2015-04-01	1	BOOKED	1	2015-03-30 18:38:43.296983	2015-03-30 18:43:32.064082
28	2015-04-01	2015-04-02	1	BOOKED	1	2015-03-30 18:43:32.610948	2015-03-30 18:44:21.927726
22	2015-03-29	2015-03-30	1	CLOSED	1	2015-03-29 20:25:29.046298	2015-03-30 16:19:27.420378
24	2015-03-29	2015-03-30	2	CLOSED	1	2015-03-29 20:55:46.656911	2015-03-30 14:39:13.635951
25	2015-03-30	2015-03-31	1	DENIED	1	2015-03-30 13:29:45.520855	2015-03-30 16:38:43.917527
29	2015-03-30	2015-03-31	1	CART	1	2015-03-30 18:44:22.539771	2015-04-03 17:32:33.910124
\.


--
-- Data for Name: bookings_guests; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY bookings_guests (id, guest_id, booking_id, room_id, role, created_at, updated_at, bed, room_index) FROM stdin;
78	1	22	11	BOOKER	2015-03-29 20:25:29.081428	2015-03-29 20:31:27.763312	1	1
79	59	22	11	RELATIVE	2015-03-29 20:31:27.791887	2015-03-29 20:31:27.791887	2	1
80	60	22	11	RELATIVE	2015-03-29 20:31:27.821684	2015-03-29 20:31:27.821684	1	2
81	61	22	11	RELATIVE	2015-03-29 20:31:27.831819	2015-03-29 20:31:27.831819	2	2
82	1	23	1	BOOKER	2015-03-29 20:31:28.331449	2015-03-29 20:55:46.111083	1	1
83	62	23	1	RELATIVE	2015-03-29 20:55:46.14827	2015-03-29 20:55:46.14827	2	1
84	1	24	1	BOOKER	2015-03-29 20:55:46.661298	2015-03-30 13:29:43.333821	1	1
85	63	24	1	RELATIVE	2015-03-30 13:29:43.455545	2015-03-30 13:29:43.455545	2	1
86	64	24	8	RELATIVE	2015-03-30 13:29:43.560605	2015-03-30 13:29:43.560605	1	2
87	65	24	8	RELATIVE	2015-03-30 13:29:43.638425	2015-03-30 13:29:43.638425	2	2
88	1	25	2	BOOKER	2015-03-30 13:29:45.5556	2015-03-30 16:38:43.781788	1	1
89	66	25	2	RELATIVE	2015-03-30 16:38:43.840853	2015-03-30 16:38:43.840853	2	1
90	1	26	3	BOOKER	2015-03-30 16:38:46.160739	2015-03-30 18:38:42.557646	1	1
91	67	26	3	RELATIVE	2015-03-30 18:38:42.673043	2015-03-30 18:38:42.673043	2	1
92	68	26	3	RELATIVE	2015-03-30 18:38:42.712519	2015-03-30 18:38:42.712519	1	2
93	69	26	3	RELATIVE	2015-03-30 18:38:42.73222	2015-03-30 18:38:42.73222	2	2
94	1	27	3	BOOKER	2015-03-30 18:38:43.306755	2015-03-30 18:43:31.952322	1	1
95	70	27	3	RELATIVE	2015-03-30 18:43:32.002285	2015-03-30 18:43:32.002285	2	1
96	71	27	3	RELATIVE	2015-03-30 18:43:32.020653	2015-03-30 18:43:32.020653	1	2
97	72	27	3	RELATIVE	2015-03-30 18:43:32.038204	2015-03-30 18:43:32.038204	2	2
98	1	28	3	BOOKER	2015-03-30 18:43:32.620775	2015-03-30 18:44:21.8595	1	1
99	73	28	3	RELATIVE	2015-03-30 18:44:21.871456	2015-03-30 18:44:21.871456	2	1
100	74	28	3	RELATIVE	2015-03-30 18:44:21.89984	2015-03-30 18:44:21.89984	1	2
101	75	28	3	RELATIVE	2015-03-30 18:44:21.910352	2015-03-30 18:44:21.910352	2	2
102	1	29	\N	\N	2015-03-30 18:44:22.544275	2015-03-30 18:44:22.544275	\N	\N
\.


--
-- Name: bookings_guests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('bookings_guests_id_seq', 79, true);


--
-- Name: bookings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('bookings_id_seq', 22, true);


--
-- Data for Name: bookings_rooms; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY bookings_rooms (id, booking_id, room_id, status, created_at, updated_at, index) FROM stdin;
61	22	11	DENIED	2015-03-29 20:28:41.321612	2015-03-30 16:19:27.388204	2
60	22	11	DENIED	2015-03-29 20:28:41.299821	2015-03-30 16:19:27.401915	1
68	23	1	CLOSED	2015-03-29 20:54:41.869447	2015-03-30 16:29:20.76362	1
77	25	2	BOOKED	2015-03-30 16:38:24.592868	2015-03-30 16:38:43.906319	1
79	26	3	BOOKED	2015-03-30 18:38:04.643998	2015-03-30 18:38:42.749919	1
80	26	3	BOOKED	2015-03-30 18:38:08.593435	2015-03-30 18:38:42.754222	2
81	27	3	BOOKED	2015-03-30 18:39:15.851429	2015-03-30 18:43:32.044125	1
82	27	3	BOOKED	2015-03-30 18:43:09.738281	2015-03-30 18:43:32.049412	2
83	28	3	BOOKED	2015-03-30 18:43:57.304108	2015-03-30 18:44:21.918145	1
84	28	3	BOOKED	2015-03-30 18:44:01.049118	2015-03-30 18:44:21.923027	2
75	24	1	CLOSED	2015-03-30 13:26:58.226171	2015-03-30 14:17:20.918665	1
76	24	8	CLOSED	2015-03-30 13:28:35.414704	2015-03-30 14:39:13.60521	2
85	29	2	\N	2015-04-03 17:32:33.873911	2015-04-03 17:32:33.873911	\N
\.


--
-- Name: bookings_rooms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('bookings_rooms_id_seq', 76, true);


--
-- Data for Name: categries; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY categries (id, name, code, value, created_at, updated_at) FROM stdin;
1	1 csillag	STAR_1	1	2015-02-20 16:02:10.146827	2015-02-20 16:03:41.667264
2	2 csillag	STAR_2	2	2015-02-20 16:02:31.709424	2015-02-20 16:03:50.178878
3	3 csillag	STAR_3	3	2015-02-20 16:04:05.397413	2015-02-20 16:04:05.397413
4	4 csillag	STAR_4	4	2015-02-20 16:04:15.630177	2015-02-20 16:04:15.630177
5	5 csillag	STAR_5	5	2015-02-20 16:04:27.336501	2015-02-20 16:04:27.336501
\.


--
-- Name: categries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('categries_id_seq', 5, true);


--
-- Data for Name: comments; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY comments (id, stars, text, guest_id, accommodation_id, booking_id, created_at, updated_at) FROM stdin;
3	9	asdasd	1	5	24	2015-03-30 20:20:33.891724	2015-03-30 20:20:33.891724
4	7	qweqwe	1	2	24	2015-03-30 20:20:41.535429	2015-03-30 20:20:41.535429
\.


--
-- Name: comments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('comments_id_seq', 1, false);


--
-- Data for Name: equipment; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY equipment (id, name, code, created_at, updated_at) FROM stdin;
1	WiFi	WIF	2015-02-20 16:06:07.16939	2015-02-20 16:06:07.16939
2	Ethernet	ETH	2015-02-20 16:06:17.801805	2015-02-20 16:06:17.801805
3	Televízió	TVI	2015-02-20 16:06:32.414806	2015-02-20 16:06:32.414806
4	Telefon	TEL	2015-02-20 16:06:40.533253	2015-02-20 16:06:40.533253
5	Minibár	MBR	2015-02-20 16:06:51.504816	2015-02-20 16:06:51.504816
6	Széf	SFE	2015-02-20 16:07:04.580965	2015-02-20 16:07:14.809788
7	Légkondícionáló	CON	2015-02-20 16:07:31.707842	2015-02-20 16:07:31.707842
\.


--
-- Name: equipment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('equipment_id_seq', 7, true);


--
-- Data for Name: equipment_rooms; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY equipment_rooms (id, room_id, equipment_id, created_at, updated_at) FROM stdin;
1	1	1	2015-02-20 16:14:51.611601	2015-02-20 16:14:51.611601
2	1	3	2015-02-20 16:14:51.615432	2015-02-20 16:14:51.615432
3	1	6	2015-02-20 16:14:51.618124	2015-02-20 16:14:51.618124
4	2	1	2015-02-20 16:16:34.728009	2015-02-20 16:16:34.728009
5	2	2	2015-02-20 16:16:34.730921	2015-02-20 16:16:34.730921
6	2	3	2015-02-20 16:16:34.73795	2015-02-20 16:16:34.73795
7	2	4	2015-02-20 16:16:34.74098	2015-02-20 16:16:34.74098
8	3	6	2015-02-20 16:18:55.251157	2015-02-20 16:18:55.251157
9	3	7	2015-02-20 16:18:55.2563	2015-02-20 16:18:55.2563
10	4	1	2015-02-20 16:20:13.698744	2015-02-20 16:20:13.698744
11	4	7	2015-02-20 16:20:13.700849	2015-02-20 16:20:13.700849
12	5	1	2015-02-20 16:20:40.67634	2015-02-20 16:20:40.67634
13	5	6	2015-02-20 16:20:40.678837	2015-02-20 16:20:40.678837
14	5	7	2015-02-20 16:20:40.682028	2015-02-20 16:20:40.682028
15	6	1	2015-02-20 16:24:35.361896	2015-02-20 16:24:35.361896
16	6	2	2015-02-20 16:24:35.366367	2015-02-20 16:24:35.366367
17	6	3	2015-02-20 16:24:35.369101	2015-02-20 16:24:35.369101
18	6	4	2015-02-20 16:24:35.371554	2015-02-20 16:24:35.371554
19	6	5	2015-02-20 16:24:35.374037	2015-02-20 16:24:35.374037
20	6	6	2015-02-20 16:24:35.376576	2015-02-20 16:24:35.376576
21	6	7	2015-02-20 16:24:35.379027	2015-02-20 16:24:35.379027
22	7	1	2015-02-20 16:25:05.968682	2015-02-20 16:25:05.968682
23	7	3	2015-02-20 16:25:05.972747	2015-02-20 16:25:05.972747
24	7	7	2015-02-20 16:25:05.97831	2015-02-20 16:25:05.97831
25	8	1	2015-02-20 16:25:35.113931	2015-02-20 16:25:35.113931
26	8	7	2015-02-20 16:25:35.11731	2015-02-20 16:25:35.11731
27	9	3	2015-02-20 16:26:17.229519	2015-02-20 16:26:17.229519
28	10	1	2015-03-29 08:55:29.501598	2015-03-29 08:55:29.501598
29	10	3	2015-03-29 08:55:29.503387	2015-03-29 08:55:29.503387
30	10	4	2015-03-29 08:55:29.504751	2015-03-29 08:55:29.504751
31	11	1	2015-03-29 08:56:28.262408	2015-03-29 08:56:28.262408
32	11	3	2015-03-29 08:56:28.263929	2015-03-29 08:56:28.263929
33	11	4	2015-03-29 08:56:28.265369	2015-03-29 08:56:28.265369
34	11	7	2015-03-29 08:56:28.266699	2015-03-29 08:56:28.266699
35	12	1	2015-03-29 09:02:27.047323	2015-03-29 09:02:27.047323
36	12	7	2015-03-29 09:02:27.048738	2015-03-29 09:02:27.048738
37	13	1	2015-03-29 09:04:05.405135	2015-03-29 09:04:05.405135
38	13	7	2015-03-29 09:04:05.406624	2015-03-29 09:04:05.406624
39	14	1	2015-03-29 09:06:13.345197	2015-03-29 09:06:13.345197
40	14	5	2015-03-29 09:06:13.346665	2015-03-29 09:06:13.346665
41	14	7	2015-03-29 09:06:13.347947	2015-03-29 09:06:13.347947
42	15	1	2015-03-29 09:07:26.065034	2015-03-29 09:07:26.065034
43	15	4	2015-03-29 09:07:26.066788	2015-03-29 09:07:26.066788
44	15	7	2015-03-29 09:07:26.068468	2015-03-29 09:07:26.068468
45	16	1	2015-03-29 09:08:42.032327	2015-03-29 09:08:42.032327
46	16	7	2015-03-29 09:08:42.034588	2015-03-29 09:08:42.034588
47	17	1	2015-03-29 09:10:41.593636	2015-03-29 09:10:41.593636
48	17	7	2015-03-29 09:10:41.595084	2015-03-29 09:10:41.595084
49	18	3	2015-03-29 09:14:47.382815	2015-03-29 09:14:47.382815
50	19	3	2015-03-29 09:15:34.68379	2015-03-29 09:15:34.68379
51	19	4	2015-03-29 09:15:34.685426	2015-03-29 09:15:34.685426
52	19	7	2015-03-29 09:15:34.68684	2015-03-29 09:15:34.68684
\.


--
-- Name: equipment_rooms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('equipment_rooms_id_seq', 157, true);


--
-- Data for Name: guests; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY guests (id, name, phone, day_of_birth, guest_id, created_at, updated_at) FROM stdin;
1	Nagy Gábor	0123435	1925-02-20	\N	2015-02-20 15:35:05.864469	2015-02-20 15:35:05.864469
31	Nagy Gáborné	0	2015-02-24	\N	2015-02-24 16:46:39.380424	2015-02-24 16:46:39.380424
32	Nagy István	0	2015-02-24	\N	2015-02-24 16:49:32.162812	2015-02-24 16:49:32.162812
34	Németh Vilmos	0	2015-02-24	1	2015-02-24 17:04:51.266305	2015-02-24 17:04:51.266305
35	sdfsd	0	2015-02-24	1	2015-02-24 19:11:09.015952	2015-02-24 19:11:09.015952
36	asd	0	2015-02-24	1	2015-02-24 19:11:09.034986	2015-02-24 19:11:09.034986
37	asdasd	0	2015-02-24	1	2015-02-24 19:11:09.053269	2015-02-24 19:11:09.053269
38	asd	0	2015-02-25	1	2015-02-25 16:00:03.260924	2015-02-25 16:00:03.260924
39	sdf	0	2015-02-25	1	2015-02-25 16:00:03.298606	2015-02-25 16:00:03.298606
40	dfg	0	2015-02-25	1	2015-02-25 16:00:03.389646	2015-02-25 16:00:03.389646
41	fgh	0	2015-02-25	1	2015-02-25 16:00:03.42722	2015-02-25 16:00:03.42722
42	ghj	0	2015-02-25	1	2015-02-25 16:00:03.438901	2015-02-25 16:00:03.438901
43	hjk	0	2015-02-25	1	2015-02-25 16:00:03.461106	2015-02-25 16:00:03.461106
44	jkl	0	2015-02-25	1	2015-02-25 16:00:03.47284	2015-02-25 16:00:03.47284
45	klé	0	2015-02-25	1	2015-02-25 16:00:03.487815	2015-02-25 16:00:03.487815
46	léá	0	2015-02-25	1	2015-02-25 16:00:03.498597	2015-02-25 16:00:03.498597
47	éáű	0	2015-02-25	1	2015-02-25 16:00:03.513972	2015-02-25 16:00:03.513972
48	qwe	0	2015-02-25	1	2015-02-25 16:00:03.523848	2015-02-25 16:00:03.523848
49	wer	0	2015-02-25	1	2015-02-25 16:00:03.547942	2015-02-25 16:00:03.547942
50	ert	0	2015-02-25	1	2015-02-25 16:00:03.559296	2015-02-25 16:00:03.559296
51	rtz	0	2015-02-25	1	2015-02-25 16:00:03.57608	2015-02-25 16:00:03.57608
52	tzu	0	2015-02-25	1	2015-02-25 16:00:03.597061	2015-02-25 16:00:03.597061
53	zui	0	2015-02-25	1	2015-02-25 16:00:03.615846	2015-02-25 16:00:03.615846
54	uio	0	2015-02-25	1	2015-02-25 16:00:03.629065	2015-02-25 16:00:03.629065
55	dsa	0	1925-02-20	1	2015-03-03 19:14:45.752423	2015-03-03 19:14:45.752423
56	dsa	0	1925-02-20	1	2015-03-03 19:14:45.790476	2015-03-03 19:14:45.790476
58	Drescher Adrienn	+36302341209	1990-03-29	\N	2015-03-27 17:15:34.33497	2015-03-27 17:15:34.33497
59	asd	0	2015-03-29	1	2015-03-29 20:31:27.781059	2015-03-29 20:31:27.781059
60	sdf	0	2015-03-29	1	2015-03-29 20:31:27.812578	2015-03-29 20:31:27.812578
61	dfg	0	2015-03-29	1	2015-03-29 20:31:27.826715	2015-03-29 20:31:27.826715
62	Drescher Adrienn	0	2015-03-29	1	2015-03-29 20:55:46.131449	2015-03-29 20:55:46.131449
63	asd	0	2015-03-30	1	2015-03-30 13:29:43.416048	2015-03-30 13:29:43.416048
64	sdf	0	2015-03-30	1	2015-03-30 13:29:43.532173	2015-03-30 13:29:43.532173
65	dfg	0	2015-03-30	1	2015-03-30 13:29:43.588996	2015-03-30 13:29:43.588996
66	asd	0	2015-03-30	1	2015-03-30 16:38:43.805608	2015-03-30 16:38:43.805608
67	asad	0	2015-03-30	1	2015-03-30 18:38:42.651787	2015-03-30 18:38:42.651787
68	qwe	0	2015-03-30	1	2015-03-30 18:38:42.70627	2015-03-30 18:38:42.70627
69	ewq	0	2015-03-30	1	2015-03-30 18:38:42.721544	2015-03-30 18:38:42.721544
70	asd	0	2015-03-30	1	2015-03-30 18:43:31.986519	2015-03-30 18:43:31.986519
71	sdf	0	2015-03-30	1	2015-03-30 18:43:32.015757	2015-03-30 18:43:32.015757
72	dfg	0	2015-03-30	1	2015-03-30 18:43:32.028864	2015-03-30 18:43:32.028864
73	asd	0	2015-03-30	1	2015-03-30 18:44:21.866107	2015-03-30 18:44:21.866107
74	sdf	0	2015-03-30	1	2015-03-30 18:44:21.888423	2015-03-30 18:44:21.888423
75	dfg	0	2015-03-30	1	2015-03-30 18:44:21.905274	2015-03-30 18:44:21.905274
\.


--
-- Name: guests_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('guests_id_seq', 59, true);


--
-- Data for Name: owners; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY owners (id, name, created_at, updated_at) FROM stdin;
1	Kis Gizi	2015-02-20 15:34:31.86517	2015-02-20 15:34:31.86517
2	szállásadó1	2015-02-20 15:51:26.912395	2015-02-20 15:51:26.912395
3	szállásadó2	2015-02-20 15:51:42.202822	2015-02-20 15:51:42.202822
4	szállásadó3	2015-02-20 15:51:56.521448	2015-02-20 15:51:56.521448
5	Öreg szőlő vendégház	2015-03-27 17:40:36.595468	2015-03-27 17:40:36.595468
6	Marcsi Apartman	2015-03-27 17:44:03.95401	2015-03-27 17:44:03.95401
7	Hotel Szilán	2015-03-27 17:47:23.290175	2015-03-27 17:47:23.290175
\.


--
-- Name: owners_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('owners_id_seq', 9, true);


--
-- Data for Name: prices; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY prices (id, value, currency, ifa, vat, room_id, created_at, updated_at) FROM stdin;
1	10000	Ft	350	0.270000000000000018	1	2015-02-20 16:14:51.627472	2015-02-20 16:14:51.627472
2	10000	Ft	350	0.270000000000000018	2	2015-02-20 16:16:34.743725	2015-02-20 16:16:34.743725
3	10000	Ft	350	0.270000000000000018	3	2015-02-20 16:18:55.260026	2015-02-20 16:18:55.260026
4	10000	Ft	350	0.270000000000000018	4	2015-02-20 16:20:13.704225	2015-02-20 16:20:13.704225
5	10000	Ft	350	0.270000000000000018	5	2015-02-20 16:20:40.686117	2015-02-20 16:20:40.686117
6	10000	Ft	350	0.270000000000000018	6	2015-02-20 16:24:35.382305	2015-02-20 16:24:35.382305
7	10000	Ft	350	0.270000000000000018	7	2015-02-20 16:25:05.983939	2015-02-20 16:25:05.983939
8	10000	Ft	350	0.270000000000000018	8	2015-02-20 16:25:35.121457	2015-02-20 16:25:35.121457
9	10000	Ft	350	0.270000000000000018	9	2015-02-20 16:26:17.232675	2015-02-20 16:26:17.232675
11	26000	Ft	350	0.270000000000000018	11	2015-03-29 08:56:28.268217	2015-03-29 08:56:28.268217
10	24000	Ft	350	0.270000000000000018	10	2015-03-29 08:55:29.506567	2015-03-29 08:56:52.914379
12	19450	Ft	350	0.270000000000000018	12	2015-03-29 09:02:27.050268	2015-03-29 09:02:27.050268
13	28900	Ft	350	0.270000000000000018	13	2015-03-29 09:04:05.408344	2015-03-29 09:04:05.408344
14	32400	Ft	350	0.270000000000000018	14	2015-03-29 09:06:13.349455	2015-03-29 09:06:13.349455
15	37800	Ft	350	0.270000000000000018	15	2015-03-29 09:07:26.070498	2015-03-29 09:07:26.070498
16	51900	Ft	350	0.270000000000000018	16	2015-03-29 09:08:42.036498	2015-03-29 09:08:42.036498
17	57600	Ft	350	0.270000000000000018	17	2015-03-29 09:10:41.596748	2015-03-29 09:10:41.596748
18	26000	Ft	350	0.270000000000000018	18	2015-03-29 09:14:47.385084	2015-03-29 09:14:47.385084
19	30000	Ft	350	0.270000000000000018	19	2015-03-29 09:15:34.68844	2015-03-29 09:15:34.68844
\.


--
-- Name: prices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('prices_id_seq', 41, true);


--
-- Data for Name: properties; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY properties (id, key, value, "group", created_at, updated_at, title) FROM stdin;
1	model_cheap	set ROOMS;\r\n\r\nparam min_capacity >= 0;\r\nparam guests >= 0;\r\n\r\nparam capacity {ROOMS} >=0;\t\t\t\t# the amount of beds in a room\r\nparam stars {ROOMS} >=0;                                # average rating\r\nparam price {ROOMS} >= 0;\t\t\t\t# room price/night\r\n\r\nvar Occupation {ROOMS} binary;\t\t\t# which rooms are included in solution\r\nvar occupied_rooms = sum {i in ROOMS} Occupation[i];\r\n\r\nsubject to Accommodation:\t\t\t\t# selected rooms overall capacity have to be equal to guests\r\n\tsum {i in ROOMS} Occupation[i]*capacity[i] = if guests < min_capacity then min_capacity else guests;\r\n\r\nminimize OPTIMUM:\r\n\tsum{i in ROOMS} Occupation[i]*price[i] + \r\n     sqrt((sum{i in ROOMS} Occupation[i]*((stars[i]-10)^2))/occupied_rooms + 1)/10;	smartfilter	2015-03-29 11:49:46.844	2015-03-31 16:48:37.605746	Olcsó modell
2	model_close	set ROOMS;\r\n\r\nparam min_capacity >= 0;\r\nparam guests >= 0;\r\n\r\nparam capacity {ROOMS} >=0;\t\t\t\t# the amount of beds in a room\r\nparam stars {ROOMS} >=0;                                # average rating\r\nparam distance {ROOMS,ROOMS} >= 0;\t\t# destination between rooms\r\n\r\nvar Occupation {ROOMS} binary;\t\t\t# which rooms are included in solution\r\nvar occupied_rooms = sum {i in ROOMS} Occupation[i];\r\n\r\nsubject to Accommodation:\t\t\t\t# selected overall room capacity has to be equal to guests or minimum room capacity\r\n\tsum {i in ROOMS} Occupation[i]*capacity[i] = if guests < min_capacity then min_capacity else guests;\r\n\r\nminimize OPTIMUM:\r\n\tsum{(i,j) in {ROOMS,ROOMS}} (Occupation[i]*Occupation[j])*distance[i,j] + \r\n        sqrt((sum{i in ROOMS} Occupation[i]*((stars[i]-10)^2))/occupied_rooms + 1)/10;	smartfilter	2015-03-29 11:49:59.064	2015-03-31 13:03:37.854127	Közeli modell
3	model_cheap_and_close	set ROOMS;\r\n\r\nparam min_capacity >= 0;\r\nparam min_dist >= 0;\t\t\t\r\nparam min_price >= 0;\r\nparam guests >= 0;\r\n\r\nparam capacity {ROOMS} >=0;\t\t\t\t# the amount of beds in a room\r\nparam stars {ROOMS} >=0;                                # average rating\r\nparam price {ROOMS} >= 0;\t\t\t\t# room price/night\r\nparam distance {ROOMS,ROOMS} >= 0;\t\t# destination between rooms\r\n\r\nvar Occupation {ROOMS} binary;\t\t\t# which rooms are included in solution\r\nvar occupied_rooms = sum {i in ROOMS} Occupation[i];\r\n\r\nsubject to Accommodation:\t\t\t\t# selected rooms overall capacity have to be equal to guests\r\n\tsum {i in ROOMS} Occupation[i]*capacity[i] = if guests < min_capacity then min_capacity else guests;\r\n\r\nminimize OPTIMUM:\r\n\tsqrt((sum{i in ROOMS} Occupation[i]*((price[i]-min_price)^2))/occupied_rooms + 1)/min_price +\r\n\tif occupied_rooms > 1 then (\r\n\t\tsqrt((sum{(i,j) in {ROOMS,ROOMS}} (Occupation[i]*Occupation[j])*((distance[i,j]-min_dist)^2))/occupied_rooms + 1)\r\n\t\t\t\t/min_dist\r\n\t) + \r\n        sqrt((sum{i in ROOMS} Occupation[i]*((stars[i]-10)^2))/occupied_rooms + 1)/10;	smartfilter	2015-03-29 11:51:04.096	2015-03-31 13:03:48.746071	Olcsó és közeli modell
\.


--
-- Name: properties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('properties_id_seq', 1, false);


--
-- Data for Name: rooms; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY rooms (id, name, code, accommodation_id, num_of_this, capacity, description, created_at, updated_at, image_file_name, image_content_type, image_file_size, image_updated_at) FROM stdin;
1	Room 1	\N	2	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:14:51.604893	2015-03-27 17:20:06.63185	room1.jpg	image/jpeg	133133	2015-03-27 17:20:06.245916
3	Room 3	\N	3	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:18:55.24333	2015-03-27 17:22:56.299235	room3.jpg	image/jpeg	139227	2015-03-27 17:22:56.072695
4	Room 4	\N	3	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:20:13.695761	2015-03-27 17:23:12.777701	room4.jpg	image/jpeg	169500	2015-03-27 17:23:12.007849
5	Room 5	\N	3	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:20:40.671781	2015-03-27 17:23:27.460106	room5.jpg	image/jpeg	890864	2015-03-27 17:23:26.368928
9	Room 6	\N	4	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:26:17.221565	2015-03-27 17:23:59.582461	room6.jpg	image/jpeg	146398	2015-03-27 17:23:59.292902
6	Room 7	\N	5	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:24:35.356275	2015-03-27 17:25:11.142639	room7.jpg	image/jpeg	599775	2015-03-27 17:25:10.617593
8	Room 9	\N	5	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:25:35.110717	2015-03-27 17:25:22.593618	room9.jpg	image/jpeg	133859	2015-03-27 17:25:22.365074
7	Room 8	\N	5	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:25:05.963632	2015-03-27 17:25:57.992726	room8.jpg	image/jpeg	322251	2015-03-27 17:25:57.587994
2	Room 2	\N	2	2	2	Praesent euismod, eros quis lacinia eleifend, elit nulla iaculis sem, et vulputate orci lacus ut nisi. Cras sodales nisi dolor. Curabitur non eros in dui faucibus pharetra sed a leo. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Duis leo lorem, dignissim ac nulla convallis, rhoncus lacinia ipsum. Vivamus rutrum non lectus sed vehicula. Cras aliquam dignissim volutpat. Fusce mattis eleifend dignissim. Maecenas a felis nec nunc condimentum porta at quis augue. Ut tristique diam at urna faucibus, quis pretium dui malesuada. Nulla pulvinar congue feugiat. Quisque nec nisi vitae lacus blandit sagittis in sed urna. Pellentesque vitae fermentum risus, non viverra lorem. In porta ornare tortor ut sagittis.	2015-02-20 16:16:34.723982	2015-03-27 17:19:50.883492	room2.jpg	image/jpeg	701004	2015-03-27 17:19:50.277422
10	Standard kétágyas 	\N	6	3	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 08:55:29.499324	2015-03-29 10:42:51.905959	\N	\N	\N	\N
11	Superior kétágyas 	\N	6	4	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 08:56:28.26051	2015-03-29 10:43:11.557611	\N	\N	\N	\N
12	Fürdőszobás Standard egyágyas 	\N	7	2	1	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:02:27.045462	2015-03-29 09:02:27.045462	\N	\N	\N	\N
15	Fürdőszobás Standard háromágyas 	\N	7	2	3	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:07:26.062759	2015-03-29 09:07:26.062759	\N	\N	\N	\N
13	Fürdőszobás Standard kétágyas 	\N	7	2	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:04:05.402958	2015-03-29 09:27:26.245553	\N	\N	\N	\N
14	Panorámás Premium franciaágyas 	\N	7	2	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:06:13.342195	2015-03-29 09:06:13.342195	\N	\N	\N	\N
16	Panorámás Premium 3 fős apartman 	\N	7	2	3	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:08:42.030588	2015-03-29 09:08:42.030588	\N	\N	\N	\N
18	Erkélyes Classic kétágyas 	\N	8	2	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:14:47.379996	2015-03-29 09:28:20.374317	\N	\N	\N	\N
19	Erkélyes Standard kétágyas 	\N	8	2	2	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:15:34.681861	2015-03-29 09:28:32.507023	\N	\N	\N	\N
17	Standard Family négyágyas 	\N	7	3	4	Lorem ipsum dolor sit amet, consectetur adipiscing elit. In nec tincidunt justo. Suspendisse potenti. Nunc vehicula cursus sagittis. Etiam mollis justo leo, vitae consequat diam sollicitudin sed. Etiam tincidunt, nibh vestibulum faucibus condimentum, odio massa dictum turpis, a cursus enim nibh quis ante. Nulla facilisi. Ut viverra est vitae neque laoreet, finibus aliquam nisi ultricies. Etiam tempor, nunc eget viverra aliquam, felis nibh finibus sapien, vitae aliquet ante diam eget purus. Nam eleifend elementum massa in luctus. Nullam varius sapien ipsum. Sed ut nunc libero.	2015-03-29 09:10:41.591707	2015-03-29 09:27:49.75539	\N	\N	\N	\N
\.


--
-- Name: rooms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('rooms_id_seq', 41, true);


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY schema_migrations (version) FROM stdin;
20141124113607
20141124113617
20141124113627
20141124113637
20141124113647
20141125112859
20141125112917
20141125130140
20141125153213
20141126105640
20141126180619
20141126180716
20150203101520
20150203101553
20150203203021
20150211210112
20150212103821
20150212104021
20150212120006
20150328102239
20150328105336
20150329193503
20150329195525
20150329195759
20150330185132
\.


--
-- Data for Name: serviices; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY serviices (id, name, code, created_at, updated_at) FROM stdin;
1	Jacuzzi	JAC	2015-02-20 16:04:43.009768	2015-02-20 16:04:43.009768
2	Fedett uszoda	PO1	2015-02-20 16:05:09.082663	2015-02-20 16:05:09.082663
3	Italbár	DRB	2015-02-20 16:05:27.431231	2015-02-20 16:05:27.431231
4	Masszázs	MAS	2015-02-20 16:05:38.421359	2015-02-20 16:05:38.421359
5	Parkoló	PAR	2015-02-20 16:05:55.031034	2015-02-20 16:05:55.031034
\.


--
-- Name: serviices_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('serviices_id_seq', 5, true);


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: m3dw3
--

COPY users (id, email, encrypted_password, reset_password_token, reset_password_sent_at, remember_created_at, sign_in_count, current_sign_in_at, last_sign_in_at, current_sign_in_ip, last_sign_in_ip, role_type, role_id, created_at, updated_at) FROM stdin;
1	s@s.hu	$2a$10$spbnTM7Vej0Gh/vZQPj7qe3OCJViKL3o1qNFlXaqRAf1T38c8H8/G	\N	\N	\N	1	2015-02-20 15:35:41.153365	2015-02-20 15:35:41.153365	127.0.0.1	127.0.0.1	Owner	1	2015-02-20 15:34:31.885121	2015-02-20 15:35:41.156024
4	s2@v.hu	$2a$10$Wz5FRatWcipFoN8fDRGJ/ODpDdxcbCuH8/iMbN4m4/qFouC5xTmuO	\N	\N	\N	4	2015-02-25 16:00:55.872865	2015-02-24 20:33:20.08399	127.0.0.1	127.0.0.1	Owner	3	2015-02-20 15:51:42.205162	2015-02-25 16:00:55.877788
7	adrus90@gmail.com	$2a$10$iX41rpy6AxWgkPm3i4t6hOTj0D1AMxEj2xjlRyerYU5NhsRMfBU5y	\N	\N	2015-03-27 17:17:41.091616	1	2015-03-27 17:17:41.097379	2015-03-27 17:17:41.097379	84.21.7.41	84.21.7.41	Guest	58	2015-03-27 17:15:34.338889	2015-03-27 17:17:41.098649
10	marcsi@v.hu	$2a$10$8z9rKUezutV/gjBsfZttueJPCxkoTZCCKhLPEh621LbA43uCppnV6	\N	\N	\N	1	2015-03-27 17:44:12.945679	2015-03-27 17:44:12.945679	84.21.7.41	84.21.7.41	Owner	6	2015-03-27 17:44:03.955469	2015-03-27 17:44:12.947699
11	szilan@v.hu	$2a$10$Ofq.a1vzKEA5lTFl7evKduTCuO2QgiRGA/pnE.iNvEHXUTtPY0yfu	\N	\N	\N	0	\N	\N	\N	\N	Owner	7	2015-03-27 17:47:23.291728	2015-03-27 17:47:23.291728
8	proba.jozska@lakimail.com	$2a$10$VaK25CfnOcSyMC3qq2xjDuluQG7WRYMCVaXaFSdUNHq.Uv2iWDCrC	\N	\N	\N	2	2015-03-27 17:55:52.736416	2015-03-27 17:33:30.319943	78.131.22.36	78.131.22.36	\N	\N	2015-03-27 17:33:30.311743	2015-03-27 17:55:52.738596
5	s3@v.hu	$2a$10$dHFSFDwncVkHmKMg9PAhCu1qDkyCzi0quKZsDMcc6E7TRp3UOMd0y	\N	\N	\N	7	2015-03-30 14:38:48.234534	2015-03-30 14:19:53.080704	127.0.0.1	127.0.0.1	Owner	4	2015-02-20 15:51:56.523254	2015-03-30 14:38:48.26188
3	s1@v.hu	$2a$10$V4Qqzvs3smm/hZT3ZQjn7ebDrtCHpZ6O4npjqZy1BsvyQKu5xaYBu	\N	\N	\N	17	2015-03-31 09:57:34.849236	2015-03-30 15:50:59.495673	127.0.0.1	127.0.0.1	Owner	2	2015-02-20 15:51:26.915447	2015-03-31 09:57:34.863477
6	a@v.hu	$2a$10$/H98kpx/jQYODdZhdMuBVOANz50GPThreBhT9mkYKQWLt0X/JUzTq	\N	\N	\N	9	2015-03-31 12:51:09.782404	2015-03-29 19:08:28.650219	127.0.0.1	127.0.0.1	Admin	1	2015-02-20 17:00:51.836	2015-03-31 12:51:09.784542
2	v@v.hu	$2a$10$fQFYzR7U9iAPmVvpY0IQF.2iZOBXjgquvN/hy.8SYh1CEBwoQaKK6	\N	\N	\N	21	2015-03-31 20:46:00.911522	2015-03-30 16:36:08.13708	127.0.0.1	127.0.0.1	Guest	1	2015-02-20 15:35:05.868171	2015-03-31 20:46:00.913297
\.


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: m3dw3
--

SELECT pg_catalog.setval('users_id_seq', 13, true);


--
-- Name: accommodation_equipments_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY accommodation_equipments
    ADD CONSTRAINT accommodation_equipments_pkey PRIMARY KEY (id);


--
-- Name: accommodations_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY accommodations
    ADD CONSTRAINT accommodations_pkey PRIMARY KEY (id);


--
-- Name: addresses_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY addresses
    ADD CONSTRAINT addresses_pkey PRIMARY KEY (id);


--
-- Name: admins_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY admins
    ADD CONSTRAINT admins_pkey PRIMARY KEY (id);


--
-- Name: bookings_guests_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY bookings_guests
    ADD CONSTRAINT bookings_guests_pkey PRIMARY KEY (id);


--
-- Name: bookings_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY bookings
    ADD CONSTRAINT bookings_pkey PRIMARY KEY (id);


--
-- Name: bookings_rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY bookings_rooms
    ADD CONSTRAINT bookings_rooms_pkey PRIMARY KEY (id);


--
-- Name: categries_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY categries
    ADD CONSTRAINT categries_pkey PRIMARY KEY (id);


--
-- Name: comments_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY comments
    ADD CONSTRAINT comments_pkey PRIMARY KEY (id);


--
-- Name: equipment_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY equipment
    ADD CONSTRAINT equipment_pkey PRIMARY KEY (id);


--
-- Name: equipment_rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY equipment_rooms
    ADD CONSTRAINT equipment_rooms_pkey PRIMARY KEY (id);


--
-- Name: guests_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY guests
    ADD CONSTRAINT guests_pkey PRIMARY KEY (id);


--
-- Name: owners_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY owners
    ADD CONSTRAINT owners_pkey PRIMARY KEY (id);


--
-- Name: prices_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY prices
    ADD CONSTRAINT prices_pkey PRIMARY KEY (id);


--
-- Name: properties_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY properties
    ADD CONSTRAINT properties_pkey PRIMARY KEY (id);


--
-- Name: rooms_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY rooms
    ADD CONSTRAINT rooms_pkey PRIMARY KEY (id);


--
-- Name: serviices_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY serviices
    ADD CONSTRAINT serviices_pkey PRIMARY KEY (id);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: m3dw3; Tablespace: 
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: index_users_on_email; Type: INDEX; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE UNIQUE INDEX index_users_on_email ON users USING btree (email);


--
-- Name: index_users_on_reset_password_token; Type: INDEX; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE UNIQUE INDEX index_users_on_reset_password_token ON users USING btree (reset_password_token);


--
-- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: m3dw3; Tablespace: 
--

CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);


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


--
-- PostgreSQL database dump complete
--