(3732,568,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,110000.0000000000,110000.0000000000,0.000,0.0000000000,0.0000000000,110000.0000000000,0.0000000000,110000.0000000000,110000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3732,584,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,0.0000000000,120000.0000000000,120000.0000000000,0.000,0.0000000000,0.0000000000,120000.0000000000,0.0000000000,120000.0000000000,120000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3732,590,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,0.0000000000,45000.0000000000,45000.0000000000,0.000,0.0000000000,0.0000000000,45000.0000000000,0.0000000000,45000.0000000000,45000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(3732,591,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,0.0000000000,45000.0000000000,45000.0000000000,0.000,0.0000000000,0.0000000000,45000.0000000000,0.0000000000,45000.0000000000,45000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(3732,592,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,0.0000000000,35000.0000000000,35000.0000000000,0.000,0.0000000000,0.0000000000,35000.0000000000,0.0000000000,35000.0000000000,35000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,6,NULL,NULL,NULL,0,NULL),(3732,594,NULL,NULL,NULL,'',NULL,2,4.0000000000,4.0000000000,0.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,60000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3733,4,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,12000.0000000000,12000.0000000000,0.000,0.0000000000,0.0000000000,12000.0000000000,0.0000000000,12000.0000000000,12000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3734,181,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,15000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3734,183,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,0.0000000000,25000.0000000000,25000.0000000000,0.000,0.0000000000,0.0000000000,25000.0000000000,0.0000000000,25000.0000000000,25000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3735,76,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,35000.0000000000,35000.0000000000,0.000,0.0000000000,0.0000000000,35000.0000000000,0.0000000000,35000.0000000000,35000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3736,12,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,32200.0000000000,90000.0000000000,90000.0000000000,0.000,0.0000000000,0.0000000000,90000.0000000000,0.0000000000,90000.0000000000,57800.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3737,302,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,105000.0000000000,105000.0000000000,0.000,0.0000000000,0.0000000000,105000.0000000000,0.0000000000,105000.0000000000,105000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3738,50,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,6000.0000000000,6000.0000000000,0.000,0.0000000000,0.0000000000,6000.0000000000,0.0000000000,6000.0000000000,6000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3738,51,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,0.0000000000,8000.0000000000,8000.0000000000,0.000,0.0000000000,0.0000000000,8000.0000000000,0.0000000000,8000.0000000000,8000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3739,606,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,120000.0000000000,120000.0000000000,0.000,0.0000000000,0.0000000000,120000.0000000000,0.0000000000,120000.0000000000,120000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3740,302,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,0.0000000000,105000.0000000000,105000.0000000000,0.000,0.0000000000,0.0000000000,210000.0000000000,0.0000000000,210000.0000000000,210000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3740,535,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,0.0000000000,220000.0000000000,220000.0000000000,0.000,0.0000000000,0.0000000000,440000.0000000000,0.0000000000,440000.0000000000,440000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3740,564,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,90000.0000000000,90000.0000000000,0.000,0.0000000000,0.0000000000,90000.0000000000,0.0000000000,90000.0000000000,90000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3741,142,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,95000.0000000000,95000.0000000000,0.000,0.0000000000,0.0000000000,95000.0000000000,0.0000000000,95000.0000000000,95000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3742,580,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,29000.0000000000,65000.0000000000,65000.0000000000,0.000,0.0000000000,0.0000000000,65000.0000000000,0.0000000000,65000.0000000000,36000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3742,581,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,54500.0000000000,125000.0000000000,125000.0000000000,0.000,0.0000000000,0.0000000000,125000.0000000000,0.0000000000,125000.0000000000,70500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3742,582,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,55000.0000000000,55000.0000000000,0.000,0.0000000000,0.0000000000,55000.0000000000,0.0000000000,55000.0000000000,55000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3743,99,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,0.0000000000,200000.0000000000,200000.0000000000,0.000,0.0000000000,0.0000000000,600000.0000000000,0.0000000000,600000.0000000000,600000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3743,642,NULL,NULL,NULL,'',NULL,1,3.0000000000,3.0000000000,0.0000000000,280000.0000000000,280000.0000000000,0.000,0.0000000000,0.0000000000,840000.0000000000,0.0000000000,840000.0000000000,840000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3744,564,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,90000.0000000000,90000.0000000000,0.000,0.0000000000,0.0000000000,90000.0000000000,0.0000000000,90000.0000000000,90000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3745,284,NULL,NULL,NULL,'',NULL,1,5.0000000000,5.0000000000,0.0000000000,3600.0000000000,3600.0000000000,0.000,0.0000000000,0.0000000000,18000.0000000000,0.0000000000,18000.0000000000,18000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3745,317,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,0.0000000000,48000.0000000000,48000.0000000000,0.000,0.0000000000,0.0000000000,48000.0000000000,0.0000000000,48000.0000000000,48000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(3745,481,NULL,NULL,NULL,'',NULL,0,50.0000000000,50.0000000000,0.0000000000,900.0000000000,900.0000000000,0.000,0.0000000000,0.0000000000,45000.0000000000,0.0000000000,45000.0000000000,45000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3745,594,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,0.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,15000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(3745,772,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,68000.0000000000,160000.0000000000,160000.0000000000,0.000,0.0000000000,0.0000000000,160000.0000000000,0.0000000000,160000.0000000000,92000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3746,379,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,0.0000000000,22000.0000000000,22000.0000000000,0.000,0.0000000000,0.0000000000,44000.0000000000,0.0000000000,44000.0000000000,44000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3747,441,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,100000.0000000000,100000.0000000000,0.000,0.0000000000,0.0000000000,100000.0000000000,0.0000000000,100000.0000000000,100000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3748,827,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,10000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,30000.0000000000,0.0000000000,30000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3748,828,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,10000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,30000.0000000000,0.0000000000,30000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3749,64,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,85000.0000000000,85000.0000000000,0.000,0.0000000000,0.0000000000,85000.0000000000,0.0000000000,85000.0000000000,85000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3750,784,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,150000.0000000000,150000.0000000000,0.000,0.0000000000,0.0000000000,150000.0000000000,0.0000000000,150000.0000000000,150000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3751,815,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,2000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3752,370,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,3000.0000000000,3000.0000000000,0.000,0.0000000000,0.0000000000,3000.0000000000,0.0000000000,3000.0000000000,3000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3753,368,NULL,NULL,NULL,'',NULL,0,13.0000000000,13.0000000000,0.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,32500.0000000000,0.0000000000,32500.0000000000,32500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3754,373,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,75000.0000000000,75000.0000000000,0.000,0.0000000000,0.0000000000,75000.0000000000,0.0000000000,75000.0000000000,75000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3754,525,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,45000.0000000000,100000.0000000000,100000.0000000000,0.000,0.0000000000,0.0000000000,200000.0000000000,0.0000000000,200000.0000000000,110000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3755,51,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,8000.0000000000,8000.0000000000,0.000,0.0000000000,0.0000000000,8000.0000000000,0.0000000000,8000.0000000000,8000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3756,402,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,130000.0000000000,130000.0000000000,0.000,0.0000000000,0.0000000000,130000.0000000000,0.0000000000,130000.0000000000,130000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3757,832,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,30000.0000000000,150000.0000000000,150000.0000000000,0.000,0.0000000000,0.0000000000,150000.0000000000,0.0000000000,150000.0000000000,120000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3758,264,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,0.0000000000,65000.0000000000,65000.0000000000,0.000,0.0000000000,0.0000000000,65000.0000000000,0.0000000000,65000.0000000000,65000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3758,311,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,0.0000000000,20000.0000000000,20000.0000000000,0.000,0.0000000000,0.0000000000,20000.0000000000,0.0000000000,20000.0000000000,20000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3758,650,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,0.0000000000,28000.0000000000,28000.0000000000,0.000,0.0000000000,0.0000000000,28000.0000000000,0.0000000000,28000.0000000000,28000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(3758,735,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,50000.0000000000,50000.0000000000,0.000,0.0000000000,0.0000000000,50000.0000000000,0.0000000000,50000.0000000000,50000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3759,51,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,0.0000000000,8000.0000000000,8000.0000000000,0.000,0.0000000000,0.0000000000,8000.0000000000,0.0000000000,8000.0000000000,8000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3759,58,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,40000.0000000000,40000.0000000000,0.000,0.0000000000,0.0000000000,40000.0000000000,0.0000000000,40000.0000000000,40000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3760,3,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,0.0000000000,25000.0000000000,25000.0000000000,0.000,0.0000000000,0.0000000000,25000.0000000000,0.0000000000,25000.0000000000,25000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3761,175,NULL,NULL,NULL,'',NULL,0,8.0000000000,8.0000000000,0.0000000000,160000.0000000000,160000.0000000000,0.000,0.0000000000,0.0000000000,1280000.0000000000,0.0000000000,1280000.0000000000,1280000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(3761,186,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,0.0000000000,250000.0000000000,250000.0000000000,0.000,0.0000000000,0.0000000000,250000.0000000000,0.0000000000,250000.0000000000,250000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(3761,188,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,0.0000000000,175000.0000000000,175000.0000000000,0.000,0.0000000000,0.0000000000,175000.0000000000,0.0000000000,175000.0000000000,175000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,7,NULL,NULL,NULL,0,NULL),(3761,189,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,0.0000000000,300000.0000000000,300000.0000000000,0.000,0.0000000000,0.0000000000,300000.0000000000,0.0000000000,300000.0000000000,300000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,6,NULL,NULL,NULL,0,NULL),(3761,653,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,150000.0000000000,200000.0000000000,200000.0000000000,0.000,0.0000000000,0.0000000000,200000.0000000000,0.0000000000,200000.0000000000,50000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(3761,658,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,150000.0000000000,180000.0000000000,180000.0000000000,0.000,0.0000000000,0.0000000000,180000.0000000000,0.0000000000,180000.0000000000,30000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(3761,743,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,0.0000000000,100000.0000000000,100000.0000000000,0.000,0.0000000000,0.0000000000,200000.0000000000,0.0000000000,200000.0000000000,200000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(3762,99,NULL,NULL,NULL,'',NULL,0,5.0000000000,5.0000000000,0.0000000000,200000.0000000000,200000.0000000000,0.000,0.0000000000,0.0000000000,1000000.0000000000,0.0000000000,1000000.0000000000,1000000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL);

--
-- Table structure for table `phppos_sales_items_modifier_items`
--

CREATE TABLE `phppos_sales_items_modifier_items` (
  `item_id` int(10) NOT NULL,
  `sale_id` int(10) NOT NULL,
  `line` int(10) NOT NULL,
  `modifier_item_id` int(10) NOT NULL,
  `cost_price` decimal(23,10) NOT NULL DEFAULT 0.0000000000,
  `unit_price` decimal(23,10) NOT NULL DEFAULT 0.0000000000,
  PRIMARY KEY (`item_id`,`sale_id`,`line`,`modifier_item_id`),
  KEY `phppos_sales_items_modifier_items_ibfk_2` (`sale_id`),
  KEY `phppos_sales_items_modifier_items_ibfk_3` (`modifier_item_id`),
  CONSTRAINT `phppos_sales_items_modifier_items_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `phppos_items` (`item_id`),
  CONSTRAINT `phppos_sales_items_modifier_items_ibfk_2` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales` (`sale_id`),
  CONSTRAINT `phppos_sales_items_modifier_items_ibfk_3` FOREIGN KEY (`modifier_item_id`) REFERENCES `phppos_modifier_items` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_sales_items_modifier_items`
--


--
-- Table structure for table `phppos_sales_items_notes`
--

CREATE TABLE `phppos_sales_items_notes` (
  `note_id` int(11) NOT NULL AUTO_INCREMENT,
  `note_timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `sale_id` int(10) NOT NULL,
  `item_id` int(10) NOT NULL,
  `line` int(10) NOT NULL DEFAULT 0,
  `item_variation_id` int(10) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `detailed_notes` text DEFAULT NULL,
  `internal` tinyint(10) DEFAULT NULL,
  `employee_id` int(10) NOT NULL,
  `images` text DEFAULT NULL,
  `device_location` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  PRIMARY KEY (`note_id`),
  KEY `phppos_sales_items_notes_ibfk_1` (`sale_id`),
  KEY `phppos_sales_items_notes_ibfk_2` (`item_id`),
  KEY `phppos_sales_items_notes_ibfk_3` (`employee_id`),
  KEY `phppos_sales_items_notes_ibfk_4` (`status`),
  CONSTRAINT `phppos_sales_items_notes_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales` (`sale_id`),
  CONSTRAINT `phppos_sales_items_notes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `phppos_items` (`item_id`),
  CONSTRAINT `phppos_sales_items_notes_ibfk_3` FOREIGN KEY (`employee_id`) REFERENCES `phppos_employees` (`person_id`),
  CONSTRAINT `phppos_sales_items_notes_ibfk_4` FOREIGN KEY (`status`) REFERENCES `phppos_workorder_statuses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_sales_items_notes`
--


--
-- Table structure for table `phppos_sales_items_taxes`
--

CREATE TABLE `phppos_sales_items_taxes` (
  `sale_id` int(10) NOT NULL,
  `item_id` int(10) NOT NULL,
  `line` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `percent` decimal(15,3) NOT NULL,
  `cumulative` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`sale_id`,`item_id`,`line`,`name`,`percent`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `phppos_sales_items_taxes_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales_items` (`sale_id`),
  CONSTRAINT `phppos_sales_items_taxes_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `phppos_items` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_sales_items_taxes`
--

INSERT INTO `phppos_sales_items_taxes` VALUES (3014,64,0,'VAT',7.500,0),(3015,177,0,'VAT',7.500,0),(3016,55,0,'VAT',7.500,0),(3016,492,1,'VAT',7.500,0),(3016,591,2,'VAT',7.500,0),(3017,26,2,'VAT',7.500,0),(3017,151,0,'VAT',7.500,0),(3017,336,1,'VAT',7.500,0),(3018,55,0,'VAT',7.500,0),(3018,370,2,'VAT',7.500,0),(3018,595,1,'VAT',7.500,0),(3019,51,0,'VAT',7.500,0),(3020,12,6,'VAT',7.500,0),(3020,14,4,'VAT',7.500,0),(3020,143,0,'VAT',7.500,0),(3020,145,2,'VAT',7.500,0),(3020,146,1,'VAT',7.500,0),(3020,282,7,'VAT',7.500,0),(3020,368,9,'VAT',7.500,0),(3020,370,8,'VAT',7.500,0),(3020,371,10,'VAT',7.500,0),(3020,373,5,'VAT',7.500,0),(3020,563,11,'VAT',7.500,0),(3020,620,3,'VAT',7.500,0),(3021,142,3,'VAT',7.500,0),(3021,284,0,'VAT',7.500,0),(3021,317,2,'VAT',7.500,0),(3021,374,4,'VAT',7.500,0),(3021,443,1,'VAT',7.500,0),(3022,508,1,'VAT',7.500,0),(3022,596,0,'VAT',7.500,0),(3022,620,2,'VAT',7.500,0),(3023,290,1,'VAT',7.500,0),(3023,604,0,'VAT',7.500,0),(3024,95,0,'VAT',7.500,0),(3024,635,1,'VAT',7.500,0),(3025,92,2,'VAT',7.500,0),(3025,95,1,'VAT',7.500,0),(3025,96,0,'VAT',7.500,0),(3026,286,0,'VAT',7.500,0),(3027,374,0,'VAT',7.500,0),(3028,383,0,'VAT',7.500,0),(3028,443,1,'VAT',7.500,0),(3029,287,0,'VAT',7.500,0),(3030,568,0,'VAT',7.500,0),(3030,584,1,'VAT',7.500,0),(3030,600,3,'VAT',7.500,0),(3030,620,2,'VAT',7.500,0),(3031,285,1,'VAT',7.500,0),(3031,317,2,'VAT',7.500,0),(3031,596,0,'VAT',7.500,0),(3032,142,0,'VAT',7.500,0),(3032,562,1,'VAT',7.500,0),(3033,282,0,'VAT',7.500,0),(3034,83,0,'VAT',7.500,0),(3034,84,1,'VAT',7.500,0),(3034,617,2,'VAT',7.500,0),(3035,402,0,'VAT',7.500,0),(3036,58,1,'VAT',7.500,0),(3036,82,4,'VAT',7.500,0),(3036,209,2,'VAT',7.500,0),(3036,264,0,'VAT',7.500,0),(3036,560,3,'VAT',7.500,0),(3037,623,0,'VAT',7.500,0),(3038,95,1,'VAT',7.500,0),(3038,96,0,'VAT',7.500,0),(3039,1,0,'VAT',7.500,0),(3040,11,0,'VAT',7.500,0),(3041,109,1,'VAT',7.500,0),(3041,558,0,'VAT',7.500,0),(3041,576,3,'VAT',7.500,0),(3041,594,2,'VAT',7.500,0),(3042,568,0,'VAT',7.500,0),(3043,175,0,'VAT',7.500,0),(3044,17,2,'VAT',7.500,0),(3044,26,0,'VAT',7.500,0),(3044,40,1,'VAT',7.500,0),(3045,632,0,'VAT',7.500,0),(3046,285,1,'VAT',7.500,0),(3046,568,0,'VAT',7.500,0),(3047,282,0,'VAT',7.500,0),(3048,183,1,'VAT',7.500,0),(3048,560,0,'VAT',7.500,0),(3049,58,1,'VAT',7.500,0),(3049,82,0,'VAT',7.500,0),(3050,621,0,'VAT',7.500,0),(3051,58,0,'VAT',7.500,0),(3052,58,0,'VAT',7.500,0),(3053,575,0,'VAT',7.500,0),(3054,592,1,'VAT',7.500,0),(3054,600,0,'VAT',7.500,0),(3055,142,0,'VAT',7.500,0),(3056,435,0,'VAT',7.500,0),(3057,383,0,'VAT',7.500,0),(3058,142,0,'VAT',7.500,0),(3059,35,0,'VAT',7.500,0),(3060,96,0,'VAT',7.500,0),(3060,441,1,'VAT',7.500,0),(3061,435,0,'VAT',7.500,0),(3062,402,0,'VAT',7.500,0),(3062,613,1,'VAT',7.500,0),(3063,317,0,'VAT',7.500,0),(3064,50,0,'VAT',7.500,0),(3064,51,1,'VAT',7.500,0),(3065,7,0,'VAT',7.500,0),(3066,7,1,'VAT',7.500,0),(3066,61,0,'VAT',7.500,0),(3066,76,2,'VAT',7.500,0),(3067,29,0,'VAT',7.500,0),(3067,379,1,'VAT',7.500,0),(3067,387,2,'VAT',7.500,0),(3068,3,0,'VAT',7.500,0),(3069,594,0,'VAT',7.500,0),(3070,64,0,'VAT',7.500,0),(3070,637,1,'VAT',7.500,0),(3071,17,0,'VAT',7.500,0),(3071,297,2,'VAT',7.500,0),(3071,329,1,'VAT',7.500,0),(3071,612,3,'VAT',7.500,0),(3072,58,0,'VAT',7.500,0),(3073,508,0,'VAT',7.500,0),(3073,620,1,'VAT',7.500,0),(3073,621,3,'VAT',7.500,0),(3073,632,2,'VAT',7.500,0),(3074,383,0,'VAT',7.500,0),(3075,366,0,'VAT',7.500,0),(3076,59,0,'VAT',7.500,0),(3076,78,1,'VAT',7.500,0),(3076,83,2,'VAT',7.500,0),(3077,80,2,'VAT',7.500,0),(3077,181,1,'VAT',7.500,0),(3077,192,0,'VAT',7.500,0),(3078,378,1,'VAT',7.500,0),(3078,379,2,'VAT',7.500,0),(3078,389,0,'VAT',7.500,0),(3079,183,0,'VAT',7.500,0),(3080,282,1,'VAT',7.500,0),(3080,596,0,'VAT',7.500,0),(3081,85,0,'VAT',7.500,0),(3082,543,0,'VAT',7.500,0),(3083,58,0,'VAT',7.500,0),(3084,61,1,'VAT',7.500,0),(3084,209,0,'VAT',7.500,0),(3084,632,2,'VAT',7.500,0),(3085,61,0,'VAT',7.500,0),(3086,31,0,'VAT',7.500,0),(3087,26,0,'VAT',7.500,0),(3088,181,1,'VAT',7.500,0),(3088,183,0,'VAT',7.500,0),(3088,197,2,'VAT',7.500,0),(3089,31,0,'VAT',7.500,0),(3090,55,2,'VAT',7.500,0),(3090,145,4,'VAT',7.500,0),(3090,300,0,'VAT',7.500,0),(3090,305,1,'VAT',7.500,0),(3090,368,3,'VAT',7.500,0),(3090,406,6,'VAT',7.500,0),(3090,440,5,'VAT',7.500,0),(3090,557,7,'VAT',7.500,0),(3090,594,8,'VAT',7.500,0),(3091,4,7,'VAT',7.500,0),(3091,284,2,'VAT',7.500,0),(3091,285,4,'VAT',7.500,0),(3091,288,3,'VAT',7.500,0),(3091,317,5,'VAT',7.500,0),(3091,361,9,'VAT',7.500,0),(3091,372,0,'VAT',7.500,0),(3091,383,8,'VAT',7.500,0),(3091,541,1,'VAT',7.500,0),(3091,612,6,'VAT',7.500,0),(3092,34,0,'VAT',7.500,0),(3092,50,1,'VAT',7.500,0),(3093,282,0,'VAT',7.500,0),(3093,612,1,'VAT',7.500,0),(3094,291,1,'VAT',7.500,0),(3094,378,0,'VAT',7.500,0),(3094,447,4,'VAT',7.500,0),(3094,483,3,'VAT',7.500,0),(3094,510,5,'VAT',7.500,0),(3094,535,2,'VAT',7.500,0),(3095,3,0,'VAT',7.500,0),(3096,309,0,'VAT',7.500,0),(3097,580,0,'VAT',7.500,0),(3098,402,0,'VAT',7.500,0),(3099,568,0,'VAT',7.500,0),(3100,12,1,'VAT',7.500,0),(3100,625,0,'VAT',7.500,0),(3101,288,0,'VAT',7.500,0),(3102,563,0,'VAT',7.500,0),(3103,317,0,'VAT',7.500,0),(3104,96,0,'VAT',7.500,0),(3104,443,1,'VAT',7.500,0),(3105,443,0,'VAT',7.500,0),(3106,92,0,'VAT',7.500,0),(3107,605,0,'VAT',7.500,0),(3108,92,2,'VAT',7.500,0),(3108,201,3,'VAT',7.500,0),(3108,302,0,'VAT',7.500,0),(3108,569,1,'VAT',7.500,0),(3108,611,4,'VAT',7.500,0),(3109,34,0,'VAT',7.500,0),(3110,333,0,'VAT',7.500,0),(3111,333,0,'VAT',7.500,0),(3112,535,0,'VAT',7.500,0),(3113,302,0,'VAT',7.500,0),(3114,146,1,'VAT',7.500,0),(3114,201,3,'VAT',7.500,0),(3114,327,0,'VAT',7.500,0),(3114,529,2,'VAT',7.500,0),(3115,290,0,'VAT',7.500,0),(3116,64,0,'VAT',7.500,0),(3117,96,0,'VAT',7.500,0),(3117,201,1,'VAT',7.500,0),(3118,58,0,'VAT',7.500,0),(3118,560,1,'VAT',7.500,0),(3119,151,0,'VAT',7.500,0),(3120,11,1,'VAT',7.500,0),(3120,171,0,'VAT',7.500,0),(3121,92,3,'VAT',7.500,0),(3121,96,4,'VAT',7.500,0),(3121,406,2,'VAT',7.500,0),(3121,435,0,'VAT',7.500,0),(3121,510,1,'VAT',7.500,0),(3121,623,5,'VAT',7.500,0),(3122,284,0,'VAT',7.500,0),(3122,285,2,'VAT',7.500,0),(3122,288,1,'VAT',7.500,0),(3123,286,0,'VAT',7.500,0),(3124,58,0,'VAT',7.500,0),(3124,560,1,'VAT',7.500,0),(3125,14,13,'VAT',7.500,0),(3125,92,22,'VAT',7.500,0),(3125,95,4,'VAT',7.500,0),(3125,96,5,'VAT',7.500,0),(3125,109,26,'VAT',7.500,0),(3125,142,17,'VAT',7.500,0),(3125,143,12,'VAT',7.500,0),(3125,282,25,'VAT',7.500,0),(3125,317,16,'VAT',7.500,0),(3125,374,29,'VAT',7.500,0),(3125,379,18,'VAT',7.500,0),(3125,384,0,'VAT',7.500,0),(3125,401,28,'VAT',7.500,0),(3125,407,19,'VAT',7.500,0),(3125,408,14,'VAT',7.500,0),(3125,436,9,'VAT',7.500,0),(3125,439,21,'VAT',7.500,0),(3125,483,10,'VAT',7.500,0),(3125,514,6,'VAT',7.500,0),(3125,525,24,'VAT',7.500,0),(3125,562,3,'VAT',7.500,0),(3125,563,2,'VAT',7.500,0),(3125,564,7,'VAT',7.500,0),(3125,576,20,'VAT',7.500,0),(3125,577,8,'VAT',7.500,0),(3125,594,15,'VAT',7.500,0),(3125,613,27,'VAT',7.500,0),(3125,619,23,'VAT',7.500,0),(3125,623,11,'VAT',7.500,0),(3125,625,1,'VAT',7.500,0),(3126,406,0,'VAT',7.500,0),(3126,440,1,'VAT',7.500,0),(3126,483,2,'VAT',7.500,0),(3127,5,1,'VAT',7.500,0),(3127,213,2,'VAT',7.500,0),(3127,264,0,'VAT',7.500,0),(3128,508,0,'VAT',7.500,0),(3128,621,1,'VAT',7.500,0),(3129,439,0,'VAT',7.500,0),(3130,439,0,'VAT',7.500,0),(3131,95,2,'VAT',7.500,0),(3131,96,3,'VAT',7.500,0),(3131,285,0,'VAT',7.500,0),(3131,290,5,'VAT',7.500,0),(3131,368,6,'VAT',7.500,0),(3131,370,7,'VAT',7.500,0),(3131,372,1,'VAT',7.500,0),(3131,529,8,'VAT',7.500,0),(3131,594,4,'VAT',7.500,0),(3132,557,0,'VAT',7.500,0),(3133,528,1,'VAT',7.500,0),(3133,626,0,'VAT',7.500,0),(3134,568,0,'VAT',7.500,0),(3135,96,3,'VAT',7.500,0),(3135,284,0,'VAT',7.500,0),(3135,285,1,'VAT',7.500,0),(3135,317,2,'VAT',7.500,0),(3136,287,0,'VAT',7.500,0),(3137,96,0,'VAT',7.500,0),(3138,59,0,'VAT',7.500,0),(3138,83,1,'VAT',7.500,0),(3138,637,2,'VAT',7.500,0),(3139,510,0,'VAT',7.500,0),(3140,575,0,'VAT',7.500,0),(3141,11,0,'VAT',7.500,0),(3142,407,0,'VAT',7.500,0),(3143,95,0,'VAT',7.500,0),(3144,40,0,'VAT',7.500,0),(3145,638,0,'VAT',7.500,0),(3146,183,0,'VAT',7.500,0),(3147,307,0,'VAT',7.500,0),(3148,61,0,'VAT',7.500,0),(3149,317,1,'VAT',7.500,0),(3149,594,0,'VAT',7.500,0),(3150,55,2,'VAT',7.500,0),(3150,368,1,'VAT',7.500,0),(3150,370,0,'VAT',7.500,0),(3150,561,3,'VAT',7.500,0),(3151,143,0,'VAT',7.500,0),(3152,639,0,'VAT',7.500,0),(3153,481,0,'VAT',7.500,0),(3154,632,0,'VAT',7.500,0),(3155,374,0,'VAT',7.500,0),(3155,439,2,'VAT',7.500,0),(3155,481,1,'VAT',7.500,0),(3156,564,0,'VAT',7.500,0),(3157,83,0,'VAT',7.500,0),(3158,543,0,'VAT',7.500,0),(3159,201,2,'VAT',7.500,0),(3159,284,0,'VAT',7.500,0),(3159,286,1,'VAT',7.500,0),(3160,201,2,'VAT',7.500,0),(3160,284,0,'VAT',7.500,0),(3160,286,1,'VAT',7.500,0),(3161,92,3,'VAT',7.500,0),(3161,96,1,'VAT',7.500,0),(3161,327,2,'VAT',7.500,0),(3161,609,0,'VAT',7.500,0),(3162,451,0,'VAT',7.500,0),(3163,384,0,'VAT',7.500,0),(3163,543,1,'VAT',7.500,0),(3164,621,1,'VAT',7.500,0),(3164,632,0,'VAT',7.500,0),(3165,26,6,'VAT',7.500,0),(3165,397,3,'VAT',7.500,0),(3165,592,5,'VAT',7.500,0),(3165,611,7,'VAT',7.500,0),(3165,620,2,'VAT',7.500,0),(3165,621,1,'VAT',7.500,0),(3165,632,4,'VAT',7.500,0),(3165,637,0,'VAT',7.500,0),(3166,83,0,'VAT',7.500,0),(3166,617,1,'VAT',7.500,0),(3167,11,0,'VAT',7.500,0),(3168,510,0,'VAT',7.500,0),(3169,92,0,'VAT',7.500,0),(3170,453,0,'VAT',7.500,0),(3171,638,0,'VAT',7.500,0),(3172,402,0,'VAT',7.500,0),(3173,80,0,'VAT',7.500,0),(3174,67,2,'VAT',7.500,0),(3174,104,0,'VAT',7.500,0),(3174,124,1,'VAT',7.500,0),(3175,55,0,'VAT',7.500,0),(3175,319,1,'VAT',7.500,0),(3176,481,0,'VAT',7.500,0),(3177,151,0,'VAT',7.500,0),(3177,560,1,'VAT',7.500,0),(3178,55,0,'VAT',7.500,0),(3179,152,0,'VAT',7.500,0),(3180,63,0,'VAT',7.500,0),(3180,213,2,'VAT',7.500,0),(3180,560,1,'VAT',7.500,0),(3181,55,0,'VAT',7.500,0),(3182,407,3,'VAT',7.500,0),(3182,435,2,'VAT',7.500,0),(3182,557,1,'VAT',7.500,0),(3182,564,0,'VAT',7.500,0),(3183,285,0,'VAT',7.500,0),(3183,443,1,'VAT',7.500,0),(3184,55,0,'VAT',7.500,0);

--
-- Table structure for table `phppos_sales_work_orders`
--

CREATE TABLE `phppos_sales_work_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sale_id` int(10) NOT NULL,
  `status` int(11) DEFAULT 1,
  `employee_id` int(11) DEFAULT NULL,
  `estimated_repair_date` timestamp NULL DEFAULT NULL,
  `estimated_parts` decimal(23,10) DEFAULT NULL,
  `estimated_labor` decimal(23,10) DEFAULT NULL,
  `warranty` tinyint(1) DEFAULT NULL,
  `custom_field_1_value` varchar(255) DEFAULT NULL,
  `custom_field_2_value` varchar(255) DEFAULT NULL,
  `custom_field_3_value` varchar(255) DEFAULT NULL,
  `custom_field_4_value` varchar(255) DEFAULT NULL,
  `custom_field_5_value` varchar(255) DEFAULT NULL,
  `custom_field_6_value` varchar(255) DEFAULT NULL,
  `custom_field_7_value` varchar(255) DEFAULT NULL,
  `custom_field_8_value` varchar(255) DEFAULT NULL,
  `custom_field_9_value` varchar(255) DEFAULT NULL,
  `custom_field_10_value` varchar(255) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `deleted` int(1) DEFAULT 0,
  `pre_auth_signature_file_id` int(11) DEFAULT NULL,
  `post_auth_signature_file_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`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`),
  KEY `phppos_sales_work_orders_ibfk_1` (`sale_id`),
  KEY `phppos_sales_work_orders_ibfk_2` (`employee_id`),
  KEY `phppos_sales_work_orders_ibfk_3` (`status`),
  KEY `phppos_sales_work_orders_ibfk_4` (`pre_auth_signature_file_id`),
  KEY `phppos_sales_work_orders_ibfk_5` (`post_auth_signature_file_id`),
  CONSTRAINT `phppos_sales_work_orders_ibfk_1` FOREIGN KEY (`sale_id`) REFERENCES `phppos_sales` (`sale_id`),
  CONSTRAINT `phppos_sales_work_orders_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `phppos_employees` (`person_id`),
  CONSTRAINT `phppos_sales_work_orders_ibfk_3` FOREIGN KEY (`status`) REFERENCES `phppos_workorder_statuses` (`id`),
  CONSTRAINT `phppos_sales_work_orders_ibfk_4` FOREIGN KEY (`pre_auth_signature_file_id`) REFERENCES `phppos_app_files` (`file_id`),
  CONSTRAINT `phppos_sales_work_orders_ibfk_5` FOREIGN KEY (`post_auth_signature_file_id`) REFERENCES `phppos_app_files` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_sales_work_orders`
--


--
-- Table structure for table `phppos_sessions`
--

CREATE TABLE `phppos_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) 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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `phppos_sessions` VALUES ('556fp640nche3des3f4rq8p83cd90qfe','102.219.153.112',1784390773,'person_id|s:4:\"1595\";sale|s:9147:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:3:{i:0;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"175|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:1;s:4:\"name\";s:25:\"DERMAL FILLER PER SYRINGE\";s:8:\"quantity\";s:1:\"8\";s:10:\"unit_price\";s:9:\"160000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"1\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:2:\"30\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784390693 6a5ba425422b6\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:175;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:17:\"160000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}i:1;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"743|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:2;s:4:\"name\";s:21:\"LEMON BOTTLE {1 VIAL}\";s:8:\"quantity\";s:1:\"2\";s:10:\"unit_price\";s:9:\"100000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"1\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:2:\"51\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784390715 6a5ba43b24c94\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:743;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:17:\"100000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}i:2;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"186|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:3;s:4:\"name\";s:15:\"NOSE BRIDGE PDO\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:9:\"250000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"1\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:2:\"31\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784390734 6a5ba44eaf701\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:186;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:17:\"250000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}}s:20:\"\0PHPPOSCart\0payments\";a:0:{}s:26:\"\0PHPPOSCart\0excluded_taxes\";a:0:{}s:16:\"\0PHPPOSCart\0mode\";s:4:\"sale\";s:34:\"\0PHPPOSCart\0paid_store_account_ids\";a:0:{}s:26:\"paid_store_account_amounts\";N;s:11:\"employee_id\";N;s:11:\"location_id\";N;s:11:\"register_id\";N;s:7:\"comment\";s:0:\"\";s:23:\"supplier_invoice_number\";N;s:16:\"selected_payment\";s:0:\"\";s:13:\"email_receipt\";b:0;s:11:\"sms_receipt\";b:0;s:9:\"suspended\";i:0;s:18:\"change_date_enable\";b:0;s:16:\"change_cart_date\";N;s:19:\"is_editing_previous\";b:0;s:20:\"custom_field_1_value\";N;s:20:\"custom_field_2_value\";N;s:20:\"custom_field_3_value\";N;s:20:\"custom_field_4_value\";N;s:20:\"custom_field_5_value\";N;s:20:\"custom_field_6_value\";N;s:20:\"custom_field_7_value\";N;s:20:\"custom_field_8_value\";N;s:20:\"custom_field_9_value\";N;s:21:\"custom_field_10_value\";N;s:31:\"work_order_custom_field_1_value\";N;s:31:\"work_order_custom_field_2_value\";N;s:31:\"work_order_custom_field_3_value\";N;s:31:\"work_order_custom_field_4_value\";N;s:31:\"work_order_custom_field_5_value\";N;s:31:\"work_order_custom_field_6_value\";N;s:31:\"work_order_custom_field_7_value\";N;s:31:\"work_order_custom_field_8_value\";N;s:31:\"work_order_custom_field_9_value\";N;s:32:\"work_order_custom_field_10_value\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:17:\"details_collapsed\";b:1;s:12:\"skip_webhook\";b:0;s:6:\"offset\";i:0;s:5:\"limit\";i:20;s:11:\"sort_column\";N;s:9:\"sort_type\";N;s:14:\"create_invoice\";N;s:17:\"create_work_order\";i:0;s:13:\"is_work_order\";b:0;s:7:\"sale_id\";N;s:14:\"return_sale_id\";N;s:11:\"customer_id\";N;s:23:\"show_comment_on_receipt\";b:0;s:16:\"selected_tier_id\";i:0;s:16:\"previous_tier_id\";i:0;s:19:\"sold_by_employee_id\";s:4:\"1595\";s:15:\"discount_reason\";s:0:\"\";s:12:\"has_delivery\";b:0;s:8:\"delivery\";O:18:\"PHPPOSCartDelivery\":3:{s:13:\"delivery_info\";N;s:21:\"delivery_tax_group_id\";N;s:20:\"delivery_person_info\";N;}s:20:\"partial_transactions\";a:0:{}s:17:\"use_cc_saved_info\";b:0;s:10:\"invoice_no\";s:0:\"\";s:15:\"prompt_for_card\";b:0;s:11:\"ebt_voucher\";s:0:\"\";s:14:\"ebt_voucher_no\";s:0:\"\";s:13:\"ebt_auth_code\";s:0:\"\";s:21:\"save_credit_card_info\";b:0;s:17:\"use_saved_cc_info\";b:0;s:15:\"redeem_discount\";b:0;s:21:\"sale_exchange_details\";s:0:\"\";s:7:\"coupons\";a:0:{}s:12:\"is_ecommerce\";b:0;s:29:\"integrated_gift_card_balances\";a:0:{}s:3:\"age\";N;s:12:\"taxjar_taxes\";a:0:{}s:22:\"was_last_edit_quantity\";b:0;s:25:\"show_terms_and_conditions\";s:0:\"\";s:24:\"customer_subscription_id\";N;s:13:\"return_reason\";N;}\";employee_current_register_id|s:1:\"2\";foreign_language_to_cur_language_sales|a:95:{s:6:\"現金\";s:4:\"Cash\";s:6:\"檢查\";s:6:\"Cheque\";s:9:\"禮物卡\";s:9:\"Gift Card\";s:9:\"借記卡\";s:10:\"Debit Card\";s:9:\"信用卡\";s:11:\"Credit Card\";s:12:\"商店帳號\";s:13:\"Store Account\";s:3:\"點\";s:6:\"Points\";s:8:\"Transfer\";s:8:\"Transfer\";s:7:\"Contant\";s:4:\"Cash\";s:6:\"Cheque\";s:6:\"Cheque\";s:9:\"Waardebon\";s:9:\"Gift Card\";s:9:\"Bankkaart\";s:10:\"Debit Card\";s:12:\"Kredietkaart\";s:11:\"Credit Card\";s:11:\"Op rekening\";s:13:\"Store Account\";s:6:\"Punten\";s:6:\"Points\";s:4:\"Cash\";s:4:\"Cash\";s:9:\"Gift Card\";s:9:\"Gift Card\";s:10:\"Debit Card\";s:10:\"Debit Card\";s:11:\"Credit Card\";s:11:\"Credit Card\";s:13:\"Store Account\";s:13:\"Store Account\";s:6:\"Points\";s:6:\"Points\";s:8:\"Comptant\";s:4:\"Cash\";s:7:\"Chèque\";s:6:\"Cheque\";s:12:\"Carte cadeau\";s:9:\"Gift Card\";s:12:\"Carte débit\";s:10:\"Debit Card\";s:12:\"Carte credit\";s:11:\"Credit Card\";s:14:\"Compte magasin\";s:13:\"Store Account\";s:10:\"Des points\";s:6:\"Points\";s:7:\"Bargeld\";s:4:\"Cash\";s:6:\"Scheck\";s:6:\"Cheque\";s:9:\"Gutschein\";s:9:\"Gift Card\";s:11:\"Kundenkarte\";s:10:\"Debit Card\";s:11:\"Kreditkarte\";s:11:\"Credit Card\";s:13:\"Laden-Account\";s:13:\"Store Account\";s:6:\"Punkte\";s:6:\"Points\";s:5:\"Tunai\";s:4:\"Cash\";s:3:\"Cek\";s:6:\"Cheque\";s:12:\"Hadiah Kartu\";s:9:\"Gift Card\";s:11:\"Kartu Debit\";s:10:\"Debit Card\";s:12:\"Kartu Credit\";s:11:\"Credit Card\";s:9:\"Toko Akun\";s:13:\"Store Account\";s:4:\"Poin\";s:6:\"Points\";s:8:\"Contante\";s:4:\"Cash\";s:7:\"Assegno\";s:6:\"Cheque\";s:12:\"Buono Regalo\";s:9:\"Gift Card\";s:8:\"Bancomat\";s:10:\"Debit Card\";s:16:\"Carta di Credito\";s:11:\"Credit Card\";s:14:\"Conto deposito\";s:13:\"Store Account\";s:5:\"Punti\";s:6:\"Points\";s:30:\"សាច់ប្រាក់\";s:4:\"Cash\";s:9:\"សែក\";s:6:\"Cheque\";s:33:\"កាត​រង្វាន់\";s:9:\"Gift Card\";s:36:\"ប័ណ្ណ​ឥណពន្ធ\";s:10:\"Debit Card\";s:33:\"ប័ណ្ណ​ឥណទាន\";s:11:\"Credit Card\";s:36:\"ប្រាក់ជំពាក់\";s:13:\"Store Account\";s:18:\"ពិន្ទុ\";s:6:\"Points\";s:10:\"Numerário\";s:4:\"Cash\";s:14:\"Vale de Oferta\";s:9:\"Gift Card\";s:18:\"Cartão de Débito\";s:10:\"Debit Card\";s:19:\"Cartão de Crédito\";s:11:\"Credit Card\";s:13:\"Conta da Loja\";s:13:\"Store Account\";s:6:\"Pontos\";s:6:\"Points\";s:8:\"Efectivo\";s:4:\"Cash\";s:17:\"Tarjeta de regalo\";s:9:\"Gift Card\";s:18:\"Tarjeta de débito\";s:10:\"Debit Card\";s:19:\"Tarjeta de crédito\";s:11:\"Credit Card\";s:18:\"Línea de crédito\";s:13:\"Store Account\";s:6:\"Puntos\";s:6:\"Points\";s:12:\"பணம்\";s:4:\"Cash\";s:21:\"காசோலை\";s:6:\"Cheque\";s:31:\"பரிசு அட்டை\";s:9:\"Gift Card\";s:37:\"டெபிட் கார்டு\";s:10:\"Debit Card\";s:28:\"கடன் அட்டை\";s:11:\"Credit Card\";s:52:\"கணக்கு சேமிக்கவும்\";s:13:\"Store Account\";s:27:\"புள்ளிகள்\";s:6:\"Points\";s:12:\"Tiền mặt\";s:4:\"Cash\";s:4:\"Séc\";s:6:\"Cheque\";s:17:\"Thẻ quà tặng\";s:9:\"Gift Card\";s:14:\"Thẻ ghi nợ\";s:10:\"Debit Card\";s:17:\"Thẻ tín dụng\";s:11:\"Credit Card\";s:30:\"Tài khoản của cửa hàng\";s:13:\"Store Account\";s:7:\"Điểm\";s:6:\"Points\";s:6:\"كاش\";s:4:\"Cash\";s:6:\"شيك\";s:6:\"Cheque\";s:15:\"كرت هدية\";s:9:\"Gift Card\";s:23:\"بطاقة ائتمان\";s:10:\"Debit Card\";s:27:\"بطاقة الائتمان\";s:11:\"Credit Card\";s:21:\"حساب المتجر\";s:13:\"Store Account\";s:8:\"نقاط\";s:6:\"Points\";s:6:\"现金\";s:4:\"Cash\";s:6:\"检查\";s:6:\"Cheque\";s:9:\"礼物卡\";s:9:\"Gift Card\";s:9:\"借记卡\";s:10:\"Debit Card\";s:12:\"商店帐号\";s:13:\"Store Account\";s:3:\"点\";s:6:\"Points\";}fullscreen|s:1:\"0\";items_search_data|a:7:{s:6:\"offset\";i:0;s:9:\"order_col\";s:4:\"name\";s:9:\"order_dir\";s:3:\"asc\";s:6:\"search\";s:16:\"BOTOX ( 50 UNIT)\";s:11:\"category_id\";s:0:\"\";s:6:\"fields\";s:3:\"all\";s:7:\"deleted\";i:0;}'),('6tu3dqs2teipvh7u39agk7jgetdmg6hr','102.89.46.106',1784385331,''),('8g243hvfschtb5jarbc96oenq08ig3en','102.219.153.121',1784376601,'person_id|s:4:\"1595\";keep_alive|i:1784376448;sale|s:9165:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:3:{i:0;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"735|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:1;s:4:\"name\";s:29:\"SIGNATURE BRIGHTENING FACIALS\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:8:\"50000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"1\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:1:\"1\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784371230 6a5b581e21392\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:735;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:16:\"50000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}i:1;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"650|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:2;s:4:\"name\";s:19:\"AZECLEAR ACID CREAM\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:8:\"28000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"0\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:1:\"2\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784372543 6a5b5d3f2dfc8\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:650;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:16:\"28000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}i:2;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:18:\"264|FORCE_ITEM_ID|\";s:18:\"existed_previously\";b:0;s:4:\"line\";N;s:10:\"line_index\";N;s:23:\"receipt_line_sort_order\";i:3;s:4:\"name\";s:26:\"TEETH WHITENING (8 SHADES)\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:8:\"65000.00\";s:10:\"cost_price\";s:12:\"0.0000000000\";s:8:\"discount\";i:0;s:20:\"flat_discount_amount\";i:0;s:11:\"description\";s:0:\"\";s:12:\"serialnumber\";N;s:21:\"generate_serial_range\";N;s:4:\"size\";s:0:\"\";s:11:\"item_number\";N;s:10:\"is_service\";s:1:\"1\";s:10:\"product_id\";N;s:21:\"allow_alt_description\";s:1:\"0\";s:13:\"is_serialized\";s:1:\"0\";s:7:\"taxable\";b:0;s:11:\"system_item\";s:1:\"0\";s:14:\"has_edit_price\";N;s:46:\"allow_price_override_regardless_of_permissions\";s:1:\"0\";s:12:\"only_integer\";s:1:\"0\";s:17:\"is_series_package\";s:1:\"0\";s:15:\"series_quantity\";N;s:25:\"series_days_to_use_within\";N;s:11:\"category_id\";s:2:\"35\";s:15:\"manufacturer_id\";N;s:7:\"tag_ids\";a:0:{}s:16:\"default_quantity\";N;s:24:\"disable_from_price_rules\";s:1:\"0\";s:4:\"uniq\";s:24:\"1784376472 6a5b6c98dd36a\";s:17:\"quantity_received\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:14:\"modifier_items\";a:0:{}s:21:\"secondary_supplier_id\";N;s:11:\"supplier_id\";N;s:21:\"cart_line_supplier_id\";N;s:13:\"main_image_id\";N;s:6:\"weight\";N;s:24:\"calculated_sale_item_tax\";N;s:7:\"item_id\";i:264;s:12:\"variation_id\";N;s:14:\"variation_name\";s:0:\"\";s:17:\"variation_choices\";a:0:{}s:23:\"variation_choices_model\";a:0:{}s:14:\"quantity_units\";a:0:{}s:16:\"quantity_unit_id\";N;s:22:\"quantity_unit_quantity\";N;s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:16:\"65000.0000000000\";s:17:\"change_cost_price\";s:1:\"0\";s:20:\"max_discount_percent\";N;s:14:\"max_edit_price\";N;s:14:\"min_edit_price\";N;s:12:\"tax_included\";s:1:\"0\";s:11:\"is_ebt_item\";s:1:\"0\";s:15:\"disable_loyalty\";s:1:\"0\";s:12:\"required_age\";N;s:10:\"verify_age\";s:1:\"0\";s:10:\"info_popup\";N;s:7:\"tier_id\";i:0;s:9:\"tier_name\";s:4:\"None\";s:11:\"damaged_qty\";N;s:4:\"rule\";a:0:{}s:12:\"is_recurring\";s:1:\"0\";s:12:\"startup_cost\";s:12:\"0.0000000000\";s:14:\"is_repair_item\";N;s:21:\"sold_by_employee_id_2\";N;}}s:20:\"\0PHPPOSCart\0payments\";a:0:{}s:26:\"\0PHPPOSCart\0excluded_taxes\";a:0:{}s:16:\"\0PHPPOSCart\0mode\";s:4:\"sale\";s:34:\"\0PHPPOSCart\0paid_store_account_ids\";a:0:{}s:26:\"paid_store_account_amounts\";a:0:{}s:11:\"employee_id\";N;s:11:\"location_id\";N;s:11:\"register_id\";N;s:7:\"comment\";s:0:\"\";s:23:\"supplier_invoice_number\";N;s:16:\"selected_payment\";s:8:\"Transfer\";s:13:\"email_receipt\";b:0;s:11:\"sms_receipt\";b:0;s:9:\"suspended\";i:0;s:18:\"change_date_enable\";b:0;s:16:\"change_cart_date\";N;s:19:\"is_editing_previous\";b:0;s:20:\"custom_field_1_value\";N;s:20:\"custom_field_2_value\";N;s:20:\"custom_field_3_value\";N;s:20:\"custom_field_4_value\";N;s:20:\"custom_field_5_value\";N;s:20:\"custom_field_6_value\";N;s:20:\"custom_field_7_value\";N;s:20:\"custom_field_8_value\";N;s:20:\"custom_field_9_value\";N;s:21:\"custom_field_10_value\";N;s:31:\"work_order_custom_field_1_value\";N;s:31:\"work_order_custom_field_2_value\";N;s:31:\"work_order_custom_field_3_value\";N;s:31:\"work_order_custom_field_4_value\";N;s:31:\"work_order_custom_field_5_value\";N;s:31:\"work_order_custom_field_6_value\";N;s:31:\"work_order_custom_field_7_value\";N;s:31:\"work_order_custom_field_8_value\";N;s:31:\"work_order_custom_field_9_value\";N;s:32:\"work_order_custom_field_10_value\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:17:\"details_collapsed\";b:1;s:12:\"skip_webhook\";b:0;s:6:\"offset\";i:0;s:5:\"limit\";i:20;s:11:\"sort_column\";N;s:9:\"sort_type\";N;s:14:\"create_invoice\";N;s:17:\"create_work_order\";i:0;s:13:\"is_work_order\";b:0;s:7:\"sale_id\";N;s:14:\"return_sale_id\";N;s:11:\"customer_id\";s:4:\"1734\";s:23:\"show_comment_on_receipt\";b:0;s:16:\"selected_tier_id\";i:0;s:16:\"previous_tier_id\";i:0;s:19:\"sold_by_employee_id\";s:4:\"1595\";s:15:\"discount_reason\";s:0:\"\";s:12:\"has_delivery\";b:0;s:8:\"delivery\";O:18:\"PHPPOSCartDelivery\":3:{s:13:\"delivery_info\";N;s:21:\"delivery_tax_group_id\";N;s:20:\"delivery_person_info\";N;}s:20:\"partial_transactions\";a:0:{}s:17:\"use_cc_saved_info\";b:0;s:10:\"invoice_no\";s:0:\"\";s:15:\"prompt_for_card\";b:0;s:11:\"ebt_voucher\";s:0:\"\";s:14:\"ebt_voucher_no\";s:0:\"\";s:13:\"ebt_auth_code\";s:0:\"\";s:21:\"save_credit_card_info\";b:0;s:17:\"use_saved_cc_info\";b:0;s:15:\"redeem_discount\";b:0;s:21:\"sale_exchange_details\";s:0:\"\";s:7:\"coupons\";a:0:{}s:12:\"is_ecommerce\";b:0;s:29:\"integrated_gift_card_balances\";a:0:{}s:3:\"age\";N;s:12:\"taxjar_taxes\";a:0:{}s:22:\"was_last_edit_quantity\";b:0;s:25:\"show_terms_and_conditions\";s:0:\"\";s:24:\"customer_subscription_id\";N;s:13:\"return_reason\";N;}\";employee_current_register_id|s:1:\"2\";foreign_language_to_cur_language_sales|a:95:{s:6:\"現金\";s:4:\"Cash\";s:6:\"檢查\";s:6:\"Cheque\";s:9:\"禮物卡\";s:9:\"Gift Card\";s:9:\"借記卡\";s:10:\"Debit Card\";s:9:\"信用卡\";s:11:\"Credit Card\";s:12:\"商店帳號\";s:13:\"Store Account\";s:3:\"點\";s:6:\"Points\";s:8:\"Transfer\";s:8:\"Transfer\";s:7:\"Contant\";s:4:\"Cash\";s:6:\"Cheque\";s:6:\"Cheque\";s:9:\"Waardebon\";s:9:\"Gift Card\";s:9:\"Bankkaart\";s:10:\"Debit Card\";s:12:\"Kredietkaart\";s:11:\"Credit Card\";s:11:\"Op rekening\";s:13:\"Store Account\";s:6:\"Punten\";s:6:\"Points\";s:4:\"Cash\";s:4:\"Cash\";s:9:\"Gift Card\";s:9:\"Gift Card\";s:10:\"Debit Card\";s:10:\"Debit Card\";s:11:\"Credit Card\";s:11:\"Credit Card\";s:13:\"Store Account\";s:13:\"Store Account\";s:6:\"Points\";s:6:\"Points\";s:8:\"Comptant\";s:4:\"Cash\";s:7:\"Chèque\";s:6:\"Cheque\";s:12:\"Carte cadeau\";s:9:\"Gift Card\";s:12:\"Carte débit\";s:10:\"Debit Card\";s:12:\"Carte credit\";s:11:\"Credit Card\";s:14:\"Compte magasin\";s:13:\"Store Account\";s:10:\"Des points\";s:6:\"Points\";s:7:\"Bargeld\";s:4:\"Cash\";s:6:\"Scheck\";s:6:\"Cheque\";s:9:\"Gutschein\";s:9:\"Gift Card\";s:11:\"Kundenkarte\";s:10:\"Debit Card\";s:11:\"Kreditkarte\";s:11:\"Credit Card\";s:13:\"Laden-Account\";s:13:\"Store Account\";s:6:\"Punkte\";s:6:\"Points\";s:5:\"Tunai\";s:4:\"Cash\";s:3:\"Cek\";s:6:\"Cheque\";s:12:\"Hadiah Kartu\";s:9:\"Gift Card\";s:11:\"Kartu Debit\";s:10:\"Debit Card\";s:12:\"Kartu Credit\";s:11:\"Credit Card\";s:9:\"Toko Akun\";s:13:\"Store Account\";s:4:\"Poin\";s:6:\"Points\";s:8:\"Contante\";s:4:\"Cash\";s:7:\"Assegno\";s:6:\"Cheque\";s:12:\"Buono Regalo\";s:9:\"Gift Card\";s:8:\"Bancomat\";s:10:\"Debit Card\";s:16:\"Carta di Credito\";s:11:\"Credit Card\";s:14:\"Conto deposito\";s:13:\"Store Account\";s:5:\"Punti\";s:6:\"Points\";s:30:\"សាច់ប្រាក់\";s:4:\"Cash\";s:9:\"សែក\";s:6:\"Cheque\";s:33:\"កាត​រង្វាន់\";s:9:\"Gift Card\";s:36:\"ប័ណ្ណ​ឥណពន្ធ\";s:10:\"Debit Card\";s:33:\"ប័ណ្ណ​ឥណទាន\";s:11:\"Credit Card\";s:36:\"ប្រាក់ជំពាក់\";s:13:\"Store Account\";s:18:\"ពិន្ទុ\";s:6:\"Points\";s:10:\"Numerário\";s:4:\"Cash\";s:14:\"Vale de Oferta\";s:9:\"Gift Card\";s:18:\"Cartão de Débito\";s:10:\"Debit Card\";s:19:\"Cartão de Crédito\";s:11:\"Credit Card\";s:13:\"Conta da Loja\";s:13:\"Store Account\";s:6:\"Pontos\";s:6:\"Points\";s:8:\"Efectivo\";s:4:\"Cash\";s:17:\"Tarjeta de regalo\";s:9:\"Gift Card\";s:18:\"Tarjeta de débito\";s:10:\"Debit Card\";s:19:\"Tarjeta de crédito\";s:11:\"Credit Card\";s:18:\"Línea de crédito\";s:13:\"Store Account\";s:6:\"Puntos\";s:6:\"Points\";s:12:\"பணம்\";s:4:\"Cash\";s:21:\"காசோலை\";s:6:\"Cheque\";s:31:\"பரிசு அட்டை\";s:9:\"Gift Card\";s:37:\"டெபிட் கார்டு\";s:10:\"Debit Card\";s:28:\"கடன் அட்டை\";s:11:\"Credit Card\";s:52:\"கணக்கு சேமிக்கவும்\";s:13:\"Store Account\";s:27:\"புள்ளிகள்\";s:6:\"Points\";s:12:\"Tiền mặt\";s:4:\"Cash\";s:4:\"Séc\";s:6:\"Cheque\";s:17:\"Thẻ quà tặng\";s:9:\"Gift Card\";s:14:\"Thẻ ghi nợ\";s:10:\"Debit Card\";s:17:\"Thẻ tín dụng\";s:11:\"Credit Card\";s:30:\"Tài khoản của cửa hàng\";s:13:\"Store Account\";s:7:\"Điểm\";s:6:\"Points\";s:6:\"كاش\";s:4:\"Cash\";s:6:\"شيك\";s:6:\"Cheque\";s:15:\"كرت هدية\";s:9:\"Gift Card\";s:23:\"بطاقة ائتمان\";s:10:\"Debit Card\";s:27:\"بطاقة الائتمان\";s:11:\"Credit Card\";s:21:\"حساب المتجر\";s:13:\"Store Account\";s:8:\"نقاط\";s:6:\"Points\";s:6:\"现金\";s:4:\"Cash\";s:6:\"检查\";s:6:\"Cheque\";s:9:\"礼物卡\";s:9:\"Gift Card\";s:9:\"借记卡\";s:10:\"Debit Card\";s:12:\"商店帐号\";s:13:\"Store Account\";s:3:\"点\";s:6:\"Points\";}fullscreen|s:1:\"0\";'),('9m88ds9el43ej0lsl3999u34q8aj3gb5','102.89.46.106',1784394052,'person_id|s:1:\"3\";sale|s:2587:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:0:{}s:20:\"\0PHPPOSCart\0payments\";a:0:{}s:26:\"\0PHPPOSCart\0excluded_taxes\";a:0:{}s:16:\"\0PHPPOSCart\0mode\";s:4:\"sale\";s:34:\"\0PHPPOSCart\0paid_store_account_ids\";a:0:{}s:26:\"paid_store_account_amounts\";a:0:{}s:11:\"employee_id\";N;s:11:\"location_id\";N;s:11:\"register_id\";N;s:7:\"comment\";s:0:\"\";s:23:\"supplier_invoice_number\";N;s:16:\"selected_payment\";s:0:\"\";s:13:\"email_receipt\";b:0;s:11:\"sms_receipt\";b:0;s:9:\"suspended\";i:0;s:18:\"change_date_enable\";b:0;s:16:\"change_cart_date\";N;s:19:\"is_editing_previous\";b:0;s:20:\"custom_field_1_value\";N;s:20:\"custom_field_2_value\";N;s:20:\"custom_field_3_value\";N;s:20:\"custom_field_4_value\";N;s:20:\"custom_field_5_value\";N;s:20:\"custom_field_6_value\";N;s:20:\"custom_field_7_value\";N;s:20:\"custom_field_8_value\";N;s:20:\"custom_field_9_value\";N;s:21:\"custom_field_10_value\";N;s:31:\"work_order_custom_field_1_value\";N;s:31:\"work_order_custom_field_2_value\";N;s:31:\"work_order_custom_field_3_value\";N;s:31:\"work_order_custom_field_4_value\";N;s:31:\"work_order_custom_field_5_value\";N;s:31:\"work_order_custom_field_6_value\";N;s:31:\"work_order_custom_field_7_value\";N;s:31:\"work_order_custom_field_8_value\";N;s:31:\"work_order_custom_field_9_value\";N;s:32:\"work_order_custom_field_10_value\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:17:\"details_collapsed\";b:1;s:12:\"skip_webhook\";b:0;s:6:\"offset\";i:0;s:5:\"limit\";i:20;s:11:\"sort_column\";N;s:9:\"sort_type\";N;s:14:\"create_invoice\";N;s:17:\"create_work_order\";i:0;s:13:\"is_work_order\";b:0;s:7:\"sale_id\";N;s:14:\"return_sale_id\";N;s:11:\"customer_id\";N;s:23:\"show_comment_on_receipt\";b:0;s:16:\"selected_tier_id\";i:0;s:16:\"previous_tier_id\";i:0;s:19:\"sold_by_employee_id\";s:1:\"3\";s:15:\"discount_reason\";s:0:\"\";s:12:\"has_delivery\";b:0;s:8:\"delivery\";O:18:\"PHPPOSCartDelivery\":3:{s:13:\"delivery_info\";N;s:21:\"delivery_tax_group_id\";N;s:20:\"delivery_person_info\";N;}s:20:\"partial_transactions\";a:0:{}s:17:\"use_cc_saved_info\";b:0;s:10:\"invoice_no\";s:0:\"\";s:15:\"prompt_for_card\";b:0;s:11:\"ebt_voucher\";s:0:\"\";s:14:\"ebt_voucher_no\";s:0:\"\";s:13:\"ebt_auth_code\";s:0:\"\";s:21:\"save_credit_card_info\";b:0;s:17:\"use_saved_cc_info\";b:0;s:15:\"redeem_discount\";b:0;s:21:\"sale_exchange_details\";s:0:\"\";s:7:\"coupons\";a:0:{}s:12:\"is_ecommerce\";b:0;s:29:\"integrated_gift_card_balances\";a:0:{}s:3:\"age\";N;s:12:\"taxjar_taxes\";a:0:{}s:22:\"was_last_edit_quantity\";b:0;s:25:\"show_terms_and_conditions\";s:0:\"\";s:24:\"customer_subscription_id\";N;s:13:\"return_reason\";N;}\";employee_current_register_id|s:1:\"1\";foreign_language_to_cur_language_sales|a:95:{s:6:\"現金\";s:4:\"Cash\";s:6:\"檢查\";s:6:\"Cheque\";s:9:\"禮物卡\";s:9:\"Gift Card\";s:9:\"借記卡\";s:10:\"Debit Card\";s:9:\"信用卡\";s:11:\"Credit Card\";s:12:\"商店帳號\";s:13:\"Store Account\";s:3:\"點\";s:6:\"Points\";s:8:\"Transfer\";s:8:\"Transfer\";s:7:\"Contant\";s:4:\"Cash\";s:6:\"Cheque\";s:6:\"Cheque\";s:9:\"Waardebon\";s:9:\"Gift Card\";s:9:\"Bankkaart\";s:10:\"Debit Card\";s:12:\"Kredietkaart\";s:11:\"Credit Card\";s:11:\"Op rekening\";s:13:\"Store Account\";s:6:\"Punten\";s:6:\"Points\";s:4:\"Cash\";s:4:\"Cash\";s:9:\"Gift Card\";s:9:\"Gift Card\";s:10:\"Debit Card\";s:10:\"Debit Card\";s:11:\"Credit Card\";s:11:\"Credit Card\";s:13:\"Store Account\";s:13:\"Store Account\";s:6:\"Points\";s:6:\"Points\";s:8:\"Comptant\";s:4:\"Cash\";s:7:\"Chèque\";s:6:\"Cheque\";s:12:\"Carte cadeau\";s:9:\"Gift Card\";s:12:\"Carte débit\";s:10:\"Debit Card\";s:12:\"Carte credit\";s:11:\"Credit Card\";s:14:\"Compte magasin\";s:13:\"Store Account\";s:10:\"Des points\";s:6:\"Points\";s:7:\"Bargeld\";s:4:\"Cash\";s:6:\"Scheck\";s:6:\"Cheque\";s:9:\"Gutschein\";s:9:\"Gift Card\";s:11:\"Kundenkarte\";s:10:\"Debit Card\";s:11:\"Kreditkarte\";s:11:\"Credit Card\";s:13:\"Laden-Account\";s:13:\"Store Account\";s:6:\"Punkte\";s:6:\"Points\";s:5:\"Tunai\";s:4:\"Cash\";s:3:\"Cek\";s:6:\"Cheque\";s:12:\"Hadiah Kartu\";s:9:\"Gift Card\";s:11:\"Kartu Debit\";s:10:\"Debit Card\";s:12:\"Kartu Credit\";s:11:\"Credit Card\";s:9:\"Toko Akun\";s:13:\"Store Account\";s:4:\"Poin\";s:6:\"Points\";s:8:\"Contante\";s:4:\"Cash\";s:7:\"Assegno\";s:6:\"Cheque\";s:12:\"Buono Regalo\";s:9:\"Gift Card\";s:8:\"Bancomat\";s:10:\"Debit Card\";s:16:\"Carta di Credito\";s:11:\"Credit Card\";s:14:\"Conto deposito\";s:13:\"Store Account\";s:5:\"Punti\";s:6:\"Points\";s:30:\"សាច់ប្រាក់\";s:4:\"Cash\";s:9:\"សែក\";s:6:\"Cheque\";s:33:\"កាត​រង្វាន់\";s:9:\"Gift Card\";s:36:\"ប័ណ្ណ​ឥណពន្ធ\";s:10:\"Debit Card\";s:33:\"ប័ណ្ណ​ឥណទាន\";s:11:\"Credit Card\";s:36:\"ប្រាក់ជំពាក់\";s:13:\"Store Account\";s:18:\"ពិន្ទុ\";s:6:\"Points\";s:10:\"Numerário\";s:4:\"Cash\";s:14:\"Vale de Oferta\";s:9:\"Gift Card\";s:18:\"Cartão de Débito\";s:10:\"Debit Card\";s:19:\"Cartão de Crédito\";s:11:\"Credit Card\";s:13:\"Conta da Loja\";s:13:\"Store Account\";s:6:\"Pontos\";s:6:\"Points\";s:8:\"Efectivo\";s:4:\"Cash\";s:17:\"Tarjeta de regalo\";s:9:\"Gift Card\";s:18:\"Tarjeta de débito\";s:10:\"Debit Card\";s:19:\"Tarjeta de crédito\";s:11:\"Credit Card\";s:18:\"Línea de crédito\";s:13:\"Store Account\";s:6:\"Puntos\";s:6:\"Points\";s:12:\"பணம்\";s:4:\"Cash\";s:21:\"காசோலை\";s:6:\"Cheque\";s:31:\"பரிசு அட்டை\";s:9:\"Gift Card\";s:37:\"டெபிட் கார்டு\";s:10:\"Debit Card\";s:28:\"கடன் அட்டை\";s:11:\"Credit Card\";s:52:\"கணக்கு சேமிக்கவும்\";s:13:\"Store Account\";s:27:\"புள்ளிகள்\";s:6:\"Points\";s:12:\"Tiền mặt\";s:4:\"Cash\";s:4:\"Séc\";s:6:\"Cheque\";s:17:\"Thẻ quà tặng\";s:9:\"Gift Card\";s:14:\"Thẻ ghi nợ\";s:10:\"Debit Card\";s:17:\"Thẻ tín dụng\";s:11:\"Credit Card\";s:30:\"Tài khoản của cửa hàng\";s:13:\"Store Account\";s:7:\"Điểm\";s:6:\"Points\";s:6:\"كاش\";s:4:\"Cash\";s:6:\"شيك\";s:6:\"Cheque\";s:15:\"كرت هدية\";s:9:\"Gift Card\";s:23:\"بطاقة ائتمان\";s:10:\"Debit Card\";s:27:\"بطاقة الائتمان\";s:11:\"Credit Card\";s:21:\"حساب المتجر\";s:13:\"Store Account\";s:8:\"نقاط\";s:6:\"Points\";s:6:\"现金\";s:4:\"Cash\";s:6:\"检查\";s:6:\"Cheque\";s:9:\"礼物卡\";s:9:\"Gift Card\";s:9:\"借记卡\";s:10:\"Debit Card\";s:12:\"商店帐号\";s:13:\"Store Account\";s:3:\"点\";s:6:\"Points\";}fullscreen|s:1:\"0\";amount_change|d:-0;keep_alive|i:1784393939;'),('crf0vo0bc60js833ad3adhqjep7esg88','102.219.153.98',1784390218,'person_id|s:4:\"1595\";items_search_data|a:7:{s:6:\"offset\";i:0;s:9:\"order_col\";s:4:\"name\";s:9:\"order_dir\";s:3:\"asc\";s:6:\"search\";s:16:\"EXTRACTION (1HR)\";s:11:\"category_id\";s:0:\"\";s:6:\"fields\";s:3:\"all\";s:7:\"deleted\";i:0;}sale|s:2590:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:0:{}s:20:\"\0PHPPOSCart\0payments\";a:0:{}s:26:\"\0PHPPOSCart\0excluded_taxes\";a:0:{}s:16:\"\0PHPPOSCart\0mode\";s:4:\"sale\";s:34:\"\0PHPPOSCart\0paid_store_account_ids\";a:0:{}s:26:\"paid_store_account_amounts\";a:0:{}s:11:\"employee_id\";N;s:11:\"location_id\";N;s:11:\"register_id\";N;s:7:\"comment\";s:0:\"\";s:23:\"supplier_invoice_number\";N;s:16:\"selected_payment\";s:0:\"\";s:13:\"email_receipt\";b:0;s:11:\"sms_receipt\";b:0;s:9:\"suspended\";i:0;s:18:\"change_date_enable\";b:0;s:16:\"change_cart_date\";N;s:19:\"is_editing_previous\";b:0;s:20:\"custom_field_1_value\";N;s:20:\"custom_field_2_value\";N;s:20:\"custom_field_3_value\";N;s:20:\"custom_field_4_value\";N;s:20:\"custom_field_5_value\";N;s:20:\"custom_field_6_value\";N;s:20:\"custom_field_7_value\";N;s:20:\"custom_field_8_value\";N;s:20:\"custom_field_9_value\";N;s:21:\"custom_field_10_value\";N;s:31:\"work_order_custom_field_1_value\";N;s:31:\"work_order_custom_field_2_value\";N;s:31:\"work_order_custom_field_3_value\";N;s:31:\"work_order_custom_field_4_value\";N;s:31:\"work_order_custom_field_5_value\";N;s:31:\"work_order_custom_field_6_value\";N;s:31:\"work_order_custom_field_7_value\";N;s:31:\"work_order_custom_field_8_value\";N;s:31:\"work_order_custom_field_9_value\";N;s:32:\"work_order_custom_field_10_value\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:17:\"details_collapsed\";b:1;s:12:\"skip_webhook\";b:0;s:6:\"offset\";i:0;s:5:\"limit\";i:20;s:11:\"sort_column\";N;s:9:\"sort_type\";N;s:14:\"create_invoice\";N;s:17:\"create_work_order\";i:0;s:13:\"is_work_order\";b:0;s:7:\"sale_id\";N;s:14:\"return_sale_id\";N;s:11:\"customer_id\";N;s:23:\"show_comment_on_receipt\";b:0;s:16:\"selected_tier_id\";i:0;s:16:\"previous_tier_id\";i:0;s:19:\"sold_by_employee_id\";s:4:\"1595\";s:15:\"discount_reason\";s:0:\"\";s:12:\"has_delivery\";b:0;s:8:\"delivery\";O:18:\"PHPPOSCartDelivery\":3:{s:13:\"delivery_info\";N;s:21:\"delivery_tax_group_id\";N;s:20:\"delivery_person_info\";N;}s:20:\"partial_transactions\";a:0:{}s:17:\"use_cc_saved_info\";b:0;s:10:\"invoice_no\";s:0:\"\";s:15:\"prompt_for_card\";b:0;s:11:\"ebt_voucher\";s:0:\"\";s:14:\"ebt_voucher_no\";s:0:\"\";s:13:\"ebt_auth_code\";s:0:\"\";s:21:\"save_credit_card_info\";b:0;s:17:\"use_saved_cc_info\";b:0;s:15:\"redeem_discount\";b:0;s:21:\"sale_exchange_details\";s:0:\"\";s:7:\"coupons\";a:0:{}s:12:\"is_ecommerce\";b:0;s:29:\"integrated_gift_card_balances\";a:0:{}s:3:\"age\";N;s:12:\"taxjar_taxes\";a:0:{}s:22:\"was_last_edit_quantity\";b:0;s:25:\"show_terms_and_conditions\";s:0:\"\";s:24:\"customer_subscription_id\";N;s:13:\"return_reason\";N;}\";employee_current_register_id|s:1:\"2\";foreign_language_to_cur_language_sales|a:95:{s:6:\"現金\";s:4:\"Cash\";s:6:\"檢查\";s:6:\"Cheque\";s:9:\"禮物卡\";s:9:\"Gift Card\";s:9:\"借記卡\";s:10:\"Debit Card\";s:9:\"信用卡\";s:11:\"Credit Card\";s:12:\"商店帳號\";s:13:\"Store Account\";s:3:\"點\";s:6:\"Points\";s:8:\"Transfer\";s:8:\"Transfer\";s:7:\"Contant\";s:4:\"Cash\";s:6:\"Cheque\";s:6:\"Cheque\";s:9:\"Waardebon\";s:9:\"Gift Card\";s:9:\"Bankkaart\";s:10:\"Debit Card\";s:12:\"Kredietkaart\";s:11:\"Credit Card\";s:11:\"Op rekening\";s:13:\"Store Account\";s:6:\"Punten\";s:6:\"Points\";s:4:\"Cash\";s:4:\"Cash\";s:9:\"Gift Card\";s:9:\"Gift Card\";s:10:\"Debit Card\";s:10:\"Debit Card\";s:11:\"Credit Card\";s:11:\"Credit Card\";s:13:\"Store Account\";s:13:\"Store Account\";s:6:\"Points\";s:6:\"Points\";s:8:\"Comptant\";s:4:\"Cash\";s:7:\"Chèque\";s:6:\"Cheque\";s:12:\"Carte cadeau\";s:9:\"Gift Card\";s:12:\"Carte débit\";s:10:\"Debit Card\";s:12:\"Carte credit\";s:11:\"Credit Card\";s:14:\"Compte magasin\";s:13:\"Store Account\";s:10:\"Des points\";s:6:\"Points\";s:7:\"Bargeld\";s:4:\"Cash\";s:6:\"Scheck\";s:6:\"Cheque\";s:9:\"Gutschein\";s:9:\"Gift Card\";s:11:\"Kundenkarte\";s:10:\"Debit Card\";s:11:\"Kreditkarte\";s:11:\"Credit Card\";s:13:\"Laden-Account\";s:13:\"Store Account\";s:6:\"Punkte\";s:6:\"Points\";s:5:\"Tunai\";s:4:\"Cash\";s:3:\"Cek\";s:6:\"Cheque\";s:12:\"Hadiah Kartu\";s:9:\"Gift Card\";s:11:\"Kartu Debit\";s:10:\"Debit Card\";s:12:\"Kartu Credit\";s:11:\"Credit Card\";s:9:\"Toko Akun\";s:13:\"Store Account\";s:4:\"Poin\";s:6:\"Points\";s:8:\"Contante\";s:4:\"Cash\";s:7:\"Assegno\";s:6:\"Cheque\";s:12:\"Buono Regalo\";s:9:\"Gift Card\";s:8:\"Bancomat\";s:10:\"Debit Card\";s:16:\"Carta di Credito\";s:11:\"Credit Card\";s:14:\"Conto deposito\";s:13:\"Store Account\";s:5:\"Punti\";s:6:\"Points\";s:30:\"សាច់ប្រាក់\";s:4:\"Cash\";s:9:\"សែក\";s:6:\"Cheque\";s:33:\"កាត​រង្វាន់\";s:9:\"Gift Card\";s:36:\"ប័ណ្ណ​ឥណពន្ធ\";s:10:\"Debit Card\";s:33:\"ប័ណ្ណ​ឥណទាន\";s:11:\"Credit Card\";s:36:\"ប្រាក់ជំពាក់\";s:13:\"Store Account\";s:18:\"ពិន្ទុ\";s:6:\"Points\";s:10:\"Numerário\";s:4:\"Cash\";s:14:\"Vale de Oferta\";s:9:\"Gift Card\";s:18:\"Cartão de Débito\";s:10:\"Debit Card\";s:19:\"Cartão de Crédito\";s:11:\"Credit Card\";s:13:\"Conta da Loja\";s:13:\"Store Account\";s:6:\"Pontos\";s:6:\"Points\";s:8:\"Efectivo\";s:4:\"Cash\";s:17:\"Tarjeta de regalo\";s:9:\"Gift Card\";s:18:\"Tarjeta de débito\";s:10:\"Debit Card\";s:19:\"Tarjeta de crédito\";s:11:\"Credit Card\";s:18:\"Línea de crédito\";s:13:\"Store Account\";s:6:\"Puntos\";s:6:\"Points\";s:12:\"பணம்\";s:4:\"Cash\";s:21:\"காசோலை\";s:6:\"Cheque\";s:31:\"பரிசு அட்டை\";s:9:\"Gift Card\";s:37:\"டெபிட் கார்டு\";s:10:\"Debit Card\";s:28:\"கடன் அட்டை\";s:11:\"Credit Card\";s:52:\"கணக்கு சேமிக்கவும்\";s:13:\"Store Account\";s:27:\"புள்ளிகள்\";s:6:\"Points\";s:12:\"Tiền mặt\";s:4:\"Cash\";s:4:\"Séc\";s:6:\"Cheque\";s:17:\"Thẻ quà tặng\";s:9:\"Gift Card\";s:14:\"Thẻ ghi nợ\";s:10:\"Debit Card\";s:17:\"Thẻ tín dụng\";s:11:\"Credit Card\";s:30:\"Tài khoản của cửa hàng\";s:13:\"Store Account\";s:7:\"Điểm\";s:6:\"Points\";s:6:\"كاش\";s:4:\"Cash\";s:6:\"شيك\";s:6:\"Cheque\";s:15:\"كرت هدية\";s:9:\"Gift Card\";s:23:\"بطاقة ائتمان\";s:10:\"Debit Card\";s:27:\"بطاقة الائتمان\";s:11:\"Credit Card\";s:21:\"حساب المتجر\";s:13:\"Store Account\";s:8:\"نقاط\";s:6:\"Points\";s:6:\"现金\";s:4:\"Cash\";s:6:\"检查\";s:6:\"Cheque\";s:9:\"礼物卡\";s:9:\"Gift Card\";s:9:\"借记卡\";s:10:\"Debit Card\";s:12:\"商店帐号\";s:13:\"Store Account\";s:3:\"点\";s:6:\"Points\";}fullscreen|s:1:\"0\";keep_alive|i:1784390218;amount_change|d:-0;'),('fhbikj845o56rsqll8tgv1qaima7cuuo','102.89.46.106',1784385443,'person_id|s:1:\"3\";'),('fjt3ku4u6kejpbsgradgbfuo4u420kl4','102.219.153.111',1784376678,'person_id|s:4:\"1595\";'),('rurhpopq50v97fapd5c643o6f32k6ugg','102.219.153.118',1784469804,'person_id|s:1:\"2\";employee_current_location_id|s:1:\"1\";employee_current_register_id|N;keep_alive|i:1784469804;items_search_data|a:7:{s:6:\"offset\";i:0;s:9:\"order_col\";s:4:\"name\";s:9:\"order_dir\";s:3:\"asc\";s:6:\"search\";s:14:\"MAXY FILL 70ML\";s:11:\"category_id\";s:0:\"\";s:6:\"fields\";s:3:\"all\";s:7:\"deleted\";i:0;}'),('sebfcrr166a02cejpl02ojq6co0ndfb1','102.219.153.105',1784390477,'person_id|s:4:\"1595\";'),('si2tivl660hi3fjdgmrvo7aq2270il72','102.219.153.118',1784381933,'person_id|s:1:\"2\";'),('vgqlhjbeo5kh4o3537tsmtmscpr76jgv','102.219.153.98',1784391407,'person_id|s:4:\"1595\";items_search_data|a:7:{s:6:\"offset\";i:0;s:9:\"order_col\";s:4:\"name\";s:9:\"order_dir\";s:3:\"asc\";s:6:\"search\";s:16:\"SKIN BOOSTER EYE\";s:11:\"category_id\";s:0:\"\";s:6:\"fields\";s:3:\"all\";s:7:\"deleted\";i:0;}sale|s:2590:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:0:{}s:20:\"\0PHPPOSCart\0payments\";a:0:{}s:26:\"\0PHPPOSCart\0excluded_taxes\";a:0:{}s:16:\"\0PHPPOSCart\0mode\";s:4:\"sale\";s:34:\"\0PHPPOSCart\0paid_store_account_ids\";a:0:{}s:26:\"paid_store_account_amounts\";a:0:{}s:11:\"employee_id\";N;s:11:\"location_id\";N;s:11:\"register_id\";N;s:7:\"comment\";s:0:\"\";s:23:\"supplier_invoice_number\";N;s:16:\"selected_payment\";s:0:\"\";s:13:\"email_receipt\";b:0;s:11:\"sms_receipt\";b:0;s:9:\"suspended\";i:0;s:18:\"change_date_enable\";b:0;s:16:\"change_cart_date\";N;s:19:\"is_editing_previous\";b:0;s:20:\"custom_field_1_value\";N;s:20:\"custom_field_2_value\";N;s:20:\"custom_field_3_value\";N;s:20:\"custom_field_4_value\";N;s:20:\"custom_field_5_value\";N;s:20:\"custom_field_6_value\";N;s:20:\"custom_field_7_value\";N;s:20:\"custom_field_8_value\";N;s:20:\"custom_field_9_value\";N;s:21:\"custom_field_10_value\";N;s:31:\"work_order_custom_field_1_value\";N;s:31:\"work_order_custom_field_2_value\";N;s:31:\"work_order_custom_field_3_value\";N;s:31:\"work_order_custom_field_4_value\";N;s:31:\"work_order_custom_field_5_value\";N;s:31:\"work_order_custom_field_6_value\";N;s:31:\"work_order_custom_field_7_value\";N;s:31:\"work_order_custom_field_8_value\";N;s:31:\"work_order_custom_field_9_value\";N;s:32:\"work_order_custom_field_10_value\";N;s:18:\"override_tax_names\";N;s:21:\"override_tax_percents\";N;s:24:\"override_tax_cumulatives\";N;s:18:\"override_tax_class\";N;s:17:\"details_collapsed\";b:1;s:12:\"skip_webhook\";b:0;s:6:\"offset\";i:0;s:5:\"limit\";i:20;s:11:\"sort_column\";N;s:9:\"sort_type\";N;s:14:\"create_invoice\";N;s:17:\"create_work_order\";i:0;s:13:\"is_work_order\";b:0;s:7:\"sale_id\";N;s:14:\"return_sale_id\";N;s:11:\"customer_id\";N;s:23:\"show_comment_on_receipt\";b:0;s:16:\"selected_tier_id\";i:0;s:16:\"previous_tier_id\";i:0;s:19:\"sold_by_employee_id\";s:4:\"1595\";s:15:\"discount_reason\";s:0:\"\";s:12:\"has_delivery\";b:0;s:8:\"delivery\";O:18:\"PHPPOSCartDelivery\":3:{s:13:\"delivery_info\";N;s:21:\"delivery_tax_group_id\";N;s:20:\"delivery_person_info\";N;}s:20:\"partial_transactions\";a:0:{}s:17:\"use_cc_saved_info\";b:0;s:10:\"invoice_no\";s:0:\"\";s:15:\"prompt_for_card\";b:0;s:11:\"ebt_voucher\";s:0:\"\";s:14:\"ebt_voucher_no\";s:0:\"\";s:13:\"ebt_auth_code\";s:0:\"\";s:21:\"save_credit_card_info\";b:0;s:17:\"use_saved_cc_info\";b:0;s:15:\"redeem_discount\";b:0;s:21:\"sale_exchange_details\";s:0:\"\";s:7:\"coupons\";a:0:{}s:12:\"is_ecommerce\";b:0;s:29:\"integrated_gift_card_balances\";a:0:{}s:3:\"age\";N;s:12:\"taxjar_taxes\";a:0:{}s:22:\"was_last_edit_quantity\";b:0;s:25:\"show_terms_and_conditions\";s:0:\"\";s:24:\"customer_subscription_id\";N;s:13:\"return_reason\";N;}\";employee_current_register_id|s:1:\"2\";foreign_language_to_cur_language_sales|a:95:{s:6:\"現金\";s:4:\"Cash\";s:6:\"檢查\";s:6:\"Cheque\";s:9:\"禮物卡\";s:9:\"Gift Card\";s:9:\"借記卡\";s:10:\"Debit Card\";s:9:\"信用卡\";s:11:\"Credit Card\";s:12:\"商店帳號\";s:13:\"Store Account\";s:3:\"點\";s:6:\"Points\";s:8:\"Transfer\";s:8:\"Transfer\";s:7:\"Contant\";s:4:\"Cash\";s:6:\"Cheque\";s:6:\"Cheque\";s:9:\"Waardebon\";s:9:\"Gift Card\";s:9:\"Bankkaart\";s:10:\"Debit Card\";s:12:\"Kredietkaart\";s:11:\"Credit Card\";s:11:\"Op rekening\";s:13:\"Store Account\";s:6:\"Punten\";s:6:\"Points\";s:4:\"Cash\";s:4:\"Cash\";s:9:\"Gift Card\";s:9:\"Gift Card\";s:10:\"Debit Card\";s:10:\"Debit Card\";s:11:\"Credit Card\";s:11:\"Credit Card\";s:13:\"Store Account\";s:13:\"Store Account\";s:6:\"Points\";s:6:\"Points\";s:8:\"Comptant\";s:4:\"Cash\";s:7:\"Chèque\";s:6:\"Cheque\";s:12:\"Carte cadeau\";s:9:\"Gift Card\";s:12:\"Carte débit\";s:10:\"Debit Card\";s:12:\"Carte credit\";s:11:\"Credit Card\";s:14:\"Compte magasin\";s:13:\"Store Account\";s:10:\"Des points\";s:6:\"Points\";s:7:\"Bargeld\";s:4:\"Cash\";s:6:\"Scheck\";s:6:\"Cheque\";s:9:\"Gutschein\";s:9:\"Gift Card\";s:11:\"Kundenkarte\";s:10:\"Debit Card\";s:11:\"Kreditkarte\";s:11:\"Credit Card\";s:13:\"Laden-Account\";s:13:\"Store Account\";s:6:\"Punkte\";s:6:\"Points\";s:5:\"Tunai\";s:4:\"Cash\";s:3:\"Cek\";s:6:\"Cheque\";s:12:\"Hadiah Kartu\";s:9:\"Gift Card\";s:11:\"Kartu Debit\";s:10:\"Debit Card\";s:12:\"Kartu Credit\";s:11:\"Credit Card\";s:9:\"Toko Akun\";s:13:\"Store Account\";s:4:\"Poin\";s:6:\"Points\";s:8:\"Contante\";s:4:\"Cash\";s:7:\"Assegno\";s:6:\"Cheque\";s:12:\"Buono Regalo\";s:9:\"Gift Card\";s:8:\"Bancomat\";s:10:\"Debit Card\";s:16:\"Carta di Credito\";s:11:\"Credit Card\";s:14:\"Conto deposito\";s:13:\"Store Account\";s:5:\"Punti\";s:6:\"Points\";s:30:\"សាច់ប្រាក់\";s:4:\"Cash\";s:9:\"សែក\";s:6:\"Cheque\";s:33:\"កាត​រង្វាន់\";s:9:\"Gift Card\";s:36:\"ប័ណ្ណ​ឥណពន្ធ\";s:10:\"Debit Card\";s:33:\"ប័ណ្ណ​ឥណទាន\";s:11:\"Credit Card\";s:36:\"ប្រាក់ជំពាក់\";s:13:\"Store Account\";s:18:\"ពិន្ទុ\";s:6:\"Points\";s:10:\"Numerário\";s:4:\"Cash\";s:14:\"Vale de Oferta\";s:9:\"Gift Card\";s:18:\"Cartão de Débito\";s:10:\"Debit Card\";s:19:\"Cartão de Crédito\";s:11:\"Credit Card\";s:13:\"Conta da Loja\";s:13:\"Store Account\";s:6:\"Pontos\";s:6:\"Points\";s:8:\"Efectivo\";s:4:\"Cash\";s:17:\"Tarjeta de regalo\";s:9:\"Gift Card\";s:18:\"Tarjeta de débito\";s:10:\"Debit Card\";s:19:\"Tarjeta de crédito\";s:11:\"Credit Card\";s:18:\"Línea de crédito\";s:13:\"Store Account\";s:6:\"Puntos\";s:6:\"Points\";s:12:\"பணம்\";s:4:\"Cash\";s:21:\"காசோலை\";s:6:\"Cheque\";s:31:\"பரிசு அட்டை\";s:9:\"Gift Card\";s:37:\"டெபிட் கார்டு\";s:10:\"Debit Card\";s:28:\"கடன் அட்டை\";s:11:\"Credit Card\";s:52:\"கணக்கு சேமிக்கவும்\";s:13:\"Store Account\";s:27:\"புள்ளிகள்\";s:6:\"Points\";s:12:\"Tiền mặt\";s:4:\"Cash\";s:4:\"Séc\";s:6:\"Cheque\";s:17:\"Thẻ quà tặng\";s:9:\"Gift Card\";s:14:\"Thẻ ghi nợ\";s:10:\"Debit Card\";s:17:\"Thẻ tín dụng\";s:11:\"Credit Card\";s:30:\"Tài khoản của cửa hàng\";s:13:\"Store Account\";s:7:\"Điểm\";s:6:\"Points\";s:6:\"كاش\";s:4:\"Cash\";s:6:\"شيك\";s:6:\"Cheque\";s:15:\"كرت هدية\";s:9:\"Gift Card\";s:23:\"بطاقة ائتمان\";s:10:\"Debit Card\";s:27:\"بطاقة الائتمان\";s:11:\"Credit Card\";s:21:\"حساب المتجر\";s:13:\"Store Account\";s:8:\"نقاط\";s:6:\"Points\";s:6:\"现金\";s:4:\"Cash\";s:6:\"检查\";s:6:\"Cheque\";s:9:\"礼物卡\";s:9:\"Gift Card\";s:9:\"借记卡\";s:10:\"Debit Card\";s:12:\"商店帐号\";s:13:\"Store Account\";s:3:\"点\";s:6:\"Points\";}fullscreen|s:1:\"0\";amount_change|d:-0;async_inventory_updates|a:0:{}'),('vpb5hn7rcpe5i2lq1p0p35oehmqgfi02','102.219.153.98',1784390796,'person_id|s:4:\"1595\";');

--
-- 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) 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=utf8mb3 COLLATE=utf8mb3_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) NOT NULL,
  `order` int(10) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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) 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=utf8mb3 COLLATE=utf8mb3_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 NOT NULL,
  `state` int(1) NOT NULL DEFAULT 0,
  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=utf8mb3 COLLATE=utf8mb3_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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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


--
-- Table structure for table `phppos_supplier_invoice_details`
--

CREATE TABLE `phppos_supplier_invoice_details` (
  `invoice_details_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `line_id` int(11) DEFAULT NULL,
  `receiving_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `total` decimal(23,10) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`invoice_details_id`) USING BTREE,
  KEY `phppos_supplier_invoice_details_ibfk_1` (`receiving_id`),
  KEY `phppos_supplier_invoice_details_ibfk_2` (`invoice_id`),
  CONSTRAINT `phppos_supplier_invoice_details_ibfk_1` FOREIGN KEY (`receiving_id`) REFERENCES `phppos_receivings` (`receiving_id`),
  CONSTRAINT `phppos_supplier_invoice_details_ibfk_2` FOREIGN KEY (`invoice_id`) REFERENCES `phppos_supplier_invoices` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_supplier_invoice_details`
--


--
-- Table structure for table `phppos_supplier_invoices`
--

CREATE TABLE `phppos_supplier_invoices` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `supplier_po` varchar(255) DEFAULT NULL,
  `term_id` int(11) DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `total` decimal(23,10) DEFAULT NULL,
  `balance` decimal(23,10) DEFAULT NULL,
  `last_paid` date DEFAULT NULL,
  `deleted` int(1) DEFAULT 0,
  PRIMARY KEY (`invoice_id`) USING BTREE,
  KEY `phppos_supplier_invoices_ibfk_1` (`term_id`),
  KEY `phppos_supplier_invoices_ibfk_2` (`supplier_id`),
  KEY `phppos_supplier_invoices_ibfk_3` (`location_id`),
  CONSTRAINT `phppos_supplier_invoices_ibfk_1` FOREIGN KEY (`term_id`) REFERENCES `phppos_terms` (`term_id`),
  CONSTRAINT `phppos_supplier_invoices_ibfk_2` FOREIGN KEY (`supplier_id`) REFERENCES `phppos_suppliers` (`person_id`),
  CONSTRAINT `phppos_supplier_invoices_ibfk_3` FOREIGN KEY (`location_id`) REFERENCES `phppos_locations` (`location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_supplier_invoices`
--


--
-- 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 NOT NULL,
  `state` int(1) NOT NULL DEFAULT 0,
  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=utf8mb3 COLLATE=utf8mb3_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=utf8mb3 COLLATE=utf8mb3_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) NOT NULL,
  `account_number` varchar(255) 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) DEFAULT NULL,
  `custom_field_2_value` varchar(255) DEFAULT NULL,
  `custom_field_3_value` varchar(255) DEFAULT NULL,
  `custom_field_4_value` varchar(255) DEFAULT NULL,
  `custom_field_5_value` varchar(255) DEFAULT NULL,
  `custom_field_6_value` varchar(255) DEFAULT NULL,
  `custom_field_7_value` varchar(255) DEFAULT NULL,
  `custom_field_8_value` varchar(255) DEFAULT NULL,
  `custom_field_9_value` varchar(255) DEFAULT NULL,
  `custom_field_10_value` varchar(255) DEFAULT NULL,
  `internal_notes` text DEFAULT NULL,
  `default_term_id` int(11) 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=utf8mb3 COLLATE=utf8mb3_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) 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=utf8mb3 COLLATE=utf8mb3_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) DEFAULT NULL,
  `last_modified` timestamp NOT NULL DEFAULT current_timestamp(),
  `deleted` int(1) NOT NULL DEFAULT 0,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_name` (`name`),
  KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_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) NOT NULL,
  `ecommerce_tax_class_id` varchar(255) 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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `phppos_tax_classes` VALUES (1,1,NULL,1,'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) NOT NULL,
  `percent` decimal(15,3) NOT NULL,
  `cumulative` int(1) NOT NULL DEFAULT 0,
  `ecommerce_tax_class_tax_rate_id` varchar(255) 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `phppos_tax_classes_taxes` VALUES (1,1,1,'VAT',7.500,0,NULL);

--
-- Table structure for table `phppos_terms`
--

CREATE TABLE `phppos_terms` (
  `term_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `days_due` int(11) DEFAULT 30,
  `deleted` int(1) DEFAULT 0,
  PRIMARY KEY (`term_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_terms`
--


--
-- Table structure for table `phppos_work_order_files`
--

CREATE TABLE `phppos_work_order_files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `file_id` int(11) NOT NULL,
  `work_order_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `work_order_id` (`work_order_id`),
  KEY `file_id_2` (`file_id`),
  KEY `work_order_id_2` (`work_order_id`),
  CONSTRAINT `phppos_work_order_files_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `phppos_app_files` (`file_id`),
  CONSTRAINT `phppos_work_order_files_ibfk_2` FOREIGN KEY (`work_order_id`) REFERENCES `phppos_sales_work_orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_work_order_files`
--


--
-- Table structure for table `phppos_work_order_log`
--

CREATE TABLE `phppos_work_order_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `work_order_id` int(10) NOT NULL,
  `activity_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `employee_id` int(10) NOT NULL,
  `activity_text` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phppos_work_order_log_ibfk_1` (`work_order_id`),
  KEY `phppos_work_order_log_ibfk_2` (`employee_id`),
  CONSTRAINT `phppos_work_order_log_ibfk_1` FOREIGN KEY (`work_order_id`) REFERENCES `phppos_sales_work_orders` (`id`),
  CONSTRAINT `phppos_work_order_log_ibfk_2` FOREIGN KEY (`employee_id`) REFERENCES `phppos_employees` (`person_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_work_order_log`
--


--
-- Table structure for table `phppos_work_orders_email_templates`
--

CREATE TABLE `phppos_work_orders_email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status_id` int(11) NOT NULL,
  `content` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_work_orders_email_templates`
--


--
-- Table structure for table `phppos_workorder_checkbox_groups`
--

CREATE TABLE `phppos_workorder_checkbox_groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `sort_order` int(10) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `sort_index` (`deleted`,`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_workorder_checkbox_groups`
--


--
-- Table structure for table `phppos_workorder_checkboxes`
--

CREATE TABLE `phppos_workorder_checkboxes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) DEFAULT 0,
  `deleted` tinyint(1) NOT NULL DEFAULT 0,
  `last_modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `group_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `phppos_workorder_checkboxes_ibfk_1` (`group_id`),
  CONSTRAINT `phppos_workorder_checkboxes_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `phppos_workorder_checkbox_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_workorder_checkboxes`
--


--
-- Table structure for table `phppos_workorder_checkboxes_states`
--

CREATE TABLE `phppos_workorder_checkboxes_states` (
  `checkbox_id` int(10) NOT NULL,
  `workorder_id` int(10) NOT NULL,
  PRIMARY KEY (`checkbox_id`,`workorder_id`) USING BTREE,
  KEY `workorder_id` (`workorder_id`),
  CONSTRAINT `phppos_workorder_checkboxes_states_ibfk_1` FOREIGN KEY (`workorder_id`) REFERENCES `phppos_sales_work_orders` (`id`),
  CONSTRAINT `phppos_workorder_checkboxes_states_ibfk_2` FOREIGN KEY (`checkbox_id`) REFERENCES `phppos_workorder_checkboxes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_workorder_checkboxes_states`
--


--
-- Table structure for table `phppos_workorder_statuses`
--

CREATE TABLE `phppos_workorder_statuses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `notify_by_email` tinyint(1) DEFAULT 0,
  `notify_by_sms` tinyint(1) DEFAULT 0,
  `color` text DEFAULT NULL,
  `sort_order` int(11) DEFAULT 0,
  `last_modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `phppos_workorder_statuses`
--

INSERT INTO `phppos_workorder_statuses` VALUES (1,'lang:work_orders_new',NULL,0,0,'#4594cc',10,'2020-07-09 09:32:32'),(2,'lang:work_orders_in_progress',NULL,0,0,'#28a745',20,'2020-07-09 09:32:47'),(3,'lang:work_orders_out_for_repair',NULL,0,0,'#f7ac08',30,'2020-07-09 09:32:54'),(4,'lang:work_orders_waiting_on_customer',NULL,0,0,'#6a0dad',40,'2020-07-09 09:33:01'),(5,'lang:work_orders_repaired',NULL,0,0,'#006400',50,'2020-07-09 09:33:09'),(6,'lang:work_orders_complete',NULL,0,0,'#28a745',60,'2020-07-09 09:33:17'),(7,'lang:work_orders_cancelled',NULL,0,0,'#fb5d5d',70,'2020-07-09 09:33:34');

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

CREATE TABLE `phppos_zips` (
  `name` varchar(255) 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=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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



