Untitled
unknown
plain_text
a year ago
49 kB
17
Indexable
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
Editor is loading...
Leave a Comment