modules/dbfm/dbfm.install

<?php
/* $Id$ */

/**
 * Implementation of hook_install().
 * note that I chose to make flang an int and all dates were made datetimes - rob's version is an int - people will
 * want to give their versions all sorts of names: draft0a etc. some use the publisher field for the author - I've 
 * chosen to make it a new field
 * removed newdesc, newname
 * language chaanged to int
 */
function dbfm_install(){
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {dbfm_file} (
        fid int(10) NOT NULL auto_increment,
        uid int(10) NOT NULL default '0',
        fpath text NOT NULL,
        fname varchar(255) NOT NULL default '',
        fsize int(10) NOT NULL default '0',
        fmime varchar(255) NOT NULL default '',
        ftitle varchar(255) NOT NULL default '',
        fdesc text,
        fcreatedate datetime NOT NULL COMMENT 'changed from the original int(11)',
        flang int(2) NOT NULL default '0',
        fpublisher varchar(255) NOT NULL default '',
        fformat varchar(255) NOT NULL default '',
        fversion int(10) NOT NULL default '0',
        fnewver varchar(30) default '',
        fblob longblob COMMENT 'save a file as a blob',
        flastmod datetime NOT NULL,
        fparent int(10) NOT NULL default '0' COMMENT 'the parent fid, a directory id',
        fimagesize varchar(16) NOT NULL default '0' COMMENT 'holds image size as a text string',
        fimageh int(4) NOT NULL default '0',
        fimagew int(4) NOT NULL default '0',
        fdown int(4) NOT NULL default '0' COMMENT 'a bit generous with the size!',
        fstat int(2) NOT NULL default '0',
        faccess int(3) NOT NULL default '0',
        fauthor varchar(50) NOT NULL default '',
        PRIMARY KEY (`fid`)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {dbfm_file} (
        fid SERIAL NOT NULL,
        uid int(10) NOT NULL default '0',
        fpath text NOT NULL,
        fname varchar(255) NOT NULL default '',
        fsize int(10) NOT NULL default '0',
        fmime varchar(255) NOT NULL default '',
        ftitle varchar(255) NOT NULL default '',
        fdesc text,
        fcreatedate datetime NOT NULL COMMENT 'changed from the original int(11)',
        flang int(2) NOT NULL default '0',
        fpublisher varchar(255) NOT NULL default '',
        fformat varchar(255) NOT NULL default '',
        fversion int(10) NOT NULL default '0',
        fnewver varchar(30) default '',
        fblob longblob COMMENT 'save a file as a blob',
        flastmod datetime NOT NULL,
        fparent int(10) NOT NULL default '0' COMMENT 'the parent fid, a directory id',
        fimagesize varchar(16) NOT NULL default '0' COMMENT 'holds image size as a text string',
        fimageh int(4) NOT NULL default '0',
        fimagew int(4) NOT NULL default '0',
        fdown int(4) NOT NULL default '0' COMMENT 'a bit generous with the size!',
        fstat int(2) NOT NULL default '0',
        faccess int(3) NOT NULL default '0',
        fauthor varchar(50) NOT NULL default '',
         PRIMARY KEY (fid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
	    break;

    default:
      drupal_set_message('dbfm_install currently supports MySQL and Postgres database only', error);
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function dbfm_uninstall() {
  db_query('DROP TABLE {dbfm_file}');
  variable_del('dbfm_root_dir');
  variable_del('dbfm_icon_dir');
  variable_del('dbfm_debug');
  variable_del('dbfm_cron');
  variable_del('dbfm_frbdn');
  variable_del('dbfm_max_resolution');
  $roles = user_roles(1, 'access dbfm');
  foreach ($roles as $rid => $role) {
   variable_del('dbfm_extensions_'.$rid);
   variable_del('dbfm_uploadsize_'.$rid);
   variable_del('dbfm_usersize_'.$rid);
  }
  $types = node_get_types();
  foreach ($types as $type) {
    if ($type->type)
      variable_del('dbfm_attach_'.$type->type);
  }
}
1	<?php
2	/* $Id$ */
3
4	/**
5	* Implementation of hook_install().
6	* note that I chose to make flang an int and all dates were made datetimes - rob's version is an int - people will
7	* want to give their versions all sorts of names: draft0a etc. some use the publisher field for the author - I've
8	* chosen to make it a new field
9	* removed newdesc, newname
10	* language chaanged to int
11	*/
12	function dbfm_install(){
13	switch ($GLOBALS['db_type']) {
14	case 'mysql':
15	case 'mysqli':
16	db_query("CREATE TABLE {dbfm_file} (
17	fid int(10) NOT NULL auto_increment,
18	uid int(10) NOT NULL default '0',
19	fpath text NOT NULL,
20	fname varchar(255) NOT NULL default '',
21	fsize int(10) NOT NULL default '0',
22	fmime varchar(255) NOT NULL default '',
23	ftitle varchar(255) NOT NULL default '',
24	fdesc text,
25	fcreatedate datetime NOT NULL COMMENT 'changed from the original int(11)',
26	flang int(2) NOT NULL default '0',
27	fpublisher varchar(255) NOT NULL default '',
28	fformat varchar(255) NOT NULL default '',
29	fversion int(10) NOT NULL default '0',
30	fnewver varchar(30) default '',
31	fblob longblob COMMENT 'save a file as a blob',
32	flastmod datetime NOT NULL,
33	fparent int(10) NOT NULL default '0' COMMENT 'the parent fid, a directory id',
34	fimagesize varchar(16) NOT NULL default '0' COMMENT 'holds image size as a text string',
35	fimageh int(4) NOT NULL default '0',
36	fimagew int(4) NOT NULL default '0',
37	fdown int(4) NOT NULL default '0' COMMENT 'a bit generous with the size!',
38	fstat int(2) NOT NULL default '0',
39	faccess int(3) NOT NULL default '0',
40	fauthor varchar(50) NOT NULL default '',
41	PRIMARY KEY (`fid`)
42	) /!40100 DEFAULT CHARACTER SET utf8 /;");
43	break;
44
45	case 'pgsql':
46	db_query("CREATE TABLE {dbfm_file} (
47	fid SERIAL NOT NULL,
48	uid int(10) NOT NULL default '0',
49	fpath text NOT NULL,
50	fname varchar(255) NOT NULL default '',
51	fsize int(10) NOT NULL default '0',
52	fmime varchar(255) NOT NULL default '',
53	ftitle varchar(255) NOT NULL default '',
54	fdesc text,
55	fcreatedate datetime NOT NULL COMMENT 'changed from the original int(11)',
56	flang int(2) NOT NULL default '0',
57	fpublisher varchar(255) NOT NULL default '',
58	fformat varchar(255) NOT NULL default '',
59	fversion int(10) NOT NULL default '0',
60	fnewver varchar(30) default '',
61	fblob longblob COMMENT 'save a file as a blob',
62	flastmod datetime NOT NULL,
63	fparent int(10) NOT NULL default '0' COMMENT 'the parent fid, a directory id',
64	fimagesize varchar(16) NOT NULL default '0' COMMENT 'holds image size as a text string',
65	fimageh int(4) NOT NULL default '0',
66	fimagew int(4) NOT NULL default '0',
67	fdown int(4) NOT NULL default '0' COMMENT 'a bit generous with the size!',
68	fstat int(2) NOT NULL default '0',
69	faccess int(3) NOT NULL default '0',
70	fauthor varchar(50) NOT NULL default '',
71	PRIMARY KEY (fid)
72	) /!40100 DEFAULT CHARACTER SET utf8 /;");
73	break;
74
75	default:
76	drupal_set_message('dbfm_install currently supports MySQL and Postgres database only', error);
77	break;
78	}
79	}
80
81	/**
82	* Implementation of hook_uninstall().
83	*/
84	function dbfm_uninstall() {
85	db_query('DROP TABLE {dbfm_file}');
86	variable_del('dbfm_root_dir');
87	variable_del('dbfm_icon_dir');
88	variable_del('dbfm_debug');
89	variable_del('dbfm_cron');
90	variable_del('dbfm_frbdn');
91	variable_del('dbfm_max_resolution');
92	$roles = user_roles(1, 'access dbfm');
93	foreach ($roles as $rid => $role) {
94	variable_del('dbfm_extensions_'.$rid);
95	variable_del('dbfm_uploadsize_'.$rid);
96	variable_del('dbfm_usersize_'.$rid);
97	}
98	$types = node_get_types();
99	foreach ($types as $type) {
100	if ($type->type)
101	variable_del('dbfm_attach_'.$type->type);
102	}
103	}