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

96 lines
24 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');
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);
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'243262243132247a447a433335436450323462305a332e77487845574f4837583374565134787030332f7046786e33726e69795a5336666762613569','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'2432622431322438673039635a2f41376a6b6e444e69523531684e564f4d573665423056366179484b726c304565586f6851674373786d612e4c414b','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'24326224313224764f6938636f6a677265624236424a33743559754e654742344d46674c427a4441314e38546166364578326151706b73305334544b','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:6a9f06fccf0eff626075428e16c07c2e93464667a67c84dd0efadb1a74761d72','nodekey:d0d67c955181f1a9369a471496e1004678eebd93660394949848e61c7132ef9e','discokey:7667a90b1915f5cb3f725d159cd3f8bc3e46f6244df25f45d7fadc830a6d064e','web-05',1,'authKey',3,'2025-02-03 20:14:56.533547475+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["198.139.228.73:16016","[a5dd:542c:6998:997c:2d87:61b0:c760:ab6f]:56919","112.221.140.130:19743","[6520:763a:5fe2:8e88:5c8e:5b03:eeb1:5588]:20840","[7670:9084:a917:1173:70ce:2798:c805:66dc]:50297"]','2022-02-26 18:11:55.92837512+01:00','2025-02-03 20:14:56.533664987+01:00',NULL,'node001',NULL,'100.64.0.1','fd7a:115c:a1e0::1');
INSERT INTO nodes VALUES(3,'mkey:67287ef80f62664d68f3050e68ced4e8f78e173151801529551d42fd8e951b40','nodekey:6afc027970c1ddf9b3544b8c49223dcafe436a51384f80bb341a8f8322bef6d8','discokey:86693fc9f959f11015f3ff457b8d62381a6542e2eef097e2b6bdd679175c975b','srv-24',7,'authKey',NULL,'2025-01-29 12:28:39.61495602+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[2cbd:607c:5e91:ea51:38ed:557:fd0:3405]:48307","[790b:6b18:8ac1:afa8:c2d3:f6b:37f6:623f]:41499"]','2022-03-01 19:26:46.242187887+01:00','2025-01-29 12:28:39.615036412+01:00',NULL,'node003',NULL,'100.64.0.3','fd7a:115c:a1e0::3');
INSERT INTO nodes VALUES(4,'mkey:e0630dc6f407e6064c010dbef10b982c6e9d731706cc13b10993b542e81edf47','nodekey:44f96cda7202665271958eac8a3cfb120ea72209ee88d93fac3c23aeafa3a993','discokey:48b58784e2acdad30028ceed18bc9e7bd5fae3605dbef1a40f3f38a705adef9d','desktop-44',1,'authKey',6,'2025-02-03 15:13:03.806943975+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b53b:c286:a007:e851:dc6e:8152:82a5:22ca]:25604","[ff9b:6bbd:77bc:323d:12e4:22ba:b712:80c]:37729","[1e76:19af:e817:9a33:4f83:366e:b686:6362]:39521","57.71.157.166:9055","[c199:e8ca:c1bb:8364:dde8:bf3e:9467:c050]:61218"]','2022-03-04 08:27:19.383566031+01:00','2025-02-03 15:13:03.807014419+01:00',NULL,'node004',NULL,'100.64.0.2','fd7a:115c:a1e0::2');
INSERT INTO nodes VALUES(5,'mkey:4f7673e616b40b313ef69fd390e9c4bdb4c80f66840defb02c37d6f2fa152c5c','nodekey:91ee8b593bb0599e9583a692dabef9528423878f737f7bfdf339fc02bbe8ab47','discokey:fb3b2c151a0d277e77837dc2a5e96fe8f05bbefa770a84822689ec2c63dfe358','email-24',8,'authKey',NULL,'2025-02-03 11:10:38.911072801+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6add:4288:4372:c9ce:7cee:4852:e6d0:9d56]:44968","[884b:b2cc:e2f3:ab06:131b:e30c:69a2:363]:32943","49.81.27.127:23839"]','2022-03-05 13:54:23.660591381+01:00','2025-02-03 11:10:38.911239065+01:00',NULL,'node005',NULL,'100.64.0.4','fd7a:115c:a1e0::4');
INSERT INTO nodes VALUES(6,'mkey:e8a549e38c8301af3c044ff9ca1df86c814bc9c9a62bddd28ff47ebd9b113d07','nodekey:f0188064db0f31b49e1048044186d20700406a7a7b71b054507c90d5a79e7de4','discokey:30687e0c15fc480ef15f9d91011c9fa458c18370db11cdc8b72f36e814e9ece2','lt-01',1,'authkey',NULL,'2025-01-31 17:38:20.368668048+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[be53:e324:1587:4d86:d24c:8662:cd5c:a4c8]:58105","59.239.218.25:49807","[cfa4:ad2e:1410:3b78:ce03:b437:6749:ff3a]:39835"]','2022-03-21 15:52:20.739594362+01:00','2025-01-31 17:38:20.369001909+01:00',NULL,'node006',NULL,'100.64.0.5','fd7a:115c:a1e0::5');
INSERT INTO nodes VALUES(7,'mkey:45c951d703f782a16a6db8b4dc872952308f86883499d0613f03318d18f3e7fe','nodekey:70837c16d309644e71e6b251bdb66c4e6a5c9b9f6e23a3b803142b8f00d1017a','discokey:ebe6dd61b6b2bafccce9d01ba0d58ea2ee93a90ae6cafb4383453fb4a17441b4','desktop-61',4,'authkey',10,'2025-02-03 22:34:14.985433991+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[e5e8:7d01:63fc:4220:3b4a:df5:ebe:748c]:47047","[7513:6321:b35:b633:b39e:41ed:10a1:3fdd]: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"]','2022-04-01 22:43:27.318756043+02:00','2025-02-03 22:34:14.986222409+01:00',NULL,'node007',NULL,'100.64.0.6','fd7a:115c:a1e0::6');
INSERT INTO nodes VALUES(8,'mkey:3dff46782f13efbfe7b1a9d5d3275f48954a1abe29111b484fdb3c6edfb795bd','nodekey:080424852e9cbe3c2eaac52c1890cf485bbc2604615ec3c293b80322f17dbe63','discokey:2f6a05491ef99cafaf968c0c62b5c9d19083ef070991ee677d14b0ac9ce08377','db-70',7,'authkey',NULL,'2025-02-03 18:06:33.350444688+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["166.240.74.240:40259","[7311:ce3c:e8cf:c591:533:7132:4504:52ca]:48923","[4912:5cdb:3ed8:7c52:6b8b:2d37:59bf:cf98]:20693","[bad1:e653:831e:aa61:61e4:f824:996a:aac9]:11845"]','2022-04-03 09:38:46.178224968+02:00','2025-02-03 18:06:33.350771325+01:00',NULL,'node008',NULL,'100.64.0.7','fd7a:115c:a1e0::7');
INSERT INTO nodes VALUES(9,'mkey:05d3833026a1ecd188cc6d2b9b7f9c8a0c51baefabf20a167c85c0c6ef722669','nodekey:d281e1bea5bb2e5d2d01bf476a5ea0df5578a663211c2281dc757024f6233f90','discokey:010f415b1e41652b3eabcebdbaa1e2e62fb1412f817304c125776ecd45621fba','desktop-21',7,'cli',NULL,'2025-02-02 07:50:20.222960357+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6102:58dc:7ffb:200a:53e:b50d:38d5:45a8]:29126","32.34.123.165:35870","[1daf:274c:55b2:7413:3c1:bd3d:acc5:4eb1]:33732","182.237.82.235:32290","6.93.152.196:16212"]','2022-04-09 09:43:07.09027176+02:00','2025-02-02 07:50:20.223029247+01:00',NULL,'node009',NULL,'100.64.0.8','fd7a:115c:a1e0::8');
INSERT INTO nodes VALUES(10,'mkey:521fa99ee8b613be5da1bc0fa53e3a11806db23487572f13ce3a99b5750f47d8','nodekey:c2fd5b20a911b8193b7bc8e2dfe68598422759afb0cae2a1f6faf8a975133f68','discokey:99030d8be2cf14592175083adec1a15fdadb1181db721c9ce4f9e5ed485e8422','db-82',1,'authkey',NULL,'2025-02-01 10:52:14.603941206+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[b12:6f03:406e:1855:3cf9:8eb6:e610:adbf]:18034","70.180.67.60:48287"]','2022-06-26 13:57:07.40762063+02:00','2025-02-01 10:52:14.604222347+01:00',NULL,'node010',NULL,'100.64.0.9','fd7a:115c:a1e0::9');
INSERT INTO nodes VALUES(11,'mkey:ad3363557d233776dee0fa50f7091eaa3b6b14b8d3b0243f0cc0f61662a01769','nodekey:f7a297c8b1bde8fea7e03e10a583e168a37a5c72d9ba3c39129536d4d80e9e6d','discokey:c4af50cd6bb472f0bc2bc3ded6336fb76708a902ba0032cdd6cb90eb819d9db1','laptop-60',1,'authkey',13,'2025-02-04 01:00:03.417141337+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[dba:4050:a7df:10:aa7c:ee6b:2610:5a14]:31519","128.57.253.0:39500","25.178.136.37:18298","86.9.216.195:48221"]','2022-06-26 15:19:50.566498735+02:00','2025-02-04 01:00:03.417910968+01:00',NULL,'node011',NULL,'100.64.0.10','fd7a:115c:a1e0::a');
INSERT INTO nodes VALUES(14,'mkey:224a190ba40d8ebf84ac065a47d4e370d127151dc5b608d2f062855e67951a5d','nodekey:a81c40b004ca1a472f2d2240ea3b86f55d5f52252254d5fab7643ba0e059b684','discokey:31644ea51b89d09e6568b6f78b604a62ee7f4a5e7c0a56f194717cdcc43a6384','email-58',1,'authkey',NULL,'2025-02-01 06:18:54.156166977+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["178.84.150.172:60924","[171f:b843:ff2e:b9f0:9890:1aac:42e5:c2ab]:47842","174.7.154.174:51720"]','2022-09-26 16:07:54.206927686+02:00','2025-02-01 06:18:54.156467144+01:00',NULL,'node014',NULL,'100.64.0.13','fd7a:115c:a1e0::d');
INSERT INTO nodes VALUES(23,'mkey:bafb298852c932db46635dc6ff11a41910936907bbc6bcc5dd2d8c485c2e5b0c','nodekey:bb4a7ef9aa1a821da2f76215bcb534c3a6a7658432dafaf88a1aecff0e75f782','discokey:f0e92a4c7368ee694d70928c8c4e14b207fd7f69dfead643ce4f616cdd7a1c13','web-96',1,'authkey',23,'2025-02-01 06:44:19.76979225+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["21.139.115.42:33169","211.231.253.41:1096","171.127.122.217:28477","197.123.99.18:53038"]','2023-05-05 10:08:17.301597525+02:00','2025-02-01 06:44:19.770530333+01:00',NULL,'node023','[]','100.64.0.14','fd7a:115c:a1e0::e');
INSERT INTO nodes VALUES(24,'mkey:7f865473ff4681875a1b31d7160ef2f4ba3c59cb9cfd815a6085dd266e1027a6','nodekey:86b906c4f3540ec63474279bf542136b24fe741f7944ca88c3bd3cea132906b7','discokey:c2f69d5e677759839a7761f43eb250d4faa1873ddbc53f3e4f1bc4ef98ab2041','db-96',1,'authkey',25,'2025-01-13 15:02:48.676721758+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f41f:b9e9:9205:210a:4ff9:ab34:57fd:3148]:21852","[3d49:412:9781:b399:f9a5:587e:bd2e:a579]:3775","[867:a7e:7e04:bfbb:6286:f95f:1abd:9b5a]:63765","147.22.45.153:11543","30.125.129.134:36303","[213c:e72:d34:c59c:d4fa:8bb5:f6d3:d691]:24926","83.92.114.14:38013"]','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:1be02a7f57e51fa42c3af087a1464b33d33ad2802979d102c8b10ac146091537','nodekey:1fc37765c4fbcf068f0dd37f2b98d4d1fe35fc7c9e20ea8ed2be4b52b97481b4','discokey:9ea68ef044c00841bb6187dafedc8811caa4b12d123e00119eba0462b9dac6b2','db-52',1,'authkey',26,'2025-02-01 06:27:05.583933643+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[f538:9546:a467:a160:1e3f:ad81:b5aa:f88d]:56031","14.178.248.81:54186","[dcb5:9eee:2075:acba:1a31:1669:21dd:744b]:48312","91.212.243.143:50528","33.141.84.140:39332"]','2023-08-29 08:30:45.518580154+02:00','2025-02-01 06:27:05.584696672+01:00',NULL,'node025','[]','100.64.0.16','fd7a:115c:a1e0::10');
INSERT INTO nodes VALUES(26,'mkey:5a1b0920cafe0a8b54af7194baceac2029c4b12afc0e542423637f47cc4e53e7','nodekey:927c5ab7c0b8288ca36897c5f371487e9dc2200f28507029e1864086d95b5b1e','discokey:260c9a090d46eef056c0d411d4097b41aa0e9902f15cfa59906ee85f526f52b6','srv-51',1,'authkey',27,'2025-02-03 23:37:12.671308191+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[6676:38fc:5af9:3b60:41b7:e46e:bbe1:c8bf]:30898","[4aba:d70:c25d:5d4d:1bc0:d119:4749:9efc]:37269","[9320:382a:5779:2fa7:b46f:c4d5:f889:3155]:46058","[3d31:7ec5:7635:7b6c:c7d0:cf70:bb45:6922]:16454"]','2023-11-03 18:53:48.108033118+01:00','2025-02-03 23:37:12.672006599+01:00',NULL,'node026','[]','100.64.0.17','fd7a:115c:a1e0::11');
INSERT INTO nodes VALUES(27,'mkey:2ce8df9ae8623e48e779b951eab64134bf2806d747f1fb4d7669634fa48d9f22','nodekey:3e85d212d118f58a3a72de4d251ab9414dbe682ac3ebb36ff1283eb6fd438c7a','discokey:9e21249dc8a197f51dbd3916f74c977e222cb96639c4f17abb1856044c4593a1','srv-15',7,'authkey',NULL,'2025-02-02 21:00:46.231324685+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["169.217.181.115:16351","[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","[b9fe:3630:1807:826:a4a6:e5d2:532c:bdc8]:43617","[25b5:5b72:2ecc:193c:b61e:329:81c6:5af6]:39854","214.128.115.35:43726","[436d:61b:9834:b0e0:b2ed:b452:6330:34ee]:59171"]','2023-12-29 19:18:10.814399482+01:00','2025-02-02 21:00:46.231636043+01:00',NULL,'node027','[]','100.64.0.18','fd7a:115c:a1e0::12');
INSERT INTO nodes VALUES(29,'mkey:2e4b2ebd78830b52e6d3bc2df58a4ae2e650aa2d45d05e556b6f412ec26797b3','nodekey:b12b04927b21983c33d4e6343dbc3ca854cdddea3d53f116c79d2029cb017a36','discokey:9cd971dee5320ec78268f1c672aeea1f7ab1e88d1d97a27d1f6fd08154f2dc9b','srv-55',1,'authkey',NULL,'2025-02-03 21:59:46.11595827+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[c4c8:bd7a:122a:a5f6:664b:2744:fa5:2148]:38679","[1b3d:ef50:26cd:7cdc:d63b:eafd:a9d6:9432]:33036","[3b4a:1ade:51ce:e1f2:a6b8:8e5f:76d7:a0ac]:49522","141.1.118.254:20536"]','2024-06-02 09:46:39.307697473+02:00','2025-02-03 21:59:46.116259679+01:00',NULL,'node029','[]','100.64.0.19','fd7a:115c:a1e0::13');
INSERT INTO nodes VALUES(30,'mkey:a186e5e70f59e2fd804383e339a670ed2c312ec724ed0a389fe032921f697416','nodekey:2695f24b44d79bb02448dca69cd123fb5ff88dfccb27df9f9f57fb161ccb8697','discokey:726229d0e17c4a9253ae9c3fea0917aa2b5ace2d5b7bb6b17702502d9d22cae3','srv-45',1,'authkey',30,'2025-02-01 06:45:41.071375563+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["[cec4:d571:6561:992:e89f:e420:6681:42b5]:43741","96.163.138.14:53535","[7692:18d5:2f41:257d:dc1b:c70a:ea6c:1ad1]:56437","203.8.194.84:16031","54.25.61.205:2000"]','2024-07-29 14:24:27.684620193+02:00','2025-02-01 06:45:41.072086485+01:00',NULL,'node030','[]','100.64.0.12','fd7a:115c:a1e0::c');
INSERT INTO nodes VALUES(31,'mkey:7b374d2331a08697dc07b40066b707444d63dc02ec83a683e3cfb75f507e7219','nodekey:972d7a74740a75e43160bfa760aebfc273f3cab325abf9fdaa05d188615af553','discokey:9eaa7700bbc80de6cf2a7e115ff486727bc0bf063ccb2df44350c1a3e360fe90','lt-91',1,'authkey',31,'2025-02-03 20:18:00.015726064+01: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","7.64.160.114:11101"]','2024-08-07 20:35:12.944541318+02:00','2025-02-03 20:18:00.016420173+01:00',NULL,'node031','[]','100.64.0.20','fd7a:115c:a1e0::14');
INSERT INTO nodes VALUES(32,'mkey:8010732f3bbb0f58f3002b645258dbbc7d6c5cfebf8a485685a84da9b30dcf00','nodekey:d34dac3b348cd2d100ba36a85b42542cfe1dc74d51197caf50b138fea1401168','discokey:e28e9f435da77357942130f3923bb584773e6812d8d27fdc6dce20cc0cc0f752','lt-44',1,'cli',NULL,'2025-02-04 01:12:27.847003546+01:00','0001-01-01 00:00:00+00:00','{"fake":"data"}','["85.212.234.244:43593","161.5.250.27:14020","[cd55:bf01:5540:c30:3981:7f71:a471:4993]:25285","24.16.62.70:35569","213.115.82.246:7596","195.216.27.246:54466","[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"]','2024-10-26 07:18:04.947942936+02:00','2025-02-04 01:12:27.847267263+01:00',NULL,'node032',NULL,'100.64.0.21','fd7a:115c:a1e0::15');
CREATE TABLE `policies` (`id` integer PRIMARY KEY AUTOINCREMENT,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`data` text);
CREATE TABLE IF NOT EXISTS "users" (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`name` text UNIQUE,`display_name` text,`email` text,`provider_identifier` text,`provider` text,`profile_pic_url` text,PRIMARY KEY (`id`));
INSERT INTO users VALUES(1,'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,'');
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,'10.138.98.32/27',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,'192.168.208.0/20',1,1,1);
INSERT INTO routes VALUES(11,'2024-05-05 12:46:08.770263657+02:00','2024-05-05 12:46:39.012076195+02:00',NULL,27,'172.19.128.0/20',1,1,1);
INSERT INTO routes VALUES(12,'2024-05-05 12:46:08.779527998+02:00','2024-05-05 12:46:39.843489833+02:00',NULL,27,'10.68.0.0/14',1,1,1);
INSERT INTO routes VALUES(13,'2024-05-05 12:46:08.787239639+02:00','2024-05-05 12:46:40.983839193+02:00',NULL,27,'10.243.219.68/31',1,1,1);
INSERT INTO routes VALUES(14,'2024-05-05 12:46:08.794135892+02:00','2024-08-18 08:45:35.831813635+02:00',NULL,27,'10.30.155.128/25',1,1,1);
INSERT INTO routes VALUES(15,'2024-05-05 12:46:08.799975671+02:00','2024-05-05 12:46:44.333956126+02:00',NULL,27,'10.64.0.0/13',1,1,1);
INSERT INTO routes VALUES(16,'2024-05-05 12:46:08.806879988+02:00','2024-05-05 12:46:45.422824419+02:00',NULL,27,'192.168.0.0/16',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,'172.27.33.0/24',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,'10.151.196.0/23',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,'192.168.33.128/26',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,'10.69.87.96/27',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,'192.168.240.184/30',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.19.162.160/27',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,'172.30.190.136/30',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.241.118.90/31',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,'192.168.0.0/17',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,'192.168.192.0/19',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,'172.29.254.8/29',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,'172.18.8.0/22',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.169.34.250/31',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,'172.24.0.0/16',1,1,1);
CREATE UNIQUE INDEX `idx_api_keys_prefix` ON `api_keys`(`prefix`);
CREATE INDEX `idx_policies_deleted_at` ON `policies`(`deleted_at`);
CREATE INDEX `idx_users_deleted_at` ON `users`(`deleted_at`);
CREATE INDEX `idx_routes_deleted_at` ON `routes`(`deleted_at`);
COMMIT;
Reference in New Issue View Git Blame Copy Permalink