openstack
/
keystone
Code Issues Proposed changes

sql migration: ensure using innodb utf8 for assignment table 

During migration from 37 to 38, migration fails to create assignment
table if we don't explictly specify InnoDB and UTF8 charset.

Closes-bug #1320855
Signed-off-by: Emilien Macchi <emilien.macchi@enovance.com>

Change-Id: Icd88202d2f020aea02514e49c2d07e349c74949f
(cherry picked from commit 18289b9e26)
This commit is contained in:
Emilien Macchi 2014-05-19 14:40:44 +02:00
parent e56fe4c6d0
commit 4408625031
1 changed files with 3 additions and 1 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

4
keystone/common/sql/migrate_repo/versions/038_add_assignment_table.py
View File

@ -39,7 +39,9 @@ def upgrade(migrate_engine):
sql.Column('role_id', sql.String(64), sql.ForeignKey('role.id'),
nullable=False),
sql.Column('inherited', sql.Boolean, default=False, nullable=False),
sql.PrimaryKeyConstraint('type', 'actor_id', 'target_id', 'role_id'))
sql.PrimaryKeyConstraint('type', 'actor_id', 'target_id', 'role_id'),
mysql_engine='InnoDB',
mysql_charset='utf8')
assignment_table.create(migrate_engine, checkfirst=True)