aboutsummaryrefslogtreecommitdiffstats
path: root/core/db/database.sql
AgeCommit message (Collapse)AuthorFilesLines
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 Lange1-1/+26
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 Lange1-6/+6
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 Lange1-1/+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