CREATE TABLE tx_vhc_type (id INT AUTO_INCREMENT NOT NULL, tp_name VARCHAR(100) DEFAULT NULL, tp_description LONGTEXT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE tx_vehicule ADD tx_vhc_tp_id INT DEFAULT NULL;
ALTER TABLE tx_vehicule ADD CONSTRAINT FK_2104FB22693B052D FOREIGN KEY (tx_vhc_tp_id) REFERENCES tx_vhc_type (id) ON DELETE CASCADE;
CREATE INDEX IDX_2104FB22693B052D ON tx_vehicule (tx_vhc_tp_id);
