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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1718 by nhaye, Thu Apr 18 09:26:21 2013 UTC revision 1804 by fmichon, Tue Apr 30 14:45:17 2013 UTC
# Line 1  Line 1 
1  -- Mise à jour de la base pour la version 3.3.0-a7  --------------------------------------------------------------------------------
2    -- Script de mise à jour vers la version v3.3.0-a7
3    --
4    -- @package openfoncier
5    -- @version SVN : $Id$
6    --------------------------------------------------------------------------------
7    
8  ALTER TABLE cerfa ADD COLUMN terr_juri_titul boolean;  ALTER TABLE cerfa ADD COLUMN terr_juri_titul boolean;
9  ALTER TABLE cerfa ADD COLUMN terr_juri_lot boolean;  ALTER TABLE cerfa ADD COLUMN terr_juri_lot boolean;
# Line 246  ALTER TABLE ONLY instruction Line 251  ALTER TABLE ONLY instruction
251    
252  ALTER TABLE ONLY instruction  ALTER TABLE ONLY instruction
253      ADD CONSTRAINT dossier_etat_archive_etat_pendant_incompletude_fkey      ADD CONSTRAINT dossier_etat_archive_etat_pendant_incompletude_fkey
     FOREIGN KEY (archive_etat_pendant_incompletude) REFERENCES etat(etat);  
254        FOREIGN KEY (archive_etat_pendant_incompletude) REFERENCES etat(etat);
255    
256    ALTER TABLE action ADD COLUMN regle_date_limite_incompletude character varying(60);
257    ALTER TABLE action ADD COLUMN regle_delai_incompletude character varying(60);
258    
259    UPDATE action SET regle_avis='avis_decision' WHERE regle_avis='avis';
260    
261    -- Suppression des champs types et objet_dossier de la table dossier
262    ALTER TABLE dossier DROP COLUMN types;
263    ALTER TABLE dossier DROP COLUMN objet_dossier;
264    
265    --
266    
267    insert into om_droit(om_droit, libelle, om_profil) values
268    (nextval('om_droit_seq'), 'dossier_commission_modifier_lu', 3),
269    (nextval('om_droit_seq'), 'blocnote', 3)
270    ;
Legend:
Removed from v.1718  
changed lines
  Added in v.1804
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26