--- /dev/null
+-- Ajout / mise à jour des colonnes geométrie sur les tables fourreau, cable, sous_tubage, artere et noeud
+
+ALTER TABLE artere DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'artere', 'geom', '2154', 'MULTILINESTRING', 2);
+CREATE INDEX artere_indgist ON artere USING GIST (geom GIST_GEOMETRY_OPS);
+
+ALTER TABLE fourreau DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'fourreau', 'geom', '2154', 'MULTILINESTRING', 2);
+CREATE INDEX fourreau_indgist ON fourreau USING GIST (geom GIST_GEOMETRY_OPS);
+
+ALTER TABLE cable DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'cable', 'geom', '2154', 'MULTILINESTRING', 2);
+CREATE INDEX cable_indgist ON cable USING GIST (geom GIST_GEOMETRY_OPS);
+
+ALTER TABLE sous_tubage DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'sous_tubage', 'geom', '2154', 'MULTILINESTRING', 2);
+CREATE INDEX sous_tubage_indgist ON sous_tubage USING GIST (geom GIST_GEOMETRY_OPS);
+
+ALTER TABLE noeud DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'noeud', 'geom', '2154', 'POINT', 2);
+CREATE INDEX noeud_indgist ON noeud USING GIST (geom GIST_GEOMETRY_OPS);
+
+ALTER TABLE tranchee DROP COLUMN geom;
+select AddGeometryColumn( 'public', 'tranchee', 'geom', '2154', 'MULTILINESTRING', 2);
+CREATE INDEX tranchee_indgist ON tranchee USING GIST (geom GIST_GEOMETRY_OPS);
+
+
+-- Remplissage de la table legende
+DELETE FROM legende;
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (1,'etat','0','non existant (projet)');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (2,'etat','1','très abîmé');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (3,'etat','2','abîmé');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (4,'etat','3','correct');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (5,'etat','4','bien');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (6,'etat','5','neuf');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (7,'occupation','0','non existant (projet)');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (8,'occupation','1','vide');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (9,'occupation','2','non vide');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (10,'occupation','3','saturé');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (11,'qualite','0','non existant (projet)');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (12,'qualite','1','source très précise');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (13,'qualite','2','source précise');
+INSERT INTO legende (id,groupe,num_choix,libelle_choix) values (14,'qualite','3','source peu précise');
+
+
+-- droits
+-- ALTER DATABASE grace OWNER TO gisuser;
+GRANT ALL ON acteur TO gisuser;
+GRANT ALL ON artere TO gisuser;
+GRANT ALL ON cable TO gisuser;
+GRANT ALL ON chambre TO gisuser;
+GRANT ALL ON element_branchement_passif TO gisuser;
+GRANT ALL ON fourreau TO gisuser;
+GRANT ALL ON legende TO gisuser;
+GRANT ALL ON local_technique TO gisuser;
+GRANT ALL ON noeud TO gisuser;
+GRANT ALL ON sites_emission TO gisuser;
+GRANT ALL ON sous_tubage TO gisuser;
+GRANT ALL ON tranchee TO gisuser;
+
+
+-- SQL complémentaires
+ALTER TABLE "public"."chambre" DROP CONSTRAINT "chambre_chambre_fk";
+ALTER TABLE "public"."noeud" DROP CONSTRAINT "enforce_srid_geom";
+ALTER TABLE "public"."artere" DROP CONSTRAINT "enforce_srid_geom";
+ALTER TABLE "public"."fourreau" DROP CONSTRAINT "enforce_srid_geom";
+ALTER TABLE "public"."cable" DROP CONSTRAINT "enforce_srid_geom";
+ALTER TABLE "public"."sous_tubage" DROP CONSTRAINT "enforce_srid_geom";
+ALTER TABLE "public"."tranchee" DROP CONSTRAINT "enforce_srid_geom";
+
+ALTER TABLE "public"."local_technique" DROP CONSTRAINT "local_technique_local_technique_fk";
\ No newline at end of file