ubercart/uc_cart_links/uc_cart_links.install

<?php
// $Id$

function uc_cart_links_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_cart_link_clicks} (
        cart_link_id varchar(32) NOT NULL default '0',
        clicks int(10) NOT NULL default '0',
        last_click int(10) NOT NULL default '0',
        PRIMARY KEY cart_link_id (cart_link_id)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_cart_link_clicks} (
        cart_link_id varchar(32) NOT NULL default 0,
        clicks integer NOT NULL default 0,
        last_click integer NOT NULL default 0,
        PRIMARY KEY (cart_link_id)
      )");
      db_query("CREATE INDEX {uc_cart_link_clicks}_cart_link_id ON {uc_cart_link_clicks} (cart_link_id)");
      break;
  }
}

function uc_cart_links_uninstall() {
  db_query("DROP TABLE {uc_cart_link_clicks}");
  db_query("DELETE FROM {variable} WHERE name LIKE 'uc_cart_links_%%'");
  cache_clear_all('variables', 'cache');
}
1	<?php
2	// $Id$
3
4	function uc_cart_links_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysql':
7	case 'mysqli':
8	db_query("CREATE TABLE {uc_cart_link_clicks} (
9	cart_link_id varchar(32) NOT NULL default '0',
10	clicks int(10) NOT NULL default '0',
11	last_click int(10) NOT NULL default '0',
12	PRIMARY KEY cart_link_id (cart_link_id)
13	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
14	break;
15	case 'pgsql':
16	db_query("CREATE TABLE {uc_cart_link_clicks} (
17	cart_link_id varchar(32) NOT NULL default 0,
18	clicks integer NOT NULL default 0,
19	last_click integer NOT NULL default 0,
20	PRIMARY KEY (cart_link_id)
21	)");
22	db_query("CREATE INDEX {uc_cart_link_clicks}_cart_link_id ON {uc_cart_link_clicks} (cart_link_id)");
23	break;
24	}
25	}
26
27	function uc_cart_links_uninstall() {
28	db_query("DROP TABLE {uc_cart_link_clicks}");
29	db_query("DELETE FROM {variable} WHERE name LIKE 'uc_cart_links_%%'");
30	cache_clear_all('variables', 'cache');
31	}