{"action":"created","issue":{"url":"https://api.github.com/repos/DbUp/DbUp/issues/131","labels_url":"https://api.github.com/repos/DbUp/DbUp/issues/131/labels{/name}","comments_url":"https://api.github.com/repos/DbUp/DbUp/issues/131/comments","events_url":"https://api.github.com/repos/DbUp/DbUp/issues/131/events","html_url":"https://github.com/DbUp/DbUp/issues/131","id":106525815,"number":131,"title":"Use DbUp scripts to manage SchemaVersion table","user":{"login":"rickculpepper","id":4801808,"avatar_url":"https://avatars.githubusercontent.com/u/4801808?v=3","gravatar_id":"","url":"https://api.github.com/users/rickculpepper","html_url":"https://github.com/rickculpepper","followers_url":"https://api.github.com/users/rickculpepper/followers","following_url":"https://api.github.com/users/rickculpepper/following{/other_user}","gists_url":"https://api.github.com/users/rickculpepper/gists{/gist_id}","starred_url":"https://api.github.com/users/rickculpepper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rickculpepper/subscriptions","organizations_url":"https://api.github.com/users/rickculpepper/orgs","repos_url":"https://api.github.com/users/rickculpepper/repos","events_url":"https://api.github.com/users/rickculpepper/events{/privacy}","received_events_url":"https://api.github.com/users/rickculpepper/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-09-15T10:17:56Z","updated_at":"2015-09-18T01:23:23Z","closed_at":null,"body":"DbUp should [eat it's own dogfood](https://en.wikipedia.org/wiki/Eating_your_own_dog_food) where the SchemaVersion table is concerened. \r\n\r\n- Create/modify the SchemaVersion table using database scripts.\r\n- Dynamically inject the SchemaVersion script(s) to run *before* any user-specified scripts.\r\n- Include script to transformation any existing SchemaVersion data\r\n- Add tests around the upgrade scenario\r\n"},"comment":{"url":"https://api.github.com/repos/DbUp/DbUp/issues/comments/141300983","html_url":"https://github.com/DbUp/DbUp/issues/131#issuecomment-141300983","issue_url":"https://api.github.com/repos/DbUp/DbUp/issues/131","id":141300983,"user":{"login":"JakeGinnivan","id":453152,"avatar_url":"https://avatars.githubusercontent.com/u/453152?v=3","gravatar_id":"","url":"https://api.github.com/users/JakeGinnivan","html_url":"https://github.com/JakeGinnivan","followers_url":"https://api.github.com/users/JakeGinnivan/followers","following_url":"https://api.github.com/users/JakeGinnivan/following{/other_user}","gists_url":"https://api.github.com/users/JakeGinnivan/gists{/gist_id}","starred_url":"https://api.github.com/users/JakeGinnivan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JakeGinnivan/subscriptions","organizations_url":"https://api.github.com/users/JakeGinnivan/orgs","repos_url":"https://api.github.com/users/JakeGinnivan/repos","events_url":"https://api.github.com/users/JakeGinnivan/events{/privacy}","received_events_url":"https://api.github.com/users/JakeGinnivan/received_events","type":"User","site_admin":false},"created_at":"2015-09-18T01:23:23Z","updated_at":"2015-09-18T01:23:23Z","body":"Maybe we could have a `DelayedWriteJournal` which only writes when all scripts have been run. This allows us to fully upgrade the schema table then we insert the records into the schema table once it is updated. This could live in the `DoesTableExist` method in the Journal? We rename that to `PrepareSchemaTable` or something. "}}