summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-08-20 17:02:25 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-08-21 06:33:21 -0400
commit4ac0fe009fd1dbc61b8c7c605ba2c5b76e441f06 (patch)
treebe9a009809773269fce40e64590bfdcb9ab1f025
parentd213a8cf90d2c6273b32618ddd2bd1c4c252b332 (diff)
allow unlimited text in messages in DB
-rw-r--r--db/08to09.sql3
-rw-r--r--db/laconica.sql2
2 files changed, 4 insertions, 1 deletions
diff --git a/db/08to09.sql b/db/08to09.sql
index e8518a98d..cad095169 100644
--- a/db/08to09.sql
+++ b/db/08to09.sql
@@ -1,3 +1,6 @@
alter table notice
modify column content text comment 'update content';
+alter table message
+ modify column content text comment 'message content';
+
diff --git a/db/laconica.sql b/db/laconica.sql
index 8a1027d48..a59c5fe76 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -331,7 +331,7 @@ create table message (
uri varchar(255) unique key comment 'universally unique identifier',
from_profile integer not null comment 'who the message is from' references profile (id),
to_profile integer not null comment 'who the message is to' references profile (id),
- content varchar(140) comment 'message content',
+ content text comment 'message content',
rendered text comment 'HTML version of the content',
url varchar(255) comment 'URL of any attachment (image, video, bookmark, whatever)',
created datetime not null comment 'date this record was created',