CREATE TABLE [products] (
  [NotUsed] varchar(1),
  [ProductId] varchar(5) NOT NULL,
  [Barcode] varchar(40) NOT NULL PRIMARY KEY,
  [Description] varchar(60),
  [Group] varchar(10),
  [StandardPrice] varchar(10),
  [SellPrice] varchar(10),
  [Discount] varchar(10),
  [Content] varchar(20),
[Unit] varchar(10) );

CREATE TABLE [products_staging] (
  [NotUsed] varchar(1),
  [ProductId] varchar(5) NOT NULL,
  [Barcode] varchar(40) NOT NULL PRIMARY KEY,
  [Description] varchar(60),
  [Group] varchar(10),
  [StandardPrice] varchar(10),
  [SellPrice] varchar(10),
  [Discount] varchar(10),
  [Content] varchar(20),
  [Unit] varchar(10),
  [DELETE] varchar(1) );
-- Example Data for table `products`

INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','001', '3083680012256', 'BONDUELLE CARROTS ', '93', '0.95', '0.95', '', '180', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','002', '3083680915816', 'BONDUELLE FANTASIA FESTINI', '93', '0.99', '0.99', '', '400', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','003', '3083680823609', 'BOND BUNTER MIX', '93', '1.29', '0.89', '31%', '400', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','004', '3083680047760', 'BOND APPEL COMPOTE', '93', '0.79', '0.79', '', '150', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','005', '24000190257', 'DEL MONTE TOMATO PASTA', '93', '1.82', '1.49', '18%', '400', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit])
VALUES ('','006', '38900014605', 'DOLE PINEAPPLE ON JUICE', '93', '1.75', '1.75', '', '680', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','007', '3083680844048', 'BOND ITALIAN MIX', '93', '2.10', '2.10', '', '800', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','008', '8718114412160', 'FRUCTIS 2 IN 1 SHAMPOO', '2', '3.80', '3.80', '', '300', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','009', '5410091686352', 'SWARZKOPF SHAMPOO PEACH', '2', '2.95', '2.95', '', '400', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','010', '4005808128600', 'NIVEA FOR MEN SPORT', '2', '3.95', '2.95', '25%', '250', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','011', '5410091666279', 'SWARZKOPF JUNIOR STYLING', '2', '4.50', '3.99', '11%', '250', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','012', '3014260000318', 'GILLETTE SHAVING FOAM', '2', '6.99', '6.99', '', '200', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','013', '8710402362126', 'PRODENT TOOTHPASTE', '2', '2.05', '2.05', '', '75', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','014', '5701007022464', 'AQUAFRESH TOOTHPASTE', '2', '1.80', '1.80', '', '75', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','015', '8714789019468', 'COLGATE SENSATION WHITE', '2', '2.29', '2.29', '', '75', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','016', '8716800452049', 'ELMEX TOOTHPASTE', '2', '1.65', '1.65', '28%', '75', 'ML');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','017', '8711000028605', 'PICKWICK FOREST FRUIT', '27', '1.29', '1.29', '', '40', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','018', '8711000018705', 'PICKWICK TEA MINT ', '27', '1.29', '1.29', '', '40', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','019', '8711000008737', 'PICKWICK TEA LEMON', '27', '0.89', '0.89', '', '30', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','020', '8711000003145', 'FOLGERS CLASSIC ROAST', '27', '2.99', '2.99', '17', '250', 'GR');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','021', '8711000194553', 'D-E SENSEO REGULAR', '27', '2.49', '2.49', '', '36', 'PCS');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','022', '8711000194584', 'D-E SENSEO DARK ROAST', '27', '2.49', '2.49', '', '36', 'PCS');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','023', '5410013142003', 'SPA & FRUIT ORANGE', '30', '0.79', '0.79', '', '1.5', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','024', '5410013142004', 'SPA & FRUIT ORANGE', '30', '0.79', '0.79', '', '1.5', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','025', '5410013142005', 'SPA & FRUIT ORANGE', '30', '0.79', '0.79', '', '15', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','026', '8715600227284', '7-UP', '30', '0.95', '0.95', '', '1.5', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','027', '5410013109679', 'SPA SPARKLING WATER', '30', '0.59', '0.59', '', '1.5', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','028', '8713500008460', 'HERO CASSIS', '30', '0.79', '0.79', '', '1.25', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','029', '8713300069340', 'TROPICANA APPEL JUICE', '30', '1.29', '0.99', '23%', '1', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','030', '2076210399997', 'HOUSE WINE WHITE DRY', '30', '3.99', '3.99', '', '2', 'LT');
INSERT INTO [products] ([NotUsed], [ProductId], [Barcode], [Description], [Group], [StandardPrice], [SellPrice], [Discount], [Content], [Unit]) 
VALUES ('','031', '2076210399993', 'HOUSE WINE RED', '30', '3.99', '3.99', '', '2', 'LT');

