#
# TABLE STRUCTURE FOR: tec_adjustment_items
#

DROP TABLE IF EXISTS `tec_adjustment_items`;

CREATE TABLE `tec_adjustment_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adjustment_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(25,4) NOT NULL,
  `type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_adjustments
#

DROP TABLE IF EXISTS `tec_adjustments`;

CREATE TABLE `tec_adjustments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `reference` varchar(200) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `attachment` varchar(200) DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `created_by` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_categories
#

DROP TABLE IF EXISTS `tec_categories`;

CREATE TABLE `tec_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `name` varchar(55) NOT NULL,
  `image` varchar(100) DEFAULT 'no_image.png',
  `store_id` tinyint(1) NOT NULL DEFAULT 1,
  `default_store_cate` tinyint(1) NOT NULL,
  `discount` varchar(20) NOT NULL DEFAULT '0',
  `ingredient` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (1, '001', 'ភេសជ្ជៈក្ដៅ', 'no_image.png', 1, 0, '0', 0);
INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (2, '002', 'ភេសជ្ជៈត្រជាក់', 'no_image.png', 1, 0, '0', 0);
INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (3, '003', 'ភេសជ្ជៈក្រឡុក', 'no_image.png', 1, 0, '0', 0);
INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (4, '004', 'ភេសជ្ជៈស្មូតធី', 'no_image.png', 1, 0, '0', 0);
INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (5, '005', 'ភេសជ្ជៈតែ', 'no_image.png', 1, 0, '0', 0);
INSERT INTO `tec_categories` (`id`, `code`, `name`, `image`, `store_id`, `default_store_cate`, `discount`, `ingredient`) VALUES (6, '006', 'ភេសជ្ជៈពេញនិយម', 'no_image.png', 1, 0, '0', 0);


#
# TABLE STRUCTURE FOR: tec_combo_items
#

DROP TABLE IF EXISTS `tec_combo_items`;

CREATE TABLE `tec_combo_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `item_code` varchar(150) NOT NULL,
  `quantity` decimal(12,2) NOT NULL,
  `price` decimal(25,4) DEFAULT NULL,
  `cost` decimal(25,4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_customer_group
#

DROP TABLE IF EXISTS `tec_customer_group`;

CREATE TABLE `tec_customer_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_customers
#

DROP TABLE IF EXISTS `tec_customers`;

CREATE TABLE `tec_customers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `cf1` varchar(255) NOT NULL,
  `cf2` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `store_id` int(11) DEFAULT NULL,
  `hide` tinyint(1) NOT NULL,
  `discount` varchar(20) NOT NULL DEFAULT '0',
  `award_points` decimal(25,4) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_customers` (`id`, `name`, `cf1`, `cf2`, `phone`, `email`, `store_id`, `hide`, `discount`, `award_points`, `group_id`) VALUES (1, 'ទូទៅ', '', '', '', '', NULL, 0, '0', NULL, NULL);


#
# TABLE STRUCTURE FOR: tec_expense_type
#

DROP TABLE IF EXISTS `tec_expense_type`;

CREATE TABLE `tec_expense_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_expenses
#

DROP TABLE IF EXISTS `tec_expenses`;

CREATE TABLE `tec_expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `reference` varchar(50) NOT NULL,
  `amount` decimal(25,4) NOT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `created_by` varchar(55) NOT NULL,
  `attachment` varchar(55) DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `type` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_gift_cards
#

DROP TABLE IF EXISTS `tec_gift_cards`;

