← Back to branch summary

~ubuntu-branches/ubuntu/trusty/cinder/trusty

« back to all changes in this revision

Viewing changes to cinder/db/sqlalchemy/migrate_repo/versions/067_sqlite_downgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short
  • Date: 2012-05-22 09:57:46 UTC
  • Revision ID: package-import@ubuntu.com-20120522095746-9lm71yvzltjybk4b
Tags: upstream-2012.2~f1~20120503.2
Import upstream version 2012.2~f1~20120503.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
cinder/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;