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

Atvērta
liujq atvēra 1 gadu atpakaļ · 0 komentāri
liujq komentēja 1 gadu atpakaļ
     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 '官网网址';
Pierakstieties, lai pievienotos šai sarunai.
Nav etiķešu
Nav atskaites punktu
Nav atbildīgā
1 dalībnieki
Notiek ielāde...
Atcelt
Saglabāt
Vēl nav satura.