# Generated by Django 2.2.10 on 2022-03-15 16:38 from django.conf import settings from django.db import migrations, models import django.db.models.deletion class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='ClientPermission', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('action', models.CharField(max_length=20)), ('iown', models.BooleanField(default=False)), ('permitted', models.BooleanField(default=False)), ], ), migrations.CreateModel( name='Colors', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('colorname', models.CharField(max_length=20)), ('hexvalue', models.CharField(max_length=8)), ], ), migrations.CreateModel( name='Map_desc', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('mapname', models.CharField(blank=True, max_length=55)), ('description', models.CharField(blank=True, max_length=125)), ('status', models.CharField(choices=[('A', 'Active'), ('D', 'Deleted')], default='A', max_length=1)), ('bgcolor', models.CharField(blank=True, default='FeFeFaFF', max_length=8)), ('nodesleft', models.PositiveSmallIntegerField(null=True)), ('orientation', models.CharField(blank=True, choices=[('LR', 'Left-Right'), ('RL', 'Right-Left'), ('TB', 'Top-Bottom'), ('BT', 'Bottom-Top')], default='LR', max_length=2)), ('layoutengine', models.CharField(blank=True, default='dot', max_length=5, null=True)), ('defaultNodeStyle', models.CharField(blank=True, default='filled,rounded', max_length=25)), ('defaultNodeShape', models.PositiveSmallIntegerField(blank=True, default=0)), ('defaultNodeFillcolor', models.CharField(blank=True, default='F0E68C', max_length=8)), ('defaultNodeHeight', models.FloatField(blank=True, default=2.5)), ('defaultNodeWidth', models.FloatField(blank=True, default=2.5)), ('defaultNodeType', models.CharField(blank=True, default='O', max_length=1)), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Node', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ('label', models.CharField(blank=True, max_length=64, null=True)), ('created_date', models.DateTimeField(auto_now=True, verbose_name='date created')), ('targetmapname', models.CharField(blank=True, default=None, max_length=55, null=True)), ('clusterid', models.PositiveIntegerField(default=0)), ('status', models.CharField(choices=[('A', 'Active'), ('D', 'Deleted'), ('M', 'Marked for deletion')], default='A', max_length=1)), ('nodetype', models.CharField(choices=[('P', 'Provisional'), ('O', 'Regular Node'), ('T', 'Tunnel'), ('C', 'Cluster Node'), ('S', 'Votable'), ('B', 'Path Origin Node'), ('E', 'Path End Node')], default=None, max_length=1)), ('xpos', models.FloatField(blank=True, default=0)), ('ypos', models.FloatField(blank=True, default=0)), ('size', models.CharField(blank=True, default='2.5,2.5', max_length=17)), ('lwidth', models.FloatField(default=None, null=True)), ('shape', models.SmallIntegerField(default=0, null=True)), ('style', models.CharField(default='filled,rounded', max_length=17)), ('fillcolor', models.CharField(default='F0E68C', max_length=8)), ('pencolor', models.CharField(default='000000', max_length=8)), ('fontcolor', models.CharField(default='000000', max_length=8)), ('description', models.CharField(blank=True, default=None, max_length=4096, null=True)), ('numcomments', models.PositiveSmallIntegerField(default=0)), ('url', models.URLField(blank=True, default=None, max_length=1024, null=True)), ('hiddenbranch', models.BigIntegerField(default=None, null=True)), ('isbranchhead', models.BooleanField(default=False)), ('ofmap', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('tunnelfarendmap', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='ideatree.Map_desc')), ('tunnelfarendnode', models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='ideatree.Node')), ], ), migrations.CreateModel( name='WhosViewingMap', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('mapViewed', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='WhosLoggedIn', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('currentmap', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Vote', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('vote', models.PositiveSmallIntegerField(default=5)), ('date', models.DateTimeField(auto_now=True, verbose_name='date')), ('status', models.CharField(choices=[('A', 'Active'), ('D', 'Deleted')], default='A', max_length=1)), ('node', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Node')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='UserProfile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('accounttype', models.CharField(choices=[('F', 'free'), ('R', 'regular'), ('P', 'premium')], default='F', max_length=1)), ('registerdate', models.DateTimeField(auto_now_add=True)), ('trialperioddays', models.PositiveSmallIntegerField(default=20)), ('mapsettings', models.CharField(default='{"view.nodeMaximization.smooth":false}', max_length=255, null=True)), ('nummapsallowed', models.PositiveSmallIntegerField(default=5)), ('invitationpending', models.BooleanField(default=False)), ('stripecustomerid', models.CharField(default='', max_length=120)), ('deleteglobally', models.BooleanField(default=False)), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='NodeComment', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ('comment', models.CharField(blank=True, default=None, max_length=1024, null=True)), ('date', models.DateTimeField(auto_now=True, verbose_name='date')), ('status', models.CharField(choices=[('A', 'Active'), ('D', 'Deleted')], default='A', max_length=1)), ('node', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Node')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='MapPathEndpoints', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('ofmap', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ('pathBeginNode', models.OneToOneField(null=True, on_delete=django.db.models.deletion.SET_NULL, to='ideatree.Node')), ('pathEndNode', models.OneToOneField(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to='ideatree.Node')), ], ), migrations.CreateModel( name='Mapmember', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.CharField(choices=[('A', 'Active'), ('D', 'Deleted')], default='A', max_length=1)), ('member', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('ofmap', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ], ), migrations.CreateModel( name='Map_access_changed', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('changed', models.BooleanField()), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Friend', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('email', models.EmailField(max_length=254, null=True)), ('status', models.CharField(choices=[('A', 'accepted'), ('I', 'invited'), ('N', 'declined'), ('D', 'deleted')], default='I', max_length=1)), ('friend', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='friendTablefriendField', to=settings.AUTH_USER_MODEL)), ('initiator', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Edge', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ('creation_date', models.DateTimeField(auto_now=True, verbose_name='creation date')), ('label', models.CharField(blank=True, default='', max_length=255, null=True)), ('status', models.CharField(choices=[('P', 'provisional'), ('A', 'active'), ('D', 'deleted')], default='A', max_length=1)), ('pheremone', models.BooleanField(default=False)), ('color', models.CharField(blank=True, default='000000', max_length=8)), ('penwidth', models.FloatField(default=1.0)), ('arrowhead', models.PositiveSmallIntegerField(default=0)), ('draw', models.CharField(blank=True, default='', max_length=65535)), ('hiddenbranch', models.BigIntegerField(default=None, null=True)), ('cost', models.SmallIntegerField(blank=True, default=0)), ('ofmap', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='ideatree.Map_desc')), ('origin', models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='connectedEdgeOrigin', to='ideatree.Node')), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), ('target', models.ForeignKey(default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='connectedEdgeTarget', to='ideatree.Node')), ], options={ 'db_table': 'ideatree_edge', 'managed': True, }, ), migrations.CreateModel( name='ContactUs', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateTimeField(auto_now_add=True)), ('email', models.EmailField(max_length=254)), ('message', models.CharField(max_length=550)), ('user', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddConstraint( model_name='colors', constraint=models.UniqueConstraint(fields=('colorname',), name='unique_colorname'), ), ]