compiere.sql

Java写的ERP系统

--
--ER/Studio 5.5 SQL Code Generation
-- Company :      ComPiere, Inc.
-- Project :      AD243d.dm1
-- Author :       Jorg Janke - $Id: Compiere.sql,v 1.52 2003/04/04 05:07:22 jjanke Exp $
--
-- Date Created : Friday, February 14, 2003 01:33:59
-- Target DBMS : Oracle 8.x
--


DROP TABLE AD_Attachment CASCADE CONSTRAINTS
;
DROP TABLE AD_Attribute CASCADE CONSTRAINTS
;
DROP TABLE AD_Attribute_Value CASCADE CONSTRAINTS
;
DROP TABLE AD_ClientInfo CASCADE CONSTRAINTS
;
DROP TABLE AD_Color CASCADE CONSTRAINTS
;
DROP TABLE AD_Desktop CASCADE CONSTRAINTS
;
DROP TABLE AD_DesktopWorkbench CASCADE CONSTRAINTS
;
DROP TABLE AD_Desktop_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Element CASCADE CONSTRAINTS
;
DROP TABLE AD_Element_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Error CASCADE CONSTRAINTS
;
DROP TABLE AD_FieldGroup CASCADE CONSTRAINTS
;
DROP TABLE AD_FieldGroup_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Find CASCADE CONSTRAINTS
;
DROP TABLE AD_Form CASCADE CONSTRAINTS
;
DROP TABLE AD_Form_Access CASCADE CONSTRAINTS
;
DROP TABLE AD_Form_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Image CASCADE CONSTRAINTS
;
DROP TABLE AD_ImpFormat CASCADE CONSTRAINTS
;
DROP TABLE AD_ImpFormat_Row CASCADE CONSTRAINTS
;
DROP TABLE AD_Note CASCADE CONSTRAINTS
;
DROP TABLE AD_OrgInfo CASCADE CONSTRAINTS
;
DROP TABLE AD_PInstance CASCADE CONSTRAINTS
;
DROP TABLE AD_PInstance_Log CASCADE CONSTRAINTS
;
DROP TABLE AD_PInstance_Para CASCADE CONSTRAINTS
;
DROP TABLE AD_Preference CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintColor CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintFont CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintForm CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintFormat CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintFormatItem CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintFormatItem_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintGraph CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintPaper CASCADE CONSTRAINTS
;
DROP TABLE AD_PrintTableFormat CASCADE CONSTRAINTS
;
DROP TABLE AD_Process CASCADE CONSTRAINTS
;
DROP TABLE AD_Process_Access CASCADE CONSTRAINTS
;
DROP TABLE AD_Process_Para CASCADE CONSTRAINTS
;
DROP TABLE AD_Process_Para_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Process_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_ReportView CASCADE CONSTRAINTS
;
DROP TABLE AD_ReportView_Col CASCADE CONSTRAINTS
;
DROP TABLE AD_Role_ClientAccess CASCADE CONSTRAINTS
;
DROP TABLE AD_Role_OrgAccess CASCADE CONSTRAINTS
;
DROP TABLE AD_System CASCADE CONSTRAINTS
;
DROP TABLE AD_Task_Access CASCADE CONSTRAINTS
;
DROP TABLE AD_Trace CASCADE CONSTRAINTS
;
DROP TABLE AD_Tree CASCADE CONSTRAINTS
;
DROP TABLE AD_TreeBar CASCADE CONSTRAINTS
;
DROP TABLE AD_TreeNode CASCADE CONSTRAINTS
;
DROP TABLE AD_TreeNodeBP CASCADE CONSTRAINTS
;
DROP TABLE AD_TreeNodeMM CASCADE CONSTRAINTS
;
DROP TABLE AD_TreeNodePR CASCADE CONSTRAINTS
;
DROP TABLE AD_UserDef_Field CASCADE CONSTRAINTS
;
DROP TABLE AD_UserDef_Tab CASCADE CONSTRAINTS
;
DROP TABLE AD_UserDef_Win CASCADE CONSTRAINTS
;
DROP TABLE AD_Workbench CASCADE CONSTRAINTS
;
DROP TABLE AD_WorkbenchWindow CASCADE CONSTRAINTS
;
DROP TABLE AD_Workbench_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Workflow_Access CASCADE CONSTRAINTS
;
DROP TABLE A_Asset CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Acct CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Addition CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Change CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Change_Amt CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Delivery CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Group CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Group_Acct CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Retirement CASCADE CONSTRAINTS
;
DROP TABLE A_Asset_Use CASCADE CONSTRAINTS
;
DROP TABLE A_Depreciation CASCADE CONSTRAINTS
;
DROP TABLE C_AcctSchema CASCADE CONSTRAINTS
;
DROP TABLE C_AcctSchema_Default CASCADE CONSTRAINTS
;
DROP TABLE C_AcctSchema_Element CASCADE CONSTRAINTS
;
DROP TABLE C_AcctSchema_GL CASCADE CONSTRAINTS
;
DROP TABLE C_Activity CASCADE CONSTRAINTS
;
DROP TABLE C_Allocation CASCADE CONSTRAINTS
;
DROP TABLE C_Approval CASCADE CONSTRAINTS
;
DROP TABLE C_Bank CASCADE CONSTRAINTS
;
DROP TABLE C_BankAccount CASCADE CONSTRAINTS
;
DROP TABLE C_BankAccountDoc CASCADE CONSTRAINTS
;
DROP TABLE C_BankAccount_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_BankStatement CASCADE CONSTRAINTS
;
DROP TABLE C_BankStatementLine CASCADE CONSTRAINTS
;
DROP TABLE C_BP_BankAccount CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Customer_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_BP_EDI CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Employee_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Group CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Group_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Vendor_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_BP_Withholding CASCADE CONSTRAINTS
;
DROP TABLE C_Campaign CASCADE CONSTRAINTS
;
DROP TABLE C_Cash CASCADE CONSTRAINTS
;
DROP TABLE C_CashBook CASCADE CONSTRAINTS
;
DROP TABLE C_CashBook_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_CashLine CASCADE CONSTRAINTS
;
DROP TABLE C_Channel CASCADE CONSTRAINTS
;
DROP TABLE C_Charge CASCADE CONSTRAINTS
;
DROP TABLE C_Charge_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_Commission CASCADE CONSTRAINTS
;
DROP TABLE C_CommissionAmt CASCADE CONSTRAINTS
;
DROP TABLE C_CommissionDetail CASCADE CONSTRAINTS
;
DROP TABLE C_CommissionLine CASCADE CONSTRAINTS
;
DROP TABLE C_CommissionRun CASCADE CONSTRAINTS
;
DROP TABLE C_Cycle CASCADE CONSTRAINTS
;
DROP TABLE C_CycleStep CASCADE CONSTRAINTS
;
DROP TABLE C_DocType CASCADE CONSTRAINTS
;
DROP TABLE C_DocType_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_Dunning CASCADE CONSTRAINTS
;
DROP TABLE C_DunningLevel CASCADE CONSTRAINTS
;
DROP TABLE C_DunningLevel_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_DunningRun CASCADE CONSTRAINTS
;
DROP TABLE C_DunningRunEntry CASCADE CONSTRAINTS
;
DROP TABLE C_DunningRunLine CASCADE CONSTRAINTS
;
DROP TABLE C_ElementValue_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_Greeting CASCADE CONSTRAINTS
;
DROP TABLE C_Greeting_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_InterOrg_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_Invoice CASCADE CONSTRAINTS
;
DROP TABLE C_InvoiceLine CASCADE CONSTRAINTS
;
DROP TABLE C_InvoiceSchedule CASCADE CONSTRAINTS
;
DROP TABLE C_InvoiceTax CASCADE CONSTRAINTS
;
DROP TABLE C_Order CASCADE CONSTRAINTS
;
DROP TABLE C_OrderLine CASCADE CONSTRAINTS
;
DROP TABLE C_OrderTax CASCADE CONSTRAINTS
;
DROP TABLE C_Payment CASCADE CONSTRAINTS
;
DROP TABLE C_PaymentBatch CASCADE CONSTRAINTS
;
DROP TABLE C_PaymentProcessor CASCADE CONSTRAINTS
;
DROP TABLE C_PaymentTerm CASCADE CONSTRAINTS
;
DROP TABLE C_PaymentTerm_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_PaySelection CASCADE CONSTRAINTS
;
DROP TABLE C_PaySelectionCheck CASCADE CONSTRAINTS
;
DROP TABLE C_PaySelectionLine CASCADE CONSTRAINTS
;
DROP TABLE C_PeriodControl CASCADE CONSTRAINTS
;
DROP TABLE C_Project CASCADE CONSTRAINTS
;
DROP TABLE C_ProjectLine CASCADE CONSTRAINTS
;
DROP TABLE C_ProjectStatus CASCADE CONSTRAINTS
;
DROP TABLE C_Project_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_RevenueRecognition CASCADE CONSTRAINTS
;
DROP TABLE C_RevenueRecognition_Plan CASCADE CONSTRAINTS
;
DROP TABLE C_RevenueRecognition_Run CASCADE CONSTRAINTS
;
DROP TABLE C_SalesRegion CASCADE CONSTRAINTS
;
DROP TABLE C_ServiceLevel CASCADE CONSTRAINTS
;
DROP TABLE C_ServiceLevelLine CASCADE CONSTRAINTS
;
DROP TABLE C_Tax CASCADE CONSTRAINTS
;
DROP TABLE C_TaxCategory CASCADE CONSTRAINTS
;
DROP TABLE C_TaxCategory_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_Tax_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_UOM_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_Withholding CASCADE CONSTRAINTS
;
DROP TABLE C_Withholding_Acct CASCADE CONSTRAINTS
;
DROP TABLE C_Year CASCADE CONSTRAINTS
;
DROP TABLE DBA_ErrorLog CASCADE CONSTRAINTS
;
DROP TABLE AD_Client CASCADE CONSTRAINTS
;
DROP TABLE AD_Column CASCADE CONSTRAINTS
;
DROP TABLE AD_Field CASCADE CONSTRAINTS
;
DROP TABLE AD_Field_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Language CASCADE CONSTRAINTS
;
DROP TABLE AD_Menu CASCADE CONSTRAINTS
;
DROP TABLE AD_Menu_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Message CASCADE CONSTRAINTS
;
DROP TABLE AD_Message_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Org CASCADE CONSTRAINTS
;
DROP TABLE AD_Reference CASCADE CONSTRAINTS
;
DROP TABLE AD_Reference_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Ref_List CASCADE CONSTRAINTS
;
DROP TABLE AD_Ref_List_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Ref_Table CASCADE CONSTRAINTS
;
DROP TABLE AD_Role CASCADE CONSTRAINTS
;
DROP TABLE AD_Sequence CASCADE CONSTRAINTS
;
DROP TABLE AD_Sequence_Audit CASCADE CONSTRAINTS
;
DROP TABLE AD_Sequence_No CASCADE CONSTRAINTS
;
DROP TABLE AD_Tab CASCADE CONSTRAINTS
;
DROP TABLE AD_Table CASCADE CONSTRAINTS
;
DROP TABLE AD_Table_Access CASCADE CONSTRAINTS
;
DROP TABLE AD_Tab_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Task CASCADE CONSTRAINTS
;
DROP TABLE AD_TaskInstance CASCADE CONSTRAINTS
;
DROP TABLE AD_Task_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_User CASCADE CONSTRAINTS
;
DROP TABLE AD_User_Roles CASCADE CONSTRAINTS
;
DROP TABLE AD_Val_Rule CASCADE CONSTRAINTS
;
DROP TABLE AD_WF_Instance CASCADE CONSTRAINTS
;
DROP TABLE AD_WF_Node CASCADE CONSTRAINTS
;
DROP TABLE AD_WF_NodeNext CASCADE CONSTRAINTS
;
DROP TABLE AD_WF_Node_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Window CASCADE CONSTRAINTS
;
DROP TABLE AD_Window_Access CASCADE CONSTRAINTS
;
DROP TABLE AD_Window_Trl CASCADE CONSTRAINTS
;
DROP TABLE AD_Workflow CASCADE CONSTRAINTS
;
DROP TABLE AD_Workflow_Trl CASCADE CONSTRAINTS
;
DROP TABLE C_BPartner CASCADE CONSTRAINTS
;
DROP TABLE C_BPartner_Contact CASCADE CONSTRAINTS
;
DROP TABLE C_BPartner_Location CASCADE CONSTRAINTS
;
DROP TABLE C_Calendar CASCADE CONSTRAINTS
;
DROP TABLE C_City CASCADE CONSTRAINTS
;
DROP TABLE C_Conversion_Rate CASCADE CONSTRAINTS
;
DROP TABLE C_Country CASCADE CONSTRAINTS
;
DROP TABLE C_Currency CASCADE CONSTRAINTS
;
DROP TABLE C_Element CASCADE CONSTRAINTS
;
DROP TABLE C_ElementValue CASCADE CONSTRAINTS
;
DROP TABLE C_Location CASCADE CONSTRAINTS
;
DROP TABLE C_NonBusinessDay CASCADE CONSTRAINTS
;
DROP TABLE C_Period CASCADE CONSTRAINTS
;
DROP TABLE C_Region CASCADE CONSTRAINTS
;
DROP TABLE C_UOM CASCADE CONSTRAINTS
;
DROP TABLE C_UOM_Conversion CASCADE CONSTRAINTS
;
DROP TABLE C_ValidCombination CASCADE CONSTRAINTS
;
DROP TABLE Test CASCADE CONSTRAINTS
;
DROP TABLE Fact_Acct CASCADE CONSTRAINTS
;
DROP TABLE Fact_Acct_Balance CASCADE CONSTRAINTS
;
DROP TABLE GL_Budget CASCADE CONSTRAINTS
;
DROP TABLE GL_Category CASCADE CONSTRAINTS
;
DROP TABLE GL_Journal CASCADE CONSTRAINTS
;
DROP TABLE GL_JournalBatch CASCADE CONSTRAINTS
;
DROP TABLE GL_JournalLine CASCADE CONSTRAINTS
;
DROP TABLE I_BPartner CASCADE CONSTRAINTS
;
DROP TABLE I_ElementValue CASCADE CONSTRAINTS
;
DROP TABLE I_Inventory CASCADE CONSTRAINTS
;
DROP TABLE I_Product CASCADE CONSTRAINTS
;
DROP TABLE I_ReportLine CASCADE CONSTRAINTS