mirror of
https://github.com/zitadel/zitadel.git
synced 2025-08-11 20:57:31 +00:00

This PR summarizes multiple changes specifically only available with ZITADEL v3: - feat: Web Keys management (https://github.com/zitadel/zitadel/pull/9526) - fix(cmd): ensure proper working of mirror (https://github.com/zitadel/zitadel/pull/9509) - feat(Authz): system user support for permission check v2 (https://github.com/zitadel/zitadel/pull/9640) - chore(license): change from Apache to AGPL (https://github.com/zitadel/zitadel/pull/9597) - feat(console): list v2 sessions (https://github.com/zitadel/zitadel/pull/9539) - fix(console): add loginV2 feature flag (https://github.com/zitadel/zitadel/pull/9682) - fix(feature flags): allow reading "own" flags (https://github.com/zitadel/zitadel/pull/9649) - feat(console): add Actions V2 UI (https://github.com/zitadel/zitadel/pull/9591) BREAKING CHANGE - feat(webkey): migrate to v2beta API (https://github.com/zitadel/zitadel/pull/9445) - chore!: remove CockroachDB Support (https://github.com/zitadel/zitadel/pull/9444) - feat(actions): migrate to v2beta API (https://github.com/zitadel/zitadel/pull/9489) --------- Co-authored-by: Livio Spring <livio.a@gmail.com> Co-authored-by: Stefan Benz <46600784+stebenz@users.noreply.github.com> Co-authored-by: Silvan <27845747+adlerhurst@users.noreply.github.com> Co-authored-by: Ramon <mail@conblem.me> Co-authored-by: Elio Bischof <elio@zitadel.com> Co-authored-by: Kenta Yamaguchi <56732734+KEY60228@users.noreply.github.com> Co-authored-by: Harsha Reddy <harsha.reddy@klaviyo.com> Co-authored-by: Livio Spring <livio@zitadel.com> Co-authored-by: Max Peintner <max@caos.ch> Co-authored-by: Iraq <66622793+kkrime@users.noreply.github.com> Co-authored-by: Florian Forster <florian@zitadel.com> Co-authored-by: Tim Möhlmann <tim+github@zitadel.com> Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com> Co-authored-by: Max Peintner <peintnerm@gmail.com>
31 lines
538 B
SQL
31 lines
538 B
SQL
CREATE TABLE eventstore.events2 (
|
|
instance_id,
|
|
aggregate_type,
|
|
aggregate_id,
|
|
|
|
event_type,
|
|
"sequence",
|
|
revision,
|
|
created_at,
|
|
payload,
|
|
creator,
|
|
"owner",
|
|
|
|
"position",
|
|
in_tx_order
|
|
) AS SELECT
|
|
instance_id,
|
|
aggregate_type,
|
|
aggregate_id,
|
|
|
|
event_type,
|
|
event_sequence,
|
|
substr(aggregate_version, 2)::SMALLINT,
|
|
creation_date,
|
|
event_data,
|
|
editor_user,
|
|
resource_owner,
|
|
|
|
EXTRACT(EPOCH FROM creation_date),
|
|
event_sequence
|
|
FROM eventstore.events_old; |