Create the Flat Bowler TableJust a few simple lines for the Flat Bowler Table. This table is designed for leagues where you only have the final results. CREATE TABLE flatbowlerTBL ( bowler_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, bowler_name VARCHAR (35) NOT NULL, avg FLOAT(5,1) UNSIGNED, numgames INT UNSIGNED, thundo INT UNSIGNED, thundopct FLOAT(5,1) UNSIGNED, team_id MEDIUMINT UNSIGNED NOT NULL, division_id MEDIUMINT UNSIGNED NOT NULL, league_id MEDIUMINT UNSIGNED NOT NULL, PRIMARY KEY (bowler_id) ); |