Good morning strangers! I haven't posted in a while, but you always seem to be helpful...
I have an application that uses SQL as a back-end to store data so that multiple users can access it at once. The question I have is, the requirements have changed and the SQL schema needs to change, and I'm not sure what the best way to do this is.
I have a table that contains a "log" of sorts. Basically it allows us to keep track of tasks and indicate (via a boolean value) if the task was completed. So when the task is done, the user checks a checkbox. Now we need to have the user indicate the date that the task was completed, not just check a box.
Since we have nearly 75,000 records in this table already, and we need to maintain the old information, would it be best to:
- Add new columns to the existing table, and just not use the boolean fields for new records?
- Create a brand new table that mimics the old one and just use date fields instead of the boolean ones and keep the old table for reference?
I've never actually had to change something like this before, normally it was "we don't need this column anymore and it's safe to just drop it and all the data in it."