/jobs/migrations/0001_initial.py

https://bitbucket.org/acgray/recruitsql · Python · 207 lines · 169 code · 21 blank · 17 comment · 0 complexity · 1c95741b918bf2bf2df7216b9e4e9e5e MD5 · raw file

  1. # -*- coding: utf-8 -*-
  2. from south.db import db
  3. from south.v2 import SchemaMigration
  4. from django.db import models
  5. class Migration(SchemaMigration):
  6. def forwards(self, orm):
  7. # Adding model 'Organisation'
  8. db.create_table(u'jobs_organisation', (
  9. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  10. ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  11. ('logo', self.gf('django.db.models.fields.files.ImageField')(max_length=100, blank=True)),
  12. ('site', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['sites.Site'])),
  13. ))
  14. db.send_create_signal(u'jobs', ['Organisation'])
  15. # Adding model 'Period'
  16. db.create_table(u'jobs_period', (
  17. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  18. ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  19. ))
  20. db.send_create_signal(u'jobs', ['Period'])
  21. # Adding model 'Position'
  22. db.create_table(u'jobs_position', (
  23. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  24. ('title', self.gf('django.db.models.fields.CharField')(max_length=255)),
  25. ('organisation', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['jobs.Organisation'])),
  26. ('period', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['jobs.Period'])),
  27. ('job_description', self.gf('django.db.models.fields.TextField')()),
  28. ('summary', self.gf('django.db.models.fields.TextField')()),
  29. ('form',
  30. self.gf('django.db.models.fields.related.OneToOneField')(to=orm['jobs.ApplicationForm'], unique=True)),
  31. ))
  32. db.send_create_signal(u'jobs', ['Position'])
  33. # Adding M2M table for field applicants on 'Position'
  34. m2m_table_name = db.shorten_name(u'jobs_position_applicants')
  35. db.create_table(m2m_table_name, (
  36. ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
  37. ('position', models.ForeignKey(orm[u'jobs.position'], null=False)),
  38. ('eldonuser', models.ForeignKey(orm[u'registration_withemail.eldonuser'], null=False))
  39. ))
  40. db.create_unique(m2m_table_name, ['position_id', 'eldonuser_id'])
  41. # Adding model 'ApplicationForm'
  42. db.create_table(u'jobs_applicationform', (
  43. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  44. ('intro_text', self.gf('django.db.models.fields.TextField')()),
  45. ))
  46. db.send_create_signal(u'jobs', ['ApplicationForm'])
  47. # Adding model 'JobApplication'
  48. db.create_table(u'jobs_jobapplication', (
  49. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  50. ('entry_time', self.gf('django.db.models.fields.DateTimeField')()),
  51. ('form', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['jobs.ApplicationForm'])),
  52. ('user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['registration_withemail.EldonUser'],
  53. null=True)),
  54. ))
  55. db.send_create_signal(u'jobs', ['JobApplication'])
  56. # Adding model 'Field'
  57. db.create_table(u'jobs_field', (
  58. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  59. ('label', self.gf('django.db.models.fields.CharField')(max_length=200)),
  60. ('slug', self.gf('django.db.models.fields.SlugField')(default='', max_length=100, blank=True)),
  61. ('field_type', self.gf('django.db.models.fields.IntegerField')()),
  62. ('required', self.gf('django.db.models.fields.BooleanField')(default=True)),
  63. ('visible', self.gf('django.db.models.fields.BooleanField')(default=True)),
  64. ('choices', self.gf('django.db.models.fields.CharField')(max_length=1000, blank=True)),
  65. ('default', self.gf('django.db.models.fields.CharField')(max_length=2000, blank=True)),
  66. ('placeholder_text', self.gf('django.db.models.fields.CharField')(max_length=100, null=True, blank=True)),
  67. ('help_text', self.gf('django.db.models.fields.CharField')(max_length=100, blank=True)),
  68. ('form', self.gf('django.db.models.fields.related.ForeignKey')(related_name='fields',
  69. to=orm['jobs.ApplicationForm'])),
  70. ('order', self.gf('django.db.models.fields.IntegerField')(null=True, blank=True)),
  71. ))
  72. db.send_create_signal(u'jobs', ['Field'])
  73. # Adding model 'FieldEntry'
  74. db.create_table(u'jobs_fieldentry', (
  75. (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  76. ('field_id', self.gf('django.db.models.fields.IntegerField')()),
  77. ('value', self.gf('django.db.models.fields.CharField')(max_length=2000, null=True)),
  78. ('entry', self.gf('django.db.models.fields.related.ForeignKey')(related_name='fields',
  79. to=orm['jobs.JobApplication'])),
  80. ))
  81. db.send_create_signal(u'jobs', ['FieldEntry'])
  82. def backwards(self, orm):
  83. # Deleting model 'Organisation'
  84. db.delete_table(u'jobs_organisation')
  85. # Deleting model 'Period'
  86. db.delete_table(u'jobs_period')
  87. # Deleting model 'Position'
  88. db.delete_table(u'jobs_position')
  89. # Removing M2M table for field applicants on 'Position'
  90. db.delete_table(db.shorten_name(u'jobs_position_applicants'))
  91. # Deleting model 'ApplicationForm'
  92. db.delete_table(u'jobs_applicationform')
  93. # Deleting model 'JobApplication'
  94. db.delete_table(u'jobs_jobapplication')
  95. # Deleting model 'Field'
  96. db.delete_table(u'jobs_field')
  97. # Deleting model 'FieldEntry'
  98. db.delete_table(u'jobs_fieldentry')
  99. models = {
  100. u'jobs.applicationform': {
  101. 'Meta': {'object_name': 'ApplicationForm'},
  102. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  103. 'intro_text': ('django.db.models.fields.TextField', [], {})
  104. },
  105. u'jobs.field': {
  106. 'Meta': {'ordering': "('order',)", 'object_name': 'Field'},
  107. 'choices': ('django.db.models.fields.CharField', [], {'max_length': '1000', 'blank': 'True'}),
  108. 'default': ('django.db.models.fields.CharField', [], {'max_length': '2000', 'blank': 'True'}),
  109. 'field_type': ('django.db.models.fields.IntegerField', [], {}),
  110. 'form': ('django.db.models.fields.related.ForeignKey', [],
  111. {'related_name': "'fields'", 'to': u"orm['jobs.ApplicationForm']"}),
  112. 'help_text': ('django.db.models.fields.CharField', [], {'max_length': '100', 'blank': 'True'}),
  113. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  114. 'label': ('django.db.models.fields.CharField', [], {'max_length': '200'}),
  115. 'order': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'blank': 'True'}),
  116. 'placeholder_text': (
  117. 'django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
  118. 'required': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
  119. 'slug': ('django.db.models.fields.SlugField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}),
  120. 'visible': ('django.db.models.fields.BooleanField', [], {'default': 'True'})
  121. },
  122. u'jobs.fieldentry': {
  123. 'Meta': {'object_name': 'FieldEntry'},
  124. 'entry': ('django.db.models.fields.related.ForeignKey', [],
  125. {'related_name': "'fields'", 'to': u"orm['jobs.JobApplication']"}),
  126. 'field_id': ('django.db.models.fields.IntegerField', [], {}),
  127. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  128. 'value': ('django.db.models.fields.CharField', [], {'max_length': '2000', 'null': 'True'})
  129. },
  130. u'jobs.jobapplication': {
  131. 'Meta': {'object_name': 'JobApplication'},
  132. 'entry_time': ('django.db.models.fields.DateTimeField', [], {}),
  133. 'form': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['jobs.ApplicationForm']"}),
  134. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  135. 'user': ('django.db.models.fields.related.ForeignKey', [],
  136. {'to': u"orm['registration_withemail.EldonUser']", 'null': 'True'})
  137. },
  138. u'jobs.organisation': {
  139. 'Meta': {'object_name': 'Organisation'},
  140. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  141. 'logo': ('django.db.models.fields.files.ImageField', [], {'max_length': '100', 'blank': 'True'}),
  142. 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  143. 'site': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['sites.Site']"})
  144. },
  145. u'jobs.period': {
  146. 'Meta': {'object_name': 'Period'},
  147. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  148. 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
  149. },
  150. u'jobs.position': {
  151. 'Meta': {'object_name': 'Position'},
  152. 'applicants': ('django.db.models.fields.related.ManyToManyField', [],
  153. {'to': u"orm['registration_withemail.EldonUser']", 'symmetrical': 'False'}),
  154. 'form': ('django.db.models.fields.related.OneToOneField', [],
  155. {'to': u"orm['jobs.ApplicationForm']", 'unique': 'True'}),
  156. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  157. 'job_description': ('django.db.models.fields.TextField', [], {}),
  158. 'organisation': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['jobs.Organisation']"}),
  159. 'period': ('django.db.models.fields.related.ForeignKey', [], {'to': u"orm['jobs.Period']"}),
  160. 'summary': ('django.db.models.fields.TextField', [], {}),
  161. 'title': ('django.db.models.fields.CharField', [], {'max_length': '255'})
  162. },
  163. u'registration_withemail.eldonuser': {
  164. 'Meta': {'object_name': 'EldonUser'},
  165. 'activation_key': ('django.db.models.fields.CharField', [], {'max_length': '40', 'blank': 'True'}),
  166. 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
  167. 'email': (
  168. 'django.db.models.fields.EmailField', [], {'unique': 'True', 'max_length': '75', 'db_index': 'True'}),
  169. 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
  170. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  171. 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
  172. 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  173. 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  174. 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
  175. 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
  176. 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
  177. 'username': ('django.db.models.fields.CharField', [], {'max_length': '75', 'blank': 'True'})
  178. },
  179. u'sites.site': {
  180. 'Meta': {'ordering': "('domain',)", 'object_name': 'Site', 'db_table': "'django_site'"},
  181. 'domain': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  182. u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  183. 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
  184. }
  185. }
  186. complete_apps = ['jobs']