This file is indexed.

/usr/lib/python2.7/dist-packages/networking_l2gw/db/migration/alembic_migrations/versions/54c9c8fe22bf_db_models_for_ovsdb_hardware_vtep_schema.py is in python-networking-l2gw 1:1.0.0-0ubuntu1.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
# Copyright 2015 OpenStack Foundation
#
#    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.
#

"""DB_Models_for_OVSDB_Hardware_VTEP_Schema

Revision ID: 54c9c8fe22bf
Revises: 42438454c556
Create Date: 2015-01-27 02:05:21.599215

"""

# revision identifiers, used by Alembic.
revision = '54c9c8fe22bf'
down_revision = 'start_networking_l2gw'

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.create_table('physical_locators',
                    sa.Column('dst_ip', sa.String(length=64), nullable=True),
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('physical_switches',
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('name', sa.String(length=255), nullable=True),
                    sa.Column('tunnel_ip', sa.String(length=64),
                              nullable=True),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.Column('switch_fault_status', sa.String(length=32),
                              nullable=True),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('physical_ports',
                    sa.Column('name', sa.String(length=255), nullable=True),
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('physical_switch_id', sa.String(length=36),
                              nullable=True),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.Column('port_fault_status', sa.String(length=32),
                              nullable=True),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('logical_switches',
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('name', sa.String(length=255), nullable=True),
                    sa.Column('key', sa.Integer(), nullable=True),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('ucast_macs_locals',
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('mac', sa.String(length=32), nullable=True),
                    sa.Column('logical_switch_id', sa.String(length=36),
                              nullable=True),
                    sa.Column('physical_locator_id', sa.String(length=36),
                              nullable=True),
                    sa.Column('ip_address', sa.String(length=64),
                              nullable=True),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('ucast_macs_remotes',
                    sa.Column('uuid', sa.String(length=36), nullable=False),
                    sa.Column('mac', sa.String(length=32), nullable=True),
                    sa.Column('logical_switch_id', sa.String(length=36),
                              nullable=True),
                    sa.Column('physical_locator_id', sa.String(length=36),
                              nullable=True),
                    sa.Column('ip_address', sa.String(length=64),
                              nullable=True),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.PrimaryKeyConstraint('uuid', 'ovsdb_identifier'))

    op.create_table('vlan_bindings',
                    sa.Column('port_uuid', sa.String(length=36),
                              nullable=False),
                    sa.Column('vlan', sa.Integer(), nullable=False),
                    sa.Column('logical_switch_uuid', sa.String(length=36),
                              nullable=False),
                    sa.Column('ovsdb_identifier', sa.String(length=64),
                              nullable=False),
                    sa.PrimaryKeyConstraint('port_uuid', 'ovsdb_identifier',
                                            'vlan', 'logical_switch_uuid'))


def downgrade():
    op.drop_table('physical_locators')
    op.drop_table('physical_switches')
    op.drop_table('physical_ports')
    op.drop_table('logical_switches')
    op.drop_table('ucast_macs_locals')
    op.drop_table('ucast_macs_remotes')
    op.drop_table('vlan_bindings')