| Index: trunk/wikistats/analytics/analytics_create_and_load_from_csv.txt |
| — | — | @@ -15,7 +15,7 @@ |
| 16 | 16 | |
| 17 | 17 | |
| 18 | 18 | -- open issues: |
| | 19 | +-- only store basic data in database and calculate all aggregates on the fly or do some aggregation before hand ? (e.g. count for mobile / non-mobile / ==> total of both ? <==) |
| 19 | 20 | -- for binaries, store one extension type per row? (future proof, more work to query), or a selected few as columns? (one row only needed per month) |
| 20 | 21 | |
| 21 | 22 | -- Create database and two tables from scratch |
| — | — | @@ -41,7 +41,7 @@ |
| 42 | 42 | `region_code` varchar (2), |
| 43 | 43 | `report_language` varchar (10), |
| 44 | 44 | `region_name` varchar (18), |
| 45 | | - PRIMARY KEY (report_language,region_code) |
| | 45 | + PRIMARY KEY (region_code,report_language) |
| 46 | 46 | ) ; |
| 47 | 47 | |
| 48 | 48 | CREATE TABLE `wikistats` ( |