|
1
|
-- phpMyAdmin SQL Dump
|
|
2
|
-- version 4.5.3.1
|
|
3
|
-- http://www.phpmyadmin.net
|
|
4
|
--
|
|
5
|
-- Host: localhost
|
|
6
|
-- Erstellungszeit: 01. Feb 2016 um 19:54
|
|
7
|
-- Server-Version: 5.6.24
|
|
8
|
-- PHP-Version: 7.0.1
|
|
9
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
|
10
|
-- --------------------------------------------------------
|
|
11
|
-- Database structure for module 'captcha_control'
|
|
12
|
--
|
|
13
|
-- Replacements: {TABLE_PREFIX}, {TABLE_ENGINE}, {FIELD_COLLATION}
|
|
14
|
--
|
|
15
|
-- --------------------------------------------------------
|
|
16
|
--
|
|
17
|
-- Tabellenstruktur für Tabelle `{TABLE_PREFIX}mod_captcha_control`
|
|
18
|
--
|
|
19
|
DROP TABLE IF EXISTS `{TABLE_PREFIX}mod_captcha_control`;
|
|
20
|
CREATE TABLE IF NOT EXISTS `{TABLE_PREFIX}mod_captcha_control` (
|
|
21
|
`enabled_captcha` int(11) NOT NULL DEFAULT '1',
|
|
22
|
`enabled_asp` int(11) NOT NULL DEFAULT '1',
|
|
23
|
`captcha_type` varchar(255){FIELD_COLLATION} NOT NULL DEFAULT 'calc_text',
|
|
24
|
`asp_session_min_age` int(11) NOT NULL DEFAULT '20',
|
|
25
|
`asp_view_min_age` int(11) NOT NULL DEFAULT '10',
|
|
26
|
`asp_input_min_age` int(11) NOT NULL DEFAULT '5',
|
|
27
|
`ct_text` longtext{FIELD_COLLATION} NOT NULL
|
|
28
|
){TABLE_ENGINE};
|
|
29
|
--
|
|
30
|
-- Daten für Tabelle `{TABLE_PREFIX}mod_captcha_control`
|
|
31
|
--
|
|
32
|
INSERT INTO `{TABLE_PREFIX}mod_captcha_control`
|
|
33
|
SET `captcha_type`='calc_text', `ct_text`='';
|
|
34
|
-- necessary fields only. all others will be set to their default values
|
|
35
|
-- fields without an default MUST be set manualy in any case
|