SET SQLBLANKLINES ON
SET DEFINE OFF

-- Nov 18, 2014 1:29:07 PM CET
-- IDEMPIERE-2319 Adding date value type support in Attribute set
INSERT INTO AD_Ref_List (AD_Ref_List_ID,AD_Reference_ID,Name,AD_Ref_List_UU,Value,Created,CreatedBy,Updated,UpdatedBy,IsActive,EntityType,AD_Client_ID,AD_Org_ID) VALUES (200280,326,'Date','50fce4ba-71b6-48e7-9082-13cb27c4a0ff','D',TO_DATE('2014-11-18 13:28:56','YYYY-MM-DD HH24:MI:SS'),100,TO_DATE('2014-11-18 13:28:56','YYYY-MM-DD HH24:MI:SS'),100,'Y','C',0,0)
;

-- Nov 18, 2014 1:30:38 PM CET
INSERT INTO AD_Column (SeqNoSelection,IsSyncDatabase,Version,AD_Column_ID,IsMandatory,IsTranslated,IsIdentifier,SeqNo,IsParent,FieldLength,IsSelectionColumn,IsKey,IsAutocomplete,IsAllowLogging,AD_Column_UU,IsUpdateable,ColumnName,Description,Name,IsAllowCopy,Updated,CreatedBy,AD_Org_ID,IsActive,Created,UpdatedBy,IsToolbarButton,IsAlwaysUpdateable,AD_Client_ID,EntityType,IsEncrypted,IsSecure,AD_Element_ID,AD_Reference_ID,AD_Table_ID) VALUES (0,'N',0,211802,'N','N','N',0,'N',7,'N','N','N','Y','71fd613b-d2e2-40c4-9544-8ae1d061aeb9','Y','DateValue','Date of valuation','Valuation Date','Y',TO_DATE('2014-11-18 13:30:33','YYYY-MM-DD HH24:MI:SS'),100,0,'Y',TO_DATE('2014-11-18 13:30:33','YYYY-MM-DD HH24:MI:SS'),100,'N','N',0,'C','N','N',1727,15,561)
;

-- Nov 18, 2014 1:30:41 PM CET
ALTER TABLE M_AttributeInstance ADD DateValue DATE DEFAULT NULL 
;