diff options
| author | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-09-17 15:12:12 +0000 |
|---|---|---|
| committer | marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-09-17 15:12:12 +0000 |
| commit | 91f3e0ae778c61ffae54a680ef357780f161e4b5 (patch) | |
| tree | fe9884182d7d6ed0f18c9117a33caf0603077875 /engine/schema/mysql.sql | |
| parent | 58c550101805a39b0944be3877e0b0988328903a (diff) | |
| download | elgg-91f3e0ae778c61ffae54a680ef357780f161e4b5.tar.gz elgg-91f3e0ae778c61ffae54a680ef357780f161e4b5.tar.bz2 | |
Added hmac cache of hmacs we have seen before (MEMORY TABLE)
git-svn-id: https://code.elgg.org/elgg/trunk@2090 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema/mysql.sql')
| -rw-r--r-- | engine/schema/mysql.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index b9dc633ae..b756ed427 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -264,8 +264,10 @@ CREATE TABLE `prefix_users_apisessions` ( -- HMAC Cache protecting against Replay attacks
CREATE TABLE `prefix_hmac_cache` (
`hmac` varchar(255) NOT NULL,
+ `ts` int(11) NOT NULL,
- PRIMARY KEY (`hmac`)
+ PRIMARY KEY (`hmac`),
+ KEY `ts` (`ts`)
) ENGINE=MEMORY;
-- Datalists for things like db version
|