Hi Fellows,
Please kindly note I'm a little bit noob to the SQL, :)
I'm currently having the version OSticket 1.6 RC5 and my ticketing sys is a heavy duty platform which is always hitting 20 or 30 tickets per day. Now I'm going to upgrade it to the latest version (1.6.0 stable) with few extra functionalities.
I've downloaded the latest release and configured it as much as possible to match with my need at my local test site. Also added new 3 columns to the ticket table and made some changes in the ticket detail pages.
There are few questions.:
I'm trying to export the current tables and import them to the upgraded database to get use of old tickets. Is it correct?
Also I've identified following tables. Are there an more?
Do both versions (stable ans RC5) use same tables?
xxxx_ticket
xxxx_ticket_attachment
xxxx_ticket_lock
xxxx_ticket_message
xxxx_ticket_note
xxxx_ticket_priority
xxxx_ticket_response
Is it ok to upload the whole test site files to the live ticketing sys with override?
Or should I upload a fresh copy to the live server and re configure it to my need?
Or override the live site with the latest release's files and run the upgrade script. And make my configuration?
Also, could I keep the same database and tables in the Live ticketing system, replace only with the files and add that new 3 columns to the existing ticket table? (if could, this is easy)
Please anyone strongly confirm me both version's tables are same.
Thanks:(