rVJFmQdN

1<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
2    <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
3    <property name="hibernate.connection.url">jdbc:mysql://localhost:3310/mydb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false</property>
4    <property name="hibernate.connection.username">root</property>
5    <property name="hibernate.connection.password">qet</property>
6    <property name="format_sql">true</property>
7    <property name="hibernate.hbm2ddl.import_files_sql_extractor">org.hibernate.tool.hbm2ddl.MultipleLinesSqlCommandExtractor</property>
8    <property name="hibernate.hbm2ddl.auto">update</property>
9    <property name="hibernate.hbm2ddl.import_files">/database/initial.sql</property>
10	
11-- Test Cases
12CREATE TABLE IF NOT EXISTS `testCases` (
13  `idtestCase` int(11) NOT NULL AUTO_INCREMENT,
14  `name` varchar(45) NOT NULL,
15  `type` int(11) DEFAULT NULL,
16  `data` blob,
17  `amountOfInputs` int(11) DEFAULT '0',
18  `creationDate` varchar(45) DEFAULT NULL,
19  `createdBy` varchar(45) DEFAULT NULL,
20  `tellerConfig` int(11) DEFAULT NULL,
21  PRIMARY KEY (`idtestCase`),
22  KEY `fk03_idx` (`type`),
23  KEY `fk_tellerConfig_idx` (`tellerConfig`),
24  CONSTRAINT `fk03` FOREIGN KEY (`type`) REFERENCES `testType` (`idtestType`) ON DELETE NO ACTION ON UPDATE NO ACTION,
25  CONSTRAINT `fk_tellerConfig` FOREIGN KEY (`tellerConfig`) REFERENCES `tellerConfigs` (`id_tellerConfig`) ON DELETE NO ACTION ON UPDATE NO ACTION
26) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;