--
--



--
-- Name: uuid-ossp; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA public;


--
-- Name: EXTENSION "uuid-ossp"; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION "uuid-ossp" IS 'generate universally unique identifiers (UUIDs)';




--
-- Name: account_types; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.account_types (
    id bigint NOT NULL,
    name text NOT NULL,
    is_active character varying(1) NOT NULL
);


ALTER TABLE public.account_types OWNER TO postgres;

--
-- Name: account_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.account_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.account_types_id_seq OWNER TO postgres;

--
-- Name: account_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.account_types_id_seq OWNED BY public.account_types.id;


--
-- Name: brands; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.brands (
    id bigint NOT NULL,
    name text NOT NULL,
    is_deleted boolean NOT NULL
);


ALTER TABLE public.brands OWNER TO postgres;

--
-- Name: brands_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.brands_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brands_id_seq OWNER TO postgres;

--
-- Name: brands_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.brands_id_seq OWNED BY public.brands.id;


--
-- Name: campaigns; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.campaigns (
    id bigint NOT NULL,
    name text NOT NULL,
    start_date bigint NOT NULL,
    end_date bigint NOT NULL
);


ALTER TABLE public.campaigns OWNER TO postgres;

--
-- Name: campaigns_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.campaigns_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campaigns_id_seq OWNER TO postgres;

--
-- Name: campaigns_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.campaigns_id_seq OWNED BY public.campaigns.id;


--
-- Name: campaigns_to_plans; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.campaigns_to_plans (
    id bigint NOT NULL,
    campaigns_id bigint NOT NULL,
    plans_id bigint NOT NULL
);


ALTER TABLE public.campaigns_to_plans OWNER TO postgres;

--
-- Name: campaigns_to_plans_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.campaigns_to_plans_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.campaigns_to_plans_id_seq OWNER TO postgres;

--
-- Name: campaigns_to_plans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.campaigns_to_plans_id_seq OWNED BY public.campaigns_to_plans.id;


--
-- Name: combinations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.combinations (
    id bigint NOT NULL,
    filter_types_id bigint NOT NULL,
    filters_id bigint NOT NULL
);


ALTER TABLE public.combinations OWNER TO postgres;

--
-- Name: combinations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.combinations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.combinations_id_seq OWNER TO postgres;

--
-- Name: combinations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.combinations_id_seq OWNED BY public.combinations.id;


--
-- Name: devices; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.devices (
    id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    mac character varying(12) NOT NULL,
    is_deleted boolean NOT NULL,
    pon text,
    serie character varying(200),
    mac_wan character varying(12),
    created_at timestamp with time zone,
    updated_at timestamp with time zone,
    deleted_at timestamp with time zone,
    models_id bigint,
    subscribers_id character varying(20) NOT NULL
);


ALTER TABLE public.devices OWNER TO postgres;

--
-- Name: download_limits; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.download_limits (
    id bigint NOT NULL,
    code character varying(2) NOT NULL,
    value bigint NOT NULL,
    is_active character varying(1) NOT NULL
);


ALTER TABLE public.download_limits OWNER TO postgres;

--
-- Name: download_limits_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.download_limits_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.download_limits_id_seq OWNER TO postgres;

--
-- Name: download_limits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.download_limits_id_seq OWNED BY public.download_limits.id;


--
-- Name: filter_types; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.filter_types (
    id bigint NOT NULL,
    name text NOT NULL,
    is_active character varying(1) NOT NULL
);


ALTER TABLE public.filter_types OWNER TO postgres;

--
-- Name: filter_types_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.filter_types_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.filter_types_id_seq OWNER TO postgres;

--
-- Name: filter_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.filter_types_id_seq OWNED BY public.filter_types.id;


--
-- Name: filters; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.filters (
    id bigint NOT NULL,
    name text NOT NULL,
    is_deleted boolean NOT NULL
);


ALTER TABLE public.filters OWNER TO postgres;

--
-- Name: filters_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.filters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.filters_id_seq OWNER TO postgres;

--
-- Name: filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.filters_id_seq OWNED BY public.filters.id;


--
-- Name: menus; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.menus (
    id bigint NOT NULL,
    name text NOT NULL,
    icon text,
    menus_id bigint,
    alias character varying(50) NOT NULL,
    description text,
    is_leaf boolean,
    orden bigint
);


ALTER TABLE public.menus OWNER TO postgres;

--
-- Name: menus_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.menus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.menus_id_seq OWNER TO postgres;

--
-- Name: menus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.menus_id_seq OWNED BY public.menus.id;


--
-- Name: migration_versions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.migration_versions (
    version character varying(14) NOT NULL,
    executed_at timestamp(0) without time zone NOT NULL
);


ALTER TABLE public.migration_versions OWNER TO postgres;

--
-- Name: COLUMN migration_versions.executed_at; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON COLUMN public.migration_versions.executed_at IS '(DC2Type:datetime_immutable)';


--
-- Name: models; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.models (
    id bigint NOT NULL,
    name text NOT NULL,
    equation text NOT NULL,
    is_deleted boolean NOT NULL,
    brands_id bigint NOT NULL
);


ALTER TABLE public.models OWNER TO postgres;

--
-- Name: models_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.models_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.models_id_seq OWNER TO postgres;

--
-- Name: models_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.models_id_seq OWNED BY public.models.id;


--
-- Name: plans; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.plans (
    id bigint NOT NULL,
    code character varying(50) NOT NULL,
    name text NOT NULL,
    description text,
    valid_since bigint NOT NULL,
    valid_to bigint NOT NULL,
    duration bigint NOT NULL,
    allow_recharges character varying(1) NOT NULL,
    is_deleted boolean NOT NULL,
    duration_type character varying(20),
    download_limits_id bigint NOT NULL,
    speed_down bigint NOT NULL,
    speed_up bigint NOT NULL
);


ALTER TABLE public.plans OWNER TO postgres;

--
-- Name: plans_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.plans_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.plans_id_seq OWNER TO postgres;

--
-- Name: plans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.plans_id_seq OWNED BY public.plans.id;


--
-- Name: plans_to_filters; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.plans_to_filters (
    id bigint NOT NULL,
    filters_id bigint NOT NULL,
    plans_id bigint NOT NULL
);


ALTER TABLE public.plans_to_filters OWNER TO postgres;

--
-- Name: plans_to_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.plans_to_filters_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.plans_to_filters_id_seq OWNER TO postgres;

--
-- Name: plans_to_filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.plans_to_filters_id_seq OWNED BY public.plans_to_filters.id;


--
-- Name: profiles; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.profiles (
    id bigint NOT NULL,
    name text NOT NULL,
    description text
);


ALTER TABLE public.profiles OWNER TO postgres;

--
-- Name: profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.profiles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.profiles_id_seq OWNER TO postgres;

--
-- Name: profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.profiles_id_seq OWNED BY public.profiles.id;


--
-- Name: profiles_to_menus; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.profiles_to_menus (
    id bigint NOT NULL,
    menus_id bigint NOT NULL,
    profiles_id bigint NOT NULL
);


ALTER TABLE public.profiles_to_menus OWNER TO postgres;

--
-- Name: profiles_to_menus_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.profiles_to_menus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.profiles_to_menus_id_seq OWNER TO postgres;

--
-- Name: profiles_to_menus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.profiles_to_menus_id_seq OWNED BY public.profiles_to_menus.id;


--
-- Name: recharges; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.recharges (
    id uuid DEFAULT public.uuid_generate_v4() NOT NULL,
    is_finished character varying(1) NOT NULL,
    created_at timestamp with time zone,
    is_deleted boolean NOT NULL,
    deleted_at timestamp with time zone,
    start_date timestamp with time zone,
    end_date timestamp with time zone,
    devices_id uuid,
    plans_id bigint NOT NULL,
    subscribers_id character varying(20) NOT NULL
);


ALTER TABLE public.recharges OWNER TO postgres;

--
-- Name: speeds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.speeds (
    id bigint NOT NULL,
    code character varying(4) NOT NULL,
    value bigint NOT NULL,
    is_active character varying(1) NOT NULL
);


ALTER TABLE public.speeds OWNER TO postgres;

--
-- Name: speeds_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.speeds_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.speeds_id_seq OWNER TO postgres;

--
-- Name: speeds_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.speeds_id_seq OWNED BY public.speeds.id;


--
-- Name: subscribers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.subscribers (
    first_name text,
    last_name text,
    phone character varying(50),
    email character varying(100),
    type_ciu character varying(10),
    ciu character varying(20) NOT NULL,
    is_deleted boolean NOT NULL,
    account_types_id bigint NOT NULL
);


ALTER TABLE public.subscribers OWNER TO postgres;

--
-- Name: users_subscribers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users_subscribers (
    id uuid NOT NULL,
    users_id uuid,
    subscribers_id character varying(20)
);


ALTER TABLE public.users_subscribers OWNER TO postgres;

--
-- Name: users_to_profiles; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users_to_profiles (
    id bigint NOT NULL,
    profiles_id bigint NOT NULL,
    users_id uuid NOT NULL
);


ALTER TABLE public.users_to_profiles OWNER TO postgres;

--
-- Name: users_to_profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.users_to_profiles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_to_profiles_id_seq OWNER TO postgres;

--
-- Name: users_to_profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.users_to_profiles_id_seq OWNED BY public.users_to_profiles.id;


--
-- Name: account_types id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: brands id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: campaigns id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: campaigns_to_plans id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: combinations id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: download_limits id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: filter_types id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: filters id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: menus id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: models id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: plans id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: plans_to_filters id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: profiles id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: profiles_to_menus id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: speeds id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Name: users_to_profiles id; Type: DEFAULT; Schema: public; Owner: postgres
--

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


--
-- Data for Name: account_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.account_types (id, name, is_active) FROM stdin;
1	Pre - Pago	1
2	Post - Pago	1
3	Otro	1
4	Test	1
6	Test-t	1
5	Test-test	1
\.


--
-- Data for Name: brands; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.brands (id, name, is_deleted) FROM stdin;
1	HUAWEI	f
2	OPTICTIMES	f
3	Felix Miguel	t
4	Felix	t
11	LLL	f
10	H	f
7	LG	t
\.


--
-- Data for Name: campaigns; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.campaigns (id, name, start_date, end_date) FROM stdin;
\.


--
-- Data for Name: campaigns_to_plans; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.campaigns_to_plans (id, campaigns_id, plans_id) FROM stdin;
\.


--
-- Data for Name: combinations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.combinations (id, filter_types_id, filters_id) FROM stdin;
1	1	17
5	2	17
\.


