Some small performance tweaks

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 95e96a135a6733013f45145a8f976005aaee960a..8ae1b913b51139ea83cef46becab69f1ef2eb14d 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -231,21 +231,6 @@ CREATE TABLE IF NOT EXISTS `tag` (
         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
 --
@@ -434,20 +419,6 @@ CREATE TABLE IF NOT EXISTS `attach` (
        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
 --
@@ -1378,23 +1349,6 @@ CREATE TABLE IF NOT EXISTS `profile` (
        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
 --
@@ -1486,23 +1440,6 @@ CREATE TABLE IF NOT EXISTS `storage` (
         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
 --