taxonomy_redirect.install in Taxonomy Redirect 5
File
taxonomy_redirect.install
View source
<?php
function taxonomy_redirect_install() {
switch ($GLOBALS['db_type']) {
case 'mysqli':
case 'mysql':
db_query("CREATE TABLE if not exists {taxonomy_redirect} (\n vid int(10) unsigned NOT NULL default '0',\n module varchar(255) NOT NULL default '',\n path text NOT NULL,\n tid int(10) unsigned default NULL,\n separator_replace varchar(1) default '',\n remove_text varchar(250) default NULL,\n filter int(4) default '1',\n path_case varchar(25) NOT NULL default 'No transform',\n key (vid)\n ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */");
break;
default:
break;
}
}
function taxonomy_redirect_update_1() {
return _system_update_utf8(array(
'taxonomy_redirect',
));
}
function taxonomy_redirect_update_2() {
$ret = array();
$ret[] = update_sql("UPDATE {taxonomy_redirect} SET path = concat(path, '/!tid') WHERE path NOT LIKE '%/!tid'");
return $ret;
}
function taxonomy_redirect_update_3() {
$ret = array();
$ret[] = update_sql("ALTER TABLE {taxonomy_redirect} CHANGE `path` `path` TEXT NOT NULL");
$ret[] = update_sql("ALTER TABLE {taxonomy_redirect}\n ADD (tid int(10) unsigned default NULL,\n separator_replace varchar(1) default '',\n remove_text varchar(250) default NULL,\n filter int(4) default '1')");
return $ret;
}
function taxonomy_redirect_update_4() {
$ret = array();
$ret[] = update_sql("ALTER TABLE {taxonomy_redirect}\n ADD (path_case varchar(25) NOT NULL default 'No transform')");
return $ret;
}