--
-- Data for Name: devices; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.devices (id, mac, is_deleted, pon, serie, mac_wan, created_at, updated_at, deleted_at, models_id, subscribers_id) FROM stdin;
9d7b05d3-e6e0-4095-9553-4fb147f506ab	AABBCCDDFF22	t	ASDFGHÑLKJHG	11223344	AABBCCDDFF33	\N	\N	2018-06-27 10:54:44-05	1	123456789
cd891f38-fb56-419b-91e7-ee809f41dd5e	11AAEEFFCCBB	t	CDEXSWZAQ	qazwsxedc	11AAEEFFCCCC	\N	\N	2018-06-27 10:54:44-05	1	123456789
513e5f73-be63-4fcd-9438-2e3ee177a7c4	ABCDEF123456	f	2323	23213132	ABCDEF123467	\N	\N	\N	1	43433845
250c06ee-e338-419b-a68d-a7c0da28b83c	FFCCEEBB0000	f	QAZWSXEDCVFR	QWERTYPOIUY	FFCCEEBB0001	\N	\N	\N	1	123456
f78c437a-0ff9-4db5-8ca8-056baa20d80c	AAEE1122BB10	t	MNBV1234ÑLJ567823456	MNBV1234ÑLJ5678	AAEE1122BB11	2018-06-26 05:08:42-05	\N	2018-06-27 10:54:48-05	1	654987321
9297ad79-9d3b-4a84-8c11-1a1e09fbe4dc	345345345345	t	345345345	32534534	34534534534A	2018-06-26 08:19:43-05	\N	2018-06-27 10:54:39-05	2	12345678
0d840574-818e-4ccf-a8bf-81969d2f02ec	234234234234	t	32434234	23423423	234234234235	2018-06-26 08:23:02-05	\N	2018-06-27 10:54:39-05	1	12345678
f90d3f23-594a-4dd3-ae2d-9c0548ff7469	CCBBAA112233	t	OKMIJNUHB	qazwsxvfrcde	CCBBAA112234	2018-06-27 05:38:45-05	\N	2018-06-27 10:54:52-05	1	135792468
a788d225-362b-460b-a465-0dfc68ed91e2	00DDB3AAEEFF	t	OKMNBVGFRDAS465	EDCUHBRFVYGV	DDB3AAEF04	2018-06-27 06:26:02-05	\N	2018-06-27 07:23:26-05	2	246813579
2d82db37-3d2d-43ea-ac5e-b6f168c62c0a	11223344EEFF	t	DFHSRTHSRFTHST	ASXASDAEGFVA	11223344EF00	2018-06-27 07:00:10-05	\N	2018-06-27 07:23:26-05	1	246813579
684518cd-eb25-4598-ad2a-26f27f15bfda	22223344EEFF	t	DTHSFTHJSRTJ	DRSHASDRHNINL	22223344EF04	2018-06-27 07:01:34-05	\N	2018-06-27 07:23:26-05	2	246813579
c699175f-081a-454a-ab7d-feba4d5309a3	00DD4455EEFF	t	DSRHASWERYH	OJUBGSIYVBFLUS	DD4455EF00	2018-06-27 07:02:23-05	\N	2018-06-27 07:23:26-05	1	246813579
001a3b9b-1590-49f1-a81c-4b84604ee6ca	00113355EEFF	t	XSRGADRH	ADRGHFTHJSGDH	113355EF04	2018-06-27 07:06:39-05	\N	2018-06-27 07:23:26-05	2	246813579
402fec52-373d-4950-bb1d-1a12341ed008	00224466EEFF	t	DTYJUIRTYKI	SERGSRTH	224466EF00	2018-06-27 07:06:56-05	\N	2018-06-27 07:23:26-05	1	246813579
edff4ffa-5201-4bfd-9d8f-177494998461	CCBBAA112233	t	SEDGFLIHSA	QEÑOHJASEGÑNº	CCBBAA112238	2018-06-27 10:46:55-05	\N	2018-06-27 10:54:52-05	2	135792468
1d3b9fc6-21d0-4328-88ad-0e36fa4612cb	00112233EEFF	t	DRHRB5YRG	RFVTGBYHNUJM	00112233EF04	2018-06-27 10:49:29-05	\N	2018-06-27 10:54:39-05	2	12345678
b78a8876-f2f7-43a8-a482-ef0c43181c18	0011AABBEEFF	t	QAZOKMWSXIJN	QAZCDETGB	0011AABBEF00	2018-07-03 07:16:05-05	\N	2018-07-03 07:28:27-05	1	12345
f0ce92b8-fa63-4f42-af30-adb6c9144968	E00084A2CF48	f	E00084A2CF48w	isdfq	E00084A2CF49	2020-04-24 15:14:01-05	\N	\N	1	20518158741
fa1081fe-43db-4def-a74f-722f5f1caf1e	4857544343FB	t	4857544383243F	132av123casa	4857544343FC	2020-04-23 19:16:15-05	\N	2020-04-24 15:14:24-05	3	20518158741
74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	E00084A2CEC0	f	E00084A2CEC0rr	y654	E00084A2CEC1	2020-04-24 15:16:34-05	\N	\N	1	20518158741
811111bd-6eff-407f-b32a-658e4cd72996	01020303AABB	t	QWER1234	Q1W2E3R4T5Y6	01020303AABC	2018-06-28 07:57:47-05	\N	2020-04-27 19:18:09-05	1	987654321
ab4c4695-c74c-4828-9827-f2d80c63f604	AFC1234567B3	t	QWER1235	122334fd	AFC1234567B4	2020-04-15 13:59:02-05	\N	2020-04-27 19:18:09-05	1	987654321
c161eec3-551b-424c-ae69-dc509ff63a80	AFC1234567B1	t	QWER1235	122334fd	AFC1234567B2	2020-04-15 13:56:38-05	\N	2020-04-27 19:18:09-05	1	987654321
01f4570d-2082-4627-a0d8-c36f456e56bb	C4FF1F55773A	t	48575443FC0E469A	2150083099EGHA005737	C4FF1F55773B	2018-06-28 10:54:55-05	\N	2020-04-27 19:18:26-05	3	19660068
b2bc7faf-b3b8-4e24-a24a-6bebc1a67e82	AAAEEE111333	t	QWERTYPOIUY	11111AAAAA55555	AAAEEE111344	\N	\N	2020-04-27 19:18:44-05	1	1234567890
70aa260b-1881-44e5-adab-adfd5dfe84b1	00112233EEFF	t	EDCRFVTGB	QWERTYPOIUYT	00112233EF04	2018-06-27 10:56:53-05	\N	2020-04-27 19:18:44-05	2	1234567890
ababc6f7-66fb-4d46-9996-f311333fb3c9	00112233EEFA	t	fse	1232314	00112233EEFF	2020-04-17 10:54:09-05	\N	2020-04-27 19:18:44-05	5	1234567890
39311688-b9cb-407f-ba3a-b62ca5feb953	00112233EEFE	t	fse	1232314	00112233EF03	2020-04-17 10:46:47-05	\N	2020-04-27 19:18:44-05	5	1234567890
202cfcc3-c1ac-4ab6-bf32-71f0bd0878e5	123ABC123ABD	f	aasd	5445545	123ABC123ABE	2020-05-06 19:01:59-05	\N	\N	1	20518158741
31c28f5c-bf34-4885-9cba-52dfe89e5bf3	ABCD12344321	f	123	12314151	ABCD12344326	2020-05-13 10:54:47-05	\N	\N	5	011111113
6bd650d3-e4b4-4b5a-bf7a-2eb20aa4fd61	142352452324	f	dbt	4252	142352452329	2020-05-15 17:15:20-05	\N	\N	2	20518158741
6c1efb53-bf25-4d4e-a999-ee8a5f1c3bd2	252352352552	f	25	23425	252352352557	2020-05-15 17:19:02-05	\N	\N	2	20518158741
5c41ba56-23e4-4367-b217-c9769e3ac171	145151515151	f	1551	13	145151515156	2020-05-15 17:23:20-05	\N	\N	2	20518158741
f105eaa7-3d18-47c2-ac56-825262e9c513	145152772572	f	1551	13	145152772577	2020-05-15 17:24:05-05	\N	\N	2	20518158741
ae923a25-69dd-4aaf-800c-af913c7a89ca	145152772571	f	1551	13	145152772576	2020-05-15 17:24:18-05	\N	\N	2	20518158741
8c0f2cb3-d7a9-42f4-bac3-b3ed0644184e	145152772570	f	1551	13	145152772575	2020-05-15 17:26:15-05	\N	\N	2	20518158741
ee552fd9-1c39-41bf-a63a-6b602d10077e	121212121212	f	121313	12	121212121217	2020-05-15 17:29:18-05	\N	\N	2	20518158741
6fac8aac-430d-4229-8e62-c86f0b7399c2	121212123212	f	12313	12121212	121212123217	2020-05-15 17:36:09-05	\N	\N	2	20518158741
3b0e9aa3-e448-41d3-a496-6ccaf01c46c8	323232323232	f	24242	123	323232323233	2020-05-15 17:41:55-05	\N	\N	1	20518158741
4c3b4b7f-7319-4a3f-9341-9c77f3b82aa4	412412412212	f	42	12131312	412412412217	2020-05-15 17:45:06-05	\N	\N	2	20518158741
3d6c6362-0169-417d-ae7d-d5c61617c07a	AFC1234567B3	f	QWER1235	122334fd	AFC1234567B4	2020-05-15 17:47:19-05	\N	\N	1	20518158741
fef0aadb-12f9-430e-aaa3-4cba6c173ef0	AFC1234567B2	f	QWER1235	122334fd	AFC1234567B3	2020-05-15 17:49:26-05	\N	\N	1	20518158741
6691b37e-1526-424f-9196-8f361ae37ec1	AFC1234567B4	f	QWER1235	122334fd	AFC1234567B5	2020-05-15 17:50:18-05	\N	\N	1	20518158741
b4e380f6-3e64-4413-a6e6-23d5a330107b	AFC1234567B5	f	QWER1235	122334fd	AFC1234567B6	2020-05-15 17:54:12-05	\N	\N	1	20518158741
90a11ba9-fcd7-4beb-b5f8-43e591555ac1	424223423323	f	2423	242	424223423328	2020-05-15 17:55:13-05	\N	\N	2	20518158741
8c32dc31-a812-4582-9790-b65cd9b39008	424223423325	f	2423	242	42422342332A	2020-05-15 17:55:21-05	\N	\N	2	20518158741
4dd8a68b-91c1-45aa-83d6-9e08716e496e	424124124124	f	423	13	424124124129	2020-05-15 18:00:13-05	\N	\N	2	20518158741
97e919a4-bbb3-4a68-bb97-4c910e31364d	AFC1234567B6	f	QWER1235	122334fd	AFC1234567B7	2020-05-15 18:04:53-05	\N	\N	1	20518158741
17f9924d-3a42-4ea8-8796-205136cf789a	412131231232	f	31412	1	412131231237	2020-05-15 18:05:24-05	\N	\N	2	20518158741
19abd1ae-4a9a-49c8-82b9-7a2d8b23c1f1	523524252452	f	25245	524	523524252457	2020-05-15 18:06:20-05	\N	\N	2	20518158741
809c0c35-d7a8-4578-b787-4d377c0d0906	523425262452	f	525	53	523425262457	2020-05-15 18:08:32-05	\N	\N	2	20518158741
2d5706ab-fb8e-4adc-bc32-10de66e7404d	654345434456	f	2525	654	65434543445B	2020-05-15 18:09:32-05	\N	\N	2	20518158741
f76908f5-d497-48f3-89ba-9c16e2773029	754735436354	f	2525	5363	754735436359	2020-05-15 18:11:43-05	\N	\N	2	011111113
a9492be4-9653-4fae-acdb-d3408b2171e5	643787654235	f	2452	325242	64378765423A	2020-05-15 18:13:04-05	\N	\N	2	011111113
45c0af93-3914-411a-9b5f-d9932f85efa5	667646646464	f	3636	64	667646646469	2020-05-15 18:15:51-05	\N	\N	2	20518158741
cc790f49-ffdd-4afc-8fdb-2a3ef06deb24	667646646466	f	3636	64	66764664646B	2020-05-15 18:16:17-05	\N	\N	2	20518158741
d5521691-852d-4b52-ae11-52a22cab71a3	822875782772	f	252525	76276472	822875782777	2020-05-15 18:18:42-05	\N	\N	2	20518158741
b725fa6c-aa4c-48c4-8b83-3bb5be54561d	525245262646	f	62424	42525	52524526264B	2020-05-15 18:22:46-05	\N	\N	2	20518158741
b1d706d9-198f-4369-92eb-b3d96b08e1de	5252452626A6	f	62424	42525	5252452626AB	2020-05-15 18:25:46-05	\N	\N	2	20518158741
598fc337-6948-458d-8427-764e17780ed5	A42352D42352	f	424	wtwtwt	A42352D42357	2020-05-15 18:26:56-05	\N	\N	2	20518158741
3ecb4044-9dde-4ee8-8c42-395f3028a0d0	123121312A31	f	311313	1341	123121312A36	2020-05-15 18:29:25-05	\N	\N	2	011111116
9627f039-7dcd-41c0-b2de-45db2a124fc6	123121312A32	f	311313	1341	123121312A37	2020-05-15 18:29:49-05	\N	\N	2	011111116
9509a326-3ec5-48ef-8e2e-c9aeab27e803	123415123416	f	5	525225	12341512341B	2020-05-15 18:34:35-05	\N	\N	2	011111115
1b47c2d4-9dc5-4eaa-ab0b-8955d3bbc20e	171717171717	f	9	2	17171717171C	2020-05-15 19:21:58-05	\N	\N	2	20518158741
3a29a6fc-025b-4210-8ea0-5eed2fe4a741	171717171718	f	9	2	17171717171D	2020-05-15 19:22:31-05	\N	\N	2	20518158741
07da5068-90f5-4fcd-83fb-e594315a5bc1	245252525252	f	52	234	245252525257	2020-05-15 19:23:07-05	\N	\N	2	011111115
cde02777-1886-4f83-89fa-d4e8aa011801	535352442323	f	2342	142425	535352442328	2020-05-15 19:33:32-05	\N	\N	2	011111115
6128d15e-708a-45e9-b330-52a9a8511b4f	626633463AAA	f	2626	25525	626633463AAF	2020-05-15 19:36:04-05	\N	\N	2	011111115
68e47c16-1e9e-49f2-b232-eb3d4af0e71b	626633463AAB	f	2626	25525	626633463AB0	2020-05-15 19:38:18-05	\N	\N	2	011111115
5be60fc0-c5d5-4be6-a97a-4dabf7442853	242622342523	f	53	642	242622342528	2020-05-15 19:49:24-05	\N	\N	2	011111115
531148d6-79bf-4aae-8ace-4171d18fccf6	325233252525	f	4232	242	32523325252A	2020-05-15 19:52:31-05	\N	\N	2	20518158741
18f8f9f3-f5ed-4059-a0dd-3f3f5a3f2033	AFC1234567BC	f	QWER1235	122334fd	AFC1234567BD	2020-05-15 19:58:07-05	\N	\N	1	20518158741
caabeb0d-e09a-4bb0-a92b-48fa45b8188a	32523325252A	f	4232	242	32523325252F	2020-05-15 19:59:28-05	\N	\N	2	20518158741
d4713144-775a-416f-a344-9814ccb65fa7	65A345345223	f	523	5654	65A345345228	2020-05-15 20:01:58-05	\N	\N	2	011111115
94f05182-2cdd-47b9-b55e-0d2257dfe6c1	ACDF34124221	f	423	64	ACDF34124226	2020-05-15 20:02:56-05	\N	\N	2	011111115
79bf7f33-b275-4a54-b7bb-d830a3f6fb69	ABCDEF431241	f	4	3536	ABCDEF431246	2020-05-15 20:03:49-05	\N	\N	2	20518158741
91620d72-6208-4ddc-8e80-b7cfc2524038	342252252123	f	25	4	342252252128	2020-05-15 20:05:50-05	\N	\N	2	20518158741
552e2b4f-1f9d-44a7-be6c-d3f18ca90fbb	827758273452	f	s	wtw899	827758273457	2020-05-15 20:08:04-05	\N	\N	2	011111116
295bf56f-3740-47ea-b58e-4f88480b7b60	232123451234	f	35	eyey	232123451239	2020-05-15 20:08:48-05	\N	\N	2	20518158741
60520edc-d8ab-452e-b97a-3e30da36d4d6	524325562345	f	234	252	52432556234A	2020-05-15 20:09:30-05	\N	\N	2	20518158741
3ded2ea9-bb0a-43e4-be72-f6467807ccd7	717897831873	f	4	524	717897831878	2020-05-18 10:00:15-05	\N	\N	2	011111116
eac12b87-b9ed-4012-a1c9-f8176039a310	717897831876	f	4	524	71789783187B	2020-05-18 10:01:52-05	\N	\N	2	011111116
8fc75907-9a8c-4aa9-88b1-597d0448abcd	252222525252	f	2552	54653	252222525257	2020-05-18 11:25:20-05	\N	\N	2	20518158741
dc947418-110c-4952-8b89-04064f66798d	324242424244	f	25	3636	324242424249	2020-05-18 11:30:39-05	\N	\N	2	20518158741
197b54a2-c798-43b4-90d9-73eafa75b7cd	553232323233	f	424	wtwt	553232323238	2020-05-18 11:31:52-05	\N	\N	2	20518158741
ac96d56c-7096-47fa-8c74-5ab44f76ac7a	252525252525	f	2525	525	25252525252A	2020-05-18 11:34:07-05	\N	\N	2	011111113
b108456e-3d45-4187-ac7a-2e55c4f75dea	25252525252B	f	2525	525	252525252530	2020-05-18 11:34:52-05	\N	\N	2	011111113
5d42eaa5-aa8e-40db-89d7-b3eacb7ddc05	424242442424	f	42	2424	424242442429	2020-05-18 11:36:31-05	\N	\N	2	20518158741
6730cd49-522b-4763-a820-96982ae55268	424242442421	f	42	2424	424242442426	2020-05-18 11:45:49-05	\N	\N	2	20518158741
63b5d83d-c07c-4d15-a7c7-ba7b0e7f5b06	111111111111	f	213	wttw	111111111116	2020-05-18 11:50:37-05	\N	\N	2	20518158741
9005816b-415c-42dc-864e-a95b5e38efd0	AFC1234567B1	f	QWER1235	122334fd	AFC1234567B2	2020-05-18 11:52:04-05	\N	\N	1	20518158741
e590f54b-0b2f-4cd9-9fe7-37531483f89e	AFC1234567B0	f	QWER1235	122334fd	AFC1234567B1	2020-05-18 11:52:18-05	\N	\N	1	20518158741
491026ab-fcdc-464e-a8c3-3a4b5f3dfd19	AFC12345670A	f	QWER1235	122334fd	AFC12345670B	2020-05-18 11:56:10-05	\N	\N	1	20518158741
ccea8c10-5f78-4bfb-b1d4-63b2c583ff1d	111122212111	f	8725	wtwt	111122212116	2020-05-18 11:57:23-05	\N	\N	2	20518158741
f9ff8a35-6c9b-4edf-ae28-1198b35eb5dc	AFC123451111	f	QWER1235	122334fd	AFC123451112	2020-05-18 11:57:51-05	\N	\N	1	20518158741
463256a4-2220-417e-ba42-ecb2b607d629	111122212100	f	8725	wtwt	111122212105	2020-05-18 11:58:27-05	\N	\N	2	20518158741
34f6cecc-b1a2-43a2-9316-05a2d0a5a978	111122212101	f	QWER1235	122334fd	111122212102	2020-05-18 11:59:12-05	\N	\N	1	20518158741
e207525b-7165-448a-9561-9f36d5230795	111122212102	f	QWER1235	122334fd	111122212103	2020-05-18 12:00:07-05	\N	\N	1	20518158741
da592879-c8f3-4614-80a9-00f1e5e6271a	111122212222	f	QWER1235	122334fd	111122212223	2020-05-18 12:00:21-05	\N	\N	1	20518158741
37a12acf-51d3-40f9-90d1-4ffc73d9819b	111122212AAA	f	8725	wtwt	111122212AAF	2020-05-18 12:00:41-05	\N	\N	2	20518158741
a8f7bf44-69ea-48d6-ac41-83e7f9f82c9b	111122212BBB	f	QWER1235	122334fd	111122212BBC	2020-05-18 12:01:17-05	\N	\N	1	20518158741
e111cd4c-daff-4b75-9a2c-854472bf6686	111122212BBC	f	QWER1235	122334fd	111122212BBD	2020-05-18 12:01:34-05	\N	\N	1	20518158741
936e50c2-ca37-4889-a75f-4b6377a62b9a	111122212444	f	QWER1235	122334fd	111122212445	2020-05-18 12:04:19-05	\N	\N	1	20518158741
380dbcdf-37b1-4245-8af1-fc57371642da	111122212555	f	QWER1235	122334fd	111122212556	2020-05-18 12:06:59-05	\N	\N	1	20518158741
df59a7bb-2759-455f-9b06-58f3314f8e53	111122212551	f	QWER1235	122334fd	111122212552	2020-05-18 12:07:44-05	\N	\N	1	20518158741
019a0f5b-e0cf-40ad-8c1d-6dea24778634	111122212521	f	QWER1235	122334fd	111122212522	2020-05-18 12:15:48-05	\N	\N	1	20518158741
57d95032-4822-46ef-923a-472a80e08729	111122212520	f	QWER1235	122334fd	111122212521	2020-05-18 12:16:30-05	\N	\N	1	20518158741
32201158-f007-4c53-a8df-147192a1f988	111122212522	f	QWER1235	122334fd	111122212523	2020-05-18 12:17:30-05	\N	\N	1	20518158741
a48bea3d-97a1-48ef-bae9-adfd3d63e11d	123121123123	f	141	23424	123121123128	2020-05-18 12:17:55-05	\N	\N	2	20518158741
d1c4ebaf-6fea-448a-aebb-f0ded165152e	525252525255	f	52	25	52525252525A	2020-05-18 12:22:09-05	\N	\N	2	011111116
36248e51-349c-4a07-be88-ddc21ab1bfcb	422524231242	f	413	42	422524231247	2020-05-18 12:23:57-05	\N	\N	2	011111116
144507f5-6098-41af-b76c-ac0fcabe85b4	ADCBF1234567	f	hs	524	ADCBF123456C	2020-05-19 10:54:03-05	\N	\N	2	20518158741
c30cf17b-325f-4b14-8639-99ab91aee015	111122212500	f	QWER1235	122334fd	111122212501	2020-05-19 10:58:11-05	\N	\N	1	20518158741
\.


