# Generated by Django 6.0.5 on 2026-05-08 01:15

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Aboutus',
            fields=[
                ('abid', models.AutoField(primary_key=True, serialize=False)),
                ('about', models.TextField()),
            ],
            options={
                'verbose_name': 'Aboutus',
                'verbose_name_plural': 'Aboutuss',
                'db_table': 'aboutus',
            },
        ),
        migrations.CreateModel(
            name='AdditionalFees',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('get_id', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('fee', models.CharField(max_length=200)),
                ('amount', models.CharField(db_column='Amount', max_length=200)),
            ],
            options={
                'verbose_name': 'AdditionalFees',
                'verbose_name_plural': 'AdditionalFeess',
                'db_table': 'additional_fees',
            },
        ),
        migrations.CreateModel(
            name='AffordabilityCheck',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('provider', models.CharField(blank=True, max_length=100, null=True)),
                ('endpoint', models.CharField(blank=True, max_length=100, null=True)),
                ('username', models.CharField(blank=True, max_length=50, null=True)),
                ('password', models.CharField(blank=True, max_length=50, null=True)),
                ('status', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'AffordabilityCheck',
                'verbose_name_plural': 'AffordabilityChecks',
                'db_table': 'affordability_check',
            },
        ),
        migrations.CreateModel(
            name='Attachment',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('get_id', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('attached_file', models.TextField()),
                ('date_time', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'Attachment',
                'verbose_name_plural': 'Attachments',
                'db_table': 'attachment',
            },
        ),
        migrations.CreateModel(
            name='B2cpaymentsresults',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('merchant_loan_ref', models.CharField(blank=True, db_column='MerchantLoanRef', default=0, max_length=50, null=True)),
                ('sasa_pay_ref', models.CharField(blank=True, db_column='SasaPayRef', default=0, max_length=50, null=True)),
                ('m_pesa_ref', models.CharField(blank=True, db_column='MPesaRef', default=0, max_length=50, null=True)),
                ('result_code', models.IntegerField(blank=True, db_column='ResultCode', default=0, null=True)),
                ('result_desc', models.TextField(blank=True, db_column='ResultDesc', null=True)),
                ('trans_amount', models.DecimalField(blank=True, db_column='TransAmount', decimal_places=2, default=0.0, max_digits=12, null=True)),
                ('sasa_pay_acc_balance', models.DecimalField(blank=True, db_column='SasaPayAccBalance', decimal_places=2, default=0.0, max_digits=12, null=True)),
                ('transaction_date', models.DateField(blank=True, db_column='TransactionDate', null=True)),
            ],
            options={
                'verbose_name': 'B2cpaymentsresults',
                'verbose_name_plural': 'B2cpaymentsresultss',
                'db_table': 'b2cpaymentsresults',
            },
        ),
        migrations.CreateModel(
            name='Backup',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tracking_id', models.CharField(max_length=200)),
                ('amount', models.CharField(max_length=200)),
                ('address', models.TextField()),
                ('date_time', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'Backup',
                'verbose_name_plural': 'Backups',
                'db_table': 'backup',
            },
        ),
        migrations.CreateModel(
            name='BankAccounts',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('bank_name', models.CharField(blank=True, db_column='bankName', max_length=50, null=True)),
                ('account_number', models.BigIntegerField(blank=True, db_column='accountNumber', null=True)),
                ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('transaction_type', models.CharField(db_column='transactionType', max_length=20)),
                ('gl_code', models.CharField(max_length=10)),
                ('source_gl_code', models.CharField(max_length=50)),
            ],
            options={
                'verbose_name': 'BankAccounts',
                'verbose_name_plural': 'BankAccountss',
                'db_table': 'bank_accounts',
            },
        ),
        migrations.CreateModel(
            name='Banner',
            fields=[
                ('banaid', models.AutoField(primary_key=True, serialize=False)),
                ('bannar', models.TextField()),
            ],
            options={
                'verbose_name': 'Banner',
                'verbose_name_plural': 'Banners',
                'db_table': 'banner',
            },
        ),
        migrations.CreateModel(
            name='Basic',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('borrower', models.IntegerField(blank=True, null=True)),
                ('basic_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('additional_fixed_allowance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('gross_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('statutory_deductions', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('loan_instalments', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('net_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('other_bank_loans', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('monthly_living_expenses', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('max_available', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
            ],
            options={
                'verbose_name': 'Basic',
                'verbose_name_plural': 'Basics',
                'db_table': 'basic',
            },
        ),
        migrations.CreateModel(
            name='Battachment',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('get_id', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('attached_file', models.TextField()),
                ('date_time', models.DateTimeField(auto_now_add=True)),
                ('document_type', models.CharField(blank=True, max_length=50, null=True)),
                ('file_size', models.CharField(blank=True, max_length=50, null=True)),
                ('file_ext', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'Battachment',
                'verbose_name_plural': 'Battachments',
                'db_table': 'battachment',
            },
        ),
        migrations.CreateModel(
            name='Borrowers',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('fname', models.CharField(max_length=200)),
                ('middlename', models.CharField(max_length=50)),
                ('lname', models.CharField(max_length=200)),
                ('email', models.CharField(blank=True, max_length=200, null=True)),
                ('phone', models.CharField(blank=True, max_length=200, null=True)),
                ('telephone', models.CharField(default='', max_length=50)),
                ('addrs1', models.TextField()),
                ('addrs2', models.TextField()),
                ('district', models.CharField(max_length=200)),
                ('country', models.CharField(max_length=200)),
                ('comment', models.TextField(blank=True, null=True)),
                ('account', models.CharField(max_length=200)),
                ('image', models.CharField(blank=True, max_length=200, null=True)),
                ('date_time', models.DateTimeField(auto_now_add=True)),
                ('status', models.CharField(max_length=200)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('gender', models.CharField(blank=True, max_length=10, null=True)),
                ('id_number', models.CharField(blank=True, max_length=25, null=True)),
                ('passport', models.CharField(blank=True, max_length=50, null=True)),
                ('credit_score', models.CharField(blank=True, max_length=25, null=True)),
                ('employment_status', models.CharField(blank=True, max_length=25, null=True)),
                ('employer', models.CharField(blank=True, max_length=50, null=True)),
                ('title', models.CharField(blank=True, max_length=50, null=True)),
                ('created_by', models.CharField(blank=True, max_length=50, null=True)),
                ('modified_by', models.CharField(blank=True, max_length=50, null=True)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('emp_code', models.CharField(blank=True, max_length=50, null=True)),
                ('salary', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('disposable_income', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('occupation', models.CharField(blank=True, max_length=50, null=True)),
                ('modified_on', models.DateTimeField(blank=True, null=True)),
                ('postal', models.IntegerField(blank=True, null=True)),
                ('ownership_type', models.CharField(blank=True, db_column='ownershipType', max_length=10, null=True)),
                ('member', models.BooleanField(default=False)),
                ('marital', models.CharField(max_length=30)),
                ('marriage_type', models.CharField(db_column='marriageType', max_length=30)),
            ],
            options={
                'verbose_name': 'Borrowers',
                'verbose_name_plural': 'Borrowerss',
                'db_table': 'borrowers',
            },
        ),
        migrations.CreateModel(
            name='BorrowersSalaries',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('borrower', models.IntegerField(blank=True, null=True)),
                ('basic_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('additional_fixed_allowance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('gross_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('statutory_deductions', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('loan_instalments', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('net_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('other_bank_loans', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('monthly_living_expenses', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('max_available', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
            ],
            options={
                'verbose_name': 'BorrowersSalaries',
                'verbose_name_plural': 'BorrowersSalariess',
                'db_table': 'borrowers_salaries',
            },
        ),
        migrations.CreateModel(
            name='Branches',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(blank=True, max_length=50, null=True)),
                ('location', models.CharField(blank=True, max_length=50, null=True)),
                ('code', models.CharField(blank=True, max_length=10, null=True)),
                ('status', models.CharField(blank=True, max_length=50, null=True)),
                ('sub_account', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'Branches',
                'verbose_name_plural': 'Branchess',
                'db_table': 'branches',
            },
        ),
        migrations.CreateModel(
            name='BureauRecords',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('batch', models.IntegerField(default=0)),
                ('borrower', models.IntegerField(default=0)),
                ('id_number', models.CharField(blank=True, max_length=25, null=True)),
                ('passport', models.CharField(blank=True, max_length=50, null=True)),
                ('baccount', models.CharField(max_length=200)),
                ('district', models.CharField(max_length=200)),
                ('country', models.CharField(max_length=200)),
                ('reason', models.TextField()),
                ('bureau_account_type', models.CharField(db_column='bureauAccountType', max_length=10)),
                ('modified_date', models.DateTimeField(blank=True, null=True)),
                ('lname', models.CharField(max_length=200)),
                ('fname', models.CharField(max_length=200)),
                ('gender', models.CharField(blank=True, max_length=10, null=True)),
                ('phone', models.CharField(blank=True, max_length=200, null=True)),
                ('employer', models.CharField(max_length=50)),
                ('application_date', models.DateTimeField(blank=True, null=True)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('loan_repayment_method', models.CharField(blank=True, max_length=10, null=True)),
                ('loan_payment_scheme', models.CharField(max_length=200)),
                ('postal', models.IntegerField(blank=True, null=True)),
                ('ownership_type', models.CharField(blank=True, max_length=10, null=True)),
                ('amount_topay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('loan_duration', models.CharField(default=0, max_length=50)),
                ('loan_duration_period', models.CharField(max_length=200)),
                ('status', models.CharField(max_length=200)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('branch', models.CharField(blank=True, max_length=50, null=True)),
                ('title', models.CharField(blank=True, max_length=50, null=True)),
                ('addrs2', models.TextField()),
                ('addrs1', models.TextField()),
            ],
            options={
                'verbose_name': 'BureauRecords',
                'verbose_name_plural': 'BureauRecordss',
                'db_table': 'bureau_records',
            },
        ),
        migrations.CreateModel(
            name='BureauSubmissions',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('batch', models.IntegerField(blank=True, null=True)),
                ('loan_records', models.IntegerField(blank=True, null=True)),
                ('status', models.CharField(blank=True, default='Scheduled', max_length=50, null=True)),
                ('action_date', models.DateTimeField(blank=True, null=True)),
                ('action_by', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'BureauSubmissions',
                'verbose_name_plural': 'BureauSubmissionss',
                'db_table': 'bureau_submissions',
            },
        ),
        migrations.CreateModel(
            name='Collateral',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('idm', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('name', models.CharField(max_length=200)),
                ('type_of_collateral', models.CharField(max_length=200)),
                ('model', models.CharField(max_length=200)),
                ('make', models.CharField(max_length=200)),
                ('serial_number', models.CharField(max_length=200)),
                ('estimated_price', models.CharField(max_length=200)),
                ('proof_of_ownership', models.TextField()),
                ('cimage', models.TextField()),
                ('observation', models.TextField()),
                ('loan', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'Collateral',
                'verbose_name_plural': 'Collaterals',
                'db_table': 'collateral',
            },
        ),
        migrations.CreateModel(
            name='Comments',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=55)),
                ('comment', models.TextField()),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('account', models.CharField(max_length=100)),
                ('customer', models.CharField(max_length=100)),
            ],
            options={
                'verbose_name': 'Comments',
                'verbose_name_plural': 'Commentss',
                'db_table': 'comments',
            },
        ),
        migrations.CreateModel(
            name='Countries',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(default='', max_length=50)),
                ('alpha_2', models.CharField(default='', max_length=200)),
                ('alpha_3', models.CharField(default='', max_length=200)),
            ],
            options={
                'verbose_name': 'Countries',
                'verbose_name_plural': 'Countriess',
                'db_table': 'countries',
            },
        ),
        migrations.CreateModel(
            name='DocumentsRequired',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(blank=True, max_length=50, null=True)),
                ('status', models.CharField(blank=True, max_length=10, null=True)),
            ],
            options={
                'verbose_name': 'DocumentsRequired',
                'verbose_name_plural': 'DocumentsRequireds',
                'db_table': 'documents_required',
            },
        ),
        migrations.CreateModel(
            name='EmployerDetails',
            fields=[
                ('id', models.IntegerField()),
                ('employee_no', models.BigIntegerField(blank=True, null=True)),
                ('employer_name', models.CharField(max_length=30)),
                ('department', models.CharField(max_length=50)),
                ('employer_code', models.CharField(blank=True, max_length=12, null=True)),
                ('designation', models.CharField(max_length=30)),
                ('engagement_date', models.DateField(blank=True, null=True)),
                ('employment_status', models.CharField(max_length=30)),
                ('retirement', models.DateField(blank=True, null=True)),
                ('employer_contact', models.BigIntegerField(blank=True, null=True)),
                ('telephone', models.IntegerField(blank=True, null=True)),
                ('employer_designation', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'EmployerDetails',
                'verbose_name_plural': 'EmployerDetailss',
                'db_table': 'employer_details',
            },
        ),
        migrations.CreateModel(
            name='EmpPermission',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=200)),
                ('module_name', models.CharField(max_length=350)),
                ('pcreate', models.CharField(max_length=20)),
                ('pread', models.CharField(max_length=20)),
                ('pupdate', models.CharField(max_length=20)),
                ('pdelete', models.CharField(max_length=20)),
            ],
            options={
                'verbose_name': 'EmpPermission',
                'verbose_name_plural': 'EmpPermissions',
                'db_table': 'emp_permission',
            },
        ),
        migrations.CreateModel(
            name='EmpRole',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('role', models.CharField(max_length=200)),
            ],
            options={
                'verbose_name': 'EmpRole',
                'verbose_name_plural': 'EmpRoles',
                'db_table': 'emp_role',
            },
        ),
        migrations.CreateModel(
            name='ETemplates',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('sender', models.CharField(max_length=200)),
                ('receiver_email', models.CharField(max_length=350)),
                ('subject', models.CharField(max_length=350)),
                ('msg', models.TextField()),
                ('time_date', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'ETemplates',
                'verbose_name_plural': 'ETemplatess',
                'db_table': 'etemplates',
            },
        ),
        migrations.CreateModel(
            name='FAQs',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('topic', models.TextField()),
                ('content', models.TextField()),
            ],
            options={
                'verbose_name': 'FAQs',
                'verbose_name_plural': 'FAQss',
                'db_table': 'faqs',
            },
        ),
        migrations.CreateModel(
            name='FinInfo',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('get_id', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('occupation', models.CharField(max_length=25)),
                ('mincome', models.CharField(max_length=200)),
                ('frequency', models.CharField(blank=True, max_length=10, null=True)),
            ],
            options={
                'verbose_name': 'FinInfo',
                'verbose_name_plural': 'FinInfos',
                'db_table': 'fin_info',
            },
        ),
        migrations.CreateModel(
            name='Footer',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('email', models.CharField(max_length=200)),
                ('pho', models.CharField(max_length=200)),
                ('face', models.CharField(max_length=200)),
                ('webs', models.CharField(max_length=200)),
                ('conh', models.CharField(max_length=200)),
                ('twi', models.CharField(max_length=200)),
                ('gplus', models.CharField(max_length=200)),
                ('ins', models.CharField(max_length=200)),
                ('yous', models.CharField(max_length=200)),
                ('about', models.TextField()),
                ('apply', models.TextField()),
                ('mission', models.TextField()),
                ('objective', models.TextField()),
                ('map', models.TextField()),
            ],
            options={
                'verbose_name': 'Footer',
                'verbose_name_plural': 'Footers',
                'db_table': 'footer',
            },
        ),
        migrations.CreateModel(
            name='GlCodes',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('code', models.CharField(max_length=50)),
                ('name', models.CharField(blank=True, max_length=100, null=True)),
                ('type_field', models.CharField(blank=True, db_column='type', max_length=50, null=True)),
                ('portfolio', models.CharField(blank=True, max_length=50, null=True)),
                ('balance', models.DecimalField(decimal_places=2, max_digits=16)),
            ],
            options={
                'verbose_name': 'GlCodes',
                'verbose_name_plural': 'GlCodess',
                'db_table': 'gl_codes',
            },
        ),
        migrations.CreateModel(
            name='GrazuriUser',
            fields=[
                ('userid', models.AutoField(primary_key=True, serialize=False)),
                ('name', models.CharField(max_length=200)),
                ('email', models.CharField(max_length=200)),
                ('gender', models.CharField(max_length=20)),
                ('id_number', models.IntegerField()),
                ('phone', models.CharField(max_length=200)),
                ('addr1', models.TextField()),
                ('addr2', models.TextField()),
                ('district', models.CharField(max_length=200)),
                ('country', models.CharField(max_length=200)),
                ('comment', models.CharField(max_length=200)),
                ('username', models.CharField(max_length=200)),
                ('password', models.CharField(max_length=200)),
                ('id', models.CharField(max_length=200)),
                ('image', models.TextField(blank=True, null=True)),
                ('role', models.CharField(max_length=200)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('passport', models.CharField(blank=True, max_length=50, null=True)),
                ('branch', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'GrazuriUser',
                'verbose_name_plural': 'GrazuriUsers',
                'db_table': 'user',
            },
        ),
        migrations.CreateModel(
            name='HIW',
            fields=[
                ('hid', models.AutoField(primary_key=True, serialize=False)),
                ('hiw', models.TextField()),
            ],
            options={
                'verbose_name': 'HIW',
                'verbose_name_plural': 'HIWs',
                'db_table': 'hiw',
            },
        ),
        migrations.CreateModel(
            name='JournalTransactions',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('date', models.DateTimeField(blank=True, null=True)),
                ('account', models.BigIntegerField(blank=True, null=True)),
                ('transaction', models.CharField(blank=True, max_length=50, null=True)),
                ('opening_balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('debit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('credit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('agent', models.CharField(blank=True, max_length=50, null=True)),
                ('tx_id', models.CharField(blank=True, max_length=50, null=True)),
                ('notes', models.CharField(blank=True, max_length=50, null=True)),
                ('filename', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'JournalTransactions',
                'verbose_name_plural': 'JournalTransactionss',
                'db_table': 'journal_transactions',
            },
        ),
        migrations.CreateModel(
            name='LoanAdditionalSettings',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('fee_description', models.CharField(blank=True, max_length=50, null=True)),
                ('percentage', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('fixed_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('is_penalty', models.IntegerField(blank=True, null=True)),
                ('is_initial_deduction', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'LoanAdditionalSettings',
                'verbose_name_plural': 'LoanAdditionalSettingss',
                'db_table': 'loan_additional_settings',
            },
        ),
        migrations.CreateModel(
            name='LoanDisbursements',
            fields=[
                ('pay_id', models.AutoField(primary_key=True, serialize=False)),
                ('loan', models.IntegerField(blank=True, null=True)),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('transaction', models.CharField(max_length=200)),
                ('disbursement_method', models.CharField(max_length=50)),
            ],
            options={
                'verbose_name': 'LoanDisbursements',
                'verbose_name_plural': 'LoanDisbursementss',
                'db_table': 'loan_disbursements',
            },
        ),
        migrations.CreateModel(
            name='LoanFees',
            fields=[
                ('loan_fees_id', models.AutoField(primary_key=True, serialize=False)),
                ('fee_name', models.CharField(blank=True, max_length=50, null=True)),
                ('fee_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('loan', models.IntegerField(blank=True, null=True)),
                ('date_added', models.DateTimeField(blank=True, null=True)),
                ('added_by', models.CharField(blank=True, max_length=50, null=True)),
                ('gl_code', models.CharField(max_length=20)),
                ('status', models.CharField(max_length=20)),
            ],
            options={
                'verbose_name': 'LoanFees',
                'verbose_name_plural': 'LoanFeess',
                'db_table': 'loan_fees',
            },
        ),
        migrations.CreateModel(
            name='LoanFeespayments',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('loan_fees_id', models.IntegerField()),
                ('loan_id', models.IntegerField()),
                ('loanaccount', models.CharField(default='', max_length=50)),
                ('trxno', models.CharField(default='', max_length=50)),
                ('paymentref', models.CharField(default='', max_length=50)),
                ('amount', models.DecimalField(decimal_places=2, max_digits=16)),
                ('date_added', models.DateTimeField()),
                ('added_by', models.CharField(default='', max_length=50)),
                ('gl_code', models.CharField(default='', max_length=50)),
            ],
            options={
                'verbose_name': 'LoanFeespayments',
                'verbose_name_plural': 'LoanFeespaymentss',
                'db_table': 'loan_feespayments',
            },
        ),
        migrations.CreateModel(
            name='LoanFeesSettings',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('fee_name', models.CharField(max_length=50)),
                ('fee_amount', models.DecimalField(decimal_places=2, max_digits=16)),
                ('min_loan', models.DecimalField(decimal_places=2, max_digits=16)),
                ('max_loan', models.DecimalField(decimal_places=2, max_digits=16)),
                ('deductible', models.CharField()),
                ('active_status', models.BooleanField(default=False)),
            ],
            options={
                'verbose_name': 'LoanFeesSettings',
                'verbose_name_plural': 'LoanFeesSettingss',
                'db_table': 'loan_fees_settings',
            },
        ),
        migrations.CreateModel(
            name='LoanfeesTable',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('loan_fees', models.CharField(blank=True, null=True)),
                ('insurance_on_total_loan', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'Loanfees',
                'verbose_name_plural': 'Loanfeess',
                'db_table': 'loanfees',
            },
        ),
        migrations.CreateModel(
            name='LoanGuarantors',
            fields=[
                ('guarantor_id', models.AutoField(primary_key=True, serialize=False)),
                ('borrower', models.IntegerField(default=0)),
                ('loan_id', models.IntegerField(default=0)),
                ('name', models.CharField(default='', max_length=100)),
                ('relationship', models.CharField(default='', max_length=100)),
                ('phone', models.CharField(default='', max_length=50)),
                ('status', models.CharField(default='', max_length=50)),
                ('remarks', models.CharField(default='', max_length=50)),
                ('image', models.CharField()),
                ('address', models.CharField(blank=True, max_length=100, null=True)),
            ],
            options={
                'verbose_name': 'LoanGuarantors',
                'verbose_name_plural': 'LoanGuarantorss',
                'db_table': 'loan_guarantors',
            },
        ),
        migrations.CreateModel(
            name='LoanInfo',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('borrower', models.IntegerField(default=0)),
                ('baccount', models.CharField(max_length=200)),
                ('reason', models.TextField()),
                ('amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('application_date', models.DateTimeField(blank=True, null=True)),
                ('agent', models.CharField(max_length=200)),
                ('loan_product', models.TextField()),
                ('repayment_remark', models.CharField(max_length=200)),
                ('amount_todisburse', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('amount_intrestatuodeducted', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('amount_topay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('pay_date', models.DateField(blank=True, null=True)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('teller', models.CharField(max_length=200)),
                ('status', models.CharField(max_length=200)),
                ('disbursement_status', models.CharField(max_length=200)),
                ('loan_num_of_repayments', models.CharField(max_length=200)),
                ('loan_payment_scheme', models.CharField(max_length=200)),
                ('loan_duration_period', models.CharField(max_length=200)),
                ('loan_duration', models.CharField(default=0, max_length=50)),
                ('loan_interest_period', models.CharField(max_length=200)),
                ('loan_interest', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('loan_interest_type', models.CharField(max_length=200)),
                ('loan_interest_method', models.CharField(max_length=200)),
                ('date_release', models.DateField(blank=True, null=True)),
                ('loan_disbursed_by_id', models.CharField(max_length=200)),
                ('upstatus', models.CharField(blank=True, max_length=50, null=True)),
                ('loan_maturity', models.DateField(blank=True, null=True)),
                ('modified_date', models.DateTimeField(blank=True, null=True)),
                ('modified_by', models.CharField(blank=True, max_length=50, null=True)),
                ('fees', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('branch', models.CharField(blank=True, max_length=50, null=True)),
                ('loan_repayment_method', models.CharField(blank=True, max_length=10, null=True)),
                ('ownership_type', models.CharField(blank=True, max_length=10, null=True)),
                ('payment_reference', models.CharField(blank=True, max_length=50, null=True)),
                ('status_reason', models.CharField(blank=True, max_length=100, null=True)),
                ('disbursed_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('interest_value', models.DecimalField(decimal_places=2, max_digits=16)),
                ('bureau_account_type', models.CharField(db_column='bureauAccountType', max_length=10)),
                ('gl_code', models.CharField(max_length=20)),
                ('resch', models.IntegerField(db_column='Resch', default=0)),
            ],
            options={
                'verbose_name': 'LoanInfo',
                'verbose_name_plural': 'LoanInfos',
                'db_table': 'loan_info',
            },
        ),
        migrations.CreateModel(
            name='Loanprocessingfeesx',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('custacc', models.CharField(default='', max_length=50)),
                ('trx_no', models.CharField(db_column='TrxNo', default='', max_length=50)),
                ('payment_ref', models.CharField(db_column='paymentRef', default='', max_length=50)),
                ('loan_no', models.CharField(blank=True, db_column='loanNo', default='', max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'Loanprocessingfeesx',
                'verbose_name_plural': 'Loanprocessingfeesxs',
                'db_table': 'loanprocessingfeesx',
            },
        ),
        migrations.CreateModel(
            name='LoanRescheduleTable',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('original_loan_no', models.CharField(max_length=65)),
                ('new_loan_no', models.CharField(max_length=65)),
                ('borrower_id', models.IntegerField()),
                ('original_loan_balance', models.DecimalField(decimal_places=2, max_digits=12)),
                ('fine_charged', models.DecimalField(decimal_places=2, max_digits=12)),
                ('payable_intrest', models.IntegerField()),
                ('new_loan_balance', models.DecimalField(decimal_places=2, max_digits=12)),
                ('Payable_instalments', models.DecimalField(decimal_places=2, max_digits=12)),
                ('repayment_cycle', models.TextField()),
                ('loan_officer', models.TextField()),
                ('approving_officer_1', models.TextField()),
                ('approving_officer_1_idno', models.CharField(max_length=100)),
                ('approving_officer_2', models.TextField()),
                ('approving_officer_2_idno', models.CharField(max_length=100)),
                ('Resch_date', models.DateField()),
            ],
            options={
                'verbose_name': 'LoanRescheduleTable',
                'verbose_name_plural': 'LoanRescheduleTables',
                'db_table': 'loan_reschedule_table',
            },
        ),
        migrations.CreateModel(
            name='LoanSettings',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('interest_rate', models.DecimalField(blank=True, null=True)),
                ('minimum_loan', models.IntegerField(blank=True, null=True)),
                ('maximum_loan', models.IntegerField(blank=True, null=True)),
                ('default_duration', models.IntegerField(blank=True, null=True)),
                ('payment_cycle', models.CharField(blank=True, max_length=50, null=True)),
                ('interest_method', models.CharField(blank=True, max_length=50, null=True)),
                ('loan_insurance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('collateral', models.CharField(blank=True, max_length=10, null=True)),
                ('minimum_loan_collateral', models.IntegerField(blank=True, null=True)),
                ('penalty_fees', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'LoanSettings',
                'verbose_name_plural': 'LoanSettingss',
                'db_table': 'loan_settings',
            },
        ),
        migrations.CreateModel(
            name='LoanStatuses',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('status', models.CharField(blank=True, max_length=50, null=True)),
                ('added_by', models.CharField(blank=True, max_length=50, null=True)),
                ('added_date', models.DateTimeField(auto_now_add=True, null=True)),
                ('loan', models.IntegerField(blank=True, null=True)),
                ('reason', models.CharField(blank=True, max_length=100, null=True)),
            ],
            options={
                'verbose_name': 'LoanStatuses',
                'verbose_name_plural': 'LoanStatusess',
                'db_table': 'loan_statuses',
            },
        ),
        migrations.CreateModel(
            name='Message',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('sender_id', models.CharField(max_length=200)),
                ('sender_name', models.CharField(max_length=200)),
                ('msg_to', models.CharField(max_length=200)),
                ('subject', models.CharField(max_length=300)),
                ('message', models.TextField()),
                ('date_time', models.DateTimeField(auto_now_add=True)),
                ('status', models.CharField(blank=True, default=0, null=True)),
            ],
            options={
                'verbose_name': 'Message',
                'verbose_name_plural': 'Messages',
                'db_table': 'message',
            },
        ),
        migrations.CreateModel(
            name='Mywallet',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=200)),
                ('t_to', models.CharField(max_length=200)),
                ('amount', models.CharField(db_column='Amount', max_length=200)),
                ('desc', models.CharField(db_column='Desc', max_length=200)),
                ('wtype', models.CharField(max_length=200)),
                ('tdate', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'Mywallet',
                'verbose_name_plural': 'Mywallets',
                'db_table': 'mywallet',
            },
        ),
        migrations.CreateModel(
            name='NextOfKinDetails',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('borrower', models.IntegerField(blank=True, null=True)),
                ('names', models.CharField(blank=True, max_length=50, null=True)),
                ('address', models.CharField(blank=True, max_length=50, null=True)),
                ('contact', models.CharField(blank=True, max_length=50, null=True)),
                ('email', models.CharField(blank=True, max_length=50, null=True)),
                ('employer', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'NextOfKinDetails',
                'verbose_name_plural': 'NextOfKinDetailss',
                'db_table': 'next_of_kin_details',
            },
        ),
        migrations.CreateModel(
            name='Paymenterrors',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('paymenterror', models.TextField()),
            ],
            options={
                'verbose_name': 'Paymenterrors',
                'verbose_name_plural': 'Paymenterrorss',
                'db_table': 'paymenterrors',
            },
        ),
        migrations.CreateModel(
            name='Payments',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=200)),
                ('account', models.CharField(max_length=200)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('customer', models.CharField(max_length=200)),
                ('loan', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('pay_date', models.DateTimeField(auto_now_add=True)),
                ('amount_to_pay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('remarks', models.TextField()),
                ('payment_method', models.CharField(blank=True, max_length=50, null=True)),
                ('reference', models.CharField(blank=True, max_length=50, null=True)),
                ('tr_id', models.CharField(max_length=20)),
                ('gl_code', models.CharField(max_length=20)),
                ('status', models.CharField(default='C', max_length=10)),
            ],
            options={
                'verbose_name': 'Payments',
                'verbose_name_plural': 'Paymentss',
                'db_table': 'payments',
            },
        ),
        migrations.CreateModel(
            name='PaymentSchedule',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('idm', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('term', models.CharField(max_length=200)),
                ('day', models.CharField(max_length=200)),
                ('schedule', models.CharField(max_length=200)),
                ('interest', models.CharField(max_length=200)),
                ('penalty', models.CharField(max_length=200)),
            ],
            options={
                'verbose_name': 'PaymentSchedule',
                'verbose_name_plural': 'PaymentSchedules',
                'db_table': 'payment_schedule',
            },
        ),
        migrations.CreateModel(
            name='PaySchedule',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('get_id', models.CharField(max_length=200)),
                ('tid', models.CharField(max_length=200)),
                ('schedule', models.CharField(max_length=200)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('interest', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('payment', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('principal_due', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('pay_type', models.CharField(blank=True, max_length=50, null=True)),
                ('fees', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('total_due', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('principal_payment', models.DecimalField(decimal_places=2, max_digits=16)),
                ('interest_payment', models.DecimalField(decimal_places=2, max_digits=16)),
                ('fees_payment', models.DecimalField(decimal_places=2, max_digits=16)),
                ('open_indicator', models.CharField(max_length=1)),
                ('penalty', models.DecimalField(decimal_places=2, max_digits=16)),
                ('penalty_payment', models.DecimalField(decimal_places=2, max_digits=16)),
                ('payment_tx_id', models.CharField(max_length=20)),
            ],
            options={
                'verbose_name': 'PaySchedule',
                'verbose_name_plural': 'PaySchedules',
                'db_table': 'pay_schedule',
            },
        ),
        migrations.CreateModel(
            name='Products',
            fields=[
                ('product_id', models.AutoField(primary_key=True, serialize=False)),
                ('product_name', models.CharField(max_length=50)),
                ('product_type', models.CharField(max_length=50)),
                ('account_type', models.CharField(db_column='accountType', max_length=10)),
                ('product_configuration', models.TextField()),
            ],
            options={
                'verbose_name': 'Products',
                'verbose_name_plural': 'Productss',
                'db_table': 'products',
            },
        ),
        migrations.CreateModel(
            name='ReversedPayments',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=200)),
                ('account', models.CharField(max_length=200)),
                ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('customer', models.CharField(max_length=200)),
                ('loan', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('pay_date', models.DateTimeField(auto_now_add=True)),
                ('amount_to_pay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)),
                ('remarks', models.TextField()),
                ('payment_method', models.CharField(blank=True, max_length=50, null=True)),
                ('reference', models.CharField(blank=True, max_length=50, null=True)),
                ('tx_id', models.CharField(blank=True, max_length=50, null=True)),
                ('gl_code', models.CharField(blank=True, max_length=50, null=True)),
                ('status', models.CharField(blank=True, default='C', max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'ReversedPayments',
                'verbose_name_plural': 'ReversedPaymentss',
                'db_table': 'reversed_payments',
            },
        ),
        migrations.CreateModel(
            name='SaccosMembers',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('firstname', models.CharField(blank=True, max_length=50, null=True)),
                ('middlename', models.CharField(blank=True, max_length=50, null=True)),
                ('surname', models.CharField(blank=True, max_length=50, null=True)),
                ('othername1', models.CharField(blank=True, max_length=50, null=True)),
                ('othername2', models.CharField(blank=True, max_length=50, null=True)),
                ('member_status', models.CharField(blank=True, max_length=50, null=True)),
                ('lastmodified', models.CharField(blank=True, max_length=50, null=True)),
                ('address', models.CharField(blank=True, max_length=200, null=True)),
                ('dateofbirt', models.CharField(blank=True, max_length=50, null=True)),
                ('email', models.CharField(blank=True, max_length=50, null=True)),
                ('gender', models.CharField(blank=True, max_length=50, null=True)),
                ('home_phone', models.CharField(blank=True, max_length=50, null=True)),
                ('id_number', models.CharField(blank=True, db_column='idNumber', max_length=50, null=True)),
                ('postal_address', models.CharField(blank=True, db_column='postalAddress', max_length=50, null=True)),
                ('physical_address', models.CharField(blank=True, db_column='physicalAddress', max_length=50, null=True)),
                ('mobilenumber', models.IntegerField(blank=True, null=True)),
            ],
            options={
                'verbose_name': 'SaccosMembers',
                'verbose_name_plural': 'SaccosMemberss',
                'db_table': 'saccos_members',
            },
        ),
        migrations.CreateModel(
            name='SasaPayIPN',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('mpesaref', models.CharField(max_length=100)),
                ('paidby', models.CharField(max_length=200)),
                ('amountpaid', models.DecimalField(decimal_places=6, default=0.0, max_digits=20)),
                ('paidon', models.DateField()),
                ('billref', models.CharField(default=0, max_length=50)),
            ],
            options={
                'verbose_name': 'SasaPayIPN',
                'verbose_name_plural': 'SasaPayIPNs',
                'db_table': 'sasapayipn',
            },
        ),
        migrations.CreateModel(
            name='SMS',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('sms_gateway', models.TextField()),
                ('username', models.TextField()),
                ('password', models.TextField()),
                ('api', models.TextField()),
                ('status', models.TextField()),
            ],
            options={
                'verbose_name': 'SMS',
                'verbose_name_plural': 'SMSs',
                'db_table': 'sms',
            },
        ),
        migrations.CreateModel(
            name='SMSMessages',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('phone', models.IntegerField(blank=True, null=True)),
                ('message', models.CharField(blank=True, null=True)),
                ('datetime', models.DateTimeField(blank=True, null=True)),
                ('response', models.CharField(blank=True, max_length=50, null=True)),
                ('url', models.CharField(blank=True, null=True)),
                ('loan', models.IntegerField()),
            ],
            options={
                'verbose_name': 'SMSMessages',
                'verbose_name_plural': 'SMSMessagess',
                'db_table': 'sms_messages',
            },
        ),
        migrations.CreateModel(
            name='STKPushResults',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('merchant_loan_ref', models.CharField(db_column='MerchantLoanRef', default=0, max_length=50)),
                ('sasa_pay_ref', models.CharField(db_column='SasaPayRef', max_length=20)),
                ('result_code', models.IntegerField(db_column='ResultCode', default=0)),
                ('result_desc', models.TextField(blank=True, db_column='ResultDesc', null=True)),
                ('trans_amount', models.DecimalField(db_column='TransAmount', decimal_places=2, max_digits=12)),
                ('transaction_date', models.DateField(blank=True, db_column='TransactionDate', null=True)),
            ],
            options={
                'verbose_name': 'STKPushResults',
                'verbose_name_plural': 'STKPushResultss',
                'db_table': 'stkpushresults',
            },
        ),
        migrations.CreateModel(
            name='Systemset',
            fields=[
                ('sysid', models.AutoField(primary_key=True, serialize=False)),
                ('title', models.CharField(max_length=200)),
                ('name', models.CharField(max_length=200)),
                ('footer', models.TextField()),
                ('abb', models.CharField(max_length=200)),
                ('fax', models.TextField()),
                ('currency', models.TextField()),
                ('website', models.TextField()),
                ('mobile', models.TextField()),
                ('image', models.CharField(max_length=200)),
                ('modal_image', models.CharField(max_length=200)),
                ('address', models.TextField()),
                ('email', models.TextField()),
                ('map', models.TextField()),
                ('stamp', models.CharField(max_length=350)),
                ('timezone', models.TextField()),
                ('sms_charges', models.CharField(max_length=200)),
                ('trading_name', models.CharField(blank=True, max_length=50, null=True)),
                ('srn', models.CharField(blank=True, max_length=50, null=True)),
                ('recipient', models.CharField(blank=True, max_length=50, null=True)),
                ('submission_cycle', models.CharField(blank=True, max_length=50, null=True)),
                ('day_of_submission', models.IntegerField(blank=True, null=True)),
                ('sftp_url', models.CharField(blank=True, max_length=100, null=True)),
                ('sftp_port', models.IntegerField(blank=True, null=True)),
                ('bureau_email', models.CharField(blank=True, max_length=50, null=True)),
                ('submission_method', models.CharField(blank=True, max_length=50, null=True)),
                ('bureau_submission', models.IntegerField(blank=True, null=True)),
                ('scoring', models.IntegerField(blank=True, null=True)),
                ('file_type', models.CharField(blank=True, max_length=50, null=True)),
                ('sftp_password', models.CharField(blank=True, max_length=100, null=True)),
                ('sftp_username', models.CharField(blank=True, max_length=50, null=True)),
                ('registration', models.CharField(max_length=20)),
            ],
            options={
                'verbose_name': 'Systemset',
                'verbose_name_plural': 'Systemsets',
                'db_table': 'systemset',
            },
        ),
        migrations.CreateModel(
            name='SystemTransactions',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('date', models.DateTimeField(blank=True, null=True)),
                ('account', models.BigIntegerField(blank=True, null=True)),
                ('transaction', models.CharField(blank=True, max_length=50, null=True)),
                ('opening_balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('debit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('credit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('agent', models.CharField(blank=True, max_length=50, null=True)),
                ('loan', models.IntegerField()),
                ('tx_id', models.CharField(max_length=20)),
            ],
            options={
                'verbose_name': 'SystemTransactions',
                'verbose_name_plural': 'SystemTransactionss',
                'db_table': 'system_transactions',
            },
        ),
        migrations.CreateModel(
            name='TempBorrowers',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('fname', models.CharField(blank=True, max_length=50, null=True)),
                ('lname', models.CharField(blank=True, max_length=50, null=True)),
                ('employer', models.CharField(blank=True, max_length=50, null=True)),
                ('salary', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('disposable', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('requestedloan', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)),
                ('session', models.CharField(blank=True, max_length=50, null=True)),
                ('agent', models.CharField(blank=True, max_length=50, null=True)),
                ('emp_code', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'verbose_name': 'TempBorrowers',
                'verbose_name_plural': 'TempBorrowerss',
                'db_table': 'temp_borrowers',
            },
        ),
        migrations.CreateModel(
            name='Transaction',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('txid', models.CharField(max_length=200)),
                ('t_type', models.CharField(max_length=200)),
                ('acctno', models.CharField(max_length=200)),
                ('fn', models.CharField(max_length=200)),
                ('ln', models.CharField(max_length=200)),
                ('email', models.CharField(max_length=300)),
                ('phone', models.CharField(max_length=200)),
                ('amount', models.CharField(max_length=200)),
                ('date_time', models.DateTimeField(auto_now_add=True)),
            ],
            options={
                'verbose_name': 'Transaction',
                'verbose_name_plural': 'Transactions',
                'db_table': 'transaction',
            },
        ),
        migrations.CreateModel(
            name='Twallet',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('tid', models.CharField(max_length=200)),
                ('total', models.CharField(db_column='Total', max_length=200)),
            ],
            options={
                'verbose_name': 'Twallet',
                'verbose_name_plural': 'Twallets',
                'db_table': 'twallet',
            },
        ),
        migrations.CreateModel(
            name='UnknownPayments',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('paidamt', models.DecimalField(decimal_places=2, default=0.0, max_digits=14)),
                ('paidby', models.CharField(max_length=230)),
                ('paidon', models.DateField()),
                ('msisdn', models.CharField(max_length=100)),
                ('reference', models.CharField(default='', max_length=50)),
                ('notes', models.CharField(default='', max_length=1020)),
                ('posted', models.IntegerField(default=0)),
            ],
            options={
                'verbose_name': 'UnknownPayments',
                'verbose_name_plural': 'UnknownPaymentss',
                'db_table': 'unknown_payments',
            },
        ),
    ]
