View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15546 | Feature requests | Central participant database | public | 2019-11-07 19:48 | 2019-11-18 19:04 |
Reporter | marksim | Assigned To | |||
Priority | none | Severity | feature | ||
Status | new | Resolution | open | ||
Summary | 15546: In order to use JWT as token -> increase field | ||||
Description | For authentication purpose at any 3rd party system, the usage of JWT is quite common. Obstacles expected w/ mysql: Solution: CREATE TABLE | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Story point estimate | |||||
Users affected % | |||||
As the blog did some fancy formatting with my input (but didn't tell about using markups), I have attached plain SQL for mysql. create_token.sql (1,041 bytes)
CREATE TABLE `tokens_123456` ( `tid` int(11) NOT NULL AUTO_INCREMENT, `participant_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `firstname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, `lastname` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL, `email` text COLLATE utf8_unicode_ci, `emailstatus` text COLLATE utf8_unicode_ci, `token` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL, `language` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `blacklisted` varchar(17) COLLATE utf8_unicode_ci DEFAULT NULL, `sent` varchar(17) COLLATE utf8_unicode_ci DEFAULT 'N', `remindersent` varchar(17) COLLATE utf8_unicode_ci DEFAULT 'N', `remindercount` int(11) DEFAULT '0', `completed` varchar(17) COLLATE utf8_unicode_ci DEFAULT 'N', `usesleft` int(11) DEFAULT '1', `validfrom` datetime DEFAULT NULL, `validuntil` datetime DEFAULT NULL, `mpid` int(11) DEFAULT NULL, PRIMARY KEY (`tid`), KEY `idx_token_token_123456` (`token`(72)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
Thanks for reporting! |
|
at least field length of VARCAR 36 would enable the storage of uuid-4 tokens like 123e4567-e89b-12d3-a456-426655440000 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2019-11-07 19:48 | marksim | New Issue | |
2019-11-07 19:53 | marksim | File Added: create_token.sql | |
2019-11-07 19:53 | marksim | Note Added: 54475 | |
2019-11-07 21:10 | f_funke | Note Added: 54476 | |
2019-11-18 19:04 | conjoint | Note Added: 54662 | |
2019-11-18 19:04 | conjoint | Issue Monitored: conjoint |