Add table posts.

1 files changed, 7 insertions, 6 deletions

diff --git a/schema.sql b/schema.sql
index ae843f8..c555166 100644
--- a/schema.sql
+++ b/schema.sql
@@ -117,10 +117,15 @@ CREATE TABLE wiki_page_revisions(
 );
 
 
-CREATE TABLE bookmarks(
+CREATE TABLE posts(
   id          SERIAL    NOT NULL,
   owner       INTEGER,
   date        TIMESTAMP WITH TIME ZONE DEFAULT now(),
+  PRIMARY KEY(id),
+  FOREIGN KEY(owner) REFERENCES users
+);
+
+CREATE TABLE bookmarks INHERITS posts (
   uri         VARCHAR   NOT NULL,
   title       VARCHAR,
   description VARCHAR,
@@ -137,11 +142,7 @@ CREATE TABLE bookmark_tags(
   FOREIGN KEY(bookmark) REFERENCES bookmarks
 );
 
-
-CREATE TABLE lazychat_messages(
-  id          SERIAL    NOT NULL,
-  author      INTEGER,
-  date        TIMESTAMP WITH TIME ZONE DEFAULT now(),
+CREATE TABLE lazychat_messages INHERITS posts (
   content     VARCHAR,
   format      VARCHAR NOT NULL,
   PRIMARY KEY(id),