Project

General

Profile

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
(5-5/9)