modules/promotion/promotion.install

<?php
// $Id$

function promotion_install() {
  switch ($GLOBALS['db_type']) {
  case 'mysql':
  case 'mysqli':
    db_query("CREATE TABLE {promotion_codes} (
      pid int unsigned NOT NULL default '0',
      name varchar(128) NOT NULL,
      description text NULL,
      active_promotion int(1) NOT NULL default '1',
      start_date int NULL,
      end_date int NULL,
      activate_when int(1) unsigned NOT NULL default '1',
      activation_date int NULL,
      accounts_expire int(1) unsigned NOT NULL default '0',
      expiration_date int NULL,
      expiration_action int(1) unsigned NOT NULL default '0',
      code_type int(1) unsigned NOT NULL default '0',
      simple_code varchar(30) NOT NULL default '',
      advanced_validator text NULL,
      max_use_count int unsigned NULL,
      bypass_verification int(1) unsigned NOT NULL default '0',
      bypass_administrator int(1) unsigned NOT NULL default '0',
      linked_code int(1) unsigned NOT NULL default '0',
      code_link varchar(150) NULL,
      PRIMARY KEY (pid),
      UNIQUE (name)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

    db_query("CREATE TABLE {promotion_codes_roles} (
      pid int unsigned NOT NULL default '0',
      rid int unsigned NOT NULL default '0',
      promotion int(1) unsigned NOT NULL default '0',
      PRIMARY KEY (pid, rid, promotion)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

    db_query("CREATE TABLE {promotion_codes_users} (
      pid int unsigned NOT NULL default '0',
      uid int unsigned NOT NULL default '0',
      code_used varchar(30) NOT NULL default '',
      status int(1) unsigned NOT NULL default '0',
      PRIMARY KEY (pid, uid)
    ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
    break;
  }
}

function promotion_update_1() {
  $items = array();
  switch ($GLOBALS['db_type']) {
  case 'mysql':
  case 'mysqli':
    $items[] = update_sql("ALTER TABLE {promotion_codes_users} 
      ADD status int(1) unsigned NOT NULL default '0';");

    // Up to this point, accounts were instantly activated and never expired,
    // so it's safe to make all accounts active.
    $items[] = update_sql("
      UPDATE {promotion_codes_users}
      SET status = 1
    ");
    break;
  }

  return $items;
}

function promotion_update_2() {
  $items = array();
  switch ($GLOBALS['db_type']) {
  case 'mysql':
  case 'mysqli':
    $items[] = update_sql("ALTER TABLE {promotion_codes}
      ADD activate_when int(1) unsigned NOT NULL default '1';");

    $items[] = update_sql("ALTER TABLE {promotion_codes}
      ADD activation_date int NULL;");

    break;
  }
  return $items;
}

?>
1	<?php
2	// $Id$
3
4	function promotion_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {promotion_codes} (
9	pid int unsigned NOT NULL default '0',
10	name varchar(128) NOT NULL,
11	description text NULL,
12	active_promotion int(1) NOT NULL default '1',
13	start_date int NULL,
14	end_date int NULL,
15	activate_when int(1) unsigned NOT NULL default '1',
16	activation_date int NULL,
17	accounts_expire int(1) unsigned NOT NULL default '0',
18	expiration_date int NULL,
19	expiration_action int(1) unsigned NOT NULL default '0',
20	code_type int(1) unsigned NOT NULL default '0',
21	simple_code varchar(30) NOT NULL default '',
22	advanced_validator text NULL,
23	max_use_count int unsigned NULL,
24	bypass_verification int(1) unsigned NOT NULL default '0',
25	bypass_administrator int(1) unsigned NOT NULL default '0',
26	linked_code int(1) unsigned NOT NULL default '0',
27	code_link varchar(150) NULL,
28	PRIMARY KEY (pid),
29	UNIQUE (name)
30	) /!40100 DEFAULT CHARACTER SET utf8 /;");
31
32	db_query("CREATE TABLE {promotion_codes_roles} (
33	pid int unsigned NOT NULL default '0',
34	rid int unsigned NOT NULL default '0',
35	promotion int(1) unsigned NOT NULL default '0',
36	PRIMARY KEY (pid, rid, promotion)
37	) /!40100 DEFAULT CHARACTER SET utf8 /;");
38
39	db_query("CREATE TABLE {promotion_codes_users} (
40	pid int unsigned NOT NULL default '0',
41	uid int unsigned NOT NULL default '0',
42	code_used varchar(30) NOT NULL default '',
43	status int(1) unsigned NOT NULL default '0',
44	PRIMARY KEY (pid, uid)
45	) /!40100 DEFAULT CHARACTER SET utf8 /;");
46	break;
47	}
48	}
49
50	function promotion_update_1() {
51	$items = array();
52	switch ($GLOBALS['db_type']) {
53	case 'mysql':
54	case 'mysqli':
55	$items[] = update_sql("ALTER TABLE {promotion_codes_users}
56	ADD status int(1) unsigned NOT NULL default '0';");
57
58	// Up to this point, accounts were instantly activated and never expired,
59	// so it's safe to make all accounts active.
60	$items[] = update_sql("
61	UPDATE {promotion_codes_users}
62	SET status = 1
63	");
64	break;
65	}
66
67	return $items;
68	}
69
70	function promotion_update_2() {
71	$items = array();
72	switch ($GLOBALS['db_type']) {
73	case 'mysql':
74	case 'mysqli':
75	$items[] = update_sql("ALTER TABLE {promotion_codes}
76	ADD activate_when int(1) unsigned NOT NULL default '1';");
77
78	$items[] = update_sql("ALTER TABLE {promotion_codes}
79	ADD activation_date int NULL;");
80
81	break;
82	}
83	return $items;
84	}
85
86	?>