--
-- Data for Name: download_limits; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.download_limits (id, code, value, is_active) FROM stdin;
1	GB	3	1
3	GB	5	1
4	GB	10	1
10	GB	12	1
6	0 	0	0
5	GB	1	0
2	GB	4	0
\.


--
-- Data for Name: filter_types; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.filter_types (id, name, is_active) FROM stdin;
2	RS	1
3	GM	1
4	VIDEO	1
0	Sin Filtros	1
1	XXX	1
5	TE	0
\.


--
-- Data for Name: filters; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.filters (id, name, is_deleted) FROM stdin;
0	Sin Filtros	t
1	Streaming	f
2	Gaming	f
3	Redes Sociales	f
4	XXX	f
7	Pruebas de filtro 2	t
8	XXX RS	f
9	XXX GM	f
10	XXX VIDEO	f
11	RS GM	f
12	RS VIDEO	f
13	GM VIDEO	f
14	XXX RS GM	f
15	XXX GM STREAMING	f
16	RS GM STREAMING	f
17	XXX RS GM STREAMING	f
6	TEST_TEST	t
5	TEST	t
18	Martes-21	f
19	JUEVES-23	f
\.


--
-- Data for Name: menus; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.menus (id, name, icon, menus_id, alias, description, is_leaf, orden) FROM stdin;
1	Planes	fa fa-dashborard	\N	app_plan	Planes	f	2
2	Suscriptores	fa fa-dashborard	\N	app_subscriber	Suscriptores	f	1
3	Filtros	fa fa-dash-board	\N	app_filter	Filtros	f	3
4	Listar Planes		1	app_plan_list	Listar Planes	t	1
5	Crear Nuevos Planes		1	app_plan_add	Crear Nuevos Planes	t	1
6	Editar Planes		1	app_plan_update	Editar Planes	t	1
7	Eliminar Planes		1	app_plan_delete	Eliminar Planes	t	1
8	Listar Suscriptores		2	app_subscriber_list	Listar Suscriptores	t	1
9	Editar Suscriptores	\N	2	app_subscriber_update	Editar Suscriptores	t	1
10	Tipo de Cuenta		\N	app_account_type	Tipos de Cuenta	f	4
11	Tipo de Filtro		\N	app_filter_type	Tipos de Filtro	f	5
12	Límites de descarga		\N	download_limit	Límites de descarga	f	6
13	Velocidades		\N	app_speed	Velocidades	f	7
14	Marcas		\N	app_brand	Marcas	f	8
15	Modelos		\N	app_model	Modelos	f	9
16	Usuarios		\N	app_user	Usuarios	f	10
17	Roles		\N	app_profile	Roles	f	11
18	Crear Nuevos Suscriptores		2	app_subscriber_add	Crear Nuevos Suscriptores	t	1
19	Eliminar Suscriptores		2	app_subscriber_delete	Eliminar Suscriptores	t	1
20	Agregar Nuevos Dispositivos		2	app_subscriber_adddevices	Agregar Nuevos Dispositivos	t	1
21	Dar de baja a los Dispositivos		2	app_subscriber_deletedevices	Dar de baja a los Dispositivos	t	1
22	Listar Recargas		2	app_recharge_list	Listar recargas	t	1
23	Agregar Recargas		2	app_recharge_add	Agregar Recargas	t	1
24	Listar Filtros de Planes		1	app_plan_getplanfilters	Listar Filtros de Planes	t	1
25	Actualizar Filtros de Planes		1	app_plan_updateplanfilters	Actualizar Filtros de Planes	t	1
26	Listar Filtros		3	app_filter_list	Listar Filtros	t	1
27	Crear Nuevos Filtros		3	app_filter_add	Crear Nuevos Filtros	t	1
28	Editar Filtros		3	app_filter_update	Editar Filtros	t	1
29	Eliminar Filtros		3	app_filter_delete	Eliminar Filtros	t	1
30	Listar Combinaciones		3	app_filter_listcombinations	Listar Combinaciones de Filtro	t	1
31	Actualizar Combinaciones		3	app_filter_updatecombinations	Actualizar Combinaciones	t	1
32	Crear Nuevos Tipos de Cuentas		10	app_accounttype_add	Crear Nuevos Tipos de Cuentas	t	1
33	Actualizar Tipos de Cuentas		10	app_accounttype_update	Actualizar Tipos de Cuentas	t	1
34	Crear Nuevos Tipos de Filtro		11	app_filtertype_add	Crear Nuevos Tipos de Filtro	t	1
35	Editar Tipos de Filtros		11	app_filtertype_update	Editar Tipos de Filtros	t	1
36	Crear Nuevos Limites de Descargas		12	app_downloadlimit_add	Crear Nuevos Limites de Descargas	t	1
37	Editar Limites de Descargas		12	app_downloadlimit_update	Editar Limites de Descargas	t	1
38	Crear Nuevas Velocidades		13	app_speed_add	Crear Nuevas Velocidades	t	1
39	Editar Velocidades		13	app_speed_update	Editar Velocidades	t	1
40	Listar Marcas		14	app_brand_listAll	Listar Marcas	t	1
41	Crear Nuevos Marcas		14	app_brand_add	Crear Nuevos Marcas	t	1
42	Editar Marca		14	app_brand_update	Editar Marca	t	1
43	Eliminar Marca		14	app_brand_delete	Eliminar Marca	t	1
44	Listar Modelos		15	app_model_listAll	Listar Modelos	t	1
45	Crear Nuevos Modelos		15	app_model_add	Crear Nuevos Modelos	t	1
46	Editar Modelos		15	app_model_update	Editar Modelos	t	1
47	Eliminar Modelos		15	app_model_delete	Eliminar Modelos	t	1
48	Listar Usuarios		16	app_user_list	Listar Usuarios	t	1
49	Crear Nuevos Usuarios		16	app_user_add	Crear Nuevos Usuarios	t	1
50	Editar Usuarios		16	app_user_update	Editar Usuarios	t	1
51	Eliminar Usuarios		16	app_user_delete	Eliminar Usuarios	t	1
52	Listar Roles		17	app_profile_list	Listar Roles	t	1
53	Crear Nuevos Roles		17	app_profile_add	Crear Nuevos Roles	t	1
54	Editar Roles		17	app_profile_update	Editar Roles	t	1
55	Eliminar Roles		17	app_profile_delete	Eliminar Roles	t	1
56	Listar Dispositivos de Suscriptores		2	app_subscriber_listdevices	Listar Dispositivos de Suscriptores	t	1
57	Trazas del Sistema	fa fa-dashborard	\N	app_log	Trazas del Sistema	f	12
58	Listar Trazas del Sistema		57	app_log_index	Listar Trazas del Sistema	t	1
59	Eliminar Recargas		2	app_recharge_deleteRecharges	Eliminar Recargas	t	1
60	Sesiones	fa fa-dashboard	\N	app_session	Sesiones	f	4
61	Listar Sessiones	\N	60	app_session_activenow	Listar Sessiones	t	1
62	Cerrar Conexion		60	app_session_offconnection	Cerrar Conexion	t	1
63	Consumo por Suscriptor		2	app_subscriber_consumo	Consumo por Suscriptor	t	1
64	Pausar Servicios		2	app_subscriber_pauseService	Pausar Servicios	t	1
\.


