← Back to branch summary

~ubuntu-cloud-archive/ubuntu/precise/nova/trunk

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Chuck Short
  • Date: 2012-05-24 13:12:53 UTC
  • mfrom: (1.1.55)
  • Revision ID: package-import@ubuntu.com-20120524131253-ommql08fg1en06ut
Tags: 2012.2~f1-0ubuntu1
https://launchpad.net/bugs/907197
* New upstream release.
* Prepare for quantal:
  - Dropped debian/patches/upstream/0006-Use-project_id-in-ec2.cloud._format_image.patch
  - Dropped debian/patches/upstream/0005-Populate-image-properties-with-project_id-again.patch
  - Dropped debian/patches/upstream/0004-Fixed-bug-962840-added-a-test-case.patch
  - Dropped debian/patches/upstream/0003-Allow-unprivileged-RADOS-users-to-access-rbd-volumes.patch
  - Dropped debian/patches/upstream/0002-Stop-libvirt-test-from-deleting-instances-dir.patch
  - Dropped debian/patches/upstream/0001-fix-bug-where-nova-ignores-glance-host-in-imageref.patch 
  - Dropped debian/patches/0001-fix-useexisting-deprecation-warnings.patch
* debian/control: Add python-keystone as a dependency. (LP: #907197)
* debian/patches/kombu_tests_timeout.patch: Refreshed.
* debian/nova.conf, debian/nova-common.postinst: Convert to new ini
  file configuration
* debian/patches/nova-manage_flagfile_location.patch: Refreshed

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/059_sqlite_upgrade.sql
1
 
BEGIN TRANSACTION;
2
 
 
3
 
    CREATE TEMPORARY TABLE instance_types_backup (
4
 
                created_at DATETIME,
5
 
                updated_at DATETIME,
6
 
                deleted_at DATETIME,
7
 
                deleted BOOLEAN,
8
 
                name VARCHAR(255),
9
 
                id INTEGER NOT NULL,
10
 
                memory_mb INTEGER NOT NULL,
11
 
                vcpus INTEGER NOT NULL,
12
 
                local_gb INTEGER NOT NULL,
13
 
                swap INTEGER NOT NULL,
14
 
                rxtx_factor FLOAT,
15
 
                vcpu_weight INTEGER,
16
 
                flavorid VARCHAR(255),
17
 
                PRIMARY KEY (id),
18
 
                UNIQUE (flavorid),
19
 
                CHECK (deleted IN (0, 1)),
20
 
                UNIQUE (name)
21
 
    );
22
 
 
23
 
    INSERT INTO instance_types_backup
24
 
        SELECT created_at,
25
 
                updated_at,
26
 
                deleted_at,
27
 
                deleted,
28
 
                name,
29
 
                id,
30
 
                memory_mb,
31
 
                vcpus,
32
 
                local_gb,
33
 
                swap,
34
 
                COALESCE(rxtx_cap, 1) / COALESCE ((SELECT  MIN(rxtx_cap)
35
 
                                             FROM instance_types
36
 
                                             WHERE rxtx_cap > 0), 1) as rxtx_cap,
37
 
                vcpu_weight,
38
 
                flavorid
39
 
        FROM instance_types;
40
 
 
41
 
    ALTER TABLE networks ADD COLUMN rxtx_base INTEGER DEFAULT 1;
42
 
 
43
 
    UPDATE networks SET rxtx_base = COALESCE((SELECT MIN(rxtx_cap)
44
 
                                            FROM instance_types
45
 
                                            WHERE rxtx_cap>0), 1);
46
 
 
47
 
    DROP TABLE instance_types;
48
 
 
49
 
    CREATE TABLE instance_types (
50
 
            created_at DATETIME,
51
 
            updated_at DATETIME,
52
 
            deleted_at DATETIME,
53
 
            deleted BOOLEAN,
54
 
            name VARCHAR(255),
55
 
            id INTEGER NOT NULL,
56
 
            memory_mb INTEGER NOT NULL,
57
 
            vcpus INTEGER NOT NULL,
58
 
            local_gb INTEGER NOT NULL,
59
 
            swap INTEGER NOT NULL,
60
 
            rxtx_factor FLOAT,
61
 
            vcpu_weight INTEGER,
62
 
            flavorid VARCHAR(255),
63
 
            PRIMARY KEY (id),
64
 
            UNIQUE (flavorid),
65
 
            CHECK (deleted IN (0, 1)),
66
 
            UNIQUE (name)
67
 
    );
68
 
 
69
 
    INSERT INTO instance_types
70
 
        SELECT created_at,
71
 
               updated_at,
72
 
               deleted_at,
73
 
               deleted,
74
 
               name,
75
 
               id,
76
 
               memory_mb,
77
 
               vcpus,
78
 
               local_gb,
79
 
               swap,
80
 
               rxtx_factor,
81
 
               vcpu_weight,
82
 
               flavorid
83
 
        FROM instance_types_backup;
84
 
 
85
 
    DROP TABLE instance_types_backup;
86
 
 
87
 
COMMIT;