mirror of
https://github.com/juanfont/headscale.git
synced 2025-08-11 21:47:34 +00:00
147 lines
63 KiB
SQL
147 lines
63 KiB
SQL
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');
|
|
INSERT INTO migrations VALUES('202502131714');
|
|
INSERT INTO migrations VALUES('202502171819');
|
|
INSERT INTO migrations VALUES('202505091439');
|
|
INSERT INTO migrations VALUES('202505141324');
|
|
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, `approved_routes` 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:38315e39aa0f0ac09b49850ace14a9bffab27d4258daf52bedfcca5d3045cd0c','nodekey:5b55d8314717137fc190e4b42811f5eff1241cf32cd24d768c1e710962884db4','discokey:ac65232fe17445944990c9532faec80c27081443997d02b1d3586e7b481261b3','laptop-74','node001',2,'cli',NULL,NULL,'2025-06-22 07:21:58.271483603+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[bab2:a8b9:e00d:9655:f397:9a5e:c6bb:2300]:9564","[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"]','2023-05-17 19:38:13.531518257+02:00','2025-06-22 07:21:58.271647152+02:00',NULL,'100.64.0.1','fd7a:115c:a1e0::1',NULL);
|
|
INSERT INTO nodes VALUES(2,'mkey:1e274f40556282a5bbab04b6754985233ccdf971b663e5b38fc027035e833e9a','nodekey:5b16c7e14191ca2e57eccd86ec636db605fa5dc2c8856be5fa7f9b087cf24890','discokey:5fd2f116700fd48ce06e35e8dd11c847ccd7694e01ec4b3f6ef25f67c14ee197','email-21','node002',1,'cli',NULL,NULL,'2025-04-17 20:26:48.332385788+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5aae:55d1:7b5d:628d:bc07:b3e0:eca2:836d]:13912","[5583:8a0e:1564:ac5b:98ab:59a3:126:cba2]: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"]','2023-05-18 10:09:21.757289398+02:00','2025-04-17 20:26:49.018604197+02:00',NULL,'100.64.0.2','fd7a:115c:a1e0::2',NULL);
|
|
INSERT INTO nodes VALUES(3,'mkey:5b57ab9712ce9587cd887a650ba629d2aeceb57d83a0bcadf9fa19a33e141a07','nodekey:788dce6f52985afca7b36ad6961dd93b7cd6d102574e243c1f39b14804b370a9','discokey:8b7c85ead8a9e7225cda4c5d1975dc426aefe919b4153f4653228e325c015bfb','desktop-51','node003',3,'authkey','[]',1,'2025-06-20 23:54:25.334614243+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[fdbe:7908:805e:6c8f:47c2:2c87:b1c4:44]:48470","188.237.187.170:7622"]','2023-05-19 07:09:21.399903526+02:00','2025-06-20 23:54:25.335360998+02:00',NULL,'100.64.0.3','fd7a:115c:a1e0::3',NULL);
|
|
INSERT INTO nodes VALUES(4,'mkey:538f91fe9e485697ce13f9444ee0dadf2aaaed712fdfa03ba102113c6505db37','nodekey:1936bdc567d6758b11b2cc06ea7ff74bb933a44421fb17323965d5a402e39783','discokey:e8b762a384d644175f3b4e4fd36867b2c435e03eb0bf6b9e7ebd4f0ce83c13ef','lt-57','node004',4,'cli',NULL,NULL,'2025-06-28 12:23:20.734405211+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f6d5:e904:28e7:a5a4:12a3:96d8:9391:b22c]:37336","113.59.7.205:48432"]','2023-06-10 09:31:51.940506933+02:00','2025-06-28 12:23:20.735270748+02:00',NULL,'100.64.0.4','fd7a:115c:a1e0::4',NULL);
|
|
INSERT INTO nodes VALUES(5,'mkey:12afa721b0310fd9cf7501a19e5f23a2d33c87f989a9b0233bc09e8eb9e5eaa2','nodekey:83e8f99465cfd0ef79190bfb341bb742b39d9ddd7cfeab237153b58858a2fed2','discokey:d4fdc314c7b73e21589efef171f10158379ade1adbdc281482a62c6c20fc2ed8','lt-50','node005',4,'cli',NULL,NULL,'2025-06-28 12:20:57.298589096+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8105:c5c2:647f:e97e:85b7:577b:20b0:e4f]:16947","1.79.159.39:34092","[b12e:af88:3c55:41f8:5fba:2aa3:3248:15c1]:23643","186.84.191.82:2621","[c9d0:4e15:513a:171b:9911:f9a0:cccf:cd83]:24151"]','2023-06-11 13:56:42.694329408+02:00','2025-06-28 12:20:57.298996156+02:00',NULL,'100.64.0.5','fd7a:115c:a1e0::5',NULL);
|
|
INSERT INTO nodes VALUES(6,'mkey:229f561cff2994f922e02f0e286f6afacdb603245fa1a9c234ddb81f79674fd2','nodekey:edde606fce52c6196c994a72eb0f24ee4d4b8047d22e16dfef3f6531a8eaeb4f','discokey:2814289eb6e7bbd6093798f51410a2babab3f6a0d9ca105136d1ed387cb2ceb6','srv-66','node006',4,'cli',NULL,NULL,'2025-06-28 12:22:36.34542317+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["128.160.129.121:10590","48.173.178.104:58309","102.207.203.66:23963","153.152.90.188:59135","187.96.173.136:34092"]','2023-06-11 13:57:44.975695604+02:00','2025-06-28 12:22:36.364369698+02:00',NULL,'100.64.0.6','fd7a:115c:a1e0::6',NULL);
|
|
INSERT INTO nodes VALUES(7,'mkey:1634b8df4138ea0986578531f3be5bc398d11c83b226674d9b4b0d6daade5268','nodekey:9fa6e75dec8ed3e22a1f201fe661e67fe03de2583bb2e16ec1e97ec8b34a1ede','discokey:d4408013dd173b024ca49301592fd89d89260615f83253780b6d2c9af652f75d','web-46','node007',4,'cli',NULL,NULL,'2025-06-28 12:23:01.214171138+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["189.17.47.14:59833","[fa71:f70b:e65d:59b5:f599:8597:2bc9:56b6]:12277","[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"]','2023-06-11 14:16:56.951313537+02:00','2025-06-28 12:23:01.214662148+02:00',NULL,'100.64.0.7','fd7a:115c:a1e0::7',NULL);
|
|
INSERT INTO nodes VALUES(8,'mkey:c841efdb3731e5e826ebfecbcb50460016e7020a2b73ac202aaffc69f1260ca4','nodekey:9bbd9e2ed99a94a3284391ef3e949806578fe58f5c7e5f444cfd72e1068c7252','discokey:c763a94031000944026c3243e175a7dde5ec85ad92dffadf2ba365b8d6b4fdf4','email-75','node008',5,'cli',NULL,NULL,'2025-06-28 12:23:04.274230621+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[dd24:c2dc:debd:ad2f:ae50:cd15:9cd2:b296]:24266","[489b:6c59:1877:6215:ddc8:57f8:78dc:321c]:3025","77.213.161.20:47662"]','2023-06-11 19:59:30.401970393+02:00','2025-06-28 12:23:04.275091119+02:00',NULL,'100.64.0.8','fd7a:115c:a1e0::8',NULL);
|
|
INSERT INTO nodes VALUES(9,'mkey:b1e7fb42e35b0219c318fee0717c988ab851714c6f487bb26a184b8340920d87','nodekey:da9ddc2fadd4a47eefa8a541e9c3e316353a5650a26d30d258d60ee9fce9c899','discokey:c52edf1d688d73febbc73c977c723a638da546afcb3813de4e716c1e013404ba','lt-35','node009',6,'cli',NULL,NULL,'2025-06-22 06:38:00.485835142+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b9f9:eec0:d656:cd83:8595:46fc:b677:6ade]:17494","126.251.133.86:44347"]','2023-06-17 19:40:45.468789461+02:00','2025-06-22 06:38:00.486219076+02:00',NULL,'100.64.0.9','fd7a:115c:a1e0::9',NULL);
|
|
INSERT INTO nodes VALUES(10,'mkey:dc84e5b1cf58ec8f7200ec0a655c1d5843c520ea59aa7ddd111ad5c9beba9bd8','nodekey:3c06f5a6d7f267023044ab632892b51f5af1ce4d84f0739e88823bc22cda6c57','discokey:3c1aa008a7811012038cd6658b6f290b3d252074c47d23cf1766f878340a30bf','desktop-75','node010',6,'cli',NULL,NULL,'2025-06-24 15:38:08.972653514+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["187.166.20.165:11208","78.47.168.253:34957","[1d14:fb12:d0a0:ad7a:ad7d:496b:154a:7042]:33635","41.172.94.101:32111","223.204.123.230:38090"]','2023-06-20 11:18:35.905417341+02:00','2025-06-24 15:38:08.973364357+02:00',NULL,'100.64.0.10','fd7a:115c:a1e0::a',NULL);
|
|
INSERT INTO nodes VALUES(11,'mkey:94da5084f8fc1cfe7671b94a0d7ef767719bd0fed89f16bc2726728db4cd9d25','nodekey:e6527563ef7a2647b6c719e0c9c95c1ab2a2eeef7fbb3f46a108ee0fbca026f0','discokey:f76230afd20bfcce74fd0d689b35e82cab5bfdf4cd1530073e87b1acae513c2b','web-50','node011',7,'cli',NULL,NULL,'2025-06-27 16:44:35.818823257+02: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"]','2023-06-20 11:35:15.063855316+02:00','2025-06-27 16:44:35.81914126+02:00',NULL,'100.64.0.11','fd7a:115c:a1e0::b',NULL);
|
|
INSERT INTO nodes VALUES(12,'mkey:4d2ff8526b10e056a5d073d5640fd28002ca21b561c55407175712a98e37ada7','nodekey:a1835798e4fefbece3000abb9afdd3cb01e5a4eebafc1218ed627cde2175c1f1','discokey:24b8f6da3ef9e024e273918de8869fdfebc45f789d14c4a50a592cc27259f1c1','db-64','node012',5,'cli',NULL,NULL,'2025-06-28 12:22:57.399153574+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f1ba:2aea:9e9e:2802:ebb9:ba04:a564:7998]:52919","[ede2:462a:f99c:24c3:b1b5:8b97:abe2:3ddb]:65141","[dfe7:6f6b:a382:4fc:a3f6:eb9:9ebc:5798]:1474"]','2023-06-20 18:22:35.061914624+02:00','2025-06-28 12:22:57.400249031+02:00',NULL,'100.64.0.12','fd7a:115c:a1e0::c',NULL);
|
|
INSERT INTO nodes VALUES(18,'mkey:5e192b1b323439fcc3b921c4f523ce9b7cce867220bd092d23be2451ce93a4a5','nodekey:1452cb2c8f26c8988cd8d8ed42957c78e3ab922bdf9773978c853e4254e23fbb','discokey:b7b41dc5de1fdcc4bd609dc72f79d27269367dbf72ab73ab61e998aa31eac6a2','web-19','node018',9,'cli',NULL,NULL,'2025-06-27 21:23:45.610301586+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["60.5.210.145:1193","[5698:e318:b38c:4331:5152:c2df:743f:8ead]:34839","33.51.84.119:46756","[c844:704e:c3c0:e709:8f94:3564:1b4d:d2d9]:8357"]','2023-06-22 08:30:54.08720463+02:00','2025-06-27 21:23:45.610590171+02:00',NULL,'100.64.0.16','fd7a:115c:a1e0::10',NULL);
|
|
INSERT INTO nodes VALUES(20,'mkey:29574231af6530b1386ebe61550e3b14263500b7a70395e7b540a54ddc3fc777','nodekey:c1d6f11f1bdc2756be5836e556e2a8c10f50aed84c969662b67ebd942db8b8ce','discokey:dd5d8c17120e8560f2698b44d571ca1b0bb90e012dd34be9d31ae169d26ca344','laptop-98','node020',11,'cli',NULL,NULL,'2025-06-27 12:57:39.754859479+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["26.88.253.147:32968","[3138:83c6:ae09:a073:7888:71e0:494:3863]:59700","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"]','2023-07-10 12:40:34.838579199+02:00','2025-06-27 12:57:39.755061411+02:00',NULL,'100.64.0.14','fd7a:115c:a1e0::e',NULL);
|
|
INSERT INTO nodes VALUES(21,'mkey:94ebb2a00b9bbfe15d9a19a85409c5af01aa1b518319fbb394421888fa9fb7f9','nodekey:9109c5a733073fe487b72a328742f98f4e6e71748f1380562c46b1aaa2aa3f7e','discokey:1f11ce0393834879b2b9bd10b5fe034c85615ce94b30f67fe6153747b65653dc','laptop-07','node021',11,'cli','null',NULL,'2023-11-20 07:19:19.447470862+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["85.50.19.51:63246","[cff3:24ee:4692:f8a0:842b:c26b:e549:1f3a]:31064","207.187.74.99:12216","63.3.67.150:22907"]','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',NULL);
|
|
INSERT INTO nodes VALUES(22,'mkey:ec629722edab9383e9f816b50c2221486d52a55dd0735be575d20441b6e0c0cd','nodekey:8fc1644973c6614621da30be00b52f277c5e57f80032c681ac084354e7974665','discokey:286e95bbaca154ac900767ecd1f028764528a176cdc7c6e0bd3e0d2fff71207c','laptop-16','node022',6,'cli',NULL,NULL,'2025-06-26 08:55:27.018436146+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[fc33:9337:6f8c:253d:d87e:2d45:d618:5830]:33733","[6f37:bdc3:19c5:7d22:190e:a9d4:1ca1:e1cc]:59098","[4b06:6a05:94bd:4bca:676:93a4:2e20:b923]:23713","[68:80fa:7b30:3a0:d1fb:3e89:2c73:256b]:30308"]','2023-08-05 12:08:48.132161695+02:00','2025-06-26 08:55:27.028290638+02:00',NULL,'100.64.0.17','fd7a:115c:a1e0::11',NULL);
|
|
INSERT INTO nodes VALUES(23,'mkey:0323ca3e9858de1b53d0e3750e441d4da9a63f7e526be63b98430dbb51c66ebb','nodekey:8cd1023d1cdebd18f0f05d30852cde076e87cda3d6bc8a2785ef8f7ef37df099','discokey:0dd0075a712979849441f180da7e62bc73069050a4d25789e6f6afbcd4acb072','db-17','node023',12,'cli',NULL,NULL,'2025-06-08 16:50:57.344745353+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f371:f639:cf31:c836:19ec:b41f:f0cd:4487]:36912","27.211.232.205:36366","[e83e:63c5:7e37:2195:1ede:1e3b:f549:85d0]:56150","[92ea:991a:46a1:e1e6:6b82:659a:acc7:2272]:38018","93.129.193.97:13477"]','2023-12-15 08:05:56.592241745+01:00','2025-06-08 16:50:57.344868501+02:00',NULL,'100.64.0.18','fd7a:115c:a1e0::12',NULL);
|
|
INSERT INTO nodes VALUES(24,'mkey:f24720736968f27b5c78d9c7734a083464275b63b50662adfce0d0ad5304e4d3','nodekey:b254e68666635d7fdae5c391f6ce81b802e018cf431408646f604c5ca8dbdb8c','discokey:498b9f4eca5fb3725cec3570d70c768660e124d3e88a85949706bc7384109de6','db-59','node024',12,'cli',NULL,NULL,'2025-06-27 21:59:35.663631021+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["43.114.58.145:47143","[758f:df49:401f:abcb:57ff:c04b:79e6:8519]:62313","[2458:76c5:7d48:c26f:34e:1663:6911:ff6e]:22202","66.66.46.14:16686","[fd3e:93e:a9b5:2034:a98e:4ab1:6317:f13a]:46054"]','2023-12-15 11:14:36.765183054+01:00','2025-06-27 21:59:35.663899525+02:00',NULL,'100.64.0.19','fd7a:115c:a1e0::13',NULL);
|
|
INSERT INTO nodes VALUES(25,'mkey:f10b7f9f385e48dc99ec0944b8a04ec4d3e5613587419c134440121fa747ee75','nodekey:9559349d25dd3fa88b9595cb4ccebeeb4712338757a209e936afe37ec2643dbc','discokey:b9a07315c1eb2e074871feebe899bd2ecae64d98a8edf08883785130ef386728','laptop-25','node025',6,'cli',NULL,NULL,'2025-06-28 12:22:37.905312423+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9e60:1bb7:b542:2f50:269f:5ef:72b6:f4ba]:34677","159.52.2.200:7205","[5b7b:e424:ea77:aa8a:f835:d6bb:2e1f:52ea]:19152","[bb06:d322:7cec:426b:ef38:55d0:e7ce:95bc]:31597"]','2024-01-05 17:32:40.940566279+01:00','2025-06-28 12:22:37.906446459+02:00',NULL,'100.64.0.20','fd7a:115c:a1e0::14',NULL);
|
|
INSERT INTO nodes VALUES(26,'mkey:b07183e67f21f2d1b4f7f4eccb393c57257683629a59758f393c47b759f5da81','nodekey:b246eeb06f7aa31c0f92aa63a6836e6ecde5cccb73d0c03e103601a7cded51b6','discokey:30fbedab81413cac0736dcd7b473511905658726861a326a556bb2df80bf15b6','db-13','node026',6,'cli',NULL,NULL,'2025-06-28 12:23:07.762159769+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[769:97e6:7060:f428:ee55:f77:43a7:8d18]:61446","[630f:7c1f:d48b:ea66:23d7:1ab9:8bd1:10f3]:25600","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","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-06-28 12:23:07.762465037+02:00',NULL,'100.64.0.21','fd7a:115c:a1e0::15',NULL);
|
|
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',NULL);
|
|
INSERT INTO nodes VALUES(28,'mkey:08347db9fbe8e5e7a968c2ab9ddd1ff530ea98163c0bab7769316307545f4d46','nodekey:b6b03efd7deb52dbe0298708ea37400510ab7589b0b1787eac1a5f9b50aa7c80','discokey:6a0ab2f3329d9fe5f50c76f9f3f1d2e797574af93d823a511df57f45414f647e','srv-42','node028',7,'cli',NULL,NULL,'2025-06-23 17:14:19.693135279+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-06-23 17:14:19.693240007+02:00',NULL,'100.64.0.23','fd7a:115c:a1e0::17',NULL);
|
|
INSERT INTO nodes VALUES(29,'mkey:4a6e46330ccd4b3026337cdef37485c27592babda329107565c2a19d97253dcc','nodekey:17de47da1955a8a034788ae671c34fb10083568bf9e2f7494276cb2636065246','discokey:449f5f35a3507974cf03e3ac5c055d890de5122f57a7c2d84a0d3b324998607e','desktop-17','node029',7,'cli',NULL,NULL,'2025-06-27 14:00:54.026931428+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"]','2024-01-15 15:18:12.2871978+01:00','2025-06-27 14:00:54.02708773+02:00',NULL,'100.64.0.24','fd7a:115c:a1e0::18',NULL);
|
|
INSERT INTO nodes VALUES(30,'mkey:6472928030d718e6e2802fb3bceba7c14b4716d994be1b3562a1d03104fd37a9','nodekey:78bd59aba83429486e0ed2d50873211974650b2e2ad8f79dbc07c5d13d00c5a5','discokey:86ead449e1be5a300287e690fb9522ba4da3e5bdeb593d6261e4117708fe3ade','lt-82','node030',7,'cli','null',NULL,'2024-02-05 12:14:40.065688294+00: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","[963:536a:33e9:99fb:c204:d59c:29a8:ac18]:39005"]','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',NULL);
|
|
INSERT INTO nodes VALUES(31,'mkey:212b1ffd20a790e4f3fccc87a3f2d76a0c6149d4f2472f4eba76b40671f500af','nodekey:7b88563747cd8ad8526dd795e1dc858d84b4a9fabf3b009ad2ec5f6e7cecdfd6','discokey:660bda5c0e80a6bb18ed7d69dc80de790fc3f4a64bf5a6bebb69ce73ff3d6755','email-99','node031',7,'cli','null',NULL,'2024-02-22 08:35:27.098819037+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[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-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',NULL);
|
|
INSERT INTO nodes VALUES(32,'mkey:c4853fdd63bed5a98baaf74df437eff743f8a968fda613fdf1f2a111e7c1b100','nodekey:9fc3f32ce92ab7f8ab987f16258b11265037a47cd9a1a68ac0e07bd3c279c183','discokey:e52f22aa8e170b6a031e682b5ed6e5f790f2d6ae1eecb752de1b362a1cce7bd4','web-89','node032',7,'cli','null',NULL,'2024-04-09 13:59:43.37062537+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"]','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',NULL);
|
|
INSERT INTO nodes VALUES(33,'mkey:805d05918a94047740c914235c3c614042b05d18458f331ba0a46ee22d2187e6','nodekey:ebc009009bc015bc45f6499b04b7af9ff2ceff22c0f9676749b10c92f422a8ad','discokey:b6d83e1f6f0e86c3808cffb227cb6649bffcf5d4ba1596f6fd58f41b8b727133','db-70','node033',13,'cli',NULL,NULL,'2025-06-27 21:25:43.528971537+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a1ed:3568:9b48:6735:e553:a273:ea02:7271]:46613","90.225.231.207:5490","176.14.56.16:22127","[6224:9e4:5921:7fda:2437:15c6:a1b1:adf4]:15557"]','2024-02-03 16:33:26.706408143+01:00','2025-06-27 21:25:43.529881502+02:00',NULL,'100.64.0.28','fd7a:115c:a1e0::1c',NULL);
|
|
INSERT INTO nodes VALUES(34,'mkey:a404e578d3edd3e3d879e9f1946c859b5982c59f5e528bf6b987bd55de00b25b','nodekey:ad3013f116c370866fc9134b66999bb05e2dc10a8e2944230c3d9893c0a94c67','discokey:4fc6b881a4f170158e94336444d2cf0dea6a387b06dfc5fde08ed15d0f391c90','lt-08','node034',13,'cli',NULL,NULL,'2025-06-28 11:18:54.787303405+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["172.87.199.175:12624","71.151.27.31:51063","[f0d6:21dc:48f5:63f4:daff:a3c4:7d60:51ea]:17286"]','2024-02-03 16:42:32.683785672+01:00','2025-06-28 11:18:54.78775904+02:00',NULL,'100.64.0.29','fd7a:115c:a1e0::1d',NULL);
|
|
INSERT INTO nodes VALUES(35,'mkey:06f7b17a75e55b445cc41ad693565fd93da6f4d690a305f8e207d69b028bf859','nodekey:0f4a7ade77ba260d9b318ac18c6c1f2f0606af7edc29128a33984558b6a047b1','discokey:e3cc18eacc630c61f2a2ad6a4152ee2af4b93f0ff767122676a6e02f58f5f01e','lt-11','node035',5,'cli',NULL,NULL,'2025-06-28 09:59:51.80761163+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["94.107.22.1:45906","68.64.112.147:37449","175.25.134.28:16830"]','2024-02-03 16:51:52.010016072+01:00','2025-06-28 09:59:51.808121221+02:00',NULL,'100.64.0.30','fd7a:115c:a1e0::1e',NULL);
|
|
INSERT INTO nodes VALUES(36,'mkey:37a68d32b77a701b08f9aab0e407525cad61a79aae25512a47e834e67070caa4','nodekey:ac40d87508d60cd5ffa0c21bc569b85685667e418434e5d83cee138ef1552ac0','discokey:dc90acbf7b156f6a5dd8e2f0a36638a99994148f16138230269ced79ff89fb8b','db-19','node036',13,'cli','null',NULL,'2025-01-19 14:01:48.956567669+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["68.209.122.217:6048","[edcb:62c0:3e8f:3a8c:93dd:1672:b477:ce1a]:18240","[bbb7:5b4d:218d:55ff:ac9b:1fb6:c933:9a55]:63943","18.156.132.228:63356","122.50.5.12:7674","[a641:3f06:63bf:b716:4658:1e5b:ac6f:e14]:13490","197.206.147.31:58506"]','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',NULL);
|
|
INSERT INTO nodes VALUES(37,'mkey:2a302116eb66f119bc13369abf20be603cc433e83e4607480a6731e38ba9e8bf','nodekey:9f97afa1f234c491e12dbf3e613e4f4525d64aaa90cd40dba2919e8d315cbd27','discokey:7470aa5ff096df380fc115e26326342355093e00a5b1c7d9e6a6e91228bd2e19','srv-81','node037',5,'cli',NULL,NULL,'2025-06-28 12:21:12.129795624+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5071:881b:75ae:d129:45ec:cfba:1a25:63df]:48282","[f94b:a947:7d11:b9f2:7758:640d:478a:1da8]:26194","[6b8d:8778:d67a:4cb3:1c6:1986:f223:15a9]:12844","[e1b5:d8f1:23f0:93f:bf72:7b6a:5925:353c]:52615","[3ec9:71d2:c2a5:cc2f:e2e8:5740:7b01:4a9]:29794","[4b64:fce2:293e:a24a:9995:b0fa:ff27:5401]:58695","[5eb0:a5cb:e9da:1552:e478:f921:c3d6:ff40]:57647","[8c40:dd59:c31d:dd18:321:58a:11fa:d85a]:43064","168.4.78.117:48474","90.45.218.0:29326"]','2024-02-27 12:14:40.452601042+01:00','2025-06-28 12:21:12.130426228+02:00',NULL,'100.64.0.32','fd7a:115c:a1e0::20',NULL);
|
|
INSERT INTO nodes VALUES(38,'mkey:0cb7a61e162c150a2397b17feaa98b86ecd8eb2cb899f406f9cffc5f94bed186','nodekey:aaf8f2337e0809d347caec27b07a8a5ffbb41110569b50a386ed852b61a4b1d1','discokey:b8c6a5277eeb27573ce8647557540773904cd4559a9b2fc38c8ed0fe0c9d3b01','srv-58','node038',6,'cli',NULL,NULL,'2025-06-28 12:22:38.364224551+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["189.185.249.112:45061","117.137.197.148:33075","165.145.180.67:23334"]','2024-05-22 08:08:16.045350656+02:00','2025-06-28 12:22:38.364913686+02:00',NULL,'100.64.0.33','fd7a:115c:a1e0::21',NULL);
|
|
INSERT INTO nodes VALUES(42,'mkey:08032558a6f70b2a3125f92860e4e3261cb87d9fa5507ad75b00d14d506e42ed','nodekey:d7a05dda88f80df694090cfdd8c5e0fccead6014378741fdc8166bce304eac7b','discokey:adecd0e23ec16e2ad50c7df1d855cc7d2ac016adf103f4d9373ab4d9da6d38dc','lt-88','node042',14,'cli',NULL,NULL,'2025-06-06 20:55:32.708129231+02: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-07-03 11:12:29.418355657+02:00','2025-06-06 20:55:32.710128529+02:00',NULL,'100.64.0.37','fd7a:115c:a1e0::25',NULL);
|
|
INSERT INTO nodes VALUES(43,'mkey:33e764ae40265089c5e7dbfc8571aa23bb390fc7e1e8bd2f3e0cd6891c308214','nodekey:c444c9ff652ba29181a5f7fdf991f91f704e6698237ee18b0649c81879ec932f','discokey:2e1db3a1eea266673acf7826aa44b5aa6fdd23c6ba41330562b37c5a523ba358','laptop-81','node043',14,'cli',NULL,NULL,'2025-06-06 20:55:32.888930994+02: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","[5ea4:3410:eaa2:9da:b8d:b61a:2d9d:edaa]:3526","209.107.206.184:46974"]','2024-07-03 14:48:50.263910778+02:00','2025-06-06 20:55:32.892202297+02:00',NULL,'100.64.0.34','fd7a:115c:a1e0::22',NULL);
|
|
INSERT INTO nodes VALUES(44,'mkey:1099debb0ba187ef1f43f001c75abc118eaf017bf3bd6b48ca333fb046b98de9','nodekey:d49ef9ad4a7ecbdabcd24cae92d9ac32fbb765467cbc20abe61b4bda6ef15f1f','discokey:9f2faf39514eccb7f3d7d66ebcaf804474f75284d8b1aedbf97aee6ccdf47ed5','laptop-84','node044',14,'cli',NULL,NULL,'2025-06-06 20:55:32.852055717+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[183d:f2d6:b80:36c5:318e:64e9:7f4a:b389]:12440","169.173.198.12:15274","[e5df:1889:6ac5:7d21:4dfd:614b:7eb9:d93c]:792","119.123.40.237:58615","[415:97d8:4ecb:2a7d:14ae:64f3:7a01:471f]:15771"]','2024-07-03 15:23:48.066044194+02:00','2025-06-06 20:55:32.876004334+02:00',NULL,'100.64.0.35','fd7a:115c:a1e0::23',NULL);
|
|
INSERT INTO nodes VALUES(45,'mkey:29eedea8083105a21470a51112b2486ae4c79221e2b6b17e4c3c84f965013513','nodekey:b3249157ebc705f134a366e28beb2d7646a40bc4171bb6d6fece1e750c85379b','discokey:64cb6eaee39eca7e3ad7f1225c216bf2826a8a951b91a631cfacf3b5ec99c2db','web-31','node045',14,'cli',NULL,NULL,'2025-06-06 20:55:32.853701621+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["14.153.231.75:19825","[acd8:3779:7b6c:3a71:c15a:e323:a721:c9a7]:63377","[6816:3377:edb0:3f8e:a65b:bd60:461b:ceb]:24642","147.3.7.139:46940","[7526:4960:73a9:911a:1fbf:92bf:1219:a6bf]:25440"]','2024-07-03 15:54:01.706018896+02:00','2025-06-06 20:55:32.862645337+02:00',NULL,'100.64.0.36','fd7a:115c:a1e0::24',NULL);
|
|
INSERT INTO nodes VALUES(46,'mkey:8c948629fd6a1b66977db7f1c6f11c30f1ef99da371f2f88f6bb77d79a3fd157','nodekey:af7e300b7119ffd77488c76a756660fec6ce7b4036c9e6c5159e1dca503dbb3a','discokey:a266b60014f0798c0e31f9e11ad5eb09082bd1178e3a2a0d5791801c1f2fc415','srv-47','node046',14,'cli',NULL,NULL,'2025-06-06 20:55:32.644737833+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["57.87.213.13:62573","160.29.16.50:26152","217.233.117.213:34230"]','2024-07-03 19:38:07.783745318+02:00','2025-06-06 20:55:32.659793776+02:00',NULL,'100.64.0.38','fd7a:115c:a1e0::26',NULL);
|
|
INSERT INTO nodes VALUES(47,'mkey:bfd4f59c7df7a9f7c3ed7736b35aff1895318a2ba2de7dbeb8c5911a9fdab6c2','nodekey:18f4f5a2905ba4ddd20ab6fc31945f78cc312cf8b453a544cc6c5d7456a1f8e0','discokey:dc5f0a3318228e929379c1b82984b0b955988131f3cf1522f547680420acf39d','web-50','node047',14,'cli',NULL,NULL,'2025-06-06 20:55:32.624765906+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["55.20.245.10:37304","98.38.29.194:12660"]','2024-07-04 10:38:08.344092869+02:00','2025-06-06 20:55:32.642819932+02:00',NULL,'100.64.0.39','fd7a:115c:a1e0::27',NULL);
|
|
INSERT INTO nodes VALUES(48,'mkey:5bbb77092f21b4835b0ae1af3871fc48445819c9b6e5ff9c46ad4a623b662ae8','nodekey:191c7cc089ee160c07b63e2b6b5ef0701d76d914009420baddad9bfce13e3f2d','discokey:712cadffd23f106abeea82ae70bbae8e06c2a58f3db617afd0d149b3012c64fb','web-61','node048',15,'cli','null',NULL,'2024-10-20 13:53:33.831192385+02: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","193.95.63.195:40587","166.176.60.55:23674","[33c0:859c:4a78:8bdb:359e:31e4:1e71:7e39]:50383","[3aab:52a2:b9d3:1816:5627:336:6c60:57d7]:13486"]','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',NULL);
|
|
INSERT INTO nodes VALUES(49,'mkey:0aeb63f409c65f5e3fb88049d610c3b58476d4d9ffa41502e928b526888f937b','nodekey:39c2ec4b5e9e4ffabfbf2b0e77e12d71b281e75945e80ab2318b600cb7a2794a','discokey:36e41b77ca844d02104807b6ad0eabe3b14252fe06b0e4c3ee6d0ecb51abbbeb','lt-93','node049',16,'cli','null',NULL,'2024-09-19 09:07:18.28136023+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4451:be15:8bc9:696f:fced:a453:f30:99db]:40973","[ff9c:d2f4:d4ae:92b3:1da6:15b:cb40:b9a7]:10893","[76ef:e160:820:d8ed:de32:25f4:7874:de94]:23150"]','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',NULL);
|
|
INSERT INTO nodes VALUES(50,'mkey:f368047f0ade97d2e85be32da245e474ebdceb640b35947a5403ea4ec17dba20','nodekey:fb33e7e55c17bc7ddfc809cf37470a044cbdae049633f8e2f77009205685a318','discokey:17b46a4dd1b090347f47ff0f980521faf4cab279f97133bc03cbe0f1750187e3','desktop-00','node050',10,'cli','null',NULL,'2024-08-07 10:10:06.595550455+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["220.80.110.172:44100","[2523:fe65:400:15c0:a5a1:b955:1454:70c7]:54632","[a8a7:bda:7d93:b992:48e5:f2c1:91e2:54c6]:19368","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"]','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',NULL);
|
|
INSERT INTO nodes VALUES(51,'mkey:735ea22d4d96ae83e77aa73b97a50a1b34636cd05384bad6a9b9256ca20d7290','nodekey:7fa08d819358ea2114540aca2eb712f6a85f7610e888e9e34d1e40e2900114cc','discokey:330eb26ff5d9403bd755091b57a42aedb2c3b46583576ca6d979f9a703234cd2','web-65','node051',14,'cli',NULL,NULL,'2025-06-06 20:55:30.776282094+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c5c6:6d5f:96bc:5d51:16c2:9fb8:d390:bea8]:54983","[2300:cb9f:25a7:8450:3dd7:1ed5:6362:63d0]:47837"]','2024-08-07 14:19:31.156780417+02:00','2025-06-06 20:55:30.792088043+02:00',NULL,'100.64.0.43','fd7a:115c:a1e0::2b',NULL);
|
|
INSERT INTO nodes VALUES(52,'mkey:a1c649017ddbb4dcd4554acf5286329de306c9053b6ba103684683bc4b825b9c','nodekey:2676428ddde9161b1de90dc62ac99f436c3ac780e43719bed6313c680743ac06','discokey:f16bd3d12b57ee652bf20e358a184111d2be864bee16195053b68d21b5357384','email-01','node052',17,'cli','null',NULL,'2024-12-25 17:27:58.515851096+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[1c82:2ff1:f85f:9c4c:9bef:6197:b9b0:5e38]:29991","[2fd4:63f:f9f:ec1d:1ad9:621a:4155:8a19]:46781","[32:2239:56ed:558:32d5:7b03:dcdb:e5d0]:53865"]','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',NULL);
|
|
INSERT INTO nodes VALUES(53,'mkey:3b2b622721b0c64d215283349a2df3b86a2a4e107b92e6ca4450204061ce53d4','nodekey:0e64072dafa5f9e49266b41fc4b21ff7d287be8f4e5f2b6c395487d632f1cf3f','discokey:2f77bb8cbeb426bcded5ad9fc6da44b0b76b8d6759f10a8db28e634290760ee7','srv-65','node053',17,'cli',NULL,NULL,'2025-06-28 12:20:35.189820653+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[977f:5596:9908:14e0:8983:810e:9e9f:93d]:3616","[911d:ef36:743c:8085:8a4c:a5c8:9f35:27fc]:23538"]','2024-10-28 10:04:50.084492941+01:00','2025-06-28 12:20:35.190401013+02:00',NULL,'100.64.0.44','fd7a:115c:a1e0::2c',NULL);
|
|
INSERT INTO nodes VALUES(54,'mkey:a996b2df08089ba5a36bf00f4f0a337aa876a58f3214114862f76cf570c317f1','nodekey:241d83b165073dfebc00ef12480032b008e7d305957fe3e7b14938125b7fd788','discokey:1c36d23ccdc5d359c1f4b0626c27e0df4be0b8165553005771b638effc36249a','lt-94','node054',14,'cli',NULL,NULL,'2025-06-06 20:55:32.691473004+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"]','2024-12-09 17:10:55.363593066+01:00','2025-06-06 20:55:32.700659203+02:00',NULL,'100.64.0.46','fd7a:115c:a1e0::2e',NULL);
|
|
INSERT INTO nodes VALUES(55,'mkey:ad8d2836fc3e281ea45c14de854da61abc9ab333e94ebe3de2435e9c4c7f5ea0','nodekey:30b87abf366b736d7e782d74536382f1853f9de785d2bd532b63c5efb3d7c6cc','discokey:2ecc9071b240d067246a96ba329af5d3385cf430708f93a8aaa553e49ae225ac','web-20','node055',18,'cli',NULL,NULL,'2025-06-23 17:13:34.971389477+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["172.87.149.191:59171","[1fae:4025:aab6:7bd4:33bb:9306:1e8f:991b]:50694"]','2024-12-10 13:56:39.287449662+01:00','2025-06-23 17:16:24.577468282+02:00',NULL,'100.64.0.47','fd7a:115c:a1e0::2f',NULL);
|
|
INSERT INTO nodes VALUES(56,'mkey:7ad9c5af6111cc3286256127e6b6a939f1fb87e08c9018bd7bd8671c4b9cefc2','nodekey:84fec35781c2032d05c7e8524bada9f7242165e9ab5df5d66f993266cc6f090d','discokey:ad9158862b9c58848c37b519543415166938b6be3dfe3a8463842ebbd09eb00e','srv-14','node056',19,'cli',NULL,NULL,'2025-06-28 12:22:44.430647515+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e669:9684:b8bf:9a64:8ec7:bec:6369:4412]:16090","23.0.29.75:24889"]','2024-12-17 14:58:39.429211911+01:00','2025-06-28 12:22:44.431119935+02:00',NULL,'100.64.0.48','fd7a:115c:a1e0::30',NULL);
|
|
INSERT INTO nodes VALUES(57,'mkey:ae8c967065558f9f03a95979d2181b3aa2b3537c25a894046a65554beaf553e7','nodekey:bc9cbaeb5cd70e708b5a23565ffb1fb6e1c18f35b1861083196209dcc1e0e20c','discokey:f8647d1a8ab876931f49a8abf785d429f7f21bd1fe6317528bfbf78e38d7aafe','db-73','node057',20,'cli',NULL,NULL,'2025-06-28 12:22:11.086950088+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[caa3:7372:5199:2416:357:7b48:3127:85f1]:21026","[e2a5:db96:e7e3:6335:8bdc:90b4:40ff:920d]:28128","163.106.192.242:30271","[7d2a:9d5:1fbb:54a7:fe7a:bc40:5ea2:ca20]:3534","[f630:8bb5:a4ff:95b1:6d95:decb:a5d2:373b]:42456","[6cc8:4fca:c46e:ed25:e9ef:43e:f0ea:121a]:60965"]','2024-12-17 15:17:14.26936913+01:00','2025-06-28 12:22:11.087909892+02:00',NULL,'100.64.0.49','fd7a:115c:a1e0::31',NULL);
|
|
INSERT INTO nodes VALUES(58,'mkey:5bb86c2f730c0b247b01634f73a4f67a19bf271de3ee39cf13f879db671da5b1','nodekey:64f016a04093cc91f7d2ca3639a07a17ae8f95f246a7ad759141d598136bd060','discokey:066b4845ec135e6251d6ef6119c832b46e2bc310332d3ea836c5f39896538b38','lt-49','node058',12,'cli',NULL,NULL,'2025-01-25 18:41:03.881898904+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["128.102.246.147:15968","[d0d3:beb7:361b:71d1:af88:4105:6b5f:343e]:14598","155.200.222.111:64410"]','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',NULL);
|
|
INSERT INTO nodes VALUES(59,'mkey:86289561abe2eff47dd9c23c0bd1e076c0ff7b4306569d6c2ab63aa2ae5096a1','nodekey:1ac8d1434fe581284ae297cc9063685fc2afd854c45ed3cf0809c95b6ecbc037','discokey:44567ca0878c3505bb078f76a993fe3b381f17325a3c0f3df1125bba5eca1a92','desktop-26','node059',21,'cli',NULL,NULL,'2025-06-06 20:55:38.816110199+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9875:c11c:289c:3b14:dc40:d7af:6:8372]:51751","125.170.153.154:21718","68.3.248.154:42390","[f621:b605:bd04:a964:160c:314a:141a:2e8d]:58563"]','2025-01-29 11:59:27.291048957+01:00','2025-06-06 20:55:38.890138267+02:00',NULL,'100.64.0.54','fd7a:115c:a1e0::36',NULL);
|
|
INSERT INTO nodes VALUES(60,'mkey:06bd440cb68a2856dcab4ae09ba4c4e7969b78a99a1d06bbacebc9d1fba037b7','nodekey:c0a2b88f5f4b9aee6a50df28b6ff5e5c495053c26d969100ef23f13a51349bec','discokey:4023ff7bfd754262fe36745731a9d1175cc0b49d7acac56123cfbf0c633fa0c6','db-32','node060',21,'cli',NULL,NULL,'2025-06-06 20:55:32.690648751+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["50.133.88.187:24107","[ed61:9d51:b21f:7096:32fa:e473:f6d4:9f69]:17106","110.235.245.179:61572","[57a6:fde1:814:36cd:f8de:668c:f5fb:4f60]:39714"]','2025-01-29 12:01:57.48748166+01:00','2025-06-06 20:55:32.699638826+02:00',NULL,'100.64.0.55','fd7a:115c:a1e0::37',NULL);
|
|
INSERT INTO nodes VALUES(61,'mkey:6841756817cebda15bcacc15dc8e13134d3189a709a4b01cfe7f140a0ff928f4','nodekey:c9ad34579c8f83c989958c188d366b58bddfcfc8623f0ed478e86ae9ad9001c6','discokey:4de34c0ddff8819b97b39c2f31a2568db15e7c0ac6c1d75879b6c5247a5dd9a5','desktop-04','node061',21,'cli',NULL,NULL,'2025-06-06 20:55:32.705457818+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[507f:3427:b2a0:12b7:abaf:dd7d:2f0b:9a7b]:26021","51.210.182.192:52299","[2e30:4d2d:4925:201f:e845:2a12:503c:9524]:34552","105.198.43.87:48215"]','2025-01-29 12:03:01.464646336+01:00','2025-06-06 20:55:32.706102582+02:00',NULL,'100.64.0.56','fd7a:115c:a1e0::38',NULL);
|
|
INSERT INTO nodes VALUES(62,'mkey:f5a8d012556138cec4b6a6dbd5f36669d16e025962edf3367789b24a01cd54ab','nodekey:4ed3e288b9820dab0f68f070d6b36cb71e969d35804fdca8692c66b68538e8f0','discokey:0d6aa1b3942712032ff7936507a5eb7df01e40d068092e717d1469c3e683e8d7','web-15','node062',21,'cli',NULL,NULL,'2025-06-27 21:55:15.517052697+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["48.141.84.207:348","[ac:5c65:da8d:d68c:eb0d:3692:d441:5363]:63612"]','2025-01-29 19:23:14.092804852+01:00','2025-06-27 21:55:15.518034318+02:00',NULL,'100.64.0.57','fd7a:115c:a1e0::39','[]');
|
|
INSERT INTO nodes VALUES(63,'mkey:4be52a5e6b73a19d10d6cb424f776651633802f78caff3e2f6a45cf23eb529ae','nodekey:d4881065396d3d9b479137f2fa50504da55869d3b03120f991dcf3a9d7c733ab','discokey:77289acf81d715492dcbf00468f6297621efc9abb9d7934426babfde0c41206e','lt-52','node063',21,'cli',NULL,NULL,'2025-06-28 12:17:33.005602929+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[912a:9b6c:5845:f8d4:f476:491f:cdef:8b7d]:21677","22.203.32.217:28664","112.239.138.73:43954"]','2025-01-29 19:41:40.535299057+01:00','2025-06-28 12:17:33.174275791+02:00',NULL,'100.64.0.58','fd7a:115c:a1e0::3a',NULL);
|
|
INSERT INTO nodes VALUES(64,'mkey:4cbd491b0977f3a8cc92ef9f20a7726b3984f3c0699429ae46a0bceec5febee4','nodekey:66a7e77700fb0f4bae5b282413bdb5ff7c375549dd85c4300c73ff3d8029b4a4','discokey:2e9034fc43993eaa0cf2bc21118d378bb02afb3d197a33cf9f0dd201d176b23c','web-06','node064',21,'cli',NULL,NULL,'2025-06-28 12:00:16.139095833+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-30 18:18:57.519126133+01:00','2025-06-28 12:00:16.139426752+02:00',NULL,'100.64.0.59','fd7a:115c:a1e0::3b',NULL);
|
|
INSERT INTO nodes VALUES(65,'mkey:70cc01dc48021a01c44ab1a4bed313bb8270640ef7317fd983019c4b5e593cf3','nodekey:bfff30bca701176ec3b45b2991810cc437e3995207d924c896c4250e0efdb782','discokey:91eb7d9fa7688e3ed641adfae83be298c1ab261fd00dc2b4ad9cb4c269b623fa','laptop-27','node065',21,'cli',NULL,NULL,'2025-06-28 12:20:11.981310509+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-30 18:19:40.354692307+01:00','2025-06-28 12:20:11.982409032+02:00',NULL,'100.64.0.60','fd7a:115c:a1e0::3c',NULL);
|
|
INSERT INTO nodes VALUES(66,'mkey:ac14ce6b1ecd1a0d79bbf60d279f19d09baf0ebd409f099a401816516953eb30','nodekey:a711e6a5750ec7cceac6a771396b000766d9af8a34327bf5efec3216316e8afc','discokey:0b370e73e9970987dad3fd00317f51c68e4273fbc11b754ef7e84d4d6880002a','srv-33','node066',21,'cli',NULL,NULL,'2025-06-28 11:59:14.080155658+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","130.195.116.24:53838"]','2025-01-31 12:05:28.65297301+01:00','2025-06-28 11:59:14.080969357+02:00',NULL,'100.64.0.61','fd7a:115c:a1e0::3d',NULL);
|
|
INSERT INTO nodes VALUES(67,'mkey:fe494a29de4149025e3c41744cabfaaa2ae9a95795bdb6425e3beee27048e0f6','nodekey:2b078ccb547dc8b01f19749735f5fc43e65e4d468357a08a880fa54dc0a1e00d','discokey:cb991d6c0a14b0213e6f807e9c37a837b181c889a1e2d25e10d65d4a7e8b2b05','laptop-33','node067',21,'cli',NULL,NULL,'2025-06-28 12:16:35.347217701+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["54.154.28.86:64790","197.205.147.181:38523","[5e11:9ab9:6805:dec0:99aa:65e6:d1fe:6e58]:45247","[34f8:19dc:cc84:1e6a:d280:ac0e:2dd9:6fe5]:39241"]','2025-01-31 12:06:30.121464114+01:00','2025-06-28 12:16:35.34788428+02:00',NULL,'100.64.0.62','fd7a:115c:a1e0::3e',NULL);
|
|
INSERT INTO nodes VALUES(68,'mkey:de86679045cb8624f1a83852679a58cffd9066814aa8994f4ac0a9213b83175f','nodekey:b62e575e38a00afe79418224f7b954210702ac0a6d450eb8dbf7b5720b1eb5a5','discokey:6492f53782aab503155db83aa2d3a9e7698382da589b8c078d7850373332734b','desktop-65','node068',22,'cli',NULL,NULL,'2025-06-28 12:23:23.107075566+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b84:67b1:28c5:14f:aab8:916c:582c:6917]:24462","51.182.13.145:25726"]','2025-02-03 14:16:55.56431345+01:00','2025-06-28 12:23:23.107666016+02:00',NULL,'100.64.0.51','fd7a:115c:a1e0::33',NULL);
|
|
INSERT INTO nodes VALUES(69,'mkey:eb72ad359958c98e28f93485b720b6edef80d1bc33c4f99d772fc17c766039e9','nodekey:9122bd587ae90984e3231e0f48e15aa8abcfbc1b3324becd1f3622bbbe534da1','discokey:7610d45f8d2d3d4d7774c43288a6d50cd798a832732613647caa15e96621a3e3','laptop-93','node069',22,'cli',NULL,NULL,'2025-05-22 19:56:30.861469961+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"]','2025-02-03 15:23:16.312084161+01:00','2025-05-22 19:56:30.892062591+02:00',NULL,'100.64.0.52','fd7a:115c:a1e0::34',NULL);
|
|
INSERT INTO nodes VALUES(70,'mkey:8c5837a59e69539df974f244ee29ea29968a617072d4fdc6dfef564eea6a4061','nodekey:05ebbe5cdc96a19feb16211d4a62a2318e9448e15e1a3a90f0aa556fccba8142','discokey:cf7b3319a18ac04f588e2c5a95de9a24a37f5545338c3532d9703b861a43e3fc','laptop-86','node070',21,'cli',NULL,NULL,'2025-06-28 11:26:01.538093141+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[abf1:9c06:f1de:eef4:f14a:d431:8f2:4995]:52788","[8ac8:a469:4cc:90b5:c84b:f4f:5cb:49e1]:35646","[d152:3a18:3826:ee28:a323:74d6:7140:ca5]:40749","99.13.253.35:45887"]','2025-02-03 18:09:35.161109801+01:00','2025-06-28 11:26:01.539046342+02:00',NULL,'100.64.0.53','fd7a:115c:a1e0::35',NULL);
|
|
INSERT INTO nodes VALUES(71,'mkey:9562166c366f1968a5f82aca83bd8152d893541eed4d8682da0a540825cd44e9','nodekey:93ef8b713afeffc4324b0f9a99e185be61dbff43d6e5769efac6d82481b425c9','discokey:9aa3fe84188c317d17132a26604380ec4aaf7aed94b4b759bb6b643dbd53f8d9','desktop-61','node071',21,'cli',NULL,NULL,'2025-06-27 07:45:53.640560103+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["56.191.25.57:54747","74.194.16.233:59572"]','2025-02-04 12:03:50.32663805+01:00','2025-06-27 07:45:53.64117544+02:00',NULL,'100.64.0.63','fd7a:115c:a1e0::3f',NULL);
|
|
INSERT INTO nodes VALUES(72,'mkey:50329891edd2948b53a0905245386567c98b46bc0d566e39e1763768d51cd638','nodekey:e4ebfcbd1e1d653bda175a62b765c6a646b7844b3d6bd49a9955f96a9b284c6a','discokey:f59cb75bac53aef739bbd5be676808891ebb55550aa0560396dc0532658ed893','web-53','node072',21,'cli',NULL,NULL,'2025-06-06 20:55:32.885806537+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["200.133.152.206:14119","28.101.69.72:35202"]','2025-02-04 12:07:36.231437299+01:00','2025-06-06 20:55:32.902608355+02:00',NULL,'100.64.0.64','fd7a:115c:a1e0::40',NULL);
|
|
INSERT INTO nodes VALUES(73,'mkey:fc9d5a1c4658644beeb3130cf62b19042698652298ef36899d41f588bec371ab','nodekey:d44ef585e416773d29e627cf9a6e590af9b676d23a0a816865d05d775517ab4b','discokey:0c87d487f7a4f4ec5e045ff0c83c1b6c54453f7afe0e5f13c7ce90746e18da49','lt-48','node073',21,'cli',NULL,NULL,'2025-06-06 20:55:32.909812195+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["126.19.171.233:19526","[91e1:a8d7:5c43:b695:4f5:b147:b5f7:9f75]:62218"]','2025-02-04 12:10:26.50545127+01:00','2025-06-06 20:55:32.911837947+02:00',NULL,'100.64.0.65','fd7a:115c:a1e0::41',NULL);
|
|
INSERT INTO nodes VALUES(74,'mkey:a46b92cea88a9bac37dcb612a4a50dee75684f736c8c7f2aab812fa5fb9d463f','nodekey:1bbfdddf7b2a929a3da1e69236aa8b8fbd4b25d1839e57aaecf2ab910592bc78','discokey:c2188df6632aded7862de4b5d07c3993b3e908c59ce38f9d481f4840d85448c7','srv-06','node074',21,'cli',NULL,NULL,'2025-06-27 12:16:51.183868148+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[99f:9853:60cd:a4c5:e9d7:2a40:f86:742b]:782","[99cd:c956:e0f9:b633:5f8b:5c6a:50b1:571]:18474"]','2025-02-06 17:33:12.557302525+01:00','2025-06-27 12:16:51.184524169+02:00',NULL,'100.64.0.67','fd7a:115c:a1e0::43',NULL);
|
|
INSERT INTO nodes VALUES(75,'mkey:2c018031737bb172064fe31674acafe1b8b4d62d2b82db835e2c38061c5bfdbb','nodekey:575f781bb36f7c93cde4d9808e3dedef2c8999864ea1d4e5ee73fdd3d53ac217','discokey:00e3275941e7a0a73a1e5c44cea638a411c60bb2e257812e0f39152ec0c5a21b','lt-01','node075',9,'cli',NULL,NULL,'2025-06-28 12:12:54.498870123+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["56.80.126.49:13907","95.196.223.110:47343"]','2025-02-06 18:23:55.709687186+01:00','2025-06-28 12:12:54.499413173+02:00',NULL,'100.64.0.66','fd7a:115c:a1e0::42',NULL);
|
|
INSERT INTO nodes VALUES(76,'mkey:a5a8194cef984a1cc2081212405c10c8cc1061d3d00e6aa7e1415c854e3ded72','nodekey:ca37a131e58c14ebec3a6e179549d7c8742a31b42ed0e6e52aed138ecc176907','discokey:8a4990c19c547da50875ad00613118d5382717652b4ef9897a1d1c060c40a976','laptop-71','node076',21,'cli',NULL,NULL,'2025-06-21 21:24:09.453652526+02:00',NULL,'{"fake":"data"}','["114.141.127.86:11858","[d05b:3c4f:8402:823f:409f:87b2:4dab:4959]:58420","130.243.34.21:50806","104.255.105.25:5817"]','2025-02-14 15:29:45.220999928+01:00','2025-06-21 21:24:09.453999154+02:00',NULL,'100.64.0.13','fd7a:115c:a1e0::d',NULL);
|
|
INSERT INTO nodes VALUES(77,'mkey:51f0f5c2b892846f926abf826f5ff56a52fc4a466be7a1073f16028ef2c6aabb','nodekey:0138c27376e8289255c1d505ba8e8d0e9e8e6785198b87984763531273d0c540','discokey:5bbb476ee437efaa55c10931313e35c4c8c6e30015e7f3eb015f4736897abb12','desktop-50','node077',23,'cli',NULL,NULL,'2025-06-25 09:52:57.106038118+02:00',NULL,'{"fake":"data"}','["57.247.45.203:47518","[1709:1d2d:9e92:a2c5:f5a0:fbca:6d9:dcbb]:31824","59.75.44.185:44605","[1294:31c8:7d7a:efc5:9768:8d1:63fc:993c]:62533"]','2025-02-14 17:00:54.226657615+01:00','2025-06-25 09:52:57.123618657+02:00',NULL,'100.64.0.68','fd7a:115c:a1e0::44',NULL);
|
|
INSERT INTO nodes VALUES(78,'mkey:138104bf35231052caaaf0f55c18b5c3beb552669360dbdc4a5246a25d3ef8f5','nodekey:c4ae5fe468012696b6a85e95b23e1391f472b17ca834efe8d61578c186efb9d9','discokey:32d79e04d128c17209805e7641c0c4f3415690430afb344699f4cdaabb2ab28e','lt-38','node078',23,'cli',NULL,NULL,'2025-06-26 08:56:45.225612029+02:00',NULL,'{"fake":"data"}','["107.221.8.103:1156","[1cbd:d52d:8b7f:a698:2d0c:98f5:bbef:4d38]:43009","[6d9d:7cf0:440e:2ee6:8dc8:fdfe:3e87:f2f9]:6993","[734f:219f:40f0:ea33:47c3:ab48:b4f6:a239]:37955"]','2025-02-14 18:03:28.401774063+01:00','2025-06-26 08:56:45.232919473+02:00',NULL,'100.64.0.70','fd7a:115c:a1e0::46',NULL);
|
|
INSERT INTO nodes VALUES(79,'mkey:8dda457abd80238812f15bbc816248c5477f1c7f2a31b180e6d1917bb4cda3dd','nodekey:bee17b81a1b62eb551d672bbc6ab5c7900cc39951a3eb1be98b05e813c7a5671','discokey:aafde40e00db7577b135254c85e37e76348876996bd5b5e5b93cd9cf994cabff','email-79','node079',25,'cli',NULL,NULL,'2025-02-24 18:37:03.584752527+01:00',NULL,'{"fake":"data"}','["32.188.178.139:7110","177.149.150.247:56583","[e188:6623:d389:230b:a467:ab3b:2883:5196]:59813","[8dc1:48a1:2e5e:8c45:131e:9d7a:2d85:61ef]:1654","[dbf5:5aac:6a5a:f73c:a62e:69bc:c227:1180]:49484","200.106.54.69:19053"]','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',NULL);
|
|
INSERT INTO nodes VALUES(80,'mkey:94a77d61756e11d471ee47d55a1cb2eae0c0faacbe5b94ed8256ee68efabf715','nodekey:0b13795cf68e3a5adb091b3b97e0c2ac4884f8295245011f60c074693fe1d3f7','discokey:5ee7570d8f70a4078d7b9afe0cadc5441cb77ef9e2f849301e1082411e04c0f7','srv-48','node080',23,'cli',NULL,NULL,'2025-06-24 13:47:09.058273693+02:00',NULL,'{"fake":"data"}','["[231a:c601:4e16:b5a3:aafd:6b2a:8d59:33b6]:51062","194.8.95.111:60702","42.58.107.175:62253","[90eb:ca6c:1e10:11cc:fd29:4682:aaaa:fd20]:57634"]','2025-02-15 21:12:05.434304787+01:00','2025-06-24 13:47:09.058652899+02:00',NULL,'100.64.0.72','fd7a:115c:a1e0::48',NULL);
|
|
INSERT INTO nodes VALUES(81,'mkey:c63e8e0bd19c1d1433056fbffb0d8b66387fec012a75060189fe896296834a81','nodekey:fa2e09d0c11508bfef7f3b63cf2f0aa752a092565cc28a1a7007cfe1d44addae','discokey:37c9fd82db6d47f8dfeec0ed6d764f8b604fb06ddf8f2cdf44eea45a840b16ff','srv-28','node081',23,'cli',NULL,NULL,'2025-06-06 20:55:32.713163573+02:00',NULL,'{"fake":"data"}','["175.165.229.254:57553","107.46.106.255:64756","7.81.60.25:36846","[16f5:5847:5615:9f6f:b38a:e4eb:d340:c800]:62212"]','2025-02-17 16:05:05.921277876+01:00','2025-06-26 08:56:46.063988329+02:00',NULL,'100.64.0.73','fd7a:115c:a1e0::49',NULL);
|
|
INSERT INTO nodes VALUES(82,'mkey:9cff47309a04474303f70c020f06f8bb795bccfc71b2ebee64b5d2c5fa862f97','nodekey:538480654e054ac4e41a1249cf3a7780a48681ac2ed5c7f758fb5d1abe750389','discokey:9511b469afd6ac8c4644f6464873d440c6c4e4fc706e53d799bf7819556962e4','web-22','node082',23,'cli',NULL,NULL,'2025-06-28 11:30:16.497956346+02:00',NULL,'{"fake":"data"}','["[8c86:53d3:80d7:bd12:aa96:5eb6:7e53:dfbe]:39629","177.106.74.193:23401","153.144.178.85:48541","[a7b3:18ce:8c59:ff04:2b88:a0fb:7305:9a44]:27764"]','2025-02-28 09:21:23.143225002+01:00','2025-06-28 11:30:16.498254852+02:00',NULL,'100.64.0.69','fd7a:115c:a1e0::45',NULL);
|
|
INSERT INTO nodes VALUES(83,'mkey:619cc5464a91d8f554d47b641eb33921721d77cc277d1d4e662cb9a7e9a52b48','nodekey:8494fd062128da2a0b6cde389888fffe2e7384b5ea4f254c23392e62f7dc6962','discokey:4efe7a6440876724d36fa7380d9c73c43eb5d11a2b7c244628f878406fb166b3','db-00','node083',26,'cli',NULL,NULL,'2025-06-28 11:33:20.425827891+02:00',NULL,'{"fake":"data"}','["[f57a:5d73:f1b4:e8ff:6b9:ae85:1d9:244]:19001","3.20.49.173:50146"]','2025-03-18 09:09:50.849674955+01:00','2025-06-28 11:33:20.426570852+02:00',NULL,'100.64.0.74','fd7a:115c:a1e0::4a',NULL);
|
|
INSERT INTO nodes VALUES(84,'mkey:57b63829d09076ea08e0bacc6c66e99112804d4d05804fcd142550188928efc3','nodekey:f4506c8002304d533a91c84d4b8b450f0ead78a853dd1d962421d09f7fe323b5','discokey:e8b549a18c4ad009efe91b011ec3992d86cadb5fdc5838668835035d9442add7','srv-03','node084',23,'cli',NULL,NULL,'2025-06-06 20:55:32.855833618+02:00',NULL,'{"fake":"data"}','["195.54.83.239:15076","[3238:dbe9:f89d:91e1:6338:993d:3e76:8561]:32795","[b501:f57f:99da:e5f1:65fa:1d84:7d10:7d66]:24427","186.27.91.14:37325"]','2025-03-25 10:04:37.147174393+01:00','2025-06-06 20:55:32.866553475+02:00',NULL,'100.64.0.75','fd7a:115c:a1e0::4b',NULL);
|
|
INSERT INTO nodes VALUES(85,'mkey:569dd1b12fb2b9920f0366c57bdbf359f0e0239e6ef62cf7a1f29554f3e3ffe5','nodekey:94d32c5d5da99b19bd320ec4b7fe883e2d5bf137ede9262d035880f36610a39f','discokey:d25d5f42aee8b5d8e22b9ba1fa40e7295ad0f2b00c466d03c267ac9c0e00d152','email-49','node085',23,'cli',NULL,NULL,'2025-06-06 20:55:32.134989319+02:00',NULL,'{"fake":"data"}','["[b0bf:223c:e0af:4993:14e0:acb1:936e:4db2]:39578","222.45.50.133:6908","223.57.18.237:24236","172.116.24.79:64278"]','2025-03-25 10:08:52.471661925+01:00','2025-06-06 20:55:32.135474025+02:00',NULL,'100.64.0.76','fd7a:115c:a1e0::4c',NULL);
|
|
INSERT INTO nodes VALUES(86,'mkey:41dcb7bf690ffde927829637a6fc7c98b2600a504561ce7b0667f0f2aa1f3ab2','nodekey:633596e036705ce9ba03ce044cb7b5cd008f7045caee57fa594803a3b95c564a','discokey:9d96b830729e50d763debfefcd3af6f91ee9bb9daf53d6890652a25f3263f823','srv-96','node086',27,'cli',NULL,NULL,'2025-06-20 08:34:16.969649646+02:00',NULL,'{"fake":"data"}','["[a09b:5970:b127:fdfc:e68e:e496:bdee:6f12]:36132","51.12.68.23:57633","33.175.40.132:2790"]','2025-03-26 10:24:31.473595709+01:00','2025-06-20 08:34:16.970146755+02:00',NULL,'100.64.0.77','fd7a:115c:a1e0::4d',NULL);
|
|
INSERT INTO nodes VALUES(87,'mkey:3944556a65c99ee2890a8bd572dc3001f71f1eeebc580a026146eaa8def09009','nodekey:11966e544db141f610b5a1a864bd4be18373952b3a8ced40214105ef7371127f','discokey:a77a4b657a9ac80ad760d1e7348065578555373d8843162326e6366b0c54e444','web-11','node087',27,'cli',NULL,NULL,'2025-06-20 08:29:06.936731549+02:00',NULL,'{"fake":"data"}','["16.142.13.19:36771","[ad8a:a3fa:8d4d:c659:5e32:45dd:d95f:abc8]:43118","[797c:a12f:a521:102b:e357:ad81:247:fdcf]:61479","[5f8:a29a:bcab:9a90:4bdc:7d00:46bc:a69e]:16041"]','2025-03-26 14:30:57.179694234+01:00','2025-06-20 08:29:10.787309705+02:00',NULL,'100.64.0.78','fd7a:115c:a1e0::4e',NULL);
|
|
INSERT INTO nodes VALUES(88,'mkey:8ba458a88b40b125982bf763462a8f252fc3e80fdf8f472ab1545842af53494f','nodekey:09e6884692ec3f7f53bcc16bea60e1d4dfab44dd459af7dc42ab263e1d78920b','discokey:a09ed63f785315ae2ab524c3b34aad6f12d23a96771def70a3e0fb2de7ae7416','laptop-52','node088',27,'cli',NULL,NULL,'2025-06-19 08:39:43.92787588+02:00',NULL,'{"fake":"data"}','["54.165.39.252:59066","[127c:b334:8ae3:358c:4178:fae4:9f31:521c]:33026","104.73.3.103:62847","[fd18:384b:ef76:f4b7:6983:bd4e:70af:ce35]:42618","7.111.70.18:4634"]','2025-03-26 14:37:55.198097806+01:00','2025-06-19 08:39:48.020920495+02:00',NULL,'100.64.0.79','fd7a:115c:a1e0::4f',NULL);
|
|
INSERT INTO nodes VALUES(89,'mkey:3a17d7f9a8e51885b842e63fffad7374b06e1804f3a48e9362c2cc3e46df0af7','nodekey:4c771b227735fcb0f7e6cef27350852bffa406ad446fd37cf60f98ecbacc04a7','discokey:6a2091fd8a448626ad02024b66216b22ed02926807c2b7a18877f300e1d1d632','srv-52','node089',28,'cli',NULL,NULL,'2025-06-28 07:45:05.917078332+02:00',NULL,'{"fake":"data"}','["[3769:2186:2b73:8e38:b9bb:54c6:e48a:6e65]:33253","[460c:9b85:4ea7:ea85:e205:aa7:210e:c098]:44172","222.138.65.141:16368","[4bdf:4d9a:f0d3:2bea:deb9:33d4:c163:513]:6983","212.18.134.205:41528","190.153.32.51:23708"]','2025-03-31 18:34:22.574460539+02:00','2025-06-28 07:45:05.917342923+02:00',NULL,'100.64.0.80','fd7a:115c:a1e0::50',NULL);
|
|
INSERT INTO nodes VALUES(90,'mkey:3b2445a4e3d1c6cf3d909493530eecf8bff85ef8a440ba467d32bf6f1b64d24b','nodekey:298e7d97f1d1289dff2249401d706813c0d89121fab70e2cc514f3a53dbf14c7','discokey:3cca67ae4c540ceb6a8a7b552fdd8eddb54db6a1c082e290a4c0aa638c5c5efe','srv-72','node090',27,'cli',NULL,NULL,'2025-06-20 23:20:42.928064133+02:00',NULL,'{"fake":"data"}','["[262b:3b74:f0ee:1ea9:9099:5c3d:f9a2:22]:46101","[40ca:40f3:9b64:de92:c1af:a19d:f7e0:1dbc]:30741","[a9f5:d5cd:d553:b5:17f3:3d89:8617:46a5]:21519","102.217.166.61:13721","46.95.71.249:58007","168.186.124.250:51025"]','2025-04-03 17:52:02.130025013+02:00','2025-06-20 23:20:42.928708477+02:00',NULL,'100.64.0.81','fd7a:115c:a1e0::51',NULL);
|
|
INSERT INTO nodes VALUES(91,'mkey:2eb9cfef2ed45380bbb4043e4aa79257b50ed4575489fb5c789469283f31610a','nodekey:b09c411a584f487513bdbebd8fb50f91ca57c0f544c0649b155ba892bc9173b3','discokey:e95823238298c4f5554dd2c69e1f62ef05cae05dcd1bd95045b582f2136a7757','db-74','node091',27,'cli',NULL,NULL,'2025-06-28 03:30:33.869801917+02:00',NULL,'{"fake":"data"}','["[575d:4099:ec56:8209:f0f:ed49:b6d9:f75b]:27401","[a35b:63a2:51a7:81a6:eb0b:5e72:f82e:bdec]:54393","84.160.88.244:21712"]','2025-04-05 18:49:13.742268632+02:00','2025-06-28 03:30:33.870261795+02:00',NULL,'100.64.0.82','fd7a:115c:a1e0::52',NULL);
|
|
INSERT INTO nodes VALUES(92,'mkey:51551f7bcfb7e10f052439502541e9c00c37a8f3de91ed0fe01e5c3c47dea5a3','nodekey:6975b5ed6c0cfa85e0cdf6152f2d6c0c273109bfcaa76860637de5f1dc9e40ac','discokey:dba4f8059d89090a2e198367bbd04d6c5475abca7ae3731b7aa29c382131af27','lt-17','node092',23,'cli',NULL,NULL,'2025-06-28 12:21:17.063796663+02:00',NULL,'{"fake":"data"}','["[8052:8707:2eea:c767:5493:dd06:2d75:55a1]:60873","[8c83:88e1:5427:d2e:8604:ff8b:3c0a:6587]:6368","182.184.190.162:26611","[c45e:f0f9:8bf6:6beb:9170:ae3e:bc81:1842]:3750"]','2025-04-10 09:33:19.75758384+02:00','2025-06-28 12:21:17.064223203+02:00',NULL,'100.64.0.83','fd7a:115c:a1e0::54',NULL);
|
|
INSERT INTO nodes VALUES(93,'mkey:df4d9b0848620e7033c8cbecbe7cd076475433baa6a8233289a8207f538969c1','nodekey:2d50983fa2d5735e306a8c05630a41b897419528e2c9e7143efc29f2517777c6','discokey:7d62636f14b697c8d9666535fccc89cacb009088200957070d2ffb7108e79694','desktop-28','node093',23,'cli',NULL,NULL,'2025-06-28 12:23:07.890521061+02:00',NULL,'{"fake":"data"}','["[9497:e689:56ef:65ff:40ba:5bec:198:cbaa]:6478","165.179.14.165:11130","59.185.174.72:31766","[b430:987d:5157:7cdf:582b:c6c:801b:19d3]:8744"]','2025-04-10 11:00:40.243041051+02:00','2025-06-28 12:23:07.891010158+02:00',NULL,'100.64.0.84','fd7a:115c:a1e0::55',NULL);
|
|
INSERT INTO nodes VALUES(94,'mkey:0457d727c81909cd14e5edc1f8fd43c685bb5bca802c26df60fc27b90b66ff04','nodekey:316a01774fde64ebcfd3192f99ef9f83ff9c250b916090c1829d690d7ef5291e','discokey:de047a08a4c07142790d6919eb61e5d1c6bfebda7547778ba6e13b4166dd9100','email-53','node094',23,'cli',NULL,NULL,'2025-06-28 12:18:55.75713159+02:00',NULL,'{"fake":"data"}','["95.217.54.187:12234","2.119.104.181:58132","[7e19:7d5d:ce33:64aa:d9a0:5:ec9e:56c3]:40537","111.114.18.75:28011"]','2025-04-10 11:41:58.339188608+02:00','2025-06-28 12:18:55.757420045+02:00',NULL,'100.64.0.85','fd7a:115c:a1e0::56',NULL);
|
|
INSERT INTO nodes VALUES(95,'mkey:a0aad10c0947eabadb07e0a064b118abc6317194a20a35eefbf5f00497cc86b4','nodekey:f508bb43820174bbfbff0ddaa441477c6a4b1ad16e2d6a6c8bd8e7d579cc9512','discokey:7f3ea4389df4edfa3c5091be7ff8dab835b2584d453d8df7727d82828e9eb598','db-56','node095',1,'cli',NULL,NULL,'2025-06-28 10:23:24.075008579+02:00',NULL,'{"fake":"data"}','["24.36.243.82:39056","[100e:6264:4572:885e:777a:94d9:d296:29e5]:56545","[85c:f9c7:4780:41ba:b873:e740:7a65:aaf6]:46931","117.173.93.251:32036","3.127.130.51:31048","[b2b6:54b1:547b:3b76:a977:8ef0:9263:1d95]:10788"]','2025-04-18 07:31:25.494609012+02:00','2025-06-28 10:23:24.075270399+02:00',NULL,'100.64.0.86','fd7a:115c:a1e0::57',NULL);
|
|
INSERT INTO nodes VALUES(96,'mkey:9c90f9a2cf141fbf87bb7a713b11363c7700648c247b2be55880be65b097b32e','nodekey:a891e03b7e3f92ee155c51f966ff579e1b59affcdd7ffe2be0b17617fc5d2a4f','discokey:2d47647673be16002087672c8c3c333af739c0429b4ca3199a0b37c775f188ec','srv-31','node096',27,'cli',NULL,NULL,'2025-06-21 19:42:23.023186161+02:00',NULL,'{"fake":"data"}','["99.229.28.236:22736","[e5ea:7d6c:d0e6:153c:b9f6:17da:3b8e:a7dd]:11150","116.109.151.5:63986","[4167:adfc:1fcb:624c:e8d1:7469:aab7:e6a3]:29364","151.32.217.201:35528","129.148.62.154:38346","[5bcc:3f9b:413a:f79c:9785:4537:4acb:9123]:12439"]','2025-04-25 19:06:18.720283603+02:00','2025-06-21 19:42:23.023317999+02:00',NULL,'100.64.0.87','fd7a:115c:a1e0::58',NULL);
|
|
INSERT INTO nodes VALUES(97,'mkey:e403a9d40dd5cc7b3c34bb8e883069e46ea691bd901d80a18255b2e978ebbca3','nodekey:9fb4a4edd2f095f6d3ffc2783d13c1c1c9397edc7926a57a2b91d292dc6d9539','discokey:e3ddfd156fab89c7572aba20e9606ec10cdf6f8f60bf4a0e4b0ee9986b9fe875','desktop-17','node097',23,'cli',NULL,NULL,'2025-06-06 20:55:32.914042482+02:00',NULL,'{"fake":"data"}','["[5088:bc4f:e27b:708c:e75:6278:90c:92b5]:37686","[f352:c3ab:52a4:2b1c:d1b5:9ee4:a15e:d832]:39715"]','2025-05-14 09:57:07.359717602+02:00','2025-06-06 20:55:32.915628496+02:00',NULL,'100.64.0.88','fd7a:115c:a1e0::59',NULL);
|
|
INSERT INTO nodes VALUES(98,'mkey:076f21957e297a47c7e893b37dc38ccbc10d16041c45e733755f63a9adf27209','nodekey:23be3c688a8b508b5e09708e2a2623ece5b9ec426a776787ff163bea80104fa6','discokey:443acdc2d4a9c9f5c316b728916259e58eea2d0dc7e438181335306964c22121','desktop-72','node098',27,'cli',NULL,NULL,'2025-06-12 20:47:06.114210533+02:00',NULL,'{"fake":"data"}','["34.11.54.132:20475","[8104:4565:fd92:f07b:5ce7:8ad9:590e:349b]:64085","[fa37:1f6:5256:186d:2ce6:ed1f:b9b8:5d73]:42737","[6e79:cebf:1df1:83d1:d0de:38ca:4eaa:7bd3]:25953","[56df:3d29:e870:353a:bb28:ffcd:b225:5231]:57718","170.226.226.154:61176","[d122:a66a:2153:741a:b188:5260:a325:6c68]:17261","[67ca:e4a8:6a48:8880:1183:c56:7416:9af0]:57017","72.3.174.188:14460"]','2025-05-14 11:56:48.415832658+02:00','2025-06-12 20:47:06.114995503+02:00',NULL,'100.64.0.89','fd7a:115c:a1e0::5a',NULL);
|
|
INSERT INTO nodes VALUES(99,'mkey:24908f72d8e598ce86ab51aedbe19f7db7d459b33d53e0383231e3d54239680d','nodekey:37a38d1af4997a3a37406cfefc83240035cf5fbad122d46534e62ac9c9b23821','discokey:19926fa875306f0b304e898eee83f1711db11b5930a3016c18d0d503b37f0841','laptop-14','node099',14,'cli',NULL,NULL,'2025-06-06 20:55:32.627376311+02:00',NULL,'{"fake":"data"}','["[6228:aa08:b376:ded6:55d1:b081:66fa:6299]:59385"]','2025-05-22 13:59:12.642339275+02:00','2025-06-06 20:55:32.632840843+02:00',NULL,'100.64.0.90','fd7a:115c:a1e0::5b',NULL);
|
|
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','2025-05-14 19:39:49.446674051+02:00',NULL,'user001','','',NULL,'','');
|
|
INSERT INTO users VALUES(2,'2023-05-17 19:36:57.059073465+02:00','2025-05-14 19:39:49.446939883+02:00',NULL,'user002','','',NULL,'','');
|
|
INSERT INTO users VALUES(3,'2023-05-18 10:10:36.248939077+02:00','2025-05-14 19:39:49.447156233+02:00',NULL,'user003','','',NULL,'','');
|
|
INSERT INTO users VALUES(4,'2023-06-10 09:06:13.920718561+02:00','2025-05-14 19:39:49.447397385+02:00',NULL,'user004','','',NULL,'','');
|
|
INSERT INTO users VALUES(5,'2023-06-11 19:58:32.371218434+02:00','2025-05-14 19:39:49.447602838+02:00',NULL,'user005','','',NULL,'','');
|
|
INSERT INTO users VALUES(6,'2023-06-17 19:39:53.031565686+02:00','2025-05-14 19:39:49.447803872+02:00',NULL,'user006','','',NULL,'','');
|
|
INSERT INTO users VALUES(7,'2023-06-20 11:35:09.325846831+02:00','2025-05-14 19:39:49.447987808+02:00',NULL,'user007','','',NULL,'','');
|
|
INSERT INTO users VALUES(8,'2023-06-21 22:47:48.196234382+02:00','2025-05-14 19:39:49.44820155+02:00',NULL,'user008','','',NULL,'','');
|
|
INSERT INTO users VALUES(9,'2023-06-22 08:30:35.068995572+02:00','2025-05-14 19:39:49.448483514+02:00',NULL,'user009','','',NULL,'','');
|
|
INSERT INTO users VALUES(10,'2023-07-03 10:18:32.123226+02:00','2025-05-14 19:39:49.448692002+02:00',NULL,'user010','','',NULL,'','');
|
|
INSERT INTO users VALUES(11,'2023-07-03 10:18:37.130387602+02:00','2025-05-14 19:39:49.448883814+02:00',NULL,'user011','','',NULL,'','');
|
|
INSERT INTO users VALUES(12,'2023-12-15 08:05:06.013615212+01:00','2025-05-14 19:39:49.449111509+02:00',NULL,'user012','','',NULL,'','');
|
|
INSERT INTO users VALUES(13,'2024-02-03 16:32:42.224977233+01:00','2025-05-14 19:39:49.449357341+02:00',NULL,'user013','','',NULL,'','');
|
|
INSERT INTO users VALUES(14,'2024-05-03 10:12:38.220973042+02:00','2025-05-14 19:39:49.449556253+02:00',NULL,'user014','','',NULL,'','');
|
|
INSERT INTO users VALUES(15,'2024-07-26 08:08:40.979783263+02:00','2025-05-14 19:39:49.449755129+02:00',NULL,'user015','','',NULL,'','');
|
|
INSERT INTO users VALUES(16,'2024-08-05 17:32:02.878091894+02:00','2025-05-14 19:39:49.449974677+02:00',NULL,'user016','','',NULL,'','');
|
|
INSERT INTO users VALUES(17,'2024-09-22 15:48:00.287392203+02:00','2025-05-14 19:39:49.450181734+02:00',NULL,'user017','','',NULL,'','');
|
|
INSERT INTO users VALUES(18,'2024-12-10 13:55:11.256977421+01:00','2025-05-14 19:39:49.450421161+02:00',NULL,'user018','','',NULL,'','');
|
|
INSERT INTO users VALUES(19,'2024-12-17 14:57:58.550971236+01:00','2025-05-14 19:39:49.450633287+02:00',NULL,'user019','','',NULL,'','');
|
|
INSERT INTO users VALUES(20,'2024-12-17 15:02:08.053169491+01:00','2025-05-14 19:39:49.450837357+02:00',NULL,'user020','','',NULL,'','');
|
|
INSERT INTO users VALUES(21,'2025-01-28 15:57:32.774456057+01:00','2025-05-14 19:39:49.451012461+02:00',NULL,'user021','','',NULL,'','');
|
|
INSERT INTO users VALUES(22,'2025-02-03 14:10:50.491924701+01:00','2025-05-14 19:39:49.451214878+02:00',NULL,'user022','','',NULL,'','');
|
|
INSERT INTO users VALUES(23,'2025-02-14 16:58:30.250289644+01:00','2025-05-14 19:39:49.451415294+02:00',NULL,'user023','','',NULL,'','');
|
|
INSERT INTO users VALUES(25,'2025-02-15 12:48:14.650995528+01:00','2025-05-14 19:39:49.451605671+02:00',NULL,'user025','','',NULL,'','');
|
|
INSERT INTO users VALUES(26,'2025-03-18 09:09:00.456523573+01:00','2025-05-14 19:39:49.451854829+02:00',NULL,'user026','','',NULL,'','');
|
|
INSERT INTO users VALUES(27,'2025-03-26 10:23:51.960113834+01:00','2025-05-14 19:39:49.452164228+02:00',NULL,'user027','','',NULL,'','');
|
|
INSERT INTO users VALUES(28,'2025-03-31 18:25:26.535133091+02:00','2025-05-14 19:39:49.452536759+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_users_deleted_at` ON `users`(`deleted_at`);
|
|
COMMIT;
|