From 341176dcbf876e446fe34626908e0136c9cedd74 Mon Sep 17 00:00:00 2001 From: Loic Baron Date: Tue, 22 Jul 2014 14:47:53 +0200 Subject: [PATCH] Django Migrate sqlite models for pending tables: portal_institution, portal_pendinguser, portal_pendingauthority, portal_pendingslice --- portal/migrations/0009_initial.py | 141 ++++++++++++++++++++++++++++++ 1 file changed, 141 insertions(+) create mode 100644 portal/migrations/0009_initial.py diff --git a/portal/migrations/0009_initial.py b/portal/migrations/0009_initial.py new file mode 100644 index 00000000..4e7e20a5 --- /dev/null +++ b/portal/migrations/0009_initial.py @@ -0,0 +1,141 @@ +# -*- coding: utf-8 -*- +import datetime +from south.db import db +from south.v2 import SchemaMigration +from django.db import models + + +class Migration(SchemaMigration): + + def forwards(self, orm): + # Adding model 'Institution' + db.create_table(u'portal_institution', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('name', self.gf('django.db.models.fields.TextField')()), + )) + db.send_create_signal(u'portal', ['Institution']) + + # Adding model 'PendingUser' + db.create_table(u'portal_pendinguser', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('first_name', self.gf('django.db.models.fields.TextField')()), + ('last_name', self.gf('django.db.models.fields.TextField')()), + ('email', self.gf('django.db.models.fields.EmailField')(max_length=75)), + ('password', self.gf('django.db.models.fields.TextField')()), + ('user_hrn', self.gf('django.db.models.fields.TextField')()), + ('public_key', self.gf('django.db.models.fields.TextField')()), + ('private_key', self.gf('django.db.models.fields.TextField')()), + ('authority_hrn', self.gf('django.db.models.fields.TextField')()), + ('login', self.gf('django.db.models.fields.TextField')()), + ('pi', self.gf('django.db.models.fields.TextField')()), + ('email_hash', self.gf('django.db.models.fields.TextField')()), + ('status', self.gf('django.db.models.fields.TextField')()), + ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + )) + db.send_create_signal(u'portal', ['PendingUser']) + + # Adding model 'PendingAuthority' + db.create_table(u'portal_pendingauthority', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('site_name', self.gf('django.db.models.fields.TextField')()), + ('site_authority', self.gf('django.db.models.fields.TextField')()), + ('site_abbreviated_name', self.gf('django.db.models.fields.TextField')()), + ('site_url', self.gf('django.db.models.fields.TextField')()), + ('site_latitude', self.gf('django.db.models.fields.TextField')()), + ('site_longitude', self.gf('django.db.models.fields.TextField')()), + ('address_line1', self.gf('django.db.models.fields.TextField')()), + ('address_line2', self.gf('django.db.models.fields.TextField')()), + ('address_line3', self.gf('django.db.models.fields.TextField')()), + ('address_city', self.gf('django.db.models.fields.TextField')()), + ('address_postalcode', self.gf('django.db.models.fields.TextField')()), + ('address_state', self.gf('django.db.models.fields.TextField')()), + ('address_country', self.gf('django.db.models.fields.TextField')()), + ('authority_hrn', self.gf('django.db.models.fields.TextField')()), + ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + )) + db.send_create_signal(u'portal', ['PendingAuthority']) + + # Adding model 'PendingSlice' + db.create_table(u'portal_pendingslice', ( + (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), + ('slice_name', self.gf('django.db.models.fields.TextField')()), + ('user_hrn', self.gf('django.db.models.fields.TextField')()), + ('authority_hrn', self.gf('django.db.models.fields.TextField')(null=True)), + ('number_of_nodes', self.gf('django.db.models.fields.TextField')(default=0)), + ('type_of_nodes', self.gf('django.db.models.fields.TextField')(default='NA')), + ('purpose', self.gf('django.db.models.fields.TextField')(default='NA')), + ('created', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), + )) + db.send_create_signal(u'portal', ['PendingSlice']) + + + def backwards(self, orm): + # Deleting model 'Institution' + db.delete_table(u'portal_institution') + + # Deleting model 'PendingUser' + db.delete_table(u'portal_pendinguser') + + # Deleting model 'PendingAuthority' + db.delete_table(u'portal_pendingauthority') + + # Deleting model 'PendingSlice' + db.delete_table(u'portal_pendingslice') + + + models = { + u'portal.institution': { + 'Meta': {'object_name': 'Institution'}, + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'name': ('django.db.models.fields.TextField', [], {}) + }, + u'portal.pendingauthority': { + 'Meta': {'object_name': 'PendingAuthority'}, + 'address_city': ('django.db.models.fields.TextField', [], {}), + 'address_country': ('django.db.models.fields.TextField', [], {}), + 'address_line1': ('django.db.models.fields.TextField', [], {}), + 'address_line2': ('django.db.models.fields.TextField', [], {}), + 'address_line3': ('django.db.models.fields.TextField', [], {}), + 'address_postalcode': ('django.db.models.fields.TextField', [], {}), + 'address_state': ('django.db.models.fields.TextField', [], {}), + 'authority_hrn': ('django.db.models.fields.TextField', [], {}), + 'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'site_abbreviated_name': ('django.db.models.fields.TextField', [], {}), + 'site_authority': ('django.db.models.fields.TextField', [], {}), + 'site_latitude': ('django.db.models.fields.TextField', [], {}), + 'site_longitude': ('django.db.models.fields.TextField', [], {}), + 'site_name': ('django.db.models.fields.TextField', [], {}), + 'site_url': ('django.db.models.fields.TextField', [], {}) + }, + u'portal.pendingslice': { + 'Meta': {'object_name': 'PendingSlice'}, + 'authority_hrn': ('django.db.models.fields.TextField', [], {'null': 'True'}), + 'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'number_of_nodes': ('django.db.models.fields.TextField', [], {'default': '0'}), + 'purpose': ('django.db.models.fields.TextField', [], {'default': "'NA'"}), + 'slice_name': ('django.db.models.fields.TextField', [], {}), + 'type_of_nodes': ('django.db.models.fields.TextField', [], {'default': "'NA'"}), + 'user_hrn': ('django.db.models.fields.TextField', [], {}) + }, + u'portal.pendinguser': { + 'Meta': {'object_name': 'PendingUser'}, + 'authority_hrn': ('django.db.models.fields.TextField', [], {}), + 'created': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), + 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75'}), + 'email_hash': ('django.db.models.fields.TextField', [], {}), + 'first_name': ('django.db.models.fields.TextField', [], {}), + u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), + 'last_name': ('django.db.models.fields.TextField', [], {}), + 'login': ('django.db.models.fields.TextField', [], {}), + 'password': ('django.db.models.fields.TextField', [], {}), + 'pi': ('django.db.models.fields.TextField', [], {}), + 'private_key': ('django.db.models.fields.TextField', [], {}), + 'public_key': ('django.db.models.fields.TextField', [], {}), + 'status': ('django.db.models.fields.TextField', [], {}), + 'user_hrn': ('django.db.models.fields.TextField', [], {}) + } + } + + complete_apps = ['portal'] \ No newline at end of file -- 2.43.0