datawinners/custom_reports/crs/migrations/0003_auto__chg_field_distribution_q5__chg_field_distribution_q7__chg_field_.py
# encoding: utf-8
import datetime
from south.db import db
from south.v2 import SchemaMigration
from django.db import models
class Migration(SchemaMigration):
def forwards(self, orm):
# Changing field 'Distribution.q5'
db.alter_column('crs_distribution', 'oil', self.gf('django.db.models.fields.FloatField')(null=True, db_column='oil'))
# Changing field 'Distribution.q7'
db.alter_column('crs_distribution', 'sorghum', self.gf('django.db.models.fields.FloatField')(null=True, db_column='sorghum'))
# Changing field 'Distribution.q6'
db.alter_column('crs_distribution', 'csb', self.gf('django.db.models.fields.FloatField')(null=True, db_column='csb'))
# Changing field 'Distribution.q9'
db.alter_column('crs_distribution', 'returned_oil', self.gf('django.db.models.fields.IntegerField')(null=True, db_column='returned_oil'))
# Changing field 'Distribution.q8'
db.alter_column('crs_distribution', 'rice', self.gf('django.db.models.fields.FloatField')(null=True, db_column='rice'))
# Changing field 'Distribution.q11'
db.alter_column('crs_distribution', 'returned_sorghum', self.gf('django.db.models.fields.IntegerField')(null=True, db_column='returned_sorghum'))
# Changing field 'Distribution.q10'
db.alter_column('crs_distribution', 'returned_csb', self.gf('django.db.models.fields.IntegerField')(null=True, db_column='returned_csb'))
# Changing field 'Distribution.q12'
db.alter_column('crs_distribution', 'returned_rice', self.gf('django.db.models.fields.IntegerField')(null=True, db_column='returned_rice'))
def backwards(self, orm):
# Changing field 'Distribution.q5'
db.alter_column('crs_distribution', 'oil', self.gf('django.db.models.fields.FloatField')(default=None, db_column='oil'))
# Changing field 'Distribution.q7'
db.alter_column('crs_distribution', 'sorghum', self.gf('django.db.models.fields.FloatField')(default=None, db_column='sorghum'))
# Changing field 'Distribution.q6'
db.alter_column('crs_distribution', 'csb', self.gf('django.db.models.fields.FloatField')(default=None, db_column='csb'))
# Changing field 'Distribution.q9'
db.alter_column('crs_distribution', 'returned_oil', self.gf('django.db.models.fields.IntegerField')(default=None, db_column='returned_oil'))
# Changing field 'Distribution.q8'
db.alter_column('crs_distribution', 'rice', self.gf('django.db.models.fields.FloatField')(default=None, db_column='rice'))
# Changing field 'Distribution.q11'
db.alter_column('crs_distribution', 'returned_sorghum', self.gf('django.db.models.fields.IntegerField')(default=None, db_column='returned_sorghum'))
# Changing field 'Distribution.q10'
db.alter_column('crs_distribution', 'returned_csb', self.gf('django.db.models.fields.IntegerField')(default=None, db_column='returned_csb'))
# Changing field 'Distribution.q12'
db.alter_column('crs_distribution', 'returned_rice', self.gf('django.db.models.fields.IntegerField')(default=None, db_column='returned_rice'))
models = {
'crs.distribution': {
'Meta': {'object_name': 'Distribution'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'site_code'"}),
'q10': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'db_column': "'returned_csb'"}),
'q11': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'db_column': "'returned_sorghum'"}),
'q12': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'db_column': "'returned_rice'"}),
'q2': ('django.db.models.fields.DateField', [], {'db_column': "'distribution_date'"}),
'q3': ('django.db.models.fields.TextField', [], {'db_column': "'received_waybill_code'"}),
'q4': ('django.db.models.fields.TextField', [], {'db_column': "'returned_waybill_code'"}),
'q5': ('django.db.models.fields.FloatField', [], {'null': 'True', 'db_column': "'oil'"}),
'q6': ('django.db.models.fields.FloatField', [], {'null': 'True', 'db_column': "'csb'"}),
'q7': ('django.db.models.fields.FloatField', [], {'null': 'True', 'db_column': "'sorghum'"}),
'q8': ('django.db.models.fields.FloatField', [], {'null': 'True', 'db_column': "'rice'"}),
'q9': ('django.db.models.fields.IntegerField', [], {'null': 'True', 'db_column': "'returned_oil'"})
},
'crs.physicalinventorysheet': {
'Meta': {'object_name': 'PhysicalInventorySheet'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'store_house_code'"}),
'q2': ('django.db.models.fields.DateField', [], {'db_column': "'physical_inventory_closing_date'"}),
'q3': ('django.db.models.fields.DateField', [], {'db_column': "'actual_physical_inventory_date'"}),
'q4': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"}),
'q5': ('django.db.models.fields.TextField', [], {'db_column': "'food_type'"}),
'q6': ('django.db.models.fields.FloatField', [], {'db_column': "'good_net_weight'"}),
'q7': ('django.db.models.fields.FloatField', [], {'db_column': "'damaged_net_weight'"})
},
'crs.siteactivities': {
'Meta': {'object_name': 'SiteActivities'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'fiscal_year_with_initials'"}),
'q2': ('django.db.models.fields.TextField', [], {'db_column': "'site_location'"}),
'q3': ('django.db.models.fields.TextField', [], {'db_column': "'site_gps_coordinates'"}),
'q4': ('django.db.models.fields.TextField', [], {'db_column': "'tel_no'"}),
'q5': ('django.db.models.fields.TextField', [], {'db_column': "'site_person_responsible'"}),
'q6': ('django.db.models.fields.TextField', [], {'db_column': "'type_of_activity'"}),
'q7': ('django.db.models.fields.TextField', [], {'db_column': "'site_code'"})
},
'crs.warehouse': {
'Meta': {'object_name': 'Warehouse'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'name'"}),
'q2': ('django.db.models.fields.TextField', [], {'db_column': "'address'"}),
'q3': ('django.db.models.fields.TextField', [], {'db_column': "'gps_coordinates'"}),
'q4': ('django.db.models.fields.TextField', [], {'db_column': "'tel_no'"}),
'q5': ('django.db.models.fields.TextField', [], {'db_column': "'initials'"})
},
'crs.waybillreceived': {
'Meta': {'object_name': 'WayBillReceived'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"}),
'q2': ('django.db.models.fields.TextField', [], {'db_column': "'waybill_code'"}),
'q3': ('django.db.models.fields.TextField', [], {'db_column': "'site_code'"}),
'q4': ('django.db.models.fields.TextField', [], {'db_column': "'receiver_name'"}),
'q5': ('django.db.models.fields.DateField', [], {'db_column': "'received_date'"}),
'q6': ('django.db.models.fields.TextField', [], {'db_column': "'truck_id'"}),
'q7': ('django.db.models.fields.FloatField', [], {'db_column': "'good_net_weight'"}),
'q8': ('django.db.models.fields.FloatField', [], {'db_column': "'damaged_net_weight'"})
},
'crs.waybillsent': {
'Meta': {'object_name': 'WayBillSent'},
'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
'q1': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"}),
'q2': ('django.db.models.fields.TextField', [], {'db_column': "'waybill_code'"}),
'q3': ('django.db.models.fields.DateField', [], {'db_column': "'sent_date'"}),
'q4': ('django.db.models.fields.TextField', [], {'null': 'True', 'db_column': "'transaction_type'"}),
'q5': ('django.db.models.fields.TextField', [], {'null': 'True', 'db_column': "'site_code'"}),
'q6': ('django.db.models.fields.TextField', [], {'db_column': "'sender_name'"}),
'q7': ('django.db.models.fields.TextField', [], {'db_column': "'truck_id'"}),
'q8': ('django.db.models.fields.TextField', [], {'db_column': "'food_type'"}),
'q9': ('django.db.models.fields.FloatField', [], {'db_column': "'weight'"})
}
}
complete_apps = ['crs']