node.js游云旅游网站 （源码+数据库）231547

DROP TABLE IF EXISTS `registered_user`; CREATE TABLE `registered_user`( `registered_user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '注册用户ID', `user_name` varchar(64) NOT NULL UNIQUE comment '用户名', `examine_state` varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态', `recommend` int(11) DEFAULT '0' NOT NULL comment '智能推荐', `user_id` int(11) DEFAULT '0' NOT NULL comment '用户ID', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (registered_user_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '注册用户'; DROP TABLE IF EXISTS `introduction_to_scenic_spots`; CREATE TABLE `introduction_to_scenic_spots`( `introduction_to_scenic_spots_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '景点介绍ID', `attraction_number` varchar(64) comment '景点编号', `name_of_scenic_spot` varchar(64) comment '景点名称', `photo` varchar(255) comment '照片', `ticket_price` int(11) DEFAULT 0 comment '票价', `region` varchar(64) comment '地区', `address` varchar(64) comment '地址', `opening_hours` varchar(64) comment '开放时间', `introduction_to_scenic_spots` text comment '景点介绍', `hits` int(11) DEFAULT 0 NOT NULL comment '点击数', `praise_len` int(11) DEFAULT 0 NOT NULL comment '点赞数', `examine_state` varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态', `recommend` int(11) DEFAULT '0' NOT NULL comment '智能推荐', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (introduction_to_scenic_spots_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '景点介绍'; insert into `introduction_to_scenic_spots` values (1,'景点编号1','景点名称1','/upload/image_1615206273491.jpg',5,'地区1','地址1','开放时间1','景点介绍1','951','279','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (2,'景点编号2','景点名称2','/upload/image_1615206273491.jpg',10,'地区2','地址2','开放时间2','景点介绍2','30','495','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (3,'景点编号3','景点名称3','/upload/image_1615206273494.jpg',15,'地区3','地址3','开放时间3','景点介绍3','385','116','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (4,'景点编号4','景点名称4','/upload/image_1615206273528.jpg',20,'地区4','地址4','开放时间4','景点介绍4','567','243','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (5,'景点编号5','景点名称5','/upload/image_1615206273485.jpg',25,'地区5','地址5','开放时间5','景点介绍5','378','665','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (6,'景点编号6','景点名称6','/upload/image_1615198957318.jpg',30,'地区6','地址6','开放时间6','景点介绍6','47','59','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (7,'景点编号7','景点名称7','/upload/image_1615198965330.jpg',35,'地区7','地址7','开放时间7','景点介绍7','903','623','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `introduction_to_scenic_spots` values (8,'景点编号8','景点名称8','/upload/image_1615198958415.jpg',40,'地区8','地址8','开放时间8','景点介绍8','752','652','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); DROP TABLE IF EXISTS `regional_management`; CREATE TABLE `regional_management`( `regional_management_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地区管理ID', `region` varchar(64) comment '地区', `examine_state` varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态', `recommend` int(11) DEFAULT '0' NOT NULL comment '智能推荐', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (regional_management_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '地区管理'; insert into `regional_management` values (1,'地区1','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (2,'地区2','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (3,'地区3','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (4,'地区4','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (5,'地区5','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (6,'地区6','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (7,'地区7','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `regional_management` values (8,'地区8','已通过','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); DROP TABLE IF EXISTS `scenic_spot_ticket_purchase`; CREATE TABLE `scenic_spot_ticket_purchase`( `scenic_spot_ticket_purchase_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '景点购票ID', `order_number` varchar(64) comment '订单号', `attraction_number` varchar(64) comment '景点编号', `name_of_scenic_spot` varchar(64) comment '景点名称', `ticket_price` varchar(64) comment '票价', `purchase_quantity` int(11) DEFAULT 0 comment '购买数量', `total_price` varchar(64) comment '总价格', `user_name` int(11) DEFAULT 0 comment '用户名', `contact_number` varchar(64) comment '联系电话', `examine_state` varchar(16) DEFAULT '已通过' NOT NULL comment '审核状态', `pay_state` varchar(16) DEFAULT '未支付' NOT NULL comment '支付状态', `pay_type` varchar(16) DEFAULT '' comment '支付类型: 微信、支付宝、网银', `recommend` int(11) DEFAULT '0' NOT NULL comment '智能推荐', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (scenic_spot_ticket_purchase_id) )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '景点购票'; insert into `scenic_spot_ticket_purchase` values (1,'订单号1','景点编号1','景点名称1','票价1',5,'总价格1',0,'联系电话1','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `scenic_spot_ticket_purchase` values (2,'订单号2','景点编号2','景点名称2','票价2',10,'总价格2',0,'联系电话2','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `scenic_spot_ticket_purchase` values (3,'订单号3','景点编号3','景点名称3','票价3',15,'总价格3',0,'联系电话3','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `scenic_spot_ticket_purchase` values (4,'订单号4','景点编号4','景点名称4','票价4',20,'总价格4',0,'联系电话4','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `scenic_spot_ticket_purchase` values (5,'订单号5','景点编号5','景点名称5','票价5',25,'总价格5',0,'联系电话5','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-03-03 15:29:52'); insert into `scenic_spot_ticket_purchase` values (6,'订单号6','景点编号6','景点名称6','票价6',30,'总价格6',0,'联系电话6','已通过','未支付','支付宝','0','2022-03-03 15:29:52','2022-0