-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.28-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.7.0.6850
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for skolniekslv
CREATE DATABASE IF NOT EXISTS `skolniekslv` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `skolniekslv`;

-- Dumping structure for table skolniekslv.classes
CREATE TABLE IF NOT EXISTS `classes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_name` varchar(10) NOT NULL COMMENT 'klases/grupas nosaukums',
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_name` (`class_name`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur visas mācību iestādes klases/grupas nosaukumus';

-- Dumping data for table skolniekslv.classes: ~40 rows (approximately)
INSERT INTO `classes` (`id`, `class_name`) VALUES
	(1, '101'),
	(2, '102'),
	(3, '103'),
	(4, '104'),
	(5, '105'),
	(6, '106'),
	(7, '107'),
	(8, '108'),
	(9, '109'),
	(10, '110'),
	(11, '201'),
	(12, '202'),
	(13, '203'),
	(14, '204'),
	(15, '205'),
	(16, '206'),
	(17, '207'),
	(18, '208'),
	(19, '209'),
	(20, '210'),
	(21, '301'),
	(22, '302'),
	(23, '303'),
	(24, '304'),
	(25, '305'),
	(26, '306'),
	(27, '307'),
	(28, '308'),
	(29, '309'),
	(30, '310'),
	(31, '401'),
	(32, '402'),
	(33, '403'),
	(34, '404'),
	(35, '405'),
	(36, '406'),
	(37, '407'),
	(38, '408'),
	(39, '409'),
	(40, '410');

-- Dumping structure for table skolniekslv.class_schedule
CREATE TABLE IF NOT EXISTS `class_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) NOT NULL COMMENT 'klases id',
  `date` date NOT NULL COMMENT 'stundu saraksta datums',
  `subject_id` int(11) NOT NULL COMMENT 'mācību priekšmeta id',
  `teacher_id` int(11) NOT NULL COMMENT 'pasniedzēja id',
  `room_id` int(11) NOT NULL COMMENT 'telpas id',
  `position` int(2) NOT NULL COMMENT 'pozīcija stundu sarakstā',
  PRIMARY KEY (`id`),
  KEY `class_id` (`class_id`),
  KEY `subject_id` (`subject_id`),
  KEY `teacher_id` (`teacher_id`),
  KEY `room_id` (`room_id`),
  CONSTRAINT `class_schedule_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`),
  CONSTRAINT `class_schedule_ibfk_2` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`),
  CONSTRAINT `class_schedule_ibfk_3` FOREIGN KEY (`teacher_id`) REFERENCES `emails_v` (`id`),
  CONSTRAINT `class_schedule_ibfk_4` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur visu klašu/grupu stundu sarakstus';

-- Dumping data for table skolniekslv.class_schedule: ~29 rows (approximately)
INSERT INTO `class_schedule` (`id`, `class_id`, `date`, `subject_id`, `teacher_id`, `room_id`, `position`) VALUES
	(34, 40, '2024-11-18', 2, 2, 19, 1),
	(35, 40, '2024-11-18', 2, 2, 19, 2),
	(36, 40, '2024-11-18', 3, 2, 19, 3),
	(37, 40, '2024-11-18', 3, 2, 19, 4),
	(38, 40, '2024-11-18', 3, 2, 19, 5),
	(39, 40, '2024-11-18', 3, 2, 19, 6),
	(40, 40, '2024-11-18', 3, 2, 19, 7),
	(41, 40, '2024-11-18', 3, 2, 19, 8),
	(42, 40, '2024-11-21', 14, 2, 4, 1),
	(43, 40, '2024-11-21', 14, 2, 1, 2),
	(44, 40, '2024-11-21', 14, 2, 1, 1),
	(45, 40, '2024-11-21', 14, 2, 1, 3),
	(46, 40, '2024-11-21', 14, 2, 1, 4),
	(47, 40, '2024-11-21', 14, 2, 1, 5),
	(50, 40, '2024-12-11', 14, 2, 1, 1),
	(51, 40, '2024-12-12', 14, 2, 1, 1),
	(52, 40, '2024-12-12', 14, 2, 1, 2),
	(53, 40, '2024-12-12', 14, 2, 1, 3),
	(54, 40, '2024-12-12', 14, 2, 1, 4),
	(55, 40, '2024-12-12', 14, 2, 1, 5),
	(56, 40, '2024-12-12', 14, 2, 1, 6),
	(57, 40, '2024-12-12', 12, 4, 1, 7),
	(58, 40, '2024-12-12', 12, 4, 1, 8),
	(62, 40, '2024-12-19', 14, 2, 1, 1),
	(63, 40, '2025-01-13', 13, 2, 19, 1),
	(64, 40, '2025-01-13', 13, 2, 19, 2),
	(65, 40, '2025-01-13', 1, 4, 14, 3),
	(66, 40, '2025-01-13', 1, 4, 14, 4),
	(67, 1, '2025-01-13', 14, 2, 1, 1);

-- Dumping structure for table skolniekslv.conversations
CREATE TABLE IF NOT EXISTS `conversations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT 'sarakstes nosaukums',
  `is_group` tinyint(1) DEFAULT 0 COMMENT 'vai sarakste ir grupa',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'kad sarakste izveidota',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur visas sarakstes kas ir izveidotas savstarpēji starp lietotājiem';

