docker-compose.yml
· 288 B · YAML
Неформатований
# 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.table.sql
· 500 B · MySQL
Неформатований
-- S3DigitalTwin.TestPattern definition
CREATE DATABASE `S3DigitalTwin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */;
CREATE TABLE `S3DigitalTwin.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` double DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;
| 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; |