diff options
Diffstat (limited to 'lib/orm/migrations/0001_initial.py')
-rw-r--r-- | lib/orm/migrations/0001_initial.py | 92 |
1 files changed, 53 insertions, 39 deletions
diff --git a/lib/orm/migrations/0001_initial.py b/lib/orm/migrations/0001_initial.py index 0914d2bc..69ff00a3 100644 --- a/lib/orm/migrations/0001_initial.py +++ b/lib/orm/migrations/0001_initial.py @@ -99,10 +99,11 @@ class Migration(migrations.Migration): ('cvssV2_baseScore',models.CharField(max_length=50, blank=True)), ('cvssV2_severity', models.CharField(max_length=50, blank=True)), - ('packages', models.TextField(blank=True, null=True)), + ('packages', models.TextField(blank=True)), ('score_date', models.DateTimeField(null=True, blank=True)), ('srt_updated', models.DateTimeField(auto_now=True)), +## ('srt_created', models.DateTimeField(auto_now_add=True)), ], ), @@ -158,18 +159,18 @@ class Migration(migrations.Migration): migrations.CreateModel( name='CveSource', fields=[ - ('cve', models.ForeignKey(related_name='source2cve', default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('cve', models.ForeignKey(default=None, related_name='source2cve', to='orm.cve', null=True,on_delete=models.CASCADE,)), ('datasource', models.ForeignKey(default=None, to='orm.datasource',null=True,on_delete=models.CASCADE,)), ], ), - migrations.CreateModel( name='CveToCwe', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('cve', models.ForeignKey(related_name='cve2cwe', default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), - ('cwe', models.ForeignKey(default=None, to='orm.cwetable', null=True,on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(related_name='cve2cwe', to='orm.cve', on_delete=models.CASCADE,)), + ('cwe', models.ForeignKey(to='orm.cwetable', on_delete=models.CASCADE,)), ], ), @@ -177,10 +178,11 @@ class Migration(migrations.Migration): migrations.CreateModel( name='Package', fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('mode', models.IntegerField(default=0)), ('name', models.CharField(max_length=50, blank=True)), ('realname', models.CharField(max_length=50, blank=True)), - ('invalidname', models.TextField(blank=True, null=True)), + ('invalidname', models.TextField(blank=True)), ('weight', models.IntegerField(default=0)), ('cve_count', models.IntegerField(default=0)), ('vulnerability_count', models.IntegerField(default=0)), @@ -192,8 +194,9 @@ class Migration(migrations.Migration): migrations.CreateModel( name='PackageToCve', fields=[ - ('package', models.ForeignKey(related_name='package2cve', default=None, to='orm.package', null=True,on_delete=models.CASCADE,)), - ('cve', models.ForeignKey(related_name='cve2package', default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('package', models.ForeignKey(related_name='package2cve', to='orm.package', on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(related_name='cve2package', to='orm.cve', on_delete=models.CASCADE,)), ('applicable', models.NullBooleanField(default=True, null=True)), ], ), @@ -202,13 +205,13 @@ class Migration(migrations.Migration): name='CveReference', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('cve', models.ForeignKey(related_name='references', default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(related_name='references', to='orm.cve', on_delete=models.CASCADE,)), ('hyperlink', models.CharField(max_length=100, null=True)), ('resource', models.CharField(max_length=100, null=True)), ('type', models.CharField(max_length=100, null=True)), ('source', models.CharField(max_length=100, null=True)), ('name', models.CharField(max_length=100, null=True)), - ('datasource', models.ForeignKey(related_name='source_references', default=None, to='orm.datasource', null=True,on_delete=models.CASCADE,)), + ('datasource', models.ForeignKey(related_name='source_references', to='orm.datasource', default=None, null=True,on_delete=models.CASCADE,)), ], ), @@ -216,7 +219,7 @@ class Migration(migrations.Migration): name='CveHistory', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('cve', models.ForeignKey(default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(default=None, null=True, to='orm.cve', on_delete=models.CASCADE,)), ('comment', models.TextField(blank=True)), ('date', models.DateField(null=True, blank=True)), ('author', models.TextField(blank=True)), @@ -258,8 +261,8 @@ class Migration(migrations.Migration): name='CveToVulnerablility', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), - ('cve', models.ForeignKey(default=None, to='orm.cve', null=True,on_delete=models.CASCADE,)), + ('vulnerability', models.ForeignKey(to='orm.vulnerability', on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(to='orm.cve', on_delete=models.CASCADE,)), ], ), @@ -267,7 +270,7 @@ class Migration(migrations.Migration): name='VulnerabilityComments', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), + ('vulnerability', models.ForeignKey(to='orm.vulnerability', on_delete=models.CASCADE,)), ('comment', models.TextField(blank=True)), ('date', models.DateField(null=True, blank=True)), ('author', models.TextField(blank=True)), @@ -278,7 +281,7 @@ class Migration(migrations.Migration): name='VulnerabilityHistory', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), + ('vulnerability', models.ForeignKey(to='orm.vulnerability', on_delete=models.CASCADE,)), ('comment', models.TextField(blank=True)), ('date', models.DateField(null=True, blank=True)), ('author', models.TextField(blank=True)), @@ -289,7 +292,7 @@ class Migration(migrations.Migration): name='VulnerabilityUploads', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), + ('vulnerability', models.ForeignKey(to='orm.vulnerability',on_delete=models.CASCADE,)), ('description', models.TextField(blank=True)), ('path', models.TextField(blank=True)), ('size', models.IntegerField(default=0)), @@ -310,7 +313,7 @@ class Migration(migrations.Migration): ('resolution', models.IntegerField(default=0)), ('publish', models.TextField(blank=True)), ('release_version', models.CharField(max_length=50)), - ('product', models.ForeignKey(default=None, to='orm.product', null=True,on_delete=models.CASCADE,)), + ('product', models.ForeignKey(to='orm.product', on_delete=models.CASCADE,)), ('date_created', models.CharField(max_length=50)), ('date_updated', models.CharField(max_length=50)), ('srt_updated', models.DateTimeField(auto_now=True)), @@ -323,8 +326,8 @@ class Migration(migrations.Migration): fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), ('name', models.CharField(max_length=50)), - ('vulnerability', models.ForeignKey(related_name='vulnerability_investigation',default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), - ('product', models.ForeignKey(related_name='references', default=None, to='orm.product', null=True,on_delete=models.CASCADE,)), + ('vulnerability', models.ForeignKey(related_name='vulnerability_investigation',to='orm.vulnerability', on_delete=models.CASCADE,)), + ('product', models.ForeignKey(related_name='references', to='orm.product',on_delete=models.CASCADE,)), ('public', models.BooleanField(default=True)), ('comments', models.TextField(blank=True)), @@ -340,9 +343,9 @@ class Migration(migrations.Migration): name='InvestigationToDefect', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), - ('defect', models.ForeignKey(default=None, to='orm.defect', null=True,on_delete=models.CASCADE,)), - ('product', models.ForeignKey(default=None, to='orm.product', null=True,on_delete=models.CASCADE,)), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), + ('defect', models.ForeignKey(to='orm.defect', on_delete=models.CASCADE,)), + ('product', models.ForeignKey(to='orm.product', on_delete=models.CASCADE,)), ], ), @@ -350,7 +353,7 @@ class Migration(migrations.Migration): name='InvestigationComments', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), ('comment', models.TextField(blank=True)), ('date', models.DateField(null=True, blank=True)), ('author', models.TextField(blank=True)), @@ -361,7 +364,7 @@ class Migration(migrations.Migration): name='InvestigationHistory', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), ('comment', models.TextField(blank=True)), ('date', models.DateField(null=True, blank=True)), ('author', models.TextField(blank=True)), @@ -372,7 +375,7 @@ class Migration(migrations.Migration): name='InvestigationUploads', fields=[ ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)), - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), ('description', models.TextField(blank=True)), ('path', models.TextField(blank=True)), ('size', models.IntegerField(default=0)), @@ -394,38 +397,43 @@ class Migration(migrations.Migration): migrations.CreateModel( name='VulnerabilityAccess', fields=[ - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), - ('user', models.ForeignKey(default=None, to='users.srtuser', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('vulnerability', models.ForeignKey(to='orm.vulnerability', on_delete=models.CASCADE,)), + ('user', models.ForeignKey(to='users.srtuser', on_delete=models.CASCADE,)), ], ), migrations.CreateModel( name='InvestigationAccess', fields=[ - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), - ('user', models.ForeignKey(default=None, to='users.srtuser', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), + ('user', models.ForeignKey(to='users.srtuser', on_delete=models.CASCADE,)), ], ), migrations.CreateModel( name='VulnerabilityNotification', fields=[ - ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability', null=True,on_delete=models.CASCADE,)), - ('user', models.ForeignKey(default=None, to='users.srtuser', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('vulnerability', models.ForeignKey(to='orm.vulnerability', on_delete=models.CASCADE,)), + ('user', models.ForeignKey(to='users.srtuser', on_delete=models.CASCADE,)), ], ), migrations.CreateModel( name='InvestigationNotification', fields=[ - ('investigation', models.ForeignKey(default=None, to='orm.investigation', null=True,on_delete=models.CASCADE,)), - ('user', models.ForeignKey(default=None, to='users.srtuser', null=True,on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('investigation', models.ForeignKey(to='orm.investigation', on_delete=models.CASCADE,)), + ('user', models.ForeignKey(to='users.srtuser', on_delete=models.CASCADE,)), ], ), migrations.CreateModel( name='CpeTable', fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('vulnerable', models.BooleanField(default='False')), ('cpeMatchString', models.TextField(blank=True)), ('cpe23Uri', models.TextField(blank=True)), @@ -436,14 +444,16 @@ class Migration(migrations.Migration): migrations.CreateModel( name='CpeToCve', fields=[ - ('cpe', models.ForeignKey(default=None, to='orm.cpetable',on_delete=models.CASCADE,)), - ('cve', models.ForeignKey(default=None, to='orm.cve',on_delete=models.CASCADE,)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('cpe', models.ForeignKey(to='orm.cpetable',on_delete=models.CASCADE,)), + ('cve', models.ForeignKey(to='orm.cve',on_delete=models.CASCADE,)), ], ), migrations.CreateModel( name='CpeFilter', fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('key_prime', models.CharField(max_length=50)), ('key_sub', models.CharField(max_length=50)), ('status', models.IntegerField(default=CpeFilter.UNDECIDED)), @@ -456,6 +466,7 @@ class Migration(migrations.Migration): migrations.CreateModel( name='PublishPending', fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cve', models.ForeignKey(default=None, to='orm.cve',blank=True,null=True,on_delete=models.CASCADE,)), ('vulnerability', models.ForeignKey(default=None, to='orm.vulnerability',blank=True,null=True,on_delete=models.CASCADE,)), ('investigation', models.ForeignKey(default=None, to='orm.investigation',blank=True,null=True,on_delete=models.CASCADE,)), @@ -468,19 +479,21 @@ class Migration(migrations.Migration): migrations.CreateModel( name='Notify', fields=[ - ('category', models.CharField(max_length=50, null=True)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('category', models.CharField(max_length=50)), ('description', models.TextField()), ('url', models.TextField()), ('priority', models.IntegerField(default=0)), ('author', models.TextField()), - ('srt_updated', models.DateTimeField(auto_now_add=True)), - ('srt_created', models.DateTimeField(auto_now=True)), +## ('srt_updated', models.DateTimeField(auto_now=True)), +## ('srt_created', models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name='NotifyAccess', fields=[ + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('notify', models.ForeignKey(default=None, to='orm.notify',blank=True,null=True,on_delete=models.CASCADE,)), ('user', models.ForeignKey(default=None, to='users.srtuser',blank=True,null=True,on_delete=models.CASCADE,)), ], @@ -489,7 +502,8 @@ class Migration(migrations.Migration): migrations.CreateModel( name='NotifyCategories', fields=[ - ('category', models.CharField(max_length=50, null=True)), + ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), + ('category', models.CharField(max_length=50)), ], ), |