-- Adminer 5.4.2 MariaDB 11.8.3-MariaDB-0+deb13u1 from Debian dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `counter`;
CREATE TABLE `counter` (
  `id` int(11) NOT NULL,
  `counter` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

INSERT INTO `counter` (`id`, `counter`) VALUES
(1,	46);

DROP TABLE IF EXISTS `imgcounter`;
CREATE TABLE `imgcounter` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `imgcounter` int(8) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

INSERT INTO `imgcounter` (`id`, `imgcounter`) VALUES
(1,	4);

DROP TABLE IF EXISTS `nachrichten`;
CREATE TABLE `nachrichten` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `rid` varchar(55) NOT NULL,
  `msg` text NOT NULL,
  `datum` varchar(20) NOT NULL,
  `rdatum` varchar(20) NOT NULL,
  `passwort` int(1) NOT NULL DEFAULT 0,
  `fehler` int(1) NOT NULL DEFAULT 0,
  `img` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


DROP TABLE IF EXISTS `pwcounter`;
CREATE TABLE `pwcounter` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `pwcounter` int(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `pwcounter` (`id`, `pwcounter`) VALUES
(1,	10);

DROP TABLE IF EXISTS `sqlcounter`;
CREATE TABLE `sqlcounter` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `sqlcounter` int(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `sqlcounter` (`id`, `sqlcounter`) VALUES
(1,	1206);

-- 2026-02-26 15:10:23 UTC
