CREATE TABLE `so_teams` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `schools_id` INT NOT NULL , `name` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;