← 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/088_sqlite_upgrade.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/088_sqlite_upgrade.sql
1
 
BEGIN TRANSACTION;
2
 
    CREATE TEMPORARY TABLE block_device_mapping_backup (
3
 
        created_at DATETIME,
4
 
        updated_at DATETIME,
5
 
        deleted_at DATETIME,
6
 
        deleted BOOLEAN,
7
 
        id INTEGER NOT NULL,
8
 
        instance_id INTEGER NOT NULL,
9
 
        device_name VARCHAR(255) NOT NULL,
10
 
        delete_on_termination BOOLEAN,
11
 
        virtual_name VARCHAR(255),
12
 
        snapshot_id INTEGER,
13
 
        volume_id INTEGER,
14
 
        volume_size INTEGER,
15
 
        no_device BOOLEAN,
16
 
        connection_info TEXT,
17
 
        instance_uuid VARCHAR(36),
18
 
        PRIMARY KEY (id),
19
 
        FOREIGN KEY(snapshot_id) REFERENCES snapshots (id),
20
 
        CHECK (deleted IN (0, 1)),
21
 
        CHECK (delete_on_termination IN (0, 1)),
22
 
        CHECK (no_device IN (0, 1)),
23
 
        FOREIGN KEY(volume_id) REFERENCES volumes (id),
24
 
        FOREIGN KEY(instance_id) REFERENCES instances (id)
25
 
    );
26
 
 
27
 
    INSERT INTO block_device_mapping_backup
28
 
        SELECT created_at,
29
 
               updated_at,
30
 
               deleted_at,
31
 
               deleted,
32
 
               id,
33
 
               instance_id,
34
 
               device_name,
35
 
               delete_on_termination,
36
 
               virtual_name,
37
 
               snapshot_id,
38
 
               volume_id,
39
 
               volume_size,
40
 
               no_device,
41
 
               connection_info,
42
 
               NULL
43
 
        FROM block_device_mapping;
44
 
 
45
 
    UPDATE block_device_mapping_backup
46
 
        SET instance_uuid=
47
 
            (SELECT uuid
48
 
                 FROM instances
49
 
                 WHERE block_device_mapping_backup.instance_id = instances.id
50
 
    );
51
 
 
52
 
    DROP TABLE block_device_mapping;
53
 
 
54
 
    CREATE TABLE block_device_mapping (
55
 
        created_at DATETIME,
56
 
        updated_at DATETIME,
57
 
        deleted_at DATETIME,
58
 
        deleted BOOLEAN,
59
 
        id INTEGER NOT NULL,
60
 
        device_name VARCHAR(255) NOT NULL,
61
 
        delete_on_termination BOOLEAN,
62
 
        virtual_name VARCHAR(255),
63
 
        snapshot_id INTEGER,
64
 
        volume_id INTEGER,
65
 
        volume_size INTEGER,
66
 
        no_device BOOLEAN,
67
 
        connection_info TEXT,
68
 
        instance_uuid VARCHAR(36),
69
 
        PRIMARY KEY (id),
70
 
        FOREIGN KEY(snapshot_id) REFERENCES snapshots (id),
71
 
        CHECK (deleted IN (0, 1)),
72
 
        CHECK (delete_on_termination IN (0, 1)),
73
 
        CHECK (no_device IN (0, 1)),
74
 
        FOREIGN KEY(volume_id) REFERENCES volumes (id),
75
 
        FOREIGN KEY(instance_uuid) REFERENCES instances (uuid)
76
 
    );
77
 
 
78
 
    INSERT INTO block_device_mapping
79
 
        SELECT created_at,
80
 
               updated_at,
81
 
               deleted_at,
82
 
               deleted,
83
 
               id,
84
 
               device_name,
85
 
               delete_on_termination,
86
 
               virtual_name,
87
 
               snapshot_id,
88
 
               volume_id,
89
 
               volume_size,
90
 
               no_device,
91
 
               connection_info,
92
 
               instance_uuid
93
 
        FROM block_device_mapping_backup;
94
 
 
95
 
    DROP TABLE block_device_mapping_backup;
96
 
 
97
 
COMMIT;