From de99d6c28b6cdb8c72f79df91669598ded432a6d Mon Sep 17 00:00:00 2001 From: Jacob Casper Date: Fri, 3 Apr 2020 00:46:02 -0500 Subject: [PATCH] Create database during setup --- mercuryms.service | 1 + migrations/001-create_media.sql | 5 +++++ migrations/002-create_sent_media.sql | 5 +++++ setup.sh | 2 ++ 4 files changed, 13 insertions(+) create mode 100644 migrations/001-create_media.sql create mode 100644 migrations/002-create_sent_media.sql diff --git a/mercuryms.service b/mercuryms.service index 50044a8..8fe1143 100644 --- a/mercuryms.service +++ b/mercuryms.service @@ -7,6 +7,7 @@ Type=simple User=mercuryms Group=mercuryms WorkingDirectory=/usr/share/mercuryms +StandardOutput=syslog ExecStart=/opt/mercuryms/bin/python /opt/mercuryms/mms-download.py Environment="MERCURYMS_PORT=9092" diff --git a/migrations/001-create_media.sql b/migrations/001-create_media.sql new file mode 100644 index 0000000..bb9f029 --- /dev/null +++ b/migrations/001-create_media.sql @@ -0,0 +1,5 @@ +CREATE TABLE MEDIA ( + ID INTEGER PRIMARY KEY AUTOINCREMENT, + PHONE_NUMBER TEXT NOT NULL, + URI TEXT NOT NULL +); diff --git a/migrations/002-create_sent_media.sql b/migrations/002-create_sent_media.sql new file mode 100644 index 0000000..85f81cf --- /dev/null +++ b/migrations/002-create_sent_media.sql @@ -0,0 +1,5 @@ +CREATE TABLE SENT_MEDIA ( + ID INTEGER PRIMARY KEY AUTOINCREMENT, + MEDIA_ID INTEGER NOT NULL, + FOREIGN KEY(MEDIA_ID) REFERENCES MEDIA(ID) +); diff --git a/setup.sh b/setup.sh index a4698ad..f1a3474 100755 --- a/setup.sh +++ b/setup.sh @@ -5,3 +5,5 @@ groupadd mercuryms useradd -g mercuryms -d /usr/share/mercuryms -s $(which nologin) mercuryms chown mercuryms:mercuryms /usr/share/mercuryms chmod 700 /usr/share/mercuryms +sqlite3 /usr/share/mercuryms/mercuryms.sqlite "$(cat migrations/*)" +chown mercuryms:mercuryms /usr/share/mercuryms/mercuryms.sqlite -- 2.20.1