From: Jorg J. <jj...@us...> - 2002-05-27 03:13:05
|
Update of /cvsroot/compiere/db/database/Create In directory usw-pr-cvs1:/tmp/cvs-serv31559/database/Create Modified Files: Compiere.sql Log Message: . Index: Compiere.sql =================================================================== RCS file: /cvsroot/compiere/db/database/Create/Compiere.sql,v retrieving revision 1.21 retrieving revision 1.22 diff -C2 -d -r1.21 -r1.22 *** Compiere.sql 14 May 2002 03:44:51 -0000 1.21 --- Compiere.sql 27 May 2002 03:13:02 -0000 1.22 *************** *** 5,9 **** -- Author : Jorg Janke - $Id$ -- ! -- Date Created : Monday, May 13, 2002 14:59:06 -- Target DBMS : Oracle 8 -- --- 5,9 ---- -- Author : Jorg Janke - $Id$ -- ! -- Date Created : Sunday, May 26, 2002 20:11:42 -- Target DBMS : Oracle 8 -- *************** *** 7366,7387 **** CREATE TABLE M_MatchPO( ! M_MatchPO_ID NUMBER(10, 0) NOT NULL, ! AD_Client_ID NUMBER(10, 0) NOT NULL, ! AD_Org_ID NUMBER(10, 0) NOT NULL, ! IsActive CHAR(1) DEFAULT 'Y' NOT NULL ! CHECK (IsActive in ('Y','N')), ! Created DATE DEFAULT SYSDATE NOT NULL, ! CreatedBy NUMBER(10, 0) NOT NULL, ! Updated DATE DEFAULT SYSDATE NOT NULL, ! UpdatedBy NUMBER(10, 0) NOT NULL, ! M_InOutLine_ID NUMBER(10, 0) NOT NULL, ! C_OrderLine_ID NUMBER(10, 0) NOT NULL, ! M_Product_ID NUMBER(10, 0) NOT NULL, ! DateTrx DATE NOT NULL, ! Qty NUMBER DEFAULT 0 NOT NULL, ! Processing CHAR(1) NOT NULL, ! Processed CHAR(1) DEFAULT 'N' NOT NULL ! CHECK (Processed in ('Y','N')), ! Posted CHAR(1) DEFAULT 'N' NOT NULL, CONSTRAINT M_MatchPO_Key PRIMARY KEY (M_MatchPO_ID) ) --- 7366,7388 ---- CREATE TABLE M_MatchPO( ! M_MatchPO_ID NUMBER(10, 0) NOT NULL, ! AD_Client_ID NUMBER(10, 0) NOT NULL, ! AD_Org_ID NUMBER(10, 0) NOT NULL, ! IsActive CHAR(1) DEFAULT 'Y' NOT NULL ! CHECK (IsActive in ('Y','N')), ! Created DATE DEFAULT SYSDATE NOT NULL, ! CreatedBy NUMBER(10, 0) NOT NULL, ! Updated DATE DEFAULT SYSDATE NOT NULL, ! UpdatedBy NUMBER(10, 0) NOT NULL, ! C_OrderLine_ID NUMBER(10, 0) NOT NULL, ! M_Product_ID NUMBER(10, 0) NOT NULL, ! M_InOutLine_ID NUMBER(10, 0), ! C_InvoiceLine_ID NUMBER(10, 0), ! DateTrx DATE NOT NULL, ! Qty NUMBER DEFAULT 0 NOT NULL, ! Processing CHAR(1) NOT NULL, ! Processed CHAR(1) DEFAULT 'N' NOT NULL ! CHECK (Processed in ('Y','N')), ! Posted CHAR(1) DEFAULT 'N' NOT NULL, CONSTRAINT M_MatchPO_Key PRIMARY KEY (M_MatchPO_ID) ) *************** *** 8694,8717 **** CREATE TABLE Test( ! Test_ID NUMBER(10, 0) NOT NULL, ! AD_Client_ID NUMBER(10, 0) NOT NULL, ! AD_Org_ID NUMBER(10, 0) NOT NULL, ! IsActive CHAR(1) DEFAULT 'Y' NOT NULL CHECK (IsActive in ('Y','N')), ! Created DATE DEFAULT SYSDATE NOT NULL, ! CreatedBy NUMBER(10, 0) NOT NULL, ! Updated DATE DEFAULT SYSDATE NOT NULL, ! UpdatedBy NUMBER(10, 0) NOT NULL, ! Name VARCHAR2(60) NOT NULL, Description VARCHAR2(255), Help VARCHAR2(2000), T_Integer NUMBER(10, 0), ! T_Number NUMBER, T_Date DATE, T_DateTime DATE, C_UOM_ID NUMBER(10, 0), ! T_Qty NUMBER DEFAULT 0, C_Currency_ID NUMBER(10, 0), ! T_Amount NUMBER DEFAULT 0, C_Location_ID NUMBER(10, 0), Account_Acct NUMBER(10, 0), --- 8695,8718 ---- CREATE TABLE Test( ! Test_ID NUMBER(10, 0) NOT NULL, ! AD_Client_ID NUMBER(10, 0) NOT NULL, ! AD_Org_ID NUMBER(10, 0) NOT NULL, ! IsActive CHAR(1) DEFAULT 'Y' NOT NULL CHECK (IsActive in ('Y','N')), ! Created DATE DEFAULT SYSDATE NOT NULL, ! CreatedBy NUMBER(10, 0) NOT NULL, ! Updated DATE DEFAULT SYSDATE NOT NULL, ! UpdatedBy NUMBER(10, 0) NOT NULL, ! Name VARCHAR2(60) NOT NULL, Description VARCHAR2(255), Help VARCHAR2(2000), T_Integer NUMBER(10, 0), ! T_Number NUMBER DEFAULT 0, T_Date DATE, T_DateTime DATE, C_UOM_ID NUMBER(10, 0), ! T_Qty NUMBER DEFAULT 0, C_Currency_ID NUMBER(10, 0), ! T_Amount NUMBER DEFAULT 0, C_Location_ID NUMBER(10, 0), Account_Acct NUMBER(10, 0), *************** *** 8721,8725 **** M_Locator_ID NUMBER(10, 0), Processing CHAR(1), ! Processed CHAR(1) DEFAULT 'N' CHECK (Processed in ('Y','N')), CONSTRAINT Test_Key PRIMARY KEY (Test_ID) --- 8722,8726 ---- M_Locator_ID NUMBER(10, 0), Processing CHAR(1), ! Processed CHAR(1) DEFAULT 'N' CHECK (Processed in ('Y','N')), CONSTRAINT Test_Key PRIMARY KEY (Test_ID) *************** *** 8918,8922 **** -- ! CREATE UNIQUE INDEX AD_Find_ID_Key ON AD_Find(Find_ID) TABLESPACE INDX / --- 8919,8923 ---- -- ! CREATE INDEX AD_Find_ID_Key ON AD_Find(Find_ID) TABLESPACE INDX / *************** *** 13582,13585 **** --- 13583,13591 ---- -- TABLE: M_MatchPO -- + + ALTER TABLE M_MatchPO ADD CONSTRAINT CInvoiceLine_MMatchPO + FOREIGN KEY (C_InvoiceLine_ID) + REFERENCES C_InvoiceLine(C_InvoiceLine_ID) + / ALTER TABLE M_MatchPO ADD CONSTRAINT COrderLine_MMatchPO |