TheArchive/headscale
1
0
Fork 0
mirror of https://github.com/juanfont/headscale.git synced 2025-08-11 19:17:34 +00:00
Code Issues Packages Projects Releases Wiki Activity
Files
main
headscale/hscontrol/db/testdata/sqlite/from_nblock_db02__0.22.1__0.25.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

137 lines
57 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');
INSERT INTO migrations VALUES('202501311657');
INSERT INTO migrations VALUES('202502070949');
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-04-01 16:27:58.397462433+02: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"]','2023-05-17 19:38:13.531518257+02:00','2025-04-01 16:27:58.397628099+02:00',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(2,'mkey:fa994293c516f7166a803edf260ec091b1638547f4ba78aaf0625a4d0cace0a5','nodekey:5b5bb489a68285591c97034325637a7767cea0051fcf19934dc694331137f459','discokey:1743557d49de33b01698e6eea7c6ce383010f3c6b20a56c39defdaccee9c5873','lt-98','node002',1,'cli',NULL,NULL,'2025-04-05 07:56:58.676183973+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["149.96.226.131:35537","84.23.188.83: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"]','2023-05-18 10:09:21.757289398+02:00','2025-04-05 07:56:58.749180421+02:00',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(3,'mkey:e44e45bd1656b97e8b328dc927ccab6cbce6c869992f70fb9c6031b980a1bf2b','nodekey:1497e461383f07b4f7cd7c76036b6fcabf23f46ac9f3651e22fd1f67eee22804','discokey:d84cef5408f6a40a7d789abbfdabd99edcd794e066894632f3cbb20d0e90a100','lt-24','node003',3,'authkey','[]',1,'2025-03-31 18:38:46.659409582+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["219.238.10.240:64443","[5e3d:ce1d:284e:9f89:155c:bff2:a65:d667]:51808"]','2023-05-19 07:09:21.399903526+02:00','2025-03-31 18:38:48.354115247+02:00',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:a2be538ff79403d577686c0ff675e1ec1b0da10902211d25ccf8adb58deaa6be','nodekey:69977d7f034a8ca09f0f08dc2d6410eb2b6f5fd343b6c88124ec37d6bcddb4d9','discokey:2a3fadbffba90bd0d74d432626a92d1ce1cf0297d4ad51cfd2011c4de7e198fa','db-36','node004',4,'cli',NULL,NULL,'2025-04-05 07:55:13.242501536+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8a81:30b8:5d50:73d7:9039:f2ce:c1be:a099]:43373","76.78.238.163:55069"]','2023-06-10 09:31:51.940506933+02:00','2025-04-05 07:55:13.243195188+02:00',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(5,'mkey:d1533206380a3d91fe09ba9aca808b8caada2cb469e9065acdebab13f22a215f','nodekey:961c8e15bdb7e261c0d359f72256c218447c9c007032f102a418d07b0b829b1b','discokey:d6e4dec2b26039771350ddf132dadf1a5d8615608bd99461d267271e7b53269c','srv-09','node005',4,'cli',NULL,NULL,'2025-04-05 07:57:42.002738555+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b12e:af88:3c55:41f8:5fba:2aa3:3248:15c1]:23643","186.84.191.82:2621","[c9d0:4e15:513a:171b:9911:f9a0:cccf:cd83]:24151","66.84.158.199:63451","47.94.115.240:6677"]','2023-06-11 13:56:42.694329408+02:00','2025-04-05 07:57:42.003378098+02:00',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(6,'mkey:4cf09b5d948c6492d0706b7972a9f46f03261dc73244cbd098653461c1426dab','nodekey:dd207345a8cdda46d50803658ab26c0fc7f28283217c6aa616a945885e92fca3','discokey:a0e6dfe46d6380aa0d131816dc0ea3287aad89196690b9bd91224f904816aa06','email-01','node006',4,'cli',NULL,NULL,'2025-04-05 07:56:59.056128983+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f739:43a6:4363:817e:34d9:3cc:1272:dba1]:26597","220.204.45.94:59135","187.96.173.136:34092","[fece:76ed:4c23:1e89:f225:97a1:94be:b5c4]:33472","[e1e6:a14:535a:668b:698:f125:543f:b5b7]:31740"]','2023-06-11 13:57:44.975695604+02:00','2025-04-05 07:56:59.0920878+02:00',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(7,'mkey:5bbbd75488079eda04771e44ddf21c5866640024a947e66cfd3c3bafb19d3e11','nodekey:022306df92cac976efdd1dd5d4454d0e20eb46ac6f7b847dbcc382a399d1c97e','discokey:4980d19a6814405d26c40dee31a93a5f43e18b41f6f6f4908ee59066e04f8179','lt-67','node007',4,'cli',NULL,NULL,'2025-04-05 07:57:44.198576857+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8ddd:4aae:2b94:4c1a:d05f:65d2:2bdb:b400]:42839","[c493:a941:58b6:7634:6221:70ba:20e6:40c4]:35486","[9b54:61a6:c678:edac:956f:741e:5e2c:9ec9]:17930","[cd3f:af1c:fcb4:bcb3:806e:adf4:3f3f:ab36]:58513","[7a83:6a84:9f15:ba1a:9671:3d54:2e31:d5e9]:64893","167.223.65.194:6907"]','2023-06-11 14:16:56.951313537+02:00','2025-04-05 07:57:44.198934821+02:00',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(8,'mkey:1abadbff7c8bdbe7a3104396c70068fa0a7aa30e405ef7d088738a8510877b39','nodekey:1251afbe69b3212ef1137c4bf2ef842409b8440d9ce32470ce4e8fb245480ccb','discokey:4a7b4155015d4cc2418ccb4005d3408b610c37b9f7bffdc625e2823f3e44514b','srv-71','node008',5,'cli',NULL,NULL,'2025-04-05 07:57:27.984224703+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["107.117.104.69:47662","[adea:86d3:b312:f445:d835:6023:f1f:f928]:27483","124.104.237.237:47957"]','2023-06-11 19:59:30.401970393+02:00','2025-04-05 07:57:27.985100444+02:00',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(9,'mkey:9ced3abf3a281d71b6f361a75769c571c4aff9e4cbab5b317f6cf18918f66bbc','nodekey:e533ead6c5b810764db07631d7b9b14434bf66549837d33a6187daac1ab1d7a9','discokey:571a7ba01a8a0fff2af21d0f135caf8ae2ee0e15fd5ab996d2e490cf968d7217','email-22','node009',6,'cli',NULL,NULL,'2025-03-31 18:38:47.329086514+02: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"]','2023-06-17 19:40:45.468789461+02:00','2025-03-31 18:38:48.935281615+02:00',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(10,'mkey:6cb022f8457bd430cd8ca6e88f1d4e3678965fd0af659ef29c956fbaa81c870c','nodekey:b4dc05758407f598a2cb77f98d5c4fca9dc3820e31976887942b54a4d44e43bf','discokey:fb9dba09bf8b64d2ef3b35d917d41d5208aafb2b013a53da0d2196a152a3cf9f','desktop-07','node010',6,'cli',NULL,NULL,'2025-04-05 06:30:41.564651006+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["2.116.83.236:33635","41.172.94.101:32111","223.204.123.230:38090","[9394:b33d:67e:fde5:21f8:77e8:97a8:bbb7]:47884","14.155.207.231:4806"]','2023-06-20 11:18:35.905417341+02:00','2025-04-05 06:30:41.565251484+02:00',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(11,'mkey:e76a4d43284c0d19fbcf84b38d4bbdc5f978f8922f2ef6dcbe15170a3860a7d8','nodekey:85652faac3a65cb620073e7402506930daa194a7a3555c335741ee65a920530b','discokey:3a6aac7afdc916c9bc84b77b90c521c0e08f3fbf06ce89cfb2281271ec070b1a','lt-86','node011',7,'cli',NULL,NULL,'2025-04-04 21:59:20.16340839+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["22.207.212.228:27547","[2c3e:2260:8c34:275:2287:b721:1bdb:d462]:59540","70.115.64.117:6906","147.25.71.84:48460"]','2023-06-20 11:35:15.063855316+02:00','2025-04-04 21:59:20.295244825+02:00',NULL,'100.64.0.11','fd7a:115c:a1e0::b');
INSERT INTO nodes VALUES(12,'mkey:6dacfe30ad1cab87eb1ef96c1d574cdb59d71aa0695483c7f17aef6b26f446b3','nodekey:b1f007ca3a9d6637fa1388c71397a537d4cc3b94918c280dd9068c3871861c02','discokey:3cf2b60ecdfbf0b633afb7c89de5c05274933adb6a71fdfc28fdd79c0814ee51','lt-86','node012',5,'cli',NULL,NULL,'2025-04-05 07:56:06.898009216+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2e1:2c69:85a7:8894:dfe7:6f6c:a382:4fc]:6426","[e758:c726:ced4:43ea:60fd:3ad8:1b8b:b514]:15200","[314c:5aba:d6ac:63d3:4de3:2c46:5e60:903b]:30789"]','2023-06-20 18:22:35.061914624+02:00','2025-04-05 07:56:06.898660893+02:00',NULL,'100.64.0.12','fd7a:115c:a1e0::c');
INSERT INTO nodes VALUES(18,'mkey:88ef4bda4139c7c09e33bbc866b88e069c51187346d8095238179c82502dffcc','nodekey:7ad274415b296099222e0ca334eb849e0e6595ffa54dbcc94a0fc9ffa69d1747','discokey:388c1077bdd17ce1f86b92936609756ecd3e8b21ab3f4b8a84da7727dd2b2552','web-70','node018',9,'cli',NULL,NULL,'2025-04-04 21:32:36.521819531+02: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","[2acf:3f32:1763:5d21:88a:4af:8779:1b1d]:36283"]','2023-06-22 08:30:54.08720463+02:00','2025-04-04 21:32:36.56813156+02:00',NULL,'100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(20,'mkey:338d7e5ca6c5a8c65d7174eb1af312107408a16b7769b7088c8acf64134d9722','nodekey:440bd6fd6eea65489be99a6a95f4b6315ea55fa31fa1d6905a53ba4c046e0817','discokey:80890f521819e60c3778df342a98a9adfe2f46c15b0f55aa14f17df002aaa398','desktop-48','node020',11,'cli',NULL,NULL,'2025-04-04 22:24:36.219266862+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["191.156.96.176:5489","[166e:c30:4d73:440f:456a:22be:71e1:142b]:33036","[6d05:6bb8:3bec:c76c:1890:ca9c:2684:1bbb]:31223","173.218.108.179:51272","143.8.135.130:62709","[1af1:db8a:7b81:52eb:f4e9:e74e:905:79d3]:7418"]','2023-07-10 12:40:34.838579199+02:00','2025-04-04 22:24:36.219367472+02:00',NULL,'100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(21,'mkey:ee8b7cc5b7ece1e1a03fdf355a2356928cc272be6f9570866e8ab7d43c09036c','nodekey:2249e3a64297951858ce623341c49d6ebcfe94a8fb5e4edde4889b8f50deea48','discokey:555c31b79c570eafb2f3be56f01cc73913c4886081fc75b868d14340380e5a42','desktop-87','node021',11,'cli','null',NULL,'2023-11-20 07:19:19.447470862+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["207.187.74.99:12216","63.3.67.150:22907","[77ac:562:7c4c:438a:6ec:be48:743d:47b1]:11349","[33cd:731c:f110:9b45:66b5:de81:1daa:757f]:5997"]','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:2894a7babdc030bac1e4ec0e14aa4b6b67ebe382a1773e0ff4aa8b16ecd443a3','nodekey:1e219f3cc03eaa868018b9f6870d108317c31760fdc38ad4bec7200d58379f26','discokey:a81e998383baa23adb3e1e6757ef0c4b960095022f00b500b57f53c6147c71e4','laptop-48','node022',6,'cli',NULL,NULL,'2025-03-31 18:38:46.693334487+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[736d:a0a:e343:6b2c:b48b:7510:ace2:edc]:60377","82.193.154.129:23713","[68:80fa:7b30:3a0:d1fb:3e89:2c73:256b]:30308","[ad42:3917:5edb:3e85:732:1c71:a19e:9fe0]:11799"]','2023-08-05 12:08:48.132161695+02:00','2025-03-31 18:38:46.801242352+02:00',NULL,'100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(23,'mkey:9ab69494a274cba5b22cbcf35b3ada57d4b3d2ee03930a456f80fb34dc69064b','nodekey:0345912b4e39cd9d03dec55edec6fba7f8aca631312884b49538550475332182','discokey:a2c1be2ae50af07e5b96b0a3ee2d3a1b0148fbfc5c1a283bc787e31410d6f74c','web-51','node023',12,'cli','null',NULL,'2024-12-07 19:25:56.935152754+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["9.237.225.227:64622","[46a1:e1e6:6b82:6599:acc7:2273:afea:f09f]:38018","93.129.193.97:13477","184.41.32.72:1026","[f136:8b69:185a:7ec7:94a1:ca58:5d95:ba9f]:21119"]','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:94d0eadf801d88022019f9353b7c29cafdd060a269a0245396e01f1293953cb0','nodekey:1db769d2ca42bc0f8b4e18b5c89a31fb4595edf0592ce1a534b713ba503f07e9','discokey:912056b78049017764c78a047b65feb3c3b934fa26ac62b44f8d7d561711321a','srv-85','node024',12,'cli',NULL,NULL,'2025-04-02 22:03:44.023075093+02: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 11:14:36.765183054+01:00','2025-04-02 22:03:44.02329052+02:00',NULL,'100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(25,'mkey:247cad9ffd7d108f553e7658db14bbad992332458abb9b4bc5a0c0d3a13ead9f','nodekey:bbfb569ac8a34cf4d59d2bc13d0f03660d24aedf22c61b56510a65d20bdf0812','discokey:61f92520602549b9bc684eeed3186f608a38e13794d06d4b8d165c4efbb69a24','laptop-29','node025',6,'cli',NULL,NULL,'2025-04-05 07:56:00.717501781+02: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"]','2024-01-05 17:32:40.940566279+01:00','2025-04-05 07:56:00.718576252+02:00',NULL,'100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(26,'mkey:d623495ccdc12a3f219322cf53458a85c29b8795ceff5cef5338bb9c26e329dc','nodekey:781ad44c939f14168ec1c22c3fa2c5422f5ff1a5b0fc163fa80e6ace4e20c4a2','discokey:c474b4d7b9883e70466b6240b885a2a71dbe6efb0e8c84b85277beb584f25690','email-47','node026',6,'cli',NULL,NULL,'2025-04-05 07:53:33.912069529+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["173.144.3.182:33138","[975a:978:5cfb:5e5a:1b6:d272:a1c1:50dd]:3245","[e6e4:7cfc:9ce:b47:62f5:b64e:d2e4:9015]:42369","[26c6:541b:69af:974a:8ea8:6bd0:7c4d:5a82]:10571","[c898:1525:ebe8:704a:243b:de9d:b8c:ea69]:22747","32.167.123.100:57075","[2c67:a9f3:3163:c675:3386:2447:1cc:ed3a]:42590","64.137.67.1:56198","163.42.128.241:47535","49.160.22.202:42427","[1526:e34a:8857:394e:bbe0:c043:4b37:68d4]:5245"]','2024-01-05 17:34:19.811670479+01:00','2025-04-05 07:53:34.448650057+02:00',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
INSERT INTO nodes VALUES(27,'mkey:d95c13394bdb912ef51f3123fdb0495feef567dc13724efd8dea17b33ce7aa1d','nodekey:fd8be528ea41d74697d46084c8cf560fff1c21b3193bec752ba2d60457396b19','discokey:9ec066ac46492f546a67be34b417eb469dfc95aff8b7be28be3bd8b36bf98653','db-72','node027',6,'cli','null',NULL,'2024-01-16 14:32:21.570104175+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5760:dc4e:eac8:5c38:6c9c:8451:98d6:4e9c]:21573","[e350:bf94:9128:bca7:8c74:ab49:c419:4c50]:18052","222.155.102.116:42746","[e32f:122e:8a:e473:4b83:8ec9:61db:60ce]:37054","154.68.57.163:54048","[c5a0:942c:ed88:2277:3c9a:4f65:a25e:5b40]:27852"]','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:08347db9fbe8e5e7a968c2ab9ddd1ff530ea98163c0bab7769316307545f4d46','nodekey:b6b03efd7deb52dbe0298708ea37400510ab7589b0b1787eac1a5f9b50aa7c80','discokey:6a0ab2f3329d9fe5f50c76f9f3f1d2e797574af93d823a511df57f45414f647e','srv-42','node028',7,'cli',NULL,NULL,'2025-04-04 14:08:44.348585699+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["42.99.149.47:5231","146.122.164.252:36824","16.15.205.75:58574","82.136.149.34:28707"]','2024-01-15 09:34:54.847632697+01:00','2025-04-04 14:08:44.348711737+02:00',NULL,'100.64.0.23','fd7a:115c:a1e0::17');
INSERT INTO nodes VALUES(29,'mkey:4a6e46330ccd4b3026337cdef37485c27592babda329107565c2a19d97253dcc','nodekey:17de47da1955a8a034788ae671c34fb10083568bf9e2f7494276cb2636065246','discokey:449f5f35a3507974cf03e3ac5c055d890de5122f57a7c2d84a0d3b324998607e','desktop-17','node029',7,'cli',NULL,NULL,'2025-04-04 21:46:12.712212086+02: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","173.82.71.57:3159"]','2024-01-15 15:18:12.2871978+01:00','2025-04-04 21:46:12.807613421+02:00',NULL,'100.64.0.24','fd7a:115c:a1e0::18');
INSERT INTO nodes VALUES(30,'mkey:26f1059c45c12a8e56cd57ba6db33dfe104eac76103327af49622cb7810fab7d','nodekey:b157bbdc37aa4634b8d69d6fbc7670780fff69337713176a11f893afafa2a9bc','discokey:4c8c175d0e61ca8f7b2de92a1033cb9be95eaeaf09e9395c767afa5afdf2d9b5','desktop-64','node030',7,'cli','null',NULL,'2024-02-05 12:14:40.065688294+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8a1a:5c17:bb81:bb69:c7db:3513:f14c:ca2d]:52077","123.235.220.59:59925","155.210.184.45:60093","[963:536a:33e9:99fb:c204:d59c:29a8:ac18]:39005","[e84c:35c4:4bd9:a100:c271:8921:ca7:5901]:21828"]','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:ef048095dd3e937a8617f18797ed42d2c4513d07126dc419a466f257982113d1','nodekey:1c6c367df9b85ab5e1618c70c0a4f8b22e2eeea77523b40059c3ebfef0f4057f','discokey:80fb63a98202437504c700e582eddf800b02dc654577bb95796c60cdf1176793','lt-55','node031',7,'cli','null',NULL,'2024-02-22 08:35:27.098819037+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[cc02:5592:3738:a2ab:8c55:97bf:a5b8:24e6]:41616","129.130.98.189:47833","[99c0:d769:2f38:10e9:c01a:e3d:898e:afc]:17505","[3423:afbf:aa2:e156:81df:bbd3:412a:df65]:5125"]','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:5b0e391e12914bcbcc6b415d9dd72937d74f9ce92a22c6ec938eb749962ee6ce','nodekey:4fa73acfb54cb140dad6b02bc853f6360f5ed160f819dc57701ad9a4caae9782','discokey:d3e90723a3b90eea513e7710ccaf25f68c0a2d60a85e3d4b9e4385335fddf8e9','srv-15','node032',7,'cli','null',NULL,'2024-04-09 13:59:43.37062537+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[14bd:ee53:6776:c1c0:124a:efbf:38cc:b312]:62180","85.234.248.186:20429"]','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:ba179b51f3540e619eaac9a6d4bc67403daa7c3cf28a6b579087cd6d284501b4','nodekey:246fadfe2a3606f043aca1fc1fa31b79e9eef9c21ec67e72425e05576707b3c6','discokey:5c64c1a08b88425b6e1e2971f950708d38f951d2d5eed2b85df8dd7d1bb88a44','desktop-32','node033',13,'cli',NULL,NULL,'2025-04-04 21:35:50.079412269+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["106.67.113.92:45634","85.199.78.110:6716","[bc29:715c:cdce:f1f6:8630:4929:ea1e:5c03]:10918","[af8:f5e8:32f0:75ee:d351:c0e9:78e:93d9]:12624"]','2024-02-03 16:33:26.706408143+01:00','2025-04-04 21:35:50.07986885+02:00',NULL,'100.64.0.28','fd7a:115c:a1e0::1c');
INSERT INTO nodes VALUES(34,'mkey:6fe02bbbdd40bb09e8aa74cf66b40b5b94f227690fd804a33242f56e18bee64e','nodekey:acc333e66d45e660ff4a31a152340d391547ebef1056f5f046624b629389bfd3','discokey:cf4a1217f85585d74fc5138af6ed9b78a29a9d4f12ad2e1beac660816d8c7b3f','lt-74','node034',13,'cli',NULL,NULL,'2025-04-05 07:35:41.145084059+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[1092:57ce:a60b:141d:ba79:79a3:91ed:66b8]:11037","[f766:14e5:6acc:ba40:8b28:59b7:ef7f:cd51]:46293","[c:e6fc:18ea:2e45:6bef:c1c1:f84e:b1e2]:62296"]','2024-02-03 16:42:32.683785672+01:00','2025-04-05 07:35:41.16521778+02:00',NULL,'100.64.0.29','fd7a:115c:a1e0::1d');
INSERT INTO nodes VALUES(35,'mkey:f95240eb788522b37f5513f0253f8bdab2ccf7594ffbf9bb77945fd67e598c05','nodekey:f5a6f47f5a34b4f4c6883e46fb52c0a5f7ca2ce17397cbba751efa8736e0066d','discokey:4dc728a0c0de0ce87530a47dda426d5bf6ad1b2f6cdefcc819c29c1015c3131e','web-44','node035',5,'cli',NULL,NULL,'2025-04-01 19:27:16.8887994+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["136.113.252.147:325","139.180.210.231:32286","171.29.58.211:2336"]','2024-02-03 16:51:52.010016072+01:00','2025-04-01 19:27:16.890057487+02:00',NULL,'100.64.0.30','fd7a:115c:a1e0::1e');
INSERT INTO nodes VALUES(36,'mkey:8ac09adfe44b8e60665601726c99627216e71b49ef7e8cc58ae6ba4f997c8652','nodekey:62d8af3310a7f27d84b931eaaa7ee110fe7fe46ea3ca8c817e47b9ce456c9b4a','discokey:bd31ae97729ac879d9b57866a69abb521248fb7fd5663d2149857d4dbf023d85','web-93','node036',13,'cli','null',NULL,'2025-01-19 14:01:48.956567669+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[7e9e:219a:507d:d3d:cc77:6195:7ce3:b30e]:25018","203.251.190.122:19081","49.144.40.103:7674","[a641:3f06:63bf:b716:4658:1e5b:ac6f:e14]:13490","197.206.147.31:58506","[b1e8:68a0:4017:a243:61d0:b303:7860:18e]:28633","[e5b8:6c78:ce2f:cf6f:13fb:401f:8223:3f04]:54121"]','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:c371756901cab84ae432a7d201e47232b008ef55effcf90341f24de7dfc55bb0','nodekey:0f858ae8a6492e1cc63fb502c6453ae90e8723f8b4ea8eba8c67f9f5114dec39','discokey:b6fc59b2a9ec7ddf1ae9573245cd3271259f964cdd730b811fabb019eccb3c81','db-47','node037',5,'cli',NULL,NULL,'2025-04-05 07:56:56.882618261+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[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","193.82.125.68:38601","[e9da:1552:e478:f920:c3d6:ff41:9e86:e27e]:48481","[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"]','2024-02-27 12:14:40.452601042+01:00','2025-04-05 07:56:56.896138732+02:00',NULL,'100.64.0.32','fd7a:115c:a1e0::20');
INSERT INTO nodes VALUES(38,'mkey:465de79eadf29db3136d0b230c481876edbe7e05a803281a523618c586fd3c01','nodekey:01614d4aa1bb0be1f6b41e10aa9ea1c7af206ef9a2571bb68c24e85bea697216','discokey:d3eea5725d8408db2ffc560d74c70da0a70c3f3dc40a0d6a6fad9afaaadee9f2','srv-59','node038',6,'cli',NULL,NULL,'2025-04-04 10:17:46.472491162+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8125:ebe4:83e1:4806:f061:5bd9:a08a:8ccc]:6467","114.199.17.195:52817","[de36:fc02:8cf4:c60d:824a:9963:2440:5b5d]:39343"]','2024-05-22 08:08:16.045350656+02:00','2025-04-04 10:17:46.473325907+02:00',NULL,'100.64.0.33','fd7a:115c:a1e0::21');
INSERT INTO nodes VALUES(42,'mkey:ff2ce8eb04d99e45d7babacacc758ec8e031474fcf494b4c0349c7084cc62365','nodekey:660bae997d6da1efccc0135ed712176a379f59ec9ca7a02eddea607a8855cebe','discokey:66ca4169c6be68079a1244ec506d8c922af4133187e0117a1800ed4791ed9a67','web-21','node042',14,'cli',NULL,NULL,'2025-04-03 14:18:40.656342991+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[3a3f:717c:1ea3:7c82:81e4:5d9d:765f:7da4]:6540","[bc95:459c:aab:499d:4354:d239:ef14:dcb]:14429","[f673:7912:6d5e:7244:62ca:9500:78f5:31c0]:27677"]','2024-07-03 11:12:29.418355657+02:00','2025-04-03 14:18:40.709062776+02:00',NULL,'100.64.0.37','fd7a:115c:a1e0::25');
INSERT INTO nodes VALUES(43,'mkey:df2afe1643d44e7b5d2b4fe1b78e8b0c8c7871b50b1b580048cf6b184cc99143','nodekey:4512e240f89db2671db1ad974c151afad41491d7d11486b644aa2cf66bc3410e','discokey:f4b10325d44499f510cf0bd61d7c9d116b10c14434b8fab4559f0797f033936a','lt-12','node043',14,'cli',NULL,NULL,'2025-03-31 18:38:47.400103948+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c91c:4366:d3bd:a993:b5e:75c7:ef8e:8166]:46974","191.185.253.85:37427","17.31.200.70:26794","[183d:f2d6:b80:36c5:318e:64e9:7f4a:b389]:12440","169.173.198.12:15274"]','2024-07-03 14:48:50.263910778+02:00','2025-03-31 18:38:48.06470771+02:00',NULL,'100.64.0.34','fd7a:115c:a1e0::22');
INSERT INTO nodes VALUES(44,'mkey:7d71974b3095c1ae476074cf0e7e5628088873768b2a24b827c50699dc9d61d5','nodekey:bf967004b398b7634581159dae489f4f6f9ab3a56b35d5c5bbf5751b2ac73bc8','discokey:5be6e1d98febe4e50f1b907d23635c2bd342e9d5ec9524df24c4349c752ac923','db-53','node044',14,'cli',NULL,NULL,'2025-03-31 18:38:49.196820572+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8dab:7bad:415:97d8:4ecb:2a7e:14ae:64f2]:15771","[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"]','2024-07-03 15:23:48.066044194+02:00','2025-03-31 18:38:49.528314036+02:00',NULL,'100.64.0.35','fd7a:115c:a1e0::23');
INSERT INTO nodes VALUES(45,'mkey:3f3fa2155a168125fd4d22d58f30d1d101796d67dfbe317a3808721019282ce0','nodekey:edccaae68a3381b0f736db6a23a9d45a8747caf1a8427ac5d680205cc4fed415','discokey:7a91312730081d203379ecdf264707a4325fdf272e1338b0abf770f0050e33ae','email-63','node045',14,'cli',NULL,NULL,'2025-03-31 18:38:48.272123393+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["161.33.154.107:16255","[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"]','2024-07-03 15:54:01.706018896+02:00','2025-03-31 18:38:48.790175394+02:00',NULL,'100.64.0.36','fd7a:115c:a1e0::24');
INSERT INTO nodes VALUES(46,'mkey:d084c15ae8c10c1de1d625c7292df7da48e4fcfd1ad860ca140ce9259254a1fa','nodekey:6ea87964a36dfb6e359a0721fee4e988461cbf585410fd2a49321d49e215eecc','discokey:bc27f1168519c55a34986345caeb0f666d18990faa74a8b84b317d33058987b5','lt-93','node046',14,'cli',NULL,NULL,'2025-03-31 18:38:46.808546326+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2077:6b7:927e:5e5c:a0f0:3352:1490:e1e1]:47997","6.170.76.62:28497"]','2024-07-03 19:38:07.783745318+02:00','2025-03-31 18:38:47.865608242+02:00',NULL,'100.64.0.38','fd7a:115c:a1e0::26');
INSERT INTO nodes VALUES(47,'mkey:6a001dd5eed681d035dc3235ead186e6722d92e80695430ec542664659a82b68','nodekey:4a2155f4fac513f7382187a6bced77ab0a1a1c8fc4bfa93f31eb3236bdeb0308','discokey:76377c4b4a67de97ad3ec8af288ef68b7c917da1845351f9e49f7b588bed2b3d','email-54','node047',14,'cli',NULL,NULL,'2025-03-31 18:38:47.867863816+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d722:f972:c192:4cff:3916:e1e7:6d02:236b]:55695","101.58.151.244:39467"]','2024-07-04 10:38:08.344092869+02:00','2025-03-31 18:38:48.178140996+02:00',NULL,'100.64.0.39','fd7a:115c:a1e0::27');
INSERT INTO nodes VALUES(48,'mkey:479cd91a3b16f2636c609f67817778a3ba3f35a33c5f3a6fad9ef86166ccae38','nodekey:5bf0038573184bd6031b88e9412f42eda5a8ddd2ec5761e1f22b9125b3c349c3','discokey:c7e977fadfc1bbd63183a2a2d82f1fb1f1700aa1b36c03b8c1754d46560fdfd0','lt-53','node048',15,'cli','null',NULL,'2024-10-20 13:53:33.831192385+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["60.228.0.149:54791","45.103.140.120:38129","59.24.21.245:44110","[def3:2f58:1a57:4620:9775:7f2c:3aab:52a2]:50978","[9236:c0c2:b9b4:e60b:99ff:582e:50ee:92b9]:25915","84.253.15.156:7777"]','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:4d5f9a38fce205b2dfb62f42464172a1408e00221317b01332714a4db55e6ebb','nodekey:415009b46e40247f7a60d9e0f53c938b6a032fd4c11ae70d824e2d95cf170957','discokey:280e5896d458bd63044265484d38ad711ef52a68981f83281ff693e837421a13','web-11','node049',16,'cli','null',NULL,'2024-09-19 09:07:18.28136023+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[475b:3641:5abe:b0a8:8a68:dd51:8e80:3efa]:574","153.151.233.195:41734","[19b0:8be2:708:d27f:4d3d:3c93:9979:e9e8]:50438"]','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:a35a00c69e2fa10d442ae03a4d9312ee61e56caaa030d1303a4ebab2b26c27eb','nodekey:39bf208ba118345630aecd3c6ed042d40b1e6b4897c9548a21a473c28352ba95','discokey:437f4dda6cfd2d269543f32dfaac1333b8660cec03b279728e296f6cbc67ca69','db-28','node050',10,'cli','null',NULL,'2024-08-07 10:10:06.595550455+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["150.170.146.70:3311","139.117.239.209:33788","[2eac:ffa0:99fd:d109:c120:a35d:ed48:eea3]:51544","[7644:c348:2969:b90:e84f:94d4:b629:f266]:49336","169.247.3.239:36225","[5b4c:bb2:d43f:6ff4:d494:8616:a66a:d059]:50360","203.180.122.83:13344","63.162.234.32:11653"]','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:38d8adcfb8f6217b6dce62c89e816da260f1b0747a9a980e0ede5de9412aab4b','nodekey:98cb6a87bfa7cd614051008583e5f0904552b44d98854a0fb5d8e0e3c3115949','discokey:104eda6ea8f8fbeae20617662e601bd0acf102511d17ffc829c08db6a7f78872','laptop-32','node051',14,'cli',NULL,NULL,'2025-03-31 18:38:45.515173008+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["33.182.22.166:13283","181.10.243.176:14596"]','2024-08-07 14:19:31.156780417+02:00','2025-03-31 18:38:46.360795928+02:00',NULL,'100.64.0.43','fd7a:115c:a1e0::2b');
INSERT INTO nodes VALUES(52,'mkey:3a83699597e3bee8b15df3733dfb54b1d7af3ff9ccc7a4b65df4b0feb4a3f25c','nodekey:86cf80f0bd8bef4888116f2bab1b5ac4b11bd6fa637f7ef0886cd0aa265b2bec','discokey:28e2d745a5216bdaaeb83b4483b19d1c2ae0c149b97c08c06a4b90ca2c742a00','srv-53','node052',17,'cli','null',NULL,'2024-12-25 17:27:58.515851096+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["72.183.239.155:49891","167.46.143.131:51781","[9e9f:93d:a8cf:c86f:17e3:9e2b:dc42:efa6]:3616"]','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:d1fda0c437a79b121817c1c24e88bce18fdab566d5e74678b8730cb48c1dd574','nodekey:1463eab453b78867448baaae38b88547334df5070c30e77a08cd3410bd721d8a','discokey:4688405d194600e9c1a783e71e274c3e42976a5021d81db4ba4a0506a768cbca','srv-86','node053',17,'cli',NULL,NULL,'2025-04-05 07:53:50.501049438+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["69.219.0.37:43476","[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"]','2024-10-28 10:04:50.084492941+01:00','2025-04-05 07:53:50.501509322+02:00',NULL,'100.64.0.44','fd7a:115c:a1e0::2c');
INSERT INTO nodes VALUES(54,'mkey:4eee40f0117b3b8580f4cf3ec7be063bb4d82173cfa3c015c8932431940d9c92','nodekey:4241ffb9768a0e31f38cc0c5b2f240c1de72b8810e7ff3705964316e63c1a055','discokey:3ad8f2ebea95d15109a0adfc69b3a6b566ce02ce82df7a32e68f278538bc05a2','lt-15','node054',14,'cli',NULL,NULL,'2025-03-31 18:38:45.793020142+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9fe:6ddd:ab0:1193:7bb7:4a4b:c036:b910]:63516","158.169.112.249:5480"]','2024-12-09 17:10:55.363593066+01:00','2025-03-31 18:38:45.816484332+02:00',NULL,'100.64.0.46','fd7a:115c:a1e0::2e');
INSERT INTO nodes VALUES(55,'mkey:22e4ac4e25b05db4e94b5211e08ed14d983972f92e192f15e0231ff355fd46bf','nodekey:225f907deaffccb674416dc4ba532f0b20304e86d57808eef2d96f15211f2309','discokey:e695b849380f698178e7457311dca3cc10ae13a79b0a71d22130e7c401c4f246','web-26','node055',18,'cli',NULL,NULL,'2025-04-04 15:19:04.171978054+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[ecbc:a9b6:cbb7:695b:62ad:27cb:36f0:2380]:27992","135.238.213.41:64084"]','2024-12-10 13:56:39.287449662+01:00','2025-04-04 15:19:04.174839842+02:00',NULL,'100.64.0.47','fd7a:115c:a1e0::2f');
INSERT INTO nodes VALUES(56,'mkey:ad967c824d2c235ed17b1437f6756d4354ad76a2d27b575c0257ecac9a3a5fd2','nodekey:6196332e325e3f1d0c58acb182b48b070340dd673247c616a28d60a7669f5a4a','discokey:3a67fc6fdb9288679886c2d45dba4d1e1ba014af2c48f0f942acd39ef0e0ee64','email-56','node056',19,'cli',NULL,NULL,'2025-04-05 07:53:56.457113205+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["122.41.198.69:28824","[5437:6f4:94c1:c6c1:43ce:7a41:e5c2:65d0]:57161"]','2024-12-17 14:58:39.429211911+01:00','2025-04-05 07:53:56.457486062+02:00',NULL,'100.64.0.48','fd7a:115c:a1e0::30');
INSERT INTO nodes VALUES(57,'mkey:3d9e1a7fc884de338b8391bbc5d3398c7d0ec4c36388b756df5b2304b727fa11','nodekey:9cd5d41c04ae83ade43363dd165c792cbc5386e0d3e005311ca7c79ae7f7acaf','discokey:2d6fad1f43bc97a6d48bcd400c829db2d4f47291b12a59dcbe669d8b1d341c1b','srv-70','node057',20,'cli',NULL,NULL,'2025-03-29 11:27:16.332745436+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a34b:36c0:9f18:1062:2269:92c:1c83:6ec6]:56902","[41e8:60a4:229:a09b:efd3:c73f:b885:d235]:39533","44.230.54.249:64083","29.229.203.183:13","153.68.228.171:36559","138.154.192.66:772"]','2024-12-17 15:17:14.26936913+01:00','2025-03-29 11:27:16.556356179+01:00',NULL,'100.64.0.49','fd7a:115c:a1e0::31');
INSERT INTO nodes VALUES(58,'mkey:97bc215b57ea30368b04727189d5a09f60e682171b2b05355d046f86cd4aa30d','nodekey:33c0e1c36d9762397b6406cba0f71c77dc7d11b8838911c7ce1a1cb632751e1a','discokey:f8394e6be895b3c2261fab8cd62d1f28124d377df6b4b17dac4b9f18c54a3e00','desktop-11','node058',12,'cli',NULL,NULL,'2025-01-25 18:41:03.881898904+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2ddd:7c1b:a237:41c8:3baf:e9cc:1f31:9057]:62916","[9c34:190d:7bf0:c940:18d6:f96c:9aca:8c0a]:8787","181.226.177.82:63703"]','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:4d690637aa5cdd6575d9dbb7fa0b55c83bece3e82bc689e73122c9120f871772','nodekey:8733914d48b0c34a0111ec5f633123ae4ec7de39e597077d659ab8f2354270b9','discokey:ff25bf692a69cc0e79101e1cc1b926ca97b6e3897e65c55e5bd3f09ca1ea6d16','lt-20','node059',21,'cli',NULL,NULL,'2025-04-05 02:21:31.304172899+02: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","[536b:bf65:da86:c7ca:ecc4:c84a:1811:334e]:24087"]','2025-01-29 11:59:27.291048957+01:00','2025-04-05 02:21:31.304988854+02:00',NULL,'100.64.0.54','fd7a:115c:a1e0::36');
INSERT INTO nodes VALUES(60,'mkey:552ca0e4c611df54a38bd150d7f6c4ef77c66625435073b3751718e44884b92a','nodekey:7b4b25d90935b79af2efc7f0499d3f16a49d5078997314de57b65fb5ce01cf1c','discokey:2118ebb5a0b1c12de379802db2b247fcbf516de56216c4d0ee7a0489dde05071','laptop-14','node060',21,'cli',NULL,NULL,'2025-03-31 18:38:47.60389811+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["67.131.191.86:14533","45.142.234.80:30901","58.251.220.64:42364","[d9a7:5288:3427:e52b:4eb5:794f:11d2:5d6b]:33898"]','2025-01-29 12:01:57.48748166+01:00','2025-03-31 18:38:48.228181117+02:00',NULL,'100.64.0.55','fd7a:115c:a1e0::37');
INSERT INTO nodes VALUES(61,'mkey:f5eaa64ce3d0dbd7539fd9c3f9a494688a4a64b9a3d1fc0b9f40dedc14192ba8','nodekey:ccd6aadf68fdcc95d0d15f6654a0c6bfd5ebbf282491539ee63e5b0848de9ef5','discokey:a492c6d1d0b9de44f6adcf7ac919d49c269058d301b4be21fbb5bf4203b2fa8b','db-97','node061',21,'cli',NULL,NULL,'2025-03-31 18:38:47.847511392+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d002:74d:2b8b:87bb:25cf:5512:50fc:e379]:46829","206.194.47.198:21677","22.203.32.217:28664","112.239.138.73:43954"]','2025-01-29 12:03:01.464646336+01:00','2025-03-31 18:38:48.152116326+02:00',NULL,'100.64.0.56','fd7a:115c:a1e0::38');
INSERT INTO nodes VALUES(62,'mkey:4cbd491b0977f3a8cc92ef9f20a7726b3984f3c0699429ae46a0bceec5febee4','nodekey:66a7e77700fb0f4bae5b282413bdb5ff7c375549dd85c4300c73ff3d8029b4a4','discokey:2e9034fc43993eaa0cf2bc21118d378bb02afb3d197a33cf9f0dd201d176b23c','web-06','node062',21,'cli',NULL,NULL,'2025-03-31 18:38:48.069494509+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["81.51.60.60:63220","12.64.198.119:51541","[5e99:3950:5dc4:45be:bab7:e7ba:2476:14e8]:43360"]','2025-01-29 19:23:14.092804852+01:00','2025-03-31 18:38:48.161442612+02:00',NULL,'100.64.0.57','fd7a:115c:a1e0::39');
INSERT INTO nodes VALUES(63,'mkey:70cc01dc48021a01c44ab1a4bed313bb8270640ef7317fd983019c4b5e593cf3','nodekey:bfff30bca701176ec3b45b2991810cc437e3995207d924c896c4250e0efdb782','discokey:91eb7d9fa7688e3ed641adfae83be298c1ab261fd00dc2b4ad9cb4c269b623fa','laptop-27','node063',21,'cli',NULL,NULL,'2025-04-05 07:46:04.800277542+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["105.95.65.117:11546","[68bb:e8d1:72d8:8b02:608b:2284:c9b3:184d]:20876","[5c17:4014:ea6a:5528:b1a:61b7:5cda:5c5e]:21597"]','2025-01-29 19:41:40.535299057+01:00','2025-04-05 07:46:04.80130455+02:00',NULL,'100.64.0.58','fd7a:115c:a1e0::3a');
INSERT INTO nodes VALUES(64,'mkey:ac14ce6b1ecd1a0d79bbf60d279f19d09baf0ebd409f099a401816516953eb30','nodekey:a711e6a5750ec7cceac6a771396b000766d9af8a34327bf5efec3216316e8afc','discokey:0b370e73e9970987dad3fd00317f51c68e4273fbc11b754ef7e84d4d6880002a','srv-33','node064',21,'cli',NULL,NULL,'2025-04-05 07:53:41.648931109+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["145.91.193.5:37126","[2fb6:ea0a:3639:a1cd:9075:a258:6a79:4f5c]:13944","[2384:3000:4d47:a9e7:54ef:99:52c0:e920]:39358"]','2025-01-30 18:18:57.519126133+01:00','2025-04-05 07:53:41.649324054+02:00',NULL,'100.64.0.59','fd7a:115c:a1e0::3b');
INSERT INTO nodes VALUES(65,'mkey:899a5048a327c15cade8ca854986909ed306f37b2a7655785bbf838c99285ded','nodekey:11b61191a3fc660e078ddc10a65c29c51459b5d67351d99967a504ac6c791f23','discokey:124857d5d0233a30c595fab8e1e5ca8659c9c3c5164fbd084582e7d697c5f580','srv-60','node065',21,'cli',NULL,NULL,'2025-04-05 07:56:55.874050704+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["167.46.40.4:60291","102.143.230.113:46288","[b341:3259:c5dd:9f91:fd70:c616:3033:2b3b]:59081"]','2025-01-30 18:19:40.354692307+01:00','2025-04-05 07:56:55.875106342+02:00',NULL,'100.64.0.60','fd7a:115c:a1e0::3c');
INSERT INTO nodes VALUES(66,'mkey:547a8b97c8c8227d9ba40174ce4d28d0e64f10fae3f39797c60e29742ed59e62','nodekey:cb4a9d1dee6f581036b7c262348cf2c4a96be8b2eea78f7805097e3f7b1a9fcf','discokey:c233a42a4afb5fbf921bf7b3fb4330e6c46273d18570aaf6b7254dbf3c67614f','desktop-82','node066',21,'cli',NULL,NULL,'2025-04-05 07:57:45.102165038+02: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","171.59.96.217:25726"]','2025-01-31 12:05:28.65297301+01:00','2025-04-05 07:57:45.169550808+02:00',NULL,'100.64.0.61','fd7a:115c:a1e0::3d');
INSERT INTO nodes VALUES(67,'mkey:eb72ad359958c98e28f93485b720b6edef80d1bc33c4f99d772fc17c766039e9','nodekey:9122bd587ae90984e3231e0f48e15aa8abcfbc1b3324becd1f3622bbbe534da1','discokey:7610d45f8d2d3d4d7774c43288a6d50cd798a832732613647caa15e96621a3e3','laptop-93','node067',21,'cli',NULL,NULL,'2025-04-05 07:53:21.399420055+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[3022:fc47:6534:7fe3:9d1e:8d49:75b:984b]:10998","60.241.100.13:15037","[9356:40f8:a98c:a1a9:18e6:e781:f169:4277]:63375","[c733:e842:4621:e95d:6576:9ccf:b2c8:1582]:41668"]','2025-01-31 12:06:30.121464114+01:00','2025-04-05 07:53:21.744746916+02:00',NULL,'100.64.0.62','fd7a:115c:a1e0::3e');
INSERT INTO nodes VALUES(68,'mkey:18580a8353c2c11c364849a9b45141ad99c22e2052de3b07c0a3e095ef6ee9cc','nodekey:d375fbb50d508e31b73b4d960272b0d886df1973e1c00b71723d5dcd7c658b5d','discokey:905bd1003c6e9822d22177c87108107c8a84c9f4f99d0f6e452457b7fdc2f23f','email-60','node068',22,'cli',NULL,NULL,'2025-04-05 07:52:45.084976072+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d89b:6894:a590:e3f7:d152:3a19:3826:ee28]:40749","99.13.253.35:45887"]','2025-02-03 14:16:55.56431345+01:00','2025-04-05 07:52:45.085842656+02:00',NULL,'100.64.0.51','fd7a:115c:a1e0::33');
INSERT INTO nodes VALUES(69,'mkey:9562166c366f1968a5f82aca83bd8152d893541eed4d8682da0a540825cd44e9','nodekey:93ef8b713afeffc4324b0f9a99e185be61dbff43d6e5769efac6d82481b425c9','discokey:9aa3fe84188c317d17132a26604380ec4aaf7aed94b4b759bb6b643dbd53f8d9','desktop-61','node069',22,'cli',NULL,NULL,'2025-04-05 07:49:17.983292316+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["56.191.25.57:54747","74.194.16.233:59572"]','2025-02-03 15:23:16.312084161+01:00','2025-04-05 07:49:17.983430933+02:00',NULL,'100.64.0.52','fd7a:115c:a1e0::34');
INSERT INTO nodes VALUES(70,'mkey:50329891edd2948b53a0905245386567c98b46bc0d566e39e1763768d51cd638','nodekey:e4ebfcbd1e1d653bda175a62b765c6a646b7844b3d6bd49a9955f96a9b284c6a','discokey:f59cb75bac53aef739bbd5be676808891ebb55550aa0560396dc0532658ed893','web-53','node070',21,'cli',NULL,NULL,'2025-04-05 07:51:00.943197398+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["200.133.152.206:14119","28.101.69.72:35202","52.120.18.3:13372","[dc9a:ed1e:f97d:b356:d5f5:5d44:c917:3077]:33994"]','2025-02-03 18:09:35.161109801+01:00','2025-04-05 07:51:00.943819644+02:00',NULL,'100.64.0.53','fd7a:115c:a1e0::35');
INSERT INTO nodes VALUES(71,'mkey:9845e32e5bdac3fde9276125068f931ea329c65dd136081ddad62a644f41a795','nodekey:9a927389db6eb337e83a82882b5d4dc56667d1f1b2b774122f7e907a5511a95b','discokey:9dd163c600f6a522255812bce48ff492eb56771f74a9e40af7514375b221b86f','email-32','node071',21,'cli',NULL,NULL,'2025-04-05 02:20:31.545698826+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a57e:a4c2:c889:ff09:e17e:a0a0:2623:282f]:2539","137.63.201.132:39740"]','2025-02-04 12:03:50.32663805+01:00','2025-04-05 02:20:31.578007599+02:00',NULL,'100.64.0.63','fd7a:115c:a1e0::3f');
INSERT INTO nodes VALUES(72,'mkey:e91a507e388c22494ec286192de1d6f5943c88a7084fbe1f0274f1d1f6169c06','nodekey:341a90749469a79de31683b37038f0bfad8aa8dceb80ad6850ed148f8fdef655','discokey:a2143d31409f3645542e4ec1c2982e6cb4cfaacbe7cb99111ef112afff1907da','laptop-21','node072',21,'cli',NULL,NULL,'2025-04-03 11:30:24.373825692+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["93.35.202.238:41314","212.130.175.245:30054"]','2025-02-04 12:07:36.231437299+01:00','2025-04-03 11:30:24.376835622+02:00',NULL,'100.64.0.64','fd7a:115c:a1e0::40');
INSERT INTO nodes VALUES(73,'mkey:575f781bb36f7c93cde4d9808e3dedef2c8999864ea1d4e5ee73fdd3d53ac217','nodekey:00e3275941e7a0a73a1e5c44cea638a411c60bb2e257812e0f39152ec0c5a21b','discokey:69a8791ea090c8867078eba807d456ce8363aab46f0c998b327f4c7aaed091a7','db-48','node073',21,'cli',NULL,NULL,'2025-03-31 18:38:46.80095927+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["74.253.132.228:65062","20.112.75.120:15833"]','2025-02-04 12:10:26.50545127+01:00','2025-03-31 18:38:47.215533873+02:00',NULL,'100.64.0.65','fd7a:115c:a1e0::41');
INSERT INTO nodes VALUES(74,'mkey:8a4990c19c547da50875ad00613118d5382717652b4ef9897a1d1c060c40a976','nodekey:4894fef93c5af5094e3f9d18b0c7c822b66ade3221829502c95d2e0ae88ae3c4','discokey:fbe18283aa4bc599c8dd8c82c5fe7b236f1f059bf0344ce9a28e1196258811a1','srv-48','node074',21,'cli',NULL,NULL,'2025-03-31 18:39:34.600462031+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["114.141.127.86:11858","[d05b:3c4f:8402:823f:409f:87b2:4dab:4959]:58420"]','2025-02-06 17:33:12.557302525+01:00','2025-03-31 18:39:34.632063451+02:00',NULL,'100.64.0.67','fd7a:115c:a1e0::43');
INSERT INTO nodes VALUES(75,'mkey:fb413a3831a1db1639197bf6eb887a913ff044346d9fc07eeadc50aa96ae196f','nodekey:763f78cdd841a2859c2a7e1b00129ed1a527e97afc193da93d864263fb048c0e','discokey:1c658f44f2e30f60cd35d6d730625710bb86ca1873f0cc55f6a08f0fc62bd814','srv-20','node075',9,'cli',NULL,NULL,'2025-04-05 07:55:19.031501504+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["147.221.39.105:29051","146.211.135.172:35153"]','2025-02-06 18:23:55.709687186+01:00','2025-04-05 07:55:19.031893003+02:00',NULL,'100.64.0.66','fd7a:115c:a1e0::42');
INSERT INTO nodes VALUES(76,'mkey:7a392b19fffc82a338a4a9e640b63b474c918db933a38bb72dc8957dc95fffb8','nodekey:29a892ef6ca08c4691db5272b310b98a0abd3c2f40372702323afc30909517b9','discokey:4ae873b73a87e7282a9275c3d5e9c68227934f68c6601567d92ddfe202d2cd31','laptop-09','node076',21,'cli',NULL,NULL,'2025-04-03 03:19:15.701019816+02:00',NULL,'{"fake":"data"}','["[9768:8d0:63fc:993c:bab0:4be6:571e:9579]:64245","205.167.26.141:5100","140.129.39.90:29397","163.61.27.204:21704"]','2025-02-14 15:29:45.220999928+01:00','2025-04-03 03:19:15.701454834+02:00',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(77,'mkey:3c49826dc55bc0e0e4643777d4950888452791b9f41b4cdcbce633551c7e4586','nodekey:8c5b96984a77dfba9d9ab0da01c4834e27b4c5e8add2aa9e22be59fa675b58e9','discokey:3f25a8ba8632b6e6dc3148ae42fd90ec433e9c47a98dfcf2f65d326fd030a47c','srv-81','node077',23,'cli',NULL,NULL,'2025-03-31 18:38:48.332406555+02:00',NULL,'{"fake":"data"}','["[734f:219f:40f0:ea33:47c3:ab48:b4f6:a239]:37955","[aade:2619:9aa8:378d:2365:1ab8:8920:a86]:7960","[71ce:8ddc:ec8a:58eb:d01e:2951:a8a7:dff]:31349","209.201.158.153:40013"]','2025-02-14 17:00:54.226657615+01:00','2025-03-31 18:38:48.558712405+02:00',NULL,'100.64.0.68','fd7a:115c:a1e0::44');
INSERT INTO nodes VALUES(78,'mkey:a89496b608c3a9a479a8adcbeac38dd6a856ac638d3ce35c715abb10ef0c278a','nodekey:04e6629fb5fbadb92b0ab1d2c2fa9f77f0b212890b491ddd7913b0d540a346b8','discokey:cd9e6272edc39d50afc27080316aae91de105df7e4f09b27a4301f219217b460','srv-30','node078',23,'cli',NULL,NULL,'2025-03-31 18:38:46.90455425+02:00',NULL,'{"fake":"data"}','["[8dc1:48a1:2e5e:8c45:131e:9d7a:2d85:61ef]:1654","[dbf5:5aac:6a5a:f73c:a62e:69bc:c227:1180]:49484","200.106.54.69:19053","145.76.224.52:32069"]','2025-02-14 18:03:28.401774063+01:00','2025-03-31 18:38:47.149620162+02:00',NULL,'100.64.0.70','fd7a:115c:a1e0::46');
INSERT INTO nodes VALUES(79,'mkey:31e2f2e88d77ea01fc3f7869f672d015dc76b0a12b46829aa1b344fdc0827aae','nodekey:124fde6d53a012efc7626136b2c32df231f87c92aff2c4fe9596c4d79a0c0db1','discokey:796b737943327a0b25ce400e70a628eca55747e61546e6a8a3c84ae8d0a7b491','laptop-17','node079',25,'cli',NULL,NULL,'2025-02-24 18:37:03.584752527+01:00',NULL,'{"fake":"data"}','["61.30.74.244:1071","[4587:514f:e01d:e13b:768f:6402:862c:f470]:52999","105.225.1.28:57634","78.215.20.31:28892","4.11.131.129:50580","61.47.47.240:57553"]','2025-02-15 12:49:11.523904469+01:00','2025-02-24 18:37:03.584913585+01:00',NULL,'100.64.0.71','fd7a:115c:a1e0::47');
INSERT INTO nodes VALUES(80,'mkey:f9c7fccb40e5f809fce3149d8643d3b5459b882837487e19da72f0ec8e9b36c4','nodekey:1fff3539a6acf0e9b8cbb0427824179491ac293b7c0092cd320ff48071eff4a5','discokey:7067ea828bcc4e1e5ee41152c79ea50cdf583a5aca0115cdfe9e2161271e9807','desktop-82','node080',23,'cli',NULL,NULL,'2025-03-31 18:39:08.617771904+02:00',NULL,'{"fake":"data"}','["207.204.17.116:6826","121.94.132.177:17160","[35d1:7781:52e5:8550:72a6:3a02:104e:9380]:34711"]','2025-02-15 21:12:05.434304787+01:00','2025-03-31 18:39:08.727340814+02:00',NULL,'100.64.0.72','fd7a:115c:a1e0::48');
INSERT INTO nodes VALUES(81,'mkey:d089a5917a4b469009a451f834bd93870888f18afd170ef9d7558abcbf7f56e6','nodekey:5c55b563d9796cf68da579cf8fb195a3bfb0d1e80f81d74359ca65b5367b1638','discokey:41a15fa481076c161c6b7bf8120e90ad4e73f3300d711eb81e31b7301d512b83','web-42','node081',23,'cli',NULL,NULL,'2025-03-31 18:38:46.169280974+02:00',NULL,'{"fake":"data"}','["[2b88:a0fa:7305:9a44:6c1f:65d9:5ece:8f1c]:27764","[bd66:349c:a29a:4c05:b3ab:dd92:749c:434e]:27566","69.37.34.188:32687","172.43.25.248:19211"]','2025-02-17 16:05:05.921277876+01:00','2025-03-31 18:38:47.081362641+02:00',NULL,'100.64.0.73','fd7a:115c:a1e0::49');
INSERT INTO nodes VALUES(82,'mkey:9c853f04d1bfe9d438a8719160628329d7bbe56df8dcdb74fbdc4a6570af701b','nodekey:b4a22d5a8c9fad2e1fcc6b5f1693528974a38859285fd67b64bab7e6d3122710','discokey:8cc24fcbe0e6a7fdf36a0cedcbbdc4295194c821cac4a30d5c449cdc4d8723ee','srv-08','node082',23,'cli',NULL,NULL,'2025-04-05 07:04:44.68803226+02:00',NULL,'{"fake":"data"}','["[3c46:906c:ac3:7713:f36c:eef7:3764:7844]:57048","59.217.231.119:10496","[be71:9d1a:fa93:361b:4d94:fbdf:bb45:5421]:15076","[3238:dbe9:f89d:91e1:6338:993d:3e76:8561]:32795"]','2025-02-28 09:21:23.143225002+01:00','2025-04-05 07:04:44.688660094+02:00',NULL,'100.64.0.69','fd7a:115c:a1e0::45');
INSERT INTO nodes VALUES(83,'mkey:0ec54480d16ae9c954b21852540a7e669caf0b1df2ebc3192353058b191d4732','nodekey:981dfbabf258ac252cb4470040b425696d40c15ae9bd70cdbb6541ff47a4f99a','discokey:f77ff65615d1ec4afefd1accd883bfdcad5daf3810a72604fc0a95df2214a1e3','srv-36','node083',26,'cli',NULL,NULL,'2025-04-05 07:53:06.561831453+02:00',NULL,'{"fake":"data"}','["195.8.172.201:53059","[ed13:96e3:daf2:3df4:c6f:3b8d:af9f:eb5b]:10689"]','2025-03-18 09:09:50.849674955+01:00','2025-04-05 07:53:06.562851054+02:00',NULL,'100.64.0.74','fd7a:115c:a1e0::4a');
INSERT INTO nodes VALUES(84,'mkey:911d47d2e7518087e6e43d47074cb58739880e9dfd3912467b8b7d618458f93f','nodekey:87e6089fc13207cdb034bb83d3361be25faca6d35a4a12c1d195d7b5607d726a','discokey:172772172f52d6a3033debe69654f8c9fbd823a7876e36cd890a5a2990eda884','laptop-89','node084',23,'cli',NULL,NULL,'2025-04-01 19:26:08.705667279+02:00',NULL,'{"fake":"data"}','["172.116.24.79:64278","26.140.212.195:18107","[8ea5:bf8c:6205:76f0:a23e:8ac8:f856:f091]:26017","25.10.147.197:36132"]','2025-03-25 10:04:37.147174393+01:00','2025-04-01 19:26:08.706193488+02:00',NULL,'100.64.0.75','fd7a:115c:a1e0::4b');
INSERT INTO nodes VALUES(85,'mkey:0d5a6cbee59cef0dfb24e410466777da40ac48b308d5387c7118371da4dd66c0','nodekey:a3c2435fbaddbe915301fd294f6f7d787f18ea7938b468d0dbc2373585c6e153','discokey:3f4fad81a23a9b13308d6b2e84a217c00a73088d2a31ce5eb15be9192dc7aebb','laptop-35','node085',23,'cli',NULL,NULL,'2025-04-01 23:16:37.04412104+02:00',NULL,'{"fake":"data"}','["[f54b:3eec:1a3d:2bec:d025:cfbb:b951:6e47]:10751","169.51.234.97:16861","16.142.13.19:36771","[ad8a:a3fa:8d4d:c659:5e32:45dd:d95f:abc8]:43118"]','2025-03-25 10:08:52.471661925+01:00','2025-04-01 23:16:37.044513666+02:00',NULL,'100.64.0.76','fd7a:115c:a1e0::4c');
INSERT INTO nodes VALUES(86,'mkey:6e91fa8345d4795f579da2e0c8672463bfdc4035eb5f31fd0a511722e6986ca4','nodekey:0064d45bc62c00ddf68241741547493ef6a6d0f4ead224d963500ea42fb90ae4','discokey:3d63df2a68aa3ac1fd33e0bb8eabc59a5f7f03eec4c8d1e2e3693f69f2fe90ee','laptop-84','node086',27,'cli',NULL,NULL,'2025-04-03 21:56:30.423789526+02:00',NULL,'{"fake":"data"}','["36.19.57.186:49366","[cf88:94d3:5835:2356:c48a:6f91:dafc:9c5d]:24503","[83c:82b4:9941:dec8:30fa:4c7f:de12:fd5c]:60355"]','2025-03-26 10:24:31.473595709+01:00','2025-04-03 21:56:30.424301457+02:00',NULL,'100.64.0.77','fd7a:115c:a1e0::4d');
INSERT INTO nodes VALUES(87,'mkey:ecdf9b138473ce9d2b2b4861bf2a358bfda62032572e1474a9726f45f24e3702','nodekey:69ad63020724d64042e91204bbd382fe4f8e838d2eca106709dc2b61592462a9','discokey:f574c20bb2f8558f787798b4b89918e5bbfc8d3001ef41ab155d8adb4ceda4e0','lt-76','node087',27,'cli',NULL,NULL,'2025-04-05 06:05:53.807723942+02:00',NULL,'{"fake":"data"}','["8.73.3.103:62847","[fd18:384b:ef76:f4b7:6983:bd4e:70af:ce35]:42618","7.111.70.18:4634","85.240.97.0:21327"]','2025-03-26 14:30:57.179694234+01:00','2025-04-05 06:05:53.808074341+02:00',NULL,'100.64.0.78','fd7a:115c:a1e0::4e');
INSERT INTO nodes VALUES(88,'mkey:a4a50964463b8a2bb0778291c014c4ffc1de4b45140278723879e3afd7ad3b53','nodekey:7befe9b0bd2e08bc976c08e2b199069d0fc42d0ea8dbb346ccd706f1771c6d74','discokey:fc3a7797bd83d5c4109b33fb7c52cd4fca772e91d31787f7bb09ddf9d5d8df17','db-62','node088',27,'cli',NULL,NULL,'2025-04-05 06:45:42.584225511+02:00',NULL,'{"fake":"data"}','["48.12.29.120:59556","146.247.211.102:6983","212.18.134.205:41528","190.153.32.51:23708","33.50.209.62:29699"]','2025-03-26 14:37:55.198097806+01:00','2025-04-05 06:45:42.585458518+02:00',NULL,'100.64.0.79','fd7a:115c:a1e0::4f');
INSERT INTO nodes VALUES(89,'mkey:7c3f129f0eb0f541a270bd8d4236991cbcfc984d5fbc422e0f227401b3e33fcb','nodekey:9e8eac7d23ec974e4170fb5437c80c773c8f93b5d99fa479f0a7a92660423f4d','discokey:436409c6a1b9a7e50e2e7b7a07861f6d29f1d1a1f0934f8145d2d7a959b0daeb','srv-64','node089',28,'cli',NULL,NULL,'2025-04-03 21:12:36.172240418+02:00',NULL,'{"fake":"data"}','["165.160.173.41:62002","[d35d:30be:3c0a:c5f2:40ca:40f4:9b64:de92]:54562","[e40f:e89b:a9f5:d5cd:d553:b6:17f3:3d88]:21519","102.217.166.61:13721"]','2025-03-31 18:34:22.574460539+02:00','2025-04-03 21:12:36.172550446+02:00',NULL,'100.64.0.80','fd7a:115c:a1e0::50');
INSERT INTO nodes VALUES(90,'mkey:3aedbb5b71c6de73eeb59138b920c4c5a62debd4f738d4856115412e5f8f9318','nodekey:d7d143dc5680d770fe0ba2273eb3b01004593c2b187edafde8f89709de3d0078','discokey:7c45bed52e4d175be90c88784a39adcd765627238691aa9963191e0acef41624','srv-73','node090',27,'cli',NULL,NULL,'2025-04-05 07:31:24.445741627+02:00',NULL,'{"fake":"data"}','["[bf19:5560:9254:d556:e834:573e:63a8:92f1]:57176","[48b1:5eba:7dda:918d:19ac:f3da:239a:72f8]:6265","104.240.254.212:44730"]','2025-04-03 17:52:02.130025013+02:00','2025-04-05 07:31:24.473509723+02:00',NULL,'100.64.0.81','fd7a:115c:a1e0::51');
CREATE TABLE `policies` (`id` integer PRIMARY KEY AUTOINCREMENT,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`data` text);
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 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-02-06 17:43:41.935399542+01:00',NULL,'user021','','',NULL,'','');
INSERT INTO users VALUES(22,'2025-02-03 14:10:50.491924701+01:00','2025-02-03 14:10:50.491924701+01:00',NULL,'user022','','',NULL,'','');
INSERT INTO users VALUES(23,'2025-02-14 16:58:30.250289644+01:00','2025-02-14 16:58:30.250289644+01:00',NULL,'user023','','',NULL,'','');
INSERT INTO users VALUES(25,'2025-02-15 12:48:14.650995528+01:00','2025-02-15 12:48:14.650995528+01:00',NULL,'user025','','',NULL,'','');
INSERT INTO users VALUES(26,'2025-03-18 09:09:00.456523573+01:00','2025-03-18 09:09:00.456523573+01:00',NULL,'user026','','',NULL,'','');
INSERT INTO users VALUES(27,'2025-03-26 10:23:51.960113834+01:00','2025-03-26 10:23:51.960113834+01:00',NULL,'user027','','',NULL,'','');
INSERT INTO users VALUES(28,'2025-03-31 18:25:26.535133091+02:00','2025-03-31 18:25:26.535133091+02:00',NULL,'user028','','',NULL,'','');
CREATE UNIQUE INDEX `idx_api_keys_prefix` ON `api_keys`(`prefix`);
CREATE INDEX `idx_policies_deleted_at` ON `policies`(`deleted_at`);
CREATE INDEX `idx_routes_deleted_at` ON `routes`(`deleted_at`);
CREATE INDEX `idx_users_deleted_at` ON `users`(`deleted_at`);
COMMIT;
Reference in New Issue View Git Blame Copy Permalink