-- Dumping data for table skolniekslv.conversations: ~0 rows (approximately)

-- Dumping structure for table skolniekslv.conversation_participants
CREATE TABLE IF NOT EXISTS `conversation_participants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL COMMENT 'sarakstes id',
  `user_id` int(11) NOT NULL COMMENT 'sarakstes lietotāja id',
  PRIMARY KEY (`id`),
  KEY `conversation_id` (`conversation_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `conversation_participants_ibfk_1` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `conversation_participants_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `emails_v` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur visu sarakstu dalībniekus';

-- Dumping data for table skolniekslv.conversation_participants: ~0 rows (approximately)

-- Dumping structure for table skolniekslv.emails_v
CREATE TABLE IF NOT EXISTS `emails_v` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL COMMENT 'lietotāja epasts',
  `username` varchar(50) NOT NULL COMMENT 'lietotāja vārds, uzvārds',
  `is_verified` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'vai lietotājs ir verificēts',
  `level` int(11) DEFAULT 1 COMMENT 'lietotāja līmenis',
  `class_id` int(11) DEFAULT NULL COMMENT 'klases/grupas id',
  `theme_id` int(11) DEFAULT 1 COMMENT 'tematikas id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `FK_emails_v_classes` (`class_id`),
  KEY `FK_emails_v_themes` (`theme_id`),
  CONSTRAINT `FK_emails_v_classes` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_emails_v_themes` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur dažādu informāciju par specifisko lietotāju';

-- Dumping data for table skolniekslv.emails_v: ~5 rows (approximately)
INSERT INTO `emails_v` (`id`, `email`, `username`, `is_verified`, `level`, `class_id`, `theme_id`) VALUES
	(1, 'karlischickens@gmail.com', 'Kārlis Mālnieks', 1, 1, 40, 1),
	(2, 'uldisgrunde@gmail.com', 'Uldis Grunde-Zeiferts', 1, 2, NULL, 1),
	(3, 'nadezdabergfelde@gmail.com', 'Nadezda Bergfelde', 1, 3, NULL, 1),
	(4, 'gintaulenda@gmail.com', 'Ginta Ūlande', 1, 2, NULL, 1),
	(5, 'haralds@gmail.com', 'Haralds Kriščuns', 1, 1, 40, 1);

-- Dumping structure for table skolniekslv.events
CREATE TABLE IF NOT EXISTS `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL COMMENT 'notikuma nosaukums',
  `description` text NOT NULL COMMENT 'notikuma apraksts',
  `event_date` date NOT NULL COMMENT 'notikuma notikšanas datums',
  `user_id` int(11) NOT NULL COMMENT 'lietotāja id kas pievienoja',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'kad izveidots notikums',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`email_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur kalendāro ierakstu saturu';

