Add localized texts to Benki post model.

Change-Id: I123cfe2ff06f85dc14c705b21d723d1c68fd2e00

19 files changed, 580 insertions, 85 deletions

diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java
index a659049..256c988 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/Bookmark.java
@@ -1,7 +1,6 @@
 package eu.mulk.mulkcms2.benki.bookmarks;
 
 import eu.mulk.mulkcms2.benki.posts.Post;
-import eu.mulk.mulkcms2.common.markdown.MarkdownConverter;
 import java.util.Set;
 import javax.annotation.CheckForNull;
 import javax.persistence.CollectionTable;
@@ -11,23 +10,14 @@ import javax.persistence.Entity;
 import javax.persistence.FetchType;
 import javax.persistence.JoinColumn;
 import javax.persistence.Table;
-import javax.persistence.Transient;
 
 @Entity
 @Table(name = "bookmarks", schema = "benki")
-public class Bookmark extends Post {
+public class Bookmark extends Post<BookmarkText> {
 
   @Column(name = "uri", nullable = false, length = -1)
   public String uri;
 
-  @Column(name = "title", nullable = true, length = -1)
-  @CheckForNull
-  public String title;
-
-  @Column(name = "description", nullable = true, length = -1)
-  @CheckForNull
-  public String description;
-
   @ElementCollection(fetch = FetchType.LAZY)
   @CollectionTable(
       name = "bookmark_tags",
@@ -36,13 +26,10 @@ public class Bookmark extends Post {
   @Column(name = "tag")
   public Set<String> tags;
 
-  @Transient
   @CheckForNull
-  protected String computeDescriptionHtml() {
-    if (description == null) {
-      return null;
-    }
-    return new MarkdownConverter().htmlify(description);
+  private String getDescription() {
+    var text = getText();
+    return text == null ? null : text.description;
   }
 
   @CheckForNull
@@ -54,7 +41,8 @@ public class Bookmark extends Post {
   @CheckForNull
   @Override
   public String getTitle() {
-    return title;
+    var text = getText();
+    return text == null ? null : text.title;
   }
 
   @Override
@@ -66,4 +54,29 @@ public class Bookmark extends Post {
   public boolean isLazychatMessage() {
     return false;
   }
+
+  public void setTitle(String x) {
+    var text = getText();
+    if (text == null) {
+      text = new BookmarkText();
+      text.post = this;
+      text.language = "";
+      texts.put(text.language, text);
+    }
+
+    text.title = x;
+  }
+
+  public void setDescription(String x) {
+    var text = getText();
+    if (text == null) {
+      text = new BookmarkText();
+      text.post = this;
+      text.language = "";
+      texts.put(text.language, text);
+    }
+
+    text.description = x;
+    text.cachedDescriptionHtml = null;
+  }
 }
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java
index f81ed04..bb39be9 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkResource.java
@@ -66,9 +66,9 @@ public class BookmarkResource extends PostResource {
 
     var bookmark = new Bookmark();
     bookmark.uri = uri.toString();
-    bookmark.title = title;
     bookmark.tags = Set.of();
-    bookmark.description = description;
+    bookmark.setTitle(title);
+    bookmark.setDescription(description);
     bookmark.owner = user;
     bookmark.date = OffsetDateTime.now();
 
@@ -106,10 +106,9 @@ public class BookmarkResource extends PostResource {
     }
 
     bookmark.uri = uri.toString();
-    bookmark.title = title;
     bookmark.tags = Set.of();
-    bookmark.description = description;
-    bookmark.cachedDescriptionHtml = null;
+    bookmark.setTitle(title);
+    bookmark.setDescription(description);
     bookmark.owner = user;
 
     assignPostTargets(visibility, user, bookmark);
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java
new file mode 100644
index 0000000..c30f3df
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkText.java
@@ -0,0 +1,31 @@
+package eu.mulk.mulkcms2.benki.bookmarks;
+
+import eu.mulk.mulkcms2.benki.posts.PostText;
+import eu.mulk.mulkcms2.common.markdown.MarkdownConverter;
+import javax.annotation.CheckForNull;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import javax.persistence.Transient;
+
+@Entity
+@Table(name = "bookmark_texts", schema = "benki")
+public class BookmarkText extends PostText<Bookmark> {
+
+  @Column(name = "title", nullable = true, length = -1)
+  @CheckForNull
+  public String title;
+
+  @Column(name = "description", nullable = true, length = -1)
+  @CheckForNull
+  public String description;
+
+  @Transient
+  @CheckForNull
+  protected String computeDescriptionHtml() {
+    if (description == null) {
+      return null;
+    }
+    return new MarkdownConverter().htmlify(description);
+  }
+}
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java
new file mode 100644
index 0000000..92bda99
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/bookmarks/BookmarkTextPK.java
@@ -0,0 +1,54 @@
+package eu.mulk.mulkcms2.benki.bookmarks;
+
+import java.io.Serializable;
+import java.util.Objects;
+import javax.persistence.Column;
+import javax.persistence.FetchType;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+
+public class BookmarkTextPK implements Serializable {
+
+  @Id
+  @Column(name = "language", nullable = false, length = -1)
+  private String language;
+
+  @ManyToOne(fetch = FetchType.LAZY)
+  @JoinColumn(name = "bookmark", referencedColumnName = "id", nullable = false)
+  private Bookmark bookmark;
+
+  public String getLanguage() {
+    return language;
+  }
+
+  public void setLanguage(String language) {
+    this.language = language;
+  }
+
+  public Bookmark getBookmark() {
+    return bookmark;
+  }
+
+  public void setBookmark(Bookmark bookmark) {
+    this.bookmark = bookmark;
+  }
+
+  @Override
+  public boolean equals(Object o) {
+    if (this == o) {
+      return true;
+    }
+    if (!(o instanceof BookmarkTextPK)) {
+      return false;
+    }
+    BookmarkTextPK that = (BookmarkTextPK) o;
+    return Objects.equals(getBookmark(), that.getBookmark())
+        && getLanguage().equals(that.getLanguage());
+  }
+
+  @Override
+  public int hashCode() {
+    return Objects.hash(getBookmark(), getLanguage());
+  }
+}
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java
index 5cec6aa..aa5b6eb 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessage.java
@@ -1,11 +1,9 @@
 package eu.mulk.mulkcms2.benki.lazychat;
 
 import eu.mulk.mulkcms2.benki.posts.Post;
-import eu.mulk.mulkcms2.common.markdown.MarkdownConverter;
 import java.util.Collection;
 import javax.annotation.CheckForNull;
 import javax.json.bind.annotation.JsonbTransient;
-import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.FetchType;
 import javax.persistence.OneToMany;
@@ -14,14 +12,7 @@ import javax.persistence.Transient;
 
 @Entity
 @Table(name = "lazychat_messages", schema = "benki")
-public class LazychatMessage extends Post {
-
-  @Column(name = "content", nullable = true, length = -1)
-  @CheckForNull
-  public String content;
-
-  @Column(name = "format", nullable = false, length = -1)
-  public String format;
+public class LazychatMessage extends Post<LazychatMessageText> {
 
   @OneToMany(mappedBy = "referrer", fetch = FetchType.LAZY)
   @JsonbTransient
@@ -46,16 +37,6 @@ public class LazychatMessage extends Post {
     return null;
   }
 
-  @CheckForNull
-  @Override
-  @JsonbTransient
-  protected String computeDescriptionHtml() {
-    if (content == null) {
-      return null;
-    }
-    return new MarkdownConverter().htmlify(content);
-  }
-
   @Override
   public boolean isBookmark() {
     return false;
@@ -65,4 +46,17 @@ public class LazychatMessage extends Post {
   public boolean isLazychatMessage() {
     return true;
   }
+
+  public void setContent(String x) {
+    var text = getText();
+    if (text == null) {
+      text = new LazychatMessageText();
+      text.post = this;
+      text.language = "";
+      texts.put(text.language, text);
+    }
+
+    text.cachedDescriptionHtml = null;
+    text.content = x;
+  }
 }
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java
new file mode 100644
index 0000000..1a60877
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageText.java
@@ -0,0 +1,28 @@
+package eu.mulk.mulkcms2.benki.lazychat;
+
+import eu.mulk.mulkcms2.benki.posts.PostText;
+import eu.mulk.mulkcms2.common.markdown.MarkdownConverter;
+import javax.annotation.CheckForNull;
+import javax.json.bind.annotation.JsonbTransient;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.Table;
+
+@Entity
+@Table(name = "lazychat_message_texts", schema = "benki")
+public class LazychatMessageText extends PostText<LazychatMessage> {
+
+  @Column(name = "content", nullable = true, length = -1)
+  @CheckForNull
+  public String content;
+
+  @CheckForNull
+  @Override
+  @JsonbTransient
+  protected String computeDescriptionHtml() {
+    if (content == null) {
+      return null;
+    }
+    return new MarkdownConverter().htmlify(content);
+  }
+}
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java
new file mode 100644
index 0000000..33063b1
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatMessageTextPK.java
@@ -0,0 +1,54 @@
+package eu.mulk.mulkcms2.benki.lazychat;
+
+import java.io.Serializable;
+import java.util.Objects;
+import javax.persistence.Column;
+import javax.persistence.FetchType;
+import javax.persistence.Id;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+
+public class LazychatMessageTextPK implements Serializable {
+
+  @ManyToOne(fetch = FetchType.LAZY)
+  @JoinColumn(name = "lazychat_message", referencedColumnName = "id", nullable = false)
+  public LazychatMessage lazychatMessage;
+
+  @Id
+  @Column(name = "language", nullable = false, length = -1)
+  private String language;
+
+  public LazychatMessage getLazychatMessage() {
+    return lazychatMessage;
+  }
+
+  public void setLazychatMessageId(LazychatMessage lazychatMessage) {
+    this.lazychatMessage = lazychatMessage;
+  }
+
+  public String getLanguage() {
+    return language;
+  }
+
+  public void setLanguage(String language) {
+    this.language = language;
+  }
+
+  @Override
+  public boolean equals(Object o) {
+    if (this == o) {
+      return true;
+    }
+    if (!(o instanceof LazychatMessageTextPK)) {
+      return false;
+    }
+    LazychatMessageTextPK that = (LazychatMessageTextPK) o;
+    return Objects.equals(getLazychatMessage(), that.getLazychatMessage())
+        && getLanguage().equals(that.getLanguage());
+  }
+
+  @Override
+  public int hashCode() {
+    return Objects.hash(getLazychatMessage(), getLanguage());
+  }
+}
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java
index 156b638..270a3d0 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/lazychat/LazychatResource.java
@@ -45,8 +45,7 @@ public class LazychatResource extends PostResource {
     var user = Objects.requireNonNull(getCurrentUser());
 
     var message = new LazychatMessage();
-    message.content = text;
-    message.format = "markdown";
+    message.setContent(text);
     message.owner = user;
     message.date = OffsetDateTime.now();
 
@@ -81,9 +80,7 @@ public class LazychatResource extends PostResource {
       throw new ForbiddenException();
     }
 
-    message.content = text;
-    message.cachedDescriptionHtml = null;
-    message.format = "markdown";
+    message.setContent(text);
 
     assignPostTargets(visibility, user, message);
 
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java
index 2bd9ade..8f2166c 100644
--- a/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java
+++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/Post.java
@@ -1,5 +1,7 @@
 package eu.mulk.mulkcms2.benki.posts;
 
+import static java.util.stream.Collectors.toList;
+
 import eu.mulk.mulkcms2.benki.accesscontrol.Role;
 import eu.mulk.mulkcms2.benki.bookmarks.Bookmark;
 import eu.mulk.mulkcms2.benki.lazychat.LazychatMessage;
@@ -10,7 +12,9 @@ import java.time.LocalDate;
 import java.time.OffsetDateTime;
 import java.util.ArrayList;
 import java.util.Comparator;
+import java.util.HashMap;
 import java.util.List;
+import java.util.Map;
 import java.util.Objects;
 import java.util.Set;
 import java.util.TimeZone;
@@ -18,6 +22,7 @@ import java.util.stream.Collectors;
 import javax.annotation.CheckForNull;
 import javax.annotation.Nullable;
 import javax.json.bind.annotation.JsonbTransient;
+import javax.persistence.CascadeType;
 import javax.persistence.Column;
 import javax.persistence.Entity;
 import javax.persistence.FetchType;
@@ -30,6 +35,8 @@ import javax.persistence.JoinColumn;
 import javax.persistence.JoinTable;
 import javax.persistence.ManyToMany;
 import javax.persistence.ManyToOne;
+import javax.persistence.MapKey;
+import javax.persistence.OneToMany;
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
 import javax.persistence.criteria.CriteriaBuilder;
@@ -43,12 +50,10 @@ import org.jboss.logging.Logger;
 @Entity
 @Table(name = "posts", schema = "benki")
 @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
-public abstract class Post extends PanacheEntityBase {
+public abstract class Post<Text extends PostText<?>> extends PanacheEntityBase {
 
   private static final Logger log = Logger.getLogger(Post.class);
 
-  private static final int DESCRIPTION_CACHE_VERSION = 1;
-
   @Id
   @SequenceGenerator(
       allocationSize = 1,
@@ -63,14 +68,6 @@ public abstract class Post extends PanacheEntityBase {
   @CheckForNull
   public OffsetDateTime date;
 
-  @Column(name = "cached_description_version", nullable = true)
-  @CheckForNull
-  public Integer cachedDescriptionVersion;
-
-  @Column(name = "cached_description_html", nullable = true)
-  @CheckForNull
-  public String cachedDescriptionHtml;
-
   @ManyToOne(fetch = FetchType.LAZY)
   @JoinColumn(name = "owner", referencedColumnName = "id")
   @CheckForNull
@@ -95,6 +92,18 @@ public abstract class Post extends PanacheEntityBase {
   @JsonbTransient
   public Set<Role> targets;
 
+  @OneToMany(
+      mappedBy = "post",
+      fetch = FetchType.LAZY,
+      cascade = CascadeType.ALL,
+      targetEntity = PostText.class)
+  @MapKey(name = "language")
+  public Map<String, Text> texts = new HashMap<>();
+
+  public Map<String, Text> getTexts() {
+    return texts;
+  }
+
   public abstract boolean isBookmark();
 
   public abstract boolean isLazychatMessage();
@@ -103,23 +112,6 @@ public abstract class Post extends PanacheEntityBase {
   public abstract String getTitle();
 
   @CheckForNull
-  public final String getDescriptionHtml() {
-    if (cachedDescriptionHtml != null
-        && cachedDescriptionVersion != null
-        && cachedDescriptionVersion >= DESCRIPTION_CACHE_VERSION) {
-      return cachedDescriptionHtml;
-    } else {
-      @CheckForNull var descriptionHtml = computeDescriptionHtml();
-      cachedDescriptionHtml = descriptionHtml;
-      cachedDescriptionVersion = DESCRIPTION_CACHE_VERSION;
-      return descriptionHtml;
-    }
-  }
-
-  @CheckForNull
-  protected abstract String computeDescriptionHtml();
-
-  @CheckForNull
   public abstract String getUri();
 
   public Visibility getVisibility() {
@@ -195,7 +187,16 @@ public abstract class Post extends PanacheEntityBase {
     return getVisibility() == Visibility.PUBLIC || (user != null && visibleTo.contains(user));
   }
 
-  public static class PostPage<T extends Post> {
+  @CheckForNull
+  public final String getDescriptionHtml() {
+    var text = getText();
+    if (text == null) {
+      return null;
+    }
+    return text.getDescriptionHtml();
+  }
+
+  public static class PostPage<T extends Post<? extends PostText>> {
     public @CheckForNull final Integer prevCursor;
     public @CheckForNull final Integer cursor;
     public @CheckForNull final Integer nextCursor;
@@ -229,7 +230,7 @@ public abstract class Post extends PanacheEntityBase {
 
       public void cacheDescriptions() {
         for (var post : posts) {
-          post.getDescriptionHtml();
+          post.getTexts().values().forEach(PostText::getDescriptionHtml);
         }
       }
     }
@@ -245,12 +246,12 @@ public abstract class Post extends PanacheEntityBase {
     }
   }
 
-  public static PostPage<Post> findViewable(
+  public static PostPage<Post<? extends PostText>> findViewable(
       PostFilter postFilter, Session session, @CheckForNull User viewer, @CheckForNull User owner) {
     return findViewable(postFilter, session, viewer, owner, null, null);
   }
 
-  public static PostPage<Post> findViewable(
+  public static PostPage<Post<? extends PostText>> findViewable(
       PostFilter postFilter,
       Session session,
       @CheckForNull User viewer,
@@ -271,7 +272,7 @@ public abstract class Post extends PanacheEntityBase {
     return findViewable(entityClass, session, viewer, owner, cursor, count);
   }
 
-  protected static <T extends Post> PostPage<T> findViewable(
+  protected static <T extends Post<? extends PostText>> PostPage<T> findViewable(
       Class<? extends T> entityClass,
       Session session,
       @CheckForNull User viewer,
@@ -316,9 +317,31 @@ public abstract class Post extends PanacheEntityBase {
       }
     }
 
+    // Fetch texts (to avoid n+1 selects).
+    var postIds = forwardResults.stream().map(x -> x.id).collect(toList());
+
+    if (!postIds.isEmpty()) {
+      find("SELECT p FROM Post p LEFT JOIN FETCH p.texts WHERE p.id IN (?1)", postIds).stream()
+          .count();
+    }
+
     return new PostPage<>(prevCursor, cursor, nextCursor, forwardResults);
   }
 
+  @CheckForNull
+  protected Text getText() {
+    var texts = getTexts();
+    if (texts.isEmpty()) {
+      return null;
+    } else if (texts.containsKey("")) {
+      return texts.get("");
+    } else if (texts.containsKey("en")) {
+      return texts.get("en");
+    } else {
+      return texts.values().stream().findAny().get();
+    }
+  }
+
   public enum Visibility {
     PUBLIC,
     SEMIPRIVATE,
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java
new file mode 100644
index 0000000..01753dc
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostText.java
@@ -0,0 +1,61 @@
+package eu.mulk.mulkcms2.benki.posts;
+
+import javax.annotation.CheckForNull;
+import javax.json.bind.annotation.JsonbTransient;
+import javax.persistence.Column;
+import javax.persistence.Entity;
+import javax.persistence.FetchType;
+import javax.persistence.Id;
+import javax.persistence.IdClass;
+import javax.persistence.Inheritance;
+import javax.persistence.InheritanceType;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+import javax.persistence.Table;
+
+@Entity
+@Table(name = "post_texts", schema = "benki")
+@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
+@IdClass(PostTextPK.class)
+public abstract class PostText<OwningPost extends Post<?>> {
+
+  private static final int DESCRIPTION_CACHE_VERSION = 1;
+
+  @Id
+  @Column(name = "post", nullable = false, insertable = false, updatable = false)
+  public int postId;
+
+  @Id
+  @Column(name = "language", nullable = false, length = -1)
+  public String language;
+
+  @Column(name = "cached_description_version", nullable = true)
+  @CheckForNull
+  public Integer cachedDescriptionVersion;
+
+  @Column(name = "cached_description_html", nullable = true)
+  @CheckForNull
+  public String cachedDescriptionHtml;
+
+  @ManyToOne(fetch = FetchType.LAZY, targetEntity = Post.class)
+  @JoinColumn(name = "post", referencedColumnName = "id", nullable = false)
+  @JsonbTransient
+  public OwningPost post;
+
+  @CheckForNull
+  public final String getDescriptionHtml() {
+    if (cachedDescriptionHtml != null
+        && cachedDescriptionVersion != null
+        && cachedDescriptionVersion >= DESCRIPTION_CACHE_VERSION) {
+      return cachedDescriptionHtml;
+    } else {
+      @CheckForNull var descriptionHtml = computeDescriptionHtml();
+      cachedDescriptionHtml = descriptionHtml;
+      cachedDescriptionVersion = DESCRIPTION_CACHE_VERSION;
+      return descriptionHtml;
+    }
+  }
+
+  @CheckForNull
+  protected abstract String computeDescriptionHtml();
+}
diff --git a/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java
new file mode 100644
index 0000000..0a945dd
--- /dev/null
+++ b/src/main/java/eu/mulk/mulkcms2/benki/posts/PostTextPK.java
@@ -0,0 +1,55 @@
+package eu.mulk.mulkcms2.benki.posts;
+
+import java.io.Serializable;
+import java.util.Objects;
+import javax.persistence.Column;
+import javax.persistence.FetchType;
+import javax.persistence.Id;
+import javax.persistence.IdClass;
+import javax.persistence.JoinColumn;
+import javax.persistence.ManyToOne;
+
+@IdClass(PostTextPK.class)
+public class PostTextPK implements Serializable {
+
+  @ManyToOne(fetch = FetchType.LAZY)
+  @JoinColumn(name = "post", referencedColumnName = "id", nullable = false)
+  public Post<?> post;
+
+  @Id
+  @Column(name = "language", nullable = false, length = -1)
+  private String language;
+
+  public Post<?> getPost() {
+    return post;
+  }
+
+  public void setPost(Post post) {
+    this.post = post;
+  }
+
+  public String getLanguage() {
+    return language;
+  }
+
+  public void setLanguage(String language) {
+    this.language = language;
+  }
+
+  @Override
+  public boolean equals(Object o) {
+    if (this == o) {
+      return true;
+    }
+    if (!(o instanceof PostTextPK)) {
+      return false;
+    }
+    PostTextPK that = (PostTextPK) o;
+    return Objects.equals(getPost(), that.getPost()) && getLanguage().equals(that.getLanguage());
+  }
+
+  @Override
+  public int hashCode() {
+    return Objects.hash(getPost(), getLanguage());
+  }
+}
diff --git a/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js b/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js
index 6ecc355..b4d21d3 100644
--- a/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js
+++ b/src/main/resources/META-INF/resources/bookmarks/MlkBookmarkSubmissionForm.js
@@ -173,9 +173,11 @@ export class MlkBookmarkSubmissionForm extends HTMLElement {
 
     let post = await r.json();
     this.uriInput.value = post.uri;
-    this.titleInput.value = post.title;
-    this.descriptionInput.innerText = post.description;
     this.visibilityInput.value = post.visibility;
+    if (post.texts['']) {
+      this.titleInput.value = post.texts[''].title;
+      this.descriptionInput.innerText = post.texts[''].description;
+    }
 
     this.loaded = true;
   }
diff --git a/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js b/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js
index c6334ad..3688527 100644
--- a/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js
+++ b/src/main/resources/META-INF/resources/lazychat/MlkLazychatSubmissionForm.js
@@ -107,8 +107,10 @@ export class MlkLazychatSubmissionForm extends HTMLElement {
     }
 
     let post = await r.json();
-    this.textInput.value = post.content;
     this.visibilityInput.value = post.visibility;
+    if (post.texts['']) {
+      this.textInput.value = post.texts[''].content;
+    }
 
     this.loaded = true;
   }
diff --git a/src/main/resources/db/changeLog-1.2.xml b/src/main/resources/db/changeLog-1.2.xml
new file mode 100644
index 0000000..87ff426
--- /dev/null
+++ b/src/main/resources/db/changeLog-1.2.xml
@@ -0,0 +1,15 @@
+<?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.2-1">
+    <dropColumn tableName="lazychat_messages" schemaName="benki">
+      <column name="format"/>
+    </dropColumn>
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/src/main/resources/db/changeLog-1.3.xml b/src/main/resources/db/changeLog-1.3.xml
new file mode 100644
index 0000000..a0659c0
--- /dev/null
+++ b/src/main/resources/db/changeLog-1.3.xml
@@ -0,0 +1,79 @@
+<?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.3-1">
+    <createTable tableName="lazychat_message_texts" schemaName="benki">
+      <column name="lazychat_message" type="integer">
+        <constraints
+          nullable="false"
+          primaryKeyName="lazychat_message_texts_pkey"
+          primaryKey="true"
+          foreignKeyName="lazychat_message_texts_lazychat_message_fkey"
+          referencedTableSchemaName="benki"
+          referencedTableName="lazychat_messages"
+          referencedColumnNames="id"/>
+      </column>
+
+      <column name="language" type="varchar">
+        <constraints
+          nullable="false"
+          primaryKeyName="lazychat_message_texts_pkey"
+          primaryKey="true"
+          checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/>
+      </column>
+
+      <column name="content" type="varchar">
+        <constraints nullable="false"/>
+      </column>
+    </createTable>
+
+    <sql>
+      insert into benki.lazychat_message_texts(lazychat_message, language, content)
+        select id, '', content from benki.lazychat_messages;
+    </sql>
+
+    <dropColumn tableName="lazychat_messages" schemaName="benki">
+      <column name="content"/>
+    </dropColumn>
+
+    <createTable tableName="bookmark_texts" schemaName="benki">
+      <column name="bookmark" type="integer">
+        <constraints
+          nullable="false"
+          primaryKeyName="bookmark_texts_pkey"
+          primaryKey="true"
+          foreignKeyName="bookmark_texts_bookmark_fkey"
+          referencedTableSchemaName="benki"
+          referencedTableName="bookmarks"
+          referencedColumnNames="id"/>
+      </column>
+
+      <column name="language" type="varchar">
+        <constraints
+          nullable="false"
+          primaryKeyName="bookmark_texts_pkey"
+          primaryKey="true"
+          checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/>
+      </column>
+
+      <column name="title" type="varchar"/>
+      <column name="description" type="varchar"/>
+    </createTable>
+
+    <sql>
+      insert into benki.bookmark_texts(bookmark, language, title, description)
+        select id, '', title, description from benki.bookmarks;
+    </sql>
+
+    <dropColumn tableName="bookmarks" schemaName="benki">
+      <column name="title"/>
+      <column name="description"/>
+    </dropColumn>
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/src/main/resources/db/changeLog-1.4.xml b/src/main/resources/db/changeLog-1.4.xml
new file mode 100644
index 0000000..2e47dab
--- /dev/null
+++ b/src/main/resources/db/changeLog-1.4.xml
@@ -0,0 +1,43 @@
+<?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.3-1">
+    <createTable tableName="post_texts" schemaName="benki">
+      <column name="post" type="integer">
+        <constraints
+          nullable="false"
+          primaryKeyName="post_texts_pkey"
+          primaryKey="true"
+          foreignKeyName="post_texts_post_fkey"
+          referencedTableSchemaName="benki"
+          referencedTableName="posts"
+          referencedColumnNames="id"/>
+      </column>
+
+      <column name="language" type="varchar">
+        <constraints
+          nullable="false"
+          primaryKeyName="lazychat_message_texts_pkey"
+          primaryKey="true"
+          checkConstraint="IN ('', 'de', 'en', 'fr', 'ja', 'la')"/>
+      </column>
+    </createTable>
+
+    <renameColumn tableName="lazychat_message_texts" schemaName="benki" oldColumnName="lazychat_message" newColumnName="post"/>
+    <renameColumn tableName="bookmark_texts" schemaName="benki" oldColumnName="bookmark" newColumnName="post"/>
+
+    <sql>
+      ALTER TABLE benki.lazychat_message_texts INHERIT benki.post_texts;
+    </sql>
+
+    <sql>
+      ALTER TABLE benki.bookmark_texts INHERIT benki.post_texts;
+    </sql>
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/src/main/resources/db/changeLog-1.5.xml b/src/main/resources/db/changeLog-1.5.xml
new file mode 100644
index 0000000..c10beb1
--- /dev/null
+++ b/src/main/resources/db/changeLog-1.5.xml
@@ -0,0 +1,41 @@
+<?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.3-1">
+    <addColumn tableName="bookmark_texts" schemaName="benki">
+      <column name="cached_description_html" type="VARCHAR"/>
+      <column name="cached_description_version" type="INTEGER"/>
+    </addColumn>
+
+    <addColumn tableName="lazychat_message_texts" schemaName="benki">
+      <column name="cached_description_html" type="VARCHAR"/>
+      <column name="cached_description_version" type="INTEGER"/>
+    </addColumn>
+
+    <addColumn tableName="post_texts" schemaName="benki">
+      <column name="cached_description_html" type="VARCHAR"/>
+      <column name="cached_description_version" type="INTEGER"/>
+    </addColumn>
+
+    <dropColumn tableName="posts" schemaName="benki">
+      <column name="cached_description_html"/>
+      <column name="cached_description_version"/>
+    </dropColumn>
+
+    <dropColumn tableName="bookmarks" schemaName="benki">
+      <column name="cached_description_html"/>
+      <column name="cached_description_version"/>
+    </dropColumn>
+
+    <dropColumn tableName="lazychat_messages" schemaName="benki">
+      <column name="cached_description_html"/>
+      <column name="cached_description_version"/>
+    </dropColumn>
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/src/main/resources/db/changeLog.xml b/src/main/resources/db/changeLog.xml
index 7d346aa..1c5c4ea 100644
--- a/src/main/resources/db/changeLog.xml
+++ b/src/main/resources/db/changeLog.xml
@@ -8,5 +8,9 @@
 
   <include file="db/changeLog-1.0.xml"/>
   <include file="db/changeLog-1.1.xml"/>
+  <include file="db/changeLog-1.2.xml"/>
+  <include file="db/changeLog-1.3.xml"/>
+  <include file="db/changeLog-1.4.xml"/>
+  <include file="db/changeLog-1.5.xml"/>
 
 </databaseChangeLog>
diff --git a/src/main/resources/db/liquibase.properties b/src/main/resources/db/liquibase.properties
index 79aca15..38e258c 100644
--- a/src/main/resources/db/liquibase.properties
+++ b/src/main/resources/db/liquibase.properties
@@ -1,3 +1,3 @@
-url = jdbc:postgresql:///mulkcms?currentSchemas=public,benki
+url = jdbc:postgresql://localhost:5432/mulkcms?currentSchemas=public,benki
 changeLogFile = src/main/resources/db/changeLog.xml
 schemas = public,benki