I have the following scenario:
A company has an account.
Each account has many users.
Users can make posts.
Posts will obviously have an .id field that autoincrements. However, I
a field, say post_number, that increments within the :scope =>
so all the posts within a company has numbers that follow on each other.
Problem. Two users from the same account could be posting at the same
I need a way to make sure the post_number is unique for each account and
increments from 1.
If you are using a mysql database - what would be the best way of doing
this? Would you have to do the saving within a transaction?