diff options
Diffstat (limited to 'Auth/OpenID/MySQLStore.php')
-rw-r--r-- | Auth/OpenID/MySQLStore.php | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/Auth/OpenID/MySQLStore.php b/Auth/OpenID/MySQLStore.php index f89afc6..44b5d67 100644 --- a/Auth/OpenID/MySQLStore.php +++ b/Auth/OpenID/MySQLStore.php @@ -23,8 +23,8 @@ class Auth_OpenID_MySQLStore extends Auth_OpenID_SQLStore { function setSQL() { $this->sql['nonce_table'] = - "CREATE TABLE %s (nonce CHAR(8) UNIQUE PRIMARY KEY, ". - "expires INTEGER) TYPE=InnoDB"; + "CREATE TABLE %s (server_url VARCHAR(2047), timestamp INTEGER, ". + "salt CHAR(40), UNIQUE (server_url, timestamp, salt)"; $this->sql['assoc_table'] = "CREATE TABLE %s (server_url BLOB, handle VARCHAR(255), ". @@ -61,9 +61,6 @@ class Auth_OpenID_MySQLStore extends Auth_OpenID_SQLStore { $this->sql['get_nonce'] = "SELECT * FROM %s WHERE nonce = ?"; - - $this->sql['remove_nonce'] = - "DELETE FROM %s WHERE nonce = ?"; } /** |