/
bear
/
opencorpora
Обзор
Документация
Войти
/
bear
/
opencorpora
Код
Запросы
0
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
export/database/copy_nulled_tables.sql
47 строк
993 B
Dmitry Granovsky
maintain prod-identical structure in dev db export, also fix dos endings
13 апр 2019, 12:30
13 апр 2019, 12:30
7718e32
Код
Авторство
О чём код?
SET NAMES utf8; -- table `users` --> `users_for_selective_backup` DROP TABLE `users_for_selective_backup`; CREATE TABLE `users_for_selective_backup` LIKE `users`; INSERT INTO `users_for_selective_backup` ( `user_id`, `user_name`, `user_passwd`, `user_email`, `user_reg`, `user_shown_name`, `user_team`, `user_level`, `user_shown_level`, `user_rating10` ) SELECT `user_id`, `user_name`, '' AS `user_passwd`, '' AS `user_email`, `user_reg`, `user_shown_name`, `user_team`, `user_level`, `user_shown_level`, `user_rating10` FROM `users` WHERE 1 = 1; -- table `user_tokens` --> `user_tokens_for_selective_backup` DROP TABLE `user_tokens_for_selective_backup`; CREATE TABLE `user_tokens_for_selective_backup` LIKE `user_tokens`; INSERT INTO `user_tokens_for_selective_backup` ( `user_id`, `token`, `timestamp` ) SELECT `user_id`, 0 AS `token`, `timestamp` FROM `user_tokens` WHERE 1 = 1;