Changeset 1017 for branches/cname-collision/t/test-cname-timestamps.sql

Timestamp:

02/03/26 15:57:28 (10 days ago)

Author:

Kris Deugau

Message:

/branches/cname-collision

Add record group for testing update to CNAME with expiry
See #72, #88

File:

• branches/cname-collision/t/test-cname-timestamps.sql (modified) (1 diff)

branches/cname-collision/t/test-cname-timestamps.sql

@@ -22 +22 @@
 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 77;
 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 78;
+
+UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 84;
+UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 85;
+UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 86;
+UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 87;
+UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record_id = 88;