...
Code Block |
---|
CREATE TABLE public.layer_styles ( id serial NOT NULL, f_table_catalog character varying, f_table_schema character varying, f_table_name character varying, f_geometry_column character varying, stylename character varying(30), styleqml xml, stylesld xml, useasdefault boolean, description text, "owner" character varying(30), ui xml, update_time timestamp without time zone DEFAULT now(), CONSTRAINT layer_styles_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE public.layer_styles OWNER TO "iShareDatasdw_owner"; GRANT ALL ON TABLE public.layer_styles TO "iShareDatasdw_owner"; GRANT SELECT, INSERT, DELETE, UPDATE ON TABLE public.layer_styles TO staff; GRANT SELECT, UPDATE ON SEQUENCE public.layer_styles_id_seq TO staff; |
...