modules/ilovethis/ilovethis.install

<?php
// $Id: 

/**
 * Implementation of hook_install().
 */
function ilovethis_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $result = db_query("CREATE TABLE ilovethis  (
          nid     INT NOT NULL,
          uid     INT NOT NULL,
          last    INT,
          PRIMARY KEY (nid, uid)
          ) Type=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;
        ");
      break;
    case 'pgsql':
      // TODO: need this
      break;
  }

  if ($result) {
    drupal_set_message(t('ilovethis module database tables created successfully.'));
  } else {
    drupal_set_message(t('ilovethis module database table creation failure. Please view the ilovethis module folder and read the README.txt'), 'error');
  }
}

/**
 * Implementation of hook_uninstall().
 */
function ilovethis_uninstall() {
  db_query('DROP TABLE {ilovethis}');
  // TODO: need to handle this.
  //db_query("DELETE FROM {variable} WHERE name LIKE '%ilovethis%'");
}
1	<?php
2	// $Id:
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function ilovethis_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	$result = db_query("CREATE TABLE ilovethis (
12	nid INT NOT NULL,
13	uid INT NOT NULL,
14	last INT,
15	PRIMARY KEY (nid, uid)
16	) Type=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;
17	");
18	break;
19	case 'pgsql':
20	// TODO: need this
21	break;
22	}
23
24	if ($result) {
25	drupal_set_message(t('ilovethis module database tables created successfully.'));
26	} else {
27	drupal_set_message(t('ilovethis module database table creation failure. Please view the ilovethis module folder and read the README.txt'), 'error');
28	}
29	}
30
31	/**
32	* Implementation of hook_uninstall().
33	*/
34	function ilovethis_uninstall() {
35	db_query('DROP TABLE {ilovethis}');
36	// TODO: need to handle this.
37	//db_query("DELETE FROM {variable} WHERE name LIKE '%ilovethis%'");
38	}