Comprot application DDL

app.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `comprot_entity_ref` (
  `id` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

CREATE TABLE IF NOT EXISTS `comprot_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `displayName` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `email` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `password` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `roles` tinyblob NOT NULL,
  `username` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_username` (`username`),
  UNIQUE KEY `unique_email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=3 ;

CREATE TABLE IF NOT EXISTS `comprot_workbench` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  `userId` bigint(20) NOT NULL,
  `workbenches_ORDER` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_9o65g8favfvm4dx34rahmvh7e` (`userId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=3 ;

CREATE TABLE IF NOT EXISTS `comprot_workbench_compound` (
  `workbenchId` bigint(20) NOT NULL,
  `entityRefId` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  KEY `FK_d4dj291k4lea7djdfm7oc52ds` (`entityRefId`),
  KEY `FK_jmfrf087jgj2ran21mclvbfti` (`workbenchId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

CREATE TABLE IF NOT EXISTS `comprot_workbench_target` (
  `workbenchId` bigint(20) NOT NULL,
  `entityRefId` varchar(255) COLLATE latin1_german2_ci NOT NULL,
  KEY `FK_8x2fmmj0icvwy1ula4m15bot3` (`entityRefId`),
  KEY `FK_28to89h0ixaamxthncflomroe` (`workbenchId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;