SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE IF NOT EXISTS Users( userid INTEGER NOT NULL PRIMARY KEY, friendlyname VARCHAR(50), emailaddress VARCHAR(320) NOT NULL, password VARCHAR(256) NOT NULL, admin INTEGER, lastlogin INTEGER(4) DEFUALT (strftime('%s','now')) ); CREATE TABLE IF NOT EXISTS Messages( id INTEGER NOT NULL PRIMARY KEY, message TEXT, userid INTEGER NOT NULL, created INTEGER(4) DEFAULT (strftime('%s','now')), archive INTEGER(1) DEFAULT 0 );