nirix/traq — comment on commit f4837748e2f16127b4e6dce030accb0cc3c2e94c
File:  line 0
By CharlesMartel:

Ok I think I have successfully ported everything. I am having some issues with my webserver not wanting to go through index.php so it keeps looking for subfolders but I don't think that is a problem with the code as much as my setup. The only fields that I did not see in the file that I needed to change were...

plugins table - needed to add a 'file' column, didn't know the type so i just set it to text
tickets table - needed to add a 'assignee_id' column, the rest seemed to be BIGINT(20) so thats what I gave it
milestones table - needed to add 'name' - varchar(255)
milestones table - needed to add 'is_completed' - boolean
milestones table - needed to add 'is_cancelled' - boolean
milestones table - needed to add 'is_locked' - boolean

I'll let you know if I run across any others. Please let me know if I have chosen incorrect data types for these ones above and also specifically which time stamp fields were moved to date time as I think they were previously being stored as integer and have no way of differentiating which fields need changing.