--
--


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



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

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

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

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

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

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


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

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


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

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;
1	LIM-ITX00000000000000b6e525015104	7c10fc9c2514b0ae937e4e350af02040		\N	10.20.129.1	\N		2020-04-23 16:11:50-05	2020-04-23 16:11:50-05	2020-04-23 16:11:50-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
2	LIM-ITX00000000000000f44805015104	aec6d4f21eadba1b806b74d3f407596c		\N	10.20.129.1	\N		2020-04-23 16:12:15-05	2020-04-23 16:12:15-05	2020-04-23 16:12:15-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
3	LIM-ITX0000000000000016dca7015104	b442a72abac933f943de1b101dd9693e		\N	10.20.129.1	\N		2020-04-23 16:13:32-05	2020-04-23 16:13:32-05	2020-04-23 16:13:32-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
4	LIM-ITX00000000000000bff6f8015104	7ff238c2389a97025a130cd6e1d21d97		\N	10.20.129.1	\N		2020-04-23 16:13:58-05	2020-04-23 16:13:58-05	2020-04-23 16:13:58-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
5	LIM-ITX0000000000000098630c015104	c948e462f5759c710f39c23907f5184e		\N	10.20.129.1	\N		2020-04-23 16:14:54-05	2020-04-23 16:14:54-05	2020-04-23 16:14:54-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
6	LIM-ITX000000000000003b53b0015104	1360f18f736e4dde2811cd17d66146b2		\N	10.20.129.1	\N		2020-04-23 16:15:30-05	2020-04-23 16:15:30-05	2020-04-23 16:15:30-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
7	LIM-ITX000000000000002ad387015104	3ea73b7df091844f23bd3908c24123e6		\N	10.20.129.1	\N		2020-04-23 16:16:32-05	2020-04-23 16:16:32-05	2020-04-23 16:16:32-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
8	LIM-ITX0000000000000095b4e2015104	870c0c68ac63dbb927ea312333f2718c		\N	10.20.129.1	\N		2020-04-23 16:16:52-05	2020-04-23 16:16:52-05	2020-04-23 16:16:52-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
9	LIM-ITX00000000000000bae46c015104	490a47c0e2070d6582d69d0b07b31594		\N	10.20.129.1	\N		2020-04-23 16:17:37-05	2020-04-23 16:17:37-05	2020-04-23 16:17:37-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
10	LIM-ITX00000000000000948f9d015104	068dd3b02b95d9fa726dcbd34f1d5c4d		\N	10.20.129.1	\N		2020-04-23 16:18:57-05	2020-04-23 16:18:57-05	2020-04-23 16:18:57-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
11	LIM-ITX00000000000000462b8e015104	76fc184cfec18e42ca64bf565ddca396		\N	10.20.129.1	\N		2020-04-23 16:20:45-05	2020-04-23 16:20:45-05	2020-04-23 16:20:45-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
12	LIM-ITX00000000000000c4607b015104	1ce8765668022a0f24ebeaa255ee6947		\N	10.20.129.1	\N		2020-04-23 16:31:13-05	2020-04-23 16:31:13-05	2020-04-23 16:31:13-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
13	LIM-ITX00000000000000e9e69d015104	8b678c7f6ed89ed910523f078215108f		\N	190.108.83.113	\N		2020-04-23 16:50:22-05	2020-04-23 16:50:22-05	2020-04-23 16:50:22-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
14	LIM-ITX00000000000000aa59a5015104	16f8c6b9963b5fc63e291021220c24d8		\N	190.108.83.113	\N		2020-04-23 16:51:50-05	2020-04-23 16:51:50-05	2020-04-23 16:51:50-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
15	LIM-ITX00000000000000923a55015104	37d152ad7b56a9776fc13da77dbcdb18		\N	190.108.83.113	\N		2020-04-24 08:52:55-05	2020-04-24 08:52:55-05	2020-04-24 08:52:55-05	\N	\N			\N	0	0			User-Request			\N	\N	\N	\N	\N
\.


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

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


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

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


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

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


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

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: postgres
--

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: postgres
--

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


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

GRANT SELECT,INSERT,UPDATE ON TABLE public.radacct TO radius;


--
-- Name: SEQUENCE radacct_radacctid_seq; Type: ACL; Schema: public; Owner: postgres
--

GRANT SELECT,USAGE ON SEQUENCE public.radacct_radacctid_seq TO radius;


--
--

