# Generated by Django 3.0.2 on 2020-01-13 03:23

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Stock',
            fields=[
                ('stockId', models.AutoField(primary_key=True, serialize=False)),
                ('stock_name', models.CharField(max_length=200)),
                ('price', models.DecimalField(decimal_places=2, max_digits=5)),
            ],
        ),
        migrations.CreateModel(
            name='Userstock',
            fields=[
                ('user_stockId', models.AutoField(primary_key=True, serialize=False)),
                ('stock_price', models.DecimalField(decimal_places=2, max_digits=19)),
                ('amount_invested', models.DecimalField(decimal_places=2, max_digits=19)),
                ('number_of_stock_bought', models.DecimalField(decimal_places=2, max_digits=19)),
                ('total_amount_invested', models.DecimalField(decimal_places=2, max_digits=19)),
                ('total_stock', models.DecimalField(decimal_places=2, max_digits=19)),
                ('pur_date', models.DateTimeField(verbose_name='date purchased')),
                ('stock_id', models.ForeignKey(db_column='stockId', on_delete=django.db.models.deletion.CASCADE, to='invest.Stock')),
            ],
        ),
    ]
