api.sql

Go to the documentation of this file.

 
 
-- 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';