diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2020-11-03 06:16:17 +0100 |
|---|---|---|
| committer | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2020-11-03 06:49:44 +0100 |
| commit | ff358945f2b210f7f374d3e3e7e36170ee16aed5 (patch) | |
| tree | 5f7300b2e3cc9686847b3495ae2b48c579eeb9a2 /src/main/resources/db | |
| parent | ba3e58c04e918723233dcc66996399eeeff24007 (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.xml | 14 |
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> |