5,838
edits
ImportCumulusFile: Difference between revisions
m
no edit summary
m (→Realtime table) |
mNo edit summary |
||
|
=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.
=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 version 4.0 and later =
</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 =
| |||