search

Discordanian / mmatch

mmatch work stream
MIT License
2 stars 0 forks source link

User / Time Trigger on tables #131

Closed quequegg closed 6 years ago

quequegg commented 6 years ago

We need to add the typical date and user trigger to files, at least the ones that are set up by organizations.

I need to be able to see if we are getting any traction from the organizations.

alandgri commented 6 years ago

I'd rather do this in the code than in triggers. One benefit is we can also track who made the changes.

alandgri commented 6 years ago

mysql actually has this functionality built into the timestamp data type. No trigger nor coding necessary. I will implement tonight.

alandgri commented 6 years ago

This is complete. I implemented in all environments for the org table. I will add it to the user table as well.

quequegg commented 6 years ago

Thanks!

On Feb 6, 2018, at 8:00 PM, alandgri notifications@github.com wrote:

This is complete. I implemented in all environments for the org table. I will add it to the user table as well.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub, or mute the thread.

alandgri commented 6 years ago

The special value '2000-01-01' for the update_timestamp is what will be seen for any rows that existed right now, but haven't been updated yet. Any new rows created after this will have the correct time stamp.