modules/paypalnode/nodepromocode.install

<?php
/*
	nodepromocode_install
*/
function nodepromocode_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $r = db_query('
               CREATE TABLE IF NOT EXISTS  {nodepromocode} (
                `tid` INT( 10 ) NOT NULL ,
                `promocode` VARCHAR( 11 ) NOT NULL ,
                `discount` INT( 10 ) NOT NULL,
                PRIMARY KEY  (`tid`),
                KEY `promocode` (`promocode`)
                ) /*!40100 DEFAULT CHARACTER SET UTF8 */');

      $r = db_query('
               CREATE TABLE IF NOT EXISTS {nodepromocode_node} (
                `nid` INT( 10 ) NOT NULL ,
                `promocode` VARCHAR( 11 ) NOT NULL ,
                `discount` FLOAT NOT NULL ,
                PRIMARY KEY  (`nid`),
                KEY `promocode` (`promocode`)
                ) /*!40100 DEFAULT CHARACTER SET UTF8 */');
      break;
  }

  if($r) {
    drupal_set_message(t('NodePromoCode tables installed.'), 'status');
  }
}

function nodepromocode_uninstall() {
  db_query('DROP TABLE {nodepromocode}');
  db_query('DROP TABLE {nodepromocode_node}');
}
1	<?php
2	/*
3	nodepromocode_install
4	*/
5	function nodepromocode_install() {
6	switch ($GLOBALS['db_type']) {
7	case 'mysql':
8	case 'mysqli':
9	$r = db_query('
10	CREATE TABLE IF NOT EXISTS {nodepromocode} (
11	`tid` INT( 10 ) NOT NULL ,
12	`promocode` VARCHAR( 11 ) NOT NULL ,
13	`discount` INT( 10 ) NOT NULL,
14	PRIMARY KEY (`tid`),
15	KEY `promocode` (`promocode`)
16	) /!40100 DEFAULT CHARACTER SET UTF8 /');
17
18	$r = db_query('
19	CREATE TABLE IF NOT EXISTS {nodepromocode_node} (
20	`nid` INT( 10 ) NOT NULL ,
21	`promocode` VARCHAR( 11 ) NOT NULL ,
22	`discount` FLOAT NOT NULL ,
23	PRIMARY KEY (`nid`),
24	KEY `promocode` (`promocode`)
25	) /!40100 DEFAULT CHARACTER SET UTF8 /');
26	break;
27	}
28
29	if($r) {
30	drupal_set_message(t('NodePromoCode tables installed.'), 'status');
31	}
32	}
33
34	function nodepromocode_uninstall() {
35	db_query('DROP TABLE {nodepromocode}');
36	db_query('DROP TABLE {nodepromocode_node}');
37	}