upgrade12.php (mybb_1822) | : | upgrade12.php (mybb_1823) | ||
---|---|---|---|---|
skipping to change at line 1864 | skipping to change at line 1864 | |||
{ | { | |||
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP stylesh eets"); | $db->write_query("ALTER TABLE ".TABLE_PREFIX."themes DROP stylesh eets"); | |||
} | } | |||
$db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD stylesheets text NOT NULL AFTER properties"); | $db->write_query("ALTER TABLE ".TABLE_PREFIX."themes ADD stylesheets text NOT NULL AFTER properties"); | |||
if($db->table_exists("themestylesheets")) | if($db->table_exists("themestylesheets")) | |||
{ | { | |||
$db->drop_table("themestylesheets"); | $db->drop_table("themestylesheets"); | |||
} | } | |||
$collation = $db->build_create_table_collation(); | ||||
$db->write_query("CREATE TABLE ".TABLE_PREFIX."themestylesheets( | $db->write_query("CREATE TABLE ".TABLE_PREFIX."themestylesheets( | |||
sid int unsigned NOT NULL auto_increment, | sid int unsigned NOT NULL auto_increment, | |||
name varchar(30) NOT NULL default '', | name varchar(30) NOT NULL default '', | |||
tid int unsigned NOT NULL default '0', | tid int unsigned NOT NULL default '0', | |||
attachedto text NOT NULL, | attachedto text NOT NULL, | |||
stylesheet text NOT NULL, | stylesheet text NOT NULL, | |||
cachefile varchar(100) NOT NULL default '', | cachefile varchar(100) NOT NULL default '', | |||
lastmodified bigint(30) NOT NULL default '0', | lastmodified bigint(30) NOT NULL default '0', | |||
PRIMARY KEY(sid) | PRIMARY KEY(sid) | |||
) ENGINE=MyISAM{$collation};"); | ) ENGINE=MyISAM{$collation};"); | |||
End of changes. 1 change blocks. | ||||
0 lines changed or deleted | 2 lines changed or added |