django models 建表

1. 新建数据库
2. django 项目 setting 设置
   指定APP

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'cleanApp',
]

指定数据库

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': '数据库名',
        'USER': '用户名',
        'PASSWORD': '密码',
        "HOST": "127.0.0.1",
        'PORT': '3306',
    }
}

init.py 文件 指定mysql

# __init__.py
import pymysql
pymysql.install_as_MySQLdb()

3. models 文件

class k_user(models.Model):
    id = models.BigAutoField(primary_key=True)
    openid = models.CharField(unique=True, default="0", max_length=60)
    mobilephone = models.CharField(unique=True, max_length=11, blank=True, null=True)
    unionid = models.CharField(max_length=50, blank=True, null=True)
    regist_time = models.DateTimeField(blank=True, null=True)

    def __str__(self):
        return self.id

    class Meta:
        db_table = 'k_user'

4. python manage.py makemigrations
5. python manage.py migrate