mirror of
https://github.com/processone/ejabberd
synced 2025-10-03 17:59:31 +02:00
10 lines
338 B
SQL
10 lines
338 B
SQL
CREATE TABLE "users" (
|
|
username text NOT NULL,
|
|
server_host text NOT NULL,
|
|
"password" text NOT NULL,
|
|
serverkey text NOT NULL DEFAULT '',
|
|
salt text NOT NULL DEFAULT '',
|
|
iterationcount integer NOT NULL DEFAULT 0,
|
|
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (server_host, username)
|
|
);
|