Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update Install.sql to alter tables instead of creating them on every run. #5

Open
agabuza opened this issue Nov 23, 2015 · 2 comments

Comments

@agabuza
Copy link

agabuza commented Nov 23, 2015

Every time running .UseSQLiteStorage(ConnectionString, options) it attempts to create Hangfire-related tables even if they already exist. This leads to sql-exception and failure.

@agabuza
Copy link
Author

agabuza commented Nov 23, 2015

Proposing to use SQLite 3.3 IF NOT EXISTS statement which will ignore already created items and create missing. It can be used on both CONSTRAINS and TABLES which pretty much covers all cases.

@rocker8942
Copy link

rocker8942 commented Dec 3, 2016

This is already done in https://github.com/wanlitao/HangfireExtension/issues Have a look at.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants