[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3  $Id: database_tables.php 3 2006-05-27 04:59:07Z user $

   4  

   5    osCMax Power E-Commerce

   6    http://oscdox.com

   7  

   8    Copyright 2006 osCMax

   9  

  10    Released under the GNU General Public License

  11  */
  12  
  13  // define the database table names used in the project

  14    define('TABLE_ADDRESS_BOOK', 'address_book');
  15    define('TABLE_ADDRESS_FORMAT', 'address_format');
  16  // Line added: Mod RC2A

  17    define('TABLE_ADMINISTRATORS', 'admin');
  18  // BOF: MOD - Article Manager

  19    define('TABLE_ARTICLE_REVIEWS', 'article_reviews');
  20    define('TABLE_ARTICLE_REVIEWS_DESCRIPTION', 'article_reviews_description');
  21    define('TABLE_ARTICLES', 'articles');
  22    define('TABLE_ARTICLES_DESCRIPTION', 'articles_description');
  23    define('TABLE_ARTICLES_TO_TOPICS', 'articles_to_topics');
  24    define('TABLE_ARTICLES_XSELL', 'articles_xsell');
  25    define('TABLE_AUTHORS', 'authors');
  26    define('TABLE_AUTHORS_INFO', 'authors_info');
  27  // EOF: MOD - Article Manager

  28    define('TABLE_BANNERS', 'banners');
  29    define('TABLE_BANNERS_HISTORY', 'banners_history');
  30    define('TABLE_CATEGORIES', 'categories');
  31    define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');
  32    define('TABLE_CONFIGURATION', 'configuration');
  33    define('TABLE_CONFIGURATION_GROUP', 'configuration_group');
  34    define('TABLE_COUNTER', 'counter');
  35    define('TABLE_COUNTER_HISTORY', 'counter_history');
  36    define('TABLE_COUNTRIES', 'countries');
  37    define('TABLE_CURRENCIES', 'currencies');
  38    define('TABLE_CUSTOMERS', 'customers');
  39    define('TABLE_CUSTOMERS_BASKET', 'customers_basket');
  40    define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');
  41    define('TABLE_CUSTOMERS_INFO', 'customers_info');
  42    define('TABLE_LANGUAGES', 'languages');
  43    define('TABLE_MANUFACTURERS', 'manufacturers');
  44    define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');
  45    define('TABLE_ORDERS', 'orders');
  46    define('TABLE_ORDERS_PRODUCTS', 'orders_products');
  47    define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');
  48    define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');
  49    define('TABLE_ORDERS_STATUS', 'orders_status');
  50    define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');
  51    define('TABLE_ORDERS_TOTAL', 'orders_total');
  52    define('TABLE_PRODUCTS', 'products');
  53    define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');
  54    define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');
  55    define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');
  56    define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');
  57    define('TABLE_PRODUCTS_OPTIONS', 'products_options');
  58    define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');
  59    define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');
  60    define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');
  61    define('TABLE_REVIEWS', 'reviews');
  62    define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');
  63    define('TABLE_SESSIONS', 'sessions');
  64    define('TABLE_SPECIALS', 'specials');
  65    define('TABLE_TAX_CLASS', 'tax_class');
  66    define('TABLE_TAX_RATES', 'tax_rates');
  67  // LINE ADDED: MOD - BTS

  68    define('TABLE_THEME_CONFIGURATION', 'theme_configuration');
  69  // BOF: MOD - Article Manager

  70    define('TABLE_TOPICS', 'topics');
  71    define('TABLE_TOPICS_DESCRIPTION', 'topics_description');
  72  // EOF: MOD - Article Manager

  73    define('TABLE_GEO_ZONES', 'geo_zones');
  74    define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');
  75    define('TABLE_WHOS_ONLINE', 'whos_online');
  76    define('TABLE_ZONES', 'zones');
  77  // LINE ADDED: MOD - Xsell Products

  78    define('TABLE_PRODUCTS_XSELL', 'products_xsell'); 
  79  // BOF: MOD - Wish List 3.5

  80    define('TABLE_WISHLIST', 'customers_wishlist');
  81    define('TABLE_WISHLIST_ATTRIBUTES', 'customers_wishlist_attributes');
  82  // EOF: MOD - Wish List 3.5

  83  // LINE ADDED: MOD - QT Pro: Begin Changed code

  84    define('TABLE_PRODUCTS_STOCK', 'products_stock');
  85  // BOF: MOD - Separate Pricing per Customer

  86    define('TABLE_PRODUCTS_GROUPS', 'products_groups');
  87    define('TABLE_SPECIALS_RETAIL_PRICES', 'specials_retail_prices');
  88    define('TABLE_PRODUCTS_GROUP_PRICES', 'products_group_prices_cg_');
  89    define('TABLE_CUSTOMERS_GROUPS', 'customers_groups');
  90    // this will define the maximum time in minutes between updates of a products_group_prices_cg_# table

  91    // changes in table specials will trigger an immediate update if a query needs this particular table

  92    define('MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE', '15');
  93  // EOF: MOD - Separate Pricing per Customer

  94  
  95  // LINE ADDED

  96    define('TABLE_PACKAGING', 'packaging');
  97    define('TABLE_UPS_BOXES_USED', 'ups_boxes_used');
  98  ?>