-- Dumping data for table skolniekslv.events: ~8 rows (approximately)
INSERT INTO `events` (`id`, `title`, `description`, `event_date`, `user_id`, `created_at`) VALUES
	(48, '123', '123123', '2024-11-18', 3, '2024-11-18 15:53:13'),
	(50, 'asd', 'asd', '2024-11-14', 3, '2024-11-20 21:03:14'),
	(51, 'ca', 'cca', '2024-11-13', 3, '2024-11-20 21:25:31'),
	(52, 'ad', 'ad', '2024-11-13', 3, '2024-11-20 21:32:18'),
	(54, 'Lorem ipsum', 'Lorem ipsum', '2024-11-22', 3, '2024-11-22 05:48:54'),
	(57, 'asd', 'asd', '2024-12-18', 3, '2024-12-19 14:03:11'),
	(59, 'asd', 'asd', '2024-12-18', 3, '2024-12-19 14:03:27'),
	(60, 'Dzimsanas diena visforšākajam!', 'Kārlim Mālniekam šodien ir dzimšanas diena, apsveicam visi viņu, jo viņš ir tiešām foršs un mēs visi viņu mīlam. Es neesmu Kārlis Mālnieks!', '2025-01-13', 3, '2025-01-13 15:44:23');

-- Dumping structure for table skolniekslv.grades
CREATE TABLE IF NOT EXISTS `grades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) NOT NULL COMMENT 'studenta id',
  `grade` varchar(5) NOT NULL COMMENT 'studenta iegūtais vērtējums',
  `subject_id` int(11) NOT NULL COMMENT 'mācību priekšmeta id',
  `test_id` int(11) NOT NULL COMMENT 'pārbaudes darba id',
  `class_id` int(11) NOT NULL COMMENT 'grupas id',
  `teacher_id` int(11) NOT NULL COMMENT 'pasniedzēja id',
  `date` date NOT NULL COMMENT 'datums kad ieguvis vērtējumu',
  PRIMARY KEY (`id`),
  KEY `subject_id` (`subject_id`),
  KEY `test_id` (`test_id`),
  KEY `teacher_id` (`teacher_id`),
  KEY `student_id` (`student_id`),
  KEY `class_id` (`class_id`),
  CONSTRAINT `grades_ibfk_1` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_ibfk_2` FOREIGN KEY (`test_id`) REFERENCES `tests` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_ibfk_3` FOREIGN KEY (`teacher_id`) REFERENCES `emails_v` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_ibfk_4` FOREIGN KEY (`student_id`) REFERENCES `emails_v` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_ibfk_5` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur visu informāciju par skolnieku vērtējumiem';

-- Dumping data for table skolniekslv.grades: ~1 rows (approximately)
INSERT INTO `grades` (`id`, `student_id`, `grade`, `subject_id`, `test_id`, `class_id`, `teacher_id`, `date`) VALUES
	(36, 1, '10', 1, 35, 40, 4, '2025-01-14');

-- Dumping structure for table skolniekslv.messages
CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `conversation_id` int(11) NOT NULL COMMENT 'sarakstes id',
  `sender_id` int(11) NOT NULL COMMENT 'ziņas nosūtītāja id',
  `content` text NOT NULL COMMENT 'ziņas saturs',
  `read` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'vai ziņa izlasīta',
  `sent_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'kas tika ziņa nosūtīta',
  `iv` varchar(255) NOT NULL COMMENT 'šifrēšanai',
  PRIMARY KEY (`id`),
  KEY `conversation_id` (`conversation_id`),
  KEY `sender_id` (`sender_id`),
  CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`sender_id`) REFERENCES `emails_v` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula satur no sarakstu pārsūtītajām ziņām';

-- Dumping data for table skolniekslv.messages: ~0 rows (approximately)

-- Dumping structure for table skolniekslv.posts
CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL COMMENT 'lietotāja id',
  `tab` enum('news','feed') NOT NULL COMMENT 'kurā sadaļā atrodas ieraksts',
  `description` text NOT NULL COMMENT 'ieraksta apraksts',
  `image` varchar(255) DEFAULT NULL COMMENT 'attēla ceļš',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'kad tika pievienots',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `FK_posts_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`email_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula satur plūsmas ierakstu informāciju';

-- Dumping data for table skolniekslv.posts: ~1 rows (approximately)
INSERT INTO `posts` (`id`, `user_id`, `tab`, `description`, `image`, `created_at`) VALUES
	(206, 1, 'news', 'iechekojat manu pirmo postu', '[]', '2025-02-05 16:01:40');

