-- Changeset cloud-connector/2.0.x/20251203-pa-cloud-device-info-mapping-table-2.0.0.xml::1::Pavel Sindelar
-- Create table pa_cloud_device_info_mapping
CREATE TABLE pa_cloud_device_info_mapping (id BIGINT NOT NULL, platform VARCHAR(64) NOT NULL, brand VARCHAR(256), marketing_name VARCHAR(256), model_identifier VARCHAR(256) NOT NULL, device_codename VARCHAR(256), CONSTRAINT pa_cloud_device_info_mapping_pkey PRIMARY KEY (id));

-- Changeset cloud-connector/2.0.x/20251203-pa-cloud-device-info-mapping-table-2.0.0.xml::2::Pavel Sindelar
-- Create index on pa_cloud_device_info_mapping(model_identifier)
CREATE INDEX pa_cloud_dev_inf_map_mid_idx ON pa_cloud_device_info_mapping(model_identifier);

-- Changeset cloud-connector/2.0.x/20251203-pa-cloud-device-info-mapping-table-2.0.0.xml::3::Pavel Sindelar
-- Create sequence pa_cloud_device_info_map_seq
CREATE SEQUENCE  IF NOT EXISTS pa_cloud_device_info_map_seq START WITH 1 INCREMENT BY 1 CACHE 20;
