
DROP TABLE IF EXISTS `va_suppliers`;
CREATE TABLE `va_suppliers`(
 `supplier_id` INT(11) NOT NULL AUTO_INCREMENT,
 `supplier_order` INT(11) default '1',
 `supplier_name` VARCHAR(255),
 `supplier_email` VARCHAR(255),
 `short_description` TEXT,
 `full_description` TEXT,
 `image_small` VARCHAR(255),
 `image_small_alt` VARCHAR(255),
 `image_large` VARCHAR(255),
 `image_large_alt` VARCHAR(255)
  ,PRIMARY KEY (supplier_id)
);

DELETE FROM `va_suppliers`;
INSERT INTO `va_suppliers` (supplier_id, supplier_order, supplier_name, supplier_email, short_description, full_description, image_small, image_small_alt, image_large, image_large_alt) VALUES (3, 1, 'RC Sports', 'Janeen@rcsports.com', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `va_suppliers` (supplier_id, supplier_order, supplier_name, supplier_email, short_description, full_description, image_small, image_small_alt, image_large, image_large_alt) VALUES (4, 2, 'Derby Diva', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `va_suppliers` (supplier_id, supplier_order, supplier_name, supplier_email, short_description, full_description, image_small, image_small_alt, image_large, image_large_alt) VALUES (5, 3, 'Riedell', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `va_suppliers` (supplier_id, supplier_order, supplier_name, supplier_email, short_description, full_description, image_small, image_small_alt, image_large, image_large_alt) VALUES (6, 4, 'Riedell Skates', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
