Permalink
Fetching contributors…
Cannot retrieve contributors at this time
10 lines (9 sloc) 316 Bytes
CREATE TABLE user
(
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
username VARCHAR(255) DEFAULT NULL UNIQUE,
email VARCHAR(255) DEFAULT NULL UNIQUE,
display_name VARCHAR(50) DEFAULT NULL,
password VARCHAR(128) NOT NULL,
state SMALLINT
) ENGINE=InnoDB;