Drupal e-Commerce

• View documentation
• List references

Definition

auction_install()
ecommerce-5--4/contrib/auction/auction.install, line 13

Description

e-Commerce auction module schema

Code

<?php
function auction_install() {
  $table_config = '';

  // Check if its using MySQL
  if ($GLOBALS['db_type'] == 'mysql' or $GLOBALS['db_type'] == 'mysqli') {
    $table_config = ' /*!40100 DEFAULT CHARACTER SET utf8 */';
  }

  db_query('CREATE TABLE {ec_product_auction} (
    nid           INTEGER       NOT NULL,
    expires       INTEGER       NOT NULL,
    reserve_price DECIMAL(10,2),
    PRIMARY KEY  (nid)
  )'. $table_config);
  db_query('CREATE TABLE {ec_auction_bid} (
    nid           INTEGER       NOT NULL,
    uid           INTEGER       NOT NULL,
    bid           DECIMAL(10,2) NOT NULL,
    created       INTEGER       NOT NULL
  )'. $table_config);
  db_query('CREATE INDEX {ec_auction_bid}_nid ON {ec_auction_bid} (nid)');
}
?>