#$@%#$%!

Ngiler SH3LL 360
: / var / softaculous / tcexam /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	63.250.38.10
System	Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User	likhxapw
PHP Version	8.3.30
Software	LiteSpeed
Doc root	Writable

Edit File : tcexam.sql \| Size : 19.10 KB
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: `tcexam1661` -- -- -------------------------------------------------------- -- -- 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 /; Back

Edit File : tcexam.sql | Size : 19.10 KB

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: `tcexam1661`
--

-- --------------------------------------------------------

--
-- 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 */;

Back