summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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 cad095169..83bb42e35 100644
--- a/db/08to09.sql
+++ b/db/08to09.sql
@@ -4,3 +4,6 @@ alter table notice
alter table message
modify column content text comment 'message content';
+alter table profile
+ modify column bio text comment 'descriptive biography';
+
diff --git a/db/laconica.sql b/db/laconica.sql
index a59c5fe76..724877f92 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -6,7 +6,7 @@ create table profile (
fullname varchar(255) comment 'display name',
profileurl varchar(255) comment 'URL, cached so we dont regenerate',
homepage varchar(255) comment 'identifying URL',
- bio varchar(140) comment 'descriptive biography',
+ bio text comment 'descriptive biography',
location varchar(255) comment 'physical location',
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified',