From: Radek Czajka Date: Fri, 28 Aug 2026 12:59:04 +0000 (+0200) Subject: add view X-Git-Url: https://git.mdrn.pl/cas.git/commitdiff_plain/04510504d07bdc83bfe8a9559604b1663ce10cf1 add view --- diff --git a/src/emails/migrations/0005_create_view.py b/src/emails/migrations/0005_create_view.py new file mode 100644 index 0000000..485df4e --- /dev/null +++ b/src/emails/migrations/0005_create_view.py @@ -0,0 +1,27 @@ +# Generated by Django 4.2.16 on 2026-08-28 12:48 + +from django.db import migrations + + +CREATE_VIEW = """ +CREATE VIEW emails_sharedmailbox_v AS +SELECT + sm.name AS from_user, + u.username AS to_user +FROM emails_sharedmailbox_users g +JOIN auth_user u ON u.id = g.user_id +JOIN emails_sharedmailbox sm ON sm.id = g.sharedmailbox_id; +""" + +DROP_VIEW = "DROP VIEW IF EXISTS emails_sharedmailbox_v;" + + +class Migration(migrations.Migration): + + dependencies = [ + ('emails', '0004_sharedmailbox'), + ] + + operations = [ + migrations.RunSQL(CREATE_VIEW, reverse_sql=DROP_VIEW), + ]