/home/fresvfqn/waterdamagerestorationandrepairsmithtown.com/Compressed/osclassified.tar
osclassified.sql 0000644 00000214611 15054015335 0007743 0 ustar 00
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: `osclassified830`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_admin`
--
CREATE TABLE `[[dbprefix]]t_admin` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_username` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_password` char(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_moderator` tinyint(1) NOT NULL DEFAULT '0',
`s_moderator_access` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`i_login_fails` int(3) DEFAULT '0',
`dt_login_fail_date` datetime DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
UNIQUE KEY `s_username` (`s_username`),
UNIQUE KEY `s_email` (`s_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]t_admin`
--
INSERT INTO `[[dbprefix]]t_admin` VALUES
(1, 'Administrator', '[[admin_username]]', '[[admin_pass]]', '[[admin_email]]', NULL, 0, NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_alerts`
--
CREATE TABLE `[[dbprefix]]t_alerts` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_user_id` int(10) unsigned DEFAULT NULL,
`s_search` text COLLATE utf8mb4_unicode_ci,
`s_param` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_sql` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_active` tinyint(1) NOT NULL DEFAULT '0',
`e_type` enum('INSTANT','HOURLY','DAILY','WEEKLY','CUSTOM') COLLATE utf8mb4_unicode_ci NOT NULL,
`i_num_trigger` int(10) DEFAULT '0',
`dt_date` datetime DEFAULT NULL,
`dt_unsub_date` datetime DEFAULT NULL,
PRIMARY KEY (`pk_i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_alerts_sent`
--
CREATE TABLE `[[dbprefix]]t_alerts_sent` (
`d_date` date NOT NULL,
`i_num_alerts_sent` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`d_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_ban_rule`
--
CREATE TABLE `[[dbprefix]]t_ban_rule` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_name` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`s_ip` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`s_email` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`i_hit` int(10) DEFAULT '1',
`dt_date` datetime DEFAULT CURRENT_TIMESTAMP,
`dt_expire_date` date DEFAULT NULL,
PRIMARY KEY (`pk_i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_category`
--
CREATE TABLE `[[dbprefix]]t_category` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_i_parent_id` int(10) unsigned DEFAULT NULL,
`i_expiration_days` int(3) unsigned NOT NULL DEFAULT '0',
`i_position` int(2) unsigned NOT NULL DEFAULT '0',
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
`b_price_enabled` tinyint(1) NOT NULL DEFAULT '1',
`s_icon` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_color` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_parent_id` (`fk_i_parent_id`),
KEY `i_position` (`i_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=96 ;
--
-- Dumping data for table `[[dbprefix]]t_category`
--
INSERT INTO `[[dbprefix]]t_category` VALUES
(1, NULL, 0, 1, 1, 1, NULL, NULL),
(2, NULL, 0, 2, 1, 1, NULL, NULL),
(3, NULL, 0, 3, 1, 1, NULL, NULL),
(4, NULL, 0, 4, 1, 1, NULL, NULL),
(5, NULL, 0, 5, 1, 1, NULL, NULL),
(6, NULL, 0, 6, 1, 1, NULL, NULL),
(7, NULL, 0, 7, 1, 1, NULL, NULL),
(8, NULL, 0, 8, 1, 1, NULL, NULL),
(9, 1, 0, 1, 1, 1, NULL, NULL),
(10, 1, 0, 2, 1, 1, NULL, NULL),
(11, 1, 0, 3, 1, 1, NULL, NULL),
(12, 1, 0, 4, 1, 1, NULL, NULL),
(13, 1, 0, 5, 1, 1, NULL, NULL),
(14, 1, 0, 6, 1, 1, NULL, NULL),
(15, 1, 0, 7, 1, 1, NULL, NULL),
(16, 1, 0, 8, 1, 1, NULL, NULL),
(17, 1, 0, 9, 1, 1, NULL, NULL),
(18, 1, 0, 10, 1, 1, NULL, NULL),
(19, 1, 0, 11, 1, 1, NULL, NULL),
(20, 1, 0, 12, 1, 1, NULL, NULL),
(21, 1, 0, 13, 1, 1, NULL, NULL),
(22, 1, 0, 14, 1, 1, NULL, NULL),
(23, 1, 0, 15, 1, 1, NULL, NULL),
(24, 1, 0, 16, 1, 1, NULL, NULL),
(25, 1, 0, 17, 1, 1, NULL, NULL),
(26, 1, 0, 18, 1, 1, NULL, NULL),
(27, 1, 0, 19, 1, 1, NULL, NULL),
(28, 1, 0, 20, 1, 1, NULL, NULL),
(29, 1, 0, 21, 1, 1, NULL, NULL),
(30, 1, 0, 22, 1, 1, NULL, NULL),
(31, 2, 0, 1, 1, 1, NULL, NULL),
(32, 2, 0, 2, 1, 1, NULL, NULL),
(33, 2, 0, 3, 1, 1, NULL, NULL),
(34, 2, 0, 4, 1, 1, NULL, NULL),
(35, 2, 0, 5, 1, 1, NULL, NULL),
(36, 2, 0, 6, 1, 1, NULL, NULL),
(37, 2, 0, 7, 1, 1, NULL, NULL),
(38, 3, 0, 1, 1, 1, NULL, NULL),
(39, 3, 0, 2, 1, 1, NULL, NULL),
(40, 3, 0, 3, 1, 1, NULL, NULL),
(41, 3, 0, 4, 1, 1, NULL, NULL),
(42, 3, 0, 5, 1, 1, NULL, NULL),
(43, 4, 0, 1, 1, 1, NULL, NULL),
(44, 4, 0, 2, 1, 1, NULL, NULL),
(45, 4, 0, 3, 1, 1, NULL, NULL),
(46, 4, 0, 4, 1, 1, NULL, NULL),
(47, 4, 0, 5, 1, 1, NULL, NULL),
(48, 4, 0, 6, 1, 1, NULL, NULL),
(49, 4, 0, 7, 1, 1, NULL, NULL),
(50, 4, 0, 8, 1, 1, NULL, NULL),
(51, 4, 0, 9, 1, 1, NULL, NULL),
(52, 5, 0, 1, 1, 1, NULL, NULL),
(53, 5, 0, 2, 1, 1, NULL, NULL),
(54, 5, 0, 3, 1, 1, NULL, NULL),
(55, 5, 0, 4, 1, 1, NULL, NULL),
(56, 5, 0, 5, 1, 1, NULL, NULL),
(57, 5, 0, 6, 1, 1, NULL, NULL),
(58, 5, 0, 7, 1, 1, NULL, NULL),
(59, 5, 0, 8, 1, 1, NULL, NULL),
(60, 5, 0, 9, 1, 1, NULL, NULL),
(61, 5, 0, 10, 1, 1, NULL, NULL),
(62, 5, 0, 11, 1, 1, NULL, NULL),
(63, 6, 0, 1, 1, 1, NULL, NULL),
(64, 6, 0, 2, 1, 1, NULL, NULL),
(65, 6, 0, 3, 1, 1, NULL, NULL),
(66, 6, 0, 4, 1, 1, NULL, NULL),
(67, 6, 0, 5, 1, 1, NULL, NULL),
(68, 6, 0, 6, 1, 1, NULL, NULL),
(69, 7, 0, 1, 1, 1, NULL, NULL),
(70, 7, 0, 2, 1, 1, NULL, NULL),
(71, 7, 0, 3, 1, 1, NULL, NULL),
(72, 7, 0, 4, 1, 1, NULL, NULL),
(73, 7, 0, 5, 1, 1, NULL, NULL),
(74, 7, 0, 6, 1, 1, NULL, NULL),
(75, 8, 0, 1, 1, 1, NULL, NULL),
(76, 8, 0, 2, 1, 1, NULL, NULL),
(77, 8, 0, 3, 1, 1, NULL, NULL),
(78, 8, 0, 4, 1, 1, NULL, NULL),
(79, 8, 0, 5, 1, 1, NULL, NULL),
(80, 8, 0, 6, 1, 1, NULL, NULL),
(81, 8, 0, 7, 1, 1, NULL, NULL),
(82, 8, 0, 8, 1, 1, NULL, NULL),
(83, 8, 0, 9, 1, 1, NULL, NULL),
(84, 8, 0, 10, 1, 1, NULL, NULL),
(85, 8, 0, 11, 1, 1, NULL, NULL),
(86, 8, 0, 12, 1, 1, NULL, NULL),
(87, 8, 0, 13, 1, 1, NULL, NULL),
(88, 8, 0, 14, 1, 1, NULL, NULL),
(89, 8, 0, 15, 1, 1, NULL, NULL),
(90, 8, 0, 16, 1, 1, NULL, NULL),
(91, 8, 0, 17, 1, 1, NULL, NULL),
(92, 8, 0, 18, 1, 1, NULL, NULL),
(93, 8, 0, 19, 1, 1, NULL, NULL),
(94, 8, 0, 20, 1, 1, NULL, NULL),
(95, 8, 0, 21, 1, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_category_description`
--
CREATE TABLE `[[dbprefix]]t_category_description` (
`fk_i_category_id` int(10) unsigned NOT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_description` text COLLATE utf8mb4_unicode_ci,
`s_slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`fk_i_category_id`,`fk_c_locale_code`),
KEY `idx_s_slug` (`s_slug`),
KEY `fk_c_locale_code` (`fk_c_locale_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_category_description`
--
INSERT INTO `[[dbprefix]]t_category_description` VALUES
(1, 'en_US', 'For sale', NULL, 'for-sale'),
(2, 'en_US', 'Vehicles', NULL, 'vehicles'),
(3, 'en_US', 'Classes', NULL, 'classes'),
(4, 'en_US', 'Real estate', NULL, 'real-estate'),
(5, 'en_US', 'Services', NULL, 'services'),
(6, 'en_US', 'Community', NULL, 'community'),
(7, 'en_US', 'Personals', NULL, 'personals'),
(8, 'en_US', 'Jobs', NULL, 'jobs'),
(9, 'en_US', 'Animals', NULL, 'animals'),
(10, 'en_US', 'Art - Collectibles', NULL, 'art-collectibles'),
(11, 'en_US', 'Barter', NULL, 'barter'),
(12, 'en_US', 'Books - Magazines', NULL, 'books-magazines'),
(13, 'en_US', 'Cameras - Camera Accessories', NULL, 'cameras-camera-accessories'),
(14, 'en_US', 'CDs - Records', NULL, 'cds-records'),
(15, 'en_US', 'Cell Phones - Accessories', NULL, 'cell-phones-accessories'),
(16, 'en_US', 'Clothing', NULL, 'clothing'),
(17, 'en_US', 'Computers - Hardware', NULL, 'computers-hardware'),
(18, 'en_US', 'DVD', NULL, 'dvd'),
(19, 'en_US', 'Electronics', NULL, 'electronics'),
(20, 'en_US', 'For Babies - Infants', NULL, 'for-babies-infants'),
(21, 'en_US', 'Garage Sale', NULL, 'garage-sale'),
(22, 'en_US', 'Health - Beauty', NULL, 'health-beauty'),
(23, 'en_US', 'Home - Furniture - Garden Supplies', NULL, 'home-furniture-garden-supplies'),
(24, 'en_US', 'Jewelry - Watches', NULL, 'jewelry-watches'),
(25, 'en_US', 'Musical Instruments', NULL, 'musical-instruments'),
(26, 'en_US', 'Sporting Goods - Bicycles', NULL, 'sporting-goods-bicycles'),
(27, 'en_US', 'Tickets', NULL, 'tickets'),
(28, 'en_US', 'Toys - Games - Hobbies', NULL, 'toys-games-hobbies'),
(29, 'en_US', 'Video Games - Consoles', NULL, 'video-games-consoles'),
(30, 'en_US', 'Everything Else', NULL, 'everything-else'),
(31, 'en_US', 'Cars', NULL, 'cars'),
(32, 'en_US', 'Car Parts', NULL, 'car-parts'),
(33, 'en_US', 'Motorcycles', NULL, 'motorcycles'),
(34, 'en_US', 'Boats - Ships', NULL, 'boats-ships'),
(35, 'en_US', 'RVs - Campers - Caravans', NULL, 'rvs-campers-caravans'),
(36, 'en_US', 'Trucks - Commercial Vehicles', NULL, 'trucks-commercial-vehicles'),
(37, 'en_US', 'Other Vehicles', NULL, 'other-vehicles'),
(38, 'en_US', 'Computer - Multimedia Classes', NULL, 'computer-multimedia-classes'),
(39, 'en_US', 'Language Classes', NULL, 'language-classes'),
(40, 'en_US', 'Music - Theatre - Dance Classes', NULL, 'music-theatre-dance-classes'),
(41, 'en_US', 'Tutoring - Private Lessons', NULL, 'tutoring-private-lessons'),
(42, 'en_US', 'Other Classes', NULL, 'other-classes'),
(43, 'en_US', 'Houses - Apartments for Sale', NULL, 'houses-apartments-for-sale'),
(44, 'en_US', 'Houses - Apartments for Rent', NULL, 'houses-apartments-for-rent'),
(45, 'en_US', 'Rooms for Rent - Shared', NULL, 'rooms-for-rent-shared'),
(46, 'en_US', 'Housing Swap', NULL, 'housing-swap'),
(47, 'en_US', 'Vacation Rentals', NULL, 'vacation-rentals'),
(48, 'en_US', 'Parking Spots', NULL, 'parking-spots'),
(49, 'en_US', 'Land', NULL, 'land'),
(50, 'en_US', 'Office - Commercial Space', NULL, 'office-commercial-space'),
(51, 'en_US', 'Shops for Rent - Sale', NULL, 'shops-for-rent-sale'),
(52, 'en_US', 'Babysitter - Nanny', NULL, 'babysitter-nanny'),
(53, 'en_US', 'Casting - Auditions', NULL, 'casting-auditions'),
(54, 'en_US', 'Computer', NULL, 'computer'),
(55, 'en_US', 'Event Services', NULL, 'event-services'),
(56, 'en_US', 'Health - Beauty - Fitness', NULL, 'health-beauty-fitness'),
(57, 'en_US', 'Horoscopes - Tarot', NULL, 'horoscopes-tarot'),
(58, 'en_US', 'Household - Domestic Help', NULL, 'household-domestic-help'),
(59, 'en_US', 'Moving - Storage', NULL, 'moving-storage'),
(60, 'en_US', 'Repair', NULL, 'repair'),
(61, 'en_US', 'Writing - Editing - Translating', NULL, 'writing-editing-translating'),
(62, 'en_US', 'Other Services', NULL, 'other-services'),
(63, 'en_US', 'Carpool', NULL, 'carpool'),
(64, 'en_US', 'Community Activities', NULL, 'community-activities'),
(65, 'en_US', 'Events', NULL, 'events'),
(66, 'en_US', 'Musicians - Artists - Bands', NULL, 'musicians-artists-bands'),
(67, 'en_US', 'Volunteers', NULL, 'volunteers'),
(68, 'en_US', 'Lost And Found', NULL, 'lost-and-found'),
(69, 'en_US', 'Women looking for Men', NULL, 'women-looking-for-men'),
(70, 'en_US', 'Men looking for Women', NULL, 'men-looking-for-women'),
(71, 'en_US', 'Men looking for Men', NULL, 'men-looking-for-men'),
(72, 'en_US', 'Women looking for Women', NULL, 'women-looking-for-women'),
(73, 'en_US', 'Friendship - Activity Partners', NULL, 'friendship-activity-partners'),
(74, 'en_US', 'Missed Connections', NULL, 'missed-connections'),
(75, 'en_US', 'Accounting - Finance', NULL, 'accounting-finance'),
(76, 'en_US', 'Advertising - Public Relations', NULL, 'advertising-public-relations'),
(77, 'en_US', 'Arts - Entertainment - Publishing', NULL, 'arts-entertainment-publishing'),
(78, 'en_US', 'Clerical - Administrative', NULL, 'clerical-administrative'),
(79, 'en_US', 'Customer Service', NULL, 'customer-service'),
(80, 'en_US', 'Education - Training', NULL, 'education-training'),
(81, 'en_US', 'Engineering - Architecture', NULL, 'engineering-architecture'),
(82, 'en_US', 'Healthcare', NULL, 'healthcare'),
(83, 'en_US', 'Human Resource', NULL, 'human-resource'),
(84, 'en_US', 'Internet', NULL, 'internet'),
(85, 'en_US', 'Legal', NULL, 'legal'),
(86, 'en_US', 'Manual Labor', NULL, 'manual-labor'),
(87, 'en_US', 'Manufacturing - Operations', NULL, 'manufacturing-operations'),
(88, 'en_US', 'Marketing', NULL, 'marketing'),
(89, 'en_US', 'Non-profit - Volunteer', NULL, 'non-profit-volunteer'),
(90, 'en_US', 'Real Estate', NULL, 'real-estate'),
(91, 'en_US', 'Restaurant - Food Service', NULL, 'restaurant-food-service'),
(92, 'en_US', 'Retail', NULL, 'retail'),
(93, 'en_US', 'Sales', NULL, 'sales'),
(94, 'en_US', 'Technology', NULL, 'technology'),
(95, 'en_US', 'Other Jobs', NULL, 'other-jobs');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_category_stats`
--
CREATE TABLE `[[dbprefix]]t_category_stats` (
`fk_i_category_id` int(10) unsigned NOT NULL,
`i_num_items` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fk_i_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_category_stats`
--
INSERT INTO `[[dbprefix]]t_category_stats` VALUES
(1, 1),
(9, 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_city`
--
CREATE TABLE `[[dbprefix]]t_city` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_i_region_id` int(10) unsigned NOT NULL,
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_slug` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`b_active` tinyint(1) NOT NULL DEFAULT '1',
`d_coord_lat` decimal(20,10) DEFAULT NULL,
`d_coord_long` decimal(20,10) DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_region_id` (`fk_i_region_id`),
KEY `fk_c_country_code` (`fk_c_country_code`),
KEY `idx_s_name` (`s_name`),
KEY `idx_s_name_native` (`s_name_native`),
KEY `idx_s_slug` (`s_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_city_area`
--
CREATE TABLE `[[dbprefix]]t_city_area` (
`pk_i_id` int(10) unsigned NOT NULL,
`fk_i_city_id` int(10) unsigned NOT NULL,
`fk_i_region_id` int(10) unsigned NOT NULL,
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_slug` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`b_active` tinyint(1) NOT NULL DEFAULT '1',
`d_coord_lat` decimal(20,10) DEFAULT NULL,
`d_coord_long` decimal(20,10) DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_city_id` (`fk_i_city_id`),
KEY `fk_i_region_id` (`fk_i_region_id`),
KEY `fk_c_country_code` (`fk_c_country_code`),
KEY `idx_s_name` (`s_name`),
KEY `idx_s_name_native` (`s_name_native`),
KEY `idx_s_slug` (`s_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_city_stats`
--
CREATE TABLE `[[dbprefix]]t_city_stats` (
`fk_i_city_id` int(10) unsigned NOT NULL,
`i_num_items` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fk_i_city_id`),
KEY `idx_num_items` (`i_num_items`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_country`
--
CREATE TABLE `[[dbprefix]]t_country` (
`pk_c_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name_native` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_phone_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_currency` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_slug` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`pk_c_code`),
KEY `idx_s_slug` (`s_slug`),
KEY `idx_s_name` (`s_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_country_stats`
--
CREATE TABLE `[[dbprefix]]t_country_stats` (
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
`i_num_items` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fk_c_country_code`),
KEY `idx_num_items` (`i_num_items`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_cron`
--
CREATE TABLE `[[dbprefix]]t_cron` (
`e_type` enum('INSTANT','MINUTELY','HOURLY','DAILY','WEEKLY','MONTHLY','YEARLY','CUSTOM') COLLATE utf8mb4_unicode_ci NOT NULL,
`d_last_exec` datetime NOT NULL,
`d_next_exec` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_cron`
--
INSERT INTO `[[dbprefix]]t_cron` VALUES
('MINUTELY', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('HOURLY', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('DAILY', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('WEEKLY', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('MONTHLY', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
('YEARLY', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_currency`
--
CREATE TABLE `[[dbprefix]]t_currency` (
`pk_c_code` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_description` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`pk_c_code`),
UNIQUE KEY `s_name` (`s_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_currency`
--
INSERT INTO `[[dbprefix]]t_currency` VALUES
('EUR', 'European Union Euro', '€', 1),
('GBP', 'United Kingdom Pound', '£', 1),
('USD', 'United States Dollar', '$', 1);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item`
--
CREATE TABLE `[[dbprefix]]t_item` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_i_user_id` int(10) unsigned DEFAULT NULL,
`fk_i_category_id` int(10) unsigned NOT NULL,
`dt_pub_date` datetime NOT NULL,
`dt_mod_date` datetime DEFAULT NULL,
`f_price` float DEFAULT NULL,
`i_price` bigint(20) DEFAULT NULL,
`fk_c_currency_code` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_contact_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_contact_email` varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_contact_phone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_contact_other` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_ip` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`b_premium` tinyint(1) NOT NULL DEFAULT '0',
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
`b_active` tinyint(1) NOT NULL DEFAULT '0',
`b_spam` tinyint(1) NOT NULL DEFAULT '0',
`s_secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_show_email` tinyint(1) DEFAULT NULL,
`b_show_phone` tinyint(1) DEFAULT '1',
`i_renewed` int(3) DEFAULT '0',
`dt_expiration` datetime NOT NULL DEFAULT '9999-12-31 23:59:59',
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_user_id` (`fk_i_user_id`),
KEY `idx_b_premium` (`b_premium`),
KEY `idx_s_contact_email` (`s_contact_email`(10)),
KEY `fk_i_category_id` (`fk_i_category_id`),
KEY `fk_c_currency_code` (`fk_c_currency_code`),
KEY `idx_pub_date` (`dt_pub_date`),
KEY `idx_price` (`i_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;
--
-- Dumping data for table `[[dbprefix]]t_item`
--
INSERT INTO `[[dbprefix]]t_item` VALUES
(1, NULL, 9, '[[regtime]]', NULL, NULL, NULL, NULL, 'Example author', 'osclass@example.com', '', '', '[[clientip]]', 0, 1, 1, 0, '[[s_secret]]', 0, 0, 0, '9999-12-31 23:59:59');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_comment`
--
CREATE TABLE `[[dbprefix]]t_item_comment` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_i_item_id` int(10) unsigned NOT NULL,
`dt_pub_date` datetime NOT NULL,
`s_title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_author_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_author_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_body` text COLLATE utf8mb4_unicode_ci NOT NULL,
`i_rating` int(3) DEFAULT NULL,
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
`b_active` tinyint(1) NOT NULL DEFAULT '0',
`b_spam` tinyint(1) NOT NULL DEFAULT '0',
`fk_i_user_id` int(10) unsigned DEFAULT NULL,
`fk_i_reply_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_item_id` (`fk_i_item_id`),
KEY `fk_i_user_id` (`fk_i_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_description`
--
CREATE TABLE `[[dbprefix]]t_item_description` (
`fk_i_item_id` int(10) unsigned NOT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`fk_i_item_id`,`fk_c_locale_code`),
FULLTEXT KEY `s_description` (`s_description`,`s_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_item_description`
--
INSERT INTO `[[dbprefix]]t_item_description` VALUES
(1, 'en_US', 'Example Ad', 'Description of the example ad. Insert here some usefull description of your ad.');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_location`
--
CREATE TABLE `[[dbprefix]]t_item_location` (
`fk_i_item_id` int(10) unsigned NOT NULL,
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_country` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_country_native` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_zip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_region_id` int(10) unsigned DEFAULT NULL,
`s_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_region_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_city_id` int(10) unsigned DEFAULT NULL,
`s_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_city_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_city_area_id` int(10) unsigned DEFAULT NULL,
`s_city_area` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`d_coord_lat` decimal(20,10) DEFAULT NULL,
`d_coord_long` decimal(20,10) DEFAULT NULL,
PRIMARY KEY (`fk_i_item_id`),
KEY `fk_c_country_code` (`fk_c_country_code`),
KEY `fk_i_region_id` (`fk_i_region_id`),
KEY `fk_i_city_id` (`fk_i_city_id`),
KEY `fk_i_city_area_id` (`fk_i_city_area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_item_location`
--
INSERT INTO `[[dbprefix]]t_item_location` VALUES
(1, NULL, 'Example country', '', '', NULL, NULL, 'Example region', NULL, NULL, 'Example city', NULL, NULL, '', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_meta`
--
CREATE TABLE `[[dbprefix]]t_item_meta` (
`fk_i_item_id` int(10) unsigned NOT NULL,
`fk_i_field_id` int(10) unsigned NOT NULL,
`s_value` text COLLATE utf8mb4_unicode_ci,
`s_multi` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`fk_i_item_id`,`fk_i_field_id`,`s_multi`),
KEY `s_value` (`s_value`(255)),
KEY `fk_i_field_id` (`fk_i_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_resource`
--
CREATE TABLE `[[dbprefix]]t_item_resource` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_i_item_id` int(10) unsigned NOT NULL,
`s_name` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_extension` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_content_type` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_path` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`i_order` int(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`pk_i_id`),
KEY `fk_i_item_id` (`fk_i_item_id`),
KEY `idx_s_content_type` (`pk_i_id`,`s_content_type`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_item_stats`
--
CREATE TABLE `[[dbprefix]]t_item_stats` (
`fk_i_item_id` int(10) unsigned NOT NULL,
`i_num_views` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_spam` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_repeated` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_bad_classified` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_offensive` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_expired` int(10) unsigned NOT NULL DEFAULT '0',
`i_num_premium_views` int(10) unsigned NOT NULL DEFAULT '0',
`dt_date` date NOT NULL,
PRIMARY KEY (`fk_i_item_id`,`dt_date`),
KEY `dt_date_fk_i_item_id` (`dt_date`,`fk_i_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_item_stats`
--
INSERT INTO `[[dbprefix]]t_item_stats` VALUES
(1, 0, 0, 0, 0, 0, 0, 0, '[[regdate]]');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_keywords`
--
CREATE TABLE `[[dbprefix]]t_keywords` (
`s_md5` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_original_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_anchor_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_normalized_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`fk_i_category_id` int(10) unsigned DEFAULT NULL,
`fk_i_city_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`s_md5`,`fk_c_locale_code`),
KEY `fk_i_category_id` (`fk_i_category_id`),
KEY `fk_i_city_id` (`fk_i_city_id`),
KEY `fk_c_locale_code` (`fk_c_locale_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_latest_searches`
--
CREATE TABLE `[[dbprefix]]t_latest_searches` (
`d_date` datetime NOT NULL,
`s_search` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_locale`
--
CREATE TABLE `[[dbprefix]]t_locale` (
`pk_c_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_short_name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_description` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_version` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_author_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_author_url` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_currency_format` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_dec_point` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '.',
`s_thousands_sep` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT '',
`i_num_dec` tinyint(4) DEFAULT '2',
`s_date_format` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_stop_words` text COLLATE utf8mb4_unicode_ci,
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
`b_enabled_bo` tinyint(1) NOT NULL DEFAULT '1',
`b_locations_native` tinyint(1) DEFAULT '0',
`b_rtl` tinyint(1) DEFAULT '0',
`fk_c_currency_code` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`pk_c_code`),
UNIQUE KEY `s_short_name` (`s_short_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_locale`
--
INSERT INTO `[[dbprefix]]t_locale` VALUES
('en_US', 'English (US)', 'English', 'American english translation', '8.3.0', 'OsclassPoint', 'https://osclass-classifieds.com/', '{NUMBER} {CURRENCY}', '.', '', 2, 'm/d/Y', 'i,a,about,an,are,as,at,be,by,com,for,from,how,in,is,it,of,on,or,that,the,this,to,was,what,when,where,who,will,with,the', 1, 1, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_locations_tmp`
--
CREATE TABLE `[[dbprefix]]t_locations_tmp` (
`id_location` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`e_type` enum('COUNTRY','REGION','CITY') COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id_location`,`e_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_log`
--
CREATE TABLE `[[dbprefix]]t_log` (
`dt_date` datetime NOT NULL,
`s_section` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`fk_i_id` int(10) unsigned NOT NULL,
`s_data` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_detail` text COLLATE utf8mb4_unicode_ci,
`s_comment` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_ip` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_who` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`fk_i_who_id` int(10) unsigned NOT NULL,
KEY `idx_s_section` (`s_section`),
KEY `idx_s_action` (`s_action`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_log`
--
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_meta_categories`
--
CREATE TABLE `[[dbprefix]]t_meta_categories` (
`fk_i_category_id` int(10) unsigned NOT NULL,
`fk_i_field_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`fk_i_category_id`,`fk_i_field_id`),
KEY `fk_i_field_id` (`fk_i_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_meta_fields`
--
CREATE TABLE `[[dbprefix]]t_meta_fields` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`e_type` enum('TEXT','NUMBER','TEL','EMAIL','COLOR','TEXTAREA','DROPDOWN','RADIO','CHECKBOX','URL','DATE','DATEINTERVAL') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TEXT',
`s_options` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_required` tinyint(1) NOT NULL DEFAULT '0',
`b_searchable` tinyint(1) NOT NULL DEFAULT '0',
`i_order` int(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`pk_i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_pages`
--
CREATE TABLE `[[dbprefix]]t_pages` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_internal_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_indelible` tinyint(1) NOT NULL DEFAULT '0',
`b_link` tinyint(1) NOT NULL DEFAULT '1',
`b_index` tinyint(1) NOT NULL DEFAULT '1',
`i_visibility` tinyint(1) DEFAULT '0',
`dt_pub_date` datetime NOT NULL,
`dt_mod_date` datetime DEFAULT NULL,
`i_order` int(3) NOT NULL DEFAULT '0',
`s_meta` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`pk_i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=24 ;
--
-- Dumping data for table `[[dbprefix]]t_pages`
--
INSERT INTO `[[dbprefix]]t_pages` VALUES
(1, 'email_item_inquiry', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(2, 'email_user_validation', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(3, 'email_user_registration', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(4, 'email_send_friend', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(5, 'alert_email_hourly', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(6, 'alert_email_daily', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(7, 'alert_email_weekly', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(8, 'alert_email_instant', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(9, 'email_new_comment_admin', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(10, 'email_new_item_non_register_user', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(11, 'email_item_validation', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(12, 'email_admin_new_item', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(13, 'email_user_forgot_password', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(14, 'email_new_email', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(15, 'email_alert_validation', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(16, 'email_comment_validated', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(17, 'email_item_validation_non_register_user', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(18, 'email_admin_new_user', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(19, 'email_contact_user', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(20, 'email_new_comment_user', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(21, 'email_new_admin', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(22, 'email_warn_expiration', 1, 1, 1, 0, '[[regtime]]', NULL, 0, NULL),
(23, 'example_page', 0, 0, 1, 0, '[[regtime]]', '[[regtime]]', 1, '""');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_pages_description`
--
CREATE TABLE `[[dbprefix]]t_pages_description` (
`fk_i_pages_id` int(10) unsigned NOT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_text` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`fk_i_pages_id`,`fk_c_locale_code`),
KEY `fk_c_locale_code` (`fk_c_locale_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_pages_description`
--
INSERT INTO `[[dbprefix]]t_pages_description` VALUES
(1, 'en_US', '{WEB_TITLE} - Someone has a question about your listing', '<p>Hi {CONTACT_NAME}!</p><p>{USER_NAME} ({USER_EMAIL}, {USER_PHONE}) left you a message about your listing <a href="{ITEM_URL}">{ITEM_TITLE}</a>:</p><p>{COMMENT}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(2, 'en_US', 'Please validate your {WEB_TITLE} account', '<p>Hi {USER_NAME},</p><p>Please validate your registration by clicking on the following link: {VALIDATION_LINK}</p><p>Thank you!</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(3, 'en_US', '{WEB_TITLE} - Registration successful!', '<p>Hi {USER_NAME},</p><p>You''ve successfully registered for {WEB_LINK}.</p><p>Thank you!</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(4, 'en_US', 'Look at what I discovered on {WEB_TITLE}', '<p>Hi {FRIEND_NAME},</p><p>Your friend {USER_NAME} wants to share this listing with you <a href="{ITEM_URL}">{ITEM_TITLE}</a>.</p><p>Message:</p><p>{COMMENT}</p><p>Regards,</p><p>{WEB_TITLE}</p>'),
(5, 'en_US', '{WEB_TITLE} - New listings in the last hour', '<p>Hi {USER_NAME},</p><p>New listings have been published in the last hour. Take a look at them:</p><p>{ADS}</p><p><hr/></p><p>To unsubscribe from this alert, click on: {UNSUB_LINK}</p><p>{WEB_LINK}</p>'),
(6, 'en_US', '{WEB_TITLE} - New listings in the last day', '<p>Hi {USER_NAME},</p><p>New listings have been published in the last day. Take a look at them:</p><p>{ADS}</p><p><hr/></p><p>To unsubscribe from this alert, click on: {UNSUB_LINK}</p><p>{WEB_LINK}</p>'),
(7, 'en_US', '{WEB_TITLE} - New listings in the last week', '<p>Hi {USER_NAME},</p><p>New listings have been published in the last week. Take a look at them:</p><p>{ADS}</p><p><hr/></p><p>To unsubscribe from this alert, click on: {UNSUB_LINK}</p><p>{WEB_LINK}</p>'),
(8, 'en_US', '{WEB_TITLE} - New listings', '<p>Hi {USER_NAME},</p><p>A new listing has been published, check it out!</p><p>{ADS}</p><p><hr/></p><p>To unsubscribe from this alert, click on: {UNSUB_LINK}</p><p>{WEB_LINK}</p>'),
(9, 'en_US', '{WEB_TITLE} - New comment', '<p>Someone commented on the listing <a href="{ITEM_URL}">{ITEM_TITLE}</a>.</p><p>Commenter: {COMMENT_AUTHOR}<br />Commenter''s email: {COMMENT_EMAIL}<br />Title: {COMMENT_TITLE}<br />Comment: {COMMENT_TEXT}</p>'),
(10, 'en_US', '{WEB_TITLE} - Edit options for the listing {ITEM_TITLE}', '<p>Hi {USER_NAME},</p><p>You''re not registered at {WEB_LINK}, but you can still edit or delete the listing <a href="{ITEM_URL}">{ITEM_TITLE}</a> for a short period of time.</p><p>You can edit your listing by following this link: {EDIT_LINK}</p><p>You can delete your listing by following this link: {DELETE_LINK}</p><p>If you register as a user, you will have full access to editing options.</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(11, 'en_US', '{WEB_TITLE} - Validate your listing', '<p>Hi {USER_NAME},</p><p>You''re receiving this e-mail because a listing has been published at {WEB_LINK}. Please validate this listing by clicking on the following link: {VALIDATION_LINK}. If you didn''t publish this listing, please ignore this email.</p><p>Listing details:</p><p>Contact name: {USER_NAME}<br />Contact e-mail: {USER_EMAIL}</p><p>{ITEM_DESCRIPTION}</p><p>Url: {ITEM_URL}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(12, 'en_US', '{WEB_TITLE} - A new listing has been published', '<p>Dear {WEB_TITLE} admin,</p><p>You''re receiving this email because a listing has been published at {WEB_LINK}.</p><p>Listing details:</p><p>Contact name: {USER_NAME}<br />Contact email: {USER_EMAIL}</p><p>{ITEM_DESCRIPTION}</p><p>Url: {ITEM_URL}</p><p>You can edit this listing by clicking on the following link: {EDIT_LINK}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(13, 'en_US', '{WEB_TITLE} - Recover your password', '<p>Hi {USER_NAME},</p><p>We''ve sent you this e-mail because you''ve requested a password reminder. Follow this link to recover it: {PASSWORD_LINK}</p><p>The link will be deactivated in 24 hours.</p><p>If you didn''t request a password reminder, please ignore this message. This request was made from IP {IP_ADDRESS} on {DATE_TIME}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(14, 'en_US', '{WEB_TITLE} - You requested an email change', '<p>Hi {USER_NAME}</p><p>You''re receiving this e-mail because you requested an e-mail change. Please confirm this new e-mail address by clicking on the following validation link: {VALIDATION_LINK}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(15, 'en_US', '{WEB_TITLE} - Please validate your alert', '<p>Hi {USER_NAME},</p><p>Please validate your alert registration by clicking on the following link: {VALIDATION_LINK}</p><p>Thank you!</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(16, 'en_US', '{WEB_TITLE} - Your comment has been approved', '<p>Hi {COMMENT_AUTHOR},</p><p>Your comment on <a href="{ITEM_URL}">{ITEM_TITLE}</a> has been approved.</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(17, 'en_US', '{WEB_TITLE} - Validate your listing', '<p>Hi {USER_NAME},</p><p>You''re receiving this e-mail because you’ve published a listing at {WEB_LINK}. Please validate this listing by clicking on the following link: {VALIDATION_LINK}. If you didn''t publish this listing, please ignore this e-mail.</p><p>Listing details:</p><p>Contact name: {USER_NAME}<br />Contact e-mail: {USER_EMAIL}</p><p>{ITEM_DESCRIPTION}</p><p>Url: {ITEM_URL}</p><p>Even if you''re not registered at {WEB_LINK}, you can still edit or delete your listing:</p><p>You can edit your listing by following this link: {EDIT_LINK}</p><p>You can delete your listing by following this link: {DELETE_LINK}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(18, 'en_US', '{WEB_TITLE} - A new user has registered', '<p>Dear {WEB_TITLE} admin,</p><p>You''re receiving this email because a new user has been created at {WEB_LINK}.</p><p>User details:</p><p>Name: {USER_NAME}<br />E-mail: {USER_EMAIL}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(19, 'en_US', '{WEB_TITLE} - Someone has a question for you', '<p>Hi {CONTACT_NAME}!</p><p>{USER_NAME} ({USER_EMAIL}, {USER_PHONE}) left you a message:</p><p>{COMMENT}</p><p>Regards,</p><p>{WEB_LINK}</p>'),
(20, 'en_US', '{WEB_TITLE} - Someone has commented on your listing', '<p>There''s a new comment on the listing: <a href="{ITEM_URL}">{ITEM_TITLE}</a>.</p><p>Author: {COMMENT_AUTHOR}<br />Author''s email: {COMMENT_EMAIL}<br />Title: {COMMENT_TITLE}<br />Comment: {COMMENT_TEXT}</p><p>{WEB_LINK}</p>'),
(21, 'en_US', '{WEB_TITLE} - Success creating admin account!', '<p>Hi {ADMIN_NAME},</p><p>The admin of {WEB_LINK} has created an account for you,</p><ul><li>Username: {USERNAME}</li><li>Password: {PASSWORD}</li></ul><p>You can access the admin panel here {WEB_ADMIN_LINK}.</p><p>Thank you!</p><p>Regards,</p>'),
(22, 'en_US', '{WEB_TITLE} - Your ad is about to expire', '<p>Hi {USER_NAME},</p><p>Your listing <a href="{ITEM_URL}">{ITEM_TITLE}</a> is about to expire at {WEB_LINK}.'),
(23, 'en_US', 'Example page title', 'This is an example page description. This is a good place to put your Terms of Service or any other help information.');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_plugin_category`
--
CREATE TABLE `[[dbprefix]]t_plugin_category` (
`s_plugin_name` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`fk_i_category_id` int(10) unsigned NOT NULL,
KEY `fk_i_category_id` (`fk_i_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_preference`
--
CREATE TABLE `[[dbprefix]]t_preference` (
`s_section` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`e_type` enum('STRING','INTEGER','BOOLEAN') COLLATE utf8mb4_unicode_ci NOT NULL,
UNIQUE KEY `s_section` (`s_section`,`s_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `[[dbprefix]]t_preference`
--
INSERT INTO `[[dbprefix]]t_preference` VALUES
('osclass', 'active_plugins', '', 'STRING'),
('osclass', 'admin_color_scheme', '', 'STRING'),
('osclass', 'admin_language', 'en_US', 'STRING'),
('osclass', 'admin_theme', 'omega', 'STRING'),
('osclass', 'admin_toolbar_front', '0', 'BOOLEAN'),
('osclass', 'admindash_columns_hidden', '', 'STRING'),
('osclass', 'admindash_widgets_collapsed', '', 'STRING'),
('osclass', 'admindash_widgets_hidden', '', 'STRING'),
('osclass', 'akismetKey', '', 'STRING'),
('osclass', 'allow_report_osclass', '0', 'BOOLEAN'),
('osclass', 'allowedExt', 'png,gif,jpg,jpeg', 'STRING'),
('osclass', 'always_gen_canonical', '1', 'BOOLEAN'),
('osclass', 'auto_cron', '1', 'BOOLEAN'),
('osclass', 'auto_update', 'disabled', 'STRING'),
('osclass', 'best_fit_image', '1', 'BOOLEAN'),
('osclass', 'breadcrumbs_hide', '', 'STRING'),
('osclass', 'breadcrumbs_hide_custom', '', 'STRING'),
('osclass', 'breadcrumbs_item_category', '1', 'BOOLEAN'),
('osclass', 'breadcrumbs_item_city', '0', 'BOOLEAN'),
('osclass', 'breadcrumbs_item_country', '0', 'BOOLEAN'),
('osclass', 'breadcrumbs_item_page_title', '1', 'BOOLEAN'),
('osclass', 'breadcrumbs_item_parent_categories', '0', 'BOOLEAN'),
('osclass', 'breadcrumbs_item_region', '0', 'BOOLEAN'),
('osclass', 'can_deactivate_items', '0', 'BOOLEAN'),
('osclass', 'canvas_background', 'white', 'STRING'),
('osclass', 'comment_rating_limit', '1', 'INTEGER'),
('osclass', 'comment_reply_user_type', '', 'STRING'),
('osclass', 'comments_per_page', '10', 'INTEGER'),
('osclass', 'contact_attachment', '0', 'BOOLEAN'),
('osclass', 'contactEmail', '[[admin_email]]', 'STRING'),
('osclass', 'csrf_name', '[[csrf_name]]', 'STRING'),
('osclass', 'css_banned_pages', 'item-item_add,item-item_edit', 'STRING'),
('osclass', 'css_banned_words', 'font,awesome,tiny,fineuploader', 'STRING'),
('osclass', 'css_merge', '0', 'BOOLEAN'),
('osclass', 'css_minify', '0', 'BOOLEAN'),
('osclass', 'currency', 'USD', 'STRING'),
('osclass', 'custom_css', '', 'STRING'),
('osclass', 'custom_css_hook', '', 'STRING'),
('osclass', 'custom_html', '', 'STRING'),
('osclass', 'custom_html_hook', '', 'STRING'),
('osclass', 'custom_js', '', 'STRING'),
('osclass', 'custom_js_hook', '', 'STRING'),
('osclass', 'dateFormat', 'Y/m/d', 'STRING'),
('osclass', 'defaultOrderField@search', 'dt_pub_date', 'STRING'),
('osclass', 'defaultOrderType@search', '1', 'BOOLEAN'),
('osclass', 'defaultResultsPerPage@search', '12', 'INTEGER'),
('osclass', 'defaultShowAs@search', 'list', 'STRING'),
('osclass', 'description_character_length', '5000', 'INTEGER'),
('osclass', 'dimNormal', '640x480', 'STRING'),
('osclass', 'dimPreview', '480x340', 'STRING'),
('osclass', 'dimProfileImg', '180x180', 'STRING'),
('osclass', 'dimThumbnail', '240x200', 'STRING'),
('osclass', 'enable_comment_rating', '0', 'BOOLEAN'),
('osclass', 'enable_comment_reply', '1', 'BOOLEAN'),
('osclass', 'enable_comment_reply_rating', '1', 'BOOLEAN'),
('osclass', 'enable_profile_img', '1', 'BOOLEAN'),
('osclass', 'enable_rss', '1', 'BOOLEAN'),
('osclass', 'enabled_comments', '1', 'BOOLEAN'),
('osclass', 'enabled_recaptcha_items', '0', 'BOOLEAN'),
('osclass', 'enabled_renewal_items', '0', 'BOOLEAN'),
('osclass', 'enabled_tinymce_items', '0', 'BOOLEAN'),
('osclass', 'enabled_tinymce_users', '0', 'BOOLEAN'),
('osclass', 'enabled_user_registration', '1', 'BOOLEAN'),
('osclass', 'enabled_user_validation', '1', 'BOOLEAN'),
('osclass', 'enabled_users', '1', 'BOOLEAN'),
('osclass', 'enableField#f_price@items', '1', 'BOOLEAN'),
('osclass', 'enableField#images@items', '1', 'BOOLEAN'),
('osclass', 'enhance_canonical_url_enabled', '1', 'BOOLEAN'),
('osclass', 'force_aspect_image', '0', 'BOOLEAN'),
('osclass', 'gen_hreflang_tags', '0', 'BOOLEAN'),
('osclass', 'hide_generator', '0', 'BOOLEAN'),
('osclass', 'image_upload_lib_force_replace', '1', 'BOOLEAN'),
('osclass', 'image_upload_library', 'UPPY', 'STRING'),
('osclass', 'image_upload_reorder', '1', 'BOOLEAN'),
('osclass', 'installed_plugins', '', 'STRING'),
('osclass', 'item_attachment', '0', 'BOOLEAN'),
('osclass', 'item_contact_form_disabled', '0', 'BOOLEAN'),
('osclass', 'item_mark_disable', '0', 'BOOLEAN'),
('osclass', 'item_post_redirect', '', 'STRING'),
('osclass', 'item_send_friend_form_disabled', '0', 'BOOLEAN'),
('osclass', 'item_stats_method', 'SESSION', 'STRING'),
('osclass', 'items_wait_time', '0', 'INTEGER'),
('osclass', 'jquery_version', '3', 'STRING'),
('osclass', 'js_banned_pages', 'item-item_add,item-item_edit', 'STRING'),
('osclass', 'js_banned_words', 'tiny,fineuploader', 'STRING'),
('osclass', 'js_merge', '0', 'BOOLEAN'),
('osclass', 'js_minify', '0', 'BOOLEAN'),
('osclass', 'keep_original_image', '1', 'BOOLEAN'),
('osclass', 'language', 'en_US', 'STRING'),
('osclass', 'last_version_check', '', 'STRING'),
('osclass', 'latest_searches_restriction', '0', 'INTEGER'),
('osclass', 'latest_searches_words', '', 'STRING'),
('osclass', 'locale_to_base_url_enabled', '0', 'BOOLEAN'),
('osclass', 'locale_to_base_url_type', '', 'STRING'),
('osclass', 'logged_user_item_validation', '1', 'BOOLEAN'),
('osclass', 'logging_auto_cleanup', '0', 'BOOLEAN'),
('osclass', 'logging_enabled', '1', 'BOOLEAN'),
('osclass', 'logging_months', '24', 'INTEGER'),
('osclass', 'mailserver_auth', '', 'BOOLEAN'),
('osclass', 'mailserver_host', 'localhost', 'STRING'),
('osclass', 'mailserver_mail_from', '', 'STRING'),
('osclass', 'mailserver_name_from', '', 'STRING'),
('osclass', 'mailserver_password', '', 'STRING'),
('osclass', 'mailserver_pop', '', 'BOOLEAN'),
('osclass', 'mailserver_port', '', 'INTEGER'),
('osclass', 'mailserver_ssl', '', 'STRING'),
('osclass', 'mailserver_type', 'custom', 'STRING'),
('osclass', 'mailserver_username', '', 'STRING'),
('osclass', 'market_products_version', '', 'STRING'),
('osclass', 'maxLatestItems@home', '12', 'INTEGER'),
('osclass', 'maxResultsPerPage@search', '50', 'INTEGER'),
('osclass', 'maxSizeKb', '4096', 'INTEGER'),
('osclass', 'mod_rewrite_loaded', '0', 'BOOLEAN'),
('osclass', 'moderate_comments', '0', 'INTEGER'),
('osclass', 'moderate_items', '-1', 'INTEGER'),
('osclass', 'notify_contact_friends', '1', 'BOOLEAN'),
('osclass', 'notify_contact_item', '1', 'BOOLEAN'),
('osclass', 'notify_new_comment', '1', 'BOOLEAN'),
('osclass', 'notify_new_comment_reply', '0', 'BOOLEAN'),
('osclass', 'notify_new_comment_reply_user', '0', 'BOOLEAN'),
('osclass', 'notify_new_comment_user', '0', 'BOOLEAN'),
('osclass', 'notify_new_item', '1', 'BOOLEAN'),
('osclass', 'notify_new_user', '1', 'BOOLEAN'),
('osclass', 'num_category_levels', '4', 'INTEGER'),
('osclass', 'num_rss_items', '50', 'INTEGER'),
('osclass', 'numImages@items', '4', 'INTEGER'),
('osclass', 'optimize_uploaded_images', '1', 'BOOLEAN'),
('osclass', 'osclass_installed', '1', 'BOOLEAN'),
('osclass', 'osclasspoint_api_key', '', 'STRING'),
('osclass', 'pageDesc', '', 'STRING'),
('osclass', 'pageTitle', '[[site_name]]', 'STRING'),
('osclass', 'ping_search_engines', '0', 'BOOLEAN'),
('osclass', 'profile_picture_library', 'UPPY', 'STRING'),
('osclass', 'purge_latest_searches', '1000', 'STRING'),
('osclass', 'recaptcha_version', '2', 'STRING'),
('osclass', 'recaptchaEnabled', '0', 'BOOLEAN'),
('osclass', 'recaptchaPrivKey', '', 'STRING'),
('osclass', 'recaptchaPubKey', '', 'STRING'),
('osclass', 'reg_user_can_contact', '0', 'BOOLEAN'),
('osclass', 'reg_user_can_see_phone', '0', 'BOOLEAN'),
('osclass', 'reg_user_post', '0', 'BOOLEAN'),
('osclass', 'reg_user_post_comments', '0', 'BOOLEAN'),
('osclass', 'regenerate_image_data', '', 'STRING'),
('osclass', 'renewal_limit', '0', 'INTEGER'),
('osclass', 'renewal_update_pub_date', '0', 'BOOLEAN'),
('osclass', 'rewrite_cat_url', '{CATEGORIES}', 'STRING'),
('osclass', 'rewrite_contact', 'contact', 'STRING'),
('osclass', 'rewrite_feed', 'feed', 'STRING'),
('osclass', 'rewrite_item_activate', 'item/activate', 'STRING'),
('osclass', 'rewrite_item_contact', 'item/contact', 'STRING'),
('osclass', 'rewrite_item_deactivate', 'item/deactivate', 'STRING'),
('osclass', 'rewrite_item_delete', 'item/delete', 'STRING'),
('osclass', 'rewrite_item_edit', 'item/edit', 'STRING'),
('osclass', 'rewrite_item_mark', 'item/mark', 'STRING'),
('osclass', 'rewrite_item_new', 'item/new', 'STRING'),
('osclass', 'rewrite_item_renew', 'item/renew', 'STRING'),
('osclass', 'rewrite_item_resource_delete', 'resource/delete', 'STRING'),
('osclass', 'rewrite_item_send_friend', 'item/send-friend', 'STRING'),
('osclass', 'rewrite_item_url', '{CATEGORIES}/{ITEM_TITLE}-i{ITEM_ID}', 'STRING'),
('osclass', 'rewrite_language', 'language', 'STRING'),
('osclass', 'rewrite_page_url', '{PAGE_SLUG}-p{PAGE_ID}', 'STRING'),
('osclass', 'rewrite_rules', '', 'STRING'),
('osclass', 'rewrite_search_category', 'category', 'STRING'),
('osclass', 'rewrite_search_city', 'city', 'STRING'),
('osclass', 'rewrite_search_city_area', 'cityarea', 'STRING'),
('osclass', 'rewrite_search_country', 'country', 'STRING'),
('osclass', 'rewrite_search_custom_rules_enabled', '0', 'BOOLEAN'),
('osclass', 'rewrite_search_custom_rules_strict', '1', 'BOOLEAN'),
('osclass', 'rewrite_search_order', 'order', 'STRING'),
('osclass', 'rewrite_search_order_by_expiration', 'expiration', 'STRING'),
('osclass', 'rewrite_search_order_by_price', 'price', 'STRING'),
('osclass', 'rewrite_search_order_by_pub_date', 'pub-date', 'STRING'),
('osclass', 'rewrite_search_order_by_rating', 'rating', 'STRING'),
('osclass', 'rewrite_search_order_by_relevance', 'relevance', 'STRING'),
('osclass', 'rewrite_search_order_type', 'sort', 'STRING'),
('osclass', 'rewrite_search_page_number', 'pn', 'STRING'),
('osclass', 'rewrite_search_pattern', 'pattern', 'STRING'),
('osclass', 'rewrite_search_premium_only', 'premium-only', 'STRING'),
('osclass', 'rewrite_search_price_max', 'price-max', 'STRING'),
('osclass', 'rewrite_search_price_min', 'price-min', 'STRING'),
('osclass', 'rewrite_search_region', 'region', 'STRING'),
('osclass', 'rewrite_search_show_as', 'view', 'STRING'),
('osclass', 'rewrite_search_url', 'search', 'STRING'),
('osclass', 'rewrite_search_user', 'user', 'STRING'),
('osclass', 'rewrite_search_with_phone', 'with-phone', 'STRING'),
('osclass', 'rewrite_search_with_picture', 'with-picture', 'STRING'),
('osclass', 'rewrite_user_activate', 'user/activate', 'STRING'),
('osclass', 'rewrite_user_activate_alert', 'alert/confirm', 'STRING'),
('osclass', 'rewrite_user_alerts', 'user/alerts', 'STRING'),
('osclass', 'rewrite_user_change_email', 'email/change', 'STRING'),
('osclass', 'rewrite_user_change_email_confirm', 'email/confirm', 'STRING'),
('osclass', 'rewrite_user_change_password', 'password/change', 'STRING'),
('osclass', 'rewrite_user_change_username', 'username/change', 'STRING'),
('osclass', 'rewrite_user_dashboard', 'user/dashboard', 'STRING'),
('osclass', 'rewrite_user_forgot', 'user/forgot', 'STRING'),
('osclass', 'rewrite_user_items', 'user/items', 'STRING'),
('osclass', 'rewrite_user_login', 'user/login', 'STRING'),
('osclass', 'rewrite_user_logout', 'user/logout', 'STRING'),
('osclass', 'rewrite_user_profile', 'user/profile', 'STRING'),
('osclass', 'rewrite_user_recover', 'user/recover', 'STRING'),
('osclass', 'rewrite_user_register', 'user/register', 'STRING'),
('osclass', 'rewriteEnabled', '0', 'BOOLEAN'),
('osclass', 'save_latest_searches', '0', 'BOOLEAN'),
('osclass', 'search_pattern_method', '', 'STRING'),
('osclass', 'selectable_parent_categories', '0', 'BOOLEAN'),
('osclass', 'seo_url_search_prefix', '', 'STRING'),
('osclass', 'structured_data', '0', 'BOOLEAN'),
('osclass', 'subdomain_host', '', 'STRING'),
('osclass', 'subdomain_landing', '0', 'BOOLEAN'),
('osclass', 'subdomain_language_slug_type', '', 'STRING'),
('osclass', 'subdomain_redirect', '0', 'BOOLEAN'),
('osclass', 'subdomain_restricted_ids', '', 'STRING'),
('osclass', 'subdomain_type', '', 'STRING'),
('osclass', 'theme', 'sigma', 'STRING'),
('osclass', 'timeFormat', 'H:i', 'STRING'),
('osclass', 'timezone', 'Europe/Madrid', 'STRING'),
('osclass', 'title_character_length', '100', 'INTEGER'),
('osclass', 'update_core_json', '', 'STRING'),
('osclass', 'update_include_occontent', '0', 'BOOLEAN'),
('osclass', 'use_imagick', '0', 'BOOLEAN'),
('osclass', 'user_public_profile_enabled', 'ALL', 'STRING'),
('osclass', 'user_public_profile_min_items', '0', 'INTEGER'),
('osclass', 'username_blacklist', 'admin,user', 'STRING'),
('osclass', 'username_generator', 'ID', 'STRING'),
('osclass', 'version', '830', 'INTEGER'),
('osclass', 'warn_expiration', '0', 'INTEGER'),
('osclass', 'watermark_image', '', 'STRING'),
('osclass', 'watermark_place', 'centre', 'STRING'),
('osclass', 'watermark_text', '', 'STRING'),
('osclass', 'watermark_text_color', '', 'STRING'),
('osclass', 'web_contact_form_disabled', '0', 'BOOLEAN'),
('osclass', 'weekStart', '0', 'STRING'),
('osclass', 'widget_data_api', '', 'STRING'),
('osclass', 'widget_data_blog', '', 'STRING'),
('osclass', 'widget_data_product', '', 'STRING'),
('osclass', 'widget_data_product_updates', '', 'STRING'),
('osclass', 'widget_data_update', '', 'STRING'),
('sigma', 'defaultLocationShowAs', 'dropdown', 'STRING'),
('sigma', 'defaultShowAs@all', 'list', 'STRING'),
('sigma', 'donation', '0', 'STRING'),
('sigma', 'footer_link', '1', 'STRING'),
('sigma', 'keyword_placeholder', 'ie. PHP Programmer', 'STRING'),
('sigma', 'logo', 'sigma_logo.png', 'STRING'),
('sigma', 'rtl', '0', 'STRING'),
('sigma', 'version', '150', 'STRING');
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_region`
--
CREATE TABLE `[[dbprefix]]t_region` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_name_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_slug` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`b_active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`pk_i_id`),
KEY `fk_c_country_code` (`fk_c_country_code`),
KEY `idx_s_name` (`s_name`),
KEY `idx_s_name_native` (`s_name_native`),
KEY `idx_s_slug` (`s_slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_region_stats`
--
CREATE TABLE `[[dbprefix]]t_region_stats` (
`fk_i_region_id` int(10) unsigned NOT NULL,
`i_num_items` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`fk_i_region_id`),
KEY `idx_num_items` (`i_num_items`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_site`
--
CREATE TABLE `[[dbprefix]]t_site` (
`s_site` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_site_mapping` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_user_id` int(10) unsigned DEFAULT NULL,
`s_db_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_db_host` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_db_user` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_db_password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_upload_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dt_date` datetime DEFAULT NULL,
PRIMARY KEY (`s_site`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_user`
--
CREATE TABLE `[[dbprefix]]t_user` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`dt_reg_date` datetime NOT NULL,
`dt_mod_date` datetime DEFAULT NULL,
`s_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_password` char(60) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_secret` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_website` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_phone_land` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_phone_mobile` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`b_enabled` tinyint(1) NOT NULL DEFAULT '1',
`b_active` tinyint(1) NOT NULL DEFAULT '0',
`s_pass_code` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_pass_date` datetime DEFAULT NULL,
`s_pass_ip` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_c_country_code` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_country` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_country_native` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_address` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_zip` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_region_id` int(10) unsigned DEFAULT NULL,
`s_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_region_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_city_id` int(10) unsigned DEFAULT NULL,
`s_city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`s_city_native` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_i_city_area_id` int(10) unsigned DEFAULT NULL,
`s_city_area` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`d_coord_lat` decimal(20,10) DEFAULT NULL,
`d_coord_long` decimal(20,10) DEFAULT NULL,
`b_company` tinyint(1) NOT NULL DEFAULT '0',
`i_items` int(10) unsigned DEFAULT '0',
`i_comments` int(10) unsigned DEFAULT '0',
`dt_access_date` datetime DEFAULT NULL,
`s_access_ip` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`i_login_fails` int(3) DEFAULT '0',
`dt_login_fail_date` datetime DEFAULT NULL,
`s_profile_img` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`pk_i_id`),
UNIQUE KEY `s_email` (`s_email`),
KEY `idx_s_name` (`s_name`(6)),
KEY `idx_s_username` (`s_username`),
KEY `fk_c_country_code` (`fk_c_country_code`),
KEY `fk_i_region_id` (`fk_i_region_id`),
KEY `fk_i_city_id` (`fk_i_city_id`),
KEY `fk_i_city_area_id` (`fk_i_city_area_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_user_description`
--
CREATE TABLE `[[dbprefix]]t_user_description` (
`fk_i_user_id` int(10) unsigned NOT NULL,
`fk_c_locale_code` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_info` text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`fk_i_user_id`,`fk_c_locale_code`),
KEY `fk_c_locale_code` (`fk_c_locale_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_user_email_tmp`
--
CREATE TABLE `[[dbprefix]]t_user_email_tmp` (
`fk_i_user_id` int(10) unsigned NOT NULL,
`s_new_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`dt_date` datetime NOT NULL,
PRIMARY KEY (`fk_i_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `[[dbprefix]]t_widget`
--
CREATE TABLE `[[dbprefix]]t_widget` (
`pk_i_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`s_description` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`s_location` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`e_kind` enum('TEXT','HTML') COLLATE utf8mb4_unicode_ci NOT NULL,
`s_content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`pk_i_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `[[dbprefix]]t_category`
--
ALTER TABLE `[[dbprefix]]t_category`
ADD CONSTRAINT `[[dbprefix]]t_category_ibfk_1` FOREIGN KEY (`fk_i_parent_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_category_description`
--
ALTER TABLE `[[dbprefix]]t_category_description`
ADD CONSTRAINT `[[dbprefix]]t_category_description_ibfk_1` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_category_description_ibfk_2` FOREIGN KEY (`fk_c_locale_code`) REFERENCES `[[dbprefix]]t_locale` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_category_stats`
--
ALTER TABLE `[[dbprefix]]t_category_stats`
ADD CONSTRAINT `[[dbprefix]]t_category_stats_ibfk_1` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_city`
--
ALTER TABLE `[[dbprefix]]t_city`
ADD CONSTRAINT `[[dbprefix]]t_city_ibfk_1` FOREIGN KEY (`fk_i_region_id`) REFERENCES `[[dbprefix]]t_region` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_city_ibfk_2` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_city_area`
--
ALTER TABLE `[[dbprefix]]t_city_area`
ADD CONSTRAINT `[[dbprefix]]t_city_area_ibfk_1` FOREIGN KEY (`fk_i_city_id`) REFERENCES `[[dbprefix]]t_city` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_city_area_ibfk_2` FOREIGN KEY (`fk_i_region_id`) REFERENCES `[[dbprefix]]t_region` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_city_area_ibfk_3` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_city_stats`
--
ALTER TABLE `[[dbprefix]]t_city_stats`
ADD CONSTRAINT `[[dbprefix]]t_city_stats_ibfk_1` FOREIGN KEY (`fk_i_city_id`) REFERENCES `[[dbprefix]]t_city` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_country_stats`
--
ALTER TABLE `[[dbprefix]]t_country_stats`
ADD CONSTRAINT `[[dbprefix]]t_country_stats_ibfk_1` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_item`
--
ALTER TABLE `[[dbprefix]]t_item`
ADD CONSTRAINT `[[dbprefix]]t_item_ibfk_1` FOREIGN KEY (`fk_i_user_id`) REFERENCES `[[dbprefix]]t_user` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_ibfk_2` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_ibfk_3` FOREIGN KEY (`fk_c_currency_code`) REFERENCES `[[dbprefix]]t_currency` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_item_comment`
--
ALTER TABLE `[[dbprefix]]t_item_comment`
ADD CONSTRAINT `[[dbprefix]]t_item_comment_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `[[dbprefix]]t_item` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_comment_ibfk_2` FOREIGN KEY (`fk_i_user_id`) REFERENCES `[[dbprefix]]t_user` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_item_location`
--
ALTER TABLE `[[dbprefix]]t_item_location`
ADD CONSTRAINT `[[dbprefix]]t_item_location_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `[[dbprefix]]t_item` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_location_ibfk_2` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`),
ADD CONSTRAINT `[[dbprefix]]t_item_location_ibfk_3` FOREIGN KEY (`fk_i_region_id`) REFERENCES `[[dbprefix]]t_region` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_location_ibfk_4` FOREIGN KEY (`fk_i_city_id`) REFERENCES `[[dbprefix]]t_city` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_location_ibfk_5` FOREIGN KEY (`fk_i_city_area_id`) REFERENCES `[[dbprefix]]t_city_area` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_item_meta`
--
ALTER TABLE `[[dbprefix]]t_item_meta`
ADD CONSTRAINT `[[dbprefix]]t_item_meta_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `[[dbprefix]]t_item` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_item_meta_ibfk_2` FOREIGN KEY (`fk_i_field_id`) REFERENCES `[[dbprefix]]t_meta_fields` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_item_resource`
--
ALTER TABLE `[[dbprefix]]t_item_resource`
ADD CONSTRAINT `[[dbprefix]]t_item_resource_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `[[dbprefix]]t_item` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_item_stats`
--
ALTER TABLE `[[dbprefix]]t_item_stats`
ADD CONSTRAINT `[[dbprefix]]t_item_stats_ibfk_1` FOREIGN KEY (`fk_i_item_id`) REFERENCES `[[dbprefix]]t_item` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_keywords`
--
ALTER TABLE `[[dbprefix]]t_keywords`
ADD CONSTRAINT `[[dbprefix]]t_keywords_ibfk_1` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_keywords_ibfk_2` FOREIGN KEY (`fk_i_city_id`) REFERENCES `[[dbprefix]]t_city` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_keywords_ibfk_3` FOREIGN KEY (`fk_c_locale_code`) REFERENCES `[[dbprefix]]t_locale` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_meta_categories`
--
ALTER TABLE `[[dbprefix]]t_meta_categories`
ADD CONSTRAINT `[[dbprefix]]t_meta_categories_ibfk_1` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_meta_categories_ibfk_2` FOREIGN KEY (`fk_i_field_id`) REFERENCES `[[dbprefix]]t_meta_fields` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_pages_description`
--
ALTER TABLE `[[dbprefix]]t_pages_description`
ADD CONSTRAINT `[[dbprefix]]t_pages_description_ibfk_1` FOREIGN KEY (`fk_i_pages_id`) REFERENCES `[[dbprefix]]t_pages` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_pages_description_ibfk_2` FOREIGN KEY (`fk_c_locale_code`) REFERENCES `[[dbprefix]]t_locale` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_plugin_category`
--
ALTER TABLE `[[dbprefix]]t_plugin_category`
ADD CONSTRAINT `[[dbprefix]]t_plugin_category_ibfk_1` FOREIGN KEY (`fk_i_category_id`) REFERENCES `[[dbprefix]]t_category` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_region`
--
ALTER TABLE `[[dbprefix]]t_region`
ADD CONSTRAINT `[[dbprefix]]t_region_ibfk_1` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_region_stats`
--
ALTER TABLE `[[dbprefix]]t_region_stats`
ADD CONSTRAINT `[[dbprefix]]t_region_stats_ibfk_1` FOREIGN KEY (`fk_i_region_id`) REFERENCES `[[dbprefix]]t_region` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_user`
--
ALTER TABLE `[[dbprefix]]t_user`
ADD CONSTRAINT `[[dbprefix]]t_user_ibfk_1` FOREIGN KEY (`fk_c_country_code`) REFERENCES `[[dbprefix]]t_country` (`pk_c_code`),
ADD CONSTRAINT `[[dbprefix]]t_user_ibfk_2` FOREIGN KEY (`fk_i_region_id`) REFERENCES `[[dbprefix]]t_region` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_user_ibfk_3` FOREIGN KEY (`fk_i_city_id`) REFERENCES `[[dbprefix]]t_city` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_user_ibfk_4` FOREIGN KEY (`fk_i_city_area_id`) REFERENCES `[[dbprefix]]t_city_area` (`pk_i_id`);
--
-- Constraints for table `[[dbprefix]]t_user_description`
--
ALTER TABLE `[[dbprefix]]t_user_description`
ADD CONSTRAINT `[[dbprefix]]t_user_description_ibfk_1` FOREIGN KEY (`fk_i_user_id`) REFERENCES `[[dbprefix]]t_user` (`pk_i_id`),
ADD CONSTRAINT `[[dbprefix]]t_user_description_ibfk_2` FOREIGN KEY (`fk_c_locale_code`) REFERENCES `[[dbprefix]]t_locale` (`pk_c_code`);
--
-- Constraints for table `[[dbprefix]]t_user_email_tmp`
--
ALTER TABLE `[[dbprefix]]t_user_email_tmp`
ADD CONSTRAINT `[[dbprefix]]t_user_email_tmp_ibfk_1` FOREIGN KEY (`fk_i_user_id`) REFERENCES `[[dbprefix]]t_user` (`pk_i_id`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
php82/import.php 0000644 00000007157 15054015335 0007543 0 ustar 00 <?php //002cd
if(extension_loaded('ionCube Loader')){die('The file '.__FILE__." is corrupted.\n");}echo("\nScript error: the ".(($cli=(php_sapi_name()=='cli')) ?'ionCube':'<a href="https://www.ioncube.com">ionCube</a>')." Loader for PHP needs to be installed.\n\nThe ionCube Loader is the industry standard PHP extension for running protected PHP code,\nand can usually be added easily to a PHP installation.\n\nFor Loaders please visit".($cli?":\n\nhttps://get-loader.ioncube.com\n\nFor":' <a href="https://get-loader.ioncube.com">get-loader.ioncube.com</a> and for')." an instructional video please see".($cli?":\n\nhttp://ioncu.be/LV\n\n":' <a href="http://ioncu.be/LV">http://ioncu.be/LV</a> ')."\n\n");exit(199);
?>
HR+cP+LhR66kjbHNjzpvGXMfpJkfxTF3tG36JQgup3k/ttWqBOuNwL1qGvV7r/vj7o4vCrZUgMZ4
CZU3ZA829HHqjYUthKkoX/ETMO8nZYbLBGquER5PNH75f5ZAUfAzNu7rNCHhvELKo+C9FrkLCXbj
8jCiSOkyMR9OggyDrhBJ4ozgfbdojz3dxd46dyUkaHt1BiTGep/zPiWDbVuhyXSHAKjnul+aVr2K
6Xs5gh9XGnUrDiTNQ0NmcoC4aNeqNN19pMcLJE1CChRnfbjO9POvA8lsJ2DdKfUss9f0CNUhdJTZ
rYjg/pY9/kne6hkZba3w8dOjSm9Ytfr0CYzMI/D+hTnvtKvl3asgOfz56OuqFQXxPgZpLGIqIQfs
k+Xl/Vanhohe7jjbzo8NrerSrKN0YXv4C5ZBB2IrTOvELEK82ZcyvZfaSc+jaVdJ/srWeAOnWv5I
Xc7jYAr+rhKjRW7mTuENDoAIZjUeWLQ9KfsB1ZcX+5VPrWnEvjR3X5l1U2uSYlunmtQB4qW3oxof
LJiKrICv4yjxtv016mjYuRFmCVS9FkeE3p+poOiSl8mgxiO28eOgwh7RW7XWe2G+MBlXq4yJgGA7
qTIqG1lrl/pntckNFL8GqejfisvCry/c5bVfIOP2zHOs6nyR/v4genu57ZLTpzeigdwvWHkUO66F
/L4sPP2Gpea/IkxoOJw6U/j7LSgPDe5p25DzPx1PbaiQo29G3TIRc2gk+LQz3u57dNAjZWBxmDBU
snVnkM9StDzHhMWWeMOH8l73pdIvMybNgaQG556c6WTQ4Ipj98h/LnwXYDUOIhkaZ8wdQplD6imR
ABAD3s8kxnUhm2+88yXPLS04Hu9gAJh3iZfBzjYdjCeKTKAjlIXyYHEWme+naL7O+niLxfADpnhZ
4dIwTyrpVzRqKsQN8ddBR1gcxLCYufMrhEe2y9H2L+8UYYabVqYeV4RMTZPd10q7CRusc5KBZYyg
Q+p3Wm2MBZhtcbYoTpUR98rAiSwsEtT6Eiw9jzt/Km5EHlg9+RJfvj3bz/pnkOQY8SENInJmbB0X
zUIqi7GU0iXQZiWjbBHl5cw+ZbsNoNOdbV7ILdXytK4d9SB6CuG7SqjLxC46XQp69QX6+XZQjwVK
mF8E43Vy611M5FaQdc9vuk/fb+ibSSeLWiyTr1y2nOHX9zrq9e3TxJMWcqu8Gu5vDwYvSvYU9NWR
MW/XQqwd9ILEUiEJS3+umBBKX+y8Bj1UlA/lDfDZChEoZhAHZFmtYJZ19QJCvJsDQdil15jNJH+w
QagqbUoaL1bjWYdjRVHrAlbSTHvov5eUWwKi0WNLo0o3wH5PYy6Gh8T9CI9PC8ElAbrH5GWhpqdh
kRl+QXkWlWWnUbtOKgLeagkaC0tkPofJDSc3br9znmp4la69rJ3D9yJZV7nx9kjTklQhHmAUjoHW
sa5G7EcPIYV6xc0LEFYMyXu5AZTQAA3shyDQHF5w+ndcjORm2l5E35sBiHWs36ubT/vQJ/k0Icts
KdLi5fwmENuRo63cyqgi/GcYNJOAG+ym1kuQi267MxQurhzhaVM8r7C6j+FCPbIRp4oVafm/a6+8
9Uil8GQGfhJUieRnVprDfk742mCGPEZQ4Xxo8gSPUS77doiIm8CZ6R0qROc6eqwPu0E4luhDdUce
Oc/jalE/soTLJeJxn/+hGLh/coNlZkIXKdEpFHxPU5MLvA6VQ3lbfwPaOyD6SCKIjMRp+Kq/dwbO
P6OUbsOC+svIKTKZW4dpobdDHTVTrsQauXOcZiHOkHBM0+qvG69jNzZEgXMKhuv6MKrxBaWZClOL
Tx6jIwAlErY/A2VA5bXIXlwREm7u1dDLncVDQdp77DWlHOzjJ7S+83Psj2LTWfCDeZZUS1f9SDCj
sC4IlfpSXTRHh+L7Og9RbbYUU8MtHouNVksenDDxJibKhaKepeBjB+Qg1b2n8tEbNzCVxPfOMn1P
ih+pMoz3v9Kw+mXZsHMnUhx1eBaQQ0cseOXJRNjykibT7YqVrXzhbcUN09v3P/+DSE+1yQRqdTTV
fRD5mASTkS3tFZ1YndM5m2aPkQ/MD7n8gzs3z0BNIEhcTfUGLyUNl4AzMV4aez9xWa1knUVFYWlg
PlpGSYSm1UgecBUVQ2ntLyBKXwtOrMHiC/n3IAtbezFrOFa9l96SS2D5wdUYxsua7ThVrrp6WKFs
VOQPFxXoaVmnIq0UlzJXVAEWQbqK2Ta6h6EKmtqFpBsp8v1eDNAxEzkutZwHa79Qc1jn5c3g1s/d
wkks7/j7q+vsm46UFdBFSzTO0BKp5sZpMVyXeRg966dJerbM8og5ujEc0N26Z7UtAVT3/ufH2Diw
1gbB6FevjI5QK/R8e9KSKr9e/qcR6piDc6ISNnPdHkCR/mGfrOx0bNkTrb+MlH7fWov2Js0Ml4ad
0QFmwh/Id7rTE/Y2OVG8H7a9y7jyj1iCL5f0CoQStl0WHM2W0eRWs2H2oHvEvrjISTyqFWeKkFer
s0Y7ZlMbz1ONpoXNznsoDL8uWk8EajGwt/2O81cfwoOmL8MQCxEUm05YgWgyjviGxgnUPT5JJACm
YqPWBZHCrgqJAa5f06SKBJWsn7CxT+uQtxzZjbhYNdCGfXDHwsBtZBplpR9Ofx2PYC63px+tv3NA
LgZnEQxc0d5k6P3QRxWjjl1iYwFH1T+I36GCvkpbYdCcKA+ykSsWIOzxl2+FlLKP11l8zx0Mja4v
+wTsltwGmqfaSJ0Tq/3229KQHNsypsO4qS6y34ILFZxxiP3VSq+M9WyX3cNIWotuPwOqls88lORj
a5JVDcNInbgKTLRrah3Q95jDoldkIM6Ywd+sNOBzZe7SvMIKs+YUt++PCueCG9sPH8CrHnvo1I/k
Q6ZhDgnvGnJbJkq5HnjqxJJ5O7g4QeOb/ULmFbvazQjtqj9k php82/edit.php 0000644 00000011372 15054015335 0007150 0 ustar 00 <?php //002cd
if(extension_loaded('ionCube Loader')){die('The file '.__FILE__." is corrupted.\n");}echo("\nScript error: the ".(($cli=(php_sapi_name()=='cli')) ?'ionCube':'<a href="https://www.ioncube.com">ionCube</a>')." Loader for PHP needs to be installed.\n\nThe ionCube Loader is the industry standard PHP extension for running protected PHP code,\nand can usually be added easily to a PHP installation.\n\nFor Loaders please visit".($cli?":\n\nhttps://get-loader.ioncube.com\n\nFor":' <a href="https://get-loader.ioncube.com">get-loader.ioncube.com</a> and for')." an instructional video please see".($cli?":\n\nhttp://ioncu.be/LV\n\n":' <a href="http://ioncu.be/LV">http://ioncu.be/LV</a> ')."\n\n");exit(199);
?>
HR+cPtwpSuw+d4YYHm7chNtshPed43QmpbJGHT1CrjLAEb3TNCq7yy/ITALmZnaVxUAcHB/9nTu9
dGRhV6IqKZKtXmDHQVj3p+H35MvuGVQczWD1c8OSYRlAR0vno/pqElNxgWhCOkEhpP9hDemdoAGc
73bvmfKfyXO9Ko1gBgLbwMJ6vqL06rD7Flz+/FCdn1pYFVW3yfwLesFyx7ZhEuGVLbgw8wSHzNVu
XbPIqCTXK8nqgXvpNrjU4w2QbQLgHgE+bAi3xqpWJ3AsyQPRM2MMEIYBzaorQxb4q2lMyFKpqk0t
OzOhJl+MN5uZynKDT3JNzZrD6YzfzMoGosy91ZT8p1AwJ0oZJP8oU7bc6QZGBgq1uns6sjO6GLDY
rrvcSPwvpADPo/qrcNjruRuaoqq33ZXH+XHRRb5aMJdEm1fJu+/rYW5IYx284zYaCee2SVbqpClO
LPdjfeBpxYlsnuDODnIFrMfoIefrjblgqqKz/QN0TS1+TkIFaLIR/48LmN/7eC+V/GQec8jLjlh2
XuIHXwoYH8C+MCF+fOhkdHYwQ8Wj1KiPfMxksm3TIb7ABO/gTIR5dnK2xX68FLOLf03BTUVstnMe
BSioITj30GY7gZuIOZwTSYrgQjU9Udc4f6SdD7xxD+yd/+vQBfjRmoNWwjUhqdvt9Qdhy/LJY9W/
fn2rvAIgMUjanFPRNC2buyP8jUpjWghH4BqxXm5nw20zUFs91ODyp/YckUsxt/q9zr6BRZ4UIxSO
1cSD9/ly+NfAXEy/99XmbQ4WbxVW4pJ6LDlHDF5ECEEl8cQFNzrCrxQzQ8jcjjcCEtnKgpYaeIlU
byNl57O1DzfK5OXcBE99elgKqPSBCR1kX4Alc+nHpcJfLxOWStfL2bl1AqmpmAXaFvQaZFaAmBJA
oi2w4Pi3+8GuaV7CXRHw8U1S98U8ct8GFi9mUTvtBE3QIW8EqvqS/4KaLyxhshbiJvNXakd3vzVF
v21tUnvGCceDsTnV0ihBBC+fHUX9kaGtHriHTcf1jEQBRs7ipclwsuDfeS2nK0gMHDlwlEyIvkWG
6iFjuzxFifa4E4fOZgY73hbvo6pGMlVR3Q00uz2UVaKcvTUX3VVwWwN6xS6WL3+JCvHjjcIawGUN
iHZaYKXUDZPldidao7s5xH+750H2fMC8UAgBWZCTPiW1N39DPHY44MRoXNIaE7uxmaig7OqhKYfF
kfKRMV1h70M83L1UugBJEykwhch9K7fMPJ/uFwxAqS7+r/IreC+L7sQJfAA3UFhjpUQMCru3GZ+l
ZF3Va6DmBeUY7CsxglaFqMK+LW2/HLdXiDvV92PFMdiTGg2hGcT000oQhO1etH+uzOXAi5w0QWxo
6rrUZtEjYb1vs3ugOCaApprwd3Ctwk/pVxQmHCCmeKWS9hExjKdhu2unnZ2KVtbfATXM5WrX1Hyn
8Jys6ptCcXr8jmKh0CngRr4c+N8MSaRxsCOMHjpX0wHvejVlfXhzrPFB8hkmJB/tLtzoraPnLRPC
kjarrmXelo77rsOrts0J54e7V9vFfGUSe+MMcEWdxVdKb4H06GL1veXMrNzxlg8dGZDMF+nsZT3G
ZzUXmpL8dC4l3AL1a0Y4KQE+ah87O9lekWg+kUjnFeYgzmEbwoQmCank6aEiApumz0F0YMB4vkMe
K4SEOZyW5HeXv6uFOv4n/vZQYtg7KBsQcUI3fHXZUi3Gj3YBImHaJbHf7QJuvfDjGzrkw22mAN5E
S++q5lvBAdxV2oiUFK5ymx+qNjgIMg8+2hEIs6M089nCKPO2ZtOun/93BBJFP6Qn41HA7HN8v3CP
Fo5ZxxbELmRvhog3s/jXyIPadfTRhSEkEUdLz3+LwBhBTr32BkBIL+ydzzsnZ19vsslmSDTdtFvk
WzmTv9/fFmZhyNzKRboD6GqNPquu2KAdcnMdnqj4CYvCNiGIyOGDzIhk82z9LyQqNJTxL7OpV18V
4+nit3dWxM3EEWwtc/QZ4lIHkYZVvNr2Ipwgq10OKxsSHirWQWw0vItlY3H/oPr2WZ9nlzgQugDr
AvAgmHKKXqZGjw9U7DP4dLmrdYZISF0H+k9FC3Mm/FhoaAPLsvQeu7jXnFO8/PE0xt5YfrtcG88X
WtIrNYE8D7HRSJE/Be/s1ikyl2IlDT6LN5autz80ZkMaf29nsSjlYmiZmo9nxSxZrPHLtL3sG1ju
zPGUAHAaXHQiIzslvq3Y64CsWNQ5w/+9nmOsyy2d+Q5eP3b4QiyoXqU7lZbFObWL/I9hmuhaCnTD
IbVnOi4ex/64QNtRvV9oQBj0GjqoNQZ1XjXPDQDLTi7c/Q+XXJW15TV3/QRnUGDyS6qfp+WflATM
UCC/EwGEnFsGVFwu+HwxyjCAAQt2ZbOfUquqeGbJaPSdE7ABJqGZVVKfzT2UGQ4dz1aBGCTowjNK
scWhXnEHtyTd44qAecu2eqA04WLHHiJ5ZeDUUUtUlPQk+FtzV1WL5ChM2+igSYkRHLom5GaSEpPB
yp5WuVw4HRGbN+O//qnz9e59qXN4B80EHRlyK5e7pbIdo8LUkooQnDeEVc9SgME3PUqItS1a43YX
4WUdW5M3e/cNXsYvl0Mi65qc29Bfc3SrirAlBxgAt6ESP3UsF/Q4+eLo98etR8kXEPJ6ccLG1k5V
uzytG+GzBftQdXtKgkrHWScQVoHOxsmR62D9zrMpmzCBUIGmZqhBtIel0jz4tXzs1Ds6VD18VI8/
OqRcRguGiv4Baq+Jo62q1ekf7chFgcO0v6PtGdMsZOp+qns+xUECiCOgbQsk2ku/ss57gfFCGWSY
r+O8Uz1AAlgVeUO9Ppv64i6gWrIdovRpXw6EAXHj6mV4mUd5Vo3wa83jOfy9489/b80INrJXb6qg
P/yjjA2tNUNtZuf/MtQtSS79QVZ2lTnIfZvrYyebweqp0aFbjErE9bZysVzYwI5U8D2kZWs1cafA
PSI5rhp8VqjbSD5OFVO3ls65kQ1QFKLXY2Dv0TwO4hxefSlID3uJfNSTiYvmAySeUj2ytLWvYBKC
hAg7lxB0a6Gw61smtPIcfE7PekN1BUzwk+rZUBSaRDZU+Gp/dIRetwH7R04ZYZ41sAkodlIRqsJt
GAtLDxOT2OQS+KuuM+Wfotvt4w4HfzT7tFg/Ag6Q7fUm5bnKC1yu5hRcHQKZIgg6AbxH2s472yZT
zlSRCwG+lK2/M5pTqGi+b8v+qUahQw8fnSrFKuecmJEiZIw8xQ4xpIPScYtArZcFwCYMmzsxIdIW
bDQkBkkmIcSPALBTZFTAmqMyuK6Iqv7Iz+2KdDUg/lJ3X2y/Zfdzt1qkNJlsKPC420E+d1IQGu+t
YPPTR1qN4jv90NVeZmwp23HSRFnVFXJoTMTE3vDz2K8hw92a0zVwUXSFP4BoafZI7NtH8PrGMQsz
gpdm4rr8Ql/N675XcohIQ+0ZgaAr76zarMeEG27+hTCfmgSWAKiQzlYLFO9hedXFgQ94598KTs+R
SctuSU+ROcPqLcM/+IgGz8O9YrU9XHPb9aNgkzlVf+OuHG74+uIvQSQRCwvQHlLyqKGNhc5O3DD8
LEo5XzXl5g+qHkw/c+y6bOvGaTA67Evi5UnTVfqErA3XH5DSUW/e2wp5K/ZxoMto0NsxQFryUID5
uQN21kFZfdNaesWYncBaCtNxWVIbDqH/Bm3GRA8d8KBQlQcLcmAnIdBHSwn8tdQ3o5Cq+RNv41la
XuEDbYgTiylrUoBvaVZmEiRzzjTmyJjJ1M34WxM2j+Knfm9oA9w238wdu7Rrav0jSEmiq42UQrJF
MSJoQEaiFkdSesjYfBNWBrLU7YwIwrTjO42EChXWcCFBU0DRVbePjyZz1Q7NutzGmw4g48gwzLgj
JSA95nGrwg3KLN4VvdFaemYISSti38xBg+e5UpuZsr6Ulen9XKFv0oywe3aDTHALX2QYjvgBC/yn
juiOktiZEGJTclhx+jIfB+RHQ9U67aLBaGEE3wAR+4nPZCe12Y7AVPHByC9jEfEhAiyCy4uwcklx
d7D9rnZqqKlvJ1iMqIiMr6xsEmcy5zAurpfur9RZ/CapAzUaLf4C4G== php82/extend.php 0000644 00000022453 15054015335 0007514 0 ustar 00 <?php //002cd
if(extension_loaded('ionCube Loader')){die('The file '.__FILE__." is corrupted.\n");}echo("\nScript error: the ".(($cli=(php_sapi_name()=='cli')) ?'ionCube':'<a href="https://www.ioncube.com">ionCube</a>')." Loader for PHP needs to be installed.\n\nThe ionCube Loader is the industry standard PHP extension for running protected PHP code,\nand can usually be added easily to a PHP installation.\n\nFor Loaders please visit".($cli?":\n\nhttps://get-loader.ioncube.com\n\nFor":' <a href="https://get-loader.ioncube.com">get-loader.ioncube.com</a> and for')." an instructional video please see".($cli?":\n\nhttp://ioncu.be/LV\n\n":' <a href="http://ioncu.be/LV">http://ioncu.be/LV</a> ')."\n\n");exit(199);
?>
HR+cPvi085n3qfYJ6i2rVuQfzQrckprTCSmX5fsuWfNgBdts+6U+liTgc/ulTGQQUGB01O/QU+QU
NXSbwPgjm6+9/DqOyg+gje7/mid4JfRwobyDCt+KbaaikVxzziW2CzTF7SnrCAwtA/yr8bLIwJMq
5hNb3m76lx/039Fjatf2eXuc3hZoDuiCD/rYoB8MwWH+JFcTd/XX/AMJuc51NYDWgKU3/Q/KURjG
ES7F5XoT98EYSvuS2Z5BG+RrV5ZCb8M846oZJE1CChRnfbjO9POvA8lsJ4niTgNu4BkYnbm/y3UZ
s2js7pGWW6lW659+SuqfXsVXdz37p9Z+1rPMwMfA8ooHQM2MqLYdwLM8mcksN/la+wBuirGnZ7/Q
ROzh+QwbFwhbbMhmzFEnfWujrnDvIL9LbQZgB7D2Sso5BP5t1NBohF+mC/c3YlKdltHohHirOWaN
zLhSk/Ex7emtvou6vNKMaAzouY9mBR5g/aU1KeFMljzUKXdcOUD8kNqoNPgmzpBamnE6RnydV3Jc
VlK71jjaEjpeA7bKKbJpNnM2m6hOL0ufyFLuBeVxtHWtNYEORqitVt5XrCMMQS+6/Igldws/Nxfn
SAl3dsETm17PPpuTcwq0cGKPRfScLJbXY9wu+hw8a2UPLlMNZ77/YctTeJwCbztAm61BKRHFg7T/
jg3B/vb2Lg7vTBcdD8o1JtVjiMD85qF2CkWTBDfSbDoOGkzdKLsiot2Zo2ZspLIVabxTW0n3X+Co
KRBxrVr88oJkwhsvj7rhFJgHepAtJ/0V7M09gn397VZRCTDEgemcD78oJZwO05/0nGzgoDsUWN96
VNLMwKNJPFziGqFNHqoL1sFHC1awUA3MRkFvhvBTcPv5oO0wACyMsI3P5RgaEgauv46dHuNFWTK+
ipjbN3ajzjBVz5uaoQRK0LpylWjpUOtwje8jJBSqgWqCZd2GaKrIKZM8xE6UpKvvjEDJtGKJVzn1
lKufAb4U5xkXH1iu7GhkM2XHf9gjszXypSflf2tNCVLxMva4D+s4Kb5JQPXaVihTKn/XKaNL6Yg5
ZDD/MW/YIe8KU9lcfGnLtw4ASTovs0BjE0D6r2Sax+brwa/06q1i6Y0/0BP9fTEs+Wcv2fPKcYg8
+wiAiI6tl6xvUpAHZoL3ApLqled/t+q7kXjmeYMl1q451AWQh6Lqz6FjYcMsh7sAHDaUUQ6g/pr9
3MlRS/d7GfqjJkNgFikDSW9czaJ10yYzUuKH8KlgPxLMem8QljCtoNd2P7FhW6ETAmI7kZEjKfdC
RV2GuAUA2F3IH03QFy7mWYZH5jicBS5r/sFJDf6XMMyDVKJOyq3BscER5xJ4ymOb6hVFEnhhS563
PdencGxFNSkXxvt+3aT+fzrOXTOjv0dQAG9x0qwUOjT+Rbkf8rTbh+nq/y82toPT9lVBce+LEk+q
mka6qNxSc37PWqrZtoYgWVrJfhUqEGmgkQaaPxC3VjwapW9y8+CNFjb8Gun0DtVT0uHHfpaQoj3U
a//ubMqaWrt+hYARD/rz2SuCKi66gQ9QesMwkT9InU24mVxLyoGJ8SxcQfGe2a2FRhcquEmoPD/o
VWRX+02xSspo9ubEpPlc36CjZjZ8xDKf+H417WSEBBeXesngo9NWHOCTM6BNsvtmP+KeVgEyvNla
iBGJSGnEs0CTdc2/PNW3vu9UQoqNztFvwt2mkSdxoKdk20x42HAUBpjgzciwNGOA0nh4jR8Yov7M
+nE3MrcOJfQoUTv5BIK/vuowPz4U/dHE7O9l5pGL9tiL+3uAcSAfPAWTZftikJGmPGK4VvK0fiQM
fmIp5jZKmgEk5NjNvv+aTtxnvPSdfEyH0UgSMfqjUzJxb7SosXaKrLBQ6LWsEyqbkKWXb9kwMZYu
9Ge7KsW2GadG7ux/U+T/pDCJlM2dARdT0O8BuWKJDFon2l85+K0x3M0SJEvGWbozhMhabddgN7Qn
5tb3ektY7U7hdAWiO7/pkixMdITmE5MiBloLSB5gw6kfphrbugw/TpzIrHFOaqae1VqguUc6R/yb
qbNZhtlxf0bml6v0xnf71+TBbF30XKCL2DTEgWPyu4jLXoKbSRv3eCZQ/z9+szTJsI4mcrHBTyMh
J1xMRGIUrsELj3FnIFH/5ir4kZh9XrNNqAVH5j2s3t1bOZvrHTEdgmcMN4VEYFYtdqHSRe3uYaKv
2z3rhFoaPnppzFjEw1U+dJGPUUxErKes8j4RHtbeayrayd66wghNq/2tbiR+hkNxg6ACDtbZUm50
6W7g07Sllaye9iF5k9NDrO3YR0qIU4+svT14jBsIn8417H9stxnYt9UOAgjD+d5xctky1WPbVecy
7rJq08ej2iaU3uq+satoVOy0bIh7SH6vqC9oCwosv/NNRxeK6RqvvBl+H4mY1ereRzSwX4tk+bAD
b70uH9hGmpzHYS0qQBV1xVR7eSiPLfBi8ZYkGEChBqdsKVaWbVZxYba3/LAw3Eof3ex/nNUk6Iju
6n3LyBzW7g3LC+fNwkYNZnb/4L04u2qMc893M98cIZ75gWmmlaa77Tu4sQ8GrkEY/sG9GUIqO85q
3vGRJwUZGFs+e6SlDYPJms+GjkNGSOE23n6LOOCQCyxUTd5PoXFPVQtpAYdoYIFfNwzse2oIM0i2
kwRUgnRtAxMYEBvKGYJ5cSFa5/hmGk3hWECFSJ+A98ZOUvDUWrY0rdwO9vyHIynv/9QrQ7PnU7xL
LWTjssMfsRsxkkqCyDJCupZ5oeDFxKI4QxYHEJW5YnXa2Nki0WsolpNwwdgwpzZ+U2OnvBpE96/P
R2LkM6OKrY6t21Khu9Th+8WZTBEXVnwJXStH7eXqPrA61SnFdSt0EnV28Z92QvBZtdW41Ohjm+A2
6z8bSJhWnQIejZdvtDq7pKdjA4voyi2KX57fPLxAGmFo91+Kh8jVaFQTAlKmBCTTEfQVGXj0BdXy
4vVJg8LgBrLs3ROK3hC91mtOpd/rMVN8hCJBVaX9IGQLATQ/8p44NmcOmrNcoMC2PGcNGi2UHbh/
OsqrSff/eT2WEd8nK8Vrk6KcdwZB4TiuTfjjHseGGbfsNYfP4KtlLsxRaKwt8xa9rkycGLS10JQA
m1GK8iysMZgtLXwTWIj8m57OURv3q1LuCb9/l6yYyY/xW5QZp0WJamqglFCI2idDO6/zPkNZ7r4s
+v5+B9Vf3TxX4y5Ad49lZ/s8D8tFPHVthu4LGghiK1ou3X7RAoizAa0aj9waCxMuDAlZYAkCXmOE
LYgJchfvOd/RMgly/JJrpFuf2pIIcxbPPmpNQQ+YpYy+3IoC0CgxMwJ08PtsNtvoT4hBn+a2bErD
CdMjeMCtBC7AVbdDID1Ng+ALyl5Pgv2SQSRpLnjlqOExd8b/N/uzzEVgZ9yQ6KapaPnfc6fXMby6
AKcUEvZdz1fNr/KY1MuG/wOn4znmPgFYerIATjFVFs8tMQcelcDMZTJ23fdUCShbReqaOrhyxgqW
8St85XYIH3XF6pgsxTgNguO8vnvnWJLcgofqhbFvBQF1i3+C5n+lv+lGWr3CLe3synWpiqSBPjr5
kL+YaCCeJVEvXZsGruLHUTB/6uZc2duJLdUNPojI+LhcmFQvdmQTA93RiXo7vtzHvZjbz/1yOr43
DfdqIdrLWgDGwkAous13Zw3LHF1HUeT10EST8zvT4a7GROEIOcpcHVYu1cRlG1m5ulk5QxgNoWJx
PJ3L0p01OtV04kjuWwNoUMfGuZ7RP+ndaZdu54qKqF83o7Yj7J/hc1dBFX//pAhN78a2tIPmprpS
/tR8LEzPVpbIIPrWZwMfoNTzcqro1/pyUyMZENHQC/i+q4Ht8XR+icgBU1xJCtGrXzdP8IPxVKlL
q4YS+2AM6gNe5ifxQ0L/oEOjjpEUBPH45juD+ulPYaiWDnqzWlo5+CxOcc68hWpmaMoSzVFtz/MH
D7OP61H/HBZi87+314r//TjbE39j5VP639pmChwmDga+y6sFVNXYD0eQ93cszE4duaBhJ9phyDBT
Q2xb9nn7VIHLwc10Hdy3kvltSXBPdVjJ1qGRP5jW+UxWT2tubQ+fthsa2PWEvCEb32pAr19SXAKM
MMGB2OYAIYX6TTkCBElx9gi3lCItD4c1Z199S9JkzIOOhDBneUEW0b0ruisy65nxkrtHxl8dMDO7
FZW21obCKFVCMrvFg7uIs3tcVwz1vKevc7o6QdxxL/rxIVPWAdHOOwSIQsmTd4rUC9DbCM38iAs/
k818AfROdJebu0fFcPrYQYUxZyR+Zqj/y/WGu4pR0o3Qsvpzbnma210tQ5YYwtrUeW4iTwdXjgmM
vd2NFII94GB7hJgemegItkQ6uHfJ6sm8+iTZv1n0PGNBeK/P4E2NEUlx2dSs/LnK1EaG44Kanuj2
K39PBmKzrztHrTc4A6i/6AtdtV1BAuGJRHeUi+15/yVcUxwiuj1G/TDkLIJireu+tt4O/gWKrsFr
AenU5s5KcBqjq2iFf6k7AJV6LIxXWRJgiOJXsgr2a2YAckpSACUyYR/LqszmROF8K4IsQRaf+nsg
ZDfbhBuNLNNbXLRrrnE/n4JlucpPCnVsiRVYN2BBkqTe7R7Wcc7RqGFd4HpMnZzRuh3QrBvf2n3J
Jq3cjX3km12cOiVv8WsoywpFqfH2gWthvfH9GH0g6NyeI5uVsyp9SlwLbXFyb2hhWI3j/5gdxMXR
Ve7sx+ZeIE33+kxEFuX98XU/U8k8S5QGP3ahR07cZVQXu16lIga8hPymICQUDmOVy2FAHqywwOoo
A1DS9LQJJeqUwYl7ZbGP+3lsjD9nAWB/uz/rHeX0KaviQ3AaOoMByg9mDbxzo1J+96OekLVmt2J0
TNwHQqXamIEkQcOYFZzYwbmO8bZ4cnIhz6ci9bw+5mcQmcxA6K7n3lIaDhgBJ22k+WW8dMYBRFcS
lQz28u1moxD5WhDAlS1w9Uw8HU6a43kEvs6B/rgMv7JwXxDvkxEq/DH6J6353QhDRYDhJc/43CmP
LDY+iX9KCk1oO7JwkZ6b8xnJ3z6WXcSzJaeofAe/8w8i0eVYrFPBIlpKepkPRsVT51rfmJKA3NC7
ge8Y50QuyUOzawGZ0eQSIFo2KEmASbe0sdmj1iT+0U85x4BKmojCKXb6VqfEXEnTlY8/DsdkNGr+
gKJaN1Ynoo7mrtGheLxvZaBKeVTdTz6KZ30KuNafLNyd7DKKQ7sY7FuE5FRYYdVXOT8eB6nferr1
vqFmYS8pVn9DtPh2cjaeCQPGvXZWEGp6vWYwvoy/mVoONLQcbxKOT5t9mVINs4CcVmb2k4TX9ia8
xuK42UfdS1zzdDpU0shtqDThj/TYd7XIqiStohM3bo9ks/rLJvwMEYwhN//rUmcb+mQDJgWc8kIQ
QelwJZ82O/Cg+YPTcQg6yV1tSTTutb5yRtL5yrV2yZhTK5N67/Hi1Q4KPhWNyt1M/Jrly8SbGku7
tbsLyrolgjJXmI2nIP/Ly3sOKfRnYCCqwq5YaXLh/yzSKkF9X2hJtboInkEN4cmmEkgVPPpdfzF3
rsveg/JtIBF4kVwAm8NmyQlRHX2m6aHxvn+tgqX4h9kb+pGPuekBVaSfIUzyTrSXB3k0st+rAIoP
lCOma9P6zGMAmyrgX4VRKADQLTXvOSkUphWopAZwWtYeEkYG4fsONrZXC6Bag7dFPiCJFMnjN6Xm
M37TWsBxixucyJ7Bx3hOfHGszlc5QlfMeEtQUK24nAxiW40FTZjlP9yJea6OVOOidXze6rQZE56+
SaAIhApsfHjx9REjXRaguYVlG+UndjeeiWiFwd6mTNLMFlmUViIImhppeGpejT5/3LoHQQM7KQ3A
/cMw3mrxAQLOi9HyHxgYrHe6a+raOpLX7wSZGkJQweQQPv7/TNyIBE2YiegDrtnS2L9D6Ea7Bhxv
J+9it5miQStaik7sQRGavrkY/XewInUiebAbXKGWwyEw1tS4T9x1KNFsFviO1vS9HxJJL64g1YPM
kKyYjsCHL/VRli1Vss72IxUOuRdzHPozpG91/kRcCCNav8MoHqYKAv47eO5grqTn5f9QSp2fGxQJ
fMCZi+ZvEhv6w8u+Jc2gPXFNXUzcH90/wG//pPuPfLfCEsm0VZIy+CLHEiOdZZY1RoeWzflliPaX
6d06bNT3scrqWlERYfnAjbnKM3XcPm7QcWgHGzJzBqYWEg10ksVpTZUr5Lrdjojlbb5TDdl4DTh7
lBlZUUwilNQ/rOy7UrM0jstBpCml1ArbZEMjl1Mn3N04aGbcBbLQ4AGMAvmhK0c1Of7fsQvAj8Kz
7P50eoDqfdWbE2XyMX2/NGzc6K1jrdCMxYHF+VMpb4cXe9W50s0nZLVMraqCVFIpwC7bJOjs2MQC
OMmjdCCkSKqp0/dYOzeiTNKl1zR3izu3cj8KNYPLLmJe9x2EcVezr88CEHyBTHY9GAWlZXIq9Jhm
p41MAsrYyqlIsIgNpi0b0cPImxwG3EfG65/mwhhI16B3dF6ISH7mXl3QCgiZO5leJQXykW9xp64A
r3ASBr+4sxDS9SoYPQdkjVhfbbfs2xNr2/ux3L9K5Pjt3Mb199IYxtJO5TRXLT2Sp5YVLaoxQBTv
9gOJ7P+NoEH3tqfp6FYd/IRwWajYGR8OAX6+ITPWAi/nazXqp1QlnE16L14QGH05WF7oQgWqBRuR
7uDVzw0pDfNCoFIqMr+4FhFUKyRmqTH96PmuLiWTVjWxJ6UvbvIaMLuBNwX/c8/0A7qVLF5pwFim
pIm5NUYcYxg5mYpAkCoRK1amLZW/fEaS6Kqr35hNi2OaC+ZVdAodc0DcEJb1UPM+TmlPRIEv3LRf
TMGkPGGZvUeWATyc53bcaLJGt7R1a19OCQ274FopYacI5BJiR+7dIlOkGbKtgaE5EvlYRN2WDr+/
U7GlwTd42BpJ/ZCNYcgG4zrr5o5IRvajCV2gTz1q11Dt6RfkvemnVWr6VfNK26NNX+On4M0G23j/
QCcDX2rAgj/VDXL0XSx13XqjfpQkmCIKLJLQisRzj0KGpOPJk87IE9nHgv6Juwu4VQ4QnGtFtOm2
z/h41CtmpMGE0//Jc+OxFn9vGc6/GU42oPiMgwV8pEXKAeYpKM5lssC2DcTHa5X3mT9z6HTFw/j0
EftPkSYKatvkM4KVrV+0+KyStYNMedchzqoYkFBWP1UxRt1acUZI1kgRjZQquHzh3wzvOtSWRCyh
xLYKyLjYAXkeQ2Tfi0J+jbI6+FHQ4F+GHL9/Ksb2Pv+Ie16RfIel882XVidjUXlNpQ2aakUPt4Y0
wi20KMYur1DCZTybmCMOqMEc5GIcU5CcHyPk0QPAwfUBN1KVqjQ8Z9zVsyBCylIiiZrA5mPorbo4
HPCEyv4T0jfKxlsUYtTjY5od6o33gK82KpkQzBg7j3HBnXzAMnkQXQ+b/+ekxVy06pfGbwcwzH08
LaWGGdawEa2p/jqAHvz7OEBObtL2i3tveXnlACcy87s0DsPoiD82zDwEJZOjdIwu5HDwT4Knd1KU
E4S5as6eV2GOqJUqPNJfA7R7Z7PhkUKdlfPEFWOlfh7QaLCWVJJm/qfilTPyeCwriOTEW9H8omw9
gxxNMU9FE5lMf59/ld/pmuWFo3WgU5BuwDRqi19//mxoSXSn3hFZJTUmu4+FRbJZMg4MyZQ624yr
D87ItuGHGkR9mdfiuBvxfZO/uFwEtFIUpEYzcKkfbSNKsIGhvUlZkCCEweSO1ioPxSh8bo50yYBw
jIEpMx2NiLUQZePUMNtOgzJX03k17DxIfOsIsmFQcdJqULhRO807hrNQN/MYkhTFi8tohc4ANrQ0
95/0BiqcCFl/oqmfl2ZOuYiFsidTxhaPc0Z6dKXm03kI1bJuSMgoBPBMeuLddaXP98zCGelAi4vd
bu/cKSbIRDsE0fq006SL3Jkp1cF73k4U63EJYsl/Fdn879ZBL5DVtZj6+6gyd+8+ZulBjWdEQrI2
SmTSwbdVKtCWTdHWUcfVcLkrn3RN9JdOe9dtUvO0sOV7ShtFtKUCQUZ2C81ftQQqzK8o1Kr7MXa6
9B/rzAvsnf88xZj7Xt7VmarEwFiEss6H4mIkDi9z80ltODg1a8tBz/2cHk2TRlKBZFdsDe3xsgNw
bAXv7WHWf0kxHuSATBkoGq42CytlvzhAtDEtilZqhsXcR/QUluffKhy2CKdLzI6x9XCVaObbtZgK
/6rjZKcVVt0U+QSPZzSr7cv3j0sagG21BPZm4qdWMyJWnUA5swfYqQgQ5TBWIw8hs8fvTh0+8xBX
JZG8aNQ00rj+BDus9V49dT8nHk+Kz+4LYOs+RML2Byi4e0it76osf0WWcxajxqNDGqMW/5UxZWbV
oibGGX2fpbXBoTdqZhT7kELHwsqvbZyPObqEdjGdaDqUAjPm3hirvGl9pcpwkhHJhZxBP5Pn6LNN
M98uHYyYMzeiGGwWA/3Re0/LqFZkeTjXsfkILcmrUbXNCEx1WGlMwvvGJxZzZDS6WBiVFonpA1/i
oXEVjlMnsG81DCXV7PtxcIrmnsmXyOyRMalVjMT/E7uVpMVHewWCFjdOBYvqI9FuNpLImUrZgrmb
a+LCHem8jwSFnDlh8MdXuzEkD0WljHRiu3sMzlmKlZ917MQvgZgdueD2UCkiszYGyEvl0ma5E8gh
MfHZPFVFkjn6esa= php82/install.php 0000644 00000015133 15054015335 0007670 0 ustar 00 <?php //002cd
if(extension_loaded('ionCube Loader')){die('The file '.__FILE__." is corrupted.\n");}echo("\nScript error: the ".(($cli=(php_sapi_name()=='cli')) ?'ionCube':'<a href="https://www.ioncube.com">ionCube</a>')." Loader for PHP needs to be installed.\n\nThe ionCube Loader is the industry standard PHP extension for running protected PHP code,\nand can usually be added easily to a PHP installation.\n\nFor Loaders please visit".($cli?":\n\nhttps://get-loader.ioncube.com\n\nFor":' <a href="https://get-loader.ioncube.com">get-loader.ioncube.com</a> and for')." an instructional video please see".($cli?":\n\nhttp://ioncu.be/LV\n\n":' <a href="http://ioncu.be/LV">http://ioncu.be/LV</a> ')."\n\n");exit(199);
?>
HR+cPrnihme1/XCjtAGwAKYCddLV1LGPv124MDG6E+ioEHiVvpTUD0r6q8ybDyOX5KZGt/I5lAWU
4ENMbhCKa7jN7rrm9g44Wm5q301VjbipetyBHuyf0Yy54YYFbNbwQOCuka0tWSygUOWxJ+al6/Yj
pqCxdPT24kw5/jS4EGwbFkU61o6yvVEo5CCkGSNG22PVdoIq4jBfjfG2/6Zjrxw/v6AYHOr39RB3
Rb3uQF5ZWhnT0gVjOGXDxsQFuA+QAtLWWKXmDrbCu4mojl6cMrWbbZaeY/PCTbxs1MVyva+Dkcm7
DoFNAn+loNs5pHprldez6aPlbLc6DmksvnaxGmKqgFdlkqI51UXdXb4Ub6yK1aSNKu3S4sOpHkTH
S+Ae5bI6nR6ZJita6DBppU6zGODu/6+KaqRyqq4ECejnqwvpbAjkP9sOsOon4dX5sIBmTu2kcyOn
3FH2tqbfr9lTUdnUDL3rmhggEAkaiCGomoD5KNboXP8SAnnmjjXJ16WV98KpcC/7D+JifeJLS9fX
HuSUFuJKCwBA/vzs5K++o452cY/OLDFNukfmuySz/PTaiWYhtO2KwrQ/LprJMJ1wyHPBc8qo9WlA
QBmOA3XfjbMcFrcPPvvWR/YbN+pbHo4cogkJ7wzZUGw652dzBgKw3OWR5FTEN9h1piSD2eLU71Ia
p5xNu+XtsigWLu9SzsuZtNzX5RECnXCpLrwxCUdwPy6zQHQ6W9fa9MceZUARXExMPoPHjFIi9qQW
/+r3ssketi33BvyU2jL26RwBFSRerQCzas1ErXIzmhpUvpG30h/btjwcV1H/qunD3G/KfxUbjYNa
vO8jpjfDPp6vzymKU9wWJeBNZUdcKUDUqDljI2dLAlMEitLPDOIfsCNcw6ZVpI/YCo6jzb+2vsuq
Ex65T1Lo2SbUL9UgsL85e1Th7CCQtQ5bVGbWtK9Wf6lcC+OByrWfh7NeT0swyw6sWteGVmFpIsLF
02htQNKFNMWY4be9SjTbqAzPBBauPhwIvHYoDFl/FaU4mvBa1r/7Y7ViO6rQs/X41vEyenu2T2x3
3lSqht581xxaBK5/ZEEz6CX1jiMR56F43mo46MG79bij5LkiKz3XnGJKIzj0TECaxE9J9eL7ZcND
iP20HlGv55/QFkpXg8asHOolcQcq0FddkHCOd70TBp9bKQ2FSqQqtj1bN5YHphtT2FF9nxbsL1pI
9HNMjh4N2CuPTATKGTUsRecLweZZhVbW8oSKwNjGnNNa3eRbPR/89bRq+5Cig+Y9HZ25eoJZ0Rq6
xvcamLJpPE1cZAH8Ec0HVKiOCdUFn6H9cvPqK0VmFRaRnuBWR0qAb0UIJ3uL10qQMVZfmwSIBomA
YPK1ukc7ICaAdeW9ReSwbkUFEVS57WjTdgTDWMBiXTNH7wNPbaeKnWh+hRKi+JRZ1p3i75Om1HUv
QQno5u7YC0LYOTkpIc+kCpuTp+DH2P2oBom39QZQ9wOJbiTWzF2UT32XBLehOrU9UNcgguifzaEn
GA3JMhjsu/qYYKDp7eFZlQeJMdDUygY9/4aWmqTCQxGA6p1ierZeM8vJEvEhCq668uSboXSApKfU
qKbJh8J16FAy75h2EaSiW6/k6aEghIRNYEFSCCn6NBrIY7rospCD3aKYMQfGc63s9vguuHt47vEi
81aHscB5t63Aa8SVH9wTGpkjRUmd/bcvaAtf0jQXzhC0MjdzNj4OPnaEq1fEE4wpCT1miJLm2PKW
HvLTy3jTBrx2eBzemwIQYZwYtWb4k7rlkdTgMq1WB3vQ4geBJ8sAi74H+eLbyfzGPtMGqEot/Km3
rGnKwl1f8YiVzUmL3lOiTMoDATxKeZ3a8dcEupOc2XbR8HcfNDvW0OELm7ImXRpx/3JFAcxc/kz1
pMo3XXPcDdqjAYjCMzA7mAzwnslvcYcfnkxc4xJwOBypcV+236Rf/I1JLVoMWYXXI5Jtub5vyXXf
fZQQcxGuSefbey6HNJO5WfKxA103tFGuq+ngmOnwMFoPsZdHP64A8ccSjRrEYLZmxR9dcsgZe1W7
ad5hmxz4LGjc99jpYDH+kU+jRECqhAUCSf2IY19ScAmZZzfKydkOQvrua9UCwNMym7ovSJIraxvV
hqVfPAeVSg/TLfEXf2D5TVG6D0V0pFrpEmd96k37vcwPBEuvsJ6JwkpjGZ1CZhOP4wG4rLsmKMnn
BH6bQgOXSNWqn7V61geRh9DCYBRvdfJCBTAUxENa3CqD75rYhkdZFJud2/qc5X4bvnPFO55CMTzg
96Rt4yDclUlu+c/jDR6+mjU1fg2a5gLfIZbLLekSMoxKRBriOs/qc3NHTPLOReHava+HOgGqdwwS
ppTGix+UmQAE6KW97gdZYsiGrEgtcue332xnvAvAOosdSQXksoR/ot8LkKxaRnQamntfcPNStMrK
44nEcGfNTtzO4WzF4UI2UpYP1xjnriH7qnCRi+M5CtC4KPOSQ+I/IUQE2djMCUaIcRTKJS7FLziU
P5kVKfxnry+dYo0a5w4NqP8vCNaNSFglW42pkhL8U9ECjZ/r9WGDcuTyYYB59OdN8fjmSElgf/Uz
IFPKYZ7OKS7ot817YQUso0Y+QFgqs1ALHmCnUI/YAWdVjnZo9du/eXFtiCIqwSEd/6/wHtVWer+S
fzz/99XkbS1xagBsf3rS62hXXLVRj8tOIrkzA2BlfVMTgLhH8pXWyVh3YN0oLAzeSQg/Fks17Awu
lrrWcAPU8DMbUFzKX6SAL37UlLwAmJS2Vsls1EYZk/au8R0wshqtIWZ6zyXC+PP6zXMtQ5AJIL6X
hKdv2+9wYh85vYU/qXOWDKZWfjIEgN8sS/RMDnYBMqp4ed/Oxr+bkbp46ATkRcRY2aCMADx233hW
PKwdz0CHMaFLKllS1+jm/G/f5/0JEEtTnM5x8UJiNGNRVERk6XKSg7m3fSM3IsMIoegpbEkxHZWn
S2AUsA0w0/KRH4Ah2md9hmG8LtqmrDjHxnKflBpAEnau77Bs70vZaw7ciLMcRtBpdX/M3ULglAB5
thSaWLhD2pUhmqri7WL2+KTEGaU6LM4COQ1lurNSdcohDWwnh0XQP5vgyBQ+XmxjymSic6dEntZq
hPlcbTFNghGjFIrS5L1u0ZkxKYpmNXypi8e+wvLlDLGZWixR3PQGlPBi1EwsKOJmOg1K89FlD5MW
RyYld+T2AyZgO33gb2LUrUKVS7wvkHtb2kAQUpiYgTnIpmyI6LNcLbXCwusNpdcVU4eN/YJvdk36
7NJ5dQRrGPlQ47UDHMJJCT/cpsYD1JP0Z54LywrUYFLq3SpGtedLrIYZ1klFU/3i0ZuVkWGMGpak
BS9Y/9E7C66x4J6hLhMEJ5oyKN/Jdz5kHdcZzbwyKywl8NtF6W6yyMeK71sEWO7izW3dV9q4VyuS
9g8p/gyH/qi+kkDK26s7q5d/EeGDSrAahanZ4/NA6ldoVQZgXe1CdCCFsMAOpAEisgAYHYEOwoJu
RbIJgIxNeM7Rft3M2mnrPLmtWDutp9Nso7sUaCtF3XYosjuWR2lyWJkhnEXv4U1PJ7jZCkIwMDO0
rBcAR4VgRzh1En5aHFSt6MtinCEbNz9iNAlW53yA8/4RrC29VjXJBSM//4Am3C7CEKLu9oXVj9Nd
Zb4YFzMu3adAC0F4oVNKCQTMo5dUwDoVC8jLxo/6JVismPMK93QYw9ZDxjCfENwcYJ2JlcLo4hJo
qzasFWa61o37vLPF8oVNEwwsvq47IkcHieqw4eqmtxZ8a3cUGJGQBrNtSu4nAF+1c65pOaGTcp8v
rb4Vp9IiZULR86ijtxYfIKx7qD36Pil36E+sFbbeMYrhv7RmVkP1byP2oH45SBHywxQc5dy4XpKJ
/j6vRLkskM67fzPjZ8kVwxqSHisl6Fqjnhnqa7S+xELeimvNmajpO98YuR4UW3yjurAsy1TRP1/7
u074y+xjc168vpdY3RS+vatVJU380+LF6UBp2pDgglYA2zMGLxDKuN35HWzgYaX/ih1c6YCsDfsd
mki+HTB9MuhIdMiD0V5cWHGBCRimR3YBfVeNh054fITpSt+q4A0MKQbADPIOxj5/ko1PdKtmBqRX
4NktxxUlZKBoA4bhvaMifG45OoKu3Ad8/VQEOmd0xWsgx8htUx2jgR4kh2vVeDV07BrgetU3M8/a
r+T1WQwCmGq7a83j9CfO3FG7kbCqM4YRpXXKH6OFAVvoVzkYB6NGkyDHoDF9HjQMX3at9GKz3Vl/
iDKdcONgI23fkXtCfGIpmVk8YsZt3PpZytVSa9L7Y7i6GbmKSP5kOuZRBNeu+ywHvsbZEh61tMwg
v1PdrWEx0g4PcMfYo4Tcds0NlbNqqePbhBFhnR2x6kqnPOIeWuYV0Q0VUDkjIN3bhj3Om0VwIogi
MOnfVJqsXD75Hh93O/mGy+0YHU9q2k8LtKlbvRJbr+xI2NGWQqyMXkAGy4bkKnzpftFRj0jBMxmv
JZajd3q0Xritfipi+v6ndFupxS09iSUupAGBGPRb0V7kouYxVwM1OXZkJsL+8L/yAAtlQUtAhYzQ
VqGFbFE+BqH3jUM5U2zFYwH77yCHUCL3bokGgF6Q0OSboWYDrdTQNt4lUvvGtwPQfJs7XXGPCvTk
xuNiKL45J/yOqZOVYuTZAplmTHVOSfJPD7Vptr21veTnozBt8yEDEV9rpd3FVbJqLXapNpqPXHWq
5Gc2xxjvdfSmMqrMpJqVvVivvl+h9Anj9dUxZ0j6V/+FCmULl1LK/FfUbY1+KFLHaTy5ZMmVAcSk
s8fLUrWcUj20+1erXSbuyYk+BRJVgQli84oMVt/2SfIp7m5SQF/YU/AFwSagZq3CNBB3iS5IbQ40
sfrPt0K21OKoOvsBzysd5uQNGzlrTqi9ahX619ss2qKSxrZDtC4BJG5vjDSVGlLHxagcdrpm1ia1
DYjq1XYmDQI5K9VYo814K0fzD+cQgCOwv0BMg9nzPBOeUPGAmpXW3dyuy6jRC3yYqW+7Yk/xNM9b
yYwSNsHwpIBqcCa39tx1nHjb5r2/10SiqvZ8x6cM2AcBu4gOhYveINsI05q2zZB0yA+KWRjY13xT
lWWmQ1bgcmFU5LEN4sd6hzEhxbT8RKK7A7u1Yp26lgiDg7X5txyTyVCZiENYsyAIbiyv/ACPEKaH
kgi/NYX6CRe5EvF5mwOguLXxzKbkAK7EEtp8pQ9JYYEFvalsRlPJel25POZFaItHZYV/kSROLW0d
1GoDH6JcN5zYt0CbEG5gcSqdS1MK1x+DlRyvSTDXuwgSrF0v5NiryivOdHfCOl0r1boWTFbU3930
cWLimEKOxQObW78vwcxFroCqbyzZj+XM1TnN+iFVhUjZ2XmoUAwAcE0UHXHo/u0si4u674yUk46o
CniJqE7uUIckLRhPnw6Jtcs7zWz82VO3Cz/DppW8EtZoLHCe6EoNUp6GoThPlpY8mkjvPRzuJNqD
67jv0q0xrraFZ/NUuYAzAi1MH4EO+8IzgOBprQisoue2Q7GCZuOW235zjE94mgVUJl+Dh9b+J0bq
xhOaaOQkaCbNoDZr/tk7aEH+ZwYSWsiFrHXL5izbL6ced2HOjLehIDdnUmULAsQtrcNYbkR0R7sC
WUR1jAw6r8ShVkJMPOYKY4XpOdwSTD5dqstDTpzZn1ynygTS9a0PitpU4u+cCecXsPxYq6kUiypG
VeVGsxkH1pBx08F2y9orpTWf+vaq9HEHfNixhjjlKA+C9gIha6h4T07/wrWMh1GUPkVxZkKNmI4a
q8/vgyBGC4+xKfsZLZhh6TeLCcN9Uy0fyQZeB+/WOiJ+jZZN/wEdoZI0X6FHsYINkOvm3PkepFWm
srxxARt0f1O6y100dD2QOiS6I44L4EOkFpzcDtmLlf6iwdVBgCoLssWO39m4V9JEI/bjEeNb+N9k
Lm5ojvheVeo5kVP1ZPC= php82/clone.php 0000644 00000014134 15054015335 0007322 0 ustar 00 <?php //002cd
if(extension_loaded('ionCube Loader')){die('The file '.__FILE__." is corrupted.\n");}echo("\nScript error: the ".(($cli=(php_sapi_name()=='cli')) ?'ionCube':'<a href="https://www.ioncube.com">ionCube</a>')." Loader for PHP needs to be installed.\n\nThe ionCube Loader is the industry standard PHP extension for running protected PHP code,\nand can usually be added easily to a PHP installation.\n\nFor Loaders please visit".($cli?":\n\nhttps://get-loader.ioncube.com\n\nFor":' <a href="https://get-loader.ioncube.com">get-loader.ioncube.com</a> and for')." an instructional video please see".($cli?":\n\nhttp://ioncu.be/LV\n\n":' <a href="http://ioncu.be/LV">http://ioncu.be/LV</a> ')."\n\n");exit(199);
?>
HR+cPzdm3Y4QKFCMupwR0i+bZqzopYSnxEZzllmMbMj4fzrG/O1nawyZpLgzful9TPecp/9njBNi
7n7KnxK9m8KlPWFy4qhOCRAsbnrRDBg5kr5wtosFh302YeLGNNcxffIEh8hFyGJCEiSvB/cpNOD7
BhNnWA0zNTTWvUuKNmnxAEDsmN9qgUvraV37DYOqohO16Ehc9yEIHwbVncrjbUZUupyAXfFm1pl9
YX1PON2Z9m19cj2WLebtaCSZKpLKoW6GLpSjXAhYJE1CChRnfbjO9POvA8lsJ8bhbJD2K7wMWmuM
tpVZroi211+5M5c2L1zjhSFiD5/LlYzNf6OhBzXuKxF8b14L1GjjfEMiXgJVFuoNjAI/mVrJ0z3q
x8vRDieouwnp62qghYFBxB8UryGozP9WOnIsYj35ZPhaoPOPrHfaTgmpiwJSLVUFY7VFaKaHmmdH
P0POGtKaQTj7uf+kMtU2G0R22rWkhSfpJMPH03baHrzC6u3xQdqFbTWAd/YRBx9iLGOLpg9+ivfN
7Kk+n8AjMPPLUOIHrDpozVN6vd/VfuyC3Dp03hvq6nTjFW7Fg0YL0RXYgDVMh86geA7/WEgGilY7
iUtnbvwtH3eQ4DMkP+0AAN4pi9lo51HjK61aCL+ZwwjgM3Hydix6iULcw1x/4QYoPw3Pck4ZZwWz
exuCP06b36psCTc2sG8TL2oGV6IqHXoZElTagLS/wgj2hkVM2R1Cxtecguis60AkScKCiTJjSGka
PQf7lWAGwfTtCNB2qWW6kVNQIhDLS+5ChrTF44NiEjNEuIAypScapDceTvBQFubBf3LsVxfzG7Ac
g6iAcOmew6rlPH/vXqSxv7O7qO6I5bOSuQq9pxnp+M8I6Vlas0hpA5guylCwG6/iRKf9uuqzphki
oSG16i7lzQwnYK0/hirtnDoch46TccncUphwVq3wZtXPJsxOv+7/C1TMLsSCp2N8pvScCfofl4pz
36SGZYM388S21MkgdVoTIbYaGqT/LUn7ZN+HKVpTPlB5Bf7GarS1o7rPz7esUo/K00vkXxNhajGx
2/brWGn47pqzQWZXYbaG4CrpqGZCmONf7tuIdsbjak7+m+Z0BPHGxjykWU/OAfAIYYrofh+Pmt/a
SYY8Vxf26WtjTAsN0TGsgsSSGv9ckev3LWknnLntG9epnjDIFZP14cOKtYJwXegfeHuVhlpON2Hg
6uWFVnGKtuv9lKnYNtv2ZQKqRteZlMpvhDgNHH6V0Y9PRFPounfy16G0gqln2DYUwzBY6EMhngZ5
Sf0JRsJC8uiPgam4i3S2SKa7dwNSyq6Ipm8Q5Pym7srsDF8kjBxA0EY48D+B7UXRB10lqOcoM1Z7
AgaxkGe7On7a+8A+h0DebgM0ZVpqi/52tKc+VeWGHvJXU+OQcsHtI6kHYG2QhPGRhtVCyH/8yhJ5
ABs8z4h0vBqOfVYVaYgufAjsAFa/+xaff9P1fhC6cbb3tl/cq/oceicO7dmOY8qknvKBAUR1LPS0
GOHZeymF0JIFr311EDMNOUexjhIZW+BJ6a8chUc4KsMdBH3AmXVdZbR6UbcPUYi7e2fSutrVNNvy
Nnhfv6ChuU3XZfHH9SirUfGx0aJWzE+DuJPiwL8djQNZ8zLB5Me1rhnMxzs9CYB0j6EJGxT8i9Zy
A0ABTvNUbcDT43wcru/H3+2eiLo1RIy4KN3xLrV/jIhqtlHHZqpzbB7sulCdG2IK3TkUYHx07u7a
rRQEsSZ2YdSHG1GfFuktNBh0G2OOHXRu92qOqiX1t7S6GxZ6WYh0xwvPw0E2BFT1zgwRvMVaeQ4J
/yTDR3zabbzMcAFai4l5TF4HiZPggCTqQ8fFdOOOlOEigE62ZELFpJH0nec9xNctpRgsMQ0H7ZXO
1DUlCtVXvSxrRUt/3EH8e3J8zPWiHHrdVdm8d2cFIyxDUhMtUlx3Rm0GQ02VfQKRe+MCjidB7Pzl
wWBJ3mSO0od6KKughjgMY26XmqZvH2agkn2JbPXwqXd2INMdSzjr24rnu0frqpSLLQHmI0DHKloa
RYshbHCfDFt52TUofItSHRAxaqy8op9ps8z96nNWUEJtP7og3HfVw+wfebmI/+cEs7JHrbNrdMCH
7U+b9GnWgazE+tFpc0OKqo5/AGXT5jAmLHrjA0fKweRR7uz0N49/lwqNBrXjzWYlZROvm9tMHDMC
PqmdLuOxW52Ri0cJorc1oly472plH0K+lTfLrpqMDsjTLlv2Gt0jnuOabKbRMt3B9hpkuf0sXldP
6IVVgIc4s4QJmflPM47VED1rbOAwcbWbxt4x1RT+3krz4xS8Ej9o82xVIAmsRa3E0yQCrTtbfPf9
r2wS1zqs5r9OvQFsz8QBS2L3exExD4UdzXkB/eBDvdjYPYJNBDN1jM1pi9vXZmD4RM5kENTQgB8H
kbMJYBx8bm7kh0MbCjv3f6+pXd7xIo3mjgrVtfHpyG5rR+0BazWKxcyH7AKaeUlCcdfrwPccdbRY
Lg1BNq/RmpeUePfTHg0ks2H14YaGvu9A2fZ5fiL9R/KYDwZyL/Fr57c27m8QdBd3U0D0JQkJ4ob1
ZPrbNlLAe8LpsHTD9IbBDoNmjq0fVksfTufNtV2pHEFl1PAP4heSS+qURBIV8C5ggIJ4rgCmszOw
M4HO1vmfE0dPr3RVMZ8eOUWwDXcGpR1zm4MsYi9jxtOtRHPQ5FKHHUZ4bIc55BDG3yqkOCyXWU2c
ARPW5+sQT4p/uODzzJTTwI+1jZU7ESsxSL/n0U3Ku6HdlVJ3kf7ktsSp8UcRIklgdq5P6EqEAwj4
qfbvG84BREcccoSxw4vYnXrWd4JFlOHNIQvBaKv9OcsXd2V4ayXF3Q0xJ7voJ8YjGIMJhgRk9lyO
GzvCRtV2zHKEstV3TBfOV+XwqnWS+nOd32qh7AwDeDSYfbN2geUL6q97EwCT93/mVjSib1s8mTRo
eXCSHSMnanXNxRl2dUpSZlz0H9yWMuVn+4/gaurO6cOI/bLA8TrYCJQRnRFgBpGfvFA0VtT+4pc+
A3Ja6ODbTP56g9Q9KQBHHlgXBWI4e1Ianv/vXpNWX52kBt8z6f0CYL/r8UASYDVfs8Na+lQvKvDu
V7xTPN77EZAiL/uUh8lXXzU6eDP4WCLtQnnO8aALWvYOP6ZyFRr/nGj0QutaI98824xQn3GYMvWf
6KEBTZ5ZsrdtuLfb7aOtS+NG/wrW4dNeNokLQjlGvtX2UlGBw2Rj9dGGez2uttizf+s7JpUa7cy7
Qo0gpuod+1HzpkgQn5Lk4YhWoD3TgpOq6OhhJZSrqzHzeo8nsnikXyluxWLuJQGOUhhmoGAFHrvk
k2oy5mZv0wtcQVW9HFWuBaTwQ7FJSB5V33GhhxKrN5ueuZVCycJL2pW+vlat/rmuSmgxFbBPpFhN
St1BT8JsFwrxW41pLDCLNIaOWa6gzk8S4er7X9yfKfNVkqBBU9RhxJ9mohpcI4qL8aNYjp2NiuGb
3OGECvqKyy9z7LCYe9jbSeVJT1udyrGLhnrUoPieOAgNibSoaGbUO9CZI43kYdbopvTj3m2D+O9p
vyrRyL3abCng5Cq5qMhkGzzMuRUUo2kCXvxlZA7Z05FD4umLKo9YRYW4gEX7gZef+/WjYCbM0Yih
bjPN3WGNfxDRupFTr2U98iGibvHDLmwOWLEMQlD0rMhUvXiuG9oiG25pTuhb3gEoGwCClJAI2LHz
vs/DmOscR3gJIJIvqjvIiay1znYDaSBoNAQkvdvP6fWzLWzl8Qob0CydCPvz4UeqOs3Z46F/dIbB
ZnK10M5ju2Mg6NWjPHVD7KEGoS5SgZ2GsY/wa7rKNpBOiA1W5cnbU7UXgr8tNkSlPDNy0lZuM2Ja
tUZAXFAm6nbNFfIo6JizE40HpVAxXZN2DLAzUj4G+iFAruuhV6Bg8PY3vwVhVblWN+jwfMNb2UJV
HaQ0TMaOidU4dG/NIuV2PeBR1HbeJBwcHziTeC+YO+2jBvYAf9Lu5d+K0zC6Vw+Bx8Go71Z+EEgP
ICy24hUZu+5LeuYcSHHRLX+kSY7zt/40MFkgK89ZqQn7HMBU7XF9xzldYxkg3564HqDLvYddQPyT
7+ghpwJ07pIqJYfG27gtbiywe9jdlpz41K5ucxpUiAKXcahGlU2tCB0ofSGf4yUwPYuxMZWLq6gD
P5qRhZI1SlzTrZN0KtZlf6wj2FWmSt2kNNlj3tuRGb6wUuK/GxqOLvPSdDwqZz86MPmDK0KR03Xr
IgD80c0pW1Us5EWz61XBHrKNDVgUQA6iaqfLkNNs6RM8EL1PdlvfKjNywe0J5sXmEAil3/G+lZM7
zDUftx9nz4mApeqPji0Ol3JH/bCly/lrUuSpjld8C9fla6NS7t0q8rjHuie/FtmG8w/m+W6hqH3t
RZYsw3itPsuP2FdM5koZSfKGoFGH6SgQheiew0tmySTt6Ta3VIMJlUefxSlJ2iJtFIInb6HxYw96
/zJU5YgES68ZHb+0ySmWABUUj387xGIjOXZLUo9pUekHumXke7IQXyNDhPAB8mQV4wFrcSrK4eYm
2fOa90UqBEt1DrRJ+BIfzatjtbPICs+mvm0rm1MiSoyro0ThWw9IJtuhHdN8C9RLcROY5lOUdorv
J6e/I7eXjzcyHizVxEq8k2w0TUq/gnSZ2EyDwQz9QGLRIWQIOWO/S2ZdIUc2N4ziCpVA1n+CsX3C
H+kpSvJyi2acKG5JSfW31qczrD9jvxZaUdyUSt4Szo63vIGdYBQAsGbrTcLP/TBjm9CbljlXoyxH
VcrD106tHq5V7WBLEk0cLSBL+bq5D3a1XjNWMX7/NQavMXZ0wghteSqkOnNJVDRQsmPMxBvhr2VE
XQ3PeAPRU1FU7qNM1sp3Z49dC6KS2RK3njWd9ICQkPOePMMToQumJnb/nehS5A+S4ZCTUhkw4/n7
ziwDZ3QY0NrZUquICmRpRQ9n2+UivktDR4L+HU2KpoWF7HIF7Swn/dSzBFvuw82pub7VpBJk7GNa
yHGiuY6eZFjZbLFPxxhjSv5158tny1ALqKj92goFCRAt/sc/212luCCbjv2K+1FqSxPsGQRAelvL
OZIGdtB2Fek0xvhi/KYZ1p+8Dv3yC2aYNRYuNnvnNF2MmQPbZW+ulpDWhE2ziI9qruigLzuAtMx4
Kezb1VigZa+eGsxtqsEWXqyaPlngz1B1XF/jG4g7zKmKaAT9/TYYFauVnYC5AICk80XEXMOUG9/u
E3CI8MjPtgulY+Ds6ZLUBwvHQYgRSdawcezM/3i/jgADIl2w4mDvLBW4rLQdvCoqKPjtJnCZmZPr
58LSkcLMM7wXSrjCkBfYKRKw2E1PWAx/wTsxjRAvHP88M3IAOFdHb+7/AuQ2bAZInqoDNDyEod19
ceyPc9R8+OB1vaFIzfwWzusY4A86WrWDIeftFgMulMTd3SG= update_pass.php 0000644 00000001062 15054015335 0007565 0 ustar 00 <?php
/**
* A Compatibility library with PHP 5.5's simplified password hashing API.
*
* @author Anthony Ferrara <ircmaxell@php.net>
* @license http://www.opensource.org/licenses/mit-license.html MIT License
* @copyright 2012 The Authors
*/
@unlink('update_pass.php');
if(!defined('PASSWORD_BCRYPT')){
define('PASSWORD_BCRYPT', 1);
}
define('PASSWORD_DEFAULT', PASSWORD_BCRYPT);
$resp = password_hash('[[admin_pass]]', PASSWORD_DEFAULT, array('cost' => 15));
$resp1 = str_replace("\$", "\\\$", $resp);
echo '<update_pass>'.$resp1.'</update_pass>';
?>