← 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/074_sqlite_upgrade.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/074_sqlite_upgrade.sql
1
 
 
2
 
BEGIN TRANSACTION;
3
 
    -- make backup of instance_types
4
 
    CREATE TEMPORARY TABLE instance_types_backup (
5
 
        created_at DATETIME,
6
 
        updated_at DATETIME,
7
 
        deleted_at DATETIME,
8
 
        deleted BOOLEAN,
9
 
        name VARCHAR(255),
10
 
        id INTEGER NOT NULL,
11
 
        memory_mb INTEGER NOT NULL,
12
 
        vcpus INTEGER NOT NULL,
13
 
        local_gb INTEGER NOT NULL,
14
 
        swap INTEGER NOT NULL,
15
 
        rxtx_factor FLOAT,
16
 
        vcpu_weight INTEGER,
17
 
        flavorid VARCHAR(255),
18
 
        PRIMARY KEY (id),
19
 
        UNIQUE (flavorid),
20
 
        CHECK (deleted IN (0, 1)),
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
 
               rxtx_factor,
36
 
               vcpu_weight,
37
 
               flavorid
38
 
        FROM instance_types;
39
 
 
40
 
    DROP TABLE instance_types;
41
 
 
42
 
    CREATE TABLE instance_types (
43
 
        created_at DATETIME,
44
 
        updated_at DATETIME,
45
 
        deleted_at DATETIME,
46
 
        deleted BOOLEAN,
47
 
        name VARCHAR(255),
48
 
        id INTEGER NOT NULL,
49
 
        memory_mb INTEGER NOT NULL,
50
 
        vcpus INTEGER NOT NULL,
51
 
        root_gb INTEGER NOT NULL,
52
 
        ephemeral_gb INTEGER NOT NULL,
53
 
        swap INTEGER NOT NULL,
54
 
        rxtx_factor FLOAT,
55
 
        vcpu_weight INTEGER,
56
 
        flavorid VARCHAR(255),
57
 
        PRIMARY KEY (id),
58
 
        UNIQUE (flavorid),
59
 
        CHECK (deleted IN (0, 1)),
60
 
        UNIQUE (name)
61
 
    );
62
 
 
63
 
    -- copy from backup to new table with root_gb set to local_gb and
64
 
    -- ephmeral_gb set to 0
65
 
    INSERT INTO instance_types
66
 
        SELECT created_at,
67
 
               updated_at,
68
 
               deleted_at,
69
 
               deleted,
70
 
               name,
71
 
               id,
72
 
               memory_mb,
73
 
               vcpus,
74
 
               local_gb,
75
 
               0,
76
 
               swap,
77
 
               rxtx_factor,
78
 
               vcpu_weight,
79
 
               flavorid
80
 
        FROM instance_types_backup;
81
 
 
82
 
    DROP TABLE instance_types_backup;
83
 
 
84
 
    -- make backup of instances
85
 
    CREATE TEMPORARY TABLE instances_backup (
86
 
        created_at DATETIME,
87
 
        updated_at DATETIME,
88
 
        deleted_at DATETIME,
89
 
        deleted BOOLEAN,
90
 
        id INTEGER NOT NULL,
91
 
        internal_id INTEGER,
92
 
        user_id VARCHAR(255),
93
 
        project_id VARCHAR(255),
94
 
        image_ref VARCHAR(255),
95
 
        kernel_id VARCHAR(255),
96
 
        ramdisk_id VARCHAR(255),
97
 
        server_name VARCHAR(255),
98
 
        launch_index INTEGER,
99
 
        key_name VARCHAR(255),
100
 
        key_data TEXT,
101
 
        power_state INTEGER,
102
 
        vm_state VARCHAR(255),
103
 
        memory_mb INTEGER,
104
 
        vcpus INTEGER,
105
 
        local_gb INTEGER,
106
 
        hostname VARCHAR(255),
107
 
        host VARCHAR(255),
108
 
        user_data TEXT,
109
 
        reservation_id VARCHAR(255),
110
 
        scheduled_at DATETIME,
111
 
        launched_at DATETIME,
112
 
        terminated_at DATETIME,
113
 
        display_name VARCHAR(255),
114
 
        display_description VARCHAR(255),
115
 
        availability_zone VARCHAR(255),
116
 
        locked BOOLEAN,
117
 
        os_type VARCHAR(255),
118
 
        launched_on TEXT,
119
 
        instance_type_id INTEGER,
120
 
        vm_mode VARCHAR(255),
121
 
        uuid VARCHAR(36),
122
 
        architecture VARCHAR(255),
123
 
        root_device_name VARCHAR(255),
124
 
        access_ip_v4 VARCHAR(255),
125
 
        access_ip_v6 VARCHAR(255),
126
 
        config_drive VARCHAR(255),
127
 
        task_state VARCHAR(255),
128
 
        default_local_device VARCHAR(255),
129
 
        default_swap_device VARCHAR(255),
130
 
        progress INTEGER,
131
 
        auto_disk_config BOOLEAN,
132
 
        shutdown_terminate BOOLEAN,
133
 
        disable_terminate BOOLEAN,
134
 
        PRIMARY KEY (id),
135
 
        CHECK (deleted IN (0, 1)),
136
 
        CHECK (locked IN (0, 1)),
137
 
        CHECK (auto_disk_config IN (0, 1)),
138
 
        CHECK (shutdown_terminate IN (0, 1)),
139
 
        CHECK (disable_terminate IN (0, 1))
140
 
    );
141
 
 
142
 
    INSERT INTO instances_backup
143
 
        SELECT created_at,
144
 
               updated_at,
145
 
               deleted_at,
146
 
               deleted,
147
 
               id,
148
 
               internal_id,
149
 
               user_id,
150
 
               project_id,
151
 
               image_ref,
152
 
               kernel_id,
153
 
               ramdisk_id,
154
 
               server_name,
155
 
               launch_index,
156
 
               key_name,
157
 
               key_data,
158
 
               power_state,
159
 
               vm_state,
160
 
               memory_mb,
161
 
               vcpus,
162
 
               local_gb,
163
 
               hostname,
164
 
               host,
165
 
               user_data,
166
 
               reservation_id,
167
 
               scheduled_at,
168
 
               launched_at,
169
 
               terminated_at,
170
 
               display_name,
171
 
               display_description,
172
 
               availability_zone,
173
 
               locked,
174
 
               os_type,
175
 
               launched_on,
176
 
               instance_type_id,
177
 
               vm_mode,
178
 
               uuid,
179
 
               architecture,
180
 
               root_device_name,
181
 
               access_ip_v4,
182
 
               access_ip_v6,
183
 
               config_drive,
184
 
               task_state,
185
 
               default_local_device,
186
 
               default_swap_device,
187
 
               progress,
188
 
               auto_disk_config,
189
 
               shutdown_terminate,
190
 
               disable_terminate
191
 
        FROM instances;
192
 
 
193
 
    DROP TABLE instances;
194
 
 
195
 
    CREATE TABLE instances (
196
 
        created_at DATETIME,
197
 
        updated_at DATETIME,
198
 
        deleted_at DATETIME,
199
 
        deleted BOOLEAN,
200
 
        id INTEGER NOT NULL,
201
 
        internal_id INTEGER,
202
 
        user_id VARCHAR(255),
203
 
        project_id VARCHAR(255),
204
 
        image_ref VARCHAR(255),
205
 
        kernel_id VARCHAR(255),
206
 
        ramdisk_id VARCHAR(255),
207
 
        server_name VARCHAR(255),
208
 
        launch_index INTEGER,
209
 
        key_name VARCHAR(255),
210
 
        key_data TEXT,
211
 
        power_state INTEGER,
212
 
        vm_state VARCHAR(255),
213
 
        memory_mb INTEGER,
214
 
        vcpus INTEGER,
215
 
        root_gb INTEGER,
216
 
        ephemeral_gb INTEGER,
217
 
        hostname VARCHAR(255),
218
 
        host VARCHAR(255),
219
 
        user_data TEXT,
220
 
        reservation_id VARCHAR(255),
221
 
        scheduled_at DATETIME,
222
 
        launched_at DATETIME,
223
 
        terminated_at DATETIME,
224
 
        display_name VARCHAR(255),
225
 
        display_description VARCHAR(255),
226
 
        availability_zone VARCHAR(255),
227
 
        locked BOOLEAN,
228
 
        os_type VARCHAR(255),
229
 
        launched_on TEXT,
230
 
        instance_type_id INTEGER,
231
 
        vm_mode VARCHAR(255),
232
 
        uuid VARCHAR(36),
233
 
        architecture VARCHAR(255),
234
 
        root_device_name VARCHAR(255),
235
 
        access_ip_v4 VARCHAR(255),
236
 
        access_ip_v6 VARCHAR(255),
237
 
        config_drive VARCHAR(255),
238
 
        task_state VARCHAR(255),
239
 
        default_ephemeral_device VARCHAR(255),
240
 
        default_swap_device VARCHAR(255),
241
 
        progress INTEGER,
242
 
        auto_disk_config BOOLEAN,
243
 
        shutdown_terminate BOOLEAN,
244
 
        disable_terminate BOOLEAN,
245
 
        PRIMARY KEY (id),
246
 
        CHECK (deleted IN (0, 1)),
247
 
        CHECK (locked IN (0, 1)),
248
 
        CHECK (auto_disk_config IN (0, 1)),
249
 
        CHECK (shutdown_terminate IN (0, 1)),
250
 
        CHECK (disable_terminate IN (0, 1))
251
 
    );
252
 
 
253
 
    CREATE INDEX project_id ON instances (project_id);
254
 
    CREATE UNIQUE INDEX uuid ON instances (uuid);
255
 
 
256
 
    -- copy from backup to new table with root_gb set to local_gb and
257
 
    -- ephmeral_gb set to 0
258
 
    INSERT INTO instances
259
 
        SELECT created_at,
260
 
               updated_at,
261
 
               deleted_at,
262
 
               deleted,
263
 
               id,
264
 
               internal_id,
265
 
               user_id,
266
 
               project_id,
267
 
               image_ref,
268
 
               kernel_id,
269
 
               ramdisk_id,
270
 
               server_name,
271
 
               launch_index,
272
 
               key_name,
273
 
               key_data,
274
 
               power_state,
275
 
               vm_state,
276
 
               memory_mb,
277
 
               vcpus,
278
 
               local_gb,
279
 
               0,
280
 
               hostname,
281
 
               host,
282
 
               user_data,
283
 
               reservation_id,
284
 
               scheduled_at,
285
 
               launched_at,
286
 
               terminated_at,
287
 
               display_name,
288
 
               display_description,
289
 
               availability_zone,
290
 
               locked,
291
 
               os_type,
292
 
               launched_on,
293
 
               instance_type_id,
294
 
               vm_mode,
295
 
               uuid,
296
 
               architecture,
297
 
               root_device_name,
298
 
               access_ip_v4,
299
 
               access_ip_v6,
300
 
               config_drive,
301
 
               task_state,
302
 
               default_local_device,
303
 
               default_swap_device,
304
 
               progress,
305
 
               auto_disk_config,
306
 
               shutdown_terminate,
307
 
               disable_terminate
308
 
        FROM instances_backup;
309
 
 
310
 
    DROP TABLE instances_backup;
311
 
COMMIT;