--
-- Host: localhost    Database: company
-- ------------------------------------------------------


--
-- Table structure for table `bank_transfer`
--

CREATE TABLE `bank_transfer` (
  `id_bank_transfer` int NOT NULL AUTO_INCREMENT,
  `id_client_from` int NOT NULL DEFAULT '0',
  `id_client_to` int NOT NULL DEFAULT '0',
  `id_dengi` int NOT NULL DEFAULT '0',
  `amount_bank_transfer` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_bank_transfer` int NOT NULL DEFAULT '0',
  `description_bank_transfer` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `partiya_id` int DEFAULT NULL,
  PRIMARY KEY (`id_bank_transfer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bank_transfer`
--


--
-- Table structure for table `category_client`
--

CREATE TABLE `category_client` (
  `id_category_client` int NOT NULL AUTO_INCREMENT,
  `name_category_client` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_category_client`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_client`
--

INSERT INTO `category_client` VALUES (1,'Ombor'),(2,'Mol yetkazib beruvchi'),(3,'Klient'),(4,'Mijoz va mol yetkazib beruvchi');

--
-- Table structure for table `category_rasxod`
--

CREATE TABLE `category_rasxod` (
  `id_category_rasxod` int NOT NULL AUTO_INCREMENT,
  `name_category_rasxod` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_category_rasxod`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_rasxod`
--

INSERT INTO `category_rasxod` VALUES (80,'Sadulla akaga berilgan'),(79,'Obed'),(78,'Sadaqa'),(77,'Taksi'),(76,'Islombek'),(75,'Dokon Rasxod');

--
-- Table structure for table `category_siryo`
--

CREATE TABLE `category_siryo` (
  `id_category_siryo` int NOT NULL AUTO_INCREMENT,
  `name_category_siryo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_category_siryo`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_siryo`
--

INSERT INTO `category_siryo` VALUES (1,'Lak'),(15,'Islom kartasiga tushgan'),(6,'Rostvoritel'),(9,'Emulsiya'),(11,'Pasta Emulsiya'),(12,'Pasta Tinting');

--
-- Table structure for table `client`
--

CREATE TABLE `client` (
  `id_client` int NOT NULL AUTO_INCREMENT,
  `id_category_client` int NOT NULL DEFAULT '0',
  `name_client` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `description_client` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `is_active` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_client`)
) ENGINE=MyISAM AUTO_INCREMENT=197 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client`
--

INSERT INTO `client` VALUES (1,1,'Ombor','Ombor',1),(2,1,'BAZA','',1),(3,3,'\"E\'tiqod Mebel\"','',0),(4,3,'Klient 1','',0),(18,2,'Nurafshon dokon','Razliv',1),(9,3,'Lutfuloh aka  946690908','',1),(10,3,'Maruf aka 971950330','diller',1),(11,3,'Yusuf aka Itifoq mebel 983069065','',1),(12,3,'Jurat aka D.Studio 917955505','',1),(13,3,'Aziz aka ЮКПП 971300700','',1),(14,3,'Komoliddin aka 909682094','',1),(15,3,'Boriy aka Jomiy 998425255','',1),(16,3,'Zayniddin aka 974487008','',1),(17,2,'Sadulla aka Sergeli','',1),(19,3,'Kashtan 946854242','',1),(20,3,'Kashtan Bekzodaka 940562420','',1),(21,3,'Kashtan Elyoraka 998266640','',1),(22,3,'Kashtan Maxmudaka 881505100','',1),(23,3,'Samarqand Timuraka(diller) 932955000','diller',1),(24,3,'Nukus Ondasinaka 907342661','',1),(25,3,'Qoqon Sarvaraka 979440701','diller',1),(26,3,'Andijon Bohodiraka 902005500','diller',1),(27,3,'Istrohat Betek Ibrohimaka 990552125','diller',1),(28,3,'Shohona Shovkataka 998331212','',1),(29,3,'Novza Saidalixonaka 339408888','',1),(30,3,'Kushmag Abduraxmanaka 913724334','',1),(31,3,'IT PARK 977502770','',1),(32,3,'Davr Jixoz Sardoraka 974764444','',1),(33,3,'Kingland Salmonaka 996328837','',1),(34,3,'Komol aka 974700022','',1),(35,3,'Sabura Shuxrataka 977333460','',1),(36,3,'Sandiq Ubaydulloxaka 931803434','',1),(38,3,'Rasulaka 983080201 ','',1),(39,3,'Avangard Jamshidaka 977502222','',1),(40,3,'Rinataka Zarafshon 977780260','',1),(41,3,'Sattor aka 338880030','',1),(42,3,'Magnat Aziya 999227111','',1),(43,3,'Sunnat doda 993653745','',1),(44,3,'Usmonaka Nazarbek 983646568','',1),(45,3,'Faxridinaka 998032255 983646568','',1),(46,3,'Bohodir aka qoshni 998812244','',1),(47,3,'Isoq aka 915800270','',1),(48,3,'Bekzodaka 999860879','',1),(50,3,'Ma\'muraka Molyar 974027172','',1),(51,3,'Elyor aka 981285056','',1),(52,3,'Otabek aka 974030660','',1),(53,3,'Abdug\'ani aka 981116466 977066466','',1),(54,3,'Ziyodilla aka 999555559','',1),(55,3,'Doniyor 977301013','',1),(56,3,'Shohjahonaka Woodlands 919610001','',1),(57,3,'Dilmurod aka 998842447','',1),(58,3,'Umar aka 993077705','',1),(59,3,'Chig\'atoy Eshik 998300500','',1),(60,3,'Jurat Muhammadaka 974706666','',1),(61,3,'Ixlos mebel Farhodaka 946001771','',1),(62,3,'Orredo mebel Ibrohimaka 935289955','',1),(63,3,'Yangi Yol Otamurodaka 950444405','',1),(64,3,'Ju\'rat aka 994446560','',1),(65,3,'Woodmax Dilshodaka 973452222','',1),(66,3,'Fozil aka 998762241','',1),(67,3,'Kardar mebel 907284116','',1),(68,3,'Comfort Mebel Azizaka 977050001','',1),(69,3,'Mirolim aka Grand Futures 909756666','',1),(70,3,'Farhod aka Ravshan aka o\'rtoq','',1),(71,3,'Abdulloh aka Shedevr ','',1),(72,3,'Akbar aka jomiy 908150088','',1),(73,3,'Abdulloh 998886558','',1),(74,3,'Dilnavoz','',1),(75,3,'Ibrohim aka amma','',1),(76,3,'Ibo aka','',1),(77,3,'Aziz aka','',1),(78,3,'Patox aka','',1),(79,3,'Eshmomin aka Chorsu 983688868','',1),(80,3,'Alisher aka 977040026','',1),(81,3,'Kashtan Komolaka 959400800','',1),(82,3,'Ahmadjon aka Samarqand Darvoza','',1),(83,3,'Pocha','',1),(84,3,'Muslim ','',1),(85,3,'Kashtan Sherzodaka 998738636','',1),(86,3,'Javlon aka ','',1),(87,3,'AHK Sahib bey','',1),(88,3,'Aziz aka Namangan 919273030','',1),(89,3,'Jovo','',1),(90,3,'Xumoyun aka usluga 909546868','',1),(91,3,'Arenda Nurafshon','',1),(92,3,'Jo\'rabek aka 974048855','',1),(93,3,'Atom mabel 999983333','',1),(94,3,'Sunnat aka Original Bola admin 999333545','',1),(95,3,'Shuxrat aka 974141165','',1),(100,3,'Toxa','',1),(97,3,'Muhammad aka Metall lider 950568698','',1),(98,3,'Fayzirahmon aka jomi','',1),(99,3,'Ali','',1),(101,3,'Usmon aka Minor','',1),(102,3,'Akbar aka 933995999','',1),(103,3,'Muxtasar','',1),(104,3,'Melores mebel 998866662','',1),(105,3,'Sadulla akaga berilgan pulla','',1),(106,3,'Klient Polchem','',1),(107,3,'Muhammad aka Mehau mebel 903474979','',1),(108,3,'Sora mebel 903915050','',1),(109,3,'Sanjar aka Ravshan aka o\"rtoq 931036061','',1),(110,3,'Abo Islom ortoq 909883838','',1),(111,3,'Qo\'qon Muzafar aka','',1),(112,3,'Umida aka Navoi','',1),(113,3,'Muhiddin aka 946881001','',1),(114,3,'Johongir aka Bek Topi','',1),(115,3,'Rustam aka molyar','',1),(116,3,'Abdulazim Genc','',1),(117,3,'Baron mebel 938007464','',1),(118,3,'G\'ayrat aka Eshik va Zina 935150580','',1),(119,3,'Sasha Aka 901881482 New Mebel','',1),(120,3,'Radik aka 935630368','',1),(121,3,'Murod aka Devero 911600020','',1),(122,3,'Munisa opa Usluga 947344004','',1),(123,3,'Bonur aka','',1),(126,3,'Elyor aka Jomiy 977466367','',1),(125,3,'Bahrom aka 909202525','',1),(127,3,'Ismoil aka Kabir exclusive 909474741','',1),(128,3,'Olim aka 998482441','',1),(129,3,'Ikrom','',1),(130,3,'Azamat aka 999909119 ','Biz Qarzmiz',1),(131,3,'Islom aka Buxoro','',1),(132,3,'Dilmurod aka Emulsiya 909266666','',1),(133,3,'Davron aka 974244774','',1),(134,3,'Anvar aka Tojikiston','',1),(136,3,'Nusrat aka Jomi 888608888','',1),(137,3,'Habibulloh aka  Expressly doors 998814050','',1),(138,3,'Abduvohid aka 998760666','',1),(139,3,'Doston aka','',1),(140,3,'Feruz og\'a Xorazm','',1),(141,3,'Islom aka Buxoro Talipoch','',1),(142,3,'Jora ','',1),(143,3,'Shoma','',1),(144,3,'Keng Makon Shuhrat aka','',1),(145,3,'Aziz aka Grabus 974021266','',1),(146,3,'Jasur aka ','',1),(150,3,'Status Mebel Husan aka 997020009','',1),(148,3,'Abbos ','',1),(149,3,'Ilhom Shafer','',1),(151,3,'Farruh aka Sidr_doors 974400999','',1),(152,3,'Farux aka ','',1),(153,3,'Zilola','',1),(154,3,'Ideal Door 977550070','',1),(155,3,'Art Kabinet Ravshan aka 996351111','',1),(156,3,'Kashtan Muzafar aka 944396131','',1),(157,3,'Kashtan Akmal aka','',1),(158,3,'Etibor Mebel Dilshod aka 946900007','',1),(159,3,'Burhon aka Bellezzio 998957100','',1),(160,3,'Isola mebel Yodgor Aka 901095511','',1),(161,3,'Huvaydo mebel Farhod aka 935459944','',1),(162,3,'Qahramon aka 990377676','',1),(163,3,'Nodir aka 909494777','',1),(164,3,'Johon bodomzor','',1),(165,3,'Kvadro Mercury Maxmud aka 98365 6080 990022227','',1),(166,3,'Ziynat Mebel 946655544','',1),(167,3,'Jamshid aka Nazarbek 977675151','',1),(168,3,'Fahmiddin aka 933974975','diller',1),(169,3,'Belim mebel Bobur aka 998416707','',1),(170,3,'BYD qarz','',1),(171,3,'Miraziz aka MMM Doors 990109292','',1),(172,3,'Firdavs','',1),(173,3,'Tuyg\'un aka','',1),(175,3,'Hasan aka Sharqdizayn 999886777','',1),(176,3,'Zokir aka 903154462','',1),(177,3,'Yer','',1),(190,3,'Fayoz Smm','',1),(189,3,'Kashtan Sherzod aka Eshik 998696607','2',1),(188,3,'Alimov Mebel Otabek aka 997757779','',1),(184,3,'Kashtan Yo\'ldosh aka 909435552','',1),(180,3,'Ali','',1),(181,3,'Mamur aka 909725775','',1),(183,3,'16pro max ','',1),(182,3,'Davron','',1),(179,3,'Dilshod aka Qozog\'iston +77014614104','',1),(185,3,'Abdulloh ','',1),(178,3,'Davlat Nexia','',1),(187,3,'Xola','',1),(186,3,'Islom aka Gilam bozor 93-811-11-11','',1),(192,3,'Klient','',1),(194,3,'Fozil Islom ortoq','',1),(196,3,'Isoq aka Komola opa','',1),(195,3,'Alladin Mebel Ziyoviddin aka 981154009','',1),(193,3,'Nozim aka Tojikiston 9929282866969','',1);

--
-- Table structure for table `client_siryo`
--

CREATE TABLE `client_siryo` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `id_siryo` int unsigned NOT NULL,
  `id_client` int unsigned NOT NULL,
  `cost_siryo` decimal(20,6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `client_siryo`
--


--
-- Table structure for table `dengi`
--

CREATE TABLE `dengi` (
  `id_dengi` int NOT NULL AUTO_INCREMENT,
  `name_dengi` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_dengi`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dengi`
--

INSERT INTO `dengi` VALUES (1,'$'),(2,'Sum'),(5,'Perechisleniya');

--
-- Table structure for table `difference`
--

CREATE TABLE `difference` (
  `id_difference` int NOT NULL AUTO_INCREMENT,
  `id_sklad` int NOT NULL DEFAULT '0',
  `id_siryo` int NOT NULL DEFAULT '0',
  `amount_difference` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_difference` int NOT NULL DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id_difference`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `difference`
--


--
-- Table structure for table `dollar`
--

CREATE TABLE `dollar` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dollar` decimal(20,2) NOT NULL,
  `time` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=196 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `dollar`
--

INSERT INTO `dollar` VALUES (195,12885.00,1732129200);

--
-- Table structure for table `obmen`
--

CREATE TABLE `obmen` (
  `id_obmen` int NOT NULL AUTO_INCREMENT,
  `from_client` int NOT NULL DEFAULT '0',
  `id_dengi_from` int NOT NULL DEFAULT '0',
  `amount_from_dengi` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `kurs` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `to_client` int NOT NULL DEFAULT '0',
  `id_dengi_to` int NOT NULL DEFAULT '0',
  `amount_to_dengi` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_obmen` int NOT NULL DEFAULT '0',
  `description_obmen` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `partiya_id` int DEFAULT NULL,
  PRIMARY KEY (`id_obmen`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `obmen`
--


--
-- Table structure for table `ostatka_dengi`
--

CREATE TABLE `ostatka_dengi` (
  `id_ostatka_dengi` int NOT NULL AUTO_INCREMENT,
  `id_sklad` int NOT NULL DEFAULT '0',
  `id_client` int NOT NULL DEFAULT '0',
  `id_dengi` int DEFAULT NULL,
  `sum_ostatka_dengi` decimal(20,6) DEFAULT NULL,
  `time_ostatka_dengi` int DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id_ostatka_dengi`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ostatka_dengi`
--


--
-- Table structure for table `ostatka_kassa`
--

CREATE TABLE `ostatka_kassa` (
  `id_ostatka_kassa` int NOT NULL AUTO_INCREMENT,
  `id_client` int NOT NULL DEFAULT '0',
  `id_dengi` int NOT NULL DEFAULT '0',
  `sum_ostatka_kassa` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_ostatka_kassa` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_ostatka_kassa`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ostatka_kassa`
--


--
-- Table structure for table `partiya`
--

CREATE TABLE `partiya` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `number` int NOT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `partiya_type` int DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `partiya`
--


--
-- Table structure for table `pokupka_siryo`
--

CREATE TABLE `pokupka_siryo` (
  `id_pokupka_siryo` int NOT NULL AUTO_INCREMENT,
  `id_siryo` int NOT NULL DEFAULT '0',
  `id_client_from` int NOT NULL DEFAULT '0',
  `id_client_to` int NOT NULL DEFAULT '0',
  `amount_pokupka_siryo` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `cost_pokupka_siryo` decimal(20,2) DEFAULT NULL,
  `time_pokupka_siryo` int NOT NULL DEFAULT '0',
  `is_ostatka` tinyint(1) NOT NULL DEFAULT '0',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`id_pokupka_siryo`)
) ENGINE=MyISAM AUTO_INCREMENT=199 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pokupka_siryo`
--


--
-- Table structure for table `prodaja_siryo`
--

CREATE TABLE `prodaja_siryo` (
  `id_prodaja_siryo` int NOT NULL AUTO_INCREMENT,
  `id_siryo` int NOT NULL DEFAULT '0',
  `id_client_from` int NOT NULL DEFAULT '0',
  `id_client_to` int NOT NULL DEFAULT '0',
  `id_dengi` int NOT NULL DEFAULT '0',
  `cost_prodaja_siryo` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `amount_prodaja_siryo` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_prodaja_siryo` int NOT NULL DEFAULT '0',
  `description_prodaja_siryo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `partiya_id` int DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id_prodaja_siryo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prodaja_siryo`
--


--
-- Table structure for table `rasxod`
--

CREATE TABLE `rasxod` (
  `id_rasxod` int NOT NULL AUTO_INCREMENT,
  `id_client` int NOT NULL DEFAULT '0',
  `id_category_rasxod` int NOT NULL DEFAULT '0',
  `name_rasxod` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `id_dengi` int NOT NULL DEFAULT '0',
  `cost_rasxod` decimal(20,6) NOT NULL,
  `amount_rasxod` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_rasxod` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_rasxod`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rasxod`
--


--
-- Table structure for table `rasxod_siryo`
--

CREATE TABLE `rasxod_siryo` (
  `id_rasxod_siryo` int NOT NULL AUTO_INCREMENT,
  `id_client` int NOT NULL DEFAULT '0',
  `id_siryo` int NOT NULL DEFAULT '0',
  `amount_rasxod_siryo` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_rasxod_siryo` int NOT NULL DEFAULT '0',
  `description_rasxod_siryo` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id_rasxod_siryo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rasxod_siryo`
--


--
-- Table structure for table `role`
--

CREATE TABLE `role` (
  `id_role` int NOT NULL AUTO_INCREMENT,
  `name_role` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_role`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (1,'admin'),(2,'user');

--
-- Table structure for table `siryo`
--

CREATE TABLE `siryo` (
  `id_siryo` int NOT NULL AUTO_INCREMENT,
  `id_category_siryo` int NOT NULL DEFAULT '0',
  `name_siryo` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `id_unit` int DEFAULT NULL,
  `cost_siryo` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `isActive` int NOT NULL DEFAULT '1',
  `weight` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`id_siryo`)
) ENGINE=MyISAM AUTO_INCREMENT=785 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `siryo`
--

INSERT INTO `siryo` VALUES (4,1,'HP900.6,25kg (381)',32,0.000000,0,NULL),(3,1,'VP500.40.25kg (672)',32,142.000000,1,26.64),(2,1,'HP777.12,5kg (397)',32,0.000000,1,13.45),(1,1,'VP380.77.25kg (650)',32,143.000000,1,26.64),(5,1,'VA510.00.12kg (438)',32,152.000000,1,13.30),(6,1,'HA190.6kg (439)',32,0.000000,1,NULL),(7,1,'VA500.40.15kg (392)',32,134.000000,1,16.37),(8,1,'HA190.1,5kg (393)',32,0.000000,1,1.76),(9,1,'VN101.8150.12kg (389)',32,62.000000,1,13.30),(10,1,'BP333.77.3033.18kg (387)',32,82.000000,1,19.30),(11,1,'HP900.6kg (385)',32,0.000000,1,6.59),(12,1,'ZD420.1093 1lt (417)',31,12.000000,1,0.97),(13,1,'BN100.40.1000.12kg (399)',32,60.000000,1,13.34),(16,1,'BP333.77.1000.18kg (659)',32,79.000000,1,19.30),(18,1,'BN100.00.2001.12kg (416)',32,74.000000,1,13.34),(20,1,'BN100.77.1000.13kg (651)',32,47.000000,1,14.15),(21,1,'BN301.77.8144.13kg (667)',32,48.000000,1,14.15),(23,1,'BP333.77.8144.18kg (386)',32,82.000000,1,19.30),(24,1,'BP580.50.1000.12kg (400)',32,125.000000,1,13.30),(26,1,'HP196.00.6kg Baryer Otver (469)',32,0.000000,1,6.59),(27,1,'HP600.12.5kg (558)',32,0.000000,1,13.19),(28,1,'HP777.6kg (414)',32,0.000000,1,6.51),(29,1,'HP900.3kg (407)',32,0.000000,1,3.45),(30,1,'HP580.6kg (635)',32,0.000000,1,NULL),(31,1,'HP900.12,5kg',32,0.000000,0,NULL),(32,1,'TN150.180kg (419)',39,365.000000,1,195.00),(33,1,'TP100.12kg (412)',32,48.000000,1,13.00),(34,1,'TP100.180kg (418)',39,660.000000,1,195.00),(37,1,'VA104.77.15kg (654)',32,122.000000,1,16.37),(38,1,'Vl195.77.12kg Baryer (693)',32,203.000000,1,13.30),(39,1,'VN100.00.12kg (477)',32,48.000000,1,13.15),(40,1,'VN100.15.12kg (476)',32,48.000000,1,13.15),(41,1,'VN100.40.12kg (391)',32,48.000000,1,13.15),(42,1,'VN100.77.12kg (666)',32,49.000000,1,13.63),(43,1,'VN100.77.25kg (660)',32,90.000000,1,25.14),(44,1,'VN101.00.3111.12kg (390)',32,60.000000,1,13.30),(45,1,'VN100.77.3kg (661)',32,15.000000,1,3.43),(46,1,'VP500.00.25kg (671)',32,194.000000,1,26.89),(47,1,'VP500.20.12kg (676)',32,77.000000,1,13.30),(48,1,'VP500.20.25kg (669)',32,142.000000,1,26.89),(49,1,'VP500.40.12kg (676)',32,77.000000,1,13.30),(50,1,'VP509.40.25kg (398)',32,175.000000,1,27.00),(52,1,'ZD420.1029 1litr (421)',31,12.000000,1,0.97),(53,1,'ZD820.1007 1 LT TUTUN (424)',32,16.000000,1,1.10),(54,1,'ZD820.1013 1 LT BEYAZ (502)',32,28.500000,1,1.90),(55,1,'ZD820.1014 1 LT OKYANUS MAVI (446)',32,16.000000,1,1.10),(56,1,'ZD820.1025 1 LT KIRMIZI (435)',32,16.000000,1,1.12),(57,1,'ZD820.1033 1 LT MESE (404)',32,16.000000,1,1.10),(58,1,'ZD820.1043 1 LT KOYU FINDIK (503)',32,16.000000,1,1.11),(59,1,'ZD820.1051 1 LT KOYU MESE (402)',32,16.000000,1,1.11),(60,1,'ZD820.1052 1litr MAUN (425)',32,16.000000,1,1.12),(61,1,'ZD820.1054 1LT SARI  (426)',32,28.500000,1,1.10),(62,1,'ZD820.1056 PARLEMENT MAVI 1 LT (447)',32,28.500000,1,1.10),(63,1,'ZD820.1058 1 LT YESIL (448)',32,28.500000,1,1.10),(64,1,'ZD820.1069 1 LT TURUNCU (528)',32,16.000000,1,1.12),(65,1,'ZD820.1072 1 LT SIYAH (445)',32,16.000000,1,1.15),(66,1,'ZD820.1090 1 LT KOYU MAUN (927)',32,16.000000,1,1.10),(67,1,'ZD820.1093 1 LT FINDIK (444)',32,16.000000,1,1.10),(68,1,'ZD820.1096 1 LT VENGE (423)',32,16.000000,1,1.12),(69,1,'ZD820.1092 1 LT CEVIZ (401)',32,16.000000,1,1.10),(70,1,'ZD900.1092 1litr (568)',32,14.500000,1,NULL),(71,1,'ZD420.1072 1litr (422)',32,12.000000,1,0.97),(75,1,'T43003 Dub Shpatlevka (420)',32,2.500000,1,1.08),(76,1,'T43002 Orex Shpatlevka (456)',32,2.500000,1,1.08),(77,1,'T43000 Oq Shpatlevka (457)',32,2.500000,1,1.08),(78,1,'BO100.00 0.83lt Smivka (437)',32,7.000000,1,1.19),(80,1,'VP500.00.12KG (679)',32,100.000000,1,13.30),(81,1,'HP900.12KG',32,0.000000,0,NULL),(82,1,'BP580.25.1000.12kg (581)',32,125.000000,1,13.30),(83,1,'ZD820.1084. 1 LT ANTIK CEVIZ (403)',32,16.000000,1,1.12),(84,1,'ZD820.1087. 1 LT KOYU CEVIZ (405)',32,16.000000,1,1.10),(85,1,'ZD820.1088. 1 LT KAHVERENGI MAUN (434)',32,19.000000,1,1.12),(86,1,'VP380.77.3kg (677)',32,22.000000,1,3.43),(87,1,'HP777.1,5 kg (428)',32,0.000000,1,1.76),(88,1,'VP500.40.3kg (449)',32,21.000000,1,3.43),(89,1,'HP900.0,75kg (450)',32,0.000000,1,NULL),(92,1,'VP380.77.12kg (657)',32,79.000000,1,13.30),(96,1,'VA500.25.15kg (472)',32,134.000000,1,16.37),(97,1,'TN150.1шт',30,16.570000,1,7.50),(98,1,'BE400.76 3/1 Polyester Shpaklyovka (480)',40,10.000000,1,3.00),(103,1,'CP558.25.1000 12kg (100/50 HP120 6kg)',32,91.000000,1,NULL),(330,1,'BP444.77.1000.12kg Baryer (780)',40,81.000000,1,13.30),(329,1,'BN100.00.2185.12kg Krom Sari',40,62.000000,1,13.00),(114,1,'CN500.15.0000 9.6kg Sel (904)',32,65.000000,1,NULL),(117,1,'Kumush Kraska 1kg',30,12.000000,0,NULL),(120,1,'HP551.13kg (410)',32,0.000000,1,NULL),(121,1,'BP580.50.1000 3KG',32,10.000000,0,NULL),(123,1,'TN150.12kg (878)',32,37.000000,1,13.00),(124,1,'BP571.15.1001.12kg (550)',40,72.000000,0,NULL),(125,1,'VS102.00 2.5 lt Yaxt',40,13.000000,1,3.00),(740,1,'Buk Shpon',36,0.000000,1,NULL),(741,9,'Dub Shpon',36,0.000000,1,NULL),(130,1,'VP551.00.24kg (409)',32,398.000000,1,26.39),(743,1,'VA450.00 12kg',32,140.000000,1,13.30),(742,1,'Cobler ANTIK 15kg DK110PA',32,125.000000,1,16.30),(739,1,'HP900 12.5kg',32,0.000000,1,13.10),(737,1,'BP100.77.1000 18kg',32,80.000000,1,19.30),(738,1,'BP333.77.1000 36kg',32,152.000000,1,37.85),(136,1,'BE400.76 1/1 Polyester Shpaklyovka',40,4.000000,0,NULL),(140,1,'BP571.50.1001. 12kg (406)',32,74.000000,1,13.30),(142,2,'HP 159.00 (5kg)',32,0.000000,0,NULL),(145,1,'Gench Tinting Kraska 1kg',30,0.000000,1,NULL),(147,1,'TA550.00 12kg (533)',40,55.000000,1,13.00),(149,1,'BN100.77.9103.13kg (691)',40,53.000000,1,14.15),(151,1,'CP558.25.0000 2.25kg',40,1.000000,1,NULL),(154,1,'HA190.0,3kg (479)',40,0.000000,1,NULL),(736,1,'P400 Abrasoft 25mt',40,19.000000,1,1.50),(159,1,'HP600.1.5Lt Cizilmes',40,0.000000,1,1.76),(160,1,'BE401.77.1000.10kg (903)',40,70.000000,1,NULL),(161,1,'VP500.10.12kg (411)',40,67.000000,0,13.30),(168,1,'Tilla Patina 1kg (750) Jexdi',30,12.000000,1,NULL),(331,1,'HP444.3kg Baryer Sert (407)',40,0.000000,1,3.45),(170,1,'HP600.6kg (783)',40,0.000000,1,6.59),(171,1,'HP580.1.5kg (471)',40,14.000000,1,1.76),(175,1,'Tilla Patina 1kg (5437) Zafar',30,12.000000,1,NULL),(176,1,'Tilla Kraska 1kg (0050) Zafar',40,14.000000,1,NULL),(177,1,'Kumush Kraska 1kg (5461) Zafar',30,14.000000,0,NULL),(181,1,'VP500.10.25kg (672)',40,129.000000,1,27.39),(184,1,'BN100.00.1000.12kg (374)',40,58.000000,1,13.34),(186,1,'VA500.40.3kg (478)',40,34.000000,1,3.43),(187,1,'BP333.77.1000.4,5kg (670) ',40,25.000000,1,4.93),(188,1,'HP900.1,5kg (471)',40,0.000000,1,NULL),(189,1,'VA510.00.3kg (473)',40,43.000000,1,3.43),(207,1,'VP500.00.3kg (702)',32,30.000000,1,3.43),(208,1,'BN100.10.1000.12kg (522)',32,60.000000,1,13.34),(213,1,'VN101.8150.3kg (662)',40,20.000000,1,3.43),(214,1,'HP904.12,5kg (383)',40,0.000000,1,13.06),(215,1,'HP904.3kg (407)',40,0.000000,1,3.45),(784,1,'Hp575 1.5kg',32,0.000000,1,1.76),(270,1,'BS600.8195.2.5kg',40,11.800000,0,NULL),(271,1,'BS600.2680.0.75kg',40,4.000000,1,NULL),(272,1,'BS600.4176.0.75kg',40,4.000000,1,NULL),(273,1,'HP904.12kg (475)',40,0.000000,1,NULL),(274,1,'VP509.40.3kg',40,24.000000,0,NULL),(275,1,'BP571.25.1000.12kg (406)',32,72.000000,0,NULL),(328,1,'HX100.00.6kg Epokso Sert (611)',40,0.000000,1,NULL),(782,1,'BN100.00.8506 2.5Lt ',32,14.500000,1,2.81),(783,1,'Bp575.77.1000 3kg Pu Ortucu A Beyaz',32,25.000000,1,3.43),(327,1,'VX100.00.18kg Epoksi',40,255.000000,0,NULL),(781,1,'HE400. 0225kg polyester Hizlandirici',32,0.000000,1,NULL),(780,1,'VH400. 0225kg polyester Hizlandirici',32,0.000000,1,NULL),(779,1,'VE401.77 10kg Polyester Dolgu',32,80.000000,1,11.30),(778,1,'P120 Abrasoft 25m',32,16.000000,1,NULL),(777,1,'P800 abrasoft 25m',32,16.000000,1,1.50),(776,1,'P600 Abrasoft 25m shkurka',32,17.000000,1,1.50),(775,1,'BN350.77.1110 13kg',32,38.000000,1,14.30),(774,1,'HP521.00 1.5kg ',32,0.000000,1,1.76),(773,1,'BP521.77.1000 4.5kg PU.Astar',32,26.000000,1,4.93),(772,1,'Cobler Rose Gold 15kg',32,107.000000,1,16.30),(771,1,'HP521.00 12kg ',32,0.000000,1,13.10),(770,1,'BP521.77.1000 36kg PU.Astar',32,148.000000,1,37.85),(769,1,'HA450.00 6kg',32,0.000000,1,6.55),(768,1,'BA450.00.1000 12kg',32,160.000000,1,13.30),(767,1,'BP580.10.1000 3kg',32,37.000000,1,3.30),(766,1,'BP580.50.9103 12kg I.MATT-SIYAH',32,105.000000,1,13.30),(765,1,'VN125.77.25LT SEL DOLGU',32,89.000000,1,25.14),(727,1,'VS102.40 12kg',40,56.000000,1,13.00),(735,1,'P320 Abrasoft 25mt',40,19.000000,1,1.50),(316,1,'BN100.00.3205.12kg',40,61.000000,1,13.00),(317,1,'BN100.00.9123.12kg (593)',40,59.000000,1,13.34),(318,1,'BN100.00.2183.12kg',40,62.000000,1,13.00),(319,1,'VA104.77.3kg (870)',40,31.000000,1,3.43),(320,1,'BP133.77.1000.18kg (659)',40,1.000000,0,NULL),(733,1,'P220 Abrasoft 25mt',40,19.000000,1,1.50),(734,1,'P240 Abrasoft 25mt',40,19.000000,1,1.50),(732,1,'P180 Abrasoft 25mt',40,19.000000,1,1.50),(340,1,'P-180.1mt Shkurka',34,1.000000,1,NULL),(341,1,'P-320.1mt Shkurka',34,1.000000,1,NULL),(342,1,'P-400.1mt Shkurka',34,1.000000,1,NULL),(343,1,'P-280.1mt Shkurka',34,0.920000,1,NULL),(344,1,'P-220.1mt Shkurka',34,1.000000,1,NULL),(345,1,'BS600.4176.2.5Lt (763)',40,11.800000,0,2.47),(720,1,'Cobler Kraska 1kg',30,9.000000,1,1.00),(722,1,'BN100.00.9123 2.5LT',32,13.500000,1,3.00),(731,1,'P150 Abrasoft 25mt',40,19.000000,1,1.50),(730,1,'Orex Shpon',36,0.000000,1,NULL),(351,1,'BN160.15.1000.12KG SEL. MAT BEYAZ BOYA (374)',40,57.000000,1,13.30),(352,1,'BN100.00.3205.3kg ',40,13.500000,1,3.00),(353,1,'BN100.00.2185.3kg',40,13.500000,1,3.00),(354,1,'BN100.00.8505.3kg',32,15.000000,1,NULL),(355,1,'BN100.00.8506.12kg (769)',40,60.000000,1,13.34),(356,1,'BN100.00.8505.12kg (768)',40,60.000000,1,13.34),(357,1,'P-180.25mt Karobka Shkurka (791)',40,17.000000,1,1.72),(358,1,'P-220.25mt Karobka Shkurka (704)',40,17.000000,1,1.72),(359,1,'P-320.25mt Karobka Shkurka (766)',40,17.000000,1,1.72),(360,1,'BN100.77.9103.3kg (678)',40,14.000000,1,NULL),(729,1,'Yasin Shpon',36,0.000000,1,NULL),(362,1,'BE400.76 1.8/1 Polyester Shpaklyovka (682)',40,7.000000,1,NULL),(363,1,'BN100.00.1140.12kg Krem.Sel.Boya (684)',40,65.000000,1,13.34),(364,1,'HP444.6kg Baryer Sert (475)',40,0.000000,0,6.59),(365,1,'3kg Pasuda',40,0.800000,1,NULL),(366,1,'BL193.77.1000.12+3kg MDF BARIYERI (975)',40,76.000000,1,13.30),(367,1,'HP193.3kg (BL193.77.1000.12kg) (468)',40,0.000000,1,3.45),(369,1,'TN200.180kg (799)',40,515.000000,1,195.00),(726,1,'VS102.20 2.5LT',32,13.000000,1,3.00),(725,1,'VS100.40 12kg',40,58.000000,1,13.00),(724,1,'VS100.40 2.5LT',32,13.000000,1,3.00),(719,1,'TP100 1kg',30,4.500000,1,1.00),(375,1,'BN100.00.1810.12kg Metalik Altin (697)',40,95.000000,1,13.34),(376,1,'BN100.00.7069.12kg Metalik Gumush (698)',40,88.000000,1,13.34),(377,1,'BN100.00.3310.12kg Metalik Bronz',40,88.000000,1,13.34),(378,1,'P-400.25mt Karobka Shkurka (703)',40,17.000000,1,1.72),(379,1,'BN100.77.1000.3kg (701)',40,14.000000,1,3.33),(380,1,'BL193.77.20+6kg MDF BARIYERI (706)',40,120.000000,1,25.50),(381,1,'HP193.6kg (385)',40,0.000000,1,6.59),(382,1,'VP510.20.10Lt Cizilmes (781)',40,74.000000,1,11.40),(383,1,'HP600.5Lt Cizilmes (686)',40,0.000000,1,NULL),(717,1,'BN100.40.1000 12kg Ral1013',40,67.000000,1,NULL),(718,1,'TA550 1kg',30,5.000000,1,1.00),(387,1,'TN200.1kg',30,2.130000,1,NULL),(388,9,'Premium Silicon Matt Beyaz 15Lt 1001 ',40,45.500000,1,23.60),(389,9,'Premium Silicon Matt Beyaz 7.5Lt 1001 ',40,24.500000,1,11.42),(390,9,'Premium Silicon Matt Beyaz 2.5Lt 1001 ',40,9.000000,1,3.81),(391,9,'Premium Silicon Matt D1 15Lt 1002 ',40,42.500000,1,24.35),(392,9,'Premium Silicon Matt D1 7.5Lt 1002 ',40,23.000000,1,12.30),(393,9,'Premium Silicon Matt D1 2.5Lt 1002 ',40,9.000000,1,4.12),(394,9,'Premium Silicon Matt D2 15Lt 1003',40,40.500000,1,23.71),(395,9,'Premium Silicon Matt D2 7.5Lt 1003',40,22.000000,1,11.97),(396,9,'Premium Silicon Matt D2 2.5Lt 1003',40,8.500000,1,4.01),(397,9,'Premium Silicon Matt D3 15Lt 1004',40,39.000000,1,23.49),(398,9,'Premium Silicon Matt D3 7.5Lt 1004',40,21.000000,1,11.86),(399,9,'Premium Silicon Matt D3 2.5Lt 1004',40,8.500000,1,3.98),(400,9,'Premium Silicon Matt D4 15Lt 1005',40,31.500000,1,22.46),(401,9,'Premium Silicon Matt D4 7.5Lt 1005',40,17.500000,1,11.35),(402,9,'Premium Silicon Matt D4 2.5Lt 1005',40,7.000000,1,3.81),(403,9,'Premium Cover Primer 15LT 1001',40,26.000000,1,22.95),(404,9,'Premium Cover Primer 2.5Lt 1001',40,5.500000,1,3.88),(405,9,'Standard Ecosil Matt Beyaz 12Lt 1001 ',40,35.000000,1,21.56),(406,9,'Standard Ecosil Matt Beyaz 6Lt 1001 ',40,19.000000,1,10.92),(407,9,'Standard Ecosil Matt Beyaz 2.2Lt 1001 ',40,8.000000,1,4.03),(408,9,'Premium Silicon Matt A1 15Lt 1001',40,44.000000,1,24.34),(409,9,'Premium Silicon Matt A1 7.5Lt 1001',40,23.500000,1,12.29),(410,9,'Premium Silicon Matt A1 2.5Lt 1001',40,9.000000,1,4.12),(411,9,'Standard Plastic Matt A1 12Lt 1001',40,31.500000,1,20.97),(412,9,'Standard Plastic Matt A1 6Lt 1001',40,17.000000,1,10.63),(413,9,'Standard Plastic Matt A1 2.2Lt 1001',40,6.500000,1,3.91),(414,9,'Standard Plastic Matt D1 12Lt 1002',40,30.500000,1,20.97),(415,9,'Standard Plastic Matt D1 6Lt 1002',40,16.500000,1,10.63),(416,9,'Standard Plastic Matt D1 2.2Lt 1002',40,6.500000,1,3.91),(417,9,'Standard Plastic Matt D2 12Lt 1003',40,29.000000,1,20.97),(418,9,'Standard Plastic Matt D2 6Lt 1003',40,15.500000,1,10.63),(419,9,'Standard Plastic Matt D2 2.2Lt 1003',40,6.000000,1,3.91),(420,9,'Standard Plastic Matt D3 12Lt 1004',40,28.000000,1,20.97),(421,9,'Standard Plastic Matt D3 6Lt 1004',40,15.000000,1,10.63),(422,9,'Standard Plastic Matt D3 2.2Lt 1004',40,6.000000,1,3.91),(423,9,'Fassade Silicon Sun A1 15Lt 1001',40,47.000000,1,24.66),(424,9,'Fassade Silicon Sun A1 7.5Lt 1001',40,25.000000,1,12.41),(425,9,'Fassade Silicon Sun A1 2.5Lt 1001',40,9.500000,1,4.16),(426,1,'VS102.40 2.5Lt Yat Vernik',40,13.000000,1,3.00),(427,1,'VS100.00 2.5Lt Parke Vernik',40,12.000000,1,NULL),(428,1,'VS100.20 2.5Lt Parke Vernik',40,13.000000,1,3.00),(764,9,'MR Shkurka(ko\'k) 25m',32,0.000000,1,NULL),(430,1,'BN100.40.1000 2.5Lt (760)',40,15.000000,1,3.18),(431,1,'BN100.00.2001 2.5Lt (774)',40,16.000000,1,2.83),(716,1,'BN100.10.1000 12kg Ral1013',40,67.000000,1,NULL),(433,1,'BS600.00.4176.2.5lt Sent.Renkl.Venge',40,12.500000,1,2.48),(715,1,'BN100.00.1000 12kg Ral1013',40,67.000000,1,13.00),(728,1,'BN100.10.9103 2.5LT',32,14.500000,1,3.02),(436,1,'P-150.25mt Karobka Shkurka (767)',40,17.000000,1,1.72),(437,1,'P-150 1mt Shkurka',40,1.000000,1,NULL),(438,1,'BP575.77.1000 12kg',40,96.000000,1,13.30),(439,1,'HP575 6kg (385)',40,0.000000,1,6.59),(714,1,'BN100.10.1000 12kg Ral9010',40,66.000000,1,NULL),(441,1,'BL193.77.2+0.25 kg MDF BARIYERI (775)',40,15.000000,1,2.33),(442,1,'HP193.0.5kg (776)',40,0.000000,1,0.50),(443,1,'BL193.77.12+3 kg MDF BARIYERI (777)',40,68.000000,1,13.30),(444,1,'HP193.00. 3kg (407)',40,0.000000,1,3.45),(711,1,'PADBOR KRASKA',30,1.000000,1,1.10),(710,1,'VS102.20 12kg',40,56.000000,1,13.00),(709,1,'BN100.00.2001 1kg',30,7.000000,1,1.20),(453,1,'VP510.40 10kg Cizilmes (781)',40,74.000000,1,11.40),(454,1,'BP475.77.1000 15kg Esnek Astar (882)',40,118.000000,1,16.26),(455,1,'HP475 6kg ',40,0.000000,1,NULL),(456,1,'F00081 Altin Boya 1kg (1011)',40,11.000000,1,1.00),(457,1,'CP585.50.0000 10.2kg (785)',40,1.000000,1,NULL),(458,1,'CP585.50.1000 12kg (505)',40,1.000000,1,NULL),(459,1,'VP510.10 3kg Cizilmes (789)',32,24.000000,1,NULL),(461,1,'VP510.40 3kg Cizilmes (790)',32,26.000000,1,3.49),(745,1,'BP521.77.1000 18kg PU.Astar',32,0.000000,1,19.30),(463,1,'VS100.00 12kg Parke Vernik',32,54.000000,1,NULL),(464,1,'VS102.00 12kg Yat Vernik',40,54.000000,1,13.00),(746,1,'HP521.00 6kg',32,0.000000,1,6.59),(468,11,'10.DIYE - Sari 1lt',40,25.000000,1,NULL),(469,11,'1.Sari.2 EYL 1lt',40,95.000000,1,NULL),(470,11,'2.DGRN - Yesil 1lt',40,36.000000,1,NULL),(471,11,'8.IOR - Orange 1lt',40,58.000000,1,NULL),(472,11,'5.DOXY - Oksit Sari 1lt',40,21.000000,1,NULL),(473,11,'6.ERE1 - Kirmizi 1lt',40,69.000000,1,NULL),(474,11,'7.EBL - Mavi 1lt',40,46.000000,1,NULL),(475,11,'12.DP550.00.0210 EBK1 - Siyah 1lt',40,25.000000,1,NULL),(476,11,'13.EVI1 - Viyole 1lt',40,109.000000,1,NULL),(477,11,'4.EXR1 - Oksit Kirmizi 1lt',40,21.000000,1,NULL),(478,11,'3.EWH1 - Beyaz 1lt',40,35.000000,1,NULL),(479,11,'9.ERE3 - Kirmizi 1lt',40,67.000000,1,NULL),(480,11,'11.EOR - Turuncu 1lt',40,64.000000,1,NULL),(481,9,'FASSADE SILICONE SUN C BAZI 15 LT',40,41.000000,1,24.18),(482,9,'FASSADE SILICONE SUN D1 BAZI  15 LT',40,52.000000,1,24.66),(483,9,'FASSADE SILICONE SUN D2 BAZI 15 LT',40,50.000000,1,24.66),(484,9,'FASSADE SILICONE SUN D3 BAZI 15 LT',40,48.000000,1,24.66),(485,9,'FASSADE SILICONE SUN D4 BAZI 15 LT',40,41.500000,1,24.66),(486,9,'Standard Plastic Mat Beyaz 12Lt 1001',40,33.000000,1,21.56),(487,9,'Standard Plastic Mat Beyaz 6Lt 1001',40,18.000000,1,10.92),(488,9,'Standard Plastic Mat Beyaz 2.2Lt 1001',40,7.500000,1,4.03),(525,9,'Premium Silicon Silk Matt Beyaz 7.5Lt 1001',40,36.000000,1,10.82),(490,9,'Standard Latex Matt Beyaz 20kg 1001',40,25.000000,1,20.66),(491,9,'Standard Latex Matt Beyaz 7.5Lt 1001',40,17.500000,1,13.92),(492,9,'Standard Latex Matt Beyaz 2.5Lt 1001',40,7.000000,1,4.51),(493,9,'Silicone Rock Impregnation 5Lt',40,18.500000,1,5.27),(494,9,'Premium Interior Putty ic 25kg',40,25.000000,1,25.96),(495,9,'Premium Interior Putty ic 5kg',40,7.000000,1,NULL),(496,9,'Fassade Exterior Putty Dis 25kg',40,25.000000,1,26.07),(497,9,'Fassade Exterior Putty 4kg',40,6.000000,1,NULL),(499,9,'Premium Silicon Satin Beyaz 7.5Lt 1001',40,35.000000,1,10.75),(523,1,'VX100.00. 21kg Epoksi (874)',40,370.000000,1,22.90),(501,9,'Premium Transparent Primer 20Lt',40,20.000000,1,21.10),(502,9,'Premium Transparent Primer 5Lt',40,5.500000,1,5.27),(503,9,'Premium Silicon Satin Beyaz 2.5Lt 1001',40,13.000000,1,3.61),(504,9,'Fassade Silicon Sun Beyaz 15Lt 1001',40,52.000000,1,24.66),(505,9,'Fassade Silicon Sun Beyaz 7.5Lt 1001',40,28.000000,1,12.41),(506,9,'Fassade Eco Sun Beyaz 7.5Lt 1001',40,25.000000,1,12.92),(507,9,'Fassade Silicon Cover Primer Beyaz 15Lt ',40,32.000000,1,22.83),(508,9,'Fassade Silicon Cover Primer Beyaz 2.5Lt ',40,6.000000,1,3.86),(509,9,'Fassade Concrete Primer Kirmizi 12kg',40,22.500000,1,NULL),(510,9,'Fassade Eco Sun Beyaz 20kg 1001',40,37.000000,1,20.66),(511,9,'Fassade Eco Sun Beyaz 2.5Lt 1001',40,9.000000,1,4.33),(512,9,'Fassade Silicon Sun Beyaz 2.5Lt 1001',40,10.500000,1,4.16),(513,9,'Hydro Isolation Beyaz 20kg 1001',40,60.000000,1,20.78),(514,9,'Hydro Isolation Beyaz 3kg 1001',40,10.500000,1,3.17),(516,9,'Premium Silicon Satin Beyaz 15Lt 1001',40,66.500000,1,21.35),(531,1,'ZD421.3400 1lt Kizil Altin (881)',40,18.000000,1,1.00),(530,1,'ZD421.2400 1lt Altin (880)',40,15.000000,1,1.00),(524,9,'Premium Silicon Silk Matt Beyaz 15Lt 1001',40,68.500000,1,21.41),(521,9,'Standard Acrylic Ceiling Beyaz 17.5kg 1001',40,20.000000,1,18.16),(522,9,'Standard Acrylic Ceiling Beyaz 3.5kg 1001',40,5.000000,1,3.68),(526,9,'Premium Silicon Silk Matt Beyaz 2.5Lt 1001',40,13.000000,1,3.62),(527,9,'Premium Concentrated Primer 1:7 15Lt',40,38.000000,1,15.75),(528,9,'Premium Concentrated Primer 1:7 2.5Lt',40,7.500000,1,2.86),(532,1,'F00081 Gumush Boya 1kg',32,11.000000,1,1.00),(760,1,'Cobler Sprey',32,6.000000,1,NULL),(534,1,'VP510.10.10kg Cizilmes (443)',40,74.000000,1,11.20),(535,1,'CP585.25.0000 10.2kg (1013)',40,63.000000,1,NULL),(536,1,'F00081 Altin Boya 2.5kg',40,30.000000,1,NULL),(537,1,'F00081 Champangne Boya 1kg (456)',40,11.000000,1,1.00),(538,1,'VP380.77.200kg',40,1.000000,0,NULL),(539,1,'VU142.77 20kg (953)',40,155.000000,1,21.67),(761,1,'2x2 Shkurka',40,0.500000,1,NULL),(708,1,'CN500.15 1kg',30,7.500000,1,1.00),(542,1,'P-240.25mt Karobka Shkurka (931)',40,17.000000,1,1.72),(713,1,'BN100.40.1000 12kg RAL9010',40,66.000000,1,NULL),(544,1,'TO190.00 RAPID Tiner 1kg',32,3.000000,1,1.00),(545,1,'VU141.77 20kg (507)',32,155.000000,1,21.67),(546,1,'P-240.1mt Shkurka',34,1.000000,1,NULL),(547,12,'PP600.0001',32,104.000000,1,NULL),(548,12,'PP600.0002',32,259.000000,1,NULL),(549,12,'PP600.0003',32,121.000000,1,NULL),(550,12,'PP600.0004',32,137.000000,1,NULL),(551,12,'PP600.0005',32,133.000000,1,NULL),(552,12,'PP600.0006',32,127.000000,1,NULL),(553,12,'PP600.0007',32,92.000000,1,NULL),(554,12,'PP600.0008',32,82.000000,1,NULL),(555,12,'PP600.0009',32,61.000000,1,NULL),(556,12,'PP600.0010',32,206.000000,1,NULL),(557,12,'PP600.0011',32,292.000000,1,NULL),(558,12,'PP600.0012',32,87.000000,1,NULL),(559,12,'PP600.0013',32,184.000000,1,NULL),(560,12,'PP600.0014',32,278.000000,1,NULL),(561,12,'PP600.0015',32,278.000000,1,NULL),(562,12,'PP600.0016',32,135.000000,1,NULL),(763,1,'MR Shkurka(Yashil) 25m',32,0.000000,1,NULL),(762,1,'4x4 Shkurka',32,0.500000,1,NULL),(566,1,'BP580.00.1000.12kg (998)',40,130.000000,1,13.30),(567,1,'BS600.00.8125. 2.5LT KIZIL CEVIZ (965)',40,12.500000,1,2.48),(568,1,'BS600.00.8109. 2.5LT CEVIZ (966)',40,12.500000,1,2.48),(569,1,'BS600.00.8151. 2.5LT KOYU CEVIZ (967)',40,12.500000,1,2.48),(570,1,'BS600.00.8195. 2.5LT FINDIK (968)',40,12.500000,1,2.48),(572,1,'BS600.00.8107. 2.5LT ACIK MESE (969)',40,12.500000,1,2.48),(723,1,'VS100.20 12kg',40,58.000000,1,13.00),(575,1,'HA197.00 0.3kg (479)',40,0.000000,1,0.30),(576,1,'BN350.77.1110.18KG SEL. ASTAR - OZEL BEYAZ (975)',40,54.000000,1,19.26),(744,1,'HA450.00 6kg',32,0.000000,0,6.00),(578,1,'VA300.25.15kg AKRILIK MAT VERNIK (654)',40,120.000000,1,16.37),(579,1,'VA300.40.15kg AKRILIK I.MAT VERNIK (392)',40,120.000000,1,16.37),(580,1,'HA300.1.5KG AKRILIK SERTLESTIRICI  ',40,0.000000,1,1.76),(581,1,'VA107.77.15KG AKRILIK DOLGU (870)',40,114.000000,1,16.37),(582,1,'HA197.1.5kg AKRILIK SERT (393)',40,0.000000,1,1.76),(583,1,'VA500.25.3kg AKRILIK MAT VERNIK (478)',32,34.000000,1,3.43),(747,1,'Cobler Seedef ',32,0.000000,1,16.30),(585,1,'VP500.20.3kg (793)',40,21.000000,1,3.43),(586,1,'Vl195.77.3kg Baryer (999)',32,58.000000,1,3.43),(587,1,'HP196.00.1.5kg Baryer Otver (993)',32,0.000000,1,1.76),(588,1,'VP510.20.3Lt Cizilmes (793)',40,26.000000,1,3.49),(707,1,'BP580.50.25 1kg',30,8.000000,1,1.10),(706,1,'Genc KG Kraska 1kg',30,6.500000,1,1.20),(705,1,'GB460.30kg ',40,56.000000,1,31.10),(592,1,'BN100.00.1810.3kg Metalik Altin',40,22.000000,1,2.83),(748,1,'BP580.10.1000 12kg',32,120.000000,1,13.30),(749,1,'TP100 7.5kg 1шт',32,21.840000,1,NULL),(750,1,'BA105.77.1000 15kg Akrilik Astar',32,123.000000,1,16.37),(751,1,'BP750.1136 3kg Bulut Efekt',32,52.000000,1,3.00),(721,1,'BN100.10.1000 2.5LT',40,15.000000,1,3.00),(752,1,'HP751 3kg Sert Bulut Efekt',32,0.000000,1,3.00),(753,1,'VA500.10 3kg',32,33.000000,1,3.20),(754,1,'BP100.77.9103 18kg Astar Siyah',32,85.000000,1,19.30),(755,1,'VP950.10 12kg Darbe',32,125.000000,1,13.00),(756,1,'VP950.40 12kg Darbe',32,125.000000,1,13.00),(757,1,'HP950 12kg',32,0.000000,1,13.00),(758,9,'L150 MR 1sht',32,0.500000,1,NULL),(759,1,'P240 MR (KOK) 25mt',32,18.000000,1,NULL),(606,1,'ZD900.1025 1lt KIRMIZI',40,12.000000,1,1.00),(607,1,'ZD900.1008 1lt GUL ',40,12.000000,1,1.00),(608,1,'ZD900.1069 1lt TURUNCU',40,12.000000,1,1.00),(609,1,'ZD420.1008 1lt GUL',40,12.000000,1,1.00),(610,1,'ZD900.1090 1lt KOYU MAUN ',40,12.000000,1,1.00),(611,1,'ZD900.1096 1lt VENGE ',40,12.000000,1,1.00),(612,1,'ZD900.1007 1lt TUTUN',40,12.000000,1,NULL),(613,1,'ZD900.1095 1lt KAHVE CEKIRDEGI',40,12.000000,1,1.00),(614,1,'ZD900.1072 1lt SIYAH ',40,12.000000,1,1.00),(615,1,'ZD420.1015 1lt MAVI',40,12.000000,1,1.00),(616,1,'ZD420.1004 1lt SARI',40,12.000000,1,1.00),(617,1,'ZD900.1014 1lt OKYANUS MAVI',40,12.000000,1,1.00),(618,1,'ZD900.1042 1lt YESIL',40,12.000000,1,1.00),(619,1,'ZD900.1089 1lt TIK ',40,12.000000,1,1.00),(620,1,'ZD900.1004 1lt SARI',40,12.000000,1,1.00),(621,1,'BL193.77.1000.2kg (+0.5kg) MDF BARIYERI (997)',32,16.000000,1,2.33),(622,1,'VA520.00.12kg AKRILIK PARLAK VERNIK ',40,134.000000,1,13.30),(623,1,'HA520.6kg AKRILIK SERTLESTIRICI  ',40,0.000000,1,6.59),(712,1,'BN100.10.9103 12kg',40,62.000000,1,13.00),(624,1,'COROB TINTING KRASKA',32,1.000000,1,NULL),(625,1,'CP585.25.1001 10.8kg (1012) ',32,74.000000,1,12.10),(626,1,'CP585.50.1001 10.8kg',32,74.000000,1,12.10),(627,1,'BN100.00.1000 2.5Lt ',40,14.000000,1,3.18),(628,1,'VN100.00.3kg ',40,14.000000,1,3.43),(629,1,'VN100.40.3kg',40,14.000000,1,3.43),(630,1,'VN100.15.3kg',40,14.000000,1,3.43),(631,1,'BP580.00.1000.3kg',40,39.000000,1,3.43),(632,1,'BP580.25.1000.3kg ',40,38.000000,1,3.43),(635,1,'BS200.00.9103.SIYAH 2.5 LT',40,1.000000,1,NULL),(636,1,'BS200.00.9103.SIYAH 0.75 LT',32,1.000000,1,NULL),(637,1,'BS200.10.9103.MAT SIYAH 2.5 LT',32,1.000000,1,NULL),(638,1,'BS200.10.9103.MAT SIYAH 0.75 LT',32,1.000000,1,NULL),(639,1,'BS200.00.1000.BOYA BEYAZ 2.5 LT',32,1.000000,1,NULL),(640,1,'BS200.00.1000.BOYA BEYAZ 0.75 LT',32,1.000000,1,NULL),(641,1,'BS200.10.1000.MAT BEYAZ 2.5 LT',32,1.000000,1,NULL),(642,1,'BS200.10.1000.MAT BEYAZ 0.75 LT',32,1.000000,1,NULL),(643,1,'BS200.00.7100.BOYA METALIK GRI 2.5 LT',32,1.000000,1,NULL),(644,1,'BS200.00.7100.BOYA METALIK GRI 0.75 LT',32,1.000000,1,NULL),(645,1,'BS200.00.7210.BOYA KURSUNI 2.5 LT',32,1.000000,1,NULL),(646,1,'BS200.00.7210.BOYA KURSUNI 0.75 LT',32,1.000000,1,NULL),(647,1,'BS200.00.8910.BOYA KOYU KAHVE 2.5 LT',32,1.000000,1,NULL),(648,1,'BS200.00.8910.BOYA KOYU KAHVE 0.75 LT',32,1.000000,1,NULL),(649,1,'BS200.00.8926.BOYA ACIK KAHVE 2.5 LT',32,1.000000,1,NULL),(650,1,'BS200.00.8926.BOYA ACIK KAHVE 0.75 LT',32,1.000000,1,NULL),(651,1,'BS200.00.7400.BOYA GUMUS 2.5 LT',32,1.000000,1,NULL),(652,1,'BS200.00.7400.BOYA GUMUS 0.75 LT',32,1.000000,1,NULL),(653,1,'BS100.78.7103.ANTIPAS - GRI 2.5 LT',32,1.000000,1,NULL),(654,1,'BS100.78.7103. ANTIPAS - GRI 0.75 LT',32,1.000000,1,NULL),(655,1,'BS100.78.3105.ANTIPAS - KIRMIZI 2.5 LT',32,1.000000,1,NULL),(656,1,'BS100.78.3105. KIRMIZI 0.75 LT',32,1.000000,1,NULL),(658,9,'FASSADE SILICONE PLUS D2 BAZI 15 LT',32,1.000000,1,22.94),(659,9,'FASSADE SILICONE PLUS D2 BAZI 2.5 LT',32,1.000000,1,3.87),(660,9,'FASSADE SILICONE PLUS BEYAZ 2.5 LT',32,1.000000,1,3.99),(661,9,'FASSADE SILICONE PLUS BEYAZ 7.5 LT',32,1.000000,1,11.89),(662,9,'FASSADE SILICONE PLUS BEYAZ 15 LT',32,1.000000,1,23.62),(663,9,'FASSADE SILICONE SUN C BAZI 2.5 LT',40,8.500000,1,4.08),(664,9,'FASSADE SILICONE SUN C BAZI 7.5 LT',40,22.000000,1,12.17),(665,9,'FASSADE SILICONE PLUS D4 BAZI 2.5 LT',32,1.000000,1,3.70),(666,9,'FASSADE SILICONE PLUS D4 BAZI 7.5 LT',32,1.000000,1,11.04),(667,9,'FASSADE SILICONE PLUS C BAZI 15 LT',32,1.000000,1,21.67),(668,9,'FASSADE SILICONE PLUS C BAZI 2.5 LT',32,1.000000,1,3.67),(669,9,'FASSADE SILICONE PLUS C BAZI 7.5 LT',32,1.000000,1,10.91),(670,9,'FASSADE SILICONE PLUS D1 BAZI 2.5 LT',32,1.000000,1,3.95),(671,9,'FASSADE SILICONE PLUS D4 BAZI 15 LT',32,1.000000,1,21.91),(672,9,'FASSADE SILICONE SUN D2 BAZI 2.5 LT',32,10.000000,1,4.08),(673,9,'FASSADE SILICONE SUN D3 BAZI 2.5 LT',40,9.500000,1,4.08),(674,9,'FASSADE SILICONE SUN D3 BAZI 7.5 LT',40,25.500000,1,12.17),(675,9,'FASSADE SILICONE SUN D2 BAZI 7.5 LT',40,26.500000,1,12.17),(676,9,'FASSADE SILICONE SUN D4 BAZI 2.5 LT',40,8.000000,1,4.08),(677,9,'FASSADE SILICONE SUN D4 BAZI 7.5 LT',40,21.500000,1,12.17),(678,9,'HYDRO ISOLATION BEYAZ 10 KG',32,32.000000,1,10.65),(679,9,'FASSADE SILICONE SUN D1 BAZI  7.5 LT',40,27.500000,1,12.17),(680,9,'FASSADE SILICONE SUN D1 BAZI 2.5 LT',32,10.000000,1,4.08),(681,1,'BN100.00.1000 12kg Ral9010',40,66.000000,1,13.00),(682,1,'Altin Boya 15kg',40,130.000000,1,16.00),(683,1,'Champangne Boya 15kg',40,130.000000,1,16.00),(684,1,'Gumush boya 15kg',40,130.000000,1,16.00),(685,1,'VA500.10 15kg',40,134.000000,1,16.00),(686,1,'BP580.50 3kg',40,38.000000,1,3.00),(687,1,'BN100.00.6400 2.5L',40,14.500000,1,3.00),(688,1,'TN200 12kg',40,37.000000,1,13.00),(689,1,'Cobler Shampagne 15kg',40,128.000000,1,16.00),(690,1,'Cobler Altin 15kg',40,128.000000,1,16.00),(691,1,'Cobler Gumush 15kg',40,128.000000,1,16.00),(692,1,'BN100.00.1000 25kg',40,117.000000,1,26.84),(693,1,'BN100.10.1000 25kg',40,127.000000,1,26.84),(694,1,'BN100.40.1000 25kg',40,127.000000,1,26.84),(695,1,'VN100.77 25kg',40,94.000000,1,26.84),(696,1,'VA520.00 25kg',40,267.000000,1,26.84),(697,1,'HA520.00 12.5kg',40,0.000000,1,12.94),(698,1,'BN100.77.1000 30kg',40,111.000000,1,32.00),(699,1,'BN350.77.1110 30kg',40,92.000000,1,31.74),(700,1,'BP333.77.1000 30kg',40,135.000000,1,31.74),(701,1,'HP900 10kg',40,0.000000,1,10.70),(702,1,'VA520.00 3kg',40,40.000000,1,3.00),(703,1,'HA520.00 1.5kg',40,0.000000,1,1.50),(704,1,'BN100.00.5800 12kg',40,67.000000,1,13.00);

--
-- Table structure for table `unit`
--

CREATE TABLE `unit` (
  `id_unit` int NOT NULL AUTO_INCREMENT,
  `name_unit` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_unit`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `unit`
--

INSERT INTO `unit` VALUES (30,'кг'),(31,'литр'),(32,'банка'),(33,'гр'),(34,'метр'),(35,'см'),(36,'м2'),(37,'м3'),(39,'бочка'),(40,'шт');

--
-- Table structure for table `vozvrat`
--

CREATE TABLE `vozvrat` (
  `id_vozvrat` int NOT NULL AUTO_INCREMENT,
  `id_prodaja` int NOT NULL DEFAULT '0',
  `amount_vozvrat` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_vozvrat` int NOT NULL DEFAULT '0',
  `description_vozvrat` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_vozvrat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vozvrat`
--


--
-- Table structure for table `vozvrat_pokupka`
--

CREATE TABLE `vozvrat_pokupka` (
  `id_vozvrat_pokupka` int NOT NULL AUTO_INCREMENT,
  `id_siryo` int NOT NULL DEFAULT '0',
  `amount_vozvrat_pokupka` decimal(20,6) NOT NULL DEFAULT '0.000000',
  `time_vozvrat_pokupka` int NOT NULL DEFAULT '0',
  `description_vozvrat_pokupka` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_vozvrat_pokupka`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vozvrat_pokupka`
--


--
-- Table structure for table `worker`
--

CREATE TABLE `worker` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `time` date NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker`
--

INSERT INTO `worker` VALUES (1,'Davlat','2023-06-25',1),(2,'Islombek','2023-06-25',1);

--
-- Table structure for table `worker_appoint_payment`
--

CREATE TABLE `worker_appoint_payment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `worker_id` int unsigned NOT NULL,
  `dengi_id` int NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `worker_id` (`worker_id`),
  CONSTRAINT `worker_appoint_payment_ibfk_1` FOREIGN KEY (`worker_id`) REFERENCES `worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker_appoint_payment`
--


--
-- Table structure for table `worker_avans`
--

CREATE TABLE `worker_avans` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `worker_id` int unsigned NOT NULL,
  `dengi_id` int DEFAULT NULL,
  `amount` decimal(20,2) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `worker_id` (`worker_id`),
  CONSTRAINT `worker_avans_ibfk_1` FOREIGN KEY (`worker_id`) REFERENCES `worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker_avans`
--


--
-- Table structure for table `worker_extra_payment`
--

CREATE TABLE `worker_extra_payment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `worker_id` int unsigned NOT NULL,
  `dengi_id` int DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `mukofot` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 mukofot, 0 shtraf',
  PRIMARY KEY (`id`),
  KEY `worker_id` (`worker_id`),
  CONSTRAINT `worker_extra_payment_ibfk_1` FOREIGN KEY (`worker_id`) REFERENCES `worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker_extra_payment`
--


--
-- Table structure for table `worker_payment`
--

CREATE TABLE `worker_payment` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `worker_id` int unsigned NOT NULL,
  `dengi_id` int DEFAULT NULL,
  `amount` decimal(20,2) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `worker_id` (`worker_id`),
  CONSTRAINT `worker_payment_ibfk_1` FOREIGN KEY (`worker_id`) REFERENCES `worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker_payment`
--


--
-- Table structure for table `worker_yuqlama`
--

CREATE TABLE `worker_yuqlama` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `worker_id` int unsigned NOT NULL,
  `absent_day` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `worker_id` (`worker_id`),
  CONSTRAINT `worker_yuqlama_ibfk_1` FOREIGN KEY (`worker_id`) REFERENCES `worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `worker_yuqlama`
--


--
-- Table structure for table `zakaz`
--

CREATE TABLE `zakaz` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `id_siryo` int unsigned NOT NULL,
  `id_client` int unsigned NOT NULL,
  `id_dengi` int NOT NULL,
  `cost` decimal(20,2) NOT NULL DEFAULT '0.00',
  `amount` decimal(20,6) NOT NULL,
  `get_date` date DEFAULT NULL,
  `partiya_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `zakaz`
--



