-- 2. Insert an unconsumed fresh trial activation code INSERT INTO "ActivationCodes" ( "Id", "Code", "TenantId", "ClassroomId", "TargetClassNameAtIssue", "IsUsed", "Status", "DistributionMethod", "AssignedAt", "ExpiresAt", "LicenseTier", "LicenseDurationDays" ) VALUES ( 'act_test_exp_ovr_voucher', 'TEST-EXPIRED-OVR1', 't_beijing_no4', 'cls_801', 'Test Class', false, 'Issued', 'TeacherAccount', NOW(), NOW() + INTERVAL '30 days', 'Trial', 7 ) ON CONFLICT ("Code") DO UPDATE SET "IsUsed" = false, "Status" = 'Issued';