| Index: trunk/wikistats/analytics/create_and_use_db_analytics.txt |
| — | — | @@ -10,13 +10,13 @@ |
| 11 | 11 | -- meta data (mostly for auditing, may not be sent over API on default) |
| 12 | 12 | -- not used right now, store meta dat elsewhere,tbd, kept for brainstorm |
| 13 | 13 | -- |
| | 14 | +-- `id` int auto_increment NOT NULL, |
| | 15 | +-- `generated` timestamp, |
| | 16 | +-- `source` char (20), |
| | 17 | +-- `server` char (20), |
| | 18 | +-- `script_name` char (30), |
| | 19 | +-- `script_version` char (8), |
| | 20 | +-- `user` char (20), |
| 14 | 21 | -- |
| 15 | 22 | -- analytics data |
| 16 | 23 | `yyyymm` char (7), |