summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2009-12-11 10:20:32 -0500
committerEvan Prodromou <evan@status.net>2009-12-11 10:20:32 -0500
commit3d06431787430f7102087ee4a8a66319fcb50350 (patch)
tree3cbba321e24381acbca312034fe0f8f764bfd185 /db/statusnet.sql
parent63642dccf1d2ad6a42eafed5d4ede86635b554a2 (diff)
add repeat_of column to notice table
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r--db/statusnet.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql
index 18abcdfdb..6b3c2ca06 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -129,11 +129,13 @@ create table notice (
lon decimal(10,7) comment 'longitude',
location_id integer comment 'location id if possible',
location_ns integer comment 'namespace for location',
+ repeat_of integer comment 'notice this is a repeat of' references notice (id),
index notice_profile_id_idx (profile_id,created,id),
index notice_conversation_idx (conversation),
index notice_created_idx (created),
index notice_replyto_idx (reply_to),
+ index notice_repeatof_idx (repeat_of),
FULLTEXT(content)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;