DROP TABLE IF EXISTS users; CREATE TABLE users ( userid TEXT PRIMARY KEY NOT NULL, username TEXT NOT NULL, password TEXT, views INT NOT NULL DEFAULT 0 );