{"action":"opened","issue":{"url":"https://api.github.com/repos/loconomics/loconomics-data/issues/3","repository_url":"https://api.github.com/repos/loconomics/loconomics-data","labels_url":"https://api.github.com/repos/loconomics/loconomics-data/issues/3/labels{/name}","comments_url":"https://api.github.com/repos/loconomics/loconomics-data/issues/3/comments","events_url":"https://api.github.com/repos/loconomics/loconomics-data/issues/3/events","html_url":"https://github.com/loconomics/loconomics-data/issues/3","id":386215352,"node_id":"MDU6SXNzdWUzODYyMTUzNTI=","number":3,"title":"Replicable database schema","user":{"login":"IagoSRL","id":1070576,"node_id":"MDQ6VXNlcjEwNzA1NzY=","avatar_url":"https://avatars1.githubusercontent.com/u/1070576?v=4","gravatar_id":"","url":"https://api.github.com/users/IagoSRL","html_url":"https://github.com/IagoSRL","followers_url":"https://api.github.com/users/IagoSRL/followers","following_url":"https://api.github.com/users/IagoSRL/following{/other_user}","gists_url":"https://api.github.com/users/IagoSRL/gists{/gist_id}","starred_url":"https://api.github.com/users/IagoSRL/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IagoSRL/subscriptions","organizations_url":"https://api.github.com/users/IagoSRL/orgs","repos_url":"https://api.github.com/users/IagoSRL/repos","events_url":"https://api.github.com/users/IagoSRL/events{/privacy}","received_events_url":"https://api.github.com/users/IagoSRL/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-11-30T14:43:39Z","updated_at":"2018-11-30T14:43:39Z","closed_at":null,"author_association":"COLLABORATOR","body":"Per conversations with @ndarilek @samwa @joshdanielson, we need to have a replicable database through the SQL scripts we store and manage at this repo.\r\n\r\nThis topic was covered in the past with Matt (late 2016!) and we have record of it at [an issue and comments on the main repo](https://github.com/loconomics/loconomics/issues/144#issuecomment-277490125), I'm copying from there the main points of tasks/targets that I think we should cover:\r\n\r\n------------\r\n- we need to being able to re-create the whole database from a set of SQL scripts\r\n- and too to track changes (scheme and objects)\r\n- being able to track system tables data and copy it on a database; both data that is tight to code (statuses, types) and tables with manually edited data needed for the system to work (jobtitles, pricingtypes, countries).\r\n- some of that called system tables (another name?) can receive data introduced by users, that at some points (for testing or reproducing bugs) we may want to copy back from live to dev databases and track changes on scripts at repo.\r\n- this must enable us to automate the creating of a new local database with base data, run tests on it for automated testing; or perform changes to try ideas, branch specific changes, without breaking anyone else.\r\n-----------\r\n\r\nThat initial proposal of tasks covered both schema and data. **Let's start here with the schema only**, a task already started by @ndarilek by generating a schema file from the *dev* database, that is the \"core\" of this repo."}}
{"actor":{"display_login":"IagoSRL"}}