Jump to content

Edit History

wigs

wigs

In the prestashop 9 database schema I noticed there's a randomly named key here: 

/* Admin users */
CREATE TABLE `PREFIX_employee` (
  `id_employee` int(10) unsigned NOT NULL auto_increment,
  [...]
  PRIMARY KEY (`id_employee`),
  KEY `employee_login` (`email`, `passwd`),
  KEY `id_employee_passwd` (`id_employee`, `passwd`),
  KEY `id_profile` (`id_profile`),
  KEY `IDX_1D8DF9EBBA299860` (`id_lang`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

This `IDX_rngstring` should probably be renamed to `id_lang` or something like that. 

source line 835 in https://github.com/PrestaShop/PrestaShop/blob/c847584362b7e36fcd5d9b28cfe6c98e4556a3bf/install-dev/data/db_structure.sql

It was added by this commit and shortly discussed here https://github.com/PrestaShop/PrestaShop/pull/36233#pullrequestreview-2082071245

More randomly named keys like this were added, generated by doctrine orm. Would renaming them break existing relations?

offtopic: if anyone knows where the tables added by this commit were created before being added to the schema I would be interested in finding out.

wigs

wigs

In the prestashop 9 database schema I noticed there's a randomly named key here: 

/* Admin users */
CREATE TABLE `PREFIX_employee` (
  `id_employee` int(10) unsigned NOT NULL auto_increment,
  [...]
  PRIMARY KEY (`id_employee`),
  KEY `employee_login` (`email`, `passwd`),
  KEY `id_employee_passwd` (`id_employee`, `passwd`),
  KEY `id_profile` (`id_profile`),
  KEY `IDX_1D8DF9EBBA299860` (`id_lang`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

This `IDX_rngstring` should probably be renamed to `id_lang` or something like that. 

source line 835 in https://github.com/PrestaShop/PrestaShop/blob/c847584362b7e36fcd5d9b28cfe6c98e4556a3bf/install-dev/data/db_structure.sql

It was added by this commit and shortly discussed here https://github.com/PrestaShop/PrestaShop/pull/36233#pullrequestreview-2082071245

offtopic: if anyone knows where the tables added by this commit were created before being added to the schema I would be interested in finding out.

wigs

wigs

In the prestashop 9 database schema I noticed there's a randomly named key here: 

/* Admin users */
CREATE TABLE `PREFIX_employee` (
  `id_employee` int(10) unsigned NOT NULL auto_increment,
  [...]
  PRIMARY KEY (`id_employee`),
  KEY `employee_login` (`email`, `passwd`),
  KEY `id_employee_passwd` (`id_employee`, `passwd`),
  KEY `id_profile` (`id_profile`),
  KEY `IDX_1D8DF9EBBA299860` (`id_lang`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

This `IDX_rngstring` should probably be renamed to `id_lang` or something like that. 

source line 835 in https://github.com/PrestaShop/PrestaShop/blob/c847584362b7e36fcd5d9b28cfe6c98e4556a3bf/install-dev/data/db_structure.sql

wigs

wigs

In the prestashop 9 database schema I noticed there's a randomly named key here: 

/* Admin users */
CREATE TABLE `PREFIX_employee` (
  `id_employee` int(10) unsigned NOT NULL auto_increment,
  [...]
  PRIMARY KEY (`id_employee`),
  KEY `employee_login` (`email`, `passwd`),
  KEY `id_employee_passwd` (`id_employee`, `passwd`),
  KEY `id_profile` (`id_profile`),
  KEY `IDX_1D8DF9EBBA299860` (`id_lang`)
) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8mb4 COLLATION;

This `IDX_rngstring` should probably be renamed to `idx_lang` or something like that. 

source line 835 in https://github.com/PrestaShop/PrestaShop/blob/c847584362b7e36fcd5d9b28cfe6c98e4556a3bf/install-dev/data/db_structure.sql

×
×
  • Create New...