summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-08-20 17:11:34 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-08-21 06:33:21 -0400
commitd50d24dcf499795f5b697132d9450cf72453feef (patch)
tree3d9311051eea7b97d27453d9d4ff98fe2a69d8bf /db
parentfa6b49ab38ab8588c1505f6f0ac7c96d49295e68 (diff)
update database to allow >140c in group descriptions
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 83bb42e35..4d1830611 100644
--- a/db/08to09.sql
+++ b/db/08to09.sql
@@ -7,3 +7,6 @@ alter table message
alter table profile
modify column bio text comment 'descriptive biography';
+alter table user_group
+ modify column description text comment 'group description';
+
diff --git a/db/laconica.sql b/db/laconica.sql
index 724877f92..56bd4b1e3 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -380,7 +380,7 @@ create table user_group (
nickname varchar(64) unique key comment 'nickname for addressing',
fullname varchar(255) comment 'display name',
homepage varchar(255) comment 'URL, cached so we dont regenerate',
- description varchar(140) comment 'descriptive biography',
+ description text comment 'group description',
location varchar(255) comment 'related physical location, if any',
original_logo varchar(255) comment 'original size logo',