Review the access column for the following tables
installation/sql/mysql/joomla.sql
#__categories, #__contact_details, #__content, #__languages, #__menu, #__modules, #__newsfeeds, #__tags, #__ucm_content, #__extensions, #__finder_links, #__finder_taxonomy
administrator/components/com_finder/sql/install.mysql.sql
#__finder_links
administrator/components/com_contact/sql/install.mysql.utf8.sql
#__contact_details
administrator/components/com_newsfeeds/sql/install.mysql.utf8.sql
#__newsfeeds
All tables should have a consistent database schema for the access column
Going with the value for the Asset ID from the #__assets table
`access` int(10) unsigned NOT NULL DEFAULT 0,or for the extentions table (higher default permissions)
#__extensions
`access` int(10) unsigned NOT NULL DEFAULT 1,#__finder_links
`access` int(5) DEFAULT 0,#__finder_taxonomy
`access` tinyint(1) unsigned NOT NULL DEFAULT 0,administrator/components/com_finder/sql/install.mysql.sql
#__finder_links
`access` int(5) default '0',administrator/components/com_contact/sql/install.mysql.utf8.sql
#__contact_details
`access` tinyint(3) unsigned NOT NULL default '0',administrator/components/com_newsfeeds/sql/install.mysql.utf8.sql
#__newsfeeds
`access` tinyint UNSIGNED NOT NULL DEFAULT '0',I only reviewed the access column when I noticed the inconsistency, other common columns should also be reviewed and should be made consistent.
Recommended for review
alias
varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT ''state / published
tinyint(1) NOT NULL DEFAULT 0catid
int(11) unsigned NOT NULL DEFAULT 0ordering
int(11) unsigned NOT NULL DEFAULT 0metakey
params
checked_out
int(11) unsigned NOT NULL DEFAULT 0checked_out_time
datetime NOT NULL DEFAULT '0000-00-00 00:00:00'publish_up
datetime NOT NULL DEFAULT '0000-00-00 00:00:00'publish_down
datetime NOT NULL DEFAULT '0000-00-00 00:00:00'created
datetime NOT NULL DEFAULT '0000-00-00 00:00:00'language / lang_code
char(7) NOT NULLcreated_by / created_user_id
int(11) unsigned NOT NULL DEFAULT 0created_by_alias
modified
datetime NOT NULL DEFAULT '0000-00-00 00:00:00'modified_by / modified_user_id
int(11) unsigned NOT NULL DEFAULT 0version
int(11) unsigned NOT NULL DEFAULT 1| Category | ⇒ | SQL |
| Title |
|
||||||
| Title |
|
||||||
| Labels |
Added:
?
|
||
Closed as we have a PR #10098