Untitled

mail@pastecode.io avatar
unknown
plain_text
13 days ago
49 kB
1
Indexable
Never
2024-07-02T10:28:51.491+03:00 ERROR 80568 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542 [Failed SQL: (0) create schema if not exists raeicei;

create sequence raeicei.revinfo_seq
    increment by 50;

create table raeicei.devices
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    description varchar(255),
    name        varchar(255) not null,
    type        varchar(255) not null
);

create table raeicei.eid_administrator
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    contact     varchar(255),
    eik_number  varchar(255) not null,
    is_active   boolean,
    name        varchar(255) not null
);

create table raeicei.administrator_front_office
(
    id                   uuid         not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    contact              varchar(255) not null,
    is_active            boolean,
    location             varchar(255) not null,
    name                 varchar(255) not null,
    region               varchar(255) not null,
    eid_administrator_id uuid         not null
        constraint fkaa7ai8y75cdlk4eit2m97vujj
            references raeicei.eid_administrator
);

create table raeicei.device_tariffs
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    price                double precision not null,
    start_date           date             not null,
    device_id            uuid             not null
        constraint uk_lkp5h2uqn905sff9f9xkdy6js
            unique
        constraint fkiat50ixx0swp53sr81adc4wcg
            references devices,
    eid_administrator_id uuid             not null
        constraint fklnofaawx21hvodutubxfg2sg3
            references raeicei.eid_administrator
);

create table raeicei.discounts
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    age_from             integer          not null,
    age_until            integer          not null,
    disability           boolean,
    discount             double precision not null,
    start_date           date             not null,
    eid_administrator_id uuid             not null
        constraint fkld0xlun3u81jfkiagrbtutag1
            references raeicei.eid_administrator
);

create table raeicei.tariffs
(
    id                       uuid             not null
        primary key,
    create_date              timestamp(6),
    created_by               varchar(255),
    last_update              timestamp(6),
    updated_by               varchar(255),
    version                  bigint,
    currency                 varchar(255)
        constraint tariffs_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision not null,
    revoke_application_price double precision not null,
    start_application_price  double precision not null,
    start_date               date             not null,
    stop_application_price   double precision not null,
    eid_administrator_id     uuid             not null
        constraint fkobrmkn30xfhtoek0v91icoybs
            references raeicei.eid_administrator
);

create table raeicei.administrator_front_office_devices
(
    administrator_front_office_id uuid not null
        constraint fk2el8uygbiguylh28tuovtdswx
            references raeicei.administrator_front_office,
    devices_id                    uuid not null
        constraint uk_j5g08t98vllgff2p8fmqxoggs
            unique
        constraint fkw6j5gyfhb3kpi93a0vxra75a
            references raeicei.devices
);

create table raeicei.revinfo
(
    rev      integer not null
        primary key,
    revtstmp bigint
);

create table raeicei.administrator_front_office_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkhc3vr2qvvsengi1m7f87ekoi
            references raeicei.revinfo,
    revtype              smallint,
    contact              varchar(255),
    is_active            boolean,
    location             varchar(255),
    name                 varchar(255),
    region               varchar(255)
        constraint administrator_front_office_aud_region_check
            check ((region >= 0) AND (region <= 28)),
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.device_tariffs_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fk3dc8gm082upwq6x2jxw6l1oy2
            references raeicei.revinfo,
    revtype              smallint,
    price                double precision,
    start_date           date,
    device_id            uuid,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table devices_aud
(
    id          uuid    not null,
    rev         integer not null
        constraint fk334l0xy7gy0qjjfr5pe1wwxie
            references raeicei.revinfo,
    revtype     smallint,
    description varchar(255),
    name        varchar(255),
    type        varchar(255),
    primary key (rev, id)
);

create table raeicei.discounts_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkn2d7xmo6yoj2m4nso3eta8cdu
            references raeicei.revinfo,
    revtype              smallint,
    age_from             integer,
    age_until            integer,
    disability           boolean,
    discount             double precision,
    start_date           date,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.eid_administrator_aud
