modules/uc_promo/uc_promo.install

<?php
// $Id$

function uc_promo_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_promos} (
        promo_id int NOT NULL default 0,
        promo_name varchar(255) NOT NULL default '',
        landing_page varchar(255) NOT NULL default '',
        redeem_once smallint NOT NULL default 0,
        promo_status smallint NOT NULL default 0,
        created int NOT NULL default 0,
        PRIMARY KEY (promo_id)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_promo_codes} (
        promo_code varchar(32) NOT NULL default '',
        promo_id int NOT NULL default 0,
        promo_code_type smallint NOT NULL default 0,
        bulkgen_seed varchar(128) NOT NULL default '',
        redemptions int NOT NULL default 0,
        max_redemptions int NOT NULL default 0,
        expiration int NOT NULL default 0,
        created int NOT NULL default 0,
        last_redemption int NOT NULL default 0,
        PRIMARY KEY (promo_code),
        INDEX promo_id (promo_id)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_promo_code_redemptions} (
        redemption_id int NOT NULL default 0,
        promo_code varchar(32) NOT NULL default '',
        bulk_code varchar(30) NOT NULL default '',
        promo_id int NOT NULL default 0,
        uid int NOT NULL default 0,
        redeemed int NOT NULL default 0,
        INDEX promo_code (promo_code)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
    break;
  }
}

function uc_promo_uninstall() {
  db_query("DROP TABLE {uc_promos}");
  db_query("DROP TABLE {uc_promo_codes}");
  db_query("DROP TABLE {uc_promo_code_redemptions}");
}
1	<?php
2	// $Id$
3
4	function uc_promo_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {uc_promos} (
9	promo_id int NOT NULL default 0,
10	promo_name varchar(255) NOT NULL default '',
11	landing_page varchar(255) NOT NULL default '',
12	redeem_once smallint NOT NULL default 0,
13	promo_status smallint NOT NULL default 0,
14	created int NOT NULL default 0,
15	PRIMARY KEY (promo_id)
16	) /!40100 DEFAULT CHARACTER SET UTF8 / ;");
17	db_query("CREATE TABLE {uc_promo_codes} (
18	promo_code varchar(32) NOT NULL default '',
19	promo_id int NOT NULL default 0,
20	promo_code_type smallint NOT NULL default 0,
21	bulkgen_seed varchar(128) NOT NULL default '',
22	redemptions int NOT NULL default 0,
23	max_redemptions int NOT NULL default 0,
24	expiration int NOT NULL default 0,
25	created int NOT NULL default 0,
26	last_redemption int NOT NULL default 0,
27	PRIMARY KEY (promo_code),
28	INDEX promo_id (promo_id)
29	) /!40100 DEFAULT CHARACTER SET UTF8 / ;");
30	db_query("CREATE TABLE {uc_promo_code_redemptions} (
31	redemption_id int NOT NULL default 0,
32	promo_code varchar(32) NOT NULL default '',
33	bulk_code varchar(30) NOT NULL default '',
34	promo_id int NOT NULL default 0,
35	uid int NOT NULL default 0,
36	redeemed int NOT NULL default 0,
37	INDEX promo_code (promo_code)
38	) /!40100 DEFAULT CHARACTER SET UTF8 / ;");
39	break;
40	}
41	}
42
43	function uc_promo_uninstall() {
44	db_query("DROP TABLE {uc_promos}");
45	db_query("DROP TABLE {uc_promo_codes}");
46	db_query("DROP TABLE {uc_promo_code_redemptions}");
47	}