core
core copied to clipboard
Create default variant
We need to create a default variant
, so we need to:
Create a new TaskUpgrade to:
- Create a
default variant
in the variant table - Add a new variant field to "contentlet_version_info", the default value should point to the
default variant
PRs:
https://github.com/dotCMS/core/pull/22868
Note to QA: Verify all records in contentlet_version_info
have variant = DEFAULT
Needs work: failing upgrade in MSSQL: https://gist.github.com/dsilvam/4fbe28b5b844920588a546b1cc914e66
MSSQL:
select * from variant
DEFAULT,Variant use by DEFAULT when a Contentlet is created,0
New contentlet creadted:
select * from contentlet where title = 'dinho'
183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,0,dinho,2022-10-14 22:28:56.275 +00:00,dotcms.org.1,0,dinho,c541abb1-69b3-4bc5-8430-5e09e5239cc8,"",7781f30550cac8ec7cb04ca227ecc82e
select * from contentlet_version_info where identifier = '7781f30550cac8ec7cb04ca227ecc82e'
7781f30550cac8ec7cb04ca227ecc82e,1,183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,183eecb3-8f40-47dc-bf9c-590f1ce0a4fc,0,,2022-10-14 22:28:56.503 +00:00,2022-10-14 22:28:56.977 +00:00,DEFAULT
Upgrade from 22.08 to master:
17:08:00.826 INFO startup.StartupTasksExecutor - Running Upgrade Tasks
17:08:00.826 INFO startup.StartupTasksExecutor - Database version: 220606
17:08:01.292 INFO startup.StartupTasksExecutor - Running Upgrade Tasks: Task220822CreateVariantTable
17:08:01.316 INFO startup.StartupTasksExecutor - Database upgraded to version: 220822
17:08:01.355 INFO startup.StartupTasksExecutor - Running Upgrade Tasks: Task220824CreateDefaultVariant
17:08:01.371 INFO startup.StartupTasksExecutor - Database upgraded to version: 220824
17:08:01.403 INFO startup.StartupTasksExecutor - Running Upgrade Tasks: Task220825CreateVariantField