· 7 years ago · Nov 24, 2018, 10:36 PM
1-- Cars/settings/my.sql
2
3DROP TABLE IF EXISTS engine4_car_cars;
4CREATE TABLE engine4_car_cars (
5 car_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
6 title VARCHAR(128) NOT NULL,
7 description MEDIUMTEXT NOT NULL,
8 owner_id INT(11) UNSIGNED NOT NULL,
9 owner_type INT(11) UNSIGNED NOT NULL,
10 photo_id INT(11) UNSIGNED NOT NULL,
11 creation_date DATETIME NOT NULL,
12 modified_date DATETIME NOT NULL,
13 view_count INT(11) UNSIGNED NOT NULL,
14 comment_count INT(11) UNSIGNED NOT NULL,
15 search TINYINT(1) NOT NULL,
16 PRIMARY KEY (car_id),
17 INDEX (photo_id),
18 INDEX (owner_id)
19);