mirror of
https://github.com/chatopera/cosin.git
synced 2025-08-01 16:38:02 +08:00
22 lines
729 B
SQL
22 lines
729 B
SQL
USE `cosinee`;
|
|
-- -----------------
|
|
-- prepare variables
|
|
-- -----------------
|
|
|
|
CREATE TABLE IF NOT EXISTS `cs_fb_messenger` (
|
|
`id` varchar(32) NOT NULL,
|
|
`page_id` varchar(100) NOT NULL,
|
|
`token` varchar(300) NOT NULL,
|
|
`verify_token` varchar(100) NOT NULL,
|
|
`name` varchar(100) NOT NULL,
|
|
`status` varchar(100) NOT NULL,
|
|
`organ` varchar(32) NOT NULL,
|
|
`aiid` varchar(32) DEFAULT NULL,
|
|
`ai` tinyint(4) DEFAULT '0' COMMENT '启用AI',
|
|
`aisuggest` tinyint(4) DEFAULT '0' COMMENT '启用智能建议',
|
|
`config` VARCHAR(1000) NULL DEFAULT NULL COMMENT '文案配置',
|
|
`createtime` datetime NOT NULL,
|
|
`updatetime` datetime NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='FB渠道';
|