← Back to branch summary

~ubuntu-branches/ubuntu/quantal/nova/quantal-proposed

« back to all changes in this revision

Viewing changes to nova/db/sqlalchemy/migrate_repo/versions/113_sqlite_upgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short
  • Date: 2012-08-16 14:04:11 UTC
  • mto: This revision was merged to the branch mainline in revision 84.
  • Revision ID: package-import@ubuntu.com-20120816140411-0mr4n241wmk30t9l
Tags: upstream-2012.2~f3
Import upstream version 2012.2~f3

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/113_sqlite_upgrade.sql
 
1
BEGIN TRANSACTION;
 
2
    CREATE TEMPORARY TABLE fixed_ips_backup (
 
3
        created_at DATETIME,
 
4
        updated_at DATETIME,
 
5
        deleted_at DATETIME,
 
6
        deleted BOOLEAN,
 
7
        id INTEGER NOT NULL,
 
8
        address VARCHAR(255),
 
9
        network_id INTEGER,
 
10
        instance_id INTEGER NOT NULL,
 
11
        instance_uuid VARCHAR(36),
 
12
        allocated BOOLEAN,
 
13
        leased BOOLEAN,
 
14
        reserved BOOLEAN,
 
15
        virtual_interface_id INTEGER,
 
16
        host VARCHAR(255),
 
17
        PRIMARY KEY (id)
 
18
    );
 
19
 
 
20
    INSERT INTO fixed_ips_backup
 
21
        SELECT created_at,
 
22
               updated_at,
 
23
               deleted_at,
 
24
               deleted,
 
25
               id,
 
26
               address,
 
27
               network_id,
 
28
               instance_id,
 
29
               NULL,
 
30
               allocated,
 
31
               leased,
 
32
               reserved,
 
33
               virtual_interface_id,
 
34
               host
 
35
        FROM fixed_ips;
 
36
 
 
37
    UPDATE fixed_ips_backup
 
38
        SET instance_uuid=
 
39
            (SELECT uuid
 
40
                 FROM instances
 
41
                 WHERE fixed_ips_backup.instance_id = instances.id
 
42
    );
 
43
 
 
44
    DROP TABLE fixed_ips;
 
45
 
 
46
    CREATE TABLE fixed_ips (
 
47
        created_at DATETIME,
 
48
        updated_at DATETIME,
 
49
        deleted_at DATETIME,
 
50
        deleted BOOLEAN,
 
51
        id INTEGER NOT NULL,
 
52
        address VARCHAR(255),
 
53
        network_id INTEGER,
 
54
        instance_uuid VARCHAR(36),
 
55
        allocated BOOLEAN,
 
56
        leased BOOLEAN,
 
57
        reserved BOOLEAN,
 
58
        virtual_interface_id INTEGER,
 
59
        host VARCHAR(255),
 
60
        PRIMARY KEY (id),
 
61
        FOREIGN KEY(instance_uuid) REFERENCES instances (uuid)
 
62
    );
 
63
 
 
64
    CREATE INDEX fixed_ips_id ON fixed_ips(id);
 
65
    CREATE INDEX address ON fixed_ips(address);
 
66
 
 
67
    INSERT INTO fixed_ips
 
68
        SELECT created_at,
 
69
               updated_at,
 
70
               deleted_at,
 
71
               deleted,
 
72
               id,
 
73
               address,
 
74
               network_id,
 
75
               instance_uuid,
 
76
               allocated,
 
77
               leased,
 
78
               reserved,
 
79
               virtual_interface_id,
 
80
               host
 
81
        FROM fixed_ips_backup;
 
82
 
 
83
    DROP TABLE fixed_ips_backup;
 
84
 
 
85
COMMIT;