115 lines
7.2 KiB
SQL
115 lines
7.2 KiB
SQL
SET SQLBLANKLINES ON
|
|
SET DEFINE OFF
|
|
|
|
-- IDEMPIERE-4936
|
|
-- Aug 27, 2021, 4:48:42 PM CEST
|
|
INSERT INTO AD_Column (AD_Column_ID,Version,Name,AD_Table_ID,ColumnName,FieldLength,IsKey,IsParent,IsMandatory,IsTranslated,IsIdentifier,SeqNo,IsEncrypted,AD_Reference_ID,AD_Reference_Value_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,AD_Element_ID,IsUpdateable,IsSelectionColumn,EntityType,IsSyncDatabase,IsAlwaysUpdateable,IsAutocomplete,IsAllowLogging,AD_Column_UU,IsAllowCopy,SeqNoSelection,IsToolbarButton,IsSecure,IsHtml) VALUES (214581,0,'Show in Grid',464,'IsDisplayedGrid',1,'N','N','N','N','N',0,'N',17,319,0,0,'Y',TO_DATE('2021-08-27 16:48:41','YYYY-MM-DD HH24:MI:SS'),0,TO_DATE('2021-08-27 16:48:41','YYYY-MM-DD HH24:MI:SS'),0,200083,'Y','N','D','N','N','N','Y','4354dad8-0dcc-4d10-954e-266cf323de28','Y',0,'N','N','N')
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:48:47 PM CEST
|
|
ALTER TABLE AD_UserDef_Field ADD IsDisplayedGrid CHAR(1) DEFAULT NULL
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:05 PM CEST
|
|
INSERT INTO AD_Field (AD_Field_ID,Name,AD_Tab_ID,AD_Column_ID,IsDisplayed,DisplayLength,SeqNo,IsSameLine,IsHeading,IsFieldOnly,IsEncrypted,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,IsReadOnly,IsCentrallyMaintained,EntityType,AD_Field_UU,IsDisplayedGrid,SeqNoGrid,ColumnSpan) VALUES (206743,'Show in Grid',395,214581,'Y',1,380,'N','N','N','N',0,0,'Y',TO_DATE('2021-08-27 16:49:05','YYYY-MM-DD HH24:MI:SS'),0,TO_DATE('2021-08-27 16:49:05','YYYY-MM-DD HH24:MI:SS'),0,'N','Y','D','d8a8c406-56ae-4473-a06d-f5a7ebedb966','Y',350,2)
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET IsDisplayed='Y', SeqNo=150, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, XPosition=1, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=206743
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET IsDisplayed='Y', SeqNo=160, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, XPosition=4, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=206670
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=170, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=11252
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=180, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=206521
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=190, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200857
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=200, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200850
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=210, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200853
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=220, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=204215
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=230, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=204216
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=240, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200858
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=250, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200856
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=260, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200855
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=270, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=203266
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=280, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=204221
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=290, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=206130
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=300, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=5054
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=310, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200849
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=320, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200851
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=330, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=206408
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=340, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200852
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=350, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=203499
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=360, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=200854
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=370, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=5051
|
|
;
|
|
|
|
-- Aug 27, 2021, 4:49:27 PM CEST
|
|
UPDATE AD_Field SET SeqNo=380, AD_Reference_Value_ID=NULL, AD_Val_Rule_ID=NULL, IsToolbarButton=NULL,Updated=TO_DATE('2021-08-27 16:49:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Field_ID=5057
|
|
;
|
|
|
|
SELECT register_migration_script('202108271700_IDEMPIERE-4936.sql') FROM dual
|
|
;
|