14 lines
260 B
MySQL
14 lines
260 B
MySQL
|
BEGIN TRANSACTION;
|
||
|
|
|
||
|
|
ALTER TABLE transactions ADD COLUMN parent_id TEXT;
|
||
|
|
|
||
|
|
UPDATE transactions SET
|
||
|
|
parent_id = CASE
|
||
|
|
WHEN isChild THEN SUBSTR(id, 1, INSTR(id, '/') - 1)
|
||
|
|
ELSE NULL
|
||
|
|
END;
|
||
|
|
|
||
|
|
CREATE INDEX trans_parent_id ON transactions(parent_id);
|
||
|
|
|
||
|
|
COMMIT;
|