CREATE TABLE `pos_credit_note` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `credit_note_id` varchar(225) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT '0.00',
  `return_order_id` varchar(45) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `redeem_order_id` varchar(45) DEFAULT NULL,
  `redeem_date` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `pos_cust_credit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `return_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_mobile` varchar(45) DEFAULT NULL,
  `mode_type` varchar(45) DEFAULT NULL,
  `credit_amount` decimal(15,2) DEFAULT '0.00',
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modify` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `pos_customer_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `customer_id` varchar(45) DEFAULT NULL,
  `name` varchar(225) DEFAULT NULL,
  `email` varchar(225) DEFAULT NULL,
  `mobile` varchar(45) DEFAULT NULL,
  `gst_number` varchar(45) DEFAULT NULL,
  `address` text,
  `landmark` text,
  `area_name` varchar(225) DEFAULT NULL,
  `city_name` varchar(225) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_daily_coupon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `coupon_number` varchar(45) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_hsn_code_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hsn_code` varchar(45) DEFAULT NULL,
  `description_english` blob,
  `description_hindi` blob,
  `cgst_tax` decimal(15,2) DEFAULT '0.00',
  `sgst_tax` decimal(15,2) DEFAULT '0.00',
  `igst_tax` decimal(15,2) DEFAULT '0.00',
  `total_gst` decimal(15,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_local_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `meta_key` text,
  `meta_value` blob,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_order_detail` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_type` varchar(45) DEFAULT NULL,
  `order_flag` varchar(45) DEFAULT NULL,
  `order_source` varchar(45) DEFAULT NULL,
  `packing_order` tinyint(4) DEFAULT '0',
  `invoice_no` varchar(45) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(225) DEFAULT NULL,
  `customer_mobile` varchar(45) DEFAULT NULL,
  `customer_email` varchar(225) DEFAULT NULL,
  `customer_address` text,
  `customer_gst_number` varchar(45) DEFAULT NULL,
  `sale_amount` decimal(15,2) DEFAULT '0.00',
  `cgst_tax` decimal(15,2) DEFAULT '0.00',
  `igst_tax` decimal(15,2) DEFAULT '0.00',
  `sgst_tax` decimal(15,2) DEFAULT '0.00',
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `coupon_amount` decimal(15,2) DEFAULT '0.00',
  `net_amount` decimal(15,2) DEFAULT '0.00',
  `order_status` varchar(45) DEFAULT NULL,
  `order_product` longblob,
  `order_total` longblob,
  `order_payment` longblob,
  `payment_option` longblob,
  `tax_detail` longblob,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modify` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `live_order_id` varchar(45) DEFAULT NULL,
  `order_sync` tinyint(4) DEFAULT '0',
  `packing_note` blob,
  `order_coupon` varchar(45) DEFAULT NULL,
  `serial_number` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_order_retun` (
  `return_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(45) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `sale_amount` decimal(15,2) DEFAULT '0.00',
  `cgst_tax` decimal(15,2) DEFAULT '0.00',
  `igst_tax` decimal(15,2) DEFAULT '0.00',
  `sgst_tax` decimal(15,2) DEFAULT '0.00',
  `total_amount` decimal(15,2) DEFAULT '0.00',
  `return_product` longblob,
  `return_payment` longblob,
  `return_total` longblob,
  `credit_note_id` varchar(225) DEFAULT NULL,
  `credit_note_amount` decimal(15,2) DEFAULT '0.00',
  `return_status` int(11) DEFAULT NULL,
  `tax_detail` longblob,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `redeem_order_id` varchar(45) DEFAULT NULL,
  `live_return_id` varchar(45) DEFAULT NULL,
  `return_sync` tinyint(4) DEFAULT '0',
  `return_coupon` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`return_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(225) DEFAULT NULL,
  `category_image` text,
  `status` tinyint(4) DEFAULT '1',
  `del_status` tinyint(4) DEFAULT '1',
  `image_approval` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_category_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `main_category` varchar(45) DEFAULT NULL,
  `sub_category` varchar(45) DEFAULT NULL,
  `product_list` blob,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_customize` (
  `pro_customize_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `pro_name` varchar(225) DEFAULT NULL,
  `pro_price` decimal(15,2) DEFAULT NULL,
  `pro_desc` blob,
  `pro_sorting` int(4) DEFAULT NULL,
  PRIMARY KEY (`pro_customize_id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `product_name` varchar(225) DEFAULT NULL,
  `product_type` int(11) DEFAULT NULL,
  `upc` varchar(45) DEFAULT NULL,
  `sku` varchar(45) DEFAULT NULL,
  `brand_id` int(11) DEFAULT NULL,
  `brand_name` varchar(45) DEFAULT NULL,
  `size` varchar(45) DEFAULT NULL,
  `unit` varchar(45) DEFAULT NULL,
  `unit_name` varchar(45) DEFAULT NULL,
  `size_unit` varchar(45) DEFAULT NULL,
  `mrp_price` decimal(15,2) DEFAULT '0.00',
  `purchase_price` decimal(15,2) DEFAULT '0.00',
  `selling_price` decimal(15,2) DEFAULT '0.00',
  `qty` varchar(45) DEFAULT NULL,
  `reserve_qty` varchar(45) DEFAULT NULL,
  `inventory_alert` varchar(45) DEFAULT NULL,
  `bin_location` blob,
  `shelf_life` blob,
  `hsn_code` varchar(45) DEFAULT NULL,
  `cgst_tax` decimal(15,2) DEFAULT '0.00',
  `igst_tax` decimal(15,2) DEFAULT '0.00',
  `sgst_tax` decimal(15,2) DEFAULT '0.00',
  `item_prepare` tinyint(4) DEFAULT '0',
  `item_recipe` blob,
  `display_flag` tinyint(4) DEFAULT '1',
  `pro_customize` tinyint(4) DEFAULT '0',
  `tag_pro_topping` blob,
  `combo_tag_pro` blob,
  `product_image` text,
  `status` tinyint(4) DEFAULT '1',
  `del_status` tinyint(4) DEFAULT '1',
  `new_barcode` varchar(45) DEFAULT NULL,
  `sync_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=511 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_inventory` (
  `inventory_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `pro_mrp` decimal(15,2) DEFAULT NULL,
  `pro_purchase` decimal(15,2) DEFAULT NULL,
  `batch_number` text,
  `bin_location` text,
  `shelf_life` text,
  `pro_qty` int(11) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modify` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`inventory_id`)
) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_product_unit` (
  `unit_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `description` text,
  `status` tinyint(4) DEFAULT '1',
  `del_status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`unit_id`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_store_coupon_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_coupon_id` int(11) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `coupon_code` varchar(45) DEFAULT NULL,
  `based_type` tinyint(4) DEFAULT NULL,
  `based_type_name` varchar(45) DEFAULT NULL,
  `apply_type` tinyint(4) DEFAULT NULL,
  `apply_type_name` varchar(45) DEFAULT NULL,
  `discount_type` tinyint(4) DEFAULT NULL,
  `discount_type_name` varchar(45) DEFAULT NULL,
  `minimum_order` decimal(15,2) DEFAULT '0.00',
  `channel_pos` tinyint(4) DEFAULT '0',
  `channel_web` tinyint(4) DEFAULT '0',
  `channel_android` tinyint(4) DEFAULT '0',
  `channel_ios` tinyint(4) DEFAULT '0',
  `discount_pos` decimal(15,2) DEFAULT '0.00',
  `discount_web` decimal(15,2) DEFAULT '0.00',
  `discount_android` decimal(15,2) DEFAULT '0.00',
  `discount_ios` decimal(15,2) DEFAULT '0.00',
  `status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_store_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `store_id_encrypt` text,
  `seller_id` int(11) DEFAULT NULL,
  `store_name` varchar(225) DEFAULT NULL,
  `owner_name` varchar(225) DEFAULT NULL,
  `business_type` int(11) DEFAULT NULL,
  `business_type_name` varchar(45) DEFAULT NULL,
  `username` varchar(45) DEFAULT NULL,
  `password` text,
  `first_login` tinyint(4) DEFAULT '0',
  `configuration_step` varchar(45) DEFAULT NULL,
  `approval_status` tinyint(4) DEFAULT NULL,
  `live_status` tinyint(4) DEFAULT NULL,
  `deny_reason_name` varchar(45) DEFAULT NULL,
  `deny_comment` varchar(45) DEFAULT NULL,
  `store_address` text,
  `store_image` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_store_meta_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `meta_key` text,
  `meta_value` blob,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_store_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `pos_enable` varchar(45) DEFAULT NULL,
  `pos_certification` varchar(45) DEFAULT NULL,
  `pos_user` int(11) DEFAULT NULL,
  `pos_type` varchar(45) DEFAULT NULL,
  `order_estimation` varchar(45) DEFAULT NULL,
  `pos_kitchen` varchar(45) DEFAULT NULL,
  `pos_table` varchar(45) DEFAULT NULL,
  `pos_table_count` varchar(45) DEFAULT NULL,
  `table_split` varchar(45) DEFAULT NULL,
  `demo_active_date` varchar(45) DEFAULT NULL,
  `validity_start` varchar(45) DEFAULT NULL,
  `validity_end` varchar(45) DEFAULT NULL,
  `pos_payment_type` text,
  `serial_prefix` varchar(45) DEFAULT NULL,
  `store_marquee` blob,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `pos_table_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `table_id` varchar(45) DEFAULT NULL,
  `sub_table` varchar(45) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `cust_name` varchar(225) DEFAULT NULL,
  `cust_mobile` varchar(45) DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `order_product` longblob,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `start_time` varchar(45) DEFAULT NULL,
  `close_time` varchar(45) DEFAULT NULL,
  `order_status` varchar(45) DEFAULT 'Hold',
  `complete_order_id` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `pos_topping_master` (
  `topping_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `topping_name` varchar(225) DEFAULT NULL,
  `topping_price` decimal(15,2) DEFAULT '0.00',
  `product_list` blob,
  `del_status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`topping_id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

CREATE TABLE `vendor_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) DEFAULT NULL,
  `vendor_code` varchar(45) DEFAULT NULL,
  `firm_owner` varchar(225) DEFAULT NULL,
  `firm_name` varchar(225) DEFAULT NULL,
  `mobile` varchar(45) DEFAULT NULL,
  `email` varchar(225) DEFAULT NULL,
  `gst_number` varchar(45) DEFAULT NULL,
  `pan_number` varchar(45) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `del_status` tinyint(4) DEFAULT '1',
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `added_by` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

CREATE TABLE `vendor_invoice_detail` (
  `invoice_rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `invoice_type` varchar(45) DEFAULT NULL,
  `invoice_number` varchar(45) DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modify` varchar(45) DEFAULT 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
  `live_rec_id` varchar(45) DEFAULT NULL,
  `sync_status` tinyint(4) DEFAULT '0',
  `debit_amount` decimal(15,2) DEFAULT NULL,
  PRIMARY KEY (`invoice_rec_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

CREATE TABLE `vendor_invoice_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_rec_id` varchar(45) DEFAULT NULL,
  `store_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `pro_size` varchar(45) DEFAULT NULL,
  `pro_qty` int(11) DEFAULT NULL,
  `pro_mrp` decimal(15,2) DEFAULT NULL,
  `pro_purchase` decimal(15,2) DEFAULT NULL,
  `pro_selling` decimal(15,2) DEFAULT NULL,
  `bin_location` text,
  `shelf_life` text,
  `batch_number` text,
  `cgst_tax` decimal(15,2) DEFAULT NULL,
  `sgst_tax` decimal(15,2) DEFAULT NULL,
  `igst_tax` decimal(15,2) DEFAULT NULL,
  `total_gst` decimal(15,2) DEFAULT NULL,
  `sub_total` decimal(15,2) DEFAULT NULL,
  `total_amount` decimal(15,2) DEFAULT NULL,
  `cgstTaxAmt` decimal(15,2) DEFAULT NULL,
  `sgstTaxAmt` decimal(15,2) DEFAULT NULL,
  `igstTaxAmt` decimal(15,2) DEFAULT NULL,
  `taxAmount` decimal(15,2) DEFAULT NULL,
  `net_amount` decimal(15,2) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modify` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

CREATE TABLE `vendor_payment_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_id` int(11) DEFAULT NULL,
  `invoice_rec_id` varchar(45) DEFAULT NULL,
  `transaction_type` varchar(45) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT '0.00',
  `payment_type` varchar(45) DEFAULT NULL,
  `transaction_id` varchar(45) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `sync_status` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;