· 8 years ago · Aug 04, 2018, 05:16 AM
1--
2-- Table structure for table `jos_comprofiler`
3--
4
5CREATE TABLE IF NOT EXISTS `jos_comprofiler` (
6 `id` int(11) NOT NULL DEFAULT '0',
7 `user_id` int(11) NOT NULL DEFAULT '0',
8 `firstname` varchar(100) DEFAULT NULL,
9 `middlename` varchar(100) DEFAULT NULL,
10 `lastname` varchar(100) DEFAULT NULL,
11 `hits` int(11) NOT NULL DEFAULT '0',
12 `message_last_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
13 `message_number_sent` int(11) NOT NULL DEFAULT '0',
14 `avatar` varchar(255) DEFAULT NULL,
15 `avatarapproved` tinyint(4) NOT NULL DEFAULT '1',
16 `approved` tinyint(4) NOT NULL DEFAULT '1',
17 `confirmed` tinyint(4) NOT NULL DEFAULT '1',
18 `lastupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
19 `registeripaddr` varchar(50) NOT NULL DEFAULT '',
20 `cbactivation` varchar(50) NOT NULL DEFAULT '',
21 `banned` tinyint(4) NOT NULL DEFAULT '0',
22 `banneddate` datetime DEFAULT NULL,
23 `unbanneddate` datetime DEFAULT NULL,
24 `bannedby` int(11) DEFAULT NULL,
25 `unbannedby` int(11) DEFAULT NULL,
26 `bannedreason` mediumtext,
27 `acceptedterms` tinyint(1) NOT NULL DEFAULT '0',
28 `website` varchar(255) DEFAULT NULL,
29 `location` varchar(255) DEFAULT NULL,
30 `occupation` varchar(255) DEFAULT NULL,
31 `interests` varchar(255) DEFAULT NULL,
32 `company` varchar(255) DEFAULT NULL,
33 `address` varchar(255) DEFAULT NULL,
34 `city` varchar(255) DEFAULT NULL,
35 `state` varchar(255) DEFAULT NULL,
36 `zipcode` varchar(255) DEFAULT NULL,
37 `country` varchar(255) DEFAULT NULL,
38 `phone` varchar(255) DEFAULT NULL,
39 `fax` varchar(255) DEFAULT NULL,
40 `cb_subs_inv_first_name` varchar(255) DEFAULT NULL,
41 `cb_subs_inv_last_name` varchar(255) DEFAULT NULL,
42 `cb_subs_inv_payer_business_name` varchar(255) DEFAULT NULL,
43 `cb_subs_inv_address_street` varchar(255) DEFAULT NULL,
44 `cb_subs_inv_address_city` varchar(255) DEFAULT NULL,
45 `cb_subs_inv_address_state` varchar(255) DEFAULT NULL,
46 `cb_subs_inv_address_zip` varchar(255) DEFAULT NULL,
47 `cb_subs_inv_address_country` varchar(255) DEFAULT NULL,
48 `cb_subs_inv_contact_phone` varchar(255) DEFAULT NULL,
49 `cb_subs_inv_vat_number` varchar(255) DEFAULT NULL,
50 `cb_folderaccess` varchar(100) DEFAULT NULL,
51 `cb_howfound` varchar(255) DEFAULT NULL,
52 `cb_deliveryfrequency` varchar(255) DEFAULT NULL,
53 `cb_faxfrequency` varchar(255) DEFAULT NULL,
54 `cb_personid` varchar(255) DEFAULT NULL,
55 `cb_mobilefrequency` varchar(255) DEFAULT NULL,
56 PRIMARY KEY (`id`),
57 UNIQUE KEY `user_id` (`user_id`),
58 KEY `apprconfbanid` (`approved`,`confirmed`,`banned`,`id`),
59 KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`,`approved`,`confirmed`,`banned`,`avatar`),
60 KEY `lastupdatedate` (`lastupdatedate`)
61) ENGINE=MyISAM DEFAULT CHARSET=utf8;