-- Dumping structure for table skolniekslv.rooms
CREATE TABLE IF NOT EXISTS `rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_number` varchar(50) NOT NULL COMMENT 'telpas nosaukums',
  `floor` int(11) NOT NULL COMMENT 'stāvs',
  PRIMARY KEY (`id`),
  UNIQUE KEY `room_number` (`room_number`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur no mācību iestāžu telpu nosaukumiem un to stāviem';

-- Dumping data for table skolniekslv.rooms: ~25 rows (approximately)
INSERT INTO `rooms` (`id`, `room_number`, `floor`) VALUES
	(1, '101', 1),
	(2, '102', 1),
	(3, '103', 1),
	(4, '104', 1),
	(5, '105', 1),
	(6, '106', 1),
	(7, '201', 2),
	(8, '202', 2),
	(9, '203', 2),
	(10, '204', 2),
	(11, '205', 2),
	(12, '206', 2),
	(13, '301', 3),
	(14, '302', 3),
	(15, '303', 3),
	(16, '304', 3),
	(17, '305', 3),
	(18, '306', 3),
	(19, '401', 4),
	(20, '402', 4),
	(21, '403', 4),
	(22, '404', 4),
	(23, '405', 4),
	(24, '406', 4),
	(25, 'Sporta Zāle', 1);

-- Dumping structure for table skolniekslv.subjects
CREATE TABLE IF NOT EXISTS `subjects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT 'mācību priekšmeta nosaukums',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura sastāv no mācību priekšmetu nosaukumiem';

-- Dumping data for table skolniekslv.subjects: ~7 rows (approximately)
INSERT INTO `subjects` (`id`, `name`) VALUES
	(14, 'EIKT drošības politika - 2'),
	(3, 'EIKT produktu izstrāde - 2'),
	(2, 'EIKT produktu izstrāde - teorija'),
	(13, 'Lietotnes programmēšana - 2'),
	(11, 'Lietotnes programmēšana - teorija'),
	(1, 'Matemātika II'),
	(12, 'Sports');

-- Dumping structure for table skolniekslv.tests
CREATE TABLE IF NOT EXISTS `tests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` int(11) NOT NULL COMMENT 'skolotāja id',
  `name` varchar(100) NOT NULL COMMENT 'pārbaudes darba nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura satur no pārbaudes darbu nosaukumiem';

-- Dumping data for table skolniekslv.tests: ~1 rows (approximately)
INSERT INTO `tests` (`id`, `teacher_id`, `name`) VALUES
	(35, 4, 'eksāmens');

-- Dumping structure for table skolniekslv.themes
CREATE TABLE IF NOT EXISTS `themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT 'tematikas nosaukums',
  `description` text DEFAULT NULL COMMENT 'tematikas apraksts',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura sastāv no lietotāju tematikas izvēlēm';

-- Dumping data for table skolniekslv.themes: ~2 rows (approximately)
INSERT INTO `themes` (`id`, `name`, `description`) VALUES
	(1, 'light', 'Gaišais režīms'),
	(2, 'dark', 'Tumšais režīms');

-- Dumping structure for table skolniekslv.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_id` int(11) NOT NULL COMMENT 'lietotāja verificētā epasta id',
  `password` varchar(255) NOT NULL COMMENT 'lietotāja parole',
  PRIMARY KEY (`id`),
  KEY `email_id` (`email_id`),
  CONSTRAINT `FK_users_emails_v` FOREIGN KEY (`email_id`) REFERENCES `emails_v` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Tabula kura sastāv no lietotāju izveidotajām parolēm';

-- Dumping data for table skolniekslv.users: ~5 rows (approximately)
INSERT INTO `users` (`id`, `email_id`, `password`) VALUES
	(8, 1, '$2y$10$dAFgFqONRomxheLLV/ssqu1TNcebXE952uCnD20RYL9bHzLTBIBgi'),
	(9, 2, '$2y$10$Qjrt2wXHsvWm/5JH1wIbU.qmI4Ic/9X0tDFQqN4zVB7GauRV5hMjS'),
	(10, 3, '$2y$10$e8SBPXnfyRZn.PVVLzmyaeGB8P46aTocQmOvGYjhrZuIvTr0utJve'),
	(11, 4, '$2y$10$3th.OyTglew4kzFX2v4zfOuaFAx9t0VU5iWDi/D7eNCcP5mr4Zq6O'),
	(12, 5, '$2y$10$lfB9aJtXPVbaOwu3REU6MumG60TEIUs.YMHrKDI5XVqcjjABV.bzu');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
