primitems†[edit]
MariaDB [jogrid_db]> show columns from primitems;
+---------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+---------+-------+
| invType | int(11) | YES | | NULL | |
| assetType | int(11) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| description | varchar(255) | YES | | NULL | |
| creationDate | bigint(20) | YES | | NULL | |
| nextPermissions | int(11) | YES | | NULL | |
| currentPermissions | int(11) | YES | | NULL | |
| basePermissions | int(11) | YES | | NULL | |
| everyonePermissions | int(11) | YES | | NULL | |
| groupPermissions | int(11) | YES | | NULL | |
| flags | int(11) | NO | | 0 | |
| itemID | char(36) | NO | PRI | | |
| primID | char(36) | YES | MUL | NULL | |
| assetID | char(36) | YES | | NULL | |
| parentFolderID | char(36) | YES | | NULL | |
| CreatorID | varchar(255) | NO | | | |
| ownerID | char(36) | YES | | NULL | |
| groupID | char(36) | YES | | NULL | |
| lastOwnerID | char(36) | YES | | NULL | |
+---------------------+--------------+------+-----+---------+-------+
19 rows in set (0.00 sec)