[Phpwebsite-developers] Database Design Suggestions

[clayton c. <cc...@ca...>]

1. All primary keys should be integer (size, indexing speed, comparability).
This may cause issues for heavily populated tables (forums, etc), though we
can design around it.

2. (Please...) Sequences instead of autoincs. Not only are they more
portable, but they allow you to do things like double-click protection, and
are more conservative of key-space.

more to follow ....