Comment 1 for bug 1846548

The following patch allows glance to create its database. It seems subsequent queries must be quoted correctly as the service functions once the DB is created.

https://paste.ubuntu.com/p/yZ7yJwHsqQ/
Index: glance/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py
===================================================================
--- glance.orig/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py
+++ glance/glance/db/sqlalchemy/alembic_migrations/add_images_tables.py
@@ -134,7 +134,7 @@ def _add_image_members_table():
     op.create_table('image_members',
                     Column('id', Integer(), nullable=False),
                     Column('image_id', String(length=36), nullable=False),
- Column('member', String(length=255), nullable=False),
+ Column('`member`', String(length=255), nullable=False),
                     Column('can_share', Boolean(), nullable=False),
                     Column('created_at', DateTime(), nullable=False),
                     Column('updated_at', DateTime(), nullable=True),
@@ -147,7 +147,7 @@ def _add_image_members_table():
                     ForeignKeyConstraint(['image_id'], ['images.id'], ),
                     PrimaryKeyConstraint('id'),
                     UniqueConstraint('image_id',
- 'member',
+ '`member`',
                                      'deleted_at',
                                      name=deleted_member_constraint),
                     mysql_engine='InnoDB',
@@ -164,7 +164,7 @@ def _add_image_members_table():
                     unique=False)
     op.create_index('ix_image_members_image_id_member',
                     'image_members',
- ['image_id', 'member'],
+ ['image_id', '`member`'],
                     unique=False)