← Back to branch summary

~ubuntu-branches/ubuntu/raring/nova/raring-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Chuck Short, Adam Gandelman, Chuck Short
  • Date: 2012-11-23 09:04:58 UTC
  • mfrom: (1.1.66)
  • Revision ID: package-import@ubuntu.com-20121123090458-91565o7aev1i1h71
Tags: 2013.1~g1-0ubuntu1
https://launchpad.net/bugs/1073289
https://launchpad.net/bugs/1076442
[ Adam Gandelman ]
* debian/control: Ensure novaclient is upgraded with nova,
  require python-keystoneclient >= 1:2.9.0. (LP: #1073289)
* debian/patches/{ubuntu/*, rbd-security.patch}: Dropped, applied
  upstream.
* debian/control: Add python-testtools to Build-Depends.

[ Chuck Short ]
* New upstream version.
* Refreshed debian/patches/avoid_setuptools_git_dependency.patch.
* debian/rules: FTBFS if missing binaries.
* debian/nova-scheudler.install: Add missing rabbit-queues and
  nova-rpc-zmq-receiver.
* Remove nova-volume since it doesnt exist anymore, transition to cinder-*.
* debian/rules: install apport hook in the right place.
* debian/patches/ubuntu-show-tests.patch: Display test failures.
* debian/control: Add depends on genisoimage
* debian/control: Suggest guestmount.
* debian/control: Suggest websockify. (LP: #1076442)
* debian/nova.conf: Disable nova-volume service.
* debian/control: Depend on xen-system-* rather than the hypervisor.
* debian/control, debian/mans/nova-conductor.8, debian/nova-conductor.init,
  debian/nova-conductor.install, debian/nova-conductor.logrotate
  debian/nova-conductor.manpages, debian/nova-conductor.postrm
  debian/nova-conductor.upstart.in: Add nova-conductor service.
* debian/control: Add python-fixtures as a build deps.

Show diffs side-by-side

added added

removed removed

Lines of Context:
nova/db/sqlalchemy/migrate_repo/versions/109_sqlite_upgrade.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
 
    );
38
 
 
39
 
    INSERT INTO dns_domains 
40
 
        SELECT created_at,
41
 
               updated_at,
42
 
               deleted_at,
43
 
               deleted,
44
 
               domain,
45
 
               scope,
46
 
               availability_zone,
47
 
               project_id
48
 
        FROM dns_domains_backup;
49
 
 
50
 
    DROP TABLE dns_domains_backup;
51
 
 
52
 
COMMIT;