CREATE TABLE lib_counts ( dir_number INT not null, # number that corresponds to the name of # this directory in lib_counts_lookup table count INT not null, # number of times dir_number is accessed # on a given day year INT not null # ) \g