Файловый менеджер - Редактировать - /var/softaculous/wallabag/wallabag.sql
Назад
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `wallabag2610` -- -- -------------------------------------------------------- -- -- Table structure for table `migration_versions` -- CREATE TABLE `migration_versions` ( `version` varchar(192) COLLATE utf8_unicode_ci NOT NULL, `executed_at` datetime DEFAULT NULL, `execution_time` int(11) DEFAULT NULL, PRIMARY KEY (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `migration_versions` -- INSERT INTO `migration_versions` VALUES ('Application\\Migrations\\Version20160401000000', '[[regtime]]', 1907), ('Application\\Migrations\\Version20160410190541', '[[regtime]]', 81), ('Application\\Migrations\\Version20160812120952', '[[regtime]]', 93), ('Application\\Migrations\\Version20160911214952', '[[regtime]]', 10), ('Application\\Migrations\\Version20160916201049', '[[regtime]]', 86), ('Application\\Migrations\\Version20161001072726', '[[regtime]]', 341), ('Application\\Migrations\\Version20161022134138', '[[regtime]]', 710), ('Application\\Migrations\\Version20161024212538', '[[regtime]]', 158), ('Application\\Migrations\\Version20161031132655', '[[regtime]]', 3), ('Application\\Migrations\\Version20161104073720', '[[regtime]]', 51), ('Application\\Migrations\\Version20161106113822', '[[regtime]]', 84), ('Application\\Migrations\\Version20161117071626', '[[regtime]]', 8), ('Application\\Migrations\\Version20161118134328', '[[regtime]]', 78), ('Application\\Migrations\\Version20161122144743', '[[regtime]]', 4), ('Application\\Migrations\\Version20161122203647', '[[regtime]]', 510), ('Application\\Migrations\\Version20161128084725', '[[regtime]]', 93), ('Application\\Migrations\\Version20161128131503', '[[regtime]]', 91), ('Application\\Migrations\\Version20161214094403', '[[regtime]]', 42), ('Application\\Migrations\\Version20170127093841', '[[regtime]]', 88), ('Application\\Migrations\\Version20170327194233', '[[regtime]]', 9), ('Application\\Migrations\\Version20170405182620', '[[regtime]]', 134), ('Application\\Migrations\\Version20170407200919', '[[regtime]]', 102), ('Application\\Migrations\\Version20170420134133', '[[regtime]]', 0), ('Application\\Migrations\\Version20170501115751', '[[regtime]]', 141), ('Application\\Migrations\\Version20170510082609', '[[regtime]]', 22), ('Application\\Migrations\\Version20170511115400', '[[regtime]]', 88), ('Application\\Migrations\\Version20170511211659', '[[regtime]]', 86), ('Application\\Migrations\\Version20170602075214', '[[regtime]]', 4), ('Application\\Migrations\\Version20170719231144', '[[regtime]]', 1), ('Application\\Migrations\\Version20170824113337', '[[regtime]]', 116), ('Application\\Migrations\\Version20171008195606', '[[regtime]]', 61), ('Application\\Migrations\\Version20171105202000', '[[regtime]]', 87), ('Application\\Migrations\\Version20171120163128', '[[regtime]]', 4), ('Application\\Migrations\\Version20171125164500', '[[regtime]]', 4), ('Application\\Migrations\\Version20180405182455', '[[regtime]]', 95), ('Application\\Migrations\\Version20181128203230', '[[regtime]]', 640), ('Application\\Migrations\\Version20181202073750', '[[regtime]]', 167), ('Application\\Migrations\\Version20190117131816', '[[regtime]]', 71), ('Application\\Migrations\\Version20190129120000', '[[regtime]]', 71), ('Application\\Migrations\\Version20190401105353', '[[regtime]]', 125), ('Application\\Migrations\\Version20190425115043', '[[regtime]]', 16), ('Application\\Migrations\\Version20190510141130', '[[regtime]]', 348), ('Application\\Migrations\\Version20190511165128', '[[regtime]]', 126), ('Application\\Migrations\\Version20190601125843', '[[regtime]]', 116), ('Application\\Migrations\\Version20190708122957', '[[regtime]]', 0), ('Application\\Migrations\\Version20190806130304', '[[regtime]]', 235), ('Application\\Migrations\\Version20190808124957', '[[regtime]]', 11), ('Application\\Migrations\\Version20190826204730', '[[regtime]]', 162), ('Application\\Migrations\\Version20200414120227', '[[regtime]]', 0), ('Application\\Migrations\\Version20200428072628', '[[regtime]]', 10), ('Application\\Migrations\\Version20221123132612', '[[regtime]]', 77), ('Application\\Migrations\\Version20221221092957', '[[regtime]]', 69), ('Application\\Migrations\\Version20230613121354', '[[regtime]]', 78); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]annotation` -- CREATE TABLE `[[dbprefix]]annotation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `entry_id` int(11) DEFAULT NULL, `text` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `quote` text COLLATE utf8mb4_unicode_ci NOT NULL, `ranges` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)', PRIMARY KEY (`id`), KEY `IDX_A7AED006A76ED395` (`user_id`), KEY `IDX_A7AED006BA364942` (`entry_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]config` -- CREATE TABLE `[[dbprefix]]config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `items_per_page` int(11) NOT NULL, `language` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `feed_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `feed_limit` int(11) DEFAULT NULL, `reading_speed` double DEFAULT NULL, `pocket_consumer_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `action_mark_as_read` int(11) DEFAULT '0', `list_mode` int(11) DEFAULT NULL, `display_thumbnails` int(11) DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_87E64C53A76ED395` (`user_id`), KEY `config_feed_token` (`feed_token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]config` -- INSERT INTO `[[dbprefix]]config` VALUES (1, 1, 12, '[[language]]', NULL, 50, 200, NULL, 1, 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]entry` -- CREATE TABLE `[[dbprefix]]entry` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `title` longtext COLLATE utf8mb4_unicode_ci, `url` longtext COLLATE utf8mb4_unicode_ci, `is_archived` tinyint(1) NOT NULL, `is_starred` tinyint(1) NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `mimetype` longtext COLLATE utf8mb4_unicode_ci, `language` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reading_time` int(11) NOT NULL, `domain_name` longtext COLLATE utf8mb4_unicode_ci, `preview_picture` longtext COLLATE utf8mb4_unicode_ci, `uid` varchar(23) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `http_status` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `published_at` datetime DEFAULT NULL, `published_by` longtext COLLATE utf8mb4_unicode_ci, `headers` longtext COLLATE utf8mb4_unicode_ci, `starred_at` datetime DEFAULT NULL, `origin_url` longtext COLLATE utf8mb4_unicode_ci, `archived_at` datetime DEFAULT NULL, `hashed_url` tinytext COLLATE utf8mb4_unicode_ci, `given_url` longtext COLLATE utf8mb4_unicode_ci, `hashed_given_url` tinytext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), KEY `IDX_F4D18282A76ED395` (`user_id`), KEY `IDX_entry_created_at` (`created_at`), KEY `IDX_entry_uid` (`uid`), KEY `IDX_entry_starred` (`is_starred`), KEY `IDX_entry_archived` (`is_archived`), KEY `hashed_url_user_id` (`user_id`,`hashed_url`(40)), KEY `hashed_given_url_user_id` (`user_id`,`hashed_given_url`(40)), KEY `user_language` (`language`,`user_id`), KEY `user_archived` (`user_id`,`is_archived`,`archived_at`), KEY `user_created` (`user_id`,`created_at`), KEY `user_starred` (`user_id`,`is_starred`,`starred_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]entry_tag` -- CREATE TABLE `[[dbprefix]]entry_tag` ( `entry_id` int(11) NOT NULL, `tag_id` int(11) NOT NULL, PRIMARY KEY (`entry_id`,`tag_id`), KEY `IDX_C9F0DD7CBA364942` (`entry_id`), KEY `IDX_C9F0DD7CBAD26311` (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]ignore_origin_instance_rule` -- CREATE TABLE `[[dbprefix]]ignore_origin_instance_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ; -- -- Dumping data for table `[[dbprefix]]ignore_origin_instance_rule` -- INSERT INTO `[[dbprefix]]ignore_origin_instance_rule` VALUES (1, 'host = "feedproxy.google.com"'), (2, 'host = "feeds.reuters.com"'), (3, '_all ~ "https?://www\\.lemonde\\.fr/tiny.*"'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]ignore_origin_user_rule` -- CREATE TABLE `[[dbprefix]]ignore_origin_user_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `config_id` int(11) NOT NULL, `rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `idx_config` (`config_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]internal_setting` -- CREATE TABLE `[[dbprefix]]internal_setting` ( `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `value` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, `section` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`name`), UNIQUE KEY `UNIQ_5D9649505E237E06` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]internal_setting` -- INSERT INTO `[[dbprefix]]internal_setting` VALUES ('api_user_registration', '0', 'api'), ('demo_mode_enabled', '0', 'misc'), ('demo_mode_username', 'wallabag', 'misc'), ('diaspora_url', 'https://diasporapod.com', 'entry'), ('download_images_enabled', '0', 'misc'), ('export_csv', '1', 'export'), ('export_epub', '1', 'export'), ('export_json', '1', 'export'), ('export_mobi', '0', 'export'), ('export_pdf', '1', 'export'), ('export_txt', '1', 'export'), ('export_xml', '1', 'export'), ('import_with_rabbitmq', '0', 'import'), ('import_with_redis', '0', 'import'), ('matomo_enabled', '0', 'analytics'), ('matomo_host', 'matomo.wallabag.org', 'analytics'), ('matomo_site_id', '1', 'analytics'), ('restricted_access', '0', 'entry'), ('shaarli_share_origin_url', '0', 'entry'), ('shaarli_url', 'https://myshaarli.com', 'entry'), ('share_diaspora', '1', 'entry'), ('share_mail', '1', 'entry'), ('share_public', '1', 'entry'), ('share_shaarli', '1', 'entry'), ('share_twitter', '1', 'entry'), ('share_unmark', '1', 'entry'), ('show_printlink', '1', 'entry'), ('store_article_headers', '0', 'entry'), ('unmark_url', 'https://unmark.it', 'entry'), ('wallabag_support_url', 'https://www.wallabag.org/pages/support.html', 'misc'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]oauth2_access_tokens` -- CREATE TABLE `[[dbprefix]]oauth2_access_tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `token` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `expires_at` int(11) DEFAULT NULL, `scope` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_368A42095F37A13B` (`token`), KEY `IDX_368A420919EB6921` (`client_id`), KEY `IDX_368A4209A76ED395` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]oauth2_auth_codes` -- CREATE TABLE `[[dbprefix]]oauth2_auth_codes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `token` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `redirect_uri` longtext COLLATE utf8_unicode_ci NOT NULL, `expires_at` int(11) DEFAULT NULL, `scope` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_EE52E3FA5F37A13B` (`token`), KEY `IDX_EE52E3FA19EB6921` (`client_id`), KEY `IDX_EE52E3FAA76ED395` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]oauth2_clients` -- CREATE TABLE `[[dbprefix]]oauth2_clients` ( `id` int(11) NOT NULL AUTO_INCREMENT, `random_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `redirect_uris` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `allowed_grant_types` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `name` longblob NOT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_C7E1A097A76ED395` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]oauth2_refresh_tokens` -- CREATE TABLE `[[dbprefix]]oauth2_refresh_tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `token` varchar(191) COLLATE utf8_unicode_ci NOT NULL, `expires_at` int(11) DEFAULT NULL, `scope` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_20C9FB245F37A13B` (`token`), KEY `IDX_20C9FB2419EB6921` (`client_id`), KEY `IDX_20C9FB24A76ED395` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_credential` -- CREATE TABLE `[[dbprefix]]site_credential` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `host` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `username` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `password` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `createdAt` datetime NOT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tag` -- CREATE TABLE `[[dbprefix]]tag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `label` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_4CA58A8C989D9B62` (`slug`), KEY `tag_label` (`label`(255)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tagging_rule` -- CREATE TABLE `[[dbprefix]]tagging_rule` ( `id` int(11) NOT NULL AUTO_INCREMENT, `config_id` int(11) DEFAULT NULL, `rule` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `tags` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:simple_array)', PRIMARY KEY (`id`), KEY `IDX_2D9B3C5424DB0683` (`config_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user` -- CREATE TABLE `[[dbprefix]]user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `username_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `email_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `enabled` tinyint(1) NOT NULL, `salt` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `last_login` datetime DEFAULT NULL, `confirmation_token` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password_requested_at` datetime DEFAULT NULL, `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)', `name` longtext COLLATE utf8mb4_unicode_ci, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `authCode` int(11) DEFAULT NULL, `emailTwoFactor` tinyint(1) NOT NULL, `googleAuthenticatorSecret` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `backupCodes` json DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_1D63E7E592FC23A8` (`username_canonical`), UNIQUE KEY `UNIQ_1D63E7E5A0D96FBF` (`email_canonical`), UNIQUE KEY `UNIQ_1D63E7E5C05FB297` (`confirmation_token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user` -- INSERT INTO `[[dbprefix]]user` VALUES (1, '[[admin_username]]', '[[admin_username_lower]]', '[[admin_email]]', '[[admin_email_lower]]', 1, '[[salt]]', '[[admin_pass]]', NULL, NULL, NULL, 'a:2:{i:0;s:9:"ROLE_USER";i:1;s:16:"ROLE_SUPER_ADMIN";}', '[[admin_realname]]', '[[regtime]]', '[[regtime]]', NULL, 0, NULL, NULL); -- -- Constraints for dumped tables -- -- -- Constraints for table `[[dbprefix]]annotation` -- ALTER TABLE `[[dbprefix]]annotation` ADD CONSTRAINT `FK_A7AED006A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`), ADD CONSTRAINT `FK_annotation_entry` FOREIGN KEY (`entry_id`) REFERENCES `[[dbprefix]]entry` (`id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]config` -- ALTER TABLE `[[dbprefix]]config` ADD CONSTRAINT `FK_87E64C53A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`); -- -- Constraints for table `[[dbprefix]]entry` -- ALTER TABLE `[[dbprefix]]entry` ADD CONSTRAINT `FK_F4D18282A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`); -- -- Constraints for table `[[dbprefix]]entry_tag` -- ALTER TABLE `[[dbprefix]]entry_tag` ADD CONSTRAINT `FK_entry_tag_entry` FOREIGN KEY (`entry_id`) REFERENCES `[[dbprefix]]entry` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_entry_tag_tag` FOREIGN KEY (`tag_id`) REFERENCES `[[dbprefix]]tag` (`id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]ignore_origin_user_rule` -- ALTER TABLE `[[dbprefix]]ignore_origin_user_rule` ADD CONSTRAINT `fk_config` FOREIGN KEY (`config_id`) REFERENCES `[[dbprefix]]config` (`id`); -- -- Constraints for table `[[dbprefix]]oauth2_access_tokens` -- ALTER TABLE `[[dbprefix]]oauth2_access_tokens` ADD CONSTRAINT `FK_368A420919EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`), ADD CONSTRAINT `FK_368A4209A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]oauth2_auth_codes` -- ALTER TABLE `[[dbprefix]]oauth2_auth_codes` ADD CONSTRAINT `FK_EE52E3FA19EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`), ADD CONSTRAINT `FK_EE52E3FAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]oauth2_clients` -- ALTER TABLE `[[dbprefix]]oauth2_clients` ADD CONSTRAINT `FK_635D765EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`); -- -- Constraints for table `[[dbprefix]]oauth2_refresh_tokens` -- ALTER TABLE `[[dbprefix]]oauth2_refresh_tokens` ADD CONSTRAINT `FK_20C9FB2419EB6921` FOREIGN KEY (`client_id`) REFERENCES `[[dbprefix]]oauth2_clients` (`id`), ADD CONSTRAINT `FK_20C9FB24A76ED395` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]site_credential` -- ALTER TABLE `[[dbprefix]]site_credential` ADD CONSTRAINT `fk_user` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`id`); -- -- Constraints for table `[[dbprefix]]tagging_rule` -- ALTER TABLE `[[dbprefix]]tagging_rule` ADD CONSTRAINT `FK_2D9B3C5424DB0683` FOREIGN KEY (`config_id`) REFERENCES `[[dbprefix]]config` (`id`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Генерация страницы: 1.54 |
proxy
|
phpinfo
|
Настройка