function uc_payment_pack_install in Ubercart 5

Same name and namespace in other branches

1. 6.2 payment/uc_payment_pack/uc_payment_pack.install \uc_payment_pack_install()

File

payment/uc_payment_pack/uc_payment_pack.install, line 3

Code

function uc_payment_pack_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      db_query("CREATE TABLE {uc_payment_check} (\n        check_id mediumint(9) NOT NULL,\n        order_id mediumint(9) NOT NULL,\n        clear_date int(11) NOT NULL,\n        PRIMARY KEY (check_id),\n        KEY order_id (order_id)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {uc_payment_cod} (\n        order_id mediumint(9) NOT NULL,\n        delivery_month smallint(6) NOT NULL,\n        delivery_day smallint(6) NOT NULL,\n        delivery_year smallint(6) NOT NULL,\n        PRIMARY KEY (order_id)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      db_query("CREATE TABLE {uc_payment_other} (\n        order_id mediumint(9) NOT NULL,\n        description varchar(64) NOT NULL,\n        PRIMARY KEY order_id (order_id)\n      ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
      break;
    case 'pgsql':
      db_query("CREATE TABLE {uc_payment_check} (\n        check_id serial NOT NULL,\n        order_id integer NOT NULL,\n        clear_date integer NOT NULL,\n        PRIMARY KEY (check_id)\n      );");
      db_query("CREATE INDEX {uc_payment_check}_order_id ON {uc_payment_check} (order_id)");
      db_query("CREATE TABLE {uc_payment_cod} (\n        order_id integer NOT NULL,\n        delivery_month smallint NOT NULL,\n        delivery_day smallint NOT NULL,\n        delivery_year smallint NOT NULL,\n        PRIMARY KEY (order_id)\n      );");
      db_query("CREATE TABLE {uc_payment_other} (\n        order_id integer NOT NULL,\n        description varchar(64) NOT NULL,\n        PRIMARY KEY (order_id)\n      );");
      break;
  }
}