Changes between Version 7 and Version 8 of WikiStart/DB
- Timestamp:
- 03/22/25 21:38:29 (2 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WikiStart/DB
v7 v8 113 113 BEGIN 114 114 IF NEW.type = 'Deposit' THEN 115 -- Log deposit as a self-transfer115 116 116 INSERT INTO transfer(s_id, r_id) 117 117 VALUES (NEW.account_id, NEW.account_id); 118 118 119 119 ELSIF NEW.type = 'Withdrawal' THEN 120 -- Log withdrawal as a self-transfer120 121 121 INSERT INTO transfer(s_id, r_id) 122 122 VALUES (NEW.account_id, NEW.account_id); … … 127 127 NEW.type LIKE '(GBP) Transfer Out to%' THEN 128 128 129 -- Extract recipient username and insert into transfer table129 130 130 INSERT INTO transfer(s_id, r_id) 131 131 SELECT NEW.account_id,