liquibase.changelogs.v3_0_0.schema.yml Maven / Gradle / Ivy
databaseChangeLog:
## UUID
- property:
name: uuid_function
value: NEWID()
dbms: mssql
- property:
name: uuid_function
value: uuid()
dbms: mariadb, mysql
- property:
name: uuid_function
value: md5(random()::text || clock_timestamp()::text)::uuid
dbms: postgresql
## LENGTH function
- property:
name: length
value: len
dbms: mssql
- property:
name: length
value: length
dbms: mariadb, mysql, postgresql
- changeSet:
id: 3.0.0
author: GraviteeSource Team
validCheckSum: 1:any
changes:
## roles, permissions & memberships migration ##
# roles_permissions
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('29',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '10%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('30',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '11%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('17',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '12%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('31',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '13%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('32',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '14%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('26',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '15%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('33',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '16%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('34',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '17%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT', permission = CONCAT('35',substring(permission, 3, ${length}(permission))) where role_scope = 'PORTAL' and permission like '18%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ORGANIZATION', permission = CONCAT('12',substring(permission, 3, ${length}(permission))) where role_scope = 'MANAGEMENT' and permission like '16%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ORGANIZATION', permission = CONCAT('10',substring(permission, 3, ${length}(permission))) where role_scope = 'MANAGEMENT' and permission like '21%'
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT' where role_scope = 'MANAGEMENT' and permission like '17%' and not exists (select * from (select * from ${gravitee_prefix}role_permissions) rp2 where rp2.role_scope = 'ENVIRONMENT' and rp2.permission like '17%' and rp2.role_name = role_name)
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT' where role_scope = 'MANAGEMENT' and permission like '26%' and not exists (select * from (select * from ${gravitee_prefix}role_permissions) rp2 where rp2.role_scope = 'ENVIRONMENT' and rp2.permission like '26%' and rp2.role_name = role_name)
- sql:
sql: update ${gravitee_prefix}role_permissions set role_scope = 'ENVIRONMENT' where role_scope = 'MANAGEMENT' and permission not like '17%' and permission not like '26%'
- sql:
sql: delete from ${gravitee_prefix}role_permissions where role_scope = 'MANAGEMENT'
- addColumn:
tableName: ${gravitee_prefix}role_permissions
columns:
- column:
name: role_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}role_permissions set role_id = CONCAT(role_scope,'_',role_name)
- addNotNullConstraint:
columnDataType: nvarchar(64)
columnName: role_id
tableName: ${gravitee_prefix}role_permissions
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}role_permissions
tableName: ${gravitee_prefix}role_permissions
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}role_permissions
columnNames: role_id, permission
tableName: ${gravitee_prefix}role_permissions
- dropColumn:
columnName: role_scope
tableName: ${gravitee_prefix}role_permissions
- dropColumn:
columnName: role_name
tableName: ${gravitee_prefix}role_permissions
# roles
- sql:
sql: update ${gravitee_prefix}roles set scope = 'ENVIRONMENT' where scope = 'PORTAL'
## insert roles
# dbms: mariadb, mysql
- sql:
dbms: mariadb, mysql
sql: insert into ${gravitee_prefix}roles (scope, name, description, default_role, `system`, created_at, updated_at) select 'ORGANIZATION', r.name, r.description, r.default_role, r.system, r.created_at, r.updated_at from ${gravitee_prefix}roles r where r.scope = 'MANAGEMENT' and exists (select 1 from ${gravitee_prefix}role_permissions rp where rp.role_id = CONCAT('ORGANIZATION_',r.name))
# dbms: postgresql, mssql
- sql:
dbms: postgresql, mssql
sql: insert into ${gravitee_prefix}roles (scope, name, description, default_role, system, created_at, updated_at) select 'ORGANIZATION', r.name, r.description, r.default_role, r.system, r.created_at, r.updated_at from ${gravitee_prefix}roles r where r.scope = 'MANAGEMENT' and exists (select 1 from ${gravitee_prefix}role_permissions rp where rp.role_id = CONCAT('ORGANIZATION_',r.name))
- sql:
sql: update ${gravitee_prefix}roles set scope = 'ENVIRONMENT' where scope = 'MANAGEMENT' and not exists (select 1 from (select * from ${gravitee_prefix}roles) r2 where r2.scope = 'ENVIRONMENT' and r2.name = name)
- sql:
sql: delete from ${gravitee_prefix}roles where scope = 'MANAGEMENT'
- addColumn:
tableName: ${gravitee_prefix}roles
columns:
- column:
name: id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}roles set id = CONCAT(scope,'_',name)
- addNotNullConstraint:
columnDataType: nvarchar(64)
columnName: id
tableName: ${gravitee_prefix}roles
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}roles
tableName: ${gravitee_prefix}roles
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}roles
columnNames: id
tableName: ${gravitee_prefix}roles
# membership_roles
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}membership_roles
tableName: ${gravitee_prefix}membership_roles
- modifyDataType:
columnName: role_scope
newDataType: nvarchar(64)
tableName: ${gravitee_prefix}membership_roles
- sql:
sql: update ${gravitee_prefix}membership_roles set role_scope = 'MANAGEMENT' where role_scope = '1';
- sql:
sql: update ${gravitee_prefix}membership_roles set role_scope = 'PORTAL' where role_scope = '2';
- sql:
sql: update ${gravitee_prefix}membership_roles set role_scope = 'API' where role_scope = '3';
- sql:
sql: update ${gravitee_prefix}membership_roles set role_scope = 'APPLICATION' where role_scope = '4';
- sql:
sql: update ${gravitee_prefix}membership_roles set role_scope = 'GROUP' where role_scope = '5';
- sql:
sql: update ${gravitee_prefix}membership_roles set reference_type = 'ENVIRONMENT', role_scope = 'ENVIRONMENT' WHERE reference_type = 'PORTAL' and role_scope = 'PORTAL'
- sql:
sql: insert into ${gravitee_prefix}membership_roles (user_id, reference_id, reference_type, role_scope, role_name) select user_id, reference_id, 'ORGANIZATION', 'ORGANIZATION', role_name from ${gravitee_prefix}membership_roles mr where mr.reference_type = 'MANAGEMENT' and mr.role_scope = 'MANAGEMENT' and exists (select 1 from ${gravitee_prefix}roles r where r.id = CONCAT('ORGANIZATION_',mr.role_name))
- sql:
sql: update ${gravitee_prefix}membership_roles set reference_type = 'ENVIRONMENT', role_scope = 'ENVIRONMENT' where reference_type = 'MANAGEMENT' and role_scope = 'MANAGEMENT' and not exists (select 1 from (select * from ${gravitee_prefix}membership_roles) mr2 where mr2.reference_type = 'ENVIRONMENT' and mr2.role_scope = 'ENVIRONMENT' and mr2.role_name = role_name and mr2.user_id = user_id)
- sql:
sql: delete from ${gravitee_prefix}membership_roles where reference_type = 'MANAGEMENT' and role_scope = 'MANAGEMENT'
# memberships
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}memberships
tableName: ${gravitee_prefix}memberships
- sql:
sql: update ${gravitee_prefix}memberships set reference_type = 'ENVIRONMENT' WHERE reference_type = 'PORTAL'
- sql:
sql: insert into ${gravitee_prefix}memberships (user_id, reference_id, reference_type, created_at, updated_at) select user_id, reference_id, 'ORGANIZATION', created_at, updated_at from ${gravitee_prefix}memberships m where m.reference_type = 'MANAGEMENT' and exists (select 1 from ${gravitee_prefix}membership_roles mr where mr.user_id = m.user_id and mr.reference_id = m.reference_id and mr.reference_type = 'ORGANIZATION')
- sql:
sql: update ${gravitee_prefix}memberships set reference_type = 'ENVIRONMENT' where reference_type = 'MANAGEMENT' and not exists (select 1 from (select * from ${gravitee_prefix}memberships) m2 where m2.user_id = user_id and reference_id = m2.reference_id and m2.reference_type = 'ENVIRONMENT')
- sql:
sql: delete from ${gravitee_prefix}memberships where reference_type = 'MANAGEMENT'
- addColumn:
tableName: ${gravitee_prefix}memberships
columns:
- column:
name: id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: member_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: member_type
type: nvarchar(64)
constraints:
nullable: true
- column:
name: role_id
type: nvarchar(64)
constraints:
nullable: true
- dropNotNullConstraint:
columnDataType: nvarchar(64)
columnName: user_id
tableName: ${gravitee_prefix}memberships
- sql:
sql: insert into ${gravitee_prefix}memberships (id, member_id, member_type, reference_id, reference_type, role_id, created_at, updated_at) select ${uuid_function} as id, m.user_id, 'USER', m.reference_id, m.reference_type, CONCAT(mr.role_scope,'_',mr.role_name) as role_id, m.created_at, m.updated_at from ${gravitee_prefix}memberships m inner join ${gravitee_prefix}membership_roles mr on mr.user_id = m.user_id and mr.reference_id = m.reference_id and mr.reference_type = m.reference_type
- sql:
sql: delete from ${gravitee_prefix}memberships where id is null
- dropIndex:
indexName: idx_${gravitee_prefix}memberships_userid_referencetype
tableName: ${gravitee_prefix}memberships
- dropColumn:
columnName: user_id
tableName: ${gravitee_prefix}memberships
- addNotNullConstraint:
columnDataType: nvarchar(64)
columnName: id
tableName: ${gravitee_prefix}memberships
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}memberships
columnNames: id
tableName: ${gravitee_prefix}memberships
- dropTable:
tableName: ${gravitee_prefix}membership_roles
## group, group_roles & memberships ##
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}group_roles
tableName: ${gravitee_prefix}group_roles
- modifyDataType:
columnName: role_scope
newDataType: nvarchar(64)
tableName: ${gravitee_prefix}group_roles
- sql:
sql: update ${gravitee_prefix}group_roles set role_scope = 'API' where role_scope = '3';
- sql:
sql: update ${gravitee_prefix}group_roles set role_scope = 'APPLICATION' where role_scope = '4';
- dropNotNullConstraint:
columnDataType: nvarchar(64)
columnName: reference_id
tableName: ${gravitee_prefix}memberships
## insert memberships
# dbms: mariadb, mysql
- sql:
dbms: mariadb, mysql
sql: insert into ${gravitee_prefix}memberships (id, member_id, member_type, reference_id, reference_type, role_id, created_at, updated_at) select ${uuid_function} as id, g.id, 'GROUP', null, gr.role_scope, CONCAT(gr.role_scope,'_',gr.role_name) as role_id, g.created_at, g.updated_at from `${gravitee_prefix}groups` g inner join ${gravitee_prefix}group_roles gr on gr.group_id = g.id
# dbms: postgresql, mssql
- sql:
dbms: postgresql, mssql
sql: insert into ${gravitee_prefix}memberships (id, member_id, member_type, reference_id, reference_type, role_id, created_at, updated_at) select ${uuid_function} as id, g.id, 'GROUP', null, gr.role_scope, CONCAT(gr.role_scope,'_',gr.role_name) as role_id, g.created_at, g.updated_at from ${gravitee_prefix}groups g inner join ${gravitee_prefix}group_roles gr on gr.group_id = g.id
- dropTable:
tableName: ${gravitee_prefix}group_roles
## a plan is now associated to one and only one API ##
- addColumn:
tableName: ${gravitee_prefix}plans
columns:
- column:
name: api
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}plans set api = (select pa.api from ${gravitee_prefix}plan_apis pa where pa.plan_id = id)
- addNotNullConstraint:
tableName: ${gravitee_prefix}plans
columnDataType: nvarchar(64)
columnName: api
- dropIndex:
tableName: ${gravitee_prefix}plan_apis
indexName: idx_${gravitee_prefix}planapis_api
- dropPrimaryKey:
constraintName: pk_${gravitee_prefix}plan_apis
tableName: ${gravitee_prefix}plan_apis
- dropTable:
tableName: ${gravitee_prefix}plan_apis
## organization and environments ##
- addColumn:
tableName: ${gravitee_prefix}pages
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}pages set reference_type='API', reference_id=api where api is not null
- sql:
sql: update ${gravitee_prefix}pages set reference_type='ENVIRONMENT', reference_id='DEFAULT' where api is null
- dropIndex:
indexName: idx_${gravitee_prefix}pages_api
tableName: ${gravitee_prefix}pages
- dropColumn:
columnName: api
tableName: ${gravitee_prefix}pages
- addNotNullConstraint:
tableName: ${gravitee_prefix}pages
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}pages
columnDataType: nvarchar(64)
columnName: reference_id
- addColumn:
tableName: ${gravitee_prefix}ratings
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}ratings set reference_type='API', reference_id=api where api is not null
- sql:
sql: update ${gravitee_prefix}ratings set reference_type='ENVIRONMENT', reference_id='DEFAULT' where api is null
- dropIndex:
indexName: idx_${gravitee_prefix}ratings_api
tableName: ${gravitee_prefix}ratings
- dropColumn:
columnName: api
tableName: ${gravitee_prefix}ratings
- addNotNullConstraint:
tableName: ${gravitee_prefix}ratings
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}ratings
columnDataType: nvarchar(64)
columnName: reference_id
- addColumn:
tableName: ${gravitee_prefix}identity_providers
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}identity_providers set reference_type='ENVIRONMENT', reference_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}identity_providers
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}identity_providers
columnDataType: nvarchar(64)
columnName: reference_id
- addColumn:
tableName: ${gravitee_prefix}parameters
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}parameters set reference_type='ENVIRONMENT', reference_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}parameters
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}parameters
columnDataType: nvarchar(64)
columnName: reference_id
- addColumn:
tableName: ${gravitee_prefix}roles
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}roles set reference_type='ORGANIZATION', reference_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}roles
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}roles
columnDataType: nvarchar(32)
columnName: reference_type
- addColumn:
tableName: ${gravitee_prefix}apis
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}apis set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}apis
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}api_headers
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}api_headers set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}api_headers
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}applications
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: picture
type: nclob
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}applications set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}applications
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}commands
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}commands set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}commands
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}dictionaries
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}dictionaries set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}dictionaries
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}entrypoints
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}entrypoints set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}entrypoints
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}events
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}events set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}events
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}groups
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
## update groups
# dbms: mariadb, mysql
- sql:
dbms: mariadb, mysql
sql: update `${gravitee_prefix}groups` set environment_id='DEFAULT'
# dbms: postgresql, mssql
- sql:
dbms: postgresql, mssql
sql: update ${gravitee_prefix}groups set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}groups
columnDataType: nvarchar(64)
columnName: environment_id
- addColumn:
tableName: ${gravitee_prefix}users
columns:
- column:
name: reference_id
type: nvarchar(64)
constraints:
nullable: true
- column:
name: reference_type
type: nvarchar(32)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}users set reference_type='ORGANIZATION', reference_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}users
columnDataType: nvarchar(64)
columnName: reference_id
- addNotNullConstraint:
tableName: ${gravitee_prefix}users
columnDataType: nvarchar(64)
columnName: reference_id
- addColumn:
tableName: ${gravitee_prefix}views
columns:
- column:
name: environment_id
type: nvarchar(64)
constraints:
nullable: true
- sql:
sql: update ${gravitee_prefix}views set environment_id='DEFAULT'
- addNotNullConstraint:
tableName: ${gravitee_prefix}views
columnDataType: nvarchar(64)
columnName: environment_id
- createTable:
tableName: ${gravitee_prefix}environments
columns:
- column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: name, type: nvarchar(64), constraints: { nullable: true } }
- column: {name: description, type: nvarchar(64), constraints: { nullable: true } }
- column: {name: organization_id, type: nvarchar(64), constraints: { nullable: false } }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}environments
columnNames: id
tableName: ${gravitee_prefix}environments
- sql:
sql: insert into ${gravitee_prefix}environments (id, name, description, organization_id) values ('DEFAULT', 'Default environment', 'Default environment', 'DEFAULT')
- createTable:
tableName: ${gravitee_prefix}environment_domain_restrictions
columns:
- column: {name: environment_id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: domain_restriction, type: nvarchar(64), constraints: { nullable: false } }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}environment_domain_restrictions
columnNames: environment_id, domain_restriction
tableName: ${gravitee_prefix}environment_domain_restrictions
- createTable:
tableName: ${gravitee_prefix}organizations
columns:
- column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: name, type: nvarchar(64), constraints: { nullable: true } }
- column: {name: description, type: nvarchar(64), constraints: { nullable: true } }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}organizations
columnNames: id
tableName: ${gravitee_prefix}organizations
- sql:
sql: insert into ${gravitee_prefix}organizations (id, name, description) values ('DEFAULT', 'Default organization', 'Default organization')
- createTable:
tableName: ${gravitee_prefix}organization_domain_restrictions
columns:
- column: {name: organization_id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: domain_restriction, type: nvarchar(64), constraints: { nullable: false } }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}organization_domain_restrictions
columnNames: organization_id, domain_restriction
tableName: ${gravitee_prefix}organization_domain_restrictions
- createTable:
tableName: ${gravitee_prefix}themes
columns:
- column: {name: id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: name, type: nvarchar(64), constraints: { nullable: true } }
- column: {name: reference_id, type: nvarchar(64), constraints: { nullable: false } }
- column: {name: reference_type, type: nvarchar(32), constraints: { nullable: false } }
- column: {name: enabled, type: boolean, constraints: { nullable: false } }
- column: {name: definition, type: nclob, constraints: { nullable: true } }
- column: {name: created_at, type: timestamp(6), constraints: { nullable: false } }
- column: {name: updated_at, type: timestamp(6), constraints: { nullable: true } }
- column: {name: logo, type: nclob, constraints: { nullable: true } }
- column: {name: optional_logo, type: nclob, constraints: { nullable: true } }
- column: {name: background_image, type: nclob, constraints: { nullable: true } }
- addPrimaryKey:
constraintName: pk_${gravitee_prefix}themes
columnNames: id
tableName: ${gravitee_prefix}themes
## others
- addColumn:
tableName: ${gravitee_prefix}users
columns:
- column:
name: login_count
type: bigint
- sql:
sql: delete from ${gravitee_prefix}parameters where "key" = 'portal.devMode.enabled';
- sql:
sql: delete from ${gravitee_prefix}views where id = 'all';
- dropColumn:
columnName: default_view
tableName: ${gravitee_prefix}views
© 2015 - 2025 Weber Informatics LLC | Privacy Policy