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

125 lines
52 KiB
SQL
Raw Permalink Blame History

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE `migrations` (`id` text,PRIMARY KEY (`id`));
INSERT INTO migrations VALUES('202312101416');
INSERT INTO migrations VALUES('202312101430');
INSERT INTO migrations VALUES('202402151347');
INSERT INTO migrations VALUES('2024041121742');
INSERT INTO migrations VALUES('202406021630');
INSERT INTO migrations VALUES('202409271400');
INSERT INTO migrations VALUES('202407191627');
INSERT INTO migrations VALUES('202408181235');
INSERT INTO migrations VALUES('202501221827');
INSERT INTO migrations VALUES('202501311657');
INSERT INTO migrations VALUES('202502070949');
CREATE TABLE IF NOT EXISTS "pre_auth_keys" (`id` integer,`key` text,`user_id` integer,`reusable` numeric,`ephemeral` numeric DEFAULT false,`used` numeric DEFAULT false,`created_at` datetime,`expiration` datetime, `tags` text,PRIMARY KEY (`id`),CONSTRAINT `fk_pre_auth_keys_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE);
INSERT INTO pre_auth_keys VALUES(1,'463a8b372963aeaca12400faa0c7ea29e9bfa3b4c59e9622',3,0,0,1,'2023-05-19 05:09:19.66636462+00:00','2023-05-19 05:14:19.664224869+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(2,'77a019cb12c0d0b9347a17ab23fa4c87983814fe36bb2fbb',14,0,0,0,'2024-05-03 08:13:55.8614948+00:00','2024-05-04 08:13:55.85782156+00:00',NULL);
CREATE TABLE IF NOT EXISTS "api_keys" (`id` integer,`prefix` text UNIQUE,`hash` blob,`created_at` datetime,`expiration` datetime,`last_seen` datetime,PRIMARY KEY (`id`));
CREATE TABLE IF NOT EXISTS "nodes" (`id` integer,`machine_key` text,`node_key` text,`disco_key` text,`hostname` text,`given_name` varchar(63),`user_id` integer,`register_method` text,`forced_tags` text,`auth_key_id` integer,`last_seen` datetime,`expiry` datetime,`host_info` text,`endpoints` text,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`ipv4` text,`ipv6` text,PRIMARY KEY (`id`),CONSTRAINT `fk_nodes_user` FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE,CONSTRAINT `fk_nodes_auth_key` FOREIGN KEY (`auth_key_id`) REFERENCES `pre_auth_keys`(`id`) ON DELETE SET NULL);
INSERT INTO nodes VALUES(1,'mkey:0ea01e8cd608548a171ebcedc16da73b25ec18d58861be7a6b4274eb17baf6ba','nodekey:0fcf591dc1997c1d7388a3835bd24dae48240e5b03b6a7f5f33b2e813d222bcf','discokey:ed27f0b3c04222f0d05bfbc6fb5787338275ed0e32fd42fe68c669aca0f3d7a4','desktop-54','node001',2,'cli',NULL,NULL,'2025-02-21 16:47:31.967030967+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b8f0:cf44:22c8:82d1:f79:c3eb:9144:c24f]:6142","[8e25:af1:e31a:8fcc:7dcf:be1:a3c9:ed6a]:38766","[37a1:215f:bf3d:3fb1:6399:f7cb:4048:3ca8]:51666","137.242.125.72:25376","86.84.184.63:26062","[c187:a8:1181:8321:28ab:fe72:b0b8:8ec6]:41236"]','2023-05-17 19:38:13.531518257+02:00','2025-02-21 16:47:31.967134366+01:00',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(2,'mkey:77e0289c8c37caae9d3d7b6c851db0beb9e47fc8854dbe2d5bb0d7a33d377c56','nodekey:7b550e852203d47984bce22eaca3a6a738e711869c79932b087b848cf33c8065','discokey:d1a6b93cedd0e850997eeb0ff84be2d169d15b8b29192dffbf49dea812d50874','web-87','node002',1,'cli',NULL,NULL,'2025-02-25 18:07:33.299494262+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["149.96.226.131:35537","84.23.188.83:48876","44.184.117.89:36643","90.223.136.253:7056","[e43c:be7:7f4e:8217:a009:7f9d:a510:1af6]:18872","[3a86:865b:2f4c:f3b7:88a0:4aa2:f05d:c3fd]:47680","86.50.30.30:18216","[fdbe:7908:805e:6c8f:47c2:2c87:b1c4:44]:48470","188.237.187.170:7622"]','2023-05-18 10:09:21.757289398+02:00','2025-02-25 18:07:33.299970499+01:00',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(3,'mkey:538f91fe9e485697ce13f9444ee0dadf2aaaed712fdfa03ba102113c6505db37','nodekey:1936bdc567d6758b11b2cc06ea7ff74bb933a44421fb17323965d5a402e39783','discokey:e8b762a384d644175f3b4e4fd36867b2c435e03eb0bf6b9e7ebd4f0ce83c13ef','lt-57','node003',3,'authkey','[]',1,'2025-02-14 06:23:29.821940467+01: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-05-19 07:09:21.399903526+02:00','2025-02-14 06:23:29.828817276+01:00',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:12afa721b0310fd9cf7501a19e5f23a2d33c87f989a9b0233bc09e8eb9e5eaa2','nodekey:83e8f99465cfd0ef79190bfb341bb742b39d9ddd7cfeab237153b58858a2fed2','discokey:d4fdc314c7b73e21589efef171f10158379ade1adbdc281482a62c6c20fc2ed8','lt-50','node004',4,'cli',NULL,NULL,'2025-02-25 18:57:43.626901249+01: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"]','2023-06-10 09:31:51.940506933+02:00','2025-02-25 18:57:43.62738857+01:00',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(5,'mkey:517d332699122618020754ebd6b7aa342136392cbb3186a181c32bad87cfa666','nodekey:ab36644fc8e56ce3816124f4e51be0a2e74505b0b6669ec7dac0001ec3774bf5','discokey:f1413ef26f1c11540e6d0b3f8ae7124e8b2eeffc9a330016cab23036f5b4fcf6','srv-15','node005',4,'cli',NULL,NULL,'2025-02-25 18:54:08.745255864+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["66.84.158.199:63451","47.94.115.240:6677","19.74.30.92:1284","213.110.62.40:49373","222.60.90.114:9445"]','2023-06-11 13:56:42.694329408+02:00','2025-02-25 18:54:08.745544477+01:00',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(6,'mkey:cc260b25fa19bf6d04469bdd96eab67578ec80bb0f2c4e3c4e188050951f8ff4','nodekey:d2730f52d9efa38cc46e37ba658c8bc6df42a4dac4b4fa3a9cc7f284cc1a17a0','discokey:665b19ab4efaa1bdbe9cf27d21a57be739c2713ac442f6342cfc988e410d66e3','web-56','node006',4,'cli',NULL,NULL,'2025-02-25 18:56:58.143735821+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[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","[e65d:59b5:f599:8596:2bc9:56b7:820a:8c12]:12277","[8ddd:4aae:2b94:4c1a:d05f:65d2:2bdb:b400]:42839"]','2023-06-11 13:57:44.975695604+02:00','2025-02-25 18:56:58.144115128+01:00',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(7,'mkey:b1d6228a1bad37f4e8491772fe83a3e7e4832fb93f8a7aeef1fe97a1a1ec6ee0','nodekey:f352383d311b4f323d0a5ae82c06ac24230a6a98671f00b09a2300c6d7413b36','discokey:92304c75e1c7d328f4445ac6f278f66244f11b66ac6e89060b498b0fe122f096','desktop-85','node007',4,'cli',NULL,NULL,'2025-02-25 18:57:34.843267809+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2e31:d5e9:a2fb:d204:f840:3746:7248:ba38]:62726","[cbb6:53d4:54ce:cd07:cef3:87ea:7ebe:e5a3]:12262","[bb94:d03c:901b:a7d6:d7d:955d:7df4:1c2a]:24266","[489b:6c59:1877:6215:ddc8:57f8:78dc:321c]:3025","77.213.161.20:47662","[adea:86d3:b312:f445:d835:6023:f1f:f928]:27483"]','2023-06-11 14:16:56.951313537+02:00','2025-02-25 18:57:34.843605919+01:00',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(8,'mkey:1ec07ddb5eefc8bf45fc902699a9b656dc6c4be81224aff81ef4b14990f02b76','nodekey:f2ad6282c57e4ac666137b69e68805d137e0d002eb05f6173a76b38965b5a877','discokey:6bcc988157ed256c25d0487285b8bd02379ece8f0292608f80f4e4ccfaeca269','desktop-82','node008',5,'cli',NULL,NULL,'2025-02-25 18:58:08.246285374+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["31.85.36.236:46674","[80ab:9956:c1bc:b242:cd97:6bb:52e3:10fb]:47368","[4ddb:3188:c8f2:6122:e983:bf33:d2d4:74bf]:25781"]','2023-06-11 19:59:30.401970393+02:00','2025-02-25 18:58:08.24660639+01:00',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(9,'mkey:f436d5d56dca10e95dac89d2d2b10629a7d1888543378d56d6a66c4ed5e8acbd','nodekey:200327faa3d157c1ab859e71a27bfd52642b863352a219146e7fcae245b0b35f','discokey:08d0b384d256d12f19297672b41d62b87174af0b8332602760dd6615f8ceb796','db-78','node009',6,'cli',NULL,NULL,'2025-02-11 14:57:51.798862802+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f78c:8abc:854e:670e:1d14:fb13:d0a0:ad7a]:33635","41.172.94.101:32111"]','2023-06-17 19:40:45.468789461+02:00','2025-02-11 14:57:53.417438918+01:00',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(10,'mkey:628fa7eba9bc1474eeb62eedf4e6b7e5b970a3acaeb2e020f4de7bd2aad547ef','nodekey:c105625e67654c70809a72beddc9ab34e7da931e4e7b72784c5d2781acbfb9c6','discokey:0d7060f2779a56c357749e61ba7b1cbd03a0d0d8397c9989c54087e1a80b5224','web-49','node010',6,'cli',NULL,NULL,'2025-02-25 18:16:38.447549074+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[69bc:fe73:f6c7:31b2:bc4f:1a95:4676:201d]:4806","[d794:c918:b0e8:6023:d7cd:709:79eb:23f7]:56801","113.147.88.203:61138","22.207.212.228:27547","[2c3e:2260:8c34:275:2287:b721:1bdb:d462]:59540"]','2023-06-20 11:18:35.905417341+02:00','2025-02-25 18:16:38.448089273+01:00',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(11,'mkey:4d2ff8526b10e056a5d073d5640fd28002ca21b561c55407175712a98e37ada7','nodekey:a1835798e4fefbece3000abb9afdd3cb01e5a4eebafc1218ed627cde2175c1f1','discokey:24b8f6da3ef9e024e273918de8869fdfebc45f789d14c4a50a592cc27259f1c1','db-64','node011',7,'cli',NULL,NULL,'2025-02-25 16:12:02.791603536+01: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","56.63.78.181:15200"]','2023-06-20 11:35:15.063855316+02:00','2025-02-25 16:12:02.791828881+01:00',NULL,'100.64.0.11','fd7a:115c:a1e0::b');
INSERT INTO nodes VALUES(12,'mkey:80fb6f55cbac10695c455ecd74fdd59ae5e804ef27a53085450e713eb6afc4ad','nodekey:8b94382fa21050586620d8a5ee69649c9e854b3dfe06f1341e85768a0f6a1185','discokey:27c408f43b0d0857a1897d995513d907107d8e6f04c6a3bc5826d066324f2303','email-92','node012',5,'cli',NULL,NULL,'2025-02-25 18:57:33.682368055+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[743f:8ead:64df:d533:ccdd:f29a:254:97ee]:41637","[f780:17d4:440b:f400:cb10:dc8d:5698:e318]:37997","33.51.84.119:46756"]','2023-06-20 18:22:35.061914624+02:00','2025-02-25 18:57:33.682775689+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-25 14:45:50.465939403+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-25 14:45:50.466242342+01:00',NULL,'100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(20,'mkey:157706346bfe3502b6e24a84efa59b1a151be08f5a260ff96c72a734c1da1390','nodekey:139a99de286f52c55bdd61e932827c9d7cb84101a698df3576bdffbeedbf654d','discokey:293abc1a1cf2921e7961f5753cc39097956648bab47879791afb12ea03a4e6dd','lt-42','node020',11,'cli',NULL,NULL,'2025-02-24 19:54:14.700663055+01: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","[7b81:52eb:f4e9:e74d:905:79d4:67b1:d359]:13795","81.17.18.155:10091"]','2023-07-10 12:40:34.838579199+02:00','2025-02-24 19:54:14.700825212+01:00',NULL,'100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(21,'mkey:8bc474d6d0d812ab011b7748675802bd9d4af70c2edab0da6c682a0cf1ca34f8','nodekey:2cb4a0ab98e83dafb20621dcfec33cd5fa7fa99b97998546cb6796249bdba88a','discokey:e341e99f352acb61779807aea844516d7e9e220c58699f09232bcee105e88797','lt-43','node021',11,'cli','null',NULL,'2023-11-20 07:19:19.447470862+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["63.3.67.150:22907","[77ac:562:7c4c:438a:6ec:be48:743d:47b1]:11349","[33cd:731c:f110:9b45:66b5:de81:1daa:757f]:5997","[d618:5830:8a37:fbe4:3b37:a35c:fad9:11d1]:57112"]','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:170eb5e825f19f37d8e8747d888a79962d96acab073459e889d64d906e9a4a7f','nodekey:722321c00084d0152c13e34375b006f3ff2b95507685d13aa2df04093561df8b','discokey:c0463a2785b1741b3ce35422310ccd59f55edee22f5b64fdada2a95abfd0ae74','laptop-89','node022',6,'cli',NULL,NULL,'2025-02-13 18:41:19.151025389+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["194.185.67.128:22758","[722e:3c42:d444:e150:3b32:135c:68:80fa]:3684","132.110.176.16:63801","168.165.127.136:13273"]','2023-08-05 12:08:48.132161695+02:00','2025-02-13 18:41:19.151860126+01:00',NULL,'100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(23,'mkey:0ac434671e1b07546381d5dd36d4e04dbf7a098f226d7173e4b7e766c18283f2','nodekey:dc35ef6da42fbb0f4b90e5cf935b0012ab62fa61016b17d8a3a24240004fa3b4','discokey:5f7118e434c174dbac710b1d088db6213ca894ca3912a92688110ed5f96eb37d','laptop-54','node023',12,'cli','null',NULL,'2024-12-07 19:25:56.935152754+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["146.144.83.178:46323","1.236.14.11:13477","184.41.32.72:1026","[f136:8b69:185a:7ec7:94a1:ca58:5d95:ba9f]:21119","51.158.48.68:23441"]','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:27effcc5ab9b8bc295f0a76a09e753e7bb6b0c4c33343f59635494e1d717c82c','nodekey:c663007fc1b770065de8303e6bcd9ad7184c345795625591c3e0fe8304b6c29f','discokey:0de43076bf8295b5281d848e1515c304e3f541d5b10b9160fea430a6272ab160','desktop-77','node024',12,'cli',NULL,NULL,'2025-02-25 14:31:30.623705545+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2b5d:522b:8ced:49a8:d0dc:bc0a:81ba:7f84]:30767","212.18.227.41:50735","[f774:e89b:980f:975d:fd3e:93f:a9b5:2034]:46054","[7225:d0ce:d29a:59d8:f596:b945:9a02:29ed]:43419","[5a76:d5b0:b51d:6b56:afaa:3968:277b:192c]:19250"]','2023-12-15 11:14:36.765183054+01:00','2025-02-25 14:31:30.623800675+01:00',NULL,'100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(25,'mkey:247cad9ffd7d108f553e7658db14bbad992332458abb9b4bc5a0c0d3a13ead9f','nodekey:bbfb569ac8a34cf4d59d2bc13d0f03660d24aedf22c61b56510a65d20bdf0812','discokey:61f92520602549b9bc684eeed3186f608a38e13794d06d4b8d165c4efbb69a24','laptop-29','node025',6,'cli',NULL,NULL,'2025-02-25 18:56:13.569853699+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[5b7b:e424:ea77:aa8a:f835:d6bb:2e1f:52ea]:19152","[bb06:d322:7cec:426b:ef38:55d0:e7ce:95bc]:31597","[320d:6314:eaa2:a098:8594:977d:27b:8442]:12827","163.235.127.125:61230"]','2024-01-05 17:32:40.940566279+01:00','2025-02-25 18:56:13.57010639+01:00',NULL,'100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(26,'mkey:d623495ccdc12a3f219322cf53458a85c29b8795ceff5cef5338bb9c26e329dc','nodekey:781ad44c939f14168ec1c22c3fa2c5422f5ff1a5b0fc163fa80e6ace4e20c4a2','discokey:c474b4d7b9883e70466b6240b885a2a71dbe6efb0e8c84b85277beb584f25690','email-47','node026',6,'cli',NULL,NULL,'2025-02-25 18:57:44.753081033+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["173.144.3.182:33138","[975a:978:5cfb:5e5a:1b6:d272:a1c1:50dd]:3245","[e6e4:7cfc:9ce:b47:62f5:b64e:d2e4:9015]:42369","[26c6:541b:69af:974a:8ea8:6bd0:7c4d:5a82]:10571","[c898:1525:ebe8:704a:243b:de9d:b8c:ea69]:22747","32.167.123.100:57075","[2c67:a9f3:3163:c675:3386:2447:1cc:ed3a]:42590","64.137.67.1:56198","163.42.128.241:47535","49.160.22.202:42427"]','2024-01-05 17:34:19.811670479+01:00','2025-02-25 18:57:44.753480656+01:00',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
INSERT INTO nodes VALUES(27,'mkey:dc2bfab4553c0294e57f034001e3d575413ee8b0622e788050341c29b702f8e0','nodekey:9fd699021ab41ed4911faade849d0d702debfa1ef735a60eff8c1cae87b820c3','discokey:dc9c5f140c9ab0afaf55756f956a5fb53466ac0480c395aed0a4b481cc775679','srv-61','node027',6,'cli','null',NULL,'2024-01-16 14:32:21.570104175+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a542:b648:e2d9:5461:2ac4:6b34:77a8:ff65]:55609","106.52.35.144:41091","[537d:7a83:c891:ac8:9460:e49:e769:988b]:55062","50.23.199.223:4814","[a2b8:ea55:f9e3:2c00:f423:8c56:7fec:c617]:53793","[ed88:2277:3c9a:4f64:a25e:5b41:a3ca:e904]:27852"]','2024-01-05 17:48:25.466030859+01:00','2024-09-18 16:15:14.040766068+02:00',NULL,'100.64.0.22','fd7a:115c:a1e0::16');
INSERT INTO nodes VALUES(28,'mkey:08347db9fbe8e5e7a968c2ab9ddd1ff530ea98163c0bab7769316307545f4d46','nodekey:b6b03efd7deb52dbe0298708ea37400510ab7589b0b1787eac1a5f9b50aa7c80','discokey:6a0ab2f3329d9fe5f50c76f9f3f1d2e797574af93d823a511df57f45414f647e','srv-42','node028',7,'cli',NULL,NULL,'2025-02-25 17:11:29.962245449+01: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-02-25 17:11:29.962361262+01:00',NULL,'100.64.0.23','fd7a:115c:a1e0::17');
INSERT INTO nodes VALUES(29,'mkey:4a6e46330ccd4b3026337cdef37485c27592babda329107565c2a19d97253dcc','nodekey:17de47da1955a8a034788ae671c34fb10083568bf9e2f7494276cb2636065246','discokey:449f5f35a3507974cf03e3ac5c055d890de5122f57a7c2d84a0d3b324998607e','desktop-17','node029',7,'cli',NULL,NULL,'2025-02-11 14:54:59.936098654+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c2f1:82ab:922a:9b9d:f53d:a0b3:bccd:f6af]:299","[d28b:7b33:1f88:7583:7ed7:a923:4c90:9ee0]:62318","[68e3:a070:f02c:708c:a057:b579:aee9:4d25]:11747","[7224:b76a:cd04:e6d2:67fd:fec0:2f14:1837]:29002","173.82.71.57:3159"]','2024-01-15 15:18:12.2871978+01:00','2025-02-11 14:54:59.936147608+01:00',NULL,'100.64.0.24','fd7a:115c:a1e0::18');
INSERT INTO nodes VALUES(30,'mkey:26f1059c45c12a8e56cd57ba6db33dfe104eac76103327af49622cb7810fab7d','nodekey:b157bbdc37aa4634b8d69d6fbc7670780fff69337713176a11f893afafa2a9bc','discokey:4c8c175d0e61ca8f7b2de92a1033cb9be95eaeaf09e9395c767afa5afdf2d9b5','desktop-64','node030',7,'cli','null',NULL,'2024-02-05 12:14:40.065688294+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[8a1a:5c17:bb81:bb69:c7db:3513:f14c:ca2d]:52077","123.235.220.59:59925","155.210.184.45:60093","[963:536a:33e9:99fb:c204:d59c:29a8:ac18]:39005","[e84c:35c4:4bd9:a100:c271:8921:ca7:5901]:21828"]','2024-01-15 15:21:43.217136004+01:00','2024-09-18 16:15:14.041757308+02:00',NULL,'100.64.0.25','fd7a:115c:a1e0::19');
INSERT INTO nodes VALUES(31,'mkey:ef048095dd3e937a8617f18797ed42d2c4513d07126dc419a466f257982113d1','nodekey:1c6c367df9b85ab5e1618c70c0a4f8b22e2eeea77523b40059c3ebfef0f4057f','discokey:80fb63a98202437504c700e582eddf800b02dc654577bb95796c60cdf1176793','lt-55','node031',7,'cli','null',NULL,'2024-02-22 08:35:27.098819037+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[cc02:5592:3738:a2ab:8c55:97bf:a5b8:24e6]:41616","129.130.98.189:47833","[99c0:d769:2f38:10e9:c01a:e3d:898e:afc]:17505","[3423:afbf:aa2:e156:81df:bbd3:412a:df65]:5125"]','2024-01-29 16:05:35.338524634+01:00','2024-09-18 16:15:14.042191514+02:00',NULL,'100.64.0.26','fd7a:115c:a1e0::1a');
INSERT INTO nodes VALUES(32,'mkey:5b0e391e12914bcbcc6b415d9dd72937d74f9ce92a22c6ec938eb749962ee6ce','nodekey:4fa73acfb54cb140dad6b02bc853f6360f5ed160f819dc57701ad9a4caae9782','discokey:d3e90723a3b90eea513e7710ccaf25f68c0a2d60a85e3d4b9e4385335fddf8e9','srv-15','node032',7,'cli','null',NULL,'2024-04-09 13:59:43.37062537+00:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[14bd:ee53:6776:c1c0:124a:efbf:38cc:b312]:62180","85.234.248.186:20429"]','2024-01-30 10:41:58.31917869+01:00','2024-09-18 16:15:14.042506082+02:00',NULL,'100.64.0.27','fd7a:115c:a1e0::1b');
INSERT INTO nodes VALUES(33,'mkey:ba179b51f3540e619eaac9a6d4bc67403daa7c3cf28a6b579087cd6d284501b4','nodekey:246fadfe2a3606f043aca1fc1fa31b79e9eef9c21ec67e72425e05576707b3c6','discokey:5c64c1a08b88425b6e1e2971f950708d38f951d2d5eed2b85df8dd7d1bb88a44','desktop-32','node033',13,'cli',NULL,NULL,'2025-02-25 00:23:14.381890489+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["106.67.113.92:45634","85.199.78.110:6716","[bc29:715c:cdce:f1f6:8630:4929:ea1e:5c03]:10918","[af8:f5e8:32f0:75ee:d351:c0e9:78e:93d9]:12624"]','2024-02-03 16:33:26.706408143+01:00','2025-02-25 00:23:14.38239676+01:00',NULL,'100.64.0.28','fd7a:115c:a1e0::1c');
INSERT INTO nodes VALUES(34,'mkey:6fe02bbbdd40bb09e8aa74cf66b40b5b94f227690fd804a33242f56e18bee64e','nodekey:acc333e66d45e660ff4a31a152340d391547ebef1056f5f046624b629389bfd3','discokey:cf4a1217f85585d74fc5138af6ed9b78a29a9d4f12ad2e1beac660816d8c7b3f','lt-74','node034',13,'cli',NULL,NULL,'2025-02-25 16:49:04.386505728+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[1092:57ce:a60b:141d:ba79:79a3:91ed:66b8]:11037","[f766:14e5:6acc:ba40:8b28:59b7:ef7f:cd51]:46293","[c:e6fc:18ea:2e45:6bef:c1c1:f84e:b1e2]:62296"]','2024-02-03 16:42:32.683785672+01:00','2025-02-25 16:49:04.386771772+01:00',NULL,'100.64.0.29','fd7a:115c:a1e0::1d');
INSERT INTO nodes VALUES(35,'mkey:f95240eb788522b37f5513f0253f8bdab2ccf7594ffbf9bb77945fd67e598c05','nodekey:f5a6f47f5a34b4f4c6883e46fb52c0a5f7ca2ce17397cbba751efa8736e0066d','discokey:4dc728a0c0de0ce87530a47dda426d5bf6ad1b2f6cdefcc819c29c1015c3131e','web-44','node035',5,'cli',NULL,NULL,'2025-02-18 17:59:56.043915212+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["136.113.252.147:325","139.180.210.231:32286","171.29.58.211:2336"]','2024-02-03 16:51:52.010016072+01:00','2025-02-18 17:59:56.044175137+01:00',NULL,'100.64.0.30','fd7a:115c:a1e0::1e');
INSERT INTO nodes VALUES(36,'mkey:8ac09adfe44b8e60665601726c99627216e71b49ef7e8cc58ae6ba4f997c8652','nodekey:62d8af3310a7f27d84b931eaaa7ee110fe7fe46ea3ca8c817e47b9ce456c9b4a','discokey:bd31ae97729ac879d9b57866a69abb521248fb7fd5663d2149857d4dbf023d85','web-93','node036',13,'cli','null',NULL,'2025-01-19 14:01:48.956567669+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[7e9e:219a:507d:d3d:cc77:6195:7ce3:b30e]:25018","203.251.190.122:19081","49.144.40.103:7674","[a641:3f06:63bf:b716:4658:1e5b:ac6f:e14]:13490","197.206.147.31:58506","[b1e8:68a0:4017:a243:61d0:b303:7860:18e]:28633","[e5b8:6c78:ce2f:cf6f:13fb:401f:8223:3f04]:54121"]','2024-02-09 12:34:57.879970954+01:00','2025-01-19 14:01:48.956830267+01:00',NULL,'100.64.0.31','fd7a:115c:a1e0::1f');
INSERT INTO nodes VALUES(37,'mkey:c371756901cab84ae432a7d201e47232b008ef55effcf90341f24de7dfc55bb0','nodekey:0f858ae8a6492e1cc63fb502c6453ae90e8723f8b4ea8eba8c67f9f5114dec39','discokey:b6fc59b2a9ec7ddf1ae9573245cd3271259f964cdd730b811fabb019eccb3c81','db-47','node037',5,'cli',NULL,NULL,'2025-02-25 18:57:09.0895949+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b8c2:c792:3329:2c93:f94b:a948:7d11:b9f2]:908","[5925:353c:bd9a:f42e:1916:45b4:c170:e515]:18400","[c2a5:cc2f:e2e8:573f:7b01:4aa:8a1a:fd71]:32146","193.82.125.68:38601","[e9da:1552:e478:f920:c3d6:ff41:9e86:e27e]:48481","[c31d:dd18:321:589:11fa:d85b:695f:1fca]:43064","168.4.78.117:48474","90.45.218.0:29326","90.233.46.138:29846"]','2024-02-27 12:14:40.452601042+01:00','2025-02-25 18:57:09.090070104+01:00',NULL,'100.64.0.32','fd7a:115c:a1e0::20');
INSERT INTO nodes VALUES(38,'mkey:86d359e5681ac6a642788f26d2dfa71c65883af4a1af67a290d46fc3861b221d','nodekey:33aa0fc0fb105997472a1e1024710288ec481753149da6c50d79c9d3c59bef0a','discokey:79d066251321d58c1359edfc9b774b33b2dc46797aeb5b70ee3dc9f1be415a42','web-20','node038',6,'cli',NULL,NULL,'2025-02-25 16:11:28.263125427+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["99.62.182.69:45368","41.96.84.44:45622","[a81d:f0ad:7a29:65e6:2d93:238e:99a2:eb30]:50585"]','2024-05-22 08:08:16.045350656+02:00','2025-02-25 16:11:28.291976461+01:00',NULL,'100.64.0.33','fd7a:115c:a1e0::21');
INSERT INTO nodes VALUES(42,'mkey:10e4ff66fdd37fb54f6dcb0e42f483a15b6340610acc3a4517c24f0f350b5a9a','nodekey:f20786f9c7edc967d0b415bbcce39468441af3b531ff15656c0683d3f328720a','discokey:4e1247022b7ddf4b30d00043fded8b0132f598feeb77dd34d2fc32f97a1d2c2a','lt-05','node042',14,'cli',NULL,NULL,'2025-02-14 10:43:03.67095554+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-07-03 11:12:29.418355657+02:00','2025-02-14 10:43:03.671476921+01:00',NULL,'100.64.0.37','fd7a:115c:a1e0::25');
INSERT INTO nodes VALUES(43,'mkey:33e764ae40265089c5e7dbfc8571aa23bb390fc7e1e8bd2f3e0cd6891c308214','nodekey:c444c9ff652ba29181a5f7fdf991f91f704e6698237ee18b0649c81879ec932f','discokey:2e1db3a1eea266673acf7826aa44b5aa6fdd23c6ba41330562b37c5a523ba358','laptop-81','node043',14,'cli',NULL,NULL,'2025-02-23 16:43:04.441516493+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","[5ea4:3410:eaa2:9da:b8d:b61a:2d9d:edaa]:3526","209.107.206.184:46974"]','2024-07-03 14:48:50.263910778+02:00','2025-02-23 16:43:04.441841303+01:00',NULL,'100.64.0.34','fd7a:115c:a1e0::22');
INSERT INTO nodes VALUES(44,'mkey:1099debb0ba187ef1f43f001c75abc118eaf017bf3bd6b48ca333fb046b98de9','nodekey:d49ef9ad4a7ecbdabcd24cae92d9ac32fbb765467cbc20abe61b4bda6ef15f1f','discokey:9f2faf39514eccb7f3d7d66ebcaf804474f75284d8b1aedbf97aee6ccdf47ed5','laptop-84','node044',14,'cli',NULL,NULL,'2025-02-11 14:57:51.787233089+01: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-02-11 14:57:51.796185225+01:00',NULL,'100.64.0.35','fd7a:115c:a1e0::23');
INSERT INTO nodes VALUES(45,'mkey:29eedea8083105a21470a51112b2486ae4c79221e2b6b17e4c3c84f965013513','nodekey:b3249157ebc705f134a366e28beb2d7646a40bc4171bb6d6fece1e750c85379b','discokey:64cb6eaee39eca7e3ad7f1225c216bf2826a8a951b91a631cfacf3b5ec99c2db','web-31','node045',14,'cli',NULL,NULL,'2025-02-11 14:57:51.802536554+01: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","[360:d312:e59c:79e0:a7e4:2295:caa0:946e]:17493"]','2024-07-03 15:54:01.706018896+02:00','2025-02-11 14:57:51.804667794+01:00',NULL,'100.64.0.36','fd7a:115c:a1e0::24');
INSERT INTO nodes VALUES(46,'mkey:05f627f2614a4b7cf260a96650b0c5c62fcbfa993480253fd89771ad3b16ca2f','nodekey:678b922f6004223f9163155c62b8877ca663b1ecb3327b2c64453527f9c0f6a1','discokey:b77917efffd1020f1b03202e74265e308bc18a12e863bb04b94aa814cbc8e9bc','web-60','node046',14,'cli',NULL,NULL,'2025-02-11 14:57:51.964197644+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[89d4:f6c6:ccf6:b19d:3b76:642e:7a36:d229]:930","[ea0e:83e6:309f:c748:3314:72ba:996c:bfdd]:40599","136.29.193.173:47997","6.170.76.62:28497","[5cff:a345:4885:7b07:98a4:bcfb:f622:b94d]:58641"]','2024-07-03 19:38:07.783745318+02:00','2025-02-11 14:57:52.805260039+01:00',NULL,'100.64.0.38','fd7a:115c:a1e0::26');
INSERT INTO nodes VALUES(47,'mkey:bed87b73eea00bf3d74184d911253df54cc7697f2dd023cfd836b801efd82518','nodekey:2146154fd3fb48377f6bf4cbf08f555008471b493a90a0614e5ecf76c338bc99','discokey:c3ea2fb606807d06b1ed3e10219fee70456d1db0208d2e73a081a258992e4316','lt-41','node047',14,'cli',NULL,NULL,'2025-02-11 14:57:51.975754077+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["83.69.120.197:25918","[3f3a:e533:53b0:bf90:95bb:fe47:d61:516b]:2433"]','2024-07-04 10:38:08.344092869+02:00','2025-02-11 14:57:52.006716436+01:00',NULL,'100.64.0.39','fd7a:115c:a1e0::27');
INSERT INTO nodes VALUES(48,'mkey:8fede09a569258fc0fd7ebfbd12b2b4e8c2f4ce95c43ab0d89e41ab3998e6d24','nodekey:63af6498d4fb0e1e8312e3ec6a1639b178c051a271f33f213324e3ac1af53e17','discokey:a1e793aa09c20360cb4ef57e7dc42171a0abbc9f562140609e930ba5b7b12e83','email-92','node048',15,'cli','null',NULL,'2024-10-20 13:53:33.831192385+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[33c0:859c:4a78:8bdb:359e:31e4:1e71:7e39]: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-11 14:57:46.210281474+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-11 14:57:46.210762678+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-25 17:34:21.764621261+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6084:ee60:1697:864e:4a61:cf6e:e9b6:4c05]:63961","[fad7:2601:d286:4772:3cce:6e89:f66e:9eeb]:5430","216.60.124.11:45041","[d513:c472:d7a:f316:f610:10d0:9851:4feb]:3955","156.228.105.157:61542","102.126.185.0:50694","[156b:e934:d171:2693:8db4:f193:a58c:17b6]:24190","79.255.179.99:56057","[6369:4412:8cfc:2a5e:7cfb:8b45:e2ac:f98a]:16090","23.0.29.75:24889","[ab0:1193:7bb7:4a4a:c036:b911:994f:3aa4]:5116","[9491:7bd5:3979:414a:d198:a8b:f2e7:29b4]:62795"]','2024-10-28 10:04:50.084492941+01:00','2025-02-25 17:34:21.856390854+01:00',NULL,'100.64.0.44','fd7a:115c:a1e0::2c');
INSERT INTO nodes VALUES(54,'mkey:a6e3c45c81dbefdd09389920767df65c30bc7ff1396806623e7f8e1938b6fcac','nodekey:22e4ac4e25b05db4e94b5211e08ed14d983972f92e192f15e0231ff355fd46bf','discokey:225f907deaffccb674416dc4ba532f0b20304e86d57808eef2d96f15211f2309','db-52','node054',14,'cli',NULL,NULL,'2025-02-11 14:57:51.780134436+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"]','2024-12-09 17:10:55.363593066+01:00','2025-02-11 14:57:51.783335437+01:00',NULL,'100.64.0.46','fd7a:115c:a1e0::2e');
INSERT INTO nodes VALUES(55,'mkey:ad967c824d2c235ed17b1437f6756d4354ad76a2d27b575c0257ecac9a3a5fd2','nodekey:6196332e325e3f1d0c58acb182b48b070340dd673247c616a28d60a7669f5a4a','discokey:3a67fc6fdb9288679886c2d45dba4d1e1ba014af2c48f0f942acd39ef0e0ee64','email-56','node055',18,'cli',NULL,NULL,'2025-02-18 13:56:36.97652271+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["122.41.198.69:28824","[5437:6f4:94c1:c6c1:43ce:7a41:e5c2:65d0]:57161"]','2024-12-10 13:56:39.287449662+01:00','2025-02-18 13:56:36.978076326+01:00',NULL,'100.64.0.47','fd7a:115c:a1e0::2f');
INSERT INTO nodes VALUES(56,'mkey:3d9e1a7fc884de338b8391bbc5d3398c7d0ec4c36388b756df5b2304b727fa11','nodekey:9cd5d41c04ae83ade43363dd165c792cbc5386e0d3e005311ca7c79ae7f7acaf','discokey:2d6fad1f43bc97a6d48bcd400c829db2d4f47291b12a59dcbe669d8b1d341c1b','srv-70','node056',19,'cli',NULL,NULL,'2025-02-25 18:57:39.407869706+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a34b:36c0:9f18:1062:2269:92c:1c83:6ec6]:56902","[41e8:60a4:229:a09b:efd3:c73f:b885:d235]:39533"]','2024-12-17 14:58:39.429211911+01:00','2025-02-25 18:57:39.408317173+01:00',NULL,'100.64.0.48','fd7a:115c:a1e0::30');
INSERT INTO nodes VALUES(57,'mkey:1025548b29dc9733e1099fbb6516778e9d8f07eeaa214cd1ef33438e731333eb','nodekey:3f21adc328130ab468ac28ee25b4002974610ddd7b11f586752dec5a151114b2','discokey:605115f1238609b148dff010ca6e04d7b337df4e2b88de7a1f900a2f1de7db42','laptop-79','node057',20,'cli',NULL,NULL,'2025-02-25 10:30:02.978978512+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[a329:52fe:45d1:996e:4767:d50c:6513:92ac]:54604","80.29.45.84:8223","178.193.134.41:58563","29.219.180.224:55412","[2ddd:7c1b:a237:41c8:3baf:e9cc:1f31:9057]:62916"]','2024-12-17 15:17:14.26936913+01:00','2025-02-25 10:30:02.979071466+01:00',NULL,'100.64.0.49','fd7a:115c:a1e0::31');
INSERT INTO nodes VALUES(58,'mkey:e2795aaa6a9a19aa8efe47496bd930d8ed32d5feacd49e903ebce90db20101dc','nodekey:1066fbdf7648099fbf06cd5b69e20e80c3422790caee0354e8465520329f7754','discokey:d00b560ef82f566c3171c1a313f25e65b7bc7a2eeb5146cb4c513bfbfe40fdf9','desktop-48','node058',12,'cli',NULL,NULL,'2025-01-25 18:41:03.881898904+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["168.76.222.22:27595","[dc1f:57e3:7842:53ba:b427:8e40:6ebf:5b36]:4136","55.12.42.230:527"]','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:4de34c0ddff8819b97b39c2f31a2568db15e7c0ac6c1d75879b6c5247a5dd9a5','nodekey:13565579616a60409e411d5406b743f5dcf878da4aa82031350537d41038e09f','discokey:788fe7ffbb2b564852b1b9ec170a4267449c98b17ed51dcdce65942de712918b','lt-29','node059',21,'cli',NULL,NULL,'2025-02-16 03:40:04.156549179+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[32d2:d2f7:d5d2:8e10:507f:3428:b2a0:12b7]:22008","[c493:2a8f:6625:98c3:4f4a:db04:19cb:c7df]:41081","96.25.93.176:21890","219.197.124.83:46550"]','2025-01-29 11:59:27.291048957+01:00','2025-02-16 03:40:04.156814266+01:00',NULL,'100.64.0.54','fd7a:115c:a1e0::36');
INSERT INTO nodes VALUES(60,'mkey:f04e27d229384590995331a3723f7a668443d5e638956102ab37df84529fff40','nodekey:49394e4605a507fd3a121abf6406645648b79c5f07f9f594fd8edc25eb94b04a','discokey:16256cfb6fdbae68d3ee7de3124887892d557512d5f86b5e9f3b4af036c1eb9a','db-54','node060',21,'cli',NULL,NULL,'2025-02-14 16:39:11.521346869+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["168.132.106.166:348","[ac:5c65:da8d:d68c:eb0d:3692:d441:5363]:63612","107.250.166.141:64587","[25cf:5511:50fc:e379:b64c:3a3:ff6f:104f]:22295"]','2025-01-29 12:01:57.48748166+01:00','2025-02-14 16:39:11.521680749+01:00',NULL,'100.64.0.55','fd7a:115c:a1e0::37');
INSERT INTO nodes VALUES(61,'mkey:bdbef72c5f0e479a26353e2fe037cf6dd20719cb4d501f04a88a08571914307a','nodekey:fa24bcb6e340f6b8ea272a0d17ac7b5401e48d2fda056465326f2e1ac4695412','discokey:94ce18576693a7a51d39574aa5c81060355b8ae3f912c78515e525b5e31e5dae','web-59','node061',21,'cli',NULL,NULL,'2025-02-13 11:30:13.272216377+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["112.239.138.73:43954","174.168.204.29:5611","190.0.61.36:13730","33.70.223.181:46561"]','2025-01-29 12:03:01.464646336+01:00','2025-02-13 11:30:13.272621771+01:00',NULL,'100.64.0.56','fd7a:115c:a1e0::38');
INSERT INTO nodes VALUES(62,'mkey:7d5ae8f0478c9a247bd1bb17d30ca742093c245c62ee324252337a170c6693a5','nodekey:9eff4972c9c5ed636f469b7869e5b5a9ffb7ec419d5316958631a72dd0da765b','discokey:124c71c581460affbc538c1c3efef93fa40e2170b4a4e3e08d81847bac150bed','laptop-08','node062',21,'cli',NULL,NULL,'2025-02-21 21:09:17.619738167+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[54b0:31b1:f5d1:bd45:5e99:3951:5dc4:45be]:33239","55.225.129.62:57985","28.93.179.45:19029"]','2025-01-29 19:23:14.092804852+01:00','2025-02-21 21:09:17.620347693+01:00',NULL,'100.64.0.57','fd7a:115c:a1e0::39');
INSERT INTO nodes VALUES(63,'mkey:baeda24b92a15048f28b063ac4e3aa9ffa67b0bfd2a9ceb3b3005f6167e7c846','nodekey:9da3c4c71920a17c6476a51cc658c2d1e8ab167079cd0fab2215fa2e98675e03','discokey:c37813a5ff804ebfbd17ba3c3e030f97e5bacf4bf37c1829f1193b354657974c','web-17','node063',21,'cli',NULL,NULL,'2025-02-25 18:57:46.306411004+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["213.69.213.51:7048","[37a5:a9dd:8b9d:5014:b243:4f4f:6888:713e]:21123","223.252.160.61:32625"]','2025-01-29 19:41:40.535299057+01:00','2025-02-25 18:57:46.306748231+01:00',NULL,'100.64.0.58','fd7a:115c:a1e0::3a');
INSERT INTO nodes VALUES(64,'mkey:194758915fa3a0f4dc51d5c8809c8d34811a2ba691f8286e1281c8733b908ca0','nodekey:3edcebd1bbc810d5df8fe3217eebd41e209d8b62beb09912bd60fe3682006a2c','discokey:89d4a743b38f61254b01454fdaa89e7855966b1beffe363e86c28ce8ada66454','lt-49','node064',21,'cli',NULL,NULL,'2025-02-25 17:53:18.185882601+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["26.157.224.19:39567","54.120.201.209:5659","[1b62:c927:40b:7b50:6285:2eff:280f:4c8c]:58979"]','2025-01-30 18:18:57.519126133+01:00','2025-02-25 17:53:18.186491242+01:00',NULL,'100.64.0.59','fd7a:115c:a1e0::3b');
INSERT INTO nodes VALUES(65,'mkey:270533b0e4234eb9e697ee9e69403551dae192d4b3269a6810c4a0d2a6a55b6e','nodekey:d54cc8d3a12b77589e471e30b6ae4d803e58392b82aff1953974d722f8f1368d','discokey:e6c009756cf69ac7cdaea6c4a725c8766ec8e5a67be080a6ba2c6ed0fc5d7900','laptop-75','node065',21,'cli',NULL,NULL,'2025-02-25 18:58:05.70384565+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["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-30 18:19:40.354692307+01:00','2025-02-25 18:58:05.704297047+01:00',NULL,'100.64.0.60','fd7a:115c:a1e0::3c');
INSERT INTO nodes VALUES(66,'mkey:de86679045cb8624f1a83852679a58cffd9066814aa8994f4ac0a9213b83175f','nodekey:b62e575e38a00afe79418224f7b954210702ac0a6d450eb8dbf7b5720b1eb5a5','discokey:6492f53782aab503155db83aa2d3a9e7698382da589b8c078d7850373332734b','desktop-65','node066',21,'cli',NULL,NULL,'2025-02-25 18:24:57.136610701+01: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","[3095:7c2f:3784:9955:ebbc:4382:662b:a218]:48812","[c771:8240:30ba:d472:9e15:10c8:b026:2654]:14619"]','2025-01-31 12:05:28.65297301+01:00','2025-02-25 18:24:57.136876179+01:00',NULL,'100.64.0.61','fd7a:115c:a1e0::3d');
INSERT INTO nodes VALUES(67,'mkey:259ea817a2c4d8a4c072db370e8c15ad9667331a63187285aaa4987b023b3e5f','nodekey:f743d054050f294bc1141b11924d8813401a650cc454e68dbfb20067f7d013af','discokey:aeb45bb93e68891487622a4274d9d2cfdbe795681e6f431075ad1aabb7ec1171','lt-70','node067',21,'cli',NULL,NULL,'2025-02-25 18:49:11.272283063+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b3d0:4706:73c5:9035:dd98:af39:b7f5:1311]:15037","[9356:40f8:a98c:a1a9:18e6:e781:f169:4277]:63375","[c733:e842:4621:e95d:6576:9ccf:b2c8:1582]:41668","[8f2:4995:746a:bc2c:84e9:95fa:b236:3c1f]:52788"]','2025-01-31 12:06:30.121464114+01:00','2025-02-25 18:49:11.272545005+01:00',NULL,'100.64.0.62','fd7a:115c:a1e0::3e');
INSERT INTO nodes VALUES(68,'mkey:87dacd4a5bad58d9676d8242fe304668201101da8843faf4991afa597adeeb2c','nodekey:bac278a5ad2db26a926acc26fd63948ba6bd59f251f7cb63189686ce6ab708a1','discokey:24a9b3c24f38b690ca357a9659d7694a2a4fc85da77fb1412eae653c644b3bd2','web-47','node068',22,'cli',NULL,NULL,'2025-02-25 17:56:50.63061982+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["171.134.254.145:45887","[29e:44c9:159f:6692:bdc0:de17:58cb:1908]:58971"]','2025-02-03 14:16:55.56431345+01:00','2025-02-25 17:56:50.630814975+01:00',NULL,'100.64.0.51','fd7a:115c:a1e0::33');
INSERT INTO nodes VALUES(69,'mkey:a3f039c16511f2b68bc8ab68a8d844c2f942aef9a277a1e2b1c3182c9f95b41d','nodekey:4cfd59f8b4bb7c82f7f7fba87ee21d2a0f32ce138d680591e8e0e47df3328ed5','discokey:38bae7e836bfd18b54cd4323709ae713fbd37d12c774cf19a8568bff1a410cb3','srv-80','node069',22,'cli',NULL,NULL,'2025-02-25 18:45:26.655373144+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f2d6:a8f1:727:d9e1:759:3a6c:6aed:d7ea]:22032","[3014:978:1762:1290:b92f:47f5:1dca:d0bf]:16383"]','2025-02-03 15:23:16.312084161+01:00','2025-02-25 18:45:26.655510978+01:00',NULL,'100.64.0.52','fd7a:115c:a1e0::34');
INSERT INTO nodes VALUES(70,'mkey:0b6c7fc5eea73e731daabee34180efedfe9feea3171ba9f64c45e913bd068910','nodekey:6c63bd3c0336e50cb895df6e1fb177d2e6ab7f8e59baac6f4d54a1708324248b','discokey:b594b1893b68cef8d9e8496797bad67eee207093fdb12a9dd08e0b53cb915791','db-86','node070',21,'cli',NULL,NULL,'2025-02-25 18:34:37.1756356+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["99.25.81.82:35202","52.120.18.3:13372","[dc9a:ed1e:f97d:b356:d5f5:5d44:c917:3077]:33994","[dac7:80d0:6b4:2620:3ae4:2936:23a2:eba9]:31156"]','2025-02-03 18:09:35.161109801+01:00','2025-02-25 18:34:37.176092039+01:00',NULL,'100.64.0.53','fd7a:115c:a1e0::35');
INSERT INTO nodes VALUES(71,'mkey:2251ba3534d7e20a28b1b2820ffd1a52a7cdcf60b1779a07d6c760aed6b3fc5b','nodekey:772af8901804b0da90941644bef50afbf67d0414226835865b7078383fc25272','discokey:fe85bbd953fe9294941fdb62ef965ff83bf7b646adec696db3bf889316cfc226','web-09','node071',21,'cli',NULL,NULL,'2025-02-25 01:29:06.614357209+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[4d9e:563b:9e58:71a5:24ff:2612:7985:3f81]:20272","[2967:f7fc:b02a:7e75:6842:a146:56:dca1]:14923"]','2025-02-04 12:03:50.32663805+01:00','2025-02-25 01:29:06.674397902+01:00',NULL,'100.64.0.63','fd7a:115c:a1e0::3f');
INSERT INTO nodes VALUES(72,'mkey:b070570c4361b0e9ce2f3afc15c0280c1ccdbdb3cc77f46df24238984e0ec527','nodekey:1b7b5f34a954359091fb9c9f81ded16fb83c96aa793aa08dbfc8e043e9f5378b','discokey:3f7d2271e073c6d51bcaa49e6b040ab689dbf9cde108e1a82d0b3f30c4f2a6a5','db-60','node072',21,'cli',NULL,NULL,'2025-02-24 22:26:45.69683022+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["170.145.88.37:51085","[4556:deae:aed1:6442:1456:5897:f4:12b1]:18138"]','2025-02-04 12:07:36.231437299+01:00','2025-02-24 22:26:45.697080608+01:00',NULL,'100.64.0.64','fd7a:115c:a1e0::40');
INSERT INTO nodes VALUES(73,'mkey:0ec65946fc090054aa5164b3f5cd6f548dfc27b490025b1a190b93d69068c2e3','nodekey:37bda01462c321bf5c22d9f475325184aaff6d156964ef36d3f4638772db608e','discokey:9c15df2e2016b42d1c57c2ce1e3607786ecfcb4c3271991ea8e6abf28e1a1064','web-61','node073',21,'cli',NULL,NULL,'2025-02-24 20:16:59.20339999+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["20.112.75.120:15833","158.67.245.119:11948"]','2025-02-04 12:10:26.50545127+01:00','2025-02-24 20:16:59.203598225+01:00',NULL,'100.64.0.65','fd7a:115c:a1e0::41');
INSERT INTO nodes VALUES(74,'mkey:7352aa9afe2d3372cacf883c2fa2f9faee561f8dd567184909c6d1206156ac7c','nodekey:88b163165d7438eb768e100a617a3850f050f4b7f1a9d26f6a1c6c2cbab2a6df','discokey:a32aac3d9bad0a0557274da524523b2831914a5329307114c9c3abffa0899790','db-43','node074',21,'cli',NULL,NULL,'2025-02-25 17:40:44.888267238+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[d05b:3c4f:8402:823f:409f:87b2:4dab:4959]:58420","130.243.34.21:50806","104.255.105.25:5817"]','2025-02-06 17:33:12.557302525+01:00','2025-02-25 17:40:44.88889439+01:00',NULL,'100.64.0.67','fd7a:115c:a1e0::43');
INSERT INTO nodes VALUES(75,'mkey:51f0f5c2b892846f926abf826f5ff56a52fc4a466be7a1073f16028ef2c6aabb','nodekey:0138c27376e8289255c1d505ba8e8d0e9e8e6785198b87984763531273d0c540','discokey:5bbb476ee437efaa55c10931313e35c4c8c6e30015e7f3eb015f4736897abb12','desktop-50','node075',9,'cli',NULL,NULL,'2025-02-25 08:20:55.11942837+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["57.247.45.203:47518","[1709:1d2d:9e92:a2c5:f5a0:fbca:6d9:dcbb]:31824"]','2025-02-06 18:23:55.709687186+01:00','2025-02-25 08:20:55.119891701+01:00',NULL,'100.64.0.66','fd7a:115c:a1e0::42');
INSERT INTO nodes VALUES(76,'mkey:e3ec4d021ea80bdca94d97bc70443b58b6f7c9fa382e4a2cd61b9397cdbefbb7','nodekey:60862d1848548d0816874d83c3d819dd8359869f24e4e0ca0b10ba98fae9aacd','discokey:5265333600c360986c74f93bda288a7adf25d8abb6b5174694dbfbc56e03d488','laptop-97','node076',21,'cli',NULL,NULL,'2025-02-24 22:26:45.695195612+01:00',NULL,'{"fake":"data"}','["140.129.39.90:29397","163.61.27.204:21704","208.72.71.10:23065","[5400:ad99:9af3:c69f:c044:7959:1cbd:d52d]:62818"]','2025-02-14 15:29:45.220999928+01:00','2025-02-24 22:26:45.695391477+01:00',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(77,'mkey:eacc877df3ab3cdbbe20b1784ebeda63fa5058b8dcf69215b7993219e4a9ea94','nodekey:0e46ba129c4fb18195868f1e3b7bb7ad91e882b5e5aeab040692b69036457b67','discokey:6b42741054b0235ac27e649163acff4f6f90e6cdd6c4e587c25cd2a6b9f35aec','lt-44','node077',23,'cli',NULL,NULL,'2025-02-23 16:44:05.007011804+01:00',NULL,'{"fake":"data"}','["[f8c:6efe:aade:2619:9aa8:378e:2365:1ab7]:58269","[de0b:ae5e:4986:c7a0:3d3a:e4f5:afe1:d7d5]:61468","174.113.53.229:41982","[de3:22e3:e882:aeaf:2f2:ca2d:a179:de48]:23754"]','2025-02-14 17:00:54.226657615+01:00','2025-02-23 16:44:05.007327971+01:00',NULL,'100.64.0.68','fd7a:115c:a1e0::44');
INSERT INTO nodes VALUES(78,'mkey:db77190826c814e219de0cd88d82298e7bf6d4fbb67ce8f00c0fd5c060fff85c','nodekey:73f0e887839e84b765d6186f97221d612d79595c119ff885682797991a02652c','discokey:74401b0dd1e1bfbbda82bf25fba18e15a89a30f4c1868cfb8ea81eb35ef4ae98','lt-27','node078',23,'cli',NULL,NULL,'2025-02-17 18:30:50.582229691+01:00',NULL,'{"fake":"data"}','["[5132:fd57:f2d8:8b61:470a:b25:60a6:48a6]:13595","208.34.222.79:35431","[e66d:c35:81d9:5ffd:4ad7:25c6:3ea2:a41f]:49279","[89f2:dc57:80ea:c56a:73b3:2563:1fd3:df17]:57048"]','2025-02-14 18:03:28.401774063+01:00','2025-02-17 18:30:50.635233842+01:00',NULL,'100.64.0.70','fd7a:115c:a1e0::46');
INSERT INTO nodes VALUES(79,'mkey:60cd68f2d9965be36441f2f639e5245d845b7fea90a9325938813fdedf751679','nodekey:783e5ff1eac899d0cb25f2539244aef4c4a46198a4ec8753afe89f00670e29e4','discokey:688d1fb7063cc3e59a7041e64de8d416ab6390f2739a50dcf06d529fd263d28f','desktop-70','node079',25,'cli',NULL,NULL,'2025-02-24 18:37:03.584752527+01:00',NULL,'{"fake":"data"}','["[1e10:11cc:fd29:4681:aaaa:fd21:a79c:bc3d]:57634","78.215.20.31:28892","4.11.131.129:50580","61.47.47.240:57553","107.46.106.255:64756","7.81.60.25:36846"]','2025-02-15 12:49:11.523904469+01:00','2025-02-24 18:37:03.584913585+01:00',NULL,'100.64.0.71','fd7a:115c:a1e0::47');
INSERT INTO nodes VALUES(80,'mkey:1de9a40ca190e9c6da65eecb16d3bb0574bf7757189115dc466299e08915c514','nodekey:de98e4358158b9231331934496db7fab148a8aac11248e4a17df0c4843c3a46a','discokey:cba115a9da4fa05b24b13e1180999612993a0eafb9728c3be13d50dd4458b95f','email-70','node080',23,'cli',NULL,NULL,'2025-02-21 18:58:38.982571563+01:00',NULL,'{"fake":"data"}','["156.169.142.128:42443","178.75.210.129:64679"]','2025-02-15 21:12:05.434304787+01:00','2025-02-21 18:58:38.983040117+01:00',NULL,'100.64.0.72','fd7a:115c:a1e0::48');
INSERT INTO nodes VALUES(81,'mkey:58cf6b62ae7bec2c13af7be13bca5edc03bd7a55d56ebdcb4a43b35adce5ff7c','nodekey:31d2dcb989bc02a1943ea12ad376f2f58cbab06e9761cb1bf4ef4024d310def9','discokey:68b0066f49c936d164f9595ddde2676815501a14bc6df2914cb34de8476acd57','srv-02','node081',23,'cli',NULL,NULL,'2025-02-17 16:28:36.502444963+01:00',NULL,'{"fake":"data"}','["42.226.40.62:27764","[bd66:349c:a29a:4c05:b3ab:dd92:749c:434e]:27566","69.37.34.188:32687","172.43.25.248:19211"]','2025-02-17 16:05:05.921277876+01:00','2025-02-17 16:28:36.502658351+01:00',NULL,'100.64.0.73','fd7a:115c:a1e0::49');
CREATE TABLE `policies` (`id` integer PRIMARY KEY AUTOINCREMENT,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`data` text);
CREATE TABLE IF NOT EXISTS "routes" (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`node_id` integer NOT NULL,`prefix` text,`advertised` numeric,`enabled` numeric,`is_primary` numeric,PRIMARY KEY (`id`),CONSTRAINT `fk_nodes_routes` FOREIGN KEY (`node_id`) REFERENCES `nodes`(`id`) ON DELETE CASCADE);
INSERT INTO routes VALUES(1,'2023-05-19 07:09:23.387641743+02:00','2023-05-22 09:48:18.908103256+02:00',NULL,3,'192.168.224.0/21',1,0,0);
CREATE TABLE IF NOT EXISTS "users" (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`name` text UNIQUE,`display_name` text,`email` text,`provider_identifier` text,`provider` text,`profile_pic_url` text,PRIMARY KEY (`id`));
INSERT INTO users VALUES(1,'2023-05-17 19:36:55.859473496+02:00','2023-05-17 19:36:55.859473496+02:00',NULL,'user001','','',NULL,NULL,'');
INSERT INTO users VALUES(2,'2023-05-17 19:36:57.059073465+02:00','2023-05-17 19:36:57.059073465+02:00',NULL,'user002','','',NULL,NULL,'');
INSERT INTO users VALUES(3,'2023-05-18 10:10:36.248939077+02:00','2023-05-18 10:10:36.248939077+02:00',NULL,'user003','','',NULL,NULL,'');
INSERT INTO users VALUES(4,'2023-06-10 09:06:13.920718561+02:00','2023-06-10 09:06:13.920718561+02:00',NULL,'user004','','',NULL,NULL,'');
INSERT INTO users VALUES(5,'2023-06-11 19:58:32.371218434+02:00','2023-06-11 19:58:32.371218434+02:00',NULL,'user005','','',NULL,NULL,'');
INSERT INTO users VALUES(6,'2023-06-17 19:39:53.031565686+02:00','2023-06-17 19:39:53.031565686+02:00',NULL,'user006','','',NULL,NULL,'');
INSERT INTO users VALUES(7,'2023-06-20 11:35:09.325846831+02:00','2023-06-20 11:35:09.325846831+02:00',NULL,'user007','','',NULL,NULL,'');
INSERT INTO users VALUES(8,'2023-06-21 22:47:48.196234382+02:00','2023-06-21 22:47:48.196234382+02:00',NULL,'user008','','',NULL,NULL,'');
INSERT INTO users VALUES(9,'2023-06-22 08:30:35.068995572+02:00','2023-06-22 08:30:35.068995572+02:00',NULL,'user009','','',NULL,NULL,'');
INSERT INTO users VALUES(10,'2023-07-03 10:18:32.123226+02:00','2023-07-03 10:18:32.123226+02:00',NULL,'user010','','',NULL,NULL,'');
INSERT INTO users VALUES(11,'2023-07-03 10:18:37.130387602+02:00','2023-07-03 10:18:37.130387602+02:00',NULL,'user011','','',NULL,NULL,'');
INSERT INTO users VALUES(12,'2023-12-15 08:05:06.013615212+01:00','2023-12-15 08:05:06.013615212+01:00',NULL,'user012','','',NULL,NULL,'');
INSERT INTO users VALUES(13,'2024-02-03 16:32:42.224977233+01:00','2024-02-03 16:32:42.224977233+01:00',NULL,'user013','','',NULL,NULL,'');
INSERT INTO users VALUES(14,'2024-05-03 10:12:38.220973042+02:00','2024-05-03 10:12:38.220973042+02:00',NULL,'user014','','',NULL,NULL,'');
INSERT INTO users VALUES(15,'2024-07-26 08:08:40.979783263+02:00','2024-07-26 08:08:40.979783263+02:00',NULL,'user015','','',NULL,NULL,'');
INSERT INTO users VALUES(16,'2024-08-05 17:32:02.878091894+02:00','2024-08-05 17:32:02.878091894+02:00',NULL,'user016','','',NULL,NULL,'');
INSERT INTO users VALUES(17,'2024-09-22 15:48:00.287392203+02:00','2024-09-22 15:48:00.287392203+02:00',NULL,'user017','','',NULL,NULL,'');
INSERT INTO users VALUES(18,'2024-12-10 13:55:11.256977421+01:00','2024-12-10 13:55:11.256977421+01:00',NULL,'user018','','',NULL,NULL,'');
INSERT INTO users VALUES(19,'2024-12-17 14:57:58.550971236+01:00','2024-12-17 14:57:58.550971236+01:00',NULL,'user019','','',NULL,NULL,'');
INSERT INTO users VALUES(20,'2024-12-17 15:02:08.053169491+01:00','2024-12-17 15:02:08.053169491+01:00',NULL,'user020','','',NULL,NULL,'');
INSERT INTO users VALUES(21,'2025-01-28 15:57:32.774456057+01:00','2025-02-06 17:43:41.935399542+01:00',NULL,'user021','','',NULL,'','');
INSERT INTO users VALUES(22,'2025-02-03 14:10:50.491924701+01:00','2025-02-03 14:10:50.491924701+01:00',NULL,'user022','','',NULL,'','');
INSERT INTO users VALUES(23,'2025-02-14 16:58:30.250289644+01:00','2025-02-14 16:58:30.250289644+01:00',NULL,'user023','','',NULL,'','');
INSERT INTO users VALUES(25,'2025-02-15 12:48:14.650995528+01:00','2025-02-15 12:48:14.650995528+01:00',NULL,'user025','','',NULL,'','');
CREATE UNIQUE INDEX `idx_api_keys_prefix` ON `api_keys`(`prefix`);
CREATE INDEX `idx_policies_deleted_at` ON `policies`(`deleted_at`);
CREATE INDEX `idx_routes_deleted_at` ON `routes`(`deleted_at`);
CREATE INDEX `idx_users_deleted_at` ON `users`(`deleted_at`);
COMMIT;
Reference in New Issue View Git Blame Copy Permalink