summaryrefslogtreecommitdiffstats
path: root/0001_initial.py
diff options
context:
space:
mode:
Diffstat (limited to '0001_initial.py')
-rw-r--r--0001_initial.py545
1 files changed, 0 insertions, 545 deletions
diff --git a/0001_initial.py b/0001_initial.py
deleted file mode 100644
index e5e0784..0000000
--- a/0001_initial.py
+++ /dev/null
@@ -1,545 +0,0 @@
-# -*- coding: utf-8 -*-
-from __future__ import unicode_literals
-
-from django.db import models, migrations
-from django.conf import settings
-
-# created by
-# $ python manage.py makemigrations core
-# in troggle/core/migrations/0001_initial.py
-
-# Useful shorthand for db structure
-
-class Migration(migrations.Migration):
-
- dependencies = [
- migrations.swappable_dependency(settings.AUTH_USER_MODEL),
- ]
-
- operations = [
- migrations.CreateModel(
- name='Area',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(max_length=200, blank=True, null=True)),
- ('description', models.TextField(blank=True, null=True)),
- ('parent', models.ForeignKey(blank=True, null=True, to='core.Area')),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='Cave',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(max_length=20, blank=True, null=True)),
- ('kataster_number', models.CharField(max_length=10, blank=True, null=True)),
- ('unofficial_number', models.CharField(max_length=60, blank=True, 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(max_length=100, blank=True, null=True)),
- ('depth', models.CharField(max_length=100, blank=True, null=True)),
- ('extent', models.CharField(max_length=100, blank=True, null=True)),
- ('survex_file', models.CharField(max_length=100, blank=True, null=True)),
- ('description_file', models.CharField(max_length=200, blank=True, null=True)),
- ('url', models.CharField(max_length=200, blank=True, null=True)),
- ('filename', models.CharField(max_length=200)),
- ('area', models.ManyToManyField(blank=True, null=True, to='core.Area')),
- ],
- options={
- 'ordering': ('kataster_code', 'unofficial_number'),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='CaveAndEntrance',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('entrance_letter', models.CharField(max_length=20, blank=True, null=True)),
- ('cave', models.ForeignKey(to='core.Cave')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='CaveDescription',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(max_length=200, blank=True, null=True)),
- ('description', models.TextField(blank=True, null=True)),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='CaveSlug',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('slug', models.SlugField(unique=True)),
- ('primary', models.BooleanField(default=False)),
- ('cave', models.ForeignKey(to='core.Cave')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='DataIssue',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(max_length=50, blank=True, null=True)),
- ('message', models.CharField(max_length=400, blank=True, null=True)),
- ],
- options={
- 'ordering': ['date'],
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='Entrance',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('name', models.CharField(max_length=100, blank=True, 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(max_length=2, choices=[('P', 'Paint'), ('P?', 'Paint (?)'), ('T', 'Tag'), ('T?', 'Tag (?)'), ('R', 'Needs Retag'), ('S', 'Spit'), ('S?', 'Spit (?)'), ('U', 'Unmarked'), ('?', 'Unknown')])),
- ('marking_comment', models.TextField(blank=True, null=True)),
- ('findability', models.CharField(max_length=1, blank=True, null=True, choices=[('?', 'To be confirmed ...'), ('S', 'Coordinates'), ('L', 'Lost'), ('R', 'Refindable')])),
- ('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(max_length=200, blank=True, null=True)),
- ('filename', models.CharField(max_length=200)),
- ('cached_primary_slug', models.CharField(max_length=200, blank=True, null=True)),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='EntranceSlug',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('slug', models.SlugField(unique=True)),
- ('primary', models.BooleanField(default=False)),
- ('entrance', models.ForeignKey(to='core.Entrance')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='Expedition',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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',
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='ExpeditionDay',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('date', models.DateField()),
- ('expedition', models.ForeignKey(to='core.Expedition')),
- ],
- options={
- 'ordering': ('date',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='LogbookEntry',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('date', models.DateField()),
- ('title', models.CharField(max_length=200)),
- ('cave_slug', models.SlugField()),
- ('place', models.CharField(max_length=100, blank=True, null=True, help_text="Only use this if you haven't chosen a cave")),
- ('text', models.TextField()),
- ('slug', models.SlugField()),
- ('filename', models.CharField(max_length=200, null=True)),
- ('entry_type', models.CharField(max_length=50, null=True, default='wiki', choices=[('wiki', 'Wiki style logbook'), ('html', 'Html style logbook')])),
- ('expedition', models.ForeignKey(blank=True, null=True, to='core.Expedition')),
- ('expeditionday', models.ForeignKey(null=True, to='core.ExpeditionDay')),
- ],
- options={
- 'verbose_name_plural': 'Logbook Entries',
- 'ordering': ('-date',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='NewSubCave',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='OtherCaveName',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('name', models.CharField(max_length=160)),
- ('cave', models.ForeignKey(to='core.Cave')),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='Person',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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='VFHO is the Vereines für Höhlenkunde in Obersteier, a nearby Austrian caving club.')),
- ('mug_shot', models.CharField(max_length=100, blank=True, null=True)),
- ('blurb', models.TextField(blank=True, null=True)),
- ('orderref', models.CharField(max_length=200)),
- ('user', models.OneToOneField(blank=True, null=True, to=settings.AUTH_USER_MODEL)),
- ],
- options={
- 'verbose_name_plural': 'People',
- 'ordering': ('orderref',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='PersonExpedition',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(max_length=200, blank=True, null=True, choices=[('leader', 'Expo leader'), ('medical', 'Expo medical officer'), ('treasurer', 'Expo treasurer'), ('sponsorship', 'Expo sponsorship coordinator'), ('research', 'Expo research coordinator')])),
- ('nickname', models.CharField(max_length=100, blank=True, null=True)),
- ('expedition', models.ForeignKey(to='core.Expedition')),
- ('person', models.ForeignKey(to='core.Person')),
- ],
- options={
- 'ordering': ('-expedition',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='PersonTrip',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('time_underground', models.FloatField(help_text='In decimal hours')),
- ('is_logbook_entry_author', models.BooleanField(default=False)),
- ('logbook_entry', models.ForeignKey(to='core.LogbookEntry')),
- ('personexpedition', models.ForeignKey(null=True, to='core.PersonExpedition')),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='QM',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('new_since_parsing', models.BooleanField(default=False, editable=False)),
- ('non_public', models.BooleanField(default=False)),
- ('number', models.IntegerField(help_text='this is the sequential number in the year')),
- ('grade', models.CharField(max_length=1, choices=[('A', 'A: Large obvious lead'), ('B', 'B: Average lead'), ('C', 'C: Tight unpromising lead'), ('D', 'D: Dig'), ('X', 'X: Unclimbable aven')])),
- ('location_description', models.TextField(blank=True)),
- ('nearest_station_description', models.CharField(max_length=400, blank=True, null=True)),
- ('nearest_station_name', models.CharField(max_length=200, blank=True, null=True)),
- ('area', models.CharField(max_length=100, blank=True, 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, related_name='QMs_found', to='core.LogbookEntry')),
- ],
- options={
- 'abstract': False,
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexBlock',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('name', models.CharField(max_length=100)),
- ('text', models.TextField()),
- ('date', models.DateField(blank=True, null=True)),
- ('begin_char', models.IntegerField()),
- ('survexpath', models.CharField(max_length=200)),
- ('totalleglength', models.FloatField()),
- ('cave', models.ForeignKey(blank=True, null=True, to='core.Cave')),
- ('expedition', models.ForeignKey(blank=True, null=True, to='core.Expedition')),
- ('expeditionday', models.ForeignKey(null=True, to='core.ExpeditionDay')),
- ('parent', models.ForeignKey(blank=True, null=True, to='core.SurvexBlock')),
- ],
- options={
- 'ordering': ('id',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexDirectory',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('path', models.CharField(max_length=200)),
- ('cave', models.ForeignKey(blank=True, null=True, to='core.Cave')),
- ],
- options={
- 'ordering': ('id',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexEquate',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('cave', models.ForeignKey(blank=True, null=True, to='core.Cave')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexFile',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('path', models.CharField(max_length=200)),
- ('cave', models.ForeignKey(blank=True, null=True, to='core.Cave')),
- ('survexdirectory', models.ForeignKey(blank=True, null=True, to='core.SurvexDirectory')),
- ],
- options={
- 'ordering': ('id',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexLeg',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('tape', models.FloatField()),
- ('compass', models.FloatField()),
- ('clino', models.FloatField()),
- ('block', models.ForeignKey(to='core.SurvexBlock')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexPersonRole',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('nrole', models.CharField(max_length=200, blank=True, null=True, choices=[('insts', 'Instruments'), ('dog', 'Other'), ('notes', 'Notes'), ('pics', 'Pictures'), ('tape', 'Tape measure'), ('useless', 'Useless'), ('helper', 'Helper'), ('disto', 'Disto'), ('consultant', 'Consultant')])),
- ('personname', models.CharField(max_length=100)),
- ('expeditionday', models.ForeignKey(null=True, to='core.ExpeditionDay')),
- ('person', models.ForeignKey(blank=True, null=True, to='core.Person')),
- ('personexpedition', models.ForeignKey(blank=True, null=True, to='core.PersonExpedition')),
- ('persontrip', models.ForeignKey(blank=True, null=True, to='core.PersonTrip')),
- ('survexblock', models.ForeignKey(to='core.SurvexBlock')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexScansFolder',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('fpath', models.CharField(max_length=200)),
- ('walletname', models.CharField(max_length=200)),
- ],
- options={
- 'ordering': ('walletname',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexScanSingle',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('ffile', models.CharField(max_length=200)),
- ('name', models.CharField(max_length=200)),
- ('survexscansfolder', models.ForeignKey(null=True, to='core.SurvexScansFolder')),
- ],
- options={
- 'ordering': ('name',),
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexStation',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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(to='core.SurvexBlock')),
- ('equate', models.ForeignKey(blank=True, null=True, to='core.SurvexEquate')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='SurvexTitle',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('title', models.CharField(max_length=200)),
- ('cave', models.ForeignKey(blank=True, null=True, to='core.Cave')),
- ('survexblock', models.ForeignKey(to='core.SurvexBlock')),
- ],
- options={
- },
- bases=(models.Model,),
- ),
- migrations.CreateModel(
- name='TunnelFile',
- fields=[
- ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
- ('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',),
- },
- bases=(models.Model,),
- ),
- migrations.AddField(
- model_name='survexleg',
- name='stationfrom',
- field=models.ForeignKey(related_name='stationfrom', to='core.SurvexStation'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='survexleg',
- name='stationto',
- field=models.ForeignKey(related_name='stationto', to='core.SurvexStation'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='survexdirectory',
- name='primarysurvexfile',
- field=models.ForeignKey(blank=True, null=True, related_name='primarysurvexfile', to='core.SurvexFile'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='survexblock',
- name='survexfile',
- field=models.ForeignKey(blank=True, null=True, to='core.SurvexFile'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='survexblock',
- name='survexscansfolder',
- field=models.ForeignKey(null=True, to='core.SurvexScansFolder'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='qm',
- name='nearest_station',
- field=models.ForeignKey(blank=True, null=True, to='core.SurvexStation'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='qm',
- name='ticked_off_by',
- field=models.ForeignKey(blank=True, null=True, related_name='QMs_ticked_off', to='core.LogbookEntry'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='cavedescription',
- name='linked_entrances',
- field=models.ManyToManyField(blank=True, null=True, to='core.Entrance'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='cavedescription',
- name='linked_qms',
- field=models.ManyToManyField(blank=True, null=True, to='core.QM'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='cavedescription',
- name='linked_subcaves',
- field=models.ManyToManyField(blank=True, null=True, to='core.NewSubCave'),
- preserve_default=True,
- ),
- migrations.AddField(
- model_name='caveandentrance',
- name='entrance',
- field=models.ForeignKey(to='core.Entrance'),
- preserve_default=True,
- ),
- ]