search

karthickrmk05 / oauth2-php

Automatically exported from code.google.com/p/oauth2-php
MIT License
0 stars 0 forks source link

mysql_create_tables.sql should allow scope to be NULL #6

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
The table tokens does not allow scope to be NULL, but in the function 
"store_access_token" scope is set to null if no other value is passed.

A better way to create the table would be:

CREATE TABLE `tokens` (
`id` VARCHAR( 40 ) NOT NULL ,
`client_id` VARCHAR( 20 ) NOT NULL ,
`expires` INT NOT NULL ,
`scope` VARCHAR( 200 ) NULL ,
PRIMARY KEY ( `id` )
)

Original issue reported on code.google.com by eriksso...@gmail.com on 22 Sep 2010 at 12:07

GoogleCodeExporter commented 8 years ago 
Refer to 
http://code.google.com/p/oauth2-php/source/detail?r=d4e371c900e8fa8f0d59c798ca47
ecca5f579db6, this is now get fixed within latest dev.

Original comment by hswon...@pantarei-design.com on 14 Dec 2010 at 4:45