1 files changed, 0 insertions, 317 deletions
diff --git a/keystone-moon/keystone/common/sql/migrate_repo/versions/067_kilo.py b/keystone-moon/keystone/common/sql/migrate_repo/versions/067_kilo.py
deleted file mode 100644
index a6dbed67..00000000
--- a/keystone-moon/keystone/common/sql/migrate_repo/versions/067_kilo.py
+++ /dev/null
@@ -1,317 +0,0 @@
-# Licensed under the Apache License, Version 2.0 (the "License"); you may
-# not use this file except in compliance with the License. You may obtain
-# a copy of the License at
-#
-#      http://www.apache.org/licenses/LICENSE-2.0
-#
-# Unless required by applicable law or agreed to in writing, software
-# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
-# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
-# License for the specific language governing permissions and limitations
-# under the License.
-
-
-import migrate
-from oslo_log import log
-import sqlalchemy as sql
-
-from keystone.assignment.backends import sql as assignment_sql
-from keystone.common import sql as ks_sql
-from keystone.identity.mapping_backends import mapping as mapping_backend
-
-
-LOG = log.getLogger(__name__)
-
-
-def upgrade(migrate_engine):
-    meta = sql.MetaData()
-    meta.bind = migrate_engine
-
-    if migrate_engine.name == 'mysql':
-        # In Folsom we explicitly converted migrate_version to UTF8.
-        migrate_engine.execute(
-            'ALTER TABLE migrate_version CONVERT TO CHARACTER SET utf8')
-        # Set default DB charset to UTF8.
-        migrate_engine.execute(
-            'ALTER DATABASE %s DEFAULT CHARACTER SET utf8' %
-            migrate_engine.url.database)
-
-    credential = sql.Table(
-        'credential', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('user_id', sql.String(length=64), nullable=False),
-        sql.Column('project_id', sql.String(length=64)),
-        sql.Column('blob', ks_sql.JsonBlob, nullable=False),
-        sql.Column('type', sql.String(length=255), nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    domain = sql.Table(
-        'domain', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('name', sql.String(length=64), nullable=False),
-        sql.Column('enabled', sql.Boolean, default=True, nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    endpoint = sql.Table(
-        'endpoint', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('legacy_endpoint_id', sql.String(length=64)),
-        sql.Column('interface', sql.String(length=8), nullable=False),
-        sql.Column('service_id', sql.String(length=64), nullable=False),
-        sql.Column('url', sql.Text, nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        sql.Column('enabled', sql.Boolean, nullable=False, default=True,
-                   server_default='1'),
-        sql.Column('region_id', sql.String(length=255), nullable=True),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    group = sql.Table(
-        'group', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('domain_id', sql.String(length=64), nullable=False),
-        sql.Column('name', sql.String(length=64), nullable=False),
-        sql.Column('description', sql.Text),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    policy = sql.Table(
-        'policy', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('type', sql.String(length=255), nullable=False),
-        sql.Column('blob', ks_sql.JsonBlob, nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    project = sql.Table(
-        'project', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('name', sql.String(length=64), nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        sql.Column('description', sql.Text),
-        sql.Column('enabled', sql.Boolean),
-        sql.Column('domain_id', sql.String(length=64), nullable=False),
-        sql.Column('parent_id', sql.String(64), nullable=True),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    role = sql.Table(
-        'role', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('name', sql.String(length=255), nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    service = sql.Table(
-        'service', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('type', sql.String(length=255)),
-        sql.Column('enabled', sql.Boolean, nullable=False, default=True,
-                   server_default='1'),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    token = sql.Table(
-        'token', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('expires', sql.DateTime, default=None),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        sql.Column('valid', sql.Boolean, default=True, nullable=False),
-        sql.Column('trust_id', sql.String(length=64)),
-        sql.Column('user_id', sql.String(length=64)),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    trust = sql.Table(
-        'trust', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('trustor_user_id', sql.String(length=64), nullable=False),
-        sql.Column('trustee_user_id', sql.String(length=64), nullable=False),
-        sql.Column('project_id', sql.String(length=64)),
-        sql.Column('impersonation', sql.Boolean, nullable=False),
-        sql.Column('deleted_at', sql.DateTime),
-        sql.Column('expires_at', sql.DateTime),
-        sql.Column('remaining_uses', sql.Integer, nullable=True),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    trust_role = sql.Table(
-        'trust_role', meta,
-        sql.Column('trust_id', sql.String(length=64), primary_key=True,
-                   nullable=False),
-        sql.Column('role_id', sql.String(length=64), primary_key=True,
-                   nullable=False),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    user = sql.Table(
-        'user', meta,
-        sql.Column('id', sql.String(length=64), primary_key=True),
-        sql.Column('name', sql.String(length=255), nullable=False),
-        sql.Column('extra', ks_sql.JsonBlob.impl),
-        sql.Column('password', sql.String(length=128)),
-        sql.Column('enabled', sql.Boolean),
-        sql.Column('domain_id', sql.String(length=64), nullable=False),
-        sql.Column('default_project_id', sql.String(length=64)),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    user_group_membership = sql.Table(
-        'user_group_membership', meta,
-        sql.Column('user_id', sql.String(length=64), primary_key=True),
-        sql.Column('group_id', sql.String(length=64), primary_key=True),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    region = sql.Table(
-        'region',
-        meta,
-        sql.Column('id', sql.String(255), primary_key=True),
-        sql.Column('description', sql.String(255), nullable=False),
-        sql.Column('parent_region_id', sql.String(255), nullable=True),
-        sql.Column('extra', sql.Text()),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    assignment = sql.Table(
-        'assignment',
-        meta,
-        sql.Column('type', sql.Enum(
-            assignment_sql.AssignmentType.USER_PROJECT,
-            assignment_sql.AssignmentType.GROUP_PROJECT,
-            assignment_sql.AssignmentType.USER_DOMAIN,
-            assignment_sql.AssignmentType.GROUP_DOMAIN,
-            name='type'),
-            nullable=False),
-        sql.Column('actor_id', sql.String(64), nullable=False),
-        sql.Column('target_id', sql.String(64), nullable=False),
-        sql.Column('role_id', sql.String(64), nullable=False),
-        sql.Column('inherited', sql.Boolean, default=False, nullable=False),
-        sql.PrimaryKeyConstraint('type', 'actor_id', 'target_id', 'role_id'),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    mapping = sql.Table(
-        'id_mapping',
-        meta,
-        sql.Column('public_id', sql.String(64), primary_key=True),
-        sql.Column('domain_id', sql.String(64), nullable=False),
-        sql.Column('local_id', sql.String(64), nullable=False),
-        sql.Column('entity_type', sql.Enum(
-            mapping_backend.EntityType.USER,
-            mapping_backend.EntityType.GROUP,
-            name='entity_type'),
-            nullable=False),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    domain_config_whitelist = sql.Table(
-        'whitelisted_config',
-        meta,
-        sql.Column('domain_id', sql.String(64), primary_key=True),
-        sql.Column('group', sql.String(255), primary_key=True),
-        sql.Column('option', sql.String(255), primary_key=True),
-        sql.Column('value', ks_sql.JsonBlob.impl, nullable=False),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    domain_config_sensitive = sql.Table(
-        'sensitive_config',
-        meta,
-        sql.Column('domain_id', sql.String(64), primary_key=True),
-        sql.Column('group', sql.String(255), primary_key=True),
-        sql.Column('option', sql.String(255), primary_key=True),
-        sql.Column('value', ks_sql.JsonBlob.impl, nullable=False),
-        mysql_engine='InnoDB',
-        mysql_charset='utf8')
-
-    # create all tables
-    tables = [credential, domain, endpoint, group, policy, project, role,
-              service, token, trust, trust_role, user, user_group_membership,
-              region, assignment, mapping, domain_config_whitelist,
-              domain_config_sensitive]
-
-    for table in tables:
-        try:
-            table.create()
-        except Exception:
-            LOG.exception('Exception while creating table: %r', table)
-            raise
-
-    # Unique Constraints
-    migrate.UniqueConstraint(user.c.domain_id,
-                             user.c.name,
-                             name='ixu_user_name_domain_id').create()
-    migrate.UniqueConstraint(group.c.domain_id,
-                             group.c.name,
-                             name='ixu_group_name_domain_id').create()
-    migrate.UniqueConstraint(role.c.name,
-                             name='ixu_role_name').create()
-    migrate.UniqueConstraint(project.c.domain_id,
-                             project.c.name,
-                             name='ixu_project_name_domain_id').create()
-    migrate.UniqueConstraint(domain.c.name,
-                             name='ixu_domain_name').create()
-    migrate.UniqueConstraint(mapping.c.domain_id,
-                             mapping.c.local_id,
-                             mapping.c.entity_type,
-                             name='domain_id').create()
-
-    # Indexes
-    sql.Index('ix_token_expires', token.c.expires).create()
-    sql.Index('ix_token_expires_valid', token.c.expires,
-              token.c.valid).create()
-    sql.Index('ix_actor_id', assignment.c.actor_id).create()
-    sql.Index('ix_token_user_id', token.c.user_id).create()
-    sql.Index('ix_token_trust_id', token.c.trust_id).create()
-    # NOTE(stevemar): The two indexes below were named 'service_id' and
-    # 'group_id' in 050_fk_consistent_indexes.py, and need to be preserved
-    sql.Index('service_id', endpoint.c.service_id).create()
-    sql.Index('group_id', user_group_membership.c.group_id).create()
-
-    fkeys = [
-        {'columns': [endpoint.c.service_id],
-         'references': [service.c.id]},
-
-        {'columns': [user_group_membership.c.group_id],
-         'references': [group.c.id],
-         'name': 'fk_user_group_membership_group_id'},
-
-        {'columns': [user_group_membership.c.user_id],
-         'references':[user.c.id],
-         'name': 'fk_user_group_membership_user_id'},
-
-        {'columns': [project.c.domain_id],
-         'references': [domain.c.id],
-         'name': 'fk_project_domain_id'},
-
-        {'columns': [endpoint.c.region_id],
-         'references': [region.c.id],
-         'name': 'fk_endpoint_region_id'},
-
-        {'columns': [project.c.parent_id],
-         'references': [project.c.id],
-         'name': 'project_parent_id_fkey'},
-    ]
-
-    if migrate_engine.name == 'sqlite':
-        # NOTE(stevemar): We need to keep this FK constraint due to 073, but
-        # only for sqlite, once we collapse 073 we can remove this constraint
-        fkeys.append(
-            {'columns': [assignment.c.role_id],
-             'references': [role.c.id],
-             'name': 'fk_assignment_role_id'})
-
-    for fkey in fkeys:
-        migrate.ForeignKeyConstraint(columns=fkey['columns'],
-                                     refcolumns=fkey['references'],
-                                     name=fkey.get('name')).create()