modules/views_fusion/views_fusion.install

<?php
// $Id: views_fusion.install,v 1.2 2006/11/19 15:35:59 fago Exp $

function views_fusion_install() {

  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':     
      db_query("CREATE TABLE if not exists {views_fusion} (
        vid int(10) unsigned NOT NULL,
        mvid int(10) unsigned NOT NULL,
        uses varchar(32) NOT NULL,
        PRIMARY KEY(vid,mvid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {views_fusion} (
        vid integer NOT NULL,
        mvid integer NOT NULL,
        uses varchar(32) NOT NULL,
        PRIMARY KEY(vid,mvid)
      )");
    default:
      break;
  }

}
1	<?php
2	// $Id: views_fusion.install,v 1.2 2006/11/19 15:35:59 fago Exp $
3
4	function views_fusion_install() {
5
6	switch ($GLOBALS['db_type']) {
7	case 'mysqli':
8	case 'mysql':
9	db_query("CREATE TABLE if not exists {views_fusion} (
10	vid int(10) unsigned NOT NULL,
11	mvid int(10) unsigned NOT NULL,
12	uses varchar(32) NOT NULL,
13	PRIMARY KEY(vid,mvid)
14	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
15	break;
16	case 'pgsql':
17	db_query("CREATE TABLE {views_fusion} (
18	vid integer NOT NULL,
19	mvid integer NOT NULL,
20	uses varchar(32) NOT NULL,
21	PRIMARY KEY(vid,mvid)
22	)");
23	default:
24	break;
25	}
26
27	}