Yes, this is better -- or just a general "modified" time stamp like linux..
Mark Mackay - Orcon wrote:
I totally second this idea!
Also on deletions - it would be great to have a 'deleted timestamp' (forgive
me if this is in the upcoming 2.0 release, I haven't checked the code).
That way you can purge messages from the database once they've been *marked
as deleted* for more than <user configurable> days. A grace-period if you
will where helpdesks can 'save the day' for unsavvy users.
/Mark
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jamieson Becker
Sent: Monday, 13 October 2003 3:05 p.m.
To: [email protected]
Subject: Re: [Dbmail] Usage question...
Doug,
Perhaps the maintenance script could also be modified to allow
user-modifiable SQL statements. For example,
DELETE FROM sometable WHERE deleted='1' AND TIMESTAMP<"%s"
That way, it'd only delete mail that was older than a certain
date AND
deleted...
(excuse my SQL, it's a second language..)
Doug Stanley wrote:
Are any of you using the dbmail system at a larger
university? Or even
a small university? I suggested using it here for our
computer science
deptartment, but the big thing stopping us was that
professors often
"accidentally" delete mail they didn't want to so we have
to go in and
get their mail file from tape backups...
I think dbmail would actually be better in this case cause
we could just
change the mail deleted flag in the db...as long as we only run the
maintanence script pretty rarely...anyways...I'm just
curious if anyone
out there is actually using this at a university setting
where people
do stupid things to their mail...
Doug
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
