11/03/2013, 14:04
|
 | | | Fecha de Ingreso: marzo-2013
Mensajes: 9
Antigüedad: 11 años, 1 mes Puntos: 0 | |
| Respuesta: Error 1054 dbforge
mysql> SHOW CREATE TABLE articuloscarrito;
+------------------+------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+
| Table | Create Table
|
+------------------+------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+
| articuloscarrito | CREATE TABLE `articuloscarrito` (
`codigocarrito` int(11) NOT NULL,
`codigoarticulo` int(11) NOT NULL,
`cantidad` int(11) DEFAULT NULL,
`precioventa` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`codigocarrito`,`codigoarticulo`),
KEY `FK_articuloscarrito_articulos_codigo` (`codigoarticulo`),
CONSTRAINT `FK_articuloscarrito_articulos_codigo` FOREIGN KEY (`codigoarticulo
`) REFERENCES `articulos` (`codigo`),
CONSTRAINT `FK_articuloscarrito_carrito_codigo` FOREIGN KEY (`codigocarrito`)
REFERENCES `carrito` (`codigo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AVG_ROW_LENGTH=3276 |
+------------------+------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+
1 row in set (0.00 sec)
eso es lo que sale =) |