NC Cloud适配CA认证的SQL建表预置数据

/*创建公钥证书源表*/
drop table ITRUS_NC_CERTINFO;
create table ITRUS_NC_CERTINFO(
CERT_UID varchar2(50),
CERT_SERIALNUMBER varchar2(50),
CERT_BUF clob,
CERT_NOTBEFORE varchar2(14),
CERT_NOTAFTER varchar2(14),
CERT_STATUS number(1),
TS varchar(19),
DR number(11),
primary key (CERT_UID,CERT_SERIALNUMBER)
);

/*创建管理员表*/
drop table ITRUS_NC_USERINFO;
create table ITRUS_NC_USERINFO(
NAME varchar2(50),
PASSWORD varchar2(50),
DR number(11),
TS varchar(19)
);
/*增加默认管理员 默认密码1234 */
insert into ITRUS_NC_USERINFO (NAME,PASSWORD) values ('admin','SHA1cRDtpNCeBiql5KOQsKVyrA0sAiA=');
commit;

sqlserver

/*创建公钥证书源表*/
drop table ITRUS_NC_CERTINFO;
create table ITRUS_NC_CERTINFO(
CERT_UID varchar(50) primary key,
CERT_SERIALNUMBER varchar(50),
CERT_BUF text,
CERT_NOTBEFORE varchar(14),
CERT_NOTAFTER varchar(14),
CERT_STATUS numeric(1, 0),
TS varchar(19),
DR numeric(11, 0)
); 

/*创建管理员表*/
drop table ITRUS_NC_USERINFO;
create table ITRUS_NC_USERINFO(
NAME varchar(50),
PASSWORD varchar(50),
DR numeric(11, 0),
TS varchar(19)
);
/*增加默认管理员 默认密码1234 */
insert into ITRUS_NC_USERINFO (NAME,PASSWORD) values ('admin','SHA1cRDtpNCeBiql5KOQsKVyrA0sAiA=');
commit;