CREATE TABLE midmember_workid(
user_all_id INT(12) NOT NULL,
member_id MEDIUMINT(8) UNSIGNED NOT NULL,
foreign key (user_all_id) references v_mid_user_all (id),
foreign key (member_id) references midmembers (id),
primary key(user_all_id,member_id)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DEFAULT;