Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../openx
• File: openx.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: `revive541`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]accounts`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]accounts` (
[20] Fix | Delete
`account_id` mediumint(9) NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`account_type` varchar(16) NOT NULL DEFAULT '',
[22] Fix | Delete
`account_name` varchar(255) DEFAULT NULL,
[23] Fix | Delete
PRIMARY KEY (`account_id`),
[24] Fix | Delete
KEY `[[dbprefix]]accounts_account_type` (`account_type`)
[25] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[26] Fix | Delete
[27] Fix | Delete
--
[28] Fix | Delete
-- Dumping data for table `[[dbprefix]]accounts`
[29] Fix | Delete
--
[30] Fix | Delete
[31] Fix | Delete
INSERT INTO `[[dbprefix]]accounts` VALUES
[32] Fix | Delete
(1, 'ADMIN', 'Administrator account'),
[33] Fix | Delete
(2, 'MANAGER', 'Default manager');
[34] Fix | Delete
[35] Fix | Delete
-- --------------------------------------------------------
[36] Fix | Delete
[37] Fix | Delete
--
[38] Fix | Delete
-- Table structure for table `[[dbprefix]]account_preference_assoc`
[39] Fix | Delete
--
[40] Fix | Delete
[41] Fix | Delete
CREATE TABLE `[[dbprefix]]account_preference_assoc` (
[42] Fix | Delete
`account_id` mediumint(9) NOT NULL,
[43] Fix | Delete
`preference_id` mediumint(9) NOT NULL,
[44] Fix | Delete
`value` text NOT NULL,
[45] Fix | Delete
PRIMARY KEY (`account_id`,`preference_id`)
[46] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[47] Fix | Delete
[48] Fix | Delete
--
[49] Fix | Delete
-- Dumping data for table `[[dbprefix]]account_preference_assoc`
[50] Fix | Delete
--
[51] Fix | Delete
[52] Fix | Delete
INSERT INTO `[[dbprefix]]account_preference_assoc` VALUES
[53] Fix | Delete
(1, 1, ''),
[54] Fix | Delete
(1, 2, ''),
[55] Fix | Delete
(1, 3, '1'),
[56] Fix | Delete
(1, 4, '1'),
[57] Fix | Delete
(1, 5, '1'),
[58] Fix | Delete
(1, 6, '100'),
[59] Fix | Delete
(1, 7, '1'),
[60] Fix | Delete
(1, 8, ''),
[61] Fix | Delete
(1, 9, ''),
[62] Fix | Delete
(1, 10, '1'),
[63] Fix | Delete
(1, 11, '100'),
[64] Fix | Delete
(1, 12, '1'),
[65] Fix | Delete
(1, 13, '1'),
[66] Fix | Delete
(1, 14, '100'),
[67] Fix | Delete
(1, 15, '1'),
[68] Fix | Delete
(1, 16, 'America/New_York'),
[69] Fix | Delete
(1, 17, '4'),
[70] Fix | Delete
(1, 18, '1'),
[71] Fix | Delete
(1, 19, ''),
[72] Fix | Delete
(1, 20, '1'),
[73] Fix | Delete
(1, 21, '1'),
[74] Fix | Delete
(1, 22, ''),
[75] Fix | Delete
(1, 23, ''),
[76] Fix | Delete
(1, 24, '1'),
[77] Fix | Delete
(1, 25, ''),
[78] Fix | Delete
(1, 26, ''),
[79] Fix | Delete
(1, 27, '1'),
[80] Fix | Delete
(1, 28, ''),
[81] Fix | Delete
(1, 29, ''),
[82] Fix | Delete
(1, 30, '1'),
[83] Fix | Delete
(1, 31, '1'),
[84] Fix | Delete
(1, 32, '2'),
[85] Fix | Delete
(1, 33, '1'),
[86] Fix | Delete
(1, 34, ''),
[87] Fix | Delete
(1, 35, '4'),
[88] Fix | Delete
(1, 36, ''),
[89] Fix | Delete
(1, 37, ''),
[90] Fix | Delete
(1, 38, '0'),
[91] Fix | Delete
(1, 39, ''),
[92] Fix | Delete
(1, 40, ''),
[93] Fix | Delete
(1, 41, '0'),
[94] Fix | Delete
(1, 42, ''),
[95] Fix | Delete
(1, 43, ''),
[96] Fix | Delete
(1, 44, '0'),
[97] Fix | Delete
(1, 45, ''),
[98] Fix | Delete
(1, 46, ''),
[99] Fix | Delete
(1, 47, '0'),
[100] Fix | Delete
(1, 48, ''),
[101] Fix | Delete
(1, 49, ''),
[102] Fix | Delete
(1, 50, '0'),
[103] Fix | Delete
(1, 51, ''),
[104] Fix | Delete
(1, 52, ''),
[105] Fix | Delete
(1, 53, '0'),
[106] Fix | Delete
(1, 54, ''),
[107] Fix | Delete
(1, 55, ''),
[108] Fix | Delete
(1, 56, '0'),
[109] Fix | Delete
(1, 57, ''),
[110] Fix | Delete
(1, 58, ''),
[111] Fix | Delete
(1, 59, '0'),
[112] Fix | Delete
(1, 60, ''),
[113] Fix | Delete
(1, 61, ''),
[114] Fix | Delete
(1, 62, '0'),
[115] Fix | Delete
(1, 63, '1'),
[116] Fix | Delete
(1, 64, ''),
[117] Fix | Delete
(1, 65, '5'),
[118] Fix | Delete
(1, 66, ''),
[119] Fix | Delete
(1, 67, ''),
[120] Fix | Delete
(1, 68, '0'),
[121] Fix | Delete
(1, 69, ''),
[122] Fix | Delete
(1, 70, ''),
[123] Fix | Delete
(1, 71, '0'),
[124] Fix | Delete
(1, 72, ''),
[125] Fix | Delete
(1, 73, ''),
[126] Fix | Delete
(1, 74, '0'),
[127] Fix | Delete
(1, 75, ''),
[128] Fix | Delete
(1, 76, ''),
[129] Fix | Delete
(1, 77, '0'),
[130] Fix | Delete
(1, 78, '1'),
[131] Fix | Delete
(1, 79, ''),
[132] Fix | Delete
(1, 80, '1'),
[133] Fix | Delete
(1, 81, '1'),
[134] Fix | Delete
(1, 82, ''),
[135] Fix | Delete
(1, 83, '2'),
[136] Fix | Delete
(1, 84, '1'),
[137] Fix | Delete
(1, 85, ''),
[138] Fix | Delete
(1, 86, '3'),
[139] Fix | Delete
(1, 87, ''),
[140] Fix | Delete
(1, 88, ''),
[141] Fix | Delete
(1, 89, '0'),
[142] Fix | Delete
(1, 90, ''),
[143] Fix | Delete
(1, 91, ''),
[144] Fix | Delete
(1, 92, '0'),
[145] Fix | Delete
(1, 93, ''),
[146] Fix | Delete
(1, 94, ''),
[147] Fix | Delete
(1, 95, '0'),
[148] Fix | Delete
(1, 96, ''),
[149] Fix | Delete
(1, 97, ''),
[150] Fix | Delete
(1, 98, '0');
[151] Fix | Delete
[152] Fix | Delete
-- --------------------------------------------------------
[153] Fix | Delete
[154] Fix | Delete
--
[155] Fix | Delete
-- Table structure for table `[[dbprefix]]account_user_assoc`
[156] Fix | Delete
--
[157] Fix | Delete
[158] Fix | Delete
CREATE TABLE `[[dbprefix]]account_user_assoc` (
[159] Fix | Delete
`account_id` mediumint(9) NOT NULL,
[160] Fix | Delete
`user_id` mediumint(9) NOT NULL,
[161] Fix | Delete
`linked` datetime NOT NULL,
[162] Fix | Delete
PRIMARY KEY (`account_id`,`user_id`),
[163] Fix | Delete
KEY `[[dbprefix]]account_user_assoc_user_id` (`user_id`)
[164] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[165] Fix | Delete
[166] Fix | Delete
--
[167] Fix | Delete
-- Dumping data for table `[[dbprefix]]account_user_assoc`
[168] Fix | Delete
--
[169] Fix | Delete
[170] Fix | Delete
INSERT INTO `[[dbprefix]]account_user_assoc` VALUES
[171] Fix | Delete
(1, 1, '[[regtime]]'),
[172] Fix | Delete
(2, 1, '[[regtime]]');
[173] Fix | Delete
[174] Fix | Delete
-- --------------------------------------------------------
[175] Fix | Delete
[176] Fix | Delete
--
[177] Fix | Delete
-- Table structure for table `[[dbprefix]]account_user_permission_assoc`
[178] Fix | Delete
--
[179] Fix | Delete
[180] Fix | Delete
CREATE TABLE `[[dbprefix]]account_user_permission_assoc` (
[181] Fix | Delete
`account_id` mediumint(9) NOT NULL,
[182] Fix | Delete
`user_id` mediumint(9) NOT NULL,
[183] Fix | Delete
`permission_id` mediumint(9) NOT NULL,
[184] Fix | Delete
`is_allowed` tinyint(1) NOT NULL DEFAULT '1',
[185] Fix | Delete
PRIMARY KEY (`account_id`,`user_id`,`permission_id`)
[186] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[187] Fix | Delete
[188] Fix | Delete
-- --------------------------------------------------------
[189] Fix | Delete
[190] Fix | Delete
--
[191] Fix | Delete
-- Table structure for table `[[dbprefix]]acls`
[192] Fix | Delete
--
[193] Fix | Delete
[194] Fix | Delete
CREATE TABLE `[[dbprefix]]acls` (
[195] Fix | Delete
`bannerid` mediumint(9) NOT NULL DEFAULT '0',
[196] Fix | Delete
`logical` varchar(3) NOT NULL DEFAULT 'and',
[197] Fix | Delete
`type` varchar(255) NOT NULL DEFAULT '',
[198] Fix | Delete
`comparison` char(2) NOT NULL DEFAULT '==',
[199] Fix | Delete
`data` text NOT NULL,
[200] Fix | Delete
`executionorder` int(10) unsigned NOT NULL DEFAULT '0',
[201] Fix | Delete
UNIQUE KEY `[[dbprefix]]acls_bannerid_executionorder` (`bannerid`,`executionorder`),
[202] Fix | Delete
KEY `[[dbprefix]]acls_bannerid` (`bannerid`)
[203] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[204] Fix | Delete
[205] Fix | Delete
-- --------------------------------------------------------
[206] Fix | Delete
[207] Fix | Delete
--
[208] Fix | Delete
-- Table structure for table `[[dbprefix]]acls_channel`
[209] Fix | Delete
--
[210] Fix | Delete
[211] Fix | Delete
CREATE TABLE `[[dbprefix]]acls_channel` (
[212] Fix | Delete
`channelid` mediumint(9) NOT NULL DEFAULT '0',
[213] Fix | Delete
`logical` varchar(3) NOT NULL DEFAULT 'and',
[214] Fix | Delete
`type` varchar(255) NOT NULL DEFAULT '',
[215] Fix | Delete
`comparison` char(2) NOT NULL DEFAULT '==',
[216] Fix | Delete
`data` text NOT NULL,
[217] Fix | Delete
`executionorder` int(10) unsigned NOT NULL DEFAULT '0',
[218] Fix | Delete
UNIQUE KEY `[[dbprefix]]acls_channel_channelid_executionorder` (`channelid`,`executionorder`),
[219] Fix | Delete
KEY `[[dbprefix]]acls_channel_channelid` (`channelid`)
[220] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[221] Fix | Delete
[222] Fix | Delete
-- --------------------------------------------------------
[223] Fix | Delete
[224] Fix | Delete
--
[225] Fix | Delete
-- Table structure for table `[[dbprefix]]ad_category_assoc`
[226] Fix | Delete
--
[227] Fix | Delete
[228] Fix | Delete
CREATE TABLE `[[dbprefix]]ad_category_assoc` (
[229] Fix | Delete
`ad_category_assoc_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[230] Fix | Delete
`category_id` int(10) unsigned NOT NULL,
[231] Fix | Delete
`ad_id` int(10) unsigned NOT NULL,
[232] Fix | Delete
PRIMARY KEY (`ad_category_assoc_id`)
[233] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[234] Fix | Delete
[235] Fix | Delete
-- --------------------------------------------------------
[236] Fix | Delete
[237] Fix | Delete
--
[238] Fix | Delete
-- Table structure for table `[[dbprefix]]ad_zone_assoc`
[239] Fix | Delete
--
[240] Fix | Delete
[241] Fix | Delete
CREATE TABLE `[[dbprefix]]ad_zone_assoc` (
[242] Fix | Delete
`ad_zone_assoc_id` mediumint(9) NOT NULL AUTO_INCREMENT,
[243] Fix | Delete
`zone_id` mediumint(9) DEFAULT NULL,
[244] Fix | Delete
`ad_id` mediumint(9) DEFAULT NULL,
[245] Fix | Delete
`priority` double DEFAULT '0',
[246] Fix | Delete
`link_type` smallint(6) NOT NULL DEFAULT '1',
[247] Fix | Delete
`priority_factor` double DEFAULT '0',
[248] Fix | Delete
`to_be_delivered` tinyint(1) NOT NULL DEFAULT '1',
[249] Fix | Delete
PRIMARY KEY (`ad_zone_assoc_id`),
[250] Fix | Delete
KEY `[[dbprefix]]ad_zone_assoc_zone_id` (`zone_id`),
[251] Fix | Delete
KEY `[[dbprefix]]ad_zone_assoc_ad_id` (`ad_id`)
[252] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[253] Fix | Delete
[254] Fix | Delete
-- --------------------------------------------------------
[255] Fix | Delete
[256] Fix | Delete
--
[257] Fix | Delete
-- Table structure for table `[[dbprefix]]affiliates`
[258] Fix | Delete
--
[259] Fix | Delete
[260] Fix | Delete
CREATE TABLE `[[dbprefix]]affiliates` (
[261] Fix | Delete
`affiliateid` mediumint(9) NOT NULL AUTO_INCREMENT,
[262] Fix | Delete
`agencyid` mediumint(9) NOT NULL DEFAULT '0',
[263] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[264] Fix | Delete
`mnemonic` varchar(5) NOT NULL DEFAULT '',
[265] Fix | Delete
`comments` text,
[266] Fix | Delete
`contact` varchar(255) DEFAULT NULL,
[267] Fix | Delete
`email` varchar(64) NOT NULL DEFAULT '',
[268] Fix | Delete
`website` varchar(255) DEFAULT NULL,
[269] Fix | Delete
`updated` datetime NOT NULL,
[270] Fix | Delete
`oac_country_code` char(2) NOT NULL DEFAULT '',
[271] Fix | Delete
`oac_language_id` int(11) DEFAULT NULL,
[272] Fix | Delete
`oac_category_id` int(11) DEFAULT NULL,
[273] Fix | Delete
`account_id` mediumint(9) DEFAULT NULL,
[274] Fix | Delete
PRIMARY KEY (`affiliateid`),
[275] Fix | Delete
UNIQUE KEY `[[dbprefix]]affiliates_account_id` (`account_id`),
[276] Fix | Delete
KEY `[[dbprefix]]affiliates_agencyid` (`agencyid`)
[277] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[278] Fix | Delete
[279] Fix | Delete
-- --------------------------------------------------------
[280] Fix | Delete
[281] Fix | Delete
--
[282] Fix | Delete
-- Table structure for table `[[dbprefix]]affiliates_extra`
[283] Fix | Delete
--
[284] Fix | Delete
[285] Fix | Delete
CREATE TABLE `[[dbprefix]]affiliates_extra` (
[286] Fix | Delete
`affiliateid` mediumint(9) NOT NULL,
[287] Fix | Delete
`address` text,
[288] Fix | Delete
`city` varchar(255) DEFAULT NULL,
[289] Fix | Delete
`postcode` varchar(64) DEFAULT NULL,
[290] Fix | Delete
`country` varchar(255) DEFAULT NULL,
[291] Fix | Delete
`phone` varchar(64) DEFAULT NULL,
[292] Fix | Delete
`fax` varchar(64) DEFAULT NULL,
[293] Fix | Delete
`account_contact` varchar(255) DEFAULT NULL,
[294] Fix | Delete
`payee_name` varchar(255) DEFAULT NULL,
[295] Fix | Delete
`tax_id` varchar(64) DEFAULT NULL,
[296] Fix | Delete
`mode_of_payment` varchar(64) DEFAULT NULL,
[297] Fix | Delete
`currency` varchar(64) DEFAULT NULL,
[298] Fix | Delete
`unique_users` int(11) DEFAULT NULL,
[299] Fix | Delete
`unique_views` int(11) DEFAULT NULL,
[300] Fix | Delete
`page_rank` int(11) DEFAULT NULL,
[301] Fix | Delete
`category` varchar(255) DEFAULT NULL,
[302] Fix | Delete
`help_file` varchar(255) DEFAULT NULL,
[303] Fix | Delete
PRIMARY KEY (`affiliateid`)
[304] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[305] Fix | Delete
[306] Fix | Delete
-- --------------------------------------------------------
[307] Fix | Delete
[308] Fix | Delete
--
[309] Fix | Delete
-- Table structure for table `[[dbprefix]]agency`
[310] Fix | Delete
--
[311] Fix | Delete
[312] Fix | Delete
CREATE TABLE `[[dbprefix]]agency` (
[313] Fix | Delete
`agencyid` mediumint(9) NOT NULL AUTO_INCREMENT,
[314] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[315] Fix | Delete
`contact` varchar(255) DEFAULT NULL,
[316] Fix | Delete
`email` varchar(64) NOT NULL DEFAULT '',
[317] Fix | Delete
`logout_url` varchar(255) DEFAULT NULL,
[318] Fix | Delete
`updated` datetime NOT NULL,
[319] Fix | Delete
`account_id` mediumint(9) DEFAULT NULL,
[320] Fix | Delete
`status` smallint(6) NOT NULL DEFAULT '0',
[321] Fix | Delete
PRIMARY KEY (`agencyid`),
[322] Fix | Delete
UNIQUE KEY `[[dbprefix]]agency_account_id` (`account_id`)
[323] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[324] Fix | Delete
[325] Fix | Delete
--
[326] Fix | Delete
-- Dumping data for table `[[dbprefix]]agency`
[327] Fix | Delete
--
[328] Fix | Delete
[329] Fix | Delete
INSERT INTO `[[dbprefix]]agency` VALUES
[330] Fix | Delete
(1, 'Default manager', NULL, '[[admin_email]]', NULL, '[[regtime]]', 2, 0);
[331] Fix | Delete
[332] Fix | Delete
-- --------------------------------------------------------
[333] Fix | Delete
[334] Fix | Delete
--
[335] Fix | Delete
-- Table structure for table `[[dbprefix]]application_variable`
[336] Fix | Delete
--
[337] Fix | Delete
[338] Fix | Delete
CREATE TABLE `[[dbprefix]]application_variable` (
[339] Fix | Delete
`name` varchar(250) NOT NULL DEFAULT '',
[340] Fix | Delete
`value` text NOT NULL,
[341] Fix | Delete
PRIMARY KEY (`name`)
[342] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[343] Fix | Delete
[344] Fix | Delete
--
[345] Fix | Delete
-- Dumping data for table `[[dbprefix]]application_variable`
[346] Fix | Delete
--
[347] Fix | Delete
[348] Fix | Delete
INSERT INTO `[[dbprefix]]application_variable` VALUES
[349] Fix | Delete
('admin_account_id', '1'),
[350] Fix | Delete
('Client_version', '5.0.7'),
[351] Fix | Delete
('Geo_version', '5.0.7'),
[352] Fix | Delete
('oa_version', '5.4.1'),
[353] Fix | Delete
('oxCacheFile_version', '1.5.0'),
[354] Fix | Delete
('oxDeliveryDataPrepare_version', '1.5.0'),
[355] Fix | Delete
('oxHtml_version', '1.6.1'),
[356] Fix | Delete
('oxInvocationTags_version', '1.8.0'),
[357] Fix | Delete
('oxLogClick_version', '1.5.0'),
[358] Fix | Delete
('oxLogConversion_version', '1.5.0'),
[359] Fix | Delete
('oxLogImpression_version', '1.5.0'),
[360] Fix | Delete
('oxLogRequest_version', '1.5.0'),
[361] Fix | Delete
('oxLogVast_version', '1.13.5'),
[362] Fix | Delete
('oxMemcached_version', '1.5.0'),
[363] Fix | Delete
('oxReportsAdmin_version', '1.6.1'),
[364] Fix | Delete
('oxReportsStandard_version', '1.6.1'),
[365] Fix | Delete
('oxText_version', '1.6.1'),
[366] Fix | Delete
('rvMaxMindGeoIP2Maintenance_version', '1.1.1'),
[367] Fix | Delete
('rvMaxMindGeoIP2_version', '1.1.1'),
[368] Fix | Delete
('Site_version', '5.0.7'),
[369] Fix | Delete
('tables_core', '627'),
[370] Fix | Delete
('tables_oxDeliveryDataPrepare', '002'),
[371] Fix | Delete
('tables_vastbannertypehtml', '013'),
[372] Fix | Delete
('Time_version', '5.0.7'),
[373] Fix | Delete
('vastInlineBannerTypeHtml_version', '1.13.5'),
[374] Fix | Delete
('vastOverlayBannerTypeHtml_version', '1.13.5'),
[375] Fix | Delete
('vastServeVideoPlayer_version', '1.13.5'),
[376] Fix | Delete
('videoReport_version', '1.13.5');
[377] Fix | Delete
[378] Fix | Delete
-- --------------------------------------------------------
[379] Fix | Delete
[380] Fix | Delete
--
[381] Fix | Delete
-- Table structure for table `[[dbprefix]]audit`
[382] Fix | Delete
--
[383] Fix | Delete
[384] Fix | Delete
CREATE TABLE `[[dbprefix]]audit` (
[385] Fix | Delete
`auditid` mediumint(9) NOT NULL AUTO_INCREMENT,
[386] Fix | Delete
`actionid` mediumint(9) NOT NULL,
[387] Fix | Delete
`context` varchar(200) NOT NULL DEFAULT '',
[388] Fix | Delete
`contextid` mediumint(9) DEFAULT NULL,
[389] Fix | Delete
`parentid` mediumint(9) DEFAULT NULL,
[390] Fix | Delete
`details` text NOT NULL,
[391] Fix | Delete
`userid` mediumint(9) NOT NULL DEFAULT '0',
[392] Fix | Delete
`username` varchar(64) DEFAULT NULL,
[393] Fix | Delete
`usertype` tinyint(4) NOT NULL DEFAULT '0',
[394] Fix | Delete
`updated` datetime DEFAULT NULL,
[395] Fix | Delete
`account_id` mediumint(9) NOT NULL,
[396] Fix | Delete
`advertiser_account_id` mediumint(9) DEFAULT NULL,
[397] Fix | Delete
`website_account_id` mediumint(9) DEFAULT NULL,
[398] Fix | Delete
PRIMARY KEY (`auditid`),
[399] Fix | Delete
KEY `[[dbprefix]]audit_parentid_contextid` (`parentid`,`contextid`),
[400] Fix | Delete
KEY `[[dbprefix]]audit_updated` (`updated`),
[401] Fix | Delete
KEY `[[dbprefix]]audit_usertype` (`usertype`),
[402] Fix | Delete
KEY `[[dbprefix]]audit_username` (`username`),
[403] Fix | Delete
KEY `[[dbprefix]]audit_context_actionid` (`context`,`actionid`),
[404] Fix | Delete
KEY `[[dbprefix]]audit_account_id` (`account_id`),
[405] Fix | Delete
KEY `[[dbprefix]]audit_advertiser_account_id` (`advertiser_account_id`),
[406] Fix | Delete
KEY `[[dbprefix]]audit_website_account_id` (`website_account_id`)
[407] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=204 ;
[408] Fix | Delete
[409] Fix | Delete
--
[410] Fix | Delete
-- Dumping data for table `[[dbprefix]]audit`
[411] Fix | Delete
--
[412] Fix | Delete
[413] Fix | Delete
INSERT INTO `[[dbprefix]]audit` VALUES
[414] Fix | Delete
(1, 1, 'accounts', 1, NULL, 'a:4:{s:10:"account_id";i:1;s:12:"account_type";s:5:"ADMIN";s:12:"account_name";s:21:"Administrator account";s:8:"key_desc";s:21:"Administrator account";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[415] Fix | Delete
(2, 1, 'accounts', 2, NULL, 'a:4:{s:10:"account_id";i:2;s:12:"account_type";s:7:"MANAGER";s:12:"account_name";s:15:"Default manager";s:8:"key_desc";s:15:"Default manager";}', 0, 'Installer', 0, '[[regtime]]', 2, NULL, NULL),
[416] Fix | Delete
(3, 1, 'agency', 1, NULL, '[[agency_audit]]', 0, 'Installer', 0, '[[regtime]]', 2, NULL, NULL),
[417] Fix | Delete
(4, 1, 'users', 1, NULL, '[[user_audit]]', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[418] Fix | Delete
(5, 1, 'account_user_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:7:"user_id";i:1;s:6:"linked";s:19:"[[regtime]]";s:8:"key_desc";s:21:"Account #1 -> User #1";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[419] Fix | Delete
(6, 1, 'account_user_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:2;s:7:"user_id";i:1;s:6:"linked";s:19:"[[regtime]]";s:8:"key_desc";s:21:"Account #2 -> User #1";}', 0, 'Installer', 0, '[[regtime]]', 2, NULL, NULL),
[420] Fix | Delete
(7, 1, 'preferences', 1, NULL, 'a:4:{s:13:"preference_id";i:1;s:15:"preference_name";s:24:"default_banner_image_url";s:12:"account_type";s:10:"TRAFFICKER";s:8:"key_desc";s:24:"default_banner_image_url";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[421] Fix | Delete
(8, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:1;s:5:"value";s:0:"";s:8:"key_desc";s:27:"Account #1 -> Preference #1";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[422] Fix | Delete
(9, 1, 'preferences', 2, NULL, 'a:4:{s:13:"preference_id";i:2;s:15:"preference_name";s:30:"default_banner_destination_url";s:12:"account_type";s:10:"TRAFFICKER";s:8:"key_desc";s:30:"default_banner_destination_url";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[423] Fix | Delete
(10, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:2;s:5:"value";s:0:"";s:8:"key_desc";s:27:"Account #1 -> Preference #2";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[424] Fix | Delete
(11, 1, 'preferences', 3, NULL, 'a:4:{s:13:"preference_id";i:3;s:15:"preference_name";s:21:"default_banner_weight";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:21:"default_banner_weight";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[425] Fix | Delete
(12, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:3;s:5:"value";i:1;s:8:"key_desc";s:27:"Account #1 -> Preference #3";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[426] Fix | Delete
(13, 1, 'preferences', 4, NULL, 'a:4:{s:13:"preference_id";i:4;s:15:"preference_name";s:23:"default_campaign_weight";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:23:"default_campaign_weight";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[427] Fix | Delete
(14, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:4;s:5:"value";i:1;s:8:"key_desc";s:27:"Account #1 -> Preference #4";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[428] Fix | Delete
(15, 1, 'preferences', 5, NULL, 'a:4:{s:13:"preference_id";i:5;s:15:"preference_name";s:16:"warn_email_admin";s:12:"account_type";s:5:"ADMIN";s:8:"key_desc";s:16:"warn_email_admin";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[429] Fix | Delete
(16, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:5;s:5:"value";b:1;s:8:"key_desc";s:27:"Account #1 -> Preference #5";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[430] Fix | Delete
(17, 1, 'preferences', 6, NULL, 'a:4:{s:13:"preference_id";i:6;s:15:"preference_name";s:33:"warn_email_admin_impression_limit";s:12:"account_type";s:5:"ADMIN";s:8:"key_desc";s:33:"warn_email_admin_impression_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[431] Fix | Delete
(18, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:6;s:5:"value";i:100;s:8:"key_desc";s:27:"Account #1 -> Preference #6";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[432] Fix | Delete
(19, 1, 'preferences', 7, NULL, 'a:4:{s:13:"preference_id";i:7;s:15:"preference_name";s:26:"warn_email_admin_day_limit";s:12:"account_type";s:5:"ADMIN";s:8:"key_desc";s:26:"warn_email_admin_day_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[433] Fix | Delete
(20, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:7;s:5:"value";i:1;s:8:"key_desc";s:27:"Account #1 -> Preference #7";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[434] Fix | Delete
(21, 1, 'preferences', 8, NULL, 'a:4:{s:13:"preference_id";i:8;s:15:"preference_name";s:21:"campaign_ecpm_enabled";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:21:"campaign_ecpm_enabled";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[435] Fix | Delete
(22, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:8;s:5:"value";b:0;s:8:"key_desc";s:27:"Account #1 -> Preference #8";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[436] Fix | Delete
(23, 1, 'preferences', 9, NULL, 'a:4:{s:13:"preference_id";i:9;s:15:"preference_name";s:21:"contract_ecpm_enabled";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:21:"contract_ecpm_enabled";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[437] Fix | Delete
(24, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:9;s:5:"value";b:0;s:8:"key_desc";s:27:"Account #1 -> Preference #9";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[438] Fix | Delete
(25, 1, 'preferences', 10, NULL, 'a:4:{s:13:"preference_id";i:10;s:15:"preference_name";s:18:"warn_email_manager";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:18:"warn_email_manager";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[439] Fix | Delete
(26, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:10;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #10";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[440] Fix | Delete
(27, 1, 'preferences', 11, NULL, 'a:4:{s:13:"preference_id";i:11;s:15:"preference_name";s:35:"warn_email_manager_impression_limit";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:35:"warn_email_manager_impression_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[441] Fix | Delete
(28, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:11;s:5:"value";i:100;s:8:"key_desc";s:28:"Account #1 -> Preference #11";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[442] Fix | Delete
(29, 1, 'preferences', 12, NULL, 'a:4:{s:13:"preference_id";i:12;s:15:"preference_name";s:28:"warn_email_manager_day_limit";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:28:"warn_email_manager_day_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[443] Fix | Delete
(30, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:12;s:5:"value";i:1;s:8:"key_desc";s:28:"Account #1 -> Preference #12";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[444] Fix | Delete
(31, 1, 'preferences', 13, NULL, 'a:4:{s:13:"preference_id";i:13;s:15:"preference_name";s:21:"warn_email_advertiser";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:21:"warn_email_advertiser";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[445] Fix | Delete
(32, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:13;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #13";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[446] Fix | Delete
(33, 1, 'preferences', 14, NULL, 'a:4:{s:13:"preference_id";i:14;s:15:"preference_name";s:38:"warn_email_advertiser_impression_limit";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:38:"warn_email_advertiser_impression_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[447] Fix | Delete
(34, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:14;s:5:"value";i:100;s:8:"key_desc";s:28:"Account #1 -> Preference #14";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[448] Fix | Delete
(35, 1, 'preferences', 15, NULL, 'a:4:{s:13:"preference_id";i:15;s:15:"preference_name";s:31:"warn_email_advertiser_day_limit";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:31:"warn_email_advertiser_day_limit";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[449] Fix | Delete
(36, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:15;s:5:"value";i:1;s:8:"key_desc";s:28:"Account #1 -> Preference #15";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[450] Fix | Delete
(37, 1, 'preferences', 16, NULL, 'a:4:{s:13:"preference_id";i:16;s:15:"preference_name";s:8:"timezone";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:8:"timezone";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[451] Fix | Delete
(38, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:16;s:5:"value";s:0:"";s:8:"key_desc";s:28:"Account #1 -> Preference #16";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[452] Fix | Delete
(39, 1, 'preferences', 17, NULL, 'a:4:{s:13:"preference_id";i:17;s:15:"preference_name";s:22:"tracker_default_status";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:22:"tracker_default_status";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[453] Fix | Delete
(40, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:17;s:5:"value";i:4;s:8:"key_desc";s:28:"Account #1 -> Preference #17";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[454] Fix | Delete
(41, 1, 'preferences', 18, NULL, 'a:4:{s:13:"preference_id";i:18;s:15:"preference_name";s:20:"tracker_default_type";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:20:"tracker_default_type";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[455] Fix | Delete
(42, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:18;s:5:"value";i:1;s:8:"key_desc";s:28:"Account #1 -> Preference #18";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[456] Fix | Delete
(43, 1, 'preferences', 19, NULL, 'a:4:{s:13:"preference_id";i:19;s:15:"preference_name";s:22:"tracker_link_campaigns";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:22:"tracker_link_campaigns";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[457] Fix | Delete
(44, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:19;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #19";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[458] Fix | Delete
(45, 1, 'preferences', 20, NULL, 'a:4:{s:13:"preference_id";i:20;s:15:"preference_name";s:21:"ui_show_campaign_info";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:21:"ui_show_campaign_info";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[459] Fix | Delete
(46, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:20;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #20";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[460] Fix | Delete
(47, 1, 'preferences', 21, NULL, 'a:4:{s:13:"preference_id";i:21;s:15:"preference_name";s:19:"ui_show_banner_info";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:19:"ui_show_banner_info";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[461] Fix | Delete
(48, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:21;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #21";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[462] Fix | Delete
(49, 1, 'preferences', 22, NULL, 'a:4:{s:13:"preference_id";i:22;s:15:"preference_name";s:24:"ui_show_campaign_preview";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:24:"ui_show_campaign_preview";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[463] Fix | Delete
(50, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:22;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #22";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[464] Fix | Delete
(51, 1, 'preferences', 23, NULL, 'a:4:{s:13:"preference_id";i:23;s:15:"preference_name";s:19:"ui_show_banner_html";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:19:"ui_show_banner_html";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[465] Fix | Delete
(52, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:23;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #23";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[466] Fix | Delete
(53, 1, 'preferences', 24, NULL, 'a:4:{s:13:"preference_id";i:24;s:15:"preference_name";s:22:"ui_show_banner_preview";s:12:"account_type";s:10:"ADVERTISER";s:8:"key_desc";s:22:"ui_show_banner_preview";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[467] Fix | Delete
(54, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:24;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #24";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[468] Fix | Delete
(55, 1, 'preferences', 25, NULL, 'a:4:{s:13:"preference_id";i:25;s:15:"preference_name";s:22:"ui_html_wyswyg_enabled";s:12:"account_type";s:0:"";s:8:"key_desc";s:22:"ui_html_wyswyg_enabled";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[469] Fix | Delete
(56, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:25;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #25";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[470] Fix | Delete
(57, 1, 'preferences', 26, NULL, 'a:4:{s:13:"preference_id";i:26;s:15:"preference_name";s:16:"ui_hide_inactive";s:12:"account_type";s:0:"";s:8:"key_desc";s:16:"ui_hide_inactive";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[471] Fix | Delete
(58, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:26;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #26";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[472] Fix | Delete
(59, 1, 'preferences', 27, NULL, 'a:4:{s:13:"preference_id";i:27;s:15:"preference_name";s:24:"ui_show_matching_banners";s:12:"account_type";s:10:"TRAFFICKER";s:8:"key_desc";s:24:"ui_show_matching_banners";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[473] Fix | Delete
(60, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:27;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #27";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[474] Fix | Delete
(61, 1, 'preferences', 28, NULL, 'a:4:{s:13:"preference_id";i:28;s:15:"preference_name";s:32:"ui_show_matching_banners_parents";s:12:"account_type";s:10:"TRAFFICKER";s:8:"key_desc";s:32:"ui_show_matching_banners_parents";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[475] Fix | Delete
(62, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:28;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #28";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[476] Fix | Delete
(63, 1, 'preferences', 29, NULL, 'a:4:{s:13:"preference_id";i:29;s:15:"preference_name";s:17:"ui_show_entity_id";s:12:"account_type";s:0:"";s:8:"key_desc";s:17:"ui_show_entity_id";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[477] Fix | Delete
(64, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:29;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #29";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[478] Fix | Delete
(65, 1, 'preferences', 30, NULL, 'a:4:{s:13:"preference_id";i:30;s:15:"preference_name";s:14:"ui_novice_user";s:12:"account_type";s:0:"";s:8:"key_desc";s:14:"ui_novice_user";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[479] Fix | Delete
(66, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:30;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #30";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[480] Fix | Delete
(67, 1, 'preferences', 31, NULL, 'a:4:{s:13:"preference_id";i:31;s:15:"preference_name";s:17:"ui_week_start_day";s:12:"account_type";s:0:"";s:8:"key_desc";s:17:"ui_week_start_day";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[481] Fix | Delete
(68, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:31;s:5:"value";i:1;s:8:"key_desc";s:28:"Account #1 -> Preference #31";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[482] Fix | Delete
(69, 1, 'preferences', 32, NULL, 'a:4:{s:13:"preference_id";i:32;s:15:"preference_name";s:22:"ui_percentage_decimals";s:12:"account_type";s:0:"";s:8:"key_desc";s:22:"ui_percentage_decimals";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[483] Fix | Delete
(70, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:32;s:5:"value";i:2;s:8:"key_desc";s:28:"Account #1 -> Preference #32";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[484] Fix | Delete
(71, 1, 'preferences', 33, NULL, 'a:4:{s:13:"preference_id";i:33;s:15:"preference_name";s:17:"ui_column_revenue";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:17:"ui_column_revenue";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[485] Fix | Delete
(72, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:33;s:5:"value";b:1;s:8:"key_desc";s:28:"Account #1 -> Preference #33";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[486] Fix | Delete
(73, 1, 'preferences', 34, NULL, 'a:4:{s:13:"preference_id";i:34;s:15:"preference_name";s:23:"ui_column_revenue_label";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:23:"ui_column_revenue_label";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[487] Fix | Delete
(74, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:34;s:5:"value";s:0:"";s:8:"key_desc";s:28:"Account #1 -> Preference #34";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[488] Fix | Delete
(75, 1, 'preferences', 35, NULL, 'a:4:{s:13:"preference_id";i:35;s:15:"preference_name";s:22:"ui_column_revenue_rank";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:22:"ui_column_revenue_rank";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[489] Fix | Delete
(76, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:35;s:5:"value";i:4;s:8:"key_desc";s:28:"Account #1 -> Preference #35";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[490] Fix | Delete
(77, 1, 'preferences', 36, NULL, 'a:4:{s:13:"preference_id";i:36;s:15:"preference_name";s:12:"ui_column_bv";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:12:"ui_column_bv";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[491] Fix | Delete
(78, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:36;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #36";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[492] Fix | Delete
(79, 1, 'preferences', 37, NULL, 'a:4:{s:13:"preference_id";i:37;s:15:"preference_name";s:18:"ui_column_bv_label";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:18:"ui_column_bv_label";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[493] Fix | Delete
(80, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:37;s:5:"value";s:0:"";s:8:"key_desc";s:28:"Account #1 -> Preference #37";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[494] Fix | Delete
(81, 1, 'preferences', 38, NULL, 'a:4:{s:13:"preference_id";i:38;s:15:"preference_name";s:17:"ui_column_bv_rank";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:17:"ui_column_bv_rank";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[495] Fix | Delete
(82, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:38;s:5:"value";i:0;s:8:"key_desc";s:28:"Account #1 -> Preference #38";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[496] Fix | Delete
(83, 1, 'preferences', 39, NULL, 'a:4:{s:13:"preference_id";i:39;s:15:"preference_name";s:19:"ui_column_num_items";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:19:"ui_column_num_items";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[497] Fix | Delete
(84, 1, 'account_preference_assoc', 0, NULL, 'a:4:{s:10:"account_id";i:1;s:13:"preference_id";i:39;s:5:"value";b:0;s:8:"key_desc";s:28:"Account #1 -> Preference #39";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[498] Fix | Delete
(85, 1, 'preferences', 40, NULL, 'a:4:{s:13:"preference_id";i:40;s:15:"preference_name";s:25:"ui_column_num_items_label";s:12:"account_type";s:7:"MANAGER";s:8:"key_desc";s:25:"ui_column_num_items_label";}', 0, 'Installer', 0, '[[regtime]]', 1, NULL, NULL),
[499] Fix | Delete
1234
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function