sroberts / malwarehouse

A warehouse for your malware
http://sroberts.github.com/malwarehouse/
Other
131 stars 43 forks source link

Implement SQLite #11

Closed sroberts closed 11 years ago

sroberts commented 11 years ago

Basic schema:

# Setup Database
__tablename__ = malwarehouse_index

meta_id = Column(Integer, primary_key=True)
meta_datetime = Column(String)

basic_filename = Column(String)
basic_size = Column(Integer)

mimetype = Column(String)
tags = Column(String)

hash_md5 = Column(String)
hash_sha256 = Column(String)
hash_ssdeep = Column(String)

user_source = Column(String)
user_notes = Column(String)

A good ideal longterm for supporting larger datasets, but it's a lot to bite off now with all the other restructuring.