ht80/houduan/ai_planner/migrations/0001_initial.py

# 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': '景点',
            },
        ),
    ]