-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 16-12-2022 a las 09:38:41
-- Versión del servidor: 8.0.31-0ubuntu0.20.04.2
-- Versión de PHP: 7.4.3

START TRANSACTION;















CREATE TABLE `warehouse_catalog_items` (
  `id` int NOT NULL,
  `catalogs_id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL,
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `orden` int DEFAULT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `warehouse_catalog_items`
--

INSERT INTO `warehouse_catalog_items` (`id`, `catalogs_id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `orden`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'ALMACEN DE INSUMOS', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE INSUMOS', NULL, 'A', '2022-04-24 21:29:37', '2022-04-24 21:29:37'),
(2, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'ALMACEN DE COMPRA Y VENTA', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE COMPRA Y VENTA', NULL, 'A', '2022-04-24 21:35:37', '2022-04-24 21:35:37'),
(3, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'GENERICO', 'es', NULL, 'BRAND', '0', 0, 'GENERICO', NULL, 'A', '2022-05-13 12:21:32', '2022-05-13 12:21:32'),
(4, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'COLOR', 'es', NULL, 'ASSISTANT', '0', 0, 'COLOR', NULL, 'A', '2022-05-13 12:21:43', '2022-05-13 12:21:43'),
(5, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'TALLA', 'es', NULL, 'ASSISTANT', '0', 0, 'TALLA', NULL, 'A', '2022-05-13 12:21:50', '2022-05-13 12:21:50'),
(6, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'UNIDAD', 'es', NULL, 'MEASUREMENT', '0', 0, 'UNIDAD', NULL, 'A', '2022-05-13 12:22:47', '2022-05-13 12:22:47'),
(7, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'AJUSTE DE INVENTARIO', 'es', NULL, 'DROPS', '0', 0, 'AJUSTE DE INVENTARIO', NULL, 'A', '2022-05-13 12:22:58', '2022-05-13 12:22:58'),
(9, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'VARIOS', 'es', 1000, 'CATEGORY', '0', 0, 'VARIOS', NULL, 'A', '2022-05-13 12:38:24', '2022-06-26 22:39:24'),
(10, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'COCA COLA', 'es', -1, 'BRAND', '0', 0, 'COCA COLA', NULL, 'A', '2022-06-26 19:09:39', '2022-06-26 19:09:39'),
(11, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'NESCAFE', 'es', -1, 'BRAND', '0', 0, 'NESCAFE', NULL, 'A', '2022-06-26 19:11:06', '2022-06-26 19:11:06'),
(12, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'XIAOMI', 'es', -1, 'BRAND', '0', 0, 'XIAOMI', NULL, 'A', '2022-06-26 19:12:52', '2022-06-26 19:12:52'),
(13, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PRODUCTOS VARIOS', 'es', 1001, 'CATEGORY', 'CATEGORY', 2, 'PRODUCTOS VARIOS', NULL, 'A', '2022-06-26 22:39:17', '2022-06-26 22:39:17'),
(14, 1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'ALMACEN DE ACTIVOS FIJOS', 'es', NULL, 'TIPOALMACEN', '0', 0, 'ALMACEN DE ACTIVOS FIJOS', NULL, 'A', '2022-06-30 19:04:44', '2022-06-30 19:04:44');

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

--
-- Estructura de tabla para la tabla `warehouse_configuration`
--

CREATE TABLE `warehouse_configuration` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `decimals` smallint NOT NULL,
  `currency_id` int NOT NULL DEFAULT '1' COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `warehouse_configuration`
--

INSERT INTO `warehouse_configuration` (`relative`, `users_sid`, `global_branch_office_id`, `decimals`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('9c307433-e41c-4205-982d-b715f5779b98', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 'A', '2022-04-26 21:30:28', '2022-04-26 21:30:28');

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

--
-- Estructura de tabla para la tabla `warehouse_enterprise`
--

CREATE TABLE `warehouse_enterprise` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `fullname` varchar(250) NOT NULL,
  `economic_activity` mediumtext NOT NULL,
  `owner` varchar(250) NOT NULL,
  `address` mediumtext NOT NULL,
  `phones` varchar(150) NOT NULL,
  `branch_office` varchar(200) DEFAULT NULL,
  `branch_code` varchar(25) DEFAULT NULL,
  `city` tinytext NOT NULL,
  `photo` varchar(250) DEFAULT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `warehouse_enterprise`
--

INSERT INTO `warehouse_enterprise` (`relative`, `users_sid`, `global_branch_office_id`, `fullname`, `economic_activity`, `owner`, `address`, `phones`, `branch_office`, `branch_code`, `city`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('d1c463d9-4219-40f1-b410-8df570eb4859', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 'TRYDENT SERVICES', 'Desarrollo de aplicaciones web', 'Ing. Jose Aparicio', 'Descripcion del sistema', '+591-76108443', 'Casa matriz', '1', 'La Paz', '1650934826-7142650-da69c7b4-ee88-410a-a4a3-7b908747fcdf.jpeg', 'A', '2022-04-25 21:00:26', '2022-04-25 21:03:19');

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

--
-- Estructura de tabla para la tabla `warehouse_products`
--

CREATE TABLE `warehouse_products` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `internal_code` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Internal code',
  `fullname` varchar(250) NOT NULL,
  `description` mediumtext NOT NULL,
  `category_id` smallint NOT NULL COMMENT 'Related to Catalogs item = CATEGORY',
  `subcategory_id` smallint DEFAULT NULL COMMENT 'Related to Catalogs item = CATEGORY | SUBCATEGORY',
  `product_pictures` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci COMMENT 'Many URL separated by | on each data',
  `barcode` varchar(50) NOT NULL,
  `inventory_method` enum('PEPS','UEPS','PEPP','UEPP') NOT NULL DEFAULT 'UEPS',
  `enabled` enum('Y','N') NOT NULL DEFAULT 'Y',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_products_assistant`
--

CREATE TABLE `warehouse_products_assistant` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to catalogs = BRANCH',
  `provisional` varchar(50) DEFAULT NULL,
  `product_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'Related to product table',
  `assistant_id` smallint NOT NULL COMMENT 'Related to catalogs = ASSISTANT	',
  `specification` varchar(200) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `warehouse_products_assistant`
--

INSERT INTO `warehouse_products_assistant` (`id`, `users_sid`, `global_branch_office_id`, `provisional`, `product_id`, `assistant_id`, `specification`, `status`, `created_at`, `updated_at`) VALUES
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '0c1aacaf-ff95-48fb-86f3-03d743f279e9', NULL, 1, 'ROJO', 'A', '2022-10-03 19:13:45', '2022-10-03 19:13:45');

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

--
-- Estructura de tabla para la tabla `warehouse_products_lot`
--

CREATE TABLE `warehouse_products_lot` (
  `relative` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to product table',
  `lot` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `generic` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N' COMMENT 'Lot generated by the system',
  `initial_quantity` decimal(10,5) NOT NULL,
  `quantity` decimal(10,5) NOT NULL,
  `measurement_id` smallint NOT NULL COMMENT 'Related to catalogs items = MEASUREMENT',
  `brand_id` smallint NOT NULL COMMENT 'Related to catalogs = BRAND',
  `supplier_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to supplier database, supplier vendors table UUID',
  `unit_cost` decimal(10,5) NOT NULL DEFAULT '0.00000',
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `expires` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'If the product expires',
  `expiration_date` date DEFAULT NULL COMMENT 'The expiration date',
  `status` enum('A','X') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_products_lot_adjustment`
--

CREATE TABLE `warehouse_products_lot_adjustment` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `lot_id` varchar(50) NOT NULL COMMENT 'Related to lot table',
  `previous_quantity` decimal(10,5) NOT NULL,
  `quantity` decimal(10,5) NOT NULL,
  `type` enum('I','E') NOT NULL DEFAULT 'I',
  `drops_id` smallint NOT NULL COMMENT 'Related to catalogs items = ''DROPS''',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_products_lot_kardex`
--

CREATE TABLE `warehouse_products_lot_kardex` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to products table',
  `lot_id` varchar(50) NOT NULL COMMENT 'Related to lot table',
  `iet` enum('I','E','T') NOT NULL DEFAULT 'I',
  `quantity` decimal(10,5) NOT NULL,
  `detail` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_products_metadata`
--

CREATE TABLE `warehouse_products_metadata` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `meta_title` varchar(200) NOT NULL,
  `meta_keywords` varchar(200) NOT NULL,
  `meta_description` text NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_products_stock`
--

CREATE TABLE `warehouse_products_stock` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `warehouse_id` smallint NOT NULL COMMENT 'Related to warehouse table',
  `product_id` varchar(50) NOT NULL COMMENT 'Related to product table',
  `quantity` decimal(10,5) NOT NULL,
  `measurement_id` smallint NOT NULL COMMENT 'Related to catalogs items = ''MEASUREMENT''',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_purchase_international`
--

CREATE TABLE `warehouse_purchase_international` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind` enum('DIM','DUI','FISVF') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'DIM=Declaracion de importacion de mercancias, DUI=Declaracion unica de importacion FISV=Factura internacional sin valor fiscal',
  `voucher_number` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `total_items` int DEFAULT NULL,
  `packages` int DEFAULT NULL,
  `weight` int DEFAULT NULL,
  `purchase_date` date NOT NULL,
  `total_cost` decimal(10,5) NOT NULL,
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `comments` text,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_purchase_local`
--

CREATE TABLE `warehouse_purchase_local` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users sid',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind` enum('FC','FL','O') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'FC=Factura computarizada C7, FL=Factura en linea, O=Otro documento',
  `voucher_number` varchar(50) NOT NULL,
  `purchase_date_time` datetime NOT NULL,
  `cuf` varchar(50) DEFAULT NULL,
  `invoice_nit` varchar(50) DEFAULT NULL,
  `autorization_code` varchar(50) DEFAULT NULL,
  `issue_deadline` date DEFAULT NULL,
  `control_code` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `total_cost` decimal(10,5) NOT NULL,
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_purchase_previous_inventory`
--

CREATE TABLE `warehouse_purchase_previous_inventory` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `following_number` varchar(50) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_purchase_production_order`
--

CREATE TABLE `warehouse_purchase_production_order` (
  `relative` varchar(50) NOT NULL COMMENT 'UUID data',
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `production_order_voucher` varchar(50) NOT NULL COMMENT 'Production order',
  `total_cost` decimal(10,5) NOT NULL,
  `currency_id` smallint NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Estructura de tabla para la tabla `warehouse_warehouse`
--

CREATE TABLE `warehouse_warehouse` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `kind_id` int NOT NULL COMMENT 'Related to catalogs items=TIPOALMACEN',
  `warehouse` varchar(200) NOT NULL,
  `warehouse_description` mediumtext,
  `warehouse_location` varchar(200) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Volcado de datos para la tabla `warehouse_warehouse`
--

INSERT INTO `warehouse_warehouse` (`id`, `users_sid`, `global_branch_office_id`, `kind_id`, `warehouse`, `warehouse_description`, `warehouse_location`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'Almacen general - A1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta).', 'Almacen La Paz - CV', 'A', '2022-05-04 09:13:56', '2022-06-30 19:05:53'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'Almacen de materias primas C1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta) desconocido usó una galería de textos y los mezcló de tal manera que logró hacer un libro de textos especimen.', 'Almacen La Paz - CV', 'A', '2022-05-04 09:33:17', '2022-06-30 19:06:49'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'Almacen B1', 'Lorem Ipsum es simplemente el texto de relleno de las imprentas y archivos de texto. Lorem Ipsum ha sido el texto de relleno estándar de las industrias desde el año 1500, cuando un impresor (N. del T. persona que se dedica a la imprenta).', 'Segundo galpon B1', 'A', '2022-06-30 19:05:43', '2022-06-30 19:05:43');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `warehouse_catalog_items`
--
ALTER TABLE `warehouse_catalog_items`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_configuration`
--
ALTER TABLE `warehouse_configuration`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `configuration.relative` (`relative`);

--
-- Indices de la tabla `warehouse_enterprise`
--
ALTER TABLE `warehouse_enterprise`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `sivir_enterprise.relative` (`relative`);

--
-- Indices de la tabla `warehouse_products`
--
ALTER TABLE `warehouse_products`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indices de la tabla `warehouse_products_assistant`
--
ALTER TABLE `warehouse_products_assistant`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_products_lot`
--
ALTER TABLE `warehouse_products_lot`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_lot.relative` (`relative`);

--
-- Indices de la tabla `warehouse_products_lot_adjustment`
--
ALTER TABLE `warehouse_products_lot_adjustment`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_products_lot_kardex`
--
ALTER TABLE `warehouse_products_lot_kardex`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_products_metadata`
--
ALTER TABLE `warehouse_products_metadata`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_products_stock`
--
ALTER TABLE `warehouse_products_stock`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `warehouse_purchase_international`
--
ALTER TABLE `warehouse_purchase_international`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_international.relative` (`relative`) USING BTREE;

--
-- Indices de la tabla `warehouse_purchase_local`
--
ALTER TABLE `warehouse_purchase_local`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_local.relative` (`relative`);

--
-- Indices de la tabla `warehouse_purchase_previous_inventory`
--
ALTER TABLE `warehouse_purchase_previous_inventory`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `warehouse_purchase_previous_inventory.relative` (`relative`) USING BTREE;

--
-- Indices de la tabla `warehouse_purchase_production_order`
--
ALTER TABLE `warehouse_purchase_production_order`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `relative` (`relative`);

--
-- Indices de la tabla `warehouse_warehouse`
--
ALTER TABLE `warehouse_warehouse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kind_id` (`kind_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `warehouse_catalog_items`
--
ALTER TABLE `warehouse_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT de la tabla `warehouse_products_assistant`
--
ALTER TABLE `warehouse_products_assistant`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `warehouse_products_lot_adjustment`
--
ALTER TABLE `warehouse_products_lot_adjustment`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `warehouse_products_lot_kardex`
--
ALTER TABLE `warehouse_products_lot_kardex`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `warehouse_products_metadata`
--
ALTER TABLE `warehouse_products_metadata`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `warehouse_products_stock`
--
ALTER TABLE `warehouse_products_stock`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `warehouse_warehouse`
--
ALTER TABLE `warehouse_warehouse`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

