11# encoding: utf-8
2+ import datetime
23from south .db import db
34from south .v2 import SchemaMigration
45from django .db import models
56
6-
77class Migration (SchemaMigration ):
88
99 def forwards (self , orm ):
10-
10+
1111 # Adding model 'NomCom'
1212 db .create_table ('nomcom_nomcom' , (
1313 ('id' , self .gf ('django.db.models.fields.AutoField' )(primary_key = True )),
@@ -34,6 +34,7 @@ def forwards(self, orm):
3434 db .create_table ('nomcom_nominee' , (
3535 ('id' , self .gf ('django.db.models.fields.AutoField' )(primary_key = True )),
3636 ('email' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['person.Email' ])),
37+ ('duplicated' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['nomcom.Nominee' ], null = True , blank = True )),
3738 ))
3839 db .send_create_signal ('nomcom' , ['Nominee' ])
3940
@@ -43,13 +44,21 @@ def forwards(self, orm):
4344 ('position' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['nomcom.Position' ])),
4445 ('nominee' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['nomcom.Nominee' ])),
4546 ('state' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['name.NomineePositionState' ])),
46- ('questionnaire ' , self .gf ('django.db.models.fields.related.ForeignKey ' )(blank = True , related_name = 'questionnaire' , null = True , to = orm [ 'nomcom.Feedback' ] )),
47+ ('time ' , self .gf ('django.db.models.fields.DateTimeField ' )(auto_now_add = True , blank = True )),
4748 ))
4849 db .send_create_signal ('nomcom' , ['NomineePosition' ])
4950
5051 # Adding unique constraint on 'NomineePosition', fields ['position', 'nominee']
5152 db .create_unique ('nomcom_nomineeposition' , ['position_id' , 'nominee_id' ])
5253
54+ # Adding M2M table for field questionnaires on 'NomineePosition'
55+ db .create_table ('nomcom_nomineeposition_questionnaires' , (
56+ ('id' , models .AutoField (verbose_name = 'ID' , primary_key = True , auto_created = True )),
57+ ('nomineeposition' , models .ForeignKey (orm ['nomcom.nomineeposition' ], null = False )),
58+ ('feedback' , models .ForeignKey (orm ['nomcom.feedback' ], null = False ))
59+ ))
60+ db .create_unique ('nomcom_nomineeposition_questionnaires' , ['nomineeposition_id' , 'feedback_id' ])
61+
5362 # Adding M2M table for field feedback on 'NomineePosition'
5463 db .create_table ('nomcom_nomineeposition_feedback' , (
5564 ('id' , models .AutoField (verbose_name = 'ID' , primary_key = True , auto_created = True )),
@@ -75,7 +84,7 @@ def forwards(self, orm):
7584 # Adding model 'Feedback'
7685 db .create_table ('nomcom_feedback' , (
7786 ('id' , self .gf ('django.db.models.fields.AutoField' )(primary_key = True )),
78- ('author' , self .gf ('django.db.models.fields.EmailField' )(max_length = 75 )),
87+ ('author' , self .gf ('django.db.models.fields.EmailField' )(max_length = 75 , blank = True )),
7988 ('position' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['nomcom.Position' ])),
8089 ('nominee' , self .gf ('django.db.models.fields.related.ForeignKey' )(to = orm ['nomcom.Nominee' ])),
8190 ('comments' , self .gf ('ietf.nomcom.fields.EncryptedTextField' )()),
@@ -84,8 +93,9 @@ def forwards(self, orm):
8493 ))
8594 db .send_create_signal ('nomcom' , ['Feedback' ])
8695
87- def backwards (self , orm ):
8896
97+ def backwards (self , orm ):
98+
8999 # Removing unique constraint on 'NomineePosition', fields ['position', 'nominee']
90100 db .delete_unique ('nomcom_nomineeposition' , ['position_id' , 'nominee_id' ])
91101
@@ -101,6 +111,9 @@ def backwards(self, orm):
101111 # Deleting model 'NomineePosition'
102112 db .delete_table ('nomcom_nomineeposition' )
103113
114+ # Removing M2M table for field questionnaires on 'NomineePosition'
115+ db .delete_table ('nomcom_nomineeposition_questionnaires' )
116+
104117 # Removing M2M table for field feedback on 'NomineePosition'
105118 db .delete_table ('nomcom_nomineeposition_feedback' )
106119
@@ -110,6 +123,7 @@ def backwards(self, orm):
110123 # Deleting model 'Feedback'
111124 db .delete_table ('nomcom_feedback' )
112125
126+
113127 models = {
114128 'auth.group' : {
115129 'Meta' : {'object_name' : 'Group' },
@@ -327,7 +341,7 @@ def backwards(self, orm):
327341 },
328342 'nomcom.feedback' : {
329343 'Meta' : {'object_name' : 'Feedback' },
330- 'author' : ('django.db.models.fields.EmailField' , [], {'max_length' : '75' }),
344+ 'author' : ('django.db.models.fields.EmailField' , [], {'max_length' : '75' , 'blank' : 'True' }),
331345 'comments' : ('ietf.nomcom.fields.EncryptedTextField' , [], {}),
332346 'id' : ('django.db.models.fields.AutoField' , [], {'primary_key' : 'True' }),
333347 'nominee' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['nomcom.Nominee']" }),
@@ -355,18 +369,20 @@ def backwards(self, orm):
355369 },
356370 'nomcom.nominee' : {
357371 'Meta' : {'object_name' : 'Nominee' },
372+ 'duplicated' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['nomcom.Nominee']" , 'null' : 'True' , 'blank' : 'True' }),
358373 'email' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['person.Email']" }),
359374 'id' : ('django.db.models.fields.AutoField' , [], {'primary_key' : 'True' }),
360- 'nomine_position ' : ('django.db.models.fields.related.ManyToManyField' , [], {'to' : "orm['nomcom.Position']" , 'through' : "orm['nomcom.NomineePosition']" , 'symmetrical' : 'False' })
375+ 'nominee_position ' : ('django.db.models.fields.related.ManyToManyField' , [], {'to' : "orm['nomcom.Position']" , 'through' : "orm['nomcom.NomineePosition']" , 'symmetrical' : 'False' })
361376 },
362377 'nomcom.nomineeposition' : {
363378 'Meta' : {'unique_together' : "(('position', 'nominee'),)" , 'object_name' : 'NomineePosition' },
364379 'feedback' : ('django.db.models.fields.related.ManyToManyField' , [], {'symmetrical' : 'False' , 'to' : "orm['nomcom.Feedback']" , 'null' : 'True' , 'blank' : 'True' }),
365380 'id' : ('django.db.models.fields.AutoField' , [], {'primary_key' : 'True' }),
366381 'nominee' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['nomcom.Nominee']" }),
367382 'position' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['nomcom.Position']" }),
368- 'questionnaire' : ('django.db.models.fields.related.ForeignKey' , [], {'blank' : 'True' , 'related_name' : "'questionnaire'" , 'null' : 'True' , 'to' : "orm['nomcom.Feedback']" }),
369- 'state' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['name.NomineePositionState']" })
383+ 'questionnaires' : ('django.db.models.fields.related.ManyToManyField' , [], {'blank' : 'True' , 'related_name' : "'questionnaires'" , 'null' : 'True' , 'symmetrical' : 'False' , 'to' : "orm['nomcom.Feedback']" }),
384+ 'state' : ('django.db.models.fields.related.ForeignKey' , [], {'to' : "orm['name.NomineePositionState']" }),
385+ 'time' : ('django.db.models.fields.DateTimeField' , [], {'auto_now_add' : 'True' , 'blank' : 'True' })
370386 },
371387 'nomcom.position' : {
372388 'Meta' : {'object_name' : 'Position' },
0 commit comments