Hi guys, I am stuck in defining the database of my new project. I need help on this. DESCRIPTION: The web page has a form that allows for a 140 character post, and another field for tags.
I have 2 problems now, how do I implement tagging in the database? i.e. allow a post to be associated with different tags without using the "tagging" plugin? Also, how do I extend the User table to allow me extra fields? Do I have to implement my own USER class and extend the base User class? This is a rough draft: POST table: Fields: 1. post 2. tag 3. timestamp 4. author (this should be auth.user.username) 5. karma (default=1) TAGS table: Fields: 1. Post (reference DB.POST) 2. Tag