-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Servidor: localhost:3306 -- Tiempo de generación: 16-03-2026 a las 21:41:54 -- Versión del servidor: 8.0.45 -- Versión de PHP: 8.4.18 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Base de datos: `ofinita_db` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `activity_log` -- CREATE TABLE `activity_log` ( `id` bigint UNSIGNED NOT NULL, `log_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject_id` bigint UNSIGNED DEFAULT NULL, `causer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `causer_id` bigint UNSIGNED DEFAULT NULL, `properties` json DEFAULT NULL, `batch_uuid` char(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `activity_log` -- INSERT INTO `activity_log` (`id`, `log_name`, `description`, `subject_type`, `event`, `subject_id`, `causer_type`, `causer_id`, `properties`, `batch_uuid`, `created_at`, `updated_at`) VALUES (1, 'default', 'created', 'App\\Models\\User', 'created', 1, NULL, NULL, '{\"attributes\": {\"id\": 1, \"slug\": \"coke-colombres\", \"email\": \"coke@lacompaniadigital.com\", \"role_id\": 1, \"password\": \"$2y$10$PhbmQrmfbktHa.1sPnASOuhla4gIuE.3TOU5SCHGQ9n5TvvA64lq6\", \"two_step\": 0, \"api_token\": \"$2y$10$iKOorTZQbvX.qPrMoLyo5uthoEIjrbOzcICo19nsGJ5IERKYGj33e\", \"last_name\": \"Colombres\", \"created_at\": \"2025-05-21T17:37:23.000000Z\", \"first_name\": \"Coke\", \"updated_at\": \"2025-05-21T17:37:23.000000Z\", \"last_login_at\": null, \"last_login_ip\": null, \"remember_token\": null, \"email_verified_at\": \"2025-05-21T17:37:23.000000Z\"}}', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'default', 'created', 'App\\Models\\UserInfo', 'created', 1, NULL, NULL, '{\"attributes\": {\"id\": 1, \"file\": null, \"type\": null, \"phone\": \"909 71 6469\", \"avatar\": null, \"mobile\": \"+34 969 60 4596\", \"status\": null, \"address\": null, \"country\": null, \"details\": null, \"user_id\": 1, \"language\": null, \"linkedin\": null, \"avatar_url\": \"http://localhost/demo1/media/avatars/blank.png\", \"created_at\": \"2025-05-21T17:37:23.000000Z\", \"updated_at\": \"2025-05-21T17:37:23.000000Z\", \"member_since\": null, \"avatar_public_id\": null}}', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'default', 'created', 'App\\Models\\User', 'created', 2, NULL, NULL, '{\"attributes\": {\"id\": 2, \"slug\": \"admin-admin\", \"email\": \"admin@ofinita.com\", \"role_id\": 1, \"password\": \"$2y$10$QBukBgmaCfqBQLR9stMLsut/rr5hsRlNbbkXszPq8mzM4NZysvBdi\", \"two_step\": 0, \"api_token\": \"$2y$10$Uvzq0bx4sC5CBy15s.RfYumukl24Tz/gkAh4rz1a6tLIFJ..KOpci\", \"last_name\": \"Admin\", \"created_at\": \"2025-05-21T17:37:23.000000Z\", \"first_name\": \"Admin\", \"updated_at\": \"2025-05-21T17:37:23.000000Z\", \"last_login_at\": null, \"last_login_ip\": null, \"remember_token\": null, \"email_verified_at\": \"2025-05-21T17:37:23.000000Z\"}}', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 'default', 'created', 'App\\Models\\UserInfo', 'created', 2, NULL, NULL, '{\"attributes\": {\"id\": 2, \"file\": null, \"type\": null, \"phone\": \"904937959\", \"avatar\": null, \"mobile\": \"973 44 1246\", \"status\": null, \"address\": null, \"country\": null, \"details\": null, \"user_id\": 2, \"language\": null, \"linkedin\": null, \"avatar_url\": \"http://localhost/demo1/media/avatars/blank.png\", \"created_at\": \"2025-05-21T17:37:23.000000Z\", \"updated_at\": \"2025-05-21T17:37:23.000000Z\", \"member_since\": null, \"avatar_public_id\": null}}', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `albums` -- CREATE TABLE `albums` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `album_picture` -- CREATE TABLE `album_picture` ( `id` bigint UNSIGNED NOT NULL, `album_id` bigint UNSIGNED NOT NULL, `picture_id` bigint UNSIGNED NOT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `album_tag` -- CREATE TABLE `album_tag` ( `id` bigint UNSIGNED NOT NULL, `album_id` bigint UNSIGNED NOT NULL, `tag_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `carousels` -- CREATE TABLE `carousels` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `items` int NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `carousel_picture` -- CREATE TABLE `carousel_picture` ( `id` bigint UNSIGNED NOT NULL, `carousel_id` bigint UNSIGNED NOT NULL, `picture_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `categories` -- CREATE TABLE `categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `categories` -- INSERT INTO `categories` (`id`, `name`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Unique Ceramics', 'unique-ceramics', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Artistic Textiles', 'artistic-textiles', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Mixed Media Works', 'mixed-media-works', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `faqs` -- CREATE TABLE `faqs` ( `id` bigint UNSIGNED NOT NULL, `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `answer` text COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` bigint UNSIGNED NOT NULL, `order` int DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `faqs` -- INSERT INTO `faqs` (`id`, `question`, `answer`, `category_id`, `order`, `created_at`, `updated_at`) VALUES (1, '¿Cómo puedo encargar una pieza personalizada?', 'Para encargar una pieza personalizada, simplemente contacta con Delfina a través del correo electrónico o WhatsApp. Discute tus ideas y necesidades, y Delfina trabajará contigo para crear una obra única.', 1, 0, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, '¿Cuál es el tiempo estimado de envío internacional?', 'Los envíos internacionales suelen tardar entre 2 y 4 semanas, dependiendo del destino. Utilizamos embalaje seguro para asegurar que todas las piezas lleguen en perfecto estado.', 2, 0, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, '¿Cómo puedo suscribirme a los talleres o experiencias artísticas?', 'Puedes suscribirte a los talleres y experiencias artísticas suscribiéndote al newsletter de Ofinita o contactando directamente a Delfina para obtener información sobre fechas y disponibilidad.', 3, 0, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `faqs_categories` -- CREATE TABLE `faqs_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `faqs_categories` -- INSERT INTO `faqs_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (1, 'Pedidos', 'pedidos', 'Preguntas comunes sobre cómo realizar un pedido personalizado.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Envíos', 'envios', 'Información sobre envíos nacionales e internacionales.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Talleres y Experiencias', 'talleres-experiencias', 'Información sobre cómo participar en las experiencias artísticas de Ofinita.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `gallery` -- CREATE TABLE `gallery` ( `id` bigint UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `gallery` -- INSERT INTO `gallery` (`id`, `title`, `description`, `img`, `category_id`, `created_at`, `updated_at`) VALUES (1, 'Navigating Within', 'A solitary red canoe travels across a vast body of water, reflecting the inner journey.', 'cd-project/product-7/seeders/gallery/gallery-1.jpg', 3, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Golden Gaze', 'Portrait of an ostrich over a gradient yellow background, filled with curiosity and contrast.', 'cd-project/product-7/seeders/gallery/gallery-2.jpg', 4, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Contemplation in Silence', 'A group of figures seen from behind, immersed in quiet observation or reflection.', 'cd-project/product-7/seeders/gallery/gallery-3.jpg', 3, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 'Forest Light', 'Minimalist white tree trunks contrast a deep red and black background like a memory of winter woods.', 'cd-project/product-7/seeders/gallery/gallery-4.jpg', 2, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (5, 'Mycology Series', 'Scientific and artistic linocut representation of different mushroom species.', 'cd-project/product-7/seeders/gallery/gallery-5.jpg', 2, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (6, 'Zebra Split', 'Layered zebra portrait playing with composition and contrast in framing.', 'cd-project/product-7/seeders/gallery/gallery-6.jpg', 4, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (7, 'Ostriches in the Field', 'Three expressive ostrich faces placed in a natural, outdoor setting.', 'cd-project/product-7/seeders/gallery/gallery-7.jpg', 4, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (8, 'Yellow Texture', 'Abstract texture composition in yellow, printed on rough handmade paper.', 'cd-project/product-7/seeders/gallery/gallery-8.jpg', 3, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (9, 'The Hen', 'Expressive hen in black ink with a striking red comb, surrounded by green nature.', 'cd-project/product-7/seeders/gallery/gallery-9.jpg', 4, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (10, 'Wild Eye', 'Close-up view of a wild animal’s eye, capturing power and emotion in a raw setting.', 'cd-project/product-7/seeders/gallery/gallery-10.jpg', 2, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `gallery_categories` -- CREATE TABLE `gallery_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `gallery_categories` -- INSERT INTO `gallery_categories` (`id`, `name`, `description`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Otros', NULL, 'otros', '2025-05-21 12:37:21', '2025-05-21 12:37:21'), (2, 'Nature Engraving', 'Prints inspired by landscapes, animals, and the wilderness.', 'nature-engraving', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Symbolic Art', 'Artworks loaded with personal or cultural symbolism.', 'symbolic-art', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 'Humans and Animals', 'Works exploring the bond and reflection between human and animal worlds.', 'humans-and-animals', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `gallery_gallery_tag` -- CREATE TABLE `gallery_gallery_tag` ( `id` bigint UNSIGNED NOT NULL, `gallery_id` bigint UNSIGNED NOT NULL, `gallery_tag_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `gallery_gallery_tag` -- INSERT INTO `gallery_gallery_tag` (`id`, `gallery_id`, `gallery_tag_id`, `created_at`, `updated_at`) VALUES (1, 1, 1, NULL, NULL), (2, 1, 3, NULL, NULL), (3, 2, 1, NULL, NULL), (4, 2, 2, NULL, NULL), (5, 3, 1, NULL, NULL), (6, 3, 3, NULL, NULL), (7, 4, 2, NULL, NULL), (8, 5, 1, NULL, NULL), (9, 6, 1, NULL, NULL), (10, 6, 2, NULL, NULL), (11, 7, 1, NULL, NULL), (12, 7, 3, NULL, NULL), (13, 8, 1, NULL, NULL), (14, 9, 1, NULL, NULL), (15, 9, 2, NULL, NULL), (16, 10, 1, NULL, NULL), (17, 10, 2, NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `gallery_tags` -- CREATE TABLE `gallery_tags` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `gallery_tags` -- INSERT INTO `gallery_tags` (`id`, `name`, `description`, `slug`, `created_at`, `updated_at`) VALUES (1, 'Woodcut', 'Created using traditional relief printmaking techniques.', 'woodcut', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Framed', 'Presented in wooden or custom frames ready for exhibition.', 'framed', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Limited Edition', 'Part of a numbered, exclusive print series.', 'limited-edition', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2021_03_22_144618_create_permission_tables', 1), (5, '2021_04_14_044507_create_settings_table', 1), (6, '2021_06_15_022916_create_user_infos_table', 1), (7, '2021_06_23_041411_create_activity_log_table', 1), (8, '2021_06_23_041412_add_event_column_to_activity_log_table', 1), (9, '2021_06_23_041413_add_batch_uuid_column_to_activity_log_table', 1), (10, '2021_11_04_200820_add_api_token_column', 1), (11, '2022_10_28_011905_create_post_categories_table', 1), (12, '2022_10_28_013743_create_posts_table', 1), (13, '2022_11_27_174317_add_columns_user_infos_table', 1), (14, '2022_11_27_213151_add_role_column_to_users_table', 1), (15, '2022_11_28_183514_add_header_column_to_posts_table', 1), (16, '2022_11_28_230301_add_2steps_boolean_column_to_users_table', 1), (17, '2022_11_29_001654_add_description_column_to_roles_table', 1), (18, '2022_11_29_010232_add_login_fields_to_users_table', 1), (19, '2022_11_30_012122_add_slug_column_to_users_table', 1), (20, '2022_11_30_015822_remove_infos_column_in_user_infos_table', 1), (21, '2022_12_01_145953_create_albums_table', 1), (22, '2022_12_01_150118_create_pictures_table', 1), (23, '2022_12_01_150217_create_tags_table', 1), (24, '2022_12_01_153440_create_album_tag_table', 1), (25, '2022_12_01_153536_create_picture_tag_table', 1), (26, '2022_12_03_110421_create_album_picture_table', 1), (27, '2022_12_14_125955_add_featured_column_to_pictures_table', 1), (28, '2023_01_03_132602_create_carousels_table', 1), (29, '2023_01_03_133219_create_carousel_picture_table', 1), (30, '2023_01_30_214920_create_categories_table', 1), (31, '2023_01_30_215103_create_products_table', 1), (32, '2023_01_30_231208_create_projects_table', 1), (33, '2023_03_08_192259_add_slug_column_to_roles_table', 1), (34, '2023_03_08_203351_modify_columns_on_user_infos_table', 1), (35, '2023_03_14_013201_modify_columns_in_user_infos_table', 1), (36, '2023_03_14_013447_modify_column_content_in_posts_table', 1), (37, '2023_03_14_015848_add_column_in_user_infos_table', 1), (38, '2023_03_14_020506_drop_columns_city_and_zipcode_in_user_infos_table', 1), (39, '2023_03_14_125135_drop_social_columns_on_user_infos_table', 1), (40, '2023_03_19_200738_rename_column_born_date_on_user_infos_table', 1), (41, '2024_09_28_112149_add_category_id_to_products_table', 1), (42, '2024_10_16_094040_create_project_categories_table', 1), (43, '2024_10_16_094131_create_project_category_project_table', 1), (44, '2024_10_16_094821_add_image_path_and_is_active_to_projects_table', 1), (45, '2024_10_16_111812_rename_image_path_to_image_in_projects_table', 1), (46, '2024_10_29_123145_remove_description_from_categories_table', 1), (47, '2024_10_29_141636_create_product_tags_table', 1), (48, '2024_10_29_141914_create_product_product_tag_table', 1), (49, '2024_10_29_172710_create_product_images_table', 1), (50, '2024_10_29_175900_remove_image_path_from_products_table', 1), (51, '2024_11_05_161233_create_welcome_carousels_table', 1), (52, '2024_11_07_131830_add_cloudinary_fields_to_user_infos_table', 1), (53, '2024_11_07_153540_add_country_to_user_infos_table', 1), (54, '2024_12_30_150554_create_gallery_table', 1), (55, '2024_12_30_150637_create_gallery_categories_table', 1), (56, '2024_12_30_150709_add_category_id_to_gallery_table', 1), (57, '2024_12_30_150802_add_category_id_index_to_gallery_table', 1), (58, '2025_01_14_125955_create_faqs_categories_table', 1), (59, '2025_01_14_142859_create_faqs_table', 1), (60, '2025_01_14_142959_modify_order_in_faqs_table', 1), (61, '2025_01_15_100659_create_news_categories_table', 1), (62, '2025_01_15_100734_create_news_table', 1), (63, '2025_01_15_100754_update_slug_default_in_news_table', 1), (64, '2025_01_23_124707_create_gallery_tags_table', 1), (65, '2025_01_23_124818_create_gallery_gallery_tag_table', 1), (66, '2025_02_10_082609_create_reference_categories_table', 1), (67, '2025_02_10_082939_create_references_table', 1), (68, '2025_02_10_082950_update_references_table', 1), (69, '2025_02_10_125803_create_services_table', 1), (70, '2025_02_11_124507_create_team_members_and_categories_tables', 1), (71, '2025_02_11_125015_update_team_members_table_with_extra_fields', 1), (72, '2025_03_05_125737_add_slug_and_description_to_project_categories_table', 1), (73, '2025_03_07_111602_add_public_id_to_posts_table', 1), (74, '2025_03_07_111646_drop_category_id_from_news_table', 1), (75, '2025_03_07_111716_drop_news_categories_table', 1), (76, '2025_03_10_160158_create_projects_table', 1), (77, '2025_03_19_224401_add_slug_and_description_to_faqs_categories_table', 1), (78, '2025_04_01_103909_add_description_to_product_tags_table', 1), (79, '2025_04_01_125717_add_url_and_description_to_project__table', 1), (80, '2025_04_14_165729_create_newsletter_subscribers_table', 1), (81, '2025_05_13_180427_add_slug_to_products_table', 1); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `model_has_permissions` -- CREATE TABLE `model_has_permissions` ( `permission_id` bigint UNSIGNED NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `model_has_roles` -- CREATE TABLE `model_has_roles` ( `role_id` bigint UNSIGNED NOT NULL, `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `model_id` bigint UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `model_has_roles` -- INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1, 'App\\Models\\User', 1), (1, 'App\\Models\\User', 2); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `news` -- CREATE TABLE `news` ( `id` bigint UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default-slug', `user_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `newsletter_subscribers` -- CREATE TABLE `newsletter_subscribers` ( `id` bigint UNSIGNED NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `newsletter_subscribers` -- INSERT INTO `newsletter_subscribers` (`id`, `email`, `created_at`, `updated_at`) VALUES (1, 'vanessawilliams756516@yahoo.com', '2025-05-21 14:30:10', '2025-05-21 14:30:10'), (2, 'andrboni55@gmail.com', '2025-05-22 14:10:20', '2025-05-22 14:10:20'), (3, 'hatfregane4@gmail.com', '2025-05-23 01:41:06', '2025-05-23 01:41:06'), (4, 'djoipark53@gmail.com', '2025-05-23 12:27:16', '2025-05-23 12:27:16'), (5, 'dsparksm1997@gmail.com', '2025-05-23 17:00:27', '2025-05-23 17:00:27'), (6, 'ndvggose@formtest.guru', '2025-05-24 04:12:51', '2025-05-24 04:12:51'), (7, 'dgbrrevx@formtest.guru', '2025-05-24 04:12:51', '2025-05-24 04:12:51'), (8, 'zjqvyxvo@formtest.guru', '2025-05-24 04:12:51', '2025-05-24 04:12:51'), (9, 'idsimocy43@gmail.com', '2025-05-24 04:38:03', '2025-05-24 04:38:03'), (10, 'bretancastilloj@gmail.com', '2025-05-24 21:56:27', '2025-05-24 21:56:27'), (11, 'djonilucasuw18@gmail.com', '2025-05-25 01:26:47', '2025-05-25 01:26:47'), (12, 'velmabnd1986@gmail.com', '2025-05-25 03:38:47', '2025-05-25 03:38:47'), (13, 'kingsleih17@gmail.com', '2025-05-25 14:07:30', '2025-05-25 14:07:30'), (14, 'decstefb@gmail.com', '2025-05-26 11:32:34', '2025-05-26 11:32:34'), (15, 'hbraianyw47@gmail.com', '2025-05-26 12:04:42', '2025-05-26 12:04:42'), (16, 'murraygrirdk@gmail.com', '2025-05-26 22:45:04', '2025-05-26 22:45:04'), (17, 'merivetersimsqe@gmail.com', '2025-05-27 22:16:59', '2025-05-27 22:16:59'), (18, 'brooksjessica612478@yahoo.com', '2025-05-28 03:38:13', '2025-05-28 03:38:13'), (19, 'kingharlandmi6@gmail.com', '2025-05-28 10:11:11', '2025-05-28 10:11:11'), (20, 'ildredcarpenter2006@gmail.com', '2025-05-28 21:10:30', '2025-05-28 21:10:30'), (21, 'womxhrrs@testform.xyz', '2025-05-29 07:44:23', '2025-05-29 07:44:23'), (22, 'zgvzenoo@testform.xyz', '2025-05-29 07:44:23', '2025-05-29 07:44:23'), (23, 'mihedkuh@testform.xyz', '2025-05-29 07:44:23', '2025-05-29 07:44:23'), (24, 'tlpytehr@testform.xyz', '2025-05-29 07:44:24', '2025-05-29 07:44:24'), (25, 'cunninghamkaren957112@yahoo.com', '2025-05-29 10:46:25', '2025-05-29 10:46:25'), (26, 'jesseheiman1996@yahoo.com', '2025-05-30 07:52:56', '2025-05-30 07:52:56'), (27, 'dahliyam1996@gmail.com', '2025-05-30 19:57:40', '2025-05-30 19:57:40'), (28, 'tirnanfs@gmail.com', '2025-05-30 20:04:17', '2025-05-30 20:04:17'), (29, 'mclovencarl1995@yahoo.com', '2025-05-31 00:19:31', '2025-05-31 00:19:31'), (30, 'fpkxehuo@testform.xyz', '2025-05-31 02:42:56', '2025-05-31 02:42:56'), (31, 'yzupqpzi@testform.xyz', '2025-05-31 02:42:56', '2025-05-31 02:42:56'), (32, 'rdltgmuj@testform.xyz', '2025-05-31 02:42:56', '2025-05-31 02:42:56'), (33, 'wjsqydgd@testform.xyz', '2025-05-31 02:42:56', '2025-05-31 02:42:56'), (34, 'mariarivera200022@yahoo.com', '2025-05-31 09:00:13', '2025-05-31 09:00:13'), (35, 'kandiswf63@gmail.com', '2025-05-31 11:49:58', '2025-05-31 11:49:58'), (36, 'parkersherlokm45@gmail.com', '2025-05-31 23:13:43', '2025-05-31 23:13:43'), (37, 'madisonoyn5@gmail.com', '2025-06-03 21:10:27', '2025-06-03 21:10:27'), (38, 'keldjoa30@gmail.com', '2025-06-05 05:31:51', '2025-06-05 05:31:51'), (39, 'lykindabutler36@gmail.com', '2025-06-05 22:13:32', '2025-06-05 22:13:32'), (40, 'nortonadnei1986@gmail.com', '2025-06-05 22:41:12', '2025-06-05 22:41:12'), (41, 'fterloe80@gmail.com', '2025-06-06 00:57:00', '2025-06-06 00:57:00'), (42, 'garciabrennanpg2006@gmail.com', '2025-06-06 22:14:28', '2025-06-06 22:14:28'), (43, 'eidenlqj1990@gmail.com', '2025-06-06 23:07:51', '2025-06-06 23:07:51'), (44, 'ashleymelg8@gmail.com', '2025-06-07 03:25:24', '2025-06-07 03:25:24'), (45, 'bcallahanie12@gmail.com', '2025-06-07 12:59:01', '2025-06-07 12:59:01'), (46, 'orjsprfp@testform.xyz', '2025-06-07 13:06:01', '2025-06-07 13:06:01'), (47, 'zfkqjqko@testform.xyz', '2025-06-07 13:06:01', '2025-06-07 13:06:01'), (48, 'qmzyssru@testform.xyz', '2025-06-07 13:06:01', '2025-06-07 13:06:01'), (49, 'ntuxspvj@testform.xyz', '2025-06-07 13:06:01', '2025-06-07 13:06:01'), (50, 'clarknancy829737@yahoo.com', '2025-06-08 18:44:38', '2025-06-08 18:44:38'), (51, 'rshannonbq1989@gmail.com', '2025-06-08 21:54:46', '2025-06-08 21:54:46'), (52, 'agataamw88@gmail.com', '2025-06-09 01:54:16', '2025-06-09 01:54:16'), (53, 'nicolethomas150377@yahoo.com', '2025-06-09 02:26:18', '2025-06-09 02:26:18'), (54, 'reimondhebert36@gmail.com', '2025-06-09 15:17:04', '2025-06-09 15:17:04'), (55, 'emilysmith649386@yahoo.com', '2025-06-09 22:26:56', '2025-06-09 22:26:56'), (56, 'derrikry@gmail.com', '2025-06-10 05:00:58', '2025-06-10 05:00:58'), (57, 'martinclaudia836747@yahoo.com', '2025-06-10 08:58:44', '2025-06-10 08:58:44'), (58, 'zrmtdmkf@testform.xyz', '2025-06-11 09:41:43', '2025-06-11 09:41:43'), (59, 'iqpqnkzz@testform.xyz', '2025-06-11 09:41:43', '2025-06-11 09:41:43'), (60, 'udfrytkq@testform.xyz', '2025-06-11 09:41:43', '2025-06-11 09:41:43'), (61, 'gjrmmhum@testform.xyz', '2025-06-11 09:41:43', '2025-06-11 09:41:43'), (62, 'barnabasw1992@gmail.com', '2025-06-11 10:26:21', '2025-06-11 10:26:21'), (63, 'tvilayorkle1986@gmail.com', '2025-06-11 15:18:35', '2025-06-11 15:18:35'), (64, 'rioklein44@gmail.com', '2025-06-12 03:50:15', '2025-06-12 03:50:15'), (65, 'stephenscherisx2@gmail.com', '2025-06-12 10:40:43', '2025-06-12 10:40:43'), (66, 'rmarshallc33@gmail.com', '2025-06-12 13:16:51', '2025-06-12 13:16:51'), (67, 'msaloymx81@gmail.com', '2025-06-12 14:40:08', '2025-06-12 14:40:08'), (68, 'merllynna39@gmail.com', '2025-06-12 23:43:04', '2025-06-12 23:43:04'), (69, 'robertdavidson589722@yahoo.com', '2025-06-13 06:13:59', '2025-06-13 06:13:59'), (70, 'doughertyleofvainar1988@gmail.com', '2025-06-13 21:34:05', '2025-06-13 21:34:05'), (71, 'ryanhayes86579@yahoo.com', '2025-06-14 03:06:16', '2025-06-14 03:06:16'), (72, 'blerballu1986@gmail.com', '2025-06-14 03:22:10', '2025-06-14 03:22:10'), (73, 'eboyerd3@gmail.com', '2025-06-15 08:54:57', '2025-06-15 08:54:57'), (74, 'hmerdiy96@gmail.com', '2025-06-16 07:13:25', '2025-06-16 07:13:25'), (75, 'sheksavq31@gmail.com', '2025-06-16 16:04:51', '2025-06-16 16:04:51'), (76, 'harrisbradlei@gmail.com', '2025-06-16 23:59:09', '2025-06-16 23:59:09'), (77, 'freizerbg41@gmail.com', '2025-06-17 00:10:46', '2025-06-17 00:10:46'), (78, 'rheiyadouglas1996@gmail.com', '2025-06-17 08:41:12', '2025-06-17 08:41:12'), (79, 'mcmahonmichelmq1@gmail.com', '2025-06-18 17:49:01', '2025-06-18 17:49:01'), (80, 'mccluremerrittlt1@gmail.com', '2025-06-18 18:50:27', '2025-06-18 18:50:27'), (81, 'navarrplisxl@gmail.com', '2025-06-19 01:37:51', '2025-06-19 01:37:51'), (82, 'ricblubqs28@gmail.com', '2025-06-19 16:41:36', '2025-06-19 16:41:36'), (83, 'samphemfria89@gmail.com', '2025-06-20 04:56:32', '2025-06-20 04:56:32'), (84, 'meiorprince47@gmail.com', '2025-06-21 01:30:54', '2025-06-21 01:30:54'), (85, 'dklevz30@gmail.com', '2025-06-22 01:35:17', '2025-06-22 01:35:17'), (86, 'shannensx98@gmail.com', '2025-06-22 09:24:16', '2025-06-22 09:24:16'), (87, 'ervanhooverq@gmail.com', '2025-06-22 10:51:07', '2025-06-22 10:51:07'), (88, 'zunifortyn29@gmail.com', '2025-06-23 22:48:32', '2025-06-23 22:48:32'), (89, 'subtisimet1975@yahoo.com', '2025-06-25 02:03:36', '2025-06-25 02:03:36'), (90, 'betsgoodqv@gmail.com', '2025-06-25 18:08:40', '2025-06-25 18:08:40'), (91, 'itiwazaqeha37@gmail.com', '2025-06-26 11:30:48', '2025-06-26 11:30:48'), (92, 'kebitivahul106@gmail.com', '2025-06-26 13:36:42', '2025-06-26 13:36:42'), (93, 'liyaguyi52@gmail.com', '2025-06-27 13:31:06', '2025-06-27 13:31:06'), (94, 'orizematil38@gmail.com', '2025-06-28 04:54:14', '2025-06-28 04:54:14'), (95, 'djaneiwatson@gmail.com', '2025-06-28 20:31:49', '2025-06-28 20:31:49'), (96, 'gardnermilli4@gmail.com', '2025-06-29 18:14:12', '2025-06-29 18:14:12'), (97, 'nealmiloserdaya21@gmail.com', '2025-06-30 03:19:34', '2025-06-30 03:19:34'), (98, 'dfisherhx1983@gmail.com', '2025-06-30 17:53:13', '2025-06-30 17:53:13'), (99, 'blackwellaboton@gmail.com', '2025-06-30 22:49:14', '2025-06-30 22:49:14'), (100, 'clark_angel1558@yahoo.com', '2025-07-01 04:29:37', '2025-07-01 04:29:37'), (101, 'balloweangel2002@yahoo.com', '2025-07-01 06:01:53', '2025-07-01 06:01:53'), (102, 'francisgvenet8@gmail.com', '2025-07-01 06:17:17', '2025-07-01 06:17:17'), (103, 'helviesean623408@yahoo.com', '2025-07-01 10:19:34', '2025-07-01 10:19:34'), (104, 'mcconnellelanorjg53@gmail.com', '2025-07-01 14:22:19', '2025-07-01 14:22:19'), (105, 'ffloresvs1980@gmail.com', '2025-07-02 16:57:55', '2025-07-02 16:57:55'), (106, 'curbyportillo127019@yahoo.com', '2025-07-03 01:26:06', '2025-07-03 01:26:06'), (107, 'roddicn9@gmail.com', '2025-07-03 10:25:49', '2025-07-03 10:25:49'), (108, 'ecimahelivas50@gmail.com', '2025-07-04 06:21:22', '2025-07-04 06:21:22'), (109, 'symonemckenzie343960@yahoo.com', '2025-07-04 07:38:27', '2025-07-04 07:38:27'), (110, 'titalexuzo456@gmail.com', '2025-07-04 15:02:51', '2025-07-04 15:02:51'), (111, 'qatafalimeh297@gmail.com', '2025-07-04 16:35:22', '2025-07-04 16:35:22'), (112, 'ceciliagomez677785@yahoo.com', '2025-07-04 23:38:10', '2025-07-04 23:38:10'), (113, 'wigubojado32@gmail.com', '2025-07-05 18:47:05', '2025-07-05 18:47:05'), (114, 'kodofovupaz38@gmail.com', '2025-07-05 20:01:08', '2025-07-05 20:01:08'), (115, 'gloyan1984@gmail.com', '2025-07-06 11:34:34', '2025-07-06 11:34:34'), (116, 'frederickmelvillk20@gmail.com', '2025-07-06 21:54:38', '2025-07-06 21:54:38'), (117, 'anettaasd38@gmail.com', '2025-07-07 11:05:37', '2025-07-07 11:05:37'), (118, 'esloandp1990@gmail.com', '2025-07-07 15:19:44', '2025-07-07 15:19:44'), (119, 'mpeimliyaup27@gmail.com', '2025-07-07 16:57:45', '2025-07-07 16:57:45'), (120, 'horton_claudia4778@yahoo.com', '2025-07-07 19:00:00', '2025-07-07 19:00:00'), (121, 'erica_gibson1991@yahoo.com', '2025-07-07 19:32:20', '2025-07-07 19:32:20'), (122, 'djeniskz88@gmail.com', '2025-07-08 01:13:07', '2025-07-08 01:13:07'), (123, 'smith_kayla1980@yahoo.com', '2025-07-08 04:41:47', '2025-07-08 04:41:47'), (124, 'curtisgarold1985@gmail.com', '2025-07-08 17:56:02', '2025-07-08 17:56:02'), (125, 'qazenucixos204@gmail.com', '2025-07-09 00:33:37', '2025-07-09 00:33:37'), (126, 'gui.whit9637@yahoo.com', '2025-07-09 02:17:08', '2025-07-09 02:17:08'), (127, 'adelfiyad6@gmail.com', '2025-07-09 07:10:35', '2025-07-09 07:10:35'), (128, 'fritzbraianup53@gmail.com', '2025-07-09 11:10:58', '2025-07-09 11:10:58'), (129, 'gmurilloug3@gmail.com', '2025-07-10 03:36:22', '2025-07-10 03:36:22'), (130, 'bafehec505@gmail.com', '2025-07-10 05:51:14', '2025-07-10 05:51:14'), (131, 'seminabopi738@gmail.com', '2025-07-10 09:33:43', '2025-07-10 09:33:43'), (132, 'dujedumi679@gmail.com', '2025-07-10 16:46:34', '2025-07-10 16:46:34'), (133, 'angie_isaacson8641@yahoo.com', '2025-07-11 11:31:31', '2025-07-11 11:31:31'), (134, 'jilojabapob137@gmail.com', '2025-07-11 12:32:52', '2025-07-11 12:32:52'), (135, 'xelunazudiv861@gmail.com', '2025-07-11 20:48:14', '2025-07-11 20:48:14'), (136, 'moondalindan5@gmail.com', '2025-07-12 07:10:50', '2025-07-12 07:10:50'), (137, 'stanlebrandgi@gmail.com', '2025-07-12 10:19:57', '2025-07-12 10:19:57'), (138, 'mertonavilaz27@gmail.com', '2025-07-12 17:22:28', '2025-07-12 17:22:28'), (139, 'mercadoeinsli1981@gmail.com', '2025-07-13 06:13:28', '2025-07-13 06:13:28'), (140, 'dukealfawt1996@gmail.com', '2025-07-13 15:54:23', '2025-07-13 15:54:23'), (141, 'grahammirtim@gmail.com', '2025-07-13 19:48:27', '2025-07-13 19:48:27'), (142, 'fonzhaasyz@gmail.com', '2025-07-14 21:52:52', '2025-07-14 21:52:52'), (143, 'hannadadk49@gmail.com', '2025-07-15 17:12:01', '2025-07-15 17:12:01'), (144, 'upesagaqi19@gmail.com', '2025-07-15 21:40:12', '2025-07-15 21:40:12'), (145, 'ifijefigenay50@gmail.com', '2025-07-16 01:26:12', '2025-07-16 01:26:12'), (146, 'markibdu2004@gmail.com', '2025-07-17 05:27:01', '2025-07-17 05:27:01'), (147, 'oberhauserderrick83666@yahoo.com', '2025-07-17 08:42:39', '2025-07-17 08:42:39'), (148, 'krzywickipolo842408@yahoo.com', '2025-07-17 12:48:17', '2025-07-17 12:48:17'), (149, 'djaklaingilly@gmail.com', '2025-07-17 15:06:32', '2025-07-17 15:06:32'), (150, 'royselena620247@yahoo.com', '2025-07-18 06:55:23', '2025-07-18 06:55:23'), (151, 'fkorrain@gmail.com', '2025-07-18 10:47:51', '2025-07-18 10:47:51'), (152, 'vibertmzf@gmail.com', '2025-07-18 20:07:42', '2025-07-18 20:07:42'), (153, 'skilercurtis2000@gmail.com', '2025-07-19 02:31:03', '2025-07-19 02:31:03'), (154, 'rbenjaminl1984@gmail.com', '2025-07-19 07:17:34', '2025-07-19 07:17:34'), (155, 'dumuqiwo823@gmail.com', '2025-07-19 10:43:52', '2025-07-19 10:43:52'), (156, 'zajebocasax154@gmail.com', '2025-07-20 04:00:22', '2025-07-20 04:00:22'), (157, 'michaellykil83@gmail.com', '2025-07-20 12:26:27', '2025-07-20 12:26:27'), (158, 'harleclarkby21@gmail.com', '2025-07-20 18:47:19', '2025-07-20 18:47:19'), (159, 'alisonfrey903047@yahoo.com', '2025-07-21 19:48:05', '2025-07-21 19:48:05'), (160, 'kingbassettyq42@gmail.com', '2025-07-22 01:00:31', '2025-07-22 01:00:31'), (161, 'nimuveloliqi99@gmail.com', '2025-07-22 01:01:44', '2025-07-22 01:01:44'), (162, 'mikecaldwell1995@yahoo.com', '2025-07-24 14:53:57', '2025-07-24 14:53:57'), (163, 'vaugabei@gmail.com', '2025-07-25 00:51:10', '2025-07-25 00:51:10'), (164, 'giguwehubeca24@gmail.com', '2025-07-25 03:57:28', '2025-07-25 03:57:28'), (165, 'lisaraymongc@gmail.com', '2025-07-25 06:22:29', '2025-07-25 06:22:29'), (166, 'tomsholeh1987@yahoo.com', '2025-07-25 11:21:16', '2025-07-25 11:21:16'), (167, 'nejakuvoc366@gmail.com', '2025-07-25 13:00:27', '2025-07-25 13:00:27'), (168, 'ulafuxizu034@gmail.com', '2025-07-26 10:10:58', '2025-07-26 10:10:58'), (169, 'ormehayde39@gmail.com', '2025-07-26 10:26:50', '2025-07-26 10:26:50'), (170, 'ixidebuveba23@gmail.com', '2025-07-26 15:25:09', '2025-07-26 15:25:09'), (171, 'idumunoyogah40@gmail.com', '2025-07-26 18:26:20', '2025-07-26 18:26:20'), (172, 'sepufemim48@gmail.com', '2025-07-26 21:18:22', '2025-07-26 21:18:22'), (173, 'djitarice@gmail.com', '2025-07-27 02:54:16', '2025-07-27 02:54:16'), (174, 'engbergrodger918632@yahoo.com', '2025-07-27 03:25:21', '2025-07-27 03:25:21'), (175, 'charmiankb31@gmail.com', '2025-07-27 19:49:44', '2025-07-27 19:49:44'), (176, 'hsofiw26@gmail.com', '2025-07-28 03:34:59', '2025-07-28 03:34:59'), (177, 'spiritlegu@gmail.com', '2025-07-28 03:52:50', '2025-07-28 03:52:50'), (178, 'lawsondariyag@gmail.com', '2025-07-28 23:43:29', '2025-07-28 23:43:29'), (179, 'elsbetriley@gmail.com', '2025-07-29 04:13:55', '2025-07-29 04:13:55'), (180, 'statenrussell628502@yahoo.com', '2025-07-30 19:51:49', '2025-07-30 19:51:49'), (181, 'jenningsheilis@gmail.com', '2025-07-30 21:14:12', '2025-07-30 21:14:12'), (182, 'brandihunter660838@yahoo.com', '2025-07-30 22:19:15', '2025-07-30 22:19:15'), (183, 'eyevariqe63@gmail.com', '2025-07-30 23:13:27', '2025-07-30 23:13:27'), (184, 'ecimivazojac29@gmail.com', '2025-07-31 04:50:26', '2025-07-31 04:50:26'), (185, 'dojohidaxa98@gmail.com', '2025-07-31 11:15:42', '2025-07-31 11:15:42'), (186, 'xabixupi83@gmail.com', '2025-07-31 13:05:45', '2025-07-31 13:05:45'), (187, 'wihuropohi51@gmail.com', '2025-07-31 13:40:24', '2025-07-31 13:40:24'), (188, 'vukotazenawa36@gmail.com', '2025-07-31 15:39:47', '2025-07-31 15:39:47'), (189, 'iniyomafo13@gmail.com', '2025-08-01 05:04:02', '2025-08-01 05:04:02'), (190, 'dizuhimap25@gmail.com', '2025-08-01 23:45:12', '2025-08-01 23:45:12'), (191, 'richarteks3@gmail.com', '2025-08-03 01:37:36', '2025-08-03 01:37:36'), (192, 'lizslater2707@yahoo.com', '2025-08-03 02:19:04', '2025-08-03 02:19:04'), (193, 'enifujubuh521@gmail.com', '2025-08-03 02:27:09', '2025-08-03 02:27:09'), (194, 'kasoliho927@gmail.com', '2025-08-04 12:30:25', '2025-08-04 12:30:25'), (195, 'jasminemiller295575@yahoo.com', '2025-08-04 20:53:00', '2025-08-04 20:53:00'), (196, 'ocayiyiyu642@gmail.com', '2025-08-05 06:57:22', '2025-08-05 06:57:22'), (197, 'breezyjames278745@yahoo.com', '2025-08-05 12:07:51', '2025-08-05 12:07:51'), (198, 'oruqixefa568@gmail.com', '2025-08-05 18:05:05', '2025-08-05 18:05:05'), (199, 'rojassheraya1995@gmail.com', '2025-08-07 10:41:52', '2025-08-07 10:41:52'), (200, 'powupibefed99@gmail.com', '2025-08-07 22:38:13', '2025-08-07 22:38:13'), (201, 'mohimal296@gmail.com', '2025-08-09 22:20:11', '2025-08-09 22:20:11'), (202, 'zevicoxudiw867@gmail.com', '2025-08-10 01:51:08', '2025-08-10 01:51:08'), (203, 'igikodawozi417@gmail.com', '2025-08-12 00:41:33', '2025-08-12 00:41:33'), (204, 'yibuvasug433@gmail.com', '2025-08-12 00:49:15', '2025-08-12 00:49:15'), (205, 'omowihawo416@gmail.com', '2025-08-12 04:44:38', '2025-08-12 04:44:38'), (206, 'ujekedob12@gmail.com', '2025-08-13 00:37:38', '2025-08-13 00:37:38'), (207, 'iradebixedon30@gmail.com', '2025-08-14 17:36:57', '2025-08-14 17:36:57'), (208, 'jevineyozas496@gmail.com', '2025-08-15 09:45:37', '2025-08-15 09:45:37'), (209, 'nopohufuxej416@gmail.com', '2025-08-16 01:25:18', '2025-08-16 01:25:18'), (210, 'eqigegi076@gmail.com', '2025-08-16 02:05:39', '2025-08-16 02:05:39'), (211, 'tiffanywoods879899@yahoo.com', '2025-08-16 04:46:29', '2025-08-16 04:46:29'), (212, 'heranot581@gmail.com', '2025-08-16 18:17:59', '2025-08-16 18:17:59'), (213, 'wocorop498@gmail.com', '2025-08-16 20:49:22', '2025-08-16 20:49:22'), (214, 'litecuvav045@gmail.com', '2025-08-17 05:11:16', '2025-08-17 05:11:16'), (215, 'azefisasowo953@gmail.com', '2025-08-17 12:51:42', '2025-08-17 12:51:42'), (216, 'efuhedoja636@gmail.com', '2025-08-17 17:13:10', '2025-08-17 17:13:10'), (217, 'barrettbrian248464@yahoo.com', '2025-08-17 21:39:09', '2025-08-17 21:39:09'), (218, 'qivadaja036@gmail.com', '2025-08-18 01:32:51', '2025-08-18 01:32:51'), (219, 'fitzpatrickscott945845@yahoo.com', '2025-08-19 12:13:44', '2025-08-19 12:13:44'), (220, 'baqoman731@gmail.com', '2025-08-20 03:21:28', '2025-08-20 03:21:28'), (221, 'jeffreyallman42441@yahoo.com', '2025-08-20 18:50:11', '2025-08-20 18:50:11'), (222, 'roqigebe51@gmail.com', '2025-08-20 22:36:34', '2025-08-20 22:36:34'), (223, 'omadevit75@gmail.com', '2025-08-21 15:24:45', '2025-08-21 15:24:45'), (224, 'yfitzgeraldez@gmail.com', '2025-08-21 23:55:55', '2025-08-21 23:55:55'), (225, 'qijudonabo94@gmail.com', '2025-08-22 05:50:42', '2025-08-22 05:50:42'), (226, 'ihigakuhe54@gmail.com', '2025-08-22 15:06:55', '2025-08-22 15:06:55'), (227, 'rakobirijo536@gmail.com', '2025-08-23 05:58:51', '2025-08-23 05:58:51'), (228, 'ujenoyajumu00@gmail.com', '2025-08-24 09:05:40', '2025-08-24 09:05:40'), (229, 'degikuheli988@gmail.com', '2025-08-25 23:44:01', '2025-08-25 23:44:01'), (230, 'beqehame914@gmail.com', '2025-08-26 04:22:34', '2025-08-26 04:22:34'), (231, 'kaxiqoli51@gmail.com', '2025-08-26 14:53:40', '2025-08-26 14:53:40'), (232, 'ujelevije79@gmail.com', '2025-08-28 00:16:19', '2025-08-28 00:16:19'), (233, 'dulefeyakut33@gmail.com', '2025-08-28 04:11:52', '2025-08-28 04:11:52'), (234, 'edurosusi489@gmail.com', '2025-08-28 19:57:23', '2025-08-28 19:57:23'), (235, 'okeqpwjaiplkhnmm@yahoo.com', '2025-08-28 22:10:03', '2025-08-28 22:10:03'), (236, 'urutifeyaq74@gmail.com', '2025-08-29 09:02:49', '2025-08-29 09:02:49'), (237, 'clnbroina@yahoo.com', '2025-08-29 12:48:45', '2025-08-29 12:48:45'), (238, 'kozemeyiq752@gmail.com', '2025-08-30 03:38:03', '2025-08-30 03:38:03'), (239, 'ufaqebubiwe908@gmail.com', '2025-08-30 09:38:57', '2025-08-30 09:38:57'), (240, 'omisisifuj990@gmail.com', '2025-08-30 15:09:22', '2025-08-30 15:09:22'), (241, 'momaropado867@gmail.com', '2025-08-30 16:28:36', '2025-08-30 16:28:36'), (242, 'cekamevoriv957@gmail.com', '2025-08-31 17:24:01', '2025-08-31 17:24:01'), (243, 'oloretew41@gmail.com', '2025-08-31 22:38:16', '2025-08-31 22:38:16'), (244, 'ijopakaqovo27@gmail.com', '2025-09-01 02:05:09', '2025-09-01 02:05:09'), (245, 'teyoripi803@gmail.com', '2025-09-01 02:37:31', '2025-09-01 02:37:31'), (246, 'udevoyod000@gmail.com', '2025-09-03 02:07:32', '2025-09-03 02:07:32'), (247, 'afomufivik35@gmail.com', '2025-09-04 01:43:48', '2025-09-04 01:43:48'), (248, 'ayojogab151@gmail.com', '2025-09-05 00:44:00', '2025-09-05 00:44:00'), (249, 'koslowskywxxusmaudslay@yahoo.com', '2025-09-06 16:29:41', '2025-09-06 16:29:41'), (250, 'miwahawuqib25@gmail.com', '2025-09-07 18:40:10', '2025-09-07 18:40:10'), (251, 'nubujucolev077@gmail.com', '2025-09-08 13:27:02', '2025-09-08 13:27:02'), (252, 'isolugirum27@gmail.com', '2025-09-08 18:53:06', '2025-09-08 18:53:06'), (253, 'bonatoreg91@gmail.com', '2025-09-09 10:07:03', '2025-09-09 10:07:03'), (254, 'ihumuzucar85@gmail.com', '2025-09-10 23:50:16', '2025-09-10 23:50:16'), (255, 'ohakaxobi498@gmail.com', '2025-09-11 02:13:50', '2025-09-11 02:13:50'), (256, 'alulunaneme33@gmail.com', '2025-09-11 23:19:39', '2025-09-11 23:19:39'), (257, 'ajomorutoseh97@gmail.com', '2025-09-12 06:52:59', '2025-09-12 06:52:59'), (258, 'gorofuzih53@gmail.com', '2025-09-13 19:33:23', '2025-09-13 19:33:23'), (259, 'btefaubon1trv@yahoo.com', '2025-09-13 21:42:30', '2025-09-13 21:42:30'), (260, 'cebayilove213@gmail.com', '2025-09-14 16:07:56', '2025-09-14 16:07:56'), (261, 'esolawiy93@gmail.com', '2025-09-16 04:39:58', '2025-09-16 04:39:58'), (262, 'abaselot344@gmail.com', '2025-09-16 10:04:11', '2025-09-16 10:04:11'), (263, 'oqtjocys5h7zdf8ap@yahoo.com', '2025-09-16 10:58:05', '2025-09-16 10:58:05'), (264, 'rokuhereye150@gmail.com', '2025-09-16 13:41:15', '2025-09-16 13:41:15'), (265, 'iqohidura35@gmail.com', '2025-09-17 12:02:12', '2025-09-17 12:02:12'), (266, 'ihiromiralo439@gmail.com', '2025-09-20 09:24:29', '2025-09-20 09:24:29'), (267, 'xcuyw39w7qqvm@yahoo.com', '2025-09-20 13:10:14', '2025-09-20 13:10:14'), (268, 'zonalugav500@gmail.com', '2025-09-22 17:09:38', '2025-09-22 17:09:38'), (269, 'abejagaratud87@gmail.com', '2025-09-22 19:25:02', '2025-09-22 19:25:02'), (270, 'u1ylxyc5geqxrxx@yahoo.com', '2025-09-23 15:28:29', '2025-09-23 15:28:29'), (271, 'wtxagbcltgyofdg@yahoo.com', '2025-09-28 17:03:29', '2025-09-28 17:03:29'), (272, 'tailerwoy21@gmail.com', '2025-09-28 21:58:50', '2025-09-28 21:58:50'), (273, 'rampesadw38rojkvic@yahoo.com', '2025-09-29 08:13:38', '2025-09-29 08:13:38'), (274, 'urgsseyy@testform.xyz', '2025-10-08 02:09:03', '2025-10-08 02:09:03'), (275, 'ffydyxlh@testform.xyz', '2025-10-08 02:09:03', '2025-10-08 02:09:03'), (276, 'ijaviniji431@gmail.com', '2025-10-24 00:06:02', '2025-10-24 00:06:02'), (277, 'djillianjlg1985@gmail.com', '2025-10-29 22:40:00', '2025-10-29 22:40:00'), (278, 'apasefifuna060@gmail.com', '2025-11-01 06:25:28', '2025-11-01 06:25:28'), (279, 'romerosheliya1995@gmail.com', '2025-11-01 23:43:19', '2025-11-01 23:43:19'), (280, 'efilzoyg@testform.xyz', '2025-11-04 18:56:14', '2025-11-04 18:56:14'), (281, 'prnzqmlk@testform.xyz', '2025-11-04 18:56:15', '2025-11-04 18:56:15'), (282, 'sgpzxhww@testform.xyz', '2025-11-04 18:56:21', '2025-11-04 18:56:21'), (283, 'lnpizsis@testform.xyz', '2025-11-06 02:48:52', '2025-11-06 02:48:52'), (284, 'jwqndykn@testform.xyz', '2025-11-06 02:48:52', '2025-11-06 02:48:52'), (285, 'hiqgropf@testform.xyz', '2025-11-06 02:48:53', '2025-11-06 02:48:53'), (286, 'xadafavijar627@gmail.com', '2025-11-06 20:48:12', '2025-11-06 20:48:12'), (287, 'abenode808@gmail.com', '2025-11-08 20:42:31', '2025-11-08 20:42:31'), (288, 'nogqwmro@testform.xyz', '2025-11-11 13:43:48', '2025-11-11 13:43:48'), (289, 'ewjgttqv@testform.xyz', '2025-11-11 13:43:50', '2025-11-11 13:43:50'), (290, 'zkklxsph@testform.xyz', '2025-11-11 13:43:52', '2025-11-11 13:43:52'), (291, 'rxxntdlm@testform.xyz', '2025-11-11 13:43:52', '2025-11-11 13:43:52'), (292, 'hahiwew218@gmail.com', '2025-11-17 20:37:27', '2025-11-17 20:37:27'), (293, 'sabafekali784@gmail.com', '2025-11-25 02:44:06', '2025-11-25 02:44:06'), (294, 'zsfrphnj@testform.xyz', '2025-12-04 06:36:44', '2025-12-04 06:36:44'), (295, 'misvyepr@testform.xyz', '2025-12-04 06:36:44', '2025-12-04 06:36:44'), (296, 'nhdzkxqk@testform.xyz', '2025-12-04 06:36:44', '2025-12-04 06:36:44'), (297, 'tedhldxt@testform.xyz', '2025-12-04 06:36:45', '2025-12-04 06:36:45'), (298, 'ignkxdoh@testform.xyz', '2025-12-15 22:29:09', '2025-12-15 22:29:09'), (299, 'ytjwlpms@testform.xyz', '2025-12-15 22:29:10', '2025-12-15 22:29:10'), (300, 'xjtppzev@testform.xyz', '2025-12-15 22:29:10', '2025-12-15 22:29:10'), (301, 'ribuqucebig699@gmail.com', '2025-12-25 09:00:33', '2025-12-25 09:00:33'), (302, 'k.u.he.mi.ka356@gmail.com', '2026-01-06 16:07:54', '2026-01-06 16:07:54'), (303, 'oz.i.ho.z.o.w.9.1.5@gmail.com', '2026-01-14 03:34:01', '2026-01-14 03:34:01'), (304, 'o.ye.s.uba.m.a.x.0.68@gmail.com', '2026-01-16 14:14:58', '2026-01-16 14:14:58'), (305, 'di.daq.e.v.i.ce.w57@gmail.com', '2026-01-23 17:28:05', '2026-01-23 17:28:05'), (306, 'tlelvhxe@checkyourform.xyz', '2026-01-29 05:23:54', '2026-01-29 05:23:54'), (307, 'lizjlsiq@checkyourform.xyz', '2026-01-29 05:24:19', '2026-01-29 05:24:19'), (308, 'xhkiufoq@checkyourform.xyz', '2026-01-29 05:24:28', '2026-01-29 05:24:28'), (309, 'oxa.mi.ji.f.u70.1@gmail.com', '2026-02-23 04:37:21', '2026-02-23 04:37:21'), (310, 'ez.abuc.o.r.2.8@gmail.com', '2026-02-24 06:10:32', '2026-02-24 06:10:32'), (311, 'oq.i.n.i.q.u.7.5.2@gmail.com', '2026-02-24 17:56:08', '2026-02-24 17:56:08'), (312, 'um.af.e.pi.q.i.b.u.c87@gmail.com', '2026-03-01 14:24:43', '2026-03-01 14:24:43'), (313, 'mewiugdw@checkyourform.xyz', '2026-03-01 16:06:50', '2026-03-01 16:06:50'), (314, 'hfolqftq@checkyourform.xyz', '2026-03-01 16:06:53', '2026-03-01 16:06:53'), (315, 'elyeqrek@checkyourform.xyz', '2026-03-01 16:07:38', '2026-03-01 16:07:38'), (316, 'w.es.u.xaso.f.u.le4.0@gmail.com', '2026-03-02 06:22:37', '2026-03-02 06:22:37'), (317, 'so.lu.qiq.oga.gi88@gmail.com', '2026-03-02 08:52:03', '2026-03-02 08:52:03'), (318, 'og.e.h.u.l.e.qo.c0.0@gmail.com', '2026-03-07 03:24:03', '2026-03-07 03:24:03'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `permissions` -- CREATE TABLE `permissions` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `permissions` -- INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'create content', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'read content', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'update content', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 'delete content', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (5, 'create user', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (6, 'read user', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (7, 'update user', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (8, 'delete user', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (9, 'create role', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (10, 'read role', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (11, 'update role', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (12, 'delete role', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (13, 'create permission', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (14, 'read permission', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (15, 'update permission', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (16, 'delete permission', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `pictures` -- CREATE TABLE `pictures` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `picture_tag` -- CREATE TABLE `picture_tag` ( `id` bigint UNSIGNED NOT NULL, `picture_id` bigint UNSIGNED NOT NULL, `tag_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `posts` -- CREATE TABLE `posts` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `header` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_id` bigint UNSIGNED NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('Published','Paused','Draft') COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `posts` -- INSERT INTO `posts` (`id`, `user_id`, `title`, `slug`, `header`, `public_id`, `category_id`, `description`, `type`, `status`, `content`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'Nature in Ofinita’s Ceramics', 'nature-ceramics-ofinita', 'cd-project/product-7/seeders/blog/blog-1.jpg', 'blog-1', 1, 'Delfina Colombres integrates natural elements into her ceramics, creating pieces that resonate with memory and transformation.', 'public', 'Published', '

In her ceramics, Delfina Colombres captures textures and forms inspired by nature, evoking memories and emotional connections. Each piece is a testament to her affinity with the natural world, reinterpreted through a contemporary and artisanal lens.

', '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (2, 1, 'The Fusion of Traditional and Modern Techniques', 'fusion-craft-techniques', 'cd-project/product-7/seeders/blog/blog-2.jpg', 'blog-2', 2, 'How Ofinita blends traditional techniques with modern processes to create new visual narratives.', 'public', 'Published', '

Delfina Colombres explores an experimental approach in her work, combining traditional methods such as engraving and embroidery with contemporary creative processes. This dual approach allows Ofinita to create unique pieces that are both visually captivating and deeply evocative of personal and cultural stories.

', '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (3, 1, 'Identity and Memory in Ofinita’s Art', 'identity-memory-ofinita', 'cd-project/product-7/seeders/blog/blog-3.jpg', 'blog-3', 3, 'Explore how Delfina Colombres’ work tells stories of identity and memory through art.', 'public', 'Published', '

Through her art, Delfina Colombres investigates the relationship between identity and memory. Using a range of multidisciplinary techniques, her works reflect deep introspection into past experiences and cultural influence, bringing to the present personal narratives that invite viewers into introspective reflection.

', '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `post_categories` -- CREATE TABLE `post_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `post_categories` -- INSERT INTO `post_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (1, 'Art and Nature', 'art-nature', 'Explore how nature influences the multidisciplinary work of Delfina Colombres.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Craft Techniques', 'craft-techniques', 'Dive into the traditional and contemporary techniques Delfina uses in her creative process.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Memory and Identity', 'memory-identity', 'Discover the visual narratives that explore themes of memory and identity in Ofinita’s work.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `products` -- CREATE TABLE `products` ( `id` bigint UNSIGNED NOT NULL, `category_id` bigint UNSIGNED DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `price` decimal(10,2) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `products` -- INSERT INTO `products` (`id`, `category_id`, `name`, `slug`, `description`, `price`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 1, 'Root Vessel', 'root-vessel', 'Sculptural ceramic vessel with abstract shapes, earthy texture and dark finish, blending tradition and contemporary design.', 200.00, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (2, 1, 'Andean Bowl', 'andean-bowl', 'Narrow-mouth bowl with rounded body, decorated with a bubble-pattern in black glaze and reddish clay base.', 200.00, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (3, 2, 'Tapestry \'Living Memory\'', 'tapestry-living-memory', 'Naive-style ceramic dog figure, evoking childhood memories and symbolic elements from rural life.', 200.00, 1, '2025-05-21 12:37:23', '2025-06-04 17:10:12', NULL), (4, 2, 'Earth Paths', 'earth-paths', 'Biomorphic ceramic object with double opening, rough surface and organic modeling, representing life journeys.', 200.00, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (5, 3, 'Ritual Object', 'ritual-object', 'Sculptural piece with curved lines and grainy texture, inspired by pre-Columbian ritual art with a modern vision.', 200.00, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL), (6, 3, 'Fragments Series', 'fragments-series', 'Pufferfish sculpture in raw clay with protrusions, exploring playfulness and volume in formal construction.', 200.00, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `product_images` -- CREATE TABLE `product_images` ( `id` bigint UNSIGNED NOT NULL, `product_id` bigint UNSIGNED NOT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `product_images` -- INSERT INTO `product_images` (`id`, `product_id`, `image_path`, `created_at`, `updated_at`) VALUES (1, 1, 'cd-project/product-7/seeders/products/product-1-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 1, 'cd-project/product-7/seeders/products/product-1-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 1, 'cd-project/product-7/seeders/products/product-1-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 2, 'cd-project/product-7/seeders/products/product-2-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (5, 2, 'cd-project/product-7/seeders/products/product-2-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (6, 2, 'cd-project/product-7/seeders/products/product-2-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (7, 3, 'cd-project/product-7/seeders/products/product-3-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (8, 3, 'cd-project/product-7/seeders/products/product-3-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (9, 3, 'cd-project/product-7/seeders/products/product-3-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (10, 4, 'cd-project/product-7/seeders/products/product-4-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (11, 4, 'cd-project/product-7/seeders/products/product-4-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (12, 4, 'cd-project/product-7/seeders/products/product-4-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (13, 5, 'cd-project/product-7/seeders/products/product-5-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (14, 5, 'cd-project/product-7/seeders/products/product-5-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (15, 5, 'cd-project/product-7/seeders/products/product-5-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (16, 6, 'cd-project/product-7/seeders/products/product-6-1.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (17, 6, 'cd-project/product-7/seeders/products/product-6-2.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (18, 6, 'cd-project/product-7/seeders/products/product-6-3.jpg', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `product_product_tag` -- CREATE TABLE `product_product_tag` ( `id` bigint UNSIGNED NOT NULL, `product_id` bigint UNSIGNED NOT NULL, `product_tag_id` bigint UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `product_product_tag` -- INSERT INTO `product_product_tag` (`id`, `product_id`, `product_tag_id`, `created_at`, `updated_at`) VALUES (1, 1, 1, NULL, NULL), (2, 1, 2, NULL, NULL), (3, 2, 1, NULL, NULL), (4, 4, 1, NULL, NULL), (5, 4, 2, NULL, NULL), (6, 6, 1, NULL, NULL), (7, 3, 1, NULL, NULL), (8, 5, 3, NULL, NULL), (9, 5, 2, NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `product_tags` -- CREATE TABLE `product_tags` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `product_tags` -- INSERT INTO `product_tags` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (1, 'Handmade', 'handmade', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Limited Edition', 'limited-edition', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Mixed Technique', 'mixed-technique', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `projects` -- CREATE TABLE `projects` ( `id` bigint UNSIGNED NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `url` text COLLATE utf8mb4_unicode_ci, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `projects` -- INSERT INTO `projects` (`id`, `description`, `url`, `title`, `image`, `logo`, `is_active`, `created_at`, `updated_at`, `deleted_at`, `image_path`) VALUES (1, 'A framed composition of real ant figures over a blurred cityscape, representing community, fragility and rhythm in urban nature.', '', 'Urban Ant Ritual', 'cd-project/product-7/seeders/projects/project-1.jpg', 'cd-project/product-7/seeders/projects/logos/project-logo-1.jpg', 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL), (2, 'A bold linocut print featuring an emu in bright yellow tones, symbolizing the wild spirit of Australian fauna.', '', 'Emu Portrait', 'cd-project/product-7/seeders/projects/project-2.jpg', 'cd-project/product-7/seeders/projects/logos/project-logo-2.jpg', 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL), (3, 'Minimalist blue-toned print capturing the quiet intensity of a child diver, suspended in a moment of inner focus and courage.', '', 'The Diver', 'cd-project/product-7/seeders/projects/project-3.jpg', 'cd-project/product-7/seeders/projects/logos/project-logo-3.jpg', 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL), (4, 'A poetic linoprint of a boat at sea, moving forward beneath radiant lines—a meditation on solitude, movement and destiny.', '', 'Into the Sea', 'cd-project/product-7/seeders/projects/project-4.jpg', 'cd-project/product-7/seeders/projects/logos/project-logo-4.jpg', 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `project_categories` -- CREATE TABLE `project_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `project_categories` -- INSERT INTO `project_categories` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES (1, 'Paintings', 'paintings', 'Unique handmade paintings by Ofinita.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Illustrations', 'illustrations', 'Illustrated works exploring contemporary and personal themes.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Portraits', 'portraits', 'Portraits of people from different cultures and backgrounds.', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `project_category_project` -- CREATE TABLE `project_category_project` ( `project_id` bigint UNSIGNED NOT NULL, `category_id` bigint UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `project_category_project` -- INSERT INTO `project_category_project` (`project_id`, `category_id`) VALUES (1, 1), (2, 3), (3, 2), (4, 1); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `references` -- CREATE TABLE `references` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `category_id` bigint UNSIGNED DEFAULT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `reference_categories` -- CREATE TABLE `reference_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `roles` -- CREATE TABLE `roles` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `roles` -- INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `guard_name`, `created_at`, `updated_at`) VALUES (1, 'System Admin', 'system-admin', 'An administrator has full power. In addition to everything an editor can do, administrators can manage users, themes, settings, widgets and plugins. This role is good for team leaders, or whoever will be “in charge” of the blog.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Administrator', 'administrator', 'An administrator has full power. In addition to everything an editor can do, administrators can manage users, themes, settings, widgets and plugins. This role is good for team leaders, or whoever will be “in charge” of the blog.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Editor', 'editor', 'An editor can create, edit, publish and delete any post or page. They can also moderate all comments, and manage categories and tags. This role is good for team members.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (4, 'Contributor', 'contributor', 'A contributor can only create and edit their own posts, but only an editor or administrator can publish them. Contributors have no access to anyone else’s posts, and cannot edit their own posts once they have published. This role is perfect for guest or student bloggers.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (5, 'Author', 'author', 'An author has the ability to create, edit, delete and publish their own posts. They can also upload media content, and edit comments on their own posts. However, they cannot touch anyone else’s posts or modify pages.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (6, 'Member', 'member', 'A member role is assigned to those users who do not have access to the administration panel.', 'web', '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `role_has_permissions` -- CREATE TABLE `role_has_permissions` ( `permission_id` bigint UNSIGNED NOT NULL, `role_id` bigint UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `services` -- CREATE TABLE `services` ( `id` bigint UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_featured` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `services` -- INSERT INTO `services` (`id`, `title`, `description`, `slug`, `logo`, `image`, `is_active`, `is_featured`, `created_at`, `updated_at`) VALUES (1, 'Pedidos Personalizados', 'Transforma tu espacio con piezas personalizadas creadas por Ofinita.', 'pedidos-personalizados', 'cd-project/product-7/seeders/services/icon-services-1.svg', NULL, 1, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Envíos Internacionales', 'Envía arte a cualquier rincón del mundo con garantía de calidad.', 'envios-internacionales', 'cd-project/product-7/seeders/services/icon-services-2.svg', NULL, 1, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Experiencias Artísticas', 'Participa en talleres presenciales y en línea con Delfina Colombres.', 'experiencias-artisticas', 'cd-project/product-7/seeders/services/icon-services-3.svg', NULL, 1, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `settings` -- CREATE TABLE `settings` ( `id` int UNSIGNED NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `settings` -- INSERT INTO `settings` (`id`, `key`, `value`, `user_id`) VALUES (1, 'description', 'LCD CMS', 1), (2, 'plan', 'Full Plan', 1), (3, 'title', 'La Compañía Digital', 1), (4, 'description', 'Content Management System Standard - Version 1.0', 1), (5, 'keywords', 'Words separated with \",\" to will found on internet', 1), (6, 'home_maintenance', '0', 1), (7, 'about_maintenance', '0', 1), (8, 'contact_maintenance', '0', 1), (9, 'blog', '0', 1), (10, 'personal_blog', '0', 1), (11, 'gallery_maintenance', '0', 1), (12, 'maintenance_mode', '0', 1); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `tags` -- CREATE TABLE `tags` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `team_categories` -- CREATE TABLE `team_categories` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `team_members` -- CREATE TABLE `team_members` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `languages` json DEFAULT NULL, `category_id` bigint UNSIGNED DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `details` longtext COLLATE utf8mb4_unicode_ci, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `users` -- CREATE TABLE `users` ( `id` bigint UNSIGNED NOT NULL, `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role_id` bigint UNSIGNED NOT NULL, `two_step` tinyint(1) NOT NULL DEFAULT '0', `api_token` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `last_login_at` datetime DEFAULT NULL, `last_login_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `users` -- INSERT INTO `users` (`id`, `first_name`, `last_name`, `slug`, `email`, `email_verified_at`, `password`, `role_id`, `two_step`, `api_token`, `remember_token`, `created_at`, `updated_at`, `last_login_at`, `last_login_ip`) VALUES (1, 'Coke', 'Colombres', 'coke-colombres', 'coke@lacompaniadigital.com', '2025-05-21 12:37:23', '$2y$10$PhbmQrmfbktHa.1sPnASOuhla4gIuE.3TOU5SCHGQ9n5TvvA64lq6', 1, 0, '$2y$10$iKOorTZQbvX.qPrMoLyo5uthoEIjrbOzcICo19nsGJ5IERKYGj33e', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL), (2, 'Admin', 'Admin', 'admin-admin', 'admin@ofinita.com', '2025-05-21 12:37:23', '$2y$10$QBukBgmaCfqBQLR9stMLsut/rr5hsRlNbbkXszPq8mzM4NZysvBdi', 1, 0, '$2y$10$Uvzq0bx4sC5CBy15s.RfYumukl24Tz/gkAh4rz1a6tLIFJ..KOpci', NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `user_infos` -- CREATE TABLE `user_infos` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `avatar` text COLLATE utf8mb4_unicode_ci, `avatar_public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `member_since` date DEFAULT NULL, `linkedin` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `user_infos` -- INSERT INTO `user_infos` (`id`, `user_id`, `avatar`, `avatar_public_id`, `avatar_url`, `phone`, `mobile`, `status`, `country`, `file`, `type`, `details`, `language`, `created_at`, `updated_at`, `address`, `member_since`, `linkedin`) VALUES (1, 1, NULL, NULL, NULL, '909 71 6469', '+34 969 60 4596', NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL, NULL), (2, 2, NULL, NULL, NULL, '904937959', '973 44 1246', NULL, NULL, NULL, NULL, NULL, NULL, '2025-05-21 12:37:23', '2025-05-21 12:37:23', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `welcome_carousels` -- CREATE TABLE `welcome_carousels` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `public_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order` int NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Volcado de datos para la tabla `welcome_carousels` -- INSERT INTO `welcome_carousels` (`id`, `name`, `image_path`, `public_id`, `order`, `created_at`, `updated_at`) VALUES (1, 'Experiencias de Lujo a Medida', 'cd-project/product-7/seeders/banner/1.jpg', NULL, 1, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (2, 'Transporte Privado y Estilo de Vida', 'cd-project/product-7/seeders/banner/2.jpg', NULL, 2, '2025-05-21 12:37:23', '2025-05-21 12:37:23'), (3, 'Eventos Inolvidables y Entretenimiento Premium', 'cd-project/product-7/seeders/banner/3.jpg', NULL, 3, '2025-05-21 12:37:23', '2025-05-21 12:37:23'); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `activity_log` -- ALTER TABLE `activity_log` ADD PRIMARY KEY (`id`), ADD KEY `subject` (`subject_type`,`subject_id`), ADD KEY `causer` (`causer_type`,`causer_id`), ADD KEY `activity_log_log_name_index` (`log_name`); -- -- Indices de la tabla `albums` -- ALTER TABLE `albums` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `albums_name_unique` (`name`); -- -- Indices de la tabla `album_picture` -- ALTER TABLE `album_picture` ADD PRIMARY KEY (`id`), ADD KEY `album_picture_album_id_foreign` (`album_id`), ADD KEY `album_picture_picture_id_foreign` (`picture_id`); -- -- Indices de la tabla `album_tag` -- ALTER TABLE `album_tag` ADD PRIMARY KEY (`id`), ADD KEY `album_tag_album_id_foreign` (`album_id`), ADD KEY `album_tag_tag_id_foreign` (`tag_id`); -- -- Indices de la tabla `carousels` -- ALTER TABLE `carousels` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `carousel_picture` -- ALTER TABLE `carousel_picture` ADD PRIMARY KEY (`id`), ADD KEY `carousel_picture_carousel_id_foreign` (`carousel_id`), ADD KEY `carousel_picture_picture_id_foreign` (`picture_id`); -- -- Indices de la tabla `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indices de la tabla `faqs` -- ALTER TABLE `faqs` ADD PRIMARY KEY (`id`), ADD KEY `faqs_category_id_foreign` (`category_id`); -- -- Indices de la tabla `faqs_categories` -- ALTER TABLE `faqs_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `faqs_categories_name_unique` (`name`), ADD UNIQUE KEY `faqs_categories_slug_unique` (`slug`); -- -- Indices de la tabla `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`), ADD KEY `gallery_category_id_index` (`category_id`); -- -- Indices de la tabla `gallery_categories` -- ALTER TABLE `gallery_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `gallery_categories_name_unique` (`name`), ADD UNIQUE KEY `gallery_categories_slug_unique` (`slug`); -- -- Indices de la tabla `gallery_gallery_tag` -- ALTER TABLE `gallery_gallery_tag` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `gallery_gallery_tag_gallery_id_gallery_tag_id_unique` (`gallery_id`,`gallery_tag_id`), ADD KEY `gallery_gallery_tag_gallery_tag_id_foreign` (`gallery_tag_id`); -- -- Indices de la tabla `gallery_tags` -- ALTER TABLE `gallery_tags` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`), ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indices de la tabla `model_has_roles` -- ALTER TABLE `model_has_roles` ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`), ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`); -- -- Indices de la tabla `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `news_slug_unique` (`slug`), ADD KEY `news_user_id_foreign` (`user_id`); -- -- Indices de la tabla `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `newsletter_subscribers_email_unique` (`email`); -- -- Indices de la tabla `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indices de la tabla `permissions` -- ALTER TABLE `permissions` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`); -- -- Indices de la tabla `pictures` -- ALTER TABLE `pictures` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `picture_tag` -- ALTER TABLE `picture_tag` ADD PRIMARY KEY (`id`), ADD KEY `picture_tag_picture_id_foreign` (`picture_id`), ADD KEY `picture_tag_tag_id_foreign` (`tag_id`); -- -- Indices de la tabla `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`), ADD KEY `posts_user_id_foreign` (`user_id`), ADD KEY `posts_category_id_foreign` (`category_id`); -- -- Indices de la tabla `post_categories` -- ALTER TABLE `post_categories` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `products_slug_unique` (`slug`), ADD KEY `products_category_id_foreign` (`category_id`); -- -- Indices de la tabla `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`), ADD KEY `product_images_product_id_foreign` (`product_id`); -- -- Indices de la tabla `product_product_tag` -- ALTER TABLE `product_product_tag` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `product_product_tag_product_id_product_tag_id_unique` (`product_id`,`product_tag_id`), ADD KEY `product_product_tag_product_tag_id_foreign` (`product_tag_id`); -- -- Indices de la tabla `product_tags` -- ALTER TABLE `product_tags` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `product_tags_name_unique` (`name`), ADD UNIQUE KEY `product_tags_slug_unique` (`slug`); -- -- Indices de la tabla `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`id`); -- -- Indices de la tabla `project_categories` -- ALTER TABLE `project_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `project_categories_slug_unique` (`slug`); -- -- Indices de la tabla `project_category_project` -- ALTER TABLE `project_category_project` ADD KEY `project_category_project_project_id_foreign` (`project_id`), ADD KEY `project_category_project_category_id_foreign` (`category_id`); -- -- Indices de la tabla `references` -- ALTER TABLE `references` ADD PRIMARY KEY (`id`), ADD KEY `references_category_id_foreign` (`category_id`); -- -- Indices de la tabla `reference_categories` -- ALTER TABLE `reference_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `reference_categories_name_unique` (`name`), ADD UNIQUE KEY `reference_categories_slug_unique` (`slug`); -- -- Indices de la tabla `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`); -- -- Indices de la tabla `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD PRIMARY KEY (`permission_id`,`role_id`), ADD KEY `role_has_permissions_role_id_foreign` (`role_id`); -- -- Indices de la tabla `services` -- ALTER TABLE `services` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `services_slug_unique` (`slug`); -- -- Indices de la tabla `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD KEY `settings_key_index` (`key`); -- -- Indices de la tabla `tags` -- ALTER TABLE `tags` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tags_name_unique` (`name`); -- -- Indices de la tabla `team_categories` -- ALTER TABLE `team_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `team_categories_name_unique` (`name`); -- -- Indices de la tabla `team_members` -- ALTER TABLE `team_members` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `team_members_slug_unique` (`slug`), ADD KEY `team_members_category_id_foreign` (`category_id`); -- -- Indices de la tabla `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD UNIQUE KEY `users_api_token_unique` (`api_token`), ADD KEY `users_role_id_foreign` (`role_id`); -- -- Indices de la tabla `user_infos` -- ALTER TABLE `user_infos` ADD PRIMARY KEY (`id`), ADD KEY `user_infos_user_id_foreign` (`user_id`); -- -- Indices de la tabla `welcome_carousels` -- ALTER TABLE `welcome_carousels` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `activity_log` -- ALTER TABLE `activity_log` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT de la tabla `albums` -- ALTER TABLE `albums` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `album_picture` -- ALTER TABLE `album_picture` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `album_tag` -- ALTER TABLE `album_tag` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `carousels` -- ALTER TABLE `carousels` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `carousel_picture` -- ALTER TABLE `carousel_picture` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `categories` -- ALTER TABLE `categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `faqs` -- ALTER TABLE `faqs` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `faqs_categories` -- ALTER TABLE `faqs_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `gallery` -- ALTER TABLE `gallery` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT de la tabla `gallery_categories` -- ALTER TABLE `gallery_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT de la tabla `gallery_gallery_tag` -- ALTER TABLE `gallery_gallery_tag` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT de la tabla `gallery_tags` -- ALTER TABLE `gallery_tags` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82; -- -- AUTO_INCREMENT de la tabla `news` -- ALTER TABLE `news` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=319; -- -- AUTO_INCREMENT de la tabla `permissions` -- ALTER TABLE `permissions` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT de la tabla `pictures` -- ALTER TABLE `pictures` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `picture_tag` -- ALTER TABLE `picture_tag` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `posts` -- ALTER TABLE `posts` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `post_categories` -- ALTER TABLE `post_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `products` -- ALTER TABLE `products` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT de la tabla `product_images` -- ALTER TABLE `product_images` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT de la tabla `product_product_tag` -- ALTER TABLE `product_product_tag` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT de la tabla `product_tags` -- ALTER TABLE `product_tags` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `projects` -- ALTER TABLE `projects` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT de la tabla `project_categories` -- ALTER TABLE `project_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `references` -- ALTER TABLE `references` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `reference_categories` -- ALTER TABLE `reference_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `roles` -- ALTER TABLE `roles` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT de la tabla `services` -- ALTER TABLE `services` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT de la tabla `settings` -- ALTER TABLE `settings` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT de la tabla `tags` -- ALTER TABLE `tags` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `team_categories` -- ALTER TABLE `team_categories` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `team_members` -- ALTER TABLE `team_members` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT de la tabla `users` -- ALTER TABLE `users` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT de la tabla `user_infos` -- ALTER TABLE `user_infos` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT de la tabla `welcome_carousels` -- ALTER TABLE `welcome_carousels` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- Restricciones para tablas volcadas -- -- -- Filtros para la tabla `album_picture` -- ALTER TABLE `album_picture` ADD CONSTRAINT `album_picture_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `album_picture_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `album_tag` -- ALTER TABLE `album_tag` ADD CONSTRAINT `album_tag_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `album_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `carousel_picture` -- ALTER TABLE `carousel_picture` ADD CONSTRAINT `carousel_picture_carousel_id_foreign` FOREIGN KEY (`carousel_id`) REFERENCES `carousels` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `carousel_picture_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `faqs` -- ALTER TABLE `faqs` ADD CONSTRAINT `faqs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `faqs_categories` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `gallery` -- ALTER TABLE `gallery` ADD CONSTRAINT `gallery_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE SET NULL; -- -- Filtros para la tabla `gallery_gallery_tag` -- ALTER TABLE `gallery_gallery_tag` ADD CONSTRAINT `gallery_gallery_tag_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `gallery_gallery_tag_gallery_tag_id_foreign` FOREIGN KEY (`gallery_tag_id`) REFERENCES `gallery_tags` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `model_has_permissions` -- ALTER TABLE `model_has_permissions` ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `model_has_roles` -- ALTER TABLE `model_has_roles` ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `news` -- ALTER TABLE `news` ADD CONSTRAINT `news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `picture_tag` -- ALTER TABLE `picture_tag` ADD CONSTRAINT `picture_tag_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `picture_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `posts` -- ALTER TABLE `posts` ADD CONSTRAINT `posts_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `post_categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `product_images` -- ALTER TABLE `product_images` ADD CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `product_product_tag` -- ALTER TABLE `product_product_tag` ADD CONSTRAINT `product_product_tag_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `product_product_tag_product_tag_id_foreign` FOREIGN KEY (`product_tag_id`) REFERENCES `product_tags` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `project_category_project` -- ALTER TABLE `project_category_project` ADD CONSTRAINT `project_category_project_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `project_categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `project_category_project_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `references` -- ALTER TABLE `references` ADD CONSTRAINT `references_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `reference_categories` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `role_has_permissions` -- ALTER TABLE `role_has_permissions` ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `team_members` -- ALTER TABLE `team_members` ADD CONSTRAINT `team_members_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `team_categories` (`id`) ON DELETE SET NULL; -- -- Filtros para la tabla `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE; -- -- Filtros para la tabla `user_infos` -- ALTER TABLE `user_infos` ADD CONSTRAINT `user_infos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;