-- Respaldo Nativo generado por Sistema CRM TS --
-- Base de datos: trydvnte_bameredith.com_core_sivir --
-- Conexión: mysql_sivir --
-- Fecha: 2026-08-24 01:01:53 --

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `sivir_order_sold`;
CREATE TABLE `sivir_order_sold` (
  `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 table',
  `provisional` varchar(50) DEFAULT NULL COMMENT ' The provisional uuid for the sale ',
  `order_id` bigint(20) DEFAULT NULL COMMENT 'related to sivir_order table',
  `product_id` varchar(50) NOT NULL COMMENT 'related to product table',
  `product_code` varchar(50) DEFAULT NULL,
  `product_fullname` text NOT NULL,
  `with_ingredients` varchar(250) DEFAULT NULL,
  `without_ingredients` varchar(250) DEFAULT NULL,
  `price` decimal(15,5) NOT NULL,
  `quantity` decimal(15,5) NOT NULL,
  `total_price` decimal(15,5) NOT NULL,
  `discount` decimal(15,5) DEFAULT 0.00000,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`relative`),
  UNIQUE KEY `sivir_products_price.relative` (`relative`),
  KEY `idx_sivir_order_sold_order` (`order_id`),
  KEY `idx_sivir_order_sold_branch_product` (`global_branch_office_id`,`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;