5,838
edits
ImportCumulusFile: Difference between revisions
From Cumulus Wiki
Jump to navigationJump to search
m
→Dayfile table
m (→Dayfile table) |
|||
| Line 187: | Line 187: | ||
= Schema for versions 2.0 to 3.0 = | = Schema for versions 2.0 to 3.0 = | ||
== Dayfile table == | == Dayfile table (old) == | ||
The database table that mirrors dayfile.txt (with its fields as at Cumulus version 1.9.4) has the following schema at version 1.3 to 3.2 inclusive (column names and their format), for earlier Cumulus 1 versions with fewer fields, the schema will also work because all columns after 'TotWindRun' can default to null values: | The database table that mirrors dayfile.txt (with its fields as at Cumulus version 1.9.4) has the following schema at version 1.3 to 3.2 inclusive (column names and their format), for earlier Cumulus 1 versions with fewer fields, the schema will also work because all columns after 'TotWindRun' can default to null values: | ||
| Line 240: | Line 240: | ||
'DomWindDirSym', 'varchar(3)' | 'DomWindDirSym', 'varchar(3)' | ||
</pre> | </pre> | ||
== Monthly table == | == Monthly table == | ||
