sql script.txt

来自「用纯java语言实现的数字证书制作工具。」· 文本 代码 · 共 51 行

use minica

create table AdminData(
	AdminName	varchar(250),
	AdminId		bigint,
	AdminPublicKey	varchar(5000),
	AdminPrivateKey	varchar(5000)
	)

create table CertData(
	Version			varchar(50),
	SerialNumber		varchar(500),
	SignatureAlgorithm	varchar(50),
	Issuers			varchar(250),
	SubjectName		varchar(500),
	Algorithm		varchar(50),
	SubjectPublicKey	varchar(5000),
	SignatureValue		varchar(5000),
	UserID			varchar(8),
	UserCertificate 	varchar(8000)
	)

create table ConfigData(
	AlgorithmNumber		varchar(50),
	ConfigId		bigint,
	CACertificate		varchar(5000),
	CAPrivateKey		varchar(5000)
	)

create table Login(
	Name			varchar(50),
	Psw			char(8),
	ID			varchar(50)
	)

create table UserData(
	UserName		varchar(50),
	Nation			varchar(250),
	City			varchar(250),
	Unit			varchar(250),
	Orgnization		varchar(250),
	IDCard			varchar(50)
	)

create table UserKey(
	UserID			varchar(50),
	AlgorithmNumber		varchar(50),
	UserPublicKey		varchar(5000),
	UserPrivateKey		varchar(5000)
	)