Hello I’m trying to create an index for a content type defined in my plugin.
The problem is that when I try to call the following instruction in the plugin bootstrap function
await connection.raw(
'CREATE UNIQUE INDEX IF NOT EXISTS composite_uix ON my_table("a", "b")'
);
This exception is thrown back> error: CREATE UNIQUE INDEX IF NOT EXISTS ..... - relation "my-table" does not exist
This because content type builder has not been executed yet.
How can I create the index without manually create the relation ?
This topic has been created from a Discord post (1280196675209658371) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord