New SQL created by Lisa G. during the final port to MSSQL. These definitions include the IDENTITY field, to work-around the limit of 16 max fields in a key.