initial commit
[namibia] / data / old_b4c stuff / mig_db.sql
1 -- phpMyAdmin SQL Dump
2 -- version 3.5.1
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: localhost
6 -- Generation Time: Aug 29, 2013 at 10:59 AM
7 -- Server version: 5.1.63-community
8 -- PHP Version: 5.4.11
9
10 SET FOREIGN_KEY_CHECKS=0;
11 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
12 SET time_zone = "+00:00";
13
14
15 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
16 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
17 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
18 /*!40101 SET NAMES utf8 */;
19
20 --
21 -- Database: `mig_db`
22 --
23
24 -- --------------------------------------------------------
25
26 --
27 -- Table structure for table `app_config`
28 --
29
30 DROP TABLE IF EXISTS `app_config`;
31 CREATE TABLE IF NOT EXISTS `app_config` (
32   `id` int(11) NOT NULL AUTO_INCREMENT,
33   `profile_permissions_id` int(11) NOT NULL,
34   `date_format` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
35   `datetime_format` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
36   `time_format` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
37   `excel_currency_format` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
38   `currency_prefix` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
39   `vat_percentage` decimal(5,2) NOT NULL,
40   `source_email_address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
41   `source_mobile_address` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
42   `admin_email_address` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
43   `sms_new_pin` tinyint(1) NOT NULL,
44   `sms_customer_valuation` tinyint(1) NOT NULL,
45   `price_guide_open_days` smallint(6) DEFAULT NULL,
46   `price_guide_completion_days` smallint(6) DEFAULT NULL,
47   `auction_max_days` smallint(6) DEFAULT NULL,
48   `app_version` decimal(5,2) NOT NULL,
49   PRIMARY KEY (`id`),
50   KEY `IDX_318942FC7748E92` (`profile_permissions_id`)
51 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
52
53 --
54 -- Dumping data for table `app_config`
55 --
56
57 INSERT INTO `app_config` (`id`, `profile_permissions_id`, `date_format`, `datetime_format`, `time_format`, `excel_currency_format`, `currency_prefix`, `vat_percentage`, `source_email_address`, `source_mobile_address`, `admin_email_address`, `sms_new_pin`, `sms_customer_valuation`, `price_guide_open_days`, `price_guide_completion_days`, `auction_max_days`, `app_version`) VALUES
58 (1, 9, 'Y-m-d', 'Y-m-d H:i:s', 'H:i:s', 'R #,##0.00;[red]R -#,##0.00', 'R ', '14.00', 'noreply@bid4cars.co.za', '', 'andre@nirph.com', 1, 0, 3, 30, NULL, '1.00');
59
60 -- --------------------------------------------------------
61
62 --
63 -- Table structure for table `auction`
64 --
65
66 DROP TABLE IF EXISTS `auction`;
67 CREATE TABLE IF NOT EXISTS `auction` (
68   `id` int(11) NOT NULL AUTO_INCREMENT,
69   `created_by_profile_id` int(11) NOT NULL,
70   `company_id` int(11) NOT NULL,
71   `stock_id` int(11) NOT NULL,
72   `sold_to_profile_id` int(11) DEFAULT NULL,
73   `sold_to_company_id` int(11) DEFAULT NULL,
74   `auction_bid_id` int(11) DEFAULT NULL,
75   `bid_price` decimal(11,2) NOT NULL,
76   `reserve_price` decimal(11,2) NOT NULL,
77   `bid_increment` decimal(11,2) NOT NULL,
78   `start_date` datetime NOT NULL,
79   `end_date` datetime NOT NULL,
80   `number_of_bids` int(11) NOT NULL,
81   `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
82   `created` datetime NOT NULL,
83   `updated` datetime DEFAULT NULL,
84   `archived` tinyint(1) NOT NULL,
85   PRIMARY KEY (`id`),
86   UNIQUE KEY `UNIQ_DEE4F593340BCA85` (`auction_bid_id`),
87   KEY `IDX_DEE4F593FFA30A58` (`created_by_profile_id`),
88   KEY `IDX_DEE4F593979B1AD6` (`company_id`),
89   KEY `IDX_DEE4F593DCD6110` (`stock_id`),
90   KEY `IDX_DEE4F5933291555F` (`sold_to_profile_id`),
91   KEY `IDX_DEE4F59369F05D31` (`sold_to_company_id`)
92 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
93
94 --
95 -- Dumping data for table `auction`
96 --
97
98 INSERT INTO `auction` (`id`, `created_by_profile_id`, `company_id`, `stock_id`, `sold_to_profile_id`, `sold_to_company_id`, `auction_bid_id`, `bid_price`, `reserve_price`, `bid_increment`, `start_date`, `end_date`, `number_of_bids`, `status`, `created`, `updated`, `archived`) VALUES
99 (1, 2, 1, 1, NULL, NULL, 1, '301500.00', '300000.00', '1500.00', '2013-08-29 08:47:50', '2013-08-30 14:30:00', 1, 'Active', '2013-08-29 08:47:50', '2013-08-29 08:50:26', 0),
100 (2, 2, 1, 2, NULL, NULL, 2, '655500.00', '654654.00', '1500.00', '2013-08-29 12:29:41', '2013-08-30 14:30:00', 1, 'Active', '2013-08-29 12:29:41', '2013-08-29 12:30:04', 0);
101
102 -- --------------------------------------------------------
103
104 --
105 -- Table structure for table `auction_autobid`
106 --
107
108 DROP TABLE IF EXISTS `auction_autobid`;
109 CREATE TABLE IF NOT EXISTS `auction_autobid` (
110   `id` int(11) NOT NULL AUTO_INCREMENT,
111   `auction_id` int(11) NOT NULL,
112   `company_id` int(11) NOT NULL,
113   `profile_id` int(11) NOT NULL,
114   `amount` decimal(11,2) NOT NULL,
115   `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
116   `created` datetime NOT NULL,
117   `archived` tinyint(1) NOT NULL,
118   PRIMARY KEY (`id`),
119   KEY `IDX_69F7105B57B8F0DE` (`auction_id`),
120   KEY `IDX_69F7105B979B1AD6` (`company_id`),
121   KEY `IDX_69F7105BCCFA12B8` (`profile_id`)
122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
123
124 -- --------------------------------------------------------
125
126 --
127 -- Table structure for table `auction_basket`
128 --
129
130 DROP TABLE IF EXISTS `auction_basket`;
131 CREATE TABLE IF NOT EXISTS `auction_basket` (
132   `id` int(11) NOT NULL AUTO_INCREMENT,
133   `auction_id` int(11) NOT NULL,
134   `company_id` int(11) NOT NULL,
135   `profile_id` int(11) NOT NULL,
136   `created` datetime NOT NULL,
137   `updated` datetime DEFAULT NULL,
138   `archived` tinyint(1) NOT NULL,
139   PRIMARY KEY (`id`),
140   KEY `IDX_5BD5FC4657B8F0DE` (`auction_id`),
141   KEY `IDX_5BD5FC46979B1AD6` (`company_id`),
142   KEY `IDX_5BD5FC46CCFA12B8` (`profile_id`)
143 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
144
145 --
146 -- Dumping data for table `auction_basket`
147 --
148
149 INSERT INTO `auction_basket` (`id`, `auction_id`, `company_id`, `profile_id`, `created`, `updated`, `archived`) VALUES
150 (1, 1, 2, 6, '2013-08-29 08:50:26', '2013-08-29 12:32:35', 0),
151 (4, 2, 2, 6, '2013-08-29 12:34:10', NULL, 0);
152
153 -- --------------------------------------------------------
154
155 --
156 -- Table structure for table `auction_bid`
157 --
158
159 DROP TABLE IF EXISTS `auction_bid`;
160 CREATE TABLE IF NOT EXISTS `auction_bid` (
161   `id` int(11) NOT NULL AUTO_INCREMENT,
162   `auction_id` int(11) NOT NULL,
163   `company_id` int(11) NOT NULL,
164   `profile_id` int(11) NOT NULL,
165   `auction_autobid_id` int(11) DEFAULT NULL,
166   `amount` decimal(11,2) NOT NULL,
167   `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
168   `created` datetime NOT NULL,
169   `archived` tinyint(1) NOT NULL,
170   PRIMARY KEY (`id`),
171   KEY `IDX_401A9C4357B8F0DE` (`auction_id`),
172   KEY `IDX_401A9C43979B1AD6` (`company_id`),
173   KEY `IDX_401A9C43CCFA12B8` (`profile_id`),
174   KEY `IDX_401A9C436FB371E6` (`auction_autobid_id`)
175 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
176
177 --
178 -- Dumping data for table `auction_bid`
179 --
180
181 INSERT INTO `auction_bid` (`id`, `auction_id`, `company_id`, `profile_id`, `auction_autobid_id`, `amount`, `status`, `created`, `archived`) VALUES
182 (1, 1, 2, 6, NULL, '301500.00', 'Active', '2013-08-29 08:50:26', 0),
183 (2, 2, 2, 6, NULL, '655500.00', 'Active', '2013-08-29 12:30:04', 0);
184
185 -- --------------------------------------------------------
186
187 --
188 -- Table structure for table `auction_increment`
189 --
190
191 DROP TABLE IF EXISTS `auction_increment`;
192 CREATE TABLE IF NOT EXISTS `auction_increment` (
193   `id` int(11) NOT NULL AUTO_INCREMENT,
194   `range_from` int(10) unsigned NOT NULL,
195   `range_to` int(10) unsigned NOT NULL,
196   `amount` decimal(11,2) NOT NULL,
197   PRIMARY KEY (`id`)
198 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
199
200 --
201 -- Dumping data for table `auction_increment`
202 --
203
204 INSERT INTO `auction_increment` (`id`, `range_from`, `range_to`, `amount`) VALUES
205 (1, 0, 100000, '1000.00'),
206 (2, 100000, 1000000, '1500.00'),
207 (3, 1000000, 10000000, '2000.00');
208
209 -- --------------------------------------------------------
210
211 --
212 -- Table structure for table `auction_question`
213 --
214
215 DROP TABLE IF EXISTS `auction_question`;
216 CREATE TABLE IF NOT EXISTS `auction_question` (
217   `id` int(11) NOT NULL AUTO_INCREMENT,
218   `auction_id` int(11) NOT NULL,
219   `company_id` int(11) NOT NULL,
220   `profile_id` int(11) NOT NULL,
221   `auction_reply_id` int(11) DEFAULT NULL,
222   `question` longtext COLLATE utf8_unicode_ci NOT NULL,
223   `created` datetime NOT NULL,
224   `updated` datetime DEFAULT NULL,
225   `archived` tinyint(1) NOT NULL,
226   PRIMARY KEY (`id`),
227   KEY `IDX_37F97A057B8F0DE` (`auction_id`),
228   KEY `IDX_37F97A0979B1AD6` (`company_id`),
229   KEY `IDX_37F97A0CCFA12B8` (`profile_id`),
230   KEY `IDX_37F97A03F869091` (`auction_reply_id`)
231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
232
233 -- --------------------------------------------------------
234
235 --
236 -- Table structure for table `auction_reply`
237 --
238
239 DROP TABLE IF EXISTS `auction_reply`;
240 CREATE TABLE IF NOT EXISTS `auction_reply` (
241   `id` int(11) NOT NULL AUTO_INCREMENT,
242   `auction_question_id` int(11) NOT NULL,
243   `profile_id` int(11) NOT NULL,
244   `reply` longtext COLLATE utf8_unicode_ci NOT NULL,
245   `archived` tinyint(1) NOT NULL,
246   PRIMARY KEY (`id`),
247   KEY `IDX_B2BC5FE94183E823` (`auction_question_id`),
248   KEY `IDX_B2BC5FE9CCFA12B8` (`profile_id`)
249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
250
251 -- --------------------------------------------------------
252
253 --
254 -- Table structure for table `company`
255 --
256
257 DROP TABLE IF EXISTS `company`;
258 CREATE TABLE IF NOT EXISTS `company` (
259   `id` int(11) NOT NULL AUTO_INCREMENT,
260   `lib_region_id` int(11) NOT NULL,
261   `lib_town_id` int(11) NOT NULL,
262   `billing_lib_town_id` int(11) DEFAULT NULL,
263   `auction_lib_town_id` int(11) DEFAULT NULL,
264   `trade_center_dealer_id` int(11) DEFAULT NULL,
265   `company_group_id` int(11) DEFAULT NULL,
266   `company_group_division_id` int(11) DEFAULT NULL,
267   `lib_contact_id` int(11) DEFAULT NULL,
268   `billing_lib_contact_id` int(11) DEFAULT NULL,
269   `company_found_method_id` int(11) DEFAULT NULL,
270   `company_found_method_detail_id` int(11) DEFAULT NULL,
271   `lib_photo_id` int(11) DEFAULT NULL,
272   `stock_cert_lib_document_id` int(11) DEFAULT NULL,
273   `address_proof_lib_document_id` int(11) DEFAULT NULL,
274   `copy_of_id_lib_document_id` int(11) DEFAULT NULL,
275   `copy_of_director_id_lib_document_id` int(11) DEFAULT NULL,
276   `company_reg_lib_document_id` int(11) DEFAULT NULL,
277   `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
278   `business_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
279   `postal_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
280   `street` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
281   `billing_postal_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
282   `billing_street` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
283   `auction_postal_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
284   `auction_street` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL,
285   `dealer_type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
286   `client_type` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
287   `company_registration_number` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
288   `vat_number` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
289   `turmi_no` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
290   `dealer_stock_number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
291   `trade_exchange_link` tinyint(1) NOT NULL,
292   `company_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
293   `company_turnover` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
294   `price_guide` tinyint(1) NOT NULL,
295   `club_invite` tinyint(1) NOT NULL,
296   `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
297   `status_reason` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
298   `created` datetime NOT NULL,
299   `updated` datetime DEFAULT NULL,
300   `archived` tinyint(1) NOT NULL,
301   PRIMARY KEY (`id`),
302   UNIQUE KEY `UNIQ_4FBF094FD5F1213C` (`lib_contact_id`),
303   UNIQUE KEY `UNIQ_4FBF094F5D34198B` (`billing_lib_contact_id`),
304   UNIQUE KEY `UNIQ_4FBF094F1E518654` (`lib_photo_id`),
305   KEY `IDX_4FBF094F104E9479` (`lib_region_id`),
306   KEY `IDX_4FBF094FAA63B9B` (`lib_town_id`),
307   KEY `IDX_4FBF094F8D22FF26` (`billing_lib_town_id`),
308   KEY `IDX_4FBF094F55022507` (`auction_lib_town_id`),
309   KEY `IDX_4FBF094F5488C135` (`trade_center_dealer_id`),
310   KEY `IDX_4FBF094FE6C3CC2A` (`company_group_id`),
311   KEY `IDX_4FBF094F38A01CB0` (`company_group_division_id`),
312   KEY `IDX_4FBF094F1384F663` (`company_found_method_id`),
313   KEY `IDX_4FBF094F788B138A` (`company_found_method_detail_id`),
314   KEY `IDX_4FBF094F8AC042D1` (`stock_cert_lib_document_id`),
315   KEY `IDX_4FBF094F5064FE5E` (`address_proof_lib_document_id`),
316   KEY `IDX_4FBF094F17D9359C` (`copy_of_id_lib_document_id`),
317   KEY `IDX_4FBF094FF0455375` (`copy_of_director_id_lib_document_id`),
318   KEY `IDX_4FBF094F36522823` (`company_reg_lib_document_id`)
319 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
320
321 --
322 -- Dumping data for table `company`
323 --
324
325 INSERT INTO `company` (`id`, `lib_region_id`, `lib_town_id`, `billing_lib_town_id`, `auction_lib_town_id`, `trade_center_dealer_id`, `company_group_id`, `company_group_division_id`, `lib_contact_id`, `billing_lib_contact_id`, `company_found_method_id`, `company_found_method_detail_id`, `lib_photo_id`, `stock_cert_lib_document_id`, `address_proof_lib_document_id`, `copy_of_id_lib_document_id`, `copy_of_director_id_lib_document_id`, `company_reg_lib_document_id`, `name`, `business_name`, `postal_code`, `street`, `billing_postal_code`, `billing_street`, `auction_postal_code`, `auction_street`, `dealer_type`, `client_type`, `company_registration_number`, `vat_number`, `turmi_no`, `dealer_stock_number`, `trade_exchange_link`, `company_type`, `company_turnover`, `price_guide`, `club_invite`, `status`, `status_reason`, `created`, `updated`, `archived`) VALUES
326 (1, 1, 1, NULL, NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ImperialSeller', NULL, '0030', 'Umgeni Street', NULL, NULL, NULL, NULL, 'Trader', 'Buyer & Seller', NULL, NULL, '7777', NULL, 0, 'PTY Limited', NULL, 0, 0, 'Active', NULL, '2013-08-29 08:22:16', NULL, 0),
327 (2, 1, 1, NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'AmhSeller', NULL, '0030', 'Church Srteet', NULL, NULL, NULL, NULL, 'Trader', 'Buyer & Seller', NULL, NULL, '7777', NULL, 0, 'PTY Limited', NULL, 0, 0, 'Active', NULL, '2013-08-29 08:22:16', NULL, 0),
328 (3, 1, 2, NULL, NULL, NULL, 3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'IndependantBuyer', NULL, '0032', 'Lenchen South', NULL, NULL, NULL, NULL, 'Trader', 'Buyer', NULL, NULL, '', NULL, 0, 'PTY Limited', NULL, 0, 0, 'Active', NULL, '2013-08-29 08:22:16', NULL, 0),
329 (4, 1, 2, NULL, NULL, NULL, 1, 2, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Dave''s Dealership', NULL, '0032', 'Lenchen South', NULL, NULL, NULL, NULL, 'Trader', 'Buyer', NULL, NULL, '7777', NULL, 0, 'PTY Limited', NULL, 0, 0, 'Active', NULL, '2013-08-29 08:22:16', NULL, 0),
330 (5, 1, 2, NULL, NULL, NULL, 3, 3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Byron''s Trader Dealership', NULL, '0032', 'Lenchen South', NULL, NULL, NULL, NULL, 'Trader', 'Buyer', NULL, NULL, '7777', NULL, 0, 'PTY Limited', NULL, 0, 0, 'Active', NULL, '2013-08-29 08:22:16', NULL, 0);
331
332 -- --------------------------------------------------------
333
334 --
335 -- Table structure for table `company_found_method`
336 --
337
338 DROP TABLE IF EXISTS `company_found_method`;
339 CREATE TABLE IF NOT EXISTS `company_found_method` (
340   `id` int(11) NOT NULL AUTO_INCREMENT,
341   `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
342   `archived` tinyint(1) NOT NULL,
343   PRIMARY KEY (`id`)
344 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
345
346 -- --------------------------------------------------------
347
348 --
349 -- Table structure for table `company_found_method_subcategory`
350 --
351
352 DROP TABLE IF EXISTS `company_found_method_subcategory`;
353 CREATE TABLE IF NOT EXISTS `company_found_method_subcategory` (
354   `id` int(11) NOT NULL AUTO_INCREMENT,
355   `company_found_method_id` int(11) DEFAULT NULL,
356   `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
357   `archived` tinyint(1) NOT NULL,
358   PRIMARY KEY (`id`),
359   KEY `IDX_D63613C51384F663` (`company_found_method_id`)
360 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
361
362 -- --------------------------------------------------------
363
364 --
365 -- Table structure for table `company_group`
366 --
367
368 DROP TABLE IF EXISTS `company_group`;
369 CREATE TABLE IF NOT EXISTS `company_group` (
370   `id` int(11) NOT NULL AUTO_INCREMENT,
371   `logo_lib_photo_id` int(11) DEFAULT NULL,
372   `watermark_lib_photo_id` int(11) DEFAULT NULL,
373   `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
374   `number_of_dealers` smallint(6) NOT NULL,
375   `pricing_type` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
376   `fixed_pricing` int(11) DEFAULT NULL,
377   `price_guide` tinyint(1) NOT NULL,
378   `created` datetime NOT NULL,
379   `updated` datetime DEFAULT NULL,
380   `archived` tinyint(1) NOT NULL,
381   `landing_page` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
382   PRIMARY KEY (`id`),
383   UNIQUE KEY `UNIQ_2A31E6A0D0B1F706` (`logo_lib_photo_id`),
384   UNIQUE KEY `UNIQ_2A31E6A0128352F2` (`watermark_lib_photo_id`)
385 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;
386
387 --
388 -- Dumping data for table `company_group`
389 --
390
391 INSERT INTO `company_group` (`id`, `logo_lib_photo_id`, `watermark_lib_photo_id`, `name`, `number_of_dealers`, `pricing_type`, `fixed_pricing`, `price_guide`, `created`, `updated`, `archived`, `landing_page`) VALUES
392 (1, NULL, NULL, 'Imperial', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations'),
393 (2, NULL, NULL, 'AMH', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations'),
394 (3, NULL, NULL, 'Independant', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'priceguide'),
395 (4, NULL, NULL, 'Tavcor', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations'),
396 (5, NULL, NULL, 'McCarthy', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations'),
397 (6, NULL, NULL, 'Eastern Cape Motors', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations'),
398 (7, NULL, NULL, 'CMH group', 0, 'Incremental', 0, 0, '2013-08-29 08:22:15', NULL, 0, 'valuations');
399
400 -- --------------------------------------------------------
401
402 --
403 -- Table structure for table `company_group_division`
404 --
405
406 DROP TABLE IF EXISTS `company_group_division`;
407 CREATE TABLE IF NOT EXISTS `company_group_division` (
408   `id` int(11) NOT NULL AUTO_INCREMENT,
409   `company_group_id` int(11) DEFAULT NULL,
410   `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
411   `created` datetime NOT NULL,
412   `updated` datetime DEFAULT NULL,
413   `archived` tinyint(1) NOT NULL,
414   PRIMARY KEY (`id`),
415   KEY `IDX_37EF24C8E6C3CC2A` (`company_group_id`)
416 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
417
418 --
419 -- Dumping data for table `company_group_division`
420 --
421
422 INSERT INTO `company_group_division` (`id`, `company_group_id`, `name`, `created`, `updated`, `archived`) VALUES
423 (1, 1, 'Hyundai', '2013-08-29 08:22:15', NULL, 0),
424 (2, 1, 'Cargo', '2013-08-29 08:22:16', NULL, 0),
425 (3, 3, 'Independant', '2013-08-29 08:22:16', NULL, 0),
426 (4, 2, 'Mercedes', '2013-08-29 08:22:16', NULL, 0),
427 (5, 2, 'Chev', '2013-08-29 08:22:16', NULL, 0);
428
429 -- --------------------------------------------------------
430
431 --
432 -- Table structure for table `company_owner`
433 --
434
435 DROP TABLE IF EXISTS `company_owner`;
436 CREATE TABLE IF NOT EXISTS `company_owner` (
437   `id` int(11) NOT NULL AUTO_INCREMENT,
438   `company_id` int(11) DEFAULT NULL,
439   `first_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
440   `family_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
441   `id_number` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
442   `created` datetime NOT NULL,
443   `updated` datetime DEFAULT NULL,
444   PRIMARY KEY (`id`),
445   KEY `IDX_88914419979B1AD6` (`company_id`)
446 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
447
448 -- --------------------------------------------------------
449
450 --
451 -- Table structure for table `company_retail`
452 --
453
454 DROP TABLE IF EXISTS `company_retail`;
455 CREATE TABLE IF NOT EXISTS `company_retail` (
456   `id` int(11) NOT NULL AUTO_INCREMENT,
457   `company_id` int(11) DEFAULT NULL,
458   `retail_id` int(11) DEFAULT NULL,
459   `username` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
460   `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
461   `created` datetime NOT NULL,
462   `updated` datetime DEFAULT NULL,
463   `archived` tinyint(1) NOT NULL,
464   PRIMARY KEY (`id`),
465   UNIQUE KEY `UNIQ_C616FA60F85E0677` (`username`),
466   KEY `IDX_C616FA60979B1AD6` (`company_id`),
467   KEY `IDX_C616FA6070A3840` (`retail_id`)
468 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
469
470 -- --------------------------------------------------------
471
472 --
473 -- Table structure for table `dispute`
474 --
475
476 DROP TABLE IF EXISTS `dispute`;
477 CREATE TABLE IF NOT EXISTS `dispute` (
478   `id` int(11) NOT NULL AUTO_INCREMENT,
479   `created_by_profile_id` int(11) NOT NULL,
480   `from_company_id` int(11) NOT NULL,
481   `against_company_id` int(11) NOT NULL,
482   `auction_id` int(11) NOT NULL,
483   `complaint` longtext COLLATE utf8_unicode_ci NOT NULL,
484   `resolution` longtext COLLATE utf8_unicode_ci NOT NULL,
485   `status` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
486   `created` datetime NOT NULL,
487   `updated` datetime DEFAULT NULL,
488   `archived` tinyint(1) NOT NULL,
489   PRIMARY KEY (`id`),
490   KEY `IDX_3C925007FFA30A58` (`created_by_profile_id`),
491   KEY `IDX_3C925007BC3FDCD1` (`from_company_id`),
492   KEY `IDX_3C92500767F3FF09` (`against_company_id`),
493   KEY `IDX_3C92500757B8F0DE` (`auction_id`)
494 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
495
496 -- --------------------------------------------------------
497
498 --
499 -- Table structure for table `lib_api_log`
500 --
501
502 DROP TABLE IF EXISTS `lib_api_log`;
503 CREATE TABLE IF NOT EXISTS `lib_api_log` (
504   `id` int(11) NOT NULL AUTO_INCREMENT,
505   `from_company_id` int(11) DEFAULT NULL,
506   `from_profile_id` int(11) DEFAULT NULL,
507   `service` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
508   `request` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
509   `response` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
510   `status` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
511   `created` datetime NOT NULL,
512   `updated` datetime DEFAULT NULL,
513   `archived` tinyint(1) NOT NULL,
514   PRIMARY KEY (`id`),
515   KEY `IDX_B3F9236EBC3FDCD1` (`from_company_id`),
516   KEY `IDX_B3F9236EE75ED4BF` (`from_profile_id`)
517 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
518
519 --
520 -- Dumping data for table `lib_api_log`
521 --
522
523 INSERT INTO `lib_api_log` (`id`, `from_company_id`, `from_profile_id`, `service`, `request`, `response`, `status`, `created`, `updated`, `archived`) VALUES
524 (1, 1, 2, 'TransUnion', 'a:3:{s:10:"Credential";a:2:{s:8:"Username";s:10:"Bid4Cars01";s:8:"Password";s:11:"B1d4C@rS!*@";}s:6:"MMCode";s:8:"03740100";s:7:"RegYear";s:4:"2012";}', 'a:3:{s:11:"SearchRefNo";i:156508;s:6:"Status";s:7:"Success";s:14:"VehicleDetails";a:1:{i:0;a:2:{s:5:"Value";a:7:{s:15:"IsPriceEstimate";b:0;s:8:"NewPrice";i:364800;s:7:"Options";a:0:{}s:23:"RetailMileageAdjustment";i:0;s:11:"RetailPrice";i:0;s:22:"TradeMileageAdjustment";i:0;s:10:"TradePrice";i:0;}s:7:"Vehicle";a:12:{s:6:"Colour";N;s:10:"Derivative";s:37:"812 MINI BUS B/S B/S (2004 - CURRENT)";s:8:"EngineNo";N;s:6:"MMCode";s:8:"03740100";s:4:"Make";s:13:"ASHOK LEYLAND";s:16:"ManufacturedYear";N;s:5:"Model";s:3:"812";s:5:"RegNo";N;s:7:"RegYear";i:2012;s:5:"Specs";a:12:{i:0;a:2:{s:4:"Name";s:4:"Axle";s:5:"Value";s:3:"4X2";}i:1;a:2:{s:4:"Name";s:9:"Body Type";s:5:"Value";s:3:"B/S";}i:2;a:2:{s:4:"Name";s:2:"CC";s:5:"Value";s:4:"3908";}i:3;a:2:{s:4:"Name";s:3:"Cyl";s:5:"Value";s:1:"4";}i:4;a:2:{s:4:"Name";s:5:"Doors";s:5:"Value";s:1:"2";}i:5;a:2:{s:4:"Name";s:3:"GVM";s:5:"Value";s:4:"7500";}i:6;a:2:{s:4:"Name";s:2:"kW";s:5:"Value";s:2:"85";}i:7;a:2:{s:4:"Name";s:4:"Tare";s:5:"Value";s:4:"2700";}i:8;a:2:{s:4:"Name";s:17:"Tyre Size (Front)";s:5:"Value";s:12:"7.50X16-14PR";}i:9;a:2:{s:4:"Name";s:16:"Tyre Size (Rear)";s:5:"Value";s:12:"7.50X16-14PR";}i:10;a:2:{s:4:"Name";s:3:"Use";s:5:"Value";s:3:"B/S";}i:11;a:2:{s:4:"Name";s:10:"Wheel base";s:5:"Value";s:4:"3600";}}s:4:"Type";s:3:"Bus";s:3:"VIN";N;}}}}', 'Success', '2013-08-29 08:47:27', NULL, 0),
525 (2, 1, 2, 'TransUnion', 'a:3:{s:10:"Credential";a:2:{s:8:"Username";s:10:"Bid4Cars01";s:8:"Password";s:11:"B1d4C@rS!*@";}s:6:"MMCode";s:8:"02081800";s:7:"RegYear";s:4:"2012";}', 'a:3:{s:11:"SearchRefNo";i:156930;s:6:"Status";s:7:"Success";s:14:"VehicleDetails";a:1:{i:0;a:2:{s:5:"Value";a:7:{s:15:"IsPriceEstimate";b:0;s:8:"NewPrice";i:339548;s:7:"Options";a:0:{}s:23:"RetailMileageAdjustment";i:0;s:11:"RetailPrice";i:250600;s:22:"TradeMileageAdjustment";i:0;s:10:"TradePrice";i:224500;}s:7:"Vehicle";a:12:{s:6:"Colour";N;s:10:"Derivative";s:36:"GT 1.9 JTD DISTINCTIVE (2004 - 2012)";s:8:"EngineNo";N;s:6:"MMCode";s:8:"02081800";s:4:"Make";s:10:"ALFA ROMEO";s:16:"ManufacturedYear";N;s:5:"Model";s:8:"156 / GT";s:5:"RegNo";N;s:7:"RegYear";i:2012;s:5:"Specs";a:11:{i:0;a:2:{s:4:"Name";s:4:"Axle";s:5:"Value";s:3:"4X2";}i:1;a:2:{s:4:"Name";s:9:"Body Type";s:5:"Value";s:3:"C/P";}i:2;a:2:{s:4:"Name";s:2:"CC";s:5:"Value";s:4:"1910";}i:3;a:2:{s:4:"Name";s:3:"Cyl";s:5:"Value";s:1:"4";}i:4;a:2:{s:4:"Name";s:5:"Doors";s:5:"Value";s:1:"2";}i:5;a:2:{s:4:"Name";s:2:"kW";s:5:"Value";s:3:"110";}i:6;a:2:{s:4:"Name";s:4:"Tare";s:5:"Value";s:4:"1365";}i:7;a:2:{s:4:"Name";s:17:"Tyre Size (Front)";s:5:"Value";s:10:"205/55 R16";}i:8;a:2:{s:4:"Name";s:16:"Tyre Size (Rear)";s:5:"Value";s:10:"205/55 R16";}i:9;a:2:{s:4:"Name";s:3:"Use";s:5:"Value";s:3:"GEN";}i:10;a:2:{s:4:"Name";s:10:"Wheel base";s:5:"Value";s:4:"2596";}}s:4:"Type";s:4:"Auto";s:3:"VIN";N;}}}}', 'Success', '2013-08-29 12:29:28', NULL, 0);
526
527 -- --------------------------------------------------------
528
529 --
530 -- Table structure for table `lib_attachment`
531 --
532
533 DROP TABLE IF EXISTS `lib_attachment`;
534 CREATE TABLE IF NOT EXISTS `lib_attachment` (
535   `id` int(11) NOT NULL AUTO_INCREMENT,
536   `filename` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
537   `mime_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
538   `downloads` int(11) NOT NULL,
539   `created` datetime NOT NULL,
540   `archived` tinyint(1) NOT NULL,
541   PRIMARY KEY (`id`)
542 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
543
544 -- --------------------------------------------------------
545
546 --
547 -- Table structure for table `lib_city`
548 --
549
550 DROP TABLE IF EXISTS `lib_city`;
551 CREATE TABLE IF NOT EXISTS `lib_city` (
552   `id` int(11) NOT NULL AUTO_INCREMENT,
553   `lib_region_id` int(11) DEFAULT NULL,
554   `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
555   `created` datetime NOT NULL,
556   `updated` datetime DEFAULT NULL,
557   `archived` tinyint(1) NOT NULL,
558   PRIMARY KEY (`id`),
559   KEY `IDX_F2848C8104E9479` (`lib_region_id`)
560 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;
561
562 --
563 -- Dumping data for table `lib_city`
564 --
565
566 INSERT INTO `lib_city` (`id`, `lib_region_id`, `name`, `created`, `updated`, `archived`) VALUES
567 (1, 1, 'Pretoria', '2013-08-29 08:22:13', NULL, 0),
568 (2, 1, 'Centurion', '2013-08-29 08:22:14', NULL, 0),
569 (3, 1, 'Randburg', '2013-08-29 08:22:14', NULL, 0),
570 (4, 2, 'Durban', '2013-08-29 08:22:14', NULL, 0),
571 (5, 2, 'Port Elizabeth', '2013-08-29 08:22:14', NULL, 0),
572 (6, 2, 'Balito', '2013-08-29 08:22:14', NULL, 0),
573 (7, 3, 'Knysna', '2013-08-29 08:22:14', NULL, 0),
574 (8, 4, 'Middle of Nowhere', '2013-08-29 08:22:14', NULL, 0),
575 (9, 4, 'Close to Nowhere', '2013-08-29 08:22:14', NULL, 0),
576 (10, 5, 'Somewhere', '2013-08-29 08:22:14', NULL, 0),
577 (11, 5, 'Neverwhere', '2013-08-29 08:22:15', NULL, 0);
578
579 -- --------------------------------------------------------
580
581 --
582 -- Table structure for table `lib_contact`
583 --
584
585 DROP TABLE IF EXISTS `lib_contact`;
586 CREATE TABLE IF NOT EXISTS `lib_contact` (
587   `id` int(11) NOT NULL AUTO_INCREMENT,
588   `first_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
589   `family_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
590   `mobile` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
591   `office` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
592   `fax` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
593   `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
594   `archived` tinyint(1) NOT NULL,
595   PRIMARY KEY (`id`)
596 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
597
598 --
599 -- Dumping data for table `lib_contact`
600 --
601
602 INSERT INTO `lib_contact` (`id`, `first_name`, `family_name`, `mobile`, `office`, `fax`, `email`, `archived`) VALUES
603 (1, 'Jack', 'Trader', '+27821234567', '+27111234567', NULL, 'a@imperial.com', 0),
604 (2, 'Dave', 'Thomas', '+27833248462', '+27123248462', NULL, 'dave@bid4cars.co.za', 0),
605 (3, 'Byron', 'Stephenson', '+27826039258', '+27126039258', NULL, 'bstephenson@cargomotors.co.za', 0);
606
607 -- --------------------------------------------------------
608
609 --
610 -- Table structure for table `lib_country`
611 --
612
613 DROP TABLE IF EXISTS `lib_country`;
614 CREATE TABLE IF NOT EXISTS `lib_country` (
615   `id` int(11) NOT NULL AUTO_INCREMENT,
616   `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
617   `country_code_iso` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
618   `country_code_fips` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
619   `dialing_code` smallint(6) DEFAULT NULL,
620   `archived` tinyint(1) NOT NULL,
621   PRIMARY KEY (`id`),
622   UNIQUE KEY `UNIQ_2C37C4F95E237E06` (`name`)
623 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
624
625 --
626 -- Dumping data for table `lib_country`
627 --
628
629 INSERT INTO `lib_country` (`id`, `name`, `country_code_iso`, `country_code_fips`, `dialing_code`, `archived`) VALUES
630 (1, 'South Africa', NULL, NULL, NULL, 0),
631 (2, 'Australia', NULL, NULL, NULL, 0);
632
633 -- --------------------------------------------------------
634
635 --
636 -- Table structure for table `lib_debug_log`
637 --
638
639 DROP TABLE IF EXISTS `lib_debug_log`;
640 CREATE TABLE IF NOT EXISTS `lib_debug_log` (
641   `id` int(11) NOT NULL AUTO_INCREMENT,
642   `profile_id` int(11) DEFAULT NULL,
643   `call_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
644   `parameters` longtext COLLATE utf8_unicode_ci NOT NULL,
645   `error_string` longtext COLLATE utf8_unicode_ci NOT NULL,
646   `created` datetime NOT NULL,
647   PRIMARY KEY (`id`)
648 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
649
650 -- --------------------------------------------------------
651
652 --
653 -- Table structure for table `lib_document`
654 --
655
656 DROP TABLE IF EXISTS `lib_document`;
657 CREATE TABLE IF NOT EXISTS `lib_document` (
658   `id` int(11) NOT NULL AUTO_INCREMENT,
659   `filename` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
660   `mime_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
661   `downloads` int(11) NOT NULL,
662   `created` datetime NOT NULL,
663   `archived` tinyint(1) NOT NULL,
664   PRIMARY KEY (`id`)
665 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
666
667 -- --------------------------------------------------------
668
669 --
670 -- Table structure for table `lib_newsletter`
671 --
672
673 DROP TABLE IF EXISTS `lib_newsletter`;
674 CREATE TABLE IF NOT EXISTS `lib_newsletter` (
675   `id` int(11) NOT NULL AUTO_INCREMENT,
676   `lib_attachment_id` int(11) DEFAULT NULL,
677   `subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
678   `content` longtext COLLATE utf8_unicode_ci NOT NULL,
679   `status` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
680   `sent_to` int(11) NOT NULL,
681   `created` datetime NOT NULL,
682   `updated` datetime DEFAULT NULL,
683   `archived` tinyint(1) NOT NULL,
684   PRIMARY KEY (`id`),
685   KEY `IDX_4CD581BE5B1F66AB` (`lib_attachment_id`)
686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
687
688 -- --------------------------------------------------------
689
690 --
691 -- Table structure for table `lib_notification_log`
692 --
693
694 DROP TABLE IF EXISTS `lib_notification_log`;
695 CREATE TABLE IF NOT EXISTS `lib_notification_log` (
696   `id` int(11) NOT NULL AUTO_INCREMENT,
697   `from_company_id` int(11) DEFAULT NULL,
698   `from_profile_id` int(11) DEFAULT NULL,
699   `to_company_id` int(11) DEFAULT NULL,
700   `to_profile_id` int(11) DEFAULT NULL,
701   `email_to` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
702   `email_subject` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
703   `email_body` longtext COLLATE utf8_unicode_ci NOT NULL,
704   `sms_to` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
705   `sms_body` longtext COLLATE utf8_unicode_ci NOT NULL,
706   `api_msg_id` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
707   `sms_status` int(11) DEFAULT NULL,
708   `created` datetime NOT NULL,
709   `updated` datetime DEFAULT NULL,
710   `archived` tinyint(1) NOT NULL,
711   PRIMARY KEY (`id`),
712   KEY `IDX_CAC82BB2BC3FDCD1` (`from_company_id`),
713   KEY `IDX_CAC82BB2E75ED4BF` (`from_profile_id`),
714   KEY `IDX_CAC82BB2B0A8F8AB` (`to_company_id`),
715   KEY `IDX_CAC82BB2EBC9F0C5` (`to_profile_id`)
716 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
717
718 -- --------------------------------------------------------
719
720 --
721 -- Table structure for table `lib_photo`
722 --
723
724 DROP TABLE IF EXISTS `lib_photo`;
725 CREATE TABLE IF NOT EXISTS `lib_photo` (
726   `id` int(11) NOT NULL AUTO_INCREMENT,
727   `filename` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
728   `mime_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
729   `archived` tinyint(1) NOT NULL,
730   PRIMARY KEY (`id`)
731 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
732
733 -- --------------------------------------------------------
734
735 --
736 -- Table structure for table `lib_region`
737 --
738
739 DROP TABLE IF EXISTS `lib_region`;
740 CREATE TABLE IF NOT EXISTS `lib_region` (
741   `id` int(11) NOT NULL AUTO_INCREMENT,
742   `lib_country_id` int(11) DEFAULT NULL,
743   `name` varchar(75) COLLATE utf8_unicode_ci NOT NULL,
744   `iso3166_2_code` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
745   `fips10_4_code` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
746   `archived` tinyint(1) NOT NULL,
747   PRIMARY KEY (`id`),
748   KEY `IDX_2162D53ACB7F3A06` (`lib_country_id`)
749 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
750
751 --
752 -- Dumping data for table `lib_region`
753 --
754
755 INSERT INTO `lib_region` (`id`, `lib_country_id`, `name`, `iso3166_2_code`, `fips10_4_code`, `archived`) VALUES
756 (1, 1, 'Gauteng', NULL, NULL, 0),
757 (2, 1, 'Natal', NULL, NULL, 0),
758 (3, 1, 'Eastern Cape', NULL, NULL, 0),
759 (4, 2, 'The South', NULL, NULL, 0),
760 (5, 2, 'The North', NULL, NULL, 0);
761
762 -- --------------------------------------------------------
763
764 --
765 -- Table structure for table `lib_repeater_template`
766 --
767
768 DROP TABLE IF EXISTS `lib_repeater_template`;
769 CREATE TABLE IF NOT EXISTS `lib_repeater_template` (
770   `id` int(11) NOT NULL AUTO_INCREMENT,
771   `group_field` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
772   `group_repeater` longtext COLLATE utf8_unicode_ci NOT NULL,
773   `row_repeater_odd` longtext COLLATE utf8_unicode_ci NOT NULL,
774   `row_repeater_even` longtext COLLATE utf8_unicode_ci NOT NULL,
775   PRIMARY KEY (`id`)
776 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
777
778 -- --------------------------------------------------------
779
780 --
781 -- Table structure for table `lib_template`
782 --
783
784 DROP TABLE IF EXISTS `lib_template`;
785 CREATE TABLE IF NOT EXISTS `lib_template` (
786   `id` int(11) NOT NULL AUTO_INCREMENT,
787   `lib_repeater_template_id` int(11) DEFAULT NULL,
788   `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
789   `subject` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
790   `tags` longtext COLLATE utf8_unicode_ci NOT NULL,
791   `email_template` longtext COLLATE utf8_unicode_ci NOT NULL,
792   `sms_template` longtext COLLATE utf8_unicode_ci NOT NULL,
793   PRIMARY KEY (`id`),
794   UNIQUE KEY `UNIQ_F7AFD55B5E237E06` (`name`),
795   UNIQUE KEY `UNIQ_F7AFD55B34F09D60` (`lib_repeater_template_id`)
796 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ;
797
798 --
799 -- Dumping data for table `lib_template`
800 --
801
802 INSERT INTO `lib_template` (`id`, `lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES
803 (1, NULL, 'auction-no-sale', 'No winner on Bid4Cars Auction.', 'firstName,familyName,vehicle', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n   <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">No winner on Bid4Cars Auction</h1>\r\n                                                                           <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Unfortunately there were no bids on the following vehicle you loaded on Bid4Cars: [vehicle]\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      We encourage you to relist the vehicle (and amend details as required).\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                               <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
804 (2, NULL, 'auction-sale-admin', 'Auction Successful.', 'vehicle,seller,price,buyer', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n     <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n                                                                              <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       The auction for [vehicle] from [seller] finished with a winning bid of [price] from [buyer].\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                               <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
805 (3, NULL, 'auction-sale-buyer', 'Bid Successful.', 'firstName,familyName,vehicle,seller,price,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Bid Successful</h1>\r\n                                                                          <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].\r\n                                                                         </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      <b>Your responsibilities:</b>\r\n                      <ul>\r\n                        <li>Complete sale within two working days.</li>\r\n                        <li>Collect vehicle.</li>\r\n                        <li>Sign attachments when collecting vehicle.</li>\r\n                      </ul>\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      <b>Seller:</b>\r\n                      <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                        <tr>\r\n                          <td width="80px"><b>Trading Name:</b></td>\r\n                          <td><b>[seller]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Full Name:</b></td>\r\n                          <td><b>[seller_name]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Auction Address:</b></td>\r\n                          <td><b>[vehicle_address]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Billing Address:</b></td>\r\n                          <td><b>[seller_billing_address]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>VAT Number:</b></td>\r\n                          <td><b>[seller_vat_number]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>E-mail:</b></td>\r\n                          <td><b>[seller_email]</b></td>\r\n                        </tr>\r\n                      </table>\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;"><br/>\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                               <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', 'Congratulations! You have won [vehicle] on Bid4Cars for [price]. Please check your e-mail for more info.'),
806 (4, NULL, 'auction-sale-seller', 'Auction Successul.', 'firstName,familyName,vehicle,price,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n    <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n                                                                              <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Hello [first_name] [family_name],\r\n                                                                           </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      <b>Your responsibilities:</b>\r\n                      <ul>\r\n                        <li>Invoice vehicle.</li>\r\n                        <li>Send Natis, invoice and bank details.</li>\r\n                        <li>Have vehicle ready for collection.</li>\r\n                        <li>Print attachments.</li>\r\n                      </ul>\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      <b>Buyer:</b>\r\n                      <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                        <tr>\r\n                          <td width="80px"><b>Trading Name:</b></td>\r\n                          <td><b>[buyer]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Full Name:</b></td>\r\n                          <td><b>[buyer_name]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Physical Address:</b></td>\r\n                          <td><b>[buyer_address]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>VAT Number:</b></td>\r\n                          <td><b>[buyer_vat_number]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>Cellphone:</b></td>\r\n                          <td><b>[buyer_mobile]</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td width="80px"><b>E-mail:</b></td>\r\n                          <td><b>[buyer_email]</b></td>\r\n                        </tr>\r\n                      </table>\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;"><br/>\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                               <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', 'Congratulations! [vehicle] has been sold on Bid4Cars for [price]. Please check your e-mail and complete the necessary documentation.'),
807 (5, NULL, 'auction-outbid', 'You have been outbid.', 'firstName,familyName,vehicle,seller,price,bid,auction_expiry_date', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">You have been outbid on [vehicle]</h1>\r\n                                                                               <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      You have been outbid on the following vehicle: [vehicle] from [seller], next minimum bid is [price].\r\n                      Your bid of [bid] is no longer in the leading bid. The auction ends [auction_expiry_date].\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Best of luck,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                               <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', 'You have been outbid on [vehicle], next minimum bid is [price]. Click here http://bid4cars.co.za/bid to continue bidding.'),
808 (6, NULL, 'auction-question', 'Stock Question.', 'first_name,family_name,dealer,vehicle,question', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Question</h1>\r\n                                                                          <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       You have a question from [dealer] concerning vehicle [vehicle].\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       <b>Question:</b> [question]\r\n                                                                         </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       You can reply to the question in <i>My settings</i> page.\r\n                                                                           </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                              <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n                                                                           <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     If you have any questions please feel free to contact us for assistance.\r\n                                                                            </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            &nbsp;\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
809 (7, NULL, 'auction-reply', 'Stock Reply.', 'first_name,family_name,dealer,vehicle,question,reply', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Reply</h1>\r\n                                                                             <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [first_name] [family_name],\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Your question to [dealer] concerning vehicle [vehicle] have received a reply.\r\n                                                                               </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       <b>Question:</b> [question]\r\n                                                                         </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       <b>Reply:</b> [reply]\r\n                                                                               </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                            <p style="margin:0 0 1em;padding:0;">\r\n                                                         Regards,<br/>\r\n                                                       The Bid4Cars Team\r\n                                                         </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                              <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n                                                                           <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     If you have any questions please feel free to contact us for assistance.\r\n                                                                            </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            &nbsp;\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
810 (8, NULL, 'forgot-pin', 'Your pin was reset on the Bid 4 Cars website.', 'firstName,familyName,email,pin', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Pin Reset</h1>\r\n                                                                               <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Your pin was reset on the Bid 4 Cars website.\r\n                                                                                       Here is your new login details:\r\n                                                                                     <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td width="80px"><b>Username:</b></td>\r\n                                                                                                      <td><b>[email]</b></td>\r\n                                                                                             </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Pin:</b></td>\r\n                                                                                                        <td><b>[pin]</b></td>\r\n                                                                                               </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To login please go to <i><a href="{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/reset-button.jpg" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                         <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Reset</h2>\r\n                                                                                <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Please remember to change your pin once logged in.\r\n                                                                          </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', 'Your new pin is [pin]. Details also sent via email.'),
811 (9, NULL, 'valuation-mobile-new', 'New mobile valuation.', 'firstName,familyName,vehicle_reg,customer_name, customer_family_name', '', '[firstName] [familyName] requested a valuation on [vehicle_reg], for [customer_name] [customer_family_name].'),
812 (10, NULL, 'valuation-completed', 'Valuation Completed.', 'firstName,familyName,customer.name,customer.familyName,dateCreated,refNo,valNo,year,make,model,type,regNo,salesComments', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n     <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Valuation Completed</h1>\r\n                                                                             <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       your valuation for  [customer.name] [customer.familyName] has been completed.\r\n                                                                               </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       [dateCreated], [refNo], [valNo].\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Vehicle: [year], [make], [model], [type], [regNo]\r\n                                                                           </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">[salesComments]</p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', 'Your valuation for [customer.name] [customer.familyName], [regNo] was completed, please check your mail.');
813 INSERT INTO `lib_template` (`id`, `lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES
814 (11, NULL, 'club-stock-on-offer', 'We invite you to make an offer.', 'firstName,familyName,company.name,make.name,model.name,type.name,tradeRetail,link,seller', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Make an offer to [company.name]</h1>\r\n                                                                         <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n\r\n                                                                             We invite you to make an offer on the following vehicle:\r\n                                                                            <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                          <tr>\r\n                                                                  <td><b>Vehicle:</b></td>\r\n                                                            <td><b>[make.name], [model.name], [type.name]</b></td>\r\n                                                            </tr>\r\n                                                               [tradeRetail]\r\n                                                             </table>\r\n                                                                              </p>\r\n                                                            <p style="margin:0 0 1em;padding:0;">\r\n                                                         &nbsp;\r\n                                                            </p>\r\n                                                        <p style="margin:0 0 1em;padding:0;">\r\n                                                         To make an offer please click here <i><a href="{APP_HOST}[link]">{APP_HOST}[link]</a></i>\r\n                                                         </p>\r\n                                                        <p style="margin:0 0 1em;padding:0;">\r\n                                                         &nbsp;\r\n                                                            </p>\r\n                                                        <p style="margin:0 0 1em;padding:0;">\r\n                                                         We hope to have the pleasure of doing business with you,<br/>\r\n                                                       [seller]\r\n                                                          </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', '[make.name] [type.name]. {APP_HOST}[link]\r\n\r\n'),
815 (12, NULL, 'club-invite-accepted', 'Bid4cars: New club member.', 'firstName,familyName,clubName,clubType,dealer,dealer.contactFirstName,dealer.contactFamilyName', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New club member</h1>\r\n                                                                         <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                 The following recipient has accepted your invitation to become a member of the [clubName] [clubType]:\r\n                                                                                     <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td><b>[dealer]</b></td>\r\n                                                                                            </tr>\r\n                        <tr>\r\n                          <td><b>[dealer.contactFirstName] [dealer.contactFamilyName]</b></td>\r\n                        </tr>\r\n                                                                                    </table>\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      &nbsp;\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
816 (13, NULL, 'club-membership-revoked', 'Bid4cars: Club membership revoked.', 'firstName,familyName,dealer,clubName,reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Club membership revoked.</h1>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                 We regret to inform you that [dealer] has removed you from [clubName]. The following reasons were provided:\r\n                                                                                       <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td><b>[reason]</b></td>\r\n                                                                                            </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      &nbsp;\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
817 (14, NULL, 'club-invite-registered', 'Bid4cars: Club membership invite.', 'firstName,familyName,clubType,dealer,contact.name,contact.familyName,contact.email,contact.cell', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n     <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                             </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Club membership invite</h1>\r\n                                                                          <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                 We at [dealer] would like to invite you to join our exclusive Bid4Cars [clubType].\r\n                      By becoming a member, you will receive the following benefits:\r\n                                                                                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td><b>Receive exclusive offers.</b></td>\r\n                                                                                           </tr>\r\n                        <tr>\r\n                          <td><b>Small high-value trading base.</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td><b>Quick turn-around.</b></td>\r\n                        </tr>\r\n                        <tr>\r\n                          <td><b>Get notified of accepted offers within 7 days.</b></td>\r\n                        </tr>\r\n                                                                                    </table>\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      &nbsp;\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      To accept this offer please login on Bid4Cars and find your invitation under My Settings &gt; Club membership invites.\r\n                    </p>\r\n                                                                              <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n                                                                             </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      [dealer],<br/>\r\n                      [contact.name] [contact.familyName],<br/>\r\n                      [contact.email],<br/>\r\n                      [contact.cell]\r\n                    </p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
818 (15, NULL, 'stock-not-sold', 'Stock not yet sold.', 'firstName,familyName,make.name,model.name,days', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n    <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock not yet sold</h1>\r\n                                                                              <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Vehicle [make.name] [model.name] has not yet been sold in the [days] days since it was added to your stock list.\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
819 (16, NULL, 'general', 'Bid4Cars email.', 'body', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px">\r\n                                                        [body]\r\n                                              </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
820 (17, NULL, 'contact-rquest', 'Bid4Cars contact request.', 'personName,tradingName,email,mobile,telephone,subject,message', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n       <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Action Required</h1>\r\n                                                                         <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       You have a new contact request from the website. Details are as follows:\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td width="150px"><b>Person:</b></td>\r\n                                                                                                       <td>[personName]</td>\r\n                                                                                               </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Trading Name:</b></td>\r\n                                                                                                       <td>[tradingName]</td>\r\n                                                                                              </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Email Address:</b></td>\r\n                                                                                                      <td>[email]</td>\r\n                                                                                            </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Mobile Number:</b></td>\r\n                                                                                                      <td>[mobile]</td>\r\n                                                                                           </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Telephone Number:</b></td>\r\n                                                                                                   <td>[telephone]</td>\r\n                                                                                                </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Subject:</b></td>\r\n                                                                                                    <td>[subject]</td>\r\n                                                                                          </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td colspan="2"><b>Message:</b></td>\r\n                                                                                                </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td colspan="2">&nbsp;[message]</td>\r\n                                                                                                </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/contact.jpg" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                              <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Contact Request</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     A user filled in the contact form on the Bid4Cars website. \r\n                                                                                 To change the email addres that this notification is sent to \r\n                                                                                       please login as an Administrator and change the setting under\r\n                                                                                       General Settings &gt; Site Configuration.\r\n                                                                           </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
821 (18, NULL, 'welcome', 'Thank you for registering with Bid4Cars.', 'firstName,familyName', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Thank you for registering with Bid4Cars!</h1>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Thank you for taking the time to register as an official user on the Bid4Cars online vehicle management system\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      We have received your registration, and will be in touch with you shortly with the status of your application.\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Please be patient while your application is being processed. You will receive your username and PIN confirmation shortly.\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      We appreciate your patience as we complete the necessary formalities.\r\n                    </p>\r\n                                                                          <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
822 (19, NULL, 'activation-pending', 'Activation of your registration on Bid4Cars is still pending.', 'firstName,familyName,message', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Activation Pending</h1>\r\n                                                                              <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Activation of your registration on Bid4Cars is still pending.\r\n                                                                               </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       <b>Message:</b> [message]\r\n                                                                           </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>\r\n                                                                             <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            &nbsp;\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
823 (20, NULL, 'registration-pending', 'Your application was flagged as pending.', 'firstName,familyName,status_reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n     <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Registration Pending</h1>\r\n                                                                            <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Your application was flagged as pending for the following reason:\r\n                                                                           </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       [status_reason]\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       You will be notified via email if your application is either approved or declined.\r\n                                                                          </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                              <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n                                                                           <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     If you have any questions please feel free to contact us for assistance.\r\n                                                                            </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="380" valign="top" align="right" style="width:380px;">\r\n                                                                            Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', '');
824 INSERT INTO `lib_template` (`id`, `lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES
825 (21, NULL, 'registration-declined', 'Your application was declined.', 'firstName,familyName,status_reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n      <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->                                      \r\n                            <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>                           \r\n                                    <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Registration Declined</h1>\r\n                                                                           <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Your application was declined for the following reason:\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       [status_reason]\r\n                                                                             </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/noaccess.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                             <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Have we made an error?</h2>\r\n                                                                               <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     If you feel that we have made a mistake please contact us with the\r\n                                                                                  relevant details so that we can have another look.\r\n                                                                          </p>                    \r\n                                                                    </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->                    \r\n                                            </td>           \r\n                                    </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n                                                                      </td>\r\n                                                                       <!-- Spacing Column -->                                                         \r\n                                                                    <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->      \r\n                                            </td>\r\n                                       </tr>                           \r\n                            </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->  \r\n</body>\r\n</html>\r\n', ''),
826 (22, NULL, 'registration-success', 'Congratulations, your registration has been approved!', 'firstName,familyName,email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n        <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Congratulations, your registration has been approved!</h1>\r\n                                                                           <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Hello again [firstName] [familyName], and a very warm welcome!\r\n                                                                              </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Congratulations! We are delighted to advise you that your application as an official user of the Bid4Cars online vehicle management system has been approved.\r\n                    </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      To log in to your account, please click on the link below and enter the username and PIN provided.\r\n                    </p>\r\n                                                                           <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Here are your login details:\r\n                                                                                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td width="80px"><b>Username:</b></td>\r\n                                                                                                      <td><b>[email]</b></td>\r\n                                                                                             </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Pin:</b></td>\r\n                                                                                                        <td><b><i>* As entered on registration</i></b></td>\r\n                                                                                         </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n                                                                          </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       We look forward to interacting with you online,<br/>\r\n                                                                                        The Bid4Cars Team\r\n                                                                           </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
827 (23, NULL, 'new-profile-recipient', 'Profile created/updated', 'firstName,familyName,email,pin', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Profile created/updated</h1>\r\n                                                                         <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                 A profile was registered/updated for you on the Bid4Cars website.\r\n                                                                                 Here are your login details:\r\n                                                                                        <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td width="80px"><b>Username:</b></td>\r\n                                                                                                      <td><b>[email]</b></td>\r\n                                                                                             </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td><b>Pin:</b></td>\r\n                                                                                                        <td><b>[pin]</b></td>\r\n                                                                                               </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n                                                                          </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       And to help you get going please have a look at the FAQ''s <i><a href="http://{APP_HOST}/#/faq">{APP_HOST}/#/index/faq</a></i>\r\n                                                                              </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                            <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n                                                                              <p style="margin:0 0 1em;padding:5px;">\r\n                                                                                     Online technology bringing buyers and sellers\r\n                                                                                       together through the Dealer Network.\r\n                                                                                </p>\r\n                                                                        </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                         </tr>\r\n                                                       </table>\r\n                                                    <!-- /Main Content Table -->\r\n                                                </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#ececec;padding:10px 0 0;">\r\n                                                   <!-- Begin Footer table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n                                                                  </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;&nbsp;</td>\r\n                                                           </tr>\r\n                                                       </table>\r\n                                                    <!-- /End Footer Table -->\r\n                                          </td>\r\n                                       </tr>\r\n                               </table>\r\n                            <!-- /End Main Template Table -->\r\n                   </td>\r\n               </tr>\r\n       </table>\r\n<!-- /End 100% Wrapping Table  -->\r\n</body>\r\n</html>\r\n', ''),
828 (24, NULL, 'new-profile-admin-notification', 'Profile created/updated by user', 'firstName,familyName,company.firstName,company.familyName,profile.name,company.name,profile.familyName,email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n  <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n       <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n    <!-- Begin 100% Wrapping Table -->\r\n  <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n           <tr>\r\n                        <td style="padding:20px 0;">\r\n                                <!-- Begin Main Template Table -->\r\n                          <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n                                        <tr>\r\n                                                <td>\r\n                                                <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n                                            </td>\r\n                                       </tr>\r\n                                       <tr>\r\n                                                <td style="background:#f6f6f6;padding:20px 0">\r\n                                                      <!-- Main Content table -->\r\n                                                 <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                <tr>\r\n                                                                        <!-- Spacing Column -->\r\n                                                                     <td width="20" valign="top" style="width:20px;">&nbsp;</td>\r\n                                                                 <!-- Main Column -->\r\n                                                                        <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Profile created/updated</h1>\r\n                                                                         <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       Dear [firstName] [familyName],\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                 [company.firstName] [company.familyName] from [company.name] has just registered/updated a profile for:\r\n                                                                                   <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                                            <tr>\r\n                                                                                                        <td width="80px"><b>Name:</b></td>\r\n                                                                                                  <td><b>[profile.name]</b></td>\r\n                                                                                              </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td width="80px"><b>Family name:</b></td>\r\n                                                                                                   <td><b>[profile.familyName]</b></td>\r\n                                                                                                </tr>\r\n                                                                                               <tr>\r\n                                                                                                        <td width="80px"><b>Username:</b></td>\r\n                                                                                                      <td><b>[email]</b></td>\r\n                                                                                             </tr>\r\n                                                                                       </table>\r\n                                                                            </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       &nbsp;\r\n                                                                              </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n                                                                             </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n                                                                          </p>\r\n                                                                                <p style="margin:0 0 1em;padding:0;">\r\n                                                                                       And to help you get going please have a look at the FAQ''s <i><a href="http://{APP_HOST}/index/faq">{APP_HOST}/index/faq</a></i>\r\n                                                                            </p>\r\n                    <p style="margin:0 0 1em;padding:0;">\r\n                      Regards,<br/>\r\n                      The Bid4Cars Team\r\n                    </p>\r\n                                                                     </td>\r\n                                                                       <!-- Spacing Column -->\r\n                                                                     <td width="40" valign="top" style="width:40px;">&nbsp;</td>\r\n                                                                 <!-- Side Column -->\r\n                                                                        <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n                                                                          <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n                                                                   &nb