summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-06-14 12:04:45 -0700
committerEvan Prodromou <evan@controlyourself.ca>2009-06-14 12:04:45 -0700
commit754b610ac4e4478cd36e5826f6bbfcad0531b7aa (patch)
tree4d56846c2740e02d58efb411c113976609219f59
parent7f76c36f24bd51fd4f204f363d5ddf35e9ea9950 (diff)
added group_block table to database
-rw-r--r--db/laconica.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index a11e31692..3ffe1ed81 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -482,3 +482,13 @@ create table file_to_post (
unique(file_id, post_id)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
+
+create table group_block (
+ group_id integer not null comment 'group profile is blocked from' references user_group (id),
+ blocked integer not null comment 'profile that is blocked' references profile (id),
+ blocker integer not null comment 'user making the block' references user (id),
+ modified timestamp comment 'date of blocking',
+
+ constraint primary key (group_id, blocked)
+
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;