View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001588 | Database Workbench v5 | MySQL Module | public | 2018-04-18 17:15 | 2018-07-09 13:45 |
| Reporter | Stephen Lappin | Assigned To | Martijn Tonies | ||
| Priority | high | Severity | feature | Reproducibility | N/A |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.4.2 | ||||
| Fixed in Version | 5.4.4 | ||||
| Summary | 0001588: Add support for InnoDB Table Encryption | ||||
| Description | In Physical Data Model for MySQL/MariaDB, support InnoDB Table Encryption with encryption clause appearing in generated DDL. For example: CREATE TABLE t1 (c1 INT) ENCRYPTION='Y'; | ||||
| Tags | No tags attached. | ||||
|
|
for example (MariaDB): CREATE TABLE accounts ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255), email VARCHAR(255)) ENGINE = InnoDB ENCRYPTED = YES ENCRYPTION_KEY_ID = 3; |
|
|
In MariaDB, this is supported for InnoDB, XtraDB and Aria storage engine. https://mariadb.com/kb/en/library/data-at-rest-encryption/ In plain MySQL, only for InnoDB. https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-04-18 17:15 | Stephen Lappin | New Issue | |
| 2018-04-18 18:15 | Stephen Lappin | Note Added: 0000458 | |
| 2018-04-20 09:35 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2018-04-20 09:35 | Martijn Tonies | Status | new => acknowledged |
| 2018-04-20 15:14 | Martijn Tonies | Note Added: 0000459 | |
| 2018-04-23 13:04 | Martijn Tonies | Status | acknowledged => assigned |
| 2018-04-23 14:00 | Martijn Tonies | Status | assigned => resolved |
| 2018-04-23 14:00 | Martijn Tonies | Fixed in Version | => 5.4.4 |
| 2018-04-23 14:00 | Martijn Tonies | Resolution | open => fixed |
| 2018-04-23 14:00 | Martijn Tonies | Category | Diagramming => MySQL Module |
| 2018-04-23 14:00 | Martijn Tonies | Summary | Add support for InnoDB Tablespace Encryption => Add support for InnoDB Table Encryption |
| 2018-04-23 14:00 | Martijn Tonies | Description Updated | |
| 2018-07-09 13:45 | Martijn Tonies | Status | resolved => closed |
