CREATE TABLE Products (
    prod_id int(10) unsigned NOT NULL AUTO_INCREMENT,
    prod_name varchar(127) DEFAULT NULL,
    prod_img varchar(127) DEFAULT NULL,
    prod_description varchar(511) DEFAULT NULL,
    prod_price decimal(10,2) DEFAULT NULL,
    prod_rating tinyint unsigned DEFAULT NULL,
    prod_sku char(32) DEFAULT NULL,
    prod_stock int(10) unsigned,
    PRIMARY KEY (prod_id)
);

INSERT INTO `Products` (`prod_id`, `prod_name`, `prod_img`, `prod_description`, `prod_price`, `prod_rating`, `prod_sku`, `prod_stock`) VALUES
(NULL, 'Ibanez Iron Label S SIX6FDFM', 'ibanez.jpg', 'The Ibanez SIX6FDFM solidbody electric guitar is built from the ground up for heavy metal. The guitar\'s S-series body is incredibly thin and contoured for unparalleled comfort. The Nitro Wizard neck profile welcomes your fastest performances. A pair of DiMarzio Fusion Edge humbucking pickups are engineered to bring out the most power, clarity, and note velocity as possible from the SIX6FDFM. And you receive rock-solid tuning stability due to the Gibraltar Standard II fixed bridge and locking tuners.', '899.99', 5, '98094104', 12),
(NULL, 'Jackson RR24 Pro Series Rhoads', 'jackson.jpg', 'The Jackson Pro Series Rhoads RR24 solidbody electric guitar is packed with aggressive visuals, fast-playing performance, and ferocious sound. Dual Seymour Duncan humbuckers supply savage high-output tone that beautifully enhances the resonance of this guitar\'s mahogany body. And you\'ll experience a serious speed boost to your playing, thanks to the RR24\'s oil-finished maple neck. Whammy and dive-bomb to your heart\'s content with a Floyd Rose double-locking tremolo.', '499.99', 4, '18409350', 2),
(NULL, 'Paul Reed Smith SE Torero', 'prs.jpg', 'Continuing the Paul Reed Smith legacy, the SE Torero takes two giant steps toward bridging the gap between the highly-acclaimed PRS SE series and their premier solidbody masterpieces. The minimalist fretboard free of inlays offsets the beauty of the SE Torero\'s flame maple top. Underneath, solid mahogany flanks a neck though body that leads all the way up an ultra-fast 25-1/2" 24-fret wide-thin neck. Its highly glossy body, neck, and headstock are all bound for a truly polished look and feel.', '999.99', 5, '57930195', 0),
(NULL, 'Fender Squier Vintage Modified Mustang', 'fender.jpg', 'Squier welcomes its first-ever Mustang guitar to the family in the sleekly diminutive form of the Vintage Modified Mustang. With its distinctive 24" scale, dual pickup switches and floating bridge with dynamic vibrato tailpiece, it\'s a classic modded with present-day touches including full-sounding Duncan Designed pickups and a 9.5 fingerboard radius. Whether installing hotter pickups, different pickguards or just plain personalizing their instruments with distinctive paint jobs.', '299.99', 1, '88823419', 10),
(NULL, 'Washburn Parallaxe Series M20FRF', 'washburn.jpg', 'If you\'re into metal, then you\'ll love the Washburn Parallaxe PXM20 solidbody electric guitar. Designed for the modern metal player, the PXM20 sports all the tonal tools needed to shred and chug like a pro. It starts off with a solid mahogany body with flame maple veneer. Tone screams out of a pair of Seymour Duncan pickups that are directly mounted to the body for maximum sustain and tonal transfer. Add to that a thin maple neck, ebony fretboard, extra jumbo frets, and an original Floyd Rose tremolo.', '499.99', 3, '09915424', 0),
(NULL, 'Gibson Les Paul Classic', 'gibson.jpg', 'Strap on Gibson\'s Les Paul Classic, and you\'ll experience iconic tone and uncompromising playability. A time-tested combination of maple and mahogany serves up the tone that\'s fueled a million rock anthems, while Burstbucker pickups inject your playing with loads of midrange muscle and sizzling overtones. You also get coil tapping, phase reversal, and pure bypass options for an endless variety of tonal textures. Equipped with a SlimTaper neck and easy-playing rosewood fingerboard.', '2299.99', 2, '57710923', 4);