From cb93e214f83738e88fd5f1aafc0d82384d2820ed Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Wed, 3 Dec 2008 17:26:19 -0500
Subject: add profile block data object

darcs-hash:20081203222619-5ed1f-b313092893c67a3ec1dc92a79aa7fed4ab583729.gz
---
 db/laconica.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'db/laconica.sql')

diff --git a/db/laconica.sql b/db/laconica.sql
index 3417ef254..50a61c7d9 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -357,3 +357,12 @@ create table profile_tag (
    index profile_tag_tagger_tag_idx (tagger, tag)
 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
 
+create table profile_block (
+
+   blocker integer not null comment 'user making the block' references user (id),
+   blocked integer not null comment 'profile that is blocked' references profile (id),
+   modified timestamp comment 'date of blocking',
+
+   constraint primary key (blocker, blocked)
+
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
-- 
cgit v1.2.3-54-g00ecf