• Home
• com.github.jonasrutishauser
• transactional-event-quarkus-deployment
• 2.1.2
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

nasrutishauser.transactional-event-quarkus-deployment.2.1.2.source-code.transactional-event-tables-mysql.sql Maven / Gradle / Ivy

DROP INDEX event_store_locked_until ON event_store;
DROP TABLE event_store;

CREATE TABLE event_store (
	id VARCHAR(50) NOT NULL,
	event_type VARCHAR(50) NOT NULL,
	context VARCHAR(4000),
	payload VARCHAR(4000) NOT NULL,
	published_at TIMESTAMP NOT NULL,
	tries INT NOT NULL,
	lock_owner VARCHAR(50),
	locked_until BIGINT NOT NULL,
	PRIMARY KEY (id)
);

CREATE INDEX event_store_locked_until ON event_store (locked_until);