-- Juan A. Villalpando
-- kio4.com

CREATE TABLE `comercio` (
  `id` int(6) NOT NULL,
  `nombre` varchar(14) COLLATE utf8_spanish2_ci NOT NULL,
  `producto` varchar(12) COLLATE utf8_spanish2_ci NOT NULL,
  `precio` varchar(6) COLLATE utf8_spanish2_ci NOT NULL,
  `fecha` varchar(10) COLLATE utf8_spanish2_ci NOT NULL,
  `pagado` varchar(5) COLLATE utf8_spanish2_ci NOT NULL,
  `profesional` varchar(5) COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

ALTER TABLE `comercio`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `comercio`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;
COMMIT;	