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; |