/[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 499 by nhaye, Fri Oct 12 16:01:09 2012 UTC revision 500 by vpihour, Mon Oct 15 08:34:00 2012 UTC
# Line 39  UPDATE consultation SET service=(select Line 39  UPDATE consultation SET service=(select
39    
40  ALTER TABLE service ADD COLUMN consultation_papier boolean;  ALTER TABLE service ADD COLUMN consultation_papier boolean;
41  ALTER TABLE service ADD COLUMN choix_consultation boolean;  ALTER TABLE service ADD COLUMN choix_consultation boolean;
42    ALTER TABLE service ADD COLUMN notification_email boolean;
43  ALTER TABLE service ADD COLUMN om_validite_debut date;  ALTER TABLE service ADD COLUMN om_validite_debut date;
44  ALTER TABLE service ADD COLUMN om_validite_fin date;  ALTER TABLE service ADD COLUMN om_validite_fin date;
45    
# Line 178  ALTER TABLE consultation ADD COLUMN fich Line 179  ALTER TABLE consultation ADD COLUMN fich
179  ALTER TABLE consultation ADD COLUMN lu boolean;  ALTER TABLE consultation ADD COLUMN lu boolean;
180    
181    
182    
183  UPDATE evenement SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);  UPDATE evenement SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);
184  UPDATE instruction SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);  UPDATE instruction SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);
185  UPDATE dossier SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);  UPDATE dossier SET avis_decision=(select avis_decision.avis_decision from avis_decision where avis=avis_decision.avis_old);
# Line 224  INSERT INTO om_droit VALUES (nextval('om Line 226  INSERT INTO om_droit VALUES (nextval('om
226  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'avis_decision', '4');  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'avis_decision', '4');
227  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'avis_consultation', '4');  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'avis_consultation', '4');
228  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'lien_service_service_categorie', '4');  INSERT INTO om_droit VALUES (nextval('om_droit_seq'),'lien_service_service_categorie', '4');
229    
230    --
231    -- Ajout des types de consultation
232    --
233    CREATE TABLE type_consultation (
234      type_consultation integer,
235      libelle varchar(70)  NOT NULL default ''
236    );
237    
238    ALTER TABLE ONLY type_consultation
239        ADD CONSTRAINT type_consultation_pkey PRIMARY KEY (type_consultation);
240    
241    CREATE SEQUENCE type_consultation_seq
242      INCREMENT 1
243      MINVALUE 1
244      MAXVALUE 9223372036854775807
245      START 1
246      CACHE 1;
247    
248    INSERT INTO type_consultation VALUES ('1','pour_information');
249    INSERT INTO type_consultation VALUES ('2','avec_avis_atendu');
250    INSERT INTO type_consultation VALUES ('3','pour_conformite');
251    
252    ALTER TABLE service ADD COLUMN type_consultation integer;
253    
254    ALTER TABLE ONLY service
255        ADD CONSTRAINT service_type_consultation_fkey FOREIGN KEY (type_consultation) REFERENCES type_consultation(type_consultation);
Legend:
Removed from v.499  
changed lines
  Added in v.500
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26