/*
 Navicat Premium Data Transfer

 Source Server         : myconn2
 Source Server Type    : MySQL
 Source Server Version : 80031 (8.0.31)
 Source Host           : localhost:3306
 Source Schema         : inventory_app

 Target Server Type    : MySQL
 Target Server Version : 80031 (8.0.31)
 File Encoding         : 65001

 Date: 25/02/2025 20:39:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `barcode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NULL,
  `price` decimal(10, 2) NOT NULL,
  `stock` int NOT NULL,
  `last_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `barcode`(`barcode`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_spanish_ci;

-- ----------------------------
-- Records of products
-- ----------------------------
BEGIN;
INSERT INTO `products` (`id`, `barcode`, `name`, `description`, `price`, `stock`, `last_updated`) VALUES (1, '123456789012', 'Leche Entera', 'Leche entera de 1 litro', 1.99, 103, '2025-02-25 20:10:31'), (2, '223456789012', 'Pan Integral', 'Pan integral de 500g', 2.49, 50, '2025-02-25 19:30:29'), (3, '323456789012', 'Huevos', 'Docena de huevos grandes', 3.99, 30, '2025-02-25 19:30:29'), (4, '423456789012', 'Manzanas', 'Bolsa de manzanas rojas 1kg', 2.99, 40, '2025-02-25 19:30:29'), (5, '523456789012', 'Arroz', 'Arroz blanco de grano largo 1kg', 1.79, 80, '2025-02-25 19:30:29'), (6, '623456789012', 'Pasta', 'Pasta de espagueti 500g', 1.29, 60, '2025-02-25 19:30:29'), (7, '723456789012', 'Atún en Lata', 'Atún en agua 150g', 1.49, 70, '2025-02-25 19:30:29'), (8, '823456789012', 'Jabón de Manos', 'Jabón líquido para manos 250ml', 2.99, 45, '2025-02-25 19:30:29'), (9, '923456789012', 'Papel Higiénico', 'Paquete de 12 rollos', 5.99, 25, '2025-02-25 19:30:29'), (10, '023456789012', 'Detergente', 'Detergente líquido para ropa 2L', 7.99, 35, '2025-02-25 19:30:29');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `role` enum('admin','editor') CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_spanish_ci;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `role`) VALUES (1, 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'admin'), (2, 'editor1', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'editor'), (3, 'editor2', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'editor');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;