-
CREATE TABLE IF NOT EXISTS vehicle_years (
id INT AUTO_INCREMENT PRIMARY KEY,
year INT NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY uniq_year (year)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS vehicle_makes (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(80) NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY uniq_make (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS vehicle_models (
id INT AUTO_INCREMENT PRIMARY KEY,
make_id INT NOT NULL,
name VARCHAR(120) NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY uniq_make_model (make_id, name),
KEY idx_make (make_id),
CONSTRAINT fk_models_make FOREIGN KEY (make_id)
REFERENCES vehicle_makes(id)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS engine_sizes (
id INT AUTO_INCREMENT PRIMARY KEY,
size VARCHAR(50) NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY uniq_size (size)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS vehicle_years ( id INT AUTO_INCREMENT PRIMARY KEY, year INT NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY uniq_year (year) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS vehicle_makes ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(80) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY uniq_make (name) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS vehicle_models ( id INT AUTO_INCREMENT PRIMARY KEY, make_id INT NOT NULL, name VARCHAR(120) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY uniq_make_model (make_id, name), KEY idx_make (make_id), CONSTRAINT fk_models_make FOREIGN KEY (make_id) REFERENCES vehicle_makes(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS engine_sizes ( id INT AUTO_INCREMENT PRIMARY KEY, size VARCHAR(50) NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE KEY uniq_size (size) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;0 Comments 0 Shares 8 Views 0 Reviews -
CREATE TABLE IF NOT EXISTS vehicle_makes (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(80) NOT NULL UNIQUE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS vehicle_models (
id INT AUTO_INCREMENT PRIMARY KEY,
make_id INT NOT NULL,
name VARCHAR(120) NOT NULL,
UNIQUE KEY uniq_make_model (make_id, name),
CONSTRAINT fk_models_make
FOREIGN KEY (make_id) REFERENCES vehicle_makes(id)
ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- Seed common makes
INSERT IGNORE INTO vehicle_makes (name) VALUES
('Ford'),('Jeep'),('Honda'),('Toyota'),('Chevrolet'),('Nissan'),('Hyundai'),('Kia'),
('Dodge'),('RAM'),('GMC'),('BMW'),('Mercedes-Benz'),('Audi'),('Subaru'),('Volkswagen');
-- Seed a few models (add more anytime)
INSERT IGNORE INTO vehicle_models (make_id, name)
SELECT m.id, x.model
FROM vehicle_makes m
JOIN (
SELECT 'Ford' make, 'F-150' model UNION ALL
SELECT 'Ford', 'Mustang' UNION ALL
SELECT 'Ford', 'Explorer' UNION ALL
SELECT 'Jeep', 'Wrangler' UNION ALL
SELECT 'Jeep', 'Grand Cherokee' UNION ALL
SELECT 'Honda', 'Civic' UNION ALL
SELECT 'Honda', 'Accord' UNION ALL
SELECT 'Honda', 'CR-V' UNION ALL
SELECT 'Toyota', 'Camry' UNION ALL
SELECT 'Toyota', 'Corolla' UNION ALL
SELECT 'Chevrolet', 'Silverado' UNION ALL
SELECT 'Nissan', 'Altima'
) x ON x.make = m.name;
CREATE TABLE IF NOT EXISTS vehicle_makes ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(80) NOT NULL UNIQUE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS vehicle_models ( id INT AUTO_INCREMENT PRIMARY KEY, make_id INT NOT NULL, name VARCHAR(120) NOT NULL, UNIQUE KEY uniq_make_model (make_id, name), CONSTRAINT fk_models_make FOREIGN KEY (make_id) REFERENCES vehicle_makes(id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Seed common makes INSERT IGNORE INTO vehicle_makes (name) VALUES ('Ford'),('Jeep'),('Honda'),('Toyota'),('Chevrolet'),('Nissan'),('Hyundai'),('Kia'), ('Dodge'),('RAM'),('GMC'),('BMW'),('Mercedes-Benz'),('Audi'),('Subaru'),('Volkswagen'); -- Seed a few models (add more anytime) INSERT IGNORE INTO vehicle_models (make_id, name) SELECT m.id, x.model FROM vehicle_makes m JOIN ( SELECT 'Ford' make, 'F-150' model UNION ALL SELECT 'Ford', 'Mustang' UNION ALL SELECT 'Ford', 'Explorer' UNION ALL SELECT 'Jeep', 'Wrangler' UNION ALL SELECT 'Jeep', 'Grand Cherokee' UNION ALL SELECT 'Honda', 'Civic' UNION ALL SELECT 'Honda', 'Accord' UNION ALL SELECT 'Honda', 'CR-V' UNION ALL SELECT 'Toyota', 'Camry' UNION ALL SELECT 'Toyota', 'Corolla' UNION ALL SELECT 'Chevrolet', 'Silverado' UNION ALL SELECT 'Nissan', 'Altima' ) x ON x.make = m.name;0 Comments 0 Shares 10 Views 0 Reviews -
https://www.ebay.com/itm/156660469182?_skw=WALKER+TAPE+No-Shine+-+1%22+X+36+Yds%2C+Roll+Support+Tape+Wig%2C+Double-Sided%21&itmmeta=01KG4E82PJQ8RTFD9F0Y6ADK30&hash=item2479b10dbe:g:vmQAAeSwqf1pWgjJ&itmprp=enc%3AAQALAAABEO7PUuNWmJ%2B%2BUShgI9tQz%2Fo%2B20lWjb1u3%2FEoVHBC5kxbR2wkeKHaF7dtj1mUWDRoMkZBALCIw5OJjQlcSaNNVLJyxBcQWkDRmeEHXhkwwBRJ0aSRg1V12oC9Wf%2FjOOD67vCl7GUQT4Yd45DweLrcChdFVUk0wbBFxA5xQjdSVYXkIYQy7ZH0bcPpX7sE0BGawva5Ly7AuOec9IH0TxscwKIOVi3ja9SMWXvtJTTB7awmE%2BREQkOG4ZiI9NdzHo1xqfk6ElTH2%2B2ULWEPrcwuiE93bdYk%2B0ZczaRuNp4V6VL2YcBCdMMD5Z4tWydOFhNRsEvUJHFAqXcN8dDf1foc6m%2Bg3I6MKD6JNCOZvzEd%2BM5D%7Ctkp%3ABk9SR7CroI6BZw0 Comments 0 Shares 230 Views 0 Reviews
-
https://www.ebay.com/itm/406315123359?_trkparms=itmf%3D1%26aid%3D1110006%26rkt%3D4%26mech%3D1%26algv%3DSimVIDwebV4WithCtxRankerV1UnifiedFeatures%26pmt%3D1%26amclksrc%3DITM%26sd%3D358076985048%26sid%3DAQALAAAAENFw%2BX6SAZsQOpTIF7ePTP0%3D%26itm%3D406315123359%26noa%3D0%26plcampt%3D0%3A13240273019%26algo%3DHOMESPLICE.SIM%26brand%3DUnbranded%26asc%3D20231107084023%26ao%3D1%26rk%3D4%26pid%3D101875%26b%3D1%26mehot%3Dnone%26lsid%3D0%26meid%3D0f7818a3d9d84581a735ec4fd219bcdd%26pg%3D2332490&_trksid=p2332490.c101875.m1851&itmprp=cksum%3A4063151233590f7818a3d9d84581a735ec4fd219bcdd%7Cenc%3AAQALAAABEKLoGo41gKHtqPfIa5lF%252FWjQjdzIQ73rtGosP%252BBGmcPis1364XGSU%252Fh7VHaFLoC%252Bljy6U4EeqSxR92I%252FWlok6LCRFHnl0DdEhfZvfMx7PwoY%252BFpx%252BtVATgcVa%252BBZZPB8J9uM9g9TlfVFGSMGwBSFvmwUpbHfu2VvOwoZD%252FlglkRezxYgsaPDXhDQG4HeQynL9Cuw2qnYbfSn%252BzegLDlYddkcMLrB%252BnHTHjLyPoDfB8QRpOcLQH4fHqGfZ%252B4if%252FkwsqqFbeJ0e2Vv9sU99mLaeaAG18F1QeVDEVVktKgW5cOX%252FbcZF65LbVpGl%252FB4edRqG2WTa9DBOUoEqES25SmodlCvU%252FHZ0ot%252BuPAxGyGJu%252FjQ%7Campid%3APL_CLK%7Cclp%3A23324900 Comments 0 Shares 229 Views 0 Reviews
-
https://www.youtube.com/shorts/erjd8DLVGWE
0 Comments 0 Shares 1K Views 0 Reviews -
https://www.youtube.com/shorts/43VAkQJ8kJE
0 Comments 0 Shares 1K Views 0 Reviews -
https://www.youtube.com/shorts/42fgwFRbaBg
0 Comments 0 Shares 1K Views 0 Reviews -
https://khyraa.blogspot.com/2011/04/blog-post_9877.html0 Comments 0 Shares 1K Views 0 Reviews
-
https://www.youtube.com/shorts/_MyCtDPdKBc
0 Comments 0 Shares 1K Views 0 Reviews -
https://www.youtube.com/watch?v=LHRBm_qfJr4
0 Comments 0 Shares 1K Views 0 Reviews
More Stories
Arabic
French
Spanish
Portuguese
Deutsch
Turkish
Dutch
Italiano
Russian
Romaian
Portuguese (Brazil)
Greek