diff options
Diffstat (limited to 'buildbot_gentoo_ci/db/model.py')
-rw-r--r-- | buildbot_gentoo_ci/db/model.py | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/buildbot_gentoo_ci/db/model.py b/buildbot_gentoo_ci/db/model.py index 4373ebb..6e13ad7 100644 --- a/buildbot_gentoo_ci/db/model.py +++ b/buildbot_gentoo_ci/db/model.py @@ -287,6 +287,34 @@ class Model(base.DBConnectorComponent): sa.Column('deleted_at', sa.Integer, nullable=True), ) + emails = sautils.Table( + "emails", metadata, + # unique uuid per keyword + sa.Column('id', sa.Integer, primary_key=True), + sa.Column('email', sa.String(255), nullable=False), + ) + + packages_emails = sautils.Table( + "packages_emails", metadata, + # unique uuid per keyword + sa.Column('id', sa.Integer, primary_key=True), + sa.Column('package_uuid', sa.String(36), + sa.ForeignKey('packages.uuid', ondelete='CASCADE')), + sa.Column('email_id', sa.Integer, + sa.ForeignKey('emails.id', ondelete='CASCADE')), + sa.Column('mail_type', sa.Enum('project', 'person', 'unknown',), nullable=False, default='unknown'), + sa.Column('proxied', sa.Enum('yes', 'no', 'proxy',), nullable=False, default='no'), + ) + + packages_metadata = sautils.Table( + "packages_metadata", metadata, + # unique uuid per keyword + sa.Column('id', sa.Integer, primary_key=True), + sa.Column('package_uuid', sa.String(36), + sa.ForeignKey('packages.uuid', ondelete='CASCADE')), + sa.Column('sha256', sa.String(255), nullable=False, default='0'), + ) + versions = sautils.Table( "versions", metadata, sa.Column('uuid', sa.String(36), primary_key=True, |