CREATE TABLE lib_counts ( dirname CHAR(80) NOT NULL, # name of the directory. count INT not null, # number of accesses to the directory year INT not null # ) \g