function user_relationships_api_install in User Relationships 5.3
Same name and namespace in other branches
- 6 user_relationships_api/user_relationships_api.install \user_relationships_api_install()
File
- user_relationships_api/
user_relationships_api.install, line 40
Code
function user_relationships_api_install() {
$mysql_queries = array(
"CREATE TABLE {user_relationship_types} (\n `rtid` int(11) unsigned NOT NULL default 0,\n `name` varchar(255) NOT NULL default '',\n `plural_name` varchar(255) NOT NULL default '',\n `is_oneway` tinyint(1) NOT NULL default 0,\n `requires_approval` tinyint(1) NOT NULL default 0,\n `expires_val` int(11) unsigned NOT NULL default 0,\n PRIMARY KEY (`rtid`),\n UNIQUE KEY `name` (`name`)\n ) /*!40100 DEFAULT CHARACTER SET utf8*/;",
"CREATE TABLE {user_relationships} (\n `rid` int(11) unsigned NOT NULL default 0,\n `requester_id` int(11) NOT NULL default 0,\n `requestee_id` int(11) NOT NULL default 0,\n `rtid` int(11) NOT NULL default 0,\n `approved` tinyint(1) NOT NULL default 0,\n `created_at` int(11) NOT NULL,\n `updated_at` int(11) NOT NULL,\n `flags` int(11) default 0,\n UNIQUE KEY `relationship` (`requester_id`,`requestee_id`,`rtid`),\n KEY `rid` (`rid`),\n KEY `requester_id` (`requester_id`),\n KEY `requestee_id` (`requestee_id`),\n KEY `rtid` (`rtid`)\n ) /*!40100 DEFAULT CHARACTER SET utf8*/;",
);
$pgsql_queries = array(
"CREATE TABLE {user_relationship_types} (\n rtid int_unsigned NOT NULL default 0,\n name varchar(255) NOT NULL default '',\n plural_name varchar(255) NOT NULL default '',\n is_oneway smallint NOT NULL default 0,\n requires_approval smallint NOT NULL default 0,\n expires_val int_unsigned NOT NULL default 0,\n PRIMARY KEY (rtid)\n )",
"CREATE UNIQUE INDEX {user_relationship_types}_name_idx ON {user_relationship_types} (name)",
"CREATE SEQUENCE {user_relationship_types}_id_seq",
"CREATE TABLE {user_relationships} (\n rid int_unsigned NOT NULL default 0,\n requester_id int NOT NULL default 0,\n requestee_id int NOT NULL default 0,\n rtid int NOT NULL default 0,\n approved smallint NOT NULL default 0,\n created_at int NOT NULL,\n updated_at int NOT NULL,\n flags int default 0\n )",
"CREATE UNIQUE INDEX {user_relationships}_relationship_idx ON {user_relationships} (requester_id, requestee_id, rtid)",
"CREATE INDEX {user_relationships}_rid_idx ON {user_relationships} (rid)",
"CREATE INDEX {user_relationships}_requester_id_idx ON {user_relationships} (requester_id)",
"CREATE INDEX {user_relationships}_requestee_id_idx ON {user_relationships} (requestee_id)",
"CREATE INDEX {user_relationships}_rtid_idx ON {user_relationships} (rtid)",
"CREATE SEQUENCE {user_relationships}_id_seq",
);
if (_user_relationships_api_installation_query($mysql_queries, $pgsql_queries)) {
drupal_set_message(t('User Relationships module installed successfully.'));
}
else {
drupal_set_message(t('The installation of the User Relationships module was unsuccessful.'), 'error');
}
}