代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : local
Source Server Version : 50554
Source Host : localhost:3306
Source Database : nba
Target Server Type : MYSQL
Target Server Version : 50554
File Encoding : 65001
Date: 2022-09-23 22:36:49
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '后台管理id\r\n',
`admin_name` varchar(255) NOT NULL,
`admin_password` varchar(255) NOT NULL,
PRIMARY KEY (`admin_id`),
UNIQUE KEY `admin_name` (`admin_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin');
INSERT INTO `admin` VALUES ('2', 'admin2', '123456');
INSERT INTO `admin` VALUES ('6', 'admin3', '123456');
-- ----------------------------
-- Table structure for atlas
-- ----------------------------
DROP TABLE IF EXISTS `atlas`;
CREATE TABLE `atlas` (
`atlas_id` int(11) NOT NULL AUTO_INCREMENT,
`atlas_theme` varchar(255) NOT NULL,
`atlas_content` varchar(255) DEFAULT NULL,
`atlas_url` varchar(255) NOT NULL,
`atlas_time` datetime NOT NULL,
`type_id` int(11) NOT NULL,
PRIMARY KEY (`atlas_id`),
KEY `type_id` (`type_id`),
CONSTRAINT `atlas_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `type` (`tyep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of atlas
-- ----------------------------
INSERT INTO `atlas` VALUES ('1', '1234', '44444', '/nba/images/1654017446316.jpg', '2022-06-01 01:17:00', '2');
-- ----------------------------
-- Table structure for code
-- ----------------------------
DROP TABLE IF EXISTS `code`;
CREATE TABLE `code` (
`code_id` int(11) NOT NULL AUTO_INCREMENT,
`code_text` varchar(255) NOT NULL,
`code_url` varchar(255) NOT NULL,
PRIMARY KEY (`code_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of code
-- ----------------------------
INSERT INTO `code` VALUES ('1', '7364', 'images/7364.jpg');
INSERT INTO `code` VALUES ('2', '2vyk', 'images/2vyk.jpg');
INSERT INTO `code` VALUES ('3', '22c1', 'images/22c1.jpg');
INSERT INTO `code` VALUES ('4', '6791', 'images/6791.jpg');
INSERT INTO `code` VALUES ('5', 'sxnx', 'images/sxnx.jpg');
INSERT INTO `code` VALUES ('6', 'uwv6', 'images/uwv6.jpg');
INSERT INTO `code` VALUES ('7', 'x5tb', 'images/x5tb.jpg');
INSERT INTO `code` VALUES ('8', 'kmk5', 'images/kmk5.jpg');
INSERT INTO `code` VALUES ('9', '3n3d', 'images/3n3d.jpg');
INSERT INTO `code` VALUES ('10', 'jfvb', 'images/jfvb.jpg');
-- ----------------------------
-- Table structure for hotspot
-- ----------------------------
DROP TABLE IF EXISTS `hotspot`;
CREATE TABLE `hotspot` (
`hotspot_id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`hotspot_one` double NOT NULL,
`hotspot_two` double NOT NULL,
`hotspot_three` double NOT NULL,
`hotspot_four` double NOT NULL,
`hotspot_five` double NOT NULL,
`hotspot_six` double NOT NULL,
`hotspot_seven` double NOT NULL,
`hotspot_eight` double NOT NULL,
`hotspot_nine` double NOT NULL,
`hotspot_ten` double NOT NULL,
`hotspot_eleven` double NOT NULL,
`hotspot_twelve` double NOT NULL,
`hotspot_thirteen` double NOT NULL,
`hotspot_fourteen` double NOT NULL,
`season_id` int(11) NOT NULL,
`hotspot_date` year(4) NOT NULL,
PRIMARY KEY (`hotspot_id`),
KEY `hotspot_ibfk_1` (`player_id`),
KEY `hotspot_ibfk_2` (`season_id`),
CONSTRAINT `hotspot_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `player` (`player_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `hotspot_ibfk_2` FOREIGN KEY (`season_id`) REFERENCES `season` (`season_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of hotspot
-- ----------------------------
-- ----------------------------
-- Table structure for new
-- ----------------------------
DROP TABLE IF EXISTS `new`;
CREATE TABLE `new` (
`new_id` int(11) NOT NULL AUTO_INCREMENT,
`new_theme` varchar(255) NOT NULL,
`new_content` varchar(255) NOT NULL,
`new_time` datetime NOT NULL,
`new_url` varchar(255) NOT NULL,
`type_id` int(11) NOT NULL,
PRIMARY KEY (`new_id`),
KEY `type_id` (`type_id`),
CONSTRAINT `new_ibfk_5` FOREIGN KEY (`type_id`) REFERENCES `type` (`tyep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of new
-- ----------------------------
INSERT INTO `new` VALUES ('38', '123', '222', '2022-06-01 03:38:00', '/nba/images/1654025900113.jpg', '1');
INSERT INTO `new` VALUES ('39', '张会敏', '爱何宗达', '2022-06-03 16:31:00', '/nba/images/1654245125119.jpg', '1');
INSERT INTO `new` VALUES ('40', '张会敏', '达达', '2022-06-03 22:22:00', '123', '1');
INSERT INTO `new` VALUES ('41', '加大肯定啦打多久啊看到啦加大肯定啦的大家啊搭理搭理空间大家啊', '大姐大大开大合肯德基阿瓦达安达健康打卡打五个大未来的', '2022-08-24 17:49:00', '/nba/images/1661334582124.webp', '1');
-- ----------------------------
-- Table structure for partition
-- ----------------------------
DROP TABLE IF EXISTS `partition`;
CREATE TABLE `partition` (
`partition_id` int(11) NOT NULL,
`partition_name` varchar(255) NOT NULL,
`union_id` int(11) NOT NULL,
PRIMARY KEY (`partition_id`),
KEY `union_id` (`union_id`),
CONSTRAINT `partition_ibfk_1` FOREIGN KEY (`union_id`) REFERENCES `union` (`union_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of partition
-- ----------------------------
INSERT INTO `partition` VALUES ('1', '东南', '1');
INSERT INTO `partition` VALUES ('2', '中央', '1');
INSERT INTO `partition` VALUES ('3', '大西洋', '1');
INSERT INTO `partition` VALUES ('4', '西南', '2');
INSERT INTO `partition` VALUES ('5', '西北', '2');
INSERT INTO `partition` VALUES ('6', '太平洋', '2');
-- ----------------------------
-- Table structure for pdate
-- ----------------------------
DROP TABLE IF EXISTS `pdate`;
CREATE TABLE `pdate` (
`pdate_id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`player_date` date NOT NULL,
`rteam_id` int(11) NOT NULL,
`start_num` int(11) NOT NULL,
`pdate_time` double NOT NULL,
`all_hit` double(11,0) NOT NULL,
`all_move` double(11,0) NOT NULL,
`three_hit` double(11,0) NOT NULL,
`three_move` double(11,0) NOT NULL,
`free_hit` double(11,0) NOT NULL,
`free_move` double(11,0) NOT NULL,
`attack` double(11,0) NOT NULL,
`defense` double(11,0) NOT NULL,
`score` double(11,0) NOT NULL,
`backboard` double(11,0) NOT NULL,
`assists` double(11,0) NOT NULL,
`snatch` double(11,0) NOT NULL,
`nutcap` double(11,0) NOT NULL,
`fault` double(11,0) NOT NULL,
`breakrules` double(11,0) NOT NULL,
`season_id` int(11) NOT NULL,
PRIMARY KEY (`pdate_id`),
KEY `season_id` (`season_id`),
KEY `pdate_ibfk_2` (`rteam_id`),
KEY `player_id` (`player_id`),
CONSTRAINT `pdate_ibfk_2` FOREIGN KEY (`rteam_id`) REFERENCES `team` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `pdate_ibfk_3` FOREIGN KEY (`season_id`) REFERENCES `season` (`season_id`),
CONSTRAINT `pdate_ibfk_4` FOREIGN KEY (`player_id`) REFERENCES `player` (`player_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of pdate
-- ----------------------------
INSERT INTO `pdate` VALUES ('3', '4', '2022-09-23', '27', '0', '212', '121', '12', '21', '21', '21', '1', '2', '3', '4', '3', '10', '12', '9', '13', '8', '2');
-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
`player_id` int(11) NOT NULL AUTO_INCREMENT,
`player_name` varchar(255) NOT NULL,
`english_name` varchar(255) NOT NULL,
`player_titl` varchar(255) NOT NULL,
`player_body` varchar(255) NOT NULL,
`team_id` int(11) NOT NULL,
`player_position` varchar(255) NOT NULL,
`player_height` double NOT NULL,
`player_weight` double NOT NULL,
`player_exp` varchar(255) NOT NULL,
`player_nation` varchar(255) NOT NULL,
`player_date` date NOT NULL,
`player_num` int(11) NOT NULL,
`player_draft` int(4) NOT NULL,
`player_before` varchar(255) NOT NULL,
`type_id` int(11) NOT NULL,
PRIMARY KEY (`player_id`),
KEY `player_ibfk_1` (`team_id`),
KEY `player_ibfk_2` (`type_id`),
CONSTRAINT `player_ibfk_1` FOREIGN KEY (`team_id`) REFERENCES `team` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `player_ibfk_2` FOREIGN KEY (`type_id`) REFERENCES `type` (`tyep_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of player
-- ----------------------------
INSERT INTO `player` VALUES ('4', '普雷舍斯-阿丘瓦', 'Precious-Achiuwa', '/nba/images/player/1663249577269.webp', '/nba/images/player/1663249577271.webp', '30', '前锋', '2.03', '102.1', '2', '尼日利亚', '1999-09-19', '5', '2020', 'Memphis/Nigeria', '4');
-- ----------------------------
-- Table structure for schedule
-- ----------------------------
DROP TABLE IF EXISTS `schedule`;
CREATE TABLE `schedule` (
`schedule_id` int(11) NOT NULL AUTO_INCREMENT,
`season_id` int(11) NOT NULL,
`ateam_id` int(11) NOT NULL,
`bteam_id` int(11) NOT NULL,
`afirst_num` int(11) NOT NULL,
`bfirst_num` int(11) NOT NULL,
`asecond_num` int(11) NOT NULL,
`bsecond_num` int(11) NOT NULL,
`athird_num` int(11) NOT NULL,
`bthird_num` int(11) NOT NULL,
`afourth_num` int(11) NOT NULL,
`bfourth_num` int(11) NOT NULL,
`afastbreak_score` int(11) NOT NULL,
`bfastbreak_score` int(11) NOT NULL,
`arestricted_score` int(11) NOT NULL,
`brestricted_score` int(11) NOT NULL,
`afault_score` int(11) NOT NULL,
`bfault_score` int(11) NOT NULL,
`field` varchar(255) NOT NULL,
`schedule_time` datetime NOT NULL,
PRIMARY KEY (`schedule_id`),
KEY `season_id` (`season_id`),
KEY `schedule_ibfk_2` (`ateam_id`),
KEY `schedule_ibfk_3` (`bteam_id`),
CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`season_id`) REFERENCES `season` (`season_id`),
CONSTRAINT `schedule_ibfk_2` FOREIGN KEY (`ateam_id`) REFERENCES `team` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `schedule_ibfk_3` FOREIGN KEY (`bteam_id`) REFERENCES `team` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of schedule
-- ----------------------------
-- ----------------------------
-- Table structure for season
-- ----------------------------
DROP TABLE IF EXISTS `season`;
CREATE TABLE `season` (
`season_id` int(11) NOT NULL AUTO_INCREMENT,
`season_name` varchar(255) NOT NULL,
PRIMARY KEY (`season_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of season
-- ----------------------------
INSERT INTO `season` VALUES ('1', '季前赛');
INSERT INTO `season` VALUES ('2', '季后赛');
INSERT INTO `season` VALUES ('3', '常规赛');
-- ----------------------------
-- Table structure for tdate
-- ----------------------------
DROP TABLE IF EXISTS `tdate`;
CREATE TABLE `tdate` (
`tdate_id` int(11) NOT NULL AUTO_INCREMENT,
`team_id` int(11) NOT NULL,
`tdate_time` datetime NOT NULL,
`all_hit` double(11,0) NOT NULL,
`all_move` double(11,0) NOT NULL,
`three_hit` double(11,0) NOT NULL,
`three_move` double(11,0) NOT NULL,
`free_hit` double(11,0) NOT NULL,
`free_move` double(11,0) NOT NULL,
`attack` double(11,0) NOT NULL,
`defense` double(11,0) NOT NULL,
`score` double(11,0) NOT NULL,
`backboard` double(11,0) NOT NULL,
`assists` double(11,0) NOT NULL,
`snatch` double(11,0) NOT NULL,
`nutcap` double(11,0) NOT NULL,
`fault` double(11,0) NOT NULL,
`breakrules` double(11,0) NOT NULL,
`season_id` int(11) NOT NULL,
PRIMARY KEY (`tdate_id`),
KEY `tdate_ibfk_1` (`team_id`),
CONSTRAINT `tdate_ibfk_1` FOREIGN KEY (`team_id`) REFERENCES `team` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of tdate
-- ----------------------------
INSERT INTO `tdate` VALUES ('3', '27', '2022-09-23 21:21:00', '12', '21', '12', '21', '21', '1', '2', '3', '2', '1', '1', '1', '1', '1', '1', '3');
-- ----------------------------
-- Table structure for team
-- ----------------------------
DROP TABLE IF EXISTS `team`;
CREATE TABLE `team` (
`team_id` int(11) NOT NULL AUTO_INCREMENT,
`team_name` varchar(255) NOT NULL,
`team_region` varchar(255) NOT NULL,
`team_url` varchar(255) NOT NULL,
`team_coach` varchar(255) NOT NULL,
`team_stadium` varchar(255) NOT NULL,
`union_id` int(11) NOT NULL,
`partition_id` int(11) NOT NULL,
PRIMARY KEY (`team_id`),
KEY `union_id` (`union_id`),
KEY `partition_id` (`partition_id`),
CONSTRAINT `team_ibfk_1` FOREIGN KEY (`union_id`) REFERENCES `union` (`union_id`),
CONSTRAINT `team_ibfk_2` FOREIGN KEY (`partition_id`) REFERENCES `partition` (`partition_id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of team
-- ----------------------------
INSERT INTO `team` VALUES ('21', '老鹰', '亚特兰大', '/nba/images/team/1662993352632.svg', '内特 麦克米', '菲利浦体育馆', '1', '1');
INSERT INTO `team` VALUES ('22', '黄蜂', '夏洛特', '/nba/images/team/1662993445494.svg', '', '时代华纳中心球馆', '1', '1');
INSERT INTO `team` VALUES ('23', '热火', '迈阿密', '/nba/images/team/1663210747174.svg', '', '美航球馆', '1', '1');
INSERT INTO `team` VALUES ('24', '魔术', '奥兰多', '/nba/images/team/1663210968200.svg', '', '安利中心', '1', '1');
INSERT INTO `team` VALUES ('25', '奇才', '华盛顿', '/nba/images/team/1663211145307.svg', '', 'Verizon挪威森中心球馆', '1', '1');
INSERT INTO `team` VALUES ('26', '凯尔特人', '波士顿', '/nba/images/team/1663211282622.svg', '', 'TD北岸花园球馆', '1', '3');
INSERT INTO `team` VALUES ('27', '篮网', '布鲁克林', '/nba/images/team/1663211391660.svg', '', '巴克莱中心球馆', '1', '3');
INSERT INTO `team` VALUES ('28', '尼克斯', '纽约', '/nba/images/team/1663211493418.svg', '', '麦迪逊广场花园球馆', '1', '3');
INSERT INTO `team` VALUES ('29', '76人', '费城', '/nba/images/team/1663211641964.svg', '', '瓦乔维亚中心球馆', '1', '3');
INSERT INTO `team` VALUES ('30', '猛龙', '多伦多', '/nba/images/team/1663211728730.svg', '', '加拿大航空中心体育馆', '1', '3');
INSERT INTO `team` VALUES ('31', '公牛', '芝加哥', '/nba/images/team/1663212795957.svg', '', '联合中心球馆', '1', '2');
INSERT INTO `team` VALUES ('32', '骑士', '克利夫兰', '/nba/images/team/1663213021237.svg', '', '速贷球馆', '1', '2');
INSERT INTO `team` VALUES ('33', '活塞', '底特律', '/nba/images/team/1663213163181.svg', '', '奥本山殿球馆', '1', '2');
INSERT INTO `team` VALUES ('34', '步行者', '印第安纳', '/nba/images/team/1663213257899.svg', '', '银行家生活球馆', '1', '2');
INSERT INTO `team` VALUES ('35', '雄鹿', '密尔沃基', '/nba/images/team/1663213380736.svg', '', '布拉德利中心', '1', '2');
INSERT INTO `team` VALUES ('36', '独行侠', '达拉斯', '/nba/images/team/1663213514813.svg', '', '美国航线中心', '2', '4');
INSERT INTO `team` VALUES ('37', '火箭', '休斯顿', '/nba/images/team/1663213599728.svg', '', '丰田中心球馆', '2', '4');
INSERT INTO `team` VALUES ('38', '灰熊', '孟菲斯', '/nba/images/team/1663213685004.svg', '', '联邦快递球馆', '2', '4');
INSERT INTO `team` VALUES ('39', '鹈鹕', '新奥尔良', '/nba/images/team/1663213744612.svg', '', '新奥尔良球馆', '2', '4');
INSERT INTO `team` VALUES ('40', '马刺', '圣安东尼奥', '/nba/images/team/1663213813451.svg', '', 'AT&T中心球馆', '2', '4');
INSERT INTO `team` VALUES ('41', '掘金', '丹佛', '/nba/images/team/1663213926281.svg', '', '丹佛百事中心', '2', '5');
INSERT INTO `team` VALUES ('42', '森林狼', '明尼苏达', '/nba/images/team/1663214040896.svg', '', '标靶中心球馆', '2', '5');
INSERT INTO `team` VALUES ('43', '雷霆', '俄克拉荷马城', '/nba/images/team/1663214152588.svg', '', '切萨皮克能源球馆', '2', '5');
INSERT INTO `team` VALUES ('44', '开拓者', '波特兰', '/nba/images/team/1663223843082.svg', '', '摩达中心', '2', '5');
INSERT INTO `team` VALUES ('45', '爵士', '犹他', '/nba/images/team/1663223951249.svg', '维尔 哈迪', '能源方案球馆', '2', '5');
INSERT INTO `team` VALUES ('46', '勇士', '金州', '/nba/images/team/1663224031912.svg', '', '奥克兰体育馆', '2', '6');
INSERT INTO `team` VALUES ('47', '快船', '洛杉矶', '/nba/images/team/1663224547774.svg', '', '斯台普斯中心', '2', '6');
INSERT INTO `team` VALUES ('48', '湖人', '洛杉矶', '/nba/images/team/1663225110069.svg', '达尔文 哈姆', '斯台普斯中心', '2', '6');
INSERT INTO `team` VALUES ('49', '太阳', '菲尼克斯', '/nba/images/team/1663225924167.svg', '', '美航中心', '2', '6');
INSERT INTO `team` VALUES ('50', '国王', '萨克拉门托', '/nba/images/team/1663226340291.svg', '', '阿科球馆', '2', '6');
-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
`tyep_id` int(11) NOT NULL,
`type_name` varchar(255) NOT NULL,
PRIMARY KEY (`tyep_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES ('1', '其他');
INSERT INTO `type` VALUES ('2', '不止篮球');
INSERT INTO `type` VALUES ('3', 'NBA休赛观察期');
INSERT INTO `type` VALUES ('4', '现役');
INSERT INTO `type` VALUES ('5', '退役');
INSERT INTO `type` VALUES ('6', '历史');
-- ----------------------------
-- Table structure for union
-- ----------------------------
DROP TABLE IF EXISTS `union`;
CREATE TABLE `union` (
`union_id` int(11) NOT NULL AUTO_INCREMENT,
`union_name` varchar(255) NOT NULL,
PRIMARY KEY (`union_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of union
-- ----------------------------
INSERT INTO `union` VALUES ('1', '东部');
INSERT INTO `union` VALUES ('2', '西部');
-- ----------------------------
-- Table structure for video
-- ----------------------------
DROP TABLE IF EXISTS `video`;
CREATE TABLE `video` (
`video_id` int(11) NOT NULL AUTO_INCREMENT,
`video_theme` varchar(255) NOT NULL,
`video_content` varchar(255) DEFAULT NULL,
`video_time` datetime NOT NULL,
`video_url` varchar(255) NOT NULL,
`type_id` int(11) NOT NULL,
PRIMARY KEY (`video_id`),
KEY `type_id` (`type_id`),
CONSTRAINT `video_ibfk_5` FOREIGN KEY (`type_id`) REFERENCES `type` (`tyep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of video
-- ----------------------------
INSERT INTO `video` VALUES ('1', '1234', '1111', '2022-06-01 01:11:00', '/nba/images/1654017074194.jpg', '1');
-- ----------------------------
-- View structure for hps
-- ----------------------------
DROP VIEW IF EXISTS `hps`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `hps` AS select `t1`.`hotspot_id` AS `hotspot_id`,`t1`.`player_id` AS `player_id`,`t1`.`hotspot_one` AS `hotspot_one`,`t1`.`hotspot_two` AS `hotspot_two`,`t1`.`hotspot_three` AS `hotspot_three`,`t1`.`hotspot_four` AS `hotspot_four`,`t1`.`hotspot_five` AS `hotspot_five`,`t1`.`hotspot_six` AS `hotspot_six`,`t1`.`hotspot_seven` AS `hotspot_seven`,`t1`.`hotspot_eight` AS `hotspot_eight`,`t1`.`hotspot_nine` AS `hotspot_nine`,`t1`.`hotspot_ten` AS `hotspot_ten`,`t1`.`hotspot_eleven` AS `hotspot_eleven`,`t1`.`hotspot_twelve` AS `hotspot_twelve`,`t1`.`hotspot_thirteen` AS `hotspot_thirteen`,`t1`.`hotspot_fourteen` AS `hotspot_fourteen`,`t1`.`season_id` AS `season_id`,`t1`.`hotspot_date` AS `hotspot_date`,`t2`.`player_name` AS `player_name`,`t3`.`season_name` AS `season_name` from ((`hotspot` `t1` join `player` `t2`) join `season` `t3`) where ((`t1`.`player_id` = `t2`.`player_id`) and (`t1`.`season_id` = `t3`.`season_id`)) ;
-- ----------------------------
-- View structure for ppts
-- ----------------------------
DROP VIEW IF EXISTS `ppts`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `ppts` AS select `t1`.`pdate_id` AS `pdate_id`,`t1`.`player_id` AS `player_id`,`t1`.`player_date` AS `player_date`,`t1`.`rteam_id` AS `rteam_id`,`t1`.`start_num` AS `start_num`,`t1`.`pdate_time` AS `pdate_time`,`t1`.`all_hit` AS `all_hit`,`t1`.`all_move` AS `all_move`,`t1`.`three_hit` AS `three_hit`,`t1`.`three_move` AS `three_move`,`t1`.`free_hit` AS `free_hit`,`t1`.`free_move` AS `free_move`,`t1`.`attack` AS `attack`,`t1`.`defense` AS `defense`,`t1`.`score` AS `score`,`t1`.`backboard` AS `backboard`,`t1`.`assists` AS `assists`,`t1`.`snatch` AS `snatch`,`t1`.`nutcap` AS `nutcap`,`t1`.`fault` AS `fault`,`t1`.`breakrules` AS `breakrules`,`t1`.`season_id` AS `season_id`,`t2`.`player_name` AS `player_name`,`t3`.`team_name` AS `rteam_name`,`t4`.`season_name` AS `season_name` from (((`pdate` `t1` join `player` `t2`) join `team` `t3`) join `season` `t4`) where ((`t1`.`player_id` = `t2`.`player_id`) and (`t1`.`rteam_id` = `t3`.`team_id`) and (`t1`.`season_id` = `t4`.`season_id`)) ;
-- ----------------------------
-- View structure for ptt
-- ----------------------------
DROP VIEW IF EXISTS `ptt`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `ptt` AS select `t1`.`player_id` AS `player_id`,`t1`.`player_name` AS `player_name`,`t1`.`english_name` AS `english_name`,`t1`.`player_titl` AS `player_titl`,`t1`.`player_body` AS `player_body`,`t1`.`team_id` AS `team_id`,`t1`.`player_position` AS `player_position`,`t1`.`player_height` AS `player_height`,`t1`.`player_weight` AS `player_weight`,`t1`.`player_exp` AS `player_exp`,`t1`.`player_nation` AS `player_nation`,`t1`.`player_date` AS `player_date`,`t1`.`player_num` AS `player_num`,`t1`.`player_draft` AS `player_draft`,`t1`.`player_before` AS `player_before`,`t1`.`type_id` AS `type_id`,`t2`.`team_name` AS `team_name`,`t3`.`type_name` AS `type_name` from ((`player` `t1` join `team` `t2`) join `type` `t3`) where ((`t1`.`team_id` = `t2`.`team_id`) and (`t1`.`type_id` = `t3`.`tyep_id`)) ;
-- ----------------------------
-- View structure for sstt
-- ----------------------------
DROP VIEW IF EXISTS `sstt`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `sstt` AS select `t1`.`schedule_id` AS `schedule_id`,`t1`.`season_id` AS `season_id`,`t1`.`ateam_id` AS `ateam_id`,`t1`.`bteam_id` AS `bteam_id`,`t1`.`afirst_num` AS `afirst_num`,`t1`.`bfirst_num` AS `bfirst_num`,`t1`.`asecond_num` AS `asecond_num`,`t1`.`bsecond_num` AS `bsecond_num`,`t1`.`athird_num` AS `athird_num`,`t1`.`bthird_num` AS `bthird_num`,`t1`.`afourth_num` AS `afourth_num`,`t1`.`bfourth_num` AS `bfourth_num`,`t1`.`afastbreak_score` AS `afastbreak_score`,`t1`.`bfastbreak_score` AS `bfastbreak_score`,`t1`.`arestricted_score` AS `arestricted_score`,`t1`.`brestricted_score` AS `brestricted_score`,`t1`.`afault_score` AS `afault_score`,`t1`.`bfault_score` AS `bfault_score`,`t1`.`field` AS `field`,`t1`.`schedule_time` AS `schedule_time`,`t2`.`season_name` AS `season_name`,`t3`.`team_name` AS `ateam_name`,`t4`.`team_name` AS `bteam_name` from (((`schedule` `t1` join `season` `t2`) join `team` `t3`) join `team` `t4`) where ((`t1`.`ateam_id` = `t3`.`team_id`) and (`t1`.`bteam_id` = `t4`.`team_id`) and (`t1`.`season_id` = `t2`.`season_id`)) ;
-- ----------------------------
-- View structure for tts
-- ----------------------------
DROP VIEW IF EXISTS `tts`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `tts` AS select `t1`.`tdate_id` AS `tdate_id`,`t1`.`team_id` AS `team_id`,`t1`.`tdate_time` AS `tdate_time`,`t1`.`all_hit` AS `all_hit`,`t1`.`all_move` AS `all_move`,`t1`.`three_hit` AS `three_hit`,`t1`.`three_move` AS `three_move`,`t1`.`free_hit` AS `free_hit`,`t1`.`free_move` AS `free_move`,`t1`.`attack` AS `attack`,`t1`.`defense` AS `defense`,`t1`.`score` AS `score`,`t1`.`backboard` AS `backboard`,`t1`.`assists` AS `assists`,`t1`.`snatch` AS `snatch`,`t1`.`nutcap` AS `nutcap`,`t1`.`fault` AS `fault`,`t1`.`breakrules` AS `breakrules`,`t1`.`season_id` AS `season_id`,`t2`.`team_name` AS `team_name`,`t3`.`season_name` AS `season_name` from ((`tdate` `t1` join `team` `t2`) join `season` `t3`) where ((`t1`.`team_id` = `t2`.`team_id`) and (`t1`.`season_id` = `t3`.`season_id`)) ;
-- ----------------------------
-- View structure for tup
-- ----------------------------
DROP VIEW IF EXISTS `tup`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `tup` AS select `t1`.`team_id` AS `team_id`,`t1`.`team_name` AS `team_name`,`t1`.`team_region` AS `team_region`,`t1`.`team_url` AS `team_url`,`t1`.`team_coach` AS `team_coach`,`t1`.`team_stadium` AS `team_stadium`,`t1`.`union_id` AS `union_id`,`t1`.`partition_id` AS `partition_id`,`t2`.`union_name` AS `union_name`,`t3`.`partition_name` AS `partition_name` from ((`team` `t1` join `union` `t2`) join `partition` `t3`) where ((`t1`.`union_id` = `t2`.`union_id`) and (`t1`.`partition_id` = `t3`.`partition_id`) and (`t2`.`union_id` = `t3`.`union_id`)) ;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手