docker-compose.yml
· 288 B · YAML
Raw
# 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
| 1 | # Use root/example as user/password credentials |
| 2 | version: '3.1' |
| 3 | |
| 4 | services: |
| 5 | |
| 6 | db: |
| 7 | image: mariadb |
| 8 | restart: always |
| 9 | ports: |
| 10 | - 3306:3306 |
| 11 | environment: |
| 12 | MARIADB_ROOT_PASSWORD: Password123! |
| 13 | |
| 14 | adminer: |
| 15 | image: adminer |
| 16 | restart: always |
| 17 | ports: |
| 18 | - 8080:8080 |
| 19 |
schema.sql
· 282 B · MySQL
Raw
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
}
| 1 | CREATE DATABASE `S3DigitalTwin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */; |
| 2 | CREATE TABLE TestPattern { |
| 3 | |
| 4 | ID int PRIMARY KEY AUTO_INCREMENT, |
| 5 | ChunkID int NOT NULL, |
| 6 | |
| 7 | coordX DOUBLE, |
| 8 | coordY DOUBLE, |
| 9 | coordZ DOUBLE, |
| 10 | |
| 11 | gripperOpen bool |
| 12 | |
| 13 | } |
| 14 | |
| 15 |