+create table notice_inbox (\r
+\r
+ user_id integer not null /* comment 'user receiving the message' */ references user (id),\r
+ notice_id integer not null /* comment 'notice received' */ references notice (id),\r
+ created datetime not null /* comment 'date the notice was created' */,\r
+ source integer default 1 /* comment 'reason it is in the inbox; 1=subscription' */,\r
+\r
+ primary key (user_id, notice_id)\r
+);\r
+create index notice_inbox_notice_id_idx (notice_id) on notice_inbox using btree(notice_id);\r
+\r
+create table profile_tag (\r
+ tagger integer not null /* comment 'user making the tag' */ references "user" (id),\r
+ tagged integer not null /* comment 'profile tagged' */ references profile (id),\r
+ tag varchar(64) not null /* comment 'hash tag associated with this notice' */,\r
+ modified timestamp /* comment 'date the tag was added' */,\r
+\r
+ primary key (tagger, tagged, tag)\r
+);\r
+create index profile_tag_modified_idx on profile_tag using btree(modified);\r
+create index profile_tag_tagger_tag_idx on profile_tag using btree(tagger,tag);\r
+\r
+create table profile_block (\r
+\r
+ blocker integer not null i/* comment 'user making the block' */ references user (id),\r
+ blocked integer not null /* comment 'profile that is blocked' */ references profile (id),\r
+ modified timestamp /* comment 'date of blocking' */,\r
+\r
+ primary key (blocker, blocked)\r
+\r
+);\r
+\r