SET FOREIGN_KEY_CHECKS=0;

-- Drop table tbl_riders
DROP TABLE IF EXISTS `tbl_riders`;

CREATE TABLE `tbl_riders` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rider_number` int(11),
  `rider_name` varchar(255),
  PRIMARY KEY(`id`)
)
ENGINE=INNODB;

-- Drop table tbl_images
DROP TABLE IF EXISTS `tbl_images`;

CREATE TABLE `tbl_images` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `rider_id` int(11),
  `img_small_filename` varchar(255),
  `img_med_filename` varchar(255),
  `img_large_filename` varchar(255),
  `img_orig_filename` varchar(255),
  PRIMARY KEY(`id`),
  CONSTRAINT `idx_rider` FOREIGN KEY (`rider_id`)
    REFERENCES `tbl_riders`(`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
)
ENGINE=INNODB;

SET FOREIGN_KEY_CHECKS=1;