updating copyright
adding deduping to each of the create statements