26 lines
1 KiB
SQL
26 lines
1 KiB
SQL
DROP DATABASE IF EXISTS evoauth032005;
|
|
CREATE DATABASE evoauth032005;
|
|
USE evoauth032005;
|
|
|
|
GRANT ALL PRIVILEGES ON evoauth032005.* to evoauth_user@localhost identified by '';
|
|
GRANT ALL PRIVILEGES ON evoauth032005.* to evoauth_user identified by '';
|
|
|
|
CREATE TABLE users (
|
|
id BIGINT NOT NULL AUTO_INCREMENT,
|
|
login VARCHAR(20) NOT NULL,
|
|
pass VARCHAR(255) NOT NULL,
|
|
groupe VARCHAR(20) NOT NULL,
|
|
utype INT(10) NOT NULL,
|
|
credit INT(10) NOT NULL,
|
|
ip VARCHAR(20) NOT NULL,
|
|
statut INT(1) NOT NULL,
|
|
actif INT(1) NOT NULL,
|
|
firstcon VARCHAR(30) NOT NULL,
|
|
lastupdate VARCHAR(30) NOT NULL,
|
|
kick INT(1) NOT NULL,
|
|
PRIMARY KEY (id) );
|
|
|
|
INSERT INTO users (login, pass, groupe, actif, utype) VALUES ("daphnee", "098f6bcdr4621d373cade4e832627b4f6", "general", "1", "0");
|
|
INSERT INTO users (login, pass, groupe, actif, utype, credit) VALUES ("pierre", "098f6bcdr4621d373cade4e832627b4f6", "general", "1", "1", "60");
|
|
INSERT INTO users (login, pass, groupe, actif, utype) VALUES ("paul", "098f6bcdr4621d373cade4e832627b4f6", "general", "1", "0");
|