LayUI树形菜单实现数据库脚本

CREATE TABLE IF NOT EXISTS menu (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50) NOT NULL,

parent_id INT,

FOREIGN KEY (parent_id) REFERENCES menu(id)

);

INSERT INTO menu (name, parent_id) VALUES

('节点1', NULL),

('节点2', NULL),

('子节点1-1', 1),

('子节点1-2', 1),

('子节点2-1', 2),

('子节点2-2', 2);