function user_relationships_install in User Relationships 5.2

Same name and namespace in other branches

1. 5 user_relationships.install \user_relationships_install()

File

./user_relationships.install, line 40

Code

function user_relationships_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_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');
  }
}