diff options
Diffstat (limited to 'troggle-inspectdb.py')
| -rw-r--r-- | troggle-inspectdb.py | 595 |
1 files changed, 0 insertions, 595 deletions
diff --git a/troggle-inspectdb.py b/troggle-inspectdb.py deleted file mode 100644 index 4c3d1dc..0000000 --- a/troggle-inspectdb.py +++ /dev/null @@ -1,595 +0,0 @@ -* importing troggle/settings.py - * importing troggle/localsettings.py -+ finished importing troggle/settings.py -* importing troggle/settings.py -+ finished importing troggle/settings.py -** importing troggle/core/views_other.py - - newFile() is next in troggle/core/views_other.py -** Finished importing troggle/core/views_other.py -# This is an auto-generated Django model module. -# You'll have to do the following manually to clean this up: -# * Rearrange models' order -# * Make sure each model has one field with primary_key=True -# * Make sure each ForeignKey has `on_delete` set to the desired behavior. -# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table -# Feel free to rename the models, but don't rename db_table values or field names. -from __future__ import unicode_literals - -from django.db import models - - -class AuthGroup(models.Model): - name = models.CharField(unique=True, max_length=80) - - class Meta: - managed = False - db_table = 'auth_group' - - -class AuthGroupPermissions(models.Model): - group = models.ForeignKey(AuthGroup, models.DO_NOTHING) - permission = models.ForeignKey('AuthPermission', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_group_permissions' - unique_together = (('group', 'permission'),) - - -class AuthPermission(models.Model): - name = models.CharField(max_length=255) - content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING) - codename = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'auth_permission' - unique_together = (('content_type', 'codename'),) - - -class AuthUser(models.Model): - password = models.CharField(max_length=128) - last_login = models.DateTimeField(blank=True, null=True) - is_superuser = models.IntegerField() - username = models.CharField(unique=True, max_length=150) - first_name = models.CharField(max_length=30) - last_name = models.CharField(max_length=30) - email = models.CharField(max_length=254) - is_staff = models.IntegerField() - is_active = models.IntegerField() - date_joined = models.DateTimeField() - - class Meta: - managed = False - db_table = 'auth_user' - - -class AuthUserGroups(models.Model): - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - group = models.ForeignKey(AuthGroup, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_user_groups' - unique_together = (('user', 'group'),) - - -class AuthUserUserPermissions(models.Model): - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_user_user_permissions' - unique_together = (('user', 'permission'),) - - -class CoreArea(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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('self', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_area' - - -class CoreCave(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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) - - class Meta: - managed = False - db_table = 'core_cave' - - -class CoreCaveArea(models.Model): - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - area = models.ForeignKey(CoreArea, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cave_area' - unique_together = (('cave', 'area'),) - - -class CoreCaveandentrance(models.Model): - entrance_letter = models.CharField(max_length=20, blank=True, null=True) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - entrance = models.ForeignKey('CoreEntrance', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_caveandentrance' - - -class CoreCavedescription(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - short_name = models.CharField(unique=True, max_length=50) - long_name = models.CharField(max_length=200, blank=True, null=True) - description = models.TextField(blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_cavedescription' - - -class CoreCavedescriptionLinkedEntrances(models.Model): - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - entrance = models.ForeignKey('CoreEntrance', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_entrances' - unique_together = (('cavedescription', 'entrance'),) - - -class CoreCavedescriptionLinkedQms(models.Model): - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - qm = models.ForeignKey('CoreQm', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_qms' - unique_together = (('cavedescription', 'qm'),) - - -class CoreCavedescriptionLinkedSubcaves(models.Model): - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - newsubcave = models.ForeignKey('CoreNewsubcave', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_subcaves' - unique_together = (('cavedescription', 'newsubcave'),) - - -class CoreCaveslug(models.Model): - slug = models.CharField(unique=True, max_length=50) - primary = models.IntegerField() - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_caveslug' - - -class CoreDataissue(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - date = models.DateTimeField() - parser = models.CharField(max_length=50, blank=True, null=True) - message = models.CharField(max_length=400, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_dataissue' - - -class CoreEntrance(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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) - marking_comment = models.TextField(blank=True, null=True) - findability = models.CharField(max_length=1, blank=True, 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(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) - - class Meta: - managed = False - db_table = 'core_entrance' - - -class CoreEntranceslug(models.Model): - slug = models.CharField(unique=True, max_length=50) - primary = models.IntegerField() - entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_entranceslug' - - -class CoreExpedition(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - year = models.CharField(unique=True, max_length=20) - name = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'core_expedition' - - -class CoreExpeditionday(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - date = models.DateField() - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_expeditionday' - - -class CoreLogbookentry(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - date = models.DateField() - title = models.CharField(max_length=200) - cave_slug = models.CharField(max_length=50, blank=True, null=True) - place = models.CharField(max_length=100, blank=True, null=True) - text = models.TextField() - slug = models.CharField(max_length=50) - filename = models.CharField(max_length=200, blank=True, null=True) - entry_type = models.CharField(max_length=50, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING, blank=True, null=True) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_logbookentry' - - -class CoreNewsubcave(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - name = models.CharField(unique=True, max_length=200) - - class Meta: - managed = False - db_table = 'core_newsubcave' - - -class CoreOthercavename(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - name = models.CharField(max_length=160) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_othercavename' - - -class CorePerson(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - first_name = models.CharField(max_length=100) - last_name = models.CharField(max_length=100) - fullname = models.CharField(max_length=200) - is_vfho = models.IntegerField() - 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.ForeignKey(AuthUser, models.DO_NOTHING, unique=True, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_person' - - -class CorePersonexpedition(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - slugfield = models.CharField(max_length=50, blank=True, null=True) - is_guest = models.IntegerField() - expo_committee_position = models.CharField(max_length=200, blank=True, null=True) - nickname = models.CharField(max_length=100, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING) - person = models.ForeignKey(CorePerson, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_personexpedition' - - -class CorePersontrip(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - time_underground = models.FloatField() - is_logbook_entry_author = models.IntegerField() - logbook_entry = models.ForeignKey(CoreLogbookentry, models.DO_NOTHING) - personexpedition = models.ForeignKey(CorePersonexpedition, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_persontrip' - - -class CoreQm(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - number = models.IntegerField() - grade = models.CharField(max_length=1) - location_description = models.TextField() - 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(CoreLogbookentry, models.DO_NOTHING, blank=True, null=True) - nearest_station = models.ForeignKey('CoreSurvexstation', models.DO_NOTHING, blank=True, null=True) - ticked_off_by = models.ForeignKey(CoreLogbookentry, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_qm' - - -class CoreScansfolder(models.Model): - fpath = models.CharField(max_length=200) - walletname = models.CharField(max_length=200) - - class Meta: - managed = False - db_table = 'core_scansfolder' - - -class CoreSinglescan(models.Model): - ffile = models.CharField(max_length=200) - name = models.CharField(max_length=200) - scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_singlescan' - - -class CoreSurvexblock(models.Model): - name = models.CharField(max_length=100) - title = models.CharField(max_length=200) - date = models.DateField(blank=True, null=True) - survexpath = models.CharField(max_length=200) - legsall = models.IntegerField(blank=True, null=True) - legslength = models.FloatField(blank=True, null=True) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING, blank=True, null=True) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True) - scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING, blank=True, null=True) - survexfile = models.ForeignKey('CoreSurvexfile', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexblock' - - -class CoreSurvexdirectory(models.Model): - path = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - primarysurvexfile = models.ForeignKey('CoreSurvexfile', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexdirectory' - - -class CoreSurvexfile(models.Model): - path = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - survexdirectory = models.ForeignKey(CoreSurvexdirectory, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexfile' - - -class CoreSurvexpersonrole(models.Model): - nrole = models.CharField(max_length=200, blank=True, null=True) - personname = models.CharField(max_length=100) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - person = models.ForeignKey(CorePerson, models.DO_NOTHING, blank=True, null=True) - personexpedition = models.ForeignKey(CorePersonexpedition, models.DO_NOTHING, blank=True, null=True) - persontrip = models.ForeignKey(CorePersontrip, models.DO_NOTHING, blank=True, null=True) - survexblock = models.ForeignKey(CoreSurvexblock, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_survexpersonrole' - - -class CoreSurvexstation(models.Model): - 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(CoreSurvexblock, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexstation' - - -class CoreSurvextitle(models.Model): - title = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - survexblock = models.ForeignKey(CoreSurvexblock, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survextitle' - - -class CoreTunnelfile(models.Model): - tunnelpath = models.CharField(max_length=200) - tunnelname = models.CharField(max_length=200) - bfontcolours = models.IntegerField() - filesize = models.IntegerField() - npaths = models.IntegerField() - - class Meta: - managed = False - db_table = 'core_tunnelfile' - - -class CoreTunnelfileManyscansfolders(models.Model): - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_manyscansfolders' - unique_together = (('tunnelfile', 'scansfolder'),) - - -class CoreTunnelfileScans(models.Model): - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - singlescan = models.ForeignKey(CoreSinglescan, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_scans' - unique_together = (('tunnelfile', 'singlescan'),) - - -class CoreTunnelfileSurvexfiles(models.Model): - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - survexfile = models.ForeignKey(CoreSurvexfile, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_survexfiles' - unique_together = (('tunnelfile', 'survexfile'),) - - -class CoreTunnelfileTunnelcontains(models.Model): - from_tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - to_tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_tunnelcontains' - unique_together = (('from_tunnelfile', 'to_tunnelfile'),) - - -class DjangoAdminLog(models.Model): - action_time = models.DateTimeField() - object_id = models.TextField(blank=True, null=True) - object_repr = models.CharField(max_length=200) - action_flag = models.SmallIntegerField() - change_message = models.TextField() - content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True) - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'django_admin_log' - - -class DjangoContentType(models.Model): - app_label = models.CharField(max_length=100) - model = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'django_content_type' - unique_together = (('app_label', 'model'),) - - -class DjangoMigrations(models.Model): - app = models.CharField(max_length=255) - name = models.CharField(max_length=255) - applied = models.DateTimeField() - - class Meta: - managed = False - db_table = 'django_migrations' - - -class DjangoSession(models.Model): - session_key = models.CharField(primary_key=True, max_length=40) - session_data = models.TextField() - expire_date = models.DateTimeField() - - class Meta: - managed = False - db_table = 'django_session' - - -class FlatpagesEntranceredirect(models.Model): - originalurl = models.CharField(db_column='originalURL', max_length=200) # Field name made lowercase. - entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'flatpages_entranceredirect' - - -class FlatpagesRedirect(models.Model): - originalurl = models.CharField(db_column='originalURL', unique=True, max_length=200) # Field name made lowercase. - newurl = models.CharField(db_column='newURL', max_length=200) # Field name made lowercase. - - class Meta: - managed = False - db_table = 'flatpages_redirect' - - -class RegistrationRegistrationprofile(models.Model): - activation_key = models.CharField(max_length=40) - user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True) - - class Meta: - managed = False - db_table = 'registration_registrationprofile' |