Something went wrong. Try again.
A one-stop-shop capsuleer manager for EVE Online pod.aaronmallen.dev
Something went wrong. Try again.
542 B · 16 lines
SQL
at main
1234567891011121314151617CREATE VIEW IF NOT EXISTS mail_unified ASSELECT m.character_id AS character_id, m.mail_id AS mail_id, m.from_id AS from_id, m.from_name AS from_name, m.subject AS subject, m.timestamp AS timestamp, m.is_read AS is_read, m.has_attachment AS has_attachment, m.important AS important, m.from_corp AS from_corp, m.from_system AS from_system, b.body AS bodyFROM character_mail mJOIN character_mail_body b ON b.character_id = m.character_id AND b.mail_id = m.mail_id;