META-INF.sql.tables.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of com.liferay.portal.security.audit.storage.service

Liferay Portal Security Audit Storage Service

There is a newer version: 6.0.47

Show newest version

create table Audit_AuditEvent (
	auditEventId LONG not null primary key,
	companyId LONG,
	userId LONG,
	userName VARCHAR(200) null,
	createDate DATE null,
	eventType VARCHAR(75) null,
	className VARCHAR(200) null,
	classPK VARCHAR(75) null,
	message STRING null,
	clientHost VARCHAR(255) null,
	clientIP VARCHAR(255) null,
	serverName VARCHAR(255) null,
	serverPort INTEGER,
	sessionID VARCHAR(255) null,
	additionalInfo TEXT null
);