Jump to content

Community

cms_database_revisions revision_date


G17 Media
 Share

Go to solution Solved by bfarber,

Recommended Posts

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.

Link to comment
Share on other sites

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 by G17 Media
Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy