var OPS_DB = "opsales";

var PAGE_TEXT_TBL = "caPageText";
var PAGE_TEXT_ID = "ptID";
var PAGE_TEXT_PAGE = "ptPage";
var PAGE_TEXT_KEY = "ptKey";
var PAGE_TEXT_CONTENT = "ptContent";
var PAGE_TEXT_DESCRIPTION = "ptDesc";
var PAGE_TEXT_UPDATED_BY = "ptUpdatedBy";
var PAGE_TEXT_UPDATED_DATE = "ptUpdatedDate";

var FRAME_STYLES_TBL = "framestyles";
var FRAME_ID = "frameID";
var FRAME_PROD_ID = "frameProduct";
var FRAME_NAME = "frameName";
var FRAME_ABBREV = "frameAbbrev";
var FRAME_DISPLAY_ORDER = "frameDisplayOrder";
var FRAME_SIZEA = "frameSizeA";
var FRAME_SIZEB = "frameSizeB";

var FRAME_SIZES_TBL = "framesizes";
var FRAME_SIZE_ID = "fSizeID";
var FRAME_SIZE_VAL = "fSizeVal";

var FRAME_COLORS_TBL = "framecolors";
var FRAME_COLOR_ID = "fColorID";
var FRAME_COLOR_PROD_ID = "fColorProduct";
var FRAME_COLOR_NAME = "fColorName";
var FRAME_COLOR_ABBREV = "fColorAbbrev";
var FRAME_COLOR_DISPLAY_ORDER = "fColorDisplayOrder";

var LENS_COLORS_TBL = "lenscolors";
var LENS_COLOR_ID = "lColorID";
var LENS_COLOR_PROD_ID = "lColorProduct";
var LENS_COLOR_NAME = "lColorName";
var LENS_COLOR_ABBREV = "lColorAbbrev";
var LENS_COLOR_DISPLAY_ORDER = "lColorDisplayOrder";

var LENS_POWERS_TBL = "lenspowers";
var LENS_POWER_ID = "lPowerID";
var LENS_POWER_PROD_ID = "lPowerProduct";
var LENS_POWER_NAME = "lPowerName";
var LENS_POWER_ABBREV = "lPowerAbbrev";
var LENS_POWER_DISPLAY_ORDER = "lPowerDisplayOrder";

var INV_SC_TBL = "inv_solarclips";
var INV_SC_ID = "scItemID";
var INV_SC_SKU = "sku";
var INV_SC_DESC = "description";
var INV_SC_FRAME_STYLE_ID = "frameStyleID";
var INV_SC_FRAME_COLOR_ID = "frameColorID";
var INV_SC_LENS_COLOR_ID = "lensColorID";
var INV_SC_FRAME_SIZE_ID = "frameSizeID";
var INV_SC_PRICE = "price";
var INV_SC_PROD_CODE = "productCode";

var INV_GC_TBL = "inv_gclips";
var INV_GC_ID = "gcItemID";
var INV_GC_SKU = "sku";
var INV_GC_DESC = "description";
var INV_GC_FRAME_STYLE_ID = "frameStyleID";
var INV_GC_FRAME_COLOR_ID = "frameColorID";
var INV_GC_LENS_COLOR_ID = "lensColorID";
var INV_GC_PRICE = "price";
var INV_GC_PROD_CODE = "productCode";

var INV_GCPC_TBL = "inv_gclips_pc";
var INV_GCPC_ID = "gcpcItemID";
var INV_GCPC_SKU = "sku";
var INV_GCPC_DESC = "description";
var INV_GCPC_FRAME_STYLE_ID = "frameStyleID";
var INV_GCPC_FRAME_COLOR_ID = "frameColorID";
var INV_GCPC_LENS_COLOR_ID = "lensColorID";
var INV_GCPC_PRICE = "price";
var INV_GCPC_PROD_CODE = "productCode";

var INV_DC_TBL = "inv_dclips";
var INV_DC_ID = "dcItemID";
var INV_DC_SKU = "sku";
var INV_DC_DESC = "description";
var INV_DC_FRAME_STYLE_ID = "frameStyleID";
var INV_DC_FRAME_COLOR_ID = "frameColorID";
var INV_DC_LENS_COLOR_ID = "lensColorID";
var INV_DC_PRICE = "price";
var INV_DC_PROD_CODE = "productCode";

var INV_DCPC_TBL = "inv_dclips_pc";
var INV_DCPC_ID = "dcpcItemID";
var INV_DCPC_SKU = "sku";
var INV_DCPC_DESC = "description";
var INV_DCPC_FRAME_STYLE_ID = "frameStyleID";
var INV_DCPC_FRAME_COLOR_ID = "frameColorID";
var INV_DCPC_LENS_COLOR_ID = "lensColorID";
var INV_DCPC_PRICE = "price";
var INV_DCPC_PROD_CODE = "productCode";

var INV_MAG_TBL = "inv_magnifiers";
var INV_MAG_ID = "magItemID";
var INV_MAG_SKU = "sku";
var INV_MAG_DESC = "description";
var INV_MAG_FRAME_STYLE_ID = "frameStyleID";
var INV_MAG_LENS_POWER_ID = "lPowerID";
var INV_MAG_PRICE = "price";
var INV_MAG_PROD_CODE = "productCode";