class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('Main', '0007_auto_20210204_2100'),
]
operations = [
migrations.RemoveField(
model_name='investmentinfo',
name='id',
),
migrations.AddField(
model_name='investmentinfo',
name='date_created',
field=models.DateTimeField(auto_now_add=True, null=True),
),
migrations.AlterField(
model_name='investmentinfo',
name='monthly_expenses',
field=models.FloatField(),
),
migrations.AlterField(
model_name='investmentinfo',
name='monthly_income',
field=models.FloatField(),
),
migrations.AlterField(
model_name='investmentinfo',
name='user',
field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Balance',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('expense', models.FloatField(default=0)),
('income', models.FloatField(default=0)),
('user', models.OneToOneField(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Expense',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('subcategories', models.CharField(max_length=15)),
('source', models.CharField(max_length=15)),
('paid_to', models.CharField(max_length=50)),
('cost', models.IntegerField()),
('tax_details', models.FloatField()),
('date_created', models.DateField(default=django.utils.timezone.now)),
('bill', models.FileField(blank=True, null=True, upload_to='bills')),
('vat', models.CharField(blank=True, max_length=50, null=True)),
('ext_ref', models.CharField(blank=True, max_length=10, null=True)),
('description', models.CharField(blank=True, max_length=100, null=True)),
('is_recurrent', models.CharField(max_length=10)),
('rec_date', models.DateField(default=django.utils.timezone.now)),
('rec_year', models.IntegerField(blank=True, null=True)),
('rec_month', models.IntegerField(blank=True, null=True)),
('rec_day', models.IntegerField(blank=True, null=True)),
('option', models.CharField(max_length=15)),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='UserDetails',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('company_name', models.CharField(max_length=100)),
('dob', models.DateField(null=True)),
('address', models.CharField(max_length=100)),
('hire_date', models.DateField(null=True)),
('phone_no', models.IntegerField()),
('photo', models.ImageField(null=True, upload_to='profile')),
('occupation', models.CharField(max_length=15)),
('yearly_package', models.PositiveIntegerField(null=True)),
('pf', models.PositiveIntegerField(default=5)),
('res_address', models.CharField(max_length=100)),
('user', models.OneToOneField(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('Main', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Loan',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('loan_name', models.CharField(max_length=50)),
('loan_amount', models.PositiveIntegerField()),
('no_of_years', models.IntegerField(default=20)),
('date_of_payment',
models.DateField(default=django.utils.timezone.now)),
('rate_of_interest', models.FloatField(default=10.0)),
('type', models.CharField(max_length=15)),
('is_calender', models.BooleanField(default=False)),
('user',
models.ForeignKey(default=1,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
bases=(models.Model, Main.models.Main),
),
migrations.CreateModel(
name='Premium',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('lic_name', models.CharField(max_length=50, null=True)),
('start_date', models.DateField(null=True)),
('end_date', models.DateField()),
('type', models.CharField(max_length=15)),
('premium_amount', models.PositiveIntegerField()),
('end_year', models.DateField()),
('is_calender', models.BooleanField(default=False)),
('user',
models.ForeignKey(default=1,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
bases=(models.Model, Main.models.Main),
),
]
class Migration(migrations.Migration):
dependencies = [
('Main', '0001_initial'),
]
operations = [
migrations.AddField(
model_name='course',
name='assignment',
field=models.FileField(null=True, upload_to=Main.models.upload_path),
),
migrations.AddField(
model_name='course',
name='ratings',
field=models.FloatField(null=True),
),
migrations.AddField(
model_name='module',
name='flag',
field=models.BooleanField(default=False),
),
migrations.AddField(
model_name='student',
name='Linkdein',
field=models.URLField(max_length=500, null=True),
),
migrations.AddField(
model_name='teacher',
name='Education',
field=models.CharField(max_length=200, null=True),
),
migrations.AddField(
model_name='teacher',
name='Institute_Organization',
field=models.CharField(max_length=200, null=True),
),
migrations.AddField(
model_name='teacher',
name='Linkdein',
field=models.URLField(max_length=500, null=True),
),
migrations.AddField(
model_name='teacher',
name='Quote',
field=models.TextField(blank=True, null=True),
),
migrations.AddField(
model_name='teacher',
name='Specialization',
field=models.CharField(max_length=200, null=True),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('Main', '0010_auto_20161003_1436'),
]
operations = [
migrations.CreateModel(
name='LoanPremium',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('loan_premium_name', models.CharField(max_length=50,
null=True)),
('loan_premium_amount',
models.PositiveIntegerField(null=True)),
('start_date', models.DateField(null=True)),
('end_date', models.DateField(default=2004, null=True)),
('description', models.CharField(max_length=200, null=True)),
('no_of_years', models.IntegerField(default=20, null=True)),
('rate_of_interest', models.FloatField(default=10.0,
null=True)),
('type_loan_premium', models.CharField(max_length=15,
null=True)),
('type_duration', models.CharField(max_length=15, null=True)),
('is_calender', models.BooleanField(default=False)),
('user',
models.ForeignKey(default=1,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
bases=(models.Model, Main.models.Main),
),
migrations.RemoveField(
model_name='loan',
name='user',
),
migrations.RemoveField(
model_name='premium',
name='user',
),
migrations.DeleteModel(name='Loan', ),
migrations.DeleteModel(name='Premium', ),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Actor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ActorId',
models.CharField(blank=True,
editable=False,
max_length=50,
unique=True,
verbose_name='演员id')),
('ActorName',
models.CharField(max_length=50, verbose_name='演员姓名')),
('ActorArea',
models.CharField(blank=True,
default='未知',
max_length=50,
verbose_name='演员地区')),
('ActorSex',
models.SmallIntegerField(choices=[(1, '男'), (2, '女'),
(3, '未知')],
default=3,
verbose_name='演员性别')),
],
options={
'verbose_name': '演员信息',
'verbose_name_plural': '演员信息',
},
),
migrations.CreateModel(
name='ActorConnection',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ActorId',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='Main.Actor',
to_field='ActorId',
verbose_name='演员id')),
],
options={
'verbose_name': '参演信息',
'verbose_name_plural': '参演信息',
},
),
migrations.CreateModel(
name='Agree',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('RecordId',
models.CharField(blank=True,
editable=False,
max_length=100,
unique=True,
verbose_name='实体id')),
('TargetId',
models.CharField(max_length=50, verbose_name='目标id')),
('RecordTime', models.DateTimeField(auto_now_add=True)),
('AgreeType',
models.PositiveSmallIntegerField(choices=[(1, '评论'),
(2, '标签')],
verbose_name='点赞类型')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='EditRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('RecordId',
models.CharField(blank=True,
editable=False,
max_length=100,
unique=True,
verbose_name='实体id')),
('TargetId',
models.CharField(max_length=50, verbose_name='目标id')),
('RecordTime', models.DateTimeField(auto_now_add=True)),
('EditType',
models.PositiveSmallIntegerField(choices=[(1, '修改信息'),
(2, '添加标签')],
verbose_name='编辑类型')),
('EditContent', models.TextField(verbose_name='修改内容')),
],
options={
'verbose_name': '编辑记录',
'verbose_name_plural': '编辑记录',
},
),
migrations.CreateModel(
name='FavoriteRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('RecordId',
models.CharField(blank=True,
editable=False,
max_length=100,
unique=True,
verbose_name='实体id')),
('TargetId',
models.CharField(max_length=50, verbose_name='目标id')),
('RecordTime', models.DateTimeField(auto_now_add=True)),
('FavoriteType',
models.PositiveSmallIntegerField(choices=[(1, '电影')],
default=1,
verbose_name='收藏类型')),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='IDCount',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('Type',
models.CharField(max_length=20,
unique=True,
verbose_name='id类型')),
('Count',
models.PositiveIntegerField(default=0,
editable=False,
verbose_name='计数')),
],
),
migrations.CreateModel(
name='Movie',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('MovId',
models.CharField(blank=True,
editable=False,
max_length=50,
unique=True)),
('MovName',
models.CharField(max_length=100, verbose_name='电影标题')),
('MovType', models.IntegerField(verbose_name='电影类型')),
('MovLength',
models.IntegerField(default=0, verbose_name='电影时长')),
('MovImg',
models.ImageField(default='static/cover/default_cover.bmp',
upload_to=Main.models.cover_directory_path,
verbose_name='电影封面')),
('MovOrigin',
models.SmallIntegerField(default=16, verbose_name='电影产地')),
('MovCompany',
models.CharField(default='未知',
max_length=100,
verbose_name='电影公司')),
('MovDirector',
models.CharField(default='未知',
max_length=100,
verbose_name='电影导演')),
('MovDescription',
models.TextField(default='无', verbose_name='电影描述')),
('MovDate', models.DateField(default=1,
verbose_name='电影上映时间')),
('MovLanguage',
models.CharField(default='未知',
max_length=50,
verbose_name='电影语言')),
('MovScore',
models.FloatField(default=0.0, verbose_name='电影平均分')),
('MovScoreCount',
models.IntegerField(default=0, verbose_name='评分人数')),
('MovImdbId',
models.IntegerField(default=0, verbose_name='IMDB')),
('MovTmdbId',
models.IntegerField(default=0, verbose_name='TMDB')),
],
options={
'verbose_name': '电影信息',
'verbose_name_plural': '电影信息',
},
),
migrations.CreateModel(
name='MovieTag',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('MovTagId',
models.CharField(blank=True,
editable=False,
max_length=20,
unique=True)),
('MovTagCnt',
models.CharField(max_length=20,
unique=True,
verbose_name='标签内容')),
],
options={
'verbose_name': '电影标签',
'verbose_name_plural': '电影标签',
},
),
migrations.CreateModel(
name='MovTagConnection',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('AgreeCount',
models.PositiveIntegerField(default=0,
editable=False,
verbose_name='点赞数')),
('MovId',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='Main.Movie',
to_field='MovId',
verbose_name='电影id')),
('MovTagId',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='Main.MovieTag',
to_field='MovTagId',
verbose_name='标签id')),
],
options={
'verbose_name': '标签联系信息',
'verbose_name_plural': '标签联系信息',
},
),
migrations.CreateModel(
name='ReplyRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('RecordId',
models.CharField(blank=True,
editable=False,
max_length=100,
unique=True,
verbose_name='实体id')),
('TargetId',
models.CharField(max_length=50, verbose_name='目标id')),
('RecordTime', models.DateTimeField(auto_now_add=True)),
('ReplyType',
models.PositiveSmallIntegerField(choices=[(1, '电影'),
(2, '评论')],
verbose_name='回复类型')),
('ReplyGrade',
models.SmallIntegerField(blank=True,
null=True,
verbose_name='评分')),
('ReplyContent', models.TextField(verbose_name='回复内容')),
('AgreeCount',
models.PositiveIntegerField(default=0,
editable=False,
verbose_name='点赞数')),
],
options={
'verbose_name': '评论记录',
'verbose_name_plural': '评论记录',
},
),
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('UserId',
models.CharField(blank=True,
editable=False,
max_length=30,
unique=True,
verbose_name='用户id')),
('UserPwd', models.CharField(max_length=20,
verbose_name='密码')),
('UserName',
models.CharField(max_length=30,
unique=True,
verbose_name='用户名')),
('UserLevel',
models.SmallIntegerField(default=1, verbose_name='用户等级')),
('UserCurExp',
models.SmallIntegerField(default=0, verbose_name='用户当前经验')),
('UserMaxExp',
models.SmallIntegerField(default=1000,
verbose_name='用户最大经验')),
('Email', models.EmailField(max_length=254)),
('HasView',
models.BooleanField(default=False, verbose_name='是否有过浏览记录')),
],
options={
'verbose_name': '用户信息',
'verbose_name_plural': '用户信息',
},
),
migrations.CreateModel(
name='ViewRecord',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('RecordId',
models.CharField(blank=True,
editable=False,
max_length=100,
unique=True,
verbose_name='实体id')),
('TargetId',
models.CharField(max_length=50, verbose_name='目标id')),
('RecordTime', models.DateTimeField(auto_now_add=True)),
('UserId',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='Main.User',
to_field='UserId',
verbose_name='用户id')),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='replyrecord',
name='UserId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='Main.User',
to_field='UserId',
verbose_name='用户id'),
),
migrations.AddField(
model_name='favoriterecord',
name='UserId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='Main.User',
to_field='UserId',
verbose_name='用户id'),
),
migrations.AddField(
model_name='editrecord',
name='UserId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='Main.User',
to_field='UserId',
verbose_name='用户id'),
),
migrations.AddField(
model_name='agree',
name='UserId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='Main.User',
to_field='UserId',
verbose_name='用户id'),
),
migrations.AddField(
model_name='actorconnection',
name='MovId',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='Main.Movie',
to_field='MovId',
verbose_name='电影id'),
),
migrations.AlterIndexTogether(
name='viewrecord',
index_together={('UserId', 'TargetId')},
),
migrations.AlterUniqueTogether(
name='movtagconnection',
unique_together={('MovTagId', 'MovId')},
),
migrations.AlterIndexTogether(
name='movtagconnection',
index_together={('MovTagId', 'MovId')},
),
migrations.AlterIndexTogether(
name='favoriterecord',
index_together={('UserId', 'TargetId')},
),
migrations.AlterIndexTogether(
name='agree',
index_together={('UserId', 'TargetId')},
),
migrations.AlterUniqueTogether(
name='actorconnection',
unique_together={('ActorId', 'MovId')},
),
migrations.AlterIndexTogether(
name='actorconnection',
index_together={('ActorId', 'MovId')},
),
]