/[openfoncier]/trunk/data/pgsql/v3.1.0-b1.sql
ViewVC logotype

Diff of /trunk/data/pgsql/v3.1.0-b1.sql

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

revision 392 by nhaye, Wed Sep 19 15:41:35 2012 UTC revision 393 by nhaye, Wed Sep 19 16:23:00 2012 UTC
# Line 63  ALTER TABLE om_etat ALTER COLUMN corpsat Line 63  ALTER TABLE om_etat ALTER COLUMN corpsat
63  ALTER TABLE om_etat ALTER COLUMN footerattribut SET DEFAULT '';  ALTER TABLE om_etat ALTER COLUMN footerattribut SET DEFAULT '';
64  ALTER TABLE om_etat ALTER COLUMN sousetat SET DEFAULT '';  ALTER TABLE om_etat ALTER COLUMN sousetat SET DEFAULT '';
65    
66  ALTER TABLE om_etat ALTER COLUMN actif TYPE boolean USING CASE WHEN actif='Oui' THEN true ELSE false END;  ALTER TABLE om_sousetat ALTER COLUMN titreattribut SET DEFAULT '';
67  ALTER TABLE om_etat ALTER actif DROP NOT NULL;  ALTER TABLE om_sousetat ALTER COLUMN actif TYPE boolean USING CASE WHEN actif='Oui' THEN true ELSE false END;
68    ALTER TABLE om_sousetat ALTER actif DROP NOT NULL;
69    
70    ALTER TABLE om_sousetat ALTER entete_orientation TYPE varchar(100);
Legend:
Removed from v.392  
changed lines
  Added in v.393
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26