summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@prodromou.name>2008-07-31 11:27:31 -0400
committerEvan Prodromou <evan@prodromou.name>2008-07-31 11:27:31 -0400
commit9676315b2eb2d888d9b7333c3f95a524a3e74712 (patch)
tree7aaa1b34624a667c3fac8f868aac8021957e94e6 /db
parent557f56a4a74e41d4b5c1e09e9eb2465529724c3f (diff)
extend length of source for notices
darcs-hash:20080731152731-84dde-dc6bf652c38ae9a52950e65d7cb310f870a70640.gz
Diffstat (limited to 'db')
-rw-r--r--db/laconica.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/db/laconica.sql b/db/laconica.sql
index 5869297cc..69dd4644f 100644
--- a/db/laconica.sql
+++ b/db/laconica.sql
@@ -105,7 +105,7 @@ create table notice (
modified timestamp comment 'date this record was modified',
reply_to integer comment 'notice replied to (usually a guess)' references notice (id),
is_local tinyint default 0 comment 'notice was generated by a user',
- source varchar(8) comment 'source of comment, like "web", "im", or "clientname"',
+ source varchar(32) comment 'source of comment, like "web", "im", or "clientname"',
index notice_profile_id_idx (profile_id),
index notice_created_idx (created),
@@ -113,7 +113,7 @@ create table notice (
) ENGINE=MyISAM;
create table notice_source (
- code varchar(8) primary key not null comment 'source code',
+ code varchar(32) primary key not null comment 'source code',
name varchar(255) not null comment 'name of the source',
url varchar(255) not null comment 'url to link to',
created datetime not null comment 'date this record was created',