function ad_install in Advertisement 5
Same name and namespace in other branches
- 5.2 ad.install \ad_install()
- 6.3 ad.install \ad_install()
- 6 ad.install \ad_install()
- 6.2 ad.install \ad_install()
- 7 ad.install \ad_install()
- 7.2 ad.install \ad_install()
Ad module database schema. Copyright (c) 2005-2007 Jeremy Andrews <jeremy@kerneltrap.org>. All rights reserved.
File
- ./
ad.install, line 9
Code
function ad_install() {
switch ($GLOBALS['db_type']) {
case 'pgsql':
/* The ad table stores administrative information about each ad. The
* actual ad itself can be found in the appropriate ad type table.
*/
db_query("CREATE TABLE {ads} (\n aid INT NOT NULL UNIQUE DEFAULT '0' PRIMARY KEY,\n uid INT NOT NULL DEFAULT '0',\n \n adstatus VARCHAR(255) NOT NULL DEFAULT '',\n adtype VARCHAR(255) NOT NULL DEFAULT '',\n\n redirect VARCHAR(255) NOT NULL DEFAULT '',\n\n autoactivate INT NOT NULL DEFAULT '0',\n autoactivated INT NOT NULL DEFAULT '0',\n autoexpire INT NOT NULL DEFAULT '0',\n autoexpired INT NOT NULL DEFAULT '0',\n\n activated INT NOT NULL DEFAULT '0',\n maxviews INT NOT NULL DEFAULT '0',\n maxclicks INT NOT NULL DEFAULT '0',\n expired INT NOT NULL DEFAULT '0'\n );");
/**
* Every ad can have one or more owners.
*/
db_query("CREATE TABLE {ad_owners} (\n oid SERIAL NOT NULL PRIMARY KEY,\n aid INT NOT NULL DEFAULT '0',\n uid INT NOT NULL DEFAULT '0'\n );");
/**
* Permissions can be granted to each owner of each ad. The same owner
* can own multiple ads, and can have different permissions for each ad.
*/
db_query("CREATE TABLE {ad_permissions} (\n oid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n permissions TEXT NULL DEFAULT ''\n );");
/**
* This table counts each time a given action occurs on an ad. Actions
* include when the ad is viewed, clicked, enabled and disabled.
* Statistics are collected at an hourly granularity.
*
* The source column is used for tracking statistics for externally
* hosted ads.
*
* Actions:
* 'view', 'click', 'enable', 'disable'
*/
db_query("CREATE TABLE {ad_statistics} (\n sid SERIAL NOT NULL PRIMARY KEY,\n aid INT NOT NULL DEFAULT '0',\n\n date INT NOT NULL DEFAULT '0',\n action VARCHAR(255) NOT NULL DEFAULT '',\n adgroup VARCHAR(255) NULL DEFAULT '',\n hostid VARCHAR(32) NULL DEFAULT '',\n count INT NOT NULL DEFAULT '0'\n );");
/**
* The ad_clicks table tracks when a given advertisement was clicked,
* who clicked it (uid if any and IP address), and what page they were
* on when they clicked it.
*/
db_query("CREATE TABLE {ad_clicks} (\n cid SERIAL NOT NULL PRIMARY KEY,\n aid INT NOT NULL DEFAULT '0',\n uid INT NOT NULL DEFAULT '0',\n\n status INT NOT NULL DEFAULT '0',\n \n hostname varchar(128) NOT NULL DEFAULT '',\n user_agent varchar(255) NOT NULL DEFAULT '',\n adgroup varchar(255) NOT NULL DEFAULT '',\n hostid varchar(32) NOT NULL DEFAULT '',\n url varchar(255) DEFAULT '',\n timestamp INT NOT NULL DEFAULT '0'\n );");
/**
* The ad_hosts table is used to configure users that can display ads
* remotely.
*/
db_query("CREATE TABLE {ad_hosts} (\n uid INT NOT NULL DEFAULT '0' PRIMARY KEY,\n \n hostid varchar(32) DEFAULT '',\n status INT NOT NULL DEFAULT '0',\n description TEXT NOT NULL DEFAULT ''\n );");
break;
case 'mysql':
case 'mysqli':
default:
/* The ad table stores administrative information about each ad. The
* actual ad itself can be found in the appropriate ad type table.
*/
db_query("CREATE TABLE {ads} (\n aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n uid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n \n adstatus VARCHAR(255) NOT NULL DEFAULT '',\n adtype VARCHAR(255) NOT NULL DEFAULT '',\n\n redirect VARCHAR(255) NOT NULL DEFAULT '',\n\n autoactivate INT UNSIGNED NOT NULL DEFAULT '0',\n autoactivated INT UNSIGNED NOT NULL DEFAULT '0',\n autoexpire INT UNSIGNED NOT NULL DEFAULT '0',\n autoexpired INT UNSIGNED NOT NULL DEFAULT '0',\n\n activated INT UNSIGNED NOT NULL DEFAULT '0',\n maxviews INT UNSIGNED NOT NULL DEFAULT '0',\n maxclicks INT UNSIGNED NOT NULL DEFAULT '0',\n expired INT UNSIGNED NOT NULL DEFAULT '0',\n\n PRIMARY KEY (aid),\n KEY (uid),\n KEY (autoactivate),\n KEY (autoexpire)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
/**
* Every ad can have one or more owners.
*/
db_query("CREATE TABLE {ad_owners} (\n oid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,\n aid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n uid INT(10) UNSIGNED NOT NULL DEFAULT '0',\n\n PRIMARY KEY (oid),\n KEY (aid),\n KEY (uid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
/**
* Permissions can be granted to each owner of each ad. The same owner
* can own multiple ads, and can have different permissions for each ad.
*/
db_query("CREATE TABLE {ad_permissions} (\n oid INT(11) UNSIGNED NOT NULL DEFAULT '0',\n permissions LONGTEXT NULL,\n PRIMARY KEY (oid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
/**
* This table counts each time a given action occurs on an ad. Actions
* include when the ad is viewed, clicked, enabled and disabled.
* Statistics are collected at an hourly granularity.
*
* The source column is used for tracking statistics for externally
* hosted ads.
*
* Actions:
* 'view', 'click', 'enable', 'disable'
*/
db_query("CREATE TABLE {ad_statistics} (\n sid INT UNSIGNED NOT NULL AUTO_INCREMENT,\n aid INT UNSIGNED NOT NULL DEFAULT '0',\n\n date INT(10) UNSIGNED NOT NULL DEFAULT '0',\n action VARCHAR(255) NOT NULL DEFAULT '',\n adgroup VARCHAR(255) NULL DEFAULT '',\n hostid VARCHAR(32) NULL DEFAULT '',\n count INT(11) UNSIGNED NOT NULL DEFAULT '0',\n\n PRIMARY KEY (sid),\n KEY (aid),\n KEY (date),\n KEY (action),\n KEY (adgroup),\n KEY (hostid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
/**
* The ad_clicks table tracks when a given advertisement was clicked,
* who clicked it (uid if any and IP address), and what page they were
* on when they clicked it.
*/
db_query("CREATE TABLE {ad_clicks} (\n cid INT UNSIGNED NOT NULL AUTO_INCREMENT,\n aid INT UNSIGNED NOT NULL DEFAULT '0',\n uid int(10) UNSIGNED NOT NULL DEFAULT '0',\n\n status INT(2) NOT NULL DEFAULT '0',\n\n hostname varchar(128) NOT NULL DEFAULT '',\n user_agent varchar(255) NOT NULL DEFAULT '',\n adgroup varchar(255) NOT NULL DEFAULT '',\n hostid varchar(32) NOT NULL DEFAULT '',\n url varchar(255) DEFAULT '',\n timestamp INT(11) UNSIGNED NOT NULL DEFAULT '0',\n\n PRIMARY KEY (cid),\n KEY (aid),\n KEY (status),\n KEY (hostname),\n KEY (user_agent),\n KEY (adgroup),\n KEY (hostid),\n KEY (url)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
/**
* The ad_hosts table is used to configure users that can display ads
* remotely.
*/
db_query("CREATE TABLE {ad_hosts} (\n uid INT UNSIGNED NOT NULL DEFAULT '0',\n\n hostid varchar(32) DEFAULT '',\n\n status INT(2) UNSIGNED NOT NULL DEFAULT '0',\n description TEXT NULL,\n\n PRIMARY KEY (uid),\n KEY (status),\n KEY (hostid)\n ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
}
drupal_set_message(t('The necessary ad module tables have been created.'));
}