Home › API reference

Definition

address_install()
ecommerce-5--4/address/address.install, line 13

Description

e-Commerce address module schema

Code

<?php
function address_install() {
  $table_config = '';
  $serial = 'SERIAL';

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

  db_query('CREATE TABLE {ec_address} (
    aid       '. $serial .' PRIMARY KEY,
    uid       INTEGER     NOT NULL,
    firstname VARCHAR(32) NOT NULL,
    lastname  VARCHAR(32) NOT NULL,
    street1   VARCHAR(64) NOT NULL,
    street2   VARCHAR(64),
    zip       VARCHAR(10) NOT NULL,
    city      VARCHAR(32) NOT NULL,
    state     VARCHAR(32) DEFAULT NULL,
    country   VARCHAR(2)  NOT NULL,
    phone     VARCHAR(64)
  )'. $table_config);
}
?>