SGA Inventory Table

/*
Drop the table to allow for multiple iterations
*/
DROP TABLE INVENTORY;

/*
Recreate the table
*/
CREATE TABLE INVENTORY(TAG_NUM BIGINT NOT NULL, NOA_NUM TINYTEXT, ITEM_NAME TINYTEXT NOT NULL, ITEM_DESC TINYTEXT NOT NULL, MANUFACT_NAME TINYTEXT, MODEL_NUM TINYTEXT, SERIAL_NUM TINYTEXT, ITEM_PIC LONGBLOB, ITEM_COND TINYTEXT NOT NULL, SELLER_NAME TINYTEXT, PUR_DATE DATE NOT NULL, PUR_PRICE DECIMAL(65,2) NOT NULL, WARRANTY CHAR(1), WAR_END_DATE DATE, FOC_CAT TINYTEXT, STORE_LOINVENTORYCAL TINYTEXT, ARCHIVE CHAR(1), ARCHIVE_DATE DATE, RSO_NAME VARCHAR(100) NOT NULL, PRIMARY KEY(TAG_NUM));

/*
Verify the table columns are expected
*/
DESCRIBE INVENTORY;

/*
Insert test values into the table to ensure data appears as expected
*/

INSERT INTO INVENTORY(TAG_NUM, NOA_NUM, ITEM_NAME, ITEM_DESC, MANUFACT_NAME, MODEL_NUM, SERIAL_NUM, ITEM_PIC, ITEM_COND, SELLER_NAME, PUR_DATE, PUR_PRICE, WARRANTY, WAR_END_DATE, FOC_CAT, STORE_LOCAL, ARCHIVE, ARCHIVE_DATE, RSO_NAME)
VALUES (1,"TESTNOANUM", "TEST ITEM NAME", "TEST ITEM DESC", "TEST MANUFACT NAME", "TEST MODEL NUM", "TEST SERIAL NUM", NULL, "TEST ITEM CONDITION", "TEST SELLER NAME", "2019-11-14", 65.00, "Y", NULL, "TEST FOC CAT", "TEST STORE LOCAL", NULL, NULL, "7 Thunders");

/*
Select every value in the table, to ensure data passed is valid
*/

SELECT * FROM INVENTORY;