diff options
author | Brenda Wallace <shiny@cpan.org> | 2009-12-12 22:47:12 +0000 |
---|---|---|
committer | Brenda Wallace <shiny@cpan.org> | 2009-12-12 22:47:12 +0000 |
commit | 9d3829df9d29581c1d0281e57fda8ba4452ce2c2 (patch) | |
tree | a196e99a9de45a982b76f5c4cef24b7dfc57d21b /db/statusnet.sql | |
parent | a5c11cc92a277c3af6f9b18b1ffaf6dc5f90f5cc (diff) | |
parent | 438a0d7f1c23d176f380d6f5dba181ec54722b83 (diff) |
Merge commit 'origin/0.9.x' into 0.9.x
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r-- | db/statusnet.sql | 13 |
1 files changed, 2 insertions, 11 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql index b500b81f2..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; @@ -585,14 +587,3 @@ create table login_token ( constraint primary key (user_id) ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; -create table forward ( - - profile_id integer not null comment 'profile who forwarded the notice' references profile (id), - notice_id integer not null comment 'notice they forwarded' references notice (id), - - created datetime not null comment 'date this record was created', - - constraint primary key (profile_id, notice_id) - -) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin; - |