Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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;

...