-- Table structure for table `ps_stock`
--

CREATE TABLE `ps_stock` (
  `id_stock` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(32) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `physical_quantity` int(11) unsigned NOT NULL,
  `usable_quantity` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_stock`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock`
--


--
-- Table structure for table `ps_stock_available`
--

CREATE TABLE `ps_stock_available` (
  `id_stock_available` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  `id_shop_group` int(11) unsigned NOT NULL,
  `quantity` int(10) NOT NULL DEFAULT '0',
  `depends_on_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `out_of_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_stock_available`),
  UNIQUE KEY `product_sqlstock` (`id_product`,`id_product_attribute`,`id_shop`,`id_shop_group`),
  KEY `id_shop` (`id_shop`),
  KEY `id_shop_group` (`id_shop_group`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=InnoDB AUTO_INCREMENT=2127 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_available`
--

INSERT INTO `ps_stock_available` VALUES (631,631,0,1,0,1,0,1),(634,634,0,1,0,10,0,2),(637,637,0,1,0,9,0,2),(639,639,0,1,0,1,0,2),(640,640,0,1,0,0,0,2),(641,641,0,1,0,9,0,2),(642,642,0,1,0,10,0,2),(643,643,0,1,0,10,0,2),(644,644,0,1,0,9,0,2),(645,645,0,1,0,6,0,2),(646,646,0,1,0,9,0,2),(647,647,0,1,0,1,0,0),(728,728,0,1,0,10,0,2),(729,729,0,1,0,10,0,2),(730,730,0,1,0,10,0,2),(731,731,0,1,0,10,0,2),(732,732,0,1,0,10,0,2),(733,733,0,1,0,10,0,2),(734,734,0,1,0,10,0,2),(735,735,0,1,0,10,0,2),(737,737,0,1,0,10,0,2),(751,751,0,1,0,9,0,2),(752,752,0,1,0,10,0,2),(753,753,0,1,0,10,0,2),(754,754,0,1,0,10,0,2),(755,755,0,1,0,10,0,2),(756,756,0,1,0,10,0,2),(757,757,0,1,0,10,0,2),(758,758,0,1,0,10,0,2),(759,759,0,1,0,10,0,2),(760,760,0,1,0,9,0,2),(761,761,0,1,0,10,0,2),(762,762,0,1,0,9,0,2),(763,763,0,1,0,10,0,2),(764,764,0,1,0,9,0,2),(765,765,0,1,0,10,0,2),(766,766,0,1,0,10,0,2),(767,767,0,1,0,1,0,1),(769,769,0,1,0,9,0,2),(770,770,0,1,0,10,0,2),(771,771,0,1,0,10,0,2),(772,772,0,1,0,10,0,2),(774,774,0,1,0,10,0,2),(775,775,0,1,0,10,0,2),(776,776,0,1,0,10,0,2),(777,777,0,1,0,9,0,2),(779,779,0,1,0,10,0,2),(780,780,0,1,0,10,0,2),(781,781,0,1,0,10,0,2),(786,786,0,1,0,10,0,2),(787,787,0,1,0,10,0,2),(788,788,0,1,0,10,0,2),(789,789,0,1,0,10,0,2),(790,790,0,1,0,9,0,2),(791,791,0,1,0,9,0,2),(837,837,0,1,0,10,0,2),(838,838,0,1,0,9,0,2),(840,840,0,1,0,10,0,2),(841,841,0,1,0,10,0,2),(842,842,0,1,0,10,0,2),(843,843,0,1,0,10,0,2),(844,844,0,1,0,10,0,2),(845,845,0,1,0,7,0,2),(846,846,0,1,0,9,0,2),(847,847,0,1,0,9,0,2),(848,848,0,1,0,10,0,2),(849,849,0,1,0,10,0,2),(850,850,0,1,0,10,0,2),(851,851,0,1,0,10,0,2),(852,852,0,1,0,10,0,2),(853,853,0,1,0,9,0,2),(854,854,0,1,0,10,0,2),(855,855,0,1,0,9,0,2),(856,856,0,1,0,9,0,2),(857,857,0,1,0,7,0,2),(858,858,0,1,0,10,0,2),(859,859,0,1,0,10,0,2),(860,860,0,1,0,10,0,2),(861,861,0,1,0,10,0,2),(862,862,0,1,0,10,0,2),(863,863,0,1,0,10,0,2),(864,864,0,1,0,10,0,2),(865,865,0,1,0,9,0,2),(866,866,0,1,0,9,0,2),(892,892,0,1,0,10,0,2),(894,894,0,1,0,10,0,2),(895,895,0,1,0,7,0,2),(896,896,0,1,0,10,0,2),(897,897,0,1,0,9,0,2),(900,900,0,1,0,4,0,2),(901,901,0,1,0,0,0,2),(903,903,0,1,0,10,0,2),(904,904,0,1,0,10,0,2),(906,906,0,1,0,10,0,2),(908,908,0,1,0,10,0,2),(912,912,0,1,0,10,0,2),(913,913,0,1,0,4,0,2),(915,915,0,1,0,10,0,2),(917,917,0,1,0,10,0,2),(918,918,0,1,0,10,0,2),(919,919,0,1,0,9,0,2),(921,921,0,1,0,10,0,2),(922,922,0,1,0,10,0,2),(923,923,0,1,0,10,0,2),(924,924,0,1,0,10,0,2),(927,927,0,1,0,10,0,2),(928,928,0,1,0,9,0,2),(929,929,0,1,0,10,0,2),(930,930,0,1,0,9,0,2),(931,931,0,1,0,9,0,2),(932,932,0,1,0,10,0,2),(933,933,0,1,0,10,0,2),(934,934,0,1,0,10,0,2),(935,935,0,1,0,10,0,2),(936,936,0,1,0,1,0,2),(937,937,0,1,0,10,0,2),(938,938,0,1,0,10,0,2),(939,939,0,1,0,10,0,2),(940,940,0,1,0,10,0,2),(941,941,0,1,0,10,0,2),(942,942,0,1,0,9,0,2),(943,943,0,1,0,10,0,2),(945,945,0,1,0,10,0,2),(946,946,0,1,0,10,0,2),(947,947,0,1,0,8,0,2),(949,949,0,1,0,9,0,2),(950,950,0,1,0,10,0,2),(978,978,0,1,0,7,0,2),(980,980,0,1,0,10,0,2),(981,981,0,1,0,10,0,2),(982,982,0,1,0,10,0,2),(983,983,0,1,0,10,0,2),(984,984,0,1,0,8,0,2),(985,985,0,1,0,10,0,2),(986,986,0,1,0,9,0,2),(987,987,0,1,0,10,0,2),(988,988,0,1,0,8,0,2),(989,989,0,1,0,10,0,2),(990,990,0,1,0,10,0,2),(991,991,0,1,0,10,0,2),(992,992,0,1,0,0,0,2),(993,993,0,1,0,8,0,2),(995,995,0,1,0,8,0,2),(1080,1080,0,1,0,10,0,2),(1081,1081,0,1,0,8,0,2),(1082,1082,0,1,0,10,0,2),(1083,1083,0,1,0,10,0,2),(1085,1085,0,1,0,9,0,2),(1087,1087,0,1,0,10,0,2),(1088,1088,0,1,0,10,0,2),(1089,1089,0,1,0,10,0,2),(1090,1090,0,1,0,10,0,2),(1091,1091,0,1,0,10,0,2),(1093,1093,0,1,0,10,0,2),(1094,1094,0,1,0,10,0,2),(1095,1095,0,1,0,10,0,2),(1096,1096,0,1,0,9,0,2),(1097,1097,0,1,0,9,0,2),(1098,1098,0,1,0,10,0,2),(1099,1099,0,1,0,10,0,2),(1100,1100,0,1,0,10,0,2),(1396,1396,0,1,0,10,0,2),(1397,1397,0,1,0,10,0,2),(1398,1398,0,1,0,9,0,2),(1399,1399,0,1,0,10,0,2),(1400,1400,0,1,0,10,0,2),(1401,1401,0,1,0,10,0,2),(1402,1402,0,1,0,10,0,2),(1403,1403,0,1,0,10,0,2),(1404,1404,0,1,0,10,0,2),(1405,1405,0,1,0,10,0,2),(1406,1406,0,1,0,10,0,2),(1409,1409,0,1,0,10,0,2),(1410,1410,0,1,0,10,0,2),(1411,1411,0,1,0,10,0,2),(1412,1412,0,1,0,10,0,2),(1413,1413,0,1,0,10,0,2),(1416,1416,0,1,0,10,0,2),(1417,1417,0,1,0,10,0,2),(1418,1418,0,1,0,10,0,2),(1419,1419,0,1,0,10,0,2),(1420,1420,0,1,0,10,0,2),(1421,1421,0,1,0,8,0,2),(1422,1422,0,1,0,10,0,2),(1423,1423,0,1,0,10,0,2),(1424,1424,0,1,0,10,0,2),(1425,1425,0,1,0,9,0,2),(1426,1426,0,1,0,10,0,2),(1427,1427,0,1,0,10,0,2),(1428,1428,0,1,0,10,0,2),(1429,1429,0,1,0,10,0,2),(1430,1430,0,1,0,10,0,2),(1431,1431,0,1,0,10,0,2),(1432,1432,0,1,0,10,0,2),(1433,1433,0,1,0,9,0,2),(1434,1434,0,1,0,10,0,2),(1435,1435,0,1,0,10,0,2),(1436,1436,0,1,0,10,0,2),(1437,1437,0,1,0,10,0,2),(1439,1439,0,1,0,9,0,2),(1440,1440,0,1,0,1,0,2),(1442,1442,0,1,0,9,0,2),(1443,1443,0,1,0,10,0,2),(1444,1444,0,1,0,10,0,2),(1445,1445,0,1,0,10,0,2),(1446,1446,0,1,0,10,0,2),(1447,1447,0,1,0,10,0,2),(1467,1467,0,1,0,6,0,2),(1468,1468,0,1,0,9,0,2),(1469,1469,0,1,0,9,0,2),(1470,1470,0,1,0,10,0,2),(1471,1471,0,1,0,10,0,2),(1472,1472,0,1,0,10,0,2),(1473,1473,0,1,0,8,0,2),(1474,1474,0,1,0,9,0,2),(1475,1475,0,1,0,8,0,2),(1476,1476,0,1,0,8,0,2),(1477,1477,0,1,0,10,0,2),(1478,1478,0,1,0,9,0,2),(1479,1479,0,1,0,8,0,2),(1480,1480,0,1,0,10,0,2),(1481,1481,0,1,0,8,0,2),(1482,1482,0,1,0,9,0,2),(1483,1483,0,1,0,9,0,2),(1484,1484,0,1,0,10,0,2),(1485,1485,0,1,0,10,0,2),(1486,1486,0,1,0,8,0,2),(1487,1487,0,1,0,10,0,2),(1488,1488,0,1,0,8,0,2),(1489,1489,0,1,0,8,0,2),(1490,1490,0,1,0,0,0,2),(1491,1491,0,1,0,10,0,2),(1492,1492,0,1,0,0,0,2),(1493,1493,0,1,0,10,0,2),(1494,1494,0,1,0,10,0,2),(1495,1495,0,1,0,8,0,2),(1496,1496,0,1,0,10,0,2),(1497,1497,0,1,0,10,0,2),(1519,1519,0,1,0,10,0,2),(1520,1520,0,1,0,6,0,2),(1521,1521,0,1,0,10,0,2),(1522,1522,0,1,0,6,0,2),(1523,1523,0,1,0,10,0,2),(1524,1524,0,1,0,10,0,2),(1525,1525,0,1,0,10,0,2),(1526,1526,0,1,0,10,0,2),(1527,1527,0,1,0,10,0,2),(1528,1528,0,1,0,10,0,2),(1529,1529,0,1,0,10,0,2),(1530,1530,0,1,0,9,0,2),(1531,1531,0,1,0,10,0,2),(1532,1532,0,1,0,10,0,2),(1533,1533,0,1,0,8,0,2),(1534,1534,0,1,0,10,0,2),(1535,1535,0,1,0,9,0,2),(1536,1536,0,1,0,10,0,2),(1537,1537,0,1,0,10,0,2),(1538,1538,0,1,0,10,0,2),(1539,1539,0,1,0,10,0,2),(1540,1540,0,1,0,10,0,2),(1541,1541,0,1,0,10,0,2),(1542,1542,0,1,0,5,0,2),(1543,1543,0,1,0,9,0,2),(1544,1544,0,1,0,10,0,2),(1545,1545,0,1,0,10,0,2),(1546,1546,0,1,0,10,0,2),(1547,1547,0,1,0,10,0,2),(1548,1548,0,1,0,6,0,2),(1549,1549,0,1,0,7,0,2),(1550,1550,0,1,0,10,0,2),(1551,1551,0,1,0,10,0,2),(1553,1553,0,1,0,5,0,2),(1554,1554,0,1,0,10,0,2),(1555,1555,0,1,0,10,0,2),(1556,1556,0,1,0,9,0,2),(1557,1557,0,1,0,9,0,2),(1558,1558,0,1,0,10,0,2),(1560,1560,0,1,0,7,0,2),(1561,1561,0,1,0,10,0,2),(1562,1562,0,1,0,10,0,2),(1563,1563,0,1,0,10,0,2),(1564,1564,0,1,0,10,0,2),(1565,1565,0,1,0,9,0,2),(1566,1566,0,1,0,9,0,2),(1567,1567,0,1,0,10,0,2),(1569,1569,0,1,0,1,0,2),(1570,1570,0,1,0,5,0,2),(1571,1571,0,1,0,2,0,2),(1572,1572,0,1,0,2,0,2),(1573,1573,0,1,0,2,0,2),(1574,1574,0,1,0,1,0,2),(1575,1575,0,1,0,0,0,2),(1576,1576,0,1,0,2,0,2),(1577,1577,0,1,0,5,0,2),(1578,1578,0,1,0,3,0,2),(1579,1579,0,1,0,5,0,2),(1580,1580,0,1,0,4,0,2),(1581,1581,0,1,0,5,0,2),(1585,1585,0,1,0,3,0,2),(1588,1588,0,1,0,10,0,2),(1590,1590,0,1,0,3,0,2),(1600,1600,0,1,0,10,0,2),(1601,1601,0,1,0,10,0,2),(1602,1602,0,1,0,10,0,2),(1603,1603,0,1,0,9,0,2),(1604,1604,0,1,0,9,0,2),(1608,1608,0,1,0,1,0,2),(1609,1609,0,1,0,0,0,2),(1610,1610,0,1,0,5,0,2),(1612,1612,0,1,0,0,0,2),(1615,1615,0,1,0,9,0,2),(1616,1616,0,1,0,5,0,2),(1618,1618,0,1,0,500,0,2),(1619,1619,0,1,0,500,0,2),(1620,1620,0,1,0,3,0,2),(1621,1621,0,1,0,0,0,2),(1623,1623,0,1,0,1,0,2),(1625,1625,0,1,0,7,0,2),(1626,1626,0,1,0,2,0,2),(1627,1627,0,1,0,1,0,2),(1628,1628,0,1,0,3,0,2),(1629,1629,0,1,0,1,0,2),(1630,1630,0,1,0,5,0,2),(1631,1631,0,1,0,2,0,2),(1632,1632,0,1,0,2,0,2),(1633,1633,0,1,0,1,0,2),(1634,1634,0,1,0,1,0,2),(1637,1637,0,1,0,0,0,2),(1639,1639,0,1,0,2,0,2),(1640,1640,0,1,0,1,0,2),(1641,1641,0,1,0,2,0,2),(1642,1642,0,1,0,2,0,2),(1643,1643,0,1,0,10,0,2),(1644,1644,0,1,0,2,0,2),(1645,1645,0,1,0,2,0,2),(1646,1646,0,1,0,0,0,2),(1647,1647,0,1,0,0,0,2),(1648,1648,0,1,0,2,0,2),(1649,1649,0,1,0,2,0,2),(1653,1653,0,1,0,2,0,2),(1654,1654,0,1,0,7,0,2),(1656,1656,0,1,0,2,0,2),(1657,1657,0,1,0,1,0,2),(1658,1658,0,1,0,1,0,2),(1659,1659,0,1,0,1,0,2),(1660,1660,0,1,0,1,0,2),(1661,1661,0,1,0,2,0,2),(1662,1662,0,1,0,2,0,2),(1663,1663,0,1,0,2,0,2),(1664,1664,0,1,0,2,0,2),(1665,1665,0,1,0,0,0,2),(1666,1666,0,1,0,9,0,2),(1667,1667,0,1,0,0,0,2),(1668,1668,0,1,0,2,0,2),(1669,1669,0,1,0,0,0,2),(1670,1670,0,1,0,0,0,2),(1672,1672,0,1,0,1,0,2),(1673,1673,0,1,0,1,0,2),(1674,1674,0,1,0,1,0,2),(1675,1675,0,1,0,1,0,2),(1676,1676,0,1,0,1,0,2),(1677,1677,0,1,0,0,0,2),(1678,1678,0,1,0,1,0,2),(1679,1679,0,1,0,1,0,2),(1680,1680,0,1,0,1,0,2),(1681,1681,0,1,0,0,0,2),(1682,1682,0,1,0,0,0,2),(1683,1683,0,1,0,0,0,2),(1684,1684,0,1,0,1,0,2),(1685,1685,0,1,0,1,0,2),(1686,1686,0,1,0,1,0,2),(1687,1687,0,1,0,0,0,2),(1689,1689,0,1,0,1,0,2),(1690,1690,0,1,0,2,0,2),(1692,1692,0,1,0,0,0,2),(1694,1694,0,1,0,2,0,2),(1695,1695,0,1,0,1,0,2),(1696,1696,0,1,0,0,0,2),(1697,1697,0,1,0,1,0,2),(1708,1,0,1,0,1,0,2),(1711,1710,0,1,0,2,0,2),(1712,1711,0,1,0,0,0,2),(1713,1712,0,1,0,6,0,2),(1714,1713,0,1,0,6,0,2),(1715,1714,0,1,0,2,0,2),(1716,1715,0,1,0,6,0,2),(1717,1716,0,1,0,6,0,2),(1725,1724,0,1,0,6,0,2),(1726,1725,0,1,0,6,0,2),(1727,1726,0,1,0,6,0,2),(1729,1728,0,1,0,5,0,2),(1748,1747,0,1,0,1,0,2),(1750,1749,0,1,0,1,0,2),(1751,1750,0,1,0,1,0,2),(1752,1751,0,1,0,2,0,2),(1753,1752,0,1,0,1,0,2),(1754,1753,0,1,0,1,0,2),(1755,1754,0,1,0,2,0,2),(1756,1755,0,1,0,10,0,2),(1757,1756,0,1,0,1,0,2),(1758,1757,0,1,0,3,0,2),(1759,1758,0,1,0,1,0,2),(1760,1759,0,1,0,1,0,2),(1761,1760,0,1,0,1,0,2),(1763,1762,0,1,0,8,0,2),(1766,1765,0,1,0,0,0,2),(1768,1767,0,1,0,0,0,2),(1769,1768,0,1,0,1,0,2),(1771,1770,0,1,0,0,0,2),(1772,1771,0,1,0,1,0,2),(1773,1772,0,1,0,1,0,2),(1774,1773,0,1,0,0,0,2),(1775,1774,0,1,0,1,0,2),(1776,1775,0,1,0,1,0,2),(1777,1776,0,1,0,0,0,2),(1779,1778,0,1,0,1,0,2),(1780,1779,0,1,0,1,0,2),(1781,1780,0,1,0,1,0,2),(1782,1781,0,1,0,1,0,2),(1783,1782,0,1,0,1,0,2),(1784,1783,0,1,0,1,0,2),(1785,1784,0,1,0,2,0,2),(1786,1785,0,1,0,1,0,2),(1787,1786,0,1,0,1,0,2),(1788,1787,0,1,0,0,0,2),(1789,1788,0,1,0,1,0,2),(1790,1789,0,1,0,1,0,2),(1791,1790,0,1,0,1,0,2),(1792,1791,0,1,0,1,0,2),(1793,1792,0,1,0,10,0,2),(1794,1793,0,1,0,10,0,2),(1795,1794,0,1,0,10,0,2),(1796,1795,0,1,0,10,0,2),(1797,1796,0,1,0,9,0,2),(1798,1797,0,1,0,10,0,2),(1799,1798,0,1,0,10,0,2),(1800,1799,0,1,0,10,0,2),(1801,1800,0,1,0,10,0,2),(1803,1802,0,1,0,10,0,2),(1804,1803,0,1,0,10,0,2),(1805,1804,0,1,0,10,0,2),(1807,1806,0,1,0,10,0,2),(1809,1808,0,1,0,10,0,2),(1810,1809,0,1,0,10,0,2),(1811,1810,0,1,0,10,0,2),(1812,1811,0,1,0,10,0,2),(1813,1812,0,1,0,10,0,2),(1814,1813,0,1,0,10,0,2),(1815,1814,0,1,0,10,0,2),(1816,1815,0,1,0,10,0,2),(1817,1816,0,1,0,10,0,2),(1818,1817,0,1,0,10,0,2),(1821,1820,0,1,0,10,0,2),(1822,1821,0,1,0,10,0,2),(1823,1822,0,1,0,10,0,2),(1824,1823,0,1,0,10,0,2),(1825,1824,0,1,0,10,0,2),(1826,1825,0,1,0,10,0,2),(1827,1826,0,1,0,10,0,2),(1828,1827,0,1,0,10,0,2),(1829,1828,0,1,0,10,0,2),(1830,1829,0,1,0,10,0,2),(1831,1830,0,1,0,10,0,2),(1832,1831,0,1,0,10,0,2),(1833,1832,0,1,0,10,0,2),(1834,1833,0,1,0,10,0,2),(1835,1834,0,1,0,10,0,2),(1836,1835,0,1,0,10,0,2),(1837,1836,0,1,0,10,0,2),(1838,1837,0,1,0,10,0,2),(1839,1838,0,1,0,10,0,2),(1840,1839,0,1,0,10,0,2),(1841,1840,0,1,0,10,0,2),(1842,1841,0,1,0,10,0,2),(1843,1842,0,1,0,10,0,2),(1844,1843,0,1,0,10,0,2),(1845,1844,0,1,0,10,0,2),(1846,1845,0,1,0,10,0,2),(1847,1846,0,1,0,10,0,2),(1848,1847,0,1,0,10,0,2),(1849,1848,0,1,0,10,0,2),(1850,1849,0,1,0,10,0,2),(1851,1850,0,1,0,10,0,2),(1852,1851,0,1,0,10,0,2),(1853,1852,0,1,0,10,0,2),(1854,1853,0,1,0,10,0,2),(1855,1854,0,1,0,10,0,2),(1856,1855,0,1,0,10,0,2),(1857,1856,0,1,0,10,0,2),(1858,1857,0,1,0,10,0,2),(1859,1858,0,1,0,10,0,2),(1860,1859,0,1,0,9,0,2),(1861,1860,0,1,0,10,0,2),(1862,1861,0,1,0,7,0,2),(1863,1862,0,1,0,7,0,2),(1864,1863,0,1,0,9,0,2),(1865,1864,0,1,0,10,0,2),(1866,1865,0,1,0,9,0,2),(1867,1866,0,1,0,10,0,2),(1868,1867,0,1,0,10,0,2),(1869,1868,0,1,0,10,0,2),(1870,1869,0,1,0,10,0,2),(1871,1870,0,1,0,10,0,2),(1873,1872,0,1,0,10,0,2),(1874,1873,0,1,0,10,0,2),(1875,1874,0,1,0,10,0,2),(1876,1875,0,1,0,1,0,2),(1877,1876,0,1,0,2,0,2),(1878,1877,0,1,0,0,0,2),(1879,1878,0,1,0,1,0,2),(1880,1879,0,1,0,2,0,2),(1881,1880,0,1,0,1,0,2),(1882,1881,0,1,0,2,0,2),(1883,1882,0,1,0,1,0,2),(1884,1883,0,1,0,0,0,2),(1885,1884,0,1,0,2,0,2),(1886,1885,0,1,0,2,0,2),(1887,1886,0,1,0,1,0,2),(1888,1887,0,1,0,2,0,2),(1889,1888,0,1,0,2,0,2),(1890,1889,0,1,0,2,0,2),(1891,1890,0,1,0,2,0,2),(1892,1891,0,1,0,2,0,2),(1893,1892,0,1,0,0,0,2),(1894,1893,0,1,0,1,0,2),(1895,1894,0,1,0,1,0,2),(1896,1895,0,1,0,1,0,2),(1897,1896,0,1,0,1,0,2),(1898,1897,0,1,0,1,0,2),(1899,1898,0,1,0,1,0,2),(1900,1899,0,1,0,1,0,2),(1901,1900,0,1,0,1,0,2),(1902,1901,0,1,0,1,0,2),(1903,1902,0,1,0,1,0,2),(1904,1903,0,1,0,0,0,2),(1905,1904,0,1,0,0,0,2),(1907,1906,0,1,0,2,0,2),(1908,1907,0,1,0,0,0,2),(1909,1908,0,1,0,1,0,2),(1910,1909,0,1,0,2,0,2),(1911,1910,0,1,0,2,0,2),(1912,1911,0,1,0,1,0,2),(1913,1912,0,1,0,2,0,2),(1914,1913,0,1,0,2,0,2),(1915,1914,0,1,0,1,0,2),(1916,1915,0,1,0,2,0,2),(1917,1916,0,1,0,1,0,2),(1918,1917,0,1,0,2,0,2),(1919,1918,0,1,0,1,0,2),(1920,1919,0,1,0,1,0,2),(1921,1920,0,1,0,3,0,2),(1922,1921,0,1,0,2,0,2),(1923,1922,0,1,0,2,0,2),(1924,1923,0,1,0,2,0,2),(1925,1924,0,1,0,2,0,2),(1926,1925,0,1,0,2,0,2),(1927,1926,0,1,0,1,0,2),(1928,1927,0,1,0,2,0,2),(1929,1928,0,1,0,1,0,2),(1930,1929,0,1,0,2,0,2),(1931,1930,0,1,0,2,0,2),(1932,1931,0,1,0,2,0,2),(1933,1932,0,1,0,2,0,2),(1934,1933,0,1,0,10,0,2),(1935,1934,0,1,0,0,0,2),(1936,1935,0,1,0,2,0,2),(1937,1936,0,1,0,2,0,2),(1938,1937,0,1,0,1,0,2),(1939,1938,0,1,0,1,0,2),(1940,1939,0,1,0,1,0,2),(1941,1941,0,1,0,0,0,2),(1943,1942,0,1,0,0,0,2),(1944,1943,0,1,0,0,0,2),(1945,1944,0,1,0,1,0,2),(1946,1945,0,1,0,4,0,2),(1947,1946,0,1,0,0,0,2),(1948,1947,0,1,0,10,0,2),(1949,1948,0,1,0,10,0,2),(1950,1949,0,1,0,1,0,2),(1952,1951,0,1,0,1,0,2),(1953,1953,0,1,0,1,0,2),(1955,1954,0,1,0,2,0,2),(1956,1955,0,1,0,2,0,2),(1957,1956,0,1,0,2,0,2),(1958,1957,0,1,0,2,0,2),(1959,1958,0,1,0,2,0,2),(1960,1959,0,1,0,2,0,2),(1961,1960,0,1,0,2,0,2),(1962,1961,0,1,0,5,0,2),(1963,1962,0,1,0,5,0,2),(1964,1963,0,1,0,5,0,2),(1965,1964,0,1,0,5,0,2),(1966,1965,0,1,0,5,0,2),(1967,1966,0,1,0,2,0,2),(1968,1967,0,1,0,1,0,2),(1969,1968,0,1,0,2,0,2),(1970,1969,0,1,0,0,0,2),(1971,1970,0,1,0,1,0,2),(1972,1971,0,1,0,2,0,2),(1973,1973,0,1,0,0,0,2),(1974,1972,0,1,0,2,0,2),(1975,1974,0,1,0,2,0,2),(1976,1975,0,1,0,2,0,2),(1977,1976,0,1,0,2,0,2),(1978,1977,0,1,0,2,0,2),(1979,1978,0,1,0,2,0,2),(1980,1979,0,1,0,50,0,2),(1981,1980,0,1,0,2,0,2),(1982,1981,0,1,0,2,0,2),(1983,1982,0,1,0,2,0,2),(1985,1984,0,1,0,2,0,2),(1986,1985,0,1,0,2,0,2),(1987,1986,0,1,0,2,0,2),(1988,1987,0,1,0,2,0,2),(1989,1988,0,1,0,2,0,2),(1990,1989,0,1,0,1,0,2),(1991,1990,0,1,0,1,0,2),(1992,1991,0,1,0,4,0,2),(1993,1992,0,1,0,1,0,1),(1995,1994,0,1,0,2,0,2),(1996,1995,0,1,0,0,0,2),(1997,1996,0,1,0,1,0,2),(1998,1997,0,1,0,1,0,2),(1999,1998,0,1,0,0,0,2),(2000,1999,0,1,0,0,0,2),(2001,2000,0,1,0,1,0,2),(2002,2001,0,1,0,0,0,2),(2003,2002,0,1,0,1,0,2),(2004,2003,0,1,0,9,0,2),(2005,2004,0,1,0,2,0,2),(2006,2005,0,1,0,0,0,2),(2007,2006,0,1,0,2,0,2),(2008,2007,0,1,0,1,0,2),(2009,2008,0,1,0,1,0,2),(2010,2009,0,1,0,1,0,2),(2011,2011,0,1,0,1,0,2),(2012,2010,0,1,0,1,0,2),(2013,2012,0,1,0,0,0,2),(2014,2013,0,1,0,2,0,2),(2015,2014,0,1,0,0,0,2),(2016,2015,0,1,0,0,0,2),(2017,2016,0,1,0,1,0,2),(2018,2017,0,1,0,0,0,2),(2019,2018,0,1,0,1,0,2),(2020,2019,0,1,0,2,0,2),(2021,2020,0,1,0,1,0,2),(2022,2021,0,1,0,0,0,2),(2023,2022,0,1,0,10,0,2),(2024,2023,0,1,0,10,0,2),(2025,2024,0,1,0,1,0,2),(2026,2025,0,1,0,2,0,1),(2028,2027,0,1,0,10,0,2),(2029,2028,0,1,0,1,0,2),(2030,2029,0,1,0,2,0,2),(2031,2030,0,1,0,3,0,2),(2032,2031,0,1,0,0,0,2),(2033,2032,0,1,0,1,0,2),(2034,2033,0,1,0,0,0,2),(2035,2034,0,1,0,0,0,2),(2036,2035,0,1,0,2,0,2),(2037,2036,0,1,0,2,0,2),(2038,2037,0,1,0,5,0,2),(2039,2038,0,1,0,1,0,2),(2040,2040,0,1,0,0,0,2),(2041,2041,0,1,0,0,0,2),(2042,2039,0,1,0,0,0,2),(2043,2042,0,1,0,0,0,1),(2044,2043,0,1,0,0,0,2),(2045,2044,0,1,0,0,0,2),(2046,2045,0,1,0,0,0,2),(2047,2046,0,1,0,0,0,2),(2049,2048,0,1,0,0,0,1),(2050,2049,0,1,0,5,0,2),(2051,2050,0,1,0,0,0,2),(2052,2051,0,1,0,2,0,2),(2054,2053,0,1,0,1,0,2),(2055,2054,0,1,0,0,0,2),(2056,2055,0,1,0,0,0,2),(2057,2056,0,1,0,1,0,2),(2058,2057,0,1,0,1,0,2),(2059,2058,0,1,0,1,0,2),(2060,2059,0,1,0,1,0,2),(2061,2060,0,1,0,1,0,2),(2063,2062,0,1,0,0,0,2),(2064,2063,0,1,0,4,0,2),(2065,2064,0,1,0,1,0,2),(2066,2065,0,1,0,1,0,2),(2067,2066,0,1,0,0,0,2),(2068,2068,0,1,0,2,0,2),(2070,2069,0,1,0,1,0,2),(2071,2070,0,1,0,0,0,2),(2072,2071,0,1,0,2,0,2),(2073,2072,0,1,0,2,0,2),(2074,2073,0,1,0,2,0,2),(2075,2074,0,1,0,2,0,2),(2076,2075,0,1,0,0,0,2),(2077,2076,0,1,0,0,0,2),(2078,2077,0,1,0,1,0,2),(2079,2078,0,1,0,2,0,2),(2080,2079,0,1,0,1,0,2),(2081,2080,0,1,0,1,0,2),(2082,2081,0,1,0,0,0,2),(2083,2082,0,1,0,0,0,2),(2084,2083,0,1,0,1,0,2),(2085,2084,0,1,0,2,0,2),(2086,2085,0,1,0,2,0,2),(2087,2086,0,1,0,2,0,2),(2088,2087,0,1,0,2,0,2),(2089,2088,0,1,0,2,0,2),(2090,2089,0,1,0,2,0,2),(2092,2090,0,1,0,0,0,2),(2093,2092,0,1,0,2,0,2),(2094,2093,0,1,0,2,0,2),(2095,2094,0,1,0,3,0,2),(2098,2097,0,1,0,1,0,2),(2099,2098,0,1,0,1,0,2),(2100,2099,0,1,0,1,0,2),(2101,2100,0,1,0,1,0,2),(2102,2101,0,1,0,1,0,2),(2103,2102,0,1,0,1,0,2),(2104,2103,0,1,0,1,0,2),(2105,2104,0,1,0,1,0,2),(2106,2105,0,1,0,1,0,2),(2107,2106,0,1,0,0,0,2),(2108,2107,0,1,0,1,0,2),(2110,2109,0,1,0,1,0,2),(2111,2110,0,1,0,1,0,2),(2112,2111,0,1,0,1,0,2),(2113,2112,0,1,0,1,0,2),(2115,2114,0,1,0,1,0,2),(2116,2115,0,1,0,1,0,2),(2117,2116,0,1,0,3,0,2),(2118,2117,0,1,0,2,0,2),(2119,2118,0,1,0,2,0,2),(2120,2119,0,1,0,1,0,0),(2121,2120,0,1,0,1,0,2),(2122,2121,0,1,0,2,0,2),(2123,2122,0,1,0,1,0,2),(2124,2123,0,1,0,5,0,2),(2125,2124,0,1,0,2,0,2),(2126,2125,0,1,0,5,0,2);

--
-- Table structure for table `ps_stock_mvt`
--

CREATE TABLE `ps_stock_mvt` (
  `id_stock_mvt` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_stock` int(11) unsigned NOT NULL,
  `id_order` int(11) unsigned DEFAULT NULL,
  `id_supply_order` int(11) unsigned DEFAULT NULL,
  `id_stock_mvt_reason` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `physical_quantity` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `sign` tinyint(1) NOT NULL DEFAULT '1',
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `last_wa` decimal(20,6) DEFAULT '0.000000',
  `current_wa` decimal(20,6) DEFAULT '0.000000',
  `referer` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id_stock_mvt`),
  KEY `id_stock` (`id_stock`),
  KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_mvt`
--


--
-- Table structure for table `ps_stock_mvt_reason`
--

CREATE TABLE `ps_stock_mvt_reason` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sign` tinyint(1) NOT NULL DEFAULT '1',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_stock_mvt_reason`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_mvt_reason`
--

INSERT INTO `ps_stock_mvt_reason` VALUES (1,1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(2,-1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(3,-1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(4,-1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(5,1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(6,-1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(7,1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0),(8,1,'2018-08-31 09:32:40','2018-08-31 09:32:40',0);

--
-- Table structure for table `ps_stock_mvt_reason_lang`
--

CREATE TABLE `ps_stock_mvt_reason_lang` (
  `id_stock_mvt_reason` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id_stock_mvt_reason`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_stock_mvt_reason_lang`
--

INSERT INTO `ps_stock_mvt_reason_lang` VALUES (1,1,'Augmenter'),(1,2,'Augmenter'),(2,1,'Diminuer'),(2,2,'Diminuer'),(3,1,'Commande client'),(3,2,'Commande client'),(4,1,'Régularisation du stock suite à un inventaire'),(4,2,'Régularisation du stock suite à un inventaire'),(5,1,'Régularisation du stock suite à un inventaire'),(5,2,'Régularisation du stock suite à un inventaire'),(6,1,'Transfert vers un autre entrepôt'),(6,2,'Transfert vers un autre entrepôt'),(7,1,'Transfert depuis un autre entrepôt'),(7,2,'Transfert depuis un autre entrepôt'),(8,1,'Commande fournisseur'),(8,2,'Commande fournisseur');

--
-- Table structure for table `ps_store`
--

CREATE TABLE `ps_store` (
  `id_store` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `address1` varchar(128) NOT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `postcode` varchar(12) NOT NULL,
  `latitude` decimal(13,8) DEFAULT NULL,
  `longitude` decimal(13,8) DEFAULT NULL,
  `hours` varchar(254) DEFAULT NULL,
  `phone` varchar(16) DEFAULT NULL,
  `fax` varchar(16) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `note` text,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_store`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_store`
--

INSERT INTO `ps_store` VALUES (1,152,0,'Pyramusique','132 Résidence des médecins Témara','0661430372','Rabat','12000',25.94896900,-80.22643900,'a:7:{i:0;s:8:\"9h30-20h\";i:1;s:8:\"9h30-20h\";i:2;s:8:\"9h30-20h\";i:3;s:8:\"9h30-20h\";i:4;s:8:\"9h30-20h\";i:5;s:8:\"9h30-20h\";i:6;s:0:\"\";}','0661430372','0689631665','pyramusique@gmail.com','Vente des instruments de musique',1,'2019-05-01 12:31:06','2022-04-09 00:28:15');

--
-- Table structure for table `ps_store_shop`
--

CREATE TABLE `ps_store_shop` (
  `id_store` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_store`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_store_shop`
--

INSERT INTO `ps_store_shop` VALUES (1,1);

--
-- Table structure for table `ps_supplier`
--

CREATE TABLE `ps_supplier` (
  `id_supplier` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier`
--

INSERT INTO `ps_supplier` VALUES (2,'Fender','2018-09-12 09:56:17','2018-09-12 10:03:51',1),(3,'Yamaha ','2018-09-12 10:03:25','2018-09-12 10:03:25',1);

--
-- Table structure for table `ps_supplier_lang`
--

CREATE TABLE `ps_supplier_lang` (
  `id_supplier` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `description` text,
  `meta_title` varchar(128) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_supplier`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier_lang`
--

INSERT INTO `ps_supplier_lang` VALUES (2,1,'','','',''),(2,2,'','','',''),(3,1,'','','',''),(3,2,'','','','');

--
-- Table structure for table `ps_supplier_shop`
--

CREATE TABLE `ps_supplier_shop` (
  `id_supplier` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_supplier`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supplier_shop`
--

INSERT INTO `ps_supplier_shop` VALUES (2,1),(3,1);

--
-- Table structure for table `ps_supply_order`
--

CREATE TABLE `ps_supply_order` (
  `id_supply_order` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supplier` int(11) unsigned NOT NULL,
  `supplier_name` varchar(64) NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_ref_currency` int(11) unsigned NOT NULL,
  `reference` varchar(64) NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `date_delivery_expected` datetime DEFAULT NULL,
  `total_te` decimal(20,6) DEFAULT '0.000000',
  `total_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `total_tax` decimal(20,6) DEFAULT '0.000000',
  `total_ti` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `is_template` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id_supply_order`),
  KEY `id_supplier` (`id_supplier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `reference` (`reference`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order`
--


--
-- Table structure for table `ps_supply_order_detail`
--

CREATE TABLE `ps_supply_order_detail` (
  `id_supply_order_detail` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_currency` int(11) unsigned NOT NULL,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `reference` varchar(32) NOT NULL,
  `supplier_reference` varchar(32) NOT NULL,
  `name` varchar(128) NOT NULL,
  `ean13` varchar(13) DEFAULT NULL,
  `upc` varchar(12) DEFAULT NULL,
  `exchange_rate` decimal(20,6) DEFAULT '0.000000',
  `unit_price_te` decimal(20,6) DEFAULT '0.000000',
  `quantity_expected` int(11) unsigned NOT NULL,
  `quantity_received` int(11) unsigned NOT NULL,
  `price_te` decimal(20,6) DEFAULT '0.000000',
  `discount_rate` decimal(20,6) DEFAULT '0.000000',
  `discount_value_te` decimal(20,6) DEFAULT '0.000000',
  `price_with_discount_te` decimal(20,6) DEFAULT '0.000000',
  `tax_rate` decimal(20,6) DEFAULT '0.000000',
  `tax_value` decimal(20,6) DEFAULT '0.000000',
  `price_ti` decimal(20,6) DEFAULT '0.000000',
  `tax_value_with_order_discount` decimal(20,6) DEFAULT '0.000000',
  `price_with_order_discount_te` decimal(20,6) DEFAULT '0.000000',
  PRIMARY KEY (`id_supply_order_detail`),
  KEY `id_supply_order` (`id_supply_order`),
  KEY `id_product` (`id_product`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_product_product_attribute` (`id_product`,`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_detail`
--


--
-- Table structure for table `ps_supply_order_history`
--

CREATE TABLE `ps_supply_order_history` (
  `id_supply_order_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `id_state` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_history`),
  KEY `id_supply_order` (`id_supply_order`),
  KEY `id_employee` (`id_employee`),
  KEY `id_state` (`id_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_history`
--


--
-- Table structure for table `ps_supply_order_receipt_history`
--

CREATE TABLE `ps_supply_order_receipt_history` (
  `id_supply_order_receipt_history` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_supply_order_detail` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `employee_lastname` varchar(32) DEFAULT '',
  `employee_firstname` varchar(32) DEFAULT '',
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `quantity` int(11) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_supply_order_receipt_history`),
  KEY `id_supply_order_detail` (`id_supply_order_detail`),
  KEY `id_supply_order_state` (`id_supply_order_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_receipt_history`
--


--
-- Table structure for table `ps_supply_order_state`
--

CREATE TABLE `ps_supply_order_state` (
  `id_supply_order_state` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `delivery_note` tinyint(1) NOT NULL DEFAULT '0',
  `editable` tinyint(1) NOT NULL DEFAULT '0',
  `receipt_state` tinyint(1) NOT NULL DEFAULT '0',
  `pending_receipt` tinyint(1) NOT NULL DEFAULT '0',
  `enclosed` tinyint(1) NOT NULL DEFAULT '0',
  `color` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_state`
--

INSERT INTO `ps_supply_order_state` VALUES (1,0,1,0,0,0,'#faab00'),(2,1,0,0,0,0,'#273cff'),(3,0,0,0,1,0,'#ff37f5'),(4,0,0,1,1,0,'#ff3e33'),(5,0,0,1,0,1,'#00d60c'),(6,0,0,0,0,1,'#666666');

--
-- Table structure for table `ps_supply_order_state_lang`
--

CREATE TABLE `ps_supply_order_state_lang` (
  `id_supply_order_state` int(11) unsigned NOT NULL,
  `id_lang` int(11) unsigned NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id_supply_order_state`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_supply_order_state_lang`
--

INSERT INTO `ps_supply_order_state_lang` VALUES (1,1,'1 - Création en cours'),(1,2,'1 - Création en cours'),(2,1,'2 - Commande validée'),(2,2,'2 - Commande validée'),(3,1,'3 - En attente de réception'),(3,2,'3 - En attente de réception'),(4,1,'4 - Commande réceptionnée partiellement'),(4,2,'4 - Commande réceptionnée partiellement'),(5,1,'5 - Commande réceptionnée totalement'),(5,2,'5 - Commande réceptionnée totalement'),(6,1,'6 - Commande annulée'),(6,2,'6 - Commande annulée');

--
-- Table structure for table `ps_tab`
--

CREATE TABLE `ps_tab` (
  `id_tab` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` int(11) NOT NULL,
  `class_name` varchar(64) NOT NULL,
  `module` varchar(64) DEFAULT NULL,
  `position` int(10) unsigned NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `hide_host_mode` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tab`),
  KEY `class_name` (`class_name`),
  KEY `id_parent` (`id_parent`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tab`
--

INSERT INTO `ps_tab` VALUES (1,0,'AdminDashboard','',0,1,0),(2,-1,'AdminCms','',1,1,0),(3,-1,'AdminCmsCategories','',2,1,0),(4,-1,'AdminAttributeGenerator','',3,1,0),(5,-1,'AdminSearch','',4,1,0),(6,-1,'AdminLogin','',5,1,0),(7,-1,'AdminShop','',6,1,0),(8,-1,'AdminShopUrl','',7,1,0),(9,0,'AdminCatalog','',1,1,0),(10,0,'AdminParentOrders','',2,1,0),(11,0,'AdminParentCustomer','',3,1,0),(12,0,'AdminPriceRule','',4,1,0),(13,0,'AdminParentModules','',5,1,0),(14,0,'AdminParentShipping','',6,1,0),(15,0,'AdminParentLocalization','',7,1,0),(16,0,'AdminParentPreferences','',8,1,0),(17,0,'AdminTools','',9,1,0),(18,0,'AdminAdmin','',10,1,0),(19,0,'AdminParentStats','',11,1,0),(20,0,'AdminStock','',12,1,0),(21,9,'AdminProducts','',0,1,0),(22,9,'AdminCategories','',1,1,0),(23,9,'AdminTracking','',2,1,0),(24,9,'AdminAttributesGroups','',3,1,0),(25,9,'AdminFeatures','',4,1,0),(26,9,'AdminManufacturers','',5,1,0),(27,9,'AdminSuppliers','',6,1,0),(28,9,'AdminTags','',7,1,0),(29,9,'AdminAttachments','',8,1,0),(30,10,'AdminOrders','',0,1,0),(31,10,'AdminInvoices','',1,1,0),(32,10,'AdminReturn','',2,1,0),(33,10,'AdminDeliverySlip','',3,1,0),(34,10,'AdminSlip','',4,1,0),(35,10,'AdminStatuses','',5,1,0),(36,10,'AdminOrderMessage','',6,1,0),(37,11,'AdminCustomers','',0,1,0),(38,11,'AdminAddresses','',1,1,0),(39,11,'AdminGroups','',2,1,0),(40,11,'AdminCarts','',3,1,0),(41,11,'AdminCustomerThreads','',4,1,0),(42,11,'AdminContacts','',5,1,0),(43,11,'AdminGenders','',6,1,0),(44,11,'AdminOutstanding','',7,0,0),(45,12,'AdminCartRules','',0,1,0),(46,12,'AdminSpecificPriceRule','',1,1,0),(47,12,'AdminMarketing','',2,1,0),(48,14,'AdminCarriers','',0,1,0),(49,14,'AdminShipping','',1,1,0),(50,14,'AdminCarrierWizard','',2,1,0),(51,15,'AdminLocalization','',0,1,0),(52,15,'AdminLanguages','',1,1,0),(53,15,'AdminZones','',2,1,0),(54,15,'AdminCountries','',3,1,0),(55,15,'AdminStates','',4,1,0),(56,15,'AdminCurrencies','',5,1,0),(57,15,'AdminTaxes','',6,1,0),(58,15,'AdminTaxRulesGroup','',7,1,0),(59,15,'AdminTranslations','',8,1,0),(60,13,'AdminModules','',0,1,0),(61,13,'AdminAddonsCatalog','',1,1,0),(62,13,'AdminModulesPositions','',2,1,0),(63,13,'AdminPayment','',3,1,0),(64,16,'AdminPreferences','',0,1,0),(65,16,'AdminOrderPreferences','',1,1,0),(66,16,'AdminPPreferences','',2,1,0),(67,16,'AdminCustomerPreferences','',3,1,0),(68,16,'AdminThemes','',4,1,0),(69,16,'AdminMeta','',5,1,0),(70,16,'AdminCmsContent','',6,1,0),(71,16,'AdminImages','',7,1,0),(72,16,'AdminStores','',8,1,0),(73,16,'AdminSearchConf','',9,1,0),(74,16,'AdminMaintenance','',10,1,0),(75,16,'AdminGeolocation','',11,1,0),(76,17,'AdminInformation','',0,1,0),(77,17,'AdminPerformance','',1,1,0),(78,17,'AdminEmails','',2,1,0),(79,17,'AdminShopGroup','',3,0,0),(80,17,'AdminImport','',4,1,0),(81,17,'AdminBackup','',5,1,0),(82,17,'AdminRequestSql','',6,1,0),(83,17,'AdminLogs','',7,1,0),(84,17,'AdminWebservice','',8,1,0),(85,18,'AdminAdminPreferences','',0,1,0),(86,18,'AdminQuickAccesses','',1,1,0),(87,18,'AdminEmployees','',2,1,0),(88,18,'AdminProfiles','',3,1,0),(89,18,'AdminAccess','',4,1,0),(90,18,'AdminTabs','',5,1,0),(91,19,'AdminStats','',0,1,0),(92,19,'AdminSearchEngines','',1,1,0),(93,19,'AdminReferrers','',2,1,0),(94,20,'AdminWarehouses','',0,1,0),(95,20,'AdminStockManagement','',1,1,0),(96,20,'AdminStockMvt','',2,1,0),(97,20,'AdminStockInstantState','',3,1,0),(98,20,'AdminStockCover','',4,1,0),(99,20,'AdminSupplyOrders','',5,1,0),(100,20,'AdminStockConfiguration','',6,1,0),(101,-1,'AdminBlockCategories','blockcategories',8,1,0),(102,-1,'AdminDashgoals','dashgoals',9,1,0),(103,13,'AdminStoreCommander','storecommander',4,1,0),(105,-1,'AdminThemeConfigurator','themeconfigurator',10,1,0),(106,0,'Admin','cobiro',13,1,0),(107,106,'AdminCobiro','cobiro',1,1,0),(108,-1,'AdminLeoSliderLayer','leosliderlayer',11,1,0),(109,13,'AdminLeotempcpModule','leotempcp',5,1,0),(110,13,'AdminLeotempcpPanel','leotempcp',6,1,0),(111,13,'AdminLeotempcpTheme','leotempcp',7,1,0),(112,13,'AdminLeotempcpWidgets','leotempcp',8,1,0),(113,-1,'AdminLeotempcpImages','leotempcp',12,1,0),(114,0,'AdminGetStarted','touchize',14,1,0),(115,-1,'AdminSettings','touchize',13,1,0),(116,-1,'AdminWizard','touchize',14,1,0),(117,-1,'AdminTouchmaps','touchize',15,1,0),(118,-1,'AdminMenuBuilder','touchize',16,1,0),(119,-1,'AdminLicense','touchize',17,1,0),(120,-1,'AdminTopMenuBuilder','touchize',18,1,0),(121,-1,'AdminContactUs','touchize',19,1,0),(122,0,'AdminPaypalAjaxHandler','paypal',15,0,0),(123,-1,'AdminSmartsuppAjax','smartsupp',20,1,0);

--
-- Table structure for table `ps_tab_lang`
--

CREATE TABLE `ps_tab_lang` (
  `id_tab` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_tab`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tab_lang`
--

INSERT INTO `ps_tab_lang` VALUES (1,1,'Tableau de bord'),(1,2,'لوحة التحكم'),(2,1,'Pages et Catégories CMS'),(2,2,'Pages CMS'),(3,1,'Pages et Catégories CMS'),(3,2,'Catégories CMS'),(4,1,'Générateur de déclinaisons'),(4,2,'توليد الألوان'),(5,1,'Rechercher'),(5,2,'بحث'),(6,1,'Identifiant'),(6,2,'تسجيل الدخول'),(7,1,'Boutiques'),(7,2,'المتاجر:'),(8,1,'URL des boutiques'),(8,2,'URLs de boutique'),(9,1,'Catalogue'),(9,2,'الفهرس'),(10,1,'Commandes'),(10,2,'الطلبات'),(11,1,'Clients'),(11,2,'العملاء'),(12,1,'Promotions'),(12,2,'Promotions'),(13,1,'Modules'),(13,2,'الإضاقات'),(14,1,'Livraison'),(14,2,'الشحن'),(15,1,'Localisation'),(15,2,'اللغة والإعدادت الإقليمية'),(16,1,'Préférences'),(16,2,'Préférences'),(17,1,'Paramètres avancés'),(17,2,'Paramètres avancés'),(18,1,'Administration'),(18,2,'الإدارة'),(19,1,'Statistiques'),(19,2,'الإحصائيات'),(20,1,'Stock'),(20,2,'الاسهم'),(21,1,'Produits'),(21,2,'المنتجات'),(22,1,'Catégories'),(22,2,'التصنيفات'),(23,1,'Suivi'),(23,2,'Suivi'),(24,1,'Attributs des produits'),(24,2,'Attributs et Valeurs'),(25,1,'Caractéristiques'),(25,2,'Caractéristiques'),(26,1,'Fabricants'),(26,2,'الماركات'),(27,1,'Fournisseurs'),(27,2,'الموردون'),(28,1,'Mots-clés'),(28,2,'الوسوم:'),(29,1,'Documents joints'),(29,2,'الملفات المرفقة'),(30,1,'Commandes'),(30,2,'الطلبات'),(31,1,'Factures'),(31,2,'الفواتير'),(32,1,'Retours produits'),(32,2,'إرجاع البضائع'),(33,1,'Bons de livraison'),(33,2,'Bons de livraison'),(34,1,'Avoirs'),(34,2,'Avoirs'),(35,1,'États'),(35,2,'ضبط حالات الطلب'),(36,1,'Messages prédéfinis'),(36,2,'Messages prédéfinis'),(37,1,'Clients'),(37,2,'العملاء'),(38,1,'Adresses'),(38,2,'العناوين'),(39,1,'Groupes'),(39,2,'مجموعات المستخدمين'),(40,1,'Paniers'),(40,2,'Paniers'),(41,1,'SAV'),(41,2,'خدمة العملاء'),(42,1,'Contacts'),(42,2,'جهات الاتصال'),(43,1,'Titres de civilité'),(43,2,'المسميات'),(44,1,'Encours autorisés'),(44,2,'Encours'),(45,1,'Règles panier'),(45,2,'قواعد سلة الشراء'),(46,1,'Règles de prix catalogue'),(46,2,'آلية تسعير كتالوج المنتجات'),(47,1,'Marketing'),(47,2,'التسويق'),(48,1,'Transporteurs'),(48,2,'جهات الشحن:'),(49,1,'Préférences'),(49,2,'Préférences'),(50,1,'Transporteur'),(50,2,'جهة الشحن'),(51,1,'Localisation'),(51,2,'اللغة والإعدادت الإقليمية'),(52,1,'Langues'),(52,2,'لغات'),(53,1,'Zones'),(53,2,'النطاقات الجغرافية'),(54,1,'Pays'),(54,2,'الدول'),(55,1,'États'),(55,2,'المناطق'),(56,1,'Devises'),(56,2,'العملات:'),(57,1,'Taxes'),(57,2,'الضرائب'),(58,1,'Règles de taxes'),(58,2,'القواعد الضريبية'),(59,1,'Traductions'),(59,2,'Traductions'),(60,1,'Modules'),(60,2,'الإضاقات'),(61,1,'Catalogue de Modules et Thèmes'),(61,2,'Catalogue de modules et thèmes'),(62,1,'Positions'),(62,2,'أماكن العرض'),(63,1,'Paiement'),(63,2,'الدفع'),(64,1,'Paramètres généraux'),(64,2,'عام'),(65,1,'Commandes'),(65,2,'الطلبات'),(66,1,'Produits'),(66,2,'المنتجات'),(67,1,'Clients'),(67,2,'العملاء'),(68,1,'Thèmes'),(68,2,'Thèmes'),(69,1,'SEO & URL'),(69,2,'SEO & URLs'),(70,1,'CMS'),(70,2,'إدارة الصفحات'),(71,1,'Images'),(71,2,'الصور'),(72,1,'Coordonnées et magasins'),(72,2,'Coordonnées & magasins'),(73,1,'Rechercher'),(73,2,'بحث'),(74,1,'Maintenance'),(74,2,'الصيانة'),(75,1,'Géolocalisation'),(75,2,'Géolocalisation'),(76,1,'Informations'),(76,2,'معلومات'),(77,1,'Performances'),(77,2,'الخصائص'),(78,1,'Email'),(78,2,'البريد الإكتروني'),(79,1,'Multiboutique'),(79,2,'المتجر المتعدد'),(80,1,'Imports CSV'),(80,2,'Import'),(81,1,'Sauvegarde BDD'),(81,2,'Sauvegarde BDD'),(82,1,'Gestionnaire SQL'),(82,2,'Gestionnaire SQL'),(83,1,'Logs'),(83,2,'Log'),(84,1,'Webservice'),(84,2,'Service web'),(85,1,'Préférences'),(85,2,'Préférences'),(86,1,'Accès rapide'),(86,2,'الوصول السريع'),(87,1,'Employés'),(87,2,'الموظفين'),(88,1,'Profils'),(88,2,'Profils'),(89,1,'Permissions'),(89,2,'صلاحيات الموظفين'),(90,1,'Menus'),(90,2,'قائمة لوحة التحكم'),(91,1,'Statistiques'),(91,2,'الإحصائيات'),(92,1,'Moteurs de recherche'),(92,2,'Moteurs de recherche'),(93,1,'Affiliés'),(93,2,'المشيرين'),(94,1,'Entrepôts'),(94,2,'المستودعات'),(95,1,'Gestion du stock'),(95,2,'إدارة المستدوع'),(96,1,'Mouvements de stock'),(96,2,'Mouvements de Stock'),(97,1,'État instantané du stock'),(97,2,'حالة المخزون'),(98,1,'Couverture du stock'),(98,2,'Couverture du stock'),(99,1,'Commandes fournisseurs'),(99,2,'Commandes fournisseurs'),(100,1,'Paramètres'),(100,2,'الإعدادات'),(101,1,'BlockCategories'),(101,2,'BlockCategories'),(102,1,'Dashgoals'),(102,2,'Dashgoals'),(103,1,'StoreCommander'),(103,2,'StoreCommander'),(105,1,'themeconfigurator'),(105,2,'themeconfigurator'),(106,1,'Cobiro'),(106,2,'Cobiro'),(107,1,'Configure'),(107,2,'Configure'),(108,1,'LeoSliderLayer'),(108,2,'LeoSliderLayer'),(109,1,'Leo Theme Configuration'),(109,2,'Leo Theme Configuration'),(110,1,'Leo Positions Control Panel'),(110,2,'Leo Positions Control Panel'),(111,1,'Leo Live Theme Editor'),(111,2,'Leo Live Theme Editor'),(112,1,'Leo Manage widgets'),(112,2,'Leo Manage widgets'),(113,1,'Leo Manage Images'),(113,2,'Leo Manage Images'),(114,1,'Touchize Commerce'),(114,2,'Touchize Commerce'),(115,1,'Touchize Commerce Advanced Settings'),(115,2,'Touchize Commerce Advanced Settings'),(116,1,'Touchize Commerce Choose your look'),(116,2,'Touchize Commerce Choose your look'),(117,1,'Touchize Commerce Banners'),(117,2,'Touchize Commerce Banners'),(118,1,'Touchize Commerce Menus'),(118,2,'Touchize Commerce Menus'),(119,1,'Touchize Commerce Subscription'),(119,2,'Touchize Commerce Subscription'),(120,1,'Top Menu'),(120,2,'Top Menu'),(121,1,'Contact Us'),(121,2,'Contact Us'),(122,1,'Paypal Ajax Handler'),(122,2,'Paypal Ajax Handler'),(123,1,'Smartsupp'),(123,2,'Smartsupp');

--
-- Table structure for table `ps_tab_module_preference`
--

CREATE TABLE `ps_tab_module_preference` (
  `id_tab_module_preference` int(11) NOT NULL AUTO_INCREMENT,
  `id_employee` int(11) NOT NULL,
  `id_tab` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  PRIMARY KEY (`id_tab_module_preference`),
  UNIQUE KEY `employee_module` (`id_employee`,`id_tab`,`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tab_module_preference`
--


--
-- Table structure for table `ps_tag`
--

CREATE TABLE `ps_tag` (
  `id_tag` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tag`),
  KEY `tag_name` (`name`),
  KEY `id_lang` (`id_lang`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tag`
--

INSERT INTO `ps_tag` VALUES (1,1,'Maorc'),(2,1,'Orgue'),(3,1,'Yamaha A 350'),(4,1,'Carte son'),(5,1,'M audio'),(6,1,'2x2'),(7,1,'Studio'),(8,1,'Instrument de muisque'),(9,1,'Yamaha'),(10,1,'Piano'),(14,1,'Pioneer'),(15,1,'DJ'),(16,1,'Table de mixage'),(17,1,'Maroc'),(19,1,'rabat'),(20,1,'prix'),(23,1,'Ampli'),(24,1,'Guitare'),(25,1,'Fender'),(26,1,'Electrique'),(27,1,'Basse'),(28,1,'bass'),(29,1,'rumble'),(30,1,'15 w'),(31,1,'Folk'),(32,1,'AAcoustic'),(33,1,'Acoustique'),(34,1,'électro acoustique'),(35,1,'50 w'),(36,1,'watts'),(37,1,'amplificateur'),(38,1,'YDP 163'),(39,1,'électro'),(40,1,'CX40'),(41,1,'Acoustic'),(43,1,'éléctro-acoustique'),(44,1,'electric'),(45,1,'Electrix'),(46,1,'batterie électrique'),(47,1,'batterie'),(48,1,'batterie électronique'),(49,1,'Clarinet'),(50,1,'Clarinette'),(51,1,'cajon'),(52,1,'cloche'),(53,1,'meinl'),(54,1,'cowbell'),(55,1,'Micro'),(56,1,'Casque'),(57,1,'Headphones'),(58,1,'écouteurs'),(59,1,'ddj'),(60,1,'ddj 400'),(61,1,'العود'),(62,1,'oud'),(63,1,'luth'),(64,1,'turc'),(65,1,'instrument artisanal'),(66,1,'PSR'),(67,1,'F51');

--
-- Table structure for table `ps_tax`
--

CREATE TABLE `ps_tax` (
  `id_tax` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rate` decimal(10,3) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_tax`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax`
--

INSERT INTO `ps_tax` VALUES (1,20.000,1,0),(2,14.000,1,0),(3,10.000,1,0),(4,7.000,1,0),(5,0.000,1,0);

--
-- Table structure for table `ps_tax_lang`
--

CREATE TABLE `ps_tax_lang` (
  `id_tax` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_tax`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_lang`
--

INSERT INTO `ps_tax_lang` VALUES (1,1,'TVA MA 20%'),(1,2,'TVA MA 20%'),(2,1,'TVA MA 14%'),(2,2,'TVA MA 14%'),(3,1,'TVA MA 10%'),(3,2,'TVA MA 10%'),(4,1,'TVA MA 7%'),(4,2,'TVA MA 7%'),(5,1,'TVA MA 0%'),(5,2,'TVA MA 0%');

--
-- Table structure for table `ps_tax_rule`
--

CREATE TABLE `ps_tax_rule` (
  `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT,
  `id_tax_rules_group` int(11) NOT NULL,
  `id_country` int(11) NOT NULL,
  `id_state` int(11) NOT NULL,
  `zipcode_from` varchar(12) NOT NULL,
  `zipcode_to` varchar(12) NOT NULL,
  `id_tax` int(11) NOT NULL,
  `behavior` int(11) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id_tax_rule`),
  KEY `id_tax_rules_group` (`id_tax_rules_group`),
  KEY `id_tax` (`id_tax`),
  KEY `category_getproducts` (`id_tax_rules_group`,`id_country`,`id_state`,`zipcode_from`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rule`
--

INSERT INTO `ps_tax_rule` VALUES (1,1,152,0,'0','0',1,0,''),(2,2,152,0,'0','0',2,0,''),(3,3,152,0,'0','0',3,0,''),(4,4,152,0,'0','0',5,0,'');

--
-- Table structure for table `ps_tax_rules_group`
--

CREATE TABLE `ps_tax_rules_group` (
  `id_tax_rules_group` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `active` int(11) NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rules_group`
--

INSERT INTO `ps_tax_rules_group` VALUES (1,'MA Standard Rate (20%)',1),(2,'MA Reduced Rate (14%)',1),(3,'MA Reduced Rate (10%)',1),(4,'MA Zero Rate (0%)',1);

--
-- Table structure for table `ps_tax_rules_group_shop`
--

CREATE TABLE `ps_tax_rules_group_shop` (
  `id_tax_rules_group` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_tax_rules_group`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_tax_rules_group_shop`
--

INSERT INTO `ps_tax_rules_group_shop` VALUES (1,1),(2,1),(3,1),(4,1);

--
-- Table structure for table `ps_theme`
--

CREATE TABLE `ps_theme` (
  `id_theme` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `directory` varchar(64) NOT NULL,
  `responsive` tinyint(1) NOT NULL DEFAULT '0',
  `default_left_column` tinyint(1) NOT NULL DEFAULT '0',
  `default_right_column` tinyint(1) NOT NULL DEFAULT '0',
  `product_per_page` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_theme`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme`
--

INSERT INTO `ps_theme` VALUES (1,'default-bootstrap','default-bootstrap',1,1,0,20),(2,'ap_funiture','ap_funiture',1,0,0,1);

--
-- Table structure for table `ps_theme_meta`
--

CREATE TABLE `ps_theme_meta` (
  `id_theme_meta` int(11) NOT NULL AUTO_INCREMENT,
  `id_theme` int(11) NOT NULL,
  `id_meta` int(10) unsigned NOT NULL,
  `left_column` tinyint(1) NOT NULL DEFAULT '1',
  `right_column` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_theme_meta`),
  UNIQUE KEY `id_theme_2` (`id_theme`,`id_meta`),
  KEY `id_theme` (`id_theme`),
  KEY `id_meta` (`id_meta`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme_meta`
--

INSERT INTO `ps_theme_meta` VALUES (1,1,1,0,0),(2,1,2,1,0),(3,1,3,0,0),(4,1,4,0,0),(5,1,5,1,0),(6,1,6,1,0),(7,1,7,0,0),(8,1,8,1,0),(9,1,9,1,0),(10,1,10,1,0),(11,1,11,0,0),(12,1,12,0,0),(13,1,13,0,0),(14,1,14,0,0),(15,1,15,0,0),(16,1,16,0,0),(17,1,17,0,0),(18,1,18,0,0),(19,1,19,0,0),(20,1,20,0,0),(21,1,21,0,0),(22,1,22,1,0),(23,1,23,1,0),(24,1,24,0,0),(25,1,25,0,0),(26,1,26,0,0),(27,1,28,1,0),(28,1,29,0,0),(29,1,27,0,0),(30,1,30,0,0),(31,1,31,0,0),(32,1,32,0,0),(33,1,33,0,0),(34,1,34,0,0),(35,1,35,1,0),(39,2,11,0,0),(40,2,12,0,0),(41,2,13,0,0),(42,2,2,1,0),(43,2,14,0,0),(44,2,28,1,0),(45,2,29,0,0),(46,2,3,0,0),(47,2,15,0,0),(48,2,25,0,0),(49,2,16,0,0),(50,2,17,0,0),(51,2,4,0,0),(52,2,5,1,0),(53,2,33,0,0),(54,2,32,0,0),(55,2,30,0,0),(56,2,31,0,0),(57,2,18,0,0),(58,2,6,1,0),(59,2,21,0,0),(60,2,26,0,0),(61,2,19,0,0),(62,2,24,0,0),(63,2,20,0,0),(64,2,7,0,0),(65,2,8,1,0),(66,2,27,0,0),(67,2,34,0,0),(68,2,22,1,0),(69,2,9,1,0),(70,2,23,0,0),(71,2,10,0,0),(72,2,1,0,0),(73,2,35,0,0),(74,2,36,0,0),(75,1,36,1,0);

--
-- Table structure for table `ps_theme_specific`
--

CREATE TABLE `ps_theme_specific` (
  `id_theme` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  `entity` int(11) unsigned NOT NULL,
  `id_object` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_theme`,`id_shop`,`entity`,`id_object`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_theme_specific`
--


--
-- Table structure for table `ps_themeconfigurator`
--

CREATE TABLE `ps_themeconfigurator` (
  `id_item` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `item_order` int(10) unsigned NOT NULL,
  `title` varchar(100) DEFAULT NULL,
  `title_use` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hook` varchar(100) DEFAULT NULL,
  `url` text,
  `target` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `image` varchar(100) DEFAULT NULL,
  `image_w` varchar(10) DEFAULT NULL,
  `image_h` varchar(10) DEFAULT NULL,
  `html` text,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_themeconfigurator`
--


--
-- Table structure for table `ps_timezone`
--

CREATE TABLE `ps_timezone` (
  `id_timezone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY (`id_timezone`)
) ENGINE=InnoDB AUTO_INCREMENT=561 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_timezone`
--

INSERT INTO `ps_timezone` VALUES (1,'Africa/Abidjan'),(2,'Africa/Accra'),(3,'Africa/Addis_Ababa'),(4,'Africa/Algiers'),(5,'Africa/Asmara'),(6,'Africa/Asmera'),(7,'Africa/Bamako'),(8,'Africa/Bangui'),(9,'Africa/Banjul'),(10,'Africa/Bissau'),(11,'Africa/Blantyre'),(12,'Africa/Brazzaville'),(13,'Africa/Bujumbura'),(14,'Africa/Cairo'),(15,'Africa/Casablanca'),(16,'Africa/Ceuta'),(17,'Africa/Conakry'),(18,'Africa/Dakar'),(19,'Africa/Dar_es_Salaam'),(20,'Africa/Djibouti'),(21,'Africa/Douala'),(22,'Africa/El_Aaiun'),(23,'Africa/Freetown'),(24,'Africa/Gaborone'),(25,'Africa/Harare'),(26,'Africa/Johannesburg'),(27,'Africa/Kampala'),(28,'Africa/Khartoum'),(29,'Africa/Kigali'),(30,'Africa/Kinshasa'),(31,'Africa/Lagos'),(32,'Africa/Libreville'),(33,'Africa/Lome'),(34,'Africa/Luanda'),(35,'Africa/Lubumbashi'),(36,'Africa/Lusaka'),(37,'Africa/Malabo'),(38,'Africa/Maputo'),(39,'Africa/Maseru'),(40,'Africa/Mbabane'),(41,'Africa/Mogadishu'),(42,'Africa/Monrovia'),(43,'Africa/Nairobi'),(44,'Africa/Ndjamena'),(45,'Africa/Niamey'),(46,'Africa/Nouakchott'),(47,'Africa/Ouagadougou'),(48,'Africa/Porto-Novo'),(49,'Africa/Sao_Tome'),(50,'Africa/Timbuktu'),(51,'Africa/Tripoli'),(52,'Africa/Tunis'),(53,'Africa/Windhoek'),(54,'America/Adak'),(55,'America/Anchorage '),(56,'America/Anguilla'),(57,'America/Antigua'),(58,'America/Araguaina'),(59,'America/Argentina/Buenos_Aires'),(60,'America/Argentina/Catamarca'),(61,'America/Argentina/ComodRivadavia'),(62,'America/Argentina/Cordoba'),(63,'America/Argentina/Jujuy'),(64,'America/Argentina/La_Rioja'),(65,'America/Argentina/Mendoza'),(66,'America/Argentina/Rio_Gallegos'),(67,'America/Argentina/Salta'),(68,'America/Argentina/San_Juan'),(69,'America/Argentina/San_Luis'),(70,'America/Argentina/Tucuman'),(71,'America/Argentina/Ushuaia'),(72,'America/Aruba'),(73,'America/Asuncion'),(74,'America/Atikokan'),(75,'America/Atka'),(76,'America/Bahia'),(77,'America/Barbados'),(78,'America/Belem'),(79,'America/Belize'),(80,'America/Blanc-Sablon'),(81,'America/Boa_Vista'),(82,'America/Bogota'),(83,'America/Boise'),(84,'America/Buenos_Aires'),(85,'America/Cambridge_Bay'),(86,'America/Campo_Grande'),(87,'America/Cancun'),(88,'America/Caracas'),(89,'America/Catamarca'),(90,'America/Cayenne'),(91,'America/Cayman'),(92,'America/Chicago'),(93,'America/Chihuahua'),(94,'America/Coral_Harbour'),(95,'America/Cordoba'),(96,'America/Costa_Rica'),(97,'America/Cuiaba'),(98,'America/Curacao'),(99,'America/Danmarkshavn'),(100,'America/Dawson'),(101,'America/Dawson_Creek'),(102,'America/Denver'),(103,'America/Detroit'),(104,'America/Dominica'),(105,'America/Edmonton'),(106,'America/Eirunepe'),(107,'America/El_Salvador'),(108,'America/Ensenada'),(109,'America/Fort_Wayne'),(110,'America/Fortaleza'),(111,'America/Glace_Bay'),(112,'America/Godthab'),(113,'America/Goose_Bay'),(114,'America/Grand_Turk'),(115,'America/Grenada'),(116,'America/Guadeloupe'),(117,'America/Guatemala'),(118,'America/Guayaquil'),(119,'America/Guyana'),(120,'America/Halifax'),(121,'America/Havana'),(122,'America/Hermosillo'),(123,'America/Indiana/Indianapolis'),(124,'America/Indiana/Knox'),(125,'America/Indiana/Marengo'),(126,'America/Indiana/Petersburg'),(127,'America/Indiana/Tell_City'),(128,'America/Indiana/Vevay'),(129,'America/Indiana/Vincennes'),(130,'America/Indiana/Winamac'),(131,'America/Indianapolis'),(132,'America/Inuvik'),(133,'America/Iqaluit'),(134,'America/Jamaica'),(135,'America/Jujuy'),(136,'America/Juneau'),(137,'America/Kentucky/Louisville'),(138,'America/Kentucky/Monticello'),(139,'America/Knox_IN'),(140,'America/La_Paz'),(141,'America/Lima'),(142,'America/Los_Angeles'),(143,'America/Louisville'),(144,'America/Maceio'),(145,'America/Managua'),(146,'America/Manaus'),(147,'America/Marigot'),(148,'America/Martinique'),(149,'America/Mazatlan'),(150,'America/Mendoza'),(151,'America/Menominee'),(152,'America/Merida'),(153,'America/Mexico_City'),(154,'America/Miquelon'),(155,'America/Moncton'),(156,'America/Monterrey'),(157,'America/Montevideo'),(158,'America/Montreal'),(159,'America/Montserrat'),(160,'America/Nassau'),(161,'America/New_York'),(162,'America/Nipigon'),(163,'America/Nome'),(164,'America/Noronha'),(165,'America/North_Dakota/Center'),(166,'America/North_Dakota/New_Salem'),(167,'America/Panama'),(168,'America/Pangnirtung'),(169,'America/Paramaribo'),(170,'America/Phoenix'),(171,'America/Port-au-Prince'),(172,'America/Port_of_Spain'),(173,'America/Porto_Acre'),(174,'America/Porto_Velho'),(175,'America/Puerto_Rico'),(176,'America/Rainy_River'),(177,'America/Rankin_Inlet'),(178,'America/Recife'),(179,'America/Regina'),(180,'America/Resolute'),(181,'America/Rio_Branco'),(182,'America/Rosario'),(183,'America/Santarem'),(184,'America/Santiago'),(185,'America/Santo_Domingo'),(186,'America/Sao_Paulo'),(187,'America/Scoresbysund'),(188,'America/Shiprock'),(189,'America/St_Barthelemy'),(190,'America/St_Johns'),(191,'America/St_Kitts'),(192,'America/St_Lucia'),(193,'America/St_Thomas'),(194,'America/St_Vincent'),(195,'America/Swift_Current'),(196,'America/Tegucigalpa'),(197,'America/Thule'),(198,'America/Thunder_Bay'),(199,'America/Tijuana'),(200,'America/Toronto'),(201,'America/Tortola'),(202,'America/Vancouver'),(203,'America/Virgin'),(204,'America/Whitehorse'),(205,'America/Winnipeg'),(206,'America/Yakutat'),(207,'America/Yellowknife'),(208,'Antarctica/Casey'),(209,'Antarctica/Davis'),(210,'Antarctica/DumontDUrville'),(211,'Antarctica/Mawson'),(212,'Antarctica/McMurdo'),(213,'Antarctica/Palmer'),(214,'Antarctica/Rothera'),(215,'Antarctica/South_Pole'),(216,'Antarctica/Syowa'),(217,'Antarctica/Vostok'),(218,'Arctic/Longyearbyen'),(219,'Asia/Aden'),(220,'Asia/Almaty'),(221,'Asia/Amman'),(222,'Asia/Anadyr'),(223,'Asia/Aqtau'),(224,'Asia/Aqtobe'),(225,'Asia/Ashgabat'),(226,'Asia/Ashkhabad'),(227,'Asia/Baghdad'),(228,'Asia/Bahrain'),(229,'Asia/Baku'),(230,'Asia/Bangkok'),(231,'Asia/Beirut'),(232,'Asia/Bishkek'),(233,'Asia/Brunei'),(234,'Asia/Calcutta'),(235,'Asia/Choibalsan'),(236,'Asia/Chongqing'),(237,'Asia/Chungking'),(238,'Asia/Colombo'),(239,'Asia/Dacca'),(240,'Asia/Damascus'),(241,'Asia/Dhaka'),(242,'Asia/Dili'),(243,'Asia/Dubai'),(244,'Asia/Dushanbe'),(245,'Asia/Gaza'),(246,'Asia/Harbin'),(247,'Asia/Ho_Chi_Minh'),(248,'Asia/Hong_Kong'),(249,'Asia/Hovd'),(250,'Asia/Irkutsk'),(251,'Asia/Istanbul'),(252,'Asia/Jakarta'),(253,'Asia/Jayapura'),(254,'Asia/Jerusalem'),(255,'Asia/Kabul'),(256,'Asia/Kamchatka'),(257,'Asia/Karachi'),(258,'Asia/Kashgar'),(259,'Asia/Kathmandu'),(260,'Asia/Katmandu'),(261,'Asia/Kolkata'),(262,'Asia/Krasnoyarsk'),(263,'Asia/Kuala_Lumpur'),(264,'Asia/Kuching'),(265,'Asia/Kuwait'),(266,'Asia/Macao'),(267,'Asia/Macau'),(268,'Asia/Magadan'),(269,'Asia/Makassar'),(270,'Asia/Manila'),(271,'Asia/Muscat'),(272,'Asia/Nicosia'),(273,'Asia/Novosibirsk'),(274,'Asia/Omsk'),(275,'Asia/Oral'),(276,'Asia/Phnom_Penh'),(277,'Asia/Pontianak'),(278,'Asia/Pyongyang'),(279,'Asia/Qatar'),(280,'Asia/Qyzylorda'),(281,'Asia/Rangoon'),(282,'Asia/Riyadh'),(283,'Asia/Saigon'),(284,'Asia/Sakhalin'),(285,'Asia/Samarkand'),(286,'Asia/Seoul'),(287,'Asia/Shanghai'),(288,'Asia/Singapore'),(289,'Asia/Taipei'),(290,'Asia/Tashkent'),(291,'Asia/Tbilisi'),(292,'Asia/Tehran'),(293,'Asia/Tel_Aviv'),(294,'Asia/Thimbu'),(295,'Asia/Thimphu'),(296,'Asia/Tokyo'),(297,'Asia/Ujung_Pandang'),(298,'Asia/Ulaanbaatar'),(299,'Asia/Ulan_Bator'),(300,'Asia/Urumqi'),(301,'Asia/Vientiane'),(302,'Asia/Vladivostok'),(303,'Asia/Yakutsk'),(304,'Asia/Yekaterinburg'),(305,'Asia/Yerevan'),(306,'Atlantic/Azores'),(307,'Atlantic/Bermuda'),(308,'Atlantic/Canary'),(309,'Atlantic/Cape_Verde'),(310,'Atlantic/Faeroe'),(311,'Atlantic/Faroe'),(312,'Atlantic/Jan_Mayen'),(313,'Atlantic/Madeira'),(314,'Atlantic/Reykjavik'),(315,'Atlantic/South_Georgia'),(316,'Atlantic/St_Helena'),(317,'Atlantic/Stanley'),(318,'Australia/ACT'),(319,'Australia/Adelaide'),(320,'Australia/Brisbane'),(321,'Australia/Broken_Hill'),(322,'Australia/Canberra'),(323,'Australia/Currie'),(324,'Australia/Darwin'),(325,'Australia/Eucla'),(326,'Australia/Hobart'),(327,'Australia/LHI'),(328,'Australia/Lindeman'),(329,'Australia/Lord_Howe'),(330,'Australia/Melbourne'),(331,'Australia/North'),(332,'Australia/NSW'),(333,'Australia/Perth'),(334,'Australia/Queensland'),(335,'Australia/South'),(336,'Australia/Sydney'),(337,'Australia/Tasmania'),(338,'Australia/Victoria'),(339,'Australia/West'),(340,'Australia/Yancowinna'),(341,'Europe/Amsterdam'),(342,'Europe/Andorra'),(343,'Europe/Athens'),(344,'Europe/Belfast'),(345,'Europe/Belgrade'),(346,'Europe/Berlin'),(347,'Europe/Bratislava'),(348,'Europe/Brussels'),(349,'Europe/Bucharest'),(350,'Europe/Budapest'),(351,'Europe/Chisinau'),(352,'Europe/Copenhagen'),(353,'Europe/Dublin'),(354,'Europe/Gibraltar'),(355,'Europe/Guernsey'),(356,'Europe/Helsinki'),(357,'Europe/Isle_of_Man'),(358,'Europe/Istanbul'),(359,'Europe/Jersey'),(360,'Europe/Kaliningrad'),(361,'Europe/Kiev'),(362,'Europe/Lisbon'),(363,'Europe/Ljubljana'),(364,'Europe/London'),(365,'Europe/Luxembourg'),(366,'Europe/Madrid'),(367,'Europe/Malta'),(368,'Europe/Mariehamn'),(369,'Europe/Minsk'),(370,'Europe/Monaco'),(371,'Europe/Moscow'),(372,'Europe/Nicosia'),(373,'Europe/Oslo'),(374,'Europe/Paris'),(375,'Europe/Podgorica'),(376,'Europe/Prague'),(377,'Europe/Riga'),(378,'Europe/Rome'),(379,'Europe/Samara'),(380,'Europe/San_Marino'),(381,'Europe/Sarajevo'),(382,'Europe/Simferopol'),(383,'Europe/Skopje'),(384,'Europe/Sofia'),(385,'Europe/Stockholm'),(386,'Europe/Tallinn'),(387,'Europe/Tirane'),(388,'Europe/Tiraspol'),(389,'Europe/Uzhgorod'),(390,'Europe/Vaduz'),(391,'Europe/Vatican'),(392,'Europe/Vienna'),(393,'Europe/Vilnius'),(394,'Europe/Volgograd'),(395,'Europe/Warsaw'),(396,'Europe/Zagreb'),(397,'Europe/Zaporozhye'),(398,'Europe/Zurich'),(399,'Indian/Antananarivo'),(400,'Indian/Chagos'),(401,'Indian/Christmas'),(402,'Indian/Cocos'),(403,'Indian/Comoro'),(404,'Indian/Kerguelen'),(405,'Indian/Mahe'),(406,'Indian/Maldives'),(407,'Indian/Mauritius'),(408,'Indian/Mayotte'),(409,'Indian/Reunion'),(410,'Pacific/Apia'),(411,'Pacific/Auckland'),(412,'Pacific/Chatham'),(413,'Pacific/Easter'),(414,'Pacific/Efate'),(415,'Pacific/Enderbury'),(416,'Pacific/Fakaofo'),(417,'Pacific/Fiji'),(418,'Pacific/Funafuti'),(419,'Pacific/Galapagos'),(420,'Pacific/Gambier'),(421,'Pacific/Guadalcanal'),(422,'Pacific/Guam'),(423,'Pacific/Honolulu'),(424,'Pacific/Johnston'),(425,'Pacific/Kiritimati'),(426,'Pacific/Kosrae'),(427,'Pacific/Kwajalein'),(428,'Pacific/Majuro'),(429,'Pacific/Marquesas'),(430,'Pacific/Midway'),(431,'Pacific/Nauru'),(432,'Pacific/Niue'),(433,'Pacific/Norfolk'),(434,'Pacific/Noumea'),(435,'Pacific/Pago_Pago'),(436,'Pacific/Palau'),(437,'Pacific/Pitcairn'),(438,'Pacific/Ponape'),(439,'Pacific/Port_Moresby'),(440,'Pacific/Rarotonga'),(441,'Pacific/Saipan'),(442,'Pacific/Samoa'),(443,'Pacific/Tahiti'),(444,'Pacific/Tarawa'),(445,'Pacific/Tongatapu'),(446,'Pacific/Truk'),(447,'Pacific/Wake'),(448,'Pacific/Wallis'),(449,'Pacific/Yap'),(450,'Brazil/Acre'),(451,'Brazil/DeNoronha'),(452,'Brazil/East'),(453,'Brazil/West'),(454,'Canada/Atlantic'),(455,'Canada/Central'),(456,'Canada/East-Saskatchewan'),(457,'Canada/Eastern'),(458,'Canada/Mountain'),(459,'Canada/Newfoundland'),(460,'Canada/Pacific'),(461,'Canada/Saskatchewan'),(462,'Canada/Yukon'),(463,'CET'),(464,'Chile/Continental'),(465,'Chile/EasterIsland'),(466,'CST6CDT'),(467,'Cuba'),(468,'EET'),(469,'Egypt'),(470,'Eire'),(471,'EST'),(472,'EST5EDT'),(473,'Etc/GMT'),(474,'Etc/GMT+0'),(475,'Etc/GMT+1'),(476,'Etc/GMT+10'),(477,'Etc/GMT+11'),(478,'Etc/GMT+12'),(479,'Etc/GMT+2'),(480,'Etc/GMT+3'),(481,'Etc/GMT+4'),(482,'Etc/GMT+5'),(483,'Etc/GMT+6'),(484,'Etc/GMT+7'),(485,'Etc/GMT+8'),(486,'Etc/GMT+9'),(487,'Etc/GMT-0'),(488,'Etc/GMT-1'),(489,'Etc/GMT-10'),(490,'Etc/GMT-11'),(491,'Etc/GMT-12'),(492,'Etc/GMT-13'),(493,'Etc/GMT-14'),(494,'Etc/GMT-2'),(495,'Etc/GMT-3'),(496,'Etc/GMT-4'),(497,'Etc/GMT-5'),(498,'Etc/GMT-6'),(499,'Etc/GMT-7'),(500,'Etc/GMT-8'),(501,'Etc/GMT-9'),(502,'Etc/GMT0'),(503,'Etc/Greenwich'),(504,'Etc/UCT'),(505,'Etc/Universal'),(506,'Etc/UTC'),(507,'Etc/Zulu'),(508,'Factory'),(509,'GB'),(510,'GB-Eire'),(511,'GMT'),(512,'GMT+0'),(513,'GMT-0'),(514,'GMT0'),(515,'Greenwich'),(516,'Hongkong'),(517,'HST'),(518,'Iceland'),(519,'Iran'),(520,'Israel'),(521,'Jamaica'),(522,'Japan'),(523,'Kwajalein'),(524,'Libya'),(525,'MET'),(526,'Mexico/BajaNorte'),(527,'Mexico/BajaSur'),(528,'Mexico/General'),(529,'MST'),(530,'MST7MDT'),(531,'Navajo'),(532,'NZ'),(533,'NZ-CHAT'),(534,'Poland'),(535,'Portugal'),(536,'PRC'),(537,'PST8PDT'),(538,'ROC'),(539,'ROK'),(540,'Singapore'),(541,'Turkey'),(542,'UCT'),(543,'Universal'),(544,'US/Alaska'),(545,'US/Aleutian'),(546,'US/Arizona'),(547,'US/Central'),(548,'US/East-Indiana'),(549,'US/Eastern'),(550,'US/Hawaii'),(551,'US/Indiana-Starke'),(552,'US/Michigan'),(553,'US/Mountain'),(554,'US/Pacific'),(555,'US/Pacific-New'),(556,'US/Samoa'),(557,'UTC'),(558,'W-SU'),(559,'WET'),(560,'Zulu');

--
-- Table structure for table `ps_touchize_actionarea`
--

CREATE TABLE `ps_touchize_actionarea` (
  `id_touchize_actionarea` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tx` varchar(255) DEFAULT NULL,
  `ty` varchar(255) DEFAULT NULL,
  `width` varchar(255) DEFAULT NULL,
  `height` varchar(255) DEFAULT NULL,
  `id_product` int(10) DEFAULT NULL,
  `id_product_attribute` varchar(255) DEFAULT NULL,
  `id_category` int(10) DEFAULT NULL,
  `search_term` varchar(255) DEFAULT NULL,
  `id_touchize_touchmap` int(10) unsigned DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_touchize_actionarea`),
  KEY `id_touchize_touchmap` (`id_touchize_touchmap`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_actionarea`
--


--
-- Table structure for table `ps_touchize_main_menu`
--

CREATE TABLE `ps_touchize_main_menu` (
  `id_menu_item` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('menu-item','menu-header','menu-divider') DEFAULT NULL,
  `action` enum('page','cms_page','url','event') DEFAULT NULL,
  `page` int(10) DEFAULT NULL,
  `cms_page` int(10) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `external` int(1) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `event_input` varchar(255) DEFAULT NULL,
  `page_url` varchar(255) DEFAULT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_menu_item`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_main_menu`
--

INSERT INTO `ps_touchize_main_menu` VALUES (1,'menu-item','page',3,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `ps_touchize_main_menu_lang`
--

CREATE TABLE `ps_touchize_main_menu_lang` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_lang` int(10) DEFAULT NULL,
  `id_menu_item` int(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_main_menu_lang`
--

INSERT INTO `ps_touchize_main_menu_lang` VALUES (1,1,1,NULL),(2,2,1,NULL);

--
-- Table structure for table `ps_touchize_touchmap`
--

CREATE TABLE `ps_touchize_touchmap` (
  `id_touchize_touchmap` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned DEFAULT NULL,
  `imageurl` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `mobile` tinyint(1) NOT NULL DEFAULT '1',
  `tablet` tinyint(1) NOT NULL DEFAULT '1',
  `runonce` tinyint(1) NOT NULL DEFAULT '0',
  `new_products` tinyint(1) NOT NULL DEFAULT '0',
  `best_sellers` tinyint(1) NOT NULL DEFAULT '0',
  `prices_drop` tinyint(1) NOT NULL DEFAULT '0',
  `home_page` tinyint(1) NOT NULL DEFAULT '0',
  `inslider` tinyint(1) NOT NULL DEFAULT '1',
  `position` int(10) unsigned DEFAULT NULL,
  `width` int(10) unsigned DEFAULT NULL,
  `height` int(10) unsigned DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_touchize_touchmap`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_touchmap`
--

INSERT INTO `ps_touchize_touchmap` VALUES (1,0,'','Touchize Banner',1,1,1,0,0,0,0,1,0,0,1770,1178,'2018-10-04 17:51:21','2018-10-04 17:53:16');

--
-- Table structure for table `ps_touchize_touchmapcategory`
--

CREATE TABLE `ps_touchize_touchmapcategory` (
  `id_touchize_touchmap` int(10) unsigned NOT NULL,
  `id_category` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_touchize_touchmap`,`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_touchmapcategory`
--


--
-- Table structure for table `ps_touchize_variables`
--

CREATE TABLE `ps_touchize_variables` (
  `id_variable` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) DEFAULT NULL,
  `id_shop_group` int(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `is_color` tinyint(1) NOT NULL DEFAULT '0',
  `template` varchar(255) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_variable`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_variables`
--

INSERT INTO `ps_touchize_variables` VALUES (1,NULL,NULL,'@price-color','','#2C2A29',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(2,NULL,NULL,'@price-new-color','','#DE002D',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(3,NULL,NULL,'@price-old-color','','#8A8D8F',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(4,NULL,NULL,'@item-title-color','','#8A8D8F',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(5,NULL,NULL,'@topbar-background-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(6,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(7,NULL,NULL,'@cartsummary-text-color','','#2C2A29',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(8,NULL,NULL,'@checkoutbutton-background-color','','#009CDE',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(9,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(10,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(11,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(12,NULL,NULL,'@price-color','','#000',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(13,NULL,NULL,'@price-new-color','','#DE002D',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(14,NULL,NULL,'@price-old-color','','#D8D8D8',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(15,NULL,NULL,'@item-title-color','','#4A4A4A',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(16,NULL,NULL,'@topbar-background-color','','#08C299',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(17,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(18,NULL,NULL,'@cartsummary-text-color','','#000',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(19,NULL,NULL,'@checkoutbutton-background-color','','#08C299',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(20,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(21,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(22,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(23,NULL,NULL,'@price-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(24,NULL,NULL,'@price-new-color','','#DE002D',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(25,NULL,NULL,'@price-old-color','','#8A8D8F',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(26,NULL,NULL,'@item-title-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(27,NULL,NULL,'@topbar-background-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(28,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(29,NULL,NULL,'@cartsummary-text-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(30,NULL,NULL,'@checkoutbutton-background-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(31,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(32,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(33,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24');

--
-- Table structure for table `ps_touchize_variables_preview`
--

CREATE TABLE `ps_touchize_variables_preview` (
  `id_variable` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) DEFAULT NULL,
  `id_shop_group` int(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `is_color` tinyint(1) NOT NULL DEFAULT '0',
  `template` varchar(255) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_variable`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_touchize_variables_preview`
--

INSERT INTO `ps_touchize_variables_preview` VALUES (1,NULL,NULL,'@price-color','','#2C2A29',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(2,NULL,NULL,'@price-new-color','','#DE002D',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(3,NULL,NULL,'@price-old-color','','#8A8D8F',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(4,NULL,NULL,'@item-title-color','','#8A8D8F',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(5,NULL,NULL,'@topbar-background-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(6,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(7,NULL,NULL,'@cartsummary-text-color','','#2C2A29',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(8,NULL,NULL,'@checkoutbutton-background-color','','#009CDE',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(9,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(10,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(11,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'classic/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(12,NULL,NULL,'@price-color','','#000',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(13,NULL,NULL,'@price-new-color','','#DE002D',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(14,NULL,NULL,'@price-old-color','','#D8D8D8',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(15,NULL,NULL,'@item-title-color','','#4A4A4A',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(16,NULL,NULL,'@topbar-background-color','','#08C299',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(17,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(18,NULL,NULL,'@cartsummary-text-color','','#000',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(19,NULL,NULL,'@checkoutbutton-background-color','','#08C299',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(20,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(21,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(22,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'lines/latest','2020-03-04 01:47:23','2020-03-04 01:47:23'),(23,NULL,NULL,'@price-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(24,NULL,NULL,'@price-new-color','','#DE002D',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(25,NULL,NULL,'@price-old-color','','#8A8D8F',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(26,NULL,NULL,'@item-title-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(27,NULL,NULL,'@topbar-background-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(28,NULL,NULL,'@cartsummary-background-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(29,NULL,NULL,'@cartsummary-text-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(30,NULL,NULL,'@checkoutbutton-background-color','','#2C2A29',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(31,NULL,NULL,'@checkoutbutton-text-color','','#FFF',1,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(32,NULL,NULL,'@body-font-family','','\'Quattrocento Sans\',arial,sans-serif',0,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24'),(33,NULL,NULL,'@heading-font-family','','\'Exo 2\',serif',0,'clean/latest','2020-03-04 01:47:24','2020-03-04 01:47:24');

--
-- Table structure for table `ps_warehouse`
--

CREATE TABLE `ps_warehouse` (
  `id_warehouse` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_currency` int(11) unsigned NOT NULL,
  `id_address` int(11) unsigned NOT NULL,
  `id_employee` int(11) unsigned NOT NULL,
  `reference` varchar(32) DEFAULT NULL,
  `name` varchar(45) NOT NULL,
  `management_type` enum('WA','FIFO','LIFO') NOT NULL DEFAULT 'WA',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse`
--


--
-- Table structure for table `ps_warehouse_carrier`
--

CREATE TABLE `ps_warehouse_carrier` (
  `id_carrier` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_carrier`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_carrier` (`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_carrier`
--


--
-- Table structure for table `ps_warehouse_product_location`
--

CREATE TABLE `ps_warehouse_product_location` (
  `id_warehouse_product_location` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_product_attribute` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  `location` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_warehouse_product_location`),
  UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_product_location`
--


--
-- Table structure for table `ps_warehouse_shop`
--

CREATE TABLE `ps_warehouse_shop` (
  `id_shop` int(11) unsigned NOT NULL,
  `id_warehouse` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_warehouse`,`id_shop`),
  KEY `id_warehouse` (`id_warehouse`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_warehouse_shop`
--


--
-- Table structure for table `ps_web_browser`
--

CREATE TABLE `ps_web_browser` (
  `id_web_browser` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id_web_browser`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_web_browser`
--

INSERT INTO `ps_web_browser` VALUES (1,'Safari'),(2,'Safari iPad'),(3,'Firefox'),(4,'Opera'),(5,'IE 6'),(6,'IE 7'),(7,'IE 8'),(8,'IE 9'),(9,'IE 10'),(10,'IE 11'),(11,'Chrome');

--
-- Table structure for table `ps_webservice_account`
--

CREATE TABLE `ps_webservice_account` (
  `id_webservice_account` int(11) NOT NULL AUTO_INCREMENT,
  `key` varchar(32) NOT NULL,
  `description` text,
  `class_name` varchar(50) NOT NULL DEFAULT 'WebserviceRequest',
  `is_module` tinyint(2) NOT NULL DEFAULT '0',
  `module_name` varchar(50) DEFAULT NULL,
  `active` tinyint(2) NOT NULL,
  PRIMARY KEY (`id_webservice_account`),
  KEY `key` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_account`
--

INSERT INTO `ps_webservice_account` VALUES (1,'MTHNKFAZVCCSEGZVXFNZFQXY9CDEIA5R','Cobiro Access','WebserviceRequest',0,'cobiro',1),(2,'nz5AMEk7KLVApXIX5Hib9vQqcTjLnZc6','CleverPPC webservice key','WebserviceRequest',0,NULL,1);

--
-- Table structure for table `ps_webservice_account_shop`
--

CREATE TABLE `ps_webservice_account_shop` (
  `id_webservice_account` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_webservice_account`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_account_shop`
--

INSERT INTO `ps_webservice_account_shop` VALUES (1,1),(2,1);

--
-- Table structure for table `ps_webservice_permission`
--

CREATE TABLE `ps_webservice_permission` (
  `id_webservice_permission` int(11) NOT NULL AUTO_INCREMENT,
  `resource` varchar(50) NOT NULL,
  `method` enum('GET','POST','PUT','DELETE','HEAD') NOT NULL,
  `id_webservice_account` int(11) NOT NULL,
  PRIMARY KEY (`id_webservice_permission`),
  UNIQUE KEY `resource_2` (`resource`,`method`,`id_webservice_account`),
  KEY `resource` (`resource`),
  KEY `method` (`method`),
  KEY `id_webservice_account` (`id_webservice_account`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_webservice_permission`
--

INSERT INTO `ps_webservice_permission` VALUES (16,'cart_rules','GET',2),(4,'categories','GET',1),(17,'categories','GET',2),(1,'cobiro','GET',1),(2,'cobiro','POST',1),(8,'combinations','GET',1),(18,'configurations','GET',2),(19,'content_management_system','GET',2),(20,'countries','GET',2),(21,'currencies','GET',2),(22,'deliveries','GET',2),(23,'employees','GET',2),(24,'groups','GET',2),(25,'guests','GET',2),(27,'images','GET',2),(26,'image_types','GET',2),(9,'languages','GET',1),(28,'languages','GET',2),(15,'manufacturers','GET',1),(5,'orders','GET',1),(33,'orders','GET',2),(29,'order_carriers','GET',2),(30,'order_details','GET',2),(31,'order_discounts','GET',2),(32,'order_histories','GET',2),(10,'order_states','GET',1),(34,'price_ranges','GET',2),(3,'products','GET',1),(40,'products','GET',2),(36,'product_features','GET',2),(35,'product_feature_values','GET',2),(6,'product_options','GET',1),(38,'product_options','GET',2),(7,'product_option_values','GET',1),(37,'product_option_values','GET',2),(39,'product_suppliers','GET',2),(43,'shops','GET',2),(41,'shop_groups','GET',2),(42,'shop_urls','GET',2),(45,'specific_prices','GET',2),(44,'specific_price_rules','GET',2),(46,'states','GET',2),(50,'stocks','GET',2),(14,'stock_availables','GET',1),(47,'stock_availables','GET',2),(49,'stock_movements','GET',2),(48,'stock_movement_reasons','GET',2),(51,'stores','GET',2),(52,'suppliers','GET',2),(53,'supply_order_histories','GET',2),(54,'tags','GET',2),(13,'taxes','GET',1),(12,'tax_rules','GET',1),(11,'tax_rule_groups','GET',1),(55,'translated_configurations','GET',2),(56,'weight_ranges','GET',2),(57,'zones','GET',2);

--
-- Table structure for table `ps_zone`
--

CREATE TABLE `ps_zone` (
  `id_zone` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_zone`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_zone`
--

INSERT INTO `ps_zone` VALUES (1,'Europe',1),(2,'North America',1),(3,'Asia',1),(4,'Africa',1),(5,'Oceania',1),(6,'South America',1),(7,'Europe (non-EU)',1),(8,'Central America/Antilla',1);

--
-- Table structure for table `ps_zone_shop`
--

CREATE TABLE `ps_zone_shop` (
  `id_zone` int(11) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_zone`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_zone_shop`
--

INSERT INTO `ps_zone_shop` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1);


