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

wanlitao / HangfireExtension

Hangfire Extension plugins

Apache License 2.0

22 stars 32 forks source link

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

Closed agabuza closed 8 years ago

agabuza commented 8 years ago

Hi, 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 commented 8 years ago

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.