Developer forum

Hi Hakan

You can always find the tables in \Admin\Update\Data\Create_DefaultEmpty.sql

This is the SQL

CREATE TABLE [dbo].[EcomProductCategoryTranslation](
    [CategoryTranslationCategoryId] [nvarchar](50) NOT NULL,
    [CategoryTranslationLanguageId] [nvarchar](50) NOT NULL,
    [CategoryTranslationCategoryName] [nvarchar](255) NULL,
    [CategoryTranslationAutoId] [int] IDENTITY(1,1) NOT NULL
)

Followed by

ALTER TABLE [dbo].[EcomProductCategoryTranslation] ADD  CONSTRAINT [DW_PK_EcomProductCategoryTranslation] PRIMARY KEY NONCLUSTERED
(
    [CategoryTranslationCategoryId] ASC,
    [CategoryTranslationLanguageId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

If you encounter this issue - you probably have a database that is pretty damaged, so you might just run into another problem after fixing this.

BR Nicolai