From SemanticLab
--
-- Drop and Create Script
-- Database Version : 11.1.0.6.0
-- DB Connect String : ORCL
-- Schema : BIBDB
-- Script Created by : BIBDB
-- Physical Location :
-- Notes :
--
-- Object Counts:
-- Users: 1 Sys Privs: 1 Roles: 3 Tablespace Quotas: 1
-- Tablespaces: 1 DataFiles: 1
--
-- Indexes: 39 Columns: 51
-- Sequences: 1
-- Tables: 21 Columns: 109 Constraints: 25
-- Views: 7
-- "Set define off" turns off substitution variables.
Set define off;
@./Tablespaces/USERS.sql;
@./Users/BIBDB.sql;
@./Sequences/BIB_SEQ.sql;
@./Tables/B_BIBLIOGRAPHY.sql;
@./Tables/B_ITEMS.sql;
@./Tables/INFO_BUILDIN.sql;
@./Tables/META_ENTRY_FIELDS.sql;
@./Tables/META_FUNCTIONS.sql;
@./Tables/META_TYPEFUNCTIONS.sql;
@./Tables/OWNERS.sql;
@./Tables/S_BIBLIOGRAPHYSTYLES.sql;
@./Tables/S_BIBSTYLES_REF.sql;
@./Tables/S_ENTRY_FIELDS.sql;
@./Tables/S_FUNCTIONS.sql;
@./Tables/S_TYPEFUNCTIONS.sql;
@./Tables/TEMP_B_FIELDS.sql;
@./Tables/TEMP_ENTRY_FIELDS.sql;
@./Tables/TEMP_FUNCTIONS.sql;
@./Tables/TEMP_MACROS.sql;
@./Tables/TEMP_STR.sql;
@./Tables/TEMP_VARS.sql;
@./Indexes/B_BIB_OWN_FK_I.sql;
@./Indexes/B_BIB_PK.sql;
@./Indexes/B_BIB_UK1_UK.sql;
@./Indexes/B_FIELD_B_ITEM_FK_I.sql;
@./Indexes/B_FIELD_PK.sql;
@./Indexes/B_FIELD_UK1_UK.sql;
@./Indexes/B_ITEM_B_BIB_FK_I.sql;
@./Indexes/B_ITEM_PK.sql;
@./Indexes/B_ITEM_UK1_UK.sql;
@./Indexes/B_ITEM_UK2_UK.sql;
@./Indexes/M_ENTR_PK.sql;
@./Indexes/M_ENTR_UK1_UK.sql;
@./Indexes/M_FUNCITEM_PK.sql;
@./Indexes/M_FUNCITEM_UK1_PK.sql;
@./Indexes/M_FUNC_PK.sql;
@./Indexes/M_FUNC_UK1_UK.sql;
@./Indexes/M_TYPEF_PK.sql;
@./Indexes/M_TYPEF_UK1_UK.sql;
@./Indexes/OWN_OWN_2_UK.sql;
@./Indexes/OWN_PK.sql;
@./Indexes/S_BST_OWN_FK_I.sql;
@./Indexes/S_BST_PK.sql;
@./Indexes/S_BSTREF_PK.sql;
@./Indexes/S_BSTREF_S_BST_DETAIL_FK_I.sql;
@./Indexes/S_BSTREF_S_BST_MAST_FK_I.sql;
@./Indexes/S_BSTREF_UK1_UK.sql;
@./Indexes/S_BSTREF_UK2_UK.sql;
@./Indexes/S_BST_UK1_UK.sql;
@./Indexes/S_ENTR_PK.sql;
@./Indexes/S_ENTR_S_BST_FK_I.sql;
@./Indexes/S_ENTR_UK1_UK.sql;
@./Indexes/S_FUNCITEM_PK.sql;
@./Indexes/S_FUNCITEM_UK1_PK.sql;
@./Indexes/S_FUNC_PK.sql;
@./Indexes/S_FUNC_S_BST_FK_I.sql;
@./Indexes/S_FUNC_UK1_UK.sql;
@./Indexes/S_TYPEF_PK.sql;
@./Indexes/S_TYPEF_S_BST_FK_I.sql;
@./Indexes/S_TYPEF_UK1_UK.sql;
@./Views/S_ENTRY_FIELDS_V.sql;
@./Views/S_INCL_ENTRY_FIELDS_V1.sql;
@./Views/S_INCL_TYPEFUNCTIONS_V1.sql;
@./Tables/B_FIELDS.sql;
@./Tables/META_FUNCTIONITEMS.sql;
@./Tables/S_FUNCTIONITEMS.sql;
@./Views/B_BIB_V.sql;
@./Views/FUNC_ALLOTHERS_ITEMS_V.sql;
@./Views/FUNC_BIBTYPE_ITEMS_V.sql;
@./Views/FUNC_FIELDFORMAT_ITEMS_V.sql;
@./Constraints/B_BIBLIOGRAPHY_NonFK.sql;
@./Constraints/B_ITEMS_NonFK.sql;
@./Constraints/META_ENTRY_FIELDS_NonFK.sql;
@./Constraints/META_FUNCTIONS_NonFK.sql;
@./Constraints/META_TYPEFUNCTIONS_NonFK.sql;
@./Constraints/OWNERS_NonFK.sql;
@./Constraints/S_BIBLIOGRAPHYSTYLES_NonFK.sql;
@./Constraints/S_BIBSTYLES_REF_NonFK.sql;
@./Constraints/S_ENTRY_FIELDS_NonFK.sql;
@./Constraints/S_FUNCTIONS_NonFK.sql;
@./Constraints/S_TYPEFUNCTIONS_NonFK.sql;
@./Constraints/B_FIELDS_NonFK.sql;
@./Constraints/META_FUNCTIONITEMS_NonFK.sql;
@./Constraints/S_FUNCTIONITEMS_NonFK.sql;
@./Constraints/B_ITEMS_FK.sql;
@./Constraints/S_BIBLIOGRAPHYSTYLES_FK.sql;
@./Constraints/S_BIBSTYLES_REF_FK.sql;
@./Constraints/S_ENTRY_FIELDS_FK.sql;
@./Constraints/S_FUNCTIONS_FK.sql;
@./Constraints/S_TYPEFUNCTIONS_FK.sql;
@./Constraints/B_FIELDS_FK.sql;
@./Constraints/META_FUNCTIONITEMS_FK.sql;
@./Constraints/S_FUNCTIONITEMS_FK.sql;
