-- Table structure for table `ps_aeuc_cmsrole_email`
--

CREATE TABLE `ps_aeuc_cmsrole_email` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cms_role` int(11) NOT NULL,
  `id_mail` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_aeuc_cmsrole_email`
--


--
-- Table structure for table `ps_aeuc_email`
--

CREATE TABLE `ps_aeuc_email` (
  `id_mail` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(64) NOT NULL,
  `display_name` varchar(64) NOT NULL,
  PRIMARY KEY (`id_mail`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_aeuc_email`
--

INSERT INTO `ps_aeuc_email` (`id_mail`, `filename`, `display_name`) VALUES (1,'account','Account'),(2,'backoffice_order','Backoffice order'),(3,'bankwire','Bankwire'),(4,'cheque','Cheque'),(5,'contact','Contact'),(6,'contact_form','Contact form'),(7,'credit_slip','Credit slip'),(8,'download_product','Download product'),(9,'employee_password','Employee password'),(10,'forward_msg','Forward msg'),(11,'guest_to_customer','Guest to customer'),(12,'in_transit','In transit'),(13,'log_alert','Log alert'),(14,'newsletter','Newsletter'),(15,'order_canceled','Order canceled'),(16,'order_changed','Order changed'),(17,'order_conf','Order conf'),(18,'order_customer_comment','Order customer comment'),(19,'order_merchant_comment','Order merchant comment'),(20,'order_return_state','Order return state'),(21,'outofstock','Outofstock'),(22,'password','Password'),(23,'password_query','Password query'),(24,'payment','Payment'),(25,'payment_error','Payment error'),(26,'preparation','Preparation'),(27,'refund','Refund'),(28,'reply_msg','Reply msg'),(29,'shipped','Shipped'),(30,'test','Test'),(31,'voucher','Voucher'),(32,'voucher_new','Voucher new');

--
-- Table structure for table `ps_alias`
--

CREATE TABLE `ps_alias` (
  `id_alias` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alias` varchar(255) NOT NULL,
  `search` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_alias`),
  UNIQUE KEY `alias` (`alias`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_alias`
--

INSERT INTO `ps_alias` (`id_alias`, `alias`, `search`, `active`) VALUES (1,'bloose','blouse',0),(2,'blues','blouse',0);

--
-- Table structure for table `ps_attachment`
--

CREATE TABLE `ps_attachment` (
  `id_attachment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file` varchar(40) NOT NULL,
  `file_name` varchar(128) NOT NULL,
  `file_size` bigint(10) unsigned NOT NULL DEFAULT '0',
  `mime` varchar(128) NOT NULL,
  PRIMARY KEY (`id_attachment`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attachment`
--


--
-- Table structure for table `ps_attachment_lang`
--

CREATE TABLE `ps_attachment_lang` (
  `id_attachment` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(32) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id_attachment`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attachment_lang`
--


--
-- Table structure for table `ps_attribute`
--

CREATE TABLE `ps_attribute` (
  `id_attribute` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_attribute_group` int(10) unsigned NOT NULL,
  `color` varchar(32) DEFAULT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_attribute`),
  KEY `attribute_group` (`id_attribute_group`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attribute`
--

INSERT INTO `ps_attribute` (`id_attribute`, `id_attribute_group`, `color`, `position`) VALUES (1,1,'',0),(2,1,'',1),(3,1,'',2),(4,1,'',3),(5,3,'#AAB2BD',0),(6,3,'#CFC4A6',1),(7,3,'#f5f5dc',2),(8,3,'#ffffff',3),(9,3,'#faebd7',4),(10,3,'#E84C3D',5),(11,3,'#434A54',6),(12,3,'#C19A6B',7),(13,3,'#F39C11',8),(14,3,'#5D9CEC',9),(15,3,'#A0D468',10),(16,3,'#F1C40F',11),(17,3,'#964B00',12),(18,2,'',0),(19,2,'',1),(20,2,'',2),(21,2,'',3),(22,2,'',4),(23,2,'',5),(24,3,'#FCCACD',13),(25,4,'',0),(26,4,'',1),(27,4,'',2),(28,6,'',0),(29,6,'',1),(30,6,'',2),(31,6,'',3),(32,6,'',4),(33,6,'',5),(34,6,'',6),(35,6,'',7),(36,6,'',8),(37,6,'',9),(38,3,'#fffef4',14),(39,6,'',10),(40,6,'',11),(41,6,'',12),(42,6,'',13),(43,6,'',14),(44,6,'',15),(45,6,'',16),(46,6,'',17),(47,6,'',18),(48,6,'',19),(49,7,'',0),(50,7,'',1),(51,7,'',2),(52,7,'',3),(53,7,'',4),(54,7,'',5),(55,7,'',6),(56,7,'',7),(57,8,'',0),(58,8,'',1),(59,8,'',2),(60,8,'',3),(61,8,'',4),(62,8,'',5),(63,6,'',20),(64,6,'',21),(65,6,'',22),(66,6,'',23),(67,6,'',24),(68,6,'',25),(69,6,'',26),(70,6,'',27),(71,6,'',28),(72,6,'',29),(73,7,'',8),(74,7,'',9),(75,7,'',10),(76,6,'',30),(77,6,'',31),(78,6,'',32),(79,6,'',33),(80,6,'',34),(81,9,'',0),(82,9,'',1),(83,9,'',2),(84,9,'',3),(85,9,'',4),(86,9,'',5),(87,9,'',6),(88,9,'',7),(89,9,'',8),(90,9,'',9),(91,9,'',10),(92,9,'',11),(93,9,'',12),(94,9,'',13),(95,9,'',14),(96,9,'',15),(97,6,'',35),(98,6,'',36),(99,6,'',37),(100,6,'',38),(101,6,'',39),(102,6,'',40);

--
-- Table structure for table `ps_attribute_group`
--

CREATE TABLE `ps_attribute_group` (
  `id_attribute_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `is_color_group` tinyint(1) NOT NULL DEFAULT '0',
  `group_type` enum('select','radio','color') NOT NULL DEFAULT 'select',
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_attribute_group`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attribute_group`
--

INSERT INTO `ps_attribute_group` (`id_attribute_group`, `is_color_group`, `group_type`, `position`) VALUES (1,0,'select',0),(2,0,'select',1),(3,1,'color',2),(4,0,'select',3),(6,0,'select',4),(7,0,'select',5),(8,0,'select',6),(9,0,'select',7);

--
-- Table structure for table `ps_attribute_group_lang`
--

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

--
-- Dumping data for table `ps_attribute_group_lang`
--

INSERT INTO `ps_attribute_group_lang` (`id_attribute_group`, `id_lang`, `name`, `public_name`) VALUES (1,1,'Size','Size'),(1,2,'Size','Size'),(2,1,'Shoes Size','Size'),(2,2,'Shoes Size','Size'),(3,1,'Color','Color'),(3,2,'Color','Color'),(4,1,'Doudou Sweety','Doudou Sweety Models'),(4,2,'Doudou Sweety','Doudou Sweety Models'),(6,1,'Model','Model'),(6,2,'Model','Model'),(7,1,'Puppet Model','Puppet Model'),(7,2,'Puppet Model','Puppet Model'),(8,1,'Mini Doudou','Mini Doudou'),(8,2,'Mini Doudou','Mini Doudou'),(9,1,'Pacifier Holder','Pacifier Holder'),(9,2,'Pacifier Holder','Pacifier Holder');

--
-- Table structure for table `ps_attribute_group_shop`
--

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

--
-- Dumping data for table `ps_attribute_group_shop`
--

INSERT INTO `ps_attribute_group_shop` (`id_attribute_group`, `id_shop`) VALUES (1,1),(2,1),(3,1),(4,1),(6,1),(7,1),(8,1),(9,1);

--
-- Table structure for table `ps_attribute_impact`
--

CREATE TABLE `ps_attribute_impact` (
  `id_attribute_impact` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(11) unsigned NOT NULL,
  `id_attribute` int(11) unsigned NOT NULL,
  `weight` decimal(20,6) NOT NULL,
  `price` decimal(17,2) NOT NULL,
  PRIMARY KEY (`id_attribute_impact`),
  UNIQUE KEY `id_product` (`id_product`,`id_attribute`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attribute_impact`
--

INSERT INTO `ps_attribute_impact` (`id_attribute_impact`, `id_product`, `id_attribute`, `weight`, `price`) VALUES (4,131,25,0.000000,0.00),(5,131,26,0.000000,0.00),(6,131,27,0.000000,0.00);

--
-- Table structure for table `ps_attribute_lang`
--

CREATE TABLE `ps_attribute_lang` (
  `id_attribute` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(128) NOT NULL,
  PRIMARY KEY (`id_attribute`,`id_lang`),
  KEY `id_lang` (`id_lang`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_attribute_lang`
--

INSERT INTO `ps_attribute_lang` (`id_attribute`, `id_lang`, `name`) VALUES (18,1,'35'),(19,1,'36'),(20,1,'37'),(21,1,'38'),(22,1,'39'),(23,1,'40'),(81,1,'Amerindian Bear'),(82,1,'Amerindian Rabbit'),(83,1,'Baby Rabbit'),(25,1,'Bear'),(50,1,'Bear'),(76,1,'Bear'),(31,1,'Bear Head'),(35,1,'Bebe d Amour'),(7,1,'Beige'),(11,1,'Black'),(45,1,'Blanche'),(14,1,'Blue'),(28,1,'Blue'),(60,1,'Blue Bear'),(74,1,'Blue Bear'),(84,1,'Blue Bear'),(102,1,'Blue Bear'),(67,1,'Blue Rabbit'),(85,1,'Blue Rabbit'),(17,1,'Brown'),(37,1,'Brown'),(86,1,'Brown Bear'),(98,1,'Brown Rabbit'),(12,1,'Camel'),(46,1,'Camelia'),(73,1,'Cat'),(79,1,'Cat'),(87,1,'Celeste Rabbit'),(33,1,'Dancing Shoe'),(51,1,'Donkey'),(63,1,'Elephant'),(40,1,'Flower Coral'),(39,1,'Flower White'),(78,1,'Fox'),(43,1,'Fraise'),(15,1,'Green'),(68,1,'Green Bear'),(5,1,'Grey'),(57,1,'Grey Rabbit'),(52,1,'Hippo'),(47,1,'Hortensia'),(38,1,'Ivory'),(88,1,'Joker Bear'),(3,1,'L'),(49,1,'Ladybird'),(89,1,'Ladybird'),(64,1,'Lion'),(2,1,'M'),(99,1,'Mint Rabbit'),(26,1,'Mouse'),(53,1,'Mouse'),(80,1,'Mouse'),(30,1,'Mulicolore'),(61,1,'Multicolor Bear'),(59,1,'Multicolor Rabbit'),(90,1,'Multicoloured Mouse'),(9,1,'Off White'),(4,1,'One size'),(13,1,'Orange'),(91,1,'Orange Blue Bear'),(92,1,'Orange Dog'),(44,1,'Orchidee'),(54,1,'Panda'),(65,1,'Panda'),(75,1,'Peach Bear'),(48,1,'Peche'),(55,1,'Penguin'),(24,1,'Pink'),(36,1,'Pink'),(100,1,'Pink Bear'),(69,1,'Pink Mouse'),(93,1,'Pink Orange Rabbit'),(58,1,'Pink Rabbit'),(94,1,'Pink Rabbit'),(97,1,'Pink Rabbit'),(34,1,'Ptit Bout'),(62,1,'Purple Bear'),(101,1,'Purple Bear'),(70,1,'Purple Rabbit'),(27,1,'Rabbit'),(56,1,'Rabbit'),(66,1,'Rabbit'),(10,1,'Red'),(71,1,'Red Dog'),(1,1,'S'),(77,1,'Sheep'),(32,1,'Shoe Imitation'),(95,1,'Sleeping Bear'),(96,1,'Sleeping Mouse'),(29,1,'Stripes'),(6,1,'Taupe'),(8,1,'White'),(41,1,'Wind Mill Beige'),(42,1,'Wind Mill Blue'),(16,1,'Yellow'),(72,1,'Yellow Bear'),(18,2,'35'),(19,2,'36'),(20,2,'37'),(21,2,'38'),(22,2,'39'),(23,2,'40'),(81,2,'Amerindian Bear'),(82,2,'Amerindian Rabbit'),(83,2,'Baby Rabbit'),(25,2,'Bear'),(50,2,'Bear'),(76,2,'Bear'),(31,2,'Bear Head'),(35,2,'Bebe d Amour'),(7,2,'Beige'),(11,2,'Black'),(45,2,'Blanche'),(14,2,'Blue'),(28,2,'Blue'),(60,2,'Blue Bear'),(74,2,'Blue Bear'),(84,2,'Blue Bear'),(102,2,'Blue Bear'),(67,2,'Blue Rabbit'),(85,2,'Blue Rabbit'),(17,2,'Brown'),(37,2,'Brown'),(86,2,'Brown Bear'),(98,2,'Brown Rabbit'),(12,2,'Camel'),(46,2,'Camelia'),(73,2,'Cat'),(79,2,'Cat'),(87,2,'Celeste Rabbit'),(33,2,'Dancing Shoe'),(51,2,'Donkey'),(63,2,'Elephant'),(40,2,'Flower Coral'),(39,2,'Flower White'),(78,2,'Fox'),(43,2,'Fraise'),(15,2,'Green'),(68,2,'Green Bear'),(5,2,'Grey'),(57,2,'Grey Rabbit'),(52,2,'Hippo'),(47,2,'Hortensia'),(38,2,'Ivory'),(88,2,'Joker Bear'),(3,2,'L'),(49,2,'Ladybird'),(89,2,'Ladybird'),(64,2,'Lion'),(2,2,'M'),(99,2,'Mint Rabbit'),(26,2,'Mouse'),(53,2,'Mouse'),(80,2,'Mouse'),(30,2,'Mulicolore'),(61,2,'Multicolor Bear'),(59,2,'Multicolor Rabbit'),(90,2,'Multicoloured Mouse'),(9,2,'Off White'),(4,2,'One size'),(13,2,'Orange'),(91,2,'Orange Blue Bear'),(92,2,'Orange Dog'),(44,2,'Orchidee'),(54,2,'Panda'),(65,2,'Panda'),(75,2,'Peach Bear'),(48,2,'Peche'),(55,2,'Penguin'),(24,2,'Pink'),(36,2,'Pink'),(100,2,'Pink Bear'),(69,2,'Pink Mouse'),(93,2,'Pink Orange Rabbit'),(58,2,'Pink Rabbit'),(94,2,'Pink Rabbit'),(97,2,'Pink Rabbit'),(34,2,'Ptit Bout'),(62,2,'Purple Bear'),(101,2,'Purple Bear'),(70,2,'Purple Rabbit'),(27,2,'Rabbit'),(56,2,'Rabbit'),(66,2,'Rabbit'),(10,2,'Red'),(71,2,'Red Dog'),(1,2,'S'),(77,2,'Sheep'),(32,2,'Shoe Imitation'),(95,2,'Sleeping Bear'),(96,2,'Sleeping Mouse'),(29,2,'Stripes'),(6,2,'Taupe'),(8,2,'White'),(41,2,'Wind Mill Beige'),(42,2,'Wind Mill Blue'),(16,2,'Yellow'),(72,2,'Yellow Bear');

--
-- Table structure for table `ps_attribute_shop`
--

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

--
-- Dumping data for table `ps_attribute_shop`
--

INSERT INTO `ps_attribute_shop` (`id_attribute`, `id_shop`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(71,1),(72,1),(73,1),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(98,1),(99,1),(100,1),(101,1),(102,1);

--
-- Table structure for table `ps_badge`
--

CREATE TABLE `ps_badge` (
  `id_badge` int(11) NOT NULL AUTO_INCREMENT,
  `id_ps_badge` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `id_group` int(11) NOT NULL,
  `group_position` int(11) NOT NULL,
  `scoring` int(11) NOT NULL,
  `awb` int(11) DEFAULT '0',
  `validated` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_badge`)
) ENGINE=InnoDB AUTO_INCREMENT=235 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_badge`
--

INSERT INTO `ps_badge` (`id_badge`, `id_ps_badge`, `type`, `id_group`, `group_position`, `scoring`, `awb`, `validated`) VALUES (1,159,'feature',41,1,5,1,0),(2,160,'feature',41,2,10,1,0),(3,161,'feature',41,3,15,1,0),(4,162,'feature',41,4,20,1,0),(5,163,'feature',41,1,5,1,0),(6,164,'feature',41,2,10,1,0),(7,165,'feature',41,3,15,1,0),(8,166,'feature',41,4,20,1,0),(9,195,'feature',41,1,5,1,0),(10,196,'feature',41,2,10,1,0),(11,229,'feature',41,1,5,1,0),(12,230,'feature',41,2,10,1,0),(13,231,'feature',41,3,15,1,0),(14,232,'feature',41,4,20,1,0),(15,233,'feature',41,1,5,1,0),(16,234,'feature',41,2,10,1,0),(17,235,'feature',41,3,15,1,0),(18,236,'feature',41,4,20,1,0),(19,241,'feature',41,1,5,1,0),(20,242,'feature',41,2,10,1,0),(21,243,'feature',41,3,15,1,0),(22,244,'feature',41,4,20,1,0),(23,249,'feature',41,1,5,1,0),(24,250,'feature',41,2,10,1,0),(25,251,'feature',41,3,15,1,0),(26,252,'feature',41,4,20,1,0),(27,253,'feature',41,1,5,1,0),(28,254,'feature',41,2,10,1,0),(29,255,'feature',41,3,15,1,0),(30,256,'feature',41,4,20,1,0),(31,261,'feature',41,1,5,1,0),(32,262,'feature',41,2,10,1,0),(33,269,'feature',41,1,5,1,0),(34,270,'feature',41,2,10,1,0),(35,271,'feature',41,3,15,1,0),(36,272,'feature',41,4,20,1,0),(37,273,'feature',41,1,5,1,0),(38,274,'feature',41,2,10,1,0),(39,275,'feature',41,3,15,1,0),(40,276,'feature',41,4,20,1,0),(41,277,'feature',41,1,5,1,0),(42,278,'feature',41,2,10,1,0),(43,279,'feature',41,3,15,1,0),(44,280,'feature',41,4,20,1,0),(45,281,'feature',41,1,5,1,0),(46,282,'feature',41,2,10,1,0),(47,283,'feature',41,3,15,1,0),(48,284,'feature',41,4,20,1,0),(49,285,'feature',41,1,5,1,0),(50,286,'feature',41,2,10,1,0),(51,287,'feature',41,3,15,1,0),(52,288,'feature',41,4,20,1,0),(53,289,'feature',41,1,5,1,1),(54,290,'feature',41,2,10,1,0),(55,291,'feature',41,3,15,1,0),(56,292,'feature',41,4,20,1,0),(57,293,'feature',41,1,5,1,0),(58,294,'feature',41,2,10,1,0),(59,295,'feature',41,3,15,1,0),(60,296,'feature',41,4,20,1,0),(61,297,'feature',41,1,5,1,0),(62,298,'feature',41,2,10,1,0),(63,299,'feature',41,3,15,1,0),(64,300,'feature',41,4,20,1,0),(65,301,'feature',41,1,5,1,0),(66,302,'feature',41,2,10,1,0),(67,303,'feature',41,3,15,1,0),(68,304,'feature',41,4,20,1,0),(69,305,'feature',41,1,5,1,0),(70,306,'feature',41,2,10,1,0),(71,307,'feature',41,3,15,1,0),(72,308,'feature',41,4,20,1,0),(73,309,'feature',41,1,5,1,0),(74,310,'feature',41,2,10,1,0),(75,311,'feature',41,3,15,1,0),(76,312,'feature',41,4,20,1,0),(77,313,'feature',41,1,5,1,0),(78,314,'feature',41,2,10,1,0),(79,315,'feature',41,3,15,1,0),(80,316,'feature',41,4,20,1,0),(81,317,'feature',41,1,5,1,0),(82,318,'feature',41,2,10,1,0),(83,319,'feature',41,3,15,1,0),(84,320,'feature',41,4,20,1,0),(85,321,'feature',41,1,5,1,0),(86,322,'feature',41,2,10,1,0),(87,323,'feature',41,3,15,1,0),(88,324,'feature',41,4,20,1,0),(89,325,'feature',41,1,5,1,0),(90,326,'feature',41,2,10,1,0),(91,327,'feature',41,3,15,1,0),(92,328,'feature',41,4,20,1,0),(93,329,'feature',41,1,5,1,0),(94,330,'feature',41,2,10,1,0),(95,331,'feature',41,3,15,1,0),(96,332,'feature',41,4,20,1,0),(97,333,'feature',41,1,5,1,0),(98,334,'feature',41,2,10,1,0),(99,335,'feature',41,3,15,1,0),(100,336,'feature',41,4,20,1,0),(101,337,'feature',41,1,5,1,0),(102,338,'feature',41,2,10,1,0),(103,339,'feature',41,3,15,1,0),(104,340,'feature',41,4,20,1,0),(105,341,'feature',41,1,5,1,0),(106,342,'feature',41,2,10,1,0),(107,343,'feature',41,3,15,1,0),(108,344,'feature',41,4,20,1,0),(109,345,'feature',41,1,5,1,0),(110,346,'feature',41,2,10,1,0),(111,347,'feature',41,3,15,1,0),(112,348,'feature',41,4,20,1,0),(113,349,'feature',41,1,5,1,0),(114,350,'feature',41,2,10,1,0),(115,351,'feature',41,3,15,1,0),(116,352,'feature',41,4,20,1,0),(117,353,'feature',41,1,5,1,0),(118,354,'feature',41,2,10,1,0),(119,355,'feature',41,3,15,1,0),(120,356,'feature',41,4,20,1,0),(121,357,'feature',41,1,5,1,0),(122,358,'feature',41,2,10,1,0),(123,359,'feature',41,3,15,1,0),(124,360,'feature',41,4,20,1,0),(125,1,'feature',1,1,10,0,1),(126,2,'feature',2,1,10,0,0),(127,3,'feature',2,2,15,0,0),(128,4,'feature',3,1,15,0,0),(129,5,'feature',3,2,15,0,0),(130,6,'feature',4,1,15,0,0),(131,7,'feature',4,2,15,0,0),(132,8,'feature',5,1,5,0,1),(133,9,'feature',5,2,10,0,1),(134,10,'feature',6,1,15,0,1),(135,11,'feature',6,2,10,0,0),(136,12,'feature',6,3,10,0,0),(137,13,'feature',5,3,10,0,1),(138,14,'feature',5,4,15,0,0),(139,15,'feature',5,5,20,0,0),(140,16,'feature',5,6,20,0,0),(141,17,'achievement',7,1,5,0,1),(142,18,'achievement',7,2,10,0,1),(143,19,'feature',8,1,15,0,1),(144,20,'feature',8,2,15,0,0),(145,21,'feature',9,1,15,0,0),(146,22,'feature',10,1,10,0,0),(147,23,'feature',10,2,10,0,0),(148,24,'feature',10,3,10,0,0),(149,25,'feature',10,4,10,0,0),(150,26,'feature',10,5,10,0,0),(151,27,'feature',4,3,10,0,0),(152,28,'feature',3,3,10,0,0),(153,29,'achievement',11,1,5,0,1),(154,30,'achievement',11,2,10,0,1),(155,31,'achievement',11,3,15,0,0),(156,32,'achievement',11,4,20,0,0),(157,33,'achievement',11,5,25,0,0),(158,34,'achievement',11,6,30,0,0),(159,35,'achievement',7,3,15,0,1),(160,36,'achievement',7,4,20,0,0),(161,37,'achievement',7,5,25,0,0),(162,38,'achievement',7,6,30,0,0),(163,39,'achievement',12,1,5,0,1),(164,40,'achievement',12,2,10,0,1),(165,41,'achievement',12,3,15,0,1),(166,42,'achievement',12,4,20,0,0),(167,43,'achievement',12,5,25,0,0),(168,44,'achievement',12,6,30,0,0),(169,45,'achievement',13,1,5,0,1),(170,46,'achievement',13,2,10,0,1),(171,47,'achievement',13,3,15,0,0),(172,48,'achievement',13,4,20,0,0),(173,49,'achievement',13,5,25,0,0),(174,50,'achievement',13,6,30,0,0),(175,51,'achievement',14,1,5,0,1),(176,52,'achievement',14,2,10,0,1),(177,53,'achievement',14,3,15,0,0),(178,54,'achievement',14,4,20,0,0),(179,55,'achievement',14,5,25,0,0),(180,56,'achievement',14,6,30,0,0),(181,57,'achievement',15,1,5,0,1),(182,58,'achievement',15,2,10,0,0),(183,59,'achievement',15,3,15,0,0),(184,60,'achievement',15,4,20,0,0),(185,61,'achievement',15,5,25,0,0),(186,62,'achievement',15,6,30,0,0),(187,63,'achievement',16,1,5,0,1),(188,64,'achievement',16,2,10,0,1),(189,65,'achievement',16,3,15,0,0),(190,66,'achievement',16,4,20,0,0),(191,67,'achievement',16,5,25,0,0),(192,68,'achievement',16,6,30,0,0),(193,74,'international',22,1,10,0,0),(194,75,'international',23,1,10,0,0),(195,83,'international',31,1,10,0,0),(196,84,'international',25,1,10,0,0),(197,85,'international',32,1,10,0,0),(198,86,'international',33,1,10,0,0),(199,87,'international',34,1,10,0,0),(200,88,'feature',35,1,5,0,0),(201,89,'feature',35,2,10,0,0),(202,90,'feature',35,3,10,0,0),(203,91,'feature',35,4,10,0,0),(204,92,'feature',35,5,10,0,0),(205,93,'feature',35,6,10,0,0),(206,94,'feature',36,1,5,0,1),(207,95,'feature',36,2,5,0,1),(208,96,'feature',36,3,10,0,1),(209,97,'feature',36,4,10,0,0),(210,98,'feature',36,5,20,0,0),(211,99,'feature',36,6,20,0,0),(212,100,'feature',8,3,15,0,0),(213,101,'achievement',37,1,5,0,0),(214,102,'achievement',37,2,5,0,0),(215,103,'achievement',37,3,10,0,0),(216,104,'achievement',37,4,10,0,0),(217,105,'achievement',37,5,15,0,0),(218,106,'achievement',37,6,15,0,0),(219,107,'achievement',38,1,10,0,0),(220,108,'achievement',38,2,10,0,0),(221,109,'achievement',38,3,15,0,0),(222,110,'achievement',38,4,20,0,0),(223,111,'achievement',38,5,25,0,0),(224,112,'achievement',38,6,30,0,0),(225,113,'achievement',39,1,10,0,1),(226,114,'achievement',39,2,20,0,1),(227,115,'achievement',39,3,30,0,1),(228,116,'achievement',39,4,40,0,1),(229,117,'achievement',39,5,50,0,0),(230,118,'achievement',39,6,50,0,0),(231,119,'feature',40,1,10,0,0),(232,120,'feature',40,2,15,0,0),(233,121,'feature',40,3,20,0,0),(234,122,'feature',40,4,25,0,0);

--
-- Table structure for table `ps_badge_lang`
--

CREATE TABLE `ps_badge_lang` (
  `id_badge` int(11) NOT NULL,
  `id_lang` int(11) NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `group_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_badge`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_badge_lang`
--

INSERT INTO `ps_badge_lang` (`id_badge`, `id_lang`, `name`, `description`, `group_name`) VALUES (1,1,'Shopgate installed','You have installed the Shopgate module','Partners'),(1,2,'Shopgate installed','You have installed the Shopgate module','Partners'),(2,1,'Shopgate configured','You have configured the Shopgate module','Partners'),(2,2,'Shopgate configured','You have configured the Shopgate module','Partners'),(3,1,'Shopgate active','Your Shopgate module is active','Partners'),(3,2,'Shopgate active','Your Shopgate module is active','Partners'),(4,1,'Shopgate very active','Your Shopgate module is very active','Partners'),(4,2,'Shopgate very active','Your Shopgate module is very active','Partners'),(5,1,'Skrill installed','You have installed the Skrill module','Partners'),(5,2,'Skrill installed','You have installed the Skrill module','Partners'),(6,1,'Skrill configured','You have configured the Skrill module','Partners'),(6,2,'Skrill configured','You have configured the Skrill module','Partners'),(7,1,'Skrill active','Your Skrill module is active','Partners'),(7,2,'Skrill active','Your Skrill module is active','Partners'),(8,1,'Skrill very active','Your Skrill module is very active','Partners'),(8,2,'Skrill very active','Your Skrill module is very active','Partners'),(9,1,'Shopping Feed installed','You have installed the Shopping Feed module','Partners'),(9,2,'Shopping Feed installed','You have installed the Shopping Feed module','Partners'),(10,1,'Shopping Feed configured','You have configured the Shopping Feed module','Partners'),(10,2,'Shopping Feed configured','You have configured the Shopping Feed module','Partners'),(11,1,'Alliance Payment installed','You have installed the Alliance Payment module','Partners'),(11,2,'Alliance Payment installed','You have installed the Alliance Payment module','Partners'),(12,1,'Alliance Payment configured','You have configured the Alliance Payment module','Partners'),(12,2,'Alliance Payment configured','You have configured the Alliance Payment module','Partners'),(13,1,'Alliance Payment active','Your Alliance Payment module is active','Partners'),(13,2,'Alliance Payment active','Your Alliance Payment module is active','Partners'),(14,1,'Alliance Payment very active','Your Alliance Payment module is very active','Partners'),(14,2,'Alliance Payment very active','Your Alliance Payment module is very active','Partners'),(15,1,'Authorize Aim installed','You have installed the Authorize Aim module','Partners'),(15,2,'Authorize Aim installed','You have installed the Authorize Aim module','Partners'),(16,1,'Authorize Aim configured','You have configured the Authorize Aim module','Partners'),(16,2,'Authorize Aim configured','You have configured the Authorize Aim module','Partners'),(17,1,'Authorize Aim active','Your Authorize Aim module is active','Partners'),(17,2,'Authorize Aim active','Your Authorize Aim module is active','Partners'),(18,1,'Authorize Aim very active','Your Authorize Aim module is very active','Partners'),(18,2,'Authorize Aim very active','Your Authorize Aim module is very active','Partners'),(19,1,'Blue Pay installed','You have installed the Blue Pay module','Partners'),(19,2,'Blue Pay installed','You have installed the Blue Pay module','Partners'),(20,1,'Blue Pay configured','You have configured the Blue Pay module','Partners'),(20,2,'Blue Pay configured','You have configured the Blue Pay module','Partners'),(21,1,'Blue Pay active','Your Blue Pay module is active','Partners'),(21,2,'Blue Pay active','Your Blue Pay module is active','Partners'),(22,1,'Blue Pay very active','Your Blue Pay module is very active','Partners'),(22,2,'Blue Pay very active','Your Blue Pay module is very active','Partners'),(23,1,'Ebay installed','You have installed the Ebay module','Partners'),(23,2,'Ebay installed','You have installed the Ebay module','Partners'),(24,1,'Ebay configured','You have configured the Ebay module','Partners'),(24,2,'Ebay configured','You have configured the Ebay module','Partners'),(25,1,'Ebay active','Your Ebay module is active','Partners'),(25,2,'Ebay active','Your Ebay module is active','Partners'),(26,1,'Ebay very active','Your Ebay module is very active','Partners'),(26,2,'Ebay very active','Your Ebay module is very active','Partners'),(27,1,'PayPlug installed','You have installed the PayPlug module','Partners'),(27,2,'PayPlug installed','You have installed the PayPlug module','Partners'),(28,1,'PayPlug configured','You have configured the PayPlug module','Partners'),(28,2,'PayPlug configured','You have configured the PayPlug module','Partners'),(29,1,'PayPlug active','Your PayPlug module is active','Partners'),(29,2,'PayPlug active','Your PayPlug module is active','Partners'),(30,1,'PayPlug very active','Your PayPlug module is very active','Partners'),(30,2,'PayPlug very active','Your PayPlug module is very active','Partners'),(31,1,'Affinity Items installed','You have installed the Affinity Items module','Partners'),(31,2,'Affinity Items installed','You have installed the Affinity Items module','Partners'),(32,1,'Affinity Items configured','You have configured the Affinity Items module','Partners'),(32,2,'Affinity Items configured','You have configured the Affinity Items module','Partners'),(33,1,'DPD Poland installed','You have installed the DPD Poland module','Partners'),(33,2,'DPD Poland installed','You have installed the DPD Poland module','Partners'),(34,1,'DPD Poland configured','You have configured the DPD Poland module','Partners'),(34,2,'DPD Poland configured','You have configured the DPD Poland module','Partners'),(35,1,'DPD Poland active','Your DPD Poland module is active','Partners'),(35,2,'DPD Poland active','Your DPD Poland module is active','Partners'),(36,1,'DPD Poland very active','Your DPD Poland module is very active','Partners'),(36,2,'DPD Poland very active','Your DPD Poland module is very active','Partners'),(37,1,'Envoimoinscher installed','You have installed the Envoimoinscher module','Partners'),(37,2,'Envoimoinscher installed','You have installed the Envoimoinscher module','Partners'),(38,1,'Envoimoinscher configured','You have configured the Envoimoinscher module','Partners'),(38,2,'Envoimoinscher configured','You have configured the Envoimoinscher module','Partners'),(39,1,'Envoimoinscher active','Your Envoimoinscher module is active','Partners'),(39,2,'Envoimoinscher active','Your Envoimoinscher module is active','Partners'),(40,1,'Envoimoinscher very active','Your Envoimoinscher module is very active','Partners'),(40,2,'Envoimoinscher very active','Your Envoimoinscher module is very active','Partners'),(41,1,'Klik&Pay installed','You have installed the Klik&Pay module','Partners'),(41,2,'Klik&Pay installed','You have installed the Klik&Pay module','Partners'),(42,1,'Klik&Pay configured','You have configured the Klik&Pay module','Partners'),(42,2,'Klik&Pay configured','You have configured the Klik&Pay module','Partners'),(43,1,'Klik&Pay active','Your Klik&Pay module is active','Partners'),(43,2,'Klik&Pay active','Your Klik&Pay module is active','Partners'),(44,1,'Klik&Pay very active','Your Klik&Pay module is very active','Partners'),(44,2,'Klik&Pay very active','Your Klik&Pay module is very active','Partners'),(45,1,'Clickline installed','You have installed the Clickline module','Partners'),(45,2,'Clickline installed','You have installed the Clickline module','Partners'),(46,1,'Clickline configured','You have configured the Clickline module','Partners'),(46,2,'Clickline configured','You have configured the Clickline module','Partners'),(47,1,'Clickline active','Your Clickline module is active','Partners'),(47,2,'Clickline active','Your Clickline module is active','Partners'),(48,1,'Clickline very active','Your Clickline module is very active','Partners'),(48,2,'Clickline very active','Your Clickline module is very active','Partners'),(49,1,'CDiscount installed','You have installed the CDiscount module','Partners'),(49,2,'CDiscount installed','You have installed the CDiscount module','Partners'),(50,1,'CDiscount configured','You have configured the CDiscount module','Partners'),(50,2,'CDiscount configured','You have configured the CDiscount module','Partners'),(51,1,'CDiscount active','Your CDiscount module is active','Partners'),(51,2,'CDiscount active','Your CDiscount module is active','Partners'),(52,1,'CDiscount very active','Your CDiscount module is very active','Partners'),(52,2,'CDiscount very active','Your CDiscount module is very active','Partners'),(53,1,'illicoPresta installed','You have installed the illicoPresta module','Partners'),(53,2,'illicoPresta installed','You have installed the illicoPresta module','Partners'),(54,1,'illicoPresta configured','You have configured the illicoPresta module','Partners'),(54,2,'illicoPresta configured','You have configured the illicoPresta module','Partners'),(55,1,'illicoPresta active','Your illicoPresta module is active','Partners'),(55,2,'illicoPresta active','Your illicoPresta module is active','Partners'),(56,1,'illicoPresta very active','Your illicoPresta module is very active','Partners'),(56,2,'illicoPresta very active','Your illicoPresta module is very active','Partners'),(57,1,'NetReviews installed','You have installed the NetReviews module','Partners'),(57,2,'NetReviews installed','You have installed the NetReviews module','Partners'),(58,1,'NetReviews configured','You have configured the NetReviews module','Partners'),(58,2,'NetReviews configured','You have configured the NetReviews module','Partners'),(59,1,'NetReviews active','Your NetReviews module is active','Partners'),(59,2,'NetReviews active','Your NetReviews module is active','Partners'),(60,1,'NetReviews very active','Your NetReviews module is very active','Partners'),(60,2,'NetReviews very active','Your NetReviews module is very active','Partners'),(61,1,'Bluesnap installed','You have installed the Bluesnap module','Partners'),(61,2,'Bluesnap installed','You have installed the Bluesnap module','Partners'),(62,1,'Bluesnap configured','You have configured the Bluesnap module','Partners'),(62,2,'Bluesnap configured','You have configured the Bluesnap module','Partners'),(63,1,'Bluesnap active','Your Bluesnap module is active','Partners'),(63,2,'Bluesnap active','Your Bluesnap module is active','Partners'),(64,1,'Bluesnap very active','Your Bluesnap module is very active','Partners'),(64,2,'Bluesnap very active','Your Bluesnap module is very active','Partners'),(65,1,'Desjardins installed','You have installed the Desjardins module','Partners'),(65,2,'Desjardins installed','You have installed the Desjardins module','Partners'),(66,1,'Desjardins configured','You have configured the Desjardins module','Partners'),(66,2,'Desjardins configured','You have configured the Desjardins module','Partners'),(67,1,'Desjardins active','Your Desjardins module is active','Partners'),(67,2,'Desjardins active','Your Desjardins module is active','Partners'),(68,1,'Desjardins very active','Your Desjardins module is very active','Partners'),(68,2,'Desjardins very active','Your Desjardins module is very active','Partners'),(69,1,'First Data installed','You have installed the First Data module','Partners'),(69,2,'First Data installed','You have installed the First Data module','Partners'),(70,1,'First Data configured','You have configured the First Data module','Partners'),(70,2,'First Data configured','You have configured the First Data module','Partners'),(71,1,'First Data active','Your First Data module is active','Partners'),(71,2,'First Data active','Your First Data module is active','Partners'),(72,1,'First Data very active','Your First Data module is very active','Partners'),(72,2,'First Data very active','Your First Data module is very active','Partners'),(73,1,'Give.it installed','You have installed the Give.it module','Partners'),(73,2,'Give.it installed','You have installed the Give.it module','Partners'),(74,1,'Give.it configured','You have configured the Give.it module','Partners'),(74,2,'Give.it configured','You have configured the Give.it module','Partners'),(75,1,'Give.it active','Your Give.it module is active','Partners'),(75,2,'Give.it active','Your Give.it module is active','Partners'),(76,1,'Give.it very active','Your Give.it module is very active','Partners'),(76,2,'Give.it very active','Your Give.it module is very active','Partners'),(77,1,'Google Analytics installed','You have installed the Google Analytics module','Partners'),(77,2,'Google Analytics installed','You have installed the Google Analytics module','Partners'),(78,1,'Google Analytics configured','You have configured the Google Analytics module','Partners'),(78,2,'Google Analytics configured','You have configured the Google Analytics module','Partners'),(79,1,'Google Analytics active','Your Google Analytics module is active','Partners'),(79,2,'Google Analytics active','Your Google Analytics module is active','Partners'),(80,1,'Google Analytics very active','Your Google Analytics module is very active','Partners'),(80,2,'Google Analytics very active','Your Google Analytics module is very active','Partners'),(81,1,'PagSeguro installed','You have installed the PagSeguro module','Partners'),(81,2,'PagSeguro installed','You have installed the PagSeguro module','Partners'),(82,1,'PagSeguro configured','You have configured the PagSeguro module','Partners'),(82,2,'PagSeguro configured','You have configured the PagSeguro module','Partners'),(83,1,'PagSeguro active','Your PagSeguro module is active','Partners'),(83,2,'PagSeguro active','Your PagSeguro module is active','Partners'),(84,1,'PagSeguro very active','Your PagSeguro module is very active','Partners'),(84,2,'PagSeguro very active','Your PagSeguro module is very active','Partners'),(85,1,'Paypal MX installed','You have installed the Paypal MX module','Partners'),(85,2,'Paypal MX installed','You have installed the Paypal MX module','Partners'),(86,1,'Paypal MX configured','You have configured the Paypal MX module','Partners'),(86,2,'Paypal MX configured','You have configured the Paypal MX module','Partners'),(87,1,'Paypal MX active','Your Paypal MX module is active','Partners'),(87,2,'Paypal MX active','Your Paypal MX module is active','Partners'),(88,1,'Paypal MX very active','Your Paypal MX module is very active','Partners'),(88,2,'Paypal MX very active','Your Paypal MX module is very active','Partners'),(89,1,'Paypal USA installed','You have installed the Paypal USA module','Partners'),(89,2,'Paypal USA installed','You have installed the Paypal USA module','Partners'),(90,1,'Paypal USA configured','You have configured the Paypal USA module','Partners'),(90,2,'Paypal USA configured','You have configured the Paypal USA module','Partners'),(91,1,'Paypal USA active','Your Paypal USA module is active','Partners'),(91,2,'Paypal USA active','Your Paypal USA module is active','Partners'),(92,1,'Paypal USA very active','Your Paypal USA module is very active','Partners'),(92,2,'Paypal USA very active','Your Paypal USA module is very active','Partners'),(93,1,'PayULatam installed','You have installed the PayULatam module','Partners'),(93,2,'PayULatam installed','You have installed the PayULatam module','Partners'),(94,1,'PayULatam configured','You have configured the PayULatam module','Partners'),(94,2,'PayULatam configured','You have configured the PayULatam module','Partners'),(95,1,'PayULatam active','Your PayULatam module is active','Partners'),(95,2,'PayULatam active','Your PayULatam module is active','Partners'),(96,1,'PayULatam very active','Your PayULatam module is very active','Partners'),(96,2,'PayULatam very active','Your PayULatam module is very active','Partners'),(97,1,'PrestaStats installed','You have installed the PrestaStats module','Partners'),(97,2,'PrestaStats installed','You have installed the PrestaStats module','Partners'),(98,1,'PrestaStats configured','You have configured the PrestaStats module','Partners'),(98,2,'PrestaStats configured','You have configured the PrestaStats module','Partners'),(99,1,'PrestaStats active','Your PrestaStats module is active','Partners'),(99,2,'PrestaStats active','Your PrestaStats module is active','Partners'),(100,1,'PrestaStats very active','Your PrestaStats module is very active','Partners'),(100,2,'PrestaStats very active','Your PrestaStats module is very active','Partners'),(101,1,'Riskified installed','You have installed the Riskified module','Partners'),(101,2,'Riskified installed','You have installed the Riskified module','Partners'),(102,1,'Riskified configured','You have configured the Riskified module','Partners'),(102,2,'Riskified configured','You have configured the Riskified module','Partners'),(103,1,'Riskified active','Your Riskified module is active','Partners'),(103,2,'Riskified active','Your Riskified module is active','Partners'),(104,1,'Riskified very active','Your Riskified module is very active','Partners'),(104,2,'Riskified very active','Your Riskified module is very active','Partners'),(105,1,'Simplify installed','You have installed the Simplify module','Partners'),(105,2,'Simplify installed','You have installed the Simplify module','Partners'),(106,1,'Simplify configured','You have configured the Simplify module','Partners'),(106,2,'Simplify configured','You have configured the Simplify module','Partners'),(107,1,'Simplify active','Your Simplify module is active','Partners'),(107,2,'Simplify active','Your Simplify module is active','Partners'),(108,1,'Simplify very active','Your Simplify module is very active','Partners'),(108,2,'Simplify very active','Your Simplify module is very active','Partners'),(109,1,'VTPayment installed','You have installed the VTPayment module','Partners'),(109,2,'VTPayment installed','You have installed the VTPayment module','Partners'),(110,1,'VTPayment configured','You have configured the VTPayment module','Partners'),(110,2,'VTPayment configured','You have configured the VTPayment module','Partners'),(111,1,'VTPayment active','Your VTPayment module is active','Partners'),(111,2,'VTPayment active','Your VTPayment module is active','Partners'),(112,1,'VTPayment very active','Your VTPayment module is very active','Partners'),(112,2,'VTPayment very active','Your VTPayment module is very active','Partners'),(113,1,'Yotpo installed','You have installed the Yotpo module','Partners'),(113,2,'Yotpo installed','You have installed the Yotpo module','Partners'),(114,1,'Yotpo configured','You have configured the Yotpo module','Partners'),(114,2,'Yotpo configured','You have configured the Yotpo module','Partners'),(115,1,'Yotpo active','Your Yotpo module is active','Partners'),(115,2,'Yotpo active','Your Yotpo module is active','Partners'),(116,1,'Yotpo very active','Your Yotpo module is very active','Partners'),(116,2,'Yotpo very active','Your Yotpo module is very active','Partners'),(117,1,'Youstice installed','You have installed the Youstice module','Partners'),(117,2,'Youstice installed','You have installed the Youstice module','Partners'),(118,1,'Youstice configured','You have configured the Youstice module','Partners'),(118,2,'Youstice configured','You have configured the Youstice module','Partners'),(119,1,'Youstice active','Your Youstice module is active','Partners'),(119,2,'Youstice active','Your Youstice module is active','Partners'),(120,1,'Youstice very active','Your Youstice module is very active','Partners'),(120,2,'Youstice very active','Your Youstice module is very active','Partners'),(121,1,'Loyalty Lion installed','You have installed the Loyalty Lion module','Partners'),(121,2,'Loyalty Lion installed','You have installed the Loyalty Lion module','Partners'),(122,1,'Loyalty Lion configured','You have configured the Loyalty Lion module','Partners'),(122,2,'Loyalty Lion configured','You have configured the Loyalty Lion module','Partners'),(123,1,'Loyalty Lion active','Your Loyalty Lion module is active','Partners'),(123,2,'Loyalty Lion active','Your Loyalty Lion module is active','Partners'),(124,1,'Loyalty Lion very active','Your Loyalty Lion module is very active','Partners'),(124,2,'Loyalty Lion very active','Your Loyalty Lion module is very active','Partners'),(125,1,'SEO','You enabled the URL rewriting through the tab \"Preferences > SEO and URLs\".','SEO'),(125,2,'SEO','You enabled the URL rewriting through the tab \"Preferences > SEO and URLs\".','SEO'),(126,1,'Site Performance','You enabled CCC (Combine, Compress and Cache), Rijndael and Smarty through the tab \r\nAdvanced Parameters > Performance.','Site Performance'),(126,2,'Site Performance','You enabled CCC (Combine, Compress and Cache), Rijndael and Smarty through the tab \r\nAdvanced Parameters > Performance.','Site Performance'),(127,1,'Site Performance','You enabled media servers through the tab \"Advanced parameters > Performance\".','Site Performance'),(127,2,'Site Performance','You enabled media servers through the tab \"Advanced parameters > Performance\".','Site Performance'),(128,1,'Payment','You configured a payment solution on your shop.','Payment'),(128,2,'Payment','You configured a payment solution on your shop.','Payment'),(129,1,'Payment','You offer two different payment methods to your customers.','Payment'),(129,2,'Payment','You offer two different payment methods to your customers.','Payment'),(130,1,'Shipping','You configured a carrier on your shop.','Shipping'),(130,2,'Shipping','You configured a carrier on your shop.','Shipping'),(131,1,'Shipping','You offer two shipping solutions (carriers) to your customers.','Shipping'),(131,2,'Shipping','You offer two shipping solutions (carriers) to your customers.','Shipping'),(132,1,'Catalog Size','You added your first product to your catalog!','Catalog Size'),(132,2,'Catalog Size','You added your first product to your catalog!','Catalog Size'),(133,1,'Catalog Size','You have 10 products within your catalog.','Catalog Size'),(133,2,'Catalog Size','You have 10 products within your catalog.','Catalog Size'),(134,1,'Contact information','You configured your phone number so your customers can reach you!','Contact information'),(134,2,'Contact information','You configured your phone number so your customers can reach you!','Contact information'),(135,1,'Contact information','You added a third email address to your contact form.','Contact information'),(135,2,'Contact information','You added a third email address to your contact form.','Contact information'),(136,1,'Contact information','You suggest a total of 5 departments to be reached by your customers via your contact form.','Contact information'),(136,2,'Contact information','You suggest a total of 5 departments to be reached by your customers via your contact form.','Contact information'),(137,1,'Catalog Size','You have 100 products within your catalog.','Catalog Size'),(137,2,'Catalog Size','You have 100 products within your catalog.','Catalog Size'),(138,1,'Catalog Size','You have 1,000 products within your catalog.','Catalog Size'),(138,2,'Catalog Size','You have 1,000 products within your catalog.','Catalog Size'),(139,1,'Catalog Size','You have 10,000 products within your catalog.','Catalog Size'),(139,2,'Catalog Size','You have 10,000 products within your catalog.','Catalog Size'),(140,1,'Catalog Size','You have 100,000 products within your catalog.','Catalog Size'),(140,2,'Catalog Size','You have 100,000 products within your catalog.','Catalog Size'),(141,1,'Days of Experience','You just installed PrestaShop!','Days of Experience'),(141,2,'Days of Experience','You just installed PrestaShop!','Days of Experience'),(142,1,'Days of Experience','You installed PrestaShop a week ago!','Days of Experience'),(142,2,'Days of Experience','You installed PrestaShop a week ago!','Days of Experience'),(143,1,'Customization','You uploaded your own logo.','Customization'),(143,2,'Customization','You uploaded your own logo.','Customization'),(144,1,'Customization','You installed a new template.','Customization'),(144,2,'Customization','You installed a new template.','Customization'),(145,1,'Addons','You connected your back-office to the Addons platform using your PrestaShop Addons account.','Addons'),(145,2,'Addons','You connected your back-office to the Addons platform using your PrestaShop Addons account.','Addons'),(146,1,'Multistores','You enabled the Multistores feature.','Multistores'),(146,2,'Multistores','You enabled the Multistores feature.','Multistores'),(147,1,'Multistores','You manage two shops with the Multistores feature.','Multistores'),(147,2,'Multistores','You manage two shops with the Multistores feature.','Multistores'),(148,1,'Multistores','You manage two different groups of shops using the Multistores feature.','Multistores'),(148,2,'Multistores','You manage two different groups of shops using the Multistores feature.','Multistores'),(149,1,'Multistores','You manage five shops with the Multistores feature.','Multistores'),(149,2,'Multistores','You manage five shops with the Multistores feature.','Multistores'),(150,1,'Multistores','You manage five different groups of shops using the Multistores feature.','Multistores'),(150,2,'Multistores','You manage five different groups of shops using the Multistores feature.','Multistores'),(151,1,'Shipping','You offer three different shipping solutions (carriers) to your customers.','Shipping'),(151,2,'Shipping','You offer three different shipping solutions (carriers) to your customers.','Shipping'),(152,1,'Payment','You offer three different payment methods to your customers.','Payment'),(152,2,'Payment','You offer three different payment methods to your customers.','Payment'),(153,1,'Revenue','You get this badge when you reach 200 USD in sales.','Revenue'),(153,2,'Revenue','You get this badge when you reach 200 USD in sales.','Revenue'),(154,1,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(154,2,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(155,1,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(155,2,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(156,1,'Revenue','You get this badge when you reach 200 USD in sales.','Revenue'),(156,2,'Revenue','You get this badge when you reach 200 USD in sales.','Revenue'),(157,1,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(157,2,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(158,1,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(158,2,'Revenue','You get this badge when you reach 1000 USD in sales.','Revenue'),(159,1,'Days of Experience','You installed PrestaShop a month ago!','Days of Experience'),(159,2,'Days of Experience','You installed PrestaShop a month ago!','Days of Experience'),(160,1,'Days of Experience','You installed PrestaShop six months ago!','Days of Experience'),(160,2,'Days of Experience','You installed PrestaShop six months ago!','Days of Experience'),(161,1,'Days of Experience','You installed PrestaShop a year ago!','Days of Experience'),(161,2,'Days of Experience','You installed PrestaShop a year ago!','Days of Experience'),(162,1,'Days of Experience','You installed PrestaShop two years ago!','Days of Experience'),(162,2,'Days of Experience','You installed PrestaShop two years ago!','Days of Experience'),(163,1,'Visitors','You reached 10 visitors!','Visitors'),(163,2,'Visitors','You reached 10 visitors!','Visitors'),(164,1,'Visitors','You reached 100 visitors!','Visitors'),(164,2,'Visitors','You reached 100 visitors!','Visitors'),(165,1,'Visitors','You reached 1,000 visitors!','Visitors'),(165,2,'Visitors','You reached 1,000 visitors!','Visitors'),(166,1,'Visitors','You reached 10,000 visitors!','Visitors'),(166,2,'Visitors','You reached 10,000 visitors!','Visitors'),(167,1,'Visitors','You reached 100,000 visitors!','Visitors'),(167,2,'Visitors','You reached 100,000 visitors!','Visitors'),(168,1,'Visitors','You reached 1,000,000 visitors!','Visitors'),(168,2,'Visitors','You reached 1,000,000 visitors!','Visitors'),(169,1,'Customer Carts','Two carts have been created by visitors','Customer Carts'),(169,2,'Customer Carts','Two carts have been created by visitors','Customer Carts'),(170,1,'Customer Carts','Ten carts have been created by visitors.','Customer Carts'),(170,2,'Customer Carts','Ten carts have been created by visitors.','Customer Carts'),(171,1,'Customer Carts','A hundred carts have been created by visitors on your shop.','Customer Carts'),(171,2,'Customer Carts','A hundred carts have been created by visitors on your shop.','Customer Carts'),(172,1,'Customer Carts','A thousand carts have been created by visitors on your shop.','Customer Carts'),(172,2,'Customer Carts','A thousand carts have been created by visitors on your shop.','Customer Carts'),(173,1,'Customer Carts','10,000 carts have been created by visitors.','Customer Carts'),(173,2,'Customer Carts','10,000 carts have been created by visitors.','Customer Carts'),(174,1,'Customer Carts','100,000 carts have been created by visitors.','Customer Carts'),(174,2,'Customer Carts','100,000 carts have been created by visitors.','Customer Carts'),(175,1,'Orders','You received your first order.','Orders'),(175,2,'Orders','You received your first order.','Orders'),(176,1,'Orders','10 orders have been placed through your online shop.','Orders'),(176,2,'Orders','10 orders have been placed through your online shop.','Orders'),(177,1,'Orders','You received 100 orders through your online shop!','Orders'),(177,2,'Orders','You received 100 orders through your online shop!','Orders'),(178,1,'Orders','You received 1,000 orders through your online shop, congrats!','Orders'),(178,2,'Orders','You received 1,000 orders through your online shop, congrats!','Orders'),(179,1,'Orders','You received 10,000 orders through your online shop, cheers!','Orders'),(179,2,'Orders','You received 10,000 orders through your online shop, cheers!','Orders'),(180,1,'Orders','You received 100,000 orders through your online shop!','Orders'),(180,2,'Orders','You received 100,000 orders through your online shop!','Orders'),(181,1,'Customer Service Threads','You received  your first customer\'s message.','Customer Service Threads'),(181,2,'Customer Service Threads','You received  your first customer\'s message.','Customer Service Threads'),(182,1,'Customer Service Threads','You received 10 messages from your customers.','Customer Service Threads'),(182,2,'Customer Service Threads','You received 10 messages from your customers.','Customer Service Threads'),(183,1,'Customer Service Threads','You received 100 messages from your customers.','Customer Service Threads'),(183,2,'Customer Service Threads','You received 100 messages from your customers.','Customer Service Threads'),(184,1,'Customer Service Threads','You received 1,000 messages from your customers.','Customer Service Threads'),(184,2,'Customer Service Threads','You received 1,000 messages from your customers.','Customer Service Threads'),(185,1,'Customer Service Threads','You received 10,000 messages from your customers.','Customer Service Threads'),(185,2,'Customer Service Threads','You received 10,000 messages from your customers.','Customer Service Threads'),(186,1,'Customer Service Threads','You received 100,000 messages from your customers.','Customer Service Threads'),(186,2,'Customer Service Threads','You received 100,000 messages from your customers.','Customer Service Threads'),(187,1,'Customers','You got the first customer registered on your shop!','Customers'),(187,2,'Customers','You got the first customer registered on your shop!','Customers'),(188,1,'Customers','You have over 10 customers registered on your shop.','Customers'),(188,2,'Customers','You have over 10 customers registered on your shop.','Customers'),(189,1,'Customers','You have over 100 customers registered on your shop.','Customers'),(189,2,'Customers','You have over 100 customers registered on your shop.','Customers'),(190,1,'Customers','You have over 1,000 customers registered on your shop.','Customers'),(190,2,'Customers','You have over 1,000 customers registered on your shop.','Customers'),(191,1,'Customers','You have over 10,000 customers registered on your shop.','Customers'),(191,2,'Customers','You have over 10,000 customers registered on your shop.','Customers'),(192,1,'Customers','You have over 100,000 customers registered on your shop.','Customers'),(192,2,'Customers','You have over 100,000 customers registered on your shop.','Customers'),(193,1,'North America','You got your first sale in North America','North America'),(193,2,'North America','You got your first sale in North America','North America'),(194,1,'Oceania','You got your first sale in Oceania','Oceania'),(194,2,'Oceania','You got your first sale in Oceania','Oceania'),(195,1,'Asia','You got your first sale in Asia','Asia'),(195,2,'Asia','You got your first sale in Asia','Asia'),(196,1,'South America','You got your first sale in South America','South America'),(196,2,'South America','You got your first sale in South America','South America'),(197,1,'Europe','You got your first sale in  Europe!','Europe'),(197,2,'Europe','You got your first sale in  Europe!','Europe'),(198,1,'Africa','You got your first sale in Africa','Africa'),(198,2,'Africa','You got your first sale in Africa','Africa'),(199,1,'Maghreb','You got your first sale in Maghreb','Maghreb'),(199,2,'Maghreb','You got your first sale in Maghreb','Maghreb'),(200,1,'Your Team\'s Employees','First employee account added to your shop','Your Team\'s Employees'),(200,2,'Your Team\'s Employees','First employee account added to your shop','Your Team\'s Employees'),(201,1,'Your Team\'s Employees','3 employee accounts added to your shop','Your Team\'s Employees'),(201,2,'Your Team\'s Employees','3 employee accounts added to your shop','Your Team\'s Employees'),(202,1,'Your Team\'s Employees','5 employee accounts added to your shop','Your Team\'s Employees'),(202,2,'Your Team\'s Employees','5 employee accounts added to your shop','Your Team\'s Employees'),(203,1,'Your Team\'s Employees','10 employee accounts added to your shop','Your Team\'s Employees'),(203,2,'Your Team\'s Employees','10 employee accounts added to your shop','Your Team\'s Employees'),(204,1,'Your Team\'s Employees','20 employee accounts added to your shop','Your Team\'s Employees'),(204,2,'Your Team\'s Employees','20 employee accounts added to your shop','Your Team\'s Employees'),(205,1,'Your Team\'s Employees','40 employee accounts added to your shop','Your Team\'s Employees'),(205,2,'Your Team\'s Employees','40 employee accounts added to your shop','Your Team\'s Employees'),(206,1,'Product Pictures','First photo added to your catalog','Product Pictures'),(206,2,'Product Pictures','First photo added to your catalog','Product Pictures'),(207,1,'Product Pictures','50 photos added to your catalog','Product Pictures'),(207,2,'Product Pictures','50 photos added to your catalog','Product Pictures'),(208,1,'Product Pictures','100 photos added to your catalog','Product Pictures'),(208,2,'Product Pictures','100 photos added to your catalog','Product Pictures'),(209,1,'Product Pictures','1,000 photos added to your catalog','Product Pictures'),(209,2,'Product Pictures','1,000 photos added to your catalog','Product Pictures'),(210,1,'Product Pictures','10,000 photos added to your catalog','Product Pictures'),(210,2,'Product Pictures','10,000 photos added to your catalog','Product Pictures'),(211,1,'Product Pictures','50,000 photos added to your catalog','Product Pictures'),(211,2,'Product Pictures','50,000 photos added to your catalog','Product Pictures'),(212,1,'Customization','First CMS page added to your catalog','Customization'),(212,2,'Customization','First CMS page added to your catalog','Customization'),(213,1,'Cart Rules','First cart rules configured on your shop','Cart Rules'),(213,2,'Cart Rules','First cart rules configured on your shop','Cart Rules'),(214,1,'Cart Rules','You have 10 cart rules configured on your shop','Cart Rules'),(214,2,'Cart Rules','You have 10 cart rules configured on your shop','Cart Rules'),(215,1,'Cart Rules','You have 100 cart rules configured on your shop','Cart Rules'),(215,2,'Cart Rules','You have 100 cart rules configured on your shop','Cart Rules'),(216,1,'Cart Rules','You have 500 cart rules configured on your shop','Cart Rules'),(216,2,'Cart Rules','You have 500 cart rules configured on your shop','Cart Rules'),(217,1,'Cart Rules','You have 1,000 cart rules configured on your shop','Cart Rules'),(217,2,'Cart Rules','You have 1,000 cart rules configured on your shop','Cart Rules'),(218,1,'Cart Rules','You have 5,000 cart rules configured on your shop','Cart Rules'),(218,2,'Cart Rules','You have 5,000 cart rules configured on your shop','Cart Rules'),(219,1,'International Orders','First international order placed on your shop.','International Orders'),(219,2,'International Orders','First international order placed on your shop.','International Orders'),(220,1,'International Orders','10 international orders placed on your shop.','International Orders'),(220,2,'International Orders','10 international orders placed on your shop.','International Orders'),(221,1,'International Orders','100 international orders placed on your shop!','International Orders'),(221,2,'International Orders','100 international orders placed on your shop!','International Orders'),(222,1,'International Orders','1,000 international orders placed on your shop!','International Orders'),(222,2,'International Orders','1,000 international orders placed on your shop!','International Orders'),(223,1,'International Orders','5,000 international orders placed on your shop!','International Orders'),(223,2,'International Orders','5,000 international orders placed on your shop!','International Orders'),(224,1,'International Orders','10,000 international orders placed on your shop!','International Orders'),(224,2,'International Orders','10,000 international orders placed on your shop!','International Orders'),(225,1,'Store','First store configured on your shop!','Store'),(225,2,'Store','First store configured on your shop!','Store'),(226,1,'Store','You have 2 stores configured on your shop','Store'),(226,2,'Store','You have 2 stores configured on your shop','Store'),(227,1,'Store','You have 5 stores configured on your shop','Store'),(227,2,'Store','You have 5 stores configured on your shop','Store'),(228,1,'Store','You have 10 stores configured on your shop','Store'),(228,2,'Store','You have 10 stores configured on your shop','Store'),(229,1,'Store','You have 20 stores configured on your shop','Store'),(229,2,'Store','You have 20 stores configured on your shop','Store'),(230,1,'Store','You have 50 stores configured on your shop','Store'),(230,2,'Store','You have 50 stores configured on your shop','Store'),(231,1,'Webservice x1','First webservice account added to your shop','WebService'),(231,2,'Webservice x1','First webservice account added to your shop','WebService'),(232,1,'Webservice x2','2 webservice accounts added to your shop','WebService'),(232,2,'Webservice x2','2 webservice accounts added to your shop','WebService'),(233,1,'Webservice x3','3 webservice accounts added to your shop','WebService'),(233,2,'Webservice x3','3 webservice accounts added to your shop','WebService'),(234,1,'Webservice x4','4 webservice accounts added to your shop','WebService'),(234,2,'Webservice x4','4 webservice accounts added to your shop','WebService');

--
-- Table structure for table `ps_blocklink`
--

CREATE TABLE `ps_blocklink` (
  `id_blocklink` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(254) NOT NULL,
  `new_window` tinyint(1) NOT NULL,
  PRIMARY KEY (`id_blocklink`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_blocklink`
--


--
-- Table structure for table `ps_blocklink_lang`
--

CREATE TABLE `ps_blocklink_lang` (
  `id_blocklink` int(10) NOT NULL,
  `id_lang` int(10) NOT NULL,
  `text` varchar(62) NOT NULL,
  PRIMARY KEY (`id_blocklink`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_blocklink_lang`
--


--
-- Table structure for table `ps_blocklink_shop`
--

CREATE TABLE `ps_blocklink_shop` (
  `id_blocklink` int(10) NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) NOT NULL,
  PRIMARY KEY (`id_blocklink`,`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_blocklink_shop`
--


--
-- Table structure for table `ps_carrier`
--

CREATE TABLE `ps_carrier` (
  `id_carrier` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_reference` int(10) unsigned NOT NULL,
  `id_tax_rules_group` int(10) unsigned DEFAULT '0',
  `name` varchar(64) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `shipping_handling` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `range_behavior` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_module` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `shipping_external` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `need_range` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `external_module_name` varchar(64) DEFAULT NULL,
  `shipping_method` int(2) NOT NULL DEFAULT '0',
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `max_width` int(10) DEFAULT '0',
  `max_height` int(10) DEFAULT '0',
  `max_depth` int(10) DEFAULT '0',
  `max_weight` decimal(20,6) DEFAULT '0.000000',
  `grade` int(10) DEFAULT '0',
  PRIMARY KEY (`id_carrier`),
  KEY `deleted` (`deleted`,`active`),
  KEY `id_tax_rules_group` (`id_tax_rules_group`),
  KEY `reference` (`id_reference`,`deleted`,`active`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_carrier`
--

INSERT INTO `ps_carrier` (`id_carrier`, `id_reference`, `id_tax_rules_group`, `name`, `url`, `active`, `deleted`, `shipping_handling`, `range_behavior`, `is_module`, `is_free`, `shipping_external`, `need_range`, `external_module_name`, `shipping_method`, `position`, `max_width`, `max_height`, `max_depth`, `max_weight`, `grade`) VALUES (1,1,0,'Doudou Malaysia','',0,1,0,0,0,0,0,0,'',1,0,0,0,0,0.000000,0),(2,2,0,'My carrier','',0,1,1,0,0,0,0,0,'',1,1,0,0,0,0.000000,0),(3,2,0,'Pos Laju','',1,1,1,1,0,1,0,0,'',1,1,0,0,0,0.000000,0),(4,2,0,'Pos Laju','',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(5,2,0,'Pos Laju','',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(6,2,0,'Pos Laju','',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(7,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(8,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(9,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(10,1,0,'Doudou Malaysia','',0,1,0,0,0,1,0,0,'',2,0,70,60,50,10.000000,0),(11,1,0,'Doudou Malaysia','',0,1,0,0,0,1,0,0,'',2,0,70,60,50,10.000000,0),(12,1,0,'Doudou Malaysia','',0,1,0,0,0,0,0,0,'',2,0,70,60,50,10.000000,0),(13,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(14,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(15,1,0,'Doudou Malaysia','',1,1,0,0,0,0,0,0,'',2,0,70,60,50,10.000000,0),(16,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(17,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,1,70,50,50,10.000000,0),(18,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0),(19,1,0,'Doudou Malaysia','',1,1,0,0,0,1,0,0,'',2,0,70,60,50,10.000000,0),(20,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0),(21,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0),(22,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0),(23,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,1,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0),(24,2,0,'Pos Laju','http://www.poslaju.com.my/track-trace/',1,0,1,1,0,0,0,0,'',1,0,70,50,50,10.000000,0);

--
-- Table structure for table `ps_carrier_group`
--

CREATE TABLE `ps_carrier_group` (
  `id_carrier` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_carrier`,`id_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_carrier_group`
--

INSERT INTO `ps_carrier_group` (`id_carrier`, `id_group`) VALUES (1,1),(1,2),(1,3),(2,1),(2,2),(2,3),(3,1),(3,2),(3,3),(4,1),(4,2),(4,3),(5,1),(5,2),(5,3),(6,1),(6,2),(6,3),(7,1),(7,2),(7,3),(8,1),(8,2),(8,3),(9,1),(9,2),(9,3),(10,1),(10,2),(10,3),(11,1),(11,2),(11,3),(12,1),(12,2),(12,3),(13,1),(13,2),(13,3),(14,1),(14,2),(14,3),(15,1),(15,2),(15,3),(16,1),(16,2),(16,3),(17,1),(17,2),(17,3),(18,1),(18,2),(18,3),(19,1),(19,2),(19,3),(20,1),(20,2),(20,3),(21,1),(21,2),(21,3),(22,1),(22,2),(22,3),(23,1),(23,2),(23,3),(24,1),(24,2),(24,3);

--
-- Table structure for table `ps_carrier_lang`
--

CREATE TABLE `ps_carrier_lang` (
  `id_carrier` int(10) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_lang` int(10) unsigned NOT NULL,
  `delay` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id_lang`,`id_shop`,`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_carrier_lang`
--

INSERT INTO `ps_carrier_lang` (`id_carrier`, `id_shop`, `id_lang`, `delay`) VALUES (1,1,1,'Pick up in-store'),(2,1,1,'Delivery next day!'),(3,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(4,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(5,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(6,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(7,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(8,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(9,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(10,1,1,'Free Delivery'),(11,1,1,'Free Delivery'),(12,1,1,'Free Delivery'),(13,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(14,1,1,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(15,1,1,'2 to 5 Days'),(16,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(17,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(18,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(19,1,1,'2 to 5 Days'),(20,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(21,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(22,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(23,1,1,'2 to 5 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(24,1,1,'Please refer to tracking system for updates'),(1,1,2,'Pick up in-store'),(2,1,2,'Delivery next day!'),(3,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(4,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(5,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(6,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(7,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(8,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(9,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(10,1,2,'Free Delivery'),(11,1,2,'Free Delivery'),(12,1,2,'Free Delivery'),(13,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(14,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(15,1,2,'Free Delivery'),(16,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(17,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(18,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(19,1,2,'Free Delivery'),(20,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(21,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(22,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(23,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia'),(24,1,2,'2 to 3 days for Peninsula Malaysia, 3 to 7 days for Eastern Malaysia');

--
-- Table structure for table `ps_carrier_shop`
--

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

--
-- Dumping data for table `ps_carrier_shop`
--

INSERT INTO `ps_carrier_shop` (`id_carrier`, `id_shop`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1);

--
-- Table structure for table `ps_carrier_tax_rules_group_shop`
--

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

--
-- Dumping data for table `ps_carrier_tax_rules_group_shop`
--

INSERT INTO `ps_carrier_tax_rules_group_shop` (`id_carrier`, `id_tax_rules_group`, `id_shop`) VALUES (1,1,1),(2,1,1),(3,0,1),(4,0,1),(5,0,1),(6,0,1),(7,0,1),(8,0,1),(9,0,1),(10,1,1),(11,1,1),(12,0,1),(13,0,1),(14,0,1),(15,0,1),(16,0,1),(17,0,1),(18,0,1),(19,0,1),(20,0,1),(21,0,1),(22,0,1),(23,0,1),(24,0,1);

--
-- Table structure for table `ps_carrier_zone`
--

CREATE TABLE `ps_carrier_zone` (
  `id_carrier` int(10) unsigned NOT NULL,
  `id_zone` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_carrier`,`id_zone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_carrier_zone`
--

INSERT INTO `ps_carrier_zone` (`id_carrier`, `id_zone`) VALUES (1,1),(2,1),(2,2),(4,3),(5,3),(6,3),(7,3),(8,9),(8,10),(8,11),(9,9),(9,10),(9,11),(10,10),(11,10),(12,10),(13,9),(13,11),(14,9),(14,11),(15,10),(16,9),(16,11),(17,9),(17,11),(18,1),(18,2),(18,3),(18,4),(18,5),(18,6),(18,7),(18,8),(18,9),(18,10),(18,11),(19,1),(19,2),(19,3),(19,4),(19,5),(19,6),(19,7),(19,8),(19,9),(19,10),(19,11),(20,1),(20,2),(20,3),(20,4),(20,5),(20,6),(20,7),(20,8),(20,9),(20,10),(20,11),(21,1),(21,2),(21,4),(21,5),(21,6),(21,7),(21,8),(21,9),(21,10),(21,11),(22,9),(22,10),(22,11),(23,9),(23,10),(23,11),(24,9),(24,10),(24,11);

--
-- Table structure for table `ps_cart`
--

CREATE TABLE `ps_cart` (
  `id_cart` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop_group` int(11) unsigned NOT NULL DEFAULT '1',
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_carrier` int(10) unsigned NOT NULL,
  `delivery_option` text NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `id_address_delivery` int(10) unsigned NOT NULL,
  `id_address_invoice` int(10) unsigned NOT NULL,
  `id_currency` int(10) unsigned NOT NULL,
  `id_customer` int(10) unsigned NOT NULL,
  `id_guest` int(10) unsigned NOT NULL,
  `secure_key` varchar(32) NOT NULL DEFAULT '-1',
  `recyclable` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `gift` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `gift_message` text,
  `mobile_theme` tinyint(1) NOT NULL DEFAULT '0',
  `allow_seperated_package` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_cart`),
  KEY `cart_customer` (`id_customer`),
  KEY `id_address_delivery` (`id_address_delivery`),
  KEY `id_address_invoice` (`id_address_invoice`),
  KEY `id_carrier` (`id_carrier`),
  KEY `id_lang` (`id_lang`),
  KEY `id_currency` (`id_currency`),
  KEY `id_guest` (`id_guest`),
  KEY `id_shop_group` (`id_shop_group`),
  KEY `id_shop_2` (`id_shop`,`date_upd`),
  KEY `id_shop` (`id_shop`,`date_add`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart`
--

INSERT INTO `ps_cart` (`id_cart`, `id_shop_group`, `id_shop`, `id_carrier`, `delivery_option`, `id_lang`, `id_address_delivery`, `id_address_invoice`, `id_currency`, `id_customer`, `id_guest`, `secure_key`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES (1,1,1,2,'a:1:{i:3;s:2:\"2,\";}',1,4,4,1,1,2,'b44a6d9efd7a0076a0fbce6b15eaf3b1',0,0,'',0,0,'2015-08-17 20:32:53','2015-08-17 20:32:53'),(2,1,1,2,'a:1:{i:3;s:2:\"2,\";}',1,4,4,1,1,1,'b44a6d9efd7a0076a0fbce6b15eaf3b1',0,0,'',0,0,'2015-08-17 20:32:53','2015-08-17 20:32:53'),(3,1,1,2,'a:1:{i:3;s:2:\"2,\";}',1,4,4,1,1,1,'b44a6d9efd7a0076a0fbce6b15eaf3b1',0,0,'',0,0,'2015-08-17 20:32:54','2015-08-17 20:32:54'),(4,1,1,2,'a:1:{i:3;s:2:\"2,\";}',1,4,4,1,1,1,'b44a6d9efd7a0076a0fbce6b15eaf3b1',0,0,'',0,0,'2015-08-17 20:32:54','2015-08-17 20:32:54'),(5,1,1,2,'a:1:{i:3;s:2:\"2,\";}',1,4,4,1,1,1,'b44a6d9efd7a0076a0fbce6b15eaf3b1',0,0,'',0,0,'2015-08-17 20:32:54','2015-08-17 20:32:54'),(6,1,1,0,'',1,6,6,1,3,8,'16a0695020c8a2fca1de3caf762c46a8',0,0,'',0,0,'2015-08-31 17:47:42','2015-08-31 18:26:12'),(15,1,1,24,'a:1:{i:12;s:3:\"24,\";}',1,12,12,1,8,9,'3729fc07b2e1553824cb5a05e6b6d8a2',0,0,'',0,0,'2015-09-07 18:07:49','2015-09-08 16:35:47'),(24,1,1,24,'a:1:{i:13;s:3:\"24,\";}',1,13,13,1,9,10,'0a4fb8360014d92853bf8355dad3cb93',0,0,'',1,0,'2015-09-15 20:24:20','2015-09-15 20:26:56'),(26,1,1,24,'a:1:{i:14;s:3:\"24,\";}',1,14,14,1,10,65,'467d1a2114f2d4fbc7c38e11b10a413a',0,0,'',0,0,'2015-10-01 14:31:37','2015-10-04 14:29:17'),(27,1,1,24,'a:1:{i:15;s:3:\"24,\";}',1,15,15,1,11,219,'c64bc486dda935e76264298b7fcdbada',0,0,'',0,0,'2015-10-19 20:01:44','2015-10-20 14:47:12'),(28,1,1,0,'',1,17,17,1,12,814,'9021693daa3dbd0f14c42a74d1d2fe39',0,0,'',1,0,'2015-11-06 13:40:43','2015-11-06 13:53:21'),(29,1,1,24,'a:1:{i:19;s:3:\"24,\";}',1,19,19,1,13,629,'9155aeda051c5e9644cf0f2573ad76fe',0,0,'',0,0,'2015-11-06 19:03:28','2015-11-06 19:11:17'),(30,1,1,24,'a:1:{i:17;s:3:\"24,\";}',1,17,17,1,12,842,'9021693daa3dbd0f14c42a74d1d2fe39',0,0,'',0,0,'2015-11-08 13:46:10','2015-11-08 13:51:42'),(31,1,1,24,'a:1:{i:5;s:3:\"24,\";}',1,5,5,1,2,973,'e3538f48a1ae17263cb2a2ed33d7ddba',0,0,'',0,0,'2015-11-13 18:16:13','2015-11-13 18:19:54'),(32,1,1,0,'',1,0,0,1,0,1341,'',0,0,'',0,0,'2015-11-24 14:53:11','2015-11-24 14:53:11'),(33,0,1,24,'a:1:{i:0;s:3:\"24,\";}',1,21,21,1,15,0,'dcd13c9b0f636d4ab38d73bdd36f6c11',0,0,'',0,0,'2015-12-07 22:10:24','2015-12-07 22:25:37'),(34,0,1,24,'a:1:{i:0;s:3:\"24,\";}',1,22,22,1,16,0,'2f673d9fb7cb4bd8524a188e1a168495',0,0,'',0,0,'2015-12-09 22:05:42','2015-12-09 22:11:33'),(35,1,1,24,'a:1:{i:23;s:3:\"24,\";}',1,23,23,1,17,1749,'64d391428734474f99cb260ccc3ce45e',0,0,'',0,0,'2015-12-11 20:54:59','2015-12-11 20:59:57'),(36,0,1,24,'a:1:{i:0;s:3:\"24,\";}',1,24,24,1,18,0,'95f7e8b25b0172465d82eb6606e7d32a',0,0,'',0,0,'2015-12-12 18:25:07','2015-12-12 18:27:30'),(37,1,1,24,'a:1:{i:25;s:3:\"24,\";}',1,25,25,1,19,1572,'11fc6a0ff6220d0efa7754714510fa94',0,0,'',1,0,'2015-12-16 09:37:02','2015-12-16 22:30:43'),(38,1,1,0,'',1,25,25,1,19,1984,'11fc6a0ff6220d0efa7754714510fa94',0,0,'',1,0,'2015-12-16 22:26:36','2015-12-16 22:28:24'),(39,1,1,24,'a:1:{i:27;s:3:\"24,\";}',1,27,27,1,20,2297,'cf9c4fca9193411d4b2b0c4904b84d62',0,0,'',0,0,'2015-12-19 13:16:33','2015-12-26 10:44:28'),(40,0,1,24,'a:1:{i:19;s:3:\"24,\";}',1,19,19,1,13,0,'9155aeda051c5e9644cf0f2573ad76fe',0,0,'',0,0,'2015-12-21 22:13:01','2015-12-21 22:14:07'),(41,1,1,24,'a:1:{i:26;s:3:\"24,\";}',1,26,26,1,21,1799,'c617de85606a24d653745016f2039d6e',0,0,'',0,0,'2015-12-23 11:13:33','2015-12-23 17:44:46'),(42,1,1,0,'',1,25,25,1,19,1572,'11fc6a0ff6220d0efa7754714510fa94',0,0,'',1,0,'2015-12-23 13:41:43','2015-12-23 13:42:02'),(43,1,1,24,'a:1:{i:26;s:3:\"24,\";}',1,26,26,1,21,1799,'c617de85606a24d653745016f2039d6e',0,0,'',0,0,'2015-12-23 17:49:06','2015-12-23 22:15:36'),(44,1,1,0,'',1,26,26,1,21,1799,'c617de85606a24d653745016f2039d6e',0,0,'',0,0,'2015-12-29 17:37:08','2015-12-29 17:37:20'),(45,1,1,24,'a:1:{i:31;s:3:\"24,\";}',1,31,31,1,22,4128,'89eccd76665e2334446614e9ad6a9c79',0,0,'',0,0,'2015-12-29 17:37:56','2015-12-29 17:43:25'),(46,1,1,0,'',1,0,0,1,0,4464,'',0,0,'',1,0,'2016-01-01 09:07:41','2016-01-01 09:07:42');

--
-- Table structure for table `ps_cart_cart_rule`
--

CREATE TABLE `ps_cart_cart_rule` (
  `id_cart` int(10) unsigned NOT NULL,
  `id_cart_rule` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart`,`id_cart_rule`),
  KEY `id_cart_rule` (`id_cart_rule`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_cart_rule`
--

INSERT INTO `ps_cart_cart_rule` (`id_cart`, `id_cart_rule`) VALUES (26,1),(31,1),(35,1),(27,2),(28,2),(30,2),(33,2),(34,2),(37,2),(39,2),(41,2),(42,2),(29,4),(31,5),(33,6),(34,7),(36,8),(40,9);

--
-- Table structure for table `ps_cart_product`
--

CREATE TABLE `ps_cart_product` (
  `id_cart` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_address_delivery` int(10) unsigned NOT NULL DEFAULT '0',
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `id_product_attribute` int(10) unsigned NOT NULL DEFAULT '0',
  `quantity` int(10) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`),
  KEY `id_product_attribute` (`id_product_attribute`),
  KEY `id_cart_order` (`id_cart`,`date_add`,`id_product`,`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_product`
--

INSERT INTO `ps_cart_product` (`id_cart`, `id_product`, `id_address_delivery`, `id_shop`, `id_product_attribute`, `quantity`, `date_add`) VALUES (6,110,6,1,0,1,'2015-08-31 18:26:09'),(6,117,6,1,0,1,'2015-08-31 18:25:52'),(15,66,12,1,0,1,'2015-09-08 16:32:03'),(24,43,13,1,0,1,'2015-09-15 20:24:20'),(26,39,14,1,0,1,'2015-10-01 14:31:39'),(26,66,14,1,0,1,'2015-10-04 13:29:47'),(26,127,14,1,0,1,'2015-10-04 13:23:43'),(27,88,15,1,71,1,'2015-10-19 20:01:45'),(28,117,17,1,0,1,'2015-11-06 13:40:43'),(29,71,19,1,0,1,'2015-11-06 19:04:16'),(30,117,17,1,0,1,'2015-11-08 13:47:40'),(33,187,21,1,0,1,'2015-12-07 22:21:58'),(34,60,22,1,0,1,'2015-12-09 22:08:29'),(37,188,25,1,0,1,'2015-12-16 22:30:04'),(38,188,25,1,0,1,'2015-12-16 22:28:24'),(39,42,27,1,0,1,'2015-12-26 10:41:54'),(40,171,19,1,0,1,'2015-12-21 22:13:27'),(41,187,26,1,0,1,'2015-12-23 17:40:52'),(41,188,26,1,0,1,'2015-12-23 17:40:49'),(42,187,25,1,0,1,'2015-12-23 13:42:02'),(42,188,25,1,0,1,'2015-12-23 13:41:43'),(46,117,0,1,0,1,'2016-01-01 09:07:42');

--
-- Table structure for table `ps_cart_rule`
--

CREATE TABLE `ps_cart_rule` (
  `id_cart_rule` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_customer` int(10) unsigned NOT NULL DEFAULT '0',
  `date_from` datetime NOT NULL,
  `date_to` datetime NOT NULL,
  `description` text,
  `quantity` int(10) unsigned NOT NULL DEFAULT '0',
  `quantity_per_user` int(10) unsigned NOT NULL DEFAULT '0',
  `priority` int(10) unsigned NOT NULL DEFAULT '1',
  `partial_use` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `code` varchar(254) NOT NULL,
  `minimum_amount` decimal(17,2) NOT NULL DEFAULT '0.00',
  `minimum_amount_tax` tinyint(1) NOT NULL DEFAULT '0',
  `minimum_amount_currency` int(10) unsigned NOT NULL DEFAULT '0',
  `minimum_amount_shipping` tinyint(1) NOT NULL DEFAULT '0',
  `country_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `carrier_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `group_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cart_rule_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `product_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `shop_restriction` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `free_shipping` tinyint(1) NOT NULL DEFAULT '0',
  `reduction_percent` decimal(5,2) NOT NULL DEFAULT '0.00',
  `reduction_amount` decimal(17,2) NOT NULL DEFAULT '0.00',
  `reduction_tax` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `reduction_currency` int(10) unsigned NOT NULL DEFAULT '0',
  `reduction_product` int(10) NOT NULL DEFAULT '0',
  `gift_product` int(10) unsigned NOT NULL DEFAULT '0',
  `gift_product_attribute` int(10) unsigned NOT NULL DEFAULT '0',
  `highlight` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_cart_rule`),
  KEY `id_customer` (`id_customer`,`active`,`date_to`),
  KEY `group_restriction` (`group_restriction`,`active`,`date_to`),
  KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`),
  KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule`
--

INSERT INTO `ps_cart_rule` (`id_cart_rule`, `id_customer`, `date_from`, `date_to`, `description`, `quantity`, `quantity_per_user`, `priority`, `partial_use`, `code`, `minimum_amount`, `minimum_amount_tax`, `minimum_amount_currency`, `minimum_amount_shipping`, `country_restriction`, `carrier_restriction`, `group_restriction`, `cart_rule_restriction`, `product_restriction`, `shop_restriction`, `free_shipping`, `reduction_percent`, `reduction_amount`, `reduction_tax`, `reduction_currency`, `reduction_product`, `gift_product`, `gift_product_attribute`, `highlight`, `active`, `date_add`, `date_upd`) VALUES (1,0,'2015-10-01 17:00:00','2017-12-01 17:00:00','40 % discount for Staff. No Delivery Charges. ',7,10,1,1,'STAFFDISCOUNT',0.00,1,1,1,0,0,0,0,0,0,1,40.00,0.00,0,1,0,0,0,0,1,'2015-10-01 18:05:44','2015-12-11 21:00:21'),(2,0,'2015-10-04 14:00:00','2016-12-31 14:00:00','10 % Discount for Friends and relatives.',97,5,1,1,'DISCOUNT10',0.00,1,1,1,0,0,0,0,0,0,1,10.00,0.00,0,1,0,0,0,0,1,'2015-10-04 14:40:14','2015-12-26 10:45:12'),(3,0,'2015-10-29 17:00:00','2015-12-31 23:59:00','15% discount for participant to Hypnobirthing event + Free delivery',30,1,1,1,'HYPNOBIRTHDOUDOU',0.00,1,1,1,0,0,0,0,0,0,1,15.00,0.00,0,1,0,0,0,0,1,'2015-10-29 17:26:20','2015-10-29 17:27:27'),(4,0,'2015-12-20 18:00:00','2015-12-23 18:00:00','30% Discount',1,0,1,0,'30%DISCOUNT',0.00,1,1,1,0,0,0,0,0,0,1,30.00,0.00,0,1,0,0,0,0,1,'2015-11-06 18:57:56','2015-12-21 22:19:25'),(5,2,'2015-11-13 18:19:55','2015-11-23 18:19:55','',0,1,1,1,'BO_ORDER_31',0.00,0,1,0,0,0,0,0,0,0,1,0.00,0.00,0,1,0,0,0,0,1,'2015-11-13 18:19:55','2015-11-13 18:20:20'),(6,15,'2015-12-07 22:25:37','2015-12-17 22:25:37','',0,1,1,1,'BO_ORDER_33',0.00,0,1,0,0,0,0,0,0,0,1,0.00,0.00,0,1,0,0,0,0,1,'2015-12-07 22:25:37','2015-12-07 22:25:55'),(7,16,'2015-12-09 22:11:33','2015-12-19 22:11:33','',1,1,1,1,'BO_ORDER_34',0.00,0,1,0,0,0,0,0,0,0,1,0.00,0.00,0,1,0,0,0,0,1,'2015-12-09 22:11:33','2015-12-09 22:11:33'),(8,18,'2015-12-12 18:27:30','2015-12-22 18:27:30','',1,1,1,1,'BO_ORDER_36',0.00,0,1,0,0,0,0,0,0,0,1,0.00,0.00,0,1,0,0,0,0,1,'2015-12-12 18:27:30','2015-12-12 18:27:30'),(9,13,'2015-12-21 22:15:14','2015-12-31 22:15:14','',1,1,1,1,'BO_ORDER_40',0.00,0,1,0,0,0,0,0,0,0,1,0.00,0.00,0,1,0,0,0,0,1,'2015-12-21 22:15:14','2015-12-21 22:15:14'),(11,0,'2015-12-21 21:14:21','2015-12-21 23:21:18','',0,1,1,1,'',0.00,0,0,0,0,0,0,0,0,0,0,0.00,0.00,0,1,0,0,0,0,0,'2015-12-21 22:21:18','2015-12-21 22:21:18'),(12,0,'2015-12-21 21:14:21','2015-12-21 23:23:02','',0,1,1,1,'',0.00,0,0,0,0,0,0,0,0,0,0,30.00,0.00,0,1,0,0,0,0,0,'2015-12-21 22:23:02','2015-12-21 22:23:02');

--
-- Table structure for table `ps_cart_rule_carrier`
--

CREATE TABLE `ps_cart_rule_carrier` (
  `id_cart_rule` int(10) unsigned NOT NULL,
  `id_carrier` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart_rule`,`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_carrier`
--


--
-- Table structure for table `ps_cart_rule_combination`
--

CREATE TABLE `ps_cart_rule_combination` (
  `id_cart_rule_1` int(10) unsigned NOT NULL,
  `id_cart_rule_2` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart_rule_1`,`id_cart_rule_2`),
  KEY `id_cart_rule_1` (`id_cart_rule_1`),
  KEY `id_cart_rule_2` (`id_cart_rule_2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_combination`
--


--
-- Table structure for table `ps_cart_rule_country`
--

CREATE TABLE `ps_cart_rule_country` (
  `id_cart_rule` int(10) unsigned NOT NULL,
  `id_country` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart_rule`,`id_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_country`
--


--
-- Table structure for table `ps_cart_rule_group`
--

CREATE TABLE `ps_cart_rule_group` (
  `id_cart_rule` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart_rule`,`id_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_group`
--


--
-- Table structure for table `ps_cart_rule_lang`
--

CREATE TABLE `ps_cart_rule_lang` (
  `id_cart_rule` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(254) NOT NULL,
  PRIMARY KEY (`id_cart_rule`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_lang`
--

INSERT INTO `ps_cart_rule_lang` (`id_cart_rule`, `id_lang`, `name`) VALUES (1,1,'STAFF DISCOUNT'),(1,2,'STAFF DISCOUNT'),(2,1,'FRIEND DISCOUNT'),(2,2,'FRIEND DISCOUNT'),(3,1,'Hypnobirthing event'),(3,2,'Hypnobirthing event'),(4,1,'30%DISCOUNT'),(4,2,'30%DISCOUNT'),(5,1,'Free Shipping'),(5,2,'Free Shipping'),(6,1,'Free Shipping'),(6,2,'Free Shipping'),(7,1,'Free Shipping'),(7,2,'Free Shipping'),(8,1,'Free Shipping'),(8,2,'Free Shipping'),(9,1,'Free Shipping'),(9,2,'Free Shipping'),(11,1,'30%DISCOUNT'),(11,2,'30%DISCOUNT'),(12,1,'30%DISCOUNT'),(12,2,'30%DISCOUNT');

--
-- Table structure for table `ps_cart_rule_product_rule`
--

CREATE TABLE `ps_cart_rule_product_rule` (
  `id_product_rule` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_product_rule_group` int(10) unsigned NOT NULL,
  `type` enum('products','categories','attributes','manufacturers','suppliers') NOT NULL,
  PRIMARY KEY (`id_product_rule`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_product_rule`
--


--
-- Table structure for table `ps_cart_rule_product_rule_group`
--

CREATE TABLE `ps_cart_rule_product_rule_group` (
  `id_product_rule_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cart_rule` int(10) unsigned NOT NULL,
  `quantity` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_product_rule_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_product_rule_group`
--


--
-- Table structure for table `ps_cart_rule_product_rule_value`
--

CREATE TABLE `ps_cart_rule_product_rule_value` (
  `id_product_rule` int(10) unsigned NOT NULL,
  `id_item` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_product_rule`,`id_item`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_product_rule_value`
--


--
-- Table structure for table `ps_cart_rule_shop`
--

CREATE TABLE `ps_cart_rule_shop` (
  `id_cart_rule` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cart_rule`,`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cart_rule_shop`
--


--
-- Table structure for table `ps_category`
--

CREATE TABLE `ps_category` (
  `id_category` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` int(10) unsigned NOT NULL,
  `id_shop_default` int(10) unsigned NOT NULL DEFAULT '1',
  `level_depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `nleft` int(10) unsigned NOT NULL DEFAULT '0',
  `nright` int(10) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `is_root_category` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_category`),
  KEY `category_parent` (`id_parent`),
  KEY `nleftrightactive` (`nleft`,`nright`,`active`),
  KEY `level_depth` (`level_depth`),
  KEY `nright` (`nright`),
  KEY `activenleft` (`active`,`nleft`),
  KEY `activenright` (`active`,`nright`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_category`
--

INSERT INTO `ps_category` (`id_category`, `id_parent`, `id_shop_default`, `level_depth`, `nleft`, `nright`, `active`, `date_add`, `date_upd`, `position`, `is_root_category`) VALUES (1,0,1,0,1,42,1,'2015-08-17 20:31:45','2015-08-17 20:31:45',0,0),(2,1,1,1,2,41,1,'2015-08-17 20:31:45','2015-08-17 20:31:45',0,1),(3,2,1,2,3,20,1,'2015-08-17 20:32:55','2015-09-07 12:25:38',0,0),(4,3,1,3,4,5,1,'2015-08-17 20:32:55','2015-09-08 10:43:06',0,0),(9,3,1,3,10,11,1,'2015-08-17 20:32:58','2015-09-08 11:34:52',3,0),(12,2,1,2,21,32,1,'2015-08-18 13:43:31','2015-09-02 00:23:20',1,0),(13,3,1,3,6,7,1,'2015-08-18 13:55:10','2015-12-14 13:35:27',1,0),(14,3,1,3,12,13,1,'2015-08-19 18:16:55','2015-09-08 10:44:33',4,0),(15,12,1,3,22,23,1,'2015-08-19 18:48:54','2015-09-12 19:43:37',0,0),(16,12,1,3,24,25,1,'2015-08-19 19:19:49','2015-09-08 10:39:25',1,0),(17,12,1,3,26,27,1,'2015-08-19 19:26:16','2015-09-08 10:40:16',2,0),(18,12,1,3,28,29,1,'2015-08-25 18:59:45','2015-09-08 10:40:59',3,0),(19,2,1,2,33,38,1,'2015-08-26 11:55:05','2015-09-02 00:27:40',2,0),(20,19,1,3,34,35,1,'2015-08-26 12:12:44','2015-09-08 10:36:59',0,0),(21,19,1,3,36,37,1,'2015-08-26 13:05:31','2015-09-08 10:37:35',1,0),(22,12,1,3,30,31,1,'2015-08-26 13:06:59','2015-09-08 10:41:39',4,0),(23,3,1,3,16,17,1,'2015-08-28 10:49:29','2015-09-08 10:45:54',7,0),(24,3,1,3,14,15,1,'2015-08-28 14:55:05','2015-09-08 10:45:12',5,0),(25,2,1,2,39,40,0,'2015-08-30 21:27:35','2015-08-30 21:27:35',0,0),(26,3,1,3,8,9,1,'2015-09-08 12:26:05','2015-09-08 12:26:54',8,0),(27,3,1,3,18,19,0,'2015-11-18 20:10:32','2015-11-18 20:10:32',0,0);

--
-- Table structure for table `ps_category_group`
--

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

--
-- Dumping data for table `ps_category_group`
--

INSERT INTO `ps_category_group` (`id_category`, `id_group`) VALUES (2,0),(2,1),(2,2),(2,3),(3,1),(3,2),(3,3),(4,1),(4,2),(4,3),(9,1),(9,2),(9,3),(12,1),(12,2),(12,3),(13,1),(13,2),(13,3),(14,1),(14,2),(14,3),(15,1),(15,2),(15,3),(16,1),(16,2),(16,3),(17,1),(17,2),(17,3),(18,1),(18,2),(18,3),(19,1),(19,2),(19,3),(20,1),(20,2),(20,3),(21,1),(21,2),(21,3),(22,1),(22,2),(22,3),(23,1),(23,2),(23,3),(24,1),(24,2),(24,3),(25,1),(25,2),(25,3),(26,1),(26,2),(26,3),(27,1),(27,2),(27,3);

--
-- Table structure for table `ps_category_lang`
--

CREATE TABLE `ps_category_lang` (
  `id_category` int(10) unsigned NOT NULL,
  `id_shop` int(11) unsigned NOT NULL DEFAULT '1',
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(128) NOT NULL,
  `description` text,
  `link_rewrite` varchar(128) NOT NULL,
  `meta_title` varchar(128) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_category`,`id_shop`,`id_lang`),
  KEY `category_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_category_lang`
--

INSERT INTO `ps_category_lang` (`id_category`, `id_shop`, `id_lang`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (1,1,1,'Root','','root','','',''),(1,1,2,'Root','','root','','',''),(2,1,1,'Home','','home','','',''),(2,1,2,'Home','','home','','',''),(3,1,1,'Doudou et Compagnie','','doudou-et-compagnie','Doudou et Compagnie','doudou et compagnie, doudou malaysia ,doudou,soft toy,comforting blanket','Doudou et Compagnie collection available in Malaysia'),(3,1,2,'Doudou et Compagnie','','doudou-et-compagnie','Doudou et Compagnie','doudou et compagnie, doudou malaysia ,doudou,soft toy,comforting blanket','Doudou et Compagnie collection available in Malaysia'),(4,1,1,'Rabbit Pompon','','rabbit-pompon','','Rabbit Pompon,doudou malaysia,doudou,doudou et compagnie,cuddling toys,comforting blanket',''),(4,1,2,'Rabbit Pompon','','rabbit-pompon','','Rabbit Pompon,doudou malaysia,doudou,doudou et compagnie,cuddling toys,comforting blanket',''),(9,1,1,'Generation Doudou','','generation-doudou','','doudou generation,generation doudou,doudou malaysia,melis,celeste,Lila,Petit Chou,Cerise,cuddling toys,smelly pillow,activity doll,awakening,baby ,early age',''),(9,1,2,'Generation Doudou','','generation-doudou','','doudou generation,generation doudou,doudou malaysia,melis,celeste,Lila,Petit Chou,Cerise,cuddling toys,smelly pillow,activity doll,awakening,baby ,early age',''),(12,1,1,'Histoire d Ours','','histoire-d-ours','','histoire d\'ours,histoire d ours,plush toys,plush toys malaysia,plush malaysia,soft toys,soft toys malaysia,doudou malaysia',''),(12,1,2,'Histoire d Ours','','histoire-d-ours','','histoire d\'ours,histoire d ours,plush toys,plush toys malaysia,plush malaysia,soft toys,soft toys malaysia,doudou malaysia',''),(13,1,1,'Rabbit Bonbon (Candy)','','rabbit-bonbon-candy','','doudou rabbit,rabbit soft toys,doudou malaysia,cuddling toys',''),(13,1,2,'Rabbit Bonbon','','rabbit-bonbon','','doudou rabbit,rabbit soft toys,doudou malaysia,cuddling toys',''),(14,1,1,'Doudou Pop','','doudou-pop','','doudou,doudou malaysia,pop,pops de doudou,activity doll,musical box',''),(14,1,2,'Doudou Pop','','doudou-pop','','doudou,doudou malaysia,pop,pops de doudou,activity doll,musical box',''),(15,1,1,'Copains et Compagnie - Friends and Company','','copains-et-compagnie-friends-and-company','','Histoire d ours,plush toys,bear,teddy bear',''),(15,1,2,'Copains et Compagnie - Friends and Company','','copains-et-compagnie-friends-and-company','','Histoire d ours,plush toys,bear,teddy bear',''),(16,1,1,'Les Ours - The Bears','','les-ours-the-bears','','Bear,Plush Toys,Bear Toys,Bear Plush Toys,Histoire d ours bear',''),(16,1,2,'Les Ours - The Bears','','les-ours-the-bears','','Bear,Plush Toys,Bear Toys,Bear Plush Toys,Histoire d ours bear',''),(17,1,1,'The Savannah','','the-savannah','','plush toys,doudou malaysia,leo plush,croco plush,hippo plush,savannah,wild animals plush toys',''),(17,1,2,'The Savannah','','the-savannah','','plush toys,doudou malaysia,leo plush,croco plush,hippo plush,savannah,wild animals plush toys',''),(18,1,1,'The Farm','','the-farm','','',''),(18,1,2,'The Farm','','the-farm','','',''),(19,1,1,'The Puppets','','the-puppets','','Puppets, doudou et compagnie ,histoire d ours,doudou,plush toys,puppet toys,soft toys',''),(19,1,2,'The Puppets','','the-puppets','','Puppets, doudou et compagnie ,histoire d ours,doudou,plush toys,puppet toys,soft toys',''),(20,1,1,'The Puppets - Histoire d ours','','the-puppets-histoire-d-ours','','puppets,puppet,Histoire d ours,doudou puppet',''),(20,1,2,'The Puppets - Histoire d ours','','the-puppets-histoire-d-ours','','puppets,puppet,Histoire d ours,doudou puppet',''),(21,1,1,'The Puppets - Doudou et Compagnie','','the-puppets-doudou-et-compagnie','','puppets,puppet,doudou puppet,doudou et compagnie puppet',''),(21,1,2,'The Puppets - Doudou et Compagnie','','the-puppets-doudou-et-compagnie','','puppets,puppet,doudou puppet,doudou et compagnie puppet',''),(22,1,1,'Les Authentiques ','','les-authentiques-','','',''),(22,1,2,'Les Authentiques ','','les-authentiques-','','',''),(23,1,1,'Accessories','','accessories','','',''),(23,1,2,'Accessories','','accessories','','',''),(24,1,1,'Les Demoiselles - The Ladies','','les-demoiselles-the-ladies','','',''),(24,1,2,'Les Demoiselles - The Ladies','','les-demoiselles-the-ladies','','',''),(25,1,1,'Divers','','Divers','','',''),(25,1,2,'Divers','','Divers','','',''),(26,1,1,'Culture Doudou','','culture-doudou','','',''),(26,1,2,'Culture Doudou','','culture-doudou','','',''),(27,1,1,'The Choupidoux','','the-choupidoux','','',''),(27,1,2,'The Choupidoux','','the-choupidoux','','','');

--
-- Table structure for table `ps_category_product`
--

CREATE TABLE `ps_category_product` (
  `id_category` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_category`,`id_product`),
  KEY `id_product` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_category_product`
--

INSERT INTO `ps_category_product` (`id_category`, `id_product`, `position`) VALUES (2,8,0),(4,16,0),(4,66,1),(4,68,2),(4,69,3),(4,70,4),(4,86,5),(4,87,6),(4,134,7),(4,135,8),(4,136,9),(4,137,10),(4,184,11),(4,185,12),(4,187,13),(4,193,14),(9,9,0),(9,12,1),(9,13,2),(9,14,3),(9,62,4),(9,63,5),(9,64,6),(9,71,7),(9,72,8),(9,73,9),(9,118,11),(9,119,10),(9,120,12),(9,121,13),(9,127,14),(9,130,15),(9,146,16),(9,147,17),(9,148,18),(9,149,19),(9,191,20),(13,8,0),(13,17,1),(13,18,2),(13,57,3),(13,65,4),(13,188,5),(13,190,6),(14,24,0),(14,25,1),(14,26,2),(14,103,3),(14,110,4),(14,111,5),(14,112,6),(14,113,7),(14,114,8),(14,115,12),(14,116,9),(14,117,10),(14,123,11),(14,124,13),(14,126,14),(14,145,15),(14,186,16),(15,29,0),(15,37,1),(15,38,2),(15,39,3),(15,131,4),(15,167,5),(15,168,6),(15,169,7),(15,170,8),(15,183,9),(15,192,10),(16,31,0),(16,43,1),(16,46,2),(16,47,3),(16,157,4),(16,159,5),(16,172,6),(16,179,7),(16,183,8),(17,32,0),(17,33,1),(17,34,2),(17,35,3),(17,36,4),(17,129,5),(17,153,6),(17,154,7),(17,155,8),(17,156,9),(17,158,10),(17,160,11),(17,161,12),(17,162,13),(17,163,14),(17,164,15),(17,171,16),(18,40,0),(18,41,1),(18,42,2),(18,44,3),(18,45,4),(18,128,5),(18,165,6),(18,180,7),(18,181,8),(20,48,0),(20,49,1),(20,50,2),(20,51,3),(20,52,4),(21,58,0),(21,59,1),(21,96,2),(21,97,3),(21,98,4),(21,99,5),(21,100,6),(21,101,7),(21,102,8),(21,105,9),(21,106,10),(21,107,11),(21,108,12),(21,109,13),(21,138,14),(21,139,15),(21,140,16),(21,141,17),(21,142,18),(21,143,19),(21,150,20),(22,53,0),(22,54,1),(22,55,2),(22,56,3),(22,158,4),(22,160,5),(22,161,6),(23,81,0),(23,82,1),(23,83,2),(23,84,3),(23,85,4),(23,86,5),(23,87,6),(23,88,7),(23,89,8),(23,144,9),(23,151,10),(23,152,11),(24,90,0),(24,91,1),(24,92,2),(24,93,3),(24,94,4),(24,110,5),(24,111,6),(24,112,7),(24,113,8),(26,20,0),(26,60,1),(26,61,2),(26,74,4),(26,75,3),(26,76,5),(26,77,6),(26,78,7),(26,79,8),(26,80,9),(26,95,10),(26,122,11),(26,125,12),(26,132,13),(26,133,14),(26,150,15),(26,182,16),(26,189,17),(27,173,0),(27,174,1),(27,175,2),(27,176,3),(27,177,4),(27,178,5);

--
-- Table structure for table `ps_category_shop`
--

CREATE TABLE `ps_category_shop` (
  `id_category` int(11) NOT NULL,
  `id_shop` int(11) NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_category`,`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_category_shop`
--

INSERT INTO `ps_category_shop` (`id_category`, `id_shop`, `position`) VALUES (1,1,0),(2,1,0),(3,1,0),(4,1,0),(9,1,3),(12,1,1),(13,1,1),(14,1,4),(15,1,0),(16,1,1),(17,1,2),(18,1,3),(19,1,2),(20,1,0),(21,1,1),(22,1,4),(23,1,6),(24,1,5),(25,1,3),(26,1,2),(27,1,7);

--
-- Table structure for table `ps_cms`
--

CREATE TABLE `ps_cms` (
  `id_cms` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cms_category` int(10) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `indexation` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_cms`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms`
--

INSERT INTO `ps_cms` (`id_cms`, `id_cms_category`, `position`, `active`, `indexation`) VALUES (1,1,0,1,0),(2,1,1,1,0),(3,1,2,1,0),(4,1,3,1,1),(5,1,4,0,0);

--
-- Table structure for table `ps_cms_block`
--

CREATE TABLE `ps_cms_block` (
  `id_cms_block` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cms_category` int(10) unsigned NOT NULL,
  `location` tinyint(1) unsigned NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `display_store` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_cms_block`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_block`
--

INSERT INTO `ps_cms_block` (`id_cms_block`, `id_cms_category`, `location`, `position`, `display_store`) VALUES (1,1,0,0,1);

--
-- Table structure for table `ps_cms_block_lang`
--

CREATE TABLE `ps_cms_block_lang` (
  `id_cms_block` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `name` varchar(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_cms_block`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_block_lang`
--

INSERT INTO `ps_cms_block_lang` (`id_cms_block`, `id_lang`, `name`) VALUES (1,1,'Information'),(1,2,'Information');

--
-- Table structure for table `ps_cms_block_page`
--

CREATE TABLE `ps_cms_block_page` (
  `id_cms_block_page` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cms_block` int(10) unsigned NOT NULL,
  `id_cms` int(10) unsigned NOT NULL,
  `is_category` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id_cms_block_page`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_block_page`
--

INSERT INTO `ps_cms_block_page` (`id_cms_block_page`, `id_cms_block`, `id_cms`, `is_category`) VALUES (1,1,1,0),(2,1,2,0),(3,1,3,0),(4,1,4,0),(5,1,5,0);

--
-- Table structure for table `ps_cms_block_shop`
--

CREATE TABLE `ps_cms_block_shop` (
  `id_cms_block` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_cms_block`,`id_shop`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_block_shop`
--

INSERT INTO `ps_cms_block_shop` (`id_cms_block`, `id_shop`) VALUES (1,1);

--
-- Table structure for table `ps_cms_category`
--

CREATE TABLE `ps_cms_category` (
  `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_parent` int(10) unsigned NOT NULL,
  `level_depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `active` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_cms_category`),
  KEY `category_parent` (`id_parent`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_category`
--

INSERT INTO `ps_cms_category` (`id_cms_category`, `id_parent`, `level_depth`, `active`, `date_add`, `date_upd`, `position`) VALUES (1,0,1,1,'2015-08-17 20:31:43','2015-08-17 20:31:43',0);

--
-- Table structure for table `ps_cms_category_lang`
--

CREATE TABLE `ps_cms_category_lang` (
  `id_cms_category` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `name` varchar(128) NOT NULL,
  `description` text,
  `link_rewrite` varchar(128) NOT NULL,
  `meta_title` varchar(128) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_cms_category`,`id_shop`,`id_lang`),
  KEY `category_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_category_lang`
--

INSERT INTO `ps_cms_category_lang` (`id_cms_category`, `id_lang`, `id_shop`, `name`, `description`, `link_rewrite`, `meta_title`, `meta_keywords`, `meta_description`) VALUES (1,1,1,'Home','','home','','',''),(1,2,1,'Home','','home','','','');

--
-- Table structure for table `ps_cms_category_shop`
--

CREATE TABLE `ps_cms_category_shop` (
  `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_shop` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_cms_category`,`id_shop`),
  KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_category_shop`
--

INSERT INTO `ps_cms_category_shop` (`id_cms_category`, `id_shop`) VALUES (1,1);

--
-- Table structure for table `ps_cms_lang`
--

CREATE TABLE `ps_cms_lang` (
  `id_cms` int(10) unsigned NOT NULL,
  `id_lang` int(10) unsigned NOT NULL,
  `id_shop` int(10) unsigned NOT NULL DEFAULT '1',
  `meta_title` varchar(128) NOT NULL,
  `meta_description` varchar(255) DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `content` longtext,
  `link_rewrite` varchar(128) NOT NULL,
  PRIMARY KEY (`id_cms`,`id_shop`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_lang`
--

INSERT INTO `ps_cms_lang` (`id_cms`, `id_lang`, `id_shop`, `meta_title`, `meta_description`, `meta_keywords`, `content`, `link_rewrite`) VALUES (1,1,1,'Delivery','Our terms and conditions of delivery','conditions, delivery, delay, shipment, pack','<h2>Shipments and returns</h2>\n<h3>Your pack shipment</h3>\n<p>Packages are generally dispatched within 2 days after receipt of payment and are shipped via Pos Laju with tracking. If you prefer delivery via another carrier, please contact us before choosing this method. Additional costs could apply. Whichever shipment choice you make, we will provide you with a link to track your package online.</p>\n<p>Shipping fees include handling and packing fees as well as postage costs. Transport fees vary according to total weight of the shipment. We advise you to group your items in one order. We cannot group two distinct orders placed separately, and shipping fees will apply to each of them. Your package will be dispatched at your own risk, but special care is taken to protect fragile objects.<br /><br />Boxes are amply sized and your items are well-protected.</p>','delivery'),(1,2,1,'Delivery','Our terms and conditions of delivery','conditions, delivery, delay, shipment, pack','<h2>Shipments and returns</h2>\n<h3>Your pack shipment</h3>\n<p>Packages are generally dispatched within 2 days after receipt of payment and are shipped via Pos Laju with tracking. If you prefer delivery via another carrier, please contact us before choosing this method. Additional costs could apply. Whichever shipment choice you make, we will provide you with a link to track your package online.</p>\n<p>Shipping fees include handling and packing fees as well as postage costs. Transport fees vary according to total weight of the shipment. We advise you to group your items in one order. We cannot group two distinct orders placed separately, and shipping fees will apply to each of them. Your package will be dispatched at your own risk, but special care is taken to protect fragile objects.<br /><br />Boxes are amply sized and your items are well-protected.</p>','delivery'),(2,1,1,'Legal Notice','Legal notice','notice, legal, credits','<p>doudoumalaysia.com.my is the Malaysian official website for the trademarks DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS</p>\n<p>This website is managed by A&amp;O Distribution Sdn Bhd (1149679-H), the official distributor for DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS in Malaysia.</p>','legal-notice'),(2,2,1,'Legal Notice','Legal notice','notice, legal, credits','<p>doudoumalaysia.com.my is the Malaysian official website for the trademarks DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS</p>\n<p>This website is managed by A&amp;O Distribution Sdn Bhd (1149679-H), the official distributor for DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS in Malaysia.</p>','legal-notice'),(3,1,1,'Terms and conditions','Terms and conditions','conditions, terms, use, sell','<h1 id=\"tandc\">Terms &amp; Conditions</h1>\n<h2>INTRODUCTION</h2>\n<p>Welcome to the doudoumalaysia.com.my website (THE SITE). These terms and conditions of use (TERMS AND CONDITIONS) apply to THE SITE, A&amp;O Distribution Sdn Bhd (1149679-H), and all of its divisions, subsidiaries, and affiliate operated Internet sites which reference these TERMS AND CONDITIONS. A&amp;O means A&amp;O Distribution Sdn Bhd, a company incorporated in Malaysia under registration number 1149679-H and having its registered address at No.40-2, Fraser Business Park, Jalan Metro Pudu 2, 55200, Kuala Lumpur, Wilayah Persekutuan, Malaysia.</p>\n<p>By accessing THE SITE, you confirm your understanding of the TERMS AND CONDITIONS. If you do not agree to these TERMS AND CONDITIONS of use, you shall not use THE SITE. THE SITE reserves the right, to change, modify, add, or remove portions of these TERMS AND CONDITIONS at any time. Changes will be effective when posted on THE SITE with no other notice provided. Please check these TERMS AND CONDITIONS regularly for updates. Your continued use of THE SITE following the posting of changes to these TERMS AND CONDITIONS constitutes your acceptance of those changes.</p>\n<h2>USE OF THE SITE</h2>\n<p>A&amp;O grants you a non-transferable and revocable license to use THE SITE, under the TERMS AND CONDITIONS described, for the purpose of shopping for personal items sold on THE SITE. Commercial use or use on behalf of any third party is prohibited, except as explicitly permitted by A&amp;O in advance. Any breach of these TERMS AND CONDITIONS shall result in the immediate revocation of the license granted in this paragraph without notice to you.</p>\n<p>Content provided on this site is solely for informational purposes. Product representations expressed on THE SITE are those of the vendors DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS and are not made by A&amp;O. Submissions or opinions expressed on THE SITE are those of the individual posting such content and may not reflect our opinions.</p>\n<p>Certain services and related features that may be made available on THE SITE may require registration or subscription. Should you choose to register or subscribe for any such services or related features, you agree to provide accurate and current information about yourself, and to promptly update such information if there are any changes. Every user of THE SITE is solely responsible for keeping passwords and other account identifiers safe and secure. The account owner is entirely responsible for all activities that occur under such password or account. Furthermore, you must notify us of any unauthorized use of your password or account. THE SITE shall not be responsible or liable, directly or indirectly, in any way for any loss or damage of any kind incurred as a result of, or in connection with, your failure to comply with this section.</p>\n<h2>USER SUBMISSIONS</h2>\n<p>Anything that you submit to THE SITE and/or provide to us, including but not limited to, questions, reviews, comments, and suggestions (collectively, SUBMISSION(S)) will become our sole and exclusive property and shall not be returned to you. In addition to the rights applicable to any SUBMISSION, when you post comments or reviews to THE SITE, you also grant A&amp;O the right to use the name that you submit, in connection with such review, comment, or other content. You shall not use a false e-mail address, pretend to be someone other than yourself or otherwise mislead A&amp;O or third parties as to the origin of any Submissions. A&amp;O may, but shall not be obligated to, remove or edit any SUBMISSIONS.</p>\n<h2>ORDER ACCEPTANCE AND PRICING</h2>\n<p>Please note that there are cases when an order cannot be processed for various reasons. THE SITE reserves the right to refuse or cancel any order for any reason at any given time. You may be asked to provide additional verifications or information, including but not limited to phone number and address, before A&amp;O accept the order.</p>\n<p>A&amp;O are determined to provide the most accurate pricing information on THE SITE to THE SITE\'s users; however, errors may still occur, such as cases when the price of an item is not displayed correctly on THE SITE. As such, A&amp;O reserve the right to refuse or cancel any order. In the event that an item is mispriced, A&amp;O may, at their own discretion, either contact you for instructions or cancel your order and notify you of such cancellation. A&amp;O shall have the right to refuse or cancel any such orders whether or not the order has been confirmed and your credit card or bank account charged.</p>\n<h2>GST</h2>\n<p>GST is implemented in Malaysia with effect from 1 April 2015 at the rate of 6%. Prices of Items and services provided by A&amp;O, being GST registered company, will include GST where applicable.</p>\n<p>Please refer to the GST Act 2014 published in the gazette on 19 June 2014 and the GST Regulations 2014 issued on 30 June 2014. GST is under the jurisdiction of the Royal Malaysian Customs Department (“Customs Department”).</p>\n<h2>TRADEMARKS AND COPYRIGHTS</h2>\n<p>All intellectual property rights, whether registered or unregistered, in THE SITE, information content on THE SITE and all the website design, including, but not limited to, text, graphics, software, photos, video, music, sound, and their selection and arrangement, and all software compilations, underlying source code and software shall remain A&amp;O property. The entire contents of THE SITE also are protected by copyright as a collective work under Malaysia copyright laws and international conventions. All rights are reserved.</p>\n<h2>APPLICABLE LAW AND JURISDICTION</h2>\n<p>These TERMS AND CONDITIONS shall be interpreted and governed by the laws in force in Malaysia. Subject to the Arbitration section below, each party hereby agrees to submit to the jurisdiction of the courts of Government of Malaysia to waive any objections based upon venue.</p>\n<h2>ARBITRATION</h2>\n<p>Any controversy, claim or dispute arising out of or relating to these TERMS AND CONDITIONS will be referred to and finally settled by private and confidential binding arbitration before a single arbitrator held in Malaysia in English and governed by Malaysian law. The arbitrator shall be a person who is legally trained and who has experience in the information technology field in Malaysia and is independent of either party. Notwithstanding the foregoing, the Site reserves the right to pursue the protection of intellectual property rights and confidential information through injunctive or other equitable relief through the courts.</p>\n<h2>TERMINATION</h2>\n<p>In addition to any other legal or equitable remedies, A&amp;O may, without prior notice to you, immediately terminate the TERMS AND CONDITIONS or revoke any or all of your rights granted under the TERMS AND CONDITIONS. Upon any termination of this Agreement, you shall immediately cease all access to and use of THE SITE and A&amp;O shall, in addition to any other legal or equitable remedies, immediately revoke all password(s) and account identification issued to you and deny your access to and use of THE SITE in whole or in part. Any termination of this agreement shall not affect the respective rights and obligations (including without limitation, payment obligations) of the parties arising before the date of termination. You furthermore agree that THE SITE shall not be liable to you or to any other person as a result of any such suspension or termination. If you are dissatisfied with THE SITE or with any terms, conditions, rules, policies, guidelines, or practices of A&amp;O in operating THE SITE, your sole and exclusive remedy is to discontinue using THE SITE.</p>\n<h2>1. Interpretation</h2>\n<p>1.1 In these TERMS AND CONDITIONS:</p>\n<p>BUYER means the person who accepts a quotation of A&amp;O for the supply of GOODS</p>\n<p>CONTRACT means the contract for the purchase and sale of GOODS, howsoever formed or concluded;</p>\n<p>GOODS means the goods or services (including any instalment of the goods or any parts for them) which A&amp;O is to supply in accordance with a CONTRACT;</p>\n<p>WRITING includes electronic mail facsimile transmission and any comparable means of communication.</p>\n<p>1.2 Any reference in these TERMS AND CONDITIONS to any provision of a statute shall be construed as a reference to that provision as amended re-enacted or extended at the relevant time.</p>\n<p>1.3 The headings in these TERMS AND CONDITIONS are for convenience only and shall not affect the interpretation of any parties.</p>\n<h2>2. Basis of the Contract</h2>\n<p>2.1 The supply of GOODS by A&amp;O to the BUYER under any CONTRACT shall be subjected to these TERMS AND CONDITIONS which shall govern the CONTRACT to the exclusion of any other terms and conditions contained or referred to in any documentation submitted by the BUYER or in correspondence or elsewhere or implied by trade custom practice or course of dealing.</p>\n<p>2.2 Any information made available in THE SITE in connection with the supply of GOODS, including photographs, drawings, data about the extent of the delivery, appearance, performance, dimensions, weight, consumption of operating materials, operating costs, are not binding and for information purposes only. In entering into the CONTRACT the BUYER acknowledges that it does not rely on and waives any claim based on any such representations or information not so confirmed.</p>\n<p>2.3 No variation to these TERMS AND CONDITIONS shall be binding unless agreed in writing between the authorised representatives of the BUYER and A&amp;O.</p>\n<p>2.4 Any typographical clerical or other error or omission in any quotation, invoice or other document or information issued by A&amp;O in THE SITE shall be subject to correction without any liability on the part of A&amp;O.</p>\n<h2>3. Orders and Specifications</h2>\n<p>3.1 Order acceptance and completion of the contract between the BUYER and A&amp;O will only be completed upon A&amp;O issuing a confirmation of dispatch of the GOODS to the BUYER. For the avoidance of doubt, A&amp;O shall be entitled to refuse or cancel any order without giving any reasons for the same to the BUYER prior to issue of the confirmation of dispatch. A&amp;O shall furthermore be entitled to require the BUYER to furnish A&amp;O with contact and other verification information, including but not limited to address, contact numbers prior to issuing a confirmation of dispatch.</p>\n<p>3.2 No concluded CONTRACT may be modified or cancelled by the BUYER except with the agreement in writing of A&amp;O and on terms that the BUYER shall indemnify A&amp;O in full against all loss (including loss of profit) costs (including the cost of all labour and materials used) damages charges and expenses incurred by A&amp;O as a result of the modification or cancellation, as the case may be.</p>\n<h2>4. Price</h2>\n<p>The price of the GOODS shall be the price stated in THE SITE at the time which the BUYER makes its offer purchase to A&amp;O. The price excludes the cost of packaging and delivery charges, any applicable goods and services tax, value added tax or similar tax which the BUYER shall be liable to pay to A&amp;O in addition to the price.</p>\n<h2>5. Terms of Payment</h2>\n<p>5.1 The BUYER shall be entitled to make payment for the GOODS pursuant to the various payment methods set out in THE SITE. The TERMS AND CONDITIONS applicable to each type of payment, as contained in THE SITE, shall be applicable to the CONTRACT.</p>\n<p>5.2 In addition to any additional terms contained in THE SITE, the following terms shall also apply to the following types of payment when made available in THE SITE :</p>\n<p><strong>5.2.1 Credit Card</strong></p>\n<p>Credit Card payment option is available for all BUYERS. A&amp;O accepts all Visa and MasterCards, both Credit and Debit, and is 3D Secure (Verified by Visa, and MasterCard Secure) enabled. All your credit card information are protected by means of industry- leading encryption standards.</p>\n<p>Please take note that additional charges may be incurred if you are using a non-Malaysian issues card due to Foreign Exchange.</p>\n<p><strong>5.2.2 Debit Cards</strong></p>\n<p>A&amp;O accepts all Malaysian Visa and MasterCard debit cards where subject to bank availability. All debit card numbers shall be protected by means of industry-leading encryption standards.</p>\n<p><strong>5.2.3 Online Banking</strong></p>\n<p>i. By choosing this payment method, the BUYER shall transfer the payment for the GOODS to A&amp;O’s account for the total amount of the BUYER’s purchase (including any applicable taxes, fees and shipping costs). The transaction must be payable in Ringgit Malaysia. A&amp;O, in its sole discretion, may refuse this payment option service to anyone or any user without notice for any reason at any time.</p>\n<p>ii. For the time being, A&amp;O accepts online bank transfers from AmBank, Bank Islam, CIMB Bank, Hong Leong, Maybank, Public Bank, RHB.</p>\n<h2>6. Delivery/Performance</h2>\n<p>6.1 Delivery of the GOODS shall be made to the address specified by the BUYER in its order.</p>\n<p>6.2 A&amp;O has the right at any time to sub-contract all or any of its obligations for the sale/delivery of the GOODS to any other party as it may from time to time decide without giving notice of the same to the BUYER.</p>\n<p>6.3 Any dates quoted for delivery of the GOODS are approximate only. The time for delivery/performance shall not be of the essence, and A&amp;O shall not be liable for any delay in deliv-ery or performance howsoever caused.</p>\n<p>6.4 If A&amp;O has failed to deliver the GOODS in accordance with the CONTRACT or within a reasonable time, the BUYER shall be entitled, by serving written notice to A&amp;O, to demand performance within a specified time thereafter, which shall be at least 14 days for Peninsula Malaysia and 28 days for Eastern Malaysia. If A&amp;O fails to do so within the specified time, the BUYER shall be entitled to terminate the CONTRACT in respect of the undelivered GOODS and claim compensation for actual loss and expense sustained as a result of A&amp;O’s non-performance, which was foreseeable at the time of conclusion of the CONTRACT and resulting from the usual course of events, subject always to the limitations set out in Condition 12.4.</p>\n<p>6.5 If the BUYER fails to take delivery of the GOODS (otherwise than by reason of any cause beyond the BUYER\'s reasonable control or by reason of A&amp;O\'s fault) then without prejudice to any other right or remedy available to A&amp;O, A&amp;O may:</p>\n<p>6.5.1 sell the GOODS at the best price readily obtainable and (after deducting all reasonable storage and selling expenses) account to the BUYER for the excess over the price under the CONTRACT provided the price has been paid in cleared funds in full or charge the BUYER for any shortfall below the price under the CONTRACT; or</p>\n<p>6.5.2 terminate the CONTRACT and claim damages.</p>\n<h2>7. Risk and property of the Goods</h2>\n<p>7.1 Risk of damage to or loss of the GOODS shall pass to the BUYER at the time of delivery or if the BUYER wrongfully fails to take delivery of the GOODS, the time when A&amp;O has tendered delivery of the GOODS.</p>\n<p>7.2 Notwithstanding delivery and the passing of risk in the GOODS or any other provision of these TERMS AND CONDITIONS the property in the GOODS shall not pass to the BUYER until A&amp;O has received in cash or cleared funds payment in full of the price of the GOODS and all other GOODS agreed to be sold by A&amp;O to the BUYER for which payment is then due.</p>\n<p>7.3 Until such time as the property in the GOODS passes to the BUYER, the BUYER shall hold the GOODS as A&amp;O\'s fiduciary agent and bailee and shall keep the GOODS separate from those of the BUYER.</p>\n<p>7.4 The BUYER agrees with A&amp;O that the BUYER shall immediately notify A&amp;O of any matter from time to time affecting A&amp;O’s title to the GOODS and the BUYER shall provide A&amp;O with any in-formation relating to the GOODS as A&amp;O may require from time to time.</p>\n<p>7.5 Until such time as the property in the GOODS passes to the BUYER (and provided the GOODS are still in existence and have not been resold) A&amp;O shall be entitled at any time to demand the BUYER to deliver up the GOODS to A&amp;O and in the event of non-compliance, A&amp;O reserves it’s right to take legal action against the BUYER for the delivery up the GOODS and also reserves its right to seek damages and all other costs including but not limited to legal fees against the BUYER.</p>\n<p>7.6 The BUYER shall not be entitled to pledge or in any way charge by way of security for any indebtedness any of the GOODS which remain the property of A&amp;O but if the BUYER does so all moneys owing by the BUYER to A&amp;O shall (without prejudice to any other right or remedy of A&amp;O) forthwith become due and payable.</p>\n<p>7.8 If the provisions in this Condition 7 are not effective according to the law of the country in which the GOODS are located, the legal concept closest in nature to retention of title in that country shall be deemed to apply mutatis mutandis to give effect to the underlying intent expressed in this condition, and the BUYER shall take all steps necessary to give effect to the same.</p>\n<p>7.9 The BUYER shall indemnify A&amp;O against all loss damages costs expenses and legal fees in-curred by the BUYER in connection with the assertion and enforcement of A&amp;O\'s rights under this condition.</p>\n<h2>8. Warranties and Remedies</h2>\n<p>8.1 Subject as expressly provided in these TERMS AND CONDITIONS all other warranties conditions or terms, including those implied by statute or common law, are excluded to the fullest extent permitted by law.</p>\n<p>8.2 Subject to this Condition 8, A&amp;O warrants that the GOODS will correspond with their specification at the time of delivery, and agrees to remedy any non-conformity therein for a period of 12 months commencing from the date on which the GOODS are delivered or deemed to be delivered (\"Warranty Period\"). Where the BUYER is dealing as a consumer (within the meaning of the Sale of Goods Act and the Consumer Protection Act), A&amp;O further gives to the BUYER such implied warranties as cannot be excluded by law.</p>\n<p>8.2.1 A&amp;O’s above warranty concerning the GOODS is given subject to the following conditions:</p>\n<p>(a) No condition is made or to be implied nor is any warranty given or to be implied as to the life or wear of the GOODS supplied or that they will be suitable for any particular purpose or use under any specific conditions, notwithstanding that such purpose or conditions may be known or made known to A&amp;O.</p>\n<p>(b) Any description given of the GOODS is given by way of identification only and the use of such description shall not constitute a sale by description.</p>\n<p>(c) A&amp;O binds itself only to deliver GOODS in accordance with the general description under which they were sold, whether or not any special or particular description shall have been given or shall be implied by law. Any such special or particular description shall be taken only as the expression of A&amp;O\'s opinion in that behalf. A&amp;O does not give any warranty as to the quality state condition or fitness of the GOODS.</p>\n<p>(d) A&amp;O shall be under no liability for the following measures and actions taken by the BUYER or third parties and the consequences thereof: improper remedy of de-fects, alteration of the GOODS without the prior agreement of A&amp;O, addition and insertion of parts, in particular of spare parts which do not come from A&amp;O.</p>\n<p>(e) A&amp;O shall be under no liability in respect of any defect arising from unsuitable or improper use, defective installation or commissioning by the BUYER or third parties, fair wear and tear, wilful damage, negligence, abnormal working conditions, defective or negligent handling, improper maintenance, excessive load, unsuitable operating materials and replacement materials, poor work, unsuitable foundation, chemical, electro-technical/electronic or electric influences, failure to follow Lazada\'s instructions (whether oral or in writing) misuse or alteration or repair of the GOODS without A&amp;O\'s approval.</p>\n<p>(f) A&amp;O is not liable for any loss damage or liability of any kind suffered by any third party directly or indirectly caused by repairs or remedial work carried out without Lazada’s prior written approval and the BUYER shall indemnify A&amp;O against each loss liability and cost arising out of such claims.</p>\n<p>(g) A&amp;O shall be under no liability under the above warranty (or any other warranty condition or guarantee) if the total price for the GOODS has not been paid in cleared funds by the due date for payment.</p>\n<p>(h) A&amp;O shall be under no liability whatsoever in respect of any defect in the GOODS arising after the expiry of the Warranty Period.</p>\n<p>8.2.2 Any claim by the BUYER which is based on any defect in the quality or condition of the GOODS or their failure to correspond with specification shall be notified to A&amp;O within seven days from the date of receipt of the GOODS or (where the defect or failure was not apparent on reasonable inspection) within a reasonable time after discovery of the defect or failure. During use, the GOODS shall be monitored constantly with regard to safety and defects. If there are even slight reservations concerning the suitability for use or the slightest reservations concerning safety, the GOODS must not be used. GOODS shall be given written notification immediately, specifying the reservations or the defect. However in no event shall the BUYER be entitled to reject the GOODS on the basis of any defect or failure, except where the failure is such that the GOODS delivered are of a fundamentally different nature than those which A&amp;O had contracted to deliver.</p>\n<p>8.2.3 If the BUYER does not give due notification to A&amp;O in accordance with the Condition 8.2.2, A&amp;O shall have no liability for any defect or failure or for any consequences re-sulting therefrom. Where any valid claim in respect of any of the GOODS which is based on any defect in the quality or condition of the GOODS or their failure to meet a specification is notified to A&amp;O in accordance with Condition 8.2.2, the non-conforming GOODS (or part thereof) will be repaired or replaced free of charge as originally ordered. Where the GOODS have not been repaired or replaced within a reasonable time, despite a written warning from the BUYER, the BUYER shall be entitled to a reduction of the price in proportion to the reduced value of the GOODS, provided that under no circumstance shall such reduction exceed 15% of the price of the affected GOODS. In lieu of repair or replacement, A&amp;O may, at its sole discretion, grant such a reduction to the BUYER. Upon a repair, replacement or price reduction being made as aforesaid, the BUYER shall have no further claim against A&amp;O.</p>\n<p>8.2.4 When A&amp;O has provided replacement GOODS or given the BUYER a refund, the non-conforming GOODS or parts thereof shall become A&amp;O’s property.</p>\n<h2>9. Force Majeure</h2>\n<p>9.1 A&amp;O shall not be liable to the BUYER or be deemed to be in breach of the CONTRACT by reason of any delay in performing or any failure to perform any of A&amp;O\'s obligations if the delay or failure was due to any cause beyond A&amp;O\'s reasonable control. Without prejudice to the generality of the foregoing the following shall be regarded as causes beyond A&amp;O\'s reasonable control:</p>\n<p>9.1.1 Act of God, explosion, flood, tempest, fire or accident;</p>\n<p>9.1.2 war or threat of war, sabotage, insurrection, civil disturbance or requisition;</p>\n<p>9.1.3 acts of restrictions, regulations, bye-laws, prohibitions or measures of any kind on the part of any governmental parliamentary or local authority;</p>\n<p>9.1.4 import or export regulations or embargoes;</p>\n<p>9.1.5 interruption of traffic, strikes, lock-outs, other industrial actions or trade disputes (whether involving employees of A&amp;O or of a third party);</p>\n<p>9.1.6 interruption of production or operation, difficulties in obtaining raw materials labour fuel parts or machinery;</p>\n<p>9.1.7 power failure or breakdown in machinery.</p>\n<p>9.2 Upon the happening of any one of the events set out in Condition 9.1 A&amp;O may at its option:-</p>\n<p>9.2.1 fully or partially suspend delivery/performance while such event or circumstances continues;</p>\n<p>9.2.2 terminate any CONTRACT so affected with immediate effect by written notice to the BUYER and A&amp;O shall not be liable for any loss or damage suffered by the BUYER as a result thereof.</p>\n<h2>10. Insolvency of Buyer</h2>\n<p>10.1 This condition applies if:</p>\n<p>10.1.1 the BUYER makes any voluntary arrangement with its creditors or becomes subject to an administration order or (being an individual or firm) becomes bankrupt or (being a company) goes into liquidation (otherwise than for the purposes of amalgamation or reconstruction); or</p>\n<p>10.1.2 an encumbrancer takes possession or a receiver is appointed of any of the property or assets of the BUYER; or</p>\n<p>10.1.3 the BUYER ceases - or threatens to cease - to carry on business; or</p>\n<p>10.1.4 A&amp;O reasonably apprehends that any of the events mentioned above is about to occur in relation to the BUYER and notifies the BUYER accordingly.</p>\n<p>10.2 If this condition applies then without prejudice to any other right or remedy available to A&amp;O, A&amp;O shall be entitled to cancel the CONTRACT or suspend any further delivery/performance under the CONTRACT without any liability to the BUYER and if GOODS have been delivered but not paid for the price shall become immediately due and payable notwithstanding any previous agreement or arrangement to the contrary.</p>\n<h2>11. Notices</h2>\n<p>Any notice required or permitted to be given by either party to the other under these TERMS AND CONDITIONS shall be in writing addressed, if to A&amp;O, to the following address : A&amp;O Distribution Sdn Bhd, No. 3A32 Level 4 Block A, Kelana Centre Point, Jalan SS 7/19, 47301 Petaling Jaya, Selangor, Malaysia and if to the Buyer, to the address stipulated in the relevant offer to purchase.</p>\n<h2>12. Liability</h2>\n<p>12.1 A&amp;O shall accept liability to the BUYER for death or injury resulting from its own or that of its employees\' negligence. Save as aforesaid, A&amp;O’s liability under or in connection with the CONTRACT shall be subject to the limitations set out in this Condition 12.</p>\n<p>12.2 A&amp;O shall be under no liability whatsoever where this arises from a reason beyond its reasonable control as provided in Condition 9 or from an act or default of the BUYER.</p>\n<p>12.3 In no event shall A&amp;O be liable for loss of profit or goodwill, loss of production or revenue or any type of special indirect or consequential loss whatsoever (including loss or damage suffered by the BUYER as a result of an action brought by a third party) even if such loss were reasonably foreseeable or A&amp;O had been advised of the possibility of the BUYER incurring the same.</p>\n<p>12.4 Where time of performance has been agreed by A&amp;O becomes the essence of the CONTRACT by means of notice by the BUYER to A&amp;O, as provided for in Clause 6.4, and A&amp;O fails to comply with its obligations in due time, so that the BUYER becomes entitled to compensation in accordance with Condition 6.4, A&amp;O’s liability shall be limited to an amount of ½% for each full week of delay, in total to a maximum cumulative amount of 5%, of the value of the delayed GOODS.</p>\n<p>12.5 The remedies set out in Condition 8 are the BUYER’s sole and exclusive remedies for non-conformity of or defects in the GOODSand A&amp;O’s liability for the same shall be limited in the manner specified in Condition 8.</p>\n<p>12.6 Without prejudice to the sub-limits of liability applicable under this Condition 12 or elsewhere in these Conditions, A&amp;O’s maximum and cumulative total liability (including any liability for acts and omissions of its employees agents and sub-contractors) in respect of any and all claims for defective performance, breach of CONTRACT, compensation, indemnity, tort, misrepresentation, negligence at law or equity and any other damages or losses which may arise in connection with its performance or non-performance under the CONTRACT, shall not exceed the total CONTRACT price.</p>\n<p>12.7 If a number of events give rise substantially to the same loss they shall be regarded as giving rise to only one claim under these TERMS AND CONDITIONS.</p>\n<p>12.8 No action shall be brought by A&amp;O later than 12 months after the date it became aware of the circumstances giving rise to a claim or the date when it ought reasonably to have become aware, and in any event, no later than 12 months after the end of the Warranty Period.</p>\n<h2>13. Termination</h2>\n<p>13.1 On or at any time after the occurrence of any of the events in condition 13.2 A&amp;O may stop any GOODS in transit, suspend further deliveries to the BUYER and exercise its rights under Condition 7 and/or terminate the CONTRACT with the BUYER with immediate effect by written notice to the BUYER.</p>\n<p>13.2 The events are:-</p>\n<p>13.2.1 the BUYER being in breach of an obligation under the CONTRACT;</p>\n<p>13.2.2 the BUYER passing a resolution for its winding up or a court of competent jurisdiction making an order for the BUYER’s winding up or dissolution;</p>\n<p>13.2.3 the making of an administration order in relation to the BUYER or the appointment of a receiver over or an encumbrancer taking possession of or selling any of the BUYER’s assets;</p>\n<p>13.4. the BUYER making an arrangement or composition with its creditors generally or applying to a Court of competent jurisdiction for protection from its creditors.</p>\n<h2>14. General</h2>\n<p>14.1 Unless the context otherwise requires, any term or expression which is defined in or given a particular meaning by the provisions of Incoterms shall have the same meaning in these TERMS AND CONDITIONS but if there is any conflict between the provisions of Incoterms and these TERMS AND CONDITIONS, the latter shall prevail.</p>\n<p>14.2 No waiver by A&amp;O of any breach of the CONTRACT by the BUYER shall be considered as a waiver of any subsequent breach of the same or any other provision.</p>\n<p>14.3 If any provision of these TERMS AND CONDITIONSs is held by any competent authority to be invalid or unenforceable in whole or in part the validity of the other provisions of these TERMS AND CONDITIONS and the remainder of the provision in question shall not be affected thereby.</p>\n<p>14.4 No person who is not a party to this CONTRACT (including any employee officer agent representative or sub-contractor of either party) shall have any right under the Contracts (Rights of Third Parties) Act to enforce any terms of this CONTRACT which expressly or by implication confers a benefit on that person without the express prior agreement in writing of the parties, which the agreement must refer to Condition 3.2.</p>\n<p>14.5 The CONTRACT shall be governed by the laws of Malaysia and the BUYER agrees to submit to the non-exclusive jurisdiction of the Courts in Malaysia, as provided for in Clause 14.7.</p>\n<p>14.6 Except as provided for in Clause 14.7, any dispute, controversy or claim arising out of or relating to this contract, or the breach, termination or invalidity thereof shall be settled by arbitration in accordance with the Rules for Arbitration of the Kuala Lumpur Regional Centre for Arbitration (KLR-CA). The arbitral tribunal shall consist of a sole arbitrator, to be appointed by the Chairman of the KLRCA. The place of arbitration shall be Kuala Lumpur. Any award by the arbitration tribunal shall be final and binding upon the parties.</p>\n<p>14.7 Notwithstanding Clause 14.6, A&amp;O shall be entitled to commence court legal proceedings for the purposes of protecting its intellectual property rights and confidential information by means of injunctive or other equitable relief.</p>\n<p>14.8 The United Nations Convention on Contracts for the International Sale of Goods shall not apply to any CONTRACT for the sale of GOODS.</p>\n<p>14.9 A&amp;O reserves their right to these terms and conditions of sale at any time.</p>\n<p> </p>','terms-and-conditions'),(3,2,1,'Terms and conditions','Terms and conditions','conditions, terms, use, sell','<h1 id=\"tandc\">Terms &amp; Conditions</h1>\n<h2>INTRODUCTION</h2>\n<p>Welcome to the doudoumalaysia.com.my website (THE SITE). These terms and conditions of use (TERMS AND CONDITIONS) apply to THE SITE, A&amp;O Distribution Sdn Bhd (1149679-H), and all of its divisions, subsidiaries, and affiliate operated Internet sites which reference these TERMS AND CONDITIONS. A&amp;O means A&amp;O Distribution Sdn Bhd, a company incorporated in Malaysia under registration number 1149679-H and having its registered address at No.40-2, Fraser Business Park, Jalan Metro Pudu 2, 55200, Kuala Lumpur, Wilayah Persekutuan, Malaysia.</p>\n<p>By accessing THE SITE, you confirm your understanding of the TERMS AND CONDITIONS. If you do not agree to these TERMS AND CONDITIONS of use, you shall not use THE SITE. THE SITE reserves the right, to change, modify, add, or remove portions of these TERMS AND CONDITIONS at any time. Changes will be effective when posted on THE SITE with no other notice provided. Please check these TERMS AND CONDITIONS regularly for updates. Your continued use of THE SITE following the posting of changes to these TERMS AND CONDITIONS constitutes your acceptance of those changes.</p>\n<h2>USE OF THE SITE</h2>\n<p>A&amp;O grants you a non-transferable and revocable license to use THE SITE, under the TERMS AND CONDITIONS described, for the purpose of shopping for personal items sold on THE SITE. Commercial use or use on behalf of any third party is prohibited, except as explicitly permitted by A&amp;O in advance. Any breach of these TERMS AND CONDITIONS shall result in the immediate revocation of the license granted in this paragraph without notice to you.</p>\n<p>Content provided on this site is solely for informational purposes. Product representations expressed on THE SITE are those of the vendors DOUDOU ET COMPAGNIE and HISTOIRE D\'OURS and are not made by A&amp;O. Submissions or opinions expressed on THE SITE are those of the individual posting such content and may not reflect our opinions.</p>\n<p>Certain services and related features that may be made available on THE SITE may require registration or subscription. Should you choose to register or subscribe for any such services or related features, you agree to provide accurate and current information about yourself, and to promptly update such information if there are any changes. Every user of THE SITE is solely responsible for keeping passwords and other account identifiers safe and secure. The account owner is entirely responsible for all activities that occur under such password or account. Furthermore, you must notify us of any unauthorized use of your password or account. THE SITE shall not be responsible or liable, directly or indirectly, in any way for any loss or damage of any kind incurred as a result of, or in connection with, your failure to comply with this section.</p>\n<h2>USER SUBMISSIONS</h2>\n<p>Anything that you submit to THE SITE and/or provide to us, including but not limited to, questions, reviews, comments, and suggestions (collectively, SUBMISSION(S)) will become our sole and exclusive property and shall not be returned to you. In addition to the rights applicable to any SUBMISSION, when you post comments or reviews to THE SITE, you also grant A&amp;O the right to use the name that you submit, in connection with such review, comment, or other content. You shall not use a false e-mail address, pretend to be someone other than yourself or otherwise mislead A&amp;O or third parties as to the origin of any Submissions. A&amp;O may, but shall not be obligated to, remove or edit any SUBMISSIONS.</p>\n<h2>ORDER ACCEPTANCE AND PRICING</h2>\n<p>Please note that there are cases when an order cannot be processed for various reasons. THE SITE reserves the right to refuse or cancel any order for any reason at any given time. You may be asked to provide additional verifications or information, including but not limited to phone number and address, before A&amp;O accept the order.</p>\n<p>A&amp;O are determined to provide the most accurate pricing information on THE SITE to THE SITE\'s users; however, errors may still occur, such as cases when the price of an item is not displayed correctly on THE SITE. As such, A&amp;O reserve the right to refuse or cancel any order. In the event that an item is mispriced, A&amp;O may, at their own discretion, either contact you for instructions or cancel your order and notify you of such cancellation. A&amp;O shall have the right to refuse or cancel any such orders whether or not the order has been confirmed and your credit card or bank account charged.</p>\n<h2>GST</h2>\n<p>GST is implemented in Malaysia with effect from 1 April 2015 at the rate of 6%. Prices of Items and services provided by A&amp;O, being GST registered company, will include GST where applicable.</p>\n<p>Please refer to the GST Act 2014 published in the gazette on 19 June 2014 and the GST Regulations 2014 issued on 30 June 2014. GST is under the jurisdiction of the Royal Malaysian Customs Department (“Customs Department”).</p>\n<h2>TRADEMARKS AND COPYRIGHTS</h2>\n<p>All intellectual property rights, whether registered or unregistered, in THE SITE, information content on THE SITE and all the website design, including, but not limited to, text, graphics, software, photos, video, music, sound, and their selection and arrangement, and all software compilations, underlying source code and software shall remain A&amp;O property. The entire contents of THE SITE also are protected by copyright as a collective work under Malaysia copyright laws and international conventions. All rights are reserved.</p>\n<h2>APPLICABLE LAW AND JURISDICTION</h2>\n<p>These TERMS AND CONDITIONS shall be interpreted and governed by the laws in force in Malaysia. Subject to the Arbitration section below, each party hereby agrees to submit to the jurisdiction of the courts of Government of Malaysia to waive any objections based upon venue.</p>\n<h2>ARBITRATION</h2>\n<p>Any controversy, claim or dispute arising out of or relating to these TERMS AND CONDITIONS will be referred to and finally settled by private and confidential binding arbitration before a single arbitrator held in Malaysia in English and governed by Malaysian law. The arbitrator shall be a person who is legally trained and who has experience in the information technology field in Malaysia and is independent of either party. Notwithstanding the foregoing, the Site reserves the right to pursue the protection of intellectual property rights and confidential information through injunctive or other equitable relief through the courts.</p>\n<h2>TERMINATION</h2>\n<p>In addition to any other legal or equitable remedies, A&amp;O may, without prior notice to you, immediately terminate the TERMS AND CONDITIONS or revoke any or all of your rights granted under the TERMS AND CONDITIONS. Upon any termination of this Agreement, you shall immediately cease all access to and use of THE SITE and A&amp;O shall, in addition to any other legal or equitable remedies, immediately revoke all password(s) and account identification issued to you and deny your access to and use of THE SITE in whole or in part. Any termination of this agreement shall not affect the respective rights and obligations (including without limitation, payment obligations) of the parties arising before the date of termination. You furthermore agree that THE SITE shall not be liable to you or to any other person as a result of any such suspension or termination. If you are dissatisfied with THE SITE or with any terms, conditions, rules, policies, guidelines, or practices of A&amp;O in operating THE SITE, your sole and exclusive remedy is to discontinue using THE SITE.</p>\n<h2>1. Interpretation</h2>\n<p>1.1 In these TERMS AND CONDITIONS:</p>\n<p>BUYER means the person who accepts a quotation of A&amp;O for the supply of GOODS</p>\n<p>CONTRACT means the contract for the purchase and sale of GOODS, howsoever formed or concluded;</p>\n<p>GOODS means the goods or services (including any instalment of the goods or any parts for them) which A&amp;O is to supply in accordance with a CONTRACT;</p>\n<p>WRITING includes electronic mail facsimile transmission and any comparable means of communication.</p>\n<p>1.2 Any reference in these TERMS AND CONDITIONS to any provision of a statute shall be construed as a reference to that provision as amended re-enacted or extended at the relevant time.</p>\n<p>1.3 The headings in these TERMS AND CONDITIONS are for convenience only and shall not affect the interpretation of any parties.</p>\n<h2>2. Basis of the Contract</h2>\n<p>2.1 The supply of GOODS by A&amp;O to the BUYER under any CONTRACT shall be subjected to these TERMS AND CONDITIONS which shall govern the CONTRACT to the exclusion of any other terms and conditions contained or referred to in any documentation submitted by the BUYER or in correspondence or elsewhere or implied by trade custom practice or course of dealing.</p>\n<p>2.2 Any information made available in THE SITE in connection with the supply of GOODS, including photographs, drawings, data about the extent of the delivery, appearance, performance, dimensions, weight, consumption of operating materials, operating costs, are not binding and for information purposes only. In entering into the CONTRACT the BUYER acknowledges that it does not rely on and waives any claim based on any such representations or information not so confirmed.</p>\n<p>2.3 No variation to these TERMS AND CONDITIONS shall be binding unless agreed in writing between the authorised representatives of the BUYER and A&amp;O.</p>\n<p>2.4 Any typographical clerical or other error or omission in any quotation, invoice or other document or information issued by A&amp;O in THE SITE shall be subject to correction without any liability on the part of A&amp;O.</p>\n<h2>3. Orders and Specifications</h2>\n<p>3.1 Order acceptance and completion of the contract between the BUYER and A&amp;O will only be completed upon A&amp;O issuing a confirmation of dispatch of the GOODS to the BUYER. For the avoidance of doubt, A&amp;O shall be entitled to refuse or cancel any order without giving any reasons for the same to the BUYER prior to issue of the confirmation of dispatch. A&amp;O shall furthermore be entitled to require the BUYER to furnish A&amp;O with contact and other verification information, including but not limited to address, contact numbers prior to issuing a confirmation of dispatch.</p>\n<p>3.2 No concluded CONTRACT may be modified or cancelled by the BUYER except with the agreement in writing of A&amp;O and on terms that the BUYER shall indemnify A&amp;O in full against all loss (including loss of profit) costs (including the cost of all labour and materials used) damages charges and expenses incurred by A&amp;O as a result of the modification or cancellation, as the case may be.</p>\n<h2>4. Price</h2>\n<p>The price of the GOODS shall be the price stated in THE SITE at the time which the BUYER makes its offer purchase to A&amp;O. The price excludes the cost of packaging and delivery charges, any applicable goods and services tax, value added tax or similar tax which the BUYER shall be liable to pay to A&amp;O in addition to the price.</p>\n<h2>5. Terms of Payment</h2>\n<p>5.1 The BUYER shall be entitled to make payment for the GOODS pursuant to the various payment methods set out in THE SITE. The TERMS AND CONDITIONS applicable to each type of payment, as contained in THE SITE, shall be applicable to the CONTRACT.</p>\n<p>5.2 In addition to any additional terms contained in THE SITE, the following terms shall also apply to the following types of payment when made available in THE SITE :</p>\n<p><strong>5.2.1 Credit Card</strong></p>\n<p>Credit Card payment option is available for all BUYERS. A&amp;O accepts all Visa and MasterCards, both Credit and Debit, and is 3D Secure (Verified by Visa, and MasterCard Secure) enabled. All your credit card information are protected by means of industry- leading encryption standards.</p>\n<p>Please take note that additional charges may be incurred if you are using a non-Malaysian issues card due to Foreign Exchange.</p>\n<p><strong>5.2.2 Debit Cards</strong></p>\n<p>A&amp;O accepts all Malaysian Visa and MasterCard debit cards where subject to bank availability. All debit card numbers shall be protected by means of industry-leading encryption standards.</p>\n<p><strong>5.2.3 Online Banking</strong></p>\n<p>i. By choosing this payment method, the BUYER shall transfer the payment for the GOODS to A&amp;O’s account for the total amount of the BUYER’s purchase (including any applicable taxes, fees and shipping costs). The transaction must be payable in Ringgit Malaysia. A&amp;O, in its sole discretion, may refuse this payment option service to anyone or any user without notice for any reason at any time.</p>\n<p>ii. For the time being, A&amp;O accepts online bank transfers from AmBank, Bank Islam, CIMB Bank, Hong Leong, Maybank, Public Bank, RHB.</p>\n<h2>6. Delivery/Performance</h2>\n<p>6.1 Delivery of the GOODS shall be made to the address specified by the BUYER in its order.</p>\n<p>6.2 A&amp;O has the right at any time to sub-contract all or any of its obligations for the sale/delivery of the GOODS to any other party as it may from time to time decide without giving notice of the same to the BUYER.</p>\n<p>6.3 Any dates quoted for delivery of the GOODS are approximate only. The time for delivery/performance shall not be of the essence, and A&amp;O shall not be liable for any delay in deliv-ery or performance howsoever caused.</p>\n<p>6.4 If A&amp;O has failed to deliver the GOODS in accordance with the CONTRACT or within a reasonable time, the BUYER shall be entitled, by serving written notice to A&amp;O, to demand performance within a specified time thereafter, which shall be at least 14 days for Peninsula Malaysia and 28 days for Eastern Malaysia. If A&amp;O fails to do so within the specified time, the BUYER shall be entitled to terminate the CONTRACT in respect of the undelivered GOODS and claim compensation for actual loss and expense sustained as a result of A&amp;O’s non-performance, which was foreseeable at the time of conclusion of the CONTRACT and resulting from the usual course of events, subject always to the limitations set out in Condition 12.4.</p>\n<p>6.5 If the BUYER fails to take delivery of the GOODS (otherwise than by reason of any cause beyond the BUYER\'s reasonable control or by reason of A&amp;O\'s fault) then without prejudice to any other right or remedy available to A&amp;O, A&amp;O may:</p>\n<p>6.5.1 sell the GOODS at the best price readily obtainable and (after deducting all reasonable storage and selling expenses) account to the BUYER for the excess over the price under the CONTRACT provided the price has been paid in cleared funds in full or charge the BUYER for any shortfall below the price under the CONTRACT; or</p>\n<p>6.5.2 terminate the CONTRACT and claim damages.</p>\n<h2>7. Risk and property of the Goods</h2>\n<p>7.1 Risk of damage to or loss of the GOODS shall pass to the BUYER at the time of delivery or if the BUYER wrongfully fails to take delivery of the GOODS, the time when A&amp;O has tendered delivery of the GOODS.</p>\n<p>7.2 Notwithstanding delivery and the passing of risk in the GOODS or any other provision of these TERMS AND CONDITIONS the property in the GOODS shall not pass to the BUYER until A&amp;O has received in cash or cleared funds payment in full of the price of the GOODS and all other GOODS agreed to be sold by A&amp;O to the BUYER for which payment is then due.</p>\n<p>7.3 Until such time as the property in the GOODS passes to the BUYER, the BUYER shall hold the GOODS as A&amp;O\'s fiduciary agent and bailee and shall keep the GOODS separate from those of the BUYER.</p>\n<p>7.4 The BUYER agrees with A&amp;O that the BUYER shall immediately notify A&amp;O of any matter from time to time affecting A&amp;O’s title to the GOODS and the BUYER shall provide A&amp;O with any in-formation relating to the GOODS as A&amp;O may require from time to time.</p>\n<p>7.5 Until such time as the property in the GOODS passes to the BUYER (and provided the GOODS are still in existence and have not been resold) A&amp;O shall be entitled at any time to demand the BUYER to deliver up the GOODS to A&amp;O and in the event of non-compliance, A&amp;O reserves it’s right to take legal action against the BUYER for the delivery up the GOODS and also reserves its right to seek damages and all other costs including but not limited to legal fees against the BUYER.</p>\n<p>7.6 The BUYER shall not be entitled to pledge or in any way charge by way of security for any indebtedness any of the GOODS which remain the property of A&amp;O but if the BUYER does so all moneys owing by the BUYER to A&amp;O shall (without prejudice to any other right or remedy of A&amp;O) forthwith become due and payable.</p>\n<p>7.8 If the provisions in this Condition 7 are not effective according to the law of the country in which the GOODS are located, the legal concept closest in nature to retention of title in that country shall be deemed to apply mutatis mutandis to give effect to the underlying intent expressed in this condition, and the BUYER shall take all steps necessary to give effect to the same.</p>\n<p>7.9 The BUYER shall indemnify A&amp;O against all loss damages costs expenses and legal fees in-curred by the BUYER in connection with the assertion and enforcement of A&amp;O\'s rights under this condition.</p>\n<h2>8. Warranties and Remedies</h2>\n<p>8.1 Subject as expressly provided in these TERMS AND CONDITIONS all other warranties conditions or terms, including those implied by statute or common law, are excluded to the fullest extent permitted by law.</p>\n<p>8.2 Subject to this Condition 8, A&amp;O warrants that the GOODS will correspond with their specification at the time of delivery, and agrees to remedy any non-conformity therein for a period of 12 months commencing from the date on which the GOODS are delivered or deemed to be delivered (\"Warranty Period\"). Where the BUYER is dealing as a consumer (within the meaning of the Sale of Goods Act and the Consumer Protection Act), A&amp;O further gives to the BUYER such implied warranties as cannot be excluded by law.</p>\n<p>8.2.1 A&amp;O’s above warranty concerning the GOODS is given subject to the following conditions:</p>\n<p>(a) No condition is made or to be implied nor is any warranty given or to be implied as to the life or wear of the GOODS supplied or that they will be suitable for any particular purpose or use under any specific conditions, notwithstanding that such purpose or conditions may be known or made known to A&amp;O.</p>\n<p>(b) Any description given of the GOODS is given by way of identification only and the use of such description shall not constitute a sale by description.</p>\n<p>(c) A&amp;O binds itself only to deliver GOODS in accordance with the general description under which they were sold, whether or not any special or particular description shall have been given or shall be implied by law. Any such special or particular description shall be taken only as the expression of A&amp;O\'s opinion in that behalf. A&amp;O does not give any warranty as to the quality state condition or fitness of the GOODS.</p>\n<p>(d) A&amp;O shall be under no liability for the following measures and actions taken by the BUYER or third parties and the consequences thereof: improper remedy of de-fects, alteration of the GOODS without the prior agreement of A&amp;O, addition and insertion of parts, in particular of spare parts which do not come from A&amp;O.</p>\n<p>(e) A&amp;O shall be under no liability in respect of any defect arising from unsuitable or improper use, defective installation or commissioning by the BUYER or third parties, fair wear and tear, wilful damage, negligence, abnormal working conditions, defective or negligent handling, improper maintenance, excessive load, unsuitable operating materials and replacement materials, poor work, unsuitable foundation, chemical, electro-technical/electronic or electric influences, failure to follow Lazada\'s instructions (whether oral or in writing) misuse or alteration or repair of the GOODS without A&amp;O\'s approval.</p>\n<p>(f) A&amp;O is not liable for any loss damage or liability of any kind suffered by any third party directly or indirectly caused by repairs or remedial work carried out without Lazada’s prior written approval and the BUYER shall indemnify A&amp;O against each loss liability and cost arising out of such claims.</p>\n<p>(g) A&amp;O shall be under no liability under the above warranty (or any other warranty condition or guarantee) if the total price for the GOODS has not been paid in cleared funds by the due date for payment.</p>\n<p>(h) A&amp;O shall be under no liability whatsoever in respect of any defect in the GOODS arising after the expiry of the Warranty Period.</p>\n<p>8.2.2 Any claim by the BUYER which is based on any defect in the quality or condition of the GOODS or their failure to correspond with specification shall be notified to A&amp;O within seven days from the date of receipt of the GOODS or (where the defect or failure was not apparent on reasonable inspection) within a reasonable time after discovery of the defect or failure. During use, the GOODS shall be monitored constantly with regard to safety and defects. If there are even slight reservations concerning the suitability for use or the slightest reservations concerning safety, the GOODS must not be used. GOODS shall be given written notification immediately, specifying the reservations or the defect. However in no event shall the BUYER be entitled to reject the GOODS on the basis of any defect or failure, except where the failure is such that the GOODS delivered are of a fundamentally different nature than those which A&amp;O had contracted to deliver.</p>\n<p>8.2.3 If the BUYER does not give due notification to A&amp;O in accordance with the Condition 8.2.2, A&amp;O shall have no liability for any defect or failure or for any consequences re-sulting therefrom. Where any valid claim in respect of any of the GOODS which is based on any defect in the quality or condition of the GOODS or their failure to meet a specification is notified to A&amp;O in accordance with Condition 8.2.2, the non-conforming GOODS (or part thereof) will be repaired or replaced free of charge as originally ordered. Where the GOODS have not been repaired or replaced within a reasonable time, despite a written warning from the BUYER, the BUYER shall be entitled to a reduction of the price in proportion to the reduced value of the GOODS, provided that under no circumstance shall such reduction exceed 15% of the price of the affected GOODS. In lieu of repair or replacement, A&amp;O may, at its sole discretion, grant such a reduction to the BUYER. Upon a repair, replacement or price reduction being made as aforesaid, the BUYER shall have no further claim against A&amp;O.</p>\n<p>8.2.4 When A&amp;O has provided replacement GOODS or given the BUYER a refund, the non-conforming GOODS or parts thereof shall become A&amp;O’s property.</p>\n<h2>9. Force Majeure</h2>\n<p>9.1 A&amp;O shall not be liable to the BUYER or be deemed to be in breach of the CONTRACT by reason of any delay in performing or any failure to perform any of A&amp;O\'s obligations if the delay or failure was due to any cause beyond A&amp;O\'s reasonable control. Without prejudice to the generality of the foregoing the following shall be regarded as causes beyond A&amp;O\'s reasonable control:</p>\n<p>9.1.1 Act of God, explosion, flood, tempest, fire or accident;</p>\n<p>9.1.2 war or threat of war, sabotage, insurrection, civil disturbance or requisition;</p>\n<p>9.1.3 acts of restrictions, regulations, bye-laws, prohibitions or measures of any kind on the part of any governmental parliamentary or local authority;</p>\n<p>9.1.4 import or export regulations or embargoes;</p>\n<p>9.1.5 interruption of traffic, strikes, lock-outs, other industrial actions or trade disputes (whether involving employees of A&amp;O or of a third party);</p>\n<p>9.1.6 interruption of production or operation, difficulties in obtaining raw materials labour fuel parts or machinery;</p>\n<p>9.1.7 power failure or breakdown in machinery.</p>\n<p>9.2 Upon the happening of any one of the events set out in Condition 9.1 A&amp;O may at its option:-</p>\n<p>9.2.1 fully or partially suspend delivery/performance while such event or circumstances continues;</p>\n<p>9.2.2 terminate any CONTRACT so affected with immediate effect by written notice to the BUYER and A&amp;O shall not be liable for any loss or damage suffered by the BUYER as a result thereof.</p>\n<h2>10. Insolvency of Buyer</h2>\n<p>10.1 This condition applies if:</p>\n<p>10.1.1 the BUYER makes any voluntary arrangement with its creditors or becomes subject to an administration order or (being an individual or firm) becomes bankrupt or (being a company) goes into liquidation (otherwise than for the purposes of amalgamation or reconstruction); or</p>\n<p>10.1.2 an encumbrancer takes possession or a receiver is appointed of any of the property or assets of the BUYER; or</p>\n<p>10.1.3 the BUYER ceases - or threatens to cease - to carry on business; or</p>\n<p>10.1.4 A&amp;O reasonably apprehends that any of the events mentioned above is about to occur in relation to the BUYER and notifies the BUYER accordingly.</p>\n<p>10.2 If this condition applies then without prejudice to any other right or remedy available to A&amp;O, A&amp;O shall be entitled to cancel the CONTRACT or suspend any further delivery/performance under the CONTRACT without any liability to the BUYER and if GOODS have been delivered but not paid for the price shall become immediately due and payable notwithstanding any previous agreement or arrangement to the contrary.</p>\n<h2>11. Notices</h2>\n<p>Any notice required or permitted to be given by either party to the other under these TERMS AND CONDITIONS shall be in writing addressed, if to A&amp;O, to the following address : A&amp;O Distribution Sdn Bhd, No. 3A32 Level 4 Block A, Kelana Centre Point, Jalan SS 7/19, 47301 Petaling Jaya, Selangor, Malaysia and if to the Buyer, to the address stipulated in the relevant offer to purchase.</p>\n<h2>12. Liability</h2>\n<p>12.1 A&amp;O shall accept liability to the BUYER for death or injury resulting from its own or that of its employees\' negligence. Save as aforesaid, A&amp;O’s liability under or in connection with the CONTRACT shall be subject to the limitations set out in this Condition 12.</p>\n<p>12.2 A&amp;O shall be under no liability whatsoever where this arises from a reason beyond its reasonable control as provided in Condition 9 or from an act or default of the BUYER.</p>\n<p>12.3 In no event shall A&amp;O be liable for loss of profit or goodwill, loss of production or revenue or any type of special indirect or consequential loss whatsoever (including loss or damage suffered by the BUYER as a result of an action brought by a third party) even if such loss were reasonably foreseeable or A&amp;O had been advised of the possibility of the BUYER incurring the same.</p>\n<p>12.4 Where time of performance has been agreed by A&amp;O becomes the essence of the CONTRACT by means of notice by the BUYER to A&amp;O, as provided for in Clause 6.4, and A&amp;O fails to comply with its obligations in due time, so that the BUYER becomes entitled to compensation in accordance with Condition 6.4, A&amp;O’s liability shall be limited to an amount of ½% for each full week of delay, in total to a maximum cumulative amount of 5%, of the value of the delayed GOODS.</p>\n<p>12.5 The remedies set out in Condition 8 are the BUYER’s sole and exclusive remedies for non-conformity of or defects in the GOODSand A&amp;O’s liability for the same shall be limited in the manner specified in Condition 8.</p>\n<p>12.6 Without prejudice to the sub-limits of liability applicable under this Condition 12 or elsewhere in these Conditions, A&amp;O’s maximum and cumulative total liability (including any liability for acts and omissions of its employees agents and sub-contractors) in respect of any and all claims for defective performance, breach of CONTRACT, compensation, indemnity, tort, misrepresentation, negligence at law or equity and any other damages or losses which may arise in connection with its performance or non-performance under the CONTRACT, shall not exceed the total CONTRACT price.</p>\n<p>12.7 If a number of events give rise substantially to the same loss they shall be regarded as giving rise to only one claim under these TERMS AND CONDITIONS.</p>\n<p>12.8 No action shall be brought by A&amp;O later than 12 months after the date it became aware of the circumstances giving rise to a claim or the date when it ought reasonably to have become aware, and in any event, no later than 12 months after the end of the Warranty Period.</p>\n<h2>13. Termination</h2>\n<p>13.1 On or at any time after the occurrence of any of the events in condition 13.2 A&amp;O may stop any GOODS in transit, suspend further deliveries to the BUYER and exercise its rights under Condition 7 and/or terminate the CONTRACT with the BUYER with immediate effect by written notice to the BUYER.</p>\n<p>13.2 The events are:-</p>\n<p>13.2.1 the BUYER being in breach of an obligation under the CONTRACT;</p>\n<p>13.2.2 the BUYER passing a resolution for its winding up or a court of competent jurisdiction making an order for the BUYER’s winding up or dissolution;</p>\n<p>13.2.3 the making of an administration order in relation to the BUYER or the appointment of a receiver over or an encumbrancer taking possession of or selling any of the BUYER’s assets;</p>\n<p>13.4. the BUYER making an arrangement or composition with its creditors generally or applying to a Court of competent jurisdiction for protection from its creditors.</p>\n<h2>14. General</h2>\n<p>14.1 Unless the context otherwise requires, any term or expression which is defined in or given a particular meaning by the provisions of Incoterms shall have the same meaning in these TERMS AND CONDITIONS but if there is any conflict between the provisions of Incoterms and these TERMS AND CONDITIONS, the latter shall prevail.</p>\n<p>14.2 No waiver by A&amp;O of any breach of the CONTRACT by the BUYER shall be considered as a waiver of any subsequent breach of the same or any other provision.</p>\n<p>14.3 If any provision of these TERMS AND CONDITIONSs is held by any competent authority to be invalid or unenforceable in whole or in part the validity of the other provisions of these TERMS AND CONDITIONS and the remainder of the provision in question shall not be affected thereby.</p>\n<p>14.4 No person who is not a party to this CONTRACT (including any employee officer agent representative or sub-contractor of either party) shall have any right under the Contracts (Rights of Third Parties) Act to enforce any terms of this CONTRACT which expressly or by implication confers a benefit on that person without the express prior agreement in writing of the parties, which the agreement must refer to Condition 3.2.</p>\n<p>14.5 The CONTRACT shall be governed by the laws of Malaysia and the BUYER agrees to submit to the non-exclusive jurisdiction of the Courts in Malaysia, as provided for in Clause 14.7.</p>\n<p>14.6 Except as provided for in Clause 14.7, any dispute, controversy or claim arising out of or relating to this contract, or the breach, termination or invalidity thereof shall be settled by arbitration in accordance with the Rules for Arbitration of the Kuala Lumpur Regional Centre for Arbitration (KLR-CA). The arbitral tribunal shall consist of a sole arbitrator, to be appointed by the Chairman of the KLRCA. The place of arbitration shall be Kuala Lumpur. Any award by the arbitration tribunal shall be final and binding upon the parties.</p>\n<p>14.7 Notwithstanding Clause 14.6, A&amp;O shall be entitled to commence court legal proceedings for the purposes of protecting its intellectual property rights and confidential information by means of injunctive or other equitable relief.</p>\n<p>14.8 The United Nations Convention on Contracts for the International Sale of Goods shall not apply to any CONTRACT for the sale of GOODS.</p>\n<p>14.9 A&amp;O reserves their right to these terms and conditions of sale at any time.</p>\n<p> </p>','terms-and-conditions'),(4,1,1,'About us','Learn more about us','about us, informations','<h1 class=\"page-heading bottom-indent\">About us</h1>\n<div class=\"row\">\n<div class=\"col-xs-12 col-sm-4\">\n<div class=\"cms-block\">\n<h2 class=\"page-subheading\"><span style=\"color:#ff00ea;\">Doudou Culture</span></h2>\nBehavioural and psychological surveys agree that the doudou appears in the child’s environment between 4 and 6 months, only to disappear when they are around 6 years old. The doudou has been defined as a « transitional object » by Donald WINNICOTT, a brilliant English paediatrician and psychoanalyst. But we just have to look around us to realise that, if the doudou as a cuddly soft toy is logically less present in our adult lives, the doudou is nevertheless not completely absent. He just happens to take on other shapes!</div>\n<h3 class=\"cms-block\"><br /><span style=\"color:#e081d7;\">What is a doudou?</span></h3>\n<p class=\"cms-block\">A reassuring object, a means to comfort us when we are scared or sad, a confidant, a charitable presence ... A mix of all these, probably. And if, when we are 20, 30, 50 years old or more, we find our chewed and gnawed childhood doudou at the bottom of<br />the cupboard (but never in the bin!), it is only because we have progressively replaced it, even without realising it.</p>\n<p class=\"cms-block\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/10417623_1021968354499562_6968208309774563938_n.jpg\" alt=\"Baby and Doudou\" width=\"381\" height=\"171\" /></p>\n<p class=\"cms-block\">Sometimes, we hear people saying that the only way for them to find comfort is to eat a chocolate bar. And what about those who cannot function without their phones, who cannot spend another minute without checking their mailboxes or their Facebook accounts just to see if their friends and family think about them daily? Here is a scenario: Your loved one goes away for a few days and to fill the void or absence, you choose to wear or hold one of his / her shirts filled with his / her smell, to bed. There are even some night lights for adults which diffuse comforting sounds and lights to help us sleep peacefully.<br />Chocolates, mobile phones, T-shirts ... these are adult doudous which remind us of the impact that this transitional object has on our minds and is so vital, one way or another. We are never too old to get a Doudou...</p>\n</div>\n<div class=\"cms-box\">\n<h2 class=\"page-subheading\"><span style=\"color:#ff00ea;\">Doudou et Compagnie &amp; Histoire d\'Ours</span></h2>\n<h3><span style=\"color:#e081d7;\">Doudou et Compagnie</span></h3>\n<img src=\"http://www.doudoumalaysia.com.my/img/cms/About%20Us.jpg\" alt=\"doudou\" width=\"381\" height=\"219\" /></div>\n<div class=\"cms-box\">Since DOUDOU ET COMPAGNIE has been created in 1999, the brand has stood out in the early childhood world thanks to its avant-garde approach, which combines a perfect knowledge of toddlers’ needs with regards to their awakening process. In this demanding environment, DOUDOU ET COMPAGNIE attaches a huge importance to the safety and quality of its products that appear, understandably, as comforting to parents who want the best for their children. In 15 years, the little French company from Paris has successfully imposed its style and values in the early childhood world by perfectly mixing tradition and modernity. Playing a vital role both as a child’s accomplice and a comforting brand for parents, DOUDOU ET COMPAGNIE offers a full range of coloured, soft, interactive and original DOUDOUs. Every creation aims at one goal: to awaken the toddlers.</div>\n<span style=\"color:#ffffff;\">gg</span><br /><h3 class=\"cms-box\"><span style=\"color:#e081d7;\">Histoire d\'Ours</span></h3>\n<p><span style=\"color:#e081d7;\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/ho1.jpg\" alt=\"histoire d\'ours\" width=\"375\" height=\"180\" /></span></p>\n<div class=\"cms-box\">Inspiring and inspired, Histoire d\'Ours (Bear\'s story) has been founded more than 30 years ago, continuing a long French tradition of plush toys making. The names of the collections remind the magical and poetical world of the early childhood. The bears are obviously the best sellers of the House with a large range of size, colours and fabrics... Every parent will find among them the next best baby\'s friend.</div>\n<div class=\"cms-box\">Made with the highest car to stand the years, the Histoire d\'Ours toys will follow Baby from His /Her early age when needing a loving cuddle or a comforting hugh to His/Her teens when a trusted confident is needed to share an unbearable sadness. The Histoire d\'Ours toys have been the source of thousands of love stories from the day Baby opened the gift box and discovered His / Her new best friend.</div>\n</div>\n<div class=\"row\"> </div>\n<h2 class=\"cms-box\"><span style=\"color:#ff00e8;\">A traditional French savoir-faire</span></h2>\n<div class=\"cms-box\">Founded in 1985 by Alain Joly, the GROUPE DOUDOU ET COMPAGNIE strengths relies on a traditional French savoir-faire (know-how), famous worldwide for its quality and its innovation. From a small family business, it has since become the world leader in the doudou and cuddly toys industry. The company employs 50 people on its historical site of Taverny, in the Paris region, and makes more than EUR 15 million yearly turnover. Leader in the doudou French market (more than 40% market share) and a major player of the cuddly toys market (22% market share), DOUDOU ET COMPAGNIE has sold more than 3 million childcare products and half of them were DOUDOUs, in more than 4,000 shops worldwide.</div>\n<div class=\"cms-box\">Company’s reputation lies in a clever mix of traditional recipes spiced with a good dose of modernity. The attachment to the product quality and safety and a respect for tradition are most probably the main ingredients of this amazing success story. Every creation is designed and prototyped in Taverny nearby Paris, by a team of 10 talented and passionate designers and dressmakers who are constantly thinking and imagining tomorrow’s doudous, choosing newer and softer fabrics with trendier colours, all inspired by a mother’s daily life.</div>\n<div class=\"cms-box\">After conquering the European market where the brand is already well known, DOUDOU ET COMPAGNIE is in the process of developing newer markets in America, Japan, China, Taiwan and of course Malaysia.</div>\n<div class=\"cms-box\"> </div>\n<div class=\"cms-box\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/visuel-milieu-375x193.jpg\" alt=\"A french savoir faire\" width=\"375\" height=\"193\" /></div>\n<div class=\"cms-box\"> </div>','about-us'),(4,2,1,'About us','Learn more about us','about us, informations','<h1 class=\"page-heading bottom-indent\">About us</h1>\n<div class=\"row\">\n<div class=\"col-xs-12 col-sm-4\">\n<div class=\"cms-block\">\n<h2 class=\"page-subheading\"><span style=\"color:#ff00ea;\">Doudou Culture</span></h2>\nBehavioural and psychological surveys agree that the doudou appears in the child’s environment between 4 and 6 months, only to disappear when they are around 6 years old. The doudou has been defined as a « transitional object » by Donald WINNICOTT, a brilliant English paediatrician and psychoanalyst. But we just have to look around us to realise that, if the doudou as a cuddly soft toy is logically less present in our adult lives, the doudou is nevertheless not completely absent. He just happens to take on other shapes!</div>\n<h3 class=\"cms-block\"><br /><span style=\"color:#e081d7;\">What is a doudou?</span></h3>\n<p class=\"cms-block\">A reassuring object, a means to comfort us when we are scared or sad, a confidant, a charitable presence ... A mix of all these, probably. And if, when we are 20, 30, 50 years old or more, we find our chewed and gnawed childhood doudou at the bottom of<br />the cupboard (but never in the bin!), it is only because we have progressively replaced it, even without realising it.</p>\n<p class=\"cms-block\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/10417623_1021968354499562_6968208309774563938_n.jpg\" alt=\"Baby and Doudou\" width=\"381\" height=\"171\" /></p>\n<p class=\"cms-block\">Sometimes, we hear people saying that the only way for them to find comfort is to eat a chocolate bar. And what about those who cannot function without their phones, who cannot spend another minute without checking their mailboxes or their Facebook accounts just to see if their friends and family think about them daily? Here is a scenario: Your loved one goes away for a few days and to fill the void or absence, you choose to wear or hold one of his / her shirts filled with his / her smell, to bed. There are even some night lights for adults which diffuse comforting sounds and lights to help us sleep peacefully.<br />Chocolates, mobile phones, T-shirts ... these are adult doudous which remind us of the impact that this transitional object has on our minds and is so vital, one way or another. We are never too old to get a Doudou...</p>\n</div>\n<div class=\"cms-box\">\n<h2 class=\"page-subheading\"><span style=\"color:#ff00ea;\">Doudou et Compagnie &amp; Histoire d\'Ours</span></h2>\n<h3><span style=\"color:#e081d7;\">Doudou et Compagnie</span></h3>\n<img src=\"http://www.doudoumalaysia.com.my/img/cms/About%20Us.jpg\" alt=\"doudou\" width=\"381\" height=\"219\" /></div>\n<div class=\"cms-box\">Since DOUDOU ET COMPAGNIE has been created in 1999, the brand has stood out in the early childhood world thanks to its avant-garde approach, which combines a perfect knowledge of toddlers’ needs with regards to their awakening process. In this demanding environment, DOUDOU ET COMPAGNIE attaches a huge importance to the safety and quality of its products that appear, understandably, as comforting to parents who want the best for their children. In 15 years, the little French company from Paris has successfully imposed its style and values in the early childhood world by perfectly mixing tradition and modernity. Playing a vital role both as a child’s accomplice and a comforting brand for parents, DOUDOU ET COMPAGNIE offers a full range of coloured, soft, interactive and original DOUDOUs. Every creation aims at one goal: to awaken the toddlers.</div>\n<span style=\"color:#ffffff;\">gg</span><br /><h3 class=\"cms-box\"><span style=\"color:#e081d7;\">Histoire d\'Ours</span></h3>\n<p><span style=\"color:#e081d7;\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/ho1.jpg\" alt=\"histoire d\'ours\" width=\"375\" height=\"180\" /></span></p>\n<div class=\"cms-box\">Inspiring and inspired, Histoire d\'Ours (Bear\'s story) has been founded more than 30 years ago, continuing a long French tradition of plush toys making. The names of the collections remind the magical and poetical world of the early childhood. The bears are obviously the best sellers of the House with a large range of size, colours and fabrics... Every parent will find among them the next best baby\'s friend.</div>\n<div class=\"cms-box\">Made with the highest car to stand the years, the Histoire d\'Ours toys will follow Baby from His /Her early age when needing a loving cuddle or a comforting hugh to His/Her teens when a trusted confident is needed to share an unbearable sadness. The Histoire d\'Ours toys have been the source of thousands of love stories from the day Baby opened the gift box and discovered His / Her new best friend.</div>\n</div>\n<div class=\"row\"> </div>\n<h2 class=\"cms-box\"><span style=\"color:#ff00e8;\">A traditional French savoir-faire</span></h2>\n<div class=\"cms-box\">Founded in 1985 by Alain Joly, the GROUPE DOUDOU ET COMPAGNIE strengths relies on a traditional French savoir-faire (know-how), famous worldwide for its quality and its innovation. From a small family business, it has since become the world leader in the doudou and cuddly toys industry. The company employs 50 people on its historical site of Taverny, in the Paris region, and makes more than EUR 15 million yearly turnover. Leader in the doudou French market (more than 40% market share) and a major player of the cuddly toys market (22% market share), DOUDOU ET COMPAGNIE has sold more than 3 million childcare products and half of them were DOUDOUs, in more than 4,000 shops worldwide.</div>\n<div class=\"cms-box\">Company’s reputation lies in a clever mix of traditional recipes spiced with a good dose of modernity. The attachment to the product quality and safety and a respect for tradition are most probably the main ingredients of this amazing success story. Every creation is designed and prototyped in Taverny nearby Paris, by a team of 10 talented and passionate designers and dressmakers who are constantly thinking and imagining tomorrow’s doudous, choosing newer and softer fabrics with trendier colours, all inspired by a mother’s daily life.</div>\n<div class=\"cms-box\">After conquering the European market where the brand is already well known, DOUDOU ET COMPAGNIE is in the process of developing newer markets in America, Japan, China, Taiwan and of course Malaysia.</div>\n<div class=\"cms-box\"> </div>\n<div class=\"cms-box\"><img src=\"http://www.doudoumalaysia.com.my/img/cms/visuel-milieu-375x193.jpg\" alt=\"A french savoir faire\" width=\"375\" height=\"193\" /></div>\n<div class=\"cms-box\"> </div>','about-us'),(5,1,1,'Secure payment','Our secure payment method','secure payment, ssl, visa, mastercard, paypal','<h2>Secure payment</h2>\r\n<h3>Our secure payment</h3><p>With SSL</p>\r\n<h3>Using Visa/Mastercard/Paypal</h3><p>About this service</p>','secure-payment'),(5,2,1,'Secure payment','Our secure payment method','secure payment, ssl, visa, mastercard, paypal','<h2>Secure payment</h2>\r\n<h3>Our secure payment</h3><p>With SSL</p>\r\n<h3>Using Visa/Mastercard/Paypal</h3><p>About this service</p>','secure-payment');

--
-- Table structure for table `ps_cms_role`
--

CREATE TABLE `ps_cms_role` (
  `id_cms_role` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `id_cms` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id_cms_role`,`id_cms`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_cms_role`
--

INSERT INTO `ps_cms_role` (`id_cms_role`, `name`, `id_cms`) VALUES (2,'LEGAL_CONDITIONS',0),(6,'LEGAL_ENVIRONMENTAL',0),(1,'LEGAL_NOTICE',0),(5,'LEGAL_PRIVACY',0),(3,'LEGAL_REVOCATION',0),(4,'LEGAL_REVOCATION_FORM',0),(7,'LEGAL_SHIP_PAY',0);

--
-- Table structure for table `ps_cms_role_lang`
--

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

--
-- Dumping data for table `ps_cms_role_lang`
--

INSERT INTO `ps_cms_role_lang` (`id_cms_role`, `id_lang`, `id_shop`, `name`) VALUES (1,1,0,NULL),(1,2,0,NULL),(2,1,0,NULL),(2,2,0,NULL),(3,1,0,NULL),(3,2,0,NULL),(4,1,0,NULL),(4,2,0,NULL),(5,1,0,NULL),(5,2,0,NULL),(6,1,0,NULL),(6,2,0,NULL),(7,1,0,NULL),(7,2,0,NULL);

--
-- Table structure for table `ps_cms_shop`
--

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

--
-- Dumping data for table `ps_cms_shop`
--

INSERT INTO `ps_cms_shop` (`id_cms`, `id_shop`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1);

--
-- Table structure for table `ps_compare`
--

CREATE TABLE `ps_compare` (
  `id_compare` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_customer` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_compare`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_compare`
--


--
-- Table structure for table `ps_compare_product`
--

CREATE TABLE `ps_compare_product` (
  `id_compare` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_compare`,`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_compare_product`
--


--
-- Table structure for table `ps_condition`
--

CREATE TABLE `ps_condition` (
  `id_condition` int(11) NOT NULL AUTO_INCREMENT,
  `id_ps_condition` int(11) NOT NULL,
  `type` enum('configuration','install','sql') NOT NULL,
  `request` text,
  `operator` varchar(32) DEFAULT NULL,
  `value` varchar(64) DEFAULT NULL,
  `result` varchar(64) DEFAULT NULL,
  `calculation_type` enum('hook','time') DEFAULT NULL,
  `calculation_detail` varchar(64) DEFAULT NULL,
  `validated` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  PRIMARY KEY (`id_condition`,`id_ps_condition`)
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ps_condition`
--

INSERT INTO `ps_condition` (`id_condition`, `id_ps_condition`, `type`, `request`, `operator`, `value`, `result`, `calculation_type`, `calculation_detail`, `validated`, `date_add`, `date_upd`) VALUES (1,159,'install','','<=','90','1','time','2',1,'2015-12-31 18:23:15','2015-12-31 18:23:15'),(2,158,'install','','>=','90','1','time','2',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(3,19,'install','','>','0','1','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(4,40,'install','','>=','730','','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(5,324,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%shoppingfluxexport%\" ','==','0','0','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(6,399,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','499','174','hook','actionObjectProductAddAfter',0,'2015-12-31 18:23:16','2015-12-31 20:03:27'),(7,323,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%shoppingfluxexport%\" ','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(8,521,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%simplifycommerce%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(9,55,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','100','18','hook','actionObjectOrderAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(10,12,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','99','100','hook','actionObjectProductAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(11,39,'install','','>=','365','','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(12,56,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','1000','17','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(13,33,'sql',' 	SELECT SUM(total_paid_tax_excl / c.conversion_rate) FROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1 AND reference != \"XKBKNABJK\"','>=','20000','2162','time','1',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(14,132,'sql','SELECT count(id_configuration) FROM PREFIX_configuration WHERE `name` = \'PS_SHOP_DOMAIN\' AND value IN (\'127.0.0.1\', \'localhost\' )','==','1','0','time','1',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(15,175,'sql','SELECT count(*) FROM	 PREFIX_configuration WHERE name = \'PS_HOSTED_MODE\'','==','0','0','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(16,61,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','100','18','hook','actionObjectCustomerAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(17,428,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%authorizeaim%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(18,188,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%avalaratax%\" ','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(19,278,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%mailjet%\" ','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(20,1,'configuration','PS_REWRITING_SETTINGS','==','1','1','hook','actionAdminMetaControllerUpdate_optionsAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(21,2,'configuration','PS_SMARTY_FORCE_COMPILE','!=','2','1','hook','actionAdminPerformanceControllerSaveAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(22,3,'configuration','PS_CSS_THEME_CACHE','==','1','','hook','actionAdminPerformanceControllerSaveAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(23,4,'configuration','PS_CIPHER_ALGORITHM','==','1','1','hook','actionAdminPerformanceControllerSaveAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(24,5,'configuration','PS_MEDIA_SERVERS','==','1','','hook','actionAdminPerformanceControllerSaveAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(25,6,'sql','SELECT COUNT(distinct m.id_module) FROM PREFIX_hook h LEFT JOIN PREFIX_hook_module hm ON h.id_hook = hm.id_hook LEFT JOIN PREFIX_module m ON hm.id_module = m.id_module\r\nWHERE (h.name = \"displayPayment\" OR h.name = \"payment\") AND m.name NOT IN (\"bankwire\", \"cheque\", \"cashondelivery\")','>','0','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(26,7,'sql','SELECT COUNT(distinct m.id_module) FROM PREFIX_hook h LEFT JOIN PREFIX_hook_module hm ON h.id_hook = hm.id_hook LEFT JOIN PREFIX_module m ON hm.id_module = m.id_module\r\nWHERE (h.name = \"displayPayment\" OR h.name = \"payment\") AND m.name NOT IN (\"bankwire\", \"cheque\", \"cashondelivery\")','>','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(27,8,'sql','SELECT COUNT(*) FROM PREFIX_carrier WHERE name NOT IN (\"0\", \"My carrier\")','>','0','0','hook','actionObjectCarrierAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(28,9,'sql','SELECT COUNT(*) FROM PREFIX_carrier WHERE name NOT IN (\"0\", \"My carrier\")','>','1','0','hook','actionObjectCarrierAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(29,10,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','0','1','hook','actionObjectProductAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(30,11,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','9','10','hook','actionObjectProductAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(31,16,'configuration','PS_SHOP_PHONE','!=','0','1','hook','actionAdminStoresControllerUpdate_optionsAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(32,17,'sql','SELECT COUNT(*) FROM PREFIX_contact','>','2','2','hook','actionObjectContactAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(33,18,'sql','SELECT COUNT(*) FROM PREFIX_contact','>','4','2','hook','actionObjectContactAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(34,13,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','999','174','hook','actionObjectProductAddAfter',0,'2015-12-31 18:23:16','2015-12-31 20:03:26'),(35,14,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','9999','174','hook','actionObjectProductAddAfter',0,'2015-12-31 18:23:16','2015-12-31 20:03:26'),(36,15,'sql','SELECT COUNT(*) FROM PREFIX_product WHERE reference NOT LIKE \"demo_%\"','>','99999','174','hook','actionObjectProductAddAfter',0,'2015-12-31 18:23:16','2015-12-31 20:03:26'),(37,20,'install','','>=','7','1','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(38,21,'configuration','PS_LOGO','!=','logo.jpg','1','hook','actionAdminThemesControllerUpdate_optionsAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(39,22,'sql','SELECT COUNT(*) FROM PREFIX_theme WHERE directory != \"default\" AND directory != \"prestashop\" AND directory ! \"default-bootstrap\"','>','0','0','hook','actionObjectShopUpdateAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(40,23,'configuration','PS_LOGGED_ON_ADDONS','==','1','','time','1',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(41,24,'configuration','PS_MULTISHOP_FEATURE_ACTIVE','==','1','','hook','actionAdminPreferencesControllerUpdate_optionsAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(42,25,'sql','SELECT COUNT(*) FROM PREFIX_shop','>','1','1','hook','actionObjectShopAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(43,28,'sql','SELECT COUNT(*) FROM PREFIX_shop_group','>','1','1','hook','actionObjectShopGroupAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(44,26,'sql','SELECT COUNT(*) FROM PREFIX_shop','>','4','1','hook','actionObjectShopAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(45,27,'sql','SELECT COUNT(*) FROM PREFIX_shop_group','>','5','1','hook','actionObjectShopGroupAddAfter 	',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(46,30,'sql','SELECT COUNT(*) FROM PREFIX_carrier WHERE name NOT IN (\"0\", \"My carrier\")','>','2','0','hook','actionObjectCarrierAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(47,29,'sql','SELECT COUNT(distinct m.id_module) FROM PREFIX_hook h LEFT JOIN PREFIX_hook_module hm ON h.id_hook = hm.id_hook LEFT JOIN PREFIX_module m ON hm.id_module = m.id_module\r\nWHERE (h.name = \"displayPayment\" OR h.name = \"payment\") AND m.name NOT IN (\"bankwire\", \"cheque\", \"cashondelivery\")','>','2','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(48,31,'sql','SELECT SUM(total_paid_tax_excl / c.conversion_rate)\r\nFROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1 AND reference != \"XKBKNABJK\"','>=','200','205','hook','actionOrderStatusUpdate',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(49,32,'sql',' 	SELECT SUM(total_paid_tax_excl / c.conversion_rate) FROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1 AND reference != \"XKBKNABJK\"','>=','2000','2062','hook','actionOrderStatusUpdate',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(50,34,'sql',' 	SELECT SUM(total_paid_tax_excl / c.conversion_rate) FROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1','>=','200000','0','time','7',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(51,35,'sql',' 	SELECT SUM(total_paid_tax_excl / c.conversion_rate) FROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1','>=','2000000','0','time','7',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(52,36,'sql',' 	SELECT SUM(total_paid_tax_excl / c.conversion_rate) FROM PREFIX_orders o INNER JOIN PREFIX_currency c ON c.id_currency = o.id_currency WHERE valid = 1','>=','20000000','0','time','7',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(53,37,'install','','>=','30','1','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(54,38,'install','','>=','182','','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(55,41,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','10','10','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(56,42,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','100','118','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(57,43,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','1000','1136','time','1',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(58,44,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','10000','4108','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(59,45,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','100000','4108','time','3',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(60,46,'sql','SELECT COUNT(*) FROM PREFIX_guest','>=','1000000','636','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(61,47,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','2','2','hook','actionObjectCartAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(62,48,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','10','10','hook','actionObjectCartAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(63,49,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','100','24','hook','actionObjectCartAddAfter',0,'2015-12-31 18:23:16','2016-01-01 09:07:42'),(64,50,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','1000','23','time','1',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(65,51,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','10000','5','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(66,52,'sql','SELECT COUNT(*) FROM PREFIX_cart WHERE secure_key != \"b44a6d9efd7a0076a0fbce6b15eaf3b1\"','>=','100000','0','time','8',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(67,53,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','1','1','hook','actionObjectOrderAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(68,54,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','10','10','hook','actionObjectOrderAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(69,57,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','10000','5','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(70,58,'sql','SELECT COUNT(*) FROM ps_orders WHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\")','>=','100000','0','time','8',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(71,65,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','1','1','hook','actionObjectCustomerThreadAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(72,66,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','10','2','hook','actionObjectCustomerThreadAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(73,67,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','100','2','hook','actionObjectCustomerThreadAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(74,68,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','1000','1','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(75,69,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','10000','2','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(76,70,'sql','SELECT COUNT(*) FROM PREFIX_customer_thread','>=','100000','0','time','8',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(77,59,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','1','1','hook','actionObjectCustomerAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(78,60,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','10','10','hook','actionObjectCustomerAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(79,62,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','1000','18','time','1',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(80,63,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','10000','17','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(81,64,'sql','SELECT COUNT(*) FROM PREFIX_customer WHERE email != \"pub@prestashop.com\"','>=','100000','7','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(82,76,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"CA\",\r\n\"GL\",\r\n\"PM\",\r\n\"US\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:33'),(83,79,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"UM\",\r\n\"AS\",\r\n\"AU\",\r\n\"CK\",\r\n\"FJ\",\r\n\"FM\",\r\n\"GU\",\r\n\"KI\",\r\n\"MH,\"\r\n\"MP\",\r\n\"NC\",\r\n\"NF\",\r\n\"NR\",\r\n\"NU\",\r\n\"NZ\",\r\n\"PF\",\r\n\"PG\",\r\n\"PN\",\r\n\"PW\",\r\n\"SB\",\r\n\"TK\",\r\n\"TO\",\r\n\"TV\",\r\n\"VU\",\r\n\"WF\",\r\n\"WS\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:33'),(84,85,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"KG\",\r\n\"KZ\",\r\n\"TJ\",\r\n\"TM\",\r\n\"UZ\",\r\n\"AE\",\r\n\"AM\",\r\n\"AZ\",\r\n\"BH\",\r\n\"CY\",\r\n\"GE\",\r\n\"IL\",\r\n\"IQ\",\r\n\"IR\",\r\n\"JO\",\r\n\"KW\",\r\n\"LB\",\r\n\"OM\",\r\n\"QA\",\r\n\"SA\",\r\n\"SY\",\r\n\"TR\",\r\n\"YE\",\r\n\"AF\",\r\n\"BD\",\r\n\"BT\",\r\n\"IN\",\r\n\"IO\",\r\n\"LK\",\r\n\"MV\",\r\n\"NP\",\r\n\"PK\",\r\n\"CN\",\r\n\"HK\",\r\n\"JP\",\r\n\"KP\",\r\n\"KR\",\r\n\"MO\",\r\n\"TW\",\r\n\"MN\",\r\n\"BN\",\r\n\"CC\",\r\n\"CX\",\r\n\"ID\",\r\n\"KH\",\r\n\"LA\",\r\n\"MM\",\r\n\"MY\",\r\n\"PH\",\r\n\"SG\",\r\n\"TH\",\r\n\"TP\",\r\n\"VN\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:34'),(85,86,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"BZ\",\r\n\"CR\",\r\n\"GT\",\r\n\"HN\",\r\n\"MX\",\r\n\"NI\",\r\n\"PA\",\r\n\"SV\",\r\n\"AG\",\r\n\"AI\",\r\n\"AN\",\r\n\"AW\",\r\n\"BB\",\r\n\"BM\",\r\n\"BS\",\r\n\"CU\",\r\n\"DM\",\r\n\"DO\",\r\n\"GD\",\r\n\"GP\",\r\n\"HT\",\r\n\"JM\",\r\n\"KN\",\r\n\"KY\",\r\n\"LC\",\r\n\"MQ\",\r\n\"MS\",\r\n\"PR\",\r\n\"TC\",\r\n\"TT\",\r\n\"VC\",\r\n\"VG\",\r\n\"VI\",\r\n\"AR\",\r\n\"BO\",\r\n\"BR\",\r\n\"CL\",\r\n\"CO\",\r\n\"EC\",\r\n\"FK\",\r\n\"GF\",\r\n\"GY\",\r\n\"PE\",\r\n\"PY\",\r\n\"SR\",\r\n\"UY\",\r\n\"VE\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:34'),(86,87,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"BE\",\r\n\"DE\",\r\n\"FR\",\r\n\"FX\",\r\n\"GB\",\r\n\"IE\",\r\n\"LU\",\r\n\"MC\",\r\n\"NL\",\r\n\"IT\",\r\n\"MT\",\r\n\"SM\",\r\n\"VA\",\r\n\"AD\",\r\n\"ES\",\r\n\"GI\",\r\n\"PT\",\r\n\"BY\",\r\n\"EE\",\r\n\"LT\",\r\n\"LV\",\r\n\"MD\",\r\n\"PL\",\r\n\"UA\",\r\n\"AL\",\r\n\"BA\",\r\n\"BG\",\r\n\"GR\",\r\n\"HR\",\r\n\"MK\",\r\n\"RO\",\r\n\"SI\",\r\n\"YU\",\r\n\"RU\",\r\n\"AT\",\r\n\"CH\",\r\n\"CZ\",\r\n\"HU\",\r\n\"LI\",\r\n\"SK\",\r\n\"DK\",\r\n\"FI\",\r\n\"FO\",\r\n\"IS\",\r\n\"NO\",\r\n\"SE\",\r\n\"SJ\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:34'),(87,88,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"BI\",\r\n\"CF\",\r\n\"CG\",\r\n\"RW\",\r\n\"TD\",\r\n\"ZR\",\r\n\"DJ\",\r\n\"ER\",\r\n\"ET\",\r\n\"KE\",\r\n\"SO\",\r\n\"TZ\",\r\n\"UG\",\r\n\"KM\",\r\n\"MG\",\r\n\"MU\",\r\n\"RE\",\r\n\"SC\",\r\n\"YT\",\r\n\"AO\",\r\n\"BW\",\r\n\"LS\",\r\n\"MW\",\r\n\"MZ\",\r\n\"NA\",\r\n\"SZ\",\r\n\"ZA\",\r\n\"ZM\",\r\n\"ZW\",\r\n\"BF\",\r\n\"BJ\",\r\n\"CI\",\r\n\"CM\",\r\n\"CV\",\r\n\"GA\",\r\n\"GH\",\r\n\"GM\",\r\n\"GN\",\r\n\"GQ\",\r\n\"GW\",\r\n\"LR\",\r\n\"ML\",\r\n\"MR\",\r\n\"NE\",\r\n\"NG\",\r\n\"SL\",\r\n\"SN\",\r\n\"ST\",\r\n\"TG\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:34'),(88,89,'sql','SELECT IFNULL(id_order, 0) FROM PREFIX_orders o LEFT JOIN PREFIX_address a ON o.id_address_delivery = a.id_address LEFT JOIN PREFIX_country c ON c.id_country = a.id_country WHERE o.valid = 1 AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\" AND c.iso_code IN (\r\n\"DZ\",\r\n\"EG\",\r\n\"EH\",\r\n\"LY\",\r\n\"MA\",\r\n\"SD\",\r\n\"TN\"\r\n)','!=','0','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:16','2015-12-31 20:09:34'),(89,90,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','2','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(90,91,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','3','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(91,92,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','5','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(92,93,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','10','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(93,94,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','20','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(94,95,'sql','SELECT COUNT(*) FROM PREFIX_employee','>=','40','1','hook','actionObjectEmployeeAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(95,96,'sql','SELECT id_image FROM PREFIX_image WHERE id_image > 26','>','0','27','hook','actionObjectImageAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(96,97,'sql','SELECT COUNT(*) FROM PREFIX_image','>=','50','50','hook','actionObjectImageAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(97,98,'sql','SELECT COUNT(*) FROM PREFIX_image','>=','100','100','hook','actionObjectImageAddAfter',1,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(98,99,'sql','SELECT COUNT(*) FROM PREFIX_image','>=','1000','249','time','2',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(99,100,'sql','SELECT COUNT(*) FROM PREFIX_image','>=','10000','159','time','4',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(100,101,'sql','SELECT COUNT(*) FROM PREFIX_image','>=','50000','23','time','8',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(101,102,'sql','SELECT id_cms FROM PREFIX_cms WHERE id_cms > 5','>','0','0','hook','actionObjectCMSAddAfter',0,'2015-12-31 18:23:16','2015-12-31 18:23:16'),(102,103,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','1','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(103,104,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','10','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(104,105,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','100','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(105,107,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','500','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(106,106,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','1000','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(107,108,'sql','SELECT COUNT(*) FROM PREFIX_cart_rule','>=','5000','0','hook','actionObjectCartRuleAddAfter 	',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(108,109,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','1','0','hook','newOrder',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(109,110,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','10','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:17','2015-12-31 20:09:34'),(110,111,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','100','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:17','2015-12-31 20:09:34'),(111,113,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','1000','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:17','2015-12-31 20:09:34'),(112,114,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','5000','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:17','2015-12-31 20:09:34'),(113,112,'sql','SELECT COUNT(*) FROM PREFIX_orders o INNER JOIN PREFIX_address a ON a.id_address = o.id_address_delivery\r\nWHERE reference NOT IN (\"XKBKNABJK\", \"OHSATSERP\", \"FFATNOMMJ\", \"UOYEVOLI\", \"KHWLILZLL\") AND a.id_country != \"{config}PS_COUNTRY_DEFAULT{/config}\"','>=','10000','0','hook','actionOrderStatusUpdate',0,'2015-12-31 18:23:17','2015-12-31 20:09:34'),(114,165,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','0','1','hook','actionAdminStoresControllerSaveAfter',1,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(115,166,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','1','2','hook','actionAdminStoresControllerSaveAfter',1,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(116,167,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','4','5','hook','actionAdminStoresControllerSaveAfter',1,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(117,168,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','9','10','hook','actionAdminStoresControllerSaveAfter',1,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(118,169,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','19','10','hook','actionAdminStoresControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(119,170,'sql','SELECT COUNT(s.`id_store`) FROM PREFIX_store s WHERE `latitude` NOT IN (\'25.76500500\', \'26.13793600\', \'26.00998700\', \'25.73629600\', \'25.88674000\') AND `longitude` NOT IN (\'-80.24379700\', \'-80.13943500\', \'-80.29447200\', \'-80.24479700\', \'-80.16329200\')','>','49','10','hook','actionAdminStoresControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(120,171,'sql','SELECT COUNT(*) FROM PREFIX_webservice_account','>=','1','0','hook','actionAdminWebserviceControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(121,172,'sql','SELECT COUNT(*) FROM PREFIX_webservice_account','>=','2','0','hook','actionAdminWebserviceControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(122,173,'sql','SELECT COUNT(*) FROM PREFIX_webservice_account','>=','3','0','hook','actionAdminWebserviceControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(123,174,'sql','SELECT COUNT(*) FROM PREFIX_webservice_account','>=','4','0','hook','actionAdminWebserviceControllerSaveAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(124,320,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%shopgate%\" ','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(125,322,'configuration','SHOPGATE_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(126,375,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%shopgate%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(127,376,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%shopgate%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(128,140,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%moneybookers%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(129,326,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'MONEYBOOKERS_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'MB_PAY_TO_EMAIL \') AND ( value != \'testaccount2@moneybookers.com \'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(130,377,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%moneybookers%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(131,394,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%sofortbanking%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(132,325,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE name LIKE \'SHOPPINGFLUXEXPORT_CONFIGURATION_OK\' OR name LIKE \'SHOPPINGFLUXEXPORT_CONFIGURED\'','>=','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(133,424,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%alliance3%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(134,425,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'ALLIANCE3_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'ALLIANCE_DEMO\') AND ( value = \'0\'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(135,426,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%alliance3%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(136,427,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%alliance3%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(137,429,'configuration','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'AUTHORIZEAIM_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'AUTHORIZE_AIM_SANDBOX\') AND ( value = \'0\'))','==','2','','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(138,430,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%authorizeaim%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(139,431,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%authorizeaim%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(140,434,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%bluepay%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(141,435,'configuration','BLUEPAY_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(142,436,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%bluepay%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(143,437,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%bluepay%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(144,136,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%ebay%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(145,209,'configuration','EBAY_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(146,358,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%ebay%\" AND os.logable = 1','>=','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(147,359,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%ebay%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(148,438,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%payplug%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(149,439,'configuration','PAYPLUG_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(150,440,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%payplug%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(151,441,'sql','SELECT SUM(o.total_paid) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%payplug%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','10000','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(152,442,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%affinityitems%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(153,443,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE name LIKE \'AFFINITYITEMS_CONFIGURATION_OK\' AND value = \'1\'','==','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(154,446,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%dpdpoland%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(155,447,'configuration','DPDPOLAND_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(156,448,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%dpdpoland%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(157,449,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%dpdpoland%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','100','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(158,450,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%envoimoinscher%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(159,451,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'ENVOIMOINSCHER_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'EMC_ENV \') AND ( value != \'TEST\'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(160,452,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%envoimoinscher%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(161,453,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%envoimoinscher%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','100','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(162,454,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%klikandpay%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(163,455,'configuration','KLIKANDPAY_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(164,456,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%klikandpay%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(165,457,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%klikandpay%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(166,458,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%clickline%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(167,459,'configuration','CLICKLINE_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(168,460,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%clickline%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(169,461,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state LEFT JOIN PREFIX_carrier c ON c.id_carrier = o.id_carrier WHERE c.name like \"%clickline%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','100','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(170,462,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%cdiscount%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(171,463,'sql','SELECT 1','!=','1','1','time','100',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(172,464,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%cdiscount%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(173,465,'sql','SELECT SUM(o.total_paid) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%cdiscount%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 365 DAY)','>=','500','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(174,467,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%erpillicopresta%\"','>=','1','1','hook','actionModuleInstallAfter',1,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(175,468,'configuration','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'ERPILLICOPRESTA_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'ERP_LICENCE_VALIDITY \') AND ( value == \'1\')) OR (( name LIKE \'ERP_MONTH_FREE_ACTIVE \') AND ( value == \'0\'))','==','3','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(176,469,'sql','SELECT 1','!=','1','1','time','100',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(177,470,'sql','SELECT 1','!=','1','1','time','100',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(178,471,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%netreviews%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(179,472,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'NETREVIEWS_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'AVISVERIFIES_URLCERTIFICAT \') AND ( value IS NOT LIKE \'%preprod%\'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(180,473,'sql','SELECT 1','!=','1','1','time','100',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(181,474,'sql','SELECT 1','!=','1','1','time','100',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(182,475,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%bluesnap%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(183,476,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'BLUESNAP_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'BLUESNAP_SANDBOX \') AND ( value NOT LIKE \'%sandbox%\'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(184,477,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%bluesnap%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(185,478,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%bluesnap%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(186,479,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%desjardins%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(187,480,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'DESJARDINS_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'DESJARDINS_MODE \') AND ( value NOT LIKE \'%test%\'))','==','2','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(188,481,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%desjardins%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(189,482,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%desjardins%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(190,483,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%firstdata%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(191,484,'configuration','FIRSTDATA_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(192,485,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%firstdata%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(193,486,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%firstdata%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(194,487,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%giveit%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(195,488,'sql','GIVEIT_CONFIGURATION_OK','>=','1','0','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(196,489,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(197,490,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(198,491,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%ganalytics%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(199,492,'configuration','GANALYTICS_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(200,493,'sql','SELECT 1','!=','1','1','time','1',0,'2015-12-31 18:23:17','2015-12-31 18:23:17'),(201,494,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(202,496,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%pagseguro%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(203,497,'configuration','PAGSEGURO_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(204,498,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%pagseguro%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(205,499,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%pagseguro%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(206,500,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%paypalmx%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(207,501,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'PAYPALMX_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'PAYPAL_MX_SANDBOX\') AND ( value = \'0\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(208,502,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%paypalmx%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(209,503,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%paypalmx%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(210,505,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%paypalusa%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(211,506,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'PAYPALUSA_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'PAYPAL_USA_SANDBOX\') AND ( value = \'0\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(212,507,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%paypalusa%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(213,508,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%paypalmx%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(214,509,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%payulatam%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(215,510,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'PAYULATAM_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'PAYU_LATAM_TEST\') AND ( value = \'1\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(216,511,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%payulatam%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(217,512,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%payulatam%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(218,513,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%prestastats%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(219,514,'configuration','PRESTASTATS_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(220,515,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(221,516,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(222,517,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%riskified%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(223,518,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'RISKIFIED_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'RISKIFIED_MODE\') AND ( value = \'1\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(224,519,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%riskified%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(225,520,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%riskified%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(226,522,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'SIMPLIFY_CONFIGURATION_OK\') AND ( value = \'1\')) OR (( name LIKE \'SIMPLIFY_MODE\') AND ( value = \'1\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(227,523,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%simplifycommerce%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(228,524,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%simplifycommerce%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(229,525,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%vtpayment%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(230,526,'configuration','VTPAYMENT_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(231,527,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%vtpayment%\" AND os.logable = 1','>=','1','0','time','2',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(232,528,'sql','SELECT COUNT(*) FROM PREFIX_orders o LEFT JOIN PREFIX_order_state os ON os.id_order_state = o.current_state WHERE o.module like \"%vtpayment%\" AND os.logable = 1 AND o.date_add > DATE_SUB(NOW(), INTERVAL 90 DAY)','>=','30','0','time','7',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(233,529,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%yotpo%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(234,530,'configuration','YOTPO_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(235,531,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(236,532,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(237,533,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%yotpo%\"','==','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(238,534,'sql','SELECT COUNT(*) FROM PREFIX_configuration WHERE (( name LIKE \'YOUSTICERESOLUTIONSYSTEM_CONF_OK\') AND ( value = \'1\')) OR (( name LIKE \'YRS_SANDBOX\') AND ( value = \'0\'))','==','2','0','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(239,535,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(240,536,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(241,537,'sql','SELECT COUNT( id_module ) FROM PREFIX_module WHERE `name` like \"%loyaltylion%\"','>=','1','0','hook','actionModuleInstallAfter',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(242,538,'configuration','LOYALTYLION_CONFIGURATION_OK','==','1','','time','1',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(243,539,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18'),(244,540,'sql','SELECT 1','!=','1','1','time','365',0,'2015-12-31 18:23:18','2015-12-31 18:23:18');

--
