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 */;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.