headscale/hscontrol/db/testdata/sqlite/from_nblock_db02__0.22.1__0.24.3.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');
CREATE TABLE IF NOT EXISTS "pre_auth_keys"  (`id` integer,`key` text,`user_id` integer,`reusable` numeric,`ephemeral` numeric DEFAULT false,`used` numeric DEFAULT false,`created_at` datetime,`expiration` datetime, `tags` text,PRIMARY KEY (`id`),CONSTRAINT `fk_pre_auth_keys_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE);
INSERT INTO pre_auth_keys VALUES(1,'463a8b372963aeaca12400faa0c7ea29e9bfa3b4c59e9622',3,0,0,1,'2023-05-19 05:09:19.66636462+00:00','2023-05-19 05:14:19.664224869+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(2,'77a019cb12c0d0b9347a17ab23fa4c87983814fe36bb2fbb',14,0,0,0,'2024-05-03 08:13:55.8614948+00:00','2024-05-04 08:13:55.85782156+00:00',NULL);
CREATE TABLE IF NOT EXISTS "api_keys"  (`id` integer,`prefix` text UNIQUE,`hash` blob,`created_at` datetime,`expiration` datetime,`last_seen` datetime,PRIMARY KEY (`id`));
CREATE TABLE IF NOT EXISTS "nodes"  (`id` integer,`machine_key` text,`node_key` text,`disco_key` text,`hostname` text,`given_name` varchar(63),`user_id` integer,`register_method` text,`forced_tags` text,`auth_key_id` integer,`last_seen` datetime,`expiry` datetime,`host_info` text,`endpoints` text,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`ipv4` text,`ipv6` text,PRIMARY KEY (`id`),CONSTRAINT `fk_nodes_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,CONSTRAINT `fk_nodes_auth_key` FOREIGN KEY (`auth_key_id`) REFERENCES `pre_auth_keys`(`id`) ON DELETE SET NULL);
INSERT INTO nodes VALUES(1,'mkey:0ea01e8cd608548a171ebcedc16da73b25ec18d58861be7a6b4274eb17baf6ba','nodekey:0fcf591dc1997c1d7388a3835bd24dae48240e5b03b6a7f5f33b2e813d222bcf','discokey:ed27f0b3c04222f0d05bfbc6fb5787338275ed0e32fd42fe68c669aca0f3d7a4','desktop-54','node001',2,'cli',NULL,NULL,'2025-01-30 19:50:45.306207411+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b8f0:cf44:22c8:82d1:f79:c3eb:9144:c24f]:6142","[8e25:af1:e31a:8fcc:7dcf:be1:a3c9:ed6a]:38766","[37a1:215f:bf3d:3fb1:6399:f7cb:4048:3ca8]:51666","137.242.125.72:25376"]','2023-05-17 19:38:13.531518257+02:00','2025-01-30 19:50:45.306340015+01:00',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(2,'mkey:1e274f40556282a5bbab04b6754985233ccdf971b663e5b38fc027035e833e9a','nodekey:5b16c7e14191ca2e57eccd86ec636db605fa5dc2c8856be5fa7f9b087cf24890','discokey:5fd2f116700fd48ce06e35e8dd11c847ccd7694e01ec4b3f6ef25f67c14ee197','email-21','node002',1,'cli',NULL,NULL,'2025-02-07 13:37:43.531171201+01: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","[3a86:865b:2f4c:f3b7:88a0:4aa2:f05d:c3fd]:47680","86.50.30.30:18216"]','2023-05-18 10:09:21.757289398+02:00','2025-02-07 13:37:43.531627524+01:00',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(3,'mkey:4405716e66f6a07a8fea90183cb078a8b87108aef23965b1c65f51375f3882d3','nodekey:96f979ded4cf1a02655d0b9069fb14e04d2da09c182624313acccf8c7f6b67a4','discokey:f0f4a89d7893303e1a336c9838c9a55b36a5215da006fccb72c237a794f4c5ea','email-51','node003',3,'authkey','[]',1,'2025-02-07 13:37:15.112124641+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[7cd1:a579:7ddd:ed37:5f70:5783:8e09:1968]:5323","110.83.0.14:9543"]','2023-05-19 07:09:21.399903526+02:00','2025-02-07 13:37:15.122168073+01:00',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:9cd192ff56bc94ec9439083852bb541469d6725e6cda7a2aa624df6e8c8c380d','nodekey:ac53dbdd1bb1c2a36a1dde021e8f5f33d2cf01ef2892fe74853e945b9a08fda3','discokey:57cae29ceafb73857b478955a77927ff5bd8f38c313a869be093f92c6f6303da','email-15','node004',4,'cli',NULL,NULL,'2025-02-07 13:43:11.76403969+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2421:d8be:14:6b5f:7fe:56a8:54b6:8d58]:25207","[20b0:e4f:96fd:1cf3:5d39:ad75:6b8e:d0ce]:51455"]','2023-06-10 09:31:51.940506933+02:00','2025-02-07 13:43:11.765088576+01:00',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(5,'mkey:7f9c690aab22d9db060086ea375d86924359210816ad562dab2db804ad3434c0','nodekey:88fe0bcd504fd98c35a71484820dbf7b91c1704b9d29c0c7950ce5ab06ef2d17','discokey:fbaef49f1a2c61469168a9e81ee6c5bd49a777048288975a22c0f253aa14e2e3','web-24','node005',4,'cli',NULL,NULL,'2025-02-07 13:41:53.142598056+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["186.84.191.82:2621","[c9d0:4e15:513a:171b:9911:f9a0:cccf:cd83]:24151","66.84.158.199:63451","47.94.115.240:6677","19.74.30.92:1284"]','2023-06-11 13:56:42.694329408+02:00','2025-02-07 13:41:53.143294241+01:00',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(6,'mkey:00e154160e4bd8db73f2707c7a5b2f0bae04f3e26427a1aca5b0dcf2dcc1872f','nodekey:4f61b1414dd622304d407a7b4812640f774247f0c3d369a2292e3f4e88383c17','discokey:1028826beface553dd6ea7e553cc63ca59fd529716cb639981d1aa2965ed8885','laptop-48','node006',4,'cli',NULL,NULL,'2025-02-07 13:43:59.675348504+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["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","[b8e3:18de:5ece:3e24:8bbf:1cbd:d27c:7de]:53522"]','2023-06-11 13:57:44.975695604+02:00','2025-02-07 13:43:59.676029923+01:00',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(7,'mkey:69a5389410061b4c336c1f337ae3ccca903f729ff249b6f1e556dcb9d9a3b7eb','nodekey:54c0d87c263afc07b7a3bb5569f8d6b67c58fecdcabefcbe7b8057e91e573a31','discokey:765930463b973ddead698512fe882cbe5e13885d14d44808596600efbcf5303f','db-22','node007',4,'cli',NULL,NULL,'2025-02-07 13:43:32.833347079+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[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","[debd:ad2f:ae50:cd14:9cd2:b297:bb94:d03c]:24266","[489b:6c59:1877:6215:ddc8:57f8:78dc:321c]:3025"]','2023-06-11 14:16:56.951313537+02:00','2025-02-07 13:43:32.833827225+01:00',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(8,'mkey:3fa0a7da3e9f0eecb11b442d911620b629981f5eb3f4ee851256a55b7252a1e7','nodekey:1912a3b843ba973c55b449fb0e1e01faff114b440e7bd1ca8b9af3be0cc56762','discokey:0d4f62fb22a9ab554a8983123cc118ec17b9d47c97d1d84bf082c90f82fe267b','lt-35','node008',5,'cli',NULL,NULL,'2025-02-07 13:44:16.543907578+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["124.104.237.237:47957","[b9f9:eec0:d656:cd83:8595:46fc:b677:6ade]:17494","126.251.133.86:44347"]','2023-06-11 19:59:30.401970393+02:00','2025-02-07 13:44:16.544521726+01:00',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(9,'mkey:dc84e5b1cf58ec8f7200ec0a655c1d5843c520ea59aa7ddd111ad5c9beba9bd8','nodekey:3c06f5a6d7f267023044ab632892b51f5af1ce4d84f0739e88823bc22cda6c57','discokey:3c1aa008a7811012038cd6658b6f290b3d252074c47d23cf1766f878340a30bf','desktop-75','node009',6,'cli',NULL,NULL,'2025-02-07 13:37:15.10720621+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["187.166.20.165:11208","78.47.168.253:34957"]','2023-06-17 19:40:45.468789461+02:00','2025-02-07 13:37:15.127284919+01:00',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(10,'mkey:2325e928fb41b3a3815b7635223411100ba10eba8ea1b442838b40da35379ec9','nodekey:8654f75dc553fbb381f57fd3f8669b5c2572f65d97989d0a69c3b294bb8cc685','discokey:24037160babf3208537006968c9f47ec3e689b1873796a787eaa44fa95afd986','desktop-46','node010',6,'cli',NULL,NULL,'2025-02-07 13:37:36.447602378+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[97a8:bbb7:9bb9:aa2b:e449:4d57:4a65:3561]:17392","151.97.159.85:8120","[69bc:fe73:f6c7:31b2:bc4f:1a95:4676:201d]:4806","[d794:c918:b0e8:6023:d7cd:709:79eb:23f7]:56801","113.147.88.203:61138"]','2023-06-20 11:18:35.905417341+02:00','2025-02-07 13:37:36.47098382+01:00',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(11,'mkey:4fb69f4bf77b8159e4814764398e6cd3bf2067b3fd4eda0eacc443ec299fcde2','nodekey:cebae8af02150eeb54b67f2cadc33dda38a98c94cfec05c1f378bf130007e946','discokey:fd5c9fefc960538a070c2bddafd53c3f890c561e02b62218e4aa8e6ae38cbe4f','email-12','node011',7,'cli',NULL,NULL,'2025-02-07 13:38:08.624346736+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d86:4301:d7d:7706:8b4a:86bf:19cd:1d6]:55529","151.169.147.218:56573","[9e9e:2802:ebb9:ba03:a564:7999:7137:65e3]:52919","[ede2:462a:f99c:24c3:b1b5:8b97:abe2:3ddb]:65141","[dfe7:6f6b:a382:4fc:a3f6:eb9:9ebc:5798]:1474"]','2023-06-20 11:35:15.063855316+02:00','2025-02-07 13:38:08.624847369+01:00',NULL,'100.64.0.11','fd7a:115c:a1e0::b');
INSERT INTO nodes VALUES(12,'mkey:5e192b1b323439fcc3b921c4f523ce9b7cce867220bd092d23be2451ce93a4a5','nodekey:1452cb2c8f26c8988cd8d8ed42957c78e3ab922bdf9773978c853e4254e23fbb','discokey:b7b41dc5de1fdcc4bd609dc72f79d27269367dbf72ab73ab61e998aa31eac6a2','web-19','node012',5,'cli',NULL,NULL,'2025-02-07 13:44:08.729267096+01: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"]','2023-06-20 18:22:35.061914624+02:00','2025-02-07 13:44:08.729820984+01:00',NULL,'100.64.0.12','fd7a:115c:a1e0::c');
INSERT INTO nodes VALUES(18,'mkey:f11332335d9f1f9d4bfc8cf9bf4edc0c958d4e4364b7dcde3c67d847f7d05edb','nodekey:e97d97a2751ef3533818907c9f24acf3270e3824f2294bb9a36d60ca196e161e','discokey:412b0eee00b68721d9169fc81039b9cda6cf57143e4cae8f7c417db15b83411a','web-18','node018',9,'cli',NULL,NULL,'2025-02-07 13:37:16.15950606+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2acf:3f32:1763:5d21:88a:4af:8779:1b1d]:36283","84.177.251.38:32968","[3138:83c6:ae09:a073:7888:71e0:494:3863]:59700","191.156.96.176:5489"]','2023-06-22 08:30:54.08720463+02:00','2025-02-07 13:37:16.721306872+01:00',NULL,'100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(19,'mkey:157706346bfe3502b6e24a84efa59b1a151be08f5a260ff96c72a734c1da1390','nodekey:139a99de286f52c55bdd61e932827c9d7cb84101a698df3576bdffbeedbf654d','discokey:293abc1a1cf2921e7961f5753cc39097956648bab47879791afb12ea03a4e6dd','lt-42','node019',10,'cli','null',NULL,'2024-08-07 09:35:12.220368767+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[ce0f:9f05:96dc:a47d:edcd:1c25:f578:7551]:30363","[cc06:9c56:919a:2341:4ef7:7f28:c8ca:2a5c]:30788"]','2023-07-03 15:18:03.829428454+02:00','2024-09-18 16:15:14.037990869+02:00',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(20,'mkey:e4713082f1a4d5e2f5ca126b95eedc7ce673782a871afde980a74aa98e31273a','nodekey:3957decaff55af98415799c81e6cec28edc377d6e2a9ddca3c909c26bcffd45b','discokey:9e8360b263f67dc8d5dea9d37f023ebbbb8882f265f6ca43f5923194d7931609','db-08','node020',11,'cli',NULL,NULL,'2025-02-07 07:28:20.585544641+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4692:f8a0:842b:c26a:e549:1f3b:6795:964e]:31064","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:40:34.838579199+02:00','2025-02-07 07:28:20.585679087+01:00',NULL,'100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(21,'mkey:2894a7babdc030bac1e4ec0e14aa4b6b67ebe382a1773e0ff4aa8b16ecd443a3','nodekey:1e219f3cc03eaa868018b9f6870d108317c31760fdc38ad4bec7200d58379f26','discokey:a81e998383baa23adb3e1e6757ef0c4b960095022f00b500b57f53c6147c71e4','laptop-48','node021',11,'cli','null',NULL,'2023-11-20 07:19:19.447470862+00: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-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:9ab69494a274cba5b22cbcf35b3ada57d4b3d2ee03930a456f80fb34dc69064b','nodekey:0345912b4e39cd9d03dec55edec6fba7f8aca631312884b49538550475332182','discokey:a2c1be2ae50af07e5b96b0a3ee2d3a1b0148fbfc5c1a283bc787e31410d6f74c','web-51','node022',6,'cli',NULL,NULL,'2025-02-07 13:37:15.266244078+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"]','2023-08-05 12:08:48.132161695+02:00','2025-02-07 13:37:15.266464476+01:00',NULL,'100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(23,'mkey:d1b90c1c72090d082067c2dfbf287f26510b58519bbc5113f1ca63ad3ef20b96','nodekey:2d0d6f2300d295c8f91d0b954d733a2f8c4106595070d3efc6eb709df09591f6','discokey:87ef4543866a337716d7d5021346b82bbbd1aab14c36deadf96b4c38718e8cd1','srv-45','node023',12,'cli','null',NULL,'2024-12-07 19:25:56.935152754+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[79e6:8519:803b:6054:5c13:9069:8dfa:1dcd]:45055","30.154.162.65:53795","21.107.170.69:30767","212.18.227.41:50735","[f774:e89b:980f:975d:fd3e:93f:a9b5:2034]:46054"]','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:f10b7f9f385e48dc99ec0944b8a04ec4d3e5613587419c134440121fa747ee75','nodekey:9559349d25dd3fa88b9595cb4ccebeeb4712338757a209e936afe37ec2643dbc','discokey:b9a07315c1eb2e074871feebe899bd2ecae64d98a8edf08883785130ef386728','laptop-25','node024',12,'cli',NULL,NULL,'2025-02-06 16:36:01.609321017+01: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","[320d:6314:eaa2:a098:8594:977d:27b:8442]:12827"]','2023-12-15 11:14:36.765183054+01:00','2025-02-06 16:36:01.609441418+01:00',NULL,'100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(25,'mkey:84784f348b4e879e87986ef13b6f02ddef91639cd7de65540903cd846f93e1f2','nodekey:c15dc98ef47cf6f5dd52f59c22b3b6b0d8536ea5d248787a0145b45e6598cff6','discokey:c14e1be497f1423b4f4aa799f8ee907307eec987a1c3f7e32d4adf215fa731c6','srv-70','node025',6,'cli',NULL,NULL,'2025-02-07 13:42:34.03052815+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[23d7:1ab8:8bd1:10f3:a4f7:bd70:7803:773d]:50718","[3200:76c9:dca8:d60:e5d6:868e:a264:3efa]:33138","[975a:978:5cfb:5e5a:1b6:d272:a1c1:50dd]:3245","[e6e4:7cfc:9ce:b47:62f5:b64e:d2e4:9015]:42369"]','2024-01-05 17:32:40.940566279+01:00','2025-02-07 13:42:34.031054525+01:00',NULL,'100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(26,'mkey:dba47da985e4770a27031261b989e24ddd437983652bd1f96cc520ed78c5fc0c','nodekey:3c36d35f3e9ec98b36741e5973d8f5542fd82503a1752ad9e20545fb6be984bc','discokey:b30567e26d2fae861e566c4081179d8c72f9e659521dd7e6afecb3fbaaeae63a','db-02','node026',6,'cli',NULL,NULL,'2025-02-07 13:37:36.216420089+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["192.175.239.121:921","98.153.121.140:5003","208.68.161.128:56198","163.42.128.241:47535","49.160.22.202:42427","[1526:e34a:8857:394e:bbe0:c043:4b37:68d4]:5245","32.31.195.128:7039","[c50a:ec:e2e:e109:3a08:f56b:2928:4921]:61265","221.147.144.138:44737","136.208.142.64:41091"]','2024-01-05 17:34:19.811670479+01:00','2025-02-07 13:37:36.272729094+01:00',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
INSERT INTO nodes VALUES(27,'mkey:73868242348c7d709b77f52963c32eb4b95c8b6f89abb5db76bd95cdaaa538b7','nodekey:2de3f421f78de3f5cfd824ffaa80cf3fde3060bc42f51c2ee2f55b49fd5fbe20','discokey:5ff3b0ad430ee5530c972ecf0d3e69f25eecdadf6ef8a309b3841d7aaa6f70d4','web-56','node027',6,'cli','null',NULL,'2024-01-16 14:32:21.570104175+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a2b8:ea55:f9e3:2c00:f423:8c56:7fec:c617]:53793","[ed88:2277:3c9a:4f64:a25e:5b41:a3ca:e904]:27852","[d203:40a2:5efc:4a42:8910:81f8:59c6:4d8d]:23389","187.126.162.12:25054","[5d8b:9391:47f1:1bbc:e01:92de:4a90:7614]:42410","172.81.188.131:23453"]','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:300a566a21fcaab2665dc091300e2c5110dcaee25e2fcc4cc23b011fdae471e6','nodekey:8e36531b406e0b7b9c1b9abadc00626ccc8c6e7a0c37f70f42ccf06cd2dd03fa','discokey:a4134738054f6fc0c57b6eb47913e68a3f47ffb81af8a3496754921c2fcb02f8','laptop-98','node028',7,'cli',NULL,NULL,'2025-02-07 13:37:15.697245044+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["113.143.9.36:55432","[e266:66fe:4929:3831:7830:6f10:1572:20df]:9977","[afe5:7d57:fac5:a1c5:78d4:ee33:d474:1e56]:52223","7.208.95.117:299","[d28b:7b33:1f88:7583:7ed7:a923:4c90:9ee0]:62318"]','2024-01-15 09:34:54.847632697+01:00','2025-02-07 13:37:15.743059169+01:00',NULL,'100.64.0.23','fd7a:115c:a1e0::17');
INSERT INTO nodes VALUES(29,'mkey:8e49fb1776eb7ce9cf27cd557a05f6d1868e6ac5a06eab48baa953a0a0b17381','nodekey:3ff07a931e2725e7f96c378dc8b4a531818fa64e853879df8c51d5f2bbff8f9d','discokey:bcf9648f2249fbc34d8fe61593c8ffcfd4205593b9c6525196148b1f280228d2','email-91','node029',7,'cli',NULL,NULL,'2025-02-07 13:37:14.081795989+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["162.176.178.140:46577","[4f52:1708:c0a:7991:9c16:bd7d:4045:195d]:50362","[fd0d:f112:f642:c343:ac14:8ede:dc04:e2d9]:58412","[8a1a:5c17:bb81:bb69:c7db:3513:f14c:ca2d]:52077","123.235.220.59:59925"]','2024-01-15 15:18:12.2871978+01:00','2025-02-07 13:37:14.172137472+01:00',NULL,'100.64.0.24','fd7a:115c:a1e0::18');
INSERT INTO nodes VALUES(30,'mkey:15fa512b5b78a7714edf3477babba0d325e0b121f5b81b63dafa434a9eb71c32','nodekey:b61427ebfd1dd6801f5bccb3fb42c30e1ace79441daa9d5d0cadcdd9ff199370','discokey:6a09d51cbcafc8c1eb9983a744f2df3f288d43a3b8ba06f088eb7fe1c375b341','laptop-77','node030',7,'cli','null',NULL,'2024-02-05 12:14:40.065688294+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e84c:35c4:4bd9:a100:c271:8921:ca7:5901]:21828","[fab9:f181:95a4:a769:df9b:b7ae:9799:83dd]:32341","[e868:f68f:cceb:8d29:5451:c716:bdca:437d]:41081","[7016:b48d:8bcf:4ccd:8679:8c47:1c66:cd1e]:41980","22.231.20.85:41616"]','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:fbebb2c69f263a519c8902463ef9c7db0597109fae5730a222f1c6567278bc86','nodekey:d83666c0acac1a9cd306cb884a1ce24adaabbc2102eb553ef5514ac5ea1714cf','discokey:6f4280bcb38ac995d22543db32230d8f22f2c0a0dc5efe2d86c7361c897ae812','lt-82','node031',7,'cli','null',NULL,'2024-02-22 08:35:27.098819037+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4327:29dd:a02:fb00:9645:d497:8ffc:4a68]:26342","[5d4a:a2f2:16c7:3d3a:a2b8:2962:30f9:3407]:5279","107.140.203.49:9365","[1660:741a:160:67c9:7972:5f9d:14bd:ee53]:21178"]','2024-01-29 16:05:35.338524634+01:00','2024-09-18 16:15:14.042191514+02:00',NULL,'100.64.0.26','fd7a:115c:a1e0::1a');
INSERT INTO nodes VALUES(32,'mkey:8c468799222af319e17ec309dbbf3a87fb6d924a1cb17e5a0bd7e027fe3bfe5e','nodekey:3c7d82f4a44cfa1469b957ac911e8506a68962fb2583d2afaf3e8a621c0c4aca','discokey:ba179b51f3540e619eaac9a6d4bc67403daa7c3cf28a6b579087cd6d284501b4','lt-53','node032',7,'cli','null',NULL,'2024-04-09 13:59:43.37062537+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d21f:d7bc:f690:e3ba:82fe:8122:c33d:5a86]:227","10.67.113.92:45634"]','2024-01-30 10:41:58.31917869+01:00','2024-09-18 16:15:14.042506082+02:00',NULL,'100.64.0.27','fd7a:115c:a1e0::1b');
INSERT INTO nodes VALUES(33,'mkey:be7f190677fd0cd1c5e78b4ae5b02a1738dd60be7d9a41017000b22ae9636af4','nodekey:a404e578d3edd3e3d879e9f1946c859b5982c59f5e528bf6b987bd55de00b25b','discokey:ad3013f116c370866fc9134b66999bb05e2dc10a8e2944230c3d9893c0a94c67','lt-80','node033',13,'cli',NULL,NULL,'2025-02-07 13:37:15.862018576+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[af8:f5e8:32f0:75ee:d351:c0e9:78e:93d9]:12624","71.151.27.31:51063","[f0d6:21dc:48f5:63f4:daff:a3c4:7d60:51ea]:17286","[38c5:9551:f6ed:b087:91ba:bef1:771c:273d]:62171"]','2024-02-03 16:33:26.706408143+01:00','2025-02-07 13:37:16.21569294+01:00',NULL,'100.64.0.28','fd7a:115c:a1e0::1c');
INSERT INTO nodes VALUES(34,'mkey:7784df3aabe1ca1edab5270028fb3cae8b66cee2384790d06969d1e6e298520f','nodekey:fd8e939fd6db8caf6623ac3d73c12ade4da110d8c1f29e3a3ee0d2be0c526915','discokey:59aff4582e00d92260e6a90d6d0da3d818fe8f52c081c8b65e18006ef8269ebe','lt-65','node034',13,'cli',NULL,NULL,'2025-02-07 13:37:13.91519638+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["71.155.69.236:8707","125.2.67.155:50785","32.6.80.181:17295"]','2024-02-03 16:42:32.683785672+01:00','2025-02-07 13:37:14.346290035+01:00',NULL,'100.64.0.29','fd7a:115c:a1e0::1d');
INSERT INTO nodes VALUES(35,'mkey:ad3838fa63fb120ae8d3e47d4bb6bb4009e7fc5d91483d1ba7417d0681fd7162','nodekey:b10ddbdcf826d79049d74a7d4ad036b499c86f7daf786bb1a9b295366b57afe8','discokey:618ef629d3bd261964c613ad3bc45e6278fa274d734c8cd2d3396cf8c9742d88','web-33','node035',5,'cli',NULL,NULL,'2025-02-04 17:50:49.267594119+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["169.159.71.157:18240","[bbb7:5b4d:218d:55ff:ac9b:1fb6:c933:9a55]:63943","18.156.132.228:63356"]','2024-02-03 16:51:52.010016072+01:00','2025-02-04 17:50:49.26844864+01:00',NULL,'100.64.0.30','fd7a:115c:a1e0::1e');
INSERT INTO nodes VALUES(36,'mkey:c536a3efc460fb2da4c4775e2b51d0c84f001dc46a4d902429e74e97b2d3c6d4','nodekey:91da2acfa3d7f7c7b0c1a2d952ee527514504fddc504809423762203a16145ab','discokey:989ff5f21d485dcb6312fade38c9047bbde1fbce46bc29ac5f6afe00610ad215','laptop-46','node036',13,'cli','null',NULL,'2025-01-19 14:01:48.956567669+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4017:a243:61d0:b302:7860:18f:7d4d:f605]:28633","[e5b8:6c78:ce2f:cf6f:13fb:401f:8223:3f04]:54121","38.137.88.247:35801","[eec2:61c0:e20a:2fa0:5e4d:56a4:5071:881b]:36628","[b8c2:c792:3329:2c93:f94b:a948:7d11:b9f2]:908","[5925:353c:bd9a:f42e:1916:45b4:c170:e515]:18400","[c2a5:cc2f:e2e8:573f:7b01:4aa:8a1a:fd71]:32146"]','2024-02-09 12:34:57.879970954+01:00','2025-01-19 14:01:48.956830267+01:00',NULL,'100.64.0.31','fd7a:115c:a1e0::1f');
INSERT INTO nodes VALUES(37,'mkey:142e67963c9045164df7b33af6d2149d72f59527df44fd75221647281444cbe7','nodekey:a3a2cd2bd0c3a1f783d0391ea1951c5c9226ddca0f18130b77fccff8b874d694','discokey:bdb788f8825b9bd816f37dcea882920382c7feb143edf0a6baefc9015774d8aa','lt-24','node037',5,'cli',NULL,NULL,'2025-02-07 13:40:58.763825796+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c31d:dd18:321:589:11fa:d85b:695f:1fca]:43064","168.4.78.117:48474","90.45.218.0:29326","90.233.46.138:29846","8.137.133.59:22781","[cb5c:f8d4:ccb0:8333:8ec:170c:a2b0:941d]:26248","[5802:df5c:8853:4851:6dcf:cb83:8208:d143]:24568","48.38.104.41:43702","139.100.200.227:62546"]','2024-02-27 12:14:40.452601042+01:00','2025-02-07 13:40:58.764224794+01:00',NULL,'100.64.0.32','fd7a:115c:a1e0::20');
INSERT INTO nodes VALUES(38,'mkey:6829f2d5523aba7a27c31e59e2341f3feb5a5a72a0268ef10d23c39811ea3b53','nodekey:10e4ff66fdd37fb54f6dcb0e42f483a15b6340610acc3a4517c24f0f350b5a9a','discokey:f20786f9c7edc967d0b415bbcce39468441af3b531ff15656c0683d3f328720a','lt-88','node038',6,'cli',NULL,NULL,'2025-02-07 13:42:43.738264414+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a393:f17f:6728:82e4:c1e7:2367:82d0:daaf]:18560","[d192:9897:4cd7:bfb5:de36:fc03:8cf4:c60d]:25096","212.199.67.213:11150"]','2024-05-22 08:08:16.045350656+02:00','2025-02-07 13:42:43.772029617+01:00',NULL,'100.64.0.33','fd7a:115c:a1e0::21');
INSERT INTO nodes VALUES(42,'mkey:33e764ae40265089c5e7dbfc8571aa23bb390fc7e1e8bd2f3e0cd6891c308214','nodekey:c444c9ff652ba29181a5f7fdf991f91f704e6698237ee18b0649c81879ec932f','discokey:2e1db3a1eea266673acf7826aa44b5aa6fdd23c6ba41330562b37c5a523ba358','laptop-81','node042',14,'cli',NULL,NULL,'2025-02-07 13:37:15.183056803+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["190.179.215.222:61930","45.131.187.230:22916","[510f:af99:ed4d:f53a:fc21:8640:9ad9:4930]:16050"]','2024-07-03 11:12:29.418355657+02:00','2025-02-07 13:37:15.184237123+01:00',NULL,'100.64.0.37','fd7a:115c:a1e0::25');
INSERT INTO nodes VALUES(43,'mkey:353844c4b332bdbf7f39796c522ee89d7f64fde342d3e566878f456df0d57a54','nodekey:c9f47cb50fd2b9075cda9d68018659491ac29dbbe7a04e8405039fd385966fa7','discokey:ec43638237bc43ab6a9839b3a4d54c2593e11a2ebd13bd491f08f68d7cf93ac0','desktop-90','node043',14,'cli',NULL,NULL,'2025-02-07 13:37:15.256444976+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e071:3cd7:878c:ae2d:7dcf:eab0:d0d1:decf]:37427","17.31.200.70:26794","[183d:f2d6:b80:36c5:318e:64e9:7f4a:b389]:12440","169.173.198.12:15274","[e5df:1889:6ac5:7d21:4dfd:614b:7eb9:d93c]:792"]','2024-07-03 14:48:50.263910778+02:00','2025-02-07 13:37:15.258418656+01:00',NULL,'100.64.0.34','fd7a:115c:a1e0::22');
INSERT INTO nodes VALUES(44,'mkey:6d3e50168ff6e672ed7650abc5a1de7fec7150c6f84932c705c84964824d1d39','nodekey:ad70f51f99efeefdf0c8e0a9e818db1e5de474e67b2b0a1609a53190339938ef','discokey:c4d4ad19814f9312b454cadb85b333f80cccca1b4a42f30780f7a0f4ccfe1bff','laptop-97','node044',14,'cli',NULL,NULL,'2025-02-07 13:37:15.264418779+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b501:efaa:c73b:b492:c3cf:865:d55b:9557]:26172","162.210.141.106:52036","[84ef:a164:d1c:d20d:797c:753e:f8fb:3108]:5767","[c15a:e322:a721:c9a7:a662:ccb8:26b8:e1c4]:63192","[87c4:c36b:d96f:525b:fa4c:c5f6:7bc8:d6bb]:35894"]','2024-07-03 15:23:48.066044194+02:00','2025-02-07 13:37:15.265313019+01:00',NULL,'100.64.0.35','fd7a:115c:a1e0::23');
INSERT INTO nodes VALUES(45,'mkey:e1772e6b138211afff6aa8fee08438c311b1d9d32576075c980d39591b13ae77','nodekey:92b8cc28bff0c53f95fbdd8c1363040100ae849e78aea04a3755e9a1fd03fe4e','discokey:7b368b5d64b6e4fb4f0ba9e5809bee8b769949ecdc69ec6ee6c9f12c2321fced','email-94','node045',14,'cli',NULL,NULL,'2025-02-07 13:37:14.65277645+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[caa0:946e:b130:39aa:31b0:8f9:7526:4960]:1729","120.102.247.255:41936","28.177.95.32:7841","[fb23:5998:c63d:b6c4:e86a:96b2:61c:e110]:51902","[89d4:f6c6:ccf6:b19d:3b76:642e:7a36:d229]:930"]','2024-07-03 15:54:01.706018896+02:00','2025-02-07 13:37:14.741317691+01:00',NULL,'100.64.0.36','fd7a:115c:a1e0::24');
INSERT INTO nodes VALUES(46,'mkey:af6c1d228b675ff04d2584e2c23d6288ec312a6b44c5c0eed213423a11711787','nodekey:f5b21f25bb22b5cf0cedb1b643d50c3a6512ef300cc971eccccbcc500cc23408','discokey:72843a1b2564c177d8556eb0d76dda7cbe0d9f1408bd250fcc6149518eb6d5c0','desktop-41','node046',14,'cli',NULL,NULL,'2025-02-07 13:37:15.182378567+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[37a8:9998:e94e:e297:940e:5414:5549:87c7]:37130","27.138.122.133:37304","98.38.29.194:12660"]','2024-07-03 19:38:07.783745318+02:00','2025-02-07 13:37:15.183590138+01:00',NULL,'100.64.0.38','fd7a:115c:a1e0::26');
INSERT INTO nodes VALUES(47,'mkey:5bbb77092f21b4835b0ae1af3871fc48445819c9b6e5ff9c46ad4a623b662ae8','nodekey:191c7cc089ee160c07b63e2b6b5ef0701d76d914009420baddad9bfce13e3f2d','discokey:712cadffd23f106abeea82ae70bbae8e06c2a58f3db617afd0d149b3012c64fb','web-61','node047',14,'cli',NULL,NULL,'2025-02-07 13:37:15.16567498+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["186.118.23.242:32373","[5bd8:a5a8:1b3:5e41:3c4d:5fc:4c0:c6cc]:24847"]','2024-07-04 10:38:08.344092869+02:00','2025-02-07 13:37:15.167818666+01:00',NULL,'100.64.0.39','fd7a:115c:a1e0::27');
INSERT INTO nodes VALUES(48,'mkey:a1e793aa09c20360cb4ef57e7dc42171a0abbc9f562140609e930ba5b7b12e83','nodekey:3343520915898c9d90b7517eabf8660d66c37ed12aea0b5a4935458f95c801c9','discokey:6a80e23d10d2cb3edb58c9c47ee997f9063d6aed2f29049f635b6bf1da090885','web-24','node048',15,'cli','null',NULL,'2024-10-20 13:53:33.831192385+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["101.103.129.11:50383","[3aab:52a2:b9d3:1816:5627:336:6c60:57d7]:13486","22.83.180.41:14147","26.126.135.206:7777","[8706:d109:5006:f832:dca7:58e4:4451:be15]:15180","177.4.27.29:60895"]','2024-07-26 08:09:56.608302315+02:00','2024-10-20 13:53:33.831387627+02:00',NULL,'100.64.0.40','fd7a:115c:a1e0::28');
INSERT INTO nodes VALUES(49,'mkey:13b8d4cafbdb8e9ab77928219aa57bf778878866ad8e6108b60aaab8dc8cec36','nodekey:17cefd68f8a9cc20b3d4fd93598f77ddfd6bd5a7e6e4b49861f9faad8623e0ef','discokey:939a04ddd2f9a24468e07ee7924dbb7a7662c1e8a1b67426f57fd48c7394448b','desktop-40','node049',16,'cli','null',NULL,'2024-09-19 09:07:18.28136023+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[19b0:8be2:708:d27f:4d3d:3c93:9979:e9e8]:50438","129.0.5.112:19015","[91e2:54c6:93fb:ec32:6ab4:186d:81cb:b815]:37323"]','2024-08-05 17:32:41.937626584+02:00','2024-09-19 09:07:18.281618912+02:00',NULL,'100.64.0.41','fd7a:115c:a1e0::29');
INSERT INTO nodes VALUES(50,'mkey:03979d5446bb3f596bf0234d81ca84482eacb132e874ceda6cc2703422cd728c','nodekey:805c03cada525f14ee90d28ea02b23a3f57b470c793314872ad9daacf6c6484e','discokey:eb4135e1cc73a3c6b513d8cc04ca0c55a2aef7b0009845fa1d2036488aadf0f8','desktop-02','node050',10,'cli','null',NULL,'2024-08-07 10:10:06.595550455+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9175:498d:64ac:4342:2eac:ffa1:99fd:d109]:21202","[5cba:56ef:db08:320c:333a:541f:605c:44d5]:57469","150.211.2.236:50360","203.180.122.83:13344","63.162.234.32:11653","[6b63:f552:f930:e22c:fc42:3b41:c5c6:6d5f]:63162","114.48.12.185:47837","[2964:cc5d:3a1b:7889:acc8:4d8:22c1:398a]:43515"]','2024-08-07 11:50:54.144157179+02:00','2024-09-18 16:15:14.050033969+02:00',NULL,'100.64.0.42','fd7a:115c:a1e0::2a');
INSERT INTO nodes VALUES(51,'mkey:5877139c52c0bf3c0fd054bd046aaf4530dd8946548a7bc1a06733649d1557d8','nodekey:553d9638c8c455e8d1bc811ea3af03db1eb3c586413447c8003e7d905a61d06c','discokey:1da883c9eff402d786362aaac2f478c835308b3acec0993e6293becf4474609f','web-62','node051',14,'cli',NULL,NULL,'2025-02-07 13:37:38.925095255+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["86.215.174.228:26026","93.101.159.155:64005"]','2024-08-07 14:19:31.156780417+02:00','2025-02-07 13:37:38.92600407+01:00',NULL,'100.64.0.43','fd7a:115c:a1e0::2b');
INSERT INTO nodes VALUES(52,'mkey:0e64072dafa5f9e49266b41fc4b21ff7d287be8f4e5f2b6c395487d632f1cf3f','nodekey:2f77bb8cbeb426bcded5ad9fc6da44b0b76b8d6759f10a8db28e634290760ee7','discokey:836558738056edd1fa8d190c7e42f120b365a48a3b1f1c96c87755bb82d7ad0f','desktop-07','node052',17,'cli','null',NULL,'2024-12-25 17:27:58.515851096+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d889:f751:710:257f:977f:5597:9908:14e0]:61162","[f83a:5ebb:911d:ef36:743c:8086:8a4c:a5c7]:23538","[dc45:365c:e426:71d7:fe23:fdd4:d2c2:9409]:57262"]','2024-09-22 15:48:41.385301399+02:00','2024-12-25 17:27:58.517153789+01:00',NULL,'100.64.0.45','fd7a:115c:a1e0::2d');
INSERT INTO nodes VALUES(53,'mkey:a6f93e99a5019b3b6a2941d95dc7fcbfea5a59317a48b99db93b7a3f4f0a65bb','nodekey:1f78a6d76ea4a2135c0da46b202560c86ed30cd7e8239d4508088d0e02ffb961','discokey:1744062452f052aba5320e37fc08aaa37f1430db7c32c94c5626f0f3c858de3d','desktop-82','node053',17,'cli',NULL,NULL,'2025-02-07 13:37:13.842388728+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6084:ee60:1697:864e:4a61:cf6e:e9b6:4c05]:63961","[fad7:2601:d286:4772:3cce:6e89:f66e:9eeb]:5430","216.60.124.11:45041","[d513:c472:d7a:f316:f610:10d0:9851:4feb]:3955","156.228.105.157:61542","102.126.185.0:50694","[156b:e934:d171:2693:8db4:f193:a58c:17b6]:24190","79.255.179.99:56057"]','2024-10-28 10:04:50.084492941+01:00','2025-02-07 13:37:14.011393166+01: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-02-07 13:37:15.059804316+01: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-02-07 13:37:15.113575346+01: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-02-07 13:37:15.324226266+01: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","[a5d2:373b:9599:8abc:6e7:2efe:f921:3a09]:56107"]','2024-12-10 13:56:39.287449662+01:00','2025-02-07 13:37:15.355747009+01:00',NULL,'100.64.0.47','fd7a:115c:a1e0::2f');
INSERT INTO nodes VALUES(56,'mkey:6b8c199041c26e52d594b6e9be9d4d9bb695d32e9fe247c84314b6809b8f38fc','nodekey:26b392e9f02b3910c5974f133282119f99e67ed084b4327aa818333e04010d40','discokey:8312bc333f55d0d6d7fc3e28dcb6300364c3008dff0cc64d2b480d5cba8260f4','web-69','node056',19,'cli',NULL,NULL,'2025-02-07 13:42:18.972640971+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5437:6f4:94c1:c6c1:43ce:7a41:e5c2:65d0]:57161","[7af0:3b83:a2ec:716d:bc46:deca:1685:e863]:26528"]','2024-12-17 14:58:39.429211911+01:00','2025-02-07 13:42:18.973110667+01:00',NULL,'100.64.0.48','fd7a:115c:a1e0::30');
INSERT INTO nodes VALUES(57,'mkey:edabd08e316b276318382fb96ca0ed40cf36f64c0a0de538295c0a69b0035243','nodekey:6576807f6b92bca841c85256b56daef25ab7113770f1db8ebc903d8b9de41308','discokey:a42e3f0759628634516ca1b4d4fa87450026af9101040401a23532a48ee07c76','laptop-31','node057',20,'cli',NULL,NULL,'2025-02-07 13:42:22.378213299+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[229:a09b:efd3:c73e:b885:d236:7dcd:20c9]:33744","[2de9:ec02:ffc4:1715:4d36:94f9:d726:fb8b]:55312","[72a1:a0b2:624a:827d:7d29:bd5a:3398:dbe4]:56924","[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"]','2024-12-17 15:17:14.26936913+01:00','2025-02-07 13:42:22.378739434+01:00',NULL,'100.64.0.49','fd7a:115c:a1e0::31');
INSERT INTO nodes VALUES(58,'mkey:06bd440cb68a2856dcab4ae09ba4c4e7969b78a99a1d06bbacebc9d1fba037b7','nodekey:c0a2b88f5f4b9aee6a50df28b6ff5e5c495053c26d969100ef23f13a51349bec','discokey:4023ff7bfd754262fe36745731a9d1175cc0b49d7acac56123cfbf0c633fa0c6','db-32','node058',12,'cli',NULL,NULL,'2025-01-25 18:41:03.881898904+01: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"]','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:837b21b2de65f931fa922fbc8fae0552beb9e5d5f3f089caa3b23e05e21afc9c','nodekey:2966f862ddc948ac6bec836f818b6af9717a5972128c20cadb0756dca94421a1','discokey:81f0e2ccd5b3292e6129c66588862e399a2e2685592f7e8b9e45254932532bf7','desktop-45','node059',21,'cli',NULL,NULL,'2025-02-07 13:37:15.162862529+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["121.80.178.149:12322","148.31.205.9:26021","51.210.182.192:52299","[2e30:4d2d:4925:201f:e845:2a12:503c:9524]:34552"]','2025-01-29 11:59:27.291048957+01:00','2025-02-07 13:37:15.166959448+01:00',NULL,'100.64.0.54','fd7a:115c:a1e0::36');
INSERT INTO nodes VALUES(60,'mkey:a8258e2d7302528bdad3321e5251beac7b920c0fd2be9a31ac541ceba25f868f','nodekey:f6dcffb992bfd5f22fd31752d1f450d79e68fd9d3a5d8c6002846d7c7e7ca780','discokey:5ce092b58afaaeac550606cb9ca49b9a82d8ec71c5bba6cea2727f3a6c51ed58','desktop-83','node060',21,'cli',NULL,NULL,'2025-02-07 13:37:14.448391309+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[9bc9:59d8:52be:2e78:c641:a523:6bef:7101]:9124","103.8.213.76:348","[ac:5c65:da8d:d68c:eb0d:3692:d441:5363]:63612","107.250.166.141:64587"]','2025-01-29 12:01:57.48748166+01:00','2025-02-07 13:37:14.48001932+01:00',NULL,'100.64.0.55','fd7a:115c:a1e0::37');
INSERT INTO nodes VALUES(61,'mkey:274b3c292aff1b069c84dcb1708adbf93c479a88eff35023edd1d42ff9d2f3a1','nodekey:ff576e5a5d91943d1b95cc0bd0d02edf9ce965b04f4d55cf44cbc328a46e81e4','discokey:da967cf6cf6122fb4c3381342341fe2013bbb02592871a6a4875c0f2ed088497','web-95','node061',21,'cli',NULL,NULL,'2025-02-07 13:37:18.210665072+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["97.178.200.54:28664","112.239.138.73:43954","174.168.204.29:5611","190.0.61.36:13730"]','2025-01-29 12:03:01.464646336+01:00','2025-02-07 13:37:18.211304165+01:00',NULL,'100.64.0.56','fd7a:115c:a1e0::38');
INSERT INTO nodes VALUES(62,'mkey:55fead8ba87f06051dbc7eb41fc9263832e89a23587dc5161f4caa73e52b86c2','nodekey:ce19e593db9037b1ca155c2eee3628bdadf18183e7bb2c2e8452c490a4a70fc6','discokey:3fe7586ae2c3942956fa5929c628519dd776326bd41941bf9c4ca67c20b39d39','web-47','node062',21,'cli',NULL,NULL,'2025-02-07 13:37:15.119660489+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2476:14e8:ab74:a221:cfca:bd5e:64aa:83d1]:48008","203.192.235.192:35390","30.40.23.45:22912"]','2025-01-29 19:23:14.092804852+01:00','2025-02-07 13:37:15.125730738+01:00',NULL,'100.64.0.57','fd7a:115c:a1e0::39');
INSERT INTO nodes VALUES(63,'mkey:375546b6250c3cb141b036b348e902de244a8572dd7572422e95e36a6f6e4db8','nodekey:4fc64d645299720f14481c889ecaa1f08e48a3b83f19ece638b7d4d9d00bf75c','discokey:404b99d3c51100cd92dcf7caaee677b9c3f5371070504f0848759bf792ce1ed3','lt-21','node063',21,'cli',NULL,NULL,'2025-02-07 13:44:32.21661957+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[68bb:e8d1:72d8:8b02:608b:2284:c9b3:184d]:20876","[5c17:4014:ea6a:5528:b1a:61b7:5cda:5c5e]:21597","22.244.181.59:21123"]','2025-01-29 19:41:40.535299057+01:00','2025-02-07 13:44:32.217372195+01:00',NULL,'100.64.0.58','fd7a:115c:a1e0::3a');
INSERT INTO nodes VALUES(64,'mkey:ea810305395687d011a783dcd058cf511363eb4d5638eeeb6886b7f5e690482e','nodekey:c5b9b10d988bc237815f7c98830abfb86981972949898f2ce9a1451a7bc617bc','discokey:1e0c9544833ff8f89685b81f2795c330500d8d414f856e0e9f4ec439e3c76dad','web-27','node064',21,'cli',NULL,NULL,'2025-02-07 13:40:53.575919211+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[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-30 18:18:57.519126133+01:00','2025-02-07 13:40:53.576418189+01:00',NULL,'100.64.0.59','fd7a:115c:a1e0::3b');
INSERT INTO nodes VALUES(65,'mkey:fe494a29de4149025e3c41744cabfaaa2ae9a95795bdb6425e3beee27048e0f6','nodekey:2b078ccb547dc8b01f19749735f5fc43e65e4d468357a08a880fa54dc0a1e00d','discokey:cb991d6c0a14b0213e6f807e9c37a837b181c889a1e2d25e10d65d4a7e8b2b05','laptop-33','node065',21,'cli',NULL,NULL,'2025-02-07 13:44:09.41583007+01: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"]','2025-01-30 18:19:40.354692307+01:00','2025-02-07 13:44:09.416328169+01:00',NULL,'100.64.0.60','fd7a:115c:a1e0::3c');
INSERT INTO nodes VALUES(66,'mkey:6c97e6102fbb96b98090402e9414b0d8e2e5ded0aa8cded7ebae64da5c2518d9','nodekey:f2d5b51602df1f8c57ab59973c100919b7f84bdc09386d43ad49fa30d6595e38','discokey:15d3ca06419e377b06e2e0a3b36d53f5b448087f9609c73a128429e17c88102c','lt-62','node066',21,'cli',NULL,NULL,'2025-02-07 13:41:35.878248155+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["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-02-07 13:41:35.879388156+01: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-02-07 13:42:35.535333727+01: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"]','2025-01-31 12:06:30.121464114+01:00','2025-02-07 13:42:35.535828442+01:00',NULL,'100.64.0.62','fd7a:115c:a1e0::3e');
INSERT INTO nodes VALUES(68,'mkey:b1f44437d8d3550b23e7d3a79e6fb1c2649a48c2566d95dc308b78e56a1ce2f5','nodekey:17d7b53b408bcc2459fce9db6e689099b7a99de8ca26be948f2a0eebf71970c7','discokey:2af8a6603509410d88c13a6d39763e0109e8f422f27fc8da08d2e256dd7569b3','desktop-87','node068',22,'cli',NULL,NULL,'2025-02-07 13:37:14.673907509+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8ac8:a469:4cc:90b5:c84b:f4f:5cb:49e1]:35646","[d152:3a18:3826:ee28:a323:74d6:7140:ca5]:40749"]','2025-02-03 14:16:55.56431345+01:00','2025-02-07 13:37:15.115578974+01:00',NULL,'100.64.0.51','fd7a:115c:a1e0::33');
INSERT INTO nodes VALUES(69,'mkey:0a0aec355a4e4e478a9e73ac6141c7882ab29d1d14da893ba7442acc11bf6cbe','nodekey:5c3cbe65b07b0676fdc9eef42acb6f0a56196a20fa82d34429b6adc878aa4d0e','discokey:f813981e0cdb97880468aa23f9745b4b3ca367e3e9eac72c6631b8e2530a822b','desktop-75','node069',22,'cli',NULL,NULL,'2025-02-07 13:30:51.951476674+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[443d:d8da:884:82e4:de49:13e:8449:d06d]:43135","152.191.25.57:54747"]','2025-02-03 15:23:16.312084161+01:00','2025-02-07 13:30:51.951819286+01:00',NULL,'100.64.0.52','fd7a:115c:a1e0::34');
INSERT INTO nodes VALUES(70,'mkey:fa142bd90a16d891af17e0732fc3060af64e41d0ad7f0024afacbd941a538f88','nodekey:2ad7938dba6ec89f4d73dd9d8558d15efd3ef3b5b752a90e40a064835c073fc2','discokey:31457c9296771d81dd053d962b86845adc3ab09ae53f9ed42be57037a0ea2368','email-13','node070',21,'cli',NULL,NULL,'2025-02-07 13:37:15.228318848+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["7.34.191.227:52597","200.133.152.206:14119","28.101.69.72:35202"]','2025-02-03 18:09:35.161109801+01:00','2025-02-07 13:37:15.245827564+01:00',NULL,'100.64.0.53','fd7a:115c:a1e0::35');
INSERT INTO nodes VALUES(71,'mkey:fc9d5a1c4658644beeb3130cf62b19042698652298ef36899d41f588bec371ab','nodekey:d44ef585e416773d29e627cf9a6e590af9b676d23a0a816865d05d775517ab4b','discokey:0c87d487f7a4f4ec5e045ff0c83c1b6c54453f7afe0e5f13c7ce90746e18da49','lt-48','node071',21,'cli',NULL,NULL,'2025-02-07 13:37:36.853568516+01: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:03:50.32663805+01:00','2025-02-07 13:37:36.85423361+01:00',NULL,'100.64.0.63','fd7a:115c:a1e0::3f');
INSERT INTO nodes VALUES(72,'mkey:a46b92cea88a9bac37dcb612a4a50dee75684f736c8c7f2aab812fa5fb9d463f','nodekey:1bbfdddf7b2a929a3da1e69236aa8b8fbd4b25d1839e57aaecf2ab910592bc78','discokey:c2188df6632aded7862de4b5d07c3993b3e908c59ce38f9d481f4840d85448c7','srv-06','node072',21,'cli',NULL,NULL,'2025-02-07 13:37:15.252280835+01: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-04 12:07:36.231437299+01:00','2025-02-07 13:37:15.256879188+01:00',NULL,'100.64.0.64','fd7a:115c:a1e0::40');
INSERT INTO nodes VALUES(73,'mkey:2c018031737bb172064fe31674acafe1b8b4d62d2b82db835e2c38061c5bfdbb','nodekey:575f781bb36f7c93cde4d9808e3dedef2c8999864ea1d4e5ee73fdd3d53ac217','discokey:00e3275941e7a0a73a1e5c44cea638a411c60bb2e257812e0f39152ec0c5a21b','lt-01','node073',21,'cli',NULL,NULL,'2025-02-07 13:37:46.354359607+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["56.80.126.49:13907","95.196.223.110:47343"]','2025-02-04 12:10:26.50545127+01:00','2025-02-07 13:37:46.354928354+01:00',NULL,'100.64.0.65','fd7a:115c:a1e0::41');
INSERT INTO nodes VALUES(74,'mkey:a5a8194cef984a1cc2081212405c10c8cc1061d3d00e6aa7e1415c854e3ded72','nodekey:ca37a131e58c14ebec3a6e179549d7c8742a31b42ed0e6e52aed138ecc176907','discokey:8a4990c19c547da50875ad00613118d5382717652b4ef9897a1d1c060c40a976','laptop-71','node074',21,'cli',NULL,NULL,'2025-02-07 13:37:15.235404491+01: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-02-07 13:37:15.238509319+01: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-02-07 13:37:39.952195811+01: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-02-07 13:37:39.95290257+01:00',NULL,'100.64.0.66','fd7a:115c:a1e0::42');
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,'','');
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;