modules/node_media/node_media.install

<?php
/**
 * Implementation of hook_install().
 */
function node_media_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {node_media} (
	id int(10) unsigned NOT NULL auto_increment,
	nid int(10) unsigned NOT NULL default '0',
	uid int(10) unsigned NOT NULL default '0',
	filename varchar(255) NOT NULL default '',
	filepath varchar(255) NOT NULL default '',
	filemime varchar(255) NOT NULL default '',
	filesize int(10) unsigned NOT NULL default '0',
	thumbpath varchar(255) NOT NULL default '',
	thumbsize int(10) unsigned NOT NULL default '0',
	status tinyint(1) unsigned NOT NULL default '1',
	weight tinyint(1) NOT NULL default '0',
	description varchar(255) default NULL,
	type tinyint(1) unsigned NOT NULL default '0',
	PRIMARY KEY  (id),
	KEY uid (uid),
	KEY nid_status (nid,status)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {node_media} (
        id SERIAL PRIMARY KEY,
        nid integer NOT NULL default '0',
        uid integer NOT NULL default '0',
        filename varchar(255) NOT NULL default '',
        filepath varchar(255) NOT NULL default '',
        filemime varchar(255) NOT NULL default '',
        filesize integer NOT NULL default '0',
        thumbpath varchar(255) NOT NULL default '',
        thumbsize integer NOT NULL default '0',
        status smallint NOT NULL default '1',
        weight smallint NOT NULL default '0',
        description varchar(255) default NULL
      )");
      db_query("CREATE INDEX {node_media}_uid ON {node_media} (uid)");
      db_query("CREATE INDEX {node_media}_nid_status ON {node_media} (nid,status)");
      break;
  }
}

function node_media_update_1() {
  $names = node_get_types('names');
  foreach ($names as $key => $name) {
    if ($result = variable_get('node_media_'. $key, '')) {
      variable_set('node_media_position_'. $key, $result);
      variable_del('node_media_'. $key);
    }
  }
  return array();
}
1	<?php
2	/**
3	* Implementation of hook_install().
4	*/
5	function node_media_install() {
6	switch ($GLOBALS['db_type']) {
7	case 'mysql':
8	case 'mysqli':
9	db_query("CREATE TABLE {node_media} (
10	id int(10) unsigned NOT NULL auto_increment,
11	nid int(10) unsigned NOT NULL default '0',
12	uid int(10) unsigned NOT NULL default '0',
13	filename varchar(255) NOT NULL default '',
14	filepath varchar(255) NOT NULL default '',
15	filemime varchar(255) NOT NULL default '',
16	filesize int(10) unsigned NOT NULL default '0',
17	thumbpath varchar(255) NOT NULL default '',
18	thumbsize int(10) unsigned NOT NULL default '0',
19	status tinyint(1) unsigned NOT NULL default '1',
20	weight tinyint(1) NOT NULL default '0',
21	description varchar(255) default NULL,
22	type tinyint(1) unsigned NOT NULL default '0',
23	PRIMARY KEY (id),
24	KEY uid (uid),
25	KEY nid_status (nid,status)
26	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
27	break;
28
29	case 'pgsql':
30	db_query("CREATE TABLE {node_media} (
31	id SERIAL PRIMARY KEY,
32	nid integer NOT NULL default '0',
33	uid integer NOT NULL default '0',
34	filename varchar(255) NOT NULL default '',
35	filepath varchar(255) NOT NULL default '',
36	filemime varchar(255) NOT NULL default '',
37	filesize integer NOT NULL default '0',
38	thumbpath varchar(255) NOT NULL default '',
39	thumbsize integer NOT NULL default '0',
40	status smallint NOT NULL default '1',
41	weight smallint NOT NULL default '0',
42	description varchar(255) default NULL
43	)");
44	db_query("CREATE INDEX {node_media}_uid ON {node_media} (uid)");
45	db_query("CREATE INDEX {node_media}_nid_status ON {node_media} (nid,status)");
46	break;
47	}
48	}
49
50	function node_media_update_1() {
51	$names = node_get_types('names');
52	foreach ($names as $key => $name) {
53	if ($result = variable_get('node_media_'. $key, '')) {
54	variable_set('node_media_position_'. $key, $result);
55	variable_del('node_media_'. $key);
56	}
57	}
58	return array();
59	}