/
germanubis
/
sqlx
Обзор
Документация
Войти
/
germanubis
/
sqlx
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
tests/mysql/setup.sql
32 строки
1 KB
Austin Bonander
chore(mysql): create test for passwordless auth (#3484) (#3505)
14 сен 2024, 21:51
Не верифицирован
14 сен 2024, 21:51
2f5ba71
Код
Авторство
О чём код?
-- https://github.com/prisma/database-schema-examples/tree/master/postgres/basic-twitter#basic-twitter CREATE TABLE tweet ( id BIGINT PRIMARY KEY AUTO_INCREMENT, created_at TIMESTAMP NOT NULL DEFAULT NOW(), text TEXT NOT NULL, owner_id BIGINT ); CREATE TABLE tweet_reply ( id BIGINT PRIMARY KEY AUTO_INCREMENT, tweet_id BIGINT NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT NOW(), text TEXT NOT NULL, owner_id BIGINT, CONSTRAINT tweet_id_fk FOREIGN KEY (tweet_id) REFERENCES tweet(id) ); CREATE TABLE products ( product_no INTEGER, name TEXT, price NUMERIC CHECK (price > 0) ); -- Create a user without a password to test passwordless auth. CREATE USER 'no_password'@'%'; -- The minimum privilege apparently needed to connect to a specific database. -- Granting no privileges, or just `GRANT USAGE`, gives an "access denied" error. -- https://github.com/launchbadge/sqlx/issues/3484#issuecomment-2350901546 GRANT SELECT ON sqlx.* TO 'no_password'@'%';