← Back to branch summary

~gandelman-a/ubuntu/precise/nova/UCA_2012.2.1

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/059_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/059_sqlite_downgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE instance_types_backup (
4
 
                           created_at DATETIME,
5
 
                           updated_at DATETIME,
6
 
                           deleted_at DATETIME,
7
 
                           deleted BOOLEAN,
8
 
                           name VARCHAR(255),
9
 
                           id INTEGER NOT NULL,
10
 
                           memory_mb INTEGER NOT NULL,
11
 
                           vcpus INTEGER NOT NULL,
12
 
                           local_gb INTEGER NOT NULL,
13
 
                           swap INTEGER NOT NULL,
14
 
                           rxtx_quota INTEGER NOT NULL,
15
 
                           rxtx_cap INTEGER NOT NULL,
16
 
                           vcpu_weight INTEGER,
17
 
                           flavorid VARCHAR(255),
18
 
                           PRIMARY KEY (id),
19
 
                           CHECK (deleted IN (0, 1)),
20
 
                           UNIQUE (flavorid),
21
 
                           UNIQUE (name)
22
 
    );
23
 
 
24
 
    INSERT INTO instance_types_backup
25
 
        SELECT created_at,
26
 
               updated_at,
27
 
               deleted_at,
28
 
               deleted,
29
 
               name,
30
 
               id,
31
 
               memory_mb,
32
 
               vcpus,
33
 
               local_gb,
34
 
               swap,
35
 
               0 as rxtx_quota,
36
 
               COALESCE(rxtx_factor, 1) * COALESCE ((SELECT  MIN(rxtx_base)
37
 
                                            FROM networks
38
 
                                            WHERE rxtx_base > 0), 1)
39
 
                                            as rxtx_cap,
40
 
               vcpu_weight,
41
 
               flavorid FROM instance_types;
42
 
 
43
 
    DROP TABLE instance_types;
44
 
 
45
 
    CREATE TABLE instance_types (
46
 
                created_at DATETIME,
47
 
                updated_at DATETIME,
48
 
                deleted_at DATETIME,
49
 
                deleted BOOLEAN,
50
 
                name VARCHAR(255),
51
 
                id INTEGER NOT NULL,
52
 
                memory_mb INTEGER NOT NULL,
53
 
                vcpus INTEGER NOT NULL,
54
 
                local_gb INTEGER NOT NULL,
55
 
                swap INTEGER NOT NULL,
56
 
                rxtx_quota INTEGER NOT NULL,
57
 
                rxtx_cap INTEGER NOT NULL,
58
 
                vcpu_weight INTEGER,
59
 
                flavorid VARCHAR(255),
60
 
                PRIMARY KEY (id),
61
 
                UNIQUE (flavorid),
62
 
                CHECK (deleted IN (0, 1)),
63
 
                UNIQUE (name)
64
 
    );
65
 
 
66
 
    INSERT INTO instance_types SELECT * FROM instance_types_backup;
67
 
    DROP TABLE instance_types_backup;
68
 
 
69
 
    CREATE TABLE networks_backup (
70
 
                created_at DATETIME,
71
 
                updated_at DATETIME,
72
 
                deleted_at DATETIME,
73
 
                deleted BOOLEAN,
74
 
                id INTEGER NOT NULL,
75
 
                injected BOOLEAN,
76
 
                cidr VARCHAR(255),
77
 
                netmask VARCHAR(255),
78
 
                bridge VARCHAR(255),
79
 
                gateway VARCHAR(255),
80
 
                broadcast VARCHAR(255),
81
 
                dns1 VARCHAR(255),
82
 
                vlan INTEGER,
83
 
                vpn_public_address VARCHAR(255),
84
 
                vpn_public_port INTEGER,
85
 
                vpn_private_address VARCHAR(255),
86
 
                dhcp_start VARCHAR(255),
87
 
                project_id VARCHAR(255),
88
 
                host VARCHAR(255),
89
 
                cidr_v6 VARCHAR(255),
90
 
                gateway_v6 VARCHAR(255),
91
 
                label VARCHAR(255),
92
 
                netmask_v6 VARCHAR(255),
93
 
                bridge_interface VARCHAR(255),
94
 
                multi_host BOOLEAN,
95
 
                dns2 VARCHAR(255),
96
 
                uuid VARCHAR(36),
97
 
                priority INTEGER,
98
 
                PRIMARY KEY (id),
99
 
                CHECK (deleted IN (0, 1)),
100
 
                CHECK (injected IN (0, 1)),
101
 
                CHECK (multi_host IN (0, 1))
102
 
    );
103
 
 
104
 
    INSERT INTO networks_backup
105
 
       SELECT   created_at,
106
 
                updated_at,
107
 
                deleted_at,
108
 
                deleted,
109
 
                id,
110
 
                injected,
111
 
                cidr,
112
 
                netmask,
113
 
                bridge,
114
 
                gateway,
115
 
                broadcast,
116
 
                dns1,
117
 
                vlan,
118
 
                vpn_public_address,
119
 
                vpn_public_port,
120
 
                vpn_private_address,
121
 
                dhcp_start,
122
 
                project_id,
123
 
                host,
124
 
                cidr_v6,
125
 
                gateway_v6,
126
 
                label,
127
 
                netmask_v6,
128
 
                bridge_interface,
129
 
                multi_host,
130
 
                dns2,
131
 
                uuid,
132
 
                priority
133
 
       FROM networks;
134
 
 
135
 
   DROP TABLE networks;
136
 
   ALTER TABLE networks_backup RENAME TO networks;
137
 
COMMIT;