39 lines
1.4 KiB
Python
39 lines
1.4 KiB
Python
|
# Generated manually for performance optimization
|
||
|
|
|
||
|
|
from django.db import migrations, models
|
||
|
|
|
||
|
|
|
||
|
|
class Migration(migrations.Migration):
|
||
|
|
|
||
|
|
dependencies = [
|
||
|
|
('B_main', '0012_alter_person_가입일시'),
|
||
|
|
]
|
||
|
|
|
||
|
|
operations = [
|
||
|
|
# 검색 성능 향상을 위한 인덱스 추가
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_name ON B_main_person (이름);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_name;"
|
||
|
|
),
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_소속 ON B_main_person (소속);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_소속;"
|
||
|
|
),
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_직책 ON B_main_person (직책);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_직책;"
|
||
|
|
),
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_keyword1 ON B_main_person (keyword1);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_keyword1;"
|
||
|
|
),
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_sequence ON B_main_person (SEQUENCE);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_sequence;"
|
||
|
|
),
|
||
|
|
migrations.RunSQL(
|
||
|
|
"CREATE INDEX IF NOT EXISTS idx_person_user ON B_main_person (user_id);",
|
||
|
|
reverse_sql="DROP INDEX IF EXISTS idx_person_user;"
|
||
|
|
),
|
||
|
|
]
|