← 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/067_sqlite_downgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short, Monty Taylor, Chuck Short, Joseph Heck
  • Date: 2012-02-24 10:08:10 UTC
  • mfrom: (1.1.46)
  • Revision ID: package-import@ubuntu.com-20120224100810-1wnpdx8c1c43702w
Tags: 2012.1~e4~20120224.12913-0ubuntu1
https://launchpad.net/bugs/879666
[ Monty Taylor ]
* Move files from nova/locale to /usr/share/locale

[ Chuck Short ]
* debian/rules: Fix FTBFS.
* debian/control: Add depends on python-babel.
* debian/control: Add depends on python-iso8601.
* debian/nova-api-os-volume.install: Fix FTBS.
* debian/patches/libvirt-use-console-pipe.patch: Refreshed and 
  Re-enabled. (LP: #879666)
* debian/control: Make sure we install nova-cert

[ Joseph Heck ]
* debian/nova-console.install: Add nova-consoleauth.
* Add nova-api-ec2, nova-api-os-compute, and nova-api-os-volume.

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/067_sqlite_downgrade.sql
 
1
BEGIN TRANSACTION;
 
2
 
 
3
    CREATE TEMPORARY TABLE floating_ips_backup (
 
4
        created_at DATETIME,
 
5
        updated_at DATETIME,
 
6
        deleted_at DATETIME,
 
7
        deleted BOOLEAN,
 
8
        id INTEGER NOT NULL,
 
9
        address VARCHAR(255),
 
10
        fixed_ip_id INTEGER,
 
11
        project_id VARCHAR(255),
 
12
        host VARCHAR(255),
 
13
        auto_assigned BOOLEAN,
 
14
        pool VARCHAR(255),
 
15
        interface VARCHAR(255),
 
16
        PRIMARY KEY (id),
 
17
        CHECK (deleted IN (0, 1)),
 
18
        FOREIGN KEY(fixed_ip_id) REFERENCES fixed_ips (id)
 
19
    );
 
20
 
 
21
    INSERT INTO floating_ips_backup
 
22
        SELECT created_at,
 
23
               updated_at,
 
24
               deleted_at,
 
25
               deleted,
 
26
               id,
 
27
               address,
 
28
               fixed_ip_id,
 
29
               project_id,
 
30
               host,
 
31
               auto_assigned,
 
32
               pool,
 
33
               interface
 
34
        FROM floating_ips;
 
35
 
 
36
    DROP TABLE floating_ips;
 
37
 
 
38
    CREATE TABLE floating_ips (
 
39
        created_at DATETIME,
 
40
        updated_at DATETIME,
 
41
        deleted_at DATETIME,
 
42
        deleted BOOLEAN,
 
43
        id INTEGER NOT NULL,
 
44
        address VARCHAR(255),
 
45
        fixed_ip_id INTEGER,
 
46
        project_id VARCHAR(255),
 
47
        host VARCHAR(255),
 
48
        auto_assigned BOOLEAN,
 
49
        PRIMARY KEY (id),
 
50
        CHECK (deleted IN (0, 1)),
 
51
        FOREIGN KEY(fixed_ip_id) REFERENCES fixed_ips (id)
 
52
    );
 
53
 
 
54
    INSERT INTO floating_ips
 
55
        SELECT created_at,
 
56
               updated_at,
 
57
               deleted_at,
 
58
               deleted,
 
59
               id,
 
60
               address,
 
61
               fixed_ip_id,
 
62
               project_id,
 
63
               host,
 
64
               auto_assigned
 
65
        FROM floating_ips_backup;
 
66
 
 
67
    DROP TABLE floating_ips_backup;
 
68
 
 
69
COMMIT;