2025-07-01 07:06:04 +02:00
|
|
|
CREATE TABLE IF NOT EXISTS `vehicle_trackers` (
|
|
|
|
`serialNumber` varchar(11) NOT NULL,
|
|
|
|
`vehiclePlate` varchar(11) NOT NULL,
|
2025-07-01 08:02:31 +02:00
|
|
|
`owner` varchar(50) NULL,
|
2025-07-01 08:20:46 +02:00
|
|
|
`name` varchar(50) NULL,
|
2025-07-01 07:06:04 +02:00
|
|
|
`startedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
UNIQUE KEY `serialNumber` (`serialNumber`),
|
|
|
|
KEY `vehiclePlate` (`vehiclePlate`)
|
2025-07-01 08:02:31 +02:00
|
|
|
);
|