error: #1005 – Can’t create table ‘table_name.#sql-344_126′ (errno: 150).

[karo.toapanta]

CREATE TABLE camioneta (
codigo_vehiculo varchar(20) NOT NULL,
cabina varchar(50) DEFAULT NULL,
capacidad int(11) DEFAULT NULL,
num_puertas int(11) DEFAULT NULL,
PRIMARY KEY (codigo_vehiculo),
CONSTRAINT fk__camioneta__codig__300424b4 FOREIGN KEY (codigo_vehiculo) REFERENCES vehiculos (codigo_vehiculo) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

[LastMitch]

@karo.toapanta

error: #1005 – Can’t create table ‘table_name.#sql-344_126′ (errno: 150).

Read this:

http://www.insanefactory.com/forums/topic/another-solution-to-the-sql-foreign-key-problem/