For my final proposal, I have decided to create a forum that will go by the name of SaabFocus.com because I would really like to work with the mysql database a bit more.
The site will end up being a Saab Cars forum where enthusiasts and owners of Saabs can talk about their cars, repairs, and increasing performance. I will try to implement
the ability for users to utilize categories with topics in them which have posts within them, this will be a good way to practice schema creation as I am certain this will
require multiple linked tables with various primary keys. All the posts and categories will all go through mysql database, as well as the accounts. I will try to create a fluid
looking forum with the help of bootstrap and custom css. I would also like to incorporate a calendar feature into the site where
track events and meetups can be posted onto it, but this feature will only be available to registered users. Visitors to the site will be able to see some of the
categories and threads but there will be some which will only be shown to users, and visitors will not be able to reply to threads.
For the page count, there will be the home page, the login page, the logout page, the calendar page, the categories page, the topics page,
a thread page and there will be a moderator page for those users with the right user level. In terms of mysql tables, there will be the main
users table, the categories table, the topics table, the threads table, the calendar table, and the permissions table. My website is similar
to a lot of sites out there, except that I will tailor the site to what most Saab owners and enthusiasts truly need which will make them prefer
my forum over current ones. The biggest difference to other sites is that I will be able to incorporate certain features
that will be of value to Saab owners and enthusiast, such as forms to join local crews, the event calender for different track and meetup events, and all the other forums'.
features. The sites which exist that are close to what I want to do are sites like saabcentral.com and saabworld.net which offer Saab owners the opportunity to create threads
and communicate with each other, but the problem is that these sites are not as up-to-date as one would hope, which is why tailoring my forum site
to what Saab owners need will make it so that they do not need to create various accounts on different forums to achieve their car's full potentials.
In conclusion, I believe that the most difficult part of creating this forum will be figuring out the schema and all the necessary primary keys and how everything should be
linked up, but aside from that I think that the rest will just be incorporating what we have learned throughout the overall course into this final project.