modules/phpbbPostNode/phpbbPostNode.install

<?php
// $Id: phpbbPostNode.install,v 0.0.0.1 2007/02/16 peligrorice

/**
 * Implementation of hook_install().
 * Creates a table of the variables that will be needed to use this module
 */
function phpbbPostNode_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {phpbbPostNode} (
        nid int(10) unsigned primary key,
        phpbbPostNode_topic int(11),
		phpbbPostNode_teaser varchar(128)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;
      ");
      break;

    case 'pgsql':
      db_query("CREATE TABLE {phpbbPostNode} (
        nid integer PRIMARY KEY, 
        phpbbPostNode_topic integer,
		phpbbPostNode_teaser character(128)
        );
      ");
      break;
  }
}
1	<?php
2	// $Id: phpbbPostNode.install,v 0.0.0.1 2007/02/16 peligrorice
3
4	/**
5	* Implementation of hook_install().
6	* Creates a table of the variables that will be needed to use this module
7	*/
8	function phpbbPostNode_install() {
9	switch ($GLOBALS['db_type']) {
10	case 'mysql':
11	case 'mysqli':
12	db_query("CREATE TABLE {phpbbPostNode} (
13	nid int(10) unsigned primary key,
14	phpbbPostNode_topic int(11),
15	phpbbPostNode_teaser varchar(128)
16	) /!40100 DEFAULT CHARACTER SET utf8 /;
17	");
18	break;
19
20	case 'pgsql':
21	db_query("CREATE TABLE {phpbbPostNode} (
22	nid integer PRIMARY KEY,
23	phpbbPostNode_topic integer,
24	phpbbPostNode_teaser character(128)
25	);
26	");
27	break;
28	}
29	}