Sjoerd / docker-compose.yml

# Use root/example as user/password credentials version: '3.1' services: db: image: mariadb restart: always ports: - 3306:3306 environment: MARIADB_ROOT_PASSWORD: Password123! adminer: image: adminer restart: always ports: - 8080:8080

CREATE DATABASE `S3DigitalTwin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */; CREATE TABLE TestPattern { ID int PRIMARY KEY AUTO_INCREMENT, ChunkID int NOT NULL, coordX DOUBLE, coordY DOUBLE, coordZ DOUBLE, gripperOpen bool }

-- S3DigitalTwin.TestPattern definition CREATE TABLE `TestPattern` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ChunkID` int(11) NOT NULL, `coordX` double DEFAULT NULL, `coordY` double DEFAULT NULL, `coordZ` double DEFAULT NULL, `gripperOpen` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;