def METHOD_NAME():
    op.add_column(u'system_info',
                  sa.Column(u'revision_id', sa.TEXT(), autoincrement=False,
                            nullable=True))
    op.create_foreign_key(u'resource_view_resource_id_fkey', u'resource_view',
                          u'resource', ['resource_id'], ['id'],
                          onupdate=u'CASCADE', ondelete=u'CASCADE')
    op.add_column(u'resource', sa.Column(u'revision_id', sa.TEXT(),
                                         autoincrement=False, nullable=True))
    op.create_foreign_key(u'resource_revision_id_fkey', u'resource',
                          u'revision', [u'revision_id'], ['id'])
    op.add_column(u'package_tag', sa.Column(u'revision_id', sa.TEXT(),
                                            autoincrement=False,
                                            nullable=True))
    op.create_foreign_key(u'package_tag_revision_id_fkey', u'package_tag',
                          u'revision', [u'revision_id'], ['id'])
    op.add_column(u'package_relationship',
                  sa.Column(u'revision_id', sa.TEXT(), autoincrement=False,
                            nullable=True))
    op.create_foreign_key(u'package_relationship_revision_id_fkey',
                          u'package_relationship', u'revision',
                          [u'revision_id'], ['id'])
    op.add_column(u'package_extra', sa.Column(u'revision_id', sa.TEXT(),
                                              autoincrement=False,
                                              nullable=True))
    op.create_foreign_key(u'package_extra_revision_id_fkey', u'package_extra',
                          u'revision', [u'revision_id'], ['id'])
    op.add_column(u'package', sa.Column(u'revision_id', sa.TEXT(),
                                        autoincrement=False, nullable=True))
    op.create_foreign_key(u'package_revision_id_fkey', u'package', u'revision',
                          [u'revision_id'], ['id'])
    op.add_column(u'member', sa.Column(u'revision_id', sa.TEXT(),
                                       autoincrement=False, nullable=True))
    op.create_foreign_key(u'member_revision_id_fkey', u'member', u'revision',
                          [u'revision_id'], ['id'])
    op.add_column(u'group_extra', sa.Column(u'revision_id', sa.TEXT(),
                                            autoincrement=False,
                                            nullable=True))
    op.create_foreign_key(u'group_extra_revision_id_fkey', u'group_extra',
                          u'revision', [u'revision_id'], ['id'])
    op.add_column(u'group', sa.Column(u'revision_id', sa.TEXT(),
                                      autoincrement=False, nullable=True))
    op.create_foreign_key(u'group_revision_id_fkey', u'group', u'revision',
                          [u'revision_id'], ['id'])