create schema test collate utf8_unicode_ci;

create table test.input_type

(

    input_type_id int(11) unsigned auto_increment

        primary key

);

create table test.input

(

    input_id int unsigned auto_increment

        primary key,

    input_type_id int unsigned not null,

    constraint ibfk

        foreign key (input_type_id) references test.input_type (input_type_id)

);

create index type_id

    on test.input (input_type_id);

alter table test.input_type change input_type_id id int(11) unsigned auto_increment;