Visa

CREATE TABLE e_visa_category_terms (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
code VARCHAR(50) NOT NULL UNIQUE,
name VARCHAR(100) NOT NULL,
is_publish TINYINT(1) NOT NULL DEFAULT 1 COMMENT '0=inactive, 1=active',
created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
);

INSERT INTO e_visa_category_terms (code, name)
VALUES
('category', 'Category'),
('post', 'Post'),
('page', 'Page'),
('tag', 'Tag');

ALTER TABLE e_visa_categories
ADD COLUMN term_id INT UNSIGNED NULL AFTER term;

ALTER TABLE e_visa_categories
ADD COLUMN content LONGTEXT NULL AFTER meta_description;

update đỡ thôi, chứ chưa đúng, vô admin cập nhật lại data sau cho 190booking
UPDATE e_visa_categories
SET term_id = CASE
WHEN term = 'category' THEN 1
WHEN term IN ('metadata', 'info-page') THEN 3
WHEN term = 'tag' THEN 4
WHEN term = 'menu' THEN ''
ELSE 2
END;