-- Table structure for table `produse_produs_filtre`
--

CREATE TABLE `produse_produs_filtre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `produs_id` int(11) NOT NULL,
  `valoarefiltru_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `produse_produs_filtre_produs_id_valoarefiltru_id_2d1574d3_uniq` (`produs_id`,`valoarefiltru_id`),
  KEY `produse_produs_filtr_valoarefiltru_id_c60f25e2_fk_produse_v` (`valoarefiltru_id`),
  CONSTRAINT `produse_produs_filtr_valoarefiltru_id_c60f25e2_fk_produse_v` FOREIGN KEY (`valoarefiltru_id`) REFERENCES `produse_valoarefiltru` (`id`),
  CONSTRAINT `produse_produs_filtre_produs_id_dd308735_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3923 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `produse_produs_filtre`
--

INSERT INTO `produse_produs_filtre` VALUES (51,20,28),(53,20,31),(983,20,246),(1188,20,252),(1240,20,280),(56,21,11),(54,21,40),(1310,21,241),(1210,21,252),(112,22,33),(140,22,40),(1308,22,241),(1206,22,252),(60,23,41),(1221,23,229),(62,24,28),(64,24,31),(984,24,246),(1174,24,258),(1241,24,280),(68,25,28),(66,25,32),(985,25,246),(1189,25,252),(1242,25,280),(72,26,28),(70,26,32),(986,26,246),(1175,26,258),(1243,26,280),(74,27,18),(76,27,28),(987,27,246),(1190,27,252),(1244,27,280),(78,28,18),(80,28,28),(988,28,246),(1176,28,258),(1245,28,280),(83,29,28),(85,29,46),(989,29,246),(1191,29,252),(1246,29,280),(87,30,28),(89,30,46),(990,30,246),(1177,30,258),(1247,30,280),(92,31,28),(90,31,33),(991,31,246),(1192,31,252),(1248,31,280),(96,32,28),(94,32,33),(992,32,246),(1178,32,258),(1249,32,280),(98,33,10),(100,33,28),(993,33,246),(1193,33,252),(1250,33,280),(102,34,10),(104,34,28),(994,34,246),(1179,34,258),(1251,34,280),(107,35,33),(106,35,40),(1013,35,246),(1199,35,252),(110,36,33),(238,36,40),(1027,36,246),(1181,36,258),(114,37,10),(113,37,40),(1026,37,246),(1200,37,252),(117,38,10),(116,38,40),(1025,38,246),(1182,38,258),(120,39,34),(119,39,40),(1024,39,246),(1201,39,252),(123,40,34),(122,40,40),(1023,40,246),(1183,40,258),(127,41,11),(125,41,40),(1022,41,246),(1202,41,252),(129,42,11),(128,42,40),(1021,42,246),(1184,42,258),(143,43,18),(142,43,40),(1020,43,246),(1203,43,252),(147,44,18),(146,44,40),(1019,44,246),(1185,44,258),(159,45,40),(152,45,46),(1018,45,246),(1186,45,258),(154,46,40),(156,46,46),(1017,46,246),(1204,46,252),(162,47,33),(161,47,40),(1016,47,246),(1172,47,256),(165,48,48),(1214,48,119),(1211,48,229),(166,49,48),(1215,49,119),(1212,49,229),(167,50,48),(1216,50,119),(1213,50,229),(172,51,54),(1063,51,228),(1170,51,253),(1171,51,255),(174,52,54),(1064,52,228),(1164,52,252),(1165,52,254),(170,53,51),(1040,53,244),(173,54,54),(976,54,228),(1168,54,251),(1169,54,254),(1547,57,14),(178,57,24),(1365,57,228),(182,58,23),(181,58,52),(1081,58,228),(183,59,24),(184,59,52),(1082,59,228),(185,60,25),(186,60,52),(1083,60,228),(190,61,14),(189,61,23),(1084,61,228),(193,62,14),(191,62,25),(1085,62,228),(194,63,56),(1163,63,226),(1359,63,229),(195,64,58),(1153,64,223),(196,65,59),(1141,65,221),(1542,65,229),(197,66,59),(1136,66,218),(1540,66,229),(199,67,59),(1140,67,221),(1541,67,229),(202,68,59),(1137,68,218),(1543,68,229),(731,69,107),(1338,69,229),(205,70,63),(379,70,109),(1326,70,231),(206,71,63),(380,71,109),(1327,71,231),(207,72,63),(381,72,109),(1328,72,231),(208,73,63),(382,73,109),(1329,73,231),(209,74,56),(1360,74,229),(1162,74,250),(225,75,41),(1154,75,222),(228,76,41),(1121,76,217),(1380,76,229),(1235,76,273),(230,78,41),(1144,78,215),(1143,78,231),(231,79,73),(1377,79,241),(1376,79,287),(1375,79,288),(233,81,14),(234,82,56),(235,82,74),(1384,82,229),(236,83,56),(1382,83,226),(1381,83,229),(1050,84,244),(814,85,94),(1052,85,244),(244,86,51),(1041,86,244),(442,87,94),(1056,87,244),(443,88,94),(1057,88,244),(250,89,63),(1160,89,184),(1299,89,229),(252,90,63),(1157,90,208),(1267,90,229),(253,91,63),(1305,91,91),(1279,91,229),(1306,91,285),(254,92,63),(1303,92,214),(1278,92,229),(1304,92,284),(255,93,59),(955,93,185),(971,93,229),(257,94,59),(957,94,185),(973,94,229),(259,95,59),(1133,95,214),(1269,95,229),(261,96,59),(1263,96,229),(262,97,78),(1262,97,229),(263,98,59),(953,98,185),(965,98,229),(265,99,59),(1159,99,215),(1260,99,229),(267,100,80),(268,100,81),(269,101,80),(270,101,81),(272,102,45),(271,102,82),(274,103,14),(1042,103,245),(276,104,14),(1075,104,228),(277,105,52),(278,105,84),(279,106,84),(280,106,85),(755,107,14),(281,107,84),(284,108,14),(1089,108,228),(288,109,14),(1090,109,228),(291,110,14),(1091,110,228),(292,111,41),(293,111,90),(1224,111,229),(294,112,40),(295,112,91),(1222,112,229),(296,113,59),(1135,113,218),(1223,113,229),(299,115,97),(1566,115,199),(1424,115,229),(327,116,41),(1431,116,217),(1433,116,222),(1432,116,225),(1236,116,273),(331,118,100),(1161,118,184),(1410,118,229),(333,119,45),(1155,119,222),(1411,119,229),(335,120,45),(1122,120,217),(1412,120,229),(336,121,45),(1152,121,225),(1413,121,229),(340,122,45),(1123,122,217),(1124,122,222),(1125,122,249),(1526,122,290),(343,123,102),(1139,123,218),(1414,123,229),(345,124,102),(1053,124,245),(347,125,102),(1054,125,245),(349,126,94),(1944,126,229),(1400,126,291),(351,127,94),(1945,127,229),(1401,127,291),(1396,128,81),(352,128,94),(1397,128,289),(1399,128,290),(353,129,73),(1419,129,91),(1418,129,152),(354,130,103),(355,130,105),(1415,130,229),(356,131,104),(357,131,105),(1416,131,229),(1095,132,228),(359,133,63),(360,133,103),(1517,133,229),(362,134,63),(361,134,108),(1315,134,229),(364,135,63),(363,135,108),(1316,135,229),(366,136,63),(365,136,108),(1317,136,229),(368,137,63),(367,137,108),(1318,137,229),(370,138,63),(369,138,108),(1319,138,229),(372,139,63),(371,139,108),(1320,139,229),(374,140,63),(373,140,108),(1321,140,229),(376,141,63),(375,141,108),(1322,141,229),(378,142,63),(377,142,108),(1323,142,229),(384,143,63),(383,143,108),(1280,143,229),(386,144,63),(385,144,108),(1281,144,229),(388,145,63),(387,145,108),(1282,145,229),(390,146,63),(389,146,108),(1283,146,229),(392,147,63),(391,147,108),(1284,147,229),(394,148,63),(393,148,108),(1285,148,229),(396,149,63),(395,149,108),(1286,149,229),(398,150,63),(397,150,108),(1287,150,229),(400,151,63),(399,151,108),(1288,151,229),(402,152,63),(401,152,108),(1289,152,229),(404,153,63),(403,153,108),(1290,153,229),(406,154,63),(405,154,108),(1291,154,229),(408,155,63),(407,155,108),(1292,155,229),(410,156,63),(409,156,108),(1297,156,229),(411,157,59),(956,157,185),(972,157,229),(413,158,110),(414,158,111),(1277,158,229),(415,159,94),(416,159,112),(1272,159,229),(418,160,94),(417,160,112),(1275,160,229),(420,161,94),(419,161,112),(1947,161,229),(422,162,94),(421,162,112),(1273,162,229),(424,163,94),(423,163,112),(1271,163,229),(426,164,94),(425,164,112),(1948,164,229),(428,165,94),(427,165,112),(1276,165,229),(430,166,94),(429,166,112),(1274,166,229),(432,167,94),(431,167,112),(1946,167,229),(842,168,45),(434,168,113),(1518,168,229),(437,169,45),(436,169,113),(1519,169,229),(439,170,45),(438,170,113),(1520,170,229),(440,171,63),(1129,171,227),(447,172,14),(445,172,46),(1108,172,239),(450,173,14),(448,173,33),(1109,173,239),(451,174,10),(453,174,14),(1110,174,239),(456,175,14),(454,175,34),(1111,175,239),(458,176,11),(459,176,14),(1112,176,239),(462,177,14),(460,177,46),(1114,177,239),(465,178,14),(463,178,33),(1116,178,239),(466,179,10),(468,179,14),(1118,179,239),(471,180,14),(469,180,34),(1119,180,239),(473,181,11),(474,181,14),(1120,181,239),(477,182,14),(475,182,46),(1032,182,239),(480,183,14),(478,183,33),(1034,183,239),(481,184,10),(483,184,14),(1035,184,239),(486,185,14),(484,185,34),(1036,185,239),(488,186,11),(489,186,14),(1037,186,239),(492,187,14),(490,187,46),(1031,187,239),(495,188,14),(493,188,33),(1096,188,239),(496,189,10),(498,189,14),(1097,189,239),(501,190,14),(499,190,34),(1098,190,239),(503,191,11),(504,191,14),(1099,191,239),(507,192,14),(505,192,46),(1101,192,239),(510,193,14),(508,193,33),(1103,193,239),(511,194,10),(513,194,14),(1105,194,239),(516,195,14),(514,195,34),(1106,195,239),(518,196,11),(519,196,14),(1107,196,239),(522,197,14),(520,197,46),(999,197,239),(525,198,14),(523,198,33),(1000,198,239),(526,199,10),(528,199,14),(1001,199,239),(531,200,14),(529,200,34),(1002,200,239),(533,201,11),(534,201,14),(1003,201,239),(1078,202,228),(538,203,109),(537,203,116),(539,204,81),(540,204,116),(541,205,59),(542,205,111),(543,206,59),(544,206,111),(545,207,59),(546,207,111),(547,208,14),(1004,208,242),(550,209,59),(549,209,81),(551,210,109),(552,210,118),(1356,210,229),(553,211,118),(554,211,119),(1362,211,229),(555,212,118),(556,212,119),(1363,212,229),(557,213,100),(1402,213,229),(1092,216,228),(562,217,59),(1066,217,228),(564,218,45),(1539,218,229),(566,219,137),(1048,219,244),(567,220,136),(1049,220,244),(570,221,135),(1028,221,244),(572,222,63),(571,222,108),(1324,222,229),(574,223,63),(573,223,108),(1325,223,229),(576,224,94),(575,224,112),(1270,224,229),(577,225,63),(1301,225,91),(1300,225,229),(1302,225,283),(578,226,63),(579,226,138),(1293,226,229),(581,227,63),(580,227,138),(1294,227,229),(583,228,63),(582,228,138),(1295,228,229),(585,229,63),(584,229,138),(1296,229,229),(588,230,63),(1158,230,208),(1268,230,229),(589,231,63),(1148,231,220),(1423,231,229),(591,232,48),(949,232,188),(966,232,229),(594,233,28),(593,233,33),(1062,233,235),(1254,233,282),(597,234,28),(596,234,46),(1068,234,235),(1255,234,282),(600,235,28),(599,235,34),(1067,235,235),(1256,235,282),(602,236,11),(603,236,28),(1069,236,235),(1257,236,282),(605,237,10),(606,237,28),(1070,237,235),(1258,237,282),(608,238,12),(609,238,28),(1071,238,235),(1259,238,280),(612,239,41),(611,239,65),(1425,239,229),(613,240,41),(614,240,143),(1426,240,229),(615,241,41),(982,241,237),(617,242,41),(1149,242,224),(1427,242,229),(620,243,41),(1428,243,229),(622,244,41),(621,244,65),(1429,244,229),(623,245,41),(1151,245,225),(1430,245,229),(1055,246,244),(1150,248,226),(1229,248,229),(629,249,73),(630,249,149),(1366,249,229),(631,250,56),(632,250,65),(1383,250,229),(633,251,14),(1406,251,229),(634,252,14),(1403,252,229),(635,253,14),(1405,253,229),(636,254,14),(1404,254,229),(637,255,100),(1093,255,235),(641,256,34),(640,256,150),(642,256,151),(1533,256,229),(643,257,18),(644,257,150),(645,257,151),(1534,257,229),(646,258,31),(647,258,150),(648,258,151),(1535,258,229),(649,259,12),(650,259,150),(651,259,151),(1536,259,229),(652,260,10),(653,260,150),(654,260,151),(1537,260,229),(655,261,33),(656,261,150),(657,261,151),(1538,261,229),(658,262,97),(950,262,199),(967,262,229),(961,263,186),(962,263,228),(959,264,185),(960,264,228),(963,265,184),(964,265,228),(664,266,94),(1044,266,244),(1928,266,315),(666,267,94),(1046,267,244),(1930,267,315),(668,268,94),(1045,268,244),(1929,268,315),(670,269,94),(1047,269,244),(1931,269,315),(674,271,59),(673,271,152),(1385,271,229),(675,272,14),(1387,272,228),(676,273,14),(1388,273,228),(677,274,14),(1389,274,228),(678,275,14),(1390,275,228),(679,276,14),(1386,276,228),(682,277,59),(998,277,243),(684,278,59),(997,278,243),(685,279,100),(1417,279,229),(686,280,100),(1043,280,244),(690,281,102),(1038,281,238),(692,282,146),(1039,282,240),(695,283,59),(1264,283,229),(696,284,59),(1134,284,218),(1217,284,229),(698,285,59),(1156,285,221),(1218,285,229),(700,286,92),(701,286,156),(1391,286,229),(702,287,59),(1131,287,207),(1314,287,229),(704,288,59),(1138,288,218),(1395,288,229),(1266,290,92),(1265,290,216),(1367,290,229),(711,291,59),(1130,291,207),(1532,291,229),(713,292,97),(952,292,199),(969,292,229),(715,293,46),(716,293,159),(1337,293,229),(717,294,46),(718,294,159),(1330,294,229),(719,295,34),(720,295,159),(1336,295,229),(721,296,34),(722,296,159),(1331,296,229),(723,297,31),(724,297,159),(1335,297,229),(725,298,31),(726,298,159),(1332,298,229),(727,299,12),(728,299,159),(1334,299,229),(729,300,12),(730,300,159),(1333,300,229),(732,301,107),(1339,301,229),(733,302,107),(1349,302,229),(734,303,107),(1345,303,229),(735,304,107),(1348,304,229),(736,305,107),(1350,305,229),(737,306,107),(1340,306,229),(738,307,107),(1346,307,229),(739,308,107),(1347,308,229),(740,309,107),(1342,309,229),(741,310,107),(1343,310,229),(742,311,107),(1344,311,229),(743,312,107),(1351,312,229),(744,313,107),(1352,313,229),(745,314,107),(1353,314,229),(746,315,52),(1072,315,228),(750,316,52),(1073,316,228),(753,317,52),(1074,317,228),(756,318,84),(757,318,86),(764,319,33),(758,319,40),(1009,319,247),(762,320,10),(763,320,40),(1011,320,247),(766,321,34),(767,321,40),(1012,321,247),(769,322,40),(1010,322,247),(770,323,14),(1422,323,229),(777,324,10),(773,324,40),(1309,324,241),(1208,324,252),(782,325,34),(778,325,40),(1307,325,241),(1209,325,252),(783,326,40),(1394,326,246),(1207,326,252),(786,327,14),(1029,327,248),(1076,328,228),(1077,329,228),(791,330,14),(793,331,14),(795,332,14),(1033,332,239),(796,333,102),(979,333,236),(799,334,102),(1079,334,235),(801,335,164),(977,335,236),(803,336,164),(978,336,236),(804,337,105),(805,337,165),(1550,337,229),(806,338,105),(807,338,165),(1551,338,229),(809,339,56),(981,339,237),(812,341,51),(1051,341,244),(815,342,81),(1565,342,229),(817,343,100),(1008,343,241),(818,344,100),(1094,344,235),(821,345,14),(822,346,40),(1015,346,246),(1205,346,252),(826,347,40),(1014,347,246),(1187,347,258),(830,348,25),(831,348,52),(1086,348,228),(835,349,23),(833,349,52),(1087,349,228),(836,350,24),(837,350,52),(1088,350,228),(840,351,167),(1370,351,229),(1197,351,252),(1198,351,259),(841,352,167),(1371,352,229),(844,353,169),(1358,353,229),(845,354,40),(1005,354,241),(1194,354,252),(848,355,40),(1006,355,241),(1173,355,257),(853,356,40),(1007,356,241),(1180,356,258),(858,357,94),(1145,357,219),(1146,357,222),(1949,357,290),(868,358,171),(1408,358,229),(861,359,107),(862,360,107),(863,361,107),(864,362,107),(1341,362,229),(871,363,171),(869,364,171),(1409,364,229),(870,365,171),(1407,365,229),(872,366,172),(954,366,185),(1261,366,229),(1030,367,239),(875,368,107),(876,369,107),(877,370,14),(1393,370,229),(879,371,28),(880,371,46),(1100,371,239),(883,372,28),(881,372,33),(1102,372,239),(884,373,10),(886,373,28),(1104,373,239),(888,374,28),(889,374,46),(1113,374,239),(892,375,28),(890,375,33),(1115,375,239),(893,376,10),(895,376,28),(1117,376,239),(897,377,173),(1228,377,229),(898,378,173),(1225,378,229),(899,379,173),(1226,379,229),(900,380,173),(1227,380,229),(1488,381,46),(903,381,174),(996,381,246),(1196,381,252),(1487,382,18),(907,382,174),(995,382,246),(1195,382,252),(910,383,175),(980,383,236),(912,384,176),(913,385,176),(914,386,176),(915,387,176),(916,388,177),(1368,388,229),(917,389,105),(1128,389,208),(919,390,105),(921,391,110),(922,391,178),(1392,391,229),(924,392,91),(923,392,105),(1127,392,213),(1361,392,229),(926,393,171),(927,394,52),(1065,394,228),(1166,394,252),(1167,394,254),(930,395,105),(1132,395,215),(1420,395,229),(931,396,105),(1147,396,215),(1421,396,229),(935,397,180),(1369,397,229),(936,398,97),(951,398,199),(968,398,229),(1061,399,12),(938,399,146),(1059,399,244),(1060,400,34),(940,400,146),(1058,400,244),(942,401,59),(1142,401,221),(1544,401,229),(945,402,181),(1379,402,229),(946,403,181),(1378,403,229),(948,405,63),(1312,405,108),(1311,405,208),(1525,405,290),(1219,406,41),(1220,406,229),(1355,407,118),(1354,407,229),(1357,407,286),(1372,408,97),(1374,408,199),(1373,408,231),(1436,410,63),(1435,410,187),(1437,410,229),(1440,411,63),(1438,411,187),(1439,411,229),(1443,412,63),(1441,412,187),(1442,412,229),(1446,413,63),(1444,413,187),(1445,413,229),(1449,414,63),(1447,414,187),(1448,414,229),(1452,415,63),(1450,415,187),(1451,415,229),(1455,416,63),(1453,416,187),(1454,416,229),(1458,417,63),(1456,417,187),(1457,417,229),(1459,418,63),(1461,418,207),(1460,418,229),(1462,419,63),(1464,419,207),(1463,419,229),(1465,420,63),(1467,420,207),(1466,420,229),(1468,421,63),(1470,421,207),(1469,421,229),(1471,422,63),(1473,422,207),(1472,422,229),(1474,423,63),(1476,423,207),(1475,423,229),(1477,424,63),(1479,424,207),(1478,424,229),(1481,425,63),(1480,425,229),(1482,425,294),(1483,426,33),(1485,426,174),(1486,426,246),(1484,426,252),(1489,427,10),(1491,427,174),(1492,427,246),(1490,427,252),(1496,428,34),(1494,428,174),(1495,428,246),(1493,428,252),(1498,429,174),(1499,429,246),(1497,429,252),(1501,430,174),(1502,430,246),(1500,430,258),(1504,431,174),(1505,431,246),(1503,431,256),(1506,432,40),(1507,432,246),(1508,432,295),(1510,433,40),(1511,433,246),(1509,433,296),(1512,434,40),(1514,434,246),(1513,434,297),(1516,435,40),(1515,435,246),(1531,436,94),(1524,436,290),(1522,436,298),(1523,436,299),(1529,437,91),(1530,437,94),(1527,437,185),(1528,437,290),(1545,438,82),(1546,438,229),(1548,439,231),(1549,439,300),(1552,440,73),(1553,440,231),(1555,440,290),(1554,440,301),(1556,441,63),(1557,441,109),(1558,441,231),(1559,442,63),(1560,442,109),(1561,442,231),(1562,443,73),(1563,443,178),(1564,443,229),(1567,444,229),(1569,444,303),(1571,444,309),(1573,445,229),(1574,445,303),(1572,445,313),(1582,448,229),(1583,448,303),(1581,448,313),(1585,449,229),(1586,449,303),(1584,449,313),(1588,450,229),(1589,450,303),(1587,450,313),(1594,452,229),(1593,452,313),(1596,453,229),(1597,453,303),(1595,453,313),(1598,454,229),(1600,454,303),(1599,454,310),(1601,455,229),(1603,455,303),(1602,455,310),(1604,456,229),(1606,456,303),(1605,456,310),(1607,457,229),(1609,457,303),(1608,457,310),(1610,458,229),(1611,458,303),(1614,458,310),(1612,459,229),(1613,459,303),(1615,459,310),(1616,460,229),(1618,460,303),(1617,460,310),(1619,461,229),(1621,461,303),(1620,461,310),(1622,462,229),(1624,462,303),(1623,462,310),(1625,463,229),(1627,463,303),(1626,463,310),(1628,464,229),(1630,464,303),(1629,464,310),(1631,465,229),(1632,465,303),(1633,465,310),(1634,466,229),(1636,466,303),(1635,466,310),(1637,467,229),(1639,467,303),(1638,467,310),(1640,468,229),(1642,468,303),(1641,468,310),(1643,469,229),(1645,469,303),(1644,469,310),(1646,470,229),(1648,470,303),(1647,470,310),(1649,471,229),(1651,471,303),(1650,471,310),(1652,472,229),(1654,472,303),(1653,472,310),(1655,473,229),(1657,473,303),(1656,473,310),(1658,474,229),(1660,474,303),(1659,474,310),(1661,475,229),(1663,475,303),(1662,475,310),(1664,476,229),(1666,476,303),(1665,476,310),(1667,477,229),(1668,477,303),(1675,477,310),(1669,478,229),(1671,478,303),(1670,478,310),(1672,479,229),(1674,479,303),(1673,479,310),(1676,480,229),(1678,480,303),(1677,480,310),(1679,481,229),(1681,481,303),(1680,481,310),(1682,482,229),(1684,482,303),(1683,482,310),(1685,483,229),(1687,483,303),(1686,483,310),(1688,484,229),(1690,484,303),(1689,484,310),(1692,485,229),(2808,485,303),(1691,485,309),(1695,486,229),(1696,486,303),(1694,486,309),(1698,487,229),(1699,487,303),(1697,487,309),(1701,488,229),(1702,488,303),(1700,488,309),(1704,489,229),(1705,489,303),(1703,489,309),(1707,490,229),(1708,490,303),(1706,490,309),(1710,491,229),(1711,491,303),(1709,491,309),(1713,492,229),(1714,492,303),(1712,492,309),(1716,493,229),(1717,493,303),(1715,493,309),(1719,494,229),(1720,494,303),(1718,494,309),(1722,495,229),(1723,495,303),(1721,495,309),(1725,496,229),(1726,496,303),(1724,496,309),(1728,497,229),(1729,497,303),(1727,497,309),(1731,498,229),(1732,498,303),(1730,498,309),(1734,499,229),(1735,499,303),(1733,499,309),(1737,500,229),(1738,500,303),(1736,500,309),(1740,501,229),(1741,501,303),(1739,501,309),(1743,502,229),(1744,502,303),(1742,502,309),(1746,503,229),(1747,503,303),(1745,503,309),(1749,504,229),(1750,504,303),(1748,504,309),(1752,505,229),(1753,505,303),(1751,505,309),(1755,506,229),(1756,506,303),(1754,506,309),(1758,507,229),(1759,507,303),(1757,507,309),(1761,508,229),(1762,508,303),(1760,508,309),(1764,509,229),(1765,509,303),(1763,509,309),(1767,510,229),(1768,510,303),(1766,510,309),(1770,511,229),(1771,511,303),(1769,511,309),(1773,512,229),(1774,512,303),(1772,512,309),(1776,513,229),(1777,513,303),(1775,513,309),(1779,514,229),(1780,514,303),(1778,514,309),(1782,515,229),(1783,515,303),(1781,515,309),(1785,516,229),(1786,516,303),(1784,516,309),(1788,517,229),(1789,517,303),(1787,517,309),(1791,518,229),(1792,518,303),(1790,518,309),(1794,519,229),(1795,519,303),(1793,519,309),(1797,520,229),(1798,520,303),(1796,520,309),(1800,521,229),(1801,521,303),(1799,521,309),(1803,522,229),(1804,522,303),(1802,522,309),(1806,523,229),(1807,523,303),(1805,523,309),(1809,524,229),(1810,524,303),(1808,524,309),(1812,525,229),(1813,525,303),(1811,525,309),(1815,526,229),(1816,526,303),(1814,526,309),(1818,527,229),(1819,527,303),(1817,527,309),(1821,528,229),(1822,528,303),(1820,528,309),(1824,529,229),(1825,529,303),(1823,529,309),(1827,530,229),(1828,530,303),(1826,530,309),(1830,531,229),(1831,531,303),(1829,531,309),(1833,532,229),(1834,532,303),(1832,532,309),(1836,533,229),(1837,533,303),(1835,533,309),(1839,534,229),(1840,534,303),(1838,534,309),(1842,535,229),(1843,535,303),(1841,535,309),(1845,536,229),(1846,536,303),(1844,536,309),(1848,537,229),(1849,537,303),(1847,537,309),(1851,538,229),(1852,538,303),(1850,538,309),(1854,539,229),(1855,539,303),(1853,539,309),(1857,540,229),(1858,540,303),(1856,540,309),(1860,541,229),(1861,541,303),(1859,541,309),(1863,542,229),(1864,542,303),(1862,542,309),(1866,543,229),(1867,543,303),(1865,543,309),(1869,544,229),(1870,544,303),(1868,544,309),(1872,545,229),(1873,545,303),(1871,545,309),(1875,546,229),(1876,546,303),(1874,546,309),(1878,547,229),(1879,547,303),(1877,547,309),(1881,548,229),(1882,548,303),(1880,548,309),(1884,549,229),(1885,549,303),(1883,549,309),(1887,550,229),(1888,550,303),(1886,550,309),(1890,551,229),(1891,551,303),(1889,551,309),(1893,552,229),(1894,552,303),(1892,552,309),(1896,553,229),(1897,553,303),(1895,553,309),(1899,554,229),(1900,554,303),(1898,554,309),(1902,555,229),(1903,555,303),(1901,555,309),(1905,556,229),(1906,556,303),(1904,556,309),(1908,557,229),(1909,557,303),(1907,557,309),(1911,558,229),(1912,558,303),(1910,558,309),(1914,559,229),(1915,559,303),(1913,559,309),(1917,560,229),(1918,560,303),(1916,560,309),(1920,561,229),(1921,561,303),(1919,561,309),(1923,562,229),(1924,562,303),(1922,562,309),(1926,563,229),(1927,563,303),(1925,563,309),(1932,564,94),(1933,564,244),(1934,564,316),(1935,565,94),(1936,565,244),(1937,565,316),(1938,566,94),(1939,566,244),(1940,566,316),(1941,567,94),(1942,567,244),(1943,567,316),(1951,568,229),(1952,568,303),(1950,568,309),(1954,569,229),(1955,569,303),(1953,569,309),(1957,570,229),(1958,570,303),(1956,570,309),(1960,571,229),(1961,571,303),(1959,571,309),(1963,572,229),(1964,572,303),(1962,572,309),(1966,573,229),(1967,573,303),(1965,573,309),(1969,574,229),(1970,574,303),(1968,574,309),(1972,575,229),(1973,575,303),(1971,575,309),(1975,576,229),(1976,576,303),(1974,576,309),(1978,577,229),(1979,577,303),(1977,577,309),(1981,578,229),(1982,578,303),(1980,578,309),(1984,579,229),(1985,579,303),(1983,579,309),(1987,580,229),(1988,580,303),(1986,580,309),(1990,581,229),(1991,581,303),(1989,581,309),(1993,582,229),(1994,582,303),(1992,582,309),(1996,583,229),(1997,583,303),(1995,583,309),(1999,584,229),(2000,584,303),(1998,584,309),(2002,585,229),(2003,585,303),(2001,585,309),(2005,586,229),(2006,586,303),(2004,586,309),(2007,587,56),(2008,587,229),(2009,588,56),(2010,588,65),(2011,588,229),(2012,589,56),(2013,589,226),(2014,589,229),(2016,590,229),(2017,590,303),(2015,590,309),(2019,591,229),(2020,591,303),(2018,591,309),(2022,592,229),(2023,592,303),(2021,592,309),(2025,593,229),(2026,593,303),(2024,593,309),(2028,594,229),(2029,594,303),(2027,594,309),(2031,595,229),(2032,595,303),(2030,595,309),(2034,596,229),(2035,596,303),(2033,596,309),(2037,597,229),(2038,597,303),(2036,597,309),(2040,598,229),(2041,598,303),(2039,598,309),(2043,599,229),(2044,599,303),(2042,599,309),(2046,600,229),(2047,600,303),(2045,600,309),(2049,601,229),(2050,601,303),(2048,601,309),(2052,602,229),(2053,602,303),(2051,602,309),(2055,603,229),(2056,603,303),(2054,603,309),(2058,604,229),(2059,604,303),(2057,604,309),(2061,605,229),(2062,605,303),(2060,605,309),(2064,606,229),(2065,606,303),(2063,606,309),(2067,607,229),(2068,607,303),(2066,607,309),(2070,608,229),(2071,608,303),(2069,608,309),(2073,609,229),(2074,609,303),(2072,609,309),(2076,610,229),(2077,610,303),(2075,610,309),(2079,611,229),(2080,611,303),(2078,611,309),(2082,612,229),(2083,612,303),(2081,612,309),(2085,613,229),(2086,613,303),(2084,613,309),(2088,614,229),(2089,614,303),(2087,614,309),(2091,615,229),(2092,615,303),(2090,615,309),(2094,616,229),(2095,616,303),(2093,616,309),(2097,617,229),(2098,617,303),(2096,617,309),(2100,618,229),(2101,618,303),(2099,618,309),(2103,619,229),(2104,619,303),(2102,619,309),(2106,620,229),(2107,620,303),(2105,620,309),(2109,621,229),(2110,621,303),(2108,621,309),(2112,622,229),(2113,622,303),(2111,622,309),(2115,623,229),(2116,623,303),(2114,623,309),(2117,624,229),(2118,624,303),(2120,625,229),(2121,625,303),(2119,625,309),(2123,626,229),(2124,626,303),(2122,626,309),(2126,627,229),(2127,627,303),(2125,627,309),(2129,628,229),(2130,628,303),(2128,628,309),(2132,629,229),(2133,629,303),(2131,629,309),(2135,630,229),(2136,630,303),(2134,630,309),(2138,631,229),(2139,631,303),(2137,631,309),(2141,632,229),(2142,632,303),(2140,632,309),(2144,633,229),(2145,633,303),(2143,633,309),(2147,634,229),(2148,634,303),(2146,634,309),(2150,635,229),(2151,635,303),(2149,635,309),(2153,636,229),(2154,636,303),(2152,636,309),(2156,637,229),(2157,637,303),(2155,637,309),(2159,638,229),(2160,638,303),(2158,638,309),(2162,639,229),(2163,639,303),(2161,639,309),(2165,640,229),(2166,640,303),(2164,640,309),(2168,641,229),(2169,641,303),(2167,641,309),(2171,642,229),(2172,642,303),(2170,642,309),(2174,643,229),(2175,643,303),(2173,643,309),(2177,644,229),(2178,644,303),(2176,644,309),(2180,645,229),(2181,645,303),(2179,645,309),(2183,646,229),(2184,646,303),(2182,646,309),(2186,647,229),(2187,647,303),(2185,647,309),(2189,648,229),(2190,648,303),(2188,648,309),(2192,649,229),(2193,649,303),(2191,649,309),(2195,650,229),(2196,650,303),(2194,650,309),(2198,651,229),(2199,651,303),(2197,651,309),(2201,652,229),(2202,652,303),(2200,652,309),(2204,653,229),(2205,653,303),(2203,653,309),(2207,654,229),(2208,654,303),(2206,654,309),(2210,655,229),(2211,655,303),(2209,655,309),(2213,656,229),(2214,656,303),(2212,656,309),(2216,657,229),(2217,657,303),(2215,657,309),(2219,658,229),(2220,658,303),(2218,658,309),(2222,659,229),(2223,659,303),(2221,659,309),(2225,660,229),(2226,660,303),(2224,660,309),(2228,661,229),(2229,661,303),(2227,661,309),(2231,662,229),(2232,662,303),(2230,662,309),(2234,663,229),(2235,663,303),(2233,663,309),(2237,664,229),(2238,664,303),(2236,664,309),(2240,665,229),(2241,665,303),(2239,665,309),(2243,666,229),(2244,666,303),(2242,666,309),(2246,667,229),(2247,667,303),(2245,667,309),(2249,668,229),(2250,668,303),(2248,668,309),(2252,669,229),(2253,669,303),(2251,669,309),(2255,670,229),(2256,670,303),(2254,670,309),(2258,671,229),(2259,671,303),(2257,671,309),(2261,672,229),(2262,672,303),(2260,672,309),(2264,673,229),(2265,673,303),(2263,673,309),(2267,674,229),(2268,674,303),(2266,674,309),(2270,675,229),(2271,675,303),(2269,675,309),(2273,676,229),(2274,676,303),(2272,676,309),(2276,677,229),(2277,677,303),(2275,677,309),(2279,678,229),(2280,678,303),(2278,678,309),(2282,679,229),(2283,679,303),(2281,679,309),(2285,680,229),(2286,680,303),(2284,680,309),(2288,681,229),(2289,681,303),(2287,681,309),(2291,682,229),(2292,682,303),(2290,682,309),(2294,683,229),(2295,683,303),(2293,683,309),(2297,684,229),(2298,684,303),(2296,684,309),(2300,685,229),(2301,685,303),(2299,685,309),(2303,686,229),(2304,686,303),(2302,686,309),(2306,687,229),(2307,687,303),(2305,687,309),(2309,688,229),(2310,688,303),(2308,688,309),(2312,689,229),(2313,689,303),(2311,689,309),(2315,690,229),(2316,690,303),(2314,690,309),(2318,691,229),(2319,691,303),(2317,691,309),(2321,692,229),(2322,692,303),(2320,692,309),(2324,693,229),(2325,693,303),(2323,693,309),(2327,694,229),(2328,694,303),(2326,694,309),(2330,695,229),(2331,695,303),(2329,695,309),(2333,696,229),(2334,696,303),(2332,696,309),(2336,697,229),(2337,697,303),(2335,697,309),(2339,698,229),(2340,698,303),(2338,698,309),(2342,699,229),(2343,699,303),(2341,699,309),(2345,700,229),(2346,700,303),(2344,700,309),(2348,701,229),(2349,701,303),(2347,701,309),(2351,702,229),(2352,702,303),(2350,702,309),(2354,703,229),(2355,703,303),(2353,703,309),(2357,704,229),(2358,704,303),(2356,704,309),(2360,705,229),(2361,705,303),(2359,705,309),(2363,706,229),(2364,706,303),(2362,706,309),(2366,707,229),(2367,707,303),(2365,707,309),(2369,708,229),(2370,708,303),(2368,708,309),(2372,709,229),(2373,709,303),(2371,709,309),(2375,710,229),(2376,710,303),(2374,710,309),(2378,711,229),(2379,711,303),(2377,711,309),(2381,712,229),(2382,712,303),(2380,712,309),(2384,713,229),(2385,713,303),(2383,713,309),(2387,714,229),(2388,714,303),(2386,714,309),(2390,715,229),(2391,715,303),(2389,715,309),(2393,716,229),(2394,716,303),(2392,716,309),(2396,717,229),(2397,717,303),(2395,717,309),(2399,718,229),(2400,718,303),(2398,718,309),(2402,719,229),(2403,719,303),(2401,719,309),(2405,720,229),(2406,720,303),(2404,720,309),(2408,721,229),(2409,721,303),(2407,721,309),(2411,722,229),(2412,722,303),(2410,722,309),(2414,723,229),(2415,723,303),(2413,723,309),(2417,724,229),(2418,724,303),(2416,724,309),(2420,725,229),(2421,725,303),(2419,725,309),(2423,726,229),(2424,726,303),(2422,726,309),(2426,727,229),(2427,727,303),(2425,727,309),(2429,728,229),(2430,728,303),(2428,728,309),(2432,729,229),(2433,729,303),(2431,729,309),(2435,730,229),(2436,730,303),(2434,730,309),(2438,731,229),(2439,731,303),(2437,731,309),(2441,732,229),(2442,732,303),(2440,732,309),(2444,733,229),(2445,733,303),(2443,733,309),(2447,734,229),(2448,734,303),(2446,734,309),(2450,735,229),(2451,735,303),(2449,735,309),(2453,736,229),(2454,736,303),(2452,736,309),(2456,737,229),(2457,737,303),(2455,737,309),(2459,738,229),(2460,738,303),(2458,738,309),(2462,739,229),(2463,739,303),(2461,739,309),(2465,740,229),(2466,740,303),(2464,740,309),(2468,741,229),(2469,741,303),(2467,741,309),(2471,742,229),(2472,742,303),(2470,742,309),(2474,743,229),(2475,743,303),(2473,743,309),(2477,744,229),(2478,744,303),(2476,744,309),(2480,745,229),(2481,745,303),(2479,745,309),(2483,746,229),(2484,746,303),(2482,746,309),(2486,747,229),(2487,747,303),(2485,747,309),(2489,748,229),(2490,748,303),(2488,748,309),(2492,749,229),(2493,749,303),(2491,749,309),(2495,750,229),(2496,750,303),(2494,750,309),(2498,751,229),(2499,751,303),(2497,751,309),(2501,752,229),(2502,752,303),(2500,752,309),(2504,753,229),(2505,753,303),(2503,753,309),(2507,754,229),(2508,754,303),(2506,754,309),(2510,755,229),(2511,755,303),(2509,755,309),(2513,756,229),(2514,756,303),(2512,756,309),(2516,757,229),(2517,757,303),(2515,757,309),(2519,758,229),(2520,758,303),(2518,758,309),(2522,759,229),(2523,759,303),(2521,759,309),(2525,760,229),(2526,760,303),(2524,760,309),(2528,761,229),(2529,761,303),(2527,761,309),(2531,762,229),(2532,762,303),(2530,762,309),(2534,763,229),(2535,763,303),(2533,763,309),(2537,764,229),(2538,764,303),(2536,764,309),(2540,765,229),(2541,765,303),(2539,765,309),(2543,766,167),(2542,766,229),(2545,767,167),(2544,767,229),(2547,768,167),(2546,768,229),(2549,769,229),(2550,769,303),(2548,769,309),(2552,770,229),(2553,770,303),(2551,770,309),(2555,771,229),(2556,771,303),(2554,771,309),(2558,772,229),(2559,772,303),(2557,772,309),(2561,773,229),(2562,773,303),(2560,773,309),(2564,774,229),(2565,774,303),(2563,774,309),(2567,775,229),(2568,775,303),(2566,775,309),(2570,776,229),(2571,776,303),(2569,776,309),(2573,777,229),(2574,777,303),(2572,777,309),(2576,778,229),(2577,778,303),(2575,778,309),(2579,779,229),(2580,779,303),(2578,779,309),(2582,780,229),(2583,780,303),(2581,780,309),(2585,781,229),(2586,781,303),(2584,781,309),(2588,782,229),(2589,782,303),(2587,782,309),(2591,783,229),(2592,783,303),(2590,783,309),(2594,784,229),(2595,784,303),(2593,784,309),(2597,785,229),(2598,785,303),(2596,785,309),(2600,786,229),(2601,786,303),(2599,786,309),(2603,787,229),(2604,787,303),(2602,787,309),(2606,788,229),(2607,788,303),(2605,788,309),(2609,789,229),(2610,789,303),(2608,789,309),(2612,790,229),(2613,790,303),(2611,790,309),(2615,791,229),(2616,791,303),(2614,791,309),(2618,792,229),(2619,792,303),(2617,792,309),(2621,793,229),(2622,793,303),(2620,793,309),(2624,794,229),(2625,794,303),(2623,794,309),(2627,795,229),(2628,795,303),(2626,795,309),(2630,796,229),(2631,796,303),(2629,796,309),(2633,797,229),(2634,797,303),(2632,797,309),(2636,798,229),(2637,798,303),(2635,798,309),(2639,799,229),(2640,799,303),(2638,799,309),(2642,800,229),(2643,800,303),(2641,800,309),(2645,801,229),(2646,801,303),(2644,801,309),(2648,802,229),(2649,802,303),(2647,802,309),(2651,803,229),(2652,803,303),(2650,803,309),(2654,804,229),(2655,804,303),(2653,804,309),(2657,805,229),(2658,805,303),(2656,805,309),(2660,806,229),(2661,806,303),(2659,806,309),(2663,807,229),(2664,807,303),(2662,807,309),(2666,808,229),(2667,808,303),(2665,808,309),(2669,809,229),(2670,809,303),(2668,809,309),(2672,810,229),(2673,810,303),(2671,810,309),(2675,811,229),(2676,811,303),(2674,811,309),(2678,812,229),(2679,812,303),(2677,812,309),(2681,813,229),(2682,813,303),(2680,813,309),(2684,814,229),(2685,814,303),(2683,814,309),(2687,815,229),(2688,815,303),(2686,815,309),(2690,816,303),(2689,816,309),(2692,817,229),(2693,817,303),(2691,817,309),(2695,818,229),(2696,818,303),(2694,818,309),(2698,819,229),(2699,819,303),(2697,819,309),(2701,820,229),(2702,820,303),(2700,820,309),(2704,821,229),(2705,821,303),(2703,821,309),(2707,822,229),(2708,822,303),(2706,822,309),(2710,823,229),(2711,823,303),(2709,823,309),(2713,824,229),(2714,824,303),(2712,824,309),(2716,825,229),(2717,825,303),(2715,825,309),(2719,826,229),(2720,826,303),(2718,826,309),(2722,827,229),(2723,827,303),(2721,827,309),(2725,828,229),(2726,828,303),(2724,828,309),(2728,829,229),(2729,829,303),(2727,829,309),(2731,830,229),(2732,830,303),(2730,830,309),(2734,831,229),(2735,831,303),(2733,831,309),(2737,832,229),(2738,832,303),(2736,832,309),(2740,833,229),(2741,833,303),(2739,833,309),(2743,834,229),(2744,834,303),(2742,834,309),(2746,835,229),(2747,835,303),(2745,835,309),(2749,836,229),(2750,836,303),(2748,836,309),(2752,837,229),(2753,837,303),(2751,837,309),(2755,838,229),(2756,838,303),(2754,838,309),(2758,839,229),(2759,839,303),(2757,839,309),(2761,840,229),(2762,840,303),(2760,840,309),(2764,841,229),(2765,841,303),(2763,841,309),(2767,842,229),(2768,842,303),(2766,842,309),(2770,843,229),(2771,843,303),(2769,843,309),(2773,844,229),(2774,844,303),(2772,844,309),(2776,845,229),(2777,845,303),(2775,845,309),(2779,846,229),(2780,846,303),(2778,846,309),(2782,847,229),(2783,847,303),(2781,847,309),(2785,848,229),(2786,848,303),(2784,848,309),(2788,849,229),(2789,849,303),(2787,849,309),(2791,850,229),(2792,850,303),(2790,850,309),(2794,851,229),(2795,851,303),(2793,851,309),(2797,852,229),(2798,852,303),(2796,852,309),(2800,853,229),(2801,853,303),(2799,853,309),(2803,854,229),(2804,854,303),(2802,854,309),(2806,855,229),(2807,855,303),(2805,855,309),(2810,856,229),(2811,856,303),(2809,856,309),(2813,857,229),(2814,857,303),(2812,857,309),(2816,858,229),(2817,858,303),(2815,858,309),(2819,859,229),(2820,859,303),(2818,859,309),(2822,860,229),(2823,860,303),(2821,860,309),(2825,861,229),(2826,861,303),(2824,861,309),(2828,862,229),(2829,862,303),(2827,862,309),(2831,863,229),(2832,863,303),(2830,863,309),(2834,864,229),(2835,864,303),(2833,864,309),(2837,865,229),(2838,865,303),(2836,865,309),(2840,866,229),(2841,866,303),(2839,866,309),(2843,867,229),(2844,867,303),(2842,867,309),(2846,868,229),(2847,868,303),(2845,868,309),(2849,869,229),(2850,869,303),(2848,869,309),(2852,870,229),(2853,870,303),(2851,870,309),(2855,871,229),(2856,871,303),(2854,871,309),(2858,872,229),(2859,872,303),(2857,872,309),(2861,873,229),(2862,873,303),(2860,873,309),(2864,874,229),(2865,874,303),(2863,874,309),(2867,875,229),(2868,875,303),(2866,875,309),(2870,876,229),(2871,876,303),(2869,876,309),(2873,877,229),(2874,877,303),(2872,877,309),(2876,878,229),(2877,878,303),(2875,878,309),(2879,879,229),(2880,879,303),(2878,879,309),(2882,880,229),(2883,880,303),(2881,880,309),(2885,881,229),(2886,881,303),(2884,881,314),(2888,882,229),(2889,882,303),(2887,882,309),(2891,883,229),(2892,883,303),(2890,883,314),(2894,884,229),(2895,884,303),(2893,884,314),(2897,885,229),(2898,885,303),(2896,885,314),(2900,886,229),(2901,886,303),(2899,886,314),(2903,887,229),(2904,887,303),(2902,887,314),(2906,888,229),(2907,888,303),(2905,888,314),(2909,889,229),(2910,889,303),(2908,889,314),(2912,890,229),(2913,890,303),(2911,890,314),(2915,891,229),(2916,891,303),(2914,891,314),(2918,892,229),(2919,892,303),(2917,892,314),(2922,893,229),(2923,893,303),(2920,893,314),(2925,894,229),(2926,894,303),(2924,894,314),(2928,895,229),(2929,895,303),(2927,895,314),(2931,896,229),(2932,896,303),(2930,896,314),(2934,897,229),(2935,897,303),(2933,897,314),(2937,898,229),(2938,898,303),(2936,898,314),(2940,899,229),(2941,899,303),(2939,899,314),(2943,900,229),(2944,900,303),(2942,900,314),(2946,901,229),(2947,901,303),(2945,901,314),(2949,902,229),(2950,902,303),(2948,902,314),(2952,903,229),(2953,903,303),(2951,903,314),(2955,904,229),(2956,904,303),(2954,904,314),(2958,905,229),(2959,905,303),(2957,905,314),(2961,906,229),(2962,906,303),(2960,906,314),(2964,907,229),(2965,907,303),(2963,907,314),(2967,908,229),(2968,908,303),(2966,908,314),(2970,909,229),(2971,909,303),(2969,909,314),(2973,910,229),(2974,910,303),(2972,910,314),(2976,911,229),(2977,911,303),(2975,911,314),(2979,912,229),(2980,912,303),(2978,912,314),(2982,913,229),(2983,913,303),(2981,913,314),(2985,914,229),(2986,914,303),(2984,914,314),(2988,915,229),(2989,915,303),(2987,915,314),(2991,916,229),(2992,916,303),(2990,916,314),(2994,917,229),(2995,917,303),(2993,917,314),(2997,918,229),(2998,918,303),(2996,918,314),(3000,919,229),(3001,919,303),(2999,919,314),(3003,920,229),(3004,920,303),(3002,920,314),(3006,921,229),(3007,921,303),(3005,921,314),(3009,922,229),(3010,922,303),(3008,922,314),(3012,923,229),(3013,923,303),(3011,923,314),(3015,924,229),(3016,924,303),(3014,924,314),(3018,925,229),(3019,925,303),(3017,925,314),(3021,926,229),(3022,926,303),(3020,926,314),(3024,927,229),(3025,927,303),(3023,927,314),(3027,928,229),(3028,928,303),(3026,928,314),(3030,929,229),(3031,929,303),(3029,929,314),(3033,930,229),(3034,930,303),(3032,930,314),(3036,931,229),(3037,931,303),(3035,931,314),(3039,932,229),(3040,932,303),(3038,932,314),(3042,933,229),(3043,933,303),(3041,933,314),(3045,934,229),(3046,934,303),(3044,934,314),(3048,935,229),(3049,935,303),(3047,935,314),(3051,936,229),(3052,936,303),(3050,936,314),(3054,937,229),(3055,937,303),(3053,937,314),(3057,938,229),(3058,938,303),(3056,938,314),(3060,939,229),(3061,939,303),(3059,939,314),(3063,940,229),(3064,940,303),(3062,940,314),(3066,941,229),(3067,941,303),(3065,941,314),(3069,942,229),(3070,942,303),(3068,942,314),(3072,943,229),(3073,943,303),(3071,943,314),(3075,944,229),(3076,944,303),(3074,944,314),(3078,945,229),(3079,945,303),(3077,945,314),(3081,946,229),(3082,946,303),(3080,946,314),(3084,947,229),(3085,947,303),(3083,947,314),(3088,948,229),(3087,948,303),(3086,948,314),(3090,949,229),(3091,949,303),(3089,949,314),(3093,950,229),(3094,950,303),(3092,950,314),(3096,951,229),(3097,951,303),(3095,951,314),(3099,952,229),(3100,952,303),(3098,952,314),(3102,953,229),(3103,953,303),(3101,953,314),(3105,954,229),(3106,954,303),(3104,954,314),(3108,955,229),(3109,955,303),(3107,955,314),(3111,956,229),(3112,956,303),(3110,956,314),(3114,957,229),(3115,957,303),(3113,957,314),(3120,959,229),(3121,959,303),(3119,959,314),(3123,960,229),(3124,960,303),(3122,960,314),(3126,961,229),(3127,961,303),(3125,961,314),(3129,962,229),(3130,962,303),(3128,962,314),(3132,963,229),(3133,963,303),(3131,963,314),(3135,964,229),(3136,964,303),(3134,964,314),(3138,965,229),(3139,965,303),(3137,965,314),(3141,966,229),(3142,966,303),(3140,966,314),(3144,967,229),(3145,967,303),(3143,967,314),(3147,968,229),(3148,968,303),(3146,968,314),(3150,969,229),(3151,969,303),(3149,969,314),(3153,970,229),(3154,970,303),(3152,970,314),(3156,971,229),(3157,971,303),(3155,971,311),(3159,972,229),(3160,972,303),(3158,972,311),(3162,973,229),(3163,973,303),(3161,973,312),(3166,974,229),(3165,974,303),(3164,974,312),(3168,975,229),(3169,975,303),(3167,975,312),(3171,976,229),(3172,976,303),(3170,976,312),(3174,977,229),(3175,977,303),(3173,977,312),(3177,978,229),(3178,978,303),(3176,978,312),(3180,979,229),(3181,979,303),(3179,979,312),(3183,980,229),(3184,980,303),(3182,980,312),(3186,981,229),(3187,981,303),(3185,981,312),(3189,982,229),(3190,982,303),(3188,982,312),(3192,983,229),(3193,983,303),(3191,983,312),(3195,984,229),(3196,984,303),(3194,984,312),(3198,985,229),(3199,985,303),(3197,985,312),(3201,986,229),(3202,986,303),(3200,986,312),(3204,987,229),(3205,987,303),(3203,987,312),(3207,988,229),(3208,988,303),(3206,988,312),(3210,989,229),(3211,989,303),(3209,989,312),(3213,990,229),(3214,990,303),(3212,990,312),(3216,991,229),(3217,991,303),(3215,991,312),(3219,992,229),(3220,992,303),(3218,992,312),(3222,993,229),(3223,993,303),(3221,993,312),(3225,994,229),(3226,994,303),(3224,994,312),(3228,995,229),(3229,995,303),(3227,995,312),(3231,996,229),(3232,996,303),(3230,996,312),(3234,997,229),(3235,997,303),(3233,997,312),(3237,998,229),(3238,998,303),(3236,998,312),(3240,999,229),(3241,999,303),(3239,999,312),(3243,1000,229),(3244,1000,303),(3242,1000,312),(3246,1001,229),(3247,1001,303),(3245,1001,312),(3249,1002,229),(3250,1002,303),(3248,1002,312),(3252,1003,229),(3253,1003,303),(3251,1003,312),(3255,1004,229),(3256,1004,303),(3254,1004,312),(3258,1005,229),(3259,1005,303),(3257,1005,312),(3261,1006,229),(3262,1006,303),(3260,1006,312),(3267,1008,229),(3268,1008,303),(3266,1008,312),(3270,1009,229),(3271,1009,303),(3269,1009,312),(3273,1010,229),(3274,1010,303),(3272,1010,312),(3276,1011,229),(3277,1011,303),(3275,1011,312),(3279,1012,229),(3280,1012,303),(3278,1012,312),(3282,1013,229),(3283,1013,303),(3281,1013,312),(3288,1015,229),(3287,1015,292),(3290,1016,229),(3289,1016,292),(3292,1017,229),(3291,1017,292),(3297,1019,229),(3296,1019,292),(3299,1020,229),(3298,1020,292),(3301,1021,229),(3300,1021,292),(3303,1022,229),(3302,1022,292),(3304,1023,229),(3305,1023,318),(3306,1024,28),(3307,1024,229),(3308,1025,92),(3309,1025,229),(3310,1026,14),(3311,1026,239),(3312,1027,229),(3313,1027,319),(3314,1028,14),(3315,1028,229),(3316,1028,320),(3317,1029,229),(3318,1030,56),(3319,1030,229),(3320,1031,228),(3321,1032,14),(3322,1032,321),(3323,1033,56),(3325,1033,226),(3324,1033,229),(3326,1034,56),(3328,1034,229),(3327,1034,322),(3330,1035,86),(3329,1035,229),(3331,1036,229),(3332,1037,14),(3537,1037,229),(3333,1038,14),(3334,1038,239),(3335,1039,229),(3336,1039,323),(3337,1039,324),(3340,1040,229),(3338,1040,323),(3339,1040,324),(3342,1041,229),(3341,1041,323),(3344,1042,229),(3345,1042,303),(3343,1042,309),(3347,1043,229),(3348,1043,303),(3346,1043,309),(3350,1044,229),(3351,1044,303),(3349,1044,314),(3353,1045,229),(3354,1045,303),(3352,1045,314),(3356,1046,229),(3357,1046,303),(3355,1046,309),(3359,1047,229),(3360,1047,303),(3358,1047,309),(3362,1048,229),(3363,1048,303),(3361,1048,313),(3365,1049,229),(3366,1049,303),(3364,1049,312),(3368,1050,229),(3369,1050,303),(3367,1050,309),(3371,1051,229),(3372,1051,303),(3370,1051,309),(3374,1052,229),(3375,1052,303),(3373,1052,313),(3377,1053,229),(3378,1053,303),(3376,1053,309),(3380,1054,229),(3381,1054,303),(3379,1054,309),(3382,1055,229),(3383,1055,303),(3384,1056,229),(3385,1056,303),(3386,1057,229),(3387,1057,303),(3388,1058,229),(3389,1058,303),(3390,1059,229),(3391,1059,303),(3392,1060,229),(3393,1060,303),(3394,1061,229),(3395,1061,303),(3396,1062,229),(3397,1062,303),(3398,1063,229),(3399,1063,303),(3400,1064,229),(3401,1064,303),(3402,1065,229),(3403,1065,303),(3404,1066,229),(3405,1066,303),(3406,1067,229),(3407,1067,303),(3408,1068,229),(3409,1068,303),(3410,1069,229),(3411,1069,303),(3412,1070,229),(3413,1070,303),(3414,1071,229),(3415,1071,303),(3416,1072,229),(3417,1072,303),(3418,1073,229),(3419,1073,303),(3420,1074,229),(3421,1074,303),(3422,1075,229),(3423,1075,303),(3425,1076,229),(3426,1076,303),(3424,1076,312),(3428,1077,229),(3429,1077,303),(3427,1077,312),(3431,1078,229),(3432,1078,303),(3430,1078,312),(3434,1079,229),(3435,1079,303),(3433,1079,309),(3437,1080,229),(3438,1080,303),(3436,1080,309),(3440,1081,229),(3441,1081,303),(3446,1081,314),(3448,1083,229),(3449,1083,303),(3447,1083,314),(3451,1084,229),(3452,1084,303),(3450,1084,312),(3454,1085,229),(3455,1085,303),(3453,1085,309),(3457,1086,229),(3458,1086,303),(3456,1086,309),(3460,1087,229),(3461,1087,303),(3459,1087,309),(3463,1088,229),(3464,1088,303),(3462,1088,309),(3466,1089,229),(3467,1089,303),(3465,1089,309),(3469,1090,229),(3470,1090,303),(3468,1090,314),(3472,1091,229),(3473,1091,303),(3471,1091,314),(3475,1092,229),(3476,1092,303),(3474,1092,314),(3478,1093,229),(3479,1093,303),(3477,1093,312),(3481,1094,229),(3482,1094,303),(3480,1094,312),(3484,1095,229),(3485,1095,303),(3483,1095,312),(3487,1096,229),(3488,1096,303),(3486,1096,309),(3490,1097,229),(3491,1097,303),(3489,1097,312),(3493,1098,229),(3494,1098,303),(3492,1098,312),(3496,1099,229),(3497,1099,303),(3495,1099,312),(3498,1100,229),(3500,1100,303),(3499,1100,310),(3501,1101,229),(3503,1101,303),(3502,1101,310),(3504,1102,229),(3506,1102,303),(3505,1102,310),(3508,1103,229),(3509,1103,303),(3510,1103,310),(3512,1104,246),(3511,1104,252),(3513,1104,303),(3515,1105,246),(3514,1105,252),(3516,1105,303),(3518,1106,246),(3517,1106,252),(3519,1106,303),(3521,1107,246),(3520,1107,257),(3522,1107,303),(3524,1108,229),(3523,1108,325),(3526,1109,229),(3525,1109,325),(3528,1110,229),(3527,1110,325),(3530,1111,229),(3529,1111,325),(3532,1112,229),(3531,1112,325),(3534,1113,228),(3533,1113,326),(3536,1114,86),(3535,1114,229),(3539,1115,229),(3538,1115,292),(3541,1116,229),(3540,1116,292),(3543,1117,229),(3542,1117,292),(3545,1118,229),(3544,1118,292),(3547,1119,229),(3546,1119,292),(3549,1120,229),(3548,1120,292),(3551,1121,229),(3550,1121,292),(3553,1122,229),(3552,1122,292),(3555,1123,229),(3554,1123,292),(3557,1124,229),(3556,1124,292),(3559,1125,229),(3558,1125,292),(3561,1126,229),(3560,1126,292),(3563,1127,229),(3562,1127,292),(3565,1128,229),(3564,1128,292),(3567,1129,229),(3566,1129,292),(3569,1130,229),(3568,1130,292),(3571,1131,229),(3570,1131,292),(3573,1132,229),(3572,1132,292),(3575,1133,229),(3574,1133,292),(3577,1134,229),(3576,1134,292),(3579,1135,229),(3578,1135,292),(3581,1136,229),(3580,1136,292),(3583,1137,229),(3582,1137,292),(3585,1138,229),(3584,1138,292),(3587,1139,229),(3586,1139,292),(3589,1140,229),(3588,1140,292),(3591,1141,229),(3590,1141,292),(3593,1142,229),(3592,1142,292),(3595,1143,229),(3594,1143,292),(3597,1144,229),(3596,1144,292),(3599,1145,229),(3598,1145,292),(3601,1146,229),(3600,1146,292),(3603,1147,229),(3602,1147,292),(3605,1148,229),(3604,1148,292),(3607,1149,229),(3606,1149,292),(3611,1151,229),(3610,1151,317),(3613,1152,229),(3612,1152,317),(3615,1153,229),(3614,1153,317),(3617,1154,229),(3616,1154,317),(3619,1155,229),(3618,1155,317),(3621,1156,229),(3620,1156,317),(3623,1157,229),(3622,1157,317),(3625,1158,229),(3624,1158,317),(3627,1159,229),(3626,1159,317),(3629,1160,229),(3628,1160,317),(3631,1161,229),(3630,1161,317),(3633,1162,229),(3632,1162,317),(3635,1163,229),(3634,1163,317),(3637,1164,229),(3636,1164,317),(3639,1165,229),(3638,1165,317),(3641,1166,229),(3640,1166,317),(3643,1167,229),(3642,1167,317),(3645,1168,229),(3644,1168,317),(3647,1169,229),(3646,1169,317),(3649,1170,229),(3648,1170,317),(3660,1171,229),(3650,1171,317),(3652,1172,229),(3651,1172,317),(3654,1173,229),(3653,1173,317),(3655,1174,317),(3657,1175,229),(3656,1175,317),(3659,1176,229),(3658,1176,317),(3662,1177,229),(3661,1177,317),(3664,1178,229),(3663,1178,317),(3666,1179,229),(3665,1179,317),(3668,1180,229),(3667,1180,317),(3670,1181,229),(3669,1181,317),(3672,1182,229),(3671,1182,317),(3674,1183,229),(3673,1183,317),(3676,1184,229),(3675,1184,317),(3678,1185,229),(3677,1185,317),(3680,1186,229),(3679,1186,317),(3682,1187,229),(3681,1187,317),(3684,1188,229),(3683,1188,317),(3686,1189,229),(3685,1189,317),(3688,1190,229),(3687,1190,317),(3690,1191,229),(3689,1191,317),(3692,1192,229),(3691,1192,317),(3694,1193,229),(3693,1193,317),(3696,1194,229),(3695,1194,317),(3698,1195,229),(3697,1195,317),(3700,1196,229),(3699,1196,317),(3701,1197,317),(3703,1198,229),(3702,1198,317),(3705,1199,229),(3704,1199,317),(3707,1200,229),(3706,1200,317),(3709,1201,229),(3708,1201,317),(3711,1202,229),(3710,1202,317),(3713,1203,229),(3712,1203,317),(3715,1204,229),(3714,1204,317),(3717,1205,229),(3716,1205,317),(3719,1206,229),(3718,1206,317),(3721,1207,229),(3720,1207,317),(3723,1208,229),(3722,1208,317),(3725,1209,229),(3724,1209,317),(3727,1210,229),(3726,1210,317),(3729,1211,229),(3728,1211,317),(3731,1212,229),(3730,1212,317),(3733,1213,229),(3732,1213,317),(3735,1214,229),(3734,1214,317),(3737,1215,229),(3736,1215,317),(3739,1216,229),(3738,1216,317),(3741,1217,229),(3740,1217,317),(3743,1218,229),(3742,1218,317),(3745,1219,229),(3744,1219,317),(3747,1220,229),(3746,1220,317),(3749,1221,229),(3748,1221,317),(3751,1222,229),(3750,1222,317),(3753,1223,229),(3752,1223,317),(3755,1224,229),(3754,1224,317),(3757,1225,229),(3756,1225,317),(3759,1226,229),(3758,1226,317),(3761,1227,229),(3760,1227,317),(3763,1228,229),(3762,1228,317),(3765,1229,229),(3764,1229,317),(3767,1230,229),(3766,1230,317),(3769,1231,229),(3768,1231,317),(3771,1232,229),(3770,1232,317),(3773,1233,229),(3772,1233,317),(3775,1234,229),(3774,1234,317),(3777,1235,229),(3776,1235,317),(3779,1236,229),(3778,1236,317),(3781,1237,229),(3780,1237,317),(3783,1238,229),(3782,1238,317),(3785,1239,229),(3784,1239,317),(3787,1240,229),(3786,1240,317),(3789,1241,229),(3788,1241,317),(3791,1242,229),(3790,1242,317),(3793,1243,229),(3792,1243,317),(3795,1244,229),(3794,1244,317),(3797,1245,229),(3796,1245,317),(3799,1246,229),(3798,1246,317),(3801,1247,229),(3800,1247,317),(3803,1248,229),(3802,1248,317),(3805,1249,229),(3804,1249,317),(3807,1250,229),(3806,1250,317),(3809,1251,229),(3808,1251,317),(3811,1252,229),(3810,1252,317),(3813,1253,229),(3812,1253,317),(3815,1254,229),(3814,1254,317),(3817,1255,229),(3816,1255,317),(3819,1256,229),(3818,1256,317),(3821,1257,229),(3820,1257,317),(3823,1258,229),(3822,1258,317),(3825,1259,229),(3824,1259,317),(3827,1260,229),(3826,1260,317),(3829,1261,229),(3828,1261,317),(3831,1262,229),(3830,1262,317),(3833,1263,229),(3832,1263,317),(3835,1264,229),(3834,1264,317),(3837,1265,229),(3836,1265,317),(3839,1266,229),(3838,1266,317),(3841,1267,229),(3840,1267,317),(3843,1268,229),(3842,1268,317),(3845,1269,229),(3844,1269,317),(3847,1270,229),(3846,1270,317),(3849,1271,229),(3848,1271,317),(3851,1272,229),(3850,1272,317),(3852,1273,229),(3853,1273,319),(3854,1274,229),(3855,1274,319),(3856,1275,229),(3857,1275,319),(3858,1276,229),(3859,1276,319),(3860,1277,229),(3861,1277,319),(3862,1278,229),(3863,1278,319),(3864,1279,229),(3865,1279,319),(3866,1280,59),(3867,1280,229),(3868,1281,59),(3869,1281,327),(3870,1282,229),(3871,1282,319),(3873,1283,28),(3872,1283,32),(3874,1283,229),(3875,1284,10),(3876,1284,28),(3877,1284,229),(3879,1285,28),(3878,1285,33),(3880,1285,229),(3881,1286,229),(3882,1286,328),(3883,1287,45),(3884,1287,229),(3885,1288,59),(3886,1288,229),(3888,1289,229),(3887,1289,328),(3889,1290,229),(3890,1290,329),(3891,1291,45),(3892,1291,229),(3893,1292,229),(3894,1292,330),(3896,1293,229),(3895,1293,330),(3898,1294,229),(3897,1294,330),(3899,1295,330),(3901,1296,229),(3900,1296,330),(3903,1297,45),(3902,1297,290),(3904,1298,229),(3906,1299,229),(3905,1299,328),(3907,1300,229),(3908,1300,319),(3909,1301,229),(3910,1301,319),(3912,1302,229),(3911,1302,331),(3914,1303,229),(3913,1303,331),(3916,1304,229),(3915,1304,331),(3917,1305,229),(3918,1305,332),(3920,1306,229),(3919,1306,333),(3922,1307,229),(3921,1307,333);

--
-- Table structure for table `produse_unitatemasura`
--

CREATE TABLE `produse_unitatemasura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nume` (`nume`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `produse_unitatemasura`
--

INSERT INTO `produse_unitatemasura` VALUES (36,'Bax'),(32,'Bidon'),(8,'Bucata'),(19,'Cartus'),(34,'Cutie'),(21,'Cutie - 6 buc'),(42,'Flacon pulbere'),(29,'Flacon solutie'),(18,'Folie'),(35,'Kit'),(37,'Punga'),(41,'Rola'),(31,'Seringa'),(38,'Set'),(33,'Tub');

--
-- Table structure for table `produse_valoarefiltru`
--

CREATE TABLE `produse_valoarefiltru` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filtru_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `produse_valoarefiltru_filtru_id_5a1fd205_fk_produse_filtru_id` (`filtru_id`),
  CONSTRAINT `produse_valoarefiltru_filtru_id_5a1fd205_fk_produse_filtru_id` FOREIGN KEY (`filtru_id`) REFERENCES `produse_filtru` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=334 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `produse_valoarefiltru`
--

INSERT INTO `produse_valoarefiltru` VALUES (10,'Rosu',8),(11,'Negru',8),(12,'Verde',8),(14,'Dr Mayer',9),(18,'Mov',8),(23,'S',17),(24,'XS',17),(25,'M',17),(26,'L',17),(27,'Vita 3D Master',9),(28,'VDW',9),(31,'Roz',8),(32,'Gri',8),(33,'Galben',8),(34,'Albastru',8),(40,'Dentsply',9),(41,'Zhermack',9),(45,'Coltene',9),(46,'Alb',8),(48,'Centrix',9),(51,'Inibsa Dental',9),(52,'Dr Protect',9),(54,'Heraeus Kulzer',9),(56,'OCC',9),(58,'Septodont',9),(59,'Cerkamed',9),(63,'GC',9),(65,'1 L',18),(73,'Kerr',9),(74,'1 kg',18),(78,'Spident',9),(80,'Dorident',9),(81,'30 gr',18),(82,'38 gr',18),(84,'300 gr',18),(85,'EMS',9),(86,'NSK',9),(90,'500 gr',18),(91,'15 gr',18),(92,'Meta Biomed',9),(94,'3M',9),(97,'UltraDent',9),(100,'Angelus',9),(102,'Roeko',9),(103,'20 gr',18),(104,'130 gr',18),(105,'Pentron',9),(106,'Oral B',9),(107,'Megagen',9),(108,'4.7 gr',18),(109,'1.5 gr',18),(110,'Voco',9),(111,'2 gr',18),(112,'4 gr',18),(113,'2.3 gr',18),(116,'Nordiska',9),(118,'DMG',9),(119,'76 gr',18),(135,'6,5',17),(136,'7',17),(137,'8',17),(138,'3.4 gr',18),(143,'900 gr',18),(146,'CareLife',9),(149,'5 gr',18),(150,'DLS',9),(151,'1 gr',18),(152,'50 gr',18),(156,'13.5 gr',18),(159,'Kenda',9),(164,'Microdont',9),(165,'7.8 gr',18),(166,'Tor VM',9),(167,'Purgo',9),(169,'Hygitech',9),(171,'No Name',9),(172,'Itena',9),(173,'Woodpecker',9),(174,'Fanta Dental',9),(175,'Hahnenkratt',9),(176,'Geistlich Biomaterials',9),(177,'OsteoBiol by Technoss Dental',9),(178,'100 gr',18),(180,'Botiss Dental',9),(181,'Ivoclar',9),(184,'5 ml',30),(185,'10 ml',30),(186,'3 ml',30),(187,'1 ml',30),(188,'0.3 ml',30),(199,'1.2 ml',30),(207,'2 ml',30),(208,'4 ml',30),(213,'15 ml',30),(214,'20 ml',30),(215,'50 ml',30),(216,'100 ml',30),(217,'140 ml',30),(218,'200 ml',30),(219,'300 ml',30),(220,'35 ml',30),(221,'400 ml',30),(222,'60 ml',30),(223,'45 ml',30),(224,'750 ml',30),(225,'900 ml',30),(226,'5 L',30),(227,'23.8 ml',30),(228,'100 buc',31),(229,'1 buc',31),(231,'2 buc',31),(235,'10 buc',31),(236,'12 buc',31),(237,'120 buc',31),(238,'20 buc',31),(239,'200 buc',31),(240,'25 buc',31),(241,'3 buc',31),(242,'32 buc',31),(243,'36 buc',31),(244,'50 buc',31),(245,'500 buc',31),(246,'6 buc',31),(247,'60 buc',31),(248,'80 buc',31),(249,'910 ml',30),(250,'1 L',30),(251,'12 mm (L)',33),(252,'25 mm (L)',33),(253,'38 mm (L)',33),(254,'0.3 mm (G)',34),(255,'0.4 mm (G)',34),(256,'19 mm (L)',33),(257,'21 mm (L)',33),(258,'31 mm (L)',33),(259,'17 mm (L)',33),(273,'Material amprenta',40),(274,'Obturatie canal',40),(280,'K-file',41),(281,'H-file',41),(282,'Tire Nerf',41),(283,'6.8 ml',30),(284,'35 gr',18),(285,'6.4 ml',30),(286,'0.33 gr',18),(287,'8 ml',30),(288,'3 gr',18),(289,'13 gr',18),(290,'1 kit',31),(291,'11 gr',18),(292,'Straumann BLX',9),(294,'9.2 gr',18),(295,'18 mm (L)',33),(296,'16 mm (L)',33),(297,'22 mm (L)',33),(298,'12 ml',30),(299,'33 gr',18),(300,'Prevest',9),(301,'12 gr',18),(303,'Edenta Dental',9),(309,'freza diamantata',38),(310,'freza chirurgie',38),(311,'freza ortodontie',38),(312,'polipant',38),(313,'freza endodontie',38),(314,'freza extradura',38),(315,'12.7 mm (G)',34),(316,'9.5 mm (G)',34),(317,'Straumann NeoDent',9),(318,'TPC',9),(319,'Medenta',9),(320,'500 ml',30),(321,'1000 buc',31),(322,'2 L',30),(323,'Detax',9),(324,'25 gr',18),(325,'Hu-Friedy',9),(326,'ErKodent',9),(327,'5 buc',31),(328,'LM Dental',9),(329,'Larident',9),(330,'Directa',9),(331,'Stoma',9),(332,'Duo Quattro',9),(333,'Medesy',9);

--
-- Table structure for table `sedii`
--

CREATE TABLE `sedii` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_firma` int(11) NOT NULL,
  `id_judet` int(11) NOT NULL,
  `id_oras` int(11) NOT NULL,
  `flag_dental_clone` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `implanturi` varchar(255) DEFAULT NULL,
  `ceramica` varchar(255) DEFAULT NULL,
  `scanner` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `amprenta` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(150) NOT NULL,
  `strada` varchar(150) NOT NULL,
  `nr_strada` varchar(10) NOT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `lat` decimal(18,16) NOT NULL DEFAULT 0.0000000000000000,
  `lng` decimal(18,16) NOT NULL DEFAULT 0.0000000000000000,
  `zoom` tinyint(4) NOT NULL DEFAULT 7,
  `uid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_firma` (`id_firma`),
  KEY `id_judet` (`id_judet`),
  KEY `id_oras` (`id_oras`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sedii`
--

INSERT INTO `sedii` VALUES (6,2,23,6907,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Pitesti','NEGRU VODĂ','4','0348434436',44.8628882493922060,24.8652201890945470,17,'7fd6fcda-ecbb-4c0c-98e3-64fe5d534d67'),(7,2,27,8544,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Valcea','Stirbei Voda','7','',45.1026531340484950,24.3589049577713050,17,'3a539bb6-0175-45e8-bff3-7d15c8e19267'),(12,5,9,2715,1,'','',0,0,'Sediu Bucuresti 2','Aleea Alexandru','21','',44.4565325144233800,26.0893481969833370,17,'f6b55cb7-ccd0-4fec-9884-59f4e7e8296e'),(15,2,42,13361,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Slatina','Una','10','',44.4305524731604960,24.3610508626084600,17,'adf9f4fb-d4b5-4840-ba7f-2e846a812174');

--
-- Table structure for table `stoc_gestiune`
--

CREATE TABLE `stoc_gestiune` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nume` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `added` datetime(6) NOT NULL,
  `fakeuser_id` int(11) NOT NULL,
  `location_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stoc_gestiune_location_id_fakeuser_id_25e8ec8d_uniq` (`location_id`,`fakeuser_id`),
  UNIQUE KEY `slug` (`slug`),
  KEY `stoc_gestiune_fakeuser_id_d9c1fbb3_fk_auth_user_id` (`fakeuser_id`),
  CONSTRAINT `stoc_gestiune_fakeuser_id_d9c1fbb3_fk_auth_user_id` FOREIGN KEY (`fakeuser_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `stoc_gestiune_location_id_9f78ae89_fk_user_locations_id` FOREIGN KEY (`location_id`) REFERENCES `user_locations` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_gestiune`
--

INSERT INTO `stoc_gestiune` VALUES (46,'Receptie Pitesti','receptie-pitesti','2021-06-14 08:08:07.541815',529,28),(47,'Curatenie Pitesti','curatenie-pitesti','2021-06-14 08:11:35.855513',530,28),(49,'Receptie Rm Valcea','receptie-rm-valcea','2021-06-14 08:12:16.243298',532,29),(55,'Curatenie Rm Valcea','curatenie-rm-valcea','2021-06-14 08:20:00.328201',538,29),(56,'Cabinet_01 - Slatina','cabinet_01-slatina','2021-10-08 08:31:06.386227',539,30),(57,'Cabinet_02 - Slatina','cabinet_02-slatina','2021-10-08 08:31:28.444098',540,30),(58,'Cabinet_03 - Slatina','cabinet_03-slatina','2021-10-08 08:32:02.291098',541,30),(59,'Cabinet_04 - Slatina','cabinet_04-slatina','2021-10-08 08:32:09.261296',542,30),(60,'Cabinet_05 - Slatina','cabinet_05-slatina','2021-10-08 08:32:33.918258',543,30),(63,'Cabinet_01 - Rm Valcea','cabinet_01-rm-valcea','2021-10-15 09:24:33.306492',557,29),(64,'Cabinet_02 - Rm Valcea','cabinet_02-rm-valcea','2021-10-15 09:24:38.066378',558,29),(65,'Cabinet_03 - Rm Valcea','cabinet_03-rm-valcea','2021-10-15 09:24:43.048887',559,29),(66,'Cabinet_04 - Rm Valcea','cabinet_04-rm-valcea','2021-10-15 09:24:47.682281',560,29),(67,'Cabinet_05 - Rm Valcea','cabinet_05-rm-valcea','2021-10-15 09:24:51.645986',561,29),(68,'Cabinet_01 - Pitesti','cabinet_01-pitesti','2021-10-15 09:27:23.188657',564,28),(69,'Cabinet_02 - Pitesti','cabinet_02-pitesti','2021-10-15 09:27:27.820899',565,28),(70,'Cabinet_03 - Pitesti','cabinet_03-pitesti','2021-10-15 09:27:32.027319',566,28),(71,'Cabinet_04 - Pitesti','cabinet_04-pitesti','2021-10-15 09:27:37.027587',567,28),(72,'Cabinet_05 - Pitesti','cabinet_05-pitesti','2021-10-15 09:27:46.255206',568,28),(73,'Cabinet_06 - Pitesti','cabinet_06-pitesti','2021-10-15 09:27:56.058417',569,28),(74,'Cabinet_07 - Pitesti','cabinet_07-pitesti','2021-10-15 09:28:01.259445',570,28),(75,'Cabinet_08 - Pitesti','cabinet_08-pitesti','2021-10-15 09:28:05.319559',571,28),(76,'Cabinet_09 - Pitesti','cabinet_09-pitesti','2021-10-15 09:28:20.742794',572,28),(77,'Cabinet_10 - Pitesti','cabinet_10-pitesti','2021-10-15 09:28:25.639857',573,28),(78,'Cabinet_11 - Pitesti','cabinet_11-pitesti','2021-10-15 09:28:30.416569',574,28),(80,'Radiologie Slatina','radiologie-slatina','2021-10-15 09:30:35.349447',580,30),(81,'Radiologie Rm Valcea','radiologie-rm-valcea','2021-10-15 09:31:11.030649',582,29),(82,'Radiologie Pitesti','radiologie-pitesti','2021-10-15 09:31:33.315003',583,28),(83,'Sterilizare Pitesti','sterilizare-pitesti','2021-10-15 12:48:17.732861',584,28),(84,'Sterilizare Slatina','sterilizare-slatina','2021-10-15 12:48:27.546226',585,30),(85,'Sterilizare Rm Valcea','sterilizare-rm-valcea','2021-10-15 12:48:38.149784',586,29),(86,'Cabinet_01_Targoviste','cabinet_01_targoviste','2021-12-30 08:20:46.920277',609,32),(87,'Radiologie_Targoviste','radiologie_targoviste','2021-12-30 08:21:15.591818',610,32),(88,'Sterilizare_Targoviste','sterilizare_targoviste','2021-12-30 08:21:38.973641',611,32),(89,'Cabinet_01_Bucuresti1','cabinet_01_bucuresti1','2021-12-30 08:22:00.852902',612,31),(90,'Radiologie_Bucuresti1','radiologie_bucuresti1','2021-12-30 08:22:17.906494',613,31),(91,'Sterilizare_Bucuresti1','sterilizare_bucuresti1','2021-12-30 08:22:32.398771',614,31);

--
-- Table structure for table `stoc_stoclog`
--

CREATE TABLE `stoc_stoclog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantitate` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `comandarow_id` int(11) DEFAULT NULL,
  `facturarow_id` int(11) DEFAULT NULL,
  `produs_id` int(11) NOT NULL,
  `positive` tinyint(1) NOT NULL,
  `returrow_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stoc_stoclog_facturarow_id_comandarow_98391c2a_uniq` (`facturarow_id`,`comandarow_id`,`produs_id`,`positive`,`returrow_id`),
  KEY `stoc_stoclog_comandarow_id_f0873798_fk_comanda_comandarecord_id` (`comandarow_id`),
  KEY `stoc_stoclog_produs_id_5faad233_fk_produse_produs_id` (`produs_id`),
  KEY `stoc_stoclog_facturarow_id_d20cf823` (`facturarow_id`),
  KEY `stoc_stoclog_returrow_id_3493eeb1_fk_stoc_stoc` (`returrow_id`),
  CONSTRAINT `stoc_stoclog_comandarow_id_f0873798_fk_comanda_comandarecord_id` FOREIGN KEY (`comandarow_id`) REFERENCES `comanda_comandarecord` (`id`),
  CONSTRAINT `stoc_stoclog_facturarow_id_d20cf823_fk_factura_facturarecord_id` FOREIGN KEY (`facturarow_id`) REFERENCES `factura_facturarecord` (`id`),
  CONSTRAINT `stoc_stoclog_produs_id_5faad233_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`),
  CONSTRAINT `stoc_stoclog_returrow_id_3493eeb1_fk_stoc_stoc` FOREIGN KEY (`returrow_id`) REFERENCES `stoc_stocrecorduserrebate` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=503 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stoclog`
--

INSERT INTO `stoc_stoclog` VALUES (317,1,'2021-06-03 15:47:17.779703',NULL,NULL,288,1,NULL),(318,2,'2021-06-03 15:47:17.789332',NULL,NULL,85,1,NULL),(319,-2,'2021-06-03 15:47:27.402530',283,NULL,85,0,NULL),(320,-1,'2021-06-03 15:47:29.758786',282,NULL,288,0,NULL),(321,10,'2021-06-03 16:06:16.092817',NULL,150,20,1,NULL),(322,-10,'2021-06-03 16:06:23.898430',285,NULL,20,0,NULL),(323,3,'2021-06-11 11:42:28.303321',NULL,151,83,1,NULL),(324,12,'2021-06-11 11:42:28.337305',NULL,NULL,241,1,NULL),(325,-3,'2021-06-11 11:44:00.440175',292,NULL,83,0,NULL),(326,-12,'2021-06-11 11:44:41.407537',293,NULL,241,0,NULL),(327,1,'2021-06-11 11:48:08.979181',NULL,NULL,83,1,32),(328,-2,'2021-06-11 11:50:52.128286',297,NULL,83,0,NULL),(329,-12,'2021-06-14 08:41:58.173876',NULL,NULL,241,0,NULL),(330,12,'2021-06-14 08:50:34.685356',NULL,153,339,1,NULL),(331,3,'2021-06-14 08:50:34.685798',NULL,154,63,1,NULL),(332,-1,'2021-06-14 08:56:38.133266',298,NULL,63,0,NULL),(333,-2,'2021-06-14 09:57:58.489750',309,NULL,63,0,NULL),(334,-12,'2021-06-14 09:58:00.681287',308,NULL,339,0,NULL),(335,1,'2021-06-14 12:01:22.021361',NULL,NULL,351,1,NULL),(336,-1,'2021-06-14 12:01:45.034529',310,NULL,351,0,NULL),(337,-1,'2021-06-14 12:05:40.588780',NULL,NULL,351,0,NULL),(340,24,'2021-06-14 12:17:23.780897',NULL,157,339,1,NULL),(341,4,'2021-06-14 12:17:23.829413',NULL,158,83,1,NULL),(342,4,'2021-06-14 12:17:23.830666',NULL,159,63,1,NULL),(343,-4,'2021-06-14 12:29:13.889379',313,NULL,63,0,NULL),(344,-1,'2021-06-14 12:29:13.911139',306,NULL,63,0,NULL),(345,-4,'2021-06-14 12:29:23.163389',312,NULL,83,0,NULL),(346,-1,'2021-06-14 12:29:23.164843',307,NULL,83,0,NULL),(347,-24,'2021-06-14 12:29:25.765610',311,NULL,339,0,NULL),(348,4,'2021-06-14 12:54:03.615045',NULL,160,316,1,NULL),(349,2,'2021-06-14 12:54:03.664280',NULL,161,105,1,NULL),(350,2,'2021-06-14 12:54:03.670251',NULL,162,107,1,NULL),(351,5,'2021-06-14 12:54:03.734969',NULL,163,170,1,NULL),(352,12,'2021-06-14 12:54:03.755123',NULL,164,169,1,NULL),(353,-5,'2021-06-14 12:56:42.961356',318,NULL,170,0,NULL),(354,-1,'2021-06-14 12:56:42.963812',290,NULL,170,0,NULL),(355,-4,'2021-06-14 12:57:03.050719',314,NULL,316,0,NULL),(356,-2,'2021-06-14 12:57:06.985589',315,NULL,105,0,NULL),(357,-2,'2021-06-14 12:57:19.180536',317,NULL,107,0,NULL),(358,-12,'2021-06-14 12:57:24.560253',316,NULL,169,0,NULL),(362,21,'2021-06-15 06:32:06.151749',NULL,165,329,1,NULL),(363,4,'2021-06-15 06:32:06.205678',NULL,166,328,1,NULL),(364,3,'2021-06-15 06:32:06.208341',NULL,167,84,1,NULL),(365,3,'2021-06-15 06:32:06.236888',NULL,168,100,1,NULL),(366,-4,'2021-06-15 06:34:29.774576',324,NULL,328,0,NULL),(367,-21,'2021-06-15 06:34:34.335307',323,NULL,329,0,NULL),(368,-3,'2021-06-15 06:34:51.135368',326,NULL,100,0,NULL),(369,-3,'2021-06-15 06:35:34.486130',325,NULL,84,0,NULL),(370,1,'2021-06-17 08:47:14.864307',NULL,169,357,1,NULL),(371,-1,'2021-06-17 08:47:38.374740',327,NULL,357,0,NULL),(372,10,'2021-06-17 08:52:46.960085',NULL,170,328,1,NULL),(373,10,'2021-06-17 08:52:47.005213',NULL,171,329,1,NULL),(374,75,'2021-06-17 08:52:47.018937',NULL,172,358,1,NULL),(375,-10,'2021-06-17 08:53:23.937112',328,NULL,328,0,NULL),(376,-10,'2021-06-17 08:53:26.076349',329,NULL,329,0,NULL),(377,-75,'2021-06-17 08:53:27.825711',330,NULL,358,0,NULL),(378,5,'2021-06-17 10:46:43.010990',NULL,173,359,1,NULL),(379,2,'2021-06-17 10:46:43.077043',NULL,174,361,1,NULL),(380,5,'2021-06-17 10:46:43.078023',NULL,175,360,1,NULL),(381,3,'2021-06-17 10:46:43.130094',NULL,176,362,1,NULL),(382,4,'2021-06-17 10:46:43.234589',NULL,177,69,1,NULL),(383,2,'2021-06-17 10:46:43.250115',NULL,178,301,1,NULL),(384,1,'2021-06-17 11:00:05.252747',NULL,NULL,363,1,NULL),(385,-1,'2021-06-17 11:09:18.526380',NULL,180,363,0,NULL),(386,-5,'2021-06-17 12:55:52.961940',331,NULL,359,0,NULL),(387,1,'2021-06-24 06:48:57.120571',NULL,181,99,1,NULL),(388,1,'2021-06-24 06:48:57.180045',NULL,182,253,1,NULL),(389,3,'2021-06-24 06:48:57.181555',NULL,183,193,1,NULL),(390,1,'2021-06-24 06:48:57.292450',NULL,184,192,1,NULL),(391,1,'2021-06-24 06:48:57.292584',NULL,185,177,1,NULL),(392,1,'2021-06-24 07:01:35.708547',NULL,186,203,1,NULL),(393,1,'2021-06-24 07:01:35.734965',NULL,187,104,1,NULL),(394,1,'2021-06-24 07:01:35.736150',NULL,188,113,1,NULL),(395,5,'2021-06-24 07:01:35.839203',NULL,189,84,1,NULL),(396,12,'2021-06-24 07:01:35.868333',NULL,190,339,1,NULL),(397,1,'2021-06-24 07:01:35.870548',NULL,191,259,1,NULL),(398,1,'2021-06-24 07:01:35.938408',NULL,192,256,1,NULL),(399,2,'2021-06-24 07:01:35.957843',NULL,193,101,1,NULL),(400,1,'2021-06-24 07:01:35.971514',NULL,194,210,1,NULL),(401,1,'2021-06-24 07:01:36.045861',NULL,195,330,1,NULL),(402,1,'2021-06-24 07:01:36.068522',NULL,196,193,1,NULL),(403,1,'2021-06-24 07:08:01.222918',NULL,197,124,1,NULL),(404,1,'2021-06-24 07:20:56.867523',NULL,198,29,1,NULL),(405,1,'2021-06-24 07:20:56.870787',NULL,199,25,1,NULL),(406,1,'2021-06-24 07:20:56.946580',NULL,200,31,1,NULL),(407,1,'2021-06-24 07:25:51.736564',NULL,201,104,1,NULL),(408,-1,'2021-06-24 07:54:31.762373',343,NULL,31,0,NULL),(409,-1,'2021-06-24 07:54:34.077817',339,NULL,29,0,NULL),(410,-1,'2021-06-24 07:54:39.012877',342,NULL,25,0,NULL),(411,-1,'2021-06-24 07:54:43.562609',338,NULL,104,0,NULL),(412,-1,'2021-06-24 07:54:45.228743',344,NULL,192,0,NULL),(413,-1,'2021-06-24 07:54:47.404026',337,NULL,99,0,NULL),(414,-1,'2021-06-24 07:54:49.251715',345,NULL,177,0,NULL),(415,-1,'2021-06-24 07:54:51.091536',346,NULL,253,0,NULL),(416,-1,'2021-06-24 07:54:52.651590',340,NULL,124,0,NULL),(417,1,'2021-06-24 08:34:31.763930',NULL,202,370,1,NULL),(418,1,'2021-06-24 08:39:15.142582',NULL,203,335,1,NULL),(419,-1,'2021-06-24 08:41:32.794369',347,NULL,370,0,NULL),(420,5,'2021-06-24 09:02:12.874970',NULL,204,169,1,NULL),(421,1,'2021-06-24 09:02:12.898569',NULL,205,170,1,NULL),(422,10,'2021-06-24 09:08:00.522611',NULL,206,349,1,NULL),(423,6,'2021-06-24 09:08:00.640267',NULL,207,350,1,NULL),(424,1,'2021-06-24 09:08:00.668232',NULL,208,76,1,NULL),(425,2,'2021-06-24 09:08:00.709364',NULL,209,111,1,NULL),(426,1,'2021-06-24 09:08:00.823986',NULL,210,64,1,NULL),(427,1,'2021-06-24 09:13:00.684522',NULL,211,154,1,NULL),(428,2,'2021-06-24 09:20:42.516719',NULL,212,382,1,NULL),(429,1,'2021-06-24 09:20:42.537420',NULL,213,381,1,NULL),(430,-1,'2021-06-24 09:24:14.902433',349,NULL,381,0,NULL),(431,-2,'2021-06-24 09:24:17.497671',348,NULL,382,0,NULL),(432,1,'2021-06-24 10:32:02.715344',NULL,214,205,1,NULL),(433,4,'2021-06-24 10:32:02.745344',NULL,215,378,1,NULL),(434,2,'2021-06-24 10:32:02.753706',NULL,216,380,1,NULL),(435,2,'2021-06-24 10:32:02.816986',NULL,217,379,1,NULL),(436,2,'2021-06-24 10:32:02.831429',NULL,218,377,1,NULL),(437,12,'2021-06-24 10:36:06.825322',NULL,219,383,1,NULL),(438,8,'2021-06-24 10:36:06.840891',NULL,220,58,1,NULL),(439,-7,'2021-06-24 10:37:41.744472',295,NULL,58,0,NULL),(440,1,'2021-06-30 06:04:32.004895',NULL,221,203,1,NULL),(441,1,'2021-06-30 06:04:32.064990',NULL,222,113,1,NULL),(442,1,'2021-06-30 06:04:32.093450',NULL,224,133,1,NULL),(443,12,'2021-06-30 06:04:32.094189',NULL,223,339,1,NULL),(444,5,'2021-06-30 06:04:32.139298',NULL,225,84,1,NULL),(445,1,'2021-06-30 06:04:32.201563',NULL,226,25,1,NULL),(446,3,'2021-06-30 06:04:32.208722',NULL,227,27,1,NULL),(447,1,'2021-06-30 06:04:32.220230',NULL,228,20,1,NULL),(448,1,'2021-06-30 06:04:32.331778',NULL,229,29,1,NULL),(449,1,'2021-06-30 06:04:32.332981',NULL,230,259,1,NULL),(450,1,'2021-06-30 06:04:32.337612',NULL,231,256,1,NULL),(451,1,'2021-06-30 06:04:32.424567',NULL,232,210,1,NULL),(452,1,'2021-06-30 06:04:32.451576',NULL,233,330,1,NULL),(453,2,'2021-06-30 06:04:32.451619',NULL,234,101,1,NULL),(454,1,'2021-06-30 06:04:32.525256',NULL,235,372,1,NULL),(455,1,'2021-06-30 06:04:32.549715',NULL,236,104,1,NULL),(456,2,'2021-06-30 07:12:34.441673',NULL,237,315,1,NULL),(457,1,'2021-06-30 07:12:34.499065',NULL,238,320,1,NULL),(458,4,'2021-06-30 07:12:34.508725',NULL,239,72,1,NULL),(459,1,'2021-06-30 07:12:34.528560',NULL,240,316,1,NULL),(460,8,'2021-06-30 07:12:34.574249',NULL,241,169,1,NULL),(461,1,'2021-06-30 07:12:34.635760',NULL,242,44,1,NULL),(462,1,'2021-06-30 07:12:34.642411',NULL,243,39,1,NULL),(463,5,'2021-06-30 07:12:34.676541',NULL,244,348,1,NULL),(464,10,'2021-06-30 07:12:34.714885',NULL,245,350,1,NULL),(465,5,'2021-06-30 07:14:07.792795',NULL,246,58,1,NULL),(466,-1,'2021-07-02 10:44:37.277898',287,NULL,58,0,NULL),(467,1,'2021-07-06 17:07:29.461711',NULL,NULL,100,1,NULL),(468,-1,'2021-07-06 17:07:39.182652',NULL,NULL,100,0,NULL),(469,0,'2021-07-09 15:05:54.289955',NULL,NULL,323,1,NULL),(470,0,'2021-07-09 15:06:25.037592',NULL,NULL,323,1,NULL),(471,0,'2021-07-09 16:06:47.747142',NULL,NULL,323,1,NULL),(472,0,'2021-07-09 16:06:47.753681',NULL,NULL,238,1,NULL),(473,0,'2021-07-09 16:08:36.203934',NULL,NULL,323,1,NULL),(474,-1,'2021-07-09 16:08:41.038292',NULL,NULL,288,0,NULL),(475,0,'2021-07-09 16:08:43.535843',NULL,NULL,238,1,NULL),(476,-2,'2021-07-09 16:08:45.373275',NULL,NULL,85,0,NULL),(477,1,'2021-07-19 12:30:39.353309',NULL,NULL,83,1,36),(478,1,'2021-07-22 09:56:39.649207',NULL,NULL,83,1,35),(479,10,'2021-09-20 13:24:15.414139',NULL,251,52,1,NULL),(480,-1,'2021-09-20 13:25:37.062430',296,NULL,52,0,NULL),(481,-1,'2021-09-20 13:25:37.063908',368,NULL,52,0,NULL),(482,1,'2021-12-30 08:34:41.943369',NULL,252,216,1,NULL),(483,-1,'2021-12-30 08:37:52.304211',399,NULL,216,0,NULL),(484,1,'2021-12-30 08:40:20.809253',NULL,253,51,1,NULL),(485,-1,'2021-12-30 08:41:05.059816',388,NULL,51,0,NULL),(486,1,'2021-12-30 09:15:32.031770',NULL,254,187,1,NULL),(487,1,'2021-12-30 09:15:32.103809',NULL,255,370,1,NULL),(488,-1,'2021-12-30 09:19:43.405566',394,NULL,187,0,NULL),(489,-4,'2021-12-30 09:20:25.183175',400,NULL,370,0,NULL),(490,0,'2022-01-03 09:24:02.448270',NULL,256,408,1,NULL),(491,6,'2022-01-03 09:25:37.750186',NULL,257,216,1,NULL),(492,3,'2022-01-03 09:25:37.782654',NULL,258,370,1,NULL),(493,-1,'2022-01-03 10:04:50.267269',396,NULL,216,0,NULL),(494,10,'2022-01-04 11:26:31.513570',NULL,259,408,1,NULL),(495,2,'2022-01-04 11:27:39.699165',NULL,260,187,1,NULL),(496,-1,'2022-01-05 09:06:01.664361',401,NULL,408,0,NULL),(497,1,'2022-01-05 13:32:43.509538',NULL,261,51,1,NULL),(498,1,'2022-01-13 15:15:27.671366',NULL,262,323,1,NULL),(499,-1,'2022-01-13 15:16:17.165643',423,NULL,323,0,NULL),(500,1,'2022-01-13 15:41:00.358939',NULL,NULL,323,1,38),(501,-2,'2022-01-27 12:08:45.342844',332,NULL,361,0,NULL),(502,1,'2022-02-16 12:09:20.248544',NULL,NULL,51,1,39);

--
-- Table structure for table `stoc_stoclograw`
--

CREATE TABLE `stoc_stoclograw` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantitate` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `positive` tinyint(1) NOT NULL,
  `comandarow_id` int(11) DEFAULT NULL,
  `facturarow_id` int(11) DEFAULT NULL,
  `produs_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stoc_stoclograw_comandarow_id_38efca81_fk_comanda_c` (`comandarow_id`),
  KEY `stoc_stoclograw_facturarow_id_d2747b6f_fk_factura_f` (`facturarow_id`),
  KEY `stoc_stoclograw_produs_id_54bdc498_fk_produse_produs_id` (`produs_id`),
  CONSTRAINT `stoc_stoclograw_comandarow_id_38efca81_fk_comanda_c` FOREIGN KEY (`comandarow_id`) REFERENCES `comanda_comandarecord` (`id`),
  CONSTRAINT `stoc_stoclograw_facturarow_id_d2747b6f_fk_factura_f` FOREIGN KEY (`facturarow_id`) REFERENCES `factura_facturarecord` (`id`),
  CONSTRAINT `stoc_stoclograw_produs_id_54bdc498_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1484 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stoclograw`
--

INSERT INTO `stoc_stoclograw` VALUES (612,0,'2021-06-03 15:47:27.406076',1,283,NULL,85),(613,-2,'2021-06-03 15:47:27.408993',0,283,NULL,85),(614,0,'2021-06-03 15:47:29.761248',1,282,NULL,288),(615,-1,'2021-06-03 15:47:29.765291',0,282,NULL,288),(616,0,'2021-06-03 16:06:16.097607',1,NULL,150,20),(617,10,'2021-06-03 16:06:16.101451',1,NULL,150,20),(618,0,'2021-06-03 16:06:23.902413',1,285,NULL,20),(619,-10,'2021-06-03 16:06:23.906549',0,285,NULL,20),(620,0,'2021-06-11 11:42:28.326717',1,NULL,151,83),(621,3,'2021-06-11 11:42:28.332501',1,NULL,151,83),(624,0,'2021-06-11 11:44:00.444098',1,292,NULL,83),(625,-3,'2021-06-11 11:44:00.453105',0,292,NULL,83),(626,0,'2021-06-11 11:44:41.409826',1,293,NULL,241),(627,-12,'2021-06-11 11:44:41.412782',0,293,NULL,241),(628,0,'2021-06-11 11:48:08.983886',1,NULL,NULL,83),(629,1,'2021-06-11 11:48:08.988192',1,NULL,NULL,83),(630,0,'2021-06-11 11:50:52.157517',1,297,NULL,83),(631,-1,'2021-06-11 11:50:52.162338',0,297,NULL,83),(634,3,'2021-06-14 08:45:29.166968',1,NULL,151,83),(635,3,'2021-06-14 08:48:36.883137',1,NULL,151,83),(636,3,'2021-06-14 08:50:34.551640',1,NULL,151,83),(637,3,'2021-06-14 08:50:34.642484',1,NULL,151,83),(638,0,'2021-06-14 08:50:34.692667',1,NULL,154,63),(639,0,'2021-06-14 08:50:34.693093',1,NULL,153,339),(640,12,'2021-06-14 08:50:34.697294',1,NULL,153,339),(641,3,'2021-06-14 08:50:34.713935',1,NULL,154,63),(642,0,'2021-06-14 08:56:38.147706',1,298,NULL,63),(643,-1,'2021-06-14 08:56:38.161044',0,298,NULL,63),(644,3,'2021-06-14 09:47:34.718087',1,NULL,151,83),(645,12,'2021-06-14 09:47:34.726944',1,NULL,153,339),(646,3,'2021-06-14 09:47:34.736117',1,NULL,154,63),(647,3,'2021-06-14 09:47:34.859658',1,NULL,151,83),(648,12,'2021-06-14 09:47:34.907539',1,NULL,153,339),(649,3,'2021-06-14 09:47:34.916459',1,NULL,154,63),(650,3,'2021-06-14 09:47:41.110891',1,NULL,151,83),(651,12,'2021-06-14 09:47:41.119804',1,NULL,153,339),(652,3,'2021-06-14 09:47:41.128796',1,NULL,154,63),(653,3,'2021-06-14 09:47:41.250173',1,NULL,151,83),(654,12,'2021-06-14 09:47:41.295664',1,NULL,153,339),(655,3,'2021-06-14 09:47:41.309836',1,NULL,154,63),(656,0,'2021-06-14 09:57:58.492072',1,309,NULL,63),(657,-2,'2021-06-14 09:57:58.496714',0,309,NULL,63),(658,0,'2021-06-14 09:58:00.683643',1,308,NULL,339),(659,-12,'2021-06-14 09:58:00.686625',0,308,NULL,339),(662,0,'2021-06-14 12:01:45.037005',1,310,NULL,351),(663,-1,'2021-06-14 12:01:45.041157',0,310,NULL,351),(668,0,'2021-06-14 12:17:23.786878',1,NULL,157,339),(669,24,'2021-06-14 12:17:23.790765',1,NULL,157,339),(670,0,'2021-06-14 12:17:23.835247',1,NULL,158,83),(671,0,'2021-06-14 12:17:23.836582',1,NULL,159,63),(672,4,'2021-06-14 12:17:23.841235',1,NULL,158,83),(673,4,'2021-06-14 12:17:23.857135',1,NULL,159,63),(674,0,'2021-06-14 12:29:13.903496',1,313,NULL,63),(675,-3,'2021-06-14 12:29:13.908096',0,313,NULL,63),(676,0,'2021-06-14 12:29:13.917177',1,306,NULL,63),(677,-1,'2021-06-14 12:29:13.921783',0,306,NULL,63),(678,0,'2021-06-14 12:29:23.180534',1,307,NULL,83),(679,-1,'2021-06-14 12:29:23.183453',0,307,NULL,83),(680,0,'2021-06-14 12:29:23.192401',1,312,NULL,83),(681,-3,'2021-06-14 12:29:23.196974',0,312,NULL,83),(682,0,'2021-06-14 12:29:25.767868',1,311,NULL,339),(683,-24,'2021-06-14 12:29:25.770796',0,311,NULL,339),(684,0,'2021-06-14 12:54:03.663039',1,NULL,160,316),(685,4,'2021-06-14 12:54:03.672295',1,NULL,160,316),(686,0,'2021-06-14 12:54:03.676961',1,NULL,162,107),(687,0,'2021-06-14 12:54:03.678297',1,NULL,161,105),(688,2,'2021-06-14 12:54:03.688078',1,NULL,162,107),(689,2,'2021-06-14 12:54:03.689000',1,NULL,161,105),(690,0,'2021-06-14 12:54:03.755733',1,NULL,163,170),(691,0,'2021-06-14 12:54:03.760905',1,NULL,164,169),(692,12,'2021-06-14 12:54:03.766632',1,NULL,164,169),(693,5,'2021-06-14 12:54:03.767645',1,NULL,163,170),(694,0,'2021-06-14 12:56:42.966927',1,318,NULL,170),(695,-4,'2021-06-14 12:56:42.970540',0,318,NULL,170),(696,0,'2021-06-14 12:56:42.978031',1,290,NULL,170),(697,-1,'2021-06-14 12:56:42.982583',0,290,NULL,170),(698,0,'2021-06-14 12:57:03.053204',1,314,NULL,316),(699,-4,'2021-06-14 12:57:03.056197',0,314,NULL,316),(700,0,'2021-06-14 12:57:06.989528',1,315,NULL,105),(701,-2,'2021-06-14 12:57:06.992526',0,315,NULL,105),(702,0,'2021-06-14 12:57:19.182791',1,317,NULL,107),(703,-2,'2021-06-14 12:57:19.185713',0,317,NULL,107),(704,0,'2021-06-14 12:57:24.562496',1,316,NULL,169),(705,-12,'2021-06-14 12:57:24.565416',0,316,NULL,169),(706,-4,'2021-06-14 12:57:28.895173',0,313,NULL,63),(707,-4,'2021-06-14 12:57:33.294569',0,312,NULL,83),(708,-5,'2021-06-15 05:37:00.326334',0,318,NULL,170),(709,0,'2021-06-15 06:32:06.157900',1,NULL,165,329),(710,21,'2021-06-15 06:32:06.162003',1,NULL,165,329),(711,0,'2021-06-15 06:32:06.211749',1,NULL,166,328),(712,4,'2021-06-15 06:32:06.217501',1,NULL,166,328),(713,0,'2021-06-15 06:32:06.219669',1,NULL,167,84),(714,3,'2021-06-15 06:32:06.228273',1,NULL,167,84),(715,0,'2021-06-15 06:32:06.244232',1,NULL,168,100),(716,3,'2021-06-15 06:32:06.249986',1,NULL,168,100),(717,0,'2021-06-15 06:34:29.776880',1,324,NULL,328),(718,-4,'2021-06-15 06:34:29.779760',0,324,NULL,328),(719,0,'2021-06-15 06:34:34.337564',1,323,NULL,329),(720,-21,'2021-06-15 06:34:34.340492',0,323,NULL,329),(721,0,'2021-06-15 06:34:51.137574',1,326,NULL,100),(722,-3,'2021-06-15 06:34:51.141946',0,326,NULL,100),(723,0,'2021-06-15 06:35:34.488582',1,325,NULL,84),(724,-3,'2021-06-15 06:35:34.491580',0,325,NULL,84),(725,0,'2021-06-17 08:47:14.870289',1,NULL,169,357),(726,1,'2021-06-17 08:47:14.874430',1,NULL,169,357),(727,0,'2021-06-17 08:47:38.377294',1,327,NULL,357),(728,-1,'2021-06-17 08:47:38.380281',0,327,NULL,357),(729,0,'2021-06-17 08:52:46.966970',1,NULL,170,328),(730,10,'2021-06-17 08:52:46.970821',1,NULL,170,328),(731,0,'2021-06-17 08:52:47.021014',1,NULL,171,329),(732,10,'2021-06-17 08:52:47.026466',1,NULL,171,329),(733,0,'2021-06-17 08:52:47.026786',1,NULL,172,358),(734,75,'2021-06-17 08:52:47.041207',1,NULL,172,358),(735,0,'2021-06-17 08:53:23.939434',1,328,NULL,328),(736,-10,'2021-06-17 08:53:23.944133',0,328,NULL,328),(737,0,'2021-06-17 08:53:26.078592',1,329,NULL,329),(738,-10,'2021-06-17 08:53:26.081584',0,329,NULL,329),(739,0,'2021-06-17 08:53:27.828032',1,330,NULL,358),(740,-75,'2021-06-17 08:53:27.830935',0,330,NULL,358),(741,10,'2021-06-17 09:05:03.307856',1,NULL,170,328),(742,10,'2021-06-17 09:05:03.316750',1,NULL,171,329),(743,75,'2021-06-17 09:05:03.325831',1,NULL,172,358),(744,10,'2021-06-17 09:09:39.940018',1,NULL,170,328),(745,10,'2021-06-17 09:09:39.948631',1,NULL,171,329),(746,75,'2021-06-17 09:09:39.979739',1,NULL,172,358),(747,10,'2021-06-17 09:09:40.073979',1,NULL,170,328),(748,10,'2021-06-17 09:09:40.118902',1,NULL,171,329),(749,75,'2021-06-17 09:09:40.118994',1,NULL,172,358),(750,0,'2021-06-17 10:46:43.016724',1,NULL,173,359),(751,5,'2021-06-17 10:46:43.020790',1,NULL,173,359),(752,0,'2021-06-17 10:46:43.171994',1,NULL,175,360),(753,0,'2021-06-17 10:46:43.173051',1,NULL,174,361),(754,0,'2021-06-17 10:46:43.173215',1,NULL,176,362),(755,5,'2021-06-17 10:46:43.180820',1,NULL,175,360),(756,2,'2021-06-17 10:46:43.181702',1,NULL,174,361),(757,3,'2021-06-17 10:46:43.183440',1,NULL,176,362),(758,0,'2021-06-17 10:46:43.240333',1,NULL,177,69),(759,4,'2021-06-17 10:46:43.246019',1,NULL,177,69),(760,0,'2021-06-17 10:46:43.258021',1,NULL,178,301),(761,2,'2021-06-17 10:46:43.263824',1,NULL,178,301),(762,4,'2021-06-17 11:00:04.911293',1,NULL,177,69),(763,2,'2021-06-17 11:00:04.920589',1,NULL,178,301),(764,5,'2021-06-17 11:00:04.929554',1,NULL,173,359),(765,5,'2021-06-17 11:00:04.938410',1,NULL,175,360),(766,2,'2021-06-17 11:00:04.947355',1,NULL,174,361),(767,3,'2021-06-17 11:00:04.956630',1,NULL,176,362),(768,5,'2021-06-17 11:00:05.125406',1,NULL,173,359),(769,3,'2021-06-17 11:00:05.171350',1,NULL,176,362),(770,5,'2021-06-17 11:00:05.228084',1,NULL,175,360),(771,2,'2021-06-17 11:00:05.240959',1,NULL,174,361),(774,4,'2021-06-17 11:00:05.315321',1,NULL,177,69),(775,2,'2021-06-17 11:00:05.317302',1,NULL,178,301),(777,4,'2021-06-17 11:08:41.693114',1,NULL,177,69),(778,2,'2021-06-17 11:08:41.701852',1,NULL,178,301),(779,5,'2021-06-17 11:08:41.710752',1,NULL,173,359),(780,5,'2021-06-17 11:08:41.721350',1,NULL,175,360),(781,2,'2021-06-17 11:08:41.730292',1,NULL,174,361),(782,3,'2021-06-17 11:08:41.739360',1,NULL,176,362),(783,5,'2021-06-17 11:08:41.890804',1,NULL,173,359),(784,3,'2021-06-17 11:08:41.942903',1,NULL,176,362),(785,4,'2021-06-17 11:08:41.967800',1,NULL,177,69),(786,2,'2021-06-17 11:08:41.973371',1,NULL,174,361),(787,5,'2021-06-17 11:08:42.020174',1,NULL,175,360),(788,2,'2021-06-17 11:08:42.039427',1,NULL,178,301),(789,4,'2021-06-17 11:09:18.191134',1,NULL,177,69),(790,2,'2021-06-17 11:09:18.200110',1,NULL,178,301),(791,5,'2021-06-17 11:09:18.208954',1,NULL,173,359),(792,5,'2021-06-17 11:09:18.217442',1,NULL,175,360),(793,2,'2021-06-17 11:09:18.226649',1,NULL,174,361),(794,3,'2021-06-17 11:09:18.235331',1,NULL,176,362),(795,4,'2021-06-17 11:09:18.383089',1,NULL,177,69),(796,2,'2021-06-17 11:09:18.430471',1,NULL,178,301),(797,5,'2021-06-17 11:09:18.464521',1,NULL,175,360),(798,5,'2021-06-17 11:09:18.468770',1,NULL,173,359),(799,2,'2021-06-17 11:09:18.483649',1,NULL,174,361),(800,0,'2021-06-17 11:09:18.530977',1,NULL,180,363),(801,-1,'2021-06-17 11:09:18.537908',0,NULL,180,363),(802,3,'2021-06-17 11:09:18.547788',1,NULL,176,362),(803,0,'2021-06-17 12:55:52.964360',1,331,NULL,359),(804,-5,'2021-06-17 12:55:52.969310',0,331,NULL,359),(805,1,'2021-06-18 11:02:01.606945',1,NULL,169,357),(806,0,'2021-06-24 06:48:57.177386',1,NULL,181,99),(807,1,'2021-06-24 06:48:57.203405',1,NULL,181,99),(808,0,'2021-06-24 06:48:57.207347',1,NULL,183,193),(809,3,'2021-06-24 06:48:57.223311',1,NULL,183,193),(810,0,'2021-06-24 06:48:57.224480',1,NULL,182,253),(811,1,'2021-06-24 06:48:57.229938',1,NULL,182,253),(812,0,'2021-06-24 06:48:57.297169',1,NULL,184,192),(813,1,'2021-06-24 06:48:57.303726',1,NULL,184,192),(814,0,'2021-06-24 06:48:57.306085',1,NULL,185,177),(815,1,'2021-06-24 06:48:57.317790',1,NULL,185,177),(816,1,'2021-06-24 06:50:12.560916',1,NULL,181,99),(817,1,'2021-06-24 06:50:12.569783',1,NULL,185,177),(818,1,'2021-06-24 06:50:12.578489',1,NULL,184,192),(819,3,'2021-06-24 06:50:12.587454',1,NULL,183,193),(820,1,'2021-06-24 06:50:12.616245',1,NULL,182,253),(821,1,'2021-06-24 06:50:59.810206',1,NULL,181,99),(822,1,'2021-06-24 06:50:59.830309',1,NULL,185,177),(823,1,'2021-06-24 06:50:59.838867',1,NULL,184,192),(824,3,'2021-06-24 06:50:59.847660',1,NULL,183,193),(825,1,'2021-06-24 06:50:59.856370',1,NULL,182,253),(826,1,'2021-06-24 06:50:59.997471',1,NULL,181,99),(827,1,'2021-06-24 06:51:00.028162',1,NULL,185,177),(828,1,'2021-06-24 06:51:00.045802',1,NULL,184,192),(829,3,'2021-06-24 06:51:00.093403',1,NULL,183,193),(830,1,'2021-06-24 06:51:00.130218',1,NULL,182,253),(831,0,'2021-06-24 07:01:35.735377',1,NULL,186,203),(832,0,'2021-06-24 07:01:35.753192',1,NULL,187,104),(833,0,'2021-06-24 07:01:35.754484',1,NULL,188,113),(834,1,'2021-06-24 07:01:35.759732',1,NULL,186,203),(835,1,'2021-06-24 07:01:35.762927',1,NULL,187,104),(836,1,'2021-06-24 07:01:35.770673',1,NULL,188,113),(837,0,'2021-06-24 07:01:35.869307',1,NULL,189,84),(838,5,'2021-06-24 07:01:35.874913',1,NULL,189,84),(839,0,'2021-06-24 07:01:35.876384',1,NULL,191,259),(840,1,'2021-06-24 07:01:35.882384',1,NULL,191,259),(841,0,'2021-06-24 07:01:35.891139',1,NULL,190,339),(842,12,'2021-06-24 07:01:35.896926',1,NULL,190,339),(843,0,'2021-06-24 07:01:35.949514',1,NULL,192,256),(844,1,'2021-06-24 07:01:35.970533',1,NULL,192,256),(845,0,'2021-06-24 07:01:35.977088',1,NULL,194,210),(846,1,'2021-06-24 07:01:35.982839',1,NULL,194,210),(847,0,'2021-06-24 07:01:35.985191',1,NULL,193,101),(848,2,'2021-06-24 07:01:35.994067',1,NULL,193,101),(849,0,'2021-06-24 07:01:36.066887',1,NULL,195,330),(850,1,'2021-06-24 07:01:36.072704',1,NULL,195,330),(851,0,'2021-06-24 07:01:36.073162',1,NULL,196,193),(852,1,'2021-06-24 07:01:36.078436',1,NULL,196,193),(853,5,'2021-06-24 07:02:37.895444',1,NULL,189,84),(854,2,'2021-06-24 07:02:37.904521',1,NULL,193,101),(855,1,'2021-06-24 07:02:37.913353',1,NULL,187,104),(856,1,'2021-06-24 07:02:37.922129',1,NULL,188,113),(857,1,'2021-06-24 07:02:37.930951',1,NULL,196,193),(858,1,'2021-06-24 07:02:37.940069',1,NULL,186,203),(859,1,'2021-06-24 07:02:37.948915',1,NULL,194,210),(860,1,'2021-06-24 07:02:37.957887',1,NULL,192,256),(861,1,'2021-06-24 07:02:37.968702',1,NULL,191,259),(862,1,'2021-06-24 07:02:37.977828',1,NULL,195,330),(863,12,'2021-06-24 07:02:37.986753',1,NULL,190,339),(864,5,'2021-06-24 07:02:59.358917',1,NULL,189,84),(865,2,'2021-06-24 07:02:59.367884',1,NULL,193,101),(866,1,'2021-06-24 07:02:59.376262',1,NULL,187,104),(867,1,'2021-06-24 07:02:59.384853',1,NULL,188,113),(868,1,'2021-06-24 07:02:59.393383',1,NULL,196,193),(869,1,'2021-06-24 07:02:59.402652',1,NULL,186,203),(870,1,'2021-06-24 07:02:59.411531',1,NULL,194,210),(871,1,'2021-06-24 07:02:59.420224',1,NULL,192,256),(872,1,'2021-06-24 07:02:59.428851',1,NULL,191,259),(873,1,'2021-06-24 07:02:59.437331',1,NULL,195,330),(874,12,'2021-06-24 07:02:59.445956',1,NULL,190,339),(875,5,'2021-06-24 07:02:59.707350',1,NULL,189,84),(876,1,'2021-06-24 07:02:59.761510',1,NULL,187,104),(877,1,'2021-06-24 07:02:59.766109',1,NULL,188,113),(878,2,'2021-06-24 07:02:59.769748',1,NULL,193,101),(879,1,'2021-06-24 07:02:59.828580',1,NULL,196,193),(880,1,'2021-06-24 07:02:59.859743',1,NULL,186,203),(881,1,'2021-06-24 07:02:59.894193',1,NULL,194,210),(882,1,'2021-06-24 07:02:59.921838',1,NULL,192,256),(883,1,'2021-06-24 07:02:59.939798',1,NULL,191,259),(884,1,'2021-06-24 07:02:59.998822',1,NULL,195,330),(885,12,'2021-06-24 07:03:00.008416',1,NULL,190,339),(886,1,'2021-06-24 07:08:00.971078',1,NULL,181,99),(887,1,'2021-06-24 07:08:00.986694',1,NULL,185,177),(888,1,'2021-06-24 07:08:01.001612',1,NULL,184,192),(889,3,'2021-06-24 07:08:01.011224',1,NULL,183,193),(890,1,'2021-06-24 07:08:01.020783',1,NULL,182,253),(891,1,'2021-06-24 07:08:01.169651',1,NULL,181,99),(892,0,'2021-06-24 07:08:01.229951',1,NULL,197,124),(893,0,'2021-06-24 07:08:01.236495',1,NULL,197,124),(894,1,'2021-06-24 07:08:01.237395',1,NULL,185,177),(895,1,'2021-06-24 07:08:01.238853',1,NULL,182,253),(896,1,'2021-06-24 07:08:01.293905',1,NULL,184,192),(897,3,'2021-06-24 07:08:01.337036',1,NULL,183,193),(898,1,'2021-06-24 07:20:56.361360',1,NULL,181,99),(899,0,'2021-06-24 07:20:56.370421',1,NULL,197,124),(900,1,'2021-06-24 07:20:56.383003',1,NULL,185,177),(901,1,'2021-06-24 07:20:56.431907',1,NULL,184,192),(902,3,'2021-06-24 07:20:56.440546',1,NULL,183,193),(903,1,'2021-06-24 07:20:56.449383',1,NULL,182,253),(904,1,'2021-06-24 07:20:56.695494',1,NULL,181,99),(905,1,'2021-06-24 07:20:56.754701',1,NULL,184,192),(906,3,'2021-06-24 07:20:56.757968',1,NULL,183,193),(907,0,'2021-06-24 07:20:56.765040',1,NULL,197,124),(908,1,'2021-06-24 07:20:56.822816',1,NULL,182,253),(909,0,'2021-06-24 07:20:56.875549',1,NULL,198,29),(910,1,'2021-06-24 07:20:56.881503',1,NULL,198,29),(911,1,'2021-06-24 07:20:56.886938',1,NULL,185,177),(912,0,'2021-06-24 07:20:56.884979',1,NULL,199,25),(913,1,'2021-06-24 07:20:56.900532',1,NULL,199,25),(914,0,'2021-06-24 07:20:56.952235',1,NULL,200,31),(915,1,'2021-06-24 07:20:56.957947',1,NULL,200,31),(916,1,'2021-06-24 07:25:51.128854',1,NULL,199,25),(917,1,'2021-06-24 07:25:51.138099',1,NULL,198,29),(918,1,'2021-06-24 07:25:51.147097',1,NULL,200,31),(919,1,'2021-06-24 07:25:51.156304',1,NULL,181,99),(920,0,'2021-06-24 07:25:51.165209',1,NULL,197,124),(921,1,'2021-06-24 07:25:51.174258',1,NULL,185,177),(922,1,'2021-06-24 07:25:51.183751',1,NULL,184,192),(923,3,'2021-06-24 07:25:51.193356',1,NULL,183,193),(924,1,'2021-06-24 07:25:51.202358',1,NULL,182,253),(925,1,'2021-06-24 07:25:51.441971',1,NULL,181,99),(926,1,'2021-06-24 07:25:51.503211',1,NULL,185,177),(927,1,'2021-06-24 07:25:51.521358',1,NULL,197,124),(928,1,'2021-06-24 07:25:51.521203',1,NULL,184,192),(929,3,'2021-06-24 07:25:51.596276',1,NULL,183,193),(930,1,'2021-06-24 07:25:51.607578',1,NULL,182,253),(931,1,'2021-06-24 07:25:51.653211',1,NULL,198,29),(932,1,'2021-06-24 07:25:51.685715',1,NULL,200,31),(933,1,'2021-06-24 07:25:51.691633',1,NULL,199,25),(934,0,'2021-06-24 07:25:51.744910',1,NULL,201,104),(935,1,'2021-06-24 07:25:51.755611',1,NULL,201,104),(936,1,'2021-06-24 07:26:42.859295',1,NULL,199,25),(937,1,'2021-06-24 07:26:42.868427',1,NULL,198,29),(938,1,'2021-06-24 07:26:42.877301',1,NULL,200,31),(939,1,'2021-06-24 07:26:42.886201',1,NULL,181,99),(940,1,'2021-06-24 07:26:42.895184',1,NULL,201,104),(941,1,'2021-06-24 07:26:42.904527',1,NULL,197,124),(942,1,'2021-06-24 07:26:42.913499',1,NULL,185,177),(943,1,'2021-06-24 07:26:42.922800',1,NULL,184,192),(944,3,'2021-06-24 07:26:42.947428',1,NULL,183,193),(945,1,'2021-06-24 07:26:42.956708',1,NULL,182,253),(946,1,'2021-06-24 07:26:43.371824',1,NULL,181,99),(947,1,'2021-06-24 07:26:43.432798',1,NULL,185,177),(948,1,'2021-06-24 07:26:43.433867',1,NULL,197,124),(949,1,'2021-06-24 07:26:43.436435',1,NULL,182,253),(950,3,'2021-06-24 07:26:43.490053',1,NULL,183,193),(951,1,'2021-06-24 07:26:43.554528',1,NULL,199,25),(952,1,'2021-06-24 07:26:43.562403',1,NULL,198,29),(953,1,'2021-06-24 07:26:43.565284',1,NULL,184,192),(954,1,'2021-06-24 07:26:43.639769',1,NULL,200,31),(955,1,'2021-06-24 07:26:43.661329',1,NULL,201,104),(956,0,'2021-06-24 07:54:31.787325',1,343,NULL,31),(957,-1,'2021-06-24 07:54:31.790221',0,343,NULL,31),(958,0,'2021-06-24 07:54:34.080149',1,339,NULL,29),(959,-1,'2021-06-24 07:54:34.083066',0,339,NULL,29),(960,0,'2021-06-24 07:54:39.015168',1,342,NULL,25),(961,-1,'2021-06-24 07:54:39.018082',0,342,NULL,25),(962,0,'2021-06-24 07:54:43.565002',1,338,NULL,104),(963,-1,'2021-06-24 07:54:43.568100',0,338,NULL,104),(964,0,'2021-06-24 07:54:45.230943',1,344,NULL,192),(965,-1,'2021-06-24 07:54:45.233933',0,344,NULL,192),(966,0,'2021-06-24 07:54:47.406269',1,337,NULL,99),(967,-1,'2021-06-24 07:54:47.410624',0,337,NULL,99),(968,0,'2021-06-24 07:54:49.253934',1,345,NULL,177),(969,-1,'2021-06-24 07:54:49.256897',0,345,NULL,177),(970,0,'2021-06-24 07:54:51.093712',1,346,NULL,253),(971,-1,'2021-06-24 07:54:51.096691',0,346,NULL,253),(972,0,'2021-06-24 07:54:52.653738',1,340,NULL,124),(973,-1,'2021-06-24 07:54:52.656687',0,340,NULL,124),(974,1,'2021-06-24 08:34:31.107201',1,NULL,199,25),(975,1,'2021-06-24 08:34:31.116371',1,NULL,198,29),(976,1,'2021-06-24 08:34:31.125156',1,NULL,200,31),(977,1,'2021-06-24 08:34:31.133897',1,NULL,181,99),(978,1,'2021-06-24 08:34:31.142830',1,NULL,201,104),(979,1,'2021-06-24 08:34:31.151853',1,NULL,197,124),(980,1,'2021-06-24 08:34:31.161080',1,NULL,185,177),(981,1,'2021-06-24 08:34:31.169935',1,NULL,184,192),(982,3,'2021-06-24 08:34:31.178993',1,NULL,183,193),(983,1,'2021-06-24 08:34:31.187951',1,NULL,182,253),(984,1,'2021-06-24 08:34:31.443235',1,NULL,199,25),(985,1,'2021-06-24 08:34:31.503660',1,NULL,200,31),(986,1,'2021-06-24 08:34:31.504629',1,NULL,198,29),(987,1,'2021-06-24 08:34:31.509923',1,NULL,181,99),(988,1,'2021-06-24 08:34:31.580287',1,NULL,201,104),(989,1,'2021-06-24 08:34:31.601640',1,NULL,197,124),(990,1,'2021-06-24 08:34:31.648570',1,NULL,185,177),(991,1,'2021-06-24 08:34:31.670130',1,NULL,184,192),(992,3,'2021-06-24 08:34:31.701346',1,NULL,183,193),(993,1,'2021-06-24 08:34:31.723807',1,NULL,182,253),(994,0,'2021-06-24 08:34:31.768473',1,NULL,202,370),(995,1,'2021-06-24 08:34:31.772362',1,NULL,202,370),(996,0,'2021-06-24 08:39:15.146256',1,NULL,203,335),(997,1,'2021-06-24 08:39:15.150305',1,NULL,203,335),(998,1,'2021-06-24 08:40:46.117744',1,NULL,203,335),(999,1,'2021-06-24 08:40:58.164182',1,NULL,203,335),(1000,1,'2021-06-24 08:41:14.665001',1,NULL,203,335),(1001,1,'2021-06-24 08:41:14.720802',1,NULL,203,335),(1002,0,'2021-06-24 08:41:32.798177',1,347,NULL,370),(1003,-1,'2021-06-24 08:41:32.801135',0,347,NULL,370),(1004,0,'2021-06-24 09:02:12.879988',1,NULL,204,169),(1005,5,'2021-06-24 09:02:12.904379',1,NULL,204,169),(1006,0,'2021-06-24 09:02:12.905400',1,NULL,205,170),(1007,1,'2021-06-24 09:02:12.939595',1,NULL,205,170),(1008,5,'2021-06-24 09:08:00.391467',1,NULL,204,169),(1009,1,'2021-06-24 09:08:00.400749',1,NULL,205,170),(1010,5,'2021-06-24 09:08:00.476837',1,NULL,204,169),(1011,0,'2021-06-24 09:08:00.530797',1,NULL,206,349),(1012,10,'2021-06-24 09:08:00.540480',1,NULL,206,349),(1013,1,'2021-06-24 09:08:00.543614',1,NULL,205,170),(1014,0,'2021-06-24 09:08:00.646975',1,NULL,207,350),(1015,6,'2021-06-24 09:08:00.653183',1,NULL,207,350),(1016,0,'2021-06-24 09:08:00.674463',1,NULL,208,76),(1017,1,'2021-06-24 09:08:00.680611',1,NULL,208,76),(1018,0,'2021-06-24 09:08:00.715143',1,NULL,209,111),(1019,2,'2021-06-24 09:08:00.720864',1,NULL,209,111),(1020,0,'2021-06-24 09:08:00.827763',1,NULL,210,64),(1021,1,'2021-06-24 09:08:00.831925',1,NULL,210,64),(1022,1,'2021-06-24 09:13:00.262222',1,NULL,210,64),(1023,1,'2021-06-24 09:13:00.271202',1,NULL,208,76),(1024,2,'2021-06-24 09:13:00.280226',1,NULL,209,111),(1025,5,'2021-06-24 09:13:00.288927',1,NULL,204,169),(1026,1,'2021-06-24 09:13:00.297774',1,NULL,205,170),(1027,10,'2021-06-24 09:13:00.306615',1,NULL,206,349),(1028,6,'2021-06-24 09:13:00.315550',1,NULL,207,350),(1029,5,'2021-06-24 09:13:00.493473',1,NULL,204,169),(1030,6,'2021-06-24 09:13:00.549813',1,NULL,207,350),(1031,1,'2021-06-24 09:13:00.561546',1,NULL,205,170),(1032,10,'2021-06-24 09:13:00.562586',1,NULL,206,349),(1033,1,'2021-06-24 09:13:00.616622',1,NULL,208,76),(1034,2,'2021-06-24 09:13:00.694432',1,NULL,209,111),(1035,0,'2021-06-24 09:13:00.703566',1,NULL,211,154),(1036,1,'2021-06-24 09:13:00.706917',1,NULL,210,64),(1037,0,'2021-06-24 09:13:00.713817',1,NULL,211,154),(1038,1,'2021-06-24 09:13:35.705391',1,NULL,210,64),(1039,1,'2021-06-24 09:13:35.720242',1,NULL,208,76),(1040,2,'2021-06-24 09:13:35.728984',1,NULL,209,111),(1041,0,'2021-06-24 09:13:35.745755',1,NULL,211,154),(1042,5,'2021-06-24 09:13:35.754626',1,NULL,204,169),(1043,1,'2021-06-24 09:13:35.763684',1,NULL,205,170),(1044,10,'2021-06-24 09:13:35.772814',1,NULL,206,349),(1045,6,'2021-06-24 09:13:35.799456',1,NULL,207,350),(1046,5,'2021-06-24 09:13:35.999256',1,NULL,204,169),(1047,1,'2021-06-24 09:13:36.066928',1,NULL,205,170),(1048,10,'2021-06-24 09:13:36.081844',1,NULL,206,349),(1049,6,'2021-06-24 09:13:36.148048',1,NULL,207,350),(1050,1,'2021-06-24 09:13:36.221867',1,NULL,208,76),(1051,2,'2021-06-24 09:13:36.240693',1,NULL,209,111),(1052,1,'2021-06-24 09:13:36.331415',1,NULL,210,64),(1053,1,'2021-06-24 09:13:36.338126',1,NULL,211,154),(1054,0,'2021-06-24 09:20:42.522582',1,NULL,212,382),(1055,2,'2021-06-24 09:20:42.528464',1,NULL,212,382),(1056,0,'2021-06-24 09:20:42.543008',1,NULL,213,381),(1057,1,'2021-06-24 09:20:42.554958',1,NULL,213,381),(1058,1,'2021-06-24 09:22:18.970474',1,NULL,213,381),(1059,2,'2021-06-24 09:22:18.979438',1,NULL,212,382),(1060,0,'2021-06-24 09:24:14.904759',1,349,NULL,381),(1061,-1,'2021-06-24 09:24:14.907673',0,349,NULL,381),(1062,0,'2021-06-24 09:24:17.500046',1,348,NULL,382),(1063,-2,'2021-06-24 09:24:17.502897',0,348,NULL,382),(1064,1,'2021-06-24 10:32:02.608461',1,NULL,203,335),(1065,1,'2021-06-24 10:32:02.677579',1,NULL,203,335),(1066,0,'2021-06-24 10:32:02.749219',1,NULL,214,205),(1067,0,'2021-06-24 10:32:02.753742',1,NULL,215,378),(1068,1,'2021-06-24 10:32:02.757539',1,NULL,214,205),(1069,0,'2021-06-24 10:32:02.765661',1,NULL,216,380),(1070,4,'2021-06-24 10:32:02.766355',1,NULL,215,378),(1071,2,'2021-06-24 10:32:02.775608',1,NULL,216,380),(1072,0,'2021-06-24 10:32:02.825580',1,NULL,217,379),(1073,2,'2021-06-24 10:32:02.832137',1,NULL,217,379),(1074,0,'2021-06-24 10:32:02.837307',1,NULL,218,377),(1075,2,'2021-06-24 10:32:02.842888',1,NULL,218,377),(1076,1,'2021-06-24 10:36:06.229150',1,NULL,210,64),(1077,1,'2021-06-24 10:36:06.238013',1,NULL,208,76),(1078,2,'2021-06-24 10:36:06.246870',1,NULL,209,111),(1079,1,'2021-06-24 10:36:06.256059',1,NULL,211,154),(1080,5,'2021-06-24 10:36:06.265011',1,NULL,204,169),(1081,1,'2021-06-24 10:36:06.274112',1,NULL,205,170),(1082,10,'2021-06-24 10:36:06.282959',1,NULL,206,349),(1083,6,'2021-06-24 10:36:06.292149',1,NULL,207,350),(1084,1,'2021-06-24 10:36:06.560463',1,NULL,210,64),(1085,1,'2021-06-24 10:36:06.596945',1,NULL,208,76),(1086,2,'2021-06-24 10:36:06.606780',1,NULL,209,111),(1087,5,'2021-06-24 10:36:06.669267',1,NULL,204,169),(1088,1,'2021-06-24 10:36:06.713180',1,NULL,211,154),(1089,1,'2021-06-24 10:36:06.714266',1,NULL,205,170),(1090,10,'2021-06-24 10:36:06.767414',1,NULL,206,349),(1091,0,'2021-06-24 10:36:06.833168',1,NULL,219,383),(1092,12,'2021-06-24 10:36:06.839469',1,NULL,219,383),(1093,0,'2021-06-24 10:36:06.851441',1,NULL,220,58),(1094,8,'2021-06-24 10:36:06.861971',1,NULL,220,58),(1095,6,'2021-06-24 10:36:06.865677',1,NULL,207,350),(1096,1,'2021-06-24 10:37:13.210019',1,NULL,214,205),(1097,1,'2021-06-24 10:37:13.218781',1,NULL,203,335),(1098,2,'2021-06-24 10:37:13.227654',1,NULL,218,377),(1099,4,'2021-06-24 10:37:13.237307',1,NULL,215,378),(1100,2,'2021-06-24 10:37:13.245968',1,NULL,217,379),(1101,2,'2021-06-24 10:37:13.254750',1,NULL,216,380),(1102,1,'2021-06-24 10:37:13.400924',1,NULL,203,335),(1103,2,'2021-06-24 10:37:13.460170',1,NULL,218,377),(1104,4,'2021-06-24 10:37:13.461400',1,NULL,215,378),(1105,1,'2021-06-24 10:37:13.464795',1,NULL,214,205),(1106,2,'2021-06-24 10:37:13.515177',1,NULL,217,379),(1107,2,'2021-06-24 10:37:13.551103',1,NULL,216,380),(1108,0,'2021-06-24 10:37:41.746762',1,295,NULL,58),(1109,-7,'2021-06-24 10:37:41.749788',0,295,NULL,58),(1110,0,'2021-06-30 06:04:32.011367',1,NULL,221,203),(1111,1,'2021-06-30 06:04:32.015578',1,NULL,221,203),(1112,0,'2021-06-30 06:04:32.075143',1,NULL,222,113),(1113,1,'2021-06-30 06:04:32.080904',1,NULL,222,113),(1114,0,'2021-06-30 06:04:32.099903',1,NULL,224,133),(1115,0,'2021-06-30 06:04:32.109905',1,NULL,223,339),(1116,12,'2021-06-30 06:04:32.118229',1,NULL,223,339),(1117,1,'2021-06-30 06:04:32.120449',1,NULL,224,133),(1118,0,'2021-06-30 06:04:32.145188',1,NULL,225,84),(1119,5,'2021-06-30 06:04:32.150868',1,NULL,225,84),(1120,0,'2021-06-30 06:04:32.213691',1,NULL,226,25),(1121,0,'2021-06-30 06:04:32.214668',1,NULL,227,27),(1122,1,'2021-06-30 06:04:32.222954',1,NULL,226,25),(1123,0,'2021-06-30 06:04:32.227867',1,NULL,228,20),(1124,1,'2021-06-30 06:04:32.233530',1,NULL,228,20),(1125,3,'2021-06-30 06:04:32.222286',1,NULL,227,27),(1126,0,'2021-06-30 06:04:32.343612',1,NULL,229,29),(1127,0,'2021-06-30 06:04:32.344814',1,NULL,230,259),(1128,0,'2021-06-30 06:04:32.350002',1,NULL,231,256),(1129,1,'2021-06-30 06:04:32.350520',1,NULL,230,259),(1130,1,'2021-06-30 06:04:32.353751',1,NULL,229,29),(1131,1,'2021-06-30 06:04:32.361416',1,NULL,231,256),(1132,0,'2021-06-30 06:04:32.430266',1,NULL,232,210),(1133,0,'2021-06-30 06:04:32.456966',1,NULL,234,101),(1134,2,'2021-06-30 06:04:32.470031',1,NULL,234,101),(1135,1,'2021-06-30 06:04:32.470151',1,NULL,232,210),(1136,0,'2021-06-30 06:04:32.492625',1,NULL,233,330),(1137,1,'2021-06-30 06:04:32.498501',1,NULL,233,330),(1138,0,'2021-06-30 06:04:32.534117',1,NULL,235,372),(1139,1,'2021-06-30 06:04:32.560602',1,NULL,235,372),(1140,0,'2021-06-30 06:04:32.561746',1,NULL,236,104),(1141,1,'2021-06-30 06:04:32.567618',1,NULL,236,104),(1142,0,'2021-06-30 07:12:34.445644',1,NULL,237,315),(1143,2,'2021-06-30 07:12:34.449932',1,NULL,237,315),(1144,0,'2021-06-30 07:12:34.504743',1,NULL,238,320),(1145,1,'2021-06-30 07:12:34.510661',1,NULL,238,320),(1146,0,'2021-06-30 07:12:34.519651',1,NULL,239,72),(1147,4,'2021-06-30 07:12:34.530215',1,NULL,239,72),(1148,0,'2021-06-30 07:12:34.539858',1,NULL,240,316),(1149,1,'2021-06-30 07:12:34.571101',1,NULL,240,316),(1150,0,'2021-06-30 07:12:34.580222',1,NULL,241,169),(1151,8,'2021-06-30 07:12:34.585787',1,NULL,241,169),(1152,0,'2021-06-30 07:12:34.641615',1,NULL,242,44),(1153,1,'2021-06-30 07:12:34.647323',1,NULL,242,44),(1154,0,'2021-06-30 07:12:34.661072',1,NULL,243,39),(1155,1,'2021-06-30 07:12:34.669303',1,NULL,243,39),(1156,0,'2021-06-30 07:12:34.686574',1,NULL,244,348),(1157,5,'2021-06-30 07:12:34.695434',1,NULL,244,348),(1158,0,'2021-06-30 07:12:34.720538',1,NULL,245,350),(1159,10,'2021-06-30 07:12:34.726237',1,NULL,245,350),(1160,1,'2021-06-30 07:14:06.890151',1,NULL,243,39),(1161,1,'2021-06-30 07:14:06.904532',1,NULL,242,44),(1162,4,'2021-06-30 07:14:06.917257',1,NULL,239,72),(1163,8,'2021-06-30 07:14:06.930740',1,NULL,241,169),(1164,2,'2021-06-30 07:14:06.943891',1,NULL,237,315),(1165,1,'2021-06-30 07:14:06.958254',1,NULL,240,316),(1166,1,'2021-06-30 07:14:06.971920',1,NULL,238,320),(1167,5,'2021-06-30 07:14:06.985111',1,NULL,244,348),(1168,10,'2021-06-30 07:14:06.998655',1,NULL,245,350),(1169,2,'2021-06-30 07:14:07.440844',1,NULL,237,315),(1170,1,'2021-06-30 07:14:07.509094',1,NULL,240,316),(1171,1,'2021-06-30 07:14:07.515820',1,NULL,242,44),(1172,8,'2021-06-30 07:14:07.537325',1,NULL,241,169),(1173,4,'2021-06-30 07:14:07.603457',1,NULL,239,72),(1174,1,'2021-06-30 07:14:07.675828',1,NULL,238,320),(1175,1,'2021-06-30 07:14:07.685226',1,NULL,243,39),(1176,5,'2021-06-30 07:14:07.689066',1,NULL,244,348),(1177,10,'2021-06-30 07:14:07.783990',1,NULL,245,350),(1178,0,'2021-06-30 07:14:07.799584',1,NULL,246,58),(1179,5,'2021-06-30 07:14:07.806464',1,NULL,246,58),(1180,0,'2021-07-02 10:44:37.281019',1,287,NULL,58),(1181,-1,'2021-07-02 10:44:37.302392',0,287,NULL,58),(1416,0,'2021-07-19 12:30:39.356294',1,NULL,NULL,83),(1417,1,'2021-07-19 12:30:39.359194',1,NULL,NULL,83),(1418,-2,'2021-07-19 12:31:01.260802',0,297,NULL,83),(1419,0,'2021-07-22 09:56:39.816438',1,NULL,NULL,83),(1420,1,'2021-07-22 09:56:39.929773',1,NULL,NULL,83),(1421,0,'2021-09-20 13:24:15.455966',1,NULL,251,52),(1422,10,'2021-09-20 13:24:15.510417',1,NULL,251,52),(1423,0,'2021-09-20 13:25:37.078431',1,296,NULL,52),(1424,-1,'2021-09-20 13:25:37.101577',0,296,NULL,52),(1425,0,'2021-09-20 13:25:37.206911',1,368,NULL,52),(1426,-1,'2021-09-20 13:25:37.231851',0,368,NULL,52),(1427,0,'2021-12-30 08:34:41.983005',1,NULL,252,216),(1428,1,'2021-12-30 08:34:42.017567',1,NULL,252,216),(1429,1,'2021-12-30 08:35:32.829420',1,NULL,252,216),(1430,1,'2021-12-30 08:35:32.874377',1,NULL,252,216),(1431,0,'2021-12-30 08:37:52.306698',1,399,NULL,216),(1432,-1,'2021-12-30 08:37:52.309777',0,399,NULL,216),(1433,0,'2021-12-30 08:40:20.813151',1,NULL,253,51),(1434,1,'2021-12-30 08:40:20.817240',1,NULL,253,51),(1435,0,'2021-12-30 08:41:05.062052',1,388,NULL,51),(1436,-1,'2021-12-30 08:41:05.064929',0,388,NULL,51),(1437,0,'2021-12-30 09:15:32.036824',1,NULL,254,187),(1438,1,'2021-12-30 09:15:32.040996',1,NULL,254,187),(1439,0,'2021-12-30 09:15:32.106823',1,NULL,255,370),(1440,1,'2021-12-30 09:15:32.111047',1,NULL,255,370),(1441,1,'2021-12-30 09:16:17.099334',1,NULL,254,187),(1442,1,'2021-12-30 09:16:17.108229',1,NULL,255,370),(1443,1,'2021-12-30 09:16:17.225852',1,NULL,254,187),(1444,1,'2021-12-30 09:16:17.283459',1,NULL,255,370),(1445,0,'2021-12-30 09:19:43.408844',1,394,NULL,187),(1446,-1,'2021-12-30 09:19:43.411796',0,394,NULL,187),(1447,0,'2021-12-30 09:20:25.185462',1,400,NULL,370),(1448,-1,'2021-12-30 09:20:25.188306',0,400,NULL,370),(1449,0,'2022-01-03 09:24:02.453366',1,NULL,256,408),(1450,0,'2022-01-03 09:24:02.457244',1,NULL,256,408),(1451,0,'2022-01-03 09:25:37.753475',1,NULL,257,216),(1452,0,'2022-01-03 09:25:37.763951',1,NULL,257,216),(1453,0,'2022-01-03 09:25:37.785026',1,NULL,258,370),(1454,0,'2022-01-03 09:25:37.788998',1,NULL,258,370),(1455,0,'2022-01-03 09:46:39.275983',1,NULL,257,216),(1456,0,'2022-01-03 09:46:39.284548',1,NULL,258,370),(1457,0,'2022-01-03 09:46:39.390647',1,NULL,257,216),(1458,0,'2022-01-03 09:46:39.424101',1,NULL,258,370),(1459,0,'2022-01-03 09:46:53.537497',1,NULL,257,216),(1460,0,'2022-01-03 09:46:53.546102',1,NULL,258,370),(1461,6,'2022-01-03 09:46:53.654084',1,NULL,257,216),(1462,3,'2022-01-03 09:46:53.691679',1,NULL,258,370),(1463,0,'2022-01-03 10:04:50.270617',1,396,NULL,216),(1464,-1,'2022-01-03 10:04:50.273598',0,396,NULL,216),(1465,-4,'2022-01-03 10:04:55.004705',0,400,NULL,370),(1466,0,'2022-01-04 11:26:31.516493',1,NULL,259,408),(1467,10,'2022-01-04 11:26:31.520364',1,NULL,259,408),(1468,0,'2022-01-04 11:27:39.702048',1,NULL,260,187),(1469,2,'2022-01-04 11:27:39.705904',1,NULL,260,187),(1470,0,'2022-01-05 09:06:01.667288',1,401,NULL,408),(1471,-1,'2022-01-05 09:06:01.670191',0,401,NULL,408),(1472,0,'2022-01-05 13:32:43.512905',1,NULL,261,51),(1473,1,'2022-01-05 13:32:43.516912',1,NULL,261,51),(1474,0,'2022-01-13 15:15:27.676028',1,NULL,262,323),(1475,1,'2022-01-13 15:15:27.679873',1,NULL,262,323),(1476,0,'2022-01-13 15:16:17.168388',1,423,NULL,323),(1477,-1,'2022-01-13 15:16:17.171291',0,423,NULL,323),(1478,0,'2022-01-13 15:41:00.363704',1,NULL,NULL,323),(1479,1,'2022-01-13 15:41:00.366494',1,NULL,NULL,323),(1480,0,'2022-01-27 12:08:45.432406',1,332,NULL,361),(1481,-2,'2022-01-27 12:08:45.443014',0,332,NULL,361),(1482,0,'2022-02-16 12:09:20.322312',1,NULL,NULL,51),(1483,1,'2022-02-16 12:09:20.349027',1,NULL,NULL,51);

--
-- Table structure for table `stoc_stocrecord`
--

CREATE TABLE `stoc_stocrecord` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantitate` int(11) NOT NULL,
  `pret_ponderat` double NOT NULL,
  `location_id` int(11) NOT NULL,
  `produs_id` int(11) NOT NULL,
  `last_update` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stoc_stocrecord_location_id_produs_id_6cf718ec_uniq` (`location_id`,`produs_id`),
  KEY `stoc_stocrecord_produs_id_b749faba_fk_produse_produs_id` (`produs_id`),
  CONSTRAINT `stoc_stocrecord_location_id_4e0b8a6e_fk_user_locations_id` FOREIGN KEY (`location_id`) REFERENCES `user_locations` (`id`),
  CONSTRAINT `stoc_stocrecord_produs_id_b749faba_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stocrecord`
--

INSERT INTO `stoc_stocrecord` VALUES (85,-1,1,28,288,'2021-07-09 16:08:41.046680'),(86,-2,2,28,85,'2021-07-09 16:08:45.380033'),(87,0,10,28,20,'2021-06-03 16:06:23.905803'),(88,1,231.92999999999998,30,83,'2021-07-22 09:56:39.929048'),(89,-12,22.179999999999996,30,241,'2021-06-14 08:41:58.181612'),(90,0,191.59,30,63,'2021-06-14 09:57:58.495976'),(91,12,23.570000000000004,30,339,'2021-06-30 06:04:32.115464'),(92,-1,808.38,29,351,'2021-06-14 12:05:40.615153'),(93,0,22.179999999999996,28,339,'2021-06-14 12:29:25.769982'),(94,0,231.93,28,83,'2021-06-14 12:57:33.293777'),(95,2,191.59,28,63,'2021-06-14 12:57:28.894386'),(96,0,12.07,28,316,'2021-06-14 12:57:03.055368'),(97,0,52.49,28,105,'2021-06-14 12:57:06.991778'),(98,0,52.49,28,107,'2021-06-14 12:57:19.184978'),(99,3,25.05,28,170,'2021-06-15 05:37:00.325510'),(100,0,25.05,28,169,'2021-06-14 12:57:24.564694'),(101,0,9.22,28,329,'2021-06-15 06:34:34.339719'),(102,0,15.5,28,328,'2021-06-15 06:34:29.778986'),(103,0,18.08,28,84,'2021-06-15 06:35:34.490729'),(104,0,11.42,28,100,'2021-06-15 06:34:51.141184'),(105,0,462.19,29,357,'2021-06-18 11:02:01.605661'),(106,0,9.8,29,328,'2021-06-17 09:09:40.072779'),(107,0,9.75,29,329,'2021-06-17 09:09:40.117110'),(108,0,0.38,29,358,'2021-06-17 09:09:40.117433'),(109,0,87.54,28,359,'2021-06-17 12:55:52.968556'),(110,0,87.54,28,361,'2022-01-27 12:08:45.442270'),(111,5,87.54,28,360,'2021-06-17 11:09:18.461119'),(112,3,399.16,28,362,'2021-06-17 11:09:18.546177'),(113,4,399.16,28,69,'2021-06-17 11:09:18.381890'),(114,2,399.16,28,301,'2021-06-17 11:09:18.428775'),(115,0,0.04,28,363,'2021-06-17 11:09:18.535100'),(116,0,80.66,29,99,'2021-06-24 08:34:31.508281'),(117,0,29.58,29,253,'2021-06-24 08:34:31.722135'),(118,4,52.67422656920204,29,193,'2021-06-24 08:34:31.699682'),(119,0,12.76,29,192,'2021-06-24 08:34:31.668437'),(120,0,12.76,29,177,'2021-06-24 08:34:31.644167'),(121,1,37.29,29,203,'2021-06-24 07:02:59.858009'),(122,1,7.33,29,104,'2021-06-24 08:34:31.578548'),(123,1,40.83,29,113,'2021-06-24 07:02:59.764448'),(124,5,7.779999999999999,29,84,'2021-06-24 07:02:59.706115'),(125,1,33.61,29,259,'2021-06-24 07:02:59.936968'),(126,12,23.570000000000004,29,339,'2021-06-24 07:03:00.006763'),(127,1,33.61,29,256,'2021-06-24 07:02:59.920284'),(128,1,5.17,29,210,'2021-06-24 07:02:59.892487'),(129,2,15.71,29,101,'2021-06-24 07:02:59.768199'),(130,1,7.38,29,330,'2021-06-24 07:02:59.997214'),(131,0,25.13,29,124,'2021-06-24 08:34:31.599935'),(132,0,15.35,29,29,'2021-06-24 08:34:31.502214'),(133,0,15.35,29,25,'2021-06-24 08:34:31.441987'),(134,0,15.35,29,31,'2021-06-24 08:34:31.500755'),(135,0,11.17,29,370,'2021-06-24 08:41:32.800407'),(136,1,20.36,29,335,'2021-06-24 10:37:13.399700'),(137,5,24.21,29,169,'2021-06-24 10:36:06.632092'),(138,1,24.21,29,170,'2021-06-24 10:36:06.688280'),(139,10,45.31,29,349,'2021-06-24 10:36:06.765468'),(140,6,33.96,29,350,'2021-06-24 10:36:06.863984'),(141,1,34.04,29,76,'2021-06-24 10:36:06.584361'),(142,2,20.76,29,111,'2021-06-24 10:36:06.593077'),(143,1,91.12,29,64,'2021-06-24 10:36:06.549546'),(144,1,153.39,29,154,'2021-06-24 10:36:06.692327'),(145,0,111.77,29,382,'2021-06-24 09:24:17.502172'),(146,0,111.77,29,381,'2021-06-24 09:24:14.906899'),(147,1,43.61,29,205,'2021-06-24 10:37:13.462158'),(148,4,24.37,29,378,'2021-06-24 10:37:13.459988'),(149,2,24.37,29,380,'2021-06-24 10:37:13.549892'),(150,2,24.37,29,379,'2021-06-24 10:37:13.513475'),(151,2,24.37,29,377,'2021-06-24 10:37:13.458436'),(152,12,5.63,29,383,'2021-06-24 10:36:06.837830'),(153,1,26.4,29,58,'2021-06-24 10:37:41.749004'),(154,1,37.29,30,203,'2021-06-30 06:04:32.014225'),(155,1,40.83,30,113,'2021-06-30 06:04:32.079239'),(156,1,235.21,30,133,'2021-06-30 06:04:32.116864'),(157,5,7.779999999999999,30,84,'2021-06-30 06:04:32.149262'),(158,1,15.35,30,25,'2021-06-30 06:04:32.220820'),(159,3,15.35,30,27,'2021-06-30 06:04:32.219207'),(160,1,15.35,30,20,'2021-06-30 06:04:32.231933'),(161,1,33.61,30,259,'2021-06-30 06:04:32.348901'),(162,1,15.35,30,29,'2021-06-30 06:04:32.350706'),(163,1,33.61,30,256,'2021-06-30 06:04:32.357413'),(164,1,52.17,30,210,'2021-06-30 06:04:32.468452'),(165,2,15.71,30,101,'2021-06-30 06:04:32.468328'),(166,1,7.38,30,330,'2021-06-30 06:04:32.496885'),(167,1,12.76,30,372,'2021-06-30 06:04:32.546904'),(168,1,7.33,30,104,'2021-06-30 06:04:32.566095'),(169,2,11.65,30,315,'2021-06-30 07:14:07.439064'),(170,1,80.61,30,320,'2021-06-30 07:14:07.674002'),(171,4,140.93,30,72,'2021-06-30 07:14:07.601612'),(172,1,11.65,30,316,'2021-06-30 07:14:07.507518'),(173,8,24.21,30,169,'2021-06-30 07:14:07.535607'),(174,1,218.13,30,44,'2021-06-30 07:14:07.514190'),(175,1,218.13,30,39,'2021-06-30 07:14:07.683660'),(176,5,27.910000000000004,30,348,'2021-06-30 07:14:07.687402'),(177,10,0,30,350,'2021-06-30 07:14:07.782190'),(178,4,26.4,30,58,'2021-07-02 10:44:37.301664'),(179,0,10,30,100,'2021-07-06 17:07:39.190131'),(180,0,0,28,323,'2021-07-09 16:08:36.210617'),(181,0,0,28,238,'2021-07-09 16:08:43.542601'),(182,9,10,30,52,'2021-09-20 13:25:37.231010'),(183,0,50,31,216,'2021-12-30 08:37:52.309035'),(184,2,100,31,51,'2022-02-16 12:09:20.348236'),(185,2,52,32,187,'2022-01-04 11:27:39.705022'),(186,0,100,32,370,'2022-01-03 10:04:55.003887'),(187,9,72,32,408,'2022-01-05 09:06:01.669465'),(188,5,60,32,216,'2022-01-03 10:04:50.272875'),(189,1,1,31,323,'2022-01-13 15:41:00.365788');

--
-- Table structure for table `stoc_stocrecorduser`
--

CREATE TABLE `stoc_stocrecorduser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantitate` int(11) NOT NULL,
  `last_update` datetime(6) NOT NULL,
  `location_id` int(11) DEFAULT NULL,
  `produs_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cantitate_faptica` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stoc_stocrecorduser_user_id_location_id_produs_id_1f730624_uniq` (`user_id`,`location_id`,`produs_id`),
  KEY `stoc_stocrecorduser_location_id_54c4a0e1_fk_user_locations_id` (`location_id`),
  KEY `stoc_stocrecorduser_produs_id_b8efae5f_fk_produse_produs_id` (`produs_id`),
  CONSTRAINT `stoc_stocrecorduser_location_id_54c4a0e1_fk_user_locations_id` FOREIGN KEY (`location_id`) REFERENCES `user_locations` (`id`),
  CONSTRAINT `stoc_stocrecorduser_produs_id_b8efae5f_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`),
  CONSTRAINT `stoc_stocrecorduser_user_id_04851dac_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stocrecorduser`
--

INSERT INTO `stoc_stocrecorduser` VALUES (34,2,'2021-06-03 15:47:27.417898',28,85,455,0),(35,1,'2021-06-03 15:47:29.771561',28,288,455,0),(36,10,'2021-06-03 16:06:23.912963',28,20,455,0),(37,2,'2021-06-11 11:48:08.972987',30,83,436,0),(38,12,'2021-06-11 11:44:41.420653',30,241,436,0),(39,0,'2021-07-22 09:56:39.371499',30,83,438,0),(40,3,'2021-06-14 09:57:58.499733',30,63,436,0),(41,12,'2021-06-14 09:58:00.711881',30,339,436,0),(42,1,'2021-06-14 12:01:45.048675',29,351,456,0),(43,4,'2021-06-14 12:57:28.900425',28,63,443,0),(44,1,'2021-06-14 12:29:13.933736',28,63,513,0),(45,1,'2021-06-14 12:29:23.190079',28,83,513,0),(46,4,'2021-06-14 12:57:33.299624',28,83,443,0),(47,24,'2021-06-14 12:29:25.777320',28,339,443,0),(48,5,'2021-06-15 05:37:00.331474',28,170,443,0),(49,1,'2021-06-14 12:56:42.993246',28,170,451,0),(50,4,'2021-06-14 12:57:03.064309',28,316,443,0),(51,2,'2021-06-14 12:57:06.998994',28,105,443,0),(52,2,'2021-06-14 12:57:19.194832',28,107,443,0),(53,12,'2021-06-14 12:57:24.572120',28,169,443,0),(54,4,'2021-06-15 06:34:29.787885',28,328,506,0),(55,21,'2021-06-15 06:34:34.346955',28,329,506,0),(56,3,'2021-06-15 06:34:51.149830',28,100,506,0),(57,3,'2021-06-15 06:35:34.497866',28,84,506,0),(58,1,'2021-06-17 08:47:38.389337',29,357,483,0),(59,10,'2021-06-17 08:54:01.022174',29,328,532,0),(60,10,'2021-06-17 08:54:01.008229',29,329,532,0),(61,75,'2021-06-17 08:54:01.010389',29,358,532,0),(62,5,'2021-06-17 12:55:52.978510',28,359,456,0),(63,1,'2021-06-24 07:54:31.798058',29,31,484,0),(64,1,'2021-06-24 07:54:34.089646',29,29,484,0),(65,1,'2021-06-24 07:54:39.052053',29,25,484,0),(66,1,'2021-06-24 07:54:43.590462',29,104,484,0),(67,1,'2021-06-24 07:54:45.241774',29,192,480,0),(68,1,'2021-06-24 07:54:47.417362',29,99,484,0),(69,1,'2021-06-24 07:54:49.263220',29,177,480,0),(70,1,'2021-06-24 07:54:51.103017',29,253,452,0),(71,1,'2021-06-24 07:54:52.663252',29,124,484,0),(72,1,'2021-06-24 08:41:32.807547',29,370,533,0),(73,1,'2021-06-24 09:24:14.915790',29,381,484,0),(74,2,'2021-06-24 09:24:17.509108',29,382,484,0),(75,7,'2021-06-24 10:37:41.756418',29,58,484,0),(76,1,'2021-07-02 10:44:37.328679',30,58,436,0),(77,1,'2021-09-20 13:25:37.205108',30,52,438,0),(78,1,'2021-09-20 13:25:37.239687',30,52,439,0),(79,1,'2021-12-30 08:37:52.318608',31,216,612,0),(80,0,'2022-02-16 12:09:19.988749',31,51,589,0),(81,1,'2022-01-03 08:51:28.308346',32,187,597,0),(82,4,'2022-01-03 10:04:55.007703',32,370,590,0),(83,1,'2022-01-03 10:04:50.280429',32,216,590,0),(84,1,'2022-01-05 09:06:01.678825',32,408,590,0),(85,0,'2022-01-13 15:41:00.346393',31,323,589,0),(86,2,'2022-01-27 12:08:45.473838',28,361,456,0);

--
-- Table structure for table `stoc_stocrecorduserlog`
--

CREATE TABLE `stoc_stocrecorduserlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cantitate` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `produs_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cantitate_faptica` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `stoc_stocrecorduserlog_produs_id_cc75e003_fk_produse_produs_id` (`produs_id`),
  KEY `stoc_stocrecorduserlog_user_id_89c5bc47_fk_auth_user_id` (`user_id`),
  CONSTRAINT `stoc_stocrecorduserlog_produs_id_cc75e003_fk_produse_produs_id` FOREIGN KEY (`produs_id`) REFERENCES `produse_produs` (`id`),
  CONSTRAINT `stoc_stocrecorduserlog_user_id_89c5bc47_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=284 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stocrecorduserlog`
--

INSERT INTO `stoc_stocrecorduserlog` VALUES (162,0,'2021-06-03 15:47:27.417424',85,455,0),(163,2,'2021-06-03 15:47:27.418614',85,455,0),(164,0,'2021-06-03 15:47:29.771044',288,455,0),(165,1,'2021-06-03 15:47:29.772275',288,455,0),(166,0,'2021-06-03 16:06:23.912445',20,455,0),(167,10,'2021-06-03 16:06:23.913687',20,455,0),(168,0,'2021-06-11 11:44:00.470887',83,436,0),(169,3,'2021-06-11 11:44:00.473086',83,436,0),(170,0,'2021-06-11 11:44:41.418783',241,436,0),(171,12,'2021-06-11 11:44:41.421395',241,436,0),(172,2,'2021-06-11 11:48:08.975832',83,436,0),(173,0,'2021-06-11 11:50:52.166560',83,438,0),(174,1,'2021-06-11 11:50:52.168985',83,438,0),(175,0,'2021-06-14 08:56:38.168587',63,436,0),(176,1,'2021-06-14 08:56:38.171701',63,436,0),(177,3,'2021-06-14 09:57:58.502055',63,436,0),(178,0,'2021-06-14 09:58:00.693740',339,436,0),(179,12,'2021-06-14 09:58:00.713261',339,436,0),(180,0,'2021-06-14 12:01:45.047057',351,456,0),(181,1,'2021-06-14 12:01:45.049412',351,456,0),(182,0,'2021-06-14 12:29:13.914203',63,443,0),(183,3,'2021-06-14 12:29:13.916365',63,443,0),(184,0,'2021-06-14 12:29:13.932768',63,513,0),(185,1,'2021-06-14 12:29:13.934515',63,513,0),(186,0,'2021-06-14 12:29:23.189475',83,513,0),(187,1,'2021-06-14 12:29:23.191614',83,513,0),(188,0,'2021-06-14 12:29:23.206137',83,443,0),(189,3,'2021-06-14 12:29:23.208287',83,443,0),(190,0,'2021-06-14 12:29:25.776832',339,443,0),(191,24,'2021-06-14 12:29:25.778040',339,443,0),(192,0,'2021-06-14 12:56:42.974497',170,443,0),(193,4,'2021-06-14 12:56:42.977141',170,443,0),(194,0,'2021-06-14 12:56:42.992629',170,451,0),(195,1,'2021-06-14 12:56:42.993990',170,451,0),(196,0,'2021-06-14 12:57:03.062392',316,443,0),(197,4,'2021-06-14 12:57:03.065899',316,443,0),(198,0,'2021-06-14 12:57:06.998500',105,443,0),(199,2,'2021-06-14 12:57:06.999789',105,443,0),(200,0,'2021-06-14 12:57:19.193301',107,443,0),(201,2,'2021-06-14 12:57:19.195629',107,443,0),(202,0,'2021-06-14 12:57:24.571431',169,443,0),(203,12,'2021-06-14 12:57:24.573669',169,443,0),(204,4,'2021-06-14 12:57:28.902775',63,443,0),(205,4,'2021-06-14 12:57:33.301936',83,443,0),(206,5,'2021-06-15 05:37:00.333871',170,443,0),(207,0,'2021-06-15 06:34:29.786048',328,506,0),(208,4,'2021-06-15 06:34:29.788643',328,506,0),(209,0,'2021-06-15 06:34:34.346465',329,506,0),(210,21,'2021-06-15 06:34:34.347750',329,506,0),(211,0,'2021-06-15 06:34:51.148292',100,506,0),(212,3,'2021-06-15 06:34:51.150579',100,506,0),(213,0,'2021-06-15 06:35:34.497386',84,506,0),(214,3,'2021-06-15 06:35:34.498588',84,506,0),(215,0,'2021-06-17 08:47:38.387400',357,483,0),(216,1,'2021-06-17 08:47:38.390459',357,483,0),(217,0,'2021-06-17 08:53:23.950400',328,532,0),(218,10,'2021-06-17 08:53:23.951769',328,532,0),(219,0,'2021-06-17 08:53:26.087736',329,532,0),(220,10,'2021-06-17 08:53:26.090002',329,532,0),(221,0,'2021-06-17 08:53:27.838209',358,532,0),(222,75,'2021-06-17 08:53:27.839544',358,532,0),(223,10,'2021-06-17 08:54:01.012222',329,532,0),(224,75,'2021-06-17 08:54:01.015729',358,532,0),(225,10,'2021-06-17 08:54:01.023874',328,532,0),(226,0,'2021-06-17 12:55:52.976813',359,456,0),(227,5,'2021-06-17 12:55:52.979281',359,456,0),(228,0,'2021-06-24 07:54:31.797532',31,484,0),(229,1,'2021-06-24 07:54:31.798804',31,484,0),(230,0,'2021-06-24 07:54:34.089169',29,484,0),(231,1,'2021-06-24 07:54:34.090366',29,484,0),(232,0,'2021-06-24 07:54:39.037067',25,484,0),(233,1,'2021-06-24 07:54:39.053395',25,484,0),(234,0,'2021-06-24 07:54:43.589982',104,484,0),(235,1,'2021-06-24 07:54:43.591214',104,484,0),(236,0,'2021-06-24 07:54:45.241298',192,480,0),(237,1,'2021-06-24 07:54:45.242494',192,480,0),(238,0,'2021-06-24 07:54:47.416870',99,484,0),(239,1,'2021-06-24 07:54:47.418123',99,484,0),(240,0,'2021-06-24 07:54:49.262695',177,480,0),(241,1,'2021-06-24 07:54:49.264014',177,480,0),(242,0,'2021-06-24 07:54:51.102412',253,452,0),(243,1,'2021-06-24 07:54:51.118800',253,452,0),(244,0,'2021-06-24 07:54:52.662727',124,484,0),(245,1,'2021-06-24 07:54:52.664012',124,484,0),(246,0,'2021-06-24 08:41:32.806986',370,533,0),(247,1,'2021-06-24 08:41:32.808274',370,533,0),(248,0,'2021-06-24 09:24:14.914033',381,484,0),(249,1,'2021-06-24 09:24:14.916559',381,484,0),(250,0,'2021-06-24 09:24:17.508633',382,484,0),(251,2,'2021-06-24 09:24:17.509827',382,484,0),(252,0,'2021-06-24 10:37:41.755940',58,484,0),(253,7,'2021-06-24 10:37:41.757143',58,484,0),(254,0,'2021-07-02 10:44:37.309848',58,436,0),(255,1,'2021-07-02 10:44:37.329426',58,436,0),(256,0,'2021-07-19 12:30:39.325772',83,438,0),(257,1,'2021-07-19 12:31:01.269955',83,438,0),(258,0,'2021-07-22 09:56:39.472586',83,438,0),(259,0,'2021-09-20 13:25:37.108502',52,438,0),(260,1,'2021-09-20 13:25:37.205845',52,438,0),(261,0,'2021-09-20 13:25:37.239082',52,439,0),(262,1,'2021-09-20 13:25:37.240447',52,439,0),(263,0,'2021-12-30 08:37:52.317717',216,612,0),(264,1,'2021-12-30 08:37:52.319402',216,612,0),(265,0,'2021-12-30 08:41:05.071027',51,589,0),(266,1,'2021-12-30 08:41:05.072230',51,589,0),(267,0,'2021-12-30 09:19:43.419161',187,597,0),(268,1,'2021-12-30 09:19:43.420390',187,597,0),(269,0,'2021-12-30 09:20:25.192398',370,590,0),(270,1,'2021-12-30 09:20:25.211867',370,590,0),(271,1,'2022-01-03 08:51:28.307717',187,597,1),(272,1,'2022-01-03 08:51:28.309331',187,597,0),(273,0,'2022-01-03 10:04:50.279827',216,590,0),(274,1,'2022-01-03 10:04:50.281147',216,590,0),(275,4,'2022-01-03 10:04:55.010047',370,590,0),(276,0,'2022-01-05 09:06:01.676898',408,590,0),(277,1,'2022-01-05 09:06:01.679631',408,590,0),(278,0,'2022-01-13 15:16:17.179161',323,589,0),(279,1,'2022-01-13 15:16:17.180899',323,589,0),(280,0,'2022-01-13 15:41:00.348976',323,589,0),(281,0,'2022-01-27 12:08:45.465453',361,456,0),(282,2,'2022-01-27 12:08:45.474614',361,456,0),(283,0,'2022-02-16 12:09:19.991983',51,589,0);

--
-- Table structure for table `stoc_stocrecorduserrebate`
--

CREATE TABLE `stoc_stocrecorduserrebate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `added` datetime(6) NOT NULL,
  `cantitate` int(11) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `approved_at` datetime(6) DEFAULT NULL,
  `approved_by_id` int(11) DEFAULT NULL,
  `stocrecorduser_id` int(11) NOT NULL,
  `admin_status` smallint(6) NOT NULL,
  `msg_admin` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `msg_doctor` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stoc_stocrecorduserr_approved_by_id_79813236_fk_auth_user` (`approved_by_id`),
  KEY `stoc_stocrecorduserr_stocrecorduser_id_08988fb7_fk_stoc_stoc` (`stocrecorduser_id`),
  CONSTRAINT `stoc_stocrecorduserr_approved_by_id_79813236_fk_auth_user` FOREIGN KEY (`approved_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `stoc_stocrecorduserr_stocrecorduser_id_08988fb7_fk_stoc_stoc` FOREIGN KEY (`stocrecorduser_id`) REFERENCES `stoc_stocrecorduser` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stoc_stocrecorduserrebate`
--

INSERT INTO `stoc_stocrecorduserrebate` VALUES (32,'2021-06-11 11:46:18.949231',1,1,'2021-06-11 11:48:08.988451',486,37,1,NULL,'nu'),(33,'2021-06-14 10:01:22.095866',1,0,NULL,NULL,39,1,NULL,''),(34,'2021-06-14 10:03:42.770917',1,0,NULL,NULL,39,1,NULL,''),(35,'2021-06-14 10:03:51.051750',1,1,'2021-07-22 09:56:39.946282',494,39,1,NULL,''),(36,'2021-06-28 11:22:36.655715',1,1,'2021-07-19 12:30:39.359492',486,39,1,NULL,''),(37,'2021-07-09 12:00:12.640696',1,0,NULL,NULL,35,0,NULL,'test luigi'),(38,'2022-01-13 15:38:24.860089',1,1,'2022-01-13 15:41:00.366792',600,85,1,'de acord','test luigi'),(39,'2022-02-16 12:02:51.926233',1,1,'2022-02-16 12:09:20.349562',600,80,1,'ok aprob (admin)','test luigi');

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(70) COLLATE utf8_romanian_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_romanian_ci DEFAULT NULL,
  `email` varchar(70) COLLATE utf8_romanian_ci DEFAULT NULL,
  `password` varchar(32) COLLATE utf8_romanian_ci DEFAULT NULL,
  `cif` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8_romanian_ci NOT NULL,
  `locked` tinyint(1) DEFAULT 0,
  `valid` tinyint(1) NOT NULL DEFAULT 0,
  `ip` varchar(15) COLLATE utf8_romanian_ci DEFAULT NULL,
  `date_signup` int(11) DEFAULT NULL,
  `date_llogin` int(11) DEFAULT NULL,
  `uid` varchar(36) COLLATE utf8_romanian_ci NOT NULL DEFAULT '',
  `token` varchar(60) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `uid` (`cif`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=302 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (1,'Ionut Dogaru','ionut.dogaru','ionut.dogaru@gmail.com','7815696ecbf1c96e6894b779456d330e','u5283a88f5438a','',0,0,NULL,NULL,1596441462,'84aaa87f-9a87-4922-9d3c-8ebba871a87r',''),(2,'victoria dental offices','admin@dentacloud.ro','admin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','u5283a88f5438b','',0,0,NULL,NULL,1640160042,'84aaa87f-9a87-4922-9d3c-8ebba871a87g',''),(5,'Tehnician','','tehnician@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','RO26232012','0724966366',0,0,'::1',1580146574,1599199148,'025528af-73c3-4281-8d87-e87e2cd444ab',''),(6,'Nume Angajat','nume.angajat@manager','manager@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','RO26232012','0724966366',0,0,'::1',1580210375,1614798843,'f8e07e04-c901-421a-8040-c1758a06a1b9',''),(16,'Ionita Bogdan','ionita.bogdan@medic','medic@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,0,'::1',1583512924,1615994298,'5df22eca-e99f-4dac-95d0-4b39bf7a528e','84ABA-191C022D576882225D0D4EEEC58F27500BA8D07-E5DF9D4154F6A4'),(194,'TEHNOPLUS MEDICAL SRL','','aaa@gmail.com','47bce5c74f589f4867dbd57e9ca9f808','	4261939','0722457856',0,0,'92.83.125.202',1586346885,1587974248,'84aaa87f-9a87-4922-9d3c-8ebba871a87e',''),(195,'ORTOPROFIL PROD ROMANIA SRL','','bbb@gmail.com','08f8e0260c64418510cefb2b06eee5cd','6877197','0722457856',0,0,'92.83.125.202',1586347653,1587974265,'48e48989-d570-4504-9685-106f13d6691e',''),(196,'LABVISION SRL','','ccc@gmail.com','9df62e693988eb4e1e1444ece0578579','28389235','0722457856',0,0,'92.83.125.202',1586351100,1587976636,'bfc8fd99-4d8d-4da0-8a5b-424471253356',''),(197,'VICTORIA DENTAL OFFICES SRL','','vvv@clinicavictoria.ro','4786f3282f04de5b5c7317c490c6d922','32269563','0722457856',0,0,'92.83.125.202',1586351415,1590344569,'a744cbac-df9b-4d41-8dd6-0a8eb9994381',''),(198,'VICTORIA DENT ESTETIC SRL','','vde@gmail.com','929b00559675fbcd5d16abe66117e0d7','36812068','0722457856',0,0,'92.83.125.202',1586352048,1586352048,'5b3d00b0-c2be-4fb1-b4e0-75a2ff09de14',''),(199,'Clinica Victoria 2','','clinica2@dentacloud.ro','f3abb86bd34cf4d52698f14c0da1dc60','RO26232012','0724966366',0,0,'::1',1587974445,1587974445,'9324d54f-3cf3-440a-a58d-df7ab445ef09',NULL),(210,'Receptionera','receptionera@receptioner','receptioner@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,0,'::1',1594650224,1615040865,'8a275f39-233a-4f3c-88ed-a9dd690fd684',NULL),(211,'Medic Consultant','medic.consultant@manager','s@k.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,0,'::1',1595174920,1615476297,'9042f99d-b910-4321-ba5c-0383c9c6507b',NULL),(212,'Calinescu Adrian','calinescu.adrian@medic','calinescu.adrian@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0727903937',0,0,'::1',1595772369,1628171768,'cf863296-405b-484f-a5b5-53dde10a2804',NULL),(213,'Plan Tratament','plan.tratament@plantratament','plantratament@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,1,'::1',1597385279,1629728999,'b81896e6-bcf6-4026-964d-2948ab6bde72',NULL),(214,'Calota Ionela Adelina','calota.ionela.adelina@radiolog','radiolog@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0768841820',0,1,'::1',1600680989,1615037765,'b67aea53-42f7-49c1-aa0c-5e851b51d755',NULL),(215,'Fojica Radu','fojica.radu@medic','fojica.radu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766540568',0,1,'::1',1602333576,1632219287,'05715fea-65ac-4370-84e0-47d7d5464b49',NULL),(216,'Iordache Anamaria','iordache.anamaria@medic','anamaria.corcau@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0741696817',0,1,'::1',1602333622,1637833784,'0ea26429-3866-451f-be3f-645f25b38aa2',NULL),(217,'Istrate Alexandra','istrate.alexandra@medic','istrate.alexandra@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769911218',0,1,'::1',1602334202,1629786648,'f37fc09b-814f-482e-b95c-3e5cf0870e2a',NULL),(218,'Damian Alexandra','damian.alexandra@medic','damian.alexandra@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0743333122',0,1,'::1',1602334286,1627285596,'dd043884-e1d0-4eee-b097-a843f5f132a4',NULL),(219,'Craioveanu George','craioveanu.george@medic','craioveanu.george@dentacloud.ro',NULL,'','0726265254',0,1,'::1',1602334315,1602334215,'3d6fe2b3-87c1-4116-ae4e-d1e1122f46d1',NULL),(220,'Arin Lupascu','arin.lupascu@medic','lupascu.arin@dentacloud.ro',NULL,'','0724966366',0,1,'::1',1602334370,1602334270,'dfcac16d-a05e-45ba-9b8a-707967917618',NULL),(221,'Receptioner Slatina Doi','receptioner.slatina.doi@receptioner','receptioner2@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966365',0,1,'90.95.13.180',1614674399,1615476736,'39e62016-2d91-4b6e-a35c-4b5434ffe877',NULL),(222,'Cojocaru Maria Mihaela','cojocaru.maria.mihaela@radiolog','radiolog-slatina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0746891954',0,1,'212.93.153.203',1614767276,1614769766,'53650f3d-daab-4552-aa73-9f8809e575d4',NULL),(223,'Medic Slatina Doi','medic.slatina.doi@medic','medic-slatina-2@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,1,'90.95.13.180',1614770977,1615476275,'4c795c5f-f2ac-48d5-8ed4-7d1cea4ec51a',NULL),(224,'Maris Liana','maris.liana@medic','maris.liana@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0746891954',0,1,'5.2.164.147',1615536317,1639470420,'ba49351e-a1bd-4e2c-b626-bf0add16aec8',NULL),(225,'Badescu Elena','badescu.elena@receptioner','badescu.elena@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0755236027',0,1,'5.2.164.147',1615536521,1634302138,'e93d7df8-e92d-4462-aa50-6ff968ea30ee',NULL),(226,'Iconaru Ecaterina','iconaru.ecaterina@medic','iconaru.kati@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0721479067',0,1,'5.2.164.147',1615536638,1615537483,'82edf032-ce5b-4d73-840a-5befa96cacbe',NULL),(227,'Pestritu Adelina','pestritu.adelina@receptioner','pestritu.adelina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0761322448',0,1,'5.2.164.147',1615536795,1632219349,'a85fa92d-74c6-4c98-95ed-550acca5b45c',NULL),(228,'Todea Cosmin','todea.cosmin@medic','todea.cosmin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0726474118',0,1,'5.2.164.147',1615536873,1621238896,'3e05ab1a-fbb0-40f9-a744-cdd4cf5ed4c7',NULL),(229,'Gheorghe Ramona','gheorghe.ramona@asistenta','gheorghe.ramona@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769982007',0,1,'5.2.164.147',1615536964,1615536988,'1315eaea-d28d-4de7-9f19-eed6764c788e',NULL),(230,'Comanescu Florin','comanescu.florin@medic','comanescu.florin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0729123851',0,1,'5.2.164.147',1615538993,1623656902,'4ff72729-ff9a-4bb2-9823-af4731b2024d',NULL),(231,'Comanescu Ligia','comanescu.ligia@medic','comanescu.ligia@dentacloud.ro',NULL,'','0744237699',0,1,'5.2.164.147',1615539045,1615538945,'c5ef1b30-7d86-4d07-877c-58ccec689c0c',NULL),(232,'Iancu Simona','iancu.simona@medic','iancu.simona@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766320441',0,1,'5.2.164.147',1615539186,1637310092,'94a6efcf-34c1-49fc-a2e1-5c79341344b0',NULL),(233,'Mihailescu Mihai','mihailescu.mihai@medic','mihailescu.mihai@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0747891938',0,1,'5.2.164.147',1615539256,1624520963,'2e0f73ce-06d3-421d-ad87-73ed2b0b414b',NULL),(234,'Niculescu Elena','niculescu.elena@medic','niculescu.elena@dentacloud.ro',NULL,'','0741984630',0,1,'5.2.164.147',1615539322,1615539222,'3c88c2c2-4066-42f2-a9e6-6ff062f8041a',NULL),(235,'Traistaru Andu','traistaru.andu@medic','traistaru.andu@dentacloud.ro',NULL,'','0722591835',0,1,'5.2.164.147',1615540816,1615540716,'7a7c4005-ad2b-405d-9b2a-0118659be68d',NULL),(236,'Ionita Bogdan','ionita.bogdan@manager','ionita.bogdan@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0770448643',0,1,'5.2.164.147',1615540949,1640159307,'97c24aaa-6b05-4f6b-b595-ac03482e60f5',NULL),(237,'Stanciu Mihai','stanciu.mihai@medic','stanciu.mihai@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0746130685',0,1,'5.2.164.147',1615541286,1633679908,'b49117a6-5f5d-472b-99a7-77a053213dae',NULL),(238,'Soare Camelia','soare.camelia@asistenta','soare.camelia@dentacloud.ro',NULL,'','0738311005',0,1,'5.2.164.147',1615542117,1615542017,'bab224e3-8663-44d7-8a62-1abc325d4496',NULL),(239,'Voicu Andreea','voicu.andreea@scaner','voicu.andreea@dentacloud.ro',NULL,'','0721251626',0,1,'5.2.164.147',1615542223,1615542123,'fa9213d9-76fb-4e29-8ce5-b0d3667a3916',NULL),(240,'Cirstea Anca','cirstea.anca@asistenta','cirstea.anca@dentacloud.ro',NULL,'','0765211939',0,1,'5.2.164.147',1615542283,1615542183,'0efe4c7b-6a2a-425c-a3e6-e1c89712cff5',NULL),(241,'Tirlea Corina','tirlea.corina@manager','tirlea.corina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0753335078',0,1,'5.2.164.147',1615542499,1626947527,'f2f0a05e-c3b3-4ab3-bf26-77e771593f37',NULL),(242,'Deleanu Oana','deleanu.oana@asistenta','deleanu.oana@dentacloud.ro',NULL,'','0722612137',0,1,'5.2.164.147',1615542792,1615542692,'69fd0e72-495b-4ae1-bfaf-db11c57f5a5d',NULL),(243,'Ivan Elena','ivan.elena@asistenta','ivan.elena@dentacloud.ro',NULL,'','0761979725',0,1,'5.2.164.147',1615542854,1615542754,'4032652f-9c10-449f-b954-de133e262ac6',NULL),(244,'Olteanu Nicoleta','olteanu.nicoleta@curatenie','olteanu.nicoleta@dentacloud.ro',NULL,'','0742129915',0,1,'5.2.164.147',1615543039,1615542939,'d41f1d5d-5247-4051-bd33-c176ec528586',NULL),(245,'Costescu Valerica','costescu.valerica@curatenie','costescu.valerica@dentacloud.ro',NULL,'','0741963942',0,1,'5.2.164.147',1615543091,1615542991,'3560f772-a23a-41f5-a72a-fd79cd06d4e4',NULL),(246,'Petcu Ruxandra','petcu.ruxandra@asistenta','petcu.ruxandra@dentacloud.ro',NULL,'','0747811278',0,1,'5.2.164.147',1615543364,1615543264,'44cec71d-d310-499f-9537-baa5aa1b8302',NULL),(247,'Radu Ionela','radu.ionela@asistenta','radu.ionela@dentacloud.ro',NULL,'','0744572336',0,1,'5.2.164.147',1615543426,1615543326,'1375b0de-a665-4b0d-8866-0e51336e2780',NULL),(248,'Rapeanu Ana Maria','rapeanu.ana.maria@asistenta','rapeanu.anamaria@dentacloud.ro',NULL,'','0745412549',0,1,'5.2.164.147',1615543516,1615543416,'d9266db5-dccb-4824-a0b9-44bb07f3ab27',NULL),(249,'Stefanoiu Irina','stefanoiu.irina@asistenta','stefanoiu.irina@dentacloud.ro',NULL,'','0786310311',0,1,'5.2.164.147',1615543601,1615543501,'3f823fb7-73e3-4b61-93ae-ce863811822f',NULL),(250,'Udroiu Madalina','udroiu.madalina@asistenta','udroiu.madalina@dentacloud.ro',NULL,'','0746525503',0,1,'5.2.164.147',1615543657,1615543557,'405cb0df-17b3-414e-bb4b-65a912c5a1c7',NULL),(251,'Barbu Antoaneta','barbu.antoaneta@asistenta','barbu.antoaneta@dentacloud.ro',NULL,'','0736822929',0,1,'5.2.164.147',1615544238,1615544138,'aeb2da97-6fcf-40bb-88e7-2cec0ea3e973',NULL),(252,'Bulagea Mihaela','bulagea.mihaela@asistenta','bulagea.mihaela@dentacloud.ro',NULL,'','0765328728',0,1,'5.2.164.147',1615544708,1615544608,'6f320e26-c4d0-4e53-9517-494ee62c26b2',NULL),(253,'Brandiburu Larisa','brandiburu.larisa@receptioner','brandiburu.larisa@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0748297178',0,1,'5.2.164.147',1615544793,1634915881,'55f0d499-ade0-4fb8-8a8b-6cf9ade954d2',NULL),(254,'Coada Alina','coada.alina@asistenta','coada.alina@dentacloud.ro',NULL,'','0769290199',0,1,'5.2.164.147',1615544834,1615544734,'7b017ba2-edd4-4001-8dd8-3c27a9f4eae1',NULL),(255,'Constantinescu Lavinia','constantinescu.lavinia@receptioner','constantinescu.lavinia@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0730939122',0,1,'5.2.164.147',1615545087,1618999392,'2efbf37b-eb88-4ca9-8d17-f0350feb1ebd',NULL),(256,'Doditoiu Maria','doditoiu.maria@curatenie','doditoiu.maria@dentacloud.ro',NULL,'','0771786361',0,1,'5.2.164.147',1615545151,1615545051,'eced6ef4-a941-4a00-b949-56d4fbaab12f',NULL),(257,'Mutica Mihaela','mutica.mihaela@asistenta','mutica.mihaela@dentacloud.ro',NULL,'','0765389113',0,1,'5.2.164.147',1615545201,1615545101,'b1127c3a-c300-4202-ac3c-f7e5f73fa178',NULL),(258,'Neacsa Mihaela','neacsa.mihaela@asistenta','neacsa.mihaela@dentacloud.ro',NULL,'','0745566699',0,1,'5.2.164.147',1615545377,1615545277,'2e0eeb78-ae59-450c-bd1b-ae2a2e5692e8',NULL),(259,'Nitu Aliora','nitu.aliora@asistenta','nitu.aliora@dentacloud.ro',NULL,'','0760065126',0,1,'5.2.164.147',1615545423,1615545323,'7c360dd3-08de-41ad-87e4-75ed05f0f5d9',NULL),(260,'Sima Nicoleta','sima.nicoleta@curatenie','sima.nicoleta@dentacloud.ro',NULL,'','0721440771',0,1,'5.2.164.147',1615545481,1615545381,'bd223489-2cda-4246-99e6-93c5e356c23f',NULL),(261,'Zamfirescu Laura','zamfirescu.laura@medic','zamfirescu.laura@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0765685431',0,1,'5.2.164.147',1615548140,1624520867,'b1022c4c-387d-48f1-a430-634187905ef1',NULL),(262,'Penzes Alexandru','penzes.alexandru@medic','penzes.alexandru@dentacloud.ro',NULL,'','0745326918',0,1,'5.2.164.147',1615548185,1615548085,'283a44de-bb4e-43e1-89e2-91b951be2350',NULL),(263,'Baranguta Alina','baranguta.alina@medic','baranguta.alina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766107724',0,1,'5.2.164.147',1615548234,1621590043,'b52f050c-1f28-412e-8817-0508b2880602',NULL),(264,'Rosca Adrian','rosca.adrian@medic','rosca.adrian@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0752697710',0,1,'5.2.164.147',1615548313,1623918770,'c7d4cc2b-5d65-415c-a913-de6dd4a316da',NULL),(265,'Popa Ana Maria','popa.ana.maria@medic','popa.anamaria@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0749600211',0,1,'5.2.164.147',1615548883,1624526158,'3787efd0-0140-4bc8-8731-5f2e7dd53715',NULL),(267,'Barbulescu Sabin','barbulescu.sabin@asistenta','barbulescu.sabin@dentacloud.ro',NULL,'','0765729005',0,1,'5.2.164.147',1615549465,1615549365,'5e83a051-cbc8-48d9-bc28-66473dc44564',NULL),(268,'Calota Adelina','calota.adelina@receptioner','calota.adelina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0768841820',0,1,'5.2.164.147',1615549561,1639468805,'5edc76d1-debd-438c-8bc4-132e0426da9c',NULL),(269,'Cojocaru Mihaela','cojocaru.mihaela@radiolog','cojocaru.mihaela@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0762566413',0,1,'5.2.164.147',1615549620,1617188113,'40d04bcc-0417-47ce-b60a-6ae0490a2dba',NULL),(270,'Lungu Stefania','lungu.stefania@curatenie','lungu.stefania@dentacloud.ro',NULL,'','0771436305',0,1,'5.2.164.147',1615550077,1615549977,'481af462-4d8d-416d-a56d-1f8f2fc24a47',NULL),(271,'Mazilu Cristina','mazilu.cristina@receptioner','mazilu.cristina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0764277414',0,1,'5.2.164.147',1615550134,1625742193,'efcf1d59-2fb2-4817-b66d-71f4fdb33b93',NULL),(272,'Odagiu Ramona','odagiu.ramona@asistenta','odagiu.ramona@dentacloud.ro',NULL,'','0763615431',0,1,'5.2.164.147',1615550217,1615550117,'e67262c2-f932-44fe-9c59-1c4d0e33cab2',NULL),(273,'Popa Nicoleta','popa.nicoleta@asistenta','popa.nicoleta@dentacloud.ro',NULL,'','0748591074',0,1,'5.2.164.147',1615550267,1615550167,'f3856a5f-2433-4ee7-818d-43f9d9aad9be',NULL),(274,'Ristea Madalina','ristea.madalina@asistenta','ristea.madalina@dentacloud.ro',NULL,'','0757452650',0,1,'5.2.164.147',1615550332,1615550232,'b712d2e2-9e78-4042-9d8b-45aa567e51fd',NULL),(275,'Ungureanu Cristina','ungureanu.cristina@asistenta','ungureanu.cristina@dentacloud.ro',NULL,'','0763791175',0,1,'5.2.164.147',1615550404,1615550304,'1e773dc4-0397-4599-b18f-3b98e054bd5e',NULL),(276,'Tandarica Irina','tandarica.irina@receptioner','tandarica.irina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0763833191',0,1,'5.2.164.147',1615550512,1631093968,'01b2cd3b-4e18-4d34-b840-c8440e7c69ba',NULL),(277,'Vilcica Veronica','vilcica.veronica@curatenie','vilcica.veronica@dentacloud.ro',NULL,'','0770352449',0,1,'5.2.164.147',1615550554,1615550454,'539dc69b-d8bc-4a9d-98b2-f34a8c98a6e4',NULL),(278,'Cojocaru Mihaela','cojocaru.mihaela@radiolog','cojocaru.mihaela.radiolog@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0762566413',0,1,'5.2.164.147',1615550951,1617087590,'642b19c9-c7cc-46ba-ab79-5d80a137f10b',NULL),(279,'Barbu Antoaneta','barbu.antoaneta@radiolog','barbu.antoaneta.radiolog@dentacloud.ro',NULL,'','0736822929',0,1,'5.2.164.147',1615551025,1615550925,'7535aca2-33d7-47cc-9795-6314e2b4f67a',NULL),(280,'Soare Camelia','soare.camelia@radiolog','soare.camelia.radiolog@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0738311005',0,1,'5.2.164.147',1615551138,1615640947,'7cdc663b-667f-4fe3-9f59-6666f42a813e',NULL),(281,'Ivan Elena','ivan.elena@radiolog','ivan.elena.radiolog@dentacloud.ro',NULL,'','0761979725',0,1,'5.2.164.147',1615551198,1615551098,'62435c75-50b9-4a53-885e-8c52870582c7',NULL),(282,'Banu Mirela','banu.mirela@receptioner','banu.mirela@dentacloud.ro',NULL,'','0726267501',0,1,'5.2.164.147',1615551786,1615551686,'e8a7d2aa-75bd-4a46-bd30-6eaf5bc139a3',NULL),(283,'Mitrache Claudia','mitrache.claudia@receptioner','mitrache.claudia@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0753838502',0,1,'5.2.164.147',1626946517,1628159070,'38821e95-78b1-438a-a8e2-08043e9f286b',NULL),(284,'Andreea Smarandoiu','andreea.smarandoiu@medic','andreea.smarandoiu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0752029507',0,1,'5.2.164.147',1629469569,1637896789,'40e483ff-4c67-4014-baeb-46b8e6a74f59',NULL),(285,'Corodescu Simona','corodescu.simona@manager','simona.corodescu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0720194875',0,1,'5.2.164.147',1630336877,1640597366,'5ad13f82-469f-4e99-999f-a9e1aa52f566',NULL),(286,'Ioana Matei','ioana.matei@medic','ioana.matei@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0723319980',0,1,'5.2.164.147',1630337051,1639470299,'cf3e63a6-d45f-47ef-91fc-aa2f2d3451c0',NULL),(287,'Blebea Doinita','blebea.doinita@medic','doinita.blebea@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0732294778',0,1,'92.83.158.186',1630477490,1630481424,'348c35fd-ad66-4a2b-b404-167f1f269001',NULL),(288,'Zaharia Mirela','zaharia.mirela@manager','mirela.zaharia@dentacloud.ro','9392ab575b6a2f532b327f42e2577050','','0723683890',0,1,'92.83.158.186',1637742406,1638201786,'9866d5a3-775a-445c-a80b-1ff76f1db74c',NULL),(289,'Ciongaru Dragos','ciongaru.dragos@medic','dragos.ciongaru@dentacloud.ro','f62ff60199bb9293c726631b4e28b025','','0784305521',0,1,'92.83.158.186',1637742495,1640013799,'6c5da9fe-7044-4d6f-a7ad-76e65895005a',NULL),(290,'Antoci Adina Alexandra','antoci.adina.alexandra@medic','adina.antoci@dentacloud.ro',NULL,'','0765871429',0,1,'92.83.158.186',1637742818,1637742718,'8908db3f-e7d9-418c-90d8-96ef672c5020',NULL),(291,'Bazavan Adina','bazavan.adina@medic','adina.bazavan@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769216893',0,1,'92.83.158.186',1637742918,1639332441,'eecd50ac-4139-48b1-a6ee-fe6b4655b1cc',NULL),(292,'Daniel Florin Radu','daniel.florin.radu@medic','daniel.radu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769506190',0,1,'92.83.158.186',1637743080,1640597286,'c218cf5f-af5f-4844-9a0c-12140c49d94d',NULL),(293,'Maria Dumitru','maria.dumitru@manager','maria.dumitru@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0726281901',0,1,'92.83.158.186',1637743286,1637997884,'56af7a44-cb90-43a2-be2a-e5bcdcafcdf4',NULL),(297,'Cosma Ana','cosma.ana@medic','ana.cosma@dentacloud.ro',NULL,'','0724246162',0,1,'92.83.158.186',1637747468,1637747368,'92c19670-f0f6-48ab-b87a-d34795b6c2ad',NULL),(298,'Tudose Andreea Gabriela','tudose.andreea.gabriela@medic','andreea.tudose@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0742015564',0,1,'92.83.158.186',1637747549,1640597210,'35d1b703-8284-4393-bb60-166a0e5d9b84',NULL),(299,'Bianca','bianca@receptioner','bianca.receptie@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0736810079',0,1,'92.83.158.186',1637894374,1640599428,'89cf633e-19ec-40b8-a084-e6af61c908e8',NULL),(300,'Maria Oprea','maria.oprea@radiolog','maria.oprea@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0738831568',0,1,'82.76.174.58',1638788601,1638790549,'0dbedfcd-dcd2-46d2-ad4b-7f773e83ba0e',NULL),(301,'Giusepa Docescu','giusepa.docescu@receptioner','giusepa.docescu@dentacloud.ro',NULL,'','0787341872',0,1,'82.76.174.58',1638956660,1638956560,'b3cf273e-8a21-4d18-a203-9aa01aac2dc6',NULL);

--
-- Table structure for table `user_lastlogins`
--

CREATE TABLE `user_lastlogins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `user_lastlogins_user_id_location_id_cc75ceb4_uniq` (`user_id`,`location_id`),
  KEY `user_lastlogins_location_id_fb898ab3_fk_user_locations_id` (`location_id`),
  CONSTRAINT `user_lastlogins_location_id_fb898ab3_fk_user_locations_id` FOREIGN KEY (`location_id`) REFERENCES `user_locations` (`id`),
  CONSTRAINT `user_lastlogins_user_id_56007b94_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_lastlogins`
--

INSERT INTO `user_lastlogins` VALUES (48,30,436),(52,30,438),(64,30,439),(63,30,441),(57,28,443),(55,28,444),(47,28,446),(75,28,447),(54,28,449),(49,28,451),(60,29,452),(46,28,455),(56,28,456),(53,29,472),(59,29,480),(58,29,483),(50,29,484),(51,30,486),(61,30,489),(62,30,494),(67,31,589),(70,31,590),(74,31,593),(76,31,594),(68,31,596),(69,32,597),(66,31,599),(65,31,600),(71,31,602),(72,32,605),(73,32,606);

--
-- Table structure for table `user_locations`
--

CREATE TABLE `user_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remote_id` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `remote_id` (`remote_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_locations`
--

INSERT INTO `user_locations` VALUES (28,'VICTORIA DENTAL OFFICES SRL - Pitesti',NULL,6),(29,'VICTORIA DENTAL OFFICES SRL - Valcea',NULL,7),(30,'VICTORIA DENTAL OFFICES SRL - Slatina',NULL,15),(31,'VICTORIA DENTAL OFFICES -  Bucuresti',NULL,16),(32,'VICTORIA DENTAL OFFICES - Targoviste',NULL,17);

--
-- Table structure for table `user_profile`
--

CREATE TABLE `user_profile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remote_id` smallint(6) DEFAULT NULL,
  `role_id` smallint(6) DEFAULT NULL,
  `role_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `remote_id` (`remote_id`),
  CONSTRAINT `user_profile_user_id_8fdce8e2_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=592 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_profile`
--

INSERT INTO `user_profile` VALUES (433,'','84aaa87f-9a87-4922-9d3c-8ebba871a87r',1,1,'root',434),(434,'','84aaa87f-9a87-4922-9d3c-8ebba871a87g',2,2,'admin',435),(435,'0727903937','cf863296-405b-484f-a5b5-53dde10a2804',212,31,'medic',436),(436,'0724966366','b81896e6-bcf6-4026-964d-2948ab6bde72',213,35,'plantratament',437),(437,'0766540568','05715fea-65ac-4370-84e0-47d7d5464b49',215,31,'medic',438),(438,'0741696817','0ea26429-3866-451f-be3f-645f25b38aa2',216,35,'plantratament',439),(439,'0769911218','f37fc09b-814f-482e-b95c-3e5cf0870e2a',217,31,'medic',440),(440,'0743333122','dd043884-e1d0-4eee-b097-a843f5f132a4',218,31,'medic',441),(441,'0726265254','3d6fe2b3-87c1-4116-ae4e-d1e1122f46d1',219,31,'medic',442),(442,'0746891954','ba49351e-a1bd-4e2c-b626-bf0add16aec8',224,35,'plantratament',443),(443,'0755236027','e93d7df8-e92d-4462-aa50-6ff968ea30ee',225,33,'receptioner',444),(444,'0721479067','82edf032-ce5b-4d73-840a-5befa96cacbe',226,31,'medic',445),(445,'0761322448','a85fa92d-74c6-4c98-95ed-550acca5b45c',227,33,'receptioner',446),(446,'0726474118','3e05ab1a-fbb0-40f9-a744-cdd4cf5ed4c7',228,31,'medic',447),(447,'0769982007','1315eaea-d28d-4de7-9f19-eed6764c788e',229,38,'asistenta',448),(448,'0729123851','4ff72729-ff9a-4bb2-9823-af4731b2024d',230,31,'medic',449),(449,'0744237699','c5ef1b30-7d86-4d07-877c-58ccec689c0c',231,31,'medic',450),(450,'0766320441','94a6efcf-34c1-49fc-a2e1-5c79341344b0',232,35,'plantratament',451),(451,'0747891938','2e0f73ce-06d3-421d-ad87-73ed2b0b414b',233,31,'medic',452),(452,'0741984630','3c88c2c2-4066-42f2-a9e6-6ff062f8041a',234,31,'medic',453),(453,'0722591835','7a7c4005-ad2b-405d-9b2a-0118659be68d',235,31,'medic',454),(454,'0770448643','97c24aaa-6b05-4f6b-b595-ac03482e60f5',236,31,'medic',455),(455,'0746130685','b49117a6-5f5d-472b-99a7-77a053213dae',237,31,'medic',456),(456,'0738311005','bab224e3-8663-44d7-8a62-1abc325d4496',238,38,'asistenta',457),(457,'0721251626','fa9213d9-76fb-4e29-8ce5-b0d3667a3916',239,37,'scaner',458),(458,'0765211939','0efe4c7b-6a2a-425c-a3e6-e1c89712cff5',240,38,'asistenta',459),(459,'0753335078','f2f0a05e-c3b3-4ab3-bf26-77e771593f37',241,29,'manager',460),(460,'0722612137','69fd0e72-495b-4ae1-bfaf-db11c57f5a5d',242,38,'asistenta',461),(461,'0761979725','4032652f-9c10-449f-b954-de133e262ac6',243,38,'asistenta',462),(462,'0742129915','d41f1d5d-5247-4051-bd33-c176ec528586',244,34,'curatenie',463),(463,'0741963942','3560f772-a23a-41f5-a72a-fd79cd06d4e4',245,34,'curatenie',464),(464,'0747811278','44cec71d-d310-499f-9537-baa5aa1b8302',246,38,'asistenta',465),(465,'0744572336','1375b0de-a665-4b0d-8866-0e51336e2780',247,38,'asistenta',466),(466,'0745412549','d9266db5-dccb-4824-a0b9-44bb07f3ab27',248,38,'asistenta',467),(467,'0786310311','3f823fb7-73e3-4b61-93ae-ce863811822f',249,38,'asistenta',468),(468,'0746525503','405cb0df-17b3-414e-bb4b-65a912c5a1c7',250,38,'asistenta',469),(469,'0736822929','aeb2da97-6fcf-40bb-88e7-2cec0ea3e973',251,38,'asistenta',470),(470,'0765328728','6f320e26-c4d0-4e53-9517-494ee62c26b2',252,38,'asistenta',471),(471,'0748297178','55f0d499-ade0-4fb8-8a8b-6cf9ade954d2',253,33,'receptioner',472),(472,'0769290199','7b017ba2-edd4-4001-8dd8-3c27a9f4eae1',254,38,'asistenta',473),(473,'0730939122','2efbf37b-eb88-4ca9-8d17-f0350feb1ebd',255,33,'receptioner',474),(474,'0771786361','eced6ef4-a941-4a00-b949-56d4fbaab12f',256,34,'curatenie',475),(475,'0765389113','b1127c3a-c300-4202-ac3c-f7e5f73fa178',257,38,'asistenta',476),(476,'0745566699','2e0eeb78-ae59-450c-bd1b-ae2a2e5692e8',258,38,'asistenta',477),(477,'0760065126','7c360dd3-08de-41ad-87e4-75ed05f0f5d9',259,38,'asistenta',478),(478,'0721440771','bd223489-2cda-4246-99e6-93c5e356c23f',260,34,'curatenie',479),(479,'0765685431','b1022c4c-387d-48f1-a430-634187905ef1',261,31,'medic',480),(480,'0745326918','283a44de-bb4e-43e1-89e2-91b951be2350',262,31,'medic',481),(481,'0766107724','b52f050c-1f28-412e-8817-0508b2880602',263,31,'medic',482),(482,'0752697710','c7d4cc2b-5d65-415c-a913-de6dd4a316da',264,31,'medic',483),(483,'0749600211','3787efd0-0140-4bc8-8731-5f2e7dd53715',265,31,'medic',484),(484,'0765729005','5e83a051-cbc8-48d9-bc28-66473dc44564',267,38,'asistenta',485),(485,'0768841820','5edc76d1-debd-438c-8bc4-132e0426da9c',268,37,'scaner',486),(486,'0762566413','40d04bcc-0417-47ce-b60a-6ae0490a2dba',269,38,'asistenta',487),(487,'0771436305','481af462-4d8d-416d-a56d-1f8f2fc24a47',270,34,'curatenie',488),(488,'0764277414','efcf1d59-2fb2-4817-b66d-71f4fdb33b93',271,33,'receptioner',489),(489,'0763615431','e67262c2-f932-44fe-9c59-1c4d0e33cab2',272,38,'asistenta',490),(490,'0748591074','f3856a5f-2433-4ee7-818d-43f9d9aad9be',273,38,'asistenta',491),(491,'0757452650','b712d2e2-9e78-4042-9d8b-45aa567e51fd',274,38,'asistenta',492),(492,'0763791175','1e773dc4-0397-4599-b18f-3b98e054bd5e',275,38,'asistenta',493),(493,'0763833191','01b2cd3b-4e18-4d34-b840-c8440e7c69ba',276,38,'asistenta',494),(494,'0770352449','539dc69b-d8bc-4a9d-98b2-f34a8c98a6e4',277,34,'curatenie',495),(495,'0762566413','642b19c9-c7cc-46ba-ab79-5d80a137f10b',278,36,'radiolog',496),(496,'0736822929','7535aca2-33d7-47cc-9795-6314e2b4f67a',279,36,'radiolog',497),(497,'0738311005','7cdc663b-667f-4fe3-9f59-6666f42a813e',280,36,'radiolog',498),(498,'0761979725','62435c75-50b9-4a53-885e-8c52870582c7',281,36,'radiolog',499),(499,'0726267501','e8a7d2aa-75bd-4a46-bd30-6eaf5bc139a3',282,33,'receptioner',500),(500,NULL,NULL,NULL,NULL,NULL,501),(501,NULL,NULL,NULL,NULL,NULL,502),(502,NULL,NULL,NULL,NULL,NULL,503),(503,NULL,NULL,NULL,NULL,NULL,504),(504,NULL,NULL,NULL,NULL,NULL,505),(505,NULL,NULL,NULL,NULL,NULL,506),(506,NULL,NULL,NULL,NULL,NULL,507),(507,NULL,NULL,NULL,NULL,NULL,508),(508,NULL,NULL,NULL,NULL,NULL,509),(509,NULL,NULL,NULL,NULL,NULL,510),(510,NULL,NULL,NULL,NULL,NULL,511),(511,NULL,NULL,NULL,NULL,NULL,512),(512,NULL,NULL,NULL,NULL,NULL,513),(513,NULL,NULL,NULL,NULL,NULL,514),(514,NULL,NULL,NULL,NULL,NULL,515),(515,NULL,NULL,NULL,NULL,NULL,519),(516,NULL,NULL,NULL,NULL,NULL,520),(517,NULL,NULL,NULL,NULL,NULL,521),(518,NULL,NULL,NULL,NULL,NULL,522),(519,NULL,NULL,NULL,NULL,NULL,523),(520,NULL,NULL,NULL,NULL,NULL,524),(521,NULL,NULL,NULL,NULL,NULL,525),(522,NULL,NULL,NULL,NULL,NULL,526),(523,NULL,NULL,NULL,NULL,NULL,528),(524,NULL,NULL,NULL,NULL,NULL,529),(525,NULL,NULL,NULL,NULL,NULL,530),(526,NULL,NULL,NULL,NULL,NULL,531),(527,NULL,NULL,NULL,NULL,NULL,532),(528,NULL,NULL,NULL,NULL,NULL,533),(529,NULL,NULL,NULL,NULL,NULL,534),(530,NULL,NULL,NULL,NULL,NULL,535),(531,NULL,NULL,NULL,NULL,NULL,536),(532,NULL,NULL,NULL,NULL,NULL,537),(533,NULL,NULL,NULL,NULL,NULL,538),(534,NULL,NULL,NULL,NULL,NULL,539),(535,NULL,NULL,NULL,NULL,NULL,540),(536,NULL,NULL,NULL,NULL,NULL,541),(537,NULL,NULL,NULL,NULL,NULL,542),(538,NULL,NULL,NULL,NULL,NULL,543),(539,NULL,NULL,NULL,NULL,NULL,550),(540,NULL,NULL,NULL,NULL,NULL,553),(541,NULL,NULL,NULL,NULL,NULL,557),(542,NULL,NULL,NULL,NULL,NULL,558),(543,NULL,NULL,NULL,NULL,NULL,559),(544,NULL,NULL,NULL,NULL,NULL,560),(545,NULL,NULL,NULL,NULL,NULL,561),(546,NULL,NULL,NULL,NULL,NULL,564),(547,NULL,NULL,NULL,NULL,NULL,565),(548,NULL,NULL,NULL,NULL,NULL,566),(549,NULL,NULL,NULL,NULL,NULL,567),(550,NULL,NULL,NULL,NULL,NULL,568),(551,NULL,NULL,NULL,NULL,NULL,569),(552,NULL,NULL,NULL,NULL,NULL,570),(553,NULL,NULL,NULL,NULL,NULL,571),(554,NULL,NULL,NULL,NULL,NULL,572),(555,NULL,NULL,NULL,NULL,NULL,573),(556,NULL,NULL,NULL,NULL,NULL,574),(557,NULL,NULL,NULL,NULL,NULL,577),(558,NULL,NULL,NULL,NULL,NULL,580),(559,NULL,NULL,NULL,NULL,NULL,582),(560,NULL,NULL,NULL,NULL,NULL,583),(561,NULL,NULL,NULL,NULL,NULL,584),(562,NULL,NULL,NULL,NULL,NULL,585),(563,NULL,NULL,NULL,NULL,NULL,586),(564,'0753838502','38821e95-78b1-438a-a8e2-08043e9f286b',283,38,'asistenta',587),(565,'0752029507','40e483ff-4c67-4014-baeb-46b8e6a74f59',284,35,'plantratament',588),(566,'0720194875','5ad13f82-469f-4e99-999f-a9e1aa52f566',285,31,'medic',589),(567,'0723319980','cf3e63a6-d45f-47ef-91fc-aa2f2d3451c0',286,35,'plantratament',590),(568,'0732294778','348c35fd-ad66-4a2b-b404-167f1f269001',287,35,'plantratament',591),(569,'0723683890','9866d5a3-775a-445c-a80b-1ff76f1db74c',288,31,'medic',592),(570,'0784305521','6c5da9fe-7044-4d6f-a7ad-76e65895005a',289,31,'medic',593),(571,'0765871429','8908db3f-e7d9-418c-90d8-96ef672c5020',290,31,'medic',594),(572,'0769216893','eecd50ac-4139-48b1-a6ee-fe6b4655b1cc',291,31,'medic',595),(573,'0769506190','c218cf5f-af5f-4844-9a0c-12140c49d94d',292,31,'medic',596),(574,'0726281901','56af7a44-cb90-43a2-be2a-e5bcdcafcdf4',293,31,'medic',597),(575,'0724246162','92c19670-f0f6-48ab-b87a-d34795b6c2ad',297,31,'medic',598),(576,'0742015564','35d1b703-8284-4393-bb60-166a0e5d9b84',298,31,'medic',599),(577,'0736810079','89cf633e-19ec-40b8-a084-e6af61c908e8',299,37,'scaner',600),(578,'0738831568','0dbedfcd-dcd2-46d2-ad4b-7f773e83ba0e',300,37,'scaner',601),(579,'0787341872','b3cf273e-8a21-4d18-a203-9aa01aac2dc6',301,33,'receptioner',602),(580,'0736810079','c8c1ba69-cde4-4f65-89ae-5305e9db6797',302,37,'scaner',603),(581,'0762616096','f06ac394-5138-4f38-8dd9-70f1e352c918',303,37,'scaner',604),(582,'0723587577','68f5d593-9fc5-44f3-a659-9eb70c454247',304,33,'receptioner',605),(583,'0721816481','ce68fbb6-8386-460e-982c-48cd7b2bb396',305,33,'receptioner',606),(584,'0735229892','251dae06-f293-422d-a357-df7f2bef95f8',306,37,'scaner',607),(585,'0771635226','6325da7d-082c-4f9e-8f28-a1327300eaf7',307,37,'scaner',608),(586,NULL,NULL,NULL,NULL,NULL,609),(587,NULL,NULL,NULL,NULL,NULL,610),(588,NULL,NULL,NULL,NULL,NULL,611),(589,NULL,NULL,NULL,NULL,NULL,612),(590,NULL,NULL,NULL,NULL,NULL,613),(591,NULL,NULL,NULL,NULL,NULL,614);

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `untouchable` tinyint(1) NOT NULL DEFAULT 0,
  `custom` tinyint(3) unsigned DEFAULT NULL,
  `srt` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lft` (`srt`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` VALUES (1,'root',1,0,1),(2,'admin',1,0,1),(29,'manager',0,0,2),(30,'tehnician',0,1,4),(31,'medic',0,0,3),(33,'receptioner',0,0,5),(34,'curatenie',0,1,6),(35,'plantratament',0,NULL,7),(36,'radiolog',0,NULL,8),(37,'scaner',0,NULL,9),(38,'asistenta',0,1,10);

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `id_user` int(11) NOT NULL,
  `id_role` int(11) NOT NULL,
  UNIQUE KEY `id_role` (`id_role`,`id_user`),
  KEY `role` (`id_role`),
  KEY `user` (`id_user`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_roles`
--

INSERT INTO `user_roles` VALUES (1,1),(2,2),(6,29),(199,29),(211,29),(224,29),(236,29),(241,29),(5,30),(194,30),(195,30),(196,30),(197,30),(198,30),(6,31),(16,31),(211,31),(212,31),(215,31),(216,31),(217,31),(218,31),(219,31),(220,31),(223,31),(224,31),(226,31),(228,31),(230,31),(231,31),(232,31),(233,31),(234,31),(235,31),(236,31),(237,31),(261,31),(262,31),(263,31),(264,31),(265,31),(194,33),(210,33),(221,33),(225,33),(227,33),(253,33),(255,33),(268,33),(271,33),(282,33),(244,34),(245,34),(256,34),(260,34),(270,34),(277,34),(213,35),(214,36),(222,36),(278,36),(279,36),(280,36),(281,36),(239,37),(229,38),(238,38),(240,38),(242,38),(243,38),(246,38),(247,38),(248,38),(249,38),(250,38),(251,38),(252,38),(254,38),(257,38),(258,38),(259,38),(267,38),(269,38),(272,38),(273,38),(274,38),(275,38),(276,38);

--
-- Table structure for table `vlab_sedii`
--

CREATE TABLE `vlab_sedii` (
  `id` int(7) NOT NULL AUTO_INCREMENT,
  `id_firma` int(7) NOT NULL,
  `id_judet` int(7) NOT NULL,
  `id_oras` int(7) NOT NULL,
  `flag_dental_clone` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `implanturi` varchar(255) DEFAULT NULL,
  `ceramica` varchar(255) DEFAULT NULL,
  `scanner` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `amprenta` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `name` varchar(150) NOT NULL,
  `strada` varchar(150) NOT NULL,
  `nr_strada` varchar(10) NOT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `lat` decimal(18,16) NOT NULL DEFAULT 0.0000000000000000,
  `lng` decimal(18,16) NOT NULL DEFAULT 0.0000000000000000,
  `zoom` tinyint(2) NOT NULL DEFAULT 7,
  `uid` varchar(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_firma` (`id_firma`),
  KEY `id_judet` (`id_judet`),
  KEY `id_oras` (`id_oras`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vlab_sedii`
--

INSERT INTO `vlab_sedii` VALUES (6,2,23,6907,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Pitesti','NEGRU VODĂ','4','0348434436',44.8630631541379800,24.8653006969266280,17,'7fd6fcda-ecbb-4c0c-98e3-64fe5d534d67'),(7,2,27,8544,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Valcea','Stirbei Voda','7','',45.1036981748088400,24.3602943420410200,13,'3a539bb6-0175-45e8-bff3-7d15c8e19267'),(15,2,42,13361,1,'','',0,0,'VICTORIA DENTAL OFFICES SRL - Slatina','Una','10','',44.4299415423587260,24.3640510911894240,17,'adf9f4fb-d4b5-4840-ba7f-2e846a812174'),(16,2,9,2715,1,NULL,NULL,0,0,'VICTORIA DENTAL OFFICES -  Bucuresti','Bulevardul Vasile Milea','10','0722457856',44.4358746656060900,26.1038838888498430,16,'a2353aa3-9b03-46dc-b2cc-6fa8bf0c499c'),(17,2,5,1414,1,NULL,NULL,0,0,'VICTORIA DENTAL OFFICES - Targoviste','Bulevardul Libertatii','3','0722457856',44.9291195270580300,25.4586973498359200,13,'a26356e4-96e9-4348-9c9c-bc9cb818d01a');

--
-- Table structure for table `vlab_user`
--

CREATE TABLE `vlab_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(70) COLLATE utf8_romanian_ci DEFAULT NULL,
  `username` varchar(100) COLLATE utf8_romanian_ci DEFAULT NULL,
  `email` varchar(70) COLLATE utf8_romanian_ci DEFAULT NULL,
  `password` varchar(32) COLLATE utf8_romanian_ci DEFAULT NULL,
  `cif` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8_romanian_ci NOT NULL,
  `locked` tinyint(1) DEFAULT 0,
  `valid` tinyint(1) NOT NULL DEFAULT 0,
  `ip` varchar(15) COLLATE utf8_romanian_ci DEFAULT NULL,
  `date_signup` int(12) DEFAULT NULL,
  `date_llogin` int(12) DEFAULT NULL,
  `uid` varchar(36) COLLATE utf8_romanian_ci NOT NULL DEFAULT '',
  `token` varchar(60) COLLATE utf8_romanian_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `uid` (`cif`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=308 DEFAULT CHARSET=utf8 COLLATE=utf8_romanian_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `vlab_user`
--

INSERT INTO `vlab_user` VALUES (1,'Ionut Dogaru','ionut.dogaru','ionut.dogaru@gmail.com','7815696ecbf1c96e6894b779456d330e','u5283a88f5438a','',0,0,NULL,NULL,1596441462,'84aaa87f-9a87-4922-9d3c-8ebba871a87r',''),(2,'victoria dental offices','admin@dentacloud.ro','admin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','u5283a88f5438b','',0,0,NULL,NULL,1640692301,'84aaa87f-9a87-4922-9d3c-8ebba871a87g',''),(212,'Calinescu Adrian','calinescu.adrian@medic','calinescu.adrian@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0727903937',0,0,'::1',1595772369,1628171768,'cf863296-405b-484f-a5b5-53dde10a2804',NULL),(213,'Plan Tratament','plan.tratament@plantratament','plantratament@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0724966366',0,1,'::1',1597385279,1629728999,'b81896e6-bcf6-4026-964d-2948ab6bde72',NULL),(215,'Fojica Radu','fojica.radu@medic','fojica.radu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766540568',0,1,'::1',1602333576,1632219287,'05715fea-65ac-4370-84e0-47d7d5464b49',NULL),(216,'Iordache Anamaria','iordache.anamaria@medic','anamaria.corcau@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0741696817',0,1,'::1',1602333622,1640689208,'0ea26429-3866-451f-be3f-645f25b38aa2',NULL),(217,'Istrate Alexandra','istrate.alexandra@medic','istrate.alexandra@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769911218',0,1,'::1',1602334202,1629786648,'f37fc09b-814f-482e-b95c-3e5cf0870e2a',NULL),(218,'Damian Alexandra','damian.alexandra@medic','damian.alexandra@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0743333122',0,1,'::1',1602334286,1627285596,'dd043884-e1d0-4eee-b097-a843f5f132a4',NULL),(219,'Craioveanu George','craioveanu.george@medic','craioveanu.george@dentacloud.ro',NULL,'','0726265254',0,1,'::1',1602334315,1602334215,'3d6fe2b3-87c1-4116-ae4e-d1e1122f46d1',NULL),(224,'Maris Liana','maris.liana@medic','maris.liana@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0746891954',0,1,'5.2.164.147',1615536317,1640771935,'ba49351e-a1bd-4e2c-b626-bf0add16aec8',NULL),(225,'Badescu Elena','badescu.elena@receptioner','badescu.elena@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0755236027',0,1,'5.2.164.147',1615536521,1634302138,'e93d7df8-e92d-4462-aa50-6ff968ea30ee',NULL),(226,'Iconaru Ecaterina','iconaru.ecaterina@medic','iconaru.kati@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0721479067',0,1,'5.2.164.147',1615536638,1615537483,'82edf032-ce5b-4d73-840a-5befa96cacbe',NULL),(227,'Pestritu Adelina','pestritu.adelina@receptioner','pestritu.adelina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0761322448',0,1,'5.2.164.147',1615536795,1632219349,'a85fa92d-74c6-4c98-95ed-550acca5b45c',NULL),(228,'Todea Cosmin','todea.cosmin@medic','todea.cosmin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0726474118',0,1,'5.2.164.147',1615536873,1621238896,'3e05ab1a-fbb0-40f9-a744-cdd4cf5ed4c7',NULL),(229,'Gheorghe Ramona','gheorghe.ramona@asistenta','gheorghe.ramona@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769982007',0,1,'5.2.164.147',1615536964,1615536988,'1315eaea-d28d-4de7-9f19-eed6764c788e',NULL),(230,'Comanescu Florin','comanescu.florin@medic','comanescu.florin@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0729123851',0,1,'5.2.164.147',1615538993,1623656902,'4ff72729-ff9a-4bb2-9823-af4731b2024d',NULL),(231,'Comanescu Ligia','comanescu.ligia@medic','comanescu.ligia@dentacloud.ro',NULL,'','0744237699',0,1,'5.2.164.147',1615539045,1615538945,'c5ef1b30-7d86-4d07-877c-58ccec689c0c',NULL),(232,'Iancu Simona','iancu.simona@medic','iancu.simona@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766320441',0,1,'5.2.164.147',1615539186,1637310092,'94a6efcf-34c1-49fc-a2e1-5c79341344b0',NULL),(233,'Mihailescu Mihai','mihailescu.mihai@medic','mihailescu.mihai@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0747891938',0,1,'5.2.164.147',1615539256,1624520963,'2e0f73ce-06d3-421d-ad87-73ed2b0b414b',NULL),(234,'Niculescu Elena','niculescu.elena@medic','niculescu.elena@dentacloud.ro',NULL,'','0741984630',0,1,'5.2.164.147',1615539322,1615539222,'3c88c2c2-4066-42f2-a9e6-6ff062f8041a',NULL),(235,'Traistaru Andu','traistaru.andu@medic','traistaru.andu@dentacloud.ro',NULL,'','0722591835',0,1,'5.2.164.147',1615540816,1615540716,'7a7c4005-ad2b-405d-9b2a-0118659be68d',NULL),(236,'Ionita Bogdan','ionita.bogdan@manager','ionita.bogdan@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0770448643',0,1,'5.2.164.147',1615540949,1640159307,'97c24aaa-6b05-4f6b-b595-ac03482e60f5',NULL),(237,'Stanciu Mihai','stanciu.mihai@medic','stanciu.mihai@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0746130685',0,1,'5.2.164.147',1615541286,1633679908,'b49117a6-5f5d-472b-99a7-77a053213dae',NULL),(238,'Soare Camelia','soare.camelia@asistenta','soare.camelia@dentacloud.ro',NULL,'','0738311005',0,1,'5.2.164.147',1615542117,1615542017,'bab224e3-8663-44d7-8a62-1abc325d4496',NULL),(239,'Voicu Andreea','voicu.andreea@scaner','voicu.andreea@dentacloud.ro',NULL,'','0721251626',0,1,'5.2.164.147',1615542223,1615542123,'fa9213d9-76fb-4e29-8ce5-b0d3667a3916',NULL),(240,'Cirstea Anca','cirstea.anca@asistenta','cirstea.anca@dentacloud.ro',NULL,'','0765211939',0,1,'5.2.164.147',1615542283,1615542183,'0efe4c7b-6a2a-425c-a3e6-e1c89712cff5',NULL),(241,'Tirlea Corina','tirlea.corina@manager','tirlea.corina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0753335078',0,1,'5.2.164.147',1615542499,1626947527,'f2f0a05e-c3b3-4ab3-bf26-77e771593f37',NULL),(242,'Deleanu Oana','deleanu.oana@asistenta','deleanu.oana@dentacloud.ro',NULL,'','0722612137',0,1,'5.2.164.147',1615542792,1615542692,'69fd0e72-495b-4ae1-bfaf-db11c57f5a5d',NULL),(243,'Ivan Elena','ivan.elena@asistenta','ivan.elena@dentacloud.ro',NULL,'','0761979725',0,1,'5.2.164.147',1615542854,1615542754,'4032652f-9c10-449f-b954-de133e262ac6',NULL),(244,'Olteanu Nicoleta','olteanu.nicoleta@curatenie','olteanu.nicoleta@dentacloud.ro',NULL,'','0742129915',0,1,'5.2.164.147',1615543039,1615542939,'d41f1d5d-5247-4051-bd33-c176ec528586',NULL),(245,'Costescu Valerica','costescu.valerica@curatenie','costescu.valerica@dentacloud.ro',NULL,'','0741963942',0,1,'5.2.164.147',1615543091,1615542991,'3560f772-a23a-41f5-a72a-fd79cd06d4e4',NULL),(246,'Petcu Ruxandra','petcu.ruxandra@asistenta','petcu.ruxandra@dentacloud.ro',NULL,'','0747811278',0,1,'5.2.164.147',1615543364,1615543264,'44cec71d-d310-499f-9537-baa5aa1b8302',NULL),(247,'Radu Ionela','radu.ionela@asistenta','radu.ionela@dentacloud.ro',NULL,'','0744572336',0,1,'5.2.164.147',1615543426,1615543326,'1375b0de-a665-4b0d-8866-0e51336e2780',NULL),(248,'Rapeanu Ana Maria','rapeanu.ana.maria@asistenta','rapeanu.anamaria@dentacloud.ro',NULL,'','0745412549',0,1,'5.2.164.147',1615543516,1615543416,'d9266db5-dccb-4824-a0b9-44bb07f3ab27',NULL),(249,'Stefanoiu Irina','stefanoiu.irina@asistenta','stefanoiu.irina@dentacloud.ro',NULL,'','0786310311',0,1,'5.2.164.147',1615543601,1615543501,'3f823fb7-73e3-4b61-93ae-ce863811822f',NULL),(250,'Udroiu Madalina','udroiu.madalina@asistenta','udroiu.madalina@dentacloud.ro',NULL,'','0746525503',0,1,'5.2.164.147',1615543657,1615543557,'405cb0df-17b3-414e-bb4b-65a912c5a1c7',NULL),(251,'Barbu Antoaneta','barbu.antoaneta@asistenta','barbu.antoaneta@dentacloud.ro',NULL,'','0736822929',0,1,'5.2.164.147',1615544238,1615544138,'aeb2da97-6fcf-40bb-88e7-2cec0ea3e973',NULL),(252,'Bulagea Mihaela','bulagea.mihaela@asistenta','bulagea.mihaela@dentacloud.ro',NULL,'','0765328728',0,1,'5.2.164.147',1615544708,1615544608,'6f320e26-c4d0-4e53-9517-494ee62c26b2',NULL),(253,'Brandiburu Larisa','brandiburu.larisa@receptioner','brandiburu.larisa@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0748297178',0,1,'5.2.164.147',1615544793,1634915881,'55f0d499-ade0-4fb8-8a8b-6cf9ade954d2',NULL),(254,'Coada Alina','coada.alina@asistenta','coada.alina@dentacloud.ro',NULL,'','0769290199',0,1,'5.2.164.147',1615544834,1615544734,'7b017ba2-edd4-4001-8dd8-3c27a9f4eae1',NULL),(255,'Constantinescu Lavinia','constantinescu.lavinia@receptioner','constantinescu.lavinia@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0730939122',0,1,'5.2.164.147',1615545087,1618999392,'2efbf37b-eb88-4ca9-8d17-f0350feb1ebd',NULL),(256,'Doditoiu Maria','doditoiu.maria@curatenie','doditoiu.maria@dentacloud.ro',NULL,'','0771786361',0,1,'5.2.164.147',1615545151,1615545051,'eced6ef4-a941-4a00-b949-56d4fbaab12f',NULL),(257,'Mutica Mihaela','mutica.mihaela@asistenta','mutica.mihaela@dentacloud.ro',NULL,'','0765389113',0,1,'5.2.164.147',1615545201,1615545101,'b1127c3a-c300-4202-ac3c-f7e5f73fa178',NULL),(258,'Neacsa Mihaela','neacsa.mihaela@asistenta','neacsa.mihaela@dentacloud.ro',NULL,'','0745566699',0,1,'5.2.164.147',1615545377,1615545277,'2e0eeb78-ae59-450c-bd1b-ae2a2e5692e8',NULL),(259,'Nitu Aliora','nitu.aliora@asistenta','nitu.aliora@dentacloud.ro',NULL,'','0760065126',0,1,'5.2.164.147',1615545423,1615545323,'7c360dd3-08de-41ad-87e4-75ed05f0f5d9',NULL),(260,'Sima Nicoleta','sima.nicoleta@curatenie','sima.nicoleta@dentacloud.ro',NULL,'','0721440771',0,1,'5.2.164.147',1615545481,1615545381,'bd223489-2cda-4246-99e6-93c5e356c23f',NULL),(261,'Zamfirescu Laura','zamfirescu.laura@medic','zamfirescu.laura@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0765685431',0,1,'5.2.164.147',1615548140,1624520867,'b1022c4c-387d-48f1-a430-634187905ef1',NULL),(262,'Penzes Alexandru','penzes.alexandru@medic','penzes.alexandru@dentacloud.ro',NULL,'','0745326918',0,1,'5.2.164.147',1615548185,1615548085,'283a44de-bb4e-43e1-89e2-91b951be2350',NULL),(263,'Baranguta Alina','baranguta.alina@medic','baranguta.alina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0766107724',0,1,'5.2.164.147',1615548234,1621590043,'b52f050c-1f28-412e-8817-0508b2880602',NULL),(264,'Rosca Adrian','rosca.adrian@medic','rosca.adrian@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0752697710',0,1,'5.2.164.147',1615548313,1623918770,'c7d4cc2b-5d65-415c-a913-de6dd4a316da',NULL),(265,'Popa Ana Maria','popa.ana.maria@medic','popa.anamaria@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0749600211',0,1,'5.2.164.147',1615548883,1624526158,'3787efd0-0140-4bc8-8731-5f2e7dd53715',NULL),(267,'Barbulescu Sabin','barbulescu.sabin@asistenta','barbulescu.sabin@dentacloud.ro',NULL,'','0765729005',0,1,'5.2.164.147',1615549465,1615549365,'5e83a051-cbc8-48d9-bc28-66473dc44564',NULL),(268,'Calota Adelina','calota.adelina@receptioner','calota.adelina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0768841820',0,1,'5.2.164.147',1615549561,1640707391,'5edc76d1-debd-438c-8bc4-132e0426da9c',NULL),(269,'Cojocaru Mihaela','cojocaru.mihaela@radiolog','cojocaru.mihaela@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0762566413',0,1,'5.2.164.147',1615549620,1617188113,'40d04bcc-0417-47ce-b60a-6ae0490a2dba',NULL),(270,'Lungu Stefania','lungu.stefania@curatenie','lungu.stefania@dentacloud.ro',NULL,'','0771436305',0,1,'5.2.164.147',1615550077,1615549977,'481af462-4d8d-416d-a56d-1f8f2fc24a47',NULL),(271,'Mazilu Cristina','mazilu.cristina@receptioner','mazilu.cristina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0764277414',0,1,'5.2.164.147',1615550134,1625742193,'efcf1d59-2fb2-4817-b66d-71f4fdb33b93',NULL),(272,'Odagiu Ramona','odagiu.ramona@asistenta','odagiu.ramona@dentacloud.ro',NULL,'','0763615431',0,1,'5.2.164.147',1615550217,1615550117,'e67262c2-f932-44fe-9c59-1c4d0e33cab2',NULL),(273,'Popa Nicoleta','popa.nicoleta@asistenta','popa.nicoleta@dentacloud.ro',NULL,'','0748591074',0,1,'5.2.164.147',1615550267,1615550167,'f3856a5f-2433-4ee7-818d-43f9d9aad9be',NULL),(274,'Ristea Madalina','ristea.madalina@asistenta','ristea.madalina@dentacloud.ro',NULL,'','0757452650',0,1,'5.2.164.147',1615550332,1615550232,'b712d2e2-9e78-4042-9d8b-45aa567e51fd',NULL),(275,'Ungureanu Cristina','ungureanu.cristina@asistenta','ungureanu.cristina@dentacloud.ro',NULL,'','0763791175',0,1,'5.2.164.147',1615550404,1615550304,'1e773dc4-0397-4599-b18f-3b98e054bd5e',NULL),(276,'Tandarica Irina','tandarica.irina@receptioner','tandarica.irina@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0763833191',0,1,'5.2.164.147',1615550512,1631093968,'01b2cd3b-4e18-4d34-b840-c8440e7c69ba',NULL),(277,'Vilcica Veronica','vilcica.veronica@curatenie','vilcica.veronica@dentacloud.ro',NULL,'','0770352449',0,1,'5.2.164.147',1615550554,1615550454,'539dc69b-d8bc-4a9d-98b2-f34a8c98a6e4',NULL),(278,'Cojocaru Mihaela','cojocaru.mihaela@radiolog','cojocaru.mihaela.radiolog@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0762566413',0,1,'5.2.164.147',1615550951,1617087590,'642b19c9-c7cc-46ba-ab79-5d80a137f10b',NULL),(279,'Barbu Antoaneta','barbu.antoaneta@radiolog','barbu.antoaneta.radiolog@dentacloud.ro',NULL,'','0736822929',0,1,'5.2.164.147',1615551025,1615550925,'7535aca2-33d7-47cc-9795-6314e2b4f67a',NULL),(280,'Soare Camelia','soare.camelia@radiolog','soare.camelia.radiolog@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0738311005',0,1,'5.2.164.147',1615551138,1615640947,'7cdc663b-667f-4fe3-9f59-6666f42a813e',NULL),(281,'Ivan Elena','ivan.elena@radiolog','ivan.elena.radiolog@dentacloud.ro',NULL,'','0761979725',0,1,'5.2.164.147',1615551198,1615551098,'62435c75-50b9-4a53-885e-8c52870582c7',NULL),(282,'Banu Mirela','banu.mirela@receptioner','banu.mirela@dentacloud.ro',NULL,'','0726267501',0,1,'5.2.164.147',1615551786,1615551686,'e8a7d2aa-75bd-4a46-bd30-6eaf5bc139a3',NULL),(283,'Mitrache Claudia','mitrache.claudia@receptioner','mitrache.claudia@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0753838502',0,1,'5.2.164.147',1626946517,1628159070,'38821e95-78b1-438a-a8e2-08043e9f286b',NULL),(284,'Andreea Smarandoiu','andreea.smarandoiu@medic','andreea.smarandoiu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0752029507',0,1,'5.2.164.147',1629469569,1637896789,'40e483ff-4c67-4014-baeb-46b8e6a74f59',NULL),(285,'Corodescu Simona','corodescu.simona@manager','simona.corodescu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0720194875',0,1,'5.2.164.147',1630336877,1640847642,'5ad13f82-469f-4e99-999f-a9e1aa52f566',NULL),(286,'Ioana Matei','ioana.matei@medic','ioana.matei@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0723319980',0,1,'5.2.164.147',1630337051,1640775584,'cf3e63a6-d45f-47ef-91fc-aa2f2d3451c0',NULL),(287,'Blebea Doinita','blebea.doinita@medic','doinita.blebea@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0732294778',0,1,'92.83.158.186',1630477490,1630481424,'348c35fd-ad66-4a2b-b404-167f1f269001',NULL),(288,'Zaharia Mirela','zaharia.mirela@manager','mirela.zaharia@dentacloud.ro','9392ab575b6a2f532b327f42e2577050','','0723683890',0,1,'92.83.158.186',1637742406,1638201786,'9866d5a3-775a-445c-a80b-1ff76f1db74c',NULL),(289,'Ciongaru Dragos','ciongaru.dragos@medic','dragos.ciongaru@dentacloud.ro','f62ff60199bb9293c726631b4e28b025','','0784305521',0,1,'92.83.158.186',1637742495,1640775730,'6c5da9fe-7044-4d6f-a7ad-76e65895005a',NULL),(290,'Antoci Adina Alexandra','antoci.adina.alexandra@medic','adina.antoci@dentacloud.ro',NULL,'','0765871429',0,1,'92.83.158.186',1637742818,1637742718,'8908db3f-e7d9-418c-90d8-96ef672c5020',NULL),(291,'Bazavan Adina','bazavan.adina@medic','adina.bazavan@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769216893',0,1,'92.83.158.186',1637742918,1639332441,'eecd50ac-4139-48b1-a6ee-fe6b4655b1cc',NULL),(292,'Daniel Florin Radu','daniel.florin.radu@medic','daniel.radu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0769506190',0,1,'92.83.158.186',1637743080,1640772251,'c218cf5f-af5f-4844-9a0c-12140c49d94d',NULL),(293,'Maria Dumitru','maria.dumitru@medic','maria.dumitru@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0726281901',0,1,'92.83.158.186',1637743286,1640778491,'56af7a44-cb90-43a2-be2a-e5bcdcafcdf4',NULL),(297,'Cosma Ana','cosma.ana@medic','ana.cosma@dentacloud.ro',NULL,'','0724246162',0,1,'92.83.158.186',1637747468,1637747368,'92c19670-f0f6-48ab-b87a-d34795b6c2ad',NULL),(298,'Tudose Andreea Gabriela','tudose.andreea.gabriela@medic','andreea.tudose@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0742015564',0,1,'92.83.158.186',1637747549,1640776317,'35d1b703-8284-4393-bb60-166a0e5d9b84',NULL),(299,'Bianca','bianca@receptioner','bianca.receptie@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0736810079',0,1,'92.83.158.186',1637894374,1640768729,'89cf633e-19ec-40b8-a084-e6af61c908e8',NULL),(300,'Maria Oprea','maria.oprea@radiolog','maria.oprea@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0738831568',0,1,'82.76.174.58',1638788601,1638790549,'0dbedfcd-dcd2-46d2-ad4b-7f773e83ba0e',NULL),(301,'Giusepa Docescu','giusepa.docescu@receptioner','giusepa.docescu@dentacloud.ro','188c70fdac4b6c84d9f28d2add89d4a5','','0787341872',0,1,'82.76.174.58',1638956660,1640797783,'b3cf273e-8a21-4d18-a203-9aa01aac2dc6',NULL),(302,'Bianca Bobeica','bianca.bobeica@radiolog','bianca.bobeica@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0736810079',0,1,'82.76.174.58',1640767530,1640768829,'c8c1ba69-cde4-4f65-89ae-5305e9db6797',NULL),(303,'Ana-Maria Nicoara','ana-maria.nicoara@radiolog','ana.nicoara@dentacloud.ro',NULL,'','0762616096',0,1,'82.76.174.58',1640767625,1640767525,'f06ac394-5138-4f38-8dd9-70f1e352c918',NULL),(304,'Brezeanu Loredana','brezeanu.loredana@receptioner','loredana.brezeanu@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0723587577',0,1,'82.76.174.58',1640769450,1640775350,'68f5d593-9fc5-44f3-a659-9eb70c454247',NULL),(305,'Iordache Andreea Gabriela','iordache.andreea.gabriela@receptioner','andreea.iordache@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0721816481',0,1,'82.76.174.58',1640769541,1640770460,'ce68fbb6-8386-460e-982c-48cd7b2bb396',NULL),(306,'Ghita Alexandra Maria','ghita.alexandra.maria@radiolog','alexandra.ghita@dentacloud.ro','7815696ecbf1c96e6894b779456d330e','','0735229892',0,1,'82.76.174.58',1640769724,1640772129,'251dae06-f293-422d-a357-df7f2bef95f8',NULL),(307,'Stanciu Nicoleta Ionela','stanciu.nicoleta.ionela@radiolog','nicoleta.stanciu@dentacloud.ro',NULL,'','0771635226',0,1,'82.76.174.58',1640769807,1640769707,'6325da7d-082c-4f9e-8f28-a1327300eaf7',NULL);

--
-- Table structure for table `vlab_user_role`
--

CREATE TABLE `vlab_user_role` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `untouchable` tinyint(1) NOT NULL DEFAULT 0,
  `custom` tinyint(1) unsigned DEFAULT NULL,
  `srt` tinyint(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lft` (`srt`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `vlab_user_role`
--

INSERT INTO `vlab_user_role` VALUES (1,'root',1,0,1),(2,'admin',1,0,1),(29,'manager',0,0,2),(30,'tehnician',0,1,4),(31,'medic',0,0,3),(33,'receptioner',0,0,5),(34,'curatenie',0,1,6),(35,'plantratament',0,NULL,7),(36,'radiolog',0,NULL,8),(37,'scaner',0,NULL,9),(38,'asistenta',0,1,10);

--
-- Table structure for table `vlab_user_roles`
--

CREATE TABLE `vlab_user_roles` (
  `id_user` int(5) NOT NULL,
  `id_role` int(5) NOT NULL,
  UNIQUE KEY `id_role` (`id_role`,`id_user`),
  KEY `role` (`id_role`),
  KEY `user` (`id_user`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vlab_user_roles`
--

INSERT INTO `vlab_user_roles` VALUES (1,1),(2,2),(224,29),(236,29),(241,29),(285,29),(293,29),(212,31),(215,31),(216,31),(217,31),(218,31),(219,31),(224,31),(226,31),(228,31),(230,31),(231,31),(232,31),(233,31),(234,31),(235,31),(236,31),(237,31),(261,31),(262,31),(263,31),(264,31),(265,31),(284,31),(285,31),(286,31),(287,31),(288,31),(289,31),(290,31),(291,31),(292,31),(293,31),(297,31),(298,31),(225,33),(227,33),(253,33),(255,33),(268,33),(271,33),(276,33),(282,33),(283,33),(299,33),(301,33),(304,33),(305,33),(244,34),(245,34),(256,34),(260,34),(270,34),(277,34),(213,35),(216,35),(224,35),(232,35),(284,35),(286,35),(287,35),(268,36),(269,36),(278,36),(279,36),(280,36),(281,36),(299,36),(300,36),(302,36),(303,36),(306,36),(307,36),(239,37),(268,37),(299,37),(300,37),(302,37),(303,37),(306,37),(307,37),(229,38),(238,38),(240,38),(242,38),(243,38),(246,38),(247,38),(248,38),(249,38),(250,38),(251,38),(252,38),(254,38),(257,38),(258,38),(259,38),(267,38),(269,38),(272,38),(273,38),(274,38),(275,38),(276,38),(283,38);


