summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
diff options
context:
space:
mode:
authorZach Copley <zach@status.net>2010-02-01 20:58:29 +0000
committerZach Copley <zach@status.net>2010-02-02 08:50:01 +0000
commitdf2a08126510445f93eddbebc0551ee44c945fd5 (patch)
tree60bd8e47f64fc728de6b14bde282e40662e8e4d9 /db/statusnet.sql
parentdabfe19098e6d2d5d12ba4a980bc42f40d365a97 (diff)
OAuth app names should be unique.
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r--db/statusnet.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql
index 17de4fd0d..71a6e724c 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -214,7 +214,7 @@ create table oauth_application (
id integer auto_increment primary key comment 'unique identifier',
owner integer not null comment 'owner of the application' references profile (id),
consumer_key varchar(255) not null comment 'application consumer key' references consumer (consumer_key),
- name varchar(255) not null comment 'name of the application',
+ name varchar(255) unique key comment 'name of the application',
description varchar(255) comment 'description of the application',
icon varchar(255) not null comment 'application icon',
source_url varchar(255) comment 'application homepage - used for source link',