SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "non_communication" CASCADE;
BEGIN;
CREATE TABLE "non_communication"();
SELECT AddGeometryColumn('non_communication','geometrie',2975,'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;
01010000209F0B0000CDCCCCCC081D1541CDCCCCACC02A5D41	NON_COMM0000002204325187	2019/09/20 18:22:23.636	\N	\N	\N	TRONROUT0000001400361106	TRONROUT0000001400361101
01010000209F0B0000CDCCCCCC2C1F1541666666265C2A5D41	NON_COMM0000002204325128	2019/09/20 18:21:52.936	\N	\N	\N	TRONROUT0000001400362329	TRONROUT0000001400362369
01010000209F0B000033333333B5EE13416666666697505D41	NON_COMM0000002000107944	2016/09/27 11:38:28.873	\N	\N	\N	TRONROUT0000001400294759	TRONROUT0000001400294763
\.
END;
COMMIT;
