/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='NO_ENGINE_SUBSTITUTION' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; CREATE TABLE `comprapedlote` ( `cod` int(11) NOT NULL AUTO_INCREMENT, `ped` int(11) DEFAULT '0', `tipo` smallint(4) DEFAULT '0', `tecido` smallint(4) DEFAULT '0', `cor` smallint(4) DEFAULT '0', `tam` tinyint(2) DEFAULT '0', `descricao` char(255) DEFAULT NULL, `qtd` smallint(4) DEFAULT '0', `preco` decimal(10,2) DEFAULT '0.00', `itensvenda` tinyint(1) DEFAULT '0', `codprodsite` int(11) DEFAULT '0', `corsite` smallint(6) DEFAULT '0', `agrupamento` int(11) DEFAULT '0', PRIMARY KEY (`cod`), KEY `ped` (`ped`), KEY `agrupamento` (`agrupamento`) ) ENGINE=MyISAM AUTO_INCREMENT=11732 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED; INSERT INTO `comprapedlote` VALUES (11724,1779,200,6,5,2,'Montaria preto',55,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11725,1779,200,6,5,4,'Montaria preto',57,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11726,1779,200,6,5,3,'Montaria preto',56,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11727,1779,200,6,5,5,'Montaria preto',52,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11728,1779,200,6,9,2,'Montaria preto',43,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11729,1779,200,6,9,4,'Montaria preto',42,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11730,1779,200,6,9,3,'Montaria preto',42,13,1,0,0,1904); INSERT INTO `comprapedlote` VALUES (11731,1779,200,6,9,5,'Montaria preto',46,13,1,0,0,1904); /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;