postgresql schema has leftover zones sequence (should be cells now)

[Dan Prince]

Using Nova w/ PostgreSQL. It looks like we have a leftover zones sequence that needs to be renamed to its 'cell' equivalent:

--
-- Name: zones_id_seq; Type: SEQUENCE; Schema: public;
--

CREATE SEQUENCE zones_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER TABLE public.zones_id_seq

--
-- Name: zones_id_seq; Type: SEQUENCE OWNED BY; Schema: public;
--

ALTER SEQUENCE zones_id_seq OWNED BY cells.id;

--
-- Name: zones_id_seq; Type: SEQUENCE SET; Schema: public;
--

SELECT pg_catalog.setval('zones_id_seq', 1, false);

---------------------------

When renaming tables in our SQLAlchemy script we'll need to be mindful that this leaves behind orphaned sequences on PostgreSQL.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/7154

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/7154
Committed: http://github.com/openstack/nova/commit/190775d5ea82364ad1baf2471cd453032e9c60de
Submitter: Jenkins
Branch: master

commit 190775d5ea82364ad1baf2471cd453032e9c60de
Author: Dan Prince <email address hidden>
Date: Sat May 5 13:55:45 2012 -0400

    Update PostgreSQL sequence names for zones/quotas.

    Fixes LP Bug #993667.
    Fixes LP Bug #993669.

    Change-Id: Ifcc33929ced617916bd6613fc941257494f4a99b