CREATE TABLE `tec_gift_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `card_no` varchar(20) NOT NULL,
  `value` decimal(25,4) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `balance` decimal(25,4) NOT NULL,
  `expiry` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_no` (`card_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_groups
#

DROP TABLE IF EXISTS `tec_groups`;

CREATE TABLE `tec_groups` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (1, 'admin', 'Administrator');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (2, 'staff', 'Cashier');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (3, 'stock', 'Stock');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (4, 'manager', 'Manager');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (5, 'print', 'Print Only');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (6, 'salereport', 'View Sales Report');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (7, 'allreports', 'View All Reports');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (8, 'order', 'Order');
INSERT INTO `tec_groups` (`id`, `name`, `description`) VALUES (9, 'supervisor', 'Supervisor');


#
# TABLE STRUCTURE FOR: tec_login_attempts
#

DROP TABLE IF EXISTS `tec_login_attempts`;

CREATE TABLE `tec_login_attempts` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varbinary(16) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_payments
#

DROP TABLE IF EXISTS `tec_payments`;

CREATE TABLE `tec_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` timestamp NULL DEFAULT current_timestamp(),
  `sale_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `transaction_id` varchar(50) DEFAULT NULL,
  `paid_by` varchar(20) NOT NULL,
  `cheque_no` varchar(20) DEFAULT NULL,
  `cc_no` varchar(20) DEFAULT NULL,
  `cc_holder` varchar(25) DEFAULT NULL,
  `cc_month` varchar(2) DEFAULT NULL,
  `cc_year` varchar(4) DEFAULT NULL,
  `cc_type` varchar(20) DEFAULT NULL,
  `amount` decimal(25,4) NOT NULL,
  `currency` varchar(3) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `attachment` varchar(55) DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `pos_paid` decimal(25,4) DEFAULT 0.0000,
  `pos_balance` decimal(25,4) DEFAULT 0.0000,
  `gc_no` varchar(20) DEFAULT NULL,
  `reference` varchar(50) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `pos_paid_main` decimal(25,4) DEFAULT 0.0000,
  `pos_paid_exc` decimal(25,4) DEFAULT 0.0000,
  `pos_paid_exc2` decimal(25,4) DEFAULT 0.0000,
  `next_payment` date DEFAULT NULL,
  `alert_payment_day` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_printers
#

DROP TABLE IF EXISTS `tec_printers`;

CREATE TABLE `tec_printers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `type` varchar(25) NOT NULL,
  `profile` varchar(25) NOT NULL,
  `char_per_line` tinyint(3) unsigned DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `ip_address` varbinary(45) DEFAULT NULL,
  `port` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_product_options
#

DROP TABLE IF EXISTS `tec_product_options`;

CREATE TABLE `tec_product_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `additional_price` decimal(25,4) DEFAULT 0.0000,
  `additional_price_wholesale` decimal(25,4) DEFAULT 0.0000,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_product_options_group
#

DROP TABLE IF EXISTS `tec_product_options_group`;

CREATE TABLE `tec_product_options_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_product_store_qty
#

DROP TABLE IF EXISTS `tec_product_store_qty`;

CREATE TABLE `tec_product_store_qty` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL DEFAULT 0.00,
  `price` decimal(25,4) DEFAULT NULL,
  `price_wholesale` decimal(25,4) DEFAULT 0.0000,
  `price_vip` decimal(25,4) DEFAULT 0.0000,
  `unit_id` int(11) DEFAULT NULL,
  `sold_qty` decimal(10,4) NOT NULL DEFAULT 0.0000
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 1, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 2, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 3, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 4, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 5, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 6, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 7, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 8, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 9, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 10, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 11, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 12, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 13, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 14, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 15, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 16, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 17, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 18, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 19, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 20, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 21, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 22, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 23, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 24, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 25, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 26, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 27, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 28, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 29, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 30, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 31, 1, '0.00', '5000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 32, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 33, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 34, 1, '0.00', '4000.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 35, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 36, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 37, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 38, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 39, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 40, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 41, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 42, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 43, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 44, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 45, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');
INSERT INTO `tec_product_store_qty` (`id`, `product_id`, `store_id`, `quantity`, `price`, `price_wholesale`, `price_vip`, `unit_id`, `sold_qty`) VALUES (0, 46, 1, '0.00', '4500.0000', '0.0000', '0.0000', NULL, '0.0000');


#
# TABLE STRUCTURE FOR: tec_products
#

DROP TABLE IF EXISTS `tec_products`;

CREATE TABLE `tec_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(150) NOT NULL,
  `name` char(255) NOT NULL,
  `second_name` varchar(255) DEFAULT NULL,
  `category_id` int(11) NOT NULL DEFAULT 1,
  `price` decimal(25,4) NOT NULL,
  `price_wholesale` decimal(25,4) DEFAULT 0.0000,
  `price_vip` decimal(25,4) DEFAULT 0.0000,
  `image` varchar(255) DEFAULT 'no_image.png',
  `tax` varchar(20) DEFAULT NULL,
  `cost` decimal(25,4) DEFAULT NULL,
  `tax_method` tinyint(1) DEFAULT 1,
  `quantity` decimal(15,2) DEFAULT 0.00,
  `barcode_symbology` varchar(20) NOT NULL DEFAULT 'code128',
  `type` varchar(20) NOT NULL DEFAULT 'standard',
  `details` text DEFAULT NULL,
  `alert_quantity` decimal(25,4) DEFAULT 0.0000,
  `unit_id` int(11) DEFAULT NULL,
  `alert_expiry` decimal(25,4) DEFAULT 0.0000,
  `expiry_date` date DEFAULT NULL,
  `beverage` tinyint(1) DEFAULT 0,
  `ingredient` tinyint(1) DEFAULT 0,
  `service_month` int(11) DEFAULT 0,
  `alert_service` int(11) DEFAULT 0,
  `promotion` tinyint(4) DEFAULT 0,
  `promo_price` decimal(25,4) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `divided1` int(11) DEFAULT NULL,
  `divided2` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (1, '000001', 'អេចប្រសសូ (Espresso)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (2, '000002', 'អាមេរិចកាណូ (Americano)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (3, '000003', 'កាហ្វេសូកូឡាក្ដៅ (Hot Mocha)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (4, '000004', 'ឡាតេតែបៃតងក្ដៅ (Green Tea Latte)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (5, '000005', 'កាហ្វេទឹកដោះគោខាប់ (Condensed Milk Coffee)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (6, '000006', 'កាហ្វេខារ៉ាមែលឡាតេ (Caramel Latte)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (7, '000007', 'កាហ្វេឡាតេ (Hot Latte)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (8, '000008', 'កាហ្វេទឹកដោះគោក្ដៅ (Hot Cappucino)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (9, '000009', 'សូកូឡាទឺកដោះគោក្ដៅ (Hot Chocolate)', '', 1, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (10, '000010', 'កាហ្វេខ្មៅទឹកកក (Iced Americano)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (11, '000011', 'កាហ្វេទឹកដោះគោទឺកកក (Iced Latte)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (12, '000012', 'ម៉ូកាទឹកកក (Iced Mocha)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (13, '000013', 'សូកូឡាទឹកកក (Iced Chocolate)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (14, '000014', 'កាហ្វេទឺកដោះគោខាប់ (Iced Condensed Milk Coffee)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (15, '000015', 'តែបៃតងឡាតេទឹកកក (Iced Green Tea Latte)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (16, '000016', 'ខារ៉ាមែលទឺកកក (Iced Caramel)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (17, '000017', 'ឡាតេវ៉ានីឡាទឹកកក (Iced Vanilla)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (18, '000018', 'ឡាតេខារ៉ាមែលទឺកកក (Iced Caramel Latte)', '', 2, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (19, '000019', 'កាហ្វេក្រឡុក (Latte Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (20, '000020', 'តែបៃតងក្រឡុក (Green Tea Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (21, '000021', 'ខារ៉ាមែលក្រឡុក (Caramel Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (22, '000022', 'សូកូឡាក្រឡុក (Chocolate Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (23, '000023', 'ម៉ូកាក្រឡុក (Mocha Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (24, '000024', 'ប្លូប៊ែរីក្រឡុក (Blueberry Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (25, '000025', 'ផ្លែស្វាយក្រឡុក (Mango Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (26, '000026', 'ស្រប៊ឺរីក្រឡុក (Strawberry Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (27, '000027', 'ផាសិនក្រឡុក (Passion Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (28, '000028', 'វ៉ាន់នីឡាក្រឡុក (Vanilla Frappe)', '', 3, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (29, '000029', 'ស្រប៊ឺរីស្មូធី (Strawberry Smoothie)', '', 4, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (30, '000030', 'ប្លូប៊ែរីស្មូធី (Blueberry Smoothie)', '', 4, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (31, '000031', 'ផាសិនស្មូតធី (Passion Smoothie)', '', 4, '5000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (32, '000032', 'តែក្រហមក្រូចឆ្មាទឹកកក (Iced Red Tea Lemonade)', '', 5, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (33, '000033', 'តែបៃតងក្រូចឆ្មាផាសិនទឹកកក (Iced Lemonade Passion)', '', 5, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (34, '000034', 'តែបៃតងក្រូចឆ្មាទឹកកក (Iced Passion Lemonade)', '', 5, '4000.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (35, '000035', 'កាហ្វេទឹកដោះគោដូងក្រអូប (Coconut Latte)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (36, '000036', 'សូកូឡាទឺកដោះគោដូងក្រអូប (Chocolate With Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (37, '000037', 'តែក្រហមទឹកដោះគោដូងក្រអូប (Red Tea Latte with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (38, '000038', 'កាហ្វេទឹកដោះគោតែបៃតងដូងក្រអូប (Coffee Green Tea Latte with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (39, '000039', 'តែមេអំបៅទឹកដោះគោតែបៃតងដូងក្រអូប (Butterfly Pea Green Tea with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (40, '000040', 'តែមេអំបៅទឹកដោះគោដូងក្រអូប (Butterfly Pea Latte with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (41, '000041', 'សូកូឡាតែបៃតងទឹកដោះគោដូងក្រអូប (Chocolate Green Tea Latte with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (42, '000042', 'តែមេអំបៅក្រូចឆ្មា (Butterfly Pea Lemonade Tea)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (43, '000043', 'ស្រប៊ឺរីសូដា (Strawberry Soda)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (44, '000044', 'ផាសិនសូដា (Passion Soda)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (45, '000045', 'តែដំឡូងស្វាយទឹកដោះគោ (Sweet Purple Potato Latte)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);
INSERT INTO `tec_products` (`id`, `code`, `name`, `second_name`, `category_id`, `price`, `price_wholesale`, `price_vip`, `image`, `tax`, `cost`, `tax_method`, `quantity`, `barcode_symbology`, `type`, `details`, `alert_quantity`, `unit_id`, `alert_expiry`, `expiry_date`, `beverage`, `ingredient`, `service_month`, `alert_service`, `promotion`, `promo_price`, `start_date`, `end_date`, `divided1`, `divided2`) VALUES (46, '000046', 'តែមេអំបៅដំឡូងស្វាយទឹកដោះគោដូងក្រអូប (Butterfly Pea Sweet Potato Latte with Coconut)', '', 6, '4500.0000', '0.0000', '0.0000', 'no_image.png', '0', '0.0000', 0, '0.00', 'code128', 'standard', '', '0.0000', NULL, NULL, NULL, 0, 0, NULL, NULL, 0, '0.0000', '0000-00-00', '0000-00-00', NULL, NULL);


#
# TABLE STRUCTURE FOR: tec_purchase_items
#

DROP TABLE IF EXISTS `tec_purchase_items`;

CREATE TABLE `tec_purchase_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchase_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `cost` decimal(25,4) NOT NULL,
  `subtotal` decimal(25,4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_purchases
#

DROP TABLE IF EXISTS `tec_purchases`;

CREATE TABLE `tec_purchases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(55) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `note` varchar(1000) NOT NULL,
  `total` decimal(25,4) NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `received` tinyint(1) DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `discount` decimal(25,4) DEFAULT 0.0000,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_registers
#

DROP TABLE IF EXISTS `tec_registers`;

CREATE TABLE `tec_registers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `user_id` int(11) NOT NULL,
  `cash_in_hand` decimal(25,4) NOT NULL,
  `status` varchar(10) NOT NULL,
  `total_cash` decimal(25,4) DEFAULT NULL,
  `total_cheques` int(11) DEFAULT NULL,
  `total_cc_slips` int(11) DEFAULT NULL,
  `total_cash_submitted` decimal(25,4) DEFAULT NULL,
  `total_cheques_submitted` int(11) DEFAULT NULL,
  `total_cc_slips_submitted` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `closed_at` timestamp NULL DEFAULT NULL,
  `transfer_opened_bills` varchar(50) DEFAULT NULL,
  `closed_by` int(11) DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `cash_sales` decimal(25,4) DEFAULT 0.0000,
  `ch_sales` decimal(25,4) DEFAULT 0.0000,
  `cc_sales` decimal(25,4) DEFAULT 0.0000,
  `gc_sales` decimal(25,4) DEFAULT 0.0000,
  `other_sales` decimal(25,4) DEFAULT 0.0000,
  `total_sales` decimal(25,4) DEFAULT 0.0000,
  `nbr_sales` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total_cash_1` decimal(25,4) DEFAULT NULL,
  `total_cash_2` decimal(25,4) DEFAULT NULL,
  `total_cash_3` decimal(25,4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_sale_items
#

DROP TABLE IF EXISTS `tec_sale_items`;

CREATE TABLE `tec_sale_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(25,4) NOT NULL,
  `net_unit_price` decimal(25,4) NOT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `item_discount` decimal(25,4) DEFAULT NULL,
  `tax` int(20) DEFAULT NULL,
  `item_tax` decimal(25,4) DEFAULT NULL,
  `subtotal` decimal(25,4) NOT NULL,
  `real_unit_price` decimal(25,4) DEFAULT NULL,
  `cost` decimal(25,4) DEFAULT 0.0000,
  `product_code` varchar(150) DEFAULT NULL,
  `product_name` varchar(150) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `length` decimal(15,2) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `second_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_sales
#

DROP TABLE IF EXISTS `tec_sales`;

CREATE TABLE `tec_sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(55) NOT NULL,
  `total` decimal(25,4) NOT NULL,
  `product_discount` decimal(25,4) DEFAULT NULL,
  `order_discount_id` varchar(20) DEFAULT NULL,
  `order_discount` decimal(25,4) DEFAULT NULL,
  `total_discount` decimal(25,4) DEFAULT NULL,
  `product_tax` decimal(25,4) DEFAULT NULL,
  `order_tax_id` varchar(20) DEFAULT NULL,
  `order_tax` decimal(25,4) DEFAULT NULL,
  `total_tax` decimal(25,4) DEFAULT NULL,
  `grand_total` decimal(25,4) NOT NULL,
  `total_items` int(11) DEFAULT NULL,
  `total_quantity` decimal(15,2) DEFAULT NULL,
  `paid` decimal(25,4) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `rounding` decimal(25,4) DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `hold_ref` varchar(255) DEFAULT NULL,
  `date_in` datetime DEFAULT NULL,
  `date_out` datetime DEFAULT NULL,
  `waiting_number` int(11) NOT NULL,
  `total_cost` decimal(25,4) DEFAULT NULL,
  `delivery_by` varchar(255) DEFAULT NULL,
  `delivery_status` varchar(100) DEFAULT NULL,
  `delivery_note` varchar(255) DEFAULT NULL,
  `delivery_staff` varchar(255) DEFAULT NULL,
  `delivery_date` date DEFAULT NULL,
  `delivery_attachment` varchar(255) DEFAULT NULL,
  `next_payment` date DEFAULT NULL,
  `alert_payment_day` int(11) DEFAULT NULL,
  `inv_number` int(11) DEFAULT NULL,
  `sale_customer_group` int(11) DEFAULT NULL,
  `customer_group_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_sessions
#

DROP TABLE IF EXISTS `tec_sessions`;

CREATE TABLE `tec_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('01f68330222d18e26c10445b4e597f60a3d8a991', '91.231.89.101', 1773799684, '__ci_last_regenerate|i:1773799684;error|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('132db8c5c4f9448ccc72209c83e6b3d17e50ba5a', '119.13.157.135', 1773798130, '__ci_last_regenerate|i:1773798130;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('134fbd626e9e8a5e108d0aac0011ac469939a969', '91.231.89.99', 1773799947, '__ci_last_regenerate|i:1773799947;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('172dd552e820a59ff4ffdb45350bfde52966c3be', '64.15.129.126', 1773800096, '__ci_last_regenerate|i:1773800096;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('19a30c9cece36a2312ccc98e834ff3fbd329c460', '91.231.89.101', 1773798574, '__ci_last_regenerate|i:1773798574;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1cb3da77888e593728c5fc3df4ba06b37a0d1dfd', '103.196.9.120', 1773796890, '__ci_last_regenerate|i:1773796889;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2131695f886ecfbd7f6ec41197918e1a9fcd80e0', '192.175.111.237', 1773800095, '__ci_last_regenerate|i:1773800095;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2735272ecfb6a58e4b0833cfea7726c452b60baf', '64.15.129.125', 1773800102, '__ci_last_regenerate|i:1773800102;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('29472e33849ef942dcaff774a7c170bf0aadaeb8', '104.197.69.115', 1773796798, '__ci_last_regenerate|i:1773796798;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2c601e2c2b987262b5d30ce9509a75c8afbb4864', '91.231.89.124', 1773800955, '__ci_last_regenerate|i:1773800955;error|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('327bcac7b2d4bff9e4ddbf0432bd71875a95de0c', '64.15.129.124', 1773800105, '__ci_last_regenerate|i:1773800105;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('35d4cb1644bdafc5302c23ab6ddafc075dba03ad', '192.175.111.238', 1773800100, '__ci_last_regenerate|i:1773800100;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('369f7ecff5d2dedc76e8a50aa88596e6f9e85b07', '119.13.157.135', 1773797093, '__ci_last_regenerate|i:1773797093;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('387c25d6dae0412fcf71608449c2486d364ca782', '64.15.129.107', 1773800099, '__ci_last_regenerate|i:1773800099;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3bda1d1003e7ce5a59cad287470bf75b26b3f4ea', '91.231.89.33', 1773800824, '__ci_last_regenerate|i:1773800823;error|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3d8e864f74a9943ea0aa9d5bebdc822529d041ff', '91.231.89.37', 1773799196, '__ci_last_regenerate|i:1773799196;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3e79da65fba2d62e75db3ccbca60dd0c19f69b60', '91.231.89.125', 1773800492, '__ci_last_regenerate|i:1773800492;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4cc978029516b3367f3383dc7e36a54911497d57', '91.231.89.127', 1773800824, '__ci_last_regenerate|i:1773800824;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('658f95326f472b303a9de3874fe8c88cdcffba57', '91.231.89.102', 1773800162, '__ci_last_regenerate|i:1773800162;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6814bc123b779d18b9320405faab9dd56969d76d', '192.175.111.237', 1773800095, '__ci_last_regenerate|i:1773800095;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6b22ab91f062ce0581b0226f5eaf53a66c98189c', '192.175.111.254', 1773800101, '__ci_last_regenerate|i:1773800101;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('71d567680a70a741c50883a3d0fcb4ebe27cf167', '91.231.89.102', 1773801319, '__ci_last_regenerate|i:1773801319;error|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7a540b27e1cf189ff56d024b3e88fe999a4aefa3', '91.231.89.99', 1773799920, '__ci_last_regenerate|i:1773799920;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7ec447dcb0ad55df29eb7c94c2c175c675c4ec43', '64.15.129.124', 1773800105, '__ci_last_regenerate|i:1773800105;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('86c02f47ed69dc74754736db75826e23830fed3a', '180.149.18.191', 1773796892, '__ci_last_regenerate|i:1773796892;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('87389642f8db62a9df7ccc19257a3eee1b2dbccb', '119.13.157.135', 1773797420, '__ci_last_regenerate|i:1773797420;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8d638a723dd3a9aa4818a44d1aeb10d03536fa54', '64.15.129.114', 1773800103, '__ci_last_regenerate|i:1773800103;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8ee7f165f5c5ad4c9f5b12d68ad4e7ada73984f0', '119.13.157.135', 1773799669, '__ci_last_regenerate|i:1773799669;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8f5127cb82da4ed18387c200b8440e5759164db3', '119.13.157.135', 1773801058, '__ci_last_regenerate|i:1773801058;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('91ffb58617b6ce15184285af4104c63b9028f496', '172.111.15.81', 1773797339, '__ci_last_regenerate|i:1773797339;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('92d58994a63aa1192cbd100c0fd58940606c0e7e', '172.111.15.2', 1773797342, '__ci_last_regenerate|i:1773797340;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9487a00e91b40ea9af8cc536f1d88f757d86e091', '64.15.129.107', 1773800099, '__ci_last_regenerate|i:1773800099;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('979b84b530d8bd9c7ab24e3c671fa03e58c73e82', '119.13.157.135', 1773796785, '__ci_last_regenerate|i:1773796785;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9b82598cff6aef9ef26e2adfce3d6ccfc34c1bc0', '91.231.89.122', 1773801262, '__ci_last_regenerate|i:1773801262;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9dddc4445bfe864521b4b0b2450ffe76128a63cd', '35.204.90.168', 1773800359, '__ci_last_regenerate|i:1773800359;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9ea800d894e5cf172892977e28fe60621051b660', '223.178.212.147', 1773797050, '__ci_last_regenerate|i:1773797050;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a1279bf85de1ff0333fb318b0ba83b9d43e239a3', '192.175.111.238', 1773800100, '__ci_last_regenerate|i:1773800100;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a30c2259aab78e8c2854f12d3099870f54ee8af0', '64.15.129.125', 1773800101, '__ci_last_regenerate|i:1773800101;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a3aebe55f5b2a1c0e784e6194c60e5f58c4ad17f', '119.13.157.135', 1773797799, '__ci_last_regenerate|i:1773797799;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a45778660826e0aee7763d36e0c20291ea495ea8', '119.13.157.135', 1773802123, '__ci_last_regenerate|i:1773802118;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;messgae|s:93:\"ទិន្នន័យត្រូវបានលប់ចេញដោយជោគជ័យ\";__ci_vars|a:1:{s:7:\"messgae\";s:3:\"old\";}');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a8375dd2aa50d41df741daf882bd79115c38d0ae', '192.175.111.254', 1773800100, '__ci_last_regenerate|i:1773800100;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a87c4a843ee55f4766a3788349b9d232cbf809ba', '192.175.111.254', 1773800106, '__ci_last_regenerate|i:1773800106;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ac42f2d9e618ae7f3a256472f0ad0ebce9c96e38', '119.13.157.135', 1773799973, '__ci_last_regenerate|i:1773799973;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b6d228360ec82162be56abffc52915e326f2b302', '103.196.9.56', 1773796890, '__ci_last_regenerate|i:1773796889;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b92e5be225db4ac3a4a3ba50d51a692da9103729', '91.231.89.37', 1773800365, '__ci_last_regenerate|i:1773800365;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b98a5d37405931bdb3286f52cbf37143f498a9b0', '77.81.142.215', 1773799247, '__ci_last_regenerate|i:1773799247;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bbc6870b8b1d9c35fef85677f1892da237438d56', '91.231.89.32', 1773800901, '__ci_last_regenerate|i:1773800901;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bd5128b0518fe436c9e8d1f854e1d3013fdc282e', '64.15.129.126', 1773800096, '__ci_last_regenerate|i:1773800096;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c7a7facb41b256a344fa2953dd4d9b951a7f54fa', '46.232.209.1', 1773796892, '__ci_last_regenerate|i:1773796892;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c7da02adb31251ecc85541a38ec0db565596c4a7', '64.15.129.126', 1773800106, '__ci_last_regenerate|i:1773800106;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cc25d01e9b2ae0478b633f187bc8356fa56b89e1', '216.73.216.60', 1773801898, '__ci_last_regenerate|i:1773801898;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d6ae6d6b5fc018cd29a1234325986c210e79f672', '119.13.157.135', 1773802118, '__ci_last_regenerate|i:1773802118;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('dd17d9d19774880b22c14f060e4856fa55238d98', '64.15.129.114', 1773800102, '__ci_last_regenerate|i:1773800102;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e269b4df121751e70f33e6370be96576ad52e66b', '119.13.157.135', 1773799353, '__ci_last_regenerate|i:1773799353;identity|s:5:\"admin\";username|s:5:\"admin\";email|s:5:\"admin\";user_id|s:1:\"1\";first_name|s:5:\"Super\";last_name|s:5:\"Admin\";created_on|s:24:\"Thu 25 Jun 2015 10:59 AM\";old_last_login|s:10:\"1687149262\";last_ip|s:3:\"::1\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e9edbccb7c71d438debb01f995a688517d16f5e7', '94.139.230.114', 1773797338, '__ci_last_regenerate|i:1773797337;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('eb82bc640a77b46f132c19e5e9cdd43644e0c75e', '223.178.212.147', 1773797054, '__ci_last_regenerate|i:1773797054;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ee616d288a1d7e5269e0199b4957ede5737a39a4', '34.91.229.116', 1773800359, '__ci_last_regenerate|i:1773800359;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f09bd28f819ec298066013b8d07a6be59ce833a8', '192.175.111.254', 1773800106, '__ci_last_regenerate|i:1773800106;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f2f877204fb372c825a47f76510a45172b2a01e9', '223.178.212.147', 1773797050, '__ci_last_regenerate|i:1773797050;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('fc7dedead78381c7a768ad6d597afbe78d53a00c', '223.178.212.147', 1773797054, '__ci_last_regenerate|i:1773797053;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ff927e7c725d6989cd962f66c7db45b6817cc5ab', '64.15.129.126', 1773800107, '__ci_last_regenerate|i:1773800107;');


#
# TABLE STRUCTURE FOR: tec_settings
#

DROP TABLE IF EXISTS `tec_settings`;

CREATE TABLE `tec_settings` (
  `setting_id` int(1) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `site_name` varchar(55) NOT NULL,
  `tel` varchar(20) NOT NULL,
  `dateformat` varchar(25) DEFAULT NULL,
  `timeformat` varchar(20) DEFAULT NULL,
  `default_email` varchar(100) NOT NULL,
  `language` varchar(20) NOT NULL,
  `version` varchar(10) NOT NULL DEFAULT '1.0',
  `theme` varchar(20) NOT NULL,
  `timezone` varchar(255) NOT NULL DEFAULT '0',
  `protocol` varchar(20) NOT NULL DEFAULT 'mail',
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_user` varchar(100) DEFAULT NULL,
  `smtp_pass` varchar(255) DEFAULT NULL,
  `smtp_port` varchar(10) DEFAULT '25',
  `smtp_crypto` varchar(5) DEFAULT NULL,
  `mmode` tinyint(1) NOT NULL,
  `captcha` tinyint(1) NOT NULL DEFAULT 1,
  `mailpath` varchar(55) DEFAULT NULL,
  `currency_prefix` varchar(3) NOT NULL,
  `default_customer` int(11) NOT NULL,
  `default_tax_rate` varchar(20) NOT NULL,
  `rows_per_page` int(2) NOT NULL,
  `total_rows` int(2) NOT NULL,
  `header` varchar(1000) DEFAULT NULL,
  `footer` varchar(1000) DEFAULT NULL,
  `bsty` tinyint(4) NOT NULL,
  `display_kb` tinyint(4) NOT NULL,
  `default_category` int(11) NOT NULL,
  `default_discount` varchar(20) NOT NULL,
  `item_addition` tinyint(1) NOT NULL,
  `barcode_symbology` varchar(55) DEFAULT NULL,
  `pro_limit` tinyint(4) NOT NULL,
  `decimals` tinyint(1) NOT NULL DEFAULT 2,
  `thousands_sep` varchar(2) NOT NULL DEFAULT ',',
  `decimals_sep` varchar(2) NOT NULL DEFAULT '.',
  `focus_add_item` varchar(55) DEFAULT NULL,
  `add_customer` varchar(55) DEFAULT NULL,
  `toggle_category_slider` varchar(55) DEFAULT NULL,
  `cancel_sale` varchar(55) DEFAULT NULL,
  `suspend_sale` varchar(55) DEFAULT NULL,
  `print_order` varchar(55) DEFAULT NULL,
  `print_bill` varchar(55) DEFAULT NULL,
  `finalize_sale` varchar(55) DEFAULT NULL,
  `today_sale` varchar(55) DEFAULT NULL,
  `open_hold_bills` varchar(55) DEFAULT NULL,
  `close_register` varchar(55) DEFAULT NULL,
  `java_applet` tinyint(1) NOT NULL,
  `receipt_printer` varchar(55) DEFAULT NULL,
  `pos_printers` varchar(255) DEFAULT NULL,
  `cash_drawer_codes` varchar(55) DEFAULT NULL,
  `char_per_line` tinyint(4) DEFAULT 42,
  `rounding` tinyint(1) DEFAULT 0,
  `pin_code` varchar(20) DEFAULT NULL,
  `stripe` tinyint(1) DEFAULT NULL,
  `stripe_secret_key` varchar(100) DEFAULT NULL,
  `stripe_publishable_key` varchar(100) DEFAULT NULL,
  `purchase_code` varchar(100) DEFAULT NULL,
  `envato_username` varchar(50) DEFAULT NULL,
  `theme_style` varchar(25) DEFAULT 'green',
  `after_sale_page` tinyint(1) DEFAULT NULL,
  `overselling` tinyint(1) DEFAULT 1,
  `multi_store` tinyint(1) DEFAULT NULL,
  `qty_decimals` tinyint(1) DEFAULT 2,
  `symbol` varchar(55) DEFAULT NULL,
  `sac` tinyint(1) DEFAULT 0,
  `display_symbol` tinyint(1) DEFAULT NULL,
  `remote_printing` tinyint(1) DEFAULT 1,
  `printer` int(11) DEFAULT NULL,
  `order_printers` varchar(55) DEFAULT NULL,
  `auto_print` tinyint(1) DEFAULT 0,
  `local_printers` tinyint(1) DEFAULT NULL,
  `rtl` tinyint(1) DEFAULT NULL,
  `print_img` tinyint(1) DEFAULT NULL,
  `exchange_rate` decimal(10,2) NOT NULL,
  `exchange_rate2` decimal(10,2) NOT NULL,
  `exchange_rate_symbol` varchar(10) DEFAULT NULL,
  `exchange_rate_multiply` varchar(1) DEFAULT NULL,
  `exchange_rate2_symbol` varchar(10) DEFAULT NULL,
  `exchange_rate2_multiply` varchar(1) DEFAULT NULL,
  `show_wholesale` tinyint(1) NOT NULL,
  `hold_customer` tinyint(1) NOT NULL,
  `label_fontsize` tinyint(1) NOT NULL,
  `label_width` tinyint(1) NOT NULL,
  `label_height` tinyint(1) NOT NULL,
  `show_itemdiscount` tinyint(1) NOT NULL,
  `show_exc_paid` tinyint(1) NOT NULL DEFAULT 1,
  `show_refbarcode` tinyint(1) NOT NULL,
  `show_date_inout` tinyint(1) NOT NULL,
  `waiting_number` int(11) NOT NULL,
  `show_waiting_number` tinyint(1) NOT NULL,
  `multistore_quantity` tinyint(1) NOT NULL,
  `customer_as_holdref` tinyint(1) NOT NULL,
  `show_changedecimal` tinyint(1) NOT NULL,
  `show_inclusive_tax` tinyint(1) NOT NULL,
  `multistore_product` tinyint(1) NOT NULL,
  `show_icesugar` tinyint(1) NOT NULL,
  `auto_print_order` tinyint(1) NOT NULL,
  `print_order_label` tinyint(1) NOT NULL,
  `receipt_font_size` tinyint(1) NOT NULL,
  `print_customer_label` tinyint(1) NOT NULL,
  `show_unit` tinyint(1) NOT NULL,
  `show_expiry` tinyint(1) NOT NULL,
  `staff_change_pos_price` tinyint(1) NOT NULL,
  `staff_change_pos_discount` tinyint(1) NOT NULL,
  `show_product_service` tinyint(1) NOT NULL,
  `show_drink_ingredient` tinyint(1) NOT NULL DEFAULT 1,
  `pos_prodtype_filter` tinyint(4) NOT NULL DEFAULT 0,
  `show_delivery` tinyint(4) NOT NULL DEFAULT 0,
  `show_alert_payment` tinyint(4) NOT NULL DEFAULT 0,
  `show_orderbill` tinyint(4) DEFAULT 1,
  `telegram_notification` tinyint(4) DEFAULT 0,
  `receipt_format` tinyint(4) DEFAULT 0,
  `show_product_options` tinyint(4) NOT NULL DEFAULT 0,
  `product_second_name` tinyint(4) NOT NULL DEFAULT 0,
  `each_spent` decimal(25,4) DEFAULT NULL,
  `ca_point` decimal(25,4) DEFAULT NULL,
  `each_sale` decimal(25,4) DEFAULT NULL,
  `sa_point` decimal(25,4) DEFAULT NULL,
  `show_item_length` tinyint(1) NOT NULL DEFAULT 0,
  `ws_barcode_type` varchar(40) DEFAULT 'weight',
  `ws_barcode_chars` int(11) DEFAULT NULL,
  `flag_chars` int(11) DEFAULT NULL,
  `item_code_start` int(11) DEFAULT NULL,
  `item_code_chars` int(11) DEFAULT NULL,
  `price_start` int(11) DEFAULT NULL,
  `price_chars` int(11) DEFAULT NULL,
  `price_divide_by` int(11) DEFAULT NULL,
  `weight_start` int(11) DEFAULT NULL,
  `weight_chars` int(11) DEFAULT NULL,
  `weight_divide_by` int(11) DEFAULT NULL,
  `show_previous_due` tinyint(4) NOT NULL DEFAULT 0,
  `pos_printer_margin` tinyint(4) NOT NULL DEFAULT 0,
  `show_customer_group` tinyint(4) DEFAULT 0,
  `telegram_chat_id` varchar(250) DEFAULT NULL,
  `continue_inv_number` tinyint(4) DEFAULT 0,
  `update_cost` tinyint(4) DEFAULT 0,
  `divided` tinyint(4) NOT NULL DEFAULT 0,
  `show_imagea4` tinyint(1) NOT NULL,
  `show_labelprice` tinyint(1) NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_settings` (`setting_id`, `logo`, `site_name`, `tel`, `dateformat`, `timeformat`, `default_email`, `language`, `version`, `theme`, `timezone`, `protocol`, `smtp_host`, `smtp_user`, `smtp_pass`, `smtp_port`, `smtp_crypto`, `mmode`, `captcha`, `mailpath`, `currency_prefix`, `default_customer`, `default_tax_rate`, `rows_per_page`, `total_rows`, `header`, `footer`, `bsty`, `display_kb`, `default_category`, `default_discount`, `item_addition`, `barcode_symbology`, `pro_limit`, `decimals`, `thousands_sep`, `decimals_sep`, `focus_add_item`, `add_customer`, `toggle_category_slider`, `cancel_sale`, `suspend_sale`, `print_order`, `print_bill`, `finalize_sale`, `today_sale`, `open_hold_bills`, `close_register`, `java_applet`, `receipt_printer`, `pos_printers`, `cash_drawer_codes`, `char_per_line`, `rounding`, `pin_code`, `stripe`, `stripe_secret_key`, `stripe_publishable_key`, `purchase_code`, `envato_username`, `theme_style`, `after_sale_page`, `overselling`, `multi_store`, `qty_decimals`, `symbol`, `sac`, `display_symbol`, `remote_printing`, `printer`, `order_printers`, `auto_print`, `local_printers`, `rtl`, `print_img`, `exchange_rate`, `exchange_rate2`, `exchange_rate_symbol`, `exchange_rate_multiply`, `exchange_rate2_symbol`, `exchange_rate2_multiply`, `show_wholesale`, `hold_customer`, `label_fontsize`, `label_width`, `label_height`, `show_itemdiscount`, `show_exc_paid`, `show_refbarcode`, `show_date_inout`, `waiting_number`, `show_waiting_number`, `multistore_quantity`, `customer_as_holdref`, `show_changedecimal`, `show_inclusive_tax`, `multistore_product`, `show_icesugar`, `auto_print_order`, `print_order_label`, `receipt_font_size`, `print_customer_label`, `show_unit`, `show_expiry`, `staff_change_pos_price`, `staff_change_pos_discount`, `show_product_service`, `show_drink_ingredient`, `pos_prodtype_filter`, `show_delivery`, `show_alert_payment`, `show_orderbill`, `telegram_notification`, `receipt_format`, `show_product_options`, `product_second_name`, `each_spent`, `ca_point`, `each_sale`, `sa_point`, `show_item_length`, `ws_barcode_type`, `ws_barcode_chars`, `flag_chars`, `item_code_start`, `item_code_chars`, `price_start`, `price_chars`, `price_divide_by`, `weight_start`, `weight_chars`, `weight_divide_by`, `show_previous_due`, `pos_printer_margin`, `show_customer_group`, `telegram_chat_id`, `continue_inv_number`, `update_cost`, `divided`, `show_imagea4`, `show_labelprice`) VALUES (1, 'Logo-Photoroom.png', 'Coffee 36', '093 889 567', 'D j M Y', 'h:i A', 'simplepos@gmail.com', 'english', '5.2.13', 'default', 'Asia/Kuala_Lumpur', 'mail', 'smtp.gmail.com', '', '', '587', '', 0, 0, NULL, 'USD', 1, '0', 25, 30, NULL, NULL, 3, 0, 0, '0', 1, NULL, 21, 0, ',', '.', 'ALT+F1', 'ALT+F2', 'ALT+F10', 'ALT+F5', 'ALT+F6', 'ALT+F11', 'ALT+F12', 'ALT+F8', 'Ctrl+F1', 'Ctrl+F2', 'ALT+F7', 0, '', '', '', 42, 0, NULL, 0, '123', '123', '65806230-5697-4f94-89f4-49275c3c19d8', 'sgr1875', 'blue', 0, 1, 0, 0, '៛', 0, 1, 1, NULL, 'null', 1, 0, 0, 0, '4000.00', '0.00', '$', '/', 'B', '*', 0, 0, 8, 40, 25, 0, 1, 0, 0, 43, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0.0000', '0.0000', '0.0000', '0.0000', 0, 'weight', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 1);


#
# TABLE STRUCTURE FOR: tec_stores
#

DROP TABLE IF EXISTS `tec_stores`;

CREATE TABLE `tec_stores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `code` varchar(20) NOT NULL,
  `logo` varchar(250) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `phone` varchar(250) NOT NULL,
  `address1` varchar(250) DEFAULT NULL,
  `address2` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `postal_code` varchar(250) DEFAULT NULL,
  `country` varchar(250) DEFAULT NULL,
  `currency_code` varchar(3) DEFAULT NULL,
  `receipt_header` text DEFAULT NULL,
  `receipt_footer` text DEFAULT NULL,
  `promotion_photo` varchar(250) DEFAULT NULL,
  `inv_number` int(11) NOT NULL DEFAULT 0,
  `aba_qrstring` varchar(250) DEFAULT NULL,
  `acleda_qrstring` varchar(250) DEFAULT NULL,
  `telegram_chat_id` varchar(250) DEFAULT NULL,
  `show_header` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_stores` (`id`, `name`, `code`, `logo`, `email`, `phone`, `address1`, `address2`, `city`, `state`, `postal_code`, `country`, `currency_code`, `receipt_header`, `receipt_footer`, `promotion_photo`, `inv_number`, `aba_qrstring`, `acleda_qrstring`, `telegram_chat_id`, `show_header`) VALUES (1, 'COFFEE 36', 'POS', '', 'store@gmail.com', '088 61 666 86 / 076 61 666 86', 'ភូមិអូឈើក្រំ ឃុំស្ទឹងកាច់ ស្រុកសាលាក្រៅ', 'ខេត្តប៉ៃលិន', '', '', '', '', 'USD', '', 'Thank you! have a nice day.', '', 0, '', '', NULL, 0);


#
# TABLE STRUCTURE FOR: tec_suppliers
#

DROP TABLE IF EXISTS `tec_suppliers`;

CREATE TABLE `tec_suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) NOT NULL,
  `cf1` varchar(255) NOT NULL,
  `cf2` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_suspended_items
#

DROP TABLE IF EXISTS `tec_suspended_items`;

CREATE TABLE `tec_suspended_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `suspend_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` decimal(15,2) NOT NULL,
  `unit_price` decimal(25,4) NOT NULL,
  `net_unit_price` decimal(25,4) NOT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `item_discount` decimal(25,4) DEFAULT NULL,
  `tax` int(20) DEFAULT NULL,
  `item_tax` decimal(25,4) DEFAULT NULL,
  `subtotal` decimal(25,4) NOT NULL,
  `real_unit_price` decimal(25,4) DEFAULT NULL,
  `product_code` varchar(150) DEFAULT NULL,
  `product_name` varchar(250) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `next_service_date` date DEFAULT NULL,
  `length` decimal(15,2) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `second_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_suspended_sales
#

DROP TABLE IF EXISTS `tec_suspended_sales`;

CREATE TABLE `tec_suspended_sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_name` varchar(55) NOT NULL,
  `total` decimal(25,4) NOT NULL,
  `product_discount` decimal(25,4) DEFAULT NULL,
  `order_discount_id` varchar(20) DEFAULT NULL,
  `order_discount` decimal(25,4) DEFAULT NULL,
  `total_discount` decimal(25,4) DEFAULT NULL,
  `product_tax` decimal(25,4) DEFAULT NULL,
  `order_tax_id` varchar(20) DEFAULT NULL,
  `order_tax` decimal(25,4) DEFAULT NULL,
  `total_tax` decimal(25,4) DEFAULT NULL,
  `grand_total` decimal(25,4) NOT NULL,
  `total_items` int(11) DEFAULT NULL,
  `total_quantity` decimal(15,2) DEFAULT NULL,
  `paid` decimal(25,4) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `note` varchar(1000) DEFAULT NULL,
  `hold_ref` varchar(255) DEFAULT NULL,
  `store_id` int(11) NOT NULL DEFAULT 1,
  `date_in` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_unit
#

DROP TABLE IF EXISTS `tec_unit`;

CREATE TABLE `tec_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

#
# TABLE STRUCTURE FOR: tec_user_logins
#

DROP TABLE IF EXISTS `tec_user_logins`;

CREATE TABLE `tec_user_logins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `company_id` int(11) DEFAULT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_user_logins` (`id`, `user_id`, `company_id`, `ip_address`, `login`, `time`) VALUES (1, 1, NULL, '119.13.157.135', 'Admin', '2026-03-18 08:14:31');


#
# TABLE STRUCTURE FOR: tec_users
#

DROP TABLE IF EXISTS `tec_users`;

CREATE TABLE `tec_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `last_ip_address` varbinary(45) DEFAULT NULL,
  `ip_address` varbinary(45) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(40) NOT NULL,
  `salt` varchar(40) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` int(11) unsigned NOT NULL,
  `last_login` int(11) unsigned DEFAULT NULL,
  `active` tinyint(1) unsigned DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `avatar` varchar(55) DEFAULT NULL,
  `gender` varchar(20) DEFAULT NULL,
  `group_id` int(11) unsigned NOT NULL DEFAULT 2,
  `store_id` int(11) DEFAULT NULL,
  `terminal_id` int(11) NOT NULL DEFAULT 1,
  `award_points` decimal(25,4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_users` (`id`, `last_ip_address`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`, `avatar`, `gender`, `group_id`, `store_id`, `terminal_id`, `award_points`) VALUES (1, '119.13.157.135', '127.0.0.1', 'admin', 'fe941d48eb1fbce34b4588ae500861570fb0e398', NULL, 'admin', NULL, NULL, NULL, 'b2d2c8fd5d9a5f19901279ac74cec92dc15ac970', 1435204774, 1773796471, 1, 'Super', 'Admin', 'Tecdiary', '012345678', NULL, 'male', 1, NULL, 1, NULL);
INSERT INTO `tec_users` (`id`, `last_ip_address`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`, `avatar`, `gender`, `group_id`, `store_id`, `terminal_id`, `award_points`) VALUES (2, '::1', '::1', 'sale1', '587684c629970094a433b1996ac7f796e08edc7f', NULL, '', NULL, NULL, NULL, 'ef248ac704a9cb7fc06f8e63033e7579e7843e3e', 1680852851, 1682563745, 1, 'Sale', 'Mr.', NULL, '', NULL, 'male', 2, 1, 1, '0.0000');


