# Generated by Django 4.2.17 on 2025-01-18 15:15

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Categoria_stock',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('categoria', models.CharField(max_length=100)),
                ('imagem', models.ImageField(null=True, upload_to='categoria_farmacia')),
                ('caixa', models.IntegerField(null=True)),
                ('status', models.IntegerField(default=1, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Categoria_stock_fixo',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('categoria', models.CharField(max_length=100)),
                ('imagem', models.ImageField(null=True, upload_to='categoria_farmacia')),
                ('caixa', models.IntegerField(null=True)),
                ('status', models.IntegerField(default=1, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='ControlGraficoAdmin',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('nome', models.CharField(max_length=50)),
                ('dados', models.IntegerField()),
            ],
            options={
                'verbose_name_plural': 'Dados do grafico',
            },
        ),
        migrations.CreateModel(
            name='Despesa',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('despesa', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Despesas',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('despesa', models.CharField(max_length=200, null=True)),
                ('valor', models.IntegerField(default=0, null=True)),
                ('descricao', models.CharField(max_length=300, null=True)),
                ('data', models.CharField(default='05/08/2024', max_length=20, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Facturas',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(default=0, null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('factura', models.TextField(default='', null=True)),
                ('preco', models.TextField(default='', null=True)),
                ('quantidade', models.TextField(default='', null=True)),
                ('data', models.CharField(max_length=20)),
                ('total', models.IntegerField(default=0, null=True)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Facturas_diarias',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(default=0, null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('factura', models.TextField(default='', null=True)),
                ('preco', models.TextField(default='', null=True)),
                ('quantidade', models.TextField(default='', null=True)),
                ('data', models.CharField(max_length=20)),
                ('total', models.IntegerField(default=0, null=True)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Feixo_data',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(default=0, null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('factura', models.CharField(max_length=5000)),
                ('quantidade', models.IntegerField()),
                ('data', models.CharField(max_length=20)),
                ('total', models.IntegerField(default=0, null=True)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Feixo_diario',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('nome_comercial', models.CharField(max_length=100)),
                ('nome_generico', models.CharField(max_length=100)),
                ('forma_farmaceutica', models.CharField(max_length=100)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('imagem', models.ImageField(upload_to='stock_farmacia')),
                ('quantidade', models.IntegerField()),
                ('preco', models.IntegerField()),
                ('lucro', models.IntegerField(default=0, null=True)),
                ('data_venda', models.CharField(max_length=20)),
                ('hora_venda', models.CharField(max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Feixo_diario_fixo',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True, verbose_name='Anfitriao')),
                ('produto', models.CharField(max_length=100, verbose_name='Produto')),
                ('imagem', models.ImageField(upload_to='produtos_farmacia')),
                ('quantidade', models.IntegerField(verbose_name='Quantidade')),
                ('preco', models.IntegerField(verbose_name='preco')),
                ('lucro', models.IntegerField(default=0, null=True, verbose_name='lucro')),
                ('data_venda', models.CharField(default='18/01/25', max_length=20)),
                ('hora_venda', models.CharField(default='17:15:21', max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Fornecedores',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('nome', models.CharField(max_length=200, null=True)),
                ('categoria', models.CharField(max_length=300, null=True)),
                ('contacto', models.CharField(max_length=20, null=True)),
                ('email', models.CharField(max_length=100, null=True)),
                ('localizacao', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Itens_Pedidos',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('id_pedido', models.IntegerField(null=True)),
                ('nome_generico', models.CharField(max_length=100, null=True)),
                ('nome_comercial', models.CharField(max_length=100, null=True)),
                ('lote', models.CharField(max_length=100, null=True)),
                ('quantidade', models.IntegerField(null=True)),
                ('preco_unitario', models.IntegerField(null=True)),
                ('total_liquido', models.IntegerField(null=True)),
                ('data', models.CharField(max_length=20, null=True)),
                ('data_validade', models.CharField(max_length=20, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Meus_Pedidos',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('nr_factura', models.IntegerField(null=True)),
                ('id_fornecedor', models.IntegerField(null=True)),
                ('fornecedor', models.CharField(max_length=200, null=True)),
                ('status', models.CharField(default='aberto', max_length=20, null=True)),
                ('total', models.IntegerField(null=True)),
                ('data', models.CharField(max_length=20, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Produto_vendido',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('nome_comercial', models.CharField(max_length=100)),
                ('nome_generico', models.CharField(max_length=100)),
                ('forma_farmaceutica', models.CharField(max_length=100)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('imagem', models.ImageField(upload_to='stock_farmacia')),
                ('quantidade', models.IntegerField()),
                ('preco', models.IntegerField()),
                ('lucro', models.IntegerField(default=0, null=True)),
                ('data_venda', models.CharField(max_length=20)),
                ('hora_venda', models.CharField(max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Produto_vendido_carinho',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_P', models.IntegerField(null=True)),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('nome_comercial', models.CharField(max_length=100)),
                ('nome_generico', models.CharField(max_length=100)),
                ('forma_farmaceutica', models.CharField(max_length=100)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('imagem', models.ImageField(upload_to='stock_farmacia')),
                ('quantidade', models.IntegerField()),
                ('preco', models.IntegerField()),
                ('lucro', models.IntegerField(default=0, null=True)),
                ('data_venda', models.CharField(max_length=20)),
                ('hora_venda', models.CharField(max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Produto_vendido_fixo',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True, verbose_name='Anfitriao')),
                ('produto', models.CharField(max_length=100, verbose_name='Produto')),
                ('imagem', models.ImageField(upload_to='produtos_farmacia')),
                ('quantidade', models.IntegerField(verbose_name='Quantidade')),
                ('preco', models.IntegerField(verbose_name='preco')),
                ('lucro', models.IntegerField(default=0, null=True, verbose_name='lucro')),
                ('data_venda', models.CharField(default='18/01/25', max_length=20)),
                ('hora_venda', models.CharField(default='17:15:21', max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Stok',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_categoria', models.IntegerField(default=0, null=True)),
                ('nome_generico', models.CharField(max_length=100)),
                ('nome_comercial', models.CharField(max_length=100)),
                ('forma_farmaceutica', models.CharField(max_length=100, null=True)),
                ('importadora', models.CharField(max_length=100, null=True)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('quantidade', models.IntegerField()),
                ('preco', models.IntegerField()),
                ('lucro', models.IntegerField(default=0, null=True)),
                ('imagem', models.ImageField(upload_to='stock_farmacia')),
                ('lote', models.CharField(max_length=20, null=True)),
                ('data_validade', models.CharField(max_length=20, null=True)),
                ('data_venda', models.CharField(max_length=20)),
                ('hora_venda', models.CharField(max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Stok_Armazem',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_stock', models.IntegerField(null=True)),
                ('id_categoria', models.IntegerField(default=0, null=True)),
                ('nome_generico', models.CharField(max_length=100)),
                ('nome_comercial', models.CharField(max_length=100)),
                ('forma_farmaceutica', models.CharField(max_length=100, null=True)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('quantidade', models.IntegerField(null=True)),
                ('preco', models.IntegerField(null=True)),
                ('lucro', models.IntegerField(default=0, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Stok_fixo',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_categoria', models.IntegerField(default=0, null=True)),
                ('produto', models.CharField(max_length=100)),
                ('imagem', models.ImageField(null=True, upload_to='produtos_farmacia')),
                ('preco', models.IntegerField()),
                ('lucro', models.IntegerField(default=0, null=True)),
                ('categoria', models.CharField(max_length=100, null=True)),
                ('data_venda', models.CharField(default='18/01/25', max_length=20)),
                ('hora_venda', models.CharField(default='17:15:21', max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Todos_Eventos',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_anfitriao', models.IntegerField(null=True)),
                ('id_resp', models.IntegerField(default=0, null=True)),
                ('tipo', models.CharField(max_length=100, null=True)),
                ('evento', models.CharField(max_length=100, null=True)),
                ('data', models.CharField(max_length=20)),
                ('responsavel', models.CharField(max_length=100, null=True)),
            ],
        ),
    ]