aboutsummaryrefslogtreecommitdiffstats
path: root/core/db
AgeCommit message (Collapse)AuthorFilesLines
2024-02-03Fix broken link to wiki page in first postThomas Lange1-1/+1
OLD: https://github.com/Nerdmind/Blog/wiki/Content-functions NEW: https://github.com/Nerdmind/Blog/wiki/Content_functions
2022-08-03SET NAMES 'utf8mb4'Markus Hackspacher1-0/+1
with SET NAMES can you imort the file with the commandline: mysql -u root blog < core/db/database.sql
2021-07-22Add demo category and update other demo entitiesThomas Lange1-4/+6
2021-07-01Update database schema for coming category systemThomas Lange2-1/+50
This commit updates the database schema and adds a new migration for the upcoming category system. Please note that you need to have at least the following MySQL/MariaDB versions to use the category system later: MariaDB: 10.2.2 MySQL: 8.0
2021-07-01Update database schema: Make id columns unsignedThomas Lange2-6/+19
This commit updates the database schema and adds a new migration to modify the signed integer columns to make them unsigned.
2021-06-30Optimize core/db/database.sqlThomas Lange1-38/+34
2021-06-24Remove migration for migration table (readme)Thomas Lange2-4/+1
This commit removes the migration number 5 which created the migration table. The initialization of the migration table will be implemented in the upcoming migration script by itself. Sorry! If you recently installed the application with a fresh database which contained the migration table, please manually set the schema_version to 4. It is recommended to only install a specific tag instead of the latest master branch unless you are a developer or know what you do. UPDATE migration SET schema_version = 4
2021-06-17Move database.sql to core/db/Thomas Lange1-0/+86
2021-06-17Add migrations directoryThomas Lange5-0/+18
This commit adds the directory core/db/migrations/ which contains all migrations that were applied to the database since the first release.