SELECT motherboards.id,
chipsets.chipset_name,
brends.brend_name,
series.series_name,
connectors.connector_name,
motherboards.motherboard_name FROM asus.parametrs
JOIN asus.chipsets ON parametrs.chipset_id = chipsets.id
JOIN asus.brends ON parametrs.brend_id = brends.id
JOIN asus.series ON parametrs.series_id = series.id
JOIN asus.connectors ON parametrs.connector_id = connectors.id
JOIN asus.motherboards ON parametrs.motherboard_id = motherboards.id AND
(
chipsets.id = 2 AND
brends.id = 1 AND
series.id = 1 AND
connectors.id = 1 AND
motherboards.id = 4
)
ORDER BY parametrs.motherboard_id;
DROP DATABASE `asus`;
CREATE DATABASE `asus`;
USE `asus`;
CREATE TABLE asus.chipsets
(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`chipset_name` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);
CREATE TABLE asus.brends
(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`brend_name` VARCHAR(30) NOT NULL,
PRIMARY KEY(`id`)
);
CREATE TABLE asus.series
(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`series_name` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);
CREATE TABLE asus.connectors
(
`id` INT UNSIGNED AUTO_INCREMENT NOT NULL,
`connector_name` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);
CREATE TABLE asus.motherboards
(
id INT UNSIGNED AUTO_INCREMENT NOT NULL,
`motherboard_name` VARCHAR(255) NOT NULL,
`motherboard_image` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);
CREATE TABLE asus.parametrs
(
#id INT UNSIGNED AUTO_INCREMENT NOT NULL,
`chipset_id` INT UNSIGNED NOT NULL,
`brend_id` INT UNSIGNED NOT NULL,
`series_id` INT UNSIGNED NOT NULL,
`connector_id` INT UNSIGNED NOT NULL,
`motherboard_id` INT UNSIGNED NOT NULL,
FOREIGN KEY(`chipset_id`) REFERENCES chipsets(`id`),
FOREIGN KEY(`brend_id`) REFERENCES brends(`id`),
FOREIGN KEY(`series_id`) REFERENCES series(`id`),
FOREIGN KEY(`connector_id`) REFERENCES connectors(`id`),
FOREIGN KEY(`motherboard_id`) REFERENCES motherboards(`id`),
PRIMARY KEY(`chipset_id`, `brend_id`, `series_id`, `connector_id`, `motherboard_id`)
);
INSERT INTO asus.chipsets(`chipset_name`) VALUES
('Intel B560'),
('Intel Z590');
INSERT INTO asus.brends(`brend_name`) VALUES
('Intel'),
('AMD');
INSERT INTO asus.series(`series_name`) VALUES
('PRIME'),
('ProArt'),
('ROG - Republic of Gamers'),
('TUF Gaming');
INSERT INTO asus.connectors(`connector_name`) VALUES
('LGA 1200'),
('AM4');
INSERT INTO asus.motherboards
(
`motherboard_name`,
`motherboard_image`
)
VALUES
('PRIME Z590M-PLUS', 'https://dlcdnwebimgs.asus.com/gain/109a7d9b-f938-48b5-a8fa-ec1b73210558/w185'),
('PRIME Z590M-PLUS', 'https://dlcdnwebimgs.asus.com/gain/17aff855-1b28-4a7d-8ca1-9aaf8418b723/w185'),
('PRIME Z590-A', 'https://dlcdnwebimgs.asus.com/gain/276acda5-c2eb-4d3e-8b35-844eed31d025/w185'),
('PRIME B560-PLUS', 'https://dlcdnwebimgs.asus.com/gain/f8c4b5c6-002c-4b97-8cf5-13a2fb63ea41/w185');
INSERT INTO asus.parametrs
(
`chipset_id`,
`brend_id`,
`series_id`,
`connector_id`,
`motherboard_id`
)
VALUES
(2, 1, 1, 1, 1),
(2, 1, 1, 1, 2),
(2, 1, 1, 1, 3),
(1, 1, 1, 1, 4);
SELECT * FROM asus.parametrs;
//package.json
{
"private": true,
"scripts": {
"dev": "npm run development",
"development": "mix",
"watch": "mix watch",
"watch-poll": "mix watch -- --watch-options-poll=1000",
"hot": "mix watch --hot",
"prod": "npm run production",
"production": "mix --production"
},
"devDependencies": {
"@vue/compiler-sfc": "^3.0.7",
"axios": "^0.21",
"bootstrap": "^4.6.0",
"jquery": "^3.6.0",
"laravel-mix": "^6.0.12",
"lodash": "^4.17.21",
"popper.js": "^1.16.1",
"postcss": "^8.2.8",
"resolve-url-loader": "^3.1.2",
"sass": "^1.32.8",
"sass-loader": "^10.1.1",
"vue": "^3.0.7",
"vue-loader": "^16.1.0"
}
}
D:\install\openserver\domains\apps.local>npm install
added 78 packages, removed 26 packages, changed 1 package, and audited 1331 packages in 11s
98 packages are looking for funding
run `npm fund` for details
found 0 vulnerabilities
D:\install\openserver\domains\apps.local>npm run dev
> dev
> npm run development
> development
> mix
9% setup compilation vue-loader-plugin[webpack-cli] TypeError: The 'compilation' argument must be an instance of Compilation
at Function.getCompilationHooks (D:\install\openserver\domains\apps.local\node_modules\webpack\lib\NormalModule.js:179:10)
at D:\install\openserver\domains\apps.local\node_modules\vue-loader\dist\pluginWebpack5.js:37:26
at Hook.eval [as call] (eval at create (D:\install\OpenServer\domains\apps.local\node_modules\tapable\lib\HookCodeFactory.js:19:10), <anonymous>:206:1)
at Hook.CALL_DELEGATE [as _call] (D:\install\OpenServer\domains\apps.local\node_modules\tapable\lib\Hook.js:14:14)
at Compiler.newCompilation (D:\install\OpenServer\domains\apps.local\node_modules\webpack\lib\Compiler.js:993:26)
at D:\install\OpenServer\domains\apps.local\node_modules\webpack\lib\Compiler.js:1035:29
at Hook.eval [as callAsync] (eval at create (D:\install\OpenServer\domains\apps.local\node_modules\tapable\lib\HookCodeFactory.js:33:10), <anonymous>:22:1)
at Hook.CALL_ASYNC_DELEGATE [as _callAsync] (D:\install\OpenServer\domains\apps.local\node_modules\tapable\lib\Hook.js:18:14)
at Compiler.compile (D:\install\OpenServer\domains\apps.local\node_modules\webpack\lib\Compiler.js:1030:28)
at D:\install\OpenServer\domains\apps.local\node_modules\webpack\lib\Compiler.js:473:12