← 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/030_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/030_sqlite_downgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE instances_backup (
4
 
        created_at DATETIME,
5
 
        updated_at DATETIME,
6
 
        deleted_at DATETIME,
7
 
        deleted BOOLEAN,
8
 
        id INTEGER NOT NULL,
9
 
        internal_id INTEGER,
10
 
        admin_pass VARCHAR(255),
11
 
        user_id VARCHAR(255),
12
 
        project_id VARCHAR(255),
13
 
        image_ref VARCHAR(255),
14
 
        kernel_id VARCHAR(255),
15
 
        ramdisk_id VARCHAR(255),
16
 
        server_name VARCHAR(255),
17
 
        launch_index INTEGER,
18
 
        key_name VARCHAR(255),
19
 
        key_data TEXT,
20
 
        state INTEGER,
21
 
        state_description VARCHAR(255),
22
 
        memory_mb INTEGER,
23
 
        vcpus INTEGER,
24
 
        local_gb INTEGER,
25
 
        hostname VARCHAR(255),
26
 
        host VARCHAR(255),
27
 
        user_data TEXT,
28
 
        reservation_id VARCHAR(255),
29
 
        scheduled_at DATETIME,
30
 
        launched_at DATETIME,
31
 
        terminated_at DATETIME,
32
 
        display_name VARCHAR(255),
33
 
        display_description VARCHAR(255),
34
 
        availability_zone VARCHAR(255),
35
 
        locked BOOLEAN,
36
 
        os_type VARCHAR(255),
37
 
        launched_on TEXT,
38
 
        instance_type_id INTEGER,
39
 
        vm_mode VARCHAR(255),
40
 
        uuid VARCHAR(36),
41
 
        architecture VARCHAR(255),
42
 
        PRIMARY KEY (id),
43
 
        CHECK (locked IN (0, 1)),
44
 
        CHECK (deleted IN (0, 1))
45
 
    );
46
 
 
47
 
    INSERT INTO instances_backup
48
 
        SELECT created_at,
49
 
               updated_at,
50
 
               deleted_at,
51
 
               deleted,
52
 
               id,
53
 
               internal_id,
54
 
               admin_pass,
55
 
               user_id,
56
 
               project_id,
57
 
               image_ref,
58
 
               kernel_id,
59
 
               ramdisk_id,
60
 
               server_name,
61
 
               launch_index,
62
 
               key_name,
63
 
               key_data,
64
 
               state,
65
 
               state_description,
66
 
               memory_mb,
67
 
               vcpus,
68
 
               local_gb,
69
 
               hostname,
70
 
               host,
71
 
               user_data,
72
 
               reservation_id,
73
 
               scheduled_at,
74
 
               launched_at,
75
 
               terminated_at,
76
 
               display_name,
77
 
               display_description,
78
 
               availability_zone,
79
 
               locked,
80
 
               os_type,
81
 
               launched_on,
82
 
               instance_type_id,
83
 
               vm_mode,
84
 
               uuid,
85
 
               architecture
86
 
        FROM instances;
87
 
 
88
 
    DROP TABLE instances;
89
 
 
90
 
    CREATE TABLE instances (
91
 
        created_at DATETIME,
92
 
        updated_at DATETIME,
93
 
        deleted_at DATETIME,
94
 
        deleted BOOLEAN,
95
 
        id INTEGER NOT NULL,
96
 
        internal_id INTEGER,
97
 
        admin_pass VARCHAR(255),
98
 
        user_id VARCHAR(255),
99
 
        project_id VARCHAR(255),
100
 
        image_ref VARCHAR(255),
101
 
        kernel_id VARCHAR(255),
102
 
        ramdisk_id VARCHAR(255),
103
 
        server_name VARCHAR(255),
104
 
        launch_index INTEGER,
105
 
        key_name VARCHAR(255),
106
 
        key_data TEXT,
107
 
        state INTEGER,
108
 
        state_description VARCHAR(255),
109
 
        memory_mb INTEGER,
110
 
        vcpus INTEGER,
111
 
        local_gb INTEGER,
112
 
        hostname VARCHAR(255),
113
 
        host VARCHAR(255),
114
 
        user_data TEXT,
115
 
        reservation_id VARCHAR(255),
116
 
        scheduled_at DATETIME,
117
 
        launched_at DATETIME,
118
 
        terminated_at DATETIME,
119
 
        display_name VARCHAR(255),
120
 
        display_description VARCHAR(255),
121
 
        availability_zone VARCHAR(255),
122
 
        locked BOOLEAN,
123
 
        os_type VARCHAR(255),
124
 
        launched_on TEXT,
125
 
        instance_type_id INTEGER,
126
 
        vm_mode VARCHAR(255),
127
 
        uuid VARCHAR(36),
128
 
        architecture VARCHAR(255),
129
 
        mac_address VARCHAR(255),
130
 
        PRIMARY KEY (id),
131
 
        CHECK (locked IN (0, 1)),
132
 
        CHECK (deleted IN (0, 1))
133
 
    );
