scottreynolds/modules/cre.install

<?php
// $Id:$
function cre_install()
{
   switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {cre_similarity_matrix}(
        content_id1 int(10) NOT NULL DEFAULT 0,
        content_id2 int(10) NOT NULL DEFAULT 0,
        content_type1 varchar(20) default NULL,
        content_type2 varchar(20) default NULL,
        count int(10) NOT NULL DEFAULT 0,
        sum int(10) NOT NULL DEFAULT 0,
        PRIMARY KEY (content_id1, content_id2)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
       drupal_set_message(t('PGSQL is not supported'));
       return;
       break;
    }
   
   drupal_set_message(t('CRE Table created'));
   

	_cre_load_all_diff_avg();
	      
}
1	<?php
2	// $Id:$
3	function cre_install()
4	{
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {cre_similarity_matrix}(
9	content_id1 int(10) NOT NULL DEFAULT 0,
10	content_id2 int(10) NOT NULL DEFAULT 0,
11	content_type1 varchar(20) default NULL,
12	content_type2 varchar(20) default NULL,
13	count int(10) NOT NULL DEFAULT 0,
14	sum int(10) NOT NULL DEFAULT 0,
15	PRIMARY KEY (content_id1, content_id2)
16	) /!40100 DEFAULT CHARACTER SET utf8 /;");
17	break;
18	case 'pgsql':
19	drupal_set_message(t('PGSQL is not supported'));
20	return;
21	break;
22	}
23
24	drupal_set_message(t('CRE Table created'));
25
26
27	_cre_load_all_diff_avg();
28
29	}