Public feed #887183

Unnamed

public sql v1 · immutable
Raw Edit
·published 2008-02-01 04:39 UTC
rendered paste body
SET FOREIGN_KEY_CHECKS=0;-- Drop table tbl_ridersDROP 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_imagesDROP 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;