# Generated by Django 3.2.9 on 2025-05-13 08:22

import datetime
from django.conf import settings
import django.contrib.gis.db.models.fields
import django.contrib.postgres.indexes
from django.db import migrations, models
import django.db.models.deletion
import django.utils.timezone
import rog.models
import uuid


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('auth', '0012_alter_user_first_name_max_length'),
    ]

    operations = [
        migrations.CreateModel(
            name='GifuAreas',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(blank=True, null=True, srid=4326)),
                ('adm0_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('area_nm', models.CharField(blank=True, max_length=254, null=True)),
            ],
            options={
                'db_table': 'gifu_areas',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='JpnAdminMainPerf',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(blank=True, null=True, srid=4326)),
                ('adm0_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_pcode', models.CharField(blank=True, max_length=254, null=True)),
            ],
            options={
                'db_table': 'jpn_admin_main_perf',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='JpnSubPerf',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(blank=True, null=True, srid=4326)),
                ('adm0_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm0_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm1_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_ja', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_en', models.CharField(blank=True, max_length=254, null=True)),
                ('adm2_pcode', models.CharField(blank=True, max_length=254, null=True)),
                ('name_modified', models.CharField(blank=True, max_length=254, null=True)),
                ('area_name', models.CharField(blank=True, max_length=254, null=True)),
                ('list_order', models.IntegerField(default=0)),
            ],
            options={
                'db_table': 'jpn_sub_perf',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='CustomUser',
            fields=[
                ('id', models.BigAutoField(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')),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('firstname', models.CharField(blank=True, max_length=255, null=True)),
                ('lastname', models.CharField(blank=True, max_length=255, null=True)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('female', models.BooleanField(default=False)),
                ('group', models.CharField(blank=True, max_length=255)),
                ('is_active', models.BooleanField(default=True)),
                ('is_staff', models.BooleanField(default=False)),
                ('date_joined', models.DateTimeField(default=django.utils.timezone.now)),
                ('is_rogaining', models.BooleanField(default=False)),
                ('zekken_number', models.CharField(blank=True, max_length=255, null=True, verbose_name='Zekken Number')),
                ('event_code', models.CharField(blank=True, max_length=255, null=True, verbose_name='Event Code')),
                ('team_name', models.CharField(blank=True, max_length=255, null=True, verbose_name='Team Name')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Category',
            fields=[
                ('category_name', models.CharField(max_length=255, primary_key=True, serialize=False)),
                ('category_number', models.IntegerField(default=0)),
                ('duration', models.DurationField(default=datetime.timedelta(seconds=18000))),
                ('num_of_member', models.IntegerField(default=1)),
                ('family', models.BooleanField(default=False)),
                ('female', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='CheckinImages',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('checkinimage', models.FileField(blank=True, null=True, upload_to='checkin/%y%m%d')),
                ('checkintime', models.DateTimeField(verbose_name='Goal time')),
                ('team_name', models.CharField(max_length=255, verbose_name='Team name')),
                ('event_code', models.CharField(max_length=255, verbose_name='event code')),
                ('cp_number', models.IntegerField(verbose_name='CP numner')),
            ],
        ),
        migrations.CreateModel(
            name='CheckPoint',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cp_number', models.CharField(max_length=20)),
                ('image_address', models.URLField(blank=True, null=True)),
                ('checkin_time', models.DateTimeField(auto_now_add=True)),
                ('is_service_checked', models.BooleanField(default=False)),
            ],
            options={
                'ordering': ['checkin_time'],
            },
        ),
        migrations.CreateModel(
            name='Entry',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('date', models.DateTimeField()),
                ('zekken_number', models.IntegerField(default=0)),
                ('is_active', models.BooleanField(default=True)),
                ('hasParticipated', models.BooleanField(default=False)),
                ('hasGoaled', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='EntryMember',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('is_temporary', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='Event',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tagname', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('status', models.CharField(choices=[('PREPARING', 'Preparing'), ('PROMOTION', 'Promotion'), ('EVENT', 'Event'), ('END', 'End')], max_length=256)),
                ('price', models.IntegerField(default=0, verbose_name='Paid Amount')),
                ('promotion_date', models.DateTimeField(blank=True, null=True, verbose_name='Promotion date')),
                ('event_start', models.DateTimeField(blank=True, null=True, verbose_name='Promotion date')),
                ('event_end', models.DateTimeField(blank=True, null=True, verbose_name='Promotion date')),
                ('remark', models.CharField(blank=True, max_length=256, null=True)),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='EventUser',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
            ],
        ),
        migrations.CreateModel(
            name='Favorite',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('good', models.IntegerField(default=0, verbose_name='Good')),
                ('favorite', models.IntegerField(default=0, verbose_name='Favorite')),
                ('evaluation', models.IntegerField(default=0, verbose_name='Evaluation')),
                ('number_visit', models.IntegerField(default=0, verbose_name='Good')),
                ('last_visited', models.DateTimeField(blank=True, null=True, verbose_name='Last Visited')),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='GifurogeRegister',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('event_code', models.CharField(max_length=100)),
                ('time', models.IntegerField(choices=[(3, '3時間'), (5, '5時間')])),
                ('owner_name_kana', models.CharField(max_length=100)),
                ('owner_name', models.CharField(max_length=100)),
                ('email', models.EmailField(max_length=254)),
                ('password', models.CharField(max_length=100)),
                ('owner_birthday', models.DateField(blank=True, null=True)),
                ('owner_sex', models.CharField(blank=True, max_length=10, null=True)),
                ('team_name', models.CharField(max_length=100)),
                ('department', models.CharField(max_length=100)),
                ('members_count', models.IntegerField()),
                ('member2', models.CharField(blank=True, max_length=100, null=True)),
                ('birthday2', models.DateField(blank=True, null=True)),
                ('sex2', models.CharField(blank=True, max_length=10, null=True)),
                ('member3', models.CharField(blank=True, max_length=100, null=True)),
                ('birthday3', models.DateField(blank=True, null=True)),
                ('sex3', models.CharField(blank=True, max_length=10, null=True)),
                ('member4', models.CharField(blank=True, max_length=100, null=True)),
                ('birthday4', models.DateField(blank=True, null=True)),
                ('sex4', models.CharField(blank=True, max_length=10, null=True)),
                ('member5', models.CharField(blank=True, max_length=100, null=True)),
                ('birthday5', models.DateField(blank=True, null=True)),
                ('sex5', models.CharField(blank=True, max_length=10, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='GoalImages',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('goalimage', models.FileField(blank=True, null=True, upload_to='goals/%y%m%d')),
                ('goaltime', models.DateTimeField(blank=True, null=True, verbose_name='Goal time')),
                ('team_name', models.CharField(max_length=255, verbose_name='Team name')),
                ('event_code', models.CharField(max_length=255, verbose_name='event code')),
                ('cp_number', models.IntegerField(verbose_name='CP numner')),
                ('zekken_number', models.TextField(blank=True, help_text='ゼッケン番号', null=True)),
            ],
        ),
        migrations.CreateModel(
            name='GpsCheckin',
            fields=[
                ('id', models.AutoField(primary_key=True, serialize=False)),
                ('path_order', models.IntegerField(help_text='チェックポイントの順序番号')),
                ('zekken_number', models.TextField(help_text='ゼッケン番号')),
                ('event_id', models.IntegerField(blank=True, help_text='イベントID', null=True)),
                ('event_code', models.TextField(help_text='イベントコード')),
                ('cp_number', models.IntegerField(blank=True, help_text='チェックポイント番号', null=True)),
                ('lattitude', models.FloatField(blank=True, help_text='緯度：写真から取得', null=True)),
                ('longitude', models.FloatField(blank=True, help_text='経度：写真から取得', null=True)),
                ('image_address', models.TextField(blank=True, help_text='チェックイン画像のパス', null=True)),
                ('image_receipt', models.TextField(blank=True, default=False, help_text='レシート画像のパス', null=True)),
                ('image_qr', models.BooleanField(default=False, help_text='QRコードスキャンフラグ')),
                ('validate_location', models.BooleanField(default=False, help_text='位置情報検証フラグ：画像認識で検証した結果')),
                ('goal_time', models.TextField(blank=True, help_text='ゴール時刻=ゴール時のみ使用される。画像から時刻を読み取り設定する。', null=True)),
                ('late_point', models.IntegerField(blank=True, help_text='遅刻ポイント：ゴールの時刻が制限時間を超えた場合、１分につき-50点が加算。', null=True)),
                ('create_at', models.DateTimeField(blank=True, help_text='作成日時：データの作成日時', null=True)),
                ('create_user', models.TextField(blank=True, help_text='作成ユーザー', null=True)),
                ('update_at', models.DateTimeField(blank=True, help_text='更新日時', null=True)),
                ('update_user', models.TextField(blank=True, help_text='更新ユーザー', null=True)),
                ('buy_flag', models.BooleanField(default=False, help_text='購入フラグ：協賛店で購入した場合、無条件でTRUEにする。')),
                ('colabo_company_memo', models.TextField(default='', help_text='グループコード：複数のイベントで合算する場合に使用する')),
                ('points', models.IntegerField(blank=True, help_text='ポイント：このチェックインによる獲得ポイント。通常ポイントと買い物ポイントは分離される。ゴールの場合には減点なども含む。', null=True)),
            ],
            options={
                'db_table': 'gps_checkins',
            },
        ),
        migrations.CreateModel(
            name='Location',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('location_id', models.IntegerField(blank=True, db_index=True, null=True, verbose_name='Location id')),
                ('sub_loc_id', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Sub location id')),
                ('cp', models.FloatField(default=0, null=True, verbose_name='Check Point')),
                ('location_name', models.CharField(default='--- 場所をお願いします --', max_length=2048, verbose_name='Location Name')),
                ('category', models.CharField(blank=True, db_index=True, max_length=2048, null=True, verbose_name='Category')),
                ('subcategory', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Sub Category')),
                ('zip', models.CharField(blank=True, max_length=12, null=True, verbose_name='Zip code')),
                ('address', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Address')),
                ('prefecture', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Prefecture')),
                ('area', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Area')),
                ('city', models.CharField(blank=True, max_length=2048, null=True, verbose_name='City')),
                ('latitude', models.FloatField(blank=True, null=True, verbose_name='Latitude')),
                ('longitude', models.FloatField(blank=True, null=True, verbose_name='Latitude')),
                ('photos', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Photos')),
                ('videos', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Videos')),
                ('webcontents', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Web Content')),
                ('status', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Status')),
                ('portal', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Portal')),
                ('group', models.CharField(blank=True, db_index=True, max_length=2048, null=True, verbose_name='Group')),
                ('phone', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Phone')),
                ('fax', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Fax')),
                ('email', models.EmailField(blank=True, max_length=2048, null=True, verbose_name='Email')),
                ('facility', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Facility')),
                ('remark', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Remarks')),
                ('tags', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Tags')),
                ('event_name', models.CharField(blank=True, db_index=True, max_length=2048, null=True, verbose_name='Event name')),
                ('event_active', models.BooleanField(db_index=True, default=True, verbose_name='Is Event active')),
                ('hidden_location', models.BooleanField(default=False, verbose_name='Is Hidden Location')),
                ('auto_checkin', models.BooleanField(default=False, verbose_name='Is AutoCheckin')),
                ('checkin_radius', models.FloatField(blank=True, default=15.0, null=True, verbose_name='Checkin radious')),
                ('checkin_point', models.FloatField(blank=True, default=10, null=True, verbose_name='Checkin Point')),
                ('buy_point', models.FloatField(blank=True, default=0, null=True, verbose_name='buy Point')),
                ('evaluation_value', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Evaluation value (評価)')),
                ('shop_closed', models.BooleanField(default=False, verbose_name='Shop Closed (休業)')),
                ('shop_shutdown', models.BooleanField(default=False, verbose_name='Shop Shutdown (閉業)')),
                ('opening_hours_mon', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours monday (月曜)')),
                ('opening_hours_tue', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours tuesday (火曜)')),
                ('opening_hours_wed', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours wednesday (水曜)')),
                ('opening_hours_thu', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours thursday (木曜)')),
                ('opening_hours_fri', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours frinday (金曜)')),
                ('opening_hours_sat', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours saturday (土曜)')),
                ('opening_hours_sun', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours sunday (日曜)')),
                ('parammeters', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
                ('last_updated_user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='location_updated_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='NewCategory',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('category_name', models.CharField(max_length=255, unique=True)),
                ('category_number', models.IntegerField(default=0)),
                ('duration', models.DurationField(default=datetime.timedelta(seconds=18000))),
                ('num_of_member', models.IntegerField(default=1)),
                ('family', models.BooleanField(default=False)),
                ('female', models.BooleanField(default=False)),
                ('trial', models.BooleanField(default=False)),
            ],
            options={
                'unique_together': {('category_name', 'category_number')},
            },
        ),
        migrations.CreateModel(
            name='NewEvent',
            fields=[
                ('event_name', models.CharField(max_length=255, primary_key=True, serialize=False)),
                ('start_datetime', models.DateTimeField(default=django.utils.timezone.now)),
                ('end_datetime', models.DateTimeField()),
            ],
        ),
        migrations.CreateModel(
            name='NewEvent2',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('event_name', models.CharField(max_length=255, unique=True)),
                ('event_description', models.TextField(blank=True, max_length=255, null=True)),
                ('start_datetime', models.DateTimeField(default=django.utils.timezone.now)),
                ('end_datetime', models.DateTimeField()),
                ('deadlineDateTime', models.DateTimeField(blank=True, null=True)),
                ('public', models.BooleanField(default=False)),
                ('hour_3', models.BooleanField(default=False)),
                ('hour_5', models.BooleanField(default=True)),
                ('class_general', models.BooleanField(default=True)),
                ('class_family', models.BooleanField(default=True)),
                ('class_solo_male', models.BooleanField(default=True)),
                ('class_solo_female', models.BooleanField(default=True)),
                ('self_rogaining', models.BooleanField(default=False)),
            ],
        ),
        migrations.CreateModel(
            name='ShapeFileLocations',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('shapefile', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Shapelayer')),
                ('locid', models.IntegerField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='ShapeLayers',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, verbose_name='Shape Layer')),
                ('file', models.FileField(blank=True, upload_to=rog.models.get_file_path)),
                ('uploaded_date', models.DateField(auto_now_add=True)),
                ('layerof', models.IntegerField(choices=[(1, 'templocation'), (2, 'Location_line'), (3, 'Location_polygon')], default=1)),
                ('table_name', models.CharField(blank=True, max_length=255, verbose_name='Table name')),
            ],
        ),
        migrations.CreateModel(
            name='TempUser',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('email', models.EmailField(max_length=254, unique=True)),
                ('password', models.CharField(max_length=128)),
                ('is_rogaining', models.BooleanField(default=False)),
                ('zekken_number', models.CharField(blank=True, max_length=255, null=True)),
                ('event_code', models.CharField(blank=True, max_length=255, null=True)),
                ('team_name', models.CharField(blank=True, max_length=255, null=True)),
                ('group', models.CharField(max_length=255)),
                ('firstname', models.CharField(blank=True, max_length=255, null=True)),
                ('lastname', models.CharField(blank=True, max_length=255, null=True)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('female', models.BooleanField(default=False)),
                ('verification_code', models.UUIDField(default=uuid.uuid4, editable=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('expires_at', models.DateTimeField()),
            ],
        ),
        migrations.CreateModel(
            name='TestModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('testbane', models.CharField(max_length=355, verbose_name='test field')),
                ('wanttogo', models.BooleanField(default=False)),
                ('like', models.BooleanField(default=False)),
                ('checkin', models.BooleanField(default=False)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
            ],
        ),
        migrations.CreateModel(
            name='TravelList',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('travel_id', models.IntegerField(verbose_name='Travel Id')),
                ('start_date', models.DateTimeField(blank=True, null=True, verbose_name='Start date')),
                ('finish_date', models.DateTimeField(blank=True, null=True, verbose_name='End date')),
                ('category', models.CharField(choices=[('PRIVATE', 'Private'), ('GROUP', 'Group'), ('AGENT', 'Agent'), ('ROGAINING', 'Rogaining')], max_length=256)),
                ('title', models.CharField(max_length=255, verbose_name='Title')),
                ('transportation', models.CharField(blank=True, max_length=255, null=True, verbose_name='Transpotation')),
                ('moving_distance', models.IntegerField(blank=True, null=True)),
                ('duration', models.DurationField(blank=True, null=True, verbose_name='Duration')),
                ('eta', models.DateTimeField(blank=True, null=True)),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('last_updated_user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='travel_list_updated_user', to=settings.AUTH_USER_MODEL)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='UserUpload',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=255, verbose_name='User uploads')),
                ('file', models.FileField(blank=True, upload_to=rog.models.get_file_path)),
                ('uploaded_date', models.DateField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='UserUploadUser',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('userfile', models.CharField(blank=True, max_length=2048, null=True, verbose_name='User file')),
                ('email', models.CharField(max_length=255, verbose_name='User Email')),
            ],
        ),
        migrations.CreateModel(
            name='Waypoint',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('latitude', models.FloatField()),
                ('longitude', models.FloatField()),
                ('altitude', models.FloatField(blank=True, null=True)),
                ('accuracy', models.FloatField(blank=True, null=True)),
                ('speed', models.FloatField(blank=True, null=True)),
                ('recorded_at', models.DateTimeField()),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('entry', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='waypoints', to='rog.entry')),
            ],
            options={
                'ordering': ['recorded_at'],
            },
        ),
        migrations.CreateModel(
            name='UserTracks',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Useractions',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('wanttogo', models.BooleanField(default=False)),
                ('like', models.BooleanField(default=False)),
                ('checkin', models.BooleanField(default=False)),
                ('checkinimage', models.FileField(blank=True, null=True, upload_to='%y%m%d')),
                ('order', models.IntegerField(default=0)),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='action_location', to='rog.location')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='action_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='TravelPoint',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('distance', models.FloatField(blank=True, null=True)),
                ('transportation', models.CharField(blank=True, max_length=255, null=True, verbose_name='Transpotation')),
                ('eta', models.DateTimeField(blank=True, null=True)),
                ('order_number', models.IntegerField(blank=True, null=True)),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('last_updated_user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='travelpoint_updated_user', to=settings.AUTH_USER_MODEL)),
                ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.location')),
                ('travel_list', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to='rog.travellist')),
            ],
        ),
        migrations.CreateModel(
            name='templocation',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('location_id', models.IntegerField(blank=True, null=True, verbose_name='Location id')),
                ('sub_loc_id', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Sub location id')),
                ('cp', models.FloatField(default=0, null=True, verbose_name='Check Point')),
                ('location_name', models.CharField(default='--- 場所をお願いします --', max_length=2048, verbose_name='Location Name')),
                ('category', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Category')),
                ('subcategory', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Sub Category')),
                ('zip', models.CharField(blank=True, max_length=12, null=True, verbose_name='Zip code')),
                ('address', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Address')),
                ('prefecture', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Prefecture')),
                ('area', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Area')),
                ('city', models.CharField(blank=True, max_length=2048, null=True, verbose_name='City')),
                ('latitude', models.FloatField(blank=True, null=True, verbose_name='Latitude')),
                ('longitude', models.FloatField(blank=True, null=True, verbose_name='Latitude')),
                ('photos', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Photos')),
                ('videos', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Videos')),
                ('webcontents', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Web Content')),
                ('status', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Status')),
                ('portal', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Portal')),
                ('group', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Group')),
                ('phone', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Phone')),
                ('fax', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Fax')),
                ('email', models.EmailField(blank=True, max_length=2048, null=True, verbose_name='Email')),
                ('facility', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Facility')),
                ('remark', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Remarks')),
                ('tags', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Tags')),
                ('event_name', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Event name')),
                ('event_active', models.BooleanField(default=True, verbose_name='Is Event active')),
                ('hidden_location', models.BooleanField(default=False, verbose_name='Is Hidden Location')),
                ('auto_checkin', models.BooleanField(default=False, verbose_name='Is AutoCheckin')),
                ('checkin_radius', models.FloatField(blank=True, default=15.0, null=True, verbose_name='Checkin radious')),
                ('checkin_point', models.FloatField(blank=True, default=10, null=True, verbose_name='Checkin Point')),
                ('buy_point', models.FloatField(blank=True, default=0, null=True, verbose_name='buy Point')),
                ('evaluation_value', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Evaluation value (評価)')),
                ('shop_closed', models.BooleanField(default=False, verbose_name='Shop Closed (休業)')),
                ('shop_shutdown', models.BooleanField(default=False, verbose_name='Shop Shutdown (閉業)')),
                ('opening_hours_mon', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours monday (月曜)')),
                ('opening_hours_tue', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours tuesday (火曜)')),
                ('opening_hours_wed', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours wednesday (水曜)')),
                ('opening_hours_thu', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours thursday (木曜)')),
                ('opening_hours_fri', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours frinday (金曜)')),
                ('opening_hours_sat', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours saturday (土曜)')),
                ('opening_hours_sun', models.CharField(blank=True, max_length=512, null=True, verbose_name='Opening hours sunday (日曜)')),
                ('parammeters', models.CharField(blank=True, max_length=2048, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('geom', django.contrib.gis.db.models.fields.MultiPointField(srid=4326)),
                ('last_updated_user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='temp_location_updated_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='TeamStart',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('start_time', models.DateTimeField(auto_now_add=True)),
                ('entry', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='start_info', to='rog.entry')),
            ],
        ),
        migrations.CreateModel(
            name='TeamGoal',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('goal_time', models.DateTimeField()),
                ('image_url', models.URLField(blank=True, null=True)),
                ('score', models.IntegerField(default=0)),
                ('scoreboard_url', models.URLField(blank=True, null=True)),
                ('entry', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='goal_info', to='rog.entry')),
            ],
        ),
        migrations.CreateModel(
            name='Team',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('team_name', models.CharField(max_length=255)),
                ('category', models.ForeignKey(default=rog.models.get_default_category, on_delete=django.db.models.deletion.SET_DEFAULT, to='rog.newcategory')),
                ('owner', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='owned_teams', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='SystemSettings',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('setting_name', models.CharField(max_length=255, verbose_name='Settings Name')),
                ('version', models.CharField(blank=True, max_length=10, null=True, verbose_name='Version')),
                ('effective_date', models.DateTimeField()),
                ('end_date', models.DateTimeField()),
                ('parammeters', models.CharField(max_length=512, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('last_updated_user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='system_setting_updated_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='RogUser',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('phone', models.CharField(max_length=55, verbose_name='Phone Number')),
                ('first_name', models.CharField(max_length=255, verbose_name='First Name')),
                ('middle_name', models.CharField(blank=True, max_length=255, null=True, verbose_name='Middle Name')),
                ('last_name', models.CharField(max_length=255, verbose_name='last_name')),
                ('nickname', models.CharField(blank=True, max_length=255, null=True, verbose_name='Nickname')),
                ('country', models.CharField(default='Japan', max_length=255, verbose_name='Country')),
                ('language', models.CharField(default='Japanese', max_length=255, verbose_name='Language')),
                ('prefecture', models.CharField(blank=True, max_length=255, null=True, verbose_name='Prefecture')),
                ('sex', models.CharField(blank=True, default='unknown', max_length=255, null=True, verbose_name='Sex')),
                ('birthyear', models.IntegerField(blank=True, null=True, verbose_name='Birth year')),
                ('family_structure', models.IntegerField(blank=True, null=True, verbose_name='Family Structure')),
                ('level', models.IntegerField(blank=True, default=0, null=True, verbose_name='Level')),
                ('paid', models.BooleanField(default=False, verbose_name='Is Paid')),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('introducer', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='introduced_uesr', to=settings.AUTH_USER_MODEL)),
                ('last_updated_user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='roguser_updated_user', to=settings.AUTH_USER_MODEL)),
                ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Member',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('firstname', models.CharField(blank=True, max_length=255, null=True)),
                ('lastname', models.CharField(blank=True, max_length=255, null=True)),
                ('date_of_birth', models.DateField(blank=True, null=True)),
                ('female', models.BooleanField(default=False)),
                ('is_temporary', models.BooleanField(default=False)),
                ('team', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='members', to='rog.team')),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Location_polygon',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('location_id', models.IntegerField(blank=True, null=True, verbose_name='Location id')),
                ('location_name', models.CharField(max_length=255, verbose_name='Location Name')),
                ('category', models.CharField(blank=True, max_length=255, null=True, verbose_name='Category')),
                ('zip', models.CharField(blank=True, max_length=12, null=True, verbose_name='Zip code')),
                ('address', models.CharField(blank=True, max_length=512, null=True, verbose_name='Address')),
                ('prefecture', models.CharField(blank=True, max_length=255, null=True, verbose_name='Prefecture')),
                ('area', models.CharField(blank=True, max_length=255, null=True, verbose_name='Area')),
                ('city', models.CharField(blank=True, max_length=255, null=True, verbose_name='City')),
                ('photos', models.CharField(blank=True, max_length=255, null=True, verbose_name='Phptos')),
                ('videos', models.CharField(blank=True, max_length=255, null=True, verbose_name='Videos')),
                ('webcontents', models.CharField(blank=True, max_length=255, null=True, verbose_name='Web Content')),
                ('status', models.CharField(blank=True, max_length=255, null=True, verbose_name='Status')),
                ('portal', models.CharField(blank=True, max_length=255, null=True, verbose_name='Portal')),
                ('group', models.CharField(blank=True, max_length=255, null=True, verbose_name='Group')),
                ('phone', models.CharField(blank=True, max_length=255, null=True, verbose_name='Phone')),
                ('fax', models.CharField(blank=True, max_length=255, null=True, verbose_name='Fax')),
                ('email', models.EmailField(blank=True, max_length=255, null=True, verbose_name='Email')),
                ('facility', models.CharField(blank=True, max_length=255, null=True, verbose_name='Facility')),
                ('remark', models.CharField(blank=True, max_length=255, null=True, verbose_name='Remarks')),
                ('tags', models.CharField(blank=True, max_length=512, null=True, verbose_name='Tags')),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('geom', django.contrib.gis.db.models.fields.MultiPolygonField(blank=True, null=True, srid=4326)),
                ('last_updated_user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='location_polygon_updated_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='Location_line',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('location_id', models.IntegerField(blank=True, null=True, verbose_name='Location id')),
                ('location_name', models.CharField(max_length=255, verbose_name='Location Name')),
                ('category', models.CharField(blank=True, max_length=255, null=True, verbose_name='Category')),
                ('zip', models.CharField(blank=True, max_length=12, null=True, verbose_name='Zip code')),
                ('address', models.CharField(blank=True, max_length=512, null=True, verbose_name='Address')),
                ('prefecture', models.CharField(blank=True, max_length=255, null=True, verbose_name='Prefecture')),
                ('area', models.CharField(blank=True, max_length=255, null=True, verbose_name='Area')),
                ('city', models.CharField(blank=True, max_length=255, null=True, verbose_name='City')),
                ('photos', models.CharField(blank=True, max_length=255, null=True, verbose_name='Phptos')),
                ('videos', models.CharField(blank=True, max_length=255, null=True, verbose_name='Videos')),
                ('webcontents', models.CharField(blank=True, max_length=255, null=True, verbose_name='Web Content')),
                ('status', models.CharField(blank=True, max_length=255, null=True, verbose_name='Status')),
                ('portal', models.CharField(blank=True, max_length=255, null=True, verbose_name='Portal')),
                ('group', models.CharField(blank=True, max_length=255, null=True, verbose_name='Group')),
                ('phone', models.CharField(blank=True, max_length=255, null=True, verbose_name='Phone')),
                ('fax', models.CharField(blank=True, max_length=255, null=True, verbose_name='Fax')),
                ('email', models.EmailField(blank=True, max_length=255, null=True, verbose_name='Email')),
                ('facility', models.CharField(blank=True, max_length=255, null=True, verbose_name='Facility')),
                ('remark', models.CharField(blank=True, max_length=255, null=True, verbose_name='Remarks')),
                ('tags', models.CharField(blank=True, max_length=512, null=True, verbose_name='Tags')),
                ('parammeters', models.CharField(blank=True, max_length=512, null=True, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('geom', django.contrib.gis.db.models.fields.MultiLineStringField(blank=True, null=True, srid=4326)),
                ('last_updated_user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='location_line_updated_user', to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.CreateModel(
            name='JoinedEvent',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tagname', models.CharField(blank=True, max_length=255, null=True, verbose_name='Tag Name')),
                ('status', models.CharField(choices=[('REGISTERED', 'Registered'), ('ACCEPTED', 'accepted'), ('PAID', 'paid'), ('JOINED', 'joined'), ('CANCELED', 'Canceled')], max_length=256)),
                ('registrationid', models.CharField(max_length=56, verbose_name='Registration Id')),
                ('payment_code', models.CharField(max_length=255, verbose_name='Payment Code')),
                ('paid', models.IntegerField(default=0, verbose_name='Paid Amount')),
                ('remark', models.CharField(blank=True, max_length=255, null=True, verbose_name='Remark')),
                ('parammeters', models.CharField(max_length=512, verbose_name='Parameters')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('last_updated_at', models.DateTimeField(auto_now=True)),
                ('last_updated_user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='joined_event_updated_user', to=settings.AUTH_USER_MODEL)),
                ('user', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)),
            ],
        ),
        migrations.AddIndex(
            model_name='gpscheckin',
            index=models.Index(fields=['zekken_number', 'event_code', 'path_order'], name='idx_zekken_event'),
        ),
        migrations.AddIndex(
            model_name='gpscheckin',
            index=models.Index(fields=['create_at'], name='idx_create_at'),
        ),
        migrations.AddField(
            model_name='goalimages',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='favorite',
            name='last_updated_user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='favorite_updated_user', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='favorite',
            name='location',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.location'),
        ),
        migrations.AddField(
            model_name='favorite',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='eventuser',
            name='event',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='event', to='rog.event'),
        ),
        migrations.AddField(
            model_name='eventuser',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='event',
            name='last_updated_user',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='event_updated_user', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='event',
            name='user',
            field=models.ManyToManyField(related_name='even', through='rog.EventUser', to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='entrymember',
            name='entry',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.entry'),
        ),
        migrations.AddField(
            model_name='entrymember',
            name='member',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.member'),
        ),
        migrations.AddField(
            model_name='entry',
            name='category',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.newcategory'),
        ),
        migrations.AddField(
            model_name='entry',
            name='event',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.newevent2'),
        ),
        migrations.AddField(
            model_name='entry',
            name='owner',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AddField(
            model_name='entry',
            name='team',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rog.team'),
        ),
        migrations.AddField(
            model_name='checkpoint',
            name='entry',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='checkpoints', to='rog.entry'),
        ),
        migrations.AddField(
            model_name='checkinimages',
            name='user',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL),
        ),
        migrations.AlterUniqueTogether(
            name='category',
            unique_together={('category_name', 'category_number')},
        ),
        migrations.AddField(
            model_name='customuser',
            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='customuser',
            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.AddIndex(
            model_name='waypoint',
            index=models.Index(fields=['entry', 'recorded_at'], name='rog_waypoin_entry_i_fb2cb5_idx'),
        ),
        migrations.AlterUniqueTogether(
            name='member',
            unique_together={('team', 'user')},
        ),
        migrations.AddIndex(
            model_name='location',
            index=django.contrib.postgres.indexes.GistIndex(fields=['geom'], name='rog_locatio_geom_4793cc_gist'),
        ),
        migrations.AlterUniqueTogether(
            name='entrymember',
            unique_together={('entry', 'member')},
        ),
        migrations.AlterUniqueTogether(
            name='entry',
            unique_together={('zekken_number', 'event', 'date')},
        ),
        migrations.AlterUniqueTogether(
            name='checkpoint',
            unique_together={('entry', 'cp_number')},
        ),
    ]
