function answers_install in Answers 5.2

Same name and namespace in other branches

1. 8 answers.install \answers_install()
2. 7.4 answers.install \answers_install()

Implementation of hook_install().

File

./answers.install, line 6

Code

function answers_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {answers} (\n        qid int(11) NOT NULL default '0',\n        nid int(11) NOT NULL default '0',\n        uid int(11) NOT NULL default '0',\n        Status tinyint(1) NOT NULL default '0',\n        relationscore int(2) NOT NULL default '0',\n        PRIMARY KEY (qid,uid, nid),\n        KEY answers_uid (uid),\n        KEY answers_nid (nid),\n        KEY answers_qid (qid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {quests} (\n        vid int(11) NOT NULL default '0',\n        nid int(11) NOT NULL default '0',\n        notifyme tinyint(1) NOT NULL default '0',\n        answeranon tinyint(1) NOT NULL default '0',\n        PRIMARY KEY (vid,nid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {answers} (\n        qid int_unsigned NOT NULL default 0,\n        nid int_unsigned NOT NULL default 0,\n        uid int_unsigned NOT NULL default 0,\n        Status int_unsigned NOT NULL default 0,\n        relationscore int NOT NULL default 0,\n        PRIMARY KEY (qid,uid, nid),\n        KEY answers_uid (uid),\n        KEY answers_nid (nid),\n        KEY answers_qid (qid)\n      )");
      db_query("CREATE TABLE {quests} (\n        vid int_unsigned NOT NULL default 0,\n        nid int_unsigned NOT NULL default 0,\n        notifyme int_unsigned NOT NULL default 0,\n        answeranon int_unsigned NOT NULL default 0,\n        PRIMARY KEY (vid,nid)\n      )");

      // TODO: TEST on PGSQL.
      break;
  }
}