← 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/109_sqlite_downgrade.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/109_sqlite_downgrade.sql
 
1
BEGIN TRANSACTION;
 
2
    CREATE TEMPORARY TABLE dns_domains_backup (
 
3
        created_at DATETIME,
 
4
        updated_at DATETIME,
 
5
        deleted_at DATETIME,
 
6
        deleted BOOLEAN,
 
7
        domain VARCHAR(512) NOT NULL,
 
8
        scope VARCHAR(255),
 
9
        availability_zone VARCHAR(255),
 
10
        project_id VARCHAR(255),
 
11
        PRIMARY KEY (domain)
 
12
    );
 
13
 
 
14
    INSERT INTO dns_domains_backup 
 
15
        SELECT created_at,
 
16
               updated_at,
 
17
               deleted_at,
 
18
               deleted,
 
19
               domain,
 
20
               scope,
 
21
               availability_zone,
 
22
               project_id
 
23
        FROM dns_domains;
 
24
 
 
25
    DROP TABLE dns_domains;
 
26
 
 
27
    CREATE TABLE dns_domains (
 
28
        created_at DATETIME,
 
29
        updated_at DATETIME,
 
30
        deleted_at DATETIME,
 
31
        deleted BOOLEAN,
 
32
        domain VARCHAR(512) NOT NULL,
 
33
        scope VARCHAR(255),
 
34
        availability_zone VARCHAR(255),
 
35
        project_id VARCHAR(255),
 
36
        PRIMARY KEY (domain),
 
37
        FOREIGN KEY (project_id) REFERENCES projects (id)
 
38
    );
 
39
 
 
40
    INSERT INTO dns_domains 
 
41
        SELECT created_at,
 
42
               updated_at,
 
43
               deleted_at,
 
44
               deleted,
 
45
               domain,
 
46
               scope,
 
47
               availability_zone,
 
48
               project_id
 
49
        FROM dns_domains_backup;
 
50
 
 
51
    DROP TABLE dns_domains_backup;
 
52
 
 
53
COMMIT;