--
-- Data for Name: migration_versions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.migration_versions (version, executed_at) FROM stdin;
20200430205211	2020-04-30 20:58:25
20200507235708	2020-05-08 00:00:10
\.


--
-- Data for Name: models; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.models (id, name, equation, is_deleted, brands_id) FROM stdin;
1	HG8245Q2	MAC+1	f	1
2	Generico	MAC+5	f	2
3	HG8245H	MAC+1	f	1
5	H1234H	MAC+5	f	10
6	H1234HHH	MAC+5	t	10
\.


--
-- Data for Name: plans; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.plans (id, code, name, description, valid_since, valid_to, duration, allow_recharges, is_deleted, duration_type, download_limits_id, speed_down, speed_up) FROM stdin;
1	PLAN01	Plan 01	Plan descripción editado	1527489814574	1525971600000	360	1	t	HOUR	1	4	4
6	1w50mpbs35d	Internet Wow 50 Mpbs	Plan mensual de  50 Mpbs	1585760400000	1648746000000	35	1	f	DAY	6	4	4
8	iw250mbps35d	Internet Wow 250 Mbps	Plan Mensual de  250 Mbps	1585760400000	1648746000000	35	1	f	DAY	6	32	32
10	1Mdegradado	Internet Limitado 1Mbps	Plan Básico Degradación 1Mbps	1585760400000	1648746000000	30	1	f	DAY	4	34	34
2	PLAN02	PLAN PRUEBA	DESCRIPCION ALGO IMPORTANTE	1587229200000	1588266000000	355484100	1	t	HOUR	1	1	1
3	PLAN03	PLAN TEST 15/04/2020	DESCRIPCION ALGO IMPORTANTE	1587229200000	1588266000000	355484100	1	t	HOUR	1	1	1
4	PLAN04	PLAN TEST 15/04/2020	DESCRIPCION ALGO IMPORTANTE	1587229200000	1588266000000	355484100	1	t	HOUR	1	1	1
9	iw500mbps35d	Internet Wow 500 Mbps	Plan Mensual de  500 Mbps	1585760400000	1648746000000	35	1	f	DAY	1	33	33
7	iw100mbps35d	Internet Wow 100 Mbps	Plan Mensual de 100 Mbps	1585760400000	1648746000000	35	1	f	DAY	4	10	11
5	iw300M35d	Internet Wow 300Mbps	Plan Mensual de  300 Mbps	1584896400000	1648054800000	35	1	f	DAY	10	1	1
11	2Mdegradado	Internet Limitado 2Mbps	Plan Básico Degradación 2Mbps	1585760400000	1648746000000	30	1	f	MONTH	4	1	13
\.


--
-- Data for Name: plans_to_filters; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.plans_to_filters (id, filters_id, plans_id) FROM stdin;
3	15	2
5	16	4
9	16	3
14	17	1
\.


--
-- Data for Name: profiles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.profiles (id, name, description) FROM stdin;
1	ROLE_ADMIN	Usuario Administrador del Sistema
2	ROLE_OPERARIO	El Operario del Sistema es el usuario que gestionara toda la información referente al almacen de dispositivos.
3	ROLE_VISOR	Visualiza la Información del sistema
4	ROLE_API	ACCESSO AL API
5	ROLE_SUSCRIPTOR	Usuario suscriptor del Sistema el cual puede observar sus datos de Navegación
\.


--
-- Data for Name: profiles_to_menus; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.profiles_to_menus (id, menus_id, profiles_id) FROM stdin;
307	1	3
308	4	3
309	2	3
310	8	3
311	22	3
312	56	3
313	3	3
314	26	3
315	30	3
316	10	3
317	40	3
318	44	3
319	48	3
337	1	2
338	4	2
339	2	2
340	8	2
341	9	2
342	18	2
343	22	2
344	23	2
345	20	2
346	21	2
347	56	2
1	1	1
2	4	1
3	5	1
4	6	1
5	7	1
6	24	1
7	25	1
8	2	1
9	8	1
10	9	1
11	18	1
12	19	1
13	20	1
14	21	1
15	22	1
16	23	1
17	56	1
18	59	1
19	63	1
20	64	1
21	3	1
22	26	1
23	27	1
24	28	1
25	29	1
26	30	1
27	31	1
28	10	1
29	32	1
30	33	1
31	11	1
32	34	1
33	35	1
34	12	1
35	36	1
36	37	1
37	13	1
38	38	1
39	39	1
40	14	1
41	40	1
42	41	1
43	42	1
44	43	1
45	15	1
46	44	1
47	45	1
48	46	1
49	47	1
50	16	1
51	48	1
52	49	1
53	50	1
54	51	1
55	17	1
56	52	1
57	53	1
58	54	1
59	55	1
60	57	1
61	58	1
62	60	1
63	61	1
64	62	1
\.


