mangroveorg/datawinners

# -*- coding: 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):
        # Adding field 'WayBillReceived.data_record_id'
        db.add_column('crs_waybillreceived', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'Warehouse.data_record_id'
        db.add_column('crs_warehouse', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'WayBillReceivedPort.data_record_id'
        db.add_column('crs_waybillreceivedport', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'DistributionAtCPS.data_record_id'
        db.add_column('crs_distributionatcps', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'SiteActivities.data_record_id'
        db.add_column('crs_siteactivities', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'NumberOfRecipientServed.data_record_id'
        db.add_column('crs_numberofrecipientserved', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'BillOfLading.data_record_id'
        db.add_column('crs_billoflading', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'ContainerSent.data_record_id'
        db.add_column('crs_containersent', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'PhysicalInventorySheet.data_record_id'
        db.add_column('crs_physicalinventorysheet', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'BreakBulkSent.data_record_id'
        db.add_column('crs_breakbulksent', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'WayBillSent.data_record_id'
        db.add_column('crs_waybillsent', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'BAV.data_record_id'
        db.add_column('crs_bav', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

        # Adding field 'Distribution.data_record_id'
        db.add_column('crs_distribution', 'data_record_id',
                      self.gf('django.db.models.fields.TextField')(default=' '),
                      keep_default=False)

    def backwards(self, orm):
        # Deleting field 'WayBillReceived.data_record_id'
        db.delete_column('crs_waybillreceived', 'data_record_id')

        # Deleting field 'Warehouse.data_record_id'
        db.delete_column('crs_warehouse', 'data_record_id')

        # Deleting field 'WayBillReceivedPort.data_record_id'
        db.delete_column('crs_waybillreceivedport', 'data_record_id')

        # Deleting field 'DistributionAtCPS.data_record_id'
        db.delete_column('crs_distributionatcps', 'data_record_id')

        # Deleting field 'SiteActivities.data_record_id'
        db.delete_column('crs_siteactivities', 'data_record_id')

        # Deleting field 'NumberOfRecipientServed.data_record_id'
        db.delete_column('crs_numberofrecipientserved', 'data_record_id')

        # Deleting field 'BillOfLading.data_record_id'
        db.delete_column('crs_billoflading', 'data_record_id')

        # Deleting field 'ContainerSent.data_record_id'
        db.delete_column('crs_containersent', 'data_record_id')

        # Deleting field 'PhysicalInventorySheet.data_record_id'
        db.delete_column('crs_physicalinventorysheet', 'data_record_id')

        # Deleting field 'BreakBulkSent.data_record_id'
        db.delete_column('crs_breakbulksent', 'data_record_id')

        # Deleting field 'WayBillSent.data_record_id'
        db.delete_column('crs_waybillsent', 'data_record_id')

        # Deleting field 'BAV.data_record_id'
        db.delete_column('crs_bav', 'data_record_id')

        # Deleting field 'Distribution.data_record_id'
        db.delete_column('crs_distribution', 'data_record_id')

    models = {
        'crs.bav': {
            'Meta': {'object_name': 'BAV'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'bav_type'"}),
            'q2': ('django.db.models.fields.DateField', [], {'db_column': "'bav_date'"}),
            'q3': ('django.db.models.fields.IntegerField', [], {'db_column': "'no_of_recipients'"}),
            'q4': ('django.db.models.fields.FloatField', [], {'null': 'True', 'db_column': "'rice'"}),
            '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'"})
        },
        'crs.billoflading': {
            'Meta': {'object_name': 'BillOfLading'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            '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': "'shipment_type'"}),
            'q3': ('django.db.models.fields.DateField', [], {'db_column': "'issue_date'"}),
            'q4': ('django.db.models.fields.TextField', [], {'db_column': "'food_type'"}),
            'q5': ('django.db.models.fields.TextField', [], {'db_column': "'bill_of_lading_code'"}),
            'q6': ('django.db.models.fields.FloatField', [], {'db_column': "'weight'"})
        },
        'crs.breakbulksent': {
            'Meta': {'object_name': 'BreakBulkSent'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.DateField', [], {'db_column': "'sent_date'"}),
            'q2': ('django.db.models.fields.FloatField', [], {'db_column': "'weight'"}),
            'q3': ('django.db.models.fields.TextField', [], {'db_column': "'waybill_code'"}),
            'q4': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"})
        },
        'crs.containersent': {
            'Meta': {'object_name': 'ContainerSent'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'bill_of_lading'"}),
            'q2': ('django.db.models.fields.FloatField', [], {'db_column': "'weight'"}),
            'q3': ('django.db.models.fields.TextField', [], {'db_column': "'container_code'"})
        },
        'crs.distribution': {
            'Meta': {'object_name': 'Distribution'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'distribution_type': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'site_code'"}),
            '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'"})
        },
        'crs.distributionatcps': {
            'Meta': {'object_name': 'DistributionAtCPS'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'centre_code'"}),
            'q2': ('django.db.models.fields.DateField', [], {'db_column': "'received_date'"}),
            'q3': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"}),
            'q4': ('django.db.models.fields.FloatField', [], {'db_column': "'rice'"}),
            'q5': ('django.db.models.fields.FloatField', [], {'db_column': "'oil'"}),
            'q6': ('django.db.models.fields.FloatField', [], {'db_column': "'csb'"})
        },
        'crs.numberofrecipientserved': {
            'Meta': {'object_name': 'NumberOfRecipientServed'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'received_type'"}),
            'q2': ('django.db.models.fields.DateField', [], {'db_column': "'received_date'"}),
            'q3': ('django.db.models.fields.IntegerField', [], {'db_column': "'no_of_type1_recipient'"}),
            'q4': ('django.db.models.fields.IntegerField', [], {'db_column': "'no_of_type2_recipient'"}),
            'q5': ('django.db.models.fields.IntegerField', [], {'db_column': "'no_of_new_type1_recipient'"}),
            'q6': ('django.db.models.fields.IntegerField', [], {'db_column': "'no_of_new_type2_recipient'"})
        },
        'crs.physicalinventorysheet': {
            'Meta': {'object_name': 'PhysicalInventorySheet'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            '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'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            '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'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            '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'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            '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'"}),
            'q9': ('django.db.models.fields.TextField', [], {'null': 'True', 'db_column': "'transaction_type'"})
        },
        'crs.waybillreceivedport': {
            'Meta': {'object_name': 'WayBillReceivedPort'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'waybill_code'"}),
            'q2': ('django.db.models.fields.DateField', [], {'db_column': "'received_date'"}),
            'q3': ('django.db.models.fields.FloatField', [], {'db_column': "'good_weight'"}),
            'q4': ('django.db.models.fields.FloatField', [], {'db_column': "'damaged_weight'"}),
            'q5': ('django.db.models.fields.TextField', [], {'null': 'True', 'db_column': "'container_code'"})
        },
        'crs.waybillsent': {
            'Meta': {'object_name': 'WayBillSent'},
            'data_record_id': ('django.db.models.fields.TextField', [], {}),
            'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}),
            'q1': ('django.db.models.fields.TextField', [], {'db_column': "'pl_code'"}),
            'q10': ('django.db.models.fields.TextField', [], {'db_column': "'receiver_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': "'warehouse_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']