summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-08-20 17:07:20 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-08-21 06:33:21 -0400
commit2d6039fb69772dec233df8fbf8fdc2c6d492e86b (patch)
tree1ef6cd4cf6338167371b185416ce92a893e23199 /db
parent4b443089884a30806aa5a3d00665fbd6296ccd43 (diff)
Allow unlimited-size bios in profiles
Diffstat (limited to '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 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',