2 files changed, 120 insertions, 0 deletions
diff --git a/rpki/pubdb/migrations/0001_initial.py b/rpki/pubdb/migrations/0001_initial.py
new file mode 100644
index 00000000..c796d020
--- /dev/null
+++ b/rpki/pubdb/migrations/0001_initial.py
@@ -0,0 +1,120 @@
+# -*- coding: utf-8 -*-
+from south.utils import datetime_utils as datetime
+from south.db import dbs
+from south.v2 import SchemaMigration
+from django.db import models
+
+db = dbs["pubdb"]
+
+class Migration(SchemaMigration):
+
+    def forwards(self, orm):
+        # Adding model 'Client'
+        db.create_table(u'pubdb_client', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('client_handle', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)),
+            ('base_uri', self.gf('django.db.models.fields.TextField')()),
+            ('bpki_cert', self.gf('rpki.fields.BlobField')(default=None, blank=True)),
+            ('bpki_glue', self.gf('rpki.fields.BlobField')(default=None, null=True, blank=True)),
+            ('last_cms_timestamp', self.gf('rpki.fields.SundialField')(null=True, blank=True)),
+        ))
+        db.send_create_signal(u'pubdb', ['Client'])
+
+        # Adding model 'Session'
+        db.create_table(u'pubdb_session', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('uuid', self.gf('django.db.models.fields.CharField')(unique=True, max_length=36)),
+            ('serial', self.gf('django.db.models.fields.BigIntegerField')()),
+            ('snapshot', self.gf('django.db.models.fields.TextField')(blank=True)),
+            ('hash', self.gf('django.db.models.fields.CharField')(max_length=64, blank=True)),
+        ))
+        db.send_create_signal(u'pubdb', ['Session'])
+
+        # Adding model 'Delta'
+        db.create_table(u'pubdb_delta', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('serial', self.gf('django.db.models.fields.BigIntegerField')()),
+            ('xml', self.gf('django.db.models.fields.TextField')()),
+            ('hash', self.gf('django.db.models.fields.CharField')(max_length=64)),
+            ('expires', self.gf('rpki.fields.SundialField')()),
+            ('session', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['pubdb.Session'])),
+        ))
+        db.send_create_signal(u'pubdb', ['Delta'])
+
+        # Adding model 'PublishedObject'
+        db.create_table(u'pubdb_publishedobject', (
+            (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
+            ('uri', self.gf('django.db.models.fields.CharField')(max_length=255)),
+            ('der', self.gf('rpki.fields.BlobField')(default=None, blank=True)),
+            ('hash', self.gf('django.db.models.fields.CharField')(max_length=64)),
+            ('client', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['pubdb.Client'])),
+            ('session', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['pubdb.Session'])),
+        ))
+        db.send_create_signal(u'pubdb', ['PublishedObject'])
+
+        # Adding unique constraint on 'PublishedObject', fields ['session', 'hash']
+        db.create_unique(u'pubdb_publishedobject', ['session_id', 'hash'])
+
+        # Adding unique constraint on 'PublishedObject', fields ['session', 'uri']
+        db.create_unique(u'pubdb_publishedobject', ['session_id', 'uri'])
+
+
+    def backwards(self, orm):
+        # Removing unique constraint on 'PublishedObject', fields ['session', 'uri']
+        db.delete_unique(u'pubdb_publishedobject', ['session_id', 'uri'])
+
+        # Removing unique constraint on 'PublishedObject', fields ['session', 'hash']
+        db.delete_unique(u'pubdb_publishedobject', ['session_id', 'hash'])
+
+        # Deleting model 'Client'
+        db.delete_table(u'pubdb_client')
+
+        # Deleting model 'Session'
+        db.delete_table(u'pubdb_session')
+
+        # Deleting model 'Delta'
+        db.delete_table(u'pubdb_delta')
+
+        # Deleting model 'PublishedObject'
+        db.delete_table(u'pubdb_publishedobject')
+
+
+    models = {
+        u'pubdb.client': {
+            'Meta': {'object_name': 'Client'},
+            'base_uri': ('django.db.models.fields.TextField', [], {}),
+            'bpki_cert': ('rpki.fields.BlobField', [], {'default': 'None', 'blank': 'True'}),
+            'bpki_glue': ('rpki.fields.BlobField', [], {'default': 'None', 'null': 'True', 'blank': 'True'}),
+            'client_handle': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'last_cms_timestamp': ('rpki.fields.SundialField', [], {'null': 'True', 'blank': 'True'})
+        },
+        u'pubdb.delta': {
+            'Meta': {'object_name': 'Delta'},
+            'expires': ('rpki.fields.SundialField', [], {}),
+            'hash': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'serial': ('django.db.models.fields.BigIntegerField', [], {}),
+            'session': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['pubdb.Session']"}),
+            'xml': ('django.db.models.fields.TextField', [], {})
+        },
+        u'pubdb.publishedobject': {
+            'Meta': {'unique_together': "((u'session', u'hash'), (u'session', u'uri'))", 'object_name': 'PublishedObject'},
+            'client': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['pubdb.Client']"}),
+            'der': ('rpki.fields.BlobField', [], {'default': 'None', 'blank': 'True'}),
+            'hash': ('django.db.models.fields.CharField', [], {'max_length': '64'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'session': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['pubdb.Session']"}),
+            'uri': ('django.db.models.fields.CharField', [], {'max_length': '255'})
+        },
+        u'pubdb.session': {
+            'Meta': {'object_name': 'Session'},
+            'hash': ('django.db.models.fields.CharField', [], {'max_length': '64', 'blank': 'True'}),
+            u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
+            'serial': ('django.db.models.fields.BigIntegerField', [], {}),
+            'snapshot': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
+            'uuid': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '36'})
+        }
+    }
+
+    complete_apps = ['pubdb']
diff --git a/rpki/pubdb/migrations/__init__.py b/rpki/pubdb/migrations/__init__.py
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/rpki/pubdb/migrations/__init__.py