← 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/007_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/007_sqlite_downgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE fixed_ips_backup (
4
 
        id INTEGER NOT NULL,
5
 
        address VARCHAR(255),
6
 
        network_id INTEGER,
7
 
        instance_id INTEGER,
8
 
        allocated BOOLEAN DEFAULT FALSE,
9
 
        leased BOOLEAN DEFAULT FALSE,
10
 
        reserved BOOLEAN DEFAULT FALSE,
11
 
        created_at DATETIME NOT NULL,
12
 
        updated_at DATETIME,
13
 
        deleted_at DATETIME,
14
 
        deleted BOOLEAN NOT NULL,
15
 
        addressV6 VARCHAR(255),
16
 
        netmaskV6 VARCHAR(3),
17
 
        gatewayV6 VARCHAR(255),
18
 
        PRIMARY KEY (id),
19
 
        CHECK (leased IN (0, 1)),
20
 
        CHECK (allocated IN (0, 1)),
21
 
        CHECK (deleted IN (0, 1)),
22
 
        CHECK (reserved IN (0, 1))
23
 
    );
24
 
 
25
 
    INSERT INTO fixed_ips_backup
26
 
        SELECT id,
27
 
               address,
28
 
               network_id,
29
 
               instance_id,
30
 
               allocated,
31
 
               leased,
32
 
               reserved,
33
 
               created_at,
34
 
               updated_at,
35
 
               deleted_at,
36
 
               deleted,
37
 
               addressV6,
38
 
               netmaskV6,
39
 
               gatewayV6
40
 
        FROM fixed_ips;
41
 
 
42
 
    DROP TABLE fixed_ips;
43
 
 
44
 
    CREATE TABLE fixed_ips (
45
 
        id INTEGER NOT NULL,
46
 
        address VARCHAR(255),
47
 
        network_id INTEGER,
48
 
        instance_id INTEGER,
49
 
        allocated BOOLEAN DEFAULT FALSE,
50
 
        leased BOOLEAN DEFAULT FALSE,
51
 
        reserved BOOLEAN DEFAULT FALSE,
52
 
        created_at DATETIME NOT NULL,
53
 
        updated_at DATETIME,
54
 
        deleted_at DATETIME,
55
 
        deleted BOOLEAN NOT NULL,
56
 
        PRIMARY KEY (id),
57
 
        CHECK (leased IN (0, 1)),
58
 
        CHECK (allocated IN (0, 1)),
59
 
        CHECK (deleted IN (0, 1)),
60
 
        CHECK (reserved IN (0, 1))
61
 
    );
62
 
 
63
 
    INSERT INTO fixed_ips
64
 
        SELECT id,
65
 
               address,
66
 
               network_id,
67
 
               instance_id,
68
 
               allocated,
69
 
               leased,
70
 
               reserved,
71
 
               created_at,
72
 
               updated_at,
73
 
               deleted_at,
74
 
               deleted
75
 
        FROM fixed_ips_backup;
76
 
 
77
 
    DROP TABLE fixed_ips_backup;
78
 
 
79
 
COMMIT;