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);