Vergleich install/resources/upgrade12.php - 1.6.1 - 1.6.3

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: upgrade12.php 5016 2010-06-12 00:24:02Z RyanGordon $

 * $Id: upgrade12.php 5440 2011-04-15 10:18:35Z Tomm $

 */

/**

 */

/**

Zeile 443Zeile 443
		conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)

		conditions text NOT NULL,
perpage smallint(4) NOT NULL default '50',
PRIMARY KEY(mid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."maillogs (
mid int unsigned NOT NULL auto_increment,

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."maillogs (
mid int unsigned NOT NULL auto_increment,

Zeile 457Zeile 457
		tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY(mid)

		tid int unsigned NOT NULL default '0',
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY(mid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailerrors(
eid int unsigned NOT NULL auto_increment,


$db->write_query("CREATE TABLE ".TABLE_PREFIX."mailerrors(
eid int unsigned NOT NULL auto_increment,

Zeile 470Zeile 470
		smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY(eid)

		smtperror varchar(200) NOT NULL default '',
smtpcode int(5) NOT NULL default '0',
PRIMARY KEY(eid)

 	) TYPE=MyISAM{$collation};");

 	) ENGINE=MyISAM{$collation};");

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotions (
pid int unsigned NOT NULL auto_increment,

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotions (
pid int unsigned NOT NULL auto_increment,

Zeile 489Zeile 489
		newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

		newusergroup smallint unsigned NOT NULL default '0',
usergrouptype varchar(120) NOT NULL default '0',
PRIMARY KEY (pid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotionlogs(
plid int unsigned NOT NULL auto_increment,

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."promotionlogs(
plid int unsigned NOT NULL auto_increment,

Zeile 500Zeile 500
		dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)

		dateline bigint(30) NOT NULL default '0',
type varchar(9) NOT NULL default 'primary',
PRIMARY KEY(plid)

 	) TYPE=MyISAM{$collation};");

 	) ENGINE=MyISAM{$collation};");


if($db->field_exists('maxemails', "usergroups"))
{


if($db->field_exists('maxemails', "usergroups"))
{

Zeile 544Zeile 544
		logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)

		logging int(1) NOT NULL default '0',
locked bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");



$db->write_query("CREATE TABLE ".TABLE_PREFIX."tasklog (



$db->write_query("CREATE TABLE ".TABLE_PREFIX."tasklog (

Zeile 553Zeile 553
		dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)

		dateline bigint(30) NOT NULL default '0',
data text NOT NULL,
PRIMARY KEY(lid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");



include_once MYBB_ROOT."inc/functions_task.php";



include_once MYBB_ROOT."inc/functions_task.php";

Zeile 630Zeile 630
		percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY(lid)

		percentage int(3) NOT NULL default '0',
action text NOT NULL,
PRIMARY KEY(lid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->write_query("CREATE TABLE ".TABLE_PREFIX."warningtypes (
tid int unsigned NOT NULL auto_increment,


$db->write_query("CREATE TABLE ".TABLE_PREFIX."warningtypes (
tid int unsigned NOT NULL auto_increment,

Zeile 638Zeile 638
		points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)

		points int unsigned NOT NULL default '0',
expirationtime bigint(30) NOT NULL default '0',
PRIMARY KEY(tid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->write_query("CREATE TABLE ".TABLE_PREFIX."warnings (
wid int unsigned NOT NULL auto_increment,


$db->write_query("CREATE TABLE ".TABLE_PREFIX."warnings (
wid int unsigned NOT NULL auto_increment,

Zeile 656Zeile 656
		revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY(wid)

		revokereason text NOT NULL,
notes text NOT NULL,
PRIMARY KEY(wid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


if($db->field_exists('warningpoints', "users"))
{


if($db->field_exists('warningpoints', "users"))
{

Zeile 729Zeile 729
	  action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)

	  action varchar(50) NOT NULL default '',
data text NOT NULL,
KEY module (module, action)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");

	
if($db->field_exists('data', "adminsessions"))
{

	
if($db->field_exists('data', "adminsessions"))
{

Zeile 795Zeile 795
	  lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)

	  lastuse bigint(30) NOT NULL default '0',
dateline bigint(30) NOT NULL default '0',
PRIMARY KEY (fid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


// Now we convert all of the old bans in to the new system!
$ban_types = array('bannedips', 'bannedemails', 'bannedusernames');


// Now we convert all of the old bans in to the new system!
$ban_types = array('bannedips', 'bannedemails', 'bannedusernames');

Zeile 874Zeile 874
		useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

		useragent varchar(200) NOT NULL default '',
lastvisit bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."stats (
dateline bigint(30) NOT NULL default '0',

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."stats (
dateline bigint(30) NOT NULL default '0',

Zeile 882Zeile 882
		numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)

		numthreads int unsigned NOT NULL default '0',
numposts int unsigned NOT NULL default '0',
PRIMARY KEY(dateline)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->insert_query("spiders", array('name' => 'GoogleBot', 'useragent' => 'google'));
$db->insert_query("spiders", array('name' => 'Lycos', 'useragent' => 'lycos'));


$db->insert_query("spiders", array('name' => 'GoogleBot', 'useragent' => 'google'));
$db->insert_query("spiders", array('name' => 'Lycos', 'useragent' => 'lycos'));

Zeile 1092Zeile 1092
		prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)

		prefix varchar(50) NOT NULL default '',
title varchar(100) NOT NULL default '',
PRIMARY KEY (gid)

		) TYPE=MyISAM{$collation};");

		) ENGINE=MyISAM{$collation};");

	
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('1','calendar','<lang:group_calendar>');");
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('2','editpost','<lang:group_editpost>');");

	
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('1','calendar','<lang:group_calendar>');");
$db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('2','editpost','<lang:group_editpost>');");

Zeile 1165Zeile 1165
	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."threadviews (
tid int unsigned NOT NULL default '0'

	
$db->write_query("CREATE TABLE ".TABLE_PREFIX."threadviews (
tid int unsigned NOT NULL default '0'

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->write_query("CREATE TABLE ".TABLE_PREFIX."calendars (
cid int unsigned NOT NULL auto_increment,


$db->write_query("CREATE TABLE ".TABLE_PREFIX."calendars (
cid int unsigned NOT NULL auto_increment,

Zeile 1180Zeile 1180
	  allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)

	  allowimgcode int(1) NOT NULL default '0',
allowsmilies int(1) NOT NULL default '0',
PRIMARY KEY(cid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$calendar_array = array(
'name' => 'Default Calendar',


$calendar_array = array(
'name' => 'Default Calendar',

Zeile 1203Zeile 1203
	  canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'

	  canaddevents int(1) NOT NULL default '0',
canbypasseventmod int(1) NOT NULL default '0',
canmoderateevents int(1) NOT NULL default '0'

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$db->write_query("CREATE TABLE ".TABLE_PREFIX."forumsread (
fid int unsigned NOT NULL default '0',


$db->write_query("CREATE TABLE ".TABLE_PREFIX."forumsread (
fid int unsigned NOT NULL default '0',

Zeile 1211Zeile 1211
	  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)

	  dateline int(10) NOT NULL default '0',
KEY dateline (dateline),
UNIQUE KEY fid (fid,uid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


if($db->field_exists('dateuploaded', "attachments"))
{


if($db->field_exists('dateuploaded', "attachments"))
{

Zeile 1232Zeile 1232
		perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)

		perpage int(4) NOT NULL default '0',
view_type varchar(6) NOT NULL default '',
PRIMARY KEY(vid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


$views = file_get_contents(INSTALL_ROOT.'resources/adminviews.xml');
$parser = new XMLParser($views);


$views = file_get_contents(INSTALL_ROOT.'resources/adminviews.xml');
$parser = new XMLParser($views);

Zeile 1873Zeile 1873
		cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

		cachefile varchar(100) NOT NULL default '',
lastmodified bigint(30) NOT NULL default '0',
PRIMARY KEY(sid)

	) TYPE=MyISAM{$collation};");

	) ENGINE=MyISAM{$collation};");


// Define our default stylesheets - MyBB 1.4 contains additional stylesheets that our converted themes will also need
$contents = @file_get_contents(INSTALL_ROOT.'resources/mybb_theme.xml');


// Define our default stylesheets - MyBB 1.4 contains additional stylesheets that our converted themes will also need
$contents = @file_get_contents(INSTALL_ROOT.'resources/mybb_theme.xml');