cms_database_revisions revision_date

[G17 Media]

Is it possible you can change the revision_date in cms_database_revisions from a varchar(13) to an int? And maybe index it?

We are working on a working on a way of showing Wiki edits and this is a bit of a blocker without us changing it manually.

 

Thanks.

[bfarber]

Why specifically do you need it to be an indexed int column?

[G17 Media]

We are putting CMS database edits into the All Activity feed.

[bfarber]

Ok, but why does that require changing the column type out of curiousity?

[G17 Media]

Well, the idea of at least making it an int would make it consistent to how dates are stored elsewhere in the framework.

The indexing would be useful for particularly for our use in putting edits in the activity stream so they are searchable by date/time, so probably isn't needed in the core framework (but might be useful if IPS wants to count/filter these by date/time) -- I'm happy to make our database inconsistent with an extra index.

Edited May 2, 2020 by G17 Media

[bfarber]

As the change you are suggesting has no practical impact in our case, it's not a change we are likely to make anytime in the immediate future. I'd recommend just adding the index and doing what you need to do.