Agregar formas de pago Geocom

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