SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `qloapps1610`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]access`
--
CREATE TABLE `[[dbprefix]]access` (
`id_profile` int(10) unsigned NOT NULL,
`id_tab` int(10) unsigned NOT NULL,
`view` int(11) NOT NULL,
`add` int(11) NOT NULL,
`edit` int(11) NOT NULL,
`delete` int(11) NOT NULL,
PRIMARY KEY (`id_profile`,`id_tab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]accessory`
--
CREATE TABLE `[[dbprefix]]accessory` (
`id_product_1` int(10) unsigned NOT NULL,
`id_product_2` int(10) unsigned NOT NULL,
KEY `accessory_product` (`id_product_1`,`id_product_2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]address`
--
CREATE TABLE `[[dbprefix]]address` (
`id_address` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_country` int(10) unsigned NOT NULL,
`id_state` int(10) unsigned DEFAULT NULL,
`id_customer` int(10) unsigned NOT NULL DEFAULT '0',
`id_manufacturer` int(10) unsigned NOT NULL DEFAULT '0',
`id_supplier` int(10) unsigned NOT NULL DEFAULT '0',
`id_warehouse` int(10) unsigned NOT NULL DEFAULT '0',
`id_hotel` int(10) unsigned NOT NULL DEFAULT '0',
`alias` varchar(32) NOT NULL,
`company` varchar(255) DEFAULT NULL,
`lastname` varchar(32) NOT NULL,
`firstname` varchar(32) NOT NULL,
`address1` varchar(128) NOT NULL,
`address2` varchar(128) DEFAULT NULL,
`postcode` varchar(12) DEFAULT NULL,
`city` varchar(64) NOT NULL,
`other` text,
`phone` varchar(32) DEFAULT NULL,
`phone_mobile` varchar(32) DEFAULT NULL,
`vat_number` varchar(32) DEFAULT NULL,
`dni` varchar(16) DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`auto_generated` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_address`),
KEY `address_customer` (`id_customer`),
KEY `id_country` (`id_country`),
KEY `id_state` (`id_state`),
KEY `id_manufacturer` (`id_manufacturer`),
KEY `id_supplier` (`id_supplier`),
KEY `id_warehouse` (`id_warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]address`
--
INSERT INTO `[[dbprefix]]address` VALUES
(1, 21, 1, 1, 0, 0, 0, 0, 'My Address', '', 'Doe', 'John', '16, Main street', '2nd floor', '78763', 'Demo City', '', '0102030405', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0, 0),
(2, 21, 1, 0, 0, 0, 0, 1, 'The Hotel Prime', '', 'The Hotel Prime', 'The Hotel Prime', 'Monticello Dr, Montgomery, 10010', '', '14316', 'Demo City', '', '0987654321', '', '', '', '[[regtime]]', '[[regtime]]', 1, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]address_format`
--
CREATE TABLE `[[dbprefix]]address_format` (
`id_country` int(10) unsigned NOT NULL,
`format` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id_country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]address_format`
--
INSERT INTO `[[dbprefix]]address_format` VALUES
(1, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(2, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(3, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(4, 'firstname lastname\ncompany\naddress1\naddress2\ncity State:name postcode\nCountry:name\nphone\nphone_mobile'),
(5, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(6, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(7, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(8, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(9, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(10, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nState:name\nCountry:name\nphone\nphone_mobile'),
(11, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nState:name\nCountry:name\nphone\nphone_mobile'),
(12, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(13, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(14, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(15, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(16, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(17, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\ncity\npostcode\nCountry:name\nphone\nphone_mobile'),
(18, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(19, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(20, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(21, 'firstname lastname\ncompany\naddress1 address2\ncity, State:name postcode\nCountry:name\nphone\nphone_mobile'),
(22, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(23, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(24, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(25, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(26, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(27, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(28, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(29, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(30, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(31, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(32, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(33, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(34, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(35, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(36, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(37, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(38, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(39, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(40, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(41, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(42, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(43, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(44, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nState:name\nCountry:name\nphone\nphone_mobile'),
(45, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(46, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(47, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(48, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(49, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(50, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(51, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(52, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(53, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(54, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(55, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(56, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(57, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(58, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(59, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(60, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(61, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(62, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(63, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(64, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(65, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(66, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(67, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(68, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(69, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(70, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(71, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(72, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(73, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(74, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(75, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(76, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(77, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(78, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(79, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(80, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(81, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(82, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(83, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(84, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(85, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(86, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(87, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(88, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(89, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(90, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(91, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(92, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(93, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(94, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(95, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(96, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(97, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(98, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(99, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(100, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(101, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(102, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(103, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(104, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(105, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(106, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(107, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(108, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(109, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(110, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(111, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nState:name\nCountry:name\nphone\nphone_mobile'),
(112, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(113, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(114, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(115, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(116, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(117, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(118, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(119, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(120, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(121, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(122, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(123, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(124, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(125, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(126, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(127, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(128, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(129, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(130, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(131, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(132, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(133, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(134, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(135, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(136, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(137, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(138, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(139, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(140, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(141, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(142, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(143, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(144, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(145, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nState:name\nCountry:name\nphone\nphone_mobile'),
(146, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(147, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(148, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(149, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(150, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(151, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(152, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(153, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(154, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(155, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(156, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(157, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(158, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(159, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(160, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(161, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(162, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(163, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(164, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(165, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(166, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(167, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(168, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(169, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(170, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(171, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(172, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(173, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(174, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(175, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(176, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(177, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(178, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(179, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(180, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(181, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(182, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(183, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(184, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(185, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(186, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(187, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(188, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(189, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(190, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(191, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(192, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(193, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(194, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(195, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(196, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(197, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(198, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(199, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(200, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(201, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(202, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(203, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(204, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(205, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(206, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(207, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(208, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(209, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(210, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(211, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(212, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(213, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(214, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(215, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(216, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(217, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(218, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(219, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(220, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(221, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(222, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(223, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(224, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(225, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(226, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(227, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(228, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(229, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(230, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(231, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(232, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(233, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(234, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(235, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(236, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(237, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(238, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(239, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(240, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(241, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(242, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(243, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile'),
(244, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\nCountry:name\nphone\nphone_mobile');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]alias`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]alias`
--
INSERT INTO `[[dbprefix]]alias` VALUES
(1, 'bloose', 'blouse', 1),
(2, 'blues', 'blouse', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachment`
--
CREATE TABLE `[[dbprefix]]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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attachment_lang`
--
CREATE TABLE `[[dbprefix]]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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_group`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_group_lang`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_group_shop`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_impact`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_lang`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]attribute_shop`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier_group`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier_lang`
--
CREATE TABLE `[[dbprefix]]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(512) DEFAULT NULL,
PRIMARY KEY (`id_lang`,`id_shop`,`id_carrier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier_shop`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier_tax_rules_group_shop`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]carrier_zone`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart`
--
CREATE TABLE `[[dbprefix]]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',
`is_advance_payment` tinyint(1) 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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_cart_rule`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_customer_guest_detail`
--
CREATE TABLE `[[dbprefix]]cart_customer_guest_detail` (
`id_customer_guest_detail` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_cart` int(10) unsigned NOT NULL,
`id_gender` int(10) unsigned NOT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`phone` varchar(32) DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer_guest_detail`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]cart_customer_guest_detail`
--
INSERT INTO `[[dbprefix]]cart_customer_guest_detail` VALUES
(1, 0, 1, 'John', 'Doe', 'pub@qloapps.com', '1234567890', '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_product`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_carrier`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_combination`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_country`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_group`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_lang`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_product_rule`
--
CREATE TABLE `[[dbprefix]]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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_product_rule_group`
--
CREATE TABLE `[[dbprefix]]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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_product_rule_value`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cart_rule_shop`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `[[dbprefix]]category`
--
INSERT INTO `[[dbprefix]]category` VALUES
(1, 0, 1, 0, 1, 24, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(2, 1, 1, 1, 2, 23, 1, '[[regtime]]', '[[regtime]]', 0, 1),
(3, 2, 1, 2, 3, 12, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(4, 2, 1, 2, 13, 22, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(5, 3, 1, 3, 4, 11, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(6, 5, 1, 4, 5, 10, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(7, 6, 1, 5, 6, 9, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(8, 7, 1, 6, 7, 8, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(9, 4, 1, 3, 14, 15, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(10, 4, 1, 3, 16, 17, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(11, 4, 1, 3, 18, 19, 1, '[[regtime]]', '[[regtime]]', 0, 0),
(12, 4, 1, 3, 20, 21, 1, '[[regtime]]', '[[regtime]]', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_group`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]category_group`
--
INSERT INTO `[[dbprefix]]category_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);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_lang`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]category_lang`
--
INSERT INTO `[[dbprefix]]category_lang` VALUES
(1, 1, 1, 'Root', '', 'root', '', '', ''),
(2, 1, 1, 'Home', '', 'home', '', '', ''),
(3, 1, 1, 'Locations', '', 'locations', '', '', ''),
(4, 1, 1, 'Services', '', 'services', '', '', ''),
(5, 1, 1, 'United States', 'This category are for hotels only', 'united-states', '', '', ''),
(6, 1, 1, 'Alabama', 'This category are for hotels only', 'alabama', '', '', ''),
(7, 1, 1, 'Demo City', 'This category are for hotels only', 'demo-city', '', '', ''),
(8, 1, 1, 'The Hotel Prime', 'This category are for hotels only', 'the-hotel-prime', '', '', ''),
(9, 1, 1, 'Restaurant', 'This category are for hotels only', 'restaurant', '', '', ''),
(10, 1, 1, 'Transfers', 'This category are for hotels only', 'transfers', '', '', ''),
(11, 1, 1, 'Activities', 'This category are for hotels only', 'activities', '', '', ''),
(12, 1, 1, 'Operational charges', 'This category are for hotels only', 'operational-charges', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_product`
--
CREATE TABLE `[[dbprefix]]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`),
KEY `id_category` (`id_category`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]category_product`
--
INSERT INTO `[[dbprefix]]category_product` VALUES
(2, 1, 0),
(2, 2, 1),
(2, 3, 2),
(2, 4, 3),
(3, 1, 0),
(3, 2, 1),
(3, 3, 2),
(3, 4, 3),
(5, 1, 0),
(5, 2, 1),
(5, 3, 2),
(5, 4, 3),
(6, 1, 0),
(6, 2, 1),
(6, 3, 2),
(6, 4, 3),
(7, 1, 0),
(7, 2, 1),
(7, 3, 2),
(7, 4, 3),
(8, 1, 0),
(8, 2, 1),
(8, 3, 2),
(8, 4, 3),
(9, 9, 0),
(9, 10, 1),
(10, 7, 0),
(10, 8, 1),
(12, 5, 0),
(12, 6, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]category_shop`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]category_shop`
--
INSERT INTO `[[dbprefix]]category_shop` VALUES
(1, 1, 0),
(2, 1, 0),
(3, 1, 0),
(4, 1, 1),
(5, 1, 0),
(6, 1, 0),
(7, 1, 0),
(8, 1, 0),
(9, 1, 0),
(10, 1, 1),
(11, 1, 2),
(12, 1, 3);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `[[dbprefix]]cms`
--
INSERT INTO `[[dbprefix]]cms` VALUES
(1, 1, 0, 1, 0),
(2, 1, 1, 1, 0),
(3, 1, 2, 1, 0),
(4, 1, 3, 1, 0),
(5, 1, 4, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_category`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]cms_category`
--
INSERT INTO `[[dbprefix]]cms_category` VALUES
(1, 0, 1, 1, '[[regtime]]', '[[regtime]]', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_category_lang`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]cms_category_lang`
--
INSERT INTO `[[dbprefix]]cms_category_lang` VALUES
(1, 1, 1, 'Home', '', 'home', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_category_shop`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]cms_category_shop`
--
INSERT INTO `[[dbprefix]]cms_category_shop` VALUES
(1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_lang`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]cms_lang`
--
INSERT INTO `[[dbprefix]]cms_lang` VALUES
(1, 1, 1, 'Policies', 'Our policies of hotel bookings', 'conditions, policy, guidelines, protocol, rule', 'Policies
\n \n
This page contains demo content for illustrative purposes only. Any resemblance to actual products, services, or events is purely coincidental. Thank you for your understanding.
\n
\n
Reservation Policy:
\n
\n - Guests must provide valid credit card details to secure a reservation.
\n - Cancellation policies vary based on room type and rate plan.
\n - Changes to reservations may be subject to availability and additional charges.
\n
\n
Check-in and Check-out Times:
\n
\n - Check-in time: 11:00 AM
\n - Check-out time: 10:30 AM
\n - Early check-in and late check-out requests are subject to availability and may incur additional charges.
\n
\n
Payment Policy:
\n
\n - Payment for the entire stay is due upon check-in.
\n - Acceptable forms of payment: credit cards, cash, etc.
\n - A security deposit may be required upon arrival.
\n
\n
Cancellation and No-show Policy:
\n
\n - Cancellations made 7 days prior to arrival are eligible for a full refund.
\n - No-shows will be charged the full amount of the reservation.
\n
\n
Pet Policy:
\n
\n - Pets are welcome with prior arrangement.
\n - Additional charges may apply for pet-friendly accommodations.
\n - Guests are responsible for any damages caused by their pets.
\n
\n
Smoking Policy:
\n
\n - Our hotel is smoke-free. Smoking is strictly prohibited indoors.
\n - Designated smoking areas are available outside the premises.
\n
\n
Privacy Policy:
\n
\n - We are committed to protecting your privacy and personal information.
\n - Information collected during booking and stay is used solely for operational purposes.
\n
\n
Accessibility Policy:
\n
\n - Our hotel is committed to providing accessible accommodations and facilities for guests with disabilities.
\n - Please contact us directly for specific accessibility requests.
\n
\n
Additional Policies:
\n
\n - Use of hotel facilities such as the gym, spa, pool, etc.
\n - Conduct and behavior expectations while on hotel premises.
\n
\n
Legal Notice
\n \n
This page contains demo content for illustrative purposes only. Any resemblance to actual products, services, or events is purely coincidental. Thank you for your understanding.
\n
Website Terms of Use:
\n \n - The content of the pages of this website is for your general information and use only. It is subject to change without notice.
\n - Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness, or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors, and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.
\n - Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services, or information available through this website meet your specific requirements.
\n
\n Intellectual Property:
\n \n - This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance, and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.
\n - All trademarks reproduced in this website, which are not the property of, or licensed to the operator, are acknowledged on the website.
\n
\n Privacy Policy:
\n \n - Your privacy is important to us. Please review our Privacy Policy to understand how we collect, use, and disclose information about you.
\n
\n Limitation of Liability:
\n \n - Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness, or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors, and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.
\n - Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services, or information available through this website meet your specific requirements.
\n
\n ', 'legal-notice'),
(3, 1, 1, 'Terms and Conditions', 'Our Terms and Conditions', 'conditions, terms, use, sell', '\n Terms and Conditions
\n \n
This page contains demo content for illustrative purposes only. Any resemblance to actual products, services, or events is purely coincidental. Thank you for your understanding.
\n
\n
Cancellation Policy:
\n
\n
\n - Free Cancellation: Up to 48 hours before arrival for standard rates.
\n - Bookings made with a non-refundable rate cannot be canceled or modified.
\n - Cancellations within 24 hours of arrival will incur a fee of one night''s stay.
\n
\n
\n
\n
Changes to Bookings:
\n
\n
\n - A fee of $25 may apply to change your reservation dates after booking.
\n - Changes to room type or number of guests are subject to availability at the hotel.
\n
\n
\n
\n
Guest Responsibility:
\n
\n
\n - All guests must present a valid government-issued photo ID at check-in.
\n - The maximum occupancy for the room type is 2 adults.
\n - Smoking and alcohol are strictly prohibited in all guest rooms and public areas.
\n
\n
\n
About Us
\n
This page contains demo content for illustrative purposes only. Any resemblance to actual products, services, or events is purely coincidental. Thank you for your understanding.
\n
\n
\n
\n
\n
Welcome to our sanctuary of luxury and tranquility, where every stay is crafted to provide an unparalleled experience. Whether you''re seeking a relaxing getaway, a productive business trip, or a memorable event, we are dedicated to making your visit exceptional.
\n
\n
\n
Our Story
\n
Inspired by serene surroundings and rich local culture, our hotel combines modern comfort with timeless elegance. Our thoughtfully designed rooms, impeccable service, and attention to detail reflect our commitment to providing a haven for travelers.
\n
\n
\n
Our Mission
\n
Our mission is to create a home away from home, offering personalized service and luxurious amenities tailored to your needs. Your comfort and satisfaction are our top priorities, and we strive to exceed your expectations at every turn.
\n
\n
\n
Our Amenities
\n
Indulge in the finest amenities during your stay. Relax in elegantly appointed rooms and suites with breathtaking views. Savor gourmet dining at our on-site restaurant, unwind with a cocktail at our stylish bar, and rejuvenate at our state-of-the-art spa and fitness center. Enjoy our serene outdoor pool, lush gardens, and modern business facilities to cater to all your needs.
\n
\n
\n
Our Team
\n
Our dedicated team of hospitality professionals is here to serve you with a passion for excellence. From personalized concierge services to meticulous housekeeping, every member of our team is committed to making your stay extraordinary.
\n
\n
\n
Join Us
\n
Discover the charm and elegance of our hotel for yourself. Whether visiting for leisure or business, we invite you to experience our warm hospitality and luxurious accommodations. Book your stay with us today and let us make your visit unforgettable.
\n
\n
\n
\n
\n
\n
Testimonials
\n
\n
“Hotel Prime surpassed my expectations in every way. The Executive Room was not only luxurious but also provided a peaceful retreat with its stunning lake views. The attention to detail and personalized service made my stay truly memorable. I highly recommend Hotel Prime for both business and leisure travelers looking for a blend of comfort and sophistication”
\n
\n
Calrk Kent
\n
\n
“As a frequent traveler, I can confidently say Hotel Prime stands out for its tranquil environment and exceptional hospitality. The View Room provided a perfect retreat with its stunning cityscape views and comfortable accommodations.”
\n
\n
john Doe
\n
\n
\n
Secure payment
\n \n
This page contains demo content for illustrative purposes only. Any resemblance to actual products, services, or events is purely coincidental. Thank you for your understanding.
\n
We prioritize your security. All transactions made on our website are encrypted using Secure Socket Layer (SSL) technology to ensure your personal information and payment details are protected. We accept major credit cards and provide a secure environment for a seamless booking experience. For any inquiries regarding payment security, feel free to contact our customer support team.
\n ', 'secure-payment');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_role`
--
CREATE TABLE `[[dbprefix]]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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_role_lang`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]cms_shop`
--
CREATE TABLE `[[dbprefix]]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 `[[dbprefix]]cms_shop`
--
INSERT INTO `[[dbprefix]]cms_shop` VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]compare`
--
CREATE TABLE `[[dbprefix]]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 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]compare_product`
--
CREATE TABLE `[[dbprefix]]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;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]configuration`
--
CREATE TABLE `[[dbprefix]]configuration` (
`id_configuration` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned DEFAULT NULL,
`id_shop` int(11) unsigned DEFAULT NULL,
`name` varchar(254) NOT NULL,
`value` text,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_configuration`),
KEY `name` (`name`),
KEY `id_shop` (`id_shop`),
KEY `id_shop_group` (`id_shop_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=393 ;
--
-- Dumping data for table `[[dbprefix]]configuration`
--
INSERT INTO `[[dbprefix]]configuration` VALUES
(1, NULL, NULL, 'PS_LANG_DEFAULT', '1', '[[regtime]]', '[[regtime]]'),
(2, NULL, NULL, 'PS_VERSION_DB', '1.6.1.23', '[[regtime]]', '[[regtime]]'),
(3, NULL, NULL, 'PS_INSTALL_VERSION', '1.6.1.23', '[[regtime]]', '[[regtime]]'),
(4, NULL, NULL, 'PS_GROUP_FEATURE_ACTIVE', '1', '[[regtime]]', '[[regtime]]'),
(5, NULL, NULL, 'PS_SEARCH_INDEXATION', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, NULL, NULL, 'PS_ONE_PHONE_AT_LEAST', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, NULL, NULL, 'PS_CART_FOLLOWING', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, NULL, NULL, 'PS_CARRIER_DEFAULT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, NULL, NULL, 'PS_CURRENCY_DEFAULT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, NULL, NULL, 'PS_COUNTRY_DEFAULT', '21', '0000-00-00 00:00:00', '[[regtime]]'),
(11, NULL, NULL, 'PS_REWRITING_SETTINGS', '1', '0000-00-00 00:00:00', '[[regtime]]'),
(12, NULL, NULL, 'PS_ORDER_OUT_OF_STOCK', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, NULL, NULL, 'PS_LAST_QTIES', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, NULL, NULL, 'PS_CART_REDIRECT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, NULL, NULL, 'PS_CONDITIONS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, NULL, NULL, 'PS_RECYCLABLE_PACK', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, NULL, NULL, 'PS_GIFT_WRAPPING', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, NULL, NULL, 'PS_GIFT_WRAPPING_PRICE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, NULL, NULL, 'PS_STOCK_MANAGEMENT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, NULL, NULL, 'PS_NAVIGATION_PIPE', '>', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, NULL, NULL, 'PS_PRODUCTS_PER_PAGE', '12', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, NULL, NULL, 'PS_HOTEL_IMAGES_PER_PAGE', '9', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, NULL, NULL, 'PS_PURCHASE_MINIMUM', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, NULL, NULL, 'PS_PRODUCTS_ORDER_WAY', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, NULL, NULL, 'PS_PRODUCTS_ORDER_BY', '4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, NULL, NULL, 'PS_DISPLAY_QTIES', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, NULL, NULL, 'PS_SHIPPING_HANDLING', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, NULL, NULL, 'PS_SHIPPING_FREE_PRICE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, NULL, NULL, 'PS_SHIPPING_FREE_WEIGHT', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, NULL, NULL, 'PS_SHIPPING_METHOD', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, NULL, NULL, 'PS_TAX', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, NULL, NULL, 'PS_SHOP_ENABLE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, NULL, NULL, 'PS_ALLOW_EMP', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, NULL, NULL, 'PS_ALLOW_EMP_MAX_ATTEMPTS', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, NULL, NULL, 'PS_NB_DAYS_NEW_PRODUCT', '20', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, NULL, NULL, 'PS_KPI_BEST_SELLING_ROOM_TYPE_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, NULL, NULL, 'PS_SSL_ENABLED', '[[PS_SSL_ENABLED]]', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, NULL, NULL, 'PS_WEIGHT_UNIT', 'kg', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, NULL, NULL, 'PS_BLOCK_CART_AJAX', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, NULL, NULL, 'PS_ORDER_RETURN', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, NULL, NULL, 'PS_ORDER_RETURN_NB_DAYS', '14', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, NULL, NULL, 'PS_MAIL_TYPE', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, NULL, NULL, 'PS_PRODUCT_PICTURE_MAX_SIZE', '8388608', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, NULL, NULL, 'PS_PRODUCT_PICTURE_WIDTH', '64', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, NULL, NULL, 'PS_PRODUCT_PICTURE_HEIGHT', '64', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, NULL, NULL, 'PS_INVOICE_PREFIX', '#IN', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, NULL, NULL, 'PS_INVCE_INVOICE_ADDR_RULES', '{"avoid":[]}', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, NULL, NULL, 'PS_INVCE_DELIVERY_ADDR_RULES', '{"avoid":[]}', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, NULL, NULL, 'PS_DELIVERY_PREFIX', '#DE', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, NULL, NULL, 'PS_DELIVERY_NUMBER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, NULL, NULL, 'PS_RETURN_PREFIX', '#RE', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(52, NULL, NULL, 'PS_INVOICE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, NULL, NULL, 'PS_PASSWD_TIME_BACK', '360', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, NULL, NULL, 'PS_PASSWD_TIME_FRONT', '360', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, NULL, NULL, 'PS_DISP_UNAVAILABLE_ATTR', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, NULL, NULL, 'PS_SEARCH_MINWORDLEN', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, NULL, NULL, 'PS_SEARCH_BLACKLIST', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, NULL, NULL, 'PS_SEARCH_WEIGHT_PNAME', '6', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, NULL, NULL, 'PS_SEARCH_WEIGHT_REF', '10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, NULL, NULL, 'PS_SEARCH_WEIGHT_SHORTDESC', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, NULL, NULL, 'PS_SEARCH_WEIGHT_DESC', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, NULL, NULL, 'PS_SEARCH_WEIGHT_CNAME', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, NULL, NULL, 'PS_SEARCH_WEIGHT_MNAME', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, NULL, NULL, 'PS_SEARCH_WEIGHT_TAG', '4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, NULL, NULL, 'PS_SEARCH_WEIGHT_ATTRIBUTE', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, NULL, NULL, 'PS_SEARCH_WEIGHT_FEATURE', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(67, NULL, NULL, 'PS_SEARCH_AJAX', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(68, NULL, NULL, 'PS_TIMEZONE', 'US/Eastern', '0000-00-00 00:00:00', '[[regtime]]'),
(69, NULL, NULL, 'PS_THEME_V11', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(70, NULL, NULL, 'PRESTASTORE_LIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(71, NULL, NULL, 'PS_TIN_ACTIVE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(72, NULL, NULL, 'PS_SHOW_ALL_MODULES', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(73, NULL, NULL, 'PS_BACKUP_ALL', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(74, NULL, NULL, 'PS_1_3_UPDATE_DATE', '2011-12-27 10:20:42', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(75, NULL, NULL, 'PS_PRICE_ROUND_MODE', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(76, NULL, NULL, 'PS_1_3_2_UPDATE_DATE', '2011-12-27 10:20:42', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(77, NULL, NULL, 'PS_CONDITIONS_CMS_ID', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(78, NULL, NULL, 'PS_ORDER_LIST_PRICE_DISPLAY_CURRENCY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(79, NULL, NULL, 'TRACKING_DIRECT_TRAFFIC', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(80, NULL, NULL, 'PS_META_KEYWORDS', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(81, NULL, NULL, 'PS_DISPLAY_JQZOOM', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(82, NULL, NULL, 'PS_VOLUME_UNIT', 'cl', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(83, NULL, NULL, 'PS_CIPHER_ALGORITHM', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(84, NULL, NULL, 'PS_ATTRIBUTE_CATEGORY_DISPLAY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(85, NULL, NULL, 'PS_CUSTOMER_SERVICE_FILE_UPLOAD', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(86, NULL, NULL, 'PS_CUSTOMER_SERVICE_SIGNATURE', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(87, NULL, NULL, 'PS_BLOCK_BESTSELLERS_DISPLAY', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(88, NULL, NULL, 'PS_BLOCK_NEWPRODUCTS_DISPLAY', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(89, NULL, NULL, 'PS_BLOCK_SPECIALS_DISPLAY', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(90, NULL, NULL, 'PS_STOCK_MVT_REASON_DEFAULT', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(91, NULL, NULL, 'PS_COMPARATOR_MAX_ITEM', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(92, NULL, NULL, 'PS_ORDER_PROCESS_TYPE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(93, NULL, NULL, 'PS_SPECIFIC_PRICE_PRIORITIES', 'id_shop;id_currency;id_country;id_group', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(94, NULL, NULL, 'PS_TAX_DISPLAY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(95, NULL, NULL, 'PS_SMARTY_FORCE_COMPILE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(96, NULL, NULL, 'PS_DISTANCE_UNIT', 'km', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(97, NULL, NULL, 'PS_STORES_DISPLAY_CMS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(98, NULL, NULL, 'PS_STORES_DISPLAY_FOOTER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(99, NULL, NULL, 'PS_STORES_SIMPLIFIED', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(100, NULL, NULL, 'SHOP_LOGO_WIDTH', '243', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(101, NULL, NULL, 'SHOP_LOGO_HEIGHT', '120', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(102, NULL, NULL, 'EDITORIAL_IMAGE_WIDTH', '530', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(103, NULL, NULL, 'EDITORIAL_IMAGE_HEIGHT', '228', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(104, NULL, NULL, 'PS_STATSDATA_CUSTOMER_PAGESVIEWS', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(105, NULL, NULL, 'PS_STATSDATA_PAGESVIEWS', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(106, NULL, NULL, 'PS_STATSDATA_PLUGINS', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(107, NULL, NULL, 'PS_GEOLOCATION_ENABLED', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(108, NULL, NULL, 'PS_ALLOWED_COUNTRIES', 'AF;ZA;AX;AL;DZ;DE;AD;AO;AI;AQ;AG;AN;SA;AR;AM;AW;AU;AT;AZ;BS;BH;BD;BB;BY;BE;BZ;BJ;BM;BT;BO;BA;BW;BV;BR;BN;BG;BF;MM;BI;KY;KH;CM;CA;CV;CF;CL;CN;CX;CY;CC;CO;KM;CG;CD;CK;KR;KP;CR;CI;HR;CU;DK;DJ;DM;EG;IE;SV;AE;EC;ER;ES;EE;ET;FK;FO;FJ;FI;FR;GA;GM;GE;GS;GH;GI;GR;GD;GL;GP;GU;GT;GG;GN;GQ;GW;GY;GF;HT;HM;HN;HK;HU;IM;MU;VG;VI;IN;ID;IR;IQ;IS;IL;IT;JM;JP;JE;JO;KZ;KE;KG;KI;KW;LA;LS;LV;LB;LR;LY;LI;LT;LU;MO;MK;MG;MY;MW;MV;ML;MT;MP;MA;MH;MQ;MR;YT;MX;FM;MD;MC;MN;ME;MS;MZ;NA;NR;NP;NI;NE;NG;NU;NF;NO;NC;NZ;IO;OM;UG;UZ;PK;PW;PS;PA;PG;PY;NL;PE;PH;PN;PL;PF;PR;PT;QA;DO;CZ;RE;RO;GB;RU;RW;EH;BL;KN;SM;MF;PM;VA;VC;LC;SB;WS;AS;ST;SN;RS;SC;SL;SG;SK;SI;SO;SD;LK;SE;CH;SR;SJ;SZ;SY;TJ;TW;TZ;TD;TF;TH;TL;TG;TK;TO;TT;TN;TM;TC;TR;TV;UA;UY;US;VU;VE;VN;WF;YE;ZM;ZW', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(109, NULL, NULL, 'PS_GEOLOCATION_BEHAVIOR', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(110, NULL, NULL, 'PS_LOCALE_LANGUAGE', 'en', '0000-00-00 00:00:00', '[[regtime]]'),
(111, NULL, NULL, 'PS_LOCALE_COUNTRY', 'us', '0000-00-00 00:00:00', '[[regtime]]'),
(112, NULL, NULL, 'PS_ATTACHMENT_MAXIMUM_SIZE', '8', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(113, NULL, NULL, 'PS_SMARTY_CACHE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(114, NULL, NULL, 'PS_DIMENSION_UNIT', 'cm', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(115, NULL, NULL, 'PS_GUEST_CHECKOUT_ENABLED', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(116, NULL, NULL, 'PS_OVERBOOKING_ORDER_ACTION', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(117, NULL, NULL, 'PS_MAX_OVERBOOKING_PER_HOTEL_PER_DAY', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(118, NULL, NULL, 'PS_ORDER_CONF_MAIL_TO_CUSTOMER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(119, NULL, NULL, 'PS_ORDER_CONF_MAIL_TO_SUPERADMIN', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(120, NULL, NULL, 'PS_ORDER_CONF_MAIL_TO_HOTEL_MANAGER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(121, NULL, NULL, 'PS_ORDER_CONF_MAIL_TO_EMPLOYEE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(122, NULL, NULL, 'PS_DISPLAY_SUPPLIERS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(123, NULL, NULL, 'PS_DISPLAY_BEST_SELLERS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(124, NULL, NULL, 'PS_CATALOG_MODE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(125, NULL, NULL, 'PS_GEOLOCATION_WHITELIST', '127;209.185.108;209.185.253;209.85.238;209.85.238.11;209.85.238.4;216.239.33.96;216.239.33.97;216.239.33.98;216.239.33.99;216.239.37.98;216.239.37.99;216.239.39.98;216.239.39.99;216.239.41.96;216.239.41.97;216.239.41.98;216.239.41.99;216.239.45.4;216.239.46;216.239.51.96;216.239.51.97;216.239.51.98;216.239.51.99;216.239.53.98;216.239.53.99;216.239.57.96;91.240.109;216.239.57.97;216.239.57.98;216.239.57.99;216.239.59.98;216.239.59.99;216.33.229.163;64.233.173.193;64.233.173.194;64.233.173.195;64.233.173.196;64.233.173.197;64.233.173.198;64.233.173.199;64.233.173.200;64.233.173.201;64.233.173.202;64.233.173.203;64.233.173.204;64.233.173.205;64.233.173.206;64.233.173.207;64.233.173.208;64.233.173.209;64.233.173.210;64.233.173.211;64.233.173.212;64.233.173.213;64.233.173.214;64.233.173.215;64.233.173.216;64.233.173.217;64.233.173.218;64.233.173.219;64.233.173.220;64.233.173.221;64.233.173.222;64.233.173.223;64.233.173.224;64.233.173.225;64.233.173.226;64.233.173.227;64.233.173.228;64.233.173.229;64.233.173.230;64.233.173.231;64.233.173.232;64.233.173.233;64.233.173.234;64.233.173.235;64.233.173.236;64.233.173.237;64.233.173.238;64.233.173.239;64.233.173.240;64.233.173.241;64.233.173.242;64.233.173.243;64.233.173.244;64.233.173.245;64.233.173.246;64.233.173.247;64.233.173.248;64.233.173.249;64.233.173.250;64.233.173.251;64.233.173.252;64.233.173.253;64.233.173.254;64.233.173.255;64.68.80;64.68.81;64.68.82;64.68.83;64.68.84;64.68.85;64.68.86;64.68.87;64.68.88;64.68.89;64.68.90.1;64.68.90.10;64.68.90.11;64.68.90.12;64.68.90.129;64.68.90.13;64.68.90.130;64.68.90.131;64.68.90.132;64.68.90.133;64.68.90.134;64.68.90.135;64.68.90.136;64.68.90.137;64.68.90.138;64.68.90.139;64.68.90.14;64.68.90.140;64.68.90.141;64.68.90.142;64.68.90.143;64.68.90.144;64.68.90.145;64.68.90.146;64.68.90.147;64.68.90.148;64.68.90.149;64.68.90.15;64.68.90.150;64.68.90.151;64.68.90.152;64.68.90.153;64.68.90.154;64.68.90.155;64.68.90.156;64.68.90.157;64.68.90.158;64.68.90.159;64.68.90.16;64.68.90.160;64.68.90.161;64.68.90.162;64.68.90.163;64.68.90.164;64.68.90.165;64.68.90.166;64.68.90.167;64.68.90.168;64.68.90.169;64.68.90.17;64.68.90.170;64.68.90.171;64.68.90.172;64.68.90.173;64.68.90.174;64.68.90.175;64.68.90.176;64.68.90.177;64.68.90.178;64.68.90.179;64.68.90.18;64.68.90.180;64.68.90.181;64.68.90.182;64.68.90.183;64.68.90.184;64.68.90.185;64.68.90.186;64.68.90.187;64.68.90.188;64.68.90.189;64.68.90.19;64.68.90.190;64.68.90.191;64.68.90.192;64.68.90.193;64.68.90.194;64.68.90.195;64.68.90.196;64.68.90.197;64.68.90.198;64.68.90.199;64.68.90.2;64.68.90.20;64.68.90.200;64.68.90.201;64.68.90.202;64.68.90.203;64.68.90.204;64.68.90.205;64.68.90.206;64.68.90.207;64.68.90.208;64.68.90.21;64.68.90.22;64.68.90.23;64.68.90.24;64.68.90.25;64.68.90.26;64.68.90.27;64.68.90.28;64.68.90.29;64.68.90.3;64.68.90.30;64.68.90.31;64.68.90.32;64.68.90.33;64.68.90.34;64.68.90.35;64.68.90.36;64.68.90.37;64.68.90.38;64.68.90.39;64.68.90.4;64.68.90.40;64.68.90.41;64.68.90.42;64.68.90.43;64.68.90.44;64.68.90.45;64.68.90.46;64.68.90.47;64.68.90.48;64.68.90.49;64.68.90.5;64.68.90.50;64.68.90.51;64.68.90.52;64.68.90.53;64.68.90.54;64.68.90.55;64.68.90.56;64.68.90.57;64.68.90.58;64.68.90.59;64.68.90.6;64.68.90.60;64.68.90.61;64.68.90.62;64.68.90.63;64.68.90.64;64.68.90.65;64.68.90.66;64.68.90.67;64.68.90.68;64.68.90.69;64.68.90.7;64.68.90.70;64.68.90.71;64.68.90.72;64.68.90.73;64.68.90.74;64.68.90.75;64.68.90.76;64.68.90.77;64.68.90.78;64.68.90.79;64.68.90.8;64.68.90.80;64.68.90.9;64.68.91;64.68.92;66.249.64;66.249.65;66.249.66;66.249.67;66.249.68;66.249.69;66.249.70;66.249.71;66.249.72;66.249.73;66.249.78;66.249.79;72.14.199;8.6.48', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(126, NULL, NULL, 'PS_LOGS_BY_EMAIL', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(127, NULL, NULL, 'PS_COOKIE_CHECKIP', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(128, NULL, NULL, 'PS_STORES_CENTER_LAT', '25.948969', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(129, NULL, NULL, 'PS_STORES_CENTER_LONG', '-80.226439', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(130, NULL, NULL, 'PS_USE_ECOTAX', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(131, NULL, NULL, 'PS_CANONICAL_REDIRECT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(132, NULL, NULL, 'PS_IMG_UPDATE_TIME', '1324977642', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(133, NULL, NULL, 'PS_BACKUP_DROP_TABLE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(134, NULL, NULL, 'PS_OS_AWAITING_PAYMENT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(135, NULL, NULL, 'PS_OS_PAYMENT_ACCEPTED', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(136, NULL, NULL, 'PS_OS_PROCESSING', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(137, NULL, NULL, 'PS_OS_CANCELED', '4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(138, NULL, NULL, 'PS_OS_REFUND', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(139, NULL, NULL, 'PS_OS_ERROR', '6', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(140, NULL, NULL, 'PS_OS_OUTOFSTOCK', '7', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(141, NULL, NULL, 'PS_OS_OUTOFSTOCK_PAID', '7', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(142, NULL, NULL, 'PS_OS_OVERBOOKING_PAID', '7', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(143, NULL, NULL, 'PS_OS_PARTIAL_PAYMENT_ACCEPTED', '8', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(144, NULL, NULL, 'PS_OS_AWAITING_REMOTE_PAYMENT', '9', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(145, NULL, NULL, 'PS_OS_WS_PAYMENT', '10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(146, NULL, NULL, 'PS_OS_REMOTE_PAYMENT_ACCEPTED', '10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(147, NULL, NULL, 'PS_OS_OUTOFSTOCK_UNPAID', '11', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(148, NULL, NULL, 'PS_OS_OVERBOOKING_UNPAID', '11', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(149, NULL, NULL, 'PS_OS_OVERBOOKING_PARTIAL_PAID', '12', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(150, NULL, NULL, 'PS_ORS_PENDING', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(151, NULL, NULL, 'PS_ORS_DENIED', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(152, NULL, NULL, 'PS_ORS_REFUNDED', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(153, NULL, NULL, 'PS_LEGACY_IMAGES', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(154, NULL, NULL, 'PS_IMAGE_QUALITY', 'png', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(155, NULL, NULL, 'PS_PNG_QUALITY', '7', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(156, NULL, NULL, 'PS_JPEG_QUALITY', '90', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(157, NULL, NULL, 'PS_COOKIE_LIFETIME_FO', '480', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(158, NULL, NULL, 'PS_COOKIE_LIFETIME_BO', '480', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(159, NULL, NULL, 'PS_COOKIE_SAMESITE', 'Lax', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(160, NULL, NULL, 'PS_RESTRICT_DELIVERED_COUNTRIES', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(161, NULL, NULL, 'PS_SHOW_NEW_ORDERS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(162, NULL, NULL, 'PS_SHOW_NEW_CUSTOMERS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(163, NULL, NULL, 'PS_SHOW_NEW_MESSAGES', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(164, NULL, NULL, 'PS_FEATURE_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(165, NULL, NULL, 'PS_COMBINATION_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(166, NULL, NULL, 'PS_SPECIFIC_PRICE_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(167, NULL, NULL, 'PS_SCENE_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(168, NULL, NULL, 'PS_VIRTUAL_PROD_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '[[regtime]]'),
(169, NULL, NULL, 'PS_CUSTOMIZATION_FEATURE_ACTIVE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(170, NULL, NULL, 'PS_CART_RULE_FEATURE_ACTIVE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(171, NULL, NULL, 'PS_PACK_FEATURE_ACTIVE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(172, NULL, NULL, 'PS_ALIAS_FEATURE_ACTIVE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(173, NULL, NULL, 'PS_TAX_ADDRESS_TYPE', 'id_address_invoice', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(174, NULL, NULL, 'PS_SHOP_DEFAULT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(175, NULL, NULL, 'PS_CARRIER_DEFAULT_SORT', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(176, NULL, NULL, 'PS_STOCK_MVT_INC_REASON_DEFAULT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(177, NULL, NULL, 'PS_STOCK_MVT_DEC_REASON_DEFAULT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(178, NULL, NULL, 'PS_ADVANCED_STOCK_MANAGEMENT', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(179, NULL, NULL, 'PS_ADMINREFRESH_NOTIFICATION', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(180, NULL, NULL, 'PS_STOCK_MVT_TRANSFER_TO', '7', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(181, NULL, NULL, 'PS_STOCK_MVT_TRANSFER_FROM', '6', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(182, NULL, NULL, 'PS_CARRIER_DEFAULT_ORDER', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(183, NULL, NULL, 'PS_STOCK_MVT_SUPPLY_ORDER', '8', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(184, NULL, NULL, 'PS_STOCK_CUSTOMER_ORDER_REASON', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(185, NULL, NULL, 'PS_UNIDENTIFIED_GROUP', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(186, NULL, NULL, 'PS_GUEST_GROUP', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(187, NULL, NULL, 'PS_CUSTOMER_GROUP', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(188, NULL, NULL, 'PS_SMARTY_CONSOLE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(189, NULL, NULL, 'PS_INVOICE_MODEL', 'invoice', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(190, NULL, NULL, 'PS_LIMIT_UPLOAD_IMAGE_VALUE', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(191, NULL, NULL, 'PS_LIMIT_UPLOAD_FILE_VALUE', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(192, NULL, NULL, 'MB_PAY_TO_EMAIL', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(193, NULL, NULL, 'MB_SECRET_WORD', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(194, NULL, NULL, 'MB_HIDE_LOGIN', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(195, NULL, NULL, 'MB_ID_LOGO', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(196, NULL, NULL, 'MB_ID_LOGO_WALLET', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(197, NULL, NULL, 'MB_PARAMETERS', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(198, NULL, NULL, 'MB_PARAMETERS_2', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(199, NULL, NULL, 'MB_DISPLAY_MODE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(200, NULL, NULL, 'MB_CANCEL_URL', 'http://www.yoursite.com', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(201, NULL, NULL, 'MB_LOCAL_METHODS', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(202, NULL, NULL, 'MB_INTER_METHODS', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(203, NULL, NULL, 'BANK_WIRE_CURRENCIES', '2,1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(204, NULL, NULL, 'CHEQUE_CURRENCIES', '2,1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(205, NULL, NULL, 'PRODUCTS_VIEWED_NBR', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(206, NULL, NULL, 'BLOCK_CATEG_DHTML', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(207, NULL, NULL, 'BLOCK_CATEG_MAX_DEPTH', '4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(208, NULL, NULL, 'MANUFACTURER_DISPLAY_FORM', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(209, NULL, NULL, 'MANUFACTURER_DISPLAY_TEXT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(210, NULL, NULL, 'MANUFACTURER_DISPLAY_TEXT_NB', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(211, NULL, NULL, 'NEW_PRODUCTS_NBR', '8', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(212, NULL, NULL, 'PS_TOKEN_ENABLE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(213, NULL, NULL, 'PS_STATS_RENDER', 'graphnvd3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(214, NULL, NULL, 'PS_STATS_OLD_CONNECT_AUTO_CLEAN', 'never', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(215, NULL, NULL, 'PS_STATS_GRID_RENDER', 'gridhtml', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(216, NULL, NULL, 'BLOCKTAGS_NBR', '10', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(217, NULL, NULL, 'HOTEL_CHECKUP_DESCRIPTIONS_LT', '100', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(218, NULL, NULL, 'HOTEL_CHECKUP_DESCRIPTIONS_GT', '400', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(219, NULL, NULL, 'HOTEL_CHECKUP_IMAGES_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(220, NULL, NULL, 'HOTEL_CHECKUP_IMAGES_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(221, NULL, NULL, 'HOTEL_CHECKUP_ORDERS_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(222, NULL, NULL, 'HOTEL_CHECKUP_ORDERS_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(223, NULL, NULL, 'HOTEL_CHECKUP_TOTAL_ROOMS_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(224, NULL, NULL, 'HOTEL_CHECKUP_TOTAL_ROOMS_GT', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(225, NULL, NULL, 'ROOM_TYPE_CHECKUP_DESCRIPTIONS_LT', '100', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(226, NULL, NULL, 'ROOM_TYPE_CHECKUP_DESCRIPTIONS_GT', '400', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(227, NULL, NULL, 'ROOM_TYPE_CHECKUP_IMAGES_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(228, NULL, NULL, 'ROOM_TYPE_CHECKUP_IMAGES_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(229, NULL, NULL, 'ROOM_TYPE_CHECKUP_ORDERS_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(230, NULL, NULL, 'ROOM_TYPE_CHECKUP_ORDERS_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(231, NULL, NULL, 'ROOM_TYPE_CHECKUP_TOTAL_ROOMS_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(232, NULL, NULL, 'ROOM_TYPE_CHECKUP_TOTAL_ROOMS_GT', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(233, NULL, NULL, 'SERVICE_CHECKUP_DESCRIPTIONS_SHORT_LT', '50', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(234, NULL, NULL, 'SERVICE_CHECKUP_DESCRIPTIONS_GT', '150', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(235, NULL, NULL, 'SERVICE_CHECKUP_IMAGES_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(236, NULL, NULL, 'SERVICE_CHECKUP_IMAGES_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(237, NULL, NULL, 'SERVICE_CHECKUP_ORDERS_LT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(238, NULL, NULL, 'SERVICE_CHECKUP_ORDERS_GT', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(239, NULL, NULL, 'FOOTER_CMS', '0_3|0_4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(240, NULL, NULL, 'FOOTER_BLOCK_ACTIVATION', '0_3|0_4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(241, NULL, NULL, 'FOOTER_POWEREDBY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(242, NULL, NULL, 'BLOCKADVERT_LINK', 'https://qloapps.com/', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(243, NULL, NULL, 'BLOCKADVERT_IMG_EXT', 'jpg', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(244, NULL, NULL, 'MOD_BLOCKTOPMENU_ITEMS', 'CAT3,CAT8,CAT5,LNK1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(245, NULL, NULL, 'MOD_BLOCKTOPMENU_SEARCH', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(246, NULL, NULL, 'BLOCKSOCIAL_FACEBOOK', 'https://www.facebook.com/qloapps', '0000-00-00 00:00:00', '[[regtime]]'),
(247, NULL, NULL, 'BLOCKSOCIAL_TWITTER', 'https://twitter.com/qloapps', '0000-00-00 00:00:00', '[[regtime]]'),
(248, NULL, NULL, 'SUPPLIER_DISPLAY_TEXT', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(249, NULL, NULL, 'SUPPLIER_DISPLAY_TEXT_NB', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(250, NULL, NULL, 'SUPPLIER_DISPLAY_FORM', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(251, NULL, NULL, 'BLOCK_CATEG_NBR_COLUMN_FOOTER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(252, NULL, NULL, 'UPGRADER_BACKUPDB_FILENAME', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(253, NULL, NULL, 'UPGRADER_BACKUPFILES_FILENAME', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(254, NULL, NULL, 'BLOCKREINSURANCE_NBBLOCKS', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(255, NULL, NULL, 'PS_BASE_DISTANCE_UNIT', 'm', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(256, NULL, NULL, 'PS_SHOP_DOMAIN', '[[punycode_domhost]]', '0000-00-00 00:00:00', '[[regtime]]'),
(257, NULL, NULL, 'PS_SHOP_DOMAIN_SSL', '[[punycode_domhost]]', '0000-00-00 00:00:00', '[[regtime]]'),
(258, NULL, NULL, 'PS_SHOP_NAME', '[[store_name]]', '0000-00-00 00:00:00', '[[regtime]]'),
(259, NULL, NULL, 'PS_SHOP_EMAIL', '[[admin_email]]', '0000-00-00 00:00:00', '[[regtime]]'),
(260, NULL, NULL, 'PS_MAIL_METHOD', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(261, NULL, NULL, 'PS_SHOP_ACTIVITY', NULL, '0000-00-00 00:00:00', '[[regtime]]'),
(262, NULL, NULL, 'PS_LOGO', 'logo.jpg', '0000-00-00 00:00:00', '[[regtime]]'),
(263, NULL, NULL, 'PS_FAVICON', 'favicon.ico', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(264, NULL, NULL, 'PS_STORES_ICON', 'logo_stores.gif', '0000-00-00 00:00:00', '[[regtime]]'),
(265, NULL, NULL, 'PS_ROOT_CATEGORY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(266, NULL, NULL, 'PS_HOME_CATEGORY', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(267, NULL, NULL, 'PS_LOCATIONS_CATEGORY', '3', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(268, NULL, NULL, 'PS_SERVICE_CATEGORY', '4', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(269, NULL, NULL, 'PS_CONFIGURATION_AGREMENT', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(270, NULL, NULL, 'PS_MAIL_SERVER', 'smtp.', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(271, NULL, NULL, 'PS_MAIL_USER', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(272, NULL, NULL, 'PS_MAIL_PASSWD', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(273, NULL, NULL, 'PS_MAIL_SMTP_ENCRYPTION', 'off', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(274, NULL, NULL, 'PS_MAIL_SMTP_PORT', '25', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(275, NULL, NULL, 'PS_MAIL_COLOR', '#db3484', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(276, NULL, NULL, 'NW_SALT', '[[NW_SALT]]', '0000-00-00 00:00:00', '[[regtime]]'),
(277, NULL, NULL, 'PS_PAYMENT_LOGO_CMS_ID', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(278, NULL, NULL, 'HOME_FEATURED_NBR', '8', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(279, NULL, NULL, 'SEK_MIN_OCCURENCES', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(280, NULL, NULL, 'SEK_FILTER_KW', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(281, NULL, NULL, 'PS_ALLOW_MOBILE_DEVICE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(282, NULL, NULL, 'PS_CUSTOMER_CREATION_EMAIL', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(283, NULL, NULL, 'PS_SMARTY_CONSOLE_KEY', 'SMARTY_DEBUG', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(284, NULL, NULL, 'PS_DASHBOARD_USE_PUSH', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(285, NULL, NULL, 'PS_ATTRIBUTE_ANCHOR_SEPARATOR', '-', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(286, NULL, NULL, 'CONF_AVERAGE_PRODUCT_MARGIN', '40', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(287, NULL, NULL, 'PS_DASHBOARD_SIMULATION', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(288, NULL, NULL, 'PS_QUICK_VIEW', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(289, NULL, NULL, 'PS_USE_HTMLPURIFIER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(290, NULL, NULL, 'PS_SMARTY_CACHING_TYPE', 'filesystem', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(291, NULL, NULL, 'PS_SMARTY_CLEAR_CACHE', 'everytime', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(292, NULL, NULL, 'PS_DETECT_LANG', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(293, NULL, NULL, 'PS_DETECT_COUNTRY', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(294, NULL, NULL, 'PS_ROUND_TYPE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(295, NULL, NULL, 'PS_PRICE_DISPLAY_PRECISION', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(296, NULL, NULL, 'PS_LOG_EMAILS', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(297, NULL, NULL, 'PS_CUSTOMER_BIRTHDATE', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(298, NULL, NULL, 'PS_CUSTOMER_NWSL', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(299, NULL, NULL, 'PS_CUSTOMER_OPTIN', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(300, NULL, NULL, 'PS_KPI_FREQUENT_CUSTOMER_NB_ORDERS', '5', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(301, NULL, NULL, 'PS_KPI_REVPAC_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(302, NULL, NULL, 'PS_KPI_CONVERSION_RATE_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(303, NULL, NULL, 'PS_ORDER_KPI_AVG_ORDER_VALUE_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(304, NULL, NULL, 'PS_ORDER_KPI_PER_VISITOR_PROFIT_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(305, NULL, NULL, 'PS_KPI_NEW_CUSTOMERS_NB_DAYS', '30', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(306, NULL, NULL, 'PS_PACK_STOCK_TYPE', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(307, NULL, NULL, 'PS_LOG_MODULE_PERFS_MODULO', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(308, NULL, NULL, 'PS_DISALLOW_HISTORY_REORDERING', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(309, NULL, NULL, 'PS_DISPLAY_PRODUCT_WEIGHT', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(310, NULL, NULL, 'PS_PRODUCT_WEIGHT_PRECISION', '2', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(311, NULL, NULL, 'PS_ADVANCED_PAYMENT_API', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(312, NULL, NULL, 'PS_SERVICE_PRODUCT_CATEGORY_FILTER', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(313, NULL, NULL, 'PS_BACKDATE_ORDER_SUPERADMIN', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(314, NULL, NULL, 'PS_BACKDATE_ORDER_EMPLOYEES', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(315, NULL, NULL, 'PS_SSL_ENABLED_EVERYWHERE', '[[PS_SSL_ENABLED_EVERYWHERE]]', '[[regtime]]', '[[regtime]]'),
(316, NULL, NULL, 'PRICE_DISPLAY_METHOD', '1', '[[regtime]]', '[[regtime]]'),
(317, NULL, NULL, 'WK_HOTEL_LOCATION_ENABLE', '1', '[[regtime]]', '[[regtime]]'),
(318, NULL, NULL, 'WK_HOTEL_NAME_ENABLE', '1', '[[regtime]]', '[[regtime]]'),
(319, NULL, NULL, 'WK_HOTEL_NAME_SEARCH_THRESHOLD', '5', '[[regtime]]', '[[regtime]]'),
(320, NULL, NULL, 'WK_SEARCH_AUTO_FOCUS_NEXT_FIELD', '1', '[[regtime]]', '[[regtime]]'),
(321, NULL, NULL, 'WK_ROOM_LEFT_WARNING_NUMBER', '10', '[[regtime]]', '[[regtime]]'),
(322, NULL, NULL, 'WK_HTL_ESTABLISHMENT_YEAR', '2010', '[[regtime]]', '[[regtime]]'),
(323, NULL, NULL, 'WK_HOTEL_GLOBAL_ADDRESS', 'The Hotel Prime, Monticello Dr, Montgomery, 10010', '[[regtime]]', '[[regtime]]'),
(324, NULL, NULL, 'WK_HOTEL_GLOBAL_CONTACT_NUMBER', '0987654321', '[[regtime]]', '[[regtime]]'),
(325, NULL, NULL, 'WK_HOTEL_GLOBAL_CONTACT_EMAIL', 'hotelprime@htl.com', '[[regtime]]', '[[regtime]]'),
(326, NULL, NULL, 'WK_CUSTOMER_SUPPORT_PHONE_NUMBER', '0987654321', '[[regtime]]', '[[regtime]]'),
(327, NULL, NULL, 'WK_CUSTOMER_SUPPORT_EMAIL', 'hotelprime@htl.com', '[[regtime]]', '[[regtime]]'),
(328, NULL, NULL, 'WK_TITLE_HEADER_BLOCK', 'Hotel Prime', '[[regtime]]', '[[regtime]]'),
(329, NULL, NULL, 'WK_CONTENT_HEADER_BLOCK', 'Our hotel is the perfect destination for both business and leisure travelers seeking a memorable stay.', '[[regtime]]', '[[regtime]]'),
(330, NULL, NULL, 'WK_HOTEL_HEADER_IMAGE', 'hotel_header_image.jpg', '[[regtime]]', '[[regtime]]'),
(331, NULL, NULL, 'WK_ALLOW_ADVANCED_PAYMENT', '1', '[[regtime]]', '[[regtime]]'),
(332, NULL, NULL, 'WK_ADVANCED_PAYMENT_GLOBAL_MIN_AMOUNT', '10', '[[regtime]]', '[[regtime]]'),
(333, NULL, NULL, 'WK_ADVANCED_PAYMENT_INC_TAX', '1', '[[regtime]]', '[[regtime]]'),
(334, NULL, NULL, 'WK_GLOBAL_CHILD_MAX_AGE', '15', '[[regtime]]', '[[regtime]]'),
(335, NULL, NULL, 'WK_GLOBAL_MAX_CHILD_IN_ROOM', '0', '[[regtime]]', '[[regtime]]'),
(336, NULL, NULL, 'MAX_GLOBAL_BOOKING_DATE', '[[max_global_booking_date]]', '[[regtime]]', '[[regtime]]'),
(337, NULL, NULL, 'GLOBAL_PREPARATION_TIME', '0', '[[regtime]]', '[[regtime]]'),
(338, NULL, NULL, 'HTL_FEATURE_PRICING_PRIORITY', 'specific_date;special_day;date_range', '[[regtime]]', '[[regtime]]'),
(339, NULL, NULL, 'WK_GOOGLE_ACTIVE_MAP', '0', '[[regtime]]', '[[regtime]]'),
(340, NULL, NULL, 'WK_MAP_HOTEL_ACTIVE_ONLY', '1', '[[regtime]]', '[[regtime]]'),
(341, NULL, NULL, 'PS_LOGO_MAIL', 'logo_mail.jpg', '[[regtime]]', '[[regtime]]'),
(342, NULL, NULL, 'PS_LOGO_INVOICE', 'logo_invoice.jpg', '[[regtime]]', '[[regtime]]'),
(343, NULL, NULL, 'WK_HTL_CHAIN_NAME', NULL, '[[regtime]]', '[[regtime]]'),
(344, NULL, NULL, 'WK_HTL_TAG_LINE', NULL, '[[regtime]]', '[[regtime]]'),
(345, NULL, NULL, 'WK_HTL_SHORT_DESC', NULL, '[[regtime]]', '[[regtime]]'),
(346, NULL, NULL, 'PS_FRONT_SEARCH_TYPE', '1', '[[regtime]]', '[[regtime]]'),
(347, NULL, NULL, 'PS_FRONT_OWS_SEARCH_ALGO_TYPE', '1', '[[regtime]]', '[[regtime]]'),
(348, NULL, NULL, 'PS_FRONT_ROOM_UNIT_SELECTION_TYPE', '1', '[[regtime]]', '[[regtime]]'),
(349, NULL, NULL, 'PS_BACKOFFICE_SEARCH_TYPE', '1', '[[regtime]]', '[[regtime]]'),
(350, NULL, NULL, 'PS_BACKOFFICE_OWS_SEARCH_ALGO_TYPE', '2', '[[regtime]]', '[[regtime]]'),
(351, NULL, NULL, 'PS_BACKOFFICE_ROOM_BOOKING_TYPE', '1', '[[regtime]]', '[[regtime]]'),
(352, NULL, NULL, 'WK_PRIMARY_HOTEL', '1', '[[regtime]]', '[[regtime]]'),
(353, NULL, NULL, 'BLOCKSOCIAL_RSS', NULL, '[[regtime]]', '[[regtime]]'),
(354, NULL, NULL, 'BLOCKSOCIAL_YOUTUBE', NULL, '[[regtime]]', '[[regtime]]'),
(355, NULL, NULL, 'BLOCKSOCIAL_PINTEREST', NULL, '[[regtime]]', '[[regtime]]'),
(356, NULL, NULL, 'BLOCKSOCIAL_VIMEO', NULL, '[[regtime]]', '[[regtime]]'),
(357, NULL, NULL, 'BLOCKSOCIAL_INSTAGRAM', NULL, '[[regtime]]', '[[regtime]]'),
(358, NULL, NULL, 'SHOW_AMENITIES_FILTER', '1', '[[regtime]]', '[[regtime]]'),
(359, NULL, NULL, 'SHOW_PRICE_FILTER', '1', '[[regtime]]', '[[regtime]]'),
(360, NULL, NULL, 'HOTEL_INTERIOR_HEADING', NULL, '[[regtime]]', '[[regtime]]'),
(361, NULL, NULL, 'HOTEL_INTERIOR_DESCRIPTION', NULL, '[[regtime]]', '[[regtime]]'),
(362, NULL, NULL, 'HOTEL_AMENITIES_HEADING', NULL, '[[regtime]]', '[[regtime]]'),
(363, NULL, NULL, 'HOTEL_AMENITIES_DESCRIPTION', NULL, '[[regtime]]', '[[regtime]]'),
(364, NULL, NULL, 'HOTEL_ROOM_DISPLAY_HEADING', NULL, '[[regtime]]', '[[regtime]]'),
(365, NULL, NULL, 'HOTEL_ROOM_DISPLAY_DESCRIPTION', NULL, '[[regtime]]', '[[regtime]]'),
(366, NULL, NULL, 'HOTEL_TESIMONIAL_BLOCK_HEADING', NULL, '[[regtime]]', '[[regtime]]'),
(367, NULL, NULL, 'HOTEL_TESIMONIAL_BLOCK_CONTENT', NULL, '[[regtime]]', '[[regtime]]'),
(368, NULL, NULL, 'CONF_BANKWIRE_FIXED', '0.2', '[[regtime]]', '[[regtime]]'),
(369, NULL, NULL, 'CONF_BANKWIRE_VAR', '2', '[[regtime]]', '[[regtime]]'),
(370, NULL, NULL, 'CONF_BANKWIRE_FIXED_FOREIGN', '0.2', '[[regtime]]', '[[regtime]]'),
(371, NULL, NULL, 'CONF_BANKWIRE_VAR_FOREIGN', '2', '[[regtime]]', '[[regtime]]'),
(372, NULL, NULL, 'CONF_CHEQUE_FIXED', '0.2', '[[regtime]]', '[[regtime]]'),
(373, NULL, NULL, 'CONF_CHEQUE_VAR', '2', '[[regtime]]', '[[regtime]]'),
(374, NULL, NULL, 'CONF_CHEQUE_FIXED_FOREIGN', '0.2', '[[regtime]]', '[[regtime]]'),
(375, NULL, NULL, 'CONF_CHEQUE_VAR_FOREIGN', '2', '[[regtime]]', '[[regtime]]'),
(376, NULL, NULL, 'QHR_ADMIN_APPROVAL_ENABLED', '1', '[[regtime]]', '[[regtime]]'),
(377, NULL, NULL, 'QHR_MAX_IMAGES_PER_REVIEW', '5', '[[regtime]]', '[[regtime]]'),
(378, NULL, NULL, 'QHR_REVIEWS_AT_ONCE', '5', '[[regtime]]', '[[regtime]]'),
(379, NULL, NULL, 'QHR_REVIEW_APPROVAL_EMAIL_ENABLED', '0', '[[regtime]]', '[[regtime]]'),
(380, NULL, NULL, 'QHR_REVIEW_MGMT_REPLY_EMAIL_ENABLED', '0', '[[regtime]]', '[[regtime]]'),
(381, NULL, NULL, 'WK_SHOW_FOOTER_NAVIGATION_BLOCK', '1', '[[regtime]]', '[[regtime]]'),
(382, NULL, NULL, 'DASHACTIVITY_CART_ACTIVE', '30', '[[regtime]]', '[[regtime]]'),
(383, NULL, NULL, 'DASHACTIVITY_CART_ABANDONED_MIN', '24', '[[regtime]]', '[[regtime]]'),
(384, NULL, NULL, 'DASHACTIVITY_CART_ABANDONED_MAX', '48', '[[regtime]]', '[[regtime]]'),
(385, NULL, NULL, 'DASHACTIVITY_VISITOR_ONLINE', '30', '[[regtime]]', '[[regtime]]'),
(386, NULL, NULL, 'DASHPRODUCT_NBR_SHOW_LAST_ORDER', '10', '[[regtime]]', '[[regtime]]'),
(387, NULL, NULL, 'DASHPRODUCT_NBR_SHOW_BEST_SELLER', '10', '[[regtime]]', '[[regtime]]'),
(388, NULL, NULL, 'DASHPRODUCT_NBR_SHOW_MOST_VIEWED', '10', '[[regtime]]', '[[regtime]]'),
(389, NULL, NULL, 'DASHPRODUCT_NBR_SHOW_TOP_SEARCH', '10', '[[regtime]]', '[[regtime]]'),
(390, NULL, NULL, 'PS_DASHGOALS_CURRENT_YEAR', '[[ps_dashgoals_current_year]]', '[[regtime]]', '[[regtime]]'),
(391, NULL, NULL, 'PS_BLOCK_CART_XSELL_LIMIT', '12', '[[regtime]]', '[[regtime]]'),
(392, NULL, NULL, 'PS_BLOCK_CART_SHOW_CROSSSELLING', '1', '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]configuration_kpi`
--
CREATE TABLE `[[dbprefix]]configuration_kpi` (
`id_configuration_kpi` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned DEFAULT NULL,
`id_shop` int(11) unsigned DEFAULT NULL,
`name` varchar(64) NOT NULL,
`value` text,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_configuration_kpi`),
KEY `name` (`name`),
KEY `id_shop` (`id_shop`),
KEY `id_shop_group` (`id_shop_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
--
-- Dumping data for table `[[dbprefix]]configuration_kpi`
--
INSERT INTO `[[dbprefix]]configuration_kpi` VALUES
(1, NULL, NULL, 'DASHGOALS_TRAFFIC_01_2024', '600', '[[regtime]]', '[[regtime]]'),
(2, NULL, NULL, 'DASHGOALS_CONVERSION_01_2024', '2', '[[regtime]]', '[[regtime]]'),
(3, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_01_2024', '80', '[[regtime]]', '[[regtime]]'),
(4, NULL, NULL, 'DASHGOALS_TRAFFIC_02_2024', '600', '[[regtime]]', '[[regtime]]'),
(5, NULL, NULL, 'DASHGOALS_CONVERSION_02_2024', '2', '[[regtime]]', '[[regtime]]'),
(6, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_02_2024', '80', '[[regtime]]', '[[regtime]]'),
(7, NULL, NULL, 'DASHGOALS_TRAFFIC_03_2024', '600', '[[regtime]]', '[[regtime]]'),
(8, NULL, NULL, 'DASHGOALS_CONVERSION_03_2024', '2', '[[regtime]]', '[[regtime]]'),
(9, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_03_2024', '80', '[[regtime]]', '[[regtime]]'),
(10, NULL, NULL, 'DASHGOALS_TRAFFIC_04_2024', '600', '[[regtime]]', '[[regtime]]'),
(11, NULL, NULL, 'DASHGOALS_CONVERSION_04_2024', '2', '[[regtime]]', '[[regtime]]'),
(12, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_04_2024', '80', '[[regtime]]', '[[regtime]]'),
(13, NULL, NULL, 'DASHGOALS_TRAFFIC_05_2024', '600', '[[regtime]]', '[[regtime]]'),
(14, NULL, NULL, 'DASHGOALS_CONVERSION_05_2024', '2', '[[regtime]]', '[[regtime]]'),
(15, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_05_2024', '80', '[[regtime]]', '[[regtime]]'),
(16, NULL, NULL, 'DASHGOALS_TRAFFIC_06_2024', '600', '[[regtime]]', '[[regtime]]'),
(17, NULL, NULL, 'DASHGOALS_CONVERSION_06_2024', '2', '[[regtime]]', '[[regtime]]'),
(18, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_06_2024', '80', '[[regtime]]', '[[regtime]]'),
(19, NULL, NULL, 'DASHGOALS_TRAFFIC_07_2024', '600', '[[regtime]]', '[[regtime]]'),
(20, NULL, NULL, 'DASHGOALS_CONVERSION_07_2024', '2', '[[regtime]]', '[[regtime]]'),
(21, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_07_2024', '80', '[[regtime]]', '[[regtime]]'),
(22, NULL, NULL, 'DASHGOALS_TRAFFIC_08_2024', '600', '[[regtime]]', '[[regtime]]'),
(23, NULL, NULL, 'DASHGOALS_CONVERSION_08_2024', '2', '[[regtime]]', '[[regtime]]'),
(24, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_08_2024', '80', '[[regtime]]', '[[regtime]]'),
(25, NULL, NULL, 'DASHGOALS_TRAFFIC_09_2024', '600', '[[regtime]]', '[[regtime]]'),
(26, NULL, NULL, 'DASHGOALS_CONVERSION_09_2024', '2', '[[regtime]]', '[[regtime]]'),
(27, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_09_2024', '80', '[[regtime]]', '[[regtime]]'),
(28, NULL, NULL, 'DASHGOALS_TRAFFIC_10_2024', '600', '[[regtime]]', '[[regtime]]'),
(29, NULL, NULL, 'DASHGOALS_CONVERSION_10_2024', '2', '[[regtime]]', '[[regtime]]'),
(30, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_10_2024', '80', '[[regtime]]', '[[regtime]]'),
(31, NULL, NULL, 'DASHGOALS_TRAFFIC_11_2024', '600', '[[regtime]]', '[[regtime]]'),
(32, NULL, NULL, 'DASHGOALS_CONVERSION_11_2024', '2', '[[regtime]]', '[[regtime]]'),
(33, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_11_2024', '80', '[[regtime]]', '[[regtime]]'),
(34, NULL, NULL, 'DASHGOALS_TRAFFIC_12_2024', '600', '[[regtime]]', '[[regtime]]'),
(35, NULL, NULL, 'DASHGOALS_CONVERSION_12_2024', '2', '[[regtime]]', '[[regtime]]'),
(36, NULL, NULL, 'DASHGOALS_AVG_CART_VALUE_12_2024', '80', '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]configuration_kpi_lang`
--
CREATE TABLE `[[dbprefix]]configuration_kpi_lang` (
`id_configuration_kpi` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`value` text,
`date_upd` datetime DEFAULT NULL,
PRIMARY KEY (`id_configuration_kpi`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]configuration_lang`
--
CREATE TABLE `[[dbprefix]]configuration_lang` (
`id_configuration` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`value` text,
`date_upd` datetime DEFAULT NULL,
PRIMARY KEY (`id_configuration`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]configuration_lang`
--
INSERT INTO `[[dbprefix]]configuration_lang` VALUES
(46, 1, '#IN', NULL),
(49, 1, '#DE', NULL),
(51, 1, '#RE', NULL),
(57, 1, 'a|about|above|after|again|against|all|am|an|and|any|are|aren|as|at|be|because|been|before|being|below|between|both|but|by|can|cannot|could|couldn|did|didn|do|does|doesn|doing|don|down|during|each|few|for|from|further|had|hadn|has|hasn|have|haven|having|he|ll|her|here|hers|herself|him|himself|his|how|ve|if|in|into|is|isn|it|its|itself|let|me|more|most|mustn|my|myself|no|nor|not|of|off|on|once|only|or|other|ought|our|ours|ourselves|out|over|own|same|shan|she|should|shouldn|so|some|such|than|that|the|their|theirs|them|themselves|then|there|these|they|re|this|those|through|to|too|under|until|up|very|was|wasn|we|were|weren|what|when|where|which|while|who|whom|why|with|won|would|wouldn|you|your|yours|yourself|yourselves', NULL),
(80, 1, '0', NULL),
(86, 1, 'Dear Customer,\r\n\r\nRegards,\r\nCustomer service', NULL),
(343, 1, 'Hotel Prime', '[[regtime]]'),
(344, 1, 'A place where comfort and luxury are blended with nature!', '[[regtime]]'),
(345, 1, 'We offer elegant rooms, gourmet dining, and attentive service for a memorable stay.', '[[regtime]]'),
(360, 1, 'Explore the Interiors!', '[[regtime]]'),
(361, 1, 'Step into the sophisticated elegance of our hotel, where every detail is designed with your comfort in mind.', '[[regtime]]'),
(362, 1, 'Amenities', '[[regtime]]'),
(363, 1, 'Experience luxury at our hotel with top-notch amenities. Enjoy our fitness center, rejuvenating spa, serene outdoor pool, and exquisite dining.', '[[regtime]]'),
(364, 1, 'Our Rooms', '[[regtime]]'),
(365, 1, 'Relax in the comfort of our rooms. With modern amenities, serene decor, and stunning lake or city views, each room offers a peaceful retreat for your stay.', '[[regtime]]'),
(366, 1, 'What our guests say?', '[[regtime]]'),
(367, 1, 'Here are some valuable feedbacks from our guests.', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]connections`
--
CREATE TABLE `[[dbprefix]]connections` (
`id_connections` 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_guest` int(10) unsigned NOT NULL,
`id_page` int(10) unsigned NOT NULL,
`ip_address` bigint(20) DEFAULT NULL,
`date_add` datetime NOT NULL,
`http_referer` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_connections`),
KEY `id_guest` (`id_guest`),
KEY `date_add` (`date_add`),
KEY `id_page` (`id_page`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]connections`
--
INSERT INTO `[[dbprefix]]connections` VALUES
(1, 1, 1, 1, 1, 2130706433, '[[regtime]]', 'https://www.qloapps.com');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]connections_page`
--
CREATE TABLE `[[dbprefix]]connections_page` (
`id_connections` int(10) unsigned NOT NULL,
`id_page` int(10) unsigned NOT NULL,
`time_start` datetime NOT NULL,
`time_end` datetime DEFAULT NULL,
PRIMARY KEY (`id_connections`,`id_page`,`time_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]connections_source`
--
CREATE TABLE `[[dbprefix]]connections_source` (
`id_connections_source` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_connections` int(10) unsigned NOT NULL,
`http_referer` varchar(255) DEFAULT NULL,
`request_uri` varchar(255) DEFAULT NULL,
`keywords` varchar(255) DEFAULT NULL,
`date_add` datetime NOT NULL,
PRIMARY KEY (`id_connections_source`),
KEY `connections` (`id_connections`),
KEY `orderby` (`date_add`),
KEY `http_referer` (`http_referer`),
KEY `request_uri` (`request_uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]contact`
--
CREATE TABLE `[[dbprefix]]contact` (
`id_contact` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(128) NOT NULL,
`customer_service` tinyint(1) NOT NULL DEFAULT '0',
`position` tinyint(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]contact`
--
INSERT INTO `[[dbprefix]]contact` VALUES
(1, '[[admin_email]]', 1, 0),
(2, '[[admin_email]]', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]contact_lang`
--
CREATE TABLE `[[dbprefix]]contact_lang` (
`id_contact` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(32) NOT NULL,
`description` text,
PRIMARY KEY (`id_contact`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]contact_lang`
--
INSERT INTO `[[dbprefix]]contact_lang` VALUES
(1, 1, 'Webmaster', 'If a technical problem occurs on this website'),
(2, 1, 'Customer service', 'For any query regarding a hotel or a booking');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]contact_shop`
--
CREATE TABLE `[[dbprefix]]contact_shop` (
`id_contact` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_contact`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]contact_shop`
--
INSERT INTO `[[dbprefix]]contact_shop` VALUES
(1, 1),
(2, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]country`
--
CREATE TABLE `[[dbprefix]]country` (
`id_country` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_zone` int(10) unsigned NOT NULL,
`id_currency` int(10) unsigned NOT NULL DEFAULT '0',
`iso_code` varchar(3) NOT NULL,
`call_prefix` int(10) NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`contains_states` tinyint(1) NOT NULL DEFAULT '0',
`need_identification_number` tinyint(1) NOT NULL DEFAULT '0',
`need_zip_code` tinyint(1) NOT NULL DEFAULT '1',
`zip_code_format` varchar(12) NOT NULL DEFAULT '',
`display_tax_label` tinyint(1) NOT NULL,
PRIMARY KEY (`id_country`),
KEY `country_iso_code` (`iso_code`),
KEY `country_` (`id_zone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=245 ;
--
-- Dumping data for table `[[dbprefix]]country`
--
INSERT INTO `[[dbprefix]]country` VALUES
(1, 1, 0, 'DE', 49, 0, 0, 0, 1, 'NNNNN', 1),
(2, 1, 0, 'AT', 43, 0, 0, 0, 1, 'NNNN', 1),
(3, 1, 0, 'BE', 32, 0, 0, 0, 1, 'NNNN', 1),
(4, 2, 0, 'CA', 1, 0, 1, 0, 1, 'LNL NLN', 0),
(5, 3, 0, 'CN', 86, 0, 0, 0, 1, 'NNNNNN', 1),
(6, 1, 0, 'ES', 34, 0, 0, 1, 1, 'NNNNN', 1),
(7, 1, 0, 'FI', 358, 0, 0, 0, 1, 'NNNNN', 1),
(8, 1, 0, 'FR', 33, 0, 0, 0, 1, 'NNNNN', 1),
(9, 1, 0, 'GR', 30, 0, 0, 0, 1, 'NNNNN', 1),
(10, 1, 0, 'IT', 39, 0, 1, 0, 1, 'NNNNN', 1),
(11, 3, 0, 'JP', 81, 0, 1, 0, 1, 'NNN-NNNN', 1),
(12, 1, 0, 'LU', 352, 0, 0, 0, 1, 'NNNN', 1),
(13, 1, 0, 'NL', 31, 0, 0, 0, 1, 'NNNN LL', 1),
(14, 1, 0, 'PL', 48, 0, 0, 0, 1, 'NN-NNN', 1),
(15, 1, 0, 'PT', 351, 0, 0, 0, 1, 'NNNN-NNN', 1),
(16, 1, 0, 'CZ', 420, 0, 0, 0, 1, 'NNN NN', 1),
(17, 1, 0, 'GB', 44, 0, 0, 0, 1, '', 1),
(18, 1, 0, 'SE', 46, 0, 0, 0, 1, 'NNN NN', 1),
(19, 7, 0, 'CH', 41, 0, 0, 0, 1, 'NNNN', 1),
(20, 1, 0, 'DK', 45, 0, 0, 0, 1, 'NNNN', 1),
(21, 2, 0, 'US', 1, 1, 1, 0, 1, 'NNNNN', 0),
(22, 3, 0, 'HK', 852, 0, 0, 0, 0, '', 1),
(23, 7, 0, 'NO', 47, 0, 0, 0, 1, 'NNNN', 1),
(24, 5, 0, 'AU', 61, 0, 0, 0, 1, 'NNNN', 1),
(25, 3, 0, 'SG', 65, 0, 0, 0, 1, 'NNNNNN', 1),
(26, 1, 0, 'IE', 353, 0, 0, 0, 0, '', 1),
(27, 5, 0, 'NZ', 64, 0, 0, 0, 1, 'NNNN', 1),
(28, 3, 0, 'KR', 82, 0, 0, 0, 1, 'NNNNN', 1),
(29, 3, 0, 'IL', 972, 0, 0, 0, 1, 'NNNNNNN', 1),
(30, 4, 0, 'ZA', 27, 0, 0, 0, 1, 'NNNN', 1),
(31, 4, 0, 'NG', 234, 0, 0, 0, 1, '', 1),
(32, 4, 0, 'CI', 225, 0, 0, 0, 1, '', 1),
(33, 4, 0, 'TG', 228, 0, 0, 0, 1, '', 1),
(34, 6, 0, 'BO', 591, 0, 0, 0, 1, '', 1),
(35, 4, 0, 'MU', 230, 0, 0, 0, 1, '', 1),
(36, 1, 0, 'RO', 40, 0, 0, 0, 1, 'NNNNNN', 1),
(37, 1, 0, 'SK', 421, 0, 0, 0, 1, 'NNN NN', 1),
(38, 4, 0, 'DZ', 213, 0, 0, 0, 1, 'NNNNN', 1),
(39, 2, 0, 'AS', 0, 0, 0, 0, 1, '', 1),
(40, 7, 0, 'AD', 376, 0, 0, 0, 1, 'CNNN', 1),
(41, 4, 0, 'AO', 244, 0, 0, 0, 0, '', 1),
(42, 8, 0, 'AI', 0, 0, 0, 0, 1, '', 1),
(43, 2, 0, 'AG', 0, 0, 0, 0, 1, '', 1),
(44, 6, 0, 'AR', 54, 0, 1, 0, 1, 'LNNNNLLL', 1),
(45, 3, 0, 'AM', 374, 0, 0, 0, 1, 'NNNN', 1),
(46, 8, 0, 'AW', 297, 0, 0, 0, 1, '', 1),
(47, 3, 0, 'AZ', 994, 0, 0, 0, 1, 'CNNNN', 1),
(48, 2, 0, 'BS', 0, 0, 0, 0, 1, '', 1),
(49, 3, 0, 'BH', 973, 0, 0, 0, 1, '', 1),
(50, 3, 0, 'BD', 880, 0, 0, 0, 1, 'NNNN', 1),
(51, 2, 0, 'BB', 0, 0, 0, 0, 1, 'CNNNNN', 1),
(52, 7, 0, 'BY', 0, 0, 0, 0, 1, 'NNNNNN', 1),
(53, 8, 0, 'BZ', 501, 0, 0, 0, 0, '', 1),
(54, 4, 0, 'BJ', 229, 0, 0, 0, 0, '', 1),
(55, 2, 0, 'BM', 0, 0, 0, 0, 1, '', 1),
(56, 3, 0, 'BT', 975, 0, 0, 0, 1, '', 1),
(57, 4, 0, 'BW', 267, 0, 0, 0, 1, '', 1),
(58, 6, 0, 'BR', 55, 0, 0, 0, 1, 'NNNNN-NNN', 1),
(59, 3, 0, 'BN', 673, 0, 0, 0, 1, 'LLNNNN', 1),
(60, 4, 0, 'BF', 226, 0, 0, 0, 1, '', 1),
(61, 3, 0, 'MM', 95, 0, 0, 0, 1, '', 1),
(62, 4, 0, 'BI', 257, 0, 0, 0, 1, '', 1),
(63, 3, 0, 'KH', 855, 0, 0, 0, 1, 'NNNNN', 1),
(64, 4, 0, 'CM', 237, 0, 0, 0, 1, '', 1),
(65, 4, 0, 'CV', 238, 0, 0, 0, 1, 'NNNN', 1),
(66, 4, 0, 'CF', 236, 0, 0, 0, 1, '', 1),
(67, 4, 0, 'TD', 235, 0, 0, 0, 1, '', 1),
(68, 6, 0, 'CL', 56, 0, 0, 0, 1, 'NNN-NNNN', 1),
(69, 6, 0, 'CO', 57, 0, 0, 0, 1, 'NNNNNN', 1),
(70, 4, 0, 'KM', 269, 0, 0, 0, 1, '', 1),
(71, 4, 0, 'CD', 242, 0, 0, 0, 1, '', 1),
(72, 4, 0, 'CG', 243, 0, 0, 0, 1, '', 1),
(73, 8, 0, 'CR', 506, 0, 0, 0, 1, 'NNNNN', 1),
(74, 7, 0, 'HR', 385, 0, 0, 0, 1, 'NNNNN', 1),
(75, 8, 0, 'CU', 53, 0, 0, 0, 1, '', 1),
(76, 1, 0, 'CY', 357, 0, 0, 0, 1, 'NNNN', 1),
(77, 4, 0, 'DJ', 253, 0, 0, 0, 1, '', 1),
(78, 8, 0, 'DM', 0, 0, 0, 0, 1, '', 1),
(79, 8, 0, 'DO', 0, 0, 0, 0, 1, '', 1),
(80, 3, 0, 'TL', 670, 0, 0, 0, 1, '', 1),
(81, 6, 0, 'EC', 593, 0, 0, 0, 1, 'CNNNNNN', 1),
(82, 4, 0, 'EG', 20, 0, 0, 0, 1, 'NNNNN', 1),
(83, 8, 0, 'SV', 503, 0, 0, 0, 1, '', 1),
(84, 4, 0, 'GQ', 240, 0, 0, 0, 1, '', 1),
(85, 4, 0, 'ER', 291, 0, 0, 0, 1, '', 1),
(86, 1, 0, 'EE', 372, 0, 0, 0, 1, 'NNNNN', 1),
(87, 4, 0, 'ET', 251, 0, 0, 0, 1, '', 1),
(88, 8, 0, 'FK', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
(89, 7, 0, 'FO', 298, 0, 0, 0, 1, '', 1),
(90, 5, 0, 'FJ', 679, 0, 0, 0, 1, '', 1),
(91, 4, 0, 'GA', 241, 0, 0, 0, 1, '', 1),
(92, 4, 0, 'GM', 220, 0, 0, 0, 1, '', 1),
(93, 3, 0, 'GE', 995, 0, 0, 0, 1, 'NNNN', 1),
(94, 4, 0, 'GH', 233, 0, 0, 0, 1, '', 1),
(95, 8, 0, 'GD', 0, 0, 0, 0, 1, '', 1),
(96, 7, 0, 'GL', 299, 0, 0, 0, 1, '', 1),
(97, 7, 0, 'GI', 350, 0, 0, 0, 1, '', 1),
(98, 8, 0, 'GP', 590, 0, 0, 0, 1, '', 1),
(99, 5, 0, 'GU', 0, 0, 0, 0, 1, '', 1),
(100, 8, 0, 'GT', 502, 0, 0, 0, 1, '', 1),
(101, 7, 0, 'GG', 0, 0, 0, 0, 1, 'LLN NLL', 1),
(102, 4, 0, 'GN', 224, 0, 0, 0, 1, '', 1),
(103, 4, 0, 'GW', 245, 0, 0, 0, 1, '', 1),
(104, 6, 0, 'GY', 592, 0, 0, 0, 1, '', 1),
(105, 8, 0, 'HT', 509, 0, 0, 0, 1, '', 1),
(106, 5, 0, 'HM', 0, 0, 0, 0, 1, '', 1),
(107, 7, 0, 'VA', 379, 0, 0, 0, 1, 'NNNNN', 1),
(108, 8, 0, 'HN', 504, 0, 0, 0, 1, '', 1),
(109, 7, 0, 'IS', 354, 0, 0, 0, 1, 'NNN', 1),
(110, 3, 0, 'IN', 91, 0, 0, 0, 1, 'NNN NNN', 1),
(111, 3, 0, 'ID', 62, 0, 1, 0, 1, 'NNNNN', 1),
(112, 3, 0, 'IR', 98, 0, 0, 0, 1, 'NNNNN-NNNNN', 1),
(113, 3, 0, 'IQ', 964, 0, 0, 0, 1, 'NNNNN', 1),
(114, 7, 0, 'IM', 0, 0, 0, 0, 1, 'CN NLL', 1),
(115, 8, 0, 'JM', 0, 0, 0, 0, 1, '', 1),
(116, 7, 0, 'JE', 0, 0, 0, 0, 1, 'CN NLL', 1),
(117, 3, 0, 'JO', 962, 0, 0, 0, 1, '', 1),
(118, 3, 0, 'KZ', 7, 0, 0, 0, 1, 'NNNNNN', 1),
(119, 4, 0, 'KE', 254, 0, 0, 0, 1, '', 1),
(120, 5, 0, 'KI', 686, 0, 0, 0, 1, '', 1),
(121, 3, 0, 'KP', 850, 0, 0, 0, 1, '', 1),
(122, 3, 0, 'KW', 965, 0, 0, 0, 1, '', 1),
(123, 3, 0, 'KG', 996, 0, 0, 0, 1, '', 1),
(124, 3, 0, 'LA', 856, 0, 0, 0, 1, '', 1),
(125, 1, 0, 'LV', 371, 0, 0, 0, 1, 'C-NNNN', 1),
(126, 3, 0, 'LB', 961, 0, 0, 0, 1, '', 1),
(127, 4, 0, 'LS', 266, 0, 0, 0, 1, '', 1),
(128, 4, 0, 'LR', 231, 0, 0, 0, 1, '', 1),
(129, 4, 0, 'LY', 218, 0, 0, 0, 1, '', 1),
(130, 1, 0, 'LI', 423, 0, 0, 0, 1, 'NNNN', 1),
(131, 1, 0, 'LT', 370, 0, 0, 0, 1, 'NNNNN', 1),
(132, 3, 0, 'MO', 853, 0, 0, 0, 0, '', 1),
(133, 7, 0, 'MK', 389, 0, 0, 0, 1, '', 1),
(134, 4, 0, 'MG', 261, 0, 0, 0, 1, '', 1),
(135, 4, 0, 'MW', 265, 0, 0, 0, 1, '', 1),
(136, 3, 0, 'MY', 60, 0, 0, 0, 1, 'NNNNN', 1),
(137, 3, 0, 'MV', 960, 0, 0, 0, 1, '', 1),
(138, 4, 0, 'ML', 223, 0, 0, 0, 1, '', 1),
(139, 1, 0, 'MT', 356, 0, 0, 0, 1, 'LLL NNNN', 1),
(140, 5, 0, 'MH', 692, 0, 0, 0, 1, '', 1),
(141, 8, 0, 'MQ', 596, 0, 0, 0, 1, '', 1),
(142, 4, 0, 'MR', 222, 0, 0, 0, 1, '', 1),
(143, 1, 0, 'HU', 36, 0, 0, 0, 1, 'NNNN', 1),
(144, 4, 0, 'YT', 262, 0, 0, 0, 1, '', 1),
(145, 2, 0, 'MX', 52, 0, 1, 1, 1, 'NNNNN', 1),
(146, 5, 0, 'FM', 691, 0, 0, 0, 1, '', 1),
(147, 7, 0, 'MD', 373, 0, 0, 0, 1, 'C-NNNN', 1),
(148, 7, 0, 'MC', 377, 0, 0, 0, 1, '980NN', 1),
(149, 3, 0, 'MN', 976, 0, 0, 0, 1, '', 1),
(150, 7, 0, 'ME', 382, 0, 0, 0, 1, 'NNNNN', 1),
(151, 8, 0, 'MS', 0, 0, 0, 0, 1, '', 1),
(152, 4, 0, 'MA', 212, 0, 0, 0, 1, 'NNNNN', 1),
(153, 4, 0, 'MZ', 258, 0, 0, 0, 1, '', 1),
(154, 4, 0, 'NA', 264, 0, 0, 0, 1, '', 1),
(155, 5, 0, 'NR', 674, 0, 0, 0, 1, '', 1),
(156, 3, 0, 'NP', 977, 0, 0, 0, 1, '', 1),
(157, 8, 0, 'AN', 599, 0, 0, 0, 1, '', 1),
(158, 5, 0, 'NC', 687, 0, 0, 0, 1, '', 1),
(159, 8, 0, 'NI', 505, 0, 0, 0, 1, 'NNNNNN', 1),
(160, 4, 0, 'NE', 227, 0, 0, 0, 1, '', 1),
(161, 5, 0, 'NU', 683, 0, 0, 0, 1, '', 1),
(162, 5, 0, 'NF', 0, 0, 0, 0, 1, '', 1),
(163, 5, 0, 'MP', 0, 0, 0, 0, 1, '', 1),
(164, 3, 0, 'OM', 968, 0, 0, 0, 1, '', 1),
(165, 3, 0, 'PK', 92, 0, 0, 0, 1, '', 1),
(166, 5, 0, 'PW', 680, 0, 0, 0, 1, '', 1),
(167, 3, 0, 'PS', 0, 0, 0, 0, 1, '', 1),
(168, 8, 0, 'PA', 507, 0, 0, 0, 1, 'NNNNNN', 1),
(169, 5, 0, 'PG', 675, 0, 0, 0, 1, '', 1),
(170, 6, 0, 'PY', 595, 0, 0, 0, 1, '', 1),
(171, 6, 0, 'PE', 51, 0, 0, 0, 1, '', 1),
(172, 3, 0, 'PH', 63, 0, 0, 0, 1, 'NNNN', 1),
(173, 5, 0, 'PN', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
(174, 8, 0, 'PR', 0, 0, 0, 0, 1, 'NNNNN', 1),
(175, 3, 0, 'QA', 974, 0, 0, 0, 1, '', 1),
(176, 4, 0, 'RE', 262, 0, 0, 0, 1, '', 1),
(177, 7, 0, 'RU', 7, 0, 0, 0, 1, 'NNNNNN', 1),
(178, 4, 0, 'RW', 250, 0, 0, 0, 1, '', 1),
(179, 8, 0, 'BL', 0, 0, 0, 0, 1, '', 1),
(180, 8, 0, 'KN', 0, 0, 0, 0, 1, '', 1),
(181, 8, 0, 'LC', 0, 0, 0, 0, 1, '', 1),
(182, 8, 0, 'MF', 0, 0, 0, 0, 1, '', 1),
(183, 8, 0, 'PM', 508, 0, 0, 0, 1, '', 1),
(184, 8, 0, 'VC', 0, 0, 0, 0, 1, '', 1),
(185, 5, 0, 'WS', 685, 0, 0, 0, 1, '', 1),
(186, 7, 0, 'SM', 378, 0, 0, 0, 1, 'NNNNN', 1),
(187, 4, 0, 'ST', 239, 0, 0, 0, 1, '', 1),
(188, 3, 0, 'SA', 966, 0, 0, 0, 1, '', 1),
(189, 4, 0, 'SN', 221, 0, 0, 0, 1, '', 1),
(190, 7, 0, 'RS', 381, 0, 0, 0, 1, 'NNNNN', 1),
(191, 4, 0, 'SC', 248, 0, 0, 0, 1, '', 1),
(192, 4, 0, 'SL', 232, 0, 0, 0, 1, '', 1),
(193, 1, 0, 'SI', 386, 0, 0, 0, 1, 'C-NNNN', 1),
(194, 5, 0, 'SB', 677, 0, 0, 0, 1, '', 1),
(195, 4, 0, 'SO', 252, 0, 0, 0, 1, '', 1),
(196, 8, 0, 'GS', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
(197, 3, 0, 'LK', 94, 0, 0, 0, 1, 'NNNNN', 1),
(198, 4, 0, 'SD', 249, 0, 0, 0, 1, '', 1),
(199, 8, 0, 'SR', 597, 0, 0, 0, 1, '', 1),
(200, 7, 0, 'SJ', 0, 0, 0, 0, 1, '', 1),
(201, 4, 0, 'SZ', 268, 0, 0, 0, 1, '', 1),
(202, 3, 0, 'SY', 963, 0, 0, 0, 1, '', 1),
(203, 3, 0, 'TW', 886, 0, 0, 0, 1, 'NNNNN', 1),
(204, 3, 0, 'TJ', 992, 0, 0, 0, 1, '', 1),
(205, 4, 0, 'TZ', 255, 0, 0, 0, 1, '', 1),
(206, 3, 0, 'TH', 66, 0, 0, 0, 1, 'NNNNN', 1),
(207, 5, 0, 'TK', 690, 0, 0, 0, 1, '', 1),
(208, 5, 0, 'TO', 676, 0, 0, 0, 1, '', 1),
(209, 6, 0, 'TT', 0, 0, 0, 0, 1, '', 1),
(210, 4, 0, 'TN', 216, 0, 0, 0, 1, '', 1),
(211, 7, 0, 'TR', 90, 0, 0, 0, 1, 'NNNNN', 1),
(212, 3, 0, 'TM', 993, 0, 0, 0, 1, '', 1),
(213, 8, 0, 'TC', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
(214, 5, 0, 'TV', 688, 0, 0, 0, 1, '', 1),
(215, 4, 0, 'UG', 256, 0, 0, 0, 1, '', 1),
(216, 1, 0, 'UA', 380, 0, 0, 0, 1, 'NNNNN', 1),
(217, 3, 0, 'AE', 971, 0, 0, 0, 1, '', 1),
(218, 6, 0, 'UY', 598, 0, 0, 0, 1, '', 1),
(219, 3, 0, 'UZ', 998, 0, 0, 0, 1, '', 1),
(220, 5, 0, 'VU', 678, 0, 0, 0, 1, '', 1),
(221, 6, 0, 'VE', 58, 0, 0, 0, 1, '', 1),
(222, 3, 0, 'VN', 84, 0, 0, 0, 1, 'NNNNNN', 1),
(223, 2, 0, 'VG', 0, 0, 0, 0, 1, 'CNNNN', 1),
(224, 2, 0, 'VI', 0, 0, 0, 0, 1, '', 1),
(225, 5, 0, 'WF', 681, 0, 0, 0, 1, '', 1),
(226, 4, 0, 'EH', 0, 0, 0, 0, 1, '', 1),
(227, 3, 0, 'YE', 967, 0, 0, 0, 1, '', 1),
(228, 4, 0, 'ZM', 260, 0, 0, 0, 1, '', 1),
(229, 4, 0, 'ZW', 263, 0, 0, 0, 1, '', 1),
(230, 7, 0, 'AL', 355, 0, 0, 0, 1, 'NNNN', 1),
(231, 3, 0, 'AF', 93, 0, 0, 0, 1, 'NNNN', 1),
(232, 5, 0, 'AQ', 0, 0, 0, 0, 1, '', 1),
(233, 1, 0, 'BA', 387, 0, 0, 0, 1, '', 1),
(234, 5, 0, 'BV', 0, 0, 0, 0, 1, '', 1),
(235, 5, 0, 'IO', 0, 0, 0, 0, 1, 'LLLL NLL', 1),
(236, 1, 0, 'BG', 359, 0, 0, 0, 1, 'NNNN', 1),
(237, 8, 0, 'KY', 0, 0, 0, 0, 1, '', 1),
(238, 3, 0, 'CX', 0, 0, 0, 0, 1, '', 1),
(239, 3, 0, 'CC', 0, 0, 0, 0, 1, '', 1),
(240, 5, 0, 'CK', 682, 0, 0, 0, 1, '', 1),
(241, 6, 0, 'GF', 594, 0, 0, 0, 1, '', 1),
(242, 5, 0, 'PF', 689, 0, 0, 0, 1, '', 1),
(243, 5, 0, 'TF', 0, 0, 0, 0, 1, '', 1),
(244, 7, 0, 'AX', 0, 0, 0, 0, 1, 'NNNNN', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]country_lang`
--
CREATE TABLE `[[dbprefix]]country_lang` (
`id_country` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`id_country`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]country_lang`
--
INSERT INTO `[[dbprefix]]country_lang` VALUES
(1, 1, 'Germany'),
(2, 1, 'Austria'),
(3, 1, 'Belgium'),
(4, 1, 'Canada'),
(5, 1, 'China'),
(6, 1, 'Spain'),
(7, 1, 'Finland'),
(8, 1, 'France'),
(9, 1, 'Greece'),
(10, 1, 'Italy'),
(11, 1, 'Japan'),
(12, 1, 'Luxemburg'),
(13, 1, 'Netherlands'),
(14, 1, 'Poland'),
(15, 1, 'Portugal'),
(16, 1, 'Czech Republic'),
(17, 1, 'United Kingdom'),
(18, 1, 'Sweden'),
(19, 1, 'Switzerland'),
(20, 1, 'Denmark'),
(21, 1, 'United States'),
(22, 1, 'HongKong'),
(23, 1, 'Norway'),
(24, 1, 'Australia'),
(25, 1, 'Singapore'),
(26, 1, 'Ireland'),
(27, 1, 'New Zealand'),
(28, 1, 'South Korea'),
(29, 1, 'Israel'),
(30, 1, 'South Africa'),
(31, 1, 'Nigeria'),
(32, 1, 'Ivory Coast'),
(33, 1, 'Togo'),
(34, 1, 'Bolivia'),
(35, 1, 'Mauritius'),
(36, 1, 'Romania'),
(37, 1, 'Slovakia'),
(38, 1, 'Algeria'),
(39, 1, 'American Samoa'),
(40, 1, 'Andorra'),
(41, 1, 'Angola'),
(42, 1, 'Anguilla'),
(43, 1, 'Antigua and Barbuda'),
(44, 1, 'Argentina'),
(45, 1, 'Armenia'),
(46, 1, 'Aruba'),
(47, 1, 'Azerbaijan'),
(48, 1, 'Bahamas'),
(49, 1, 'Bahrain'),
(50, 1, 'Bangladesh'),
(51, 1, 'Barbados'),
(52, 1, 'Belarus'),
(53, 1, 'Belize'),
(54, 1, 'Benin'),
(55, 1, 'Bermuda'),
(56, 1, 'Bhutan'),
(57, 1, 'Botswana'),
(58, 1, 'Brazil'),
(59, 1, 'Brunei'),
(60, 1, 'Burkina Faso'),
(61, 1, 'Burma (Myanmar)'),
(62, 1, 'Burundi'),
(63, 1, 'Cambodia'),
(64, 1, 'Cameroon'),
(65, 1, 'Cape Verde'),
(66, 1, 'Central African Republic'),
(67, 1, 'Chad'),
(68, 1, 'Chile'),
(69, 1, 'Colombia'),
(70, 1, 'Comoros'),
(71, 1, 'Congo, Dem. Republic'),
(72, 1, 'Congo, Republic'),
(73, 1, 'Costa Rica'),
(74, 1, 'Croatia'),
(75, 1, 'Cuba'),
(76, 1, 'Cyprus'),
(77, 1, 'Djibouti'),
(78, 1, 'Dominica'),
(79, 1, 'Dominican Republic'),
(80, 1, 'East Timor'),
(81, 1, 'Ecuador'),
(82, 1, 'Egypt'),
(83, 1, 'El Salvador'),
(84, 1, 'Equatorial Guinea'),
(85, 1, 'Eritrea'),
(86, 1, 'Estonia'),
(87, 1, 'Ethiopia'),
(88, 1, 'Falkland Islands'),
(89, 1, 'Faroe Islands'),
(90, 1, 'Fiji'),
(91, 1, 'Gabon'),
(92, 1, 'Gambia'),
(93, 1, 'Georgia'),
(94, 1, 'Ghana'),
(95, 1, 'Grenada'),
(96, 1, 'Greenland'),
(97, 1, 'Gibraltar'),
(98, 1, 'Guadeloupe'),
(99, 1, 'Guam'),
(100, 1, 'Guatemala'),
(101, 1, 'Guernsey'),
(102, 1, 'Guinea'),
(103, 1, 'Guinea-Bissau'),
(104, 1, 'Guyana'),
(105, 1, 'Haiti'),
(106, 1, 'Heard Island and McDonald Islands'),
(107, 1, 'Vatican City State'),
(108, 1, 'Honduras'),
(109, 1, 'Iceland'),
(110, 1, 'India'),
(111, 1, 'Indonesia'),
(112, 1, 'Iran'),
(113, 1, 'Iraq'),
(114, 1, 'Man Island'),
(115, 1, 'Jamaica'),
(116, 1, 'Jersey'),
(117, 1, 'Jordan'),
(118, 1, 'Kazakhstan'),
(119, 1, 'Kenya'),
(120, 1, 'Kiribati'),
(121, 1, 'Korea, Dem. Republic of'),
(122, 1, 'Kuwait'),
(123, 1, 'Kyrgyzstan'),
(124, 1, 'Laos'),
(125, 1, 'Latvia'),
(126, 1, 'Lebanon'),
(127, 1, 'Lesotho'),
(128, 1, 'Liberia'),
(129, 1, 'Libya'),
(130, 1, 'Liechtenstein'),
(131, 1, 'Lithuania'),
(132, 1, 'Macau'),
(133, 1, 'Macedonia'),
(134, 1, 'Madagascar'),
(135, 1, 'Malawi'),
(136, 1, 'Malaysia'),
(137, 1, 'Maldives'),
(138, 1, 'Mali'),
(139, 1, 'Malta'),
(140, 1, 'Marshall Islands'),
(141, 1, 'Martinique'),
(142, 1, 'Mauritania'),
(143, 1, 'Hungary'),
(144, 1, 'Mayotte'),
(145, 1, 'Mexico'),
(146, 1, 'Micronesia'),
(147, 1, 'Moldova'),
(148, 1, 'Monaco'),
(149, 1, 'Mongolia'),
(150, 1, 'Montenegro'),
(151, 1, 'Montserrat'),
(152, 1, 'Morocco'),
(153, 1, 'Mozambique'),
(154, 1, 'Namibia'),
(155, 1, 'Nauru'),
(156, 1, 'Nepal'),
(157, 1, 'Netherlands Antilles'),
(158, 1, 'New Caledonia'),
(159, 1, 'Nicaragua'),
(160, 1, 'Niger'),
(161, 1, 'Niue'),
(162, 1, 'Norfolk Island'),
(163, 1, 'Northern Mariana Islands'),
(164, 1, 'Oman'),
(165, 1, 'Pakistan'),
(166, 1, 'Palau'),
(167, 1, 'Palestinian Territories'),
(168, 1, 'Panama'),
(169, 1, 'Papua New Guinea'),
(170, 1, 'Paraguay'),
(171, 1, 'Peru'),
(172, 1, 'Philippines'),
(173, 1, 'Pitcairn'),
(174, 1, 'Puerto Rico'),
(175, 1, 'Qatar'),
(176, 1, 'Reunion Island'),
(177, 1, 'Russian Federation'),
(178, 1, 'Rwanda'),
(179, 1, 'Saint Barthelemy'),
(180, 1, 'Saint Kitts and Nevis'),
(181, 1, 'Saint Lucia'),
(182, 1, 'Saint Martin'),
(183, 1, 'Saint Pierre and Miquelon'),
(184, 1, 'Saint Vincent and the Grenadines'),
(185, 1, 'Samoa'),
(186, 1, 'San Marino'),
(187, 1, 'São Tomé and Príncipe'),
(188, 1, 'Saudi Arabia'),
(189, 1, 'Senegal'),
(190, 1, 'Serbia'),
(191, 1, 'Seychelles'),
(192, 1, 'Sierra Leone'),
(193, 1, 'Slovenia'),
(194, 1, 'Solomon Islands'),
(195, 1, 'Somalia'),
(196, 1, 'South Georgia and the South Sandwich Islands'),
(197, 1, 'Sri Lanka'),
(198, 1, 'Sudan'),
(199, 1, 'Suriname'),
(200, 1, 'Svalbard and Jan Mayen'),
(201, 1, 'Swaziland'),
(202, 1, 'Syria'),
(203, 1, 'Taiwan'),
(204, 1, 'Tajikistan'),
(205, 1, 'Tanzania'),
(206, 1, 'Thailand'),
(207, 1, 'Tokelau'),
(208, 1, 'Tonga'),
(209, 1, 'Trinidad and Tobago'),
(210, 1, 'Tunisia'),
(211, 1, 'Turkey'),
(212, 1, 'Turkmenistan'),
(213, 1, 'Turks and Caicos Islands'),
(214, 1, 'Tuvalu'),
(215, 1, 'Uganda'),
(216, 1, 'Ukraine'),
(217, 1, 'United Arab Emirates'),
(218, 1, 'Uruguay'),
(219, 1, 'Uzbekistan'),
(220, 1, 'Vanuatu'),
(221, 1, 'Venezuela'),
(222, 1, 'Vietnam'),
(223, 1, 'Virgin Islands (British)'),
(224, 1, 'Virgin Islands (U.S.)'),
(225, 1, 'Wallis and Futuna'),
(226, 1, 'Western Sahara'),
(227, 1, 'Yemen'),
(228, 1, 'Zambia'),
(229, 1, 'Zimbabwe'),
(230, 1, 'Albania'),
(231, 1, 'Afghanistan'),
(232, 1, 'Antarctica'),
(233, 1, 'Bosnia and Herzegovina'),
(234, 1, 'Bouvet Island'),
(235, 1, 'British Indian Ocean Territory'),
(236, 1, 'Bulgaria'),
(237, 1, 'Cayman Islands'),
(238, 1, 'Christmas Island'),
(239, 1, 'Cocos (Keeling) Islands'),
(240, 1, 'Cook Islands'),
(241, 1, 'French Guiana'),
(242, 1, 'French Polynesia'),
(243, 1, 'French Southern Territories'),
(244, 1, 'Åland Islands');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]country_shop`
--
CREATE TABLE `[[dbprefix]]country_shop` (
`id_country` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_country`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]country_shop`
--
INSERT INTO `[[dbprefix]]country_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),
(103, 1),
(104, 1),
(105, 1),
(106, 1),
(107, 1),
(108, 1),
(109, 1),
(110, 1),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(140, 1),
(141, 1),
(142, 1),
(143, 1),
(144, 1),
(145, 1),
(146, 1),
(147, 1),
(148, 1),
(149, 1),
(150, 1),
(151, 1),
(152, 1),
(153, 1),
(154, 1),
(155, 1),
(156, 1),
(157, 1),
(158, 1),
(159, 1),
(160, 1),
(161, 1),
(162, 1),
(163, 1),
(164, 1),
(165, 1),
(166, 1),
(167, 1),
(168, 1),
(169, 1),
(170, 1),
(171, 1),
(172, 1),
(173, 1),
(174, 1),
(175, 1),
(176, 1),
(177, 1),
(178, 1),
(179, 1),
(180, 1),
(181, 1),
(182, 1),
(183, 1),
(184, 1),
(185, 1),
(186, 1),
(187, 1),
(188, 1),
(189, 1),
(190, 1),
(191, 1),
(192, 1),
(193, 1),
(194, 1),
(195, 1),
(196, 1),
(197, 1),
(198, 1),
(199, 1),
(200, 1),
(201, 1),
(202, 1),
(203, 1),
(204, 1),
(205, 1),
(206, 1),
(207, 1),
(208, 1),
(209, 1),
(210, 1),
(211, 1),
(212, 1),
(213, 1),
(214, 1),
(215, 1),
(216, 1),
(217, 1),
(218, 1),
(219, 1),
(220, 1),
(221, 1),
(222, 1),
(223, 1),
(224, 1),
(225, 1),
(226, 1),
(227, 1),
(228, 1),
(229, 1),
(230, 1),
(231, 1),
(232, 1),
(233, 1),
(234, 1),
(235, 1),
(236, 1),
(237, 1),
(238, 1),
(239, 1),
(240, 1),
(241, 1),
(242, 1),
(243, 1),
(244, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]currency`
--
CREATE TABLE `[[dbprefix]]currency` (
`id_currency` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`iso_code` varchar(3) NOT NULL DEFAULT '0',
`iso_code_num` varchar(3) NOT NULL DEFAULT '0',
`sign` varchar(8) NOT NULL,
`blank` tinyint(1) unsigned NOT NULL DEFAULT '0',
`format` tinyint(1) unsigned NOT NULL DEFAULT '0',
`decimals` tinyint(1) unsigned NOT NULL DEFAULT '1',
`conversion_rate` decimal(13,6) NOT NULL,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_currency`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]currency`
--
INSERT INTO `[[dbprefix]]currency` VALUES
(1, 'Dollar', 'USD', '840', '$', 0, 1, 1, '1.000000', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]currency_shop`
--
CREATE TABLE `[[dbprefix]]currency_shop` (
`id_currency` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
`conversion_rate` decimal(13,6) NOT NULL,
PRIMARY KEY (`id_currency`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]currency_shop`
--
INSERT INTO `[[dbprefix]]currency_shop` VALUES
(1, 1, '1.000000');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customer`
--
CREATE TABLE `[[dbprefix]]customer` (
`id_customer` 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_gender` int(10) unsigned NOT NULL,
`id_default_group` int(10) unsigned NOT NULL DEFAULT '1',
`id_lang` int(10) unsigned DEFAULT NULL,
`id_risk` int(10) unsigned NOT NULL DEFAULT '1',
`company` varchar(64) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(32) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ip_registration_newsletter` varchar(15) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT '0',
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT '0.000000',
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT '0',
`max_payment_days` int(10) unsigned NOT NULL DEFAULT '60',
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text,
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_guest` tinyint(1) NOT NULL DEFAULT '0',
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]customer`
--
INSERT INTO `[[dbprefix]]customer` VALUES
(1, 1, 1, 1, 3, 1, 0, '', '', '', 'John', 'Doe', 'pub@qloapps.com', '166ef803b1c359d555e15f01e5d2af53', '[[regtime]]', '1994-10-14', 1, '', '[[regtime]]', 1, '', '0.000000', 0, 0, '642e8de5b0e2edd1dbee92e82d4bf816', '', 1, 0, 0, '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customer_group`
--
CREATE TABLE `[[dbprefix]]customer_group` (
`id_customer` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_customer`,`id_group`),
KEY `customer_login` (`id_group`),
KEY `id_customer` (`id_customer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]customer_group`
--
INSERT INTO `[[dbprefix]]customer_group` VALUES
(1, 3);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customer_message`
--
CREATE TABLE `[[dbprefix]]customer_message` (
`id_customer_message` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_customer_thread` int(11) DEFAULT NULL,
`id_employee` int(10) unsigned DEFAULT NULL,
`message` mediumtext NOT NULL,
`file_name` varchar(18) DEFAULT NULL,
`ip_address` varchar(16) DEFAULT NULL,
`user_agent` varchar(128) DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`private` tinyint(4) NOT NULL DEFAULT '0',
`read` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_customer_message`),
KEY `id_customer_thread` (`id_customer_thread`),
KEY `id_employee` (`id_employee`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customer_message_sync_imap`
--
CREATE TABLE `[[dbprefix]]customer_message_sync_imap` (
`md5_header` varbinary(32) NOT NULL,
KEY `md5_header_index` (`md5_header`(4))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customer_thread`
--
CREATE TABLE `[[dbprefix]]customer_thread` (
`id_customer_thread` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(11) unsigned NOT NULL DEFAULT '1',
`id_lang` int(10) unsigned NOT NULL,
`id_contact` int(10) unsigned NOT NULL,
`id_customer` int(10) unsigned DEFAULT NULL,
`id_order` int(10) unsigned DEFAULT NULL,
`id_product` int(10) unsigned DEFAULT NULL,
`status` enum('open','closed','pending1','pending2') NOT NULL DEFAULT 'open',
`email` varchar(128) NOT NULL,
`token` varchar(12) DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer_thread`),
KEY `id_shop` (`id_shop`),
KEY `id_lang` (`id_lang`),
KEY `id_contact` (`id_contact`),
KEY `id_customer` (`id_customer`),
KEY `id_order` (`id_order`),
KEY `id_product` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customization`
--
CREATE TABLE `[[dbprefix]]customization` (
`id_customization` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_product_attribute` int(10) unsigned NOT NULL DEFAULT '0',
`id_address_delivery` int(10) unsigned NOT NULL DEFAULT '0',
`id_cart` int(10) unsigned NOT NULL,
`id_product` int(10) NOT NULL,
`quantity` int(10) NOT NULL,
`quantity_refunded` int(11) NOT NULL DEFAULT '0',
`quantity_returned` int(11) NOT NULL DEFAULT '0',
`in_cart` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_customization`,`id_cart`,`id_product`,`id_address_delivery`),
KEY `id_product_attribute` (`id_product_attribute`),
KEY `id_cart_product` (`id_cart`,`id_product`,`id_product_attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customization_field`
--
CREATE TABLE `[[dbprefix]]customization_field` (
`id_customization_field` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_product` int(10) unsigned NOT NULL,
`type` tinyint(1) NOT NULL,
`required` tinyint(1) NOT NULL,
PRIMARY KEY (`id_customization_field`),
KEY `id_product` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customization_field_lang`
--
CREATE TABLE `[[dbprefix]]customization_field_lang` (
`id_customization_field` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`id_shop` int(10) unsigned NOT NULL DEFAULT '1',
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id_customization_field`,`id_lang`,`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]customized_data`
--
CREATE TABLE `[[dbprefix]]customized_data` (
`id_customization` int(10) unsigned NOT NULL,
`type` tinyint(1) NOT NULL,
`index` int(3) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id_customization`,`type`,`index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]date_range`
--
CREATE TABLE `[[dbprefix]]date_range` (
`id_date_range` int(10) unsigned NOT NULL AUTO_INCREMENT,
`time_start` datetime NOT NULL,
`time_end` datetime NOT NULL,
PRIMARY KEY (`id_date_range`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]delivery`
--
CREATE TABLE `[[dbprefix]]delivery` (
`id_delivery` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(10) unsigned DEFAULT NULL,
`id_shop_group` int(10) unsigned DEFAULT NULL,
`id_carrier` int(10) unsigned NOT NULL,
`id_range_price` int(10) unsigned DEFAULT NULL,
`id_range_weight` int(10) unsigned DEFAULT NULL,
`id_zone` int(10) unsigned NOT NULL,
`price` decimal(20,6) NOT NULL,
PRIMARY KEY (`id_delivery`),
KEY `id_zone` (`id_zone`),
KEY `id_carrier` (`id_carrier`,`id_zone`),
KEY `id_range_price` (`id_range_price`),
KEY `id_range_weight` (`id_range_weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]employee`
--
CREATE TABLE `[[dbprefix]]employee` (
`id_employee` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_profile` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL DEFAULT '0',
`lastname` varchar(32) NOT NULL,
`firstname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(32) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`stats_date_from` date DEFAULT NULL,
`stats_date_to` date DEFAULT NULL,
`stats_compare_from` date DEFAULT NULL,
`stats_compare_to` date DEFAULT NULL,
`stats_compare_option` int(1) unsigned NOT NULL DEFAULT '1',
`preselect_date_range` varchar(32) DEFAULT NULL,
`bo_color` varchar(32) DEFAULT NULL,
`bo_theme` varchar(32) DEFAULT NULL,
`bo_css` varchar(64) DEFAULT NULL,
`default_tab` int(10) unsigned NOT NULL DEFAULT '0',
`bo_width` int(10) unsigned NOT NULL DEFAULT '0',
`bo_menu` tinyint(1) NOT NULL DEFAULT '1',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`optin` tinyint(1) unsigned NOT NULL DEFAULT '1',
`id_last_order` int(10) unsigned NOT NULL DEFAULT '0',
`id_last_customer_message` int(10) unsigned NOT NULL DEFAULT '0',
`id_last_customer` int(10) unsigned NOT NULL DEFAULT '0',
`last_connection_date` date DEFAULT '0000-00-00',
PRIMARY KEY (`id_employee`),
KEY `employee_login` (`email`,`passwd`),
KEY `id_employee_passwd` (`id_employee`,`passwd`),
KEY `id_profile` (`id_profile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]employee`
--
INSERT INTO `[[dbprefix]]employee` VALUES
(1, 1, 1, '[[admin_lname]]', '[[admin_fname]]', '[[admin_email]]', '[[admin_pass]]', '[[regtime]]', '[[stats_date_from]]', '[[creation]]', '0000-00-00', '0000-00-00', 1, NULL, NULL, 'default', 'admin-theme.css', 1, 0, 1, 1, 1, 0, 0, 0, '0000-00-00');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]employee_shop`
--
CREATE TABLE `[[dbprefix]]employee_shop` (
`id_employee` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_employee`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]employee_shop`
--
INSERT INTO `[[dbprefix]]employee_shop` VALUES
(1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature`
--
CREATE TABLE `[[dbprefix]]feature` (
`id_feature` int(10) unsigned NOT NULL AUTO_INCREMENT,
`position` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_feature`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `[[dbprefix]]feature`
--
INSERT INTO `[[dbprefix]]feature` VALUES
(1, 0),
(2, 1),
(3, 2),
(4, 3),
(5, 4),
(6, 5),
(7, 6);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature_lang`
--
CREATE TABLE `[[dbprefix]]feature_lang` (
`id_feature` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id_feature`,`id_lang`),
KEY `id_lang` (`id_lang`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]feature_lang`
--
INSERT INTO `[[dbprefix]]feature_lang` VALUES
(7, 1, 'Gym'),
(2, 1, 'News Paper'),
(3, 1, 'Power BackUp'),
(4, 1, 'Refrigerator'),
(5, 1, 'Restaurant'),
(6, 1, 'Room Service'),
(1, 1, 'Wi-Fi');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature_product`
--
CREATE TABLE `[[dbprefix]]feature_product` (
`id_feature` int(10) unsigned NOT NULL,
`id_product` int(10) unsigned NOT NULL,
`id_feature_value` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_feature`,`id_product`),
KEY `id_feature_value` (`id_feature_value`),
KEY `id_product` (`id_product`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]feature_product`
--
INSERT INTO `[[dbprefix]]feature_product` VALUES
(1, 1, 1),
(1, 2, 1),
(1, 3, 1),
(1, 4, 1),
(2, 1, 2),
(2, 2, 2),
(2, 3, 2),
(2, 4, 2),
(3, 1, 3),
(3, 2, 3),
(3, 3, 3),
(3, 4, 3),
(4, 1, 4),
(4, 2, 4),
(4, 3, 4),
(4, 4, 4);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature_shop`
--
CREATE TABLE `[[dbprefix]]feature_shop` (
`id_feature` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_feature`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]feature_shop`
--
INSERT INTO `[[dbprefix]]feature_shop` VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature_value`
--
CREATE TABLE `[[dbprefix]]feature_value` (
`id_feature_value` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_feature` int(10) unsigned NOT NULL,
`custom` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`id_feature_value`),
KEY `feature` (`id_feature`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `[[dbprefix]]feature_value`
--
INSERT INTO `[[dbprefix]]feature_value` VALUES
(1, 1, 0),
(2, 2, 0),
(3, 3, 0),
(4, 4, 0),
(5, 5, 0),
(6, 6, 0),
(7, 7, 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]feature_value_lang`
--
CREATE TABLE `[[dbprefix]]feature_value_lang` (
`id_feature_value` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_feature_value`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]feature_value_lang`
--
INSERT INTO `[[dbprefix]]feature_value_lang` VALUES
(1, 1, '1.jpg'),
(2, 1, '2.jpg'),
(3, 1, '3.jpg'),
(4, 1, '4.jpg'),
(5, 1, '5.jpg'),
(6, 1, '6.jpg'),
(7, 1, '7.jpg');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]gender`
--
CREATE TABLE `[[dbprefix]]gender` (
`id_gender` int(11) NOT NULL AUTO_INCREMENT,
`type` tinyint(1) NOT NULL,
PRIMARY KEY (`id_gender`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `[[dbprefix]]gender`
--
INSERT INTO `[[dbprefix]]gender` VALUES
(1, 0),
(2, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]gender_lang`
--
CREATE TABLE `[[dbprefix]]gender_lang` (
`id_gender` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(20) NOT NULL,
PRIMARY KEY (`id_gender`,`id_lang`),
KEY `id_gender` (`id_gender`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]gender_lang`
--
INSERT INTO `[[dbprefix]]gender_lang` VALUES
(1, 1, 'Mr.'),
(2, 1, 'Mrs.');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]group`
--
CREATE TABLE `[[dbprefix]]group` (
`id_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
`reduction` decimal(17,2) NOT NULL DEFAULT '0.00',
`price_display_method` tinyint(4) NOT NULL DEFAULT '0',
`show_prices` tinyint(1) unsigned NOT NULL DEFAULT '1',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `[[dbprefix]]group`
--
INSERT INTO `[[dbprefix]]group` VALUES
(1, '0.00', 1, 1, '[[regtime]]', '[[regtime]]'),
(2, '0.00', 1, 1, '[[regtime]]', '[[regtime]]'),
(3, '0.00', 1, 1, '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]group_lang`
--
CREATE TABLE `[[dbprefix]]group_lang` (
`id_group` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(32) NOT NULL,
PRIMARY KEY (`id_group`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]group_lang`
--
INSERT INTO `[[dbprefix]]group_lang` VALUES
(1, 1, 'Visitor'),
(2, 1, 'Guest'),
(3, 1, 'Customer');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]group_reduction`
--
CREATE TABLE `[[dbprefix]]group_reduction` (
`id_group_reduction` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`id_group` int(10) unsigned NOT NULL,
`id_category` int(10) unsigned NOT NULL,
`reduction` decimal(4,3) NOT NULL,
PRIMARY KEY (`id_group_reduction`),
UNIQUE KEY `id_group` (`id_group`,`id_category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]group_shop`
--
CREATE TABLE `[[dbprefix]]group_shop` (
`id_group` int(11) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL,
PRIMARY KEY (`id_group`,`id_shop`),
KEY `id_shop` (`id_shop`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]group_shop`
--
INSERT INTO `[[dbprefix]]group_shop` VALUES
(1, 1),
(2, 1),
(3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]guest`
--
CREATE TABLE `[[dbprefix]]guest` (
`id_guest` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_operating_system` int(10) unsigned DEFAULT NULL,
`id_web_browser` int(10) unsigned DEFAULT NULL,
`id_customer` int(10) unsigned DEFAULT NULL,
`javascript` tinyint(1) DEFAULT '0',
`screen_resolution_x` smallint(5) unsigned DEFAULT NULL,
`screen_resolution_y` smallint(5) unsigned DEFAULT NULL,
`screen_color` tinyint(3) unsigned DEFAULT NULL,
`sun_java` tinyint(1) DEFAULT NULL,
`adobe_flash` tinyint(1) DEFAULT NULL,
`adobe_director` tinyint(1) DEFAULT NULL,
`apple_quicktime` tinyint(1) DEFAULT NULL,
`real_player` tinyint(1) DEFAULT NULL,
`windows_media` tinyint(1) DEFAULT NULL,
`accept_language` varchar(8) DEFAULT NULL,
`mobile_theme` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_guest`),
KEY `id_customer` (`id_customer`),
KEY `id_operating_system` (`id_operating_system`),
KEY `id_web_browser` (`id_web_browser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]guest`
--
INSERT INTO `[[dbprefix]]guest` VALUES
(1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]hook`
--
CREATE TABLE `[[dbprefix]]hook` (
`id_hook` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`title` varchar(64) NOT NULL,
`description` text,
`position` tinyint(1) NOT NULL DEFAULT '1',
`live_edit` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_hook`),
UNIQUE KEY `hook_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;
--
-- Dumping data for table `[[dbprefix]]hook`
--
INSERT INTO `[[dbprefix]]hook` VALUES
(1, 'displayPayment', 'Payment', 'This hook displays new elements on the payment page', 1, 1),
(2, 'actionValidateOrder', 'New orders', '', 1, 0),
(3, 'displayMaintenance', 'Maintenance Page', 'This hook displays new elements on the maintenance page', 1, 0),
(4, 'actionPaymentConfirmation', 'Payment confirmation', 'This hook displays new elements after the payment is validated', 1, 0),
(5, 'displayPaymentReturn', 'Payment return', '', 1, 0),
(6, 'actionUpdateQuantity', 'Quantity update', 'Quantity is updated only when a customer effectively places their order', 1, 0),
(7, 'displayRightColumn', 'Right column blocks', 'This hook displays new elements in the right-hand column', 1, 1),
(8, 'displayLeftColumn', 'Left column blocks', 'This hook displays new elements in the left-hand column', 1, 1),
(9, 'displayHome', 'Homepage content', 'This hook displays new elements on the homepage', 1, 1),
(10, 'Header', 'Pages html head section', 'This hook adds additional elements in the head section of your pages (head section of html)', 1, 0),
(11, 'actionCartSave', 'Cart creation and update', 'This hook is displayed when a product is added to the cart or if the cart''s content is modified', 1, 0),
(12, 'actionAuthentication', 'Successful customer authentication', 'This hook is displayed after a customer successfully signs in', 1, 0),
(13, 'actionProductAdd', 'Product creation', 'This hook is displayed after a product is created', 1, 0),
(14, 'actionProductUpdate', 'Product update', 'This hook is displayed after a product has been updated', 1, 0),
(15, 'displayTop', 'Top of pages', 'This hook displays additional elements at the top of your pages', 1, 0),
(16, 'displayRightColumnProduct', 'New elements on the product page (right column)', 'This hook displays new elements in the right-hand column of the product page', 1, 0),
(17, 'actionProductDelete', 'Product deletion', 'This hook is called when a product is deleted', 1, 0),
(18, 'displayFooterProduct', 'Product footer', 'This hook adds new blocks under the product''s description', 1, 1),
(19, 'displayInvoice', 'Invoice', 'This hook displays new blocks on the invoice (order)', 1, 0),
(20, 'actionOrderStatusUpdate', 'Order status update - Event', 'This hook launches modules when the status of an order changes.', 1, 0),
(21, 'displayAdminOrder', 'Display new elements in the Back Office, tab AdminOrder', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office', 1, 0),
(22, 'displayAdminOrderTabOrder', 'Display new elements in Back Office, AdminOrder, panel Order', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Order panel tabs', 1, 0),
(23, 'displayAdminOrderTabShip', 'Display new elements in Back Office, AdminOrder, panel Shipping', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Shipping panel tabs', 1, 0),
(24, 'displayAdminOrderContentOrder', 'Display new elements in Back Office, AdminOrder, panel Order', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Order panel content', 1, 0),
(25, 'displayAdminOrderContentShip', 'Display new elements in Back Office, AdminOrder, panel Shipping', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Shipping panel content', 1, 0),
(26, 'displayFooter', 'Footer', 'This hook displays new blocks in the footer', 1, 0),
(27, 'displayPDFInvoice', 'PDF Invoice', 'This hook allows you to display additional information on PDF invoices', 1, 0),
(28, 'displayInvoiceLegalFreeText', 'PDF Invoice - Legal Free Text', 'This hook allows you to modify the legal free text on PDF invoices', 1, 0),
(29, 'displayAdminCustomers', 'Display new elements in the Back Office, tab AdminCustomers', 'This hook launches modules when the AdminCustomers tab is displayed in the Back Office', 1, 0),
(30, 'displayOrderConfirmation', 'Order confirmation page', 'This hook is called within an order''s confirmation page', 1, 0),
(31, 'actionCustomerAccountAdd', 'Successful customer account creation', 'This hook is called when a new customer creates an account successfully', 1, 0),
(32, 'displayCustomerAccount', 'Customer account displayed in Front Office', 'This hook displays new elements on the customer account page', 1, 0),
(33, 'displayCustomerIdentityForm', 'Customer identity form displayed in Front Office', 'This hook displays new elements on the form to update a customer identity', 1, 0),
(34, 'actionOrderSlipAdd', 'Order slip creation', 'This hook is called when a new credit slip is added regarding client order', 1, 0),
(35, 'displayProductTab', 'Tabs on product page', 'This hook is called on the product page''s tab', 1, 0),
(36, 'displayProductTabContent', 'Tabs content on the product page', 'This hook is called on the product page''s tab', 1, 0),
(37, 'displayShoppingCartFooter', 'Shopping cart footer', 'This hook displays some specific information on the shopping cart''s page', 1, 0),
(38, 'displayCustomerAccountForm', 'Customer account creation form', 'This hook displays some information on the form to create a customer account', 1, 0),
(39, 'displayAdminStatsModules', 'Stats - Modules', '', 1, 0),
(40, 'displayAdminStatsGraphEngine', 'Graph engines', '', 1, 0),
(41, 'actionOrderReturn', 'Returned product', 'This hook is displayed when a customer returns a product ', 1, 0),
(42, 'displayProductButtons', 'Product page actions', 'This hook adds new action buttons on the product page', 1, 0),
(43, 'displayBackOfficeHome', 'Administration panel homepage', 'This hook is displayed on the admin panel''s homepage', 1, 0),
(44, 'displayAdminStatsGridEngine', 'Grid engines', '', 1, 0),
(45, 'actionWatermark', 'Watermark', '', 1, 0),
(46, 'actionProductCancel', 'Product cancelled', 'This hook is called when you cancel a product in an order', 1, 0),
(47, 'displayLeftColumnProduct', 'New elements on the product page (left column)', 'This hook displays new elements in the left-hand column of the product page', 1, 0),
(48, 'actionProductOutOfStock', 'Out-of-stock product', 'This hook displays new action buttons if a product is out of stock', 1, 0),
(49, 'actionProductAttributeUpdate', 'Product attribute update', 'This hook is displayed when a product''s attribute is updated', 1, 0),
(50, 'displayCarrierList', 'Extra carrier (module mode)', '', 1, 0),
(51, 'displayShoppingCart', 'Shopping cart - Additional button', 'This hook displays new action buttons within the shopping cart', 1, 0),
(52, 'actionSearch', 'Search', '', 1, 0),
(53, 'displayBeforePayment', 'Redirect during the order process', 'This hook redirects the user to the module instead of displaying payment modules', 1, 0),
(54, 'actionCarrierUpdate', 'Carrier Update', 'This hook is called when a carrier is updated', 1, 0),
(55, 'actionOrderStatusPostUpdate', 'Post update of order status', '', 1, 0),
(56, 'displayCustomerAccountFormTop', 'Block above the form for create an account', 'This hook is displayed above the customer''s account creation form', 1, 0),
(57, 'displayBackOfficeHeader', 'Administration panel header', 'This hook is displayed in the header of the admin panel', 1, 0),
(58, 'displayBackOfficeTop', 'Administration panel hover the tabs', 'This hook is displayed on the roll hover of the tabs within the admin panel', 1, 0),
(59, 'displayBackOfficeFooter', 'Administration panel footer', 'This hook is displayed within the admin panel''s footer', 1, 0),
(60, 'actionProductAttributeDelete', 'Product attribute deletion', 'This hook is displayed when a product''s attribute is deleted', 1, 0),
(61, 'actionCarrierProcess', 'Carrier process', '', 1, 0),
(62, 'actionOrderDetail', 'Order detail', 'This hook is used to set the follow-up in Smarty when an order''s detail is called', 1, 0),
(63, 'displayBeforeCarrier', 'Before carriers list', 'This hook is displayed before the carrier list in Front Office', 1, 0),
(64, 'displayOrderDetail', 'Order detail', 'This hook is displayed within the order''s details in Front Office', 1, 0),
(65, 'actionPaymentCCAdd', 'Payment CC added', '', 1, 0),
(66, 'displayProductComparison', 'Extra product comparison', '', 1, 0),
(67, 'actionCategoryAdd', 'Category creation', 'This hook is displayed when a category is created', 1, 0),
(68, 'actionCategoryUpdate', 'Category modification', 'This hook is displayed when a category is modified', 1, 0),
(69, 'actionCategoryDelete', 'Category deletion', 'This hook is displayed when a category is deleted', 1, 0),
(70, 'actionBeforeAuthentication', 'Before authentication', 'This hook is displayed before the customer''s authentication', 1, 0),
(71, 'actionSubmitIdentityBefore', 'Before identity modification', 'This hook is called before customer''s identity modification', 1, 0),
(72, 'displayCartRoomImageAfter', 'After cart room image on checkout page', 'This hook is displayed after cart room image on checkout page', 1, 0),
(73, 'displayPaymentTop', 'Top of payment page', 'This hook is displayed at the top of the payment page', 1, 0),
(74, 'actionHtaccessCreate', 'After htaccess creation', 'This hook is displayed after the htaccess creation', 1, 0),
(75, 'actionAdminMetaSave', 'After saving the configuration in AdminMeta', 'This hook is displayed after saving the configuration in AdminMeta', 1, 0),
(76, 'displayAttributeGroupForm', 'Add fields to the form ''attribute group''', 'This hook adds fields to the form ''attribute group''', 1, 0),
(77, 'actionAttributeGroupSave', 'Saving an attribute group', 'This hook is called while saving an attributes group', 1, 0),
(78, 'actionAttributeGroupDelete', 'Deleting attribute group', 'This hook is called while deleting an attributes group', 1, 0),
(79, 'displayFeatureForm', 'Add fields to the form ''feature''', 'This hook adds fields to the form ''feature''', 1, 0),
(80, 'actionFeatureSave', 'Saving attributes'' features', 'This hook is called while saving an attributes features', 1, 0),
(81, 'actionFeatureDelete', 'Deleting attributes'' features', 'This hook is called while deleting an attributes features', 1, 0),
(82, 'actionProductSave', 'Saving products', 'This hook is called while saving products', 1, 0),
(83, 'actionProductListOverride', 'Assign a products list to a category', 'This hook assigns a products list to a category', 1, 0),
(84, 'displayAttributeGroupPostProcess', 'On post-process in admin attribute group', 'This hook is called on post-process in admin attribute group', 1, 0),
(85, 'displayFeaturePostProcess', 'On post-process in admin feature', 'This hook is called on post-process in admin feature', 1, 0),
(86, 'displayFeatureValueForm', 'Add fields to the form ''feature value''', 'This hook adds fields to the form ''feature value''', 1, 0),
(87, 'displayFeatureValuePostProcess', 'On post-process in admin feature value', 'This hook is called on post-process in admin feature value', 1, 0),
(88, 'actionFeatureValueDelete', 'Deleting attributes'' features'' values', 'This hook is called while deleting an attributes features value', 1, 0),
(89, 'actionFeatureValueSave', 'Saving an attributes features value', 'This hook is called while saving an attributes features value', 1, 0),
(90, 'displayAttributeForm', 'Add fields to the form ''attribute value''', 'This hook adds fields to the form ''attribute value''', 1, 0),
(91, 'actionAttributePostProcess', 'On post-process in admin feature value', 'This hook is called on post-process in admin feature value', 1, 0),
(92, 'actionAttributeDelete', 'Deleting an attributes features value', 'This hook is called while deleting an attributes features value', 1, 0),
(93, 'actionAttributeSave', 'Saving an attributes features value', 'This hook is called while saving an attributes features value', 1, 0),
(94, 'actionTaxManager', 'Tax Manager Factory', '', 1, 0),
(95, 'displayMyAccountBlock', 'My account block', 'This hook displays extra information within the ''my account'' block"', 1, 0),
(96, 'actionModuleInstallBefore', 'actionModuleInstallBefore', '', 1, 0),
(97, 'actionModuleInstallAfter', 'actionModuleInstallAfter', '', 1, 0),
(98, 'displayHomeTab', 'Home Page Tabs', 'This hook displays new elements on the homepage tabs', 1, 1),
(99, 'displayHomeTabContent', 'Home Page Tabs Content', 'This hook displays new elements on the homepage tabs content', 1, 1),
(100, 'displayTopColumn', 'Top column blocks', 'This hook displays new elements in the top of columns', 1, 1),
(101, 'displayBackOfficeCategory', 'Display new elements in the Back Office, tab AdminCategories', 'This hook launches modules when the AdminCategories tab is displayed in the Back Office', 1, 0),
(102, 'displayProductListFunctionalButtons', 'Display new elements in the Front Office, products list', 'This hook launches modules when the products list is displayed in the Front Office', 1, 0),
(103, 'displayNav', 'Navigation', '', 1, 1),
(104, 'displayOverrideTemplate', 'Change the default template of current controller', '', 1, 0),
(105, 'actionAdminLoginControllerSetMedia', 'Set media on admin login page header', 'This hook is called after adding media to admin login page header', 1, 0),
(106, 'actionOrderEdited', 'Order edited', 'This hook is called when an order is edited.', 1, 0),
(107, 'actionEmailAddBeforeContent', 'Add extra content before mail content', 'This hook is called just before fetching mail template', 1, 0),
(108, 'actionEmailAddAfterContent', 'Add extra content after mail content', 'This hook is called just after fetching mail template', 1, 0),
(109, 'displayCartExtraProductActions', 'Extra buttons in shopping cart', 'This hook adds extra buttons to the product lines, in the shopping cart', 1, 0),
(110, 'displayAfterHookTop', 'displayAfterHookTop', '', 1, 1),
(111, 'actionOrderHistoryAddAfter', 'actionOrderHistoryAddAfter', '', 0, 0),
(112, 'actionObjectProductDeleteBefore', 'actionObjectProductDeleteBefore', '', 0, 0),
(113, 'displayAfterDefautlFooterHook', 'displayAfterDefautlFooterHook', '', 1, 1),
(114, 'addWebserviceResources', 'addWebserviceResources', '', 0, 0),
(115, 'actionObjectLanguageAddAfter', 'actionObjectLanguageAddAfter', '', 0, 0),
(116, 'actionObjectProfileAddAfter', 'actionObjectProfileAddAfter', '', 0, 0),
(117, 'actionObjectProfileDeleteBefore', 'actionObjectProfileDeleteBefore', '', 0, 0),
(118, 'actionObjectGroupDeleteBefore', 'actionObjectGroupDeleteBefore', '', 0, 0),
(119, 'actionCartSummary', 'actionCartSummary', '', 0, 0),
(120, 'actionFrontControllerSetMedia', 'actionFrontControllerSetMedia', '', 0, 0),
(121, 'displayExternalNavigationHook', 'displayExternalNavigationHook', '', 1, 1),
(122, 'displayAfterHeaderHotelDesc', 'displayAfterHeaderHotelDesc', '', 1, 1),
(123, 'displayAddModuleSettingLink', 'displayAddModuleSettingLink', '', 1, 1),
(124, 'displayFooterNotificationHook', 'displayFooterNotificationHook', '', 1, 1),
(125, 'registerGDPRConsent', 'registerGDPRConsent', '', 0, 0),
(126, 'actionExportGDPRData', 'actionExportGDPRData', '', 0, 0),
(127, 'actionObjectCustomerUpdateBefore', 'actionObjectCustomerUpdateBefore', '', 0, 0),
(128, 'actionDeleteGDPRCustomer', 'actionDeleteGDPRCustomer', '', 0, 0),
(129, 'actionCustomerCartRulesModifier', 'actionCustomerCartRulesModifier', '', 0, 0),
(130, 'actionValidateCartRule', 'actionValidateCartRule', '', 0, 0),
(131, 'actionObjectCustomerDeleteAfter', 'actionObjectCustomerDeleteAfter', '', 0, 0),
(132, 'addOtherModuleSetting', 'addOtherModuleSetting', '', 0, 0),
(133, 'displayFooterExploreSectionHook', 'displayFooterExploreSectionHook', '', 1, 1),
(134, 'actionCleanData', 'actionCleanData', '', 0, 0),
(135, 'displayPaymentEU', 'displayPaymentEU', '', 1, 1),
(137, 'actionModuleRegisterHookAfter', 'actionModuleRegisterHookAfter', '', 0, 0),
(138, 'actionModuleUnRegisterHookAfter', 'actionModuleUnRegisterHookAfter', '', 0, 0),
(139, 'displayFooterBefore', 'displayFooterBefore', '', 1, 1),
(140, 'displayRoomTypeDetailRoomTypeNameAfter', 'displayRoomTypeDetailRoomTypeNameAfter', '', 1, 1),
(141, 'actionRoomBookingStatusUpdateAfter', 'actionRoomBookingStatusUpdateAfter', '', 0, 0),
(142, 'displayBookingAction', 'displayBookingAction', '', 1, 1),
(143, 'displayAdminAfterHeader', 'displayAdminAfterHeader', '', 1, 1),
(144, 'displayFooterMostLeftBlock', 'displayFooterMostLeftBlock', '', 1, 1),
(145, 'displayFooterPaymentInfo', 'displayFooterPaymentInfo', '', 1, 1),
(146, 'actionObjectCMSUpdateAfter', 'actionObjectCMSUpdateAfter', '', 0, 0),
(147, 'actionObjectCMSDeleteAfter', 'actionObjectCMSDeleteAfter', '', 0, 0),
(148, 'displayDefaultNavigationHook', 'displayDefaultNavigationHook', '', 1, 1),
(149, 'displayNavigationHook', 'displayNavigationHook', '', 1, 1),
(150, 'dashboardTop', 'dashboardTop', '', 0, 0),
(151, 'dashboardZoneTwo', 'dashboardZoneTwo', '', 0, 0),
(152, 'dashboardData', 'dashboardData', '', 0, 0),
(153, 'actionAdminControllerSetMedia', 'actionAdminControllerSetMedia', '', 0, 0),
(154, 'dashboardZoneOne', 'dashboardZoneOne', '', 0, 0),
(155, 'actionObjectOrderAddAfter', 'actionObjectOrderAddAfter', '', 0, 0),
(156, 'actionObjectCustomerAddAfter', 'actionObjectCustomerAddAfter', '', 0, 0),
(157, 'actionObjectCustomerMessageAddAfter', 'actionObjectCustomerMessageAddAfter', '', 0, 0),
(158, 'actionObjectCustomerThreadAddAfter', 'actionObjectCustomerThreadAddAfter', '', 0, 0),
(159, 'actionObjectOrderReturnAddAfter', 'actionObjectOrderReturnAddAfter', '', 0, 0),
(160, 'actionCartListOverride', 'actionCartListOverride', '', 0, 0),
(161, 'displayAdminListBefore', 'displayAdminListBefore', '', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]hook_alias`
--
CREATE TABLE `[[dbprefix]]hook_alias` (
`id_hook_alias` int(10) unsigned NOT NULL AUTO_INCREMENT,
`alias` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`id_hook_alias`),
UNIQUE KEY `alias` (`alias`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=87 ;
--
-- Dumping data for table `[[dbprefix]]hook_alias`
--
INSERT INTO `[[dbprefix]]hook_alias` VALUES
(1, 'payment', 'displayPayment'),
(2, 'newOrder', 'actionValidateOrder'),
(3, 'paymentConfirm', 'actionPaymentConfirmation'),
(4, 'paymentReturn', 'displayPaymentReturn'),
(5, 'updateQuantity', 'actionUpdateQuantity'),
(6, 'rightColumn', 'displayRightColumn'),
(7, 'leftColumn', 'displayLeftColumn'),
(8, 'home', 'displayHome'),
(9, 'displayHeader', 'Header'),
(10, 'cart', 'actionCartSave'),
(11, 'authentication', 'actionAuthentication'),
(12, 'addproduct', 'actionProductAdd'),
(13, 'updateproduct', 'actionProductUpdate'),
(14, 'top', 'displayTop'),
(15, 'extraRight', 'displayRightColumnProduct'),
(16, 'deleteproduct', 'actionProductDelete'),
(17, 'productfooter', 'displayFooterProduct'),
(18, 'invoice', 'displayInvoice'),
(19, 'updateOrderStatus', 'actionOrderStatusUpdate'),
(20, 'adminOrder', 'displayAdminOrder'),
(21, 'footer', 'displayFooter'),
(22, 'PDFInvoice', 'displayPDFInvoice'),
(23, 'adminCustomers', 'displayAdminCustomers'),
(24, 'orderConfirmation', 'displayOrderConfirmation'),
(25, 'createAccount', 'actionCustomerAccountAdd'),
(26, 'customerAccount', 'displayCustomerAccount'),
(27, 'orderSlip', 'actionOrderSlipAdd'),
(28, 'productTab', 'displayProductTab'),
(29, 'productTabContent', 'displayProductTabContent'),
(30, 'shoppingCart', 'displayShoppingCartFooter'),
(31, 'createAccountForm', 'displayCustomerAccountForm'),
(32, 'AdminStatsModules', 'displayAdminStatsModules'),
(33, 'GraphEngine', 'displayAdminStatsGraphEngine'),
(34, 'orderReturn', 'actionOrderReturn'),
(35, 'productActions', 'displayProductButtons'),
(36, 'backOfficeHome', 'displayBackOfficeHome'),
(37, 'GridEngine', 'displayAdminStatsGridEngine'),
(38, 'watermark', 'actionWatermark'),
(39, 'cancelProduct', 'actionProductCancel'),
(40, 'extraLeft', 'displayLeftColumnProduct'),
(41, 'productOutOfStock', 'actionProductOutOfStock'),
(42, 'updateProductAttribute', 'actionProductAttributeUpdate'),
(43, 'extraCarrier', 'displayCarrierList'),
(44, 'shoppingCartExtra', 'displayShoppingCart'),
(45, 'search', 'actionSearch'),
(46, 'backBeforePayment', 'displayBeforePayment'),
(47, 'updateCarrier', 'actionCarrierUpdate'),
(48, 'postUpdateOrderStatus', 'actionOrderStatusPostUpdate'),
(49, 'createAccountTop', 'displayCustomerAccountFormTop'),
(50, 'backOfficeHeader', 'displayBackOfficeHeader'),
(51, 'backOfficeTop', 'displayBackOfficeTop'),
(52, 'backOfficeFooter', 'displayBackOfficeFooter'),
(53, 'deleteProductAttribute', 'actionProductAttributeDelete'),
(54, 'processCarrier', 'actionCarrierProcess'),
(55, 'orderDetail', 'actionOrderDetail'),
(56, 'beforeCarrier', 'displayBeforeCarrier'),
(57, 'orderDetailDisplayed', 'displayOrderDetail'),
(58, 'paymentCCAdded', 'actionPaymentCCAdd'),
(59, 'extraProductComparison', 'displayProductComparison'),
(60, 'categoryAddition', 'actionCategoryAdd'),
(61, 'categoryUpdate', 'actionCategoryUpdate'),
(62, 'categoryDeletion', 'actionCategoryDelete'),
(63, 'beforeAuthentication', 'actionBeforeAuthentication'),
(64, 'paymentTop', 'displayPaymentTop'),
(65, 'afterCreateHtaccess', 'actionHtaccessCreate'),
(66, 'afterSaveAdminMeta', 'actionAdminMetaSave'),
(67, 'attributeGroupForm', 'displayAttributeGroupForm'),
(68, 'afterSaveAttributeGroup', 'actionAttributeGroupSave'),
(69, 'afterDeleteAttributeGroup', 'actionAttributeGroupDelete'),
(70, 'featureForm', 'displayFeatureForm'),
(71, 'afterSaveFeature', 'actionFeatureSave'),
(72, 'afterDeleteFeature', 'actionFeatureDelete'),
(73, 'afterSaveProduct', 'actionProductSave'),
(74, 'productListAssign', 'actionProductListOverride'),
(75, 'postProcessAttributeGroup', 'displayAttributeGroupPostProcess'),
(76, 'postProcessFeature', 'displayFeaturePostProcess'),
(77, 'featureValueForm', 'displayFeatureValueForm'),
(78, 'postProcessFeatureValue', 'displayFeatureValuePostProcess'),
(79, 'afterDeleteFeatureValue', 'actionFeatureValueDelete'),
(80, 'afterSaveFeatureValue', 'actionFeatureValueSave'),
(81, 'attributeForm', 'displayAttributeForm'),
(82, 'postProcessAttribute', 'actionAttributePostProcess'),
(83, 'afterDeleteAttribute', 'actionAttributeDelete'),
(84, 'afterSaveAttribute', 'actionAttributeSave'),
(85, 'taxManager', 'actionTaxManager'),
(86, 'myAccountBlock', 'displayMyAccountBlock');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]hook_module`
--
CREATE TABLE `[[dbprefix]]hook_module` (
`id_module` int(10) unsigned NOT NULL,
`id_shop` int(11) unsigned NOT NULL DEFAULT '1',
`id_hook` int(10) unsigned NOT NULL,
`position` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`id_module`,`id_hook`,`id_shop`),
KEY `id_hook` (`id_hook`),
KEY `id_module` (`id_module`),
KEY `position` (`id_shop`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]hook_module`
--
INSERT INTO `[[dbprefix]]hook_module` VALUES
(1, 1, 10, 1),
(1, 1, 15, 1),
(1, 1, 26, 1),
(1, 1, 55, 1),
(1, 1, 57, 1),
(1, 1, 82, 1),
(1, 1, 103, 1),
(1, 1, 110, 1),
(1, 1, 111, 1),
(1, 1, 112, 1),
(1, 1, 113, 1),
(1, 1, 114, 1),
(1, 1, 115, 1),
(1, 1, 116, 1),
(1, 1, 117, 1),
(1, 1, 118, 1),
(1, 1, 119, 1),
(1, 1, 120, 1),
(1, 1, 121, 1),
(2, 1, 8, 1),
(2, 1, 122, 1),
(2, 1, 123, 1),
(3, 1, 26, 1),
(3, 1, 31, 1),
(3, 1, 124, 1),
(3, 1, 125, 1),
(3, 1, 126, 1),
(3, 1, 127, 1),
(3, 1, 128, 1),
(3, 1, 129, 1),
(3, 1, 130, 1),
(3, 1, 131, 1),
(5, 1, 132, 1),
(6, 1, 9, 1),
(6, 1, 133, 1),
(8, 1, 17, 1),
(8, 1, 134, 1),
(10, 1, 1, 1),
(10, 1, 5, 1),
(10, 1, 135, 1),
(12, 1, 137, 1),
(12, 1, 138, 1),
(15, 1, 35, 1),
(15, 1, 36, 1),
(15, 1, 139, 1),
(15, 1, 140, 1),
(15, 1, 141, 1),
(15, 1, 142, 1),
(15, 1, 143, 1),
(18, 1, 144, 1),
(19, 1, 145, 1),
(21, 1, 146, 1),
(21, 1, 147, 1),
(21, 1, 148, 1),
(21, 1, 149, 1),
(22, 1, 150, 1),
(22, 1, 151, 1),
(22, 1, 152, 1),
(22, 1, 153, 1),
(23, 1, 154, 1),
(24, 1, 155, 1),
(24, 1, 156, 1),
(24, 1, 157, 1),
(24, 1, 158, 1),
(24, 1, 159, 1),
(28, 1, 52, 1),
(31, 1, 40, 1),
(33, 1, 39, 1),
(52, 1, 160, 1),
(54, 1, 2, 1),
(54, 1, 161, 1),
(2, 1, 10, 2),
(2, 1, 110, 2),
(2, 1, 120, 2),
(4, 1, 124, 2),
(5, 1, 8, 2),
(6, 1, 115, 2),
(7, 1, 9, 2),
(7, 1, 133, 2),
(8, 1, 82, 2),
(11, 1, 1, 2),
(11, 1, 5, 2),
(11, 1, 135, 2),
(13, 1, 103, 2),
(13, 1, 121, 2),
(15, 1, 57, 2),
(15, 1, 134, 2),
(21, 1, 15, 2),
(23, 1, 152, 2),
(23, 1, 153, 2),
(25, 1, 55, 2),
(25, 1, 151, 2),
(28, 1, 155, 2),
(30, 1, 154, 2),
(34, 1, 39, 2),
(3, 1, 10, 3),
(7, 1, 115, 3),
(8, 1, 9, 3),
(8, 1, 133, 3),
(12, 1, 8, 3),
(13, 1, 120, 3),
(14, 1, 103, 3),
(14, 1, 121, 3),
(16, 1, 26, 3),
(24, 1, 152, 3),
(24, 1, 153, 3),
(24, 1, 154, 3),
(26, 1, 151, 3),
(35, 1, 39, 3),
(36, 1, 15, 3),
(54, 1, 57, 3),
(1, 1, 8, 4),
(5, 1, 10, 4),
(8, 1, 115, 4),
(9, 1, 9, 4),
(9, 1, 133, 4),
(14, 1, 120, 4),
(17, 1, 26, 4),
(25, 1, 152, 4),
(25, 1, 153, 4),
(27, 1, 151, 4),
(36, 1, 39, 4),
(45, 1, 15, 4),
(53, 1, 121, 4),
(9, 1, 115, 5),
(12, 1, 10, 5),
(15, 1, 120, 5),
(20, 1, 26, 5),
(26, 1, 152, 5),
(26, 1, 153, 5),
(28, 1, 151, 5),
(37, 1, 39, 5),
(52, 1, 15, 5),
(21, 1, 26, 6),
(21, 1, 115, 6),
(27, 1, 152, 6),
(27, 1, 153, 6),
(30, 1, 151, 6),
(38, 1, 39, 6),
(52, 1, 10, 6),
(53, 1, 15, 6),
(28, 1, 152, 7),
(28, 1, 153, 7),
(29, 1, 151, 7),
(32, 1, 26, 7),
(39, 1, 39, 7),
(53, 1, 10, 7),
(29, 1, 152, 8),
(29, 1, 153, 8),
(40, 1, 39, 8),
(30, 1, 152, 9),
(30, 1, 153, 9),
(41, 1, 39, 9),
(31, 1, 153, 10),
(42, 1, 39, 10),
(39, 1, 153, 11),
(43, 1, 39, 11),
(44, 1, 39, 12),
(54, 1, 153, 12),
(45, 1, 39, 13),
(46, 1, 39, 14),
(47, 1, 39, 15),
(48, 1, 39, 16),
(49, 1, 39, 17),
(50, 1, 39, 18),
(51, 1, 39, 19);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]hook_module_exceptions`
--
CREATE TABLE `[[dbprefix]]hook_module_exceptions` (
`id_hook_module_exceptions` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop` int(11) unsigned NOT NULL DEFAULT '1',
`id_module` int(10) unsigned NOT NULL,
`id_hook` int(10) unsigned NOT NULL,
`file_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_hook_module_exceptions`),
KEY `id_module` (`id_module`),
KEY `id_hook` (`id_hook`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]hook_module_exceptions`
--
INSERT INTO `[[dbprefix]]hook_module_exceptions` VALUES
(1, 1, 12, 8, 'category');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_access`
--
CREATE TABLE `[[dbprefix]]htl_access` (
`id_profile` int(10) unsigned NOT NULL,
`id_hotel` int(10) unsigned NOT NULL,
`access` int(11) NOT NULL,
PRIMARY KEY (`id_profile`,`id_hotel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]htl_access`
--
INSERT INTO `[[dbprefix]]htl_access` VALUES
(1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_advance_payment`
--
CREATE TABLE `[[dbprefix]]htl_advance_payment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_product` int(11) NOT NULL,
`payment_type` tinyint(4) NOT NULL,
`value` decimal(20,6) NOT NULL,
`id_currency` int(11) NOT NULL,
`tax_include` tinyint(4) NOT NULL,
`calculate_from` tinyint(4) NOT NULL,
`active` tinyint(4) NOT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `[[dbprefix]]htl_advance_payment`
--
INSERT INTO `[[dbprefix]]htl_advance_payment` VALUES
(1, 1, 0, '0.000000', 0, 0, 0, 0, '[[regtime]]', '[[regtime]]'),
(2, 2, 0, '0.000000', 0, 0, 0, 0, '[[regtime]]', '[[regtime]]'),
(3, 3, 0, '0.000000', 0, 0, 0, 0, '[[regtime]]', '[[regtime]]'),
(4, 4, 0, '0.000000', 0, 0, 0, 0, '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_booking_demands`
--
CREATE TABLE `[[dbprefix]]htl_booking_demands` (
`id_booking_demand` int(11) NOT NULL AUTO_INCREMENT,
`id_htl_booking` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`unit_price_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`unit_price_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`total_price_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`total_price_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`price_calc_method` int(11) unsigned DEFAULT '0',
`id_tax_rules_group` int(11) unsigned DEFAULT '0',
`tax_computation_method` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_booking_demand`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_booking_demands_tax`
--
CREATE TABLE `[[dbprefix]]htl_booking_demands_tax` (
`id_booking_demand` int(11) NOT NULL AUTO_INCREMENT,
`id_tax` int(11) NOT NULL,
`unit_amount` decimal(16,6) NOT NULL DEFAULT '0.000000',
`total_amount` decimal(16,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (`id_booking_demand`,`id_tax`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_booking_detail`
--
CREATE TABLE `[[dbprefix]]htl_booking_detail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_product` int(11) NOT NULL,
`id_order` int(11) NOT NULL,
`id_order_detail` int(11) NOT NULL,
`id_cart` int(11) NOT NULL,
`id_room` int(11) NOT NULL,
`id_hotel` int(11) NOT NULL,
`id_customer` int(11) NOT NULL,
`booking_type` tinyint(4) NOT NULL,
`id_status` int(11) NOT NULL,
`comment` text NOT NULL,
`check_in` datetime NOT NULL,
`check_out` datetime NOT NULL,
`date_from` datetime NOT NULL,
`date_to` datetime NOT NULL,
`total_price_tax_excl` decimal(20,6) NOT NULL,
`total_price_tax_incl` decimal(20,6) NOT NULL,
`total_paid_amount` decimal(20,6) NOT NULL DEFAULT '0.000000',
`is_back_order` tinyint(4) NOT NULL,
`hotel_name` varchar(255) DEFAULT NULL,
`room_type_name` varchar(255) DEFAULT NULL,
`city` varchar(255) NOT NULL,
`state` varchar(255) DEFAULT NULL,
`country` varchar(255) DEFAULT NULL,
`zipcode` varchar(12) DEFAULT NULL,
`phone` varchar(32) DEFAULT NULL,
`email` varchar(128) DEFAULT NULL,
`check_in_time` varchar(32) DEFAULT NULL,
`check_out_time` varchar(32) DEFAULT NULL,
`room_num` varchar(225) DEFAULT NULL,
`adults` smallint(6) NOT NULL DEFAULT '0',
`children` smallint(6) NOT NULL DEFAULT '0',
`child_ages` text NOT NULL,
`is_refunded` tinyint(1) NOT NULL DEFAULT '0',
`is_cancelled` tinyint(1) NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_booking_document`
--
CREATE TABLE `[[dbprefix]]htl_booking_document` (
`id_htl_booking_document` int(11) NOT NULL AUTO_INCREMENT,
`id_htl_booking` int(11) NOT NULL,
`title` varchar(32) NOT NULL DEFAULT '',
`file_type` tinyint(1) NOT NULL DEFAULT '0',
`file_name` varchar(8) NOT NULL DEFAULT '',
`date_add` datetime NOT NULL,
PRIMARY KEY (`id_htl_booking_document`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_branch_features`
--
CREATE TABLE `[[dbprefix]]htl_branch_features` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_hotel` int(10) unsigned NOT NULL,
`feature_id` varchar(255) DEFAULT NULL,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `[[dbprefix]]htl_branch_features`
--
INSERT INTO `[[dbprefix]]htl_branch_features` VALUES
(1, 1, '1', '[[regtime]]', '[[regtime]]'),
(2, 1, '2', '[[regtime]]', '[[regtime]]'),
(3, 1, '4', '[[regtime]]', '[[regtime]]'),
(4, 1, '7', '[[regtime]]', '[[regtime]]'),
(5, 1, '8', '[[regtime]]', '[[regtime]]'),
(6, 1, '9', '[[regtime]]', '[[regtime]]'),
(7, 1, '11', '[[regtime]]', '[[regtime]]'),
(8, 1, '12', '[[regtime]]', '[[regtime]]'),
(9, 1, '14', '[[regtime]]', '[[regtime]]'),
(10, 1, '16', '[[regtime]]', '[[regtime]]'),
(11, 1, '17', '[[regtime]]', '[[regtime]]'),
(12, 1, '18', '[[regtime]]', '[[regtime]]'),
(13, 1, '21', '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_branch_info`
--
CREATE TABLE `[[dbprefix]]htl_branch_info` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_category` int(10) unsigned NOT NULL,
`email` varchar(128) NOT NULL,
`check_in` varchar(255) DEFAULT NULL,
`check_out` varchar(255) DEFAULT NULL,
`rating` int(2) unsigned NOT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`latitude` decimal(10,8) NOT NULL,
`longitude` decimal(11,8) NOT NULL,
`map_formated_address` text NOT NULL,
`map_input_text` text NOT NULL,
`active_refund` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]htl_branch_info`
--
INSERT INTO `[[dbprefix]]htl_branch_info` VALUES
(1, 8, 'hotelprime@htl.com', '12:00', '11:00', 3, 1, '0.00000000', '0.00000000', '', '', 0, '[[regtime]]', '[[regtime]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]htl_branch_info_lang`
--
CREATE TABLE `[[dbprefix]]htl_branch_info_lang` (
`id` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`hotel_name` varchar(255) DEFAULT NULL,
`short_description` text,
`description` text,
`policies` text,
PRIMARY KEY (`id`,`id_lang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `[[dbprefix]]htl_branch_info_lang`
--
INSERT INTO `[[dbprefix]]htl_branch_info_lang` VALUES
(1, 1, 'The Hotel Prime', 'The Hotel Prime is the perfect destination for both business and leisure travelers seeking a memorable stay.', '\n
Welcome to The Hotel Prime!
\n
\n
Our hotel is the perfect destination for both business and leisure travelers seeking a memorable stay.
\n
\n
Benefits of staying at The Hotel Prime!
\n
\n
Accommodation:
\n
Indulge in our well-appointed rooms and suites, exquisitely designed to provide a tranquil haven after a long\n day of exploration or meetings. Each room is tastefully furnished with modern amenities, including a plush bed,\n a spacious work desk, high-speed Wi-Fi, a TV, and a private bathroom adorned with luxurious toiletries.
\n
\n
Dining:
\n
Savor a delightful culinary experience at our onsite restaurant, where our world-class chefs craft delectable\n dishes using the finest ingredients. Whether you crave international flavors or local specialties, our diverse\n menu is sure to satisfy every palate. Enjoy a romantic dinner for two or gather with friends and family in our\n inviting dining ambiance.
\n
\n
Facilities:
\n
We believe in providing our guests with a range of facilities to enhance their stay. Take a refreshing dip in\n our sparkling swimming pool, work up a sweat in our state-of-the-art fitness center, or unwind with a\n rejuvenating spa treatment. Our attentive staff is always on hand to ensure your needs are met with utmost care\n and professionalism.
\n
\n
Events and Meetings:
\n
Host your next corporate event or special occasion in our versatile event spaces, equipped with the latest\n audiovisual technology and flexible seating arrangements. From intimate boardroom meetings to grand\n celebrations, our dedicated event planners will assist you in creating a seamless and successful gathering.\n
\n
\n
Location:
\n
Conveniently located close to major attractions and business districts, our hotel offers easy access to\n Alabamas vibrant shopping districts, cultural landmarks, and entertainment venues. Whether you''re here for\n business or leisure, our prime location ensures that you''re never far from the action.
\n
\n
Exceptional Service:
\n
At The Hotel Prime, we take pride in delivering exceptional service to our guests. From the moment you step\n through our doors, our friendly and knowledgeable staff will cater to your every need, ensuring a memorable and\n personalized stay.
\n
\n
Book Your Stay:
\n
Ready to experience the epitome of luxury and comfort? Book your stay at The Hotel Prime today and let us\n create an unforgettable experience for you. Whether you''re traveling solo, with a loved one, or with a group,\n our hotel is dedicated to surpassing your expectations and making your stay truly exceptional.
\n
- Accommodation will only be provided to guests whose details are registered with the hotel front desk.
\n
- Guests are required to show a valid photo identification during check-in.
\n
- GST / Taxes are charged extra and applicable as per government directives.
\n
- 100 % advance Payment deposit at the time of Check-in.
\n
- The check-in time is 12:00 PM & check-out time is 11:00 AM. (Subject to availability, early check-in, and late check-out will be considered)
\n
- The hotel may deny further accommodation to a guest who does not prove to be decent and comply with the hotel policy and rules.
\n
- The guest has to bear any loss caused by them to the hotel property.