Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../avactis
• File: avactis.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `avactis480`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]admin`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]admin` (
[20] Fix | Delete
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`admin_firstname` varchar(50) DEFAULT NULL,
[22] Fix | Delete
`admin_lastname` varchar(50) DEFAULT NULL,
[23] Fix | Delete
`admin_email_address` varchar(50) DEFAULT NULL,
[24] Fix | Delete
`admin_password` varchar(50) DEFAULT NULL,
[25] Fix | Delete
`admin_old_password` varchar(50) DEFAULT NULL,
[26] Fix | Delete
`admin_created` date DEFAULT '0000-00-00',
[27] Fix | Delete
`admin_modified` date DEFAULT '0000-00-00',
[28] Fix | Delete
`admin_logdate` date DEFAULT '0000-00-00',
[29] Fix | Delete
`admin_lognum` int(11) DEFAULT NULL,
[30] Fix | Delete
`admin_remember_email` varchar(5) DEFAULT NULL,
[31] Fix | Delete
`admin_options` int(11) DEFAULT NULL,
[32] Fix | Delete
`admin_lng` char(2) DEFAULT NULL,
[33] Fix | Delete
PRIMARY KEY (`admin_id`)
[34] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[35] Fix | Delete
[36] Fix | Delete
--
[37] Fix | Delete
-- Dumping data for table `[[dbprefix]]admin`
[38] Fix | Delete
--
[39] Fix | Delete
[40] Fix | Delete
INSERT INTO `[[dbprefix]]admin` VALUES
[41] Fix | Delete
(1, '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', '[[admin_pass]]', '[[admin_pass]]', '[[reg_time]]', '0000-00-00', '0000-00-00', 0, 'false', 15, '');
[42] Fix | Delete
[43] Fix | Delete
-- --------------------------------------------------------
[44] Fix | Delete
[45] Fix | Delete
--
[46] Fix | Delete
-- Table structure for table `[[dbprefix]]admin_ip`
[47] Fix | Delete
--
[48] Fix | Delete
[49] Fix | Delete
CREATE TABLE `[[dbprefix]]admin_ip` (
[50] Fix | Delete
`admin_ip_id` int(11) NOT NULL AUTO_INCREMENT,
[51] Fix | Delete
`admin_id` int(11) DEFAULT NULL,
[52] Fix | Delete
`admin_ip_address` varchar(20) DEFAULT NULL,
[53] Fix | Delete
`admin_ip_incorrect_login_count` int(11) DEFAULT NULL,
[54] Fix | Delete
`admin_ip_last_login_time` int(11) DEFAULT NULL,
[55] Fix | Delete
PRIMARY KEY (`admin_ip_id`),
[56] Fix | Delete
KEY `IDX_ai` (`admin_id`)
[57] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[58] Fix | Delete
[59] Fix | Delete
-- --------------------------------------------------------
[60] Fix | Delete
[61] Fix | Delete
--
[62] Fix | Delete
-- Table structure for table `[[dbprefix]]admin_pages`
[63] Fix | Delete
--
[64] Fix | Delete
[65] Fix | Delete
CREATE TABLE `[[dbprefix]]admin_pages` (
[66] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[67] Fix | Delete
`identifier` varchar(255) NOT NULL,
[68] Fix | Delete
`classname` varchar(255) NOT NULL,
[69] Fix | Delete
`title` varchar(255) NOT NULL,
[70] Fix | Delete
`heading` varchar(255) NOT NULL,
[71] Fix | Delete
`help_identifier` varchar(255) NOT NULL,
[72] Fix | Delete
`item_value` varchar(255) NOT NULL,
[73] Fix | Delete
`onload_js` varchar(255) DEFAULT NULL,
[74] Fix | Delete
`parent` varchar(255) NOT NULL,
[75] Fix | Delete
PRIMARY KEY (`identifier`),
[76] Fix | Delete
KEY `IDX_id` (`id`)
[77] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[78] Fix | Delete
[79] Fix | Delete
-- --------------------------------------------------------
[80] Fix | Delete
[81] Fix | Delete
--
[82] Fix | Delete
-- Table structure for table `[[dbprefix]]admin_permissions`
[83] Fix | Delete
--
[84] Fix | Delete
[85] Fix | Delete
CREATE TABLE `[[dbprefix]]admin_permissions` (
[86] Fix | Delete
`admin_id` int(11) DEFAULT NULL,
[87] Fix | Delete
`permission` int(11) DEFAULT NULL,
[88] Fix | Delete
`access_level` int(11) DEFAULT NULL,
[89] Fix | Delete
UNIQUE KEY `IDX_ap` (`admin_id`,`permission`)
[90] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[91] Fix | Delete
[92] Fix | Delete
-- --------------------------------------------------------
[93] Fix | Delete
[94] Fix | Delete
--
[95] Fix | Delete
-- Table structure for table `[[dbprefix]]attributes`
[96] Fix | Delete
--
[97] Fix | Delete
[98] Fix | Delete
CREATE TABLE `[[dbprefix]]attributes` (
[99] Fix | Delete
`attribute_id` int(11) NOT NULL AUTO_INCREMENT,
[100] Fix | Delete
`attribute_group_id` int(11) NOT NULL DEFAULT '0',
[101] Fix | Delete
`input_type_id` int(11) DEFAULT NULL,
[102] Fix | Delete
`unit_type` varchar(10) DEFAULT NULL,
[103] Fix | Delete
`attribute_view_tag` varchar(100) DEFAULT NULL,
[104] Fix | Delete
`attribute_name` varchar(255) DEFAULT NULL,
[105] Fix | Delete
`attribute_descr` longtext,
[106] Fix | Delete
`attribute_type` varchar(10) DEFAULT NULL,
[107] Fix | Delete
`attribute_allow_html` int(11) DEFAULT NULL,
[108] Fix | Delete
`attribute_min_value` varchar(255) DEFAULT NULL,
[109] Fix | Delete
`attribute_max_value` varchar(255) DEFAULT NULL,
[110] Fix | Delete
`attribute_html_size` varchar(255) DEFAULT NULL,
[111] Fix | Delete
`attribute_multilang` varchar(1) DEFAULT NULL,
[112] Fix | Delete
`attribute_sort_order` int(11) DEFAULT NULL,
[113] Fix | Delete
PRIMARY KEY (`attribute_id`),
[114] Fix | Delete
KEY `IDX_pagi` (`attribute_group_id`),
[115] Fix | Delete
KEY `IDX_iti` (`input_type_id`),
[116] Fix | Delete
KEY `IDX_aso` (`attribute_sort_order`)
[117] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;
[118] Fix | Delete
[119] Fix | Delete
--
[120] Fix | Delete
-- Dumping data for table `[[dbprefix]]attributes`
[121] Fix | Delete
--
[122] Fix | Delete
[123] Fix | Delete
INSERT INTO `[[dbprefix]]attributes` VALUES
[124] Fix | Delete
(1, 1, 1, 'currency', 'SalePrice', 'PRD_SALEPRC_NAME', 'PRD_SALEPRC_DESCR', 'standard', 0, '0', '15', '15', 'N', 11),
[125] Fix | Delete
(2, 1, 1, 'currency', 'ListPrice', 'PRD_LISTPRC_NAME', 'PRD_LISTPRC_DESCR', 'standard', 0, '0', '15', '15', 'N', 12),
[126] Fix | Delete
(3, 1, 1, 'item', 'QuantityInStock', 'PRD_QUINSTOCK_NAME', 'PRD_QUINSTOCK_DESCR', 'standard', 0, '0', '15', '15', 'N', 13),
[127] Fix | Delete
(6, 1, 1, 'item', 'LowStockLevel', 'PRD_LOWLEV_NAME', 'PRD_LOWLEV_DESCR', 'standard', 0, '0', '15', '15', 'N', 14),
[128] Fix | Delete
(4, 1, 1, 'string256', 'SKU', 'PRD_SKU_NAME', 'PRD_SKU_DESCR', 'standard', 0, '0', '256', '30', 'N', 15),
[129] Fix | Delete
(5, 1, 1, 'item', 'MinQuantity', 'PRD_QUINORDER_NAME', 'PRD_QUINORDER_DESCR', 'standard', 0, '0', '15', '15', 'N', 16),
[130] Fix | Delete
(7, 1, 7, '', 'Available', 'PRD_AVAIL_NAME', 'PRD_AVAIL_DESCR', 'standard', 0, '0', '10', '5', 'N', 17),
[131] Fix | Delete
(8, 1, 6, '', 'TaxClass', 'PRD_TAX_CLASS_NAME', 'PRD_TAX_CLASS_DESCR', 'standard', 0, '0', '0', '0', 'N', 18),
[132] Fix | Delete
(24, 1, 8, '', 'Manufacturer', 'PRD_MANUFACTURER_NAME', 'PRD_MANUFACTURER_DESCR', 'standard', 0, '0', '0', '0', 'N', 19),
[133] Fix | Delete
(27, 1, 1, 'string256', 'UPC', 'PRD_UPC_NAME', 'PRD_UPC_DESCR', 'standard', 0, '0', '15', '15', 'N', 20),
[134] Fix | Delete
(28, 1, 1, 'string256', 'EAN', 'PRD_EAN_NAME', 'PRD_EAN_DESCR', 'standard', 0, '0', '15', '15', 'N', 21),
[135] Fix | Delete
(29, 1, 1, 'string256', 'JAN', 'PRD_JAN_NAME', 'PRD_JAN_DESCR', 'standard', 0, '0', '15', '15', 'N', 22),
[136] Fix | Delete
(30, 1, 1, 'string256', 'ISBN', 'PRD_ISBN_NAME', 'PRD_ISBN_DESCR', 'standard', 0, '0', '15', '15', 'N', 23),
[137] Fix | Delete
(31, 1, 1, 'string256', 'MPN', 'PRD_MPN_NAME', 'PRD_MPN_DESCR', 'standard', 0, '0', '256', '15', 'N', 24),
[138] Fix | Delete
(9, 2, 5, '', 'LargeImage', 'PRD_LRGIMG_NAME', 'PRD_LRGIMG_DESCR', 'standard', 0, '0', '0', '0', 'N', 21),
[139] Fix | Delete
(10, 2, 5, '', 'SmallImage', 'PRD_SMLIMG_NAME', 'PRD_SMLIMG_DESCR', 'standard', 0, '0', '0', '0', 'N', 22),
[140] Fix | Delete
(11, 2, 1, 'string256', 'ImageAltText', 'PRD_IMGDESCR_NAME', 'PRD_IMGDESCR_DESCR', 'standard', 0, '0', '256', '70', 'Y', 23),
[141] Fix | Delete
(12, 3, 2, 'mstring', 'ShortDescription', 'PRD_SHRDESCR_NAME', 'PRD_SHRDESCR_DESCR', 'standard', 1, '0', '0', '0', 'Y', 31),
[142] Fix | Delete
(13, 3, 2, 'mstring', 'DetailedDescription', 'PRD_DETDESCR_NAME', 'PRD_DETDESCR_DESCR', 'standard', 1, '0', '0', '0', 'Y', 32),
[143] Fix | Delete
(14, 4, 1, 'currency', 'PerItemShippingCost', 'PRD_SHIPPRC_NAME', 'PRD_SHIPPRC_DESCR', 'standard', 0, '0', '15', '15', 'N', 41),
[144] Fix | Delete
(20, 4, 1, 'currency', 'PerItemHandlingCost', 'PRD_HANDRC_NAME', 'PRD_HANDRC_DESCR', 'standard', 0, '0', '15', '15', 'N', 42),
[145] Fix | Delete
(15, 4, 1, 'weight', 'Weight', 'PRD_WEIGHT_NAME', 'PRD_WEIGHT_DESCR', 'standard', 0, '0', '15', '15', 'N', 43),
[146] Fix | Delete
(21, 4, 3, '', 'FreeShipping', 'PRD_FREESHIP_NAME', 'PRD_FREESHIP_DESCR', 'standard', 0, '0', '0', '0', 'N', 44),
[147] Fix | Delete
(22, 4, 3, '', 'NeedShipping', 'PRD_NEEDSHIP_NAME', 'PRD_NEEDSHIP_DESCR', 'standard', 0, '0', '0', '0', 'N', 45),
[148] Fix | Delete
(75, 4, 1, 'length', 'Length', 'PRD_LENGTH_NAME', 'PRD_LENGTH_DESCR', 'standard', 0, '0', '15', '15', 'N', 46),
[149] Fix | Delete
(76, 4, 1, 'length', 'Width', 'PRD_WIDTH_NAME', 'PRD_WIDTH_DESCR', 'standard', 0, '0', '15', '15', 'N', 47),
[150] Fix | Delete
(77, 4, 1, 'length', 'Height', 'PRD_HEIGHT_NAME', 'PRD_HEIGHT_DESCR', 'standard', 0, '0', '15', '15', 'N', 48),
[151] Fix | Delete
(17, 5, 1, 'string256', 'PageTitle', 'PRD_PAGETTL_NAME', 'PRD_PAGETTL_DESCR', 'standard', 0, '0', '256', '75', 'Y', 51),
[152] Fix | Delete
(18, 5, 2, 'string1024', 'MetaKeywords', 'PRD_METAKWRD_NAME', 'PRD_METAKWRD_DESCR', 'standard', 0, '0', '0', '0', 'Y', 52),
[153] Fix | Delete
(19, 5, 2, 'string1024', 'MetaDescription', 'PRD_METADESCR_NAME', 'PRD_METADESCR_DESCR', 'standard', 0, '0', '0', '0', 'Y', 53),
[154] Fix | Delete
(23, 5, 1, 'string256', 'SEOPrefix', 'PRD_SEOURL_NAME', 'PRD_SEOURL_DESCR', 'standard', 0, '0', '256', '75', 'Y', 54),
[155] Fix | Delete
(60, 6, 11, '', 'Gpc', 'Google Product Category', 'Value which is necessary for exporting products to the Google Merchant Center.For more information see http://www.google.com/support/merchants/', 'custom', 0, '0', '255', '0', '', 81),
[156] Fix | Delete
(61, 6, 12, '', 'Agegroup', 'Age Group', 'Value which is necessary for exporting products to the Google Merchant Center.For more information see http://www.google.com/support/merchants/', 'custom', 0, '0', '255', '0', '', 82),
[157] Fix | Delete
(62, 6, 13, '', 'Gender', 'Gender', 'Value which is necessary for exporting products to the Google Merchant Center.For more information see http://www.google.com/support/merchants/', 'custom', 0, '0', '255', '0', '', 83),
[158] Fix | Delete
(63, 6, 1, '', 'Apparelsize', 'Apparel size', 'Value which is necessary for exporting products to the Google Merchant Center.For more information see http://www.google.com/support/merchants/', 'custom', 0, '0', '255', '0', '', 84),
[159] Fix | Delete
(64, 6, 1, '', 'Apparelcolor', 'Apparel color', 'Value which is necessary for exporting products to the Google Merchant Center.For more information see http://www.google.com/support/merchants/', 'custom', 0, '0', '255', '0', '', 85),
[160] Fix | Delete
(25, 7, 9, '', 'CustomerReviews', 'PRD_CUSTOMER_REVIEWS_NAME', 'PRD_CUSTOMER_REVIEWS_DESCR', 'standard', 0, '0', '0', '0', 'N', 121),
[161] Fix | Delete
(26, 8, 10, '', 'MembershipVisibility', 'PRD_MEMBERSHIP_VISIBILITY_NAME', 'PRD_MEMBERSHIP_VISIBILITY_DESCR', 'standard', 0, '0', '0', '0', 'N', 132),
[162] Fix | Delete
(32, 6, 1, '', 'Author', 'Author(s)', 'The author of a Book or a group of authors', 'custom', NULL, '2', '255', '70', NULL, 2),
[163] Fix | Delete
(33, 6, 1, '', 'Language', 'Language', 'The language of a book', 'custom', NULL, '2', '255', '70', NULL, 3),
[164] Fix | Delete
(34, 6, 1, '', 'Pages', 'Number of Pages', 'Number of Pages', 'custom', NULL, '2', '255', '70', NULL, 4),
[165] Fix | Delete
(35, 6, 1, '', 'Publicationyear', 'Year of Publication', 'The date when book had been published', 'custom', NULL, '2', '255', '70', NULL, 5),
[166] Fix | Delete
(36, 6, 1, '', 'Releasedate', 'Release Date', 'The date (year) when the CD/DVD was released', 'custom', NULL, '2', '255', '70', NULL, 1),
[167] Fix | Delete
(37, 6, 1, '', 'Recordlabel', 'Record Label', 'Record Company label', 'custom', NULL, '2', '255', '70', NULL, 2),
[168] Fix | Delete
(38, 6, 1, '', 'Numberofdisks', 'Number of Disks', 'Number of disks in the product', 'custom', NULL, '2', '255', '70', NULL, 3),
[169] Fix | Delete
(78, 6, 1, '', 'gc_from', 'From', 'From GC Attribute', 'custom', 0, '2', '255', '70', 'N', 1),
[170] Fix | Delete
(79, 6, 1, '', 'gc_to', 'To', 'To GC Attr', 'custom', 0, '2', '255', '70', 'N', 2),
[171] Fix | Delete
(80, 6, 2, '', 'gc_message', 'Message', 'Message GC Attribute', 'custom', 1, '2', '255', '70', 'N', 3),
[172] Fix | Delete
(81, 6, 1, '', 'gc_email', 'Email', 'Email GC Attribute', 'custom', 0, '2', '255', '70', 'N', 4),
[173] Fix | Delete
(82, 6, 1, '', 'gc_fname', 'First Name', 'First Name GC Attribute', 'custom', 0, '2', '255', '70', 'N', 5),
[174] Fix | Delete
(83, 6, 1, '', 'gc_lname', 'Last Name', 'Last Name GC Atribute', 'custom', 0, '2', '255', '70', 'N', 6),
[175] Fix | Delete
(84, 6, 1, '', 'gc_country_id', 'Country', 'Country GC Attribute', 'custom', 0, '2', '255', '70', 'N', 7),
[176] Fix | Delete
(85, 6, 1, '', 'gc_state_id', 'State', 'State GC Attribute', 'custom', 0, '2', '255', '70', 'N', 8),
[177] Fix | Delete
(86, 6, 1, '', 'gc_city', 'City', 'City GC Attribute', 'custom', 0, '2', '255', '70', 'N', 9),
[178] Fix | Delete
(87, 6, 1, '', 'gc_zip', 'ZipCode', 'ZipCode GC Attribute', 'custom', 0, '2', '255', '70', 'N', 10),
[179] Fix | Delete
(88, 6, 1, '', 'gc_address', 'Address', 'Address GC Attribute', 'custom', 0, '2', '255', '70', 'N', 11),
[180] Fix | Delete
(89, 6, 1, '', 'gc_phone', 'Phone', 'Phone GC Attribute', 'custom', 0, '2', '255', '70', 'N', 12),
[181] Fix | Delete
(90, 6, 1, '', 'gc_sendtype', 'SendType', 'GC Send Type attribute (email or snail mail)', 'custom', 0, '2', '255', '70', 'N', 13);
[182] Fix | Delete
[183] Fix | Delete
-- --------------------------------------------------------
[184] Fix | Delete
[185] Fix | Delete
--
[186] Fix | Delete
-- Table structure for table `[[dbprefix]]attribute_groups`
[187] Fix | Delete
--
[188] Fix | Delete
[189] Fix | Delete
CREATE TABLE `[[dbprefix]]attribute_groups` (
[190] Fix | Delete
`attribute_group_id` int(11) NOT NULL AUTO_INCREMENT,
[191] Fix | Delete
`attribute_group_name` varchar(255) DEFAULT NULL,
[192] Fix | Delete
`attribute_group_sort_order` int(11) DEFAULT NULL,
[193] Fix | Delete
PRIMARY KEY (`attribute_group_id`),
[194] Fix | Delete
KEY `IDX_agso` (`attribute_group_sort_order`)
[195] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
[196] Fix | Delete
[197] Fix | Delete
--
[198] Fix | Delete
-- Dumping data for table `[[dbprefix]]attribute_groups`
[199] Fix | Delete
--
[200] Fix | Delete
[201] Fix | Delete
INSERT INTO `[[dbprefix]]attribute_groups` VALUES
[202] Fix | Delete
(1, 'PT_ATTRGRP_001', 1),
[203] Fix | Delete
(2, 'PT_ATTRGRP_002', 2),
[204] Fix | Delete
(3, 'PT_ATTRGRP_003', 3),
[205] Fix | Delete
(4, 'PT_ATTRGRP_004', 4),
[206] Fix | Delete
(5, 'PT_ATTRGRP_005', 5),
[207] Fix | Delete
(6, 'PT_ATTRGRP_006', 8),
[208] Fix | Delete
(7, 'PT_ATTRGRP_007', 6),
[209] Fix | Delete
(8, 'PT_ATTRGRP_008', 7);
[210] Fix | Delete
[211] Fix | Delete
-- --------------------------------------------------------
[212] Fix | Delete
[213] Fix | Delete
--
[214] Fix | Delete
-- Table structure for table `[[dbprefix]]banners`
[215] Fix | Delete
--
[216] Fix | Delete
[217] Fix | Delete
CREATE TABLE `[[dbprefix]]banners` (
[218] Fix | Delete
`bannerid` int(11) NOT NULL AUTO_INCREMENT,
[219] Fix | Delete
`location` varchar(32) NOT NULL DEFAULT 'T',
[220] Fix | Delete
`width` int(11) NOT NULL DEFAULT '0',
[221] Fix | Delete
`height` int(11) NOT NULL DEFAULT '0',
[222] Fix | Delete
`order_by` int(11) NOT NULL DEFAULT '0',
[223] Fix | Delete
`start_date` varchar(255) NOT NULL DEFAULT '0',
[224] Fix | Delete
`end_date` varchar(255) NOT NULL DEFAULT '0',
[225] Fix | Delete
`effect` varchar(255) NOT NULL DEFAULT '',
[226] Fix | Delete
`pages` varchar(32) NOT NULL DEFAULT '',
[227] Fix | Delete
`nav` varchar(32) NOT NULL DEFAULT 'N',
[228] Fix | Delete
PRIMARY KEY (`bannerid`)
[229] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[230] Fix | Delete
[231] Fix | Delete
--
[232] Fix | Delete
-- Dumping data for table `[[dbprefix]]banners`
[233] Fix | Delete
--
[234] Fix | Delete
[235] Fix | Delete
INSERT INTO `[[dbprefix]]banners` VALUES
[236] Fix | Delete
(1, 'T', 6500, 500, 0, '1418857200', '1482101999', 'fade', '', '');
[237] Fix | Delete
[238] Fix | Delete
-- --------------------------------------------------------
[239] Fix | Delete
[240] Fix | Delete
--
[241] Fix | Delete
-- Table structure for table `[[dbprefix]]banners_html`
[242] Fix | Delete
--
[243] Fix | Delete
[244] Fix | Delete
CREATE TABLE `[[dbprefix]]banners_html` (
[245] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[246] Fix | Delete
`bannerid` int(11) NOT NULL DEFAULT '0',
[247] Fix | Delete
`code` longtext NOT NULL,
[248] Fix | Delete
`avail` varchar(1) NOT NULL DEFAULT 'Y',
[249] Fix | Delete
`order_by` int(11) NOT NULL DEFAULT '0',
[250] Fix | Delete
`type` varchar(1) NOT NULL DEFAULT '',
[251] Fix | Delete
PRIMARY KEY (`id`),
[252] Fix | Delete
KEY `IDX_bh` (`bannerid`)
[253] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[254] Fix | Delete
[255] Fix | Delete
-- --------------------------------------------------------
[256] Fix | Delete
[257] Fix | Delete
--
[258] Fix | Delete
-- Table structure for table `[[dbprefix]]banners_images`
[259] Fix | Delete
--
[260] Fix | Delete
[261] Fix | Delete
CREATE TABLE `[[dbprefix]]banners_images` (
[262] Fix | Delete
`imageid` int(11) NOT NULL AUTO_INCREMENT,
[263] Fix | Delete
`bannerid` int(11) NOT NULL DEFAULT '0',
[264] Fix | Delete
`image_path` varchar(255) NOT NULL DEFAULT '',
[265] Fix | Delete
`image_type` varchar(255) NOT NULL DEFAULT 'image/jpeg',
[266] Fix | Delete
`image_x` int(11) NOT NULL DEFAULT '0',
[267] Fix | Delete
`image_y` int(11) NOT NULL DEFAULT '0',
[268] Fix | Delete
`image_size` int(11) NOT NULL DEFAULT '0',
[269] Fix | Delete
`filename` varchar(255) NOT NULL DEFAULT '',
[270] Fix | Delete
`date` int(11) NOT NULL DEFAULT '0',
[271] Fix | Delete
`alt` varchar(255) NOT NULL DEFAULT '',
[272] Fix | Delete
`avail` varchar(1) NOT NULL DEFAULT 'Y',
[273] Fix | Delete
`order_by` int(11) NOT NULL DEFAULT '0',
[274] Fix | Delete
`url` varchar(255) NOT NULL DEFAULT '',
[275] Fix | Delete
`type` varchar(1) NOT NULL DEFAULT '',
[276] Fix | Delete
PRIMARY KEY (`imageid`),
[277] Fix | Delete
KEY `IDX_bi` (`bannerid`)
[278] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
[279] Fix | Delete
[280] Fix | Delete
--
[281] Fix | Delete
-- Dumping data for table `[[dbprefix]]banners_images`
[282] Fix | Delete
--
[283] Fix | Delete
[284] Fix | Delete
INSERT INTO `[[dbprefix]]banners_images` VALUES
[285] Fix | Delete
(1, 1, 'avactis-images/slide1.jpg', 'image/jpeg', 1500, 494, 126463, 'slide1.jpg', 2014, 'slider1', 'Y', 0, '', 'I'),
[286] Fix | Delete
(2, 1, 'avactis-images/bg.jpg', 'image/jpeg', 1500, 495, 306747, 'bg.jpg', 2014, 'slider2', 'Y', 0, '', 'I'),
[287] Fix | Delete
(3, 1, 'avactis-images/bg_2.jpg', 'image/jpeg', 1500, 495, 130058, 'bg_2.jpg', 2014, 'slider3', 'Y', 0, '', 'I');
[288] Fix | Delete
[289] Fix | Delete
-- --------------------------------------------------------
[290] Fix | Delete
[291] Fix | Delete
--
[292] Fix | Delete
-- Table structure for table `[[dbprefix]]banners_settings`
[293] Fix | Delete
--
[294] Fix | Delete
[295] Fix | Delete
CREATE TABLE `[[dbprefix]]banners_settings` (
[296] Fix | Delete
`setting_id` int(11) NOT NULL AUTO_INCREMENT,
[297] Fix | Delete
`setting_key` varchar(255) NOT NULL DEFAULT '',
[298] Fix | Delete
`setting_value` varchar(255) NOT NULL DEFAULT '',
[299] Fix | Delete
PRIMARY KEY (`setting_id`)
[300] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
[301] Fix | Delete
[302] Fix | Delete
--
[303] Fix | Delete
-- Dumping data for table `[[dbprefix]]banners_settings`
[304] Fix | Delete
--
[305] Fix | Delete
[306] Fix | Delete
INSERT INTO `[[dbprefix]]banners_settings` VALUES
[307] Fix | Delete
(1, 'TOP_BANNER_DEFAULT_WIDTH', '400'),
[308] Fix | Delete
(2, 'TOP_BANNER_DEFAULT_HEIGHT', '300'),
[309] Fix | Delete
(3, 'LEFT_BANNER_DEFAULT_WIDTH', '200'),
[310] Fix | Delete
(4, 'LEFT_BANNER_DEFAULT_HEIGHT', '200'),
[311] Fix | Delete
(5, 'BANNER_UNLIMITED_TIME', 'N'),
[312] Fix | Delete
(6, 'RIGHT_BANNER_DEFAULT_WIDTH', '200'),
[313] Fix | Delete
(7, 'RIGHT_BANNER_DEFAULT_HEIGHT', '200'),
[314] Fix | Delete
(8, 'BOTTOM_BANNER_DEFAULT_WIDTH', '400'),
[315] Fix | Delete
(9, 'BOTTOM_BANNER_DEFAULT_HEIGHT', '300');
[316] Fix | Delete
[317] Fix | Delete
-- --------------------------------------------------------
[318] Fix | Delete
[319] Fix | Delete
--
[320] Fix | Delete
-- Table structure for table `[[dbprefix]]blocktags_to_action`
[321] Fix | Delete
--
[322] Fix | Delete
[323] Fix | Delete
CREATE TABLE `[[dbprefix]]blocktags_to_action` (
[324] Fix | Delete
`blocktag_to_action_id` int(11) NOT NULL AUTO_INCREMENT,
[325] Fix | Delete
`notification_blocktag_id` int(11) DEFAULT NULL,
[326] Fix | Delete
`notification_action_id` int(11) DEFAULT NULL,
[327] Fix | Delete
PRIMARY KEY (`blocktag_to_action_id`),
[328] Fix | Delete
KEY `IDX_nb` (`notification_blocktag_id`),
[329] Fix | Delete
KEY `IDX_na` (`notification_action_id`)
[330] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
[331] Fix | Delete
[332] Fix | Delete
--
[333] Fix | Delete
-- Dumping data for table `[[dbprefix]]blocktags_to_action`
[334] Fix | Delete
--
[335] Fix | Delete
[336] Fix | Delete
INSERT INTO `[[dbprefix]]blocktags_to_action` VALUES
[337] Fix | Delete
(1, 1, 1),
[338] Fix | Delete
(2, 3, 1),
[339] Fix | Delete
(3, 1, 2),
[340] Fix | Delete
(4, 3, 2),
[341] Fix | Delete
(5, 1, 3),
[342] Fix | Delete
(6, 3, 3),
[343] Fix | Delete
(7, 2, 4),
[344] Fix | Delete
(8, 4, 5),
[345] Fix | Delete
(9, 5, 16),
[346] Fix | Delete
(10, 5, 17);
[347] Fix | Delete
[348] Fix | Delete
-- --------------------------------------------------------
[349] Fix | Delete
[350] Fix | Delete
--
[351] Fix | Delete
-- Table structure for table `[[dbprefix]]bs_links`
[352] Fix | Delete
--
[353] Fix | Delete
[354] Fix | Delete
CREATE TABLE `[[dbprefix]]bs_links` (
[355] Fix | Delete
`link_id` int(11) NOT NULL AUTO_INCREMENT,
[356] Fix | Delete
`category_id` int(11) NOT NULL DEFAULT '0',
[357] Fix | Delete
`bs_id` int(11) NOT NULL DEFAULT '0',
[358] Fix | Delete
`sort_order` int(11) NOT NULL DEFAULT '0',
[359] Fix | Delete
PRIMARY KEY (`link_id`),
[360] Fix | Delete
UNIQUE KEY `UNQ_cid_bs` (`category_id`,`bs_id`),
[361] Fix | Delete
KEY `IDX_cid` (`category_id`)
[362] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=262 ;
[363] Fix | Delete
[364] Fix | Delete
--
[365] Fix | Delete
-- Dumping data for table `[[dbprefix]]bs_links`
[366] Fix | Delete
--
[367] Fix | Delete
[368] Fix | Delete
INSERT INTO `[[dbprefix]]bs_links` VALUES
[369] Fix | Delete
(252, 12, 36, 2),
[370] Fix | Delete
(251, 12, 32, 1),
[371] Fix | Delete
(124, 35, 47, 3),
[372] Fix | Delete
(154, 9, 5, 6),
[373] Fix | Delete
(150, 9, 43, 2),
[374] Fix | Delete
(153, 9, 44, 5),
[375] Fix | Delete
(149, 9, 42, 1),
[376] Fix | Delete
(261, 1, 65, 8),
[377] Fix | Delete
(123, 35, 35, 2),
[378] Fix | Delete
(92, 24, 97, 3),
[379] Fix | Delete
(93, 24, 37, 4),
[380] Fix | Delete
(95, 24, 91, 6),
[381] Fix | Delete
(91, 24, 108, 2),
[382] Fix | Delete
(41, 38, 65, 1),
[383] Fix | Delete
(42, 38, 63, 2),
[384] Fix | Delete
(43, 38, 71, 3),
[385] Fix | Delete
(260, 1, 156, 7),
[386] Fix | Delete
(127, 8, 31, 3),
[387] Fix | Delete
(125, 8, 28, 1),
[388] Fix | Delete
(106, 11, 130, 1),
[389] Fix | Delete
(259, 1, 102, 6),
[390] Fix | Delete
(257, 1, 138, 4),
[391] Fix | Delete
(256, 1, 130, 3),
[392] Fix | Delete
(254, 1, 121, 1),
[393] Fix | Delete
(145, 21, 18, 1),
[394] Fix | Delete
(143, 20, 8, 1),
[395] Fix | Delete
(147, 21, 15, 3),
[396] Fix | Delete
(148, 21, 31, 4),
[397] Fix | Delete
(160, 39, 122, 1),
[398] Fix | Delete
(163, 13, 81, 1),
[399] Fix | Delete
(162, 39, 23, 3),
[400] Fix | Delete
(164, 13, 5, 2),
[401] Fix | Delete
(165, 13, 121, 3),
[402] Fix | Delete
(167, 14, 23, 2),
[403] Fix | Delete
(168, 14, 19, 3),
[404] Fix | Delete
(169, 15, 118, 1),
[405] Fix | Delete
(170, 15, 9, 2),
[406] Fix | Delete
(171, 15, 119, 3),
[407] Fix | Delete
(181, 25, 106, 2),
[408] Fix | Delete
(183, 26, 104, 1),
[409] Fix | Delete
(184, 26, 99, 2),
[410] Fix | Delete
(185, 26, 105, 3),
[411] Fix | Delete
(186, 27, 97, 1),
[412] Fix | Delete
(188, 27, 91, 3),
[413] Fix | Delete
(189, 28, 89, 1),
[414] Fix | Delete
(192, 40, 49, 1),
[415] Fix | Delete
(193, 40, 51, 2),
[416] Fix | Delete
(194, 40, 48, 3),
[417] Fix | Delete
(200, 41, 58, 3),
[418] Fix | Delete
(204, 42, 63, 1),
[419] Fix | Delete
(205, 42, 71, 2),
[420] Fix | Delete
(210, 43, 70, 1),
[421] Fix | Delete
(211, 43, 68, 2),
[422] Fix | Delete
(212, 43, 67, 3),
[423] Fix | Delete
(222, 10, 158, 1),
[424] Fix | Delete
(223, 10, 102, 2),
[425] Fix | Delete
(225, 10, 149, 4),
[426] Fix | Delete
(226, 10, 136, 5),
[427] Fix | Delete
(224, 10, 156, 3),
[428] Fix | Delete
(231, 29, 102, 1),
[429] Fix | Delete
(235, 30, 135, 1),
[430] Fix | Delete
(236, 30, 136, 2),
[431] Fix | Delete
(237, 30, 137, 3),
[432] Fix | Delete
(240, 16, 152, 3),
[433] Fix | Delete
(241, 32, 155, 1),
[434] Fix | Delete
(242, 32, 156, 2),
[435] Fix | Delete
(243, 32, 158, 3),
[436] Fix | Delete
(248, 33, 161, 2),
[437] Fix | Delete
(247, 33, 138, 1),
[438] Fix | Delete
(250, 33, 169, 4),
[439] Fix | Delete
(253, 12, 33, 3);
[440] Fix | Delete
[441] Fix | Delete
-- --------------------------------------------------------
[442] Fix | Delete
[443] Fix | Delete
--
[444] Fix | Delete
-- Table structure for table `[[dbprefix]]bs_settings`
[445] Fix | Delete
--
[446] Fix | Delete
[447] Fix | Delete
CREATE TABLE `[[dbprefix]]bs_settings` (
[448] Fix | Delete
`setting_id` int(11) NOT NULL AUTO_INCREMENT,
[449] Fix | Delete
`category_id` int(11) NOT NULL DEFAULT '0',
[450] Fix | Delete
`setting_key` varchar(255) NOT NULL DEFAULT '',
[451] Fix | Delete
`setting_value` varchar(255) NOT NULL DEFAULT '',
[452] Fix | Delete
PRIMARY KEY (`setting_id`),
[453] Fix | Delete
UNIQUE KEY `UNQ_cid_skey` (`category_id`,`setting_key`),
[454] Fix | Delete
KEY `IDX_cid` (`category_id`)
[455] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=245 ;
[456] Fix | Delete
[457] Fix | Delete
--
[458] Fix | Delete
-- Dumping data for table `[[dbprefix]]bs_settings`
[459] Fix | Delete
--
[460] Fix | Delete
[461] Fix | Delete
INSERT INTO `[[dbprefix]]bs_settings` VALUES
[462] Fix | Delete
(237, 12, 'ADD_BS_FROM_STAT', 'N'),
[463] Fix | Delete
(238, 12, 'BS_FROM_STAT_COUNT', '5'),
[464] Fix | Delete
(239, 12, 'BS_FROM_STAT_PERIOD', '2592000'),
[465] Fix | Delete
(240, 12, 'SHOW_RECURSIVELY', 'N'),
[466] Fix | Delete
(117, 9, 'ADD_BS_FROM_STAT', 'N'),
[467] Fix | Delete
(118, 9, 'BS_FROM_STAT_COUNT', '5'),
[468] Fix | Delete
(119, 9, 'BS_FROM_STAT_PERIOD', '2592000'),
[469] Fix | Delete
(120, 9, 'SHOW_RECURSIVELY', 'N'),
[470] Fix | Delete
(93, 35, 'ADD_BS_FROM_STAT', 'N'),
[471] Fix | Delete
(94, 35, 'BS_FROM_STAT_COUNT', '5'),
[472] Fix | Delete
(95, 35, 'BS_FROM_STAT_PERIOD', '2592000'),
[473] Fix | Delete
(96, 35, 'SHOW_RECURSIVELY', 'N'),
[474] Fix | Delete
(69, 24, 'ADD_BS_FROM_STAT', 'N'),
[475] Fix | Delete
(70, 24, 'BS_FROM_STAT_COUNT', '5'),
[476] Fix | Delete
(71, 24, 'BS_FROM_STAT_PERIOD', '2592000'),
[477] Fix | Delete
(72, 24, 'SHOW_RECURSIVELY', 'N'),
[478] Fix | Delete
(37, 38, 'ADD_BS_FROM_STAT', 'N'),
[479] Fix | Delete
(38, 38, 'BS_FROM_STAT_COUNT', '5'),
[480] Fix | Delete
(39, 38, 'BS_FROM_STAT_PERIOD', '2592000'),
[481] Fix | Delete
(40, 38, 'SHOW_RECURSIVELY', 'N'),
[482] Fix | Delete
(97, 8, 'ADD_BS_FROM_STAT', 'N'),
[483] Fix | Delete
(98, 8, 'BS_FROM_STAT_COUNT', '5'),
[484] Fix | Delete
(99, 8, 'BS_FROM_STAT_PERIOD', '2592000'),
[485] Fix | Delete
(100, 8, 'SHOW_RECURSIVELY', 'N'),
[486] Fix | Delete
(81, 11, 'ADD_BS_FROM_STAT', 'N'),
[487] Fix | Delete
(82, 11, 'BS_FROM_STAT_COUNT', '5'),
[488] Fix | Delete
(83, 11, 'BS_FROM_STAT_PERIOD', '2592000'),
[489] Fix | Delete
(84, 11, 'SHOW_RECURSIVELY', 'N'),
[490] Fix | Delete
(241, 1, 'ADD_BS_FROM_STAT', 'N'),
[491] Fix | Delete
(242, 1, 'BS_FROM_STAT_COUNT', '5'),
[492] Fix | Delete
(243, 1, 'BS_FROM_STAT_PERIOD', '2592000'),
[493] Fix | Delete
(244, 1, 'SHOW_RECURSIVELY', 'N'),
[494] Fix | Delete
(109, 20, 'ADD_BS_FROM_STAT', 'N'),
[495] Fix | Delete
(110, 20, 'BS_FROM_STAT_COUNT', '5'),
[496] Fix | Delete
(111, 20, 'BS_FROM_STAT_PERIOD', '2592000'),
[497] Fix | Delete
(112, 20, 'SHOW_RECURSIVELY', 'N'),
[498] Fix | Delete
(113, 21, 'ADD_BS_FROM_STAT', 'N'),
[499] Fix | Delete
123456...44
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function