/[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 2583 by nhaye, Wed Dec 4 17:02:48 2013 UTC revision 2585 by nhaye, Wed Dec 4 18:24:07 2013 UTC
# Line 1599  COMMENT ON COLUMN transition.evenement I Line 1599  COMMENT ON COLUMN transition.evenement I
1599  ALTER TABLE autorite_competente ADD COLUMN autorite_competente_sitadel integer;  ALTER TABLE autorite_competente ADD COLUMN autorite_competente_sitadel integer;
1600  COMMENT ON COLUMN autorite_competente.autorite_competente_sitadel IS 'Code sitadel de l''autorité compétente';  COMMENT ON COLUMN autorite_competente.autorite_competente_sitadel IS 'Code sitadel de l''autorité compétente';
1601    
1602    UPDATE autorite_competente SET autorite_competente_sitadel=1;
1603    UPDATE autorite_competente SET autorite_competente_sitadel=2 WHERE code = 'ETAT';
1604    
1605    ALTER TABLE autorite_competente ALTER COLUMN autorite_competente_sitadel SET NOT NULL;
1606    
1607  --  --
1608  -- Ajout de sous-états pour les export DTTE  -- Ajout de sous-états pour les export DTTE
1609  --  --

Legend:
Removed from v.2583  
changed lines
  Added in v.2585

[email protected]
ViewVC Help
Powered by ViewVC 1.1.26