modules/monument/monument_image.install

<?php

/** 
 * Implementation of hook_install().
 */
function monument_image_install() {
	switch ($GLOBALS['db_type']) {
		case 'mysqli':
		case 'mysql':
			db_query("CREATE TABLE {monument_image} (
				nid int(10) unsigned NOT NULL default '0',
  				mid tinyint(3) unsigned zerofill NOT NULL default '000' COMMENT 'Parent monument ID',
  				taken_date int(11) unsigned default '0',
  				img_loc tinyint(3) unsigned NOT NULL default '0',
  				face_bearing smallint(3) unsigned zerofill NOT NULL default '999',
  				KEY nid (nid)
  			) /*!40100 DEFAULT CHARACTER SET utf8 */;");
  			break;
  		
  		case 'pgsql':
  			die("No PostgreSQL installer. Please contribute one");
  			break;
	}
}	
1	<?php
2
3	/**
4	* Implementation of hook_install().
5	*/
6	function monument_image_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'mysqli':
9	case 'mysql':
10	db_query("CREATE TABLE {monument_image} (
11	nid int(10) unsigned NOT NULL default '0',
12	mid tinyint(3) unsigned zerofill NOT NULL default '000' COMMENT 'Parent monument ID',
13	taken_date int(11) unsigned default '0',
14	img_loc tinyint(3) unsigned NOT NULL default '0',
15	face_bearing smallint(3) unsigned zerofill NOT NULL default '999',
16	KEY nid (nid)
17	) /!40100 DEFAULT CHARACTER SET utf8 /;");
18	break;
19
20	case 'pgsql':
21	die("No PostgreSQL installer. Please contribute one");
22	break;
23	}
24	}