search

enilu / web-flash

web-flash -- Admin Framework and Mobile Website Based on Spring Boot and Vue.js
http://webflash.enilu.cn
MIT License
1.3k stars 365 forks source link

建表sql语句在哪？ #4

Closed InvisibleEmbrace closed 5 years ago

enilu commented 5 years ago

系统启动自动创建表，初始化数据在flash-api/src/main/resources/import.sql

localc commented 5 years ago

数据库库名修改后是否不能创建表，单独的数据库web_flash,拥有增删改查和create,drop等权限，无自动创建表，将项目中三个建表语句添加create_by等通用4字段建表后，报web_flash.t_sys_dict doesn't exist ERROR [SqlExceptionHelper]:142 Table 'web_flash.t_sys_dict' doesn't exist

已找到问题，在application.properties中注释了如下三行代码后不能自动建表 spring.jpa.hibernate.ddl-auto=create spring.datasource.sql-script-encoding=utf-8 server.servlet.context-path=/api