can a module create a database on install?
I've written a nice module feature that doesn't exist (probably going to need to be ported to a component) which takes a parameter (days) and emails authors when their pages are due to expire (x) days in advance, then once a day until expiry.
It also keeps a nice list module in administrator view.
1) Unfortunately at present this works manually when an the /administrator site is logged into (which would need to be once a day)
2) It has a very small database to hold the id and date of each 'warned' content so they are only warned once a day. This database can only be created automatically via a component install, is that right? or can I do this in the modules XML
3) Can I automate the running of this module so it is independant of Admin login? I've tried just the script on a Win scheduled task but as It's not been able to log in it's not run.
Would like to know if there are any developers who would like to help take this further, perhaps into a component to really assist the whole Mambo community?