-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSeedData.sql
More file actions
35 lines (18 loc) · 22.4 KB
/
Copy pathSeedData.sql
File metadata and controls
35 lines (18 loc) · 22.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
INSERT INTO "TaskGenixDb"."Users" ("Id", "Username", "AvatarUrl", "Email", "PasswordHash", "Role", "LastLogin", "EmailVerified", "IsActive", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440001', 'john_doe', 'https://avatar.com/john.jpg', 'john.doe@example.com', '123456', 'Admin', '2024-01-15 10:30:00+00', 'true', 'true', '2024-01-01 09:00:00', '2024-01-15 10:30:00'), ('550e8400-e29b-41d4-a716-446655440002', 'jane_smith', 'https://avatar.com/jane.jpg', 'jane.smith@example.com', '123456', 'User', '2024-01-14 14:20:00+00', 'true', 'true', '2024-01-02 10:15:00', '2024-01-14 14:20:00'), ('550e8400-e29b-41d4-a716-446655440003', 'bob_wilson', null, 'bob.wilson@example.com', '123456', 'User', '2024-01-13 16:45:00+00', 'true', 'true', '2024-01-03 11:30:00', '2024-01-13 16:45:00'), ('550e8400-e29b-41d4-a716-446655440004', 'alice_brown', 'https://avatar.com/alice.jpg', 'alice.brown@example.com', '123456', 'User', '2024-01-12 08:15:00+00', 'true', 'true', '2024-01-04 12:45:00', '2024-01-12 08:15:00'), ('550e8400-e29b-41d4-a716-446655440005', 'charlie_davis', null, 'charlie.davis@example.com', '123456', 'User', null, 'false', 'false', '2024-01-05 13:20:00', '2024-01-05 13:20:00'), ('550e8400-e29b-41d4-a716-446655440006', 'DuoG', null, 'manhduonglhp4@gmail.com', '123456', 'User', null, 'true', 'true', '2025-09-14 23:33:58', '2025-09-14 23:33:59');
INSERT INTO "TaskGenixDb"."Projects" ("Id", "Name", "Description", "Status", "Type", "OwnerId", "RecordingId", "DueDate", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440081', 'Website Redesign', 'Complete redesign of company website', 'Active', 'Team', '550e8400-e29b-41d4-a716-446655440001', null, '2024-03-01 23:59:59+00', '2024-01-05 09:00:00', '2024-01-15 10:30:00'), ('550e8400-e29b-41d4-a716-446655440082', 'Mobile App Development', 'Native iOS and Android app development', 'Active', 'Team', '550e8400-e29b-41d4-a716-446655440002', null, '2024-06-01 23:59:59+00', '2024-01-06 10:15:00', '2024-01-14 14:20:00'), ('550e8400-e29b-41d4-a716-446655440083', 'Marketing Campaign Q1', 'First quarter marketing campaign planning', 'NotStarted', 'Personal', '550e8400-e29b-41d4-a716-446655440003', null, '2024-03-31 23:59:59+00', '2024-01-07 11:30:00', '2024-01-13 16:45:00'), ('550e8400-e29b-41d4-a716-446655440084', 'Database Migration', 'Migrate from MySQL to PostgreSQL', 'OnHold', 'Personal', '550e8400-e29b-41d4-a716-446655440004', null, '2024-04-15 23:59:59+00', '2024-01-08 12:45:00', '2024-01-12 08:15:00');
INSERT INTO "TaskGenixDb"."ProjectMembers" ("Id", "Role", "ProjectId", "UserId", "JoinedAt", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440121', 'Owner', '550e8400-e29b-41d4-a716-446655440081', '550e8400-e29b-41d4-a716-446655440001', '2024-01-05 09:00:00', '2024-01-05 09:00:00', '2024-01-05 09:00:00'), ('550e8400-e29b-41d4-a716-446655440122', 'Member', '550e8400-e29b-41d4-a716-446655440081', '550e8400-e29b-41d4-a716-446655440002', '2024-01-05 09:30:00', '2024-01-05 09:30:00', '2024-01-05 09:30:00'), ('550e8400-e29b-41d4-a716-446655440123', 'Member', '550e8400-e29b-41d4-a716-446655440081', '550e8400-e29b-41d4-a716-446655440004', '2024-01-05 10:00:00', '2024-01-05 10:00:00', '2024-01-05 10:00:00'), ('550e8400-e29b-41d4-a716-446655440124', 'Owner', '550e8400-e29b-41d4-a716-446655440082', '550e8400-e29b-41d4-a716-446655440002', '2024-01-06 10:15:00', '2024-01-06 10:15:00', '2024-01-06 10:15:00'), ('550e8400-e29b-41d4-a716-446655440125', 'Owner', '550e8400-e29b-41d4-a716-446655440083', '550e8400-e29b-41d4-a716-446655440003', '2024-01-07 11:30:00', '2024-01-07 11:30:00', '2024-01-07 11:30:00'), ('660e8400-e29b-41d4-a716-446655440843', 'Owner', '550e8400-e29b-41d4-a716-446655440084', '550e8400-e29b-41d4-a716-446655440004', '2025-09-10 22:03:24', '2025-09-10 22:03:29', '2025-09-10 22:03:30');
INSERT INTO "TaskGenixDb"."Plans" ("Id", "Name", "Description", "DurationInDays", "Price", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440011', 'Free Plan', 'Basic features for individual users', '365', '0.00', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440012', 'Pro Plan', 'Advanced features for professionals', '30', '29.99', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440013', 'Team Plan', 'Collaboration features for teams', '30', '99.99', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440014', 'Enterprise Plan', 'Full feature set for large organizations', '365', '299.99', '2024-01-01 08:00:00', '2024-01-01 08:00:00');
INSERT INTO "TaskGenixDb"."Features" ("Id", "Key", "Name", "Unit", "FeatureType", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440021', 'projects_limit', 'Maximum Projects', 'count', 'Integer', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440022', 'tasks_per_project', 'Tasks per Project', 'count', 'Integer', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440023', 'storage_limit', 'Storage Limit', 'GB', 'Decimal', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440024', 'ai_generations', 'AI Task Generations', 'count', 'Integer', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440025', 'collaboration', 'Team Collaboration', 'boolean', 'Boolean', '2024-01-01 08:00:00', '2024-01-01 08:00:00');
INSERT INTO "TaskGenixDb"."PlanFeatures" ("Id", "QuotaValue", "IsUnlimited", "PlanId", "FeatureId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440031', '3', 'false', '550e8400-e29b-41d4-a716-446655440011', '550e8400-e29b-41d4-a716-446655440021', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440032', '10', 'false', '550e8400-e29b-41d4-a716-446655440011', '550e8400-e29b-41d4-a716-446655440022', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440033', '1', 'false', '550e8400-e29b-41d4-a716-446655440011', '550e8400-e29b-41d4-a716-446655440023', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440034', '50', 'false', '550e8400-e29b-41d4-a716-446655440011', '550e8400-e29b-41d4-a716-446655440024', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440035', '25', 'false', '550e8400-e29b-41d4-a716-446655440012', '550e8400-e29b-41d4-a716-446655440021', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440036', '100', 'false', '550e8400-e29b-41d4-a716-446655440012', '550e8400-e29b-41d4-a716-446655440022', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440037', '10', 'false', '550e8400-e29b-41d4-a716-446655440012', '550e8400-e29b-41d4-a716-446655440023', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440038', '500', 'false', '550e8400-e29b-41d4-a716-446655440012', '550e8400-e29b-41d4-a716-446655440024', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440039', null, 'true', '550e8400-e29b-41d4-a716-446655440013', '550e8400-e29b-41d4-a716-446655440021', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440040', null, 'true', '550e8400-e29b-41d4-a716-446655440013', '550e8400-e29b-41d4-a716-446655440022', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440041', '100', 'false', '550e8400-e29b-41d4-a716-446655440013', '550e8400-e29b-41d4-a716-446655440023', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440042', '2000', 'false', '550e8400-e29b-41d4-a716-446655440013', '550e8400-e29b-41d4-a716-446655440024', '2024-01-01 08:00:00', '2024-01-01 08:00:00'), ('550e8400-e29b-41d4-a716-446655440043', '1', 'false', '550e8400-e29b-41d4-a716-446655440013', '550e8400-e29b-41d4-a716-446655440025', '2024-01-01 08:00:00', '2024-01-01 08:00:00');
INSERT INTO "TaskGenixDb"."UserSettings" ("Id", "ReceiveEmailNotifications", "DarkModeEnabled", "Language", "UserId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440171', 'true', 'false', 'en-US', '550e8400-e29b-41d4-a716-446655440001', '2024-01-01 09:00:00', '2024-01-15 10:30:00'), ('550e8400-e29b-41d4-a716-446655440172', 'true', 'true', 'en-US', '550e8400-e29b-41d4-a716-446655440002', '2024-01-02 10:15:00', '2024-01-14 14:20:00'), ('550e8400-e29b-41d4-a716-446655440173', 'false', 'false', 'en-US', '550e8400-e29b-41d4-a716-446655440003', '2024-01-03 11:30:00', '2024-01-13 16:45:00'), ('550e8400-e29b-41d4-a716-446655440174', 'true', 'true', 'es-ES', '550e8400-e29b-41d4-a716-446655440004', '2024-01-04 12:45:00', '2024-01-12 08:15:00'), ('550e8400-e29b-41d4-a716-446655440175', 'false', 'false', 'en-US', '550e8400-e29b-41d4-a716-446655440005', '2024-01-05 13:20:00', '2024-01-05 13:20:00');
INSERT INTO "TaskGenixDb"."UserPlans" ("Id", "Name", "Price", "UserId", "PlanId", "StartDate", "EndDate", "IsActive", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440051', 'Pro Plan', '29.99', '550e8400-e29b-41d4-a716-446655440001', '550e8400-e29b-41d4-a716-446655440012', '2024-01-01 00:00:00+00', '2024-02-01 00:00:00+00', 'true', '2024-01-01 09:00:00', '2024-01-01 09:00:00'), ('550e8400-e29b-41d4-a716-446655440052', 'Free Plan', '0.00', '550e8400-e29b-41d4-a716-446655440002', '550e8400-e29b-41d4-a716-446655440011', '2024-01-02 00:00:00+00', '2025-01-02 00:00:00+00', 'true', '2024-01-02 10:15:00', '2024-01-02 10:15:00'), ('550e8400-e29b-41d4-a716-446655440053', 'Team Plan', '99.99', '550e8400-e29b-41d4-a716-446655440003', '550e8400-e29b-41d4-a716-446655440013', '2024-01-03 00:00:00+00', '2024-02-03 00:00:00+00', 'true', '2024-01-03 11:30:00', '2024-01-03 11:30:00'), ('550e8400-e29b-41d4-a716-446655440054', 'Enterprise Plan', '299.99', '550e8400-e29b-41d4-a716-446655440004', '550e8400-e29b-41d4-a716-446655440014', '2024-01-04 00:00:00+00', '2025-01-04 00:00:00+00', 'true', '2024-01-04 12:45:00', '2024-01-04 12:45:00');
INSERT INTO "TaskGenixDb"."UserPlanFeatures" ("Id", "QuotaTotal", "QuotaUsed", "QuotaRemaining", "IsUnlimited", "UserPlanId", "FeatureId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440061', '25.00', '5.00', '20.00', 'false', '550e8400-e29b-41d4-a716-446655440051', '550e8400-e29b-41d4-a716-446655440021', '2024-01-01 09:00:00', '2024-01-15 10:30:00'), ('550e8400-e29b-41d4-a716-446655440062', '100.00', '45.00', '55.00', 'false', '550e8400-e29b-41d4-a716-446655440051', '550e8400-e29b-41d4-a716-446655440022', '2024-01-01 09:00:00', '2024-01-15 10:30:00'), ('550e8400-e29b-41d4-a716-446655440063', '3.00', '2.00', '1.00', 'false', '550e8400-e29b-41d4-a716-446655440052', '550e8400-e29b-41d4-a716-446655440021', '2024-01-02 10:15:00', '2024-01-14 14:20:00'), ('550e8400-e29b-41d4-a716-446655440064', '10.00', '8.00', '2.00', 'false', '550e8400-e29b-41d4-a716-446655440052', '550e8400-e29b-41d4-a716-446655440022', '2024-01-02 10:15:00', '2024-01-14 14:20:00'), ('550e8400-e29b-41d4-a716-446655440065', '0.00', '15.00', '0.00', 'true', '550e8400-e29b-41d4-a716-446655440053', '550e8400-e29b-41d4-a716-446655440021', '2024-01-03 11:30:00', '2024-01-13 16:45:00'), ('550e8400-e29b-41d4-a716-446655440066', '0.00', '75.00', '0.00', 'true', '550e8400-e29b-41d4-a716-446655440053', '550e8400-e29b-41d4-a716-446655440022', '2024-01-03 11:30:00', '2024-01-13 16:45:00');
INSERT INTO "TaskGenixDb"."UserDeviceTokens" ("Id", "FCMToken", "DeviceId", "DeviceName", "Platform", "UserId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440181', 'dGhpc19pc19hX21vY2tfZmNtX3Rva2VuXzEyMzQ1', 'iPhone_12_Pro_001', 'John''s iPhone', 'iOS', '550e8400-e29b-41d4-a716-446655440001', '2024-01-01 09:00:00+00', '2024-01-15 10:30:00+00'), ('550e8400-e29b-41d4-a716-446655440182', 'YW5vdGhlcl9tb2NrX2ZjbV90b2tlbl9hYmNkZWY=', 'Pixel_6_002', 'Jane''s Pixel', 'Android', '550e8400-e29b-41d4-a716-446655440002', '2024-01-02 10:15:00+00', '2024-01-14 14:20:00+00'), ('550e8400-e29b-41d4-a716-446655440183', 'bW9ja19mY21fdG9rZW5fZm9yX2JvYl93aWxzb24=', 'Galaxy_S21_003', 'Bob''s Galaxy', 'Android', '550e8400-e29b-41d4-a716-446655440003', '2024-01-03 11:30:00+00', '2024-01-13 16:45:00+00'), ('550e8400-e29b-41d4-a716-446655440184', 'YWxpY2VfYnJvd25fZmNtX3Rva2VuXzc4OTEwMTExMg==', 'MacBook_Pro_004', 'Alice''s MacBook', 'macOS', '550e8400-e29b-41d4-a716-446655440004', '2024-01-04 12:45:00+00', '2024-01-12 08:15:00+00'), ('550e8400-e29b-41d4-a716-446655440185', 'Y2hhcmxpZV9kYXZpc19mY21fdG9rZW5fMTMxNDE1MTY=', 'iPad_Air_005', 'Charlie''s iPad', 'iOS', '550e8400-e29b-41d4-a716-446655440005', '2024-01-05 13:20:00+00', '2024-01-05 13:20:00+00');
INSERT INTO "TaskGenixDb"."TaskGens" ("Id", "Title", "Description", "Status", "Priority", "ProjectId", "DueDate", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440101', 'Create Homepage Wireframes', 'Design wireframes for the new homepage layout', 'InProgress', 'High', '550e8400-e29b-41d4-a716-446655440081', '2024-01-25 17:00:00+00', '2024-01-05 09:30:00', '2024-01-15 11:00:00'), ('550e8400-e29b-41d4-a716-446655440102', 'Implement User Authentication', 'Build login and registration functionality', 'Pending', 'High', '550e8400-e29b-41d4-a716-446655440081', '2024-02-01 17:00:00+00', '2024-01-05 10:00:00', '2024-01-05 10:00:00'), ('550e8400-e29b-41d4-a716-446655440103', 'Setup Database Schema', 'Create and configure database tables', 'Completed', 'Medium', '550e8400-e29b-41d4-a716-446655440081', '2024-01-20 17:00:00+00', '2024-01-05 10:30:00', '2024-01-20 16:30:00'), ('550e8400-e29b-41d4-a716-446655440104', 'Mobile App Market Research', 'Research competitor apps and market trends', 'InProgress', 'Medium', '550e8400-e29b-41d4-a716-446655440082', '2024-02-15 17:00:00+00', '2024-01-06 11:00:00', '2024-01-14 15:00:00'), ('550e8400-e29b-41d4-a716-446655440105', 'Create Social Media Content', 'Develop content for Q1 social media campaign', 'Completed', 'Low', '550e8400-e29b-41d4-a716-446655440083', '2024-02-28 17:00:00+00', '2024-01-07 12:00:00', '2024-02-25 14:00:00'), ('550e8400-e29b-41d4-a716-446655440106', 'API Documentation', 'Create comprehensive API documentation', 'Pending', 'Medium', '550e8400-e29b-41d4-a716-446655440081', '2024-02-10 17:00:00+00', '2024-01-16 09:00:00', '2024-01-16 09:00:00'), ('550e8400-e29b-41d4-a716-446655440107', 'UI/UX Testing', 'Conduct usability testing for mobile app', 'InProgress', 'High', '550e8400-e29b-41d4-a716-446655440082', '2024-02-20 17:00:00+00', '2024-01-17 10:00:00', '2024-01-20 15:00:00'), ('550e8400-e29b-41d4-a716-446655440108', 'Performance Optimization', 'Optimize database queries and indexing', 'Pending', 'Low', '550e8400-e29b-41d4-a716-446655440084', '2024-03-15 17:00:00+00', '2024-01-18 11:00:00', '2024-01-18 11:00:00');
INSERT INTO "TaskGenixDb"."TaskReminderConfigs" ("Id", "TaskGenId", "EnableReminders", "ReminderFrequencyInDays", "StartRemindingDaysBeforeDue", "ReminderIntervalInHours", "PreferredReminderHour", "EscalateReminderPriority", "PreferredChannel", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440131', '550e8400-e29b-41d4-a716-446655440101', 'true', '1', '3', '24', '9', 'true', 'Email', '2024-01-05 09:30:00', '2024-01-05 09:30:00'), ('550e8400-e29b-41d4-a716-446655440132', '550e8400-e29b-41d4-a716-446655440102', 'true', '2', '5', '48', '14', 'false', 'Push', '2024-01-05 10:00:00', '2024-01-05 10:00:00'), ('550e8400-e29b-41d4-a716-446655440133', '550e8400-e29b-41d4-a716-446655440104', 'true', '1', '2', '12', '10', 'true', 'Email', '2024-01-06 11:00:00', '2024-01-06 11:00:00');
INSERT INTO "TaskGenixDb"."TaskAssignments" ("Id", "TaskId", "UserId", "AssignedAt") VALUES ('550e8400-e29b-41d4-a716-446655440111', '550e8400-e29b-41d4-a716-446655440101', '550e8400-e29b-41d4-a716-446655440002', '2024-01-05 09:45:00'), ('550e8400-e29b-41d4-a716-446655440112', '550e8400-e29b-41d4-a716-446655440102', '550e8400-e29b-41d4-a716-446655440001', '2024-01-05 10:15:00'), ('550e8400-e29b-41d4-a716-446655440113', '550e8400-e29b-41d4-a716-446655440103', '550e8400-e29b-41d4-a716-446655440004', '2024-01-05 10:45:00'), ('550e8400-e29b-41d4-a716-446655440114', '550e8400-e29b-41d4-a716-446655440104', '550e8400-e29b-41d4-a716-446655440003', '2024-01-06 11:15:00'), ('550e8400-e29b-41d4-a716-446655440115', '550e8400-e29b-41d4-a716-446655440105', '550e8400-e29b-41d4-a716-446655440002', '2024-01-07 12:30:00'), ('550e8400-e29b-41d4-a716-446655440116', '550e8400-e29b-41d4-a716-446655440106', '550e8400-e29b-41d4-a716-446655440001', '2024-01-16 09:15:00'), ('550e8400-e29b-41d4-a716-446655440117', '550e8400-e29b-41d4-a716-446655440107', '550e8400-e29b-41d4-a716-446655440002', '2024-01-17 10:15:00'), ('550e8400-e29b-41d4-a716-446655440118', '550e8400-e29b-41d4-a716-446655440108', '550e8400-e29b-41d4-a716-446655440004', '2024-01-18 11:15:00');
INSERT INTO "TaskGenixDb"."ResourceLinks" ("Id", "Title", "Url", "Description", "Type", "TaskGenId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440161', 'Figma Design System', 'https://figma.com/design-system-templates', 'Design system templates and components', 'Design', '550e8400-e29b-41d4-a716-446655440101', '2024-01-05 10:00:00', '2024-01-05 10:00:00'), ('550e8400-e29b-41d4-a716-446655440162', 'Authentication Best Practices', 'https://auth0.com/docs/best-practices', 'Comprehensive guide on authentication implementation', 'Documentation', '550e8400-e29b-41d4-a716-446655440102', '2024-01-05 10:30:00', '2024-01-05 10:30:00'), ('550e8400-e29b-41d4-a716-446655440163', 'PostgreSQL Migration Guide', 'https://postgresql.org/docs/migration', 'Step-by-step database migration documentation', 'Documentation', '550e8400-e29b-41d4-a716-446655440103', '2024-01-05 11:00:00', '2024-01-05 11:00:00'), ('550e8400-e29b-41d4-a716-446655440164', 'App Store Guidelines', 'https://developer.apple.com/app-store/guidelines/', 'Apple App Store review guidelines', 'Reference', '550e8400-e29b-41d4-a716-446655440104', '2024-01-06 11:30:00', '2024-01-06 11:30:00'), ('550e8400-e29b-41d4-a716-446655440165', 'Social Media Analytics Tool', 'https://analytics.socialmedia.com', 'Tool for tracking social media performance metrics', 'Tool', '550e8400-e29b-41d4-a716-446655440105', '2024-01-07 13:00:00', '2024-01-07 13:00:00');
INSERT INTO "TaskGenixDb"."Recordings" ("Id", "Title", "FileUrl", "Duration", "ProjectId", "UserId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440091', 'Project Kickoff Meeting', 'https://storage.example.com/recordings/kickoff_001.mp3', '01:45:30', '550e8400-e29b-41d4-a716-446655440081', '550e8400-e29b-41d4-a716-446655440001', '2024-01-05 09:30:00+00', '2024-01-05 09:30:00+00'), ('550e8400-e29b-41d4-a716-446655440093', 'Marketing Strategy Discussion', 'https://storage.example.com/recordings/marketing_003.mp3', '02:15:45', '550e8400-e29b-41d4-a716-446655440083', '550e8400-e29b-41d4-a716-446655440003', '2024-01-08 16:00:00+00', '2024-01-08 16:00:00+00');
INSERT INTO "TaskGenixDb"."PaymentTransactions" ("Id", "Amount", "Currency", "TransactionDate", "PaymentMethod", "PaymentGateway", "ExternalTransactionId", "Status", "UserId", "UserPlanId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440071', '29.99', 'USD', '2024-01-01 09:00:00', 'Credit Card', 'Stripe', 'txn_1234567890', 'Completed', '550e8400-e29b-41d4-a716-446655440001', '550e8400-e29b-41d4-a716-446655440051', '2024-01-01 09:00:00', '2024-01-01 09:00:00'), ('550e8400-e29b-41d4-a716-446655440072', '99.99', 'USD', '2024-01-03 11:30:00', 'PayPal', 'PayPal', 'PAYID-ABC123DEF', 'Completed', '550e8400-e29b-41d4-a716-446655440003', '550e8400-e29b-41d4-a716-446655440053', '2024-01-03 11:30:00', '2024-01-03 11:30:00'), ('550e8400-e29b-41d4-a716-446655440073', '299.99', 'USD', '2024-01-04 12:45:00', 'Bank Transfer', 'Stripe', 'txn_0987654321', 'Completed', '550e8400-e29b-41d4-a716-446655440004', '550e8400-e29b-41d4-a716-446655440054', '2024-01-04 12:45:00', '2024-01-04 12:45:00');
INSERT INTO "TaskGenixDb"."Notifications" ("Id", "Title", "Message", "Type", "IsSent", "IsRead", "TaskGenId", "SequenceNumber", "ReminderPattern", "ReminderSeriesId", "ScheduledTime", "SentAt", "DeliveryStatus", "DeliveryChannel", "UserId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440141', 'Task Due Soon', 'Your task "Create Homepage Wireframes" is due in 2 days', 'DueDate', 'true', 'false', '550e8400-e29b-41d4-a716-446655440101', '1', 'Daily', '550e8400-e29b-41d4-a716-446655440151', '2024-01-23 09:00:00+00', '2024-01-23 09:00:00+00', 'Sent', 'Email', '550e8400-e29b-41d4-a716-446655440002', '2024-01-23 08:55:00', '2024-01-23 09:00:00'), ('550e8400-e29b-41d4-a716-446655440142', 'New Task Assigned', 'You have been assigned a new task: "Implement User Authentication"', 'TaskAssigned', 'true', 'true', '550e8400-e29b-41d4-a716-446655440102', null, null, null, null, '2024-01-05 10:15:00+00', 'Sent', 'PushNotification', '550e8400-e29b-41d4-a716-446655440001', '2024-01-05 10:15:00', '2024-01-05 10:15:00'), ('550e8400-e29b-41d4-a716-446655440143', 'Task Completed', 'Task "Setup Database Schema" has been marked as completed', 'TaskCompleted', 'true', 'false', '550e8400-e29b-41d4-a716-446655440103', null, null, null, null, '2024-01-20 16:30:00+00', 'Sent', 'Email', '550e8400-e29b-41d4-a716-446655440001', '2024-01-20 16:30:00', '2024-01-20 16:30:00'), ('550e8400-e29b-41d4-a716-446655440144', 'Welcome to TaskGenix', 'Welcome to TaskGenix! Get started by creating your first project.', 'Information', 'true', 'true', null, null, null, null, null, '2024-01-01 09:00:00+00', 'Delivered', 'Email', '550e8400-e29b-41d4-a716-446655440001', '2024-01-01 09:00:00', '2024-01-15 10:30:00');
INSERT INTO "TaskGenixDb"."Attachments" ("Id", "FileName", "FileType", "FileSize", "Data", "TaskGenId", "CreatedAt", "UpdatedAt") VALUES ('550e8400-e29b-41d4-a716-446655440151', 'wireframe_homepage_v1.pdf', 'application/pdf', '2048576', '\x255044462d312e340a25d0d4c5d80a34203020206f626a0a3c3c0a2f4c656e6774682035203020520a2f46696c7465722f466c6174654465636f64650a3e3e0a73747265616d0a', '550e8400-e29b-41d4-a716-446655440101', '2024-01-10 14:30:00', '2024-01-10 14:30:00'), ('550e8400-e29b-41d4-a716-446655440152', 'auth_requirements.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', '524288', '\x504b030414000600080000002100b7b94f4d61010000e7040000130008025b436f6e74656e745f54797065735d2e786d6c20a2040228a0000200000000000000000000', '550e8400-e29b-41d4-a716-446655440102', '2024-01-05 11:00:00', '2024-01-05 11:00:00'), ('550e8400-e29b-41d4-a716-446655440153', 'database_schema.sql', 'text/plain', '10240', '\x435245415445205441424c4520757365727320280a20206964205345524941204e4f54204e554c4c2050524956415259204b45592c0a20206e616d6520564152434841522835302920554e495155452c0a2020656d61696c20564152434841522831303029204e4f54204e554c4c0a293b', '550e8400-e29b-41d4-a716-446655440103', '2024-01-08 16:45:00', '2024-01-08 16:45:00');