application/modules/Car/settings/my.sql

my.sql

-- Cars/settings/my.sql 

DROP TABLE IF EXISTS engine4_car_cars;
CREATE TABLE engine4_car_cars (
    car_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    title VARCHAR(128) NOT NULL,
    description MEDIUMTEXT NOT NULL,
    owner_id INT(11) UNSIGNED NOT NULL,
    owner_type INT(11) UNSIGNED NOT NULL,
    photo_id INT(11) UNSIGNED NOT NULL,
    creation_date DATETIME NOT NULL,
    modified_date DATETIME NOT NULL,
    view_count INT(11) UNSIGNED NOT NULL,
    comment_count INT(11) UNSIGNED NOT NULL,
    search TINYINT(1) NOT NULL,
    PRIMARY KEY (car_id),
    INDEX (photo_id),
    INDEX (owner_id)
);