lavala.blogg.se

UPDATE SPLITTRANSACTIONS_V1 SET CATEGID = SUBCATEGID + (SELECT MAX(CATEGID) FROM CATEGORY_V1_OLD) WHERE SUBCATEGID -1 UPDATE BUDGETSPLITTRANSACTIONS_V1 SET CATEGID = SUBCATEGID + (SELECT MAX(CATEGID) FROM CATEGORY_V1_OLD) WHERE SUBCATEGID -1 UPDATE BILLSDEPOSITS_V1 SET CATEGID = SUBCATEGID + (SELECT MAX(CATEGID) FROM CATEGORY_V1_OLD) WHERE SUBCATEGID -1

UPDATE CHECKINGACCOUNT_V1 SET CATEGID = SUBCATEGID + (SELECT MAX(CATEGID) FROM CATEGORY_V1_OLD) WHERE SUBCATEGID -1 SELECT (SUBCATEGID + (SELECT MAX(CATEGID) FROM CATEGORY_V1)), INSERT INTO CATEGORY_V1 (CATEGID, CATEGNAME, ACTIVE, PARENTID) ALTER TABLE CATEGORY_V1 RENAME TO CATEGORY_V1_OLD ĬREATE INDEX IF NOT EXISTS IDX_CATEGORY_CATEGNAME_PARENTID ON CATEGORY_V1(CATEGNAME, PARENTID)