File manager

File manager - Edit - /var/softaculous/tcexam/tcexam.sql

Back
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: `tcexam1650` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]answers` -- CREATE TABLE `[[dbprefix]]answers` ( `answer_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `answer_question_id` bigint(20) unsigned NOT NULL, `answer_description` text COLLATE utf8_unicode_ci NOT NULL, `answer_explanation` text COLLATE utf8_unicode_ci, `answer_isright` tinyint(1) NOT NULL DEFAULT '0', `answer_enabled` tinyint(1) NOT NULL DEFAULT '0', `answer_position` bigint(20) unsigned DEFAULT NULL, `answer_keyboard_key` smallint(10) unsigned DEFAULT NULL, PRIMARY KEY (`answer_id`), KEY `p_answer_question_id` (`answer_question_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]modules` -- CREATE TABLE `[[dbprefix]]modules` ( `module_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `module_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `module_enabled` tinyint(1) NOT NULL DEFAULT '0', `module_user_id` bigint(20) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`module_id`), UNIQUE KEY `ak_module_name` (`module_name`), KEY `p_module_user_id` (`module_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]modules` -- INSERT INTO `[[dbprefix]]modules` VALUES (1, 'default', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]questions` -- CREATE TABLE `[[dbprefix]]questions` ( `question_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `question_subject_id` bigint(20) unsigned NOT NULL, `question_description` text COLLATE utf8_unicode_ci NOT NULL, `question_explanation` text COLLATE utf8_unicode_ci, `question_type` smallint(3) unsigned NOT NULL DEFAULT '1', `question_difficulty` smallint(6) NOT NULL DEFAULT '1', `question_enabled` tinyint(1) NOT NULL DEFAULT '0', `question_position` bigint(20) unsigned DEFAULT NULL, `question_timer` smallint(10) DEFAULT NULL, `question_fullscreen` tinyint(1) NOT NULL DEFAULT '0', `question_inline_answers` tinyint(1) NOT NULL DEFAULT '0', `question_auto_next` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`question_id`), KEY `p_question_subject_id` (`question_subject_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sessions` -- CREATE TABLE `[[dbprefix]]sessions` ( `cpsession_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `cpsession_expiry` datetime NOT NULL, `cpsession_data` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cpsession_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sslcerts` -- CREATE TABLE `[[dbprefix]]sslcerts` ( `ssl_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `ssl_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `ssl_hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ssl_end_date` datetime NOT NULL, `ssl_enabled` tinyint(1) NOT NULL DEFAULT '0', `ssl_user_id` bigint(20) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`ssl_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]subjects` -- CREATE TABLE `[[dbprefix]]subjects` ( `subject_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_module_id` bigint(20) unsigned NOT NULL DEFAULT '1', `subject_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `subject_description` text COLLATE utf8_unicode_ci, `subject_enabled` tinyint(1) NOT NULL DEFAULT '0', `subject_user_id` bigint(20) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`subject_id`), UNIQUE KEY `ak_subject_name` (`subject_module_id`,`subject_name`), KEY `p_subject_user_id` (`subject_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]testgroups` -- CREATE TABLE `[[dbprefix]]testgroups` ( `tstgrp_test_id` bigint(20) unsigned NOT NULL, `tstgrp_group_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`tstgrp_test_id`,`tstgrp_group_id`), KEY `p_tstgrp_test_id` (`tstgrp_test_id`), KEY `p_tstgrp_group_id` (`tstgrp_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tests` -- CREATE TABLE `[[dbprefix]]tests` ( `test_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `test_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `test_description` text COLLATE utf8_unicode_ci NOT NULL, `test_begin_time` datetime DEFAULT NULL, `test_end_time` datetime DEFAULT NULL, `test_duration_time` smallint(10) unsigned NOT NULL DEFAULT '0', `test_ip_range` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '...', `test_results_to_users` tinyint(1) NOT NULL DEFAULT '0', `test_report_to_users` tinyint(1) NOT NULL DEFAULT '0', `test_score_right` decimal(10,3) DEFAULT '1.000', `test_score_wrong` decimal(10,3) DEFAULT '0.000', `test_score_unanswered` decimal(10,3) DEFAULT '0.000', `test_max_score` decimal(10,3) NOT NULL DEFAULT '0.000', `test_user_id` bigint(20) unsigned NOT NULL DEFAULT '1', `test_score_threshold` decimal(10,3) DEFAULT '0.000', `test_random_questions_select` tinyint(1) NOT NULL DEFAULT '1', `test_random_questions_order` tinyint(1) NOT NULL DEFAULT '1', `test_questions_order_mode` smallint(3) unsigned NOT NULL DEFAULT '0', `test_random_answers_select` tinyint(1) NOT NULL DEFAULT '1', `test_random_answers_order` tinyint(1) NOT NULL DEFAULT '1', `test_answers_order_mode` smallint(3) unsigned NOT NULL DEFAULT '0', `test_comment_enabled` tinyint(1) NOT NULL DEFAULT '1', `test_menu_enabled` tinyint(1) NOT NULL DEFAULT '1', `test_noanswer_enabled` tinyint(1) NOT NULL DEFAULT '1', `test_mcma_radio` tinyint(1) NOT NULL DEFAULT '1', `test_repeatable` tinyint(4) NOT NULL DEFAULT '0', `test_mcma_partial_score` tinyint(1) NOT NULL DEFAULT '1', `test_logout_on_timeout` tinyint(1) NOT NULL DEFAULT '0', `test_password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`test_id`), UNIQUE KEY `ak_test_name` (`test_name`), KEY `p_test_user_id` (`test_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]testsslcerts` -- CREATE TABLE `[[dbprefix]]testsslcerts` ( `tstssl_test_id` bigint(20) unsigned NOT NULL, `tstssl_ssl_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`tstssl_test_id`,`tstssl_ssl_id`), KEY `p_tstssl_test_id` (`tstssl_test_id`), KEY `p_tstssl_ssl_id` (`tstssl_ssl_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tests_logs` -- CREATE TABLE `[[dbprefix]]tests_logs` ( `testlog_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `testlog_testuser_id` bigint(20) unsigned NOT NULL, `testlog_user_ip` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL, `testlog_question_id` bigint(20) unsigned NOT NULL, `testlog_answer_text` text COLLATE utf8_unicode_ci, `testlog_score` decimal(10,3) DEFAULT NULL, `testlog_creation_time` datetime DEFAULT NULL, `testlog_display_time` datetime DEFAULT NULL, `testlog_change_time` datetime DEFAULT NULL, `testlog_reaction_time` bigint(20) unsigned NOT NULL DEFAULT '0', `testlog_order` smallint(6) NOT NULL DEFAULT '1', `testlog_num_answers` smallint(5) unsigned NOT NULL DEFAULT '0', `testlog_comment` text COLLATE utf8_unicode_ci, PRIMARY KEY (`testlog_id`), UNIQUE KEY `ak_testuser_question` (`testlog_testuser_id`,`testlog_question_id`), KEY `p_testlog_question_id` (`testlog_question_id`), KEY `p_testlog_testuser_id` (`testlog_testuser_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tests_logs_answers` -- CREATE TABLE `[[dbprefix]]tests_logs_answers` ( `logansw_testlog_id` bigint(20) unsigned NOT NULL, `logansw_answer_id` bigint(20) unsigned NOT NULL, `logansw_selected` smallint(6) NOT NULL DEFAULT '-1', `logansw_order` smallint(6) NOT NULL DEFAULT '1', `logansw_position` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`logansw_testlog_id`,`logansw_answer_id`), KEY `p_logansw_answer_id` (`logansw_answer_id`), KEY `p_logansw_testlog_id` (`logansw_testlog_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]tests_users` -- CREATE TABLE `[[dbprefix]]tests_users` ( `testuser_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `testuser_test_id` bigint(20) unsigned NOT NULL, `testuser_user_id` bigint(20) unsigned NOT NULL, `testuser_status` smallint(5) unsigned NOT NULL DEFAULT '0', `testuser_creation_time` datetime NOT NULL, `testuser_comment` text COLLATE utf8_unicode_ci, PRIMARY KEY (`testuser_id`), UNIQUE KEY `ak_testuser` (`testuser_test_id`,`testuser_user_id`,`testuser_status`), KEY `p_testuser_user_id` (`testuser_user_id`), KEY `p_testuser_test_id` (`testuser_test_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]testuser_stat` -- CREATE TABLE `[[dbprefix]]testuser_stat` ( `tus_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tus_date` datetime NOT NULL, PRIMARY KEY (`tus_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]test_subjects` -- CREATE TABLE `[[dbprefix]]test_subjects` ( `subjset_tsubset_id` bigint(20) unsigned NOT NULL, `subjset_subject_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`subjset_tsubset_id`,`subjset_subject_id`), KEY `p_subjset_subject_id` (`subjset_subject_id`), KEY `p_subjset_tsubset_id` (`subjset_tsubset_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]test_subject_set` -- CREATE TABLE `[[dbprefix]]test_subject_set` ( `tsubset_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tsubset_test_id` bigint(20) unsigned NOT NULL, `tsubset_type` smallint(6) NOT NULL DEFAULT '1', `tsubset_difficulty` smallint(6) NOT NULL DEFAULT '1', `tsubset_quantity` smallint(6) NOT NULL DEFAULT '1', `tsubset_answers` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`tsubset_id`), KEY `p_tsubset_test_id` (`tsubset_test_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]users` -- CREATE TABLE `[[dbprefix]]users` ( `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `user_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_regdate` datetime NOT NULL, `user_ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL, `user_firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_lastname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_birthdate` date DEFAULT NULL, `user_birthplace` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_regnumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_ssn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_level` smallint(3) unsigned NOT NULL DEFAULT '1', `user_verifycode` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `user_otpkey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `ak_user_name` (`user_name`), UNIQUE KEY `user_verifycode` (`user_verifycode`), UNIQUE KEY `ak_user_regnumber` (`user_regnumber`), UNIQUE KEY `ak_user_ssn` (`user_ssn`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- Dumping data for table `[[dbprefix]]users` -- INSERT INTO `[[dbprefix]]users` VALUES (1, 'anonymous', '$2y$10$Uj0i8eUQibn5S7Q2cl8k8ecAzwrK333uG8PWYe9iqz2kig9Ql36g6', NULL, '2001-01-01 01:01:01', '0.0.0.0', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL), (2, '[[admin_username]]', '[[admin_pass]]', NULL, '2001-01-01 01:01:01', '[[clientip]]', NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_groups` -- CREATE TABLE `[[dbprefix]]user_groups` ( `group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`group_id`), UNIQUE KEY `group_name` (`group_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user_groups` -- INSERT INTO `[[dbprefix]]user_groups` VALUES (1, 'default'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]usrgroups` -- CREATE TABLE `[[dbprefix]]usrgroups` ( `usrgrp_user_id` bigint(20) unsigned NOT NULL, `usrgrp_group_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`usrgrp_user_id`,`usrgrp_group_id`), KEY `p_usrgrp_user_id` (`usrgrp_user_id`), KEY `p_usrgrp_group_id` (`usrgrp_group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]usrgroups` -- INSERT INTO `[[dbprefix]]usrgroups` VALUES (2, 1); -- -- Constraints for dumped tables -- -- -- Constraints for table `[[dbprefix]]answers` -- ALTER TABLE `[[dbprefix]]answers` ADD CONSTRAINT `[[dbprefix]]answers_ibfk_1` FOREIGN KEY (`answer_question_id`) REFERENCES `[[dbprefix]]questions` (`question_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]modules` -- ALTER TABLE `[[dbprefix]]modules` ADD CONSTRAINT `[[dbprefix]]modules_ibfk_1` FOREIGN KEY (`module_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]questions` -- ALTER TABLE `[[dbprefix]]questions` ADD CONSTRAINT `[[dbprefix]]questions_ibfk_1` FOREIGN KEY (`question_subject_id`) REFERENCES `[[dbprefix]]subjects` (`subject_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]subjects` -- ALTER TABLE `[[dbprefix]]subjects` ADD CONSTRAINT `[[dbprefix]]subjects_ibfk_1` FOREIGN KEY (`subject_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]subjects_ibfk_2` FOREIGN KEY (`subject_module_id`) REFERENCES `[[dbprefix]]modules` (`module_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]testgroups` -- ALTER TABLE `[[dbprefix]]testgroups` ADD CONSTRAINT `[[dbprefix]]testgroups_ibfk_1` FOREIGN KEY (`tstgrp_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]testgroups_ibfk_2` FOREIGN KEY (`tstgrp_group_id`) REFERENCES `[[dbprefix]]user_groups` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]tests` -- ALTER TABLE `[[dbprefix]]tests` ADD CONSTRAINT `[[dbprefix]]tests_ibfk_1` FOREIGN KEY (`test_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]testsslcerts` -- ALTER TABLE `[[dbprefix]]testsslcerts` ADD CONSTRAINT `[[dbprefix]]testsslcerts_ibfk_1` FOREIGN KEY (`tstssl_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]testsslcerts_ibfk_2` FOREIGN KEY (`tstssl_ssl_id`) REFERENCES `[[dbprefix]]sslcerts` (`ssl_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]tests_logs` -- ALTER TABLE `[[dbprefix]]tests_logs` ADD CONSTRAINT `[[dbprefix]]tests_logs_ibfk_1` FOREIGN KEY (`testlog_question_id`) REFERENCES `[[dbprefix]]questions` (`question_id`) ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]tests_logs_ibfk_2` FOREIGN KEY (`testlog_testuser_id`) REFERENCES `[[dbprefix]]tests_users` (`testuser_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]tests_logs_answers` -- ALTER TABLE `[[dbprefix]]tests_logs_answers` ADD CONSTRAINT `[[dbprefix]]tests_logs_answers_ibfk_1` FOREIGN KEY (`logansw_answer_id`) REFERENCES `[[dbprefix]]answers` (`answer_id`) ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]tests_logs_answers_ibfk_2` FOREIGN KEY (`logansw_testlog_id`) REFERENCES `[[dbprefix]]tests_logs` (`testlog_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]tests_users` -- ALTER TABLE `[[dbprefix]]tests_users` ADD CONSTRAINT `[[dbprefix]]tests_users_ibfk_1` FOREIGN KEY (`testuser_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]tests_users_ibfk_2` FOREIGN KEY (`testuser_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]test_subjects` -- ALTER TABLE `[[dbprefix]]test_subjects` ADD CONSTRAINT `[[dbprefix]]test_subjects_ibfk_1` FOREIGN KEY (`subjset_subject_id`) REFERENCES `[[dbprefix]]subjects` (`subject_id`) ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]test_subjects_ibfk_2` FOREIGN KEY (`subjset_tsubset_id`) REFERENCES `[[dbprefix]]test_subject_set` (`tsubset_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]test_subject_set` -- ALTER TABLE `[[dbprefix]]test_subject_set` ADD CONSTRAINT `[[dbprefix]]test_subject_set_ibfk_1` FOREIGN KEY (`tsubset_test_id`) REFERENCES `[[dbprefix]]tests` (`test_id`) ON DELETE CASCADE ON UPDATE NO ACTION; -- -- Constraints for table `[[dbprefix]]usrgroups` -- ALTER TABLE `[[dbprefix]]usrgroups` ADD CONSTRAINT `[[dbprefix]]usrgroups_ibfk_1` FOREIGN KEY (`usrgrp_user_id`) REFERENCES `[[dbprefix]]users` (`user_id`) ON DELETE CASCADE ON UPDATE NO ACTION, ADD CONSTRAINT `[[dbprefix]]usrgroups_ibfk_2` FOREIGN KEY (`usrgrp_group_id`) REFERENCES `[[dbprefix]]user_groups` (`group_id`) ON DELETE CASCADE ON UPDATE NO ACTION; /!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 8.0.30 | Generation time: 3.49 | proxy | phpinfo | Settings