diff options
author | M.Gergo | 2019-01-20 11:48:48 +0100 |
---|---|---|
committer | M.Gergo | 2019-01-20 11:48:48 +0100 |
commit | f70027ffbedce10f412868a7bf9b0b67b113f1b1 (patch) | |
tree | fbcc48049f1e66fe3ec66a0f3d8eee47bb400cdb /mayor-orig/install | |
parent | e6988247360fa98b85915a38803d018dd353df00 (diff) | |
download | mayor-f70027ffbedce10f412868a7bf9b0b67b113f1b1.tar.gz mayor-f70027ffbedce10f412868a7bf9b0b67b113f1b1.zip |
Rev: 4423
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; |