DROP TABLE IF EXISTS business_limit;
CREATE TABLE business_limit (
  entity_id int(11) NOT NULL AUTO_INCREMENT,
  entity_type varchar(15) CHARACTER SET utf8 NOT NULL,
  entity_limit int(11) NOT NULL,
  trans_type varchar(1) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (entity_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS app_integrations;
CREATE TABLE app_integrations (
 auto_inc int(11) NOT NULL AUTO_INCREMENT,
 app_id varchar(45) NOT NULL,
 app_name varchar(20) NOT NULL,
 app_status varchar(15) NOT NULL,
 app_settings text NOT NULL,
 date_created datetime NOT NULL,
 last_modified datetime NOT NULL,
 PRIMARY KEY (auto_inc)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS billsapp_invoices;
CREATE TABLE billsapp_invoices (
 auto_inc int(11) NOT NULL AUTO_INCREMENT,
 order_no varchar(45) NOT NULL,
 public_id varchar(15) NOT NULL,
 mobile_no varchar(15) NOT NULL,
 status varchar(15) NOT NULL DEFAULT 'pending',
 server_receipt_no varchar(45) NOT NULL,
 date_created datetime NOT NULL,
 delivered_datetime datetime NOT NULL,
 send_datetime datetime NOT NULL,
 read_datetime datetime NOT NULL,
 PRIMARY KEY (auto_inc)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS purchase_invoices;
CREATE TABLE purchase_invoices (
 auto_inc int(11) NOT NULL AUTO_INCREMENT,
 transaction_id varchar(45) NOT NULL,
 invoice_no varchar(45) NOT NULL,
 reference_no varchar(45) NOT NULL,
 product_info text NOT NULL,
 total_amount double NOT NULL,
 sub_total double NOT NULL,
 total_taxes double NOT NULL,
 tax_info text NOT NULL,
 vendor_id varchar(5) NOT NULL,
 purchase_date date NOT NULL,
 date_created datetime NOT NULL,
 last_modified datetime NOT NULL,
 PRIMARY KEY (auto_inc)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS label_templates;
CREATE TABLE label_templates (
 auto_inc int(11) NOT NULL AUTO_INCREMENT,
 label_id varchar(45) NOT NULL,
 name varchar(45) DEFAULT NULL,
 type varchar(15) DEFAULT NULL,
 theme varchar(115) DEFAULT NULL,
 settings text,
 default_template varchar(10) NOT NULL DEFAULT 'NO',
 date_created datetime NOT NULL,
 last_modified datetime NOT NULL,
 PRIMARY KEY (auto_inc),
 UNIQUE KEY label_id (label_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS calculated_json_product;
CREATE TABLE calculated_json_product (
	id INT(11) NOT NULL AUTO_INCREMENT,
	prc VARCHAR(10) NOT NULL,
	sku VARCHAR(115) NOT NULL,
	barcode VARCHAR(105) NOT NULL,
	name VARCHAR(225) NOT NULL,
	category_id VARCHAR(10) NOT NULL,
	json_data TEXT NOT NULL,
	last_modified DATETIME NOT NULL,
	PRIMARY KEY (prc),
	UNIQUE INDEX id (id ASC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS device_sync;
CREATE TABLE IF NOT EXISTS device_sync (
 id int(11) NOT NULL AUTO_INCREMENT,
 device_key varchar(115) NOT NULL,
 tables varchar(115) NOT NULL,
 event_name varchar(115) NOT NULL,
 row_id varchar(115) NOT NULL,
 sync_script text NOT NULL,
 created_datetime datetime NOT NULL,
 sync_datetime datetime NOT NULL,
 status varchar(45) NOT NULL,
 remark text NOT NULL,
 PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS devices;
CREATE TABLE IF NOT EXISTS  devices (
 id int(11) NOT NULL AUTO_INCREMENT,
 device_name varchar(115) NOT NULL,
 device_type varchar(115) NOT NULL,
 device_key varchar(115) NOT NULL,
 device_uniqueKey varchar(115) NOT NULL,
 device_info text NOT NULL,
 registered_datetime datetime NOT NULL,
 status varchar(45) NOT NULL,
 remark text NOT NULL,
 last_modified datetime NOT NULL,
 PRIMARY KEY (id),
 UNIQUE KEY device_uniqueKey (device_uniqueKey)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS canceled_invoice;
CREATE TABLE canceled_invoice (
  id int(11) NOT NULL AUTO_INCREMENT,
  prepared_by varchar(20) NOT NULL,
  invoice_no varchar(20) NOT NULL,
  product_info text NOT NULL,
  sub_total double NOT NULL,
  total double NOT NULL,
  tax_amount double NOT NULL,
  discount_info text NOT NULL,
  discount_amount double NOT NULL,
  invoice_date datetime NOT NULL,
  status varchar(20) NOT NULL,
  payment_method varchar(20) NOT NULL,
  payment_info text NOT NULL,
  notes text NOT NULL,
  profit double NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS closing_balance;
CREATE TABLE closing_balance (
  id int(11) NOT NULL AUTO_INCREMENT,
  transaction_id varchar(45) NOT NULL,
  transaction_date datetime NOT NULL,
  closing_balance double NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS customer_invoice;
CREATE TABLE customer_invoice(
  id int(11) NOT NULL AUTO_INCREMENT,
  prepared_by varchar(3) NOT NULL,
  sales_user varchar(115) NOT NULL,
  customer_info varchar(25) NOT NULL,
  order_no varchar(30) NOT NULL,
  invoice_no varchar(50) NOT NULL,
  product_info text NOT NULL,
  total_item int(11) NOT NULL,
  sub_total double NOT NULL,
  total double NOT NULL,
  tax_amount double NOT NULL,
  discount_info text NOT NULL,
  discount_amount double NOT NULL,
  invoice_date datetime NOT NULL,
  status varchar(20) NOT NULL DEFAULT 'PAID' COMMENT 'PAID,CANCELLED,PARTIAL REFUND,FULL REFUND',
  payment_method varchar(20) NOT NULL,
  payment_info text NOT NULL,
  remark text NOT NULL,
  profit double NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (order_no),
  UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
  id int(11) NOT NULL AUTO_INCREMENT,
  connection_id varchar(24) NOT NULL,
  fname varchar(45) NOT NULL,
  lname varchar(45) NOT NULL,
  mobile_no varchar(20) NOT NULL,
  email_id varchar(115) NOT NULL,
  address text NOT NULL,
  notes varchar(225) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY connection_id (connection_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS events_logs;
CREATE TABLE events_logs (
  id int(11) NOT NULL AUTO_INCREMENT,
  device text NOT NULL,
  user_id varchar(45) NOT NULL,
  events_name varchar(225) NOT NULL,
  event_desc text NOT NULL,
  event_time datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS general_settings;
CREATE TABLE general_settings (
  type varchar(25) NOT NULL,
  param text NOT NULL,
  action varchar(9) NOT NULL DEFAULT 'pending',
  last_modified datetime NOT NULL,
  PRIMARY KEY (type)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS invoice_items;
CREATE TABLE invoice_items (
  id int(11) NOT NULL AUTO_INCREMENT,
  type varchar(10) NOT NULL DEFAULT 'SALE' COMMENT 'SALE,REFUND',
  ref_no varchar(30) NOT NULL,
  prc int(11) NOT NULL,
  name varchar(45) NOT NULL,
  product_info text NOT NULL,
  selling_info text NOT NULL,
  purchase_info text NOT NULL,
  discount_info text NOT NULL,
  total_tax double NOT NULL,
  sold_rate double NOT NULL COMMENT 'Per Quantity',
  discount_amount double NOT NULL COMMENT 'Per Quantity',
  quantity int(11) NOT NULL,
  amount_sold double NOT NULL COMMENT 'Overall Amount With Discount + Taxes',
  profit double NOT NULL,
  invoice_date datetime NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS invoice_templates;
CREATE TABLE invoice_templates (
  id varchar(15) CHARACTER SET utf8 NOT NULL,
  name varchar(45) CHARACTER SET utf8 NOT NULL,
  type varchar(15) CHARACTER SET utf8 NOT NULL,
  theme VARCHAR(115) CHARACTER SET utf8 NOT NULL,
  default_template varchar(3) NOT NULL DEFAULT 'no',
  system_default varchar(3) NOT NULL DEFAULT 'no',
  settings text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS notification;
CREATE TABLE notification (
  sr_no int(11) NOT NULL AUTO_INCREMENT,
  type varchar(45) NOT NULL,
  attributes text NOT NULL,
  created_time datetime NOT NULL,
  status varchar(45) NOT NULL,
  logs text NOT NULL,
  PRIMARY KEY (sr_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS pos_users;
CREATE TABLE pos_users (
  user_id int(11) NOT NULL AUTO_INCREMENT,
  owner_id varchar(45) NOT NULL,
  name varchar(45) NOT NULL,
  username varchar(45) NOT NULL,
  password varchar(45) NOT NULL,
  restriction text CHARACTER SET utf8 NOT NULL,
  type varchar(45) NOT NULL,
  status varchar(11) NOT NULL,
  deletable varchar(4) NOT NULL DEFAULT 'yes',
  employee_id VARCHAR(115) NOT NULL , 
  employee_id_login VARCHAR(15) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS product_category;
CREATE TABLE product_category (
  id int(11) NOT NULL AUTO_INCREMENT,
  parent_id int(11) NOT NULL,
  name varchar(115) NOT NULL,
  description varchar(225) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS product_stock;
CREATE TABLE product_stock (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(225) NOT NULL,
  product_code varchar(45) NOT NULL,
  quantity_credit int(11) NOT NULL,
  quantity_debit int(11) NOT NULL,
  vendor_customer varchar(15) NOT NULL,
  ref_no varchar(115) NOT NULL,
  type varchar(50) NOT NULL COMMENT 'SALE, PURCHASE, DAMAGED',
  last_modified datetime NOT NULL,
  remark text NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS products;
CREATE TABLE products (
  id int(11) NOT NULL AUTO_INCREMENT,
  upc_code varchar(45) NOT NULL,
  name varchar(225) CHARACTER SET utf8 NOT NULL,
  sku varchar(45) CHARACTER SET utf8 NOT NULL,
  barcode varchar(45) CHARACTER SET utf8 NOT NULL,
  img varchar(225) NOT NULL,
  uom varchar(45) NOT NULL,
  quantity varchar(10) NOT NULL,
  hsn_code varchar(25) NOT NULL,
  brand varchar(45) NOT NULL,
  category_id int(12) NOT NULL,
  purchase_price double NOT NULL,
  purchase_tax_type varchar(3) NOT NULL,
  tax_id_purchase varchar(15) NOT NULL,
  selling_price double NOT NULL,
  selling_tax_type varchar(3) NOT NULL,
  tax_id varchar(15) CHARACTER SET utf8 NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY sku (sku)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS promotional_product;
CREATE TABLE promotional_product (
  sku varchar(15) CHARACTER SET utf8 NOT NULL,
  type varchar(25) CHARACTER SET utf8 NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (sku)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS purchase_history;
CREATE TABLE purchase_history (
  transaction_id varchar(15) NOT NULL,
  transaction_date datetime NOT NULL,
  transaction_amount double NOT NULL,
  order_id varchar(18) NOT NULL,
  invoice_no varchar(12) NOT NULL,
  product_type varchar(20) NOT NULL,
  product_id varchar(45) NOT NULL,
  product_details text NOT NULL,
  status varchar(15) NOT NULL,
  history_logs text NOT NULL,
  PRIMARY KEY (transaction_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS receipt_template;
CREATE TABLE receipt_template (
  id varchar(15) CHARACTER SET utf8 NOT NULL,
  name varchar(45) CHARACTER SET utf8 NOT NULL,
  type varchar(15) CHARACTER SET utf8 NOT NULL,
  theme VARCHAR(115) CHARACTER SET utf8 NOT NULL,
  default_template varchar(3) NOT NULL DEFAULT 'no',
  system_default varchar(3) NOT NULL DEFAULT 'no',
  settings text CHARACTER SET utf8 NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS refund_receipts;
CREATE TABLE refund_receipts (
  prepared_by int(11) NOT NULL,
  customer_info int(11) NOT NULL,
  refund_id varchar(30) NOT NULL,
  refund_no varchar(45) NOT NULL,
  refund_date datetime NOT NULL,
  ref_no varchar(30) NOT NULL,
  product_description text NOT NULL,
  total_amount double NOT NULL,
  reason text NOT NULL,
  remark text NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (refund_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS stock_transaction_receipt;
CREATE TABLE stock_transaction_receipt (
  id int(11) NOT NULL AUTO_INCREMENT,
  transaction_id varchar(30) NOT NULL,
  prepared_by varchar(20) NOT NULL,
  vendor_info varchar(25) NOT NULL,
  receipt_no varchar(20) NOT NULL,
  product_info text NOT NULL,
  receipt_date datetime NOT NULL,
  type varchar(20) NOT NULL,
  remark text NOT NULL,
  notes TEXT NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (receipt_no),
  UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS tax_details;
CREATE TABLE tax_details (
  id int(11) NOT NULL AUTO_INCREMENT,
  tax_type varchar(10) CHARACTER SET utf8 NOT NULL,
  tax_label_name varchar(65) NOT NULL,
  tax_name varchar(45) NOT NULL,
  tax_number varchar(20) NOT NULL,
  tax_percent double NOT NULL,
  tax_desc varchar(45) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS tax_transaction;
CREATE TABLE tax_transaction (
  trans_id int(11) NOT NULL AUTO_INCREMENT,
  ref_no varchar(45) NOT NULL,
  prc varchar(45) NOT NULL,
  tax_id int(11) NOT NULL,
  tax_name varchar(45) NOT NULL,
  tax_type varchar(10) NOT NULL,
  tax_rate double NOT NULL,
  tax_basis double NOT NULL,
  tax_amount double NOT NULL,
  status varchar(10) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (trans_id),
  KEY FK_key (ref_no)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS uom;
CREATE TABLE uom (
  id int(11) NOT NULL AUTO_INCREMENT,
  master_id INT(11) NOT NULL,
  name varchar(115) CHARACTER SET utf8 NOT NULL,
  parent_category varchar(115) CHARACTER SET utf8 NOT NULL,
  type varchar(50) CHARACTER SET utf8 NOT NULL,
  symbol varchar(10) CHARACTER SET utf8 NOT NULL,
  measurement_value varchar(20) CHARACTER SET utf8 NOT NULL,
  default_uom varchar(115) CHARACTER SET utf8 NOT NULL,
  last_updated datetime NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS user_app;
CREATE TABLE user_app (
  id int(11) NOT NULL AUTO_INCREMENT,
  package_id varchar(25) CHARACTER SET utf8 NOT NULL,
  valid_from datetime NOT NULL,
  valid_to datetime NOT NULL,
  purchase_info text NOT NULL,
  app_info text NOT NULL,
  status varchar(15) NOT NULL,
  installed_on datetime NOT NULL,
  history_logs text NOT NULL,
  app_settings text NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY package_id (package_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS user_wallet;
CREATE TABLE user_wallet (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  reference_id varchar(45) CHARACTER SET utf8 NOT NULL,
  type varchar(25) CHARACTER SET utf8 NOT NULL COMMENT 'deduction,refund,transfer,order',
  accounting varchar(3) NOT NULL,
  amount double NOT NULL,
  description text CHARACTER SET utf8 NOT NULL COMMENT 'note',
  last_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS vendors;
CREATE TABLE vendors (
  id int(11) NOT NULL AUTO_INCREMENT,
  connection_id varchar(24) NOT NULL,
  company_name varchar(225) NOT NULL,
  fname varchar(45) NOT NULL,
  lname varchar(45) NOT NULL,
  mobile_no varchar(20) NOT NULL,
  email_id varchar(115) NOT NULL,
  address text NOT NULL,
  gstin varchar(20) NOT NULL,
  notes varchar(225) NOT NULL,
  last_modified datetime NOT NULL,
  PRIMARY KEY (id),
  UNIQUE KEY connection_id (connection_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*------------------------------- Trigger (delete_event_customerInvoice) -----------------------------------------------*/
DROP TRIGGER IF EXISTS delete_event_customerInvoice;
CREATE TRIGGER delete_event_customerInvoice AFTER DELETE ON customer_invoice FOR EACH ROW BEGIN
    DELETE FROM tax_transaction WHERE ref_no = old.order_no;
    DELETE FROM invoice_items WHERE ref_no = old.order_no;
END;
/*--------------------------------- Trigger (void_action_of_customer_invoices) ---------------------------------------------*/
DROP TRIGGER IF EXISTS void_action_of_customer_invoices;
CREATE TRIGGER void_action_of_customer_invoices AFTER UPDATE ON customer_invoice FOR EACH ROW BEGIN
update tax_transaction set status='void' where ref_no=old.order_no and new.status='void';
END;
/*------------------------------------ Trigger (wallet_adjustments) ------------------------------------------*/
DROP TRIGGER IF EXISTS wallet_adjustments;
CREATE TRIGGER wallet_adjustments AFTER INSERT ON user_wallet FOR EACH ROW BEGIN
Declare available_balance Double;
SET available_balance:=(SELECT IFNULL(sum(closing_balance),0) from closing_balance where id=(SELECT max(id) FROM closing_balance));
IF NEW.accounting = 'CR' THEN
INSERT INTO closing_balance(transaction_id, transaction_date, closing_balance) VALUES(New.reference_id,new.last_modified,round(available_balance+NEW.amount,2));
ELSE
INSERT INTO closing_balance(transaction_id, transaction_date, closing_balance) VALUES(New.reference_id,new.last_modified,round(available_balance-NEW.amount,2));
END IF;
END;
/*----------------------------------------------------Database Filling -----------------------------------------*/
/*---------------------------general_settings--------------------------------*/
INSERT INTO general_settings (type, param, action, last_modified) VALUES
('general_setting', '{\"date-format\":\"d-M,Y\",\"time-format\":\"h:i:s A\",\"pos\":{\"pricing_including_taxes\":\"on\",\"quick_pay\":\"on\",\"maxDiscount\":\"10\",\"payment_method\":{\"cash\":\"on\",\"card\":\"on\",\"other\":\"on\"},\"other_payment_options\":[\"Gift Card\"],\"stock\":{\"real_time_transaction\":\"on\",\"minus_stock_selling\":\"on\"}}}', 'pending', ''),
('stock_adding_reasons', '[\"Stock Found\"]', 'pending', ''),
('stock_removing_reasons', '[\"Stock Lost\"]', 'pending', ''),
('invoice', '{\"invoice-prefix\":\"\",\"invoice-standard\":\"00001\",\"date-format\":\"d-M,Y\",\"time-format\":\"h:i:s A\",\"default-pos-printer\":\"5B2D2E586BA2E|pos\",\"default-desk-printer\":\"5B2D2DCC9E51A|desk\"}', 'pending', ''),
('receipt', '{\"receipt-prefix\":\"\",\"receipt-standard\":\"00001\",\"default-pos-printer\":\"5B2D312214609|pos\",\"default-desk-printer\":\"5B2D2F4A5D4BD|desk\",\"date-format\":\"d-M,Y\",\"time-format\":\"h:i:s A\"}', 'pending', ''),
('void_reasons', '[{\"reason\":\"Defective Goods\",\"stock_action\":\"minus\"},{\"reason\":\"Retuned Goods\",\"stock_action\":\"add\"}]', 'pending', '');
/*---------------------------invoice_templates--------------------------------*/
INSERT INTO invoice_templates (id, name, type, theme, default_template, system_default, settings, last_modified) VALUES
('5B2D2DCC9E51A', 'Modern Elegant Sales Theme', 'desk-printer', 'theme-D001', 'no', 'no', '{\"printer_name\":\"Modern Elegant Sales Theme\",\"paper_size\":\"A4\",\"font_style\":\"standard\",\"logo_img\":\"\",\"show_amount_recieved_customer\":\"on\",\"display_time\":\"on\",\"show_order_id\":\"on\",\"show_orderid_barcode\":\"on\",\"cashier_info\":\"on\",\"customer_info\":{\"display\":\"on\",\"mobile\":\"on\",\"address\":\"on\"},\"column\":{\"sr_no\":{\"value\":\"Sr.\",\"enable\":\"on\"},\"item_name\":{\"value\":\"Product Description\",\"enable\":\"on\"},\"rate\":{\"value\":\"Rate\",\"enable\":\"on\"},\"tax_rate\":{\"value\":\"Tax Rate\",\"enable\":\"on\"},\"tax_amount\":{\"value\":\"Tax Amount\",\"enable\":\"on\"},\"quantity\":{\"value\":\"Qty\",\"enable\":\"on\"},\"amount\":{\"value\":\"Amount\",\"enable\":\"on\"},\"hsn_code\":{\"enable\":\"on\"}},\"footer\":{\"text\":\"\"}}', ''),
('5B2D2E586BA2E', 'Basic Sales Theme', 'pos-printer', 'theme-P001', 'no', 'no', '{\"printer_name\":\"Basic Sales Theme\",\"paper_size\":\"80mm\",\"font_style\":\"standard\",\"logo_img\":\"\",\"display_time\":\"on\",\"show_order_id\":\"on\",\"show_orderid_barcode\":\"on\",\"cashier_info\":\"on\",\"customer_info\":{\"display\":\"on\",\"mobile\":\"on\",\"address\":\"on\"},\"column\":{\"hsn_code\":{\"value\":\"Hsn Code\"},\"tax_rate\":{\"value\":\"Tax Amount\"},\"rate\":{\"value\":\"Rate\",\"enable\":\"on\"},\"quantity\":{\"value\":\"Qty\",\"enable\":\"on\"},\"amount\":{\"value\":\"Amount\",\"enable\":\"on\"}},\"footer\":{\"text\":\"\"}}', '');
/*---------------------------receipt_template--------------------------------*/
INSERT INTO receipt_template (id, name, type, theme, default_template, system_default, settings, last_modified) VALUES
('5B2D2F4A5D4BD', 'Modern Elegant Receipt Theme', 'desk-printer', 'theme-R-D001', 'no', 'no', '{\"printer_name\":\"Modern Elegant Receipt Theme\",\"paper_size\":\"A4\",\"font_style\":\"standard\",\"logo_img\":\"\",\"display_date_added\":\"on\",\"show_order_id\":\"on\",\"show_orderid_barcode\":\"on\",\"cashier_info\":\"on\",\"vendor_info\":{\"display\":\"on\",\"mobile\":\"on\",\"address\":\"on\"},\"column\":{\"sr_no\":{\"value\":\"Sr.\",\"enable\":\"on\"},\"item_name\":{\"value\":\"Product Description\",\"enable\":\"on\"},\"quantity\":{\"value\":\"Qty\"}},\"footer\":{\"text\":\"\"}}', ''),
('5B2D312214609', 'Basic Receipt Theme', 'pos-printer', 'theme-R-P001', 'no', 'no', '{\"printer_name\":\"Basic Receipt Theme\",\"paper_size\":\"80mm\",\"font_style\":\"standard\",\"logo_img\":\"\",\"display_date_added\":\"on\",\"display_time\":\"on\",\"show_transaction_id\":\"on\",\"show_transaction_barcode\":\"on\",\"cashier_info\":\"on\",\"vendor_info\":{\"display\":\"on\",\"mobile\":\"on\",\"address\":\"on\"},\"column\":{\"sr_no\":{\"value\":\"Sr.\",\"enable\":\"on\"},\"item_name\":{\"value\":\"Product\",\"enable\":\"on\"},\"quantity\":{\"value\":\"Qty\",\"enable\":\"on\"}},\"footer\":{\"text\":\"\"}}', '');