--
-- Data for Name: recharges; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.recharges (id, is_finished, created_at, is_deleted, deleted_at, start_date, end_date, devices_id, plans_id, subscribers_id) FROM stdin;
8454b760-bb4b-4eaf-9f53-68c28146e9fa	f	2020-03-30 05:17:48-05	f	\N	2020-03-29 19:00:00-05	2020-04-29 18:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	1	987654321
b294379f-7778-4e08-874d-06320f44db5d	f	2020-04-14 23:41:01-05	f	\N	2020-04-29 19:00:00-05	2020-05-29 18:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	1	987654321
6622facb-c5fa-4d19-86a4-eb9ac3f0306f	f	2020-04-14 23:43:38-05	f	\N	2020-05-29 19:00:00-05	2020-05-30 18:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	1	987654321
ac68d92c-7044-43f1-9626-953e63ad20bd	f	2020-04-14 18:50:06-05	f	\N	2020-04-18 00:00:00-05	42573-09-23 11:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
fe65e4cb-1f30-45ee-bfcf-1911b65afa77	f	2020-04-15 14:47:26-05	t	2020-04-15 10:01:26-05	2003-09-21 12:00:00-05	2019-12-03 03:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
f28680c4-0ff2-4930-b2f4-405369ce926b	f	2020-04-15 09:14:45-05	t	2020-04-15 10:02:09-05	2020-04-16 00:00:00-05	42573-09-21 11:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
5c3b9531-3303-43da-a9b1-e7264bbe65fd	f	2020-04-15 14:17:04-05	f	\N	2020-04-26 00:00:00-05	42573-10-01 11:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	4	987654321
6dd3fd82-c53b-49a2-9d95-e27df3bb05a1	f	2020-04-15 14:19:35-05	f	\N	2020-04-26 00:00:00-05	42573-10-01 11:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	4	987654321
1670f5b1-8a1b-49de-ab92-25c0cb595295	f	2020-04-15 19:21:42-05	f	\N	2003-09-22 12:00:00-05	2172-07-24 03:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
a1916d3b-91c5-4b5a-92cc-3f006344d8f6	f	2020-04-15 19:23:25-05	f	\N	2003-09-22 12:00:00-05	2172-07-24 03:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
ee252686-99af-410a-9be0-c1a6a3666968	f	2020-04-15 09:58:57-05	t	2020-04-15 14:25:02-05	2020-04-17 00:00:00-05	42573-09-22 11:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	2	987654321
d9d90edf-192e-482c-996f-46fcd2f25f0e	f	2020-04-15 09:59:12-05	t	2020-04-15 14:29:36-05	2020-04-19 00:00:00-05	2020-05-03 23:59:59-05	811111bd-6eff-407f-b32a-658e4cd72996	1	987654321
fa0e4e82-1be3-43df-a759-b9ffd2c69134	f	2020-04-24 15:17:24-05	t	2020-04-27 16:51:38-05	2020-04-24 00:00:00-05	2020-06-23 23:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	2	20518158741
8c9b5263-a2a8-4b32-9149-8028a2bf4d23	f	2020-04-27 16:52:05-05	f	\N	2020-04-27 00:00:00-05	2020-04-29 23:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	9	20518158741
240ba7a4-2782-49e6-898c-5e08b98ffc98	f	2020-04-24 15:15:21-05	t	2020-04-27 19:16:01-05	2020-04-24 00:00:00-05	42573-09-29 11:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
5516e367-f0b8-49e0-9060-b861a7aaad7a	f	2020-04-27 19:16:14-05	f	\N	2020-04-27 00:00:00-05	2020-04-29 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	9	20518158741
a47ab57b-2999-4a34-8f71-482db9a23180	f	2020-04-29 04:44:52-05	f	\N	2020-04-30 00:00:00-05	2020-05-02 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	9	20518158741
e96a35a6-67bc-48d4-b26f-21a0f90bd75d	f	2020-05-04 12:44:27-05	t	2020-05-04 17:44:57-05	2020-05-04 00:00:00-05	2020-06-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	9	20518158741
39b2dea6-8300-4dff-b199-38e666f8d259	f	2020-05-04 17:45:20-05	t	2020-05-04 17:58:42-05	2020-05-04 00:00:00-05	2020-05-04 01:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	11	20518158741
d96eae5e-5d4a-4d8d-a1f4-b6e9d86bb718	f	2020-05-04 17:58:56-05	t	2020-05-05 11:28:03-05	2020-05-04 00:00:00-05	2020-05-27 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	11	20518158741
658f7047-78e0-46b8-b842-0edfb8192e03	f	2020-05-05 11:28:22-05	f	\N	2020-05-05 00:00:00-05	2020-05-06 05:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	10	20518158741
06fccef3-4b01-4100-a648-361e913eace7	f	2020-05-04 17:43:53-05	t	2020-05-05 11:29:45-05	2020-04-30 00:00:00-05	2020-05-29 23:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	9	20518158741
a516dd48-2ead-41af-8496-99b4768adeed	f	2020-05-05 11:30:01-05	f	\N	2020-05-05 00:00:00-05	2020-05-06 10:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	6	20518158741
9458fa3e-6c18-41fa-bfcd-53dcee65d053	f	2020-05-06 12:16:23-05	f	\N	2020-05-06 00:00:00-05	2020-05-07 10:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	7	20518158741
f25eef73-1364-4cf5-9408-5f2b3ef333e8	f	2020-05-06 12:16:45-05	f	\N	2020-05-06 00:00:00-05	2020-05-07 10:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	6	20518158741
adb16861-d5ac-41f6-82b8-f865a374599f	f	2020-05-07 09:59:29-05	f	\N	2020-05-07 00:00:00-05	2020-05-11 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	8	20518158741
55394e9d-7a84-4ad6-a65b-4b20489972fc	f	2020-05-07 10:00:10-05	f	\N	2020-05-07 00:00:00-05	2020-05-11 23:59:59-05	74f0eef9-7b4a-4e45-8e7c-e8803b0f2c5e	7	20518158741
e02b8cb3-b748-44d1-b807-fecd51c1759e	f	2020-05-07 11:11:56-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	10	20518158741
9ca680d5-824c-45ad-8b1d-ff78309240e6	f	2020-05-07 11:16:15-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	11	20518158741
d9214bf1-0081-4801-9d3e-3e83ae348baa	f	2020-05-07 11:49:41-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	6	20518158741
dc4ff461-7482-42d7-8c95-c4a12ca17c43	f	2020-05-07 12:07:16-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	7	20518158741
78e074ea-963b-43ba-a46e-dac5b79de271	f	2020-05-07 12:33:36-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	8	20518158741
dba66e34-3c8e-41d5-8c28-71b6143a36a9	f	2020-05-07 13:08:16-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	5	20518158741
5b05da04-49a8-4bb6-bb47-6502a9f7bb82	f	2020-05-07 14:52:28-05	f	\N	2020-05-07 00:00:00-05	2020-05-07 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	9	20518158741
2dfcae54-91b2-4ba9-baef-f1af731a2f22	f	2020-05-13 11:38:12-05	f	\N	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
08a7feda-5fcd-4e0f-966a-652a889d20b5	f	2020-05-13 11:45:08-05	f	\N	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
c3d55911-fdc6-4348-b6a4-b8369c49c0db	f	2020-05-13 11:54:20-05	f	\N	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
8df66da6-2ce9-4851-a1f8-2e2049b6b897	f	2020-05-13 11:54:54-05	f	\N	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
f1476a42-5f62-481c-a2b7-4289e0d3eb79	f	2020-05-22 17:14:21-05	f	\N	2020-05-23 00:00:00-05	2020-07-22 23:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
c233d89b-291e-49b1-a831-55f08d797de3	f	2020-05-18 12:13:56-05	t	2020-05-20 14:31:23-05	2052-01-21 00:00:00-05	2052-02-01 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
be4bfc76-3cf4-4dae-ae7d-4d54ed0257bc	f	2020-05-13 11:54:33-05	t	2020-05-20 14:50:22-05	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
2fc36d1f-2e57-497a-b551-7d420f89e09b	f	2020-05-13 11:53:49-05	t	2020-05-20 15:02:32-05	2020-05-14 00:00:00-05	2020-05-25 23:59:59-05	f0ce92b8-fa63-4f42-af30-adb6c9144968	2	20518158741
27021856-b0ec-4714-85a9-8a334c4a9a0a	f	2020-05-22 16:55:05-05	f	\N	2020-06-27 00:00:00-05	2020-06-27 13:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
9717ec4b-fbf7-495c-a5f3-766b7d8cffdf	f	2020-05-22 16:55:33-05	f	\N	2020-06-27 00:00:00-05	2020-07-16 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
07b72d1e-63bc-43eb-b3d6-0d419ec29e75	f	2020-05-22 16:55:59-05	f	\N	2020-11-26 23:59:59-05	2020-11-26 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
b7dc4bab-023c-4c2d-82b6-357e257bd83e	f	2020-05-22 14:05:04-05	f	\N	2020-05-23 00:00:00-05	2020-11-26 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
1560e179-f658-4b26-ac23-3c86c67987aa	f	2020-05-22 17:05:08-05	f	\N	2020-05-24 00:00:00-05	2020-07-23 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	11	011111113
6ac14808-7446-43d8-8277-3b6045b272d3	f	2020-05-22 17:08:09-05	f	\N	2020-11-22 23:59:59-05	2020-11-22 23:59:59-05	b108456e-3d45-4187-ac7a-2e55c4f75dea	9	011111113
52ee4024-641d-44b5-802a-e6e1a8309b37	f	2020-05-22 17:06:10-05	f	\N	2020-05-23 00:00:00-05	2020-11-22 23:59:59-05	b108456e-3d45-4187-ac7a-2e55c4f75dea	9	011111113
efe82a8f-19e9-44f3-8270-2287f373903d	f	2020-05-22 20:30:54-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
6eac5a6f-7702-4807-b994-ff9f0710f8a8	f	2020-05-22 20:32:59-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
3500c64e-c106-4c55-9952-96eeabad169a	f	2020-05-22 20:33:27-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
994051e7-10a3-4d1a-a4f3-bf789e36f8e8	f	2020-05-22 20:41:51-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
64d50c0c-9514-497f-b347-516781f9e2f4	f	2020-05-22 19:44:32-05	f	\N	2020-05-23 00:00:00-05	2020-06-21 23:59:59-05	a9492be4-9653-4fae-acdb-d3408b2171e5	6	011111113
e3d27cbb-93c4-436d-a6d9-af3b1cc3eb99	f	2020-05-22 20:44:38-05	f	\N	2020-06-22 00:00:00-05	2020-06-22 04:59:59-05	a9492be4-9653-4fae-acdb-d3408b2171e5	6	011111113
cef808a6-9b49-4a0b-ad83-0df1929b5af3	f	2020-05-22 20:44:58-05	f	\N	2020-06-22 05:00:00-05	2020-06-22 09:59:59-05	a9492be4-9653-4fae-acdb-d3408b2171e5	6	011111113
9b63c7f4-4090-4457-b946-9f90290b8520	f	2020-05-22 20:45:18-05	f	\N	2020-06-22 05:00:00-05	2020-06-22 11:59:59-05	a9492be4-9653-4fae-acdb-d3408b2171e5	6	011111113
94b88439-e4b9-4a2b-b8d9-739dcf2dc539	f	2020-05-22 20:48:06-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
831759c3-f858-4f45-9340-87ffa772f122	f	2020-05-22 20:48:22-05	f	\N	2020-07-23 00:00:00-05	2020-07-23 11:59:59-05	ac96d56c-7096-47fa-8c74-5ab44f76ac7a	5	011111113
8278f3cf-5ae1-48fa-9666-dab601d92285	f	2020-05-22 20:48:42-05	f	\N	2020-06-22 05:00:00-05	2020-06-22 09:59:59-05	a9492be4-9653-4fae-acdb-d3408b2171e5	6	011111113
68d28b22-501a-4ef2-b530-037612909a62	f	2020-05-25 08:58:56-05	f	\N	2020-11-27 00:00:00-05	2020-12-08 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
bc037481-7f1d-464a-bfa9-7ac650189135	f	2020-05-25 09:02:21-05	f	\N	2020-11-27 00:00:00-05	2020-11-27 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
9a7bbb29-1400-4054-9688-727d0c9c768e	f	2020-05-25 09:02:33-05	f	\N	2020-11-28 00:00:00-05	2020-12-02 23:59:59-05	f76908f5-d497-48f3-89ba-9c16e2773029	9	011111113
f5d89e4d-b483-4f50-a59d-19ac6e0deaf8	f	2020-05-25 08:21:42-05	f	\N	2020-05-26 00:00:00-05	2020-06-09 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
cbac7fbb-eea7-4499-9918-0dcaceeecaed	f	2020-05-25 09:22:22-05	f	\N	2020-06-10 00:00:00-05	2020-06-10 01:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
63308a50-dadd-4286-809e-a053a42d2f85	f	2020-05-25 09:22:49-05	f	\N	2020-06-10 00:00:00-05	2020-06-24 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
6225db59-7fd8-4943-894b-c3e28c8a961b	f	2020-05-25 09:23:24-05	f	\N	2020-06-10 00:00:00-05	2020-06-24 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
4028fef4-4436-44c0-a995-bd606689d9cf	f	2020-05-25 08:24:02-05	f	\N	2020-06-01 00:00:00-05	2020-06-05 23:59:59-05	d1c4ebaf-6fea-448a-aebb-f0ded165152e	11	011111116
4225ed64-3d24-4a18-9d15-f8ac1b8c63a3	f	2020-05-25 09:24:11-05	f	\N	2020-06-06 00:00:00-05	2020-06-10 23:59:59-05	d1c4ebaf-6fea-448a-aebb-f0ded165152e	11	011111116
226c85c2-0906-47d0-b4ba-62343bbcd994	f	2020-05-25 09:24:31-05	f	\N	2020-06-11 00:00:00-05	2020-06-15 23:59:59-05	d1c4ebaf-6fea-448a-aebb-f0ded165152e	11	011111116
c88a0a6a-df1b-4a63-8e28-7e5ef140233b	f	2020-05-25 09:30:49-05	f	\N	2020-06-10 00:00:00-05	2020-06-14 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
f943042a-fe5c-4cec-a2ce-28d6b91c6f59	f	2020-05-25 09:30:58-05	f	\N	2020-06-10 00:00:00-05	2020-06-14 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
822d79bb-c632-4336-9e06-777795969dbf	f	2020-05-25 09:41:14-05	f	\N	2020-06-15 00:00:00-05	2020-11-14 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
79c31373-8ff2-4bb9-b2ea-1efb1db5c0a2	f	2020-05-25 09:41:27-05	f	\N	2020-06-15 00:00:00-05	2024-06-14 23:59:59-05	eac12b87-b9ed-4012-a1c9-f8176039a310	5	011111116
825c07e1-dc88-4ad5-bff6-0cad0e96ae86	f	2020-05-25 09:21:06-05	f	\N	2020-05-26 00:00:00-05	2020-05-30 23:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
e366113a-85ea-4cdd-8250-5e0d66657de5	f	2020-05-25 11:05:28-05	f	\N	2020-07-05 23:59:59-05	2020-07-05 23:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
4346bbfa-c9f0-4186-ab89-d54528351109	f	2020-05-25 15:09:13-05	t	2020-05-25 16:04:22-05	2020-07-06 00:00:00-05	2020-07-08 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
4276eb94-0723-4219-a091-91bf47d37c37	f	2020-05-25 11:07:32-05	f	\N	2020-06-04 23:59:59-05	2020-06-04 23:59:59-05	cde02777-1886-4f83-89fa-d4e8aa011801	5	011111115
27ee553d-4962-45d0-9741-4824221b256e	f	2020-05-25 14:54:29-05	t	2020-05-25 13:57:57-05	2020-06-26 00:00:00-05	2020-05-28 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
6b894f8a-b7b3-42c1-9d83-2d94aeee07f9	f	2020-05-25 11:08:49-05	f	\N	2020-06-09 23:59:59-05	2020-06-09 23:59:59-05	cde02777-1886-4f83-89fa-d4e8aa011801	5	011111115
9da8928b-b532-4f13-bf87-165eb4619a95	f	2020-05-25 11:06:52-05	f	\N	2020-05-26 00:00:00-05	2020-06-09 23:59:59-05	cde02777-1886-4f83-89fa-d4e8aa011801	5	011111115
5a305555-c21a-4b2f-abbb-30e7c0b24d30	f	2020-05-25 11:16:19-05	f	\N	2020-07-10 23:59:59-05	2020-07-10 23:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
bc18ab38-a36b-41be-89b3-34b5fb55fac8	f	2020-05-25 11:28:50-05	f	\N	2020-07-15 23:59:59-05	2020-07-15 23:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
29c97644-3061-4b30-967b-d7cdd393ddfc	f	2020-05-25 11:29:58-05	f	\N	2020-07-21 04:59:59-05	2020-07-21 04:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
29e76f72-ee11-4d02-a589-24d6e38b6f84	f	2020-05-25 11:34:17-05	f	\N	2020-07-26 09:59:59-05	2020-07-26 09:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
e3881951-1b28-4a7f-b787-812a32c5d994	f	2020-05-25 11:37:05-05	f	\N	2020-07-31 14:59:59-05	2020-07-31 14:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
5febb3c1-e86f-4283-b10f-97329c6d8007	f	2020-05-25 11:44:25-05	f	\N	2020-08-05 19:59:59-05	2020-08-05 19:59:59-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
0a4515ec-95cb-4e25-a040-5021caeec1e5	f	2020-05-25 14:01:46-05	t	2020-05-25 14:03:13-05	2020-07-05 00:00:00-05	2020-07-08 04:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
a360ab10-112c-4078-9d19-ddba06046f4e	f	2020-05-25 11:49:52-05	f	\N	2020-06-11 22:17:00-05	2020-06-11 22:17:00-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
81233cce-48d9-4f2b-a329-e99cd67c6042	f	2020-05-25 11:58:34-05	f	\N	2020-06-18 00:00:00-05	2020-06-20 08:17:00-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
2c29e8cf-ef04-4d13-a0ec-c0a1d1d35233	f	2020-05-25 11:53:02-05	f	\N	2020-06-11 17:17:00-05	2020-06-15 00:00:00-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
8478ae2a-280b-48f7-a840-ad56f41df3ba	f	2020-05-25 11:59:46-05	f	\N	2020-05-26 00:00:00-05	2020-05-27 23:59:59-05	9509a326-3ec5-48ef-8e2e-c9aeab27e803	5	011111115
c0819518-36ba-4537-82bd-c0e89645aba9	f	2020-05-25 12:01:08-05	f	\N	2020-06-10 00:00:00-05	2020-08-05 04:59:59-05	94f05182-2cdd-47b9-b55e-0d2257dfe6c1	5	011111115
00e981b4-f771-4ce7-beea-6cbaf0efd707	f	2020-05-25 12:00:37-05	f	\N	2020-05-26 00:00:00-05	2020-05-31 00:00:00-05	94f05182-2cdd-47b9-b55e-0d2257dfe6c1	5	011111115
b54fa869-a573-4f44-8141-402a347e2204	f	2020-05-25 12:03:56-05	f	\N	2020-06-11 17:17:00-05	2020-06-11 22:17:00-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
c6845810-6fed-4db9-a34c-c4d0ea0e8d81	f	2020-05-25 10:22:52-05	f	\N	2020-05-31 00:00:00-05	2020-06-06 17:17:00-05	d4713144-775a-416f-a344-9814ccb65fa7	5	011111115
485daf66-86ea-46a4-922b-798310b38127	f	2020-05-25 12:12:12-05	t	2020-05-25 12:12:19-05	2020-05-26 00:00:00-05	2020-07-25 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
5c6f7085-5b47-4592-a95d-a9a4368cfa9b	f	2020-05-25 12:13:11-05	t	2020-05-25 12:13:15-05	2020-05-26 00:00:00-05	2020-08-25 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
d0f81287-c3ae-4086-9210-11bb1cb26183	f	2020-05-25 12:22:26-05	t	2020-05-25 12:22:29-05	2020-05-26 00:00:00-05	2020-07-25 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
9b15afa9-d938-4a2d-9608-2a8b4a405448	f	2020-05-25 16:07:26-05	t	2020-05-25 16:04:17-05	2020-07-06 00:00:00-05	2020-07-06 05:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
c53e06d6-0626-4ee9-9fe6-1f2b6295f7af	f	2020-05-25 16:07:12-05	t	2020-05-25 16:04:19-05	2020-07-06 00:00:00-05	2020-07-10 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
763898f2-1d52-4cea-9974-5973725476bb	f	2020-05-25 15:13:02-05	t	2020-05-25 16:04:21-05	2020-07-06 00:00:00-05	2020-07-10 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
fff2f396-84dc-427c-9384-d0307b6bc202	f	2020-05-25 15:04:15-05	t	2020-05-25 16:04:24-05	2020-07-01 00:00:00-05	2020-07-05 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
4b1c9569-202e-4e72-ad9b-1e7d44e22972	f	2020-05-25 15:03:23-05	t	2020-05-25 16:04:26-05	2020-07-01 00:00:00-05	2020-07-05 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
6152c228-4058-4fa2-a524-7ca174d0e291	f	2020-05-25 15:00:03-05	t	2020-05-25 16:04:27-05	2020-07-01 00:00:00-05	2020-07-03 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
64fb04c3-6cee-45b6-a7bf-1b247c3e786a	f	2020-05-25 14:59:34-05	t	2020-05-25 16:04:29-05	2020-06-26 00:00:00-05	2020-06-30 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
4369f41f-58e2-4576-b8db-8f0d69c17129	f	2020-05-25 13:56:18-05	t	2020-05-25 16:04:31-05	2020-05-29 00:00:00-05	2020-07-02 04:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
61014ea9-32e2-4418-b47d-b81253424fdf	f	2020-05-25 13:53:59-05	t	2020-05-25 16:04:32-05	2020-05-26 00:00:00-05	2020-06-25 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
2e8d775f-d0b1-4ba2-b334-ec19666d7e98	f	2020-05-25 16:05:52-05	t	2020-05-25 16:06:55-05	2020-05-30 00:00:00-05	2020-06-12 05:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
2c5ba8af-4d92-462b-b081-ec4e2b2f4953	f	2020-05-25 16:05:15-05	t	2020-05-25 16:06:56-05	2020-06-15 00:00:00-05	2020-07-05 04:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
eedad9e8-a521-49c8-9eae-ec29732f337e	f	2020-05-25 16:04:53-05	t	2020-05-25 16:06:58-05	2020-05-26 00:00:00-05	2020-05-28 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
dc7e3f1d-5838-43f7-9b61-fd3e2c35af84	f	2020-05-25 16:07:29-05	t	2020-05-25 16:46:56-05	2020-06-13 00:00:00-05	2020-06-15 18:18:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
f5438c4d-4299-4cee-97c1-4d1a160234f1	f	2020-05-25 16:08:17-05	t	2020-05-25 16:46:54-05	2020-06-05 00:00:00-05	2020-06-10 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
c2ab1a7d-20e1-4176-8430-48edfb1f9c86	f	2020-05-25 16:07:05-05	t	2020-05-25 16:47:07-05	2020-05-26 00:00:00-05	2020-06-02 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
dd59a65b-6fa6-4e4f-a9f4-af1feca1ee3e	f	2020-05-25 16:34:04-05	t	2020-05-25 16:46:51-05	2020-06-22 00:00:00-05	2020-06-24 15:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
0cb1ae5a-a268-4ba5-b016-cf5636a573c7	f	2020-05-25 16:39:41-05	t	2020-05-25 16:46:49-05	2020-06-25 18:18:00-05	2020-06-27 18:18:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
3954fd75-98f6-4556-97f7-6dcdb7b831b7	f	2020-05-25 16:44:37-05	t	2020-05-25 16:46:46-05	2020-07-12 18:18:00-05	2020-07-25 19:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
65a99e28-443b-4167-8a44-e6bba291719b	f	2020-05-25 16:43:05-05	t	2020-05-25 16:46:48-05	2020-07-07 18:18:00-05	2020-07-10 18:18:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
f01efa58-be7a-41e3-8afb-5683915efd4f	f	2020-05-25 16:23:37-05	t	2020-05-25 16:46:52-05	2020-06-11 00:00:00-05	2020-06-12 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	5	20518158741
2d9237c3-8900-4c00-abdc-617e8987d5db	f	2020-05-25 16:52:57-05	t	2020-05-25 16:55:38-05	2020-06-05 00:00:00-05	2020-07-04 09:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
be8b3f19-3803-489f-ba22-462c4bb6e0cc	f	2020-05-25 16:51:51-05	t	2020-05-25 16:55:40-05	2020-05-30 00:00:00-05	2020-06-03 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
b2a96009-38db-4dbe-a23b-628b7c907a41	f	2020-05-25 16:51:35-05	t	2020-05-25 16:55:42-05	2020-05-26 00:00:00-05	2020-05-28 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	7	20518158741
9220bffa-3cc4-4819-9c97-f1bd28e1243a	f	2020-05-25 16:55:53-05	t	2020-05-25 16:56:29-05	2020-05-26 00:00:00-05	2020-06-29 23:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	9	20518158741
88fa1bea-3efd-4cce-a752-b97aae908a60	f	2020-05-25 17:06:55-05	t	2020-05-25 17:07:12-05	2024-05-28 00:00:00-05	2026-11-30 09:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	11	20518158741
c520881e-186f-44b0-85ba-f9fa9906e1a0	f	2020-05-25 17:06:05-05	t	2020-05-25 17:07:14-05	2020-06-01 00:00:00-05	2020-05-28 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	11	20518158741
67bdbef1-8a9e-4cb6-a865-66511e682aff	f	2020-05-25 16:56:36-05	t	2020-05-25 17:07:16-05	2020-05-26 00:00:00-05	2020-05-28 00:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	11	20518158741
801ad655-3e46-4896-b737-972641b1b31f	f	2020-05-25 17:07:53-05	f	\N	2020-05-26 00:00:00-05	2020-05-28 19:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	8	20518158741
e514a840-a1eb-47e3-92de-257692c7b004	f	2020-05-25 17:09:09-05	f	\N	2020-05-30 19:00:00-05	2020-05-30 19:00:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	8	20518158741
a34136bf-a586-400c-a65e-1ca34aa99e79	f	2020-05-25 17:16:34-05	f	\N	2020-06-06 00:17:00-05	2020-07-05 14:59:59-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	8	20518158741
723cb2bf-842c-49bd-8b9e-4287862ad942	f	2020-05-25 17:09:27-05	f	\N	2020-06-01 19:00:00-05	2020-06-05 00:17:00-05	fef0aadb-12f9-430e-aaa3-4cba6c173ef0	8	20518158741
\.


