Changes between Version 1 and Version 2 of dmlScriptVer1.sql

Timestamp:

12/02/24 03:06:56 (3 days ago)

Author:

211101

Comment:

--

dmlScriptVer1.sql

@@ -4 +4 @@
 ('Jane Smith', 'jane@example.com', 'securepass'),
 ('Alice Johnson', 'alice@example.com', 'alicepwd');
-
-INSERT INTO YEAR (year_name) VALUES
-(2023),
-(2024),
-(2025);
-
-INSERT INTO MONTH (year_id, month_name) VALUES
-(1, 'January'),
-(1, 'February'),
-(1, 'March'),
-(2, 'January'),
-(2, 'February');
-
-INSERT INTO DAY (month_id, day_number, day_name) VALUES
-(1, 1, 'Sunday'),
-(1, 2, 'Monday'),
-(1, 3, 'Tuesday'),
-(2, 1, 'Wednesday'),
-(2, 2, 'Thursday');
 
 INSERT INTO TAG (tag_name) VALUES
@@ -38 +19 @@
 ('Foreign Currency', 300.00, 3);
 
-INSERT INTO TRANSACTION (transaction_name, amount, net_amount, day_id, tag_id) VALUES
-('Bought groceries', 1000.00, 800.00, 1, 1),
-('Paid rent', 15000.00, 15000.00, 2, 5),
-('Dinner with friends', 2500.00, 1500.00, 3, 2),
-('Movie tickets', 600.00, 600.00, 4, 4),
-('Electricity bill', 1200.00, 1200.00, 5, 5);
+INSERT INTO TRANSACTION (transaction_name, amount, net_amount, date, tag_id) VALUES
+('Bought groceries', 1000.00, 800.00, '23.11.2024 13:51:35 +02:00', 1),
+('Paid rent', 15000.00, 15000.00, '01.11.2024 17:01:41 +02:00', 5),
+('Dinner with friends', 2500.00, 1500.00, '29.11.2024 22:02:22 +02:00', 2),
+('Movie tickets', 600.00, 600.00, '30.11.2024 17:38:00 +02:00', 4),
+('Electricity bill', 1200.00, 1200.00, '02.11.2024 07:03:35 +02:00', 5);
 
 INSERT INTO TRANSACTION_BREAKDOWN (transaction_id, transaction_account_id, spent_amount, earned_amount) VALUES