ad_text.install in Advertisement 5
File
text/ad_text.install
View source
<?php
function ad_text_install() {
switch ($GLOBALS['db_type']) {
case 'pgsql':
db_query("CREATE TABLE {ad_text} (\n aid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n\n url VARCHAR(255) NOT NULL DEFAULT '',\n adheader VARCHAR(255) NOT NULL DEFAULT '',\n adbody TEXT NOT NULL DEFAULT ''\n );");
break;
case 'mysql':
case 'mysqli':
default:
db_query("CREATE TABLE {ad_text} (\n aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n\n url VARCHAR(255) NOT NULL DEFAULT '',\n adheader VARCHAR(255) NOT NULL DEFAULT '',\n adbody TEXT NULL,\n\n PRIMARY KEY (aid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
}
drupal_set_message(t('The necessary ad_text module tables have been created.'));
}
function ad_text_uninstall() {
$result = db_query("SELECT aid FROM {ad_text}");
while ($aid = db_result($result)) {
node_delete($aid);
}
db_query('DROP TABLE {ad_text}');
}
function ad_text_update_1() {
$ret = array();
switch ($GLOBALS['db_type']) {
case 'pgsql':
break;
default:
$ret[] = update_sql("ALTER TABLE {ad_text} CONVERT TO CHARACTER SET utf8");
}
return $ret;
}