← 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/012_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/012_sqlite_upgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE networks_backup (
4
 
        created_at DATETIME,
5
 
        updated_at DATETIME,
6
 
        deleted_at DATETIME,
7
 
        deleted BOOLEAN,
8
 
        id INTEGER NOT NULL,
9
 
        injected BOOLEAN,
10
 
        cidr VARCHAR(255),
11
 
        netmask VARCHAR(255),
12
 
        bridge VARCHAR(255),
13
 
        gateway VARCHAR(255),
14
 
        broadcast VARCHAR(255),
15
 
        dns VARCHAR(255),
16
 
        vlan INTEGER,
17
 
        vpn_public_address VARCHAR(255),
18
 
        vpn_public_port INTEGER,
19
 
        vpn_private_address VARCHAR(255),
20
 
        dhcp_start VARCHAR(255),
21
 
        project_id VARCHAR(255),
22
 
        host VARCHAR(255),
23
 
        cidr_v6 VARCHAR(255),
24
 
        ra_server VARCHAR(255),
25
 
        label VARCHAR(255),
26
 
        PRIMARY KEY (id),
27
 
        CHECK (injected IN (0, 1)),
28
 
        CHECK (deleted IN (0, 1))
29
 
    );
30
 
 
31
 
    INSERT INTO networks_backup
32
 
        SELECT created_at,
33
 
               updated_at,
34
 
               deleted_at,
35
 
               deleted,
36
 
               id,
37
 
               injected,
38
 
               cidr,
39
 
               netmask,
40
 
               bridge,
41
 
               gateway,
42
 
               broadcast,
43
 
               dns,
44
 
               vlan,
45
 
               vpn_public_address,
46
 
               vpn_public_port,
47
 
               vpn_private_address,
48
 
               dhcp_start,
49
 
               project_id,
50
 
               host,
51
 
               cidr_v6,
52
 
               ra_server,
53
 
               label
54
 
        FROM networks;
55
 
 
56
 
    DROP TABLE networks;
57
 
 
58
 
    CREATE TABLE networks (
59
 
        created_at DATETIME,
60
 
        updated_at DATETIME,
61
 
        deleted_at DATETIME,
62
 
        deleted BOOLEAN,
63
 
        id INTEGER NOT NULL,
64
 
        injected BOOLEAN,
65
 
        cidr VARCHAR(255),
66
 
        netmask VARCHAR(255),
67
 
        bridge VARCHAR(255),
68
 
        gateway VARCHAR(255),
69
 
        broadcast VARCHAR(255),
70
 
        dns VARCHAR(255),
71
 
        vlan INTEGER,
72
 
        vpn_public_address VARCHAR(255),
73
 
        vpn_public_port INTEGER,
74
 
        vpn_private_address VARCHAR(255),
75
 
        dhcp_start VARCHAR(255),
76
 
        project_id VARCHAR(255),
77
 
        host VARCHAR(255),
78
 
        cidr_v6 VARCHAR(255),
79
 
        gateway_v6 VARCHAR(255),
80
 
        label VARCHAR(255),
81
 
        netmask_v6 VARCHAR(255),
82
 
        PRIMARY KEY (id),
83
 
        CHECK (injected IN (0, 1)),
84
 
        CHECK (deleted IN (0, 1))
85
 
    );
86
 
 
87
 
    INSERT INTO networks
88
 
        SELECT created_at,
89
 
               updated_at,
90
 
               deleted_at,
91
 
               deleted,
92
 
               id,
93
 
               injected,
94
 
               cidr,
95
 
               netmask,
96
 
               bridge,
97
 
               gateway,
98
 
               broadcast,
99
 
               dns,
100
 
               vlan,
101
 
               vpn_public_address,
102
 
               vpn_public_port,
103
 
               vpn_private_address,
104
 
               dhcp_start,
105
 
               project_id,
106
 
               host,
107
 
               cidr_v6,
108
 
               ra_server AS gateway_v6,
109
 
               label,
110
 
               NULL AS netmask_v6
111
 
        FROM networks_backup;
112
 
 
113
 
    DROP TABLE networks_backup;
114
 
 
115
 
    CREATE TEMPORARY TABLE fixed_ips_backup (
116
 
        created_at DATETIME,
117
 
        updated_at DATETIME,
118
 
        deleted_at DATETIME,
119
 
        deleted BOOLEAN,
120
 
        id INTEGER NOT NULL,
121
 
        address VARCHAR(255),
122
 
        network_id INTEGER,
123
 
        instance_id INTEGER,
124
 
        allocated BOOLEAN,
125
 
        leased BOOLEAN,
126
 
        reserved BOOLEAN,
127
 
        addressV6 VARCHAR(255),
128
 
        netmaskV6 VARCHAR(3),
129
 
        gatewayV6 VARCHAR(255),
130
 
        PRIMARY KEY (id),
131
 
        CHECK (reserved IN (0, 1)),
132
 
        CHECK (allocated IN (0, 1)),
133
 
        CHECK (leased IN (0, 1)),
134
 
        CHECK (deleted IN (0, 1)),
135
 
        FOREIGN KEY(instance_id) REFERENCES instances (id),
136
 
        FOREIGN KEY(network_id) REFERENCES networks (id)
137
 
    );
138
 
 
139
 
    INSERT INTO fixed_ips_backup
140
 
        SELECT created_at,
141
 
               updated_at,
142
 
               deleted_at,
143
 
               deleted,
144
 
               id,
145
 
               address,
146
 
               network_id,
147
 
               instance_id,
148
 
               allocated,
149
 
               leased,
150
 
               reserved,
151
 
               addressV6,
152
 
               netmaskV6,
153
 
               gatewayV6
154
 
        FROM fixed_ips;
155
 
 
156
 
    DROP TABLE fixed_ips;
157
 
 
158
 
    CREATE TABLE fixed_ips (
159
 
        created_at DATETIME,
160
 
        updated_at DATETIME,
161
 
        deleted_at DATETIME,
162
 
        deleted BOOLEAN,
163
 
        id INTEGER NOT NULL,
164
 
        address VARCHAR(255),
165
 
        network_id INTEGER,
166
 
        instance_id INTEGER,
167
 
        allocated BOOLEAN,
168
 
        leased BOOLEAN,
169
 
        reserved BOOLEAN,
170
 
        PRIMARY KEY (id),
171
 
        CHECK (reserved IN (0, 1)),
172
 
        CHECK (allocated IN (0, 1)),
173
 
        CHECK (leased IN (0, 1)),
174
 
        CHECK (deleted IN (0, 1)),
175
 
        FOREIGN KEY(instance_id) REFERENCES instances (id),
176
 
        FOREIGN KEY(network_id) REFERENCES networks (id)
177
 
    );
178
 
 
179
 
    INSERT INTO fixed_ips
180
 
        SELECT created_at,
181
 
               updated_at,
182
 
               deleted_at,
183
 
               deleted,
184
 
               id,
185
 
               address,
186
 
               network_id,
187
 
               instance_id,
188
 
               allocated,
189
 
               leased,
190
 
               reserved
191
 
        FROM fixed_ips_backup;
192
 
 
193
 
    DROP TABLE fixed_ips_backup;
194
 
 
195
 
COMMIT;