# -*- coding: utf-8 -*-
# Generated by Django 1.9 on 2017-04-23 15:19
from __future__ import unicode_literals

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Courses_Table',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course_id', models.CharField(max_length=6, unique=True)),
                ('course_name', models.CharField(max_length=50)),
                ('course_credits', models.IntegerField()),
                ('course_alias', models.CharField(default='None', max_length=15)),
            ],
        ),
        migrations.CreateModel(
            name='Date_wise_attendance',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateField()),
                ('number_of_hours', models.IntegerField(default=1)),
            ],
        ),
        migrations.CreateModel(
            name='Professor_Tables',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('username', models.CharField(max_length=10, unique=True)),
                ('Name', models.CharField(max_length=50)),
                ('password', models.CharField(max_length=15)),
                ('designation', models.CharField(max_length=30)),
                ('date_of_birth', models.DateField()),
            ],
        ),
        migrations.CreateModel(
            name='Student_attendance',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('classes_held', models.IntegerField(default=0)),
                ('classes_attended', models.IntegerField(default=0)),
                ('attendance_persentage', models.FloatField(default=0.0)),
            ],
        ),
        migrations.CreateModel(
            name='Student_course',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Courses_Table')),
            ],
        ),
        migrations.CreateModel(
            name='Students_Table',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('student_dept', models.CharField(max_length=3)),
                ('student_year', models.CharField(max_length=4)),
                ('student_section', models.CharField(max_length=1)),
                ('student_rollno', models.CharField(max_length=2)),
                ('student_name', models.CharField(max_length=50)),
            ],
        ),
        migrations.CreateModel(
            name='Teacher_Course',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('batch', models.CharField(max_length=4)),
                ('section', models.CharField(max_length=1)),
                ('courses_taken', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Courses_Table')),
                ('prof', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Professor_Tables')),
            ],
        ),
        migrations.AlterUniqueTogether(
            name='students_table',
            unique_together=set([('student_dept', 'student_year', 'student_section', 'student_rollno')]),
        ),
        migrations.AddField(
            model_name='student_course',
            name='student',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Students_Table'),
        ),
        migrations.AddField(
            model_name='student_attendance',
            name='student_course',
            field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='Validate.Student_course'),
        ),
        migrations.AddField(
            model_name='date_wise_attendance',
            name='student_attendance',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='Validate.Student_attendance'),
        ),
        migrations.AlterUniqueTogether(
            name='teacher_course',
            unique_together=set([('prof', 'courses_taken', 'batch', 'section')]),
        ),
        migrations.AlterUniqueTogether(
            name='student_course',
            unique_together=set([('student', 'course')]),
        ),
    ]