Guest User

Untitled

a guest
Apr 23rd, 2018
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  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
  12. CREATE 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;
Add Comment
Please, Sign In to add comment