generate surrogate IDs distinct to only one table (not universally unique)

[jpuck]

With the explosively exponential creation of records, maxing out the integer size may come quicker than expected. Instead of using TSQL BIGINT, which will break DBMS portability and waste disk space, the IDs should start over for each table the same way an identity field would work.