173 lines
17 KiB
SQL
173 lines
17 KiB
SQL
--IDEMPIERE-4902: Record migration scripts with Dictionnary EntityType
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210849/* AD_Chart.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=59675/* AD_ChartDatasource.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6482/* AD_Column.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6484/* AD_Element.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=15592/* AD_EntityType.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7714/* AD_Field.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10013/* AD_FieldGroup.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7708/* AD_Form.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10574/* AD_Image.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210539/* AD_IndexColumn.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=15785/* AD_InfoColumn.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213906/* AD_InfoProcess.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213905/* AD_InfoRelated.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=15756/* AD_InfoWindow.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7721/* AD_Menu.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7716/* AD_Message.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=53263/* AD_ModelValidator.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=15620/* AD_Modification.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6485/* AD_Process.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7728/* AD_Process_Para.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7712/* AD_Ref_List.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7711/* AD_Ref_Table.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6486/* AD_Reference.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=212980/* AD_RelationType.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=9365/* AD_ReplicationStrategy.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=9343/* AD_ReplicationTable.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10032/* AD_ReportView.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=54253/* AD_Rule.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213903/* AD_SearchDefinition.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210904/* AD_StatusLine.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=212979/* AD_StatusLineUsedIn.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213900/* AD_Style.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213901/* AD_StyleLine.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=53270/* AD_SysConfig.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7713/* AD_Tab.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6488/* AD_Table.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210520/* AD_TableIndex.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7723/* AD_Task.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213902/* AD_ToolBarButton.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7715/* AD_Val_Rule.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210578/* AD_ViewColumn.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=210557/* AD_ViewComponent.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=11577/* AD_WF_NextCondition.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7725/* AD_WF_Node.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10565/* AD_WF_Node_Para.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10569/* AD_WF_NodeNext.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=10566/* AD_WF_Responsible.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=6490/* AD_Window.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7709/* AD_Workbench.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7710/* AD_WorkbenchWindow.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=7722/* AD_Workflow.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213899/* AD_ZoomCondition.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=15023/* PA_ColorSchema.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=213904/* PA_DocumentStatus.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=14781/* PA_MeasureCalc.EntityType*/
|
|
;
|
|
|
|
UPDATE AD_Column SET DefaultValue='@SQL=SELECT CASE WHEN ''@P|AdempiereSys:N@''=''Y'' THEN ''D'' ELSE get_sysconfig(''DEFAULT_ENTITYTYPE'',''U'',0,0) END FROM Dual',Updated=TO_TIMESTAMP('2021-08-05 10:47:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=53278/* PP_WF_Node_Product.EntityType*/
|
|
;
|
|
|
|
SELECT register_migration_script('202108051100_IDEMPIERE-4902.sql') FROM dual
|
|
;
|