--
--


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: cod_cliente_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.cod_cliente_seq OWNER TO radius;



--
-- Name: clientes; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.clientes (
    cod_cliente integer DEFAULT nextval('public.cod_cliente_seq'::regclass) NOT NULL,
    nome character varying NOT NULL,
    email character varying NOT NULL,
    telefone character varying NOT NULL,
    login character varying NOT NULL,
    senha character varying NOT NULL,
    hora character varying NOT NULL,
    portal character varying
);


ALTER TABLE public.clientes OWNER TO radius;

--
-- Name: mikrotik; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.mikrotik (
    id integer NOT NULL,
    nome character varying,
    ip character varying,
    username character varying,
    password character varying,
    plataforma character varying,
    uptime character varying,
    users_online integer
);


ALTER TABLE public.mikrotik OWNER TO radius;

--
-- Name: cod_mikrotik_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.cod_mikrotik_seq OWNER TO radius;

--
-- Name: cod_mikrotik_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.cod_mikrotik_seq OWNED BY public.mikrotik.id;


--
-- Name: mikrotik_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.mikrotik_id_seq OWNER TO radius;

--
-- Name: mikrotik_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.mikrotik_id_seq OWNED BY public.mikrotik.id;


--
-- Name: nas; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.nas (
    id integer NOT NULL,
    nasname text NOT NULL,
    shortname text NOT NULL,
    type text DEFAULT 'other'::text NOT NULL,
    ports integer,
    secret text NOT NULL,
    server text,
    community text,
    description text
);


ALTER TABLE public.nas OWNER TO radius;

--
-- Name: nas_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.nas_id_seq OWNER TO radius;

--
-- Name: nas_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.nas_id_seq OWNED BY public.nas.id;


--
-- Name: radacct; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radacct (
    radacctid bigint NOT NULL,
    acctsessionid text NOT NULL,
    acctuniqueid text NOT NULL,
    username text,
    realm text,
    nasipaddress inet NOT NULL,
    nasportid text,
    nasporttype text,
    acctstarttime timestamp with time zone,
    acctupdatetime timestamp with time zone,
    acctstoptime timestamp with time zone,
    acctinterval bigint,
    acctsessiontime bigint,
    acctauthentic text,
    connectinfo_start text,
    connectinfo_stop text,
    acctinputoctets bigint,
    acctoutputoctets bigint,
    calledstationid text,
    callingstationid text,
    acctterminatecause text,
    servicetype text,
    framedprotocol text,
    framedipaddress inet,
    framedipv6address inet,
    framedipv6prefix inet,
    framedinterfaceid text,
    delegatedipv6prefix inet
);


ALTER TABLE public.radacct OWNER TO radius;

--
-- Name: radacct_radacctid_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radacct_radacctid_seq OWNER TO radius;

--
-- Name: radacct_radacctid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radacct_radacctid_seq OWNED BY public.radacct.radacctid;


--
-- Name: radcheck_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radcheck_id_seq OWNER TO radius;

