#34 9-21 用户表新增字段

Open
opened 1 year ago by liujq · 0 comments
liujq commented 1 year ago
     ALTER TABLE scp_user ADD COLUMN  `POSITION_CN` varchar(255) character set utf8 default null comment '职务(中文)';
    ALTER TABLE scp_user ADD COLUMN  `POSITION_EN` varchar(255) character set utf8 default null comment '职务(英文)';
    ALTER TABLE scp_user ADD COLUMN  `WE_CHAT` varchar(255) character set utf8 default null comment '微信';
    ALTER TABLE scp_user ADD COLUMN  `WE_COM` varchar(255) character set utf8 default null comment '企业微信';
    ALTER TABLE scp_user ADD COLUMN  `QQ` varchar(255) character set utf8 default null comment 'QQ';
    ALTER TABLE scp_user ADD COLUMN  `ORG_QQ` varchar(255) character set utf8 default null comment '企业QQ';
    ALTER TABLE scp_user ADD COLUMN  `WHATS_APP` varchar(255) character set utf8 default null comment 'WhatsApp';
    ALTER TABLE scp_user ADD COLUMN  `SKYPE` varchar(255) character set utf8 default null comment 'Skype';
    ALTER TABLE scp_user ADD COLUMN  `ORG_NAME` varchar(255) character set utf8 default null comment '企业名称(中文)';
    ALTER TABLE scp_user ADD COLUMN  `ORG_ENNAME` varchar(255) character set utf8 default null comment '企业名称(英文)';
    ALTER TABLE scp_user ADD COLUMN  `WEBSITE` varchar(255) character set utf8 default null comment '官网网址';   
ALTER TABLE scp_user ADD COLUMN `POSITION_CN` varchar(255) character set utf8 default null comment '职务(中文)'; ALTER TABLE scp_user ADD COLUMN `POSITION_EN` varchar(255) character set utf8 default null comment '职务(英文)'; ALTER TABLE scp_user ADD COLUMN `WE_CHAT` varchar(255) character set utf8 default null comment '微信'; ALTER TABLE scp_user ADD COLUMN `WE_COM` varchar(255) character set utf8 default null comment '企业微信'; ALTER TABLE scp_user ADD COLUMN `QQ` varchar(255) character set utf8 default null comment 'QQ'; ALTER TABLE scp_user ADD COLUMN `ORG_QQ` varchar(255) character set utf8 default null comment '企业QQ'; ALTER TABLE scp_user ADD COLUMN `WHATS_APP` varchar(255) character set utf8 default null comment 'WhatsApp'; ALTER TABLE scp_user ADD COLUMN `SKYPE` varchar(255) character set utf8 default null comment 'Skype'; ALTER TABLE scp_user ADD COLUMN `ORG_NAME` varchar(255) character set utf8 default null comment '企业名称(中文)'; ALTER TABLE scp_user ADD COLUMN `ORG_ENNAME` varchar(255) character set utf8 default null comment '企业名称(英文)'; ALTER TABLE scp_user ADD COLUMN `WEBSITE` varchar(255) character set utf8 default null comment '官网网址';
Sign in to join this conversation.
No Label
No Milestone
No assignee
1 Participants
Loading...
Cancel
Save
There is no content yet.