(5942,29,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,416.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5942,39,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5943,29,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,416.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5943,39,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5944,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5945,4,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4040.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5945,173,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5946,5,NULL,NULL,NULL,'',NULL,2,5.0000000000,5.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,12500.0000000000,0.0000000000,12500.0000000000,7583.3500000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5946,61,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,226,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5946,135,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,31167.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,28833.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,190,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5947,4,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5948,39,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5948,46,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,950.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5949,4,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5950,31,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1083.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5950,46,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,950.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5951,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5952,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5953,13,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,28,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5953,36,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5954,29,NULL,NULL,NULL,'',NULL,3,4.0000000000,4.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,3200.0000000000,0.0000000000,3200.0000000000,1666.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5954,31,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5954,36,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,1600.0000000000,0.0000000000,1600.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5954,39,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5955,36,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5955,173,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5956,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5957,1,NULL,NULL,NULL,'',NULL,3,3.0000000000,3.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,3200.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5957,4,NULL,NULL,NULL,'',NULL,2,6.0000000000,6.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,10800.0000000000,0.0000000000,10800.0000000000,6060.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5957,16,NULL,NULL,NULL,'',NULL,1,3.0000000000,3.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,2400.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5957,36,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5958,4,NULL,NULL,NULL,'',NULL,1,4.0000000000,4.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4040.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5958,173,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5959,1,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1066.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5959,4,NULL,NULL,NULL,'',NULL,0,5.0000000000,5.0000000000,790.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,12500.0000000000,0.0000000000,12500.0000000000,8550.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5959,15,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,683.0000000000,1500.0000000000,1500.0000000000,0.000,0.0000000000,0.0000000000,1500.0000000000,0.0000000000,1500.0000000000,817.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,34,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5959,16,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5960,1,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1066.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5960,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5961,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5961,36,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5962,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5963,1,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,733.3300000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,4000.0000000000,0.0000000000,4000.0000000000,2533.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,2,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5963,34,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,583.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,834.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,205,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5963,36,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5963,46,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,750.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1050.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,74,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5964,1,NULL,NULL,NULL,'',NULL,4,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5964,4,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,8,NULL,NULL,NULL,0,NULL),(5964,5,NULL,NULL,NULL,'',NULL,7,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,9,NULL,NULL,NULL,0,NULL),(5964,16,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,6,NULL,NULL,NULL,0,NULL),(5964,36,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5964,37,NULL,NULL,NULL,'',NULL,3,2.0000000000,2.0000000000,479.1700000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1041.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,419,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5964,39,NULL,NULL,NULL,'',NULL,8,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,10,NULL,NULL,NULL,0,NULL),(5964,46,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,5100.0000000000,0.0000000000,5100.0000000000,2850.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5964,66,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,5000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,92,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5965,13,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,800.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1200.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,27,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5965,36,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5966,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5967,13,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,800.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1200.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,27,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5968,5,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,983.3333333333,2700.0000000000,2700.0000000000,0.000,0.0000000000,0.0000000000,2700.0000000000,0.0000000000,2700.0000000000,1716.6700000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5968,36,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,150.0000000000,500.0000000000,500.0000000000,0.000,0.0000000000,0.0000000000,500.0000000000,0.0000000000,500.0000000000,350.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5968,40,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1241.6666666666,2700.0000000000,2700.0000000000,0.000,0.0000000000,0.0000000000,2700.0000000000,0.0000000000,2700.0000000000,1458.3300000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5968,51,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,5208.3333333333,10000.0000000000,10000.0000000000,0.000,0.0000000000,0.0000000000,10000.0000000000,0.0000000000,10000.0000000000,4791.6700000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5968,197,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,458.3333333333,1200.0000000000,1200.0000000000,0.000,0.0000000000,0.0000000000,1200.0000000000,0.0000000000,1200.0000000000,741.6700000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5969,36,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5969,39,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,984.3000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1015.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,61,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5969,40,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5970,36,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5971,4,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5971,37,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,479.1700000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,520.8300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,419,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5972,5,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5973,31,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1083.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5974,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5974,61,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,226,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5975,8,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,800.0000000000,1500.0000000000,1500.0000000000,0.000,0.0000000000,0.0000000000,1500.0000000000,0.0000000000,1500.0000000000,700.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,19,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5975,36,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5975,66,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,5000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,92,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5975,75,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1645.0000000000,3000.0000000000,3000.0000000000,0.000,0.0000000000,0.0000000000,3000.0000000000,0.0000000000,3000.0000000000,1355.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,108,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5975,197,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,455,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5976,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5977,4,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,3030.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5978,16,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,6,NULL,NULL,NULL,0,NULL),(5978,29,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,416.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5978,39,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5978,40,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1258.3300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5978,46,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,950.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5978,207,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1799.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,482,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5979,29,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,3200.0000000000,0.0000000000,3200.0000000000,1666.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5979,34,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,583.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,417.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,206,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5979,36,NULL,NULL,NULL,'',NULL,2,4.0000000000,4.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,1600.0000000000,0.0000000000,1600.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5979,39,NULL,NULL,NULL,'',NULL,3,2.0000000000,2.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,1631.4000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5979,173,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5980,4,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2020.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5980,16,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,1600.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5980,36,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5980,39,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5981,4,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5981,16,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5982,73,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1552.0000000000,3000.0000000000,3000.0000000000,0.000,0.0000000000,0.0000000000,3000.0000000000,0.0000000000,3000.0000000000,1448.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,103,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5983,31,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5983,36,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5983,66,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,5000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,92,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5983,186,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1479.1666700000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1020.8300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,428,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5983,202,NULL,NULL,NULL,'',NULL,4,2.0000000000,2.0000000000,8800.0000000000,21600.0000000000,21600.0000000000,0.000,0.0000000000,0.0000000000,43200.0000000000,0.0000000000,43200.0000000000,25600.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,17,NULL,NULL,0,NULL),(5984,37,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,479.1700000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,520.8300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,419,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5984,46,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,3400.0000000000,0.0000000000,3400.0000000000,1900.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5985,36,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,1600.0000000000,0.0000000000,1600.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5986,4,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5986,29,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,416.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5986,36,NULL,NULL,NULL,'',NULL,0,6.0000000000,6.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,2400.0000000000,0.0000000000,2400.0000000000,1500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5986,173,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5987,5,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,202,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5988,5,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,202,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5989,1,NULL,NULL,NULL,'',NULL,3,4.0000000000,4.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4266.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5989,4,NULL,NULL,NULL,'',NULL,2,10.0000000000,10.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,18000.0000000000,0.0000000000,18000.0000000000,10100.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5989,13,NULL,NULL,NULL,'',NULL,6,3.0000000000,3.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,3000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,28,1.0000000000,7,NULL,NULL,NULL,0,NULL),(5989,16,NULL,NULL,NULL,'',NULL,5,3.0000000000,3.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,2400.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,6,NULL,NULL,NULL,0,NULL),(5989,25,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,675.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,51,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5989,36,NULL,NULL,NULL,'',NULL,8,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,9,NULL,NULL,NULL,0,NULL),(5989,39,NULL,NULL,NULL,'',NULL,7,2.0000000000,2.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,1631.4000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,8,NULL,NULL,NULL,0,NULL),(5989,40,NULL,NULL,NULL,'',NULL,4,3.0000000000,3.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,7500.0000000000,0.0000000000,7500.0000000000,3774.9900000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5989,207,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1799.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,482,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5990,1,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,733.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1766.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,1,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5990,19,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,583.3300000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,1116.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,40,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5991,29,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,1600.0000000000,0.0000000000,1600.0000000000,833.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5991,36,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5991,61,NULL,NULL,NULL,'',NULL,3,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5991,123,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,30000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5992,29,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,416.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5992,36,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5992,123,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,30000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5992,173,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5993,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5993,4,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5994,1,NULL,NULL,NULL,'',NULL,2,3.0000000000,3.0000000000,733.3300000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,6000.0000000000,0.0000000000,6000.0000000000,3800.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,2,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5994,8,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,800.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,900.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,18,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5994,27,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,842.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1158.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,55,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5994,29,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,383.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,616.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,408,1.0000000000,6,NULL,NULL,NULL,0,NULL),(5994,34,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,583.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,417.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,205,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5994,40,NULL,NULL,NULL,'',NULL,6,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,7,NULL,NULL,NULL,0,NULL),(5994,207,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1184.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1316.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5995,1,NULL,NULL,NULL,'',NULL,6,3.0000000000,3.0000000000,733.3300000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,6000.0000000000,0.0000000000,6000.0000000000,3800.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,2,1.0000000000,7,NULL,NULL,NULL,0,NULL),(5995,8,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,800.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,900.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,18,1.0000000000,6,NULL,NULL,NULL,0,NULL),(5995,27,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,842.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1158.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,55,1.0000000000,5,NULL,NULL,NULL,0,NULL),(5995,29,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,383.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,616.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,408,1.0000000000,4,NULL,NULL,NULL,0,NULL),(5995,34,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,583.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,417.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,205,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5995,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5995,207,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1184.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1316.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5996,4,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4040.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5996,173,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5997,61,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5997,123,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,30000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(5997,174,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,800.0000000000,1500.0000000000,1500.0000000000,0.000,0.0000000000,0.0000000000,1500.0000000000,0.0000000000,1500.0000000000,700.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(5998,6,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,13,1.0000000000,1,NULL,NULL,NULL,0,NULL),(5999,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6000,5,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6000,13,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,28,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6000,16,NULL,NULL,NULL,'',NULL,4,2.0000000000,2.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,1600.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6000,29,NULL,NULL,NULL,'',NULL,1,3.0000000000,3.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,2400.0000000000,0.0000000000,2400.0000000000,1250.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6000,36,NULL,NULL,NULL,'',NULL,5,3.0000000000,3.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,1200.0000000000,0.0000000000,1200.0000000000,750.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6000,39,NULL,NULL,NULL,'',NULL,7,2.0000000000,2.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,1631.4000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,8,NULL,NULL,NULL,0,NULL),(6000,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6000,42,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,416,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6001,8,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,800.0000000000,1500.0000000000,1500.0000000000,0.000,0.0000000000,0.0000000000,1500.0000000000,0.0000000000,1500.0000000000,700.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,19,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6001,36,NULL,NULL,NULL,'',NULL,2,5.0000000000,5.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6001,39,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6001,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6001,173,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6002,5,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,983.3300000000,2700.0000000000,2700.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,3433.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,201,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6002,36,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,150.0000000000,500.0000000000,500.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,700.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,212,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6002,40,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1241.6700000000,2700.0000000000,2700.0000000000,0.000,0.0000000000,0.0000000000,2700.0000000000,0.0000000000,2700.0000000000,1458.3300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,64,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6003,1,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1066.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6003,4,NULL,NULL,NULL,'',NULL,3,2.0000000000,2.0000000000,790.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,3420.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6003,16,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6003,36,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6003,39,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,984.3000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1515.7000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6003,61,NULL,NULL,NULL,'',NULL,1,3.0000000000,3.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,7500.0000000000,0.0000000000,7500.0000000000,3750.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6003,123,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,30000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6004,1,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1066.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6004,4,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,790.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,3420.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6004,16,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6004,36,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,150.0000000000,500.0000000000,500.0000000000,0.000,0.0000000000,0.0000000000,500.0000000000,0.0000000000,500.0000000000,350.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6004,39,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,984.3000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1515.7000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6004,61,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,7500.0000000000,0.0000000000,7500.0000000000,3750.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6004,123,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,120000.0000000000,0.0000000000,120000.0000000000,60000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6005,1,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1066.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6005,4,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2020.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6005,16,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6005,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6005,39,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6005,61,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6005,123,NULL,NULL,NULL,'',NULL,6,2.0000000000,2.0000000000,30000.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,120000.0000000000,0.0000000000,120000.0000000000,60000.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6006,1,NULL,NULL,NULL,'',NULL,5,4.0000000000,4.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4266.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6006,13,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,28,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6006,16,NULL,NULL,NULL,'',NULL,8,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,9,NULL,NULL,NULL,0,NULL),(6006,27,NULL,NULL,NULL,'',NULL,9,1.0000000000,1.0000000000,842.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,958.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,56,1.0000000000,10,NULL,NULL,NULL,0,NULL),(6006,29,NULL,NULL,NULL,'',NULL,7,2.0000000000,2.0000000000,383.3300000000,800.0000000000,800.0000000000,0.000,0.0000000000,0.0000000000,1600.0000000000,0.0000000000,1600.0000000000,833.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,407,1.0000000000,8,NULL,NULL,NULL,0,NULL),(6006,31,NULL,NULL,NULL,'',NULL,3,2.0000000000,2.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1083.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6006,34,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,583.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,417.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,206,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6006,36,NULL,NULL,NULL,'',NULL,4,6.0000000000,6.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,2400.0000000000,0.0000000000,2400.0000000000,1500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6006,39,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6006,66,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,5000.0000000000,15000.0000000000,15000.0000000000,0.000,0.0000000000,0.0000000000,15000.0000000000,0.0000000000,15000.0000000000,10000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,92,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6007,29,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,383.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1233.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,408,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6007,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6008,29,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,383.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1233.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,408,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6008,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6009,1,NULL,NULL,NULL,'',NULL,5,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6009,4,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1010.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,5,NULL,NULL,NULL,0,NULL),(6009,16,NULL,NULL,NULL,'',NULL,6,1.0000000000,1.0000000000,1000.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,800.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,37,1.0000000000,7,NULL,NULL,NULL,0,NULL),(6009,31,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6009,36,NULL,NULL,NULL,'',NULL,3,10.0000000000,10.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,4000.0000000000,0.0000000000,4000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6009,39,NULL,NULL,NULL,'',NULL,7,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,8,NULL,NULL,NULL,0,NULL),(6009,46,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,750.0000000000,1700.0000000000,1700.0000000000,0.000,0.0000000000,0.0000000000,1700.0000000000,0.0000000000,1700.0000000000,950.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,73,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6009,197,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,455,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6010,36,NULL,NULL,NULL,'',NULL,1,5.0000000000,5.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6010,39,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,984.3000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,815.7000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,62,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6010,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6010,173,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6011,61,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,228,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6012,31,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6012,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6012,190,NULL,NULL,NULL,'',NULL,2,3.0000000000,3.0000000000,900.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,2700.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,458,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6013,31,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,435,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6014,31,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,3000.0000000000,0.0000000000,3000.0000000000,1625.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,435,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6014,40,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1258.3300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6015,61,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,226,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6015,135,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,31167.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,28833.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,190,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6016,61,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,1250.0000000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2500.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6016,135,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,31167.0000000000,60000.0000000000,60000.0000000000,0.000,0.0000000000,0.0000000000,60000.0000000000,0.0000000000,60000.0000000000,28833.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6017,1,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,733.3300000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,3600.0000000000,0.0000000000,3600.0000000000,2133.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,3,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6017,5,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1516.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6018,4,NULL,NULL,NULL,'',NULL,1,4.0000000000,4.0000000000,790.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,7200.0000000000,0.0000000000,7200.0000000000,4040.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,10,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6018,5,NULL,NULL,NULL,'',NULL,0,4.0000000000,4.0000000000,983.3300000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,10000.0000000000,0.0000000000,10000.0000000000,6066.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,203,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6018,173,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,1430.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,570.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6019,31,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,435,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6019,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6020,31,NULL,NULL,NULL,'',NULL,1,3.0000000000,3.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,3000.0000000000,0.0000000000,3000.0000000000,1625.0100000000,NULL,NULL,0.0000000000,NULL,1.0000000000,435,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6020,40,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,2500.0000000000,0.0000000000,2500.0000000000,1258.3300000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6021,27,NULL,NULL,NULL,'',NULL,2,2.0000000000,2.0000000000,842.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,4000.0000000000,0.0000000000,4000.0000000000,2316.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,55,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6021,29,NULL,NULL,NULL,'',NULL,1,2.0000000000,2.0000000000,383.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1233.3400000000,NULL,NULL,0.0000000000,NULL,1.0000000000,408,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6021,40,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,5000.0000000000,0.0000000000,5000.0000000000,2516.6600000000,NULL,NULL,0.0000000000,NULL,1.0000000000,65,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6022,13,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,800.0000000000,2000.0000000000,2000.0000000000,0.000,0.0000000000,0.0000000000,2000.0000000000,0.0000000000,2000.0000000000,1200.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,27,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6022,31,NULL,NULL,NULL,'',NULL,1,4.0000000000,4.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,4000.0000000000,0.0000000000,4000.0000000000,2166.6800000000,NULL,NULL,0.0000000000,NULL,1.0000000000,435,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6023,36,NULL,NULL,NULL,'',NULL,0,1.0000000000,1.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,400.0000000000,0.0000000000,400.0000000000,250.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,211,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6024,6,NULL,NULL,NULL,'',NULL,0,3.0000000000,3.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,5400.0000000000,0.0000000000,5400.0000000000,3000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,13,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6024,42,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,416,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6024,53,NULL,NULL,NULL,'',NULL,2,1.0000000000,1.0000000000,205.0000000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,795.0000000000,NULL,NULL,0.0000000000,NULL,NULL,NULL,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6025,19,NULL,NULL,NULL,'',NULL,5,1.0000000000,1.0000000000,583.3300000000,1300.0000000000,1300.0000000000,0.000,0.0000000000,0.0000000000,1300.0000000000,0.0000000000,1300.0000000000,716.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,42,1.0000000000,6,NULL,NULL,NULL,0,NULL),(6025,31,NULL,NULL,NULL,'',NULL,1,1.0000000000,1.0000000000,458.3300000000,1000.0000000000,1000.0000000000,0.000,0.0000000000,0.0000000000,1000.0000000000,0.0000000000,1000.0000000000,541.6700000000,NULL,NULL,0.0000000000,NULL,1.0000000000,436,1.0000000000,2,NULL,NULL,NULL,0,NULL),(6025,36,NULL,NULL,NULL,'',NULL,0,2.0000000000,2.0000000000,150.0000000000,400.0000000000,400.0000000000,0.000,0.0000000000,0.0000000000,800.0000000000,0.0000000000,800.0000000000,500.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,210,1.0000000000,1,NULL,NULL,NULL,0,NULL),(6025,40,NULL,NULL,NULL,'',NULL,2,3.0000000000,3.0000000000,1241.6700000000,2500.0000000000,2500.0000000000,0.000,0.0000000000,0.0000000000,7500.0000000000,0.0000000000,7500.0000000000,3774.9900000000,NULL,NULL,0.0000000000,NULL,1.0000000000,213,1.0000000000,3,NULL,NULL,NULL,0,NULL),(6025,42,NULL,NULL,NULL,'',NULL,3,1.0000000000,1.0000000000,800.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1000.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,416,1.0000000000,4,NULL,NULL,NULL,0,NULL),(6025,207,NULL,NULL,NULL,'',NULL,4,1.0000000000,1.0000000000,1.0000000000,1800.0000000000,1800.0000000000,0.000,0.0000000000,0.0000000000,1800.0000000000,0.0000000000,1800.0000000000,1799.0000000000,NULL,NULL,0.0000000000,NULL,1.0000000000,482,1.0000000000,5,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`
--


--
-- 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 ('5ga0a43m1pn1kaeemhb8uu2tuj8rf95g','67.211.222.228',1784487307,'person_id|s:1:\"1\";'),('7e4jsl8b6sf37b2nf8n7kufbb9enbggr','40.77.167.27',1784476168,''),('ehfbobpabug54hm40ar0e007k23bnn7l','135.129.124.84',1784498730,'person_id|s:2:\"22\";'),('ejgj5kmogci8eb3bfn689sgcmv91c98h','135.129.124.84',1784534215,'person_id|s:2:\"26\";sale|s:20421:\"O:14:\"PHPPOSCartSale\":82:{s:19:\"\0PHPPOSCart\0cart_id\";s:4:\"sale\";s:22:\"\0PHPPOSCart\0cart_items\";a:8:{i:0;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:17:\"46|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:14:\"ORIGIN BITTERS\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:7:\"2500.00\";s:10:\"cost_price\";s:14:\"833.3333333333\";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:\"7\";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:\"1784506581 6a5d68d501c47\";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:46;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:3:{i:73;s:8:\"BUSH BAR\";i:74;s:8:\"OPEN BAR\";i:216;s:3:\"VIP\";}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:15:\"2500.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:17:\"37|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:5:\"TONIC\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:7:\"1200.00\";s:10:\"cost_price\";s:14:\"479.1666666660\";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:\"4\";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:\"1784506585 6a5d68d961835\";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:37;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:3:{i:417;s:3:\"VIP\";i:418;s:8:\"OPEN BAR\";i:419;s:8:\"BUSH BAR\";}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:15:\"1200.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:17:\"29|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:4:\"COKE\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:7:\"1200.00\";s:10:\"cost_price\";s:14:\"383.3333333330\";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:\"4\";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:\"1784506590 6a5d68de243ab\";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:29;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:3:{i:407;s:8:\"BUSH BAR\";i:408;s:8:\"OPEN BAR\";i:409;s:3:\"VIP\";}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:15:\"1200.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:3;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:17:\"36|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:4;s:4:\"name\";s:5:\"WATER\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:6:\"500.00\";s:10:\"cost_price\";s:14:\"150.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:\"4\";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:\"1784506594 6a5d68e2d9793\";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:36;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:3:{i:210;s:8:\"BUSH BAR\";i:211;s:8:\"OPEN BAR\";i:212;s:3:\"VIP\";}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:14:\"500.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:4;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:16:\"4|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:5;s:4:\"name\";s:5:\"TIGER\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:7:\"2500.00\";s:10:\"cost_price\";s:14:\"790.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:\"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:\"1784506599 6a5d68e7d7e02\";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:4;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:3:{i:8;s:3:\"VIP\";i:9;s:8:\"OPEN BAR\";i:10;s:8:\"BUSH BAR\";}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:15:\"2500.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:5;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:16:\"1|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:6;s:4:\"name\";s:6:\"TROPHY\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:7:\"2500.00\";s:10:\"cost_price\";s:14:\"733.3333333333\";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:\"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:\"1784506608 6a5d68f00c1af\";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:1;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:3:{i:1;s:3:\"VIP\";i:2;s:8:\"OPEN BAR\";i:3;s:8:\"BUSH BAR\";}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:15:\"2500.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:6;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:17:\"16|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:7;s:4:\"name\";s:6:\"GULDER\";s:8:\"quantity\";s:1:\"3\";s:10:\"unit_price\";s:15:\"1800.0000000000\";s:10:\"cost_price\";s:15:\"1000.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:\"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:\"1784506614 6a5d68f6bb766\";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:16;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:3:{i:35;s:3:\"VIP\";i:36;s:8:\"OPEN BAR\";i:37;s:8:\"BUSH BAR\";}s:16:\"quantity_unit_id\";s:2:\"37\";s:22:\"quantity_unit_quantity\";s:12:\"1.0000000000\";s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:15:\"1800.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:7;O:18:\"PHPPOSCartItemSale\":77:{s:4:\"cart\";r:1;s:4:\"type\";s:4:\"sale\";s:4:\"scan\";s:17:\"73|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:8;s:4:\"name\";s:9:\"HOLLANDIA\";s:8:\"quantity\";i:1;s:10:\"unit_price\";s:15:\"3000.0000000000\";s:10:\"cost_price\";s:15:\"1552.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:2:\"13\";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:\"1784506620 6a5d68fc93e78\";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:73;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:3:{i:103;s:8:\"BUSH BAR\";i:104;s:8:\"OPEN BAR\";i:235;s:3:\"VIP\";}s:16:\"quantity_unit_id\";s:3:\"103\";s:22:\"quantity_unit_quantity\";s:12:\"1.0000000000\";s:13:\"item_inactive\";s:1:\"0\";s:18:\"loyalty_multiplier\";i:1;s:13:\"regular_price\";s:15:\"3000.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:0;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:2:\"26\";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: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:8:\"Transfer\";s:8:\"Transfer\";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: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\";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\";}fullscreen|s:1:\"0\";amount_change|d:-0;keep_alive|i:1784534215;'),('fk2tg72stslo7q0cu5vur9hg56nl2c9g','135.129.124.84',1784492373,'person_id|s:2:\"22\";'),('hacs441dcs6d6bgstjdpl15du4oo5cmo','67.211.222.228',1784487333,''),('hnpsedolg51j10r36sq2e9ve1o8pgiku','135.129.124.84',1784491474,'person_id|s:2:\"26\";'),('i373hl25k2gj2kaob2s2qq69ohk5kfhv','135.129.124.84',1784453376,'person_id|s:2:\"22\";'),('m3jvhbvdl0ca143hthuvm33pr1o0thdo','52.167.144.195',1784453501,''),('mrfp9o436m8lhi2d0ljav9sf47p8l8il','40.77.167.41',1784456857,''),('nlgdif0ebujb3csv7vndrr3phi94sj92','135.129.124.84',1784452922,'person_id|s:2:\"26\";'),('q6trnsuq81t876eeif68mop1i389ulcs','52.167.144.221',1784476599,''),('unt64julosli2lvoghm6oft7p32sia2i','135.129.124.84',1784501463,'person_id|s:2:\"26\";'),('uppn9m4afif1q2hf3kggubseupusug0j','135.129.124.84',1784497863,'person_id|s:2:\"26\";');

--
-- 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 AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

INSERT INTO `phppos_suppliers` VALUES (1,7,'E FINE VENTURES',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(2,8,' WATER SUPPLIER',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(3,9,'ASHMANJEE',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(4,10,'BENHILL',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(5,11,'ODO ERAN MARKET',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(6,12,'EMMANUEL ENTERPRISE',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(7,15,'MCKENZO',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL),(8,17,'ASHMANDO',NULL,0,0.0000000000,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL);

--
-- 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,'Sales Tax',0.000,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`
--



