X-Git-Url: https://code.kerkeslager.com/?p=climbing.kerkeslager.com;a=blobdiff_plain;f=src%2Fclimbing%2Fmigrations%2F0001_initial.py;fp=src%2Fclimbing%2Fmigrations%2F0001_initial.py;h=38bf813f84fffe2b235081bcc516d3da779eb0dc;hp=0000000000000000000000000000000000000000;hb=1bc6954655e77c96abc15240b495331dfb0dd1a8;hpb=a61e6c6f81f4b3b226cdc232272f2cea3a129c2a diff --git a/src/climbing/migrations/0001_initial.py b/src/climbing/migrations/0001_initial.py new file mode 100644 index 0000000..38bf813 --- /dev/null +++ b/src/climbing/migrations/0001_initial.py @@ -0,0 +1,81 @@ +# Generated by Django 4.0.3 on 2022-03-03 04:01 + +from django.db import migrations, models +import django.db.models.deletion + + +class Migration(migrations.Migration): + + initial = True + + dependencies = [ + ] + + operations = [ + migrations.CreateModel( + name='Area', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('notes', models.TextField()), + ], + ), + migrations.CreateModel( + name='Crag', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('notes', models.TextField()), + ('area', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.area')), + ], + ), + migrations.CreateModel( + name='Route', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('notes', models.TextField()), + ('area', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.crag')), + ], + ), + migrations.CreateModel( + name='Pitch', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64, null=True)), + ('difficulty', models.CharField(choices=[('5.0', '5.0'), ('5.1', '5.1'), ('5.2', '5.2'), ('5.3', '5.3'), ('5.4', '5.4'), ('5.5', '5.5'), ('5.6', '5.6'), ('5.6+', '5.6+'), ('5.7', '5.7'), ('5.7+', '5.7+'), ('5.8', '5.8'), ('5.8+', '5.8+'), ('5.9-', '5.9-'), ('5.9', '5.9'), ('5.9+', '5.9+'), ('5.10a', '5.10a'), ('5.10b', '5.10b'), ('5.10c', '5.10c'), ('5.10d', '5.10d'), ('5.11a', '5.11a'), ('5.11b', '5.11b'), ('5.11c', '5.11c'), ('5.11d', '5.11d'), ('5.12a', '5.12a'), ('5.12b', '5.12b'), ('5.12c', '5.12c'), ('5.12d', '5.12d'), ('5.13a', '5.13a'), ('5.13b', '5.13b'), ('5.13c', '5.13c'), ('5.13d', '5.13d'), ('5.14a', '5.14a'), ('5.14b', '5.14b'), ('5.14c', '5.14c'), ('5.14d', '5.14d'), ('5.15a', '5.15a'), ('5.15b', '5.15b'), ('5.15c', '5.15c'), ('5.15d', '5.15d')], max_length=5)), + ('safety', models.CharField(choices=[('G', 'G'), ('PG', 'PG'), ('PG13', 'PG13'), ('R', 'R'), ('X', 'X')], max_length=4)), + ('notes', models.TextField()), + ('route', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.route')), + ], + ), + migrations.CreateModel( + name='Cluster', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('notes', models.TextField()), + ('area', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.area')), + ], + ), + migrations.CreateModel( + name='Boulder', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('notes', models.TextField()), + ('cluster', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.cluster')), + ], + ), + migrations.CreateModel( + name='Problem', + fields=[ + ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('name', models.CharField(max_length=64)), + ('difficulty', models.CharField(choices=[('V0', 'V0'), ('V1', 'V1'), ('V2', 'V2'), ('V3', 'V3'), ('V4', 'V4'), ('V5', 'V5'), ('V6', 'V6'), ('V7', 'V7'), ('V8', 'V8'), ('V9', 'V9'), ('V10', 'V10'), ('V11', 'V11'), ('V12', 'V12'), ('V13', 'V13'), ('V14', 'V14'), ('V15', 'V15'), ('V16', 'V16'), ('V17', 'V17')], max_length=3)), + ('safety', models.CharField(choices=[('G', 'G'), ('PG', 'PG'), ('PG13', 'PG13'), ('R', 'R'), ('X', 'X')], max_length=4)), + ('notes', models.TextField()), + ('boulder', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='climbing.boulder')), + ], + ), + ]