Advertisement
naimul64

Migration_disable_feature

Jan 15th, 2018
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.76 KB | None | 0 0
  1. # Table creation
  2. CREATE TABLE `enable_disable_wallet_user_feature` (
  3.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  4.   `add_feature` bit(1) NOT NULL,
  5.   `is_active` bit(1) NOT NULL,
  6.   `module` varchar(100) NOT NULL,
  7.   `operation` varchar(100) NOT NULL,
  8.   `user_group` varchar(50) DEFAULT NULL,
  9.   `user_type` varchar(50) DEFAULT NULL,
  10.   `wallet` varchar(15) DEFAULT NULL,
  11.   PRIMARY KEY (`id`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  13. ;
  14.  
  15. # Data migration
  16. INSERT INTO profino.enable_disable_wallet_user_feature (add_feature, is_active, module, operation, user_group, user_type, wallet)
  17.   SELECT
  18.     FALSE,
  19.     f.is_active,
  20.     f.disable_module,
  21.     f.disable_operation,
  22.     f.user_group,
  23.     f.user_type,
  24.     f.wallet
  25.   FROM profino.sc_disable_wallet_user_feature f
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement