-- 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 NUMBER(38, 0) NOT NULL, platform VARCHAR2(64) NOT NULL, brand VARCHAR2(256), marketing_name VARCHAR2(256), model_identifier VARCHAR2(256) NOT NULL, device_codename VARCHAR2(256), CONSTRAINT PK_PA_CLOUD_DEVICE_INFO_MAPPING 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 pa_cloud_device_info_map_seq START WITH 1 INCREMENT BY 1 CACHE 20;

-- Changeset cloud-connector/2.0.x/20260108-change-sequence-increment.xml::1::Pavel Sindelar
-- Change increment of sequence pa_cloud_device_info_map_seq
ALTER SEQUENCE pa_cloud_device_info_map_seq INCREMENT BY 100;
