Jump to content

Archived

This topic is now archived and is closed to further replies.

HookedOnWeb

db demo script

Recommended Posts


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.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.