Framework migration panel

Analysis of tables for migration

The tables listed below have been analyzed with the structure() method in each model.

Table name
Analysis

site_page

12 results

There is a difference in the id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the route_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

site_news_gallery

273 results

There is a difference in the image_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the news_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

There is a difference in the image_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

site_project_group

8 results

There is a difference in the group_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the group_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

site_news

100 results

There is a difference in the news_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

site_project

290 results

There is a difference in the project_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

site_content

26 results

This table is up to date

site_slideshow_home

6 results

There is a difference in the slide_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the slide_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

site_project_gallery

2384 results

There is a difference in the image_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the project_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

There is a difference in the image_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

site_project_group_relation

330 results

There is a difference in the relation_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the group_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

There is a difference in the project_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

site_publication

75 results

There is a difference in the publication_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the project_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table SMALLINT NULL
Current configuration on the structure SMALLINT(255) NULL

There is a difference in the news_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table SMALLINT NULL
Current configuration on the structure SMALLINT(255) NULL

site_video_group_relation

50 results

There is a difference in the relation_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the group_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

There is a difference in the video_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

site_video

50 results

There is a difference in the video_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

site_message

57 results

There is a difference in the message_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

site_on_the_homepage

12 results

There is a difference in the post_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the post_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

There is a difference in the news_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

There is a difference in the project_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT NULL
Current configuration on the structure INT(255) NULL

site_video_group

3 results

There is a difference in the group_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the group_order column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL

site_team

185 results

There is a difference in the person_id column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table INT UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT
Current configuration on the structure INT(255) UNSIGNED NOT NULL PRIMARY AUTO_INCREMENT

There is a difference in the associate column configuration between the structure and the database.

Type Null Default Key Extra
Current configuration on the table TINYINT NULL
Current configuration on the structure TINYINT(255) NULL