function nodequeue_install in Nodequeue 5

Same name and namespace in other branches

1. 5.2 nodequeue.install \nodequeue_install()
2. 6.2 nodequeue.install \nodequeue_install()

File

./nodequeue.install, line 3

Code

function nodequeue_install() {
  drupal_set_message('Installing nodequeue');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE if not exists {nodequeue_queue} (\n          qid int(10) unsigned NOT NULL PRIMARY KEY,\n          title varchar(255) NOT NULL,\n          size int(3) unsigned default '0',\n          link varchar(255),\n          link_remove varchar(255)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE if not exists {nodequeue_roles} (\n          qid int(10) unsigned NOT NULL,\n          rid int(10) unsigned,\n          KEY {nodequeue_roles}_qid_idx (qid),\n          KEY {nodequeue_roles}_rid_idx (rid)\n        )/*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE if not exists {nodequeue_types} (\n          qid int(10) unsigned NOT NULL,\n          type varchar(255),\n          KEY {nodequeue_types}_qid_idx (qid),\n          KEY {nodequeue_types}_type_idx (type)\n        )/*!40100 DEFAULT CHARACTER SET utf8 */");
      db_query("CREATE TABLE if not exists {nodequeue_nodes} (\n          qid int(10) unsigned NOT NULL,\n          nid int(10) unsigned,\n          position int(3) unsigned,\n          timestamp int unsigned NOT NULL default '0',\n          KEY {nodequeue_nodes}_qid_idx (qid, position),\n          KEY {nodequeue_nodes}_nid_idx (nid)\n        )/*!40100 DEFAULT CHARACTER SET utf8 */");
      $success = TRUE;
      break;
    case 'pgsql':
      db_query("CREATE TABLE {nodequeue_queue} (\n          qid integer NOT NULL PRIMARY KEY,\n          title varchar(255) NOT NULL,\n          size integer default '0',\n          link varchar(255),\n          link_remove varchar(255)\n        )");
      db_query("CREATE TABLE {nodequeue_roles} (\n          qid integer NOT NULL,\n          rid integer\n        )");
      db_query("CREATE INDEX {nodequeue_roles}_qid_idx ON {nodequeue_roles} (qid)");
      db_query("CREATE INDEX {nodequeue_roles}_rid_idx ON {nodequeue_roles} (rid)");
      db_query("CREATE TABLE {nodequeue_types} (\n          qid integer NOT NULL,\n          type varchar(255)\n        )");
      db_query("CREATE INDEX {nodequeue_types}_qid_idx ON {nodequeue_types} (qid)");
      db_query("CREATE TABLE {nodequeue_nodes} (\n          qid integer NOT NULL,\n          nid integer,\n          position integer,\n          timestamp integer NOT NULL default '0',\n        )");
      db_query("CREATE INDEX {nodequeue_nodes}_qid_idx ON {nodequeue_nodes} (qid, position)");
      db_query("CREATE INDEX {nodequeue_nodes}_nid_idx ON {nodequeue_nodes} (nid)");
      db_query("CREATE SEQUENCE nodequeue_queue_qid_seq INCREMENT 1 START 1");
      $success = TRUE;
      break;
  }
  if ($success) {
    drupal_set_message(t('Nodequeue module installed tables successfully.'));
  }
  else {
    drupal_set_message(t('The installation of nodequeue module was unsuccessful.'), 'error');
  }
}