S2OJ/web/app/upgrade/6_user_info_v2/up.sql

5 lines
443 B
MySQL
Raw Permalink Normal View History

2022-10-19 13:59:16 +00:00
ALTER TABLE `user_info` ADD COLUMN `codeforces_handle` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
2022-10-19 14:16:10 +00:00
ALTER TABLE `user_info` ADD COLUMN `github` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
2022-10-20 00:45:23 +00:00
ALTER TABLE `user_info` ADD COLUMN `website` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
2022-10-20 02:02:53 +00:00
ALTER TABLE `user_info` ADD COLUMN `avatar_source` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'gravatar';