Praticamente questo pero mi da errore gia sulla prima combinazione 0 e 1
CREATE TABLE IF NOT EXISTS `buildings` (
`type` int(10) unsigned NOT NULL default '0',
`faction` int(10) unsigned NOT NULL default '0',
`name` varbinary(45) NOT NULL,
`requirements` varbinary(128) NOT NULL,
`input` varbinary(128) NOT NULL,
`output` varbinary(128) NOT NULL,
`duration` varbinary(128) NOT NULL,
`upkeep` varbinary(128) NOT NULL,
`description` varbinary(512) NOT NULL,
PRIMARY KEY (`type`,`faction`),
UNIQUE KEY `Index_1` (`type`,`faction`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`)VALUES(0,1,'Settore Grano-Campo di Grano', '', '15-25-20-20-10', '60-100-160-220-300-350-400-760-880-1000-1200-1350-1500-1700-1900', '0:02-0:06-0:10-0:16-0:25-0:38-0:44-0:55-1:20-2:30-3:40-4:50-8:20-14:30-22:40', '1-1-2-2-4-6-6-8-8-10-12-14-18-20-26', 'Grazie ai Campi di Grano, potrai produrre del grano. L''ampliamento a piu livelli aumenta il grano orario');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(0, 2, 'Settore Grano-Campo di Grano', '', '15-25-20-20-10', '60-100-160-220-300-350-400-760-880-1000-1200-1350-1500-1700-1900', '0:02-0:06-0:10-0:16-0:25-0:38-0:44-0:55-1:20-2:30-3:40-4:50-8:20-14:30-22:40', '1-1-2-2-4-6-6-8-8-10-12-14-18-20-26', 'Grazie ai Campi di Grano, potrai produrre del grano. L''ampliamento a piu livelli aumenta il grano orario');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(0, 3, 'Settore Grano-Campo di Grano', '', '15-25-20-20-10', '60-100-160-220-300-350-400-760-880-1000-1200-1350-1500-1700-1900', '0:02-0:06-0:10-0:16-0:25-0:38-0:44-0:55-1:20-2:30-3:40-4:50-8:20-14:30-22:40', '1-1-2-2-4-6-6-8-8-10-12-14-18-20-26', 'Grazie ai Campi di Grano, potrai produrre del grano. L''ampliamento a piu livelli aumenta il grano orario');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(0, 4, 'Settore Grano-Campo di Grano', '', '15-25-20-20-10', '60-100-160-220-300-350-400-760-880-1000-1200-1350-1500-1700-1900', '0:02-0:06-0:10-0:16-0:25-0:38-0:44-0:55-1:20-2:30-3:40-4:50-8:20-14:30-22:40', '1-1-2-2-4-6-6-8-8-10-12-14-18-20-26', 'Grazie ai Campi di Grano, potrai produrre del grano. L''ampliamento a piu livelli aumenta il grano orario');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(0, 5, 'Settore Grano-Campo di Grano', '', '15-25-20-20-10', '60-100-160-220-300-350-400-760-880-1000-1200-1350-1500-1700-1900', '0:02-0:06-0:10-0:16-0:25-0:38-0:44-0:55-1:20-2:30-3:40-4:50-8:20-14:30-22:40', '1-1-2-2-4-6-6-8-8-10-12-14-18-20-26', 'Grazie ai Campi di Grano, potrai produrre del grano. L''ampliamento a piu livelli aumenta il grano orario');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(1, 1, 'Settore Foreste-Foresta', '', '25-10-30-20-10', '66-140-260-370-500-850-1000-1360-1580-1960', '0:02-0:08-0:16-0:48-1:15-2:18-3:24-5:45-9:00-14:50', '1-1-2-2-4-6-6-8-8-8', 'Attivando la lavorazione nelle foreste dei falegnami, avrai legna. Ampliando i livelli salirà la produzione di ogni ora');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(1, 2, 'Settore Foreste-Foresta', '', '25-10-30-20-10', '66-140-260-370-500-850-1000-1360-1580-1960', '0:02-0:08-0:16-0:48-1:15-2:18-3:24-5:45-9:00-14:50', '1-1-2-2-4-6-6-8-8-8', 'Attivando la lavorazione nelle foreste dei falegnami, avrai legna. Ampliando i livelli salirà la produzione di ogni ora');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(1, 3, 'Settore Foreste-Foresta', '', '25-10-30-20-10', '66-140-260-370-500-850-1000-1360-1580-1960', '0:02-0:08-0:16-0:48-1:15-2:18-3:24-5:45-9:00-14:50', '1-1-2-2-4-6-6-8-8-8', 'Attivando la lavorazione nelle foreste dei falegnami, avrai legna. Ampliando i livelli salirà la produzione di ogni ora');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(1, 4, 'Settore Foreste-Foresta', '', '25-10-30-20-10', '66-140-260-370-500-850-1000-1360-1580-1960', '0:02-0:08-0:16-0:48-1:15-2:18-3:24-5:45-9:00-14:50', '1-1-2-2-4-6-6-8-8-8', 'Attivando la lavorazione nelle foreste dei falegnami, avrai legna. Ampliando i livelli salirà la produzione di ogni ora');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(1, 5, 'Settore Foreste-Foresta', '', '25-10-30-20-10', '66-140-260-370-500-850-1000-1360-1580-1960', '0:02-0:08-0:16-0:48-1:15-2:18-3:24-5:45-9:00-14:50', '1-1-2-2-4-6-6-8-8-8', 'Attivando la lavorazione nelle foreste dei falegnami, avrai legna. Ampliando i livelli salirà la produzione di ogni ora');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(2, 1, 'Settore Argilla-Pozzo Argilla', '', '30-25-10-25-15', '66-140-260-370-500-850-1000-1260-1280-1800', '0:02-0:08-0:16-0:32-0:55-1:18-2:24-4:45-8:00-12:00', '1-1-2-2-4-6-6-8-9-10', 'La realizzazione e ampliamento dei pozzi di Argilla permette il suo incremento.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(2, 2, 'Settore Argilla-Pozzo Argilla', '', '30-25-10-25-15', '66-140-260-370-500-850-1000-1260-1280-1800', '0:02-0:08-0:16-0:32-0:55-1:18-2:24-4:45-8:00-12:00', '1-1-2-2-4-6-6-8-9-10', 'La realizzazione e ampliamento dei pozzi di Argilla permette il suo incremento.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(2, 3, 'Settore Argilla-Pozzo Argilla', '', '30-25-10-25-15', '66-140-260-370-500-850-1000-1260-1280-1800', '0:02-0:08-0:16-0:32-0:55-1:18-2:24-4:45-8:00-12:00', '1-1-2-2-4-6-6-8-9-10', 'La realizzazione e ampliamento dei pozzi di Argilla permette il suo incremento.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(2, 4, 'Settore Argilla-Pozzo Argilla', '', '30-25-10-25-15', '66-140-260-370-500-850-1000-1260-1280-1800', '0:02-0:08-0:16-0:32-0:55-1:18-2:24-4:45-8:00-12:00', '1-1-2-2-4-6-6-8-9-10', 'La realizzazione e ampliamento dei pozzi di Argilla permette il suo incremento.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(2, 5, 'Settore Argilla-Pozzo Argilla', '', '30-25-10-25-15', '66-140-260-370-500-850-1000-1260-1280-1800', '0:02-0:08-0:16-0:32-0:55-1:18-2:24-4:45-8:00-12:00', '1-1-2-2-4-6-6-8-9-10', 'La realizzazione e ampliamento dei pozzi di Argilla permette il suo incremento.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(3, 1, 'Settore Ferro-Miniera Ferro', '', '30-40-45-15-20', '66-140-260-370-500-850-1000-1360-1780-2700', '0:02-0:04-0:06-0:8-0:15-0:18-0:24-0:45-1:00-2:00', '1-1-2-2-4-6-6-8-8-8', 'At the iron foundry ore sites are created and upgraded. Ore sites produce iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(3, 2, 'Settore Ferro-Miniera Ferro', '', '30-40-45-15-20', '66-140-260-370-500-850-1000-1360-1780-2700', '0:02-0:04-0:06-0:8-0:15-0:18-0:24-0:45-1:00-2:00', '1-1-2-2-4-6-6-8-8-8', 'At the foundry metal deposites are found and exploited. Metal deposites produce iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(3, 3, 'Settore Ferro-Miniera Ferro', '', '30-40-45-15-20', '66-140-260-370-500-850-1000-1360-1780-2700', '0:02-0:04-0:06-0:8-0:15-0:18-0:24-0:45-1:00-2:00', '1-1-2-2-4-6-6-8-8-8', 'At the mines shafts are created and upgraded. Shafts produce iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(3, 4, 'Settore Ferro-Miniera Ferro', '', '30-40-45-15-20', '66-140-260-370-500-850-1000-1360-1780-2700', '0:02-0:04-0:06-0:8-0:15-0:18-0:24-0:45-1:00-2:00', '1-1-2-2-4-6-6-8-8-8', 'At the mines shafts are created and upgraded. Shafts produce iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(3, 5, 'Settore Ferro-Miniera Ferro', '', '30-40-45-15-20', '66-140-260-370-500-850-1000-1360-1780-2700', '0:02-0:04-0:06-0:8-0:15-0:18-0:24-0:45-1:00-2:00', '1-1-2-2-4-6-6-8-8-8', 'At the iron foundry ore sites are created and upgraded. Ore sites produce iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(4, 1, 'Granaio', '0-1', '65-85-95-95-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:05-0:10-0:20-0:35-0:50-1:05-1:45-2:00-2:35-3:0', '1-1-2-2-3-3-4-4-5-5', 'E'' un deposito del grano.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(4, 2, 'Granaio', '0-1', '65-85-95-95-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:05-0:10-0:20-0:35-0:50-1:05-1:45-2:00-2:35-3:0', '1-1-2-2-3-3-4-4-5-5', 'E'' un deposito del grano.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(4, 3, 'Granaio', '0-1', '65-85-95-95-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:05-0:10-0:20-0:35-0:50-1:05-1:45-2:00-2:35-3:0', '1-1-2-2-3-3-4-4-5-5', 'E'' un deposito del grano.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(4, 4, 'Granaio', '0-1', '65-85-95-95-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:05-0:10-0:20-0:35-0:50-1:05-1:45-2:00-2:35-3:0', '1-1-2-2-3-3-4-4-5-5', 'E'' un deposito del grano.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(4, 5, 'Granaio', '0-1', '65-85-95-95-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:05-0:10-0:20-0:35-0:50-1:05-1:45-2:00-2:35-3:0', '1-1-2-2-3-3-4-4-5-5', 'E'' un deposito del grano.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(5, 1, 'Magazzini', '1-1/2-1/3-1', '95-65-75-85-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:10-0:20-0:40-0:55-0:56-1:05-1:05-1:05-1:05-1:10', '1-1-2-2-3-3-4-4-5-5', 'The warehouse stores lumber, stone and iron.');
INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES(5, 2, 'Magazzini', '1-1/2-1/3-1', '95-65-75-85-20', '900-1600-2800-3500-5600-8400-10100-19000-40000-95500', '0:10-0:20-0:40-0:55-0:56-1:05-1:05-1:05-1:05-1:10', '1-1-2-2-3-3-4-4-5-5', 'The general stocks store lumber, stone and iron.');
continua.......
