Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/AnonR/smanonr..../var/softacul.../boxbill
• File: boxbill.sql
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[0] Fix | Delete
SET time_zone = "+00:00";
[1] Fix | Delete
[2] Fix | Delete
[3] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[5] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[6] Fix | Delete
/*!40101 SET NAMES utf8 */;
[7] Fix | Delete
[8] Fix | Delete
--
[9] Fix | Delete
-- Database: `box421`
[10] Fix | Delete
--
[11] Fix | Delete
[12] Fix | Delete
-- --------------------------------------------------------
[13] Fix | Delete
[14] Fix | Delete
--
[15] Fix | Delete
-- Table structure for table `activity_admin_history`
[16] Fix | Delete
--
[17] Fix | Delete
[18] Fix | Delete
CREATE TABLE `activity_admin_history` (
[19] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[20] Fix | Delete
`admin_id` bigint(20) DEFAULT NULL,
[21] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[22] Fix | Delete
`created_at` datetime DEFAULT NULL,
[23] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[24] Fix | Delete
PRIMARY KEY (`id`),
[25] Fix | Delete
KEY `admin_id_idx` (`admin_id`)
[26] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[27] Fix | Delete
[28] Fix | Delete
-- --------------------------------------------------------
[29] Fix | Delete
[30] Fix | Delete
--
[31] Fix | Delete
-- Table structure for table `activity_client_email`
[32] Fix | Delete
--
[33] Fix | Delete
[34] Fix | Delete
CREATE TABLE `activity_client_email` (
[35] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[36] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[37] Fix | Delete
`sender` varchar(255) DEFAULT NULL,
[38] Fix | Delete
`recipients` text,
[39] Fix | Delete
`subject` varchar(255) DEFAULT NULL,
[40] Fix | Delete
`content_html` text,
[41] Fix | Delete
`content_text` text,
[42] Fix | Delete
`created_at` datetime DEFAULT NULL,
[43] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[44] Fix | Delete
PRIMARY KEY (`id`),
[45] Fix | Delete
KEY `client_id_idx` (`client_id`)
[46] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[47] Fix | Delete
[48] Fix | Delete
-- --------------------------------------------------------
[49] Fix | Delete
[50] Fix | Delete
--
[51] Fix | Delete
-- Table structure for table `activity_client_history`
[52] Fix | Delete
--
[53] Fix | Delete
[54] Fix | Delete
CREATE TABLE `activity_client_history` (
[55] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[56] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[57] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[58] Fix | Delete
`created_at` datetime DEFAULT NULL,
[59] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[60] Fix | Delete
PRIMARY KEY (`id`),
[61] Fix | Delete
KEY `client_id_idx` (`client_id`)
[62] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[63] Fix | Delete
[64] Fix | Delete
-- --------------------------------------------------------
[65] Fix | Delete
[66] Fix | Delete
--
[67] Fix | Delete
-- Table structure for table `activity_system`
[68] Fix | Delete
--
[69] Fix | Delete
[70] Fix | Delete
CREATE TABLE `activity_system` (
[71] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[72] Fix | Delete
`priority` tinyint(4) DEFAULT NULL,
[73] Fix | Delete
`admin_id` bigint(20) DEFAULT NULL,
[74] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[75] Fix | Delete
`message` text,
[76] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[77] Fix | Delete
`created_at` datetime DEFAULT NULL,
[78] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[79] Fix | Delete
PRIMARY KEY (`id`),
[80] Fix | Delete
KEY `admin_id_idx` (`admin_id`),
[81] Fix | Delete
KEY `client_id_idx` (`client_id`)
[82] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;
[83] Fix | Delete
[84] Fix | Delete
--
[85] Fix | Delete
-- Dumping data for table `activity_system`
[86] Fix | Delete
--
[87] Fix | Delete
[88] Fix | Delete
INSERT INTO `activity_system` VALUES
[89] Fix | Delete
(1, 6, NULL, NULL, 'Added new email template #1', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[90] Fix | Delete
(2, 6, NULL, NULL, 'Added new email template #2', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[91] Fix | Delete
(3, 6, NULL, NULL, 'Added new email template #3', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[92] Fix | Delete
(4, 6, NULL, NULL, 'Added new email template #4', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[93] Fix | Delete
(5, 6, NULL, NULL, 'Added new email template #5', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[94] Fix | Delete
(6, 6, NULL, NULL, 'Added new email template #6', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[95] Fix | Delete
(7, 6, NULL, NULL, 'Added new email template #7', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[96] Fix | Delete
(8, 6, NULL, NULL, 'Added new email template #8', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[97] Fix | Delete
(9, 6, NULL, NULL, 'Added new email template #9', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[98] Fix | Delete
(10, 6, NULL, NULL, 'Added new email template #10', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[99] Fix | Delete
(11, 6, NULL, NULL, 'Added new email template #11', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[100] Fix | Delete
(12, 6, NULL, NULL, 'Added new email template #12', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[101] Fix | Delete
(13, 6, NULL, NULL, 'Added new email template #13', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[102] Fix | Delete
(14, 6, NULL, NULL, 'Added new email template #14', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[103] Fix | Delete
(15, 6, NULL, NULL, 'Added new email template #15', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[104] Fix | Delete
(16, 6, NULL, NULL, 'Added new email template #16', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[105] Fix | Delete
(17, 6, NULL, NULL, 'Added new email template #17', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[106] Fix | Delete
(18, 6, NULL, NULL, 'Added new email template #18', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[107] Fix | Delete
(19, 6, NULL, NULL, 'Added new email template #19', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[108] Fix | Delete
(20, 6, NULL, NULL, 'Added new email template #20', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[109] Fix | Delete
(21, 6, NULL, NULL, 'Added new email template #21', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[110] Fix | Delete
(22, 6, NULL, NULL, 'Added new email template #22', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[111] Fix | Delete
(23, 6, NULL, NULL, 'Added new email template #23', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[112] Fix | Delete
(24, 6, NULL, NULL, 'Added new email template #24', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[113] Fix | Delete
(25, 6, NULL, NULL, 'Added new email template #25', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[114] Fix | Delete
(26, 6, NULL, NULL, 'Added new email template #26', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[115] Fix | Delete
(27, 6, NULL, NULL, 'Added new email template #27', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[116] Fix | Delete
(28, 6, NULL, NULL, 'Added new email template #28', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[117] Fix | Delete
(29, 6, NULL, NULL, 'Added new email template #29', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[118] Fix | Delete
(30, 6, NULL, NULL, 'Added new email template #30', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[119] Fix | Delete
(31, 6, NULL, NULL, 'Added new email template #31', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[120] Fix | Delete
(32, 6, NULL, NULL, 'Added new email template #32', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[121] Fix | Delete
(33, 6, NULL, NULL, 'Added new email template #33', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[122] Fix | Delete
(34, 6, NULL, NULL, 'Added new email template #34', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[123] Fix | Delete
(35, 6, NULL, NULL, 'Added new email template #35', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[124] Fix | Delete
(36, 6, NULL, NULL, 'Added new email template #36', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[125] Fix | Delete
(37, 6, NULL, NULL, 'Added new email template #37', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[126] Fix | Delete
(38, 6, NULL, NULL, 'Added new email template #38', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[127] Fix | Delete
(39, 6, NULL, NULL, 'Added new email template #39', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[128] Fix | Delete
(40, 6, NULL, NULL, 'Added new email template #40', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[129] Fix | Delete
(41, 6, NULL, NULL, 'Added new email template #41', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[130] Fix | Delete
(42, 6, NULL, NULL, 'Added new email template #42', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[131] Fix | Delete
(43, 6, NULL, NULL, 'Added new email template #43', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[132] Fix | Delete
(44, 6, NULL, NULL, 'Added new email template #44', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[133] Fix | Delete
(45, 6, NULL, NULL, 'Added new email template #45', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[134] Fix | Delete
(46, 6, NULL, NULL, 'Added new email template #46', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[135] Fix | Delete
(47, 6, NULL, NULL, 'Added new email template #47', '[[clientip]]', '[[datetime]]', '[[datetime]]'),
[136] Fix | Delete
(48, 6, NULL, NULL, 'Generated email templates for installed extensions', '[[clientip]]', '[[datetime]]', '[[datetime]]');
[137] Fix | Delete
[138] Fix | Delete
-- --------------------------------------------------------
[139] Fix | Delete
[140] Fix | Delete
--
[141] Fix | Delete
-- Table structure for table `admin`
[142] Fix | Delete
--
[143] Fix | Delete
[144] Fix | Delete
CREATE TABLE `admin` (
[145] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[146] Fix | Delete
`role` varchar(30) DEFAULT 'staff' COMMENT 'admin, staff',
[147] Fix | Delete
`admin_group_id` bigint(20) DEFAULT '1',
[148] Fix | Delete
`email` varchar(255) DEFAULT NULL,
[149] Fix | Delete
`pass` varchar(255) DEFAULT NULL,
[150] Fix | Delete
`salt` varchar(255) DEFAULT NULL,
[151] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[152] Fix | Delete
`signature` varchar(255) DEFAULT NULL,
[153] Fix | Delete
`protected` tinyint(1) DEFAULT '0',
[154] Fix | Delete
`status` varchar(30) DEFAULT 'active' COMMENT 'active, inactive',
[155] Fix | Delete
`api_token` varchar(128) DEFAULT NULL,
[156] Fix | Delete
`permissions` text,
[157] Fix | Delete
`created_at` datetime DEFAULT NULL,
[158] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[159] Fix | Delete
PRIMARY KEY (`id`),
[160] Fix | Delete
UNIQUE KEY `email` (`email`),
[161] Fix | Delete
KEY `admin_group_id_idx` (`admin_group_id`)
[162] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[163] Fix | Delete
[164] Fix | Delete
--
[165] Fix | Delete
-- Dumping data for table `admin`
[166] Fix | Delete
--
[167] Fix | Delete
[168] Fix | Delete
INSERT INTO `admin` VALUES
[169] Fix | Delete
(1, 'admin', 1, '[[admin_email]]', '[[admin_pass]]', NULL, '[[admin_realname]]', NULL, 1, 'active', NULL, NULL, '[[datetime]]', '[[datetime]]');
[170] Fix | Delete
[171] Fix | Delete
-- --------------------------------------------------------
[172] Fix | Delete
[173] Fix | Delete
--
[174] Fix | Delete
-- Table structure for table `admin_group`
[175] Fix | Delete
--
[176] Fix | Delete
[177] Fix | Delete
CREATE TABLE `admin_group` (
[178] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[179] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[180] Fix | Delete
`created_at` datetime DEFAULT NULL,
[181] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[182] Fix | Delete
PRIMARY KEY (`id`)
[183] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
[184] Fix | Delete
[185] Fix | Delete
--
[186] Fix | Delete
-- Dumping data for table `admin_group`
[187] Fix | Delete
--
[188] Fix | Delete
[189] Fix | Delete
INSERT INTO `admin_group` VALUES
[190] Fix | Delete
(1, 'Administrators', '2012-01-01 12:00:00', '2012-01-01 12:00:00'),
[191] Fix | Delete
(2, 'Support', '2012-01-01 12:00:00', '2012-01-01 12:00:00');
[192] Fix | Delete
[193] Fix | Delete
-- --------------------------------------------------------
[194] Fix | Delete
[195] Fix | Delete
--
[196] Fix | Delete
-- Table structure for table `api_request`
[197] Fix | Delete
--
[198] Fix | Delete
[199] Fix | Delete
CREATE TABLE `api_request` (
[200] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[201] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[202] Fix | Delete
`request` text,
[203] Fix | Delete
`created_at` datetime DEFAULT NULL,
[204] Fix | Delete
PRIMARY KEY (`id`)
[205] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[206] Fix | Delete
[207] Fix | Delete
-- --------------------------------------------------------
[208] Fix | Delete
[209] Fix | Delete
--
[210] Fix | Delete
-- Table structure for table `cart`
[211] Fix | Delete
--
[212] Fix | Delete
[213] Fix | Delete
CREATE TABLE `cart` (
[214] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[215] Fix | Delete
`session_id` varchar(32) DEFAULT NULL,
[216] Fix | Delete
`currency_id` bigint(20) DEFAULT NULL,
[217] Fix | Delete
`promo_id` bigint(20) DEFAULT NULL,
[218] Fix | Delete
`created_at` datetime DEFAULT NULL,
[219] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[220] Fix | Delete
PRIMARY KEY (`id`),
[221] Fix | Delete
KEY `session_id_idx` (`session_id`),
[222] Fix | Delete
KEY `currency_id_idx` (`currency_id`),
[223] Fix | Delete
KEY `promo_id_idx` (`promo_id`)
[224] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[225] Fix | Delete
[226] Fix | Delete
-- --------------------------------------------------------
[227] Fix | Delete
[228] Fix | Delete
--
[229] Fix | Delete
-- Table structure for table `cart_product`
[230] Fix | Delete
--
[231] Fix | Delete
[232] Fix | Delete
CREATE TABLE `cart_product` (
[233] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[234] Fix | Delete
`cart_id` bigint(20) DEFAULT NULL,
[235] Fix | Delete
`product_id` bigint(20) DEFAULT NULL,
[236] Fix | Delete
`config` text,
[237] Fix | Delete
PRIMARY KEY (`id`),
[238] Fix | Delete
KEY `cart_id_idx` (`cart_id`),
[239] Fix | Delete
KEY `product_id_idx` (`product_id`)
[240] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[241] Fix | Delete
[242] Fix | Delete
-- --------------------------------------------------------
[243] Fix | Delete
[244] Fix | Delete
--
[245] Fix | Delete
-- Table structure for table `client`
[246] Fix | Delete
--
[247] Fix | Delete
[248] Fix | Delete
CREATE TABLE `client` (
[249] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[250] Fix | Delete
`aid` varchar(255) DEFAULT NULL COMMENT 'Alternative id for foreign systems',
[251] Fix | Delete
`client_group_id` bigint(20) DEFAULT NULL,
[252] Fix | Delete
`role` varchar(30) NOT NULL DEFAULT 'client' COMMENT 'client',
[253] Fix | Delete
`auth_type` varchar(255) DEFAULT NULL,
[254] Fix | Delete
`email` varchar(255) DEFAULT NULL,
[255] Fix | Delete
`pass` varchar(255) DEFAULT NULL,
[256] Fix | Delete
`salt` varchar(255) DEFAULT NULL,
[257] Fix | Delete
`status` varchar(30) DEFAULT 'active' COMMENT 'active, suspended, canceled',
[258] Fix | Delete
`email_approved` tinyint(1) DEFAULT NULL,
[259] Fix | Delete
`tax_exempt` tinyint(1) DEFAULT '0',
[260] Fix | Delete
`type` varchar(100) DEFAULT NULL,
[261] Fix | Delete
`first_name` varchar(100) DEFAULT NULL,
[262] Fix | Delete
`last_name` varchar(100) DEFAULT NULL,
[263] Fix | Delete
`gender` varchar(20) DEFAULT NULL,
[264] Fix | Delete
`birthday` date DEFAULT NULL,
[265] Fix | Delete
`phone_cc` varchar(10) DEFAULT NULL,
[266] Fix | Delete
`phone` varchar(100) DEFAULT NULL,
[267] Fix | Delete
`company` varchar(100) DEFAULT NULL,
[268] Fix | Delete
`company_vat` varchar(100) DEFAULT NULL,
[269] Fix | Delete
`company_number` varchar(255) DEFAULT NULL,
[270] Fix | Delete
`address_1` varchar(100) DEFAULT NULL,
[271] Fix | Delete
`address_2` varchar(100) DEFAULT NULL,
[272] Fix | Delete
`city` varchar(100) DEFAULT NULL,
[273] Fix | Delete
`state` varchar(100) DEFAULT NULL,
[274] Fix | Delete
`postcode` varchar(100) DEFAULT NULL,
[275] Fix | Delete
`country` varchar(100) DEFAULT NULL,
[276] Fix | Delete
`document_type` varchar(100) DEFAULT NULL,
[277] Fix | Delete
`document_nr` varchar(20) DEFAULT NULL,
[278] Fix | Delete
`notes` text,
[279] Fix | Delete
`currency` varchar(10) DEFAULT NULL,
[280] Fix | Delete
`lang` varchar(10) DEFAULT NULL,
[281] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[282] Fix | Delete
`api_token` varchar(128) DEFAULT NULL,
[283] Fix | Delete
`referred_by` varchar(255) DEFAULT NULL,
[284] Fix | Delete
`custom_1` text,
[285] Fix | Delete
`custom_2` text,
[286] Fix | Delete
`custom_3` text,
[287] Fix | Delete
`custom_4` text,
[288] Fix | Delete
`custom_5` text,
[289] Fix | Delete
`custom_6` text,
[290] Fix | Delete
`custom_7` text,
[291] Fix | Delete
`custom_8` text,
[292] Fix | Delete
`custom_9` text,
[293] Fix | Delete
`custom_10` text,
[294] Fix | Delete
`created_at` datetime DEFAULT NULL,
[295] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[296] Fix | Delete
PRIMARY KEY (`id`),
[297] Fix | Delete
UNIQUE KEY `email` (`email`),
[298] Fix | Delete
KEY `alternative_id_idx` (`aid`),
[299] Fix | Delete
KEY `client_group_id_idx` (`client_group_id`)
[300] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[301] Fix | Delete
[302] Fix | Delete
-- --------------------------------------------------------
[303] Fix | Delete
[304] Fix | Delete
--
[305] Fix | Delete
-- Table structure for table `client_balance`
[306] Fix | Delete
--
[307] Fix | Delete
[308] Fix | Delete
CREATE TABLE `client_balance` (
[309] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[310] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[311] Fix | Delete
`type` varchar(100) DEFAULT NULL,
[312] Fix | Delete
`rel_id` varchar(20) DEFAULT NULL,
[313] Fix | Delete
`amount` decimal(18,2) DEFAULT '0.00',
[314] Fix | Delete
`description` text,
[315] Fix | Delete
`created_at` datetime DEFAULT NULL,
[316] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[317] Fix | Delete
PRIMARY KEY (`id`),
[318] Fix | Delete
KEY `client_id_idx` (`client_id`)
[319] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[320] Fix | Delete
[321] Fix | Delete
-- --------------------------------------------------------
[322] Fix | Delete
[323] Fix | Delete
--
[324] Fix | Delete
-- Table structure for table `client_group`
[325] Fix | Delete
--
[326] Fix | Delete
[327] Fix | Delete
CREATE TABLE `client_group` (
[328] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[329] Fix | Delete
`title` varchar(255) DEFAULT NULL,
[330] Fix | Delete
`created_at` datetime DEFAULT NULL,
[331] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[332] Fix | Delete
PRIMARY KEY (`id`)
[333] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[334] Fix | Delete
[335] Fix | Delete
--
[336] Fix | Delete
-- Dumping data for table `client_group`
[337] Fix | Delete
--
[338] Fix | Delete
[339] Fix | Delete
INSERT INTO `client_group` VALUES
[340] Fix | Delete
(1, 'Default', '2012-01-01 12:00:00', '2012-01-01 12:00:00');
[341] Fix | Delete
[342] Fix | Delete
-- --------------------------------------------------------
[343] Fix | Delete
[344] Fix | Delete
--
[345] Fix | Delete
-- Table structure for table `client_order`
[346] Fix | Delete
--
[347] Fix | Delete
[348] Fix | Delete
CREATE TABLE `client_order` (
[349] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[350] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[351] Fix | Delete
`product_id` bigint(20) DEFAULT NULL,
[352] Fix | Delete
`form_id` bigint(20) DEFAULT NULL,
[353] Fix | Delete
`promo_id` bigint(20) DEFAULT NULL,
[354] Fix | Delete
`promo_recurring` tinyint(1) DEFAULT NULL,
[355] Fix | Delete
`promo_used` bigint(20) DEFAULT NULL,
[356] Fix | Delete
`group_id` varchar(255) DEFAULT NULL,
[357] Fix | Delete
`group_master` tinyint(1) DEFAULT '0',
[358] Fix | Delete
`invoice_option` varchar(255) DEFAULT NULL,
[359] Fix | Delete
`title` varchar(255) DEFAULT NULL,
[360] Fix | Delete
`currency` varchar(20) DEFAULT NULL,
[361] Fix | Delete
`unpaid_invoice_id` bigint(20) DEFAULT NULL,
[362] Fix | Delete
`service_id` bigint(20) DEFAULT NULL,
[363] Fix | Delete
`service_type` varchar(100) DEFAULT NULL,
[364] Fix | Delete
`period` varchar(20) DEFAULT NULL,
[365] Fix | Delete
`quantity` bigint(20) DEFAULT '1',
[366] Fix | Delete
`unit` varchar(100) DEFAULT NULL,
[367] Fix | Delete
`price` double(18,2) DEFAULT NULL,
[368] Fix | Delete
`discount` double(18,2) DEFAULT NULL COMMENT 'first invoice discount',
[369] Fix | Delete
`status` varchar(50) DEFAULT NULL,
[370] Fix | Delete
`reason` varchar(255) DEFAULT NULL COMMENT 'suspend/cancel reason',
[371] Fix | Delete
`notes` text,
[372] Fix | Delete
`config` text,
[373] Fix | Delete
`referred_by` varchar(255) DEFAULT NULL,
[374] Fix | Delete
`expires_at` datetime DEFAULT NULL,
[375] Fix | Delete
`activated_at` datetime DEFAULT NULL,
[376] Fix | Delete
`suspended_at` datetime DEFAULT NULL,
[377] Fix | Delete
`unsuspended_at` datetime DEFAULT NULL,
[378] Fix | Delete
`canceled_at` datetime DEFAULT NULL,
[379] Fix | Delete
`created_at` datetime DEFAULT NULL,
[380] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[381] Fix | Delete
PRIMARY KEY (`id`),
[382] Fix | Delete
KEY `client_id_idx` (`client_id`),
[383] Fix | Delete
KEY `product_id_idx` (`product_id`),
[384] Fix | Delete
KEY `form_id_idx` (`form_id`),
[385] Fix | Delete
KEY `promo_id_idx` (`promo_id`)
[386] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[387] Fix | Delete
[388] Fix | Delete
-- --------------------------------------------------------
[389] Fix | Delete
[390] Fix | Delete
--
[391] Fix | Delete
-- Table structure for table `client_order_meta`
[392] Fix | Delete
--
[393] Fix | Delete
[394] Fix | Delete
CREATE TABLE `client_order_meta` (
[395] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[396] Fix | Delete
`client_order_id` bigint(20) DEFAULT NULL,
[397] Fix | Delete
`name` varchar(255) DEFAULT NULL,
[398] Fix | Delete
`value` text,
[399] Fix | Delete
`created_at` datetime DEFAULT NULL,
[400] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[401] Fix | Delete
PRIMARY KEY (`id`),
[402] Fix | Delete
KEY `client_order_id_idx` (`client_order_id`)
[403] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[404] Fix | Delete
[405] Fix | Delete
-- --------------------------------------------------------
[406] Fix | Delete
[407] Fix | Delete
--
[408] Fix | Delete
-- Table structure for table `client_order_status`
[409] Fix | Delete
--
[410] Fix | Delete
[411] Fix | Delete
CREATE TABLE `client_order_status` (
[412] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[413] Fix | Delete
`client_order_id` bigint(20) DEFAULT NULL,
[414] Fix | Delete
`status` varchar(20) DEFAULT NULL,
[415] Fix | Delete
`notes` text,
[416] Fix | Delete
`created_at` datetime DEFAULT NULL,
[417] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[418] Fix | Delete
PRIMARY KEY (`id`),
[419] Fix | Delete
KEY `client_order_id_idx` (`client_order_id`)
[420] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[421] Fix | Delete
[422] Fix | Delete
-- --------------------------------------------------------
[423] Fix | Delete
[424] Fix | Delete
--
[425] Fix | Delete
-- Table structure for table `client_password_reset`
[426] Fix | Delete
--
[427] Fix | Delete
[428] Fix | Delete
CREATE TABLE `client_password_reset` (
[429] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[430] Fix | Delete
`client_id` bigint(20) DEFAULT NULL,
[431] Fix | Delete
`hash` varchar(100) DEFAULT NULL,
[432] Fix | Delete
`ip` varchar(45) DEFAULT NULL,
[433] Fix | Delete
`created_at` datetime DEFAULT NULL,
[434] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[435] Fix | Delete
PRIMARY KEY (`id`),
[436] Fix | Delete
KEY `client_id_idx` (`client_id`)
[437] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[438] Fix | Delete
[439] Fix | Delete
-- --------------------------------------------------------
[440] Fix | Delete
[441] Fix | Delete
--
[442] Fix | Delete
-- Table structure for table `currency`
[443] Fix | Delete
--
[444] Fix | Delete
[445] Fix | Delete
CREATE TABLE `currency` (
[446] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[447] Fix | Delete
`title` varchar(50) DEFAULT NULL,
[448] Fix | Delete
`code` varchar(3) DEFAULT NULL,
[449] Fix | Delete
`is_default` tinyint(1) DEFAULT '0',
[450] Fix | Delete
`conversion_rate` decimal(13,6) DEFAULT '1.000000',
[451] Fix | Delete
`format` varchar(30) DEFAULT NULL,
[452] Fix | Delete
`price_format` varchar(50) DEFAULT '1',
[453] Fix | Delete
`created_at` datetime DEFAULT NULL,
[454] Fix | Delete
`updated_at` datetime DEFAULT NULL,
[455] Fix | Delete
PRIMARY KEY (`id`)
[456] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[457] Fix | Delete
[458] Fix | Delete
--
[459] Fix | Delete
-- Dumping data for table `currency`
[460] Fix | Delete
--
[461] Fix | Delete
[462] Fix | Delete
INSERT INTO `currency` VALUES
[463] Fix | Delete
(1, 'US Dollar', 'USD', 1, 1.000000, '${{price}}', '1', '2012-01-01 12:00:00', '2012-01-01 12:00:00');
[464] Fix | Delete
[465] Fix | Delete
-- --------------------------------------------------------
[466] Fix | Delete
[467] Fix | Delete
--
[468] Fix | Delete
-- Table structure for table `email_template`
[469] Fix | Delete
--
[470] Fix | Delete
[471] Fix | Delete
CREATE TABLE `email_template` (
[472] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[473] Fix | Delete
`action_code` varchar(255) DEFAULT NULL,
[474] Fix | Delete
`category` varchar(30) DEFAULT NULL COMMENT 'general, domain, invoice, hosting, support, download, custom, license',
[475] Fix | Delete
`enabled` tinyint(1) DEFAULT '1',
[476] Fix | Delete
`subject` varchar(255) DEFAULT NULL,
[477] Fix | Delete
`content` text,
[478] Fix | Delete
`description` text,
[479] Fix | Delete
`vars` text,
[480] Fix | Delete
PRIMARY KEY (`id`),
[481] Fix | Delete
UNIQUE KEY `action_code` (`action_code`)
[482] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;
[483] Fix | Delete
[484] Fix | Delete
--
[485] Fix | Delete
-- Dumping data for table `email_template`
[486] Fix | Delete
--
[487] Fix | Delete
[488] Fix | Delete
INSERT INTO `email_template` VALUES
[489] Fix | Delete
(1, 'mod_client_confirm', 'client', 1, '[{{ guest.system_company.name }}] Please confirm your email address ', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nPlease verify your email by clicking on the link below:\n\n{{email_confirmation_link}}\n\nTo login, visit {{''login''|link({''email'' : c.email }) }}\nEdit your profile at {{''client/me''|link}}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[490] Fix | Delete
(2, 'mod_client_password_reset_approve', 'client', 1, '[{{ guest.system_company.name }}] Password Changed', '\n{% filter markdown %}\n\nHello {{ c.first_name }} {{ c.last_name }},\n\nAs you requested, your password for our client area has now been reset. \nYour new login details are as follows:\n\nLogin at: {{''login''|link({''email'' : c.email }) }}\nEmail: {{ c.email }}\nPassword: {{ password }}\n\nTo change your password to something more memorable, after logging in go to \nProfile > Change Password.\n\nEdit your profile at {{ ''client/me''|link }}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[491] Fix | Delete
(3, 'mod_client_password_reset_request', 'client', 1, '[{{ guest.system_company.name }}] Confirm Password Reset', '\n{% filter markdown %}\n\nHello {{ c.first_name }} {{ c.last_name }},\n\nRecently a request was submitted to reset your password for the client area.\nIf you did not request this, please ignore this email. It will expire and will not work in 2 hours time.\n\nTo reset your password, please visit the url below: \n{{''client/reset-password-confirm''|link}}/{{ hash }}\n\n\nWhen you visit the link above, your password will be reset and a new \npassword will be emailed to you.\n\nTo login, visit {{''login''|link({''email'' : c.email }) }}\nEdit your profile at {{''client/me''|link}}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[492] Fix | Delete
(4, 'mod_client_signup', 'client', 1, '[{{ guest.system_company.name }}] Welcome {{ c.first_name }}', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nThank you for signing up with us. Your new account has been setup and you can now login to our client area using the details below.\n\n\nEmail: {{c.email}} \nPassword: {{password}}\n\n{% if require_email_confirmation %}\n\nApprove your email by clicking on the link below:\n\n{{email_confirmation_link}}\n\n{% endif %}\n\nTo login, visit {{''login''|link({''email'' : c.email }) }}\nEdit your profile at {{''client/me''|link}}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[493] Fix | Delete
(5, 'mod_email_test', 'email', 1, '[{{ guest.system_company.name }}] BoxBilling Email Test', '\n{% filter markdown %}\nHi {{ staff.name }},\n\nIf you are reading this email, BoxBilling is **configured properly** \nand is **able to send emails**.\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[494] Fix | Delete
(6, 'mod_forum_new_post', 'forum', 1, '[{{ guest.system_company.name }}] New Forum Message', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nNew message was posted on Forum **{{ topic.forum.title }} > {{ topic.title }}**\n\n***\n\n{{ message.message }}\n\n***\n\nTo reply to this message or disable notifications, visit the link below:\n\n{{ ''forum''|link }}/{{ topic.forum.slug }}/{{ topic.slug }} \n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[495] Fix | Delete
(7, 'mod_invoice_created', 'invoice', 1, '[{{ guest.system_company.name }}] Invoice Created', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nThis is to notify that proforma invoice {{ invoice.id }} was generated on {{ invoice.created_at|bb_date }}.\nAmount Due: {{ invoice.total | money(invoice.currency) }}\nDue Date: {{invoice.due_at|bb_date}}\n\nYou can view and pay the invoice at: {{''invoice''|link}}/{{invoice.hash}}\n\nLogin to members area: {{''login''|link({''email'' : c.email }) }}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[496] Fix | Delete
(8, 'mod_invoice_due_after', 'invoice', 1, '[{{ guest.system_company.name }}] Invoice Due', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nThis is a payment reminder that your proforma invoice **{{ invoice.serie_nr }}** is already\ndue for {{ days_passed }} days. \n\nAmount due: {{ invoice.total | money(invoice.currency) }}\nDue Date: {{ invoice.due_at|bb_date }}\n\nYou can view and pay the invoice at: {{''invoice''|link}}/{{invoice.hash}}\n\nYou may review your invoice history at any time by logging in to your client area.\n\nLogin to members area: {{''login''|link({''email'' : c.email }) }}\nView and manage invoices: {{''invoice''|link}} \n\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[497] Fix | Delete
(9, 'mod_invoice_paid', 'invoice', 1, '[{{ guest.system_company.name }}] Payment Received', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nThis is a payment receipt for Invoice **{{ invoice.serie_nr }}** issued on\n{{invoice.created_at|date(''Y-m-d'')}}\n\nTotal Paid: {{ invoice.total | money(invoice.currency) }}\n\nYou may review your invoice history at any time by logging in to your client area.\nNote: This email serves as an official receipt for this payment.\n\nLogin to members area: {{''login''|link({''email'' : c.email }) }}\nView invoice: {{''invoice''|link}}/{{invoice.hash}}\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', NULL, NULL),
[498] Fix | Delete
(10, 'mod_invoice_payment_reminder', 'invoice', 1, '[{{ guest.system_company.name }}] Payment Reminder', '\n{% filter markdown %}\nHello {{ c.first_name }} {{ c.last_name }},\n\nThis is to remind that your proforma invoice **{{ invoice.serie_nr }}** is due\nin {{ invoice.due_at|daysleft }} days. \n\nAmount due: {{ invoice.total | money(invoice.currency) }}\nDue Date: {{ invoice.due_at|bb_date }}\n\nYou can view and pay the invoice at: {{''invoice''|link}}/{{invoice.hash}}\n\nYou may review your invoice history at any time by logging in to your client area.\n\nLogin to members area: {{''login''|link({''email'' : c.email }) }}\nView and manage invoices: {{''invoice''|link}} \n\n\n{{ guest.system_company.signature }}\n\n{% endfilter %}\n', 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