[FEATURE REQUEST] Additional licence fees about general-licence-manager HOT 3 CLOSED

create table LicenceCategoryAdditionalFees (
	licenceAdditionalFeeKey varchar(80) not null primary key,
	licenceCategoryKey varchar(50) not null,
	additionalFee varchar(100) not null,
	additionalFeeType varchar(10) not null,
	additionalFeeNumber decimal(10, 2) not null default 0,
	additionalFeeFunction varchar(50) not null default '',
	isRequired bit not null default 0,
	orderNumber smallint not null default 0,
	recordCreate_userName varchar(30) not null,
	recordCreate_timeMillis integer not null,
	recordUpdate_userName varchar(30) not null,
	recordUpdate_timeMillis integer not null,
	recordDelete_userName varchar(30),
	recordDelete_timeMillis integer,
	foreign key (licenceCategoryKey) references LicenceCategories (licenceCategoryKey)
) without rowid

create table LicenceAdditionalFees (
	licenceId integer not null,
	licenceAdditionalFeeKey varchar(80) not null,
	additionalFeeAmount decimal(10, 2) not null default 0,
	primary key (licenceId, licenceAdditionalFeeKey),
	foreign key (licenceId) references Licences (licenceId)
) without rowid

alter table Licences
add baseLicenceFee decimal(10, 2) not null default 0

update Licences
set baseLicenceFee = licenceFee

alter table Licences
add baseReplacementFee decimal(10, 2) not null default 0

update Licences
set baseReplacementFee = replacementFee