Ver originalCREATE TABLE `empresa` ( `id_empresa` int(11) NOT NULL AUTO_INCREMENT, `nom_comer_gr` varchar(255) DEFAULT NULL, `nombre_comercial` varchar(255) NOT NULL, `razon_social` varchar(255) NOT NULL, `giro_empresa` varchar(255) NOT NULL, `rfc` varchar(30) NOT NULL, `calle` varchar(255) NOT NULL, `no_ext` int(11) NOT NULL, `no_int` int(11) NOT NULL, `codigo_postal_emp` int(11) NOT NULL, `estado_emp` varchar(255) NOT NULL, `municipio_emp` varchar(255) NOT NULL, `colonia_emp` varchar(255) NOT NULL, `lada_emp` int(11) NOT NULL, `tel_emp` int(11) NOT NULL, `exten_emp` int(11) NOT NULL, `clasif_emp` varchar(3) NOT NULL, PRIMARY KEY (`nombre_comercial`), UNIQUE KEY `id_empresa` (`id_empresa`), KEY `id_grupo` (`nom_comer_gr`), CONSTRAINT `empresa_ibfk_1` FOREIGN KEY (`nom_comer_gr`) REFERENCES `grupo` (`nom_comer_gr`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Ver originalCREATE TABLE `grupo` ( `id_grupo` int(11) NOT NULL AUTO_INCREMENT, `nom_comer_gr` varchar(255) NOT NULL DEFAULT '', `raz_soc_gr` varchar(255) NOT NULL, `rfc_gr` varchar(20) NOT NULL, `giro_gr` varchar(30) NOT NULL, `calle_gr` varchar(30) NOT NULL, `no_ext_gr` int(11) NOT NULL, `no_int_gr` int(11) NOT NULL, `cod_post_gr` int(11) NOT NULL, `estado_gr` varchar(30) NOT NULL, `municipio_gr` varchar(30) NOT NULL, `colonia_gr` varchar(30) NOT NULL, `lada_gr` int(11) NOT NULL, `telefono_gr` int(11) NOT NULL, `exten_gr` int(11) NOT NULL, `clasif_gr` varchar(20) NOT NULL, PRIMARY KEY (`id_grupo`), UNIQUE KEY `nom_comer_gr` (`nom_comer_gr`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1