← Back to branch summary

~ubuntu-branches/ubuntu/raring/glance/raring-proposed

« back to all changes in this revision

Viewing changes to glance/db/sqlalchemy/migrate_repo/versions/011_sqlite_upgrade.sql

  • Committer: Package Import Robot
  • Author(s): Chuck Short, James Page, Chuck Short
  • Date: 2013-03-20 07:42:22 UTC
  • mfrom: (1.1.50)
  • Revision ID: package-import@ubuntu.com-20130320074222-d8oochgvhjooh1a5
Tags: 1:2013.1~rc1-0ubuntu1
[ James Page ]
* d/watch: Update uversionmangle to deal with upstream versioning
  changes, remove tarballs.openstack.org.

[ Chuck Short ]
* New upstrem release
* debian/control: Clean up build-dependencies:
  - Drop python-argparse referenced in pydist-overrides
  - Drop python-swift no longer needed.
  - Drop python-dateutils no longer needed.
  - Drop python-glacneclient no longer needed.
  - Added python-anyjson to build-depends.
  - Use python-keystoneclient instead of python-keystone.
  - Added python-lxml to build-depends.
  - Added python-swiftclientto build-depends.
  - Added python-passlib to build-depends.
* debian/rules: Set the PYTHONPATH for the tests.

Show diffs side-by-side

added added

removed removed

Lines of Context:
glance/db/sqlalchemy/migrate_repo/versions/011_sqlite_upgrade.sql
 
1
BEGIN TRANSACTION;
 
2
 
 
3
CREATE TEMPORARY TABLE images_backup (
 
4
    id INTEGER NOT NULL,
 
5
    name VARCHAR(255),
 
6
    size INTEGER,
 
7
    status VARCHAR(30) NOT NULL,
 
8
    is_public BOOLEAN NOT NULL,
 
9
    location TEXT,
 
10
    created_at DATETIME NOT NULL,
 
11
    updated_at DATETIME,
 
12
    deleted_at DATETIME,
 
13
    deleted BOOLEAN NOT NULL,
 
14
    disk_format VARCHAR(20),
 
15
    container_format VARCHAR(20),
 
16
    checksum VARCHAR(32),
 
17
    owner VARCHAR(255),
 
18
    min_disk INTEGER,
 
19
    min_ram INTEGER,
 
20
    PRIMARY KEY (id),
 
21
    CHECK (is_public IN (0, 1)),
 
22
    CHECK (deleted IN (0, 1))
 
23
);
 
24
 
 
25
INSERT INTO images_backup
 
26
SELECT id, name, size, status, is_public, location, created_at, updated_at, deleted_at, deleted, disk_format, container_format, checksum, owner, min_disk, min_ram
 
27
FROM images;
 
28
 
 
29
DROP TABLE images;
 
30
 
 
31
CREATE TABLE images (
 
32
    id INTEGER NOT NULL,
 
33
    name VARCHAR(255),
 
34
    size INTEGER,
 
35
    status VARCHAR(30) NOT NULL,
 
36
    is_public BOOLEAN NOT NULL,
 
37
    location TEXT,
 
38
    created_at DATETIME NOT NULL,
 
39
    updated_at DATETIME,
 
40
    deleted_at DATETIME,
 
41
    deleted BOOLEAN NOT NULL,
 
42
    disk_format VARCHAR(20),
 
43
    container_format VARCHAR(20),
 
44
    checksum VARCHAR(32),
 
45
    owner VARCHAR(255),
 
46
    min_disk INTEGER NOT NULL,
 
47
    min_ram INTEGER NOT NULL,
 
48
    PRIMARY KEY (id),
 
49
    CHECK (is_public IN (0, 1)),
 
50
    CHECK (deleted IN (0, 1))
 
51
);
 
52
 
 
53
CREATE INDEX ix_images_deleted ON images (deleted);
 
54
CREATE INDEX ix_images_is_public ON images (is_public);
 
55
 
 
56
 
 
57
INSERT INTO images
 
58
SELECT id, name, size, status, is_public, location, created_at, updated_at,     deleted_at, deleted, disk_format, container_format, checksum, owner, min_disk,  min_ram
 
59
FROM images_backup;
 
60
 
 
61
DROP TABLE images_backup;
 
62
COMMIT;