Файл: admin/applications/core/setup/versions/upg_31005/mysql_updates.php
Строк: 20
<?php
/*
+--------------------------------------------------------------------------
| IP.Board v3.3.3
| ========================================
| by Matthew Mecham
| (c) 2001 - 2009 Invision Power Services
| http://www.invisionpower.com
| ========================================
| Web: http://www.invisionboard.com
| Email: matt@invisionpower.com
| Licence Info: http://www.invisionboard.com/?license
+---------------------------------------------------------------------------
*/
$DB = ipsRegistry::DB();
$SQL[] = "ALTER TABLE core_item_markers DROP INDEX item_member_id;";
$SQL[] = "ALTER TABLE core_item_markers ADD INDEX item_member_id (item_is_deleted,item_member_id);";
$SQL[] = "UPDATE custom_bbcode SET bbcode_desc='[html]<div class="outer">n<p>Hello World</p>n</div>[/html]' where bbcode_tag='html';";
/* Have to add this into 3.0.0 upgrader now, so check here if we're upgrade > 3.0.0 */
if ( ! $DB->checkForField( 'mediatag_position', 'bbcode_mediatag' ) )
{
$SQL[] = "ALTER TABLE bbcode_mediatag ADD mediatag_position SMALLINT NOT NULL DEFAULT '0';";
}