DsSck7Uj

1DROP TABLE IF EXISTS `tblclients`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `tblclients` (
5  `id` int(10) NOT NULL AUTO_INCREMENT,
6  `firstname` text NOT NULL,
7  `lastname` text NOT NULL,
8  `companyname` text NOT NULL,
9  `email` text NOT NULL,
10  `address1` text NOT NULL,
11  `address2` text NOT NULL,
12  `city` text NOT NULL,
13  `state` text NOT NULL,
14  `postcode` text NOT NULL,
15  `country` text NOT NULL,
16  `phonenumber` text NOT NULL,
17  `password` text NOT NULL,
18  `authmodule` text NOT NULL,
19  `authdata` text NOT NULL,
20  `currency` int(10) NOT NULL,
21  `defaultgateway` text NOT NULL,
22  `credit` decimal(10,2) NOT NULL,
23  `taxexempt` text NOT NULL,
24  `latefeeoveride` text NOT NULL,
25  `overideduenotices` text NOT NULL,
26  `separateinvoices` text NOT NULL,
27  `disableautocc` text NOT NULL,
28  `datecreated` date NOT NULL,
29  `notes` text NOT NULL,
30  `billingcid` int(10) NOT NULL,
31  `securityqid` int(10) NOT NULL,
32  `securityqans` text NOT NULL,
33  `groupid` int(10) NOT NULL,
34  `cardtype` varchar(255) NOT NULL DEFAULT '',
35  `cardlastfour` text NOT NULL,
36  `cardnum` blob NOT NULL,
37  `startdate` blob NOT NULL,
38  `expdate` blob NOT NULL,
39  `issuenumber` blob NOT NULL,
40  `bankname` text NOT NULL,
41  `banktype` text NOT NULL,
42  `bankcode` blob NOT NULL,
43  `bankacct` blob NOT NULL,
44  `gatewayid` text NOT NULL,
45  `lastlogin` datetime DEFAULT NULL,
46  `ip` text NOT NULL,
47  `host` text NOT NULL,
48  `status` enum('Active','Inactive','Closed') NOT NULL DEFAULT 'Active',
49  `language` text NOT NULL,
50  `pwresetkey` text NOT NULL,
51  `pwresetexpiry` int(10) NOT NULL,
52  `emailoptout` int(1) NOT NULL,
53  `overrideautoclose` int(1) NOT NULL,
54  PRIMARY KEY (`id`),
55  KEY `firstname_lastname` (`firstname`(32),`lastname`(32)),
56  KEY `email` (`email`(64))
57) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8;
58/*!40101 SET character_set_client = @saved_cs_client */;