Table #__comprofiler Column id structure is up-to-date.
Table #__comprofiler Column user_id structure is up-to-date.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__comprofiler Column hits structure is up-to-date.
Table #__comprofiler Column message_last_sent structure is up-to-date.
Table #__comprofiler Column message_number_sent structure is up-to-date.
Table #__comprofiler Column avatar structure is up-to-date.
Table #__comprofiler Column avatarapproved changed successfully, type: tinyint(4) NOT NULL DEFAULT 1
ALTER TABLE `#__comprofiler` CHANGE `avatarapproved` `avatarapproved` tinyint(4) NOT NULL DEFAULT 1 AFTER `avatar`
Table #__comprofiler Column approved structure is up-to-date.
Table #__comprofiler Column confirmed structure is up-to-date.
Table #__comprofiler Column lastupdatedate structure is up-to-date.
Table #__comprofiler Column registeripaddr structure is up-to-date.
Table #__comprofiler Column cbactivation structure is up-to-date.
Table #__comprofiler Column banned structure is up-to-date.
Table #__comprofiler Column banneddate structure is up-to-date.
Table #__comprofiler Column unbanneddate structure is up-to-date.
Table #__comprofiler Column bannedby structure is up-to-date.
Table #__comprofiler Column unbannedby structure is up-to-date.
Table #__comprofiler Column bannedreason structure is up-to-date.
Table #__comprofiler Column acceptedterms structure is up-to-date.
Table #__comprofiler Index PRIMARY is up-to-date.
Table #__comprofiler Index user_id is up-to-date.
Table #__comprofiler Index apprconfbanid is up-to-date.
Table #__comprofiler Index avatappr_apr_conf_ban_avatar is up-to-date.
Table #__comprofiler Index lastupdatedate is up-to-date.
Table #__comprofiler_field_values Column fieldvalueid structure is up-to-date.
Table #__comprofiler_field_values Column fieldid structure is up-to-date.
Table #__comprofiler_field_values Column fieldtitle structure is up-to-date.
Table #__comprofiler_field_values Column ordering structure is up-to-date.
Table #__comprofiler_field_values Column sys structure is up-to-date.
Table #__comprofiler_field_values Index PRIMARY is up-to-date.
Table #__comprofiler_field_values Index fieldid_ordering is up-to-date.
Table #__comprofiler_field_values Index fieldtitle_id successfully created
ALTER TABLE `#__comprofiler_field_values` ADD KEY `fieldtitle_id` (`fieldtitle`, `fieldid`)
Table #__comprofiler_fields Column fieldid structure is up-to-date.
Table #__comprofiler_fields Column name structure is up-to-date.
Table #__comprofiler_fields Column tablecolumns created successfully, type: text NOT NULL
ALTER TABLE `#__comprofiler_fields` ADD `tablecolumns` text NOT NULL AFTER `name`; UPDATE `#__comprofiler_fields` SET `tablecolumns` = `name`
Table #__comprofiler_fields Column table structure is up-to-date.
Table #__comprofiler_fields Column title changed successfully, type: varchar(255) NOT NULL DEFAULT ''
ALTER TABLE `#__comprofiler_fields` CHANGE `title` `title` varchar(255) NOT NULL DEFAULT '' AFTER `table`
Table #__comprofiler_fields Column description structure is up-to-date.
Table #__comprofiler_fields Column type structure is up-to-date.
Table #__comprofiler_fields Column maxlength structure is up-to-date.
Table #__comprofiler_fields Column size structure is up-to-date.
Table #__comprofiler_fields Column required structure is up-to-date.
Table #__comprofiler_fields Column tabid structure is up-to-date.
Table #__comprofiler_fields Column ordering structure is up-to-date.
Table #__comprofiler_fields Column cols structure is up-to-date.
Table #__comprofiler_fields Column rows structure is up-to-date.
Table #__comprofiler_fields Column value structure is up-to-date.
Table #__comprofiler_fields Column default structure is up-to-date.
Table #__comprofiler_fields Column published structure is up-to-date.
Table #__comprofiler_fields Column registration structure is up-to-date.
Table #__comprofiler_fields Column profile structure is up-to-date.
Table #__comprofiler_fields Column displaytitle created successfully, type: tinyint(1) NOT NULL DEFAULT 1
ALTER TABLE `#__comprofiler_fields` ADD `displaytitle` tinyint(1) NOT NULL DEFAULT 1 AFTER `profile`
Table #__comprofiler_fields Column readonly structure is up-to-date.
Table #__comprofiler_fields Column searchable created successfully, type: tinyint(1) NOT NULL DEFAULT 0
ALTER TABLE `#__comprofiler_fields` ADD `searchable` tinyint(1) NOT NULL DEFAULT 0 AFTER `readonly`
Table #__comprofiler_fields Column calculated structure is up-to-date.
Table #__comprofiler_fields Column sys structure is up-to-date.
Table #__comprofiler_fields Column pluginid changed successfully, type: int(11) NOT NULL DEFAULT 0
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`
Table #__comprofiler_fields Column params structure is up-to-date.
Table #__comprofiler_fields Index PRIMARY is up-to-date.
Table #__comprofiler_fields Index tabid_pub_prof_order is up-to-date.
Table #__comprofiler_fields Index readonly_published_tabid is up-to-date.
Table #__comprofiler_fields Index registration_published_order is up-to-date.
Table #__comprofiler_fields Row (`fieldid` = 41) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'name', `displaytitle` = 1, `searchable` = 1 WHERE (`fieldid` = 41)
Table #__comprofiler_fields Row (`fieldid` = 26) successfully updated
UPDATE `#__comprofiler_fields` SET `name` = 'onlinestatus', `tablecolumns` = '', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 26)
Table #__comprofiler_fields Row fieldid = 25 successfully updated
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)
Table #__comprofiler_fields Row (`fieldid` = 27) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastvisitDate', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 27)
Table #__comprofiler_fields Row (`fieldid` = 28) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'registerDate', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 28)
Table #__comprofiler_fields Row (`fieldid` = 29) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'avatar,avatarapproved', `displaytitle` = 0, `searchable` = 0 WHERE (`fieldid` = 29)
Table #__comprofiler_fields Row (`fieldid` = 42) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'username', `displaytitle` = 1, `searchable` = 1 WHERE (`fieldid` = 42)
Table #__comprofiler_fields Row (`fieldid` = 45) successfully updated
UPDATE `#__comprofiler_fields` SET `name` = 'formatname', `tablecolumns` = '', `displaytitle` = 0, `searchable` = 0 WHERE (`fieldid` = 45)
Table #__comprofiler_fields Row (`fieldid` = 46) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'firstname', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 46)
Table #__comprofiler_fields Row (`fieldid` = 47) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'middlename', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 47)
Table #__comprofiler_fields Row (`fieldid` = 48) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastname', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 48)
Table #__comprofiler_fields Row (`fieldid` = 49) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'lastupdatedate', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 49)
Table #__comprofiler_fields Row (`fieldid` = 50) successfully updated
UPDATE `#__comprofiler_fields` SET `tablecolumns` = 'email', `displaytitle` = 1, `searchable` = 0 WHERE (`fieldid` = 50)
Table #__comprofiler_fields Row fieldid = 51 successfully updated
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 (51,'password','password','#__users','_UE_PASS','_UE_VALID_PASS','password',50,NULL,1,11,-45,NULL,NULL,NULL,NULL,1,1,0,1,0,0,1,1,1,NULL)
Table #__comprofiler_fields Row fieldid = 52 successfully updated
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 (52,'params','params','#__users','_UE_USERPARAMS','','userparams',NULL,NULL,0,11,-30,NULL,NULL,NULL,NULL,1,0,0,1,0,0,1,1,1,NULL)
Table #__comprofiler_fields Row fieldid = 24 successfully updated
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)
Table #__comprofiler_fields Row fieldid = 23 successfully updated
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)
Table #__comprofiler_fields Row fieldid = 22 successfully updated
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)
Table #__comprofiler_fields Row fieldid = 21 successfully updated
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)
Table #__comprofiler_lists Column listid structure is up-to-date.
Table #__comprofiler_lists Column title structure is up-to-date.
Table #__comprofiler_lists Column description structure is up-to-date.
Table #__comprofiler_lists Column published structure is up-to-date.
Table #__comprofiler_lists Column default structure is up-to-date.
Table #__comprofiler_lists Column usergroupids structure is up-to-date.
Table #__comprofiler_lists Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_lists Column sortfields structure is up-to-date.
Table #__comprofiler_lists Column filterfields structure is up-to-date.
Table #__comprofiler_lists Column ordering structure is up-to-date.
Table #__comprofiler_lists Column col1title structure is up-to-date.
Table #__comprofiler_lists Column col1enabled structure is up-to-date.
Table #__comprofiler_lists Column col1fields structure is up-to-date.
Table #__comprofiler_lists Column col2title structure is up-to-date.
Table #__comprofiler_lists Column col2enabled structure is up-to-date.
Table #__comprofiler_lists Column col1captions structure is up-to-date.
Table #__comprofiler_lists Column col2fields structure is up-to-date.
Table #__comprofiler_lists Column col2captions structure is up-to-date.
Table #__comprofiler_lists Column col3title structure is up-to-date.
Table #__comprofiler_lists Column col3enabled structure is up-to-date.
Table #__comprofiler_lists Column col3fields structure is up-to-date.
Table #__comprofiler_lists Column col3captions structure is up-to-date.
Table #__comprofiler_lists Column col4title structure is up-to-date.
Table #__comprofiler_lists Column col4enabled structure is up-to-date.
Table #__comprofiler_lists Column col4fields structure is up-to-date.
Table #__comprofiler_lists Column col4captions structure is up-to-date.
Table #__comprofiler_lists Column params created successfully, type: mediumtext
ALTER TABLE `#__comprofiler_lists` ADD `params` mediumtext AFTER `col4captions`
Table #__comprofiler_lists Index PRIMARY is up-to-date.
Table #__comprofiler_lists Index pub_ordering is up-to-date.
Table #__comprofiler_lists Index default_published is up-to-date.
Table #__comprofiler_members Column referenceid structure is up-to-date.
Table #__comprofiler_members Column memberid structure is up-to-date.
Table #__comprofiler_members Column accepted structure is up-to-date.
Table #__comprofiler_members Column pending structure is up-to-date.
Table #__comprofiler_members Column membersince structure is up-to-date.
Table #__comprofiler_members Column reason structure is up-to-date.
Table #__comprofiler_members Column description structure is up-to-date.
Table #__comprofiler_members Column type structure is up-to-date.
Table #__comprofiler_members Index PRIMARY is up-to-date.
Table #__comprofiler_members Index pamr is up-to-date.
Table #__comprofiler_members Index aprm is up-to-date.
Table #__comprofiler_members Index membrefid is up-to-date.
Table #__comprofiler_plugin Column id structure is up-to-date.
Table #__comprofiler_plugin Column name structure is up-to-date.
Table #__comprofiler_plugin Column element structure is up-to-date.
Table #__comprofiler_plugin Column type structure is up-to-date.
Table #__comprofiler_plugin Column folder structure is up-to-date.
Table #__comprofiler_plugin Column backend_menu structure is up-to-date.
Table #__comprofiler_plugin Column access structure is up-to-date.
Table #__comprofiler_plugin Column ordering structure is up-to-date.
Table #__comprofiler_plugin Column published structure is up-to-date.
Table #__comprofiler_plugin Column iscore structure is up-to-date.
Table #__comprofiler_plugin Column client_id structure is up-to-date.
Table #__comprofiler_plugin Column checked_out structure is up-to-date.
Table #__comprofiler_plugin Column checked_out_time structure is up-to-date.
Table #__comprofiler_plugin Column params structure is up-to-date.
Table #__comprofiler_plugin Index PRIMARY is up-to-date.
Table #__comprofiler_plugin Index idx_folder is up-to-date.
Table #__comprofiler_plugin Index type_pub_order is up-to-date.
Table #__comprofiler_plugin Row (`id` = 4) successfully updated
UPDATE `#__comprofiler_plugin` SET `name` = 'Fireboard Forum' WHERE (`id` = 4)
Table #__comprofiler_plugin Row (`id` = 15) successfully updated
UPDATE `#__comprofiler_plugin` SET `name` = 'Private Message System' WHERE (`id` = 15)
Table #__comprofiler_tabs Column tabid structure is up-to-date.
Table #__comprofiler_tabs Column title structure is up-to-date.
Table #__comprofiler_tabs Column description structure is up-to-date.
Table #__comprofiler_tabs Column ordering structure is up-to-date.
Table #__comprofiler_tabs Column ordering_register structure is up-to-date.
Table #__comprofiler_tabs Column width structure is up-to-date.
Table #__comprofiler_tabs Column enabled structure is up-to-date.
Table #__comprofiler_tabs Column pluginclass structure is up-to-date.
Table #__comprofiler_tabs Column pluginid structure is up-to-date.
Table #__comprofiler_tabs Column fields structure is up-to-date.
Table #__comprofiler_tabs Column params structure is up-to-date.
Table #__comprofiler_tabs Column sys structure is up-to-date.
Table #__comprofiler_tabs Column displaytype structure is up-to-date.
Table #__comprofiler_tabs Column position structure is up-to-date.
Table #__comprofiler_tabs Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_tabs Index PRIMARY is up-to-date.
Table #__comprofiler_tabs Index enabled_position_ordering is up-to-date.
Table #__comprofiler_tabs Index orderreg_enabled_pos_order is up-to-date.
Table #__comprofiler_tabs Row (`tabid` = 20) successfully updated
UPDATE `#__comprofiler_tabs` SET `fields` = 1 WHERE (`tabid` = 20)
Table #__comprofiler_tabs Row (`tabid` = 21) successfully updated
UPDATE `#__comprofiler_tabs` SET `fields` = 1 WHERE (`tabid` = 21)
Table #__comprofiler_userreports Column reportid structure is up-to-date.
Table #__comprofiler_userreports Column reporteduser structure is up-to-date.
Table #__comprofiler_userreports Column reportedbyuser structure is up-to-date.
Table #__comprofiler_userreports Column reportedondate structure is up-to-date.
Table #__comprofiler_userreports Column reportexplaination structure is up-to-date.
Table #__comprofiler_userreports Column reportedstatus structure is up-to-date.
Table #__comprofiler_userreports Index PRIMARY is up-to-date.
Table #__comprofiler_userreports Index status_user_date is up-to-date.
Table #__comprofiler_userreports Index reportedbyuser_ondate is up-to-date.
Table #__comprofiler_views Column viewer_id structure is up-to-date.
Table #__comprofiler_views Column profile_id structure is up-to-date.
Table #__comprofiler_views Column lastip structure is up-to-date.
Table #__comprofiler_views Column lastview structure is up-to-date.
Table #__comprofiler_views Column viewscount structure is up-to-date.
Table #__comprofiler_views Column vote structure is up-to-date.
Table #__comprofiler_views Column lastvote structure is up-to-date.
Table #__comprofiler_views Index PRIMARY is up-to-date.
Table #__comprofiler_views Index lastview is up-to-date.
Table #__comprofiler_views Index profile_id_lastview successfully changed
ALTER TABLE `#__comprofiler_views` DROP KEY `profile_id_lastview`, ADD KEY `profile_id_lastview` (`profile_id`, `lastview`, `viewer_id`)
Table #__comprofiler_sessions successfully created
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(32) 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