-- Copyright (c) 2001 bivio Software, Inc.  All rights reserved.
--
-- Visit http://www.bivio.biz for more info.
-- 
-- This library is free software; you can redistribute it and/or modify
-- it under the terms of the GNU Lesser General Public License as
-- published by the Free Software Foundation; either version 2.1 of the
-- License, or (at your option) any later version.
-- 
-- This library is distributed in the hope that it will be useful, but
-- WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
-- Lesser General Public License for more details.
-- 
-- You should have received a copy of the GNU Lesser General Public
-- License along with this library;  If not, you may get a copy from:
-- http://www.opensource.org/licenses/lgpl-license.html
-- 
-- $Id: petshop-sequences.sql,v 2.3 2006/10/16 21:08:04 moeller Exp $
--
-- Sequences for bOP PetShop Models
--
--
-- * All sequences are unique for all sites.
--
-- * The five lower order digits are reserved for site and type.
-- * For now, we only have one site, so the lowest order digits are
--   reserved for type and the site is 0.
-- * CACHE 1 is required, because postgres keeps the cache on the
--   client side
--
----------------------------------------------------------------
--
-- Starting at 21.  1-20 is reserved for bOP common Models.
--
CREATE SEQUENCE cart_s
  MINVALUE 100021
  CACHE 1 INCREMENT BY 100000
/

CREATE SEQUENCE cart_item_s
  MINVALUE 100022
  CACHE 1 INCREMENT BY 100000
/

CREATE SEQUENCE order_s
  MINVALUE 100023
  CACHE 1 INCREMENT BY 100000
/