modules/patterns/patterns.install

<?php

/**
 * Implementation of hook_install().
 */
function patterns_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {patterns} (
        pid int(10) unsigned NOT NULL default '0' PRIMARY KEY,
        name varchar(55) NOT NULL default '' UNIQUE KEY,
        status int(1) unsigned NOT NULL default '0',
        file varchar(255) NOT NULL default '0',
        updated varchar(10) NOT NULL default '0',
        enabled varchar(10) NOT NULL default '0',
        title varchar(255) NOT NULL default '0',
        description text NOT NULL default '',
        pattern text NOT NULL default ''
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
    break;
  }
}
1	<?php
2
3	/**
4	* Implementation of hook_install().
5	*/
6	function patterns_install() {
7	switch ($GLOBALS['db_type']) {
8	case 'mysql':
9	case 'mysqli':
10	db_query("CREATE TABLE {patterns} (
11	pid int(10) unsigned NOT NULL default '0' PRIMARY KEY,
12	name varchar(55) NOT NULL default '' UNIQUE KEY,
13	status int(1) unsigned NOT NULL default '0',
14	file varchar(255) NOT NULL default '0',
15	updated varchar(10) NOT NULL default '0',
16	enabled varchar(10) NOT NULL default '0',
17	title varchar(255) NOT NULL default '0',
18	description text NOT NULL default '',
19	pattern text NOT NULL default ''
20	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
21	break;
22	}
23	}