# -*- coding: utf-8 -*- from south.utils import datetime_utils as datetime from south.db import db from south.v2 import SchemaMigration from django.db import models class Migration(SchemaMigration): def forwards(self, orm): # Adding model 'UserProfile' db.create_table(u'customer_userprofile', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('profile_type', self.gf('django.db.models.fields.PositiveSmallIntegerField')()), ('boss_surname', self.gf('django.db.models.fields.CharField')(default='', max_length=30)), ('boss_name', self.gf('django.db.models.fields.CharField')(default='', max_length=30)), ('boss_midname', self.gf('django.db.models.fields.CharField')(default='', max_length=30)), ('inn', self.gf('django.db.models.fields.CharField')(default='', max_length=12)), ('ogrn', self.gf('django.db.models.fields.CharField')(default='', max_length=15)), ('okpo', self.gf('django.db.models.fields.CharField')(default='', max_length=10, blank=True)), ('glavbuh_surname', self.gf('django.db.models.fields.CharField')(default='', max_length=30, blank=True)), ('glavbuh_name', self.gf('django.db.models.fields.CharField')(default='', max_length=30, blank=True)), ('glavbuh_midname', self.gf('django.db.models.fields.CharField')(default='', max_length=30, blank=True)), ('address', self.gf('django.db.models.fields.CharField')(default='', max_length=256)), ('real_address', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('phone_code', self.gf('django.db.models.fields.CharField')(default='', max_length=10, blank=True)), ('phone', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('fax_code', self.gf('django.db.models.fields.CharField')(default='', max_length=10, blank=True)), ('fax', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('email', self.gf('django.db.models.fields.EmailField')(default='', max_length=75, blank=True)), ('site', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('svid_gos_reg', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('ip_reg_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('name', self.gf('django.db.models.fields.CharField')(default='', max_length=256)), ('full_name', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('kpp', self.gf('django.db.models.fields.CharField')(default='', max_length=9)), ('jur_address', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('boss_title', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('na_osnovanii', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('boss_sign', self.gf('django.db.models.fields.files.ImageField')(default='', max_length=100, blank=True)), ('glavbuh_sign', self.gf('django.db.models.fields.files.ImageField')(default='', max_length=100, blank=True)), ('stamp', self.gf('django.db.models.fields.files.ImageField')(default='', max_length=100, blank=True)), ('logo', self.gf('django.db.models.fields.files.ImageField')(default='', max_length=100, blank=True)), ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), ('active', self.gf('django.db.models.fields.BooleanField')(default=False)), ('confirmed', self.gf('django.db.models.fields.BooleanField')(default=False)), ('user_session_key', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), )) db.send_create_signal(u'customer', ['UserProfile']) # Adding model 'BankAccount' db.create_table(u'customer_bankaccount', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('company', self.gf('django.db.models.fields.related.ForeignKey')(related_name='bank_accounts', to=orm['customer.UserProfile'])), ('bik', self.gf('django.db.models.fields.CharField')(max_length=10)), ('name', self.gf('django.db.models.fields.CharField')(max_length=256)), ('address', self.gf('django.db.models.fields.CharField')(max_length=256)), ('korr_account', self.gf('django.db.models.fields.CharField')(max_length=20)), ('account', self.gf('django.db.models.fields.CharField')(max_length=20)), ('is_main', self.gf('django.db.models.fields.BooleanField')(default=False)), ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), )) db.send_create_signal(u'customer', ['BankAccount']) # Adding model 'Client' db.create_table(u'customer_client', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('company', self.gf('django.db.models.fields.related.ForeignKey')(related_name='clients', to=orm['customer.UserProfile'])), ('name', self.gf('django.db.models.fields.CharField')(max_length=256, db_index=True)), ('inn', self.gf('django.db.models.fields.CharField')(max_length=12)), ('kpp', self.gf('django.db.models.fields.CharField')(default='', max_length=9, blank=True)), ('okpo', self.gf('django.db.models.fields.CharField')(default='', max_length=10, blank=True)), ('address', self.gf('django.db.models.fields.CharField')(max_length=256)), ('bank_bik', self.gf('django.db.models.fields.CharField')(default='', max_length=10, blank=True)), ('bank_name', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('bank_address', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('bank_korr_account', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('bank_account', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('contact_name', self.gf('django.db.models.fields.CharField')(default='', max_length=50, blank=True)), ('contact_email', self.gf('django.db.models.fields.EmailField')(default='', max_length=50, blank=True)), ('contact_phone', self.gf('django.db.models.fields.CharField')(default='', max_length=50, blank=True)), ('contact_icq', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('contact_skype', self.gf('django.db.models.fields.CharField')(default='', max_length=20, blank=True)), ('contact_other', self.gf('django.db.models.fields.CharField')(default='', max_length=256, blank=True)), ('created_at', self.gf('django.db.models.fields.DateTimeField')(auto_now_add=True, blank=True)), ('updated_at', self.gf('django.db.models.fields.DateTimeField')(auto_now=True, blank=True)), )) db.send_create_signal(u'customer', ['Client']) # Adding model 'UserProfileFilters' db.create_table(u'customer_userprofilefilters', ( ('company', self.gf('django.db.models.fields.related.OneToOneField')(related_name='profile_filters', unique=True, primary_key=True, to=orm['customer.UserProfile'])), ('show_profile_type', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_inn', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_ogrn', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_okpo', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_glavbuh', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_bank_account', self.gf('django.db.models.fields.BooleanField')(default=True)), ('bank_account', self.gf('django.db.models.fields.related.ForeignKey')(default=None, related_name='+', null=True, blank=True, to=orm['customer.BankAccount'])), ('show_contact_info', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_real_address', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_phone', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_fax', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_email', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_site', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_ip_boss_fio', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_svid_gos_reg', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_ip_reg_date', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_name', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_full_name', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_kpp', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_org_boss_title_and_fio', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_na_osnovanii', self.gf('django.db.models.fields.BooleanField')(default=True)), ('show_jur_address', self.gf('django.db.models.fields.BooleanField')(default=True)), )) db.send_create_signal(u'customer', ['UserProfileFilters']) # Adding model 'License' db.create_table(u'customer_license', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('company', self.gf('django.db.models.fields.related.ForeignKey')(related_name='licenses', to=orm['customer.UserProfile'])), ('term', self.gf('django.db.models.fields.IntegerField')()), ('date_from', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('date_to', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('payform', self.gf('django.db.models.fields.IntegerField')(default=0)), ('status', self.gf('django.db.models.fields.IntegerField')(default=0)), ('order_date', self.gf('django.db.models.fields.DateField')(auto_now_add=True, blank=True)), ('paid_date', self.gf('django.db.models.fields.DateField')(null=True, blank=True)), ('pay_sum', self.gf('django.db.models.fields.IntegerField')()), ('deleted', self.gf('django.db.models.fields.BooleanField')(default=False)), )) db.send_create_signal(u'customer', ['License']) # Adding model 'LicensePrice' db.create_table(u'customer_licenseprice', ( (u'id', self.gf('django.db.models.fields.AutoField')(primary_key=True)), ('term', self.gf('django.db.models.fields.IntegerField')()), ('price', self.gf('django.db.models.fields.IntegerField')()), )) db.send_create_signal(u'customer', ['LicensePrice']) def backwards(self, orm): # Deleting model 'UserProfile' db.delete_table(u'customer_userprofile') # Deleting model 'BankAccount' db.delete_table(u'customer_bankaccount') # Deleting model 'Client' db.delete_table(u'customer_client') # Deleting model 'UserProfileFilters' db.delete_table(u'customer_userprofilefilters') # Deleting model 'License' db.delete_table(u'customer_license') # Deleting model 'LicensePrice' db.delete_table(u'customer_licenseprice') models = { u'customer.bankaccount': { 'Meta': {'ordering': "['-created_at']", 'object_name': 'BankAccount'}, 'account': ('django.db.models.fields.CharField', [], {'max_length': '20'}), 'address': ('django.db.models.fields.CharField', [], {'max_length': '256'}), 'bik': ('django.db.models.fields.CharField', [], {'max_length': '10'}), 'company': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'bank_accounts'", 'to': u"orm['customer.UserProfile']"}), 'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'is_main': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'korr_account': ('django.db.models.fields.CharField', [], {'max_length': '20'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '256'}), 'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) }, u'customer.client': { 'Meta': {'ordering': "['name', '-created_at']", 'object_name': 'Client'}, 'address': ('django.db.models.fields.CharField', [], {'max_length': '256'}), 'bank_account': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'bank_address': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'bank_bik': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'}), 'bank_korr_account': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'bank_name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'company': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'clients'", 'to': u"orm['customer.UserProfile']"}), 'contact_email': ('django.db.models.fields.EmailField', [], {'default': "''", 'max_length': '50', 'blank': 'True'}), 'contact_icq': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'contact_name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '50', 'blank': 'True'}), 'contact_other': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'contact_phone': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '50', 'blank': 'True'}), 'contact_skype': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'inn': ('django.db.models.fields.CharField', [], {'max_length': '12'}), 'kpp': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '9', 'blank': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'max_length': '256', 'db_index': 'True'}), 'okpo': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'}), 'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}) }, u'customer.license': { 'Meta': {'object_name': 'License'}, 'company': ('django.db.models.fields.related.ForeignKey', [], {'related_name': "'licenses'", 'to': u"orm['customer.UserProfile']"}), 'date_from': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'date_to': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'deleted': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'order_date': ('django.db.models.fields.DateField', [], {'auto_now_add': 'True', 'blank': 'True'}), 'paid_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'pay_sum': ('django.db.models.fields.IntegerField', [], {}), 'payform': ('django.db.models.fields.IntegerField', [], {'default': '0'}), 'status': ('django.db.models.fields.IntegerField', [], {'default': '0'}), 'term': ('django.db.models.fields.IntegerField', [], {}) }, u'customer.licenseprice': { 'Meta': {'object_name': 'LicensePrice'}, u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'price': ('django.db.models.fields.IntegerField', [], {}), 'term': ('django.db.models.fields.IntegerField', [], {}) }, u'customer.userprofile': { 'Meta': {'object_name': 'UserProfile'}, 'active': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'address': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256'}), 'boss_midname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30'}), 'boss_name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30'}), 'boss_sign': ('django.db.models.fields.files.ImageField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}), 'boss_surname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30'}), 'boss_title': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'confirmed': ('django.db.models.fields.BooleanField', [], {'default': 'False'}), 'created_at': ('django.db.models.fields.DateTimeField', [], {'auto_now_add': 'True', 'blank': 'True'}), 'email': ('django.db.models.fields.EmailField', [], {'default': "''", 'max_length': '75', 'blank': 'True'}), 'fax': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'fax_code': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'}), 'full_name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'glavbuh_midname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30', 'blank': 'True'}), 'glavbuh_name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30', 'blank': 'True'}), 'glavbuh_sign': ('django.db.models.fields.files.ImageField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}), 'glavbuh_surname': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '30', 'blank': 'True'}), u'id': ('django.db.models.fields.AutoField', [], {'primary_key': 'True'}), 'inn': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '12'}), 'ip_reg_date': ('django.db.models.fields.DateField', [], {'null': 'True', 'blank': 'True'}), 'jur_address': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'kpp': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '9'}), 'logo': ('django.db.models.fields.files.ImageField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}), 'na_osnovanii': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'name': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256'}), 'ogrn': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '15'}), 'okpo': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'}), 'phone': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '20', 'blank': 'True'}), 'phone_code': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '10', 'blank': 'True'}), 'profile_type': ('django.db.models.fields.PositiveSmallIntegerField', [], {}), 'real_address': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'site': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'stamp': ('django.db.models.fields.files.ImageField', [], {'default': "''", 'max_length': '100', 'blank': 'True'}), 'svid_gos_reg': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}), 'updated_at': ('django.db.models.fields.DateTimeField', [], {'auto_now': 'True', 'blank': 'True'}), 'user_session_key': ('django.db.models.fields.CharField', [], {'default': "''", 'max_length': '256', 'blank': 'True'}) }, u'customer.userprofilefilters': { 'Meta': {'object_name': 'UserProfileFilters'}, 'bank_account': ('django.db.models.fields.related.ForeignKey', [], {'default': 'None', 'related_name': "'+'", 'null': 'True', 'blank': 'True', 'to': u"orm['customer.BankAccount']"}), 'company': ('django.db.models.fields.related.OneToOneField', [], {'related_name': "'profile_filters'", 'unique': 'True', 'primary_key': 'True', 'to': u"orm['customer.UserProfile']"}), 'show_bank_account': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_contact_info': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_email': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_fax': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_full_name': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_glavbuh': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_inn': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_ip_boss_fio': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_ip_reg_date': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_jur_address': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_kpp': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_na_osnovanii': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_name': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_ogrn': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_okpo': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_org_boss_title_and_fio': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_phone': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_profile_type': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_real_address': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_site': ('django.db.models.fields.BooleanField', [], {'default': 'True'}), 'show_svid_gos_reg': ('django.db.models.fields.BooleanField', [], {'default': 'True'}) } } complete_apps = ['customer']