Changes between Version 7 and Version 8 of WikiStart/DB


Ignore:
Timestamp:
03/22/25 21:38:29 (2 months ago)
Author:
203206
Comment:

db6

Legend:

Unmodified
Added
Removed
Modified
  • WikiStart/DB

    v7 v8  
    113113BEGIN
    114114    IF NEW.type = 'Deposit' THEN
    115         -- Log deposit as a self-transfer
     115     
    116116        INSERT INTO transfer(s_id, r_id)
    117117        VALUES (NEW.account_id, NEW.account_id);
    118118
    119119    ELSIF NEW.type = 'Withdrawal' THEN
    120         -- Log withdrawal as a self-transfer
     120     
    121121        INSERT INTO transfer(s_id, r_id)
    122122        VALUES (NEW.account_id, NEW.account_id);
     
    127127          NEW.type LIKE '(GBP) Transfer Out to%' THEN
    128128         
    129         -- Extract recipient username and insert into transfer table
     129   
    130130        INSERT INTO transfer(s_id, r_id)
    131131        SELECT NEW.account_id,