class Migration(migrations.Migration):
dependencies = [
('courses', '0005_delete_resources_20190911_0815'),
]
operations = [
migrations.CreateModel(
name='Resource',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category', models.CharField(choices=[('IC', 'In Class'), ('LL', 'Language Learning'), ('FS', 'Further Study')], default=('IC', 'In Class'), max_length=2)),
('link_URL', models.URLField(blank=True)),
('link_text', models.CharField(blank=True, max_length=30)),
('description', models.TextField(blank=True, max_length=200)),
],
options={
'abstract': False,
},
),
migrations.AlterField(
model_name='worksheet',
name='solution_release_datetime',
field=models.DateTimeField(default=courses.models.Worksheet.default_release_date),
),
migrations.CreateModel(
name='CourseResource',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('category', models.CharField(choices=[('IC', 'In Class'), ('LL', 'Language Learning'), ('FS', 'Further Study')], default=('IC', 'In Class'), max_length=2)),
('link_URL', models.URLField(blank=True)),
('link_text', models.CharField(blank=True, max_length=30)),
('description', models.TextField(blank=True, max_length=200)),
('course', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='courses.Course')),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('orgs', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='CourseInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('image', models.ImageField(max_length=200, upload_to='course/', verbose_name='课程封面')),
('name', models.CharField(max_length=20, verbose_name='课程名称')),
('study_time', models.IntegerField(default=0, verbose_name='学习时长')),
('study_num', models.IntegerField(default=0, verbose_name='学习人数')),
('level', models.CharField(choices=[('gj', '高级'), ('zj', '中级'), ('cj', '初级')], default='cj', max_length=20, verbose_name='课程难度')),
('love_num', models.IntegerField(default=0, verbose_name='收藏数')),
('click_num', models.IntegerField(default=0, verbose_name='点击数')),
('desc', models.CharField(max_length=200, verbose_name='简介')),
('detail', models.TextField(verbose_name='课程详情')),
('category', models.CharField(choices=[('qd', '前端开发'), ('hd', '后端开发')], max_length=20, verbose_name='课程类别')),
('course_notice', models.CharField(max_length=200, verbose_name='课程公告')),
('course_need', models.CharField(max_length=100, verbose_name='课程须知')),
('course_tell', models.CharField(max_length=100, verbose_name='老师教导')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('orginfo', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='orgs.OrgInfo', verbose_name='所属机构')),
('teacherinfo', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='orgs.TeacherInfo', verbose_name='所属讲师')),
],
options={
'verbose_name': '课程信息',
'verbose_name_plural': '课程信息',
},
),
migrations.CreateModel(
name='LessonInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='章节名称')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('courseInfo', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.CourseInfo', verbose_name='所属课程')),
],
options={
'verbose_name': '课程信息',
'verbose_name_plural': '课程信息',
},
),
migrations.CreateModel(
name='SourceInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='资源名称')),
('down_load', models.FileField(max_length=200, upload_to='source/', verbose_name='下载路径')),
('所属课程', models.FileField(upload_to='', verbose_name=courses.models.CourseInfo)),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
],
options={
'verbose_name': '资源信息',
'verbose_name_plural': '资源信息',
},
),
migrations.CreateModel(
name='VideoInfo',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50, verbose_name='视频名称')),
('study_time', models.IntegerField(default=0, verbose_name='视频时长')),
('url', models.URLField(default='http://www.atguigu.com', verbose_name='视频链接')),
('add_time', models.DateTimeField(default=datetime.datetime.now, verbose_name='添加时间')),
('lessoninfo', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.LessonInfo', verbose_name='所属章节')),
],
options={
'verbose_name': '视频信息',
'verbose_name_plural': '视频信息',
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='ConnectionPlatform',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(blank=True, max_length=150)),
('url_link', models.URLField(blank=True)),
('deleted', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='Event',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('is_recurrent', models.BooleanField(default=False, null=True)),
('is_recorded', models.BooleanField(default=False, null=True)),
('event_type', models.CharField(blank=True, choices=[('COURSE', 'Course'), ('EVENT', 'Event')], max_length=50)),
('image', models.ImageField(blank=True, null=True, upload_to=courses.models.upload_event_picture)),
('title', models.CharField(blank=True, max_length=150)),
('description', models.CharField(blank=True, max_length=10000)),
('other_platform', models.CharField(blank=True, max_length=150)),
('reference_price', models.FloatField(blank=True, default=0, null=True)),
('date_created', models.DateTimeField(auto_now_add=True)),
('date_start', models.DateTimeField(blank=True, null=True)),
('date_end', models.DateTimeField(blank=True, null=True)),
('date_recorded', models.DateTimeField(blank=True, null=True)),
('schedule_description', models.CharField(blank=True, max_length=1000)),
('owner', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
('platform', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='courses.ConnectionPlatform')),
],
),
migrations.CreateModel(
name='CertificateRequest',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date', models.DateTimeField(auto_now_add=True, null=True)),
('accepted', models.BooleanField(blank=True, default=None, null=True)),
('deleted', models.BooleanField(blank=True, default=False, null=True)),
('event', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.Event')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Certificate',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date_created', models.DateTimeField(auto_now_add=True)),
('event', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='courses.Event')),
('user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Bookmark',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date', models.DateTimeField(auto_now_add=True, null=True)),
('deleted', models.BooleanField(blank=True, default=False, null=True)),
('event', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='courses.Event')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('taggit', '0002_auto_20150616_2121'),
]
operations = [
migrations.CreateModel(
name='Alternative',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('description', models.TextField(max_length=500)),
('is_correct', models.BooleanField(default=False)),
('created_at', models.DateField(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')),
('name', models.CharField(max_length=100)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'Category',
'verbose_name_plural': 'Categories',
},
),
migrations.CreateModel(
name='Course',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('description', models.TextField(max_length=300)),
('image',
models.ImageField(blank=True,
null=True,
upload_to='images/courses')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='categories',
to='courses.Category')),
],
),
migrations.CreateModel(
name='Document',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('uri',
models.FileField(upload_to=courses.models.upload_to_dir)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Enrollment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='enrollments',
to='courses.Course')),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='+',
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Exam',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=100)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Instructor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('contact', models.EmailField(max_length=100)),
('about', models.TextField(max_length=200)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Question',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('statement', models.TextField(max_length=500)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('exam',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='questions',
to='courses.Exam')),
],
),
migrations.CreateModel(
name='Unit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('description', models.CharField(max_length=100)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('course',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='units',
to='courses.Course')),
],
),
migrations.CreateModel(
name='Video',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=100)),
('uri', models.URLField(max_length=2000)),
('created_at', models.DateField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('unit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='videos',
to='courses.Unit')),
],
),
migrations.AddField(
model_name='exam',
name='unit',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='exams',
to='courses.Unit'),
),
migrations.AddField(
model_name='document',
name='unit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='documents',
to='courses.Unit'),
),
migrations.AddField(
model_name='course',
name='instructor',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='instructors',
to='courses.Instructor'),
),
migrations.AddField(
model_name='course',
name='keywords',
field=taggit.managers.TaggableManager(
help_text='A comma-separated list of tags.',
through='taggit.TaggedItem',
to='taggit.Tag',
verbose_name='keywords'),
),
migrations.AddField(
model_name='alternative',
name='question',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='alternatives',
to='courses.Question'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('contenttypes', '0002_remove_content_type_name'),
]
operations = [
migrations.CreateModel(
name='Content',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('object_id', models.PositiveIntegerField()),
('order', courses.fields.OrderField(blank=True)),
('content_type', models.ForeignKey(limit_choices_to={'model__in': ('text', 'video', 'image', 'file')}, on_delete=django.db.models.deletion.CASCADE, to='contenttypes.ContentType')),
],
options={
'ordering': ['order'],
},
),
migrations.CreateModel(
name='Course',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=200)),
('slug', models.SlugField(max_length=200, unique=True)),
('image', models.ImageField(blank=True, null=True, upload_to=courses.models.upload_location)),
('overview', models.TextField()),
('created', models.DateTimeField(auto_now_add=True)),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='courses_created', to=settings.AUTH_USER_MODEL)),
('students', models.ManyToManyField(blank=True, related_name='courses_joined', to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ('-created',),
},
),
migrations.CreateModel(
name='File',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=250)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('file', models.FileField(upload_to='files')),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='file_related', to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Image',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=250)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('file', models.FileField(upload_to='images')),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='image_related', to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Module',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=200)),
('description', models.TextField(blank=True)),
('order', courses.fields.OrderField(blank=True)),
('course', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='modules', to='courses.Course')),
],
options={
'ordering': ['order'],
},
),
migrations.CreateModel(
name='Subject',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=200)),
('slug', models.SlugField(max_length=200, unique=True)),
],
options={
'ordering': ('title',),
},
),
migrations.CreateModel(
name='Subscription',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('your_email', models.EmailField(blank=True, max_length=254)),
],
),
migrations.CreateModel(
name='Text',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=250)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('content', models.TextField()),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='text_related', to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='Video',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=250)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('url', models.URLField()),
('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='video_related', to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.AddField(
model_name='course',
name='subject',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='courses', to='courses.Subject'),
),
migrations.AddField(
model_name='content',
name='module',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='contents', to='courses.Module'),
),
]