1
2-- Table structure for table `tblaccounts`
3--
4
5CREATE TABLE IF NOT EXISTS `tblaccounts` (
6 `id` int(1) unsigned zerofill NOT NULL auto_increment,
7 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
8 `gateway` text COLLATE utf8_unicode_ci NOT NULL,
9 `date` datetime default NULL,
10 `description` text COLLATE utf8_unicode_ci NOT NULL,
11 `amountin` decimal(10,2) NOT NULL default '0.00',
12 `fees` decimal(10,2) NOT NULL default '0.00',
13 `amountout` decimal(10,2) NOT NULL default '0.00',
14 `transid` text COLLATE utf8_unicode_ci NOT NULL,
15 `invoiceid` int(1) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `tblactivitylog`
23--
24
25CREATE TABLE IF NOT EXISTS `tblactivitylog` (
26 `id` int(1) unsigned zerofill NOT NULL auto_increment,
27 `date` datetime NOT NULL default '0000-00-00 00:00:00',
28 `description` text COLLATE utf8_unicode_ci NOT NULL,
29 `user` text COLLATE utf8_unicode_ci NOT NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table `tbladdons`
37--
38
39CREATE TABLE IF NOT EXISTS `tbladdons` (
40 `id` int(1) unsigned zerofill NOT NULL auto_increment,
41 `packages` text COLLATE utf8_unicode_ci NOT NULL,
42 `name` text COLLATE utf8_unicode_ci NOT NULL,
43 `description` text COLLATE utf8_unicode_ci NOT NULL,
44 `recurring` decimal(10,2) NOT NULL default '0.00',
45 `setupfee` decimal(10,2) NOT NULL default '0.00',
46 `billingcycle` text COLLATE utf8_unicode_ci NOT NULL,
47 `showorder` text COLLATE utf8_unicode_ci NOT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
50
51-- --------------------------------------------------------
52
53--
54-- Table structure for table `tbladminlog`
55--
56
57CREATE TABLE IF NOT EXISTS `tbladminlog` (
58 `id` int(10) unsigned zerofill NOT NULL auto_increment,
59 `adminusername` text COLLATE utf8_unicode_ci NOT NULL,
60 `logintime` datetime NOT NULL default '0000-00-00 00:00:00',
61 `logouttime` datetime NOT NULL default '0000-00-00 00:00:00',
62 `ipaddress` text COLLATE utf8_unicode_ci NOT NULL,
63 `sessionid` text COLLATE utf8_unicode_ci NOT NULL,
64 `lastvisit` datetime NOT NULL default '0000-00-00 00:00:00',
65 PRIMARY KEY (`id`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `tbladmins`
72--
73
74CREATE TABLE IF NOT EXISTS `tbladmins` (
75 `id` int(1) unsigned zerofill NOT NULL auto_increment,
76 `username` text COLLATE utf8_unicode_ci NOT NULL,
77 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
78 `firstname` text COLLATE utf8_unicode_ci NOT NULL,
79 `lastname` text COLLATE utf8_unicode_ci NOT NULL,
80 `email` text COLLATE utf8_unicode_ci NOT NULL,
81 `userlevel` text COLLATE utf8_unicode_ci NOT NULL,
82 `signature` text COLLATE utf8_unicode_ci NOT NULL,
83 `notes` text COLLATE utf8_unicode_ci NOT NULL,
84 `loginattempts` int(1) NOT NULL,
85 `supportdepts` text COLLATE utf8_unicode_ci NOT NULL,
86 `ticketnotifications` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
87 `ordernotifications` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
88 PRIMARY KEY (`id`)
89) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `tblaffiliates`
95--
96
97CREATE TABLE IF NOT EXISTS `tblaffiliates` (
98 `id` int(3) unsigned zerofill NOT NULL auto_increment,
99 `date` date default NULL,
100 `clientid` int(10) unsigned zerofill NOT NULL default '0000000000',
101 `visitors` int(1) NOT NULL,
102 `paytype` text COLLATE utf8_unicode_ci NOT NULL,
103 `payamount` decimal(10,2) NOT NULL,
104 `balance` decimal(10,2) NOT NULL default '0.00',
105 `withdrawn` decimal(10,2) NOT NULL default '0.00',
106 PRIMARY KEY (`id`)
107) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
108
109-- --------------------------------------------------------
110
111--
112-- Table structure for table `tblaffiliatesaccounts`
113--
114
115CREATE TABLE IF NOT EXISTS `tblaffiliatesaccounts` (
116 `id` int(1) unsigned zerofill NOT NULL auto_increment,
117 `affiliateid` text COLLATE utf8_unicode_ci NOT NULL,
118 `domain` text COLLATE utf8_unicode_ci NOT NULL,
119 `package` text COLLATE utf8_unicode_ci NOT NULL,
120 `billingcycle` text COLLATE utf8_unicode_ci NOT NULL,
121 `regdate` date default NULL,
122 `amount` decimal(10,2) NOT NULL default '0.00',
123 `commission` decimal(10,2) NOT NULL,
124 `lastpaid` date NOT NULL default '0000-00-00',
125 `relid` int(10) unsigned zerofill NOT NULL default '0000000000',
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `tblaffiliateshistory`
133--
134
135CREATE TABLE IF NOT EXISTS `tblaffiliateshistory` (
136 `id` int(1) unsigned zerofill NOT NULL auto_increment,
137 `affiliateid` int(3) unsigned zerofill NOT NULL,
138 `date` date NOT NULL,
139 `affaccid` int(1) NOT NULL,
140 `amount` decimal(10,2) NOT NULL,
141 PRIMARY KEY (`id`)
142) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
143
144-- --------------------------------------------------------
145
146--
147-- Table structure for table `tblannouncements`
148--
149
150CREATE TABLE IF NOT EXISTS `tblannouncements` (
151 `id` int(1) unsigned zerofill NOT NULL auto_increment,
152 `date` date default NULL,
153 `title` text COLLATE utf8_unicode_ci NOT NULL,
154 `announcement` text COLLATE utf8_unicode_ci NOT NULL,
155 `published` text COLLATE utf8_unicode_ci NOT NULL,
156 PRIMARY KEY (`id`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
158
159-- --------------------------------------------------------
160
161--
162-- Table structure for table `tblbannedemails`
163--
164
165CREATE TABLE IF NOT EXISTS `tblbannedemails` (
166 `id` int(1) NOT NULL auto_increment,
167 `domain` text COLLATE utf8_unicode_ci NOT NULL,
168 `count` int(1) NOT NULL,
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
171
172-- --------------------------------------------------------
173
174--
175-- Table structure for table `tblbannedips`
176--
177
178CREATE TABLE IF NOT EXISTS `tblbannedips` (
179 `id` int(1) unsigned zerofill NOT NULL auto_increment,
180 `ip` text COLLATE utf8_unicode_ci NOT NULL,
181 `reason` text COLLATE utf8_unicode_ci NOT NULL,
182 `expires` datetime NOT NULL,
183 PRIMARY KEY (`id`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `tblbrowserlinks`
190--
191
192CREATE TABLE IF NOT EXISTS `tblbrowserlinks` (
193 `id` int(1) unsigned zerofill NOT NULL auto_increment,
194 `name` text COLLATE utf8_unicode_ci NOT NULL,
195 `url` text COLLATE utf8_unicode_ci NOT NULL,
196 PRIMARY KEY (`id`)
197) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
198
199-- --------------------------------------------------------
200
201--
202-- Table structure for table `tblcalendar`
203--
204
205CREATE TABLE IF NOT EXISTS `tblcalendar` (
206 `id` int(1) unsigned zerofill NOT NULL auto_increment,
207 `title` text COLLATE utf8_unicode_ci NOT NULL,
208 `desc` text COLLATE utf8_unicode_ci NOT NULL,
209 `day` text COLLATE utf8_unicode_ci NOT NULL,
210 `month` text COLLATE utf8_unicode_ci NOT NULL,
211 `year` text COLLATE utf8_unicode_ci NOT NULL,
212 `startt1` text COLLATE utf8_unicode_ci NOT NULL,
213 `startt2` text COLLATE utf8_unicode_ci NOT NULL,
214 `endt1` text COLLATE utf8_unicode_ci NOT NULL,
215 `endt2` text COLLATE utf8_unicode_ci NOT NULL,
216 `adminid` int(1) NOT NULL,
217 PRIMARY KEY (`id`)
218) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
219
220-- --------------------------------------------------------
221
222--
223-- Table structure for table `tblcancelrequests`
224--
225
226CREATE TABLE IF NOT EXISTS `tblcancelrequests` (
227 `id` int(10) unsigned zerofill NOT NULL auto_increment,
228 `date` datetime NOT NULL default '0000-00-00 00:00:00',
229 `relid` int(10) unsigned zerofill NOT NULL default '0000000000',
230 `reason` text COLLATE utf8_unicode_ci NOT NULL,
231 `type` text COLLATE utf8_unicode_ci NOT NULL,
232 PRIMARY KEY (`id`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
234
235-- --------------------------------------------------------
236
237--
238-- Table structure for table `tblclients`
239--
240
241CREATE TABLE IF NOT EXISTS `tblclients` (
242 `id` int(10) unsigned zerofill NOT NULL auto_increment,
243 `firstname` text COLLATE utf8_unicode_ci NOT NULL,
244 `lastname` text COLLATE utf8_unicode_ci NOT NULL,
245 `companyname` text COLLATE utf8_unicode_ci NOT NULL,
246 `email` text COLLATE utf8_unicode_ci NOT NULL,
247 `address1` text COLLATE utf8_unicode_ci NOT NULL,
248 `address2` text COLLATE utf8_unicode_ci NOT NULL,
249 `city` text COLLATE utf8_unicode_ci NOT NULL,
250 `state` text COLLATE utf8_unicode_ci NOT NULL,
251 `postcode` text COLLATE utf8_unicode_ci NOT NULL,
252 `country` text COLLATE utf8_unicode_ci NOT NULL,
253 `phonenumber` text COLLATE utf8_unicode_ci NOT NULL,
254 `password` text COLLATE utf8_unicode_ci NOT NULL,
255 `credit` decimal(10,2) NOT NULL,
256 `taxexempt` text COLLATE utf8_unicode_ci NOT NULL,
257 `datecreated` date NOT NULL,
258 `notes` text COLLATE utf8_unicode_ci NOT NULL,
259 `cardtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL default '',
260 `cardnum` blob NOT NULL,
261 `startdate` blob NOT NULL,
262 `expdate` blob NOT NULL,
263 `issuenumber` blob NOT NULL,
264 `lastlogin` datetime default NULL,
265 `ip` text COLLATE utf8_unicode_ci NOT NULL,
266 `host` text COLLATE utf8_unicode_ci NOT NULL,
267 `status` text COLLATE utf8_unicode_ci NOT NULL,
268 `language` text COLLATE utf8_unicode_ci NOT NULL,
269 PRIMARY KEY (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
271
272-- --------------------------------------------------------
273
274--
275-- Table structure for table `tblconfiguration`
276--
277
278CREATE TABLE IF NOT EXISTS `tblconfiguration` (
279 `setting` text COLLATE utf8_unicode_ci NOT NULL,
280 `value` text COLLATE utf8_unicode_ci NOT NULL
281) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
282
283-- --------------------------------------------------------
284
285--
286-- Table structure for table `tblcredit`
287--
288
289CREATE TABLE IF NOT EXISTS `tblcredit` (
290 `id` int(10) unsigned zerofill NOT NULL auto_increment,
291 `clientid` int(10) unsigned zerofill NOT NULL,
292 `date` date NOT NULL,
293 `description` text COLLATE utf8_unicode_ci NOT NULL,
294 `amount` decimal(10,2) NOT NULL,
295 PRIMARY KEY (`id`)
296) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
297
298-- --------------------------------------------------------
299
300--
301-- Table structure for table `tblcustomfields`
302--
303
304CREATE TABLE IF NOT EXISTS `tblcustomfields` (
305 `id` int(1) unsigned zerofill NOT NULL auto_increment,
306 `type` text COLLATE utf8_unicode_ci NOT NULL,
307 `relid` int(10) unsigned zerofill NOT NULL default '0000000000',
308 `num` text COLLATE utf8_unicode_ci NOT NULL,
309 `fieldname` text COLLATE utf8_unicode_ci NOT NULL,
310 `fieldtype` text COLLATE utf8_unicode_ci NOT NULL,
311 `fieldoptions` text COLLATE utf8_unicode_ci NOT NULL,
312 `adminonly` text COLLATE utf8_unicode_ci NOT NULL,
313 `required` text COLLATE utf8_unicode_ci NOT NULL,
314 `showorder` text COLLATE utf8_unicode_ci NOT NULL,
315 PRIMARY KEY (`id`)
316) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
317
318-- --------------------------------------------------------
319
320--
321-- Table structure for table `tblcustomfieldsvalues`
322--
323
324CREATE TABLE IF NOT EXISTS `tblcustomfieldsvalues` (
325 `fieldid` int(1) NOT NULL,
326 `relid` int(10) unsigned zerofill NOT NULL,
327 `value` text COLLATE utf8_unicode_ci NOT NULL
328) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
329
330-- --------------------------------------------------------
331
332--
333-- Table structure for table `tbldomainpricing`
334--
335
336CREATE TABLE IF NOT EXISTS `tbldomainpricing` (
337 `id` int(1) unsigned zerofill NOT NULL auto_increment,
338 `extension` text COLLATE utf8_unicode_ci NOT NULL,
339 `registrationperiod` int(1) NOT NULL default '0',
340 `register` decimal(10,2) NOT NULL default '0.00',
341 `transfer` decimal(10,2) NOT NULL,
342 `renew` decimal(10,2) NOT NULL,
343 `autoreg` text COLLATE utf8_unicode_ci NOT NULL,
344 `order` int(1) NOT NULL default '0',
345 PRIMARY KEY (`id`)
346) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
347
348-- --------------------------------------------------------
349
350--
351-- Table structure for table `tbldomains`
352--
353
354CREATE TABLE IF NOT EXISTS `tbldomains` (
355 `id` int(10) unsigned zerofill NOT NULL auto_increment,
356 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
357 `orderid` int(1) NOT NULL,
358 `registrationdate` date NOT NULL,
359 `domain` text COLLATE utf8_unicode_ci NOT NULL,
360 `firstpaymentamount` decimal(10,2) NOT NULL default '0.00',
361 `recurringamount` decimal(10,2) NOT NULL,
362 `registrar` text COLLATE utf8_unicode_ci NOT NULL,
363 `registrationperiod` int(1) NOT NULL default '1',
364 `expirydate` date default NULL,
365 `subscriptionid` text COLLATE utf8_unicode_ci NOT NULL,
366 `status` text COLLATE utf8_unicode_ci NOT NULL,
367 `nextduedate` date NOT NULL default '0000-00-00',
368 `nextinvoicedate` date NOT NULL,
369 `additionalnotes` text COLLATE utf8_unicode_ci NOT NULL,
370 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
371 `urlforwarding` text COLLATE utf8_unicode_ci NOT NULL,
372 `emailforwarding` text COLLATE utf8_unicode_ci NOT NULL,
373 PRIMARY KEY (`id`)
374) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
375
376-- --------------------------------------------------------
377
378--
379-- Table structure for table `tbldomainsadditionalfields`
380--
381
382CREATE TABLE IF NOT EXISTS `tbldomainsadditionalfields` (
383 `id` int(1) NOT NULL auto_increment,
384 `domainid` int(10) unsigned zerofill NOT NULL,
385 `name` text COLLATE utf8_unicode_ci NOT NULL,
386 `value` text COLLATE utf8_unicode_ci NOT NULL,
387 PRIMARY KEY (`id`)
388) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
389
390-- --------------------------------------------------------
391
392--
393-- Table structure for table `tbldownloadcats`
394--
395
396CREATE TABLE IF NOT EXISTS `tbldownloadcats` (
397 `id` int(1) unsigned zerofill NOT NULL auto_increment,
398 `parentid` int(1) NOT NULL default '0',
399 `name` text COLLATE utf8_unicode_ci NOT NULL,
400 `description` text COLLATE utf8_unicode_ci NOT NULL,
401 `hidden` text COLLATE utf8_unicode_ci NOT NULL,
402 PRIMARY KEY (`id`)
403) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
404
405-- --------------------------------------------------------
406
407--
408-- Table structure for table `tbldownloads`
409--
410
411CREATE TABLE IF NOT EXISTS `tbldownloads` (
412 `id` int(1) unsigned zerofill NOT NULL auto_increment,
413 `type` text COLLATE utf8_unicode_ci NOT NULL,
414 `category` text COLLATE utf8_unicode_ci NOT NULL,
415 `title` text COLLATE utf8_unicode_ci NOT NULL,
416 `description` text COLLATE utf8_unicode_ci NOT NULL,
417 `downloads` int(1) NOT NULL default '0',
418 `location` text COLLATE utf8_unicode_ci NOT NULL,
419 `clientsonly` text COLLATE utf8_unicode_ci NOT NULL,
420 PRIMARY KEY (`id`)
421) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
422
423-- --------------------------------------------------------
424
425--
426-- Table structure for table `tblemails`
427--
428
429CREATE TABLE IF NOT EXISTS `tblemails` (
430 `id` int(1) unsigned zerofill NOT NULL auto_increment,
431 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
432 `subject` text COLLATE utf8_unicode_ci NOT NULL,
433 `message` text COLLATE utf8_unicode_ci NOT NULL,
434 `date` datetime default NULL,
435 PRIMARY KEY (`id`)
436) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
437
438-- --------------------------------------------------------
439
440--
441-- Table structure for table `tblemailtemplates`
442--
443
444CREATE TABLE IF NOT EXISTS `tblemailtemplates` (
445 `id` int(1) unsigned zerofill NOT NULL auto_increment,
446 `type` text COLLATE utf8_unicode_ci NOT NULL,
447 `name` text COLLATE utf8_unicode_ci NOT NULL,
448 `subject` text COLLATE utf8_unicode_ci NOT NULL,
449 `message` text COLLATE utf8_unicode_ci NOT NULL,
450 `fromname` text COLLATE utf8_unicode_ci NOT NULL,
451 `fromemail` text COLLATE utf8_unicode_ci NOT NULL,
452 `disabled` text COLLATE utf8_unicode_ci NOT NULL,
453 `custom` text COLLATE utf8_unicode_ci NOT NULL,
454 `language` text COLLATE utf8_unicode_ci NOT NULL,
455 PRIMARY KEY (`id`)
456) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `tblfraud`
462--
463
464CREATE TABLE IF NOT EXISTS `tblfraud` (
465 `id` int(1) unsigned zerofill NOT NULL auto_increment,
466 `fraud` text COLLATE utf8_unicode_ci NOT NULL,
467 `setting` text COLLATE utf8_unicode_ci NOT NULL,
468 `value` text COLLATE utf8_unicode_ci NOT NULL,
469 PRIMARY KEY (`id`)
470) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
471
472-- --------------------------------------------------------
473
474--
475-- Table structure for table `tblgatewaylog`
476--
477
478CREATE TABLE IF NOT EXISTS `tblgatewaylog` (
479 `id` int(10) unsigned zerofill NOT NULL auto_increment,
480 `date` datetime NOT NULL default '0000-00-00 00:00:00',
481 `gateway` text COLLATE utf8_unicode_ci NOT NULL,
482 `data` text COLLATE utf8_unicode_ci NOT NULL,
483 `result` text COLLATE utf8_unicode_ci NOT NULL,
484 PRIMARY KEY (`id`)
485) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
486
487-- --------------------------------------------------------
488
489--
490-- Table structure for table `tblhosting`
491--
492
493CREATE TABLE IF NOT EXISTS `tblhosting` (
494 `id` int(10) unsigned zerofill NOT NULL auto_increment,
495 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
496 `orderid` int(1) NOT NULL,
497 `regdate` date NOT NULL,
498 `domain` text COLLATE utf8_unicode_ci NOT NULL,
499 `server` text COLLATE utf8_unicode_ci NOT NULL,
500 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
501 `firstpaymentamount` decimal(10,2) NOT NULL default '0.00',
502 `amount` decimal(10,2) NOT NULL default '0.00',
503 `billingcycle` text COLLATE utf8_unicode_ci NOT NULL,
504 `nextduedate` date default NULL,
505 `nextinvoicedate` date NOT NULL,
506 `domainstatus` text COLLATE utf8_unicode_ci NOT NULL,
507 `username` text COLLATE utf8_unicode_ci NOT NULL,
508 `password` text COLLATE utf8_unicode_ci NOT NULL,
509 `notes` text COLLATE utf8_unicode_ci NOT NULL,
510 `subscriptionid` text COLLATE utf8_unicode_ci NOT NULL,
511 `packageid` int(10) unsigned zerofill NOT NULL default '0000000000',
512 `overideautosuspend` text COLLATE utf8_unicode_ci NOT NULL,
513 `dedicatedip` text COLLATE utf8_unicode_ci NOT NULL,
514 `assignedips` text COLLATE utf8_unicode_ci NOT NULL,
515 `rootpassword` text COLLATE utf8_unicode_ci NOT NULL,
516 `ns1` text COLLATE utf8_unicode_ci NOT NULL,
517 `ns2` text COLLATE utf8_unicode_ci NOT NULL,
518 `diskusage` int(10) NOT NULL default '0',
519 `disklimit` int(10) NOT NULL default '0',
520 `bwusage` int(10) NOT NULL default '0',
521 `bwlimit` int(10) NOT NULL default '0',
522 `lastupdate` datetime NOT NULL default '0000-00-00 00:00:00',
523 PRIMARY KEY (`id`)
524) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
525
526-- --------------------------------------------------------
527
528--
529-- Table structure for table `tblhostingaddons`
530--
531
532CREATE TABLE IF NOT EXISTS `tblhostingaddons` (
533 `id` int(10) unsigned zerofill NOT NULL auto_increment,
534 `orderid` int(1) NOT NULL,
535 `hostingid` int(10) unsigned zerofill NOT NULL default '0000000000',
536 `name` text COLLATE utf8_unicode_ci NOT NULL,
537 `setupfee` decimal(10,2) NOT NULL default '0.00',
538 `recurring` decimal(10,2) NOT NULL default '0.00',
539 `billingcycle` text COLLATE utf8_unicode_ci NOT NULL,
540 `status` text COLLATE utf8_unicode_ci NOT NULL,
541 `regdate` date NOT NULL default '0000-00-00',
542 `nextduedate` date default NULL,
543 `nextinvoicedate` date NOT NULL,
544 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
545 `subscriptionid` text COLLATE utf8_unicode_ci NOT NULL,
546 PRIMARY KEY (`id`)
547) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
548
549-- --------------------------------------------------------
550
551--
552-- Table structure for table `tblhostingconfigoptions`
553--
554
555CREATE TABLE IF NOT EXISTS `tblhostingconfigoptions` (
556 `id` int(10) unsigned zerofill NOT NULL auto_increment,
557 `relid` int(10) unsigned zerofill NOT NULL default '0000000000',
558 `configid` int(10) unsigned zerofill NOT NULL default '0000000000',
559 `optionid` int(10) unsigned zerofill NOT NULL default '0000000000',
560 PRIMARY KEY (`id`)
561) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
562
563-- --------------------------------------------------------
564
565--
566-- Table structure for table `tblinvoiceitems`
567--
568
569CREATE TABLE IF NOT EXISTS `tblinvoiceitems` (
570 `id` int(1) unsigned zerofill NOT NULL auto_increment,
571 `invoiceid` text COLLATE utf8_unicode_ci NOT NULL,
572 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
573 `type` text COLLATE utf8_unicode_ci NOT NULL,
574 `relid` int(10) unsigned zerofill NOT NULL default '0000000000',
575 `description` text COLLATE utf8_unicode_ci NOT NULL,
576 `amount` decimal(10,2) NOT NULL default '0.00',
577 `taxed` int(1) NOT NULL,
578 `duedate` date default NULL,
579 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
580 `notes` text COLLATE utf8_unicode_ci NOT NULL,
581 PRIMARY KEY (`id`)
582) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
583
584-- --------------------------------------------------------
585
586--
587-- Table structure for table `tblinvoices`
588--
589
590CREATE TABLE IF NOT EXISTS `tblinvoices` (
591 `id` int(1) unsigned zerofill NOT NULL auto_increment,
592 `date` date default NULL,
593 `duedate` date default NULL,
594 `datepaid` datetime NOT NULL default '0000-00-00 00:00:00',
595 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
596 `subtotal` decimal(10,2) NOT NULL,
597 `credit` decimal(10,2) NOT NULL,
598 `tax` decimal(10,2) NOT NULL,
599 `total` decimal(10,2) NOT NULL default '0.00',
600 `taxrate` decimal(10,2) NOT NULL,
601 `status` text COLLATE utf8_unicode_ci NOT NULL,
602 `randomstring` text COLLATE utf8_unicode_ci NOT NULL,
603 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
604 `notes` text COLLATE utf8_unicode_ci NOT NULL,
605 PRIMARY KEY (`id`)
606) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
607
608-- --------------------------------------------------------
609
610--
611-- Table structure for table `tblknowledgebase`
612--
613
614CREATE TABLE IF NOT EXISTS `tblknowledgebase` (
615 `id` int(1) unsigned zerofill NOT NULL auto_increment,
616 `category` text COLLATE utf8_unicode_ci NOT NULL,
617 `title` text COLLATE utf8_unicode_ci NOT NULL,
618 `article` text COLLATE utf8_unicode_ci NOT NULL,
619 `views` int(1) NOT NULL default '0',
620 `useful` int(1) NOT NULL default '0',
621 `votes` int(1) NOT NULL default '0',
622 `private` text COLLATE utf8_unicode_ci NOT NULL,
623 PRIMARY KEY (`id`)
624) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
625
626-- --------------------------------------------------------
627
628--
629-- Table structure for table `tblknowledgebasecats`
630--
631
632CREATE TABLE IF NOT EXISTS `tblknowledgebasecats` (
633 `id` int(1) unsigned zerofill NOT NULL auto_increment,
634 `parentid` int(1) NOT NULL default '0',
635 `name` text COLLATE utf8_unicode_ci NOT NULL,
636 `description` text COLLATE utf8_unicode_ci NOT NULL,
637 `hidden` text COLLATE utf8_unicode_ci NOT NULL,
638 PRIMARY KEY (`id`)
639) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
640
641-- --------------------------------------------------------
642
643--
644-- Table structure for table `tblorders`
645--
646
647CREATE TABLE IF NOT EXISTS `tblorders` (
648 `id` int(1) unsigned zerofill NOT NULL auto_increment,
649 `ordernum` bigint(10) NOT NULL,
650 `userid` int(10) unsigned zerofill NOT NULL,
651 `date` datetime NOT NULL,
652 `hostingid` int(1) NOT NULL,
653 `domainids` text COLLATE utf8_unicode_ci NOT NULL,
654 `addonids` text COLLATE utf8_unicode_ci NOT NULL,
655 `upgradeids` text COLLATE utf8_unicode_ci NOT NULL,
656 `domaintype` text COLLATE utf8_unicode_ci NOT NULL,
657 `nameservers` text COLLATE utf8_unicode_ci NOT NULL,
658 `transfersecret` text COLLATE utf8_unicode_ci NOT NULL,
659 `promocode` text COLLATE utf8_unicode_ci NOT NULL,
660 `promotype` text COLLATE utf8_unicode_ci NOT NULL,
661 `promovalue` text COLLATE utf8_unicode_ci NOT NULL,
662 `amount` decimal(10,2) NOT NULL,
663 `paymentmethod` text COLLATE utf8_unicode_ci NOT NULL,
664 `invoiceid` int(1) NOT NULL,
665 `status` text COLLATE utf8_unicode_ci NOT NULL,
666 `ipaddress` text COLLATE utf8_unicode_ci NOT NULL,
667 `fraudmodule` text COLLATE utf8_unicode_ci NOT NULL,
668 `fraudoutput` text COLLATE utf8_unicode_ci NOT NULL,
669 PRIMARY KEY (`id`)
670) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
671
672-- --------------------------------------------------------
673
674--
675-- Table structure for table `tblpaymentgateways`
676--
677
678CREATE TABLE IF NOT EXISTS `tblpaymentgateways` (
679 `id` int(1) unsigned zerofill NOT NULL auto_increment,
680 `gateway` text COLLATE utf8_unicode_ci NOT NULL,
681 `type` text COLLATE utf8_unicode_ci NOT NULL,
682 `setting` text COLLATE utf8_unicode_ci NOT NULL,
683 `value` text COLLATE utf8_unicode_ci NOT NULL,
684 `name` text COLLATE utf8_unicode_ci NOT NULL,
685 `size` int(1) NOT NULL default '0',
686 `notes` text COLLATE utf8_unicode_ci NOT NULL,
687 `description` text COLLATE utf8_unicode_ci NOT NULL,
688 `order` int(1) NOT NULL,
689 PRIMARY KEY (`id`)
690) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
691
692-- --------------------------------------------------------
693
694--
695-- Table structure for table `tblproductconfigoptions`
696--
697
698CREATE TABLE IF NOT EXISTS `tblproductconfigoptions` (
699 `id` int(10) unsigned zerofill NOT NULL auto_increment,
700 `productid` int(10) unsigned zerofill NOT NULL default '0000000000',
701 `optionname` text COLLATE utf8_unicode_ci NOT NULL,
702 `optiontype` text COLLATE utf8_unicode_ci NOT NULL,
703 `order` int(1) NOT NULL default '0',
704 PRIMARY KEY (`id`)
705) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
706
707-- --------------------------------------------------------
708
709--
710-- Table structure for table `tblproductconfigoptionssub`
711--
712
713CREATE TABLE IF NOT EXISTS `tblproductconfigoptionssub` (
714 `id` int(10) unsigned zerofill NOT NULL auto_increment,
715 `configid` int(10) unsigned zerofill NOT NULL default '0000000000',
716 `optionname` text COLLATE utf8_unicode_ci NOT NULL,
717 `price` decimal(10,2) NOT NULL default '0.00',
718 PRIMARY KEY (`id`)
719) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
720
721-- --------------------------------------------------------
722
723--
724-- Table structure for table `tblproductgroups`
725--
726
727CREATE TABLE IF NOT EXISTS `tblproductgroups` (
728 `id` int(10) unsigned zerofill NOT NULL auto_increment,
729 `name` text COLLATE utf8_unicode_ci NOT NULL,
730 `disabledgateways` text COLLATE utf8_unicode_ci NOT NULL,
731 `hidden` text COLLATE utf8_unicode_ci NOT NULL,
732 `order` int(1) NOT NULL default '0',
733 PRIMARY KEY (`id`)
734) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
735
736-- --------------------------------------------------------
737
738--
739-- Table structure for table `tblproducts`
740--
741
742CREATE TABLE IF NOT EXISTS `tblproducts` (
743 `id` int(10) unsigned zerofill NOT NULL auto_increment,
744 `type` text COLLATE utf8_unicode_ci NOT NULL,
745 `gid` int(10) NOT NULL default '0',
746 `name` text COLLATE utf8_unicode_ci NOT NULL,
747 `description` text COLLATE utf8_unicode_ci NOT NULL,
748 `hidden` text COLLATE utf8_unicode_ci NOT NULL,
749 `showdomainoptions` text COLLATE utf8_unicode_ci NOT NULL,
750 `welcomeemail` int(1) NOT NULL default '0',
751 `stockcontrol` text COLLATE utf8_unicode_ci NOT NULL,
752 `qty` int(1) NOT NULL,
753 `proratabilling` text COLLATE utf8_unicode_ci NOT NULL,
754 `proratadate` int(2) NOT NULL,
755 `proratachargenextmonth` int(2) NOT NULL,
756 `paytype` text COLLATE utf8_unicode_ci NOT NULL,
757 `msetupfee` decimal(10,2) NOT NULL default '0.00',
758 `qsetupfee` decimal(10,2) NOT NULL default '0.00',
759 `ssetupfee` decimal(10,2) NOT NULL default '0.00',
760 `asetupfee` decimal(10,2) NOT NULL default '0.00',
761 `bsetupfee` decimal(10,2) NOT NULL,
762 `monthly` decimal(10,2) NOT NULL default '0.00',
763 `quarterly` decimal(10,2) NOT NULL default '0.00',
764 `semiannual` decimal(10,2) NOT NULL default '0.00',
765 `annual` decimal(10,2) NOT NULL default '0.00',
766 `biennial` decimal(10,2) NOT NULL,
767 `subdomain` text COLLATE utf8_unicode_ci NOT NULL,
768 `autosetup` text COLLATE utf8_unicode_ci NOT NULL,
769 `servertype` text COLLATE utf8_unicode_ci NOT NULL,
770 `defaultserver` int(1) NOT NULL default '0',
771 `configoption1` text COLLATE utf8_unicode_ci NOT NULL,
772 `configoption2` text COLLATE utf8_unicode_ci NOT NULL,
773 `configoption3` text COLLATE utf8_unicode_ci NOT NULL,
774 `configoption4` text COLLATE utf8_unicode_ci NOT NULL,
775 `configoption5` text COLLATE utf8_unicode_ci NOT NULL,
776 `configoption6` text COLLATE utf8_unicode_ci NOT NULL,
777 `configoption7` text COLLATE utf8_unicode_ci NOT NULL,
778 `configoption8` text COLLATE utf8_unicode_ci NOT NULL,
779 `configoption9` text COLLATE utf8_unicode_ci NOT NULL,
780 `configoption10` text COLLATE utf8_unicode_ci NOT NULL,
781 `configoption11` text COLLATE utf8_unicode_ci NOT NULL,
782 `configoption12` text COLLATE utf8_unicode_ci NOT NULL,
783 `configoption13` text COLLATE utf8_unicode_ci NOT NULL,
784 `configoption14` text COLLATE utf8_unicode_ci NOT NULL,
785 `configoption15` text COLLATE utf8_unicode_ci NOT NULL,
786 `configoption16` text COLLATE utf8_unicode_ci NOT NULL,
787 `configoption17` text COLLATE utf8_unicode_ci NOT NULL,
788 `configoption18` text COLLATE utf8_unicode_ci NOT NULL,
789 `configoption19` text COLLATE utf8_unicode_ci NOT NULL,
790 `configoption20` text COLLATE utf8_unicode_ci NOT NULL,
791 `configoption21` text COLLATE utf8_unicode_ci NOT NULL,
792 `configoption22` text COLLATE utf8_unicode_ci NOT NULL,
793 `configoption23` text COLLATE utf8_unicode_ci NOT NULL,
794 `configoption24` text COLLATE utf8_unicode_ci NOT NULL,
795 `freedomain` text COLLATE utf8_unicode_ci NOT NULL,
796 `freedomainpaymentterms` text COLLATE utf8_unicode_ci NOT NULL,
797 `freedomaintlds` text COLLATE utf8_unicode_ci NOT NULL,
798 `upgradepackages` text COLLATE utf8_unicode_ci NOT NULL,
799 `configoptionsupgrade` text COLLATE utf8_unicode_ci NOT NULL,
800 `billingcycleupgrade` text COLLATE utf8_unicode_ci NOT NULL,
801 `tax` int(1) NOT NULL,
802 `affiliateonetime` text COLLATE utf8_unicode_ci NOT NULL,
803 `affiliatepaytype` text COLLATE utf8_unicode_ci NOT NULL,
804 `affiliatepayamount` decimal(10,2) NOT NULL,
805 PRIMARY KEY (`id`)
806) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
807
808-- --------------------------------------------------------
809
810--
811-- Table structure for table `tblpromotions`
812--
813
814CREATE TABLE IF NOT EXISTS `tblpromotions` (
815 `id` int(1) unsigned zerofill NOT NULL auto_increment,
816 `item` text COLLATE utf8_unicode_ci NOT NULL,
817 `type` text COLLATE utf8_unicode_ci NOT NULL,
818 `code` text COLLATE utf8_unicode_ci NOT NULL,
819 `discount` text COLLATE utf8_unicode_ci NOT NULL,
820 `value` decimal(10,2) NOT NULL default '0.00',
821 `expirationdate` date default NULL,
822 `packages` text COLLATE utf8_unicode_ci NOT NULL,
823 `addons` text COLLATE utf8_unicode_ci NOT NULL,
824 `maxuses` int(1) NOT NULL default '0',
825 `uses` int(1) NOT NULL default '0',
826 `appliesto` text COLLATE utf8_unicode_ci NOT NULL,
827 PRIMARY KEY (`id`)
828) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
829
830-- --------------------------------------------------------
831
832--
833-- Table structure for table `tblregistrars`
834--
835
836CREATE TABLE IF NOT EXISTS `tblregistrars` (
837 `id` int(1) unsigned zerofill NOT NULL auto_increment,
838 `registrar` text COLLATE utf8_unicode_ci NOT NULL,
839 `setting` text COLLATE utf8_unicode_ci NOT NULL,
840 `value` text COLLATE utf8_unicode_ci NOT NULL,
841 PRIMARY KEY (`id`)
842) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
843
844-- --------------------------------------------------------
845
846--
847-- Table structure for table `tblreselleraccountsetup`
848--
849
850CREATE TABLE IF NOT EXISTS `tblreselleraccountsetup` (
851 `id` int(1) unsigned zerofill NOT NULL auto_increment,
852 `packageid` text COLLATE utf8_unicode_ci NOT NULL,
853 `resnumlimit` text COLLATE utf8_unicode_ci NOT NULL,
854 `resnumlimitamt` text COLLATE utf8_unicode_ci NOT NULL,
855 `rsnumlimitenabled` text COLLATE utf8_unicode_ci NOT NULL,
856 `reslimit` text COLLATE utf8_unicode_ci NOT NULL,
857 `resreslimit` text COLLATE utf8_unicode_ci NOT NULL,
858 `rslimit-disk` text COLLATE utf8_unicode_ci NOT NULL,
859 `rsolimit-disk` text COLLATE utf8_unicode_ci NOT NULL,
860 `rslimit-bw` text COLLATE utf8_unicode_ci NOT NULL,
861 `rsolimit-bw` text COLLATE utf8_unicode_ci NOT NULL,
862 `acl-list-accts` text COLLATE utf8_unicode_ci NOT NULL,
863 `acl-show-bandwidth` text COLLATE utf8_unicode_ci NOT NULL,
864 `acl-create-acct` text COLLATE utf8_unicode_ci NOT NULL,
865 `acl-edit-account` text COLLATE utf8_unicode_ci NOT NULL,
866 `acl-suspend-acct` text COLLATE utf8_unicode_ci NOT NULL,
867 `acl-kill-acct` text COLLATE utf8_unicode_ci NOT NULL,
868 `acl-upgrade-account` text COLLATE utf8_unicode_ci NOT NULL,
869 `acl-limit-bandwidth` text COLLATE utf8_unicode_ci NOT NULL,
870 `acl-edit-mx` text COLLATE utf8_unicode_ci NOT NULL,
871 `acl-frontpage` text COLLATE utf8_unicode_ci NOT NULL,
872 `acl-mod-subdomains` text COLLATE utf8_unicode_ci NOT NULL,
873 `acl-passwd` text COLLATE utf8_unicode_ci NOT NULL,
874 `acl-quota` text COLLATE utf8_unicode_ci NOT NULL,
875 `acl-res-cart` text COLLATE utf8_unicode_ci NOT NULL,
876 `acl-ssl-gencrt` text COLLATE utf8_unicode_ci NOT NULL,
877 `acl-ssl` text COLLATE utf8_unicode_ci NOT NULL,
878 `acl-demo-setup` text COLLATE utf8_unicode_ci NOT NULL,
879 `acl-rearrange-accts` text COLLATE utf8_unicode_ci NOT NULL,
880 `acl-clustering` text COLLATE utf8_unicode_ci NOT NULL,
881 `acl-create-dns` text COLLATE utf8_unicode_ci NOT NULL,
882 `acl-edit-dns` text COLLATE utf8_unicode_ci NOT NULL,
883 `acl-park-dns` text COLLATE utf8_unicode_ci NOT NULL,
884 `acl-kill-dns` text COLLATE utf8_unicode_ci NOT NULL,
885 `acl-add-pkg` text COLLATE utf8_unicode_ci NOT NULL,
886 `acl-edit-pkg` text COLLATE utf8_unicode_ci NOT NULL,
887 `acl-add-pkg-shell` text COLLATE utf8_unicode_ci NOT NULL,
888 `acl-allow-unlimited-disk-pkgs` text COLLATE utf8_unicode_ci NOT NULL,
889 `acl-allow-unlimited-pkgs` text COLLATE utf8_unicode_ci NOT NULL,
890 `acl-add-pkg-ip` text COLLATE utf8_unicode_ci NOT NULL,
891 `acl-allow-addoncreate` text COLLATE utf8_unicode_ci NOT NULL,
892 `acl-allow-parkedcreate` text COLLATE utf8_unicode_ci NOT NULL,
893 `acl-onlyselfandglobalpkgs` text COLLATE utf8_unicode_ci NOT NULL,
894 `acl-disallow-shell` text COLLATE utf8_unicode_ci NOT NULL,
895 `acl-all` text COLLATE utf8_unicode_ci NOT NULL,
896 `acl-stats` text COLLATE utf8_unicode_ci NOT NULL,
897 `acl-status` text COLLATE utf8_unicode_ci NOT NULL,
898 `acl-restart` text COLLATE utf8_unicode_ci NOT NULL,
899 `acl-mailcheck` text COLLATE utf8_unicode_ci NOT NULL,
900 `acl-resftp` text COLLATE utf8_unicode_ci NOT NULL,
901 `acl-news` text COLLATE utf8_unicode_ci NOT NULL,
902 PRIMARY KEY (`id`)
903) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
904
905-- --------------------------------------------------------
906
907--
908-- Table structure for table `tblservers`
909--
910
911CREATE TABLE IF NOT EXISTS `tblservers` (
912 `id` int(1) unsigned zerofill NOT NULL auto_increment,
913 `name` text COLLATE utf8_unicode_ci NOT NULL,
914 `ipaddress` text COLLATE utf8_unicode_ci NOT NULL,
915 `monthlycost` decimal(10,2) NOT NULL default '0.00',
916 `noc` text COLLATE utf8_unicode_ci NOT NULL,
917 `statusaddress` text COLLATE utf8_unicode_ci NOT NULL,
918 `primarynameserver` text COLLATE utf8_unicode_ci NOT NULL,
919 `primarynameserverip` text COLLATE utf8_unicode_ci NOT NULL,
920 `secondarynameserver` text COLLATE utf8_unicode_ci NOT NULL,
921 `secondarynameserverip` text COLLATE utf8_unicode_ci NOT NULL,
922 `maxaccounts` int(1) NOT NULL default '0',
923 `type` text COLLATE utf8_unicode_ci NOT NULL,
924 `username` text COLLATE utf8_unicode_ci NOT NULL,
925 `password` text COLLATE utf8_unicode_ci NOT NULL,
926 `secure` text COLLATE utf8_unicode_ci NOT NULL,
927 `active` text COLLATE utf8_unicode_ci NOT NULL,
928 PRIMARY KEY (`id`)
929) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
930
931-- --------------------------------------------------------
932
933--
934-- Table structure for table `tbltax`
935--
936
937CREATE TABLE IF NOT EXISTS `tbltax` (
938 `id` int(1) unsigned zerofill NOT NULL auto_increment,
939 `name` text COLLATE utf8_unicode_ci NOT NULL,
940 `state` text COLLATE utf8_unicode_ci NOT NULL,
941 `country` text COLLATE utf8_unicode_ci NOT NULL,
942 `taxrate` decimal(10,2) NOT NULL,
943 PRIMARY KEY (`id`)
944) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
945
946-- --------------------------------------------------------
947
948--
949-- Table structure for table `tblticketbreaklines`
950--
951
952CREATE TABLE IF NOT EXISTS `tblticketbreaklines` (
953 `id` int(1) unsigned zerofill NOT NULL auto_increment,
954 `breakline` text COLLATE utf8_unicode_ci NOT NULL,
955 PRIMARY KEY (`id`)
956) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
957
958-- --------------------------------------------------------
959
960--
961-- Table structure for table `tblticketdepartments`
962--
963
964CREATE TABLE IF NOT EXISTS `tblticketdepartments` (
965 `id` int(3) unsigned zerofill NOT NULL auto_increment,
966 `name` text COLLATE utf8_unicode_ci NOT NULL,
967 `description` text COLLATE utf8_unicode_ci NOT NULL,
968 `email` text COLLATE utf8_unicode_ci NOT NULL,
969 `hidden` text COLLATE utf8_unicode_ci NOT NULL,
970 `order` int(1) NOT NULL,
971 `host` text COLLATE utf8_unicode_ci NOT NULL,
972 `port` text COLLATE utf8_unicode_ci NOT NULL,
973 `login` text COLLATE utf8_unicode_ci NOT NULL,
974 `password` text COLLATE utf8_unicode_ci NOT NULL,
975 PRIMARY KEY (`id`)
976) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
977
978-- --------------------------------------------------------
979
980--
981-- Table structure for table `tblticketlog`
982--
983
984CREATE TABLE IF NOT EXISTS `tblticketlog` (
985 `id` int(10) unsigned zerofill NOT NULL auto_increment,
986 `date` datetime NOT NULL,
987 `tid` int(10) unsigned zerofill NOT NULL,
988 `action` text COLLATE utf8_unicode_ci NOT NULL,
989 PRIMARY KEY (`id`)
990) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
991
992-- --------------------------------------------------------
993
994--
995-- Table structure for table `tblticketmaillog`
996--
997
998CREATE TABLE IF NOT EXISTS `tblticketmaillog` (
999 `id` int(1) NOT NULL auto_increment,
1000 `date` datetime NOT NULL,
1001 `to` text COLLATE utf8_unicode_ci NOT NULL,
1002 `name` text COLLATE utf8_unicode_ci NOT NULL,
1003 `email` text COLLATE utf8_unicode_ci NOT NULL,
1004 `subject` text COLLATE utf8_unicode_ci NOT NULL,
1005 `message` text COLLATE utf8_unicode_ci NOT NULL,
1006 `status` text COLLATE utf8_unicode_ci NOT NULL,
1007 PRIMARY KEY (`id`)
1008) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1009
1010-- --------------------------------------------------------
1011
1012--
1013-- Table structure for table `tblticketnotes`
1014--
1015
1016CREATE TABLE IF NOT EXISTS `tblticketnotes` (
1017 `id` int(10) unsigned zerofill NOT NULL auto_increment,
1018 `admin` text COLLATE utf8_unicode_ci NOT NULL,
1019 `date` datetime NOT NULL default '0000-00-00 00:00:00',
1020 `message` text COLLATE utf8_unicode_ci NOT NULL,
1021 `ticketid` int(10) unsigned zerofill NOT NULL default '0000000000',
1022 PRIMARY KEY (`id`)
1023) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1024
1025-- --------------------------------------------------------
1026
1027--
1028-- Table structure for table `tblticketpredefinedcats`
1029--
1030
1031CREATE TABLE IF NOT EXISTS `tblticketpredefinedcats` (
1032 `id` int(1) unsigned zerofill NOT NULL auto_increment,
1033 `parentid` int(1) NOT NULL,
1034 `name` text COLLATE utf8_unicode_ci NOT NULL,
1035 PRIMARY KEY (`id`)
1036) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1037
1038-- --------------------------------------------------------
1039
1040--
1041-- Table structure for table `tblticketpredefinedreplies`
1042--
1043
1044CREATE TABLE IF NOT EXISTS `tblticketpredefinedreplies` (
1045 `id` int(1) unsigned zerofill NOT NULL auto_increment,
1046 `catid` text COLLATE utf8_unicode_ci NOT NULL,
1047 `name` text COLLATE utf8_unicode_ci NOT NULL,
1048 `reply` text COLLATE utf8_unicode_ci NOT NULL,
1049 PRIMARY KEY (`id`)
1050) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1051
1052-- --------------------------------------------------------
1053
1054--
1055-- Table structure for table `tblticketreplies`
1056--
1057
1058CREATE TABLE IF NOT EXISTS `tblticketreplies` (
1059 `id` int(10) unsigned zerofill NOT NULL auto_increment,
1060 `tid` int(10) unsigned zerofill NOT NULL,
1061 `userid` int(10) unsigned zerofill NOT NULL,
1062 `name` text COLLATE utf8_unicode_ci NOT NULL,
1063 `email` text COLLATE utf8_unicode_ci NOT NULL,
1064 `date` datetime NOT NULL,
1065 `message` text COLLATE utf8_unicode_ci NOT NULL,
1066 `admin` text COLLATE utf8_unicode_ci NOT NULL,
1067 `attachment` text COLLATE utf8_unicode_ci NOT NULL,
1068 PRIMARY KEY (`id`)
1069) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1070
1071-- --------------------------------------------------------
1072
1073--
1074-- Table structure for table `tbltickets`
1075--
1076
1077CREATE TABLE IF NOT EXISTS `tbltickets` (
1078 `id` int(10) unsigned zerofill NOT NULL auto_increment,
1079 `tid` int(6) NOT NULL default '0',
1080 `did` int(3) unsigned zerofill NOT NULL default '000',
1081 `userid` int(10) unsigned zerofill NOT NULL default '0000000000',
1082 `name` text COLLATE utf8_unicode_ci NOT NULL,
1083 `email` text COLLATE utf8_unicode_ci NOT NULL,
1084 `c` text COLLATE utf8_unicode_ci NOT NULL,
1085 `ipaddress` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
1086 `date` datetime NOT NULL default '0000-00-00 00:00:00',
1087 `title` text COLLATE utf8_unicode_ci NOT NULL,
1088 `message` text COLLATE utf8_unicode_ci NOT NULL,
1089 `status` text COLLATE utf8_unicode_ci NOT NULL,
1090 `urgency` text COLLATE utf8_unicode_ci NOT NULL,
1091 `admin` text COLLATE utf8_unicode_ci NOT NULL,
1092 `attachment` text COLLATE utf8_unicode_ci NOT NULL,
1093 `lastreply` datetime NOT NULL,
1094 `flag` int(1) NOT NULL,
1095 `clientunread` int(1) NOT NULL,
1096 `adminunread` int(1) NOT NULL,
1097 PRIMARY KEY (`id`)
1098) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1099
1100-- --------------------------------------------------------
1101
1102--
1103-- Table structure for table `tblticketspamfilters`
1104--
1105
1106CREATE TABLE IF NOT EXISTS `tblticketspamfilters` (
1107 `id` int(1) NOT NULL auto_increment,
1108 `type` enum('sender','subject','phrase') NOT NULL,
1109 `content` text COLLATE utf8_unicode_ci NOT NULL,
1110 PRIMARY KEY (`id`)
1111) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1112
1113-- --------------------------------------------------------
1114
1115--
1116-- Table structure for table `tbltodolist`
1117--
1118
1119CREATE TABLE IF NOT EXISTS `tbltodolist` (
1120 `id` int(1) NOT NULL auto_increment,
1121 `date` date NOT NULL,
1122 `title` text COLLATE utf8_unicode_ci NOT NULL,
1123 `description` text COLLATE utf8_unicode_ci NOT NULL,
1124 `admin` int(1) NOT NULL,
1125 `status` text COLLATE utf8_unicode_ci NOT NULL,
1126 `duedate` date NOT NULL,
1127 PRIMARY KEY (`id`)
1128) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1129
1130-- --------------------------------------------------------
1131
1132--
1133-- Table structure for table `tblupgrades`
1134--
1135
1136CREATE TABLE IF NOT EXISTS `tblupgrades` (
1137 `id` int(1) NOT NULL auto_increment,
1138 `type` text COLLATE utf8_unicode_ci NOT NULL,
1139 `date` date NOT NULL,
1140 `relid` int(10) NOT NULL,
1141 `originalvalue` text COLLATE utf8_unicode_ci NOT NULL,
1142 `newvalue` text COLLATE utf8_unicode_ci NOT NULL,
1143 `amount` decimal(10,2) NOT NULL,
1144 `recurringchange` decimal(10,2) NOT NULL,
1145 `status` enum('Pending','Completed') NOT NULL default 'Pending',
1146 `paid` enum('Y','N') NOT NULL default 'N',
1147 PRIMARY KEY (`id`)
1148) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1149
1150-- --------------------------------------------------------
1151
1152--
1153-- Table structure for table `tblwhoislog`
1154--
1155
1156CREATE TABLE IF NOT EXISTS `tblwhoislog` (
1157 `id` int(10) unsigned zerofill NOT NULL auto_increment,
1158 `date` datetime NOT NULL,
1159 `domain` text COLLATE utf8_unicode_ci NOT NULL,
1160 `ip` text COLLATE utf8_unicode_ci NOT NULL,
1161 PRIMARY KEY (`id`)
1162) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1163
1164-- --------------------------------------------------------
1165
1166INSERT INTO `tblconfiguration` VALUES ('Language', 'English');
1167INSERT INTO `tblconfiguration` VALUES ('CompanyName', 'Company Name');
1168INSERT INTO `tblconfiguration` VALUES ('Email', 'changeme@example.com');
1169INSERT INTO `tblconfiguration` VALUES ('Domain', 'http://www.yourdomain.com/');
1170INSERT INTO `tblconfiguration` VALUES ('LogoURL', '');
1171INSERT INTO `tblconfiguration` VALUES ('SystemURL', 'http://www.yourdomain.com/whmcs/');
1172INSERT INTO `tblconfiguration` VALUES ('SystemSSLURL', '');
1173INSERT INTO `tblconfiguration` VALUES ('Currency', 'USD');
1174INSERT INTO `tblconfiguration` VALUES ('CurrencySymbol', '$');
1175INSERT INTO `tblconfiguration` VALUES ('AutoSuspension', 'on');
1176INSERT INTO `tblconfiguration` VALUES ('AutoSuspensionDays', '5');
1177INSERT INTO `tblconfiguration` VALUES ('CreateInvoiceDaysBefore', '14');
1178INSERT INTO `tblconfiguration` VALUES ('AffiliateEnabled', '');
1179INSERT INTO `tblconfiguration` VALUES ('AffiliateEarningPercent', '0');
1180INSERT INTO `tblconfiguration` VALUES ('AffiliateBonusDeposit', '0.00');
1181INSERT INTO `tblconfiguration` VALUES ('AffiliatePayout', '0.00');
1182INSERT INTO `tblconfiguration` VALUES ('AffiliateLinks', '');
1183INSERT INTO `tblconfiguration` VALUES ('ActivityLimit', '10000');
1184INSERT INTO `tblconfiguration` VALUES ('DateFormat', 'DD/MM/YYYY');
1185INSERT INTO `tblconfiguration` VALUES ('PreSalesQuestions', 'on');
1186INSERT INTO `tblconfiguration` VALUES ('Template', 'default');
1187INSERT INTO `tblconfiguration` VALUES ('AllowRegister', 'on');
1188INSERT INTO `tblconfiguration` VALUES ('AllowTransfer', 'on');
1189INSERT INTO `tblconfiguration` VALUES ('AllowOwnDomain', 'on');
1190INSERT INTO `tblconfiguration` VALUES ('EnableTOSAccept', '');
1191INSERT INTO `tblconfiguration` VALUES ('TermsOfService', '');
1192INSERT INTO `tblconfiguration` VALUES ('AllowLanguageChange', 'on');
1193INSERT INTO `tblconfiguration` VALUES ('CutUtf8Mb4', 'on');
1194INSERT INTO `tblconfiguration` VALUES ('Version', '');
1195INSERT INTO `tblconfiguration` VALUES ('AllowCustomerChangeInvoiceGateway', 'on');
1196INSERT INTO `tblconfiguration` VALUES ('DefaultNameserver1', 'ns1.example.com');
1197INSERT INTO `tblconfiguration` VALUES ('DefaultNameserver2', 'ns2.example.com');
1198INSERT INTO `tblconfiguration` VALUES ('SendInvoiceReminderDays', '7');
1199INSERT INTO `tblconfiguration` VALUES ('SendReminder', 'on');
1200INSERT INTO `tblconfiguration` VALUES ('NumRecordstoDisplay', '50');
1201INSERT INTO `tblconfiguration` VALUES ('BCCMessages', '');
1202INSERT INTO `tblconfiguration` VALUES ('MailType', 'mail');
1203INSERT INTO `tblconfiguration` VALUES ('SMTPHost', '');
1204INSERT INTO `tblconfiguration` VALUES ('SMTPUsername', '');
1205INSERT INTO `tblconfiguration` VALUES ('SMTPPassword', '');
1206INSERT INTO `tblconfiguration` VALUES ('SMTPPort', '25');
1207INSERT INTO `tblconfiguration` VALUES ('ShowCancellationButton', 'on');
1208INSERT INTO `tblconfiguration` VALUES ('UpdateStatsAuto', 'on');
1209INSERT INTO `tblconfiguration` VALUES ('InvoicePayTo', 'Address goes here...');
1210INSERT INTO `tblconfiguration` VALUES ('SendAffiliateReportMonthly', 'on');
1211INSERT INTO `tblconfiguration` VALUES ('InvalidLoginBanLength', '15');
1212INSERT INTO `tblconfiguration` VALUES ('Signature', 'Signature goes here...');
1213INSERT INTO `tblconfiguration` VALUES ('DomainOnlyOrderEnabled', 'on');
1214INSERT INTO `tblconfiguration` VALUES ('TicketBannedAddresses', '');
1215INSERT INTO `tblconfiguration` VALUES ('SendEmailNotificationonUserDetailsChange', 'on');
1216INSERT INTO `tblconfiguration` VALUES ('TicketAllowedFileTypes', '.jpg,.gif,.jpeg,.png');
1217INSERT INTO `tblconfiguration` VALUES ('CloseInactiveTickets', '0');
1218INSERT INTO `tblconfiguration` VALUES ('InvoiceLateFeeAmount', '10.00');
1219INSERT INTO `tblconfiguration` VALUES ('AutoTermination', '');
1220INSERT INTO `tblconfiguration` VALUES ('AutoTerminationDays', '30');
1221INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminFirstName', '');
1222INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminLastName', '');
1223INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminCompanyName', '');
1224INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminAddress1', '');
1225INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminAddress2', '');
1226INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminCity', '');
1227INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminStateProvince', '');
1228INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminCountry', 'US');
1229INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminPostalCode', '');
1230INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminPhone', '');
1231INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminFax', '');
1232INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminEmailAddress', '');
1233INSERT INTO `tblconfiguration` VALUES ('RegistrarAdminUseClientDetails', 'on');
1234INSERT INTO `tblconfiguration` VALUES ('Charset', 'utf-8');
1235INSERT INTO `tblconfiguration` VALUES ('AutoUnsuspend', 'on');
1236INSERT INTO `tblconfiguration` VALUES ('RunScriptonCheckOut', '');
1237INSERT INTO `tblconfiguration` VALUES ('License', '');
1238INSERT INTO `tblconfiguration` VALUES ('OrderFormTemplate', 'standard_cart');
1239INSERT INTO `tblconfiguration` VALUES ('AllowDomainsTwice', 'on');
1240INSERT INTO `tblconfiguration` VALUES ('AddLateFeeDays', '5');
1241INSERT INTO `tblconfiguration` VALUES ('TaxEnabled', '');
1242INSERT INTO `tblconfiguration` VALUES ('DefaultCountry', 'US');
1243INSERT INTO `tblconfiguration` VALUES ('AllowTicketsRegisteredClientsOnly', '');
1244INSERT INTO `tblconfiguration` VALUES ('AutoRedirectoInvoice', 'gateway');
1245INSERT INTO `tblconfiguration` VALUES ('EnablePDFInvoices', 'on');
1246INSERT INTO `tblconfiguration` VALUES ('DisableCapatcha', 'offloggedin');
1247INSERT INTO `tblconfiguration` VALUES ('SupportTicketOrder', 'ASC');
1248INSERT INTO `tblconfiguration` VALUES ('SendOverdueInvoiceReminders', '1');
1249INSERT INTO `tblconfiguration` VALUES ('TaxType', 'Exclusive');
1250INSERT INTO `tblconfiguration` VALUES ('InvoiceSubscriptionPayments', 'on');
1251INSERT INTO `tblconfiguration` VALUES ('DomainURLForwarding', '5.00');
1252INSERT INTO `tblconfiguration` VALUES ('DomainEmailForwarding', '5.00');
1253INSERT INTO `tblconfiguration` VALUES ('InvoiceIncrement', '1');
1254INSERT INTO `tblconfiguration` VALUES ('ContinuousInvoiceGeneration', '');
1255INSERT INTO `tblconfiguration` VALUES ('AutoCancellationRequests', 'on');
1256INSERT INTO `tblconfiguration` VALUES ('SystemEmailsFromName', 'WHMCompleteSolution');
1257INSERT INTO `tblconfiguration` VALUES ('SystemEmailsFromEmail', 'noreply@yourdomain.com');
1258INSERT INTO `tblconfiguration` VALUES ('AllowClientRegister', 'on');
1259INSERT INTO `tblconfiguration` VALUES ('BulkCheckTLDs', '.com,.net');
1260INSERT INTO `tblconfiguration` VALUES ('OrderDaysGrace', '0');
1261INSERT INTO `tblconfiguration` VALUES ('CreditOnDowngrade', 'on');
1262INSERT INTO `tblconfiguration` VALUES ('TaxDomains', 'on');
1263INSERT INTO `tblconfiguration` VALUES ('TaxLateFee', 'on');
1264INSERT INTO `tblconfiguration` VALUES ('AdminForceSSL', 'on');
1265INSERT INTO `tblconfiguration` VALUES ('MarketingEmailConvert', 'on');
1266
1267INSERT INTO `tblticketbreaklines` VALUES (1, '> -----Original Message-----');
1268INSERT INTO `tblticketbreaklines` VALUES (2, '----- Original Message -----');
1269INSERT INTO `tblticketbreaklines` VALUES (3, '-----Original Message-----');
1270INSERT INTO `tblticketbreaklines` VALUES (4, '<!-- Break Line -->');
1271INSERT INTO `tblticketbreaklines` VALUES (5, '====== Please reply above this line ======');
1272INSERT INTO `tblticketbreaklines` VALUES (6, '_____');
1273UPDATE `tblconfiguration` SET `value` = '3.2.0' WHERE `setting`= 'Version';
1274