CREATE TABLE `mdt`.`media_type` (
`media_type_id` INT NOT NULL AUTO_INCREMENT ,
`media_type_name` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `media_type_id` )
) ENGINE = MYISAM ;


INSERT INTO `mdt`.`media_type` (
`media_type_id` ,
`media_type_name`
)
VALUES (
NULL , 'Movie'
), (
NULL , 'Game'
), (
NULL , 'MusicTV'
), (
NULL , 'Karaoke'
), (
NULL , 'Other'
);

ALTER TABLE `media` CHANGE `year` `year` VARCHAR( 25 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL


alter table letter_form change `Title` `title` varchar(200);