function node_privacy_byrole_install in node privacy byrole 5

Same name and namespace in other branches

1. 6 node_privacy_byrole.install \node_privacy_byrole_install()

Implementation of hook_install().

File

./node_privacy_byrole.install, line 6

Code

function node_privacy_byrole_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_privacy_byrole} (\n        nid int(10) unsigned NOT NULL default '0',\n        gid int(10) unsigned NOT NULL default '0',\n        realm varchar(255) NOT NULL default '',\n        grant_view tinyint(3) unsigned NOT NULL default '0',\n        grant_update tinyint(3) unsigned NOT NULL default '0',\n        grant_delete tinyint(3) unsigned NOT NULL default '0',\n        PRIMARY KEY  (nid,gid,realm))");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {node_privacy_byrole} (\n        nid int_unsigned NOT NULL DEFAULT 0,\n        gid int_unsigned NOT NULL DEFAULT 0,\n        realm character varying(255) NOT NULL,\n        grant_view int_unsigned NOT NULL DEFAULT 0,\n        grant_update int_unsigned NOT NULL DEFAULT 0,\n        grant_delete int_unsigned NOT NULL DEFAULT 0,\n        CONSTRAINT node_privacy_byrole_pkey PRIMARY KEY (nid, gid, realm))");
  }
}