(
    id         uuid    not null,
    rev        integer not null
        constraint fk8rh5kc77fqy9h2ebea77nibfv
            references raeicei.revinfo,
    revtype    smallint,
    contact    varchar(255),
    eik_number varchar(255),
    is_active  boolean,
    name       varchar(255),
    primary key (rev, id)
);

create table raeicei.tariffs_aud
(
    id                       uuid    not null,
    rev                      integer not null
        constraint fk5jarao91dpmdsml4dvdnywne4
            references raeicei.revinfo,
    revtype                  smallint,
    currency                 varchar(255)
        constraint tariffs_aud_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision,
    revoke_application_price double precision,
    start_application_price  double precision,
    start_date               date,
    stop_application_price   double precision,
    eid_administrator_id     uuid,
    primary key (rev, id)
);

create table raeicei.administrator_front_office_devices_aud
(
    rev                           integer not null
        constraint fk7xb7vhu9tffsosugmf6uwg62c
            references raeicei.revinfo,
    administrator_front_office_id uuid    not null,
    devices_id                    uuid    not null,
    revtype                       smallint,
    primary key (administrator_front_office_id, rev, devices_id)
)]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1770)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:520)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:313)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1156)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:931)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:608)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:733)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:435)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:311)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1305)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1294)
	at bg.bulsi.mvr.raeicei.backend.BackendApplication.main(BackendApplication.java:11)
Caused by: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542 [Failed SQL: (0) create schema if not exists raeicei;

create sequence raeicei.revinfo_seq
    increment by 50;

create table raeicei.devices
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    description varchar(255),
    name        varchar(255) not null,
    type        varchar(255) not null
);

create table raeicei.eid_administrator
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    contact     varchar(255),
    eik_number  varchar(255) not null,
    is_active   boolean,
    name        varchar(255) not null
);

create table raeicei.administrator_front_office
(
    id                   uuid         not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    contact              varchar(255) not null,
    is_active            boolean,
    location             varchar(255) not null,
    name                 varchar(255) not null,
    region               varchar(255) not null,
    eid_administrator_id uuid         not null
        constraint fkaa7ai8y75cdlk4eit2m97vujj
            references raeicei.eid_administrator
);

create table raeicei.device_tariffs
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    price                double precision not null,
    start_date           date             not null,
    device_id            uuid             not null
        constraint uk_lkp5h2uqn905sff9f9xkdy6js
            unique
        constraint fkiat50ixx0swp53sr81adc4wcg
            references devices,
    eid_administrator_id uuid             not null
        constraint fklnofaawx21hvodutubxfg2sg3
            references raeicei.eid_administrator
);

create table raeicei.discounts
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    age_from             integer          not null,
    age_until            integer          not null,
    disability           boolean,
    discount             double precision not null,
    start_date           date             not null,
    eid_administrator_id uuid             not null
        constraint fkld0xlun3u81jfkiagrbtutag1
            references raeicei.eid_administrator
);

create table raeicei.tariffs
(
    id                       uuid             not null
        primary key,
    create_date              timestamp(6),
    created_by               varchar(255),
    last_update              timestamp(6),
    updated_by               varchar(255),
    version                  bigint,
    currency                 varchar(255)
        constraint tariffs_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision not null,
    revoke_application_price double precision not null,
    start_application_price  double precision not null,
    start_date               date             not null,
    stop_application_price   double precision not null,
    eid_administrator_id     uuid             not null
        constraint fkobrmkn30xfhtoek0v91icoybs
            references raeicei.eid_administrator
);

create table raeicei.administrator_front_office_devices
(
    administrator_front_office_id uuid not null
        constraint fk2el8uygbiguylh28tuovtdswx
            references raeicei.administrator_front_office,
    devices_id                    uuid not null
        constraint uk_j5g08t98vllgff2p8fmqxoggs
            unique
        constraint fkw6j5gyfhb3kpi93a0vxra75a
            references raeicei.devices
);

create table raeicei.revinfo
(
    rev      integer not null
        primary key,
    revtstmp bigint
);

