issue_comments: 277454303
This data as json
html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | performed_via_github_app | issue |
---|---|---|---|---|---|---|---|---|---|---|---|
https://github.com/ACEmulator/ACE/issues/20#issuecomment-277454303 | https://api.github.com/repos/ACEmulator/ACE/issues/20 | 277454303 | MDEyOklzc3VlQ29tbWVudDI3NzQ1NDMwMw== | 570040 | 2017-02-04T15:48:45Z | 2017-02-04T15:48:45Z | CONTRIBUTOR | I suggest a reasonable first version of this might look like: 1) an update to the core .sql file and `Config.json` to add a new `ace_global` database with a table `schema_revisions` tracking database schema versions The columns might be something like: `id int(auto increment), schema_name varchar, schema_version int` also insert initial values into the `schema_revisions` table to set the current `schema_version` at 0 on all databases (`ace_auth`, `ace_character`, `ace_world`). 2) add a task that runs during server startup that uses the database names from `Config.json` and compares the .sql files found on the filesystem against the results from `ace_global.schema_revisions` and runs the new ones, and updates the database. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 205353528 |