summaryrefslogtreecommitdiff
path: root/src/main/resources/db
diff options
context:
space:
mode:
authorMatthias Andreas Benkard <code@mail.matthias.benkard.de>2020-11-03 06:16:17 +0100
committerMatthias Andreas Benkard <code@mail.matthias.benkard.de>2020-11-03 06:49:44 +0100
commitff358945f2b210f7f374d3e3e7e36170ee16aed5 (patch)
tree5f7300b2e3cc9686847b3495ae2b48c579eeb9a2 /src/main/resources/db
parentba3e58c04e918723233dcc66996399eeeff24007 (diff)
KB68 Newsletter registration and deregistration.
Change-Id: Ic79fe64f03ce887879bffc7623e59cb697065ee6
Diffstat (limited to 'src/main/resources/db')
-rw-r--r--src/main/resources/db/changeLog-1.7.xml14
1 files changed, 14 insertions, 0 deletions
diff --git a/src/main/resources/db/changeLog-1.7.xml b/src/main/resources/db/changeLog-1.7.xml
index 8824115..cfdad49 100644
--- a/src/main/resources/db/changeLog-1.7.xml
+++ b/src/main/resources/db/changeLog-1.7.xml
@@ -52,4 +52,18 @@
</createTable>
</changeSet>
+ <changeSet author="mulk" id="1.7-3">
+ <addColumn tableName="newsletter_subscriptions" schemaName="benki">
+ <column name="registration_key" type="VARCHAR">
+ <constraints unique="true" uniqueConstraintName="newsletter_subscriptions_registration_key_key"/>
+ </column>
+ </addColumn>
+
+ <createIndex tableName="newsletter_subscriptions"
+ schemaName="benki"
+ indexName="newsletter_subscriptions_registration_key_idx">
+ <column name="registration_key"/>
+ </createIndex>
+ </changeSet>
+
</databaseChangeLog>