Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Table creation
- CREATE TABLE `enable_disable_wallet_user_feature` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `add_feature` bit(1) NOT NULL,
- `is_active` bit(1) NOT NULL,
- `module` varchar(100) NOT NULL,
- `operation` varchar(100) NOT NULL,
- `user_group` varchar(50) DEFAULT NULL,
- `user_type` varchar(50) DEFAULT NULL,
- `wallet` varchar(15) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1
- ;
- # Data migration
- INSERT INTO profino.enable_disable_wallet_user_feature (add_feature, is_active, module, operation, user_group, user_type, wallet)
- SELECT
- FALSE,
- f.is_active,
- f.disable_module,
- f.disable_operation,
- f.user_group,
- f.user_type,
- f.wallet
- FROM profino.sc_disable_wallet_user_feature f
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement