37 lines
1.0 KiB
MySQL
37 lines
1.0 KiB
MySQL
|
-- IDEMPIERE-3453
|
||
|
|
|
||
|
|
CREATE OR REPLACE FUNCTION trunc(datetime TIMESTAMP WITHOUT TIME ZONE)
|
||
|
|
RETURNS TIMESTAMP WITHOUT TIME ZONE AS $$
|
||
|
|
BEGIN
|
||
|
|
RETURN CAST(datetime AS DATE);
|
||
|
|
END;
|
||
|
|
$$ LANGUAGE plpgsql IMMUTABLE;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:23:30 PM CEST
|
||
|
|
UPDATE AD_IndexColumn SET ColumnSQL='TRUNC(DateAcct)',Updated=TO_TIMESTAMP('2017-08-25 12:23:30','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_IndexColumn_ID=200741
|
||
|
|
;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:23:35 PM CEST
|
||
|
|
DROP INDEX fact_acct_trunc_dateacct
|
||
|
|
;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:23:35 PM CEST
|
||
|
|
CREATE INDEX fact_acct_trunc_dateacct ON Fact_Acct (TRUNC(DateAcct))
|
||
|
|
;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:27:32 PM CEST
|
||
|
|
UPDATE AD_IndexColumn SET ColumnSQL='upper(columnname)',Updated=TO_TIMESTAMP('2017-08-25 12:27:32','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_IndexColumn_ID=200079
|
||
|
|
;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:27:46 PM CEST
|
||
|
|
DROP INDEX ad_element_uppercolumnname
|
||
|
|
;
|
||
|
|
|
||
|
|
-- Aug 25, 2017 12:27:46 PM CEST
|
||
|
|
CREATE UNIQUE INDEX ad_element_uppercolumnname ON AD_Element (upper(columnname))
|
||
|
|
;
|
||
|
|
|
||
|
|
SELECT register_migration_script('201708251228_IDEMPIERE-3453.sql') FROM dual
|
||
|
|
;
|
||
|
|
|