49GbmuTz

1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Počítač: localhost
6-- Vytvořeno: Stř 07. zář 2016, 20:09
7-- Verze serveru: 10.0.26-MariaDB-0+deb8u1
8-- Verze PHP: 5.6.24-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Databáze: `pray4luck`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Struktura tabulky `settings`
21--
22
23CREATE TABLE IF NOT EXISTS `settings` (
24`id` int(11) NOT NULL,
25  `setting` varchar(255) NOT NULL,
26  `value` varchar(255) NOT NULL
27) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
28
29--
30-- Vypisuji data pro tabulku `settings`
31--
32
33INSERT INTO `settings` (`id`, `setting`, `value`) VALUES
34(1, 'maintenance_enabled', 'false'),
35(2, 'maintenance_title', 'Updating'),
36(3, 'maintenance_info', 'Updating site rules'),
37(4, 'maintenance_time', '2016-08-09 23:00'),
38(5, 'attack_mitigation_time', '+5 minutes'),
39(6, 'attempts_before_ban', '100'),
40(7, 'attempts_before_verify', '5'),
41(8, 'bcrypt_cost', '10'),
42(9, 'cookie_domain', '.pray4luck.com'),
43(10, 'cookie_forget', '+24 hours'),
44(11, 'cookie_http', '0'),
45(12, 'cookie_name', 'authID'),
46(13, 'cookie_path', '/'),
47(14, 'cookie_remember', '+1 month'),
48(15, 'cookie_secure', '0'),
49(16, 'emailmessage_suppress_activation', '0'),
50(17, 'emailmessage_suppress_reset', '0'),
51(18, 'mail_charset', 'UTF-8'),
52(19, 'password_min_score', '2'),
53(20, 'site_activation_page', 'activate'),
54(21, 'site_email', 'no-reply@pray4luck.com'),
55(22, 'site_key', 'fghuior.)/!/jdUkd8s2!7HVHG7777ghg'),
56(23, 'site_name', 'pray4luck.com'),
57(24, 'site_password_reset_page', 'reset'),
58(25, 'site_timezone', 'Europe/Paris'),
59(26, 'site_url', 'https://pray4luck.com'),
60(27, 'smtp', '0'),
61(28, 'smtp_auth', '1'),
62(29, 'smtp_host', 'smtp.example.com'),
63(30, 'smtp_password', 'password'),
64(31, 'smtp_port', '25'),
65(32, 'smtp_security', ''),
66(33, 'smtp_username', 'email@example.com'),
67(34, 'table_attempts', 'auth_attempts'),
68(35, 'table_requests', 'auth_requests'),
69(36, 'table_sessions', 'auth_sessions'),
70(37, 'table_users', 'users'),
71(38, 'verify_email_max_length', '100'),
72(39, 'verify_email_min_length', '5'),
73(40, 'verify_email_use_banlist', '1'),
74(41, 'verify_password_min_length', '3'),
75(42, 'request_key_expiration', '+10 minutes');
76
77--
78-- Klíče pro exportované tabulky
79--
80
81--
82-- Klíče pro tabulku `settings`
83--
84ALTER TABLE `settings`
85 ADD PRIMARY KEY (`id`);
86
87--
88-- AUTO_INCREMENT pro tabulky
89--
90
91--
92-- AUTO_INCREMENT pro tabulku `settings`
93--
94ALTER TABLE `settings`
95MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=43;