![[ DNS Administrator ]](/fx/dnsadmin-logo.png){kind=logo}
Changeset 1017 for branches/cname-collision
- Timestamp:
- 02/03/26 15:57:28 (5 days ago)
- Location:
- branches/cname-collision/t
- Files:
-
- 2 edited
-
dns-unitbase.sql (modified) (5 diffs)
-
test-cname-timestamps.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/cname-collision/t/dns-unitbase.sql
r1014 r1017 659 659 4 expiry1.test 1 1 2026011400 D t 660 660 5 expiry2.test 1 1 2026011901 D t 661 6 expiry3.test 1 1 20260 13007D t661 6 expiry3.test 1 1 2026020311 D t 662 662 \. 663 663 … … 801 801 92 6 1 1 admin Initial User Added record 'nostamp3b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:57.875273-05 0 0 802 802 93 6 1 1 admin Initial User Added record 'nostamp4b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:30:01.924263-05 0 0 803 94 6 1 1 admin Initial User Added record 'expires1a.expiry3.test TXT target - no timestamp', TTL 5400 2026-02-03 12:02:32.883354-05 0 0 804 95 6 1 1 admin Initial User Added record 'expires2a.expiry3.test TXT target - expired', TTL 5400, expires at 2026-01-29 14:00 2026-02-03 12:03:09.031474-05 0 0 805 96 6 1 1 admin Initial User Added record 'expires3a.expiry3.test TXT target - expires soon', TTL 5400, expires at 2026-01-31 14:00 2026-02-03 12:04:30.954558-05 0 0 806 97 6 1 1 admin Initial User Added record 'expires4a.expiry3.test TXT target - valid soon', TTL 5400, valid after 2026-01-31 14:00 2026-02-03 12:04:52.864866-05 0 0 807 98 6 1 1 admin Initial User Added record 'expires5a.expiry3.test TXT target - already valid', TTL 5400, valid after 2026-01-29 14:00 2026-02-03 12:05:10.629373-05 0 0 808 99 6 1 1 admin Initial User Added record 'expires6a.expiry3.test TXT target - valid less soon', TTL 5400, valid after 2026-01-15 18:00 2026-02-03 12:05:31.096289-05 0 0 809 100 6 1 1 admin Initial User Added record 'expires1b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:33.779645-05 0 0 810 101 6 1 1 admin Initial User Added record 'expires2b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:44.12329-05 0 0 811 102 6 1 1 admin Initial User Added record 'expires3b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:50.968888-05 0 0 812 103 6 1 1 admin Initial User Added record 'expires4b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:56.415551-05 0 0 813 104 6 1 1 admin Initial User Added record 'expires5b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:06:01.591204-05 0 0 814 105 6 1 1 admin Initial User Added record 'expires6b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:06:34.192183-05 0 0 803 815 \. 804 816 … … 808 820 -- 809 821 810 SELECT pg_catalog.setval('public.log_log_id_seq', 93, true);822 SELECT pg_catalog.setval('public.log_log_id_seq', 105, true); 811 823 812 824 … … 931 943 6 81 nostamp3b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 932 944 6 82 nostamp4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 945 6 83 expires1a.expiry3.test 16 target - no timestamp 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 946 6 84 expires2a.expiry3.test 16 target - expired 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 t t \N 947 6 85 expires3a.expiry3.test 16 target - expires soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 t t \N 948 6 86 expires4a.expiry3.test 16 target - valid soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 f t \N 949 6 87 expires5a.expiry3.test 16 target - already valid 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 950 6 88 expires6a.expiry3.test 16 target - valid less soon 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 951 6 89 expires1b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 952 6 90 expires2b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 953 6 91 expires3b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 954 6 92 expires4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 955 6 93 expires5b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 956 6 94 expires6b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 933 957 \. 934 958 … … 938 962 -- 939 963 940 SELECT pg_catalog.setval('public.records_record_id_seq', 82, true);964 SELECT pg_catalog.setval('public.records_record_id_seq', 94, true); 941 965 942 966 -
branches/cname-collision/t/test-cname-timestamps.sql
r1014 r1017 22 22 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 77; 23 23 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 78; 24 25 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 84; 26 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 85; 27 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 86; 28 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 87; 29 UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record_id = 88;
Note:
See TracChangeset
for help on using the changeset viewer.
