summaryrefslogtreecommitdiff
path: root/db/laconica.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-12-03 17:26:19 -0500
committerEvan Prodromou <evan@controlyourself.ca>2008-12-03 17:26:19 -0500
commitcb93e214f83738e88fd5f1aafc0d82384d2820ed (patch)
tree9679ece6a4e70c01572204fa03f02feedfec831b /db/laconica.sql
parent2670324ca8d868be1c46c54a3af7f3c1ebda31d0 (diff)
add profile block data object
darcs-hash:20081203222619-5ed1f-b313092893c67a3ec1dc92a79aa7fed4ab583729.gz
Diffstat (limited to 'db/laconica.sql')
-rw-r--r--db/laconica.sql9
1 files changed, 9 insertions, 0 deletions
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;