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