5,838
edits
ImportCumulusFile: Difference between revisions
From Cumulus Wiki
Jump to navigationJump to search
m
no edit summary
m (→Realtime table) |
mNo edit summary |
||
| Line 20: | Line 20: | ||
=IMPORTANT NOTE FOR VERSION 4.0+= | =IMPORTANT NOTE FOR VERSION 4.0+= | ||
Version 4.0 changes the SQL table structures from version 2 & 3. If you are currently using version 2 or 3 and wish to upgrade, then you should DROP the existing tables and let the version 4 script recreate them, or alter the table structures to add the new columns. | Version 4.0 changes the SQL table structures from version 2 & 3. If you are currently using version 2 or 3 and wish to upgrade, then you should DROP the existing tables and let the version 4 script recreate them, or alter the table structures to add the new columns. | ||
= Schema for version 4.0 and later = | = Schema for version 4.0 and later = | ||
| Line 184: | Line 175: | ||
</pre> | </pre> | ||
=IMPORTANT NOTE FOR VERSION 2.0+= | |||
Version 2.0 changes the SQL table structures from version 1.x. If you are currently using version 1.x and wish to upgrade, then you should DROP the existing tables and let the version 2 script recreate them. If this is unacceptable DO NOT UPGRADE, stay with version 1.x | |||
The new table formats use a combined date/time field instead of separate, this makes constructing queries much simpler, it is worth making the change. | |||
Of course if you do change, then any existing queries you are using will also have to be rewritten - take this into account. It may be possible to create VIEWs of the new tables that mimic the old table format, and for you to use those views with your existing queries, that is an exercise for you! | |||
You could of course run 1.x and 2.x in parallel whilst you made the switch over gradually. Just alter the table names in v2 of the script slightly to avoid name collisions. | |||
= Schema for versions 2.0 to 3.0 = | = Schema for versions 2.0 to 3.0 = | ||
