文档备忘录（便签记录）

CREATE TABLE `pm_report_user_day_data` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `date` date NOT NULL DEFAULT '2000-01-01' COMMENT '每日数据-日期',
  `userid` varchar(50) NOT NULL DEFAULT '' COMMENT '订单发起人',
  `username` varchar(50) NOT NULL DEFAULT '' COMMENT '订单发起人姓名',
  `dept_id` varchar(50) NOT NULL DEFAULT '' COMMENT '订单发起部门',
  `dept_name` varchar(50) NOT NULL DEFAULT '' COMMENT '订单发起部门',
  `data_yesterday_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '昨日成交数量',
  `data_yesterday_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '昨日成交价格',
  `data_yesterday_payment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '昨日回款数量',
  `data_yesterday_payment_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '昨日回款价格',
  `data_month_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '本月成交数量',
  `data_month_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '本月成交金额',
  `data_month_payment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '本月回款数量',
  `data_month_payment_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '本月回款金额',
  `data_year_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '本年成交数量',
  `data_year_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '本年成交金额',
  `data_year_payment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '本年回款数量',
  `data_year_payment_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '本年回款金额',
  `data_receive_payment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '应收回款数量',
  `data_receive_payment_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '应收回款金额',
  `data_execute_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '执行中数量',
  `data_execute_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '执行中金额',
  `data_contract_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '待归档数量',
  `data_contract_price` varchar(20) NOT NULL DEFAULT '0.00' COMMENT '待归档金额',
  `create_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_date_userid` (`date`,`userid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单系统-以用户为维度的每日统计报表';

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_yesterday_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '昨日成交数量' AFTER `json`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_yesterday_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '昨日成交价格' AFTER `data_yesterday_num`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_yesterday_payment_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '昨日回款数量' AFTER `data_yesterday_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_yesterday_payment_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '昨日回款价格' AFTER `data_yesterday_payment_num`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_month_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本月成交数量' AFTER `json`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_month_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '本月成交金额' AFTER `data_month_num`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_month_payment_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本月回款数量' AFTER `data_month_price`;
--   年度
ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_month_payment_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '本月回款金额' AFTER `data_month_payment_num`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_year_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本年成交数量' AFTER `data_year_payment_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_year_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '本年成交金额' AFTER `data_year_num`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_year_payment_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '本年回款数量' AFTER `data_year_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_year_payment_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '本年回款金额' AFTER `data_year_payment_num`;

--  应收回款
ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_receive_payment_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '应收回款数量' AFTER `data_year_payment_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_receive_payment_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '应收回款金额' AFTER `data_receive_payment_num`;

--  执行中
ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_execute_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行中数量' AFTER `data_receive_payment_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_execute_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '执行中金额' AFTER `data_execute_num`;

--  待归档
ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_contract_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '待归档数量' AFTER `data_execute_price`;

ALTER TABLE `pm_report_user_day` 
ADD COLUMN `data_contract_price` VARCHAR(20) NOT NULL DEFAULT '0.00' COMMENT '待归档金额' AFTER `data_contract_num`;

ALTER TABLE `digital_test`.`pm_product_module` 
ADD COLUMN `sort` smallint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '产品模块排序，由大到小' AFTER `status`;
ALTER TABLE `digital_test`.`pm_product_module_billing` 
ADD COLUMN `unit_fixed` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '计费单位是否固定' AFTER `base_price`,
ADD COLUMN `extra_price` decimal(16, 4) NOT NULL DEFAULT 0.0000 COMMENT '模块额外加成价' AFTER `unit_fixed`;

ALTER TABLE `admin_user` 
ADD COLUMN `auth_for_private` TINYINT(2) DEFAULT 2 COMMENT '是否有下载敏感信息权限:1是2否;默认为2否' AFTER `area_id`;

ALTER TABLE `report_list_product_application` 
ADD COLUMN `product_member` varchar(50) DEFAULT NULL COMMENT '产品会员类型' AFTER `product_type`;

ALTER TABLE `pm_processl_group` 
ADD COLUMN `sort` TINYINT(2) unsigned NOT NULL DEFAULT 1 COMMENT '排序' AFTER `process`;

ALTER TABLE `pm_processl_group_module` 
ADD COLUMN `sort` TINYINT(2) unsigned NOT NULL DEFAULT 1 COMMENT '排序' AFTER `user_name`;

ALTER TABLE `digital_test`.`pre_sales_assess` 
ADD COLUMN `approve_time` timestamp(0) NOT NULL DEFAULT '2000-01-01 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '审批完成时间' AFTER `finish_time`;

ALTER TABLE `que_share` 
ADD COLUMN `share_title` varchar(255) NOT NULL DEFAULT '' COMMENT '微信分享标题' AFTER `prize_rate`,
ADD COLUMN `share_abstract` varchar(500) NOT NULL DEFAULT '' COMMENT '微信分享的摘要' AFTER `share_title`,
ADD COLUMN `share_pic` varchar(500) NOT NULL COMMENT '分享的封面图链接' AFTER `share_abstract`,
ADD COLUMN `is_dialog` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否开启弹框提醒，目前仅针对接入产品有效' AFTER `share_pic`;