function ad_update_5112 in Advertisement 5.2
Introduce "extra" for ad statistics and clicks, optionally allowing add-on modules to provide additional granularity.
File
- ./
ad.install, line 421
Code
function ad_update_5112() {
$ret = array();
switch ($GLOBALS['db_type']) {
case 'mysql':
case 'mysqli':
$ret[] = update_sql("ALTER TABLE {ad_statistics} ADD extra VARCHAR(255) NULL DEFAULT '' AFTER adgroup");
$ret[] = update_sql("ALTER TABLE {ad_statistics} ADD KEY (extra)");
$ret[] = update_sql("ALTER TABLE {ad_clicks} ADD extra VARCHAR(255) NULL DEFAULT '' AFTER adgroup");
$ret[] = update_sql("ALTER TABLE {ad_clicks} ADD KEY (extra)");
break;
case 'pgsql':
db_add_column($ret, 'ad_statistics', 'extra', 'VARCHAR(255)', array(
'default' => "''",
));
db_add_column($ret, 'ad_clicks', 'extra', 'VARCHAR(255)', array(
'default' => "''",
));
break;
}
return $ret;
}