ELMRd99x

1DROP TABLE IF EXISTS tblaccounts;
2CREATE TABLE `tblaccounts` (
3  `userid` int(10) NOT NULL,
4  `currency` int(10) NOT NULL,
5  `gateway` text NOT NULL,
6  `date` datetime DEFAULT NULL,
7  `description` text NOT NULL,
8  `amountin` decimal(10,2) NOT NULL DEFAULT '0.00',
9  `fees` decimal(10,2) NOT NULL DEFAULT '0.00',
10  `amountout` decimal(10,2) NOT NULL DEFAULT '0.00',
11  `rate` decimal(10,5) NOT NULL DEFAULT '1.00000',
12  `transid` text NOT NULL,
13  `invoiceid` int(10) NOT NULL DEFAULT '0',
14  `refundid` int(10) NOT NULL DEFAULT '0',
15  KEY `invoiceid` (`invoiceid`),
16  KEY `userid` (`userid`),
17  KEY `date` (`date`),
18  KEY `transid` (`transid`(32))
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21
22
23
24
25
26
27### tblaccounts TABLE DUMP COMPLETED ###
28
29
30DROP TABLE IF EXISTS tblactivitylog;
31CREATE TABLE `tblactivitylog` (
32  `id` int(10) NOT NULL AUTO_INCREMENT,
33  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
34  `description` text NOT NULL,
35  `user` text NOT NULL,
36  `userid` int(10) NOT NULL,
37  `ipaddr` text NOT NULL,
38  PRIMARY KEY (`id`)
39) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;
40
41INSERT INTO tblactivitylog VALUES('1', '2015-06-09 03:00:02', 'Cron Job: Starting', 'System', '0', '');
42INSERT INTO tblactivitylog VALUES('2', '2015-06-09 03:00:02', 'Cron Job: Starting Updating Currency Exchange Rates', 'System', '0', '');
43INSERT INTO tblactivitylog VALUES('3', '2015-06-09 03:00:02', 'Cron Job: Done', 'System', '0', '');
44INSERT INTO tblactivitylog VALUES('4', '2015-06-09 03:00:02', 'Cron Job: Starting Generating Invoices', 'System', '0', '');
45INSERT INTO tblactivitylog VALUES('5', '2015-06-09 03:00:02', 'Cron Job: 0 Invoices Created', 'System', '0', '');
46INSERT INTO tblactivitylog VALUES('6', '2015-06-09 03:00:02', 'Cron Job: Starting Applying Late Fees', 'System', '0', '');
47INSERT INTO tblactivitylog VALUES('7', '2015-06-09 03:00:02', 'Cron Job: Late Invoice Fees added to 0 Invoices', 'System', '0', '');
48INSERT INTO tblactivitylog VALUES('8', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Credit Card Charges', 'System', '0', '');
49INSERT INTO tblactivitylog VALUES('9', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Invoice Reminder Notices', 'System', '0', '');
50INSERT INTO tblactivitylog VALUES('10', '2015-06-09 03:00:02', 'Cron Job: Sent 0 Unpaid Invoice Payment Reminders', 'System', '0', '');
51INSERT INTO tblactivitylog VALUES('11', '2015-06-09 03:00:02', 'Cron Job: Sent 0 Reminders', 'System', '0', '');
52INSERT INTO tblactivitylog VALUES('12', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Domain Renewal Notices', 'System', '0', '');
53INSERT INTO tblactivitylog VALUES('13', '2015-06-09 03:00:02', 'Cron Job: Sent 0 Notices', 'System', '0', '');
54INSERT INTO tblactivitylog VALUES('14', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Cancellation Requests', 'System', '0', '');
55INSERT INTO tblactivitylog VALUES('15', '2015-06-09 03:00:02', 'Cron Job: Processed 0 Cancellations', 'System', '0', '');
56INSERT INTO tblactivitylog VALUES('16', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Overdue Suspensions', 'System', '0', '');
57INSERT INTO tblactivitylog VALUES('17', '2015-06-09 03:00:02', 'Cron Job: Processed 0 Suspensions', 'System', '0', '');
58INSERT INTO tblactivitylog VALUES('18', '2015-06-09 03:00:02', 'Cron Job: Starting Performing Automated Fixed Term Service Terminations', 'System', '0', '');
59INSERT INTO tblactivitylog VALUES('19', '2015-06-09 03:00:02', 'Cron Job: Processed 0 Terminations', 'System', '0', '');
60INSERT INTO tblactivitylog VALUES('20', '2015-06-09 03:00:02', 'Cron Job: Starting Auto Closing Inactive Tickets', 'System', '0', '');
61INSERT INTO tblactivitylog VALUES('21', '2015-06-09 03:00:02', 'Cron Job: Starting Processing Email Marketer Rules', 'System', '0', '');
62INSERT INTO tblactivitylog VALUES('22', '2015-06-09 03:00:02', 'Cron Job: Starting Updating Disk & Bandwidth Usage Stats', 'System', '0', '');
63INSERT INTO tblactivitylog VALUES('23', '2015-06-09 03:00:02', 'Cron Job: Done', 'System', '0', '');
64INSERT INTO tblactivitylog VALUES('24', '2015-06-09 03:00:02', 'Cron Job: Starting Performing Client Status Sync', 'System', '0', '');
65INSERT INTO tblactivitylog VALUES('25', '2015-06-09 03:00:02', 'Cron Job: Done', 'System', '0', '');
66INSERT INTO tblactivitylog VALUES('26', '2015-06-09 03:00:03', 'Cron Job: Completed', 'System', '0', '');
67INSERT INTO tblactivitylog VALUES('27', '2015-06-09 03:00:03', 'Cron Job: Starting Database Backup', 'System', '0', '');
68INSERT INTO tblactivitylog VALUES('28', '2015-06-09 18:18:07', 'Failed Admin Login Attempt - Username: Vinicius', 'System', '0', '179.197.72.11');
69INSERT INTO tblactivitylog VALUES('29', '2015-06-10 02:08:27', 'Created Client Habblack Hotel - User ID: 1', 'System', '0', '189.28.157.24');
70INSERT INTO tblactivitylog VALUES('30', '2015-06-10 02:08:27', 'Email Sent to Habblack Hotel (Welcome) - User ID: 1', 'System', '1', '189.28.157.24');
71INSERT INTO tblactivitylog VALUES('31', '2015-06-10 03:00:03', 'Cron Job: Starting', 'System', '0', '');
72INSERT INTO tblactivitylog VALUES('32', '2015-06-10 03:00:03', 'Cron Job: Starting Updating Currency Exchange Rates', 'System', '0', '');
73INSERT INTO tblactivitylog VALUES('33', '2015-06-10 03:00:03', 'Cron Job: Done', 'System', '0', '');
74INSERT INTO tblactivitylog VALUES('34', '2015-06-10 03:00:03', 'Cron Job: Starting Generating Invoices', 'System', '0', '');
75INSERT INTO tblactivitylog VALUES('35', '2015-06-10 03:00:03', 'Cron Job: 0 Invoices Created', 'System', '0', '');
76INSERT INTO tblactivitylog VALUES('36', '2015-06-10 03:00:03', 'Cron Job: Starting Applying Late Fees', 'System', '0', '');
77INSERT INTO tblactivitylog VALUES('37', '2015-06-10 03:00:03', 'Cron Job: Late Invoice Fees added to 0 Invoices', 'System', '0', '');
78INSERT INTO tblactivitylog VALUES('38', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Credit Card Charges', 'System', '0', '');
79INSERT INTO tblactivitylog VALUES('39', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Invoice Reminder Notices', 'System', '0', '');
80INSERT INTO tblactivitylog VALUES('40', '2015-06-10 03:00:03', 'Cron Job: Sent 0 Unpaid Invoice Payment Reminders', 'System', '0', '');
81INSERT INTO tblactivitylog VALUES('41', '2015-06-10 03:00:03', 'Cron Job: Sent 0 Reminders', 'System', '0', '');
82INSERT INTO tblactivitylog VALUES('42', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Domain Renewal Notices', 'System', '0', '');
83INSERT INTO tblactivitylog VALUES('43', '2015-06-10 03:00:03', 'Cron Job: Sent 0 Notices', 'System', '0', '');
84INSERT INTO tblactivitylog VALUES('44', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Cancellation Requests', 'System', '0', '');
85INSERT INTO tblactivitylog VALUES('45', '2015-06-10 03:00:03', 'Cron Job: Processed 0 Cancellations', 'System', '0', '');
86INSERT INTO tblactivitylog VALUES('46', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Overdue Suspensions', 'System', '0', '');
87INSERT INTO tblactivitylog VALUES('47', '2015-06-10 03:00:03', 'Cron Job: Processed 0 Suspensions', 'System', '0', '');
88INSERT INTO tblactivitylog VALUES('48', '2015-06-10 03:00:03', 'Cron Job: Starting Performing Automated Fixed Term Service Terminations', 'System', '0', '');
89INSERT INTO tblactivitylog VALUES('49', '2015-06-10 03:00:03', 'Cron Job: Processed 0 Terminations', 'System', '0', '');
90INSERT INTO tblactivitylog VALUES('50', '2015-06-10 03:00:03', 'Cron Job: Starting Auto Closing Inactive Tickets', 'System', '0', '');
91INSERT INTO tblactivitylog VALUES('51', '2015-06-10 03:00:03', 'Cron Job: Starting Processing Email Marketer Rules', 'System', '0', '');
92INSERT INTO tblactivitylog VALUES('52', '2015-06-10 03:00:03', 'Cron Job: Starting Updating Disk & Bandwidth Usage Stats', 'System', '0', '');
93INSERT INTO tblactivitylog VALUES('53', '2015-06-10 03:00:03', 'Cron Job: Done', 'System', '0', '');
94INSERT INTO tblactivitylog VALUES('54', '2015-06-10 03:00:03', 'Cron Job: Starting Performing Client Status Sync', 'System', '0', '');
95INSERT INTO tblactivitylog VALUES('55', '2015-06-10 03:00:03', 'Cron Job: Done', 'System', '0', '');
96INSERT INTO tblactivitylog VALUES('56', '2015-06-10 03:00:03', 'Cron Job: Completed', 'System', '0', '');
97INSERT INTO tblactivitylog VALUES('57', '2015-06-10 03:00:04', 'Cron Job: Starting Database Backup', 'System', '0', '');
98
99
100
101
102
103
104### tblactivitylog TABLE DUMP COMPLETED ###
105
106
107DROP TABLE IF EXISTS tbladdonmodules;
108CREATE TABLE `tbladdonmodules` (
109  `module` text NOT NULL,
110  `setting` text NOT NULL,
111  `value` text NOT NULL
112) ENGINE=InnoDB DEFAULT CHARSET=utf8;
113
114
115
116
117
118
119
120### tbladdonmodules TABLE DUMP COMPLETED ###
121
122
123DROP TABLE IF EXISTS tbladdons;
124CREATE TABLE `tbladdons` (
125  `id` int(10) NOT NULL AUTO_INCREMENT,
126  `packages` text NOT NULL,
127  `name` text NOT NULL,
128  `description` text NOT NULL,
129  `billingcycle` text NOT NULL,
130  `tax` text NOT NULL,
131  `showorder` text NOT NULL,
132  `downloads` text NOT NULL,
133  `autoactivate` text NOT NULL,
134  `suspendproduct` text NOT NULL,
135  `welcomeemail` int(10) NOT NULL,
136  `weight` int(2) NOT NULL DEFAULT '0',
137  PRIMARY KEY (`id`),
138  KEY `name` (`name`(32))
139) ENGINE=InnoDB DEFAULT CHARSET=utf8;
140
141
142
143
144
145
146
147### tbladdons TABLE DUMP COMPLETED ###
148
149
150DROP TABLE IF EXISTS tbladminlog;
151CREATE TABLE `tbladminlog` (
152  `id` int(10) NOT NULL AUTO_INCREMENT,
153  `adminusername` text NOT NULL,
154  `logintime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
155  `logouttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
156  `ipaddress` text NOT NULL,
157  `sessionid` text NOT NULL,
158  `lastvisit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
159  PRIMARY KEY (`id`),
160  KEY `logouttime` (`logouttime`)
161) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
162
163INSERT INTO tbladminlog VALUES('1', 'Vinicius', '2015-06-09 00:41:22', '2015-06-09 18:18:24', '179.197.255.206', 'b05f6a6b4a49a2e2897a4c9bd1466fa3', '2015-06-09 00:49:34');
164INSERT INTO tbladminlog VALUES('2', 'Vinicius', '2015-06-09 18:18:24', '2015-06-09 18:31:02', '179.197.72.11', 'dd89947527d2352278ebd64d9ca0171f', '2015-06-09 18:30:59');
165
166
167
168
169
170
171### tbladminlog TABLE DUMP COMPLETED ###
172
173
174DROP TABLE IF EXISTS tbladminperms;
175CREATE TABLE `tbladminperms` (
176  `roleid` int(1) NOT NULL,
177  KEY `roleid_permid` (`roleid`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179
180INSERT INTO tbladminperms VALUES('1');
181INSERT INTO tbladminperms VALUES('1');
182INSERT INTO tbladminperms VALUES('1');
183INSERT INTO tbladminperms VALUES('1');
184INSERT INTO tbladminperms VALUES('1');
185INSERT INTO tbladminperms VALUES('1');
186INSERT INTO tbladminperms VALUES('1');
187INSERT INTO tbladminperms VALUES('1');
188INSERT INTO tbladminperms VALUES('1');
189INSERT INTO tbladminperms VALUES('1');
190INSERT INTO tbladminperms VALUES('1');
191INSERT INTO tbladminperms VALUES('1');
192INSERT INTO tbladminperms VALUES('1');
193INSERT INTO tbladminperms VALUES('1');
194INSERT INTO tbladminperms VALUES('1');
195INSERT INTO tbladminperms VALUES('1');
196INSERT INTO tbladminperms VALUES('1');
197INSERT INTO tbladminperms VALUES('1');
198INSERT INTO tbladminperms VALUES('1');
199INSERT INTO tbladminperms VALUES('1');
200INSERT INTO tbladminperms VALUES('1');
201INSERT INTO tbladminperms VALUES('1');
202INSERT INTO tbladminperms VALUES('1');
203INSERT INTO tbladminperms VALUES('1');
204INSERT INTO tbladminperms VALUES('1');
205INSERT INTO tbladminperms VALUES('1');
206INSERT INTO tbladminperms VALUES('1');
207INSERT INTO tbladminperms VALUES('1');
208INSERT INTO tbladminperms VALUES('1');
209INSERT INTO tbladminperms VALUES('1');
210INSERT INTO tbladminperms VALUES('1');
211INSERT INTO tbladminperms VALUES('1');
212INSERT INTO tbladminperms VALUES('1');
213INSERT INTO tbladminperms VALUES('1');
214INSERT INTO tbladminperms VALUES('1');
215INSERT INTO tbladminperms VALUES('1');
216INSERT INTO tbladminperms VALUES('1');
217INSERT INTO tbladminperms VALUES('1');
218INSERT INTO tbladminperms VALUES('1');
219INSERT INTO tbladminperms VALUES('1');
220INSERT INTO tbladminperms VALUES('1');
221INSERT INTO tbladminperms VALUES('1');
222INSERT INTO tbladminperms VALUES('1');
223INSERT INTO tbladminperms VALUES('1');
224INSERT INTO tbladminperms VALUES('1');
225INSERT INTO tbladminperms VALUES('1');
226INSERT INTO tbladminperms VALUES('1');
227INSERT INTO tbladminperms VALUES('1');
228INSERT INTO tbladminperms VALUES('1');
229INSERT INTO tbladminperms VALUES('1');
230INSERT INTO tbladminperms VALUES('1');
231INSERT INTO tbladminperms VALUES('1');
232INSERT INTO tbladminperms VALUES('1');
233INSERT INTO tbladminperms VALUES('1');
234INSERT INTO tbladminperms VALUES('1');
235INSERT INTO tbladminperms VALUES('1');
236INSERT INTO tbladminperms VALUES('1');
237INSERT INTO tbladminperms VALUES('1');
238INSERT INTO tbladminperms VALUES('1');
239INSERT INTO tbladminperms VALUES('1');
240INSERT INTO tbladminperms VALUES('1');
241INSERT INTO tbladminperms VALUES('1');
242INSERT INTO tbladminperms VALUES('1');
243INSERT INTO tbladminperms VALUES('1');
244INSERT INTO tbladminperms VALUES('1');
245INSERT INTO tbladminperms VALUES('1');
246INSERT INTO tbladminperms VALUES('1');
247INSERT INTO tbladminperms VALUES('1');
248INSERT INTO tbladminperms VALUES('1');
249INSERT INTO tbladminperms VALUES('1');
250INSERT INTO tbladminperms VALUES('1');
251INSERT INTO tbladminperms VALUES('1');
252INSERT INTO tbladminperms VALUES('1');
253INSERT INTO tbladminperms VALUES('1');
254INSERT INTO tbladminperms VALUES('1');
255INSERT INTO tbladminperms VALUES('1');
256INSERT INTO tbladminperms VALUES('1');
257INSERT INTO tbladminperms VALUES('1');
258INSERT INTO tbladminperms VALUES('1');
259INSERT INTO tbladminperms VALUES('1');
260INSERT INTO tbladminperms VALUES('1');
261INSERT INTO tbladminperms VALUES('1');
262INSERT INTO tbladminperms VALUES('1');
263INSERT INTO tbladminperms VALUES('1');
264INSERT INTO tbladminperms VALUES('1');
265INSERT INTO tbladminperms VALUES('1');
266INSERT INTO tbladminperms VALUES('1');
267INSERT INTO tbladminperms VALUES('1');
268INSERT INTO tbladminperms VALUES('1');
269INSERT INTO tbladminperms VALUES('1');
270INSERT INTO tbladminperms VALUES('1');
271INSERT INTO tbladminperms VALUES('1');
272INSERT INTO tbladminperms VALUES('1');
273INSERT INTO tbladminperms VALUES('1');
274INSERT INTO tbladminperms VALUES('1');
275INSERT INTO tbladminperms VALUES('1');
276INSERT INTO tbladminperms VALUES('1');
277INSERT INTO tbladminperms VALUES('1');
278INSERT INTO tbladminperms VALUES('1');
279INSERT INTO tbladminperms VALUES('1');
280INSERT INTO tbladminperms VALUES('1');
281INSERT INTO tbladminperms VALUES('1');
282INSERT INTO tbladminperms VALUES('1');
283INSERT INTO tbladminperms VALUES('1');
284INSERT INTO tbladminperms VALUES('1');
285INSERT INTO tbladminperms VALUES('1');
286INSERT INTO tbladminperms VALUES('1');
287INSERT INTO tbladminperms VALUES('1');
288INSERT INTO tbladminperms VALUES('1');
289INSERT INTO tbladminperms VALUES('1');
290INSERT INTO tbladminperms VALUES('1');
291INSERT INTO tbladminperms VALUES('1');
292INSERT INTO tbladminperms VALUES('1');
293INSERT INTO tbladminperms VALUES('1');
294INSERT INTO tbladminperms VALUES('1');
295INSERT INTO tbladminperms VALUES('1');
296INSERT INTO tbladminperms VALUES('1');
297INSERT INTO tbladminperms VALUES('1');
298INSERT INTO tbladminperms VALUES('1');
299INSERT INTO tbladminperms VALUES('1');
300INSERT INTO tbladminperms VALUES('1');
301INSERT INTO tbladminperms VALUES('1');
302INSERT INTO tbladminperms VALUES('1');
303INSERT INTO tbladminperms VALUES('1');
304INSERT INTO tbladminperms VALUES('1');
305INSERT INTO tbladminperms VALUES('1');
306INSERT INTO tbladminperms VALUES('1');
307INSERT INTO tbladminperms VALUES('1');
308INSERT INTO tbladminperms VALUES('1');
309INSERT INTO tbladminperms VALUES('1');
310INSERT INTO tbladminperms VALUES('2');
311INSERT INTO tbladminperms VALUES('2');
312INSERT INTO tbladminperms VALUES('2');
313INSERT INTO tbladminperms VALUES('2');
314INSERT INTO tbladminperms VALUES('2');
315INSERT INTO tbladminperms VALUES('2');
316INSERT INTO tbladminperms VALUES('2');
317INSERT INTO tbladminperms VALUES('2');
318INSERT INTO tbladminperms VALUES('2');
319INSERT INTO tbladminperms VALUES('2');
320INSERT INTO tbladminperms VALUES('2');
321INSERT INTO tbladminperms VALUES('2');
322INSERT INTO tbladminperms VALUES('2');
323INSERT INTO tbladminperms VALUES('2');
324INSERT INTO tbladminperms VALUES('2');
325INSERT INTO tbladminperms VALUES('2');
326INSERT INTO tbladminperms VALUES('2');
327INSERT INTO tbladminperms VALUES('2');
328INSERT INTO tbladminperms VALUES('2');
329INSERT INTO tbladminperms VALUES('2');
330INSERT INTO tbladminperms VALUES('2');
331INSERT INTO tbladminperms VALUES('2');
332INSERT INTO tbladminperms VALUES('2');
333INSERT INTO tbladminperms VALUES('2');
334INSERT INTO tbladminperms VALUES('2');
335INSERT INTO tbladminperms VALUES('2');
336INSERT INTO tbladminperms VALUES('2');
337INSERT INTO tbladminperms VALUES('2');
338INSERT INTO tbladminperms VALUES('2');
339INSERT INTO tbladminperms VALUES('2');
340INSERT INTO tbladminperms VALUES('2');
341INSERT INTO tbladminperms VALUES('2');
342INSERT INTO tbladminperms VALUES('2');
343INSERT INTO tbladminperms VALUES('2');
344INSERT INTO tbladminperms VALUES('2');
345INSERT INTO tbladminperms VALUES('2');
346INSERT INTO tbladminperms VALUES('2');
347INSERT INTO tbladminperms VALUES('2');
348INSERT INTO tbladminperms VALUES('2');
349INSERT INTO tbladminperms VALUES('2');
350INSERT INTO tbladminperms VALUES('2');
351INSERT INTO tbladminperms VALUES('2');
352INSERT INTO tbladminperms VALUES('2');
353INSERT INTO tbladminperms VALUES('2');
354INSERT INTO tbladminperms VALUES('2');
355INSERT INTO tbladminperms VALUES('2');
356INSERT INTO tbladminperms VALUES('2');
357INSERT INTO tbladminperms VALUES('2');
358INSERT INTO tbladminperms VALUES('2');
359INSERT INTO tbladminperms VALUES('2');
360INSERT INTO tbladminperms VALUES('2');
361INSERT INTO tbladminperms VALUES('2');
362INSERT INTO tbladminperms VALUES('2');
363INSERT INTO tbladminperms VALUES('2');
364INSERT INTO tbladminperms VALUES('2');
365INSERT INTO tbladminperms VALUES('2');
366INSERT INTO tbladminperms VALUES('2');
367INSERT INTO tbladminperms VALUES('2');
368INSERT INTO tbladminperms VALUES('2');
369INSERT INTO tbladminperms VALUES('2');
370INSERT INTO tbladminperms VALUES('2');
371INSERT INTO tbladminperms VALUES('2');
372INSERT INTO tbladminperms VALUES('2');
373INSERT INTO tbladminperms VALUES('2');
374INSERT INTO tbladminperms VALUES('2');
375INSERT INTO tbladminperms VALUES('2');
376INSERT INTO tbladminperms VALUES('2');
377INSERT INTO tbladminperms VALUES('2');
378INSERT INTO tbladminperms VALUES('2');
379INSERT INTO tbladminperms VALUES('2');
380INSERT INTO tbladminperms VALUES('3');
381INSERT INTO tbladminperms VALUES('3');
382INSERT INTO tbladminperms VALUES('3');
383INSERT INTO tbladminperms VALUES('3');
384INSERT INTO tbladminperms VALUES('3');
385INSERT INTO tbladminperms VALUES('3');
386INSERT INTO tbladminperms VALUES('3');
387INSERT INTO tbladminperms VALUES('3');
388INSERT INTO tbladminperms VALUES('3');
389INSERT INTO tbladminperms VALUES('3');
390INSERT INTO tbladminperms VALUES('3');
391INSERT INTO tbladminperms VALUES('3');
392INSERT INTO tbladminperms VALUES('3');
393
394
395
396
397
398
399### tbladminperms TABLE DUMP COMPLETED ###
400
401
402DROP TABLE IF EXISTS tbladminroles;
403CREATE TABLE `tbladminroles` (
404  `id` int(1) NOT NULL AUTO_INCREMENT,
405  `name` text NOT NULL,
406  `widgets` text NOT NULL,
407  `systememails` int(1) NOT NULL,
408  `accountemails` int(1) NOT NULL,
409  `supportemails` int(1) NOT NULL,
410  PRIMARY KEY (`id`)
411) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
412
413INSERT INTO tbladminroles VALUES('1', 'Full Administrator', 'activity_log,getting_started,income_forecast,income_overview,my_notes,network_status,open_invoices,orders_overview,paypal_addon,admin_activity,client_activity,system_overview,todo_list,whmcs_news,supporttickets_overview,calendar', '1', '1', '1');
414INSERT INTO tbladminroles VALUES('2', 'Sales Operator', 'activity_log,getting_started,income_forecast,income_overview,my_notes,network_status,open_invoices,orders_overview,paypal_addon,client_activity,todo_list,whmcs_news,supporttickets_overview,calendar', '0', '1', '1');
415INSERT INTO tbladminroles VALUES('3', 'Support Operator', 'activity_log,getting_started,my_notes,todo_list,whmcs_news,supporttickets_overview,calendar', '0', '0', '1');
416
417
418
419
420
421
422### tbladminroles TABLE DUMP COMPLETED ###
423
424
425DROP TABLE IF EXISTS tbladmins;
426CREATE TABLE `tbladmins` (
427  `id` int(10) NOT NULL AUTO_INCREMENT,
428  `roleid` int(1) NOT NULL,
429  `username` text NOT NULL,
430  `password` varchar(32) NOT NULL DEFAULT '',
431  `authmodule` text NOT NULL,
432  `authdata` text NOT NULL,
433  `firstname` text NOT NULL,
434  `lastname` text NOT NULL,
435  `email` text NOT NULL,
436  `signature` text NOT NULL,
437  `notes` text NOT NULL,
438  `template` text NOT NULL,
439  `language` text NOT NULL,
440  `disabled` int(1) NOT NULL,
441  `loginattempts` int(1) NOT NULL,
442  `supportdepts` text NOT NULL,
443  `ticketnotifications` text NOT NULL,
444  `homewidgets` text NOT NULL,
445  PRIMARY KEY (`id`),
446  KEY `username` (`username`(32))
447) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
448
449INSERT INTO tbladmins VALUES('1', '1', 'Vinicius', 'd259e9dd2f09db5a1f088217b4c83589', '', '', 'Vinicius', 'Oliveira', 'viniciusnegocios2@hotmail.com', '', 'Welcome to WHMCS!  Please ensure you have setup the cron job in cPanel to automate tasks', 'blend', '', '0', '0', ',', '', 'getting_started:true,orders_overview:true,supporttickets_overview:true,my_notes:true,client_activity:true,open_invoices:true,activity_log:true|income_overview:true,system_overview:true,whmcs_news:true,sysinfo:true,admin_activity:true,todo_list:true,network_status:true,income_forecast:true|');
450
451
452
453
454
455
456### tbladmins TABLE DUMP COMPLETED ###
457
458
459DROP TABLE IF EXISTS tbladminsecurityquestions;
460CREATE TABLE `tbladminsecurityquestions` (
461  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
462  `question` text NOT NULL,
463  PRIMARY KEY (`id`)
464) ENGINE=InnoDB DEFAULT CHARSET=utf8;
465
466
467
468
469
470
471
472### tbladminsecurityquestions TABLE DUMP COMPLETED ###
473
474
475DROP TABLE IF EXISTS tblaffiliates;
476CREATE TABLE `tblaffiliates` (
477  `id` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT,
478  `date` date DEFAULT NULL,
479  `clientid` int(10) NOT NULL,
480  `visitors` int(1) NOT NULL,
481  `paytype` text NOT NULL,
482  `payamount` decimal(10,2) NOT NULL,
483  `onetime` int(1) NOT NULL,
484  `balance` decimal(10,2) NOT NULL DEFAULT '0.00',
485  `withdrawn` decimal(10,2) NOT NULL DEFAULT '0.00',
486  KEY `affiliateid` (`id`),
487  KEY `clientid` (`clientid`)
488) ENGINE=InnoDB DEFAULT CHARSET=utf8;
489
490
491
492
493
494
495
496### tblaffiliates TABLE DUMP COMPLETED ###
497
498
499DROP TABLE IF EXISTS tblaffiliatesaccounts;
500CREATE TABLE `tblaffiliatesaccounts` (
501  `id` int(10) NOT NULL AUTO_INCREMENT,
502  `affiliateid` int(10) NOT NULL,
503  `relid` int(10) NOT NULL,
504  `lastpaid` date NOT NULL DEFAULT '0000-00-00',
505  PRIMARY KEY (`id`),
506  KEY `affiliateid` (`affiliateid`)
507) ENGINE=InnoDB DEFAULT CHARSET=utf8;
508
509
510
511
512
513
514
515### tblaffiliatesaccounts TABLE DUMP COMPLETED ###
516
517
518DROP TABLE IF EXISTS tblaffiliateshistory;
519CREATE TABLE `tblaffiliateshistory` (
520  `id` int(10) NOT NULL AUTO_INCREMENT,
521  `affiliateid` int(10) NOT NULL,
522  `date` date NOT NULL,
523  `affaccid` int(10) NOT NULL,
524  `description` text NOT NULL,
525  `amount` decimal(10,2) NOT NULL,
526  PRIMARY KEY (`id`),
527  KEY `affiliateid` (`affiliateid`)
528) ENGINE=InnoDB DEFAULT CHARSET=utf8;
529
530
531
532
533
534
535
536### tblaffiliateshistory TABLE DUMP COMPLETED ###
537
538
539DROP TABLE IF EXISTS tblaffiliatespending;
540CREATE TABLE `tblaffiliatespending` (
541  `id` int(10) NOT NULL AUTO_INCREMENT,
542  `affaccid` int(10) NOT NULL DEFAULT '0',
543  `amount` decimal(10,2) NOT NULL,
544  `clearingdate` date NOT NULL,
545  PRIMARY KEY (`id`),
546  KEY `clearingdate` (`clearingdate`)
547) ENGINE=InnoDB DEFAULT CHARSET=utf8;
548
549
550
551
552
553
554
555### tblaffiliatespending TABLE DUMP COMPLETED ###
556
557
558DROP TABLE IF EXISTS tblaffiliateswithdrawals;
559CREATE TABLE `tblaffiliateswithdrawals` (
560  `id` int(10) NOT NULL AUTO_INCREMENT,
561  `affiliateid` int(10) NOT NULL,
562  `date` date NOT NULL,
563  `amount` decimal(10,2) NOT NULL,
564  PRIMARY KEY (`id`),
565  KEY `affiliateid` (`affiliateid`)
566) ENGINE=InnoDB DEFAULT CHARSET=latin1;
567
568
569
570
571
572
573
574### tblaffiliateswithdrawals TABLE DUMP COMPLETED ###
575
576
577DROP TABLE IF EXISTS tblannouncements;
578CREATE TABLE `tblannouncements` (
579  `id` int(10) NOT NULL AUTO_INCREMENT,
580  `date` datetime DEFAULT NULL,
581  `title` text NOT NULL,
582  `announcement` text NOT NULL,
583  `published` text NOT NULL,
584  `parentid` int(10) NOT NULL,
585  `language` text NOT NULL,
586  PRIMARY KEY (`id`),
587  KEY `date` (`date`)
588) ENGINE=InnoDB DEFAULT CHARSET=utf8;
589
590
591
592
593
594
595
596### tblannouncements TABLE DUMP COMPLETED ###
597
598
599DROP TABLE IF EXISTS tblbannedemails;
600CREATE TABLE `tblbannedemails` (
601  `id` int(10) NOT NULL AUTO_INCREMENT,
602  `domain` text NOT NULL,
603  `count` int(10) NOT NULL DEFAULT '0',
604  PRIMARY KEY (`id`),
605  KEY `domain` (`domain`(64))
606) ENGINE=InnoDB DEFAULT CHARSET=utf8;
607
608
609
610
611
612
613
614### tblbannedemails TABLE DUMP COMPLETED ###
615
616
617DROP TABLE IF EXISTS tblbannedips;
618CREATE TABLE `tblbannedips` (
619  `id` int(10) NOT NULL AUTO_INCREMENT,
620  `ip` text NOT NULL,
621  `reason` text NOT NULL,
622  `expires` datetime NOT NULL,
623  PRIMARY KEY (`id`),
624  KEY `ip` (`ip`(32))
625) ENGINE=InnoDB DEFAULT CHARSET=utf8;
626
627
628
629
630
631
632
633### tblbannedips TABLE DUMP COMPLETED ###
634
635
636DROP TABLE IF EXISTS tblbillableitems;
637CREATE TABLE `tblbillableitems` (
638  `id` int(10) NOT NULL AUTO_INCREMENT,
639  `userid` int(10) NOT NULL,
640  `description` text NOT NULL,
641  `hours` decimal(5,1) NOT NULL,
642  `amount` decimal(10,2) NOT NULL,
643  `recur` int(5) NOT NULL DEFAULT '0',
644  `recurcycle` text NOT NULL,
645  `recurfor` int(5) NOT NULL DEFAULT '0',
646  `invoiceaction` int(1) NOT NULL,
647  `duedate` date NOT NULL,
648  `invoicecount` int(5) NOT NULL DEFAULT '0',
649  PRIMARY KEY (`id`)
650) ENGINE=InnoDB DEFAULT CHARSET=utf8;
651
652
653
654
655
656
657
658### tblbillableitems TABLE DUMP COMPLETED ###
659
660
661DROP TABLE IF EXISTS tblbrowserlinks;
662CREATE TABLE `tblbrowserlinks` (
663  `id` int(10) NOT NULL AUTO_INCREMENT,
664  `name` text NOT NULL,
665  `url` text NOT NULL,
666  PRIMARY KEY (`id`),
667  KEY `name` (`name`(32))
668) ENGINE=InnoDB DEFAULT CHARSET=utf8;
669
670
671
672
673
674
675
676### tblbrowserlinks TABLE DUMP COMPLETED ###
677
678
679DROP TABLE IF EXISTS tblbundles;
680CREATE TABLE `tblbundles` (
681  `id` int(10) NOT NULL AUTO_INCREMENT,
682  `name` text NOT NULL,
683  `validfrom` date NOT NULL,
684  `validuntil` date NOT NULL,
685  `uses` int(4) NOT NULL,
686  `maxuses` int(4) NOT NULL,
687  `itemdata` text NOT NULL,
688  `allowpromo` int(1) NOT NULL,
689  `showgroup` int(1) NOT NULL,
690  `gid` int(10) NOT NULL,
691  `description` text NOT NULL,
692  `displayprice` decimal(10,2) NOT NULL,
693  `sortorder` int(3) NOT NULL,
694  PRIMARY KEY (`id`)
695) ENGINE=InnoDB DEFAULT CHARSET=utf8;
696
697
698
699
700
701
702
703### tblbundles TABLE DUMP COMPLETED ###
704
705
706DROP TABLE IF EXISTS tblcalendar;
707CREATE TABLE `tblcalendar` (
708  `id` int(10) NOT NULL AUTO_INCREMENT,
709  `title` text NOT NULL,
710  `desc` text NOT NULL,
711  `start` int(10) NOT NULL,
712  `end` int(10) NOT NULL,
713  `allday` int(1) NOT NULL,
714  `adminid` int(10) NOT NULL,
715  `recurid` int(10) NOT NULL,
716  PRIMARY KEY (`id`)
717) ENGINE=InnoDB DEFAULT CHARSET=utf8;
718
719
720
721
722
723
724
725### tblcalendar TABLE DUMP COMPLETED ###
726
727
728DROP TABLE IF EXISTS tblcancelrequests;
729CREATE TABLE `tblcancelrequests` (
730  `id` int(10) NOT NULL AUTO_INCREMENT,
731  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
732  `relid` int(10) NOT NULL,
733  `reason` text NOT NULL,
734  `type` text NOT NULL,
735  PRIMARY KEY (`id`),
736  KEY `serviceid` (`relid`)
737) ENGINE=InnoDB DEFAULT CHARSET=utf8;
738
739
740
741
742
743
744
745### tblcancelrequests TABLE DUMP COMPLETED ###
746
747
748DROP TABLE IF EXISTS tblclientgroups;
749CREATE TABLE `tblclientgroups` (
750  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
751  `groupname` varchar(45) NOT NULL,
752  `groupcolour` varchar(45) DEFAULT NULL,
753  `discountpercent` decimal(10,2) unsigned DEFAULT '0.00',
754  `susptermexempt` text,
755  `separateinvoices` text NOT NULL,
756  PRIMARY KEY (`id`)
757) ENGINE=InnoDB DEFAULT CHARSET=utf8;
758
759
760
761
762
763
764
765### tblclientgroups TABLE DUMP COMPLETED ###
766
767
768DROP TABLE IF EXISTS tblclients;
769CREATE TABLE `tblclients` (
770  `id` int(10) NOT NULL AUTO_INCREMENT,
771  `firstname` text NOT NULL,
772  `lastname` text NOT NULL,
773  `companyname` text NOT NULL,
774  `email` text NOT NULL,
775  `address1` text NOT NULL,
776  `address2` text NOT NULL,
777  `city` text NOT NULL,
778  `state` text NOT NULL,
779  `postcode` text NOT NULL,
780  `country` text NOT NULL,
781  `phonenumber` text NOT NULL,
782  `password` text NOT NULL,
783  `authmodule` text NOT NULL,
784  `authdata` text NOT NULL,
785  `currency` int(10) NOT NULL,
786  `defaultgateway` text NOT NULL,
787  `credit` decimal(10,2) NOT NULL,
788  `taxexempt` text NOT NULL,
789  `latefeeoveride` text NOT NULL,
790  `overideduenotices` text NOT NULL,
791  `separateinvoices` text NOT NULL,
792  `disableautocc` text NOT NULL,
793  `datecreated` date NOT NULL,
794  `notes` text NOT NULL,
795  `billingcid` int(10) NOT NULL,
796  `securityqid` int(10) NOT NULL,
797  `securityqans` text NOT NULL,
798  `groupid` int(10) NOT NULL,
799  `cardtype` varchar(255) NOT NULL DEFAULT '',
800  `cardlastfour` text NOT NULL,
801  `cardnum` blob NOT NULL,
802  `startdate` blob NOT NULL,
803  `expdate` blob NOT NULL,
804  `issuenumber` blob NOT NULL,
805  `bankname` text NOT NULL,
806  `banktype` text NOT NULL,
807  `bankcode` blob NOT NULL,
808  `bankacct` blob NOT NULL,
809  `gatewayid` text NOT NULL,
810  `lastlogin` datetime DEFAULT NULL,
811  `ip` text NOT NULL,
812  `host` text NOT NULL,
813  `status` enum('Active','Inactive','Closed') NOT NULL DEFAULT 'Active',
814  `language` text NOT NULL,
815  `pwresetkey` text NOT NULL,
816  `pwresetexpiry` int(10) NOT NULL,
817  `emailoptout` int(1) NOT NULL,
818  `overrideautoclose` int(1) NOT NULL,
819  PRIMARY KEY (`id`),
820  KEY `firstname_lastname` (`firstname`(32),`lastname`(32)),
821  KEY `email` (`email`(64))
822) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
823
824INSERT INTO tblclients VALUES('1', 'Habblack', 'Hotel', '', 'luanramos38@hotmail.com', 'Rua Juvencio de Jesus', 'Calcarea', 'Caieiras', 'SP', '07700-000', 'BR', '11955554436', 'dc2f68435591fe32312082e6215b1d80:YUYXi', '', '', '1', '', '0.00', '', '', '', '', '', '2015-06-10', '', '0', '0', 'sXJ0VxURRjSoQVkXoMlJPWQEWzo=', '0', '', '', '', '', '', '', '', '', '', '', '', '2015-06-10 02:08:27', '189.28.157.24', 'c-157-24.fox.com.br', 'Inactive', '', '', '0', '0', '0');
825
826
827
828
829
830
831### tblclients TABLE DUMP COMPLETED ###
832
833
834DROP TABLE IF EXISTS tblclientsfiles;
835CREATE TABLE `tblclientsfiles` (
836  `id` int(10) NOT NULL AUTO_INCREMENT,
837  `userid` int(10) NOT NULL,
838  `title` text NOT NULL,
839  `filename` text NOT NULL,
840  `adminonly` int(1) NOT NULL,
841  `dateadded` date NOT NULL,
842  PRIMARY KEY (`id`)
843) ENGINE=InnoDB DEFAULT CHARSET=utf8;
844
845
846
847
848
849
850
851### tblclientsfiles TABLE DUMP COMPLETED ###
852
853
854DROP TABLE IF EXISTS tblconfiguration;
855CREATE TABLE `tblconfiguration` (
856  `setting` text NOT NULL,
857  `value` text NOT NULL,
858  KEY `setting` (`setting`(32))
859) ENGINE=InnoDB DEFAULT CHARSET=utf8;
860
861INSERT INTO tblconfiguration VALUES('Language', 'portuguese-br');
862INSERT INTO tblconfiguration VALUES('CompanyName', 'Thun Host');
863INSERT INTO tblconfiguration VALUES('Email', 'contato@thunhost.in');
864INSERT INTO tblconfiguration VALUES('Domain', 'http://www.thunhost.in/');
865INSERT INTO tblconfiguration VALUES('LogoURL', '');
866INSERT INTO tblconfiguration VALUES('SystemURL', 'http://thunhost.in/');
867INSERT INTO tblconfiguration VALUES('SystemSSLURL', '');
868INSERT INTO tblconfiguration VALUES('AutoSuspension', 'on');
869INSERT INTO tblconfiguration VALUES('AutoSuspensionDays', '5');
870INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBefore', '14');
871INSERT INTO tblconfiguration VALUES('AffiliateEnabled', 'on');
872INSERT INTO tblconfiguration VALUES('AffiliateEarningPercent', '0');
873INSERT INTO tblconfiguration VALUES('AffiliateBonusDeposit', '0.00');
874INSERT INTO tblconfiguration VALUES('AffiliatePayout', '0.00');
875INSERT INTO tblconfiguration VALUES('AffiliateLinks', '');
876INSERT INTO tblconfiguration VALUES('ActivityLimit', '10000');
877INSERT INTO tblconfiguration VALUES('DateFormat', 'DD/MM/YYYY');
878INSERT INTO tblconfiguration VALUES('PreSalesQuestions', '');
879INSERT INTO tblconfiguration VALUES('Template', 'default');
880INSERT INTO tblconfiguration VALUES('AllowRegister', 'on');
881INSERT INTO tblconfiguration VALUES('AllowTransfer', 'on');
882INSERT INTO tblconfiguration VALUES('AllowOwnDomain', 'on');
883INSERT INTO tblconfiguration VALUES('EnableTOSAccept', 'on');
884INSERT INTO tblconfiguration VALUES('TermsOfService', 'http://www.thunhost.in/termos.html');
885INSERT INTO tblconfiguration VALUES('AllowLanguageChange', 'on');
886INSERT INTO tblconfiguration VALUES('Version', '5.3.1');
887INSERT INTO tblconfiguration VALUES('AllowCustomerChangeInvoiceGateway', 'on');
888INSERT INTO tblconfiguration VALUES('DefaultNameserver1', 'ns1.yourdomain.com');
889INSERT INTO tblconfiguration VALUES('DefaultNameserver2', 'ns2.yourdomain.com');
890INSERT INTO tblconfiguration VALUES('SendInvoiceReminderDays', '7');
891INSERT INTO tblconfiguration VALUES('SendReminder', 'on');
892INSERT INTO tblconfiguration VALUES('NumRecordstoDisplay', '50');
893INSERT INTO tblconfiguration VALUES('BCCMessages', '');
894INSERT INTO tblconfiguration VALUES('MailType', 'mail');
895INSERT INTO tblconfiguration VALUES('SMTPHost', '');
896INSERT INTO tblconfiguration VALUES('SMTPUsername', '');
897INSERT INTO tblconfiguration VALUES('SMTPPassword', 'n1wQ6N89mp0nO7FA6zG1TYXwHSc=');
898INSERT INTO tblconfiguration VALUES('SMTPPort', '25');
899INSERT INTO tblconfiguration VALUES('ShowCancellationButton', 'on');
900INSERT INTO tblconfiguration VALUES('UpdateStatsAuto', 'on');
901INSERT INTO tblconfiguration VALUES('InvoicePayTo', 'Address goes here...');
902INSERT INTO tblconfiguration VALUES('SendAffiliateReportMonthly', 'on');
903INSERT INTO tblconfiguration VALUES('InvalidLoginBanLength', '15');
904INSERT INTO tblconfiguration VALUES('Signature', 'Signature goes here...');
905INSERT INTO tblconfiguration VALUES('DomainOnlyOrderEnabled', 'on');
906INSERT INTO tblconfiguration VALUES('TicketBannedAddresses', '');
907INSERT INTO tblconfiguration VALUES('SendEmailNotificationonUserDetailsChange', 'on');
908INSERT INTO tblconfiguration VALUES('TicketAllowedFileTypes', '.jpg,.gif,.jpeg,.png');
909INSERT INTO tblconfiguration VALUES('CloseInactiveTickets', '0');
910INSERT INTO tblconfiguration VALUES('InvoiceLateFeeAmount', '10.00');
911INSERT INTO tblconfiguration VALUES('AutoTermination', '');
912INSERT INTO tblconfiguration VALUES('AutoTerminationDays', '30');
913INSERT INTO tblconfiguration VALUES('RegistrarAdminFirstName', '');
914INSERT INTO tblconfiguration VALUES('RegistrarAdminLastName', '');
915INSERT INTO tblconfiguration VALUES('RegistrarAdminCompanyName', '');
916INSERT INTO tblconfiguration VALUES('RegistrarAdminAddress1', '');
917INSERT INTO tblconfiguration VALUES('RegistrarAdminAddress2', '');
918INSERT INTO tblconfiguration VALUES('RegistrarAdminCity', '');
919INSERT INTO tblconfiguration VALUES('RegistrarAdminStateProvince', '');
920INSERT INTO tblconfiguration VALUES('RegistrarAdminCountry', 'US');
921INSERT INTO tblconfiguration VALUES('RegistrarAdminPostalCode', '');
922INSERT INTO tblconfiguration VALUES('RegistrarAdminPhone', '');
923INSERT INTO tblconfiguration VALUES('RegistrarAdminFax', '');
924INSERT INTO tblconfiguration VALUES('RegistrarAdminEmailAddress', '');
925INSERT INTO tblconfiguration VALUES('RegistrarAdminUseClientDetails', 'on');
926INSERT INTO tblconfiguration VALUES('Charset', 'utf-8');
927INSERT INTO tblconfiguration VALUES('AutoUnsuspend', 'on');
928INSERT INTO tblconfiguration VALUES('RunScriptonCheckOut', '');
929INSERT INTO tblconfiguration VALUES('License', 'Zjk3MDZjMDA4ZDJhYzQ2OWY5ODkwNzQyM2UzYTg0M2ViZWNlYWJlODBvemM3cHpNNkUyT3lvVGE5dGpJ\r\nbFpYYTBOV1Fpb2pONk0zT2lNWGQwRkdkekppTzJvemM3SVNNejBpTXgwU081QWpNaW9ETXhvemM3SVNa\r\nMEZHWmxWSFowaFhadUppT3hFak96dGpJc0ZtZHYxV1pTQnladWxHWnVGbWNDSmlPMkVqT3p0aklsMVdZ\r\ndUppTzBvemM3cHpNNkUyT3hvVGE5dGpJbFpYYTBOV1Fpb2pONk0zT2lNWGQwRkdkekppTzJvemM3SVNN\r\nejBpTXgwU081QWpNaW9ETXhvemM3SVNaMEZHWmxWSFowaFhadUppT3hFak96dGpJd0JYUWdRV2F2Skha\r\ndUZrSTZFVE02TTNPaVVXYmg1bUk2UWpPenRuT3pvVFk3QWpPcHRuT3dFak9oSmlPemdETXhvemM3SXlj\r\ndTlHWmtGbUk2WWpPenRqSWxaWGEwTldROXdXWTI5V2JsSkZJbjVXYWs1V1l5SmtJNk1qTTZNM09pTW5i\r\ndmxHZHc5MlpwWm1idk5tSTZNVE02TTNPaXdXYjBoMlhqbEdiaVZIY3ZRM2N2aG1iMWhHZHZVV2J2aDJM\r\naW9qTnlvemM3SXljeWxHWmtsR2JoWm5JNmtqT3p0aklzMUdkbzkxWXB4bVkxQjNMME4zYm81V2RvUjNM\r\nbDEyYm85aUk2WWpNNk0zT2lrbmN2UjNZbEpYYWtSV2FzRm1kaW9ETnhvemM3SXlOeTRTTjI0Q04xSWpM\r\neWtUTWlvek14b3pjN0l5Y3dsR1pweFdZMkppTzRvemM3SXlOeTRTTjI0Q04xSWpMeWtUTWlvek14b3pj\r\nN0lDY3BSV2FzRm1kaW96TjZNM09pUVhadTVpY2wxV2EwMW1MM2QzZHM0V2F1UTNjdmhtYjFoR2Rpb2pO\r\neW96YzdJeWN1bFdZdDlHWmtsR2JoWm5JNklUTTZNM09pUVhadTVpY2wxV2EwMW1MM2QzZHM0V2F1UTNj\r\ndmhtYjFoR2Rpb2pOeW96YzdJaWJwRldidlJHWnB4V1kySmlPeEVqT3p0aklsMVdhVUJTWnU5a0k2Z2pP\r\nenRqSWx4Mlk1TjJadWxHYnNsbVlpb2pNeG96YzdJU016MGlNeDBDT3hBak1pb0RNeG96YzdJU1owRkda\r\nbFZIWjBoWFp1SmlPeEVqT3p0akl6SVRMeUVUTHpFRE15SWlPd0VqT3p0aklsUlhZa2RXWnlKaU8zb3pj\r\nN0lpVUYxVVNVMWtJNllqT3p0akl5Vkdic1YyY2xKbkk2Z2pPenRqSXdJaU94b3pjN0l5Y3pWMllqRkdk\r\neTlHY3dWM2Npb3pNeG96YzdJQ01pb1RNNk0zT2lNWFowRkdad1YzY2xKWGExRlhaeUppTzFFak96dGpJ\r\nU1ZVVEpSVlRna2xRZ1FVUlNGRVNUSmlPMkVqT3p0aklsMVdZdVIzWTFSMmJ5Qm5JNkVUTTZNM09pVWpJ\r\nNkVqT3p0aklrbEdkalZIWnZKSGNpb1RPNk0zT2lRVVJNeFVWT0JpSmdRVVJFOTBRRlJFSU14VVZHQlNR\r\nVVZrUWdJakx6NFNOZ00xUU5oMFZpb0RPem96YzdJU1p0Rm1ia1ZtY2xSM2NwZFdaeUppTzBFak96dGpJ\r\nbFpYYTBOV1Fpb2pONk0zT2lNWGQwRkdkekppTzJvemM3cFRNeW9UWWYwMTEzN2JiNmI2YjRhMjBiZDZl\r\nZjZkMzgyY2ZiMjIxNWMxZDE3MjQ5dGpJNUFqTndVVE13SWpJNmdqT3p0aklsUlhZa3QyWWxoMllpb1RP\r\nNk0zT2lJakx6NFNOaW9UTjZNM09pNDJicE5uY2xaSGR6VkdkaHhtSTZNVE02TTNPaVVEWjFjRE40VWpa\r\neEkyWWpSV014WVdPaU5UWnpFVFkzVTJOMUUyWTNjak1pb2pNem96YzdJQ2F6RkdhMVFXYmlvek42TTNP\r\naTBYZjdJU1oybEdkakZrSTZZak96dGpJelZIZGhSM2Npb2pONk0zT2lFek10SVRNdGtUT3dJakk2QVRN\r\nNk0zT2lVR2RoUldaMVJHZDRWbWJpb1RNeG96YzdJQ2N3RkVJNEF5YzM5R1p1bDJWaW96TXhvemM3SVNa\r\ndEZtYmlvRE42TTNlNk1qT2h0VE82a1dmN0lTWjJsR2RqRmtJNllqT3p0akl6VkhkaFIzY2lvak42TTNP\r\naUV6TXRJVE10a1RPd0lqSTZBVE02TTNPaVVHZGhSV1oxUkdkNFZtYmlvVE14b3pjN0l5Y2xSWFlrQlhW\r\nZ1FtYmhCQ2R5OUdjd1YzVWlvVE94b3pjN0lTWnRGbWJpb0RONk0zZTZNak9odERPNmtXZjdJU1oybEdk\r\nakZrSTZZak96dGpJelZIZGhSM2Npb2pONk0zT2lFek10SVRNdGtUT3dJakk2QVRNNk0zT2lVR2RoUlda\r\nMVJHZDRWbWJpb1RNeG96YzdJaWJ2bEdkcFJXUmdVR2JwSjJiTkppTzBFak96dGpJbDFXWXVKaU8wb3pj\r\nN3B6TTZFMk8zb1RhOXRqSWxaWGEwTldRaW9qTjZNM09pTVhkMEZHZHpKaU8yb3pjN0lTTXowaU14MFNP\r\nNUFqTWlvRE14b3pjN0lTWjBGR1psVkhaMGhYWnVKaU94RWpPenRqSTBGR2FEQlNaMmxHVGlvVE82TTNP\r\naVVXYmg1bUk2UWpPenRuT3pvVFk3WWpPcDEzT2lVbWRwUjNZQkppTzJvemM3SXljMVJYWTBObkk2WWpP\r\nenRqSXhNVEx5RVRMNWtETXlJaU93RWpPenRqSWxSWFlrVldka1JIZWw1bUk2RVRNNk0zT2k0MmJrUldR\r\nZ2NtYnBObmJsTldhTUppTzFFak96dGpJbDFXWXVKaU8wb3pjN3B6TTZFMk8xb1RhOXRqSWxaWGEwTldR\r\naW9qTjZNM09pTVhkMEZHZHpKaU8yb3pjN0lTTXowaU14MFNPNUFqTWlvRE14b3pjN0lTWjBGR1psVkha\r\nMGhYWnVKaU94RWpPenRqSXdCWFFnVW1idmhHVXBKaU93RWpPenRqSWwxV1l1SmlPMG96Yzdwek02RTJP\r\nMG9UYTl0aklsWlhhME5XUWlvak42TTNPaU1YZDBGR2R6SmlPMm96YzdJU016MGlNeDBTTzVBak1pb0RN\r\neG96YzdJU1owRkdabFZIWjBoWFp1SmlPeEVqT3p0akl1OUdaa0ZFSTA1V1p0VjJaaDVXWU5CQ2RqVm1h\r\ndkpIVWlvRE55b3pjN0lTWnRGbWJpb0RONk0zZTZNak9odHpNNmtXZjdJU1oybEdkakZrSTZZak96dGpJ\r\nelZIZGhSM2Npb2pONk0zT2lFek10SVRNdGtUT3dJakk2QVRNNk0zT2lVR2RoUldaMVJHZDRWbWJpb1RN\r\neG96YzdJaWJ2UkdaQkJTWm5GMmFqRkdVZ1VHYmlGbWMxZFdhbTUyYkRKaU8ySWpPenRqSWwxV1l1SmlP\r\nYTdkZjA5YWQ5ZjJlNmJjYjM2M2VlNzZlYmEwYTRjMDNlNGJhZjE5NA==');
930INSERT INTO tblconfiguration VALUES('OrderFormTemplate', 'cart');
931INSERT INTO tblconfiguration VALUES('AllowDomainsTwice', 'on');
932INSERT INTO tblconfiguration VALUES('AddLateFeeDays', '5');
933INSERT INTO tblconfiguration VALUES('TaxEnabled', '');
934INSERT INTO tblconfiguration VALUES('DefaultCountry', 'BR');
935INSERT INTO tblconfiguration VALUES('AutoRedirectoInvoice', 'gateway');
936INSERT INTO tblconfiguration VALUES('EnablePDFInvoices', 'on');
937INSERT INTO tblconfiguration VALUES('CaptchaSetting', 'offloggedin');
938INSERT INTO tblconfiguration VALUES('SupportTicketOrder', 'ASC');
939INSERT INTO tblconfiguration VALUES('SendFirstOverdueInvoiceReminder', '1');
940INSERT INTO tblconfiguration VALUES('TaxType', 'Exclusive');
941INSERT INTO tblconfiguration VALUES('DomainDNSManagement', '5.00');
942INSERT INTO tblconfiguration VALUES('DomainEmailForwarding', '5.00');
943INSERT INTO tblconfiguration VALUES('InvoiceIncrement', '1');
944INSERT INTO tblconfiguration VALUES('ContinuousInvoiceGeneration', '');
945INSERT INTO tblconfiguration VALUES('AutoCancellationRequests', 'on');
946INSERT INTO tblconfiguration VALUES('SystemEmailsFromName', 'WHMCompleteSolution');
947INSERT INTO tblconfiguration VALUES('SystemEmailsFromEmail', 'noreply@yourdomain.com');
948INSERT INTO tblconfiguration VALUES('AllowClientRegister', 'on');
949INSERT INTO tblconfiguration VALUES('BulkCheckTLDs', '');
950INSERT INTO tblconfiguration VALUES('OrderDaysGrace', '0');
951INSERT INTO tblconfiguration VALUES('CreditOnDowngrade', 'on');
952INSERT INTO tblconfiguration VALUES('AcceptedCardTypes', 'Visa,MasterCard,Discover,American Express,JCB,EnRoute,Diners Club');
953INSERT INTO tblconfiguration VALUES('TaxDomains', 'on');
954INSERT INTO tblconfiguration VALUES('TaxLateFee', 'on');
955INSERT INTO tblconfiguration VALUES('AdminForceSSL', 'on');
956INSERT INTO tblconfiguration VALUES('ProductMonthlyPricingBreakdown', '');
957INSERT INTO tblconfiguration VALUES('LateFeeType', 'Percentage');
958INSERT INTO tblconfiguration VALUES('SendSecondOverdueInvoiceReminder', '0');
959INSERT INTO tblconfiguration VALUES('SendThirdOverdueInvoiceReminder', '0');
960INSERT INTO tblconfiguration VALUES('DomainIDProtection', '5.00');
961INSERT INTO tblconfiguration VALUES('DomainRenewalNotices', '60,30,15,7,1');
962INSERT INTO tblconfiguration VALUES('SequentialInvoiceNumbering', '');
963INSERT INTO tblconfiguration VALUES('SequentialInvoiceNumberFormat', '{NUMBER}');
964INSERT INTO tblconfiguration VALUES('SequentialInvoiceNumberValue', '1');
965INSERT INTO tblconfiguration VALUES('DefaultNameserver3', '');
966INSERT INTO tblconfiguration VALUES('DefaultNameserver4', '');
967INSERT INTO tblconfiguration VALUES('AffiliatesDelayCommission', '0');
968INSERT INTO tblconfiguration VALUES('SupportModule', '');
969INSERT INTO tblconfiguration VALUES('AddFundsEnabled', '');
970INSERT INTO tblconfiguration VALUES('AddFundsMinimum', '10.00');
971INSERT INTO tblconfiguration VALUES('AddFundsMaximum', '100.00');
972INSERT INTO tblconfiguration VALUES('AddFundsMaximumBalance', '300.00');
973INSERT INTO tblconfiguration VALUES('OrderDaysGrace', '0');
974INSERT INTO tblconfiguration VALUES('DisableClientDropdown', '');
975INSERT INTO tblconfiguration VALUES('CCProcessDaysBefore', '0');
976INSERT INTO tblconfiguration VALUES('CCAttemptOnlyOnce', '');
977INSERT INTO tblconfiguration VALUES('CCDaySendExpiryNotices', '25');
978INSERT INTO tblconfiguration VALUES('BulkDomainSearchEnabled', 'on');
979INSERT INTO tblconfiguration VALUES('AutoRenewDomainsonPayment', 'on');
980INSERT INTO tblconfiguration VALUES('DomainAutoRenewDefault', 'on');
981INSERT INTO tblconfiguration VALUES('CCRetryEveryWeekFor', '0');
982INSERT INTO tblconfiguration VALUES('SupportTicketKBSuggestions', 'on');
983INSERT INTO tblconfiguration VALUES('DailyEmailBackup', '');
984INSERT INTO tblconfiguration VALUES('FTPBackupHostname', '');
985INSERT INTO tblconfiguration VALUES('FTPBackupUsername', '');
986INSERT INTO tblconfiguration VALUES('FTPBackupPassword', '+0BWoGNIpZXIb6L/csnie8ROwDU=');
987INSERT INTO tblconfiguration VALUES('FTPBackupDestination', '/');
988INSERT INTO tblconfiguration VALUES('TaxL2Compound', '');
989INSERT INTO tblconfiguration VALUES('EmailCSS', 'body,td { font-family: verdana; font-size: 11px; font-weight: normal; }\r\na { color: #0000ff; }');
990INSERT INTO tblconfiguration VALUES('SEOFriendlyUrls', '');
991INSERT INTO tblconfiguration VALUES('ShowCCIssueStart', '');
992INSERT INTO tblconfiguration VALUES('ClientDropdownFormat', '1');
993INSERT INTO tblconfiguration VALUES('TicketRatingEnabled', 'on');
994INSERT INTO tblconfiguration VALUES('NetworkIssuesRequireLogin', 'on');
995INSERT INTO tblconfiguration VALUES('ShowNotesFieldonCheckout', 'on');
996INSERT INTO tblconfiguration VALUES('RequireLoginforClientTickets', 'on');
997INSERT INTO tblconfiguration VALUES('NOMD5', '');
998INSERT INTO tblconfiguration VALUES('CurrencyAutoUpdateExchangeRates', 'on');
999INSERT INTO tblconfiguration VALUES('CurrencyAutoUpdateProductPrices', '');
1000INSERT INTO tblconfiguration VALUES('RequiredPWStrength', '50');
1001INSERT INTO tblconfiguration VALUES('MaintenanceMode', '');
1002INSERT INTO tblconfiguration VALUES('MaintenanceModeMessage', 'We are currently performing maintenance and will be back shortly.');
1003INSERT INTO tblconfiguration VALUES('SkipFraudForExisting', '');
1004INSERT INTO tblconfiguration VALUES('SMTPSSL', '');
1005INSERT INTO tblconfiguration VALUES('ContactFormDept', '');
1006INSERT INTO tblconfiguration VALUES('ContactFormTo', '');
1007INSERT INTO tblconfiguration VALUES('TicketEscalationLastRun', '2009-01-01 00:00:00');
1008INSERT INTO tblconfiguration VALUES('APIAllowedIPs', 'a:1:{i:0;a:2:{s:2:\"ip\";s:0:\"\";s:4:\"note\";s:0:\"\";}}');
1009INSERT INTO tblconfiguration VALUES('DisableSessionIPCheck', '');
1010INSERT INTO tblconfiguration VALUES('DisableSupportTicketReplyEmailsLogging', '');
1011INSERT INTO tblconfiguration VALUES('OverageBillingMethod', '1');
1012INSERT INTO tblconfiguration VALUES('CCNeverStore', '');
1013INSERT INTO tblconfiguration VALUES('CCAllowCustomerDelete', '');
1014INSERT INTO tblconfiguration VALUES('CreateDomainInvoiceDaysBefore', '');
1015INSERT INTO tblconfiguration VALUES('NoInvoiceEmailOnOrder', '');
1016INSERT INTO tblconfiguration VALUES('TaxInclusiveDeduct', '');
1017INSERT INTO tblconfiguration VALUES('LateFeeMinimum', '0.00');
1018INSERT INTO tblconfiguration VALUES('AutoProvisionExistingOnly', '');
1019INSERT INTO tblconfiguration VALUES('EnableDomainRenewalOrders', 'on');
1020INSERT INTO tblconfiguration VALUES('EnableMassPay', 'on');
1021INSERT INTO tblconfiguration VALUES('NoAutoApplyCredit', '');
1022INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeMonthly', '');
1023INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeQuarterly', '');
1024INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeSemiAnnually', '');
1025INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeAnnually', '');
1026INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeBiennially', '');
1027INSERT INTO tblconfiguration VALUES('CreateInvoiceDaysBeforeTriennially', '');
1028INSERT INTO tblconfiguration VALUES('ClientsProfileUneditableFields', '');
1029INSERT INTO tblconfiguration VALUES('ClientDisplayFormat', '1');
1030INSERT INTO tblconfiguration VALUES('CCDoNotRemoveOnExpiry', '');
1031INSERT INTO tblconfiguration VALUES('GenerateRandomUsername', '');
1032INSERT INTO tblconfiguration VALUES('AddFundsRequireOrder', 'on');
1033INSERT INTO tblconfiguration VALUES('GroupSimilarLineItems', 'on');
1034INSERT INTO tblconfiguration VALUES('ProrataClientsAnniversaryDate', '');
1035INSERT INTO tblconfiguration VALUES('TCPDFFont', 'helvetica');
1036INSERT INTO tblconfiguration VALUES('CancelInvoiceOnCancellation', 'on');
1037INSERT INTO tblconfiguration VALUES('AttachmentThumbnails', 'on');
1038INSERT INTO tblconfiguration VALUES('EmailGlobalHeader', '<p><a href="{$company_domain}" target="_blank"><img src="{$company_logo_url}" alt="{$company_name}" border="0" /></a></p>');
1039INSERT INTO tblconfiguration VALUES('EmailGlobalFooter', '');
1040INSERT INTO tblconfiguration VALUES('DomainSyncEnabled', 'on');
1041INSERT INTO tblconfiguration VALUES('DomainSyncNextDueDate', '');
1042INSERT INTO tblconfiguration VALUES('DomainSyncNextDueDateDays', '0');
1043INSERT INTO tblconfiguration VALUES('TicketMask', '%n%n%n%n%n%n');
1044INSERT INTO tblconfiguration VALUES('AutoClientStatusChange', '2');
1045INSERT INTO tblconfiguration VALUES('AllowClientsEmailOptOut', '');
1046INSERT INTO tblconfiguration VALUES('BannedSubdomainPrefixes', 'mail,mx,gapps,gmail,webmail,cpanel,whm,ftp,clients,billing,members,login,accounts,access');
1047INSERT INTO tblconfiguration VALUES('FreeDomainAutoRenewRequiresProduct', 'on');
1048INSERT INTO tblconfiguration VALUES('DomainToDoListEntries', 'on');
1049INSERT INTO tblconfiguration VALUES('InstanceID', 'SArAtdht8uUc');
1050INSERT INTO tblconfiguration VALUES('token_namespaces', 'a:3:{s:13:\"WHMCS.default\";b:1;s:19:\"WHMCS.admin.default\";b:1;s:19:\"WHMCS.domainchecker\";b:0;}');
1051INSERT INTO tblconfiguration VALUES('MaintenanceModeURL', '');
1052INSERT INTO tblconfiguration VALUES('ClientDateFormat', '');
1053INSERT INTO tblconfiguration VALUES('AllowIDNDomains', '');
1054INSERT INTO tblconfiguration VALUES('DomainSyncNotifyOnly', '');
1055INSERT INTO tblconfiguration VALUES('DefaultNameserver5', '');
1056INSERT INTO tblconfiguration VALUES('ShowClientOnlyDepts', '');
1057INSERT INTO tblconfiguration VALUES('TicketFeedback', '');
1058INSERT INTO tblconfiguration VALUES('DownloadsIncludeProductLinked', '');
1059INSERT INTO tblconfiguration VALUES('AffiliateDepartment', '');
1060INSERT INTO tblconfiguration VALUES('CaptchaType', '');
1061INSERT INTO tblconfiguration VALUES('ReCAPTCHAPrivateKey', '');
1062INSERT INTO tblconfiguration VALUES('ReCAPTCHAPublicKey', '');
1063INSERT INTO tblconfiguration VALUES('DisableAdminPWReset', '');
1064INSERT INTO tblconfiguration VALUES('TwitterUsername', '');
1065INSERT INTO tblconfiguration VALUES('AnnouncementsTweet', '');
1066INSERT INTO tblconfiguration VALUES('AnnouncementsFBRecommend', '');
1067INSERT INTO tblconfiguration VALUES('AnnouncementsFBComments', '');
1068INSERT INTO tblconfiguration VALUES('GooglePlus1', '');
1069INSERT INTO tblconfiguration VALUES('ClientsProfileOptionalFields', '');
1070INSERT INTO tblconfiguration VALUES('DefaultToClientArea', '');
1071INSERT INTO tblconfiguration VALUES('DisplayErrors', '');
1072INSERT INTO tblconfiguration VALUES('SQLErrorReporting', '');
1073INSERT INTO tblconfiguration VALUES('LoginFailures', 'a:1:{s:13:\"179.197.72.11\";a:2:{s:5:\"count\";i:1;s:7:\"expires\";i:1433875687;}}');
1074
1075
1076
1077
1078
1079
1080### tblconfiguration TABLE DUMP COMPLETED ###
1081
1082
1083DROP TABLE IF EXISTS tblcontacts;
1084CREATE TABLE `tblcontacts` (
1085  `id` int(10) NOT NULL AUTO_INCREMENT,
1086  `userid` int(10) NOT NULL,
1087  `firstname` text NOT NULL,
1088  `lastname` text NOT NULL,
1089  `companyname` text NOT NULL,
1090  `email` text NOT NULL,
1091  `address1` text NOT NULL,
1092  `address2` text NOT NULL,
1093  `city` text NOT NULL,
1094  `state` text NOT NULL,
1095  `postcode` text NOT NULL,
1096  `country` text NOT NULL,
1097  `phonenumber` text NOT NULL,
1098  `subaccount` int(1) NOT NULL DEFAULT '0',
1099  `password` text NOT NULL,
1100  `permissions` text NOT NULL,
1101  `domainemails` int(1) NOT NULL,
1102  `generalemails` int(1) NOT NULL,
1103  `invoiceemails` int(1) NOT NULL,
1104  `productemails` int(1) NOT NULL,
1105  `supportemails` int(1) NOT NULL,
1106  `affiliateemails` int(1) NOT NULL,
1107  `pwresetkey` text NOT NULL,
1108  `pwresetexpiry` int(10) NOT NULL,
1109  PRIMARY KEY (`id`),
1110  KEY `userid_firstname_lastname` (`userid`,`firstname`(32),`lastname`(32)),
1111  KEY `email` (`email`(64))
1112) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1113
1114
1115
1116
1117
1118
1119
1120### tblcontacts TABLE DUMP COMPLETED ###
1121
1122
1123DROP TABLE IF EXISTS tblcredit;
1124CREATE TABLE `tblcredit` (
1125  `id` int(10) NOT NULL AUTO_INCREMENT,
1126  `clientid` int(10) NOT NULL,
1127  `date` date NOT NULL,
1128  `description` text NOT NULL,
1129  `amount` decimal(10,2) NOT NULL,
1130  `relid` int(10) NOT NULL DEFAULT '0',
1131  PRIMARY KEY (`id`)
1132) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1133
1134
1135
1136
1137
1138
1139
1140### tblcredit TABLE DUMP COMPLETED ###
1141
1142
1143DROP TABLE IF EXISTS tblcurrencies;
1144CREATE TABLE `tblcurrencies` (
1145  `id` int(10) NOT NULL AUTO_INCREMENT,
1146  `code` text NOT NULL,
1147  `prefix` text NOT NULL,
1148  `suffix` text NOT NULL,
1149  `format` int(1) NOT NULL,
1150  `rate` decimal(10,5) NOT NULL DEFAULT '1.00000',
1151  `default` int(1) NOT NULL,
1152  PRIMARY KEY (`id`)
1153) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1154
1155INSERT INTO tblcurrencies VALUES('1', 'USD', '$', ' USD', '1', '1.00000', '1');
1156
1157
1158
1159
1160
1161
1162### tblcurrencies TABLE DUMP COMPLETED ###
1163
1164
1165DROP TABLE IF EXISTS tblcustomfields;
1166CREATE TABLE `tblcustomfields` (
1167  `id` int(10) NOT NULL AUTO_INCREMENT,
1168  `type` text NOT NULL,
1169  `relid` int(10) NOT NULL DEFAULT '0',
1170  `fieldname` text NOT NULL,
1171  `fieldtype` text NOT NULL,
1172  `description` text NOT NULL,
1173  `fieldoptions` text NOT NULL,
1174  `regexpr` text NOT NULL,
1175  `adminonly` text NOT NULL,
1176  `required` text NOT NULL,
1177  `showorder` text NOT NULL,
1178  `showinvoice` text NOT NULL,
1179  `sortorder` int(10) NOT NULL DEFAULT '0',
1180  PRIMARY KEY (`id`),
1181  KEY `serviceid` (`relid`)
1182) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1183
1184
1185
1186
1187
1188
1189
1190### tblcustomfields TABLE DUMP COMPLETED ###
1191
1192
1193DROP TABLE IF EXISTS tblcustomfieldsvalues;
1194CREATE TABLE `tblcustomfieldsvalues` (
1195  `fieldid` int(10) NOT NULL,
1196  `relid` int(10) NOT NULL,
1197  `value` text NOT NULL,
1198  KEY `fieldid_relid` (`fieldid`,`relid`)
1199) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1200
1201
1202
1203
1204
1205
1206
1207### tblcustomfieldsvalues TABLE DUMP COMPLETED ###
1208
1209
1210DROP TABLE IF EXISTS tbldomainpricing;
1211CREATE TABLE `tbldomainpricing` (
1212  `id` int(10) NOT NULL AUTO_INCREMENT,
1213  `extension` text NOT NULL,
1214  `dnsmanagement` text NOT NULL,
1215  `emailforwarding` text NOT NULL,
1216  `idprotection` text NOT NULL,
1217  `eppcode` text NOT NULL,
1218  `autoreg` text NOT NULL,
1219  `order` int(1) NOT NULL DEFAULT '0',
1220  PRIMARY KEY (`id`),
1221  KEY `extension_registrationperiod` (`extension`(32)),
1222  KEY `order` (`order`)
1223) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1224
1225
1226
1227
1228
1229
1230
1231### tbldomainpricing TABLE DUMP COMPLETED ###
1232
1233
1234DROP TABLE IF EXISTS tbldomains;
1235CREATE TABLE `tbldomains` (
1236  `id` int(10) NOT NULL AUTO_INCREMENT,
1237  `userid` int(10) NOT NULL,
1238  `orderid` int(1) NOT NULL,
1239  `type` enum('Register','Transfer') NOT NULL,
1240  `registrationdate` date NOT NULL,
1241  `domain` text NOT NULL,
1242  `firstpaymentamount` decimal(10,2) NOT NULL DEFAULT '0.00',
1243  `recurringamount` decimal(10,2) NOT NULL,
1244  `registrar` text NOT NULL,
1245  `registrationperiod` int(1) NOT NULL DEFAULT '1',
1246  `expirydate` date DEFAULT NULL,
1247  `subscriptionid` text NOT NULL,
1248  `promoid` int(10) NOT NULL,
1249  `status` enum('Pending','Pending Transfer','Active','Expired','Cancelled','Fraud') NOT NULL DEFAULT 'Pending',
1250  `nextduedate` date NOT NULL DEFAULT '0000-00-00',
1251  `nextinvoicedate` date NOT NULL,
1252  `additionalnotes` text NOT NULL,
1253  `paymentmethod` text NOT NULL,
1254  `dnsmanagement` text NOT NULL,
1255  `emailforwarding` text NOT NULL,
1256  `idprotection` text NOT NULL,
1257  `donotrenew` text NOT NULL,
1258  `reminders` text NOT NULL,
1259  `synced` int(1) NOT NULL,
1260  PRIMARY KEY (`id`),
1261  KEY `userid` (`userid`),
1262  KEY `orderid` (`orderid`),
1263  KEY `domain` (`domain`(64)),
1264  KEY `status` (`status`)
1265) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1266
1267
1268
1269
1270
1271
1272
1273### tbldomains TABLE DUMP COMPLETED ###
1274
1275
1276DROP TABLE IF EXISTS tbldomainsadditionalfields;
1277CREATE TABLE `tbldomainsadditionalfields` (
1278  `id` int(10) NOT NULL AUTO_INCREMENT,
1279  `domainid` int(10) NOT NULL,
1280  `name` text NOT NULL,
1281  `value` text NOT NULL,
1282  PRIMARY KEY (`id`),
1283  KEY `domainid` (`domainid`)
1284) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1285
1286
1287
1288
1289
1290
1291
1292### tbldomainsadditionalfields TABLE DUMP COMPLETED ###
1293
1294
1295DROP TABLE IF EXISTS tbldownloadcats;
1296CREATE TABLE `tbldownloadcats` (
1297  `id` int(10) NOT NULL AUTO_INCREMENT,
1298  `parentid` int(10) NOT NULL DEFAULT '0',
1299  `name` text NOT NULL,
1300  `description` text NOT NULL,
1301  `hidden` text NOT NULL,
1302  PRIMARY KEY (`id`),
1303  KEY `parentid` (`parentid`)
1304) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1305
1306
1307
1308
1309
1310
1311
1312### tbldownloadcats TABLE DUMP COMPLETED ###
1313
1314
1315DROP TABLE IF EXISTS tbldownloads;
1316CREATE TABLE `tbldownloads` (
1317  `id` int(10) NOT NULL AUTO_INCREMENT,
1318  `category` int(10) NOT NULL,
1319  `type` text NOT NULL,
1320  `title` text NOT NULL,
1321  `description` text NOT NULL,
1322  `downloads` int(10) NOT NULL DEFAULT '0',
1323  `location` text NOT NULL,
1324  `clientsonly` text NOT NULL,
1325  `hidden` text NOT NULL,
1326  `productdownload` text NOT NULL,
1327  PRIMARY KEY (`id`),
1328  KEY `title` (`title`(32)),
1329  KEY `downloads` (`downloads`)
1330) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1331
1332
1333
1334
1335
1336
1337
1338### tbldownloads TABLE DUMP COMPLETED ###
1339
1340
1341DROP TABLE IF EXISTS tblemailmarketer;
1342CREATE TABLE `tblemailmarketer` (
1343  `id` int(10) NOT NULL AUTO_INCREMENT,
1344  `name` text NOT NULL,
1345  `type` text NOT NULL,
1346  `settings` text NOT NULL,
1347  `disable` int(1) NOT NULL,
1348  `marketing` int(1) NOT NULL,
1349  PRIMARY KEY (`id`)
1350) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1351
1352
1353
1354
1355
1356
1357
1358### tblemailmarketer TABLE DUMP COMPLETED ###
1359
1360
1361DROP TABLE IF EXISTS tblemails;
1362CREATE TABLE `tblemails` (
1363  `id` int(10) NOT NULL AUTO_INCREMENT,
1364  `userid` int(10) NOT NULL,
1365  `subject` text NOT NULL,
1366  `message` text NOT NULL,
1367  `date` datetime DEFAULT NULL,
1368  `to` text,
1369  `cc` text,
1370  `bcc` text,
1371  PRIMARY KEY (`id`),
1372  KEY `userid` (`userid`)
1373) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1374
1375INSERT INTO tblemails VALUES('1', '1', 'Welcome', '<style>\nbody,td { font-family: verdana; font-size: 11px; font-weight: normal; }\r\na { color: #0000ff; }\n</style>\n<p><a href=\"http://www.thunhost.in\" target=\"_blank\"><img src=\"\" alt=\"Thun Host\" border=\"0\" /></a></p>\n<p>\r\nDear Habblack Hotel, \r\n</p>\r\n<p>\r\nThank you for signing up with us. Your new account has been setup and you can now login to our client area using the details below. \r\n</p>\r\n<p>\r\nEmail Address: luanramos38@hotmail.com<br />\r\nPassword: 26de12de \r\n</p>\r\n<p>\r\nTo login, visit http://thunhost.in \r\n</p>\r\n<p>\r\nSignature goes here... \r\n</p>\r', '2015-06-10 02:08:27', 'luanramos38@hotmail.com', '', '');
1376
1377
1378
1379
1380
1381
1382### tblemails TABLE DUMP COMPLETED ###
1383
1384
1385DROP TABLE IF EXISTS tblemailtemplates;
1386CREATE TABLE `tblemailtemplates` (
1387  `id` int(10) NOT NULL AUTO_INCREMENT,
1388  `type` text NOT NULL,
1389  `name` text NOT NULL,
1390  `subject` text NOT NULL,
1391  `message` text NOT NULL,
1392  `attachments` text NOT NULL,
1393  `fromname` text NOT NULL,
1394  `fromemail` text NOT NULL,
1395  `disabled` text NOT NULL,
1396  `custom` text NOT NULL,
1397  `language` text NOT NULL,
1398  `copyto` text NOT NULL,
1399  `plaintext` int(1) NOT NULL,
1400  PRIMARY KEY (`id`),
1401  KEY `type` (`type`(32)),
1402  KEY `name` (`name`(64))
1403) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
1404
1405INSERT INTO tblemailtemplates VALUES('1', 'product', 'Hosting Account Welcome Email', 'New Account Information', '<p>Dear {$client_name},</p><p align=\"center\"><strong>PLEASE READ THIS EMAIL IN FULL AND PRINT IT FOR YOUR RECORDS</strong></p><p>Thank you for your order from us! Your hosting account has now been setup and this email contains all the information you will need in order to begin using your account.</p><p>If you have requested a domain name during sign up, please keep in mind that your domain name will not be visible on the internet instantly. This process is called propagation and can take up to 48 hours. Until your domain has propagated, your website and email will not function, we have provided a temporary url which you may use to view your website and upload files in the meantime.</p><p><strong>New Account Information</strong></p><p>Hosting Package: {$service_product_name}<br />Domain: {$service_domain}<br />First Payment Amount: {$service_first_payment_amount}<br />Recurring Amount: {$service_recurring_amount}<br />Billing Cycle: {$service_billing_cycle}<br />Next Due Date: {$service_next_due_date}</p><p><strong>Login Details</strong></p><p>Username: {$service_username}<br />Password: {$service_password}</p><p>Control Panel URL: <a href=\"http://{$service_server_ip}:2082/\">http://{$service_server_ip}:2082/</a><br />Once your domain has propogated, you may also use <a href=\"http://www.{$service_domain}:2082/\">http://www.{$service_domain}:2082/</a></p><p><strong>Server Information</strong></p><p>Server Name: {$service_server_name}<br />Server IP: {$service_server_ip}</p><p>If you are using an existing domain with your new hosting account, you will need to update the nameservers to point to the nameservers listed below.</p><p>Nameserver 1: {$service_ns1} ({$service_ns1_ip})<br />Nameserver 2: {$service_ns2} ({$service_ns2_ip}){if $service_ns3}<br />Nameserver 3: {$service_ns3} ({$service_ns3_ip}){/if}{if $service_ns4}<br />Nameserver 4: {$service_ns4} ({$service_ns4_ip}){/if}</p><p><strong>Uploading Your Website</strong></p><p>Temporarily you may use one of the addresses given below to manage your web site:</p><p>Temporary FTP Hostname: {$service_server_ip}<br />Temporary Webpage URL: <a href=\"http://{$service_server_ip}/~{$service_username}/\">http://{$service_server_ip}/~{$service_username}/</a></p><p>And once your domain has propagated you may use the details below:</p><p>FTP Hostname: {$service_domain}<br />Webpage URL: <a href=\"http://www.{$service_domain}\">http://www.{$service_domain}</a></p><p><strong>Email Settings</strong></p><p>For email accounts that you setup, you should use the following connection details in your email program:</p><p>POP3 Host Address: mail.{$service_domain}<br />SMTP Host Address: mail.{$service_domain}<br />Username: The email address you are checking email for<br />Password: As specified in your control panel</p><p>Thank you for choosing us.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1406INSERT INTO tblemailtemplates VALUES('3', 'domain', 'Domain Registration Confirmation', 'Domain Registration Confirmation', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThis message is to confirm that your domain purchase has been successful. The details of the domain purchase are below: \r\n</p>\r\n<p>\r\nRegistration Date: {$domain_reg_date}<br />\r\nDomain: {$domain_name}<br />\r\nRegistration Period: {$domain_reg_period}<br />\r\nAmount: {$domain_first_payment_amount}<br />\r\nNext Due Date: {$domain_next_due_date} \r\n</p>\r\n<p>\r\nYou may login to your client area at {$whmcs_url} to manage your new domain. \r\n</p>\r\n<p>\r\n{$signature} \r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1407INSERT INTO tblemailtemplates VALUES('4', 'product', 'Reseller Account Welcome Email', 'Reseller Account Information', '<p align=\"center\">\r\n<strong>PLEASE PRINT THIS MESSAGE FOR YOUR RECORDS - PLEASE READ THIS EMAIL IN FULL.</strong>\r\n</p>\r\n<p>\r\nIf you have requested a domain name during sign up then this will not be visible on the internet for between 24 and 72 hours. This process is called Propagation. Until your domain has Propagated your website and email will not function, we have provided a temporary url which you may use to view your website and upload files in the meantime.\r\n</p>\r\n<p>\r\nDear {$client_name},\r\n</p>\r\n<p>\r\nThe reseller hosting account for {$service_domain} has been set up. The username and password below are for both cPanel to manage the website at {$service_domain} and WebHostManager to manage your Reseller Account.\r\n</p>\r\n<p>\r\n<strong>New Account Info</strong>\r\n</p>\r\n<p>\r\nDomain: {$service_domain}<br />\r\nUsername: {$service_username}<br />\r\nPassword: {$service_password}<br />\r\nHosting Package: {$service_product_name}\r\n</p>\r\n<p>\r\nControl Panel: <a href=\"http://{$service_server_ip}:2082/\">http://{$service_server_ip}:2082/</a><br />\r\nWeb Host Manager: <a href=\"http://{$service_server_ip}:2086/\">http://{$service_server_ip}:2086/</a>\r\n</p>\r\n<p>\r\n-------------------------------------------------------------------------------------------- <br />\r\n<strong>Web Host Manager Quick Start</strong> <br />\r\n-------------------------------------------------------------------------------------------- <br />\r\n<br />\r\nTo access your Web Host Manager, use the following address:<br />\r\n<br />\r\n<a href=\"http://{$service_server_ip}:2086/\">http://{$service_server_ip}:2086/</a><br />\r\n<br />\r\nThe <strong>http://</strong> must be in the address line to connect to port :2086 <br />\r\nPlease use the username/password given above. <br />\r\n<br />\r\n<strong><em>To Create a New Account <br />\r\n</em></strong><br />\r\nThe first thing you need to do is scroll down on the left and click on &#39Add Package&#39 so that you can create your own hosting packages. You cannot install a domain onto your account without first creating packages.<br />\r\n<br />\r\n1. Click on &#39Create a New Account&#39 from the left hand side menu <br />\r\n2. Put the domain in the &#39Domain&#39 box (no www or http or spaces ? just domainname.com). After putting in the domain, hit TAB and it will automatically create a username. Also, enter a password for the account.<br />\r\n3. Your package selection should be one that you created earlier <br />\r\n4. Then press the create button <br />\r\n<br />\r\nThis will give you a confirmation page (you should print this for your records)\r\n</p>\r\n<p>\r\nPlease do not click on anything that you are not sure what it does. Please do not try to alter the WHM Theme from the selection box - fatal errors may occur. \r\n</p>\r\n<p>\r\n-------------------------------------------------------------------------------------------- \r\n</p>\r\n<p>\r\nTemporarily you may use one of the addresses given below manage your web site\r\n</p>\r\n<p>\r\nTemporary FTP Hostname: {$service_server_ip}<br />\r\nTemporary Webpage URL: <a href=\"http://{$service_server_ip}/~{$service_username}/\">http://{$service_server_ip}/~{$service_username}/</a><br />\r\nTemporary Control Panel: <a href=\"http://{$service_server_ip}/cpanel\">http://{$service_server_ip}/cpanel</a>\r\n</p>\r\n<p>\r\nOnce your domain has Propagated\r\n</p>\r\n<p>\r\nFTP Hostname: www.{$service_domain}<br />\r\nWebpage URL: <a href=\"http://www.{$service_domain}\">http://www.{$service_domain}</a><br />\r\nControl Panel: <a href=\"http://www.{$service_domain}/cpanel\">http://www.{$service_domain}/cpanel</a><br />\r\nWeb Host Manager: <a href=\"http://www.{$service_domain}/whm\">http://www.{$service_domain}/whm</a>\r\n</p>\r\n<p>\r\n<strong>Mail settings</strong>\r\n</p>\r\n<p>\r\nCatch all email with your default email account\r\n</p>\r\n<p>\r\nPOP3 Host Address : mail.{$service_domain}<br />\r\nSMTP Host Address: mail.{$service_domain}<br />\r\nUsername: {$service_username}<br />\r\nPassword: {$service_password}\r\n</p>\r\n<p>\r\nAdditional mail accounts that you add\r\n</p>\r\n<p>\r\nPOP3 Host Address : mail.{$service_domain}<br />\r\nSMTP Host Address: mail.{$service_domain}<br />\r\nUsername : The FULL email address that you are picking up from (e.g. info@yourdomain.com). <br />\r\nIf your email client cannot accept a @ symbol, then you may replace this with a backslash .<br />\r\nPassword : As specified in your control panel \r\n</p>\r\n<p>\r\nThank you for choosing us.\r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1408INSERT INTO tblemailtemplates VALUES('7', 'support', 'Support Ticket Opened', 'New Support Ticket Opened', '<p>\r\n{$client_name},\r\n</p>\r\n<p>\r\nThank you for contacting our support team. A support ticket has now been opened for your request. You will be notified when a response is made by email. The details of your ticket are shown below.\r\n</p>\r\n<p>\r\nSubject: {$ticket_subject}<br />\r\nPriority: {$ticket_priority}<br />\r\nStatus: {$ticket_status}\r\n</p>\r\n<p>\r\nYou can view the ticket at any time at {$ticket_link}\r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1409INSERT INTO tblemailtemplates VALUES('8', 'support', 'Support Ticket Reply', 'Support Ticket Response', '<p>\r\n{$ticket_message}\r\n</p>\r\n<p>\r\n----------------------------------------------<br />\r\nTicket ID: #{$ticket_id}<br />\r\nSubject: {$ticket_subject}<br />\r\nStatus: {$ticket_status}<br />\r\nTicket URL: {$ticket_link}<br />\r\n----------------------------------------------\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1410INSERT INTO tblemailtemplates VALUES('9', 'general', 'Client Signup Email', 'Welcome', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThank you for signing up with us. Your new account has been setup and you can now login to our client area using the details below. \r\n</p>\r\n<p>\r\nEmail Address: {$client_email}<br />\r\nPassword: {$client_password} \r\n</p>\r\n<p>\r\nTo login, visit {$whmcs_url} \r\n</p>\r\n<p>\r\n{$signature} \r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1411INSERT INTO tblemailtemplates VALUES('10', 'product', 'Service Suspension Notification', 'Service Suspension Notification', '<p>Dear {$client_name},</p><p>This is a notification that your service has now been suspended.  The details of this suspension are below:</p><p>Product/Service: {$service_product_name}<br />{if $service_domain}Domain: {$service_domain}<br />{/if}Amount: {$service_recurring_amount}<br />Due Date: {$service_next_due_date}<br />Suspension Reason: <strong>{$service_suspension_reason}</strong></p><p>Please contact us as soon as possible to get your service reactivated.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1412INSERT INTO tblemailtemplates VALUES('13', 'invoice', 'Invoice Payment Confirmation', 'Invoice Payment Confirmation', '<p>Dear {$client_name},</p>\r\n<p>This is a payment receipt for Invoice {$invoice_num} sent on {$invoice_date_created}</p>\r\n<p>{$invoice_html_contents}</p>\r\n<p>Amount: {$invoice_last_payment_amount}<br />Transaction #: {$invoice_last_payment_transid}<br />Total Paid: {$invoice_amount_paid}<br />Remaining Balance: {$invoice_balance}<br />Status: {$invoice_status}</p>\r\n<p>You may review your invoice history at any time by logging in to your client area.</p>\r\n<p>Note: This email will serve as an official receipt for this payment.</p>\r\n<p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1413INSERT INTO tblemailtemplates VALUES('14', 'invoice', 'Invoice Created', 'Customer Invoice', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThis is a notice that an invoice has been generated on {$invoice_date_created}. \r\n</p>\r\n<p>\r\nYour payment method is: {$invoice_payment_method} \r\n</p>\r\n<p>\r\nInvoice #{$invoice_num}<br />\r\nAmount Due: {$invoice_total}<br />\r\nDue Date: {$invoice_date_due} \r\n</p>\r\n<p>\r\n<strong>Invoice Items</strong> \r\n</p>\r\n<p>\r\n{$invoice_html_contents} <br />\r\n------------------------------------------------------ \r\n</p>\r\n<p>\r\nYou can login to your client area to view and pay the invoice at {$invoice_link} \r\n</p>\r\n<p>\r\n{$signature} \r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1414INSERT INTO tblemailtemplates VALUES('15', 'invoice', 'Invoice Payment Reminder', 'Invoice Payment Reminder', '<p>\r\nDear {$client_name},\r\n</p>\r\n<p>\r\nThis is a billing reminder that your invoice no. {$invoice_num} which was generated on {$invoice_date_created} is due on {$invoice_date_due}.\r\n</p>\r\n<p>\r\nYour payment method is: {$invoice_payment_method}\r\n</p>\r\n<p>\r\nInvoice: {$invoice_num}<br />\r\nBalance Due: {$invoice_balance}<br />\r\nDue Date: {$invoice_date_due}\r\n</p>\r\n<p>\r\nYou can login to your client area to view and pay the invoice at {$invoice_link}\r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1415INSERT INTO tblemailtemplates VALUES('16', 'general', 'Order Confirmation', 'Order Confirmation', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nWe have received your order and will be processing it shortly. The details of the order are below: \r\n</p>\r\n<p>\r\nOrder Number: <b>{$order_number}</b></p>\r\n<p>\r\n{$order_details} \r\n</p>\r\n<p>\r\nYou will receive an email from us shortly once your account has been setup. Please quote your order reference number if you wish to contact us about this order. \r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1416INSERT INTO tblemailtemplates VALUES('17', 'product', 'Dedicated/VPS Server Welcome Email', 'New Dedicated Server Information', '<p>\r\nDear {$client_name},<br />\r\n<br />\r\n<strong>PLEASE PRINT THIS MESSAGE FOR YOUR RECORDS - PLEASE READ THIS EMAIL IN FULL.</strong>\r\n</p>\r\n<p>\r\nWe are pleased to tell you that the server you ordered has now been set up and is operational.\r\n</p>\r\n<p>\r\n<strong>Server Details<br />\r\n</strong>=============================\r\n</p>\r\n<p>\r\n{$service_product_name}\r\n</p>\r\n<p>\r\nMain IP: {$service_dedicated_ip}<br />\r\nRoot pass: {$service_password}\r\n</p>\r\n<p>\r\nIP address allocation: <br />\r\n{$service_assigned_ips}\r\n</p>\r\n<p>\r\nServerName: {$service_domain}\r\n</p>\r\n<p>\r\n<strong>WHM Access<br />\r\n</strong>=============================<br />\r\n<a href=\"http://xxxxx:2086/\">http://xxxxx:2086</a><br />\r\nUsername: root<br />\r\nPassword: {$service_password}\r\n</p>\r\n<p>\r\n<strong>Custom DNS Server Addresses</strong><br />\r\n=============================<br />\r\nThe custom DNS addresses you should set for your domain to use are: <br />\r\nPrimary DNS: {$service_ns1}<br />\r\nSecondary DNS: {$service_ns2}\r\n</p>\r\n<p>\r\nYou will have to login to your registrar and find the area where you can specify both of your custom name server addresses.\r\n</p>\r\n<p>\r\nAfter adding these custom nameservers to your domain registrar control panel, it will take 24 to 48 hours for your domain to delegate authority to your DNS server. Once this has taken effect, your DNS server has control over the DNS records for the domains which use your custom name server addresses. \r\n</p>\r\n<p>\r\n<strong>SSH Access Information<br />\r\n</strong>=============================<br />\r\nMain IP Address: xxxxxxxx<br />\r\nServer Name: {$service_domain}<br />\r\nRoot Password: xxxxxxxx\r\n</p>\r\n<p>\r\nYou can access your server using a free simple SSH client program called Putty located at:<br />\r\n<a href=\"http://www.securitytools.net/mirrors/putty/\">http://www.securitytools.net/mirrors/putty/</a>\r\n</p>\r\n<p>\r\n<strong>Support</strong><br />\r\n=============================<br />\r\nFor any support needs, please open a ticket at {$whmcs_url}\r\n</p>\r\n<p>\r\nPlease include any necessary information to provide you with faster service, such as root password, domain names, and a description of the problem / or assistance needed. This will speed up the support time by allowing our administrators to immediately begin diagnosing the problem.\r\n</p>\r\n<p>\r\nThe manual for cPanel can be found here: <a href=\"http://www.cpanel.net/docs/cp/\">http://www.cpanel.net/docs/cp/</a> <br />\r\nFor documentation on using WHM please see the following link: <a href=\"http://www.cpanel.net/docs/whm/index.html\">http://www.cpanel.net/docs/whm/index.html</a>\r\n</p>\r\n<p>\r\n=============================\r\n</p>\r\n<p>\r\nIf you need to move accounts to the server use: Transfers Copy an account from another server with account password\r\n</p>\r\n<p>\r\n<a href=\"http://xxxxxxx:2086/scripts2/norootcopy\">http://xxxxxxx:2086/scripts2/norootcopy</a>\r\n</p>\r\n<p>\r\nNote the other server must use cpanel to move it.\r\n</p>\r\n<p>\r\n=============================\r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1417INSERT INTO tblemailtemplates VALUES('18', 'product', 'Other Product/Service Welcome Email', 'New Product Information', '<p>\r\nDear {$client_name},\r\n</p>\r\n<p>\r\nYour order for {$service_product_name} has now been activated. Please keep this message for your records.\r\n</p>\r\n<p>\r\nProduct/Service: {$service_product_name}<br />\r\nPayment Method: {$service_payment_method}<br />\r\nAmount: {$service_recurring_amount}<br />\r\nBilling Cycle: {$service_billing_cycle}<br />\r\nNext Due Date: {$service_next_due_date}\r\n</p>\r\n<p>\r\nThank you for choosing us.\r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1418INSERT INTO tblemailtemplates VALUES('19', 'invoice', 'Credit Card Payment Confirmation', 'Credit Card Payment Confirmation', '<p>Dear {$client_name},</p>\r\n<p>This is a payment receipt for Invoice {$invoice_num} sent on {$invoice_date_created}</p>\r\n<p>{$invoice_html_contents}</p>\r\n<p>Amount: {$invoice_last_payment_amount}<br />Transaction #: {$invoice_last_payment_transid}<br />Total Paid: {$invoice_amount_paid}<br />Remaining Balance: {$invoice_balance}<br />Status: {$invoice_status}</p>\r\n<p>You may review your invoice history at any time by logging in to your client area.</p>\r\n<p>Note: This email will serve as an official receipt for this payment.</p>\r\n<p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1419INSERT INTO tblemailtemplates VALUES('20', 'invoice', 'Credit Card Payment Failed', 'Credit Card Payment Failed', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThis is a notice that a recent credit card payment we attempted on the card we have registered for you failed. \r\n</p>\r\n<p>\r\nInvoice Date: {$invoice_date_created}<br />\r\nInvoice No: {$invoice_num}<br />\r\nAmount: {$invoice_total}<br />\r\nStatus: {$invoice_status} \r\n</p>\r\n<p>\r\nYou now need to login to your client area to pay the invoice manually. During the payment process you will be given the opportunity to change the card on record with us.<br />\r\n{$invoice_link} \r\n</p>\r\n<p>\r\nNote: This email will serve as an official receipt for this payment. \r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1420INSERT INTO tblemailtemplates VALUES('21', 'invoice', 'Credit Card Invoice Created', 'Customer Invoice', '<p> Dear {$client_name}, </p> <p> This is a notice that an invoice has been generated on {$invoice_date_created}. </p> <p> Your payment method is: {$invoice_payment_method} </p> <p> Invoice #{$invoice_num}<br /> Amount Due: {$invoice_total}<br /> Due Date: {$invoice_date_due} </p> <p> <strong>Invoice Items</strong> </p> <p> {$invoice_html_contents} <br /> ------------------------------------------------------ </p> <p> Payment will be taken automatically on {$invoice_date_due} from your credit card on record with us. To update or change the credit card details we hold for your account please login at {$invoice_link} and click Pay Now then following the instructions on screen. </p> <p> {$signature} </p>', '', '', '', '', '', '', '', '0');
1421INSERT INTO tblemailtemplates VALUES('22', 'affiliate', 'Affiliate Monthly Referrals Report', 'Affiliate Monthly Referrals Report', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThis is your monthly affiliate referrals report. You can view your referral statistics at any time by logging in to the client area. \r\n</p>\r\n<p>\r\nTotal Visitors Referred: {$affiliate_total_visits}<br />\r\nCurrent Earnings: {$affiliate_balance}<br />\r\nAmount Withdrawn: {$affiliate_withdrawn} \r\n</p>\r\n<p>\r\n<strong>Your New Signups this Month</strong> \r\n</p>\r\n<p>\r\n{$affiliate_referrals_table} \r\n</p>\r\n<p>\r\nRemember, you can refer new customers using your unique affiliate link: {$affiliate_referral_url} \r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1422INSERT INTO tblemailtemplates VALUES('23', 'support', 'Support Ticket Opened by Admin', '{$ticket_subject}', '{$ticket_message}', '', '', '', '', '', '', '', '0');
1423INSERT INTO tblemailtemplates VALUES('24', 'invoice', 'First Invoice Overdue Notice', 'First Invoice Overdue Notice', '<p> Dear {$client_name}, </p> <p> This is a billing notice that your invoice no. {$invoice_num} which was generated on {$invoice_date_created} is now overdue. </p> <p> Your payment method is: {$invoice_payment_method} </p> <p> Invoice: {$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due Date: {$invoice_date_due} </p> <p> You can login to your client area to view and pay the invoice at {$invoice_link} </p> <p> {$signature} </p>', '', '', '', '', '', '', '', '0');
1424INSERT INTO tblemailtemplates VALUES('25', 'product', 'SHOUTcast Welcome Email', 'SHOUTcast New Account Information', '<p align=\"center\">\r\n<strong>PLEASE READ THIS EMAIL IN FULL AND PRINT IT FOR YOUR RECORDS</strong> \r\n</p>\r\n<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThank you for your order from us! Your shoutcast account has now been setup and this email contains all the information you will need in order to begin using your account. \r\n</p>\r\n<p>\r\n<strong>New Account Information</strong> \r\n</p>\r\n<p>\r\nDomain: {$service_domain}<br />\r\nUsername: {$service_username}<br />\r\nPassword: {$service_password} \r\n</p>\r\n<p>\r\n<strong>Server Information</strong> \r\n</p>\r\n<p>\r\nServer Name: {$service_server_name}<br />\r\nServer IP: {$service_server_ip}<br />\r\nNameserver 1: {$service_ns1}<br />\r\nNameserver 1 IP: {$service_ns1_ip}<br />\r\nNameserver 2: {$service_ns2} <br />\r\nNameserver 2 IP: {$service_ns2_ip} \r\n</p>\r\n<p>\r\nThank you for choosing us. \r\n</p>\r\n<p>\r\n{$signature}\r\n</p>\r\n', '', '', '', '', '', '', '', '0');
1425INSERT INTO tblemailtemplates VALUES('26', 'invoice', 'Second Invoice Overdue Notice', 'Second Invoice Overdue Notice', '<p> Dear {$client_name}, </p> <p> This is the second billing notice that your invoice no. {$invoice_num} which was generated on {$invoice_date_created} is now overdue. </p> <p> Your payment method is: {$invoice_payment_method} </p> <p> Invoice: {$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due Date: {$invoice_date_due} </p> <p> You can login to your client area to view and pay the invoice at {$invoice_link} </p> <p> {$signature} </p>', '', '', '', '', '', '', '', '0');
1426INSERT INTO tblemailtemplates VALUES('27', 'invoice', 'Third Invoice Overdue Notice', 'Third Invoice Overdue Notice', '<p> Dear {$client_name}, </p> <p> This is the third and final billing notice that your invoice no. {$invoice_num} which was generated on {$invoice_date_created} is now overdue. Failure to make payment will result in account suspension.</p> <p> Your payment method is: {$invoice_payment_method} </p> <p> Invoice: {$invoice_num}<br /> Balance Due: {$invoice_balance}<br /> Due Date: {$invoice_date_due} </p> <p> You can login to your client area to view and pay the invoice at {$invoice_link} </p> <p> {$signature} </p>', '', '', '', '', '', '', '', '0');
1427INSERT INTO tblemailtemplates VALUES('28', 'domain', 'Domain Transfer Initiated', 'Domain Transfer Initiated', '<p>Dear {$client_name}, </p><p>Thank you for your domain transfer order. Your order has been received and we have now initiated the transfer process. The details of the domain purchase are below: </p><p>Domain: {$domain_name}<br />Registration Length: {$domain_reg_period}<br />Transfer Price: {$domain_first_payment_amount}<br />Renewal Price: {$domain_recurring_amount}<br />Next Due Date: {$domain_next_due_date} </p><p>You may login to your client area at {$whmcs_url} to manage your domain. </p><p>{$signature} </p>', '', '', '', '', '', '', '', '0');
1428INSERT INTO tblemailtemplates VALUES('29', 'domain', 'Domain Renewal Confirmation', 'Domain Renewal Confirmation', '<p>Dear {$client_name}, </p><p>Thank you for your domain renewal order. Your domain renewal request for the domain listed below has now been completed.</p><p>Domain: {$domain_name}<br />Renewal Length: {$domain_reg_period}<br />Renewal Price: {$domain_recurring_amount}<br />Next Due Date: {$domain_next_due_date} </p><p>You may login to your client area at {$whmcs_url} to manage your domain. </p><p>{$signature} </p>', '', '', '', '', '', '', '', '0');
1429INSERT INTO tblemailtemplates VALUES('30', 'domain', 'Upcoming Domain Renewal Notice', 'Upcoming Domain Renewal Notice', '<p>Dear {$client_name},</p><p>{if $days_until_expiry}The domain(s) listed below are due to expire within the next {$days_until_expiry} days.{else}The domain(s) listed below are going to expire in {$domain_days_until_expiry} days. Renew now before it\'s too late...{/if}</p><p>{if $expiring_domains}{foreach from=$expiring_domains item=domain}{$domain.name} - {$domain.nextduedate} <strong>({$domain.days} Days)</strong><br />{/foreach}{else}{$domain_name} - {$domain_next_due_date} <strong>({$domain_days_until_nextdue} Days)</strong>{/if}</p><p>To ensure the domain does not expire, you should renew it now. You can do this from the domains management section of our client area here: {$whmcs_link}</p><p>Should you allow the domain to expire, you will be able to renew it for up to 30 days after the renewal date. During this time, the domain will not be accessible so any web site or email services associated with it will stop working.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1430INSERT INTO tblemailtemplates VALUES('31', 'support', 'Clients Only Bounce Message', 'Support Ticket Not Opened', '<p>{$client_name},</p><p>Your email to our support system could not be accepted because it was not recognized as coming from an email address belonging to one of our customers.  If you need assistance, please email from the address you registered with us that you use to login to our client area.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1431INSERT INTO tblemailtemplates VALUES('32', 'general', 'Credit Card Expiring Soon', 'Credit Card Expiring Soon', '<p>Dear {$client_name}, </p><p>This is a notice to inform you that your {$client_cc_type} credit card ending with {$client_cc_number} will be expiring next month on {$client_cc_expiry}. Please login to update your credit card information as soon as possible and prevent any interuptions in service at {$whmcs_url}<br /><br />If you have any questions regarding your account, please open a support ticket from the client area.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1432INSERT INTO tblemailtemplates VALUES('33', 'support', 'Support Ticket Auto Close Notification', 'Support Ticket Resolved', '<p>{$client_name},</p><p>This is a notification to let you know that we are changing the status of your ticket #{$ticket_id} to Closed as we have not received a response from you in over {$ticket_auto_close_time} hours.</p><p>Subject: {$ticket_subject}<br>Department: {$ticket_department}<br>Priority: {$ticket_priority}<br>Status: {$ticket_status}</p><p>If you have any further questions then please just reply to re-open the ticket.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1433INSERT INTO tblemailtemplates VALUES('34', 'invoice', 'Credit Card Payment Due', 'Invoice Payment Reminder', '<p>Dear {$client_name},</p><p>This is a notice to remind you that you have an invoice due on {$invoice_date_due}. We tried to bill you automatically but were unable to because we don\'t have your credit card details on file.</p><p>Invoice Date: {$invoice_date_created}<br>Invoice #{$invoice_num}<br>Amount Due: {$invoice_total}<br>Due Date: {$invoice_date_due}</p><p>Please login to our client area at the link below to submit your card details or make payment using a different method.</p><p>{$invoice_link}</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1434INSERT INTO tblemailtemplates VALUES('35', 'product', 'Cancellation Request Confirmation', 'Cancellation Request Confirmation', '<p>Dear {$client_name},</p><p>This email is to confirm that we have received your cancellation request for the service listed below.</p><p>Product/Service: {$service_product_name}<br />Domain: {$service_domain}</p><p>{if $service_cancellation_type==\"Immediate\"}The service will be terminated within the next 24 hours.{else}The service will be cancelled at the end of your current billing period on {$service_next_due_date}.{/if}</p><p>Thank you for using {$company_name} and we hope to see you again in the future.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1435INSERT INTO tblemailtemplates VALUES('36', 'general', 'Quote Delivery with PDF', 'Quote #{$quote_number} - {$quote_subject}', '<p>Dear {$client_name},</p><p>Here is the quote you requested for {$quote_subject}. The quote is valid until {$quote_valid_until}. You may {if $client_id}view the quote at any time at {$quote_link} and {/if}simply reply to this email with any further questions or requirement.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1436INSERT INTO tblemailtemplates VALUES('37', 'general', 'Password Reset Validation', 'Your login details for {$company_name}', '<p>Dear {$client_name},</p><p>Recently a request was submitted to reset your password for our client area. If you did not request this, please ignore this email. It will expire and become useless in 2 hours time.</p><p>To reset your password, please visit the url below:<br /><a href=\"{$pw_reset_url}\">{$pw_reset_url}</a></p><p>When you visit the link above, you will have the opportunity to choose a new password.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1437INSERT INTO tblemailtemplates VALUES('38', 'general', 'Automated Password Reset', 'Your new password for {$company_name}', '<p>Dear {$client_name},</p><p>As you requested, your password for our client area has now been reset.  Your new login details are as follows:</p><p>{$whmcs_link}<br />Email: {$client_email}<br />Password: {$client_password}</p><p>To change your password to something more memorable, after logging in go to My Details > Change Password.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1438INSERT INTO tblemailtemplates VALUES('39', 'admin', 'Automatic Setup Failed', 'WHMCS Automatic Setup Failed', '<p>An order has received its first payment but the automatic provisioning has failed and requires you to manually check & resolve.</p>\r\n<p>Client ID: {$client_id}<br />{if $service_id}Service ID: {$service_id}<br />Product/Service: {$service_product}<br />Domain: {$service_domain}{else}Domain ID: {$domain_id}<br />Registration Type: {$domain_type}<br />Domain: {$domain_name}{/if}<br />Error: {$error_msg}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1439INSERT INTO tblemailtemplates VALUES('40', 'admin', 'Automatic Setup Successful', 'WHMCS Automatic Setup Successful', '<p>An order has received its first payment and the product/service has been automatically provisioned successfully.</p>\r\n<p>Client ID: {$client_id}<br />{if $service_id}Service ID: {$service_id}<br />Product/Service: {$service_product}<br />Domain: {$service_domain}{else}Domain ID: {$domain_id}<br />Registration Type: {$domain_type}<br />Domain: {$domain_name}{/if}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1440INSERT INTO tblemailtemplates VALUES('41', 'admin', 'Domain Renewal Failed', 'WHMCS Automatic Domain Renewal Failed', '<p>An invoice for the renewal of a domain has been paid but the renewal request submitted to the registrar failed.</p>\r\n<p>Client ID: {$client_id}<br />Domain ID: {$domain_id}<br />Domain Name: {$domain_name}<br />Error: {$error_msg}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1441INSERT INTO tblemailtemplates VALUES('42', 'admin', 'Domain Renewal Successful', 'WHMCS Automatic Domain Renewal Successful', '<p>An invoice for the renewal of a domain has been paid and the renewal request was submitted to the registrar successfully.</p>\r\n<p>Client ID: {$client_id}<br />Domain ID: {$domain_id}<br />Domain Name: {$domain_name}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1442INSERT INTO tblemailtemplates VALUES('43', 'admin', 'New Order Notification', 'WHMCS New Order Notification', '<p><strong>Order Information</strong></p>\r\n<p>Order ID: {$order_id}<br />\r\nOrder Number: {$order_number}<br />\r\nDate/Time: {$order_date}<br />\r\nInvoice Number: {$invoice_id}<br />\r\nPayment Method: {$order_payment_method}</p>\r\n<p><strong>Customer Information</strong></p>\r\n<p>Customer ID: {$client_id}<br />\r\nName: {$client_first_name} {$client_last_name}<br />\r\nEmail: {$client_email}<br />\r\nCompany: {$client_company_name}<br />\r\nAddress 1: {$client_address1}<br />\r\nAddress 2: {$client_address2}<br />\r\nCity: {$client_city}<br />\r\nState: {$client_state}<br />\r\nPostcode: {$client_postcode}<br />\r\nCountry: {$client_country}<br />\r\nPhone Number: {$client_phonenumber}</p>\r\n<p><strong>Order Items</strong></p>\r\n<p>{$order_items}</p>\r\n{if $order_notes}<p><strong>Order Notes</strong></p>\r\n<p>{$order_notes}</p>{/if}\r\n<p><strong>ISP Information</strong></p>\r\n<p>IP: {$client_ip}<br />\r\nHost: {$client_hostname}</p><p><a href=\"{$whmcs_admin_url}orders.php?action=view&id={$order_id}\">{$whmcs_admin_url}orders.php?action=view&id={$order_id}</a></p>', '', '', '', '', '', '', '', '0');
1443INSERT INTO tblemailtemplates VALUES('44', 'admin', 'Service Unsuspension Failed', 'WHMCS Service Unsuspension Failed', '<p>This product/service has received its next payment but the automatic reactivation has failed.</p>\r\n<p>Client ID: {$client_id}<br />Service ID: {$service_id}<br />Product/Service: {$service_product}<br />Domain: {$service_domain}<br />Error: {$error_msg}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1444INSERT INTO tblemailtemplates VALUES('45', 'admin', 'Service Unsuspension Successful', 'WHMCS Service Unsuspension Successful', '<p>This product/service has received its next payment and has been reactivated successfully.</p>\r\n<p>Client ID: {$client_id}<br />Service ID: {$service_id}<br />Product/Service: {$service_product}<br />Domain: {$service_domain}</p>\r\n<p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1445INSERT INTO tblemailtemplates VALUES('46', 'admin', 'Support Ticket Created', '[Ticket ID: {$ticket_tid}] New Support Ticket Opened', '<p>A new support ticket has been opened.</p>\r\n<p>Client: {$client_name}{if $client_id} #{$client_id}{/if}<br />Department: {$ticket_department}<br />Subject: {$ticket_subject}<br />Priority: {$ticket_priority}</p>\r\n<p>---<br />{$ticket_message}<br />---</p>\r\n<p>You can respond to this ticket by simply replying to this email or through the admin area at the url below.</p>\r\n<p><a href=\"{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}\">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '', '', '', '', '', '', '', '0');
1446INSERT INTO tblemailtemplates VALUES('47', 'admin', 'Support Ticket Response', '[Ticket ID: {$ticket_tid}] New Support Ticket Response', '<p>A new support ticket response has been made.</p>\r\n<p>Client: {$client_name}{if $client_id} #{$client_id}{/if} <br />Department: {$ticket_department} <br />Subject: {$ticket_subject} <br />Priority: {$ticket_priority}</p>\r\n<p>--- <br />{$ticket_message} <br />---</p>\r\n<p>You can respond to this ticket by simply replying to this email or through the admin area at the url below.</p>\r\n<p><a href=\"{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}\">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '', '', '', '', '', '', '', '0');
1447INSERT INTO tblemailtemplates VALUES('48', 'admin', 'Escalation Rule Notification', '[Ticket ID: {$tickettid}] Escalation Rule Notification', '<p>The escalation rule {$rule_name} has just been applied to this ticket.</p><p>Client: {$client_name}{if $client_id} #{$client_id}{/if} <br />Department: {$ticket_department} <br />Subject: {$ticket_subject} <br />Priority: {$ticket_priority}</p><p>---<br />{$ticket_message}<br />---</p><p>You can respond to this ticket by simply replying to this email or through the admin area at the url below.</p><p><a href=\"{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}\">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '', '', '', '', '', '', '', '0');
1448INSERT INTO tblemailtemplates VALUES('49', 'admin', 'Support Ticket Department Reassigned', '[Ticket ID: {$ticket_tid}] Support Ticket Department Reassigned', '<p>The department this ticket is assigned to has been changed to a department you are a member of.</p><p>Client: {$client_name}{if $client_id} #{$client_id}{/if}<br />Department: {$ticket_department}<br />Subject: {$ticket_subject}<br />Priority: {$ticket_priority}</p><p>---<br />{$ticket_message}<br />---</p><p>You can respond to this ticket by simply replying to this email or through the admin area at the url below.</p><p><a href=\"{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}\">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '', '', '', '', '', '', '', '0');
1449INSERT INTO tblemailtemplates VALUES('50', 'invoice', 'Invoice Refund Confirmation', 'Invoice Refund Confirmation', '<p>Dear {$client_name},</p>\r\n<p>This is confirmation that a {if $invoice_status eq \"Refunded\"}full{else}partial{/if} refund has been processed for Invoice #{$invoice_num}</p>\r\n<p>The refund has been {if $invoice_refund_type eq \"credit\"}credited to your account balance with us{else}returned via the payment method you originally paid with{/if}.</p>\r\n<p>{$invoice_html_contents}</p>\r\n<p>Amount Refunded: {$invoice_last_payment_amount}{if $invoice_last_payment_transid}<br />Transaction #: {$invoice_last_payment_transid}{/if}</p>\r\n<p>You may review your invoice history at any time by logging in to your client area.</p>\r\n<p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1450INSERT INTO tblemailtemplates VALUES('51', 'admin', 'New Cancellation Request', 'New Cancellation Request', '<p>A new cancellation request has been submitted.</p><p>Client ID: {$client_id}<br>Client Name: {$clientname}<br>Service ID: {$service_id}<br>Product Name: {$product_name}<br>Cancellation Type: {$service_cancellation_type}<br>Cancellation Reason: {$service_cancellation_reason}</p><p>{$whmcs_admin_link}</p>', '', '', '', '', '', '', '', '0');
1451INSERT INTO tblemailtemplates VALUES('52', 'admin', 'Support Ticket Flagged', 'New Support Ticket Flagged to You', '<p>A new support ticket has been flagged to you.</p><p>Ticket #: {$ticket_tid}<br>Client Name: {$client_name} (ID {$client_id})<br>Department: {$ticket_department}<br>Subject: {$ticket_subject}<br>Priority: {$ticket_priority}</p><p>----------------------<br />{$ticket_message}<br />----------------------</p><p><a href=\"{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}\">{$whmcs_admin_url}supporttickets.php?action=viewticket&id={$ticket_id}</a></p>', '', '', '', '', '', '', '', '0');
1452INSERT INTO tblemailtemplates VALUES('53', 'domain', 'Domain Transfer Failed', 'Domain Transfer Failed: {$domain_name}', '<p>Dear {$client_name},</p><p>Recently you placed a domain transfer order with us but unfortunately it has failed. The reason for the failure if available is shown below so once this has been resolved, please contact us to re-attempt the transfer.</p><p>Domain: {$domain_name}<br>Failure Reason: {$domain_transfer_failure_reason}</p><p>If you have any questions, please open a support ticket from our client area @ {$whmcs_link}</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1453INSERT INTO tblemailtemplates VALUES('54', 'general', 'Quote Accepted', 'Quote #{$quote_number} Accepted - {$quote_subject}', '<p>\r\nDear {$client_name}, \r\n</p>\r\n<p>\r\nThis is a confirmation that quote generated on {$quote_date_created} has been accepted by you and invoice # {$invoice_num} is generated.\r\n<p>\r\n{$signature} \r\n</p>', '', '', '', '', '', '', '', '0');
1454INSERT INTO tblemailtemplates VALUES('55', 'general', 'Quote Accepted Notification', 'Quote #{$quote_number} Accepted - {$quote_subject}', '<p>A quote has been accepted by the following customer.</p><p><strong>Customer Information</strong></p>\r\n<p>Customer ID: {$client_id}<br />\r\nName: {$clientname}<br />\r\nEmail: {$client_email}<br />\r\nCompany: {$client_company_name}<br />\r\nAddress 1: {$client_address1}<br />\r\nAddress 2: {$client_address2}<br />\r\nCity: {$client_city}<br />\r\nState: {$client_state}<br />\r\nPostcode: {$client_postcode}<br />\r\nCountry: {$client_country}<br />\r\nPhone Number: {$client_phonenumber}</p>\r\n<p><strong>Quote Information</strong></p>\r\n<p>Quote #: {$quote_number}<br />\r\nQuote Subject: {$quote_subject}</p><p><a href=\"{$whmcs_admin_url}quotes.php?action=manage&id={$quote_number}\">{$whmcs_admin_url}quotes.php?action=manage&id={$quote_number}</a></p>', '', '', '', '', '', '', '', '0');
1455INSERT INTO tblemailtemplates VALUES('56', 'general', 'Password Reset Confirmation', 'Your password has been reset for {$company_name}', '<p>Dear {$client_name},</p><p>As you requested, your password for our client area has now been reset. </p><p>If it was not at your request, then please contact support immediately.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1456INSERT INTO tblemailtemplates VALUES('57', 'support', 'Support Ticket Feedback Request', 'Your Feedback is Requested for Ticket #{$ticket_id}', '<p>This support request has been marked as completed.</p><p>We would really appreciate it if you would just take a moment to let us know about the quality of your experience.</p><p><a href=\"{$ticket_url}&feedback=1\">{$ticket_url}&feedback=1</a></p><p>Your feedback is very important to us.</p><p>Thank you for your business.</p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1457INSERT INTO tblemailtemplates VALUES('58', 'support', 'Replies Only Bounce Message', 'Online Submission Required', '<p>{$client_name},</p><p>Your email to our support system could not be accepted because we require you to submit all tickets via our online client support portal. You can do this at the URL below.</p><p><a href=\"{$whmcs_url}/submitticket.php\">{$whmcs_url}/submitticket.php</a></p><p>{$signature}</p>', '', '', '', '', '', '', '', '0');
1458INSERT INTO tblemailtemplates VALUES('59', 'general', 'Unsubscribe Confirmation', 'Unsubscribe Confirmation', 'Dear {$client_name},<br /><br />We have now removed your email address from our mailing list.<br /><br />If this was a mistake or you change your mind, you can re-subscribe at any time from the My Details section of our client area.<br /><br /><a href=\"{$whmcs_url}/clientarea.php?action=details\">{$whmcs_url}/clientarea.php?action=details</a><br /><br />{$signature}', '', '', '', '', '', '', '', '0');
1459
1460
1461
1462
1463
1464
1465### tblemailtemplates TABLE DUMP COMPLETED ###
1466
1467
1468DROP TABLE IF EXISTS tblfraud;
1469CREATE TABLE `tblfraud` (
1470  `id` int(10) NOT NULL AUTO_INCREMENT,
1471  `fraud` text NOT NULL,
1472  `setting` text NOT NULL,
1473  `value` text NOT NULL,
1474  PRIMARY KEY (`id`),
1475  KEY `fraud` (`fraud`(32))
1476) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1477
1478
1479
1480
1481
1482
1483
1484### tblfraud TABLE DUMP COMPLETED ###
1485
1486
1487DROP TABLE IF EXISTS tblgatewaylog;
1488CREATE TABLE `tblgatewaylog` (
1489  `id` int(10) NOT NULL AUTO_INCREMENT,
1490  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1491  `gateway` text NOT NULL,
1492  `data` text NOT NULL,
1493  `result` text NOT NULL,
1494  PRIMARY KEY (`id`)
1495) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1496
1497
1498
1499
1500
1501
1502
1503### tblgatewaylog TABLE DUMP COMPLETED ###
1504
1505
1506DROP TABLE IF EXISTS tblhosting;
1507CREATE TABLE `tblhosting` (
1508  `id` int(10) NOT NULL AUTO_INCREMENT,
1509  `userid` int(10) NOT NULL,
1510  `orderid` int(10) NOT NULL,
1511  `packageid` int(10) NOT NULL,
1512  `server` int(10) NOT NULL,
1513  `regdate` date NOT NULL,
1514  `domain` text NOT NULL,
1515  `paymentmethod` text NOT NULL,
1516  `firstpaymentamount` decimal(10,2) NOT NULL DEFAULT '0.00',
1517  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
1518  `billingcycle` text NOT NULL,
1519  `nextduedate` date DEFAULT NULL,
1520  `nextinvoicedate` date NOT NULL,
1521  `domainstatus` enum('Pending','Active','Suspended','Terminated','Cancelled','Fraud') NOT NULL,
1522  `username` text NOT NULL,
1523  `password` text NOT NULL,
1524  `notes` text NOT NULL,
1525  `subscriptionid` text NOT NULL,
1526  `promoid` int(10) NOT NULL,
1527  `suspendreason` text NOT NULL,
1528  `overideautosuspend` text NOT NULL,
1529  `overidesuspenduntil` date NOT NULL,
1530  `dedicatedip` text NOT NULL,
1531  `assignedips` text NOT NULL,
1532  `ns1` text NOT NULL,
1533  `ns2` text NOT NULL,
1534  `diskusage` int(10) NOT NULL DEFAULT '0',
1535  `disklimit` int(10) NOT NULL DEFAULT '0',
1536  `bwusage` int(10) NOT NULL DEFAULT '0',
1537  `bwlimit` int(10) NOT NULL DEFAULT '0',
1538  `lastupdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1539  PRIMARY KEY (`id`),
1540  KEY `serviceid` (`id`),
1541  KEY `userid` (`userid`),
1542  KEY `orderid` (`orderid`),
1543  KEY `productid` (`packageid`),
1544  KEY `serverid` (`server`),
1545  KEY `domain` (`domain`(64)),
1546  KEY `domainstatus` (`domainstatus`)
1547) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1548
1549
1550
1551
1552
1553
1554
1555### tblhosting TABLE DUMP COMPLETED ###
1556
1557
1558DROP TABLE IF EXISTS tblhostingaddons;
1559CREATE TABLE `tblhostingaddons` (
1560  `id` int(10) NOT NULL AUTO_INCREMENT,
1561  `orderid` int(10) NOT NULL,
1562  `hostingid` int(10) NOT NULL,
1563  `addonid` int(10) NOT NULL,
1564  `name` text NOT NULL,
1565  `setupfee` decimal(10,2) NOT NULL DEFAULT '0.00',
1566  `recurring` decimal(10,2) NOT NULL DEFAULT '0.00',
1567  `billingcycle` text NOT NULL,
1568  `tax` text NOT NULL,
1569  `status` enum('Pending','Active','Suspended','Terminated','Cancelled','Fraud') NOT NULL DEFAULT 'Pending',
1570  `regdate` date NOT NULL DEFAULT '0000-00-00',
1571  `nextduedate` date DEFAULT NULL,
1572  `nextinvoicedate` date NOT NULL,
1573  `paymentmethod` text NOT NULL,
1574  `notes` text NOT NULL,
1575  PRIMARY KEY (`id`),
1576  KEY `orderid` (`orderid`),
1577  KEY `serviceid` (`hostingid`),
1578  KEY `name` (`name`(32)),
1579  KEY `status` (`status`)
1580) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1581
1582
1583
1584
1585
1586
1587
1588### tblhostingaddons TABLE DUMP COMPLETED ###
1589
1590
1591DROP TABLE IF EXISTS tblhostingconfigoptions;
1592CREATE TABLE `tblhostingconfigoptions` (
1593  `id` int(10) NOT NULL AUTO_INCREMENT,
1594  `relid` int(10) NOT NULL,
1595  `configid` int(10) NOT NULL,
1596  `optionid` int(10) NOT NULL,
1597  `qty` int(10) NOT NULL,
1598  PRIMARY KEY (`id`),
1599  KEY `relid_configid` (`relid`,`configid`)
1600) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1601
1602
1603
1604
1605
1606
1607
1608### tblhostingconfigoptions TABLE DUMP COMPLETED ###
1609
1610
1611DROP TABLE IF EXISTS tblinvoiceitems;
1612CREATE TABLE `tblinvoiceitems` (
1613  `id` int(10) NOT NULL AUTO_INCREMENT,
1614  `invoiceid` int(10) NOT NULL DEFAULT '0',
1615  `userid` int(10) NOT NULL,
1616  `type` text NOT NULL,
1617  `relid` int(10) NOT NULL,
1618  `description` text NOT NULL,
1619  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
1620  `taxed` int(1) NOT NULL,
1621  `duedate` date DEFAULT NULL,
1622  `paymentmethod` text NOT NULL,
1623  `notes` text NOT NULL,
1624  PRIMARY KEY (`id`),
1625  KEY `invoiceid` (`invoiceid`)
1626) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1627
1628
1629
1630
1631
1632
1633
1634### tblinvoiceitems TABLE DUMP COMPLETED ###
1635
1636
1637DROP TABLE IF EXISTS tblinvoices;
1638CREATE TABLE `tblinvoices` (
1639  `id` int(10) NOT NULL AUTO_INCREMENT,
1640  `userid` int(10) NOT NULL,
1641  `invoicenum` text NOT NULL,
1642  `date` date DEFAULT NULL,
1643  `duedate` date DEFAULT NULL,
1644  `datepaid` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
1645  `subtotal` decimal(10,2) NOT NULL,
1646  `credit` decimal(10,2) NOT NULL,
1647  `tax` decimal(10,2) NOT NULL,
1648  `tax2` decimal(10,2) NOT NULL,
1649  `total` decimal(10,2) NOT NULL DEFAULT '0.00',
1650  `taxrate` decimal(10,2) NOT NULL,
1651  `taxrate2` decimal(10,2) NOT NULL,
1652  `status` text NOT NULL,
1653  `paymentmethod` text NOT NULL,
1654  `notes` text NOT NULL,
1655  PRIMARY KEY (`id`),
1656  KEY `userid` (`userid`),
1657  KEY `status` (`status`(3))
1658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1659
1660
1661
1662
1663
1664
1665
1666### tblinvoices TABLE DUMP COMPLETED ###
1667
1668
1669DROP TABLE IF EXISTS tblknowledgebase;
1670CREATE TABLE `tblknowledgebase` (
1671  `id` int(10) NOT NULL AUTO_INCREMENT,
1672  `title` text NOT NULL,
1673  `article` text NOT NULL,
1674  `views` int(10) NOT NULL DEFAULT '0',
1675  `useful` int(10) NOT NULL DEFAULT '0',
1676  `votes` int(10) NOT NULL DEFAULT '0',
1677  `private` text NOT NULL,
1678  `order` int(3) NOT NULL,
1679  `parentid` int(10) NOT NULL,
1680  `language` text NOT NULL,
1681  PRIMARY KEY (`id`)
1682) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1683
1684
1685
1686
1687
1688
1689
1690### tblknowledgebase TABLE DUMP COMPLETED ###
1691
1692
1693DROP TABLE IF EXISTS tblknowledgebasecats;
1694CREATE TABLE `tblknowledgebasecats` (
1695  `id` int(10) NOT NULL AUTO_INCREMENT,
1696  `parentid` int(10) NOT NULL DEFAULT '0',
1697  `name` text NOT NULL,
1698  `description` text NOT NULL,
1699  `hidden` text NOT NULL,
1700  `catid` int(10) NOT NULL,
1701  `language` text NOT NULL,
1702  PRIMARY KEY (`id`),
1703  KEY `parentid` (`parentid`),
1704  KEY `name` (`name`(64))
1705) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1706
1707
1708
1709
1710
1711
1712
1713### tblknowledgebasecats TABLE DUMP COMPLETED ###
1714
1715
1716DROP TABLE IF EXISTS tblknowledgebaselinks;
1717CREATE TABLE `tblknowledgebaselinks` (
1718  `categoryid` int(10) NOT NULL,
1719  `articleid` int(10) NOT NULL
1720) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1721
1722
1723
1724
1725
1726
1727
1728### tblknowledgebaselinks TABLE DUMP COMPLETED ###
1729
1730
1731DROP TABLE IF EXISTS tbllinks;
1732CREATE TABLE `tbllinks` (
1733  `id` int(10) NOT NULL AUTO_INCREMENT,
1734  `name` text NOT NULL,
1735  `link` text NOT NULL,
1736  `clicks` int(10) NOT NULL,
1737  `conversions` int(10) NOT NULL,
1738  PRIMARY KEY (`id`),
1739  KEY `name` (`name`(64))
1740) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1741
1742
1743
1744
1745
1746
1747
1748### tbllinks TABLE DUMP COMPLETED ###
1749
1750
1751DROP TABLE IF EXISTS tblmodulelog;
1752CREATE TABLE `tblmodulelog` (
1753  `id` int(10) NOT NULL AUTO_INCREMENT,
1754  `date` datetime NOT NULL,
1755  `module` text NOT NULL,
1756  `action` text NOT NULL,
1757  `request` text NOT NULL,
1758  `response` text NOT NULL,
1759  `arrdata` text NOT NULL,
1760  PRIMARY KEY (`id`)
1761) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1762
1763
1764
1765
1766
1767
1768
1769### tblmodulelog TABLE DUMP COMPLETED ###
1770
1771
1772DROP TABLE IF EXISTS tblnetworkissues;
1773CREATE TABLE `tblnetworkissues` (
1774  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1775  `title` varchar(45) NOT NULL,
1776  `description` text NOT NULL,
1777  `type` enum('Server','System','Other') NOT NULL,
1778  `affecting` varchar(100) DEFAULT NULL,
1779  `server` int(10) unsigned DEFAULT NULL,
1780  `priority` enum('Critical','Low','Medium','High') NOT NULL,
1781  `startdate` datetime NOT NULL,
1782  `enddate` datetime DEFAULT NULL,
1783  `status` enum('Reported','Investigating','In Progress','Outage','Scheduled','Resolved') NOT NULL,
1784  `lastupdate` datetime NOT NULL,
1785  PRIMARY KEY (`id`)
1786) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1787
1788
1789
1790
1791
1792
1793
1794### tblnetworkissues TABLE DUMP COMPLETED ###
1795
1796
1797DROP TABLE IF EXISTS tblnotes;
1798CREATE TABLE `tblnotes` (
1799  `id` int(10) NOT NULL AUTO_INCREMENT,
1800  `userid` int(10) NOT NULL,
1801  `adminid` int(10) NOT NULL DEFAULT '0',
1802  `created` datetime NOT NULL,
1803  `modified` datetime NOT NULL,
1804  `note` text NOT NULL,
1805  `sticky` int(1) NOT NULL,
1806  PRIMARY KEY (`id`),
1807  KEY `userid` (`userid`)
1808) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1809
1810
1811
1812
1813
1814
1815
1816### tblnotes TABLE DUMP COMPLETED ###
1817
1818
1819DROP TABLE IF EXISTS tblorders;
1820CREATE TABLE `tblorders` (
1821  `id` int(10) NOT NULL AUTO_INCREMENT,
1822  `ordernum` bigint(10) NOT NULL,
1823  `userid` int(10) NOT NULL,
1824  `contactid` int(10) NOT NULL,
1825  `date` datetime NOT NULL,
1826  `nameservers` text NOT NULL,
1827  `transfersecret` text NOT NULL,
1828  `renewals` text NOT NULL,
1829  `promocode` text NOT NULL,
1830  `promotype` text NOT NULL,
1831  `promovalue` text NOT NULL,
1832  `orderdata` text NOT NULL,
1833  `amount` decimal(10,2) NOT NULL,
1834  `paymentmethod` text NOT NULL,
1835  `invoiceid` int(10) NOT NULL DEFAULT '0',
1836  `status` text NOT NULL,
1837  `ipaddress` text NOT NULL,
1838  `fraudmodule` text NOT NULL,
1839  `fraudoutput` text NOT NULL,
1840  `notes` text NOT NULL,
1841  PRIMARY KEY (`id`),
1842  KEY `ordernum` (`ordernum`),
1843  KEY `userid` (`userid`),
1844  KEY `contactid` (`contactid`),
1845  KEY `date` (`date`)
1846) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1847
1848
1849
1850
1851
1852
1853
1854### tblorders TABLE DUMP COMPLETED ###
1855
1856
1857DROP TABLE IF EXISTS tblorderstatuses;
1858CREATE TABLE `tblorderstatuses` (
1859  `id` int(10) NOT NULL AUTO_INCREMENT,
1860  `title` text NOT NULL,
1861  `color` text NOT NULL,
1862  `showpending` int(1) NOT NULL,
1863  `showactive` int(1) NOT NULL,
1864  `showcancelled` int(1) NOT NULL,
1865  `sortorder` int(2) NOT NULL,
1866  PRIMARY KEY (`id`)
1867) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
1868
1869INSERT INTO tblorderstatuses VALUES('1', 'Pending', '#cc0000', '1', '0', '0', '10');
1870INSERT INTO tblorderstatuses VALUES('2', 'Active', '#779500', '0', '1', '0', '20');
1871INSERT INTO tblorderstatuses VALUES('3', 'Cancelled', '#888888', '0', '0', '1', '30');
1872INSERT INTO tblorderstatuses VALUES('4', 'Fraud', '#000000', '0', '0', '0', '40');
1873
1874
1875
1876
1877
1878
1879### tblorderstatuses TABLE DUMP COMPLETED ###
1880
1881
1882DROP TABLE IF EXISTS tblpaymentgateways;
1883CREATE TABLE `tblpaymentgateways` (
1884  `gateway` text NOT NULL,
1885  `setting` text NOT NULL,
1886  `value` text NOT NULL,
1887  `order` int(1) NOT NULL,
1888  KEY `gateway_setting` (`gateway`(32),`setting`(32)),
1889  KEY `setting_value` (`setting`(32),`value`(32))
1890) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1891
1892INSERT INTO tblpaymentgateways VALUES('paypal', 'forcesubscriptions', '', '0');
1893INSERT INTO tblpaymentgateways VALUES('paypal', 'forceonetime', '', '0');
1894
1895
1896
1897
1898
1899
1900### tblpaymentgateways TABLE DUMP COMPLETED ###
1901
1902
1903DROP TABLE IF EXISTS tblpricing;
1904CREATE TABLE `tblpricing` (
1905  `id` int(10) NOT NULL AUTO_INCREMENT,
1906  `type` enum('product','addon','configoptions','domainregister','domaintransfer','domainrenew','domainaddons') NOT NULL,
1907  `currency` int(10) NOT NULL,
1908  `relid` int(10) NOT NULL,
1909  `msetupfee` decimal(10,2) NOT NULL,
1910  `qsetupfee` decimal(10,2) NOT NULL,
1911  `ssetupfee` decimal(10,2) NOT NULL,
1912  `asetupfee` decimal(10,2) NOT NULL,
1913  `bsetupfee` decimal(10,2) NOT NULL,
1914  `tsetupfee` decimal(10,2) NOT NULL,
1915  `monthly` decimal(10,2) NOT NULL,
1916  `quarterly` decimal(10,2) NOT NULL,
1917  `semiannually` decimal(10,2) NOT NULL,
1918  `annually` decimal(10,2) NOT NULL,
1919  `biennially` decimal(10,2) NOT NULL,
1920  `triennially` decimal(10,2) NOT NULL,
1921  PRIMARY KEY (`id`)
1922) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1923
1924
1925
1926
1927
1928
1929
1930### tblpricing TABLE DUMP COMPLETED ###
1931
1932
1933DROP TABLE IF EXISTS tblproductconfiggroups;
1934CREATE TABLE `tblproductconfiggroups` (
1935  `id` int(10) NOT NULL AUTO_INCREMENT,
1936  `name` text CHARACTER SET utf8 NOT NULL,
1937  `description` text CHARACTER SET utf8 NOT NULL,
1938  PRIMARY KEY (`id`)
1939) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1940
1941
1942
1943
1944
1945
1946
1947### tblproductconfiggroups TABLE DUMP COMPLETED ###
1948
1949
1950DROP TABLE IF EXISTS tblproductconfiglinks;
1951CREATE TABLE `tblproductconfiglinks` (
1952  `gid` int(10) NOT NULL,
1953  `pid` int(10) NOT NULL
1954) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1955
1956
1957
1958
1959
1960
1961
1962### tblproductconfiglinks TABLE DUMP COMPLETED ###
1963
1964
1965DROP TABLE IF EXISTS tblproductconfigoptions;
1966CREATE TABLE `tblproductconfigoptions` (
1967  `id` int(10) NOT NULL AUTO_INCREMENT,
1968  `gid` int(10) NOT NULL DEFAULT '0',
1969  `optionname` text NOT NULL,
1970  `optiontype` text NOT NULL,
1971  `qtyminimum` int(10) NOT NULL,
1972  `qtymaximum` int(10) NOT NULL,
1973  `order` int(1) NOT NULL DEFAULT '0',
1974  `hidden` int(1) NOT NULL,
1975  PRIMARY KEY (`id`),
1976  KEY `productid` (`gid`)
1977) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1978
1979
1980
1981
1982
1983
1984
1985### tblproductconfigoptions TABLE DUMP COMPLETED ###
1986
1987
1988DROP TABLE IF EXISTS tblproductconfigoptionssub;
1989CREATE TABLE `tblproductconfigoptionssub` (
1990  `id` int(10) NOT NULL AUTO_INCREMENT,
1991  `configid` int(10) NOT NULL,
1992  `optionname` text NOT NULL,
1993  `sortorder` int(10) NOT NULL DEFAULT '0',
1994  `hidden` int(1) NOT NULL,
1995  PRIMARY KEY (`id`),
1996  KEY `configid` (`configid`)
1997) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1998
1999
2000
2001
2002
2003
2004
2005### tblproductconfigoptionssub TABLE DUMP COMPLETED ###
2006
2007
2008DROP TABLE IF EXISTS tblproductgroups;
2009CREATE TABLE `tblproductgroups` (
2010  `id` int(10) NOT NULL AUTO_INCREMENT,
2011  `name` text NOT NULL,
2012  `orderfrmtpl` text NOT NULL,
2013  `disabledgateways` text NOT NULL,
2014  `hidden` text NOT NULL,
2015  `order` int(1) NOT NULL DEFAULT '0',
2016  PRIMARY KEY (`id`),
2017  KEY `order` (`order`)
2018) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2019
2020
2021
2022
2023
2024
2025
2026### tblproductgroups TABLE DUMP COMPLETED ###
2027
2028
2029DROP TABLE IF EXISTS tblproducts;
2030CREATE TABLE `tblproducts` (
2031  `id` int(10) NOT NULL AUTO_INCREMENT,
2032  `type` text NOT NULL,
2033  `gid` int(10) NOT NULL,
2034  `name` text NOT NULL,
2035  `description` text NOT NULL,
2036  `hidden` text NOT NULL,
2037  `showdomainoptions` text NOT NULL,
2038  `welcomeemail` int(1) NOT NULL DEFAULT '0',
2039  `stockcontrol` text NOT NULL,
2040  `qty` int(1) NOT NULL DEFAULT '0',
2041  `proratabilling` text NOT NULL,
2042  `proratadate` int(2) NOT NULL,
2043  `proratachargenextmonth` int(2) NOT NULL,
2044  `paytype` text NOT NULL,
2045  `allowqty` int(1) NOT NULL,
2046  `subdomain` text NOT NULL,
2047  `autosetup` text NOT NULL,
2048  `servertype` text NOT NULL,
2049  `servergroup` int(10) NOT NULL,
2050  `configoption1` text NOT NULL,
2051  `configoption2` text NOT NULL,
2052  `configoption3` text NOT NULL,
2053  `configoption4` text NOT NULL,
2054  `configoption5` text NOT NULL,
2055  `configoption6` text NOT NULL,
2056  `configoption7` text NOT NULL,
2057  `configoption8` text NOT NULL,
2058  `configoption9` text NOT NULL,
2059  `configoption10` text NOT NULL,
2060  `configoption11` text NOT NULL,
2061  `configoption12` text NOT NULL,
2062  `configoption13` text NOT NULL,
2063  `configoption14` text NOT NULL,
2064  `configoption15` text NOT NULL,
2065  `configoption16` text NOT NULL,
2066  `configoption17` text NOT NULL,
2067  `configoption18` text NOT NULL,
2068  `configoption19` text NOT NULL,
2069  `configoption20` text NOT NULL,
2070  `configoption21` text NOT NULL,
2071  `configoption22` text NOT NULL,
2072  `configoption23` text NOT NULL,
2073  `configoption24` text NOT NULL,
2074  `freedomain` text NOT NULL,
2075  `freedomainpaymentterms` text NOT NULL,
2076  `freedomaintlds` text NOT NULL,
2077  `recurringcycles` int(2) NOT NULL,
2078  `autoterminatedays` int(4) NOT NULL,
2079  `autoterminateemail` text NOT NULL,
2080  `upgradepackages` text NOT NULL,
2081  `configoptionsupgrade` text NOT NULL,
2082  `billingcycleupgrade` text NOT NULL,
2083  `upgradechargefullcycle` int(1) NOT NULL,
2084  `upgradeemail` text NOT NULL,
2085  `overagesenabled` varchar(10) NOT NULL,
2086  `overagesdisklimit` int(10) NOT NULL,
2087  `overagesbwlimit` int(10) NOT NULL,
2088  `overagesdiskprice` decimal(6,4) NOT NULL,
2089  `overagesbwprice` decimal(6,4) NOT NULL,
2090  `tax` int(1) NOT NULL,
2091  `affiliateonetime` text NOT NULL,
2092  `affiliatepaytype` text NOT NULL,
2093  `affiliatepayamount` decimal(10,2) NOT NULL,
2094  `downloads` text NOT NULL,
2095  `order` int(1) NOT NULL,
2096  `retired` int(1) NOT NULL,
2097  PRIMARY KEY (`id`),
2098  KEY `gid` (`gid`),
2099  KEY `name` (`name`(64))
2100) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2101
2102
2103
2104
2105
2106
2107
2108### tblproducts TABLE DUMP COMPLETED ###
2109
2110
2111DROP TABLE IF EXISTS tblpromotions;
2112CREATE TABLE `tblpromotions` (
2113  `id` int(10) NOT NULL AUTO_INCREMENT,
2114  `code` text NOT NULL,
2115  `type` text NOT NULL,
2116  `recurring` int(1) DEFAULT NULL,
2117  `value` decimal(10,2) NOT NULL DEFAULT '0.00',
2118  `cycles` text NOT NULL,
2119  `appliesto` text NOT NULL,
2120  `requires` text NOT NULL,
2121  `requiresexisting` int(1) NOT NULL,
2122  `startdate` date NOT NULL,
2123  `expirationdate` date DEFAULT NULL,
2124  `maxuses` int(10) NOT NULL DEFAULT '0',
2125  `uses` int(10) NOT NULL DEFAULT '0',
2126  `lifetimepromo` int(1) NOT NULL,
2127  `applyonce` int(1) NOT NULL,
2128  `newsignups` int(1) NOT NULL,
2129  `existingclient` int(11) NOT NULL,
2130  `onceperclient` int(11) NOT NULL,
2131  `recurfor` int(3) NOT NULL,
2132  `upgrades` int(1) NOT NULL,
2133  `upgradeconfig` text NOT NULL,
2134  `notes` text NOT NULL,
2135  PRIMARY KEY (`id`),
2136  KEY `code` (`code`(32))
2137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2138
2139
2140
2141
2142
2143
2144
2145### tblpromotions TABLE DUMP COMPLETED ###
2146
2147
2148DROP TABLE IF EXISTS tblquoteitems;
2149CREATE TABLE `tblquoteitems` (
2150  `id` int(10) NOT NULL AUTO_INCREMENT,
2151  `quoteid` int(10) NOT NULL,
2152  `description` text NOT NULL,
2153  `quantity` text NOT NULL,
2154  `unitprice` decimal(10,2) NOT NULL,
2155  `discount` decimal(10,2) NOT NULL,
2156  `taxable` int(1) NOT NULL,
2157  PRIMARY KEY (`id`)
2158) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2159
2160
2161
2162
2163
2164
2165
2166### tblquoteitems TABLE DUMP COMPLETED ###
2167
2168
2169DROP TABLE IF EXISTS tblquotes;
2170CREATE TABLE `tblquotes` (
2171  `id` int(10) NOT NULL AUTO_INCREMENT,
2172  `subject` text NOT NULL,
2173  `stage` enum('Draft','Delivered','On Hold','Accepted','Lost','Dead') NOT NULL,
2174  `validuntil` date NOT NULL,
2175  `userid` int(10) NOT NULL,
2176  `firstname` text NOT NULL,
2177  `lastname` text NOT NULL,
2178  `companyname` text NOT NULL,
2179  `email` text NOT NULL,
2180  `address1` text NOT NULL,
2181  `address2` text NOT NULL,
2182  `city` text NOT NULL,
2183  `state` text NOT NULL,
2184  `postcode` text NOT NULL,
2185  `country` text NOT NULL,
2186  `phonenumber` text NOT NULL,
2187  `currency` int(10) NOT NULL,
2188  `subtotal` decimal(10,2) NOT NULL,
2189  `tax1` decimal(10,2) NOT NULL,
2190  `tax2` decimal(10,2) NOT NULL,
2191  `total` decimal(10,2) NOT NULL,
2192  `proposal` text NOT NULL,
2193  `customernotes` text NOT NULL,
2194  `adminnotes` text NOT NULL,
2195  `datecreated` date NOT NULL,
2196  `lastmodified` date NOT NULL,
2197  `datesent` date NOT NULL,
2198  `dateaccepted` date NOT NULL,
2199  PRIMARY KEY (`id`)
2200) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2201
2202
2203
2204
2205
2206
2207
2208### tblquotes TABLE DUMP COMPLETED ###
2209
2210
2211DROP TABLE IF EXISTS tblregistrars;
2212CREATE TABLE `tblregistrars` (
2213  `id` int(10) NOT NULL AUTO_INCREMENT,
2214  `registrar` text NOT NULL,
2215  `setting` text NOT NULL,
2216  `value` text NOT NULL,
2217  PRIMARY KEY (`id`),
2218  KEY `registrar_setting` (`registrar`(32),`setting`(32))
2219) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2220
2221
2222
2223
2224
2225
2226
2227### tblregistrars TABLE DUMP COMPLETED ###
2228
2229
2230DROP TABLE IF EXISTS tblservergroups;
2231CREATE TABLE `tblservergroups` (
2232  `id` int(10) NOT NULL AUTO_INCREMENT,
2233  `name` text NOT NULL,
2234  `filltype` int(1) NOT NULL,
2235  PRIMARY KEY (`id`)
2236) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2237
2238
2239
2240
2241
2242
2243
2244### tblservergroups TABLE DUMP COMPLETED ###
2245
2246
2247DROP TABLE IF EXISTS tblservergroupsrel;
2248CREATE TABLE `tblservergroupsrel` (
2249  `groupid` int(10) NOT NULL,
2250  `serverid` int(10) NOT NULL
2251) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2252
2253
2254
2255
2256
2257
2258
2259### tblservergroupsrel TABLE DUMP COMPLETED ###
2260
2261
2262DROP TABLE IF EXISTS tblservers;
2263CREATE TABLE `tblservers` (
2264  `id` int(10) NOT NULL AUTO_INCREMENT,
2265  `name` text NOT NULL,
2266  `ipaddress` text NOT NULL,
2267  `assignedips` text NOT NULL,
2268  `hostname` text NOT NULL,
2269  `monthlycost` decimal(10,2) NOT NULL DEFAULT '0.00',
2270  `noc` text NOT NULL,
2271  `statusaddress` text NOT NULL,
2272  `nameserver1` text NOT NULL,
2273  `nameserver1ip` text NOT NULL,
2274  `nameserver2` text NOT NULL,
2275  `nameserver2ip` text NOT NULL,
2276  `nameserver3` text NOT NULL,
2277  `nameserver3ip` text NOT NULL,
2278  `nameserver4` text NOT NULL,
2279  `nameserver4ip` text NOT NULL,
2280  `nameserver5` text NOT NULL,
2281  `nameserver5ip` text NOT NULL,
2282  `maxaccounts` int(10) NOT NULL DEFAULT '0',
2283  `type` text NOT NULL,
2284  `username` text NOT NULL,
2285  `password` text NOT NULL,
2286  `accesshash` text NOT NULL,
2287  `secure` text NOT NULL,
2288  `active` int(1) NOT NULL,
2289  `disabled` int(1) NOT NULL,
2290  PRIMARY KEY (`id`)
2291) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2292
2293
2294
2295
2296
2297
2298
2299### tblservers TABLE DUMP COMPLETED ###
2300
2301
2302DROP TABLE IF EXISTS tblsslorders;
2303CREATE TABLE `tblsslorders` (
2304  `id` int(10) NOT NULL AUTO_INCREMENT,
2305  `userid` int(10) NOT NULL,
2306  `serviceid` int(10) NOT NULL,
2307  `remoteid` text NOT NULL,
2308  `module` text NOT NULL,
2309  `certtype` text NOT NULL,
2310  `configdata` text NOT NULL,
2311  `completiondate` datetime NOT NULL,
2312  `status` text NOT NULL,
2313  PRIMARY KEY (`id`)
2314) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2315
2316
2317
2318
2319
2320
2321
2322### tblsslorders TABLE DUMP COMPLETED ###
2323
2324
2325DROP TABLE IF EXISTS tbltax;
2326CREATE TABLE `tbltax` (
2327  `id` int(10) NOT NULL AUTO_INCREMENT,
2328  `level` int(1) NOT NULL,
2329  `name` text NOT NULL,
2330  `state` text NOT NULL,
2331  `country` text NOT NULL,
2332  `taxrate` decimal(10,2) NOT NULL,
2333  PRIMARY KEY (`id`),
2334  KEY `state_country` (`state`(32),`country`(2))
2335) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2336
2337
2338
2339
2340
2341
2342
2343### tbltax TABLE DUMP COMPLETED ###
2344
2345
2346DROP TABLE IF EXISTS tblticketbreaklines;
2347CREATE TABLE `tblticketbreaklines` (
2348  `id` int(10) NOT NULL AUTO_INCREMENT,
2349  `breakline` text NOT NULL,
2350  PRIMARY KEY (`id`)
2351) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
2352
2353INSERT INTO tblticketbreaklines VALUES('1', '> -----Original Message-----');
2354INSERT INTO tblticketbreaklines VALUES('2', '----- Original Message -----');
2355INSERT INTO tblticketbreaklines VALUES('3', '-----Original Message-----');
2356INSERT INTO tblticketbreaklines VALUES('4', '<!-- Break Line -->');
2357INSERT INTO tblticketbreaklines VALUES('5', '====== Please reply above this line ======');
2358INSERT INTO tblticketbreaklines VALUES('6', '_____');
2359
2360
2361
2362
2363
2364
2365### tblticketbreaklines TABLE DUMP COMPLETED ###
2366
2367
2368DROP TABLE IF EXISTS tblticketdepartments;
2369CREATE TABLE `tblticketdepartments` (
2370  `id` int(10) NOT NULL AUTO_INCREMENT,
2371  `name` text NOT NULL,
2372  `description` text NOT NULL,
2373  `email` text NOT NULL,
2374  `clientsonly` text NOT NULL,
2375  `piperepliesonly` text NOT NULL,
2376  `noautoresponder` text NOT NULL,
2377  `hidden` text NOT NULL,
2378  `order` int(1) NOT NULL,
2379  `host` text NOT NULL,
2380  `port` text NOT NULL,
2381  `login` text NOT NULL,
2382  `password` text NOT NULL,
2383  PRIMARY KEY (`id`),
2384  KEY `name` (`name`(64))
2385) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2386
2387
2388
2389
2390
2391
2392
2393### tblticketdepartments TABLE DUMP COMPLETED ###
2394
2395
2396DROP TABLE IF EXISTS tblticketescalations;
2397CREATE TABLE `tblticketescalations` (
2398  `id` int(10) NOT NULL AUTO_INCREMENT,
2399  `name` text NOT NULL,
2400  `departments` text NOT NULL,
2401  `statuses` text NOT NULL,
2402  `priorities` text NOT NULL,
2403  `timeelapsed` int(5) NOT NULL,
2404  `newdepartment` text NOT NULL,
2405  `newpriority` text NOT NULL,
2406  `newstatus` text NOT NULL,
2407  `flagto` text NOT NULL,
2408  `notify` text NOT NULL,
2409  `addreply` text NOT NULL,
2410  PRIMARY KEY (`id`)
2411) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2412
2413
2414
2415
2416
2417
2418
2419### tblticketescalations TABLE DUMP COMPLETED ###
2420
2421
2422DROP TABLE IF EXISTS tblticketfeedback;
2423CREATE TABLE `tblticketfeedback` (
2424  `id` int(10) NOT NULL AUTO_INCREMENT,
2425  `ticketid` int(10) NOT NULL,
2426  `adminid` int(10) NOT NULL,
2427  `rating` int(2) NOT NULL,
2428  `comments` text NOT NULL,
2429  `datetime` datetime NOT NULL,
2430  `ip` text NOT NULL,
2431  PRIMARY KEY (`id`)
2432) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2433
2434
2435
2436
2437
2438
2439
2440### tblticketfeedback TABLE DUMP COMPLETED ###
2441
2442
2443DROP TABLE IF EXISTS tblticketlog;
2444CREATE TABLE `tblticketlog` (
2445  `id` int(10) NOT NULL AUTO_INCREMENT,
2446  `date` datetime NOT NULL,
2447  `tid` int(10) NOT NULL,
2448  `action` text NOT NULL,
2449  PRIMARY KEY (`id`),
2450  KEY `tid` (`tid`)
2451) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2452
2453
2454
2455
2456
2457
2458
2459### tblticketlog TABLE DUMP COMPLETED ###
2460
2461
2462DROP TABLE IF EXISTS tblticketmaillog;
2463CREATE TABLE `tblticketmaillog` (
2464  `id` int(10) NOT NULL AUTO_INCREMENT,
2465  `date` datetime NOT NULL,
2466  `to` text NOT NULL,
2467  `name` text NOT NULL,
2468  `email` text NOT NULL,
2469  `subject` text NOT NULL,
2470  `message` text NOT NULL,
2471  `status` text NOT NULL,
2472  PRIMARY KEY (`id`)
2473) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2474
2475
2476
2477
2478
2479
2480
2481### tblticketmaillog TABLE DUMP COMPLETED ###
2482
2483
2484DROP TABLE IF EXISTS tblticketnotes;
2485CREATE TABLE `tblticketnotes` (
2486  `id` int(10) NOT NULL AUTO_INCREMENT,
2487  `ticketid` int(10) NOT NULL,
2488  `admin` text NOT NULL,
2489  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2490  `message` text NOT NULL,
2491  PRIMARY KEY (`id`),
2492  KEY `ticketid_date` (`ticketid`,`date`)
2493) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2494
2495
2496
2497
2498
2499
2500
2501### tblticketnotes TABLE DUMP COMPLETED ###
2502
2503
2504DROP TABLE IF EXISTS tblticketpredefinedcats;
2505CREATE TABLE `tblticketpredefinedcats` (
2506  `id` int(10) NOT NULL AUTO_INCREMENT,
2507  `parentid` int(10) NOT NULL DEFAULT '0',
2508  `name` text NOT NULL,
2509  PRIMARY KEY (`id`),
2510  KEY `parentid_name` (`parentid`,`name`(64))
2511) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2512
2513
2514
2515
2516
2517
2518
2519### tblticketpredefinedcats TABLE DUMP COMPLETED ###
2520
2521
2522DROP TABLE IF EXISTS tblticketpredefinedreplies;
2523CREATE TABLE `tblticketpredefinedreplies` (
2524  `id` int(10) NOT NULL AUTO_INCREMENT,
2525  `catid` int(10) NOT NULL,
2526  `name` text NOT NULL,
2527  `reply` text NOT NULL,
2528  PRIMARY KEY (`id`)
2529) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2530
2531
2532
2533
2534
2535
2536
2537### tblticketpredefinedreplies TABLE DUMP COMPLETED ###
2538
2539
2540DROP TABLE IF EXISTS tblticketreplies;
2541CREATE TABLE `tblticketreplies` (
2542  `id` int(10) NOT NULL AUTO_INCREMENT,
2543  `tid` int(10) NOT NULL,
2544  `userid` int(10) NOT NULL,
2545  `contactid` int(10) NOT NULL,
2546  `name` text NOT NULL,
2547  `email` text NOT NULL,
2548  `date` datetime NOT NULL,
2549  `message` text NOT NULL,
2550  `admin` text NOT NULL,
2551  `attachment` text NOT NULL,
2552  `rating` int(5) NOT NULL,
2553  PRIMARY KEY (`id`),
2554  KEY `tid_date` (`tid`,`date`)
2555) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2556
2557
2558
2559
2560
2561
2562
2563### tblticketreplies TABLE DUMP COMPLETED ###
2564
2565
2566DROP TABLE IF EXISTS tbltickets;
2567CREATE TABLE `tbltickets` (
2568  `id` int(10) NOT NULL AUTO_INCREMENT,
2569  `tid` varchar(15) NOT NULL,
2570  `did` int(10) NOT NULL,
2571  `userid` int(10) NOT NULL,
2572  `contactid` int(10) NOT NULL,
2573  `name` text NOT NULL,
2574  `email` text NOT NULL,
2575  `cc` text NOT NULL,
2576  `c` text NOT NULL,
2577  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
2578  `title` text NOT NULL,
2579  `message` text NOT NULL,
2580  `status` text NOT NULL,
2581  `urgency` text NOT NULL,
2582  `admin` text NOT NULL,
2583  `attachment` text NOT NULL,
2584  `lastreply` datetime NOT NULL,
2585  `flag` int(1) NOT NULL,
2586  `clientunread` int(1) NOT NULL,
2587  `adminunread` text NOT NULL,
2588  `replyingadmin` int(1) NOT NULL,
2589  `replyingtime` datetime NOT NULL,
2590  `service` text NOT NULL,
2591  PRIMARY KEY (`id`),
2592  KEY `tid_c` (`tid`,`c`(64)),
2593  KEY `userid` (`userid`),
2594  KEY `status` (`status`(10)),
2595  KEY `date` (`date`)
2596) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2597
2598
2599
2600
2601
2602
2603
2604### tbltickets TABLE DUMP COMPLETED ###
2605
2606
2607DROP TABLE IF EXISTS tblticketspamfilters;
2608CREATE TABLE `tblticketspamfilters` (
2609  `id` int(10) NOT NULL AUTO_INCREMENT,
2610  `type` enum('sender','subject','phrase') NOT NULL,
2611  `content` text NOT NULL,
2612  PRIMARY KEY (`id`),
2613  KEY `type` (`type`)
2614) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2615
2616
2617
2618
2619
2620
2621
2622### tblticketspamfilters TABLE DUMP COMPLETED ###
2623
2624
2625DROP TABLE IF EXISTS tblticketstatuses;
2626CREATE TABLE `tblticketstatuses` (
2627  `id` int(10) NOT NULL AUTO_INCREMENT,
2628  `title` text NOT NULL,
2629  `color` text NOT NULL,
2630  `sortorder` int(2) NOT NULL,
2631  `showactive` int(1) NOT NULL,
2632  `showawaiting` int(1) NOT NULL,
2633  `autoclose` int(1) NOT NULL,
2634  PRIMARY KEY (`id`)
2635) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
2636
2637INSERT INTO tblticketstatuses VALUES('1', 'Open', '#779500', '1', '1', '1', '0');
2638INSERT INTO tblticketstatuses VALUES('2', 'Answered', '#000000', '2', '1', '0', '1');
2639INSERT INTO tblticketstatuses VALUES('3', 'Customer-Reply', '#ff6600', '3', '1', '1', '1');
2640INSERT INTO tblticketstatuses VALUES('4', 'Closed', '#888888', '10', '0', '0', '0');
2641INSERT INTO tblticketstatuses VALUES('5', 'On Hold', '#224488', '5', '1', '0', '0');
2642INSERT INTO tblticketstatuses VALUES('6', 'In Progress', '#cc0000', '6', '1', '0', '0');
2643
2644
2645
2646
2647
2648
2649### tblticketstatuses TABLE DUMP COMPLETED ###
2650
2651
2652DROP TABLE IF EXISTS tbltickettags;
2653CREATE TABLE `tbltickettags` (
2654  `id` int(10) NOT NULL AUTO_INCREMENT,
2655  `ticketid` int(10) NOT NULL,
2656  `tag` text NOT NULL,
2657  PRIMARY KEY (`id`)
2658) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2659
2660
2661
2662
2663
2664
2665
2666### tbltickettags TABLE DUMP COMPLETED ###
2667
2668
2669DROP TABLE IF EXISTS tbltodolist;
2670CREATE TABLE `tbltodolist` (
2671  `id` int(10) NOT NULL AUTO_INCREMENT,
2672  `date` date NOT NULL,
2673  `title` text NOT NULL,
2674  `description` text NOT NULL,
2675  `admin` int(10) NOT NULL DEFAULT '0',
2676  `status` text NOT NULL,
2677  `duedate` date NOT NULL,
2678  PRIMARY KEY (`id`),
2679  KEY `duedate` (`duedate`)
2680) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2681
2682
2683
2684
2685
2686
2687
2688### tbltodolist TABLE DUMP COMPLETED ###
2689
2690
2691DROP TABLE IF EXISTS tbltransientdata;
2692CREATE TABLE `tbltransientdata` (
2693  `id` int(10) NOT NULL AUTO_INCREMENT,
2694  `name` varchar(1024) NOT NULL,
2695  `data` text NOT NULL,
2696  `expires` int(10) NOT NULL,
2697  PRIMARY KEY (`id`),
2698  KEY `name` (`name`(255))
2699) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2700
2701
2702
2703
2704
2705
2706
2707### tbltransientdata TABLE DUMP COMPLETED ###
2708
2709
2710DROP TABLE IF EXISTS tblupgrades;
2711CREATE TABLE `tblupgrades` (
2712  `id` int(10) NOT NULL AUTO_INCREMENT,
2713  `orderid` int(10) NOT NULL,
2714  `type` text NOT NULL,
2715  `date` date NOT NULL,
2716  `relid` int(10) NOT NULL,
2717  `originalvalue` text NOT NULL,
2718  `newvalue` text NOT NULL,
2719  `amount` decimal(10,2) NOT NULL,
2720  `recurringchange` decimal(10,2) NOT NULL,
2721  `status` enum('Pending','Completed') NOT NULL DEFAULT 'Pending',
2722  `paid` enum('Y','N') NOT NULL DEFAULT 'N',
2723  PRIMARY KEY (`id`),
2724  KEY `orderid` (`orderid`),
2725  KEY `serviceid` (`relid`)
2726) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2727
2728
2729
2730
2731
2732
2733
2734### tblupgrades TABLE DUMP COMPLETED ###
2735
2736
2737DROP TABLE IF EXISTS tblwhoislog;
2738CREATE TABLE `tblwhoislog` (
2739  `id` int(10) NOT NULL AUTO_INCREMENT,
2740  `date` datetime NOT NULL,
2741  `domain` text NOT NULL,
2742  `ip` text NOT NULL,
2743  PRIMARY KEY (`id`)
2744) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2745
2746
2747
2748
2749
2750
2751
2752### tblwhoislog TABLE DUMP COMPLETED ###
2753
2754
2755
2756
2757
2758### thunhost_bd DATABASE DUMP COMPLETED ###