diff --git a/resources/wikicaptcha.sql b/resources/wikicaptcha.sql index 91d2a7a..2248201 100644 --- a/resources/wikicaptcha.sql +++ b/resources/wikicaptcha.sql @@ -1,298 +1,246 @@ --- phpMyAdmin SQL Dump --- version 4.6.6deb4 --- https://www.phpmyadmin.net/ +-- MySQL dump 10.17 Distrib 10.3.17-MariaDB, for debian-linux-gnu (x86_64) -- --- Host: localhost:3306 --- Creato il: Nov 23, 2019 alle 23:04 --- Versione del server: 10.3.18-MariaDB-0+deb10u1 --- Versione PHP: 7.3.11-1~deb10u1 - -SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; -SET time_zone = "+00:00"; - +-- Host: localhost Database: wikicaptcha +-- ------------------------------------------------------ +-- Server version 10.3.17-MariaDB-0+deb10u1 /*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- --- Database: `wikicaptcha` +-- Table structure for table `wcaptcha_app` -- --- -------------------------------------------------------- +DROP TABLE IF EXISTS `wcaptcha_app`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `wcaptcha_app` ( + `app_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, + `app_name` varchar(128) NOT NULL, + `app_minquestions` int(11) NOT NULL DEFAULT 2 COMMENT 'Minimum number of good questions', + PRIMARY KEY (`app_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='A CAPTCHA configuration for a specific website'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_app` +-- Table structure for table `wcaptcha_appdomain` -- -CREATE TABLE `wcaptcha_app` ( - `app_ID` int(10) UNSIGNED NOT NULL, - `app_name` varchar(11) NOT NULL, - `app_minquestions` int(11) NOT NULL DEFAULT 2 COMMENT 'Minimum number of good questions' -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A CAPTCHA configuration for a specific website' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- +DROP TABLE IF EXISTS `wcaptcha_appdomain`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `wcaptcha_appdomain` ( + `app_ID` int(10) unsigned NOT NULL, + `domain_ID` int(10) unsigned NOT NULL, + `appdomain_creationdate` datetime NOT NULL, + PRIMARY KEY (`app_ID`,`domain_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_appuser` +-- Table structure for table `wcaptcha_appuser` -- +DROP TABLE IF EXISTS `wcaptcha_appuser`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_appuser` ( - `app_ID` int(10) UNSIGNED NOT NULL, - `user_ID` int(10) UNSIGNED NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Set the App ownership to some User(s)' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- + `app_ID` int(10) unsigned NOT NULL, + `user_ID` int(10) unsigned NOT NULL, + `appuser_creationdate` datetime NOT NULL, + PRIMARY KEY (`app_ID`,`user_ID`), + KEY `user_ID` (`user_ID`), + CONSTRAINT `wcaptcha_appuser_ibfk_1` FOREIGN KEY (`app_ID`) REFERENCES `wcaptcha_app` (`app_ID`) ON DELETE CASCADE, + CONSTRAINT `wcaptcha_appuser_ibfk_2` FOREIGN KEY (`user_ID`) REFERENCES `wcaptcha_user` (`user_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='Set the App ownership to some User(s)'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_challenge` +-- Table structure for table `wcaptcha_challenge` -- +DROP TABLE IF EXISTS `wcaptcha_challenge`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_challenge` ( - `challenge_ID` int(10) UNSIGNED NOT NULL, + `challenge_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `challenge_type` enum('img','text','option') NOT NULL, - `challenge_text` text DEFAULT NULL COMMENT 'Rendered text of the question (if needed)' + `challenge_text` text DEFAULT NULL COMMENT 'Rendered text of the question (if needed)', + PRIMARY KEY (`challenge_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_challenge_connotation` +-- Table structure for table `wcaptcha_challenge_connotation` -- +DROP TABLE IF EXISTS `wcaptcha_challenge_connotation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_challenge_connotation` ( - `challenge_ID` int(10) UNSIGNED NOT NULL, - `connotation_ID` int(10) UNSIGNED NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A Challenge can have multiple Connotations (what are the instance of pig of color red?)' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- + `challenge_ID` int(10) unsigned NOT NULL, + `connotation_ID` int(10) unsigned NOT NULL, + PRIMARY KEY (`challenge_ID`,`connotation_ID`), + KEY `challenge_connotation_ibfk_1` (`connotation_ID`), + CONSTRAINT `wcaptcha_challenge_connotation_ibfk_1` FOREIGN KEY (`challenge_ID`) REFERENCES `wcaptcha_challenge` (`challenge_ID`) ON DELETE CASCADE, + CONSTRAINT `wcaptcha_challenge_connotation_ibfk_2` FOREIGN KEY (`connotation_ID`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='A Challenge can have multiple Connotations (what are the instance of pig of color red?)'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_connotation` +-- Table structure for table `wcaptcha_connotation` -- +DROP TABLE IF EXISTS `wcaptcha_connotation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_connotation` ( - `connotation_ID` int(10) UNSIGNED NOT NULL, - `connotation_type` enum('positive','negative') NOT NULL, + `connotation_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, + `connotation_comment` varchar(128) DEFAULT NULL, `wikidata_property` varchar(32) NOT NULL COMMENT 'Wikidata property', - `wikidata_value` text NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Statements in the form of subject–predicate–object' ROW_FORMAT=COMPACT; + `wikidata_value` text NOT NULL, + PRIMARY KEY (`connotation_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='Statements in the form of subject–predicate–object'; +/*!40101 SET character_set_client = @saved_cs_client */; --- -------------------------------------------------------- +-- +-- Table structure for table `wcaptcha_domain` +-- + +DROP TABLE IF EXISTS `wcaptcha_domain`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `wcaptcha_domain` ( + `domain_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, + `domain_name` varchar(254) NOT NULL, + PRIMARY KEY (`domain_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_image` +-- Table structure for table `wcaptcha_image` -- +DROP TABLE IF EXISTS `wcaptcha_image`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_image` ( - `image_ID` int(10) UNSIGNED NOT NULL, + `image_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `image_src` text NOT NULL, - `commons_pageid` int(10) UNSIGNED DEFAULT NULL + `commons_pageid` int(10) unsigned DEFAULT NULL, + UNIQUE KEY `image_ID` (`image_ID`), + UNIQUE KEY `commons_pageid` (`commons_pageid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - --- -------------------------------------------------------- +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_image_connotation` +-- Table structure for table `wcaptcha_image_connotation` -- +DROP TABLE IF EXISTS `wcaptcha_image_connotation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_image_connotation` ( - `image_ID` int(10) UNSIGNED NOT NULL, - `connotation_ID` int(10) UNSIGNED NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='An Image can have multiple Connotations (this image depicts a toaster and Barack Obama)' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- + `image_ID` int(10) unsigned NOT NULL, + `connotation_ID` int(10) unsigned NOT NULL, + `image_connotation_positive` enum('positive','negative') NOT NULL, + PRIMARY KEY (`image_ID`,`connotation_ID`), + KEY `image_ID` (`image_ID`), + KEY `connotation_ID` (`connotation_ID`), + CONSTRAINT `wcaptcha_image_connotation_ibfk_1` FOREIGN KEY (`connotation_ID`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE, + CONSTRAINT `wcaptcha_image_connotation_ibfk_2` FOREIGN KEY (`image_ID`) REFERENCES `wcaptcha_image` (`image_ID`) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='An Image can have multiple Connotations (this image depicts a toaster and Barack Obama)'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_question` +-- Table structure for table `wcaptcha_question` -- +DROP TABLE IF EXISTS `wcaptcha_question`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_question` ( - `question_ID` int(10) UNSIGNED NOT NULL, - `question_image` int(10) UNSIGNED DEFAULT NULL COMMENT 'If the Challenge was of kind Image', + `question_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, + `question_image` int(10) unsigned DEFAULT NULL COMMENT 'If the Challenge was of kind Image', `question_answer` text DEFAULT NULL COMMENT '1 if yes, -1 if no, 0 if maybe no, string if Challenge kind is text', - `challenge_ID` int(10) UNSIGNED NOT NULL COMMENT 'The Challenge gives the meaning of this Question', - `session_ID` int(10) UNSIGNED NOT NULL COMMENT 'This Question is connected to a precise Session' -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A precise Question, but also its Answer' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- + `challenge_ID` int(10) unsigned NOT NULL COMMENT 'The Challenge gives the meaning of this Question', + `session_ID` int(10) unsigned NOT NULL COMMENT 'This Question is connected to a precise Session', + PRIMARY KEY (`question_ID`), + KEY `session_ID` (`session_ID`), + KEY `challenge_ID` (`challenge_ID`), + KEY `question_image` (`question_image`), + CONSTRAINT `wcaptcha_question_ibfk_2` FOREIGN KEY (`session_ID`) REFERENCES `wcaptcha_session` (`session_ID`), + CONSTRAINT `wcaptcha_question_ibfk_3` FOREIGN KEY (`challenge_ID`) REFERENCES `wcaptcha_challenge` (`challenge_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='A precise Question, but also its Answer'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_session` +-- Table structure for table `wcaptcha_session` -- +DROP TABLE IF EXISTS `wcaptcha_session`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_session` ( - `session_ID` int(10) UNSIGNED NOT NULL, - `session_ip` varchar(16) DEFAULT NULL, - `app_ID` int(10) UNSIGNED NOT NULL + `session_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, + `session_ip` blob DEFAULT NULL, + `app_ID` int(10) unsigned NOT NULL, + PRIMARY KEY (`session_ID`), + KEY `app_ID` (`app_ID`), + CONSTRAINT `wcaptcha_session_ibfk_1` FOREIGN KEY (`app_ID`) REFERENCES `wcaptcha_app` (`app_ID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - --- -------------------------------------------------------- +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_taxonomy` +-- Table structure for table `wcaptcha_taxonomy` -- +DROP TABLE IF EXISTS `wcaptcha_taxonomy`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_taxonomy` ( - `connotation_generic` int(10) UNSIGNED NOT NULL, - `connotation_specific` int(10) UNSIGNED NOT NULL -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='A Connotation may have a more generic Connotation (like an instance of Human is a generic form of instance of Mammal)' ROW_FORMAT=COMPACT; - --- -------------------------------------------------------- + `connotation_generic` int(10) unsigned NOT NULL, + `connotation_specific` int(10) unsigned NOT NULL, + PRIMARY KEY (`connotation_generic`,`connotation_specific`), + KEY `connotation_specific` (`connotation_specific`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='A Connotation may have a more generic Connotation (like an instance of Human is a generic form of instance of Mammal)'; +/*!40101 SET character_set_client = @saved_cs_client */; -- --- Struttura della tabella `wcaptcha_user` +-- Table structure for table `wcaptcha_user` -- +DROP TABLE IF EXISTS `wcaptcha_user`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `wcaptcha_user` ( - `user_ID` int(10) UNSIGNED NOT NULL, + `user_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_uid` varchar(128) NOT NULL, + `user_role` enum('user','analist') NOT NULL, + `user_active` int(11) NOT NULL DEFAULT 0, `user_email` varchar(128) NOT NULL, - `user_password` varchar(64) NOT NULL + `user_password` varchar(64) NOT NULL, + PRIMARY KEY (`user_ID`), + UNIQUE KEY `user_uid` (`user_uid`), + KEY `user_email` (`user_email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; --- --- Indici per le tabelle scaricate --- - --- --- Indici per le tabelle `wcaptcha_app` --- -ALTER TABLE `wcaptcha_app` - ADD PRIMARY KEY (`app_ID`); - --- --- Indici per le tabelle `wcaptcha_appuser` --- -ALTER TABLE `wcaptcha_appuser` - ADD PRIMARY KEY (`app_ID`,`user_ID`), - ADD KEY `user_ID` (`user_ID`); - --- --- Indici per le tabelle `wcaptcha_challenge` --- -ALTER TABLE `wcaptcha_challenge` - ADD PRIMARY KEY (`challenge_ID`); - --- --- Indici per le tabelle `wcaptcha_challenge_connotation` --- -ALTER TABLE `wcaptcha_challenge_connotation` - ADD PRIMARY KEY (`challenge_ID`,`connotation_ID`), - ADD KEY `challenge_connotation_ibfk_1` (`connotation_ID`); - --- --- Indici per le tabelle `wcaptcha_connotation` --- -ALTER TABLE `wcaptcha_connotation` - ADD KEY `image_ID` (`connotation_ID`); - --- --- Indici per le tabelle `wcaptcha_image` --- -ALTER TABLE `wcaptcha_image` - ADD UNIQUE KEY `image_ID` (`image_ID`), - ADD UNIQUE KEY `commons_pageid` (`commons_pageid`); - --- --- Indici per le tabelle `wcaptcha_image_connotation` --- -ALTER TABLE `wcaptcha_image_connotation` - ADD PRIMARY KEY (`connotation_ID`), - ADD KEY `image_ID` (`image_ID`); - --- --- Indici per le tabelle `wcaptcha_question` --- -ALTER TABLE `wcaptcha_question` - ADD PRIMARY KEY (`question_ID`), - ADD KEY `session_ID` (`session_ID`), - ADD KEY `challenge_ID` (`challenge_ID`), - ADD KEY `question_image` (`question_image`); - --- --- Indici per le tabelle `wcaptcha_session` --- -ALTER TABLE `wcaptcha_session` - ADD PRIMARY KEY (`session_ID`), - ADD KEY `app_ID` (`app_ID`); - --- --- Indici per le tabelle `wcaptcha_taxonomy` --- -ALTER TABLE `wcaptcha_taxonomy` - ADD PRIMARY KEY (`connotation_generic`,`connotation_specific`), - ADD KEY `connotation_specific` (`connotation_specific`); - --- --- Indici per le tabelle `wcaptcha_user` --- -ALTER TABLE `wcaptcha_user` - ADD PRIMARY KEY (`user_ID`), - ADD UNIQUE KEY `user_uid` (`user_uid`), - ADD KEY `user_email` (`user_email`); - --- --- AUTO_INCREMENT per le tabelle scaricate --- - --- --- AUTO_INCREMENT per la tabella `wcaptcha_image` --- -ALTER TABLE `wcaptcha_image` - MODIFY `image_ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; --- --- Limiti per le tabelle scaricate --- - --- --- Limiti per la tabella `wcaptcha_app` --- -ALTER TABLE `wcaptcha_app` - ADD CONSTRAINT `wcaptcha_app_ibfk_1` FOREIGN KEY (`app_ID`) REFERENCES `wcaptcha_appuser` (`app_ID`); - --- --- Limiti per la tabella `wcaptcha_appuser` --- -ALTER TABLE `wcaptcha_appuser` - ADD CONSTRAINT `wcaptcha_appuser_ibfk_1` FOREIGN KEY (`app_ID`) REFERENCES `wcaptcha_app` (`app_ID`) ON DELETE CASCADE, - ADD CONSTRAINT `wcaptcha_appuser_ibfk_2` FOREIGN KEY (`user_ID`) REFERENCES `wcaptcha_user` (`user_ID`) ON DELETE CASCADE; - --- --- Limiti per la tabella `wcaptcha_challenge_connotation` --- -ALTER TABLE `wcaptcha_challenge_connotation` - ADD CONSTRAINT `wcaptcha_challenge_connotation_ibfk_1` FOREIGN KEY (`connotation_ID`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE, - ADD CONSTRAINT `wcaptcha_challenge_connotation_ibfk_2` FOREIGN KEY (`challenge_ID`) REFERENCES `wcaptcha_challenge` (`challenge_ID`) ON DELETE CASCADE; - --- --- Limiti per la tabella `wcaptcha_image_connotation` --- -ALTER TABLE `wcaptcha_image_connotation` - ADD CONSTRAINT `wcaptcha_image_connotation_ibfk_1` FOREIGN KEY (`image_ID`) REFERENCES `wcaptcha_image` (`image_ID`) ON DELETE CASCADE, - ADD CONSTRAINT `wcaptcha_image_connotation_ibfk_2` FOREIGN KEY (`connotation_ID`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE; - --- --- Limiti per la tabella `wcaptcha_question` --- -ALTER TABLE `wcaptcha_question` - ADD CONSTRAINT `wcaptcha_question_ibfk_1` FOREIGN KEY (`challenge_ID`) REFERENCES `wcaptcha_challenge` (`challenge_ID`), - ADD CONSTRAINT `wcaptcha_question_ibfk_2` FOREIGN KEY (`session_ID`) REFERENCES `wcaptcha_session` (`session_ID`); - --- --- Limiti per la tabella `wcaptcha_session` --- -ALTER TABLE `wcaptcha_session` - ADD CONSTRAINT `wcaptcha_session_ibfk_1` FOREIGN KEY (`app_ID`) REFERENCES `wcaptcha_app` (`app_ID`) ON DELETE CASCADE; - --- --- Limiti per la tabella `wcaptcha_taxonomy` --- -ALTER TABLE `wcaptcha_taxonomy` - ADD CONSTRAINT `wcaptcha_taxonomy_ibfk_1` FOREIGN KEY (`connotation_generic`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE, - ADD CONSTRAINT `wcaptcha_taxonomy_ibfk_2` FOREIGN KEY (`connotation_specific`) REFERENCES `wcaptcha_connotation` (`connotation_ID`) ON DELETE CASCADE; - +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2019-11-29 20:25:52