--
-- Name: radcheck; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radcheck (
    id integer DEFAULT nextval('public.radcheck_id_seq'::regclass) NOT NULL,
    username text DEFAULT ''::text NOT NULL,
    attribute text DEFAULT ''::text NOT NULL,
    op character varying(2) DEFAULT '=='::character varying NOT NULL,
    value text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.radcheck OWNER TO radius;

--
-- Name: radgroupcheck; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radgroupcheck (
    id integer NOT NULL,
    groupname text DEFAULT ''::text NOT NULL,
    attribute text DEFAULT ''::text NOT NULL,
    op character varying(2) DEFAULT '=='::character varying NOT NULL,
    value text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.radgroupcheck OWNER TO radius;

--
-- Name: radgroupcheck_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radgroupcheck_id_seq OWNER TO radius;

--
-- Name: radgroupcheck_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radgroupcheck_id_seq OWNED BY public.radgroupcheck.id;


--
-- Name: radgroupreply; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radgroupreply (
    id integer NOT NULL,
    groupname text DEFAULT ''::text NOT NULL,
    attribute text DEFAULT ''::text NOT NULL,
    op character varying(2) DEFAULT '='::character varying NOT NULL,
    value text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.radgroupreply OWNER TO radius;

--
-- Name: radgroupreply_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radgroupreply_id_seq OWNER TO radius;

--
-- Name: radgroupreply_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radgroupreply_id_seq OWNED BY public.radgroupreply.id;


--
-- Name: radpostauth; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radpostauth (
    id bigint NOT NULL,
    username text NOT NULL,
    pass text,
    reply text,
    calledstationid text,
    callingstationid text,
    authdate timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.radpostauth OWNER TO radius;

--
-- Name: radpostauth_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radpostauth_id_seq OWNER TO radius;

--
-- Name: radpostauth_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radpostauth_id_seq OWNED BY public.radpostauth.id;


--
-- Name: radreply; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radreply (
    id integer NOT NULL,
    username text DEFAULT ''::text NOT NULL,
    attribute text DEFAULT ''::text NOT NULL,
    op character varying(2) DEFAULT '='::character varying NOT NULL,
    value text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.radreply OWNER TO radius;

--
-- Name: radreply_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radreply_id_seq OWNER TO radius;

--
-- Name: radreply_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radreply_id_seq OWNED BY public.radreply.id;


--
-- Name: radusergroup; Type: TABLE; Schema: public; Owner: radius
--

CREATE TABLE public.radusergroup (
    id integer NOT NULL,
    username text DEFAULT ''::text NOT NULL,
    groupname text DEFAULT ''::text NOT NULL,
    priority integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.radusergroup OWNER TO radius;

--
-- Name: radusergroup_id_seq; Type: SEQUENCE; Schema: public; Owner: radius
--

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


ALTER TABLE public.radusergroup_id_seq OWNER TO radius;

--
-- Name: radusergroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: radius
--

ALTER SEQUENCE public.radusergroup_id_seq OWNED BY public.radusergroup.id;


--
-- Name: mikrotik id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: nas id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: radacct radacctid; Type: DEFAULT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radacct ALTER COLUMN radacctid SET DEFAULT nextval('public.radacct_radacctid_seq'::regclass);


--
-- Name: radgroupcheck id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: radgroupreply id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: radpostauth id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: radreply id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Name: radusergroup id; Type: DEFAULT; Schema: public; Owner: radius
--

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


--
-- Data for Name: clientes; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.clientes (cod_cliente, nome, email, telefone, login, senha, hora, portal) FROM stdin;
15	OSNI	NADA@NADA.COM.BR	(35) 9.8452-3644	57899000	g6-int-ifX-erNET	19-07-2023 19:07	\N
16	OSNI CASA	NADA@NADA	(11) 1.1174-4444	743713	299911	19-07-2023 23:04	\N
17	TESTE MIKROTIK 	NADA@NADA	(66) 4.6464-6444	390585	407071	19-07-2023 23:08	\N
18	OSNI AGORA VAI	NADA@NADA.COM	(35) 9.9999-9999	406196	380270	19-07-2023 23:40	\N
19	OSNI PC	NADA@NADA	(13) 1.3211-3213	492611	796381	19-07-2023 23:42	\N
20	BLABLABAL	BLABAL@BLABLA	(45) 4.5454-5465	556085	823709	20-07-2023 00:01	MikroTik
21	BLABLABAL	BLABAL@BLABLA	(45) 4.5454-5465	900770	982539	20-07-2023 00:03	MikroTik
22	ADMIN	ADMIN@ADMIN	(21) 1.3212-1211	39860852	g6-int-sNo-erNET	20-07-2023 00:10	Ruckus
23	TESTE	NADA@NADA.COM	(35) 9.9999-9999	53154008	g6-int-gL0-erNET	20-07-2023 14:23	Ruckus
24	ANA HELOÍSA MACIEL CARDOSO 	ANAHELOISACARDOSO@GMAIL.COM	(35) 9.9871-9376	43347127	g6-int-sfW-erNET	20-07-2023 14:25	Ruckus
25	ADRIANA 	DRI.SJA@GMAIL.COM	(35) 9.8407-6564	84293467	g6-int-HQ9-erNET	20-07-2023 15:48	Ruckus
26	BRENDA 	NATACHABRENDA700@GMAIL.COM	(35) 9.9266-2193	59626757	g6-int-Spl-erNET	20-07-2023 16:20	Ruckus
27	TESTE	TESTE@OUTLOOK.COM	(11) 1.1111-1111	52624861	g6-int-EiV-erNET	20-07-2023 16:34	Ruckus
28	RAFA	STIFLERD57@GMAIL.COM	(35) 9.8894-9284	47482757	g6-int-y46-erNET	21-07-2023 17:42	Ruckus
29	RAFA 	STIFLERD57@GMAIL.COM	(35) 9.8894-9284	41975809	g6-int-Kjt-erNET	21-07-2023 17:57	Ruckus
\.


--
-- Data for Name: mikrotik; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.mikrotik (id, nome, ip, username, password, plataforma, uptime, users_online) FROM stdin;
6	OSNI CASA	177.104.209.254	admin	admin	RB433	5d20h52m58s	0
7	MikPraça	177.104.209.225	admin	tkr2029	hEX lite	10w23h3m	0
\.


--
-- Data for Name: nas; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.nas (id, nasname, shortname, type, ports, secret, server, community, description) FROM stdin;
1	177.104.209.254	OSNICASATESTE	other	\N	123456789	\N	\N	Teste em casa
10	201.159.154.239	Loja_G6	other	\N	123456789	\N	\N	\N
\.


--
-- Data for Name: radacct; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radacct (radacctid, acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid, nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctinterval, acctsessiontime, acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets, acctoutputoctets, calledstationid, callingstationid, acctterminatecause, servicetype, framedprotocol, framedipaddress, framedipv6address, framedipv6prefix, framedinterfaceid, delegatedipv6prefix) FROM stdin;
217	64b85e0e00000001	8fd8e9ddb5e0d9a400e7ec2b552c84d1	57899000	\N	10.1.0.1	00000001	Wireless-802.11	2023-07-19 22:07:56+00	2023-07-19 22:09:06+00	2023-07-19 22:09:06+00	\N	70				9355045	243988	2C-E6-CC-3A-8F-E0:TESTE HS	90-B6-22-16-98-05	Lost-Service			192.168.40.9	\N	\N	\N	\N
218	64b85f0200000001	c2c330f92c4826e151340c3b5422996a	57899000	\N	10.1.0.1	00000001	Wireless-802.11	2023-07-19 22:09:10+00	2023-07-19 22:09:22+00	2023-07-19 22:09:22+00	\N	12				5285	3200	2C-E6-CC-3A-8F-E0:TESTE HS	90-B6-22-16-98-05	Lost-Service			192.168.40.9	\N	\N	\N	\N
224	64b96d7e00000001	c7c4dec8598907f94f4383a677688a0b	53154008	\N	10.1.0.1	00000001	Wireless-802.11	2023-07-20 17:23:35+00	2023-07-20 19:24:36+00	2023-07-20 19:24:36+00	603	7261				46859959	2454918	2C-E6-CC-3A-8F-E0:TESTE HS	90-B6-22-16-98-05	Lost-Carrier			192.168.40.29	\N	\N	\N	\N
219	64b85f1200000001	43583fa5d040a8c926a27d10ba88fd8c	57899000	\N	10.1.0.1	00000001	Wireless-802.11	2023-07-19 22:10:29+00	2023-07-19 22:24:48+00	2023-07-19 22:24:48+00	601	859				59098731	20619873	2C-E6-CC-3A-8F-E0:TESTE HS	90-B6-22-16-98-05	Lost-Service			192.168.40.9	\N	\N	\N	\N
222	80c00002	cc32192732fe2bd3a5ae8f561f04b676	406196	\N	10.0.0.254	wlan2	Wireless-802.11	2023-07-20 02:40:19+00	2023-07-20 03:15:51+00	2023-07-20 03:15:51+00	60	2132				142636	427827	hotspot1	72-A8-B6-32-8C-D9	Lost-Service			10.97.1.254	\N	\N	\N	\N
231	64baf12900000003	f773d87e10ec5954a4e5faf5edde5947	41975809	\N	10.1.0.1	00000003	Wireless-802.11	2023-07-21 20:58:01+00	2023-07-21 20:58:01+00	\N	\N	0			\N	0	0	2C-E6-CC-3A-8F-E0:TESTE HS	8E-30-1A-AA-07-C3	\N			192.168.40.86	\N	\N	\N	\N
225	64b96dd700000004	2e11e8a5c20b20820a83ae5457029234	43347127	\N	10.1.0.1	00000004	Wireless-802.11	2023-07-20 17:25:42+00	2023-07-20 17:40:28+00	2023-07-20 17:40:28+00	603	886				87626367	3778526	2C-E6-CC-3A-8F-E0:TESTE HS	56-FB-23-7D-CB-60	Lost-Service			192.168.40.30	\N	\N	\N	\N
220	80c00000	602530941302501d41aabe5d0d352779	390585	\N	10.0.0.254	wlan2	Wireless-802.11	2023-07-20 02:08:12+00	2023-07-20 02:15:25+00	2023-07-20 02:15:25+00	60	433				55358	330984	hotspot1	72-A8-B6-32-8C-D9	Lost-Service			10.97.1.254	\N	\N	\N	\N
221	80c00001	b03c2e24b48decd9cc06db4f94cad570	390585	\N	10.0.0.254	wlan2	Wireless-802.11	2023-07-20 02:38:52+00	2023-07-20 02:39:38+00	2023-07-20 02:39:38+00	\N	46				55874	279212	hotspot1	72-A8-B6-32-8C-D9	Lost-Carrier			10.97.1.254	\N	\N	\N	\N
228	64b9895900000002	62732315b031cf43cc59ebeb181f5d1d	59626757	\N	10.1.0.1	00000002	Wireless-802.11	2023-07-20 19:23:06+00	2023-07-20 19:51:59+00	2023-07-20 19:51:59+00	603	1733				5449758	657727	2C-E6-CC-3A-8F-E0:TESTE HS	BA-87-E9-39-3F-FC	Lost-Service			192.168.40.20	\N	\N	\N	\N
226	64b9801900000003	2a998f61eede6a1343f53b5ec19fa1c1	84293467	\N	10.1.0.1	00000003	Wireless-802.11	2023-07-20 18:48:36+00	2023-07-20 18:54:58+00	2023-07-20 18:54:58+00	\N	382				4569510	781810	2C-E6-CC-3A-8F-E0:TESTE HS	C2-81-DC-14-23-03	Lost-Service			192.168.40.96	\N	\N	\N	\N
230	64b9905f00000002	937f299afd66035d5d293c77b3a0f780	59626757	\N	10.1.0.1	00000002	Wireless-802.11	2023-07-20 19:59:44+00	2023-07-20 20:23:59+00	2023-07-20 20:23:59+00	603	1455				1326799	208026	2C-E6-CC-3A-8F-E0:TESTE HS	BA-87-E9-39-3F-FC	Lost-Service			192.168.40.20	\N	\N	\N	\N
227	64b988d700000002	0fad8463ca81f8c41e1eb67ba0dfbe6e	59626757	\N	10.1.0.1	00000002	Wireless-802.11	2023-07-20 19:20:46+00	2023-07-20 19:22:01+00	2023-07-20 19:22:01+00	\N	75				239114	54529	2C-E6-CC-3A-8F-E0:TESTE HS	BA-87-E9-39-3F-FC	Lost-Service			192.168.40.20	\N	\N	\N	\N
223	80c00003	b1b9d5cdfd2a27ec8bdd551db70064c2	492611	\N	10.0.0.254	wlan2	Wireless-802.11	2023-07-20 02:42:54+00	2023-07-20 03:13:05+00	2023-07-20 03:13:05+00	61	1810				2062942	8450542	hotspot1	20-C1-9B-72-93-A9	Lost-Service			10.97.1.253	\N	\N	\N	\N
229	64b989f500000001	2c8866251f31ef68673547f3a2add1d5	52624861	\N	10.1.0.1	00000001	Wireless-802.11	2023-07-20 19:35:08+00	2023-07-20 20:54:59+00	2023-07-20 20:54:59+00	603	4791				77890188	3562827	2C-E6-CC-3A-8F-E0:TESTE HS	90-B6-22-16-98-05	Lost-Service			192.168.40.29	\N	\N	\N	\N
\.


--
-- Data for Name: radcheck; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radcheck (id, username, attribute, op, value) FROM stdin;
15	57899000	Cleartext-Password	:=	g6-int-ifX-erNET
16	743713	Cleartext-Password	:=	299911
17	390585	Cleartext-Password	:=	407071
18	406196	Cleartext-Password	:=	380270
19	492611	Cleartext-Password	:=	796381
20	556085	Cleartext-Password	:=	823709
21	900770	Cleartext-Password	:=	982539
22	39860852	Cleartext-Password	:=	g6-int-sNo-erNET
23	53154008	Cleartext-Password	:=	g6-int-gL0-erNET
24	43347127	Cleartext-Password	:=	g6-int-sfW-erNET
25	84293467	Cleartext-Password	:=	g6-int-HQ9-erNET
26	59626757	Cleartext-Password	:=	g6-int-Spl-erNET
27	52624861	Cleartext-Password	:=	g6-int-EiV-erNET
28	47482757	Cleartext-Password	:=	g6-int-y46-erNET
29	41975809	Cleartext-Password	:=	g6-int-Kjt-erNET
\.


--
-- Data for Name: radgroupcheck; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radgroupcheck (id, groupname, attribute, op, value) FROM stdin;
\.


--
-- Data for Name: radgroupreply; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radgroupreply (id, groupname, attribute, op, value) FROM stdin;
\.


--
-- Data for Name: radpostauth; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radpostauth (id, username, pass, reply, calledstationid, callingstationid, authdate) FROM stdin;
799	57899000	g6-int-ifX-erNET	Access-Accept	\N	\N	2023-07-19 19:07:56.533635+00
800	390585	407071	Access-Accept	\N	\N	2023-07-19 23:08:12.377529+00
801	390585	407071	Access-Accept	\N	\N	2023-07-19 23:38:51.998521+00
802	406196	380270	Access-Accept	\N	\N	2023-07-19 23:40:19.757594+00
803	492611	796381	Access-Accept	\N	\N	2023-07-19 23:42:54.632574+00
804	53154008	g6-int-gL0-erNET	Access-Accept	\N	\N	2023-07-20 14:23:34.590557+00
805	43347127	g6-int-sfW-erNET	Access-Accept	\N	\N	2023-07-20 14:25:41.640982+00
806	84293467	g6-int-HQ9-erNET	Access-Accept	\N	\N	2023-07-20 15:48:35.997323+00
807	59626757	g6-int-Spl-erNET	Access-Accept	\N	\N	2023-07-20 16:20:45.823375+00
808	52624861	g6-int-EiV-erNET	Access-Accept	\N	\N	2023-07-20 16:35:07.551785+00
809	41975809	g6-int-Kjt-erNET	Access-Accept	\N	\N	2023-07-21 17:58:00.46861+00
\.


--
-- Data for Name: radreply; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radreply (id, username, attribute, op, value) FROM stdin;
\.


--
-- Data for Name: radusergroup; Type: TABLE DATA; Schema: public; Owner: radius
--

COPY public.radusergroup (id, username, groupname, priority) FROM stdin;
\.


--
-- Name: cod_cliente_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.cod_cliente_seq', 29, true);


--
-- Name: cod_mikrotik_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

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


--
-- Name: mikrotik_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.mikrotik_id_seq', 7, true);


--
-- Name: nas_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.nas_id_seq', 11, true);


--
-- Name: radacct_radacctid_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.radacct_radacctid_seq', 231, true);


--
-- Name: radcheck_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.radcheck_id_seq', 29, true);


--
-- Name: radgroupcheck_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

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


--
-- Name: radgroupreply_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

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


--
-- Name: radpostauth_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

SELECT pg_catalog.setval('public.radpostauth_id_seq', 809, true);


--
-- Name: radreply_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

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


--
-- Name: radusergroup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: radius
--

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


--
-- Name: clientes clientes_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.clientes
    ADD CONSTRAINT clientes_pkey PRIMARY KEY (cod_cliente);


--
-- Name: mikrotik mikrotik_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.mikrotik
    ADD CONSTRAINT mikrotik_pkey PRIMARY KEY (id);


--
-- Name: nas nas_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.nas
    ADD CONSTRAINT nas_pkey PRIMARY KEY (id);


--
-- Name: radacct radacct_acctuniqueid_key; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radacct
    ADD CONSTRAINT radacct_acctuniqueid_key UNIQUE (acctuniqueid);


--
-- Name: radacct radacct_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radacct
    ADD CONSTRAINT radacct_pkey PRIMARY KEY (radacctid);


--
-- Name: radcheck radcheck_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radcheck
    ADD CONSTRAINT radcheck_pkey PRIMARY KEY (id);


--
-- Name: radgroupcheck radgroupcheck_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radgroupcheck
    ADD CONSTRAINT radgroupcheck_pkey PRIMARY KEY (id);


--
-- Name: radgroupreply radgroupreply_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radgroupreply
    ADD CONSTRAINT radgroupreply_pkey PRIMARY KEY (id);


--
-- Name: radpostauth radpostauth_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radpostauth
    ADD CONSTRAINT radpostauth_pkey PRIMARY KEY (id);


--
-- Name: radreply radreply_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radreply
    ADD CONSTRAINT radreply_pkey PRIMARY KEY (id);


--
-- Name: radusergroup radusergroup_pkey; Type: CONSTRAINT; Schema: public; Owner: radius
--

ALTER TABLE ONLY public.radusergroup
    ADD CONSTRAINT radusergroup_pkey PRIMARY KEY (id);


--
-- Name: nas_nasname; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX nas_nasname ON public.nas USING btree (nasname);


--
-- Name: radacct_active_session_idx; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radacct_active_session_idx ON public.radacct USING btree (acctuniqueid) WHERE (acctstoptime IS NULL);


--
-- Name: radacct_bulk_close; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radacct_bulk_close ON public.radacct USING btree (nasipaddress, acctstarttime) WHERE (acctstoptime IS NULL);


--
-- Name: radacct_start_user_idx; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radacct_start_user_idx ON public.radacct USING btree (acctstarttime, username);


--
-- Name: radcheck_username; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radcheck_username ON public.radcheck USING btree (username, attribute);


--
-- Name: radgroupcheck_groupname; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radgroupcheck_groupname ON public.radgroupcheck USING btree (groupname, attribute);


--
-- Name: radgroupreply_groupname; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radgroupreply_groupname ON public.radgroupreply USING btree (groupname, attribute);


--
-- Name: radreply_username; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radreply_username ON public.radreply USING btree (username, attribute);


--
-- Name: radusergroup_username; Type: INDEX; Schema: public; Owner: radius
--

CREATE INDEX radusergroup_username ON public.radusergroup USING btree (username);


--
--

