modules/monument/monument.install

<?php

/** 
 * Implementation of hook_install().
 */
function monument_install() {
	switch ($GLOBALS['db_type']) {
		case 'mysqli':
		case 'mysql':
			db_query("CREATE TABLE {monument} (
				nid int(10) unsigned NOT NULL default '0',
  				monumentID bigint(3) unsigned zerofill NOT NULL auto_increment,
  				catalogue int(11) NOT NULL default '0',
  				alt_names varchar(255) character set utf8 default NULL COMMENT 'Any alternative names for this monument',
  				SAT_PRN int(11) NOT NULL default '0',
  				RCAMS_orig smallint(6) default NULL,
  				RCAHMS_NMR varchar(12) character set utf8 default NULL,
  				HS_monnum int(11) default NULL,
  				district varchar(30) collate utf8_unicode_ci default NULL,
  				mapsheet varchar(4) collate utf8_unicode_ci default NULL,
  				gridref int(8) default '0',
  				original_diameter_metre float default NULL,
  				last_visited int(11) default NULL COMMENT 'Date last visited as UNIX timestamp',
  				PRIMARY KEY  (monumentID),
  				UNIQUE KEY catalogue (catalogue),
  				UNIQUE KEY SAT_PRN (SAT_PRN)
  			) /*!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_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'mysqli':
9	case 'mysql':
10	db_query("CREATE TABLE {monument} (
11	nid int(10) unsigned NOT NULL default '0',
12	monumentID bigint(3) unsigned zerofill NOT NULL auto_increment,
13	catalogue int(11) NOT NULL default '0',
14	alt_names varchar(255) character set utf8 default NULL COMMENT 'Any alternative names for this monument',
15	SAT_PRN int(11) NOT NULL default '0',
16	RCAMS_orig smallint(6) default NULL,
17	RCAHMS_NMR varchar(12) character set utf8 default NULL,
18	HS_monnum int(11) default NULL,
19	district varchar(30) collate utf8_unicode_ci default NULL,
20	mapsheet varchar(4) collate utf8_unicode_ci default NULL,
21	gridref int(8) default '0',
22	original_diameter_metre float default NULL,
23	last_visited int(11) default NULL COMMENT 'Date last visited as UNIX timestamp',
24	PRIMARY KEY (monumentID),
25	UNIQUE KEY catalogue (catalogue),
26	UNIQUE KEY SAT_PRN (SAT_PRN)
27	) /!40100 DEFAULT CHARACTER SET utf8 /;");
28	break;
29
30	case 'pgsql':
31	die("No PostgreSQL installer. Please contribute one");
32	break;
33	}
34	}
35