• louiz’'s avatar
    Use a different Date data type · 857c7d39
    louiz’ authored
    PLEASE backup your database before testing this commit, and report any
    migration issue.
    In postgresql, we use timestamp with timezone.
    In sqlite3 we use REAL (the date is expressed as julianday)
    This requires a migration of the muclogline_ table:
    In postgresql it’s pretty simple, we convert all the integer into timestamps
    With sqlite3, we actually rename the table, create the new one with the
    correct type, then copy everything to the new table, with a conversion
    function for the Date_ column, and then we delete the old table.
    fix #3343
To find the state of this project's repository at the time of any of these versions, check out the tags.