SET client_encoding = 'utf-8';
SET standard_conforming_strings = OFF;
DROP TABLE IF EXISTS "non_communication" CASCADE;
BEGIN;
CREATE TABLE "non_communication"();
SELECT AddGeometryColumn('non_communication','geometrie',2975,'POINT',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 CONSTRAINT "non_communication_cleabs_pkey" PRIMARY KEY ("cleabs");
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;
01010000209F0B00003333333353DB1641000000E0A13B5D41	NON_COMM0000002324044000	2022/12/06 09:03:36.811	\N	\N	\N	TRONROUT0000001400332737	TRONROUT0000001400332743
01010000209F0B00003333333353DB1641000000E0A13B5D41	NON_COMM0000002324043999	2022/12/06 09:03:36.811	\N	\N	\N	TRONROUT0000001400332743	TRONROUT0000001400332737
01010000209F0B00009A99999969FB1541CDCCCC0C9D4D5D41	NON_COMM0000002292205060	2022/08/05 16:00:51.640	\N	\N	\N	TRONROUT0000001400301960	TRONROUT0000001400301950
01010000209F0B00009A999999F7D51441CDCCCC6CC9245D41	NON_COMM0000002288013395	2022/06/20 10:31:49.227	\N	\N	\N	TRONROUT0000001400374375	TRONROUT0000001400374358
01010000209F0B00000000000024E61441333333333A255D41	NON_COMM0000002288013394	2022/06/20 10:31:49.227	\N	\N	\N	TRONROUT0000001400373236	TRONROUT0000001400373197
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;
