function webfm_install in Web File Manager 5

Same name and namespace in other branches

1. 5.2 webfm.install \webfm_install()

Implementation of hook_install().

File

./webfm.install, line 6

Code

function webfm_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {webfm_file} (\n        fid int(10) NOT NULL auto_increment,\n        uid int(10) NOT NULL default '0',\n        fpath longtext NOT NULL,\n        fsize int(10) NOT NULL default '0',\n        fmime varchar(255) NOT NULL default '',\n        ftitle varchar(255) NOT NULL default '',\n        fdesc text NOT NULL,\n        fcreatedate int(11) NOT NULL default '0',\n        flang varchar(16) NOT NULL default '',\n        fpublisher varchar(255) NOT NULL default '',\n        fformat varchar(255) NOT NULL default '',\n        fversion int(10) NOT NULL default '0',\n        perm tinyint NOT NULL default '0',\n        dl_cnt int(10) NOT NULL default '0',\n        PRIMARY KEY (`fid`)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      db_query("CREATE TABLE {webfm_attach} (\n        nid int(10) NOT NULL default '0',\n        fid int(10) NOT NULL default '0',\n        weight int(10) NOT NULL default '0',\n        PRIMARY KEY (`nid`,`fid`)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {webfm_file} (\n        fid SERIAL NOT NULL,\n        uid integer NOT NULL default 0,\n        fpath text NOT NULL,\n        fsize integer NOT NULL default 0,\n        fmime varchar(255) NOT NULL default '',\n        ftitle varchar(255) NOT NULL default '',\n        fdesc text NOT NULL default '',\n        fcreatedate numeric(11) NOT NULL default 0,\n        flang varchar(16) NOT NULL default '',\n        fpublisher varchar(255) NOT NULL default '',\n        fformat varchar(255) NOT NULL default '',\n        fversion integer NOT NULL default 0,\n        perm smallint NOT NULL default 0,\n        dl_cnt integer NOT NULL default 0,\n        PRIMARY KEY (fid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      db_query("CREATE TABLE {webfm_attach} (\n        nid integer NOT NULL default 0,\n        fid integer NOT NULL default 0,\n        weight integer NOT NULL default '0',\n        PRIMARY KEY (nid,fid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    default:
      drupal_set_message('webfm_install currently supports MySQL and Postgres database only', error);
      break;
  }
}