1 files changed, 16 insertions, 0 deletions
diff --git a/dedup/schema.py b/dedup/schema.py
new file mode 100644
index 0000000..569408f
--- /dev/null
+++ b/dedup/schema.py
@@ -0,0 +1,16 @@
+import sqlalchemy
+
+metadata = sqlalchemy.MetaData()
+
+package = sqlalchemy.Table("package", metadata,
+        sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True),
+        sqlalchemy.Column('name', sqlalchemy.Text, unique=True),
+        sqlalchemy.Column('version', sqlalchemy.Text),
+        sqlalchemy.Column('architecture', sqlalchemy.Text),
+        sqlalchemy.Column('source', sqlalchemy.Text))
+
+content = sqlalchemy.Table("content", metadata,
+        sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
+        sqlalchemy.Column("pid", None, sqlalchemy.ForeignKey("package.id")),
+        sqlalchemy.Column("filename", sqlalchemy.Text),
+        sqlalchemy.Column("size", sqlalchemy.Integer))