diff options
Diffstat (limited to 'mayor-orig/install')
| -rw-r--r-- | mayor-orig/install/base/mysql/mayor-login.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mayor-orig/install/base/mysql/mayor-login.sql b/mayor-orig/install/base/mysql/mayor-login.sql index d0f12845..d61e3404 100644 --- a/mayor-orig/install/base/mysql/mayor-login.sql +++ b/mayor-orig/install/base/mysql/mayor-login.sql @@ -182,3 +182,18 @@ CREATE TABLE `eduroam` ( UNIQUE KEY `eduroamUID` (`eduroamUID`), UNIQUE KEY `userAccount` (`userAccount`,`policy`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; + +CREATE TABLE `authToken` ( + `tokenId` int(11) unsigned NOT NULL AUTO_INCREMENT, + `policy` enum('private','parent','public') COLLATE utf8_hungarian_ci NOT NULL, + `userAccount` varchar(32) COLLATE utf8_hungarian_ci NOT NULL, + `userCn` varchar(64) COLLATE utf8_hungarian_ci NOT NULL, + `studyId` bigint(20) unsigned DEFAULT NULL, + `selector` char(16) COLLATE utf8_hungarian_ci DEFAULT NULL, + `token` char(64) COLLATE utf8_hungarian_ci DEFAULT NULL, + `expires` datetime DEFAULT NULL, + `ipAddress` varchar(64) COLLATE utf8_hungarian_ci DEFAULT NULL, + `activity` datetime DEFAULT NULL, + PRIMARY KEY (`tokenId`), + UNIQUE KEY `selector` (`selector`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci; |