diff --git a/keyserver/src/scripts/force-policy-acknowledgment.js b/keyserver/src/scripts/force-policy-acknowledgment.js new file mode 100644 index 000000000..39efbb506 --- /dev/null +++ b/keyserver/src/scripts/force-policy-acknowledgment.js @@ -0,0 +1,20 @@ +// @flow + +import { policyTypes } from 'lib/facts/policies.js'; + +import { dbQuery, SQL } from '../database/database.js'; +import { main } from './utils.js'; + +// time when policy was officially published for users +const policyUpdateTime = new Date('2022-12-30T00:00:00').getTime(); + +async function forcePolicyAcknowledgment() { + await dbQuery(SQL` + UPDATE policy_acknowledgments + SET confirmed = 0 + WHERE date <= ${policyUpdateTime} + AND policy = ${policyTypes.tosAndPrivacyPolicy} + `); +} + +main([forcePolicyAcknowledgment]);