INDEX `url` (`url`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='tags and mentions';
---
--- TABLE clients
---
-CREATE TABLE IF NOT EXISTS `clients` (
- `client_id` varchar(20) NOT NULL COMMENT '',
- `pw` varchar(20) NOT NULL DEFAULT '' COMMENT '',
- `redirect_uri` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `name` text COMMENT '',
- `icon` text COMMENT '',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- PRIMARY KEY(`client_id`),
- INDEX `uid` (`uid`),
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
-
--
-- TABLE permissionset
--
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='file attachments';
---
--- TABLE auth_codes
---
-CREATE TABLE IF NOT EXISTS `auth_codes` (
- `id` varchar(40) NOT NULL COMMENT '',
- `client_id` varchar(20) NOT NULL DEFAULT '' COMMENT '',
- `redirect_uri` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `expires` int NOT NULL DEFAULT 0 COMMENT '',
- `scope` varchar(250) NOT NULL DEFAULT '' COMMENT '',
- PRIMARY KEY(`id`),
- INDEX `client_id` (`client_id`),
- FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
-
--
-- TABLE cache
--
FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='user profiles data';
---
--- TABLE profile_check
---
-CREATE TABLE IF NOT EXISTS `profile_check` (
- `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- `cid` int unsigned NOT NULL DEFAULT 0 COMMENT 'contact.id',
- `dfrn_id` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `sec` varchar(255) NOT NULL DEFAULT '' COMMENT '',
- `expire` int unsigned NOT NULL DEFAULT 0 COMMENT '',
- PRIMARY KEY(`id`),
- INDEX `uid` (`uid`),
- INDEX `cid` (`cid`),
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE,
- FOREIGN KEY (`cid`) REFERENCES `contact` (`id`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='DFRN remote auth use';
-
--
-- TABLE profile_field
--
PRIMARY KEY(`id`)
) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Data stored by Database storage backend';
---
--- TABLE tokens
---
-CREATE TABLE IF NOT EXISTS `tokens` (
- `id` varchar(40) NOT NULL COMMENT '',
- `secret` text COMMENT '',
- `client_id` varchar(20) NOT NULL DEFAULT '',
- `expires` int NOT NULL DEFAULT 0 COMMENT '',
- `scope` varchar(200) NOT NULL DEFAULT '' COMMENT '',
- `uid` mediumint unsigned NOT NULL DEFAULT 0 COMMENT 'User id',
- PRIMARY KEY(`id`),
- INDEX `client_id` (`client_id`),
- INDEX `uid` (`uid`),
- FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON UPDATE RESTRICT ON DELETE CASCADE,
- FOREIGN KEY (`uid`) REFERENCES `user` (`uid`) ON UPDATE RESTRICT ON DELETE CASCADE
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='OAuth usage';
-
--
-- TABLE userd
--