-- Adminer 4.8.1 MySQL 10.3.34-MariaDB-0+deb10u1 dump


SET foreign_key_checks = 0;

SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';


CREATE TABLE `countries`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `nazov`(`name`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `countries`(`id`, `name`)
    VALUES (1, 'Afghanistan'),
(2, 'Albania'),
(3, 'Algeria'),
(4, 'American Samoa'),
(5, 'Andorra'),
(6, 'Angola'),
(7, 'Anguilla'),
(8, 'Antarctica'),
(9, 'Antigua And Barbuda'),
(10, 'Argentina'),
(11, 'Armenia'),
(12, 'Aruba'),
(13, 'Australia'),
(14, 'Austria'),
(15, 'Azerbaijan'),
(16, 'Bahamas'),
(17, 'Bahrain'),
(18, 'Bangladesh'),
(19, 'Barbados'),
(20, 'Belarus'),
(21, 'Belgium'),
(22, 'Belize'),
(23, 'Benin'),
(24, 'Bermuda'),
(25, 'Bhutan'),
(26, 'Bolivia'),
(27, 'Bosnia And Herzegovina'),
(28, 'Botswana'),
(29, 'Bouvet Island'),
(30, 'Brazil'),
(31, 'British Indian Ocean Territory'),
(32, 'Brunei Darussalam'),
(33, 'Bulgaria'),
(34, 'Burkina Faso'),
(35, 'Burundi'),
(36, 'Cambodia'),
(37, 'Cameroon'),
(38, 'Canada'),
(39, 'Cape Verde'),
(40, 'Cayman Islands'),
(41, 'Central African Republic'),
(42, 'Chad'),
(43, 'Chile'),
(44, 'China'),
(45, 'Christmas Island'),
(46, 'Cocos Islands'),
(47, 'Colombia'),
(48, 'Comoros'),
(49, 'Congo'),
(50, 'Cook Islands'),
(51, 'Costa Rica'),
(52, 'Cote Divoire'),
(53, 'Croatia'),
(54, 'Cuba'),
(55, 'Cyprus'),
(56, 'Czech Republic'),
(57, 'Denmark'),
(58, 'Djibouti'),
(59, 'Dominica'),
(60, 'Dominican Republic'),
(61, 'East Timor'),
(62, 'Ecuador'),
(63, 'Egypt'),
(64, 'El Salvador'),
(65, 'Equatorial Guinea'),
(66, 'Eritrea'),
(67, 'Estonia'),
(68, 'Ethiopia'),
(69, 'Falkland Islands'),
(70, 'Faroe Islands'),
(71, 'Fiji'),
(72, 'Finland'),
(73, 'France'),
(74, 'French Guiana'),
(75, 'French Polynesia'),
(76, 'French Southern Territories'),
(77, 'Gabon'),
(78, 'Gambia'),
(79, 'Georgia'),
(80, 'Germany'),
(81, 'Ghana'),
(82, 'Gibraltar'),
(83, 'Greece'),
(84, 'Greenland'),
(85, 'Grenada'),
(86, 'Guadeloupe'),
(87, 'Guam'),
(88, 'Guatemala'),
(89, 'Guinea'),
(90, 'Guinea-bissau'),
(91, 'Guyana'),
(92, 'Haiti'),
(93, 'Heard Island & Mcdonald Islands'),
(94, 'Honduras'),
(95, 'Hong Kong'),
(96, 'Hungary'),
(97, 'Iceland'),
(98, 'India'),
(99, 'Indonesia'),
(100, 'Iran, Islamic Republic Of'),
(101, 'Iraq'),
(102, 'Ireland'),
(103, 'Israel'),
(104, 'Italy'),
(105, 'Jamaica'),
(106, 'Japan'),
(107, 'Jordan'),
(108, 'Kazakhstan'),
(109, 'Kenya'),
(110, 'Kiribati'),
(111, 'Korea, Democratic Peoples Republic Of'),
(112, 'Korea, Republic Of'),
(113, 'Kuwait'),
(114, 'Kyrgyzstan'),
(115, 'Lao Peoples Democratic Republic'),
(116, 'Latvia'),
(117, 'Lebanon'),
(118, 'Lesotho'),
(119, 'Liberia'),
(120, 'Libyan Arab Jamahiriya'),
(121, 'Liechtenstein'),
(122, 'Lithuania'),
(123, 'Luxembourg'),
(124, 'Macau'),
(125, 'Macedonia'),
(126, 'Madagascar'),
(127, 'Malawi'),
(128, 'Malaysia'),
(129, 'Maldives'),
(130, 'Mali'),
(131, 'Malta'),
(132, 'Marshall Islands'),
(133, 'Martinique'),
(134, 'Mauritania'),
(135, 'Mauritius'),
(136, 'Mayotte'),
(137, 'Mexico'),
(138, 'Micronesia, Federated States Of'),
(139, 'Moldova, Republic Of'),
(140, 'Monaco'),
(141, 'Mongolia'),
(142, 'Montserrat'),
(143, 'Morocco'),
(144, 'Mozambique'),
(145, 'Myanmar'),
(146, 'Namibia'),
(147, 'Nauru'),
(148, 'Nepal'),
(149, 'Netherlands'),
(150, 'Netherlands Antilles'),
(151, 'New Caledonia'),
(152, 'New Zealand'),
(153, 'Nicaragua'),
(154, 'Niger'),
(155, 'Nigeria'),
(156, 'Niue'),
(157, 'Norfolk Island'),
(158, 'Northern Mariana Islands'),
(159, 'Norway'),
(160, 'Oman'),
(161, 'Pakistan'),
(162, 'Palau'),
(163, 'Panama'),
(164, 'Papua New Guinea'),
(165, 'Paraguay'),
(166, 'Peru'),
(167, 'Philippines'),
(168, 'Pitcairn'),
(169, 'Poland'),
(170, 'Portugal'),
(171, 'Puerto Rico'),
(172, 'Qatar'),
(173, 'Reunion'),
(174, 'Romania'),
(175, 'Russian Federation'),
(176, 'Rwanda'),
(177, 'Saint Helena'),
(178, 'Saint Kitts And Nevis'),
(179, 'Saint Lucia'),
(180, 'Saint Pierre And Miquelon'),
(181, 'Saint Vincent And The Grenadines'),
(182, 'Samoa'),
(183, 'San Marino'),
(184, 'Sao Tome And Principe'),
(185, 'Saudi Arabia'),
(186, 'Senegal'),
(187, 'Serbia'),
(188, 'Seychelles'),
(189, 'Sierra Leone'),
(190, 'Singapore'),
(191, 'Slovakia'),
(192, 'Slovenia'),
(193, 'Solomon Islands'),
(194, 'Somalia'),
(195, 'South Africa'),
(196, 'Spain'),
(197, 'Sri Lanka'),
(198, 'Sudan'),
(199, 'Suriname'),
(200, 'Svalbard And Jan Mayen Islands'),
(201, 'Swaziland'),
(202, 'Sweden'),
(203, 'Switzerland'),
(204, 'Syrian Arab Republic'),
(205, 'Taiwan, Province Of China'),
(206, 'Tajikistan'),
(207, 'Tanzania, United Republic Of'),
(208, 'Tatarstan'),
(209, 'Thailand'),
(210, 'Togo'),
(211, 'Tokelau'),
(212, 'Tonga'),
(213, 'Trinidad And Tobago'),
(214, 'Tunisia'),
(215, 'Turkey'),
(216, 'Turkmenistan'),
(217, 'Turks And Caicos Islands'),
(218, 'Tuvalu'),
(219, 'Uganda'),
(220, 'Ukraine'),
(221, 'United Arab Emirates'),
(222, 'United Kingdom'),
(223, 'United States'),
(224, 'United States Minor Outlying Islands'),
(225, 'Uruguay'),
(226, 'Uzbekistan'),
(227, 'Vanuatu'),
(228, 'Vatican City State'),
(229, 'Venezuela'),
(230, 'Viet Nam'),
(231, 'Virgin Islands [british]'),
(232, 'Virgin Islands [u.s.]'),
(233, 'Wallis And Futuna Islands'),
(234, 'Western Sahara'),
(235, 'Yemen'),
(236, 'Zaire'),
(237, 'Zambia'),
(238, 'Zimbabwe');


CREATE TABLE `emails`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP(),
    `module` varchar(255) DEFAULT NULL,
    `from` varchar(255) NOT NULL,
    `name_from` varchar(255) NOT NULL,
    `to` varchar(255) NOT NULL,
    `name_to` varchar(255) NOT NULL,
    `cc` mediumblob DEFAULT NULL,
    `bcc` mediumblob DEFAULT NULL,
    `subject` varchar(255) NOT NULL,
    `message` mediumtext DEFAULT NULL,
    `message_html` mediumtext DEFAULT NULL,
    `error` tinyint(4) NOT NULL DEFAULT 0,
    `error_message` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `module`(`module`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `galleries`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `group` varchar(255) DEFAULT NULL,
    `order` int(11) DEFAULT NULL,
    `mainphoto` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name`(`name`),
    KEY `mainphoto`(`mainphoto`),
    CONSTRAINT `galleries_ibfk_1` FOREIGN KEY (`mainphoto`) REFERENCES `photos`(`id`) ON DELETE SET NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `galleries_descriptions`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `gallery` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `description` text NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `gallery_language`(`gallery`, `language`),
    KEY `language`(`language`),
    CONSTRAINT `galleries_descriptions_ibfk_1` FOREIGN KEY (`gallery`) REFERENCES `galleries`(`id`) ON DELETE CASCADE,
    CONSTRAINT `galleries_descriptions_ibfk_2` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `galleries_photos`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `gallery` int(11) NOT NULL,
    `photo` int(11) NOT NULL,
    `order` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `gallery_photo`(`gallery`, `photo`),
    KEY `gallery`(`gallery`),
    KEY `photo`(`photo`),
    CONSTRAINT `galleries_photos_ibfk_1` FOREIGN KEY (`gallery`) REFERENCES `galleries`(`id`) ON DELETE CASCADE,
    CONSTRAINT `galleries_photos_ibfk_2` FOREIGN KEY (`photo`) REFERENCES `photos`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `groups`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(40) character
    SET latin1 COLLATE latin1_general_ci NOT NULL,
    `description` varchar(255) DEFAULT NULL,
    `module` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `module`(`module`),
    CONSTRAINT `groups_ibfk_2` FOREIGN KEY (`module`) REFERENCES `modules`(`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `groups`(`id`, `name`, `description`, `module`)
    VALUES (2, 'admins', 'Vstup do administrátorského rozhrania', 1),
(6, 'all_permissions', 'Všetky administrátorské oprávnenia', 1),
(7, 'photos_admins', 'Správcovia fotografií a galérií', 1),
(8, 'pages_admins', 'Správcovia stránok', 1);


CREATE TABLE `languages`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `code` char(2) NOT NULL,
    `description` varchar(255) NOT NULL,
    `show` tinyint(1) NOT NULL,
    `time_format` varchar(20) NOT NULL,
    `date_format` varchar(20) NOT NULL,
    `number_dec_point` char(1) NOT NULL,
    `number_thousands_sep` char(1) NOT NULL,
    `currency` varchar(3) NOT NULL,
    `week_start` tinyint(4) NOT NULL DEFAULT 1,
    `locale` varchar(20) NOT NULL,
    PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `languages`(`id`, `code`, `description`, `show`, `time_format`, `date_format`, `number_dec_point`, `number_thousands_sep`, `currency`, `week_start`, `locale`)
    VALUES (1, 'sk', 'Slovenčina', 1, 'H:i', 'd. j. Y', ',', '-', '€', 1, 'sk_SK.utf8'),
(2, 'en', 'English', 1, 'H:i', 'd. j. Y', ',', '.', '€', 1, 'en_GB.utf8');


CREATE TABLE `modules`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `disabled` tinyint(1) NOT NULL DEFAULT 0,
    `system` tinyint(1) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name`(`name`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `modules`(`id`, `name`, `disabled`, `system`)
    VALUES (1, 'Core', 0, 1),
(2, 'Pages', 0, 1),
(3, 'PhotoManager', 0, 1);


CREATE TABLE `pages`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `created` datetime NOT NULL,
    `updated` datetime NOT NULL,
    `mainphoto` int(11) DEFAULT NULL,
    `maingallery` int(11) DEFAULT NULL,
    `parent` int(11) DEFAULT NULL,
    `order` int(11) NOT NULL,
    `lft` int(11) DEFAULT NULL,
    `rgt` int(11) DEFAULT NULL,
    `level` int(11) DEFAULT NULL,
    `showlink` enum('hide', 'show', 'logged_in') DEFAULT NULL,
    `group` int(11) NOT NULL DEFAULT -1,
    `main` tinyint(1) DEFAULT NULL,
    `index` tinyint(1) DEFAULT NULL,
    `template` varchar(255) NOT NULL,
    `modify_lock` tinyint(1) NOT NULL DEFAULT 0,
    `route` varchar(255) DEFAULT NULL,
    `show_on_mainpage` tinyint(4) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `parent`(`parent`),
    KEY `mainphoto`(`mainphoto`),
    KEY `maingallery`(`maingallery`),
    CONSTRAINT `pages_ibfk_2` FOREIGN KEY (`parent`) REFERENCES `pages`(`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `pages_ibfk_5` FOREIGN KEY (`mainphoto`) REFERENCES `photos`(`id`) ON DELETE SET NULL,
    CONSTRAINT `pages_ibfk_6` FOREIGN KEY (`maingallery`) REFERENCES `galleries`(`id`) ON DELETE SET NULL) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `pages_contents`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `page` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `perex` text DEFAULT NULL,
    `content` mediumtext NOT NULL,
    `url` varchar(255) NOT NULL,
    `keywords` text DEFAULT NULL,
    `description` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `language_page`(`language`, `page`),
    UNIQUE KEY `language_url`(`language`, `url`),
    KEY `page`(`page`),
    CONSTRAINT `pages_contents_ibfk_1` FOREIGN KEY (`page`) REFERENCES `pages`(`id`) ON DELETE CASCADE,
    CONSTRAINT `pages_contents_ibfk_2` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `photos`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `file` char(40) NOT NULL,
    `old_file` varchar(255) NOT NULL,
    `width` smallint(6) NOT NULL,
    `height` smallint(6) NOT NULL,
    `center_x` smallint(6) DEFAULT NULL,
    `center_y` smallint(6) DEFAULT NULL,
    `video` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `file`(`file`),
    UNIQUE KEY `old_file`(`old_file`)) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `photos_descriptions`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `photo` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `description` varchar(255) DEFAULT NULL,
    `long_description` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `language_photo`(`language`, `photo`),
    KEY `photo`(`photo`),
    CONSTRAINT `photos_descriptions_ibfk_1` FOREIGN KEY (`photo`) REFERENCES `photos`(`id`) ON DELETE CASCADE,
    CONSTRAINT `photos_descriptions_ibfk_2` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `photos_hotspots`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `photo` int(11) NOT NULL,
    `x` mediumint(9) NOT NULL,
    `y` mediumint(9) NOT NULL,
    `videos` text character
    SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
    `icon` varchar(255) character
    SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `photo`(`photo`),
    KEY `category`(`icon`),
    CONSTRAINT `photos_hotspots_ibfk_2` FOREIGN KEY (`photo`) REFERENCES `photos`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `photos_hotspots_contents`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `hotspot` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `title` varchar(255) NOT NULL,
    `text` text DEFAULT NULL,
    `url` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `language_hotspot`(`language`, `hotspot`),
    KEY `hotspot`(`hotspot`),
    CONSTRAINT `photos_hotspots_contents_ibfk_1` FOREIGN KEY (`hotspot`) REFERENCES `photos_hotspots`(`id`) ON DELETE CASCADE,
    CONSTRAINT `photos_hotspots_contents_ibfk_2` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `photos_hotspots_photos`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `hotspot` int(11) NOT NULL,
    `photo` int(11) NOT NULL,
    `order` mediumint(9) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `hotspot_photo`(`hotspot`, `photo`),
    KEY `photo`(`photo`),
    CONSTRAINT `photos_hotspots_photos_ibfk_1` FOREIGN KEY (`hotspot`) REFERENCES `photos_hotspots`(`id`) ON DELETE CASCADE,
    CONSTRAINT `photos_hotspots_photos_ibfk_2` FOREIGN KEY (`photo`) REFERENCES `photos`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;


