package DB::Test::LocationAdmin;
use strict;
use warnings;
use parent 'DB::Test';

sub location {
"CREATE TABLE location (
  locID INTEGER PRIMARY KEY,
  isle,
  line,
  row,
  position,
  type,
  size,
  mixed,
  dynamic,
  active,
  locFunctionID,
  warehouseID,
  warehouseZoneID,
  sortOrder,
  estimate
)"
}

sub productAltLocation {
"CREATE TABLE productAltLocation ( 
  productID INTEGER PRIMARY KEY,
  locID,
  qty,
  dtAssigned,
  dtUpdated
)"   
}

sub product {
"CREATE TABLE product ( 
  productID INTEGER PRIMARY KEY,
  partnumber,
  stat_date,
  date_modified,
  previous_stockstatus,
  APRTune,
  autoprint,
  avg_90day,
  avg_qty,
  brakekit,
  brandID,
  country_origin,
  cust_max_qty,
  date_added,
  default_price_retail,
  description,
  discontinueUnitMatch,
  discontinueUnits,
  donotstock,
  featured,
  groupPricing,
  harmonizedCode,
  imageURL,
  isService,
  loc_method,
  loc_size,
  loc_type,
  locID,
  mainedoc,
  mainimage,
  manufacturerPartNumber,
  newPics,
  newrslmin,
  newrslmax,
  nla,
  nlaUnitMatch,
  nlaUnits,
  noCancelReturn,
  noindividual,
  noSplash,
  rsl_max,
  rsl_min,
  rslLastModified,
  rslOutOfDate,
  scratchdent,
  stockstatus,
  supersession_productID,
  lastSupersessionProductID,
  taxExempt,
  thumbURL,
  Type,
  ts,
  UPCCode,
  vendor_override,
  stat_cur,
  bagging,
  title,
  seName,
  purpose,
  qiRequired,
  recentIndividualSales,
  xoNumber,
  xoType,
  popCode,
  poLead,
  active,
  vendorETA,
  costSpecial,
  costSpecialExpireDate,
  ruleOverride,
  vendorPartNumber
)"   
}

sub productDescription {
"CREATE TABLE productDescription ( 
  productID INTEGER PRIMARY KEY,
  poDescription,
  description2,
  descriptionlong,
  globalAppDescription,
  homeNewsAppDescription,
  tsModified
)"   
}

sub productDimension {
"CREATE TABLE productDimension ( 
  productID INTEGER PRIMARY KEY,
  weight,
  length,
  width,
  height,
  dimSize,
  dimSet,
  dtModified
)"   
}

sub productShippingDimension {
"CREATE TABLE productShippingDimension ( 
  productID INTEGER PRIMARY KEY,
  weight,
  length,
  width,
  height,
  dtModified,
  dropship,
  multiBox
)"   
}

sub productStocking {
"CREATE TABLE productStocking ( 
  productID INTEGER PRIMARY KEY,
  wwwLead,maxStockDay,rslMinManual,rslMaxManual,rslManualDateIn,rslManualExpDays,activeStockingRuleID,rslType,targetStockQty,  targetOverstockQty,receiveToOverstock,storeOffsite,tsModified
)"   
}

sub productStock {
"CREATE TABLE productStock ( 
  productID INTEGER PRIMARY KEY,
  onHand,onOrder,onRma,lastCost,cost,tsModified
)"   
}

sub productResource {
"CREATE TABLE productResource ( 
  productID INTEGER PRIMARY KEY,
  resourceID,tsModified
)"   
}

sub productReviewSummary {
"CREATE TABLE productReviewSummary ( 
  productID INTEGER PRIMARY KEY,
  ratingCount,ratingAverage,recommendCount,fitCount,fitAverage,installTimeCount,installTimeAverage,installCostCount,installCostAverage
)"   
}
sub productCategoryInfo {
"CREATE TABLE productCategoryInfo ( 
  productID INTEGER PRIMARY KEY,
  categoryInfoID
)"   
}

sub productFreeShipEligible {
"CREATE TABLE productFreeShipEligible ( 
  productID INTEGER PRIMARY KEY,
  freeShipEligible
)"   
}
sub rniProduct {
"CREATE TABLE rniProduct ( 
  rniProductID INTEGER PRIMARY KEY,
  productID,poItemID,qtyReceived 
)"   
}
sub sdsLatest {
"CREATE TABLE sdsLatest ( 
  productID INTEGER PRIMARY KEY,
  sdsLogID
)"   
}
sub sdsLog {
"CREATE TABLE sdsLog ( 
  sdsLogID INTEGER PRIMARY KEY,
  productID,curStage,curRetail,ts
)"   
}
sub pdkRef {
"CREATE TABLE pdkRef ( 
  pdkRefID INTEGER PRIMARY KEY,
  pdkProductID,kitProductID
)"   
}
sub productVendor {
"CREATE TABLE productVendor ( 
  productID INTEGER PRIMARY KEY,
  vendorID,currentVendor
)"   
}
sub locationChangeLog {
"CREATE TABLE locationChangeLog ( 
  locationChangeLogID INTEGER PRIMARY KEY,
  locID,locationName,logType,newValue,employeeName,ts    
)"   
}

1;
