diff options
Diffstat (limited to 'odoo/tools/sql.py')
| -rw-r--r-- | odoo/tools/sql.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/odoo/tools/sql.py b/odoo/tools/sql.py index 2a0594b7d34..a805202a019 100644 --- a/odoo/tools/sql.py +++ b/odoo/tools/sql.py @@ -74,7 +74,8 @@ def column_exists(cr, tablename, columnname): def create_column(cr, tablename, columnname, columntype, comment=None): """ Create a column with the given type. """ - cr.execute('ALTER TABLE "{}" ADD COLUMN "{}" {}'.format(tablename, columnname, columntype)) + coldefault = (columntype.upper()=='BOOLEAN') and 'DEFAULT false' or '' + cr.execute('ALTER TABLE "{}" ADD COLUMN "{}" {} {}'.format(tablename, columnname, columntype, coldefault)) if comment: cr.execute('COMMENT ON COLUMN "{}"."{}" IS %s'.format(tablename, columnname), (comment,)) _schema.debug("Table %r: added column %r of type %s", tablename, columnname, columntype) |