134
 
 
135
 
    INSERT INTO instances
136
 
        SELECT created_at,
137
 
               updated_at,
138
 
               deleted_at,
139
 
               deleted,
140
 
               id,
141
 
               internal_id,
142
 
               admin_pass,
143
 
               user_id,
144
 
               project_id,
145
 
               image_ref,
146
 
               kernel_id,
147
 
               ramdisk_id,
148
 
               server_name,
149
 
               launch_index,
150
 
               key_name,
151
 
               key_data,
152
 
               state,
153
 
               state_description,
154
 
               memory_mb,
155
 
               vcpus,
156
 
               local_gb,
157
 
               hostname,
158
 
               host,
159
 
               user_data,
160
 
               reservation_id,
161
 
               scheduled_at,
162
 
               launched_at,
163
 
               terminated_at,
164
 
               display_name,
165
 
               display_description,
166
 
               availability_zone,
167
 
               locked,
168
 
               os_type,
169
 
               launched_on,
170
 
               instance_type_id,
171
 
               vm_mode,
172
 
               uuid,
173
 
               architecture,
174
 
               NULL AS mac_address
175
 
        FROM instances_backup;
176
 
 
177
 
    DROP TABLE instances_backup;
178
 
 
179
 
    UPDATE instances SET mac_address=(SELECT address
180
 
                                      FROM virtual_interfaces
181
 
                                      WHERE virtual_interfaces.instance_id = instances.id);
182
 
 
183
 
    CREATE TEMPORARY TABLE networks_backup (
184
 
        created_at DATETIME,
185
 
        updated_at DATETIME,
186
 
        deleted_at DATETIME,
187
 
        deleted BOOLEAN,
188
 
        id INTEGER NOT NULL,
189
 
        injected BOOLEAN,
190
 
        cidr VARCHAR(255),
191
 
        netmask VARCHAR(255),
192
 
        bridge VARCHAR(255),
193
 
        gateway VARCHAR(255),
194
 
        broadcast VARCHAR(255),
195
 
        dns VARCHAR(255),
196
 
        vlan INTEGER,
197
 
        vpn_public_address VARCHAR(255),
198
 
        vpn_public_port INTEGER,
199
 
        vpn_private_address VARCHAR(255),
200
 
        dhcp_start VARCHAR(255),
201
 
        project_id VARCHAR(255),
202
 
        host VARCHAR(255),
203
 
        cidr_v6 VARCHAR(255),
204
 
        gateway_v6 VARCHAR(255),
205
 
        label VARCHAR(255),
206
 
        netmask_v6 VARCHAR(255),
207
 
        bridge_interface VARCHAR(255),
208
 
        PRIMARY KEY (id),
209
 
        CHECK (injected IN (0, 1)),
210
 
        CHECK (deleted IN (0, 1))
211
 
    );
212
 
 
213
 
    INSERT INTO networks_backup
214
 
        SELECT created_at,
215
 
               updated_at,
216
 
               deleted_at,
217
 
               deleted,
218
 
               id,
219
 
               injected,
220
 
               cidr,
221
 
               netmask,
222
 
               bridge,
223
 
               gateway,
224
 
               broadcast,
225
 
               dns,
226
 
               vlan,
227
 
               vpn_public_address,
228
 
               vpn_public_port,
229
 
               vpn_private_address,
230
 
               dhcp_start,
231
 
               project_id,
232
 
               host,
233
 
               cidr_v6,
234
 
               gateway_v6,
235
 
               label,
236
 
               netmask_v6,
237
 
               bridge_interface
238
 
        FROM networks;
239
 
 
240
 
    DROP TABLE networks;
