add fields to media

1 files changed, 16 insertions, 0 deletions

diff --git a/animism-align/cli/app/sql/models/media.py b/animism-align/cli/app/sql/models/media.py
index 6b615c9..27a1498 100644
--- a/animism-align/cli/app/sql/models/media.py
+++ b/animism-align/cli/app/sql/models/media.py
@@ -13,12 +13,28 @@ class Media(Base):
   __tablename__ = 'media'
   id = Column(Integer, primary_key=True)
   type = Column(String(16, convert_unicode=True), nullable=False)
+  url = Column(String(256, convert_unicode=True), nullable=True)
+  title = Column(String(256, convert_unicode=True), nullable=True)
+  author = Column(String(256, convert_unicode=True), nullable=True)
+  pre_title = Column(String(256, convert_unicode=True), nullable=True)
+  translated_title = Column(String(256, convert_unicode=True), nullable=True)
+  date = Column(String(256, convert_unicode=True), nullable=True)
+  source = Column(String(256, convert_unicode=True), nullable=True)
+  start_ts = Column(Float, nullable=True)
   settings = Column(JSON, default={}, nullable=True)
 
   def toJSON(self):
     return {
       'id': self.id,
       'type': self.type,
+      'url': self.url,
+      'title': self.title,
+      'pre_title': self.pre_title,
+      'translated_title': self.translated_title,
+      'date': self.date,
+      'source': self.source,
+      'author': self.author,
+      'start_ts': self.start_ts,
       'settings': self.settings,
     }