class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Bible',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('testament_name', models.CharField(blank=True, max_length=100, null=True, verbose_name='성서 이름')),
('testament_kr_code', models.CharField(blank=True, max_length=50, null=True, verbose_name='성서 약어')),
('order', models.IntegerField(blank=True, null=True, validators=[common.models.validate_max_chapter], verbose_name='성서 번호')),
('chapter', models.PositiveIntegerField(blank=True, null=True, verbose_name='장')),
('verse', models.PositiveIntegerField(blank=True, null=True, verbose_name='절')),
('contents', models.TextField(blank=True, null=True, verbose_name='본문')),
('total_chapters', models.PositiveIntegerField(blank=True, null=True, verbose_name='성서의 장수')),
('total_verses', models.PositiveIntegerField(blank=True, null=True, verbose_name='해당 장의 절수')),
('version', models.CharField(blank=True, default='개역개정', max_length=100, null=True, verbose_name='개정종류')),
],
options={
'verbose_name': 'bible',
'verbose_name_plural': 'bible',
'db_table': 'bible',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('money', '0004_auto_20210527_2007'),
]
operations = [
migrations.CreateModel(
name='Budget',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('create_time', common.models.IntDateTimeField()),
('update_time', common.models.IntDateTimeField()),
('limit', models.PositiveIntegerField()),
('expense_group',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
to='money.expensegroup')),
],
options={
'db_table': 'budget_tab',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('money', '0002_income_incomecategory_incomegroup'),
]
operations = [
migrations.CreateModel(
name='ExpenseGroup',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('create_time', common.models.IntDateTimeField()),
('update_time', common.models.IntDateTimeField()),
('name', models.CharField(max_length=50, unique=True)),
],
options={
'db_table': 'expense_group_tab',
},
),
migrations.AlterField(
model_name='income',
name='receive_time',
field=common.models.IntDateTimeField(default=portfolio.time_util.now),
),
migrations.CreateModel(
name='ExpenseCategory',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('create_time', common.models.IntDateTimeField()),
('update_time', common.models.IntDateTimeField()),
('name', models.CharField(max_length=50, unique=True)),
('group', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='money.expensegroup')),
],
options={
'verbose_name_plural': 'expense categories',
'db_table': 'expense_category_tab',
},
),
migrations.CreateModel(
name='Expense',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('create_time', common.models.IntDateTimeField()),
('update_time', common.models.IntDateTimeField()),
('name', models.CharField(blank=True, max_length=500)),
('value', models.PositiveIntegerField()),
('receive_time', common.models.IntDateTimeField(default=portfolio.time_util.now)),
('category', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='money.expensecategory')),
('wallet', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='money.wallet')),
],
options={
'db_table': 'expense_tab',
},
),
]
class Migration(migrations.Migration):
dependencies = [
('common', '0003_auto_20200509_2050'),
]
operations = [
migrations.AddField(
model_name='user',
name='waist',
field=models.IntegerField(blank=True, null=True),
),
migrations.CreateModel(
name='ViceLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('vice', models.CharField(max_length=128)),
('quantity', models.CharField(max_length=128)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='ToiletLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='SymptomsLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('status',
models.IntegerField(choices=[(0, 'Okay'), (1, 'Not okay'),
(2, 'Very bad')],
default=0)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='StressLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('level', common.models.IntegerRangeField()),
('details', models.TextField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='SleepLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('start', models.TimeField()),
('end', models.TimeField()),
('quality', common.models.IntegerRangeField()),
('rem', models.BooleanField(blank=True)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='NaturalRemediesLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('natural_remedy', models.CharField(max_length=128)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='MedicationLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('medication', models.CharField(max_length=128)),
('dose', models.PositiveIntegerField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='ExerciseLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('exercise',
models.CharField(choices=[
('WA', 'Walking'), ('RU', 'Running'), ('CY', 'Cycling'),
('SW', 'Swimming')
],
max_length=2)),
('duration', models.DurationField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='DietLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('product', models.CharField(max_length=128)),
('code', models.CharField(blank=True, max_length=13)),
('calories', models.PositiveIntegerField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='CheckupLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField()),
('details', models.TextField()),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='CardiovascularLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('pulse', models.PositiveIntegerField()),
('systolic_pressure', models.PositiveIntegerField(blank=True)),
('diastolic_pressure',
models.PositiveIntegerField(blank=True)),
('blood_sugar', models.FloatField(blank=True)),
('saturation',
models.DecimalField(decimal_places=2, max_digits=5)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='BodyLog',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('preexisting', models.BooleanField(default=False)),
('timestamp', models.DateTimeField(auto_now_add=True)),
('height', models.IntegerField(blank=True, null=True)),
('weight', models.IntegerField(blank=True, null=True)),
('waist', models.IntegerField(blank=True, null=True)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'abstract': False,
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('autodj', '0001_initial'),
('broadcast', '0001_initial'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='UpstreamServer',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.SlugField(
help_text=
'Unique codename to identify this upstream server.',
max_length=20,
unique=True,
verbose_name='name')),
('hostname',
models.CharField(
help_text='Hostname for the server, eg. example.com',
max_length=255,
verbose_name='hostname')),
('protocol',
models.CharField(
choices=[('http', 'http'), ('https', 'https (secure)')],
default='http',
help_text=
"The protocol for the server, if unsure it's likely http",
max_length=5,
verbose_name='protocol')),
('port',
models.PositiveSmallIntegerField(
help_text='Port for this server, eg. 8000',
verbose_name='port')),
('telnet_port', models.PositiveIntegerField()),
('username',
models.CharField(default='source',
max_length=255,
verbose_name='username')),
('password',
models.CharField(max_length=255, verbose_name='password')),
('mount',
models.CharField(
help_text=
'Mount point for the upstream server, eg. /stream',
max_length=255,
verbose_name='mount point')),
('encoding',
models.CharField(choices=[
('mp3', 'MP3'), ('fdkaac', 'AAC'),
('vorbis.cbr', 'OGG Vorbis'),
('ffmpeg', 'ffmpeg (custom additional arguments needed)')
],
default='mp3',
max_length=20,
verbose_name='encoding format')),
('bitrate',
models.PositiveSmallIntegerField(
blank=True,
help_text=
'Encoding bitrate (kbits), blank for a sane default or ffmpeg.',
null=True,
verbose_name='bitrate')),
('mime',
models.CharField(
blank=True,
help_text=
'MIME format, ie audio/mpeg, leave blank for Liquidsoap to guess. (Needed for ffmpeg.)',
max_length=50,
verbose_name='MIME format')),
('encoding_args',
models.JSONField(
blank=True,
default=None,
help_text=
'Enter any additional arguments for the encoder here. Advanced use cases only, see the <a href="https://www.liquidsoap.info/doc-1.4.3/encoding_formats.html" target="_blank">Liquidsoap docs here</a> for more info. Leave empty or <code>null</code> for none.',
null=True,
verbose_name='additional arguments for encoding')),
],
options={
'ordering': ('name', ),
'unique_together': {('hostname', 'port', 'mount')},
},
),
migrations.CreateModel(
name='PlayoutLogEntry',
fields=[
('id',
models.BigAutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created',
models.DateTimeField(db_index=True,
default=django.utils.timezone.now,
verbose_name='Date')),
('event_type',
models.CharField(choices=[('track', 'Track'),
('dj', 'Live DJ'),
('general', 'General'),
('source', 'Source Transition')],
default='general',
max_length=10,
verbose_name='Type')),
('description',
common.models.TruncatingCharField(max_length=500,
verbose_name='Entry')),
('active_source',
common.models.TruncatingCharField(
default='N/A',
max_length=50,
verbose_name='Active Source')),
('audio_asset',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='autodj.audioasset')),
('broadcast_asset',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='broadcast.broadcastasset')),
('rotator_asset',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='autodj.rotatorasset')),
('user',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'playout log entry',
'verbose_name_plural': 'playout logs',
'ordering': ('-created', ),
},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0009_alter_user_last_name_max_length'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Department',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateField(auto_now_add=True, null=True)),
('modified_at', models.DateField(auto_now=True, null=True)),
('active', models.BooleanField(default=True)),
('name', models.CharField(max_length=150,
verbose_name='_Name')),
],
options={
'verbose_name':
'Department',
'verbose_name_plural':
'Departments',
'permissions': (('change_between_departments',
'Can change between Departments'), ),
},
),
migrations.CreateModel(
name='OwnerGroup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('created_at', models.DateField(auto_now_add=True, null=True)),
('modified_at', models.DateField(auto_now=True, null=True)),
('active', models.BooleanField(default=True)),
('name', models.CharField(max_length=80, verbose_name='Name')),
],
options={
'verbose_name': 'Owner group',
'verbose_name_plural': 'Owner groups',
},
),
migrations.CreateModel(
name='UserProfile',
fields=[
('created_at', models.DateField(auto_now_add=True, null=True)),
('modified_at', models.DateField(auto_now=True, null=True)),
('active', models.BooleanField(default=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
related_name='profile',
serialize=False,
to=settings.AUTH_USER_MODEL)),
('gender',
models.PositiveSmallIntegerField(blank=True,
choices=[(1, 'Male'),
(2, 'Female')],
null=True,
verbose_name='Gender')),
('avatar',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Avatar')),
('is_owner_admin', models.BooleanField(default=False)),
('email_is_verified',
models.BooleanField(default=False, editable=False)),
('forbidden_counter',
models.PositiveIntegerField(blank=True,
default=0,
editable=False)),
('department',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='members.Department')),
('group',
models.ManyToManyField(blank=True, to='members.OwnerGroup')),
('modified_by',
models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='userprofile_modified',
to=settings.AUTH_USER_MODEL)),
('owner',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'User profile',
'verbose_name_plural': 'User profiles',
},
),
migrations.AddField(
model_name='ownergroup',
name='modified_by',
field=models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='ownergroup_modified',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='ownergroup',
name='permission',
field=models.ManyToManyField(
blank=True,
limit_choices_to={
'codename__in': [
'add_userprofile', 'delete_userprofile',
'view_userprofile', 'change_userprofile',
'change_between_departments', 'add_department',
'change_department', 'view_department',
'delete_department', 'add_ownergroup',
'change_ownergroup', 'view_ownergroup',
'delete_ownergroup'
]
},
to='auth.Permission'),
),
migrations.AddField(
model_name='ownergroup',
name='user',
field=models.ForeignKey(editable=False,
on_delete=common.models.SET_OWNER,
related_name='ownergroup_created',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='department',
name='group',
field=models.ManyToManyField(blank=True, to='members.OwnerGroup'),
),
migrations.AddField(
model_name='department',
name='modified_by',
field=models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='department_modified',
to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='department',
name='user',
field=models.ForeignKey(editable=False,
on_delete=common.models.SET_OWNER,
related_name='department_created',
to=settings.AUTH_USER_MODEL),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Account',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', common.models.NameField(max_length=150, unique=True)),
('lft',
models.PositiveIntegerField(db_index=True, editable=False)),
('rght',
models.PositiveIntegerField(db_index=True, editable=False)),
('tree_id',
models.PositiveIntegerField(db_index=True, editable=False)),
('level',
models.PositiveIntegerField(db_index=True, editable=False)),
],
options={
'abstract': False,
},
),
migrations.CreateModel(
name='AccountType',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', common.models.NameField(max_length=150, unique=True)),
('children_allowed', models.BooleanField()),
('movements_allowed', models.BooleanField()),
('new_accounts_allowed', models.BooleanField()),
],
),
migrations.AddField(
model_name='account',
name='acc_type',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='accounts.AccountType'),
),
migrations.AddField(
model_name='account',
name='parent',
field=mptt.fields.TreeForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='children',
to='accounts.Account'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='Address',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('postal_code', models.CharField(max_length=10, validators=[django.core.validators.MinLengthValidator(4), common.validators.DigitValidator], verbose_name='Postal code')),
('city_name', models.CharField(max_length=15, verbose_name='City name')),
('street_name', models.CharField(max_length=20, verbose_name='Street name')),
('street_number', models.PositiveIntegerField(validators=[django.core.validators.MaxValueValidator(9999)], verbose_name='Street number')),
('additional', models.CharField(blank=True, max_length=100, null=True, verbose_name='Additional info')),
],
options={
'verbose_name': 'Address',
'verbose_name_plural': 'Addresses',
},
),
migrations.CreateModel(
name='BankAccount',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('number', models.CharField(max_length=20, validators=[django.core.validators.MinLengthValidator(5), common.validators.DigitValidator], verbose_name='Account number')),
('bank_code', models.CharField(max_length=10, validators=[django.core.validators.MinLengthValidator(4), common.validators.DigitValidator], verbose_name='Bank code')),
('bank_name', models.CharField(max_length=50, verbose_name='Bank name')),
],
options={
'verbose_name': 'Bank account',
'verbose_name_plural': 'Bank accounts',
},
),
migrations.CreateModel(
name='StreetType',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('short_name', models.CharField(max_length=5, unique=True, verbose_name='Short name')),
('short_name_en', models.CharField(max_length=5, null=True, unique=True, verbose_name='Short name')),
('short_name_uk', models.CharField(max_length=5, null=True, unique=True, verbose_name='Short name')),
('full_name', models.CharField(max_length=10, unique=True, verbose_name='Full name')),
('full_name_en', models.CharField(max_length=10, null=True, unique=True, verbose_name='Full name')),
('full_name_uk', models.CharField(max_length=10, null=True, unique=True, verbose_name='Full name')),
],
options={
'verbose_name': 'Street type',
'verbose_name_plural': 'Street types',
},
),
migrations.AlterUniqueTogether(
name='bankaccount',
unique_together=set([('number', 'bank_code')]),
),
migrations.AddField(
model_name='address',
name='street_type',
field=models.ForeignKey(default=common.models.get_default_street_type, on_delete=django.db.models.deletion.PROTECT, to='common.StreetType', verbose_name='Street type'),
),
]