modules/recommended_nodes/recommended_nodes.install

<?php
// $Id: recommended_nodes.install,v 1.1 2006/05/04 20:20:09 drumm Exp $

function recommended_nodes_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
      db_query('CREATE TABLE {recommended_nodes_recommendations} (
        nid int(10) unsigned NOT NULL,
        uid int(10) unsigned NOT NULL,
        PRIMARY KEY (nid, uid)
      )');
      db_query('CREATE TABLE {recommended_nodes_node} (
        nid int(10) unsigned NOT NULL,
        score decimal(6,3) unsigned NOT NULL,
        PRIMARY KEY (nid),
        INDEX (score)
      )');
  }
}
1	<?php
2	// $Id: recommended_nodes.install,v 1.1 2006/05/04 20:20:09 drumm Exp $
3
4	function recommended_nodes_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	db_query('CREATE TABLE {recommended_nodes_recommendations} (
8	nid int(10) unsigned NOT NULL,
9	uid int(10) unsigned NOT NULL,
10	PRIMARY KEY (nid, uid)
11	)');
12	db_query('CREATE TABLE {recommended_nodes_node} (
13	nid int(10) unsigned NOT NULL,
14	score decimal(6,3) unsigned NOT NULL,
15	PRIMARY KEY (nid),
16	INDEX (score)
17	)');
18	}
19	}