CREATE TABLE IF NOT EXISTS sed_cars_models (
	mod_id INT NOT NULL AUTO_INCREMENT,
	mod_name VARCHAR(255) NOT NULL,
	PRIMARY KEY(mod_id),
	KEY(mod_name)
);

CREATE TABLE IF NOT EXISTS sed_cars_engines (
	eng_id INT NOT NULL AUTO_INCREMENT,
	eng_name VARCHAR(255) NOT NULL,
	PRIMARY KEY(eng_id),
	KEY(eng_name)
);

CREATE TABLE IF NOT EXISTS sed_cars_owned (
	car_id INT NOT NULL AUTO_INCREMENT,
	car_owner INT NOT NULL,
	car_model INT NOT NULL,
	car_built SMALLINT,
	car_bought SMALLINT,
	car_engine INT NOT NULL,
	car_fuel ENUM('diesel', 'gasoline') NOT NULL DEFAULT 'gasoline',
	car_cylinders TINYINT NOT NULL DEFAULT 4,
	car_volume SMALLINT,
	car_valves TINYINT,
	car_power SMALLINT,
	car_rpm SMALLINT,
	car_gearbox ENUM('man', 'auto') NOT NULL DEFAULT 'man',
	car_gears TINYINT,
	car_descr TEXT,
	car_added DATETIME NOT NULL,
	car_views INT NOT NULL DEFAULT 0,
	PRIMARY KEY(car_id),
	KEY (car_owner)
);

CREATE TABLE IF NOT EXISTS sed_cars_photos (
	ph_id INT NOT NULL AUTO_INCREMENT,
	ph_car INT NOT NULL,
	ph_ext ENUM('jpg', 'png', 'gif'),
	ph_width SMALLINT NOT NULL DEFAULT 0,
	ph_height SMALLINT NOT NULL DEFAULT 0,
	ph_size SMALLINT NOT NULL DEFAULT 0,
	ph_name VARCHAR(200),
	ph_com TEXT,
	PRIMARY KEY(ph_id),
	KEY(ph_car)
);

Delete Sql

DROP TABLE IF EXISTS sed_cars_models;
DROP TABLE IF EXISTS sed_cars_engines;
DROP TABLE IF EXISTS sed_cars_owned;
DROP TABLE IF EXISTS sed_cars_photos;