search

TUM-Dev / Campus-Backend

New backend written in go with gRPC as an API interface
GNU General Public License v3.0
15 stars 7 forks source link

Update module github.com/prometheus/client_golang to v1.20.0 #411

Closed renovate[bot] closed 3 months ago

renovate[bot] commented 3 months ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
github.com/prometheus/client_golang v1.19.1 -> v1.20.0 age adoption passing confidence

Release Notes

prometheus/client_golang (github.com/prometheus/client_golang) ### [`v1.20.0`](https://togithub.com/prometheus/client_golang/releases/tag/v1.20.0) [Compare Source](https://togithub.com/prometheus/client_golang/compare/v1.19.1...v1.20.0) Thanks everyone for contributions! :warning: In this release we remove one (broken anyway, given Go runtime changes) metric and add three new (representing GOGC, GOMEMLIMIT and GOMAXPROCS flags) to the default `collectors.NewGoCollector()` collector. Given its popular usage, expect your binary to expose two additional metric. #### Changes - \[CHANGE] :warning: go-collector: Remove `go_memstat_lookups_total` metric which was always 0; Go runtime stopped sharing pointer lookup statistics. [#​1577](https://togithub.com/prometheus/client_golang/issues/1577) - \[FEATURE] :warning: go-collector: Add 3 default metrics: `go_gc_gogc_percent`, `go_gc_gomemlimit_bytes` and `go_sched_gomaxprocs_threads` as those are recommended by the Go team. [#​1559](https://togithub.com/prometheus/client_golang/issues/1559) - \[FEATURE] go-collector: Add more information to all metrics' HELP e.g. the exact `runtime/metrics` sourcing each metric (if relevant). [#​1568](https://togithub.com/prometheus/client_golang/issues/1568) [#​1578](https://togithub.com/prometheus/client_golang/issues/1578) - \[FEATURE] testutil: Add CollectAndFormat method. [#​1503](https://togithub.com/prometheus/client_golang/issues/1503) - \[FEATURE] histograms: Add support for exemplars in native histograms. [#​1471](https://togithub.com/prometheus/client_golang/issues/1471) - \[FEATURE] promhttp: Add experimental support for `zstd` on scrape, controlled by the request `Accept-Encoding` header. [#​1496](https://togithub.com/prometheus/client_golang/issues/1496) - \[FEATURE] api/v1: Add `WithLimit` parameter to all API methods that supports it. [#​1544](https://togithub.com/prometheus/client_golang/issues/1544) - \[FEATURE] prometheus: Add support for created timestamps in constant histograms and constant summaries. [#​1537](https://togithub.com/prometheus/client_golang/issues/1537) - \[FEATURE] process-collectors: Add network usage metrics: `process_network_receive_bytes_total` and `process_network_transmit_bytes_total`. [#​1555](https://togithub.com/prometheus/client_golang/issues/1555) - \[FEATURE] promlint: Add duplicated metric lint rule. [#​1472](https://togithub.com/prometheus/client_golang/issues/1472) - \[BUGFIX] promlint: Relax metric type in name linter rule. [#​1455](https://togithub.com/prometheus/client_golang/issues/1455) - \[BUGFIX] promhttp: Make sure server instrumentation wrapping supports new and future extra responseWriter methods. [#​1480](https://togithub.com/prometheus/client_golang/issues/1480) - \[BUGFIX] testutil: Functions using compareMetricFamilies are now failing if filtered metricNames are not in the input. [#​1424](https://togithub.com/prometheus/client_golang/issues/1424)
All commits - feat(prometheus/testutil/promlint/validations): refine lintMetricType… by [@​foehammer127](https://togithub.com/foehammer127) in [https://github.com/prometheus/client_golang/pull/1455](https://togithub.com/prometheus/client_golang/pull/1455) - Bump github.com/prometheus/client_golang from 1.18.0 to 1.19.0 in /examples/middleware by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1457](https://togithub.com/prometheus/client_golang/pull/1457) - Bump github.com/prometheus/client_model from 0.5.0 to 0.6.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1458](https://togithub.com/prometheus/client_golang/pull/1458) - Bump golang.org/x/sys from 0.16.0 to 0.17.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1459](https://togithub.com/prometheus/client_golang/pull/1459) - Bump github.com/prometheus/client_golang from 1.18.0 to 1.19.0 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1461](https://togithub.com/prometheus/client_golang/pull/1461) - Merge Release 1.19 back to main by [@​ArthurSens](https://togithub.com/ArthurSens) in [https://github.com/prometheus/client_golang/pull/1462](https://togithub.com/prometheus/client_golang/pull/1462) - Bump the github-actions group with 2 updates by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1456](https://togithub.com/prometheus/client_golang/pull/1456) - Bump google.golang.org/protobuf from 1.32.0 to 1.33.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1466](https://togithub.com/prometheus/client_golang/pull/1466) - Bump google.golang.org/protobuf from 1.32.0 to 1.33.0 in /examples/middleware by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1467](https://togithub.com/prometheus/client_golang/pull/1467) - Bump google.golang.org/protobuf from 1.32.0 to 1.33.0 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1469](https://togithub.com/prometheus/client_golang/pull/1469) - Add LintDuplicateMetric to promlint by [@​bboreham](https://togithub.com/bboreham) in [https://github.com/prometheus/client_golang/pull/1472](https://togithub.com/prometheus/client_golang/pull/1472) - Auto-update Go Collector Metrics for new Go versions by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1476](https://togithub.com/prometheus/client_golang/pull/1476) - Implement Unwrap() for responseWriterDelegator by [@​igor-drozdov](https://togithub.com/igor-drozdov) in [https://github.com/prometheus/client_golang/pull/1480](https://togithub.com/prometheus/client_golang/pull/1480) - Bump golang.org/x/sys from 0.17.0 to 0.18.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1485](https://togithub.com/prometheus/client_golang/pull/1485) - Bump github.com/prometheus/procfs from 0.12.0 to 0.13.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1486](https://togithub.com/prometheus/client_golang/pull/1486) - ci: Remove hardcoded supported Go versions from go.yml by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1489](https://togithub.com/prometheus/client_golang/pull/1489) - feat: metrics generation workflow by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1481](https://togithub.com/prometheus/client_golang/pull/1481) - fix: remove redundant go module in middleware example by [@​majolo](https://togithub.com/majolo) in [https://github.com/prometheus/client_golang/pull/1492](https://togithub.com/prometheus/client_golang/pull/1492) - chore: Refactor how base metrics are added to Sched metrics by [@​ArthurSens](https://togithub.com/ArthurSens) in [https://github.com/prometheus/client_golang/pull/1483](https://togithub.com/prometheus/client_golang/pull/1483) - gocollector: Add regex option to allow collection of debug runtime metrics by [@​ArthurSens](https://togithub.com/ArthurSens) in [https://github.com/prometheus/client_golang/pull/1389](https://togithub.com/prometheus/client_golang/pull/1389) - Bump github.com/prometheus/common from 0.48.0 to 0.52.3 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1498](https://togithub.com/prometheus/client_golang/pull/1498) - chore: fix function name in comment by [@​oftenoccur](https://togithub.com/oftenoccur) in [https://github.com/prometheus/client_golang/pull/1497](https://togithub.com/prometheus/client_golang/pull/1497) - build(deps): bump golang.org/x/net from 0.20.0 to 0.23.0 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1501](https://togithub.com/prometheus/client_golang/pull/1501) - build(deps): bump golang.org/x/net from 0.22.0 to 0.23.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1502](https://togithub.com/prometheus/client_golang/pull/1502) - feat(dependency): replace go-spew package by [@​dongjiang1989](https://togithub.com/dongjiang1989) in [https://github.com/prometheus/client_golang/pull/1499](https://togithub.com/prometheus/client_golang/pull/1499) - build(deps): bump github.com/prometheus/common from 0.52.3 to 0.53.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1504](https://togithub.com/prometheus/client_golang/pull/1504) - build(deps): bump github.com/cespare/xxhash/v2 from 2.2.0 to 2.3.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1505](https://togithub.com/prometheus/client_golang/pull/1505) - build(deps): bump google.golang.org/protobuf from 1.33.0 to 1.34.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1506](https://togithub.com/prometheus/client_golang/pull/1506) - build(deps): bump golang.org/x/sys from 0.18.0 to 0.19.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1507](https://togithub.com/prometheus/client_golang/pull/1507) - build(deps): bump github.com/prometheus/client_model from 0.6.0 to 0.6.1 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1508](https://togithub.com/prometheus/client_golang/pull/1508) - build(deps): bump github.com/prometheus/common from 0.48.0 to 0.53.0 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1509](https://togithub.com/prometheus/client_golang/pull/1509) - improved code more clean by [@​lilijreey](https://togithub.com/lilijreey) in [https://github.com/prometheus/client_golang/pull/1511](https://togithub.com/prometheus/client_golang/pull/1511) - build(deps): bump the github-actions group with 3 updates by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1510](https://togithub.com/prometheus/client_golang/pull/1510) - \[CI]: Add Concurrency Grouping to GitHub Workflows by [@​Ishani217](https://togithub.com/Ishani217) in [https://github.com/prometheus/client_golang/pull/1444](https://togithub.com/prometheus/client_golang/pull/1444) - Add CollectAndFormat to testutil, allowing caller to assert as they want to on the exported metric by [@​jcass8695](https://togithub.com/jcass8695) in [https://github.com/prometheus/client_golang/pull/1503](https://togithub.com/prometheus/client_golang/pull/1503) - testutil compareMetricFamilies: make less error-prone by [@​leonnicolas](https://togithub.com/leonnicolas) in [https://github.com/prometheus/client_golang/pull/1424](https://togithub.com/prometheus/client_golang/pull/1424) - improved code more clean use time.IsZero() replace t = time.Time{} by [@​lilijreey](https://togithub.com/lilijreey) in [https://github.com/prometheus/client_golang/pull/1515](https://togithub.com/prometheus/client_golang/pull/1515) - add native histogram exemplar support by [@​fatsheep9146](https://togithub.com/fatsheep9146) in [https://github.com/prometheus/client_golang/pull/1471](https://togithub.com/prometheus/client_golang/pull/1471) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1514](https://togithub.com/prometheus/client_golang/pull/1514) - build(deps): bump golang.org/x/sys from 0.19.0 to 0.20.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1523](https://togithub.com/prometheus/client_golang/pull/1523) - build(deps): bump google.golang.org/protobuf from 1.34.0 to 1.34.1 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1522](https://togithub.com/prometheus/client_golang/pull/1522) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1524](https://togithub.com/prometheus/client_golang/pull/1524) - Add PR template for changelog automation by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1517](https://togithub.com/prometheus/client_golang/pull/1517) - Auto label PRs by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1518](https://togithub.com/prometheus/client_golang/pull/1518) - Fix: Auto label PRs [#​1518](https://togithub.com/prometheus/client_golang/issues/1518) by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1525](https://togithub.com/prometheus/client_golang/pull/1525) - build(deps): bump github.com/prometheus/procfs from 0.13.0 to 0.15.1 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1527](https://togithub.com/prometheus/client_golang/pull/1527) - ci: Group all changelog-related CI jobs into single one by [@​ArthurSens](https://togithub.com/ArthurSens) in [https://github.com/prometheus/client_golang/pull/1526](https://togithub.com/prometheus/client_golang/pull/1526) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1530](https://togithub.com/prometheus/client_golang/pull/1530) - Remove synchronize trigger from changelog workflow by [@​SachinSahu431](https://togithub.com/SachinSahu431) in [https://github.com/prometheus/client_golang/pull/1532](https://togithub.com/prometheus/client_golang/pull/1532) - feat: Support zstd compression by [@​mrueg](https://togithub.com/mrueg) in [https://github.com/prometheus/client_golang/pull/1496](https://togithub.com/prometheus/client_golang/pull/1496) - Fix golangci-lint config by [@​SuperQ](https://togithub.com/SuperQ) in [https://github.com/prometheus/client_golang/pull/1536](https://togithub.com/prometheus/client_golang/pull/1536) - build(deps): bump github.com/prometheus/client_golang from 1.19.0 to 1.19.1 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1529](https://togithub.com/prometheus/client_golang/pull/1529) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1531](https://togithub.com/prometheus/client_golang/pull/1531) - Cleanup NOTICE file by [@​SuperQ](https://togithub.com/SuperQ) in [https://github.com/prometheus/client_golang/pull/1541](https://togithub.com/prometheus/client_golang/pull/1541) - Remove inlined upstream code by [@​SuperQ](https://togithub.com/SuperQ) in [https://github.com/prometheus/client_golang/pull/1539](https://togithub.com/prometheus/client_golang/pull/1539) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1545](https://togithub.com/prometheus/client_golang/pull/1545) - client: Add Option to provide limit query param for APIs that support it by [@​abbyssoul](https://togithub.com/abbyssoul) in [https://github.com/prometheus/client_golang/pull/1544](https://togithub.com/prometheus/client_golang/pull/1544) - Allow creating constant histogram and summary metrics with a created timestamp by [@​swar8080](https://togithub.com/swar8080) in [https://github.com/prometheus/client_golang/pull/1537](https://togithub.com/prometheus/client_golang/pull/1537) - Update README.md by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1556](https://togithub.com/prometheus/client_golang/pull/1556) - Temporarily remove required CI job for changelog. by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1560](https://togithub.com/prometheus/client_golang/pull/1560) - build(deps): bump github.com/prometheus/common from 0.53.0 to 0.55.0 in /tutorial/whatsup by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1549](https://togithub.com/prometheus/client_golang/pull/1549) - build(deps): bump golang.org/x/sys from 0.20.0 to 0.21.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1552](https://togithub.com/prometheus/client_golang/pull/1552) - build(deps): bump github.com/klauspost/compress from 1.17.8 to 1.17.9 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1553](https://togithub.com/prometheus/client_golang/pull/1553) - fix: Update Go tests by [@​SuperQ](https://togithub.com/SuperQ) in [https://github.com/prometheus/client_golang/pull/1562](https://togithub.com/prometheus/client_golang/pull/1562) - process_collector: collect received/transmitted bytes by [@​huwcbjones](https://togithub.com/huwcbjones) in [https://github.com/prometheus/client_golang/pull/1555](https://togithub.com/prometheus/client_golang/pull/1555) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1561](https://togithub.com/prometheus/client_golang/pull/1561) - chore: Remove half-implemented changelog automation by [@​ArthurSens](https://togithub.com/ArthurSens) in [https://github.com/prometheus/client_golang/pull/1564](https://togithub.com/prometheus/client_golang/pull/1564) - build(deps): bump the github-actions group across 1 directory with 3 updates by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1565](https://togithub.com/prometheus/client_golang/pull/1565) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1563](https://togithub.com/prometheus/client_golang/pull/1563) - build(deps): bump google.golang.org/protobuf from 1.34.1 to 1.34.2 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1551](https://togithub.com/prometheus/client_golang/pull/1551) - deps: Updated to prometheus/common to 0.55 by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1566](https://togithub.com/prometheus/client_golang/pull/1566) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1567](https://togithub.com/prometheus/client_golang/pull/1567) - tutorials: Renamed tutorial -> tutorials for consistency + fixed tutorial code. by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1569](https://togithub.com/prometheus/client_golang/pull/1569) - go collector: add default metrics acceptance tests; adding more context to HELP by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1568](https://togithub.com/prometheus/client_golang/pull/1568) - build(deps): bump golang.org/x/sys from 0.21.0 to 0.22.0 by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1570](https://togithub.com/prometheus/client_golang/pull/1570) - build(deps): bump the github-actions group with 3 updates by [@​dependabot](https://togithub.com/dependabot) in [https://github.com/prometheus/client_golang/pull/1571](https://togithub.com/prometheus/client_golang/pull/1571) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1572](https://togithub.com/prometheus/client_golang/pull/1572) - ci: daggerize test and lint pipelines by [@​marcosnils](https://togithub.com/marcosnils) in [https://github.com/prometheus/client_golang/pull/1534](https://togithub.com/prometheus/client_golang/pull/1534) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1573](https://togithub.com/prometheus/client_golang/pull/1573) - Add default Go runtime metrics for /gc/gogc:percent, /gc/gomemlimit:bytes, /sched/gomaxprocs:threads by [@​vesari](https://togithub.com/vesari) in [https://github.com/prometheus/client_golang/pull/1559](https://togithub.com/prometheus/client_golang/pull/1559) - Synchronize common files from prometheus/prometheus by [@​prombot](https://togithub.com/prombot) in [https://github.com/prometheus/client_golang/pull/1576](https://togithub.com/prometheus/client_golang/pull/1576) - Remove go_memstat_lookups_total; added runtime/metrics calculation to memstat metric's help. by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1577](https://togithub.com/prometheus/client_golang/pull/1577) - gocollector: Attach original runtime/metrics metric name to help. by [@​bwplotka](https://togithub.com/bwplotka) in [https://github.com/prometheus/client_golang/pull/1578](https://togithub.com/prometheus/client_golang/pull/1578)
#### New Contributors * @​foehammer127 made their first contributi[https://github.com/prometheus/client_golang/pull/1455](https://togithub.com/prometheus/client_golang/pull/1455)l/1455 * @​SachinSahu431 made their first contributi[https://github.com/prometheus/client_golang/pull/1476](https://togithub.com/prometheus/client_golang/pull/1476)l/1476 * @​igor-drozdov made their first contributi[https://github.com/prometheus/client_golang/pull/1480](https://togithub.com/prometheus/client_golang/pull/1480)l/1480 * @​majolo made their first contributi[https://github.com/prometheus/client_golang/pull/1492](https://togithub.com/prometheus/client_golang/pull/1492)l/1492 * @​oftenoccur made their first contributi[https://github.com/prometheus/client_golang/pull/1497](https://togithub.com/prometheus/client_golang/pull/1497)l/1497 * @​dongjiang1989 made their first contributi[https://github.com/prometheus/client_golang/pull/1499](https://togithub.com/prometheus/client_golang/pull/1499)l/1499 * @​lilijreey made their first contributi[https://github.com/prometheus/client_golang/pull/1511](https://togithub.com/prometheus/client_golang/pull/1511)l/1511 * @​Ishani217 made their first contributi[https://github.com/prometheus/client_golang/pull/1444](https://togithub.com/prometheus/client_golang/pull/1444)l/1444 * @​jcass8695 made their first contributi[https://github.com/prometheus/client_golang/pull/1503](https://togithub.com/prometheus/client_golang/pull/1503)l/1503 * @​leonnicolas made their first contributi[https://github.com/prometheus/client_golang/pull/1424](https://togithub.com/prometheus/client_golang/pull/1424)l/1424 * @​fatsheep9146 made their first contributi[https://github.com/prometheus/client_golang/pull/1471](https://togithub.com/prometheus/client_golang/pull/1471)l/1471 * @​abbyssoul made their first contributi[https://github.com/prometheus/client_golang/pull/1544](https://togithub.com/prometheus/client_golang/pull/1544)l/1544 * @​swar8080 made their first contributi[https://github.com/prometheus/client_golang/pull/1537](https://togithub.com/prometheus/client_golang/pull/1537)l/1537 * @​huwcbjones made their first contributi[https://github.com/prometheus/client_golang/pull/1555](https://togithub.com/prometheus/client_golang/pull/1555)l/1555 * @​marcosnils made their first contributi[https://github.com/prometheus/client_golang/pull/1534](https://togithub.com/prometheus/client_golang/pull/1534)l/1534 * @​vesari made their first contributi[https://github.com/prometheus/client_golang/pull/1559](https://togithub.com/prometheus/client_golang/pull/1559)l/1559 **Full Changelog**: https://github.com/prometheus/client_golang/compare/v1.19.1...v1.20.0

Configuration

📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

This PR was generated by Mend Renovate. View the repository job log.

renovate[bot] commented 3 months ago

ℹ Artifact update notice

File name: server/go.mod

In order to perform the update(s) described in the table above, Renovate ran the go get command, which resulted in the following additional change(s):

Details:

Package Change
github.com/prometheus/client_model v0.5.0 -> v0.6.1
github.com/prometheus/common v0.48.0 -> v0.55.0
github.com/prometheus/procfs v0.12.0 -> v0.15.1
github-actions[bot] commented 3 months ago

:eyes: Found the following differences in the sql schema:

Needed get from local to auto migration state ```sql -- Modify "" schema ALTER DATABASE COLLATE utf8mb4_unicode_ci; -- Create "published_exam_results" table CREATE TABLE `published_exam_results` ( `date` datetime(3) NULL, `exam_id` varchar(191) NOT NULL, `lecture_title` longtext NULL, `lecture_type` longtext NULL, `lecture_sem` longtext NULL, `published` bool NULL, PRIMARY KEY (`exam_id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "cafeteria_rating" table ALTER TABLE `cafeteria_rating` MODIFY COLUMN `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; -- Create "curricula" table CREATE TABLE `curricula` ( `curriculum` bigint NOT NULL AUTO_INCREMENT, `category` enum('bachelor','master') NOT NULL DEFAULT "bachelor", `name` mediumtext NOT NULL, `url` mediumtext NOT NULL, PRIMARY KEY (`curriculum`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "crontab" table ALTER TABLE `crontab` AUTO_INCREMENT 54, MODIFY COLUMN `interval` int NOT NULL DEFAULT 7200, MODIFY COLUMN `lastRun` int NOT NULL DEFAULT 0, MODIFY COLUMN `type` enum('news','mensa','ticketsale','alarm','fileDownload','canteenHeadCount','iosNotifications','iosActivityReset','newExamResultsHook','movie','feedbackEmail','dishNameDownload','scrapeStudentClubs') NULL; -- Create "openinghours" table CREATE TABLE `openinghours` ( `id` bigint NOT NULL AUTO_INCREMENT, `category` varchar(20) NOT NULL, `name` varchar(60) NOT NULL, `address` varchar(140) NOT NULL, `room` varchar(140) NULL, `transport_station` varchar(150) NULL, `opening_hours` varchar(300) NULL, `infos` varchar(500) NULL, `url` varchar(300) NOT NULL, `language` varchar(2) NULL DEFAULT "de", `reference_id` int NULL DEFAULT -1, PRIMARY KEY (`id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "dish_name_tag_option" table ALTER TABLE `dish_name_tag_option` AUTO_INCREMENT 69; -- Modify "dish_name_tag_option_excluded" table ALTER TABLE `dish_name_tag_option_excluded` AUTO_INCREMENT 9; -- Create "migrations" table CREATE TABLE `migrations` ( `id` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "wifi_measurement" table CREATE TABLE `wifi_measurement` ( `id` bigint NOT NULL AUTO_INCREMENT, `date` date NOT NULL, `SSID` varchar(32) NOT NULL, `BSSID` varchar(64) NOT NULL, `dBm` int NULL, `accuracyInMeters` float NOT NULL, `latitude` double NOT NULL, `longitude` double NOT NULL, PRIMARY KEY (`id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "dish_rating_tag_option" table ALTER TABLE `dish_rating_tag_option` AUTO_INCREMENT 10; -- Modify "feedback" table ALTER TABLE `feedback` MODIFY COLUMN `email_id` text NULL, MODIFY COLUMN `receiver` text NULL, MODIFY COLUMN `feedback` text NULL, MODIFY COLUMN `latitude` decimal(11,8) NULL, MODIFY COLUMN `longitude` decimal(11,8) NULL, MODIFY COLUMN `timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP; -- Create "sessions" table CREATE TABLE `sessions` ( `session` varchar(255) NOT NULL, `access` int unsigned NULL, `data` text NULL, PRIMARY KEY (`session`), UNIQUE INDEX `session` (`session`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "canteen_head_count" table ALTER TABLE `canteen_head_count` MODIFY COLUMN `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; -- Create "barrierFree_persons" table CREATE TABLE `barrierFree_persons` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(40) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `telephone` varchar(32) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `email` varchar(32) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `faculty` varchar(32) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `office` varchar(16) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `officeHour` varchar(16) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `tumID` varchar(24) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) CHARSET utf8mb3 COLLATE utf8mb3_general_ci; -- Modify "dish_name_tag_option_included" table ALTER TABLE `dish_name_tag_option_included` AUTO_INCREMENT 94; -- Create "mensaprices" table CREATE TABLE `mensaprices` ( `price` bigint NOT NULL AUTO_INCREMENT, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `person` mediumtext NOT NULL, `type` mediumtext NOT NULL, `typeLong` mediumtext NOT NULL, `typeNumber` int NOT NULL, `value` decimal(10) NOT NULL, PRIMARY KEY (`price`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "mensaplan_mensa" table CREATE TABLE `mensaplan_mensa` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `latitude` double NULL, `longitude` double NULL, `webid` int NULL, `category` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "member" table CREATE TABLE `member` ( `member` bigint NOT NULL AUTO_INCREMENT, `lrz_id` varchar(7) NOT NULL, `name` varchar(150) NOT NULL, `active_day` int NULL DEFAULT 0, `active_day_date` date NULL, `student_id` text NULL, `employee_id` text NULL, `external_id` text NULL, PRIMARY KEY (`member`), UNIQUE INDEX `lrz_id` (`lrz_id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 104353; -- Create "barrierFree_moreInfo" table CREATE TABLE `barrierFree_moreInfo` ( `id` bigint NOT NULL AUTO_INCREMENT, `title` varchar(32) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `category` varchar(11) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `url` varchar(128) CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) CHARSET utf8mb3 COLLATE utf8mb3_general_ci; -- Modify "cafeteria_rating_tag_option" table ALTER TABLE `cafeteria_rating_tag_option` AUTO_INCREMENT 10; -- Create "alarm_ban" table CREATE TABLE `alarm_ban` ( `ban` bigint NOT NULL AUTO_INCREMENT, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `ip` binary(16) NOT NULL, PRIMARY KEY (`ban`), UNIQUE INDEX `ip` (`ip`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "alarm_log" table CREATE TABLE `alarm_log` ( `alarm` bigint NOT NULL AUTO_INCREMENT, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `message` text NOT NULL, `send` int NOT NULL, `received` int NOT NULL, `test` enum('true','false') NOT NULL DEFAULT "false", `ip` binary(16) NOT NULL, PRIMARY KEY (`alarm`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "devices" table ALTER TABLE `devices` AUTO_INCREMENT 144352, MODIFY COLUMN `uuid` varchar(50) NOT NULL, MODIFY COLUMN `lastAccess` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, MODIFY COLUMN `lastApi` mediumtext NOT NULL DEFAULT (_utf8mb4''), MODIFY COLUMN `developer` enum('true','false') NOT NULL DEFAULT "false", MODIFY COLUMN `osVersion` mediumtext NOT NULL DEFAULT (_utf8mb4''), MODIFY COLUMN `appVersion` mediumtext NOT NULL DEFAULT (_utf8mb4''), MODIFY COLUMN `counter` int NOT NULL DEFAULT 0, MODIFY COLUMN `pk` longtext NULL, MODIFY COLUMN `pkActive` enum('true','false') NOT NULL DEFAULT "false", ADD INDEX `member` (`member`), ADD UNIQUE INDEX `uuid` (`uuid`), ADD CONSTRAINT `devices_ibfk_1` FOREIGN KEY (`member`) REFERENCES `member` (`member`) ON UPDATE NO ACTION ON DELETE NO ACTION; -- Create "device2stats" table CREATE TABLE `device2stats` ( `device` bigint NOT NULL, `LecturesPersonalActivity` int NOT NULL DEFAULT 0, `CafeteriaActivity` int NOT NULL DEFAULT 0, `WizNavStartActivity` int NOT NULL DEFAULT 0, `NewsActivity` int NOT NULL DEFAULT 0, `StartupActivity` int NOT NULL DEFAULT 0, `MainActivity` int NOT NULL DEFAULT 0, `CalendarActivity` int NOT NULL DEFAULT 0, `WizNavCheckTokenActivity` int NOT NULL DEFAULT 0, `CurriculaActivity` int NOT NULL DEFAULT 0, `CurriculaDetailsActivity` int NOT NULL DEFAULT 0, `GradeChartActivity` int NOT NULL DEFAULT 0, `GradesActivity` int NOT NULL DEFAULT 0, `InformationActivity` int NOT NULL DEFAULT 0, `LecturesAppointmentsActivity` int NOT NULL DEFAULT 0, `LecturesDetailsActivity` int NOT NULL DEFAULT 0, `OpeningHoursDetailActivity` int NOT NULL DEFAULT 0, `OpeningHoursListActivity` int NOT NULL DEFAULT 0, `OrganisationActivity` int NOT NULL DEFAULT 0, `OrganisationDetailsActivity` int NOT NULL DEFAULT 0, `PersonsDetailsActivity` int NOT NULL DEFAULT 0, `PersonsSearchActivity` int NOT NULL DEFAULT 0, `PlansActivity` int NOT NULL DEFAULT 0, `PlansDetailsActivity` int NOT NULL DEFAULT 0, `SetupEduroamActivity` int NOT NULL DEFAULT 0, `TransportationActivity` int NOT NULL DEFAULT 0, `TransportationDetailsActivity` int NOT NULL DEFAULT 0, `TuitionFeesActivity` int NOT NULL DEFAULT 0, `UserPreferencesActivity` int NOT NULL DEFAULT 0, `WizNavExtrasActivity` int NOT NULL DEFAULT 0, `TuitionFeesCard` int NOT NULL DEFAULT 0, `NextLectureCard` int NOT NULL DEFAULT 0, `CafeteriaMenuCard` int NOT NULL DEFAULT 0, `NewsCard1` int NOT NULL DEFAULT 0, `NewsCard2` int NOT NULL DEFAULT 0, `NewsCard3` int NOT NULL DEFAULT 0, `NewsCard7` int NOT NULL DEFAULT 0, PRIMARY KEY (`device`), CONSTRAINT `device2stats_ibfk_2` FOREIGN KEY (`device`) REFERENCES `devices` (`device`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "dishflags" table CREATE TABLE `dishflags` ( `flag` bigint NOT NULL AUTO_INCREMENT, `short` varchar(10) NOT NULL, `description` varchar(50) NOT NULL, PRIMARY KEY (`flag`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "dish2dishflags" table CREATE TABLE `dish2dishflags` ( `dish2dishflags` bigint NOT NULL AUTO_INCREMENT, `dish` bigint NOT NULL, `flag` bigint NOT NULL, PRIMARY KEY (`dish2dishflags`), UNIQUE INDEX `dish` (`dish`, `flag`), INDEX `flag` (`flag`), CONSTRAINT `dish2dishflags_ibfk_1` FOREIGN KEY (`dish`) REFERENCES `dish` (`dish`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `dish2dishflags_ibfk_2` FOREIGN KEY (`flag`) REFERENCES `dishflags` (`flag`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "mensa" table CREATE TABLE `mensa` ( `mensa` bigint NOT NULL AUTO_INCREMENT, `id` int NULL, `name` mediumtext NOT NULL, `address` mediumtext NOT NULL, `latitude` float NOT NULL DEFAULT 0.000000, `longitude` float NOT NULL DEFAULT 0.000000, PRIMARY KEY (`mensa`), UNIQUE INDEX `id` (`id`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 17; -- Create "dish2mensa" table CREATE TABLE `dish2mensa` ( `dish2mensa` bigint NOT NULL AUTO_INCREMENT, `mensa` bigint NOT NULL, `dish` bigint NOT NULL, `date` date NOT NULL, `created` datetime NOT NULL, `modifierd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`dish2mensa`), INDEX `dish` (`dish`), INDEX `mensa` (`mensa`), CONSTRAINT `dish2mensa_ibfk_1` FOREIGN KEY (`mensa`) REFERENCES `mensa` (`mensa`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `dish2mensa_ibfk_2` FOREIGN KEY (`dish`) REFERENCES `dish` (`dish`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "dish_rating" table ALTER TABLE `dish_rating` MODIFY COLUMN `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, ADD INDEX `dish_rating_dish_dish_fk` (`dishID`), DROP FOREIGN KEY `fk_dish_rating_dish`, ADD CONSTRAINT `dish_rating_dish_dish_fk` FOREIGN KEY (`dishID`) REFERENCES `dish` (`dish`) ON UPDATE NO ACTION ON DELETE NO ACTION; -- Modify "files" table ALTER TABLE `files` AUTO_INCREMENT 34761, MODIFY COLUMN `name` text NOT NULL, MODIFY COLUMN `path` text NOT NULL, MODIFY COLUMN `downloads` int NOT NULL DEFAULT 0; -- Modify "kino" table ALTER TABLE `kino` AUTO_INCREMENT 219, MODIFY COLUMN `trailer` text NULL, DROP INDEX `uni_kino_link`, ADD INDEX `cover` (`cover`), ADD UNIQUE INDEX `link` (`link`), DROP FOREIGN KEY `fk_kino_file`, ADD CONSTRAINT `kino_ibfk_1` FOREIGN KEY (`cover`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE; -- Create "actions" table CREATE TABLE `actions` ( `action` bigint NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` mediumtext NOT NULL, `color` varchar(6) NOT NULL, PRIMARY KEY (`action`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 19; -- Create "users" table CREATE TABLE `users` ( `user` bigint NOT NULL AUTO_INCREMENT, `username` varchar(7) NULL, `firstname` varchar(100) NULL, `surname` varchar(100) NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deleted` int NOT NULL DEFAULT 0, `lastActive` int NOT NULL DEFAULT 0, `lastPage` text NULL, `lastLogin` datetime NULL, `tum_id_student` varchar(50) NULL COMMENT "OBFUSCATED_ID_ST", `tum_id_employee` varchar(50) NULL COMMENT "OBFUSCATED_ID_B", `tum_id_alumni` varchar(50) NULL COMMENT "OBFUSCATED_ID_EXT", `tum_id_preferred` varchar(50) NULL COMMENT "OBFUSCATED_ID_BEVORZUGT", PRIMARY KEY (`user`), UNIQUE INDEX `username` (`username`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 434; -- Create "log" table CREATE TABLE `log` ( `log` bigint NOT NULL AUTO_INCREMENT, `time` int NOT NULL, `user_executed` bigint NULL, `user_affected` bigint NULL, `action` bigint NULL, `comment` varchar(255) NOT NULL, PRIMARY KEY (`log`), INDEX `action` (`action`), INDEX `user` (`user_executed`), INDEX `user_affected` (`user_affected`), CONSTRAINT `fkLog2Actions` FOREIGN KEY (`action`) REFERENCES `actions` (`action`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `fkLog2UsersAf` FOREIGN KEY (`user_affected`) REFERENCES `users` (`user`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `fkLog2UsersEx` FOREIGN KEY (`user_executed`) REFERENCES `users` (`user`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "rights" table CREATE TABLE `rights` ( `right` bigint NOT NULL AUTO_INCREMENT, `name` varchar(100) NULL, `description` mediumtext NOT NULL, `category` int NOT NULL DEFAULT 0, PRIMARY KEY (`right`), UNIQUE INDEX `Unquie` (`name`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 14; -- Create "menu" table CREATE TABLE `menu` ( `menu` bigint NOT NULL AUTO_INCREMENT, `right` bigint NULL, `parent` bigint NULL, `name` varchar(255) NULL, `path` varchar(255) NULL, `target` enum('_blank','_self','_parent','_top') NOT NULL DEFAULT "_self", `icon` varchar(200) NOT NULL, `class` varchar(200) NOT NULL, `position` int NOT NULL DEFAULT 0, PRIMARY KEY (`menu`), INDEX `parent` (`parent`), INDEX `right` (`right`), CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`right`) REFERENCES `rights` (`right`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `menu_ibfk_2` FOREIGN KEY (`parent`) REFERENCES `menu` (`menu`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 25; -- Create "modules" table CREATE TABLE `modules` ( `module` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `right` bigint NULL, PRIMARY KEY (`module`), INDEX `module_right` (`right`), CONSTRAINT `fkMod2Rights` FOREIGN KEY (`right`) REFERENCES `rights` (`right`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Modify "newsSource" table ALTER TABLE `newsSource` AUTO_INCREMENT 17, MODIFY COLUMN `title` mediumtext NOT NULL, MODIFY COLUMN `url` mediumtext NULL, MODIFY COLUMN `hook` enum('newspread','impulsivHook') NULL, ADD INDEX `icon` (`icon`), DROP FOREIGN KEY `fk_newsSource_file`, ADD CONSTRAINT `newsSource_ibfk_1` FOREIGN KEY (`icon`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE; -- Modify "news" table ALTER TABLE `news` AUTO_INCREMENT 770113, MODIFY COLUMN `date` datetime NOT NULL, MODIFY COLUMN `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `title` tinytext NOT NULL, MODIFY COLUMN `description` text NOT NULL, MODIFY COLUMN `src` bigint NOT NULL, MODIFY COLUMN `link` varchar(190) NOT NULL, ADD INDEX `file` (`file`), ADD UNIQUE INDEX `link` (`link`), ADD INDEX `src` (`src`), DROP FOREIGN KEY `fk_news_file`, DROP FOREIGN KEY `fk_news_news_source`, ADD CONSTRAINT `news_ibfk_1` FOREIGN KEY (`src`) REFERENCES `newsSource` (`source`) ON UPDATE NO ACTION ON DELETE NO ACTION, ADD CONSTRAINT `news_ibfk_2` FOREIGN KEY (`file`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE; -- Modify "news_alert" table ALTER TABLE `news_alert` MODIFY COLUMN `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `from` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `to` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD INDEX `news_alert_files_file_fk` (`file`), DROP FOREIGN KEY `fk_news_alert_file`, ADD CONSTRAINT `news_alert_files_file_fk` FOREIGN KEY (`file`) REFERENCES `files` (`file`) ON UPDATE NO ACTION ON DELETE CASCADE; -- Modify "notification_type" table ALTER TABLE `notification_type` AUTO_INCREMENT 4, MODIFY COLUMN `confirmation` enum('true','false') NULL; -- Create "location" table CREATE TABLE `location` ( `location` bigint NOT NULL AUTO_INCREMENT, `name` text CHARSET utf8mb4 NULL COLLATE utf8mb4_unicode_ci, `lon` float NOT NULL, `lat` float NOT NULL, `radius` int NOT NULL DEFAULT 1000 COMMENT "in meters", PRIMARY KEY (`location`) ) CHARSET utf8mb3 COLLATE utf8mb3_general_ci AUTO_INCREMENT 2; -- Modify "notification" table ALTER TABLE `notification` AUTO_INCREMENT 107, MODIFY COLUMN `type` bigint NOT NULL, MODIFY COLUMN `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `silent` bool NOT NULL DEFAULT 0, ADD INDEX `location` (`location`), ADD INDEX `type` (`type`), ADD CONSTRAINT `notification_ibfk_1` FOREIGN KEY (`type`) REFERENCES `notification_type` (`type`) ON UPDATE NO ACTION ON DELETE NO ACTION, ADD CONSTRAINT `notification_ibfk_2` FOREIGN KEY (`location`) REFERENCES `location` (`location`) ON UPDATE NO ACTION ON DELETE NO ACTION; -- Modify "notification_confirmation" table ALTER TABLE `notification_confirmation` MODIFY COLUMN `sent` bool NOT NULL DEFAULT 0, MODIFY COLUMN `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD INDEX `device` (`device`), ADD CONSTRAINT `notification_confirmation_ibfk_1` FOREIGN KEY (`notification`) REFERENCES `notification` (`notification`) ON UPDATE NO ACTION ON DELETE NO ACTION, ADD CONSTRAINT `notification_confirmation_ibfk_2` FOREIGN KEY (`device`) REFERENCES `devices` (`device`) ON UPDATE NO ACTION ON DELETE NO ACTION; -- Create "questionAnswers" table CREATE TABLE `questionAnswers` ( `answer` bigint NOT NULL AUTO_INCREMENT, `text` text NULL, PRIMARY KEY (`answer`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 3; -- Create "question" table CREATE TABLE `question` ( `question` bigint NOT NULL AUTO_INCREMENT, `member` bigint NOT NULL, `text` text NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `end` timestamp NULL, PRIMARY KEY (`question`), INDEX `member` (`member`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 282; -- Create "question2answer" table CREATE TABLE `question2answer` ( `question` bigint NOT NULL, `answer` bigint NOT NULL, `member` bigint NOT NULL, UNIQUE INDEX `question` (`question`, `member`), INDEX `question2answer_member_member_fk` (`member`), INDEX `question2answer_questionAnswers_answer_fk` (`answer`), CONSTRAINT `question2answer_member_member_fk` FOREIGN KEY (`member`) REFERENCES `member` (`member`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `question2answer_questionAnswers_answer_fk` FOREIGN KEY (`answer`) REFERENCES `questionAnswers` (`answer`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `question2answer_question_question_fk` FOREIGN KEY (`question`) REFERENCES `question` (`question`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "faculty" table CREATE TABLE `faculty` ( `faculty` bigint NOT NULL AUTO_INCREMENT, `name` varchar(150) NULL COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`faculty`), UNIQUE INDEX `name` (`name`) ) CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci AUTO_INCREMENT 18; -- Create "question2faculty" table CREATE TABLE `question2faculty` ( `question` bigint NOT NULL, `faculty` bigint NOT NULL, PRIMARY KEY (`question`, `faculty`), INDEX `faculty` (`faculty`), CONSTRAINT `question2faculty_ibfk_1` FOREIGN KEY (`question`) REFERENCES `question` (`question`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `question2faculty_ibfk_2` FOREIGN KEY (`faculty`) REFERENCES `faculty` (`faculty`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "recover" table CREATE TABLE `recover` ( `recover` bigint NOT NULL AUTO_INCREMENT, `user` bigint NOT NULL, `created` int NOT NULL, `hash` varchar(190) NOT NULL, `ip` varchar(255) NOT NULL, PRIMARY KEY (`recover`), UNIQUE INDEX `hash` (`hash`), INDEX `user` (`user`), CONSTRAINT `fkRecover2User` FOREIGN KEY (`user`) REFERENCES `users` (`user`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "reports" table CREATE TABLE `reports` ( `report` bigint NOT NULL AUTO_INCREMENT, `device` bigint NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `fixed` enum('true','false') NOT NULL DEFAULT "false", `issue` int NULL, `stacktrace` mediumtext NOT NULL, `stacktraceGroup` text NULL, `log` mediumtext NOT NULL, `package` mediumtext NOT NULL, `packageVersion` mediumtext NOT NULL, `packageVersionCode` int NOT NULL DEFAULT -1, `model` mediumtext NOT NULL, `osVersion` mediumtext NOT NULL, `networkWifi` varchar(10) NOT NULL, `networkMobile` varchar(10) NOT NULL, `gps` varchar(10) NOT NULL, `screenWidth` varchar(100) NOT NULL, `screenHeight` varchar(100) NOT NULL, `screenOrientation` varchar(100) NOT NULL, `screenDpi` varchar(100) NOT NULL, PRIMARY KEY (`report`), INDEX `device` (`device`), CONSTRAINT `reports_ibfk_3` FOREIGN KEY (`device`) REFERENCES `devices` (`device`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "roles" table CREATE TABLE `roles` ( `role` bigint NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` mediumtext NOT NULL, PRIMARY KEY (`role`) ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT 6; -- Create "roles2rights" table CREATE TABLE `roles2rights` ( `role` bigint NOT NULL, `right` bigint NOT NULL, PRIMARY KEY (`role`, `right`), INDEX `fkRight_idx` (`right`), CONSTRAINT `fkRight` FOREIGN KEY (`right`) REFERENCES `rights` (`right`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `fkRole` FOREIGN KEY (`role`) REFERENCES `roles` (`role`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "users2info" table CREATE TABLE `users2info` ( `user` bigint NOT NULL, `firstname` varchar(255) NOT NULL, `surname` varchar(255) NOT NULL, `lastPwChange` int NOT NULL, `pager` int NULL DEFAULT 15, PRIMARY KEY (`user`), CONSTRAINT `fkUsers` FOREIGN KEY (`user`) REFERENCES `users` (`user`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; -- Create "users2roles" table CREATE TABLE `users2roles` ( `user` bigint NOT NULL, `role` bigint NOT NULL, PRIMARY KEY (`user`, `role`), INDEX `fkUser2RolesRole` (`role`), CONSTRAINT `fkUser2RolesRole` FOREIGN KEY (`role`) REFERENCES `roles` (`role`) ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT `fkUser2RolesUser` FOREIGN KEY (`user`) REFERENCES `users` (`user`) ON UPDATE NO ACTION ON DELETE NO ACTION ) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci; ```
Needed from auto to local migration state ```sql -- Modify "" schema ALTER DATABASE COLLATE utf8mb4_0900_ai_ci; -- Modify "cafeteria_rating" table ALTER TABLE `cafeteria_rating` MODIFY COLUMN `timestamp` timestamp NOT NULL; -- Modify "canteen_head_count" table ALTER TABLE `canteen_head_count` MODIFY COLUMN `timestamp` timestamp NOT NULL; -- Modify "crontab" table ALTER TABLE `crontab` MODIFY COLUMN `interval` int NULL DEFAULT 7200, MODIFY COLUMN `lastRun` int NULL DEFAULT 0, MODIFY COLUMN `type` enum('news','mensa','movie','roomfinder','alarm','fileDownload','dishNameDownload','iosNotifications','iosActivityReset','canteenHeadCount','newExamResultsHook','scrapeStudentClubs') NULL; -- Modify "device2stats" table ALTER TABLE `device2stats` DROP FOREIGN KEY `device2stats_ibfk_2`; -- Modify "devices" table ALTER TABLE `devices` MODIFY COLUMN `uuid` varchar(50) NULL, MODIFY COLUMN `lastAccess` timestamp NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `lastApi` text NULL, MODIFY COLUMN `developer` enum('true','false') NULL DEFAULT "false", MODIFY COLUMN `osVersion` text NULL, MODIFY COLUMN `appVersion` text NULL, MODIFY COLUMN `counter` int NULL DEFAULT 0, MODIFY COLUMN `pk` text NULL, MODIFY COLUMN `pkActive` enum('true','false') NULL DEFAULT "false", DROP INDEX `uuid`, DROP FOREIGN KEY `devices_ibfk_1`; -- Modify "dish2dishflags" table ALTER TABLE `dish2dishflags` DROP FOREIGN KEY `dish2dishflags_ibfk_1`, DROP FOREIGN KEY `dish2dishflags_ibfk_2`; -- Modify "dish2mensa" table ALTER TABLE `dish2mensa` DROP FOREIGN KEY `dish2mensa_ibfk_1`, DROP FOREIGN KEY `dish2mensa_ibfk_2`; -- Modify "dish_rating" table ALTER TABLE `dish_rating` MODIFY COLUMN `timestamp` timestamp NOT NULL, ADD INDEX `fk_dish_rating_dish` (`dishID`), DROP FOREIGN KEY `dish_rating_dish_dish_fk`; -- Modify "feedback" table ALTER TABLE `feedback` MODIFY COLUMN `email_id` text NOT NULL, MODIFY COLUMN `receiver` text NOT NULL, MODIFY COLUMN `feedback` text NOT NULL, MODIFY COLUMN `latitude` double NULL, MODIFY COLUMN `longitude` double NULL, MODIFY COLUMN `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP; -- Modify "files" table ALTER TABLE `files` MODIFY COLUMN `name` text NULL, MODIFY COLUMN `path` text NULL, MODIFY COLUMN `downloads` int NULL DEFAULT 0; -- Modify "kino" table ALTER TABLE `kino` MODIFY COLUMN `trailer` longtext NULL, DROP INDEX `link`, ADD INDEX `fk_kino_file` (`cover`), ADD UNIQUE INDEX `uni_kino_link` (`link`), DROP FOREIGN KEY `kino_ibfk_1`; -- Modify "log" table ALTER TABLE `log` DROP FOREIGN KEY `fkLog2Actions`, DROP FOREIGN KEY `fkLog2UsersAf`, DROP FOREIGN KEY `fkLog2UsersEx`; -- Modify "menu" table ALTER TABLE `menu` DROP FOREIGN KEY `menu_ibfk_1`; -- Modify "modules" table ALTER TABLE `modules` DROP FOREIGN KEY `fkMod2Rights`; -- Modify "news" table ALTER TABLE `news` MODIFY COLUMN `date` datetime NULL, MODIFY COLUMN `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `title` text NULL, MODIFY COLUMN `description` text NULL, MODIFY COLUMN `src` bigint NULL, MODIFY COLUMN `link` varchar(190) NULL, DROP INDEX `link`, ADD INDEX `fk_news_file` (`file`), ADD INDEX `fk_news_news_source` (`src`), DROP FOREIGN KEY `news_ibfk_1`, DROP FOREIGN KEY `news_ibfk_2`; -- Modify "newsSource" table ALTER TABLE `newsSource` MODIFY COLUMN `title` text NULL, MODIFY COLUMN `url` text NULL, MODIFY COLUMN `hook` char(1) NULL, ADD INDEX `fk_newsSource_file` (`icon`), DROP FOREIGN KEY `newsSource_ibfk_1`; -- Modify "news_alert" table ALTER TABLE `news_alert` MODIFY COLUMN `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `from` datetime NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `to` datetime NULL DEFAULT CURRENT_TIMESTAMP, ADD INDEX `fk_news_alert_file` (`file`), DROP FOREIGN KEY `news_alert_files_file_fk`; -- Modify "notification" table ALTER TABLE `notification` MODIFY COLUMN `type` int NULL, MODIFY COLUMN `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, MODIFY COLUMN `silent` tinyint NULL DEFAULT 0, DROP FOREIGN KEY `notification_ibfk_1`, DROP FOREIGN KEY `notification_ibfk_2`; -- Modify "notification_confirmation" table ALTER TABLE `notification_confirmation` MODIFY COLUMN `sent` tinyint NULL DEFAULT 0, MODIFY COLUMN `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP, DROP FOREIGN KEY `notification_confirmation_ibfk_1`, DROP FOREIGN KEY `notification_confirmation_ibfk_2`; -- Modify "notification_type" table ALTER TABLE `notification_type` MODIFY COLUMN `confirmation` enum('true','false') NULL DEFAULT "false"; -- Modify "question2answer" table ALTER TABLE `question2answer` DROP FOREIGN KEY `question2answer_member_member_fk`, DROP FOREIGN KEY `question2answer_questionAnswers_answer_fk`, DROP FOREIGN KEY `question2answer_question_question_fk`; -- Modify "question2faculty" table ALTER TABLE `question2faculty` DROP FOREIGN KEY `question2faculty_ibfk_1`, DROP FOREIGN KEY `question2faculty_ibfk_2`; -- Modify "recover" table ALTER TABLE `recover` DROP FOREIGN KEY `fkRecover2User`; -- Modify "reports" table ALTER TABLE `reports` DROP FOREIGN KEY `reports_ibfk_3`; -- Modify "roles2rights" table ALTER TABLE `roles2rights` DROP FOREIGN KEY `fkRight`, DROP FOREIGN KEY `fkRole`; -- Modify "users2info" table ALTER TABLE `users2info` DROP FOREIGN KEY `fkUsers`; -- Modify "users2roles" table ALTER TABLE `users2roles` DROP FOREIGN KEY `fkUser2RolesRole`, DROP FOREIGN KEY `fkUser2RolesUser`; -- Modify "dish_rating" table ALTER TABLE `dish_rating` ADD CONSTRAINT `fk_dish_rating_dish` FOREIGN KEY (`dishID`) REFERENCES `dish` (`dish`) ON UPDATE CASCADE ON DELETE CASCADE; -- Modify "kino" table ALTER TABLE `kino` ADD CONSTRAINT `fk_kino_file` FOREIGN KEY (`cover`) REFERENCES `files` (`file`) ON UPDATE NO ACTION ON DELETE NO ACTION; -- Modify "news" table ALTER TABLE `news` ADD CONSTRAINT `fk_news_file` FOREIGN KEY (`file`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE, ADD CONSTRAINT `fk_news_news_source` FOREIGN KEY (`src`) REFERENCES `newsSource` (`source`) ON UPDATE CASCADE ON DELETE CASCADE; -- Modify "newsSource" table ALTER TABLE `newsSource` ADD CONSTRAINT `fk_newsSource_file` FOREIGN KEY (`icon`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE; -- Modify "news_alert" table ALTER TABLE `news_alert` ADD CONSTRAINT `fk_news_alert_file` FOREIGN KEY (`file`) REFERENCES `files` (`file`) ON UPDATE CASCADE ON DELETE CASCADE; -- Drop "actions" table DROP TABLE `actions`; -- Drop "alarm_ban" table DROP TABLE `alarm_ban`; -- Drop "alarm_log" table DROP TABLE `alarm_log`; -- Drop "barrierFree_moreInfo" table DROP TABLE `barrierFree_moreInfo`; -- Drop "barrierFree_persons" table DROP TABLE `barrierFree_persons`; -- Drop "curricula" table DROP TABLE `curricula`; -- Drop "device2stats" table DROP TABLE `device2stats`; -- Drop "dish2dishflags" table DROP TABLE `dish2dishflags`; -- Drop "dish2mensa" table DROP TABLE `dish2mensa`; -- Drop "dishflags" table DROP TABLE `dishflags`; -- Drop "faculty" table DROP TABLE `faculty`; -- Drop "location" table DROP TABLE `location`; -- Drop "log" table DROP TABLE `log`; -- Drop "member" table DROP TABLE `member`; -- Drop "mensa" table DROP TABLE `mensa`; -- Drop "mensaplan_mensa" table DROP TABLE `mensaplan_mensa`; -- Drop "mensaprices" table DROP TABLE `mensaprices`; -- Drop "menu" table DROP TABLE `menu`; -- Drop "migrations" table DROP TABLE `migrations`; -- Drop "modules" table DROP TABLE `modules`; -- Drop "openinghours" table DROP TABLE `openinghours`; -- Drop "published_exam_results" table DROP TABLE `published_exam_results`; -- Drop "question" table DROP TABLE `question`; -- Drop "question2answer" table DROP TABLE `question2answer`; -- Drop "question2faculty" table DROP TABLE `question2faculty`; -- Drop "questionAnswers" table DROP TABLE `questionAnswers`; -- Drop "recover" table DROP TABLE `recover`; -- Drop "reports" table DROP TABLE `reports`; -- Drop "rights" table DROP TABLE `rights`; -- Drop "roles" table DROP TABLE `roles`; -- Drop "roles2rights" table DROP TABLE `roles2rights`; -- Drop "sessions" table DROP TABLE `sessions`; -- Drop "users" table DROP TABLE `users`; -- Drop "users2info" table DROP TABLE `users2info`; -- Drop "users2roles" table DROP TABLE `users2roles`; -- Drop "wifi_measurement" table DROP TABLE `wifi_measurement`; ```