ALTER TABLE `web_1001_combos` 
ADD `numlinea` INT(4) NOT NULL AUTO_INCREMENT  AFTER `cantidad`,
 ADD `codfamilia` INT(3) NOT NULL AFTER `numlinea`, 
ADD `preivi` DECIMAL(19,2) NOT NULL AFTER `codfamilia`, 
ADD `importe` DECIMAL(19,2) NOT NULL AFTER `preivi`, 
ADD `dcto` TINYINT(4) NOT NULL AFTER `importe`,
ADD `mondes` DECIMAL(19,2) NOT NULL AFTER `dcto`, 
ADD `impuesto` DECIMAL(19,2) NOT NULL AFTER `mondes`,
 ADD PRIMARY KEY (`numlinea`);

ALTER TABLE `web_1001_combos` ADD `cdgcombo` INT(10) NOT NULL FIRST;


UPDATE web_1001_combos SET cdgcombo = '1' WHERE cdgbar_combo = 445;
UPDATE web_1001_combos SET cdgcombo = '2' WHERE cdgbar_combo = 448;
UPDATE web_1001_combos SET cdgcombo = '3' WHERE cdgbar_combo = 449;
UPDATE web_1001_combos SET cdgcombo = '4' WHERE cdgbar_combo = 450;
UPDATE web_1001_combos SET cdgcombo = '5' WHERE cdgbar_combo = 457;
UPDATE web_1001_combos SET cdgcombo = '6' WHERE cdgbar_combo = 452;
UPDATE web_1001_combos SET cdgcombo = '7' WHERE cdgbar_combo = 453;
UPDATE web_1001_combos SET cdgcombo = '8' WHERE cdgbar_combo = 460;
UPDATE web_1001_combos SET cdgcombo = '9' WHERE cdgbar_combo = 455;
UPDATE web_1001_combos SET cdgcombo = '10' WHERE cdgbar_combo = 461;
UPDATE web_1001_combos SET cdgcombo = '11' WHERE cdgbar_combo = 454;
UPDATE web_1001_combos SET cdgcombo = '12' WHERE cdgbar_combo = 459;
UPDATE web_1001_combos SET cdgcombo = '13' WHERE cdgbar_combo = 456;
UPDATE web_1001_combos SET cdgcombo = '14' WHERE cdgbar_combo = 458;

-- HAY QUE CREAR FAMILIA Y LINES DE CAJAS

-- SE CREA EN ENVENTARIO EL ARCICULO CAJA CAJA

INSERT INTO `web_1001` (`CDGART`, `CDGBAR`, `CDGBAR2`, `CDGBAR3`, `CDGTIPART`, `CDGTIPPRO`, `DSCART`, `ESTART`, `COB_IV`, `cdgtar`, `ivporc`, `tipcanbas`, `tarred`, `cdgtarred`, `tipart`, `DESART`, `DESFAC`, `desmax`, `desmin`, `stockmax`, `stockmin`, `EXIACT`, `cosart`, `utiart1`, `utiart2`, `utiart3`, `utisug`, `PRE001`, `PRE002`, `PRE003`, `impart`, `PREIVI`, `CDGFAM`, `fleart`, `CDGLIN`, `artcom`, `artpes`, `pasillo`, `estante`, `cdgpro`, `UNIMED`, `conexi`, `nomusu`, `fecmod`, `cantomfis`, `fectomfis`, `cdgbod`, `artpro`, `cdghac`, `cdgact`, `canstock`, `cdgtipartrest`) VALUES
(99, '99', '', '', '04', '1', 'CAJAS', 1, 2, '00', '0.00', 0, '0.00', '', '1', 0.00, 0.00, 0.00, 0.00, '0.00', '0.00', 97.00, '1.00', '9900.00', '0.00', '0.00', 0.00, 100.00, 0.00, 0.00, 0.00, 1.00, '006', '0.00', '001', 0, 0, 0, 0, 1, 'Unid', 0, 'RUDDY', '2023-01-31', 0, '0000-00-00', 1, 0, '4817105019900', '552004', '0.00', 2);



-- SE INSERTA LA CAJA EN CADA COMBO 

INSERT INTO `web_1001_combos` (`cdgcombo`, `cdgbar_combo`, `dscart_combo`, `cdgbar`, `dscart`, `cantidad`, `numlinea`, `codfamilia`, `preivi`, `importe`, `dcto`, `mondes`, `impuesto`, `fecha`, `nomusu`) VALUES
(1, '445', 'COMBO CLASICO', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(2, '448', 'COMBO PERSONAL', '99', 'CAJA', 1.00, '',0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(3, '449', 'COMBO FAMILIAR', '99', 'CAJA', 1.00, '',0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(4, '450', 'COMBO STEFFS', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(5, '457', 'BRASILEÃ‘A', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(6, '452', 'CAPRICHOSA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(7, '453', 'HAWAIANA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(8, '460', 'JAMON Y QUESO', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(9, '455', 'MARGARITA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(10, '461', 'MEDITERRANEA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(11, '454', 'MEXICANA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(12, '459', 'PEPERONNI', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(13, '456', 'PIZZA BLANCA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY'),
(12, '458', 'VEGETARIANA', '99', 'CAJA', 1.00, '', 0, '1.00', '1.00', 0, '0.00', '0.00', '2023-01-31', 'RUDDY');
