- Implemented a multi-select dropdown for associating tasks with wiki entries in the task edit form. - Enhanced task popup to display related wiki entries with visibility controls based on user permissions. - Updated the wiki main view to support bulk actions for categories, including deletion and search functionality. - Created a new database migration for establishing many-to-many relationships between tasks and wiki entries. - Improved styling for wiki components to enhance user experience. - Added a new AGENTS.md file to outline communication and change management protocols.
11 lines
294 B
SQL
11 lines
294 B
SQL
-- 2026-03-03: relacja wiele-do-wielu zadania <-> wpisy wiki
|
|
|
|
CREATE TABLE IF NOT EXISTS `task_wiki` (
|
|
`task_id` INT NOT NULL,
|
|
`wiki_id` INT NOT NULL,
|
|
`date_add` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`task_id`, `wiki_id`),
|
|
KEY `idx_task_wiki_wiki` (`wiki_id`)
|
|
);
|
|
|