/timepiece/migrations/0016_auto__add_field_personschedule_user.py

https://bitbucket.org/copelco/django-timepiece/ · Python · 244 lines · 232 code · 9 blank · 3 comment · 0 complexity · 1ec40cb8673eec34a187ac80c59b1961 MD5 · raw file 

    

  1. # encoding: utf-8
    2. 

  2. import datetime
    3. 

  3. from south.db import db
    4. 

  4. from south.v2 import SchemaMigration
    5. 

  5. from django.db import models
    6. 

  6. 

  7. class Migration(SchemaMigration):
    8. 

  8. 

  9.     def forwards(self, orm):
    10. 

  10.         
    11. 

  11.         # Adding field 'PersonSchedule.user'
    12. 

  12.         db.add_column('timepiece_personschedule', 'user', self.gf('django.db.models.fields.related.ForeignKey')(to=orm['auth.User'], unique=True, null=True), keep_default=False)
    13. 

  13. 

  14. 

  15.     def backwards(self, orm):
    16. 

  16.         
    17. 

  17.         # Deleting field 'PersonSchedule.user'
    18. 

  18.         db.delete_column('timepiece_personschedule', 'user_id')
    19. 

  19.         db.alter_column('timepiece_personschedule', 'contact_id', models.ForeignKey(orm['crm.Contact'], null=False, blank=True))
    20. 

  20. 

  21. 

  22.     models = {
    23. 

  23.         'auth.group': {
    24. 

  24.             'Meta': {'object_name': 'Group'},
    25. 

  25.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    26. 

  26.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '80'}),
    27. 

  27.             'permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'})
    28. 

  28.         },
    29. 

  29.         'auth.permission': {
    30. 

  30.             'Meta': {'ordering': "('content_type__app_label', 'content_type__model', 'codename')", 'unique_together': "(('content_type', 'codename'),)", 'object_name': 'Permission'},
    31. 

  31.             'codename': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    32. 

  32.             'content_type': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contenttypes.ContentType']"}),
    33. 

  33.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    34. 

  34.             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
    35. 

  35.         },
    36. 

  36.         'auth.user': {
    37. 

  37.             'Meta': {'object_name': 'User'},
    38. 

  38.             'date_joined': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    39. 

  39.             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
    40. 

  40.             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
    41. 

  41.             'groups': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Group']", 'symmetrical': 'False', 'blank': 'True'}),
    42. 

  42.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    43. 

  43.             'is_active': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    44. 

  44.             'is_staff': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    45. 

  45.             'is_superuser': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    46. 

  46.             'last_login': ('django.db.models.fields.DateTimeField', [], {'default': 'datetime.datetime.now'}),
    47. 

  47.             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '30', 'blank': 'True'}),
    48. 

  48.             'password': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
    49. 

  49.             'user_permissions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['auth.Permission']", 'symmetrical': 'False', 'blank': 'True'}),
    50. 

  50.             'username': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '30'})
    51. 

  51.         },
    52. 

  52.         'contactinfo.location': {
    53. 

  53.             'Meta': {'object_name': 'Location'},
    54. 

  54.             'country': ('django.db.models.fields.related.ForeignKey', [], {'default': "u'US'", 'to': "orm['countries.Country']"}),
    55. 

  55.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    56. 

  56.             'type': ('django.db.models.fields.related.ForeignKey', [], {'default': '2', 'to': "orm['contactinfo.LocationType']"})
    57. 

  57.         },
    58. 

  58.         'contactinfo.locationtype': {
    59. 

  59.             'Meta': {'object_name': 'LocationType'},
    60. 

  60.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    61. 

  61.             'name': ('django.db.models.fields.CharField', [], {'max_length': '30'}),
    62. 

  62.             'slug': ('django.db.models.fields.CharField', [], {'max_length': '30'})
    63. 

  63.         },
    64. 

  64.         'contenttypes.contenttype': {
    65. 

  65.             'Meta': {'ordering': "('name',)", 'unique_together': "(('app_label', 'model'),)", 'object_name': 'ContentType', 'db_table': "'django_content_type'"},
    66. 

  66.             'app_label': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    67. 

  67.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    68. 

  68.             'model': ('django.db.models.fields.CharField', [], {'max_length': '100'}),
    69. 

  69.             'name': ('django.db.models.fields.CharField', [], {'max_length': '100'})
    70. 

  70.         },
    71. 

  71.         'countries.country': {
    72. 

  72.             'Meta': {'ordering': "('name',)", 'object_name': 'Country', 'db_table': "'country'"},
    73. 

  73.             'iso': ('django.db.models.fields.CharField', [], {'max_length': '2', 'primary_key': 'True'}),
    74. 

  74.             'iso3': ('django.db.models.fields.CharField', [], {'max_length': '3', 'null': 'True'}),
    75. 

  75.             'name': ('django.db.models.fields.CharField', [], {'max_length': '128'}),
    76. 

  76.             'numcode': ('django.db.models.fields.PositiveSmallIntegerField', [], {'null': 'True'}),
    77. 

  77.             'printable_name': ('django.db.models.fields.CharField', [], {'max_length': '128'})
    78. 

  78.         },
    79. 

  79.         'crm.businesstype': {
    80. 

  80.             'Meta': {'object_name': 'BusinessType'},
    81. 

  81.             'can_view_all_projects': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    82. 

  82.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    83. 

  83.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'})
    84. 

  84.         },
    85. 

  85.         'crm.contact': {
    86. 

  86.             'Meta': {'object_name': 'Contact'},
    87. 

  87.             'business_types': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'businesses'", 'blank': 'True', 'to': "orm['crm.BusinessType']"}),
    88. 

  88.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'related_contacts+'", 'symmetrical': 'False', 'through': "orm['crm.ContactRelationship']", 'to': "orm['crm.Contact']"}),
    89. 

  89.             'description': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
    90. 

  90.             'email': ('django.db.models.fields.EmailField', [], {'max_length': '75', 'blank': 'True'}),
    91. 

  91.             'external_id': ('django.db.models.fields.CharField', [], {'max_length': '32', 'blank': 'True'}),
    92. 

  92.             'first_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}),
    93. 

  93.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    94. 

  94.             'last_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}),
    95. 

  95.             'locations': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['contactinfo.Location']", 'symmetrical': 'False', 'blank': 'True'}),
    96. 

  96.             'middle_name': ('django.db.models.fields.CharField', [], {'max_length': '50', 'blank': 'True'}),
    97. 

  97.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255', 'blank': 'True'}),
    98. 

  98.             'notes': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
    99. 

  99.             'picture': ('django.db.models.fields.files.ImageField', [], {'max_length': '1048576', 'null': 'True', 'blank': 'True'}),
    100. 

  100.             'slug': ('django.db.models.fields.SlugField', [], {'unique': 'True', 'max_length': '255', 'db_index': 'True'}),
    101. 

  101.             'sort_name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    102. 

  102.             'type': ('django.db.models.fields.CharField', [], {'max_length': '32'}),
    103. 

  103.             'user': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'contacts'", 'unique': 'True', 'null': 'True', 'to': "orm['auth.User']"})
    104. 

  104.         },
    105. 

  105.         'crm.contactrelationship': {
    106. 

  106.             'Meta': {'unique_together': "(('from_contact', 'to_contact'),)", 'object_name': 'ContactRelationship'},
    107. 

  107.             'end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    108. 

  108.             'from_contact': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'from_contacts'", 'to': "orm['crm.Contact']"}),
    109. 

  109.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    110. 

  110.             'start_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    111. 

  111.             'to_contact': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'to_contacts'", 'to': "orm['crm.Contact']"}),
    112. 

  112.             'types': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'contact_relationships'", 'blank': 'True', 'to': "orm['crm.RelationshipType']"})
    113. 

  113.         },
    114. 

  114.         'crm.interaction': {
    115. 

  115.             'Meta': {'ordering': "['-date']", 'object_name': 'Interaction'},
    116. 

  116.             'cdr_id': ('django.db.models.fields.TextField', [], {'null': 'True'}),
    117. 

  117.             'completed': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    118. 

  118.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'interactions'", 'symmetrical': 'False', 'to': "orm['crm.Contact']"}),
    119. 

  119.             'date': ('django.db.models.fields.DateTimeField', [], {}),
    120. 

  120.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    121. 

  121.             'memo': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
    122. 

  122.             'type': ('django.db.models.fields.CharField', [], {'max_length': '15'})
    123. 

  123.         },
    124. 

  124.         'crm.relationshiptype': {
    125. 

  125.             'Meta': {'object_name': 'RelationshipType'},
    126. 

  126.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    127. 

  127.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
    128. 

  128.             'slug': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'})
    129. 

  129.         },
    130. 

  130.         'timepiece.activity': {
    131. 

  131.             'Meta': {'ordering': "('name',)", 'object_name': 'Activity'},
    132. 

  132.             'code': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '5'}),
    133. 

  133.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    134. 

  134.             'name': ('django.db.models.fields.CharField', [], {'max_length': '50'})
    135. 

  135.         },
    136. 

  136.         'timepiece.assignmentallocation': {
    137. 

  137.             'Meta': {'object_name': 'AssignmentAllocation'},
    138. 

  138.             'assignment': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'blocks'", 'to': "orm['timepiece.ContractAssignment']"}),
    139. 

  139.             'date': ('django.db.models.fields.DateField', [], {}),
    140. 

  140.             'hours': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '8', 'decimal_places': '2'}),
    141. 

  141.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'})
    142. 

  142.         },
    143. 

  143.         'timepiece.attribute': {
    144. 

  144.             'Meta': {'ordering': "('sort_order',)", 'unique_together': "(('type', 'label'),)", 'object_name': 'Attribute'},
    145. 

  145.             'enable_timetracking': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    146. 

  146.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    147. 

  147.             'label': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    148. 

  148.             'sort_order': ('django.db.models.fields.SmallIntegerField', [], {'null': 'True', 'blank': 'True'}),
    149. 

  149.             'type': ('django.db.models.fields.CharField', [], {'max_length': '32'})
    150. 

  150.         },
    151. 

  151.         'timepiece.billingwindow': {
    152. 

  152.             'Meta': {'object_name': 'BillingWindow'},
    153. 

  153.             'date': ('django.db.models.fields.DateField', [], {}),
    154. 

  154.             'end_date': ('django.db.models.fields.DateField', [], {}),
    155. 

  155.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    156. 

  156.             'period': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'billing_windows'", 'to': "orm['timepiece.RepeatPeriod']"})
    157. 

  157.         },
    158. 

  158.         'timepiece.contractassignment': {
    159. 

  159.             'Meta': {'unique_together': "(('contract', 'contact'),)", 'object_name': 'ContractAssignment'},
    160. 

  160.             'contact': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'assignments'", 'to': "orm['auth.User']"}),
    161. 

  161.             'contract': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'assignments'", 'to': "orm['timepiece.ProjectContract']"}),
    162. 

  162.             'end_date': ('django.db.models.fields.DateField', [], {}),
    163. 

  163.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    164. 

  164.             'min_hours_per_week': ('django.db.models.fields.IntegerField', [], {'default': '0'}),
    165. 

  165.             'num_hours': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '8', 'decimal_places': '2'}),
    166. 

  166.             'start_date': ('django.db.models.fields.DateField', [], {})
    167. 

  167.         },
    168. 

  168.         'timepiece.entry': {
    169. 

  169.             'Meta': {'object_name': 'Entry'},
    170. 

  170.             'activity': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'entries'", 'null': 'True', 'to': "orm['timepiece.Activity']"}),
    171. 

  171.             'billable': ('django.db.models.fields.BooleanField', [], {'default': 'True'}),
    172. 

  172.             'comments': ('django.db.models.fields.TextField', [], {'blank': 'True'}),
    173. 

  173.             'date_updated': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}),
    174. 

  174.             'end_time': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
    175. 

  175.             'hours': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '8', 'decimal_places': '2'}),
    176. 

  176.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    177. 

  177.             'location': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'entries'", 'to': "orm['timepiece.Location']"}),
    178. 

  178.             'pause_time': ('django.db.models.fields.DateTimeField', [], {'null': 'True', 'blank': 'True'}),
    179. 

  179.             'project': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'entries'", 'to': "orm['timepiece.Project']"}),
    180. 

  180.             'seconds_paused': ('django.db.models.fields.PositiveIntegerField', [], {'default': '0'}),
    181. 

  181.             'start_time': ('django.db.models.fields.DateTimeField', [], {}),
    182. 

  182.             'user': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'timepiece_entries'", 'to': "orm['auth.User']"})
    183. 

  183.         },
    184. 

  184.         'timepiece.location': {
    185. 

  185.             'Meta': {'object_name': 'Location'},
    186. 

  186.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    187. 

  187.             'name': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'}),
    188. 

  188.             'slug': ('django.db.models.fields.CharField', [], {'unique': 'True', 'max_length': '255'})
    189. 

  189.         },
    190. 

  190.         'timepiece.personrepeatperiod': {
    191. 

  191.             'Meta': {'object_name': 'PersonRepeatPeriod'},
    192. 

  192.             'contact': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'unique': 'True', 'null': 'True'}),
    193. 

  193.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    194. 

  194.             'repeat_period': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['timepiece.RepeatPeriod']", 'unique': 'True'})
    195. 

  195.         },
    196. 

  196.         'timepiece.personschedule': {
    197. 

  197.             'Meta': {'object_name': 'PersonSchedule'},
    198. 

  198.             'contact': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['crm.Contact']", 'unique': 'True'}),
    199. 

  199.             'end_date': ('django.db.models.fields.DateField', [], {}),
    200. 

  200.             'hours_per_week': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '8', 'decimal_places': '2'}),
    201. 

  201.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    202. 

  202.             'user': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']", 'unique': 'True', 'null': 'True'})
    203. 

  203.         },
    204. 

  204.         'timepiece.project': {
    205. 

  205.             'Meta': {'ordering': "('name', 'status', 'type')", 'object_name': 'Project'},
    206. 

  206.             'billing_period': ('django.db.models.fields.related.ForeignKey', [], {'blank': 'True', 'related_name': "'projects'", 'null': 'True', 'to': "orm['timepiece.RepeatPeriod']"}),
    207. 

  207.             'business': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'business_projects'", 'to': "orm['crm.Contact']"}),
    208. 

  208.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'related_name': "'contact_projects'", 'symmetrical': 'False', 'through': "orm['timepiece.ProjectRelationship']", 'to': "orm['auth.User']"}),
    209. 

  209.             'description': ('django.db.models.fields.TextField', [], {}),
    210. 

  210.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    211. 

  211.             'interactions': ('django.db.models.fields.related.ManyToManyField', [], {'to': "orm['crm.Interaction']", 'symmetrical': 'False', 'blank': 'True'}),
    212. 

  212.             'name': ('django.db.models.fields.CharField', [], {'max_length': '255'}),
    213. 

  213.             'point_person': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"}),
    214. 

  214.             'status': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'projects_with_status'", 'to': "orm['timepiece.Attribute']"}),
    215. 

  215.             'trac_environment': ('django.db.models.fields.CharField', [], {'max_length': '255', 'null': 'True', 'blank': 'True'}),
    216. 

  216.             'type': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'projects_with_type'", 'to': "orm['timepiece.Attribute']"})
    217. 

  217.         },
    218. 

  218.         'timepiece.projectcontract': {
    219. 

  219.             'Meta': {'object_name': 'ProjectContract'},
    220. 

  220.             'end_date': ('django.db.models.fields.DateField', [], {}),
    221. 

  221.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    222. 

  222.             'num_hours': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '8', 'decimal_places': '2'}),
    223. 

  223.             'project': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'contracts'", 'to': "orm['timepiece.Project']"}),
    224. 

  224.             'start_date': ('django.db.models.fields.DateField', [], {}),
    225. 

  225.             'status': ('django.db.models.fields.CharField', [], {'default': "'upcomming'", 'max_length': '32'})
    226. 

  226.         },
    227. 

  227.         'timepiece.projectrelationship': {
    228. 

  228.             'Meta': {'unique_together': "(('contact', 'project'),)", 'object_name': 'ProjectRelationship'},
    229. 

  229.             'contact': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'project_relationships'", 'to': "orm['auth.User']"}),
    230. 

  230.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    231. 

  231.             'project': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'project_relationships'", 'to': "orm['timepiece.Project']"}),
    232. 

  232.             'types': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'project_relationships'", 'blank': 'True', 'to': "orm['crm.RelationshipType']"})
    233. 

  233.         },
    234. 

  234.         'timepiece.repeatperiod': {
    235. 

  235.             'Meta': {'object_name': 'RepeatPeriod'},
    236. 

  236.             'active': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    237. 

  237.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'symmetrical': 'False', 'related_name': "'repeat_periods'", 'blank': 'True', 'through': "orm['timepiece.PersonRepeatPeriod']", 'to': "orm['auth.User']"}),
    238. 

  238.             'count': ('django.db.models.fields.PositiveSmallIntegerField', [], {}),
    239. 

  239.             'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
    240. 

  240.             'interval': ('django.db.models.fields.CharField', [], {'max_length': '10'})
    241. 

  241.         }
    242. 

  242.     }
    243. 

  243. 

  244.     complete_apps = ['timepiece']
    245.