This board contains sensitive information and was shared to "invitees only".
Insensitive information should be going to 服貿協議相關 g0v 專案
SSH access
Transfer your `~/.ssh/id_rsa.pub` to authorized owners for ssh access without password.
If you don’t have `id_rsa.pub`, run
Then you will have it in `~/.ssh/`
Machine List
For your conveniences to access rapidly, put this machines into your `~/.ssh/config` as following format.
Deployment
All `/tisa-app\\d+/` machines have a clone of codebase at `~/tisa-map`. Currently we have no capistrano script. Just run
And restart unicorn server in `screen` session.
Database
To run Sequel console, put following content in `config/database.yml`
And run
Some recent backups from the production environment
postgresql array column
http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_array_rb.html
http://www.postgresql.org/docs/9.3/static/functions-array.html
postgresql json column
http://sequel.jeremyevans.net/rdoc-plugins/files/lib/sequel/extensions/pg_json_rb.html
http://www.postgresql.org/docs/9.3/static/functions-json.html
代碼對照表 與 服務貿易特定承諾表 對照數字(紅字, 57 個)
https://www.dropbox.com/sh/xh488y46hgxjy6b/LFIfMNhQ_M
Company
| id | integer |
| location | geometry(Point,4326) |
| taxid | character(8) |
| name | character varying(128) |
| address | text |
| categories | text[] |
| status | character varying(128) |
| owner | character varying(128) |
Tisa
| id | integer |
| articles | json |
CPC
| id | integer |
| tisa_id | integer |
| key | text |
| name | text |
Group
| id | integer |
| tisa_id | integer |
Category
Standard
| id | integer |
| type | integer |
| ip | text |
| created_at | timestamp without time zone |
| updated_at | timestamp without time zone |
Shelling Ford navyblueshellingford@gmail.com
howard chi chilijung@gmail.com
Johnson Liang johnsonliang7@gmail.com