-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.5.0.6677
-- --------------------------------------------------------


-- Dumping structure for table tasnedarbs.emails
CREATE TABLE IF NOT EXISTS `emails` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table tasnedarbs.emails: ~4 rows (approximately)
INSERT INTO `emails` (`id`, `email`) VALUES
	(1, 'test@work.com'),
	(2, 'gang@star.com'),
	(4, 'yoyoyo@email.com'),
	(5, 'ganggang@email.com');

-- Dumping structure for table tasnedarbs.entries
CREATE TABLE IF NOT EXISTS `entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 1,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `edited_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table tasnedarbs.entries: ~2 rows (approximately)
INSERT INTO `entries` (`id`, `user_id`, `title`, `description`, `created_at`, `edited_at`) VALUES
	(2, 1, 'another test', 'hope this works', '2025-02-27 13:22:11', NULL),
	(3, 1, 'yoyoyo', 'this is fire entry yo', '2025-02-27 17:20:43', NULL);
END//
DELIMITER ;
END//
DELIMITER ;

