aboutsummaryrefslogtreecommitdiffstats
path: root/lib/orm/migrations/0001_initial.py
diff options
context:
space:
mode:
Diffstat (limited to 'lib/orm/migrations/0001_initial.py')
-rw-r--r--lib/orm/migrations/0001_initial.py92
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)),
],
),