/[openfoncier]/trunk/data/pgsql/v3.3.0-a7.sql
ViewVC logotype

Contents of /trunk/data/pgsql/v3.3.0-a7.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1616 - (show annotations)
Wed Apr 3 16:48:50 2013 UTC (11 years, 10 months ago) by nhaye
File size: 1218 byte(s)
Ajout des champs concernant le terrain dans les formulaires de données techniques

1 -- Mise à jour de la base pour la version 3.3.0-a7
2
3 ALTER TABLE cerfa ADD COLUMN terr_juri_titul boolean;
4 ALTER TABLE cerfa ADD COLUMN terr_juri_lot boolean;
5 ALTER TABLE cerfa ADD COLUMN terr_juri_zac boolean;
6 ALTER TABLE cerfa ADD COLUMN terr_juri_afu boolean;
7 ALTER TABLE cerfa ADD COLUMN terr_juri_pup boolean;
8 ALTER TABLE cerfa ADD COLUMN terr_juri_oin boolean;
9 ALTER TABLE cerfa ADD COLUMN terr_juri_desc boolean;
10 ALTER TABLE cerfa ADD COLUMN terr_div_surf_etab boolean;
11 ALTER TABLE cerfa ADD COLUMN terr_div_surf_av_div boolean;
12
13 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_titul character varying(20);
14 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_lot character varying(20);
15 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_zac character varying(20);
16 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_afu character varying(20);
17 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_pup character varying(20);
18 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_oin character varying(20);
19 ALTER TABLE donnees_techniques ADD COLUMN terr_juri_desc text;
20 ALTER TABLE donnees_techniques ADD COLUMN terr_div_surf_etab numeric;
21 ALTER TABLE donnees_techniques ADD COLUMN terr_div_surf_av_div numeric;

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26