Add support for an anonymous OAuth consumer. Note: this requires a

[quix0rs-gnu-social.git] / db / statusnet.sql

diff --git a/db/statusnet.sql b/db/statusnet.sql
index 3f95948e1ed5ede5d9cde05511f78fb49f657021..4ae7e56841a720ffffd290b4a02c558e7a2cced4 100644 (file)
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -231,10 +231,10 @@ create table oauth_application_user (
     profile_id integer not null comment 'user of the application' references profile (id),
     application_id integer not null comment 'id of the application' references oauth_application (id),
     access_type tinyint default 0 comment 'access type, bit 1 = read, bit 2 = write',
     profile_id integer not null comment 'user of the application' references profile (id),
     application_id integer not null comment 'id of the application' references oauth_application (id),
     access_type tinyint default 0 comment 'access type, bit 1 = read, bit 2 = write',

-    token varchar(255) comment 'request or access token',
+    token varchar(255) not null comment 'request or access token',

     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified',
     created datetime not null comment 'date this record was created',
     modified timestamp comment 'date this record was modified',

-    constraint primary key (profile_id, application_id)
+    constraint primary key (profile_id, application_id, token)

 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
 
 /* These are used by JanRain OpenID library */
 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
 
 /* These are used by JanRain OpenID library */