create table raeicei.administrator_front_office_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkhc3vr2qvvsengi1m7f87ekoi
            references raeicei.revinfo,
    revtype              smallint,
    contact              varchar(255),
    is_active            boolean,
    location             varchar(255),
    name                 varchar(255),
    region               varchar(255)
        constraint administrator_front_office_aud_region_check
            check ((region >= 0) AND (region <= 28)),
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.device_tariffs_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fk3dc8gm082upwq6x2jxw6l1oy2
            references raeicei.revinfo,
    revtype              smallint,
    price                double precision,
    start_date           date,
    device_id            uuid,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table devices_aud
(
    id          uuid    not null,
    rev         integer not null
        constraint fk334l0xy7gy0qjjfr5pe1wwxie
            references raeicei.revinfo,
    revtype     smallint,
    description varchar(255),
    name        varchar(255),
    type        varchar(255),
    primary key (rev, id)
);

create table raeicei.discounts_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkn2d7xmo6yoj2m4nso3eta8cdu
            references raeicei.revinfo,
    revtype              smallint,
    age_from             integer,
    age_until            integer,
    disability           boolean,
    discount             double precision,
    start_date           date,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.eid_administrator_aud
(
    id         uuid    not null,
    rev        integer not null
        constraint fk8rh5kc77fqy9h2ebea77nibfv
            references raeicei.revinfo,
    revtype    smallint,
    contact    varchar(255),
    eik_number varchar(255),
    is_active  boolean,
    name       varchar(255),
    primary key (rev, id)
);

create table raeicei.tariffs_aud
(
    id                       uuid    not null,
    rev                      integer not null
        constraint fk5jarao91dpmdsml4dvdnywne4
            references raeicei.revinfo,
    revtype                  smallint,
    currency                 varchar(255)
        constraint tariffs_aud_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision,
    revoke_application_price double precision,
    start_application_price  double precision,
    start_date               date,
    stop_application_price   double precision,
    eid_administrator_id     uuid,
    primary key (rev, id)
);

create table raeicei.administrator_front_office_devices_aud
(
    rev                           integer not null
        constraint fk7xb7vhu9tffsosugmf6uwg62c
            references raeicei.revinfo,
    administrator_front_office_id uuid    not null,
    devices_id                    uuid    not null,
    revtype                       smallint,
    primary key (administrator_front_office_id, rev, devices_id)
)]
	at liquibase.command.CommandScope.execute(CommandScope.java:235)
	at liquibase.Liquibase.lambda$update$0(Liquibase.java:237)
	at liquibase.Scope.lambda$child$0(Scope.java:194)
	at liquibase.Scope.child(Scope.java:203)
	at liquibase.Scope.child(Scope.java:193)
	at liquibase.Scope.child(Scope.java:172)
	at liquibase.Liquibase.runInScope(Liquibase.java:1618)
	at liquibase.Liquibase.update(Liquibase.java:229)
	at liquibase.Liquibase.update(Liquibase.java:213)
	at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:329)
	at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:284)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1816)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766)
	... 18 common frames omitted
Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542 [Failed SQL: (0) create schema if not exists raeicei;

create sequence raeicei.revinfo_seq
    increment by 50;

create table raeicei.devices
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    description varchar(255),
    name        varchar(255) not null,
    type        varchar(255) not null
);

create table raeicei.eid_administrator
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    contact     varchar(255),
    eik_number  varchar(255) not null,
    is_active   boolean,
    name        varchar(255) not null
);

create table raeicei.administrator_front_office
(
    id                   uuid         not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    contact              varchar(255) not null,
    is_active            boolean,
    location             varchar(255) not null,
    name                 varchar(255) not null,
    region               varchar(255) not null,
    eid_administrator_id uuid         not null
        constraint fkaa7ai8y75cdlk4eit2m97vujj
            references raeicei.eid_administrator
);

create table raeicei.device_tariffs
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    price                double precision not null,
    start_date           date             not null,
    device_id            uuid             not null
        constraint uk_lkp5h2uqn905sff9f9xkdy6js
            unique
        constraint fkiat50ixx0swp53sr81adc4wcg
            references devices,
    eid_administrator_id uuid             not null
        constraint fklnofaawx21hvodutubxfg2sg3
            references raeicei.eid_administrator
);

