HookedOnWeb Posted March 14, 2006 Share Posted March 14, 2006 I have an online calendar demo application that access a database. The demo is open for anyone to use. I want to reset the db each night, thereby deleting what has been entered during the day and restore it back to its original state. The db deals with dates so I also need to create new db entries so a current calendar items are displayed.Does anyone know of a script that might work. Quote Link to comment Share on other sites More sharing options...
keeB Posted March 14, 2006 Share Posted March 14, 2006 Without knowing the DB Structure I can't be of much help.. but you would have a creation script which creates all the Tables that are required for your application to work.. and then a Deletion script which DROP's every table you don't need..Example: [code]DROP TABLE entries[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.