SQLize Online / PHPize Online  /  SQLtest Online

-- Table: public.ac_packet_list_mail -- DROP TABLE IF EXISTS public.ac_packet_list_mail; CREATE TABLE IF NOT EXISTS public.ac_packet_list_mail ( mail_id_ bigint, created timestamp without time zone, packet_list_id_ bigint, status character varying(12) COLLATE pg_catalog."default" ) WITH ( OIDS = FALSE ) TABLESPACE hddspace; ALTER TABLE IF EXISTS public.ac_packet_list_mail OWNER to postgres; GRANT SELECT, DELETE, UPDATE, INSERT ON TABLE public.ac_packet_list_mail TO deis; GRANT SELECT ON TABLE public.ac_packet_list_mail TO isp_viewer; GRANT ALL ON TABLE public.ac_packet_list_mail TO postgres; GRANT SELECT ON TABLE public.ac_packet_list_mail TO power_bi; GRANT UPDATE, SELECT, INSERT ON TABLE public.ac_packet_list_mail TO pusgui; GRANT SELECT ON TABLE public.ac_packet_list_mail TO toolpar_readonly; GRANT ALL ON TABLE public.ac_packet_list_mail TO toolpar_user; -- Index: ac_packet_list_mail_idx -- DROP INDEX IF EXISTS public.ac_packet_list_mail_idx; CREATE INDEX IF NOT EXISTS ac_packet_list_mail_idx ON public.ac_packet_list_mail USING btree (mail_id_ ASC NULLS LAST, packet_list_id_ ASC NULLS LAST) TABLESPACE pg_default; -- Index: ac_packet_list_mail_packet_list_ind -- DROP INDEX IF EXISTS public.ac_packet_list_mail_packet_list_ind; CREATE INDEX IF NOT EXISTS ac_packet_list_mail_packet_list_ind ON public.ac_packet_list_mail USING btree (packet_list_id_ ASC NULLS LAST) TABLESPACE pg_default; -- Index: ac_packet_templorary_ind