16 lines
439 B
MySQL
16 lines
439 B
MySQL
|
CREATE TABLE
|
||
|
|
master_pass (
|
||
|
|
user_id BIGINT UNSIGNED NOT NULL PRIMARY KEY,
|
||
|
|
salt BINARY(64) NOT NULL,
|
||
|
|
password_hash BINARY(64) NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE
|
||
|
|
account (
|
||
|
|
user_id BIGINT UNSIGNED NOT NULL,
|
||
|
|
name VARCHAR(255) NOT NULL,
|
||
|
|
salt BINARY(64) NOT NULL,
|
||
|
|
enc_login VARBINARY(256) NOT NULL,
|
||
|
|
enc_password VARBINARY(256) NOT NULL,
|
||
|
|
PRIMARY KEY (user_id, name)
|
||
|
|
);
|