24 lines
610 B
MySQL
24 lines
610 B
MySQL
|
|
||
|
|
|
||
|
|
-- used by Alternc_Api_Auth_Sharedsecret
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `sharedsecret` (
|
||
|
|
`uid` int(10) unsigned NOT NULL,
|
||
|
|
`secret` varchar(32) NOT NULL,
|
||
|
|
`application` varchar(255) NOT NULL,
|
||
|
|
PRIMARY KEY (`uid`,`secret`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Shared secrets used by Alternc_Api_Auth_Sharedsecret';
|
||
|
|
|
||
|
|
|
||
|
|
-- used by Alternc_Api_Token
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `token` (
|
||
|
|
`token` varchar(32) NOT NULL,
|
||
|
|
`expire` datetime NOT NULL,
|
||
|
|
`data` text NOT NULL,
|
||
|
|
PRIMARY KEY (`token`),
|
||
|
|
KEY `expire` (`expire`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tokens used by API callers';
|
||
|
|
|
||
|
|
|