title: Have more than one AutoIncrement Per Table
body: <p>Hey Everybody,<br>
  I'm trying to make a table that will have a bunch of ids referring to a user, and for each user there will be multiple posts that should also have their own ids. My question is how do I make the table so that when a record is inserted for a certain user, their post id should be incremented by 1. Meaning user 1 will have posts 1,2,3, and 4, user 2 will have posts 1,2,3,4,5,6, and 7, etc...  </p>
  
  <p>event_id is the primary key for the table, FK_user_ID is the foreign key that maps back to a user table, post_id is which number the post for that user is (which is my problem column), and post is the post</p>
  
  <pre><code>----------------------------------------------------
  |  event_id  |  FK_user_ID  |  post_id  |   post   |
  |      1     |       1      |      1    |   hey    |
  |      2     |       1      |      2    | you too  |
  |      3     |       1      |      3    |   ok     |
  |      4     |       2      |      1    |   foo    |
  |      5     |       2      |      2    |   bar    |
  ----------------------------------------------------
  </code></pre>