← Back to branch summary

~ubuntu-branches/ubuntu/raring/nova/raring-proposed

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/095_sqlite_downgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short, Adam Gandelman, Chuck Short
  • Date: 2012-11-23 09:04:58 UTC
  • mfrom: (1.1.66)
  • Revision ID: package-import@ubuntu.com-20121123090458-91565o7aev1i1h71
Tags: 2013.1~g1-0ubuntu1
https://launchpad.net/bugs/1073289
https://launchpad.net/bugs/1076442
[ Adam Gandelman ]
* debian/control: Ensure novaclient is upgraded with nova,
  require python-keystoneclient >= 1:2.9.0. (LP: #1073289)
* debian/patches/{ubuntu/*, rbd-security.patch}: Dropped, applied
  upstream.
* debian/control: Add python-testtools to Build-Depends.

[ Chuck Short ]
* New upstream version.
* Refreshed debian/patches/avoid_setuptools_git_dependency.patch.
* debian/rules: FTBFS if missing binaries.
* debian/nova-scheudler.install: Add missing rabbit-queues and
  nova-rpc-zmq-receiver.
* Remove nova-volume since it doesnt exist anymore, transition to cinder-*.
* debian/rules: install apport hook in the right place.
* debian/patches/ubuntu-show-tests.patch: Display test failures.
* debian/control: Add depends on genisoimage
* debian/control: Suggest guestmount.
* debian/control: Suggest websockify. (LP: #1076442)
* debian/nova.conf: Disable nova-volume service.
* debian/control: Depend on xen-system-* rather than the hypervisor.
* debian/control, debian/mans/nova-conductor.8, debian/nova-conductor.init,
  debian/nova-conductor.install, debian/nova-conductor.logrotate
  debian/nova-conductor.manpages, debian/nova-conductor.postrm
  debian/nova-conductor.upstart.in: Add nova-conductor service.
* debian/control: Add python-fixtures as a build deps.

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/095_sqlite_downgrade.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
 
        NULL,
50
 
        instance_uuid,
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_id =
67
 
            (SELECT id
68
 
                FROM instances
69
 
                WHERE volumes_backup.instance_uuid = instances.uuid
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_id INTEGER,
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
 
        FOREIGN KEY (instance_id) REFERENCES instances (id),
101
 
        UNIQUE (id),
102
 
        CHECK (deleted IN (0, 1))
103
 
    );
104
 
 
105
 
    INSERT INTO volumes
106
 
        SELECT created_at,
107
 
               updated_at,
108
 
               deleted_at,
109
 
               deleted,
110
 
               id,
111
 
               ec2_id,
112
 
               user_id,
113
 
               project_id,
114
 
               snapshot_id,
115
 
               host,
116
 
               size,
117
 
               availability_zone,
118
 
               instance_id,
119
 
               mountpoint,
120
 
               attach_time,
121
 
               status,
122
 
               attach_status,
123
 
               scheduled_at,
124
 
               launched_at,
125
 
               terminated_at,
126
 
               display_name,
127
 
               display_description,
128
 
               provider_location,
129
 
               provider_auth,
130
 
               volume_type_id
131
 
        FROM volumes_backup;
132
 
    DROP TABLE volumes_backup;
133
 
COMMIT;