modules/metrics/metrics.install

<?php
// $Id: metrics.install,v 1.2 2007/07/11 22:03:47 drewish Exp $

/**
 * Implementation of hook_install().
 */
function metrics_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {metrics_property} (
          property_id int unsigned NOT NULL auto_increment,
          name varchar(255) NOT NULL default '',
          description text NOT NULL,
          PRIMARY KEY (property_id)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {metrics_property_node_types} (
          property_id int unsigned NOT NULL DEFAULT '0',
          type varchar(32) NOT NULL DEFAULT '',
          PRIMARY KEY (property_id, type)
        ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");

      db_query("CREATE TABLE {metrics_property_result} (
          property_id int NOT NULL default '0',
          nid int NOT NULL default '0',
          ranking_id int unsigned NOT NULL DEFAULT '0',
          value int NOT NULL default '0',
          description text NOT NULL,
          timestamp int NOT NULL default '0',
          PRIMARY KEY (property_id, nid),
          KEY metrics_ranking_timestamp (timestamp),
          KEY metrics_ranking_value (value)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      db_query("CREATE TABLE {metrics_metric} (
          metric_id int unsigned NOT NULL auto_increment,
          property_id int unsigned NOT NULL DEFAULT '0',
          function_name varchar(255) NOT NULL default '',
          options text NOT NULL,
          displayed int default '0',
          multiplier float default '1.0',
          PRIMARY KEY (metric_id)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

// It seems like it might be a good idea to cache the results of each 
// individual metric, and then use those when computing the rows in 
// {metrics_property_result}.
#      db_query("CREATE TABLE {metrics_metric_result} (
#          property_id int NOT NULL default '0',
#          nid int NOT NULL default '0',
#          ranking_id int unsigned NOT NULL DEFAULT '0',
#          value int NOT NULL default '0',
#          description text NOT NULL,
#          timestamp int NOT NULL default '0',
#          PRIMARY KEY (property_id, nid),
#          KEY metrics_ranking_timestamp (timestamp),
#          KEY metrics_ranking_value (value)
#        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      
      db_query("CREATE TABLE {metrics_ranking} (
          ranking_id int unsigned NOT NULL auto_increment,
          property_id int NOT NULL default '0',
          name varchar(255) NOT NULL default '',
          threshold int NOT NULL default '0',
          description text NOT NULL,
          PRIMARY KEY (ranking_id)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      break;
    case 'pgsql':
      break;
  }
}

/**
 * Implementation of hook_uninstall().
 */
function metrics_uninstall() {
  db_query('DROP TABLE {metrics_property}');
  db_query('DROP TABLE {metrics_property_node_types}');
  db_query('DROP TABLE {metrics_property_result}');
  db_query('DROP TABLE {metrics_metric}');
  db_query('DROP TABLE {metrics_ranking}');
/*
  variable_del('metrics_');
*/
}
1	<?php
2	// $Id: metrics.install,v 1.2 2007/07/11 22:03:47 drewish Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function metrics_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	db_query("CREATE TABLE {metrics_property} (
12	property_id int unsigned NOT NULL auto_increment,
13	name varchar(255) NOT NULL default '',
14	description text NOT NULL,
15	PRIMARY KEY (property_id)
16	) /!40100 DEFAULT CHARACTER SET utf8 /;");
17
18	db_query("CREATE TABLE {metrics_property_node_types} (
19	property_id int unsigned NOT NULL DEFAULT '0',
20	type varchar(32) NOT NULL DEFAULT '',
21	PRIMARY KEY (property_id, type)
22	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
23
24	db_query("CREATE TABLE {metrics_property_result} (
25	property_id int NOT NULL default '0',
26	nid int NOT NULL default '0',
27	ranking_id int unsigned NOT NULL DEFAULT '0',
28	value int NOT NULL default '0',
29	description text NOT NULL,
30	timestamp int NOT NULL default '0',
31	PRIMARY KEY (property_id, nid),
32	KEY metrics_ranking_timestamp (timestamp),
33	KEY metrics_ranking_value (value)
34	) /!40100 DEFAULT CHARACTER SET utf8 /;");
35
36	db_query("CREATE TABLE {metrics_metric} (
37	metric_id int unsigned NOT NULL auto_increment,
38	property_id int unsigned NOT NULL DEFAULT '0',
39	function_name varchar(255) NOT NULL default '',
40	options text NOT NULL,
41	displayed int default '0',
42	multiplier float default '1.0',
43	PRIMARY KEY (metric_id)
44	) /!40100 DEFAULT CHARACTER SET utf8 /;");
45
46	// It seems like it might be a good idea to cache the results of each
47	// individual metric, and then use those when computing the rows in
48	// {metrics_property_result}.
49	# db_query("CREATE TABLE {metrics_metric_result} (
50	# property_id int NOT NULL default '0',
51	# nid int NOT NULL default '0',
52	# ranking_id int unsigned NOT NULL DEFAULT '0',
53	# value int NOT NULL default '0',
54	# description text NOT NULL,
55	# timestamp int NOT NULL default '0',
56	# PRIMARY KEY (property_id, nid),
57	# KEY metrics_ranking_timestamp (timestamp),
58	# KEY metrics_ranking_value (value)
59	# ) /!40100 DEFAULT CHARACTER SET utf8 /;");
60
61	db_query("CREATE TABLE {metrics_ranking} (
62	ranking_id int unsigned NOT NULL auto_increment,
63	property_id int NOT NULL default '0',
64	name varchar(255) NOT NULL default '',
65	threshold int NOT NULL default '0',
66	description text NOT NULL,
67	PRIMARY KEY (ranking_id)
68	) /!40100 DEFAULT CHARACTER SET utf8 /;");
69
70	break;
71	case 'pgsql':
72	break;
73	}
74	}
75
76	/**
77	* Implementation of hook_uninstall().
78	*/
79	function metrics_uninstall() {
80	db_query('DROP TABLE {metrics_property}');
81	db_query('DROP TABLE {metrics_property_node_types}');
82	db_query('DROP TABLE {metrics_property_result}');
83	db_query('DROP TABLE {metrics_metric}');
84	db_query('DROP TABLE {metrics_ranking}');
85	/*
86	variable_del('metrics_');
87	*/
88	}