function brilliant_gallery_install in Brilliant Gallery 5.3

Same name and namespace in other branches

1. 5.4 brilliant_gallery.install \brilliant_gallery_install()
2. 6.4 brilliant_gallery.install \brilliant_gallery_install()
3. 6 brilliant_gallery.install \brilliant_gallery_install()
4. 6.2 brilliant_gallery.install \brilliant_gallery_install()
5. 6.3 brilliant_gallery.install \brilliant_gallery_install()

File

./brilliant_gallery.install, line 3

Code

function brilliant_gallery_install() {
  drupal_set_message(t('Creating tables for brilliant gallery checklists'));
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE brilliant_gallery_checklist (\n\t    nid int NOT NULL default 0,\n            user int NOT NULL default 0,\n\t    qid text NOT NULL,\n\t    state int NOT NULL default 0,\n\t    PRIMARY KEY (nid, user, qid(255))\n\t    );");
      $sucess = TRUE;
      break;
    case 'pgsql':
      db_query("CREATE TABLE brilliant_gallery_checklist (\n\t    nid int NOT NULL default 0,\n            user int NOT NULL default 0,\n\t    qid text NOT NULL,\n\t    state int NOT NULL default 0,\n\t    PRIMARY KEY (nid, user, qid)\n\t    );\n          ");
      $sucess = TRUE;
      break;
    default:
      drupal_set_message(t("Error: Unsupported database"));
  }
  if ($success) {
    drupal_set_message(t("Tables created successfully"));
  }
}