Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
- <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
- <property name="hibernate.connection.url">jdbc:mysql://localhost:3310/mydb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false</property>
- <property name="hibernate.connection.username">root</property>
- <property name="hibernate.connection.password">qet</property>
- <property name="format_sql">true</property>
- <property name="hibernate.hbm2ddl.import_files_sql_extractor">org.hibernate.tool.hbm2ddl.MultipleLinesSqlCommandExtractor</property>
- <property name="hibernate.hbm2ddl.auto">update</property>
- <property name="hibernate.hbm2ddl.import_files">/database/initial.sql</property>
- -- Test Cases
- CREATE TABLE IF NOT EXISTS `testCases` (
- `idtestCase` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(45) NOT NULL,
- `type` int(11) DEFAULT NULL,
- `data` blob,
- `amountOfInputs` int(11) DEFAULT '0',
- `creationDate` varchar(45) DEFAULT NULL,
- `createdBy` varchar(45) DEFAULT NULL,
- `tellerConfig` int(11) DEFAULT NULL,
- PRIMARY KEY (`idtestCase`),
- KEY `fk03_idx` (`type`),
- KEY `fk_tellerConfig_idx` (`tellerConfig`),
- CONSTRAINT `fk03` FOREIGN KEY (`type`) REFERENCES `testType` (`idtestType`) ON DELETE NO ACTION ON UPDATE NO ACTION,
- CONSTRAINT `fk_tellerConfig` FOREIGN KEY (`tellerConfig`) REFERENCES `tellerConfigs` (`id_tellerConfig`) ON DELETE NO ACTION ON UPDATE NO ACTION
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
Add Comment
Please, Sign In to add comment