search

hoonsbara / octalforty-wizardby

Automatically exported from code.google.com/p/octalforty-wizardby
1 stars 0 forks source link

Default constraint is not applied #33

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
When I perform an upgrade against my database using the following schema, I 
would expect a default constraint to be created. After the upgrade, the default 
constraint is missing.

    version 20111019160807:
        alter table MyTestTable:
            alter column IsDeleted type => "Boolean", nullable => false, default => 0

Creating a new table and adding a column with a default constraint, it does not 
work either. I am using Wizardby 1.0.0.197 Alpha 3 on Windows 7 x86 against a 
Microsoft SQL 2008 database.

Original issue reported on code.google.com by martyndy...@gmail.com on 20 Oct 2011 at 8:13