-
Notifications
You must be signed in to change notification settings - Fork 1
/
create_databases.sh
27 lines (20 loc) · 2.15 KB
/
create_databases.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
#!/bin/sh
# Kanboard module
sqlite3 kanboard.sqlite "CREATE TABLE api_keys ( matrix_user VARCHAR(100), api_key VARCHAR(100), stored_at DATETIME);"
sqlite3 kanboard.sqlite "CREATE TABLE auth_requests (id VARCHAR(40), matrix_user VARCHAR(100), room_id VARCHAR(100), requested_at DATETIME);"
# Redmine module
sqlite3 redmine.sqlite "CREATE TABLE api_keys ( matrix_user VARCHAR(100), api_key VARCHAR(100), stored_at DATETIME);"
sqlite3 redmine.sqlite "CREATE TABLE auth_requests (id VARCHAR(40), matrix_user VARCHAR(100), room_id VARCHAR(100), requested_at DATETIME);"
# Bitmessage module
sqlite3 bitmessage.sqlite "CREATE TABLE bm_rooms ( room VARCHAR(100) PRIMARY KEY, bm_id VARCHAR(100), active INT(1) );"
# Kanban module
sqlite3 kanban.sqlite "CREATE TABLE auth_requests (id VARCHAR(40), matrix_user VARCHAR(100), room_id VARCHAR(100), requested_at DATETIME);"
sqlite3 kanban.sqlite "CREATE TABLE api_keys ( matrix_user VARCHAR(100), domain VARCHAR(50), api_key VARCHAR(100), stored_at DATETIME );"
sqlite3 kanban.sqlite "CREATE TABLE followed_boards ( matrix_user VARCHAR(100), room_id VARCHAR(100), board_id VARCHAR(100), last_check DATETIME, stored_at DATETIME );"
# Webhook module
sqlite3 webhook.sqlite "CREATE TABLE admin_requests (id VARCHAR(32) PRIMARY KEY, matrix_user VARCHAR(100), room_id VARCHAR(100), room_name VARCHAR(255), type VARCHAR(10), valid_until DATETIME, requested_at DATETIME );"
sqlite3 webhook.sqlite "CREATE TABLE webhooks (id VARCHAR(32) PRIMARY KEY, room_id VARCHAR(100), name VARCHAR(255), template VARCHAR(2000), active BOOLEAN, added_by VARCHAR(100), added_at DATETIME, last_modified_by VARCHAR(100), last_modified_at DATETIME, last_triggered DATETIME );"
# Wunderlist module
sqlite3 wunderlist.sqlite "CREATE TABLE auth_requests (id VARCHAR(32), matrix_user VARCHAR(255), requested_at DATETIME , secret_key VARCHAR(32), room_id VARCHAR(100));"
sqlite3 wunderlist.sqlite "CREATE TABLE auth_tokens (matrix_user VARCHAR(255), auth_token VARCHAR(255), obtained_at DATETIME);"
sqlite3 wunderlist.sqlite "CREATE TABLE monitors ( matrix_room VARCHAR(225), matrix_user VARCHAR(255), list_id INTEGER, webhook_id INTEGER , secret_key VARCHAR(100), list_title VARCHAR(200));"