suVJVAz5

1CREATE TABLE IF NOT EXISTS `user`
2(
3  `id`         INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
4  `role_id`    INT(10) UNSIGNED            NOT NULL,
5  `username`   VARCHAR(255)                NOT NULL,
6  `password`   VARCHAR(255)                NOT NULL,
7  `registered` DATE                        NOT NULL,
8  `root`       TINYINT DEFAULT 0           NOT NULL,
9  `active`     TINYINT DEFAULT 1           NOT NULL
10) ENGINE = INNODB;