/[openfoncier]/trunk/data/pgsql/v3.2.0-dev.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.2.0-dev.sql

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

revision 559 by vpihour, Tue Oct 30 16:55:55 2012 UTC revision 560 by mlimic, Tue Oct 30 17:41:31 2012 UTC
# Line 1  Line 1 
1  --  --
2    -- Ajout de table: avis_consultation_tmp;
3    --
4    
5    
6    CREATE TABLE avis_consultation_tmp (
7        avis character varying(2) NOT NULL,
8        libelle character varying(30) NOT NULL,
9        typeavis character(1) DEFAULT ''::bpchar NOT NULL,
10        sitadel character(1) DEFAULT ''::bpchar NOT NULL,
11        sitadel_motif character(1) DEFAULT ''::bpchar NOT NULL
12    );
13    
14    
15    --
16    -- Data for Name: avis_consultation_tmp;
17    --
18    
19    INSERT INTO avis_consultation_tmp VALUES ('D', 'Defavorable', 'D', '6', ' ');
20    INSERT INTO avis_consultation_tmp VALUES ('F', 'Favorable', 'F', '4', ' ');
21    INSERT INTO avis_consultation_tmp VALUES ('F1', 'Favorable avec Reserve', 'F', '4', ' ');
22    INSERT INTO avis_consultation_tmp VALUES ('T', 'Tacite', 'F', '2', ' ');
23    INSERT INTO avis_consultation_tmp VALUES ('A', 'Autre', ' ', '7', ' ');
24    
25    
26    --
27  -- Ajout de la table 'service_categorie'  -- Ajout de la table 'service_categorie'
28  --  --
29  CREATE TABLE service_categorie (  CREATE TABLE service_categorie (
# Line 144  INSERT INTO avis_decision(avis_old, libe Line 169  INSERT INTO avis_decision(avis_old, libe
169    
170  ALTER TABLE avis_consultation ADD COLUMN avis_consultation integer NOT NULL DEFAULT nextval('avis_consultation_seq'::regclass);  ALTER TABLE avis_consultation ADD COLUMN avis_consultation integer NOT NULL DEFAULT nextval('avis_consultation_seq'::regclass);
171  INSERT INTO avis_consultation(avis_old, libelle) SELECT avis, libelle  INSERT INTO avis_consultation(avis_old, libelle) SELECT avis, libelle
172    FROM avis;    FROM avis_consultation_tmp;
173    
174    
175  ALTER TABLE ONLY avis_decision  ALTER TABLE ONLY avis_decision
# Line 200  ALTER TABLE ONLY dossier Line 225  ALTER TABLE ONLY dossier
225  ALTER TABLE avis_decision DROP COLUMN avis_old;  ALTER TABLE avis_decision DROP COLUMN avis_old;
226  ALTER TABLE avis_consultation DROP COLUMN avis_old;  ALTER TABLE avis_consultation DROP COLUMN avis_old;
227  DROP TABLE avis;  DROP TABLE avis;
228    DROP TABLE avis_consultation_tmp;
229    
230  --  --
231  -- Ajout des droits sur l'objet consultation_encours  -- Ajout des droits sur l'objet consultation_encours
Legend:
Removed from v.559  
changed lines
  Added in v.560
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26