# Generated by Django 5.2.4 on 2025-08-10 15:32 import django.db.models.deletion from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='City', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50, verbose_name='城市名称')), ('code', models.CharField(max_length=20, unique=True, verbose_name='城市代码')), ('description', models.TextField(blank=True, verbose_name='城市描述')), ('image', models.ImageField(blank=True, null=True, upload_to='cities/', verbose_name='城市图片')), ('is_hot', models.BooleanField(default=False, verbose_name='是否热门')), ('latitude', models.DecimalField(blank=True, decimal_places=6, help_text='例如：北京的纬度是39.9042', max_digits=9, null=True, verbose_name='纬度')), ('longitude', models.DecimalField(blank=True, decimal_places=6, help_text='例如：北京的经度是116.4074', max_digits=9, null=True, verbose_name='经度')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')), ('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')), ], options={ 'verbose_name': '城市', 'verbose_name_plural': '城市', }, ), migrations.CreateModel( name='RedTourismDayPlan', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('day_number', models.PositiveIntegerField(verbose_name='第几天')), ('theme', models.CharField(max_length=100, verbose_name='当日主题')), ('summary', models.TextField(blank=True, verbose_name='当日总结')), ('transport', models.CharField(max_length=50, verbose_name='交通方式')), ('travel_tips', models.JSONField(default=list, verbose_name='旅行提示')), ], options={ 'verbose_name': '红色旅游每日行程', 'verbose_name_plural': '红色旅游每日行程', 'ordering': ['plan', 'day_number'], }, ), migrations.CreateModel( name='RedTourismPlan', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=200, verbose_name='行程标题')), ('description', models.TextField(verbose_name='行程描述')), ('days', models.PositiveIntegerField(verbose_name='天数')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')), ('last_updated', models.DateTimeField(auto_now=True, verbose_name='最后更新时间')), ('is_red_tourism', models.BooleanField(default=True, verbose_name='是否红色旅游')), ('statistics', models.JSONField(default=dict, verbose_name='统计数据')), ('education_goals', models.JSONField(default=list, verbose_name='教育目标')), ('original_data', models.JSONField(default=dict, verbose_name='原始数据')), ], options={ 'verbose_name': '红色旅游行程', 'verbose_name_plural': '红色旅游行程', 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='RedTourismSpot', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('spot_id', models.CharField(max_length=50, verbose_name='景点ID')), ('name', models.CharField(max_length=100, verbose_name='景点名称')), ('description', models.TextField(verbose_name='景点描述')), ('address', models.CharField(max_length=200, verbose_name='地址')), ('open_hours', models.CharField(max_length=50, verbose_name='开放时间')), ('ticket_info', models.CharField(max_length=100, verbose_name='门票信息')), ('history_significance', models.TextField(verbose_name='历史意义')), ('image', models.URLField(max_length=500, verbose_name='图片URL')), ('latitude', models.FloatField(verbose_name='纬度')), ('longitude', models.FloatField(verbose_name='经度')), ('visit_time', models.CharField(max_length=50, verbose_name='参观时间')), ('duration', models.PositiveIntegerField(verbose_name='参观时长(分钟)')), ('order', models.PositiveIntegerField(verbose_name='排序')), ('visiting_etiquette', models.JSONField(default=list, verbose_name='参观礼仪')), ('is_red_tourism', models.BooleanField(default=True, verbose_name='是否红色景点')), ], options={ 'verbose_name': '红色旅游景点', 'verbose_name_plural': '红色旅游景点', 'ordering': ['day_plan', 'order'], }, ), migrations.CreateModel( name='Attraction', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, verbose_name='景点名称')), ('description', models.TextField(verbose_name='景点描述')), ('history_significance', models.TextField(blank=True, verbose_name='历史意义')), ('learning_point', models.TextField(blank=True, verbose_name='学习要点')), ('short_desc', models.CharField(blank=True, max_length=200, verbose_name='简短描述')), ('address', models.CharField(max_length=200, verbose_name='地址')), ('latitude', models.FloatField(blank=True, null=True, verbose_name='纬度')), ('longitude', models.FloatField(blank=True, null=True, verbose_name='经度')), ('ticket_price', models.DecimalField(decimal_places=2, default=0, max_digits=8, verbose_name='门票价格')), ('ticket_info', models.CharField(blank=True, default='凭身份证免费参观', max_length=100, verbose_name='门票信息')), ('open_hours', models.CharField(blank=True, max_length=100, verbose_name='开放时间')), ('image', models.ImageField(blank=True, null=True, upload_to='attractions/', verbose_name='景点图片')), ('tags', models.JSONField(default=list, verbose_name='标签')), ('history', models.TextField(blank=True, verbose_name='历史背景')), ('is_featured', models.BooleanField(default=False, verbose_name='是否特色')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('city', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='attractions', to='ai_planner.city')), ], options={ 'verbose_name': '景点', 'verbose_name_plural': '景点', }, ), ]