13 lines
477 B
Text
13 lines
477 B
Text
|
# ログイン
|
||
|
|
psql -U suti7 -d dislocker
|
||
|
|
|
||
|
|
CREATE TABLE user
|
||
|
|
(user_id INTEGER PRIMARY KEY NOT NULL,
|
||
|
|
discord_id INTEGER NOT NULL,
|
||
|
|
discord_username VARCHAR(32) NOT NULL,
|
||
|
|
PRIMARY KEY (user_id));
|
||
|
|
|
||
|
|
CREATE TABLE user_list (user_id INTEGER NOT NULL, discord_username VARCHAR(32) NOT NULL, discord_userid INTEGER NOT NULL, PRIMARY KEY (user_id));
|
||
|
|
|
||
|
|
# テーブルを作る
|
||
|
|
CREATE TABLE web_auth (id SERIAL, username VARCHAR(10) NOT NULL, password VARCHAR(32) NOT NULL, PRIMARY KEY(id));
|