/[openfoncier]/trunk/data/pgsql/parametrage.sql
ViewVC logotype

Diff of /trunk/data/pgsql/parametrage.sql

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

revision 349 by fmichon, Wed Jul 4 18:55:07 2012 UTC revision 365 by fraynaud, Tue Jul 31 15:25:05 2012 UTC
# Line 10  Line 10 
10  -- om_parametre -> parametres utilises en lettretype  -- om_parametre -> parametres utilises en lettretype
11    
12  INSERT INTO om_parametre (om_parametre, libelle, valeur, om_collectivite) VALUES  INSERT INTO om_parametre (om_parametre, libelle, valeur, om_collectivite) VALUES
13  (3, 'departement', '13', 1),  (nextval('om_parametre_seq'), 'departement', '13', 1),
14  (4, 'commune', '004', 1),  (nextval('om_parametre_seq'), 'commune', '004', 1),
15  (5, 'nom', 'Paul DURANT', 1),  (nextval('om_parametre_seq'), 'nom', 'Paul DURANT', 1),
16  (6, 'delaville', 'd''Arles', 1),  (nextval('om_parametre_seq'), 'delaville', 'd''Arles', 1),
17  (7, 'titreelu', 'Conseiller Général des Bouches du Rhône', 1),  (nextval('om_parametre_seq'), 'titreelu', 'Conseiller Général des Bouches du Rhône', 1),
18  (8, 'datepos', '02/03/1983',1) ;  (nextval('om_parametre_seq'), 'datepos', '02/03/1983',1) ;
19  ALTER SEQUENCE om_parametre_seq RESTART WITH 9;    
   
   
   
20  -- nature  -- nature
21    
22  INSERT INTO nature VALUES ('PC', 'Permis de Construire');  INSERT INTO nature VALUES ('PC', 'Permis de Construire');
# Line 103  INSERT INTO transition VALUES (21, 'acce Line 100  INSERT INTO transition VALUES (21, 'acce
100  INSERT INTO transition VALUES (22, 'accepter', 'transfert');  INSERT INTO transition VALUES (22, 'accepter', 'transfert');
101  INSERT INTO transition VALUES (23, 'notifier', 'sursis');  INSERT INTO transition VALUES (23, 'notifier', 'sursis');
102  INSERT INTO transition VALUES (24, 'majorer', 'sursis');  INSERT INTO transition VALUES (24, 'majorer', 'sursis');
   
103  -- arles  -- arles
104  INSERT INTO transition VALUES (25, 'accepter', 'divers');  INSERT INTO transition VALUES (25, 'accepter', 'divers');
105    
Legend:
Removed from v.349  
changed lines
  Added in v.365
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26