Twee extra tabellen maken voor de light versie

[milovanderlinden]

WFS_tblLight, WFS_tblLightLOG, specs via Dennis

[milovanderlinden]

Doorgevoerd in de Brabant-Noord omgeving, dit is de SQL:

create table public."WFS_tblLight" 
(
  gid serial NOT NULL,
  "DBK_ID" integer,
  "NaamBeheerder" character varying,
  "Email" integer,
  "Telfoonnummer" character varying,
  "OmschrijvingWijziging" character varying,
  "DatumTijd" character varying,
  "BrandweerOefening" boolean,
  "Goedgekeurd" boolean,
  "Afgehandeld" boolean,
  "Web" boolean,
  "Licence_ID" integer,
  CONSTRAINT "WFS_tblLight_pkey" PRIMARY KEY (gid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "WFS_tblLight"
  OWNER TO postgres;
GRANT ALL ON TABLE "WFS_tblLight" TO postgres;
GRANT SELECT ON TABLE "WFS_tblLight" TO public;

create table public."WFS_tblLightLog" 
(
  gid serial NOT NULL,
  "DBK_ID" integer,
  "Omschrijving" character varying,
  "DatumTijd" character varying,
  "Licence_ID" integer,
  CONSTRAINT "WFS_tblLightLog_pkey" PRIMARY KEY (gid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "WFS_tblLightLog"
  OWNER TO postgres;
GRANT ALL ON TABLE "WFS_tblLightLog" TO postgres;
GRANT SELECT ON TABLE "WFS_tblLightLog" TO public;