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

Diff of /trunk/data/pgsql/v3.12.0-a1-dev.sql

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

revision 2572 by vpihour, Fri Nov 29 16:23:28 2013 UTC revision 2573 by nhaye, Tue Dec 3 18:54:39 2013 UTC
# Line 1597  COMMENT ON COLUMN transition.evenement I Line 1597  COMMENT ON COLUMN transition.evenement I
1597  --  --
1598    
1599  ALTER TABLE autorite_competente ADD COLUMN autorite_competente_sitadel integer;  ALTER TABLE autorite_competente ADD COLUMN autorite_competente_sitadel integer;
 COMMENT ON COLUMN autorite_competente.autorite_competente_sitadel IS 'Code sitadel de l''autorité compétente';  
1600    COMMENT ON COLUMN autorite_competente.autorite_competente_sitadel IS 'Code sitadel de l''autorité compétente';
1601    
1602    --
1603    -- Ajout de sous-états pour les export DTTE
1604    --
1605    INSERT INTO "om_sousetat" VALUES (nextval('om_sousetat_seq'), '1', 'dossier_premier_depot_dttm', 'Dossier 1er dépôt DTTM', 't', 'Répertoire des premiers dossiers DDE', '8', 'helvetica', 'B', '12', '0', 'C', '0', '255-255-255', '0-0-0', '5', '0', '1', '1', '0|0|0|0', '15', '0|0|0|0', 'C|C|C|C', '114-195-243', '0-0-0', '297', '0', '11', '0-0-0', '243-246-246', '255-255-255', '1', '10', '42|22|100|100', 'TLB|TLB|TLB|TLBR', 'TLB|LTB|LTB|LTR', 'L|L|L|L', '1', '0', '15', '196-213-213', 'L|L|L|L', 'L|L|C', '1', '0', '5', '212-219-219', 'L|L|L|L', 'L|L|L|C', '1', '0', '15', '255-255-255', 'L|L|L|L', 'L|R|C', '999|999|999|999', '0|0|0|0', '0|0|0|0', '0|0|0|0', 'Récup dans le reqmo');
1606    

Legend:
Removed from v.2572  
changed lines
  Added in v.2573

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26