  PRIMARY_CONTACT VARCHAR(255), 
  CREATED TIMESTAMP NOT NULL DEFAULT NOW() ,
  WEBSITE VARCHAR(256),
- CMP_TYPE VARCHAR(30) NOT NULL DEFAULT "HHUBTEST",
+ CMP_TYPE VARCHAR(30) NOT NULL DEFAULT "TRIAL",
   CREATED_BY MEDIUMINT,
   UPDATED TIMESTAMP ,
   UPDATED_BY MEDIUMINT,

PRD_TYPE CHAR(4) DEFAULT "SALE",
TENANT_ID MEDIUMINT 
);

SELECT 'CREATING TABLE DOD_PRD_CAT' AS ' ';
CREATE TABLE DOD_PRD_CATG (ROW_ID MEDIUMINT AUTO_INCREMENT PRIMARY KEY,

CATG_ID MEDIUMINT, 
QTY_PER_UNIT VARCHAR(30), 
PRD_IMAGE_PATH VARCHAR(256),
PRD_IMAGE_PATH1 VARCHAR(256),
PRD_IMAGE_PATH2 VARCHAR(256),
PRD_IMAGE_PATH3 VARCHAR(256),
PRD_IMAGE_PATH4 VARCHAR(256),
SKU VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
UPC VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
EAN VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
JAN VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
ISBN VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
SERIAL_NO VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

UNIT_PRICE DECIMAL(7,2),
UNITS_IN_STOCK SMALLINT, 
CREATED TIMESTAMP NOT NULL DEFAULT NOW() ,
