uc_price_per_role.install in Ubercart Price Per Role 5
File
uc_price_per_role.install
View source
<?php
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 );");
}
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;
}