/accounts/migrations/0012_auto__add_field_expense_supplier.py

https://github.com/splanquart/aemanager · Python · 154 lines · 142 code · 9 blank · 3 comment · 0 complexity · 69ad64f0fb5c00437a3a54ca924b0d47 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 'Expense.supplier'
    12. 

  12.         db.add_column('accounts_expense', 'supplier', self.gf('django.db.models.fields.CharField')(max_length=70, null=True, blank=True), keep_default=False)
    13. 

  13. 

  14. 

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

  16.         
    17. 

  17.         # Deleting field 'Expense.supplier'
    18. 

  18.         db.delete_column('accounts_expense', 'supplier')
    19. 

  19. 

  20. 

  21.     models = {
    22. 

  22.         'accounts.expense': {
    23. 

  23.             'Meta': {'object_name': 'Expense', '_ormbases': ['core.OwnedObject']},
    24. 

  24.             'amount': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'}),
    25. 

  25.             'date': ('django.db.models.fields.DateField', [], {'db_index': 'True'}),
    26. 

  26.             'description': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
    27. 

  27.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    28. 

  28.             'payment_type': ('django.db.models.fields.IntegerField', [], {}),
    29. 

  29.             'reference': ('django.db.models.fields.CharField', [], {'max_length': '50', 'null': 'True', 'blank': 'True'}),
    30. 

  30.             'supplier': ('django.db.models.fields.CharField', [], {'max_length': '70', 'null': 'True', 'blank': 'True'})
    31. 

  31.         },
    32. 

  32.         'accounts.invoice': {
    33. 

  33.             'Meta': {'ordering': "['invoice_id']", 'object_name': 'Invoice', '_ormbases': ['core.OwnedObject']},
    34. 

  34.             'amount': ('django.db.models.fields.DecimalField', [], {'default': '0', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}),
    35. 

  35.             'customer': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Contact']", 'null': 'True', 'blank': 'True'}),
    36. 

  36.             'discount_conditions': ('django.db.models.fields.CharField', [], {'max_length': '100', 'null': 'True', 'blank': 'True'}),
    37. 

  37.             'edition_date': ('django.db.models.fields.DateField', [], {'db_index': 'True'}),
    38. 

  38.             'execution_begin_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    39. 

  39.             'execution_end_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    40. 

  40.             'invoice_id': ('django.db.models.fields.IntegerField', [], {}),
    41. 

  41.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    42. 

  42.             'paid_date': ('django.db.models.fields.DateField', [], {'db_index': 'True', 'null': 'True', 'blank': 'True'}),
    43. 

  43.             'payment_date': ('django.db.models.fields.DateField', [], {'db_index': 'True'}),
    44. 

  44.             'payment_type': ('django.db.models.fields.IntegerField', [], {}),
    45. 

  45.             'penalty_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    46. 

  46.             'penalty_rate': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '4', 'decimal_places': '2', 'blank': 'True'}),
    47. 

  47.             'state': ('django.db.models.fields.IntegerField', [], {'default': '1', 'db_index': 'True'})
    48. 

  48.         },
    49. 

  49.         'accounts.invoicerow': {
    50. 

  50.             'Meta': {'object_name': 'InvoiceRow'},
    51. 

  51.             'amount': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}),
    52. 

  52.             'balance_payments': ('django.db.models.fields.BooleanField', [], {'default': 'False'}),
    53. 

  53.             'category': ('django.db.models.fields.IntegerField', [], {}),
    54. 

  54.             'invoice': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'invoice_rows'", 'to': "orm['accounts.Invoice']"}),
    55. 

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

  56.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    57. 

  57.             'proposal': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'invoice_rows'", 'to': "orm['project.Proposal']"}),
    58. 

  58.             'quantity': ('django.db.models.fields.DecimalField', [], {'max_digits': '5', 'decimal_places': '1'}),
    59. 

  59.             'unit_price': ('django.db.models.fields.DecimalField', [], {'max_digits': '12', 'decimal_places': '2'})
    60. 

  60.         },
    61. 

  61.         'auth.group': {
    62. 

  62.             'Meta': {'object_name': 'Group'},
    63. 

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

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

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

  66.         },
    67. 

  67.         'auth.permission': {
    68. 

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

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

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

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

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

  73.         },
    74. 

  74.         'auth.user': {
    75. 

  75.             'Meta': {'object_name': 'User'},
    76. 

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

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

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

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

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

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

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

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

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

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

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

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

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

  89.         },
    90. 

  90.         'contact.address': {
    91. 

  91.             'Meta': {'object_name': 'Address', '_ormbases': ['core.OwnedObject']},
    92. 

  92.             'city': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    93. 

  93.             'country': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Country']", 'null': 'True', 'blank': 'True'}),
    94. 

  94.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    95. 

  95.             'street': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
    96. 

  96.             'zipcode': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'})
    97. 

  97.         },
    98. 

  98.         'contact.contact': {
    99. 

  99.             'Meta': {'object_name': 'Contact', '_ormbases': ['core.OwnedObject']},
    100. 

  100.             'address': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Address']"}),
    101. 

  101.             'company_id': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '50', 'blank': 'True'}),
    102. 

  102.             'contact_type': ('django.db.models.fields.IntegerField', [], {}),
    103. 

  103.             'contacts': ('django.db.models.fields.related.ManyToManyField', [], {'blank': 'True', 'related_name': "'contacts_rel_+'", 'null': 'True', 'to': "orm['contact.Contact']"}),
    104. 

  104.             'email': ('django.db.models.fields.EmailField', [], {'default': "''", 'max_length': '75', 'blank': 'True'}),
    105. 

  105.             'firstname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    106. 

  106.             'function': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}),
    107. 

  107.             'legal_form': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    108. 

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

  109.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    110. 

  110.             'representative': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '255', 'blank': 'True'}),
    111. 

  111.             'representative_function': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '100', 'blank': 'True'})
    112. 

  112.         },
    113. 

  113.         'contact.country': {
    114. 

  114.             'Meta': {'ordering': "['country_name']", 'object_name': 'Country'},
    115. 

  115.             'country_code2': ('django.db.models.fields.CharField', [], {'max_length': '2'}),
    116. 

  116.             'country_code3': ('django.db.models.fields.CharField', [], {'max_length': '3'}),
    117. 

  117.             'country_name': ('django.db.models.fields.CharField', [], {'max_length': '50'}),
    118. 

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

  119.         },
    120. 

  120.         'contenttypes.contenttype': {
    121. 

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

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

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

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

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

  126.         },
    127. 

  127.         'core.ownedobject': {
    128. 

  128.             'Meta': {'object_name': 'OwnedObject'},
    129. 

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

  130.             'owner': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['auth.User']"})
    131. 

  131.         },
    132. 

  132.         'project.project': {
    133. 

  133.             'Meta': {'object_name': 'Project', '_ormbases': ['core.OwnedObject']},
    134. 

  134.             'customer': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['contact.Contact']"}),
    135. 

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

  136.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    137. 

  137.             'state': ('django.db.models.fields.IntegerField', [], {'default': '1', 'db_index': 'True'})
    138. 

  138.         },
    139. 

  139.         'project.proposal': {
    140. 

  140.             'Meta': {'ordering': "['begin_date', 'update_date']", 'object_name': 'Proposal', '_ormbases': ['core.OwnedObject']},
    141. 

  141.             'amount': ('django.db.models.fields.DecimalField', [], {'null': 'True', 'max_digits': '12', 'decimal_places': '2', 'blank': 'True'}),
    142. 

  142.             'begin_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    143. 

  143.             'contract_content': ('django.db.models.fields.TextField', [], {'default': "''", 'blank': 'True'}),
    144. 

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

  145.             'expiration_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}),
    146. 

  146.             'ownedobject_ptr': ('django.db.models.fields.related.OneToOneField', [], {'to': "orm['core.OwnedObject']", 'unique': 'True', 'primary_key': 'True'}),
    147. 

  147.             'project': ('django.db.models.fields.related.ForeignKey', [], {'to': "orm['project.Project']"}),
    148. 

  148.             'reference': ('django.db.models.fields.CharField', [], {'max_length': '20', 'null': 'True', 'blank': 'True'}),
    149. 

  149.             'state': ('django.db.models.fields.IntegerField', [], {'default': '1', 'db_index': 'True'}),
    150. 

  150.             'update_date': ('django.db.models.fields.DateField', [], {})
    151. 

  151.         }
    152. 

  152.     }
    153. 

  153. 

  154.     complete_apps = ['accounts']
    155.