[BLOB], '2025-06-09', '17:21:47');

-- Dumping structure for table notepad.published_file_categories
CREATE TABLE IF NOT EXISTS `published_file_categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Publicētā faila sasaistes ar categorijām id',
  `published_file_id` int(11) unsigned NOT NULL COMMENT 'Publicētā faila id',
  `category_id` int(11) unsigned NOT NULL COMMENT 'Kategoriju id',
  PRIMARY KEY (`id`),
  KEY `FK__published_files` (`published_file_id`),
  KEY `FK__categories` (`category_id`),
  CONSTRAINT `FK__categories` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK__published_files` FOREIGN KEY (`published_file_id`) REFERENCES `published_files` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Publicētā faila sasaiste ar kategorijām';

-- Dumping data for table notepad.published_file_categories: ~21 rows (approximately)
INSERT INTO `published_file_categories` (`id`, `published_file_id`, `category_id`) VALUES
	(1, 4, 2),
	(2, 5, 1),
	(3, 5, 2),
	(4, 6, 3),
	(5, 6, 2),
	(6, 6, 1),
	(7, 7, 1),
	(8, 8, 4),
	(9, 8, 2),
	(10, 8, 1),
	(11, 9, 2),
	(12, 10, 1),
	(13, 10, 2),
	(14, 11, 1),
	(15, 12, 1),
	(16, 12, 5),
	(17, 12, 2),
	(18, 13, 6),
	(19, 13, 7),
	(20, 13, 8),
	(21, 14, 9),
	(22, 14, 10),
	(23, 14, 1);

