Revize d815887f

Docker compose file refactor and rename config file

config.sql

@@ +1 @@
+create or replace view artifactView as select wi.name, wi.description, wi.created, wi.url, a.id as id, a.artifactClass, a.mimeType, a.size, p.id as authorId, p.name as authorName, p.projectId from work_item wi join artifact a on a.id = wi.id join personView p on p.id = wi.authorId;
+SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

docker-compose.yml

@@ -12 +12 @@
     restart: always
     volumes:
       - ./db_dump.sql:/usr/local/etc/db_dump.sql
+      - ./config.sql:/usr/local/etc/config.sql
 
 
   #service 2: definition of phpMyAdmin
@@ -21 +22 @@
     ports:
       - "8082:80"
     restart: always
-
     depends_on:
       - db
     environment:
@@ -45 +45 @@
     depends_on:
       - db
     environment:
-      SPRING_DATASOURCE_URL: jdbc:mysql://mysql-db:3306/spade?createDatabaseIfNotExist=true
+      SPRING_DATASOURCE_URL: jdbc:mysql://mysql-db:3306/spade
       SPRING_DATASOURCE_USERNAME: root
       SPRING_DATASOURCE_PASSWORD: testtest

update_views.sql

@@ -1 @@
-create or replace view artifactView as select wi.name, wi.description, wi.created, wi.url, a.id as id, a.artifactClass, a.mimeType, a.size, p.id as authorId, p.name as authorName, p.projectId from work_item wi join artifact a on a.id = wi.id join personView p on p.id = wi.authorId;
-SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));