/qualitio/organizations/migrations/0001_initial.py

https://github.com/qualitio/qualitio · Python · 145 lines · 117 code · 17 blank · 11 comment · 0 complexity · 6359e7032e253b1b4b29d3d17cbbf815 MD5 · raw file

  1. # encoding: utf-8
  2. import datetime
  3. from south.db import db
  4. from south.v2 import SchemaMigration
  5. from django.db import models
  6. class Migration(SchemaMigration):
  7. def forwards(self, orm):
  8. # Adding model 'Organization'
  9. db.create_table('organizations_organization', (
  10. ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  11. ('name', self.gf('django.db.models.fields.CharField')(unique=True, max_length=255)),
  12. ('slug', self.gf('django.db.models.fields.SlugField')(db_index=True, max_length=50, blank=True)),
  13. ('homepage', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)),
  14. ('description', self.gf('django.db.models.fields.TextField')(blank=True)),
  15. ('googleapps_domain', self.gf('django.db.models.fields.CharField')(max_length=255, blank=True)),
  16. ('modified_time', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
  17. ('created_time', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
  18. ))
  19. db.send_create_signal('organizations', ['Organization'])
  20. # Adding model 'OrganizationMember'
  21. db.create_table('organizations_organizationmember', (
  22. ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  23. ('organization', self.gf('django.db.models.fields.related.ForeignKey')(related_name='members', to=orm['organizations.Organization'])),
  24. ('user', self.gf('django.db.models.fields.related.OneToOneField')(related_name='organization_member', unique=True, to=orm['auth.User'])),
  25. ('role', self.gf('django.db.models.fields.IntegerField')(default=999)),
  26. ))
  27. db.send_create_signal('organizations', ['OrganizationMember'])
  28. # Adding model 'Project'
  29. db.create_table('organizations_project', (
  30. ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
  31. ('organization', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['organizations.Organization'])),
  32. ('name', self.gf('django.db.models.fields.CharField')(max_length=255)),
  33. ('slug', self.gf('django.db.models.fields.SlugField')(db_index=True, max_length=50, blank=True)),
  34. ('homepage', self.gf('django.db.models.fields.URLField')(max_length=200, blank=True)),
  35. ('description', self.gf('django.db.models.fields.TextField')(blank=True)),
  36. ('modified_time', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)),
  37. ('created_time', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)),
  38. ))
  39. db.send_create_signal('organizations', ['Project'])
  40. # Adding unique constraint on 'Project', fields ['organization', 'name']
  41. db.create_unique('organizations_project', ['organization_id', 'name'])
  42. # Adding M2M table for field team on 'Project'
  43. db.create_table('organizations_project_team', (
  44. ('id', models.AutoField(verbose_name='ID', primary_key=True, auto_created=True)),
  45. ('project', models.ForeignKey(orm['organizations.project'], null=False)),
  46. ('user', models.ForeignKey(orm['auth.user'], null=False))
  47. ))
  48. db.create_unique('organizations_project_team', ['project_id', 'user_id'])
  49. def backwards(self, orm):
  50. # Removing unique constraint on 'Project', fields ['organization', 'name']
  51. db.delete_unique('organizations_project', ['organization_id', 'name'])
  52. # Deleting model 'Organization'
  53. db.delete_table('organizations_organization')
  54. # Deleting model 'OrganizationMember'
  55. db.delete_table('organizations_organizationmember')
  56. # Deleting model 'Project'
  57. db.delete_table('organizations_project')
  58. # Removing M2M table for field team on 'Project'
  59. db.delete_table('organizations_project_team')
  60. models = {
  61. 'auth.group': {
  62. 'Meta': {'object_name': 'Group'},
  63. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  64. 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
  65. 'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
  66. },
  67. 'auth.permission': {
  68. 'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
  69. 'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  70. 'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
  71. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  72. 'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
  73. },
  74. 'auth.user': {
  75. 'Meta': {'object_name': 'User'},
  76. 'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
  77. 'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
  78. 'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
  79. 'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
  80. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  81. 'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
  82. 'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  83. 'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
  84. 'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
  85. 'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
  86. 'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
  87. 'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
  88. 'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
  89. },
  90. 'contenttypes.contenttype': {
  91. 'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
  92. 'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  93. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  94. 'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
  95. 'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
  96. },
  97. 'organizations.organization': {
  98. 'Meta': {'object_name': 'Organization'},
  99. 'created_time': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
  100. 'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
  101. 'googleapps_domain': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
  102. 'homepage': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'}),
  103. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  104. 'modified_time': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
  105. 'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
  106. 'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '50', 'blank': 'True'})
  107. },
  108. 'organizations.organizationmember': {
  109. 'Meta': {'object_name': 'OrganizationMember'},
  110. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  111. 'organization': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'members'", 'to': "orm['organizations.Organization']"}),
  112. 'role': ('django.db.models.fields.IntegerField', [], {'default': '999'}),
  113. 'user': ('django.db.models.fields.related.OneToOneField', [], {'related_name': "'organization_member'", 'unique': 'True', 'to': "orm['auth.User']"})
  114. },
  115. 'organizations.project': {
  116. 'Meta': {'unique_together': "(('organization', 'name'),)", 'object_name': 'Project'},
  117. 'created_time': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}),
  118. 'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
  119. 'homepage': ('django.db.models.fields.URLField', [], {'max_length': '200', 'blank': 'True'}),
  120. 'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
  121. 'modified_time': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
  122. 'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
  123. 'organization': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['organizations.Organization']"}),
  124. 'slug': ('django.db.models.fields.SlugField', [], {'db_index': 'True', 'max_length': '50', 'blank': 'True'}),
  125. 'team': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'projects'", 'blank': 'True', 'to': "orm['auth.User']"})
  126. }
  127. }
  128. complete_apps = ['organizations']