Texture Overlay DB Update

Texture Overlay (Surface Texture) – Database Requirements

The API only enables surface textures if these columns exist:

product_sides:

• surface_texture (TINYINT(1), default 0)
• surface_texture_file_name (VARCHAR(255))

product_decoration_settings:

• surface_texture (TINYINT(1), default 0)
• surface_texture_file_name (VARCHAR(255))

SQL:
ALTER TABLE product_sides
ADD COLUMN surface_texture TINYINT(1) NOT NULL DEFAULT 0,
ADD COLUMN surface_texture_file_name VARCHAR(255) NULL;

ALTER TABLE product_decoration_settings
ADD COLUMN surface_texture TINYINT(1) NOT NULL DEFAULT 0,
ADD COLUMN surface_texture_file_name VARCHAR(255) NULL;

If those columns are missing, the API will report “Surface Texture is not supported by the current database schema”.