--
-- Data for Name: speeds; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.speeds (id, code, value, is_active) FROM stdin;
4	Mbps	50	1
6	Mbps	1000	0
9	Mbps	5	1
10	Mbps	25	1
1	Mbps	10	1
7	Mbps	200	0
12	Mbps	125	0
28	Mbps	999	0
24	Mbps	190	0
22	Mbps	111	0
13	Mbps	130	1
11	Mbps	150	1
8	Mbps	300	1
5	Mbps	100	1
32	Mbps	250	1
33	Mbps	500	1
34	Mbps	1	1
35	Mbps	2	1
2	Mbps	20	1
3	Mbps	30	0
\.


--
-- Data for Name: subscribers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.subscribers (first_name, last_name, phone, email, type_ciu, ciu, is_deleted, account_types_id) FROM stdin;
\N	\N	\N	\N	RUC	111222333	t	1
\N	\N	\N	\N	RUC	123	t	1
\N	\N	\N	\N	RUC	1234	t	1
Angel	Perez	891765234	aperez@pe.pe	DNI	12345	t	1
Juan	Meza	123654987	jmeza@pe.pe	RUC	123456	t	1
\N	\N	\N	\N	RUC	1234567	t	1
\N	\N	\N	\N	RUC	123456700	t	1
Julio	Yanez	112233	jya@pe.pe	RUC	12345678	t	1
\N	\N	\N	\N	RUC	123456780	t	1
Carlos David	Moron Vegas	111222333	cmoron@pe.pe	RUC	123456789	t	1
\N	\N	\N	\N	DNI	123546789	t	1
Eduard	Colmenares	584732159	rcolme@pe.pe	RUC	135792468	t	1
Ramon	Barboza	951357741	rbarboza@pe.ve	RUC	246813579	t	2
\N	\N	\N	\N	DNI	43433845	t	1
Ruben Carlos	Villegas	321654987	rubven@pe.ve	DNI	654987321	t	1
Luis Vicente	Arevalo Rios	975864756	uno.dos@gmail.com	DNI	75168230	t	2
Empresa	Test	9994553588	info@test.com	RUC	20518158741	f	1
Jorge	Peralta	321654987	jperalta@pe.pe	CARNET	987654321	t	2
Ocho	Ocho	999999999	ocho@ocho.com	RUC	787878	t	1
Juan	Avila	12345	esd4556@gfsrt.co	DNI	19660068	t	1
Ocho	Ocho	999999999	ocho@ocho.com	RUC	777777	t	1
Pedro	Cabrera	912100123	pmcabrera@gmail.com	DNI	12323441	t	1
Raul	Sierra	123456789	rsierra@pe.pe	CARNET	1234567890	t	1
Luis	Arévalo Ríos	\N	\N	RUC	011111113	f	1
Victor	Hañari	\N	\N	RUC	011111115	f	1
Sebastian	Hañari!#$%&	\N	\N	RUC	011111116	f	1
\.


