modules/uc_zpayment/uc_zpayment.install

<?php
// $Id$

function uc_zpayment_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_zpayment_transaction} (
        txnid int(10) unsigned NOT NULL default '0',
        amount decimal(6,2) default '0.00',
        description text,
        PRIMARY KEY (txnid)
      ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_zpayment_transaction} (
        txnid integer NOT NULL default '0',
        amount decimal(10,2) unsigned NOT NULL default '0',
        description longtext,
        PRIMARY KEY (txnid)
      )");
      break;
  }
  
  drupal_set_message(t('Ubercart: zpayment tables have been created.'));
}
function uc_zpayment_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $deleted = db_query("DROP TABLE IF EXISTS {uc_zpayment_transaction}");
      break;

    case 'pgsql':
      $deleted = db_query('DROP TABLE {uc_zpayment_transaction}');
      break;
  }
}

1	<?php
2	// $Id$
3
4	function uc_zpayment_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {uc_zpayment_transaction} (
9	txnid int(10) unsigned NOT NULL default '0',
10	amount decimal(6,2) default '0.00',
11	description text,
12	PRIMARY KEY (txnid)
13	) TYPE=MyISAM /!40100 DEFAULT CHARACTER SET utf8 /;");
14	break;
15	case 'pgsql':
16	db_query("CREATE TABLE {uc_zpayment_transaction} (
17	txnid integer NOT NULL default '0',
18	amount decimal(10,2) unsigned NOT NULL default '0',
19	description longtext,
20	PRIMARY KEY (txnid)
21	)");
22	break;
23	}
24
25	drupal_set_message(t('Ubercart: zpayment tables have been created.'));
26	}
27	function uc_zpayment_uninstall() {
28	switch ($GLOBALS['db_type']) {
29	case 'mysql':
30	case 'mysqli':
31	$deleted = db_query("DROP TABLE IF EXISTS {uc_zpayment_transaction}");
32	break;
33
34	case 'pgsql':
35	$deleted = db_query('DROP TABLE {uc_zpayment_transaction}');
36	break;
37	}
38	}
39