summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-08-20 16:53:00 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-08-21 06:33:20 -0400
commitd94a4eae8a68014c2f78ede52364d410c274cbbf (patch)
tree33e907a7efd47a5f45a78ebe6894156d6d832405 /db
parentc8b3557802733f4eb60bad18638298d9acfadf8c (diff)
update database to allow large posts
Diffstat (limited to 'db')
-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',