TheArchive/headscale
1
0
Fork 0
mirror of https://github.com/juanfont/headscale.git synced 2025-08-11 21:17:35 +00:00
Code Issues Packages Projects Releases Wiki Activity
Files
main
headscale/hscontrol/db/testdata/sqlite/from_nblock_db02__0.22.1__0.24.1.sql
Kristoffer Dalby c6736dd6d6 db: add sqlite "source of truth" schema 
Signed-off-by: Kristoffer Dalby <kristoffer@tailscale.com>
2025-07-07 15:48:38 +01:00

105 lines
42 KiB
SQL
Raw Permalink Blame History

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE `migrations` (`id` text,PRIMARY KEY (`id`));
INSERT INTO migrations VALUES('202312101416');
INSERT INTO migrations VALUES('202312101430');
INSERT INTO migrations VALUES('202402151347');
INSERT INTO migrations VALUES('2024041121742');
INSERT INTO migrations VALUES('202406021630');
INSERT INTO migrations VALUES('202409271400');
INSERT INTO migrations VALUES('202407191627');
INSERT INTO migrations VALUES('202408181235');
INSERT INTO migrations VALUES('202501221827');
CREATE TABLE IF NOT EXISTS "pre_auth_keys" (`id` integer,`key` text,`user_id` integer,`reusable` numeric,`ephemeral` numeric DEFAULT false,`used` numeric DEFAULT false,`created_at` datetime,`expiration` datetime, `tags` text,PRIMARY KEY (`id`),CONSTRAINT `fk_pre_auth_keys_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE);
INSERT INTO pre_auth_keys VALUES(1,'463a8b372963aeaca12400faa0c7ea29e9bfa3b4c59e9622',3,0,0,1,'2023-05-19 05:09:19.66636462+00:00','2023-05-19 05:14:19.664224869+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(2,'77a019cb12c0d0b9347a17ab23fa4c87983814fe36bb2fbb',14,0,0,0,'2024-05-03 08:13:55.8614948+00:00','2024-05-04 08:13:55.85782156+00:00',NULL);
CREATE TABLE IF NOT EXISTS "api_keys" (`id` integer,`prefix` text UNIQUE,`hash` blob,`created_at` datetime,`expiration` datetime,`last_seen` datetime,PRIMARY KEY (`id`));
CREATE TABLE IF NOT EXISTS "nodes" (`id` integer,`machine_key` text,`node_key` text,`disco_key` text,`hostname` text,`given_name` varchar(63),`user_id` integer,`register_method` text,`forced_tags` text,`auth_key_id` integer,`last_seen` datetime,`expiry` datetime,`host_info` text,`endpoints` text,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`ipv4` text,`ipv6` text,PRIMARY KEY (`id`),CONSTRAINT `fk_nodes_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,CONSTRAINT `fk_nodes_auth_key` FOREIGN KEY (`auth_key_id`) REFERENCES `pre_auth_keys`(`id`) ON DELETE SET NULL);
INSERT INTO nodes VALUES(1,'mkey:0ea01e8cd608548a171ebcedc16da73b25ec18d58861be7a6b4274eb17baf6ba','nodekey:0fcf591dc1997c1d7388a3835bd24dae48240e5b03b6a7f5f33b2e813d222bcf','discokey:ed27f0b3c04222f0d05bfbc6fb5787338275ed0e32fd42fe68c669aca0f3d7a4','desktop-54','node001',2,'cli','null',NULL,'2025-01-16 10:47:40.213920406+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b8f0:cf44:22c8:82d1:f79:c3eb:9144:c24f]:6142","[8e25:af1:e31a:8fcc:7dcf:be1:a3c9:ed6a]:38766","[37a1:215f:bf3d:3fb1:6399:f7cb:4048:3ca8]:51666","137.242.125.72:25376","86.84.184.63:26062","[c187:a8:1181:8321:28ab:fe72:b0b8:8ec6]:41236","[9089:461f:ad5b:68d4:f7a8:618a:a52a:56ac]:63162"]','2023-05-17 19:38:13.531518257+02:00','2025-01-16 10:47:40.214263246+01:00',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(2,'mkey:348464565f0009e9205c9a78f381e12b9cf63ee2006b8e95d720a274347c4847','nodekey:bff28b3734e3343ded434f23bbffe562bab527165158c992e1126c94f39ea877','discokey:9c077cf7719204300ecc1ab64fb6bd3cc0cd398a4a208e37ed79e4500db3f86c','db-91','node002',1,'cli',NULL,NULL,'2025-01-30 19:01:13.901141508+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["165.5.239.20:48876","44.184.117.89:36643","90.223.136.253:7056","[e43c:be7:7f4e:8217:a009:7f9d:a510:1af6]:18872","[3a86:865b:2f4c:f3b7:88a0:4aa2:f05d:c3fd]:47680","86.50.30.30:18216","[fdbe:7908:805e:6c8f:47c2:2c87:b1c4:44]:48470","188.237.187.170:7622","[c032:e70d:dbd3:27de:85a3:28b4:8a64:155a]:48864"]','2023-05-18 10:09:21.757289398+02:00','2025-01-30 19:01:13.901463969+01:00',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(3,'mkey:cd435d043e3dba7c0cd2f089c57c46abd59f84c1d05d5b9ea03d344a6dd7e61c','nodekey:5a558233f8e076e1f3a78e95e274265332c984372e8bfa91c62e748707e3d9c8','discokey:d2dbd001168ca99d38dd2b56270201056955f5d05a97934278b7a8311d809e37','laptop-91','node003',3,'authkey','[]',1,'2025-01-26 12:49:44.580858758+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d40d:59d:b450:8ad7:bc04:9836:f16d:d538]:10080","87.84.28.245:43373"]','2023-05-19 07:09:21.399903526+02:00','2025-01-26 12:49:44.582326495+01:00',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:4b507fc1f103042642d3c619b0cdc77a6dadb4415ccd78b5b3880f4fcacacef6','nodekey:259a4b5de585a90421714fe40040c339a26a660b1fa0511f6323e51926b88c5c','discokey:36b7d0cbd65c02c741958c3e793960fcf2b93f7d907fc4483f548043864bdbae','laptop-59','node004',4,'cli',NULL,NULL,'2025-01-30 19:08:13.209119931+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["1.79.159.39:34092","[b12e:af88:3c55:41f8:5fba:2aa3:3248:15c1]:23643"]','2023-06-10 09:31:51.940506933+02:00','2025-01-30 19:08:13.209865565+01:00',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(5,'mkey:4937d77921b93317ae3fb1fb406ffd3fa2d9154afa78c3ed00a5a685ede9aaae','nodekey:3c38f956817733cb7dfb474be1a8289f90ae0cb4df5dfd42ad8fc57e3a35b702','discokey:9abee320c0000a4f325c4aaf75173a715bbd1dc88f93699df10e7bf06ba0097f','email-95','node005',4,'cli',NULL,NULL,'2025-01-30 19:08:24.678660839+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[cd19:68e0:693d:5e6:659d:9f7e:277e:21cf]:31475","86.42.90.60:13473","[14af:1283:fc98:5791:282:5e8:a450:315f]:22243","201.199.139.78:9445","121.159.150.133:23963"]','2023-06-11 13:56:42.694329408+02:00','2025-01-30 19:08:24.679099806+01:00',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(6,'mkey:33535c582e158d27acdafdda3edd3777fd581ddc2adad52eaee607a82a0f9d9c','nodekey:144ba4b580e0d6d9add9a482c5f893deba28ec44622ccd056a06a9ddf80af32c','discokey:62d0e22d743d8096882b23d1bc5f5810863dc39876bbec1253ff2a4c445f423b','db-15','node006',4,'cli',NULL,NULL,'2025-01-30 19:08:06.034183297+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[698:f124:543f:b5b7:644e:5b79:4160:6e0b]:42676","165.236.227.226:53522","[e65d:59b5:f599:8596:2bc9:56b7:820a:8c12]:12277","[8ddd:4aae:2b94:4c1a:d05f:65d2:2bdb:b400]:42839","[c493:a941:58b6:7634:6221:70ba:20e6:40c4]:35486"]','2023-06-11 13:57:44.975695604+02:00','2025-01-30 19:08:06.034942035+01:00',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(7,'mkey:26d1a98dc9d16df9ce9692bd330c25b5d021d11ff35b15a79f282b51c7f13888','nodekey:dd3d71574aa1270acb5176b071f1e99f512a4436ac20050df6d617865d2e47f9','discokey:def83e0a3c95bb379b8af036680ce07aa7725d1d2c4b7feb656c5a441f51fef7','laptop-38','node007',4,'cli',NULL,NULL,'2025-01-30 19:07:54.580925698+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[cef3:87e9:7ebe:e5a3:a6a0:5dc2:7a83:6a84]:43421","177.175.178.171:24266","[489b:6c59:1877:6215:ddc8:57f8:78dc:321c]:3025","77.213.161.20:47662","[adea:86d3:b312:f445:d835:6023:f1f:f928]:27483","124.104.237.237:47957"]','2023-06-11 14:16:56.951313537+02:00','2025-01-30 19:07:54.581710417+01:00',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(8,'mkey:9ced3abf3a281d71b6f361a75769c571c4aff9e4cbab5b317f6cf18918f66bbc','nodekey:e533ead6c5b810764db07631d7b9b14434bf66549837d33a6187daac1ab1d7a9','discokey:571a7ba01a8a0fff2af21d0f135caf8ae2ee0e15fd5ab996d2e490cf968d7217','email-22','node008',5,'cli',NULL,NULL,'2025-01-30 19:08:26.01751405+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5b29:3bfe:7aa9:2767:900a:8142:1ae:eb94]:59942","165.200.68.0:39862","187.166.20.165:11208"]','2023-06-11 19:59:30.401970393+02:00','2025-01-30 19:08:26.017863321+01:00',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(9,'mkey:4115777754bb14ec2d04345ee2ffb97968692a59f0f66fc4aec9737616903f41','nodekey:5a0133001bc6b02d996ea2e2cae3abcfcb073d69a25aefd4077f36c564af0075','discokey:91ec1c63e9572a6742c8bf8796ce7f5ffc3d42a03ad53070a3ee56a2523317a9','lt-39','node009',6,'cli',NULL,NULL,'2025-01-26 12:49:38.323826827+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["192.120.123.140:19810","63.152.247.204:38090"]','2023-06-17 19:40:45.468789461+02:00','2025-01-26 12:49:38.324187836+01:00',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(10,'mkey:94da5084f8fc1cfe7671b94a0d7ef767719bd0fed89f16bc2726728db4cd9d25','nodekey:e6527563ef7a2647b6c719e0c9c95c1ab2a2eeef7fbb3f46a108ee0fbca026f0','discokey:f76230afd20bfcce74fd0d689b35e82cab5bfdf4cd1530073e87b1acae513c2b','web-50','node010',6,'cli',NULL,NULL,'2025-01-30 05:10:56.348559998+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[bed5:a4c2:8547:c044:9956:2566:d794:c918]:56801","113.147.88.203:61138","22.207.212.228:27547","[2c3e:2260:8c34:275:2287:b721:1bdb:d462]:59540","70.115.64.117:6906"]','2023-06-20 11:18:35.905417341+02:00','2025-01-30 05:10:56.349025961+01:00',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(11,'mkey:4b59a62af15d9350f16c9a2e03aa6174692418948d6a5ad5c272f5bb88feb061','nodekey:5004a6cb840ab527bcf897c17761fd30338b1250b3a9e0ac3e3c60a422ee09d0','discokey:e191e0039edbf786f88ab163173eb3c297e060f51cb90249f36e4867d5d89928','email-58','node011',7,'cli',NULL,NULL,'2025-01-30 16:14:19.573081099+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f99c:24c3:b1b5:8b96:abe2:3ddc:c21e:87dc]:65141","[dfe7:6f6b:a382:4fc:a3f6:eb9:9ebc:5798]:1474","56.63.78.181:15200","[314c:5aba:d6ac:63d3:4de3:2c46:5e60:903b]:30789"]','2023-06-20 11:35:15.063855316+02:00','2025-01-30 16:14:19.573230274+01:00',NULL,'100.64.0.11','fd7a:115c:a1e0::b');
INSERT INTO nodes VALUES(12,'mkey:88ef4bda4139c7c09e33bbc866b88e069c51187346d8095238179c82502dffcc','nodekey:7ad274415b296099222e0ca334eb849e0e6595ffa54dbcc94a0fc9ffa69d1747','discokey:388c1077bdd17ce1f86b92936609756ecd3e8b21ab3f4b8a84da7727dd2b2552','web-70','node012',5,'cli',NULL,NULL,'2025-01-30 19:07:30.410870761+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["33.51.84.119:46756","[c844:704e:c3c0:e709:8f94:3564:1b4d:d2d9]:8357","[169:f098:49e9:99af:27bb:802f:fc22:bd59]:63749"]','2023-06-20 18:22:35.061914624+02:00','2025-01-30 19:07:30.411307945+01:00',NULL,'100.64.0.12','fd7a:115c:a1e0::c');
INSERT INTO nodes VALUES(18,'mkey:c2e0286f5c59bc66c9a7c950ffc72f8241916be6e9f16861fe3680cb3cd2c172','nodekey:2c67affcede5c938b2b0aa8a0a42753fecc147bcad5f3df411aa999751a3482d','discokey:7f4e89781a7a169060fdedb120b316e88a2c66f40c41118bdc1759ff818a28bc','srv-41','node018',9,'cli',NULL,NULL,'2025-01-30 09:35:22.409611504+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["204.36.161.195:61712","[bfe5:7c2f:e9:71b:749a:5176:3138:83c6]:63942","24.173.68.87:39654","216.16.204.79:19720"]','2023-06-22 08:30:54.08720463+02:00','2025-01-30 09:35:22.410235858+01:00',NULL,'100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(19,'mkey:28aaec5617646c94f895ba9449d924469be2345700d80131bd72c449b02346bb','nodekey:419dd05380491ade058b139b43fda78a99d52b00cb1984180c3f251c19c7bac1','discokey:0f0490d46f8794af22a08c1d6e874ee8303df7ba39095fdd78db9522849ed427','web-93','node019',10,'cli','null',NULL,'2024-08-07 09:35:12.220368767+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[7b81:52eb:f4e9:e74d:905:79d4:67b1:d359]:13795","81.17.18.155:10091"]','2023-07-03 15:18:03.829428454+02:00','2024-09-18 16:15:14.037990869+02:00',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(20,'mkey:8bc474d6d0d812ab011b7748675802bd9d4af70c2edab0da6c682a0cf1ca34f8','nodekey:2cb4a0ab98e83dafb20621dcfec33cd5fa7fa99b97998546cb6796249bdba88a','discokey:e341e99f352acb61779807aea844516d7e9e220c58699f09232bcee105e88797','lt-43','node020',11,'cli',NULL,NULL,'2025-01-30 18:17:53.075807086+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["63.3.67.150:22907","[77ac:562:7c4c:438a:6ec:be48:743d:47b1]:11349","[33cd:731c:f110:9b45:66b5:de81:1daa:757f]:5997","[d618:5830:8a37:fbe4:3b37:a35c:fad9:11d1]:57112","9.144.234.157:13194"]','2023-07-10 12:40:34.838579199+02:00','2025-01-30 18:17:53.076540774+01:00',NULL,'100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(21,'mkey:84000655b74a39e42877c1941d84a4e5b94db841c5440f19950813a5c25e1204','nodekey:bf71cc04a7b081255d32ce73fa666db0090b20af8e6e6115d279edead8b15227','discokey:b37d86213f6b344b4b24c73541b9c65e5aebcfa8d5c25114d10ef57761da6c09','lt-77','node021',11,'cli','null',NULL,'2023-11-20 07:19:19.447470862+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[68:80fa:7b30:3a0:d1fb:3e89:2c73:256b]:30308","[ad42:3917:5edb:3e85:732:1c71:a19e:9fe0]:11799","25.63.36.137:903","179.61.150.131:36912"]','2023-07-10 12:42:43.290469734+02:00','2024-09-18 16:15:14.03886353+02:00',NULL,'100.64.0.15','fd7a:115c:a1e0::f');
INSERT INTO nodes VALUES(22,'mkey:5f7118e434c174dbac710b1d088db6213ca894ca3912a92688110ed5f96eb37d','nodekey:eb2dc8689a32bb671c62e8744f2c968b9ecf3a0e1e50775de39a0f2a4f4011aa','discokey:bc1e75ccfe1c7c282df689d559cc5ef08659f1ee198456bc82df99e13371dd1c','desktop-81','node022',6,'cli',NULL,NULL,'2025-01-26 12:49:36.385301301+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["146.144.83.178:46323","1.236.14.11:13477","184.41.32.72:1026","[f136:8b69:185a:7ec7:94a1:ca58:5d95:ba9f]:21119"]','2023-08-05 12:08:48.132161695+02:00','2025-01-26 12:49:36.385653182+01:00',NULL,'100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(23,'mkey:94d0eadf801d88022019f9353b7c29cafdd060a269a0245396e01f1293953cb0','nodekey:1db769d2ca42bc0f8b4e18b5c89a31fb4595edf0592ce1a534b713ba503f07e9','discokey:912056b78049017764c78a047b65feb3c3b934fa26ac62b44f8d7d561711321a','srv-85','node023',12,'cli','null',NULL,'2024-12-07 19:25:56.935152754+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["21.107.170.69:30767","212.18.227.41:50735","[f774:e89b:980f:975d:fd3e:93f:a9b5:2034]:46054","[7225:d0ce:d29a:59d8:f596:b945:9a02:29ed]:43419","[5a76:d5b0:b51d:6b56:afaa:3968:277b:192c]:19250"]','2023-12-15 08:05:56.592241745+01:00','2024-12-07 19:25:56.935317645+01:00',NULL,'100.64.0.18','fd7a:115c:a1e0::12');
INSERT INTO nodes VALUES(24,'mkey:247cad9ffd7d108f553e7658db14bbad992332458abb9b4bc5a0c0d3a13ead9f','nodekey:bbfb569ac8a34cf4d59d2bc13d0f03660d24aedf22c61b56510a65d20bdf0812','discokey:61f92520602549b9bc684eeed3186f608a38e13794d06d4b8d165c4efbb69a24','laptop-29','node024',12,'cli',NULL,NULL,'2025-01-29 22:13:40.47247515+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5b7b:e424:ea77:aa8a:f835:d6bb:2e1f:52ea]:19152","[bb06:d322:7cec:426b:ef38:55d0:e7ce:95bc]:31597","[320d:6314:eaa2:a098:8594:977d:27b:8442]:12827","163.235.127.125:61230","208.233.231.156:35248"]','2023-12-15 11:14:36.765183054+01:00','2025-01-29 22:13:40.472698887+01:00',NULL,'100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(25,'mkey:232be2297acbce00785cbdff20dad9faf2b2147e15eeab1a5282fd2a48e7fb6a','nodekey:87b7b1f5e238a246897514dc0b57eca6403f8483bed626a9400c6ebc54161544','discokey:d87d208ca22717686d41e21c9adba999965a5cbcd4336b3dc3876b10f58bfaff','web-78','node025',6,'cli',NULL,NULL,'2025-01-30 19:05:56.81412934+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["160.27.109.39:47606","[62f5:b64d:d2e4:9015:b03a:c64e:656:8c59]:5020","3.166.190.93:19852","[243b:de9c:b8c:ea69:b66d:b3ce:14a5:9671]:22747"]','2024-01-05 17:32:40.940566279+01:00','2025-01-30 19:05:56.814546683+01:00',NULL,'100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(26,'mkey:0fe76a3827debaf6af306bc25af56334fa1e02f73245aa70c508bc3e253c84cb','nodekey:0926a8072f34e14c1131b1e3c92402a4b8cf0dca5cd36a6dcf90887ec2890d41','discokey:69cd5153481aad99ea93df0e335d8aa7d8fd36171e49e1c6d11ef5830af2f7c5','email-86','node026',6,'cli',NULL,NULL,'2025-01-30 19:00:06.767381943+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["64.137.67.1:56198","163.42.128.241:47535","49.160.22.202:42427","[1526:e34a:8857:394e:bbe0:c043:4b37:68d4]:5245","32.31.195.128:7039","[c50a:ec:e2e:e109:3a08:f56b:2928:4921]:61265","221.147.144.138:44737","136.208.142.64:41091","[537d:7a83:c891:ac8:9460:e49:e769:988b]:55062","50.23.199.223:4814","[a2b8:ea55:f9e3:2c00:f423:8c56:7fec:c617]:53793"]','2024-01-05 17:34:19.811670479+01:00','2025-01-30 19:00:06.767773381+01:00',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
INSERT INTO nodes VALUES(27,'mkey:95e3d9972a77bda2f7b243091fbd9286ebbc415c108cd984c15b419b82867a59','nodekey:4c7e3c311374ae8f7b4983bfde91b950234915f4fef2da3445702f1d474f21da','discokey:4b5e41432c037af086249f5b0f7552da9cd523ba84092ed303f09e27d294859e','web-93','node027',6,'cli','null',NULL,'2024-01-16 14:32:21.570104175+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e56d:6121:30ef:4870:5bf5:1066:8aa7:dffc]:56225","87.98.228.228:42410","172.81.188.131:23453","[cbf3:dde3:47ec:2c76:49ea:93f1:f43c:d8d4]:39412","[7267:209d:7e:6a59:8e21:b285:91d8:fc9f]:1315","217.68.74.145:28707"]','2024-01-05 17:48:25.466030859+01:00','2024-09-18 16:15:14.040766068+02:00',NULL,'100.64.0.22','fd7a:115c:a1e0::16');
INSERT INTO nodes VALUES(28,'mkey:4a6e46330ccd4b3026337cdef37485c27592babda329107565c2a19d97253dcc','nodekey:17de47da1955a8a034788ae671c34fb10083568bf9e2f7494276cb2636065246','discokey:449f5f35a3507974cf03e3ac5c055d890de5122f57a7c2d84a0d3b324998607e','desktop-17','node028',7,'cli',NULL,NULL,'2025-01-30 17:08:57.494420371+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c2f1:82ab:922a:9b9d:f53d:a0b3:bccd:f6af]:299","[d28b:7b33:1f88:7583:7ed7:a923:4c90:9ee0]:62318","[68e3:a070:f02c:708c:a057:b579:aee9:4d25]:11747","[7224:b76a:cd04:e6d2:67fd:fec0:2f14:1837]:29002"]','2024-01-15 09:34:54.847632697+01:00','2025-01-30 17:08:57.494670314+01:00',NULL,'100.64.0.23','fd7a:115c:a1e0::17');
INSERT INTO nodes VALUES(29,'mkey:6472928030d718e6e2802fb3bceba7c14b4716d994be1b3562a1d03104fd37a9','nodekey:78bd59aba83429486e0ed2d50873211974650b2e2ad8f79dbc07c5d13d00c5a5','discokey:86ead449e1be5a300287e690fb9522ba4da3e5bdeb593d6261e4117708fe3ade','lt-82','node029',7,'cli',NULL,NULL,'2025-01-30 16:03:46.587400142+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[fd0d:f112:f642:c343:ac14:8ede:dc04:e2d9]:58412","[8a1a:5c17:bb81:bb69:c7db:3513:f14c:ca2d]:52077","123.235.220.59:59925","155.210.184.45:60093"]','2024-01-15 15:18:12.2871978+01:00','2025-01-30 16:03:46.587530619+01:00',NULL,'100.64.0.24','fd7a:115c:a1e0::18');
INSERT INTO nodes VALUES(30,'mkey:947247ecfc46c57c6806008c2edac71e9e88b87903b4814f1d4f2b3ae3b4824a','nodekey:d19005205b9e8a43b2727bc1f9bc44acb0ced560304f2aad60b335de457603a9','discokey:882d6a41700c79c95d228db394d4a59244a1c2f39493b658400d95bd162b957a','lt-04','node030',7,'cli','null',NULL,'2024-02-05 12:14:40.065688294+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e868:f68f:cceb:8d29:5451:c716:bdca:437d]:41081","[7016:b48d:8bcf:4ccd:8679:8c47:1c66:cd1e]:41980","22.231.20.85:41616","129.130.98.189:47833","[99c0:d769:2f38:10e9:c01a:e3d:898e:afc]:17505"]','2024-01-15 15:21:43.217136004+01:00','2024-09-18 16:15:14.041757308+02:00',NULL,'100.64.0.25','fd7a:115c:a1e0::19');
INSERT INTO nodes VALUES(31,'mkey:c4853fdd63bed5a98baaf74df437eff743f8a968fda613fdf1f2a111e7c1b100','nodekey:9fc3f32ce92ab7f8ab987f16258b11265037a47cd9a1a68ac0e07bd3c279c183','discokey:e52f22aa8e170b6a031e682b5ed6e5f790f2d6ae1eecb752de1b362a1cce7bd4','web-89','node031',7,'cli','null',NULL,'2024-02-22 08:35:27.098819037+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["133.177.207.78:47765","[d1b1:653:cd17:f39c:8a89:85d0:c7aa:b53]:5279","107.140.203.49:9365","[1660:741a:160:67c9:7972:5f9d:14bd:ee53]:21178"]','2024-01-29 16:05:35.338524634+01:00','2024-09-18 16:15:14.042191514+02:00',NULL,'100.64.0.26','fd7a:115c:a1e0::1a');
INSERT INTO nodes VALUES(32,'mkey:8c468799222af319e17ec309dbbf3a87fb6d924a1cb17e5a0bd7e027fe3bfe5e','nodekey:3c7d82f4a44cfa1469b957ac911e8506a68962fb2583d2afaf3e8a621c0c4aca','discokey:ba179b51f3540e619eaac9a6d4bc67403daa7c3cf28a6b579087cd6d284501b4','lt-53','node032',7,'cli','null',NULL,'2024-04-09 13:59:43.37062537+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d21f:d7bc:f690:e3ba:82fe:8122:c33d:5a86]:227","10.67.113.92:45634"]','2024-01-30 10:41:58.31917869+01:00','2024-09-18 16:15:14.042506082+02:00',NULL,'100.64.0.27','fd7a:115c:a1e0::1b');
INSERT INTO nodes VALUES(33,'mkey:be7f190677fd0cd1c5e78b4ae5b02a1738dd60be7d9a41017000b22ae9636af4','nodekey:a404e578d3edd3e3d879e9f1946c859b5982c59f5e528bf6b987bd55de00b25b','discokey:ad3013f116c370866fc9134b66999bb05e2dc10a8e2944230c3d9893c0a94c67','lt-80','node033',13,'cli',NULL,NULL,'2025-01-27 21:29:56.078640865+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[af8:f5e8:32f0:75ee:d351:c0e9:78e:93d9]:12624","71.151.27.31:51063","[f0d6:21dc:48f5:63f4:daff:a3c4:7d60:51ea]:17286","[38c5:9551:f6ed:b087:91ba:bef1:771c:273d]:62171"]','2024-02-03 16:33:26.706408143+01:00','2025-01-27 21:29:56.079623854+01:00',NULL,'100.64.0.28','fd7a:115c:a1e0::1c');
INSERT INTO nodes VALUES(34,'mkey:7784df3aabe1ca1edab5270028fb3cae8b66cee2384790d06969d1e6e298520f','nodekey:fd8e939fd6db8caf6623ac3d73c12ade4da110d8c1f29e3a3ee0d2be0c526915','discokey:59aff4582e00d92260e6a90d6d0da3d818fe8f52c081c8b65e18006ef8269ebe','lt-65','node034',13,'cli',NULL,NULL,'2025-01-30 19:07:28.343976513+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["71.155.69.236:8707","125.2.67.155:50785","32.6.80.181:17295"]','2024-02-03 16:42:32.683785672+01:00','2025-01-30 19:07:28.344657417+01:00',NULL,'100.64.0.29','fd7a:115c:a1e0::1d');
INSERT INTO nodes VALUES(35,'mkey:ad3838fa63fb120ae8d3e47d4bb6bb4009e7fc5d91483d1ba7417d0681fd7162','nodekey:b10ddbdcf826d79049d74a7d4ad036b499c86f7daf786bb1a9b295366b57afe8','discokey:618ef629d3bd261964c613ad3bc45e6278fa274d734c8cd2d3396cf8c9742d88','web-33','node035',5,'cli',NULL,NULL,'2025-01-26 12:49:34.225736739+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["169.159.71.157:18240","[bbb7:5b4d:218d:55ff:ac9b:1fb6:c933:9a55]:63943","18.156.132.228:63356"]','2024-02-03 16:51:52.010016072+01:00','2025-01-26 12:49:34.238493375+01:00',NULL,'100.64.0.30','fd7a:115c:a1e0::1e');
INSERT INTO nodes VALUES(36,'mkey:c536a3efc460fb2da4c4775e2b51d0c84f001dc46a4d902429e74e97b2d3c6d4','nodekey:91da2acfa3d7f7c7b0c1a2d952ee527514504fddc504809423762203a16145ab','discokey:989ff5f21d485dcb6312fade38c9047bbde1fbce46bc29ac5f6afe00610ad215','laptop-46','node036',13,'cli','null',NULL,'2025-01-19 14:01:48.956567669+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4017:a243:61d0:b302:7860:18f:7d4d:f605]:28633","[e5b8:6c78:ce2f:cf6f:13fb:401f:8223:3f04]:54121","38.137.88.247:35801","[eec2:61c0:e20a:2fa0:5e4d:56a4:5071:881b]:36628","[b8c2:c792:3329:2c93:f94b:a948:7d11:b9f2]:908","[5925:353c:bd9a:f42e:1916:45b4:c170:e515]:18400","[c2a5:cc2f:e2e8:573f:7b01:4aa:8a1a:fd71]:32146"]','2024-02-09 12:34:57.879970954+01:00','2025-01-19 14:01:48.956830267+01:00',NULL,'100.64.0.31','fd7a:115c:a1e0::1f');
INSERT INTO nodes VALUES(37,'mkey:142e67963c9045164df7b33af6d2149d72f59527df44fd75221647281444cbe7','nodekey:a3a2cd2bd0c3a1f783d0391ea1951c5c9226ddca0f18130b77fccff8b874d694','discokey:bdb788f8825b9bd816f37dcea882920382c7feb143edf0a6baefc9015774d8aa','lt-24','node037',5,'cli',NULL,NULL,'2025-01-30 18:52:12.369500276+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c31d:dd18:321:589:11fa:d85b:695f:1fca]:43064","168.4.78.117:48474","90.45.218.0:29326","90.233.46.138:29846","8.137.133.59:22781","[cb5c:f8d4:ccb0:8333:8ec:170c:a2b0:941d]:26248","[5802:df5c:8853:4851:6dcf:cb83:8208:d143]:24568","48.38.104.41:43702","139.100.200.227:62546"]','2024-02-27 12:14:40.452601042+01:00','2025-01-30 18:52:12.369790328+01:00',NULL,'100.64.0.32','fd7a:115c:a1e0::20');
INSERT INTO nodes VALUES(38,'mkey:6829f2d5523aba7a27c31e59e2341f3feb5a5a72a0268ef10d23c39811ea3b53','nodekey:10e4ff66fdd37fb54f6dcb0e42f483a15b6340610acc3a4517c24f0f350b5a9a','discokey:f20786f9c7edc967d0b415bbcce39468441af3b531ff15656c0683d3f328720a','lt-88','node038',6,'cli',NULL,NULL,'2025-01-30 16:09:13.024420431+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a393:f17f:6728:82e4:c1e7:2367:82d0:daaf]:18560","[d192:9897:4cd7:bfb5:de36:fc03:8cf4:c60d]:25096","212.199.67.213:11150"]','2024-05-22 08:08:16.045350656+02:00','2025-01-30 16:09:13.20760575+01:00',NULL,'100.64.0.33','fd7a:115c:a1e0::21');
INSERT INTO nodes VALUES(42,'mkey:33e764ae40265089c5e7dbfc8571aa23bb390fc7e1e8bd2f3e0cd6891c308214','nodekey:c444c9ff652ba29181a5f7fdf991f91f704e6698237ee18b0649c81879ec932f','discokey:2e1db3a1eea266673acf7826aa44b5aa6fdd23c6ba41330562b37c5a523ba358','laptop-81','node042',14,'cli',NULL,NULL,'2025-01-29 16:46:30.352621883+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["190.179.215.222:61930","45.131.187.230:22916","[510f:af99:ed4d:f53a:fc21:8640:9ad9:4930]:16050"]','2024-07-03 11:12:29.418355657+02:00','2025-01-29 16:46:30.353292973+01:00',NULL,'100.64.0.37','fd7a:115c:a1e0::25');
INSERT INTO nodes VALUES(43,'mkey:353844c4b332bdbf7f39796c522ee89d7f64fde342d3e566878f456df0d57a54','nodekey:c9f47cb50fd2b9075cda9d68018659491ac29dbbe7a04e8405039fd385966fa7','discokey:ec43638237bc43ab6a9839b3a4d54c2593e11a2ebd13bd491f08f68d7cf93ac0','desktop-90','node043',14,'cli',NULL,NULL,'2025-01-29 16:39:14.757499741+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e071:3cd7:878c:ae2d:7dcf:eab0:d0d1:decf]:37427","17.31.200.70:26794","[183d:f2d6:b80:36c5:318e:64e9:7f4a:b389]:12440","169.173.198.12:15274","[e5df:1889:6ac5:7d21:4dfd:614b:7eb9:d93c]:792"]','2024-07-03 14:48:50.263910778+02:00','2025-01-29 16:39:14.757996869+01:00',NULL,'100.64.0.34','fd7a:115c:a1e0::22');
INSERT INTO nodes VALUES(44,'mkey:6d3e50168ff6e672ed7650abc5a1de7fec7150c6f84932c705c84964824d1d39','nodekey:ad70f51f99efeefdf0c8e0a9e818db1e5de474e67b2b0a1609a53190339938ef','discokey:c4d4ad19814f9312b454cadb85b333f80cccca1b4a42f30780f7a0f4ccfe1bff','laptop-97','node044',14,'cli',NULL,NULL,'2025-01-29 16:27:57.81216036+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b501:efaa:c73b:b492:c3cf:865:d55b:9557]:26172","162.210.141.106:52036","[84ef:a164:d1c:d20d:797c:753e:f8fb:3108]:5767","[c15a:e322:a721:c9a7:a662:ccb8:26b8:e1c4]:63192","[87c4:c36b:d96f:525b:fa4c:c5f6:7bc8:d6bb]:35894"]','2024-07-03 15:23:48.066044194+02:00','2025-01-29 16:27:57.81269748+01:00',NULL,'100.64.0.35','fd7a:115c:a1e0::23');
INSERT INTO nodes VALUES(45,'mkey:e1772e6b138211afff6aa8fee08438c311b1d9d32576075c980d39591b13ae77','nodekey:92b8cc28bff0c53f95fbdd8c1363040100ae849e78aea04a3755e9a1fd03fe4e','discokey:7b368b5d64b6e4fb4f0ba9e5809bee8b769949ecdc69ec6ee6c9f12c2321fced','email-94','node045',14,'cli',NULL,NULL,'2025-01-29 16:48:59.640158179+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[caa0:946e:b130:39aa:31b0:8f9:7526:4960]:1729","120.102.247.255:41936","28.177.95.32:7841","[fb23:5998:c63d:b6c4:e86a:96b2:61c:e110]:51902","[89d4:f6c6:ccf6:b19d:3b76:642e:7a36:d229]:930"]','2024-07-03 15:54:01.706018896+02:00','2025-01-29 16:48:59.64070889+01:00',NULL,'100.64.0.36','fd7a:115c:a1e0::24');
INSERT INTO nodes VALUES(46,'mkey:af6c1d228b675ff04d2584e2c23d6288ec312a6b44c5c0eed213423a11711787','nodekey:f5b21f25bb22b5cf0cedb1b643d50c3a6512ef300cc971eccccbcc500cc23408','discokey:72843a1b2564c177d8556eb0d76dda7cbe0d9f1408bd250fcc6149518eb6d5c0','desktop-41','node046',14,'cli',NULL,NULL,'2025-01-26 18:40:46.403363149+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[37a8:9998:e94e:e297:940e:5414:5549:87c7]:37130","27.138.122.133:37304","98.38.29.194:12660"]','2024-07-03 19:38:07.783745318+02:00','2025-01-26 18:40:46.403759275+01:00',NULL,'100.64.0.38','fd7a:115c:a1e0::26');
INSERT INTO nodes VALUES(47,'mkey:5bbb77092f21b4835b0ae1af3871fc48445819c9b6e5ff9c46ad4a623b662ae8','nodekey:191c7cc089ee160c07b63e2b6b5ef0701d76d914009420baddad9bfce13e3f2d','discokey:712cadffd23f106abeea82ae70bbae8e06c2a58f3db617afd0d149b3012c64fb','web-61','node047',14,'cli',NULL,NULL,'2025-01-28 14:54:17.570894466+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["186.118.23.242:32373","[5bd8:a5a8:1b3:5e41:3c4d:5fc:4c0:c6cc]:24847"]','2024-07-04 10:38:08.344092869+02:00','2025-01-28 14:54:17.571166771+01:00',NULL,'100.64.0.39','fd7a:115c:a1e0::27');
INSERT INTO nodes VALUES(48,'mkey:a1e793aa09c20360cb4ef57e7dc42171a0abbc9f562140609e930ba5b7b12e83','nodekey:3343520915898c9d90b7517eabf8660d66c37ed12aea0b5a4935458f95c801c9','discokey:6a80e23d10d2cb3edb58c9c47ee997f9063d6aed2f29049f635b6bf1da090885','web-24','node048',15,'cli','null',NULL,'2024-10-20 13:53:33.831192385+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["101.103.129.11:50383","[3aab:52a2:b9d3:1816:5627:336:6c60:57d7]:13486","22.83.180.41:14147","26.126.135.206:7777","[8706:d109:5006:f832:dca7:58e4:4451:be15]:15180","177.4.27.29:60895"]','2024-07-26 08:09:56.608302315+02:00','2024-10-20 13:53:33.831387627+02:00',NULL,'100.64.0.40','fd7a:115c:a1e0::28');
INSERT INTO nodes VALUES(49,'mkey:13b8d4cafbdb8e9ab77928219aa57bf778878866ad8e6108b60aaab8dc8cec36','nodekey:17cefd68f8a9cc20b3d4fd93598f77ddfd6bd5a7e6e4b49861f9faad8623e0ef','discokey:939a04ddd2f9a24468e07ee7924dbb7a7662c1e8a1b67426f57fd48c7394448b','desktop-40','node049',16,'cli','null',NULL,'2024-09-19 09:07:18.28136023+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[19b0:8be2:708:d27f:4d3d:3c93:9979:e9e8]:50438","129.0.5.112:19015","[91e2:54c6:93fb:ec32:6ab4:186d:81cb:b815]:37323"]','2024-08-05 17:32:41.937626584+02:00','2024-09-19 09:07:18.281618912+02:00',NULL,'100.64.0.41','fd7a:115c:a1e0::29');
INSERT INTO nodes VALUES(50,'mkey:03979d5446bb3f596bf0234d81ca84482eacb132e874ceda6cc2703422cd728c','nodekey:805c03cada525f14ee90d28ea02b23a3f57b470c793314872ad9daacf6c6484e','discokey:eb4135e1cc73a3c6b513d8cc04ca0c55a2aef7b0009845fa1d2036488aadf0f8','desktop-02','node050',10,'cli','null',NULL,'2024-08-07 10:10:06.595550455+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9175:498d:64ac:4342:2eac:ffa1:99fd:d109]:21202","[5cba:56ef:db08:320c:333a:541f:605c:44d5]:57469","150.211.2.236:50360","203.180.122.83:13344","63.162.234.32:11653","[6b63:f552:f930:e22c:fc42:3b41:c5c6:6d5f]:63162","114.48.12.185:47837","[2964:cc5d:3a1b:7889:acc8:4d8:22c1:398a]:43515"]','2024-08-07 11:50:54.144157179+02:00','2024-09-18 16:15:14.050033969+02:00',NULL,'100.64.0.42','fd7a:115c:a1e0::2a');
INSERT INTO nodes VALUES(51,'mkey:5877139c52c0bf3c0fd054bd046aaf4530dd8946548a7bc1a06733649d1557d8','nodekey:553d9638c8c455e8d1bc811ea3af03db1eb3c586413447c8003e7d905a61d06c','discokey:1da883c9eff402d786362aaac2f478c835308b3acec0993e6293becf4474609f','web-62','node051',14,'cli',NULL,NULL,'2025-01-26 12:49:36.351868783+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["86.215.174.228:26026","93.101.159.155:64005"]','2024-08-07 14:19:31.156780417+02:00','2025-01-26 12:49:36.353124877+01:00',NULL,'100.64.0.43','fd7a:115c:a1e0::2b');
INSERT INTO nodes VALUES(52,'mkey:0e64072dafa5f9e49266b41fc4b21ff7d287be8f4e5f2b6c395487d632f1cf3f','nodekey:2f77bb8cbeb426bcded5ad9fc6da44b0b76b8d6759f10a8db28e634290760ee7','discokey:836558738056edd1fa8d190c7e42f120b365a48a3b1f1c96c87755bb82d7ad0f','desktop-07','node052',17,'cli','null',NULL,'2024-12-25 17:27:58.515851096+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d889:f751:710:257f:977f:5597:9908:14e0]:61162","[f83a:5ebb:911d:ef36:743c:8086:8a4c:a5c7]:23538","[dc45:365c:e426:71d7:fe23:fdd4:d2c2:9409]:57262"]','2024-09-22 15:48:41.385301399+02:00','2024-12-25 17:27:58.517153789+01:00',NULL,'100.64.0.45','fd7a:115c:a1e0::2d');
INSERT INTO nodes VALUES(53,'mkey:a6f93e99a5019b3b6a2941d95dc7fcbfea5a59317a48b99db93b7a3f4f0a65bb','nodekey:1f78a6d76ea4a2135c0da46b202560c86ed30cd7e8239d4508088d0e02ffb961','discokey:1744062452f052aba5320e37fc08aaa37f1430db7c32c94c5626f0f3c858de3d','desktop-82','node053',17,'cli',NULL,NULL,'2025-01-30 18:44:17.370143702+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6084:ee60:1697:864e:4a61:cf6e:e9b6:4c05]:63961","[fad7:2601:d286:4772:3cce:6e89:f66e:9eeb]:5430","216.60.124.11:45041","[d513:c472:d7a:f316:f610:10d0:9851:4feb]:3955","156.228.105.157:61542","102.126.185.0:50694","[156b:e934:d171:2693:8db4:f193:a58c:17b6]:24190","79.255.179.99:56057","[6369:4412:8cfc:2a5e:7cfb:8b45:e2ac:f98a]:16090","23.0.29.75:24889","[ab0:1193:7bb7:4a4a:c036:b911:994f:3aa4]:5116","[9491:7bd5:3979:414a:d198:a8b:f2e7:29b4]:62795","140.73.225.124:1710"]','2024-10-28 10:04:50.084492941+01:00','2025-01-30 18:44:17.370913494+01:00',NULL,'100.64.0.44','fd7a:115c:a1e0::2c');
INSERT INTO nodes VALUES(54,'mkey:e47e8ca8e89ebf89a399a8206916ac7a55f855b449acf80c7d27b6b225aac678','nodekey:377793cdc9eb6f2279806b2b70d0fea24c4f4c1dfdf92771eecd9199f67d80e9','discokey:299a45d53358f6a43234df87ceff28e642433aa06e8341862e8557d1d499ddae','email-83','node054',14,'cli',NULL,NULL,'2025-01-30 10:34:07.584992479+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[7d2a:9d5:1fbb:54a7:fe7a:bc40:5ea2:ca20]:3534","[f630:8bb5:a4ff:95b1:6d95:decb:a5d2:373b]:42456"]','2024-12-09 17:10:55.363593066+01:00','2025-01-30 10:34:07.58575113+01:00',NULL,'100.64.0.46','fd7a:115c:a1e0::2e');
INSERT INTO nodes VALUES(55,'mkey:c0b2d0e2ff266bfc53e07b246f000847c7d0c86649152c2bc6a421443627c733','nodekey:105f9b052032e510f9ab817af7df0ea561dc304223ceaf75c9116ce487bbfe86','discokey:cfb384a16ce161420b9bd42615dfa45ca547084bf61f3728ccf342d8693a9383','lt-74','node055',18,'cli',NULL,NULL,'2025-01-30 13:48:04.74697862+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["155.233.51.24:54409","191.94.7.112:26528","[1f30:3a9a:19b:da4e:a3d7:9a55:707b:d112]:54974"]','2024-12-10 13:56:39.287449662+01:00','2025-01-30 13:48:04.74733257+01:00',NULL,'100.64.0.47','fd7a:115c:a1e0::2f');
INSERT INTO nodes VALUES(56,'mkey:5b28e1fc6b67cf4a900aeed7c413f06b83e8e9de3f5fada3cefac31ef51ac932','nodekey:8f015f994d88c5348b98c2cf40f9f224f85787941044438f4a9ee34cabbb5d4f','discokey:5b44ab87d7620b22294cae6536c69b272e9ca9ade6812bf4f41375fcb44ace7c','lt-86','node056',19,'cli',NULL,NULL,'2025-01-30 19:03:58.987501999+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["44.230.54.249:64083","29.229.203.183:13"]','2024-12-17 14:58:39.429211911+01:00','2025-01-30 19:03:58.987864718+01:00',NULL,'100.64.0.48','fd7a:115c:a1e0::30');
INSERT INTO nodes VALUES(57,'mkey:200d4ac92d1084e22e9cdcd0a74ac2a12e33a279dd2bd9aa88a779c92c82bf35','nodekey:48c2e3c2c51da5ce63d764bb3698482e96746c543f2c728235ea8afe971202b2','discokey:2b3dec80b092c04bb25c9c39bf18e7f85d38dc666de1fff2dd7a6dd95e6af162','desktop-62','node057',20,'cli',NULL,NULL,'2025-01-28 11:01:52.058651587+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["178.193.134.41:58563","29.219.180.224:55412","[2ddd:7c1b:a237:41c8:3baf:e9cc:1f31:9057]:62916","[9c34:190d:7bf0:c940:18d6:f96c:9aca:8c0a]:8787","181.226.177.82:63703"]','2024-12-17 15:17:14.26936913+01:00','2025-01-28 11:01:52.058860063+01:00',NULL,'100.64.0.49','fd7a:115c:a1e0::31');
INSERT INTO nodes VALUES(58,'mkey:4d690637aa5cdd6575d9dbb7fa0b55c83bece3e82bc689e73122c9120f871772','nodekey:8733914d48b0c34a0111ec5f633123ae4ec7de39e597077d659ab8f2354270b9','discokey:ff25bf692a69cc0e79101e1cc1b926ca97b6e3897e65c55e5bd3f09ca1ea6d16','lt-20','node058',12,'cli',NULL,NULL,'2025-01-25 18:41:03.881898904+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[57a6:fde1:814:36cd:f8de:668c:f5fb:4f60]:39714","[f08d:aeaa:107:fc17:5c30:ab9a:e31e:3147]:55879","80.27.167.78:21548"]','2025-01-17 10:17:23.455895657+01:00','2025-01-25 18:41:03.882180987+01:00',NULL,'100.64.0.50','fd7a:115c:a1e0::32');
INSERT INTO nodes VALUES(59,'mkey:581824fee9a91fdacfd3529d7e28548440259284e3f3251d00981c34ff1817a4','nodekey:ef7f1fd978b01f30758074df76c5eab42279ba200d7e3386fd6545e2d2865463','discokey:1e77e9eb061b34dd246f44cf32bf818b431948fed86d4dd02de112845caad4e3','srv-53','node059',21,'cli',NULL,NULL,'2025-01-30 18:54:11.030475733+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2e30:4d2d:4925:201f:e845:2a12:503c:9524]:34552","105.198.43.87:48215","214.199.117.40:30901","58.251.220.64:42364"]','2025-01-29 11:59:27.291048957+01:00','2025-01-30 18:54:11.030888364+01:00',NULL,'100.64.0.54','fd7a:115c:a1e0::36');
INSERT INTO nodes VALUES(60,'mkey:1fde1d60f3aacf01ce0d5faa329ebe3da2465dfc4a568e31648b06b313a690d4','nodekey:e1038e05b45f270e2d47d90898a9f599253421e9046a799d394b623766a81aae','discokey:d5e3dddd1a9422458643058ed2d8fd8e9da0cf3b4378cf4b421672cf1e13d71d','desktop-08','node060',21,'cli',NULL,NULL,'2025-01-30 19:04:25.435259221+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["15.226.94.222:41465","109.183.111.101:20875","[912a:9b6c:5845:f8d4:f476:491f:cdef:8b7d]:21677","22.203.32.217:28664"]','2025-01-29 12:01:57.48748166+01:00','2025-01-30 19:04:25.4358129+01:00',NULL,'100.64.0.55','fd7a:115c:a1e0::37');
INSERT INTO nodes VALUES(61,'mkey:17196701e0a4b870bae52dd1fc0eeb26843f2ceb0745ad263e69ef737d9a5403','nodekey:a8c47bf5faf5110c298862a919bc7308eb616c92c110f7dfd38194a74b3ffe7a','discokey:4dcc87f0698a1e669485874eaacf9438090ac69deb20fb9cc693d7df75b8265f','web-53','node061',21,'cli',NULL,NULL,'2025-01-29 23:58:55.106877823+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[1ad1:4e50:7001:e922:d6b0:2b1e:c718:f3f7]:31291","13.175.9.68:14464","[e9e:965b:7b7a:3219:44cc:f0f3:e3a0:a504]:34840","[2476:14e8:ab74:a221:cfca:bd5e:64aa:83d1]:48008"]','2025-01-29 12:03:01.464646336+01:00','2025-01-29 23:58:55.107564914+01:00',NULL,'100.64.0.56','fd7a:115c:a1e0::38');
INSERT INTO nodes VALUES(62,'mkey:e8ecee3b3c1e75bea1ee3d00a759ab31864c33f6c8df4a15c352d1b420450d88','nodekey:820bacc3e7d49bb90be56bb3297c98aed4c777bc1aed02b3b0b7b4301c8e445f','discokey:d16e93e7d7b6fbc451ec3576211f7c19398ca18f684fa285f5d6bd84be50286c','laptop-57','node062',21,'cli',NULL,NULL,'2025-01-30 17:23:37.246636502+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["69.125.5.213:11546","[68bb:e8d1:72d8:8b02:608b:2284:c9b3:184d]:20876"]','2025-01-29 19:23:14.092804852+01:00','2025-01-30 17:23:37.246792226+01:00',NULL,'100.64.0.57','fd7a:115c:a1e0::39');
INSERT INTO nodes VALUES(63,'mkey:3e0dcb286f6e19b1e3a0b5330978aa8a8d710934cc754e811d0f690046e04469','nodekey:cd2d301b9b163b806fe8d63cdd07004f26559706bf7dc782645f05e12ebe0ec3','discokey:14675666cf2b55697f0032897d1c6742413d7c24bada8cfdc6246bf150d06fc7','db-76','node063',21,'cli',NULL,NULL,'2025-01-30 19:07:01.231463482+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["74.32.222.198:59615","145.91.193.5:37126","[2fb6:ea0a:3639:a1cd:9075:a258:6a79:4f5c]:13944"]','2025-01-29 19:41:40.535299057+01:00','2025-01-30 19:07:01.23207245+01:00',NULL,'100.64.0.58','fd7a:115c:a1e0::3a');
INSERT INTO nodes VALUES(64,'mkey:1adfdd6ba590feffc711c40506ed5ecb16609cd6e90a536d50c5f54cec223508','nodekey:0d58cee32d99cde76b3d8769ae4605cb4bfc9cbb01fc13069c8b59faca320e48','discokey:cba00753c508df0b5cdea1e59eaa829c6cfda4f8399121307f931dbaa3730296','desktop-90','node064',21,'cli',NULL,NULL,'2025-01-30 19:04:27.551570027+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["172.210.49.58:58821","[23f9:9c6d:5069:a14f:33d2:c0b1:5ab5:f83b]:46288","[b341:3259:c5dd:9f91:fd70:c616:3033:2b3b]:59081"]','2025-01-30 18:18:57.519126133+01:00','2025-01-30 19:04:27.552291406+01:00',NULL,'100.64.0.59','fd7a:115c:a1e0::3b');
INSERT INTO nodes VALUES(65,'mkey:547a8b97c8c8227d9ba40174ce4d28d0e64f10fae3f39797c60e29742ed59e62','nodekey:cb4a9d1dee6f581036b7c262348cf2c4a96be8b2eea78f7805097e3f7b1a9fcf','discokey:c233a42a4afb5fbf921bf7b3fb4330e6c46273d18570aaf6b7254dbf3c67614f','desktop-82','node065',21,'cli',NULL,NULL,'2025-01-30 19:01:43.552616838+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["21.197.131.68:13997","6.193.99.72:20874","181.248.237.50:21695"]','2025-01-30 18:19:40.354692307+01:00','2025-01-30 19:01:43.553264821+01:00',NULL,'100.64.0.60','fd7a:115c:a1e0::3c');
CREATE TABLE `policies` (`id` integer PRIMARY KEY AUTOINCREMENT,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`data` text);
CREATE TABLE IF NOT EXISTS "users" (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`name` text UNIQUE,`display_name` text,`email` text,`provider_identifier` text,`provider` text,`profile_pic_url` text,PRIMARY KEY (`id`));
INSERT INTO users VALUES(1,'2023-05-17 19:36:55.859473496+02:00','2023-05-17 19:36:55.859473496+02:00',NULL,'user001','','',NULL,NULL,'');
INSERT INTO users VALUES(2,'2023-05-17 19:36:57.059073465+02:00','2023-05-17 19:36:57.059073465+02:00',NULL,'user002','','',NULL,NULL,'');
INSERT INTO users VALUES(3,'2023-05-18 10:10:36.248939077+02:00','2023-05-18 10:10:36.248939077+02:00',NULL,'user003','','',NULL,NULL,'');
INSERT INTO users VALUES(4,'2023-06-10 09:06:13.920718561+02:00','2023-06-10 09:06:13.920718561+02:00',NULL,'user004','','',NULL,NULL,'');
INSERT INTO users VALUES(5,'2023-06-11 19:58:32.371218434+02:00','2023-06-11 19:58:32.371218434+02:00',NULL,'user005','','',NULL,NULL,'');
INSERT INTO users VALUES(6,'2023-06-17 19:39:53.031565686+02:00','2023-06-17 19:39:53.031565686+02:00',NULL,'user006','','',NULL,NULL,'');
INSERT INTO users VALUES(7,'2023-06-20 11:35:09.325846831+02:00','2023-06-20 11:35:09.325846831+02:00',NULL,'user007','','',NULL,NULL,'');
INSERT INTO users VALUES(8,'2023-06-21 22:47:48.196234382+02:00','2023-06-21 22:47:48.196234382+02:00',NULL,'user008','','',NULL,NULL,'');
INSERT INTO users VALUES(9,'2023-06-22 08:30:35.068995572+02:00','2023-06-22 08:30:35.068995572+02:00',NULL,'user009','','',NULL,NULL,'');
INSERT INTO users VALUES(10,'2023-07-03 10:18:32.123226+02:00','2023-07-03 10:18:32.123226+02:00',NULL,'user010','','',NULL,NULL,'');
INSERT INTO users VALUES(11,'2023-07-03 10:18:37.130387602+02:00','2023-07-03 10:18:37.130387602+02:00',NULL,'user011','','',NULL,NULL,'');
INSERT INTO users VALUES(12,'2023-12-15 08:05:06.013615212+01:00','2023-12-15 08:05:06.013615212+01:00',NULL,'user012','','',NULL,NULL,'');
INSERT INTO users VALUES(13,'2024-02-03 16:32:42.224977233+01:00','2024-02-03 16:32:42.224977233+01:00',NULL,'user013','','',NULL,NULL,'');
INSERT INTO users VALUES(14,'2024-05-03 10:12:38.220973042+02:00','2024-05-03 10:12:38.220973042+02:00',NULL,'user014','','',NULL,NULL,'');
INSERT INTO users VALUES(15,'2024-07-26 08:08:40.979783263+02:00','2024-07-26 08:08:40.979783263+02:00',NULL,'user015','','',NULL,NULL,'');
INSERT INTO users VALUES(16,'2024-08-05 17:32:02.878091894+02:00','2024-08-05 17:32:02.878091894+02:00',NULL,'user016','','',NULL,NULL,'');
INSERT INTO users VALUES(17,'2024-09-22 15:48:00.287392203+02:00','2024-09-22 15:48:00.287392203+02:00',NULL,'user017','','',NULL,NULL,'');
INSERT INTO users VALUES(18,'2024-12-10 13:55:11.256977421+01:00','2024-12-10 13:55:11.256977421+01:00',NULL,'user018','','',NULL,NULL,'');
INSERT INTO users VALUES(19,'2024-12-17 14:57:58.550971236+01:00','2024-12-17 14:57:58.550971236+01:00',NULL,'user019','','',NULL,NULL,'');
INSERT INTO users VALUES(20,'2024-12-17 15:02:08.053169491+01:00','2024-12-17 15:02:08.053169491+01:00',NULL,'user020','','',NULL,NULL,'');
INSERT INTO users VALUES(21,'2025-01-28 15:57:32.774456057+01:00','2025-01-28 15:57:32.774456057+01:00',NULL,'user021','','',NULL,'','');
CREATE TABLE IF NOT EXISTS "routes" (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`node_id` integer NOT NULL,`prefix` text,`advertised` numeric,`enabled` numeric,`is_primary` numeric,PRIMARY KEY (`id`),CONSTRAINT `fk_nodes_routes` FOREIGN KEY (`node_id`) REFERENCES `nodes`(`id`) ON DELETE CASCADE);
INSERT INTO routes VALUES(1,'2023-05-19 07:09:23.387641743+02:00','2023-05-22 09:48:18.908103256+02:00',NULL,3,'192.168.224.0/21',1,0,0);
CREATE UNIQUE INDEX `idx_api_keys_prefix` ON `api_keys`(`prefix`);
CREATE INDEX `idx_policies_deleted_at` ON `policies`(`deleted_at`);
CREATE INDEX `idx_users_deleted_at` ON `users`(`deleted_at`);
CREATE INDEX `idx_routes_deleted_at` ON `routes`(`deleted_at`);
COMMIT;
Reference in New Issue View Git Blame Copy Permalink