190Travel

database

1. tour_product_category
   column: position (có sẵn)
   ex: ["favorite", "location", "subfooter"]

2. tour_posts
   column: position (tạo mới tương tự tour_product_category)
   ex: ["subfooter"]

code
API: lấy ra danh sách như hình
Admin: thêm colum cho trang quản trị

CREATE TABLE general_sub_footer (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
domain_id BIGINT UNSIGNED NOT NULL,
sort INT NOT NULL DEFAULT 0,
is_publish TINYINT(1) NOT NULL DEFAULT 1 COMMENT '1 = publish, 0 = hidden',
created_by BIGINT DEFAULT NULL,
updated_by BIGINT DEFAULT NULL,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (id),
UNIQUE KEY uniq_title_domain (title, domain_id)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;

INSERT INTO general_sub_footer
(title, domain_id, sort, is_publish, created_at)
VALUES
('Du lịch trong nước', 2, 1, 1, NOW()),
('Du lịch Châu Á', 2, 2, 1, NOW()),
('Du lịch Châu Âu - Úc - Mỹ', 2, 3, 1, NOW()),
('Cẩm nang du lịch', 2, 4, 1, NOW());

ALTER TABLE tour_product_category
ADD COLUMN sub_footer_id INT UNSIGNED DEFAULT NULL;

ALTER TABLE tour_posts
ADD COLUMN sub_footer_id INT UNSIGNED DEFAULT NULL
AFTER meta_description