CREATE TABLE `search_index`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `language` int(11) DEFAULT NULL,
    `object` int(11) NOT NULL,
    `type` varchar(255) NOT NULL,
    `type_priority` tinyint(4) NOT NULL,
    `object_date` datetime NOT NULL,
    `object_data` mediumblob NOT NULL,
    `data_1` text DEFAULT NULL,
    `data_2` text DEFAULT NULL,
    `data_3` text DEFAULT NULL,
    `data_4` text DEFAULT NULL,
    `data_5` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `language_object_type`(`language`, `object`, `type`),
    FULLTEXT KEY `data_1_data_2_data_3_data_4_data_5`(`data_1`, `data_2`, `data_3`, `data_4`, `data_5`)) ENGINE = MyISAM DEFAULT CHARSET = utf8;



CREATE TABLE `snippets`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name`(`name`)) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;


CREATE TABLE `snippets_contents`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `snippet` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `content` mediumtext NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `snippet_language`(`snippet`, `language`),
    KEY `snippet`(`snippet`),
    KEY `language`(`language`),
    CONSTRAINT `snippets_contents_ibfk_4` FOREIGN KEY (`snippet`) REFERENCES `snippets`(`id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `snippets_contents_ibfk_5` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;


CREATE TABLE `users_description`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `language` int(11) NOT NULL,
    `description` text DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `user_language`(`user`, `language`),
    KEY `language`(`language`),
    CONSTRAINT `users_description_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users`(`id`) ON DELETE CASCADE,
    CONSTRAINT `users_description_ibfk_2` FOREIGN KEY (`language`) REFERENCES `languages`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `users_description`(`id`, `user`, `language`, `description`)
    VALUES (19, 1, 1, ''),
(20, 1, 2, '');


CREATE TABLE `users_groups`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user` int(11) NOT NULL,
    `group` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `user_group`(`user`, `group`),
    KEY `group`(`group`),
    CONSTRAINT `users_groups_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users`(`id`) ON DELETE CASCADE,
    CONSTRAINT `users_groups_ibfk_2` FOREIGN KEY (`group`) REFERENCES `groups`(`id`) ON DELETE CASCADE) ENGINE = InnoDB DEFAULT CHARSET = utf8;

INSERT INTO `users_groups`(`id`, `user`, `group`)
    VALUES (3, 1, 2),
(6, 1, 6),
(27, 1, 7),
(28, 1, 8);

-- 2025-03-29 20:24:19
