← Back to branch summary

~ed-leafe/nova/os-hosts-restful-api

« back to all changes in this revision

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

  • Committer: Tarmac
  • Author(s): Jason Kölker, Trey Morris, Jason Koelker, Cerberus
  • Date: 2011-06-30 20:47:11 UTC
  • mfrom: (742.1.131 multi_nic)
  • Revision ID: tarmac-20110630204711-37fz9pyzyy76ju3e
added multi-nic support

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/031_sqlite_downgrade.sql
 
1
BEGIN TRANSACTION;
 
2
 
 
3
    CREATE TEMPORARY TABLE fixed_ips_backup (
 
4
        id INTEGER NOT NULL,
 
5
        address VARCHAR(255),
 
6
        virtual_interface_id INTEGER,
 
7
        network_id INTEGER,
 
8
        instance_id INTEGER,
 
9
        allocated BOOLEAN default FALSE,
 
10
        leased BOOLEAN default FALSE,
 
11
        reserved BOOLEAN default FALSE,
 
12
        created_at DATETIME NOT NULL,
 
13
        updated_at DATETIME,
 
14
        deleted_at DATETIME,
 
15
        deleted BOOLEAN NOT NULL,
 
16
        PRIMARY KEY (id),
 
17
        FOREIGN KEY(virtual_interface_id) REFERENCES virtual_interfaces (id)
 
18
    );
 
19
 
 
20
    INSERT INTO fixed_ips_backup
 
21
    SELECT id, address, virtual_interface_id, network_id, instance_id, allocated, leased, reserved, created_at, updated_at, deleted_at, deleted
 
22
    FROM fixed_ips;
 
23
 
 
24
    DROP TABLE fixed_ips;
 
25
 
 
26
    CREATE TABLE fixed_ips (
 
27
        id INTEGER NOT NULL,
 
28
        address VARCHAR(255),
 
29
        virtual_interface_id INTEGER,
 
30
        network_id INTEGER,
 
31
        instance_id INTEGER,
 
32
        allocated BOOLEAN default FALSE,
 
33
        leased BOOLEAN default FALSE,
 
34
        reserved BOOLEAN default FALSE,
 
35
        created_at DATETIME NOT NULL,
 
36
        updated_at DATETIME,
 
37
        deleted_at DATETIME,
 
38
        deleted BOOLEAN NOT NULL,
 
39
        PRIMARY KEY (id)
 
40
    );
 
41
 
 
42
    INSERT INTO fixed_ips
 
43
    SELECT id, address, virtual_interface_id, network_id, instance_id, allocated, leased, reserved, created_at, updated_at, deleted_at, deleted
 
44
    FROM fixed_ips;
 
45
 
 
46
    DROP TABLE fixed_ips_backup;
 
47
 
 
48
COMMIT;