From c7dceedde516170d1a6ac1257103bdacb3b0cc84 Mon Sep 17 00:00:00 2001 From: Eugene Nikanorov Date: Thu, 10 Apr 2014 13:36:45 +0400 Subject: [PATCH] Properly apply column default in migration pool_monitor_status server_default parameter should be used to apply default value at table/column creation time. Otherwise non-nullable column can't be created because of existing rows in the tables. Change-Id: I7136e6a0dfb9dc66ca63ff3c9fcf6de164e27e63 Closes-Bug: #1305725 --- .../versions/11c6e18605c8_pool_monitor_status_.py | 1 + 1 file changed, 1 insertion(+) diff --git a/neutron/db/migration/alembic_migrations/versions/11c6e18605c8_pool_monitor_status_.py b/neutron/db/migration/alembic_migrations/versions/11c6e18605c8_pool_monitor_status_.py index a31bf6a95..598f2ab32 100644 --- a/neutron/db/migration/alembic_migrations/versions/11c6e18605c8_pool_monitor_status_.py +++ b/neutron/db/migration/alembic_migrations/versions/11c6e18605c8_pool_monitor_status_.py @@ -45,6 +45,7 @@ def upgrade(active_plugins=None, options=None): op.add_column('poolmonitorassociations', sa.Column('status', sa.String(16), + server_default='', nullable=False)) op.add_column('poolmonitorassociations', sa.Column('status_description', sa.String(255))) -- 2.45.2