• Home
• com.github.paulcwarren
• spring-versions-jpa
• 3.0.17
• source code
• schema-mysql.sql

×

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.

org.springframework.versions.jpa.schema-mysql.sql Maven / Gradle / Ivy

CREATE TABLE IF NOT EXISTS locks(
    entity_id VARCHAR(64) NOT NULL PRIMARY KEY,
    lock_owner VARCHAR(64)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SELECT IF (
    EXISTS (
        SELECT DISTINCT index_name FROM information_schema.statistics
        WHERE table_schema = DATABASE()
        AND table_name = 'locks' AND index_name like 'locks_pk'
    )
    ,'SELECT ''index index_1 exists'' _______;'
    ,'CREATE UNIQUE INDEX locks_pk ON locks(entity_id,lock_owner)') INTO @a;
PREPARE stmt1 FROM @a;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;