#
# 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=3 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);
INSERT INTO `tec_customers` (`id`, `name`, `cf1`, `cf2`, `phone`, `email`, `store_id`, `hide`, `discount`, `award_points`, `group_id`) VALUES (2, 'bb', '', '', '', '', NULL, 0, '', NULL, 0);


#
# 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_payments` (`id`, `date`, `sale_id`, `customer_id`, `transaction_id`, `paid_by`, `cheque_no`, `cc_no`, `cc_holder`, `cc_month`, `cc_year`, `cc_type`, `amount`, `currency`, `created_by`, `attachment`, `note`, `pos_paid`, `pos_balance`, `gc_no`, `reference`, `updated_by`, `updated_at`, `store_id`, `pos_paid_main`, `pos_paid_exc`, `pos_paid_exc2`, `next_payment`, `alert_payment_day`) VALUES (1, '2026-04-21 10:37:34', 1, 1, NULL, 'ABA', '', '', '', '', '', '', '13500.0000', NULL, 1, NULL, '', '13500.0000', '0.0000', '', NULL, NULL, NULL, 1, '13500.0000', '0.0000', '0.0000', NULL, NULL);
INSERT INTO `tec_payments` (`id`, `date`, `sale_id`, `customer_id`, `transaction_id`, `paid_by`, `cheque_no`, `cc_no`, `cc_holder`, `cc_month`, `cc_year`, `cc_type`, `amount`, `currency`, `created_by`, `attachment`, `note`, `pos_paid`, `pos_balance`, `gc_no`, `reference`, `updated_by`, `updated_at`, `store_id`, `pos_paid_main`, `pos_paid_exc`, `pos_paid_exc2`, `next_payment`, `alert_payment_day`) VALUES (2, '2026-04-21 10:42:22', 2, 2, NULL, 'cash', '', '', '', '', '', 'Visa', '12000.0000', NULL, 1, NULL, '', '0.0000', '0.0000', '', '', NULL, NULL, 1, '0.0000', '0.0000', '0.0000', NULL, NULL);


#
# 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, '-1.00', '5000.0000', '0.0000', '0.0000', NULL, '1.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, '-1.00', '5000.0000', '0.0000', '0.0000', NULL, '1.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, '-1.00', '5000.0000', '0.0000', '0.0000', NULL, '1.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', '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, 5, 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, 6, 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, 7, 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, 8, 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, 9, 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, 10, 1, '-2.00', '6000.0000', '0.0000', '0.0000', NULL, '2.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, '-1.00', '6000.0000', '0.0000', '0.0000', NULL, '1.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6500.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6000.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', '6500.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', '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, 43, 1, '0.00', '6000.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', '6000.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', '6000.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', '6000.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, '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 (2, '000002', 'អាមេរិចកាណូ (Americano)', '', 1, '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 (3, '000003', 'កាហ្វេសូកូឡាក្ដៅ (Hot Mocha)', '', 1, '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 (4, '000004', 'ឡាតេតែបៃតងក្ដៅ (Green Tea Latte)', '', 1, '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 (5, '000005', 'កាហ្វេទឹកដោះគោខាប់ (Condensed Milk Coffee)', '', 1, '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 (6, '000006', 'កាហ្វេខារ៉ាមែលឡាតេ (Caramel Latte)', '', 1, '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 (7, '000007', 'កាហ្វេឡាតេ (Hot Latte)', '', 1, '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 (8, '000008', 'កាហ្វេទឹកដោះគោក្ដៅ (Hot Cappucino)', '', 1, '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 (9, '000009', 'សូកូឡាទឺកដោះគោក្ដៅ (Hot Chocolate)', '', 1, '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 (10, '000010', 'កាហ្វេខ្មៅទឹកកក (Iced Americano)', '', 2, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6500.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6000.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, '6500.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, '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 (43, '000043', 'ស្រប៊ឺរីសូដា (Strawberry Soda)', '', 6, '6000.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, '6000.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, '6000.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, '6000.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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_registers` (`id`, `date`, `user_id`, `cash_in_hand`, `status`, `total_cash`, `total_cheques`, `total_cc_slips`, `total_cash_submitted`, `total_cheques_submitted`, `total_cc_slips_submitted`, `note`, `closed_at`, `transfer_opened_bills`, `closed_by`, `store_id`, `cash_sales`, `ch_sales`, `cc_sales`, `gc_sales`, `other_sales`, `total_sales`, `nbr_sales`, `total_cash_1`, `total_cash_2`, `total_cash_3`) VALUES (1, '2026-04-21 10:36:16', 1, '50.0000', 'open', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', NULL, NULL, NULL);


#
# 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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `net_unit_price`, `discount`, `item_discount`, `tax`, `item_tax`, `subtotal`, `real_unit_price`, `cost`, `product_code`, `product_name`, `comment`, `next_service_date`, `length`, `image`, `second_name`) VALUES (1, 1, 11, '1.00', '4500.0000', '4500.0000', '0', '0.0000', 0, '0.0000', '4500.0000', '4500.0000', '0.0000', '000011', 'កាហ្វេទឹកដោះគោទឺកកក (Iced Latte)', '', NULL, NULL, 'no_image.png', '');
INSERT INTO `tec_sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `net_unit_price`, `discount`, `item_discount`, `tax`, `item_tax`, `subtotal`, `real_unit_price`, `cost`, `product_code`, `product_name`, `comment`, `next_service_date`, `length`, `image`, `second_name`) VALUES (2, 1, 10, '2.00', '4500.0000', '4500.0000', '0', '0.0000', 0, '0.0000', '9000.0000', '4500.0000', '0.0000', '000010', 'កាហ្វេខ្មៅទឹកកក (Iced Americano)', '', NULL, NULL, 'no_image.png', '');
INSERT INTO `tec_sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `net_unit_price`, `discount`, `item_discount`, `tax`, `item_tax`, `subtotal`, `real_unit_price`, `cost`, `product_code`, `product_name`, `comment`, `next_service_date`, `length`, `image`, `second_name`) VALUES (3, 2, 3, '1.00', '4000.0000', '4000.0000', '0', '0.0000', 0, '0.0000', '4000.0000', '4000.0000', '0.0000', '000003', 'កាហ្វេសូកូឡាក្ដៅ (Hot Mocha)', '', NULL, NULL, 'no_image.png', '');
INSERT INTO `tec_sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `net_unit_price`, `discount`, `item_discount`, `tax`, `item_tax`, `subtotal`, `real_unit_price`, `cost`, `product_code`, `product_name`, `comment`, `next_service_date`, `length`, `image`, `second_name`) VALUES (4, 2, 2, '1.00', '4000.0000', '4000.0000', '0', '0.0000', 0, '0.0000', '4000.0000', '4000.0000', '0.0000', '000002', 'អាមេរិចកាណូ (Americano)', '', NULL, NULL, 'no_image.png', '');
INSERT INTO `tec_sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `net_unit_price`, `discount`, `item_discount`, `tax`, `item_tax`, `subtotal`, `real_unit_price`, `cost`, `product_code`, `product_name`, `comment`, `next_service_date`, `length`, `image`, `second_name`) VALUES (5, 2, 1, '1.00', '4000.0000', '4000.0000', '0', '0.0000', 0, '0.0000', '4000.0000', '4000.0000', '0.0000', '000001', 'អេចប្រសសូ (Espresso)', '', NULL, NULL, 'no_image.png', '');


