21 lines
622 B
MySQL
21 lines
622 B
MySQL
|
ALTER TABLE vn.project ADD stateFk varchar(25) DEFAULT 'open';
|
||
|
|
|
||
|
|
CREATE TABLE vn.projectState (
|
||
|
|
code varchar(25) NOT NULL,
|
||
|
|
description varchar(100) NOT NULL,
|
||
|
|
CONSTRAINT projectState_PK PRIMARY KEY (code)
|
||
|
|
)
|
||
|
|
ENGINE=InnoDB
|
||
|
|
DEFAULT CHARSET=utf8mb3
|
||
|
|
COLLATE=utf8mb3_unicode_ci;
|
||
|
|
|
||
|
|
INSERT INTO vn.projectState (code,description)
|
||
|
|
VALUES ('open','Abierto');
|
||
|
|
INSERT INTO vn.projectState (code,description)
|
||
|
|
VALUES ('inProgress','En progreso');
|
||
|
|
INSERT INTO vn.projectState (code,description)
|
||
|
|
VALUES ('closed','Cerrado');
|
||
|
|
|
||
|
|
ALTER TABLE vn.project ADD CONSTRAINT project_FK_3 FOREIGN KEY (stateFk) REFERENCES vn.projectState(code);
|
||
|
|
|