class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(max_length=254, unique=True)), ('user_type', models.PositiveSmallIntegerField(choices=[(0, 'admin'), (1, 'client'), (2, 'fournisseur')])), ('tel', models.CharField(blank=True, max_length=10, null=True)), ('sexe', models.CharField(choices=[('M', 'Masculin'), ('F', 'Feminin')], max_length=1)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Categorie', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nom', models.CharField(max_length=50)), ], ), migrations.CreateModel( name='Client', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Facture', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField(default=django.utils.timezone.now)), ('client', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='factures', to='bill.Client')), ], ), migrations.CreateModel( name='Fournisseur', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Produit', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('designation', models.CharField(max_length=50)), ('prix', models.FloatField(default=0)), ('categorie', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='produits', to='bill.Categorie')), ('fournisseur', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='produits', to='bill.Fournisseur')), ], ), migrations.CreateModel( name='LigneFacture', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('qte', models.IntegerField(default=1)), ('facture', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='lignes', to='bill.Facture')), ('produit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='lignes', to='bill.Produit')), ], ), migrations.CreateModel( name='Admin', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddConstraint( model_name='lignefacture', constraint=models.UniqueConstraint(fields=('produit', 'facture'), name='produit-facture'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('type', models.CharField(choices=[('student', 'Student'), ('tutor', 'Tutor')], max_length=20)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Location', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('city', models.CharField(max_length=255)), ('street_address', models.CharField(max_length=255)), ('zip_code', models.CharField(max_length=255)), ('latitude', models.FloatField()), ('longitude', models.FloatField()), ], ), migrations.CreateModel( name='Student', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date_of_birth', models.DateField(blank=True, null=True)), ('gender', models.CharField(blank=True, max_length=50)), ('locations', models.ManyToManyField(related_name='_student_locations_+', to='accounts.Location')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='Tutor', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date_of_birth', models.DateField(blank=True, null=True)), ('gender', models.CharField(blank=True, max_length=50)), ('hourly_rate', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)), ('available', models.BooleanField(default=True)), ('locations', models.ManyToManyField(related_name='_tutor_locations_+', to='accounts.Location')), ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='tutor', to=settings.AUTH_USER_MODEL)), ], options={ 'abstract': False, }, ), migrations.AddField( model_name='student', name='tutors', field=models.ManyToManyField(related_name='students', to='accounts.Tutor'), ), migrations.AddField( model_name='student', name='user', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='student', to=settings.AUTH_USER_MODEL), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('name', models.CharField(max_length=32, verbose_name='Name')), ('surname', models.CharField(max_length=32, verbose_name='Surname')), ('email', models.EmailField(max_length=254, verbose_name='Email')), ('tel', models.CharField(max_length=15, null=True, verbose_name='Telephone number')), ('address', models.CharField(max_length=120, verbose_name='Address')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Booking', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('book_date', models.DateField(verbose_name='Date')), ('status', models.CharField(max_length=20, verbose_name='Status')), ], ), migrations.CreateModel( name='Car', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('vin', models.CharField(max_length=36)), ('car_number', models.CharField(max_length=36)), ], ), migrations.CreateModel( name='CarFuel', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='CarList', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('model_specifiction', models.TextField()), ('power', models.FloatField()), ('mileage', models.FloatField()), ('year', models.IntegerField()), ('fuel', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarFuel')), ], ), migrations.CreateModel( name='CarMake', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='CarModel', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='CarTransmission', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='Chat', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.TextField(verbose_name='Message')), ('finished', models.BooleanField(default=False, verbose_name='Finished')), ], ), migrations.CreateModel( name='Request', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('answered', models.BooleanField(default=False)), ('answered_date', models.DateField(blank=True)), ('car', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarList')), ], ), migrations.CreateModel( name='ServiceHistory', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('end_date', models.DateField()), ('price', models.FloatField()), ('details', models.TextField()), ('finished', models.BooleanField(default=False)), ('review', models.IntegerField()), ('request', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.Request')), ], ), migrations.CreateModel( name='ServiceList', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ('price', models.FloatField()), ('active', models.BooleanField(default=False)), ('car_make', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarMake')), ], ), migrations.CreateModel( name='BusinessUser', fields=[ ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL, verbose_name='User')), ('company_name', models.CharField(max_length=32, verbose_name='Company Name')), ('reg', models.IntegerField(verbose_name='Reg')), ('vat', models.IntegerField(verbose_name='Vat')), ], ), migrations.CreateModel( name='Merchant', fields=[ ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('company_name', models.CharField(max_length=120, verbose_name='Company Name')), ('autoservice_name', models.CharField(max_length=120, verbose_name='Auto Service Name')), ('reg', models.IntegerField(verbose_name='Reg')), ('vat', models.IntegerField(verbose_name='Vat')), ('iban', models.CharField(max_length=120, verbose_name='Iban')), ('description', models.TextField(verbose_name='Description')), ('photo_url', models.ImageField(blank=True, upload_to='', verbose_name='Photo')), ('approved', models.BooleanField(default=False, verbose_name='Approve')), ], ), migrations.AddField( model_name='request', name='client', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='request', name='service', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.ServiceList'), ), migrations.AddField( model_name='chat', name='receiver', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='receivers', to=settings.AUTH_USER_MODEL, verbose_name='Receiver'), ), migrations.AddField( model_name='chat', name='sender', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='senders', to=settings.AUTH_USER_MODEL, verbose_name='Sender'), ), migrations.AddField( model_name='carlist', name='make', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarMake'), ), migrations.AddField( model_name='carlist', name='model', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarModel'), ), migrations.AddField( model_name='carlist', name='transmission', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarTransmission'), ), migrations.AddField( model_name='car', name='car_type', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.CarList', verbose_name='Car Type'), ), migrations.AddField( model_name='car', name='owner', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='user', name='groups', field=models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'), ), migrations.AddField( model_name='user', name='user_permissions', field=models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'), ), migrations.AddField( model_name='servicelist', name='merchant', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.Merchant'), ), migrations.AddField( model_name='booking', name='merchant', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='general.Merchant', verbose_name='Merchant'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='CustomUser', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('user_type', models.CharField(choices=[(1, 'HOD'), (2, 'Staff'), (3, 'Student')], default=1, max_length=10)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Attendance', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('attendance_date', models.DateField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Category', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=200)), ], ), migrations.CreateModel( name='Courses', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('course_name', models.CharField(max_length=255)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='FacultyMember', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(blank=True, max_length=50)), ('department', models.CharField(blank=True, max_length=50)), ('designation', models.CharField(blank=True, max_length=50)), ('qualification', models.CharField(blank=True, max_length=500)), ('experience', models.CharField(blank=True, max_length=500)), ('awards', models.CharField(blank=True, max_length=500)), ], ), migrations.CreateModel( name='HeroCarousal', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('alt_text', models.CharField(max_length=200, null=True)), ('carousal_image', models.ImageField(null=True, upload_to='banner/')), ('url_link', models.URLField(null=True)), ('status', models.CharField(choices=[('Featured', 'Featured'), ('Not Featured', 'Not Featured')], default='Not Featured', max_length=15)), ('caption', models.CharField(max_length=100, null=True)), ], ), migrations.CreateModel( name='Notice', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=200, null=True)), ('description', models.TextField(max_length=1000, null=True)), ('created_on', models.DateTimeField(null=True)), ('is_featured', models.CharField(choices=[('True', 'Yes'), ('False', 'No')], default='False', max_length=10, null=True)), ], ), migrations.CreateModel( name='SessionYearModel', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('session_start_year', models.DateField()), ('session_end_year', models.DateField()), ], ), migrations.CreateModel( name='Subjects', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('subject_name', models.CharField(max_length=255)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('course_id', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Courses')), ('staff_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Students', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('gender', models.CharField(max_length=50)), ('profile_pic', models.FileField(upload_to='profile/%Y/%m/%d')), ('address', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('myconfirm_password', models.CharField(max_length=200, null=True)), ('admin', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('course_id', models.ForeignKey( default=1, on_delete=django.db.models.deletion.DO_NOTHING, to='student_management_app.Courses')), ('session_year_id', models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='student_management_app.SessionYearModel')), ], ), migrations.CreateModel( name='StudentResult', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('subject_exam_marks', models.FloatField(default=0)), ('subject_assignment_marks', models.FloatField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('student_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Students')), ('subject_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Subjects')), ], ), migrations.CreateModel( name='Staffs', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('address', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('admin', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='NotificationStudent', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('message', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('student_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Students')), ], ), migrations.CreateModel( name='NotificationStaffs', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('message', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('stafff_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Staffs')), ], ), migrations.CreateModel( name='LeaveReportStudent', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('leave_date', models.CharField(max_length=255)), ('leave_message', models.TextField()), ('leave_status', models.IntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('student_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Students')), ], ), migrations.CreateModel( name='LeaveReportStaff', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('leave_date', models.CharField(max_length=255)), ('leave_message', models.TextField()), ('leave_status', models.IntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('staff_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Staffs')), ], ), migrations.CreateModel( name='FeedBackStudent', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('feedback', models.TextField()), ('feedback_reply', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('student_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Students')), ], ), migrations.CreateModel( name='FeedBackStaffs', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('feedback', models.TextField()), ('feedback_reply', models.TextField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('staff_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Staffs')), ], ), migrations.CreateModel( name='Events', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=200)), ('featured_image', models.ImageField(null=True, upload_to='events/%Y/%m/%d')), ('content', models.TextField(max_length=1000, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('status', models.CharField(choices=[('Draft', 'Draft'), ('Publish', 'Publish')], default='Draft', max_length=10)), ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Category')), ], ), migrations.CreateModel( name='AttendanceReport', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('status', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('attendance_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student_management_app.Attendance')), ('student_id', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='student_management_app.Students')), ], ), migrations.AddField( model_name='attendance', name='session_year_id', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='student_management_app.SessionYearModel'), ), migrations.AddField( model_name='attendance', name='subject_id', field=models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='student_management_app.Subjects'), ), migrations.CreateModel( name='AdminHOD', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('admin', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Collectdevice', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cd_active', models.IntegerField(default=0)), ('cd_name', models.CharField(max_length=32, null=True)), ('cd_series_number', models.IntegerField()), ('cd_tunnel', models.CharField(max_length=32)), ('cd_status', models.CharField(max_length=20)), ('cd_data_status', models.CharField(max_length=20)), ('cd_last_contract_time', models.DateTimeField()), ('cd_register_time', models.DateTimeField()), ], ), migrations.CreateModel( name='Company', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ('company_icon', models.ImageField(upload_to='cicons/%Y%m%d')), ('company_name', models.CharField(max_length=32, unique=True)), ('company_address', models.CharField(max_length=64, unique=True)), ('active', models.IntegerField(default=0)), ('context', models.CharField(max_length=128, null=True)), ], ), migrations.CreateModel( name='Device', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('d_u_id', models.IntegerField(default=None, null=True)), ('d_active', models.IntegerField(default=0)), ('d_name', models.CharField(max_length=32)), ('d_series_number', models.IntegerField()), ('d_tunnel', models.CharField(max_length=32)), ('d_status', models.CharField(max_length=20)), ('d_data_status', models.CharField(max_length=20)), ('d_last_contract_time', models.DateTimeField()), ('d_register_time', models.DateTimeField()), ('d_c_id', models.ForeignKey(db_column='d_c_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.collectdevice')), ], ), migrations.CreateModel( name='Knowledge', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('k_user_id', models.IntegerField()), ('k_title', models.CharField(max_length=32)), ('k_type', models.CharField(max_length=10)), ('k_date', models.DateTimeField()), ('k_content', models.CharField(max_length=20000)), ], ), migrations.CreateModel( name='KnowledgeMediaStore', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('m_k_id', models.CharField(db_column='m_k_id', max_length=10, null=True)), ('m_k_filepath', models.ImageField(upload_to='kmedia/%Y%m%d')), ('m_type', models.CharField(max_length=10)), ('m_date', models.DateTimeField()), ], ), migrations.CreateModel( name='Project', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('p_active', models.IntegerField(default=0, null=True)), ('p_name', models.CharField(max_length=32)), ('p_description', models.CharField(max_length=300, null=True)), ('p_type', models.CharField(max_length=20, null=True)), ('p_customer_type', models.CharField(max_length=20, null=True)), ('p_party_a', models.CharField(max_length=30)), ('p_purchase_time', models.DateTimeField(null=True)), ('p_setup_time', models.DateTimeField(null=True)), ('p_built_time', models.DateTimeField(null=True)), ('p_contact_name', models.CharField(max_length=20, null=True)), ('p_contact_number', models.CharField(max_length=11, null=True)), ('p_province', models.CharField(max_length=10, null=True)), ('p_city', models.CharField(max_length=10, null=True)), ('p_address', models.CharField(max_length=100, null=True)), ('p_longitude', models.DecimalField(decimal_places=20, max_digits=30, null=True)), ('p_latitude', models.DecimalField(decimal_places=20, max_digits=30, null=True)), ('p_c_id', models.ForeignKey(db_column='p_c_id', default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='One.company')), ], ), migrations.CreateModel( name='Test', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('t', models.ImageField(upload_to='tmedia/%Y%m%d')), ], ), migrations.CreateModel( name='Worksheet', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('w_name', models.CharField(max_length=20)), ('w_type', models.CharField(max_length=20)), ('w_content', models.CharField(max_length=2000)), ('w_status', models.CharField(max_length=10)), ('w_time', models.DateTimeField()), ], ), migrations.CreateModel( name='LoginUser', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('phone_numbers', models.CharField(max_length=11, unique=True, verbose_name='手机号')), ('u_company_id', models.IntegerField(null=True)), ('u_icon', models.ImageField(null=True, upload_to='uicons/%Y%m%d')), ('u_type', models.CharField(max_length=10, null=True)), ('tag', models.CharField(max_length=20, null=True)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('project', models.ManyToManyField(to='One.Project')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Worksheetmedia', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('wm_w_image', models.ImageField(upload_to='wmedia/%Y%m%d')), ('wm_date', models.DateTimeField()), ('wm_w_id', models.ForeignKey(db_column='wm_w_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.worksheet')), ], ), migrations.AddField( model_name='worksheet', name='w_e_id', field=models.ForeignKey( db_column='w_e_id', default=None, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.CreateModel( name='Solution', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('s_title', models.CharField(max_length=32)), ('s_type', models.CharField(max_length=20)), ('s_date', models.DateTimeField()), ('s_content', models.CharField(max_length=20000)), ('s_k_id', models.ForeignKey(db_column='s_k_id', on_delete=django.db.models.deletion.CASCADE, to='One.knowledge')), ('s_user_id', models.ForeignKey(db_column='s_user_id', default=None, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='project', name='p_u_id', field=models.ForeignKey( db_column='p_u_id', default=None, on_delete=django.db.models.deletion.CASCADE, related_name='apply', to=settings.AUTH_USER_MODEL, verbose_name='申请人'), ), migrations.CreateModel( name='Message', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.TextField(blank=True, null=True, verbose_name='内容')), ('unread', models.BooleanField(db_index=True, default=True, verbose_name='是否未读')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')), ('recipient', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='receive_messages', to=settings.AUTH_USER_MODEL, verbose_name='接收者')), ('sender', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='sent_message', to=settings.AUTH_USER_MODEL, verbose_name='发送者')), ], ), migrations.CreateModel( name='Devicemaintainrecord', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('dmo_name', models.CharField(max_length=20, null=True)), ('dm_d_detail', models.CharField(max_length=2000)), ('dm_time', models.DateTimeField()), ('dm_d_id', models.ForeignKey(db_column='dm_d_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.device')), ('dm_o_id', models.ForeignKey(db_column='dm_o_id', default=None, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Devicedata', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('ddd_name', models.CharField(max_length=32)), ('ddd_data', models.FloatField()), ('ddd_d_id', models.ForeignKey(db_column='ddd_d_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.device')), ], ), migrations.AddField( model_name='device', name='d_m_id', field=models.ForeignKey( db_column='d_mm_id', default=None, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='device', name='d_p_id', field=models.ForeignKey( db_column='d_p_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.project'), ), migrations.CreateModel( name='Data', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('d_name', models.CharField(max_length=20)), ('d_data', models.FloatField()), ('d_d_id', models.ForeignKey(db_column='d_d_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.device')), ], ), migrations.CreateModel( name='Complainrecord', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cr_detail', models.CharField(max_length=200)), ('cr_date', models.DateTimeField()), ('cr_type', models.CharField(max_length=10)), ('cr_e_id', models.ForeignKey( blank=True, db_column='cr_e_id', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='receiver', to=settings.AUTH_USER_MODEL)), ('cr_u_id', models.ForeignKey( blank=True, db_column='cr_u_id', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='sender', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='company', name='c_u_id', field=models.OneToOneField( db_column='c_u_id', default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.CreateModel( name='Comment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cm_detail', models.CharField(max_length=200)), ('cm_date', models.DateTimeField()), ('cm_type', models.CharField(max_length=10)), ('cm_e_id', models.ForeignKey( blank=True, db_column='cm_e_id', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='service', to=settings.AUTH_USER_MODEL)), ('cm_u_id', models.ForeignKey( blank=True, db_column='cm_u_id', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='customer', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='collectdevice', name='cd_m_id', field=models.ForeignKey( db_column='cd_m_id', default=None, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='collectdevice', name='cd_p_id', field=models.ForeignKey( db_column='cd_p_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.project'), ), migrations.CreateModel( name='Cdevicedata', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cdd_name', models.CharField(max_length=32)), ('cdd_data', models.CharField(max_length=32)), ('cdd_c_id', models.ForeignKey(db_column='cd_p_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.collectdevice')), ], ), migrations.CreateModel( name='Alert', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('a_highest_line', models.FloatField(null=True)), ('a_highest_level', models.CharField(max_length=10, null=True)), ('a_highest_tip', models.CharField(max_length=20, null=True)), ('a_high_line', models.FloatField(null=True)), ('a_high_level', models.CharField(max_length=10, null=True)), ('a_high_tip', models.CharField(max_length=20, null=True)), ('a_low_line', models.FloatField(null=True)), ('a_low_level', models.CharField(max_length=10, null=True)), ('a_low_tip', models.CharField(max_length=20, null=True)), ('a_lowest_line', models.FloatField(null=True)), ('a_lowest_level', models.CharField(max_length=10, null=True)), ('a_lowest_tip', models.CharField(max_length=20, null=True)), ('a_data_id', models.ForeignKey(db_column='a_data_id', default=None, on_delete=django.db.models.deletion.CASCADE, to='One.data')), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='Usuario', fields=[ ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('username', models.CharField(max_length=150, primary_key=True, serialize=False, verbose_name='username')), ('is_active', models.BooleanField(default=True, verbose_name='is active')), ('is_staff', models.BooleanField(default=True, verbose_name='staff status')), ('is_superuser', models.BooleanField(default=False, verbose_name='superuser status')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'User', 'verbose_name_plural': 'Users', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Avaliador', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ], ), migrations.CreateModel( name='Coordenador', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ], ), migrations.CreateModel( name='CriterioAvaliacao', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descricao', models.CharField(max_length=200, verbose_name='Nome')), ('nota_minima', models.FloatField(verbose_name='Nota Mínima')), ('nota_maxima', models.FloatField(verbose_name='Nota Maxima')), ('ajuda_avaliador', models.CharField(max_length=500, verbose_name='Nome')), ('incremento_nota', models.PositiveIntegerField( verbose_name='Incremento da Nota')), ], ), migrations.CreateModel( name='Cronograma', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('etapa', models.CharField(max_length=200, verbose_name='Etapa')), ('marco', models.CharField(max_length=200, verbose_name='Marco')), ('inicio', models.DateField(verbose_name='Data Inicial')), ('fim', models.DateField(verbose_name='Data Final')), ], ), migrations.CreateModel( name='Documento', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nome', models.CharField(max_length=200, verbose_name='Nome')), ], ), migrations.CreateModel( name='Edital', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('tipo', models.CharField(help_text='Discente/Bolsista', max_length=100, verbose_name='Tipo')), ('programa', models.CharField(max_length=100, verbose_name='Programa')), ('numero', models.CharField(blank=True, max_length=50, null=True, verbose_name='Número')), ('siglaUO', models.CharField(help_text='Ex.: DG-EAD/IFRN', max_length=100, verbose_name='Unidade organizacional')), ('linkEdital', models.URLField(help_text='Informe o LINK onde está o edital', max_length=300, verbose_name='URL')), ('grupo', models.CharField(max_length=200, null=True, verbose_name='Grupo')), ('descricao', models.CharField(max_length=300, verbose_name='Descrição')), ('ano', models.PositiveIntegerField(help_text='Digite o ano', verbose_name='Ano')), ('periodo', models.PositiveIntegerField(choices=[(1, '1º Período'), (2, '2º Período')], verbose_name='Período letivo')), ('data_publicacao', models.DateTimeField(verbose_name='Data de publicação')), ], ), migrations.CreateModel( name='EstrategiaClassificacao', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descriaco', models.CharField(help_text='Exemplo: Inscrição sem anexos', max_length=200, verbose_name='Descrição')), ], ), migrations.CreateModel( name='Fase', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nome', models.CharField(max_length=200, verbose_name='Nome')), ('tipo_classificacao', models.PositiveIntegerField( choices=[(1, 'Eliminatória'), (2, 'Classificatória')], verbose_name='Tipo de classificação')), ('aproveitamento_min', models.PositiveIntegerField( help_text='Nota necessária para passar', verbose_name='Aproveitamento mínimo')), ('fator_habilitacao', models.PositiveIntegerField( help_text= 'Quantidade máxima de cadidatos que serão selecionados', verbose_name='Fator habilitação')), ('edital', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Edital')), ], ), migrations.CreateModel( name='MotivoNotaZero', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descriaco', models.CharField(help_text='Exemplo: Inscrição sem anexos', max_length=200, verbose_name='Descrição')), ('fase', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase')), ], ), migrations.CreateModel( name='Pagamento', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('existe_taxa', models.BooleanField(default=False)), ('valor_taxa', models.DecimalField(decimal_places=2, max_digits=7)), ('vencimento_boleto', models.DateField()), ('edital', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Edital')), ], ), migrations.CreateModel( name='Vaga', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('curso', models.CharField(max_length=200, verbose_name='Curso')), ('vaga', models.CharField(max_length=100, verbose_name='Vaga')), ('numero_vagas', models.PositiveIntegerField(verbose_name='Número de vagas')), ('edital', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Edital')), ], ), migrations.AddField( model_name='estrategiaclassificacao', name='fase', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase'), ), migrations.AddField( model_name='documento', name='fase', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase'), ), migrations.AddField( model_name='cronograma', name='fase', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase'), ), migrations.AddField( model_name='criterioavaliacao', name='fase', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase'), ), migrations.AddField( model_name='coordenador', name='edital', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Edital'), ), migrations.AddField( model_name='coordenador', name='usuario', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='avaliador', name='fase', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='cadastro_edital.Fase'), ), migrations.AddField( model_name='avaliador', name='usuario', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Employment_type', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(db_index=True, max_length=30, verbose_name='Name')), ], options={ 'verbose_name': 'Employment', 'verbose_name_plural': 'Employments', 'ordering': ['name'], }, ), migrations.CreateModel( name='Skill', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(db_index=True, max_length=30, verbose_name='Name')), ], options={ 'verbose_name': 'Skill', 'verbose_name_plural': 'Skills', 'ordering': ['name'], }, ), migrations.CreateModel( name='Subcategory', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(db_index=True, max_length=30, verbose_name='Name')), ('img', models.FileField(blank=True, null=True, upload_to='img', verbose_name='Subcategory_img')), ], options={ 'verbose_name': 'Subcategory', 'verbose_name_plural': 'Subcategories', 'ordering': ['name'], }, ), migrations.CreateModel( name='Сategory', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(db_index=True, max_length=30, verbose_name='Name')), ('img', models.FileField(blank=True, null=True, upload_to='img', verbose_name='Сategory_img')), ], options={ 'verbose_name': 'Сategory', 'verbose_name_plural': 'Categories', 'ordering': ['name'], }, ), migrations.CreateModel( name='Vacancie', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=50, verbose_name='Title')), ('description', models.TextField(blank=True, null=True, verbose_name='Description')), ('img', models.ImageField(blank=True, null=True, upload_to='img', verbose_name='Vacancy_img')), ('email', models.EmailField(max_length=50, verbose_name='Email')), ('location', models.TextField(blank=True, null=True, verbose_name='Location')), ('salary', models.FloatField(blank=True, null=True)), ('company', models.CharField(blank=True, max_length=70, null=True, verbose_name='Company')), ('url', models.CharField(blank=True, max_length=50, null=True, verbose_name='Url')), ('published', models.DateTimeField(auto_now_add=True, db_index=True, verbose_name='Published')), ('requirements', models.TextField(blank=True, null=True, verbose_name='requirements')), ('tasks', models.TextField(blank=True, null=True, verbose_name='Tasks')), ('terms', models.TextField(blank=True, null=True, verbose_name='Terms')), ('telegram', models.CharField(blank=True, max_length=50, null=True, verbose_name='Telegram')), ('category', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='main.сategory', verbose_name='Сategory')), ('employment', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='main.employment_type', verbose_name='Employmet type')), ('skill', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='main.skill', verbose_name='Skill')), ('subcategores', models.ManyToManyField(to='main.Subcategory', verbose_name='Subcategory')), ], options={ 'verbose_name': 'Vacancy', 'verbose_name_plural': 'Vacancies', 'ordering': ['-published'], }, ), migrations.CreateModel( name='AdvUser', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('is_activated', models.BooleanField(db_index=True, default=True, verbose_name='Is active?')), ('send_messages', models.BooleanField(default=True, verbose_name='Send alerts?')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('is_student', models.BooleanField(default=False)), ('is_teacher', models.BooleanField(default=False)), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Class', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('location', models.CharField(max_length=50)), ('time_day', models.CharField(choices=[('MON', 'Monday'), ('TUE', 'Tuesday'), ('WED', 'Wednesday'), ('THU', 'Thursday'), ('FRI', 'Friday'), ('SAT', 'Saturday'), ('SUN', 'Sunday')], default='WED', max_length=3)), ('time_start', models.TimeField(default=datetime.time(15, 30))), ('time_end', models.TimeField(default=datetime.time(16, 30))), ], ), migrations.CreateModel( name='MemberLevel', fields=[ ('level_status', models.CharField(choices=[('B', 'Bronze'), ('S', 'Silver'), ('G', 'Gold'), ('P', 'Platinum'), ('D', 'Diamond')], default='B', max_length=1, primary_key=True, serialize=False)), ('price', models.FloatField()), ], ), migrations.CreateModel( name='Member', fields=[ ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('funds', models.FloatField(default=0)), ('expired_date', models.DateField(default=datetime.date(2019, 5, 29))), ('name', models.CharField(max_length=100)), ('email', models.EmailField(max_length=254)), ('phone_number', models.CharField( blank=True, max_length=17, validators=[ django.core.validators.RegexValidator( message= "Phone number must be entered in the format: '+999999999'. Up to 15 digits allowed.", regex='^\\+?1?\\d{9,15}$') ])), ('classes', models.ManyToManyField(to='login.Class')), ('level', models.ForeignKey(default='B', on_delete=django.db.models.deletion.CASCADE, to='login.MemberLevel')), ], ), migrations.CreateModel( name='Staff', fields=[ ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('name', models.CharField(max_length=100)), ], ), migrations.AddField( model_name='user', name='groups', field=models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'), ), migrations.AddField( model_name='user', name='user_permissions', field=models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'), ), migrations.AddField( model_name='class', name='staff', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='login.Staff'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('is_customer', models.BooleanField(default=False)), ('is_sp', models.BooleanField(default=False)), ('first_name', models.CharField(blank=True, max_length=50, null=True)), ('last_name', models.CharField(blank=True, max_length=100, null=True)), ('email', models.EmailField(max_length=254)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Order', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date_of_order', models.DateField(auto_now_add=True, null=True)), ('no_of_orders', models.CharField(max_length=100, null=True)), ('last_date', models.DateField(null=True)), ], ), migrations.CreateModel( name='Customer', fields=[ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='account.user')), ('phone_number', models.CharField(max_length=10)), ('alt_phone_number', models.CharField(blank=True, max_length=10, null=True)), ('date_create', models.DateTimeField(default=django.utils.timezone.now)), ], ), migrations.CreateModel( name='PlaceAnOrder', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.CharField(choices=[('Pending', 'Pending'), ('out for Delivery', 'out for Delivery'), ('Delivered', 'Delivered'), ('Cancel', 'Cancel')], default='Pending', max_length=200, null=True)), ('new_date', models.DateField(auto_now_add=True, null=True)), ('time', models.TimeField(null=True)), ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.order')), ], ), migrations.CreateModel( name='CustomerMenuItem', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('item_name', models.CharField(max_length=500)), ('price', models.CharField(max_length=20)), ('quantity', models.PositiveIntegerField()), ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.placeanorder')), ], ), migrations.CreateModel( name='Address', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('state', models.CharField(max_length=150)), ('city', models.CharField(max_length=100)), ('pin_no', models.CharField(max_length=20)), ('Area_name', models.CharField(max_length=200)), ('land_mark', models.CharField(max_length=200)), ('building_name', models.CharField(max_length=200)), ('flate_number', models.CharField(max_length=100)), ('date_of_order', models.DateField(auto_now_add=True)), ('total_amount', models.FloatField(null=True)), ('placeanorder', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.placeanorder')), ], ), migrations.CreateModel( name='ServiceProvider', fields=[ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='account.user')), ('admin_name', models.CharField(max_length=100)), ('company_name', models.CharField(max_length=200)), ('phone_no', models.CharField(max_length=10)), ('alt_phone_no', models.CharField(max_length=10)), ('state', models.CharField(max_length=150)), ('city', models.CharField(max_length=100)), ('pin_no', models.CharField(max_length=20)), ('Area_name', models.CharField(max_length=200)), ('land_mark', models.CharField(max_length=200)), ('building_name', models.CharField(max_length=200)), ('flate_number', models.CharField(max_length=100)), ('customer', models.ManyToManyField(to='account.Customer')), ], ), migrations.AddField( model_name='order', name='customer', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='account.customer'), ), migrations.AddField( model_name='order', name='sp', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.serviceprovider'), ), migrations.CreateModel( name='Menu', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('item_name', models.CharField(max_length=500)), ('price', models.CharField(max_length=20)), ('category', models.CharField(max_length=200, null=True)), ('sp', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='account.serviceprovider')), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Case', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('dateConfirmed', models.DateField()), ('caseType', models.CharField(choices=[('Local', 'Local'), ('Imported', 'Imported')], max_length=8)), ], ), migrations.CreateModel( name='Location', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('address', models.CharField(max_length=300)), ('x', models.FloatField(default=0.0)), ('y', models.FloatField(default=0.0)), ], ), migrations.CreateModel( name='Patient', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(default='', max_length=80)), ('idNumber', models.CharField(max_length=20)), ('dateOfBirth', models.DateField()), ], ), migrations.CreateModel( name='Virus', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=30)), ('commonName', models.CharField(max_length=50)), ('maxInfectiousPeriod', models.IntegerField(default=0)), ], options={ 'verbose_name_plural': 'Viruses', }, ), migrations.CreateModel( name='Visit', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('dateFrom', models.DateField()), ('dateTo', models.DateField()), ('category', models.CharField(choices=[('Visit', 'Visit'), ('Residence', 'Residence'), ('Workplace', 'Workplace')], max_length=20)), ('case', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='locations.case')), ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='locations.location')), ], ), migrations.AddField( model_name='case', name='patient', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='locations.patient'), ), migrations.AddField( model_name='case', name='virus', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='locations.virus'), ), migrations.CreateModel( name='StaffUser', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('chpStaffNumber', models.CharField(max_length=7, unique=True, verbose_name='CHP Staff Number')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0008_alter_user_username_max_length'), ] operations = [ migrations.CreateModel( name='SpecialistMessageList', fields=[ ('id', models.IntegerField(primary_key=True, serialize=False)), ('photo', models.CharField(blank=True, max_length=240)), ('nick', models.CharField(blank=True, max_length=40)), ('date', models.DateField(blank=True)), ('title', models.CharField(blank=True, max_length=240)), ('total', models.IntegerField(blank=True)), ('client', models.IntegerField(blank=True)), ('specialist', models.IntegerField(blank=True)), ], options={ 'managed': False, 'db_table': 'specialist_message_list', }, ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('nick', models.CharField(blank=True, max_length=45, null=True, verbose_name='nick')), ('email_exact', models.CharField(max_length=150, unique=True, verbose_name='email')), ('telephone', models.CharField(blank=True, max_length=14, null=True, verbose_name='phone')), ('cellphone', models.CharField(blank=True, max_length=14, null=True, verbose_name='cellphone')), ('photo', models.CharField(max_length=250, null=True, verbose_name='photo')), ('document_type', models.PositiveIntegerField(choices=[(1, 'DNI'), (2, 'Passport'), (3, 'Foreign Card')], verbose_name='type document')), ('document_number', models.CharField(max_length=45, verbose_name='document number')), ('img_document_number', models.CharField(max_length=250, null=True, verbose_name='upload document')), ('ruc', models.CharField(blank=True, max_length=40, null=True)), ('code', models.CharField(max_length=45, verbose_name='code')), ('anonymous', models.BooleanField(default=True, verbose_name='anonymous')), ('updated_at', models.DateTimeField(auto_now_add=True, verbose_name='updated at')), ('foreign_address', models.CharField(blank=True, max_length=200, null=True, verbose_name='foreign address')), ('key', models.CharField(blank=True, max_length=90, null=True)), ('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Activate'), (3, 'Reject'), (4, 'Deactivated')], default=1)), ], options={ 'verbose_name_plural': 'users', 'abstract': False, 'verbose_name': 'user', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Address', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('street', models.CharField(blank=True, max_length=100)), ], ), migrations.CreateModel( name='Bank', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200, verbose_name='Bank')), ('code', models.CharField(max_length=10)), ], ), migrations.CreateModel( name='Category', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45, unique=True)), ('image', models.CharField(max_length=169)), ('description', models.CharField(max_length=255)), ('fixed_commission', models.DecimalField(decimal_places=2, max_digits=10, null=True)), ('variable_commission', models.DecimalField(decimal_places=2, max_digits=10, null=True)), ], ), migrations.CreateModel( name='Ciiu', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=4, unique=True)), ('description', models.CharField(max_length=255)), ], ), migrations.CreateModel( name='Clasification', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('created_at', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='Contract', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('url_file', models.CharField(max_length=255)), ('created_at', models.DateField(auto_now_add=True)), ('active', models.BooleanField(default=False)), ('validity_months', models.PositiveIntegerField()), ('expiration_date', models.DateField()), ], ), migrations.CreateModel( name='ContractType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('descripcion', models.CharField(max_length=200)), ], ), migrations.CreateModel( name='Countries', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=90, unique=True)), ('code_phone', models.CharField(max_length=4)), ('iso_code', models.CharField(max_length=4, unique=True)), ], ), migrations.CreateModel( name='Department', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=55)), ], ), migrations.CreateModel( name='District', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=55)), ], ), migrations.CreateModel( name='EconomicSector', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ], ), migrations.CreateModel( name='FeeMonthSeller', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('start_month', models.DateField()), ('fee_plans', models.PositiveIntegerField()), ('fee_contacts', models.PositiveIntegerField()), ('complete_fee_products', models.PositiveIntegerField()), ('created_at', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='GroupMessage', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.PositiveIntegerField()), ], ), migrations.CreateModel( name='LevelInstruction', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ], ), migrations.CreateModel( name='LogPaymentsCreditCard', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('successful', models.BooleanField()), ('description', models.CharField(max_length=50)), ('code_api', models.CharField(max_length=100)), ], ), migrations.CreateModel( name='Match', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('price', models.DecimalField(decimal_places=2, max_digits=10)), ], ), migrations.CreateModel( name='MatchAcquired', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('price', models.DecimalField(decimal_places=2, max_digits=10)), ('cause', models.TextField()), ('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Declined')])), ('paid_by_client', models.BooleanField(default=True)), ('paid_by_specialist', models.BooleanField(default=False)), ], ), migrations.CreateModel( name='MatchAcquiredFiles', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('file_url', models.CharField(max_length=100)), ('type_file', models.PositiveIntegerField(choices=[(2, 'Image'), (3, 'Voice'), (4, 'Document')])), ('match_acquired', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.MatchAcquired')), ], ), migrations.CreateModel( name='MatchAcquiredLog', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('changed_on', models.DateTimeField(auto_now_add=True)), ('action', models.CharField(max_length=50)), ('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Declined')])), ('declined', models.NullBooleanField()), ('declined_motive', models.CharField(max_length=255, null=True)), ('match_acquired', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.MatchAcquired')), ], ), migrations.CreateModel( name='Message', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.TextField(blank=True)), ('msg_type', models.CharField(blank=True, choices=[('q', 'query'), ('r', 'requery'), ('a', 'answer')], max_length=1)), ('created_at', models.DateTimeField(auto_now_add=True)), ('content_type', models.PositiveIntegerField(choices=[(1, 'Text'), (2, 'Image'), (3, 'Video'), (4, 'Voice'), (5, 'Document')])), ('viewed', models.BooleanField(default=False)), ('file_url', models.CharField(blank=True, max_length=100)), ('code', models.CharField(max_length=45, verbose_name='code')), ('room', models.CharField(max_length=200)), ('group', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.GroupMessage')), ('message_reference', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='ref', to='api.Message')), ], ), migrations.CreateModel( name='MonthlyFee', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('fee_amount', models.DecimalField(decimal_places=2, max_digits=10)), ('fee_order_number', models.PositiveIntegerField()), ('fee_quantity', models.PositiveIntegerField()), ('reference_number', models.CharField(max_length=20)), ('pay_before', models.DateField()), ('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Paid')])), ], ), migrations.CreateModel( name='NotificationsBack', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('message', models.CharField(max_length=255, verbose_name='message')), ('viewed', models.BooleanField(default=False, verbose_name='viewed')), ('created_at', models.DateTimeField(auto_now_add=True)), ('code', models.CharField(max_length=200)), ], ), migrations.CreateModel( name='Objection', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=65)), ], ), migrations.CreateModel( name='Parameter', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('parameter', models.CharField(max_length=45)), ('value', models.CharField(max_length=50)), ], ), migrations.CreateModel( name='Payment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('amount', models.FloatField()), ('operation_number', models.CharField(max_length=12)), ('agency_code', models.CharField(max_length=10)), ('account_number_drawer', models.CharField(max_length=50)), ('check_number', models.CharField(max_length=50)), ('credit_cart_number', models.CharField(max_length=30)), ('credit_card_cvc', models.CharField(max_length=3)), ('credit_card_exp_date', models.DateField()), ('authorization_date', models.DateTimeField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('status', models.PositiveIntegerField(choices=[(1, 'Pending'), (2, 'Accepted'), (3, 'Declined')])), ('observations', models.CharField(max_length=255)), ], ), migrations.CreateModel( name='PaymentType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('description', models.CharField(max_length=200, null=True)), ('status', models.BooleanField(default=True)), ], ), migrations.CreateModel( name='Permmission', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=150)), ('description', models.CharField(max_length=220)), ('code', models.CharField(max_length=12)), ], ), migrations.CreateModel( name='ProductType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('description', models.CharField(max_length=200)), ('created_at', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='Province', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=55)), ('department', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Department')), ], ), migrations.CreateModel( name='Query', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=100)), ('status', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Answered'), (4, 'To score'), (5, 'Absolved')])), ('created_at', models.DateTimeField(auto_now_add=True)), ('last_modified', models.DateTimeField(auto_now=True)), ('calification', models.PositiveSmallIntegerField(null=True)), ('changed_on', models.DateTimeField(auto_now=True, null=True)), ], ), migrations.CreateModel( name='QueryLogs', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('action', models.CharField(max_length=10)), ('description', models.CharField(max_length=200, null=True)), ('changed_on', models.DateTimeField()), ('status_log', models.PositiveIntegerField(choices=[(1, 'Requested'), (2, 'Accepted'), (3, 'Answered'), (4, 'To score'), (5, 'Absolved')])), ('derived', models.NullBooleanField()), ('declined', models.NullBooleanField()), ('declined_motive', models.TextField(null=True)), ('query', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Query')), ], ), migrations.CreateModel( name='QueryPlans', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('query_quantity', models.IntegerField()), ('validity_months', models.PositiveIntegerField()), ('maximum_response_time', models.PositiveIntegerField()), ('price', models.DecimalField(decimal_places=4, max_digits=10)), ('created_at', models.DateTimeField(auto_now_add=True)), ('is_active', models.BooleanField(default=True)), ('clasification', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Clasification')), ('product_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType')), ], ), migrations.CreateModel( name='QueryPlansAcquired', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('expiration_date', models.DateField(null=True)), ('validity_months', models.PositiveIntegerField()), ('available_queries', models.PositiveIntegerField()), ('query_quantity', models.PositiveIntegerField()), ('activation_date', models.DateField(null=True)), ('is_active', models.BooleanField(default=False)), ('is_chosen', models.BooleanField(default=False)), ('available_requeries', models.PositiveIntegerField()), ('maximum_response_time', models.PositiveIntegerField()), ('acquired_at', models.DateTimeField(auto_now_add=True)), ('plan_name', models.CharField(max_length=50)), ('query_plans', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlans')), ], ), migrations.CreateModel( name='RecoveryPassword', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('is_active', models.BooleanField(default=False)), ('code', models.CharField(max_length=6)), ], ), migrations.CreateModel( name='Role', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50, unique=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('permissions', models.ManyToManyField(db_table='role_permission', to='api.Permmission')), ], ), migrations.CreateModel( name='Sale', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('place', models.CharField(max_length=100)), ('total_amount', models.DecimalField(decimal_places=2, max_digits=10)), ('reference_number', models.CharField(max_length=20)), ('description', models.TextField()), ('is_fee', models.BooleanField(default=False)), ], ), migrations.CreateModel( name='SaleDetail', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('price', models.DecimalField(decimal_places=2, max_digits=10)), ('description', models.TextField()), ('discount', models.DecimalField(decimal_places=2, max_digits=10)), ('pin_code', models.CharField(max_length=50)), ('is_billable', models.BooleanField(default=True)), ('contract', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Contract')), ('product_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType')), ('sale', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Sale')), ], ), migrations.CreateModel( name='SellerContactNoEfective', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('first_name', models.CharField(max_length=45, null=True)), ('last_name', models.CharField(max_length=55, null=True)), ('type_contact', models.CharField(choices=[('n', 'Natural'), ('b', 'Business')], max_length=1)), ('document_type', models.PositiveIntegerField(choices=[(1, 'DNI'), (2, 'Passport'), (3, 'Foreign Card')])), ('document_number', models.CharField(max_length=45)), ('email', models.CharField(max_length=150, null=True)), ('civil_state', models.CharField(choices=[('c', 'cohabiting'), ('e', 'separated'), ('m', 'married'), ('w', 'widower'), ('d', 'divorced'), ('s', 'single')], max_length=1, null=True)), ('birthdate', models.DateField(null=True)), ('institute', models.CharField(blank=True, max_length=100, null=True)), ('activity_description', models.CharField(blank=True, max_length=255, null=True)), ('photo', models.CharField(max_length=250, null=True)), ('about', models.CharField(blank=True, max_length=255, null=True)), ('cellphone', models.CharField(blank=True, max_length=14, null=True)), ('telephone', models.CharField(blank=True, max_length=14, null=True)), ('ocupation', models.PositiveIntegerField(choices=[(1, 'Employer'), (2, 'Independent worker'), (3, 'Employee'), (4, 'Worker'), (5, 'Worker in a family business'), (6, 'Home worker'), (7, 'Other')], default=7, null=True)), ('profession', models.CharField(max_length=45, null=True)), ('business_name', models.CharField(max_length=45, null=True)), ('commercial_reason', models.CharField(max_length=45, null=True)), ('agent_firstname', models.CharField(max_length=45, null=True)), ('agent_lastname', models.CharField(max_length=45, null=True)), ('sex', models.CharField(blank=True, choices=[('m', 'Male'), ('f', 'Female')], max_length=1)), ('latitude', models.CharField(blank=True, max_length=45)), ('longitude', models.CharField(blank=True, max_length=45)), ('created_at', models.DateTimeField(auto_now_add=True)), ('position', models.CharField(max_length=45, null=True)), ('ruc', models.CharField(blank=True, max_length=40, null=True)), ('address', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Address')), ('ciiu', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')), ('economic_sector', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.EconomicSector')), ('level_instruction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.LevelInstruction')), ('nationality', models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Countries')), ('objection', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Objection')), ], ), migrations.CreateModel( name='SellerNonBillablePlans', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('quantity', models.PositiveIntegerField()), ('number_month', models.PositiveIntegerField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('query_plans', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlans')), ], ), migrations.CreateModel( name='Zone', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('districts', models.ManyToManyField(db_table='zones_districts', to='api.District')), ], ), migrations.CreateModel( name='Client', fields=[ ('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('type_client', models.CharField(choices=[('n', 'Natural'), ('b', 'Business')], max_length=1)), ('sex', models.CharField(blank=True, choices=[('m', 'Male'), ('f', 'Female')], max_length=1)), ('commercial_reason', models.CharField(max_length=45, null=True)), ('civil_state', models.CharField(choices=[('c', 'cohabiting'), ('e', 'separated'), ('m', 'married'), ('w', 'widower'), ('d', 'divorced'), ('s', 'single')], max_length=1, null=True)), ('birthdate', models.DateField(null=True)), ('activity_description', models.CharField(blank=True, max_length=255, null=True)), ('institute', models.CharField(blank=True, max_length=100, null=True)), ('ocupation', models.PositiveIntegerField(choices=[(1, 'Employer'), (2, 'Independent worker'), (3, 'Employee'), (4, 'Worker'), (5, 'Worker in a family business'), (6, 'Home worker'), (7, 'Other')], null=True)), ('about', models.CharField(blank=True, max_length=255, null=True)), ('business_name', models.CharField(max_length=45, null=True)), ('agent_firstname', models.CharField(max_length=45, null=True)), ('agent_lastname', models.CharField(max_length=45, null=True)), ('position', models.CharField(max_length=45, null=True)), ('profession', models.CharField(max_length=45, null=True)), ('ciiu', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')), ('economic_sector', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.EconomicSector')), ('level_instruction', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.LevelInstruction')), ], options={ 'verbose_name_plural': 'Clients', 'verbose_name': 'Client', }, bases=('api.user',), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Seller', fields=[ ('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('cv', models.CharField(blank=True, max_length=100, null=True)), ('ciiu', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Ciiu')), ('zone', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Zone')), ], options={ 'verbose_name_plural': 'Sellers', 'verbose_name': 'Seller', }, bases=('api.user',), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Specialist', fields=[ ('user_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('business_name', models.CharField(max_length=55)), ('type_specialist', models.CharField(choices=[('m', 'Main'), ('a', 'Associate')], max_length=1)), ('star_rating', models.IntegerField(null=True)), ('cv', models.CharField(max_length=150, null=True)), ('payment_per_answer', models.DecimalField(decimal_places=2, max_digits=10)), ], options={ 'verbose_name_plural': 'Specialists', 'verbose_name': 'Specialist', }, bases=('api.user',), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.AddField( model_name='recoverypassword', name='user', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='queryplansacquired', name='sale_detail', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'), ), migrations.AddField( model_name='query', name='acquired_plan', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.QueryPlansAcquired'), ), migrations.AddField( model_name='query', name='category', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'), ), migrations.AddField( model_name='payment', name='authorized_by', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='payment', name='bank', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Bank'), ), migrations.AddField( model_name='payment', name='payment_type', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.PaymentType'), ), migrations.AddField( model_name='notificationsback', name='user', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='monthlyfee', name='payment', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Payment'), ), migrations.AddField( model_name='monthlyfee', name='sale_detail', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'), ), migrations.AddField( model_name='message', name='query', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Query'), ), migrations.AddField( model_name='matchacquired', name='sale_detail', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.SaleDetail'), ), migrations.AddField( model_name='match', name='product_type', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ProductType'), ), migrations.AddField( model_name='match', name='speciality', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'), ), migrations.AddField( model_name='district', name='province', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Province'), ), migrations.AddField( model_name='contract', name='type_contract', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.ContractType'), ), migrations.AddField( model_name='category', name='contract', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Contract'), ), migrations.AddField( model_name='address', name='department', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Department'), ), migrations.AddField( model_name='address', name='district', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.District'), ), migrations.AddField( model_name='address', name='province', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Province'), ), migrations.AddField( model_name='user', name='address', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Address', verbose_name='address'), ), migrations.AddField( model_name='user', name='code_cellphone', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='prefix_cellphone', to='api.Countries'), ), migrations.AddField( model_name='user', name='code_telephone', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='prefix_telephone', to='api.Countries'), ), migrations.AddField( model_name='user', name='groups', field=models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups'), ), migrations.AddField( model_name='user', name='nationality', field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Countries', verbose_name='nationality'), ), migrations.AddField( model_name='user', name='residence_country', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='residence', to='api.Countries', verbose_name='residence country'), ), migrations.AddField( model_name='user', name='role', field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.PROTECT, to='api.Role', verbose_name='role'), ), migrations.AddField( model_name='user', name='user_permissions', field=models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'), ), migrations.AddField( model_name='specialist', name='category', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Category'), ), migrations.AddField( model_name='sellernonbillableplans', name='seller', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'), ), migrations.AddField( model_name='sellercontactnoefective', name='seller', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'), ), migrations.AddField( model_name='sale', name='client', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'), ), migrations.AddField( model_name='sale', name='seller', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Seller'), ), migrations.AddField( model_name='queryplansacquired', name='client', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'), ), migrations.AddField( model_name='queryplans', name='non_billable', field=models.ManyToManyField(through='api.SellerNonBillablePlans', to='api.Seller'), ), migrations.AddField( model_name='querylogs', name='from_specialist', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='al_especialista', to='api.Specialist'), ), migrations.AddField( model_name='querylogs', name='to_specialist', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='del_especialista', to='api.Specialist'), ), migrations.AddField( model_name='query', name='client', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'), ), migrations.AddField( model_name='query', name='specialist', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'), ), migrations.AddField( model_name='message', name='specialist', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'), ), migrations.AddField( model_name='matchacquired', name='client', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Client'), ), migrations.AddField( model_name='matchacquired', name='specialist', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Specialist'), ), migrations.AddField( model_name='feemonthseller', name='seller', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='api.Seller'), ), migrations.AddField( model_name='client', name='seller_asigned', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='api.Seller'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Cart', fields=[ ('cid', models.AutoField(primary_key=True, serialize=False)), ('c_food_num', models.IntegerField()), ('c_is_select', models.IntegerField()), ], options={ 'db_table': 'cart', 'managed': False, }, ), migrations.CreateModel( name='Foods', fields=[ ('fid', models.AutoField(primary_key=True, serialize=False)), ('food_name', models.CharField(max_length=255)), ('food_price', models.FloatField()), ('food_describe', models.CharField(max_length=255)), ('sell_num', models.IntegerField(default=0)), ('food_img', models.CharField(max_length=255)), ], options={ 'db_table': 'foods', 'ordering': ['fid'], 'managed': False, }, ), migrations.CreateModel( name='Order', fields=[ ('oid', models.AutoField(primary_key=True, serialize=False)), ('o_price', models.FloatField()), ('o_time', models.DateTimeField(auto_now=True)), ('o_status', models.IntegerField()), ], options={ 'db_table': 'order', 'ordering': ['-o_time'], 'managed': False, }, ), migrations.CreateModel( name='Orderfoods', fields=[ ('ofid', models.AutoField(primary_key=True, serialize=False)), ('of_food_num', models.IntegerField()), ], options={ 'db_table': 'orderfoods', 'managed': False, }, ), migrations.CreateModel( name='Type', fields=[ ('tid', models.AutoField(primary_key=True, serialize=False)), ('type_name', models.CharField(max_length=32)), ], options={ 'db_table': 'type', 'managed': False, }, ), migrations.CreateModel( name='User', fields=[ ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('uid', models.AutoField(primary_key=True, serialize=False)), ('username', models.CharField(max_length=20, unique=True)), ('password', models.CharField(max_length=200)), ('email', models.EmailField(max_length=200, unique=True)), ('phone', models.IntegerField(blank=True, null=True)), ('sex', models.IntegerField(blank=True, null=True)), ('is_active', models.IntegerField(default=0)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'db_table': 'user', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(error_messages={ 'unique': 'El email que ingreso ya existe' }, max_length=254, unique=True, verbose_name='email addres')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Asignacion', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('portada', models.ImageField(blank=True, null=True, upload_to='Portada')), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Ciclo', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('anio', models.PositiveIntegerField(validators=[ django.core.validators.MinValueValidator(1990) ])), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Curso', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Estudiante', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('telefono_contacto', models.CharField(blank=True, max_length=15, null=True)), ('direccion_contacto', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('asignacion_estudiante', models.ManyToManyField(related_name='estudiante_asignaciones', to='api.Asignacion')), ], ), migrations.CreateModel( name='Nivel', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Profesion', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Rol', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Seccion', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name='Tarea', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('titulo', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('fecha_entrega', models.DateField()), ('hora_entrega', models.TimeField()), ('nota', models.FloatField(default=0)), ('archivo', models.FileField(blank=True, null=True, upload_to='tarea_maestros')), ('permitir_archivo', models.BooleanField(default=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('asignacion', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='asignaciones', to='api.Asignacion')), ], ), migrations.CreateModel( name='Tarea_Estudiante', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('texto', models.CharField(blank=True, max_length=250, null=True)), ('archivo', models.FileField(blank=True, null=True, upload_to='tarea_alumnos')), ('punteo', models.FloatField(default=0)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('estudiante', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='estudiantes', to='api.Estudiante')), ('tarea', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tareas', to='api.Tarea')), ], ), migrations.CreateModel( name='Profile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('phone', models.CharField(blank=True, max_length=15, null=True)), ('address', models.CharField(blank=True, max_length=250, null=True)), ('avatar', models.ImageField(blank=True, null=True, upload_to='Avatar')), ('is_first_login', models.BooleanField( default=True, help_text= 'Verifica si es la primera vez que se logueo en la aplicaion', verbose_name='first_login')), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('rol', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='roles', to='api.Rol')), ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='profiles', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Material', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('titulo', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('archivo', models.FileField(upload_to='material_apoyo')), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('asignacion', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='material_asignaciones', to='api.Asignacion')), ], ), migrations.CreateModel( name='Maestro', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('maestro_profile', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='maestros_profiles', to='api.Profile')), ('profesion', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='profesiones', to='api.Profesion')), ], ), migrations.CreateModel( name='Grado', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('nivel', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='niveles', to='api.Nivel')), ], ), migrations.CreateModel( name='Evento', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('titulo', models.CharField(max_length=100)), ('descripcion', models.CharField(blank=True, max_length=250, null=True)), ('fecha', models.DateField()), ('hora', models.TimeField()), ('activo', models.BooleanField(default=True)), ('creado', models.DateTimeField(auto_now_add=True)), ('modificado', models.DateTimeField(auto_now=True)), ('ciclo_escolar', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='ciclos', to='api.Ciclo')), ], ), migrations.AddField( model_name='estudiante', name='estudiante_profile', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='profiles', to='api.Profile'), ), migrations.AddField( model_name='asignacion', name='asignacion_ciclo', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='asignacion_ciclos', to='api.Ciclo'), ), migrations.AddField( model_name='asignacion', name='curso', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='asignacion_cursos', to='api.Curso'), ), migrations.AddField( model_name='asignacion', name='grado', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='asignacion_grados', to='api.Grado'), ), migrations.AddField( model_name='asignacion', name='maestro', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='asignacion_maestros', to='api.Maestro'), ), migrations.AddField( model_name='asignacion', name='seccion', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='asignacion_secciones', to='api.Seccion'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('created', models.DateTimeField( auto_now_add=True, help_text='Date time on which the object was created.', verbose_name='created_at')), ('modified', models.DateTimeField( auto_now=True, help_text= 'Date time on which the object was last modified.', verbose_name='modified_at')), ('email', models.EmailField(error_messages={ 'unique': 'A user with that email already exists.' }, max_length=254, unique=True, verbose_name='email address')), ('phone_number', models.CharField( blank=True, max_length=17, validators=[ django.core.validators.RegexValidator( message= 'Phone number must be entered in the format: +999999999. Up to 15 digits allowed.', regex='\\+?1?\\d{9,15}$') ])), ('is_client', models.BooleanField( default=True, help_text= 'Help easily distinguish users and perform queries. Clients are the main type of user.', verbose_name='client')), ('is_verified', models.BooleanField( default=True, help_text= 'Set to true when the user have verified its email address.', verbose_name='verified')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'ordering': ['-created', '-modified'], 'get_latest_by': 'created', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Profile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', models.DateTimeField( auto_now_add=True, help_text='Date time on which the object was created.', verbose_name='created_at')), ('modified', models.DateTimeField( auto_now=True, help_text= 'Date time on which the object was last modified.', verbose_name='modified_at')), ('picture', models.ImageField(blank=True, null=True, upload_to='users/pictures/', verbose_name='profile picture')), ('biography', models.TextField(blank=True, max_length=500)), ('rides_taken', models.PositiveIntegerField(default=0)), ('rides_offered', models.PositiveIntegerField(default=0)), ('reputation', models.FloatField( default=5.0, help_text= "User's reputaton based on the rides taken and offered.") ), ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['-created', '-modified'], 'get_latest_by': 'created', 'abstract': False, }, ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0008_alter_user_username_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('nickname', models.CharField(blank=True, max_length=32, null=True, verbose_name='昵称')), ('telphone', models.IntegerField(max_length=11, verbose_name='手机号码')), ('address', models.CharField(max_length=128, verbose_name='邮寄地址')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Order', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('telphone', models.IntegerField(max_length=11)), ('create_time', models.DateTimeField(auto_now=True)), ('total_price', models.FloatField(default=0)), ('address', models.CharField(max_length=128)), ('status', models.CharField(choices=[('wait', '待付款'), ('overdue', '已过期'), ('complete', '已完成'), ('refund', '已退款')], default='wait', max_length=9)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='orders', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='OrderProduct', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('price', models.FloatField(default=0.0)), ('count', models.IntegerField(default=0)), ('total_price', models.FloatField(default=0.0)), ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='orders', to='shop.Order')), ], ), migrations.CreateModel( name='Product', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('pic', models.ImageField(upload_to='product_pic')), ('describe', models.TextField()), ('price', models.FloatField(default=0.0)), ('count', models.IntegerField(default=0)), ], ), migrations.CreateModel( name='ShopCar', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('count', models.IntegerField(default=0)), ('product', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='shopcars', to='shop.Product')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='shopcar', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='orderproduct', name='product', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='orderproducts', to='shop.Product'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0008_alter_user_username_max_length'), ] operations = [ migrations.CreateModel( name='UserProfile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('name', models.CharField(blank=True, max_length=30, null=True, verbose_name='姓名')), ('birthday', models.DateField(blank=True, null=True, verbose_name='出生年月')), ('gender', models.CharField(choices=[('male', '男'), ('female', '女')], default='female', max_length=6, verbose_name='性别')), ('mobile', models.CharField(blank=True, max_length=11, null=True, verbose_name='电话')), ('qq_number', models.CharField(blank=True, max_length=15, null=True, verbose_name='QQ号码')), ('balance', models.FloatField(default=0, null=True, verbose_name='余额')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': '用户', 'verbose_name_plural': '用户', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='RechargeOrder', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('money', models.FloatField(verbose_name='充值金额')), ('arrival_money', models.FloatField(default=0, verbose_name='到账金额')), ('order_number', models.CharField(blank=True, max_length=300, null=True, verbose_name='充值单号')), ('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')), ('state', models.BooleanField(default=False, verbose_name='处理状态')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='充值用户')), ], options={ 'verbose_name': '充值订单', 'verbose_name_plural': '充值订单', }, ), migrations.CreateModel( name='Store', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('store_ww', models.CharField(default='', max_length=100, verbose_name='店铺旺旺')), ('store_name', models.CharField(default='', max_length=100, verbose_name='店铺名称')), ('store_category', models.CharField(default='', max_length=100, verbose_name='店铺类目')), ('store_url', models.URLField(max_length=500, verbose_name='店铺链接')), ('sender_name', models.CharField(default='', max_length=100, verbose_name='发件人')), ('mobile', models.CharField(default='', max_length=11, verbose_name='电话')), ('province', models.CharField(default='', max_length=100, verbose_name='省份')), ('city', models.CharField(default='', max_length=100, verbose_name='城市')), ('district', models.CharField(default='', max_length=100, verbose_name='区域')), ('address', models.CharField(default='', max_length=100, verbose_name='详细地址')), ('postal_code', models.CharField(default='', max_length=6, verbose_name='邮编')), ('image', models.ImageField(upload_to='store_image', verbose_name='卖家中心图片')), ('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')), ('state', models.BooleanField(default=False, verbose_name='审核状态')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='用户')), ], options={ 'verbose_name': '我的店铺', 'verbose_name_plural': '我的店铺', }, ), migrations.CreateModel( name='VerifyCode', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=10, verbose_name='邀请码')), ('mobile', models.CharField(max_length=11, verbose_name='电话')), ('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')), ], options={ 'verbose_name': '邀请码', 'verbose_name_plural': '邀请码', }, ), migrations.CreateModel( name='WithdrawOrder', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('money', models.FloatField(verbose_name='提现金额')), ('Bank_number', models.CharField(blank=True, max_length=50, null=True, verbose_name='提现银行卡号')), ('arrival_money', models.FloatField(default=0, verbose_name='到账金额')), ('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')), ('state', models.BooleanField(default=False, verbose_name='处理状态')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='提现用户')), ], options={ 'verbose_name': '提现订单', 'verbose_name_plural': '提现订单', }, ), ]
class Migration(migrations.Migration): dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ('movie_app', '0001_initial'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('access_level', models.IntegerField(choices=[(1, 'Admin'), (2, 'User')], default=2)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Genre', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=100, unique=True)), ], ), migrations.CreateModel( name='Movie', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=100, unique=True)), ('rating', models.FloatField(validators=[ django.core.validators.MinValueValidator(0), django.core.validators.MaxValueValidator(10) ])), ('popularity', models.FloatField(validators=[ django.core.validators.MinValueValidator(0), django.core.validators.MaxValueValidator(100) ])), ('director', models.CharField(blank=True, max_length=100, null=True)), ('genre', models.ManyToManyField(to='movie_app.Genre')), ], ), migrations.DeleteModel(name='Movies', ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(max_length=254, unique=True)), ('email_confirmed', models.BooleanField(default=False)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Food', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('description', models.CharField(blank=True, max_length=200, null=True)), ('counter', models.PositiveIntegerField()), ('vegetarian', models.BooleanField()), ('vegan', models.BooleanField()), ('halal', models.BooleanField()), ('lactose_free', models.BooleanField()), ('gluten_free', models.BooleanField()), ('bio', models.BooleanField()), ('expiration_date', models.DateField( validators=[fridge.validators.expiration_date_validator]) ), ], ), migrations.CreateModel( name='Fridge', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('address', models.CharField(max_length=45)), ('city', models.CharField(max_length=45)), ('zip_code', models.CharField(max_length=45, validators=[ django.core.validators.RegexValidator( '^\\d{4}$', 'This NPA is not valid') ])), ('phone_number', models.CharField(max_length=12, validators=[ django.core.validators.RegexValidator( '^(\\+41|0)\\d{9}$', 'This phone number is not valid.') ])), ('latitude', models.FloatField()), ('longitude', models.FloatField()), ('image', models.ImageField(upload_to='images/')), ('is_active', models.BooleanField(default=False)), ('user', models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Sponsor', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=45)), ('logo', models.ImageField(upload_to='images/')), ('website', models.URLField(blank=True, null=True)), ], ), migrations.CreateModel( name='TemperatureControl', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('temperature', models.FloatField()), ('visa', models.CharField(max_length=45)), ('fridge', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge')), ], ), migrations.CreateModel( name='SpecialDay', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('description', models.CharField(max_length=200)), ('is_open', models.BooleanField(default=False)), ('from_date', models.DateField()), ('to_date', models.DateField(blank=True, null=True)), ('from_hour', models.TimeField(blank=True, null=True)), ('to_hour', models.TimeField(blank=True, null=True)), ('fridge', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge')), ], ), migrations.CreateModel( name='Reservation', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('quantity', models.PositiveIntegerField()), ('food', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='fridge.food')), ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='ReportContent', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('food', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fridge.food')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='OpeningHour', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('weekday', models.PositiveSmallIntegerField(choices=[(0, 'Monday'), (1, 'Tuesday'), (2, 'Wednesday'), (3, 'Thursday'), (4, 'Friday'), (5, 'Saturday'), (6, 'Sunday')], default=0)), ('from_hour', models.TimeField()), ('to_hour', models.TimeField()), ('fridge', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge')), ], ), migrations.CreateModel( name='Inventory', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('product_name', models.CharField(max_length=45)), ('product_number', models.IntegerField()), ('temperature', models.FloatField()), ('visa', models.CharField(max_length=45)), ('fridge', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge')), ], ), migrations.CreateModel( name='FridgeFollowing', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('fridge', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='food', name='fridge', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='fridge.fridge'), ), migrations.AddField( model_name='food', name='user', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('address', '0002_auto_20160213_1726'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='CriticalDateType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('season_flag', models.BooleanField()), ('comment', models.CharField(blank=True, max_length=200, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Crop', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, null=True)), ('dwu_formaula', models.CharField(blank=True, max_length=100, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Diviner', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('diviner_number', models.CharField(max_length=50)), ('comment', models.CharField(blank=True, max_length=100, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Document', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('description', models.CharField(blank=True, max_length=255)), ('document', models.FileField(upload_to='documents/')), ], ), migrations.CreateModel( name='Farm', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('owner', models.CharField(default='TEST', max_length=100)), ('comment', models.CharField(blank=True, max_length=200, null=True)), ('landline', models.CharField(blank=True, max_length=40, null=True)), ('mobile', models.CharField(blank=True, max_length=40, null=True)), ('email', models.EmailField(blank=True, max_length=254, null=True)), ('folder', models.CharField(blank=True, max_length=100, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('address', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='address.Address')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Probe', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('serial_number', models.CharField(default='Manual', max_length=100)), ('comment', models.CharField(blank=True, max_length=200, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='ReadingType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('comment', models.CharField(blank=True, max_length=200, null=True)), ('formula', models.CharField(blank=True, max_length=200, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Report', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Season', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=20)), ('current_flag', models.BooleanField( default=None, help_text= 'Is this the current season, only one season can be the current season', null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='UserFullName', fields=[], options={ 'proxy': True, 'indexes': [], 'constraints': [], }, bases=('auth.user', ), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='SeasonStartEnd', fields=[ ('season', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='skeleton.Season')), ('season_name', models.CharField(max_length=20)), ('site_name', models.CharField(max_length=100)), ('period_from', models.DateTimeField()), ('period_to', models.DateTimeField()), ], options={ 'db_table': 'skeleton_season_start_end', 'managed': False, }, ), migrations.CreateModel( name='WeatherStation', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, null=True)), ('code', models.CharField(max_length=4, null=True)), ('region', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='address.State')), ], ), migrations.CreateModel( name='Variety', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, null=True)), ('comment', models.TextField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='StrategyType', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('comment', models.TextField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Strategy', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('days', models.IntegerField( help_text= 'A positive or negative number indicated the amount of days away from that critical date.' )), ('percentage', models.FloatField( help_text= 'A number beween 1 and 0 indicating the variation from the limit associated with the strategy.' )), ('comment', models.TextField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('critical_date_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.CriticalDateType')), ('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.StrategyType')), ], ), migrations.CreateModel( name='Site', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('site_number', models.CharField(max_length=20, unique=True)), ('selected', models.BooleanField(null=True)), ('name', models.CharField(max_length=100, null=True)), ('irrigation_method', models.IntegerField( choices=[(0, 'Non-Drip (Overhead)'), (1, 'Drip')], default=1, help_text= 'Are you sure you want to change this to Overhead?')), ('irrigation_area', models.FloatField(blank=True, null=True)), ('irrigation_time', models.FloatField(blank=True, null=True)), ('irrigation_delivered_volume', models.FloatField(blank=True, null=True)), ('irrigation_position', models.FloatField( blank=True, null=True, verbose_name='Inline Water Meter Position in Trees')), ('irrigation_yield', models.FloatField(blank=True, null=True)), ('irrigation_allocation_volume', models.FloatField(blank=True, null=True)), ('rz1_top', models.IntegerField(blank=True, null=True)), ('rz1_bottom', models.IntegerField(blank=True, null=True)), ('rz2_top', models.IntegerField(blank=True, null=True)), ('rz2_bottom', models.IntegerField(blank=True, null=True)), ('rz3_top', models.IntegerField(blank=True, null=True)), ('rz3_bottom', models.IntegerField(blank=True, null=True)), ('depth1', models.IntegerField(blank=True, null=True)), ('depth2', models.IntegerField(blank=True, null=True)), ('depth3', models.IntegerField(blank=True, null=True)), ('depth4', models.IntegerField(blank=True, null=True)), ('depth5', models.IntegerField(blank=True, null=True)), ('depth6', models.IntegerField(blank=True, null=True)), ('depth7', models.IntegerField(blank=True, null=True)), ('depth8', models.IntegerField(blank=True, null=True)), ('depth9', models.IntegerField(blank=True, null=True)), ('depth10', models.IntegerField(blank=True, null=True)), ('depth_he1', models.IntegerField(blank=True, null=True)), ('depth_he2', models.IntegerField(blank=True, null=True)), ('depth_he3', models.IntegerField(blank=True, null=True)), ('depth_he4', models.IntegerField(blank=True, null=True)), ('depth_he5', models.IntegerField(blank=True, null=True)), ('depth_he6', models.IntegerField(blank=True, null=True)), ('depth_he7', models.IntegerField(blank=True, null=True)), ('depth_he8', models.IntegerField(blank=True, null=True)), ('depth_he9', models.IntegerField(blank=True, null=True)), ('depth_he10', models.IntegerField(blank=True, null=True)), ('emitter_rate', models.FloatField(blank=True, null=True)), ('row_spacing', models.IntegerField(blank=True, null=True, verbose_name='Row Spacing (cm)')), ('emitter_spacing', models.IntegerField(blank=True, null=True, verbose_name='Emitter Spacing (cm)')), ('plant_spacing', models.IntegerField(blank=True, null=True, verbose_name='Plant Spacing (cm)')), ('wetted_width', models.IntegerField(blank=True, null=True, verbose_name='Wetted Width (cm)')), ('delivery_time', models.IntegerField(blank=True, null=True, verbose_name='Deliver Time in Minutes')), ('area', models.FloatField(blank=True, null=True, verbose_name='Area (Ha)')), ('comment', models.TextField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('crop', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.Crop')), ('farm', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.Farm')), ('lower_limit', models.ForeignKey(blank=True, help_text='Target Lower line for Graph', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='lower_limit_type', to='skeleton.ReadingType')), ('lower_strategy', models.ForeignKey( blank=True, help_text= 'Strategy dictating deviance of Lower line for Graph', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='lower_strategy_type', to='skeleton.StrategyType')), ('report', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Report')), ('technician', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, related_name='technician_id', to=settings.AUTH_USER_MODEL)), ('upper_limit', models.ForeignKey(blank=True, help_text='Target Upper line for Graph', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='upper_limit_type', to='skeleton.ReadingType')), ('upper_strategy', models.ForeignKey( blank=True, help_text= 'Strategy dictating deviance of Upper line for Graph', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='upper_strategy_type', to='skeleton.StrategyType')), ], ), migrations.CreateModel( name='ProbeDiviner', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('diviner', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Diviner')), ('probe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.Probe')), ], ), migrations.CreateModel( name='KCReading', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('period_from', models.DateField(default=django.utils.timezone.now)), ('period_to', models.DateField(default=django.utils.timezone.now)), ('kc', models.FloatField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('crop', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.Crop')), ], ), migrations.AddField( model_name='farm', name='report', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Report'), ), migrations.AddField( model_name='farm', name='weatherstation', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.WeatherStation'), ), migrations.CreateModel( name='ETReading', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField(default=django.utils.timezone.now)), ('weekly', models.FloatField(blank=True, null=True)), ('daily', models.FloatField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('state', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='address.State')), ], ), migrations.AddField( model_name='diviner', name='site', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Site'), ), migrations.AddField( model_name='crop', name='report', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Report'), ), migrations.AddField( model_name='crop', name='variety', field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Variety'), ), migrations.CreateModel( name='Calibration', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('soil_type', models.IntegerField(blank=True, null=True)), ('period_from', models.DateField(default=django.utils.timezone.now)), ('period_to', models.DateField(blank=True, null=True)), ('slope', models.FloatField(blank=True, null=True)), ('intercept', models.FloatField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('serial_number', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Probe')), ], ), migrations.CreateModel( name='SiteDescription', fields=[], options={ 'proxy': True, 'indexes': [], 'constraints': [], }, bases=('skeleton.site', ), ), migrations.CreateModel( name='Reading', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField(default=django.utils.timezone.now)), ('depth1', models.FloatField(blank=True, null=True, verbose_name='Depth1 VSW/Normal')), ('depth2', models.FloatField(blank=True, null=True, verbose_name='Depth1 VSW/Normal')), ('depth3', models.FloatField(blank=True, null=True, verbose_name='Depth3 VSW/Normal')), ('depth4', models.FloatField(blank=True, null=True, verbose_name='Depth4 VSW/Normal')), ('depth5', models.FloatField(blank=True, null=True, verbose_name='Depth5 VSW/Normal')), ('depth6', models.FloatField(blank=True, null=True, verbose_name='Depth6 VSW/Normal')), ('depth7', models.FloatField(blank=True, null=True, verbose_name='Depth7 VSW/Normal')), ('depth8', models.FloatField(blank=True, null=True, verbose_name='Depth8 VSW/Normal')), ('depth9', models.FloatField(blank=True, null=True, verbose_name='Depth9 VSW/Normal')), ('depth10', models.FloatField(blank=True, null=True, verbose_name='Depth10 VSW/Normal')), ('depth1_count', models.FloatField(blank=True, null=True)), ('depth2_count', models.FloatField(blank=True, null=True)), ('depth3_count', models.FloatField(blank=True, null=True)), ('depth4_count', models.FloatField(blank=True, null=True)), ('depth5_count', models.FloatField(blank=True, null=True)), ('depth6_count', models.FloatField(blank=True, null=True)), ('depth7_count', models.FloatField(blank=True, null=True)), ('depth8_count', models.FloatField(blank=True, null=True)), ('depth9_count', models.FloatField(blank=True, null=True)), ('depth10_count', models.FloatField(blank=True, null=True)), ('rz1', models.FloatField(blank=True, null=True, verbose_name='Root Zone 1')), ('rz2', models.FloatField(blank=True, null=True, verbose_name='Root Zone 2')), ('rz3', models.FloatField(blank=True, null=True, verbose_name='Root Zone 3')), ('deficit', models.FloatField( blank=True, help_text= 'Deficit is the difference between the full point reading and root zone 1', null=True)), ('probe_dwu', models.FloatField( blank=True, help_text= 'PDWU is the rate of change of the water content of root zone 1, expressed in mm/day', null=True, verbose_name='Probe Daily Water Use')), ('estimated_dwu', models.FloatField( blank=True, help_text= 'EDWU is KC Reading for crop multiplied by ET reading for region', null=True, verbose_name='Estimated Daily Water Use')), ('rain', models.FloatField(blank=True, help_text='Rainfall reding', null=True)), ('meter', models.FloatField( blank=True, help_text='Meter reading', null=True, verbose_name='Inline Water Meter in Litres')), ('irrigation_litres', models.FloatField( blank=True, help_text= 'Difference in Meter readings multipled by the Irrigation Postion', null=True, verbose_name='Irrigation in Litres')), ('irrigation_mms', models.FloatField( blank=True, help_text= 'Irrigation in Litres divided by Schedule Rowspace and Schedule Plantspace divided by 10000', null=True, verbose_name='Irrigation in Millimetres')), ('effective_rain_1', models.FloatField(blank=True, help_text='keydata 5 - Well Complicated', null=True)), ('effective_rainfall', models.FloatField(blank=True, help_text='keydata 6', null=True)), ('efflrr1', models.FloatField(blank=True, help_text='keydata 7', null=True)), ('efflrr2', models.FloatField(blank=True, help_text='keydata 8', null=True)), ('effective_irrigation', models.FloatField(blank=True, help_text='keydata 9', null=True)), ('comment', models.TextField(blank=True, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('serial_number', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='skeleton.Probe')), ('site', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='readings', to='skeleton.Site')), ('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='skeleton.ReadingType')), ], options={ 'unique_together': {('date', 'site', 'type')}, }, ), migrations.AlterUniqueTogether( name='crop', unique_together={('name', 'variety')}, ), migrations.CreateModel( name='CriticalDate', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField(default=django.utils.timezone.now)), ('comment', models.CharField(blank=True, max_length=200, null=True)), ('created_date', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date published')), ('created_by', models.ForeignKey(default=django.contrib.auth.models.User, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('season', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='seasons', to='skeleton.Season')), ('site', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sites', to='skeleton.Site')), ('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='critical_date_types', to='skeleton.CriticalDateType')), ], options={ 'unique_together': {('site', 'season', 'type')}, }, ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='Users', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='College', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ], ), migrations.CreateModel( name='Faculties', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('college', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='public.College')), ], ), migrations.CreateModel( name='Major', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=63)), ('faculty', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='public.Faculties')), ], ), migrations.CreateModel( name='Role', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('role', models.CharField(choices=[('Student', 'Role1'), ('Teacher', 'Role2'), ('DepartmentHead', 'Role3'), ('FacultyTrainingStaff', 'Role4'), ('UniversityTrainingStaff', 'Role5'), ('InternshipHead', 'Role6')], max_length=31)), ], ), migrations.CreateModel( name='Student', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('credits', models.IntegerField()), ('average', models.FloatField()), ('studentNumber', models.CharField(max_length=9)), ('phone', models.CharField(max_length=11)), ('nationalCode', models.CharField(max_length=10)), ('major', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='public.Major')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Department', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('faculty', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='public.Faculties')), ], ), migrations.AddField( model_name='users', name='role', field=models.ManyToManyField(to='public.Role'), ), migrations.AddField( model_name='users', name='user_permissions', field=models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('registration_number', models.CharField(max_length=25, unique=True, verbose_name='registration number')), ('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')), ('is_teacher', models.BooleanField(default=False, verbose_name='is teacher')), ('is_student', models.BooleanField(default=False, verbose_name='is student')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'db_table': 'users', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Activity', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('description', models.CharField(max_length=250)), ('create_at', models.DateTimeField(auto_now_add=True)), ('update_at', models.DateTimeField(auto_now=True)), ], options={ 'db_table': 'activity', }, ), migrations.CreateModel( name='Class', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200)), ('description', models.TextField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created_at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified_at')), ], options={ 'db_table': 'class', }, ), migrations.CreateModel( name='Institution', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=250, verbose_name='name')), ('description', models.TextField(blank=True, null=True, verbose_name='description')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created_at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified_at')), ], options={ 'db_table': 'institution', }, ), migrations.CreateModel( name='Location', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=250)), ('description', models.TextField(blank=True, null=True)), ('latitude', models.FloatField()), ('longitude', models.FloatField()), ('create_at', models.DateTimeField(auto_now_add=True)), ('update_at', models.DateTimeField(auto_now=True)), ], options={ 'db_table': 'location', }, ), migrations.CreateModel( name='Teacher', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cpf', models.CharField(max_length=100, unique=True, verbose_name='cpf')), ('full_name', models.CharField(blank=True, max_length=250, null=True, verbose_name='full name')), ('description', models.TextField(blank=True, null=True, verbose_name='description')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified at')), ('institution', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='teachers', to='accounts.Institution')), ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='teacher', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'teacher', }, ), migrations.CreateModel( name='Student', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cpf', models.CharField(max_length=100, unique=True, verbose_name='cpf')), ('full_name', models.CharField(blank=True, max_length=250, null=True, verbose_name='full name')), ('description', models.TextField(blank=True, null=True, verbose_name='description')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified at')), ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='students', to='accounts.Class')), ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, related_name='student', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'student', }, ), migrations.CreateModel( name='Program', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200, verbose_name='name')), ('description', models.TextField(blank=True, null=True, verbose_name='description')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created_at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified_at')), ('institution', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='accounts.Institution')), ], options={ 'db_table': 'program', }, ), migrations.CreateModel( name='Course', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=200, verbose_name='name')), ('description', models.TextField(blank=True, null=True, verbose_name='description')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created_at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified_at')), ('class_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='courses', to='accounts.Class')), ('program', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='courses', to='accounts.Program')), ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='courses', to='accounts.Teacher')), ], options={ 'db_table': 'course', }, ), migrations.CreateModel( name='Content', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=250)), ('description', models.CharField(max_length=250)), ('create_at', models.DateTimeField(auto_now_add=True)), ('update_at', models.DateTimeField(auto_now=True)), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='contents', to='accounts.Course')), ('teacher', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='contents', to='accounts.Teacher')), ], options={ 'db_table': 'content', }, ), migrations.AddField( model_name='class', name='program', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='classes', to='accounts.Program'), ), migrations.CreateModel( name='Address', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('state', models.CharField(max_length=2, verbose_name='state')), ('city', models.CharField(max_length=100, verbose_name='city')), ('street', models.CharField(max_length=250, verbose_name='street')), ('neighborhood', models.CharField(max_length=100, verbose_name='neighborhood')), ('number', models.IntegerField(verbose_name='number')), ('postal_code', models.CharField(max_length=250, verbose_name='postal_code')), ('complement', models.CharField(blank=True, max_length=250, null=True, verbose_name='complement')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='created_at')), ('modified_at', models.DateTimeField(auto_now=True, verbose_name='modified_at')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='addresses', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'address', }, ), migrations.CreateModel( name='ActivityAnswer', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('google_drive_file_key', models.CharField(max_length=200)), ('activity', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='answers', to='accounts.Activity')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='answers', to='accounts.Student')), ], options={ 'db_table': 'activity_answer', }, ), migrations.AddField( model_name='activity', name='content', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='activities', to='accounts.Content'), ), migrations.AddField( model_name='activity', name='location', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='activities', to='accounts.Teacher'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField( error_messages={ 'unique': 'A user with that username already exists.' }, help_text= 'Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator() ], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('upload', models.ImageField(upload_to='uploads/%Y/%m/%d/')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Account', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('update_time', models.DateField()), ('currency', models.CharField(max_length=3)), ('balance', models.FloatField()), ], ), migrations.CreateModel( name='Client', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('full_name', models.CharField(max_length=30)), ('login', models.CharField(max_length=20)), ('birthday', models.DateField()), ('contract_number', models.CharField(max_length=10)), ('date_conclusion', models.DateField()), ('tel', models.CharField(max_length=12)), ('address', models.CharField(max_length=100)), ], ), migrations.CreateModel( name='History_of_changes', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('old_balance', models.FloatField()), ('new_balance', models.FloatField()), ('reason', models.CharField(max_length=30)), ('update_time', models.DateField()), ('acc_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bs.Account')), ], ), migrations.CreateModel( name='Rate', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('source_currency', models.CharField(max_length=3)), ('final_currency', models.CharField(max_length=3)), ('cost', models.FloatField()), ('update', models.DateField()), ], ), migrations.CreateModel( name='Transfer', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('tr_date', models.DateField()), ('source_currency', models.CharField(max_length=3)), ('source_sum', models.FloatField()), ('final_currency', models.CharField(max_length=3)), ('final_sum', models.FloatField()), ('final_his_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='final_his_id', to='bs.History_of_changes')), ('source_his_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='source_his_id', to='bs.History_of_changes')), ], ), migrations.AddField( model_name='account', name='cl_id', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='bs.Client'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='AuctionListings', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=64)), ('description', models.CharField(max_length=64)), ('initialBid', models.FloatField(max_length=6)), ('image', models.ImageField(default='/static/auctions/default_image.jpg', null=True, upload_to='auctions/static/auctions')), ('category', models.CharField(max_length=64)), ('auctioner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Watchlist', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('lotList', models.ManyToManyField(blank=True, to='auctions.AuctionListings')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Comments', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('comments', models.TextField(max_length=64)), ('listing', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='listingComment', to='auctions.AuctionListings')), ('userComment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='usercomment', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Bids', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('bid', models.FloatField(max_length=6)), ('holder', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bidHolder', to=settings.AUTH_USER_MODEL)), ('lot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bidLot', to='auctions.AuctionListings')), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('contenttypes', '0002_remove_content_type_name'), ('auth', '0008_alter_user_username_max_length'), ] operations = [ migrations.CreateModel( name='UserInfo', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=30, verbose_name='last name')), ('username', models.CharField(max_length=64, unique=True, verbose_name='\u7528\u6237\u540d')), ('email', models.EmailField(blank=True, max_length=255, null=True, unique=True, verbose_name='email address')), ('uid', models.CharField(max_length=64, unique=True)), ('mobile', models.BigIntegerField(help_text='\u7528\u4e8e\u624b\u673a\u9a8c\u8bc1\u7801\u767b\u5f55', null=True, unique=True, verbose_name='\u624b\u673a')), ('qq', models.CharField(blank=True, db_index=True, max_length=64, null=True, verbose_name='QQ')), ('weixin', models.CharField(blank=True, db_index=True, max_length=128, null=True, verbose_name='\u5fae\u4fe1')), ('signature', models.CharField(blank=True, max_length=255, null=True, verbose_name='\u4e2a\u4eba\u7b7e\u540d')), ('brief', models.TextField(blank=True, null=True, verbose_name='\u4e2a\u4eba\u4ecb\u7ecd')), ('openid', models.CharField(blank=True, max_length=128, null=True)), ('alipay_card', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u652f\u4ed8\u5b9d\u8d26\u6237')), ('gender', models.SmallIntegerField(choices=[(0, '\u4fdd\u5bc6'), (1, '\u7537'), (2, '\u5973')], default=0, verbose_name='\u6027\u522b')), ('id_card', models.CharField(blank=True, max_length=32, null=True, verbose_name='\u8eab\u4efd\u8bc1\u53f7\u6216\u62a4\u7167\u53f7')), ('password', models.CharField(help_text="<a class='btn-link' href='password'>\u91cd\u7f6e\u5bc6\u7801</a>", max_length=128, verbose_name='password')), ('is_active', models.BooleanField(default=True, verbose_name='\u8d26\u6237\u72b6\u6001')), ('is_staff', models.BooleanField(default=False, help_text='\u51b3\u5b9a\u7740\u7528\u6237\u662f\u5426\u53ef\u767b\u5f55\u7ba1\u7406\u540e\u53f0', verbose_name='staff status')), ('name', models.CharField(default='', max_length=32, verbose_name='\u771f\u5b9e\u59d3\u540d')), ('head_img', models.CharField(default='/static/frontend/head_portrait/[email protected]', max_length=256, verbose_name='\u4e2a\u4eba\u5934\u50cf')), ('role', models.SmallIntegerField(choices=[(0, '\u5b66\u5458'), (1, '\u5bfc\u5e08'), (2, '\u8bb2\u5e08'), (3, '\u7ba1\u7406\u5458'), (4, '\u73ed\u4e3b\u4efb'), (5, '\u7ebf\u4e0b\u73ed\u4e3b\u4efb')], default=0, verbose_name='\u89d2\u8272')), ('memo', models.TextField(blank=True, default=None, help_text='json\u683c\u5f0f\u5b58\u50a8', null=True, verbose_name='\u5907\u6ce8')), ('date_joined', models.DateTimeField(auto_now_add=True, verbose_name='\u6ce8\u518c\u65f6\u95f4')), ('beli', models.IntegerField(default=1000)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': '\u7528\u6237\u4fe1\u606f', 'verbose_name_plural': '\u7528\u6237\u4fe1\u606f', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Coupon', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=64, verbose_name='\u6d3b\u52a8\u540d\u79f0')), ('brief', models.TextField(blank=True, null=True, verbose_name='\u4f18\u60e0\u5238\u4ecb\u7ecd')), ('coupon_type', models.SmallIntegerField(choices=[(0, '\u7acb\u51cf\u5238'), (1, '\u6ee1\u51cf\u5238'), (2, '\u6298\u6263\u5238')], default=0, verbose_name='\u5238\u7c7b\u578b')), ('money_equivalent_value', models.FloatField(blank=True, null=True, verbose_name='\u7b49\u503c\u8d27\u5e01')), ('off_percent', models.PositiveSmallIntegerField(blank=True, help_text='\u53ea\u9488\u5bf9\u6298\u6263\u5238\uff0c\u4f8b7.9\u6298\uff0c\u519979', null=True, verbose_name='\u6298\u6263\u767e\u5206\u6bd4')), ('minimum_consume', models.PositiveIntegerField(default=0, help_text='\u4ec5\u5728\u6ee1\u51cf\u5238\u65f6\u586b\u5199\u6b64\u5b57\u6bb5', verbose_name='\u6700\u4f4e\u6d88\u8d39')), ('object_id', models.PositiveIntegerField(blank=True, help_text='\u53ef\u4ee5\u628a\u4f18\u60e0\u5238\u8ddf\u8bfe\u7a0b\u7ed1\u5b9a', null=True, verbose_name='\u7ed1\u5b9a\u8bfe\u7a0b')), ('quantity', models.PositiveIntegerField(default=1, verbose_name='\u6570\u91cf(\u5f20)')), ('open_date', models.DateField(verbose_name='\u4f18\u60e0\u5238\u9886\u53d6\u5f00\u59cb\u65f6\u95f4')), ('close_date', models.DateField(verbose_name='\u4f18\u60e0\u5238\u9886\u53d6\u7ed3\u675f\u65f6\u95f4')), ('valid_begin_date', models.DateField(blank=True, null=True, verbose_name='\u6709\u6548\u671f\u5f00\u59cb\u65f6\u95f4')), ('valid_end_date', models.DateField(blank=True, null=True, verbose_name='\u6709\u6548\u7ed3\u675f\u65f6\u95f4')), ('coupon_valid_days', models.PositiveIntegerField(blank=True, help_text='\u81ea\u5238\u88ab\u9886\u65f6\u5f00\u59cb\u7b97\u8d77', null=True, verbose_name='\u4f18\u60e0\u5238\u6709\u6548\u671f\uff08\u5929\uff09')), ('status', models.SmallIntegerField(choices=[(0, '\u4e0a\u7ebf'), (1, '\u4e0b\u7ebf')], default=0)), ('date', models.DateTimeField(auto_now_add=True)), ('content_type', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')), ], ), migrations.CreateModel( name='CouponRecord', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.SmallIntegerField(choices=[(0, '\u672a\u4f7f\u7528'), (1, '\u5df2\u4f7f\u7528'), (2, '\u5df2\u8fc7\u671f'), (3, '\u672a\u9886\u53d6')], default=0)), ('get_time', models.DateTimeField(blank=True, help_text='\u7528\u6237\u9886\u53d6\u65f6\u95f4', null=True, verbose_name='\u9886\u53d6\u65f6\u95f4')), ('used_time', models.DateTimeField(blank=True, null=True, verbose_name='\u4f7f\u7528\u65f6\u95f4')), ('date', models.DateTimeField(auto_now_add=True, verbose_name='\u751f\u6210\u65f6\u95f4')), ('account', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='\u4f7f\u7528\u8005')), ('coupon', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Coupon')), ], ), migrations.CreateModel( name='Course', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=128, unique=True, verbose_name='\u6a21\u5757')), ('course_img', models.CharField(max_length=255)), ('course_type', models.SmallIntegerField(choices=[(0, '\u4ed8\u8d39'), (1, 'VIP\u4e13\u4eab'), (2, '\u5b66\u4f4d\u8bfe\u7a0b')])), ('brief', models.TextField(max_length=2048, verbose_name='\u8bfe\u7a0b\u6982\u8ff0')), ('level', models.SmallIntegerField(choices=[(0, '\u521d\u7ea7'), (1, '\u4e2d\u7ea7'), (2, '\u9ad8\u7ea7')], default=1)), ('pub_date', models.DateField(blank=True, null=True, verbose_name='\u53d1\u5e03\u65e5\u671f')), ('period', models.PositiveIntegerField(default=7, verbose_name='\u5efa\u8bae\u5b66\u4e60\u5468\u671f(days)')), ('order', models.IntegerField(help_text='\u4ece\u4e0a\u4e00\u4e2a\u8bfe\u7a0b\u6570\u5b57\u5f80\u540e\u6392', verbose_name='\u8bfe\u7a0b\u987a\u5e8f')), ('attachment_path', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u8bfe\u4ef6\u8def\u5f84')), ('status', models.SmallIntegerField(choices=[(0, '\u4e0a\u7ebf'), (1, '\u4e0b\u7ebf'), (2, '\u9884\u4e0a\u7ebf')], default=0)), ], ), migrations.CreateModel( name='CourseChapter', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('chapter', models.SmallIntegerField(default=1, verbose_name='\u7b2c\u51e0\u7ae0')), ('name', models.CharField(max_length=128)), ('summary', models.TextField(blank=True, null=True, verbose_name='\u7ae0\u8282\u4ecb\u7ecd')), ('is_create', models.BooleanField(default=True, verbose_name='\u662f\u5426\u521b\u5efa\u9898\u5e93\u8fdb\u5ea6')), ('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='\u53d1\u5e03\u65e5\u671f')), ('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='coursechapters', to='api.Course')), ], ), migrations.CreateModel( name='CourseDetail', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('hours', models.IntegerField(verbose_name='\u8bfe\u65f6')), ('course_slogan', models.CharField(blank=True, max_length=125, null=True)), ('video_brief_link', models.CharField(blank=True, max_length=255, null=True)), ('why_study', models.TextField(verbose_name='\u4e3a\u4ec0\u4e48\u5b66\u4e60\u8fd9\u95e8\u8bfe\u7a0b')), ('what_to_study_brief', models.TextField(verbose_name='\u6211\u5c06\u5b66\u5230\u54ea\u4e9b\u5185\u5bb9')), ('career_improvement', models.TextField(verbose_name='\u6b64\u9879\u76ee\u5982\u4f55\u6709\u52a9\u4e8e\u6211\u7684\u804c\u4e1a\u751f\u6daf')), ('prerequisite', models.TextField(max_length=1024, verbose_name='\u8bfe\u7a0b\u5148\u4fee\u8981\u6c42')), ('course', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='api.Course')), ('recommend_courses', models.ManyToManyField(blank=True, related_name='recommend_by', to='api.Course')), ], ), migrations.CreateModel( name='CourseSection', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=128)), ('order', models.PositiveSmallIntegerField(help_text='\u5efa\u8bae\u6bcf\u4e2a\u8bfe\u65f6\u4e4b\u95f4\u7a7a1\u81f32\u4e2a\u503c\uff0c\u4ee5\u5907\u540e\u7eed\u63d2\u5165\u8bfe\u65f6', verbose_name='\u8bfe\u65f6\u6392\u5e8f')), ('section_type', models.SmallIntegerField(choices=[(0, '\u6587\u6863'), (1, '\u7ec3\u4e60'), (2, '\u89c6\u9891')], default=2)), ('section_link', models.CharField(blank=True, help_text='\u82e5\u662fvideo\uff0c\u586bvid,\u82e5\u662f\u6587\u6863\uff0c\u586blink', max_length=255, null=True)), ('video_time', models.CharField(blank=True, max_length=32, null=True, verbose_name='\u89c6\u9891\u65f6\u957f')), ('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='\u53d1\u5e03\u65f6\u95f4')), ('free_trail', models.BooleanField(default=False, verbose_name='\u662f\u5426\u53ef\u8bd5\u770b')), ('is_flash', models.BooleanField(default=False, verbose_name='\u662f\u5426\u4f7f\u7528FLASH\u64ad\u653e')), ('player', models.SmallIntegerField(choices=[(0, 'CC'), (1, 'POLYV'), (2, 'ALI')], default=1, help_text='\u89c6\u9891\u64ad\u653e\u5668\u9009\u62e9')), ('chapter', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='coursesection', to='api.CourseChapter')), ], ), migrations.CreateModel( name='OftenAskedQuestion', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('object_id', models.PositiveIntegerField()), ('question', models.CharField(max_length=255)), ('answer', models.TextField(max_length=1024)), ('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')), ], options={ 'verbose_name_plural': '\u5e38\u89c1\u95ee\u9898', }, ), migrations.CreateModel( name='Order', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('payment_type', models.SmallIntegerField(choices=[(0, '\u5fae\u4fe1'), (1, '\u652f\u4ed8\u5b9d'), (2, '\u4f18\u60e0\u7801'), (3, '\u8d1d\u91cc'), (4, '\u94f6\u8054')])), ('payment_number', models.CharField(blank=True, max_length=128, null=True, verbose_name='\u652f\u4ed8\u7b2c3\u65b9\u8ba2\u5355\u53f7')), ('order_number', models.CharField(max_length=128, unique=True, verbose_name='\u8ba2\u5355\u53f7')), ('actual_amount', models.FloatField(verbose_name='\u5b9e\u4ed8\u91d1\u989d')), ('status', models.SmallIntegerField(choices=[(0, '\u4ea4\u6613\u6210\u529f'), (1, '\u5f85\u652f\u4ed8'), (2, '\u9000\u8d39\u7533\u8bf7\u4e2d'), (3, '\u5df2\u9000\u8d39'), (4, '\u4e3b\u52a8\u53d6\u6d88'), (5, '\u8d85\u65f6\u53d6\u6d88')], verbose_name='\u72b6\u6001')), ('order_type', models.SmallIntegerField(choices=[(0, '\u7528\u6237\u4e0b\u5355'), (1, '\u7ebf\u4e0b\u73ed\u521b\u5efa')], default=0, verbose_name='\u8ba2\u5355\u7c7b\u578b')), ('date', models.DateTimeField(auto_now_add=True, verbose_name='\u8ba2\u5355\u751f\u6210\u65f6\u95f4')), ('pay_time', models.DateTimeField(blank=True, null=True, verbose_name='\u4ed8\u6b3e\u65f6\u95f4')), ('cancel_time', models.DateTimeField(blank=True, null=True, verbose_name='\u8ba2\u5355\u53d6\u6d88\u65f6\u95f4')), ('account', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='OrderDetail', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('object_id', models.PositiveIntegerField()), ('original_price', models.FloatField(verbose_name='\u8bfe\u7a0b\u539f\u4ef7')), ('price', models.FloatField(verbose_name='\u6298\u540e\u4ef7\u683c')), ('content', models.CharField(blank=True, max_length=255, null=True)), ('valid_period_display', models.CharField(max_length=32, verbose_name='\u6709\u6548\u671f\u663e\u793a')), ('valid_period', models.PositiveIntegerField(verbose_name='\u6709\u6548\u671f(days)')), ('memo', models.CharField(blank=True, max_length=255, null=True)), ('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')), ('order', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Order')), ], ), migrations.CreateModel( name='PricePolicy', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('object_id', models.PositiveIntegerField()), ('valid_period', models.SmallIntegerField(choices=[(1, '1\u5929'), (3, '3\u5929'), (7, '1\u5468'), (14, '2\u5468'), (30, '1\u4e2a\u6708'), (60, '2\u4e2a\u6708'), (90, '3\u4e2a\u6708'), (120, '4\u4e2a\u6708'), (180, '6\u4e2a\u6708'), (210, '12\u4e2a\u6708'), (540, '18\u4e2a\u6708'), (720, '24\u4e2a\u6708'), (722, '24\u4e2a\u6708'), (723, '24\u4e2a\u6708')])), ('price', models.FloatField()), ('content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')), ], ), migrations.CreateModel( name='Teacher', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=32)), ('role', models.SmallIntegerField(choices=[(0, '\u8bb2\u5e08'), (1, '\u5bfc\u5e08')], default=0)), ('title', models.CharField(max_length=64, verbose_name='\u804c\u4f4d\u3001\u804c\u79f0')), ('signature', models.CharField(blank=True, help_text='\u5bfc\u5e08\u7b7e\u540d', max_length=255, null=True)), ('image', models.CharField(max_length=128)), ('brief', models.TextField(max_length=1024)), ], ), migrations.CreateModel( name='Token', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('key', models.CharField(max_length=40)), ('created', models.DateTimeField(auto_now_add=True, verbose_name='\u521b\u5efa\u65f6\u95f4')), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='auth_token', to=settings.AUTH_USER_MODEL, verbose_name='\u5173\u8054\u7528\u6237')), ], ), migrations.AddField( model_name='coursedetail', name='teachers', field=models.ManyToManyField(to='api.Teacher', verbose_name='\u8bfe\u7a0b\u8bb2\u5e08'), ), migrations.AddField( model_name='couponrecord', name='order', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='api.Order', verbose_name='\u5173\u8054\u8ba2\u5355'), ), migrations.AlterUniqueTogether( name='pricepolicy', unique_together=set([('content_type', 'object_id', 'valid_period')]), ), migrations.AlterUniqueTogether( name='orderdetail', unique_together=set([('order', 'content_type', 'object_id')]), ), migrations.AlterUniqueTogether( name='oftenaskedquestion', unique_together=set([('content_type', 'object_id', 'question')]), ), migrations.AlterUniqueTogether( name='coursesection', unique_together=set([('chapter', 'section_link')]), ), migrations.AlterUniqueTogether( name='coursechapter', unique_together=set([('course', 'chapter')]), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('auth', '0009_alter_user_last_name_max_length'), ] operations = [ migrations.CreateModel( name='FoodDispenserAction', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('time', models.DateTimeField()), ('cups', models.FloatField(default=0)), ('command', models.PositiveIntegerField(default=2)), ], ), migrations.CreateModel( name='Pet', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('chip_id', models.BigIntegerField()), ('pet_type', models.CharField(blank=True, default='', max_length=30)), ('pet_breed', models.CharField(blank=True, default='', max_length=30)), ('name', models.CharField(blank=True, default='', max_length=30)), ('birthday', models.DateField(blank=True, default=None)), ], ), migrations.CreateModel( name='PetConsumptionAction', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('time', models.DateTimeField()), ('mass', models.PositiveIntegerField(default=0)), ], ), migrations.CreateModel( name='PetFeeder', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('serial_id', models.CharField(max_length=36, unique=True)), ('setting_cup', models.PositiveIntegerField(default=0)), ('setting_interval', models.PositiveIntegerField(default=0)), ('setting_closure', models.BooleanField(default=False)), ], ), migrations.CreateModel( name='PetFood', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('calories_serving', models.PositiveIntegerField(default=0)), ('cups_serving', models.FloatField(default=0)), ('density', models.FloatField(default=0)), ], ), migrations.CreateModel( name='Profile', fields=[ ('user', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, bases=('auth.user', ), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='UserRequestAction', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('start_time', models.DateTimeField()), ('end_time', models.DateTimeField(blank=True, default=None)), ('request_type', models.IntegerField()), ('status', models.IntegerField()), ('feeder', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='petfeeder.PetFeeder')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddField( model_name='petfood', name='user', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='petfeeder', name='food', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='petfeeder.PetFood'), ), migrations.AddField( model_name='petfeeder', name='pet', field=models.OneToOneField( null=True, on_delete=django.db.models.deletion.SET_NULL, to='petfeeder.Pet'), ), migrations.AddField( model_name='petfeeder', name='user', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='petconsumptionaction', name='food', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='petfeeder.PetFood'), ), migrations.AddField( model_name='petconsumptionaction', name='pet', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='petfeeder.Pet'), ), migrations.AddField( model_name='pet', name='user', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='fooddispenseraction', name='feeder', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='petfeeder.PetFeeder'), ), migrations.AddField( model_name='fooddispenseraction', name='food', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='petfeeder.PetFood'), ), ]
class Migration(migrations.Migration): dependencies = [ ('auth', '0009_alter_user_last_name_max_length'), ('IMSAdmin', '0001_initial'), ] operations = [ migrations.CreateModel( name='Customer', fields=[ ('user_ptr', models.OneToOneField( auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('mobile', models.CharField(max_length=50)), ('city', models.CharField(max_length=50)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, bases=('auth.user', ), managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='CustomerPolicyComprehensive', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('effectiveFrom', models.DateField()), ('effectiveTill', models.DateField()), ('year', models.IntegerField()), ('value', models.FloatField()), ('totalAmount', models.FloatField()), ('commission', models.FloatField()), ('policyType', models.BooleanField()), ('name', models.CharField(max_length=50)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('repairType', models.BooleanField()), ('premium', models.FloatField()), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='CustomerPolicyTP', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('effectiveFrom', models.DateField()), ('effectiveTill', models.DateField()), ('year', models.IntegerField()), ('value', models.FloatField()), ('totalAmount', models.FloatField()), ('commission', models.FloatField()), ('policyType', models.BooleanField()), ('name', models.CharField(max_length=50)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('fixedValue', models.FloatField()), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='InsuranceCompany', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('name', models.CharField(max_length=50)), ('logo', models.ImageField(upload_to='')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='PolicyComprehensive', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('repairType', models.BooleanField()), ('minVehicle', models.FloatField()), ('maxVehicle', models.FloatField()), ('premium', models.FloatField()), ('minAmount', models.FloatField()), ('commission', models.FloatField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('insuranceCompany', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.InsuranceCompany')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='PolicyTP', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('fixedValue', models.FloatField()), ('minVehicle', models.FloatField()), ('maxVehicle', models.FloatField()), ('commission', models.FloatField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('insuranceCompany', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.InsuranceCompany')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='VehicleMake', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('name', models.CharField(max_length=50)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='VehicleModel', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('name', models.CharField(max_length=50)), ('make', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.VehicleMake')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='VehicleValue', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('deleted_at', models.DateTimeField(blank=True, null=True)), ('value', models.FloatField()), ('year', models.IntegerField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('make', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.VehicleModel')), ], options={ 'abstract': False, }, ), migrations.DeleteModel(name='AdminProfile', ), migrations.AddField( model_name='customerpolicytp', name='insuranceCompany', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.InsuranceCompany'), ), migrations.AddField( model_name='customerpolicytp', name='model', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.VehicleModel'), ), migrations.AddField( model_name='customerpolicycomprehensive', name='insuranceCompany', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.InsuranceCompany'), ), migrations.AddField( model_name='customerpolicycomprehensive', name='model', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='IMSAdmin.VehicleModel'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='TiposCartao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)), ('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'TiposCartao', 'managed': False, }, ), migrations.CreateModel( name='Bairros', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('cod_bairro', models.CharField(blank=True, db_column='CodBairro', max_length=50, null=True)), ('data_criacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('data_atualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Bairros', }, ), migrations.CreateModel( name='Banco', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=200, null=True)), ('sigla', models.CharField(blank=True, db_column='Sigla', max_length=5, null=True)), ('numeroregisto', models.CharField(blank=True, db_column='NumeroRegisto', max_length=50, null=True)), ('swiftcode', models.CharField(blank=True, db_column='SwiftCode', max_length=10, null=True)), ('codbanco', models.CharField(blank=True, db_column='CodBanco', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Banco', }, ), migrations.CreateModel( name='CartaConducao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('numlicenca', models.CharField(blank=True, db_column='NumLicenca', max_length=50, null=True)), ('dataemissao', models.DateField(blank=True, db_column='DataEmissao', null=True)), ('dataprimeiraemissao', models.DateField(blank=True, db_column='DataPrimeiraEmissao', null=True)), ('datavalidade', models.DateField(blank=True, db_column='DataValidade', null=True)), ('caminhoficheiro', models.CharField(blank=True, db_column='CaminhoFicheiro', max_length=256, null=True)), ('codcartaconducao', models.CharField(blank=True, db_column='CodCartaConducao', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'CartaConducao', }, ), migrations.CreateModel( name='Cidades', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('codcidade', models.CharField(blank=True, db_column='CodCidade', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Cidades', }, ), migrations.CreateModel( name='Enderecos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('codendereco', models.CharField(blank=True, db_column='CodEndereco', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Enderecos', }, ), migrations.CreateModel( name='EntidadeEmissora', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)), ('codentidadeemissora', models.CharField(blank=True, db_column='CodEntidadeEmissora', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'EntidadeEmissora', }, ), migrations.CreateModel( name='EstadoCivil', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codestadocivil', models.CharField(blank=True, db_column='CodEstadoCivil', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'EstadoCivil', }, ), migrations.CreateModel( name='Generos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codGenero', models.CharField(blank=True, db_column='CodGenero', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Generos', }, ), migrations.CreateModel( name='Paises', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('codigopais', models.CharField(blank=True, db_column='CodigoPais', max_length=5, null=True)), ('ddd', models.CharField(blank=True, db_column='DDI', max_length=5, null=True)), ('codpais', models.CharField(blank=True, db_column='CodPais', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Paises', }, ), migrations.CreateModel( name='RestricoesCategorias', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)), ('codrestricoescategorias', models.CharField(blank=True, db_column='CodRestricoesCategorias', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'RestricoesCategorias', }, ), migrations.CreateModel( name='RestricoesPessoais', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)), ('codrestricoespessoais', models.CharField(blank=True, db_column='CodRestricoesPessoais', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'RestricoesPessoais', }, ), migrations.CreateModel( name='RestricoesViaturas', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)), ('codrestricoesviaturas', models.CharField(blank=True, db_column='CodRestricoesViaturas', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'RestricoesViaturas', }, ), migrations.CreateModel( name='TipoContactos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codtipocontacto', models.CharField(blank=True, db_column='CodTipoContacto', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'TipoContactos', }, ), migrations.CreateModel( name='TiposCartaConducao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=200, null=True)), ('categoria', models.CharField(blank=True, db_column='Categoria', max_length=200, null=True)), ('codigo', models.CharField(blank=True, db_column='Codigo', max_length=5, null=True)), ('codtiposcartaconducao', models.CharField(blank=True, db_column='CodTiposCartaConducao', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'TiposCartaConducao', }, ), migrations.CreateModel( name='TiposConta', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('designacao', models.CharField(blank=True, db_column='Designacao', max_length=100, null=True)), ('codtipoconta', models.CharField(blank=True, db_column='CodTipoConta', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'TiposConta', }, ), migrations.CreateModel( name='TiposEndereco', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('tipoendereco', models.CharField(blank=True, db_column='TipoEndereco', max_length=100, null=True)), ('codtipoEndereco', models.CharField(blank=True, db_column='CodTipoEndereco', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'TiposEndereco', }, ), migrations.CreateModel( name='TiposSanguineos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('tiposanguineo', models.CharField(blank=True, db_column='TipoSanguineo', max_length=5, null=True)), ('codtiposanguineo', models.CharField(blank=True, db_column='CodTipoSanguineo', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='dataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='ataAtualizacao', null=True)), ], options={ 'db_table': 'TiposSanguineos', }, ), migrations.CreateModel( name='Titulos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('titulo', models.CharField(blank=True, db_column='Titulo', max_length=100, null=True)), ('abreviacao', models.CharField(blank=True, db_column='Abreviacao', max_length=50, null=True)), ('codtitulo', models.CharField(blank=True, db_column='CodTitulo', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ], options={ 'db_table': 'Titulos', }, ), migrations.CreateModel( name='User_permissions', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('permission', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='auth.Permission')), ], ), migrations.CreateModel( name='User', fields=[ ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('id', models.UUIDField(editable=False, primary_key=True, serialize=False)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', through='Api.User_permissions', to='auth.Permission')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.AddField( model_name='user_permissions', name='user', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_permis', to=settings.AUTH_USER_MODEL), ), migrations.CreateModel( name='Ruas', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('codrua', models.CharField(blank=True, db_column='CodRua', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('bairroid', models.ForeignKey(blank=True, db_column='BairroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Bairros')), ], options={ 'db_table': 'Ruas', }, ), migrations.CreateModel( name='RestricoesViaturaCartaConducao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('codrestricoesviaturacartaconducao', models.CharField(blank=True, db_column='CodRestricoesViaturaCartaConducao', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')), ('restricoesviaturaid', models.ForeignKey(blank=True, db_column='RestricoesViaturaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesViaturas')), ], options={ 'db_table': 'RestricoesViaturaCartaConducao', }, ), migrations.CreateModel( name='RestricoesPessoaisCartaConducao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('codrestricoespessoaiscartaconducao', models.CharField(blank=True, db_column='CodRestricoesPessoaisCartaConducao', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')), ('restricoespessoaisid', models.ForeignKey(blank=True, db_column='RestricoesPessoaisId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesPessoais')), ], options={ 'db_table': 'RestricoesPessoaisCartaConducao', }, ), migrations.CreateModel( name='RestricoesCategoriasCartaConducao', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('codrestricoescategoriascartaconducao', models.CharField(blank=True, db_column='CodRestricoesCategoriasCartaConducao', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('cartaconducaoid', models.ForeignKey(blank=True, db_column='CartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.CartaConducao')), ('restricoescategoriasid', models.ForeignKey(blank=True, db_column='RestricoesCategoriasId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.RestricoesCategorias')), ], options={ 'db_table': 'RestricoesCategoriasCartaConducao', }, ), migrations.CreateModel( name='Provincias', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('codprovincia', models.CharField(blank=True, db_column='CodProvincia', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('paisid', models.ForeignKey(blank=True, db_column='PaisId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Paises')), ], options={ 'db_table': 'Provincias', }, ), migrations.CreateModel( name='Pessoa', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('primeironome', models.CharField(blank=True, db_column='PrimeiroNome', max_length=100, null=True)), ('nomedomeio', models.CharField(blank=True, db_column='NomeDoMeio', max_length=100, null=True)), ('ultimonome', models.CharField(blank=True, db_column='UltimoNome', max_length=100, null=True)), ('nomecompleto', models.CharField(blank=True, db_column='NomeCompleto', max_length=200, null=True)), ('nomecurto', models.CharField(blank=True, db_column='NomeCurto', max_length=100, null=True)), ('pseudonimo', models.CharField(blank=True, db_column='Pseudonimo', max_length=100, null=True)), ('datanascimento', models.DateField(blank=True, db_column='DataNascimento', null=True)), ('nif', models.CharField(blank=True, db_column='NIF', max_length=50, null=True, unique=True)), ('numsegurancasocial', models.CharField(blank=True, db_column='NumSegurancaSocial', max_length=50, null=True)), ('codpessoa', models.CharField(blank=True, db_column='CodPessoa', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('estadocivilid', models.ForeignKey(blank=True, db_column='EstadoCivilId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.EstadoCivil')), ('generoid', models.ForeignKey(blank=True, db_column='GeneroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Generos')), ('tiposanguineoid', models.ForeignKey(blank=True, db_column='TipoSanguineoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposSanguineos')), ('tituloid', models.ForeignKey(blank=True, db_column='TituloId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Titulos')), ], options={ 'db_table': 'Pessoa', }, ), migrations.CreateModel( name='Municipios', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('codmunicipio', models.CharField(blank=True, db_column='CodMunicipio', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('provinciaid', models.ForeignKey(blank=True, db_column='ProvinciaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Provincias')), ], options={ 'db_table': 'Municipios', }, ), migrations.CreateModel( name='Motorista', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('codmotorista', models.CharField(blank=True, db_column='CodMotorista', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('pessoaid', models.ForeignKey(blank=True, db_column='PessoaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')), ], options={ 'db_table': 'Motorista', }, ), migrations.CreateModel( name='Moradas', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('numeroporta', models.IntegerField(blank=True, db_column='NumeroPorta', null=True)), ('numerocasa', models.IntegerField(blank=True, db_column='NumeroCasa', null=True)), ('caixapostal', models.IntegerField(blank=True, db_column='CaixaPostal', null=True)), ('numeroandar', models.IntegerField(blank=True, db_column='NumeroAndar', null=True)), ('latitude', models.FloatField(blank=True, db_column='Latitude', null=True)), ('longitude', models.FloatField(blank=True, db_column='Longitude', null=True)), ('pontoreferencia', models.CharField(blank=True, db_column='PontoReferencia', max_length=100, null=True)), ('codmunicipio', models.CharField(blank=True, db_column='CodMunicipio', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('cidadeid', models.ForeignKey(blank=True, db_column='CidadeId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Cidades')), ('enderecoid', models.ForeignKey(blank=True, db_column='EnderecoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Enderecos')), ], options={ 'db_table': 'Moradas', }, ), migrations.AddField( model_name='enderecos', name='ruaid', field=models.ForeignKey(blank=True, db_column='RuaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Ruas'), ), migrations.AddField( model_name='enderecos', name='tipoenderecoId', field=models.ForeignKey(blank=True, db_column='TipoEnderecoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposEndereco'), ), migrations.CreateModel( name='Distritos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('coddistrito', models.CharField(blank=True, db_column='CodDistrito', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('municipioid', models.ForeignKey(blank=True, db_column='municipioid', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Municipios')), ], options={ 'db_table': 'Distritos', }, ), migrations.CreateModel( name='ContaFinanceira', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('refcontafinanceira', models.CharField(blank=True, db_column='RefContaFinanceira', max_length=50, null=True)), ('numeroconta', models.IntegerField(blank=True, db_column='NumeroConta', null=True)), ('nomeconta', models.CharField(blank=True, db_column='NomeConta', max_length=200, null=True)), ('descricao', models.TextField(blank=True, db_column='Descricao', null=True)), ('iban', models.CharField(blank=True, db_column='IBAN', max_length=100, null=True)), ('nib', models.CharField(blank=True, db_column='NIB', max_length=100, null=True)), ('limiteconta', models.FloatField(blank=True, db_column='LimiteConta', null=True)), ('dataencerramento', models.DateField(blank=True, db_column='DataEncerramento', null=True)), ('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('bancoid', models.ForeignKey(blank=True, db_column='BancoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Banco')), ('tipocontaid', models.ForeignKey(blank=True, db_column='TipoContaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposConta')), ('titulardacontaid', models.ForeignKey(blank=True, db_column='TitularDaContaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')), ], options={ 'db_table': 'ContaFinanceira', }, ), migrations.CreateModel( name='Contactos', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('telemovel', models.IntegerField(blank=True, db_column='Telemovel', null=True)), ('telefone', models.IntegerField(blank=True, db_column='Telefone', null=True)), ('email', models.CharField(blank=True, db_column='Email', max_length=256, null=True)), ('fax', models.IntegerField(blank=True, db_column='Fax', null=True)), ('website', models.CharField(blank=True, db_column='WebSite', max_length=256, null=True)), ('ddi', models.CharField(blank=True, db_column='DDI', max_length=5, null=True)), ('codcontacto', models.CharField(blank=True, db_column='CodContacto', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('pessoaid', models.ForeignKey(blank=True, db_column='PessoaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Pessoa')), ('tipocontactoid', models.ForeignKey(blank=True, db_column='TipoContactoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TipoContactos')), ], options={ 'db_table': 'Contactos', }, ), migrations.AddField( model_name='cidades', name='bairroid', field=models.ForeignKey(blank=True, db_column='BairroId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Provincias'), ), migrations.CreateModel( name='Cartoes', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('nome', models.CharField(blank=True, db_column='Nome', max_length=100, null=True)), ('numero', models.IntegerField(blank=True, db_column='Numero', null=True)), ('dataexpiracao', models.DateField(blank=True, db_column='DataExpiracao', null=True)), ('codcontafinanceira', models.CharField(blank=True, db_column='CodContaFinanceira', max_length=50, null=True)), ('datacriacao', models.DateTimeField(blank=True, db_column='DataCriacao', null=True)), ('dataatualizacao', models.DateTimeField(blank=True, db_column='DataAtualizacao', null=True)), ('contafinanceiraid', models.ForeignKey(blank=True, db_column='ContaFinanceiraId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.ContaFinanceira')), ('tipocartaoid', models.ForeignKey(blank=True, db_column='TipoCartaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposCartao')), ], options={ 'db_table': 'Cartoes', }, ), migrations.AddField( model_name='cartaconducao', name='entidadeemissoraid', field=models.ForeignKey(blank=True, db_column='EntidadeEmissoraId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.EntidadeEmissora'), ), migrations.AddField( model_name='cartaconducao', name='motoristaid', field=models.ForeignKey(blank=True, db_column='MotoristaId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Motorista'), ), migrations.AddField( model_name='cartaconducao', name='tipocartaconducaoid', field=models.ForeignKey(blank=True, db_column='TipoCartaConducaoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.TiposCartaConducao'), ), migrations.AddField( model_name='bairros', name='distrito_id', field=models.ForeignKey(blank=True, db_column='DistritoId', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='Api.Distritos'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='Fee', fields=[ ('uuid', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('amount', models.FloatField(default=0.0)), ], ), migrations.CreateModel( name='Project', fields=[ ('uuid', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('title', models.CharField(max_length=200, unique=True)), ('unit', models.IntegerField(choices=[(0, 'hectareas'), (1, 'árboles'), (2, 'toneladas'), (3, 'euros')], default=3)), ('description', models.TextField()), ('visible', models.BooleanField(default=True)), ('got', models.IntegerField()), ('goal', models.IntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Proyecto', }, ), migrations.CreateModel( name='FeeDistribution', fields=[ ('uuid', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('percentage', models.FloatField(default=0.0)), ('fee', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Fee')), ('project', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='api.Project')), ], options={ 'verbose_name': 'DistribucionCuota', }, ), migrations.CreateModel( name='Socio', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField( default=False, help_text= 'Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('first_name', models.CharField(blank=True, max_length=30, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('is_staff', models.BooleanField( default=False, help_text= 'Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField( default=True, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('type', models.IntegerField(choices=[(0, 'Admin'), (1, 'Socio'), (2, 'Trabajador'), (3, 'Voluntario')], default=3)), ('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')), ('username', models.CharField(blank=True, max_length=150, unique=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True)), ('fee', models.OneToOneField( on_delete=django.db.models.deletion.DO_NOTHING, to='api.Fee')), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'Socio', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='CustomUser', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(blank=True, max_length=255, null=True, unique=True)), ('telephone', models.IntegerField(blank=True, default=0, null=True)), ('first_name', models.CharField(blank=True, max_length=30, null=True)), ('last_name', models.CharField(blank=True, max_length=255, null=True)), ('username', models.CharField(blank=True, max_length=30, null=True, unique=True)), ('application_fee', models.IntegerField(blank=True, default=10000, null=True)), ('Role', models.CharField(choices=[('Admin', 'Admin'), ('Ordinary', 'Ordinary')], max_length=250)), ('is_active', models.BooleanField(default=True)), ('is_staff', models.BooleanField(default=False)), ('is_superuser', models.BooleanField(default=False)), ('groups', models.ManyToManyField( blank=True, help_text= 'The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField( blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Attendance', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('full_name', models.CharField(blank=True, max_length=123, null=True)), ('date', models.DateField(blank=True, null=True)), ('status', models.BooleanField(blank=True, default=False)), ('social_fund', models.IntegerField(blank=True, default=0, null=True)), ('attendance_year', models.CharField(blank=True, default=2020, max_length=255, null=True)), ('attendance_month', models.CharField(blank=True, max_length=255, null=True)), ], ), migrations.CreateModel( name='Cycle', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cycle_name', models.CharField(blank=True, max_length=220, null=True, unique=True)), ('rate', models.IntegerField(blank=True, default=15, null=True)), ('cycle_period_start', models.DateField(max_length=255, unique=True)), ('cycle_period_end', models.DateField(max_length=255, unique=True)), ('is_active', models.BooleanField(default=True)), ], ), migrations.CreateModel( name='LookUp', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=220, unique=True)), ], ), migrations.CreateModel( name='PayingLoan', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('loan_id', models.CharField(blank=True, max_length=100, null=True)), ('date', models.DateField(blank=True, max_length=100, null=True)), ('name', models.CharField(blank=True, max_length=100, null=True)), ('amount', models.IntegerField(blank=True, default=0, null=True)), ], ), migrations.CreateModel( name='Stock', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('ticker', models.CharField(max_length=10)), ('openn', models.FloatField()), ('close', models.FloatField()), ('volume', models.IntegerField()), ], ), migrations.CreateModel( name='Saving', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField(blank=True, max_length=100, null=True)), ('amount', models.IntegerField(default=0)), ('cycle', models.ForeignKey( blank=True, max_length=100, null=True, on_delete=django.db.models.deletion.SET_NULL, to='savingsapp.Cycle')), ('name', models.ForeignKey( blank=True, max_length=100, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='LookupDetail', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('Details', models.CharField(max_length=220)), ('Lookup_Name', models.ForeignKey(max_length=220, on_delete=django.db.models.deletion.CASCADE, to='savingsapp.LookUp')), ], ), migrations.CreateModel( name='Loan', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cycle', models.CharField(blank=True, max_length=100, null=True)), ('date', models.DateField(blank=True, max_length=100, null=True)), ('amount', models.IntegerField(default=0)), ('interest_rate', models.IntegerField(default=0)), ('loan_period', models.IntegerField(default=0)), ('loan_status', models.CharField(blank=True, choices=[('RUNNING', 'RUNNING'), ('SETTLED', 'SETTLED')], default='RUNNING', max_length=100, null=True)), ('recorded_by', models.CharField(blank=True, max_length=220, null=True)), ('name', models.ForeignKey( blank=True, max_length=100, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ], ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('is_professor', models.BooleanField(default=False)), ('is_aluno', models.BooleanField(default=False)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.Group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.Permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'user', 'verbose_name_plural': 'users', 'abstract': False, }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Disciplina', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nome', models.CharField(max_length=32)), ('descricao', models.TextField(default='Uma descrição')), ], ), migrations.CreateModel( name='Horario', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('diaSemana', models.IntegerField(choices=[(2, 'Segunda'), (3, 'Terça'), (4, 'Quarta'), (5, 'Quinta'), (6, 'Sexta'), (7, 'Sábado')])), ('horarioInicio', models.TimeField()), ('horarioFim', models.TimeField()), ], ), migrations.CreateModel( name='Inscricao', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')), ], ), migrations.CreateModel( name='Laboratorio', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('localizacao', models.CharField(max_length=10, unique=True)), ('capacidade', models.PositiveIntegerField()), ], ), migrations.CreateModel( name='Sala', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('localizacao', models.CharField(max_length=10, unique=True)), ('capacidade', models.PositiveIntegerField()), ], ), migrations.CreateModel( name='Semestre', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('ano', models.PositiveIntegerField()), ('periodo', models.PositiveIntegerField()), ], ), migrations.CreateModel( name='Aluno', fields=[ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='core.user')), ('matricula', models.CharField(max_length=12, unique=True)), ('nome', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='Professor', fields=[ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='core.user')), ('matricula', models.CharField(max_length=12, unique=True)), ('nome', models.CharField(max_length=32)), ], ), migrations.CreateModel( name='Turma', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')), ('horarioLaboratorio', models.ManyToManyField(related_name='horarios_laboratorio', to='core.Horario')), ('horarioSala', models.ManyToManyField(related_name='horarios_sala', to='core.Horario')), ('laboratorio', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='laboratorios_turmas', to='core.laboratorio')), ('sala', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='salas_turmas', to='core.sala')), ('semestre', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre')), ('professor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.professor')), ], ), migrations.CreateModel( name='Prazo', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('prazo', models.DateField()), ('disciplina', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.disciplina')), ('semestre', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre')), ], ), migrations.CreateModel( name='Nota', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nota', models.FloatField()), ('inscricao', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.inscricao')), ], ), migrations.AddField( model_name='inscricao', name='semestre', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.semestre'), ), migrations.AddField( model_name='inscricao', name='turma', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.turma'), ), migrations.AddField( model_name='inscricao', name='aluno', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.aluno'), ), ]