503 lines
28 KiB
Dart
503 lines
28 KiB
Dart
// GENERATED CODE EDIT WITH CAUTION
|
|
// THIS FILE **WILL NOT** BE REGENERATED
|
|
// This file should be version controlled and can be manually edited.
|
|
part of 'schema.g.dart';
|
|
|
|
// While migrations are intelligently created, the difference between some commands, such as
|
|
// DropTable vs. RenameTable, cannot be determined. For this reason, please review migrations after
|
|
// they are created to ensure the correct inference was made.
|
|
|
|
// The migration version must **always** mirror the file name
|
|
|
|
const List<MigrationCommand> _migration_20260411041808_up = [
|
|
InsertTable('Announcement'),
|
|
InsertTable('AnnouncementComment'),
|
|
InsertTable('AttendanceLog'),
|
|
InsertTable('ChatMessage'),
|
|
InsertTable('DutySchedule'),
|
|
InsertTable('ItServiceRequest'),
|
|
InsertTable('ItServiceRequestAction'),
|
|
InsertTable('ItServiceRequestActivityLog'),
|
|
InsertTable('ItServiceRequestAssignment'),
|
|
InsertTable('LeaveOfAbsence'),
|
|
InsertTable('NotificationItem'),
|
|
InsertTable('Office'),
|
|
InsertTable('PassSlip'),
|
|
InsertTable('Profile'),
|
|
InsertTable('Service'),
|
|
InsertTable('SwapRequest'),
|
|
InsertTable('Task'),
|
|
InsertTable('TaskActivityLog'),
|
|
InsertTable('Team'),
|
|
InsertTable('Ticket'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('author_id', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('title', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('body', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('visible_roles', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('is_template', Column.boolean, onTable: 'Announcement'),
|
|
InsertColumn('template_id', Column.varchar, onTable: 'Announcement'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'Announcement'),
|
|
InsertColumn('updated_at', Column.datetime, onTable: 'Announcement'),
|
|
InsertColumn('banner_enabled', Column.boolean, onTable: 'Announcement'),
|
|
InsertColumn('banner_show_at', Column.datetime, onTable: 'Announcement'),
|
|
InsertColumn('banner_hide_at', Column.datetime, onTable: 'Announcement'),
|
|
InsertColumn('push_interval_minutes', Column.integer, onTable: 'Announcement'),
|
|
InsertColumn('is_banner_active', Column.boolean, onTable: 'Announcement'),
|
|
InsertColumn('hash_code', Column.integer, onTable: 'Announcement'),
|
|
InsertColumn('id', Column.varchar, onTable: 'AnnouncementComment'),
|
|
InsertColumn('announcement_id', Column.varchar, onTable: 'AnnouncementComment'),
|
|
InsertColumn('author_id', Column.varchar, onTable: 'AnnouncementComment'),
|
|
InsertColumn('body', Column.varchar, onTable: 'AnnouncementComment'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'AnnouncementComment'),
|
|
InsertColumn('hash_code', Column.integer, onTable: 'AnnouncementComment'),
|
|
InsertColumn('id', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('duty_schedule_id', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('shift_type', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_in_at', Column.datetime, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_in_lat', Column.Double, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_in_lng', Column.Double, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_out_at', Column.datetime, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_out_lat', Column.Double, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_out_lng', Column.Double, onTable: 'AttendanceLog'),
|
|
InsertColumn('justification', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_out_justification', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('verification_status', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_in_verification_photo_url', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('check_out_verification_photo_url', Column.varchar, onTable: 'AttendanceLog'),
|
|
InsertColumn('is_checked_out', Column.boolean, onTable: 'AttendanceLog'),
|
|
InsertColumn('is_verified', Column.boolean, onTable: 'AttendanceLog'),
|
|
InsertColumn('is_unverified', Column.boolean, onTable: 'AttendanceLog'),
|
|
InsertColumn('id', Column.varchar, onTable: 'ChatMessage'),
|
|
InsertColumn('thread_id', Column.varchar, onTable: 'ChatMessage'),
|
|
InsertColumn('sender_id', Column.varchar, onTable: 'ChatMessage'),
|
|
InsertColumn('body', Column.varchar, onTable: 'ChatMessage'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'ChatMessage'),
|
|
InsertColumn('id', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('shift_type', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('start_time', Column.datetime, onTable: 'DutySchedule'),
|
|
InsertColumn('end_time', Column.datetime, onTable: 'DutySchedule'),
|
|
InsertColumn('status', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'DutySchedule'),
|
|
InsertColumn('check_in_at', Column.datetime, onTable: 'DutySchedule'),
|
|
InsertColumn('reliever_ids', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('swap_request_id', Column.varchar, onTable: 'DutySchedule'),
|
|
InsertColumn('id', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('request_number', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('services', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('services_other', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('event_name', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('event_details', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('event_date', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('event_end_date', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('dry_run_date', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('dry_run_end_date', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('contact_person', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('contact_number', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('remarks', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('office_id', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('requested_by', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('requested_by_user_id', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('approved_by', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('approved_by_user_id', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('approved_at', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('status', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('outside_premise_allowed', Column.boolean, onTable: 'ItServiceRequest'),
|
|
InsertColumn('cancellation_reason', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('cancelled_at', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('creator_id', Column.varchar, onTable: 'ItServiceRequest'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('updated_at', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('completed_at', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('date_time_received', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('date_time_checked', Column.datetime, onTable: 'ItServiceRequest'),
|
|
InsertColumn('hash_code', Column.integer, onTable: 'ItServiceRequest'),
|
|
InsertColumn('id', Column.varchar, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('request_id', Column.varchar, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('action_taken', Column.varchar, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('updated_at', Column.datetime, onTable: 'ItServiceRequestAction'),
|
|
InsertColumn('id', Column.varchar, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('request_id', Column.varchar, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('actor_id', Column.varchar, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('action_type', Column.varchar, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('meta', Column.varchar, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'ItServiceRequestActivityLog'),
|
|
InsertColumn('id', Column.varchar, onTable: 'ItServiceRequestAssignment'),
|
|
InsertColumn('request_id', Column.varchar, onTable: 'ItServiceRequestAssignment'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'ItServiceRequestAssignment'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'ItServiceRequestAssignment'),
|
|
InsertColumn('id', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('leave_type', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('justification', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('start_time', Column.datetime, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('end_time', Column.datetime, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('status', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('filed_by', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('leave_type_label', Column.varchar, onTable: 'LeaveOfAbsence'),
|
|
InsertColumn('id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('actor_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('ticket_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('task_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('leave_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('pass_slip_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('it_service_request_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('announcement_id', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('message_id', Column.integer, onTable: 'NotificationItem'),
|
|
InsertColumn('type', Column.varchar, onTable: 'NotificationItem'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'NotificationItem'),
|
|
InsertColumn('read_at', Column.datetime, onTable: 'NotificationItem'),
|
|
InsertColumn('is_unread', Column.boolean, onTable: 'NotificationItem'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Office'),
|
|
InsertColumn('name', Column.varchar, onTable: 'Office'),
|
|
InsertColumn('service_id', Column.varchar, onTable: 'Office'),
|
|
InsertColumn('id', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('user_id', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('duty_schedule_id', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('reason', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('status', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('requested_at', Column.datetime, onTable: 'PassSlip'),
|
|
InsertColumn('approved_by', Column.varchar, onTable: 'PassSlip'),
|
|
InsertColumn('approved_at', Column.datetime, onTable: 'PassSlip'),
|
|
InsertColumn('slip_start', Column.datetime, onTable: 'PassSlip'),
|
|
InsertColumn('slip_end', Column.datetime, onTable: 'PassSlip'),
|
|
InsertColumn('requested_start', Column.datetime, onTable: 'PassSlip'),
|
|
InsertColumn('is_active', Column.boolean, onTable: 'PassSlip'),
|
|
InsertColumn('is_exceeded', Column.boolean, onTable: 'PassSlip'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('role', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('full_name', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('religion', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('allow_tracking', Column.boolean, onTable: 'Profile'),
|
|
InsertColumn('avatar_url', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('face_photo_url', Column.varchar, onTable: 'Profile'),
|
|
InsertColumn('face_enrolled_at', Column.datetime, onTable: 'Profile'),
|
|
InsertColumn('has_face_enrolled', Column.boolean, onTable: 'Profile'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Service'),
|
|
InsertColumn('name', Column.varchar, onTable: 'Service'),
|
|
InsertColumn('id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('requester_id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('recipient_id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('requester_schedule_id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('target_schedule_id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('status', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'SwapRequest'),
|
|
InsertColumn('updated_at', Column.datetime, onTable: 'SwapRequest'),
|
|
InsertColumn('chat_thread_id', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('shift_type', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('shift_start_time', Column.datetime, onTable: 'SwapRequest'),
|
|
InsertColumn('reliever_ids', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('approved_by', Column.varchar, onTable: 'SwapRequest'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('ticket_id', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('task_number', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('title', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('description', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('office_id', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('status', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('priority', Column.integer, onTable: 'Task'),
|
|
InsertColumn('queue_order', Column.integer, onTable: 'Task'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'Task'),
|
|
InsertColumn('creator_id', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('started_at', Column.datetime, onTable: 'Task'),
|
|
InsertColumn('completed_at', Column.datetime, onTable: 'Task'),
|
|
InsertColumn('requested_by', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('noted_by', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('received_by', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('request_type', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('request_type_other', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('request_category', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('action_taken', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('cancellation_reason', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('cancelled_at', Column.datetime, onTable: 'Task'),
|
|
InsertColumn('it_job_printed', Column.boolean, onTable: 'Task'),
|
|
InsertColumn('it_job_printed_at', Column.datetime, onTable: 'Task'),
|
|
InsertColumn('it_job_received_by_id', Column.varchar, onTable: 'Task'),
|
|
InsertColumn('hash_code', Column.integer, onTable: 'Task'),
|
|
InsertColumn('has_incomplete_details', Column.boolean, onTable: 'Task'),
|
|
InsertColumn('id', Column.varchar, onTable: 'TaskActivityLog'),
|
|
InsertColumn('task_id', Column.varchar, onTable: 'TaskActivityLog'),
|
|
InsertColumn('actor_id', Column.varchar, onTable: 'TaskActivityLog'),
|
|
InsertColumn('action_type', Column.varchar, onTable: 'TaskActivityLog'),
|
|
InsertColumn('meta', Column.varchar, onTable: 'TaskActivityLog'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'TaskActivityLog'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Team'),
|
|
InsertColumn('name', Column.varchar, onTable: 'Team'),
|
|
InsertColumn('leader_id', Column.varchar, onTable: 'Team'),
|
|
InsertColumn('office_ids', Column.varchar, onTable: 'Team'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'Team'),
|
|
InsertColumn('color', Column.varchar, onTable: 'Team'),
|
|
InsertColumn('id', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('subject', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('description', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('office_id', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('status', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('created_at', Column.datetime, onTable: 'Ticket'),
|
|
InsertColumn('creator_id', Column.varchar, onTable: 'Ticket'),
|
|
InsertColumn('responded_at', Column.datetime, onTable: 'Ticket'),
|
|
InsertColumn('promoted_at', Column.datetime, onTable: 'Ticket'),
|
|
InsertColumn('closed_at', Column.datetime, onTable: 'Ticket'),
|
|
InsertColumn('hash_code', Column.integer, onTable: 'Ticket')
|
|
];
|
|
|
|
const List<MigrationCommand> _migration_20260411041808_down = [
|
|
DropTable('Announcement'),
|
|
DropTable('AnnouncementComment'),
|
|
DropTable('AttendanceLog'),
|
|
DropTable('ChatMessage'),
|
|
DropTable('DutySchedule'),
|
|
DropTable('ItServiceRequest'),
|
|
DropTable('ItServiceRequestAction'),
|
|
DropTable('ItServiceRequestActivityLog'),
|
|
DropTable('ItServiceRequestAssignment'),
|
|
DropTable('LeaveOfAbsence'),
|
|
DropTable('NotificationItem'),
|
|
DropTable('Office'),
|
|
DropTable('PassSlip'),
|
|
DropTable('Profile'),
|
|
DropTable('Service'),
|
|
DropTable('SwapRequest'),
|
|
DropTable('Task'),
|
|
DropTable('TaskActivityLog'),
|
|
DropTable('Team'),
|
|
DropTable('Ticket'),
|
|
DropColumn('id', onTable: 'Announcement'),
|
|
DropColumn('author_id', onTable: 'Announcement'),
|
|
DropColumn('title', onTable: 'Announcement'),
|
|
DropColumn('body', onTable: 'Announcement'),
|
|
DropColumn('visible_roles', onTable: 'Announcement'),
|
|
DropColumn('is_template', onTable: 'Announcement'),
|
|
DropColumn('template_id', onTable: 'Announcement'),
|
|
DropColumn('created_at', onTable: 'Announcement'),
|
|
DropColumn('updated_at', onTable: 'Announcement'),
|
|
DropColumn('banner_enabled', onTable: 'Announcement'),
|
|
DropColumn('banner_show_at', onTable: 'Announcement'),
|
|
DropColumn('banner_hide_at', onTable: 'Announcement'),
|
|
DropColumn('push_interval_minutes', onTable: 'Announcement'),
|
|
DropColumn('is_banner_active', onTable: 'Announcement'),
|
|
DropColumn('hash_code', onTable: 'Announcement'),
|
|
DropColumn('id', onTable: 'AnnouncementComment'),
|
|
DropColumn('announcement_id', onTable: 'AnnouncementComment'),
|
|
DropColumn('author_id', onTable: 'AnnouncementComment'),
|
|
DropColumn('body', onTable: 'AnnouncementComment'),
|
|
DropColumn('created_at', onTable: 'AnnouncementComment'),
|
|
DropColumn('hash_code', onTable: 'AnnouncementComment'),
|
|
DropColumn('id', onTable: 'AttendanceLog'),
|
|
DropColumn('user_id', onTable: 'AttendanceLog'),
|
|
DropColumn('duty_schedule_id', onTable: 'AttendanceLog'),
|
|
DropColumn('shift_type', onTable: 'AttendanceLog'),
|
|
DropColumn('check_in_at', onTable: 'AttendanceLog'),
|
|
DropColumn('check_in_lat', onTable: 'AttendanceLog'),
|
|
DropColumn('check_in_lng', onTable: 'AttendanceLog'),
|
|
DropColumn('check_out_at', onTable: 'AttendanceLog'),
|
|
DropColumn('check_out_lat', onTable: 'AttendanceLog'),
|
|
DropColumn('check_out_lng', onTable: 'AttendanceLog'),
|
|
DropColumn('justification', onTable: 'AttendanceLog'),
|
|
DropColumn('check_out_justification', onTable: 'AttendanceLog'),
|
|
DropColumn('verification_status', onTable: 'AttendanceLog'),
|
|
DropColumn('check_in_verification_photo_url', onTable: 'AttendanceLog'),
|
|
DropColumn('check_out_verification_photo_url', onTable: 'AttendanceLog'),
|
|
DropColumn('is_checked_out', onTable: 'AttendanceLog'),
|
|
DropColumn('is_verified', onTable: 'AttendanceLog'),
|
|
DropColumn('is_unverified', onTable: 'AttendanceLog'),
|
|
DropColumn('id', onTable: 'ChatMessage'),
|
|
DropColumn('thread_id', onTable: 'ChatMessage'),
|
|
DropColumn('sender_id', onTable: 'ChatMessage'),
|
|
DropColumn('body', onTable: 'ChatMessage'),
|
|
DropColumn('created_at', onTable: 'ChatMessage'),
|
|
DropColumn('id', onTable: 'DutySchedule'),
|
|
DropColumn('user_id', onTable: 'DutySchedule'),
|
|
DropColumn('shift_type', onTable: 'DutySchedule'),
|
|
DropColumn('start_time', onTable: 'DutySchedule'),
|
|
DropColumn('end_time', onTable: 'DutySchedule'),
|
|
DropColumn('status', onTable: 'DutySchedule'),
|
|
DropColumn('created_at', onTable: 'DutySchedule'),
|
|
DropColumn('check_in_at', onTable: 'DutySchedule'),
|
|
DropColumn('reliever_ids', onTable: 'DutySchedule'),
|
|
DropColumn('swap_request_id', onTable: 'DutySchedule'),
|
|
DropColumn('id', onTable: 'ItServiceRequest'),
|
|
DropColumn('request_number', onTable: 'ItServiceRequest'),
|
|
DropColumn('services', onTable: 'ItServiceRequest'),
|
|
DropColumn('services_other', onTable: 'ItServiceRequest'),
|
|
DropColumn('event_name', onTable: 'ItServiceRequest'),
|
|
DropColumn('event_details', onTable: 'ItServiceRequest'),
|
|
DropColumn('event_date', onTable: 'ItServiceRequest'),
|
|
DropColumn('event_end_date', onTable: 'ItServiceRequest'),
|
|
DropColumn('dry_run_date', onTable: 'ItServiceRequest'),
|
|
DropColumn('dry_run_end_date', onTable: 'ItServiceRequest'),
|
|
DropColumn('contact_person', onTable: 'ItServiceRequest'),
|
|
DropColumn('contact_number', onTable: 'ItServiceRequest'),
|
|
DropColumn('remarks', onTable: 'ItServiceRequest'),
|
|
DropColumn('office_id', onTable: 'ItServiceRequest'),
|
|
DropColumn('requested_by', onTable: 'ItServiceRequest'),
|
|
DropColumn('requested_by_user_id', onTable: 'ItServiceRequest'),
|
|
DropColumn('approved_by', onTable: 'ItServiceRequest'),
|
|
DropColumn('approved_by_user_id', onTable: 'ItServiceRequest'),
|
|
DropColumn('approved_at', onTable: 'ItServiceRequest'),
|
|
DropColumn('status', onTable: 'ItServiceRequest'),
|
|
DropColumn('outside_premise_allowed', onTable: 'ItServiceRequest'),
|
|
DropColumn('cancellation_reason', onTable: 'ItServiceRequest'),
|
|
DropColumn('cancelled_at', onTable: 'ItServiceRequest'),
|
|
DropColumn('creator_id', onTable: 'ItServiceRequest'),
|
|
DropColumn('created_at', onTable: 'ItServiceRequest'),
|
|
DropColumn('updated_at', onTable: 'ItServiceRequest'),
|
|
DropColumn('completed_at', onTable: 'ItServiceRequest'),
|
|
DropColumn('date_time_received', onTable: 'ItServiceRequest'),
|
|
DropColumn('date_time_checked', onTable: 'ItServiceRequest'),
|
|
DropColumn('hash_code', onTable: 'ItServiceRequest'),
|
|
DropColumn('id', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('request_id', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('user_id', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('action_taken', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('created_at', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('updated_at', onTable: 'ItServiceRequestAction'),
|
|
DropColumn('id', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('request_id', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('actor_id', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('action_type', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('meta', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('created_at', onTable: 'ItServiceRequestActivityLog'),
|
|
DropColumn('id', onTable: 'ItServiceRequestAssignment'),
|
|
DropColumn('request_id', onTable: 'ItServiceRequestAssignment'),
|
|
DropColumn('user_id', onTable: 'ItServiceRequestAssignment'),
|
|
DropColumn('created_at', onTable: 'ItServiceRequestAssignment'),
|
|
DropColumn('id', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('user_id', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('leave_type', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('justification', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('start_time', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('end_time', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('status', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('filed_by', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('created_at', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('leave_type_label', onTable: 'LeaveOfAbsence'),
|
|
DropColumn('id', onTable: 'NotificationItem'),
|
|
DropColumn('user_id', onTable: 'NotificationItem'),
|
|
DropColumn('actor_id', onTable: 'NotificationItem'),
|
|
DropColumn('ticket_id', onTable: 'NotificationItem'),
|
|
DropColumn('task_id', onTable: 'NotificationItem'),
|
|
DropColumn('leave_id', onTable: 'NotificationItem'),
|
|
DropColumn('pass_slip_id', onTable: 'NotificationItem'),
|
|
DropColumn('it_service_request_id', onTable: 'NotificationItem'),
|
|
DropColumn('announcement_id', onTable: 'NotificationItem'),
|
|
DropColumn('message_id', onTable: 'NotificationItem'),
|
|
DropColumn('type', onTable: 'NotificationItem'),
|
|
DropColumn('created_at', onTable: 'NotificationItem'),
|
|
DropColumn('read_at', onTable: 'NotificationItem'),
|
|
DropColumn('is_unread', onTable: 'NotificationItem'),
|
|
DropColumn('id', onTable: 'Office'),
|
|
DropColumn('name', onTable: 'Office'),
|
|
DropColumn('service_id', onTable: 'Office'),
|
|
DropColumn('id', onTable: 'PassSlip'),
|
|
DropColumn('user_id', onTable: 'PassSlip'),
|
|
DropColumn('duty_schedule_id', onTable: 'PassSlip'),
|
|
DropColumn('reason', onTable: 'PassSlip'),
|
|
DropColumn('status', onTable: 'PassSlip'),
|
|
DropColumn('requested_at', onTable: 'PassSlip'),
|
|
DropColumn('approved_by', onTable: 'PassSlip'),
|
|
DropColumn('approved_at', onTable: 'PassSlip'),
|
|
DropColumn('slip_start', onTable: 'PassSlip'),
|
|
DropColumn('slip_end', onTable: 'PassSlip'),
|
|
DropColumn('requested_start', onTable: 'PassSlip'),
|
|
DropColumn('is_active', onTable: 'PassSlip'),
|
|
DropColumn('is_exceeded', onTable: 'PassSlip'),
|
|
DropColumn('id', onTable: 'Profile'),
|
|
DropColumn('role', onTable: 'Profile'),
|
|
DropColumn('full_name', onTable: 'Profile'),
|
|
DropColumn('religion', onTable: 'Profile'),
|
|
DropColumn('allow_tracking', onTable: 'Profile'),
|
|
DropColumn('avatar_url', onTable: 'Profile'),
|
|
DropColumn('face_photo_url', onTable: 'Profile'),
|
|
DropColumn('face_enrolled_at', onTable: 'Profile'),
|
|
DropColumn('has_face_enrolled', onTable: 'Profile'),
|
|
DropColumn('id', onTable: 'Service'),
|
|
DropColumn('name', onTable: 'Service'),
|
|
DropColumn('id', onTable: 'SwapRequest'),
|
|
DropColumn('requester_id', onTable: 'SwapRequest'),
|
|
DropColumn('recipient_id', onTable: 'SwapRequest'),
|
|
DropColumn('requester_schedule_id', onTable: 'SwapRequest'),
|
|
DropColumn('target_schedule_id', onTable: 'SwapRequest'),
|
|
DropColumn('status', onTable: 'SwapRequest'),
|
|
DropColumn('created_at', onTable: 'SwapRequest'),
|
|
DropColumn('updated_at', onTable: 'SwapRequest'),
|
|
DropColumn('chat_thread_id', onTable: 'SwapRequest'),
|
|
DropColumn('shift_type', onTable: 'SwapRequest'),
|
|
DropColumn('shift_start_time', onTable: 'SwapRequest'),
|
|
DropColumn('reliever_ids', onTable: 'SwapRequest'),
|
|
DropColumn('approved_by', onTable: 'SwapRequest'),
|
|
DropColumn('id', onTable: 'Task'),
|
|
DropColumn('ticket_id', onTable: 'Task'),
|
|
DropColumn('task_number', onTable: 'Task'),
|
|
DropColumn('title', onTable: 'Task'),
|
|
DropColumn('description', onTable: 'Task'),
|
|
DropColumn('office_id', onTable: 'Task'),
|
|
DropColumn('status', onTable: 'Task'),
|
|
DropColumn('priority', onTable: 'Task'),
|
|
DropColumn('queue_order', onTable: 'Task'),
|
|
DropColumn('created_at', onTable: 'Task'),
|
|
DropColumn('creator_id', onTable: 'Task'),
|
|
DropColumn('started_at', onTable: 'Task'),
|
|
DropColumn('completed_at', onTable: 'Task'),
|
|
DropColumn('requested_by', onTable: 'Task'),
|
|
DropColumn('noted_by', onTable: 'Task'),
|
|
DropColumn('received_by', onTable: 'Task'),
|
|
DropColumn('request_type', onTable: 'Task'),
|
|
DropColumn('request_type_other', onTable: 'Task'),
|
|
DropColumn('request_category', onTable: 'Task'),
|
|
DropColumn('action_taken', onTable: 'Task'),
|
|
DropColumn('cancellation_reason', onTable: 'Task'),
|
|
DropColumn('cancelled_at', onTable: 'Task'),
|
|
DropColumn('it_job_printed', onTable: 'Task'),
|
|
DropColumn('it_job_printed_at', onTable: 'Task'),
|
|
DropColumn('it_job_received_by_id', onTable: 'Task'),
|
|
DropColumn('hash_code', onTable: 'Task'),
|
|
DropColumn('has_incomplete_details', onTable: 'Task'),
|
|
DropColumn('id', onTable: 'TaskActivityLog'),
|
|
DropColumn('task_id', onTable: 'TaskActivityLog'),
|
|
DropColumn('actor_id', onTable: 'TaskActivityLog'),
|
|
DropColumn('action_type', onTable: 'TaskActivityLog'),
|
|
DropColumn('meta', onTable: 'TaskActivityLog'),
|
|
DropColumn('created_at', onTable: 'TaskActivityLog'),
|
|
DropColumn('id', onTable: 'Team'),
|
|
DropColumn('name', onTable: 'Team'),
|
|
DropColumn('leader_id', onTable: 'Team'),
|
|
DropColumn('office_ids', onTable: 'Team'),
|
|
DropColumn('created_at', onTable: 'Team'),
|
|
DropColumn('color', onTable: 'Team'),
|
|
DropColumn('id', onTable: 'Ticket'),
|
|
DropColumn('subject', onTable: 'Ticket'),
|
|
DropColumn('description', onTable: 'Ticket'),
|
|
DropColumn('office_id', onTable: 'Ticket'),
|
|
DropColumn('status', onTable: 'Ticket'),
|
|
DropColumn('created_at', onTable: 'Ticket'),
|
|
DropColumn('creator_id', onTable: 'Ticket'),
|
|
DropColumn('responded_at', onTable: 'Ticket'),
|
|
DropColumn('promoted_at', onTable: 'Ticket'),
|
|
DropColumn('closed_at', onTable: 'Ticket'),
|
|
DropColumn('hash_code', onTable: 'Ticket')
|
|
];
|
|
|
|
//
|
|
// DO NOT EDIT BELOW THIS LINE
|
|
//
|
|
|
|
@Migratable(
|
|
version: '20260411041808',
|
|
up: _migration_20260411041808_up,
|
|
down: _migration_20260411041808_down,
|
|
)
|
|
class Migration20260411041808 extends Migration {
|
|
const Migration20260411041808()
|
|
: super(
|
|
version: 20260411041808,
|
|
up: _migration_20260411041808_up,
|
|
down: _migration_20260411041808_down,
|
|
);
|
|
}
|