数据库设计 01

django APP 设计

开发环境 python2.7  django 1.9 pycharm 2018

1、创建虚拟环境

pip install mkvirtualenv mxonline

在(mxonline) C:\Users\yuanhua> 下安装django==1.9

新建项目

安装mysql-python 驱动

配置setting--databases

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mxonline',
        'USER': "root",
        'PASSWORD': "root",
        'HOST': "127.0.0.1"
    }
}

tool工具

makemigrations 

migrate 生成数据表

2、生成user APP

manage.py@MxOnline > startapp users

设计user models.py

from django.contrib.auth.models import AbstractUser

# Create your models here.


class UserProfile(AbstractUser):
    nick_name = models.CharField(max_length=50, verbose_name=u"昵称", default="")
    birthday = models.DateField(verbose_name=u"生日", null=True, blank=True)
    gender = models.CharField(max_length=5, choices=(("male", u"男"), ("female", u"女")), default="female")
    address = models.CharField(max_length=100, default=u"")
    mobile = models.CharField(max_length=11, null=True, blank=True)
    image = models.ImageField(upload_to="image/%Y/%M", default=u"image/default.png", max_length=100)

    class Meta:
        verbose_name = "用户信息"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.username

setting.py 添加app

'users'
]

AUTH_USER_MODEL = "users.UserProfile"