Category: Laravel Database Migrations
-
Post Views: 18 1. In the startup script of the docker container, if you want to force the migration command to run without prompt, use the –force parameter 2. At this stage, there is a module developed based on Laravel Modules, and there are migration files, such as: /modules/themestoredb/database/migrations . as shown in Figure 1 3. In the local development…
-
Post Views: 19 1. When performing database migration, an error is reported: sqlstate[42000]: Syntax Error or Access Violation: 1059 Identifier nametheme_installation_version_preset_theme_store_theme_version_id_indexis too long. as shown in Figure 1 The index length limit of MySQL 5.7 defaults to 64, while the length of the Theme_Installation_Version_Preset_Theme_Store_Theme_Version_ID_Index is 68. as shown in Figure 2 3. In Laravel 6, each indexing method accepts an…
-
Post Views: 18 1. In Laravel 6’s database migration, when adding a foreign key constraint, Illuminate\Database\QueryException : SQLState[HY000]: General error: 1215 Cannot add foreign key constraint. as shown in Figure 1 2. The code is implemented as follows 3. The code is adjusted as follows, and the error is still reported: 4. The field ASSET_ID type of the table Theme_Asset_Version…
-
Post Views: 19 1. Now the field Theme_Asset of the table Theme_Asset is of type VARCHAR(255). The previous migration code is as follows. as shown in Figure 1 2. Now plan to add a new migration file to modify the type of the field Theme_id is: UUID, that is, char(36). 3. Error: Doctrine\DBAL\Exception : Unknown column type “UUID” requested. As…
-
Post Views: 19 1. In Laravle 6’s database migration, the data table option does not support adding comments. as shown in Figure 1 2. Reference:https://stackoverflow.com/questions/37493431/how-to-add-comment-to-table-not-column-in-laravel-5-migration. How to add comment to table (not column) in Laravel 5 migration? 3. The final realization is as follows 4. After performing the database migration, check the execution results, and the table comments have been…