mirror of
https://github.com/linuxserver/Clarkson.git
synced 2026-01-09 07:01:12 +08:00
49 lines
1019 B
SQL
49 lines
1019 B
SQL
DELIMITER $$
|
|
|
|
CREATE PROCEDURE `Vehicle_Insert`
|
|
(
|
|
in_vehicleId VARCHAR(36),
|
|
in_user VARCHAR(36),
|
|
in_name VARCHAR(100),
|
|
in_registration VARCHAR(20),
|
|
in_make VARCHAR(100),
|
|
in_model VARCHAR(100),
|
|
in_picture VARCHAR(100),
|
|
in_yearOfManufacture INT(11),
|
|
in_vin VARCHAR(100),
|
|
in_engineSizeCC INT(11),
|
|
in_fuelType INT(11)
|
|
)
|
|
BEGIN
|
|
|
|
INSERT INTO `Vehicles`
|
|
(
|
|
`id`,
|
|
`user`,
|
|
`name`,
|
|
`registration`,
|
|
`make`,
|
|
`model`,
|
|
`picture`,
|
|
`yearOfManufacture`,
|
|
`vin`,
|
|
`engineSizeCC`,
|
|
`fuelType`
|
|
)
|
|
VALUES
|
|
(
|
|
in_vehicleId,
|
|
in_user,
|
|
in_name,
|
|
in_registration,
|
|
in_make,
|
|
in_model,
|
|
in_picture,
|
|
in_yearOfManufacture,
|
|
in_vin,
|
|
in_engineSizeCC,
|
|
in_fuelType
|
|
);
|
|
|
|
END$$
|