-- Start the transaction
START TRANSACTION;

--  Delete all the table data
--  All other qb_* tables are deleted by CASCADING DELETEs
DELETE FROM `manfstudio_dev`.`qb_items`;
DELETE FROM `manfstudio_dev`.`qb_inventory_sites`;

-- Insert Inventory Site records
INSERT INTO `manfstudio_dev`.`qb_inventory_sites` (`site_id`, `name`) VALUES ('80000002-1477203394', 'CA-Orange');
INSERT INTO `manfstudio_dev`.`qb_inventory_sites` (`site_id`, `name`) VALUES ('80000001-1476941342', 'Drop Ship');

-- Insert Item records
INSERT INTO `manfstudio_dev`.`qb_items` (`item_id`, `name`, `item_number_type`, `type`) VALUES ('8000000A-1484095135', '- Internal Labor -', 'NONE', 'Service');

-- The following insert will throw an exception
INSERT INTO `manfstudio_dev`.`qb_items` (`item_id`, `name`, `item_numffffber_type`, `type`) VALUES ('80000024-1484102389', 'General Device Assembly Labor', 'NONE', 'Service');
INSERT INTO `manfstudio_dev`.`qb_items` (`item_id`, `name`, `item_number_type`, `type`) VALUES ('80000009-1483733754', 'Miscellaneous', 'NONE', 'Service');

-- Commit the transaction
COMMIT;