1 # -*- coding: utf-8 -*-
2 from south.utils import datetime_utils as datetime
3 from south.db import db
4 from south.v2 import SchemaMigration
5 from django.db import models
8 class Migration(SchemaMigration):
10 def forwards(self, orm):
11 # Removing unique constraint on 'Mark', fields ['expert', 'answer']
12 db.delete_unique(u'stage2_mark', ['expert_id', 'answer_id'])
14 # Adding model 'MarkCriterion'
15 db.create_table(u'stage2_markcriterion', (
16 (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
17 ('assignment', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['stage2.Assignment'])),
18 ('order', self.gf('django.db.models.fields.IntegerField')()),
19 ('label', self.gf('django.db.models.fields.CharField')(max_length=1024)),
20 ('max_points', self.gf('django.db.models.fields.IntegerField')()),
22 db.send_create_signal(u'stage2', ['MarkCriterion'])
24 # Adding unique constraint on 'MarkCriterion', fields ['assignment', 'order']
25 db.create_unique(u'stage2_markcriterion', ['assignment_id', 'order'])
27 # Adding field 'Mark.criterion'
28 db.add_column(u'stage2_mark', 'criterion',
29 self.gf('django.db.models.fields.related.ForeignKey')(default=0, to=orm['stage2.MarkCriterion']),
32 # Adding unique constraint on 'Mark', fields ['expert', 'criterion']
33 db.create_unique(u'stage2_mark', ['expert_id', 'criterion_id'])
36 def backwards(self, orm):
37 # Removing unique constraint on 'Mark', fields ['expert', 'criterion']
38 db.delete_unique(u'stage2_mark', ['expert_id', 'criterion_id'])
40 # Removing unique constraint on 'MarkCriterion', fields ['assignment', 'order']
41 db.delete_unique(u'stage2_markcriterion', ['assignment_id', 'order'])
43 # Deleting model 'MarkCriterion'
44 db.delete_table(u'stage2_markcriterion')
46 # Deleting field 'Mark.criterion'
47 db.delete_column(u'stage2_mark', 'criterion_id')
49 # Adding unique constraint on 'Mark', fields ['expert', 'answer']
50 db.create_unique(u'stage2_mark', ['expert_id', 'answer_id'])
55 'Meta': {'object_name': 'Group'},
56 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
57 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
58 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': u"orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
61 'Meta': {'ordering': "(u'content_type__app_label', u'content_type__model', u'codename')", 'unique_together': "((u'content_type', u'codename'),)", 'object_name': 'Permission'},
62 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
63 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contenttypes.ContentType']"}),
64 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
65 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
68 'Meta': {'object_name': 'User'},
69 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
70 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
71 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
72 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Group']"}),
73 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
74 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
75 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
76 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
77 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
78 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
79 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
80 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "u'user_set'", 'blank': 'True', 'to': u"orm['auth.Permission']"}),
81 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
84 'Meta': {'ordering': "('-created_at',)", 'object_name': 'Contact'},
85 'body': ('jsonfield.fields.JSONField', [], {}),
86 'contact': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
87 'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
88 'form_tag': ('django.db.models.fields.CharField', [], {'max_length': '32', 'db_index': 'True'}),
89 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
90 'ip': ('django.db.models.fields.IPAddressField', [], {'max_length': '15'})
92 u'contenttypes.contenttype': {
93 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
94 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
95 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
96 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
97 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
100 'Meta': {'unique_together': "(['participant', 'assignment'],)", 'object_name': 'Answer'},
101 'assignment': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Assignment']"}),
102 'complete': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
103 'experts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'stage2_assigned_answers'", 'symmetrical': 'False', 'to': u"orm['auth.User']"}),
104 'field_values': ('jsonfield.fields.JSONField', [], {'default': '{}'}),
105 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
106 'need_arbiter': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
107 'participant': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Participant']"})
109 u'stage2.assignment': {
110 'Meta': {'ordering': "['deadline', 'title']", 'object_name': 'Assignment'},
111 'arbiters': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'stage2_arbitrated'", 'blank': 'True', 'to': u"orm['auth.User']"}),
112 'content': ('django.db.models.fields.TextField', [], {}),
113 'content_url': ('django.db.models.fields.URLField', [], {'max_length': '200'}),
114 'deadline': ('django.db.models.fields.DateTimeField', [], {}),
115 'experts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'stage2_assignments'", 'symmetrical': 'False', 'to': u"orm['auth.User']"}),
116 'field_descriptions': ('jsonfield.fields.JSONField', [], {'default': '[]', 'blank': 'True'}),
117 'file_descriptions': ('jsonfield.fields.JSONField', [], {'default': '[]', 'blank': 'True'}),
118 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
119 'max_points': ('django.db.models.fields.IntegerField', [], {}),
120 'supervisors': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'stage2_supervised'", 'symmetrical': 'False', 'to': u"orm['auth.User']"}),
121 'title': ('django.db.models.fields.CharField', [], {'max_length': '128'})
123 u'stage2.attachment': {
124 'Meta': {'ordering': "['file_no']", 'object_name': 'Attachment'},
125 'answer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Answer']"}),
126 'file': ('django.db.models.fields.files.FileField', [], {'max_length': '100'}),
127 'file_no': ('django.db.models.fields.IntegerField', [], {}),
128 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
130 u'stage2.fieldoption': {
131 'Meta': {'ordering': "['set', 'value']", 'object_name': 'FieldOption'},
132 'answer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Answer']", 'null': 'True', 'blank': 'True'}),
133 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
134 'set': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.FieldOptionSet']"}),
135 'value': ('django.db.models.fields.CharField', [], {'max_length': '255'})
137 u'stage2.fieldoptionset': {
138 'Meta': {'object_name': 'FieldOptionSet'},
139 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
140 'name': ('django.db.models.fields.CharField', [], {'max_length': '32', 'db_index': 'True'})
143 'Meta': {'unique_together': "(['expert', 'criterion'],)", 'object_name': 'Mark'},
144 'answer': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Answer']"}),
145 'criterion': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.MarkCriterion']"}),
146 'expert': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['auth.User']"}),
147 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
148 'points': ('django.db.models.fields.DecimalField', [], {'max_digits': '3', 'decimal_places': '1'})
150 u'stage2.markcriterion': {
151 'Meta': {'ordering': "['order']", 'unique_together': "(['assignment', 'order'],)", 'object_name': 'MarkCriterion'},
152 'assignment': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['stage2.Assignment']"}),
153 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
154 'label': ('django.db.models.fields.CharField', [], {'max_length': '1024'}),
155 'max_points': ('django.db.models.fields.IntegerField', [], {}),
156 'order': ('django.db.models.fields.IntegerField', [], {})
158 u'stage2.participant': {
159 'Meta': {'object_name': 'Participant'},
160 'complete_set': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
161 'contact': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['contact.Contact']", 'null': 'True'}),
162 'email': ('django.db.models.fields.EmailField', [], {'unique': 'True', 'max_length': '100'}),
163 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
164 u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
165 'key': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'}),
166 'key_sent': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
167 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
171 complete_apps = ['stage2']