docker-compose.yml

docker-compose.yml · 288 B · YAML Raw

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.table.sql · 500 B · MySQL Raw

1	-- S3DigitalTwin.TestPattern definition
2	CREATE DATABASE `S3DigitalTwin` /!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci /;
3
4	CREATE TABLE `S3DigitalTwin.TestPattern` (
5	`ID` int(11) NOT NULL AUTO_INCREMENT,
6	`ChunkID` int(11) NOT NULL,
7	`coordX` double DEFAULT NULL,
8	`coordY` double DEFAULT NULL,
9	`coordZ` double DEFAULT NULL,
10	`gripperOpen` double DEFAULT NULL,
11	PRIMARY KEY (`ID`)
12	) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;