-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `u427573777_LC2JS`
--

-- --------------------------------------------------------

--
-- Table structure for table `j6w7_employee`
--

CREATE TABLE `j6w7_employee` (
  `id_employee` int(10) UNSIGNED NOT NULL,
  `id_profile` int(10) UNSIGNED NOT NULL,
  `id_lang` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `lastname` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  `last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
  `stats_date_from` date DEFAULT NULL,
  `stats_date_to` date DEFAULT NULL,
  `stats_compare_from` date DEFAULT NULL,
  `stats_compare_to` date DEFAULT NULL,
  `stats_compare_option` int(1) UNSIGNED NOT NULL DEFAULT 1,
  `preselect_date_range` varchar(32) DEFAULT NULL,
  `bo_color` varchar(32) DEFAULT NULL,
  `bo_theme` varchar(32) DEFAULT NULL,
  `bo_css` varchar(64) DEFAULT NULL,
  `default_tab` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `bo_width` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `bo_menu` tinyint(1) NOT NULL DEFAULT 1,
  `active` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `optin` tinyint(1) UNSIGNED DEFAULT NULL,
  `id_last_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `id_last_customer_message` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `id_last_customer` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `last_connection_date` date DEFAULT NULL,
  `reset_password_token` varchar(40) DEFAULT NULL,
  `reset_password_validity` datetime DEFAULT NULL,
  `has_enabled_gravatar` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `passwd_old_wp` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `j6w7_employee`
--

INSERT INTO `j6w7_employee` (`id_employee`, `id_profile`, `id_lang`, `lastname`, `firstname`, `email`, `passwd`, `last_passwd_gen`, `stats_date_from`, `stats_date_to`, `stats_compare_from`, `stats_compare_to`, `stats_compare_option`, `preselect_date_range`, `bo_color`, `bo_theme`, `bo_css`, `default_tab`, `bo_width`, `bo_menu`, `active`, `optin`, `id_last_order`, `id_last_customer_message`, `id_last_customer`, `last_connection_date`, `reset_password_token`, `reset_password_validity`, `has_enabled_gravatar`, `passwd_old_wp`) VALUES
(1, 1, 2, 'Owner', 'Site', 'grupornd41@gmail.com', '$2y$10$w4O0RHNOY3tLvQvA46tHvebBq80MiJ0zxGdU/J6VWqe6r3aEO4z4S', '2024-10-07 15:37:37', '2025-06-06', '2025-06-06', '0000-00-00', '0000-00-00', 1, 'day', '', 'default', 'theme.css', 1, 0, 1, 1, NULL, 2775, 15333, 2967, '2025-09-09', '', '0000-00-00 00:00:00', 0, NULL),
(2, 1, 2, 'Flores Martinez', 'Laura', 'no-responder@sunnies.uno', '$2y$10$h/dBnLqbu7pY7undTElfZO.X6zOJLNTqZL.UrrX4/6lnMZM9gD42i', '2021-03-12 11:17:13', '2021-02-12', '2021-03-12', NULL, NULL, 1, '', '', '', 'theme.css', 4, 0, 1, 1, 0, 8561, 8699, 1672, '2021-12-01', '', NULL, 0, '$2y$10$h/dBnLqbu7pY7undTElfZO.X6zOJLNTqZL.UrrX4/6lnMZM9gD42i'),
(3, 1, 2, 'Marketplace', 'Prestashop', 'mbo-74178909-ff9f-4fdc-8a77-ba67eabd76d2@prestashop.com', '$2y$10$VqvOlGx4FkrlKoHcMac57uRm4tq.ujogLiQJRd57mp7NNoGkvVD/S', '2025-01-29 04:37:20', '2024-12-29', '2025-01-29', '0000-00-00', '0000-00-00', 1, NULL, NULL, NULL, 'theme.css', 0, 0, 1, 1, NULL, 0, 0, 0, NULL, NULL, '0000-00-00 00:00:00', 0, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `j6w7_employee`
--
ALTER TABLE `j6w7_employee`
  ADD PRIMARY KEY (`id_employee`),
  ADD KEY `employee_login` (`email`,`passwd`),
  ADD KEY `id_employee_passwd` (`id_employee`,`passwd`),
  ADD KEY `id_profile` (`id_profile`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `j6w7_employee`
--
ALTER TABLE `j6w7_employee`
  MODIFY `id_employee` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

