[~AlexHeylin] Thanks for pointing this out, we'll consider it. Or better, if you can send us the PR with above modifications.

I'll test this in my dev and send you PR when ready. Thanks

On Fri, 8 Jun 2018, 08:21 Devang Nathwani, <notifications@github.com> wrote:

> [~AlexHeylin] <https://github.com/AlexHeylin> Thanks for pointing this out,
> we'll consider it. Or better, if you can send us the PR with above
> modifications.
>
> —
> You are receiving this because you were mentioned.
> Reply to this email directly, view it on GitHub
> <https://github.com/iNextrix/ASTPP/issues/432#issuecomment-395672552>, or mute
> the thread
> <https://github.com/notifications/unsubscribe-auth/AAQifYUwnK2qcePYBbMirStN5JALgy7rks5t6iXlgaJpZM4UX2iH>
> .
>

This is what I'm testing in my dev

astpp.sweeplist.id = int(10) unsigned -> astpp.accounts.sweep_id = tinyint(1)

 
ALTER TABLE `accounts` CHANGE COLUMN `sweep_id` `sweep_id` INT(10) UNSIGNED NOT NULL 
DEFAULT '0' COMMENT 'Sweep list table id' AFTER `status`;

astpp.sweeplist.id = int(10) unsigned -> astpp.charges.sweep_id = int(1)

ALTER TABLE `charges`CHANGE COLUMN `sweep_id` `sweep_id` INT(10) UNSIGNED NOT NULL 
DEFAULT '0' COMMENT 'sweeplist table id' AFTER `pro_rate`;

astpp.cdrs.trunk_id = smallint(6) -> astpp.trunks.id = int(11)

ALTER TABLE `cdrs` CHANGE COLUMN `trunk_id` `trunk_id` INT(11) NOT NULL 
DEFAULT '0' AFTER `billseconds`;

astpp.cdrs.pricelist_id = smallint(6) -> astpp.pricelists.id = int(11)

ALTER TABLE `cdrs` CHANGE COLUMN `pricelist_id` `pricelist_id` INT(11) NOT NULL 
DEFAULT '0' AFTER `provider_id`;

astpp.ip_map.pricelist_id = int(4) -> astpp.pricelists.id = int(11)

ALTER TABLE `ip_map` CHANGE COLUMN `pricelist_id` `pricelist_id` INT(11) NOT NULL 
DEFAULT '0' AFTER `accountid`;

astpp.packages.pricelist_id = int(4) -> astpp.pricelists.id = int(11)

 
ALTER TABLE `packages` CHANGE COLUMN `pricelist_id` `pricelist_id` INT(11) NOT NULL 
DEFAULT '0' COMMENT 'pricelist table id' AFTER `package_name`;

astpp.reseller_cdrs.pricelist_id = smallint(6) -> astpp.pricelists.id = int(11)

ALTER TABLE `reseller_cdrs` CHANGE COLUMN `package_id` `package_id` INT(11) NOT NULL 
DEFAULT '0' AFTER `pricelist_id`;

Hi [~AlexHeylin]

Does it work well?
If so, please send PR.

Hi (Community) DN

Please do needful to update to sql.

[~AlexHeylin] It has been fixed in V-4.0, you can update version and verify.