--
-- Data for Name: users_subscribers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users_subscribers (id, users_id, subscribers_id) FROM stdin;
\.


--
-- Data for Name: users_to_profiles; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users_to_profiles (id, profiles_id, users_id) FROM stdin;
1	1	f9f63da2-5305-440b-8bbd-2e52b637bc90
2	4	f9f63da2-5305-440b-8bbd-2e52b637bc90
7	1	b6bc0013-36c3-437a-8db5-6bbf8625b0f2
8	4	b6bc0013-36c3-437a-8db5-6bbf8625b0f2
9	1	fe465b37-3f0b-48fa-a82e-a35d78c5c885
10	4	fe465b37-3f0b-48fa-a82e-a35d78c5c885
15	1	f828b5a5-b0ed-418b-8914-2b3f562622fb
16	4	f828b5a5-b0ed-418b-8914-2b3f562622fb
\.



--
-- Name: account_types account_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.account_types
    ADD CONSTRAINT account_types_pkey PRIMARY KEY (id);


--
-- Name: brands brands_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.brands
    ADD CONSTRAINT brands_pkey PRIMARY KEY (id);


--
-- Name: campaigns campaigns_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.campaigns
    ADD CONSTRAINT campaigns_pkey PRIMARY KEY (id);


--
-- Name: campaigns_to_plans campaigns_to_plans_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.campaigns_to_plans
    ADD CONSTRAINT campaigns_to_plans_pkey PRIMARY KEY (id);


--
-- Name: combinations combinations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.combinations
    ADD CONSTRAINT combinations_pkey PRIMARY KEY (id);


--
-- Name: devices devices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devices
    ADD CONSTRAINT devices_pkey PRIMARY KEY (id);


--
-- Name: download_limits download_limits_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.download_limits
    ADD CONSTRAINT download_limits_pkey PRIMARY KEY (id);


--
-- Name: filter_types filter_types_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.filter_types
    ADD CONSTRAINT filter_types_pkey PRIMARY KEY (id);


--
-- Name: filters filters_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.filters
    ADD CONSTRAINT filters_pkey PRIMARY KEY (id);


--
-- Name: menus menus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_pkey PRIMARY KEY (id);


--
-- Name: migration_versions migration_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.migration_versions
    ADD CONSTRAINT migration_versions_pkey PRIMARY KEY (version);


--
-- Name: models models_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.models
    ADD CONSTRAINT models_pkey PRIMARY KEY (id);


--
-- Name: plans plans_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans
    ADD CONSTRAINT plans_pkey PRIMARY KEY (id);


--
-- Name: plans_to_filters plans_to_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans_to_filters
    ADD CONSTRAINT plans_to_filters_pkey PRIMARY KEY (id);


--
-- Name: profiles profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.profiles
    ADD CONSTRAINT profiles_pkey PRIMARY KEY (id);


--
-- Name: profiles_to_menus profiles_to_menus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.profiles_to_menus
    ADD CONSTRAINT profiles_to_menus_pkey PRIMARY KEY (id);


--
-- Name: recharges recharges_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recharges
    ADD CONSTRAINT recharges_pkey PRIMARY KEY (id);


--
-- Name: speeds speeds_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.speeds
    ADD CONSTRAINT speeds_pkey PRIMARY KEY (id);


--
-- Name: subscribers subscribers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscribers
    ADD CONSTRAINT subscribers_pkey PRIMARY KEY (ciu);


--
-- Name: users_subscribers users_suscribers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_subscribers
    ADD CONSTRAINT users_suscribers_pkey PRIMARY KEY (id);


--
-- Name: users_to_profiles users_to_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_to_profiles
    ADD CONSTRAINT users_to_profiles_pkey PRIMARY KEY (id);


