← Back to branch summary

~ubuntu-cloud-archive/ubuntu/precise/nova/trunk

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/095_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/095_sqlite_upgrade.sql
 
1
BEGIN TRANSACTION;
 
2
    -- change instance_id volumes table
 
3
    CREATE TABLE volumes_backup(
 
4
        created_at DATETIME,
 
5
        updated_at DATETIME,
 
6
        deleted_at DATETIME,
 
7
        deleted BOOLEAN,
 
8
        id VARCHAR(36) NOT NULL,
 
9
        ec2_id INTEGER,
 
10
        user_id VARCHAR(255),
 
11
        project_id VARCHAR(255),
 
12
        snapshot_id VARCHAR(36),
 
13
        host VARCHAR(255),
 
14
        size INTEGER,
 
15
        availability_zone VARCHAR(255),
 
16
        instance_id INTEGER,
 
17
        instance_uuid VARCHAR(36),
 
18
        mountpoint VARCHAR(255),
 
19
        attach_time VARCHAR(255),
 
20
        status VARCHAR(255),
 
21
        attach_status VARCHAR(255),
 
22
        scheduled_at DATETIME,
 
23
        launched_at DATETIME,
 
24
        terminated_at DATETIME,
 
25
        display_name VARCHAR(255),
 
26
        display_description VARCHAR(255),
 
27
        provider_location VARCHAR(255),
 
28
        provider_auth VARCHAR(255),
 
29
        volume_type_id INTEGER,
 
30
        PRIMARY KEY (id),
 
31
        FOREIGN KEY(instance_id) REFERENCES instances (id),
 
32
        UNIQUE (id),
 
33
        CHECK (deleted IN (0, 1))
 
34
    );
 
35
 
 
36
    INSERT INTO volumes_backup SELECT
 
37
        created_at,
 
38
        updated_at,
 
39
        deleted_at,
 
40
        deleted,
 
41
        id,
 
42
        ec2_id,
 
43
        user_id,
 
44
        project_id,
 
45
        snapshot_id,
 
46
        host,
 
47
        size,
 
48
        availability_zone,
 
49
        instance_id,
 
50
        NULL,
 
51
        mountpoint,
 
52
        attach_time,
 
53
        status,
 
54
        attach_status,
 
55
        scheduled_at,
 
56
        launched_at,
 
57
        terminated_at,
 
58
        display_name,
 
59
        display_description,
 
60
        provider_location,
 
61
        provider_auth,
 
62
        volume_type_id
 
63
    FROM volumes;
 
64
 
 
65
    UPDATE volumes_backup
 
66
        SET instance_uuid =
 
67
            (SELECT uuid
 
68
                FROM instances
 
69
                WHERE volumes_backup.instance_id = instances.id
 
70
        );
 
71
    DROP TABLE volumes;
 
72
 
 
73
    CREATE TABLE volumes(
 
74
        created_at DATETIME,
 
75
        updated_at DATETIME,
 
76
        deleted_at DATETIME,
 
77
        deleted BOOLEAN,
 
78
        id VARCHAR(36) NOT NULL,
 
79
        ec2_id INTEGER,
 
80
        user_id VARCHAR(255),
 
81
        project_id VARCHAR(255),
 
82
        snapshot_id VARCHAR(36),
 
83
        host VARCHAR(255),
 
84
        size INTEGER,
 
85
        availability_zone VARCHAR(255),
 
86
        instance_uuid VARCHAR(36),
 
87
        mountpoint VARCHAR(255),
 
88
        attach_time VARCHAR(255),
 
89
        status VARCHAR(255),
 
90
        attach_status VARCHAR(255),
 
91
        scheduled_at DATETIME,
 
92
        launched_at DATETIME,
 
93
        terminated_at DATETIME,
 
94
        display_name VARCHAR(255),
 
95
        display_description VARCHAR(255),
 
96
        provider_location VARCHAR(255),
 
97
        provider_auth VARCHAR(255),
 
98
        volume_type_id INTEGER,
 
99
        PRIMARY KEY (id),
 
100
        UNIQUE (id),
 
101
        CHECK (deleted IN (0, 1))
 
102
    );
 
103
 
 
104
    INSERT INTO volumes
 
105
        SELECT created_at,
 
106
               updated_at,
 
107
               deleted_at,
 
108
               deleted,
 
109
               id,
 
110
               ec2_id,
 
111
               user_id,
 
112
               project_id,
 
113
               snapshot_id,
 
114
               host,
 
115
               size,
 
116
               availability_zone,
 
117
               instance_uuid,
 
118
               mountpoint,
 
119
               attach_time,
 
120
               status,
 
121
               attach_status,
 
122
               scheduled_at,
 
123
               launched_at,
 
124
               terminated_at,
 
125
               display_name,
 
126
               display_description,
 
127
               provider_location,
 
128
               provider_auth,
 
129
               volume_type_id
 
130
        FROM volumes_backup;
 
131
    DROP TABLE volumes_backup;
 
132
COMMIT;