Create a content type and how to assign an index to an attribute?

I have set index to add_index but in the database there is no index.

database I use postgresql version 16
node version 20.9

schema :

{
“kind”: “collectionType”,
“collectionName”: “cms_product_detail_titles”,
“info”: {
“singularName”: “cms-product-detail-title”,
“pluralName”: “cms-product-detail-titles”,
“displayName”: “Product_Detail_Title”,
“createdAt”: “2024-05-26T14:41:07.459Z”,
“updatedAt”: “2024-07-01T14:33:11.506Z”
},
“options”: {
“draftAndPublish”: true,
“sharedContentType”: true
},
“attributes”: {
“add_index”: {
“type”: “integer”,
“index”: true
},
“title_id”: {
“type”: “integer”,
“unique”: true
},
“detail_title”: {
“type”: “relation”,
“relation”: “oneToOne”,
“target”: “api::cms-detail-title.cms-detail-title”
},
“expansion_headers”: {
“type”: “component”,
“repeatable”: true,
“component”: “product-det-ex.product-det-ex-header”
}
}
}

This topic has been created from a Discord post (1262714334719643680) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord