mirror of
https://github.com/YunoHost-Apps/rportd_ynh.git
synced 2024-09-03 20:16:15 +02:00
24 lines
658 B
SQL
24 lines
658 B
SQL
CREATE TABLE users (
|
|
username VARCHAR(150) NOT NULL,
|
|
password VARCHAR(255) NOT NULL,
|
|
token VARCHAR(36) DEFAULT NULL,
|
|
two_fa_send_to VARCHAR(150),
|
|
totp_secret VARCHAR(255) DEFAULT ''
|
|
);
|
|
|
|
CREATE UNIQUE INDEX main_username ON users (username);
|
|
|
|
CREATE TABLE groups (
|
|
username VARCHAR(150) NOT NULL,
|
|
`group` VARCHAR(150) NOT NULL
|
|
);
|
|
|
|
CREATE UNIQUE INDEX main_username_group ON groups (username,`group`);
|
|
|
|
INSERT INTO users VALUES('__ADMIN__','__PASSWORD_HASH__',null,'__ADMIN_MAIL__','');
|
|
INSERT INTO groups VALUES('__ADMIN__','Administrators');
|
|
|
|
CREATE TABLE `clients_auth` (
|
|
`id` varchar(100) PRIMARY KEY,
|
|
`password` varchar(100) NOT NULL
|
|
);
|