From d7cf7316beaecc6efacc01d56dbb066af8174416 Mon Sep 17 00:00:00 2001
From: redmatrix <redmatrix@redmatrix.me>
Date: Mon, 31 Aug 2015 20:55:25 -0700
Subject: change the likes db structure to make it more easily
 importable/exportable

---
 install/schema_postgres.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 9bda284ac..0b8ed52dc 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -602,6 +602,7 @@ CREATE TABLE "likes" (
   "liker" char(128) NOT NULL DEFAULT '',
   "likee" char(128) NOT NULL DEFAULT '',
   "iid" bigint  NOT NULL DEFAULT '0',
+  "i_mid" char(255) NOT NULL DEFAULT '',
   "verb" text NOT NULL DEFAULT '',
   "target_type" text NOT NULL DEFAULT '',
   "target_id" char(128) NOT NULL DEFAULT '',
@@ -612,6 +613,7 @@ create index "likes_channel_id" on likes ("channel_id");
 create index "likes_liker" on likes ("liker");
 create index "likes_likee" on likes ("likee");
 create index "likes_iid" on likes ("iid");
+create index "likes_i_mid" on likes ("i_mid");
 create index "likes_verb" on likes ("verb");
 create index "likes_target_type" on likes ("target_type");
 create index "likes_target_id" on likes ("target_id");
-- 
cgit v1.2.3

