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