# `flyway_schema_history`


- **Engine:** InnoDB
- **Collation:** utf8mb3_general_ci

## Columns

| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | `installed_rank` | `int` | NO | PRI |  |  |  |
| 2 | `version` | `varchar(50)` | YES |  |  |  |  |
| 3 | `description` | `varchar(200)` | NO |  |  |  |  |
| 4 | `type` | `varchar(20)` | NO |  |  |  |  |
| 5 | `script` | `varchar(1000)` | NO |  |  |  |  |
| 6 | `checksum` | `int` | YES |  |  |  |  |
| 7 | `installed_by` | `varchar(100)` | NO |  |  |  |  |
| 8 | `installed_on` | `timestamp` | NO |  | CURRENT_TIMESTAMP | DEFAULT_GENERATED |  |
| 9 | `execution_time` | `int` | NO |  |  |  |  |
| 10 | `success` | `tinyint(1)` | NO | MUL |  |  |  |

## Indexes

| Name | Unique | Type | Columns |
|---|---|---|---|
| `flyway_schema_history_s_idx` |  | BTREE | `success` |
| `PRIMARY` | ✓ | BTREE | `installed_rank` |

## Narrative

_No human-written narrative yet — when this table is exercised by a [vertical slice](../../slices/index.md), link from there back to this page._
