Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.
Obě strany předchozí revize Předchozí verze | Následující verze Obě strany příští revize | ||
cs:tech:idp:mariadb:new [2020/03/26 21:17] jan.oppolzer@cesnet.cz [Databáze] |
cs:tech:idp:mariadb:new [2020/03/27 08:45] jan.oppolzer@cesnet.cz [Databáze] |
||
---|---|---|---|
Řádek 94: | Řádek 94: | ||
<code mysql> | <code mysql> | ||
- | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
- | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
- | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
- | | localEntity | varchar(255) | NO | PRI | NULL | | | + | | localEntity | varchar(255) | NO | PRI | NULL | | |
- | | peerEntity | varchar(255) | NO | PRI | NULL | | | + | | peerEntity | varchar(255) | NO | PRI | NULL | | |
- | | principalName | varchar(255) | NO | | | | | + | | principalName | varchar(255) | NO | | | | |
- | | localId | varchar(255) | NO | | NULL | | | + | | localId | varchar(255) | NO | | NULL | | |
- | | persistentId | varchar(50) | NO | PRI | NULL | | | + | | persistentId | varchar(50) | NO | PRI | NULL | | |
- | | peerProvidedId | varchar(255) | YES | | NULL | | | + | | peerProvidedId | varchar(255) | YES | | NULL | | |
- | | creationDate | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | | + | | creationDate | timestamp | NO | | current_timestamp() | on update current_timestamp() | |
- | | deactivationDate | timestamp | YES | | NULL | | | + | | deactivationDate | timestamp | YES | | NULL | | |
- | +------------------+--------------+------+-----+-------------------+-----------------------------+ | + | +------------------+--------------+------+-----+---------------------+-------------------------------+ |
- | 8 rows in set (0.00 sec) | + | 8 rows in set (0.002 sec) |
- | + | ||
- | + | ||
- | FIXME | + | |
+---------+--------------+------+-----+---------+-------+ | +---------+--------------+------+-----+---------+-------+ | ||
Řádek 121: | Řádek 117: | ||
| version | bigint(20) | NO | | NULL | | | | version | bigint(20) | NO | | NULL | | | ||
+---------+--------------+------+-----+---------+-------+ | +---------+--------------+------+-----+---------+-------+ | ||
- | 5 rows in set (0.001 sec) | + | 5 rows in set (0.003 sec) |
</code> | </code> | ||