You are here

Home » API reference » Ubercart 5 » uc_quote.install

function uc_quote_install in Ubercart 5

Same name and namespace in other branches
  1. 6.2 shipping/uc_quote/uc_quote.install \uc_quote_install()

File

shipping/uc_quote/uc_quote.install, line 3

Code

function uc_quote_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_quote_shipping_types} (\n        `id_type` varchar(127) NOT NULL ,\n        `id` mediumint(9) NOT NULL ,\n        `shipping_type` varchar(64) NOT NULL,\n        PRIMARY KEY (`id_type`, `id`)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_quote_manufacturer_locations} (\n        `tid` mediumint(9) UNSIGNED NOT NULL,\n        `first_name` varchar(255) NOT NULL,\n        `last_name` varchar(255) NOT NULL,\n        `company` varchar(255) NOT NULL,\n        `street1` varchar(255) NOT NULL,\n        `street2` varchar(255) NOT NULL,\n        `city` varchar(255) NOT NULL,\n        `zone` mediumint(11) UNSIGNED NOT NULL,\n        `postal_code` varchar(255) NOT NULL,\n        `country` mediumint(11) UNSIGNED NOT NULL,\n        `phone` varchar(255) NOT NULL,\n        PRIMARY KEY (tid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_quote_product_locations} (\n        `nid` mediumint(9) UNSIGNED NOT NULL,\n        `first_name` varchar(255) NOT NULL,\n        `last_name` varchar(255) NOT NULL,\n        `company` varchar(255) NOT NULL,\n        `street1` varchar(255) NOT NULL,\n        `street2` varchar(255) NOT NULL,\n        `city` varchar(255) NOT NULL,\n        `zone` mediumint(11) UNSIGNED NOT NULL,\n        `postal_code` varchar(255) NOT NULL,\n        `country` mediumint(11) UNSIGNED NOT NULL,\n        `phone` varchar(255) NOT NULL,\n        PRIMARY KEY (nid)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      db_query("CREATE TABLE {uc_order_quotes} (\n        `oid` mediumint(9) unsigned NOT NULL,\n        `method` varchar(25) NOT NULL,\n        `accessorials` varchar(255) NOT NULL,\n        `rate` decimal(10,2) NOT NULL,\n        `quote_form` text NOT NULL,\n        UNIQUE KEY `oid_quote_method` (`oid`,`method`)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_quote_shipping_types} (\n        id_type varchar(127) NOT NULL default '',\n        id integer NOT NULL default 0,\n        shipping_type VARCHAR( 64 ) NOT NULL default '',\n        PRIMARY KEY (id_type, id)\n      );");
      db_query("CREATE TABLE {uc_quote_manufacturer_locations} (\n        tid integer NOT NULL default 0,\n        first_name varchar(255) NOT NULL default '',\n        last_name varchar(255) NOT NULL default '',\n        company varchar(255) NOT NULL default '',\n        street1 varchar(255) NOT NULL default '',\n        street2 varchar(255) NOT NULL default '',\n        city varchar(255) NOT NULL default '',\n        zone integer NOT NULL default 0,\n        postal_code varchar(255) NOT NULL default '',\n        country integer NOT NULL default 0,\n        phone varchar(255) NOT NULL default '',\n        PRIMARY KEY (tid)\n      );");
      db_query("CREATE TABLE {uc_quote_product_locations} (\n        nid integer NOT NULL default 0,\n        first_name varchar(255) NOT NULL default '',\n        last_name varchar(255) NOT NULL default '',\n        company varchar(255) NOT NULL default '',\n        street1 varchar(255) NOT NULL default '',\n        street2 varchar(255) NOT NULL default '',\n        city varchar(255) NOT NULL default '',\n        zone integer NOT NULL default 0,\n        postal_code varchar(255) NOT NULL default '',\n        country integer NOT NULL default 0,\n        phone varchar(255) NOT NULL default '',\n        PRIMARY KEY (nid)\n      );");
      db_query("CREATE TABLE {uc_order_quotes} (\n        oid int_unsigned NOT NULL default 0,\n        method varchar(25) NOT NULL default '',\n        accessorials varchar(255) NOT NULL default '',\n        rate decimal(10,2) NOT NULL default 0.00,\n        quote_form text NOT NULL default '',\n        PRIMARY KEY (oid,method)\n      ) WITHOUT OIDS;");
      break;
  }
}