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

102 lines
26 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,'c0e73b52c1706fcceea368ae07c19c0e91fbe1f78eff2f7b',1,0,1,0,'2022-02-26 17:02:32.568878371+00:00','2022-02-26 18:11:15.388354971+01:00',NULL);
INSERT INTO pre_auth_keys VALUES(2,'ad293159f9506a02d6de4730e5a2ddb74f9fd4033919ecc5',1,0,1,1,'2022-02-26 17:08:07.828690446+00:00','2022-02-26 18:11:18.890985216+01:00',NULL);
INSERT INTO pre_auth_keys VALUES(3,'66c7e0fbf74010ea2e153d35ffa0f3c48380ef38960d1fd1',1,0,0,1,'2022-02-26 17:11:54.149663776+00:00','2022-02-26 17:16:54.147175388+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(4,'cdbb69c88fabdc2609050c7f99e8ebdea6fcf81a50d802fc',1,0,0,1,'2022-02-26 17:15:34.160746962+00:00','2022-02-26 17:20:34.15935255+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(6,'0a99889a217a2f9cdd20082faadd5c90e72c83a47093a63a',1,0,0,1,'2022-03-04 07:27:17.535172209+00:00','2022-03-04 07:32:17.531871524+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(10,'6e88409e3883c1a47249e428030afd4a46bdaf3adb3b74c1',4,0,0,1,'2022-04-01 20:43:21.757703546+00:00','2022-04-01 20:48:21.756458144+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(13,'9d3c2bde9fcef181a3141dfe59d449bf03f6779dad3580e0',1,0,0,1,'2022-06-26 13:19:48.533865696+00:00','2022-06-26 13:24:48.532164552+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(16,'00b123d52ea8f58379b740fdc5c898b02330ab9b366cb1b4',1,0,0,1,'2023-02-12 06:21:30.15120385+00:00','2023-02-12 06:26:30.140082454+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(17,'c471ce93392c0d3040af0cf6166f4f578c3c66dd180b6e0b',1,0,0,1,'2023-02-12 06:26:55.829311638+00:00','2023-02-12 06:31:55.824701077+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(18,'fe0a438e67687540efcbbbc28c8e6c1b8ac1216f99de33d4',1,0,0,1,'2023-02-12 06:31:13.245185592+00:00','2023-02-12 06:36:13.241695106+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(19,'5a469043f1fa43ff11e54ea242dd882a81aea68f168b9a34',1,0,0,1,'2023-02-12 06:31:13.622545545+00:00','2023-02-12 06:36:13.560890824+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(20,'8b31d9a38282dfe07ffcebdfbd40db6b9e49997c93bed570',1,0,0,1,'2023-02-28 12:45:48.518939706+00:00','2023-02-28 12:50:48.445951259+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(21,'47a4216f2b4e5885d4e53a3de2ffe95521d8a708ca26d31e',1,0,0,1,'2023-02-28 12:45:48.53865321+00:00','2023-02-28 12:50:48.439132728+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(22,'1b7be83871f396e4544c8445acfc8d308dbfe29c7f0197f0',1,0,0,1,'2023-02-28 12:45:48.538806791+00:00','2023-02-28 12:50:48.445073692+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(23,'c9f364adba95c6c46c162eaa3786702805595841c0150927',1,0,0,1,'2023-05-05 08:08:16.73107293+00:00','2023-05-05 08:13:16.722921676+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(24,'a90c87e30fa22ffee39e5ce157dd22c909f2026295e3bce4',1,0,0,1,'2023-08-14 14:36:52.042138928+00:00','2023-08-14 14:41:52.038644473+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(25,'bb059cde5663619a8918bde19b9f8236085725554d9d78c2',1,0,0,1,'2023-08-14 16:15:33.722630834+00:00','2023-08-14 16:20:33.719604033+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(26,'0733b8fc67adc82644c87a95947b24c5d368c633cff92eb4',1,0,0,1,'2023-08-29 06:30:44.934900329+00:00','2023-08-29 06:35:44.931280114+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(27,'567f3a39066fd99c567d14bcc374b25cee0ad71af08b9054',1,0,0,1,'2023-11-03 17:53:45.857200883+00:00','2023-11-03 17:58:45.853742836+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(30,'8aa13c93cbef46d36c8159da51fb41a469ae04f932980890',1,0,0,1,'2024-07-29 12:24:27.140614087+00:00','2024-07-29 12:29:27.136525982+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(31,'9314b171abc433d73b8db297c1c5c65dae0be53d39a71520',1,0,0,1,'2024-08-07 18:35:12.375119763+00:00','2024-08-07 18:40:12.371590392+00:00',NULL);
INSERT INTO pre_auth_keys VALUES(32,'6a8fd483387734664f2a911545150a9bc0d9f12a744fe913',7,0,0,0,'2025-02-23 06:56:50.319087142+00:00','2025-02-23 07:56:50.31726796+00:00','[]');
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`));
INSERT INTO api_keys VALUES(1,'S2nn85NliD',X'2432622431322457713675666f5379396247466672516155317132374f58734e5033627671436470436c447073757979456f4a4a71626b6a434e6236','2022-12-25 21:35:28.644697962+01:00','2023-03-22 06:22:18.724817647+01:00',NULL);
INSERT INTO api_keys VALUES(2,'1KZkpEyiMH',X'2432622431322435797935525374656e525a4e67735365316837455965376872366e4e6563445a4e45666d72334d5273612e4b5151334f675a302e71','2023-03-22 06:22:18.339101298+01:00','2023-04-13 09:32:24.318715268+02:00',NULL);
INSERT INTO api_keys VALUES(3,'6yBMrqvEDX',X'24326224313224737956314430636d615a6e546531705370346a7a72654566327565367a587a737264694c336c7147644977424f7348794644624e79','2023-04-13 09:32:23.864995051+02:00','2023-07-12 07:32:23.45+00:00',NULL);
CREATE TABLE IF NOT EXISTS "nodes" (`id` integer,`machine_key` text,`node_key` text,`disco_key` text,"hostname" text,"user_id" integer,`register_method` text,`auth_key_id` integer,`last_seen` datetime,`expiry` datetime,`host_info` text,`endpoints` text,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`given_name` varchar(63),`forced_tags` text,`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:13adef46b653fc9d24415b242714d08a92605cb2d53355a03cda8bae483cc93d','nodekey:aca177c7ceeadf615c5d28bd894ddad5133fe0e99e6c5f2a4af5403daf74aac6','discokey:83f177b585a16eab54768d0284553d62d3f46ef8a21417834039525dfd9ac7dd','desktop-00',1,'authKey',3,'2025-04-04 16:01:46.440493034+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[ce6f:3f5b:da2f:8382:f3a1:e2d4:1c47:fe5e]:25604","[ff9b:6bbd:77bc:323d:12e4:22ba:b712:80c]:37729","[1e76:19af:e817:9a33:4f83:366e:b686:6362]:39521"]','2022-02-26 18:11:55.92837512+01:00','2025-04-04 16:01:46.441299466+02:00',NULL,'node001',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(3,'mkey:202076169f1eee6bcbaebd7d5c314341b9aca69fadda7286fe49f45ed81b6de0','nodekey:b02b4522c79164bb4dc5ba6ff8115cc7dac03417a9385fa9b3fe12e4c3d14ccc','discokey:e5b11353b9ee94a90963eb4318514b17ad8304b4b80d4e178b3e3485376f3c88','email-16',7,'authKey',NULL,'2025-04-03 21:00:54.6832508+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b886:a57b:2070:84fd:6618:6c8:3c70:5077]:17679","117.184.57.124:25930"]','2022-03-01 19:26:46.242187887+01:00','2025-04-03 21:00:54.683607994+02:00',NULL,'node003',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:56ad8dcc120738372c03052898bcdaf06a4b7e92adfa4e260f3ab33bbec7d560','nodekey:b197bf018c11a550972b6fe5841e99660bd70eb64faa26f334466181c6a0c23b','discokey:af3613f6dc6ef1559bb6a35ef0c74ebb42b49e75a7a07d6385a9d5e0acacaf17','web-61',1,'authKey',6,'2025-04-03 18:23:56.187297547+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["76.70.66.173:4330","164.82.63.27:24154","[be53:e324:1587:4d86:d24c:8662:cd5c:a4c8]:58105","59.239.218.25:49807","[cfa4:ad2e:1410:3b78:ce03:b437:6749:ff3a]:39835","179.46.219.166:38167","166.111.217.41:13979"]','2022-03-04 08:27:19.383566031+01:00','2025-04-03 18:23:56.1873891+02:00',NULL,'node004',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(5,'mkey:e87e820508bd86c183ebe4ffb80637130b6d7480c3db5b94fbe4be097ca31d6b','nodekey:36d6615362a2367b323e53348e7b300b5d3180954f6c73d619738b6b416f8b29','discokey:31bde1fc825d42faaefc6baeb19205176d325a0c385b3d5c42020fac5828baf7','srv-79',8,'authKey',NULL,'2025-02-23 12:50:07.992065346+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["157.68.216.200:462","[8dc0:10e:95b6:9954:2614:8dcc:6564:e167]:58499","[8e6d:95be:19a9:316a:d37e:bcb6:5e05:d7f0]:36162","[5bb2:705a:7f5c:3c9:db83:956a:1ce:5291]:9510","37.24.123.232:17607","17.23.6.93:59855"]','2022-03-05 13:54:23.660591381+01:00','2025-02-23 12:50:07.99213101+01:00',NULL,'node005',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(6,'mkey:afca3664dd99d4f692e6188b11e356803b3b88af6aea8c64f44c691c5ef0dd75','nodekey:56c0b70b513c1332dc6e96e23f9b31ce5e7d2f67bf2ce913788f6f8f4309a286','discokey:84388aee7f9b67ca6f494710d339cebe2570c109bffd46b866a3ce6bdfab0a7e','desktop-69',1,'authkey',NULL,'2025-04-04 06:54:04.865503636+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["58.226.203.77:32176","110.30.79.130:11845","87.221.84.2:11620"]','2022-03-21 15:52:20.739594362+01:00','2025-04-04 06:54:04.865830042+02:00',NULL,'node006',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(7,'mkey:cf245d2ed1c596c90501a51b0a7bb2bf72a77bd8aaa25be1798ba88ca4840de1','nodekey:b48c4f58b478be290e6f1fbdd74b54487f66e3efd00f1c90a46c413ccec88b3b','discokey:2df61e4dd58f94db5f7e51caacbb30da03e1efa2892c18ea63d00b9a0b59bd09','db-01',4,'authkey',10,'2025-04-04 11:27:17.576257983+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2c84:7686:38e3:1aa5:db0c:29e4:c685:6059]:38764","4.4.79.116:35870","[1daf:274c:55b2:7413:3c1:bd3d:acc5:4eb1]:33732","182.237.82.235:32290"]','2022-04-01 22:43:27.318756043+02:00','2025-04-04 11:27:17.576974245+02:00',NULL,'node007',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(8,'mkey:cedaee7ced43e8b6eab7807f2e0b6a65351950be008d086dda73ca1176dcb4b0','nodekey:97377594f32ffa436df6cb935fe998011700cbd94d0b7b9f1878e796e47595eb','discokey:7abe7a09338db86ecffe306c78b69a84b7a3615922a6dd580f87e25ac5065843','email-41',7,'authkey',NULL,'2025-04-04 09:43:37.714947898+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["79.62.99.173:32988","136.206.88.82:20612","151.147.230.32:10729","[2621:a1d2:a66d:a6cf:3592:dff2:93dc:5b32]:62817","[e1e8:e93f:ab91:4027:e416:9932:8e9:6fcb]:30261"]','2022-04-03 09:38:46.178224968+02:00','2025-04-04 09:43:37.715260959+02:00',NULL,'node008',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(9,'mkey:94d71f734657c61ac8dd2f7d1ed06787361c1b43bdc3a3c9a541890afa676ddb','nodekey:7bb55439c507f6a11d866f44fdea7912cc4ad8791528438b5d598f001971936e','discokey:1b0a846e57e2ebb966bae5507a41991dde493eb17c61161146056f1d4065817c','lt-20',7,'cli',NULL,'2025-04-04 16:02:13.701628939+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[45cc:7c5b:4d26:7aa1:ae7e:d9bb:ea07:456]:65311","48.237.159.121:13531","55.139.180.4:64685","[bae8:1f82:ff78:e8a8:235e:a50e:c131:2e8]:43129","[3486:5bc7:ada8:8da1:9df9:3cc6:d018:ee8b]:65112","43.182.159.11:27315"]','2022-04-09 09:43:07.09027176+02:00','2025-04-04 16:02:13.701896564+02:00',NULL,'node009',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(10,'mkey:4edbeff705459e7e5d0df80d42abce8d3db49137e013cbe38416aa2d0e77e4de','nodekey:149c771cccddad67f62a6cdf8ebc282692d3f8138e6749e3bcb8044209f30ea8','discokey:7773ea1a30faff0ef3d64186b00fc7f0d584c68eea4e3d75ad6dab5cfb54bee4','email-49',1,'authkey',NULL,'2025-03-22 18:28:09.173419272+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["61.59.238.85:46024","221.176.225.4:60304"]','2022-06-26 13:57:07.40762063+02:00','2025-03-22 18:28:09.173773792+01:00',NULL,'node010',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(11,'mkey:0bd4a2eac9b6f9b77ab9ee9ea42b36b74d73e0544a2c482526b2385e8bcb0c34','nodekey:1a5c66957c54314f72ea26fed12e48b9c4149c1f640300e39d6190226bc1aaf8','discokey:9f151fb1569ef5341c8f54eec62b82cb7e5f21540ebe9271ae6449a31250123a','laptop-22',1,'authkey',13,'2025-04-03 22:06:46.872430113+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["55.247.173.145:28477","197.123.99.18:53038","102.60.187.246:41096","155.239.169.182:41163","[c908:b81c:b4c8:38d3:e311:b3f6:3067:227c]:11541"]','2022-06-26 15:19:50.566498735+02:00','2025-04-03 22:06:46.873132509+02:00',NULL,'node011',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(14,'mkey:c7d3e8e40cafce614b65f150e345fefab60dd5b8108bc47e5159e8d3464496f8','nodekey:06d9c1b8455e39baee27729233638fd793e38376a0caafd76cfb3f1fe929b331','discokey:93ec10f68b6950a9a842c6e2cf186d86334705cf174d50985a3f4c8561246e9f','lt-29',1,'authkey',NULL,'2025-03-30 11:38:07.287941738+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["34.25.194.159:63765","147.22.45.153:11543","30.125.129.134:36303"]','2022-09-26 16:07:54.206927686+02:00','2025-03-30 11:38:07.288217849+02:00',NULL,'node014',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(23,'mkey:2cc72bee6bf01caeb26a1d00ad6653d7a2f06252afe9f7e9cbb4e1701d3d7da4','nodekey:7edccf09f05dd46626c2981cc69c74c593d314aced7de30423142ba090521d72','discokey:98629534198740b432a58b75cee1c37bd3bdc0d85e85d7fe514af16881fc420b','srv-12',1,'authkey',23,'2025-04-03 21:18:57.701368882+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[ec95:2e1e:2d50:967c:c90f:9d1e:4a3e:cac6]:63487","[57e5:faa8:aee0:9b66:a0e:6a4f:f715:631]:23151","209.114.161.143:52706","[6d6f:fcc8:f538:9546:a467:a161:1e3f:ad80]:45335","[d8b4:ed81:6b2f:8517:c171:871:7319:6abb]:54186","[dcb5:9eee:2075:acba:1a31:1669:21dd:744b]:48312"]','2023-05-05 10:08:17.301597525+02:00','2025-04-03 21:18:57.701435228+02:00',NULL,'node023','[]','100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(24,'mkey:cdd2725a2eec500da5a278444f3f3f82351e3df4b38c73781a8c04bdcdf469f3','nodekey:badffb3b36094dcff5902db9b857c436f2aa91b3a0fc2fc8f0b7e0a6cfce842d','discokey:68d8447103b317e2a41dccf0dc60017b8554f55639de9b13ffc9f07366e0dffa','desktop-58',1,'authkey',25,'2025-01-13 15:02:48.676721758+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["62.8.65.228:34575","58.211.127.215:33647","47.22.77.26:36499","185.25.84.152:44786","[c7d0:cf6f:bb45:6922:7fd7:adb7:59f5:499e]:60522","65.200.68.231:16530","11.209.67.55:8308"]','2023-08-14 18:15:34.292188686+02:00','2025-01-13 15:02:48.67679754+01:00',NULL,'node024','[]','100.64.0.15','fd7a:115c:a1e0::f');
INSERT INTO nodes VALUES(25,'mkey:54219375ce0ab01cd59b56ad984df668ae7cbe49b7b91e44877ae0d7012d6106','nodekey:2b0c163bc497f6214b25d6a333a37d273c260630dcc91782897f19a579f92a5b','discokey:4cf24a025241ad9a69c20d40513dfee5626f934d738e18f4a64fd9a1ace2cb24','srv-15',1,'authkey',26,'2025-03-31 23:15:14.255680838+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[60da:30ec:55bd:5ab3:3fe7:5492:1fc8:92f3]:36566","105.238.97.70:40193","[8c84:2d7e:5e1a:2f51:8754:aa54:b421:a19f]:60672","[5101:751a:5e00:cf46:8b50:8ba9:3c8e:4c7c]:33862"]','2023-08-29 08:30:45.518580154+02:00','2025-03-31 23:15:14.25655063+02:00',NULL,'node025','[]','100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(26,'mkey:96e8e0e986089fe5d0f5418f7ccb0a701401def77b8c5e1c337e7c5b865aa20c','nodekey:0e01df602ea65f549245772540b04373a8f2ab64a781251598226e99a6fc341f','discokey:444d74201443318337b9c8118b6d62ab087049cd1258b1b670dd3d8b8b883bd0','lt-82',1,'authkey',27,'2025-04-04 15:59:56.081157956+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["12.54.208.97:59171","[13a0:b8ff:bebb:d48:e16e:869d:b542:531b]:17201","44.157.88.255:43418","8.250.82.20:52374","180.217.175.155:13947","[76d7:a0ac:7cf2:9237:df96:42d2:4086:5b93]:41885"]','2023-11-03 18:53:48.108033118+01:00','2025-04-04 15:59:56.081857808+02:00',NULL,'node026','[]','100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(29,'mkey:ef670d35dba3168a251ce7230dfd073594f7e8454c55d2eea392b11b7eb2c58d','nodekey:c4fe657c9168dd2d798452d1c411faa57d7f2866808cf7fee5e5251eba58cfed','discokey:f47bc0695fd2db95519a8fc51ecc628c4b869dea953b34b88095c765ac4c8b2e','srv-21',1,'authkey',NULL,'2025-04-04 10:13:54.951364016+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c018:a17d:2177:f7b8:482d:b68b:9b7a:c3f4]:52482","[99d:8ae6:556e:9e4a:b721:e12f:cec4:d571]:25093","[688f:e843:1471:41c0:868f:f77c:e787:8d13]:24194","[ae51:6570:f6b6:7d2b:1803:50f1:6e3a:faa4]:6218","62.26.91.22:45257"]','2024-06-02 09:46:39.307697473+02:00','2025-04-04 10:13:54.951675714+02:00',NULL,'node029','[]','100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(30,'mkey:a50ccd27d81ae5fa4e8cf617b9a923d18b818d5903d1aa008044cf4a2145f5b4','nodekey:eb0607968c785075216b01d5e11a67124f7ab9bd8d11498aa29cd68ca7355d8b','discokey:beffe8994e5a4baf7553267e7df7da7460552b3ec1b8b0b2d12f467a07810dea','db-89',1,'authkey',30,'2025-03-31 23:15:17.070924864+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c7b3:52c3:f5c3:87c:f5ed:213:85f4:44c5]:18304","49.111.96.135:35528","[abc1:b7cd:f18:6ed2:4b5a:9dce:3f08:8c17]:333","206.118.184.48:48132"]','2024-07-29 14:24:27.684620193+02:00','2025-03-31 23:15:17.071471786+02:00',NULL,'node030','[]','100.64.0.12','fd7a:115c:a1e0::c');
INSERT INTO nodes VALUES(31,'mkey:e76b247ac8acd857970abf462c8c954f670d78fe190ca537ef68983de00806e0','nodekey:bf2c0b7e9271cb7addf94f7ee4b5c2bfab9f279fb124c76f0d1fed4b4125e422','discokey:af105f27a8a9c750ba54da2defc49dbf001891b96e6a1bb1b96ee39056e1ff5f','laptop-03',1,'authkey',31,'2025-04-04 15:57:02.028544413+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["187.133.234.227:17532","143.220.168.161:8383","[3981:7f70:a471:4993:c3a4:3173:1b62:544e]:43648","200.130.212.85:63469"]','2024-08-07 20:35:12.944541318+02:00','2025-04-04 15:57:02.03016371+02:00',NULL,'node031','[]','100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(32,'mkey:e66714b599a0fcd24e7e87019cfbfc3b9d6d1c9c3b0bb70912d6e7bc7398f8fa','nodekey:0dba1091e5ff8fbf639f490eabaa0fa5188cc076cb8922eb6889b023fc4384bc','discokey:a05e361212ffc667037a9997a178a9d0a50453bded8dfe3772fed2b711092c58','db-20',1,'cli',NULL,'2025-04-04 15:55:20.925507947+02:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c47f:35c9:41fe:6f5:a40d:3e8b:6679:411e]:12963","19.205.218.60:63516","116.228.193.194:44296","[ee98:8de3:1f5b:731c:751b:ba46:a4a7:8760]:23245","[6eb3:8c34:e6c9:4c6a:25c9:89ca:c165:354e]:65112","[7003:63bb:6429:d463:96a6:990:2bdc:217d]:4300","[d820:584e:2b46:6915:6420:3056:f76:9e33]:48885","25.167.184.15:1967","82.253.97.208:8684"]','2024-10-26 07:18:04.947942936+02:00','2025-04-04 15:55:20.925847076+02:00',NULL,'node032',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
INSERT INTO nodes VALUES(33,'mkey:e885828fffb844493b9ac09514500e4832d588586274d7ab134def4758aec8b4','nodekey:69ecbf0eda9c36c6a5a3a5bbdaebcbe87843112ccb5004acdaa3273557cca09e','discokey:3076854f388bce0a53ce84c6a01f0ce677f641bc2429b10206c6c2de7ac75a7f','laptop-99',7,'cli',NULL,'2025-04-03 22:00:57.883174604+02:00',NULL,'{"fake":"data"}','["104.248.144.146:61623","[a05:c6f9:3d44:8c37:71b:94bc:c915:47aa]:9656","15.105.112.6:17162","67.6.72.132:32571","[524:9a03:6a60:cc60:d594:b98e:e32f:d883]:8390","86.91.139.227:63567","206.126.50.249:22311","[a1f9:9745:a2ed:1bb7:9405:91f9:1c52:8c28]:14465","155.71.33.111:62332","[fd76:427:7ce5:c2b2:183a:1281:d6bb:8633]:47777","[2133:a7d0:99d5:fcce:44dd:8de3:dffe:61f5]:30756"]','2025-02-23 07:59:15.141530181+01:00','2025-04-03 22:00:57.883491572+02:00',NULL,'node033',NULL,'100.64.0.11','fd7a:115c:a1e0::b');
INSERT INTO nodes VALUES(34,'mkey:bc9632988599109f50c950f4069c6a38f9e04d22f81f5bbd4edfdf271ea3b772','nodekey:a9be3965ba99bf7ef5ca7eee6f1ea50043fab7e40a2da3b8ea45e5c5c859d0e7','discokey:f9c9d5de5033f54236970fa4c12fe4f475be4c2a00f57418f396057142aea9f3','srv-85',9,'cli',NULL,'2025-04-04 00:05:39.390959034+02:00',NULL,'{"fake":"data"}','["[1b72:b6ce:5ad1:81e3:bc01:6516:f696:e19e]:15160","[fc:3ed4:df18:5664:71f1:6c7b:652a:7fcd]:27806","[417a:9260:6c16:5a4c:911d:eaec:7e3b:cf47]:58735","190.241.43.139:19489","[9b36:5bd4:a077:9b75:65ac:ccd0:170f:69b9]:41358"]','2025-03-09 11:42:30.627548688+01:00','2025-04-04 00:05:39.391044635+02:00',NULL,'node034',NULL,'100.64.0.18','fd7a:115c:a1e0::12');
INSERT INTO nodes VALUES(35,'mkey:0a58d0ca3bac65adeddc621d1355a3801b088c393a93bc83a55c198e7ef1858e','nodekey:f25a54c9ec984566a1a245aee7f85f92ffccc090be0d4d9fdab081e23a5bd2c5','discokey:2d95fd862eb2087d1345f2825e8b3013ca9037cc44f595fc1374850ecce93c9f','desktop-75',9,'cli',NULL,'2025-04-04 12:24:50.896091765+02:00',NULL,'{"fake":"data"}','["115.214.18.115:26087","209.46.195.111:48055","[2030:c7ae:bde5:536c:7748:3ac:9eea:2468]:45768","[1ec6:10e:5a64:942e:cb28:7d65:97cc:8e89]:14623"]','2025-03-09 12:06:19.756893731+01:00','2025-04-04 12:24:50.896434652+02:00',NULL,'node035',NULL,'100.64.0.22','fd7a:115c:a1e0::16');
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(7,'2023-01-15 14:41:49.445054371+01:00','2023-01-29 10:12:11.959527554+01:00',NULL,14,'0.0.0.0/0',1,1,0);
INSERT INTO routes VALUES(8,'2023-01-15 14:41:49.452617331+01:00','2023-01-29 10:12:13.154311101+01:00',NULL,14,'::/0',1,1,0);
INSERT INTO routes VALUES(9,'2024-05-05 07:16:02.944084847+02:00','2024-05-05 13:25:02.977065366+02:00',NULL,3,'172.30.190.136/30',1,1,1);
INSERT INTO routes VALUES(10,'2024-05-05 07:16:02.95709561+02:00','2024-05-05 13:25:04.513930181+02:00',NULL,3,'10.241.118.90/31',1,1,1);
INSERT INTO routes VALUES(17,'2024-08-08 20:44:22.76306591+02:00','2024-12-21 12:10:07.339044415+01:00',NULL,31,'192.168.0.0/17',1,1,1);
INSERT INTO routes VALUES(18,'2024-08-08 20:47:33.469970726+02:00','2024-12-21 12:10:07.442783446+01:00',NULL,31,'192.168.192.0/19',1,1,1);
INSERT INTO routes VALUES(21,'2024-08-08 20:54:05.146666051+02:00','2024-12-21 12:10:07.538738125+01:00',NULL,31,'172.29.254.8/29',1,1,1);
INSERT INTO routes VALUES(23,'2024-08-08 20:54:05.162212208+02:00','2024-12-21 12:10:07.644714175+01:00',NULL,31,'172.18.8.0/22',1,1,1);
INSERT INTO routes VALUES(25,'2024-08-08 20:54:05.179419681+02:00','2024-12-21 12:10:07.753927883+01:00',NULL,31,'10.169.34.250/31',1,1,1);
INSERT INTO routes VALUES(26,'2024-08-08 20:54:05.186132539+02:00','2024-12-21 12:10:07.871905187+01:00',NULL,31,'172.24.0.0/16',1,1,1);
INSERT INTO routes VALUES(28,'2024-08-08 20:54:05.202442818+02:00','2024-12-21 12:10:07.972132539+01:00',NULL,31,'10.149.80.0/20',1,1,1);
INSERT INTO routes VALUES(31,'2024-08-08 20:54:05.246698925+02:00','2024-12-21 12:10:08.150358433+01:00',NULL,31,'10.232.0.0/13',1,1,1);
INSERT INTO routes VALUES(32,'2024-08-08 20:54:05.256984635+02:00','2024-12-21 12:10:08.349521909+01:00',NULL,31,'172.23.0.0/21',1,1,1);
INSERT INTO routes VALUES(37,'2024-08-08 20:54:05.300971626+02:00','2024-12-21 12:10:08.553265285+01:00',NULL,31,'172.17.124.137/32',1,1,1);
INSERT INTO routes VALUES(43,'2024-08-08 20:54:05.383430747+02:00','2024-12-21 12:10:08.66112581+01:00',NULL,31,'10.91.8.0/21',1,1,1);
INSERT INTO routes VALUES(47,'2024-08-08 20:54:05.443181025+02:00','2024-12-21 12:10:08.826993878+01:00',NULL,31,'192.168.222.64/27',1,1,1);
INSERT INTO routes VALUES(48,'2024-08-08 20:54:05.449778605+02:00','2024-12-21 12:10:09.237117302+01:00',NULL,31,'10.16.0.0/12',1,1,1);
INSERT INTO routes VALUES(49,'2024-09-03 06:43:34.875117755+02:00','2024-12-21 12:10:09.342259317+01:00',NULL,31,'192.168.191.192/28',1,1,1);
INSERT INTO routes VALUES(50,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'10.225.156.72/29',1,1,1);
INSERT INTO routes VALUES(51,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'172.28.71.145/32',1,1,1);
INSERT INTO routes VALUES(52,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'10.104.0.0/13',1,1,1);
INSERT INTO routes VALUES(53,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'172.16.0.0/13',1,1,1);
INSERT INTO routes VALUES(54,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'10.60.104.0/24',1,1,1);
INSERT INTO routes VALUES(55,'2025-02-23 06:43:34.875117755+02:00','2025-02-23 06:43:34.875117755+02:00',NULL,33,'10.89.96.0/19',1,1,1);
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,'2022-02-26 18:00:56.104436744+01:00','2024-09-14 08:51:13.31135114+02:00',NULL,'user001','','',NULL,NULL,'');
INSERT INTO users VALUES(4,'2022-04-01 22:30:02.657653341+02:00','2024-09-14 08:55:27.877614108+02:00',NULL,'user004','','',NULL,NULL,'');
INSERT INTO users VALUES(7,'2024-05-05 07:08:47.915309504+02:00','2024-09-14 08:55:02.778476991+02:00',NULL,'user007','','',NULL,NULL,'');
INSERT INTO users VALUES(8,'2024-09-14 08:57:26.215082073+02:00','2024-09-14 08:57:26.215082073+02:00',NULL,'user008','','',NULL,NULL,'');
INSERT INTO users VALUES(9,'2025-03-09 11:22:20.790371056+01:00','2025-03-09 11:22:20.790371056+01:00',NULL,'user009','','',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