--
-- 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: //cms/dev/sql/ccm-cms/postgres-create.sql#10 $
-- $DateTime: 2004/04/07 16:07:11 $

\i ddl/postgres/create.sql

\i default/content-section/table-cms_privileges.sql
\i default/content-section/cms-privileges.sql
\i default/content-section/insert-privileges.sql
\i default/content-section/index-phase_def_cycle_definition_idx.sql
\i default/content-section/index-lifecycles_definition_id_idx.sql
\i default/content-section/index-phases_definition_id_idx.sql
\i default/content-section/index-phases_cycle_id_idx.sql
\i default/content-section/index-acs_object_cycle_map_cycle_idx.sql
\i default/content-section/table-publication_status.sql
\i default/content-section/comment-publication_phases.sql
\i default/content-section/table-content_types.sql
\i default/content-section/comment-content_types.sql
\i default/content-section/table-cms_items.sql
\i default/content-section/index-cms_items_ancestors_idx.sql
\i default/content-section/index-cms_items_parent_id_idx.sql
\i default/content-section/index-cms_items_type_id_idx.sql
\i default/content-section/index-cms_items_name_idx.sql
\i default/content-section/index-cms_items_section_id_idx.sql
\i default/content-section/index-cms_items_vmi_idx.sql
\i default/content-section/index-cms_items_name_id_version_parent_idx.sql
\i default/content-section/comment-cms_items.sql
\i default/content-section/index-cms_folders_index_id_idx.sql
\i default/content-section/comment-cms_folders.sql
\i default/content-section/table-content_sections.sql
\i default/content-section/index-content_sections_rt_folder_idx.sql
\i default/content-section/index-content_sections_staff_grp_idx.sql
\i default/content-section/index-content_sections_vwrs_grp_idx.sql
\i default/content-section/index-content_sections_tp_folder_idx.sql
\i default/content-section/comment-content_sections.sql
\i default/content-section/comment-content_section_type_map.sql
\i default/content-section/table-content_type_lifecycle_map.sql
\i default/content-section/index-content_type_lc_type_idx.sql
\i default/content-section/index-content_type_lc_cycle_def_idx.sql
\i default/content-section/comment-content_type_lifecycle_map.sql
\i default/content-section/table-content_type_workflow_map.sql
\i default/content-section/index-content_type_wf_map_type_idx.sql
\i default/content-section/index-content_type_wf_map_templa_idx.sql
\i default/content-section/comment-content_type_workflow_map.sql
\i default/content-section/table-cms_section_locales_map.sql
\i default/content-section/index-section_locales_map_sectn_idx.sql
\i default/content-section/index-section_locales_map_locale_idx.sql
\i default/content-section/comment-cms_section_locales_map.sql
\i default/content-section/table-authoring_kits.sql
\i default/content-section/comment-authoring_kits.sql
\i default/content-section/index-cms_assets_mime_type_idx.sql
\i default/content-section/index-cms_text_pages_text_id_idx.sql
\i default/content-section/table-cms_article_image_map.sql
\i default/content-section/insert-cms_resource_types.sql
\i default/content-section/index-cms_resources_type_idx.sql
\i default/content-section/table-cms_resource_map.sql
\i default/content-section/index-cms_resource_map_resource_idx.sql
\i default/content-section/comment-cms_resource_map.sql
\i default/content-section/table-cms_task_types.sql
\i default/content-section/table-cms_tasks.sql
\i default/content-section/index-cms_tasks_task_type_id_idx.sql
\i default/content-section/table-cms_wf_notifications.sql
\i default/content-section/default-task_types.sql
\i default/content-section/insert-task-types.sql
\i default/content-section/table-cw_process_definitions.sql
\i default/content-section/table-cms_templates.sql
\i default/content-section/comment-cms_templates.sql
\i default/content-section/index-cms_category_template_map.sql
\i default/content-section/comment-cms_category_template_map.sql
\i default/content-section/table-cms_template_use_contexts.sql
\i default/content-section/comment-cms_template_use_contexts.sql
\i default/content-section/insert-cms_template_use_contexts.sql
\i default/content-section/table-cms_section_template_map.sql
\i default/content-section/index-cms_stm_unique.sql
\i default/content-section/comment-cms_section_template_map.sql
\i default/content-section/table-cms_item_template_map.sql
\i default/content-section/index-cms_itm_unique.sql
\i default/content-section/comment-cms_item_template_map.sql
\i default/content-section/table-cms_standalone_pages.sql
\i default/content-section/comment-cms_standalone_pages.sql
\i default/content-section/index-publish_to_fs_queue_inproc_idx.sql
\i default/content-section/sequence-publish_to_file_system_seq.sql
\i default/content-section/index-publish_to_fs_files_item_idx.sql
\i default/content-section/index-publish_to_fs_files_draft_idx.sql
\i default/content-section/table-publish_to_fs_links.sql
\i default/content-section/index-publish_to_fs_links_source_idx.sql
\i default/content-section/index-publish_to_fs_links_target_idx.sql
\i default/content-section/table-publish_to_fs_notify_broken.sql
\i default/content-section/index-akit_step_map_step_id_idx.sql
\i default/content-section/index-cms_artcl_img_map_img_id_idx.sql
\i default/content-section/index-cms_itm_tplt_map_tplt_id_idx.sql
\i default/content-section/index-cms_item_tplt_map_use_ctx_idx.sql
\i default/content-section/index-cms_sec_tplt_map_tplt_id_idx.sql
\i default/content-section/index-cms_sec_tplt_map_typ_id_idx.sql
\i default/content-section/index-cms_sec_tplt_map_use_ctx_idx.sql
\i default/content-section/index-cms_stdlne_pgs_pg_id_idx.sql
\i default/content-section/index-cms_stdlne_pgs_tplt_id_idx.sql
\i default/content-section/index-cont_sec_typ_map_typ_id_idx.sql
\i default/content-section/index-cont_typs_itm_frm_id_idx.sql
\i default/content-section/index-sec_lc_def_map_cyc_def_id_idx.sql
\i default/content-section/index-sec_wf_tplt_map_wf_tplt_id_idx.sql
\i default/content-section/index-cms_top_level_pages.sql
\i default/content-section/index-section_lifecycle_def_map.sql
\i default/content-section/index-acs_object_cycl_map_itm_idx.sql
\i default/content-section/index-cms_artcl_imag_map_art_id_idx.sql
\i default/content-section/index-cms_ctgry_tmpl_map_sctn_id_idx.sql
\i default/content-section/index-cms_ctgry_tmpl_map_tmpl_id_idx.sql
\i default/content-section/index-cms_ctgry_tmpl_map_type_id_idx.sql
\i default/content-section/index-cms_items_master_id_idx.sql
\i default/content-section/index-content_sctn_typ_map_sctn_idx.sql
\i default/content-section/index-ct_cnt_grp_it_map_grp_id_idx.sql
\i default/content-section/index-ct_cnt_grp_it_map_rltd_itm_idx.sql
\i default/content-section/index-cw_tsk_grp_assign_task_id_idx.sql
\i default/content-section/index-publish_to_fs_files_hst_id_idx.sql
\i default/content-section/index-publish_to_fs_queue_hst_id_idx.sql
\i default/content-section/index-sctn_wrkflw_tmplt_map_sctn_idx.sql
\i default/content-section/index-foreign_keys.sql
\i default/portlet/table-portlet_content_item.sql
\i default/portlet/index-portlet_content_itm_itm_id_idx.sql

\i postgres/content-section/triggers-cms_items_ancestors.sql

\i ddl/postgres/deferred.sql

\i postgres/fk_to_deferred.sql
