← Back to branch summary

~ubuntu-branches/ubuntu/raring/nova/raring-proposed

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/138_sqlite_downgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short, Adam Gandelman, Chuck Short
  • Date: 2012-11-23 09:04:58 UTC
  • mfrom: (1.1.66)
  • Revision ID: package-import@ubuntu.com-20121123090458-91565o7aev1i1h71
Tags: 2013.1~g1-0ubuntu1
https://launchpad.net/bugs/1073289
https://launchpad.net/bugs/1076442
[ Adam Gandelman ]
* debian/control: Ensure novaclient is upgraded with nova,
  require python-keystoneclient >= 1:2.9.0. (LP: #1073289)
* debian/patches/{ubuntu/*, rbd-security.patch}: Dropped, applied
  upstream.
* debian/control: Add python-testtools to Build-Depends.

[ Chuck Short ]
* New upstream version.
* Refreshed debian/patches/avoid_setuptools_git_dependency.patch.
* debian/rules: FTBFS if missing binaries.
* debian/nova-scheudler.install: Add missing rabbit-queues and
  nova-rpc-zmq-receiver.
* Remove nova-volume since it doesnt exist anymore, transition to cinder-*.
* debian/rules: install apport hook in the right place.
* debian/patches/ubuntu-show-tests.patch: Display test failures.
* debian/control: Add depends on genisoimage
* debian/control: Suggest guestmount.
* debian/control: Suggest websockify. (LP: #1076442)
* debian/nova.conf: Disable nova-volume service.
* debian/control: Depend on xen-system-* rather than the hypervisor.
* debian/control, debian/mans/nova-conductor.8, debian/nova-conductor.init,
  debian/nova-conductor.install, debian/nova-conductor.logrotate
  debian/nova-conductor.manpages, debian/nova-conductor.postrm
  debian/nova-conductor.upstart.in: Add nova-conductor service.
* debian/control: Add python-fixtures as a build deps.

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/138_sqlite_downgrade.sql
 
1
BEGIN TRANSACTION;
 
2
    CREATE TEMPORARY TABLE instances_backup (
 
3
        created_at DATETIME,
 
4
        updated_at DATETIME,
 
5
        deleted_at DATETIME,
 
6
        deleted BOOLEAN,
 
7
        id INTEGER NOT NULL,
 
8
        internal_id INTEGER,
 
9
        user_id VARCHAR(255),
 
10
        project_id VARCHAR(255),
 
11
        image_ref VARCHAR(255),
 
12
        kernel_id VARCHAR(255),
 
13
        ramdisk_id VARCHAR(255),
 
14
        launch_index INTEGER,
 
15
        key_name VARCHAR(255),
 
16
        key_data TEXT,
 
17
        power_state INTEGER,
 
18
        vm_state VARCHAR(255),
 
19
        memory_mb INTEGER,
 
20
        vcpus INTEGER,
 
21
        hostname VARCHAR(255),
 
22
        host VARCHAR(255),
 
23
        user_data TEXT,
 
24
        reservation_id VARCHAR(255),
 
25
        scheduled_at DATETIME,
 
26
        launched_at DATETIME,
 
27
        terminated_at DATETIME,
 
28
        display_name VARCHAR(255),
 
29
        display_description VARCHAR(255),
 
30
        availability_zone VARCHAR(255),
 
31
        locked BOOLEAN,
 
32
        os_type VARCHAR(255),
 
33
        launched_on TEXT,
 
34
        instance_type_id INTEGER,
 
35
        vm_mode VARCHAR(255),
 
36
        uuid VARCHAR(36),
 
37
        architecture VARCHAR(255),
 
38
        root_device_name VARCHAR(255),
 
39
        access_ip_v4 VARCHAR(255),
 
40
        access_ip_v6 VARCHAR(255),
 
41
        config_drive VARCHAR(255),
 
42
        task_state VARCHAR(255),
 
43
        default_ephemeral_device VARCHAR(255),
 
44
        default_swap_device VARCHAR(255),
 
45
        progress INTEGER,
 
46
        auto_disk_config BOOLEAN,
 
47
        shutdown_terminate BOOLEAN,
 
48
        disable_terminate BOOLEAN,
 
49
        root_gb INTEGER,
 
50
        ephemeral_gb INTEGER,
 
51
        cell_name VARCHAR(255),
 
52
        node VARCHAR(255),
 
53
        PRIMARY KEY (id)
 
54
    );
 
55
 
 
56
    INSERT INTO instances_backup
 
57
        SELECT created_at,
 
58
               updated_at,
 
59
               deleted_at,
 
60
               deleted,
 
61
               id,
 
62
               internal_id,
 
63
               user_id,
 
64
               project_id,
 
65
               image_ref,
 
66
               kernel_id,
 
67
               ramdisk_id,
 
68
               launch_index,
 
69
               key_name,
 
70
               key_data,
 
71
               power_state,
 
72
               vm_state,
 
73
               memory_mb,
 
74
               vcpus,
 
75
               hostname,
 
76
               host,
 
77
               user_data,
 
78
               reservation_id,
 
79
               scheduled_at,
 
80
               launched_at,
 
81
               terminated_at,
 
82
               display_name,
 
83
               display_description,
 
84
               availability_zone,
 
85
               locked,
 
86
               os_type,
 
87
               launched_on,
 
88
               instance_type_id,
 
89
               vm_mode,
 
90
               uuid,
 
91
               architecture,
 
92
               root_device_name,
 
93
               access_ip_v4,
 
94
               access_ip_v6,
 
95
               config_drive,
 
96
               task_state,
 
97
               default_ephemeral_device,
 
98
               default_swap_device,
 
99
               progress,
 
100
               auto_disk_config,
 
101
               shutdown_terminate,
 
102
               disable_terminate,
 
103
               root_gb,
 
104
               ephemeral_gb,
 
105
               cell_name,
 
106
               node
 
107
        FROM instances;
 
108
 
 
109
    DROP TABLE instances;
 
110
 
 
111
    CREATE TABLE instances (
 
112
        created_at DATETIME,
 
113
        updated_at DATETIME,
 
114
        deleted_at DATETIME,
 
115
        deleted BOOLEAN,
 
116
        id INTEGER NOT NULL,
 
117
        internal_id INTEGER,
 
118
        user_id VARCHAR(255),
 
119
        project_id VARCHAR(255),
 
120
        image_ref VARCHAR(255),
 
121
        kernel_id VARCHAR(255),
 
122
        ramdisk_id VARCHAR(255),
 
123
        server_name VARCHAR(255),
 
124
        launch_index INTEGER,
 
125
        key_name VARCHAR(255),
 
126
        key_data TEXT,
 
127
        power_state INTEGER,
 
128
        vm_state VARCHAR(255),
 
129
        memory_mb INTEGER,
 
130
        vcpus INTEGER,
 
131
        hostname VARCHAR(255),
 
132
        host VARCHAR(255),
 
133
        user_data TEXT,
 
134
        reservation_id VARCHAR(255),
 
135
        scheduled_at DATETIME,
 
136
        launched_at DATETIME,
 
137
        terminated_at DATETIME,
 
138
        display_name VARCHAR(255),
 
139
        display_description VARCHAR(255),
 
140
        availability_zone VARCHAR(255),
 
141
        locked BOOLEAN,
 
142
        os_type VARCHAR(255),
 
143
        launched_on TEXT,
 
144
        instance_type_id INTEGER,
 
145
        vm_mode VARCHAR(255),
 
146
        uuid VARCHAR(36),
 
147
        architecture VARCHAR(255),
 
148
        root_device_name VARCHAR(255),
 
149
        access_ip_v4 VARCHAR(255),
 
150
        access_ip_v6 VARCHAR(255),
 
151
        config_drive VARCHAR(255),
 
152
        task_state VARCHAR(255),
 
153
        default_ephemeral_device VARCHAR(255),
 
154
        default_swap_device VARCHAR(255),
 
155
        progress INTEGER,
 
156
        auto_disk_config BOOLEAN,
 
157
        shutdown_terminate BOOLEAN,
 
158
        disable_terminate BOOLEAN,
 
159
        root_gb INTEGER,
 
160
        ephemeral_gb INTEGER,
 
161
        cell_name VARCHAR(255),
 
162
        node VARCHAR(255),
 
163
        PRIMARY KEY (id)
 
164
    );
 
165
 
 
166
    CREATE INDEX instances_host_node_deleted_idx
 
167
        ON instances (host, node, deleted);
 
168
 
 
169
    CREATE INDEX instances_host_deleted_idx
 
170
        ON instances (host, deleted);
 
171
 
 
172
    CREATE INDEX instances_reservation_id_idx
 
173
        ON instances (reservation_id);
 
174
 
 
175
    CREATE INDEX instances_terminated_at_launched_at_idx
 
176
        ON instances (terminated_at, launched_at);
 
177
 
 
178
    CREATE INDEX instances_uuid_deleted_idx
 
179
        ON instances (uuid, deleted);
 
180
 
 
181
    CREATE INDEX instances_task_state_updated_at_idx
 
182
        ON instances (task_state, updated_at);
 
183
 
 
184
    INSERT INTO instances
 
185
        SELECT created_at,
 
186
               updated_at,
 
187
               deleted_at,
 
188
               deleted,
 
189
               id,
 
190
               internal_id,
 
191
               user_id,
 
192
               project_id,
 
193
               image_ref,
 
194
               kernel_id,
 
195
               ramdisk_id,
 
196
               hostname,
 
197
               launch_index,
 
198
               key_name,
 
199
               key_data,
 
200
               power_state,
 
201
               vm_state,
 
202
               memory_mb,
 
203
               vcpus,
 
204
               hostname,
 
205
               host,
 
206
               user_data,
 
207
               reservation_id,
 
208
               scheduled_at,
 
209
               launched_at,
 
210
               terminated_at,
 
211
               display_name,
 
212
               display_description,
 
213
               availability_zone,
 
214
               locked,
 
215
               os_type,
 
216
               launched_on,
 
217
               instance_type_id,
 
218
               vm_mode,
 
219
               uuid,
 
220
               architecture,
 
221
               root_device_name,
 
222
               access_ip_v4,
 
223
               access_ip_v6,
 
224
               config_drive,
 
225
               task_state,
 
226
               default_ephemeral_device,
 
227
               default_swap_device,
 
228
               progress,
 
229
               auto_disk_config,
 
230
               shutdown_terminate,
 
231
               disable_terminate,
 
232
               root_gb,
 
233
               ephemeral_gb,
 
234
               cell_name,
 
235
               node
 
236
        FROM instances_backup;
 
237
 
 
238
    DROP TABLE instances_backup;
 
239
COMMIT;