I'd post this in the developer section of the portal but I do not have the permission to open a topic in there yet :)
I'm working on some code for data collection that is run on my server, communicating directly with the database. The timestamp column in the cscart_products table is by default set up as an INT(11) data type. Currently, the default value is 0 and I was not able to change it to CURRENT_TIMESTAMP, as that value requires a timestamp data type.
With everything backed up, I put on my trial-and-error boots and changed the data type from INT(11) to timestamp and then made the default CURRENT_TIMESTAMP. Lo and behold, everything seems to work in order. Features such as sorting by date etc work in order.
Before I do further coding around this I just wanted to ask other devs with more cs-cart experience whether or not this will break when updating the firmware. Could there be any other complications? Do you know of any other features I could test for compatibility other than product sorting?
Many thanks :)