e3nEcqMA

1CREATE TABLE `oauth_token` (
2  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity ID' ,
3  `consumer_id` int UNSIGNED NOT NULL COMMENT 'Consumer ID' ,
4  `admin_id` int UNSIGNED NULL COMMENT 'Admin user ID' ,
5  `customer_id` int UNSIGNED NULL COMMENT 'Customer user ID' ,
6  `type` varchar(16) NOT NULL COMMENT 'Token Type' ,
7  `token` varchar(32) NOT NULL COMMENT 'Token' ,
8  `secret` varchar(32) NOT NULL COMMENT 'Token Secret' ,
9  `verifier` varchar(32) NULL COMMENT 'Token Verifier' ,
10  `callback_url` varchar(255) NOT NULL COMMENT 'Token Callback URL' ,
11  `revoked` smallint UNSIGNED NOT NULL default '0' COMMENT 'Is Token revoked' ,
12  `authorized` smallint UNSIGNED NOT NULL default '0' COMMENT 'Is Token authorized' ,
13  `created_at` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT 'Token creation timestamp' ,
14  PRIMARY KEY (`entity_id`),
15  INDEX `IDX_OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
16  UNIQUE `UNQ_OAUTH_TOKEN_TOKEN` (`token`),
17  CONSTRAINT `FK_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
18  CONSTRAINT `FK_OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
19  CONSTRAINT `FK_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
20) COMMENT='OAuth Tokens' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci