-- Table structure for table `phppos_sessions`
--

CREATE TABLE `phppos_sessions` (
  `id` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` longblob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phppos_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_sessions`
--

INSERT INTO `phppos_sessions` VALUES ('01k23b2ihtu9e94p5gdblvbepuacdlo8','190.36.9.159',1618413234,_binary '[binary data, 8333 characters]'),('06540ijhs0hm13jepqo0evku6ogv89ed','190.36.9.159',1618345315,''),('08fultrsgcopu5lbej29h6tqapd4fj5u','190.36.9.159',1618432488,_binary '[binary data, 6350 characters]'),('097mles0ncdq76i2rk6cbrrejg58lm9i','190.36.9.159',1618578702,''),('0h1bughimc0piqi4mm08gai5sa8jb0iu','190.37.219.245',1617633164,''),('0nu6bqulve4hla9ke1u1eujt40gj7ctr','190.200.0.147',1619441610,''),('0ork286149if0g5uvaen2i2o54bkisd7','190.36.9.159',1619268752,''),('10jeqgjq4o7pgdn26kq4q76rd0ulddqp','190.36.9.159',1618578705,''),('1aulv488innthp9obcqjk8sgmrktks99','190.36.9.159',1618517608,_binary '[binary data, 6350 characters]'),('1ifikvvdc96dsb6e0r00dkohh6k10dq8','190.37.216.58',1619705723,_binary '[binary data, 6332 characters]'),('1nh8cb1uvgsahaeu5npmbpn2dtreosdm','192.168.1.142',1618333734,_binary 'person_id|s:1:\"1\";'),('3238ce5af84u8k8a3rvjaa3h5bumkr6r','190.200.0.147',1619441723,''),('3p92a25ufgsrpgbgm2lu2vlfg98l9c37','190.37.107.217',1618360829,''),('4cv6auf4300m2bkq3nir6etpmaal6v49','192.168.1.12',1616520264,_binary '[binary data, 6350 characters]'),('4id4l0ksoha57460ur17qn0jnv3tp2lh','190.200.0.147',1619469942,_binary '[binary data, 6350 characters]'),('5mvalm0crp34lpcearv1k8ck841jv5om','190.36.9.159',1618578711,''),('5q9v7fea987dssj661tc46n0obadf2si','190.36.19.29',1618929362,''),('69fr8m8rqthe2cb594iotsvgb74ofsmq','192.168.0.110',1616490038,_binary 'person_id|s:1:\"1\";'),('6bahvlkp1lfbhopcv0kt6800477053si','192.168.1.1',1618333762,''),('6e9athd6i00tgfi6caimvhjph5jgbbl6','190.36.2.29',1620328735,_binary 'person_id|s:1:\"1\";keep_alive|i:1620328735;'),('6fbpditrdkf99oijjiqgop8jg7p8t5r3','190.36.9.159',1618840639,_binary '[binary data, 6332 characters]'),('77519cvnbs38c2nc4e481h39vcrt4on9','190.37.216.58',1619624434,_binary '[binary data, 6332 characters]'),('77meo43rlruks4s91h5p5qchng1v8qfs','192.168.1.1',1618333799,''),('79aitm1q3is536a07d5rqernfgbddhit','190.37.216.58',1619727173,_binary '[binary data, 6350 characters]'),('7v11tddlc6hdr1cbl6efm0p8eq5bfqel','190.37.216.58',1619630612,_binary '[binary data, 6332 characters]'),('9dagpm3c3afi8kj0ek07ouaen9sioig6','190.37.216.58',1619554138,_binary '[binary data, 6350 characters]'),('a1p6jv963tpmqnc074b6505qbs3t4jk0','190.200.0.147',1619441742,''),('afchketutgtgmpjeld7nkrmmnuh80i91','190.200.0.147',1619536233,_binary '[binary data, 6332 characters]'),('alrq40e4pqvu2aad2luob8sibitj49j4','190.36.2.29',1621091871,''),('apb6are36b7p7ht4qssjkn0tbem736i8','190.36.9.159',1618336282,''),('ar4dc87p6pf97jek51ok5n1p5ch5ht3t','190.200.0.147',1619442233,_binary '[binary data, 6311 characters]'),('cimv7lg2cmrv070vglthe8o9htu2174f','190.37.216.58',1619641446,_binary '[binary data, 6350 characters]'),('cjt3mugnpu4bajclsfqalse8e5a4vduu','190.200.0.147',1619441621,''),('cs9lmqgnr07ivgh1hliglneq68n4t62o','190.200.6.11',1618374156,_binary 'person_id|s:1:\"1\";keep_alive|i:1618373636;'),('dgb71tmag90u37dvogqs0h9uli80djtt','190.36.9.159',1619101911,_binary '[binary data, 6332 characters]'),('dgelfl9apiqqoqmj39nnl68oaoldt7pd','190.36.9.159',1618672188,_binary '[binary data, 6332 characters]'),('dnue3i5c8c2plas9a8n83agato94fat7','192.168.1.111',1619020170,_binary 'person_id|s:1:\"1\";'),('dt5dm6fahb9buv6sgt6mj4f8gnaa18f4','190.36.9.159',1619268756,''),('e31qbnragsjdno5ptjtn2hd7k61lg96u','190.37.219.245',1616545239,_binary 'person_id|s:1:\"1\";'),('e52hncthhclhia8l0a05bbmd2ops85u8','190.36.9.159',1618516277,_binary '[binary data, 6332 characters]'),('elaeeb65bs0j4orf2cm74n0611hlhci1','190.36.9.159',1618412011,''),('elnkmkqekeg6t8si4k4nmlqenke31q5c','190.36.9.159',1619283690,_binary '[binary data, 6352 characters]'),('fmbhv2bs72pvrapmua8kvn4jtcjapm3c','190.36.9.159',1619268750,''),('g2spclp2sm6o47sblhsn336vfcki5mdo','190.36.9.159',1618847059,_binary '[binary data, 6332 characters]'),('gc2ff20jb28duvg1nnurmf9ad8o2btag','190.36.9.159',1619193840,_binary '[binary data, 6331 characters]'),('gg7uiica5vfrhoog7m9ns9koqj9fh8ln','190.36.9.159',1619109874,_binary '[binary data, 6350 characters]'),('grf04lhq4ok3f74f6fv0h48gqbjma4i7','190.198.166.81',1620408019,_binary '[binary data, 6350 characters]'),('i0ummnvsjv9n168pi5tsvk5f25fsbs19','190.198.189.35',1620650436,_binary '[binary data, 6307 characters]'),('i1ej7pj4bm9ec3fc5plm6uk1i1cfh8s3','190.36.9.159',1618413297,_binary '[binary data, 6219 characters]'),('i2s1eukis7pdmjh0gt0ssk06grdpa79m','190.36.9.159',1618584306,_binary '[binary data, 8871 characters]'),('i9e5a9gc85qp329ha1qrgrl6trebha6l','190.37.216.58',1619813819,_binary '[binary data, 6350 characters]'),('irulftjd9ebrh3bvrks94plc8juo61as','190.198.166.81',1620391820,''),('j1s6u5dl016ct999aog7tuso347sf2nu','190.36.9.159',1619186582,_binary '[binary data, 10284 characters]'),('j8seukm63p353fn6rav1tgvedtr9ibd8','190.36.9.159',1619195097,_binary '[binary data, 6322 characters]'),('jbv7pb0k8njh63ukatkvticpg684gd5k','190.36.9.159',1618578708,''),('jtkm3csa7782tc8tj042cdm64kivn9s2','190.198.189.35',1620998044,''),('k00vitud3lkn399ts21m6lkn2jp2tmk3','192.168.1.11',1616519767,_binary '[binary data, 11567 characters]'),('ko6p523e29bi0ru0945na40r6thhet2f','190.36.9.159',1618578710,''),('ko7di15q79avbscfi86rcagccuan5kgr','190.36.9.159',1618688242,_binary '[binary data, 6331 characters]'),('m4nrjtmfldhj0fujkrpf0dle6b00sn7q','192.168.1.12',1616429209,_binary '[binary data, 6350 characters]'),('m8ifd7uk7v857754cirah6nf2aknrnho','190.36.9.159',1619269030,_binary '[binary data, 6332 characters]'),('mpce171tg23fqll8i562mmaqural5cc5','190.37.219.245',1618063962,''),('n2ae42q5f1gbsldm49ncrkog06pdma95','190.36.9.159',1618498644,_binary '[binary data, 6313 characters]'),('navir3a5ol6mfd1816376egp0hqad915','190.198.166.81',1620407365,_binary '[binary data, 6332 characters]'),('njs2mam8sie743ah4cs1cukpb11h43vi','190.37.216.58',1619899215,_binary '[binary data, 6352 characters]'),('nrpfdftthhdvqhqkub5euv8t3q6b0kn8','190.36.9.159',1618335953,''),('ovc1ndgh927fsls1ifa2n0nfblndjpg0','190.200.0.147',1619449339,_binary '[binary data, 6332 characters]'),('pchgiqcrgc532d83vqedla5mlndfdb9p','190.200.0.147',1619441692,''),('puohk93gf4t9ds55e72902a46rf82fa9','190.36.9.159',1618423051,_binary '[binary data, 6330 characters]'),('q3oin1bh8p9abb5tam8rm0pso5ev1o72','190.37.216.58',1619615721,_binary '[binary data, 6332 characters]'),('q8880uci0u0s4u4f7cvdf1g826ug10e3','190.37.216.58',1619536459,_binary 'person_id|s:2:\"10\";'),('qfm2b8e46l5usuqbriccbe0ng701obbt','190.36.9.159',1618414056,_binary '[binary data, 6219 characters]'),('r75ucs7rbnpl0hrrmouu8tl37bojob2g','190.36.19.29',1618669994,''),('r7u4b6rqhbi1j105ko8qmbdeke43296o','190.36.9.159',1618414664,_binary '[binary data, 6219 characters]'),('sh5lrjkcvhtvskhkopbo2ekst5td0lph','190.36.9.159',1618586095,''),('sptb70mum4hm6rrrme8j75avmhtmpg91','190.36.9.159',1618848717,_binary '[binary data, 6332 characters]'),('te71hcsss0pr004q9p9ou8o6rrq0c2o8','190.36.9.159',1618935452,_binary '[binary data, 6350 characters]'),('tnv7c0eh00123u269ijqev491kh5udl4','190.198.166.81',1620396934,_binary '[binary data, 8321 characters]'),('u3kfkrno9h23iubd4he4ging2a12b368','190.36.9.159',1618413555,_binary '[binary data, 6219 characters]'),('umvj4lp5dc4o3rf1cg5i3fn5djrvimp5','190.36.9.159',1619268754,''),('vh620sjkngpd4oijs98u7nd4umr4sonr','192.168.1.125',1619453609,_binary 'person_id|s:1:\"1\";keep_alive|i:1618845828;'),('vm54vvfp6elon7mhhpsh2ktgt6usuaku','190.37.219.245',1617132954,_binary 'person_id|s:1:\"1\";keep_alive|i:1617132954;items_search_data|a:7:{s:6:\"offset\";i:0;s:9:\"order_col\";s:10:\"unit_price\";s:9:\"order_dir\";s:4:\"desc\";s:6:\"search\";s:6:\"Zapato\";s:11:\"category_id\";s:0:\"\";s:6:\"fields\";s:3:\"all\";s:7:\"deleted\";i:0;}'),('vn37a6m3rkaqemnpgru6hvlu0t815i3c','190.37.216.58',1619811848,_binary '[binary data, 6332 characters]'),('vp7ht3qul0tjfmfgceibm4gksfuq76l1','190.36.9.159',1619104505,_binary '[binary data, 6332 characters]');

--
-- Table structure for table `phppos_shipping_methods`
--

CREATE TABLE `phppos_shipping_methods` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `shipping_provider_id` int(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fee` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `fee_tax_class_id` int(10) DEFAULT NULL,
  `time_in_days` int(11) DEFAULT NULL,
  `has_tracking_number` int(1) NOT NULL DEFAULT '0',
  `is_default` int(1) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `phppos_shipping_methods_ibfk_1` (`shipping_provider_id`),
  KEY `phppos_shipping_methods_ibfk_2` (`fee_tax_class_id`),
  CONSTRAINT `phppos_shipping_methods_ibfk_1` FOREIGN KEY (`shipping_provider_id`) REFERENCES `phppos_shipping_providers` (`id`),
  CONSTRAINT `phppos_shipping_methods_ibfk_2` FOREIGN KEY (`fee_tax_class_id`) REFERENCES `phppos_tax_classes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_shipping_methods`
--


--
-- Table structure for table `phppos_shipping_providers`
--

CREATE TABLE `phppos_shipping_providers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `order` int(10) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_shipping_providers`
--


--
-- Table structure for table `phppos_shipping_zones`
--

CREATE TABLE `phppos_shipping_zones` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fee` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `tax_class_id` int(10) DEFAULT NULL,
  `order` int(10) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `phppos_shipping_zones_ibfk_1` (`tax_class_id`),
  CONSTRAINT `phppos_shipping_zones_ibfk_1` FOREIGN KEY (`tax_class_id`) REFERENCES `phppos_tax_classes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_shipping_zones`
--


--
-- Table structure for table `phppos_store_accounts`
--

CREATE TABLE `phppos_store_accounts` (
  `sno` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) NOT NULL,
  `sale_id` int(11) DEFAULT NULL,
  `transaction_amount` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `balance` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sno`),
  KEY `phppos_store_accounts_ibfk_1` (`sale_id`),
  KEY `phppos_store_accounts_ibfk_2` (`customer_id`),
  CONSTRAINT `phppos_store_accounts_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales` (`sale_id`),
  CONSTRAINT `phppos_store_accounts_ibfk_2` FOREIGN KEY (`customer_id`) REFERENCES `phppos_customers` (`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_store_accounts`
--


--
-- Table structure for table `phppos_store_accounts_paid_sales`
--

CREATE TABLE `phppos_store_accounts_paid_sales` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `store_account_payment_sale_id` int(10) DEFAULT NULL,
  `sale_id` int(10) DEFAULT NULL,
  `partial_payment_amount` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  PRIMARY KEY (`id`),
  KEY `phppos_store_accounts_sales_ibfk_1` (`sale_id`),
  KEY `phppos_store_accounts_sales_ibfk_2` (`store_account_payment_sale_id`),
  CONSTRAINT `phppos_store_accounts_sales_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales` (`sale_id`),
  CONSTRAINT `phppos_store_accounts_sales_ibfk_2` FOREIGN KEY (`store_account_payment_sale_id`) REFERENCES `phppos_sales` (`sale_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_store_accounts_paid_sales`
--


--
-- Table structure for table `phppos_supplier_store_accounts`
--

CREATE TABLE `phppos_supplier_store_accounts` (
  `sno` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(11) NOT NULL,
  `receiving_id` int(11) DEFAULT NULL,
  `transaction_amount` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `balance` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`sno`),
  KEY `phppos_supplier_store_accounts_ibfk_1` (`receiving_id`),
  KEY `phppos_supplier_store_accounts_ibfk_2` (`supplier_id`),
  CONSTRAINT `phppos_supplier_store_accounts_ibfk_1` FOREIGN KEY (`receiving_id`) REFERENCES `phppos_receivings` (`receiving_id`),
  CONSTRAINT `phppos_supplier_store_accounts_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `phppos_suppliers` (`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_supplier_store_accounts`
--


--
-- Table structure for table `phppos_supplier_store_accounts_paid_receivings`
--

CREATE TABLE `phppos_supplier_store_accounts_paid_receivings` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `store_account_payment_receiving_id` int(10) DEFAULT NULL,
  `receiving_id` int(10) DEFAULT NULL,
  `partial_payment_amount` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  PRIMARY KEY (`id`),
  KEY `phppos_supplier_store_accounts_paid_receivings_ibfk_1` (`receiving_id`),
  KEY `phppos_supplier_store_accounts_paid_receivings_ibfk_2` (`store_account_payment_receiving_id`),
  CONSTRAINT `phppos_supplier_store_accounts_paid_receivings_ibfk_1` FOREIGN KEY (`receiving_id`) REFERENCES `phppos_receivings` (`receiving_id`),
  CONSTRAINT `phppos_supplier_store_accounts_paid_receivings_ibfk_2` FOREIGN KEY (`store_account_payment_receiving_id`) REFERENCES `phppos_receivings` (`receiving_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_supplier_store_accounts_paid_receivings`
--


--
-- Table structure for table `phppos_suppliers`
--

CREATE TABLE `phppos_suppliers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `person_id` int(10) NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `account_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `override_default_tax` int(1) NOT NULL DEFAULT '0',
  `balance` decimal(23,10) NOT NULL DEFAULT '0.0000000000',
  `deleted` int(1) NOT NULL DEFAULT '0',
  `tax_class_id` int(10) DEFAULT NULL,
  `custom_field_1_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_2_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_3_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_4_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_5_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_6_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_7_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_8_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_9_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_field_10_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_number` (`account_number`),
  KEY `person_id` (`person_id`),
  KEY `deleted` (`deleted`),
  KEY `phppos_suppliers_ibfk_2` (`tax_class_id`),
  KEY `custom_field_1_value` (`custom_field_1_value`),
  KEY `custom_field_2_value` (`custom_field_2_value`),
  KEY `custom_field_3_value` (`custom_field_3_value`),
  KEY `custom_field_4_value` (`custom_field_4_value`),
  KEY `custom_field_5_value` (`custom_field_5_value`),
  KEY `custom_field_6_value` (`custom_field_6_value`),
  KEY `custom_field_7_value` (`custom_field_7_value`),
  KEY `custom_field_8_value` (`custom_field_8_value`),
  KEY `custom_field_9_value` (`custom_field_9_value`),
  KEY `custom_field_10_value` (`custom_field_10_value`),
  CONSTRAINT `phppos_suppliers_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `phppos_people` (`person_id`),
  CONSTRAINT `phppos_suppliers_ibfk_2` FOREIGN KEY (`tax_class_id`) REFERENCES `phppos_tax_classes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_suppliers`
--


--
-- Table structure for table `phppos_suppliers_taxes`
--

CREATE TABLE `phppos_suppliers_taxes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `supplier_id` int(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `percent` decimal(15,3) NOT NULL,
  `cumulative` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_tax` (`supplier_id`,`name`,`percent`),
  CONSTRAINT `phppos_suppliers_taxes_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `phppos_suppliers` (`person_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_suppliers_taxes`
--


--
-- Table structure for table `phppos_tags`
--

CREATE TABLE `phppos_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ecommerce_tag_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_name` (`name`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_tags`
--


--
-- Table structure for table `phppos_tax_classes`
--

CREATE TABLE `phppos_tax_classes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order` int(10) NOT NULL DEFAULT '0',
  `location_id` int(10) DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ecommerce_tax_class_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `phppos_tax_classes_ibfk_1` (`location_id`),
  CONSTRAINT `phppos_tax_classes_ibfk_1` FOREIGN KEY (`location_id`) REFERENCES `phppos_locations` (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_tax_classes`
--

INSERT INTO `phppos_tax_classes` VALUES (1,1,NULL,0,'Taxes',NULL);

--
-- Table structure for table `phppos_tax_classes_taxes`
--

CREATE TABLE `phppos_tax_classes_taxes` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `order` int(10) NOT NULL DEFAULT '0',
  `tax_class_id` int(10) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `percent` decimal(15,3) NOT NULL,
  `cumulative` int(1) NOT NULL DEFAULT '0',
  `ecommerce_tax_class_tax_rate_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_tax` (`tax_class_id`,`name`,`percent`),
  CONSTRAINT `phppos_tax_classes_taxes_ibfk_1` FOREIGN KEY (`tax_class_id`) REFERENCES `phppos_tax_classes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_tax_classes_taxes`
--


--
-- Table structure for table `phppos_zips`
--

CREATE TABLE `phppos_zips` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `shipping_zone_id` int(10) DEFAULT NULL,
  `order` int(10) NOT NULL DEFAULT '0',
  `deleted` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`),
  UNIQUE KEY `name` (`name`),
  KEY `phppos_zips_ibfk_1` (`shipping_zone_id`),
  CONSTRAINT `phppos_zips_ibfk_1` FOREIGN KEY (`shipping_zone_id`) REFERENCES `phppos_shipping_zones` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `phppos_zips`
--


--
-- Dumping events for database 'sc'
--

--
-- Dumping routines for database 'sc'
--


