User login
Navigation
More Information
domain_install
Definition
domain_install()
domain.install, line 11
Description
Implements hook_install()
Code
function domain_install() {
switch ($GLOBALS['db_type']) {
case 'mysqli':
case 'mysql':
db_query("CREATE TABLE {domain} (
domain_id int(11) NOT NULL AUTO_INCREMENT,
subdomain varchar(255) NOT NULL default '',
sitename varchar(255) NOT NULL default '',
scheme varchar(8) NOT NULL default 'http',
valid varchar(1) NOT NULL default 1,
PRIMARY KEY (domain_id),
KEY subdomain (subdomain)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
db_query("CREATE TABLE {domain_access} (
nid int unsigned NOT NULL default '0',
gid int unsigned NOT NULL default '0',
realm varchar(255) NOT NULL default '',
PRIMARY KEY (nid,gid,realm),
INDEX (nid)
) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
break;
case 'pgsql':
db_query("CREATE TABLE {domain} (
domain_id serial,
subdomain varchar(255) NOT NULL default '',
sitename varchar(255) NOT NULL default '',
scheme varchar(8) NOT NULL default 'http',
valid varchar(1) NOT NULL default 1,
PRIMARY KEY (domain_id)
)");
db_query("CREATE INDEX {domain}_subdomain_idx ON {domain} (subdomain)");
db_query("CREATE TABLE {domain_access} (
nid int_unsigned NOT NULL default '0',
gid int_unsigned NOT NULL default '0',
realm varchar(255) NOT NULL default '',
PRIMARY KEY (nid,gid,realm)
)");
db_query("CREATE INDEX {domain_access}_nid_idx ON {domain_access} (nid)");
break;
}
// Create the 'all' realm for Domain Access.
db_query("INSERT INTO {node_access} VALUES (0, 0, 'domain_all', 1, 0, 0)");
}