Hi i'm following the code in pycharm with sqlite and everything works i can create a table i can look at it but the unique part doesn't work.

This is the students class

From peewee import everything

from peewee import *

Make a slqlite connection and creates the database if it doesn't excist

db = SqliteDatabase('students.db')

Models in peewee are classes

class Student(Model): username = CharField(max_length=255, unique=True) points = IntegerField(default=0)

# Tell the model to witch database this belong to!
class Meta:
    database = db

students = [ {'username':'BrechtPhilips', 'points':7000}, {'username':'SanneDeSmedt', 'points':100}, {'username':'King', 'points':10000}, {'username':'Liesse', 'points':1}, {'username':'HannePhilips', 'points':2980} ]

def add_students(): for student in students: try: Student.create(username=student['username'], points=student['points']) except IntegrityError: student_record = Student.get(username=student['username']) student_record.points = student['points'] student_record.save()

a common pattern for making code only run when the script is run

and not when it's imported

if name == 'main': db.connect() db.create_table(Student,safe=True) add_students()

But when i look at my database how it's created i get this sql statement: CREATE TABLE "student" ("id" INTEGER NOT NULL PRIMARY KEY, "username" VARCHAR(255) NOT NULL, "points" INTEGER NOT NULL)

Does anybody have ideas what i'm doing wrong?