summaryrefslogtreecommitdiffstats
path: root/core/migrations/0001_initial.py
blob: b9e0a3431f0dbabfcd574e36f40555ca13bd3443 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
# -*- coding: utf-8 -*-
# Generated by Django 1.10.8 on 2020-02-18 16:01
from __future__ import unicode_literals

from django.conf import settings
import django.core.files.storage
from django.db import migrations, models
import django.db.models.deletion
import troggle.core.models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        migrations.swappable_dependency(settings.AUTH_USER_MODEL),
    ]

    operations = [
        migrations.CreateModel(
            name='Area',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('short_name', models.CharField(max_length=100)),
                ('name', models.CharField(blank=True, max_length=200, null=True)),
                ('description', models.TextField(blank=True, null=True)),
                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Area')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Cave',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('official_name', models.CharField(max_length=160)),
                ('kataster_code', models.CharField(blank=True, max_length=20, null=True)),
                ('kataster_number', models.CharField(blank=True, max_length=10, null=True)),
                ('unofficial_number', models.CharField(blank=True, max_length=60, null=True)),
                ('explorers', models.TextField(blank=True, null=True)),
                ('underground_description', models.TextField(blank=True, null=True)),
                ('equipment', models.TextField(blank=True, null=True)),
                ('references', models.TextField(blank=True, null=True)),
                ('survey', models.TextField(blank=True, null=True)),
                ('kataster_status', models.TextField(blank=True, null=True)),
                ('underground_centre_line', models.TextField(blank=True, null=True)),
                ('notes', models.TextField(blank=True, null=True)),
                ('length', models.CharField(blank=True, max_length=100, null=True)),
                ('depth', models.CharField(blank=True, max_length=100, null=True)),
                ('extent', models.CharField(blank=True, max_length=100, null=True)),
                ('survex_file', models.CharField(blank=True, max_length=100, null=True)),
                ('description_file', models.CharField(blank=True, max_length=200, null=True)),
                ('url', models.CharField(blank=True, max_length=200, null=True)),
                ('filename', models.CharField(max_length=200)),
                ('area', models.ManyToManyField(blank=True, to='core.Area')),
            ],
            options={
                'ordering': ('kataster_code', 'unofficial_number'),
            },
        ),
        migrations.CreateModel(
            name='CaveAndEntrance',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('entrance_letter', models.CharField(blank=True, max_length=20, null=True)),
                ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
        ),
        migrations.CreateModel(
            name='CaveDescription',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('short_name', models.CharField(max_length=50, unique=True)),
                ('long_name', models.CharField(blank=True, max_length=200, null=True)),
                ('description', models.TextField(blank=True, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='CaveSlug',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('slug', models.SlugField(unique=True)),
                ('primary', models.BooleanField(default=False)),
                ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
        ),
        migrations.CreateModel(
            name='DataIssue',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('date', models.DateTimeField(auto_now_add=True)),
                ('parser', models.CharField(blank=True, max_length=50, null=True)),
                ('message', models.CharField(blank=True, max_length=400, null=True)),
            ],
            options={
                'ordering': ['date'],
            },
        ),
        migrations.CreateModel(
            name='DPhoto',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('caption', models.CharField(blank=True, max_length=1000, null=True)),
                ('file', models.ImageField(storage=django.core.files.storage.FileSystemStorage(base_url=b'http://127.0.0.1:8000/photos/', location=b'/expo/expoweb/photos'), upload_to=b'.')),
                ('is_mugshot', models.BooleanField(default=False)),
                ('lon_utm', models.FloatField(blank=True, null=True)),
                ('lat_utm', models.FloatField(blank=True, null=True)),
                ('contains_cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Entrance',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('name', models.CharField(blank=True, max_length=100, null=True)),
                ('entrance_description', models.TextField(blank=True, null=True)),
                ('explorers', models.TextField(blank=True, null=True)),
                ('map_description', models.TextField(blank=True, null=True)),
                ('location_description', models.TextField(blank=True, null=True)),
                ('approach', models.TextField(blank=True, null=True)),
                ('underground_description', models.TextField(blank=True, null=True)),
                ('photo', models.TextField(blank=True, null=True)),
                ('marking', models.CharField(choices=[(b'P', b'Paint'), (b'P?', b'Paint (?)'), (b'T', b'Tag'), (b'T?', b'Tag (?)'), (b'R', b'Needs Retag'), (b'S', b'Spit'), (b'S?', b'Spit (?)'), (b'U', b'Unmarked'), (b'?', b'Unknown')], max_length=2)),
                ('marking_comment', models.TextField(blank=True, null=True)),
                ('findability', models.CharField(blank=True, choices=[(b'?', b'To be confirmed ...'), (b'S', b'Coordinates'), (b'L', b'Lost'), (b'R', b'Refindable')], max_length=1, null=True)),
                ('findability_description', models.TextField(blank=True, null=True)),
                ('alt', models.TextField(blank=True, null=True)),
                ('northing', models.TextField(blank=True, null=True)),
                ('easting', models.TextField(blank=True, null=True)),
                ('tag_station', models.TextField(blank=True, null=True)),
                ('exact_station', models.TextField(blank=True, null=True)),
                ('other_station', models.TextField(blank=True, null=True)),
                ('other_description', models.TextField(blank=True, null=True)),
                ('bearings', models.TextField(blank=True, null=True)),
                ('url', models.CharField(blank=True, max_length=200, null=True)),
                ('filename', models.CharField(max_length=200)),
                ('cached_primary_slug', models.CharField(blank=True, max_length=200, null=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EntranceSlug',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('slug', models.SlugField(unique=True)),
                ('primary', models.BooleanField(default=False)),
                ('entrance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Entrance')),
            ],
        ),
        migrations.CreateModel(
            name='Expedition',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('year', models.CharField(max_length=20, unique=True)),
                ('name', models.CharField(max_length=100)),
            ],
            options={
                'ordering': ('-year',),
                'get_latest_by': 'year',
            },
        ),
        migrations.CreateModel(
            name='ExpeditionDay',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('date', models.DateField()),
                ('expedition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')),
            ],
            options={
                'ordering': ('date',),
            },
        ),
        migrations.CreateModel(
            name='LogbookEntry',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('date', models.DateTimeField()),
                ('title', models.CharField(max_length=200)),
                ('cave_slug', models.SlugField()),
                ('place', models.CharField(blank=True, help_text=b"Only use this if you haven't chosen a cave", max_length=100, null=True)),
                ('text', models.TextField()),
                ('slug', models.SlugField()),
                ('filename', models.CharField(max_length=200, null=True)),
                ('entry_type', models.CharField(choices=[(b'wiki', b'Wiki style logbook'), (b'html', b'Html style logbook')], default=b'wiki', max_length=50, null=True)),
                ('expedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')),
                ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.ExpeditionDay')),
            ],
            options={
                'ordering': ('-date',),
                'verbose_name_plural': 'Logbook Entries',
            },
        ),
        migrations.CreateModel(
            name='NewSubCave',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('name', models.CharField(max_length=200, unique=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='OtherCaveName',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('name', models.CharField(max_length=160)),
                ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Person',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('first_name', models.CharField(max_length=100)),
                ('last_name', models.CharField(max_length=100)),
                ('fullname', models.CharField(max_length=200)),
                ('is_vfho', models.BooleanField(default=False, help_text=b'VFHO is the Vereines für Höhlenkunde in Obersteier, a nearby Austrian caving club.')),
                ('mug_shot', models.CharField(blank=True, max_length=100, null=True)),
                ('blurb', models.TextField(blank=True, null=True)),
                ('orderref', models.CharField(max_length=200)),
                ('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
            ],
            options={
                'ordering': ('orderref',),
                'verbose_name_plural': 'People',
            },
        ),
        migrations.CreateModel(
            name='PersonExpedition',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('slugfield', models.SlugField(blank=True, null=True)),
                ('is_guest', models.BooleanField(default=False)),
                ('expo_committee_position', models.CharField(blank=True, choices=[(b'leader', b'Expo leader'), (b'medical', b'Expo medical officer'), (b'treasurer', b'Expo treasurer'), (b'sponsorship', b'Expo sponsorship coordinator'), (b'research', b'Expo research coordinator')], max_length=200, null=True)),
                ('nickname', models.CharField(blank=True, max_length=100, null=True)),
                ('expedition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')),
                ('person', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Person')),
            ],
            options={
                'ordering': ('-expedition',),
            },
        ),
        migrations.CreateModel(
            name='PersonTrip',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('time_underground', models.FloatField(help_text=b'In decimal hours')),
                ('is_logbook_entry_author', models.BooleanField(default=False)),
                ('logbook_entry', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.LogbookEntry')),
                ('personexpedition', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.PersonExpedition')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='QM',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('number', models.IntegerField(help_text=b'this is the sequential number in the year')),
                ('grade', models.CharField(choices=[(b'A', b'A: Large obvious lead'), (b'B', b'B: Average lead'), (b'C', b'C: Tight unpromising lead'), (b'D', b'D: Dig'), (b'X', b'X: Unclimbable aven')], max_length=1)),
                ('location_description', models.TextField(blank=True)),
                ('nearest_station_description', models.CharField(blank=True, max_length=400, null=True)),
                ('nearest_station_name', models.CharField(blank=True, max_length=200, null=True)),
                ('area', models.CharField(blank=True, max_length=100, null=True)),
                ('completion_description', models.TextField(blank=True, null=True)),
                ('comment', models.TextField(blank=True, null=True)),
                ('found_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='QMs_found', to='core.LogbookEntry')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ScannedImage',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('file', models.ImageField(storage=django.core.files.storage.FileSystemStorage(base_url=b'/survey_scans/', location=b'/expo/expofiles/'), upload_to=troggle.core.models.get_scan_path)),
                ('scanned_on', models.DateField(null=True)),
                ('contents', models.CharField(choices=[(b'notes', b'notes'), (b'plan', b'plan_sketch'), (b'elevation', b'elevation_sketch')], max_length=20)),
                ('number_in_wallet', models.IntegerField(null=True)),
                ('lon_utm', models.FloatField(blank=True, null=True)),
                ('lat_utm', models.FloatField(blank=True, null=True)),
                ('scanned_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Person')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='SurvexBlock',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('text', models.TextField()),
                ('date', models.DateTimeField(blank=True, null=True)),
                ('begin_char', models.IntegerField()),
                ('survexpath', models.CharField(max_length=200)),
                ('totalleglength', models.FloatField()),
                ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
                ('expedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')),
                ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.ExpeditionDay')),
                ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
            ],
            options={
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='SurvexDirectory',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('path', models.CharField(max_length=200)),
                ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
            options={
                'ordering': ('path',),
            },
        ),
        migrations.CreateModel(
            name='SurvexEquate',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
            ],
        ),
        migrations.CreateModel(
            name='SurvexFile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('path', models.CharField(max_length=200)),
                ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
                ('survexdirectory', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexDirectory')),
            ],
            options={
                'ordering': ('id',),
            },
        ),
        migrations.CreateModel(
            name='SurvexLeg',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tape', models.FloatField()),
                ('compass', models.FloatField()),
                ('clino', models.FloatField()),
                ('block', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
            ],
        ),
        migrations.CreateModel(
            name='SurvexPersonRole',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('nrole', models.CharField(blank=True, choices=[(b'insts', b'Instruments'), (b'dog', b'Other'), (b'notes', b'Notes'), (b'pics', b'Pictures'), (b'tape', b'Tape measure'), (b'useless', b'Useless'), (b'helper', b'Helper'), (b'disto', b'Disto'), (b'consultant', b'Consultant')], max_length=200, null=True)),
                ('personname', models.CharField(max_length=100)),
                ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.ExpeditionDay')),
                ('person', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Person')),
                ('personexpedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.PersonExpedition')),
                ('persontrip', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.PersonTrip')),
                ('survexblock', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
            ],
        ),
        migrations.CreateModel(
            name='SurvexScansFolder',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('fpath', models.CharField(max_length=200)),
                ('walletname', models.CharField(max_length=200)),
            ],
            options={
                'ordering': ('walletname',),
            },
        ),
        migrations.CreateModel(
            name='SurvexScanSingle',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('ffile', models.CharField(max_length=200)),
                ('name', models.CharField(max_length=200)),
                ('survexscansfolder', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexScansFolder')),
            ],
            options={
                'ordering': ('name',),
            },
        ),
        migrations.CreateModel(
            name='SurvexStation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=100)),
                ('x', models.FloatField(blank=True, null=True)),
                ('y', models.FloatField(blank=True, null=True)),
                ('z', models.FloatField(blank=True, null=True)),
                ('block', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
                ('equate', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexEquate')),
            ],
        ),
        migrations.CreateModel(
            name='SurvexTitle',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('title', models.CharField(max_length=200)),
                ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Cave')),
                ('survexblock', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
            ],
        ),
        migrations.CreateModel(
            name='Survey',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('new_since_parsing', models.BooleanField(default=False, editable=False)),
                ('non_public', models.BooleanField(default=False)),
                ('wallet_number', models.IntegerField(blank=True, null=True)),
                ('wallet_letter', models.CharField(blank=True, max_length=1, null=True)),
                ('comments', models.TextField(blank=True, null=True)),
                ('location', models.CharField(blank=True, max_length=400, null=True)),
                ('centreline_printed_on', models.DateField(blank=True, null=True)),
                ('tunnel_file', models.FileField(blank=True, null=True, upload_to=b'surveyXMLfiles')),
                ('integrated_into_main_sketch_on', models.DateField(blank=True, null=True)),
                ('rendered_image', models.ImageField(blank=True, null=True, upload_to=b'renderedSurveys')),
                ('centreline_printed_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='centreline_printed_by', to='core.Person')),
                ('expedition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')),
                ('integrated_into_main_sketch_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='integrated_into_main_sketch_by', to='core.Person')),
                ('logbook_entry', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.LogbookEntry')),
                ('subcave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.NewSubCave')),
                ('survex_block', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')),
                ('tunnel_main_sketch', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.Survey')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='TunnelFile',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('tunnelpath', models.CharField(max_length=200)),
                ('tunnelname', models.CharField(max_length=200)),
                ('bfontcolours', models.BooleanField(default=False)),
                ('filesize', models.IntegerField(default=0)),
                ('npaths', models.IntegerField(default=0)),
                ('survexblocks', models.ManyToManyField(to='core.SurvexBlock')),
                ('survexscans', models.ManyToManyField(to='core.SurvexScanSingle')),
                ('survexscansfolders', models.ManyToManyField(to='core.SurvexScansFolder')),
                ('survextitles', models.ManyToManyField(to='core.SurvexTitle')),
                ('tunnelcontains', models.ManyToManyField(to='core.TunnelFile')),
            ],
            options={
                'ordering': ('tunnelpath',),
            },
        ),
        migrations.AddField(
            model_name='survexleg',
            name='stationfrom',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='stationfrom', to='core.SurvexStation'),
        ),
        migrations.AddField(
            model_name='survexleg',
            name='stationto',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='stationto', to='core.SurvexStation'),
        ),
        migrations.AddField(
            model_name='survexdirectory',
            name='primarysurvexfile',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='primarysurvexfile', to='core.SurvexFile'),
        ),
        migrations.AddField(
            model_name='survexblock',
            name='survexfile',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexFile'),
        ),
        migrations.AddField(
            model_name='survexblock',
            name='survexscansfolder',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexScansFolder'),
        ),
        migrations.AddField(
            model_name='scannedimage',
            name='survey',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Survey'),
        ),
        migrations.AddField(
            model_name='qm',
            name='nearest_station',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.SurvexStation'),
        ),
        migrations.AddField(
            model_name='qm',
            name='ticked_off_by',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='QMs_ticked_off', to='core.LogbookEntry'),
        ),
        migrations.AddField(
            model_name='dphoto',
            name='contains_entrance',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='photo_file', to='core.Entrance'),
        ),
        migrations.AddField(
            model_name='dphoto',
            name='contains_logbookentry',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.LogbookEntry'),
        ),
        migrations.AddField(
            model_name='dphoto',
            name='contains_person',
            field=models.ManyToManyField(blank=True, to='core.Person'),
        ),
        migrations.AddField(
            model_name='dphoto',
            name='nearest_QM',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='core.QM'),
        ),
        migrations.AddField(
            model_name='cavedescription',
            name='linked_entrances',
            field=models.ManyToManyField(blank=True, to='core.Entrance'),
        ),
        migrations.AddField(
            model_name='cavedescription',
            name='linked_qms',
            field=models.ManyToManyField(blank=True, to='core.QM'),
        ),
        migrations.AddField(
            model_name='cavedescription',
            name='linked_subcaves',
            field=models.ManyToManyField(blank=True, to='core.NewSubCave'),
        ),
        migrations.AddField(
            model_name='caveandentrance',
            name='entrance',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Entrance'),
        ),
    ]