U6xDqqxQ

1DROP TABLE IF EXISTS `oauth_token`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `oauth_token` (
5`entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
6`consumer_id` int(10) unsigned NOT NULL COMMENT 'Consumer ID',
7`admin_id` int(10) unsigned DEFAULT NULL COMMENT 'Admin user ID',
8`customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer user ID',
9`type` varchar(16) NOT NULL COMMENT 'Token Type',
10`token` varchar(32) NOT NULL COMMENT 'Token',
11`secret` varchar(32) NOT NULL COMMENT 'Token Secret',
12`verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
13`callback_url` varchar(255) NOT NULL COMMENT 'Token Callback URL',
14`revoked` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token revoked',
15`authorized` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token authorized',
16`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Token creation         timestamp',
17PRIMARY KEY (`entity_id`),
18UNIQUE KEY `UNQ_OAUTH_TOKEN_TOKEN` (`token`),
19KEY `IDX_OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
20KEY `FK_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` (`admin_id`),
21KEY `FK_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
22CONSTRAINT `FK_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`)         REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
23CONSTRAINT `FK_OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY     (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE ON UPDATE     CASCADE,
24CONSTRAINT `FK_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Tokens';
26/*!40101 SET character_set_client = @saved_cs_client */;