docs/update20190531.sql · 分布式应用开发/72crm-9.0-Jfinal

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 1.1K

分布式应用开发/72crm-9.0-Jfinal

forked from 悟空CRM/72crm-9.0-Jfinal

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (1)

Tags (1)

Manage

master

vJ9.0.1

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 1

Tags 1

72crm-java

docs

update20190531.sql

update20190531.sql 3.91 KB

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for 72crm_crm_owner_record
-- ----------------------------
DROP TABLE IF EXISTS `72crm_crm_owner_record`;
CREATE TABLE `72crm_crm_owner_record` (
 `record_id` int(11) NOT NULL AUTO_INCREMENT,
 `type_id` int(11) NOT NULL COMMENT '对象id',
 `type` int(4) NOT NULL COMMENT '对象类型',
 `pre_owner_user_id` int(20) DEFAULT NULL COMMENT '上一负责人',
 `post_owner_user_id` int(20) DEFAULT NULL COMMENT '接手负责人',
 `create_time` datetime NOT NULL COMMENT '创建时间',
 PRIMARY KEY (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='负责人变更记录表';

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for 72crm_crm_customer_stats
-- ----------------------------
DROP TABLE IF EXISTS `72crm_crm_customer_stats`;
CREATE TABLE `72crm_crm_customer_stats` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(20) NOT NULL COMMENT '用户id',
 `customer_num` int(10) NOT NULL DEFAULT '0' COMMENT '客户总数',
 `create_time` datetime NOT NULL COMMENT '统计时间',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COMMENT='每日客户统计';

INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '员工客户分析', 'customer', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('111', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '销售漏斗', 'funnel', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('113', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '回款统计', 'receivables', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('115', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '产品分析', 'product', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('117', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '业绩目标完成情况', 'performance', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('119', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '员工业绩分析', 'employe', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('121', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '客户画像分析', 'portrait', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('123', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '排行榜', 'ranking', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('125', '查看', 'read', '3', '0', '1', NULL);

Copy Edit Raw Blame History

悟空CRM authored 2019年07月19日 10:15 +08:00 . no message

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48


SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for 72crm_crm_owner_record
-- ----------------------------
DROP TABLE IF EXISTS `72crm_crm_owner_record`;
CREATE TABLE `72crm_crm_owner_record` (
 `record_id` int(11) NOT NULL AUTO_INCREMENT,
 `type_id` int(11) NOT NULL COMMENT '对象id',
 `type` int(4) NOT NULL COMMENT '对象类型',
 `pre_owner_user_id` int(20) DEFAULT NULL COMMENT '上一负责人',
 `post_owner_user_id` int(20) DEFAULT NULL COMMENT '接手负责人',
 `create_time` datetime NOT NULL COMMENT '创建时间',
 PRIMARY KEY (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='负责人变更记录表';


SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for 72crm_crm_customer_stats
-- ----------------------------
DROP TABLE IF EXISTS `72crm_crm_customer_stats`;
CREATE TABLE `72crm_crm_customer_stats` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `user_id` int(20) NOT NULL COMMENT '用户id',
 `customer_num` int(10) NOT NULL DEFAULT '0' COMMENT '客户总数',
 `create_time` datetime NOT NULL COMMENT '统计时间',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COMMENT='每日客户统计';

INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '员工客户分析', 'customer', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('111', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '销售漏斗', 'funnel', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('113', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '回款统计', 'receivables', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('115', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '产品分析', 'product', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('117', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '业绩目标完成情况', 'performance', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('119', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '员工业绩分析', 'employe', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('121', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '客户画像分析', 'portrait', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('123', '查看', 'read', '3', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('2', '排行榜', 'ranking', '1', '0', '1', NULL);
INSERT INTO `72crm_admin_menu` (`parent_id`, `menu_name`, `realm`, `menu_type`, `sort`, `status`, `remarks`) VALUES ('125', '查看', 'read', '3', '0', '1', NULL);