241
 
 
242
 
    CREATE TABLE networks (
243
 
        created_at DATETIME,
244
 
        updated_at DATETIME,
245
 
        deleted_at DATETIME,
246
 
        deleted BOOLEAN,
247
 
        id INTEGER NOT NULL,
248
 
        injected BOOLEAN,
249
 
        cidr VARCHAR(255),
250
 
        netmask VARCHAR(255),
251
 
        bridge VARCHAR(255),
252
 
        gateway VARCHAR(255),
253
 
        broadcast VARCHAR(255),
254
 
        dns VARCHAR(255),
255
 
        vlan INTEGER,
256
 
        vpn_public_address VARCHAR(255),
257
 
        vpn_public_port INTEGER,
258
 
        vpn_private_address VARCHAR(255),
259
 
        dhcp_start VARCHAR(255),
260
 
        project_id VARCHAR(255),
261
 
        host VARCHAR(255),
262
 
        cidr_v6 VARCHAR(255),
263
 
        gateway_v6 VARCHAR(255),
264
 
        label VARCHAR(255),
265
 
        netmask_v6 VARCHAR(255),
266
 
        PRIMARY KEY (id),
267
 
        CHECK (injected IN (0, 1)),
268
 
        CHECK (deleted IN (0, 1))
269
 
    );
270
 
 
271
 
    INSERT INTO networks
272
 
        SELECT created_at,
273
 
               updated_at,
274
 
               deleted_at,
275
 
               deleted,
276
 
               id,
277
 
               injected,
278
 
               cidr,
279
 
               netmask,
280
 
               bridge,
281
 
               gateway,
282
 
               broadcast,
283
 
               dns,
284
 
               vlan,
285
 
               vpn_public_address,
286
 
               vpn_public_port,
287
 
               vpn_private_address,
288
 
               dhcp_start,
289
 
               project_id,
290
 
               host,
291
 
               cidr_v6,
292
 
               gateway_v6,
293
 
               label,
294
 
               netmask_v6
295
 
        FROM networks_backup;
296
 
 
297
 
    DROP TABLE networks_backup;
298
 
 
299
 
    DROP TABLE virtual_interfaces;
300
 
 
301
 
    CREATE TEMPORARY TABLE fixed_ips_backup (
302
 
        created_at DATETIME,
303
 
        updated_at DATETIME,
304
 
        deleted_at DATETIME,
305
 
        deleted BOOLEAN,
306
 
        id INTEGER NOT NULL,
307
 
        address VARCHAR(255),
308
 
        network_id INTEGER,
309
 
        instance_id INTEGER,
310
 
        allocated BOOLEAN,
311
 
        leased BOOLEAN,
312
 
        reserved BOOLEAN,
313
 
        virtual_interface_id INTEGER,
314
 
        PRIMARY KEY (id),
315
 
        CHECK (reserved IN (0, 1)),
316
 
        CHECK (allocated IN (0, 1)),
317
 
        CHECK (leased IN (0, 1)),
318
 
        CHECK (deleted IN (0, 1)),
319
 
        FOREIGN KEY(instance_id) REFERENCES instances (id),
320
 
        FOREIGN KEY(network_id) REFERENCES networks (id)
321
 
    );
322
 
 
323
 
    INSERT INTO fixed_ips_backup
324
 
        SELECT created_at,
325
 
               updated_at,
326
 
               deleted_at,
327
 
               deleted,
328
 
               id,
329
 
               address,
330
 
               network_id,
331
 
               instance_id,
332
 
               allocated,
333
 
               leased,
334
 
               reserved,
335
 
               virtual_interface_id
336
 
        FROM fixed_ips;
337
 
 
338
 
    DROP TABLE fixed_ips;
339
 
 
340
 
    CREATE TABLE fixed_ips (
341
 
        created_at DATETIME,
342
 
        updated_at DATETIME,
343
 
        deleted_at DATETIME,
344
 
        deleted BOOLEAN,
345
 
        id INTEGER NOT NULL,
346
 
        address VARCHAR(255),
347
 
        network_id INTEGER,
348
 
        instance_id INTEGER,
349
 
        allocated BOOLEAN,
350
 
        leased BOOLEAN,
351
 
        reserved BOOLEAN,
352
 
        PRIMARY KEY (id),
353
 
        CHECK (reserved IN (0, 1)),
354
 
        CHECK (allocated IN (0, 1)),
355
 
        CHECK (leased IN (0, 1)),
356
 
        CHECK (deleted IN (0, 1)),
357
 
        FOREIGN KEY(instance_id) REFERENCES instances (id),
358
 
        FOREIGN KEY(network_id) REFERENCES networks (id)
359
 
    );
360
 
 
361
 
    INSERT INTO fixed_ips
362
 
        SELECT created_at,
363
 
               updated_at,
364
 
               deleted_at,
365
 
               deleted,
366
 
               id,
367
 
               address,
368
 
               network_id,
369
 
               instance_id,
370
 
               allocated,
371
 
               leased,
372
 
               reserved
373
 
        FROM fixed_ips_backup;
374
 
 
375
 
    DROP TABLE fixed_ips_backup;
376
 
 
377
 
COMMIT;