<?php
global $gBitSystem, $gUpgradeFrom, $gUpgradeTo, $gBitDb;

$upgrades = [

'TIKIWIKI19' =>  [
	'TIKIWIKI18' =>  [

[ 'DATADICT' => [
[ 'ALTER' => [
	'tiki_user_tasks' => [
		'title' => [ '`title`', 'VARCHAR(250)' ],
		'description' => [ '`description`', 'X' ],
	],
]],
[ 'RENAMECOLUMN' => [
	'tiki_pages' => [ '`created`' => '`date` I8' ],
]],
]],

[ 'QUERY' =>
	[ 'SQL92' => [
		"UPDATE `".BIT_DB_PREFIX."tiki_user_tasks` SET `title`= (SELECT `title` FROM `".BIT_DB_PREFIX."tiki_user_tasks_history` WHERE `".BIT_DB_PREFIX."tiki_user_tasks`.`taskId`=`belongs_to`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_tasks` SET `description`= (SELECT `description` FROM `".BIT_DB_PREFIX."tiki_user_tasks_history` WHERE `".BIT_DB_PREFIX."tiki_user_tasks`.`taskId`=`belongs_to`)",
	],
], ],

/*

alter table tiki_user_modules add parse char(1) default NULL;

CREATE TABLE tiki_user_tasks_history (
  belongs_to integer(14) NOT NULL,                   -- the fist task in a history it has the same id as the task id
  task_version integer(4) NOT NULL DEFAULT 0,        -- version number for the history it starts with 0
  title varchar(250) NOT NULL,                       -- title
  description text DEFAULT NULL,                     -- description
  start integer(14) DEFAULT NULL,                    -- date of the starting, if it is not set than there is not starting date
  end integer(14) DEFAULT NULL,                      -- date of the end, if it is not set than there is not dealine
  lasteditor varchar(200) NOT NULL,                  -- lasteditor: username of last editior
  lastchanges integer(14) NOT NULL,                  -- date of last changes
  priority integer(2) NOT NULL DEFAULT 3,            -- priority
  completed integer(14) DEFAULT NULL,                -- date of the completation if it is null it is not yet completed
  deleted integer(14) DEFAULT NULL,                  -- date of the deleteation it it is null it is not deleted
  status char(1) DEFAULT NULL,                       -- null := waiting,
													 -- o := open / in progress,
													 -- c := completed -> (percentage = 100)
  percentage int(4) DEFAULT NULL,
  accepted_creator char(1) DEFAULT NULL,             -- y - yes, n - no, null - waiting
  accepted_user char(1) DEFAULT NULL,                -- y - yes, n - no, null - waiting
  PRIMARY KEY (belongs_to, task_version)
) AUTO_INCREMENT=1 ;
UPDATE tiki_user_tasks set title = '-'  where title IS NULL;
INSERT INTO tiki_user_tasks_history (belongs_to, title, start, description, lasteditor, lastchanges, priority, completed, status, percentage) SELECT  taskId, title, date, description, user, date, priority, completed, status, percentage FROM tiki_user_tasks;
ALTER TABLE tiki_user_tasks ADD last_version integer(4) NOT NULL DEFAULT 0 AFTER taskId;
ALTER TABLE tiki_user_tasks MODIFY user varchar(200) NOT NULL DEFAULT '';
ALTER TABLE tiki_user_tasks ADD creator varchar(200) NOT NULL AFTER user;
ALTER TABLE tiki_user_tasks ADD public_for_group varchar(30) DEFAULT NULL AFTER creator;
ALTER TABLE tiki_user_tasks ADD rights_by_creator char(1) DEFAULT NULL AFTER public_for_group;
ALTER TABLE tiki_user_tasks ADD status char(1) default NULL;
ALTER TABLE tiki_user_tasks ADD priority int(2) default NULL;
ALTER TABLE tiki_user_tasks ADD completed int(14) default NULL;
ALTER TABLE tiki_user_tasks ADD percentage int(4) default NULL;
*/

	],
],

'BONNIE' => [
	'BWR1' => [

// STEP 1
[ 'QUERY' =>
	[ 'MYSQL' => [
	"ALTER TABLE `".BIT_DB_PREFIX."tiki_user_preferences` DROP PRIMARY KEY",
	"ALTER TABLE `".BIT_DB_PREFIX."users_usergroups` DROP PRIMARY KEY",
	"ALTER TABLE `".BIT_DB_PREFIX."users_grouppermissions` DROP PRIMARY KEY",
	"ALTER TABLE `".BIT_DB_PREFIX."tiki_group_inclusion` DROP PRIMARY KEY",
	"ALTER TABLE `".BIT_DB_PREFIX."tiki_user_watches` DROP PRIMARY KEY",
	]],
],

// STEP 1
[ 'DATADICT' => [
[ 'RENAMETABLE' => [
		'users_usergroups' => 'users_groups_map',
		'tiki_group_inclusion' => 'users_groups_inclusion',
	],
],
[ 'RENAMECOLUMN' => [
	'users_users' => [
		'`userId`' => '`user_id` I4',
		'`lastLogin`' => '`last_login` I8',
		'`currentLogin`' => '`current_login` I8',
		'`registrationDate`' => '`registration_date` I8',
//		'`avatarName`' => '`avatar_name`',
//		'`avatarSize`' => '`avatar_size`',
//		'`avatarFileType`' => '`avatar_file_type`',
//		'`avatarData`' => '`avatar_data`',
//		'`avatarLibName`' => '`avatar_lib_name`',
//		'`avatarType`' => '`avatar_type`',
	],
	'users_groups_map' => [
		'`userId`' => '`user_id` I4',
	],
	'tiki_semaphores' => [ '`semName`' => '`sem_name` C(250)',
							   '`timestamp`' => '`created` I8', ],
	'tiki_user_preferences' => [
		'`prefName`' => '`pref_name` C(40)',
	],
//	'users_groups_inclusion' => array('`groupName`', '`group_name`'),
//	'users_groups_inclusion' => array('`includeGroup`', '`include_group`'),
	'tiki_user_bookmarks_folders' => [
		'`folderId`' => '`folder_id` I4',
		'`parentId`' => '`parent_id` I4',
	],
	'tiki_user_bookmarks_urls' => [
		'`urlId`' => '`url_id` I4',
		'`lastUpdated`' => '`last_updated` I8',
		'`folderId`' => '`folder_id` I4',
	],
	'tiki_user_menus' => [
		'`menuId`' => '`menu_id` I4',
	],
	'users_grouppermissions' => [
		'`permName`' => '`perm_name` C(30)',
	],
	'users_groups' => [
		'`groupName`' => '`group_name` C(30)',
		'`groupDesc`' => '`group_desc` C(255)',
		'`groupHome`' => '`group_home` C(255)',
	],
	'users_groups_map' => [
		'`userId`' => '`user_id` I4',
	],
	'users_objectpermissions' => [
		'`permName`' => '`perm_name` C(30)',
		'`objectType`' => '`object_type` C(20)',
	],
	'users_permissions' => [
		'`permName`' => '`perm_name` C(30)',
		'`permDesc`' => '`perm_desc` C(250)',
		'`type`' => '`package` C(100)',
	],
	'tiki_userfiles' => [
		'`fileId`' => '`file_id` I4',
		'`isFile`' => '`is_file` C(1)',
	],
	'tiki_user_tasks' => [
		'`taskId`' => '`task_id` I4' ,
	],
]],

[ 'ALTER' => [
	'users_users' => [
		'content_id' => [ '`content_id`', 'I4' ],
		'default_group_id' => [ '`default_group_id`', 'I4' ],
		'real_name' => [ '`real_name`', 'VARCHAR(64)'],
		'avatar_attachment_id' => [ '`avatar_attachment_id`', 'I4' ],
		'portrait_attachment_id' => [ '`portrait_attachment_id`', 'I4' ],
		'logo_attachment_id' => [ '`logo_attachment_id`', 'I4' ],

	],
	'tiki_semaphores' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_sessions' => [
		'user_id' => [ '`user_id`', 'I4' ],
		'session_id' => [ '`session_id`', 'VARCHAR(32)' ],
	],
	'tiki_user_bookmarks_folders' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_user_bookmarks_urls' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_user_menus' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_user_preferences' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_user_tasks' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'tiki_user_watches' => [
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'users_groups' => [
		'group_id' => [ '`group_id`', 'I4' ],
		'user_id' => [ '`user_id`', 'I4' ],
	],
	'users_grouppermissions' => [
		'group_id' => [ '`group_id`', 'I4' ],
	],
	'users_objectpermissions' => [
		'group_id' => [ '`group_id`', 'I4' ],
		'object_id' => [ '`object_id`', 'I4' ],
	],
	'users_groups_map' => [
		'group_id' => [ '`group_id`', 'I4' ],
	],
	'users_groups_inclusion' => [
		'group_id' => [ '`group_id`', 'I4' ],
		'include_group_id' => [ '`include_group_id`', 'I4' ],
	],
]],

[ 'CREATE' =>  [
'users_cnxn' => "
  user_id I4,
  cookie C(64),
  ip C(16),
  last_get I8,
  connect_time I8,
  get_count I8,
  user_agent C(128),
  current_view X
  CONSTRAINTS	', CONSTRAINT `users_cnxn_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
",

]],

]],

// STEP 2
[ 'PHP' => '
	global $gBitSystem, $gBitDb;
	$max = $gBitDb->GetOne( "SELECT MAX(user_id) FROM `'.BIT_DB_PREFIX.'users_users`" );
	$gBitSystem->mDb->CreateSequence( "users_users_user_id_seq", $max + 1 );
	$gBitSystem->mDb->CreateSequence( "users_groups_id_seq", 1 );
	$gBitDb->query( "UPDATE `'.BIT_DB_PREFIX.'users_groups` SET `group_id`=-1 WHERE group_name=\'Anonymous\'" );
	$gBitDb->query( "INSERT INTO `'.BIT_DB_PREFIX.'users_groups_map` (`group_id`,`user_id`,`groupName`) VALUES ( -1, '.ANONYMOUS_USER_ID.',\'Anonymous\' )" );
	$groupNames = $gBitDb->GetCol( "SELECT `group_name` FROM `'.BIT_DB_PREFIX.'users_groups` WHERE `group_name` != \'Anonymous\'" );
	foreach( $groupNames as $name ) {
		$id = $gBitDb->GenID( "users_groups_id_seq" );
		$gBitDb->query( "UPDATE `'.BIT_DB_PREFIX.'users_groups` SET group_id=? WHERE group_name=?", array( $id, $name ) );
	}
' ],

// STEP 3
[ 'QUERY' =>
	[ 'SQL92' => [
		"UPDATE `".BIT_DB_PREFIX."users_grouppermissions` SET `perm_name`=replace(`perm_name`,'tiki_','bit_')",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`=replace(`perm_name`,'tiki_','bit_')",
		"UPDATE `".BIT_DB_PREFIX."users_objectpermissions` SET `perm_name`=replace(`perm_name`,'tiki_','bit_')",

		"INSERT INTO `".BIT_DB_PREFIX."users_users` (`real_name`, `login`, `email`, `user_id` ) VALUES ('Anonymous', 'anonymous', 'anonymous@localhost', ".ANONYMOUS_USER_ID.")",
// TikiWiki assigns the creator user foreign key as 'system' even if there is now 'system' user - XOXO spiderr
// In order for all pages to upgrade, there must be at least an 'admin' and 'system' user
		"INSERT INTO `".BIT_DB_PREFIX."users_users` (`real_name`, `login`, `email`, `user_id` ) VALUES ('Administrator', 'admin', 'root@localhost', ".ROOT_USER_ID.")",
		"INSERT INTO `".BIT_DB_PREFIX."users_users` (`real_name`, `login`, `email` ) VALUES ('System', 'system', 'system@localhost' )",
		"UPDATE `".BIT_DB_PREFIX."tiki_semaphores` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_semaphores`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_semaphores` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_semaphores`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_sessions` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_sessions`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_preferences` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_preferences`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_bookmarks_folders` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_bookmarks_folders`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_bookmarks_urls` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_bookmarks_urls`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_menus` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_menus`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_tasks` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_tasks`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."tiki_user_watches` SET `user_id`=(SELECT `user_id` FROM `".BIT_DB_PREFIX."users_users` WHERE `".BIT_DB_PREFIX."users_users`.`login`=`".BIT_DB_PREFIX."tiki_user_watches`.`user`)",
		"UPDATE `".BIT_DB_PREFIX."users_groups_map` SET `group_id`=(SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups` WHERE `".BIT_DB_PREFIX."users_groups`.`group_name`=`".BIT_DB_PREFIX."users_groups_map`.`groupName`)",
		"UPDATE `".BIT_DB_PREFIX."users_grouppermissions` SET `group_id`=(SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups` WHERE `".BIT_DB_PREFIX."users_groups`.`group_name`=`".BIT_DB_PREFIX."users_grouppermissions`.`groupName`)",
		"UPDATE `".BIT_DB_PREFIX."users_objectpermissions` SET `group_id`=(SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups` WHERE `".BIT_DB_PREFIX."users_groups`.`group_name`=`".BIT_DB_PREFIX."users_objectpermissions`.`groupName`)",
		"UPDATE `".BIT_DB_PREFIX."users_groups_inclusion` SET `group_id`=(SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups` WHERE `group_name`=`".BIT_DB_PREFIX."users_groups_inclusion`.`groupName`)",
		"UPDATE `".BIT_DB_PREFIX."users_groups_inclusion` SET `include_group_id`=(SELECT `group_id` FROM `".BIT_DB_PREFIX."users_groups` WHERE `group_name`=`includeGroup`)",
		"UPDATE `".BIT_DB_PREFIX."users_groups` SET `user_id`=1",
		"UPDATE `".BIT_DB_PREFIX."users_groups` SET `is_default`='y' WHERE `group_name`='Registered'",
		"alter table `".BIT_DB_PREFIX."tiki_user_watches` add index `user_id` (`user_id`)",
		"update `".BIT_DB_PREFIX."tiki_user_watches` set `type` = 'bitpage' where `type` = 'Wiki page'",
		"update `".BIT_DB_PREFIX."tiki_user_watches` set `type` = 'bitpage' where `type` = 'Wiki-Seite'",

	],
], ],

// STEP 4
[ 'DATADICT' => [
[ 'DROPCOLUMN' => [
		'tiki_semaphores' => [ '`user`' ],
		'tiki_sessions' => [ '`user`', '`sessionId`' ],
		'users_groups_map' => [ '`groupName`' ],
		'users_grouppermissions' => [ '`groupName`' ],
		'users_objectpermissions' => [ '`groupName`' ],
		'users_groups_inclusion' => [ '`groupName`' ],
		'tiki_user_bookmarks_folders' => [ '`user`' ],
		'tiki_user_bookmarks_urls' => [ '`user`' ],
		'tiki_user_menus' => [ '`user`' ],
		'tiki_user_preferences' => [ '`user`' ],
		'tiki_user_tasks' => [ '`user`' ],
		'tiki_user_watches' => [ '`user`' ],
	]],
]],

// STEP 5
[ 'QUERY' =>
	[ 'SQL92' => [
		"INSERT INTO `".BIT_DB_PREFIX."users_groups_map` (`group_id`, `user_id` ) VALUES ( -1, ".ANONYMOUS_USER_ID." )",
	],
], ],

// STEP 2
[ 'PHP' => '
	global $gBitSystem, $gBitDb;
	$adminGroup = $gBitDb->GetOne( "SELECT `group_id` FROM `'.BIT_DB_PREFIX.'users_grouppermissions` where perm_name=\'bit_p_admin\'" );
	if( empty( $adminGroup ) ) {
		$adminGroup = $gBitDb->GetOne( "SELECT `group_id` FROM `'.BIT_DB_PREFIX.'users_groups` where LOWER(`group_name`) LIKE \'administrator%\'" );
		if( empty( $adminGroup ) ) {
			$adminGroup = $gBitDb->GenID( "users_groups_id_seq" );
			$gBitDb->query( "INSERT INTO `'.BIT_DB_PREFIX.'users_groups` (`group_id`,`group_name`) VALUES ( $adminGroup, \'Administrators\' )" );
		}
		$gBitDb->query( "INSERT INTO `'.BIT_DB_PREFIX.'users_groups_map` (`group_id`,`user_id`) VALUES ( $adminGroup, '.ROOT_USER_ID.' )" );
		$gBitDb->query( "INSERT INTO `'.BIT_DB_PREFIX.'users_grouppermissions` (`perm_name`, `group_id`) VALUES( \'bit_p_admin\', $adminGroup )" );
	}
' ],

// STEP 4
[ 'DATADICT' => [
[ 'CREATEINDEX' => [
		'tiki_sema_user_idx' => [ 'tiki_semaphores', '`user_id`', [] ],
		'tiki_user_prefs_idx' => [ 'tiki_user_preferences', '`user_id`', [] ],
		'tiki_user_prefs_un_idx' => [ 'tiki_user_preferences', '`user_id`,`pref_name`', [ 'UNIQUE' ] ],
		'users_groups_map_user_idx' => [ 'users_groups_map', '`user_id`', [] ],
		'users_groups_map_group_idx' => [ 'users_groups_map', '`group_id`', [] ],
		'users_groups_map_ug_idx' => [ 'users_groups_map', '`user_id`,`group_id`', [ 'UNIQUE' ] ],
		'users_groupperms_group_idx' => [ 'users_grouppermissions', '`group_id`', [] ],
		'users_groupperms_group_idx' => [ 'users_grouppermissions', '`group_id`,`perm_name`', [ 'UNIQUE' ] ],
		'users_groups_inc_group_idx' => [ 'users_groups_inclusion', '`group_id`', [] ],
		'users_groups_inc_gi_idx' => [ 'users_groups_inclusion', '`group_id`,`include_group_id`', [ 'UNIQUE' ] ],
		'users_groups_gi_idx'  => [ 'users_groups', '`group_id`', ['UNIQUE'] ],
	]],
]],

	],
],

'BWR1' => [
	'BWR2' => [
// STEP 1
[ 'DATADICT' => [
	[ 'CREATE' =>  [
		'users_favorites_map' => "
		  favorite_content_id I4 PRIMARY,
		  user_id I4 PRIMARY,
		  map_position I4
		  CONSTRAINT ', CONSTRAINT `users_fav_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)'
		",
	]],
	[ 'RENAMETABLE' => [
		'tiki_semaphores'             => 'users_semaphores',
		'users_objectpermissions'     => 'users_object_permissions',
		'users_grouppermissions'      => 'users_group_permissions',
		'tiki_user_watches'           => 'users_watches',
	]],
	[ 'RENAMECOLUMN' => [
		'users_watches' => [
			'`type`' => '`watch_type` C(200)',
		],
		'users_group_permissions' => [
			'`value`' => "`perm_value` C(1) default ''",
		],
		'users_users' => [
			'`password`' => '`user_password` C(32)',
		],
		'users_permissions' => [
			'`level`' => '`perm_level` C(80)',
		],
	]],
	[ 'DROPTABLE' => [
		'tiki_sessions',
		'users_groups_inclusion',
	]],
]],

[ 'QUERY' =>
	[ 'SQL92' => [
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_shoutbox_view' WHERE `perm_name`='bit_p_view_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_shoutbox_admin' WHERE `perm_name`='bit_p_admin_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_shoutbox_post' WHERE `perm_name`='bit_p_post_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_xmlrpc_send_content' WHERE `perm_name`='bit_p_send_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_xmlrpc_sendme_content' WHERE `perm_name`='bit_p_sendme_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_xmlrpc_admin_content' WHERE `perm_name`='bit_p_admin_received_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_admin' WHERE `perm_name`='bit_p_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_access_closed_site' WHERE `perm_name`='bit_p_access_closed_site'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_gatekeeper_create' WHERE `perm_name`='bit_p_create_gatekeeper'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_gatekeeper_edit' WHERE `perm_name`='bit_p_gatekeeper_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_gatekeeper_admin' WHERE `perm_name`='bit_p_gatekeeper_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_gatekeeper_read' WHERE `perm_name`='bit_p_read_gatekeeper'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_calendar_view' WHERE `perm_name`='bit_p_view_calendar'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_sample_admin' WHERE `perm_name`='bit_p_admin_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_sample_create' WHERE `perm_name`='bit_p_create_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_sample_edit' WHERE `perm_name`='bit_p_edit_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_sample_read' WHERE `perm_name`='bit_p_read_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_sample_remove' WHERE `perm_name`='bit_p_remove_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_categories_admin' WHERE `perm_name`='bit_p_admin_categories'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_categories_view' WHERE `perm_name`='bit_p_view_categories'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_admin_banning' WHERE `perm_name`='bit_p_admin_banning'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_upload_userfiles' WHERE `perm_name`='bit_p_userfiles'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_create_bookmarks' WHERE `perm_name`='bit_p_create_bookmarks'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_cache_bookmarks' WHERE `perm_name`='bit_p_cache_bookmarks'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_configure_modules' WHERE `perm_name`='bit_p_configure_modules'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_use_usermenu' WHERE `perm_name`='bit_p_usermenu'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_use_tasks' WHERE `perm_name`='bit_p_tasks'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_custom_home_theme' WHERE `perm_name`='bit_p_custom_home_theme'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_custom_home_layout' WHERE `perm_name`='bit_p_custom_home_layout'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_use_custom_css' WHERE `perm_name`='bit_p_custom_css'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_tidbits_edit_fortune_cookies' WHERE `perm_name`='bit_p_edit_cookies'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_quota_create' WHERE `perm_name`='bit_p_create_quota'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_quota_edit' WHERE `perm_name`='bit_p_quota_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_quota_admin' WHERE `perm_name`='bit_p_quota_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_quota_read' WHERE `perm_name`='bit_p_read_quota'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_smileys_use' WHERE `perm_name`='bit_p_use_smileys'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_chatterbox_use' WHERE `perm_name`='bit_p_use_chatterbox'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_view' WHERE `perm_name`='bit_p_view_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_create' WHERE `perm_name`='bit_p_create_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_edit' WHERE `perm_name`='bit_p_edit_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_upload' WHERE `perm_name`='bit_p_upload_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_admin' WHERE `perm_name`='bit_p_admin_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_fisheye_upload_nonimages' WHERE `perm_name`='bit_p_fisheye_upload_nonimages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_languages_create' WHERE `perm_name`='bit_p_create_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_languages_edit' WHERE `perm_name`='bit_p_edit_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_languages_delete' WHERE `perm_name`='bit_p_delete_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_languages_edit_master' WHERE `perm_name`='bit_p_edit_master_strings'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_languages_import' WHERE `perm_name`='bit_p_import_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_assign_group_perms' WHERE `perm_name`='bit_p_user_group_perms'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_assign_group_members' WHERE `perm_name`='bit_p_user_group_members'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_group_subgroups' WHERE `perm_name`='bit_p_user_group_subgroups'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_admin' WHERE `perm_name`='bit_p_admin_users'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_view_icons_and_tools' WHERE `perm_name`='bit_p_view_tabs_and_tools'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_create_personal_groups' WHERE `perm_name`='bit_p_create_personal_groups'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_view_user_list' WHERE `perm_name`='bit_p_view_user_list'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_view_user_homepage' WHERE `perm_name`='bit_p_view_user_homepage'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_users_edit_user_homepage' WHERE `perm_name`='bit_p_edit_user_homepage'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_galaxia_admin' WHERE `perm_name`='bit_p_admin_workflow'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_galaxia_abort_instance' WHERE `perm_name`='bit_p_abort_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_galaxia_use' WHERE `perm_name`='bit_p_use_workflow'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_galaxia_exception_instance' WHERE `perm_name`='bit_p_exception_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_galaxia_send_instance' WHERE `perm_name`='bit_p_send_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_newsletters_admin' WHERE `perm_name`='bit_p_admin_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_newsletters_create' WHERE `perm_name`='bit_p_create_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_newsletters_create_editions' WHERE `perm_name`='bit_p_create_editions'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_newsletters_subscribe' WHERE `perm_name`='bit_p_subscribe_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_newsletters_subscribe_email' WHERE `perm_name`='bit_p_subscribe_email'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_blogs_create' WHERE `perm_name`='bit_p_create_blogs'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_blogs_create_public_blog' WHERE `perm_name`='bit_p_create_public_blog'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_blogs_post' WHERE `perm_name`='bit_p_blog_post'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_blogs_admin' WHERE `perm_name`='bit_p_blog_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_blogs_view' WHERE `perm_name`='bit_p_read_blog'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_pdf_generation' WHERE `perm_name`='bit_p_pdf_generation'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_messages_send' WHERE `perm_name`='bit_p_messages'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_edit_dynvar' WHERE `perm_name`='bit_p_edit_dynvar'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_edit_page' WHERE `perm_name`='bit_p_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_view_page' WHERE `perm_name`='bit_p_view'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_remove_page' WHERE `perm_name`='bit_p_remove'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_rollback' WHERE `perm_name`='bit_p_rollback'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_admin' WHERE `perm_name`='bit_p_admin_wiki'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_save_minor' WHERE `perm_name`='bit_p_minor'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_rename_page' WHERE `perm_name`='bit_p_rename'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_lock_page' WHERE `perm_name`='bit_p_lock'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_edit_book' WHERE `perm_name`='bit_p_edit_books'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_admin_book' WHERE `perm_name`='bit_p_admin_books'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_wiki_edit_copyright' WHERE `perm_name`='bit_p_edit_copyrights'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_pigeonholes_view' WHERE `perm_name`='bit_p_view_pigeonholes'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_pigeonholes_insert_member' WHERE `perm_name`='bit_p_insert_pigeonhole_member'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_pigeonholes_edit' WHERE `perm_name`='bit_p_edit_pigeonholes'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_stickies_edit' WHERE `perm_name`='bit_p_stickies_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_stickies_admin' WHERE `perm_name`='bit_p_stickies_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_stats_view_referer' WHERE `perm_name`='bit_p_view_referer_stats'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_stats_view' WHERE `perm_name`='bit_p_view_stats'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_edit_html_style' WHERE `perm_name`='bit_p_edit_html_style'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_post_comments' WHERE `perm_name`='bit_p_post_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_read_comments' WHERE `perm_name`='bit_p_read_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_remove_comments' WHERE `perm_name`='bit_p_remove_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_vote_comments' WHERE `perm_name`='bit_p_vote_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_edit_comments' WHERE `perm_name`='bit_p_edit_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_attach_attachments' WHERE `perm_name`='bit_p_content_attachments'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_detach_attachment' WHERE `perm_name`='bit_p_detach_attachment'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_liberty_print' WHERE `perm_name`='bit_p_print'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_edit' WHERE `perm_name`='bit_p_edit_article'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_remove' WHERE `perm_name`='bit_p_remove_article'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_read' WHERE `perm_name`='bit_p_read_article'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_submit' WHERE `perm_name`='bit_p_submit_article'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_edit_submission' WHERE `perm_name`='bit_p_edit_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_remove_submission' WHERE `perm_name`='bit_p_remove_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_approve_submission' WHERE `perm_name`='bit_p_approve_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_send' WHERE `perm_name`='bit_p_send_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_sendme' WHERE `perm_name`='bit_p_sendme_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_auto_approve' WHERE `perm_name`='bit_p_autoapprove_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_articles_admin' WHERE `perm_name`='bit_p_admin_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_nexus_insert_item' WHERE `perm_name`='bit_p_insert_nexus_item'",
		"UPDATE `".BIT_DB_PREFIX."users_permissions` SET `perm_name`='p_nexus_create_menus' WHERE `perm_name`='bit_p_create_nexus_menus'",

		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_shoutbox_view' WHERE `perm_name`='bit_p_view_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_shoutbox_admin' WHERE `perm_name`='bit_p_admin_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_shoutbox_post' WHERE `perm_name`='bit_p_post_shoutbox'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_xmlrpc_send_content' WHERE `perm_name`='bit_p_send_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_xmlrpc_sendme_content' WHERE `perm_name`='bit_p_sendme_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_xmlrpc_admin_content' WHERE `perm_name`='bit_p_admin_received_pages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_admin' WHERE `perm_name`='bit_p_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_access_closed_site' WHERE `perm_name`='bit_p_access_closed_site'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_gatekeeper_create' WHERE `perm_name`='bit_p_create_gatekeeper'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_gatekeeper_edit' WHERE `perm_name`='bit_p_gatekeeper_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_gatekeeper_admin' WHERE `perm_name`='bit_p_gatekeeper_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_gatekeeper_read' WHERE `perm_name`='bit_p_read_gatekeeper'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_calendar_view' WHERE `perm_name`='bit_p_view_calendar'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_sample_admin' WHERE `perm_name`='bit_p_admin_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_sample_create' WHERE `perm_name`='bit_p_create_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_sample_edit' WHERE `perm_name`='bit_p_edit_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_sample_read' WHERE `perm_name`='bit_p_read_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_sample_remove' WHERE `perm_name`='bit_p_remove_sample'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_categories_admin' WHERE `perm_name`='bit_p_admin_categories'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_categories_view' WHERE `perm_name`='bit_p_view_categories'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_admin_banning' WHERE `perm_name`='bit_p_admin_banning'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_upload_userfiles' WHERE `perm_name`='bit_p_userfiles'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_create_bookmarks' WHERE `perm_name`='bit_p_create_bookmarks'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_cache_bookmarks' WHERE `perm_name`='bit_p_cache_bookmarks'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_configure_modules' WHERE `perm_name`='bit_p_configure_modules'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_use_usermenu' WHERE `perm_name`='bit_p_usermenu'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_use_tasks' WHERE `perm_name`='bit_p_tasks'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_custom_home_theme' WHERE `perm_name`='bit_p_custom_home_theme'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_custom_home_layout' WHERE `perm_name`='bit_p_custom_home_layout'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_use_custom_css' WHERE `perm_name`='bit_p_custom_css'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_tidbits_edit_fortune_cookies' WHERE `perm_name`='bit_p_edit_cookies'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_quota_create' WHERE `perm_name`='bit_p_create_quota'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_quota_edit' WHERE `perm_name`='bit_p_quota_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_quota_admin' WHERE `perm_name`='bit_p_quota_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_quota_read' WHERE `perm_name`='bit_p_read_quota'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_smileys_use' WHERE `perm_name`='bit_p_use_smileys'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_chatterbox_use' WHERE `perm_name`='bit_p_use_chatterbox'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_view' WHERE `perm_name`='bit_p_view_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_create' WHERE `perm_name`='bit_p_create_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_edit' WHERE `perm_name`='bit_p_edit_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_upload' WHERE `perm_name`='bit_p_upload_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_admin' WHERE `perm_name`='bit_p_admin_fisheye'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_fisheye_upload_nonimages' WHERE `perm_name`='bit_p_fisheye_upload_nonimages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_languages_create' WHERE `perm_name`='bit_p_create_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_languages_edit' WHERE `perm_name`='bit_p_edit_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_languages_delete' WHERE `perm_name`='bit_p_delete_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_languages_edit_master' WHERE `perm_name`='bit_p_edit_master_strings'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_languages_import' WHERE `perm_name`='bit_p_import_languages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_assign_group_perms' WHERE `perm_name`='bit_p_user_group_perms'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_assign_group_members' WHERE `perm_name`='bit_p_user_group_members'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_group_subgroups' WHERE `perm_name`='bit_p_user_group_subgroups'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_admin' WHERE `perm_name`='bit_p_admin_users'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_view_icons_and_tools' WHERE `perm_name`='bit_p_view_tabs_and_tools'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_create_personal_groups' WHERE `perm_name`='bit_p_create_personal_groups'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_view_user_list' WHERE `perm_name`='bit_p_view_user_list'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_view_user_homepage' WHERE `perm_name`='bit_p_view_user_homepage'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_users_edit_user_homepage' WHERE `perm_name`='bit_p_edit_user_homepage'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_galaxia_admin' WHERE `perm_name`='bit_p_admin_workflow'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_galaxia_abort_instance' WHERE `perm_name`='bit_p_abort_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_galaxia_use' WHERE `perm_name`='bit_p_use_workflow'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_galaxia_exception_instance' WHERE `perm_name`='bit_p_exception_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_galaxia_send_instance' WHERE `perm_name`='bit_p_send_instance'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_newsletters_admin' WHERE `perm_name`='bit_p_admin_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_newsletters_create' WHERE `perm_name`='bit_p_create_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_newsletters_create_editions' WHERE `perm_name`='bit_p_create_editions'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_newsletters_subscribe' WHERE `perm_name`='bit_p_subscribe_newsletters'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_newsletters_subscribe_email' WHERE `perm_name`='bit_p_subscribe_email'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_blogs_create' WHERE `perm_name`='bit_p_create_blogs'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_blogs_create_public_blog' WHERE `perm_name`='bit_p_create_public_blog'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_blogs_post' WHERE `perm_name`='bit_p_blog_post'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_blogs_admin' WHERE `perm_name`='bit_p_blog_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_blogs_view' WHERE `perm_name`='bit_p_read_blog'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_pdf_generation' WHERE `perm_name`='bit_p_pdf_generation'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_messages_send' WHERE `perm_name`='bit_p_messages'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_edit_dynvar' WHERE `perm_name`='bit_p_edit_dynvar'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_edit_page' WHERE `perm_name`='bit_p_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_view_page' WHERE `perm_name`='bit_p_view'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_remove_page' WHERE `perm_name`='bit_p_remove'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_rollback' WHERE `perm_name`='bit_p_rollback'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_admin' WHERE `perm_name`='bit_p_admin_wiki'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_save_minor' WHERE `perm_name`='bit_p_minor'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_rename_page' WHERE `perm_name`='bit_p_rename'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_lock_page' WHERE `perm_name`='bit_p_lock'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_edit_book' WHERE `perm_name`='bit_p_edit_books'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_admin_book' WHERE `perm_name`='bit_p_admin_books'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_wiki_edit_copyright' WHERE `perm_name`='bit_p_edit_copyrights'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_pigeonholes_view' WHERE `perm_name`='bit_p_view_pigeonholes'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_pigeonholes_insert_member' WHERE `perm_name`='bit_p_insert_pigeonhole_member'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_pigeonholes_edit' WHERE `perm_name`='bit_p_edit_pigeonholes'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_stickies_edit' WHERE `perm_name`='bit_p_stickies_edit'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_stickies_admin' WHERE `perm_name`='bit_p_stickies_admin'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_stats_view_referer' WHERE `perm_name`='bit_p_view_referer_stats'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_stats_view' WHERE `perm_name`='bit_p_view_stats'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_edit_html_style' WHERE `perm_name`='bit_p_edit_html_style'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_post_comments' WHERE `perm_name`='bit_p_post_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_read_comments' WHERE `perm_name`='bit_p_read_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_remove_comments' WHERE `perm_name`='bit_p_remove_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_vote_comments' WHERE `perm_name`='bit_p_vote_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_edit_comments' WHERE `perm_name`='bit_p_edit_comments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_attach_attachments' WHERE `perm_name`='bit_p_content_attachments'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_detach_attachment' WHERE `perm_name`='bit_p_detach_attachment'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_liberty_print' WHERE `perm_name`='bit_p_print'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_edit' WHERE `perm_name`='bit_p_edit_article'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_remove' WHERE `perm_name`='bit_p_remove_article'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_read' WHERE `perm_name`='bit_p_read_article'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_submit' WHERE `perm_name`='bit_p_submit_article'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_edit_submission' WHERE `perm_name`='bit_p_edit_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_remove_submission' WHERE `perm_name`='bit_p_remove_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_approve_submission' WHERE `perm_name`='bit_p_approve_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_send' WHERE `perm_name`='bit_p_send_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_sendme' WHERE `perm_name`='bit_p_sendme_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_auto_approve' WHERE `perm_name`='bit_p_autoapprove_submission'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_articles_admin' WHERE `perm_name`='bit_p_admin_articles'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_nexus_insert_item' WHERE `perm_name`='bit_p_insert_nexus_item'",
		"UPDATE `".BIT_DB_PREFIX."users_group_permissions` SET `perm_name`='p_nexus_create_menus' WHERE `perm_name`='bit_p_create_nexus_menus'",
	],
], ],

[ 'DATADICT' => [
	['ALTER' => [
		'users_users' => [
			'provpass_expires' => [ '`provpass_expires`', 'I8' ],
		],
		'users_groups' => [
			'is_public' => '`is_public` C(1)'  ,
			'after_registration_page' => '`after_registration_page` C(255)' ,
		],
		'users_cnxn' => [
			'assume_user_id' => [ '`assume_user_id`', 'I4' ],
		],
	]],
	],
],

], ],
];

if( isset( $upgrades[$gUpgradeFrom][$gUpgradeTo] ) ) {
	$gBitSystem->registerUpgrade( USERS_PKG_NAME, $upgrades[$gUpgradeFrom][$gUpgradeTo] );
}

?>