create table raeicei.discounts
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    age_from             integer          not null,
    age_until            integer          not null,
    disability           boolean,
    discount             double precision not null,
    start_date           date             not null,
    eid_administrator_id uuid             not null
        constraint fkld0xlun3u81jfkiagrbtutag1
            references raeicei.eid_administrator
);

create table raeicei.tariffs
(
    id                       uuid             not null
        primary key,
    create_date              timestamp(6),
    created_by               varchar(255),
    last_update              timestamp(6),
    updated_by               varchar(255),
    version                  bigint,
    currency                 varchar(255)
        constraint tariffs_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision not null,
    revoke_application_price double precision not null,
    start_application_price  double precision not null,
    start_date               date             not null,
    stop_application_price   double precision not null,
    eid_administrator_id     uuid             not null
        constraint fkobrmkn30xfhtoek0v91icoybs
            references raeicei.eid_administrator
);

create table raeicei.administrator_front_office_devices
(
    administrator_front_office_id uuid not null
        constraint fk2el8uygbiguylh28tuovtdswx
            references raeicei.administrator_front_office,
    devices_id                    uuid not null
        constraint uk_j5g08t98vllgff2p8fmqxoggs
            unique
        constraint fkw6j5gyfhb3kpi93a0vxra75a
            references raeicei.devices
);

create table raeicei.revinfo
(
    rev      integer not null
        primary key,
    revtstmp bigint
);

create table raeicei.administrator_front_office_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkhc3vr2qvvsengi1m7f87ekoi
            references raeicei.revinfo,
    revtype              smallint,
    contact              varchar(255),
    is_active            boolean,
    location             varchar(255),
    name                 varchar(255),
    region               varchar(255)
        constraint administrator_front_office_aud_region_check
            check ((region >= 0) AND (region <= 28)),
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.device_tariffs_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fk3dc8gm082upwq6x2jxw6l1oy2
            references raeicei.revinfo,
    revtype              smallint,
    price                double precision,
    start_date           date,
    device_id            uuid,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table devices_aud
(
    id          uuid    not null,
    rev         integer not null
        constraint fk334l0xy7gy0qjjfr5pe1wwxie
            references raeicei.revinfo,
    revtype     smallint,
    description varchar(255),
    name        varchar(255),
    type        varchar(255),
    primary key (rev, id)
);

create table raeicei.discounts_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkn2d7xmo6yoj2m4nso3eta8cdu
            references raeicei.revinfo,
    revtype              smallint,
    age_from             integer,
    age_until            integer,
    disability           boolean,
    discount             double precision,
    start_date           date,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.eid_administrator_aud
(
    id         uuid    not null,
    rev        integer not null
        constraint fk8rh5kc77fqy9h2ebea77nibfv
            references raeicei.revinfo,
    revtype    smallint,
    contact    varchar(255),
    eik_number varchar(255),
    is_active  boolean,
    name       varchar(255),
    primary key (rev, id)
);

create table raeicei.tariffs_aud
(
    id                       uuid    not null,
    rev                      integer not null
        constraint fk5jarao91dpmdsml4dvdnywne4
            references raeicei.revinfo,
    revtype                  smallint,
    currency                 varchar(255)
        constraint tariffs_aud_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision,
    revoke_application_price double precision,
    start_application_price  double precision,
    start_date               date,
    stop_application_price   double precision,
    eid_administrator_id     uuid,
    primary key (rev, id)
);

