summaryrefslogtreecommitdiffstats
path: root/Auth/OpenID/MySQLStore.php
diff options
context:
space:
mode:
Diffstat (limited to 'Auth/OpenID/MySQLStore.php')
-rw-r--r--Auth/OpenID/MySQLStore.php7
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 = ?";
}
/**