modules/referral_links/referral_links.install

<?php
// $Id: referral_links.install,v 1.1 2007/04/11 20:37:37 stevemckenzie Exp $

/**
 *  Implementation of hook_install().
 */
function referral_links_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $result1 = db_query(
      "CREATE TABLE {referral_links_sites} (
          rid INT NOT NULL,
          domain VARCHAR(250) NOT NULL,
          uid INT NOT NULL,
          added INT NOT NULL,
          total INT NOT NULL,
          INDEX (domain, uid, added, total),
          UNIQUE (rid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
      );
      $result2 = db_query(
      "CREATE TABLE {referral_links_signups} (
          sid INT NOT NULL,
          rid INT NOT NULL,
          uid INT NOT NULL,
          added INT NOT NULL,
          INDEX (rid, uid, added),
          UNIQUE (sid)
        ) /*!40100 DEFAULT CHARACTER SET utf8 */;"
      );
      
      if ($result1 && $result2) {
      	drupal_set_message(t('The Referral Links module has been installed.'));
      } else {
      	drupal_set_message(t('The Referral Links module had a problem configuring the database for its needs. This module will not work properly under these conditions.'), 'error');
      }
      break;
  }
}
1	<?php
2	// $Id: referral_links.install,v 1.1 2007/04/11 20:37:37 stevemckenzie Exp $
3
4	/**
5	* Implementation of hook_install().
6	*/
7	function referral_links_install() {
8	switch ($GLOBALS['db_type']) {
9	case 'mysql':
10	case 'mysqli':
11	$result1 = db_query(
12	"CREATE TABLE {referral_links_sites} (
13	rid INT NOT NULL,
14	domain VARCHAR(250) NOT NULL,
15	uid INT NOT NULL,
16	added INT NOT NULL,
17	total INT NOT NULL,
18	INDEX (domain, uid, added, total),
19	UNIQUE (rid)
20	) /!40100 DEFAULT CHARACTER SET utf8 /;"
21	);
22	$result2 = db_query(
23	"CREATE TABLE {referral_links_signups} (
24	sid INT NOT NULL,
25	rid INT NOT NULL,
26	uid INT NOT NULL,
27	added INT NOT NULL,
28	INDEX (rid, uid, added),
29	UNIQUE (sid)
30	) /!40100 DEFAULT CHARACTER SET utf8 /;"
31	);
32
33	if ($result1 && $result2) {
34	drupal_set_message(t('The Referral Links module has been installed.'));
35	} else {
36	drupal_set_message(t('The Referral Links module had a problem configuring the database for its needs. This module will not work properly under these conditions.'), 'error');
37	}
38	break;
39	}
40	}