|
|
(3 intermediate revisions by the same user not shown) |
Line 1: |
Line 1: |
| This page is the new ''Cumulusmx.db'' page. This page and subpages hold a complete rewrite of the ''Webtags'' related pages.
| |
|
| |
| The information that was on this old ''Cumulusmx.db'' page has been moved to [[Cumulusmx.db_(preserving_history)|Cumulusmx.db (preserving history)]]. You are advised to use that page until this page is ready and this message has been removed. If any questions or remarks please send a PM to [https://cumulus.hosiene.co.uk/memberlist.php?mode=viewprofile&u=9016 HansR] on the forum. Do not use the ''discussion'' tab unless accompanied by a PM: there is no automated signal to HansR if you use that page.
| |
|
| |
| This page and its subpages will document the Cumulusmx.db from the point of view of the CumulusMX software and not the Cumulus 1 legacy software. Cumulus 1 is no longer maintained and will eventually disappear. If you are still using it, please refer to the original [[Cumulusmx.db_(preserving_history)|Cumulusmx.db (preserving history)]] page where @sfws has tried to give both packages equal value. That effort is no longer maintained in this ''Webtags'' page. We hope you will understand this approach.
| |
|
| |
| Please do not edit this page while it is being worked on i.e. while this message is still here.
| |
|
| |
| <hr/>
| |
|
| |
| [[Category:Cumulus MX]][[Category:Cumulus Files]] | | [[Category:Cumulus MX]][[Category:Cumulus Files]] |
|
| |
|
Line 215: |
Line 205: |
| |- | | |- |
| | 0 | | | 0 |
| | Timestamp | | | key |
| | datetime | | | integer |
| | Primary Key, can never be NULL, No Default Value, | | | Primary Key, Not NULL, No Default Value, |
| | Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running) | | | An autoincrement integer for every SQL statement entered in the cache |
| | |- |
| | |- |
| | | 1 |
| | | statement |
| | | varchar |
| | | Not NULL, No Default Value, |
| | | Contains the actual SQL statement that failed |
| |- | | |- |
| |} | | |} |
| #key; An autoincrement integer for every SQL statement entered in the cache
| |
| #statement; A varchar (string) containing the SQL statement that failed
| |
|
| |
|
| = SQLite Sequence = | | = SQLite Sequence = |
| No relevant information on this table is known | | No relevant information on this table is known |