#
# 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `tec_sales` (`id`, `date`, `customer_id`, `customer_name`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `grand_total`, `total_items`, `total_quantity`, `paid`, `created_by`, `updated_by`, `updated_at`, `note`, `status`, `rounding`, `store_id`, `hold_ref`, `date_in`, `date_out`, `waiting_number`, `total_cost`, `delivery_by`, `delivery_status`, `delivery_note`, `delivery_staff`, `delivery_date`, `delivery_attachment`, `next_payment`, `alert_payment_day`, `inv_number`, `sale_customer_group`, `customer_group_name`) VALUES (1, '2026-04-21 10:37:34', 1, 'ទូទៅ', '13500.0000', '0.0000', NULL, '0.0000', '0.0000', '0.0000', NULL, '0.0000', '0.0000', '13500.0000', 2, '3.00', '13500.0000', 1, NULL, NULL, '', 'paid', '0.0000', 1, 'ទូទៅ', NULL, '2026-04-21 10:37:34', 44, '0.0000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL);
INSERT INTO `tec_sales` (`id`, `date`, `customer_id`, `customer_name`, `total`, `product_discount`, `order_discount_id`, `order_discount`, `total_discount`, `product_tax`, `order_tax_id`, `order_tax`, `total_tax`, `grand_total`, `total_items`, `total_quantity`, `paid`, `created_by`, `updated_by`, `updated_at`, `note`, `status`, `rounding`, `store_id`, `hold_ref`, `date_in`, `date_out`, `waiting_number`, `total_cost`, `delivery_by`, `delivery_status`, `delivery_note`, `delivery_staff`, `delivery_date`, `delivery_attachment`, `next_payment`, `alert_payment_day`, `inv_number`, `sale_customer_group`, `customer_group_name`) VALUES (2, '2026-04-21 10:41:46', 2, 'bb', '12000.0000', '0.0000', NULL, '0.0000', '0.0000', '0.0000', NULL, '0.0000', '0.0000', '12000.0000', 3, '3.00', '12000.0000', 1, NULL, NULL, '', 'paid', '0.0000', 1, 'bb', NULL, '2026-04-21 10:41:46', 45, '0.0000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, NULL);


#
# 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 ('028829da0e492aa10c57683cfda6276abb33f5b9', '34.248.137.227', 1773807562, '__ci_last_regenerate|i:1773807562;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('031afd5ce3ab5999ed8fda530d29b6452d9f9a95', '35.185.64.3', 1775994348, '__ci_last_regenerate|i:1775994347;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('034bcded9e4a0216b3c0447b381a231eb31aa6cd', '103.4.251.184', 1773892280, '__ci_last_regenerate|i:1773892279;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('03835a82ceb456b0615531c246f78e9356ee67f5', '136.116.170.16', 1775815835, '__ci_last_regenerate|i:1775815835;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('04836cb1ed5b31a50ddaa03e82fc29d019355f6c', '146.148.66.46', 1773835553, '__ci_last_regenerate|i:1773835553;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('06cc785053d05ee8ab00d2269ae2fec97daec10e', '216.73.216.60', 1773802277, '__ci_last_regenerate|i:1773802276;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0855bb39564a1ff8fb481d701c95673c9ed78f97', '34.10.44.162', 1774020308, '__ci_last_regenerate|i:1774020308;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('08a80c2e13959088f605c0821593184182da411d', '35.225.2.16', 1773917199, '__ci_last_regenerate|i:1773917199;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('08ac741e791f19f4e43ec102d80d3de79b3cd8c9', '23.27.145.255', 1774163078, '__ci_last_regenerate|i:1774163076;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0cff8465e9ec0d92153a6bdd5502330056110251', '104.204.221.16', 1776527214, '__ci_last_regenerate|i:1776527214;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0d73454dfe978e84dcceb0324ba1fa9848d1169b', '136.118.105.52', 1775095191, '__ci_last_regenerate|i:1775095190;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0e8df16ad51054f03e38dc5eb98103538bbe62c8', '35.238.34.74', 1773847661, '__ci_last_regenerate|i:1773847661;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0f4c25c46edab461d8361dd14faa3e7a120941b8', '44.248.206.10', 1773833537, '__ci_last_regenerate|i:1773833537;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('0f905743bad4f21ff82c08dd94d8d3dd725d73d1', '34.44.46.141', 1773805024, '__ci_last_regenerate|i:1773805024;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('10d2a5f26c694f4853e8548928450c86b6c18bef', '3.38.161.225', 1774052469, '__ci_last_regenerate|i:1774052469;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('12123151fb7ea98d2120b7c578230c48fcfd3459', '34.142.197.42', 1773904131, '__ci_last_regenerate|i:1773904129;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1242279a34217123e08fa4ac660d629840851abd', '35.233.181.155', 1775095316, '__ci_last_regenerate|i:1775095316;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('12d5b594b6dec5385f740284e5a86acc758c5f45', '146.148.66.46', 1773835552, '__ci_last_regenerate|i:1773835552;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('12f17e2dfd072fc5863064170594b6807032592f', '119.13.157.135', 1773970632, '__ci_last_regenerate|i:1773970632;');
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 ('142530d9347d858f3f939913115ccad602acd26b', '34.46.101.59', 1775839389, '__ci_last_regenerate|i:1775839389;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('14a0237202efdf390d7e80e879a3204caff3019e', '3.38.161.225', 1774052491, '__ci_last_regenerate|i:1774052491;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('14cfa4e41fcb237a3696e1bd18cc1b2c3c59dbf9', '205.169.39.49', 1775698041, '__ci_last_regenerate|i:1775698038;');
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 ('17845577fbb55f9594a4b277301c9f8671401bd6', '136.116.9.18', 1773939231, '__ci_last_regenerate|i:1773939231;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('18af8aa0b463d98ead7f07ba39e038f1cc8a762e', '34.141.254.56', 1776399182, '__ci_last_regenerate|i:1776399181;');
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 ('1ab5d9fce55af0b6a5a97e162afc604071322d83', '203.147.139.70', 1776743581, '__ci_last_regenerate|i:1776743581;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|s:1:\"1\";terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1b1278305cf2b0d2dce21b9c2ce287a913beb5a4', '3.82.106.227', 1774165437, '__ci_last_regenerate|i:1774165436;');
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 ('1cff217e7b4afdf0ef4b030fd6891ae15d7164f2', '45.148.10.245', 1775465795, '__ci_last_regenerate|i:1775465795;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1d8289a2141e5768f211a084ef3fe82ceda6a99f', '75.119.157.72', 1775581177, '__ci_last_regenerate|i:1775581177;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1def540a97512101d5527b99fcee2a48a3aafda4', '165.227.69.240', 1773836778, '__ci_last_regenerate|i:1773836777;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('1e29d3c5fc43ef06e7e3c665047476831e578356', '103.4.251.191', 1773889577, '__ci_last_regenerate|i:1773889577;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('20f267193b9f803d75b3c39f6339d9e2e6c9028a', '205.169.39.133', 1775660312, '__ci_last_regenerate|i:1775660309;');
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 ('215a37d314d581ed997c2db0f6c13a9366b69189', '34.70.14.107', 1773846427, '__ci_last_regenerate|i:1773846427;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('217e24eafa807640c44138aa0460a88f6805baf6', '136.116.9.18', 1773939230, '__ci_last_regenerate|i:1773939230;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('22411fdc1d033c4589c08c62d128893aba2115a2', '203.147.139.70', 1776744428, '__ci_last_regenerate|i:1776744419;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|s:1:\"1\";terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";messgae|s:99:\"ទិន្នន័យត្រូវបានរក្សាទុកដោយជោគជ័យ\";__ci_vars|a:1:{s:7:\"messgae\";s:3:\"old\";}');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('22bddad8aff514e4767af77833b5964688ccdb5f', '159.65.94.2', 1774877011, '__ci_last_regenerate|i:1774877010;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2597b61414cc2ff7864f055f4b02fe5312ec890b', '185.8.107.67', 1773904392, '__ci_last_regenerate|i:1773904392;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('25d151b62b181e9a7e01da670c444d7feff3ede4', '205.169.39.133', 1775660321, '__ci_last_regenerate|i:1775660321;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('26313250421af271b35364784a1b9d7f9955ed6e', '3.38.161.225', 1774052478, '__ci_last_regenerate|i:1774052478;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('26de5b756e212062802b3db544dfe5445582ca15', '35.238.34.74', 1773847661, '__ci_last_regenerate|i:1773847661;');
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 ('273d512ced26c85913cb1e8d43d3c133081c1fa9', '68.183.195.136', 1775112646, '__ci_last_regenerate|i:1775112645;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2811b9d4cfe08ed904edb3c3707f1bbc58482d3c', '3.38.161.225', 1774052466, '__ci_last_regenerate|i:1774052466;');
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 ('2b37ab81d5a2c14e0690b7d82642e863eff91e34', '165.227.152.71', 1775394756, '__ci_last_regenerate|i:1775394750;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2b989185b6ab5b60d5601f610e36c2f8b1440f0e', '35.193.117.244', 1775151765, '__ci_last_regenerate|i:1775151765;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2c432d4d38ba6c3541aacfb6c67e89f0a7cd08c3', '52.12.122.46', 1773834469, '__ci_last_regenerate|i:1773834469;');
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 ('2c6fe52b6597733be12add58027de81c9c296fc6', '34.248.137.227', 1773807543, '__ci_last_regenerate|i:1773807543;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2ce97dfbfa1cc9105cc1492d8f183900bbfc1dd8', '195.178.110.65', 1773977978, '__ci_last_regenerate|i:1773977978;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('2d79144a2c9129925695cab0d26d504f3c5ffe9c', '18.237.107.80', 1773818636, '__ci_last_regenerate|i:1773818636;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('30494b17b1b74817afc10a5929ab1f1dee9aa0f2', '3.38.161.225', 1774052468, '__ci_last_regenerate|i:1774052468;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('304d77c503e5f5b9283094ff7ae6aeebfa857499', '164.92.221.53', 1775700981, '__ci_last_regenerate|i:1775700981;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('307a38dcd67676b829b19bbb5604f03d508fe426', '157.173.126.50', 1775586040, '__ci_last_regenerate|i:1775586040;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('30d627398df1322c73476f7c44f8e52db7c67ce3', '34.56.233.22', 1775815140, '__ci_last_regenerate|i:1775815140;');
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 ('3298247929bbd0bc90292fa2d7d07d1adf594c7e', '34.141.147.241', 1776399192, '__ci_last_regenerate|i:1776399192;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('34041dc26149d28494f87d94355372066ac2b127', '34.168.106.157', 1773890138, '__ci_last_regenerate|i:1773890138;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3421843d2d7aee26e71c4a78ee7a7fb5c27ce00a', '195.164.49.144', 1773893561, '__ci_last_regenerate|i:1773893561;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('34a1af7780366375676a79095f53645784ca39ab', '203.147.139.70', 1776743278, '__ci_last_regenerate|i:1776743278;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|s:1:\"1\";terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";');
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 ('36242e75c6c41ccf80ec261343f6e0bc528e78de', '159.223.33.124', 1774342330, '__ci_last_regenerate|i:1774342330;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3698cb2044b84e2dcc9cede5729d89856fbf00a3', '157.230.108.252', 1774622727, '__ci_last_regenerate|i:1774622727;');
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 ('37cc99f53c0ae7b26a21ebbc117b5d498472c241', '121.127.34.166', 1774040364, '__ci_last_regenerate|i:1774040364;');
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 ('387e8987f73f75053d60f48c4e83fcc056a37a62', '205.169.39.46', 1773807666, '__ci_last_regenerate|i:1773807666;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3903454dd0a3b9b425dffc44a166983df9d54290', '206.189.11.120', 1773906827, '__ci_last_regenerate|i:1773906820;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('3b48fd93cb7934fe81486bd95a5bf2e5cc3f8b57', '34.248.137.227', 1773807546, '__ci_last_regenerate|i:1773807546;');
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 ('3f93f5e30f49525ef4f7df9c099bdbf19f73d3dd', '139.59.181.98', 1775226334, '__ci_last_regenerate|i:1775226330;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4027b9bd3d210ece12c0fdc738130a4aeacec5e9', '52.12.122.46', 1773834462, '__ci_last_regenerate|i:1773834462;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('40374ab7b0462e8ea335704da85314dd3556fb8a', '44.248.206.10', 1773833536, '__ci_last_regenerate|i:1773833536;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('40d90db90ca407022904526f94f5c1e3b285e29b', '168.144.19.77', 1774518190, '__ci_last_regenerate|i:1774518190;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('41d1b78afaa70cdbef333eb7f3a4f69b53772c71', '54.190.166.133', 1773821959, '__ci_last_regenerate|i:1773821959;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('42acf9332ad38ae5e837134084fba97f362cce0e', '91.231.89.17', 1773884165, '__ci_last_regenerate|i:1773884165;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('446eb6ba4d69313b7085dc2caeb9618b6e41ea7c', '109.70.100.4', 1773959373, '__ci_last_regenerate|i:1773959373;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4574c54b296d2fa4124a545462de839d693679fc', '34.182.114.52', 1773920774, '__ci_last_regenerate|i:1773920774;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('45df6b010b875b2d2c7660da0f179eaa10a86426', '203.147.139.70', 1776742511, '__ci_last_regenerate|i:1776742511;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('472b483f5d71fc8e159eecc58fae3e81d85257f5', '154.28.229.218', 1773893615, '__ci_last_regenerate|i:1773893614;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('47946dbe6ce24718a2915fe8a55adf0549e6abd0', '149.57.180.29', 1773990325, '__ci_last_regenerate|i:1773990315;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('48ecc6a6ef13da725d2bc7a643e311356c1f3ab5', '194.163.139.165', 1775584866, '__ci_last_regenerate|i:1775584866;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('493cafae95f646d7bf188fbd636a812ec1d20961', '54.244.70.21', 1773848035, '__ci_last_regenerate|i:1773848035;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('49fd93804b8c6298f1f11889dddeba586ec198ca', '52.11.171.121', 1773845977, '__ci_last_regenerate|i:1773845977;');
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 ('4d70460bb558741a338650d2019dac400b3c5f5f', '107.172.195.175', 1773892288, '__ci_last_regenerate|i:1773892287;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4d749fed0ee1931d4e46a06d59ee32ef91231478', '44.248.206.10', 1773833538, '__ci_last_regenerate|i:1773833538;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4e45fff5c40731574901fa3c91b1e0ae31a9539b', '34.10.44.162', 1774020308, '__ci_last_regenerate|i:1774020308;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('4e4f1af6dade49895a57f9db9bbf70f8d3ecac2c', '136.109.88.216', 1773890128, '__ci_last_regenerate|i:1773890127;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('50a8234b6aa0f83169eed0f98d9f26b8c4317b5e', '149.57.180.186', 1774422114, '__ci_last_regenerate|i:1774422110;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5194c78e1bcd053a3d904a3a2d0a3caa480f5046', '34.86.67.12', 1775121731, '__ci_last_regenerate|i:1775121729;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('522e83d168ce956ce3a32982594884205a6ddbd2', '192.42.116.45', 1775065759, '__ci_last_regenerate|i:1775065759;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5307b9cbdb2e82f731bcaf655803a9161aa011fd', '34.56.35.13', 1775837569, '__ci_last_regenerate|i:1775837569;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('546b66dc55fcaf2ec7c051e798cdae9579902af0', '34.60.197.86', 1774020251, '__ci_last_regenerate|i:1774020251;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5578c07ef9f8e9ddecfbfbaa6eb1feca5c677645', '18.237.107.80', 1773818636, '__ci_last_regenerate|i:1773818636;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('55ce4613fc69acf5e633254759d6e1956dab96a5', '23.27.145.31', 1775026901, '__ci_last_regenerate|i:1775026899;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5664a95a688884e3c8cfca8c07c54ab6bf5415b0', '64.23.145.236', 1775144337, '__ci_last_regenerate|i:1775144336;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5762ebd968579097ebabb153dc16d8de02873864', '159.223.216.110', 1774010100, '__ci_last_regenerate|i:1774010095;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('57a27a0441c988f349590483f862e5a7f123ae1f', '205.169.39.146', 1774285502, '__ci_last_regenerate|i:1774285501;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('57a5e1b82b28cc506c40c2bec44545b510c5639b', '157.173.126.56', 1775577673, '__ci_last_regenerate|i:1775577673;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('57a82258220c94331b64d5517ad286a50aeb3142', '157.173.126.56', 1775577674, '__ci_last_regenerate|i:1775577674;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5aadbfbb222348615f982d78923750ce88686eb9', '3.38.161.225', 1774052472, '__ci_last_regenerate|i:1774052472;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5b6833769bf6d4deb1aa563909fcf6f38e213d99', '149.57.180.27', 1775026909, '__ci_last_regenerate|i:1775026909;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5f25db3f82532c57b4371a01f4aad885d5589893', '54.244.70.21', 1773848030, '__ci_last_regenerate|i:1773848030;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('5fc90ff26655e33ae24fea6984c135d64da002de', '136.113.228.241', 1775661198, '__ci_last_regenerate|i:1775661198;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('60c0cee3564a1f692d2496e186b1cf9241ad267c', '8.229.235.136', 1773969530, '__ci_last_regenerate|i:1773969529;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('611c3b9aa8daad2f11e4aee43e32207a409c3ddc', '84.32.70.55', 1776088633, '__ci_last_regenerate|i:1776088633;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6132ccf53a995fd07fdaba88cbdd8b4be2d77ecf', '147.185.132.27', 1774929339, '__ci_last_regenerate|i:1774929339;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('62551a3f0d76eee1c82a7e3c0f2dd449b2331e34', '165.227.152.71', 1775394747, '__ci_last_regenerate|i:1775394746;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('644ef0c12af04eaa216a9b3928c3e5520b9a9d1e', '157.173.126.50', 1775574378, '__ci_last_regenerate|i:1775574378;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6505c9795786222bcf1a80fa74df821e73af9626', '3.38.161.225', 1774052447, '__ci_last_regenerate|i:1774052447;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('654249bbb4f41acc61b075cb3394901f0173d610', '136.118.214.59', 1773976636, '__ci_last_regenerate|i:1773976636;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6579bd72acc9678593aac8f999ba6e3ef4b01fc0', '136.115.63.37', 1776175330, '__ci_last_regenerate|i:1776175329;');
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 ('65be7f33d4f775ba044753b7629363289655aac1', '23.27.145.110', 1774163079, '__ci_last_regenerate|i:1774163078;');
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 ('68eaa1352fc270abe10f7046f35f502cb9e68660', '203.147.139.70', 1776744419, '__ci_last_regenerate|i:1776744419;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('696d654912b73e9b88f09ab36a8a29346c1ead33', '3.38.161.225', 1774052479, '__ci_last_regenerate|i:1774052479;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('69f5907fb6190bd2d4ed88c6d2a398115f4948c3', '157.173.126.50', 1775575517, '__ci_last_regenerate|i:1775575517;');
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 ('6b8fcf64f31026243caab1d999beba0f59d48298', '172.69.151.20', 1773950966, '__ci_last_regenerate|i:1773950966;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6bc4f71a031bcab459974d44db2b3cb888aab678', '34.82.68.249', 1773891655, '__ci_last_regenerate|i:1773891655;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6c47df31ba33d4a7df434a61314bcd9e3d9b29f1', '35.186.157.93', 1773819143, '__ci_last_regenerate|i:1773819138;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6f2b21e3feeb42e563281444c6614222c13ddb48', '136.117.105.119', 1773891639, '__ci_last_regenerate|i:1773891638;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6f39ece632ffea7f2649898d927d6ea8241317aa', '139.59.181.98', 1775226329, '__ci_last_regenerate|i:1775226328;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6f3b22d876bbac8001353fef839eac60e5a56ec2', '203.147.139.70', 1776742824, '__ci_last_regenerate|i:1776742824;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|i:1;terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6f73db7dece9a7c0a9b7cd023ffc7dd6fcbfd93b', '34.30.161.210', 1773939290, '__ci_last_regenerate|i:1773939290;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('6f75c12df4a0403acc5aa6ed0da94bcb2d3f4e2f', '15.206.170.177', 1774202993, '__ci_last_regenerate|i:1774202993;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('70132bb4d241140c61e5377c09c1a1e2fd17faae', '195.164.49.144', 1773896967, '__ci_last_regenerate|i:1773896967;');
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 ('732f8ba75c92fc506caf79dd5b63a2cddf2c36b3', '157.173.126.50', 1775574378, '__ci_last_regenerate|i:1775574378;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7355ec365dad2d3533578df9dc8469a5abef462f', '209.38.110.100', 1774253199, '__ci_last_regenerate|i:1774253198;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('73c761188306d1b5bd83c7a519f6d362fcf9c611', '203.147.139.70', 1776743889, '__ci_last_regenerate|i:1776743889;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:\"1776737611\";last_ip|s:13:\"119.13.156.53\";avatar|N;gender|s:4:\"male\";group_id|s:1:\"1\";store_id|s:1:\"1\";terminal_id|s:1:\"1\";has_store_id|N;register_id|s:1:\"1\";cash_in_hand|s:7:\"50.0000\";register_open_time|s:19:\"2026-04-21 10:36:16\";');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('748751692021446ffd7484f3fb6014a38ddc63dd', '149.57.180.111', 1774681358, '__ci_last_regenerate|i:1774681356;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('764c8a83720626812e3587c8dd327475b873a78e', '194.163.139.165', 1775584865, '__ci_last_regenerate|i:1775584865;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('769528794cd92d6e466e6bf6579f99d0b38c6bc2', '164.92.196.102', 1775838122, '__ci_last_regenerate|i:1775838118;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('795d1819622e41ed630a5fe18f764f983d3f55dd', '165.22.218.150', 1774188917, '__ci_last_regenerate|i:1774188916;');
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 ('7c86841d8ed1c93c004e9aa45e5ceb10616bcb3a', '54.190.166.133', 1773821965, '__ci_last_regenerate|i:1773821965;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7d0f6ca15a15894f3f9b9ebdd7b577d7d3075c21', '107.172.180.205', 1774887228, '__ci_last_regenerate|i:1774887228;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7d734cd41e9f5eb6e616a217cd016d3a24932776', '141.148.153.213', 1773930210, '__ci_last_regenerate|i:1773930210;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('7e0c7476a88941f401d6d0140a4c7f77aed2d90a', '103.4.251.191', 1773889574, '__ci_last_regenerate|i:1773889574;');
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 ('7eddb42a68680a980967f9df6b02a0bb66ca2b06', '52.11.171.121', 1773845982, '__ci_last_regenerate|i:1773845982;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('807fa9b2a0cdedd7571b23a85462f492a8fcaea7', '34.248.137.227', 1773807544, '__ci_last_regenerate|i:1773807544;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('815ee05b29802d3e3f8d61306ba288647f1041d3', '45.148.10.120', 1774095550, '__ci_last_regenerate|i:1774095550;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('82bf2bd295f65db3784fb9662a9d8105a5f6911d', '23.27.145.232', 1776495704, '__ci_last_regenerate|i:1776495702;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8327416be7ee435170a5d8d741af109faecdce9b', '168.144.19.77', 1774518192, '__ci_last_regenerate|i:1774518191;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8420d076a05813c7ac03e1bc0b5773ca3f8cf0c7', '157.173.126.50', 1775575518, '__ci_last_regenerate|i:1775575518;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('84b1b0f433a1e1ac1e1c9bae2f04bcb36734b22b', '159.223.33.124', 1774342330, '__ci_last_regenerate|i:1774342330;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8505928906b8fd12beca6142c6fc297aa4e57db8', '16.145.84.150', 1773834443, '__ci_last_regenerate|i:1773834443;');
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 ('87d44a1039bb35ed8e743107ae6582cc74e97f1c', '3.38.161.225', 1774052492, '__ci_last_regenerate|i:1774052492;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('87e54047cadcb1917d97fc8ab7ad058e798edf08', '35.230.53.93', 1775743160, '__ci_last_regenerate|i:1775743159;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('87f6b199eba922fa7cc64fd455fcd9d5e734202d', '136.107.80.76', 1775681152, '__ci_last_regenerate|i:1775681151;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('89d0e2478ec6c449cf5e4a72085c315bd01ca855', '194.15.36.117', 1775192335, '__ci_last_regenerate|i:1775192335;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8b5bcad10da79ae0b9070fff44d1fd593085b59a', '34.30.161.210', 1773939292, '__ci_last_regenerate|i:1773939292;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('8d089206007ae6d5e6d57fe1f5686fddeef8b467', '195.164.49.144', 1773809433, '__ci_last_regenerate|i:1773809433;');
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 ('8ee8673bdfee165bdba7fab7f6f97e59f4c3f434', '34.85.227.76', 1774180706, '__ci_last_regenerate|i:1774180705;');
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 ('904db0a86c40f7d89ffe5e9431c0295042bfc3c6', '136.118.234.67', 1776099716, '__ci_last_regenerate|i:1776099715;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9181b0b2ff369b42756847035acf9d4421f71577', '68.183.207.57', 1774076082, '__ci_last_regenerate|i:1774076076;');
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 ('92988ac976cc147e0d40b748cfce4d8c9693e980', '161.35.135.37', 1774882705, '__ci_last_regenerate|i:1774882703;');
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 ('934141b0cfc498760490372d5ba59371bf8e37b3', '157.173.126.44', 1775582393, '__ci_last_regenerate|i:1775582393;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('93bef2e53d77ad2516761164d48f054cc166083b', '136.109.143.198', 1773892564, '__ci_last_regenerate|i:1773892564;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('94787306ba6d05dedd1593c79133594891cc326e', '34.134.135.175', 1773805026, '__ci_last_regenerate|i:1773805025;');
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 ('96a190000f5facf8a5836a9b6dea8b067e9a0403', '34.26.203.248', 1773835043, '__ci_last_regenerate|i:1773835043;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('97426b1ac0686e43553af94d7d6adf3ce3800f83', '3.38.161.225', 1774052446, '__ci_last_regenerate|i:1774052446;');
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 ('9963e3587683b56c7feae71f2c5f60c1ccbfef70', '34.182.114.52', 1773920774, '__ci_last_regenerate|i:1773920774;');
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 ('9bfb9f12322ff5753fef6c164244961fea9b9879', '119.13.156.53', 1776737771, '__ci_last_regenerate|i:1776737606;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:\"1773970563\";last_ip|s:14:\"119.13.157.135\";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 ('9c3b21403d5c397c7b58c6ffe12c646e1441a79d', '136.119.205.178', 1775660836, '__ci_last_regenerate|i:1775660836;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9d59e8e046b0ee02648ffefb0af678b5711029c7', '104.164.126.190', 1773893594, '__ci_last_regenerate|i:1773893594;');
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 ('9e3985961582ee37423785acd5bc18c73102b4e2', '209.38.110.100', 1774253206, '__ci_last_regenerate|i:1774253200;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('9e558453a618c800adfe3604793d58ca1967c965', '18.237.107.80', 1773818636, '__ci_last_regenerate|i:1773818636;');
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 ('a000b099f922b15ba29e9ff58118f6139559978b', '13.233.186.5', 1774206471, '__ci_last_regenerate|i:1774206470;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a070b8fbf8b06ebac6393a66550633d8ebe5d451', '16.145.84.150', 1773834437, '__ci_last_regenerate|i:1773834437;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a0804303075a10187c323aa46121d6c0f5c4e051', '195.211.77.141', 1773906122, '__ci_last_regenerate|i:1773906122;');
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 ('a1d457dd6d0eafc55bdd495b5f14d262b5c1afdb', '205.169.39.146', 1774285478, '__ci_last_regenerate|i:1774285475;');
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 ('a445ca3fd4be65ddd4f94a8deb5d861620ead791', '35.225.2.16', 1773917199, '__ci_last_regenerate|i:1773917199;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a45778660826e0aee7763d36e0c20291ea495ea8', '119.13.157.135', 1773802127, '__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 ('a6be93c2103b1efee4dab6789ed733f5873ffc5a', '54.153.233.55', 1774168751, '__ci_last_regenerate|i:1774168751;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a72b8a17e6734116d7e8787b3b8c9ba514ef05d9', '195.211.77.141', 1774759440, '__ci_last_regenerate|i:1774759440;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('a7377315cd944485c4c451f47627eb78e62e0fd9', '195.211.77.141', 1773906092, '__ci_last_regenerate|i:1773906092;');
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 ('a93683d108473efb6ccc42294f622523e9b63b71', '157.173.126.44', 1775582391, '__ci_last_regenerate|i:1775582391;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('aa12efaed32bacc031adf52657bf3f0818644476', '171.25.193.81', 1774014136, '__ci_last_regenerate|i:1774014136;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('aa2e1c2558b7ffdd3b69b74cae8c0f6e37023cac', '18.237.88.183', 1773845963, '__ci_last_regenerate|i:1773845963;');
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 ('ac55dfd86b8f217df8054c892670654d0b60c2d9', '164.92.221.53', 1775700987, '__ci_last_regenerate|i:1775700983;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('acdc8b30ee9b0fbc438de874f571ff2bc6f8d0cf', '75.119.137.33', 1775579087, '__ci_last_regenerate|i:1775579087;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('af83ae51e3051ace9e88d04042bf75616e83e43f', '134.209.86.27', 1775288790, '__ci_last_regenerate|i:1775288786;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('af8570cb5d4f528718261557a500b5ad5ff4f423', '35.193.117.244', 1775151764, '__ci_last_regenerate|i:1775151764;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b1ca15ef2a5c1bf7c9d1f081a1cc53e348a21118', '136.111.228.39', 1775477946, '__ci_last_regenerate|i:1775477944;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b299820362e172dd3236a7430e2eb2121f61ca49', '142.93.207.24', 1775918373, '__ci_last_regenerate|i:1775918372;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b2ddba6be4b76b0d570d018f8002ce3aade89ffc', '155.2.226.162', 1776216688, '__ci_last_regenerate|i:1776216688;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b3b3ce6c4e19102d0a5c73be96b74a2de924c06a', '164.92.83.116', 1775128798, '__ci_last_regenerate|i:1775128798;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b454f0680b3f7a7cf87af62930e6aad861475f57', '34.182.7.8', 1773890623, '__ci_last_regenerate|i:1773890622;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b45f0873f26992a9dcbe31c6f13fc270aef57db3', '5.255.125.79', 1776542920, '__ci_last_regenerate|i:1776542920;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b4855ab0e18a2b8b33124f98aaf513071fb15d74', '165.227.69.240', 1773836786, '__ci_last_regenerate|i:1773836780;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b4a986b3ce1d7e7735904b46d276628b034f4782', '34.30.161.210', 1773939292, '__ci_last_regenerate|i:1773939292;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b5a05beda033573ede9bbb579e052c5097b02217', '164.92.83.116', 1775128797, '__ci_last_regenerate|i:1775128797;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b5ec398b261c0acaf73a1d28572e379b47a2e049', '107.172.195.175', 1773892280, '__ci_last_regenerate|i:1773892279;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b5f868ee02aba2f48d0766a4ca1d0ad6aac28470', '8.229.235.136', 1773969522, '__ci_last_regenerate|i:1773969522;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b61331ad17d1ba06ea7287e9c11cfb20df4f37cd', '84.32.70.55', 1776088633, '__ci_last_regenerate|i:1776088633;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b630f71ee1b3c130704c7e96ade55e109749bf8c', '34.56.233.22', 1775815139, '__ci_last_regenerate|i:1775815139;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('b637e441dc6e1d485fee8550e78700f8150b8041', '23.27.145.62', 1774681354, '__ci_last_regenerate|i:1774681354;');
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 ('b776f7077681f71310b752062ce2f6783861b2fd', '104.164.126.235', 1773893593, '__ci_last_regenerate|i:1773893593;');
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 ('ba24ceca2abda19ba29009dc0c9a46e6e71bcfbd', '195.211.77.141', 1774759398, '__ci_last_regenerate|i:1774759398;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ba80ea2f1a5ddea8437a2f1b46e375995bf7dab5', '159.223.88.186', 1774011499, '__ci_last_regenerate|i:1774011499;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bb6c6e2338a2362f6aa7970ffcf1dd15509aff66', '34.248.137.227', 1773807560, '__ci_last_regenerate|i:1773807560;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bb8e10cb648a242800548925081d781c2181c9ab', '136.119.205.178', 1775660836, '__ci_last_regenerate|i:1775660836;');
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 ('bc572d0d7739b6f5aa8e60709d89d1d32f582218', '44.248.206.10', 1773833537, '__ci_last_regenerate|i:1773833537;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bd22d818af1e6484972a8d36ac42c252f17f30ca', '34.26.203.248', 1773835044, '__ci_last_regenerate|i:1773835044;');
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 ('be85f1521de4813bf358472fef5fc84843ddf8d9', '35.247.186.56', 1773854084, '__ci_last_regenerate|i:1773854083;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('be9a98c01d36cf361bb6da2a9ecf84062708e240', '34.57.7.247', 1773939297, '__ci_last_regenerate|i:1773939297;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('beb76cc60c4bc1971c8082efcf9c1cd43a5a78f8', '34.83.40.147', 1775133115, '__ci_last_regenerate|i:1775133114;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('bffe1b17bec2b713b6a76103daa8dddcd437bb35', '157.173.126.50', 1775586039, '__ci_last_regenerate|i:1775586039;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c0b757804d886de15cb6671c6311d10862887b58', '149.57.180.36', 1773903861, '__ci_last_regenerate|i:1773903861;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c163482c1c316e2adf8686b7befd95d5858c33e5', '155.2.226.162', 1776216314, '__ci_last_regenerate|i:1776216314;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c1b9fa59640c63beb3fbfd2bcf9064996818a754', '16.146.33.110', 1775095680, '__ci_last_regenerate|i:1775095680;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c1e75f9be0ec430db4fa42be1efd7c55d645ea6d', '34.57.7.247', 1773939297, '__ci_last_regenerate|i:1773939297;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c2cb4ced7ebc7fe2678d6df53d81e78393637ab5', '34.70.14.107', 1773846428, '__ci_last_regenerate|i:1773846428;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c429c6d478bb429257732359abfde001a78e33ed', '159.223.216.110', 1774010094, '__ci_last_regenerate|i:1774010093;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c522347dd6451b0bb898193775572939f4c69c11', '34.30.161.210', 1773939290, '__ci_last_regenerate|i:1773939290;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c6582df1211ca1148b94d1cf0f90a343eb8cb933', '34.46.101.59', 1775839388, '__ci_last_regenerate|i:1775839388;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c69a6845dbd736bd2b621f501cf12382dde2c75e', '136.109.102.6', 1775636804, '__ci_last_regenerate|i:1775636804;');
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 ('c84b91dfc83e56ffc891585eb74f08137fb02537', '107.172.180.205', 1774887228, '__ci_last_regenerate|i:1774887228;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c8702907ba889083f3df6e14417a6f4cdff48930', '164.92.196.102', 1775838117, '__ci_last_regenerate|i:1775838116;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('c8ad326be496796c0877b9226b7ac618a63f4b71', '141.148.153.213', 1773843808, '__ci_last_regenerate|i:1773843808;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ca1fbcbc11cd5ee34005e296a7788351eeb8b636', '149.57.180.144', 1773908523, '__ci_last_regenerate|i:1773908522;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cbf5a530de13f637d8bc75665982c7f573142231', '165.22.218.150', 1774188918, '__ci_last_regenerate|i:1774188917;');
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 ('cd5fa79fb9b2fa1a495e686a750ff187e9d660e2', '3.38.161.225', 1774052454, '__ci_last_regenerate|i:1774052454;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cd811112621ae9b4d73d66c4270ea167fa8612a3', '3.38.161.225', 1774052459, '__ci_last_regenerate|i:1774052459;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cef1a72673b9bc2b9485c6bffef01045ea75e2b5', '68.183.207.57', 1774076075, '__ci_last_regenerate|i:1774076074;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cf6075c83b70655da0f9304440645e08340a9e71', '18.237.88.183', 1773845970, '__ci_last_regenerate|i:1773845970;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('cff565d54daec0d2c447a4f0eb370aeee45cce98', '185.8.107.67', 1773903117, '__ci_last_regenerate|i:1773903117;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d03ddc01225153eb7901ec1087bfe4a5556cd9c3', '34.126.119.94', 1773888016, '__ci_last_regenerate|i:1773888016;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d18aaffbba5288054b7afde70e1e18a48705fa0e', '149.57.180.167', 1773903842, '__ci_last_regenerate|i:1773903841;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d23a983aeeb8d45e6e0198c1d2db42906c056322', '3.38.161.225', 1774052465, '__ci_last_regenerate|i:1774052465;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d3da4075430d2ef907c0a9dba546b19c6f8aa3c5', '195.164.49.144', 1773815042, '__ci_last_regenerate|i:1773815042;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d42a7206dd8ded701e451508a4453dbe75d1ae1b', '206.189.11.120', 1773906819, '__ci_last_regenerate|i:1773906819;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d58611a270d85d39f0a8bffcbe9c615cd8bf62e9', '104.252.191.97', 1773889574, '__ci_last_regenerate|i:1773889574;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d5e809b21a7cc0d4937fcd36a83378d6f76e94bd', '35.230.6.175', 1773919599, '__ci_last_regenerate|i:1773919599;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d65c2dc39727ba157a0ad10aea81e85f1fa7f56b', '5.255.125.79', 1776542920, '__ci_last_regenerate|i:1776542920;');
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 ('d8c5d11bf8de377ca0577fafef00f569d860394f', '34.60.197.86', 1774020253, '__ci_last_regenerate|i:1774020253;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d8fc723abd1a70e9366d62fd224bebe009bd621d', '35.94.131.115', 1773890677, '__ci_last_regenerate|i:1773890676;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d90f601b718ea02d8460265d513ce2cbb59982db', '34.248.137.227', 1773807559, '__ci_last_regenerate|i:1773807558;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('d9c856289e3d85990cc1b89c8cc42e5fb9a88444', '75.119.157.72', 1775581176, '__ci_last_regenerate|i:1775581176;');
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 ('df00d253b927678c06a6ea612fecdde49cbd42eb', '3.38.161.225', 1774052489, '__ci_last_regenerate|i:1774052489;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e226e1b8fde9e52958f13c8a354b345f7db0c6dc', '75.119.137.33', 1775579088, '__ci_last_regenerate|i:1775579088;');
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 ('e3a7f897bcf3911771aad65ce4b7df6fa75478d3', '121.127.34.166', 1774040363, '__ci_last_regenerate|i:1774040363;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e44b5d38092d811b7cd47bf6c12835bde3b2591a', '205.169.39.54', 1775055463, '__ci_last_regenerate|i:1775055463;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e5eef6b7d5595277736a9ed44bcfb47081551fbf', '195.178.110.65', 1773977971, '__ci_last_regenerate|i:1773977971;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e72572a812f1489efb91e1a02e1e32535ac263bb', '110.172.98.2', 1776581698, '__ci_last_regenerate|i:1776581698;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e754ed46407be5fe5c155079b326f83fce23e58f', '136.109.88.216', 1773890170, '__ci_last_regenerate|i:1773890168;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e76b3796ae3ff003f2cc09142e268859590548c3', '68.183.195.136', 1775112653, '__ci_last_regenerate|i:1775112648;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e81ffee5d2989d888386d08cdf5551a8d0eff657', '34.82.68.249', 1773891646, '__ci_last_regenerate|i:1773891645;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('e8effb678db128ae317cb4ce919a30d22226bebc', '136.109.223.16', 1773890645, '__ci_last_regenerate|i:1773890644;');
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 ('ea068956462e17ec0a3e0a2323354451cee46666', '34.85.224.85', 1776018061, '__ci_last_regenerate|i:1776018060;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('eabb40dee769acd519d1af9868e806ab8e60fc53', '104.197.69.115', 1775055351, '__ci_last_regenerate|i:1775055351;');
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 ('ecdc333eca6601e4e7344bb9daa1a945e2790cc4', '136.116.170.16', 1775815838, '__ci_last_regenerate|i:1775815838;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('ed5b48660c381a4de1d36e26568c49f861a67378', '134.209.86.27', 1775288785, '__ci_last_regenerate|i:1775288784;');
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 ('eef599614537bb1c2a5a06230d76e898351dc773', '136.113.228.241', 1775661199, '__ci_last_regenerate|i:1775661199;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f01f4e7d421f23c4c5bb85f9c35fefae9d68b7d7', '45.148.10.245', 1775465794, '__ci_last_regenerate|i:1775465794;');
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 ('f0a9f5b7b9ffac2350e9005044519d05388dcf94', '34.150.209.141', 1774189354, '__ci_last_regenerate|i:1774189353;');
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 ('f482eb0b753d29a2222ac8899580408d1f84afef', '18.237.107.80', 1773818637, '__ci_last_regenerate|i:1773818637;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f4edd11cd0e73f3b09563a779eaf33de3398dfcc', '104.204.221.16', 1776527214, '__ci_last_regenerate|i:1776527214;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f4fe682afee973529f639f156bdfb3b600773030', '34.34.7.25', 1773804005, '__ci_last_regenerate|i:1773804005;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f54e6ba42ad6b93ba61c87ae2e8c4d580ec3eeb4', '185.243.218.229', 1775065763, '__ci_last_regenerate|i:1775065763;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f60e237101930a13c014a38b4d418888e50df5e9', '34.56.35.13', 1775837569, '__ci_last_regenerate|i:1775837569;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f6e3c54599779531a0ea27b863041228280f71c5', '45.148.10.120', 1774053964, '__ci_last_regenerate|i:1774053964;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f80dfe59cc8dd8fb2ea7322d8d8c0774fa9f7f69', '3.38.161.225', 1774052454, '__ci_last_regenerate|i:1774052454;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f8b960b0ded7123d51c4b94f657f376c07fd792a', '172.69.151.20', 1773950967, '__ci_last_regenerate|i:1773950967;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f930b203981a30019ab534cbf78f8a42a2d972c0', '34.55.95.50', 1775493612, '__ci_last_regenerate|i:1775493610;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('f9cacb28237e88e23eea29876c58c1266bd7bcfd', '157.230.108.252', 1774622733, '__ci_last_regenerate|i:1774622728;');
INSERT INTO `tec_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('fa2d3741b0ece8df6e86e02e60575ecf091c2964', '3.38.161.225', 1774052445, '__ci_last_regenerate|i:1774052445;');
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 ('fdb4d4bda8749fefb2a7540cd6e6dbb9e94573a6', '35.230.6.175', 1773919600, '__ci_last_regenerate|i:1773919600;');
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, 45, 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.', '', 2, '', '', 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=5 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');
INSERT INTO `tec_user_logins` (`id`, `user_id`, `company_id`, `ip_address`, `login`, `time`) VALUES (2, 1, NULL, '119.13.157.135', 'admin', '2026-03-20 08:36:03');
INSERT INTO `tec_user_logins` (`id`, `user_id`, `company_id`, `ip_address`, `login`, `time`) VALUES (3, 1, NULL, '119.13.156.53', 'Admin', '2026-04-21 09:13:31');
INSERT INTO `tec_user_logins` (`id`, `user_id`, `company_id`, `ip_address`, `login`, `time`) VALUES (4, 1, NULL, '203.147.139.70', 'admin', '2026-04-21 10:35:35');


#
# 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, '203.147.139.70', '127.0.0.1', 'admin', 'fe941d48eb1fbce34b4588ae500861570fb0e398', NULL, 'admin', NULL, NULL, NULL, 'b2d2c8fd5d9a5f19901279ac74cec92dc15ac970', 1435204774, 1776742535, 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');


