74 lines
4.2 KiB
Python
74 lines
4.2 KiB
Python
# Generated by Django 5.2.12 on 2026-09-06 16:34
|
|
|
|
import django.db.models.deletion
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='Tenant',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('code', models.SlugField(help_text='租户代码（小写字母数字）', max_length=64, unique=True)),
|
|
('name', models.CharField(help_text='租户名称（公司/品牌名）', max_length=128)),
|
|
('contact', models.CharField(blank=True, default='', max_length=64)),
|
|
('phone', models.CharField(blank=True, default='', max_length=32)),
|
|
('is_active', models.BooleanField(default=True)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
],
|
|
options={
|
|
'db_table': 'core_tenant',
|
|
'ordering': ['code'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Org',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('code', models.CharField(help_text='组织代码（在租户内唯一）', max_length=64)),
|
|
('name', models.CharField(max_length=128)),
|
|
('org_path', models.CharField(blank=True, default='', help_text='组织层级路径，如 0001.0002.0003；用于快速子树查询', max_length=255)),
|
|
('is_active', models.BooleanField(default=True)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='children', to='core.org')),
|
|
('tenant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='orgs', to='core.tenant')),
|
|
],
|
|
options={
|
|
'db_table': 'core_org',
|
|
'ordering': ['org_path', 'code'],
|
|
'unique_together': {('tenant', 'code')},
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='AuditLog',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('action', models.CharField(choices=[('create', '创建'), ('update', '更新'), ('delete', '删除'), ('view', '查看'), ('login', '登录'), ('logout', '登出'), ('export', '导出')], max_length=16)),
|
|
('target_type', models.CharField(help_text='目标模型名，如 SalesOrder', max_length=64)),
|
|
('target_id', models.CharField(blank=True, default='', max_length=64)),
|
|
('detail', models.JSONField(blank=True, default=dict, help_text='操作详情 JSON')),
|
|
('ip', models.GenericIPAddressField(blank=True, null=True)),
|
|
('user_agent', models.CharField(blank=True, default='', max_length=255)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='audit_logs', to=settings.AUTH_USER_MODEL)),
|
|
('tenant', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='audit_logs', to='core.tenant')),
|
|
],
|
|
options={
|
|
'db_table': 'core_audit_log',
|
|
'ordering': ['-created_at'],
|
|
'indexes': [models.Index(fields=['tenant', '-created_at'], name='core_audit__tenant__985477_idx'), models.Index(fields=['target_type', 'target_id'], name='core_audit__target__fd0ddd_idx'), models.Index(fields=['user', '-created_at'], name='core_audit__user_id_465bdf_idx')],
|
|
},
|
|
),
|
|
]
|