function uc_weightquote_install in Ubercart 5

Same name and namespace in other branches

1. 6.2 shipping/uc_weightquote/uc_weightquote.install \uc_weightquote_install()

File

shipping/uc_weightquote/uc_weightquote.install, line 3

Code

function uc_weightquote_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_weightquote_products} (\n        `vid` mediumint(9) unsigned NOT NULL default 0,\n        `nid` mediumint(9) unsigned NOT NULL default 0,\n        `mid` mediumint(9) unsigned NOT NULL default 0,\n        `rate` decimal(10,2) NOT NULL default 0.00,\n        PRIMARY KEY (`vid`, `mid`)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_weightquote_methods} (\n        `mid` mediumint(9) unsigned NOT NULL default 0,\n        `title` varchar(255) NOT NULL default '',\n        `label` varchar(255) NOT NULL default '',\n        `base_rate` decimal(10,2) NOT NULL default 0.00,\n        `unit_rate` decimal(10,2) NOT NULL default 0.00,\n        PRIMARY KEY (`mid`)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_weightquote_products} (\n        vid int_unsigned NOT NULL default 0,\n        nid int_unsigned NOT NULL default 0,\n        mid int_unsigned NOT NULL default 0,\n        rate decimal(10,2) NOT NULL default 0.00,\n        PRIMARY KEY (vid, mid)\n      );");
      db_query("CREATE TABLE {uc_weightquote_methods} (\n        mid serial NOT NULL,\n        title varchar(255) NOT NULL default '',\n        label varchar(255) NOT NULL default '',\n        base_rate decimal(10,2) NOT NULL default 0.00,\n        unit_rate decimal(10,2) NOT NULL default 0.00,\n        PRIMARY KEY (mid)\n      );");
      db_query("CREATE INDEX {uc_weightquote_methods}_mid_idx ON {uc_weightquote_methods}(mid)");
      break;
  }
}