7 lines
244 B
MySQL
7 lines
244 B
MySQL
|
CREATE TABLE `vn`.`vehiclePlateRegex` (
|
||
|
|
`countryCodeFk` VARCHAR(2) NOT NULL,
|
||
|
|
`regex` VARCHAR(45) NOT NULL,
|
||
|
|
PRIMARY KEY (`countryCodeFk`));
|
||
|
|
|
||
|
|
ALTER TABLE `vn`.`vehicle`
|
||
|
|
ADD COLUMN `countryCodeFk` VARCHAR(2) NULL DEFAULT 'ES' AFTER `ppeFk`;
|