data/pgsql/v3.3.0-a7.sql

-- Mise à jour de la base pour la version 3.3.0-a7

ALTER TABLE cerfa ADD COLUMN terr_juri_titul boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_lot boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_zac boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_afu boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_pup boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_oin boolean;
ALTER TABLE cerfa ADD COLUMN terr_juri_desc boolean;
ALTER TABLE cerfa ADD COLUMN terr_div_surf_etab boolean;
ALTER TABLE cerfa ADD COLUMN terr_div_surf_av_div boolean;

ALTER TABLE donnees_techniques ADD COLUMN terr_juri_titul character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_lot character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_zac character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_afu character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_pup character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_oin character varying(20);
ALTER TABLE donnees_techniques ADD COLUMN terr_juri_desc text;
ALTER TABLE donnees_techniques ADD COLUMN terr_div_surf_etab numeric;
ALTER TABLE donnees_techniques ADD COLUMN terr_div_surf_av_div numeric;


-- Ajout des dates manquante dans le dossier d'autorisation
ALTER TABLE dossier_autorisation ADD COLUMN date_depot date;
ALTER TABLE dossier_autorisation ADD COLUMN date_decision date;
ALTER TABLE dossier_autorisation ADD COLUMN date_validite date;
ALTER TABLE dossier_autorisation ADD COLUMN date_chantier date;
ALTER TABLE dossier_autorisation ADD COLUMN date_achevement date;
1	nhaye	1616	-- 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;
22	nhaye	1639
23
24			-- Ajout des dates manquante dans le dossier d'autorisation
25			ALTER TABLE dossier_autorisation ADD COLUMN date_depot date;
26			ALTER TABLE dossier_autorisation ADD COLUMN date_decision date;
27			ALTER TABLE dossier_autorisation ADD COLUMN date_validite date;
28			ALTER TABLE dossier_autorisation ADD COLUMN date_chantier date;
29			ALTER TABLE dossier_autorisation ADD COLUMN date_achevement date;