龙兵智能名片源码5.99.84.zip

SET FOREIGN_KEY_CHECKS=0; CREATE TABLE `ims_longbing_action_log` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键' , `user_id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '执行用户id' , `username` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名' , `ip` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '执行行为者ip' , `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '行为名称' , `describe` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述' , `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '执行的URL' , `param` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '请求参数' , `status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '状态' , `uniacid` int(10) NOT NULL , `update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 , `create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行行为的时间' , `mem` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消耗内存' , `execution_time` double(11,6) NOT NULL COMMENT '执行时间' , `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '返回内容' , PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci CHECKSUM=0 ROW_FORMAT=Dynamic DELAY_KEY_WRITE=0 ; CREATE TABLE `ims_longbing_cardauth2_auth_app` ( `id` int(11) NOT NULL AUTO_INCREMENT , `modular_id` int(10) NOT NULL DEFAULT 0 , `sign` int(10) NOT NULL DEFAULT 0 , `uniacid` int(10) NOT NULL , `status` int(3) NOT NULL DEFAULT 1 , `create_time` int(11) NOT NULL DEFAULT 0 , `update_time` int(11) NOT NULL DEFAULT 0 , `count` int(11) NOT NULL DEFAULT 0 , `app_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , `sign_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=Dynamic ; ALTER TABLE `ims_longbing_cardauth2_config` MODIFY COLUMN `boos` int(10) NOT NULL AFTER `send_switch`; ALTER TABLE `ims_longbing_cardcloud_radar_client` DROP COLUMN `tel_note`; ALTER TABLE `ims_longbing_cardcloud_radar_data` DROP COLUMN `words`; ALTER TABLE `ims_longbing_cardcloud_radar_data` DROP COLUMN `table_id`; ALTER TABLE `ims_longbing_cardcloud_radar_event` MODIFY COLUMN `is_show` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '是否展示在事件页面 1-展示 0-不展示' AFTER `words`; ALTER TABLE `ims_longbing_cardcloud_radar_rules` MODIFY COLUMN `type` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '1-客户兴趣占比类型' AFTER `update_time`; CREATE TABLE `ims_longbing_card_baidu_setting` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `uniacid` int(11) NULL DEFAULT NULL , `client_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '百度id' , `client_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '百度密钥' , `create_time` int(11) NOT NULL , `update_time` int(11) NOT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic ; ALTER TABLE `ims_longbing_card_config` ADD COLUMN `dynamic_switch` tinyint(1) NOT NULL DEFAULT 0 COMMENT '名片首页展示动态' AFTER `is_sync`; CREATE INDEX `count_radar` ON `ims_longbing_card_count`(`to_uid`, `type`, `sign`, `uniacid`) USING BTREE ; CREATE INDEX `count_user_unread` ON `ims_longbing_card_count`(`to_uid`, `unread`) USING BTREE ; ALTER TABLE `ims_longbing_card_house` ADD COLUMN `img_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详情图' AFTER `address`; CREATE TABLE `ims_longbing_card_house_staff` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `uniacid` int(11) NULL DEFAULT NULL , `house_id` int(11) NOT NULL DEFAULT 0 , `staff_id` int(11) NOT NULL DEFAULT 0 , `create_time` int(11) NOT NULL DEFAULT 0 , `status` int(11) NOT NULL DEFAULT 0 , `update_time` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic ; CREATE TABLE `ims_longbing_card_message_friend` ( `id` int(11) NOT NULL AUTO_INCREMENT , `user_id` int(10) NOT NULL COMMENT '发送消息用户id' , `friend_id` int(10) NOT NULL COMMENT '接收消息用户id' , `message_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'text' , `lastmessage` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '消息内容' , `not_read_message_count` int(11) NOT NULL DEFAULT 0 COMMENT '未读消息数量' , `uniacid` int(10) NOT NULL , `create_time` int(11) NOT NULL DEFAULT 0 , `update_time` int(11) NOT NULL DEFAULT 0 , `is_read` tinyint(1) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`), INDEX `chat_id` (`user_id`, `friend_id`, `create_time`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=Dynamic ; CREATE TABLE `ims_longbing_card_staff_hand_log` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `uniacid` int(11) NULL DEFAULT NULL , `staff_id` int(11) NOT NULL DEFAULT 0 COMMENT '交接员工id' , `to_staff_id` int(11) NOT NULL DEFAULT 0 COMMENT '被交接员工id' , `timeline` int(11) NOT NULL DEFAULT 0 COMMENT '是否交接动态' , `card_qr` int(11) NOT NULL DEFAULT 0 COMMENT '是否交接名片码' , `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '交接时间' , `type` int(11) NOT NULL DEFAULT 0 COMMENT '交接类型' , `action_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '操作人员' , `status` int(11) NOT NULL DEFAULT 0 , `action` int(11) NOT NULL DEFAULT 0 , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic ; ALTER TABLE `ims_longbing_card_timeline` ROW_FORMAT=Dynamic; ALTER TABLE `ims_longbing_card_timeline` MODIFY COLUMN `id` int(11) NOT NULL AUTO_INCREMENT FIRST ; CREATE TABLE `ims_longbing_card_tmpl_config` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `uniacid` int(11) NULL DEFAULT NULL , `model_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模块名' , `model_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模块key' , `tmpl_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模版id' , `tmpl_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模版名字' , `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间' , `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间' , `tid` int(11) NOT NULL DEFAULT 0 COMMENT '模版消息的标题id' , `kidList` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模版消息的内容' , `sceneDesc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '模版消息场景' , `kid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '生成模版类容时候需要传的' , `example` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '样板内容' , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic ; CREATE TABLE `ims_longbing_card_tmpl_user` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , `uniacid` int(11) NOT NULL , `user_id` int(11) NOT NULL , `tmpl_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , `status` int(11) NOT NULL , PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=Dynamic ; ALTER TABLE `ims_longbing_card_user` MODIFY CO