-- MySQL dump 9.08 -- -- Host: localhost Database: mileniumvalli --------------------------------------------------------- -- Server version 4.0.14-max-debug -- -- Table structure for table 'ordini' -- CREATE TABLE ordini ( nr int(11) NOT NULL auto_increment, date date NOT NULL default '0000-00-00', time time NOT NULL default '00:00:00', operatore varchar(21) default NULL, codice varchar(14) default NULL, descrizione varchar(81) binary NOT NULL default '', numeroordine varchar(11) binary NOT NULL default '', dataordine varchar(11) binary NOT NULL default '', numeroriferimento varchar(11) binary NOT NULL default '', datariferimento varchar(11) binary NOT NULL default '', categoriaanagrafica_1 int(11) NOT NULL default '0', categoriaanagrafica_2 int(11) NOT NULL default '0', ragionesociale varchar(81) binary NOT NULL default '', categoriamagazzino_1 int(11) NOT NULL default '0', categoriamagazzino_2 int(11) NOT NULL default '0', categoriamagazzino_3 int(11) NOT NULL default '0', categoriamagazzino_4 int(11) NOT NULL default '0', prodotto varchar(81) binary NOT NULL default '', codiceprodotto varchar(21) binary NOT NULL default '', datainserimento varchar(11) binary NOT NULL default '', articolo varchar(81) binary NOT NULL default '', codicearticolo varchar(21) binary NOT NULL default '', modello varchar(41) binary NOT NULL default '', varieta varchar(41) binary NOT NULL default '', colore varchar(41) binary NOT NULL default '', lottoproduzione varchar(41) binary NOT NULL default '', annoproduzione varchar(5) binary NOT NULL default '', prezzounitario double default NULL, quantita double default NULL, importo double default NULL, sconto double default NULL, iva double default NULL, nr_art_magazzino int(11) NOT NULL default '0', TABLETAIL int(11) default NULL, PRIMARY KEY (nr) ) TYPE=MyISAM; -- -- Dumping data for table 'ordini' -- INSERT INTO ordini VALUES (77,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','PERA','DOLCE','0','0','2004',0,0,0,0,0,46,1); INSERT INTO ordini VALUES (76,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','MIX','MELA-PESCA-PERA','0','0','2004',0,0,0,0,0,45,1); INSERT INTO ordini VALUES (74,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','MELA','GENERICA','0','0','2004',0,0,0,0,0,43,1); INSERT INTO ordini VALUES (75,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','MELA','GOLDEN','0','0','2004',0,0,0,0,0,44,1); INSERT INTO ordini VALUES (73,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','ALBICOCCA','GIALLA','0','0','2004',0,0,0,0,0,42,1); INSERT INTO ordini VALUES (72,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','PESCA','GIALLA','0','0','2004',0,0,0,0,0,5,1); INSERT INTO ordini VALUES (71,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','PERA','WILLIAM\'S','0','0','2004',0,0,0,0,0,18,1); INSERT INTO ordini VALUES (69,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','MIX','MELA-PESCA-PERA','0','0','2004',0,0,0,0,0,4,1); INSERT INTO ordini VALUES (70,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','PERA','DOLCE','0','0','2004',0,0,0,0,0,10,1); INSERT INTO ordini VALUES (68,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','MELA','GOLDEN','0','0','2004',0,0,0,0,0,26,1); INSERT INTO ordini VALUES (67,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','MELA','GENERICA','0','0','2004',0,0,0,0,0,11,1); INSERT INTO ordini VALUES (66,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','ALBICOCCA','GIALLA','0','0','2004',0,0,0,0,0,13,1); INSERT INTO ordini VALUES (65,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','PESCA','GIALLA','0','0','2004',0,0,0,0,0,41,1); INSERT INTO ordini VALUES (63,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','PERA','DOLCE','0','0','2004',0,0,0,0,0,39,1); INSERT INTO ordini VALUES (64,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','PERA','WILLIAM\'S','0','0','2004',0,0,0,0,0,40,1); INSERT INTO ordini VALUES (61,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','MELA','GOLDEN','0','0','2004',0,0,0,0,0,37,1); INSERT INTO ordini VALUES (62,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','MIX','MELA-PESCA-PERA','0','0','2004',0,0,0,0,0,38,1); INSERT INTO ordini VALUES (59,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','ALBICOCCA','GIALLA','0','0','2004',0,0,0,0,0,35,1); INSERT INTO ordini VALUES (60,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','MELA','GENERICA','0','0','2004',0,0,0,0,0,36,1); INSERT INTO ordini VALUES (78,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','PERA','WILLIAM\'S','0','0','2004',0,0,0,0,0,47,1); INSERT INTO ordini VALUES (79,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','PESCA','GIALLA','0','0','2004',0,0,0,0,0,48,1); INSERT INTO ordini VALUES (80,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO BIO','CB','COLD BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,25,1); INSERT INTO ordini VALUES (81,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO BIO','CB','HOT BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,24,1); INSERT INTO ordini VALUES (82,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO CONVENZIONALE','CC','COLD BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,2,1); INSERT INTO ordini VALUES (83,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO CONVENZIONALE','CC','HOT BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,1,1); INSERT INTO ordini VALUES (84,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'PASSATA DI POMODORO','PP','2005/03/18','MIX DI VERDURE CONVENZIONALE','MVC','COLD BREAK','BRIX 12','0','0','2004',0,0,0,0,0,8,1); INSERT INTO ordini VALUES (85,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'PASSATA DI POMODORO','PP','2005/03/18','PASSATA BIO','PB','COLD BREAK','BRIX 12','0','0','2004',0,0,0,0,0,20,1); INSERT INTO ordini VALUES (86,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'PASSATA DI POMODORO','PP','2005/03/18','PASSATA CONVENZIONALE','PC','COLD BREAK','BRIX 12','0','0','2004',0,0,0,0,0,9,1); INSERT INTO ordini VALUES (87,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'PASSATA DI POMODORO','PP','2005/03/18','PASSATA LOTTA INTEGRATA','PLI','COLD BREAK','BRIX 12','0','0','2004',0,0,0,0,0,27,1); INSERT INTO ordini VALUES (88,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'SUCCO DI POMODORO','SP','2005/03/18','SUCCO BIO','SB','COLD BREAK','BRIX 5','0','0','2004',0,0,0,0,0,22,1); INSERT INTO ordini VALUES (89,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'SUCCO DI POMODORO','SP','2005/03/18','SUCCO CONVENZIONALE','SC','COLD BREAK','BRIX 5','0','0','2004',0,0,0,0,0,21,1); INSERT INTO ordini VALUES (90,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'SUCCO DI POMODORO','SP','2005/03/18','SUCCO LOTTA INTEGRATA','SLI','COLD BREAK','BRIX 5','0','0','2004',0,0,0,0,0,30,1); INSERT INTO ordini VALUES (97,'0000-00-00','00:00:00',NULL,NULL,'ORDINE','8200000002','2005/03/22','','',0,1,'FLUMEC S.R.L.',0,0,0,1,'VALVOLA A SFERA INOX 1/2\" UNIFLUX CON COMANDO PNEUMATICO','000','2005/03/22','VALVOLA A SFERA INOX 1/2\" UNIFLUX CON COMANDO PNEUMATICO','0','511140','Z100','0','0','0',180,1,180,0,0,53,1); INSERT INTO ordini VALUES (91,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO LOTTA INTEGRATA','CLI','COLD BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,29,1); INSERT INTO ordini VALUES (96,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2005','8200000001','2005/03/21','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','PERA','DOLCE','0','0','2005',0,0,0,0,0,52,1); INSERT INTO ordini VALUES (92,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'DOPPIO CONCENTRATO DI POMODORO','DCP','2005/03/17','CONCENTRATO LOTTA INTEGRATA','CLI','HOT BREAK','BRIX 28/30','1','1','2004',0,0,0,0,0,28,1); INSERT INTO ordini VALUES (93,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA BIO','PB','PESCA','GENERICA','0','0','2004',0,0,0,0,0,49,1); INSERT INTO ordini VALUES (94,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA CONVENZIONALE','PC','PESCA','GENERICA','0','0','2004',0,0,0,0,0,50,1); INSERT INTO ordini VALUES (95,'0000-00-00','00:00:00',NULL,NULL,'INVENTARIO 2004','8200000000','2005/03/18','','',0,1,'VALLI ESTENSI SRL',1,0,0,0,'CREMOGENATI FRESCHI DI FRUTTA','CFF','2005/03/18','PUREA LOTTA INTEGRATA','PLI','PESCA','GENERICA','0','0','2004',0,0,0,0,0,51,1);