· 3 years ago · May 25, 2022, 08:50 PM
1-- Table: public.acesso
2
3-- DROP TABLE IF EXISTS public.acesso;
4
5CREATE TABLE IF NOT EXISTS public.acesso
6(
7 id_acesso bigserial NOT NULL,
8 xid bigint DEFAULT txid_current(),
9 statusapagado boolean DEFAULT false,
10 ip character varying(15) COLLATE pg_catalog."default",
11 datahoraacesso timestamp with time zone DEFAULT CURRENT_TIMESTAMP(0),
12 referer text COLLATE pg_catalog."default",
13 CONSTRAINT acesso_pkey PRIMARY KEY (id_acesso)
14)
15
16TABLESPACE pg_default;
17
18ALTER TABLE IF EXISTS public.acesso
19 OWNER to postgres;