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

v. 1.0.4

In this update:

• Now if the database not exists will be automatically created by the server
• Integrated the Equinox library
• Remapped the endpoints and formatted the responses to adapt them to the Requester

Migration from 1.0.3

If you have started the service before the version 1.0.3 (inclusive) you have to change some details of the table already created.
After started the 1.0.4 version of the server follow these steps:

• You need to rename the old images folder as resources to correctly serve the profile images
• If you have customized the properties file, so you have a file named pandoro.properties, you have to change its name in custom.properties
• In the users table you need to insert in the dtype field EquinoxUser as value
• In the notes table you need to delete the added id field and rename the note_id field as id, be aware to delete before the id field and then rename the past note_id field
• In the changelogs table you need to delete the added id field and rename the changelog_id field as id, be aware to delete before the id field and then rename the past changelog_id field

What's Changed

• Update 1.0.4 by @N7ghtm4r3 in #3

Full Changelog: 1.0.3...1.0.4

v. 1.0.3

In this version:

• Added the multi-language system for the internationalization
• Optimized some routine workflow like the SSL requests validation
• Ordered the list of values in the responses inserting the OrderBy in the queries

What's Changed

• e1.0.3 by @N7ghtm4r3 in #2

Full Changelog: 1.0.2...1.0.3

v. 1.0.2

In this version:

• Fixed the delete group query
• Fixed the bug when a project author leaves a group and the projects
• stay available for the group
• Fixed the Overview algorithms
• Fixed the last update timestamp to show in the project view
• Now the author of a group cannot be removed or changed the role

v. 1.0.1

In this release:

• Fixes the SSL certificate

v. 1.0.0

Released the first routines of the backend service for the Pandoro's system