← 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/053_sqlite_downgrade.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/053_sqlite_downgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE block_device_mapping_backup (
4
 
        created_at DATETIME,
5
 
        updated_at DATETIME,
6
 
        deleted_at DATETIME,
7
 
        deleted BOOLEAN,
8
 
        id INTEGER NOT NULL,
9
 
        instance_id INTEGER NOT NULL,
10
 
        device_name VARCHAR(255) NOT NULL,
11
 
        delete_on_termination BOOLEAN,
12
 
        virtual_name VARCHAR(255),
13
 
        snapshot_id INTEGER,
14
 
        volume_id INTEGER,
15
 
        volume_size INTEGER,
16
 
        no_device BOOLEAN,
17
 
        connection_info TEXT,
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
 
        FROM block_device_mapping;
43
 
 
44
 
    DROP TABLE block_device_mapping;
45
 
 
46
 
    CREATE TABLE block_device_mapping (
47
 
        created_at DATETIME,
48
 
        updated_at DATETIME,
49
 
        deleted_at DATETIME,
50
 
        deleted BOOLEAN,
51
 
        id INTEGER NOT NULL,
52
 
        instance_id INTEGER NOT NULL,
53
 
        device_name VARCHAR(255) NOT NULL,
54
 
        delete_on_termination BOOLEAN,
55
 
        virtual_name VARCHAR(255),
56
 
        snapshot_id INTEGER,
57
 
        volume_id INTEGER,
58
 
        volume_size INTEGER,
59
 
        no_device BOOLEAN,
60
 
        PRIMARY KEY (id),
61
 
        FOREIGN KEY(snapshot_id) REFERENCES snapshots (id),
62
 
        CHECK (deleted IN (0, 1)),
63
 
        CHECK (delete_on_termination IN (0, 1)),
64
 
        CHECK (no_device IN (0, 1)),
65
 
        FOREIGN KEY(volume_id) REFERENCES volumes (id),
66
 
        FOREIGN KEY(instance_id) REFERENCES instances (id)
67
 
    );
68
 
 
69
 
    INSERT INTO block_device_mapping
70
 
        SELECT created_at,
71
 
               updated_at,
72
 
               deleted_at,
73
 
               deleted,
74
 
               id,
75
 
               instance_id,
76
 
               device_name,
77
 
               delete_on_termination,
78
 
               virtual_name,
79
 
               snapshot_id,
80
 
               volume_id,
81
 
               volume_size,
82
 
               no_device
83
 
        FROM block_device_mapping_backup;
84
 
 
85
 
    DROP TABLE block_device_mapping_backup;
86
 
 
87
 
COMMIT;