ALTER TABLE `#__comprofiler` CHANGE `avatarapproved` `avatarapproved` tinyint(4) NOT NULL DEFAULT 1 AFTER `avatar`
ALTER TABLE `#__comprofiler_field_values` ADD KEY `fieldtitle_id` (`fieldtitle`, `fieldid`)
ALTER TABLE `#__comprofiler_fields` ADD `tablecolumns` text NOT NULL AFTER `name`; 
UPDATE `#__comprofiler_fields` SET `tablecolumns` = `name`
ALTER TABLE `#__comprofiler_fields` ADD `displaytitle` tinyint(1) NOT NULL DEFAULT 1 AFTER `profile`
ALTER TABLE `#__comprofiler_fields` ADD `searchable` tinyint(1) NOT NULL DEFAULT 0 AFTER `readonly`
UPDATE `#__comprofiler_fields` SET `pluginid` = 1 WHERE `pluginid` IS NULL; 
ALTER TABLE `#__comprofiler_fields` CHANGE `pluginid` `pluginid` int(11) NOT NULL DEFAULT 0 AFTER `sys`
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'name', `tabid` = 11, `ordering` = -51, `displaytitle` = 1, `searchable` = 1, `pluginid` = 1, `description` = '_UE_REGWARN_NAME', `required` = 1, `registration` = 1, `profile` = 0 WHERE (`fieldid` = 41)
UPDATE `#__comprofiler_fields` SET `name` = 'onlinestatus', `tablecolumns` = '', `tabid` = 21, `ordering` = -21, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1 WHERE (`fieldid` = 26)
INSERT INTO `#__comprofiler_fields` (`fieldid`,`name`,`tablecolumns`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`displaytitle`,`readonly`,`searchable`,`calculated`,`sys`,`pluginid`,`params`) VALUES (25,'hits','hits','#__comprofiler','_UE_HITS','_UE_HITS_DESC','counter',NULL,NULL,0,21,-22,NULL,NULL,NULL,NULL,1,0,1,1,1,0,1,1,1,NULL)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastvisitDate', `type` = 'datetime', `tabid` = 21, `ordering` = -19, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `readonly` = 1, `params` = 'field_display_by=2' WHERE (`fieldid` = 27)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'registerDate', `type` = 'datetime', `tabid` = 21, `ordering` = -20, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `readonly` = 1, `params` = 'field_display_by=2' WHERE (`fieldid` = 28)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'avatar,avatarapproved', `tabid` = 20, `ordering` = 1, `displaytitle` = 0, `searchable` = 0, `pluginid` = 1 WHERE (`fieldid` = 29)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'username', `tabid` = 11, `ordering` = -46, `displaytitle` = 1, `searchable` = 1, `pluginid` = 1, `description` = '_UE_VALID_UNAME', `required` = 1, `registration` = 1, `profile` = 0 WHERE (`fieldid` = 42)
UPDATE `#__comprofiler_fields` SET `name` = 'formatname', `tablecolumns` = '', `tabid` = 11, `ordering` = -52, `displaytitle` = 0, `searchable` = 0, `pluginid` = 1, `readonly` = 1 WHERE (`fieldid` = 45)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'firstname', `tabid` = 11, `ordering` = -50, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `description` = '_UE_REGWARN_FNAME', `required` = 1, `registration` = 1, `profile` = 0 WHERE (`fieldid` = 46)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'middlename', `tabid` = 11, `ordering` = -49, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `description` = '_UE_REGWARN_MNAME', `registration` = 1, `profile` = 0 WHERE (`fieldid` = 47)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastname', `tabid` = 11, `ordering` = -48, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `description` = '_UE_REGWARN_LNAME', `required` = 1, `registration` = 1, `profile` = 0 WHERE (`fieldid` = 48)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastupdatedate', `type` = 'datetime', `tabid` = 21, `ordering` = -18, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `readonly` = 1, `params` = 'field_display_by=2' WHERE (`fieldid` = 49)
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'email', `tabid` = 11, `ordering` = -47, `displaytitle` = 1, `searchable` = 0, `pluginid` = 1, `description` = '_UE_REGWARN_MAIL', `required` = 1, `registration` = 1, `profile` = 0 WHERE (`fieldid` = 50)
UPDATE `#__comprofiler_fields` SET `name` = 'password', `tablecolumns` = 'password', `table` = '#__users', `type` = 'password', `displaytitle` = 1, `searchable` = 0, `calculated` = 1, `sys` = 1, `pluginid` = 1 WHERE (`fieldid` = 51)
UPDATE `#__comprofiler_fields` SET `name` = 'params', `tablecolumns` = 'params', `table` = '#__users', `type` = 'userparams', `displaytitle` = 1, `searchable` = 0, `calculated` = 1, `sys` = 1, `pluginid` = 1 WHERE (`fieldid` = 52)
INSERT INTO `#__comprofiler_fields` (`fieldid`,`name`,`tablecolumns`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`displaytitle`,`readonly`,`searchable`,`calculated`,`sys`,`pluginid`,`params`) VALUES (24,'connections','','#__comprofiler','_UE_CONNECTION','','connections',NULL,NULL,0,21,-17,NULL,NULL,NULL,NULL,1,0,1,1,1,0,1,1,1,NULL)
INSERT INTO `#__comprofiler_fields` (`fieldid`,`name`,`tablecolumns`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`displaytitle`,`readonly`,`searchable`,`calculated`,`sys`,`pluginid`,`params`) VALUES (23,'forumrank','','#__comprofiler','_UE_FORUM_FORUMRANKING','','forumstats',NULL,NULL,0,21,-16,NULL,NULL,NULL,NULL,1,0,1,1,1,0,1,1,4,NULL)
INSERT INTO `#__comprofiler_fields` (`fieldid`,`name`,`tablecolumns`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`displaytitle`,`readonly`,`searchable`,`calculated`,`sys`,`pluginid`,`params`) VALUES (22,'forumposts','','#__comprofiler','_UE_FORUM_TOTALPOSTS','','forumstats',NULL,NULL,0,21,-15,NULL,NULL,NULL,NULL,1,0,1,1,1,0,1,1,4,NULL)
INSERT INTO `#__comprofiler_fields` (`fieldid`,`name`,`tablecolumns`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`displaytitle`,`readonly`,`searchable`,`calculated`,`sys`,`pluginid`,`params`) VALUES (21,'forumkarma','','#__comprofiler','_UE_FORUM_KARMA','','forumstats',NULL,NULL,0,21,-14,NULL,NULL,NULL,NULL,1,0,1,1,1,0,1,1,4,NULL)
ALTER TABLE `#__comprofiler_lists` CHANGE `filterfields` `filterfields` mediumtext AFTER `sortfields`
ALTER TABLE `#__comprofiler_lists` ADD `params` mediumtext AFTER `col4captions`
UPDATE `#__comprofiler_plugin` SET `name` = 'Fireboard Forum' WHERE (`id` = 4)
UPDATE `#__comprofiler_plugin` SET `name` = 'Private Message System' WHERE (`id` = 15)
UPDATE `#__comprofiler_tabs` SET `fields` = 1 WHERE (`tabid` = 20)
UPDATE `#__comprofiler_tabs` SET `fields` = 1 WHERE (`tabid` = 21)
ALTER TABLE `#__comprofiler_views` DROP KEY `profile_id_lastview`, ADD KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`)
CREATE TABLE `#__comprofiler_sessions` ( `username` varchar(50) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT 0, `ui` tinyint(4) NOT NULL DEFAULT 0, `incoming_ip` varchar(39) NOT NULL DEFAULT '', `client_ip` varchar(39) NOT NULL DEFAULT '', `session_id` varchar(33) NOT NULL DEFAULT '', `session_data` mediumtext NOT NULL, `expiry_time` int(14) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`), KEY `expiry_time` (`expiry_time`), KEY `userid` (`userid`) ) ENGINE=MyISAM