diff options
| author | Josh Hoyt <josh@janrain.com> | 2006-09-07 23:55:14 +0000 |
|---|---|---|
| committer | Josh Hoyt <josh@janrain.com> | 2006-09-07 23:55:14 +0000 |
| commit | 3f1a808ec947162636862c97907d69a726fa62da (patch) | |
| tree | 5e946c8d4658c3c200d96cd135e89d0a464d1581 | |
| parent | b57fb4a8ae7e07646fbc3ee192a94f60e09fcd2a (diff) | |
| download | php-openid-3f1a808ec947162636862c97907d69a726fa62da.zip php-openid-3f1a808ec947162636862c97907d69a726fa62da.tar.gz php-openid-3f1a808ec947162636862c97907d69a726fa62da.tar.bz2 | |
[project @ Fix MySQLStore nonce SQL]
| -rw-r--r-- | Auth/OpenID/MySQLStore.php | 26 |
1 files changed, 16 insertions, 10 deletions
diff --git a/Auth/OpenID/MySQLStore.php b/Auth/OpenID/MySQLStore.php index 44b5d67..5f2bbc7 100644 --- a/Auth/OpenID/MySQLStore.php +++ b/Auth/OpenID/MySQLStore.php @@ -23,14 +23,23 @@ class Auth_OpenID_MySQLStore extends Auth_OpenID_SQLStore { function setSQL() { $this->sql['nonce_table'] = - "CREATE TABLE %s (server_url VARCHAR(2047), timestamp INTEGER, ". - "salt CHAR(40), UNIQUE (server_url, timestamp, salt)"; + "CREATE TABLE %s (\n". + " server_url VARCHAR(2047),\n". + " timestamp INTEGER,\n". + " salt CHAR(40),\n". + " UNIQUE (server_url(255), timestamp, salt)\n". + ") TYPE=InnoDB"; $this->sql['assoc_table'] = - "CREATE TABLE %s (server_url BLOB, handle VARCHAR(255), ". - "secret BLOB, issued INTEGER, lifetime INTEGER, ". - "assoc_type VARCHAR(64), PRIMARY KEY (server_url(255), handle)) ". - "TYPE=InnoDB"; + "CREATE TABLE %s (\n". + " server_url BLOB,\n". + " handle VARCHAR(255),\n". + " secret BLOB,\n". + " issued INTEGER,\n". + " lifetime INTEGER,\n". + " assoc_type VARCHAR(64),\n". + " PRIMARY KEY (server_url(255), handle)\n". + ") TYPE=InnoDB"; $this->sql['settings_table'] = "CREATE TABLE %s (setting VARCHAR(128) UNIQUE PRIMARY KEY, ". @@ -57,10 +66,7 @@ class Auth_OpenID_MySQLStore extends Auth_OpenID_SQLStore { "DELETE FROM %s WHERE server_url = ? AND handle = ?"; $this->sql['add_nonce'] = - "REPLACE INTO %s (nonce, expires) VALUES (?, ?)"; - - $this->sql['get_nonce'] = - "SELECT * FROM %s WHERE nonce = ?"; + "INSERT INTO %s (server_url, timestamp, salt) VALUES (?, ?, ?)"; } /** |