summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--db/08to09.sql5
-rw-r--r--db/laconica.sql2
2 files changed, 4 insertions, 3 deletions
diff --git a/db/08to09.sql b/db/08to09.sql
index 892df4a39..e8518a98d 100644
--- a/db/08to09.sql
+++ b/db/08to09.sql
@@ -1,2 +1,3 @@
-// SQL commands to update an 0.8.x version of Laconica
-// to 0.9.x.
+alter table notice
+ modify column content text comment 'update content';
+
diff --git a/db/laconica.sql b/db/laconica.sql
index f01107176..8a1027d48 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -110,7 +110,7 @@ create table notice (
id integer auto_increment primary key comment 'unique identifier',
profile_id integer not null comment 'who made the update' references profile (id),
uri varchar(255) unique key comment 'universally unique identifier, usually a tag URI',
- content varchar(140) comment 'update content',
+ content text comment 'update 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',