-- Adminer 4.7.6 MySQL dump

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

DROP TABLE IF EXISTS `nk_log`;
CREATE TABLE `nk_log` (
  `id` int(11) NOT NULL,
  `id_nk_users` int(11) unsigned NOT NULL,
  `logintime` datetime NOT NULL,
  KEY `id_nk_users` (`id_nk_users`),
  CONSTRAINT `nk_log_ibfk_1` FOREIGN KEY (`id_nk_users`) REFERENCES `nk_users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


DROP TABLE IF EXISTS `nk_prispevky`;
CREATE TABLE `nk_prispevky` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_nk_users` int(11) unsigned NOT NULL,
  `title` varchar(128) COLLATE utf8_czech_ci NOT NULL,
  `msg` text COLLATE utf8_czech_ci NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id_nk_users` (`id_nk_users`),
  CONSTRAINT `nk_prispevky_ibfk_1` FOREIGN KEY (`id_nk_users`) REFERENCES `nk_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `nk_prispevky` (`id`, `id_nk_users`, `title`, `msg`, `created`) VALUES
(1,	3,	'Lorem 1',	'Lorem Ipsum supres',	'2023-03-01 23:36:52'),
(2,	2,	'Lorem 11',	'Lorem ipsumus loremos spravenost',	'2023-03-01 23:37:30'),
(4,	9,	'Test z PHP',	'LOREM lipsum',	'2023-03-09 10:12:35'),
(5,	10,	'Hodnocení',	'Je to tu boží, mám to tady rád ☺',	'2023-03-09 10:22:39'),
(7,	1,	'Ctcrřtky jsou fajne v2',	'testxt',	'2023-03-23 09:57:45'),
(8,	4,	'Zapis od Mod1',	'AHOJ DĚTI',	'2023-03-23 10:07:55');

DROP TABLE IF EXISTS `nk_users`;
CREATE TABLE `nk_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(32) COLLATE utf8_czech_ci NOT NULL,
  `password` varchar(64) COLLATE utf8_czech_ci NOT NULL,
  `role` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `nk_users` (`id`, `username`, `password`, `role`) VALUES
(1,	'admin',	'admin',	1),
(2,	'user1',	'user1',	5),
(3,	'user2',	'user2',	5),
(4,	'mod1',	'mod1',	3),
(5,	'mod2',	'mod2',	3),
(9,	'asd',	'asd',	5),
(10,	'xyz',	'xyz',	5);

-- 2023-03-23 09:32:22