 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() ,

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,

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