# 
# OpenGroupware.org database schema creation script
# (C) 2000-2003 SKYRIX Software AG
# $Id: fb-drop-schema.sql92,v 1.1.1.1 2003/07/09 22:57:26 cvs Exp $
#

# model modification requires heavy-locking ..
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, LOCKING PESSIMISTIC;

# drop indexes

DROP INDEX action_idx;
DROP INDEX appointment_resource_name_idx;
DROP INDEX article_status_idx;
DROP INDEX assignment_kind_idx;
DROP INDEX attribute_idx;
DROP INDEX document_editing_status_idx;
DROP INDEX document_status_idx;
DROP INDEX email;
DROP INDEX end_date_ind;
DROP INDEX has_access_idx;
DROP INDEX invoice_date_idx;
DROP INDEX invoice_status_idx;
DROP INDEX is_absence_idx;
DROP INDEX is_account_idx;
DROP INDEX is_attendance_idx;
DROP INDEX is_conflict_disabled_idx;
DROP INDEX is_control_job_idx;
DROP INDEX is_enterprise_idx;
DROP INDEX is_extra_account_idx;
DROP INDEX is_fake_idx;
DROP INDEX is_folder_idx;
DROP INDEX is_index_article_idx;
DROP INDEX is_index_doc_idx;
DROP INDEX is_intra_account_idx;
DROP INDEX is_location_team_idx;
DROP INDEX is_new_idx;
DROP INDEX is_note_idx;
DROP INDEX is_object_link_idx;
DROP INDEX is_person_idx;
DROP INDEX is_private_idx;
DROP INDEX is_special_idx;
DROP INDEX is_team_idx;
DROP INDEX is_team_job_idx;
DROP INDEX is_trust_idx;
DROP INDEX job_db_status_idx;
DROP INDEX job_status_idx;
DROP INDEX invoice_kind_idx;
DROP INDEX project_kind_idx;
DROP INDEX job_kind_idx;
DROP INDEX object_link_idx;
DROP INDEX priority_idx;
DROP INDEX project_db_status_idx;
DROP INDEX project_status_idx;
DROP INDEX start_date_ind;
DROP INDEX address_type_idx;
DROP INDEX company_value_type_idx;
COMMIT;

# drop views

DROP VIEW person CASCADE;
COMMIT;
DROP VIEW enterprise CASCADE;
COMMIT;
DROP VIEW trust CASCADE;
COMMIT;
DROP VIEW team CASCADE;
COMMIT;
DROP VIEW note CASCADE;
COMMIT;
DROP VIEW doc CASCADE;
COMMIT;

# drop tables

DROP TABLE staff CASCADE;
COMMIT;
DROP TABLE company CASCADE;
COMMIT;
DROP TABLE company_info CASCADE;
COMMIT;
DROP TABLE company_value CASCADE;
COMMIT;
DROP TABLE company_category CASCADE;
COMMIT;
DROP TABLE company_assignment CASCADE;
COMMIT;
DROP TABLE appointment_resource CASCADE;
COMMIT;
DROP TABLE appointment CASCADE;
COMMIT;
DROP TABLE date_info CASCADE;
COMMIT;
DROP TABLE date_company_assignment CASCADE;
COMMIT;
DROP TABLE project CASCADE;
COMMIT;
DROP TABLE project_company_assignment CASCADE;
COMMIT;
DROP TABLE document CASCADE;
COMMIT;
DROP TABLE document_version CASCADE;
COMMIT;
DROP TABLE document_editing CASCADE;
COMMIT;
DROP TABLE address CASCADE;
COMMIT;
DROP TABLE telephone CASCADE;
COMMIT;
DROP TABLE job CASCADE;
COMMIT;
DROP TABLE job_history CASCADE;
COMMIT;
DROP TABLE job_history_info CASCADE;
COMMIT;
DROP TABLE email_folder CASCADE;
COMMIT;
DROP TABLE email_content CASCADE;
COMMIT;
DROP TABLE email CASCADE;
COMMIT;
DROP TABLE news_article CASCADE;
COMMIT;
DROP TABLE news_article_link CASCADE;
COMMIT;
DROP TABLE key_generator CASCADE;
COMMIT;
DROP TABLE log CASCADE;
COMMIT;
DROP TABLE table_version CASCADE;
COMMIT;
DROP TABLE object_model CASCADE;
COMMIT;
DROP TABLE url_criterion CASCADE;
COMMIT;
DROP TABLE url_rating CASCADE;
COMMIT;
DROP TABLE url CASCADE;
COMMIT;
DROP TABLE invoice CASCADE;
COMMIT;
DROP TABLE article CASCADE;
COMMIT;
DROP TABLE article_unit CASCADE;
COMMIT;
DROP TABLE article_category CASCADE;
COMMIT;
DROP TABLE invoice_article_assignment CASCADE;
COMMIT;
DROP TABLE resource CASCADE;
COMMIT;
DROP TABLE job_resource_assignment CASCADE;
COMMIT;
DROP TABLE job_assignment CASCADE;
COMMIT;
DROP TABLE project_info CASCADE;
COMMIT;
DROP TABLE obj_property CASCADE;
COMMIT;

# drop domains

DROP DOMAIN text            CASCADE;
COMMIT;
DROP DOMAIN money           CASCADE;
COMMIT;
DROP DOMAIN image           CASCADE;
COMMIT;
DROP DOMAIN t_id            CASCADE;
COMMIT;
DROP DOMAIN t_int           CASCADE;
COMMIT;
DROP DOMAIN t_bool          CASCADE;
COMMIT;
DROP DOMAIN t_string        CASCADE;
COMMIT;
DROP DOMAIN t_smallstring   CASCADE;
COMMIT;
DROP DOMAIN t_tinystring    CASCADE;
COMMIT;
DROP DOMAIN t_tinieststring CASCADE;
COMMIT;
DROP DOMAIN t_text          CASCADE;
COMMIT;
DROP DOMAIN t_image         CASCADE;
COMMIT;
DROP DOMAIN t_datetime      CASCADE;
COMMIT;
DROP DOMAIN t_price         CASCADE;
COMMIT;
DROP DOMAIN t_money         CASCADE;
COMMIT;