Once we've merged all the new work to master and it has been deployed, we will need to run the following script on the live database in order to turn existing users to trial users.
copy the evaluated number from the line belowDate.now() + (90 * 24 * 60 * 60 * 1000)Paste it in the script down belowupdate users set trial_expiry_time = TIMEFROMABOVE where is_lecturer=true and group_code is null and trial_expiry_time is null and is_group_admin = false RETURNING *;
Run this script on the live postgresDB. I'm happy to do this once we have all the work on prod.
Hi @iteles,
Once we've merged all the new work to master and it has been deployed, we will need to run the following script on the live database in order to turn existing users to trial users.
copy the evaluated number from the line below
Date.now() + (90 * 24 * 60 * 60 * 1000)
Paste it in the script down belowupdate users set trial_expiry_time = TIMEFROMABOVE where is_lecturer=true and group_code is null and trial_expiry_time is null and is_group_admin = false RETURNING *;
Run this script on the live postgresDB. I'm happy to do this once we have all the work on prod.