Products
GG网络技术分享 2025-11-13 12:22 7
根据文章内容,
sql -- 创建配置项表 CREATE TABLE ConfigItems ( id BIGINT AUTOINCREMENT PRIMARY KEY, namespaceName VARCHAR NOT NULL, key VARCHAR NOT NULL, value TEXT NOT NULL, dataType VARCHAR NOT NULL, secret BOOLEAN NOT NULL DEFAULT FALSE, createTime TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP, lastModifiedTime TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP ON UPDATE CURRENTTIMESTAMP, tenantId VARCHAR DEFAULT NULL, cdcId BIGINT DEFAULT NULL, application VARCHAR DEFAULT NULL, clusterName VARCHAR DEFAULT NULL, environment VARCHAR DEFAULT NULL, onChangeTimestamp TIMESTAMP DEFAULT NULL, configSource VARCHAR DEFAULT NULL );

-- 创建发布往事表 CREATE TABLE ConfigReleaseHistory ( id BIGINT AUTOINCREMENT PRIMARY KEY, releaseId VARCHAR NOT NULL, app VARCHAR NOT NULL, cluster VARCHAR NOT NULL, environment VARCHAR NOT NULL, tenantId VARCHAR DEFAULT NULL, configDigest VARCHAR NOT NULL, releaseMessage VARCHAR, operator VARCHAR NOT NULL, releaseTime TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP, cdcId BIGINT DEFAULT NULL );
-- 创建配置变来变去事件表 CREATE TABLE ConfigChangeEvents ( id BIGINT AUTOINCREMENT PRIMARY KEY, cdcId BIGINT NOT NULL, configChangeType VARCHAR NOT NULL, configContent TEXT NOT NULL, tenantId VARCHAR DEFAULT NULL, changeTimestamp TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP, application VARCHAR DEFAULT NULL, clusterName VARCHAR DEFAULT NULL, environment VARCHAR DEFAULT NULL, namespaceName VARCHAR DEFAULT NULL, changeDesc VARCHAR );
-- 创建租户信息表 CREATE TABLE Tenants ( id BIGINT AUTOINCREMENT PRIMARY KEY, tenantId VARCHAR NOT NULL, tenantName VARCHAR NOT NULL, tenantDescription TEXT, createTime TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP, lastModifiedTime TIMESTAMP NOT NULL DEFAULT CURRENTTIMESTAMP ON UPDATE CURRENTTIMESTAMP );
这玩意儿脚本创建了Apollo配置中心服务端所需的基本表, 包括配置项、发布往事、配置变来变去事件、租户信息、配置数据中心、集群信息和应用信息等。请根据实际需求调整表结构。
Demand feedback