v1.0.5

• Remapped hardcoded error messages to use related constant keys
• Updated README:
  • Added a warning about the ALTER TABLE TODO for the Notes table
    regarding mark_as_done and mark_as_done_date
• Integrated pagination functionality
• Migrated the core to be KMP (Kotlin Multiplatform) compliant
• Removed the short_description field from the Project entity
• Optimized database operations by using batch queries where applicable
• Added the "Edit Group" functionality

Migration from previous releases

To corretly migrate from the previous releases you have to follow these simple following steps:

• Change the dType field value of the users table, you can do it using this query:

UPDATE users SET dType = 'PandoroUser';

• Change the is_read field value of the changelogs table, you can do it using this query:

-- mark as unread the changelogs previously unread
UPDATE changelogs SET is_read = 0 WHERE red = 0;

-- mark as read the changelogs previously read
UPDATE changelogs SET is_read = 1 WHERE red = 1;

-- then drop the deprecated red colum
ALTER TABLE changelogs DROP red;

• Edit the default value of the marked_as_done field of the notes table, you can do it with sql command:

-- before alter the table
ALTER TABLE `notes` CHANGE `marked_as_done` `marked_as_done` BIT(1) NULL DEFAULT b'0';

-- after set the default value to the previous note status which have NULL as default value
UPDATE notes SET marked_as_done = 0 WHERE marked_as_done is NULL

• Edit the default value of the marked_as_done_date field of the notes table, you can do it with sql command:

-- before alter the table
ALTER TABLE `notes` CHANGE `marked_as_done_date` `marked_as_done_date` BIGINT(20) NULL DEFAULT '-1';

-- after set the default value to the previous note status which have NULL as default value
UPDATE notes SET marked_as_done_date = -1 WHERE marked_as_done_date IS NULL