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