CREATE TABLE working.soms_analyse
(
  prem text,
  addy CHARACTER VARYING(80),
  technician text,
  serviceorder text,
  geom geometry,
  "timestamp" TIMESTAMP WITHOUT TIME zone
)
WITH (
  OIDS=FALSE
);
ALTER TABLE working.soms_analyse OWNER TO postgres;

-- Index: working.idx_soms_analyse___btree___prem

-- DROP INDEX working.idx_soms_analyse___btree___prem;

CREATE INDEX idx_soms_analyse___btree___prem
  ON working.soms_analyse
  USING btree
  (prem);

-- Index: working.idx_soms_analyse___btree___serviceorder

-- DROP INDEX working.idx_soms_analyse___btree___serviceorder;

CREATE INDEX idx_soms_analyse___btree___serviceorder
  ON working.soms_analyse
  USING btree
  (serviceorder);

-- Index: working.idx_soms_analyse___btree___technician

-- DROP INDEX working.idx_soms_analyse___btree___technician;

CREATE INDEX idx_soms_analyse___btree___technician
  ON working.soms_analyse
  USING btree
  (technician);