#GNUBOARD MODELS // DO NOT TOUCH!
class G5Member(AbstractBaseUser):
    mb_no = models.AutoField(primary_key=True)
    mb_name = models.CharField(max_length=255)
    mb_nick_date = models.DateField()
    email = models.CharField(max_length=255, db_column='mb_email', null=True)
    mb_homepage = models.CharField(max_length=255, null=True)
    mb_level = models.IntegerField()
    mb_sex = models.CharField(max_length=1, null=True)
    mb_birth = models.CharField(max_length=255, null=True)
    mb_tel = models.CharField(max_length=255, null=True)
    mb_hp = models.CharField(max_length=255, null=True)
    mb_certify = models.CharField(max_length=20, null=True)
    mb_adult = models.IntegerField(null=True)
    mb_dupinfo = models.CharField(max_length=255, null=True)
    mb_zip1 = models.CharField(max_length=3, null=True)
    mb_zip2 = models.CharField(max_length=3, null=True)
    mb_addr1 = models.CharField(max_length=255, null=True)
    mb_addr2 = models.CharField(max_length=255, null=True)
    mb_addr3 = models.CharField(max_length=255, null=True)
    mb_addr_jibeon = models.CharField(max_length=255, null=True)
    mb_signature = models.TextField(null=True)
    mb_recommend = models.CharField(max_length=255, null=True)
    mb_point = models.IntegerField(null=True)
    mb_login_ip = models.CharField(max_length=255, null=True)
    mb_datetime = models.DateTimeField(null=True)
    mb_ip = models.CharField(max_length=255, null=True)
    mb_leave_date = models.CharField(max_length=8, null=True)
    mb_intercept_date = models.CharField(max_length=8, null=True)
    mb_email_certify = models.DateTimeField(null=True)
    mb_memo = models.TextField(null=True)
    mb_lost_certify = models.CharField(max_length=255, null=True)
    mb_mailling = models.IntegerField(null=True)
    mb_sms = models.IntegerField(null=True)
    mb_open = models.IntegerField(null=True)
    mb_open_date = models.DateField(null=True)
    mb_profile = models.TextField(null=True)
    mb_memo_call = models.CharField(max_length=255, null=True)
    mb_1 = models.CharField(max_length=255, null=True)
    mb_2 = models.CharField(max_length=255, null=True)
    mb_3 = models.CharField(max_length=255, null=True)
    mb_4 = models.CharField(max_length=255, null=True)
    mb_5 = models.CharField(max_length=255, null=True)
    mb_6 = models.CharField(max_length=255, null=True)
    mb_7 = models.CharField(max_length=255, null=True)
    mb_8 = models.CharField(max_length=255, null=True)
    mb_id = models.CharField(unique=True, max_length=20)
    password = models.CharField(max_length=255, db_column='mb_password')
    last_login = models.DateTimeField(db_column='mb_today_login', null=True)
    username = models.CharField(max_length=255, db_column='mb_nick', null=True)

    #is_superuser=True
    #is_staff=True



    USERNAME_FIELD = 'mb_id'
    REQUIRED_FIELDS = ['mb_level','email','username']

    def get_username(self):
        return self.mb_id

    def has_perm(self, perm, obj=None):
        return self.is_superuser()

    def has_module_perms(self, app_label):
        return self.is_superuser()

    def get_short_name(self):
        return self.username


    def is_superuser(self):
        if self.mb_level == 10:
            return True
        else:
            return False

    def is_staff(self):
        if self.mb_level == 10:
            return True
        else:
            return False


    class UserManager(BaseUserManager):
        use_in_migrations = True

        def _create_user(self, username, email, password, **extra_fields):
            """
            Creates and saves a User with the given username, email and password.
            """
            if not username:
                raise ValueError('The given username must be set')
            email = self.normalize_email(email)
            username = self.model.normalize_username(username)
            user = self.model(email=email, username=username)
            user.set_password(password)
            user.save(using=self._db)
            return user

        def create_user(self, username, email=None, password=None, **extra_fields):
            extra_fields.setdefault('is_staff', False)
            extra_fields.setdefault('is_superuser', False)
            return self._create_user(username, email, password, **extra_fields)

        def create_superuser(self, username, email, password, **extra_fields):
            extra_fields.setdefault('is_staff', True)
            extra_fields.setdefault('is_superuser', True)

            if extra_fields.get('is_staff') is not True:
                raise ValueError('Superuser must have is_staff=True.')
            if extra_fields.get('is_superuser') is not True:
                raise ValueError('Superuser must have is_superuser=True.')

            return self._create_user(username, email, password, **extra_fields)



    objects = UserManager()

    class Meta:
        managed = False
        db_table = 'g5_member'