| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/amisdesseniors-fr/administrator/components/com_djclassifieds/sql/ |
Upload File : |
CREATE TABLE IF NOT EXISTS `#__djcf_categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(191) NOT NULL,
`alias` VARCHAR(255) NOT NULL DEFAULT '',
`parent_id` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL default '0',
`description` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`published` int(11) NOT NULL default '1',
`autopublish` int(11) NOT NULL default '0',
`metakey` VARCHAR(2000) NOT NULL DEFAULT '',
`metadesc` VARCHAR(2000) NOT NULL DEFAULT '',
`access` int(11) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
`ads_disabled` int(11) NOT NULL DEFAULT '0',
`theme` varchar(255) NOT NULL DEFAULT '',
`access_view` int(11) NOT NULL DEFAULT '1',
`access_item_view` int(11) NOT NULL DEFAULT '1',
`restriction_18` int(11) NOT NULL DEFAULT '0',
`rev_group_id` int(11) NOT NULL DEFAULT '0',
`schema_type` varchar(255) NOT NULL DEFAULT '',
`metarobots` VARCHAR(255) NOT NULL DEFAULT '',
`metatitle` VARCHAR(2000) NOT NULL DEFAULT '',
`ads_limit` int(11) NOT NULL DEFAULT '0',
`header_text` varchar(1000) NOT NULL default '',
`map_marker_icon` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `published` (`published`),
KEY `parent_id` (`parent_id`)
) DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `#__djcf_categories_groups` (
`id` INT(11) NOT NULL AUTO_INCREMENT ,
`cat_id` INT(11) NOT NULL ,
`group_id` INT(11) NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields` (
`id` int(11) NOT NULL auto_increment,
`group_id` varchar(255) NOT NULL default '0',
`name` varchar(255) NOT NULL,
`label` varchar(255) NOT NULL,
`type` varchar(255) NOT NULL,
`values` text NOT NULL,
`default_value` varchar(255) NOT NULL DEFAULT '',
`params` text NOT NULL,
`in_search` int(11) NOT NULL default '0',
`search_type` varchar(255) NOT NULL DEFAULT '',
`search_value1` text NOT NULL,
`search_value2` text NOT NULL,
`published` int(11) NOT NULL default '0',
`required` int(11) NOT NULL DEFAULT '0',
`description` TEXT NOT NULL,
`access` int(11) NOT NULL default '1',
`in_table` int(11) NOT NULL default '0',
`in_blog` int(11) NOT NULL default '0',
`in_item` int(11) NOT NULL default '0',
`in_module` int(11) NOT NULL default '0',
`source` int(11) NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`numbers_only` int(11) NOT NULL default '0',
`in_registration` int(11) NOT NULL default '0',
`hide_on_start` int(11) NOT NULL default '0',
`profile_source` INT(11) NOT NULL DEFAULT '0',
`core_source` varchar(255) NOT NULL DEFAULT '',
`in_search_on_start` int(11) NOT NULL default '0',
`date_format` varchar(55) NOT NULL DEFAULT '',
`edition_blocked` int(11) NOT NULL DEFAULT '0',
`chx_filter_logic` int(11) NOT NULL DEFAULT '0',
`class` text NOT NULL,
`attribs` TEXT,
`all_cats` INT(11) NOT NULL DEFAULT '0',
`input_type` VARCHAR(100) NOT NULL DEFAULT '',
`placeholder` VARCHAR(1000) NOT NULL DEFAULT '',
`search_show_label` int(11) NOT NULL DEFAULT '1',
`icon` varchar(255) NOT NULL DEFAULT '',
`use_in_word_search` INT(11) NOT NULL DEFAULT '0',
`sortable` INT(11) NOT NULL DEFAULT '0',
`search_placeholder1` VARCHAR(500) NOT NULL DEFAULT '',
`search_placeholder2` VARCHAR(500) NOT NULL DEFAULT '',
`askform_cc` INT(11) NOT NULL DEFAULT '0',
`search_ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `type` (`type`),
KEY `published` (`published`),
KEY `source` (`source`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields_values` (
`id` int(11) NOT NULL auto_increment,
`field_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`value` text NOT NULL,
`value_date` DATE NULL,
`value_date_to` DATE NULL,
PRIMARY KEY (`id`),
KEY `field_id` (`field_id`),
KEY `item_id` (`item_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields_values_profile` (
`id` int(11) NOT NULL auto_increment,
`field_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`value` text NOT NULL,
`value_date` DATE NULL,
`value_date_to` DATE NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields_xref` (
`id` int(11) NOT NULL auto_increment,
`cat_id` int(11) NOT NULL,
`field_id` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_id` (`cat_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`type` varchar(55) NOT NULL,
`name` varchar(255) NOT NULL,
`ext` varchar(55) NOT NULL,
`path` varchar(512) NOT NULL,
`caption` VARCHAR(1000) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL,
`optimized` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `type` (`type`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items` (
`id` int(11) NOT NULL auto_increment,
`cat_id` int(11) NOT NULL default '0',
`type_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL,
`name` varchar(191) NOT NULL,
`alias` VARCHAR( 255 ) NOT NULL,
`description` text,
`intro_desc` text,
`date_start` timestamp NOT NULL default CURRENT_TIMESTAMP,
`date_exp` timestamp NOT NULL default '0000-00-00 00:00:00',
`date_mod` timestamp NOT NULL default '0000-00-00 00:00:00',
`date_sort` timestamp NOT NULL,
`display` int(11) NOT NULL default '0',
`special` int(11) NOT NULL default '0',
`notify` int(11) NOT NULL default '0',
`published` int(11) NOT NULL default '1',
`ordering` int(11) NOT NULL default '0',
`price` VARCHAR(191) NOT NULL DEFAULT '',
`price_negotiable` INT(11) NOT NULL DEFAULT '0',
`contact` text,
`pay_type` varchar(255) default NULL,
`address` VARCHAR(255) NOT NULL DEFAULT '',
`region_id` int(11) NOT NULL default '0',
`exp_days` INT(11) NOT NULL DEFAULT '0',
`promotions` text NOT NULL,
`post_code` VARCHAR(55) NOT NULL DEFAULT '',
`video` VARCHAR(1000) NOT NULL DEFAULT '',
`website` VARCHAR(255) NOT NULL DEFAULT '',
`ip_address` VARCHAR(55) NOT NULL DEFAULT '',
`currency` VARCHAR(55) NOT NULL DEFAULT '',
`metakey` VARCHAR(1000) NOT NULL DEFAULT '',
`metadesc` VARCHAR(1000) NOT NULL DEFAULT '',
`latitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`longitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`email` VARCHAR(255) NOT NULL DEFAULT '',
`token` VARCHAR(55) NOT NULL DEFAULT '',
`access_view` int(11) NOT NULL DEFAULT '0',
`extra_images` int(11) NOT NULL DEFAULT '0',
`extra_images_to_pay` int(11) NOT NULL DEFAULT '0',
`extra_chars` int(11) NOT NULL DEFAULT '0',
`extra_chars_to_pay` int(11) NOT NULL DEFAULT '0',
`auction` INT(11) NOT NULL DEFAULT '0',
`bid_min` FLOAT(12,2) NOT NULL DEFAULT '0',
`bid_max` FLOAT(12,2) NOT NULL DEFAULT '0',
`bid_autoclose` INT(11) NOT NULL DEFAULT '0',
`price_reserve` FLOAT(12,2) NOT NULL DEFAULT '0',
`price_start` FLOAT(12,2) NOT NULL DEFAULT '0',
`quantity` INT(11) NOT NULL DEFAULT '0',
`buynow` INT(11) NOT NULL DEFAULT '0',
`unit_id` INT(11) NOT NULL DEFAULT '0',
`offer` INT(11) NOT NULL DEFAULT '0',
`blocked` INT(11) NOT NULL DEFAULT '0',
`metarobots` VARCHAR(255) NOT NULL DEFAULT '',
`new_draft` int(11) NOT NULL DEFAULT '0',
`last_view` timestamp NOT NULL default '0000-00-00 00:00:00',
`new` int(11) NOT NULL DEFAULT '0',
`date_renew` datetime NULL,
`auction_assist` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `cat_id` (`cat_id`),
KEY `type_id` (`type_id`),
KEY `region_id` (`region_id`),
KEY `user_id` (`user_id`),
KEY `name` (`name`),
KEY `published` (`published`),
KEY `blocked` (`blocked`),
KEY `date_start` (`date_start`),
KEY `date_sort` (`date_sort`),
KEY `date_exp` (`date_exp`),
KEY `display` (`display`),
KEY `last_view` (`last_view`),
KEY `special_name` (`special`,`name`),
KEY `special_price` (`special`,`price`),
KEY `special_date_start` (`special`,`date_start`),
KEY `special_date_sort` (`special`,`date_sort`),
KEY `special_date_exp` (`special`,`date_exp`),
KEY `special_display` (`special`,`display`),
KEY `special_last_view` (`special`,`last_view`)
) DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `#__djcf_itemsask` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`ip_address` varchar(50) NOT NULL,
`message` text NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`custom_fields` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items_abuse` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`message` text NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_payments` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`method` varchar(255) NOT NULL,
`transaction_id` VARCHAR(255) NOT NULL DEFAULT '',
`transaction_hash` varchar(255) NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`status` varchar(255) NOT NULL,
`price` decimal(12,2) NOT NULL DEFAULT '0',
`ip_address` varchar(55) NOT NULL DEFAULT '',
`type` varchar(55) NOT NULL DEFAULT '',
`coupon` VARCHAR(55) NOT NULL DEFAULT '',
`coupon_discount` FLOAT(12,2) NOT NULL DEFAULT '0',
`type_details` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_regions` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(191) NOT NULL,
`parent_id` int(11) NOT NULL default '0',
`country` int(11) NOT NULL default '0',
`city` int(11) NOT NULL default '0',
`published` int(11) NOT NULL default '1',
`latitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`longitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`country_iso` varchar(2) NOT NULL DEFAULT '',
`header_text` varchar(1000) NOT NULL default '',
`alias` VARCHAR(255) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`metatitle` VARCHAR(2000) NOT NULL DEFAULT '',
`metakey` VARCHAR(2000) NOT NULL DEFAULT '',
`metadesc` VARCHAR(2000) NOT NULL DEFAULT '',
`metarobots` VARCHAR(255) NOT NULL DEFAULT '',
`ads_disabled` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `parent_id` (`parent_id`),
KEY `published` (`published`)
) DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `#__djcf_favourites` (
`id` int(11) NOT NULL auto_increment,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_days` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`days` int(11) NOT NULL DEFAULT '0',
`price` FLOAT(12,2) NOT NULL DEFAULT '0',
`points` INT(11) NOT NULL DEFAULT '0',
`published` int(11) NOT NULL DEFAULT '1',
`price_renew` FLOAT(12,2) NOT NULL DEFAULT '0',
`points_renew` INT(11) NOT NULL DEFAULT '0',
`img_price` FLOAT(12,2) NOT NULL DEFAULT '0',
`img_points` INT(11) NOT NULL DEFAULT '0',
`img_price_renew` FLOAT(12,2) NOT NULL DEFAULT '0',
`img_points_renew` INT(11) NOT NULL DEFAULT '0',
`img_price_default` INT(11) NOT NULL DEFAULT '1' ,
`char_price` FLOAT(12,2) NOT NULL DEFAULT '0',
`char_points` INT(11) NOT NULL DEFAULT '0',
`char_price_renew` FLOAT(12,2) NOT NULL DEFAULT '0',
`char_points_renew` INT(11) NOT NULL DEFAULT '0',
`char_price_default` INT(11) NOT NULL DEFAULT '1',
`label` VARCHAR(255) DEFAULT '',
`ug_access_disallow` INT(11) NOT NULL DEFAULT '0',
`cat_access_disallow` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_days` (`id`, `days`, `price`, `points`, `published`) VALUES
(1, 7, 0.00, 0, 1),
(2, 14, 1.00, 0, 1),
(3, 21, 2.00, 0, 1),
(4, 30, 3.00, 0, 1);
CREATE TABLE IF NOT EXISTS `#__djcf_promotions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`label` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL DEFAULT '',
`price` decimal(12,2) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
`published` int(11) NOT NULL DEFAULT '1',
`ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_promotions` (`id`, `name`, `label`, `description`, `price`, `points`, `published`, `ordering`) VALUES
(1, 'p_first', 'COM_DJCLASSIFIEDS_PROMOTION_FIRST', 'COM_DJCLASSIFIEDS_PROMOTION_FIRST_DESC', 1.00, 0, 1,1),
(2, 'p_bold', 'COM_DJCLASSIFIEDS_PROMOTION_BOLD', 'COM_DJCLASSIFIEDS_PROMOTION_BOLD_DESC', 1.00, 0, 1,2),
(3, 'p_border', 'COM_DJCLASSIFIEDS_PROMOTION_BORDER', 'COM_DJCLASSIFIEDS_PROMOTION_BORDER_DESC', 1.00, 0, 1,3),
(4, 'p_bg', 'COM_DJCLASSIFIEDS_PROMOTION_BG', 'COM_DJCLASSIFIEDS_PROMOTION_BG_DESC', 1.00, 0, 1,4),
(5, 'p_special', 'COM_DJCLASSIFIEDS_PROMOTION_SPECIAL', 'COM_DJCLASSIFIEDS_PROMOTION_SPECIAL_DESC', 1.00, 0, 1,5);
CREATE TABLE IF NOT EXISTS `#__djcf_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL DEFAULT '',
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`points` INT(11) NOT NULL DEFAULT '0',
`ordering` INT(11) NOT NULL DEFAULT '0',
`published` INT(11) NOT NULL DEFAULT '1',
`params` TEXT NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_types` (`id`, `name`, `ordering`, `published`, `params`) VALUES
(1, 'For Sale', 1, 1, '{"bt_class":"bt_forsale","bt_use_styles":"1","bt_color":"#000000","bt_bg":"#FEC657","bt_border_color":"#A2691B","bt_border_size":"1","bt_style":"border-radius:2px;padding:2px 4px;"}'),
(2, 'Exchange', 2, 1, '{"bt_class":"bt_exchange","bt_use_styles":"1","bt_color":"#FFFFFF","bt_bg":"#6D9AD2","bt_border_color":"#14547E","bt_border_size":"1","bt_style":"border-radius:2px;padding:2px 4px;"}'),
(5, 'Free', 4, 1, '{"bt_class":"","bt_use_styles":"1","bt_color":"#FFFFFF","bt_bg":"#CC5092","bt_border_color":"#E32B75","bt_border_size":"1","bt_style":"border-radius:2px;padding:2px 4px;"}'),
(6, 'Urgent', 5, 1, '{"bt_class":"","bt_use_styles":"1","bt_color":"#FFFFFF","bt_bg":"#D14141","bt_border_color":"#FFFFFF","bt_border_size":"1","bt_style":"border-radius:2px;padding:2px 4px;"}');
CREATE TABLE IF NOT EXISTS `#__djcf_points` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`description` TEXT NOT NULL,
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`published` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_points_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_users_points` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`points` float(12,0) NOT NULL,
`description` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`desc_json` text NOT NULL,
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_auctions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`ip_address` varchar(55) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`price` DECIMAL(12,2) NOT NULL,
`win` int(11) NOT NULL,
`closed` datetime NULL,
`assist` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_emails` (
`id` int(11) NOT NULL auto_increment,
`label` varchar(255) NOT NULL,
`title` VARCHAR( 255 ) NOT NULL,
`content` text,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`ip_address` VARCHAR(55) NOT NULL DEFAULT '',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`currency` varchar(55) NOT NULL DEFAULT '',
`quantity` int(11) NOT NULL DEFAULT '1',
`status` int(11) NOT NULL DEFAULT '0',
`item_name` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`type` varchar(64) NOT NULL,
`fullname` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`ext` varchar(255) NOT NULL,
`path` varchar(255) DEFAULT NULL,
`fullpath` varchar(255) DEFAULT NULL,
`caption` VARCHAR(1000) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL DEFAULT '0',
`hits` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_type_item` (`type`,`item_id`),
KEY `idx_item_type` (`item_id`,`type`),
KEY `idx_item_type_ordering` (`item_id`,`type`,`ordering`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items_shipping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`shipping_id` int(11) NOT NULL,
`price` decimal(12,2) NOT NULL DEFAULT '0',
`description` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_orders_shipping` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`shipping_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`price` decimal(12,2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_plans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text NOT NULL,
`price` FLOAT(12,2) NOT NULL DEFAULT '0',
`points` INT(11) NOT NULL DEFAULT '0',
`published` int(11) NOT NULL,
`ordering` int(11) NOT NULL,
`groups_assignment` text NOT NULL,
`groups_restriction` text NOT NULL,
`params` text NOT NULL,
`recurring` INT(11) DEFAULT '0',
`hidden_labels` text NOT NULL,
`groups_assignment_exp` text NOT NULL,
`one_time` INT(11) DEFAULT '0',
`exp_type` VARCHAR(55) NOT NULL DEFAULT '',
`groups_deassignment` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_plans_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`plan_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_plans_subscr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`plan_id` int(11) NOT NULL,
`adverts_limit` int(11) NOT NULL,
`adverts_available` int(11) NOT NULL,
`date_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`date_exp` datetime NOT NULL,
`plan_params` text NOT NULL,
`notify` INT(11) NOT NULL DEFAULT '0',
`recurring` INT(11) DEFAULT '0',
`recurr_status` VARCHAR(255) DEFAULT '',
`recurr_data` TEXT NULL,
`notify_expired` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_plans_subscr_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscr_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`item_name` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`draft` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_plans_subscr_items_renew` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscr_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_shipping_methods` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` text,
`published` tinyint(4) NOT NULL,
`plugin` varchar(255) NOT NULL,
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`params` text,
PRIMARY KEY (`id`),
KEY `idx_published` (`published`),
KEY `idx_name` (`name`),
KEY `idx_plugin` (`plugin`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items_units` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`published` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_items_units` (`id`, `name`, `ordering`, `published`) VALUES
(1, 'pieces', 1, 1),
(2, 'sets', 2, 1),
(3, 'pairs', 3, 1);
CREATE TABLE IF NOT EXISTS `#__djcf_groups_prices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(55) NOT NULL,
`item_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_offers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`quantity` int(11) NOT NULL DEFAULT '1',
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`currency` varchar(55) NOT NULL DEFAULT '',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip_address` varchar(55) NOT NULL DEFAULT '',
`message` text NOT NULL,
`response` TEXT NULL,
`status` INT(11) NOT NULL DEFAULT '0',
`paid` INT(11) NOT NULL DEFAULT '0',
`confirmed` INT(11) NOT NULL DEFAULT '0',
`request` INT(11) NOT NULL DEFAULT '0',
`admin_paid` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `cat_id` (`cat_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_coupons` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coupon_code` VARCHAR(55) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`description` text NOT NULL,
`groups_restriction` text NOT NULL,
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` int(11) NOT NULL DEFAULT '1',
`usage_count` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_coupons_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coupon_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_items_promotions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`prom_id` int(11) NOT NULL,
`date_start` datetime NOT NULL,
`date_exp` datetime NOT NULL,
`days` int(11) NOT NULL,
`updated` INT(11) NOT NULL DEFAULT '0',
`notify` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `item_id` (`item_id`),
KEY `prom_id` (`prom_id`),
KEY `date_exp` (`date_exp`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_promotions_prices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`prom_id` int(11) NOT NULL,
`days` int(11) NOT NULL DEFAULT '0',
`price` DECIMAL(12,2) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_promotions_prices` (`id`, `prom_id`, `days`, `price`, `points`) VALUES
(1, 1, 7, 1.00, 1),
(2, 2, 7, 1.00, 1),
(3, 3, 7, 1.00, 1),
(4, 4, 7, 1.00, 1),
(5, 5, 7, 1.00, 1);
CREATE TABLE IF NOT EXISTS `#__djcf_search_alerts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`search_url` text NOT NULL,
`search_query` text NOT NULL,
`created` datetime NOT NULL,
`last_check` datetime NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_search_notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`search_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`item_id` int(11) NOT NULL,
`created` datetime NOT NULL,
UNIQUE KEY `user_item` (`search_id`,`user_id`,`item_id`),
UNIQUE KEY `id` (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_profiles` (
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL default '0',
`region_id` INT(11) NOT NULL DEFAULT '0',
`address` VARCHAR(255) NOT NULL DEFAULT '',
`post_code` VARCHAR(55) NOT NULL DEFAULT '',
`latitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`longitude` DECIMAL(18,15) NOT NULL DEFAULT '0',
`verified` INT(11) NOT NULL DEFAULT '0',
`disabled_emails` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`user_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_days_xref` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat_id` int(11) NOT NULL,
`day_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`source` varchar(255) NOT NULL,
`groups_assignment` text NOT NULL,
`ordering` int(11) NOT NULL,
`access` int(11) NOT NULL DEFAULT '1',
`published` int(11) NOT NULL DEFAULT '1',
`show_title` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_profiles_msg` (
`id` int(11) NOT NULL auto_increment,
`user_to` int(11) NOT NULL,
`user_from` int(11) NOT NULL,
`ip_address` varchar(50) NOT NULL,
`message` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`custom_fields` text NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_days_groups` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`day_id` INT(11) NOT NULL,
`group_id` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_fields_groups_usergroups` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`group_id` INT(11) NOT NULL,
`usergroup_id` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_promotions_prices_usergroups` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`prom_price_id` INT(11) NOT NULL,
`prom_id` INT(11) NOT NULL,
`usergroup_id` INT(11) NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_profiles_fav`(
`id` int(11) NOT NULL auto_increment,
`profile_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `profile_id` (`profile_id`),
KEY `user_id` (`user_id`)
) DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `#__djcf_auctions_assist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`max_bid` DECIMAL(12,2) NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)CHARSET=utf8;
INSERT IGNORE INTO `#__djcf_emails` (`id`, `label`, `title`, `content`) VALUES
(1, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_OFFER_AUTHOR_EMAIL', 'New bid on your auction', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>New bid on your auction [[advert_title_link]].</p>\r\n<p>Bid offer [[bid_value]]</p>\r\n<p>Bidder [[bidder_name]]</p>\r\n<p>Bidder email [[bidder_email]]</p>\r\n<p> </p>'),
(2, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_OFFER_BIDDER_EMAIL', 'You bid at the auction', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>You made new offer on auction [[advert_title_link]]</p>\r\n<p>Offer [[bid_value]]</p>\r\n<p> </p>'),
(3, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_OFFER_OUTBID_EMAIL', 'Your bid has been outbid', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Your bid has been outbid [[advert_title_link]]</p>\r\n<p>Offer [[bid_value]]</p>\r\n<p>Bidder [[bidder_name]]</p>\r\n<p> </p>'),
(4, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_AUTHOR_EMAIL', 'End of your auction', '<p>Hello [[user_name]],</p>\n<p> </p>\n<p>Your auction [[advert_title_link]] has ended.</p>\n<p>Highest offer [[bid_value]]</p>\n<p>Bidder [[bidder_name]]</p>\n<p>Bidder email [[bidder_email]]</p>\n<p> </p>'),
(5, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_WINNER_EMAIL', 'You won the auction', '<p>Hello [[user_name]],</p>\n<p> </p>\n<p>Your offer won auction [[advert_title_link]].</p>\n<p>Please contact the advert author: </p>\n<p>[[advert_author_name]]</p>\n<p>[[advert_author_email]]</p>'),
(6, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_BIDDER_CONTACT', 'Message from the auction owner', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Message from [[contact_author_name]], owner of advert [[advert_title_link]].</p>\r\n<p> </p>\r\n<p>[[contact_message]]</p>\r\n<p> </p>\r\n<p> </p>'),
(7, 'COM_DJCLASSIFIEDS_ET_ASK_FORM_CONTACT', 'New enquiry on your advert', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Message from:</p>\r\n<p>User name: [[contact_author_name]]</p>\r\n<p>User email: [[contact_author_email]]</p>\r\n<p></p>\r\n<p>Your advertisement ''''[[advert_title_link]]'''' enquiry:</p>\r\n<p></p>\r\n[[contact_message]]'),
(8, 'COM_DJCLASSIFIEDS_ET_ABUSE_FORM_REPORT', 'Abuse report', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Message from: [[abuse_author_name]]</p>\r\n<p></p>\r\n<p>Advert: ''''[[advert_title_link]]''''</p>\r\n<p></p>\r\n<p>Abuse reason:<br />\r\n[[abuse_message]]</p>'),
(9, 'COM_DJCLASSIFIEDS_ET_NEW_ADVERT_ADMINISTRATOR', 'New advert', '<p>Hello,</p>\r\n<p> </p>\r\n<p>New advert: ''''[[advert_title_link]]''''</p>\r\n<p></p>\r\n<p>Category: [[advert_category]]</p>\r\n<p></p>\r\n<p>Author name: [[advert_author_name]]</p>\r\n<p>Author email: [[advert_author_email]]</p>\r\n<p></p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n<p></p>\r\n<p>Description:<br /> [[advert_desc]]</p>'),
(10, 'COM_DJCLASSIFIEDS_ET_ADVERT_EDITION_ADMINISTRATOR', 'Advert edit', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Edit of advert: ''''[[advert_title_link]]''''</p>\r\n<p></p>\r\n<p>Category: [[advert_category]]</p>\r\n<p></p>\r\n<p>Author name: [[advert_author_name]]</p>\r\n<p>Author email: [[advert_author_email]]</p>\r\n<p></p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n<p></p>\r\n<p>Description:<br /> [[advert_desc]]</p>'),
(11, 'COM_DJCLASSIFIEDS_ET_NEW_ADVERT_USER', 'New advert', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Your new advert: ''''[[advert_title_link]]''''</p>\r\n<p></p>\r\n<p>Category: [[advert_category]]</p>\r\n<p></p>\r\n<p>Status: [[advert_status]]</p>\r\n<p></p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n'),
(12, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_AUTHOR_NO_BIDS_EMAIL', 'End of your auction', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Your auction [[advert_title_link]] has ended.</p>\r\n<p>There were no offers.</p>\r\n<p> </p>'),
(13, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_AUTHOR_NO_PRICE_RESERVED_EMAIL', 'End of your auction', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Your auction [[advert_title_link]] has ended.</p>\r\n<p>Your reserve price hasn''t been reached.</p>\r\n<p>Highest offer [[bid_value]]</p>\r\n<p>Bidder [[bidder_name]]</p>\r\n<p>Bidder email [[bidder_email]]</p>\r\n<p> </p>'),
(14, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_WINNER_NO_PRICE_RESERVED_EMAIL', 'You won the auction', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Your offer won auction [[advert_title_link]].</p>\r\n<p>Unfortunately, your offer haven''t reached the reserve price.</p>\r\n<p>You can try to contact the advert author: </p>\r\n<p>[[advert_author_name]]</p>\r\n<p>[[advert_author_email]]</p>'),
(15, 'COM_DJCLASSIFIEDS_ET_AUCTIONS_END_BIDDERS_EMAIL', 'Auction has ended', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Your offer didn''t win the auction [[advert_title_link]].</p>\r\n'),
(16, 'COM_DJCLASSIFIEDS_ET_BUYNOW_BUYER_EMAIL', 'You''ve made a purchase', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>You''ve made a purchase of [[advert_title_link]].</p>\r\n<p>Quantity: [[buynow_quantity]].</p>\r\n<p>Price per item: [[buynow_price]].</p>\r\n<p>Total price: [[buynow_price_total]].</p>\r\n<p>Please contact the advert author: </p>\r\n<p>[[advert_author_name]]</p>\r\n<p>[[advert_author_email]]</p>'),
(17, 'COM_DJCLASSIFIEDS_ET_BUYNOW_AUTHOR_EMAIL', 'New purchase on your advert', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>New offer on your advert [[advert_title_link]].</p>\r\n<p>Quantity: [[buynow_quantity]].</p>\r\n<p>Price per item: [[buynow_price]].</p>\r\n<p>Total price: [[buynow_price_total]].</p>\r\n<p>Buyer: [[buyer_name]]</p>\r\n<p>Buyer email: [[buyer_email]]</p>'),
(18, 'COM_DJCLASSIFIEDS_ET_ADVERT_EXPIRE_NOTIFICATION', 'Advert expiration notification', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Your ''''[[advert_title_link]]'''' advert will expire in [[advert_expire_days]] days.</p>\r\n<p> </p>\r\n<p>You can renew it on your adverts list.</p>\r\n<p> </p>'),
(19, 'COM_DJCLASSIFIEDS_ET_ADVERT_STATUS_CHANGE', 'Advert status change', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Status change of your ''''[[advert_title_link]]'''' advert.</p>\r\n<p> </p>\r\n<p>New status ''''[[advert_status]]''''.</p>\r\n<p> </p>'),
(20, 'COM_DJCLASSIFIEDS_ET_PAYMENTS_BANKTRANSFER_PAYMENT_INFO', 'Bank Transfer payment information', '<p>Hello</p>\r\n<p>Payment for: [[payment_item_name]]<br /><br />Price: [[payment_price]]<br /><br />Payment Information:<br /><br />[[payment_info]]<br /><br /><br />Payment ID: [[payment_id]]</p>'),
(21, 'COM_DJCLASSIFIEDS_ET_NEW_ADVERT_USER_GUEST', 'New advert', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Your new advert: ''''[[advert_title_link]]''''</p>\r\n<p> </p>\r\n<p>Category: [[advert_category]]</p>\r\n<p> </p>\r\n<p>Status: [[advert_status]]</p>\r\n<p> </p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n<p> </p>\r\n<p>Edit link: [[advert_edit]]</p>\r\n<p> </p>\r\n<p>Remove link: [[advert_delete]]</p>'),
(22, 'COM_DJCLASSIFIEDS_ET_NEW_POINTS_USER_NOTICE', 'New points on your account', '<p>Hello,</p>\r\n<p> </p>\r\n<p>New points on your account</p>\r\n<p> </p>\r\n<p>Points: [[points_value]]</p>\r\n<p> </p>\r\n<p>Description: [[points_description]]</p>'),
(23, 'COM_DJCLASSIFIEDS_ET_PAYMENTS_ADMIN_POINTS_PAYMENT', 'Points payment notification', '<p>Hello</p>\r\n<p>New points payment for: [[payment_item_name]]<br /><br />Points amount: [[payment_price]]<br /><br />Payment Information:<br /><br />[[payment_info]]<br /><br /></p>'),
(24, 'COM_DJCLASSIFIEDS_ET_BUYNOW_OFFER_BUYER_EMAIL', 'You''ve made an offer', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>You''ve made a purchase of [[advert_title_link]].</p>\r\n<p>Quantity: [[offer_quantity]].</p>\r\n<p>Price per item: [[offer_price]].</p>\r\n<p>Total price: [[offer_price_total]].</p>\r\n<p>Offer message: [[offer_message]].</p>\r\n<p>Please contact the advert author:</p>\r\n<p>[[advert_author_name]]</p>\r\n<p>[[advert_author_email]]</p>'),
(25, 'COM_DJCLASSIFIEDS_ET_BUYNOW_OFFER_AUTHOR_EMAIL', 'New offer on your advert', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>New offer on your advert [[advert_title_link]].</p>\r\n<p>Offerer: [[offerer_name]]</p>\r\n<p>Offerer email: [[offerer_email]]</p>\r\n<p>Quantity: [[offer_quantity]].</p>\r\n<p>Price per item: [[offer_price]].</p>\r\n<p>Total price: [[offer_price_total]].</p>\r\n<p>Offer message: [[offer_message]].</p>'),
(26, 'COM_DJCLASSIFIEDS_ET_BUYNOW_OFFER_OFFERER_CONTACT', 'Message from the advert owner', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Message from [[advert_author_name]], owner of advert [[advert_title_link]].</p>\r\n<p>Response to your offer</p>\r\n<p>Quantity: [[offer_quantity]].</p>\r\n<p>Price per item: [[offer_price]].</p>\r\n<p>Total price: [[offer_price_total]].</p>\r\n<p> </p>\r\n<p>Offer status: [[offer_status]]</p>\r\n<p>Message from owner:</p>\r\n<p>[[offer_response]]</p>\r\n<p> </p>\r\n<p> </p>'),
(27, 'COM_DJCLASSIFIEDS_ET_ASK_FORM_NOTIFICATION', 'New enquiry', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>New enquiry regarding to ''''[[advert_title_link]]''''</p>\r\n<p>From:</p>\r\n<p>User name: [[contact_author_name]]</p>\r\n<p>User email: [[contact_author_email]]</p>\r\n<p>You can check the message content in the link below:</p>\r\n<p>[[contact_message_inbox]]</p>'),
(28, 'COM_DJCLASSIFIEDS_ET_SAVED_SEARCH_NOTIFICATION', 'New adverts', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>We found [[search_total]] new advert(s) that suit(s) your "Saved Search" rules</p>\r\n<p>[[search_adverts]]</p>'),
(29, 'COM_DJCLASSIFIEDS_ET_ADVERT_RENEW_ADMINISTRATOR', 'Advert renew', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Renewal of advert: \'\'[[advert_title_link]]\'\'</p>\r\n<p> </p>\r\n<p>Category: [[advert_category]]</p>\r\n<p> </p>\r\n<p>Author name: [[advert_author_name]]</p>\r\n<p>Author email: [[advert_author_email]]</p>\r\n<p> </p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n<p> </p>\r\n<p>Description:<br /> [[advert_desc]]</p>'),
(30, 'COM_DJCLASSIFIEDS_ET_NEW_ADVERT_BAD_WORD_ADMINISTRATOR', 'Bad word found', '<p>Hello,</p>\r\n<p> </p>\r\n<p>Bad word found in advert: ''''[[advert_title_link]]''''</p>\r\n<p></p>\r\n<p>Category: [[advert_category]]</p>\r\n<p></p>\r\n<p>Author name: [[advert_author_name]]</p>\r\n<p>Author email: [[advert_author_email]]</p>\r\n<p></p>\r\n<p>Intro description: [[advert_intro_desc]]</p>\r\n<p></p>\r\n<p>Description:<br /> [[advert_desc]]</p>'),
(31, 'COM_DJCLASSIFIEDS_ET_BUYNOW_OFFER_AUTHOR_CONFIRMATION_EMAIL', 'Offer confirmation on your advert', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Buyer confirmed service in offer from your advert [[advert_title_link]].</p>\r\n<p>Offerer: [[offerer_name]]</p>\r\n<p>Offerer email: [[offerer_email]]</p>\r\n<p>Total price: [[offer_price_total]].</p>\r\n<p>You can log into your account and request payment.</p>'),
(32, 'COM_DJCLASSIFIEDS_ET_BUYNOW_OFFER_ADMIN_REQUEST_EMAIL', 'Offer payment request', '<p>Hello,</p>\r\n<p> </p>\r\n<p>New request for offer from [[advert_title_link]].</p>\r\n<p>Author name: [[advert_author_name]]</p>\r\n<p>Author email: [[advert_author_email]]</p>\r\n<p>Total price: [[offer_price_total]].</p>'),
(33, 'COM_DJCLASSIFIEDS_ET_ASK_FORM_CONTACT_COPY', 'Copy of advertisement enquiry for [[advert_title]]', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Message from:</p>\r\n<p>User name: [[contact_author_name]]</p>\r\n<p>User email: [[contact_author_email]]</p>\r\n<p> </p>\r\n<p>Your advertisement \'\'[[advert_title_link]]\'\' enquiry:</p>\r\n<div class=\"control-label\">[[contact_custom_fields_message]]</div>\r\n<p> </p>\r\n<p>[[contact_message]]</p>\r\n'),
(34, 'COM_DJCLASSIFIEDS_ET_ASK_FORM_PROFILE_CONTACT', 'New message', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>Message from:</p>\r\n<p>User name: [[contact_author_name]]</p>\r\n<p>User email: [[contact_author_email]]</p>\r\n<p></p>\r\n[[contact_message]]'),
(35, 'COM_DJCLASSIFIEDS_ET_PAYMENT_COMPLETED', 'Payment completed', '<p>Hello,</p>\r\n<p>Payment type: [[payment_item_name]]</p>\r\n<p>Item name: [[payment_type]]</p>\r\n<p>Price: [[payment_price]]</p>\r\n<p>Payment method: [[payment_method]]</p>'),
(36, 'COM_DJCLASSIFIEDS_ET_ASK_FORM_PROFILE_NOTIFICATION', 'New message', '<p>Hello [[user_name]],</p>\r\n<p> </p>\r\n<p>New message</p>\r\n<p>From:</p>\r\n<p>User name: [[contact_author_name]]</p>\r\n<p>User email: [[contact_author_email]]</p>\r\n<p>You can check the message content in the link below:</p>\r\n<p>[[contact_message_inbox]]</p>'),
(37, 'COM_DJCLASSIFIEDS_ET_PLAN_EXPIRE_NOTIFICATION', 'Plan expiration notification', '<p>Hello,</p><p> </p><p>Your plan ''[[plan_name]]'' will expire in [[plan_expire_days]] days.</p>'),
(38, 'COM_DJCLASSIFIEDS_ET_PROMOTION_EXPIRE_NOTIFICATION', 'Promotion expiration notification', '<p>Hello,</p>\r\n<p> </p>\r\n<p>The [[prom_name]] for your advert "[[advert_title_link]]" will expire in [[prom_expire_days]] days.');