create table raeicei.administrator_front_office_devices_aud
(
    rev                           integer not null
        constraint fk7xb7vhu9tffsosugmf6uwg62c
            references raeicei.revinfo,
    administrator_front_office_id uuid    not null,
    devices_id                    uuid    not null,
    revtype                       smallint,
    primary key (administrator_front_office_id, rev, devices_id)
)]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:123)
	at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102)
	at liquibase.Scope.lambda$child$0(Scope.java:194)
	at liquibase.Scope.child(Scope.java:203)
	at liquibase.Scope.child(Scope.java:193)
	at liquibase.Scope.child(Scope.java:172)
	at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99)
	at liquibase.command.CommandScope.execute(CommandScope.java:212)
	... 30 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542 [Failed SQL: (0) create schema if not exists raeicei;

create sequence raeicei.revinfo_seq
    increment by 50;

create table raeicei.devices
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    description varchar(255),
    name        varchar(255) not null,
    type        varchar(255) not null
);

create table raeicei.eid_administrator
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    contact     varchar(255),
    eik_number  varchar(255) not null,
    is_active   boolean,
    name        varchar(255) not null
);

create table raeicei.administrator_front_office
(
    id                   uuid         not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    contact              varchar(255) not null,
    is_active            boolean,
    location             varchar(255) not null,
    name                 varchar(255) not null,
    region               varchar(255) not null,
    eid_administrator_id uuid         not null
        constraint fkaa7ai8y75cdlk4eit2m97vujj
            references raeicei.eid_administrator
);

create table raeicei.device_tariffs
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    price                double precision not null,
    start_date           date             not null,
    device_id            uuid             not null
        constraint uk_lkp5h2uqn905sff9f9xkdy6js
            unique
        constraint fkiat50ixx0swp53sr81adc4wcg
            references devices,
    eid_administrator_id uuid             not null
        constraint fklnofaawx21hvodutubxfg2sg3
            references raeicei.eid_administrator
);

create table raeicei.discounts
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    age_from             integer          not null,
    age_until            integer          not null,
    disability           boolean,
    discount             double precision not null,
    start_date           date             not null,
    eid_administrator_id uuid             not null
        constraint fkld0xlun3u81jfkiagrbtutag1
            references raeicei.eid_administrator
);

create table raeicei.tariffs
(
    id                       uuid             not null
        primary key,
    create_date              timestamp(6),
    created_by               varchar(255),
    last_update              timestamp(6),
    updated_by               varchar(255),
    version                  bigint,
    currency                 varchar(255)
        constraint tariffs_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision not null,
    revoke_application_price double precision not null,
    start_application_price  double precision not null,
    start_date               date             not null,
    stop_application_price   double precision not null,
    eid_administrator_id     uuid             not null
        constraint fkobrmkn30xfhtoek0v91icoybs
            references raeicei.eid_administrator
);

create table raeicei.administrator_front_office_devices
(
    administrator_front_office_id uuid not null
        constraint fk2el8uygbiguylh28tuovtdswx
            references raeicei.administrator_front_office,
    devices_id                    uuid not null
        constraint uk_j5g08t98vllgff2p8fmqxoggs
            unique
        constraint fkw6j5gyfhb3kpi93a0vxra75a
            references raeicei.devices
);

create table raeicei.revinfo
(
    rev      integer not null
        primary key,
    revtstmp bigint
);

create table raeicei.administrator_front_office_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkhc3vr2qvvsengi1m7f87ekoi
            references raeicei.revinfo,
    revtype              smallint,
    contact              varchar(255),
    is_active            boolean,
    location             varchar(255),
    name                 varchar(255),
    region               varchar(255)
        constraint administrator_front_office_aud_region_check
            check ((region >= 0) AND (region <= 28)),
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.device_tariffs_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fk3dc8gm082upwq6x2jxw6l1oy2
            references raeicei.revinfo,
    revtype              smallint,
    price                double precision,
    start_date           date,
    device_id            uuid,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table devices_aud
(
    id          uuid    not null,
    rev         integer not null
        constraint fk334l0xy7gy0qjjfr5pe1wwxie
            references raeicei.revinfo,
    revtype     smallint,
    description varchar(255),
    name        varchar(255),
    type        varchar(255),
    primary key (rev, id)
);

create table raeicei.discounts_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkn2d7xmo6yoj2m4nso3eta8cdu
            references raeicei.revinfo,
    revtype              smallint,
    age_from             integer,
    age_until            integer,
    disability           boolean,
    discount             double precision,
    start_date           date,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.eid_administrator_aud
