mangroveorg/datawinners

# 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):
        
        # Deleting model 'SFMDistribution'
        db.delete_table('crs_sfmdistribution')

        # Adding model 'Distribution'
        db.create_table('crs_distribution', (
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
            ('q1', self.gf('django.db.models.fields.TextField')(db_column='site_code')),
            ('q2', self.gf('django.db.models.fields.DateField')(db_column='distribution_date')),
            ('q3', self.gf('django.db.models.fields.TextField')(db_column='received_waybill_code')),
            ('q4', self.gf('django.db.models.fields.TextField')(db_column='returned_waybill_code')),
            ('q5', self.gf('django.db.models.fields.FloatField')(db_column='oil')),
            ('q6', self.gf('django.db.models.fields.FloatField')(db_column='csb')),
            ('q7', self.gf('django.db.models.fields.FloatField')(db_column='sorghum')),
            ('q8', self.gf('django.db.models.fields.FloatField')(db_column='rice')),
            ('q9', self.gf('django.db.models.fields.IntegerField')(db_column='returned_oil')),
            ('q10', self.gf('django.db.models.fields.IntegerField')(db_column='returned_csb')),
            ('q11', self.gf('django.db.models.fields.IntegerField')(db_column='returned_sorghum')),
            ('q12', self.gf('django.db.models.fields.IntegerField')(db_column='returned_rice')),
        ))
        db.send_create_signal('crs', ['Distribution'])


    def backwards(self, orm):
        
        # Adding model 'SFMDistribution'
        db.create_table('crs_sfmdistribution', (
            ('q1', self.gf('django.db.models.fields.TextField')(db_column='site_code')),
            ('q2', self.gf('django.db.models.fields.DateField')(db_column='distribution_date')),
            ('q3', self.gf('django.db.models.fields.TextField')(db_column='received_waybill_code')),
            ('q5', self.gf('django.db.models.fields.FloatField')(db_column='distributed_csb_quantity')),
            ('q4', self.gf('django.db.models.fields.FloatField')(db_column='distributed_oil_quantity')),
            ('q7', self.gf('django.db.models.fields.IntegerField')(db_column='returned_oil_quantity')),
            ('q6', self.gf('django.db.models.fields.TextField')(db_column='returned_waybill_code')),
            ('q8', self.gf('django.db.models.fields.IntegerField')(db_column='returned_csb_quantity')),
            ('id', self.gf('django.db.models.fields.AutoField')(primary_key=True)),
        ))
        db.send_create_signal('crs', ['SFMDistribution'])

        # Deleting model 'Distribution'
        db.delete_table('crs_distribution')


    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', [], {'db_column': "'returned_csb'"}),
            'q11': ('django.db.models.fields.IntegerField', [], {'db_column': "'returned_sorghum'"}),
            'q12': ('django.db.models.fields.IntegerField', [], {'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', [], {'db_column': "'oil'"}),
            'q6': ('django.db.models.fields.FloatField', [], {'db_column': "'csb'"}),
            'q7': ('django.db.models.fields.FloatField', [], {'db_column': "'sorghum'"}),
            'q8': ('django.db.models.fields.FloatField', [], {'db_column': "'rice'"}),
            'q9': ('django.db.models.fields.IntegerField', [], {'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']