← Back to branch summary

~ubuntu-branches/ubuntu/saucy/nova/saucy-proposed

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/070_sqlite_upgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short
  • Date: 2012-05-24 13:12:53 UTC
  • mfrom: (1.1.55)
  • Revision ID: package-import@ubuntu.com-20120524131253-ommql08fg1en06ut
Tags: 2012.2~f1-0ubuntu1
https://launchpad.net/bugs/907197
* New upstream release.
* Prepare for quantal:
  - Dropped debian/patches/upstream/0006-Use-project_id-in-ec2.cloud._format_image.patch
  - Dropped debian/patches/upstream/0005-Populate-image-properties-with-project_id-again.patch
  - Dropped debian/patches/upstream/0004-Fixed-bug-962840-added-a-test-case.patch
  - Dropped debian/patches/upstream/0003-Allow-unprivileged-RADOS-users-to-access-rbd-volumes.patch
  - Dropped debian/patches/upstream/0002-Stop-libvirt-test-from-deleting-instances-dir.patch
  - Dropped debian/patches/upstream/0001-fix-bug-where-nova-ignores-glance-host-in-imageref.patch 
  - Dropped debian/patches/0001-fix-useexisting-deprecation-warnings.patch
* debian/control: Add python-keystone as a dependency. (LP: #907197)
* debian/patches/kombu_tests_timeout.patch: Refreshed.
* debian/nova.conf, debian/nova-common.postinst: Convert to new ini
  file configuration
* debian/patches/nova-manage_flagfile_location.patch: Refreshed

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/070_sqlite_upgrade.sql
1
 
BEGIN TRANSACTION;
2
 
    CREATE TABLE fixed_ips_backup (
3
 
            created_at DATETIME NOT NULL,
4
 
            updated_at DATETIME,
5
 
            deleted_at DATETIME,
6
 
            deleted BOOLEAN NOT NULL,
7
 
            id INTEGER NOT NULL,
8
 
            address VARCHAR(255),
9
 
            virtual_interface_id INTEGER,
10
 
            network_id INTEGER,
11
 
            instance_id INTEGER,
12
 
            allocated BOOLEAN default FALSE,
13
 
            leased BOOLEAN default FALSE,
14
 
            reserved BOOLEAN default FALSE,
15
 
            host VARCHAR(255),
16
 
            PRIMARY KEY (id)
17
 
        );
18
 
 
19
 
    CREATE TABLE floating_ips_backup (
20
 
        created_at DATETIME,
21
 
        updated_at DATETIME,
22
 
        deleted_at DATETIME,
23
 
        deleted BOOLEAN,
24
 
        id INTEGER NOT NULL,
25
 
        address VARCHAR(255),
26
 
        fixed_ip_id INTEGER,
27
 
        project_id VARCHAR(255),
28
 
        host VARCHAR(255),
29
 
        auto_assigned BOOLEAN,
30
 
        pool VARCHAR(255),
31
 
        interface VARCHAR(255),
32
 
        PRIMARY KEY (id)
33
 
    );
34
 
 
35
 
    INSERT INTO fixed_ips_backup
36
 
        SELECT created_at, updated_at, deleted_at, deleted, id, address,
37
 
                virtual_interface_id, network_id, instance_id, allocated,
38
 
                leased, reserved, host
39
 
        FROM fixed_ips;
40
 
 
41
 
    INSERT INTO floating_ips_backup
42
 
        SELECT created_at, updated_at, deleted_at, deleted, id, address,
43
 
                fixed_ip_id, project_id, host, auto_assigned, pool,
44
 
                interface
45
 
        FROM floating_ips;
46
 
 
47
 
    DROP TABLE fixed_ips;
48
 
    DROP TABLE floating_ips;
49
 
 
50
 
    CREATE TABLE fixed_ips (
51
 
            created_at DATETIME NOT NULL,
52
 
            updated_at DATETIME,
53
 
            deleted_at DATETIME,
54
 
            deleted BOOLEAN NOT NULL,
55
 
            id INTEGER NOT NULL,
56
 
            address VARCHAR(255),
57
 
            virtual_interface_id INTEGER,
58
 
            network_id INTEGER,
59
 
            instance_id INTEGER,
60
 
            allocated BOOLEAN default FALSE,
61
 
            leased BOOLEAN default FALSE,
62
 
            reserved BOOLEAN default FALSE,
63
 
            host VARCHAR(255),
64
 
            PRIMARY KEY (id)
65
 
        );
66
 
 
67
 
    CREATE TABLE floating_ips (
68
 
        created_at DATETIME,
69
 
        updated_at DATETIME,
70
 
        deleted_at DATETIME,
71
 
        deleted BOOLEAN,
72
 
        id INTEGER NOT NULL,
73
 
        address VARCHAR(255),
74
 
        fixed_ip_id INTEGER,
75
 
        project_id VARCHAR(255),
76
 
        host VARCHAR(255),
77
 
        auto_assigned BOOLEAN,
78
 
        pool VARCHAR(255),
79
 
        interface VARCHAR(255),
80
 
        PRIMARY KEY (id),
81
 
        CHECK (deleted IN (0, 1))
82
 
    );
83
 
 
84
 
    INSERT INTO fixed_ips
85
 
        SELECT created_at, updated_at, deleted_at, deleted, id, address,
86
 
                virtual_interface_id, network_id, instance_id, allocated,
87
 
                leased, reserved, host
88
 
        FROM fixed_ips_backup;
89
 
 
90
 
    INSERT INTO floating_ips
91
 
        SELECT created_at, updated_at, deleted_at, deleted, id, address,
92
 
                fixed_ip_id, project_id, host, auto_assigned, pool,
93
 
                interface
94
 
        FROM floating_ips_backup;
95
 
 
96
 
    DROP TABLE fixed_ips_backup;
97
 
    DROP TABLE floating_ips_backup;
98
 
 
99
 
COMMIT;