(
    id         uuid    not null,
    rev        integer not null
        constraint fk8rh5kc77fqy9h2ebea77nibfv
            references raeicei.revinfo,
    revtype    smallint,
    contact    varchar(255),
    eik_number varchar(255),
    is_active  boolean,
    name       varchar(255),
    primary key (rev, id)
);

create table raeicei.tariffs_aud
(
    id                       uuid    not null,
    rev                      integer not null
        constraint fk5jarao91dpmdsml4dvdnywne4
            references raeicei.revinfo,
    revtype                  smallint,
    currency                 varchar(255)
        constraint tariffs_aud_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision,
    revoke_application_price double precision,
    start_application_price  double precision,
    start_date               date,
    stop_application_price   double precision,
    eid_administrator_id     uuid,
    primary key (rev, id)
);

create table raeicei.administrator_front_office_devices_aud
(
    rev                           integer not null
        constraint fk7xb7vhu9tffsosugmf6uwg62c
            references raeicei.revinfo,
    administrator_front_office_id uuid    not null,
    devices_id                    uuid    not null,
    revtype                       smallint,
    primary key (administrator_front_office_id, rev, devices_id)
)]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:761)
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:61)
	at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111)
	at liquibase.Scope.lambda$child$0(Scope.java:194)
	at liquibase.Scope.child(Scope.java:203)
	at liquibase.Scope.child(Scope.java:193)
	at liquibase.Scope.child(Scope.java:172)
	at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:111)
	at liquibase.Scope.lambda$child$0(Scope.java:194)
	at liquibase.Scope.child(Scope.java:203)
	at liquibase.Scope.child(Scope.java:193)
	at liquibase.Scope.child(Scope.java:172)
	at liquibase.Scope.child(Scope.java:260)
	at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94)
	at liquibase.Scope.lambda$child$0(Scope.java:194)
	at liquibase.Scope.child(Scope.java:203)
	at liquibase.Scope.child(Scope.java:193)
	at liquibase.Scope.child(Scope.java:172)
	at liquibase.Scope.child(Scope.java:260)
	at liquibase.Scope.child(Scope.java:264)
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:68)
	... 37 common frames omitted
Caused by: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542 [Failed SQL: (0) create schema if not exists raeicei;

create sequence raeicei.revinfo_seq
    increment by 50;

create table raeicei.devices
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    description varchar(255),
    name        varchar(255) not null,
    type        varchar(255) not null
);

create table raeicei.eid_administrator
(
    id          uuid         not null
        primary key,
    create_date timestamp(6),
    created_by  varchar(255),
    last_update timestamp(6),
    updated_by  varchar(255),
    version     bigint,
    contact     varchar(255),
    eik_number  varchar(255) not null,
    is_active   boolean,
    name        varchar(255) not null
);

create table raeicei.administrator_front_office
(
    id                   uuid         not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    contact              varchar(255) not null,
    is_active            boolean,
    location             varchar(255) not null,
    name                 varchar(255) not null,
    region               varchar(255) not null,
    eid_administrator_id uuid         not null
        constraint fkaa7ai8y75cdlk4eit2m97vujj
            references raeicei.eid_administrator
);

create table raeicei.device_tariffs
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    price                double precision not null,
    start_date           date             not null,
    device_id            uuid             not null
        constraint uk_lkp5h2uqn905sff9f9xkdy6js
            unique
        constraint fkiat50ixx0swp53sr81adc4wcg
            references devices,
    eid_administrator_id uuid             not null
        constraint fklnofaawx21hvodutubxfg2sg3
            references raeicei.eid_administrator
);

create table raeicei.discounts
(
    id                   uuid             not null
        primary key,
    create_date          timestamp(6),
    created_by           varchar(255),
    last_update          timestamp(6),
    updated_by           varchar(255),
    version              bigint,
    age_from             integer          not null,
    age_until            integer          not null,
    disability           boolean,
    discount             double precision not null,
    start_date           date             not null,
    eid_administrator_id uuid             not null
        constraint fkld0xlun3u81jfkiagrbtutag1
            references raeicei.eid_administrator
);

