VIP31/consumer-service-demo/admin-demo/sql/sfcc_bak_2024-08-13.sql

# ************************************************************
# Sequel Ace SQL dump
# 版本号： 20067
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# 主机: localhost (MySQL 8.0.33)
# 数据库: sfcc_bak
# 生成时间: 2024-08-13 01:21:22 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# 转储表 sts_echarts
# ------------------------------------------------------------

DROP TABLE IF EXISTS `sts_echarts`;

CREATE TABLE `sts_echarts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `int_day` date DEFAULT NULL COMMENT '时间',
  `in_answer_calls` int DEFAULT NULL COMMENT '应答呼入量',
  `in_calls` int DEFAULT NULL COMMENT '总呼入量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

LOCK TABLES `sts_echarts` WRITE;
/*!40000 ALTER TABLE `sts_echarts` DISABLE KEYS */;

INSERT INTO `sts_echarts` (`id`, `int_day`, `in_answer_calls`, `in_calls`)
VALUES
	(1,'2024-08-12',110,118),
	(2,'2024-08-11',32,38),
	(3,'2024-08-13',121,132);

/*!40000 ALTER TABLE `sts_echarts` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;