/[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 394 by nhaye, Wed Sep 19 16:50:59 2012 UTC revision 401 by nhaye, Thu Sep 20 14:17:34 2012 UTC
# Line 75  ALTER TABLE om_lettretype ALTER COLUMN t Line 75  ALTER TABLE om_lettretype ALTER COLUMN t
75  ALTER TABLE om_lettretype ALTER COLUMN corpsattribut SET DEFAULT '';  ALTER TABLE om_lettretype ALTER COLUMN corpsattribut SET DEFAULT '';
76  ALTER TABLE om_lettretype ALTER COLUMN actif TYPE boolean USING CASE WHEN actif='Oui' THEN true ELSE false END;  ALTER TABLE om_lettretype ALTER COLUMN actif TYPE boolean USING CASE WHEN actif='Oui' THEN true ELSE false END;
77  ALTER TABLE om_lettretype ALTER actif DROP NOT NULL;  ALTER TABLE om_lettretype ALTER actif DROP NOT NULL;
78    
79    ALTER TABLE avis ALTER libelle DROP DEFAULT;
Legend:
Removed from v.394  
changed lines
  Added in v.401
[email protected]
 ViewVC Help
Powered by ViewVC 1.1.26