create table raeicei.tariffs
(
    id                       uuid             not null
        primary key,
    create_date              timestamp(6),
    created_by               varchar(255),
    last_update              timestamp(6),
    updated_by               varchar(255),
    version                  bigint,
    currency                 varchar(255)
        constraint tariffs_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision not null,
    revoke_application_price double precision not null,
    start_application_price  double precision not null,
    start_date               date             not null,
    stop_application_price   double precision not null,
    eid_administrator_id     uuid             not null
        constraint fkobrmkn30xfhtoek0v91icoybs
            references raeicei.eid_administrator
);

create table raeicei.administrator_front_office_devices
(
    administrator_front_office_id uuid not null
        constraint fk2el8uygbiguylh28tuovtdswx
            references raeicei.administrator_front_office,
    devices_id                    uuid not null
        constraint uk_j5g08t98vllgff2p8fmqxoggs
            unique
        constraint fkw6j5gyfhb3kpi93a0vxra75a
            references raeicei.devices
);

create table raeicei.revinfo
(
    rev      integer not null
        primary key,
    revtstmp bigint
);

create table raeicei.administrator_front_office_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkhc3vr2qvvsengi1m7f87ekoi
            references raeicei.revinfo,
    revtype              smallint,
    contact              varchar(255),
    is_active            boolean,
    location             varchar(255),
    name                 varchar(255),
    region               varchar(255)
        constraint administrator_front_office_aud_region_check
            check ((region >= 0) AND (region <= 28)),
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.device_tariffs_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fk3dc8gm082upwq6x2jxw6l1oy2
            references raeicei.revinfo,
    revtype              smallint,
    price                double precision,
    start_date           date,
    device_id            uuid,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table devices_aud
(
    id          uuid    not null,
    rev         integer not null
        constraint fk334l0xy7gy0qjjfr5pe1wwxie
            references raeicei.revinfo,
    revtype     smallint,
    description varchar(255),
    name        varchar(255),
    type        varchar(255),
    primary key (rev, id)
);

create table raeicei.discounts_aud
(
    id                   uuid    not null,
    rev                  integer not null
        constraint fkn2d7xmo6yoj2m4nso3eta8cdu
            references raeicei.revinfo,
    revtype              smallint,
    age_from             integer,
    age_until            integer,
    disability           boolean,
    discount             double precision,
    start_date           date,
    eid_administrator_id uuid,
    primary key (rev, id)
);

create table raeicei.eid_administrator_aud
(
    id         uuid    not null,
    rev        integer not null
        constraint fk8rh5kc77fqy9h2ebea77nibfv
            references raeicei.revinfo,
    revtype    smallint,
    contact    varchar(255),
    eik_number varchar(255),
    is_active  boolean,
    name       varchar(255),
    primary key (rev, id)
);

create table raeicei.tariffs_aud
(
    id                       uuid    not null,
    rev                      integer not null
        constraint fk5jarao91dpmdsml4dvdnywne4
            references raeicei.revinfo,
    revtype                  smallint,
    currency                 varchar(255)
        constraint tariffs_aud_currency_check
            check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])),
    resume_application_price double precision,
    revoke_application_price double precision,
    start_application_price  double precision,
    start_date               date,
    stop_application_price   double precision,
    eid_administrator_id     uuid,
    primary key (rev, id)
);

create table raeicei.administrator_front_office_devices_aud
(
    rev                           integer not null
        constraint fk7xb7vhu9tffsosugmf6uwg62c
            references raeicei.revinfo,
    administrator_front_office_id uuid    not null,
    devices_id                    uuid    not null,
    revtype                       smallint,
    primary key (administrator_front_office_id, rev, devices_id)
)]
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:445)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
	at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1287)
	at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1269)
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:718)
	... 57 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 542
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335)
	at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321)
	at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292)
	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
	at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:441)
	... 62 common frames omitted


Process finished with exit code 1
Leave a Comment