-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Aug 19, 2022 at 10:32 AM -- Server version: 8.0.30-0ubuntu0.20.04.2 -- PHP Version: 7.4.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `bdev` -- -- -------------------------------------------------------- -- -- Table structure for table `board` -- CREATE TABLE `board` ( `id` int NOT NULL, `category_id` int NOT NULL, `last_active_user_id` int DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `active` tinyint(1) NOT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `priority` int DEFAULT NULL, `plots_no` int DEFAULT NULL, `posts_no` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `board_board` -- CREATE TABLE `board_board` ( `board_source` int NOT NULL, `board_target` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `box` -- CREATE TABLE `box` ( `id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `engine` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, `html` longtext COLLATE utf8mb4_unicode_ci, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `box` -- INSERT INTO `box` (`id`, `name`, `engine`, `html`, `updated_at`, `created_at`) VALUES (21, 'User statistics', 'UserStats', NULL, '2022-08-19 10:31:19', '2022-08-19 10:31:19'), (22, 'Custom box', 'CustomBox', '
This is custom box example
', '2022-08-19 10:31:19', '2022-08-19 10:31:19'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) DEFAULT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `priority` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `doctrine_migration_versions` -- CREATE TABLE `doctrine_migration_versions` ( `version` varchar(191) COLLATE utf8mb3_unicode_ci NOT NULL, `executed_at` datetime DEFAULT NULL, `execution_time` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; -- -- Dumping data for table `doctrine_migration_versions` -- INSERT INTO `doctrine_migration_versions` (`version`, `executed_at`, `execution_time`) VALUES ('DoctrineMigrations\\Version20220609064526', '2022-07-07 14:11:34', 2899), ('DoctrineMigrations\\Version20220629084457', '2022-07-07 14:11:37', 213), ('DoctrineMigrations\\Version20220629084746', '2022-07-07 14:11:37', 48), ('DoctrineMigrations\\Version20220629111956', '2022-07-07 14:11:37', 73), ('DoctrineMigrations\\Version20220629113633', '2022-07-07 14:11:37', 47), ('DoctrineMigrations\\Version20220706082931', '2022-07-07 14:11:37', 41), ('DoctrineMigrations\\Version20220706090027', '2022-07-07 14:11:37', 220), ('DoctrineMigrations\\Version20220707080208', '2022-07-07 14:11:38', 72), ('DoctrineMigrations\\Version20220802070845', '2022-08-02 09:09:52', 1270), ('DoctrineMigrations\\Version20220803103947', '2022-08-03 12:42:37', 712); -- -------------------------------------------------------- -- -- Table structure for table `group` -- CREATE TABLE `group` ( `id` int NOT NULL, `html_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `group_level` int DEFAULT NULL, `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `group` -- INSERT INTO `group` (`id`, `html_code`, `group_name`, `group_level`, `created_at`, `updated_at`) VALUES (1, ' {{username}}', ' Admin', 0, '2022-08-19 10:31:18', '2022-08-19 10:31:18'), (2, ' {{username}}', ' User', 0, '2022-08-19 10:31:18', '2022-08-19 10:31:18'); -- -------------------------------------------------------- -- -- Table structure for table `metafield` -- CREATE TABLE `metafield` ( `id` int NOT NULL, `namespace` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `metafield_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `plugin_id` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `metafield_value` -- CREATE TABLE `metafield_value` ( `id` int NOT NULL, `metafield_id` int DEFAULT NULL, `value` json DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `page` -- CREATE TABLE `page` ( `id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `priority` int DEFAULT NULL, `active` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plot` -- CREATE TABLE `plot` ( `id` int NOT NULL, `board_id` int NOT NULL, `user_id` int DEFAULT NULL, `last_active_user_id` int DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tags` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) NOT NULL, `pinned` tinyint(1) DEFAULT NULL, `pinned_order` int DEFAULT NULL, `locked` tinyint(1) NOT NULL, `hidden` tinyint(1) NOT NULL, `views` int DEFAULT NULL, `stars` double DEFAULT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `post_no` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `plugin` -- CREATE TABLE `plugin` ( `id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `install` tinyint(1) DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `meta` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `snippet` longtext COLLATE utf8mb4_unicode_ci, `events` json DEFAULT NULL, `acp` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `post` -- CREATE TABLE `post` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `plot_id` int NOT NULL, `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `reputation` int DEFAULT NULL, `hidden` tinyint(1) NOT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `post_user` -- CREATE TABLE `post_user` ( `post_id` int NOT NULL, `user_id` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `refresh_tokens` -- CREATE TABLE `refresh_tokens` ( `id` int NOT NULL, `refresh_token` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `valid` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `skin` -- CREATE TABLE `skin` ( `id` int NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `updated_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `skin` -- INSERT INTO `skin` (`id`, `name`, `version`, `author`, `active`, `updated_at`, `created_at`) VALUES (7, 'standard', '1.0', 'PanKrok', 1, '2022-08-19 10:31:18', '2022-08-19 10:31:18'); -- -------------------------------------------------------- -- -- Table structure for table `skin_boxes` -- CREATE TABLE `skin_boxes` ( `id` int NOT NULL, `skin_id` int NOT NULL, `box_id` int NOT NULL, `page` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, `position` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL, `active` tinyint(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int NOT NULL, `user_group_id` int DEFAULT NULL, `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `roles` json NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `banned` tinyint(1) NOT NULL, `verified` tinyint(1) NOT NULL, `acp_enable` tinyint(1) NOT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `posts_no` int NOT NULL, `plots_no` int NOT NULL, `mcp_enable` tinyint(1) DEFAULT NULL, `warn_lvl` int DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '(DC2Type:datetime_immutable)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `user_group_id`, `username`, `roles`, `password`, `email`, `banned`, `verified`, `acp_enable`, `avatar`, `slug`, `posts_no`, `plots_no`, `mcp_enable`, `warn_lvl`, `created_at`) VALUES (5, 1, 'admin', '[\"ROLE_ADMIN\"]', '$2y$13$m9JnX2/lApqBZ8h2piDMCe0Qq3mOVc1d66AlpNYmT9tgc7Yriye6m', 'admin@foo.com', 0, 1, 1, NULL, 'admin', 0, 0, 1, NULL, '2022-08-19 10:31:18'); -- -------------------------------------------------------- -- -- Table structure for table `user_validation` -- CREATE TABLE `user_validation` ( `id` int NOT NULL, `user_id` int DEFAULT NULL, `selector` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `expires_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)', `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `board` -- ALTER TABLE `board` ADD PRIMARY KEY (`id`), ADD KEY `IDX_58562B4712469DE2` (`category_id`), ADD KEY `IDX_58562B474A25660F` (`last_active_user_id`); -- -- Indexes for table `board_board` -- ALTER TABLE `board_board` ADD PRIMARY KEY (`board_source`,`board_target`), ADD KEY `IDX_FAEBCC6CF3943BD4` (`board_source`), ADD KEY `IDX_FAEBCC6CEA716B5B` (`board_target`); -- -- Indexes for table `box` -- ALTER TABLE `box` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `doctrine_migration_versions` -- ALTER TABLE `doctrine_migration_versions` ADD PRIMARY KEY (`version`); -- -- Indexes for table `group` -- ALTER TABLE `group` ADD PRIMARY KEY (`id`); -- -- Indexes for table `metafield` -- ALTER TABLE `metafield` ADD PRIMARY KEY (`id`), ADD KEY `IDX_95764600EC942BCF` (`plugin_id`); -- -- Indexes for table `metafield_value` -- ALTER TABLE `metafield_value` ADD PRIMARY KEY (`id`), ADD KEY `IDX_F5709C1A7904F92F` (`metafield_id`); -- -- Indexes for table `page` -- ALTER TABLE `page` ADD PRIMARY KEY (`id`); -- -- Indexes for table `plot` -- ALTER TABLE `plot` ADD PRIMARY KEY (`id`), ADD KEY `IDX_BEBB8F89E7EC5785` (`board_id`), ADD KEY `IDX_BEBB8F89A76ED395` (`user_id`), ADD KEY `IDX_BEBB8F894A25660F` (`last_active_user_id`); -- -- Indexes for table `plugin` -- ALTER TABLE `plugin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `post` -- ALTER TABLE `post` ADD PRIMARY KEY (`id`), ADD KEY `IDX_5A8A6C8DA76ED395` (`user_id`), ADD KEY `IDX_5A8A6C8D680D0B01` (`plot_id`); -- -- Indexes for table `post_user` -- ALTER TABLE `post_user` ADD PRIMARY KEY (`post_id`,`user_id`), ADD KEY `IDX_44C6B1424B89032C` (`post_id`), ADD KEY `IDX_44C6B142A76ED395` (`user_id`); -- -- Indexes for table `refresh_tokens` -- ALTER TABLE `refresh_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UNIQ_9BACE7E1C74F2195` (`refresh_token`); -- -- Indexes for table `skin` -- ALTER TABLE `skin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `skin_boxes` -- ALTER TABLE `skin_boxes` ADD PRIMARY KEY (`id`), ADD KEY `IDX_C2E43A6AF404637F` (`skin_id`), ADD KEY `IDX_C2E43A6AD8177B3F` (`box_id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UNIQ_8D93D649F85E0677` (`username`), ADD UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`), ADD KEY `IDX_8D93D6491ED93D47` (`user_group_id`); -- -- Indexes for table `user_validation` -- ALTER TABLE `user_validation` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `UNIQ_B1CB9D82A76ED395` (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `board` -- ALTER TABLE `board` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `box` -- ALTER TABLE `box` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `group` -- ALTER TABLE `group` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `metafield` -- ALTER TABLE `metafield` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `metafield_value` -- ALTER TABLE `metafield_value` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `page` -- ALTER TABLE `page` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `plot` -- ALTER TABLE `plot` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `plugin` -- ALTER TABLE `plugin` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `post` -- ALTER TABLE `post` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `refresh_tokens` -- ALTER TABLE `refresh_tokens` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=406; -- -- AUTO_INCREMENT for table `skin` -- ALTER TABLE `skin` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `skin_boxes` -- ALTER TABLE `skin_boxes` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `user_validation` -- ALTER TABLE `user_validation` MODIFY `id` int NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `board` -- ALTER TABLE `board` ADD CONSTRAINT `FK_58562B4712469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`), ADD CONSTRAINT `FK_58562B474A25660F` FOREIGN KEY (`last_active_user_id`) REFERENCES `user` (`id`); -- -- Constraints for table `board_board` -- ALTER TABLE `board_board` ADD CONSTRAINT `FK_FAEBCC6CEA716B5B` FOREIGN KEY (`board_target`) REFERENCES `board` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_FAEBCC6CF3943BD4` FOREIGN KEY (`board_source`) REFERENCES `board` (`id`) ON DELETE CASCADE; -- -- Constraints for table `metafield` -- ALTER TABLE `metafield` ADD CONSTRAINT `FK_95764600EC942BCF` FOREIGN KEY (`plugin_id`) REFERENCES `plugin` (`id`); -- -- Constraints for table `metafield_value` -- ALTER TABLE `metafield_value` ADD CONSTRAINT `FK_F5709C1A7904F92F` FOREIGN KEY (`metafield_id`) REFERENCES `metafield` (`id`); -- -- Constraints for table `plot` -- ALTER TABLE `plot` ADD CONSTRAINT `FK_BEBB8F894A25660F` FOREIGN KEY (`last_active_user_id`) REFERENCES `user` (`id`), ADD CONSTRAINT `FK_BEBB8F89A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`), ADD CONSTRAINT `FK_BEBB8F89E7EC5785` FOREIGN KEY (`board_id`) REFERENCES `board` (`id`); -- -- Constraints for table `post` -- ALTER TABLE `post` ADD CONSTRAINT `FK_5A8A6C8D680D0B01` FOREIGN KEY (`plot_id`) REFERENCES `plot` (`id`), ADD CONSTRAINT `FK_5A8A6C8DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); -- -- Constraints for table `post_user` -- ALTER TABLE `post_user` ADD CONSTRAINT `FK_44C6B1424B89032C` FOREIGN KEY (`post_id`) REFERENCES `post` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `FK_44C6B142A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE; -- -- Constraints for table `skin_boxes` -- ALTER TABLE `skin_boxes` ADD CONSTRAINT `FK_C2E43A6AD8177B3F` FOREIGN KEY (`box_id`) REFERENCES `box` (`id`), ADD CONSTRAINT `FK_C2E43A6AF404637F` FOREIGN KEY (`skin_id`) REFERENCES `skin` (`id`); -- -- Constraints for table `user` -- ALTER TABLE `user` ADD CONSTRAINT `FK_8D93D6491ED93D47` FOREIGN KEY (`user_group_id`) REFERENCES `group` (`id`); -- -- Constraints for table `user_validation` -- ALTER TABLE `user_validation` ADD CONSTRAINT `FK_B1CB9D82A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`); COMMIT; /*!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 */;