294 lines
12 KiB
SQL
294 lines
12 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19-11.6.2-MariaDB, for osx10.19 (x86_64)
|
|
--
|
|
-- Host: localhost Database: nodehub
|
|
-- ------------------------------------------------------
|
|
-- Server version 11.6.2-MariaDB
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
|
|
|
|
--
|
|
-- Table structure for table `cache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `cache` (
|
|
`key` varchar(255) NOT NULL,
|
|
`value` mediumtext NOT NULL,
|
|
`expiration` int(11) NOT NULL,
|
|
PRIMARY KEY (`key`),
|
|
KEY `cache_expiration_index` (`expiration`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `cache`
|
|
--
|
|
|
|
LOCK TABLES `cache` WRITE;
|
|
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `cache_locks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cache_locks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `cache_locks` (
|
|
`key` varchar(255) NOT NULL,
|
|
`owner` varchar(255) NOT NULL,
|
|
`expiration` int(11) NOT NULL,
|
|
PRIMARY KEY (`key`),
|
|
KEY `cache_locks_expiration_index` (`expiration`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `cache_locks`
|
|
--
|
|
|
|
LOCK TABLES `cache_locks` WRITE;
|
|
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `failed_jobs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `failed_jobs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `failed_jobs` (
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`uuid` varchar(255) NOT NULL,
|
|
`connection` text NOT NULL,
|
|
`queue` text NOT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`exception` longtext NOT NULL,
|
|
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `failed_jobs`
|
|
--
|
|
|
|
LOCK TABLES `failed_jobs` WRITE;
|
|
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `job_batches`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `job_batches`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `job_batches` (
|
|
`id` varchar(255) NOT NULL,
|
|
`name` varchar(255) NOT NULL,
|
|
`total_jobs` int(11) NOT NULL,
|
|
`pending_jobs` int(11) NOT NULL,
|
|
`failed_jobs` int(11) NOT NULL,
|
|
`failed_job_ids` longtext NOT NULL,
|
|
`options` mediumtext DEFAULT NULL,
|
|
`cancelled_at` int(11) DEFAULT NULL,
|
|
`created_at` int(11) NOT NULL,
|
|
`finished_at` int(11) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `job_batches`
|
|
--
|
|
|
|
LOCK TABLES `job_batches` WRITE;
|
|
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `jobs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `jobs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `jobs` (
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`queue` varchar(255) NOT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`attempts` tinyint(3) unsigned NOT NULL,
|
|
`reserved_at` int(10) unsigned DEFAULT NULL,
|
|
`available_at` int(10) unsigned NOT NULL,
|
|
`created_at` int(10) unsigned NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `jobs_queue_index` (`queue`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `jobs`
|
|
--
|
|
|
|
LOCK TABLES `jobs` WRITE;
|
|
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `migrations`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `migrations`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `migrations` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`migration` varchar(255) NOT NULL,
|
|
`batch` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `migrations`
|
|
--
|
|
|
|
LOCK TABLES `migrations` WRITE;
|
|
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
|
|
INSERT INTO `migrations` VALUES
|
|
(1,'0001_01_01_000000_create_users_table',1),
|
|
(2,'0001_01_01_000001_create_cache_table',1),
|
|
(3,'0001_01_01_000002_create_jobs_table',1);
|
|
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `password_reset_tokens`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `password_reset_tokens`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `password_reset_tokens` (
|
|
`email` varchar(255) NOT NULL,
|
|
`token` varchar(255) NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`email`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `password_reset_tokens`
|
|
--
|
|
|
|
LOCK TABLES `password_reset_tokens` WRITE;
|
|
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `sessions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sessions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `sessions` (
|
|
`id` varchar(255) NOT NULL,
|
|
`user_id` bigint(20) unsigned DEFAULT NULL,
|
|
`ip_address` varchar(45) DEFAULT NULL,
|
|
`user_agent` text DEFAULT NULL,
|
|
`payload` longtext NOT NULL,
|
|
`last_activity` int(11) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `sessions_user_id_index` (`user_id`),
|
|
KEY `sessions_last_activity_index` (`last_activity`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `sessions`
|
|
--
|
|
|
|
LOCK TABLES `sessions` WRITE;
|
|
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
|
|
INSERT INTO `sessions` VALUES
|
|
('1HbV0H5Wtp0FMbZREBjeMVlIbSYfDjeXobLeqJzt',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.3 Safari/605.1.15','YTozOntzOjY6Il90b2tlbiI7czo0MDoib3M2cTZQVkdDT0J0SU8zVHUweXhPbzNuV3g5ZFN4dzQ0SFVLNklVWiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vbm9kZWh1Yi5sb2MiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1770115426),
|
|
('4YVFp4hvxeRGiKQI5pD5bFTZpUuzGsKGVRuH6Pzn',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoibWxkZUwwSENvNXBiVjlqZW9xazJndVRqYlBNOVFtQWMxYmVDTkNoVyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770191025),
|
|
('7Kp8cHA3IJTDg8tpXS7E7wAp9gVZ0S5sfqzA9ltT',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiVVB4S2dVdWFsREZtN3B2bXNVS1daRFJqM2pMTmJIRFBDdHE0c2tUUCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770114456),
|
|
('8U5i5L6aFHlhUjXQZcgxv4bBaG2bTZLQCNjZbDxB',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiT282ZEtYcGZsYWZ4WlNDMEVBWkR6d3lrTlIwQ25jWjMxcFQ0R0UzOSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770191007),
|
|
('9Q1iOu4YuNT0vchRxS0kuxlEZW7Ivrq1VLT6ixh2',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoib09hd0R4Z01ISDZDWW9MTjVpYVVTbkVJS0s0Q1hzZmV0aUtZWFFsMiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770113692),
|
|
('A7YXclU0IOaObQ1xXPHrRl8aA0WyEA0oL1HvAsUZ',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoidk9MRE10OFJPSlBTZ25Nd1BLZ0FkNk9HZThDWHNMbE9JeEVHd1NZNCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770114478),
|
|
('AaRUIJ17vMLYeI8AgnOX4H6A5PRvudSMVeuTkLGI',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoibW42YXRjM2xvNm55ZGxqcXJOVkdScmZLREpCOWQzT2p6V1JNUnVxdiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770114463),
|
|
('C00fqboz4hV9s3sLvzYNpvSZvjxw2TAP0OFGlCe3',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiOGlGbnI5WkdIMmpWbGJNSEVsQmdhSFpHRm84cnJuckZ1bTZvMURjUCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770113786),
|
|
('L7xxT9aDH2SuQJMw88yUCyRaJ7hppDexGau4EvFi',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiRkpUem92TzlMSEFHTVFaZ1dxTHBTdHMzRG5qcEw2VFBKN0lsUkJEbyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770113771),
|
|
('NqJKl7LIir1ROT7aZbVBNGYwBK49IPwuKf9hGarR',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiSTVsV0dxcVN1ZlJ0UHBvM0NiQ3owVkRoRXRFYm9QN211dkZzVml0QyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770115605),
|
|
('sYK9Clyt2DrvVDQR0K1T5plsy5qxMbB2w6xrMWag',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiMHBDN1NBWkhjc2FBWWR2enY0VjJkNjF6cjBtOHlMQnBibEttMXN5eSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770115642),
|
|
('TA5SahNPhPkkAxF06JD7demscYkBR1XNnIeH99D1',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiYTF4UU9BNkYwek5sRTl5UlVxODZIb0NsM0hReG5tWlFqYjJ1elhjcSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770113817),
|
|
('tcI07X8E0P8HDleNZ9Yia1TK3IuHau7kQWdvecBU',NULL,'127.0.0.1','','YToyOntzOjY6Il90b2tlbiI7czo0MDoiR2NqNGNuUkVpQmNJU2haTHB3anQ3S0l6Z1RKV3BuWUJ1MlFVZ1AyaCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1770114409),
|
|
('znIlURNYewCwth0hxOBeM53UzMY9EkjSYR7AFAFL',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:147.0) Gecko/20100101 Firefox/147.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiNlZRODc2cUVxTTRrbjFBdnVKTFJVT0tBQ1FDS1NvT0RXTzFOeTh1SCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vbm9kZWh1Yi5sb2MiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1770110732);
|
|
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `users` (
|
|
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`email` varchar(255) NOT NULL,
|
|
`email_verified_at` timestamp NULL DEFAULT NULL,
|
|
`password` varchar(255) NOT NULL,
|
|
`remember_token` varchar(100) DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `users_email_unique` (`email`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `users`
|
|
--
|
|
|
|
LOCK TABLES `users` WRITE;
|
|
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;
|
|
|
|
-- Dump completed on 2026-02-21 20:04:47
|