Sjoerd revised this gist 1 year ago. Go to revision
2 files changed, 3 insertions, 16 deletions
schema.sql (file deleted)
| @@ -1,14 +0,0 @@ | |||
| 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 | - | ||
schema.table.sql
| @@ -1,11 +1,12 @@ | |||
| 1 | 1 | -- S3DigitalTwin.TestPattern definition | |
| 2 | + | CREATE DATABASE `S3DigitalTwin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */; | |
| 2 | 3 | ||
| 3 | - | CREATE TABLE `TestPattern` ( | |
| 4 | + | CREATE TABLE `S3DigitalTwin.TestPattern` ( | |
| 4 | 5 | `ID` int(11) NOT NULL AUTO_INCREMENT, | |
| 5 | 6 | `ChunkID` int(11) NOT NULL, | |
| 6 | 7 | `coordX` double DEFAULT NULL, | |
| 7 | 8 | `coordY` double DEFAULT NULL, | |
| 8 | 9 | `coordZ` double DEFAULT NULL, | |
| 9 | - | `gripperOpen` tinyint(1) DEFAULT NULL, | |
| 10 | + | `gripperOpen` double DEFAULT NULL, | |
| 10 | 11 | PRIMARY KEY (`ID`) | |
| 11 | 12 | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; | |
Sjoerd revised this gist 1 year ago. Go to revision
1 file changed, 11 insertions
schema.table.sql(file created)
| @@ -0,0 +1,11 @@ | |||
| 1 | + | -- S3DigitalTwin.TestPattern definition | |
| 2 | + | ||
| 3 | + | CREATE TABLE `TestPattern` ( | |
| 4 | + | `ID` int(11) NOT NULL AUTO_INCREMENT, | |
| 5 | + | `ChunkID` int(11) NOT NULL, | |
| 6 | + | `coordX` double DEFAULT NULL, | |
| 7 | + | `coordY` double DEFAULT NULL, | |
| 8 | + | `coordZ` double DEFAULT NULL, | |
| 9 | + | `gripperOpen` tinyint(1) DEFAULT NULL, | |
| 10 | + | PRIMARY KEY (`ID`) | |
| 11 | + | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci; | |
Sjoerd revised this gist 1 year ago. Go to revision
2 files changed, 32 insertions
docker-compose.yml(file created)
| @@ -0,0 +1,18 @@ | |||
| 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 | |
schema.sql(file created)
| @@ -0,0 +1,14 @@ | |||
| 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 | + | ||