class nx_fmts(models.Model):
    date = models.DateTimeField('exception date')
    ip_client =  models.TextField()
    server = models.TextField()
    uri = models.TextField()
    total_processed = models.IntegerField()
    total_blocked = models.IntegerField()
    couples = models.ManyToManyField(nx_couples)

    def __unicode__(self):
        return self.date+self.ip_client+self.total_processed+self.total_blocked

    class Meta:
        ordering = ('date','ip_client','uri',
                    'total_processed', 'total_blocked')


class nx_couples(models.Model):
    zone_raw = models.CharField(max_length=50)
    zone = models.CharField(max_length=50)
    id = models.IntegerField()
    var_name = models.TextField()
    in_name = models.BooleanField()
    in_file = models.BooleanField()
    fmts = models.ManyToManyField(nx_fmts)

    def __unicode__(self):
        return self.zone+self.id+self.var_name

    class Meta:
        ordering = ('id','zone_raw','var_name')