’, 3, ‘2020-04-25 22:10:52’, ‘宠物预防针多久打一次’);
INSERT INTO notice
VALUES (3, ’
请填写文字内容
\n\n
如果你的小狗已经出现了一定情况的问题,那么请先从自己/现有环境的身上找原因——毕竟养狗行为课程,其实最重要的不是小狗,而是小狗的主人。
\n\n
我们对待小狗的方式,就是我们对待小孩,或者说是童年的自己的方式。是选择恐吓训斥,让他们永远失去好奇心,对周围充满恐惧?还是选择给小孩以积极尊重,探索周边,予以互动?培养小狗的自信心和成就感,也是重要的课程内容。
\n\n
', 5, ‘2020-04-26 11:35:09’, ‘养犬最重要的是什么?’);
INSERT INTO notice
VALUES (4, ‘
宠物…
’, 2, ‘2020-04-26 19:15:57’, ‘养犬’);
INSERT INTO notice
VALUES (5, ‘
怎么养宠物…
’, 1, ‘2020-04-26 19:46:22’, ‘养犬重要的是什么?’);
INSERT INTO notice
VALUES (6, ‘
怎么养宠物…
’, 12, ‘2020-04-26 19:46:28’, ‘养犬重要的是什么?’);
INSERT INTO notice
VALUES (8, ‘
宠物
’, 1, ‘2020-05-30 10:37:36’, ‘宠物’);
– Table structure for page
DROP TABLE IF EXISTS page
;
CREATE TABLE page
(
page_id
int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
parent_id
int(11) DEFAULT NULL COMMENT ‘父页面id’,
name
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘页面名称’,
url
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘页面地址’,
level_type
int(11) DEFAULT NULL COMMENT ‘页面层级’,
level_index
int(11) DEFAULT NULL COMMENT ‘页面索引’,
delete_flag
int(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 0 COMMENT ‘是否删除’,
desc
varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT ‘描述’,
PRIMARY KEY (page_id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
– Records of page
INSERT INTO page
VALUES (1, 0, ‘系统设置’, NULL, 0, 10, 0, ‘manager’);
INSERT INTO page
VALUES (2, 1, ‘用户管理’, ‘/admin/userPage’, 1, 22, 0, ‘manager’);
INSERT INTO page
VALUES (3, 1, ‘页面管理’, ‘/admin/page’, 1, 23, 0, ‘manager’);
INSERT INTO page
VALUES (4, 1, ‘角色管理’, ‘/admin/role’, 1, 24, 0, ‘manager’);
INSERT INTO page
VALUES (6, 0, ‘宠物管理’, ‘’, 0, 1, 0, ‘left_menu_shop’);
INSERT INTO page
VALUES (7, 6, ‘宠物列表’, ‘/user/pet/petList’, 1, 1, 0, ‘’);
INSERT INTO page
VALUES (8, 6, ‘宠物健康史’, ‘/user/diagnosis/diagnosisList’, 1, 2, 0, ‘’);
INSERT INTO page
VALUES (9, 0, ‘预约管理’, ‘’, 0, 2, 0, ‘left_menu_data’);
INSERT INTO page
VALUES (10, 9, ‘预约列表’, ‘/user/apply/applyList’, 1, 1, 0, ‘’);
INSERT INTO page
VALUES (12, 0, ‘日常健康’, ‘’, 0, 3, 0, ‘user’);
INSERT INTO page
VALUES (13, 12, ‘健康指南’, ‘/user/notice/list’, 1, 1, 0, ‘’);
INSERT INTO page
VALUES (14, 12, ‘健康监测’, ‘/health/assess’, 1, 2, 0, ‘’);
INSERT INTO page
VALUES (19, 0, ‘宠物档案’, ‘’, 0, 4, 0, ‘left_menu_house’);
INSERT INTO page
VALUES (20, 19, ‘预约统计’, ‘/health/tjApply’, 1, 1, 0, ‘’);
INSERT INTO page
VALUES (21, 0, ‘医院管理’, ‘’, 0, 5, 0, ‘page’);
INSERT INTO page
VALUES (23, 21, ‘预约统计’, ‘/health/tjApplyDoctor’, 1, 2, 0, ‘’);
INSERT INTO page
VALUES (24, 21, ‘发布指南’, ‘/user/notice/publish’, 1, 3, 0, ‘’);
INSERT INTO page
VALUES (27, 19, ‘宠物日志’, ‘/user/petDaily/petDailyList’, 1, 2, 0, ‘’);
INSERT INTO page
VALUES (28, 19, ‘预约统计’, ‘/health/tjApply’, 1, 3, 0, NULL);
INSERT INTO page
VALUES (30, 6, ‘宠物健康史’, ‘/user/diagnos