Changes between Version 2 and Version 3 of dmlScript.sql

Timestamp:

12/16/24 01:25:41 (12 months ago)

Author:

211101

Comment:

--

dmlScript.sql

@@ -1 @@
-
 {{{#!sql
 INSERT INTO "user" (user_name, email, password) VALUES
@@ -20 +19 @@
 ('Foreign Currency', 300.00, 3);
 
-INSERT INTO transaction (transaction_name, amount, net_amount, date, tag_id) VALUES 
-('Bought groceries', 1000.00, 800.00, '2024-11-23 13:51:35+02:00', 1),
-('Paid rent', 15000.00, 15000.00, '2024-11-01 17:01:41+02:00', 5),
-('Dinner with friends', 2500.00, 1500.00, '2024-11-29 22:02:22+02:00', 2),
-('Movie tickets', 600.00, 600.00, '2024-11-30 17:38:00+02:00', 4),
-('Electricity bill', 1200.00, 1200.00, '2024-11-02 07:03:35+02:00', 5);
+INSERT INTO transaction (transaction_name, amount, net_amount, date) VALUES 
+('Bought groceries', 1000.00, 800.00, '2024-11-23 13:51:35+02:00'),
+('Paid rent', 15000.00, 15000.00, '2024-11-01 17:01:41+02:00'),
+('Dinner with friends', 2500.00, 1500.00, '2024-11-29 22:02:22+02:00'),
+('Movie tickets', 600.00, 600.00, '2024-11-30 17:38:00+02:00'),
+('Electricity bill', 1200.00, 1200.00, '2024-11-02 07:03:35+02:00');
+
+INSERT INTO tag_assigned_to_transaction (transaction_id, tag_id) VALUES 
+(1, 1),
+(2, 5),
+(3, 2),
+(4, 4),
+(5, 5);
 
 INSERT INTO transaction_breakdown (transaction_id, transaction_account_id, spent_amount, earned_amount) VALUES
@@ -33 +39 @@
 (3, 1, 2500.00, 1000.00), -- Spent 2500 on Cash, earned back 1000
 (4, 3, 600.00, 0.00);     -- Spent 600 on Credit Card for movie
-
-INSERT INTO tag_assigned_to_transaction (tag_id, transaction_id) VALUES
-(1, 1),
-(5, 2),
-(2, 3),
-(4, 4),
-(5, 5);
 }}}