core (memory/sqla_mapping): fix some technical debt: a first Alembic revision file is joined to migrate existing databases to new mapping. This patch: - set `nullable=False` in various places - drop legacy `message_types` table, and use `Enum` instead - use naming convention, and get rid of anonymous constraint (this is the main reason why the revision file is so long)

[Desktop Entry]
Type=Application
Name=Libervia TUI (Primitivus)
Comment=console frontend for Libervia (XMPP)
Exec=libervia-tui
Icon=org.libervia.LiberviaTUI
Categories=Network;InstantMessaging;Chat;FileTransfer;RemoteAccess;
Keywords=xmpp;chat;messaging;im;file;sharing;communication;jabber;social;network;decentralization;console;