7Hex4ipa

1CREATE TABLE IF NOT EXISTS `contract` (
2  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '[ID]',
3  `no` VARCHAR(20) NOT NULL COMMENT '[NO]',
4  `type` TINYINT UNSIGNED NOT NULL COMMENT '[contract target]..1:car,2:bike',
5  `type_id` INT UNSIGNED NOT NULL COMMENT '[target table id]',
6  PRIMARY KEY (`id`)
7)
8ENGINE = InnoDB;
9	
10CREATE TABLE IF NOT EXISTS `contract` (
11  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '[ID]',
12  `no` VARCHAR(20) NOT NULL COMMENT '[NO]',
13  `car_id` INT UNSIGNED NOT NULL COMMENT '[car table id]',
14  `bike_id` INT UNSIGNED NOT NULL COMMENT '[bike table id]',
15  PRIMARY KEY (`id`)
16)
17ENGINE = InnoDB;