ubercart/uc_stock/uc_stock.install

<?php
// $Id$

function uc_stock_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("CREATE TABLE {uc_product_stock} (
        `sku` varchar(255) NOT NULL,
        `nid` mediumint(9) NOT NULL,
        `active` tinyint(2) NOT NULL default 0,
        `stock` mediumint(11) NOT NULL default 0,
        `threshold` mediumint(11) NOT NULL default 0,
        PRIMARY KEY (`sku`),
        KEY nid (nid)
      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_product_stock} (
        sku varchar(255) NOT NULL default '',
        nid integer NOT NULL default 0,
        active smallint NOT NULL default 0,
        stock integer NOT NULL default 0,
        threshold integer NOT NULL default 0,
        PRIMARY KEY (sku)
      );");
      db_query("CREATE INDEX {uc_product_stock}_nid ON {uc_product_stock} (nid)");
      break;
  }
}

function uc_stock_uninstall() {
  switch ($GLOBALS['db_type']) {
    case 'mysqli':
    case 'mysql':
      db_query("DROP TABLE IF EXISTS {uc_product_stock}");
      break;
  case 'pgsql':
      db_query("DROP TABLE {uc_product_stock}");
      break;
  }
}
1	<?php
2	// $Id$
3
4	function uc_stock_install() {
5	switch ($GLOBALS['db_type']) {
6	case 'mysqli':
7	case 'mysql':
8	db_query("CREATE TABLE {uc_product_stock} (
9	`sku` varchar(255) NOT NULL,
10	`nid` mediumint(9) NOT NULL,
11	`active` tinyint(2) NOT NULL default 0,
12	`stock` mediumint(11) NOT NULL default 0,
13	`threshold` mediumint(11) NOT NULL default 0,
14	PRIMARY KEY (`sku`),
15	KEY nid (nid)
16	) /!40100 DEFAULT CHARACTER SET UTF8 / ");
17	break;
18	case 'pgsql':
19	db_query("CREATE TABLE {uc_product_stock} (
20	sku varchar(255) NOT NULL default '',
21	nid integer NOT NULL default 0,
22	active smallint NOT NULL default 0,
23	stock integer NOT NULL default 0,
24	threshold integer NOT NULL default 0,
25	PRIMARY KEY (sku)
26	);");
27	db_query("CREATE INDEX {uc_product_stock}_nid ON {uc_product_stock} (nid)");
28	break;
29	}
30	}
31
32	function uc_stock_uninstall() {
33	switch ($GLOBALS['db_type']) {
34	case 'mysqli':
35	case 'mysql':
36	db_query("DROP TABLE IF EXISTS {uc_product_stock}");
37	break;
38	case 'pgsql':
39	db_query("DROP TABLE {uc_product_stock}");
40	break;
41	}
42	}