diff options
| author | Matthias Andreas Benkard <code@mail.matthias.benkard.de> | 2020-11-01 12:58:35 +0100 |
|---|---|---|
| committer | Matthias Andreas Benkard <> | 2020-11-01 12:58:35 +0100 |
| commit | ba3e58c04e918723233dcc66996399eeeff24007 (patch) | |
| tree | ece716b5ff12e77ee2eaf0163912ebe49077f0e0 /src/main/resources/db | |
| parent | 8ae23a7fa6202377f957919d763c618859cb0d74 (diff) | |
KB68 Implement newsletter sending.
Change-Id: I1d56e40d7f35d6be77fde1a1e8519a91bd2dc3b8
Diffstat (limited to 'src/main/resources/db')
| -rw-r--r-- | src/main/resources/db/changeLog-1.7.xml | 55 | ||||
| -rw-r--r-- | src/main/resources/db/changeLog.xml | 1 |
2 files changed, 56 insertions, 0 deletions
diff --git a/src/main/resources/db/changeLog-1.7.xml b/src/main/resources/db/changeLog-1.7.xml new file mode 100644 index 0000000..8824115 --- /dev/null +++ b/src/main/resources/db/changeLog-1.7.xml @@ -0,0 +1,55 @@ +<?xml version="1.1" encoding="UTF-8" standalone="no"?> +<databaseChangeLog + xmlns="http://www.liquibase.org/xml/ns/dbchangelog" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation=" + http://www.liquibase.org/xml/ns/dbchangelog + http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.10.xsd"> + + <changeSet author="mulk" id="1.7-1"> + <createTable tableName="newsletters" schemaName="benki"> + <column name="id" type="INTEGER"> + <constraints primaryKeyName="newsletters_pkey" nullable="false" primaryKey="true"/> + </column> + + <column name="date" type="TIMESTAMP WITH TIME ZONE"> + <constraints nullable="false"/> + </column> + </createTable> + + <addColumn tableName="bookmarks" schemaName="benki"> + <column name="newsletter" type="INTEGER"> + <constraints foreignKeyName="bookmarks_newsletter_fkey" references="benki.newsletters(id)"/> + </column> + </addColumn> + + <addColumn tableName="lazychat_messages" schemaName="benki"> + <column name="newsletter" type="INTEGER"> + <constraints foreignKeyName="lazychat_messages_newsletter_fkey" references="benki.newsletters(id)"/> + </column> + </addColumn> + + <addColumn tableName="posts" schemaName="benki"> + <column name="newsletter" type="INTEGER"> + <constraints foreignKeyName="posts_newsletter_fkey" references="benki.newsletters(id)"/> + </column> + </addColumn> + </changeSet> + + <changeSet author="mulk" id="1.7-2"> + <createTable tableName="newsletter_subscriptions" schemaName="benki"> + <column name="id" type="SERIAL" autoIncrement="true"> + <constraints primaryKeyName="newsletter_subscriptions_pkey" nullable="false" primaryKey="true"/> + </column> + + <column name="start_date" type="TIMESTAMP WITH TIME ZONE" defaultValue="now()"> + <constraints nullable="false"/> + </column> + + <column name="email" type="VARCHAR"> + <constraints nullable="false" unique="true" uniqueConstraintName="newsletter_subscriptions_email_key"/> + </column> + </createTable> + </changeSet> + +</databaseChangeLog> diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml index f1c0849..7b4b700 100644 --- a/src/main/resources/db/changeLog.xml +++ b/src/main/resources/db/changeLog.xml @@ -13,5 +13,6 @@ <include file="db/changeLog-1.4.xml"/> <include file="db/changeLog-1.5.xml"/> <include file="db/changeLog-1.6.xml"/> + <include file="db/changeLog-1.7.xml"/> </databaseChangeLog> |