DELETE FROM tblsystemwide_supplier;
DELETE FROM tblsystemwide_supplies;
DELETE FROM tblsystemwide_supply_category;
ALTER TABLE tblsystemwide_supplier AUTO_INCREMENT = 1;
ALTER TABLE tblsystemwide_supplies AUTO_INCREMENT = 1;
ALTER TABLE tblsystemwide_supply_category AUTO_INCREMENT = 1;

INSERT INTO tblsystemwide_supplier
    (name, img_folder, datecreated)
VALUES
    ("Ace Hardware", "ace_hardware", NOW()),
    ("Fastenal", "fastenal", NOW()),
    ("HDsupply", "hdsupply", NOW()),
    ("Home Depot", "home_depot", NOW()),
    ("Lowes", "lowes", NOW()),
    ("Menards", "menards", NOW()),
    ("White Cap", "white_cap", NOW());


ALTER TABLE `tblsystemwide_supplier`
ADD `img_folder` VARCHAR
(255) NOT NULL AFTER `image`;


ALTER TABLE `tblsystemwide_supply_category`
ADD `parent_id` BIGINT UNSIGNED NOT NULL AFTER `id`;
