Open source/ERD/Autonumber

I have looked at Intuit's TrackIT, and a couple of open source (running on Apache) packages that do similar things to get an idea of layout and features. Some neat hardware inventory features are in some of them, but while useful, is beyond the scope of this project.

I've got a couple rough ERDs done.

I don't know how to do auto-numbers for my primary keys in SQL--at least by hand, and I'm trying not to be too GUI dependent, but rather hand scripting the tables/constraints in notepad and importing via SQL Analyzer.

Still looking at a baby step of an Access front end. I've created another one for work using Access that keeps track of our MSDN licenses, so I can make it look nice, but .php/.asp would really be really slick and universally available. It's just a matter of how long it'll take to get the skills and implement them.