class Migration(migrations.Migration):
dependencies = [
('data', '0019_merge_20180701_0022'),
]
operations = [
migrations.CreateModel(
name='Committee',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=50)),
('committee_lgo',
models.ImageField(
blank=True,
upload_to=data.models.get_committee_upload_url,
verbose_name='Committee Logo')),
('members',
models.ManyToManyField(blank=True, to='data.MoreUserData')),
],
),
migrations.CreateModel(
name='CommitteeContactInfo',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('phone_number',
models.CharField(
blank=True,
help_text=
'Enter The contact number of committee without the preceeding country code',
max_length=10,
validators=[
django.core.validators.MinLengthValidator(10)
])),
('email', models.EmailField(blank=True, max_length=254)),
('committee',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='data.Committee')),
],
),
migrations.AlterField(
model_name='event',
name='organisers',
field=models.ManyToManyField(
blank=True,
help_text='Please Select 1 or more users as Organisers',
related_name='organising_events',
to='data.MoreUserData'),
),
]
class Migration(migrations.Migration):
dependencies = [
('data', '0008_datarelease_created'),
]
operations = [
migrations.CreateModel(
name='VariantDiff',
fields=[
('variant',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to='data.Variant')),
('diff', data.models.LegacyJSONField()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('data', '0026_report_change_type'),
]
operations = [
migrations.CreateModel(
name='ReportDiff',
fields=[
('report',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to='data.Report')),
('report_diff', data.models.LegacyJSONField()),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('data', '0012_merge_20180626_2003'),
]
operations = [
migrations.CreateModel(
name='EventCatalogue',
fields=[
('event', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='data.Event')),
('image1', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional). This is primary image that will appear on main page', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 1')),
('image2', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional)', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 2')),
('image3', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional)', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 3')),
('image4', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional)', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 4')),
('image5', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional)', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 5')),
('image6', models.ImageField(blank=True, help_text='Upload Image 1 for this Event. (optional)', upload_to=data.models.get_event_catalogue_upload_url, verbose_name='Image 6')),
],
),
]
class Migration(migrations.Migration):
dependencies = [
('data', '0004_auto_20181118_0840'),
]
operations = [
migrations.CreateModel(
name='HeadingEvent',
fields=[
('locationevent_ptr', models.OneToOneField(auto_created=True, on_delete=django.db.models.deletion.CASCADE, parent_link=True, primary_key=True, serialize=False, to='data.LocationEvent')),
],
options={
'abstract': False,
'base_manager_name': 'objects',
},
bases=('data.locationevent',),
),
migrations.AddField(
model_name='ferry',
name='destination',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='data.Destination'),
),
migrations.AddField(
model_name='ferry',
name='heading',
field=models.CharField(blank=True, max_length=8, null=True),
),
migrations.AddField(
model_name='ferry',
name='last_updated',
field=models.DateTimeField(auto_now=True),
),
migrations.AddField(
model_name='ferry',
name='status',
field=models.CharField(blank=True, choices=[(data.models.FerryStatus('In Port'), 'In Port'), (data.models.FerryStatus('Under Way'), 'Under Way'), (data.models.FerryStatus('Offline'), 'Offline')], max_length=16, null=True),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0007_alter_validators_add_error_messages'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='EventLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=256)),
('description', models.CharField(blank=True, max_length=512)),
('timestamp',
models.DateTimeField(default=data.models.get_now)),
],
),
migrations.CreateModel(
name='Image',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('filename',
models.CharField(max_length=512, verbose_name=b'Filename')),
],
),
migrations.CreateModel(
name='Task',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('finished',
models.IntegerField(choices=[(0, b'No'), (1, b'Yes'),
(2, b'N/A')],
default=0)),
('street_num',
models.CharField(max_length=64,
null=True,
verbose_name=b'Street #')),
('street_nam',
models.CharField(max_length=512,
null=True,
verbose_name=b'Street name')),
('city',
models.CharField(max_length=512,
null=True,
verbose_name=b'City')),
('state',
models.CharField(choices=[(b'AL', b'AL'), (b'AK', b'AK'),
(b'AZ', b'AZ'), (b'AR', b'AR'),
(b'CA', b'CA'), (b'CO', b'CO'),
(b'CT', b'CT'), (b'DC', b'DC'),
(b'DE', b'DE'), (b'FL', b'FL'),
(b'GA', b'GA'), (b'HI', b'HI'),
(b'ID', b'ID'), (b'IL', b'IL'),
(b'IN', b'IN'), (b'IA', b'IA'),
(b'KS', b'KS'), (b'KY', b'KY'),
(b'LA', b'LA'), (b'ME', b'ME'),
(b'MD', b'MD'), (b'MA', b'MA'),
(b'MI', b'MI'), (b'MN', b'MN'),
(b'MS', b'MS'), (b'MO', b'MO'),
(b'MT', b'MT'), (b'NE', b'NE'),
(b'NV', b'NV'), (b'NH', b'NH'),
(b'NJ', b'NJ'), (b'NM', b'NM'),
(b'NY', b'NY'), (b'NC', b'NC'),
(b'ND', b'ND'), (b'OH', b'OH'),
(b'OK', b'OK'), (b'OR', b'OR'),
(b'PA', b'PA'), (b'RI', b'RI'),
(b'SC', b'SC'), (b'SD', b'SD'),
(b'TN', b'TN'), (b'TX', b'TX'),
(b'UT', b'UT'), (b'VT', b'VT'),
(b'VA', b'VA'), (b'WA', b'WA'),
(b'WV', b'WV'), (b'WI', b'WI'),
(b'WY', b'WY')],
max_length=4,
null=True,
verbose_name=b'State')),
('month',
models.IntegerField(choices=[(1, b'Jan'), (2, b'Feb'),
(3, b'Mar'), (4, b'Apr'),
(5, b'May'), (6, b'Jun'),
(7, b'Jul'), (8, b'Aug'),
(9, b'Sep'), (10, b'Oct'),
(11, b'Nov'), (12, b'Dec')],
null=True)),
('year',
models.IntegerField(choices=[(2000, 2000), (2001, 2001),
(2002, 2002), (2003, 2003),
(2004, 2004), (2005, 2005),
(2006, 2006), (2007, 2007),
(2008, 2008), (2009, 2009),
(2010, 2010), (2011, 2011),
(2012, 2012), (2013, 2013),
(2014, 2014), (2015, 2015),
(2016, 2016)],
null=True)),
('pic_quality',
models.IntegerField(
choices=[(1, b'Strongly Disagree'), (2, b'Disagree'),
(3, b'Neither Agree or Disagree'), (4, b'Agree'),
(5, b'Strongly Agree'), (6, b'N/A')],
null=True,
verbose_name=b'The quality of the actual picture is high')
),
('str_quality',
models.IntegerField(
choices=[(1, b'Strongly Disagree'), (2, b'Disagree'),
(3, b'Neither Agree or Disagree'), (4, b'Agree'),
(5, b'Strongly Agree'), (6, b'N/A')],
null=True,
verbose_name=
b'The quality of the streets visible in the picture is high'
)),
('pot_holes',
models.IntegerField(
choices=[(0, b'0'), (1, b'1'), (2, b'2'), (3, b'3'),
(4, b'4'), (5, b'5'), (6, b'5+'), (7, b'N/A')],
null=True,
verbose_name=
b'How many potholes are visible in the picture')),
('bui_quality',
models.IntegerField(
choices=[(1, b'Strongly Disagree'), (2, b'Disagree'),
(3, b'Neither Agree or Disagree'), (4, b'Agree'),
(5, b'Strongly Agree'), (6, b'N/A')],
null=True,
verbose_name=
b'The quality of buildings visible in the picture is high'
)),
('car_quality',
models.IntegerField(
choices=[(1, b'Strongly Disagree'), (2, b'Disagree'),
(3, b'Neither Agree or Disagree'), (4, b'Agree'),
(5, b'Strongly Agree'), (6, b'N/A')],
null=True,
verbose_name=
b'The quality of the vehicles visible in the picture is high'
)),
('litter',
models.IntegerField(
choices=[(1, b'Strongly Disagree'), (2, b'Disagree'),
(3, b'Neither Agree or Disagree'), (4, b'Agree'),
(5, b'Strongly Agree'), (6, b'N/A')],
null=True,
verbose_name=
b'The amount of litter visible in the picture is high')),
('road_work',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'Are there signs of road work visible in the picture')),
('graffiti',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=b'Is there graffiti visible in the picture')
),
('for_sale',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'There are one or more house for sale signs visible in the picture'
)),
('shoes',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'Are there shoes on a wire visible in the picture')),
('trees',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'Are there trees and/or large bushes visible in the picture'
)),
('broken_signs',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'Are there any broken street signs visible in the picture'
)),
('people',
models.IntegerField(
choices=[(0, b'No'), (1, b'Yes'), (2, b'N/A')],
null=True,
verbose_name=
b'Are there people actively covering their faces visible in the picture'
)),
('timestarted',
models.DateTimeField(default=data.models.get_now)),
('timefinished', models.DateTimeField(blank=True, null=True)),
('image',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='data.Image')),
],
),
migrations.CreateModel(
name='Treatment',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('wage',
models.CharField(max_length=128, verbose_name=b'Wage Rate')),
('tutorial', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='WorkTimer',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page', models.CharField(max_length=28, null=True)),
('value', models.IntegerField()),
('token', models.CharField(max_length=256)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('task',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.Task')),
],
),
migrations.CreateModel(
name='TimeSheet',
fields=[],
options={
'proxy': True,
},
bases=('auth.user', ),
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
migrations.AddField(
model_name='worktimer',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='treatment',
name='user',
field=models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='task',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='eventlog',
name='task',
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.Task'),
),
migrations.AddField(
model_name='eventlog',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Activation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('COAID',
models.CharField(blank=True,
max_length=255,
null=True,
unique=True)),
('productKey', models.CharField(max_length=255, unique=True)),
('securityCode',
models.CharField(blank=True, max_length=255, null=True)),
('windowsVer', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='CPU',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('serial',
models.CharField(blank=True, max_length=255, null=True)),
('location',
models.CharField(blank=True, max_length=255, null=True)),
],
),
migrations.CreateModel(
name='CPUModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('manufacturer', models.CharField(max_length=255)),
('arch', models.CharField(max_length=255)),
('partnum',
models.CharField(blank=True, max_length=255, null=True)),
('family',
models.CharField(blank=True, max_length=255, null=True)),
('upgradeMethod',
models.CharField(blank=True, max_length=255, null=True)),
('cores',
models.PositiveSmallIntegerField(blank=True, null=True)),
('threads',
models.PositiveSmallIntegerField(blank=True, null=True)),
('speed',
models.PositiveSmallIntegerField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='GPU',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('location',
models.CharField(blank=True, max_length=255, null=True)),
],
),
migrations.CreateModel(
name='GPUModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('size', models.BigIntegerField(blank=True, null=True)),
('refresh',
models.PositiveSmallIntegerField(blank=True, null=True)),
('arch', models.CharField(blank=True,
max_length=255,
null=True)),
('memoryType',
models.CharField(blank=True, max_length=255, null=True)),
],
bases=(models.Model, data.models.CalcSizeMixin),
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('campus', models.CharField(blank=True, max_length=255)),
('room', models.CharField(blank=True, max_length=255)),
('address', models.CharField(blank=True, max_length=255)),
],
),
migrations.CreateModel(
name='LogicalDisk',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('mount', models.CharField(blank=True, max_length=4,
null=True)),
('filesystem',
models.CharField(blank=True, max_length=255, null=True)),
('size', models.BigIntegerField()),
('freesize', models.BigIntegerField(blank=True, null=True)),
('type', models.CharField(blank=True,
max_length=255,
null=True)),
],
bases=(models.Model, data.models.CalcSizeMixin),
),
migrations.CreateModel(
name='Machine',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255, unique=True)),
('os', models.CharField(blank=True, max_length=255)),
('cloudID',
models.PositiveSmallIntegerField(blank=True,
null=True,
unique=True)),
('activation',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.Activation')),
],
),
migrations.CreateModel(
name='MachineModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('compType',
models.PositiveSmallIntegerField(choices=[(0, 'Unknown'),
(1, 'Other'),
(2, 'Desktop'),
(3, 'Laptop'),
(4, 'Server')],
default=0)),
('manufacturer', models.CharField(blank=True, max_length=255)),
('name', models.CharField(blank=True, max_length=255)),
],
),
migrations.CreateModel(
name='Network',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('mac',
macaddress.fields.MACAddressField(integer=True, unique=True)),
('location',
models.CharField(blank=True, max_length=255, null=True)),
('machine',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='data.Machine')),
],
),
migrations.CreateModel(
name='NetworkModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
('manufacturer',
models.CharField(blank=True, max_length=255, null=True)),
],
),
migrations.CreateModel(
name='PhysicalDisk',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('serial', models.CharField(blank=True, max_length=255)),
('partitions',
models.PositiveSmallIntegerField(blank=True, null=True)),
('machine',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='data.Machine')),
],
),
migrations.CreateModel(
name='PhysicalDiskModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(blank=True, max_length=255)),
('size', models.BigIntegerField()),
('interface', models.CharField(blank=True, max_length=5)),
('manufacturer', models.CharField(blank=True, max_length=255)),
],
bases=(models.Model, data.models.CalcSizeMixin),
),
migrations.CreateModel(
name='RAM',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('serial',
models.CharField(blank=True, max_length=255, null=True)),
('location',
models.CharField(blank=True, max_length=255, null=True)),
('machine',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='data.Machine')),
],
),
migrations.CreateModel(
name='RAMModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('size', models.BigIntegerField()),
('manufacturer',
models.CharField(blank=True, max_length=255, null=True)),
('partnum',
models.CharField(blank=True, max_length=255, null=True)),
('speed',
models.PositiveSmallIntegerField(blank=True, null=True)),
('formFactor',
models.CharField(blank=True, max_length=255, null=True)),
('memoryType',
models.CharField(blank=True, max_length=255, null=True)),
],
bases=(models.Model, data.models.CalcSizeMixin),
),
migrations.CreateModel(
name='Role',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=255)),
],
),
migrations.CreateModel(
name='WMICodes',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(default='Unknown', max_length=255)),
('code', models.PositiveSmallIntegerField()),
('identifier', models.CharField(max_length=255)),
('wmiObject', models.CharField(max_length=255)),
('status',
models.PositiveSmallIntegerField(choices=[(0, 'Unknown'),
(1, 'Known'),
(2, 'Custom')],
default=0)),
('machines',
models.ManyToManyField(blank=True, to='data.Machine')),
],
),
migrations.AddField(
model_name='ram',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.RAMModel'),
),
migrations.AddField(
model_name='physicaldisk',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.PhysicalDiskModel'),
),
migrations.AddField(
model_name='network',
name='model',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.NetworkModel'),
),
migrations.AddField(
model_name='machine',
name='model',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.MachineModel'),
),
migrations.AddField(
model_name='machine',
name='roles',
field=models.ManyToManyField(blank=True, to='data.Role'),
),
migrations.AddField(
model_name='logicaldisk',
name='disk',
field=models.ManyToManyField(to='data.PhysicalDisk'),
),
migrations.AddField(
model_name='location',
name='computers',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='data.Machine'),
),
migrations.AddField(
model_name='gpu',
name='machine',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.Machine'),
),
migrations.AddField(
model_name='gpu',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.GPUModel'),
),
migrations.AddField(
model_name='cpu',
name='machine',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.Machine'),
),
migrations.AddField(
model_name='cpu',
name='model',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='data.CPUModel'),
),
]