midsuit
/
core-jgi
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
core-jgi/migration/i7.1z/postgresql/202002051703_IDEMPIERE-4084...

178 lines
8.1 KiB
MySQL
Raw Permalink Normal View History

IDEMPIERE-4084 Modify default toolbar buttons
2020-02-05 23:05:59 +07:00
-- IDEMPIERE-4084 improve toolbar more configurable
-- Feb 5, 2020, 4:52:04 PM CET
UPDATE AD_ToolBarButton SET SeqNo=10,Updated=TO_TIMESTAMP('2020-02-05 16:52:04','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200031
;
-- Feb 5, 2020, 4:52:08 PM CET
UPDATE AD_ToolBarButton SET SeqNo=20,Updated=TO_TIMESTAMP('2020-02-05 16:52:08','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200032
;
-- Feb 5, 2020, 4:52:26 PM CET
UPDATE AD_ToolBarButton SET SeqNo=130,Updated=TO_TIMESTAMP('2020-02-05 16:52:26','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200033
;
-- Feb 5, 2020, 4:52:34 PM CET
UPDATE AD_ToolBarButton SET SeqNo=30,Updated=TO_TIMESTAMP('2020-02-05 16:52:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200035
;
-- Feb 5, 2020, 4:52:45 PM CET
UPDATE AD_ToolBarButton SET SeqNo=140,Updated=TO_TIMESTAMP('2020-02-05 16:52:45','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200036
;
-- Feb 5, 2020, 4:52:58 PM CET
UPDATE AD_ToolBarButton SET SeqNo=150,Updated=TO_TIMESTAMP('2020-02-05 16:52:58','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200037
;
-- Feb 5, 2020, 4:53:02 PM CET
UPDATE AD_ToolBarButton SET SeqNo=50,Updated=TO_TIMESTAMP('2020-02-05 16:53:02','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200038
;
-- Feb 5, 2020, 4:53:11 PM CET
UPDATE AD_ToolBarButton SET SeqNo=160,Updated=TO_TIMESTAMP('2020-02-05 16:53:11','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200039
;
-- Feb 5, 2020, 4:53:23 PM CET
UPDATE AD_ToolBarButton SET SeqNo=170,Updated=TO_TIMESTAMP('2020-02-05 16:53:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200040
;
-- Feb 5, 2020, 4:53:30 PM CET
UPDATE AD_ToolBarButton SET SeqNo=60,Updated=TO_TIMESTAMP('2020-02-05 16:53:30','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200041
;
-- Feb 5, 2020, 4:53:42 PM CET
UPDATE AD_ToolBarButton SET SeqNo=180,Updated=TO_TIMESTAMP('2020-02-05 16:53:41','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200043
;
-- Feb 5, 2020, 4:53:45 PM CET
UPDATE AD_ToolBarButton SET SeqNo=190,Updated=TO_TIMESTAMP('2020-02-05 16:53:45','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200044
;
-- Feb 5, 2020, 4:54:06 PM CET
UPDATE AD_ToolBarButton SET SeqNo=80,Updated=TO_TIMESTAMP('2020-02-05 16:54:06','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200049
;
-- Feb 5, 2020, 4:54:17 PM CET
UPDATE AD_ToolBarButton SET SeqNo=200,Updated=TO_TIMESTAMP('2020-02-05 16:54:17','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200050
;
-- Feb 5, 2020, 4:54:21 PM CET
UPDATE AD_ToolBarButton SET SeqNo=100,Updated=TO_TIMESTAMP('2020-02-05 16:54:21','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200051
;
-- Feb 5, 2020, 4:54:26 PM CET
UPDATE AD_ToolBarButton SET SeqNo=210,Updated=TO_TIMESTAMP('2020-02-05 16:54:26','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200052
;
-- Feb 5, 2020, 4:54:29 PM CET
UPDATE AD_ToolBarButton SET SeqNo=70,Updated=TO_TIMESTAMP('2020-02-05 16:54:29','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200053
;
-- Feb 5, 2020, 4:54:59 PM CET
UPDATE AD_ToolBarButton SET SeqNo=250,Updated=TO_TIMESTAMP('2020-02-05 16:54:59','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200057
;
-- Feb 5, 2020, 4:55:05 PM CET
UPDATE AD_ToolBarButton SET SeqNo=260,Updated=TO_TIMESTAMP('2020-02-05 16:55:05','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200058
;
-- Feb 5, 2020, 4:55:39 PM CET
UPDATE AD_ToolBarButton SET SeqNo=280,Updated=TO_TIMESTAMP('2020-02-05 16:55:39','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200059
;
-- Feb 5, 2020, 4:55:45 PM CET
UPDATE AD_ToolBarButton SET SeqNo=NULL,Updated=TO_TIMESTAMP('2020-02-05 16:55:45','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200059
;
-- Feb 5, 2020, 4:55:56 PM CET
UPDATE AD_ToolBarButton SET SeqNo=90,Updated=TO_TIMESTAMP('2020-02-05 16:55:56','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200078
;
-- Feb 5, 2020, 4:56:08 PM CET
UPDATE AD_ToolBarButton SET SeqNo=290,Updated=TO_TIMESTAMP('2020-02-05 16:56:08','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200088
;
-- Feb 5, 2020, 4:57:13 PM CET
UPDATE AD_ToolBarButton SET SeqNo=120,Updated=TO_TIMESTAMP('2020-02-05 16:57:13','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200030
;
-- Feb 5, 2020, 4:58:20 PM CET
UPDATE AD_ToolBarButton SET SeqNo=40,Updated=TO_TIMESTAMP('2020-02-05 16:58:20','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200029
;
-- Feb 5, 2020, 4:58:47 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:58:47','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200030
;
-- Feb 5, 2020, 4:58:57 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:58:57','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200033
;
-- Feb 5, 2020, 4:58:59 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:58:59','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200036
;
-- Feb 5, 2020, 4:59:00 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:00','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200037
;
-- Feb 5, 2020, 4:59:02 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:02','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200039
;
-- Feb 5, 2020, 4:59:05 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:05','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200040
;
-- Feb 5, 2020, 4:59:06 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:06','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200043
;
-- Feb 5, 2020, 4:59:07 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:07','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200044
;
-- Feb 5, 2020, 4:59:12 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:12','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200050
;
-- Feb 5, 2020, 4:59:14 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:14','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200052
;
-- Feb 5, 2020, 4:59:16 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:16','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200054
;
-- Feb 5, 2020, 4:59:17 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:17','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200055
;
-- Feb 5, 2020, 4:59:20 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:20','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200056
;
-- Feb 5, 2020, 4:59:22 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:22','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200057
;
-- Feb 5, 2020, 4:59:23 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200058
;
-- Feb 5, 2020, 4:59:24 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:24','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200067
;
-- Feb 5, 2020, 4:59:27 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:27','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200081
;
-- Feb 5, 2020, 4:59:28 PM CET
UPDATE AD_ToolBarButton SET IsShowMore='Y',Updated=TO_TIMESTAMP('2020-02-05 16:59:28','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_ToolBarButton_ID=200088
;
SELECT register_migration_script('202002051703_IDEMPIERE-4084.sql') FROM dual
;