updated syntax of default values to allow file to run inside HSQLDB GUI (it ran fine on the back end for some reason), addresses #545
added UNIQUE constraint to client_id