Josiah’s Johnson

CREATE TABLE program_hotel_room_block_counts (
program_hotel_room_block_count_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
program_hotel_room_block_id INTEGER(11) UNSIGNED NOT NULL,
program_wave_id INTEGER(11) UNSIGNED NOT NULL,
room_date DATE NOT NULL,
room_count INTEGER UNSIGNED NULL,
PRIMARY KEY(program_hotel_room_block_count_id)
);