SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "non_communication" CASCADE;
BEGIN;
CREATE TABLE "non_communication"();
SELECT AddGeometryColumn('non_communication','geometrie',2972,'GEOMETRY',2);
CREATE INDEX "non_communication_geometrie_geom_idx" ON "non_communication" USING GIST ("geometrie");
ALTER TABLE "non_communication" ADD COLUMN "cleabs" VARCHAR(24);
ALTER TABLE "non_communication" ADD COLUMN "date_creation" timestamp with time zone;
ALTER TABLE "non_communication" ADD COLUMN "date_modification" timestamp with time zone;
ALTER TABLE "non_communication" ADD COLUMN "date_d_apparition" date;
ALTER TABLE "non_communication" ADD COLUMN "date_de_confirmation" date;
ALTER TABLE "non_communication" ADD COLUMN "lien_vers_troncon_entree" VARCHAR(24);
ALTER TABLE "non_communication" ADD COLUMN "liens_vers_troncon_sortie" VARCHAR;
COMMIT;
SET standard_conforming_strings = OFF;
BEGIN;
COPY "non_communication" ("geometrie", "cleabs", "date_creation", "date_modification", "date_d_apparition", "date_de_confirmation", "lien_vers_troncon_entree", "liens_vers_troncon_sortie") FROM STDIN;
01010000209C0B000000000000D0CC154166666666519F2041	NON_COMM0000002200277404	2019/01/07 15:00:23.632	\N	\N	\N	TRONROUT0000002012515040	TRONROUT0000002012515043
01010000209C0B000066666666E873154166666666A1552041	NON_COMM0000002200173959	2018/12/17 19:49:13.895	\N	\N	\N	TRONROUT0000001369983419	TRONROUT0000001369983156
01010000209C0B00009A999999CF93154166666666808D2041	NON_COMM0000001371317839	2011/11/21 14:45:02.531	\N	\N	\N	TRONROUT0000001369978265	TRONROUT0000001369979421
\.
END;
COMMIT;