--
-- Name: campaigns_to_plans_campaigns_id_07a3b649; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX campaigns_to_plans_campaigns_id_07a3b649 ON public.campaigns_to_plans USING btree (campaigns_id);


--
-- Name: campaigns_to_plans_plans_id_9c584c29; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX campaigns_to_plans_plans_id_9c584c29 ON public.campaigns_to_plans USING btree (plans_id);


--
-- Name: combinations_filter_types_id_8f35de4f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX combinations_filter_types_id_8f35de4f ON public.combinations USING btree (filter_types_id);


--
-- Name: combinations_filters_id_789344b1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX combinations_filters_id_789344b1 ON public.combinations USING btree (filters_id);


--
-- Name: devices_models_id_567aa6d9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX devices_models_id_567aa6d9 ON public.devices USING btree (models_id);


--
-- Name: devices_subscribers_id_69b8cf0d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX devices_subscribers_id_69b8cf0d ON public.devices USING btree (subscribers_id);


--
-- Name: devices_subscribers_id_69b8cf0d_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX devices_subscribers_id_69b8cf0d_like ON public.devices USING btree (subscribers_id varchar_pattern_ops);


--
-- Name: menus_menus_id_2c7c8bb7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX menus_menus_id_2c7c8bb7 ON public.menus USING btree (menus_id);


--
-- Name: models_brands_id_f0439c2d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX models_brands_id_f0439c2d ON public.models USING btree (brands_id);


--
-- Name: plans_download_limits_id_b884985e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX plans_download_limits_id_b884985e ON public.plans USING btree (download_limits_id);


--
-- Name: plans_speed_down_6dee07ae; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX plans_speed_down_6dee07ae ON public.plans USING btree (speed_down);


--
-- Name: plans_speed_up_74e75268; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX plans_speed_up_74e75268 ON public.plans USING btree (speed_up);


--
-- Name: plans_to_filters_filters_id_3c60415b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX plans_to_filters_filters_id_3c60415b ON public.plans_to_filters USING btree (filters_id);


--
-- Name: plans_to_filters_plans_id_777031f7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX plans_to_filters_plans_id_777031f7 ON public.plans_to_filters USING btree (plans_id);


--
-- Name: profiles_to_menus_menus_id_825c6c43; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX profiles_to_menus_menus_id_825c6c43 ON public.profiles_to_menus USING btree (menus_id);


--
-- Name: profiles_to_menus_profiles_id_87357a4e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX profiles_to_menus_profiles_id_87357a4e ON public.profiles_to_menus USING btree (profiles_id);


--
-- Name: recharges_devices_id_f32864d4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX recharges_devices_id_f32864d4 ON public.recharges USING btree (devices_id);


--
-- Name: recharges_plans_id_20b3d4f0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX recharges_plans_id_20b3d4f0 ON public.recharges USING btree (plans_id);


--
-- Name: recharges_subscribers_id_0e3d802e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX recharges_subscribers_id_0e3d802e ON public.recharges USING btree (subscribers_id);


--
-- Name: recharges_subscribers_id_0e3d802e_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX recharges_subscribers_id_0e3d802e_like ON public.recharges USING btree (subscribers_id varchar_pattern_ops);


--
-- Name: subscribers_account_types_id_c98b123d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscribers_account_types_id_c98b123d ON public.subscribers USING btree (account_types_id);


--
-- Name: subscribers_ciu_70813fa2_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX subscribers_ciu_70813fa2_like ON public.subscribers USING btree (ciu varchar_pattern_ops);


--
-- Name: uniq_53fce7ed5e237e06; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX uniq_53fce7ed5e237e06 ON public.account_types USING btree (name);


--
-- Name: users_to_profiles_profiles_id_0cf3ae29; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_to_profiles_profiles_id_0cf3ae29 ON public.users_to_profiles USING btree (profiles_id);


--
-- Name: users_to_profiles_users_id_bd9001a4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_to_profiles_users_id_bd9001a4 ON public.users_to_profiles USING btree (users_id);


--
-- Name: campaigns_to_plans campaigns_to_plans_campaigns_id_07a3b649_fk_campaigns_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.campaigns_to_plans
    ADD CONSTRAINT campaigns_to_plans_campaigns_id_07a3b649_fk_campaigns_id FOREIGN KEY (campaigns_id) REFERENCES public.campaigns(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: campaigns_to_plans campaigns_to_plans_plans_id_9c584c29_fk_plans_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.campaigns_to_plans
    ADD CONSTRAINT campaigns_to_plans_plans_id_9c584c29_fk_plans_id FOREIGN KEY (plans_id) REFERENCES public.plans(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: combinations combinations_filter_types_id_8f35de4f_fk_filter_types_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.combinations
    ADD CONSTRAINT combinations_filter_types_id_8f35de4f_fk_filter_types_id FOREIGN KEY (filter_types_id) REFERENCES public.filter_types(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: combinations combinations_filters_id_789344b1_fk_filters_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.combinations
    ADD CONSTRAINT combinations_filters_id_789344b1_fk_filters_id FOREIGN KEY (filters_id) REFERENCES public.filters(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: devices devices_models_id_567aa6d9_fk_models_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devices
    ADD CONSTRAINT devices_models_id_567aa6d9_fk_models_id FOREIGN KEY (models_id) REFERENCES public.models(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: devices devices_subscribers_id_69b8cf0d_fk_subscribers_ciu; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.devices
    ADD CONSTRAINT devices_subscribers_id_69b8cf0d_fk_subscribers_ciu FOREIGN KEY (subscribers_id) REFERENCES public.subscribers(ciu) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: menus menus_menus_id_2c7c8bb7_fk_menus_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_menus_id_2c7c8bb7_fk_menus_id FOREIGN KEY (menus_id) REFERENCES public.menus(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;


--
-- Name: models models_brands_id_f0439c2d_fk_brands_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.models
    ADD CONSTRAINT models_brands_id_f0439c2d_fk_brands_id FOREIGN KEY (brands_id) REFERENCES public.brands(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: plans plans_download_limits_id_b884985e_fk_download_limits_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans
    ADD CONSTRAINT plans_download_limits_id_b884985e_fk_download_limits_id FOREIGN KEY (download_limits_id) REFERENCES public.download_limits(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: plans plans_speed_down_6dee07ae_fk_speeds_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans
    ADD CONSTRAINT plans_speed_down_6dee07ae_fk_speeds_id FOREIGN KEY (speed_down) REFERENCES public.speeds(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: plans plans_speed_up_74e75268_fk_speeds_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans
    ADD CONSTRAINT plans_speed_up_74e75268_fk_speeds_id FOREIGN KEY (speed_up) REFERENCES public.speeds(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: plans_to_filters plans_to_filters_filters_id_3c60415b_fk_filters_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans_to_filters
    ADD CONSTRAINT plans_to_filters_filters_id_3c60415b_fk_filters_id FOREIGN KEY (filters_id) REFERENCES public.filters(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: plans_to_filters plans_to_filters_plans_id_777031f7_fk_plans_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.plans_to_filters
    ADD CONSTRAINT plans_to_filters_plans_id_777031f7_fk_plans_id FOREIGN KEY (plans_id) REFERENCES public.plans(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: profiles_to_menus profiles_to_menus_menus_id_825c6c43_fk_menus_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.profiles_to_menus
    ADD CONSTRAINT profiles_to_menus_menus_id_825c6c43_fk_menus_id FOREIGN KEY (menus_id) REFERENCES public.menus(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: profiles_to_menus profiles_to_menus_profiles_id_87357a4e_fk_profiles_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.profiles_to_menus
    ADD CONSTRAINT profiles_to_menus_profiles_id_87357a4e_fk_profiles_id FOREIGN KEY (profiles_id) REFERENCES public.profiles(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: recharges recharges_devices_id_f32864d4_fk_devices_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recharges
    ADD CONSTRAINT recharges_devices_id_f32864d4_fk_devices_id FOREIGN KEY (devices_id) REFERENCES public.devices(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: recharges recharges_plans_id_20b3d4f0_fk_plans_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recharges
    ADD CONSTRAINT recharges_plans_id_20b3d4f0_fk_plans_id FOREIGN KEY (plans_id) REFERENCES public.plans(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: recharges recharges_subscribers_id_0e3d802e_fk_subscribers_ciu; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recharges
    ADD CONSTRAINT recharges_subscribers_id_0e3d802e_fk_subscribers_ciu FOREIGN KEY (subscribers_id) REFERENCES public.subscribers(ciu) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: subscribers subscribers_account_types_id_c98b123d_fk_account_types_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.subscribers
    ADD CONSTRAINT subscribers_account_types_id_c98b123d_fk_account_types_id FOREIGN KEY (account_types_id) REFERENCES public.account_types(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_subscribers users_subscribers_subscribers_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_subscribers
    ADD CONSTRAINT users_subscribers_subscribers_id_fkey FOREIGN KEY (subscribers_id) REFERENCES public.subscribers(ciu) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: users_subscribers users_subscribers_users_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_subscribers
    ADD CONSTRAINT users_subscribers_users_id_fkey FOREIGN KEY (users_id) REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: users_to_profiles users_to_profiles_profiles_id_0cf3ae29_fk_profiles_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_to_profiles
    ADD CONSTRAINT users_to_profiles_profiles_id_0cf3ae29_fk_profiles_id FOREIGN KEY (profiles_id) REFERENCES public.profiles(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_to_profiles users_to_profiles_users_id_bd9001a4_fk_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_to_profiles
    ADD CONSTRAINT users_to_profiles_users_id_bd9001a4_fk_users_id FOREIGN KEY (users_id) REFERENCES public.users(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: TABLE account_types; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.account_types TO radman;


--
-- Name: TABLE brands; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.brands TO radman;


--
-- Name: TABLE campaigns; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.campaigns TO radman;


--
-- Name: TABLE campaigns_to_plans; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.campaigns_to_plans TO radman;


--
-- Name: TABLE combinations; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.combinations TO radman;


--
-- Name: TABLE devices; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.devices TO radman;


--
-- Name: TABLE download_limits; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.download_limits TO radman;


--
-- Name: TABLE filter_types; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.filter_types TO radman;


--
-- Name: TABLE filters; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.filters TO radman;


--
-- Name: TABLE menus; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.menus TO radman;


--
-- Name: TABLE migration_versions; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.migration_versions TO radman;


--
-- Name: TABLE models; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.models TO radman;


--
-- Name: TABLE plans; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.plans TO radman;


--
-- Name: TABLE plans_to_filters; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.plans_to_filters TO radman;


--
-- Name: TABLE profiles; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.profiles TO radman;


--
-- Name: TABLE profiles_to_menus; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.profiles_to_menus TO radman;


--
-- Name: TABLE recharges; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.recharges TO radman;


--
-- Name: TABLE speeds; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.speeds TO radman;


--
-- Name: TABLE subscribers; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.subscribers TO radman;


--
-- Name: TABLE users; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.users TO radman;


--
-- Name: TABLE users_subscribers; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.users_subscribers TO radman;


--
-- Name: TABLE users_to_profiles; Type: ACL; Schema: public; Owner: postgres
--

GRANT ALL ON TABLE public.users_to_profiles TO radman;


--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--

ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public REVOKE ALL ON TABLES  FROM postgres;
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT ALL ON TABLES  TO radman;


--
--

