# Generated by Django 5.2.4 on 2026-06-08 10:43 from django.db import migrations, models class Migration(migrations.Migration): dependencies = [ ('api', '0071_userschedulingpreference'), ] operations = [ migrations.CreateModel( name='EmxTtActivityFinal', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=150)), ('name', models.CharField(max_length=255)), ('desc', models.TextField(null=True)), ('activity_type_code', models.CharField(max_length=255, null=True)), ('group_id', models.IntegerField(db_comment='follow activity name the last number eg. Activity/1, will get the 1', null=True)), ('module_code', models.CharField(max_length=255, null=True)), ('scheduled_day', models.CharField(db_comment="Client request send by String 'Monday'", max_length=100, null=True)), ('duration', models.IntegerField(db_comment='in minute', null=True)), ('start_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('end_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('planned_size', models.IntegerField(null=True)), ('record_state', models.CharField(db_comment='U - update/create, D - Delete', max_length=100)), ], options={ 'db_table': 'emx_tt_activity_final', }, ), migrations.CreateModel( name='EmxTtActivityHistory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=150)), ('name', models.CharField(max_length=255)), ('desc', models.TextField(null=True)), ('activity_type_code', models.CharField(max_length=255, null=True)), ('group_id', models.IntegerField(db_comment='follow activity name the last number eg. Activity/1, will get the 1', null=True)), ('module_code', models.CharField(max_length=255, null=True)), ('scheduled_day', models.CharField(db_comment="Client request send by String 'Monday'", max_length=100, null=True)), ('duration', models.IntegerField(db_comment='in minute', null=True)), ('start_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('end_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('planned_size', models.IntegerField(null=True)), ('record_state', models.CharField(db_comment='U - update/create, D - Delete', max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True, null=True)), ], options={ 'db_table': 'emx_tt_activity_history', }, ), migrations.CreateModel( name='EmxTtActivityLast', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=150)), ('name', models.CharField(max_length=255)), ('desc', models.TextField(null=True)), ('activity_type_code', models.CharField(max_length=255, null=True)), ('group_id', models.IntegerField(db_comment='follow activity name the last number eg. Activity/1, will get the 1', null=True)), ('module_code', models.CharField(max_length=255, null=True)), ('scheduled_day', models.CharField(db_comment="Client request send by String 'Monday'", max_length=100, null=True)), ('duration', models.IntegerField(db_comment='in minute', null=True)), ('start_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('end_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('planned_size', models.IntegerField(null=True)), ('check_sum', models.TextField(db_comment='used to compare see got update or not', null=True)), ], options={ 'db_table': 'emx_tt_activity_last', }, ), migrations.CreateModel( name='EmxTtActivityStatic', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('code', models.CharField(max_length=150)), ('name', models.CharField(max_length=255)), ('desc', models.TextField(null=True)), ('activity_type_code', models.CharField(max_length=255, null=True)), ('group_id', models.IntegerField(db_comment='follow activity name the last number eg. Activity/1, will get the 1', null=True)), ('module_code', models.CharField(max_length=255, null=True)), ('scheduled_day', models.CharField(db_comment="Client request send by String 'Monday'", max_length=100, null=True)), ('duration', models.IntegerField(db_comment='in minute', null=True)), ('start_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('end_time', models.TextField(db_comment='client request in datetime format(6/6/2026 12:00:00 PM) so using text field, date just put today date', null=True)), ('planned_size', models.IntegerField(null=True)), ('check_sum', models.TextField(db_comment='used to compare see got update or not', null=True)), ], options={ 'db_table': 'emx_tt_activity_static', }, ), migrations.RunSQL( # need the default value for created_at for history sql=""" ALTER TABLE emx_tt_activity_history ALTER COLUMN created_at SET DEFAULT now(); """, reverse_sql=""" ALTER TABLE emx_tt_activity_history ALTER COLUMN created_at DROP DEFAULT; """, ), ]