--
-- Copyright (C) 2002-2004 Red Hat Inc. All Rights Reserved.
--
-- The contents of this file are subject to the CCM Public
-- License (the "License"); you may not use this file except in
-- compliance with the License. You may obtain a copy of the
-- License at http://www.redhat.com/licenses/ccmpl.html.
--
-- Software distributed under the License is distributed on an
-- "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express
-- or implied. See the License for the specific language governing
-- rights and limitations under the License.
--
-- $Id: //core-platform/dev/test/src/com/arsdigita/test/ddl/canonical/postgres/table-application_types-auto.sql#3 $
-- $DateTime: 2004/04/07 16:07:11 $
create table application_types (
    application_type_id INTEGER not null
        constraint appli_typ_appli_typ_id_p_r5e8o
          primary key,
    description VARCHAR(4000),
    has_embedded_view_p BOOLEAN,
    has_full_page_view_p BOOLEAN,
    object_type VARCHAR(100) not null
        constraint applicat_typ_obje_type_u_pf2uk
          unique,
    package_type_id INTEGER,
        -- referential constraint for package_type_id deferred due to circular dependencies
    profile VARCHAR(20),
    provider_id INTEGER,
        -- referential constraint for provider_id deferred due to circular dependencies
    singleton_p BOOLEAN,
    title VARCHAR(200),
    workspace_application_p BOOLEAN
);
