Jump to content


Photo

db demo script


  • Please log in to reply
1 reply to this topic

#1 HookedOnWeb

HookedOnWeb
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 14 March 2006 - 10:40 PM


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.


#2 keeB

keeB
  • Staff Alumni
  • Advanced Member
  • 1,078 posts
  • LocationCalifornia

Posted 14 March 2006 - 11:29 PM

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:
DROP TABLE entries

Come visit my site to see my latest projects
http://nick.stinemates.org/wordpress/





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users