3 files changed, 32 insertions, 0 deletions

diff --git a/src/mailman_pgp/model/__init__.py b/src/mailman_pgp/model/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/src/mailman_pgp/model/__init__.py
diff --git a/src/mailman_pgp/model/base.py b/src/mailman_pgp/model/base.py
new file mode 100644
index 0000000..e25407f
--- /dev/null
+++ b/src/mailman_pgp/model/base.py
@@ -0,0 +1,8 @@
+""""""
+
+from public import public
+from sqlalchemy.ext.declarative import declarative_base
+
+
+Base = declarative_base()
+public(Base=Base)
diff --git a/src/mailman_pgp/model/list.py b/src/mailman_pgp/model/list.py
new file mode 100644
index 0000000..f781a9a
--- /dev/null
+++ b/src/mailman_pgp/model/list.py
@@ -0,0 +1,24 @@
+""""""
+
+from mailman.database.types import Enum, SAUnicode
+from mailman.interfaces.action import Action
+from public import public
+from sqlalchemy import Boolean, Column, Integer
+
+from mailman_pgp.model.base import Base
+
+
+@public
+class EncryptedMailingList(Base):
+    __tablename__ = 'encrypted_lists'
+
+    id = Column(Integer, primary_key=True)
+    list_id = Column(SAUnicode)
+    key_fingerprint = Column(SAUnicode)
+    unsigned_msg_action = Column(Enum(Action))
+    nonencrypted_msg_action = Column(Enum(Action))
+    strip_original_signature = Column(Boolean)
+    sign_outgoing = Column(Boolean)
+
+    def __init__(self, mlist):
+        self.list_id = mlist.list_id