/[openfoncier]/trunk/data/pgsql/v3.0.0rc1.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.0.0rc1.sql

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

revision 352 by fraynaud, Thu Jul 5 14:34:19 2012 UTC revision 363 by fraynaud, Tue Jul 31 11:02:32 2012 UTC
# Line 266  CREATE SEQUENCE om_sig_map_seq Line 266  CREATE SEQUENCE om_sig_map_seq
266    MINVALUE 1    MINVALUE 1
267    MAXVALUE 9223372036854775807    MAXVALUE 9223372036854775807
268    START 1    START 1
   CACHE 1;  
269      CACHE 1;
270      
271    -- nouveau om_parametres
272    DO $$
273    DECLARE variable bigint;
274    DECLARE collectivite bigint;
275    BEGIN
276      collectivite:=1;
277      variable:= (SELECT MAX(om_parametre) FROM om_parametre);
278      INSERT INTO om_parametre (om_parametre, libelle, valeur, om_collectivite) VALUES
279            (variable+1, 'numero_unique', '1', collectivite),
280            (variable+2, 'lettre', 'R',  collectivite);
281            PERFORM setval('om_parametre_seq', variable+2);  
282    END $$;
Legend:
Removed from v.352  
changed lines
  Added in v.363
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26