You are here

uc_price_per_role.install in Ubercart Price Per Role 5

Same filename and directory in other branches
  1. 6 uc_price_per_role.install
  2. 7 uc_price_per_role.install

File

uc_price_per_role.install
View source
<?php

/**
 * Implementation of hook_install().
 */
function uc_price_per_role_install() {
  db_query("CREATE TABLE {uc_price_per_role_prices} (\n    `rpid` mediumint(9) NOT NULL default 0,\n    `vid` mediumint(9) NOT NULL default 0,\n    `nid` mediumint(9) NOT NULL default 0,\n    `rid` mediumint(9) NOT NULL default 0,\n    `price` decimal(10,2) NOT NULL default 0.00,\n    PRIMARY KEY  (`rpid`)\n  );");
  db_query("CREATE TABLE {uc_price_per_role_option_prices} (\n    `opid` mediumint(9) NOT NULL default 0,\n    `nid` mediumint(9) NOT NULL default 0,\n    `oid` mediumint(9) NOT NULL default 0,\n    `rid` mediumint(9) NOT NULL default 0,\n    `price` decimal(10,2) NOT NULL default 0.00,\n    PRIMARY KEY  (`opid`)\n  );");
}

/**
 * Implementation of hook_uninstall().
 */
function uc_price_per_role_uninstall() {
  db_query("DROP TABLE {uc_price_per_role_prices}");
}
function uc_price_per_role_update_1() {
  $ret[] = update_sql("CREATE TABLE {uc_price_per_role_option_prices} (\n    `opid` mediumint(9) NOT NULL default 0,\n    `nid` mediumint(9) NOT NULL default 0,\n    `oid` mediumint(9) NOT NULL default 0,\n    `rid` mediumint(9) NOT NULL default 0,\n    `price` decimal(10,2) NOT NULL default 0.00,\n    PRIMARY KEY  (`opid`)\n  )");
  return $ret;
}