![[ DNS Administrator ]](/fx/dnsadmin-logo.png){kind=logo}
Changeset 1014 for branches/cname-collision
- Timestamp:
- 02/03/26 11:04:09 (3 days ago)
- Location:
- branches/cname-collision/t
- Files:
-
- 2 edited
-
dns-unitbase.sql (modified) (6 diffs)
-
test-cname-timestamps.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/cname-collision/t/dns-unitbase.sql
r998 r1014 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 2026013007 D t 661 662 \. 662 663 … … 666 667 -- 667 668 668 SELECT pg_catalog.setval('public.domains_domain_id_seq', 5, true);669 SELECT pg_catalog.setval('public.domains_domain_id_seq', 6, true); 669 670 670 671 … … 784 785 76 5 1 1 admin Initial User Added record 'valid-after4.expiry2.test TXT valid quite soon', TTL 5400, expires at 2026-01-15 18:00 2026-01-19 11:40:07.438603-05 0 0 785 786 77 5 1 1 admin Initial User Added record 'valid-after5.expiry2.test TXT expires before pending valid', TTL 5400, expires at 2026-01-15 18:00 2026-01-19 11:40:55.325144-05 0 0 787 78 6 1 1 admin Initial User Added active domain expiry3.test 2026-01-29 18:05:53.678277-05 0 0 788 79 6 1 1 admin Initial User [new expiry3.test] Added SOA record [contact ns1.example.com] [master hostmaster.expiry3.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2026-01-29 18:05:53.678277-05 0 78 789 80 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test NS ns2.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 790 81 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test NS ns1.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 791 82 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test A 10.0.0.4', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 792 83 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test MX [distance 10] mx1.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 793 84 6 1 1 admin Initial User [new expiry3.test] Added record 'www.expiry3.test CNAME expiry3.test', TTL 10800 2026-01-29 18:05:53.678277-05 0 78 794 85 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test TXT "v=spf1 a mx -all"', TTL 10800 2026-01-29 18:05:53.678277-05 0 78 795 86 6 1 1 admin Initial User Added record 'nostamp1a.expiry3.test TXT target - expired', TTL 5400, expires at 2026-01-29 14:00 2026-01-30 15:07:08.695134-05 0 0 796 87 6 1 1 admin Initial User Added record 'nostamp2a.expiry3.test TXT target - soon to expire', TTL 5400, expires at 2026-01-31 14:00 2026-01-30 15:07:34.780671-05 0 0 797 88 6 1 1 admin Initial User Added record 'nostamp3a.expiry3.test TXT target - valid soon', TTL 5400, valid after 2026-01-31 14:00 2026-01-30 15:07:53.379107-05 0 0 798 89 6 1 1 admin Initial User Added record 'nostamp4a.expiry3.test TXT target - already valid', TTL 5400, valid after 2026-01-29 14:00 2026-01-30 15:08:15.4399-05 0 0 799 90 6 1 1 admin Initial User Added record 'nostamp1b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:48.433198-05 0 0 800 91 6 1 1 admin Initial User Added record 'nostamp2b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:53.902318-05 0 0 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 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 786 803 \. 787 804 … … 791 808 -- 792 809 793 SELECT pg_catalog.setval('public.log_log_id_seq', 77, true);810 SELECT pg_catalog.setval('public.log_log_id_seq', 93, true); 794 811 795 812 … … 899 916 5 66 valid-after4.expiry2.test 16 valid quite soon 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 f t \N 900 917 5 67 valid-after5.expiry2.test 16 expires before pending valid 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 t t \N 918 6 68 ns1.example.com:hostmaster.expiry3.test 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N 919 6 69 expiry3.test 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 920 6 70 expiry3.test 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 921 6 71 expiry3.test 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 922 6 72 expiry3.test 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 923 6 73 www.expiry3.test 5 expiry3.test 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 924 6 74 expiry3.test 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 925 6 75 nostamp1a.expiry3.test 16 target - expired 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 t t \N 926 6 76 nostamp2a.expiry3.test 16 target - soon to expire 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 t t \N 927 6 77 nostamp3a.expiry3.test 16 target - valid soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 f t \N 928 6 78 nostamp4a.expiry3.test 16 target - already valid 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 929 6 79 nostamp1b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 930 6 80 nostamp2b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 931 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 6 82 nostamp4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 901 933 \. 902 934 … … 906 938 -- 907 939 908 SELECT pg_catalog.setval('public.records_record_id_seq', 67, true);940 SELECT pg_catalog.setval('public.records_record_id_seq', 82, true); 909 941 910 942 -
branches/cname-collision/t/test-cname-timestamps.sql
r998 r1014 18 18 UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 67; 19 19 20 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 75; 21 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 76; 22 UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 77; 23 UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 78;
Note:
See TracChangeset
for help on using the changeset viewer.
