use softrestaurant95pro;
/*EFECTIVO PRIMER LUGAR*/ UPDATE formasdepago SET prioridadboton=0 where idformadepago = 'EF';
/*DOLAR PRIMER LUGAR*/ UPDATE formasdepago SET prioridadboton=0 where idformadepago = 'DLL';
insert into formasdepago values
/*PASSCARD*/ ('PASS', 'PASSCARD', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*VISA_DEBITO*/ ('VS_DB', 'VISA_DEBITO', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*VISA_DEBITO_PRESTACIONES*/ ('VS_DP', 'VISA_DEBITO_PRESTACIONES', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*VISA_ALIMENTACION*/ ('VS_AL', 'VISA_ALIMENTACION', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*AMEX*/ ('AMEX', 'AMEX', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*ANDA*/ ('ANDA', 'ANDA', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*CABAL*/ ('CB', 'CABAL', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*CABAL_AFAM*/ ('CB_AF', 'CABAL_AFAM', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*CABAL_DEBIT*/ ('CB_DB', 'CABAL_DEBIT', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*CREDITEL_BPS*/ ('CR_BP', 'CREDITEL_BPS', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*CREDITEL*/ ('CRED', 'CREDITEL', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*CREDITOS_DIRECTOS*/ ('CR_DR', 'CREDITOS_DIRECTOS', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*EDENRED*/ ('EDNR', 'EDENRED', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*MASTERCARD*/ ('MC', 'MASTERCARD', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*MASTER_JCB*/ ('MC_JC', 'MASTER_JCB', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*DINERS*/ ('DNRS', 'DINERS', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*MAESTRO*/ ('MA', 'MAESTRO', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*MAESTRO_AFAM*/ ('MA_AF', 'MAESTRO_AFAM', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*LIDER*/ ('LD', 'LIDER', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*LIDER_AFAM*/ ('LD_AF', 'LIDER_AFAM', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*LIDER_SODEXO*/ ('LD_SO', 'LIDER_SODEXO', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 2, '', 04),
/*OCA*/ ('OCA', 'OCA', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04),
/*OCA_AFAM*/ ('OC_AF', 'OCA_AFAM', 2, 1.00, 0, 1, 02, '' , '' , 0.00, 1, 1, 0, '', '', '', '', 0, 0, 0, 0 , 0, '', 0, NULL, NULL, 1, '', 04);
